create multiple rows if a column has more than one value in a dataframe

Question

I have a df like below :-

import pandas as pd 
  
# intialise data of lists. 
data = {'cust':['fnwp', 'utp'], 'events':[['abhi','ashu'],'abhi']} 
  
# Create DataFrame 
df = pd.DataFrame(data) 
  
# Print the output. 
df

My expected outcome is :-

IoaTzimas · Accepted Answer · 2020-12-01 00:33:51Z

2

You can use pandas.explode() function:

>>> df.explode('events').reset_index(drop=True)

   cust events
0  fnwp   abhi
1  fnwp   ashu
2   utp   abhi

answered Dec 1, 2020 at 0:33

IoaTzimas

10.7k2 gold badges15 silver badges32 bronze badges

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

3 Comments

abhi Over a year ago

The solution works on the df i have provided but its not working on my df which I am having. Do you have any clue why?

IoaTzimas Over a year ago

What is the result-error when you try it to your df?

abhi Over a year ago

nevermind I got it working actually i did some string operation and that's why it was not working! Thanks a lot!

Collectives™ on Stack Overflow

create multiple rows if a column has more than one value in a dataframe

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related