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?

question from:https://stackoverflow.com/questions/5204953/r-select-values-from-data-table-in-range

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