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

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

[Walter Roberson]

perhaps do an innerjoin() first ?

[Madeline Daveney]

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]

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