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

2 votes290 views1 answer
Database default code in settings django
Python
0 vote336 views1 answer
Django.db.utils.IntegrityError: column contains null values
Python Django
1 vote272 views1 answer
Cv2 draw box
Python
0 vote256 views1 answer
Pandas astype str still object
Python
0 vote267 views1 answer
Image loader RGB transform
Python
1 vote255 views1 answer
File to lowercase python
Python
5 votes229 views1 answer
Python multi split
Python
0 vote275 views1 answer
Fibonacci series list comphrehension in python
Python
5 votes249 views1 answer
Python how to skip iteration
Python
3 votes323 views5 answers
India
Python