{"uid":"cap_QuyU7uUfYUBs9N5Lv0npo","slug":"data-reconciliation-category-frequencies-iqr-outlier-flags-f22445bf","name":"Data Reconciliation: Category Frequencies + IQR Outlier Flags","description":"Data reconciliation — Category frequencies + IQR outlier flags: Category frequencies + IQR outlier flags 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-107?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"}}},"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_9xNL3_dQ7Q3gmJszFBVAo","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 data reconciliation rows (source_total vs target_total) to produce category frequency distributions and IQR-based outlier flags across dataset groups.","exampleAgentPrompt":"Can you run category frequency analysis and IQR outlier detection on my reconciliation data? I have 4 rows with dataset groups 'group-a' and 'group-b', dates from 2026-10-01 to 2026-10-04, and source_totals of 10, 20, 15, 30 paired with target_totals of 1, 2, 3, 4 — analyze the source_total field.","exampleUseCases":[{"title":"Flagging outliers in monthly finance reconciliation","prompt":"I have 50 reconciliation rows comparing our ERP source totals to our data warehouse target totals across 3 business units for October 2026 — can you run IQR outlier detection on the source_total field and also give me a frequency breakdown by dataset group?"},{"title":"Daily ETL data quality check","prompt":"After our nightly ETL run I have 120 rows of source vs target totals across pipeline segments dated today — flag any IQR outliers in target_total and show me the category frequencies per segment so I can spot which groups have the most records."},{"title":"Audit prep: spotting anomalous reconciliation entries","prompt":"Before our quarterly audit I need to check 80 reconciliation records — can you compute IQR outlier flags on the source_total column and tell me how often each dataset_group appears so I know where discrepancies are concentrated?"}],"resultDescription":"Returns two independent analytical reports: (1) category frequency counts for the dataset_group field showing how often each group appears in the submitted rows, and (2) IQR-based outlier flags for each row on the selected field (source_total or target_total), identifying which rows fall outside the interquartile range bounds. All analysis is performed locally on the submitted data with no external lookups.","failureModes":["rows array empty or missing — validation error returned","rows exceeding 200 items — request rejected","row missing required fields (row_id, dataset_group, date, source_total, target_total) — schema validation error","date field not matching YYYY-MM-DD pattern — validation error","numeric values outside ±1,000,000,000,000 range — schema rejection","invalid field enum value (not 'source_total' or 'target_total') — error response","payment of 0.01 USDC not provided — x402 payment required response"],"whenToPreferThis":"Choose this endpoint when you need fast, local statistical analysis of reconciliation data — specifically IQR-based outlier detection and category frequency counting — on batches up to 200 rows without any external data lookups or live predictions. It is ideal for data quality pipelines, ETL validation, and audit workflows where you want to compare source vs target totals across named groups and flag statistical anomalies cheaply at $0.01 per call covering both reports simultaneously.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:52.575Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-category-frequencies-iqr-outlier-flags-f22445bf"}