跳至正文
OpenAgentSkill
浏览已开放 · 目录记录日期 2026-11-21 · 自动更新和账户服务暂时关闭。
数据与分析

data-analysis

Profile and aggregate a bundled sales dataset - group revenue by region, category, channel or month, apply filters, and compute sums, means, medians and ranges. Use for questions about sales figures, trends, or which segments perform best.

DougTrajano · 已有 AI 审核记录

安装与使用

运行命令前先阅读来源与依赖说明。复制命令不会自动安装或执行。

npx skills add DougTrajano/pydantic-ai-skills --skill data-analysis

技能说明


name: data-analysis description: Profile and aggregate a bundled sales dataset - group revenue by region, category, channel or month, apply filters, and compute sums, means, medians and ranges. Use for questions about sales figures, trends, or which segments perform best. compatibility: Standard library only, no network - runs unchanged on the host or inside a sandbox executor

Data Analysis Skill

Answers questions about a bundled sales dataset (resources/sales.csv): 96 rows covering six months, four regions, four product categories and three sales channels.

This is the reference skill for exercising sandbox executors. Both scripts are standard library only and read their data from the skill folder, so they do real work with no network, no third-party packages and no host access — exactly the shape a sandbox is meant to run.

When to Use This Skill

  • "Which region had the highest revenue?" → aggregate
  • "What were average units sold per category?" → aggregate
  • "How many rows are in the dataset and what does revenue look like?" → profile_dataset
  • "Compare online versus retail sales in the north" → aggregate with filters

Skill Scripts

profile_dataset

Reports dataset shape, column names, summary statistics for every numeric column (count, sum, mean, median, stdev, min, max) and distinct-value counts for the categorical ones.

  • column (optional): Profile a single numeric column instead of all of them

Exits 2 for an unknown column.

aggregate

Groups rows and aggregates a numeric column, optionally filtered and truncated.

  • group-by (required): Column to group by — month, region, category, channel
  • metric (optional): Numeric column to aggregate, default revenue
  • agg (optional): sum (default), mean, median, min, max, count
  • where (optional, repeatable): Filter as column=value, e.g. region=north
  • top (optional): Keep only the highest N groups

Exits 2 for an unknown column or malformed filter, 1 when no rows match.

Usage Examples

Revenue by region, highest first:

  • group-by: region

Top 3 categories by units sold, online only:

  • group-by: category
  • metric: units
  • agg: sum
  • where: channel=online
  • top: 3

Average revenue per month in the west:

  • group-by: month
  • agg: mean
  • where: region=west

Data Source

resources/sales.csv is generated sample data, included so the skill is self-contained and deterministic. It is not real sales data.

Sandbox Behaviour

Both scripts produce byte-identical output on the host and under LocalSandboxScriptExecutor or OpenSandboxScriptExecutor, including the ../resources/sales.csv read through the skill root and non-zero exit codes for bad arguments. That equivalence is the point: swapping the executor changes where the script runs, not what the model sees.