{"uid":"cap_NA1o_YEbi-f9nBDoPygUT","slug":"csv-column-statistics-analyzer-cbc5f0ae","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_yjgooxl2eqp4adlw?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_1WdItJJyvvzXy6l2vY_QI","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 and returns per-column statistics including type, values, empty cell count, distinct value count, and for numeric columns: min, max, mean, median, and sum.","exampleAgentPrompt":"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\"","exampleUseCases":[{"title":"Data quality audit before import","prompt":"I have a semicolon-delimited CSV with a header row and I need to know how many empty cells each column has and how many distinct values — can you profile it for me? Here's the data: \"id;name;score\\n1;Alice;88\\n2;;92\\n3;Carol;\""},{"title":"Descriptive stats for sales report","prompt":"Run column statistics on this CSV sales data — I need the min, max, mean, median, and sum for all numeric columns, plus distinct value counts for the category columns. It's comma-delimited with a header: \"region,revenue,units\\nNorth,1500,30\\nSouth,2200,45\\nNorth,900,18\""},{"title":"Detect column types in unknown dataset","prompt":"I just received a CSV file and don't know what types the columns are. Can you tell me the detected type for each column, how many unique values there are, and flag any columns with empty cells? The file uses tab as delimiter and has a header row."}],"resultDescription":"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.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-19T06:39:02.463Z","isFirstParty":false,"canonicalSlug":"csv-column-statistics-analyzer-d16905f4"}