convert df to dict with colum names code example

Example 1: pandas to dictionary

df.to_dict('records')

Example 2: dataframe to dictionary using index as key

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