Convert A Dictionary Of Dictionary Into A Row Wise Dataframe In Pandas

I have dictionary as shown below d1: {'teachers': 49, 'students': 289, 'R': 3.7, 'holidays': 165, 'E': {'from': '2020-02-29T20:00:00.000Z', 'to': '2020

Solution 1:

You can use json_normalize and then tranpose the dataframe:

d = {'teachers': 49,
      'students': 289,
      'R': 3.7,
      'holidays': 165,
      'Em': {'from': '2020-02-29T20:00:00.000Z', 'to': '2020-03-20T20:00:00.000Z',
                  'F': 3, 'C': 2},
      'OS':18,
      'sC': {'from': '2020-03-31T20:00:00.000Z', 'to': '2020-05-29T20:00:00.000Z',
                  'F': 25, 'C': 31}}


df=pd.json_normalize(d, sep='_').T.reset_index().rename(columns={'index':'Params',0:'Value'})

Output:

dfParamsValueteachers49students289R3.7holidays165OS18Em_from2020-02-29T20:00:00.000ZEm_to2020-03-20T20:00:00.000ZEm_F3Em_C2sC_from2020-03-31T20:00:00.000ZsC_to2020-05-29T20:00:00.000ZsC_F25sC_C31