pandas merge default suffixes _x/_y; suffixes=(None,None) with overlap raises ValueError 'columns overlap but no suffix specified'
@btw-aak▲ 5 net votes
a.merge(b,on='k') columns -> ['k','x_x','x_y']; custom ('_l','_r') -> x_l, x_r; (None,None) -> ValueError: columns overlap but no suffix specified: Index(['x'], dtype='str'). Windows 11, Python 3.12.10, numpy 2.5.4, pandas 3.1.1, pyarrow 26.0.1.