Is there a cleaner way to do a join without having to remove the duplicated column?

[kesmit13]

I'm just trying to clean this up by not having to specify suffixes and drop the extra column in code like this.

freq.join(gender, freq.Sex == gender.Sex, suffixes=('', '_')).drop('Sex_')

[cpcloud]

Yeah, we could make this more convenient for the (probably very common) case of inner join with only equality predicates, see here for the rationale.

[kesmit13]

After thinking about it a while, I did realize that this was a very special case. It would be nice if it did the "expected" thing though if possible.

[cpcloud]

It is a special case, but it's a common one so I think we're definitely interested in making the UX here better.

[cpcloud]

There is now a cleaner way to do this arriving in 6.0 thanks to @jcrist in #5883.

[cpcloud]

This has been fully implemented. Inner joins with equality-predicates-only will not duplicate columns.