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 vote261 views1 answer
Python selenium extensions
Python
0 vote270 views1 answer
Gui radio button python
Python
16 votes282 views6 answers
Joins in pandas
Python
3 votes288 views2 answers
How to install terminal in atom
Python
2 votes286 views1 answer
Grams in kg
Python
0 vote290 views2 answers
Python - Comment jouer le fichier Mp3
Python
0 vote269 views1 answer
Skewness removal
Python
0 vote263 views1 answer
Pandas dataframe display cell size
Python
1 vote251 views1 answer
Difference between 2 timestamps pandas
Python
0 vote284 views1 answer
Write multiple DataFrames to Excel files
Python