{"uid":"cap_RattsUEDf5ud0xeRbIizz","slug":"join-coverage-record-quality-audit-string-normalisation-missing-value-6884267c","name":"Join Coverage Record Quality Audit – String Normalisation & Missing-Value Fill","description":"Join coverage — Record quality audit + String normalisation + Explicit missing-value fill: Record quality audit + String normalisation + Explicit missing-value fill for supplied join coverage records (matched_rows, source_rows). Up to 200 rows; 3 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 3 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-analytics-09-208?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_-a01KbdxaFLknNKtJdXGe","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, normalises strings, and fills missing values using zero/mean/median imputation — three reports for up to 200 rows per call.","exampleAgentPrompt":"Can you audit these join coverage records for quality issues, normalise the strings, and fill any missing matched_rows values using median imputation? Here are 4 rows: row-1 group-a 2026-10-01 matched=10 source=1, row-2 group-b 2026-10-02 matched=null source=2, row-3 group-a 2026-10-03 matched=15 source=3, row-4 group-b 2026-10-04 matched=30 source=4.","exampleUseCases":[{"title":"ETL pipeline join quality check","prompt":"I have a batch of 50 join coverage records from our ETL pipeline with possible nulls in matched_rows — can you run a full quality audit, normalise the dataset_group strings, and fill missing matched_rows with median imputation?"},{"title":"Data warehouse coverage gap detection","prompt":"We're seeing inconsistencies in our data warehouse joins. Can you audit these 120 join coverage rows for quality problems, clean up the string fields, and use mean imputation to fill any missing source_rows values?"},{"title":"Pre-merge dataset validation","prompt":"Before we merge these two datasets, please check these 30 join coverage records for record quality issues, normalise the strings, and fill any null source_rows using zero fill so we can see exactly where the gaps are."}],"resultDescription":"Three independent analytical reports: (1) a record quality audit flagging malformed, inconsistent, or anomalous rows; (2) a string normalisation report showing standardised dataset_group and other string fields; and (3) a missing-value fill report with imputed values for the chosen field (matched_rows or source_rows) using the selected method (zero, mean, or median). All computed locally from the supplied data with no external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) cause schema rejection","Invalid date format (not YYYY-MM-DD) fails pattern validation","Numeric values outside ±1,000,000,000,000 are rejected","Empty rows array is not accepted (minItems: 1)","Invalid enum value for method or field triggers a 400-level error","Payment of 0.01 USDC must be included via x402 protocol or request is rejected"],"whenToPreferThis":"Choose this endpoint when you need three bundled data-quality operations — record audit, string normalisation, and missing-value imputation — applied together to join coverage metrics (matched_rows and source_rows) in a single paid call. It is best suited for small-to-medium batches (up to 200 rows) where you want a cost-effective combined report rather than calling separate services. Prefer it over generic data-cleaning tools when your data specifically consists of join coverage records with row-match statistics grouped by dataset and date.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:47.264Z","isFirstParty":false,"canonicalSlug":"join-coverage-record-quality-audit-string-normalisation-missing-value-6884267c"}