pivot-table-generator
Generate pivot tables from CSV/Excel with aggregations, filters, and automatic chart creation.
When & Why to Use This Skill
The Pivot Table Generator is a powerful Claude skill designed to automate complex data analysis by transforming raw CSV and Excel files into structured pivot tables. It streamlines the data processing workflow by offering multi-level grouping, diverse aggregation methods, and instant visualization through automatic chart creation, making it an essential tool for data-driven decision-making.
Use Cases
- Sales Performance Analysis: Automatically aggregate total revenue and volume by region and product line to identify key growth drivers.
- Financial Reporting: Transform raw transaction logs into summarized monthly expense reports with custom filters for departmental budgeting.
- Inventory Management: Group warehouse data by category and status to visualize stock levels and optimize supply chain efficiency.
- Marketing Campaign Evaluation: Pivot lead generation data to compare conversion rates across different channels and time periods.
| 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