Create tables based on matching columns by identical names

11 visualizzazioni (ultimi 30 giorni)
Hi,
I have two tables with four separate columns. Each column in each table has a unique variable name. However, the variable names match between position 5 and 10 for two columns (one in each table). I want to create four new tables consisting of two columns where the variable names match. So far, I have tried the following:
names5 = Table_A.Properties.VariableNames;%1
names6 = Table_B.Properties.VariableNames;%1
matchVals = {'1234', '5678','9101','1123'}; %part of the variable names that match => four new tables
numTables = numel(matchVals);
%%
tableNames_ = cell(numTables,1);
for k = 1:numel(matchVals)
idl5 = cellfun(@(x) strcmp(x(5),matchVals{k})... %assessing position 5 to 10 for correct variable names
&&strcmp(x(6),matchVals{k})...
&&strcmp(x(7),matchVals{k})...
&&strcmp(x(8),matchVals{k})...
&&strcmp(x(9),matchVals{k})...
&&strcmp(x(10),matchVals{k}),names5);
idl6 = cellfun(@(x) strcmp(x(5),matchVals{k})...%assessing position 5 to 10 for correct variable names
&&strcmp(x(6),matchVals{k})...
&&strcmp(x(7),matchVals{k})...
&&strcmp(x(8),matchVals{k})...
&&strcmp(x(9),matchVals{k})...
&&strcmp(x(10),matchVals{k}),names6);
%
eval(['Summary',matchVals{k},' = [Table_A(:,idl5) Table_B(:,idl6)]']);
tableNames_EC2217{k} = ['Summary',matchVals{k}]; %trying to create new table
end
The code runs, but my columns are not matched. I.e. my out put includes the new tables but without any row values from the original tables.
Any help is appreciated.

Risposta accettata

Vatsal
Vatsal il 26 Set 2023
Hi @Vlatko,
I understand that you have two tables “Table_A” and “Table_B” and both the tables contain four columns, each column having a unique variable name. Given that the variable names in the two columns (one from each table) match between positions 5 and 10, the objective is to generate four new tables. These tables will specifically contain two columns each, where the variable names match.
I am attaching the code which creates four new tables consisting of two columns where the variable names match: -
names5 = Table_A.Properties.VariableNames;
names6 = Table_B.Properties.VariableNames;
matchVals = {'1234', '5678', '9101', '1123'};
numTables = numel(matchVals);
tableNames_ = cell(numTables, 1);
for k = 1:numel(matchVals)
pattern = matchVals{k};
startIdx = 5; % Starting index
endIdx = 10; % Ending index
idl5 = cellfun(@(x) contains(x(startIdx:endIdx), pattern), names5);
idl6 = cellfun(@(x) contains(x(startIdx:endIdx), pattern), names6);
eval(['Summary', matchVals{k}, ' = [Table_A(:, idl5) Table_B(:, idl6)];']);
tableNames_{k} = ['Summary', matchVals{k}];
end
You can also refer to the MATLAB documentation for the function "contains" to obtain more information on its usage and syntax. The link is provided below:
I hope this helps!

Più risposte (0)

Categorie

Scopri di più su Cell Arrays in Help Center e File Exchange

Prodotti

Community Treasure Hunt

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

Start Hunting!

Translated by