{"uid":"cap_tJmz4v9w5dbiRFl1S_GIP","slug":"data-reconciliation-exact-row-deduplication-secondary-measure-746b5531","name":"Data Reconciliation — Exact Row Deduplication + Secondary-Measure Weighted Mean","description":"Data reconciliation — Exact row deduplication + Secondary-measure weighted mean: Exact row deduplication + Secondary-measure weighted mean 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-051?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_Zq3XkLEVD0pee7mAJOs96","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 exactly and computes a secondary-measure weighted mean across source/target reconciliation records, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you run exact row deduplication and a secondary-measure weighted mean on my reconciliation data? I have rows grouped into 'group-a' and 'group-b' with dates in October 2026, source_totals and target_totals for each row — use source_total as the field and give me both reports.","exampleUseCases":[{"title":"Monthly financial ledger reconciliation","prompt":"I need to reconcile my monthly ledger — here are 50 rows with row IDs, dates from 2025-01-01 to 2025-01-31, dataset groups 'actuals' and 'forecast', and source_total vs target_total figures. Please deduplicate exact duplicates and compute the weighted mean on source_total for me."},{"title":"ETL pipeline output validation","prompt":"We just ran our ETL pipeline and exported 120 rows of reconciliation records with dataset groups 'pipeline-a' and 'pipeline-b'. Can you deduplicate them exactly and calculate the secondary-measure weighted mean on target_total so we can validate the output?"},{"title":"Multi-group dataset discrepancy check","prompt":"I have reconciliation data across three dataset groups — 'region-east', 'region-west', and 'region-central' — with about 80 rows total, each with a source_total and target_total. Run exact deduplication and a weighted mean on source_total and give me the two analytical reports."}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying and removing fully duplicate rows from the supplied reconciliation data, and (2) a secondary-measure weighted mean computation over the selected field (source_total or target_total), grouped as appropriate. Both reports are produced locally without external lookups or predictions, covering up to 200 input rows.","failureModes":["More than 200 rows submitted — request rejected due to maxItems limit","Missing required fields (row_id, dataset_group, date, source_total, or target_total) — validation error","Invalid date format (not YYYY-MM-DD pattern) — schema validation failure","source_total or target_total outside ±1,000,000,000,000 range — value rejected","Invalid field enum value (not 'source_total' or 'target_total') — rejected","Empty rows array (minItems: 1 not met) — request fails","Payment not included or insufficient — x402 payment required error"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and a secondary-measure weighted mean on reconciliation data (source_total vs target_total) in a single low-cost call. It is ideal for data quality pipelines where duplicate rows must be removed before computing weighted aggregates across dataset groups. Prefer this over general analytics tools when you want two focused reconciliation reports at $0.01 USDC with no external dependencies, live lookups, or professional assessments — purely local, deterministic computation on your supplied rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:44:12.636Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-exact-row-deduplication-secondary-measure-746b5531"}