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

0 vote318 views1 answer
Open google chrome from python
Python
0 vote340 views1 answer
Matplotlib savefig cutting off graph
Python
2 votes271 views1 answer
Dataframe to list
Python
0 vote334 views1 answer
Pyplot define plotsize
Python
0 vote278 views1 answer
How to extract keys from dictreader python
Python
0 vote358 views1 answer
Non venomous snakes
Python
0 vote325 views1 answer
Test register user mismatched passwords
Python
0 vote336 views1 answer
Decode html python
Python
0 vote334 views1 answer
Comparison of two csv file and output with differences?
Python
0 vote321 views1 answer
Custom auth django channels
Python