题解 | #筛选某店铺最有价值用户中消费最多前5名#
筛选某店铺最有价值用户中消费最多前5名
https://www.nowcoder.com/practice/58655010a7c34e9fb2b7b491c3f79ca4
Python
import pandas as pd
sales = pd.read_csv('sales.csv')
R = pd.qcut(sales['recency'],[0, 0.25, 0.5, 0.75, 1.0],['4', '3', '2', '1']).astype('str')
F = pd.qcut(sales['frequency'],[0, 0.25, 0.5, 0.75, 1.0],['4', '3', '2', '1']).astype('str')
M = pd.qcut(sales['monetary'],[0, 0.25, 0.5, 0.75, 1.0],['4', '3', '2', '1']).astype('str')
sales['RFMClass'] = R+F+M
print(sales.head())
print()
print(data[sales['RFMClass'] == '444'].sort_values(by='monetary', ascending=False).reset_index(drop=True).head())
排序后需要使用
reset_index(drop=True)
