Do calculations for lines that are true
1 view (last 30 days)
Show older comments
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 Comments
Guillaume
on 27 Feb 2018
Can you explain a lot better what it is you want to do. For your given file, what should the output be?
Answers (1)
Rik
on 27 Feb 2018
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 Comment
Rik
on 9 Mar 2018
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.
See Also
Categories
Find more on Matrices and Arrays in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!