Individual skill
evo-sales-pivot-analysis
End-to-end demographic analysis pipeline that extracts population data from PDF, reads income data from Excel, merges datasets, computes range-based income quartiles, generates four openpyxl pivot table objects, and exports a five-sheet Excel workbook.
tasks-evolved/sales-pivot-analysis/environment/skills/evo-sales-pivot-analysis/SKILL.md
Source commit 84ca182da055fafb6453dcec4a6defdbbfd987c1
What was checked
- Matches the observed repository HEAD
- Yes
- Scanner rules are current
- Yes
- Repository scan complete
- No
- Skill scan complete
- No
- Observed behavior
- Local scripts
- Last checked
- Nov 6, 2026
These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.
Install this skill
Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.
An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.
Repository context
- Repository stars (not skill ratings)
- 97
- Repository last updated
- Sep 10, 2026
- License
- Apache-2.0
Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.
- agent-skills Repository topic
- ai-agents Repository topic
- llm-agents Repository topic
- open-world Repository topic
- self-evolving-agents Repository topic
- sales Derived category
- data Derived category
- testing Derived category
- testing-browser Derived category
Files and excerpt
File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.
Browse files
SKILL.mdcore · 2,820 bytesSKILL.mdcore · 2,820 bytesSKILL.mdcore · 2,820 bytesscripts/run_pipeline.pyruns · 21,806 bytes
Read excerpt
# evo-sales-pivot-analysis
Complete pipeline for demographic data analysis: extracts population data from multi-page PDF tables,
ingests income data from Excel, merges on SA2_CODE, computes range-based quartile classifications and
derived columns, builds **native openpyxl pivot table objects**, and exports a multi-sheet Excel report.
## CRITICAL: Native Pivot Tables Required
The output Excel file MUST contain **actual Excel pivot table objects** (not flat summary tables).
The verifier checks `worksheet._pivots[0]` — pandas `.to_excel()` does NOT create these.
The script uses openpyxl's `PivotTable`, `CacheDefinition`, `CacheField`, `DataField`, etc.
## Pipeline Steps
