explode pandas data frame column of object type to string and into different rows

Question

i have a data frame that is built like this :

    data = {'name':["['jem','nate','dory']", "['dave','roshy','nomy','pika']", "['kosh','liam']"], 'depart' : ['a','b','c']}

    name                               depart
0   ['jem','nate','dory']              a
1   ['dave','roshy','nomy','pika']     b
2   ['kosh','liam']                    c

I want to explode this into something like this

name    depart
jem     a
nate    a
dory    a
dave    b
roshy   b
normy   b
pika    b
kosh    c
liam    c

TIA for the help

Anurag Dabas · Accepted Answer · 2021-07-14 12:13:11Z

1

Try with pd.eval():

df['name']=pd.eval(df['name'])
df=df.explode('name',ignore_index=True)

OR

from ast import literal_eval


df['name']=df['name'].map(literal_eval)
df=df.explode('name',ignore_index=True)

Now If you print df you will get desired output

answered Jul 14, 2021 at 12:13

Anurag Dabas

24.3k9 gold badges25 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

explode pandas data frame column of object type to string and into different rows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related