题解 | #筛选某店铺最有价值用户中消费最多前5名#
筛选某店铺最有价值用户中消费最多前5名
https://www.nowcoder.com/practice/58655010a7c34e9fb2b7b491c3f79ca4
import pandas as pd
sales = pd.read_csv('sales.csv')
sales['RFMClass'] = pd.qcut(sales['recency'], [0, 0.25, 0.5, 0.75,1], labels = [4,3, 2,1]).astype(str) +\
pd.qcut(sales['frequency'], [0, 0.25, 0.5, 0.75,1], labels = [1,2,3,4]).astype(str)+\
pd.qcut(sales['monetary'], [0, 0.25, 0.5, 0.75,1], labels = [1,2,3,4]).astype(str)
print(sales.head(), '\n')
print(sales.sort_values(by='RFMClass', ascending = False).reset_index(drop=True).head())
投递作业帮等公司7个岗位 >
