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 vote210 views1 answer
Python milliseconds to datetime
Python
1 vote228 views1 answer
Python - count number of values without dupicalte in a second column values
Python
0 vote231 views1 answer
6.2.2.4 packet tracer
Python
1 vote210 views1 answer
Do you have to qualift for mosp twice?
Python
0 vote221 views1 answer
Check strict superset hackerrank solution
Python
20 votes248 views3 answers
Python sort list in reverse
Python
0 vote222 views1 answer
Change between two python 3 version in raspberrry pi
Python
1 vote263 views1 answer
Django filter not equal to
Python Django
0 vote233 views1 answer
Function continuity python
Python
0 vote232 views1 answer
Filter a pandas dataframe by length of list in a column
Python