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 |
Input Schema (JSON Schema)
{
"properties": {
"agg_func": {
"default": "mean",
"title": "Agg Func",
"type": "string"
},
"columns": {
"anyOf": [
{
"items": {
"type": "string"
},
"type": "array"
},
{
"type": "null"
}
],
"default": null,
"title": "Columns"
},
"data_range": {
"title": "Data Range",
"type": "string"
},
"filepath": {
"title": "Filepath",
"type": "string"
},
"rows": {
"items": {
"type": "string"
},
"title": "Rows",
"type": "array"
},
"sheet_name": {
"title": "Sheet Name",
"type": "string"
},
"values": {
"items": {
"type": "string"
},
"title": "Values",
"type": "array"
}
},
"required": [
"filepath",
"sheet_name",
"data_range",
"rows",
"values"
],
"title": "create_pivot_tableArguments",
"type": "object"
}