How to count the number of cells from one column of an array variable table with a certain value?
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
regina
el 11 de Oct. de 2015
Comentada: Star Strider
el 11 de Oct. de 2015
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 comentarios
Respuesta aceptada
Star Strider
el 11 de Oct. de 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 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Logical en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!