删除病毒生成的ws2_32.dll文件夹

本文介绍了一种使用批处理脚本批量删除特定文件夹内的ws2_32.dll文件的方法。用户只需将该批处理文件制作好,并通过拖拽目标文件夹到批处理文件图标上来实现快速删除。此方法简化了文件管理流程。

把如下内容制作成一个bat文件,然后把ws2_32.dll文件夹直接拖动到该bat文件图标上即可删除:

DEL /F /A /Q //?/%1
RD /S /Q //?/%1 

Description: Microsoft Teams Company: Microsoft Corporation Name: taskhostw.exe Version: 1.6.00.33567 Path: C:\Users\Administrator\AppData\Local\Programs\Common\OneDriveCloud\taskhostw.exe Command Line: "C:\Users\Administrator\AppData\Local\Programs\Common\OneDriveCloud\taskhostw.exe" PID: 187920 Parent PID: 2552 Session ID: 1 User: PC-20210210SJXF\Administrator Auth ID: 00000000:00089af0 Architecture: 64-bit Virtualized: False Integrity: High Started: 2025/5/28 23:30:01 Ended: 2025/5/28 23:30:16 Modules: RTSSHooks64.dll 0x180000000 0x3586000 C:\Program Files (x86)\RivaTuner Statistics Server\RTSSHooks64.dll 2024/3/23 17:01:22 taskhostw.exe 0x7ff6b0e90000 0x9238000 C:\Users\Administrator\AppData\Local\Programs\Common\OneDriveCloud\taskhostw.exe Microsoft Corporation 1.6.00.33567 2023/2/24 5:20:01 ffmpeg.dll 0x7ffa04260000 0x40d000 C:\Users\Administrator\AppData\Local\Programs\Common\OneDriveCloud\ffmpeg.dll 2023/2/24 5:20:01 f7a9727b-eca1-4b32-aaa8-ba029918b12c.tmp.node 0x7ffa08670000 0xc0000 C:\Users\Administrator\AppData\Local\Temp\f7a9727b-eca1-4b32-aaa8-ba029918b12c.tmp.node 2024/12/28 0:19:04 1267b9d7-d36b-4b41-87c1-64b93b56cbaa.tmp.node 0x7ffa7cfa0000 0xc1000 C:\Users\Administrator\AppData\Local\Temp\1267b9d7-d36b-4b41-87c1-64b93b56cbaa.tmp.node 2024/12/28 0:18:59 UIAutomationCore.dll 0x7ffa821c0000 0x44c000 C:\Windows\System32\UIAutomationCore.dll Microsoft Corporation 7.2.22621.4830 (WinBuild.160101.0800) 1928/1/11 10:05:16 dbgcore.dll 0x7ffa8c040000 0x32000 C:\Windows\System32\dbgcore.dll Microsoft Corporation 10.0.22621.1 (WinBuild.160101.0800) 1980/3/10 11:12:15 KBDUS.DLL 0x7ffa952d0000 0x9000 C:\Windows\System32\KBDUS.DLL Microsoft Corporation 10.0.22621.1 (WinBuild.160101.0800) 1939/12/16 5:05:36 winspool.drv 0x7ffa9dd30000 0xa8000 C:\Windows\System32\winspool.drv Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 1946/2/12 5:38:57 winmm.dll 0x7ffaaa0a0000 0x34000 C:\Windows\System32\winmm.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 1971/7/22 1:41:07 version.dll 0x7ffaad6f0000 0xa000 C:\Windows\System32\version.dll Microsoft Corporation 10.0.22621.1 (WinBuild.160101.0800) 1910/10/17 17:59:38 dhcpcsvc.dll 0x7ffaadbd0000 0x1f000 C:\Windows\System32\dhcpcsvc.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 1980/12/8 6:03:37 winhttp.dll 0x7ffaadeb0000 0x12c000 C:\Windows\System32\winhttp.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 1969/3/12 18:07:56 msimg32.dll 0x7ffab09e0000 0x7000 C:\Windows\System32\msimg32.dll Microsoft Corporation 10.0.22621.2506 (WinBuild.160101.0800) 1942/3/6 12:00:42 uxtheme.dll 0x7ffab0c20000 0xb3000 C:\Windows\System32\uxtheme.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 1997/12/31 0:25:30 DWrite.dll 0x7ffab1940000 0x273000 C:\Windows\System32\DWrite.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 2034/8/25 2:47:37 dbghelp.dll 0x7ffab1e50000 0x232000 C:\Windows\System32\dbghelp.dll Microsoft Corporation 10.0.22621.3593 (WinBuild.160101.0800) 1971/2/1 3:29:34 IPHLPAPI.DLL 0x7ffab2fb0000 0x2d000 C:\Windows\System32\IPHLPAPI.DLL Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 2028/8/29 0:38:42 secur32.dll 0x7ffab3630000 0xc000 C:\Windows\System32\secur32.dll Microsoft Corporation 10.0.22621.1 (WinBuild.160101.0800) 2013/11/12 20:11:49 kernel.appcore.dll 0x7ffab3640000 0x18000 C:\Windows\System32\kernel.appcore.dll Microsoft Corporation 10.0.22621.3958 (WinBuild.160101.0800) 1915/7/15 22:57:37 ntmarta.dll 0x7ffab3660000 0x34000 C:\Windows\System32\ntmarta.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 1962/10/8 7:49:13 sspicli.dll 0x7ffab37b0000 0x43000 C:\Windows\System32\sspicli.dll Microsoft Corporation 10.0.22621.5192 (WinBuild.160101.0800) 1915/7/20 15:07:09 mswsock.dll 0x7ffab39d0000 0x6a000 C:\Windows\System32\mswsock.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 1933/6/2 22:23:26 userenv.dll 0x7ffab3ac0000 0x28000 C:\Windows\System32\userenv.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 1992/1/6 6:41:11 cryptbase.dll 0x7ffab3c20000 0xc000 C:\Windows\System32\cryptbase.dll Microsoft Corporation 10.0.22621.4746 (WinBuild.160101.0800) 1941/9/17 1:11:37 msasn1.dll 0x7ffab4170000 0x12000 C:\Windows\System32\msasn1.dll Microsoft Corporation 10.0.22621.2506 (WinBuild.160101.0800) 1972/1/12 8:50:25 umpdc.dll 0x7ffab43c0000 0x13000 C:\Windows\System32\umpdc.dll Microsoft Corporation 10.0.22621.5124 (WinBuild.160101.0800) 1957/4/20 16:37:10 powrprof.dll 0x7ffab43e0000 0x4d000 C:\Windows\System32\powrprof.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 1908/2/24 14:32:41 bcryptprimitives.dll 0x7ffab45d0000 0x7b000 C:\Windows\System32\bcryptprimitives.dll Microsoft Corporation 10.0.22621.4317 (WinBuild.160101.0800) 1988/12/12 0:53:20 WinTypes.dll 0x7ffab4650000 0x13f000 C:\Windows\System32\WinTypes.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 1912/2/5 18:58:23 bcrypt.dll 0x7ffab4790000 0x28000 C:\Windows\System32\bcrypt.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 1995/9/13 23:26:06 wintrust.dll 0x7ffab47c0000 0x7c000 C:\Windows\System32\wintrust.dll Microsoft Corporation 10.0.22621.5262 (WinBuild.160101.0800) 1902/9/5 6:41:55 KernelBase.dll 0x7ffab4840000 0x3d3000 C:\Windows\System32\KernelBase.dll Microsoft Corporation 10.0.22621.5124 (WinBuild.160101.0800) 1954/8/21 4:10:17 gdi32full.dll 0x7ffab4c20000 0x122000 C:\Windows\System32\gdi32full.dll Microsoft Corporation 10.0.22621.5262 (WinBuild.160101.0800) 2006/9/27 20:58:55 msvcp_win.dll 0x7ffab4d50000 0x9a000 C:\Windows\System32\msvcp_win.dll Microsoft Corporation 10.0.22621.3374 (WinBuild.160101.0800) 1909/5/30 19:36:41 ucrtbase.dll 0x7ffab4df0000 0x111000 C:\Windows\System32\ucrtbase.dll Microsoft Corporation 10.0.22621.3593 (WinBuild.160101.0800) 1978/12/1 5:19:45 crypt32.dll 0x7ffab4f10000 0x167000 C:\Windows\System32\crypt32.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 1919/1/4 2:15:08 win32u.dll 0x7ffab5080000 0x26000 C:\Windows\System32\win32u.dll Microsoft Corporation 10.0.22621.5262 (WinBuild.160101.0800) 1932/6/20 18:22:01 shell32.dll 0x7ffab50b0000 0x89d000 C:\Windows\System32\shell32.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 1916/10/17 16:07:58 ws2_32.dll 0x7ffab5950000 0x71000 C:\Windows\System32\ws2_32.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 1922/2/4 14:06:50 imm32.dll 0x7ffab59d0000 0x31000 C:\Windows\System32\imm32.dll Microsoft Corporation 10.0.22621.5185 (WinBuild.160101.0800) 1966/12/30 1:01:58 sechost.dll 0x7ffab5aa0000 0xa7000 C:\Windows\System32\sechost.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 1991/4/6 9:23:37 oleaut32.dll 0x7ffab5cc0000 0xd7000 C:\Windows\System32\oleaut32.dll Microsoft Corporation 10.0.22621.5262 (WinBuild.160101.0800) 1958/8/17 3:19:10 combase.dll 0x7ffab5e30000 0x393000 C:\Windows\System32\combase.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 2037/1/11 20:39:59 advapi32.dll 0x7ffab61f0000 0xb1000 C:\Windows\System32\advapi32.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 2007/5/26 20:03:33 gdi32.dll 0x7ffab62c0000 0x29000 C:\Windows\System32\gdi32.dll Microsoft Corporation 10.0.22621.5185 (WinBuild.160101.0800) 1903/3/31 14:41:18 rpcrt4.dll 0x7ffab6400000 0x114000 C:\Windows\System32\rpcrt4.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 1944/9/5 16:00:55 msctf.dll 0x7ffab6540000 0x15e000 C:\Windows\System32\msctf.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 2014/11/28 2:44:46 SHCore.dll 0x7ffab66a0000 0x10b000 C:\Windows\System32\SHCore.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 2007/7/9 17:06:10 user32.dll 0x7ffab67b0000 0x1b1000 C:\Windows\System32\user32.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 1977/11/12 22:02:46 setupapi.dll 0x7ffab6970000 0x474000 C:\Windows\System32\setupapi.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 1920/4/20 3:36:11 msvcrt.dll 0x7ffab6e70000 0xa7000 C:\Windows\System32\msvcrt.dll Microsoft Corporation 7.0.22621.2506 (WinBuild.160101.0800) 2023/12/15 0:02:17 shlwapi.dll 0x7ffab6f20000 0x66000 C:\Windows\System32\shlwapi.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 1995/10/27 14:00:38 kernel32.dll 0x7ffab6f90000 0xc4000 C:\Windows\System32\kernel32.dll Microsoft Corporation 10.0.22621.5124 (WinBuild.160101.0800) 2025/1/5 9:09:07 ole32.dll 0x7ffab7060000 0x1a1000 C:\Windows\System32\ole32.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 1978/3/6 12:36:50 ntdll.dll 0x7ffab7410000 0x217000 C:\Windows\System32\ntdll.dll Microsoft Corporation 10.0.22621.4830 (WinBuild.160101.0800) 2001/6/9 4:28:23
05-29
import pandas as pd import numpy as np import os # 设置路径 folder_path = r'D:\Class\能管比对\导出文件' # 修改为你存放 .xlsx 的文件夹 output_file = r'D:\Class\能管比对\每日结果\汇总结果_变异系数大于0.2.xlsx' # 存储符合条件的列信息 results = [] # 循环处理每个 .xlsx 文件 for file_name in os.listdir(folder_path): if not file_name.endswith('.xlsx') or file_name.startswith('~$'): continue # 跳过非Excel文件和临时文件 file_path = os.path.join(folder_path, file_name) try: excel_file = pd.ExcelFile(file_path) except Exception as e: print(f"无法读取文件: {file_name}, 错误: {e}") continue print(f"\n正在处理文件: {file_name}") for sheet_name in excel_file.sheet_names: df = pd.read_excel(excel_file, sheet_name=sheet_name) if df.empty or len(df) < 25: continue # 数据不足25行跳过 # 取前25行用于分析 data_block = df.iloc[:25].copy() for col_idx in range(1, len(data_block.columns)): # 跳过第0列(时间列) col_name = df.columns[col_idx] series = data_block.iloc[:, col_idx] # 转换为数值型,剔除无效值 numeric_data = pd.to_numeric(series, errors='coerce').dropna() if len(numeric_data) < 2: continue mean_val = numeric_data.mean() std_val = numeric_data.std(ddof=0) cv = std_val / mean_val if mean_val != 0 else np.nan if pd.notna(cv) and cv > 0.2: # 提取整列原始数据(不限于前25行) full_col_data = df.iloc[:, col_idx].reset_index(drop=True) results.append({ '源文件': file_name, 'Sheet': sheet_name, # '列名': col_name, '均值': round(mean_val, 6), '标准差': round(std_val, 6), '变异系数(CV)': round(cv, 6), '原始数据': full_col_data # 后续会拼接到表格中 }) print(f"✅ 发现高变异列: {file_name} | {sheet_name} | 列'{col_name}', CV={cv:.6f}") # ================== 汇总输出到 Excel ================== if not results: print("\n⚠️ 未发现变异系数大于 0.2 的列。") else: print(f"\n📊 共找到 {len(results)} 个变异系数 > 0.2 的列,开始生成汇总文件...") with pd.ExcelWriter(output_file, engine='openpyxl') as writer: summary_list = [] data_dfs = [] for i, res in enumerate(results): # 构造摘要行 summary_row = { '源文件': res['源文件'], 'Sheet': res['Sheet'], # '列名': res['列名'], '均值': res['均值'], '标准差': res['标准差'], '变异系数(CV)': res['变异系数(CV)'] } summary_list.append(summary_row) # 构造带标签的数据列(添加说明头) col_data = res['原始数据'].copy() col_data.index.name = None # 添加来源信息作为列名前缀 new_series = pd.Series([f"{res['源文件']} | {res['Sheet']} | {res['列名']}"]) new_series = pd.concat([new_series, col_data], ignore_index=True) data_dfs.append(new_series) # 写入“汇总统计”sheet summary_df = pd.DataFrame(summary_list) summary_df.to_excel(writer, sheet_name='汇总统计', index=False) # 合并所有高变异列到“原始数据”sheet(横向排列) if data_dfs: combined_df = pd.concat(data_dfs, axis=1) # 重命名列为 Col1, Col2... combined_df.columns = [f"列_{i + 1}" for i in range(len(data_dfs))] combined_df.to_excel(writer, sheet_name='高变异数据列', index=False) print(f"✅ 汇总完成!结果已保存至:\n {output_file}") ——这段代码就引入了三个库,但是封装玩了内存150多MB,有什么办法让引入库的内存变小一点
11-06
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值