I have two DataFrames. In both DataFrames, the key has duplicates and I’m OK with that. I want the product column in the target DataFrame to be updated with the product value in the first DataFrame. When I use .update() I get errors because of duplicate values. Can this be done in one step somehow?
| key | product |
|---|---|
| 123 | abc |
| 456 | def |
| 123 | abc |
| 456 | def |
1