Average hourly usgs data

2 次查看（过去 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 中查找有关 Shifting and Sorting Matrices 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by