{"uid":"cap_ifkdfS5KVYp9Q-BbCzoTJ","slug":"join-coverage-adjacent-row-changes-explicit-missing-value-fill-afd6715d","name":"Join Coverage — Adjacent Row Changes + Explicit Missing-Value Fill","description":"Join coverage — Adjacent row changes + Explicit missing-value fill: Adjacent row changes + 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-162?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"},"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_CR35nFuuqYx78Et0nVZU2","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":"Analyzes join coverage data (matched_rows and source_rows) to detect adjacent row changes and fill missing values using zero, mean, or median imputation — returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"Analyze my join coverage records for adjacent row changes and fill any missing matched_rows values using median imputation — here are up to 50 rows with row_id, date, dataset_group, matched_rows, and source_rows fields.","exampleUseCases":[{"title":"Audit join coverage gaps over time","prompt":"I have 120 rows of daily join coverage data with matched_rows and source_rows per dataset group, and some matched_rows values are null. Can you fill those nulls using median and also show me where consecutive rows changed significantly?"},{"title":"Detect ETL pipeline row shifts","prompt":"My ETL pipeline produces join coverage records grouped into 'group-a' and 'group-b' — can you run adjacent row change detection on source_rows and fill any missing source_rows entries with zero so I can see where drops occurred?"},{"title":"Validate data completeness before reporting","prompt":"Before I send the weekly join coverage report, can you check these 80 rows for any missing matched_rows values and fill them using mean imputation, and also flag any adjacent rows where matched_rows changed by a large amount?"}],"resultDescription":"Returns two analytical reports: (1) an adjacent row changes report showing delta values between consecutive rows for the selected field (matched_rows or source_rows), and (2) an explicit missing-value fill report showing which rows had null values and what imputed values were substituted using the chosen method (zero, mean, or median). Reports are computed locally with no external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, date, dataset_group) — validation error","Invalid date format (must match YYYY-MM-DD pattern) — schema rejection","Invalid field enum value (must be 'matched_rows' or 'source_rows') — error","Invalid method enum value (must be 'zero', 'mean', or 'median') — error","All values non-null with fill method specified — fill report returns no changes","Numeric values outside allowed range (±1,000,000,000,000) — validation failure","Payment of 0.01 USDC not included or rejected — 402 response"],"whenToPreferThis":"Choose this endpoint when you need two specific analytical operations on join coverage data simultaneously: adjacent row change detection and missing-value imputation. It is purpose-built for join coverage metrics (matched_rows and source_rows), making it ideal for ETL quality audits, data completeness checks before reporting, or time-series gap analysis on join pipelines. Prefer this over a generic stats API when you specifically need both delta analysis and null-fill in a single low-cost call on row-level join data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:54:28.492Z","isFirstParty":false,"canonicalSlug":"join-coverage-adjacent-row-changes-explicit-missing-value-fill-afd6715d"}