Do calculations for lines that are true

1 次查看（过去 30 天）

Dylan Mecca 2018-2-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/385153-do-calculations-for-lines-that-are-true

评论： Rik 2018-3-9

ABSbrake.csv

How can I make matlab do a calculation, that will require a previous line, for a condition being true? Please reference the file I've attached.

When the 'z' vector is true, or 1, I want to take the current line's 'v', and subtract the previous line's 'v'. Then, if the next line is also true, to do the same calculation; so on and so forth until z = 0.

I will then want to take an average over each given interval of z being true, and put that into a new vector.

Any help is appreciated!

8 个评论
显示 6更早的评论隐藏 6更早的评论

Guillaume 2018-2-27

Can you explain a lot better what it is you want to do. For your given file, what should the output be?

Dylan Mecca 2018-2-27

Output should have a new vector of average 'v' only where z = 1.

For instance, cells 3:9 have 'z' as true. Take the average of 'v' during that interval, and store that average value as the first value in a new vector.

Do the same for cells 11:16, where that average will be stored as the second value in the new vector.

And finally, do it for a third vector value for average value of 'v' where 'z' = 1 in cells 19:22.

I can build a hard code to satisfy these cell values, but I need help developing a way to make matlab see the pattern I', trying to explain.

请先登录，再进行评论。

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

回答（1 个）

Rik 2018-2-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/385153-do-calculations-for-lines-that-are-true#answer_307418

在 MATLAB Online 中打开

If you have the Image Processing Toolbox, you can use bwlabel to label each group of indices where z is 1. If you don't have this toolbox, this wikipedia page could help.

data=xlsread('absbreak.xlsx');
v=data(:,2);
z=data(:,3);
[labels,num]=bwlabel(z==1);
avg_vec=zeros(1,num);
for n=1:num
    avg_vec(n)=mean(v(labels==n));
end

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

Rik 2018-3-9

If you found this answer useful, please mark it as accepted answer. It will give me reputation points and will make it easier for other people with the same question to find an answer.

请先登录，再进行评论。

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