Get startedGet started for free

I %like% data.tables

%like% is a very useful function to filter rows from data.tables 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

View Course

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
Edit and Run Code