An automated data science companion for cleaning, analyzing, and visualizing datasets using Python and Pandas.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install data-analyst-cn
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-analyst-cn 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 Analyst Assistant?
The Data Analyst Assistant is a specialized tool within the Openclaw Skills ecosystem designed to streamline the entire data lifecycle. It provides developers, product managers, and analysts with a robust framework for handling raw data, performing rigorous statistical checks, and generating production-ready visualizations. By leveraging the power of the Python data science stack, this skill transforms complex data manipulation tasks into simple, repeatable workflows.
Built to handle everything from missing value imputation to advanced time-series decomposition, this skill ensures that your data is not only clean but also provides meaningful insights. Whether you are working with local CSV files or querying remote databases, the Data Analyst Assistant acts as an intelligent layer that suggests the best analytical approaches and code snippets for your specific dataset.
Data Analyst Assistant Use Cases
- Automating the cleaning of messy datasets by removing duplicates and handling outliers.
- Generating descriptive statistical reports to understand data distribution and central tendencies.
- Creating professional-grade visualizations like heatmaps, violin plots, and time-series trends.
- Performing correlation analysis to identify key drivers in business or product metrics.
- Developing automated reporting pipelines that summarize KPIs from various data sources.
How Data Analyst Assistant Works
- The user inputs a data source path or a specific data-related query to the agent.
- The skill utilizes Pandas to ingest the data from formats such as CSV, Excel, JSON, or SQL.
- An initial data profiling step is performed to identify data types, missing values, and basic statistics.
- Based on the user's requirement, the skill applies pre-defined cleaning templates or statistical functions.
- Logic is executed to perform advanced transformations like time-series resampling or grouping.
- The skill outputs either cleaned data files, visualization code using Matplotlib/Seaborn, or a comprehensive Markdown report.
Data Analyst Assistant Setup
To use this assistant with Openclaw Skills, ensure your environment has Python 3 installed along with the necessary data science libraries.
# Install the required Python dependencies
pip install pandas matplotlib seaborn statsmodels openpyxl requests
Ensure that your workspace has the necessary permissions to read the input data files and write the generated reports or images.
Data Analyst Assistant Data Schema & Taxonomy
The Data Analyst Assistant organizes information into structured DataFrames and outputs results in standardized formats:
| Component | Details |
|---|---|
| Input Formats | CSV, XLSX, JSON, SQL Database, API JSON Responses |
| Data Processing | Structured via Pandas DataFrames with automated type inference |
| Analysis Output | Descriptive statistics, correlation matrices, and distribution metrics |
| Visual Exports | Python code for Matplotlib/Seaborn plots (PNG/SVG ready) |
| Reporting | Markdown-formatted analysis reports including key findings and suggestions |
Data Analyst Assistant Advanced Features
- Intelligent anomaly detection using Interquartile Range (IQR) methods.
- Comprehensive time-series analysis including seasonal decomposition and rolling statistics.
- Multi-category grouping and cross-tabulation for deep-dive segment analysis.
- Automated report generation function that synthesizes raw metrics into business insights.
- Support for custom visualization templates with pre-configured themes and Chinese font support.
SKILL.md
Loading
Related Openclaw Skills
Browser Fingerprinting Reference
A comprehensive, offline reference tool for developers to quickly lookup browser fingerprinting concepts, security patterns, and debugging workflows.
Learning Check-in
A lightweight habit-tracking tool that helps users maintain daily learning consistency through simple check-ins and intelligent reminders.
Capistrano Reference Skill
A comprehensive, zero-config reference tool for mastering Capistrano deployment concepts and best practices.
CORS Tester
A command-line utility for testing, debugging, and securing Cross-Origin Resource Sharing (CORS) configurations on live URLs.
AutoHotkey Reference Skill
A local, high-performance reference tool for AutoHotkey development providing instant access to patterns, best practices, and migration guides.
asr-claw
A high-performance speech recognition CLI that enables seamless audio transcription for AI agents within the Openclaw Skills library.
Featured*
