how to exclude a row from a matrix

20 views (last 30 days)
D.J
D.J on 3 Oct 2018
Commented: D.J on 3 Oct 2018
Hi all, I need to extract all data from a matrix except for one row (the 3rd from last).
Say for example I have the matrix below and I want to exclude this row: [NAN,7,7] Any idea how to do that? Many thanks
T=[1,2,3;4,5,6;7,8,9;1,2,3;4,5,6;7,8,9; NAN,7,7;4,5,6;7,8,9]
  1 Comment
Bob Thompson
Bob Thompson on 3 Oct 2018
I would suggest using an isnan check. Not entirely sure how it will treat an entire row, but a place to start.
T=[1,2,3;4,5,6;7,8,9;1,2,3;4,5,6;7,8,9; NAN,7,7;4,5,6;7,8,9];
T = T(~isnan(T),:);
I suspect you will need:
T = T(~isnan(T(:,1)),:);

Sign in to comment.

Accepted Answer

the cyclist
the cyclist on 3 Oct 2018
Assuming that what you want is to exclude any row with a NaN in any position, then either
T = T(all(~isnan(T),2),:);
or
T(any(isnan(T),2),:) = [];
will do the job.
  1 Comment
D.J
D.J on 3 Oct 2018
There was a problem with the first option, but the 2nd one worked perfectly well. Thank you very much.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!