0

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

Karl Knechtel
  • 62,466
  • 11
  • 102
  • 153
Bharat Sharma
  • 1,081
  • 3
  • 11
  • 23

0 Answers0