How to count the number of cells from one column of an array variable table with a certain value?
조회 수: 1 (최근 30일)
이전 댓글 표시
I'm very new to matlab, I have a table with several columns and almost 10,000 rows, each column contains a different set of data. I need count the number of cells in column 2 that have the number 2 in them (the cells contain numbers 1-9).
So far I have
month=tab(tab(:,2)>1 & tab(:,2)<3 ,:);
res{2}=numel(month);
where res{2} is question number 2
the answer should be 2000, but it's coming in at 11900. Any help is greatly appreciated!
댓글 수: 0
채택된 답변
Star Strider
2015년 10월 11일
Your code:
month=tab(tab(:,2)>1 & tab(:,2)<3 ,:);
res{2}=numel(month);
is counting all the elements in the rows that meet the condition. See if:
res{2}=length(month);
or:
res{2}=size(month,1);
give you the result you want.
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Logical에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!