MATLAB: How to calculating hourly average

mean

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

Best Answer

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)
Related Question