MATLAB: Fast delete of rows in a table

conditionsdeletefastMATLABtable

hi
I've got a table with 120k rows, and I need to delete some rows if there is a specific condition.
I wrote this:
for i=1:(size(db,1)-1)
     if db.INTERVENTION(i)==1 && isequal(db.SETTLEMENTDATE(i-1),db.SETTLEMENTDATE(i)) && isequal(db.DUID(i-1),db.DUID(i))
            db(i-1,:)=[];
     end
end
This code takes a long time to execute.
Is there a faster way?
thanks!

Best Answer

Try this:
numRows = size(db,1)-1;
rowsToDelete = false(numRows, 1);
for k = 2 : numRows  % Has to start at 2, right?  Since you're using k-1.  Don't use i, the imaginary variable, as a loop index.
     if db.INTERVENTION(k)==1 && isequal(db.SETTLEMENTDATE(k-1),db.SETTLEMENTDATE(k)) && isequal(db.DUID(k-1),db.DUID(k))
            rowsToDelete(k) = true;
     end
end
db(rowsToDelete, :) = []; % Remove these rows.
% Or equivalently
%db = db(~rowsToDelete, :); % Extract everything BUT the rows to delete.
Related Question