I have time series GPS tracking data from a number of individuals, all with varying time between locations (i.e. certain individuals recording at 15 minutes intervals, others at 20 minutes or 1 hour). Tracking starts at sunrise and ends at sunset, omitting overnight locations. I would like to subset the data to 1 hour to make it comparable. I am currently doing this in excel although it is proving to be a rather tedious method. Is there a method in R that can speed up this process?
Excel is surely not the right way to do it. You need a software package able to associate date and time to the observations, like SAS, SPSS or Stata.
instead of using excel, you can use your own program. You can develop your program in any programming language like python, r, etc. or as Guy Melard suggested you can use SAS.
for more information and instant help, you can reach me via whatsapp at +918200713617
There is a easy way to do this in PYTHON.
The function called "resample" and "groupby" are most used function for time series analysis.
- Badges
- Science topic
- Similar topics
- Statistics
- Time Series