{"uid":"cap_8lphGDBnuFKxsfl4l9BQK","slug":"data-reconciliation-iqr-outlier-flags-explicit-missing-value-fill-89ee6524","name":"Data Reconciliation IQR Outlier Flags + Explicit Missing-Value Fill","description":"Data reconciliation — IQR outlier flags + Explicit missing-value fill: IQR outlier flags + Explicit missing-value fill for supplied data reconciliation records (source_total, target_total). 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-11-180?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","source_total","target_total"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_total":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"target_total":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source_total":10,"target_total":1,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_total":20,"target_total":2,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_total":15,"target_total":3,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_total":30,"target_total":4,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["source_total","target_total"],"type":"string","default":"source_total"},"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_3dd_0VpbRtIQ9oJGy6qUH","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":"Detects IQR-based outliers and fills missing values in source/target reconciliation data rows using local analytical engines, returning two reports for up to 200 rows.","exampleAgentPrompt":"I have 50 reconciliation rows with source_total and target_total values — some have nulls. Can you flag IQR outliers and fill the missing source_total values using median, grouped by dataset_group and date?","exampleUseCases":[{"title":"Financial reconciliation outlier audit","prompt":"Here are 120 rows of daily financial reconciliation data with source_total and target_total. Flag any IQR outliers and fill missing target_total values using the mean method."},{"title":"ETL pipeline data quality check","prompt":"My ETL job produced 80 rows of source and target totals across several dataset groups — some source_total fields are null. Run IQR outlier flagging and fill those nulls using median so I can see what's anomalous before I load the data."},{"title":"Monthly close reconciliation cleanup","prompt":"I have end-of-month reconciliation records — 45 rows with dates, row IDs, dataset groups, and source_total/target_total pairs. Several source_total entries are missing. Flag the outliers and impute the missing source_total values with zero so I can finalize the report."}],"resultDescription":"Two analytical reports covering: (1) IQR-based outlier flags identifying which rows have source_total or target_total values outside the interquartile range, and (2) a filled dataset where missing values in the specified field have been replaced using the chosen method (zero, mean, or median). All analysis is performed locally with no external lookups.","failureModes":["More than 200 rows submitted — request will be rejected","Missing required fields (row_id, dataset_group, date, source_total, target_total) — validation error","Date field does not match YYYY-MM-DD format — schema validation failure","Numeric values outside allowed range (-1T to +1T) — schema rejection","Invalid enum value for field or method parameters — rejected with schema error","Empty rows array — rejected due to minItems:1 constraint"],"whenToPreferThis":"Choose this endpoint when you need both IQR outlier detection and missing-value imputation on reconciliation data (source_total vs target_total pairs) in a single call returning two reports. Ideal for data quality checks on ETL pipelines, financial close processes, or audit workflows with up to 200 rows. Prefer this over separate outlier or imputation tools when both reports are needed together at low cost ($0.01 USDC). Not suitable for prediction, live data lookup, or datasets exceeding 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:47:07.886Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-iqr-outlier-flags-explicit-missing-value-fill-89ee6524"}