How to filter required data

Question

Kanakaiah Jakkula 2016-5-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/283123-how-to-filter-required-data

评论： Kanakaiah Jakkula 2016-5-8

Hi,

I have below table. I want to take the data under "actual measurement" till stop, but in between there should not exist except complete or paused or stop. for example I want the below cases:

    actual measurement           start              2016/4/5           
    complete                     BA0K2              23
    complete                     BY0P2              3
    stop                         HYT0KL             54

AND

actual measurement           start              2016/4/7           
paused                       VA0L2              89
paused                       BY0P2              3
stop                         HYT0KL             54

But I dont want:

measurement restart          start              2016/4/7           
complete                     VA0L2              89
paused                       BY0P2              3
stop                         HYT0KL             54

AND

actual measurement           start              2016/4/7 
actual measurement restart   start              2016/4/7                     
paused                       VA0L2              89
stop                         HYT0KL             54

My Table:

actual measurement           start              2016/4/5           
complete                     BA0K2              23
complete                     BY0P2              3
stop                         HYT0KL             54
measurement restart          start              2016/4/7           
complete                     VA0L2              89
paused                       BY0P2              3
stop                         HYT0KL             54
actual measurement           start              2016/4/7           
paused                       VA0L2              89
paused                       BY0P2              3
stop                         HYT0KL             54
actual measurement restart   start              2016/4/7           
paused                       VA0L2              89
stop                         HYT0KL             54
actual measurement           start              2016/4/7 
actual measurement restart   start              2016/4/7                     
paused                       VA0L2              89
stop                         HYT0KL             54

2 个评论
显示无隐藏无

Walter Roberson 2016-5-8

What is the data type of this table? If it is character, are the fields separated by tab?

Kanakaiah Jakkula 2016-5-8

cell array

请先登录，再进行评论。

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

Answer 1

Weird Rando 2016-5-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/283123-how-to-filter-required-data#answer_221288

在 MATLAB Online 中打开

In order for you to run this code you must convert your data (aka the table) into cell using the cell2table() and store it into variable named 'data'

result = {};
startRows = find(strcmp(data(:,1),'actual measurement'));
stopRows = find(strcmp(data(:,1),'stop'));
nloop = length(startRows);
for i = 1:nloop
      sectionStop = find(startRows(i)<stopRows,1,'first');
      if strcmp(data(startRows(i)+1:stopRows(sectionStop)-1,1),'complete') | strcmp(data(startRows(i)+1:stopRows(sectionStop)-1,1),'paused')
          result = [result; data(startRows:stopRows(sectionStop),:)];
      end
  end