I need to find a pattern in a column

Hello,

I need to count the number of repetition of a pattern in my data. The pattern is a serie of 35 zeros. The problem is that I didn`t find how to do it in column cause my data are un one column.

Thank you for your help

Answer 1

[Chris]

A = readmatrix('test.xlsx');
count = 0;
for idx = 1:numel(A)-34
    if sum(A(idx:idx+34)) == 0
        count = count+1;
    end
end

If there is a series of N>35 zeros, this wll count the pattern multiple times (for example, if there are 36 zeros in a row, that's two patterns of 35).

Also, there are probably more efficient ways to do this.

[quentin bruxelles]

it is possible to not count the same thing multiple times ?

[Chris]

certainly!

Maybe something like this:

A = readmatrix('test.xlsx');
count = 0;
for idx = 1:numel(A)-34
    % The previous condition, but also either: 
    %   (we're at the first index OR the previous index isn't also 0)
    if (sum(A(idx:idx+34)) == 0 && (idx==1 || A(idx-1) ~= 0))
        count = count+1;
    end
end