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

2 votes280 views1 answer
Creating data frame in python with for loop
Python
3 votes254 views1 answer
Datetime.timedelta months
Python
1 vote273 views1 answer
How to read zip csv file in python
Python
0 vote273 views1 answer
Support vector machine svm using python numerical example
Python
2 votes293 views1 answer
Pandas dataframe aggregations
Python
3 votes255 views1 answer
Python numpy group by count
Python
0 vote269 views1 answer
Scrapy create project
Python
45 votes259 views3 answers
Python change filename
Python
2 votes286 views2 answers
Python django query
Python
5 votes301 views2 answers
Django form password field
Python Django