0

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

Talha Tayyab
  • 2,102
  • 9
  • 14
  • 25

0 Answers0