Trouble concatenating a cell.

2023 9 21
1 个回答
回答已采纳
更新时间：2023 9 21
9 次查看（30 天）

0 个投票

I want to concatenate the cell in the image such that rows 1,2 and10 are expanded, i.e. rows 1 and 2 each become 4 rows. Row 10 should become 2 rows. Thus, when done, the cell will be size [20 4] and not [13 4].
Ultimately I want this data into a table to write to disk as a csv. I plan to use writetable...
I'm not having any luck with cell concatenation operations gleaned online. Any suggestions?
Thanks.

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

 采纳的回答

Voss
Voss 2023-9-21
编辑：Voss 2023-9-21
Ran in:

0 个投票

Ran in:
Here's one way to make a table out of it:
% a cell array like yours:
tst = { ...
"n"+string(randi(10,4,1)),zeros(4,1),rand(4,1),rand(4,1); ...
"n"+string(randi(10,4,1)),zeros(4,1),rand(4,1),rand(4,1); ...
"n1",0,-3000,-3000; ...
"n2",0,-4000,-4300; ...
"n"+string(randi(10,2,1)),zeros(2,1),rand(2,1),rand(2,1); ...
"n3",0,-4400,-4500; ...
}
tst = 6×4 cell array
{4×1 string} {4×1 double} {4×1 double} {4×1 double} {4×1 string} {4×1 double} {4×1 double} {4×1 double} {["n1" ]} {[ 0]} {[ -3000]} {[ -3000]} {["n2" ]} {[ 0]} {[ -4000]} {[ -4300]} {2×1 string} {2×1 double} {2×1 double} {2×1 double} {["n3" ]} {[ 0]} {[ -4400]} {[ -4500]}
% vertcat each column, store in args cell to be sent to table:
N = size(tst,2);
args = cell(1,N);
for ii = 1:N
args{ii} = vertcat(tst{:,ii});
end
T = table(args{:})
T = 13×4 table
Var1 Var2 Var3 Var4 _____ ____ ________ _______ "n7" 0 0.44091 0.53584 "n1" 0 0.9128 0.38251 "n10" 0 0.10853 0.80617 "n8" 0 0.1388 0.16147 "n2" 0 0.59 0.83124 "n5" 0 0.3631 0.24028 "n10" 0 0.068072 0.79592 "n6" 0 0.88154 0.5531 "n1" 0 -3000 -3000 "n2" 0 -4000 -4300 "n10" 0 0.22986 0.98944 "n10" 0 0.063354 0.11196 "n3" 0 -4400 -4500

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息

产品

版本

R2022a

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by