Create table from data

1 次查看（过去 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

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

请先登录，再进行评论。

类别

MATLAB Language Fundamentals Data Types Cell Arrays

在 Help Center 和 File Exchange 中查找有关 Cell Arrays 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by

Create table from data

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

采纳的回答

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

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

Create table from data

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

采纳的回答

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

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

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

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