{"uid":"cap_ah2I8pmZfHEreyy_5uFo0","slug":"data-reconciliation-exact-row-deduplication-equal-width-histogram-c04a5c70","name":"Data Reconciliation — Exact Row Deduplication + Equal-Width Histogram","description":"Data reconciliation — Exact row deduplication + Equal-width histogram: Exact row deduplication + Equal-width histogram 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-048?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"}}},"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_ZhVJQM06vYlcJW3BLufTy","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 rows and computes an equal-width histogram over source_total or target_total values from supplied reconciliation data, returning two analytical reports in a single call.","exampleAgentPrompt":"Deduplicate these reconciliation rows and give me an equal-width histogram with 10 bins over the source_total field — here are my records: row-1, group-a, 2024-01-01, source=500, target=480; row-2, group-b, 2024-01-02, source=600, target=610; row-3, group-a, 2024-01-01, source=500, target=480 (duplicate of row-1).","exampleUseCases":[{"title":"Monthly close reconciliation deduplication","prompt":"I have 150 reconciliation records from our month-end close — some rows got duplicated during the ETL. Can you deduplicate them exactly and also give me a 5-bin equal-width histogram over source_total so I can see the distribution?"},{"title":"Auditing target total spread across groups","prompt":"Run a histogram with 8 bins over the target_total field for these 80 reconciliation rows across our two dataset groups, and flag any exact duplicate rows in the process."},{"title":"Pre-reporting data quality check","prompt":"Before I send this reconciliation file to the finance team, can you deduplicate it and show me a 10-bin histogram of source_total so I can spot any outlier clusters? I have about 120 rows spanning multiple dates and groups."}],"resultDescription":"Returns two reports: (1) a deduplicated list of rows with exact duplicates removed, and (2) an equal-width histogram of the chosen field (source_total or target_total) divided into the specified number of bins, showing bin ranges and record counts. Both reports are computed locally from the supplied data with no external lookups.","failureModes":["More than 200 rows submitted — request rejected, maxItems limit exceeded","Missing required fields (row_id, dataset_group, date, source_total, target_total) on any row — validation error","Date format not matching YYYY-MM-DD pattern — schema validation failure","bins value outside 1–30 range — rejected by schema","All values are null for the chosen field — histogram cannot be computed","Malformed JSON body — parse error returned"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and a frequency histogram over reconciliation totals in a single low-cost call (up to 200 rows). It is ideal for data quality checks before reporting, ETL validation, or audit workflows where you want to understand the distribution of source or target values while simultaneously cleaning duplicates. Prefer it over general-purpose analytics tools when working specifically with source_total/target_total reconciliation records and needing two reports for $0.01.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:32.084Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-exact-row-deduplication-equal-width-histogram-c04a5c70"}