{"uid":"cap_bS_mxGma5jPGtJ0K0h_lY","slug":"data-reconciliation-two-measure-correlation-keyed-dataset-comparison-0b826bdc","name":"Data Reconciliation: Two-Measure Correlation + Keyed Dataset Comparison","description":"Data reconciliation — Two-measure correlation + Keyed dataset comparison: Two-measure correlation + Keyed dataset comparison 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-183?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},"other":{"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":21,"target_total":2,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_total":17,"target_total":3,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_total":33,"target_total":4,"dataset_group":"group-b"}],"maxItems":200,"minItems":0}}},"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_Cw3JgpovuanchnZLpijb_","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":"Computes Pearson/Spearman correlation between source_total and target_total, and performs a keyed row-by-row comparison between two supplied datasets, for up to 200 reconciliation records.","exampleAgentPrompt":"Can you run a two-measure correlation and keyed dataset comparison on my reconciliation data? I have two sets of up to 200 rows, each with a row_id, dataset_group, date, source_total, and target_total — one for my source system and one for my target system — and I want to see how correlated the totals are and which rows have mismatches.","exampleUseCases":[{"title":"ETL pipeline output validation","prompt":"I ran our nightly ETL job and want to verify the output. Can you correlate the source_total and target_total across my 150 pipeline records and also do a keyed comparison between last night's source extract and the loaded target data to flag any row-level discrepancies? I'll send both datasets."},{"title":"Finance ledger cross-system reconciliation","prompt":"We have general ledger entries from two different accounting systems and need to reconcile them. Can you compute the correlation between the source and target totals for our 80 journal entries and compare the two datasets row by row by row_id so we can see exactly where the figures diverge?"},{"title":"Monthly report source vs target audit","prompt":"Before I sign off on the monthly report, can you run a statistical correlation between our source_total and target_total columns and do a keyed comparison between the two dataset snapshots — we have about 120 rows grouped by business unit — so I can confirm data integrity before publishing?"}],"resultDescription":"Returns two independent analytical reports: (1) a two-measure correlation report showing the statistical relationship (e.g. Pearson/Spearman coefficient) between source_total and target_total across the supplied rows, and (2) a keyed dataset comparison report that matches rows between the two supplied datasets by row_id and highlights value differences, missing keys, and summary statistics — all computed locally without any external lookup.","failureModes":["Exceeds 200-row limit — request rejected or truncated","Missing required fields (row_id, date, source_total, target_total, dataset_group) — validation error","Date field not in YYYY-MM-DD format — schema validation failure","Numeric values outside ±1,000,000,000,000 range — rejected","Insufficient row count for meaningful correlation (e.g. only 1 row)","Payment failure via x402 protocol — endpoint returns 402","Mismatched row_ids between the two datasets — keyed comparison may return empty matches"],"whenToPreferThis":"Choose this endpoint when you need both a statistical correlation between source and target numeric measures AND a row-keyed comparison between two versions of a dataset in a single API call. It is ideal for ETL validation, financial reconciliation, and data pipeline auditing where you supply the data yourself and do not need live external lookups. Prefer this over single-report endpoints when you want two complementary analytical perspectives (correlation + row-level diff) in one low-cost call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:19.383Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-two-measure-correlation-keyed-dataset-comparison-0b826bdc"}