{"uid":"cap_pxQN50Z8BIsLdwnisGpzU","slug":"null-coverage-analytics-exact-row-deduplication-date-by-category-pivot-b5c958f3","name":"Null Coverage Analytics: Exact Row Deduplication + Date-by-Category Pivot","description":"Null coverage — Exact row deduplication + Date by category pivot: Exact row deduplication + Date by category pivot 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-052?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_KyQ6JGbMMieUXk8m-92s6","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":"Analyzes up to 200 null-coverage records by performing exact row deduplication and a date-by-category pivot on missing_values or total_values fields, returning two independent analytical reports.","exampleAgentPrompt":"I have 4 rows of null coverage data across two groups — row-1 (group-a, 2026-10-01, missing=10, total=1), row-2 (group-b, 2026-10-02, missing=20, total=2), row-3 (group-a, 2026-10-03, missing=15, total=3), row-4 (group-b, 2026-10-04, missing=30, total=4) — can you deduplicate them and give me a date-by-category pivot on the missing_values field?","exampleUseCases":[{"title":"Data quality audit across pipeline stages","prompt":"I have 150 rows of null coverage records from my data pipeline, each tagged with a dataset_group and date. Can you deduplicate any exact duplicates and then pivot the missing_values counts by date and group so I can see where nulls are clustering?"},{"title":"Monthly null rate trend by team","prompt":"Here are our team's daily null coverage metrics for October — each row has a team name as dataset_group, a date, and missing_values plus total_values. Please deduplicate the rows and give me a pivot table showing missing_values by date and team."},{"title":"Validating data completeness before ML training","prompt":"Before I train my model, I need to check null coverage in my feature dataset. I have 80 records with feature_group, date, missing_values, and total_values. Can you run exact row deduplication and then pivot total_values by date and feature_group to see where coverage is thin?"}],"resultDescription":"Returns two independent analytical reports: (1) an exact row deduplication report identifying and removing duplicate records from the submitted null coverage rows, and (2) a date-by-category pivot table summarizing the chosen field (missing_values or total_values) broken down by date and dataset_group — all computed locally with no external data lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, dataset_group, date, missing_values, total_values) cause schema rejection","Invalid date format (not YYYY-MM-DD) triggers pattern validation failure","Numeric values outside ±1,000,000,000,000 are rejected","Empty rows array is rejected (minItems: 1)","Invalid field enum value (not 'missing_values' or 'total_values') causes an error"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and a date-by-category pivot on null coverage data (missing_values and total_values) in a single low-cost call. Ideal for data quality workflows where you want to clean duplicate records and immediately summarize null rates across groups and dates without any external API calls, predictions, or live data lookups. Best suited for datasets up to 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:57:50.809Z","isFirstParty":false,"canonicalSlug":"null-coverage-analytics-exact-row-deduplication-date-by-category-pivot-b5c958f3"}