Correlation between multiple columns of table

Question

Daphne PARLIARI 2021-6-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/859455-correlation-between-multiple-columns-of-table

评论： Daphne PARLIARI 2021-6-18

Mortality-pollution.xlsx

Hi guys!

I have a table (see attached) for which I want to calculate corrcoef ([r p]) between multiple columns. Eg. between column 2 and column 6, column 2 and column 7, then column 3 and column 6, column 3 and column 7. The last combination would be column 5 and column 12.

Is there a way to do it a with a loop (or any other way, as a matter of fact) and automatically store the values in a new table so that I don't mix them up?

Thanks in advance!

I'm on Matlab 2019a.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

KSSV 2021-6-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/859455-correlation-between-multiple-columns-of-table#answer_727625

在 MATLAB Online 中打开

iwant = zeros(2,2,[]) ;
count = 0 ; 
for r = 2:3
    for p = 6:7
        count = count+1 ; 
        iwant(:,:,count) = corrcoef(data(:,r),data(:,p)) ; 
    end
end
iwant(:,:,count+1) = corrcoef(data(:,5),data(:,12)) ; 