How to count continuous non zero elements whilst keeping the date of the first non-zero value

Question

ASJ 2018-4-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/393124-how-to-count-continuous-non-zero-elements-whilst-keeping-the-date-of-the-first-non-zero-value

评论： ASJ 2018-4-7

I a have a set of data in a matrix whereby the first 5 columns represent: year month day hour minute The 6th column represents a magnitude value and I want to know how can I continuously count the size of the non zero values enclosed by two zeros and return it in a 7th column in the same row as where the first non zero value is located.

In other words, I have this:

2010 1 1 0 5 0

2010 1 1 0 10 6

2010 1 1 0 15 16

2010 1 1 0 20 0

2010 1 1 0 25 12

2010 1 1 0 30 19

2010 1 1 0 35 11

2010 1 1 0 40 0

and I want this:

2010 1 1 0 5 0

2010 1 1 0 10 6 2

2010 1 1 0 15 16

2010 1 1 0 20 0

2010 1 1 0 25 12 3

2010 1 1 0 30 19

2010 1 1 0 35 11

2010 1 1 0 40 0

Many thanks!

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

请先登录，再进行评论。

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

Answer 1

Sergey Kasyanov 2018-4-6

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/393124-how-to-count-continuous-non-zero-elements-whilst-keeping-the-date-of-the-first-non-zero-value#answer_313809

在 MATLAB Online 中打开

Hi.

It's the simplest but not the shortest code for this problem.

k=A(1,6)~=0;
for i=1:size(A,1)
    if A(i,6)~=0&k==0
        k=i;
    elseif A(i,6)==0&k~=0
        A(k,7)=i-k;
        k=0;
    end
end
if k~=0
    A(end,7)=i-k+1;
end

4 个评论
显示 2更早的评论隐藏 2更早的评论

Sergey Kasyanov 2018-4-6

在 MATLAB Online 中打开

Of course.

k=A(1,6)~=0;
for i=1:size(A,1)
    if A(i,6)~=0&k==0
        k=i;
    elseif A(i,6)==0&k~=0
        A(k,7)=i-k;
        A(k,8)=max(A(k:i,6));
        k=0;
    end
end
if k~=0
    A(k,7)=i-k+1;
    A(k,8)=max(A(k:i,6))
end