How to filter Rows based on Values in them

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

rowIndexToRemove = any(isnan(Data),2);
Data(rowIndexToRemove,:) = [];

1 Comment

This works! Thanks and Infact it created rowIdexToRemove and show which Rows got removed.

Sign in to comment.

More Answers (0)

Tags

Asked:

on 23 Sep 2014

Commented:

on 23 Sep 2014

Community Treasure Hunt

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

Start Hunting!