R语言中如何找出在两个数据框中完全相同的行(How to find common rows between two dataframe in R?)
I would like to make a new data frame which only includes common rows of two separate data.frame. example:
data.frame 1
1 id300 2 id2345 3 id5456 4 id33 5 id45 6 id54
data.frame2
1 id832 2 id300 3 id1000 4 id45 5 id984 6 id5456 7 id888
So I want my output be:
1 id300 2 id45 3 id5456
any suggestion please?
The appropriate dplyr
function here is inner_join
(returns all rows from df x
that have a match in df y
.)
library(dplyr) inner_join(df1, df2) V1 1 id300 2 id5456 3 id45
Note: the rows are returned in the order in which they are in df1
. If you did inner_join(df2, df1)
, id45
would come before id5456
.