PANDAS DATAFRAME
I have a table that looks like this ... Table (1)
names (INDEX) ------ ID
DWIGHT S. ------ 56756
JIM H. ------ 32456
KEVIN M. ------ 76765
MICHAEL S. ------ 34245
PAM B. ------ 84572
I have a "key" that looks like this ... Table (2)
names (INDEX) ------ FULL NAME
DWIGHT S. ------ SHRUTE, DWIGHT
JIM H. ------ HALPERT, JIM
KEVIN M. ------ MALONE, KEVIN
MICHAEL S. ------ SCOTT, MICHAEL
PAM B. ------ BEESLY, PAMELA
I want to have the first table to looks like ...
FULL NAME (INDEX) ------ ID
SHRUTE, DWIGHT ------ 56756
HALPERT, JIM ------ 32456
MALONE, KEVIN ------ 76765
SCOTT, MICHAEL ------ 34245
BEESLY, PAMELA ------ 84572
What I have tried:
Not sure where to begin ---
Maybe map the values in Table (2) to the index in Table (1)