Erase all the rows that contain NaN

Question

在 MATLAB Online 中打开

0 个投票

Dear all

I have

[N,T,R]=xlsread(name)

I want to erase all the rows in R that contain only NaN

thanks

[EDITED, copied from comments]:

So to input cell matrix is

 'TOTPAIN'            [NaN]                   [6.9150]
              [1x40 char]    [NaN]                  [6.90]
    [                NaN]    [NaN]                             [NaN]
    [                NaN]    [NaN]                       [NaN]
    'MAS'                   [NaN]                           [NaN]
    'MAR PACK G'        [NaN]                            [6.7]
    'MA 3 PACK 58G'        [NaN]              [6.7]

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

Follow Question

Answer 1

Miro 2012-7-18

编辑：Miro 2012-7-18

在 MATLAB Online 中打开

0 个投票

hi,

try this

[n,~]=size(R)
R_new = [];
for i = 1 : n
  R_tmp = R(i,:);
  if length(find(isnan(R_tmp)) ~= length(R_tmp) 
    R_new = [R_new;R_tmp]
  end
end

7 个评论
显示 5更早的评论隐藏 5更早的评论

Sabbas 2012-7-18

编辑：Sabbas 2012-7-18

Hi Simon. Yes, xlsread. I edited my question to correct this mistake So R is a cell matric that contains 'NaN', and other string variables like 'Hello' etc

Miro 2012-7-18

编辑：Miro 2012-7-18

在 MATLAB Online 中打开

sorry for the missunderstanding. the following should work Your example looks like you want to delete the Coloumn, not the Row... For deleting the column try the following:

      function Rout = deleteNAN(Rin)
      [~,n]=size(R)
      R_new = {};
      for i = 1 : n
          R_tmp = cell2mat(R(:,i));
          if length(find(isnan(R_tmp))) ~= length(R_tmp) 
            R_new = [R_new R_tmp]
          end
      end
      Rout = R_new

Store this in a .m file in your current folder and run it.

Answer 2

Jan 2012-7-18

在 MATLAB Online 中打开

0 个投票

Perhaps something like this:

index = cellfun(@isequalwithequalnans, R, {NaN});
R(all(index, 2)) = [];

But due to a vague defined input, this contains too much guessing to be reliable. Sorry.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Sabbas 2012-7-18

在 MATLAB Online 中打开

thanks simon. I applied you code and I obtain the following error message

Error using ==> cellfun All of the input arguments must be of the same size and shape. Previous inputs had size 376 in dimension 1. Input #3 has size 1.

So to input cell matrix is

 'TOTPAIN'            [NaN]                   [6.9150]
              [1x40 char]    [NaN]                  [6.90]
    [                NaN]    [NaN]                             [NaN]
    [                NaN]    [NaN]                       [NaN]
    'MAS'                   [NaN]                           [NaN]
    'MAR PACK G'        [NaN]                            [6.7]
    'MA 3 PACK 58G'        [NaN]              [6.7]

thanks

Answer 3

Andrei Bobrov 2012-7-18

在 MATLAB Online 中打开

0 个投票

Rout = R(~all(cellfun(@(x)all(isnan(x)),R),2),:)

4 个评论
显示 2更早的评论隐藏 2更早的评论

Jan 2012-7-18

@Sabbas: Do you get a "warning" or an "error"? In both cases posting the message would be a good idea.

Sabbas 2012-7-20

Well, I get neither error nor warning. The rows full of NaNs still remain in the matrix. If I run the above codes you kindly provide for a matrix of 3 columns it seems to work

Erase all the rows that contain NaN

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

回答（3 个）

7 个评论
显示 5更早的评论隐藏 5更早的评论

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

4 个评论
显示 2更早的评论隐藏 2更早的评论

标签

Community Treasure Hunt

Erase all the rows that contain NaN

0 个评论 显示 -2更早的评论 隐藏 -2更早的评论

回答（3 个）

7 个评论 显示 5更早的评论 隐藏 5更早的评论

1 个评论 显示 -1更早的评论 隐藏 -1更早的评论

4 个评论 显示 2更早的评论 隐藏 2更早的评论

标签

另请参阅

Community Treasure Hunt

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

7 个评论
显示 5更早的评论隐藏 5更早的评论

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

4 个评论
显示 2更早的评论隐藏 2更早的评论