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.
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 |