I have a data for a year where I need two plots for each month covering the 1st-15th and 16th-end of month, i.e. bi-monthly plots of this data.
The dataset isn't entirely complete and at some points there is no data for the 1st/15th/16th (as well as other days) of a month.
The data is currently in a timetable with time/date in datetime format 'dd/MM/yyyy HH:mm:ss'.
Is there a way of looping through the data to produce these bi-monthly plots?
My first instinct was to use Timerange, but cannot work out if there is a way to define 'half a month' using this function and plotting every 2 weeks or 15 days soon gets out of phase.
Below is a basic example of what the data looks like (I have added … just to imply data continues during that time period)
date data01/01/2018 00:00:00 344.9801/01/2018 00:30:00 304.1301/01/2018 01:00:00 355.74...13/01/2018 09:30:00 554.1318/01/2018 10:00:00 344.7719/01/2018 10:00:00 346.4727/01/2018 00:30:00 304.1302/02/2018 01:00:00 357.8302/02/2018 01:30:00 367.87...31/12/2018 22:30:00 634.6331/12/2018 23:00:00 400.5331/12/2018 23:30:00 621.43
Best Answer