thr3ads.net - R help - [R] Need guidance on summarizing time data [Nov 2020]

If this information is useful, please help other people find it:
Share via:

Neotropical bat risk assessments and acoustic tools

2020-Nov-30 15:48 UTC

[R] Need guidance on summarizing time data

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??? Time
156??? 2/25/2008??? 18:31
156??? 2/25/2008??? 18:31
156??? 2/25/2008??? 18:32
156??? 2/25/2008??? 18:35
156??? 2/25/2008??? 18:38
156??? 2/25/2008??? 18:41
156??? 2/25/2008??? 18:42
156??? 2/25/2008??? 18:43
156??? 2/25/2008??? 18:43
156??? 2/25/2008??? 18:55
156??? 2/25/2008??? 18:56
156??? 2/25/2008??? 18:56
156??? 2/26/2008??? 18:35
156??? 2/26/2008??? 18:35
156??? 2/26/2008??? 18:35
156??? 2/26/2008??? 18:35
196??? 7/16/2006??? 4:47
250??? 4/9/2004??? 18:41
250??? 4/9/2004??? 18:44
253??? 3/5/2004??? 18:30
1268??? 2/11/2001??? 18:39
1268??? 2/11/2001??? 18:39
1344??? 4/17/2003??? 19:06
1409??? 2/28/2004??? 5:51
...etc. for 10,390 rows of data.

I am aiming for a summary by times for all of the data such that I have 
total number of "events" or count for each time period. So something
like

18:31 41
18:32 38

and so on.

So a "simple" count of the time occurrences.

I tried to do a summary running frequencies
descriptive.table(vars = d(Time) ,
+ strata = d(Date),data= Active,
+ func.names =c("Valid N","Minimum","Maximum"))


