题解 | #某店铺用户消费特征评分#
某店铺用户消费特征评分
https://www.nowcoder.com/practice/200c824e9ed4428491c27d65ec56067d
import pandas as pd
sales=pd.read_csv('sales.csv')
pd.set_option('display.max_columns',None)
pd.set_option('display.max_rows',None)
pd.set_option('display.width',None)
sales['R_Quartile']=pd.qcut(sales['recency'],4,labels=['4','3','2','1']).astype(int)
sales['F_Quartile']=pd.qcut(sales['frequency'],4,labels=['1','2','3','4']).astype(int)
sales['M_Quartile']=pd.qcut(sales['monetary'],4,labels=['1','2','3','4']).astype(int)
#要转成int否则无法通过
print(sales.head(5))
