new array using average row of the old array

I have an array M(1000,1000) and i want to build a new array N(1000,1000), where each element of N has the old value minus the average of its row (in M). If the element is zero no action will be taken. Also, from the average the zeros should be excluded.

Can you help me?

thank you in advance

Answer 1

[Azzi Abdelmalek]

Edit

out=bsxfun(@minus,M,mean(M,2)).*not(~M)

%or

idx=M==0;
out=bsxfun(@minus,M,mean(M,2));
out(idx)=0

[babis]

thank you for your answer but with this commands the average of the row also counts the elements with zero value and i want them to be excluded.

[Azzi Abdelmalek]

Do you want to exclude all the rows with zeros

[Azzi Abdelmalek]

If you want to exclude all the rows with zeros

idx=any(~M,2)
out=bsxfun(@minus,M,mean(M,2))
out(idx,:)=M(idx,:)

[babis]

dear azzi i want to exclude the zeros when calculating the average. for example in a row like [1 4 7 3 0 0 2 1] the average will be 18/6=3 not 18/8=2.25 thank you again

[Azzi Abdelmalek]

Ok try this

idx=M==0;
moyenne=sum(M,2)./sum(not(~M),2)
out=bsxfun(@minus,M,moyenne)
out(idx)=0

[babis]

thanks again this will do it

Answer 2

[Andrei Bobrov]

ii = M == 0;
out = bsxfun(@minus,M,sum(M,2)./sum(~ii,2));
out(ii) = 0;