Timeline violations
You want to construct a model that predicts which donors are most likely to donate more than 50 Euro in April 2018. To build the predictive model, we reconstruct the timeline one year back in time, so the target period of the basetable is April 2017. Below are the donations of one donor in 2016 and 2017.
Donation ID | Donor ID | Donation date | Donation Amount |
---|---|---|---|
1 | 1 | 2016-04-01 | EUR 40 |
2 | 1 | 2016-09-21 | EUR 50 |
3 | 1 | 2016-12-14 | EUR 20 |
4 | 1 | 2017-01-31 | EUR 50 |
5 | 1 | 2017-04-22 | EUR 100 |
6 | 1 | 2017-05-16 | EUR 50 |
Which donations can be used to construct predictive variables in this basetable?
This exercise is part of the course
Intermediate Predictive Analytics in Python
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
