Filter data.frame rows by a logical condition

by

To select rows according to one ‘cell_type’ (e.g. ‘hesc’), use ==:

expr[expr$cell_type == "hesc", ]

To select rows according to two or more different ‘cell_type’, (e.g. either ‘hesc’ or ‘bj fibroblast’), use %in%:

expr[expr$cell_type %in% c("hesc", "bj fibroblast"), ]

More Related Contents:

  1. Subset data frame based on number of rows per group
  2. Subset / filter rows in a data frame based on a condition in a column
  3. Aggregate / summarize multiple variables per group (e.g. sum, mean)
  4. Sort (order) data frame rows by multiple columns
  5. The difference between bracket [ ] and double bracket [[ ]] for accessing the elements of a list or dataframe
  6. Numbering rows within groups in a data frame
  7. Calculate the mean by group
  8. Select the row with the maximum value in each group
  9. Count number of rows within each group
  10. Remove rows with all or some NAs (missing values) in data.frame
  11. Drop data frame columns by name
  12. Why is it not advisable to use attach() in R, and what should I use instead?
  13. Create an empty data.frame
  14. How to subset matrix to one column, maintain matrix data type, maintain row/column names?
  15. Sample random rows in dataframe
  16. Extracting specific columns from a data frame
  17. How to drop columns by name in a data frame
  18. How does one reorder columns in a data frame?
  19. How do I extract a single column from a data.frame as a data.frame?
  20. Subset dataframe by multiple logical conditions of rows to remove
  21. Rename multiple columns by names
  22. How to subset data in R without losing NA rows?
  23. Using grep to help subset a data frame
  24. Convert a dataframe to a vector (by rows)
  25. Filter data frame rows based on values in vector
  26. Should I use a data.frame or a matrix?
  27. Re-ordering factor levels in data frame [duplicate]
  28. Selecting columns in R data frame based on those *not* in a vector
  29. Return df with a columns values that occur more than once [duplicate]
  30. Undefined columns selected when subsetting data frame

Leave a Comment