Calculating average incidences
The most important column in the predictor insight graph table is the target incidence column. This column shows the average target value for each group.
This exercise is part of the course
Introduction to Predictive Analytics in Python
Exercise instructions
- Create a DataFrame
basetable_income
that only contains the variablestarget
andincome
. - Group this DataFrame by
income
. - Calculate the average target incidence for each group in
income
.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Select the income and target columns
basetable_income = basetable[["____","____"]]
# Group basetable_income by income
groups = basetable_income.____("____")
# Calculate the target incidence and print the result
incidence = groups["____"].agg(Incidence = '____').reset_index()
print(incidence)