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 vote228 views2 answers
Python api with live ercot real time prices
Python
0 vote266 views1 answer
Change a coolumn datatype in pandas
Python
1 vote202 views2 answers
Get definition of word python
Python
6 votes193 views3 answers
Pandas.core.series.series to dataframe
Python
1 vote212 views1 answer
File handling modes in python
Python
1 vote158 views1 answer
Input array in python
Python
21 votes210 views5 answers
Base64 encode python
Python
0 vote214 views1 answer
Gui button in tkinter color
Python
3 votes206 views1 answer
Unimport library python
Python
1 vote206 views1 answer
Python 3 tkinter treeview example
Python