MATLAB: How to correlate two tables with a different number of rows

Question

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

Answer 1

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