{"uid":"cap_D8rj90149QWaGD7VbrUAF","slug":"csv-column-profiler-450c2319","name":"CSV Column Profiler","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_nmmegmfvun6cb4a7?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_0wqEnwR-d-xQig2ARgxF6","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, value counts, empty cells, distinct values, and numeric aggregates (min, max, mean, median, sum).","exampleAgentPrompt":"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.","exampleUseCases":[{"title":"Quick data quality audit","prompt":"I just exported a CSV from our database using semicolons as delimiters — can you analyze every column and tell me which ones have empty cells, what the distinct values are, and for any numeric fields give me the min, max, mean, and median?"},{"title":"Summarizing sales figures from CSV","prompt":"Here's a CSV of our monthly sales data with a header row and comma delimiters — can you compute the sum, mean, and median for all the numeric columns so I can see totals and averages at a glance?"},{"title":"Detecting column types in uploaded file","prompt":"I have a tab-delimited CSV with a header row and I need to know the inferred data type of each column, how many blank cells there are, and how many distinct values each column contains before I import it into the database."}],"resultDescription":"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.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-19T06:38:18.012Z","isFirstParty":false,"canonicalSlug":"csv-column-profiler-450c2319"}