Explode dictionary pandas

arxivdf.reset_index(inplace=True) # didn't drop the index coz I will need it later
tmp = arxivdf.explode('data') # 'data' is the column that has a list of dictionaries
dict2df = tmp['data'].apply(pd.Series)[['category', 'link', 'summary', 'title']] # the column passed are keys, 
arxivdf = pd.concat((tmp,dict2df),axis=1) # concatenate to have everything in on df

Similar codes

4 votes215 views1 answer
Tkinter text in canvas
Python
3 votes190 views4 answers
Drop na dataframe
Python
0 vote207 views1 answer
Streamlit cheatsheet
Python
5 votes269 views3 answers
Multiple variables in for loop python
Python
3 votes244 views1 answer
Frozen
Python
0 vote201 views1 answer
Python run bat in new cmd window
Python
1 vote257 views2 answers
Python frame in a frame
Python
0 vote201 views1 answer
Pandas df trim columns if too much missing data
Python
0 vote208 views1 answer
Split by backslash python
Python
0 vote210 views1 answer
Print lowercase in python
Python