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 vote132 views1 answer
Flask python use specified port
Python Flask
11 votes109 views1 answer
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xe2 in position 10: invalid continuation byte
Python
0 vote102 views1 answer
How to swap two variables without using third variable and default python functionality
Python
2 votes100 views2 answers
How to import somthing from another directory in pyhon
Python
0 vote103 views1 answer
Python clear stdout
Python
1 vote95 views1 answer
What is kali
Python
1 vote124 views1 answer
Assert len(lex) < self.bucket_specs[-1][1]
Python
0 vote125 views2 answers
Django render template
Python Django
1 vote112 views1 answer
Microbit python documentation
Python
2 votes106 views3 answers
How to increase bar width in python matplogtlib
Python