[R] Failure to aggregate

[Dimitri Shvorob]

I have a (very big - 1.5 rows) dataframe with a (POSIXt"  "POSIXlt") column h
(hour). Surprisingly, I cannot calculate a simple aggregate over the
dataframe.

> n.h1 = sqldf("select distinct h, count(*) from x group by h")
Error in sqliteExecStatement(con, statement, bind.data) : 
  RS-DBI driver: (error in statement: no such table: x)
In addition: Warning message:
In value[[3L]](cond) : RAW() can only be applied to a 'raw', not a 'double'

> n.h2 = aggregate(x$price, by = x$h, FUN = nrow)
Error in names(y) <- c(names(by), names(x)) : 
  'names' attribute [10] must be the same length as the vector [2]

Arrgh...
-- 
View this message in context: http://r.789695.n4.nabble.com/Failure-to-aggregate-tp2528613p2528613.html
Sent from the R help mailing list archive at Nabble.com.