How to a partition a data set of days into weekdays and weekends

Question

Torrey Beek on 13 May 2013

1
Link

Direct link to this question

https://au.mathworks.com/matlabcentral/answers/75628-how-to-a-partition-a-data-set-of-days-into-weekdays-and-weekends

Hi,

I'm excited to use this site; the previous posts have been immeasurably helpful for me in understanding how to use MATLAB.

I have a data set consisting of active and reactive power measurements for 365 days (1 April 2009 to 30 March 2010), beginning on a Wednesday. The exact dimension of the array is 365x48 (365 days of the year, 48 half-hours). I need to partition the data set into weekdays and weekends, and was wondering if someone could help me understand how this can be done using a MATLAB script?

Ideally I would like to sort the data set into a collection of weekdays in one array, and weekends in a separate array. Any ideas?

Thanks in advance, Torrey

0 Comments
Show -2 older commentsHide -2 older comments

Sign in to comment.

Sign in to answer this question.

Answer 1

Matt Kindig on 13 May 2013

0
Link

Direct link to this answer

https://au.mathworks.com/matlabcentral/answers/75628-how-to-a-partition-a-data-set-of-days-into-weekdays-and-weekends#answer_85277

Edited: Matt Kindig on 13 May 2013

Open in MATLAB Online

Hi Torrey,

I think this should do it:

%Matrix is your 365x48 matrix
%Every 4th and 5th rows are Saturday and Sunday
weekend_indices = sort([4:7:365, 5:7:365]);  
weekday_indices = setdiff(1:365, weekend_indices);
Weekdays = Matrix(weekday_indices,:);
Weekends = Matrix(weekend_indices,:);