Expanding a cell array in table into multiple rows

Question

AT_HYZ 2024-3-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2090871-expanding-a-cell-array-in-table-into-multiple-rows

编辑： Matt J 2024-3-6

Hi, I have a table like this

I would like to have something like this but for Column A and B, I would like to split into 1500 x 1 double for 123 rows and for B, the same 1500x1 double should be printed into 123 rows. It's something like below but I don't know how to work for column A and B. Column A is basically becoming a column vector (1500 x 1 double) from a matrix (1500x123).

Could anyone help? thank you.

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

Dyuman Joshi 2024-3-6

Please save the table as a .mat file and share it here. Use the paperclip button to upload.

请先登录，再进行评论。

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

Answer 1

Matt J 2024-3-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2090871-expanding-a-cell-array-in-table-into-multiple-rows#answer_1421681

编辑：Matt J 2024-3-6

在 MATLAB Online 中打开

Here's a scaled-down example:

T=table(1,2,3,{rand(4,3)}, {rand(4,1)}); 
   T.Properties.VariableNames(end-1:end)=["A","B"]
T = 1×5 table
    Var1    Var2    Var3         A               B      
    ____    ____    ____    ____________    ____________

     1       2       3      {4×3 double}    {4×1 double}
n=width(T{1,"A"}{1});
   
   
T=repmat(T,n,1);
T.A=reshape( num2cell(T{:,"A"}{1},1), [],1)
T = 3×5 table
    Var1    Var2    Var3         A               B      
    ____    ____    ____    ____________    ____________

     1       2       3      {4×1 double}    {4×1 double}
     1       2       3      {4×1 double}    {4×1 double}
     1       2       3      {4×1 double}    {4×1 double}