how to take monthly mean of hourly data set ?

hi,

I am having a problem with timetable.

I have an hourly data for 1 year.

I want take an average of each month and make hourly timeseries of the data.

what i mean to say; I will have 12 time series with hours. each month will have 24 hours time series.

Answer 1

[Star Strider]

The groupsummary function could be helpful here. See Grouped Calculations in Tables and Timetables for a detailed discussion. The retime function could also be an option.

[pruth]

can you tell me how to use the retime here ?

[Star Strider]

The documentation gives clear examples. I recently did something similar in Averaging hourly time series data to daily time series so you can use that as a guide.

I would have to have a representative sample of your data to see if groupsummary would be appropriate for it, so I did not even attempt to sketch the approach here. I cannot be certain that approach would work without having your data to experiment with (and even then it might not be possible).