convert column from row type to dict type code example
Example 1: df col to dict
area_dict = dict(zip(lakes.area, lakes.count))
Example 2: dataframe to dictionary using index as key
#Use the Dataframe index as the key of the dictionary
df.to_dict('index')