Re: [R] finding events in a time duration.

2011-09-07 Thread Vineet Shukla
Hi Jeff, My question is not related with SQL. I have all the data available in a csv file. I am looking for R algorithm where can specify a time period and then R essentially uses this time period as a sliding window for all the event-time stamps and gives a significant distribution of occ

Re: [R] finding events in a time duration.

2011-09-07 Thread R. Michael Weylandt
I think (no promises) roll.apply() from the zoo package with sum can count occurrences in whatever time period. Then use a logical test to identify sufficiently active periods. Hope this helps, Michael Weylandt On Sep 7, 2011, at 4:07 PM, Vineet Shukla wrote: > Hi, > > Premises: I have a d

Re: [R] finding events in a time duration.

2011-09-07 Thread Jeff Newmiller
You could phrase this in most dialects of SQL, but you don't say what kind of database you are using and this is not a SQL help list. You could also look at the rollapply function in the zoo package. --- Jeff Newmiller The ..

[R] finding events in a time duration.

2011-09-07 Thread Vineet Shukla
Hi, Premises: I have a database which contain the list of events and their time stamps (This is a Unix time stamps) What I want to do : I want know how much is the maximum occurrence of this in any a time period of 7 days or does a event occur es more than "N" (say 5) times in a period of 7 days