Deleting multiple rows based on a specific condition

18 次查看(过去 30 天)
Hi all,
I am working on a water network. I got a big matrix 381x12527 (time vs node's quality concentration) even for times that I am not interest in. So I want to delete the matrix rows for which the difference between two consecutive rows is not equal to 3600 (see yellow rows in Figure).
I would appreciate if anyone could help me, thanks!
Stefania

采纳的回答

KALYAN ACHARJYA
KALYAN ACHARJYA 2021-2-28
编辑:KALYAN ACHARJYA 2021-2-28
Lets say data1 is the column time data
diff_data=diff(data1);
idx_delete=find(diff_data~=3600)+1;
% +1 for compensate with next
% Do modify accordingly
Once get the rows numbers, which to be deleted
matrix(idx_delete,:)=[]
Or:
matrix(~mod(data1,3600)==0,:)=[]
It gives the all those numbers, which are non divisible by 3600

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Multidimensional Arrays 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by