Please I want to generatedate data for weekdays and weekend respectively. The date starts from 01/01/2016 and ends on 31/12/2016. The weekday contains only weekdays date and the weekend contains weekend dates. each dates for weekdays/weekend should have time format such that the time begins at 0.00 and end at 23.00 (i.e. 24 data point for the time associated to each date. Also, I would like to know how to calculate sum and average for each date across the different weekdays and weekends. Such that on 01/01/2016 which is a Friday and a weekday of 2016 would have the following format, and so on, thank you:
01/01 00:00 |
01/01 01:00 |
01/01 02:00 |
01/01 03:00 |
01/01 04:00 |
01/01 05:00 |
01/01 06:00 |
01/01 07:00 |
01/01 08:00 |
01/01 09:00 |
01/01 10:00 |
01/01 11:00 |
01/01 12:00 |
01/01 13:00 |
01/01 14:00 |
01/01 15:00 |
01/01 16:00 |
01/01 17:00 |
01/01 18:00 |
01/01 19:00 |
01/01 20:00 |
01/01 21:00 |
01/01 22:00 |
01/01 23:00 |