- 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?
38 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Jeevan Kumar Bodaballa
le 5 Fév 2020
Commenté : Jack
le 18 Août 2022
I have hourly data for 5years continuasly and I would like to calculate daily mean and montly mean.
Sample data file attached
0 commentaires
Réponse acceptée
Akira Agata
le 25 Fév 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 commentaires
Jack
le 18 Août 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?
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Timetables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!