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  gt  5 AND date  lt  15  What is the equivalent in R  to select rows based on the range of values in a particular column

User · Accepted Answer

Construct some data     df  lt - 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 gt 4  amp  date lt 6     name date 2 Adam    5   The following syntax produces identical results   df df date gt 4  amp  df date lt 6       name date 2 Adam    5

User · Answer

Lots of options here  but one of the easiest to follow is subset  Consider    gt  set seed 43   gt  df  lt - data frame name   sample letters  100  TRUE   date   sample 1 500  100  TRUE    gt    gt  subset df  date  gt  5  amp  date  lt  15     name date 11    k   10 67    y   12 86    e    8   You can also insert logic directly into the index for your data frame  The comma separates the rows from columns  We just have to remember that R indexes rows first  then columns  So here we are saying rows with date   5  amp   lt  15 and then all columns   df df date  gt  5  amp  df date  lt  15      I d also recommend checking out the help pages for subset   subset and the logical operators    amp

User · Answer

One should also consider another intuitive way to do this using filter   from dplyr  Here are some examples   set seed 123  df  lt - data frame name   sample letters  100  TRUE                    date   sample 1 500  100  TRUE   library dplyr  filter df  date  lt  50    date less than 50 filter df  date  in  50 100    date between 50 and 100 filter df  date  in  1 50  amp  name     r     date between 1 and 50 AND name is  r  filter df  date  in  1 50   name     r     date between 1 and 50 OR name is  r     You can also use the pipe    gt    operator df   gt   filter date  in  1 50   name     r

[r] R: Select values from data table in range

Examples related to r