How to count the number of cells from one column of an array variable table with a certain value?
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponse acceptée
Star Strider
le 11 Oct 2015
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.
2 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Logical dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!