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

1 Ansicht (letzte 30 Tage)
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!

Akzeptierte Antwort

Chunru
Chunru am 16 Aug. 2022
% 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

Weitere Antworten (1)

Simon Chan
Simon Chan am 16 Aug. 2022
Let A be your matrix, try the following:
threshold = 100;
A([false;(diff(A(:,1))<=threshold)],:)=[];
  1 Kommentar
Aleya Marzuki
Aleya Marzuki am 16 Aug. 2022
Yup this worked too! Just needed to make a minor adjustment since A is a table:
A([false;(diff(A.latency)<=threshold)],:)=[];
Thank you!

Melden Sie sich an, um zu kommentieren.

Kategorien

Mehr zu Startup and Shutdown finden Sie in Help Center und File Exchange

Produkte


Version

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by