How to find all first records of specified item between each specified case in the table

Question

Mekala balaji 2016-4-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/279249-how-to-find-all-first-records-of-specified-item-between-each-specified-case-in-the-table

编辑： Azzi Abdelmalek 2016-4-16

Hi,

I have the below table, and I want to extract all first records (appear first time after calibration) of "End" after each calibration.

Case1: If the first record after calibration is "End" just extract that row.

Cae2: If the first record after calibration is not "End", and check for the "End" record before next calibration, and take that row (if "End" exist before next calibration)

Case3: If no "End" record exists before next calibration, just take the last record before next calibration.

Kindly help, Many thanks in advance,

Calibration               HT0MEK
End                       HT0MEK
Calibration               JT0KEL
Paused                    T0KEL
End                       JT0KEL
End                       JT0KEL
Calibration               BK0JIL
Paused                    HA0GEK
Paused                    HA0GEK

My output should be: (Row 2, Row 5, and Row 9)

Output:

End  HT0MEK
End  JT0KEL
Paused  HA0GEK

Many thanks in advance

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

请先登录，再进行评论。

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

Answer 1

Azzi Abdelmalek 2016-4-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/279249-how-to-find-all-first-records-of-specified-item-between-each-specified-case-in-the-table#answer_218119

编辑：Azzi Abdelmalek 2016-4-16

在 MATLAB Online 中打开

Edit

v={'Calibration'               'HT0MEK'
'End'                       'HT0MEK'
'Calibration'               'JT0KEL'
'Paused'                    'T0KEL'
'End'                      'JT0KEL'
'End'                       'JT0KEL'
'Calibration'               'BK0JIL'
'Paused'                    'HA0GEK'
'Paused'                    'HA0GEK'
'Calibration'                'HA0GE'}
c1=v(:,1);
idx1=find(ismember(c1,'Calibration'  ))
idx1=[ones(size(idx1)) idx1]
idx2=find(ismember(c1,'End'  ))
idx2=[2*ones(size(idx2)) idx2]
h=sortrows([idx1;idx2],2)
ii=strfind(h(:,1)',[1 2])+1
ind1=h(ii,2)
jj=strfind(h(:,1)',[1 1])+1
ind2=h(jj,2)-1
ind=sort([ind1;ind2])
out=v(ind,:)