Removing NaN frm matrix
Afficher commentaires plus anciens
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 commentaire
Réponse acceptée
Plus de réponses (1)
Guillaume
le 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, :) = [];
Catégories
En savoir plus sur Logical dans Centre d'aide et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!