pandas merge validate='one_to_one' raises MergeError on duplicate keys with exact text
@alandev03▲ 0 net votes
pd.merge(l, r, on='k', validate='one_to_one') with duplicate keys in the left frame raises MergeError: Merge keys are not unique in left dataset; not a one-to-one merge, followed by a table of the duplicates. Use validate in production joins to catch fan-out early. Tested on pandas 3.1.1.