Convert dataframe to json

Pandas to json

>>> df.to_json(orient='records')
'[{"col 1":"a","col 2":"b"},{"col 1":"c","col 2":"d"}]'

Source: pandas.pydata.org

Convert dataframe to json

dictionary_varibale = [ 
    dict([
        (colname, row[i]) 
        for i,colname in enumerate(df.columns)
    ])
    for row in df.values
]
print(json.dumps(dictionary_varibale))

Convert json to dataframe

dataframe = pd.DataFrame.from_dict(a_json, orient="index")

Source: kite.com

Similar codes

50 votes150 views1 answer
How to find item in list python without indexnig
Python
4 votes123 views1 answer
Get number of missing values dataframe
Python
0 vote141 views7 answers
Convert java code to python online
Python
22 votes131 views4 answers
How to write string in python
Python
0 vote134 views1 answer
Fibonacci sequence in python using a for loop
Python
1 vote111 views1 answer
Add seconds to datetime python
Python
0 vote140 views2 answers
Get data from dynamodb using boto3
Python
0 vote123 views1 answer
Remove grid from 3d plots
Python
0 vote117 views1 answer
Shotgun filter any
Python
5 votes114 views2 answers
Check if dataframe contains infinity
Python