CODE EXAMPLE FOR PYTHON

left join two dataframes pandas on two different column names

Both_DFs = pd.merge(df1,df2, how='left',left_on=['A','B'],right_on=['A','CC']).dropna()