Remove row if its value is not different enough from the value in the row above it.

I have the table above. If the difference between latencies in one row is not much different from the latencies in the second row (difference <= 100), I would like to have the second row removed. To illustrate, row 305 would be removed in the table above because the difference in latencies between it and row 304 is less than 100. Would really appreciate suggestions on how best to do this, thank you!

Answer 1

[Chunru]

% Generate data
latency = [1000 1010 1020 1800]';
dur = zeros(size(latency));
type = ones(size(latency)) * 256;

T = table(latency, dur, type)

T = 4×3 table
    latency    dur    type
    _______    ___    ____

     1000       0     256 
     1010       0     256 
     1020       0     256 
     1800       0     256 

% diff
ldiff = diff(T.latency);
idx = find(ldiff <= 100) + 1;
T(idx, :) =[];
T

T = 2×3 table
    latency    dur    type
    _______    ___    ____

     1000       0     256 
     1800       0     256 

[Aleya Marzuki]

This worked really well thanks!!

Answer 2

[Simon Chan]

Let A be your matrix, try the following:

threshold = 100;
A([false;(diff(A(:,1))<=threshold)],:)=[];

[Aleya Marzuki]

Yup this worked too! Just needed to make a minor adjustment since A is a table:

A([false;(diff(A.latency)<=threshold)],:)=[];

Thank you!