跳到主内容
智客 ZICQ

技能库 智客分类:文档办公 Data Analysis OpenClaw

Data Analysis

数据分析与可视化. 查询数据库,生成报告,实现电子表格自动化,并将原始数据转化为清晰,可操作的见解. 当 (1) 需要分析,可视化,或解释数据时使用; (2) 用户希望将报告,仪表板,或度量表转化为决定; (3) 工作涉及SQL, Python,电子表格,BI工具,或笔记本; (4) 需要比较分块,组分,漏斗,实验,或时间段; (5) 用户明确安装或引用当前任务的技能.

1244 安装量 · 129 星标

官方网址:作者主页

技能介绍

先看中文介绍;官方 description 原文单独保留,不改写 SKILL.md。

做什么

数据分析与可视化. 查询数据库,生成报告,实现电子表格自动化,并将原始数据转化为清晰、可操作的见解

何时用

当用户需要分析、解释或可视化来自SQL、电子表格、笔记本、仪表板、导出或特设表格的数据时使用这一技能

代理如何加载

按 Agent Skills 渐进披露:启动时只加载 name 与 description(约 100 token);任务匹配后才读入整份 SKILL.md 正文;scripts/、references/、assets/ 仅在需要时再读。 本文件正文结构:When to Use、Core Principle、Methodology First、Statistical Rigor Checklist、Architecture、Quick Reference。

文件分析

文件分析:这是一份仅含 SKILL.md 的指令型技能,代理激活后整份正文进入上下文。

官方 description(原文)

Data analysis and visualization. Query databases, generate reports, automate spreadsheets, and turn raw data into clear, actionable insights. Use when (1) you need to analyze, visualize, or explain data; (2) the user wants reports, dashboards, or metrics turned into a decision; (3) the work involves SQL, Python, spreadsheets, BI tools, or notebooks; (4) you need to compare segments, cohorts, funnels, experiments, or time periods; (5) the user explicitly installs or references the skill for the current task.

When to UseCore PrincipleMethodology FirstStatistical Rigor ChecklistArchitectureQuick ReferenceCore Rules1. Start from the decision, not the dataset2. Lock the metric contract before calculating3. Separate extraction, transformation, and interpretation4. Choose visuals to answer a question5. Brief every result in decision format

来源分类:ClawHub Data Analysis

SKILL.md 与 Agent 调用

官方规范 ↗
name
Data Analysis
description
Data analysis and visualization. Query databases, generate reports, automate spreadsheets, and turn raw data into clear, actionable insights. Use when (1) you need to analyze, visualize, or explain data; (2) the user wants reports, dashboards, or metrics turned into a decision; (3) the work involves SQL, Python, spreadsheets, BI tools, or notebooks; (4) you need to compare segments, cohorts, funnels, experiments, or time periods; (5) the user explicitly installs or references the skill for the current task.
  1. 发现技能客户端向 Agent 提供名称与描述目录。
  2. 匹配与调用用户指定或任务匹配后,载入 SKILL.md 指令。
  3. 按需加载按步骤读取参考文档、使用脚本与素材。

具体调用语法与可用工具以目标 Agent 客户端为准。 查看调用机制说明 ↗

安装这个技能

Skills CLI ↗

先选择目标 Agent 和安装范围,保留技能包的附属文件,安装后检查客户端能否发现该技能。

交给 Agent 安装

复制安装指令给支持 Agent Skills 的代理,确认其中的目标目录与客户端匹配。

把 Agent Skill「Data Analysis」安装到我的项目:SKILL.md 原文与官方 description 见 https://zicq.com/zh/skills/skl-b674892107d59699-%E6%95%B0%E6%8D%AE%E5%88%86%E6%9E%90.html
请存为 .cursor/skills/data-analysis/SKILL.md 或 .claude/skills/data-analysis/SKILL.md,frontmatter 的 name 与 description 保持原样,不要改写。

当前没有明确的 GitHub 技能包地址,请按来源页面的安装器说明操作。

ClawHub ↗

