MATLAB Answers

Meh
0

Delete rows with NaN records

Meh
さんによって質問されました 2012 年 3 月 12 日
最新アクティビティ Jan
さんによって コメントされました 2017 年 3 月 8 日
How can I delete rows which have NaN on one of the column.

  0 件のコメント

サインイン to comment.

タグ

3 件の回答

Jan
Answer by Jan
on 12 Mar 2012
 Accepted Answer

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 件のコメント

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
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
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".

サインイン to comment.


Chris Turnes
Answer by 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 件のコメント

サインイン to comment.


carmen
Answer by 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 件のコメント

サインイン to comment.



Translated by