1-hour to 6-hour aggregation?

Hi all, I have rainfall data in hourly format. I want to aggregate the data to 6 hour sum data.

For ex.

01.00 5

02.00 4

03.00 6

04.00 1

05.00 9

06.00 5

the new data will be;

• 30 mm

Is it possible with matlab?

Answer 1

[Stephan]

Hi,

retime should do the job - see the example:

a = hours(1:6) + datetime('00:00','format','HH:mm');
b = [1 2 3 4 5 6];
c = timetable(a',b')
d = retime(c,'regular','sum','timestep',hours(2),'includedEdge','right')

Best regards

Stephan