题解 | #某店铺用户消费特征评分#

import pandas as pd 

#1-导入数据
data = pd.read_csv('sales.csv')
#2-cut切分
data['R_Quartile'] = pd.qcut(data['recency'], [0, 0.25, 0.5, 0.75, 1], ['4', '3', '2', '1']).astype('int')
data['F_Quartile'] = pd.qcut(data['frequency'], [0, 0.25, 0.5, 0.75, 1], ['1', '2', '3', '4']).astype('int')
data['M_Quartile'] = pd.qcut(data['monetary'], [0, 0.25, 0.5, 0.75, 1], ['1', '2', '3', '4']).astype('int')
print(data.head(n = 5))