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

2 votes217 views1 answer
Check corently installed epython version
Python
0 vote173 views1 answer
Erase % sign in row pandas
Python
4 votes274 views1 answer
Python django shell command
Python Django
0 vote189 views2 answers
Django query string route
Python
31 votes263 views6 answers
Python strip whitespace
Python
1 vote178 views1 answer
Python import ndjson data
Python
1 vote202 views1 answer
How to reference a file in python
Python
2 votes195 views1 answer
Dice rolling simulator python
Python
0 vote184 views1 answer
Quality Control in python
Python
0 vote201 views1 answer
Matplotlib dateformatter x axis
Python