- Import the data file
- Arrange the data and create timetable variable
- Apply retime funciton to obtain daily/monthly average
How to calculate Daily mean and monthly mean from hourly data?
57 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Jeevan Kumar Bodaballa
el 5 de Feb. de 2020
Comentada: Jack
el 18 de Ag. de 2022
I have hourly data for 5years continuasly and I would like to calculate daily mean and montly mean.
Sample data file attached
0 comentarios
Respuesta aceptada
Akira Agata
el 25 de Feb. de 2020
I would recommend the following steps:
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');
4 comentarios
Lejla Latifovic
el 21 de Abr. de 2022
Fabulous, thank you so much! I was able to get it to work and plot.
Jack
el 18 de Ag. de 2022
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?
Más respuestas (0)
Ver también
Categorías
Más información sobre Timetables en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!