{"uid":"cap_AUbX3W3yue04Mb3IpXtpL","slug":"join-coverage-date-by-category-pivot-with-missing-value-fill-a65c6365","name":"Join Coverage Date-by-Category Pivot with Missing-Value Fill","description":"Join coverage — Date by category pivot + Explicit missing-value fill: Date by category pivot + 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-189?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_4-2eadgFdIz3Du_eBH-Ni","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":"Pivots join coverage data (matched_rows, source_rows) by date and category, then fills missing values using zero, mean, or median imputation — producing two analytical reports for up to 200 rows.","exampleAgentPrompt":"I have up to 100 rows of join coverage data with matched_rows and source_rows across dataset groups and dates — can you pivot them by date and category and fill any missing matched_rows values using median imputation?","exampleUseCases":[{"title":"Pipeline join quality audit","prompt":"I have daily join coverage records for two dataset groups — group-a and group-b — across October 2026, with matched_rows and source_rows. Can you pivot this data by date and category and fill any missing matched_rows using median so I can see where my pipeline has coverage gaps?"},{"title":"Zero-fill missing source rows for reporting","prompt":"I need to build a weekly report on source_rows coverage across my dataset groups. I have about 80 rows of coverage records — can you pivot them by date and group, and fill any missing source_rows values with zero so nothing is left blank?"},{"title":"Mean imputation for join coverage trend analysis","prompt":"I've got 150 join coverage records with some null matched_rows values scattered across a few dataset groups. Can you pivot the data by date and dataset_group and use mean fill to impute those missing values so I can spot trends over time?"}],"resultDescription":"Two analytical reports: (1) a date-by-category pivot of the specified field (matched_rows or source_rows) across dataset groups, and (2) the same dataset with explicit missing-value imputation applied using the chosen fill method (zero, mean, or median). Both reports are computed locally from the supplied rows, with no external lookups.","failureModes":["Fewer than 1 row supplied — validation error","More than 200 rows supplied — rejected, exceeds limit","Invalid date format (not YYYY-MM-DD) — schema validation failure","Invalid field enum value (not matched_rows or source_rows) — rejected","Invalid method enum (not zero, mean, or median) — rejected","Numeric values outside allowed range (±1,000,000,000,000) — rejected","Missing required fields (row_id, dataset_group, date) — schema validation error"],"whenToPreferThis":"Choose this endpoint when you have raw join coverage records (matched_rows, source_rows) keyed by date and dataset group and need both a pivot-table view and missing-value imputation in a single call. It is ideal for data engineers auditing pipeline join quality across categories over time without needing external data sources, live lookups, or custom code execution. Prefer it over general analytics tools when your dataset fits within 200 rows and you want two pre-packaged report types (pivot + fill) for a flat $0.01 fee.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:47.263Z","isFirstParty":false,"canonicalSlug":"join-coverage-date-by-category-pivot-with-missing-value-fill-a65c6365"}