{"uid":"cap_Dvu-zEZi0TTjET7MS5Xy8","slug":"join-coverage-keyed-dataset-comparison-with-missing-value-fill-28ae7307","name":"Join Coverage — Keyed Dataset Comparison with Missing-Value Fill","description":"Join coverage — Keyed dataset comparison + Explicit missing-value fill: Keyed dataset comparison + Explicit missing-value fill for supplied join coverage records (matched_rows, source_rows). 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-09-190?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","matched_rows","source_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"matched_rows":{"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_rows":1,"matched_rows":10,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_rows":2,"matched_rows":20,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_rows":3,"matched_rows":15,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_rows":4,"matched_rows":30,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["matched_rows","source_rows"],"type":"string","default":"matched_rows"},"other":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","matched_rows","source_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"matched_rows":{"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_rows":1,"matched_rows":10,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_rows":2,"matched_rows":21,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_rows":3,"matched_rows":17,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_rows":4,"matched_rows":33,"dataset_group":"group-b"}],"maxItems":200,"minItems":0},"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_zdm_-Y3K3EVt3Hdt20bnQ","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":"Compares two keyed datasets on matched_rows or source_rows metrics, filling explicit missing values and producing two analytical reports for up to 200 rows.","exampleAgentPrompt":"Compare my two join coverage datasets — the primary set has rows for group-a and group-b from 2026-10-01 to 2026-10-04 with matched_rows values like 10, 20, 15, 30, and the secondary set has slightly different matched_rows like 10, 21, 17, 28 for the same keys — analyze the matched_rows field, fill any missing values explicitly, and give me 2 independent comparison reports.","exampleUseCases":[{"title":"ETL pipeline join audit","prompt":"I have two snapshots of my ETL join output for October — the first run has matched_rows counts per dataset_group and date, and the second run has slightly different counts for some rows. Can you compare them on the matched_rows field, fill any nulls explicitly, and give me a coverage report showing where the discrepancies are?"},{"title":"Source row completeness check","prompt":"My data team ran two versions of a join between our customer table and transaction table, and I need to compare source_rows counts across group-a and group-b for last week. Please compare the two datasets, explicitly fill any missing source_rows values, and give me 2 analytical reports on the coverage differences."},{"title":"Dataset group coverage tracking","prompt":"I want to track join coverage trends across my dataset groups — I have two sets of up to 200 rows each with row_id, dataset_group, date, matched_rows, and source_rows. Compare them on the matched_rows field, fill in missing values where they appear, and produce 2 independent coverage comparison reports."}],"resultDescription":"Two independent analytical reports comparing the two supplied keyed datasets on the selected field (matched_rows or source_rows), with explicit missing-value fills applied where nulls are present, covering up to 200 rows per dataset. No live lookups or external data is used — all analysis is performed on the supplied data using local analytical engines.","failureModes":["Rows array exceeds 200 items — request rejected","Missing required fields (row_id, dataset_group, date) in any row — validation error","Invalid date format (must be YYYY-MM-DD) — schema validation failure","Numeric values outside allowed range (±1,000,000,000,000) — rejection","Empty rows array (minItems: 1 violated) — error","Field enum value not matched_rows or source_rows — schema error","Payment of 0.01 USDC not completed — 402 response"],"whenToPreferThis":"Choose this endpoint when you need to compare two keyed datasets specifically on join coverage metrics (matched_rows or source_rows) with explicit missing-value handling, across up to 200 rows, and want two independent analytical reports from local engines without any external lookups or live data. Prefer it over generic analytics tools when the data is already structured with row_id, dataset_group, and date keys and you need a lightweight, pay-per-call comparison with null-fill logic built in.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:54:43.457Z","isFirstParty":false,"canonicalSlug":"join-coverage-keyed-dataset-comparison-with-missing-value-fill-28ae7307"}