Community研究与数据分析github.com

claude-office-skills/data-analysis

分析电子表格数据,生成洞察,创建可视化,并根据 Excel/CSV 数据构建报告。

data-analysis 是什么?

该技能专门用于分析和处理电子表格数据(如 Excel 和 CSV 文件),使 AI 代理能够高效地从结构化数据中提取洞察。它支持数据清理、统计摘要、趋势识别和可视化生成,帮助用户快速理解数据模式。该技能兼容 Claude Code、Coder 和 Cursor 等主流 AI 代理平台,通过简洁的 API 交互实现自动化报告构建。用户只需提供文件路径或数据源,即可获得包含图表的分析结果,适用于商业报告、市场研究和科学数据分析等场景。

兼容平台✓Claude Code~Codex CLI~Cursor
npx skills add https://github.com/claude-office-skills/skills/tree/main/skills/data-analysis

Installed? Explore more 研究与数据分析 skills: affaan-m/uspto-database, affaan-m/scholar-evaluation, affaan-m/literature-review · View all 6 →

在你喜欢的 AI 中提问

打开一个已预加载此 Agent Skill 的新对话。

文档

data-analysis 是做什么的?

分析电子表格数据,生成洞察,创建可视化,并根据 Excel/CSV 数据构建报告。

功能

  • 读取并解析 Excel(.xlsx, .xls)和 CSV 文件
  • 数据清洗和预处理(处理缺失值、数据类型转换)
  • 生成统计摘要(均值、中位数、标准差、分布)
  • 识别趋势和异常值
  • 生成图表(折线图、柱状图、散点图等)
  • 导出格式化报告(Markdown、HTML 或 PDF)

使用方法

基本用法

from data_analysis import analyze_spreadsheet

# 分析 CSV 文件
results = analyze_spreadsheet("sales_data.csv")

# 分析 Excel 文件
results = analyze_spreadsheet("financial_report.xlsx")

可配置选项

  • --input: 输入文件路径(必需)
  • --output: 输出报告路径(可选,默认生成到当前目录)
  • --viz: 可视化类型(可选,如 bar, line, scatter)
  • --summary: 仅生成摘要(可选,不生成可视化)

示例

分析销售数据

analyze --input sales.csv --output sales_report.md --viz bar

这将生成一个包含柱状图的 Markdown 分析报告。

快速摘要

analyze --input data.csv --summary

仅输出统计摘要到控制台。

支持的文件格式

  • .csv: 逗号分隔文件
  • .xlsx: Excel 工作簿
  • .xls: 旧版 Excel 文件
  • .tsv: 制表符分隔文件

输出示例

分析完成后,你将获得:

  1. 数据摘要:行数、列数、数据类型、缺失值统计
  2. 统计指标:均值、中位数、标准差、分位数
  3. 可视化:嵌入的图表(如适用)
  4. 洞察:突出显示的关键趋势和异常值

注意事项

  • 大型文件可能需要较长时间处理
  • 可视化需安装 matplotlib 或 plotly 库
  • 文件编码默认使用 UTF-8,如有需要可指定 --encoding 参数

Individual skills in this repo

This repo contains 20 individual skills — each has its own dedicated page.

claude-office-skills/academic-search

Search and analyze academic literature. Find papers, understand research methodologies, and synthesize academic findings for research projects.

claude-office-skills/ads-copywriter

Multi-platform ad copy generation for Google Ads, Meta/Facebook, TikTok, LinkedIn with A/B testing variants

claude-office-skills/ai-agent-builder

Build AI agents with tools, memory, and multi-step reasoning - ChatGPT, Claude, Gemini integration patterns

claude-office-skills/airtable-automation

Airtable database automation - views, automations, integrations, and workflow triggers

claude-office-skills/ai-slides

Generate complete presentations with AI - from outline to polished slides

claude-office-skills/amazon-seller

Automate Amazon seller operations including inventory, orders, pricing, and advertising management

claude-office-skills/apple-shortcuts-integration

Create and trigger Apple Shortcuts for iOS/macOS automation and cross-platform workflows

claude-office-skills/applicant-screening

Screen job applications against requirements and score candidates

claude-office-skills/asana-automation

Automate Asana project management workflows, task tracking, team collaboration, and reporting

claude-office-skills/batch-convert

Batch convert documents between multiple formats using a unified pipeline

claude-office-skills/batch-processor

Process multiple documents in bulk with parallel execution

claude-office-skills/brand-guidelines-generator

Create and maintain brand style guides for consistent visual identity

claude-office-skills/browser-automation

Automate web browser interactions, scraping, testing, and workflow automation with Puppeteer/Playwright

claude-office-skills/calendar-automation

Google Calendar and Outlook automation - scheduling optimization, meeting workflows, time blocking, and Slack/Sheets integration

claude-office-skills/changelog-generator

Generate release notes from git commits, updates, or feature lists

claude-office-skills/chart-designer

Design effective data visualizations and charts. Generate chart configurations for ECharts, Chart.js, and other libraries. Create dashboards and reports.

claude-office-skills/chat-with-pdf

Answer questions about PDF content, summarize, and extract information

claude-office-skills/clickup-automation

Automate ClickUp workspace management, task workflows, time tracking, and team productivity

claude-office-skills/company-research

Conduct comprehensive company research and due diligence. Analyze business model, competitive landscape, management, and market position.

claude-office-skills/competitive-analysis

Analyze competitors systematically. Compare products, features, pricing, positioning, and market strategies. Generate comprehensive competitive intelligence reports.

相关技能