How to count the number of cells from one column of an array variable table with a certain value?

3 ビュー (過去 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!

採用された回答

Star Strider
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 ExchangeLogical についてさらに検索

製品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by