Pandas to create new rows from a cell that has multiple values in python

Question

I've seen some similar problems on stack, but not exactly like this. I appreciate if you could share a way to turn df into df2.

df = pd.DataFrame({'zips': ['11229 11226 11225', '90291 90293 90292'],
                  'lat': [40.6943, 34.1139],
                  'lng': [-73.9249, -118.4068]})


df2 = pd.DataFrame({'zips': [11229, 11226, 11225, 90291, 90293, 90292],
                  'lat': [40.6943, 40.6943, 40.6943, 34.1139, 34.1139, 34.1139],
                  'lng': [-73.9249, -73.9249, -73.9249, -118.4068, -118.4068, -118.4068]})```

Thanks!

split and then explode: df.assign(zips = df.zips.str.split(' ')).explode('zips') — akuiper
– akuiper, Commented May 12, 2021 at 0:25

ThePyGuy · Accepted Answer · 2021-05-12 00:28:41Z

2

You can first split the values in zips column on space which will give a list, then just use explode

df['zips'] = df['zips'].str.split()
df.explode('zips')

OUTPUT:

    zips      lat       lng
0  11229  40.6943  -73.9249
1  11226  40.6943  -73.9249
2  11225  40.6943  -73.9249
3  90291  34.1139 -118.4068
4  90293  34.1139 -118.4068
5  90292  34.1139 -118.4068

You can further change the data type of zips column to integer if you wish to by type casting

df['zips'] = df['zips'].astype(int)

answered May 12, 2021 at 0:28

ThePyGuy

18.5k5 gold badges24 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pandas to create new rows from a cell that has multiple values in python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related