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

33 votes189 views5 answers
Install matplotlib pip
Python
1 vote199 views1 answer
Python - removeempy space in a cell
Python
0 vote193 views2 answers
Python union type
Python
0 vote201 views1 answer
Python turn seconds into zulu time
Python
0 vote233 views1 answer
A sorted set in python
Python
0 vote194 views1 answer
Django cms create page programmatically
Python
6 votes213 views2 answers
Convert negative to positive in python
Python
0 vote210 views1 answer
Find charechtar index in string python
Python
0 vote221 views1 answer
Gun in python turtle
Python
14 votes209 views6 answers
If condition python
Python