How to filter Rows based on Values in them

3 views (last 30 days)
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?

Accepted Answer

the cyclist
the cyclist on 23 Sep 2014
rowIndexToRemove = any(isnan(Data),2);
Data(rowIndexToRemove,:) = [];
  1 Comment
Mandeep
Mandeep on 23 Sep 2014
This works! Thanks and Infact it created rowIdexToRemove and show which Rows got removed.

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!