Pandas join issue: columns overlap but no suffix specified

Michael Zippo

👻 Check our latest review to choose the best laptop for Machine Learning engineers and Deep learning tasks!

I have following 2 data frames:

df_a =

     mukey  DI  PI
0   100000  35  14
1  1000005  44  14
2  1000006  44  14
3  1000007  43  13
4  1000008  43  13

df_b = 
    mukey  niccdcd
0  190236        4
1  190237        6
2  190238        7
3  190239        4
4  190240        7

When I try to join these 2 dataframes:

join_df = df_a.join(df_b,on="mukey",how="left")

I get the error:

*** ValueError: columns overlap but no suffix specified: Index([u"mukey"], dtype="object")

Why is this so? The dataframes do have common "mukey" values.

👻 Read also: what is the best laptop for engineering students?

We hope this article has helped you to resolve the problem. Apart from Pandas join issue: columns overlap but no suffix specified, check other code Python module-related topics.

Want to excel in Python? See our review of the best Python online courses 2023. If you are interested in Data Science, check also how to learn programming in R.

By the way, this material is also available in other languages:

Frank Porretti

Shanghai | 2023-03-24

COM PHP module is always a bit confusing 😭 Pandas join issue: columns overlap but no suffix specified is not the only problem I encountered. I am just not quite sure it is the best method

Boris Chamberlet

Singapore | 2023-03-24

re Python module is always a bit confusing 😭 Pandas join issue: columns overlap but no suffix specified is not the only problem I encountered. I am just not quite sure it is the best method

Carlo Chamberlet

Warsaw | 2023-03-24

Thanks for explaining! I was stuck with Pandas join issue: columns overlap but no suffix specified for some hours, finally got it done 🤗. Checked yesterday, it works!