How to convert hourly observations to monthly mean ?

1 次查看（过去 30 天）
Aarti Soni
Aarti Soni 2022-8-18
编辑： Aarti Soni 2022-9-16
Hello everyone,
I have 3hourly data for 10years. The datasets are arranged in different folders, e.g., there are 10 different folders (from 2001-2010) and each folder contains 12 folders (January to December) then each folder has 30 or 31 or 29 .nc files. Dimension of data is 180 X 360 X 4 X 8 (latitude X longitude X number of layers X number of observations in a day).
I want to take the layer wise mean of data. First of all I need to take a layer wise mean of hourly observation which will represent daily mean of data (output will be 180 X 360 X 4) then I need to convert this daily observation into monthly mean (output will be 180 X 360 X 4).
How can I read this data from different folders?
How can I convert the hourly observations into monthly observations?
I hope I am able to explain the question.
Thanks in advance.

请先登录，再回答此问题。

回答（1 个）

Abderrahim. B
Abderrahim. B 2022-8-18
Hi!
You can use retime function, but before make sure you have a timetable.
% Convert to timetable if you have standard table
TTble_hourly = table2timetable(TTble_hourly);
% Use retime
TTble_MonthMean = retime(TTble_hourly,'monthly','mean') ;
Hope this helps

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by