2021年4月10日星期六

Compare and find the extra rows in two datarames with only one common column but different number of rows

I have two dataframes like this:

enter image description here

As you can see, df1 has more rows than df2. Only one column COMPANY is common to them. I want to find out the rows which are extra in df1, comparing only the COMPANY column of both dataframes (no other column can be compared).

Thanks in advance

https://stackoverflow.com/questions/67040817/compare-and-find-the-extra-rows-in-two-datarames-with-only-one-common-column-but April 11, 2021 at 10:02AM

没有评论:

发表评论