Get all unique combinations of 2 columns from a table
10 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Austin Burritt
le 19 Jan 2022
Commenté : Austin Burritt
le 19 Jan 2022
I have a table that has 4 variables, similar to this:
Item1 Item2 Item3 Item4
_____ _____ _____ _____
1 5 7 10
What is the best way to produce the delta of each combination of columns? Ex. Item1 vs Item2, Item1 vs Item3, etc.
0 commentaires
Réponse acceptée
Stephen23
le 19 Jan 2022
V = {'Item1','Item2','Item3','Item4'};
T = table(1, 5, 7 ,10, 'VariableNames',V)
X = nchoosek(1:numel(V),2);
D = diff(T{:,V}(X),1,2);
Z = cell2table([V(X),num2cell(D)])
0 commentaires
Plus de réponses (1)
Cris LaPierre
le 19 Jan 2022
3 commentaires
Cris LaPierre
le 19 Jan 2022
I was probably trying too hard to make use of the variablenames. Stephen's approach is simpler by using column numbers instead.
T = table(1, 5, 7 ,10, 'VariableNames', {'Item1' 'Item2' 'Item3' 'Item4'});
C = nchoosek(T.Properties.VariableNames,2)
delta = diff([T{1,{C{:,1}}};T{1,{C{:,2}}}])
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!