Delete data from the following minutes from data that does not meet a certain condition

Question

tamara N 2021-3-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/780127-delete-data-from-the-following-minutes-from-data-that-does-not-meet-a-certain-condition

评论： tamara N 2021-3-22

Hi, I have a database in timetable format. I need to filter for those data that do not meet a certain condition.

I need to remove those data where "I" (a variable) is greater than 4 and also remove the values of the next 10 minutes when I> = 4.

Thanks.

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

请先登录，再进行评论。

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

Answer 1

Seth Furman 2021-3-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/780127-delete-data-from-the-following-minutes-from-data-that-does-not-meet-a-certain-condition#answer_654927

I believe the following post answers your question

https://www.mathworks.com/matlabcentral/answers/402361-delete-rows-in-a-table

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

tamara N 2021-3-22

在 MATLAB Online 中打开

Yes, with that I only remove the values> = 4 which I think would be something like this:

DATA((DATA{:,3}<=4),:)=[]

but I don't need to remove only the data> = 4, but also the data after 10 minutes of that reading. I have a 50000x20 timetable, where the column I have to evaluate is 3. I think I also have to use loops and conditional instructions. I do not know how to do it.

请先登录，再进行评论。