columns overlap but no suffix specified: Index(['Messed Names'], dtype='object') code example

Example: columns overlap but no suffix specified: Index(['zpid'], dtype='object')

df_a.join(df_b, on='mukey', how='left', lsuffix='_left', rsuffix='_right')