how to calculating hourly average?

Hi all, I have an observed (obs) data those were tooke every 6 min and the predicted (pred) data were recorded every 1 hr I want to take the average hour to calculate the residusl (r) by taking an obs. every 10 values corresponding to 1 value in the pred. those are also including NaN values (obs)
anyone can help me I will approciate it
thank you

 采纳的回答

v=randi(9,1,55) % Example
n=ceil(numel(v)/10)*10
v(end+1:n)=nan
a=reshape(v,10,[])
idx=~isnan(a)
for k=1:size(a,2)
out(k)=sum(a(idx(:,k),k))/sum(idx(:,k))
end
Or
v=randi(9,1,55) % Example
n=ceil(numel(v)/10)*10
v(end+1:n)=nan
a=reshape(v,10,[])
out=nanmean(a)

3 个评论

pardon Mr. Azzi can you give me more explanation thank
Run the code line by line, and see the result of each line; you will understand
ok thank you there is one thing please if I want plot the new matrix with the predicted I just only take (a) corresponding to pred matrix?

请先登录,再进行评论。

更多回答(0 个)

类别

在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by