{"uid":"cap_DTL9Q0VrIJlBuKp6Vcr_T","slug":"duplicate-observations-iqr-outlier-flags-and-missing-value-fill-a4e3afe5","name":"Duplicate Observations IQR Outlier Flags and Missing Value Fill","description":"Duplicate observations — IQR outlier flags + Explicit missing-value fill: IQR outlier flags + Explicit missing-value fill for supplied duplicate observations records (duplicate_rows, total_rows). 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-04-180?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","duplicate_rows","total_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"total_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"duplicate_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","total_rows":1,"dataset_group":"group-a","duplicate_rows":10},{"date":"2026-10-02","row_id":"row-2","total_rows":2,"dataset_group":"group-b","duplicate_rows":20},{"date":"2026-10-03","row_id":"row-3","total_rows":3,"dataset_group":"group-a","duplicate_rows":15},{"date":"2026-10-04","row_id":"row-4","total_rows":4,"dataset_group":"group-b","duplicate_rows":30}],"maxItems":200,"minItems":1},"field":{"enum":["duplicate_rows","total_rows"],"type":"string","default":"duplicate_rows"},"method":{"enum":["zero","mean","median"],"type":"string","default":"median"}}},"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_Lm8rPqZ9ESvmz7b5DBAt5","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":"Analyzes up to 200 rows of duplicate-observation records to flag IQR-based outliers and fill missing values in duplicate_rows or total_rows fields, returning two analytical reports.","exampleAgentPrompt":"I have up to 200 rows of dataset duplication observations with fields like duplicate_rows and total_rows — can you run IQR outlier flagging and fill any missing duplicate_rows values using median imputation on this data?","exampleUseCases":[{"title":"Data pipeline quality audit","prompt":"I'm auditing our ETL pipeline outputs and have 150 rows of duplicate_rows and total_rows counts across multiple dataset groups — can you flag any IQR outliers in the duplicate_rows field and fill in the missing values using median?"},{"title":"Monthly dataset deduplication review","prompt":"Here are 80 records from our monthly deduplication log with date, dataset_group, duplicate_rows, and total_rows columns — please run the IQR outlier check and use mean fill to handle any missing total_rows values, and give me both reports."},{"title":"Data quality monitoring for analytics team","prompt":"Our analytics team needs a quick outlier and missing-value report on this batch of 60 duplicate observation rows — flag IQR outliers in total_rows and fill nulls with zero, grouped by dataset_group."}],"resultDescription":"Returns two independent analytical reports per call: (1) IQR-based outlier flags indicating which observations fall outside the interquartile range for the selected field, and (2) explicit missing-value fill results replacing nulls in that field using the chosen method (zero, mean, or median). Both reports are computed locally on the supplied data with no external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) cause validation error","Invalid date format (not YYYY-MM-DD) causes schema rejection","field or method enum values not matching allowed options return error","Insufficient USDC balance or x402 payment failure blocks execution","All values for selected field are null — imputation may be undefined or trivial"],"whenToPreferThis":"Choose this endpoint when you need simultaneous IQR outlier detection and missing-value imputation on batch duplicate-observation records (up to 200 rows) in a single low-cost call. It is especially useful for data quality pipelines auditing dataset duplication metrics across groups and dates, where both anomaly flagging and null filling are needed together without external data access or live predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T07:19:35.523Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-iqr-outlier-flags-and-missing-value-fill-a4e3afe5"}