How to get the count of continuous occurrence of specified name in the table

Question

Mekala balaji 2016-6-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/288625-how-to-get-the-count-of-continuous-occurrence-of-specified-name-in-the-table

编辑： Mekala balaji 2016-6-18

采纳的回答： Azzi Abdelmalek

在 MATLAB Online 中打开

Hi,

I have the below Table:

Name5
Name2
Name2
Name1
Name3
Name2
Name2
Name2
Name2
Name5
Name3
Name3
Name2
Name2
Name2

I want to get the Name2 continuous count, and accumulated count as explained below:

For example: Name2 run continuously three times (2(row2&row3), 4(row6~9), 3(row13~15)), its max is 4, and its accumulated continuous run is 9(2+4+3). Output1:

2
4
3

output2:

Name5  -1
Name2  1
Name2  2
Name1  -1
Name3  -2
Name2  1
Name2  2
Name2  3
Name2  4
Name5  -1
Name3  -2
Name3  -3
Name2  1
Name2  2
Name2  3

Output2 explanation:

Consider Name2 as 1, and if it is continuous the number increase like 1,2,3 ...(till change from Name2 to other) and except Name2, all other weighting given as -1(it increases like -1,-2,-3,-4 etc till Name2 appear). For instance, row1 is Name5(it is -1), row 2&3 are Name2 (1,2), row4&5 Name1&Name3 (-1,-2), row 6~9 Name2(1,2,3,4) etc. My purpose is when Name2 change to other it is given -1 and till it changes to Name2 again (Name2 given as 1 and increase if it is continuous).

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

请先登录，再进行评论。

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

Answer 1

Azzi Abdelmalek 2016-6-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/288625-how-to-get-the-count-of-continuous-occurrence-of-specified-name-in-the-table#answer_224909

在 MATLAB Online 中打开

a={'Name5'
'Name2'
'Name2'
'Name1'
'Name3'
'Name2'
'Name2'
'Name2'
'Name2'
'Name5'
'Name3'
'Name3'
'Name2'
'Name2'
'Name2'
'Name2'}
n=numel(a);
ii=ismember(a,'Name2')'
ii1=strfind([0 ii],[0 1])
ii2=strfind([ii 0],[1 0])
out1=(ii2-ii1+1)'
jj=1
for k=1:numel(ii1)
  out2(jj:ii1(k)-1)=-(1:(ii1(k)-jj))
  out2(ii1(k):ii2(k))=1:ii2(k)-ii1(k)+1
  jj=ii2(k)+1;
end
out2(end+1:n)=-(1:n-ii2(k))

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

Mekala balaji 2016-6-14

编辑：Mekala balaji 2016-6-18

在 MATLAB Online 中打开

Sir,

It giving error if Name2 does not exist. Now I handled for the case like:

a={'Name5'
'Name1'
'Name3'
'Name7'
'Name6'
'Name5'
'Name3'
'Name3'
}
a=[a;{'Name2'}]
and delete last row from out2 (out2(end,:)=[]). It works but is there any smart way.