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 vote162 views1 answer
Backend not found Request Method: GET Request URL: http://127.0.0.1:8000/oauth/login/google-oauth2/ Raised by: social_django.views.au
Python
0 vote170 views1 answer
Pandas plot heatmap
Python
1 vote193 views1 answer
Convert url to base64 image py
Python
12 votes174 views2 answers
Filtering a list
Python
0 vote187 views1 answer
If function has no argument python
Python
0 vote200 views1 answer
Convert 2.9k to 2900 in python
Python
0 vote170 views1 answer
Numpy find mean of array
Python
29 votes172 views5 answers
Python try except: print error
Python
184 votes277 views6 answers
Update pip python
Python
0 vote210 views1 answer
Draw a marker in basemap python
Python