df1 <- data.frame(number = c(1,2,3,4,5),value=c(100,200,300,400,500))
df2 <- data.frame(number=c(1,2,3,7,10),value=c(100,200,300,444,555))
我有两个数据帧,数字作为标识符,值相关联。我想返回一个df3,它包含"0";数字";在每个数据帧中匹配。
Expected Output df3:
number value
1 100
2 200
3 300
编辑:我想我可以用这个真/假来子集
df1$number %in% df2$number
data.table
溶液
# load library
library(data.table)
# set as datatable
lapply(list(df1, df2), (i) setDT(i))
# inner join
df1[df2, on=.(number), mget(names(df1)), nomatch=0]
df3<-merge(df1,df2,by=c('number','value'((