how to explode a nested dictionary from a dataframe column-CodePudding

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

CodePudding user response：

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