How to convert CSV to multi level nested JSON in Python

Question

How to convert CSV to nested JSON in Python This is related to something like this.

I want to convert a flat dataframe file to Nested JSON format:

I have a csv (sales_2020) file in the following format:

and i want a json like this:

i tried the link above and was able to add 1 level using this:

import pandas as pd

df = pd.read_csv('your_file.csv')

df['sales_2020'] = df[['computer','mobile']].to_dict('records')

out = df[['a','Sales_2020']].to_json(orient='records', indent=4)

But i was unable to add 1 more level to it..i.e sales for a specific month..I tried this below solution but doesnt work..

df['jan']['sales_2020'] =df[['computer','mobile']].to_dict('records')

please help me out

Ynjxsjmh · Accepted Answer · 2022-05-13 04:55:14Z

1

I guess what you want is orient='index'

df['sales_2020'] = df[['computer','mobile']].to_dict('records')
out = df.set_index('Month')[['sales_2020']].to_json(orient='index', indent=4)

{
    "jan":{
        "sales_2020":{
            "computer":10,
            "mobile":5
        }
    },
    "feb":{
        "sales_2020":{
            "computer":8,
            "mobile":2
        }
    },
    "march":{
        "sales_2020":{
            "computer":6,
            "mobile":12
        }
    }
}

answered May 13, 2022 at 4:55

Ynjxsjmh

30.3k7 gold badges43 silver badges64 bronze badges

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

Collectives™ on Stack Overflow

How to convert CSV to multi level nested JSON in Python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related