{"uid":"cap_x3YUOm0RdbeXQprjfCo0O","slug":"24k-labs-csv-profile-4ec6b9d7","name":"24K Labs CSV Profile","description":"Column-level statistics for a CSV: inferred type, count, null count, distinct count, min/max/mean for numeric columns, and sample values. One-call data audit.","url":"https://api.24klabs.ai/api/csv-profile","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"csv":{"type":"string"}}},"responseSchema":{"type":"json","example":{"rows":3,"columns":[{"name":"price","type":"number"}]}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.005","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.005/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.005","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.005","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_NlJrTj2SWO53sLvg_VetG","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.005","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Profiles a CSV file and returns column-level statistics including inferred type, count, null count, distinct count, min/max/mean for numeric columns, and sample values.","exampleAgentPrompt":"Can you profile this CSV file for me and tell me each column's data type, how many nulls there are, distinct value counts, and the min/max/mean for any numeric columns?","exampleUseCases":[{"title":"Pre-processing data quality audit","prompt":"I have a CSV with customer records — can you run a full column-level profile on it so I can see which columns have nulls, what types were inferred, and what the value ranges look like before I import it into the database?"},{"title":"Quick dataset exploration before ML training","prompt":"Before I start building a model, can you profile this CSV training dataset and give me the stats for each column — types, null counts, distinct counts, and numeric summaries like min, max, and mean?"},{"title":"Validating a vendor-supplied data file","prompt":"A vendor sent us a CSV export — can you audit it column by column and tell me if there are any unexpected nulls, what data types each column has, and show some sample values so I can verify it looks right?"}],"resultDescription":"Returns a JSON object with per-column statistics including: inferred data type, total count, null count, distinct count, min and max values, mean (for numeric columns), and a list of sample values drawn from the column.","failureModes":["Malformed or unparseable CSV returns an error indicating the file could not be processed","Empty CSV file results in an empty statistics object or error","Very large CSV files may time out or be rejected if they exceed size limits","Non-CSV content (e.g. JSON or binary) passed as input returns a parse error","Missing or invalid payment header returns a 402 Payment Required response"],"whenToPreferThis":"Choose this endpoint when you need a fast, one-call statistical audit of a CSV file — especially when you want column-level type inference, null/distinct counts, and numeric min/max/mean without writing custom data-profiling code. It is ideal for pre-processing validation, quick dataset exploration, and data quality checks before ETL pipelines or ML workflows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-13T18:55:09.541Z","isFirstParty":false}