Expanding a cell array in table into multiple rows

Question

0 个投票

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.

请先登录，再进行评论。

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

Follow Question

Answer 1

Matt J 2024-3-6

编辑：Matt J 2024-3-6

在 MATLAB Online 中打开

0 个投票

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}

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

请先登录，再进行评论。

Expanding a cell array in table into multiple rows

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

采纳的回答

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

更多回答（0 个）

类别

标签

Community Treasure Hunt

Expanding a cell array in table into multiple rows

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

采纳的回答

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

更多回答（0 个）

类别

标签

另请参阅

Community Treasure Hunt

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

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