subsetting in data.table

r subset data.table
exl picture exl · Mar 30, 2011 · Viewed 55k times · Source

I am trying to subset a data.table ( from the package data.table ) in R (not a data.frame). I have a 4 digit year as a key. I would like to subset by taking a series of years. For example, I want to pull all the records that are from 1999, 2000, 2001.

I have tried passing in my DT[J(year)] binary search syntax the following:

1999,2000,2001
c(1999,2000,2001)
1999, 2000, 2001

but none of these seem to work. Anyone know how to do a subset where the years you want to select are not just 1 but multiple years?

Answer

Richie Cotton picture Richie Cotton · Mar 30, 2011

What works for data.frames works for data.tables. 

subset(DT, year %in% 1999:2001)

Related questions

Subsetting data.table set by date range in R

I have a large dataset in data.table that I'd like to subset by a date range. My data set looks like this: testset <- data.table(date=as.Date(c("2013-07-02","2013-08-03","2013-09-04", "2013-10-05","2013…

Read More
How do I select rows by two criteria in data.table in R

Let's say I have a data.table and I want to select all the rows where the variable x has a value of b. That is easy library(data.table) DT <- data.table(x=rep(c("a","b","…

Read More
Apply function on a subset of columns (.SDcols) whilst applying a different function on another column (within groups)

This is very similar to a question applying a common function to multiple columns of a data.table uning .SDcols answered thoroughly here. The difference is that I would like to simultaneously apply a different function on another column which …

Read More