[R] Remove Rows Based on Factor

Sparks, John James jspark4 at uic.edu
Mon Apr 15 18:58:28 CEST 2013


Dear R Helpers,

I did a search for deleting rows based on conditions but wasn't able to
find an example that addressed the error that I am getting.  I am hoping
that this is a simple syntax phenomenon that somebody else knows off the
top of their head.  My apologies for not providing a reproducible example
but I think that the information given will allow someone to give me a
hint.

I want to delete the rows of the data frame ZZ where Index is earlier that
Jan 1 of 2007.  That Index column is a factor.  When I tired a couple of
different methods, I got the error shown below.  Can anybody tell me what
I am doing wrong?  I would really appreciate it.

--John Sparks

> str(ZZ)
'data.frame':   1584 obs. of  7 variables:
 $ Index   : Factor w/ 1583 levels "2006-04-07","2006-04-10",..: 1 2 3 4 5
6 7 8 9 10 ...
 $ Open    : num  17.5 17.6 16.8 17.2 17 ...
 $ High    : num  18.2 17.6 17.2 17.2 17.1 ...
 $ Low     : num  17.3 16.8 16.8 16.8 16.6 ...
 $ Close   : num  17.5 16.8 17.1 16.8 16.7 ...
 $ Volume  : num  23834500 2916000 1453700 991400 967400 ...
 $ Adjusted: num  16.8 16.2 16.4 16.2 16 ...
> test<-ZZ[ZZ$Index>"2007-01-01",]
Warning message:
In Ops.factor(ZZ$Index, "2007-01-01") : > not meaningful for factors
>
> test<-subset(ZZ,Index>2007-01-01)
Warning message:
In Ops.factor(Index, 2007 - 1 - 1) : > not meaningful for factors



More information about the R-help mailing list