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

12 votes242 views5 answers
Python turtle documentation
Python
1 vote221 views2 answers
Simple flask hello world
Python
0 vote207 views1 answer
Hazm
Python
6 votes214 views2 answers
How to append two numpy arrays
Python
0 vote200 views1 answer
''' python '''
Python
0 vote305 views1 answer
Flask request file push request(uploadedfile= request.file) uploadedfile.read()
Python Flask
2 votes237 views2 answers
Cv2 add text
Python
10 votes214 views4 answers
How to know if python is 64 or 32 bit
Python
2 votes234 views5 answers
Swap keys and values in dictionary python
Python
3 votes211 views1 answer
Replace "-" for nan in dataframe
Python