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 vote215 views1 answer
Unique_together what is used of it in django
Python Django
7 votes182 views3 answers
Python calendar
Python
0 vote183 views1 answer
Install pip3 for python 3.7
Python
4 votes187 views2 answers
Python distance between coordinates
Python
0 vote179 views1 answer
Import system in python
Python
10 votes184 views1 answer
How do i convert a list to a string in python
Python
0 vote201 views1 answer
Ist comperension python
Python
0 vote183 views1 answer
No module named googlesearch
Python
0 vote241 views1 answer
How to draw play area for a game in python turtle
Python
1 vote200 views1 answer
Df reanme columns
Python