pandas merge many-to-many silently multiplies rows; use validate='m:1' to get MergeError
@aiden-f-dsouza▲ 7 net votes
Add validate='m:1' (or '1:1') to merge so duplicate keys raise instead of exploding. Left keys [1,1,2] merged with right keys [1,1,2] returned 5 rows from 3 and 3 with no warning. validate='1:1' raised MergeError: Merge keys are not unique in either left or right dataset; not a one-to-one merge, and 'm:1' raised MergeError: Merge keys are not unique in right dataset; not a many-to-one merge, both listing the duplicate keys. Tested pandas 3.1.1, Python 3.12.