How to apply calculation over multiple columns in a matrix

Hello,

I have a matrix (1503x7) where each column is a time series data. I need to apply the following calculation to each column in my matrix, so that each time data serie (each column) will be normalized to 100 points:

x = linspace(0,100,length(presentMatrix));
y = 0:100;
newMatrix= spline(x,presentMatrix y);

Any suggestion how to do it? Thank you!!!!!!

Answer 1

[Matt J]

The code you've posted already does it, after transposition.

x = linspace(0,100,length(presentMatrix));
y = 0:100;
newMatrix= spline(x,presentMatrix', y)';

[Adam Danz]

I'd use height(presentMatrix) rather than length(). If this is every applied to a matrix that is wider than it is tall, this will fail.

[Eleonora Montagnani]

Thanks Matt, it did work, in my code I just missed to add ' to define the transpose!