I have json like this .
{'item1': {'Jun 2019': '0',
'Sep 2019': '0',
'Dec 2019': '0',
'Mar 2020': '0',
'Jun 2020': '0'},
'item2': {'Jun 2019': '736',
'Sep 2019': '626',
'Dec 2019': '827',
'Mar 2020': '614',
'Jun 2020': '475}}
I want to covert this to pandas dataframe as shown below.
Jun 2019 Sep 2019 Dec 2019 Mar 2020 Jun 2020
item1 0 0 0 0 0
item2 736 626 827 614 475
Is this possible with pd.json_normalize
? I would like to avoid hard coding any keys.
Thanks in advance