how to take mean of variables from 00 and 12 GMT observations?

4 views (last 30 days)
% Load the grouping data
lat = ncread(ncfile,'latitude');
lon = ncread(ncfile,'longitude');
expver = ncread(ncfile,'expver');
time = ncread(ncfile,'time');
time = datetime(double(time)*60*60,'ConvertFrom','epochtime','Epoch','1901-01-01');
% convert grouping data to 4x4x2x6961 arrays
[Lon,Lat,Expver,Time] = ndgrid(lon,lat,expver,time);
dataTbl = timetable(Time,Lon,Lat,Expver,d2m,t2m,e,pev,ssr,ssrd,tp,vpd,rh)
% Calculate the mean over latitude x longitude x time
data = groupsummary(dataTbl,["Time","Time"],["hourofday","day"],"mean",4:12)
The above code computes daily average for each day over Lat X Lon and writes
the data of number of rows 3482 for 00 GMT and 3481 for 12 GMT out of total number of observations as 6963. I wish to
calculate the daily average for each day from 00 and 12 GMT also. Therefore,
the dimension of output file becomes (3481,9).
I request you all to please suggest me how to do it in above mentioned code.
Sanchit
  5 Comments

Sign in to comment.

Answers (1)

Walter Roberson
Walter Roberson on 20 Jul 2023
Now that you have a timetable, you can retime asking for 'hourly'
  2 Comments
Sanchit
Sanchit on 20 Jul 2023
Thank you very much for your kind suggestion. May I request you to please suggest me how to do it in above mentioned code. I would be grateful to you for your kind help.
Sanchit

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!