Skip to content
Prev 6311 / 7419 Next

Halyomorpha halys; observation time-series irregular: regularized weekly capture rates

Hello
I'm looking at if and how to find support with paid computer scientists
because it is not possible for an agricultural technician in the midst
of activities in the field, who does not know how to use R
solve this problem also through a mailing-list.
However it is right to complete the description of the problem, maybe
you have ideas that I will give to the computer scientists that we will
pay with the project
so I am not asking here for the solution, but only for ideas.

This is an data example (really)
datetime	capture
2021-05-15 14:09:00	15
2021-05-16 10:34:00	2
2021-05-20 15:00:00	3
2021-05-23 08:30:00	23
2021-05-29 07:30:00	30
2021-05-29 19:00:00	25
2021-06-01 19:00:00	23
2021-06-05 12:52:00	92
2021-06-05 19:00:00	5

This is the results of two possibile solution
week		simple SUM week 	right SUM week
19	17	19,44027778
20	26	52,91388889
21	55	46,4375
22	120	99,20833333

simple is done with a simple sum by aggregate with weeknum
right is done with a it is done with the calculation of the ratio
between catches and time interval
but this is done with a spreadsheet, but in order to automate the
generation of an html graph on the project server page, I need to do
this with R

I tested the xts package, and then I found lubridate and padr
interesting, but I stopped due to lack of time