How do I correlate two tables with a different number of rows?

Question

Madeline Daveney 2020-6-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/549027-how-do-i-correlate-two-tables-with-a-different-number-of-rows

回答： Divya Gaddipati 2020-6-25

Hi,

I have two tables that I am trying to correlate, but they have a different amount of rows, so matlab is not allowing me to correlate them.

Is there a way to curcumvent different row length in this situation?

Regards,

M

2 个评论
显示无隐藏无

Walter Roberson 2020-6-16

perhaps do an innerjoin() first ?

Madeline Daveney 2020-6-17

编辑：Madeline Daveney 2020-6-17

在 MATLAB Online 中打开

I think that I solved the problem by putting NaN to fill up cells in the table that didn't have enough rows. Then I specified 'rows' 'complete' so that matlab would only correlate the cells that actually had values.

Here's an example for anyone who needs help with a similar problem in the future:

[r, pV]=corr(FAs_all,ESS_all,'rows','complete')

Thanks for your suggestion anyway!

请先登录，再进行评论。

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

Answer 1

Divya Gaddipati 2020-6-25

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/549027-how-do-i-correlate-two-tables-with-a-different-number-of-rows#answer_457051

You could also convert the table to a matrix and use interpolation on the smaller matrix to resize it to the larger matrix's size. Then use corrcoef or corr2 to calculate the correlation.

You could also refer to a similar questions already asked:

https://www.mathworks.com/matlabcentral/answers/34238-corrcoef-vectors-of-different-lengths

https://www.mathworks.com/matlabcentral/answers/346341-correlation-between-two-matrices-with-different-number-of-rows-and-columns

For more information on corr2 and corrcoef, refer to the following links:

https://www.mathworks.com/help/matlab/ref/corrcoef.html

https://www.mathworks.com/help/images/ref/corr2.html