In R how to select rows from a dataframe?

Question

I have a column "Year" in my dataframe ("import") and I need to only select 2015 out of some 30 years. However none of the steps I tried worked. Things I tried include:

iy2015<-subset(import, import$year==2015)
iy2015<-import[which(import$year==2015),]
iy2015<-import[import$year==2015,]

all have given me an empty dataframe.

According to your comment on the answer below, you are using $year when it should be $Year. This is a typo and should be closed as such. — Rich Scriven
– Rich Scriven, Commented Nov 11, 2017 at 21:58
Don't use the df name and $ when using subset and noting that you say its name is "Year", then DO pay close attention to spelling. Try: iy2015<-subset(import, Year==2015) — IRTFM
– IRTFM, Commented Nov 12, 2017 at 14:59

T C Molenaar · Accepted Answer · 2017-11-11 21:58:42Z

1

For me your last option works, check if 2015 is in the column and check whether year is a column name. I used: iy2015 = import[import$Year==2015,]

EDIT:

You need to use Year instead of year.

edited Nov 11, 2017 at 21:58

answered Nov 11, 2017 at 21:54

T C Molenaar

3,2801 gold badge13 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

CWeeks Over a year ago

again I am getting an empty dataframe... here are results after I ran str(import)

CWeeks Over a year ago

'data.frame': 3809 obs. of 4 variables: $ Flow : logi TRUE TRUE TRUE TRUE TRUE TRUE ... $ Country: chr "Afghanistan" "Afghanistan" "Afghanistan" "Afghanistan" ... $ Trade : num 6.53e+09 7.72e+09 7.70e+09 8.55e+09 6.20e+09 ... $ Year : num 2016 2015 2014 2013 2012 ...

T C Molenaar Over a year ago

Does import$Year==2015 give a sequence with only one TRUE value?

Collectives™ on Stack Overflow

In R how to select rows from a dataframe?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related