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

33 votes182 views5 answers
Python exit program
Python
14 votes184 views5 answers
How to read a excel file in python
Python
0 vote136 views1 answer
Pandas loop through unique values
Python
4 votes183 views2 answers
Flask get variable from url
Python
1 vote222 views1 answer
Add year to id django
Python Django
1 vote183 views2 answers
Subtract from dataframe column
Python
6 votes180 views1 answer
Comibataion of two list
Python
1 vote188 views1 answer
How to set the location on a pygame window
Python
0 vote216 views1 answer
Django jinja else if template tags
Python
36 votes186 views4 answers
Drop multiple columns pandas
Python