Count number of rows that meet criteria based on elements in other rows

17 views (last 30 days)
Hello. How can one count the number of rows based on the elements in the columns? For example, if we have the following matrix:
3 0 0 2
5 0 0 2
2 0 1 2
2 0 1 2
1 1 1 3
4 1 0 2
3 1 1 2
1 1 1 3
5 1 0 1
4 1 1 1
How can we count the number of rows that have number 2 in the first column and number 1 in the third column? I guess one should use 'length' right? Thanks!

Answers (1)

Voss
Voss on 31 Mar 2022
nnz(A(:,1) == 2 & A(:,3) == 1)
% 1st column is 2 & 3rd column is 1
where A is your matrix

Categories

Find more on Operating on Diagonal Matrices in Help Center and File Exchange

Products


Release

R2021b

Community Treasure Hunt

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

Start Hunting!