阅读排版
--- name: Data Analysis slug: data-analysis version: 1.0.2 homepage: https://clawic.com/skills/data-analysis description: "Data analysis and visualization. Query databases, generate reports, automate spreadsheets, and turn raw data into clear, actionable insights. Use when (1) you need to analyze, visualize, or explain data; (2) the user wants reports, dashboards, or metrics turned into a decision; (3) the work involves SQL, Python, spreadsheets, BI tools, or notebooks; (4) you need to compare segments, cohorts, funnels, experiments, or time periods; (5) the user explicitly installs or references the skill for the current task." changelog: Added metric contracts, chart guidance, and decision brief templates for more reliable analysis. metadata: {"clawdbot":{"emoji":"D","requires":{"bins":[]},"os":["linux","darwin","win32"]}} --- ## When to Use Use this skill when the user needs to analyze, explain, or visualize data from SQL, spreadsheets, notebooks, dashboards, exports, or ad hoc tables. Use it for KPI debugging, experiment readouts, funnel or cohort analysis, anomaly reviews, executive reporting, and quality checks on metrics or query logic. Prefer this skill over generic coding or spreadsheet help when the hard part is analytical judgment: metric definition, comparison design, interpretation, or recommendation. User asks about: analyzing data, finding patterns, understanding metrics, testing hypotheses, cohort analysis, A/B testing, churn analysis, or statistical significance. ## Core Principle Analysis without a decision is just arithmetic. Always clarify: **What would change if this analysis shows X vs Y?** ## Methodology First Before touching data: 1. **What decision** is this analysis supporting? 2. **What would change your mind?** (the real question) 3. **What data do you actually have** vs what you wish you had? 4. **What timeframe** is relevant? ## Statistical Rigor Checklist - [ ] Sample size sufficient? (small N = wide confidence intervals) - [ ] Comparison groups fair? (same time period, similar conditions) - [ ] Multiple comparisons? (20 tests = 1 "significant" by chance) - [ ] Effect size meaningful? (statistically significant != practically important) - [ ] Uncertainty quantified? ("12-18% lift" not just "15% lift") ## Architecture This skill does not require local folders, persistent memory, or setup state. Use the included reference files as lightweight guides: - `metric-contracts.md` for KPI definitions and caveats - `chart-selection.md` for visual choice and chart anti-patterns - `decision-briefs.md` for stakeholder-facing outputs - `pitfalls.md` and `techniques.md` for analytical rigor and method choice ## Quick Reference Load only the smallest relevant file to keep context focused. | Topic | File | |-------|------| | Metric definition contracts | `metric-contracts.md` | | Visual selection and chart anti-patterns | `chart-selection.md` | | Decision-ready output formats | `decision-briefs.md` | | Failure modes to catch early | `pitfalls.md` | | Method selection by question type | `techniques.md` | ## Core Rules ### 1. Start from the decision, not the dataset - Identify the decision owner, the question that could change a decision, and the deadline before doing analysis. - If no decision would change, reframe the request before computing anything. ### 2. Lock the metric contract before calculating - Define entity, grain, numerator, denominator, time window, timezone, filters, exclusions, and source of truth. - If any of those are ambiguous, state the ambiguity explicitly before presenting results. ### 3. Separate extraction, transformation, and interpretation - Keep query logic, cleanup assumptions, and analytical conclusions distinguishable. - Never hide business assumptions inside SQL, formulas, or notebook code without naming them in the write-up. ### 4. Choose visuals to answer a question - Select charts based on the analytical question: trend, comparison, distribution, relationship, composition, funnel, or cohort retention. - Do not add charts that make the deck look fuller but do not change the decision. ### 5. Brief every result in decision format - Every output should include the answer, evidence, confidence, caveats, and recommended next action. - If the output is going to a stakeholder, translate the method into business implications instead of leading with technical detail. ### 6. Stress-test claims before recommending action - Segment by obvious confounders, compare the right baseline, quantify uncertainty, and check sensitivity to exclusions or time windows. - Strong-looking numbers without robustness checks are not decision-ready. ### 7. Escalate when the data cannot support the claim - Block or downgrade conclusions when sample size is weak, the source is unreliable, definitions drifted, or confounding is unresolved. - It is better to say "unknown yet" than to produce false confidence. ## Common Traps - Reusing a KPI name after changing numerator, denominator, or exclusions -> trend comparisons become invalid. - Comparing daily, weekly, and monthly grains in one chart -> movement looks real but is mostly aggregation noise. - Showing percentages without underlying counts -> leadership overreacts to tiny denominators. - Using a pretty chart instead of the right chart -> the output looks polished but hides the actual decision signal. - Hunting for interesting cuts after seeing the result -> narrative follows chance instead of evidence. - Shipping automated reports without metric owners or caveats -> bad numbers spread faster than they can be corrected. - Treating observational patterns as causal proof -> action plans get built on correlation alone. ## Approach Selection | Question type | Approach | Key output | |---------------|----------|------------| | "Is X different from Y?" | Hypothesis test | p-value + effect size + CI | | "What predicts Z?" | Regression/correlation | Coefficients + R² + residual check | | "How do users behave over time?" | Cohort analysis | Retention curves by cohort | | "Are these groups different?" | Segmentation | Profiles + statistical comparison | | "What's unusual?" | Anomaly detection | Flagged points + context | For technique details and when to use each, see `techniques.md`. ## Output Standards 1. **Lead with the insight**, not the methodology 2. **Quantify uncertainty** - ranges, not point estimates 3. **State limitations** - what this analysis can't tell you 4. **Recommend next steps** - what would strengthen the conclusion ## Red Flags to Escalate - User wants to "prove" a predetermined conclusion - Sample size too small for reliable inference - Data quality issues that invalidate analysis - Confounders that can't be controlled for ## External Endpoints This skill makes no external network requests. | Endpoint | Data Sent | Purpose | |----------|-----------|---------| | None | None | N/A | No data is sent externally. ## Security & Privacy Data that leaves your machine: - Nothing by default. Data that stays local: - Nothing by default. This skill does NOT: - Access undeclared external endpoints. - Store credentials or raw exports in hidden local memory files. - Create or depend on local folder systems for persistence. - Create automations or background jobs without explicit user confirmation. - Rewrite its own instruction source files. ## Related Skills Install with `clawhub install ` if user confirms: - `sql` - query design and review for reliable data extraction. - `csv` - cleanup and normalization for tabular inputs before analysis. - `dashboard` - implementation patterns for KPI visualization layers. - `report` - structured stakeholder-facing deliverables after analysis. - `business-intelligence` - KPI systems and operating cadence beyond one-off analysis. ## Feedback - If useful: `clawhub star data-analysis` - Stay updated: `clawhub sync`

相关技能

文档办公

Ontology

为结构化的代理内存和可堆肥技能所打入的知识图. 在创建/征服实体(Person, project, Task, Evention, Document)时使用,链接相关对象,强制约束,规划多步动作作为图变,或技能需要共享状态时使用. 触发到"记住","我知道什么","链接X到Y",…

文档办公

Nano Pdf

使用纳米-pdf CLI编辑带有自然语言指令的PDF.

文档办公

Word / DOCX

创建,检查,并编辑有可靠样式的Microsoft Word文档和DOCX文件,编号,跟踪更改,表格,章节,并进行相容性检查. 当 (1) 任务涉及 Word 或 ".docx " 时使用; (2) 文件包括跟踪的更改,评论,字段,表格,模板,或页面布局限制; (3) 文档必须在不…

文档办公

Api Gateway

通过 Maton 网关调用第三方 API, 它为用户已经连接的应用程序注入证书 。 当用户命名一个连接的应用程序和其中的具体行动时使用此技能——读取一个邮箱,查询一个CMM,归档一个问题,更新一个电子表格,通过一个连接的搜索或刮取提供者运行一个查询. 每一次通话都到用户连接的应用…