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

23 votes283 views3 answers
Install django rest_framework
Python Django
0 vote172 views1 answer
Matplotlib remove drawn text
Python
0 vote187 views1 answer
How to put a image in flask
Python
0 vote186 views1 answer
Pytorch calculate mse mae
Python
0 vote208 views1 answer
Get window coordinates selenium
Python
0 vote188 views1 answer
Django clear _pycache_ command
Python
0 vote187 views1 answer
Datetime time set seconds
Python
0 vote205 views1 answer
Linux site-packages location
Python
10 votes191 views3 answers
Execute linux command in python
Python
0 vote180 views1 answer
Python open file same folder
Python