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.

Deze oefening maakt deel uit van de cursus

Introduction to Predictive Analytics in Python

Cursus bekijken

Oefeninstructies

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.

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

# 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)

Code bewerken en uitvoeren