averaging

I have a matrix composed of 12 columns representing depths from 1 to 12 and I have thousands of rows which represent 2 minute intervals at which the measurements were taken. how could I change the values to show hourly averages? As in average every 30 rows! I've tried using reshape to do this but cant get my head around it.
thanks

回答(3 个)

Andrei Bobrov
Andrei Bobrov 2011-11-9
d=randi(127,90,12);
out = squeeze(mean(reshape(d.',size(d,2),30,[]),2)).';
or
n = 30;
a = zeros(size(d)./[n 1]);
k1 = (n-1:-1:0);
for j1 = 1:size(d,1)/n
k = j1*n - k1;
a(j1,:) = mean(d(k,:));
end
or 2
out2 = blockproc(d,[30, size(d,2)],@(block_struct)mean(block_struct.data))
Fangjun Jiang
Fangjun Jiang 2011-11-9
d=rand(90,12);
[M,N]=size(d);
e=mat2cell(d,30*ones(M/30,1),N);
f=cellfun(@mean,e,'uni',false);
g=cell2mat(f);
ricco
ricco 2011-11-10

0 个投票

both work perfect, thanks.

类别

帮助中心File Exchange 中查找有关 NaNs 的更多信息

标签

提问:

2011-11-9

Community Treasure Hunt

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

Start Hunting!

Translated by