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

2 votes135 views1 answer
Clear_output jupyter
Python
0 vote140 views1 answer
Python kivy bind
Python
0 vote147 views1 answer
'datetime.date' object has no attribute 'split'
Python
3 votes151 views1 answer
Python docstring
Python
0 vote144 views1 answer
Read stripped lines from a file python
Python
0 vote136 views1 answer
Array Creation in Numpy
Python
0 vote166 views1 answer
Flask_uploads.exceptions.UploadNotAllowed
Python Flask
0 vote144 views1 answer
Python look for image on screen
Python
1 vote151 views1 answer
Module 'tensorflow_core.compat.v1.random' has no attribute 'set_seed'
Python
5 votes159 views2 answers
How to get unix timestamp in python
Python