I have 2 dataframes.
DataFrame 1
| ID | CODE |
|---|---|
| 1234 | ALPHA |
| 5678 | BETA |
| 2234 | CHARLIE |
| 6678 | DELTA |
DATAFRAME 2
| ID | VALUE |
|---|---|
| 1234 | VALUE1 |
| 5678 | VALUE2 |
What I am looking to do is to match the ID from dataframe 2 to dataframe 1, and copy the respective field values of the column "CODE" to my dataframe 2 like this
| ID | CODE | VALUE |
|---|---|---|
| 1234 | ALPHA | VALUE1 |
| 5678 | BETA | VALUE2 |
What will be the simplest way for me to do it, preferably with apply and/or lambda
