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

from re import T
import pandas as pd

pd.set_option("display.width", 300)
pd.set_option("display.max_rows", None)
pd.set_option("display.max_columns", None)

会员消费情况 = pd.read_csv("sales.csv")
r= pd.qcut(会员消费情况.recency, q=4, labels=["4", "3", "2", "1"]).astype('str')
f= pd.qcut(会员消费情况.frequency, q=4, labels=["1", "2", "3", "4"]).astype('str')
m= pd.qcut(会员消费情况.monetary, q=4, labels=["1", "2", "3", "4"]).astype('str')
会员消费情况['RFMClass']=(r+f+m)
print(会员消费情况.head())
print()

会员消费情况.sort_values('monetary',ascending=False,inplace=True)

tj='RFMClass=="444"'
print(会员消费情况.query(tj).head(5).reset_index(drop=True))