I'm trying to add a column to an existing df with values from other df with matching values on other columns, a simple vlookup where I have an id on one column and the name corresponding to that id in other df with a different column name
df1 has this
other_id, ..., ..., ...
df2 has this
id, name, ..., ..., ...
I need to create a column 'name' on df1, where the id on df2.id matches the df1.other_id so I get the df2.name column on df1 extending the info from df2 to df1
Remember the column 'name' on df1 is to be created with the merge