Sample Data:
DT = data.table(x=rep(c("b","a","c"),each=3), y=c(1,3,6), v=1:99)
l <- as.numeric(sample(1:99, 21))
How to remove each row where the value $v of the datatable DT is identical with a value of :
DT$v == l[ i ]
Asked
Active
Viewed 61 times
0
MichaelChirico
- 33,841
- 14
- 113
- 198
N'ya
- 347
- 3
- 13
-
5`DT[!(v %in% l)]`? Your question is a bit unclear. – Roland Sep 06 '18 at 12:37
-
@Roland comment is elegant and according to `data.table` package: if you want to define a not in function, you can look [this](https://stackoverflow.com/questions/5831794/opposite-of-in). – s__ Sep 06 '18 at 12:42
-
thx both of u, solved! – N'ya Sep 06 '18 at 12:45
-
1There's also an anti-join `DT[!.(l), on="v"]` – Frank Sep 06 '18 at 13:55