mcpField
P
pivot-table-generator

pivot-table-generator

github.com/dkyazzentwatwaData & databases12454 installsUpdated 29w ago
Repository

About pivot-table-generator

A pivot-table generation skill for people analyzing tabular data. It supports filtering, grouped aggregations, automatic charts, and export to Excel, CSV, or HTML.

Key features

  1. 01Sum, mean, count, min, and max
  2. 02Filter data before pivoting
  3. 03Multi-level row and column groups
  4. 04Automatic pivot charts
  5. 05Excel, CSV, and HTML export

Use cases

  1. 01Summarize sales by region and product
  2. 02Filter records before aggregation
  3. 03Visualize pivot-table results
  4. 04Export summaries for sharing

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/dkyazzentwatwa/chatgpt-skills --skill pivot-table-generator

After installing, type/pivot-table-generatorin Claude Code to confirm it loaded.

Bundled filesscripts/pivot_table_generator.pyscripts/requirements.txt

Details

From the project README

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

Comments

Markdown supported