{"uid":"cap_XsZChVzWKL4VJis3673gF","slug":"join-coverage-base-100-series-explicit-missing-value-fill-a40055a5","name":"Join Coverage — Base-100 Series + Explicit Missing-Value Fill","description":"Join coverage — Base-100 series + Explicit missing-value fill: Base-100 series + 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-169?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"},"base_index":{"type":"integer","default":0,"maximum":199,"minimum":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_LvdUsg51FKLfeCyahrcNy","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 a base-100 indexed time series and fills missing values (zero, mean, or median) for join coverage metrics (matched_rows, source_rows) across up to 200 supplied rows, returning 2 analytical reports.","exampleAgentPrompt":"Take my join coverage records for group-a and group-b from October 2026 — up to 4 rows with matched_rows and source_rows — and give me a base-100 indexed series starting at row index 0, filling any missing matched_rows values using median imputation.","exampleUseCases":[{"title":"Track join quality trends over time","prompt":"I have daily join coverage data for two dataset groups across October 2026. Can you normalize the matched_rows values to a base-100 series starting from the first row, and fill any gaps using median so I can compare trends between groups?"},{"title":"Impute missing source rows before reporting","prompt":"My pipeline has some null source_rows values across about 150 rows of join coverage records. Can you fill those nulls using mean imputation and return a base-100 indexed series so I can see how source coverage evolved relative to day zero?"},{"title":"Audit join coverage with zero-fill baseline","prompt":"I want to analyze join coverage quality across my dataset groups. Please take my 80 rows of matched_rows data dated from 2025, apply zero-fill for any missing values, and produce a base-100 series indexed from row 5 so I can benchmark against that point."}],"resultDescription":"Returns 2 analytical reports: (1) a base-100 indexed time series for the selected field (matched_rows or source_rows), normalized relative to the specified base_index row; (2) a missing-value filled version of the same series using the chosen method (zero, mean, or median). All computation is performed locally on the supplied data with no external lookups.","failureModes":["Input array exceeds 200 rows — rejected with validation error","base_index out of range for the supplied rows array — validation failure","Invalid date format (not YYYY-MM-DD) in any row — schema rejection","All values for selected field are null — imputation may be undefined or return zeros","Missing required fields (row_id, dataset_group, date) on any row — request rejected","Field enum value not in ['matched_rows','source_rows'] — rejected","Method enum value not in ['zero','mean','median'] — rejected"],"whenToPreferThis":"Choose this endpoint when you need both a base-100 normalized time series AND missing-value imputation for join coverage metrics (matched_rows or source_rows) in a single call. It is ideal for data engineering workflows where you want to track join quality trends relative to a baseline row while also cleaning nulls before downstream analysis. Prefer it over separate normalization or imputation tools when your data fits within 200 rows and you want two complementary reports (indexed series + filled series) for $0.01 USDC per call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:34.202Z","isFirstParty":false,"canonicalSlug":"join-coverage-base-100-series-explicit-missing-value-fill-a40055a5"}