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.
Este ejercicio forma parte del curso
Introduction to Predictive Analytics in Python
Instrucciones del ejercicio
- 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
.
Ejercicio interactivo práctico
Prueba este ejercicio completando el código de muestra.
# 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)