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 vote126 views1 answer
User passes test django
Python
0 vote132 views1 answer
Can't open file 'sherlock.py' errno 2 no such file or directory
Python
2 votes148 views3 answers
Pandas print dataframe without index
Python
0 vote119 views1 answer
Python staticmethod property
Python
0 vote137 views1 answer
Python division no remainder
Python
79 votes128 views6 answers
Python current working directory
Python
3 votes139 views2 answers
Postgres Database Django
Python
0 vote132 views1 answer
ImportError: cannot import name 'get_column_letter' openpyxl
Python
0 vote133 views2 answers
How to calculate approximate distance with latitude and longitude
Python
2 votes169 views1 answer
Difference between w+ and r+ in python
Python