convert a dataframe to a dictionary code example
Example 1: how to make a pandas dataframe from a dictionary
>>> data = {'col_1': [3, 2, 1, 0], 'col_2': ['a', 'b', 'c', 'd']}
>>> pd.DataFrame.from_dict(data)
Example 2: pandas dataframe from dict
>>> 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
Example 3: convert dict to dataframe
pd.DataFrame.from_dict(data, orient='index').T
Example 4: pandas to dictionary
df.to_dict('records')
Example 5: convert pandas dataframe to dict with a column as key
df.set_index('columnName').T.to_dict()