how to delete NA from specific rows without delete NA included in strings?

2 ビュー (過去 30 日間)

古いコメントを表示

chocho 2017 年 3 月 8 日

0
リンク

この質問への直接リンク

https://jp.mathworks.com/matlabcentral/answers/328746-how-to-delete-na-from-specific-rows-without-delete-na-included-in-strings

コメント済み: chocho 2017 年 3 月 9 日

採用された回答: Stephen23

MATLAB Online で開く

what's wrong with this command isempty(strfind(l,'NA')) ??

i have used the code below to delete NA rows but when i execute it i found all NA's rows deleted even NA included in strings such as 'RNASE', 'GNAS'.....

fid = fopen('file1.txt','rt');    %open original file
fid2= fopen('file2.txt','wt');      % open new text file
l= fgetl(fid); %first line
l= fgetl(fid); % the second line
while ~feof(fid)
  l=fgetl(fid); %get the next lines
  if isempty(strfind(l,'NA'))==0      %remove NA rows
  else
      idx=regexp(l,'\t','split');
      [nrow,ncol]=size(idx);         %size of idx (total number of columns in every row)
      .........
    end
end

input:

0.121213 NA 0.589999
0.421566 RNASE 0.356955
0.11111 GNAS 0.0311120
0.158881 NA 0.0158999
0.122222 SLTP 0.016666

output:

0.122222 SLTP 0.016666

output wanted:

0.421566 RNASE 0.356955
0.11111 GNAS 0.0311120
0.122222 SLTP 0.016666

0 件のコメント
-2 件の古いコメントを表示-2 件の古いコメントを非表示

サインインしてコメントする。

サインインしてこの質問に回答する。

採用された回答

Stephen23 2017 年 3 月 8 日

1
リンク

この回答への直接リンク

https://jp.mathworks.com/matlabcentral/answers/328746-how-to-delete-na-from-specific-rows-without-delete-na-included-in-strings#answer_257832

編集済み: Stephen23 2017 年 3 月 8 日

MATLAB Online で開く

Try this instead:

if isempty(regexp(l,'\sNA\s','once'))

or perhaps (but less robust):

if isempty(strfind(l,' NA '))

Note also that I removed the unnecessary if- else. Your code currently deletes every row with NA: but you can see that this line also has NA in it:

0.421566 RNASE 0.356955

so it will also get deleted, even though this is not what you want. You want to check for lines that also have space on either side of the NA, like I showed above.