pandas dataframe to dict column as key code example

Example 1: pandas dataframe from dict

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

Example 2: pandas dataframe from dict

>>> 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

Example 3: convert dict to dataframe

#Lazy way to convert json dict to df

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()

Example 6: dataframe to dictionary using index as key

#Use the Dataframe index as the key of the dictionary
df.to_dict('index')