/Python/Convert pandas dataframe/ table to python dictionary

Convert pandas dataframe/ table to python dictionary

Convert a dictionary into dataframe python

import pandas as pd
data = {'col_1': [3, 2, 1, 0], 'col_2': ['a', 'b', 'c', 'd']}
pd.DataFrame.from_dict(data, orient='index').T

Dataframe to dictionary

>>> df.to_dict('records')
[{'col1': 1, 'col2': 0.5}, {'col1': 2, 'col2': 0.75}]

Source: pandas.pydata.org

Python convert dictionary to pandas dataframe

>>> data = {'col_1': [3, 2, 1, 0], 'col_2': ['a', 'b', 'c', 'd']}
>>> pd.DataFrame.from_dict(data)
   col_1 col_2
0      3     a
1      2     b
2      1     c
3      0     d

Source: pandas.pydata.org

Convert pandas dataframe/ table to python dictionary

df.to_dict(orient='index')

Convert dict to dataframe

#Lazy way to convert json dict to df

pd.DataFrame.from_dict(data, orient='index').T

Similar codes

5 votes151 views3 answers
Tuplein python
Python
9 votes161 views1 answer
Except as Exception:
Python
0 vote166 views1 answer
How to install tkinter in pycharm
Python
0 vote140 views1 answer
Pyqt5 image center
Python
0 vote150 views1 answer
How to add previous and next in tkinter in python
Python
11 votes154 views6 answers
Python Dictionaries
Python
22 votes162 views6 answers
How to use dictionary in python
Python
0 vote160 views1 answer
Python gaussian filter
Python
0 vote162 views1 answer
Pythonremove all instances from a list
Python
0 vote173 views1 answer
Back button django template
Python Django