Re: [R] Need guidance on summarizing time data

2020-11-30 Thread Jeff Newmiller
Does table(DF$Time) do what you want? Seems kinda odd to me that you want to distinguish between 18:31 and 18:32 but you don't care which days those occur on. If your phenomenon is related to local time-of-day then perhaps you might want to correlate with sun elevation relative to the horizon.

Re: [R] Need guidance on summarizing time data

2020-11-30 Thread Thierry Onkelinx via R-help
Dear Bruce, I think this should be straightforward with tidyverse. If not please provide a small reproducible data set with dput(). library(tidyverse) count(Active, Time) count(Active, Date, Time) Best regards, ir. Thierry Onkelinx Statisticus / Statistician Vlaamse Overheid / Government of Fl

[R] Need guidance on summarizing time data

2020-11-30 Thread Neotropical bat risk assessments and acoustic tools
Hi all, I need to summarize temporal activity. However date\times in R seem to be not easily handled. Seems I may need to convert date\time values to a recognizable format? My "raw data" is tab (text) includes a location ID, date and time(24 hr format). Format is like this: Location    Date