Count values in the given array

Hi,

In the attached array, column 1 got two values -3.14 and -3.84 and on column 2 some values are 0 and some are 1. I need to check how many zeros and 1 are in -3.14 and -3.84.

Answer 1

[Star Strider]

Try this —

LD = load('matlab.mat');
AA4 = LD.AA4

AA4 = 716×2

-3.4100 0 -3.4100 0 -3.4100 0 -3.4100 0 -3.4100 1.0000 -3.4100 0 -3.4100 0 -3.4100 0 -3.4100 1.0000 -3.4100 0

[UAA4,ix1,ix2] = unique(AA4(:,1));
Zeros = accumarray(ix2, (1:numel(ix2))', [], @(x)nnz(AA4(x,2) == 0));
Ones = accumarray(ix2, (1:numel(ix2))', [], @(x)nnz(AA4(x,2) == 1));
NrZeros = table(UAA4, Zeros, Ones)

NrZeros = 2×3 table
    UAA4     Zeros    Ones
    _____    _____    ____

    -3.84     303      71 
    -3.41     232     110 

See the documentation on unique and accumarray for details.

.

[Turbulence Analysis]

Thanks, Very much !

[Star Strider]

As always, my pleasure!