Using grep to help subset a data frame

by

It’s pretty straightforward using [ to extract:

grep will give you the position in which it matched your search pattern (unless you use value = TRUE). 

grep("^G45", My.Data$x)
# [1] 2

Since you’re searching within the values of a single column, that actually corresponds to the row index. So, use that with [ (where you would use My.Data[rows, cols] to get specific rows and columns).

My.Data[grep("^G45", My.Data$x), ]
#      x y
# 2 G459 2

The help-page for subset shows how you can use grep and grepl with subset if you prefer using this function over [. Here’s an example.

subset(My.Data, grepl("^G45", My.Data$x))
#      x y
# 2 G459 2

As of R 3.3, there’s now also the startsWith function, which you can again use with subset (or with any of the other approaches above). According to the help page for the function, it’s considerably faster than using substring or grepl.

subset(My.Data, startsWith(as.character(x), "G45"))
#      x y
# 2 G459 2

More Related Contents:

  1. Filter data.frame rows by a logical condition
  2. Subset data frame based on number of rows per group
  3. Opposite of %in%: exclude rows with values specified in a vector
  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 do I extract a single column from a data.frame as a data.frame?
  7. Subset dataframe by multiple logical conditions of rows to remove
  8. Filtering a data frame on a vector [duplicate]
  9. Subset data frame based on multiple conditions [duplicate]
  10. Subset of rows containing NA (missing) values in a chosen column of a data frame
  11. dplyr – filter by group size
  12. How to subset data in R without losing NA rows?
  13. Filter data frame rows based on values in vector
  14. Selecting columns in R data frame based on those *not* in a vector
  15. Return df with a columns values that occur more than once [duplicate]
  16. Undefined columns selected when subsetting data frame
  17. Drop unused factor levels in a subsetted data frame
  18. Select rows from a data frame based on values in a vector
  19. How to convert dataframe into time series?
  20. Merge unequal dataframes and replace missing rows with 0
  21. Collapse rows with overlapping ranges
  22. Removing display of row names from data frame
  23. Add extra level to factors in dataframe
  24. Dataframe create new column based on other columns
  25. What is about the first column in R’s dataset mtcars?
  26. finding close match from data frame 1 in data fame 2
  27. Combine several data frames in the global environment by row (rbind)
  28. Extract text after “/” in a data frame column
  29. use multiple columns as variables with sapply
  30. Count number of non-NA values for every column in a dataframe [duplicate]

Leave a Comment