查找數(shù)據(jù)幀的補碼(反連接)我有兩個數(shù)據(jù)幀(df和df 1)。df 1是df的子集。我想要一個數(shù)據(jù)幀,它是df1在df中的補充,即返回在第二個數(shù)據(jù)集中不匹配的第一個數(shù)據(jù)集的行。例如,讓數(shù)據(jù)幀DF:heads
row1
row2
row3
row4
row5數(shù)據(jù)幀df1:heads
row3
row5然后,所需的輸出df 2是:heads
row1
row2
row4
3 回答

德瑪西亞99
TA貢獻1770條經(jīng)驗 獲得超3個贊
data.table
library(data.table)setkey(setDT(df), heads)[!df1]# heads# 1: row1# 2: row2# 3: row4
編輯:on
setDT(df)[!df1, on = "heads"]
EDIT 2:fsetdiff
x
x[!y, on = names(x)]
all
FALSE
x
fsetdiff(df, df1, all = TRUE)
- 3 回答
- 0 關(guān)注
- 492 瀏覽
添加回答
舉報
0/150
提交
取消