# CSV Column Profiler

> CSV Column Profiler 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, value counts, empty cells, distinct values, and numeric aggregates (min, max, mean, median, sum).

## Facts

- Endpoint: POST https://centralcity.ai/api/public/x402/off_nmmegmfvun6cb4a7?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-profiler-450c2319
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_D8rj90149QWaGD7VbrUAF

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-profiler-450c2319 -d '<json body>'
```

Example prompt: Can you profile all the columns in this CSV for me — I need each column's data type, number of empty cells, distinct values, and for any numeric columns also the min, max, mean, median, and sum? The file uses a semicolon delimiter and has a header row.

## When to prefer this

Use this endpoint when you need a fast, structured statistical profile of a CSV dataset — especially when you want per-column type inference, emptiness counts, distinct value counts, and numeric aggregates (min/max/mean/median/sum) in a single call. Ideal for data quality checks, pre-import validation, and exploratory data analysis on files up to 64 KiB.

## Known failure modes

- CSV text exceeds 64 KiB limit — request rejected
- Malformed CSV that cannot be parsed — error returned
- Unsupported delimiter character — validation error
- Empty CSV text — empty or error response
- Incorrect header flag causes misinterpretation of first row as data

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

Returns per-column profile data: inferred type, list of values, count of empty cells, count of distinct values; for numeric columns also min, max, 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-profiler-450c2319/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)
