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 vote126 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 vote126 views1 answer
No default language could be detected for django app
Python
1 vote138 views1 answer
Shutil move overwrite
Python
12 votes153 views1 answer
Append a line to a text file python
Python
0 vote95 views2 answers
Python del list
Python
0 vote148 views1 answer
Bash python csv to json
Python
2 votes156 views1 answer
Make a script run itself again python
Python
5 votes136 views2 answers
Openpyxl read excel
Python
18 votes178 views3 answers
Export flask app
Python
52 votes125 views4 answers
Get diroctary in python
Python