pandas make one column as dict key and another value code example
Example 1: dataframe to dictionary with one column as key
pd.Series(df.A.values,index=df.B).to_dict()
Example 2: python how to create dict from dataframe based on 2 columns
In [9]: pd.Series(df.Letter.values,index=df.Position).to_dict()
Out[9]: {1: 'a', 2: 'b', 3: 'c', 4: 'd', 5: 'e'}