Replace missing values with a fixed value
Given a basetable
that has a predictive variable "total_donations", indicate the total amount of donations made by each donor in the population. If a value is missing for this predictive variable, it means that this is a new donor that did not make any donations yet. In this case, logical reasoning can be used to know by which value we should replace missing values.
This exercise is part of the course
Intermediate Predictive Analytics in Python
Exercise instructions
- Assign the replacement value for missing values to
replacement
. - Replace missing values in the column
total_donations
by this replacement.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Missing values replacement
replacement = ____
# Replace missing values by the appropriate value
basetable["total_donations"] = ____["____"].____(____)