How to calculate the average without taking zeros values?

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

Answer 1

[Andrei Bobrov]

[ii,~,v] = find(Y);
out = accumarray(ii,v,[],@mean);

[afrya]

Thanks

[Frederik Mitev]

Thank you sir! You have just saved us a lot of time in this school project.

[Guanting SU]

This worked out really well!

[Dongpeng Lin]

Thank God

Answer 2

[Jos (10584)]

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) …

[afrya]

Thanks

[David Du]

Very smart idea

[Jan]

+1: Easy and efficient.

[Alvaro Espinoza Hernández]

Excellent!!!! Thanks

Answer 3

[Simon]

Hi!

for n = 1:size(Y, 1)
  Average(n) = mean(Y(n, (Y(n, :) ~= 0)));
end

[afrya]

thank you for your answer,

Answer 4

[Mech Princess]

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