Replace missing values with the median value
Given is a basetable that has a predictive variable age of the donors that has missing values in it. It is a good idea to replace these missing values by the median age of the donors.
This exercise is part of the course
Intermediate Predictive Analytics in Python
Exercise instructions
- Calculate the median age of all donors and assign this value to
median_age. - Replace missing values in
agebymedian_age. - Calculate the median age of all donors after the replacement is done.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Calculate the median of age
median_age = ____["____"].____()
print(median_age)
# Replace missing values by the median
basetable["age"] = ____["____"].____(____)
# Calculate the median of age after replacement
median_age = ____["____"].____()
print(median_age)