{"uid":"cap_q-Gu54bl4FFMgqn3FZcej","slug":"data-reconciliation-two-measure-correlation-explicit-missing-value-fill-c38ddf06","name":"Data Reconciliation: Two-Measure Correlation + Explicit Missing-Value Fill","description":"Data reconciliation — Two-measure correlation + Explicit missing-value fill: Two-measure correlation + 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-184?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"},"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_fOzpQ4mvxHPUvb-wz3swV","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 correlation between source_total and target_total columns and fills missing values using a chosen method (zero, mean, or median) across up to 200 reconciliation rows.","exampleAgentPrompt":"I have 150 rows of reconciliation data with source_total and target_total columns — some target_total values are null. Can you compute the correlation between the two measures and fill the missing target_total values using the median of existing values?","exampleUseCases":[{"title":"Audit data alignment check","prompt":"I'm preparing an audit and need to verify how closely our source_total and target_total figures correlate across 80 reconciliation rows grouped by region and date — can you run the two-measure correlation and fill any null source_total values with the mean?"},{"title":"Monthly close missing-value imputation","prompt":"We're doing end-of-month close and some of our target_total entries are missing. Can you fill those nulls using zero and also give me the correlation between source and target totals for all 120 rows so I can flag outlier groups?"},{"title":"Cross-system data quality report","prompt":"I'm comparing transaction totals from two systems — here are 200 rows with row IDs, dates, and dataset groups. Please compute the correlation between source_total and target_total and fill any missing source_total values using the median so I can see where the systems diverge."}],"resultDescription":"Returns two analytical reports per call: (1) a Pearson or equivalent correlation between source_total and target_total across the supplied rows, and (2) a version of the dataset with missing values in the specified field filled using the chosen method (zero, mean, or median). Results are computed locally with no external lookups or predictions.","failureModes":["More than 200 rows submitted — request will be rejected or truncated","Invalid date format (must match YYYY-MM-DD pattern)","Both source_total and target_total are entirely null — correlation cannot be computed","Unrecognized fill method value outside enum (zero, mean, median)","Row missing required fields (row_id, dataset_group, date) — validation error","All values in the target field are null — mean/median fill has no basis value"],"whenToPreferThis":"Choose this endpoint when you have tabular reconciliation data with two numeric measures (source and target totals) and need both a correlation analysis and missing-value imputation in a single call. It is ideal for financial reconciliation, audit preparation, and data quality checks where you supply your own data and need fast, local statistical computation without any external data lookup or live prediction. Prefer this over general analytics tools when you specifically need the source/target reconciliation pattern and want both reports together at low cost ($0.01 USDC for up to 200 rows).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:49.945Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-two-measure-correlation-explicit-missing-value-fill-c38ddf06"}