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

import pandas as pd 
sales = pd.read_csv('sales.csv')
x = pd.qcut(sales['recency'],[0,0.25,0.5,0.75,1],[4,3,2,1]).astype(str)
y = pd.qcut(sales['frequency'],[0,0.25,0.5,0.75,1],[1,2,3,4]).astype(str)
z = pd.qcut(sales['monetary'],[0,0.25,0.5,0.75,1],[1,2,3,4]).astype(str)
sales['RFMClass'] = x+y+z
print(sales.head())
sales.sort_values(['monetary','RFMClass'],ascending=True)
print(sales.head())