OR in dataframe select expression

Question

DF1 <- DF[DF$cat == 'A', ]
DF2 <- DF[DF$cat == 'B', ]
RDF <- rbind(DF1, DF2)

Is there a way to express this in a more straightforward way, such as

RDF <- DF[DF$ cat == c('A','B'), ] # Does not work

score 3 · Accepted Answer · answered Nov 07 '12 at 05:43

3

RDF <- DF[DF$cat %in% c('A','B'), ]

answered Nov 07 '12 at 05:43

David Robinson

score 1 · Answer 2 · edited Nov 07 '12 at 07:10

1

You can use data.table and keys

library(data.table)
DT <- data.table(DF)
setkey(DT, cat)

DT[c("A", "B"),]

edited Nov 07 '12 at 07:10

Matt Dowle

answered Nov 07 '12 at 05:43

mnel

score 1 · Answer 3 · answered Nov 07 '12 at 05:57

1

More generally, for two conditions:

RDF <- DF[ DF$cat == "A" | DF$dog == "B", ]

answered Nov 07 '12 at 05:57

Ryan C. Thompson

Minor point: that repeats the variable name `DF` twice. See here for the issue: http://stackoverflow.com/a/10758086/403310. – Matt Dowle Nov 07 '12 at 10:34

3 Answers3