Group number identification consecutive numbers

Question

Marek Drliciak 2022-11-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1848463-group-number-identification-consecutive-numbers

移动：Bruno Luong 2022-11-21

Problem description_02.xlsx

Hello

I have millions of 1-0 data in my database. I need to detect groups of consecutive units. I would like to ask you to create the attribute "Gr_numb". An example is given in the attached file. The searched attribute is calculated there. But in Excel it is very complicated and unusable for a large database.

Thank You

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

Image Analyst 2022-11-11

OK I think I see now, though it is probably a poor example since the second group and third groups both have a group label of 3. I don't see why two different groups should have the same group number, but the example would have been clearer if the third group had had 4 or 5 1's in it instead of 3 (same as the prior group). You must have the Mind Reading Toolbox Bruno.

Jan 2022-11-11

编辑：Jan 2022-11-11

@Image Analyst: The term "group number" is misleading. "Number of group members" would be clearer.

请先登录，再进行评论。

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

Answer 1

Jan 2022-11-11

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1848463-group-number-identification-consecutive-numbers#answer_1097063

编辑：Jan 2022-11-11

在 MATLAB Online 中打开

With FileExchange: RunLength :

index   = [1 0 1 1 1 0 0 0 1 1 1 0 1 1 0 0 1 1];
[b, n]  = RunLength(index);
m       = n(b == 1);
Gr_numb = zeros(size(index));
GR_numb(index == 1) = RunLength(m, m);

If you do not have a C-compiler installed, use RunLength_M from this submission.

Or:

d = [true, diff(index) ~= 0];  % TRUE if values change
n = diff(find([d, true]));     % Number of repetitions
m = n(index(d) == 1);
index(index == 1) = repelem(m, m)
index = 1×18
     1     0     3     3     3     0     0     0     3     3     3     0     2     2     0     0     2     2

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Marek Drliciak 2022-11-21

移动：Bruno Luong 2022-11-21

Thank You very much. That was what I looking for.

请先登录，再进行评论。

Answer 2

Stephen23 2022-11-11

3
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1848463-group-number-identification-consecutive-numbers#answer_1097053

在 MATLAB Online 中打开

X = [1;0;1;1;1;0;0;0;1;1;1;0;1;1;0;0;1;1;0;1;0;0;1;1;0;1;1;1;1;0;1;1;1;1;1;;0;1;1;1;1;1;1;1;1;1;0;0;0;1;1;1;1;1;1;1;1;1;1;1;1;1;1;1;1;0]
X = 65×1
     1
     0
     1
     1
     1
     0
     0
     0
     1
     1
D = diff([0;X;0]);
B = find(D>0);
E = find(D<0);
L = E-B;
G = X;
G(X==1) = repelem(L,L)
G = 65×1
     1
     0
     3
     3
     3
     0
     0
     0
     3
     3