← Back to Skills Marketplace
lijinhao123-dot

Excel 数据自动清洗引擎 Pro

by Lijinhao123-Dot · GitHub ↗ · v1.0.0 · MIT-0
cross-platform ⚠ suspicious
26
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install excel-auto-cleaner-pro
Description
Excel 数据自动清洗引擎 — 自动去重、格式统一、缺失值处理、智能分类、交叉验证。 拖进去一份脏数据，出来一份干净能用的报表。支持 CSV/XLSX/JSON 多格式。 适合财务、运营、数据分析师、电商卖家。
README (SKILL.md)

Excel 数据自动清洗引擎

别再手动清理数据了，AI 比你快 100 倍

能做什么

  • 🧹 自动去重 — 按单列或多列去重，智能识别相似重复
  • 📐 格式统一 — 日期/电话/地址/金额...自动标准化
  • 🔧 缺失值处理 — 智能填充/标记/删除空值
  • 🏷️ 智能分类 — 根据内容自动打标签/归类
  • ✅ 交叉验证 — 检查数据逻辑（比如金额=单价×数量）
  • 📊 输出报表 — 生成清洗前后对比 + 数据质量评分

触发方式

用户说以下任意关键词时加载此技能：

  • "清洗数据" "整理表格" "处理 Excel"
  • "去重" "数据太乱" "帮我看这个表"

使用流程

第一步：读数据

让用户提供文件路径或粘贴数据。

  • read 直接读文件（CSV/TXT/JSON）
  • Excel 用 Python openpyxl 解析

第二步：体检报告

自动扫描并输出数据质量报告：

📊 数据体检报告
━━━━━━━━━━━━━━━
总行数：12,847
总列数：18
重复行：342 (2.7%)
缺失值：156 处
   - 价格列：23 个空值
   - 日期列：89 个格式错误
   - 手机号列：44 个不规范
异常值：12 处（价格负数、日期未来）
数据质量分：82/100 ⚠️

第三步：自动清洗

按发现的问题逐项处理：

  1. 去重 — 保留第一条或按业务规则合并
  2. 日期标准化 — 统一为 YYYY-MM-DD 格式
  3. 电话标准化 — 统一为纯数字或格式化
  4. 金额清洗 — 去除货币符号/空格，统一小数位
  5. 空值处理 — 数值列填中位数、分类列填"未知"
  6. 异常值标记 — 标记可疑数据但不删除

第四步：输出清洗结果

保存清洗后的文件：

  • 原文件名_cleaned.xlsx（干净数据）
  • 原文件名_report.md（清洗报告，记录了改了什么）

第五步：可选拓展

用户可以说：

  • "再帮我分类" → 对某列 AI 自动分类
  • "生成图表" → 自动生成柱状图/折线图/饼图
  • "导出飞书表格" → 写入飞书多维表格

工具使用

  • read — 读取原始数据文件
  • exec — 运行 Python openpyxl/pandas 处理
  • write — 写出清洗后的文件
  • web_search — 辅助数据验证（如手机号归属地）

常用清洗规则（内置）

列类型 规则
手机号 去空格、统一 11 位、验证格式
日期 统一 YYYY-MM-DD、修复乱码日期
金额 去货币符号、统一小数、检测异常
地址 提取省市区、补充邮编
姓名 去空格、统一大小写
身份证 验证校验位、提取生日性别

客户画像

  • 做财务/报表的运营
  • 每天要处理供应商报价的采购
  • 电商卖家（批量处理订单/商品数据）
  • 数据分析新人（不想写 Python）

定价参考

本技能模板在 ClawHub 建议售价：39-69 元 搭配定制化清洗规则：129 元

由 OpenClaw 技能工厂制作 | 2026.05

