题解 | #某店铺用户消费特征评分#

# 测试数据
sales = pd.DataFrame({'user_id':['NC0008','NC0018','NC0021','NC0035','NC0036'],'recency':[186,19,151,8,262],'frequency':[5,13,3,4,2],'monetary':[2990,3648,629,4542,896]})

sales['R_Quartile'] = pd.qcut(sales['recency'], [0, 0.25, 0.5, 0.75, 1],["4", "3", "2", "1"]).astype("int")
sales['F_Quartile'] = pd.qcut(sales['frequency'], [0, 0.25, 0.5, 0.75, 1],["1", "2", "3", "4"]).astype("int")
sales['M_Quartile'] = pd.qcut(sales['monetary'], [0, 0.25, 0.5, 0.75, 1],["1", "2", "3", "4"]).astype("int")
print(sales.head())