Selecting data frame rows based on partial string match in a column

by

I notice that you mention a function %like% in your current approach. I don’t know if that’s a reference to the %like% from “data.table”, but if it is, you can definitely use it as follows.

Note that the object does not have to be a data.table (but also remember that subsetting approaches for data.frames and data.tables are not identical):

library(data.table)
mtcars[rownames(mtcars) %like% "Merc", ]
iris[iris$Species %like% "osa", ]

If that is what you had, then perhaps you had just mixed up row and column positions for subsetting data.

If you don’t want to load a package, you can try using grep() to search for the string you’re matching. Here’s an example with the mtcars dataset, where we are matching all rows where the row names includes “Merc”:

mtcars[grep("Merc", rownames(mtcars)), ]
             mpg cyl  disp  hp drat   wt qsec vs am gear carb
# Merc 240D   24.4   4 146.7  62 3.69 3.19 20.0  1  0    4    2
# Merc 230    22.8   4 140.8  95 3.92 3.15 22.9  1  0    4    2
# Merc 280    19.2   6 167.6 123 3.92 3.44 18.3  1  0    4    4
# Merc 280C   17.8   6 167.6 123 3.92 3.44 18.9  1  0    4    4
# Merc 450SE  16.4   8 275.8 180 3.07 4.07 17.4  0  0    3    3
# Merc 450SL  17.3   8 275.8 180 3.07 3.73 17.6  0  0    3    3
# Merc 450SLC 15.2   8 275.8 180 3.07 3.78 18.0  0  0    3    3

And, another example, using the iris dataset searching for the string osa:

irisSubset <- iris[grep("osa", iris$Species), ]
head(irisSubset)
#   Sepal.Length Sepal.Width Petal.Length Petal.Width Species
# 1          5.1         3.5          1.4         0.2  setosa
# 2          4.9         3.0          1.4         0.2  setosa
# 3          4.7         3.2          1.3         0.2  setosa
# 4          4.6         3.1          1.5         0.2  setosa
# 5          5.0         3.6          1.4         0.2  setosa
# 6          5.4         3.9          1.7         0.4  setosa

For your problem try:

selectedRows <- conservedData[grep("hsa-", conservedData$miRNA), ]

More Related Contents:

  1. How to remove all whitespace from a string?
  2. Test if characters are in a string
  3. Delete rows containing specific strings in R
  4. Create new column in dataframe based on partial string matching other column
  5. Remove part of a string
  6. How to strsplit using ‘|’ character, it behaves unexpectedly?
  7. Matching multiple patterns
  8. How do I extract a single column from a data.frame as a data.frame?
  9. Subset dataframe by multiple logical conditions of rows to remove
  10. Replace single backslash in R
  11. Replace multiple strings in one gsub() or chartr() statement in R?
  12. Finding the indexes of multiple/overlapping matching substrings
  13. Reading multiple files and calculating mean based on user input
  14. How to subset data in R without losing NA rows?
  15. Using grep to help subset a data frame
  16. remove all line breaks (enter symbols) from the string using R
  17. Return data subset time frames within another timeframes?
  18. Subsetting a dataframe for a specified month and year
  19. Looping through t.tests for data frame subsets in r
  20. Delete duplicate rows in two columns simultaneously [duplicate]
  21. Filter data frame rows based on values in vector
  22. Remove all punctuation except apostrophes in R
  23. R split string by symbol
  24. Overlapping matches in R
  25. Identify records in data frame A not contained in data frame B [closed]
  26. How to remove rows of a matrix by row name, rather than numerical index?
  27. Check if string contains ONLY NUMBERS or ONLY CHARACTERS (R)
  28. How to pass “nothing” as an argument to `[` for subsetting?
  29. remove text after final period in string
  30. Efficient string similarity grouping

Leave a Comment