1. Learn
    2. /
  2. Courses
    3. /
  3. Data Manipulation with data.table in R

Exercise

Filtering with %between% and %chin%

Two other functions that can come in handy when filtering rows are %between% and %chin%.

  • %between% works only on numeric columns and can be used to filter values in the closed interval [val1, val2].
  • %chin% works only on character columns and is an efficient version of %in%. You can use it to look for specific strings in a vector.

Instructions 1/2

undefined XP
  • 1

    Use %between% to filter all rows where duration is between [5000, 6000].

  • 2

    Use %chin% to filter all rows where start_station is either "San Francisco City Hall" or "Embarcadero at Sansome".