Convert distance matrix to a table

Question

dan kin 2019-6-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/465872-convert-distance-matrix-to-a-table

回答： Akira Agata 2019-6-18

How can I convert the output matrix Z to a table with the following structure?

Object1 Object2 Distance
     2       0.2954
     3       1.0670
     1       0.2954
     3       0.9448
     1       1.0670
     2       0.9448

Code:

rng('default') % For reproducibility
X = rand(3,2);
D = pdist(X)
Z = squareform(D)

7 个评论
显示 5更早的评论隐藏 5更早的评论

Adam Danz 2019-6-17

在 MATLAB Online 中打开

Here's how to convert a matrix to a table and add column names.

m =[1       2       0.2954
     3       1.0670
     1       0.2954
     3       0.9448
     1       1.0670
     2       0.9448];
t = array2table(m,'VariableNames', {'Object1','Object2','Distance'})

Akira Agata 2019-6-18

在 MATLAB Online 中打开

How about making a graph object?

rng('default') % For reproducibility
X = rand(3,2);
D = pdist(X);
Z = squareform(D);
G = graph(Z);

Then, G.Edges becomes almost what you want to obtain, like:

>> G.Edges
ans =
  3×2 table
    EndNodes    Weight 
    ________    _______
     1    2      0.2954
     1    3       1.067
     2    3     0.94476

请先登录，再进行评论。

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

Answer 1

Akira Agata 2019-6-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/465872-convert-distance-matrix-to-a-table#answer_379623

在 MATLAB Online 中打开

Or, if you want the full list of (from, to, distance) set, how about the following?

rng('default') % For reproducibility
X = rand(3,2);
D = pdist(X);
Z = squareform(D);
[row,col] = find(Z);
d = arrayfun(@(r,c) Z(r,c),row,col);
T = table(row,col,d,'VariableNames',{'Object1','Object2','Distance'});
T = sortrows(T);

The result is:

>> T
ans =
  6×3 table
    Object1    Object2    Distance
    _______    _______    ________
       1          2        0.2954 
       1          3         1.067 
       2          1        0.2954 
       2          3       0.94476 
       3          1         1.067 
       3          2       0.94476 