0

my input is

category      destination          type        value
voice         USA, Canada, India   individual    5
Voice         USA, Canada, India   individual    7

output should be

category      destination          type        value
voice         USA                  individual    5
Voice         Canada               individual    5
Voice         India                individual    5
Voice         USA                  individual    7
Voice         Canada               individual    7
Voice         India                individual    7

i tried with explode function but its not working.

jared
  • 4,165
  • 1
  • 8
  • 31
tez
  • 9
  • 2
  • Format your data to make this readable (ie, using the | between columns to make this display as a table). Also show your coded attempt where you tried using the explode function. Explode works well for Array column type. – Isolated Aug 01 '23 at 18:54
  • You had [tag:sql], [tag:pandas], and [tag:numpy], but I don't see any code that includes these packages. In fact, I don't see any code at all... – jared Aug 01 '23 at 18:59

0 Answers0