题解 | #筛选某店铺最有价值用户中消费最多前5名#

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("str")
sales['F_Quartile']=pd.qcut(sales.frequency, [0, 0.25, 0.5, 0.75, 1], [1, 2, 3, 4]).astype("str")
sales['M_Quartile']=pd.qcut(sales.monetary, [0, 0.25, 0.5, 0.75, 1], [1, 2, 3, 4]).astype("str")

sales['RFMClass'] = sales['R_Quartile'] + sales['F_Quartile'] + sales['M_Quartile']

sales = sales[['user_id','recency','frequency','monetary','RFMClass']]
print(sales.head(5))

print('\n')

a = sales[sales['RFMClass'] == '444'].sort_values(by='monetary',ascending=False).head(5)
print(a)

这道题好像是前面几道题的PLUS组合版2333333，我这里直接直接黏贴的前面的代码，然后对照题解发现这次不能用Int 而要改为字符串类型。