2023/7/17 day6

 

 

 

使用python从sqlserver数据库提取数据,并按ITEM和PROJECT分组,分别获取最近三个月的月度数据(monthRate)、最近四周的周度数据(weekRate)和最近七天的每日数据(dailyRate),然后将结果生成HTML格式的列表文件。数据表样式如下ITEM PROJECT dailyRate weekRate monthRate IF_DATE yearWeek yearMonth DA COLLET_OFFSET 97.80% 99.10% 96.90% 2025/7/8 202528 202507 DA COLLET_OFFSET 98.80% 99.10% 96.90% 2025/7/9 202528 202507 DA COLLET_OFFSET 99.70% 99.10% 96.90% 2025/7/10 202528 202507 DA COLLET_OFFSET 99.50% 99.10% 96.90% 2025/7/11 202528 202507 DA COLLET_OFFSET 99.50% 99.10% 96.90% 2025/7/12 202528 202507 DA COLLET_OFFSET 99.20% 99.10% 96.90% 2025/7/13 202528 202507 DA COLLET_OFFSET 99.20% 93.90% 96.90% 2025/7/14 202529 202507 DA COLLET_OFFSET 98.90% 93.90% 96.90% 2025/7/15 202529 202507 DA COLLET_OFFSET 98.80% 93.90% 96.90% 2025/7/16 202529 202507 DA COLLET_OFFSET 72.60% 93.90% 96.90% 2025/7/17 202529 202507 DA COLLET_OFFSET 99.20% 93.90% 96.90% 2025/7/18 202529 202507 DA INK_MIX 99.60% 99.40% 97.10% 2025/7/8 202528 202507 DA INK_MIX 99.40% 99.40% 97.10% 2025/7/9 202528 202507 DA INK_MIX 99.60% 99.40% 97.10% 2025/7/10 202528 202507 DA INK_MIX 99.30% 99.40% 97.10% 2025/7/11 202528 202507 DA INK_MIX 99.40% 99.40% 97.10% 2025/7/12 202528 202507 DA INK_MIX 99.40% 99.40% 97.10% 2025/7/13 202528 202507 DA INK_MIX 99.60% 94.20% 97.10% 2025/7/14 202529 202507 DA INK_MIX 99.40% 94.20% 97.10% 2025/7/15 202529 202507 DA INK_MIX 98.90% 94.20% 97.10% 2025/7/16 202529 202507 DA INK_MIX 73.90% 94.20% 97.10% 2025/7/17 202529 202507 DA INK_MIX 99.40% 94.20% 97.10% 2025/7/18 202529 202507 EXPANDING ERROR_180s 100.00% 100.00% 97.70% 2025/6/21 202525 202506 EXPANDING ERROR_180s 100.00% 100.00% 97.70% 2025/6/22 202525 202506 EXPANDING ERROR_180s 97.00% 99.00% 97.70% 2025/6/23 202526 202506 EXPANDING ERROR_180s 100.00% 99.00% 97.70% 2025/6/24 202526 202506 EXPANDING ERROR_180s 100.00% 99.00% 97.70% 2025/6/25 202526 202506 EXPANDING ERROR_180s 100.00% 99.00% 97.70% 2025/6/26 202526 202506 EXPANDING ERROR_180s 100.00% 99.00% 97.70% 2025/6/27 202526 202506 EXPANDING ERROR_180s 98.10% 99.00% 97.70% 2025/6/28 202526 202506 EXPANDING ERROR_180s 100.00% 99.00% 97.70% 2025/6/29 202526 202506 EXPANDING ERROR_180s 81.80% 97.30% 97.70% 2025/6/30 202527 202506 EXPANDING ERROR_180s 100.00% 97.30% 99.50% 2025/7/1 202527 202507 EXPANDING ERROR_180s 100.00% 97.30% 99.50% 2025/7/2 202527 202507 EXPANDING ERROR_180s 95.20% 97.30% 99.50% 2025/7/3 202527 202507 EXPANDING ERROR_180s 100.00% 97.30% 99.50% 2025/7/4 202527 202507 EXPANDING ERROR_180s 100.00% 97.30% 99.50% 2025/7/5 202527 202507 EXPANDING ERROR_180s 100.00% 97.30% 99.50% 2025/7/6 202527 202507 EXPANDING ERROR_180s 100.00% 99.50% 99.50% 2025/7/7 202528 202507 EXPANDING ERROR_180s 97.70% 99.50% 99.50% 2025/7/8 202528 202507 EXPANDING ERROR_180s 100.00% 99.50% 99.50% 2025/7/9 202528 202507 EXPANDING ERROR_180s 98.90% 99.50% 99.50% 2025/7/10 202528 202507 EXPANDING ERROR_180s 100.00% 99.50% 99.50% 2025/7/11 202528 202507 EXPANDING ERROR_180s 100.00% 99.50% 99.50% 2025/7/12 202528 202507 EXPANDING ERROR_180s 100.00% 99.50% 99.50% 2025/7/13 202528 202507 EXPANDING ERROR_180s 100.00% 100.00% 99.50% 2025/7/14 202529 202507 EXPANDING ERROR_180s 100.00% 100.00% 99.50% 2025/7/15 202529 202507 EXPANDING ERROR_180s 100.00% 100.00% 99.50% 2025/7/16 202529 202507 EXPANDING ERROR_180s 100.00% 100.00% 99.50% 2025/7/17 202529 202507 EXPANDING ERROR_180s 100.00% 100.00% 99.50% 2025/7/18 202529 202507 MOUNT FORCE 100.00% 100.00% 99.90% 2025/7/13 202528 202507 MOUNT FORCE 99.90% 99.90% 99.90% 2025/7/14 202529 202507 MOUNT FORCE 99.90% 99.90% 99.90% 2025/7/17 202529 202507 MOUNT FORCE 99.90% 99.90% 99.90% 2025/7/18 202529 202507 MOUNT INK_MIX_0MARK 34.80% 33.90% 33.90% 2025/7/14 202529 202507 MOUNT INK_MIX_0MARK 26.80% 33.90% 33.90% 2025/7/17 202529 202507 MOUNT INK_MIX_0MARK 40.40% 33.90% 33.90% 2025/7/18 202529 202507 MOUNT N2 29.60% 48.70% 48.70% 2025/7/15 202529 202507 MOUNT N2 58.40% 48.70% 48.70% 2025/7/17 202529 202507 MOUNT N2 59.50% 48.70% 48.70% 2025/7/18 202529 202507 MOUNT NCH_CODE 100.00% 100.00% 100.00% 2025/7/4 202527 202507 MOUNT NCH_CODE 100.00% 100.00% 100.00% 2025/7/5 202527 202507 MOUNT NCH_CODE 100.00% 100.00% 100.00% 2025/7/8 202528 202507 MOUNT NCH_CODE 100.00% 100.00% 100.00% 2025/7/9 202528 202507 MOUNT NCH_CODE 100.00% 100.00% 100.00% 2025/7/10 202528 202507 MOUNT NCH_CODE 100.00% 100.00% 100.00% 2025/7/11 202528 202507 MOUNT NCH_CODE 100.00% 100.00% 100.00% 2025/7/12 202528 202507 MOUNT NCH_CODE 100.00% 100.00% 100.00% 2025/7/13 202528 202507 MOUNT NCH_CODE 100.00% 100.00% 100.00% 2025/7/14 202529 202507 MOUNT NCH_CODE 100.00% 100.00% 100.00% 2025/7/15 202529 202507 MOUNT NCH_CODE 100.00% 100.00% 100.00% 2025/7/16 202529 202507 MOUNT NCH_CODE 100.00% 100.00% 100.00% 2025/7/17 202529 202507 MOUNT NCH_CODE 100.00% 100.00% 100.00% 2025/7/18 202529 202507 MOUNT PBI 54.20% 54.00% 54.00% 2025/7/15 202529 202507 MOUNT PBI 51.30% 54.00% 54.00% 2025/7/17 202529 202507 MOUNT PBI 56.90% 54.00% 54.00% 2025/7/18 202529 202507 MOUNT RPM_FANSPEED 92.70% 92.70% 92.40% 2025/7/13 202528 202507 MOUNT RPM_FANSPEED 95.00% 92.30% 92.40% 2025/7/14 202529 202507
07-20
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值