MATLAB: Calculating daily average curve from weekly data

averagehourlytimetableweekly

So i have a big timetable with multiple observation from time period of one week. resolution is one hour I want to shrink it into one day time period and same 1 hour resolution. The one thing that could work is to first calculate observation averages so that the table becomes 168*1 and do a for loop to split every day of week into own columns (24*7 table) and then caculate the averages again so i finally get 24*1 table. Is there a better way to do this? timetable default "mean" function doesn't work for this because "hourly" returns only average of observations, but doesn't shrink my weekly data to daily average.

Best Answer

If i don't get wrong, it seems that you want to perform this operation:

%% Mean along 10 columns
g1m = mean(g1,2);
%% Reshape to get a the desired size
g1m_w = reshape(g1m,[24 7]);
%% Perform the mean again
g1m = mean(g1m_w,2);

Related Solutions

MATLAB: Daily average of several years data

If you can turn your data into a table, use the groupsummary function. Assuming you want to average days from each year, you could do this:

dailyAvg = groupsummary(dataTbl,["monthVar","dayVar"],"mean","sst")

If you actually convert your date into a datetime variable, you could also do this:

groupsummary(dataTbl,"date","dayofyear","mean","sst")

Here's the full code using the snippet of data you provided above.

data = [1	1	1982	13.4691935954243
2	1	1982	13.4287935963273
3	1	1982	13.4183935965598
4	1	1982	13.9135935854912
5	1	1982	13.9483935847134
6	1	1982	13.9511935846508
7	1	1982	13.9471935847402
8	1	1982	14.0023935835064
9	1	1982	13.9711935842037
10	1	1982	13.8475935869664];
dataTbl = table(data);
dataTbl = splitvars(dataTbl,"data","NewVariableNames",["day","month","year","sst"])
% option one - group by month then day.
dailyAvg1 = groupsummary(dataTbl,["month","day"],"mean","sst")
% option two - use the groupbin "dayofyear" on datetime variable "date"
dataTbl.date = datetime(fliplr(data(:,1:3)));
dailyAvg2 = groupsummary(dataTbl,"date","dayofyear","mean","sst")

MATLAB: How to divide a week of a timetable into hours

hourlytimetable = retime(yourtimetable, 'hourly', 'mean')

Best Answer

Related Solutions

MATLAB: Daily average of several years data

MATLAB: How to divide a week of a timetable into hours

Related Question