Create table from data

5 次查看（过去 30 天）

DavidL88 2021-1-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/715138-create-table-from-data

评论： Adam Danz 2021-1-13

I'm trying to extract some data (A1-4) and place it into a table. I get the error message "Error using vertcat - Dimensions of arrays being concatenated are not consistent." Can you advise what this is and how I can fix it?

The overall script the below code is from is more complex. The purpose of it is to extract data from a large number of statistical tests from multiple subjects and place the data in one table. When I run the script on one file (one subject and one test) I get the same error message. When I remove T1-4 from within the [ ] below and run it on one file then the table comes out fine. However, if I do that with all my files in a loop then the table comes out empty. For the one file I tested it on; A1-3 are 1x94 double and A4 is 1x94 cell.

 T1 = [T1; A1]';
 T2 = [T2; A2]';
 T3 = [T3; A3]';
 T4 = [T4; A4]';
T = table(T4, T1, T2, T3)

13 个评论
显示 11更早的评论隐藏 11更早的评论

DavidL88 2021-1-12

在 MATLAB Online 中打开

Hi Adam

I have the T variables as T1 = []; at the start of the script. It says the line causing the error is T1 = [T1; A1]'; I ran size as you suggested. It comes out different as below which would suggest this is the issue (it would be simpler to just run without T variables but it doesn't seem to work then when I loop it for a group of test files).

size(T1,2) = 1
size(A1,2) = 94

I ran T = [A1;A2;A3;A4]; and got the below message.

Error using vertcat
Dimensions of arrays being concatenated are not consistent. Consider converting input arrays to the same type before
concatenating.
Error in working_file (line 33)
T = [A1;A2;A3;A4];

All the A's for this one test are 1x94 double so 1 row and 94 columns. All the T's are blank.

For clarity, I copy the entire script below. Removing the T variables and just using T = table(A4, A1, A2, A3) after 'end' gives what I'm looking for when sFiles = one test. But when sFiles = all tests I get back a blank for all the A variables (A = []) and for the table (T = 0×4 empty table).

% Process: Select files using search query
sFiles = subject/test 
 T1 = [];
 T2 = [];
 T3 = [];
 T4 = [];
for iFile = 1:length(sFiles)
 DataMat = in_bst_data(sFiles(iFile).FileName);
 
 tvalue = DataMat.tmap
 pvalue = DataMat.pmap
 time = DataMat.Time
 
 col = (find(DataMat.pmap(1,:)<0.05));
  
 [X Y]=size(col);
 
 A1 = (tvalue(:,col));
 A2 = (pvalue(:,col));
 A3 = (time(:,col));
 A4 = (repmat({DataMat.Comment},1,Y'));
  
 T1 = [T1;A1]';
 T2 = [T2;A2]';
 T3 = [T3;A3]';
 T4 = [T4;A4]';
 
end
T = table(T4, T1, T2, T3)

DavidL88 2021-1-13

Thank you!

I wanted to accept your answer but can't see the option next to your comment?

Adam Danz 2021-1-13

I copied the comment I think you're referencing to the answers section. Thanks for keeping the forum tidy!

请先登录，再进行评论。

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

采纳的回答

Adam Danz 2021-1-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/715138-create-table-from-data#answer_597253

在 MATLAB Online 中打开

Summary of comments under the question,

Instead of initializing T as an empty cell, use an empty table.

T = table(); 
A1 = array2table(rand(3,3));
C = [T,A1]
C = 3x3 table
     Var1       Var2       Var3  
    _______    _______    _______

    0.73391    0.42024    0.11362
    0.81381    0.81976    0.94401
    0.23762    0.68696    0.64335