Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →dougtrajano/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.
Passed 6 of 11 test cases with the skill, and 2 of 11 without it.
and 5 more in the full report
8 fixed3 passed either way11 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
One of 8 test cases the skill fixed. Same model, same prompt, with and without the skill.
Which four categorical columns in the dataset are valid targets for the group-by argument in the aggregate script?
| Checked | Without skill | With skill |
|---|---|---|
| Lists month, region, category, and channel as valid group-by target columns. | Missed | Passed |
The instructions your model reads when the skill loads.
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.
aggregateaggregateprofile_datasetaggregate with filtersReports 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 themExits 2 for an unknown column.
Groups rows and aggregates a numeric column, optionally filtered and truncated.
group-by (required): Column to group by — month, region, category, channelmetric (optional): Numeric column to aggregate, default revenueagg (optional): sum (default), mean, median, min, max, countwhere (optional, repeatable): Filter as column=value, e.g. region=northtop (optional): Keep only the highest N groupstest cases passed, vs 2 / 11 without
More skills from the same source and nearby in the registry, with their headline benchmark lift.