Skip to content

Glossary: pandas Beyond the Basics

validate=

Also written: MergeError, many_to_one, one_to_one, join shape, many-to-many

A `merge` option stating the expected shape (one_to_one, many_to_one, one_to_many); pandas raises a `MergeError` if the data disagrees. It prevents the many-to-many trap, where repeated keys on both sides duplicate rows and inflate totals.

Where the book teaches it

Related terms

Keyindicator=Anti-join