pivot-table-generator
从CSV/Excel生成包含聚合、筛选和自动图表创建的透视表。
📖 中文导读:从CSV/Excel生成包含聚合、筛选和自动图表创建的透视表。 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。
name: pivot-table-generator description: Generate pivot tables from CSV/Excel with aggregations, filters, and automatic chart creation.
Pivot Table Generator
Create pivot tables with aggregations and visualizations.
Features
- Multiple Aggregations: Sum, mean, count, min, max
- Filtering: Filter data before pivoting
- Grouping: Multi-level row/column grouping
- Charts: Auto-generate pivot charts
- Export: Excel, CSV, HTML output
CLI Usage
python pivot_table_generator.py --data sales.csv --rows region --columns product --values amount --agg sum
Dependencies
- pandas>=2.0.0
- numpy>=1.24.0
- matplotlib>=3.7.0
- openpyxl>=3.1.0