{"uid":"cap_47b9dlGa41tg48KQk7SNe","slug":"fittings-column-profile-0bc3167d","name":"fittings Column Profile","description":"Per-column profile of a CSV or NDJSON payload: null rate, cardinality, inferred type, numeric range, mean, standard deviation and most frequent values.","url":"https://fittings.sh/v1/data/column-profile","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"data":{"type":"string","description":"CSV or NDJSON, up to 5000000 characters, 100000 rows, 256 columns and 1000000 cells"},"format":{"type":"string","description":"'csv' (default) or 'ndjson'"},"delimiter":{"type":"string","description":"CSV only. Single character, defaults to comma"}}},"responseSchema":null,"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_O_txwvzfg5ksTP2PGzpko","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":"Computes a per-column statistical profile (null rate, cardinality, inferred type, numeric range, mean, std dev, top values) for a CSV or NDJSON dataset.","exampleAgentPrompt":"Can you profile all the columns in this CSV for me — I need to know the null rate, cardinality, data types, numeric ranges, and the top most-frequent values for each field?","exampleUseCases":[{"title":"Data quality audit before pipeline ingestion","prompt":"Before I load this CSV into the database, can you run a column profile on it so I can see which columns have high null rates, what the inferred types are, and whether any numeric columns have suspicious ranges?"},{"title":"Exploratory analysis of an NDJSON log export","prompt":"I've got an NDJSON export of server logs — can you profile each field and tell me the cardinality, most frequent values, and any nulls so I understand what's in there before I start querying it?"},{"title":"Detecting schema drift in a delivered data file","prompt":"I just received a monthly data file from our vendor as a CSV — can you profile every column and tell me the inferred types, null rates, and top values so I can spot anything that looks off compared to last month?"}],"resultDescription":"A per-column breakdown containing: inferred data type, null count and null rate, distinct value cardinality, numeric min/max range, mean, standard deviation, and a list of the most frequently occurring values — returned for every column in the submitted CSV or NDJSON payload.","failureModes":["Payload exceeds 5,000,000 characters, 100,000 rows, 256 columns, or 1,000,000 cells — returns error","Malformed CSV or NDJSON that cannot be parsed — returns parse error","Unsupported format value other than 'csv' or 'ndjson' — returns validation error","Delimiter is more than one character — returns validation error","Empty dataset with no rows — may return empty or minimal profile","Payment not included or insufficient — returns 402 Payment Required"],"whenToPreferThis":"Choose this endpoint when you need a fast, comprehensive statistical summary of a tabular dataset in CSV or NDJSON format without standing up a data warehouse or running pandas locally. It is ideal for data quality audits, pre-ingestion checks, exploratory analysis, and schema drift detection, especially when the dataset fits within the 5M-character / 100K-row limit.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T18:53:36.714Z","isFirstParty":false}