Calculating aggregated variables with timegap
Assume you want to construct a predictive model to predict which donors will make a donation of at least 10 Euro during the next month. The timeline is given below, there is a timegap of one month. In this exercise, you will learn how to add a variable "mean_donation_last_month" to the basetable.
This exercise is part of the course
Intermediate Predictive Analytics in Python
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Start and end date of last month
start_date = datetime.date(____, ____, ____)
end_date = datetime.date(____, ____, ____)