An AI-driven data cleaning utility that automatically handles duplicates, missing values, and formatting errors in Excel and CSV files.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install data-cleaner-tool
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 data-cleaner-tool 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 Data Cleaner Pro?
Data Cleaner Pro is a sophisticated tool designed to simplify the complex task of data preparation. By integrating with Openclaw Skills, it provides a seamless workflow for cleaning messy datasets, ensuring that your data is accurate and ready for analysis. The skill leverages advanced logic to identify and fix common data issues, such as inconsistent date formats, invalid phone numbers, and duplicate records.
Built on a foundation of professional data science libraries, this skill bridges the gap between raw data collection and high-quality reporting. Whether you are dealing with financial ledgers or marketing contact lists, it provides a reliable way to maintain data integrity without manual intervention.
Data Cleaner Pro Use Cases
- Standardizing marketing reports by cleaning customer names and fixing email formatting.
- Auditing financial data to remove duplicate transactions and fill missing entries.
- Organizing HR employee lists to ensure consistent phone number and ID formats.
- Batch processing historical data files to prepare them for machine learning models.
How Data Cleaner Pro Works
- The user triggers the skill by providing the path to an Excel or CSV file.
- The system analyzes the data structure and identifies missing values, duplicates, and outliers.
- Based on selected rules or intelligent defaults, the tool applies cleaning transformations like standardization and imputation.
- A refined version of the file is generated along with a comprehensive processing report detailing every change made.
Data Cleaner Pro Setup
To get started with this component of Openclaw Skills, ensure you have the required Python environment ready. Install the core dependencies using the following command:
pip install pandas openpyxl
Data Cleaner Pro Data Schema & Taxonomy
The skill manages data through a structured pipeline to ensure no information is lost during the cleaning process:
| Attribute | Description |
|---|---|
| Supported Formats | CSV, XLSX, XLS |
| Core Logic | Python-based pandas integration |
| Output Metadata | Includes total rows processed, rows deleted, and specific fields updated |
| Transformation Rules | Deduplication (keep first/last), Fill-na (mean/median/mode), and Regex-based formatting |
Data Cleaner Pro Advanced Features
- Batch processing capabilities to clean entire directories of files simultaneously.
- Intelligent outlier detection using a combination of statistical methods and custom business rules.
- Customizable filling strategies for missing values, including predictive filling for complex datasets.
- Automated validation for international phone numbers and localized date formats within the Openclaw Skills ecosystem.
SKILL.md
Loading
Related Openclaw Skills
Video Subtitle Downloader
A high-performance tool for downloading subtitles and generating time-indexed transcripts from over 1000 video platforms.
PageClaw Facebook AI
A high-efficiency skill that transforms an AI agent into a full-featured Facebook Page manager with automated OAuth and niche-specific skill sets.
WebSearch Multi-Engine Aggregator
A high-performance, multi-engine web search aggregator that provides comprehensive search results without requiring any API keys.
BytesAgain Wallet Tracker
A comprehensive on-chain analytics and crypto wallet reference tool providing documentation on address formats, transaction tracing, and security protocols.
Academic Paper Refinement
A professional 12-step AI workflow for systematic academic paper revision and critical peer review within Openclaw Skills.
Chinese Content Multi-platform Adapter
An automated formatting and optimization engine designed to adapt Chinese content for Juejin, Zhihu, Xiaohongshu, and WeChat Official Accounts.