Handle json using Pandas json_normalize

Question

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

user17242583 · Accepted Answer · 2021-11-20 15:19:39Z

2

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

answered Nov 20, 2021 at 15:19

user17242583

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Handle json using Pandas json_normalize

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related