An interactive command-line interface designed for professional data cleaning, featuring automatic type inference and flexible missing value strategies.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install csv-wizard
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install csv-wizard using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is CSV Wizard?
CSV Wizard is a robust data preparation tool within the Openclaw Skills ecosystem, engineered to transform messy datasets into analysis-ready files. It eliminates the manual drudgery of data munging by providing an automated yet customizable environment for handling complex CSV structures.
Whether you are a data scientist or a developer, this tool simplifies the lifecycle of data ingestion. It handles everything from character encoding normalization to UTF-8 to the standardization of boolean values, ensuring your downstream applications receive clean, consistent input every time.
CSV Wizard Use Cases
- Automating the cleaning of large datasets for machine learning pipelines.
- Standardizing column headers to snake_case for database compatibility.
- Interactive exploration and statistical profiling of unknown CSV files.
- Rapidly filling missing data points using mean, median, or mode strategies.
- Identifying and removing duplicate records in transactional data.
How CSV Wizard Works
- The user initiates the process using the /clean-csv command followed by the target file path.
- CSV Wizard performs an initial pass to infer data types across all columns (numeric, date, boolean, or categorical).
- Depending on the flags provided, the tool analyzes the dataset for missing values and duplicate rows.
- If interactive mode is enabled, the user is prompted to make decisions on specific cleaning actions.
- The tool applies transformations such as whitespace trimming and header standardization.
- A sanitized, UTF-8 encoded CSV file is generated at the specified output destination.
CSV Wizard Setup
To start using this tool from Openclaw Skills, ensure your environment is ready and run the following commands:
# Basic installation via Openclaw
openclaw install csv-wizard
# Verify installation by checking the help menu
/clean-csv --help
CSV Wizard Data Schema & Taxonomy
CSV Wizard organizes its operations and outputs based on the following structure:
| Feature | Metadata/Logic Treatment |
|---|---|
| Encoding | Forces all outputs to UTF-8 to prevent character corruption. |
| Column Names | Optional conversion to snake_case using --standardize-names. |
| Data Types | Auto-detects Numeric, Date, Boolean, and Categorical variables. |
| Value Padding | Trims leading/trailing whitespace from all string entries. |
| Booleans | Normalizes truthy/falsy values to standard True/False. |
CSV Wizard Advanced Features
- Multi-strategy missing value imputation (drop, mean, median, mode, or constant).
- Full interactive CLI mode for step-by-step data auditing and cleaning.
- Statistical summary generation with the
--infoflag for instant data profiling. - Seamless integration into automated workflows using non-interactive CLI flags.
- Automatic duplicate detection and removal to ensure data integrity.
SKILL.md
Loading
Related Openclaw Skills
LaTeX Compiler
A high-performance LaTeX compilation engine for AI agents to generate professional PDFs from source strings.
Cloudflare Crawl
A high-performance web crawler utilizing Cloudflare's Browser Rendering API to extract AI-ready Markdown and structured JSON from entire websites.
Progressive Insurance Skill
A comprehensive informational skill for navigating Progressive’s wide range of auto, home, and commercial insurance products and savings programs.
Creator Attribution Lite
A lightweight attribution model designed to connect content outputs directly to business outcomes and ROI.
HabitTracker Conversational Habit Tracking
A conversational AI skill that eliminates manual logging by tracking your daily habits, streaks, and accountability through natural chat.
Liufeng Greeting Skill
A personalized greeting skill that detects user welcomes and responds with customized messages and real-time timestamps.
Featured*
