pivot_table
Create pivot tables to group and aggregate data from Excel or CSV files. Use this tool to summarize information by categories and calculate totals, averages, counts, minimums, or maximums.
Instructions
Create pivot table with grouping and aggregation
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| filePath | Yes | Path to the CSV or Excel file | |
| groupBy | Yes | Column to group by | |
| aggregateColumn | Yes | Column to aggregate | |
| operation | Yes | Aggregation operation | |
| sheet | No | Sheet name for Excel files (optional) |