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!