excel_analyze_dataset
Analyze Excel XLSX datasets to profile column types, missing values, numeric summaries, duplicates, outliers, top categories, and correlations without altering the file.
Instructions
Profile an XLSX dataset without changing it: column types, missing values, numeric summaries, duplicate rows, IQR outliers, top categories, and Pearson correlations. Descriptive analysis only; formulas need cached results or native recalculation.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"path": "<path>",
"sheet": "<sheet>"
},
"name": "excel_analyze_dataset"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | Absolute path or path relative to the server working directory | |
| range | No | ||
| sheet | Yes | ||
| maxRows | No | ||
| hasHeader | No | ||
| topValues | No |