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

38 vues (au cours des 30 derniers jours)
Jeevan Kumar Bodaballa
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

Réponse acceptée

Akira Agata
Akira Agata le 25 Fév 2020
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');
  4 commentaires
Lejla Latifovic
Lejla Latifovic le 21 Avr 2022
Fabulous, thank you so much! I was able to get it to work and plot.
Jack
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?

Connectez-vous pour commenter.

Plus de réponses (0)

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!

Translated by