ClawHub

excel-clean

v1.0.0

Clean Excel data — deduplication, fill missing values, format conversion.

⭐ 0· 98·0 current·0 all-time
by@martin-sh-ni

Install

OpenClaw Prompt Flow

Install with OpenClaw

Best for remote or guided setup. Copy the exact prompt, then paste it into OpenClaw for martin-sh-ni/excel-clean.

Previewing Install & Setup.
Prompt PreviewInstall & Setup
Install the skill "excel-clean" (martin-sh-ni/excel-clean) from ClawHub.
Skill page: https://clawhub.ai/martin-sh-ni/excel-clean
Keep the work scoped to this skill only.
After install, inspect the skill metadata and help me finish setup.
Use only the metadata you can verify from ClawHub; do not invent missing requirements.
Ask before making any broader environment changes.

Command Line

CLI Commands

Use the direct CLI path if you want to install manually and keep every step visible.

OpenClaw CLI

Bare skill slug

openclaw skills install excel-clean

ClawHub CLI

Package manager switcher

npx clawhub@latest install excel-clean
Security Scan
VirusTotalVirusTotal
Benign
View report →
OpenClawOpenClaw
Benign
medium confidence
✓
Purpose & Capability
Name/description (Excel cleaning) align with the SKILL.md operations (dedupe, fill, convert) and the listed dependencies (pandas, openpyxl). The requirements requested are proportionate to the stated purpose. One minor gap: the SKILL.md implies Python usage but the skill does not declare a Python runtime or install steps.
✓
Instruction Scope
Instructions stay within scope: they describe reading an input Excel file, performing local transforms, and writing a _cleaned.xlsx output. The SKILL.md does not instruct reading unrelated files, accessing environment secrets, or transmitting data externally. It describes a function signature but provides no implementation code.
ℹ
Install Mechanism
This is an instruction-only skill with no install spec. Dependencies are Python packages (pandas, openpyxl) — reasonable for the task, but the skill does not provide how/when those packages will be installed or whether a Python runtime is available.
✓
Credentials
No environment variables, credentials, or config paths are requested. The skill does not ask for unrelated secrets or broad system access.
✓
Persistence & Privilege
No elevated privileges requested: always:false and user-invocable:true. The skill does not request to modify other skills or system-wide settings.
Assessment
This skill appears coherent for cleaning Excel files, but note it is instruction-only: it assumes a Python runtime with pandas and openpyxl are available (or that the agent will pip-install them). Before installing or running: confirm the agent/environment will run Python safely; verify where files are read from and written to (ensure the agent has only the filesystem access you expect); avoid processing sensitive spreadsheets with an agent you don't fully trust; if you need guarantees, ask the skill author for an explicit install script or a packaged implementation so you can review the exact code that will run.

Like a lobster shell, security has layers — review code before you run it.

latestvk97b3aj7sd7n9wh8vgv26v4pgh84pt3w
98downloads
0stars
1versions
Updated 2w ago
v1.0.0
MIT-0
@martin-sh-ni
latest
Download

Excel Cleaner（Excel数据清洗）

去重 / 空值填充 / 格式转换 | Pandas驱动

功能 | Features

  • ✅ 批量去重 — 按指定列组合去重
  • ✅ 空值填充 — 支持填充固定值、前值、后值
  • ✅ 格式转换 — 数值/文本/日期格式互转
  • ✅ 保留原文件 — 输出为 _cleaned.xlsx，原文件不变

使用场景 | Use Cases

场景说明
名单去重删除重复客户/订单记录
数据补全用"未知"或0填充空值
格式标准化日期统一为 YYYY-MM-DD

使用方式 | Usage

输入参数:
  file_path       Excel文件路径
  dedup_cols      去重列名列表（可选）
  fill_value      空值填充内容（可选）
  convert_type    格式类型转换（可选）

输出:
  success         是否成功
  output          输出文件路径
  rows            处理后行数

示例 | Example

result = excel_clean(
    file_path="/data/orders.xlsx",
    dedup_cols=["订单号", "手机号"],
    fill_value="未知",
    convert_type="日期:YYYY-MM-DD"
)

依赖 | Dependencies

pandas >= 1.3.0
openpyxl >= 3.0.0

版本 v1.0

Comments

Loading comments...