data-analysis-skill

What This Skill Does

The Data-Analysis-Skill (DataMaster Pro) is an all-in-one automation agent designed to replace tedious manual Excel labor. It empowers users to automatically scrape web data, connect to external APIs or databases, perform intelligent data cleaning, generate professional visualizations, and draft comprehensive analysis reports. Whether you are dealing with scattered spreadsheets or massive API datasets, this skill transforms raw data into actionable insights using AI-driven workflows, effectively bridging the gap between raw information and decision-making.

Installation

To integrate this skill into your OpenClaw environment, execute the following command in your terminal: clawhub install openclaw/skills/skills/gdp6539/data-analysis-skill After the installation finishes, navigate to the skill directory and run npm install to set up all necessary dependencies. You can then use the provided run.bat or run scripts directly via the command line interface.

Use Cases

• Market Research: Automatically scrape competitor pricing and product listings from websites into a structured format.
• Operational Reporting: Pull daily sales data from your internal API, clean it for inconsistencies, generate performance charts, and export a business report to PDF.
• Database Management: Connect directly to your production databases to perform scheduled data audits and anomaly detection without manual SQL querying.
• Product Analysis: Aggregate user feedback and ratings from public web portals, perform trend analysis, and generate weekly insight reports.

Example Prompts

1. "Go to example.com/data, grab the table with the CSS selector 'table.data', clean the null values, and generate a bar chart showing the sales trends for this week."
2. "Fetch the latest metrics from the production API, normalize the 'price' and 'quantity' columns, and create a business-style PDF report summarizing the results."
3. "Set up a recurring task to scrape my competitor's website every day at 9 AM and alert me if there are any price drops in the data."

Tips & Limitations

• Pro-Tip: Use the provided config.json to define your cleaning rules and sources beforehand, which will save time and ensure consistent results across multiple runs.
• Visuals: Always verify your CSS selectors for web scraping; if a website updates its structure, the scraper may need an update to the selector path.
• Security: Be cautious when connecting to sensitive private APIs or databases. Ensure that your API tokens are stored securely in environment variables rather than hardcoded in the configuration files.
• Limitations: While the skill supports advanced AI insights, complex data sets exceeding local processing memory may require pre-aggregation or filtering at the source level.