how to explode a nested dictionary from a dataframe column

Question

I'm trying to explode the genres column into a separate data frame with (id, name) as columns.

this is the data frame I'm working with

this is what I'm trying to achieve

i havent been able to find a solution on my own what i have tried is to explode the genre

genres = df['genres'].explode()

Try genres = pd.DataFrame(df.genres.explode().values.tolist()) — Emma
– Emma, Commented Jan 4, 2023 at 21:46

Timeless · Accepted Answer · 2023-01-04 21:00:22Z

1

You can use pandas.Series.explode with pandas.DataFrame constructor :

#if need to evalute the column as lists of dict
#from ast import literal_eval
#df["genres"] = df["genres"].apply(literal_eval)

genres = pd.DataFrame(df.pop("genres").explode().tolist())

answered Jan 4, 2023 at 21:00

Timeless

38.3k6 gold badges33 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

how to explode a nested dictionary from a dataframe column

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