Re: [R] Count observation based on hour

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(

Re: [R] Count observation based on hour

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 00:00:00,

Re: [R] Count observation based on hour

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