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 vote143 views1 answer
Py convert binary to int
Python
1 vote164 views1 answer
Seconds add zero python
Python
0 vote137 views1 answer
Ignore bad lines pandas
Python
0 vote160 views2 answers
Install kivyMD from git
Python
0 vote147 views1 answer
Powershell open file with default program
Python
0 vote143 views1 answer
Plot every nth label in barplot
Python
0 vote163 views1 answer
Pylatex bold
Python
-1 vote130 views1 answer
"scrapy shell" pass cookies to fetch
Python
0 vote155 views1 answer
Lista to txt python
Python
0 vote175 views1 answer
Pip choose interpreter
Python