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

75 votes187 views6 answers
Sort dictionary python
Python
-1 vote163 views1 answer
Python : search file for string
Python
0 vote167 views1 answer
Pandas to tensor torch
Python
0 vote215 views1 answer
Access field values of form django
Python Django
0 vote181 views1 answer
Python program for getting url, hostname, port numbers
Python
0 vote150 views2 answers
How plot graph by using group by function in python
Python
81 votes189 views6 answers
Python check if string
Python
0 vote224 views1 answer
Resizing django embed player
Python Django
0 vote229 views2 answers
How to avoid inserting duplicate records in orm django
Python Django
0 vote175 views1 answer
Python mouse listener
Python