Creating a run log/count with a for loop within a table.

Question

Craig Stevens 2020-3-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/510094-creating-a-run-log-count-with-a-for-loop-within-a-table

评论： Craig Stevens 2020-3-10

I have a table that has a time column and a binary stability column (1 for stable data, 0 for non). I want to create a run count / run log for the stable data as shown below. The idea is to group stable data into "runs" then breakdown the table and export these runs into separate tables or to identify what range in which a run occurs. The table is rather long ~30000 lines, so I figured a for loop would be best but I am having difficulty identifying the conditional criteria. I appreciate any assistance.

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

dpb 2020-3-10

Attach the sample data (can make it up, but whole lot easier otherwise... :) )

请先登录，再进行评论。

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

Answer 1

Stijn Haenen 2020-3-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/510094-creating-a-run-log-count-with-a-for-loop-within-a-table#answer_419474

编辑：dpb 2020-3-10

在 MATLAB Online 中打开

I think this is what you are looking for:

switch_list=zeros(length(data),1);
switch_list(2:end)=data(2:end,2)-data(1:end-1,2);
up_list=find(switch_list==1);
down_list=find(switch_list==-1)-1;
for i=1:length(up_list)
    data(up_list(i):down_list(i),3)=i;
end

I made my own data:

7 个评论
显示 5更早的评论隐藏 5更早的评论

Craig Stevens 2020-3-10

在 MATLAB Online 中打开

I swapped "data" for the name of my matrix as shown below:

switch_list=zeros(length(StableOut),1);
switch_list(2:end)=StableOut(2:end,2)-StableOut(1:end-1,2);
up_list=find(switch_list==1);
down_list=find(switch_list==-1)-1;
for i=1:length(up_list)
    StableOut(up_list(i):down_list(i),3)=i;
end

I got the errors :

"Error using tabular/length (line 189)

Undefined function 'length' for input arguments of type 'table'. Use the HEIGHT, WIDTH, or SIZE functions instead.

Error in Scanner (line 136)

switch_list=zeros(length(StableOut),1);"

I swapped length for height in your first line of code.

switch_list=zeros(height(StableOut),1);
switch_list(2:end)=StableOut(2:end,2)-StableOut(1:end-1,2);
up_list=find(switch_list==1);
down_list=find(switch_list==-1)-1;
for i=1:length(up_list)
    StableOut(up_list(i):down_list(i),3)=i;
end

Now I get the errors:

Undefined function 'minus' for input arguments of type 'table'.

Error in Scanner (line 137)

switch_list(2:end)=StableOut(2:end,2)-StableOut(1:end-1,2);

Thank you for your continued assistance!

Craig Stevens 2020-3-10

编辑：Craig Stevens 2020-3-10

在 MATLAB Online 中打开

I'd prefer a table solution, if possible, due to everything else being in tables. I changed it as you suggessted...

StableOut = table2array(StableOut);
switch_list=zeros(length(StableOut),1);
switch_list(2:end)=StableOut(2:end,2)-StableOut(1:end-1,2);
up_list=find(switch_list==1);
down_list=find(switch_list==-1)-1;
for i=1:length(up_list)
    StableOut(up_list(i):down_list(i),3)=i;
end

Recieved the errors:

The following error occurred converting from duration to double:

Undefined function 'double' for input arguments of type 'duration'. To convert from durations to numeric, use the SECONDS, MINUTES,

HOURS, DAYS, or YEARS functions.

Error in Scanner (line 137)

switch_list(2:end)=StableOut(2:end,2)-StableOut(1:end-1,2);

Craig Stevens 2020-3-10

I appreciate all the help. I was able to accomplish what I wanted through a series of if statements within a for loop. Thank you again for your assistance.

请先登录，再进行评论。