Usage Guidance
Install only if you are comfortable processing the spreadsheet contents with this agent. Avoid external web_search for personal or confidential data unless you explicitly approve the exact lookup, keep original files, review the cleaning report, and confirm any Feishu export destination and permissions.
Capability Analysis
Type: OpenClaw Skill Name: excel-auto-cleaner-pro Version: 1.0.0 The skill is a legitimate data processing utility designed for cleaning Excel, CSV, and JSON files. It utilizes standard tools such as Python's pandas and openpyxl via the 'exec' command to perform data deduplication, formatting, and validation as described in SKILL.md. No evidence of data exfiltration, malicious prompt injection, or unauthorized system access was found.
Capability Assessment
ℹ Purpose & Capability
The core workflow is coherent for CSV/XLSX/JSON cleaning, but the stated use cases include finance, e-commerce, phone numbers, addresses, and ID numbers, so the data being processed may be sensitive.
⚠ Instruction Scope
The instructions allow automatic validation with web_search for phone-number-related data without specifying user approval, redaction, or external data-sharing limits.
✓ Install Mechanism
There is no install spec and no code files; this is an instruction-only skill. Runtime use of Python/pandas/openpyxl is disclosed in the skill text and appears purpose-aligned.
⚠ Credentials
Reading and writing user-provided spreadsheet files is proportionate, but combining sensitive spreadsheet fields with external web_search is not clearly bounded.
ℹ Persistence & Privilege
The skill writes cleaned files and reports and optionally writes to Feishu; there is no background persistence, but users should confirm destinations and account permissions.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install excel-auto-cleaner-pro
  3. After installation, invoke the skill by name or use /excel-auto-cleaner-pro
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
首发版本：支持自动去重、格式统一、缺失值处理、智能分类、交叉验证、数据质量评分报告
Metadata
Slug excel-auto-cleaner-pro
Version 1.0.0
License MIT-0
All-time Installs 0
Active Installs 0
Total Versions 1
Frequently Asked Questions

What is Excel 数据自动清洗引擎 Pro?

Excel 数据自动清洗引擎 — 自动去重、格式统一、缺失值处理、智能分类、交叉验证。 拖进去一份脏数据，出来一份干净能用的报表。支持 CSV/XLSX/JSON 多格式。 适合财务、运营、数据分析师、电商卖家。 It is an AI Agent Skill for Claude Code / OpenClaw, with 26 downloads so far.

How do I install Excel 数据自动清洗引擎 Pro?

Run "/install excel-auto-cleaner-pro" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is Excel 数据自动清洗引擎 Pro free?

Yes, Excel 数据自动清洗引擎 Pro is completely free, licensed under MIT-0. You can download, install and use it at no cost.

Which platforms does Excel 数据自动清洗引擎 Pro support?

Excel 数据自动清洗引擎 Pro is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created Excel 数据自动清洗引擎 Pro?

It is built and maintained by Lijinhao123-Dot (@lijinhao123-dot); the current version is v1.0.0.

More Skills
self-improving agent
Captures learnings, errors, and corrections to enable continuous improvement. Use when: (1) A command or operation fails unexpectedly, (2) User corrects Clau...
⬇ 463556 · by pskoett
Skill Vetter
Security-first skill vetting for AI agents. Use before installing any skill from ClawdHub, GitHub, or other sources. Checks for red flags, permission scope, and suspicious patterns.
⬇ 259610 · by spclaudehome
Polymarket
Query Polymarket prediction markets. Check odds, find trending markets, search events, track price movements.
⬇ 232503 · by joelchance
Self-Improving + Proactive Agent
Self-reflection + Self-criticism + Self-learning + Self-organizing memory. Agent evaluates its own work, catches mistakes, and improves permanently. Use when...
⬇ 200551 · by ivangdavila
Github
Interact with GitHub using the `gh` CLI. Use `gh issue`, `gh pr`, `gh run`, and `gh api` for issues, PRs, CI runs, and advanced queries.
⬇ 191226 · by steipete
ontology
Typed knowledge graph for structured agent memory and composable skills. Use when creating/querying entities (Person, Project, Task, Event, Document), linkin...
⬇ 190235 · by oswalpalash

💬 Comments