?"%in%" says "x" and "table" must be vectors. You supplied data.frames. So %in% is coercing your today.sequence to a vector using
as.character(today.sequence) Perhaps you should paste the columns together first: x <- do.call("paste", c(sequence, sep = "::")) table <- do.call("paste", c(today.sequence, sep = "::")) x[7] %in% table I'm not sure if this is what you want/need, but it does match your example. HTH, --sundar On Tue, Nov 3, 2009 at 7:53 AM, Kaushik Krishnan <kaushik.s.krish...@gmail.com> wrote: > Hi folks > > I have two data frames. I know that the nth (let's say the 7th) row > in the first data frame (sequence) is there in the second > (today.sequence). When I try to check that by doing 'sequence[7,] > %in% today.sequence', I get all FALSE when it should be all TRUE. > > I'm certain I'm making some trivial mistake. Any solutions? > > The code to recreate the data frames and see for yourself is: > ---- > sequence <- structure(list(DATE = structure(c(14549, 14549, 14553, 14550, > 14557, 14550, 14551, 14550), class = "Date"), DATASET = c(1L, > 2L, 1L, 2L, 2L, 3L, 3L, 4L), REP = c(1L, 0L, 2L, 2L, 3L, 0L, > 1L, 0L), WRONGS_ABS = c(0L, 0L, 0L, 0L, 0L, 0L, 0L, 0L), WRONGS_RATIO = c(0L, > 0L, 0L, 0L, 0L, 0L, 0L, 0L), DONE = c(1L, 1L, 0L, 1L, 0L, 1L, > 0L, 0L)), .Names = c("DATE", "DATASET", "REP", "WRONGS_ABS", > "WRONGS_RATIO", "DONE"), class = "data.frame", row.names = c(NA, > -8L)) > > today.sequence <- structure(list(DATE = structure(c(14551, 14550), > class = "Date"), > DATASET = 3:4, REP = c(1L, 0L), WRONGS_ABS = c(0L, 0L), > WRONGS_RATIO = c(0L, > 0L), DONE = c(0L, 0L)), .Names = c("DATE", "DATASET", "REP", > "WRONGS_ABS", "WRONGS_RATIO", "DONE"), row.names = 7:8, class = "data.frame") > > sequence[7,] #You should see '2009-11-03 3 1 0 > 0 0' > > today.sequence #You can clearly see that sequence [7,] is the first > row in today.sequence > > sequence[7,] %in% today.sequence #This should show 'TRUE TRUE TRUE > TRUE TRUE TRUE'. Instead > # it shows 'FALSE FALSE FALSE FALSE FALSE FALSE' > ---- > > Thanks > > -- > Kaushik Krishnan > (kaushik.s.krish...@gmail.com) > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.