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 vote125 views1 answer
Dataframe describe in pandas problems
Python
0 vote158 views1 answer
How to customize simplejwt error response message in django restframework
Python Django
0 vote150 views1 answer
How to create a cubic function in python 3
Python
0 vote176 views1 answer
How to load mnist dataset in python
Python
51 votes140 views6 answers
Python print in color
Python
10 votes144 views2 answers
How to find duplicate numbers in list in python
Python
2 votes140 views1 answer
Python regex numbers only
Python
0 vote134 views1 answer
How to import packages in python
Python
0 vote131 views1 answer
Django post request 403 forbidden
Python
0 vote148 views2 answers
Pyton como identificar se é numero
Python