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

1 vote303 views1 answer
Python for/else
Python
2 votes300 views1 answer
Serializers.py include all fields
Python
0 vote296 views1 answer
Row to column python numpy
Python
1 vote316 views1 answer
Python reference script directory
Python
0 vote305 views1 answer
Matploltib increase resolution
Python
1 vote323 views1 answer
Python parallel list comprehension
Python
1 vote366 views1 answer
Tkinter boilerplate
Python
1 vote332 views1 answer
Url decode python
Python
0 vote324 views1 answer
Google sheet api python
Python
0 vote376 views1 answer
How to convert a matrix string back to a matrix python
Python