MATLAB Answers

count a sequence of 1 or 0

조회 수: 3(최근 30일)
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

  댓글 수: 0

로그인 to comment.

채택된 답변

Stephen Cobeldick
Stephen Cobeldick 10 Dec 2019
Stephen Cobeldick 님이 편집함. 10 Dec 2019
>> 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

  댓글 수: 0

로그인 to comment.

More Answers (0)

이 질문에 답변하려면 로그인을(를) 수행하십시오.

태그


Translated by