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

import pandas as pd

df = pd.read_csv('sales.csv')

#第一步，将分箱的数（三列）先整出来，保存为r,f,m三个Series型数据

r = pd.qcut(df['recency'],[0,0.25,0.5,0.75,1],labels=['4','3','2','1'])

f = pd.qcut(df['frequency'],[0,0.25,0.5,0.75,1],labels=['1','2','3','4'])

m = pd.qcut(df['monetary'],[0,0.25,0.5,0.75,1],labels=['1','2','3','4'])

#第二步，将三者进行拼接运算，保存为新的列

df['RFMClass'] = r.str.cat(f).str.cat(m)

#第三步，打印

print(df.head())

print()

print(df[df['RFMClass' == '444']].head())