I am relatively new to R so please go easy on me!
I have a list of items, for example lets say:
Name Location
AB 1
CD 20
EF 45
...and so on for about ~17,000 items.
However, I also have a list where some of these items have updated locations and names- but not all of them. For example, in this list
Name Location Updated_Name
AB 1 (Same)
CD 32 EGG (Changed)
EF 42 OOL (Changed)
IS there a function where I can search by the 'original' name/location, and for those which are 'changed', replace the old name/location-- and where the 'original' name/location are the same, keep these? I would need to retain the positioning/order of the list.
I would really appreciate some help with this!