Select rows from data.frame ending with a specific character string in R

by

Method 1

You can use grepl with an appropraite regular expression. Consider the following:

x <- c("blank","wade","waste","rubbish","dedekind","bated")
grepl("^.+(de|te)$",x)
[1] FALSE  TRUE  TRUE FALSE FALSE FALSE

The regular expression says begin (^) with anything any number of times (.+) and then find either de or te ((de|te)) then end ($).

So for your data.frame try,

subset(PVs,grepl("^.+(de|te)$",Word))

Method 2

To avoid the regexp method you can use a substr method instead.

# substr the last two characters and test
substr(x,nchar(x)-1,nchar(x)) %in% c("de","te")
[1] FALSE  TRUE  TRUE FALSE FALSE FALSE

So try:

subset(PVs,substr(Word,nchar(Word)-1,nchar(Word)) %in% c("de","te"))

More Related Contents:

  1. Remove all special characters from a string in R?
  2. How to calculate the number of occurrence of a given character in each row of a column of strings?
  3. Replace single backslash in R
  4. Create new column in dataframe based on partial string matching other column
  5. R/regex with stringi/ICU: why is a ‘+’ considered a non-[:punct:] character?
  6. R split on delimiter (split) keep the delimiter (split)
  7. Find the location of a character in string
  8. Is there an R function to escape a string for regex characters
  9. Remove square brackets from a string vector
  10. Overlapping matches in R
  11. Remove all characters before a period in a string
  12. How to measure similarity between strings?
  13. Split data frame string column into multiple columns
  14. Extracting numbers from vectors of strings
  15. Regex to match string containing two names in any order
  16. Selecting data frame rows based on partial string match in a column
  17. Convert data.frame column format from character to factor
  18. Regex how to match an optional character
  19. R – gsub replacing backslashes
  20. Escaped Periods In R Regular Expressions
  21. R dplyr: rename variables using string functions
  22. Find numbers after specific text in a string with RegEx
  23. regex for preserving case pattern, capitalization
  24. Regex empty string or email
  25. Regular expression to find two strings anywhere in input
  26. Are there raw strings in R for regular expressions?
  27. extract number after specific string
  28. Replace string only once with php preg_replace
  29. Get Twitter @Username with Regex in R
  30. Extracting text after last period in string [duplicate]

Leave a Comment