← Back to Skills Marketplace
Data Analytics Studio
by
ai-gaoqian
· GitHub ↗
· v1.0.0
· MIT-0
39
Downloads
1
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install data-analytics-studio
Description
数据分析与可视化一站式工作台，支持CSV/Excel/JSON/SQL/API多数据源接入，自动数据清洗、统计建模、交互式图表生成、ETL管道构建、商业智能报告输出。覆盖Python生态(pandas/matplotlib/plotly)与BI场景。
README (SKILL.md)
Data Analytics Studio
数据分析与可视化一站式工作台，覆盖从数据接入、清洗转换、统计分析到可视化呈现和报告生成的完整数据管道。
触发条件
- "分析这个CSV文件"
- "画一个销售趋势图"
- "帮我做数据清洗"
- "生成月度业务报告"
- "这些数据有什么规律"
- "建立ETL管道从API同步数据"
- "做相关性分析"
核心能力
| 能力 | 说明 |
|---|---|
| 多源接入 | CSV/Excel/JSON/Parquet/SQL数据库/REST API/Web Scraping |
| 数据清洗 | 缺失值处理、异常值检测、格式标准化、去重、类型转换 |
| 探索分析 | 描述性统计、分布分析、相关性矩阵、时间序列分解 |
| 统计建模 | 回归分析、假设检验、聚类、时间序列预测、A/B测试 |
| 可视化 | 静态图(matplotlib/seaborn) + 交互式(plotly/bokeh) + 表格渲染 |
| ETL构建 | 数据提取→转换→加载管道，支持定时调度 |
| BI报告 | 自动生成结构化的业务分析报告（含图表和结论建议） |
| 自然语言查询 | "毛利最高的10个产品是什么" → 自动查询并可视化 |
可视化图表支持
- 趋势: 折线图、面积图
- 比较: 柱状图、条形图、雷达图
- 分布: 直方图、箱线图、小提琴图、密度曲线
- 关系: 散点图、气泡图、相关性热力图
- 组成: 饼图、堆叠图、树图、桑基图
- 地理: 地图/地理热力图
输出格式
📊 数据分析报告
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
数据源: [文件/数据库/API] | 行数: [N] | 列数: [N]
分析时间: [时间戳]
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
📈 关键发现:
1. [发现1 + 数值 + 趋势方向]
2. [发现2]
3. [发现3]
⚠️ 异常提示:
- [异常数据点 + 可能原因]
💡 建议:
- [基于数据的决策建议]
📎 图表: [已生成的文件路径列表]
注意事项
- 大文件（>100MB）自动采样分析，完整分析需确认
- 敏感数据列自动识别并脱敏（如手机号/身份证号/银行卡号）
- 统计结论附带置信区间，不夸大显著性
- 生成的图表保存为PNG/HTML两种格式，HTML支持交互
Usage Guidance
Safe to install for general data analysis use. Before using it on private business, customer, financial, or regulated data, confirm which files or APIs it will analyze and review generated reports/charts before sharing them.
Capability Assessment
Purpose & Capability
The stated purpose is CSV/Excel/JSON/SQL/API data analysis, cleaning, visualization, ETL, and BI reporting, and the described capabilities match that purpose.
Instruction Scope
The trigger examples are broad natural-language data-work requests, so it may activate for ordinary analytics tasks, but that is coherent with the skill's purpose and not hidden behavior.
Install Mechanism
The artifact contains a single SKILL.md file; metadata lists Python, pandas, and matplotlib requirements but no scripts, binaries, package install hooks, or auto-execution steps.
Credentials
Reading and processing local files, databases, APIs, and reports is proportionate for a data analytics skill, but users should be deliberate when using it on sensitive datasets.
Persistence & Privilege
No credential handling, privilege escalation, background agent, persistent worker, or unrelated filesystem mutation is described; output is limited to reports and chart files expected for the task.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install data-analytics-studio - After installation, invoke the skill by name or use
/data-analytics-studio - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
Initial release
Metadata
Frequently Asked Questions
What is Data Analytics Studio?
数据分析与可视化一站式工作台，支持CSV/Excel/JSON/SQL/API多数据源接入，自动数据清洗、统计建模、交互式图表生成、ETL管道构建、商业智能报告输出。覆盖Python生态(pandas/matplotlib/plotly)与BI场景。 It is an AI Agent Skill for Claude Code / OpenClaw, with 39 downloads so far.
How do I install Data Analytics Studio?
Run "/install data-analytics-studio" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Data Analytics Studio free?
Yes, Data Analytics Studio is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does Data Analytics Studio support?
Data Analytics Studio is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Data Analytics Studio?
It is built and maintained by ai-gaoqian (@ai-gaoqian); the current version is v1.0.0.
More Skills