MATLAB: Calculate the mean of the values in each time serie

time series

Hello, i have a data of time series. I want to get these data on regular time intervals (each 15 min). How I can achieve this task under matlab?

Best Answer

If you have a new enough version of MATLAB, you can use a timetable() and use retime()

Related Solutions

MATLAB: How to retime time series data every 15 minutes, or if it is not possible, to filter minutely data to 15-minutes data

To retime your data in every 15 minutes, first you should convert your data into 'timetable,' next create datetime vector (= resampling timing) and finally apply retime function. Here is an example.

load('rainanalysisdata.mat');
% Convert to timetable
rainanalysis.DatumUhrzeit = datetime(rainanalysis.DatumUhrzeit);
rainanalysis = table2timetable(rainanalysis);
% Create time vector (15 min duration)
t = rainanalysis.DatumUhrzeit(1);
startTime = datetime(t.Year,t.Month,t.Day,t.Hour,0,0);
time = (startTime:minutes(15):rainanalysis.DatumUhrzeit(end))';
% Resampling
rainanalysis2 = retime(rainanalysis,time,'linear');

MATLAB: Computing the average of all each month from all data in time series

Hey, I understand that you want the average of each column (representing months).

You can use mean() to do that.

For example if you want average of 2nd,3rd and 4th column you can use

avg=mean(data(:,2:4),2);

This will return a 1X3 matrix with mean of 2,3 and 4 columns respectively.

Note:- I'm assuming you are importing the data as matrix.

For more info on mean() refer mean

Best Answer

Related Solutions

MATLAB: How to retime time series data every 15 minutes, or if it is not possible, to filter minutely data to 15-minutes data

MATLAB: Computing the average of all each month from all data in time series

Related Question