how to make a python dictionary mapping the values from one col to another pandas code example
Example 1: pandas rename column values dictionary
df['col1'].map(di) # note: if the dictionary does not exhaustively map all
# entries then non-matched entries are changed to NaNs
Example 2: pandas rename column values dictionary
df['col1'].map(di).fillna(df['col1'])