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 vote162 views1 answer
How to shift the x axis matplot lib
Python
0 vote214 views1 answer
Eia api python
Python
7 votes239 views2 answers
Show image in python
Python
0 vote203 views1 answer
Django BruteBuster error failed attempts
Python
0 vote203 views1 answer
Brython implemantation
Python
0 vote225 views2 answers
Flask socket io
Python Flask
0 vote189 views1 answer
Cvhaardetectobjects
Python
3 votes203 views1 answer
Calculate percentile pandas dataframe
Python
0 vote199 views1 answer
How to make code only go once python
Python
0 vote230 views1 answer
Python string: .split()
Python