Handle json using Pandas json_normalize-CodePudding

My goal is to convert a dictionary to a Pandas dataframe using only json_normalize.

What I have:

d = {'date': '20-NOV-2021', 'sector': {'South': 8, 'Est': 9, 'North': 12, 'Ouest': 9}}
pd.json_normalize(d)

       date  sector.South  sector.Est  sector.North  sector.Ouest
20-NOV-2021             8           9            12             9

What I'm looking for:

sector   value          date
South    8       20-NOV-2021
Est      9       20-NOV-2021
North    12      20-NOV-2021
Ouest    9       20-NOV-2021

CodePudding user response：

I think you need to convert your sector data into a slightly different format:

d['sector'] = [{'sector': k, 'value': v} for k, v in dd['sector'].items()]
df = pd.json_normalize(d, "sector", "date")

Output:

>>> df
  sector  value         date
0  South      8  20-NOV-2021
1    Est      9  20-NOV-2021
2  North     12  20-NOV-2021
3  Ouest      9  20-NOV-2021