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 vote111 views1 answer
File.write must be string python
Python
0 vote87 views1 answer
Pandas columns case when equivalent
Python
0 vote106 views1 answer
Discord py fetch channel by id
Python
0 vote97 views1 answer
Give colour to the font in python email message
Python
0 vote92 views1 answer
Writing Bytes to a File in python
Python
0 vote98 views1 answer
Intellij python
Python
0 vote91 views1 answer
.replace pandas in for loop
Python
7 votes94 views3 answers
How to update list in python
Python
1 vote96 views1 answer
Django class based views ListView
Python
2 votes104 views2 answers
Python isdigit negative
Python