MATLAB: Finding a value based on multiple conditions of the next row

finding conditional valuesrow indexing

I need to find the row in a csv that comes right before a row where multiple conditions are met for example, the .csv look something like:

I basically need the DisttoStartPoint at of Procedure 1 when Procedure 2 has a DriveTime of <1

I can get the DistToStartPoint of the Procedure 2 by using condtions but I can not figure out how to get the info from the previous row.

Thank you.

Best Answer

idx = find(DrivenTime(Procedure==2)) ;
PReviousRow = idx(1)-1

Related Solutions

MATLAB: Can this silly accumarray for-loop be removed by a vectorization

A = randi(32280,28);
[UA,~,idx] = unique(A(:,1));
[X,Y] = ndgrid(idx, 2:size(A,2));
newcolumns = accumarray([X(:), Y(:)], reshape(A(:,2:end),[],1), [], @mean);

The ndgrid needs to start in the second column and only extract the 2nd through end columns of A for vals.

MATLAB: Replace a value in a vector with another

idx=(true,Failuretimesdet(k)==0)

is not valid matlab syntax, I'm not even sure what you're trying to do with this.

You seem to be treating logical vectors as a vector of indices. Subtracting 1 from a logical vector makes no sense, subtracting one from indices does. The equivalent of subtracting one from a vector of indices would be shifting the logical vector left by one element.

Anyway, if I understood correctly, this should work:

Failuretimes=floor(Failures); %round failures to integer to match the measurements of detoriation
failuretimesdet=Detoriation(Failuretimes,2);  %find detoriation at the times of failure
isnullfailure = Failuretimesdet == 0;  %identify which elements of failuretimesdet are 0
failuretimesdet(isnullfailure) = Detoriation(Failuretimes(isnullfailure) - 1, 2); %and subtract 1 from the FAILURETIMES to replace the failuretimesdet.

as long as a null failure doesn't occur at Detoriation(1, 1) of course (since there's no preceding row).

Best Answer

Related Solutions

MATLAB: Can this silly accumarray for-loop be removed by a vectorization

MATLAB: Replace a value in a vector with another

Related Question