Average hourly usgs data

5 次查看（过去 30 天）
Sergio
Sergio 2013-9-1
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
  2 个评论
Sergio
Sergio 2013-9-1
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

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2013-9-1
编辑：Azzi Abdelmalek 2013-9-1
You can do interpolation with interp1 function
  2 个评论
Sergio
Sergio 2013-9-1
thank you Azzi, I'm working on using Accumarray and if that does not work I'll try interp1.
Azzi Abdelmalek
Azzi Abdelmalek 2013-9-1
%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)

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 MATLAB 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by