{"uid":"cap_olffeObGdOjfwQWGFJuUx","slug":"data-reconciliation-equal-width-histogram-explicit-missing-value-fill-f03c1bc9","name":"Data Reconciliation — Equal-Width Histogram + Explicit Missing-Value Fill","description":"Data reconciliation — Equal-width histogram + Explicit missing-value fill: Equal-width histogram + 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-175?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"bins":{"type":"integer","default":5,"maximum":30,"minimum":1},"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_5SIZiwAmnJO9RG-dhFmkQ","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":"Generates an equal-width histogram and fills missing values (zero/mean/median) for source_total and target_total reconciliation data across up to 200 rows, producing 2 analytical reports locally.","exampleAgentPrompt":"I have 150 rows of reconciliation data with source_total and target_total values — some nulls — can you build an equal-width histogram with 10 bins for source_total and fill the missing values using median imputation?","exampleUseCases":[{"title":"Reconciling monthly ledger discrepancies","prompt":"I've got 80 rows of monthly ledger data with source_total and target_total fields — a few source_total entries are null. Can you fill those nulls with the median and then give me a 10-bin histogram of source_total so I can see the distribution?"},{"title":"Auditing ETL pipeline output gaps","prompt":"Our ETL pipeline produced 120 reconciliation records across two dataset groups and some target_total values are missing. Fill those gaps using zero and generate a 5-bin equal-width histogram on target_total so I can audit the spread."},{"title":"Pre-analysis data prep for finance team","prompt":"Before we hand off these 60 reconciliation rows to the finance team, can you impute any null source_total values using the mean and produce a histogram with 8 bins so they can see how the data is distributed?"}],"resultDescription":"Returns 2 analytical reports: (1) an equal-width histogram of the specified field (source_total or target_total) divided into the requested number of bins, showing frequency distribution; (2) a missing-value fill report where nulls in the specified field are replaced using the chosen method (zero, mean, or median), applied to up to 200 input reconciliation rows. All computation is local with no external lookups.","failureModes":["More than 200 rows submitted — schema enforces maxItems:200, excess rows will be rejected","Invalid date format (must match YYYY-MM-DD pattern) — returns validation error","bins value outside 1–30 range — rejected by schema","source_total or target_total outside ±1,000,000,000,000 — rejected by schema","Missing required fields (row_id, dataset_group, date) — validation error","Empty rows array — minItems:1 enforced","Invalid method enum value — only zero, mean, median accepted","Invalid field enum — only source_total or target_total accepted"],"whenToPreferThis":"Choose this endpoint when you need a lightweight, offline-style analytical report combining histogram bin distribution and missing-value imputation for reconciliation data (source_total vs target_total) without any external data lookups or live predictions. Ideal for pre-analysis data quality checks, audit prep, and distribution visualization for up to 200 rows at very low cost ($0.01 for 2 reports). Prefer this over general BI tools when you want a quick, deterministic local computation on structured reconciliation records.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:48.842Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-equal-width-histogram-explicit-missing-value-fill-f03c1bc9"}