How to concatenate table variables with underscores in their name
1 次查看(过去 30 天)
显示 更早的评论
I have variables like B1_1_3(53x1) B2_1_3(53x1) until B56_1_3(53x1) stored in my table A. I want to concatenate them to receive a new vector(53x56). I tried:
for k in 1:56
a = [A.B{k}_1_3, A.B{k}_1_3];
end
However this does not work. Any suggestions? Thank you in advance!
1 个评论
infinity
2019-7-23
What do you mean by "concatenate them to receive a new vector (53x56) "?
For example,
A = [1 2 3]
B = [1 2 3 4]
what is your output of a new matrix?
采纳的回答
Adam Danz
2019-7-23
编辑:Adam Danz
2019-7-23
No loop needed. Just list all of the table headers, pull out the ones that take the form "B#_1_3", and then create a matrix based on values from those columns.
% Create demo table
A = array2table(rand(6,4),'variableNames',{'B1_1_3','B2_1_3','B3_1_3','total'});
% List all headers
headers = A.Properties.VariableNames;
% Extract headers that have the form B#_1_3
goodHeaders = regexp(headers,'B\d+_1_3','Match');
goodHeaders = [goodHeaders{:}]';
% Create matrix of values from good header columns *see Guillaume's comment below
m = cell2mat(cellfun(@(x)A.(x)',goodHeaders,'UniformOutput',false))';
2 个评论
Guillaume
2019-7-23
Why go through cellfun and cell2mat? m is simply:
m = A{:, goodHeaders}
Adam Danz
2019-7-23
Another approach would be to remove the columns you don't want and keep the data in a table which has its advantages. That solution would look like this.
% Create demo table
A = array2table(rand(6,4),'variableNames',{'B1_1_3','B2_1_3','B3_1_3','total'});
% List all headers
headers = A.Properties.VariableNames;
% Extract headers that have the form B#_1_3
goodHeaderIdx = regexp(headers,'B\d+_1_3');
badHeaderIdx = cellfun(@isempty,goodHeaderIdx);
% Create matrix of values from good header columns
A2 = A;
A2(:,badHeaderIdx) = [];
更多回答(1 个)
llueg
2019-7-23
编辑:llueg
2019-7-24
You could use eval for this. Assuming your data in the table is numeric and you want a matrix as result:
a = zeros(53,56);
for i=1:56
eval(['a(:,i) = A.B' num2string(i) '_1_3'])
end
Edit: It has been pointed out that using eval is unnecessary here and bad in general. See the comments below for better solutions.
I just considered this to be closest to what OP was trying to do, but there are certainly better methods.
3 个评论
Guillaume
2019-7-23
Gah! Why did you accept this answer. Again, eval is bad! extremely bad!. See the link in my comment above for all the ways that it is bad.
Do not use eval and certainly not for this. I've demonstrated a much more reliable method (and simpler, and faster, and etc... read the link).
Adam's method is even more reliable in that it doesn't assume that variables 1 to 56 do exist but check which ones exist.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Whos 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!