{"uid":"cap_dHlRIpSaGo91x2C7SnfqO","slug":"null-coverage-analytics-exact-row-deduplication-grouped-numeric-summary-bcd562fd","name":"Null Coverage Analytics: Exact Row Deduplication + Grouped Numeric Summary","description":"Null coverage — Exact row deduplication + Grouped numeric summary: Exact row deduplication + Grouped numeric summary for supplied null coverage records (missing_values, total_values). 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-03-040?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","missing_values","total_values"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"total_values":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"missing_values":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","total_values":1,"dataset_group":"group-a","missing_values":10},{"date":"2026-10-02","row_id":"row-2","total_values":2,"dataset_group":"group-b","missing_values":20},{"date":"2026-10-03","row_id":"row-3","total_values":3,"dataset_group":"group-a","missing_values":15},{"date":"2026-10-04","row_id":"row-4","total_values":4,"dataset_group":"group-b","missing_values":30}],"maxItems":200,"minItems":1},"field":{"enum":["missing_values","total_values"],"type":"string","default":"missing_values"}}},"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_nOd7zU6e33Eu4ceav-WM5","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":"Deduplicates exact rows and generates a grouped numeric summary report for null coverage records containing missing_values and total_values fields, processing up to 200 rows offline.","exampleAgentPrompt":"I have up to 200 rows of null coverage data with row_id, dataset_group, date, missing_values, and total_values — can you deduplicate the exact rows and then give me a grouped numeric summary on the missing_values field?","exampleUseCases":[{"title":"Data quality audit deduplication","prompt":"I've got 150 rows of null coverage records across groups like 'sales' and 'inventory' with dates in October 2026 — can you remove any exact duplicate rows and give me a grouped summary of missing_values by dataset_group?"},{"title":"Monthly null rate report by team","prompt":"Here are our dataset completeness records for Q3 — each row has a dataset_group, a date, and counts for missing_values and total_values. Can you deduplicate them and summarize the total_values field grouped by team?"},{"title":"Pre-pipeline data cleanliness check","prompt":"Before I run my ML pipeline, I need to check this batch of up to 80 coverage rows for duplicates and get a numeric breakdown of missing_values grouped by dataset_group — can you run both reports at once?"}],"resultDescription":"Two independent reports: (1) a deduplicated set of exact rows with duplicates removed, and (2) a grouped numeric summary (e.g. count, sum, mean, min, max) of the selected field (missing_values or total_values) broken down by dataset_group. Both reports are computed locally from the supplied rows with no external lookups.","failureModes":["Missing required fields (row_id, dataset_group, date, missing_values, total_values) causes validation error","Supplying more than 200 rows exceeds the row limit and is rejected","Invalid date format (not YYYY-MM-DD) fails pattern validation","Numeric values outside the allowed range (-1,000,000,000,000 to 1,000,000,000,000) are rejected","Empty rows array (minItems: 1 not met) causes error","Invalid field enum value (not missing_values or total_values) is rejected"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and a grouped numeric summary for null coverage or data completeness records in a single paid call. It is ideal for small-to-medium batches (up to 200 rows) where you want offline, deterministic analytics without any external lookups, predictions, or live data fetching. Prefer this over general data pipelines when your records conform to the row_id/dataset_group/date/missing_values/total_values schema and you need two complementary reports cheaply.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:57:46.712Z","isFirstParty":false,"canonicalSlug":"null-coverage-analytics-exact-row-deduplication-grouped-numeric-summary-bcd562fd"}