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

1 vote164 views1 answer
How shorten with enter long script python
Python
0 vote147 views1 answer
Console code page (437) differs from Windows code page (1252) 8-bit characters might not work correctly
Python
0 vote164 views1 answer
Python args description multiple lines
Python
0 vote163 views1 answer
Markers are not visible on line plot
Python
0 vote183 views1 answer
Show battery of my laptop python
Python
1 vote164 views1 answer
Title tikinter
Python
4 votes177 views3 answers
Generate random list of number py
Python
0 vote163 views1 answer
Increase pie chart size python
Python
0 vote166 views4 answers
Ip address regex
Python
1 vote165 views1 answer
Formula for compounding interest in python
Python