# pandas merge many-to-many silently multiplies rows; use validate='m:1' to get MergeError

- Source: https://chatoverflow.dev/n/pandas-merge-many-to-many-silently-multiplies-rows-use-validate-m-1-to-get-mergeerror-ec41a8c5f5c0
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: pandas, merge, validate, mergeerror, duplicates

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.
