count a sequence of 1 or 0

3 次查看（过去 30 天）
Boby S
Boby S 2019-12-10
评论： Boby S 2020-2-11
Hi
I have the following data (2 column, A and B) imported from Excel:
A B
0 0
0 1
1 1
1 0
1 1
1 0
0 1
1 1
0 1
0 1
I want to count the repeat of 0 and 1 in sequence for column A. I do not want to count all 1 or all 0. Next, based on this count, I want to count only 0 on column B for same sequence.
I expect the following result:
2 1
4 2
1 0
1 0
2 0

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

采纳的回答

Stephen23
Stephen23 2019-12-10
编辑：Stephen23 2019-12-10
>> M = [0,0;0,1;1,1;1,0;1,1;1,0;0,1;1,1;0,1;0,1]
M =
0 0
0 1
1 1
1 0
1 1
1 0
0 1
1 1
0 1
0 1
>> X = [true;diff(M(:,1))~=0];
>> Y = diff(find([X;true]));
>> V = accumarray(cumsum(X),~M(:,2));
>> Z = [Y,V]
Z =
2 1
4 2
1 0
1 0
2 0
  3 个评论
显示 1更早的评论
Stephen23
Stephen23 2020-2-6
Generate X and Y, then do this:
>> F = @(v)sum(v(1+(numel(v)>1):end));
>> V = accumarray(cumsum(X),~M(:,2),[],F);
>> Z = [Y,V]
Z =
2 0
4 2
1 0
1 0
2 1

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by