返回 Skill 列表
extension
分类: 开发与工程无需 API Key

pivot-table-generator

从CSV/Excel生成带有聚合、过滤和自动图表创建的数据透视表。

person作者: jakexiaohubgithub

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