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

1 vote100 views2 answers
Get pytorch version
Python
0 vote110 views1 answer
Check if file already existing
Python
0 vote99 views1 answer
Print a line using python, All the word lengths should be fixed i.e., every word should have the width of the longest word
Python
3 votes100 views1 answer
Print the heat map python
Python
1 vote108 views1 answer
Posted data to flask
Python
6 votes98 views3 answers
Python data type conversion
Python
1 vote103 views1 answer
Python access modifiers
Python
19 votes119 views3 answers
Pil image to numpy
Python
3 votes208 views3 answers
Python name of current file
Python
2 votes101 views1 answer
Python multiply list bt number
Python