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.

Cet exercice fait partie du cours

Introduction to Predictive Analytics in Python

Afficher le cours

Instructions

Create a DataFrame basetable_income that only contains the variables target and income.
Group this DataFrame by income.
Calculate the average target incidence for each group in income.

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de 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)

Modifier et exécuter le code