How to calculate Daily mean and monthly mean from hourly data?

I have hourly data for 5years continuasly and I would like to calculate daily mean and montly mean.

Sample data file attached

Answer 1

[Akira Agata]

I would recommend the following steps:

1. Import the data file
2. Arrange the data and create timetable variable
3. 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');

[Lejla Latifovic]

Hello, I follow this example but get this error message: "Undefined function 'retime' for input arguments of type 'table'." Do you have any ideas why?

I combined two vectors (date and temperature) to form a table, like this: TT = table(date,Ta_D, 'VariableNames' , {'Date' 'T'})

TT:

12/31/2020 23:36:06 -0.273

01/01/2021 00:06:07 -0.443

[Akira Agata]

Hi @Lejla Latifovic

Before applying retime function, please convert your 'table' variable into 'timetable' by using table2timetable function.

[Lejla Latifovic]

Fabulous, thank you so much! I was able to get it to work and plot.

[Jack]

Is there a way to use timetables to calculate statistics for a specific date?

For example, what is the average high temperature on July 4th over the last 30 years?