Find entire rows in a matrix where a column value meets a certain condition

1 view (last 30 days)
I have a matrix (4columns, ~50000 rows) and I want a new matrix that will only return the (entire) rows (values, not row number) where column 4 = 101300 (to 4s.f).
Any help appreciated.
VLE1(ii,:)=[x1 x2 T P]

Accepted Answer

Guillaume
Guillaume on 19 Oct 2016
filteredmatrix = originalmatrix(round(originalmatrix(:, 4), 4, 'significant') == 101300, :);
is all that is needed.

More Answers (1)

Massimo Zanetti
Massimo Zanetti on 19 Oct 2016
Assume your 50000x4 matrix is A, this will remove all the rows such having 4th element = 101300:
A(A(:,4)~=101300,:)=[];

Categories

Find more on Creating and Concatenating Matrices in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!