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

4 votes213 views4 answers
Whatsapp api
Python
0 vote157 views1 answer
How to use with statementin python 2.4
Python
0 vote143 views1 answer
Python calculator file size to megabytes
Python
0 vote152 views1 answer
Random with probability python
Python
0 vote151 views1 answer
Lower case of string
Python
0 vote159 views1 answer
Python requests with login
Python
0 vote149 views1 answer
Draw pixel by pixel python
Python
0 vote153 views1 answer
Pyqt line edit mouse position change
Python
0 vote149 views1 answer
Numpy array [-1]
Python
0 vote145 views1 answer
Raspberry pi push button function control python
Python