How to combine multiple conditions to subset a data-frame using “OR”?

by 
my.data.frame <- subset(data , V1 > 2 | V2 < 4)

An alternative solution that mimics the behavior of this function and would be more appropriate for inclusion within a function body:

new.data <- data[ which( data$V1 > 2 | data$V2 < 4) , ]

Some people criticize the use of which as not needed, but it does prevent the NA values from throwing back unwanted results. The equivalent (.i.e not returning NA-rows for any NA’s in V1 or V2) to the two options demonstrated above without the which would be:

 new.data <- data[ !is.na(data$V1 | data$V2) & ( data$V1 > 2 | data$V2 < 4)  , ]

Note: I want to thank the anonymous contributor that attempted to fix the error in the code immediately above, a fix that got rejected by the moderators. There was actually an additional error that I noticed when I was correcting the first one. The conditional clause that checks for NA values needs to be first if it is to be handled as I intended, since …

> NA & 1
[1] NA
> 0 & NA
[1] FALSE

Order of arguments may matter when using ‘&”.

More Related Contents:

  1. Filter data.frame rows by a logical condition
  2. Split column at delimiter in data frame [duplicate]
  3. Pass a data.frame column name to a function
  4. Compare two data.frames to find the rows in data.frame 1 that are not present in data.frame 2
  5. R Reshape data frame from long to wide format? [duplicate]
  6. Sum rows in data.frame or matrix
  7. Select the first row by group
  8. Calculate row means on subset of columns
  9. How does one reorder columns in a data frame?
  10. R spreading multiple columns with tidyr [duplicate]
  11. Unlist data frame column preserving information from other column
  12. How to quickly form groups (quartiles, deciles, etc) by ordering column(s) in a data frame
  13. Take random sample by group
  14. The condition has length > 1 and only the first element will be used
  15. Split dataframe into multiple output files
  16. Replacing values from a column using a condition in R
  17. Split data.frame by value
  18. How to use a string variable to select a data frame column using $ notation [duplicate]
  19. R list of lists to data.frame
  20. Remove columns from dataframe where some of values are NA
  21. Check whether values in one data frame column exist in a second data frame
  22. How do you remove columns from a data.frame?
  23. Deleting columns from a data.frame where NA is more than 15% of the column length [duplicate]
  24. DT[!(x == .)] and DT[x != .] treat NA in x inconsistently
  25. Return df with a columns values that occur more than once [duplicate]
  26. Replicate each row of data.frame and specify the number of replications for each row?
  27. Find columns with all missing values
  28. How to transpose a dataframe in tidyverse?
  29. Deleting every n-th row in a dataframe
  30. How to convert certain columns only to numeric?

Leave a Comment