CODEWITHSUNDEEP
pythonpandasdataframenumpyexplode
Mustapha Kerrou
Mustapha Kerrou

Reputation: 17

how to explode a nested dictionary from a dataframe column

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 enter image description here

this is what I'm trying to achieve enter image description here

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

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

Upvotes: 0

Views: 947

Answers (1)

Timeless
Timeless

Reputation: 37757

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())

Upvotes: 1

Related Questions