I Like to Remove rows of data where I have 'NaN' and preserve the rest of the data in the original variable.
Data:
NaN NaN Nan 1 2 4;
3 4 5 Nan Nan 2;
4 5 6 7 8 1;
2 5 7 8 9 2;
NaN 2 4 5 9 1;
The final Data should look like as it removed NaN lines
4 5 6 7 8 1;
2 5 7 8 9 2
What code should I use?

 Réponse acceptée

the cyclist
the cyclist le 23 Sep 2014
rowIndexToRemove = any(isnan(Data),2);
Data(rowIndexToRemove,:) = [];

1 commentaire

Mandeep
Mandeep le 23 Sep 2014
This works! Thanks and Infact it created rowIdexToRemove and show which Rows got removed.

Connectez-vous pour commenter.

Plus de réponses (0)

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by