column_statistics
Compute descriptive statistics for a numeric column in an Excel workbook, providing mean, median, standard deviation, min, max, and sum.
Instructions
Compute descriptive statistics for a numeric column (mean, median, std, min, max, sum).
Args: file_path: Workbook path. sheet_name: Worksheet name. column: Column name or letter to analyse. has_header: Whether the sheet has a header row.
Returns: ColumnStats: Pydantic model with statistical measures.
Notes: - Read-only.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| column | Yes | ||
| file_path | Yes | ||
| has_header | No | ||
| sheet_name | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| std | No | Standard deviation, or None if unavailable. | |
| mean | No | Arithmetic mean, or None if unavailable. | |
| count | Yes | Number of non-empty numeric values. | |
| column | Yes | Column letter or header name. | |
| median | No | Median value, or None if unavailable. | |
| max_val | No | Maximum value, or None if unavailable. | |
| message | No | Informational message, e.g. when column is non-numeric. | |
| min_val | No | Minimum value, or None if unavailable. | |
| sum_val | No | Sum of values, or None if unavailable. | |
| kurtosis | No | Kurtosis of the distribution, or None if insufficient data. | |
| skewness | No | Skewness of the distribution, or None if insufficient data. |