{"uid":"cap_8kEonz_dBrqtwFSrPzrdN","slug":"brainiac-csv-outlier-detection-api-68413486","name":"BRAINIAC CSV Outlier Detection API","description":"Pay-per-call APIs for AI agents: OFAC sanctions screening, compliance checks, token security, and Base chain data via x402. No account. Fixed USDC price. MCP-ready.","url":"https://www.brainiac.software/api/v1/data-quality/csv-outlier-detect?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"csv":{"type":"string","maxLength":200000},"file":{"type":"object","required":["mediaType","fileBase64"],"properties":{"filename":{"type":"string","maxLength":180,"minLength":1},"mediaType":{"enum":["text/csv","application/json","text/plain"],"type":"string"},"fileBase64":{"type":"string","maxLength":12000000,"minLength":1}},"additionalProperties":false},"json":{"type":"string","maxLength":200000},"records":{"type":"array","items":{"type":"object","propertyNames":{"type":"string","maxLength":80,"minLength":1},"additionalProperties":{"anyOf":[{"type":"string","maxLength":4000},{"type":"number"},{"type":"boolean"},{"type":"null"}]}},"maxItems":5000},"keyColumns":{"type":"array","items":{"type":"string","maxLength":80,"minLength":1},"maxItems":20}}},"responseSchema":{"type":"json","example":{"format":"csv","issues":[],"status":"checked","columns":[{"name":"id","count":12,"index":1,"lower":"-7","upper":"19","status":"checked"},{"name":"email","count":0,"index":2,"lower":"","upper":"","status":"not_checked"},{"name":"amount","count":12,"index":3,"lower":"8.875","upper":"13.875","status":"checked"},{"name":"status","count":0,"index":4,"lower":"","upper":"","status":"not_checked"},{"name":"joined","count":0,"index":5,"lower":"","upper":"","status":"not_checked"}],"outliers":[{"row":9,"rule":"tukey_1_5_iqr","value":"500","column":"amount","detail":"The value is outside the Tukey fence 8.875 to 13.875. This is a statistical outlier, not a confirmed error.","confirmed":false,"sourceRow":10,"columnIndex":3}],"blankRows":0,"checkedAt":"2026-11-03T14:00:00.000Z","limitations":["No business system is contacted or updated.","Rows past the 2,000-row limit and columns past the 40-column limit are not read. recordsOmitted and columnsOmitted state how many.","Rows that were read stay in the counts. None of those rows is deleted.","Normalization is a proposal. The original cell is kept beside the proposed value.","A statistical outlier is not a confirmed error.","A date is normalized only when it is already a real YYYY-MM-DD day."],"recordsRead":12,"dataModified":false,"outlierCount":1,"columnsOmitted":0,"recordsOmitted":0,"recordsDiscarded":false,"outliersConfirmed":false}},"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_TrcNwHvZD_XhHae0Rscid","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":"Detects statistical outliers in tabular data (CSV, JSON, or records) using the Tukey 1.5×IQR fence method and returns per-column bounds and flagged rows","exampleAgentPrompt":"Can you check this CSV for statistical outliers? I want to know which rows have values that fall outside the normal range for each numeric column — here's the data: id,amount,status\\n1,10.5,active\\n2,500,active\\n3,11.2,active","exampleUseCases":[{"title":"Pre-import data quality check","prompt":"Before I load this sales CSV into the database, can you scan it for any rows where numeric values look like statistical outliers — things way outside the normal range? Flag anything suspicious so I can review it first."},{"title":"Financial transaction anomaly detection","prompt":"Here's a CSV of transaction amounts from last month. Can you run outlier detection on the amount column and tell me which rows fall outside the Tukey fences so I can investigate potential data entry errors or fraud?"},{"title":"Survey response cleanup","prompt":"I have a JSON dataset of survey responses with numeric rating fields. Can you detect any statistically extreme values — rows where scores are way above or below the interquartile range — before I run my analysis?"}],"resultDescription":"A JSON object containing: per-column statistics (name, count of outliers, lower/upper Tukey fence bounds, check status), a list of flagged outlier rows with the offending value, column index, row number, the specific Tukey rule violated, and a human-readable detail string; plus summary fields like outlierCount, blankRows, recordsRead, columnsOmitted, recordsOmitted, and a checkedAt timestamp. Non-numeric and non-date columns are skipped and marked as not_checked.","failureModes":["Input exceeds 2,000 rows — rows beyond the limit are omitted and recorded in recordsOmitted","Input exceeds 40 columns — extra columns are omitted and recorded in columnsOmitted","Malformed CSV or JSON that cannot be parsed — returns an error status","CSV or JSON string exceeds 200,000 character limit — rejected","File base64 exceeds 12,000,000 character limit — rejected","Columns with insufficient numeric data for IQR calculation are skipped (status: not_checked)","Missing required payment header or insufficient USDC balance — payment fails with 402 response"],"whenToPreferThis":"Use this endpoint when you need a fast, accountless, pay-per-call statistical outlier scan on tabular data without setting up a full data-quality pipeline. It is ideal for pre-import validation, one-off audits, or agent workflows that need programmatic anomaly flagging on CSV or JSON records. Prefer this over manual inspection or heavier analytics tools when the dataset fits within 2,000 rows and 40 columns and you want Tukey IQR-based detection with per-column bounds returned in a structured JSON response.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-17T00:36:55.403Z","isFirstParty":false,"canonicalSlug":"brainiac-csv-outlier-detection-api-68413486"}