CODE EXAMPLE FOR PYTHON

python - match two df on a variable with different name

pd.merge(df1, df2, left_on=  ['userid', 'column1'],
                   right_on= ['username', 'column1'], 
                   how = 'left')