New rows based on a string - Pandas. python

Question

I have this pandas df

show_id     type           title            director        cast    

  s1        Movie      Duck the Halls      Dave Wasson    Chris Diamantopoulos, Tony Anselmo, 
                                                           Tress MacNeille, Bill Farmer,

I need to be able to break down the 'cast'' field in such a way that it is in several rows Example:

show_id     type           title            director        cast    

  s1        Movie      Duck the Halls      Dave Wasson    Chris Diamantopoulos
  s1        Movie      Duck the Halls      Dave Wasson    Tony Anselmo
  s1        Movie      Duck the Halls      Dave Wasson    Tress MacNeille
  s1        Movie      Duck the Halls      Dave Wasson    Bill Farmer

I understand that I should do it with pandas, but it is very complicated, can you help me?

Onyambu · Accepted Answer · 2022-05-30 20:31:17Z

1

You can use spit and explode:

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

answered May 30, 2022 at 20:31

Onyambu

80.3k3 gold badges29 silver badges65 bronze badges

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

Comments

mozway · Accepted Answer · 2022-05-30 20:34:06Z

0

You can use:

out = (df.drop(columns='cast')
         .join(df['cast'].str.split(',')
                 .explode()
       )

answered May 30, 2022 at 20:34

mozway

267k13 gold badges56 silver badges106 bronze badges

Collectives™ on Stack Overflow

New rows based on a string - Pandas. python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related