← Back to Skills Marketplace
52yuanchangxing

csv-cleanroom

by vx：17605205782 · GitHub ↗ · v1.0.0 · MIT-0
cross-platform ✓ Security Clean
287
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install csv-cleanroom
Description
Profile messy CSV files, standardize columns, detect data quality issues, and produce a reproducible cleanup plan.
README (SKILL.md)

CSV Cleanroom

Purpose

Profile messy CSV files, standardize columns, detect data quality issues, and produce a reproducible cleanup plan.

Trigger phrases

  • 清洗 CSV
  • profile this dataset
  • 数据质量检查
  • 列名规范化
  • build a cleanup plan

Ask for these inputs

  • CSV file or schema
  • target schema if available
  • known bad values
  • dedupe rules
  • date/currency locale

Workflow

  1. Profile the CSV: row count, nulls, duplicates, type mismatches, and outliers.
  2. Normalize headers and map to the target schema.
  3. Generate a step-by-step cleanup plan and optional transformed output.
  4. Document irreversible operations before applying them.
  5. Return a quality score and remediation checklist.

Output contract

  • profile report
  • normalized schema
  • cleanup plan
  • quality scorecard

Files in this skill

  • Script: {baseDir}/scripts/csv_cleanroom.py
  • Resource: {baseDir}/resources/data_quality_checklist.md

Operating rules

  • Be concrete and action-oriented.
  • Prefer preview / draft / simulation mode before destructive changes.
  • If information is missing, ask only for the minimum needed to proceed.
  • Never fabricate metrics, legal certainty, receipts, credentials, or evidence.
  • Keep assumptions explicit.

Suggested prompts

  • 清洗 CSV
  • profile this dataset
  • 数据质量检查

Use of script and resources

Use the bundled script when it helps the user produce a structured file, manifest, CSV, or first-pass draft. Use the resource file as the default schema, checklist, or preset when the user does not provide one.

Boundaries

  • This skill supports planning, structuring, and first-pass artifacts.
  • It should not claim that files were modified, messages were sent, or legal/financial decisions were finalized unless the user actually performed those actions.

Compatibility notes

  • Directory-based AgentSkills/OpenClaw skill.
  • Runtime dependency declared through metadata.openclaw.requires.
  • Helper script is local and auditable: scripts/csv_cleanroom.py.
  • Bundled resource is local and referenced by the instructions: resources/data_quality_checklist.md.
Usage Guidance
This skill appears to be a local, auditable CSV profiling and planning tool. Before installing/using it: (1) review scripts/csv_cleanroom.py yourself — it writes a profile JSON (default csv_profile.json) to the working directory and could overwrite that file if present; (2) run the helper in a safe/isolated folder if your CSVs contain sensitive data; (3) remember the skill will not perform destructive edits by default — require explicit confirmation before applying changes; (4) ensure python3 is on PATH. If you need stronger guarantees, run the script manually on a copy of your data first.
Capability Analysis
Type: OpenClaw Skill Name: csv-cleanroom Version: 1.0.0 The csv-cleanroom skill is a legitimate utility for profiling and cleaning CSV files. The Python script (scripts/csv_cleanroom.py) performs basic data analysis using standard libraries without any network access, obfuscation, or dangerous execution patterns. The instructions in SKILL.md are well-defined, focus strictly on the stated data processing task, and include safety-oriented operating rules such as preferring simulation modes and avoiding destructive actions without user consent.
Capability Assessment
✓ Purpose & Capability
Name/description (CSV profiling and cleanup planning) align with the included artefacts: a small Python helper script and a checklist resource. Declared runtime requirement is only python3, which is proportionate to the stated purpose.
✓ Instruction Scope
SKILL.md restricts behavior to profiling, schema-normalization guidance, and producing plans/preview artifacts. It references only the local script and resource file. The bundled script only reads the explicitly provided CSV path and writes a JSON profile output; SKILL.md emphasizes preview-first and avoiding destructive actions unless the user asks.
✓ Install Mechanism
No install spec is present (instruction-only skill with a local script). This is low-risk: nothing is downloaded or executed from remote hosts and the helper script is local and auditable.
✓ Credentials
The skill declares no environment variables, credentials, or config paths. The Python script does not access environment secrets or external services. Requested inputs (CSV path, target schema, etc.) match the functionality.
✓ Persistence & Privilege
always is false and the skill does not request persistent/privileged agent presence or modify other skills. Autonomous invocation remains platform-default and is not a specific red flag here.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install csv-cleanroom
  3. After installation, invoke the skill by name or use /csv-cleanroom
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
csv-cleanroom 1.1.0 - Adds skill metadata, including required binary (python3) and emoji identifier. - Expands on supported workflow: CSV profiling, schema normalization, cleanup planning, and quality scoring. - Documents expected inputs (e.g., known bad values, dedupe rules, locale). - Clarifies output contract: profile report, normalized schema, cleanup plan, quality scorecard. - Provides guidance for safe use, including preview mode and boundaries on operations. - Introduces default scripts and resources for local, auditable processing.
Metadata
Slug csv-cleanroom
Version 1.0.0
License MIT-0
All-time Installs 0
Active Installs 0
Total Versions 1
Frequently Asked Questions

What is csv-cleanroom?

Profile messy CSV files, standardize columns, detect data quality issues, and produce a reproducible cleanup plan. It is an AI Agent Skill for Claude Code / OpenClaw, with 287 downloads so far.

How do I install csv-cleanroom?

Run "/install csv-cleanroom" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is csv-cleanroom free?

Yes, csv-cleanroom is completely free, licensed under MIT-0. You can download, install and use it at no cost.

Which platforms does csv-cleanroom support?

csv-cleanroom is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created csv-cleanroom?

It is built and maintained by vx：17605205782 (@52yuanchangxing); 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...
⬇ 463283 · 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.
⬇ 259410 · 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...
⬇ 200423 · 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.
⬇ 191115 · by steipete
ontology
Typed knowledge graph for structured agent memory and composable skills. Use when creating/querying entities (Person, Project, Task, Event, Document), linkin...
⬇ 190156 · by oswalpalash

💬 Comments