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

from re import A
import pandas as pd

df = pd.read_csv('sales.csv')
r = pd.qcut(df.recency,q=4,labels=[4,3,2,1])
f = pd.qcut(df.frequency,q=4,labels=[1,2,3,4])
m = pd.qcut(df.monetary,q=4,labels=[1,2,3,4])
j = pd.concat([r,f,m],axis=1)
df['RFMClass'] = j['recency'].astype(str)+j['frequency'].astype(str)+j['monetary'].astype(str)
print(df.head())
df = df[df.RFMClass=='444'].sort_values('monetary',ascending=False).reset_index()
print(df.head())