R: Select values from data table in range

Question

I have a data table in R:

name    date ----    ---- John    1156649280 Adam    1255701960 ...etc... 

I want to get all of the rows that have a date within a range. In SQL, I might say SELECT * FROM mytable WHERE date > 5 AND date < 15

What is the equivalent in R, to select rows based on the range of values in a particular column?

Answer 1

Construct some data

df <- data.frame( name=c("John", "Adam"), date=c(3, 5) )

Extract exact matches:

subset(df, date==3)    name date 1 John    3 

Extract matches in range:

subset(df, date>4 & date<6)    name date 2 Adam    5 

The following syntax produces identical results:

df[df$date>4 & df$date<6, ]    name date 2 Adam    5