csv-wizard

交互式数据清洗 CLI,支持自动类型推断、缺失值处理、重复检测

3,891 stars

Best use case

csv-wizard is best used when you need a repeatable AI agent workflow instead of a one-off prompt.

交互式数据清洗 CLI,支持自动类型推断、缺失值处理、重复检测

Teams using csv-wizard should expect a more consistent output, faster repeated execution, less prompt rewriting.

When to use this skill

  • You want a reusable workflow that can be run more than once with consistent structure.

When not to use this skill

  • You only need a quick one-off answer and do not need a reusable workflow.
  • You cannot install or maintain the underlying files, dependencies, or repository context.

Installation

Claude Code / Cursor / Codex

$curl -o ~/.claude/skills/csv-wizard/SKILL.md --create-dirs "https://raw.githubusercontent.com/openclaw/skills/main/skills/antonia-sz/csv-wizard/SKILL.md"

Manual Installation

  1. Download SKILL.md from GitHub
  2. Place it in .claude/skills/csv-wizard/SKILL.md inside your project
  3. Restart your AI agent — it will auto-discover the skill

How csv-wizard Compares

Feature / Agentcsv-wizardStandard Approach
Platform SupportNot specifiedLimited / Varies
Context Awareness High Baseline
Installation ComplexityUnknownN/A

Frequently Asked Questions

What does this skill do?

交互式数据清洗 CLI,支持自动类型推断、缺失值处理、重复检测

Where can I find the source code?

You can find the source code on GitHub using the link provided at the top of the page.

Related Guides

SKILL.md Source

# CSV Wizard — 交互式数据清洗工具

强大的 CSV 数据清洗和转换工具,提供自动类型推断、缺失值处理、重复检测等功能。

## 功能特性

- 🔍 自动类型推断(数字、日期、布尔值、分类变量)
- 🧹 缺失值检测与多种填充策略
- 📊 数据统计摘要与预览
- 🔄 重复行检测与删除
- 📝 列名标准化与重命名
- 🎯 数据格式转换与导出

## 使用方法

### 基本清洗

```bash
/clean-csv data.csv --output clean-data.csv
```

### 交互式清洗(推荐)

```bash
/clean-csv data.csv --interactive
```

### 预览数据信息

```bash
/clean-csv data.csv --info
```

### 处理缺失值

```bash
/clean-csv data.csv --fill-missing mean --output result.csv
```

### 删除重复行

```bash
/clean-csv data.csv --drop-duplicates --output result.csv
```

## 选项说明

| 选项 | 说明 |
|------|------|
| `--info` | 显示数据基本信息 |
| `--preview` | 预览前 N 行数据 |
| `--fill-missing` | 缺失值填充策略(drop/mean/median/mode/constant) |
| `--drop-duplicates` | 删除重复行 |
| `--standardize-names` | 标准化列名(snake_case) |
| `--interactive` | 交互式模式 |
| `--output` | 输出文件路径 |

## 缺失值填充策略

- `drop` - 删除包含缺失值的行
- `mean` - 使用列均值填充(仅数值列)
- `median` - 使用中位数填充(仅数值列)
- `mode` - 使用众数填充
- `constant` - 使用固定值填充(需配合 `--fill-value`)

## 示例

```bash
# 查看数据摘要
/clean-csv sales.csv --info

# 清洗数据:删除重复行 + 填充缺失值
/clean-csv sales.csv --drop-duplicates --fill-missing median --output clean-sales.csv

# 交互式清洗
/clean-csv data.csv --interactive

# 仅标准化列名
/clean-csv data.csv --standardize-names --output output.csv
```

## 输出说明

清洗后的 CSV 文件将保留原始格式,同时:
- 自动处理编码问题(统一为 UTF-8)
- 移除首尾空格
- 标准化布尔值(True/False)

Related Skills

meta-mcp-wizard

3891
from openclaw/skills

Use the MCPHero Meta-MCP server inside AI clients (Claude Desktop, Cursor, etc.) to create, deploy, and manage MCP servers through the wizard pipeline. Use this skill when the user wants to connect the Meta-MCP server, build MCP servers interactively via MCP tools, or asks about the meta-mcp endpoint at api.mcphero.app.

graphical-abstract-wizard

3891
from openclaw/skills

Generate graphical abstract layout recommendations based on paper abstracts

---

3891
from openclaw/skills

name: article-factory-wechat

Content & Documentation

humanizer

3891
from openclaw/skills

Remove signs of AI-generated writing from text. Use when editing or reviewing text to make it sound more natural and human-written. Based on Wikipedia's comprehensive "Signs of AI writing" guide. Detects and fixes patterns including: inflated symbolism, promotional language, superficial -ing analyses, vague attributions, em dash overuse, rule of three, AI vocabulary words, negative parallelisms, and excessive conjunctive phrases.

Content & Documentation

find-skills

3891
from openclaw/skills

Helps users discover and install agent skills when they ask questions like "how do I do X", "find a skill for X", "is there a skill that can...", or express interest in extending capabilities. This skill should be used when the user is looking for functionality that might exist as an installable skill.

General Utilities

tavily-search

3891
from openclaw/skills

Use Tavily API for real-time web search and content extraction. Use when: user needs real-time web search results, research, or current information from the web. Requires Tavily API key.

Data & Research

baidu-search

3891
from openclaw/skills

Search the web using Baidu AI Search Engine (BDSE). Use for live information, documentation, or research topics.

Data & Research

agent-autonomy-kit

3891
from openclaw/skills

Stop waiting for prompts. Keep working.

Workflow & Productivity

Meeting Prep

3891
from openclaw/skills

Never walk into a meeting unprepared again. Your agent researches all attendees before calendar events—pulling LinkedIn profiles, recent company news, mutual connections, and conversation starters. Generates a briefing doc with talking points, icebreakers, and context so you show up informed and confident. Triggered automatically before meetings or on-demand. Configure research depth, advance timing, and output format. Walking into meetings blind is amateur hour—missed connections, generic small talk, zero leverage. Use when setting up meeting intelligence, researching specific attendees, generating pre-meeting briefs, or automating your prep workflow.

Workflow & Productivity

self-improvement

3891
from openclaw/skills

Captures learnings, errors, and corrections to enable continuous improvement. Use when: (1) A command or operation fails unexpectedly, (2) User corrects Claude ('No, that's wrong...', 'Actually...'), (3) User requests a capability that doesn't exist, (4) An external API or tool fails, (5) Claude realizes its knowledge is outdated or incorrect, (6) A better approach is discovered for a recurring task. Also review learnings before major tasks.

Agent Intelligence & Learning

botlearn-healthcheck

3891
from openclaw/skills

botlearn-healthcheck — BotLearn autonomous health inspector for OpenClaw instances across 5 domains (hardware, config, security, skills, autonomy); triggers on system check, health report, diagnostics, or scheduled heartbeat inspection.

DevOps & Infrastructure

linkedin-cli

3891
from openclaw/skills

A bird-like LinkedIn CLI for searching profiles, checking messages, and summarizing your feed using session cookies.

Content & Documentation