Average hourly usgs data

HI,

I have a 15-minute dataset that I want to average hourly. The dataset contains 15 minute flow measurement from a USGS gage. There are some data missing so the time step is not consistent.

Thank you and happy labor day weekend!

SDH

[Azzi Abdelmalek]

This is not clear

[Sergio]

Hi Azzi,

I have a precipitation dataset from the USGS at a predominantly 15-minute interval. There are some gaps in the dataset. Like for example I have data for 1:15, 1:30 but then instead of 1:45 it would skip that to 2:00 and follow with 2:15. This happens a couple of times. How can I average the 15-minute dataset to a 60-minute dataset?

Hope this is clear enough.

SDH

Answer 1

[Azzi Abdelmalek]

You can do interpolation with interp1 function

[Sergio]

thank you Azzi, I'm working on using Accumarray and if that does not work I'll try interp1.

[Azzi Abdelmalek]

%Example

%Example
t={'08:00' '08:15' '08:45' '09:15' '10:00'}
y=[10 20 30 40 50]
%-----------------------------------------------------------
ti=cellstr(datestr(datenum(0,0,0,8,(0:15:120),0),'HH:MM'))'
x=find(ismember(ti,t))
xi=1:numel(ti)
yi=interp1(x,y,xi)