Calculating daily average curve from weekly data

3 Ansichten (letzte 30 Tage)
Mat P
Mat P am 6 Aug. 2020
Kommentiert: Mat P am 8 Aug. 2020
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 Kommentare
jonas
jonas am 6 Aug. 2020
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 am 8 Aug. 2020
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.

Melden Sie sich an, um zu kommentieren.

Akzeptierte Antwort

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

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Community Treasure Hunt

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

Start Hunting!

Translated by