how to exclude a row from a matrix

Question

0 个投票

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Bob Thompson 2018-10-3

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)),:);

Answer 1

the cyclist 2018-10-3

0 个投票

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.

D.J 2018-10-3

There was a problem with the first option, but the 2nd one worked perfectly well. Thank you very much.