Pandas explode with non-list column

Question

I have Dataframe contain locations by string and I want to explode using them

For example, df:

country	location	value
Canda	USA,Costa Rica,	3
Italy	Germany,France,Spain	2
Russia	Israel,	1

my df :

country	location	value
Canda	USA	3
Canda	Costa Rica	3
Italy	Germany	2
Italy	France	2
Italy	Spain	2
Russia	Israel	1

I have a lot more then only one column such as value and I want to make sure they are all duplicated

Refer to : https://stackoverflow.com/a/57122617/9840637 – anky Jun 22 '21 at 18:29 — anky, Jun 22 '21 at 18:29

score 1 · Answer 1 · answered Jun 22 '21 at 18:28

1

Split and explode

df['location'] = df.location.str.rstrip(',').str.split(',')
df.explode('location')

Output

  country    location  value
0   Canda         USA      3
0   Canda  Costa Rica      3
1   Italy     Germany      2
1   Italy      France      2
1   Italy       Spain      2
2  Russia      Israel      1

answered Jun 22 '21 at 18:28

Vishnudev

9,498
1
15
50

Thanks, I'm waiting the 10 min to give you the answer certificate – Jun 22 '21 at 18:33

Pandas explode with non-list column

1 Answers1