names(DF1)[ !(names(DF1) %in% names(DF2)) ]
To illustrate:
> x <- letters[1:5]
> y <- letters[c(2,4)]
> x[ !(x %in% y) ]
[1] "a" "c" "e"
At 11:41 AM -0800 3/7/07, lalitha viswanath wrote:
>Hi
>I have two dataframes
>names(DF1) = c("id", "val1", "val2");
>
>names(DF2) = c("id2");
>
>Ids in
try something along these lines (untested):
DF1[DF1$id %in% DF2$id2, c("val1", "val2")]
DF1[!DF1$id %in% DF2$id2, c("val1", "val2")]
I hope it helps.
Best,
Dimitris
Dimitris Rizopoulos
Ph.D. Student
Biostatistical Centre
School of Public Health
Catholic University of Leuven
Address: Kapu
Hi
I have two dataframes
names(DF1) = c("id", "val1", "val2");
names(DF2) = c("id2");
Ids in DF2 are a complete subset of those in DF1
How can I extract entries from DF1 where id NOT IN
DF2.
I tried setdiff(DF1, DF2); setdiff(DF1$id, DF2$id),
etc.
Although the latter eliminates the ids as requi
