/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

1 vote188 views1 answer
Python dictionary with list
Python
92 votes192 views6 answers
Python create virtualenv
Python
1 vote188 views2 answers
How to 404 custom page not found in django
Python Django
0 vote206 views1 answer
Branchless if python
Python
29 votes177 views3 answers
Python round up
Python
0 vote210 views1 answer
Import symspell
Python
0 vote178 views1 answer
Delete dataframe from memory python
Python
1 vote233 views1 answer
Django integer field example
Python Django
11 votes204 views4 answers
Get count of values in column pandas
Python
105 votes198 views4 answers
How to get random number python
Python