{"uid":"cap_SXmHKtTqDUZQWW8SPt9Oc","slug":"csv-column-statistics-analyzer-d16905f4","name":"CSV Column Statistics Analyzer","description":"Per column of a CSV text: its type, values, empty cells and distinct values; for numbers also min, max, mean, median and sum.","url":"https://centralcity.ai/api/public/x402/off_j7lqjismjc4weirm?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"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."}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.05","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.05/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.05","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.05","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_fUkwkRYa32CvNnxprjut3","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.05","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"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.","exampleAgentPrompt":"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?","exampleUseCases":[{"title":"Quick data quality check on upload","prompt":"I just exported a dataset as a comma-separated CSV with headers. Can you analyze each column and tell me how many empty cells there are, how many distinct values, and the min/max/mean for any numeric columns?"},{"title":"Profiling tab-delimited survey results","prompt":"Here's my survey export — it's tab-delimited with a header row. Can you break it down column by column and tell me the data types, distinct values, and descriptive statistics like median and sum for the numeric fields?"},{"title":"Detecting schema issues in a pipe-delimited file","prompt":"I have a pipe-delimited CSV without a header row and I want to know the inferred type of each column, how many empty cells each has, and the range of values — especially min and max for any numbers."}],"resultDescription":"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.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-19T06:41:05.853Z","isFirstParty":false,"canonicalSlug":"csv-column-statistics-analyzer-d16905f4"}