determine range within an array

Question

Max Bernstein 2011-10-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/17769-determine-range-within-an-array

I'm trying to determine a range within a range. I have an array of only the start and end time column shown below. The diff and type column was added after running the script. If the difference is 1, the type is check, if it's 3-5, the type is good, if it's 6-11, the type is bad, and if it's 12290 the type is cycle.

start   end             diff    type
3    1  check
8    3  good
24    10  bad
12345    12290  cycle (1)
22353    1  check
22397    8  bad
22415    10  bad
22425    5  good
22450    10  bad
34789    12290  cycle (2)
35890    1  check
35906    5  good
35915    4  good
35960    5  good
48292    12290  cycle (3)

The type "check" signifies the start of a cycle and all the "good/bad" ranges after that belongs to the cycle right below it. So far I've been able to determine the type of ranges and how many there are total but I cant figure out how to place them in the correct cycle. Below is the desired output for this array.

cycle  good  bad
1  1
1  3
3  0

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

Jan 2011-10-8

How is the shown table represented in Matlab? A text file, a cell matrix, a struct?

请先登录，再进行评论。

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

Answer 1

TAB 2011-10-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/17769-determine-range-within-an-array#answer_23944

在 MATLAB Online 中打开

Considering last column of 'type' stored in a cell array, you can find number of 'good' and 'bad' in each cycle with below code

typecell={'check';
'good';
'bad';
'cycle';
'check';
'bad';
'bad';
'good';
'bad';
'cycle';
'check';
'good';
'good';
'good';
'cycle' };
ck_idx=find(strcmp(typecell,'check'));
cy_idx=find(strcmp(typecell,'cycle'));
gd_nos=zeros(length(cy_idx),1);
bd_nos=zeros(length(cy_idx),1);
for r=1:length(cy_idx)
    tmpc=typecell(ck_idx(r)+1:cy_idx(r)-1);
    gd_nos(r)=length(find(strcmp(tmpc,'good')));
    bd_nos(r)=length(find(strcmp(tmpc,'bad')));
end

% If you want to write output result in text file

fh=fopen('myfile.txt','w');
fprintf(fh,'cycle\tgood\tbad\n');
for r=1:length(cy_idx)
    fprintf(fh,'%d\t\t%d\t\t%d\n',r,gd_nos(r),bd_nos(r));
end
fclose(fh);