I have two dataframes. The first dataframe contains an ID column, and the second a name column. An ID can have more than one name, but a name always belongs to a single ID.
I have a second dataframe, which have the name column as well.
What I would like to have is a new column in the second dataframe, with the matching IDs to the names. How do I do that?
I understand I create an empty column, than take the name as an input, search for that in the first dataframe's name column, and if I have a match, grab the ID from the next cell, and return that, but I cannot figure out how to that.