How to split a column with numerical values?

S = load('data.mat');
ICCs = S.ICCs
ICCs = 1×72 struct array with fields:
    Metrics
T = array2table(vertcat(ICCs.Metrics),'VariableNames',{'XX','YY','ZZ'})
T = 72×3 table
XXYYZZ_____________________

93769    0.92456    0.99817
86066    0.90427    0.99263
84509    0.85719    0.98951
8738    0.89004    0.99273
55918    0.68187    0.55212
7432    0.56476    0.70838
67489    0.51727    0.64014
764    0.72324     0.6591
81925    0.90581    0.90397
71105    0.74472    0.83758
71823    0.71584    0.84393
90053    0.85199    0.96139
90284    0.82024    0.98977
78653    0.76117    0.97559
75978    0.70471    0.97234
78341    0.70018    0.97691
T = splitvars(struct2table(ICCs),'Metrics','NewVariableNames',{'XX','YY','ZZ'})
T = 72×3 table
XXYYZZ_____________________

93769    0.92456    0.99817
86066    0.90427    0.99263
84509    0.85719    0.98951
8738    0.89004    0.99273
55918    0.68187    0.55212
7432    0.56476    0.70838
67489    0.51727    0.64014
764    0.72324     0.6591
81925    0.90581    0.90397
71105    0.74472    0.83758
71823    0.71584    0.84393
90053    0.85199    0.96139
90284    0.82024    0.98977
78653    0.76117    0.97559
75978    0.70471    0.97234
78341    0.70018    0.97691

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

Stephen23 2022-4-26

@Tomaszzz: did my answer resolve your question?

请先登录，再进行评论。

Answer 2

KSSV 2022-3-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1661645-how-to-split-a-column-with-numerical-values#answer_907710

编辑：KSSV 2022-3-2

在 MATLAB Online 中打开

load('data.mat')
name = reshape(struct2array(ICCs),3,[])' ;
T = array2table(name);

Or you can use

load('data.mat')
T = struct2table(ICCs);

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

Stephen23 2022-3-2

编辑：Stephen23 2022-3-2

data.mat

Avoid this code, it is not robust. Consider what would happen if the structure contains other fields.

One of the main benefits of using structures is that each field can be processed independently. This approach using STRUCT2ARRAY discards that benefit, making the code more fragile to future data changes.

EDIT: after KSSV editted and added a second approach: the second code suggestion does not work because the OP requested three columns in the table, and that code only returns one.

Sigh.

请先登录，再进行评论。

Answer 3

Mathieu NOE 2022-3-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1661645-how-to-split-a-column-with-numerical-values#answer_907760

在 MATLAB Online 中打开

hello

this would be my suggestion

 load data.mat
 
 % convert structure to numerical array
 a = struct2cell(ICCs);
 a = squeeze(a);
 a = vertcat(a{:});
 
 % create table
 t = array2table(a,'VariableNames',{'name 1' 'name 2' 'name 3'});

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

Stephen23 2022-3-2

One of the main benefits of using structures is that each field can be processed independently. This approach using STRUCT2CELL discards that benefit, making the code more fragile to future data changes.

SQUEEZE (which is an abomination anyway) is not required if the variable is used for a comma-separated list.

请先登录，再进行评论。