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

57 ビュー (過去 30 日間)
Jeevan Kumar Bodaballa 2020 年 2 月 5 日

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

サインインしてコメントする。

### 採用された回答

Akira Agata 2020 年 2 月 25 日
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:
opts = detectImportOptions('test_pog.txt');
% 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');

サインインしてコメントする。

### Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by