Can pandas join tables if the common headers are different names?

Asked Feb 10 '22 at 22:54

Active Feb 10 '22 at 23:08

Viewed 67 times

I am following this article, but I was only able to get it to work by making sure there were matching titles, the two still had computer names, but they were called differently in the title, how could I modify my command so that it still references the same column, is that possible?

lj_df2 = pd.merge(d2, d3, on="PrimaryUser", how="left")

For example, I have this, but on my other csv, I have Employee # not primary user

edited Feb 10 '22 at 22:55

Henry Ecker

34,399
18
41
57

asked Feb 10 '22 at 22:54

1

You mean different left and right on values? `lj_df2 = pd.merge(d2, d3, left_on="PrimaryUser", right_on="Employee #", how="left")` – Henry Ecker Feb 10 '22 at 22:55
@HenryEcker you should post that as an answer – Angus L'Herrou Feb 10 '22 at 22:56
It's a duplicate if that's the answer [Joining pandas dataframes by column names](https://stackoverflow.com/q/20375561/15497888) @AngusL'Herrou – Henry Ecker Feb 10 '22 at 22:56
@HenryEcker true. – Angus L'Herrou Feb 10 '22 at 22:57
This is also discussed in https://stackoverflow.com/questions/53645882/pandas-merging-101 (first answer ... do ctrl+F and search for "Different names for key columns") – cs95 Feb 10 '22 at 23:09

Can pandas join tables if the common headers are different names?

0 Answers0