题解 | #筛选某店铺最有价值用户中消费最多前5名#
筛选某店铺最有价值用户中消费最多前5名
https://www.nowcoder.com/practice/58655010a7c34e9fb2b7b491c3f79ca4
import pandas as pd
df=pd.read_csv('sales.csv')
df['r']=pd.qcut(df['recency'],4,labels=['4','3','2','1']).astype('str')
df['f']=pd.qcut(df['frequency'],4,labels=['1','2','3','4']).astype('str')
df['m']=pd.qcut(df['monetary'],4,labels=['1','2','3','4']).astype('str')
df['RFMClass']=df['r']+df['f']+df['m']
print(df[['user_id','recency','frequency','monetary','RFMClass']][:5:])
查看30道真题和解析