Replicate specific rows and separate str column values pandas

Question

I have the following dataframe

index city              pop
1     London           1000
2     Buenos Aires     2054
3     New York         34544
4     Paris-Madrid     34343
5     Barcelona-Lagos  64544

What I expect to do:

index city              pop
1     London           1000
2     Buenos Aires     2054
3     New York         34544
4     Paris            34343
5     Madrid           34343
6     Barcelona        64544  
7     Lagos            64544

How can I do that?

score 2 · Accepted Answer · answered Jul 06 '20 at 22:47

2

split + explode

df=df.assign(city=df.city.str.split('-')).explode('city').reset_index(drop=True)
   index         city    pop
0      1       London   1000
1      2  BuenosAires   2054
2      3      NewYork  34544
3      4        Paris  34343
4      4       Madrid  34343
5      5    Barcelona  64544
6      5        Lagos  64544

answered Jul 06 '20 at 22:47

BENY

317,841
20
164
234

Worked perfectly. Thank you! Edit: What is "drop=True" on reset_index for? – jimmy Jul 06 '20 at 22:58
@Guerra if not add , it will add the index as column in you dataframe – BENY Jul 06 '20 at 23:03

Replicate specific rows and separate str column values pandas

1 Answers1