Pandas to nested json

Question

My Pandas df is like:

RollCall    Physics Chemisty    Maths
1   20  30  25
2   25  30  30
3   15  12  35
4   20  15  30

I wish to convert this to a json like:

{"StudentDetails": {
"1":{"Physics":20,"Chemisty":30,"Maths":25},
"2":{"Physics":25,"Chemisty":30,"Maths":30},
"3":{"Physics":15,"Chemisty":12,"Maths":35},
}}

This is what I am doing and not getting the desired output:

d = {}
d['StudentDetails'] = df.to_json(orient='index')

Anyway to get desired output?

BENY · Accepted Answer · 2022-07-05 17:36:50Z

2

In your case do

df['RollCall'] = df['RollCall'].astype(str)

d = {}
d['StudentDetails'] = df.set_index('RollCall').to_dict('index')
d
Out[366]: 
{'StudentDetails': {'1': {'Physics': 20, 'Chemisty': 30, 'Maths': 25},
  '2': {'Physics': 25, 'Chemisty': 30, 'Maths': 30},
  '3': {'Physics': 15, 'Chemisty': 12, 'Maths': 35},
  '4': {'Physics': 20, 'Chemisty': 15, 'Maths': 30}}}

edited Jul 5, 2022 at 17:36

answered Jul 5, 2022 at 17:29

BENY

324k22 gold badges176 silver badges250 bronze badges

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

1 Comment

BENY Over a year ago

@Anant check the update

Collectives™ on Stack Overflow

Pandas to nested json

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related