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

0 vote152 views2 answers
Extract email address using expression in django
Python Django
1 vote142 views1 answer
How to redirect to another page in django after login
Python Django
21 votes114 views1 answer
How to plot a graph using matplotlib
Python
0 vote151 views1 answer
How to send file in django response
Python Django
2 votes109 views3 answers
Torch.stack example
Python
9 votes131 views4 answers
Change the default python version mac
Python
0 vote124 views1 answer
Django pull from Google Sheets
Python
4 votes113 views1 answer
Pandas find inf values
Python
0 vote110 views1 answer
How return the data timestamp after some days in python
Python
2 votes113 views1 answer
Discord.py add role on member join
Python