How to specify year range in r?

Question

I have a dataset called salaries that have yearID as a column. I would like to specify the range of the year from 2010 to 2014. How could I do that in r ? I have tried this

df <- Salaries(yearID=c(2010,2011,2012,2013,2014))

also,

salar09-05<-Salaries(yearID=c(2010:2014))

and

sqldf("select * from salaries where yearID > 2009 and date < 2015")

neither one of them work.

Did you meant `data.frame(yearID=c(2010,..`. Just do `subset(Salaries, yearID %in% 2010:2014)` — akrun, Apr 23 '16 at 16:25
yes, but I already used that in first code where my data frame is Salaries — Yahyaotaif, Apr 23 '16 at 16:26

score 2 · Answer 1 · answered Apr 23 '16 at 16:30

2

We can use subset with %in%

subset(Salaries, yearID %in% 2010:2014)

answered Apr 23 '16 at 16:30

akrun

874,273
37
540
662

Richard Telford · Accepted Answer · 2016-04-23T16:38:55.890

1

You need to use square brackets to subset.

df <- Salaries[Salaries$yearID %in% c(2010,2011,2012,2013,2014), ]

or

df <- Salaries[Salaries$yearID >= 2010 & Salaries$yearID <=2014, ]

A single "=" is an assignment operator, not a test of equality.

edited Apr 23 '16 at 16:38

answered Apr 23 '16 at 16:27

Richard Telford

9,558
6
38
51

you would need Salaries$yearID – user20650 Apr 23 '16 at 16:30
I get this error with all codes I have run: Error in `[.data.frame`(Salaries, yearID >= 2010 & yearID <= 2014, ) : object 'yearID' not found – Yahyaotaif Apr 23 '16 at 16:31
Fixed code. Needed to tell R where to find yearID – Richard Telford Apr 23 '16 at 16:39
This one worked well for me : df <- Salaries[Salaries$yearID >= 2010 & Salaries$yearID <=2014, ] – Yahyaotaif Apr 23 '16 at 16:50

How to specify year range in r?

2 Answers2