Hourly observation for date/time?

1 view (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)

Tags

Community Treasure Hunt

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

Start Hunting!