Clear Filters
Clear Filters

How to convert hourly observations to monthly mean ?

1 view (last 30 days)
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.

Answers (1)

Abderrahim. B
Abderrahim. B on 18 Aug 2022
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

Categories

Find more on Dates and Time in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!