Making clean cuts
The qcut method divides the variable in n_bins equal bins. In some cases, however, it is nice to choose your own bins. The method cut in python allows you to choose your own bins.
Este exercício faz parte do curso
Introduction to Predictive Analytics in Python
Instruções do exercício
- Discretize the variable
number_giftin three bins with borders 0 and 5, 5 and 10, 10 and 20 and assign this variable to a new column calleddisc_number_gift. - Count the number of observations in each group.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
# Discretize the variable
basetable["disc_number_gift"] = pd.cut(____[____],[____, ____, ____, ____])
# Count the number of observations per group
print(basetable.groupby("____").____())