Re: [R] Count observation based on hour

2014-02-08 Thread arun
Hi, Try: #using the same `data`  res1 <- as.data.frame(table(with(dat,cut(Date,breaks=seq(as.POSIXct("2013-01-01 00:00:00"),max(Date)+3600,by='1 hour') A.K. Hi A.K. Thank you very much! It worked!!  Just another quick follow-up question: res <- as.data.frame(table( with(dat,cut(Dat

Re: [R] Count observation based on hour

2014-02-06 Thread arun
HI Map, I am not sure what you really wanted.  Perhaps, this helps: dat <- structure(list(Date = c("2014-01-01 00:00:00", "2014-01-02 11:00:00", "2014-01-02 22:00:00", "2014-01-03 03:00:00", "2014-01-01 00:00:00", "2014-02-02 11:00:00", "2014-02-02 22:00:00", "2014-02-03 03:00:00", "2014-02-01

Re: [R] Count observation based on hour

2014-02-05 Thread arun
Hi, Try: data.frame(table(dat$Date)) A.K. Hi guys, I have some 20,000 observations like this:           Date       2014-01-01 00:00:00 2014-01-02 11:00:00 2014-01-02 22:00:00 2014-01-03 03:00:00 I want to perform an hourly count (e.g. the frequency occur at each hour for a specific date)