sum logical 1's independently for each column

7 次查看（过去 30 天）

显示更早的评论

Michael Angeles 2022-2-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1648065-sum-logical-1-s-independently-for-each-column

回答： Michael Angeles 2022-2-14

采纳的回答： DGM

logical data count .xlsx

I've attached a sample data from excel.

how can I create a "for loop" to sum each column and give me print out total for each column.

I also need to compare the "length" of the column to the sum of the logical 1's in that column then print out a pass or fail for each column tested.

example:

1 1 1 1

1 1 1 0

1 1 1 1

-----------sum

first column = 4 ==length(column) = pass

fourth column = 3 == lenght(column = fail

采纳的回答

DGM 2022-2-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1648065-sum-logical-1-s-independently-for-each-column#answer_894250

编辑：DGM 2022-2-13

在 MATLAB Online 中打开

If the inputs are integer-valued, just use all()

A = randi([0 1],5)
A = 5×5
     0     0     1     1     0
     1     1     1     1     0
     1     0     0     1     1
     0     0     0     1     0
     0     0     0     1     1
isfull = all(A,1)
isfull = 1×5 logical array
   0   0   0   1   0
% if you really need text output for some reason
flmap = {'fail','pass'};
fulllabels = flmap(isfull+1)
fulllabels = 1×5 cell array
    {'fail'}    {'fail'}    {'fail'}    {'pass'}    {'fail'}

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

Michael Angeles 2022-2-13

Thanks DGM, I will try this one if it fits the output that we are looking for.

请先登录，再进行评论。

更多回答（2 个）

David Hill 2022-2-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1648065-sum-logical-1-s-independently-for-each-column#answer_894240

在 MATLAB Online 中打开

No loop is needed.

r=readmatrix('logicalDataCount.xlsx');
s=sum(r);
l=s==size(r,1);

10 个评论
显示 8更早的评论隐藏 8更早的评论

David Hill 2022-2-13

在 MATLAB Online 中打开

The below code is completely flexible (does not depend on the size of r)

s=sum(r);
allPassed = (numPasses == size(r, 1));

You are really not understanding, the logical array above tells you every column that is passed (1) or failed (0). Converting the logical array to 'pass' or 'fail' is trivial.

Michael Angeles 2022-2-13

Hi David,

Thanks...Maybe I don't understand...The reason why I want each column to print out pass or fail as part of the output message is to inform the operator immediately that the column checked for a certain message passed or failed. This allows the operator to re-run the test.

请先登录，再进行评论。

Michael Angeles 2022-2-14