题解 | #某店铺用户消费特征评分#
某店铺用户消费特征评分
https://www.nowcoder.com/practice/200c824e9ed4428491c27d65ec56067d
import sys
import pandas as pd 
import numpy as np
df = pd.read_csv('sales.csv')
df['R_Quartile'] = df['recency'].apply(lambda x: 4 if x <= df['recency'].quantile(0.25) else (3 if x > df['recency'].quantile(0.25) and x <= df['recency'].quantile(0.5) else (2 if x > df['recency'].quantile(0.5) and x <= df['recency'].quantile(0.75) else 1)))
df['F_Quartile'] = df['frequency'].apply(lambda x: 4 if x >  df['frequency'].quantile(0.75) else (3 if x >=  df['frequency'].quantile(0.5) and x <  df['frequency'].quantile(0.75) else (2 if x >=  df['frequency'].quantile(0.25) and x <  df['frequency'].quantile(0.5) else 1)))
df['M_Quartile'] = df['monetary'].apply(lambda x: 4 if x > df['monetary'].quantile(0.75) else (3 if x >= df['monetary'].quantile(0.5) and x < df['monetary'].quantile(0.75) else (2 if x >= df['monetary'].quantile(0.25) and x < df['monetary'].quantile(0.5) else 1)))
print(df.head(5))
for line in sys.stdin:
    a = line.split()
    print(int(a[0]) + int(a[1]))


