Deleting multiple rows based on a specific condition

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

Answer 1

[KALYAN ACHARJYA]

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

[Stefania Avvedimento]

thank you Kalyan Acharjya for helping me :)

[KALYAN ACHARJYA]

I'm glad it helped

:)