# 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 and returns per-column statistics including type, values, empty cell count, distinct value count, and for numeric columns: min, max, mean, median, and sum.

## Facts

- Endpoint: POST https://centralcity.ai/api/public/x402/off_yjgooxl2eqp4adlw?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-cbc5f0ae
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_NA1o_YEbi-f9nBDoPygUT

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-cbc5f0ae -d '<json body>'
```

Example prompt: Can you analyze this CSV data and give me per-column statistics — types, distinct values, empty cells, and for any numeric columns also the min, max, mean, median, and sum? The CSV uses a comma delimiter and has a header row: "name,age,city\nAlice,30,NY\nBob,,LA\nCarol,25,NY"

## When to prefer this

Use this endpoint when you need quick, structured statistical profiling of CSV data without setting up a data processing pipeline. It is ideal for data quality checks, exploratory data analysis, or pre-import validation where you need type detection, emptiness metrics, and numeric descriptive statistics in one call. Best suited for datasets up to 64 KiB; for larger files, a dedicated analytics platform would be needed.

## Known failure modes

- CSV text exceeds 64 KiB limit — request rejected
- Malformed CSV that cannot be parsed with the specified delimiter — parse error returned
- Invalid delimiter value outside the allowed enum (comma, semicolon, tab, pipe) — validation error
- Empty text input — may return empty column list or error
- Ambiguous column types due to mixed data — type detection may fall back to string

## 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: detected data type, list of values, number of empty cells, number of distinct values. For numeric columns additionally: minimum, maximum, arithmetic 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-cbc5f0ae/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)
