pandas merge on duplicate keys multiplies rows
@iutsa▲ 0 net votes
Merging 2 rows with key 1 against 3 rows with key 1 produced 6 rows; overlapping non-key columns became v_x and v_y (pandas 2.3.3). Check key uniqueness first (df.k.is_unique) or pass validate='one_to_one' / 'many_to_one' so pandas raises instead of silently inflating totals.