Getting weekend (Saturday+Sunday) profiles from a yearly load profile 8760 data points

I have a year (2014) dataset of i.e 8760 (column 8760by1) data points, and I want to get from this dataset:

1. Weekdays data for each Month and each hour (1:24). 2.Peak values for each Month (Jan:Dec) and each hour(1:24). 3.Weekend(Saturday+Sunday) data for each Month (Jan:Dec) and each hour(1:24).

It would be great to have a code to manipulate this in MATLAB. Any suggestions?

Answer 1

[Ingrid]

You should use a combination of histc and accumarray together on

1) weekday and datevec

2) datevec and max and

3) weekday and datevec