How to calculate the average without taking zeros values?

140 次查看（过去 30 天）
afrya
afrya 2013-12-12
评论： Dongpeng Lin 2019-12-3
Hi, I have a large data list which has this form:
Y=
1 2 4 5 6 7 0 0 0 8 9 0 0 0 0... AVerage1=5.25
2 3 4 5 6 7 0 0 0 8 0 0 0 9 0... Average2=5.5
3 4 5 6 7 8 9 0 0 0 0 0 0 0 0... Average3=6
.
.
.
I would like to calculate the average of each row wihout taking zeros values.
Thanks in advance

请先登录，再回答此问题。

采纳的回答

Andrei Bobrov
Andrei Bobrov 2013-12-13
[ii,~,v] = find(Y);
out = accumarray(ii,v,[],@mean);
  4 个评论
显示 2更早的评论

请先登录，再进行评论。

更多回答（3 个）

Jos (10584)
Jos (10584) 2013-12-13
编辑：Jos (10584) 2013-12-13
No need of a loop:
A = [1 2 3 ; 10 0 30 ; 9 0 0]
rowMean = sum(A,2) ./ sum(A~=0,2)
Note that zeros do not contribute to sum(A) …
  4 个评论
显示 2更早的评论

请先登录，再进行评论。

Simon
Simon 2013-12-12
Hi!
for n = 1:size(Y, 1)
Average(n) = mean(Y(n, (Y(n, :) ~= 0)));
end
Mech Princess
Mech Princess 2019-3-5
mean(nonzeros(X))
Y=[1 2 4 5 6 7 0 0 0 8 9 0 0 0 0; ...
2 3 4 5 6 7 0 0 0 8 0 0 0 9 0;...
3 4 5 6 7 8 9 0 0 0 0 0 0 0 0];
for i=1:3
mean(nonzeros(Y(i,:)))
end

类别

在 Help Center 和 File Exchange 中查找有关 Resizing and Reshaping Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by