Using multiple criteria in subset function and logical operators

by

The correct operator is %in% here. Here is an example with dummy data:

set.seed(1)
dat <- data.frame(bf11 = sample(4, 10, replace = TRUE),
                  foo = runif(10))

giving:

> head(dat)
  bf11       foo
1    2 0.2059746
2    2 0.1765568
3    3 0.6870228
4    4 0.3841037
5    1 0.7698414
6    4 0.4976992

The subset of dat where bf11 equals any of the set 1,2,3 is taken as follows using %in%:

> subset(dat, subset = bf11 %in% c(1,2,3))
   bf11       foo
1     2 0.2059746
2     2 0.1765568
3     3 0.6870228
5     1 0.7698414
8     3 0.9919061
9     3 0.3800352
10    1 0.7774452

As to why your original didn’t work, break it down to see the problem. Look at what 1||2||3 evaluates to:

> 1 || 2 || 3
[1] TRUE

and you’d get the same using | instead. As a result, the subset() call would only return rows where bf11 was TRUE (or something that evaluated to TRUE).

What you could have written would have been something like:

subset(dat, subset = bf11 == 1 | bf11 == 2 | bf11 == 3)

Which gives the same result as my earlier subset() call. The point is that you need a series of single comparisons, not a comparison of a series of options. But as you can see, %in% is far more useful and less verbose in such circumstances. Notice also that I have to use | as I want to compare each element of bf11 against 1, 2, and 3, in turn. Compare:

> with(dat, bf11 == 1 || bf11 == 2)
[1] TRUE
> with(dat, bf11 == 1 | bf11 == 2)
 [1]  TRUE  TRUE FALSE FALSE  TRUE FALSE FALSE FALSE FALSE  TRUE

More Related Contents:

  1. R gotcha: logical-and operator for combining conditions is & not &&
  2. Select rows from a data frame based on values in a vector
  3. How to subset matrix to one column, maintain matrix data type, maintain row/column names?
  4. How to drop columns by name in a data frame
  5. Subset / filter rows in a data frame based on a condition in a column
  6. How to replace NA with mean by group / subset?
  7. How do I extract a single column from a data.frame as a data.frame?
  8. Subset dataframe by multiple logical conditions of rows to remove
  9. Subset data frame based on multiple conditions [duplicate]
  10. Subset a dataframe between 2 dates
  11. Subset data to contain only columns whose names match a condition
  12. Subset and ggplot2
  13. Extract matrix column values by matrix column name
  14. Logical operators (AND, OR) with NA, TRUE and FALSE
  15. Reading multiple files and calculating mean based on user input
  16. Collapse rows with overlapping ranges
  17. How to subset data in R without losing NA rows?
  18. Using grep to help subset a data frame
  19. Subset based on variable column name
  20. from data table, randomly select one row per group
  21. Return data subset time frames within another timeframes?
  22. Subsetting a dataframe for a specified month and year
  23. Looping through t.tests for data frame subsets in r
  24. Delete duplicate rows in two columns simultaneously [duplicate]
  25. Dealing with TRUE, FALSE, NA and NaN
  26. Filter data frame rows based on values in vector
  27. Undefined columns selected when subsetting data frame
  28. How to get all possible subsets of a character vector in R?
  29. Filtering rows in R unexpectedly removes NAs when using subset or dplyr::filter
  30. Difference between Boolean operators && and & and between || and | in R

Leave a Comment