Filter rows which contain a certain string

The answer to the question was already posted by the @latemail in the comments above. You can use regular expressions for the second and subsequent arguments of filter like this:

dplyr::filter(df, !grepl("RTB",TrackingPixel))

Since you have not provided the original data, I will add a toy example using the mtcars data set. Imagine you are only interested in cars produced by Mazda or Toyota.

mtcars$type <- rownames(mtcars)
dplyr::filter(mtcars, grepl('Toyota|Mazda', type))

   mpg cyl  disp  hp drat    wt  qsec vs am gear carb           type
1 21.0   6 160.0 110 3.90 2.620 16.46  0  1    4    4      Mazda RX4
2 21.0   6 160.0 110 3.90 2.875 17.02  0  1    4    4  Mazda RX4 Wag
3 33.9   4  71.1  65 4.22 1.835 19.90  1  1    4    1 Toyota Corolla
4 21.5   4 120.1  97 3.70 2.465 20.01  1  0    3    1  Toyota Corona

If you would like to do it the other way round, namely excluding Toyota and Mazda cars, the filter command looks like this:

dplyr::filter(mtcars, !grepl('Toyota|Mazda', type))

Related Posts:

  1. How do I select the first row in an R data frame that meets certain criteria?
  2. Poker hand range chart visualization in R
  3. Error in plot.new() : figure margins too large, Scatter plot
  4. How to join (merge) data frames (inner, outer, left, right)
  5. rbind error: “names do not match previous names”
  6. rbind error: “names do not match previous names”
  7. $ operator is invalid for atomic vectors for dataframe R
  8. adding x and y axis labels in ggplot2
  9. Set NA to 0 in R
  10. R: Using equation with natural logarithm in nls
  11. kmeans complains “NA/NaN/Inf in foreign function call (arg 1)”, when there are none?
  12. Why use as.factor() instead of just factor()
  13. Update R using RStudio
  14. mean() warning: argument is not numeric or logical: returning NA
  15. ‘x’ and ‘y’ lengths differ ERROR when plotting
  16. What does “Error: object ‘‘ not found” mean?
  17. mean() warning: argument is not numeric or logical: returning NA
  18. Difference between paste() and paste0()
  19. How do I delete rows in a data frame?
  20. Error in grid.Call(L_textBounds, as.graphicsAnnot(x$label), x$x, x$y, : Polygon edge not found
  21. Drop data frame columns by name
  22. Having trouble setting working directory
  23. How to find the statistical mode?
  24. How can two strings be concatenated?
  25. Error in colMeans(x, na.rm = TRUE) : ‘x’ must be numeric in KNN classification
  26. Error in ggplot.data.frame : Mapping should be created with aes or aes_string
  27. SummarySE (Rmisc package) to produce a barplot with error bars (ggplot2)
  28. Remove a row from a data table in R
  29. Add color to boxplot – “Continuous value supplied to discrete scale” error
  30. Error in plot.window(…) : need finite ‘xlim’ valuescc
  31. “Error: Continuous value supplied to discrete scale” in default data set example mtcars and ggplot2
  32. Logistic Regression on factor: Error in eval(family$initialize) : y values must be 0 <= y <= 1
  33. Error: Incorrect number of dimensions in R
  34. cannot coerce type ‘closure’ to vector of type ‘character’
  35. Basic – T-Test -> Grouping Factor Must have Exactly 2 Levels
  36. Error: attempt to use zero-length variable name
  37. How does one reorder columns in a data frame?
  38. R error: cannot coerce type ‘closure’ to vector of type ‘double’
  39. Error in lm.fit(x, y, offset = offset, singular.ok = singular.ok, …) : NA/NaN/Inf in ‘y’, tried every possible way
  40. scale_color_manual() not working
  41. Error in lm.fit(x, y, offset = offset, singular.ok = singular.ok, …) 0 non-na cases
  42. Clear R environment of all objetcs & packages
  43. Why I get this error writing data to a file
  44. How to save a data frame as CSV to a user selected location using tcltk
  45. Plot a line graph, error in xy.coords(x, y, xlabel, ylabel, log) : ‘x’ and ‘y’ lengths differ
  46. Subscript out of bounds – general definition and solution?
  47. R: Error in eval(predvars, data, env) : numeric ‘envir’ arg not of length one in intrinsic.pars() in multgee package
  48. Calculate correlation for more than two variables?
  49. Convert a list to a data frame
  50. What does the double percentage sign (%%) mean?
  51. How to subset a Data frame column wise using column names?
  52. Create an empty data.frame
  53. Error : length of ‘dimnames’ [2] not equal to array extent
  54. Can’t draw Histogram, ‘x’ must be numeric
  55. How can I plot data with confidence intervals?
  56. MLE error in R: initial value in ‘vmmin’ is not finite
  57. Rename multiple columns by names
  58. Unimplemented type list when trying to write.table
  59. Remove rows with all or some NAs (missing values) in data.frame
  60. Subscript out of bounds – general definition and solution?
  61. Convert date-time string to class Date
  62. Reshaping data.frame from wide to long format
  63. How to set limits for axes in ggplot2 R plots?
  64. duplicate ‘row.names’ are not allowed error
  65. predict.lm() in a loop. warning: prediction from a rank-deficient fit may be misleading
  66. Convert categorical variables to numeric in R
  67. How to sum data.frame column values?
  68. How do I get RSS from a linear model output
  69. Warning message: In `…` : invalid factor level, NA generated
  70. Mean of a column in a data frame, given the column’s name
  71. What does “The following object is masked from ‘package:xxx'” mean?
  72. grep using a character vector with multiple patterns
  73. How to avoid “Error in stripchart.default(x1, …) : invalid plotting method” error?
  74. ‘height’ must be a vector or a matrix. barplot error
  75. install.packages fails in knitr document: “trying to use CRAN without setting a mirror”
  76. Unused arguments in R
  77. How to convert a data frame column to numeric type?
  78. Optimization of a function in R ( L-BFGS-B needs finite values of ‘fn’)
  79. Error: ggplot2 doesn’t know how to deal with data of class matrix?
  80. Error in file(filename, “r”, encoding = encoding) : cannot open the connection
  81. What is integer overflow in R and how can it happen?
  82. R histogram range error: some ‘x’ not counted; maybe ‘breaks’ do not span range of ‘x
  83. Error in contrib.url(repos, “source”) in R trying to use CRAN without setting a mirror Calls: install.packages -> contrib.url Execution halted
  84. Error in : target of assignment expands to non-language object
  85. run a for loop in parallel in R
  86. How do I combine two data-frames based on two columns?
  87. Efficiently sum across multiple columns in R
  88. How to eliminate “NA/NaN/Inf in foreign function call (arg 7)” running predict with randomForest
  89. Indicator function in R
  90. IF “OR” multiple conditions
  91. R4DS error comparison (1) is possible only for atomic and list types
  92. Error in x[[i]] : recursive indexing failed at level 2
  93. non-numeric argument to binary operator
  94. How to avoid “operations are possible only for numeric, logical or complex types” when computing top 3 elements in each group
  95. Warning: non-integer #successes in a binomial glm! (survey packages)
  96. Column standard deviation R [duplicate]
  97. Difference between as.POSIXct/as.POSIXlt and strptime for converting character vectors to POSIXct/POSIXlt
  98. invalid (do_set) left-hand side to assignment in R
  99. How do I print a hexadecimal number with leading 0 to have width 2 using sprintf?
  100. In R, dealing with Error: ggplot2 doesn’t know how to deal with data of class numeric

Leave a Comment