Subset data to contain only columns whose names match a condition

by

Try grepl on the names of your data.frame. grepl matches a regular expression to a target and returns TRUE if a match is found and FALSE otherwise. The function is vectorised so you can pass a vector of strings to match and you will get a vector of boolean values returned.

Example

#  Data
df <- data.frame( ABC_1 = runif(3),
            ABC_2 = runif(3),
            XYZ_1 = runif(3),
            XYZ_2 = runif(3) )

#      ABC_1     ABC_2     XYZ_1     XYZ_2
#1 0.3792645 0.3614199 0.9793573 0.7139381
#2 0.1313246 0.9746691 0.7276705 0.0126057
#3 0.7282680 0.6518444 0.9531389 0.9673290

#  Use grepl
df[ , grepl( "ABC" , names( df ) ) ]
#      ABC_1     ABC_2
#1 0.3792645 0.3614199
#2 0.1313246 0.9746691
#3 0.7282680 0.6518444

#  grepl returns logical vector like this which is what we use to subset columns
grepl( "ABC" , names( df ) )
#[1]  TRUE  TRUE FALSE FALSE

To answer the second part, I’d make the subset data.frame and then make a vector that indexes the rows to keep (a logical vector) like this…

set.seed(1)
df <- data.frame( ABC_1 = sample(0:1,3,repl = TRUE),
            ABC_2 = sample(0:1,3,repl = TRUE),
            XYZ_1 = sample(0:1,3,repl = TRUE),
            XYZ_2 = sample(0:1,3,repl = TRUE) )

# We will want to discard the second row because 'all' ABC values are 0:
#  ABC_1 ABC_2 XYZ_1 XYZ_2
#1     0     1     1     0
#2     0     0     1     0
#3     1     1     1     0


df1 <- df[ , grepl( "ABC" , names( df ) ) ]

ind <- apply( df1 , 1 , function(x) any( x > 0 ) )

df1[ ind , ]
#  ABC_1 ABC_2
#1     0     1
#3     1     1

More Related Contents:

  1. Extract rows based on only one column using R [closed]
  2. R subset based on range of dates [closed]
  3. Filter data.frame rows by a logical condition
  4. Select rows from a data frame based on values in a vector
  5. Why is `[` better than `subset`?
  6. Selecting data frame rows based on partial string match in a column
  7. Opposite of %in%: exclude rows with values specified in a vector
  8. How to replace NA with mean by group / subset?
  9. Filtering a data frame on a vector [duplicate]
  10. Subset rows in a data frame based on a vector of values
  11. Subset data frame based on multiple conditions [duplicate]
  12. Subsetting R data frame results in mysterious NA rows
  13. Subset of rows containing NA (missing) values in a chosen column of a data frame
  14. Subset with unique cases, based on multiple columns
  15. subset a column in data frame based on another data frame/list
  16. Using multiple criteria in subset function and logical operators
  17. Remove groups with less than three unique observations
  18. Update subset of data.table based on join
  19. dplyr – filter by group size
  20. R gotcha: logical-and operator for combining conditions is & not &&
  21. R keep rows with at least one column greater than value
  22. Subsetting data.table using variables with same name as column
  23. R: How to filter/subset a sequence of dates
  24. Subset data.frame by date
  25. Return df with a columns values that occur more than once [duplicate]
  26. How to subset a matrix with different column positions for each row? [duplicate]
  27. Subset data.table by logical column
  28. Read FASTA into a dataframe and extract subsequences of FASTA file
  29. How to pass “nothing” as an argument to `[` for subsetting?
  30. Set global object in Shiny

Leave a Comment