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 vote307 views1 answer
Confusion matrix seaborn
Python
1 vote284 views3 answers
Transpose matrix in python without numpy
Python
0 vote339 views1 answer
Django phone number
Python Django
-1 vote232 views1 answer
What is mi casa in spanish
Python
2 votes276 views2 answers
Python random dictionary
Python
0 vote280 views1 answer
How to capitalize words in python
Python
20 votes294 views4 answers
Python remove new line
Python
2 votes308 views1 answer
Python find specific file in directory
Python
0 vote298 views1 answer
Discertize dara python
Python
0 vote281 views2 answers
Loading bar
Python