MATLAB Answers

Delete rows with NaN records

1,192 ビュー (過去 30 日間)
Meh
Meh 2012 年 3 月 12 日
コメント済み: Jan 2017 年 3 月 8 日
How can I delete rows which have NaN on one of the column.

  0 件のコメント

Sign in to comment.

採用された回答

Jan
Jan 2012 年 3 月 12 日
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 件のコメント

表示 1 件の古いコメント
Jan
Jan 2017 年 3 月 7 日
@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 2017 年 3 月 8 日
_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 2017 年 3 月 8 日
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.

その他の回答 (2 件)

Chris Turnes
Chris Turnes 2017 年 3 月 7 日
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 件のコメント

Sign in to comment.


carmen
carmen 2012 年 3 月 12 日
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 件のコメント

Sign in to comment.

タグ


Translated by