PYTHON
create pandas dataframe from dictionary orient index
pd.DataFrame.from_dict(data, orient='index',
... columns=['A', 'B', 'C', 'D'])
A B C D
row_1 3 2 1 0
row_2 a b c d
dataframe to dict without index
dataframe to dictionary using index as key
#Use the Dataframe index as the key of the dictionary
df.to_dict('index')
dataframe to dict without index
create pandas dataframe from dictionary orient index
data = {'row_1': [3, 2, 1, 0], 'row_2': ['a', 'b', 'c', 'd']}
>>> pd.DataFrame.from_dict(data, orient='index')
0 1 2 3
row_1 3 2 1 0
row_2 a b c d
create a dictionary from index and column pandas
import pandas as pd
df = pd.DataFrame({'Name': ['John', 'Sara','Peter','Cecilia'],
'Age': [38, 47,63,28],
'City':['Boston', 'Charlotte','London','Memphis']})
df
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'}}
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++']}