题解 | #某店铺用户消费特征评分#
某店铺用户消费特征评分
https://www.nowcoder.com/practice/200c824e9ed4428491c27d65ec56067d
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))
