题解 | #筛选某店铺最有价值用户中消费最多前5名#
筛选某店铺最有价值用户中消费最多前5名
https://www.nowcoder.com/practice/58655010a7c34e9fb2b7b491c3f79ca4
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 而要改为字符串类型。