calculate the mean of several columns
81 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hi all, I am new to Matlab and I am struggling with this problem. I have a matrix with 112 columns and 100 rows. How can I calculate the mean of column 1-7 , 8-14, 15-21,...., 106-112 and put the a new matrix with 16 columns and 100 rows. I appreciate your help Sobhan
2 commentaires
Andrei Bobrov
le 5 Avr 2012
eg
A = rand(100,112);
fun = @(block_struct)mean(block_struct.data,2);
out = blockproc(A,[100,7],fun);
Réponse acceptée
Wayne King
le 4 Avr 2012
One way is simply with a for loop
A = randn(100,112);
for nn = 0:15
B(:,nn+1) = mean(A(:,nn*7+1:(nn+1)*7),2);
end
1 commentaire
Oleg Komarov
le 4 Avr 2012
I bet this is more efficient than the one liner and definitely more readable.
Plus de réponses (3)
Oleg Komarov
le 4 Avr 2012
A = rand(100,112);
B = reshape(mean(reshape(A.',7,[])),16,100).';
% Check
isequal(mean(A(2,8:14)),B(2,2))
0 commentaires
Thomas
le 4 Avr 2012
You could reshape your matrix with 7 columns becoming 1 in the new matrix and taking the mean of each column
Eg.:
c=rand(4) % 4x4 matrix
d=reshape(c,[],2) % take two colm and form 1 total 2
p=mean(d) % mean of each columns
In your case
c=rand(100,112) % 4x4 matrix
d=mean(reshape(c,7,[])) % form 1600 columsns
final_out=(reshape(d,16,100)) % mean of each columns
3 commentaires
Oleg Komarov
le 4 Avr 2012
Now, your mean is across the first 7 rows (first column). You have to transpose and re-transpose back. Honestly, in this cases I think Waynes solution is best in terms or readability and performance.
Voir également
Catégories
En savoir plus sur Logical dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!