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

1 vote116 views1 answer
Google colab power level
Python
97 votes179 views6 answers
How to read a csv file in python
Python
0 vote161 views1 answer
Numpy collapse last dimension
Python
21 votes151 views6 answers
Print statement in python
Python
23 votes160 views4 answers
Python replace letters in string
Python
0 vote172 views1 answer
How to call the tkinter insert command from another class
Python
5 votes177 views5 answers
Formatted string in python
Python
2 votes188 views3 answers
Area of a circle in python
Python
0 vote172 views1 answer
Import views
Python
1 vote224 views1 answer
Django manger
Python Django