/R/R tibble select rows containing string

R tibble select rows containing string

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

Source: stackoverflow.com

Using like filter dplyr

library(rbenchmark)
library(tidyverse)

# The data. Data expo 09. ASA Statistics Computing and Graphics 
# http://stat-computing.org/dataexpo/2009/the-data.html
df <- read_csv("Downloads/2008.csv")
print(dim(df))
# [1] 7009728      29

benchmark(
  "str_detect" = {df %>% filter(str_detect(Dest, 'MCO|BWI'))},
  "grepl" = {df %>% filter(grepl('MCO|BWI', Dest))},
  replications = 10,
  columns = c("test", "replications", "elapsed", "relative", "user.self", "sys.self"))
# test replications elapsed relative user.self sys.self
# 2      grepl           10  16.480    1.513    16.195    0.248
# 1 str_detect           10  10.891    1.000     9.594    1.281

Source: stackoverflow.com

Similar codes

-2 votes369 views2 answers
What percentage of the row will the following column occupy on desktop devices: <div class="col-xs-3 col-sm-4 col-md-6 col-lg-12"></div>
R
1 vote385 views1 answer
Sort in descending order in r
R
0 vote388 views1 answer
Emf from r plot
R
1 vote342 views1 answer
Select all columns except one by name in r
R
0 vote362 views1 answer
Filter na in r
R
1 vote399 views1 answer
R change a single value in a dataframe
R
10 votes510 views3 answers
R replace na with 0
R
1 vote351 views1 answer
R return index of rows that have NA in dataframe
R
0 vote369 views1 answer
Select last child with class in r
R
0 vote321 views3 answers
How to throw an error in R
R