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

import pandas as pd

df = pd.read_csv("sales.csv", sep=",")

pd.set_option("display.width", 300)  # 设置字符显示宽度
pd.set_option("display.max_rows", None)  # 设置显示最大行
pd.set_option("display.max_columns", None)


R = pd.qcut(df.recency, [0, 0.25, 0.5, 0.75, 1], ["4", "3", "2", "1"]).astype('str')
F = pd.qcut(df.recency, [0, 0.25, 0.5, 0.75, 1], ["1", "2", "3", "4"]).astype('str')
M = pd.qcut(df.recency, [0, 0.25, 0.5, 0.75, 1], ["1", "2", "3", "4"]).astype('str')

df['RFMClass']=R+F+M

print(df.head())
print(df.sort_values('RFMClass',ascending=False).head())