Warning message:
In descriptive.table(vars = d(Time), strata = d(Date), data = Active,? :
 ? Non-numeric variables dropped from descriptive table
 > Active[,3]<-as.POSIXct(Active[,3], format='%m-%d-%y %H:%M:%S')
 > Active[,2]<-as.Date(Active[,2], format= '%m/%d/%y')
 > frequencies(Active[c("Time")] , r.digits = 1)
Error in names(x) <- value :
 ? 'names' attribute [4] must be the same length as the vector [3]

Suggestions welcomed.

Cheers all

-- 
Bruce W. Miller, PhD.
Neotropical bat risk and acoustic assessments
Conservation Fellow - Wildlife Conservation Society
Research Associate, American Museum of Natural History

If we lose the bats, we may lose much of the tropical vegetation and the lungs
of the planet

Using acoustic sampling to identify and map species distributions
and pioneering acoustic tools for ecology and conservation of bats for >25
years.

Key projects include providing free interactive identification keys and call
fact sheets for the vocal signatures of New World Bats

Thierry Onkelinx

2020-Nov-30 16:01 UTC

head link

[R] Need guidance on summarizing time data

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 Flanders
INSTITUUT VOOR NATUUR- EN BOSONDERZOEK / RESEARCH INSTITUTE FOR NATURE AND
FOREST
Team Biometrie & Kwaliteitszorg / Team Biometrics & Quality Assurance
thierry.onkelinx at inbo.be
Havenlaan 88 bus 73, 1000 Brussel
www.inbo.be

///////////////////////////////////////////////////////////////////////////////////////////
To call in the statistician after the experiment is done may be no more
than asking him to perform a post-mortem examination: he may be able to say
what the experiment died of. ~ Sir Ronald Aylmer Fisher
The plural of anecdote is not data. ~ Roger Brinner
The combination of some data and an aching desire for an answer does not
ensure that a reasonable answer can be extracted from a given body of data.
~ John Tukey
///////////////////////////////////////////////////////////////////////////////////////////

<https://www.inbo.be>


Op ma 30 nov. 2020 om 16:48 schreef Neotropical bat risk assessments and
acoustic tools <neotropical.bats at gmail.com>:
> 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    Time
> 156    2/25/2008    18:31
> 156    2/25/2008    18:31
> 156    2/25/2008    18:32
> 156    2/25/2008    18:35
> 156    2/25/2008    18:38
> 156    2/25/2008    18:41
> 156    2/25/2008    18:42
> 156    2/25/2008    18:43
> 156    2/25/2008    18:43
> 156    2/25/2008    18:55
> 156    2/25/2008    18:56
> 156    2/25/2008    18:56
> 156    2/26/2008    18:35
> 156    2/26/2008    18:35
> 156    2/26/2008    18:35
> 156    2/26/2008    18:35
> 196    7/16/2006    4:47
> 250    4/9/2004    18:41
> 250    4/9/2004    18:44
> 253    3/5/2004    18:30
> 1268    2/11/2001    18:39
> 1268    2/11/2001    18:39
> 1344    4/17/2003    19:06
> 1409    2/28/2004    5:51
> ...etc. for 10,390 rows of data.
>
> I am aiming for a summary by times for all of the data such that I have
> total number of "events" or count for each time period. So
something like
>
> 18:31 41
> 18:32 38
>
> and so on.
>
> So a "simple" count of the time occurrences.
>
> I tried to do a summary running frequencies
> descriptive.table(vars = d(Time) ,
> + strata = d(Date),data= Active,
> + func.names =c("Valid
N","Minimum","Maximum"))
>
>
> Warning message:
> In descriptive.table(vars = d(Time), strata = d(Date), data = Active,  :
>    Non-numeric variables dropped from descriptive table
>  > Active[,3]<-as.POSIXct(Active[,3], format='%m-%d-%y
%H:%M:%S')
>  > Active[,2]<-as.Date(Active[,2], format= '%m/%d/%y')
>  > frequencies(Active[c("Time")] , r.digits = 1)
> Error in names(x) <- value :
>    'names' attribute [4] must be the same length as the vector [3]
>
> Suggestions welcomed.
>
> Cheers all
>
> --
> Bruce W. Miller, PhD.
> Neotropical bat risk and acoustic assessments
> Conservation Fellow - Wildlife Conservation Society
> Research Associate, American Museum of Natural History
>
> If we lose the bats, we may lose much of the tropical vegetation and the
> lungs of the planet
>
> Using acoustic sampling to identify and map species distributions
> and pioneering acoustic tools for ecology and conservation of bats for
>25
> years.
>
> Key projects include providing free interactive identification keys and
> call fact sheets for the vocal signatures of New World Bats
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>
	[[alternative HTML version deleted]]

Jeff Newmiller

2020-Nov-30 16:04 UTC

head link

[R] Need guidance on summarizing time data

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. If you have lat/lon and timezone then the maptools
package can estimate local sun position from datetime.

On November 30, 2020 7:48:00 AM PST, Neotropical bat risk assessments and
acoustic tools <neotropical.bats at gmail.com>
wrote:>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??? Time
>156??? 2/25/2008??? 18:31
>156??? 2/25/2008??? 18:31
>156??? 2/25/2008??? 18:32
>156??? 2/25/2008??? 18:35
>156??? 2/25/2008??? 18:38
>156??? 2/25/2008??? 18:41
>156??? 2/25/2008??? 18:42
>156??? 2/25/2008??? 18:43
>156??? 2/25/2008??? 18:43
>156??? 2/25/2008??? 18:55
>156??? 2/25/2008??? 18:56
>156??? 2/25/2008??? 18:56
>156??? 2/26/2008??? 18:35
>156??? 2/26/2008??? 18:35
>156??? 2/26/2008??? 18:35
>156??? 2/26/2008??? 18:35
>196??? 7/16/2006??? 4:47
>250??? 4/9/2004??? 18:41
>250??? 4/9/2004??? 18:44
>253??? 3/5/2004??? 18:30
>1268??? 2/11/2001??? 18:39
>1268??? 2/11/2001??? 18:39
>1344??? 4/17/2003??? 19:06
>1409??? 2/28/2004??? 5:51
>...etc. for 10,390 rows of data.
>
>I am aiming for a summary by times for all of the data such that I have
>
>total number of "events" or count for each time period. So
something
>like
>
>18:31 41
>18:32 38
>
>and so on.
>
>So a "simple" count of the time occurrences.
>
>I tried to do a summary running frequencies
>descriptive.table(vars = d(Time) ,
>+ strata = d(Date),data= Active,
>+ func.names =c("Valid
N","Minimum","Maximum"))
>
>
>Warning message:
>In descriptive.table(vars = d(Time), strata = d(Date), data = Active,?
>:
> ? Non-numeric variables dropped from descriptive table
> > Active[,3]<-as.POSIXct(Active[,3], format='%m-%d-%y
%H:%M:%S')
> > Active[,2]<-as.Date(Active[,2], format= '%m/%d/%y')
> > frequencies(Active[c("Time")] , r.digits = 1)
>Error in names(x) <- value :
> ? 'names' attribute [4] must be the same length as the vector [3]
>
>Suggestions welcomed.
>
>Cheers all
-- 
Sent from my phone. Please excuse my brevity.

R help - Nov 2020 - Need guidance on summarizing time data

[R] Need guidance on summarizing time data

[R] Need guidance on summarizing time data

[R] Need guidance on summarizing time data