MATLAB: How to partition hourly Data by month

retimetimetable

Hi,i have 20-years hourly data converted into timetable,i need to retime my data to month running mean timetable and then substract my data from it. is it possible with retime function ? Otherwise, how to partition the data by month using reshape and taking into account leap and regular years ?

Thanks

Best Answer

Yes, you can calculate monthly mean of your timetable by retime function, like this. More details can be found in the help page of retime function .

outputTT = retime(yourTT,'monthly','mean')

Related Solutions

MATLAB: How to assign multiple strings to single variable

Try

>> jan = arrayfun( @(num) sprintf('jan_%4d',num), (1958:2018), 'uni',false );
>> jan(1:3)
ans =
  1×3 cell array
    {'jan_1958'}    {'jan_1959'}    {'jan_1960'}

MATLAB: How to calculate Daily mean and monthly mean from hourly data

I would recommend the following steps:

Import the data file
Arrange the data and create timetable variable
Apply retime funciton to obtain daily/monthly average

The following is an example:

% Read the data file
opts = detectImportOptions('test_pog.txt');
T = readtable('test_pog.txt',opts);
% Make a datetime vector
Time = datetime(T{:,1},'InputFormat','yyyy.MM.dd.');
Time.Hour = T{:,2};
% Add the datetime vector and remove the 1st&2nd columns
T.Time = Time;
T(:,1:2) = [];
% Convert to timetable
TT = table2timetable(T);
% Apply retime function to obtain daily/monthly mean
TTdailyMean = retime(TT,'daily','mean');
TTmonthlyMean = retime(TT,'monthly','mean');

Best Answer

Related Solutions

MATLAB: How to assign multiple strings to single variable

MATLAB: How to calculate Daily mean and monthly mean from hourly data

Related Question