I need to find a pattern in a column

Question

quentin bruxelles 2021-11-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1581809-i-need-to-find-a-pattern-in-a-column

评论： Chris 2021-11-9

test.xlsx

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Chris 2021-11-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1581809-i-need-to-find-a-pattern-in-a-column#answer_826779

在 MATLAB Online 中打开

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.

2 个评论
显示无隐藏无

quentin bruxelles 2021-11-9

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

Chris 2021-11-9

在 MATLAB Online 中打开

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