How to save to different column array

Question

Mekala balaji 2016-9-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/301970-how-to-save-to-different-column-array

回答： Stephen23 2016-9-5

Hi, I have below matrix and I want to save each column into different arrays (or single column matrix) if at least one row exists a numeric value(because 3rd column does not contain any numeric values, all "NA"):

Input matrix:

3   NA  5 
NA  NA  NA
NA  NA  NA
NA  NA  8

My output should be:

Y1:
1   
2  
5 
6 
Y2:
  3    
  NA  
  NA  
  NA 
Y3:
  5 
  NA
  NA
  8

Please someone help me how to do this,many thanks in advance:

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

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Adam 2016-9-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/301970-how-to-save-to-different-column-array#answer_233845

在 MATLAB Online 中打开

Y = [1 3 NaN 5; 2 NaN NaN NaN; 5 NaN NaN NaN; 6 NaN NaN 8]
Y( :, sum( isnan( Y ) ) == size( Y, 1 ) ) = [];

will remove the columns you don't want, in-place. You can obviously take a copy of your matrix if you still want the original.

There is no reason why you should split it into individually named variables though.

Y(:,1), Y(:,2) works far better than Y1, Y2 in further code.

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

请先登录，再进行评论。

Answer 2

Thorsten 2016-9-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/301970-how-to-save-to-different-column-array#answer_233847

在 MATLAB Online 中打开

Y(:, all(isnan(Y))) = [];

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

请先登录，再进行评论。

Answer 3

Stephen23 2016-9-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/301970-how-to-save-to-different-column-array#answer_233848

在 MATLAB Online 中打开

>> M = [...
    1,  3,NaN,  5
    2,NaN,NaN,NaN
    5,NaN,NaN,NaN
    6,NaN,NaN,  8];
>> out = M(:,any(isfinite(M),1))
out =
     1     3     5
     2   NaN   NaN
     5   NaN   NaN
     6   NaN     8
>> out(:,1)
ans =
     1
     2
     5
     6