how to easily and quickly change the variable names (headers) of multiple tables
32 次查看(过去 30 天)
显示 更早的评论
Hi,
I have 20 tables, let's call them A,B,C.....etc. with size of 1000 lines and 40 column.
I would like to concatenate them all in dimension 1, using function
cat(1,A,B,C.....etc)
the problem is that I must assign each table the same Headers (variable names) to each column, to be able to concanenate them all. Right now, they are all different, because the Headers were assigned by MATLAB somewhere in my code.
Right now, the code I have is
A.Properties.VariableNames{1}='Header1'
and the code above works perfectly for assigning the variable name 'Header1' to the column 1 of Table A.
However, I am pretty confident that there is a way to automate this for every case (20 tables and 40 columns), without the need to write 800 lines of code (20*40), which obviously makes no sense. Any help is appreciated.
Thank you very much,
Best regards,
0 个评论
采纳的回答
Walter Roberson
2022-3-11
A.Properties.VariableNames can be assigned a cell array of character vectors to change all of the names. This would reduce down to 20 lines.
Alternatively, table2cell all the tables, vertcat the result, cell2table with 'VariableNames' option
1 个评论
Jon
2022-3-11
In particular you can assign
B.Properties.VariableNames = A.Properties.VariableNames
C.Properties.VariableNames = A.Properties.VariableNames
% etc
Better if you had an array of tables you could do this in a loop.
更多回答(1 个)
Scott MacKenzie
2022-3-11
For each table, it can be done like this: (To illustrate, this example is just for 5 columns)
T = array2table(rand(3,5));
vn = repmat("Header", 1,5) + string(1:5)
T.Properties.VariableNames = vn
0 个评论
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!