Get all unique combinations of 2 columns from a table

12 次查看（过去 30 天）
Austin B
Austin B 2022-1-19
评论： Austin B 2022-1-19
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.

请先登录，再回答此问题。

采纳的回答

Stephen23
Stephen23 2022-1-19
Ran in:
V = {'Item1','Item2','Item3','Item4'};
T = table(1, 5, 7 ,10, 'VariableNames',V)
T = 1×4 table
Item1 Item2 Item3 Item4 _____ _____ _____ _____ 1 5 7 10
X = nchoosek(1:numel(V),2);
D = diff(T{:,V}(X),1,2);
Z = cell2table([V(X),num2cell(D)])
Z = 6×3 table
Var1 Var2 Var3 _________ _________ ____ {'Item1'} {'Item2'} 4 {'Item1'} {'Item3'} 6 {'Item1'} {'Item4'} 9 {'Item2'} {'Item3'} 2 {'Item2'} {'Item4'} 5 {'Item3'} {'Item4'} 3

更多回答（1 个）

Cris LaPierre
Cris LaPierre 2022-1-19
I would look into using the perms function, along with the unique and diff functions.
  3 个评论
显示 1更早的评论
Cris LaPierre
Cris LaPierre 2022-1-19
Ran in:
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)
C = 6×2 cell array
{'Item1'} {'Item2'} {'Item1'} {'Item3'} {'Item1'} {'Item4'} {'Item2'} {'Item3'} {'Item2'} {'Item4'} {'Item3'} {'Item4'}
delta = diff([T{1,{C{:,1}}};T{1,{C{:,2}}}])
delta = 1×6
4 6 9 2 5 3

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by