I %like% data.tables
%like%
is a very useful function to filter rows from data.table
s that match a pattern, as opposed to exact matches as seen in the previous exercise. It can be used independently on a vector as well, for example:
x <- c("aaba", "aaba", "baca")
# Search for "aa" anywhere in the string
x %like% "aa"
[1] TRUE TRUE FALSE
# Search for "ba" at the end of a string
x %like% "ba$"
[1] TRUE TRUE FALSE
The metacharacter $
indicates that you are searching for the string that ends with a specific pattern.
This exercise is part of the course
Data Manipulation with data.table in R
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Filter all rows where end_station contains "Market"
any_markets <- batrips[___]
any_markets