Finding a value based on multiple conditions of the next row

1 次查看（过去 30 天）

Jorge Young 2020-9-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/593542-finding-a-value-based-on-multiple-conditions-of-the-next-row

评论： Jorge Young 2020-9-14

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

KSSV 2020-9-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/593542-finding-a-value-based-on-multiple-conditions-of-the-next-row#answer_494425

在 MATLAB Online 中打开

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

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

KSSV 2020-9-14

在 MATLAB Online 中打开

[c,ia,ib] = unique(Procedure) ; 
for i = 2:length(c)
    idx = find(DrivenTime(Procedure==c(i))<1) ;
    if ~isempty(idx)
        PreviousRow = idx(1)-1 ; 
    end
end

Jorge Young 2020-9-14

perfect! thanks!

请先登录，再进行评论。

类别

MATLAB Language Fundamentals Matrices and Arrays Matrix Indexing

在 Help Center 和 File Exchange 中查找有关 Matrix Indexing 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by