MATLAB Answers

Delete rows with NaN records

1,056 views (last 30 days)
Meh
Meh on 12 Mar 2012
Commented: Jan on 8 Mar 2017
How can I delete rows which have NaN on one of the column.

  0 Comments

Sign in to comment.

Accepted Answer

Jan
Jan on 12 Mar 2012
X = rand(10, 10);
X(X < 0.1) = NaN;
disp(X);
X(any(isnan(X), 2), :) = [];
Or do you mean exactly one NaN in a row?
X(sum(isnan(X), 2) == 1, :) = [];

  4 Comments

Show 1 older comment
Jan
Jan on 7 Mar 2017
@chocho phD: I do not understand the question. What does "Nan(or NA)" mean? If you use strfind do you mean cell strings? Then please opena new thread, because it is a different question.
Perhaps you want: strncmp(CStr, 'GNA', 3).
chocho
chocho on 8 Mar 2017
_hi bro in my case i have NA and i want to delete it and keep the Lines which have NA inside
example:
0.255898 NA 0.257966
0.180000 RNASE 0.389999
0.892222 NA 0.458888
0.155523 GNAS 0.892133
*output wanted *
0.180000 RNASE 0.389999
0.155523 GNAS 0.892133
Note: Command i tried is isempty(strfind(l,'NA')) but it delete everything !
Jan
Jan on 8 Mar 2017
Dear chocho phD: Please post some code which creates your input in proper Matlab syntax. It is tedious to guess the type of your data. While "NA" must be a string, the rest of this thread concerned NaN, which is a double number.
Again: Please open a new thread for a new question. Then please post the complete code. "isempty(strfind(l,'NA'))" is only a hint, but we cannot see, where what is deleted by which command.
A bold guess:
C = {0.255898, 'NA', 0.257966; ...
0.180000, 'RNASE', 0.389999; ...
0.892222, 'NA', 0.458888; ...
0.155523, 'GNAS', 0.892133};
Key = C(:,2);
keep = ~cellfun('isempty', strfind(Key, 'NA')) & ~strcmp(Key, 'NA');
Wanted = C(keep, :)
Now this comment has no relation to my answer or to the original question. You cannot vote or accept this solution. So actually Meh's thread has been "highjacked".

Sign in to comment.

More Answers (2)

Chris Turnes
Chris Turnes on 7 Mar 2017
Not that this question needed another answer, but, you can also check out the rmmissing function that was introduced in R2016b. If you combine this with standardizeMissing, you can convert your 'GNAs' strings to a standard missing indicator, and then remove the rows with rmmissing.

  0 Comments

Sign in to comment.


carmen
carmen on 12 Mar 2012
check out the isnan() functioion. the following code looks like a workaround but it works:
A=[1 2 3;nan 4 5;nan 6 nan];
B=A(sum(isnan(A),2)==0);
B %returns the only nan-free row of A: [1 2 3]
hf

  0 Comments

Sign in to comment.

Sign in to answer this question.

Tags