# CSV Column Statistics Analyzer

> CSV Column Statistics Analyzer is a paid API for AI agents from centralcity.ai, paid per call via x402, $0.05/call, status unknown (last checked 2026-11-19).

Analyzes a CSV text column by column, returning type, value samples, empty cell counts, distinct value counts, and for numeric columns also min, max, mean, median, and sum.

## Facts

- Endpoint: POST https://centralcity.ai/api/public/x402/off_j7lqjismjc4weirm?utm_source=zero.xyz
- Price: $0.05/call
- Payment: x402
- Status: unknown
- Last checked: 2026-11-19
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/csv-column-statistics-analyzer-d16905f4
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_SXmHKtTqDUZQWW8SPt9Oc

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability csv-column-statistics-analyzer-d16905f4 -d '<json body>'
```

Example prompt: Can you profile this CSV data for me — it uses semicolons as delimiters and has a header row — and tell me the type, distinct values, empty cells, and numeric stats (min, max, mean, median, sum) for each column?

## When to prefer this

Use this endpoint when you need a fast, per-column statistical profile of a CSV dataset without setting up a data processing pipeline. It is ideal for data quality checks, schema inference, and exploratory data analysis on small-to-medium CSVs (up to 64 KiB). It handles comma, semicolon, tab, and pipe delimiters natively and optionally treats the first row as headers.

## Known failure modes

- CSV text exceeds 64 KiB limit — request rejected
- Malformed CSV that cannot be parsed with the specified delimiter — parsing error returned
- Invalid delimiter value outside the allowed enum — validation error
- Empty text input — no columns to analyze

## How this service works

Per column of a CSV text: its type, values, empty cells and distinct values; for numbers also min, max, mean, median and sum.

## Output

A per-column breakdown including: inferred data type, sample values, count of empty cells, count of distinct values, and for numeric columns the minimum, maximum, mean, median, and sum.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "text": {
   "type": "string",
   "description": "The CSV text, at most 64 KiB."
  },
  "header": {
   "type": "boolean",
   "description": "Whether the first row names the columns (default true)."
  },
  "delimiter": {
   "enum": [
    ",",
    ";",
    "\t",
    "|"
   ],
   "type": "string",
   "description": "The field delimiter: a comma (default), a semicolon, a tab (\\t) or a pipe."
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/csv-column-statistics-analyzer-d16905f4/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from centralcity.ai](https://www.zero.xyz/host/centralcity.ai/llms.txt)
