Adding age

Given is an early stage basetable that contains the donor ID and birth date of candidate donors. In this exercise you will learn to add the age of these donors to the basetable. The method to calculate "age" is already implemented for your convenience. Keep in mind the following timeline of the basetable:

Cet exercice fait partie du cours

Intermediate Predictive Analytics in Python

Afficher le cours

Instructions

Fill out the reference date.
Add a column "age" to the basetable that is the age of the donor on the reference date. The function calculate_age has been implemented for you. It takes date_of_birth and reference_date as arguments.
Print the mean age of all donors.

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

# Reference date
reference_date = datetime.date(____, ____, ____)

# Add age to the basetable
basetable["age"] = (pd.Series([calculate_age(____, ____)
                              for date_of_birth in basetable["date_of_birth"]]))

# Calculate mean age
print(round(basetable["____"].____()))

Modifier et exécuter le code