convert dataframe to dictionary and make columns keys 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')