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 votes273 views1 answer
Finding a substring between 2 strings
Python
0 vote247 views1 answer
Cube python
Python
0 vote242 views1 answer
Convert 1 digit to 2 digit python
Python
4 votes254 views4 answers
Pandas groupby sum
Python
0 vote232 views1 answer
Timeout python
Python
2 votes229 views1 answer
Python how to unnest a nested list
Python
0 vote229 views1 answer
Pandas to latex table width pylatex
Python
0 vote225 views1 answer
Sns how to change color if negative or positive
Python
0 vote244 views1 answer
Sqlite3 python parameterized query insert into
Python
0 vote212 views9 answers
How to form a list from a file in python
Python