Primary competition visual

Sendy Logistics Challenge

Helping Kenya
$7 000 USD
Completed (over 6 years ago)
Prediction
2180 joined
448 active
Starti
Aug 23, 19
Closei
Nov 25, 19
Reveali
Nov 26, 19
months of the year
Notebooks ยท 12 Nov 2019, 19:20 ยท 2

I am trying to get the month of the operation.

Month= ('Placement - Day of Month' - 'Placement - Weekday (Mo = 1)') % 7

So I can distinguish 7 months.

More explanation: for year=2019

if the first day of the month is Tuesday --> its January

second day of the month is Wednesday --> January

There is a problem with February and March because both of them start with a Friday.

Who can help me dealing with this problem.

Discussion 2 answers

Sendy has been using bikes since September 2014. There's no indication that the orders are from 2019. I'm guessing the data was deliberately anonymized to keep us from being able to determine the exact month and year.

12 Nov 2019, 20:28
Upvotes 0

I believe so too because that reason makes sense. But to build on Belazizs' point, one can intelligently guess the months then obtain an average of those months.