{"uid":"cap_hCb1STjavkIWEfdbW1HbU","slug":"join-coverage-record-quality-audit-and-missing-value-fill-0524d1bb","name":"Join Coverage Record Quality Audit and Missing-Value Fill","description":"Join coverage — Record quality audit + Explicit missing-value fill: Record quality audit + 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-019?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_0l-S5IMNDhU5goFBKeFQ6","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":"Audits join coverage records (matched_rows, source_rows) for quality issues and fills missing values using a chosen imputation method, producing two independent analytical reports.","exampleAgentPrompt":"Can you audit these join coverage records for data quality issues and fill any missing matched_rows values using median imputation? Here are up to 50 rows with row_id, dataset_group, date, matched_rows, and source_rows — give me both the quality audit and the filled data.","exampleUseCases":[{"title":"ETL pipeline join coverage check","prompt":"I have 120 join coverage records from our ETL pipeline — each has a row_id, dataset_group, date, matched_rows, and source_rows. Can you run a record quality audit on them and fill any null matched_rows values using median so I can see what was missing and what it was replaced with?"},{"title":"Data warehouse null source_rows repair","prompt":"Our data warehouse export has some null source_rows values in the join coverage table. Can you audit the data quality across all 80 rows and fill the missing source_rows using mean imputation, so I get both a quality report and the corrected dataset?"},{"title":"Pre-reporting join coverage validation","prompt":"Before I send this join coverage summary to the analytics team, can you check the 45 records for quality issues and fill any missing matched_rows values with zero so the report is complete? Each row has a row_id, group name, date, matched_rows, and source_rows."}],"resultDescription":"Returns two independent reports: (1) a record quality audit highlighting issues such as nulls, anomalies, or constraint violations in the join coverage rows, and (2) an explicit missing-value fill report showing which matched_rows or source_rows fields were null and what values were imputed using the chosen method (zero, mean, or median). Up to 200 rows processed per call.","failureModes":["Rows array empty or missing — validation error returned","More than 200 rows submitted — request rejected with limit error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Invalid method value outside zero/mean/median enum — rejected","Invalid field value outside matched_rows/source_rows enum — rejected","Numeric values outside allowed range (±1,000,000,000,000) — rejected","Payment not provided or insufficient — x402 payment required response"],"whenToPreferThis":"Choose this endpoint when you need both a data quality audit and missing-value imputation for join coverage metrics (matched_rows, source_rows) in a single call. It is ideal for ETL validation, pre-reporting data cleaning, and data warehouse maintenance tasks where you have up to 200 rows and want two complementary analytical reports without any external lookups or live data dependencies. Prefer it over general-purpose analytics endpoints when your specific domain is join coverage statistics and you need imputation method control (zero, mean, or median).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:35.535Z","isFirstParty":false,"canonicalSlug":"join-coverage-record-quality-audit-and-missing-value-fill-0524d1bb"}