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

import pandas as pd
sales = pd.read_csv('sales.csv')
quant = sales[['recency','frequency','monetary']].quantile([0.25,0.5,0.75])

def apply_score(x, col):
    if x <= quant[col][0.25]:
        score = 4
    elif x <= quant[col][0.5]:
        score = 3
    elif x <= quant[col][0.75]:
        score = 2
    else:
        score = 1
    return score

sales['R_Quartile'] = sales['recency'].map(lambda x: apply_score(x, 'recency'))
sales['F_Quartile'] = sales['frequency'].map(lambda x: apply_score(x, 'frequency'))
sales['M_Quartile'] = sales['monetary'].map(lambda x: apply_score(x, 'monetary'))

pd.set_option('display.max_columns',None)
pd.set_option('display.max_rows',None)
pd.set_option('display.width',300)
print(sales.head(5))