table with NaNs into separate cells

1 次查看（过去 30 天）

显示更早的评论

puccapearl 2024-4-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2111461-table-with-nans-into-separate-cells

评论： Voss 2024-4-25

采纳的回答： Voss

I have a table (M) with 4 columns (columns named X, Y, Z,K) , there is a break between the data that loads as NaN.

I want place each data chunk into cells with all 4 columns (X, Y, Z,K).

Thank you!

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

请先登录，再进行评论。

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

采纳的回答

Voss 2024-4-24

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2111461-table-with-nans-into-separate-cells#answer_1447401

在 MATLAB Online 中打开

% making a table with some all-NaN rows:
Var = randi(100,12,4);
Var([3 9],:) = NaN;
M = array2table(Var)
M = 12x4 table
    Var1    Var2    Var3    Var4
    ____    ____    ____    ____

      7      12       6       2 
     80      39      44      44 
    NaN     NaN     NaN     NaN 
     48      78      45      83 
      3      97      37      62 
     35      55      21       4 
     37      44      22      79 
     85      95      92      85 
    NaN     NaN     NaN     NaN 
     98      21      58      64 
     13      57       8      58 
     96      89      36      89 
% split the table on the all-NaN rows into a cell array of tables:
idx = find(all(isnan(M{:,:}),2));
s_idx = [1; idx+1];
e_idx = [idx-1; size(M,1)];
result = arrayfun(@(s,e)M(s:e,:),s_idx,e_idx,'UniformOutput',false)
result = 3x1 cell array
    {2x4 table}
    {5x4 table}
    {3x4 table}
celldisp(result)
 
result{1} =
 
    Var1    Var2    Var3    Var4
    ____    ____    ____    ____

      7      12       6       2 
     80      39      44      44 

 
 
result{2} =
 
    Var1    Var2    Var3    Var4
    ____    ____    ____    ____

     48      78      45      83 
      3      97      37      62 
     35      55      21       4 
     37      44      22      79 
     85      95      92      85 

 
 
result{3} =
 
    Var1    Var2    Var3    Var4
    ____    ____    ____    ____

     98      21      58      64 
     13      57       8      58 
     96      89      36      89 

 