Rows in a matrix with a certain outcome

1 view (last 30 days)
Daniel Ring
Daniel Ring on 15 Oct 2018
Answered: dpb on 15 Oct 2018
I have a matrix with 16 columns and a large number of rows. In each column, there is one of two outcomes (ex: one column is filled with ones and zeros, another column is filled with 0.4s and 0.6s). I am looking for a function that can count the number of rows in which a combination of outcomes occurs. For example, I'd like to figure out how many rows have ones, .6s, and .7s.
ex:
1 .7 .6 (random numbers 4-16)
1 .3 .4 (random numbers 4-16)
1 .3 .6 (random numbers 4-16)
1 .7 .6 (random numbers 4-16)
1 .7 .4 (random numbers 4-16)
ans = 2

Accepted Answer

dpb
dpb on 15 Oct 2018
>> sum(ismember(sort(x,2),[.6 .7 1],'rows'))
ans =
2
>>
Generalize the set looking for instead of using the hardcoded values, of course...

More Answers (0)

Categories

Find more on Creating and Concatenating Matrices in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!