pivot-table-generator

Generate pivot tables from CSV/Excel with aggregations, filters, and automatic chart creation.

⭐1stars🔀0forks📁View on GitHub🕐Updated Dec 17, 2025⬇️2downloads

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.
namepivot-table-generator
descriptionGenerate 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