Trouble concatenating a cell.

2 次查看(过去 30 天)
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
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 个)

类别

Help CenterFile 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