A specialized skill for generating Python scripts that automate the transformation of raw ERP exports into structured Excel reports based on custom templates.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install data-processing-script-generator
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-processing-script-generator 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 Processing Script Generator?
The Data Processing Script Generator is an essential addition to Openclaw Skills designed to bridge the gap between raw data exports and polished business intelligence. It analyzes user-provided Excel templates and ERP data samples to write robust Python scripts that handle data cleaning, field calculations, and complex mapping automatically.
By leveraging this skill, users can eliminate repetitive manual entry. The generated scripts are engineered to maintain original template formatting, including pivot tables and slicers, while ensuring data integrity through advanced encoding detection and standardized path management.
Data Processing Script Generator Use Cases
- Automating daily inventory reports by merging ERP CSV exports with master Excel templates.
- Generating recurring financial summaries that require specific data cleaning and derived field calculations.
- Transitioning manual VLOOKUP-heavy spreadsheets into high-performance automated Python workflows.
- Consolidating multiple daily data exports into a single master aggregate file.
How Data Processing Script Generator Works
- The agent requests and analyzes the base Excel template and a sample of the raw ERP export data.
- It prompts the user to define specific cleaning rules, such as filtering empty rows or zero-stock items.
- Mapping relationships are established between export columns and template fields.
- Fixed file paths and naming conventions for inputs and outputs are confirmed with the user.
- The skill generates a Python script that uses zip/XML writing techniques to preserve Excel formatting.
- A test run is performed to validate the script logic before final delivery to the user.
Data Processing Script Generator Setup
To use this script generator within your environment, ensure you have Python installed and the necessary libraries for Excel manipulation.
# Install required dependencies
pip install pandas openpyxl
# Call the skill via your AI agent
# "Help me generate a data processing script for my daily ERP export"
Data Processing Script Generator Data Schema & Taxonomy
The skill expects a specific directory structure to ensure the generated Openclaw Skills scripts run reliably:
| Variable | Description | Example Format |
|---|---|---|
| EXPORT_DIR | Directory containing raw ERP files | /path/to/daily_exports/ |
| TEMPLATE_PATH | Location of the master .xlsx template | Report-Template.xlsx |
| OUTPUT_DIR | Destination for processed reports | /path/to/final_reports/ |
| Encoding | Default character encoding for CSVs | gb18030, utf-8, or gbk |
Data Processing Script Generator Advanced Features
- Multi-encoding support to automatically attempt gb18030, gbk, and utf-8 for legacy ERP systems.
- Format-preserving writes that protect existing Excel Pivot Tables, Slicers, and conditional formatting.
- Centralized configuration blocks at the top of scripts for easy path and variable adjustments by non-developers.
- Automated date-matching logic to identify and process the most recent export files in a directory.
SKILL.md
Loading
Related Openclaw Skills
prose-to-deck
A sophisticated AI agent skill that transforms long-form text into polished, single-file HTML presentations with editorial pacing.
Prediction Market Data
A comprehensive data connector for Polymarket and Kalshi providing real-time market prices, historical trades, and cross-platform arbitrage intelligence.
Prediction Market Arbitrage
Detect and analyze arbitrage opportunities by matching events and comparing prices across Polymarket and Kalshi.
Android Native Development
A comprehensive toolkit for professional Android development focusing on Material Design 3, Kotlin coroutines, and Jetpack Compose best practices.
Notifications Engine
A multi-channel notification delivery system designed for AI agents to send email and SMS messages using customizable templates and delivery logs.
Vex NSFW Image Generator
An automated image generation skill designed to produce artistic, uncensored adult content of Vex using the each::sense API.
Featured*
