Hourly observation for date/time?

2 views (last 30 days)
aa
aa on 13 Mar 2021
Hi everyone,
I have two data-time (formate YYYY-MM-DDTHH:MM:SS) data sets (date-set 1: consists of 164 observations, data-set2: consists of 145000 observations). Each value indicates one observation for both the data sets. I need to calculate the hourly number of observations in data-set 2 (for 2, 6, 12, 24, and 72 hours before and after) corresponding to each value of data-set1. For example, the first observation of data-set 1 is 2015-2-13T19:30:12, I need to calculate the 2 hourly observations in data-set 2 i.e. 2015-02-13T17:30:12, 2015-02-13T18:30:12 and 015-02-13T19:30:12, 13T20:30:12 and so on.
```
0 2015-2-13T19:30:12
1 2015-2-16T23:38:28
.. ...
162 2021-2-10T14:5:56
163 2021-2-13T14:40:50
Time
0 2015-1-22T0:0:27.54
1 2015-1-22T0:8:58.89
... ...
145259 2021-2-28T10:0:35.97
145260 2021-2-28T13:58:12.49

Answers (0)

Categories

Find more on Statistics and Machine Learning Toolbox in Help Center and File Exchange

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!