Clear Filters
Clear Filters

Removing NaN frm matrix

3 views (last 30 days)
Mayank Lakhani
Mayank Lakhani on 11 Mar 2016
Edited: Stephen23 on 11 Mar 2016
a = NaN NaN NaN
NaN NaN NaN
4 5 6
7 8 9
i want t remove NaN frm matrix and want to have matrix like belw
a = 4 5 6
7 8 9
how to do it with find functin. i can do like below this but i want using find function
Result_All(isnan(Result_All(:,1)),:) = []
  1 Comment
Stephen23
Stephen23 on 11 Mar 2016
Edited: Stephen23 on 11 Mar 2016
See Guillaume's answer for the neatest and fastest way to solve this.

Sign in to comment.

Accepted Answer

KSSV
KSSV on 11 Mar 2016
a = [NaN NaN NaN
NaN NaN NaN
4 5 6
7 8 9];
k = find(isnan(a)) ;
a(k) = [] ;
reshape(a,[2,3])
  3 Comments
KSSV
KSSV on 11 Mar 2016
if every time...you are removing a complete row..it would be easy to get a matrix with same columns as the original. If not getting matrix of same columns or rows of original would be tough.
PS: If it is useful. Accept the answer.
Guillaume
Guillaume on 11 Mar 2016
Note that the find in the above answer is completely unnecessary and only slows down the code. Admittedly the slowdown is negligible in this case.

Sign in to comment.

More Answers (1)

Guillaume
Guillaume on 11 Mar 2016
Note that you cannot remove arbitrary nans from a matrix since that would leave 'gaps'. You can only remove entire rows or columns. You can detect rows or columns that are just nan with the all function. It is much better than checking the first column as you have done.
To remove all rows that contain nans:
a = [NaN NaN NaN
NaN NaN NaN
4 5 6
7 8 9];
nanrows = all(isnan(a), 2);
a(nanrows, :) = []
This is the "dynamic" versions. find is completely unnecessary. You can of course add as many unnecessary statements as you want to your code to make slower and more efficient, but why?
a = [NaN NaN NaN
NaN NaN NaN
4 5 6
7 8 9];
nanrows = find(all(isnan(a), 2)); %<- completely unnecessary find as you asked
nanrows = nanrows * 1 + 0; %<- completely unnecessary addition and multiplication, while we're at it
a(nanrows, :) = [];

Categories

Find more on Operating on Diagonal 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!