How can I do such a "countifs"(excel) process in Matlab?

99 次查看（过去 30 天）
KO
KO 2021-4-18
回答： Saad Arshad 2022-1-11
How can I do such a "countifs"(excel) process in Matlab?

请先登录，再回答此问题。

回答（3 个）

Stephan
Stephan 2021-4-18
You do it by logical indexing:
A = randi(10,1,15)
CountIf = numel(A(A>5))
gives:
A =
9 7 4 10 1 5 4 8 8 2 5 5 7 8 8
CountIf =
8
Simon Fu
Simon Fu 2021-8-6
Another way is to take advantage of the fact that logical in MATLAB has the value of 1 for true, and 0 for false.
So, using sum function would gives the same result as the previous answer of using numel; i.e.:
A = randi(10,1,15)
CountIf = sum(A>5)
gives:
A =
9 7 4 10 1 5 4 8 8 2 5 5 7 8 8
CountIf =
8
Saad Arshad
Saad Arshad 2022-1-11
The best way to perform the equivalent of a COUNTIFS function in MATLAB is to first convert your data into a table and then use the GROUPCOUNTS function. Details: https://www.mathworks.com/help/matlab/ref/double.groupcounts.html

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by