Filter one data frame by numbers from another data frame

Asked Mar 26 '19 at 15:07

Active Mar 26 '19 at 15:08

Viewed 22 times

I have two data frames:

ID Customer Productnumber
1  1         123456
2  2         4565841
3  1         4651231
4  2         123456
5  3         456454

and the second one:

ID Productnumber Info
1  123456        A
2  4565841       B
3  4651231       B

Now I want to join both data frames but keep only the lines that are contained in data frame B.

I have tried it with diffrent dplyr solutions but I can't find the right way.

So the output should looks like this:

ID Customer Productnumber  Info
1  1         123456        A 
2  2         4565841       B 
3  1         4651231       B

asked Mar 26 '19 at 15:07

Timothy_Goodman

2

`merge(B, A, all.x = TRUE)` – d.b Mar 26 '19 at 15:09
or `merge(df1, df2)` – Ronak Shah Mar 26 '19 at 15:12
Works perfectly, thank you very much. Can anyone else explain to me why I get a different number of lines with merge(B, A, all.x = TRUE) and inner_join(A, B) ? Basically, functions are the same, aren't they? – Timothy_Goodman Mar 27 '19 at 07:26

0 Answers0