Calculating daily average curve from weekly data

3 次查看（过去 30 天）
Mat P
Mat P 2020-8-6
评论： Mat P 2020-8-8
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.
  7 个评论
显示 5更早的评论
jonas
jonas 2020-8-6
If you provide a small set of data then I could write some example code. Regardless of method, I would strongly suggest using a timetable as basis.
Mat P
Mat P 2020-8-8
Thank you, I already managed to solve this problem with your suggestion and that kind of indexing what i proposed. The answer by Antonio also works well. I process this data in multiple ways, so I find it easier to just use it as an array and cell array, and store the time data as a separate vector.

请先登录，再进行评论。

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

采纳的回答

Antonio Ciociola
Antonio Ciociola 2020-8-6
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);
  1 个评论
Mat P
Mat P 2020-8-8
This works very well also. I have no idea why 'reshape' didn't come to my mind from the very beginning.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by