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

import pandas as pd
import numpy as np
data=pd.read_csv('sales.csv')
# 貌似我的做法是很笨拙的。。仅供参考
data['R_Quartile']=np.where(data['recency']<=data['recency'].quantile(0.25),4,
np.where(data['recency']<=data['recency'].quantile(0.5),3,
np.where(data['recency']<=data['recency'].quantile(0.75),2,1)))
data['F_Quartile']=np.where(data['frequency']<=data['frequency'].quantile(0.25),1,
np.where(data['frequency']<=data['frequency'].quantile(0.5),2,
np.where(data['frequency']<=data['frequency'].quantile(0.75),3,4)))
data['M_Quartile']=np.where(data['monetary']<=data['monetary'].quantile(0.25),1,
np.where(data['monetary']<=data['monetary'].quantile(0.5),2,
np.where(data['monetary']<=data['monetary'].quantile(0.75),3,4)))
print(data.head(5))