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

import pandas as pd
df=pd.read_csv('sales.csv')
R=pd.qcut(df['recency'],[0,0.25,0.5,0.75,1],['4','3','2','1']).astype(str)
F=pd.qcut(df['frequency'],[0,0.25,0.5,0.75,1],['1','2','3','4']).astype(str)
M=pd.qcut(df['monetary'],[0,0.25,0.5,0.75,1],['1','2','3','4']).astype(str)
df['RFMClass']=R+F+M
print(df.head(5))
print('\n')
print(df[df['RFMClass']=="444"].sort_values(by="monetary",ascending=False).reset_index(drop=True).head(5))