Filtering rows using negative integers
Sometimes, instead of selecting all of the rows you want individually, it makes sense to deselect the rows you do not want to include. Recall that this can be done using either the !
or the -
operators.
For example, dt[-(1:5)]
returns all rows except the first five.
Note: dt[-(1:5)]
is equivalent to dt[!(1:5)]
.
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.
# Select all rows except the first two
not_first_two <- ___
not_first_two