How can i find rows or coulmns which contain maximum zeroes?

Question

Uet 2014-5-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/130470-how-can-i-find-rows-or-coulmns-which-contain-maximum-zeroes

评论： Star Strider 2014-5-25

Hi, I want to select rows or coulmns which contain maximum zeros? can anyone please help me how to write a script file for this.. I want to develop a simple program for Assignment method..

Reagards,

Ateeq

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Star Strider 2014-5-22

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/130470-how-can-i-find-rows-or-coulmns-which-contain-maximum-zeroes#answer_137876

在 MATLAB Online 中打开

This will give you the number of zeros in particular rows and columns:

M = [105 0 55 15;  15 0 25 75;  55 0 0 10;  0 0 5 0];
[zr,zc] = find(M == 0);
Z = accumarray([zr zc], 1 )
rowzeros = sum(Z,2)
colzeros = sum(Z,1)

produces:

rowzeros =
       1
       1
       2
       3
colzeros =
       1     4     1     1

4 个评论
显示 2更早的评论隐藏 2更早的评论

Star Strider 2014-5-23

在 MATLAB Online 中打开

Add after my previous code:

uncr = find(rowzeros < 2);          % Find uncovered rows
uncc = find(colzeros < 2);          % Find uncovered cols
Munc = M(uncr,uncc);                % Uncovered rows & cols (diagnostic)
cvrr = find(rowzeros >= 2);         % Find covered rows
cvrc = find(colzeros >= 2);         % Find covered cols
M(cvrr,:) = M(cvrr,:) + 15;         % Add 15 to covered rows
q = find(M(:,cvrc)<15);             % Test for intersections
M(q,cvrc) = M(q,cvrc) + 15;         % Add 15 to the others
M(uncr,uncc) = M(uncr,uncc) - 15    % Subtract 15 from the uncovered areas

I calculate Munc to be sure I have identified those correctly. The q line was necessary because of the intersections of column 2 and rows 3 and 4. I had to be sure I didn’t add 15 to elements I had already added it to in the previous lines. I couldn’t get logical indexing or arrayfun to work here, because I am only operating on some elements of the matrix and not the entire matrix.

I can’t promise that this will be robust for all such situations, but it works here. Have fun with it!

Uet 2014-5-25

Thank you very much... it works perfect.

Star Strider 2014-5-25

My pleasure!

请先登录，再进行评论。

Answer 2

Romain 2014-5-21

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/130470-how-can-i-find-rows-or-coulmns-which-contain-maximum-zeroes#answer_137701

在 MATLAB Online 中打开

If you want the row and the colum with the maximum of values equal to zeros, I propose (for a 2D matrix) :

[numberOfZeroCol,colWithMaxZero] = max(sum(array == 0, 1))
[numberOfZeroRow,rowWithMaxZero] = max(sum(array == 0, 2))

but I'm not sure that's what you want.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Uet 2014-5-22

Actually I want to find number of rows and coulumns which contain more than two zeroes as covered by color lines in given picture. Then subtract 15 (which is minimum of all uncovered numbers) from all uncovered numbers.

请先登录，再进行评论。