'Is there a way to merge two tables and bringing only matching value from the second one? [duplicate]
I' have 2 tables on pandas (Table1,Table2) and I would like to get a third one (Table3) as in the example below (I feel like a visual example is worth 1000 words)
Could you please tell me how would the code work?
Table1
| ISIN | Price |
|---|---|
| A | 1 |
| B | 2 |
| C | 3 |
| D | 4 |
Table2
| ISIN | Price2 |
|---|---|
| A | 5 |
| D | 6 |
| E | 7 |
Table3
| ISIN | Price | Price2 |
|---|---|---|
| A | 1 | 5 |
| B | 2 | |
| C | 3 | |
| D | 4 | 6 |
Thanks for your help!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|