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

4 votes246 views3 answers
Python activate environment linux
Python
0 vote254 views1 answer
Get just filename without extension from the path python
Python
78 votes242 views4 answers
Read json
Python
0 vote262 views1 answer
Mathplotlib limit x-axis
Python
0 vote251 views1 answer
How to join an array of characters in python
Python
10 votes263 views5 answers
Rgb to grayscale python opencv
Python
1 vote248 views1 answer
Mean Kurtosis of all rows pandas
Python
0 vote267 views1 answer
How to check type inside a list in python
Python
7 votes294 views6 answers
Bar plot python
Python
0 vote230 views2 answers
How to map longitude and latitude in python
Python