r tibble select rows containing string
dplyr::filter(df, !grepl("RTB",TrackingPixel))
3.71
7
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
Thank you!
7
0
Are there any code examples left?
New code examples in category R
-
R 2022-03-27 14:00:12 R total line text file
-
R 2022-03-27 13:40:24 reduce ggtitle size
-
R 2022-03-23 02:05:30 r merge inner join
-
R 2022-03-21 19:20:02 combine columns in r
-
R 2022-03-16 11:05:16 ggplot box plot without outliers poins
-
R 2022-03-13 03:05:04 calculated defualt values in R function parameters
-
R 2022-03-12 21:55:01 r rename columns
-
R 2022-03-08 02:25:18 r - transform as factor
-
R 2022-03-06 02:50:06 create a dataframe with column names in r