Python - Splitting multiple values in list to different rows

Asked Dec 03 '18 at 13:25

Active Dec 03 '18 at 13:30

Viewed 51 times

I have my dataset as below:

bill_id, prodname
101,['apples','oranges']
102,['bananas','oranges']
103,['apples']

I would like to convert this to:

101,apples
101,oranges
101,bananas
101,oranges
101,apples

Could anyone assist on how I could split these values into multiple rows for the same bill_id. Thanks

asked Dec 03 '18 at 13:25

dark horse

1

Do you want all 101 or [101, 101, 102, 102, 103]? – Dani Mesejo Dec 03 '18 at 13:32
@DanielMesejo I would want to do this for all elements in the Dataframe – dark horse Dec 03 '18 at 13:36
So you want to set bill_id all to 101? – Dani Mesejo Dec 03 '18 at 13:37
@DanielMesejo Nope just the values in the Dataframe to be converted.. – dark horse Dec 03 '18 at 13:37
Converted to what? In your output example all the values of bill_id are set to 101 – Dani Mesejo Dec 03 '18 at 13:38

0 Answers0