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

某店铺用户消费特征评分

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]))

全部评论

相关推荐

点赞 收藏 评论
分享
牛客网
牛客企业服务