how to take monthly mean of hourly data set ?

2 views (last 30 days)
pruth
pruth on 10 Feb 2022
Commented: Star Strider on 10 Feb 2022
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.

Answers (1)

Star Strider
Star Strider on 10 Feb 2022
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.
  2 Comments
pruth
pruth on 10 Feb 2022
can you tell me how to use the retime here ?
Star Strider
Star Strider on 10 Feb 2022
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).

Sign in to comment.

Categories

Find more on Data Type Conversion in Help Center and File Exchange

Products


Release

R2019b

Community Treasure Hunt

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

Start Hunting!