columns overlap but no suffix specified: Index(['LOCATION', 'Value'], 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')