Sorting correlation matrix- with row and column information - need help..

Question

soni 2014-4-29

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/127584-sorting-correlation-matrix-with-row-and-column-information-need-help

回答： Ronit 2024-6-21

Hi, I am trying to sort a correlation matrix (high to low)

using

MeanCorrMatPerm=mean(data);

[sortedCorr indPerm]=sort(MeanCorrMatPerm,'descend');

imagesc(data(indPerm,indPerm));

When I am sorting only numerical values I am getting results, but I don't know how to get results with row and column names( Altered rows and column names after sorting). Please help me with this problem. Thank you.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

dpb 2014-4-29

How do you have the names stored? You reference that (cell array?) by the order vector.

请先登录，再进行评论。

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

Answer 1

Ronit 2024-6-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/127584-sorting-correlation-matrix-with-row-and-column-information-need-help#answer_1475276

在 MATLAB Online 中打开

Hello Soni,

I understand you are trying to sort a correlation matrix along with its row and column names. Below is a solution that addresses this issue effectively:

% Define the correlation matrix and row/column names

data = [1 0.799 0.193 0.298 -0.111;

0.799 1 0.153 0.218 -0.172;

0.193 0.153 1 0.036 0.086;

0.298 0.217 0.036 1 0.333;

-0.111 -0.171 0.086 0.333 1];

names = {'a', 'b', 'c', 'd', 'e'};

% Compute the mean of the correlation matrix

MeanCorrMatPerm = mean(data);

% Sort the mean values in descending order

[sortedCorr, indPerm] = sort(MeanCorrMatPerm, 'descend');

% Reorder the matrix and the row/column names

sortedData = data(indPerm, indPerm);

sortedNames = names(indPerm);

% Display the reordered matrix with the new row and column names

imagesc(sortedData);

set(gca, 'XTick', 1:length(sortedNames), 'XTickLabel', sortedNames);

set(gca, 'YTick', 1:length(sortedNames), 'YTickLabel', sortedNames);

colorbar;

This script will compute the correlation matrix, sort it, and reorder the row and column names accordingly, providing you with a neatly sorted correlation matrix.

Hope it helps!