how to convert pandas dataframe into nested json

Question

This is the datframe.

dataFrame =pd.DataFrame(['yes',10,'NaN',200703727.0,2141219]).T
dataFrame.columns=["a",'B','C','D','E']

DataFrame-->>

a   B   C   D   E
0   yes 10  NaN 2.00704e+08 2141219

and I want to convert this dataframe into nested JSON n rows the numbers of rows could be million in datframe.

json output I need

{   "E":2141219,
    "AA":[  {name:'a',type:'yes'},
            {name:'B',type:'10'},
            {name:'C',type:'NaN'},
            {name:'D',type:'200703727.0'}
        ]
}

I have to add name and type. Please help me to solve it.

That's just for one row, what should be the output for a dataframe with more than one row? Also, what you are asking for is a custom `JSON` which is not directly possible with what pandas offer, so you need to take a look at `json` module in python, and convert each row manually. You can use `dataframe.apply` then convert each row to the required json format. — ThePyGuy, Aug 03 '21 at 19:17

MundaneHassan · Answer 1 · 2021-08-03T19:09:36.500

0

You're gonna need to create a dictionary, or a list and then convert it to json

import json
dictionary = df1.to_dict(what you want to convert here)
json_1 = json.dumps

edited Aug 03 '21 at 19:09

answered Aug 03 '21 at 19:08

MundaneHassan

150
9

What did you write in the parentheses – MundaneHassan Aug 03 '21 at 19:10
so it can have multiple dictionaries. – Naveen Rishishwar Aug 03 '21 at 19:13
I don't understand you, can you tell me what your wrote after df1.to_dict? – MundaneHassan Aug 03 '21 at 19:14
I only mentioned the orientation of json. – Naveen Rishishwar Aug 03 '21 at 19:18
Did you put orient= before it? and it needs to be in quotation marks – MundaneHassan Aug 03 '21 at 19:19

score 0 · Answer 2 · answered Aug 03 '21 at 19:14

0

Have you tried to_json?

Also checkout:

answered Aug 03 '21 at 19:14

af3ld

782
8
30

how to convert pandas dataframe into nested json

2 Answers2