基于动态日期权重计算物品频次的技术需求
我来帮你把这个需求和相关数据整理成清晰的Markdown格式,方便后续处理:
基于动态日期权重计算物品加权频次的需求整理
原始物品日期数据集
item,Date camera,10/12/2017 mobile,10/12/2017 mobile,15/12/2017 camera,15/12/2017 mobile,15/12/2017 mobile,15/12/2017 mobile,25/12/2017 mobile,25/12/2017 camera,25/12/2017 camera,25/12/2017 camera,05/01/2018 laptop,05/01/2018 laptop,05/01/2018 computer,05/01/2018
动态权重计算规则
- 最新日期的权重为1
- 每早于最新日期的前一个日期,权重为上一个日期权重的90%(即权重 = 前一日期权重 × 0.9)
- 针对本次数据集的日期权重分配示例:
| Date | Weight |
|---|---|
| 05/01/2018 | 1 |
| 25/12/2017 | 0.90 |
| 15/12/2017 | 0.81 |
| 10/12/2017 | 0.729 |
期望生成的加权后数据集
item,Date,Weight camera,10/12/2017,0.729 mobile,10/12/2017,0.729 mobile,15/12/2017,0.81 camera,15/12/2017,0.81 mobile,15/12/2017,0.81 mobile,15/12/2017,0.81 mobile,25/12/2017,0.90 mobile,25/12/2017,0.90 camera,25/12/2017,0.90 camera,25/12/2017,0.90 camera,05/01/2018,1.0 laptop,05/01/2018,1.0 laptop,05/01/2018,1.0 computer,05/01/2018,1.0
内容的提问来源于stack exchange,提问作者Monty
相关产品推荐
相关产品推荐

