create_pivot_table
Generate pivot tables in Excel worksheets to organize, summarize, and analyze large datasets by specifying rows, columns, values, and aggregation functions.
Instructions
Create pivot table in worksheet.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| agg_func | No | mean | |
| columns | No | ||
| data_range | Yes | ||
| filepath | Yes | ||
| rows | Yes | ||
| sheet_name | Yes | ||
| values | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |