convert pandas to dictionary python code example
Example 1: 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
Example 2: dataframe to dict without index
df.to_dict('index')
Example 3: convert pandas dataframe to dict with a column as key
df.set_index('columnName').T.to_dict()
Example 4: dataframe to dict without index
{0: {'Name': 'John', 'Age': 38, 'City': 'Boston'},
1: {'Name': 'Sara', 'Age': 47, 'City': 'Charlotte'},
2: {'Name': 'Peter', 'Age': 63, 'City': 'London'},
3: {'Name': 'Cecilia', 'Age': 28, 'City': 'Memphis'}}
Example 5: dataframe to dict without index
{'Name': ['John', 'Sara', 'John', 'Sara'],
'Sem': ['Sem1', 'Sem1', 'Sem2', 'Sem2'],
'Subject': ['Mathematics', 'Biology', 'Biology', 'Mathematics'],
'Grade': ['A', 'B', 'A+', 'B++']}