quantiles_resource
Compute percentile distributions (p25/p50/p75/p90/p95/p99) of numeric columns from CSV, TSV, XLSX, or JSON files. Supports filters and customizable percentiles for salary analysis, budget distributions, and statistical profiling.
Instructions
Percentile distribution (p25/p50/p75/p90/p95/p99) of numeric columns.
Fills the gap left by aggregate_resource, which only exposes median. First call downloads + caches the file. Subsequent calls reuse the cache. Useful for salary analysis, budget distributions, and statistical profiling.
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": {
"url": "<url>",
"format": "<format>"
},
"name": "quantiles_resource"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| url | Yes | Direct URL to the file (CKAN resource 'url' field). | |
| format | Yes | Format declared in CKAN. Accepts: csv, tsv, xlsx, json. | |
| columns | No | Numeric columns to analyze. None = all numeric columns. | |
| percentiles | No | Percentiles to compute (0–1 exclusive). Default: [0.25, 0.5, 0.75, 0.90, 0.95, 0.99]. | |
| filters | No | Same filter syntax as filter_resource. Applied before computing. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| error | No | ||
| hint | No | ||
| source_url | No | ||
| format | No | ||
| cache | No | ||
| row_count | No | ||
| percentiles | No | ||
| columns | No |