{"uid":"cap_gnTI9xGOBaPt-JMWPqfgd","slug":"csv-dataset-profiler-ee4c8aca","name":"CSV Dataset Profiler","description":"Profile a CSV (delimiter auto-detected): rows, columns, type of each column, nulls, unique values, min, max, mean, median, std, sum, top values, duplicate rows and a sample. Understand a dataset before using it.","url":"https://api.vextorium.com/estadisticas-csv-pago?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["input"],"properties":{"input":{"type":"object","required":["type","method","bodyType","body"],"properties":{"body":{"required":["contenido"],"properties":{"contenido":{"type":"string","description":"CSV text (up to 5 MB)"},"delimitador":{"type":"string"}}},"type":{"type":"string","const":"http"},"method":{"enum":["POST"],"type":"string"},"bodyType":{"enum":["json","form-data","text"],"type":"string"}},"additionalProperties":false},"output":{"type":"object","required":["type"],"properties":{"type":{"type":"string"},"example":{"type":["object","null"],"properties":{"filas":{"type":["number","null"]},"perfil":{"type":["array","null"],"items":{"type":["null","object"],"properties":{"max":{"type":["null","number"]},"min":{"type":["null","number"]},"suma":{"type":["null","number"]},"tipo":{"type":["null","string"]},"media":{"type":["null","number"]},"unicos":{"type":["null","number"]},"vacios":{"type":["null","number"]},"columna":{"type":["null","string"]},"mediana":{"type":["null","number"]},"desviacion":{"type":["null","number"]},"longitud_media":{"type":["number","null"]},"mas_frecuentes":{"type":["array","null"],"items":{"type":["null","object"],"properties":{"valor":{"type":["null","number","string"]},"veces":{"type":["null","number"]}}}}}}},"muestra":{"type":["array","null"],"items":{"type":["null","object"],"properties":{"city":{"type":["null","string"]},"month":{"type":["null","number"]},"sales":{"type":["null","number"]}}}},"columnas":{"type":["number","null"]},"delimitador":{"type":["string","null"]},"filas_duplicadas":{"type":["number","null"]}}}}}}},"responseSchema":{"type":"json","example":{"filas":3,"perfil":[{"tipo":"str","unicos":2,"vacios":0,"columna":"city","longitud_media":7,"mas_frecuentes":[{"valor":"Madrid","veces":2},{"valor":"Barcelona","veces":1}]},{"max":120,"min":80,"suma":300,"tipo":"int64","media":100,"unicos":3,"vacios":0,"columna":"sales","mediana":100,"desviacion":20,"mas_frecuentes":[{"valor":100,"veces":1},{"valor":80,"veces":1},{"valor":120,"veces":1}]},{"max":2,"min":1,"suma":4,"tipo":"int64","media":1.333333,"unicos":2,"vacios":0,"columna":"month","mediana":1,"desviacion":0.57735,"mas_frecuentes":[{"valor":1,"veces":2},{"valor":2,"veces":1}]}],"muestra":[{"city":"Madrid","month":1,"sales":100},{"city":"Barcelona","month":1,"sales":80},{"city":"Madrid","month":2,"sales":120}],"columnas":3,"delimitador":",","filas_duplicadas":0}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.004","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"registry","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.004/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.004","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.004","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_fhbwzgM505X1qmYCf-IC6","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.004","costPer":"request","priority":0,"asset":null,"unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Auto-detects delimiter and profiles a CSV file: row/column counts, per-column types, nulls, unique values, min, max, mean, median, std, sum, top values, duplicate rows, and a sample.","exampleAgentPrompt":"Can you profile this CSV for me and tell me the column types, null counts, min/max, mean, median, top values, and how many duplicate rows there are? Here's the CSV text: city,sales,month\\nMadrid,100,1\\nBarcelona,80,1\\nMadrid,120,2","exampleUseCases":[{"title":"Data quality check before ETL pipeline","prompt":"Before I load this CSV into the database, can you profile it and tell me which columns have nulls, what types were detected, and whether there are any duplicate rows? Here's the raw CSV text."},{"title":"Exploratory analysis of sales data","prompt":"I've got a sales CSV and I want to understand it — can you give me the row and column count, the type of each column, and the min, max, mean, and top 5 most frequent values per column? Here's the CSV content."},{"title":"Validating a client-supplied dataset","prompt":"A client sent me this CSV file and I need to quickly sanity-check it — auto-detect the delimiter, profile each column for data type and unique values, and flag any duplicate rows. Here's the full CSV text."}],"resultDescription":"A JSON object with: total row count, column count, detected delimiter, count of duplicate rows, a sample of rows, and a per-column profile array where each entry includes column name, inferred type, null count, unique count, top frequent values (with counts), and for numeric columns: min, max, sum, mean, median, standard deviation, and average string length for text columns.","failureModes":["CSV text exceeds 5 MB limit — request rejected","Malformed or empty CSV body returns an error","Ambiguous delimiter that cannot be auto-detected may produce incorrect column splits","Non-UTF-8 encoded files may cause parsing errors"],"whenToPreferThis":"Use this endpoint when you need a fast, comprehensive statistical profile of a CSV dataset before processing, cleaning, or loading it — especially when you don't know the delimiter or column types in advance. It covers type inference, nulls, duplicates, distributions, and top values in a single call, making it ideal for automated data quality checks and exploratory data analysis in agent workflows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-12T18:44:09.081Z","isFirstParty":false,"canonicalSlug":"csv-dataset-profiler-ee4c8aca"}