aggregate
Calculate sum, average, count, min, or max values from a column in Excel or CSV files to analyze data patterns and extract key metrics.
Instructions
Perform aggregation operations on a column
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| filePath | Yes | Path to the CSV or Excel file | |
| column | Yes | Column name or index (0-based) | |
| operation | Yes | Aggregation operation | |
| sheet | No | Sheet name for Excel files (optional) |