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

import pandas as pd
sales = pd.read_csv('sales.csv')

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

注意一定要将文字改成整数类型int