{"uid":"cap__pJNXLdyvjD9G5BREQobu","slug":"schema-conformity-analytics-exact-row-deduplication-iqr-outlier-flags-e782ec31","name":"Schema Conformity Analytics: Exact Row Deduplication + IQR Outlier Flags","description":"Schema conformity — Exact row deduplication + IQR outlier flags: Exact row deduplication + IQR outlier flags for supplied schema conformity records (valid_records, checked_records). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-analytics-02-049?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","valid_records","checked_records"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"dataset_group":{"type":"string","default":"","maxLength":80},"valid_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"checked_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","dataset_group":"group-a","valid_records":10,"checked_records":1},{"date":"2026-10-02","row_id":"row-2","dataset_group":"group-b","valid_records":20,"checked_records":2},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","valid_records":15,"checked_records":3},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","valid_records":30,"checked_records":4}],"maxItems":200,"minItems":1},"field":{"enum":["valid_records","checked_records"],"type":"string","default":"valid_records"}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","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.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_AsKM16Zn7SoZcKmwZhO1e","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Deduplicates exact rows and flags IQR-based outliers in schema conformity records (valid_records, checked_records) for up to 200 rows, returning two independent analytical reports.","exampleAgentPrompt":"Can you deduplicate these schema conformity records and flag any IQR outliers in the valid_records field? I have 4 rows: row-1 for group-a on 2026-10-01 with valid_records=10 and checked_records=1, row-2 for group-b on 2026-10-02 with valid_records=20 and checked_records=2, row-3 for group-a on 2026-10-03 with valid_records=15 and checked_records=3, and row-4 for group-b on 2026-10-04 with valid_records=30 and checked_records=4.","exampleUseCases":[{"title":"Daily data quality pipeline cleanup","prompt":"I need to clean up my daily schema conformity logs — can you deduplicate these 50 rows and flag any outliers in the checked_records field? Here are the rows with row_ids, dataset groups, dates, valid_records, and checked_records values."},{"title":"Anomaly detection in validation metrics","prompt":"My data team has been logging schema validation results and I suspect some of the valid_records counts are statistical anomalies — can you run IQR outlier detection on valid_records for these 30 conformity records across groups A and B?"},{"title":"Audit duplicate conformity entries","prompt":"Before we archive this month's schema conformity report, can you check these 120 rows for exact duplicates and also flag any outlier values in the valid_records column using IQR analysis? I want two separate reports."}],"resultDescription":"Returns two independent analytical reports: (1) a deduplication report identifying and removing exact duplicate rows from the submitted dataset, and (2) an IQR-based outlier flagging report for the selected field (valid_records or checked_records), covering up to 200 input rows.","failureModes":["Input exceeds 200 rows — rejected with validation error","Missing required fields (row_id, date, dataset_group, valid_records, checked_records) cause schema validation failure","Invalid date format (not YYYY-MM-DD) triggers pattern validation error","Fewer than the required minimum rows provided","Payment not included or insufficient USDC — request rejected by x402 payment layer","null values in the numeric fields may affect IQR computation quality"],"whenToPreferThis":"Choose this endpoint when you need both exact-row deduplication and IQR-based outlier detection on schema conformity data (valid_records, checked_records) in a single low-cost call. It is purpose-built for data quality pipeline use cases involving up to 200 rows and delivers two structured analytical reports without requiring any external lookup or live data access. Prefer this over general-purpose analytics tools when working specifically with schema conformity tracking records and needing a lightweight, deterministic, offline analysis.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-17T00:46:34.880Z","isFirstParty":false,"canonicalSlug":"schema-conformity-analytics-exact-row-deduplication-iqr-outlier-flags-e782ec31"}