Clear Filters
Clear Filters

Extract month values (rows) out of year matrix

2 views (last 30 days)
Luke McLellan
Luke McLellan on 27 Jul 2018
Reopened: Walter Roberson on 22 Dec 2018
Hi there,
I have a matrix that contains 1 years worth of data (where the elements correspond to date x time) ranging from the 1st January to 31st December; each row represents 1 day of data. Is anyone aware of a method to average each column over each month? Any help would be appreciated.
Thanks
Luke

Answers (1)

jonas
jonas on 27 Jul 2018
https://se.mathworks.com/matlabcentral/answers/317655-calculate-avergae-values-per-hour-day-month-and-year
I suggest using Sean de Wolski's answer with datetime and retime
  1 Comment
Luke McLellan
Luke McLellan on 27 Jul 2018
Thanks. I have seen this before but could not get it working. I believe it is because I am dealing with data directly, meaning that each data point in the matrix is representative of a date and time. Whereas, the example is clearly split into Year Month ... format.

Sign in to comment.

Categories

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

Community Treasure Hunt

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

Start Hunting!