{"uid":"cap_tYRbbj8IIkLPtHn0asjxr","slug":"data-catalog-coverage-exact-row-deduplication-secondary-measure-3f6f6c23","name":"Data Catalog Coverage — Exact Row Deduplication + Secondary-Measure Weighted Mean","description":"Data catalog coverage — Exact row deduplication + Secondary-measure weighted mean: Exact row deduplication + Secondary-measure weighted mean for supplied data catalog coverage records (documented_fields, total_fields). 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-21-051?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","documented_fields","total_fields"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"total_fields":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"documented_fields":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","total_fields":1,"dataset_group":"group-a","documented_fields":10},{"date":"2026-10-02","row_id":"row-2","total_fields":2,"dataset_group":"group-b","documented_fields":20},{"date":"2026-10-03","row_id":"row-3","total_fields":3,"dataset_group":"group-a","documented_fields":15},{"date":"2026-10-04","row_id":"row-4","total_fields":4,"dataset_group":"group-b","documented_fields":30}],"maxItems":200,"minItems":1},"field":{"enum":["documented_fields","total_fields"],"type":"string","default":"documented_fields"}}},"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_0HEhmDI96h7QqzwmX0n5C","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 rows and computes a secondary-measure weighted mean for data catalog coverage records (documented_fields, total_fields) across up to 200 rows in two independent reports.","exampleAgentPrompt":"Can you deduplicate these catalog coverage records and give me a weighted mean of documented_fields? I have 4 rows across two groups — group-a and group-b — with dates ranging from 2026-10-01 to 2026-10-04, and I want to analyze the documented_fields metric.","exampleUseCases":[{"title":"Data catalog documentation audit","prompt":"I have about 150 catalog coverage records across several dataset groups with documented_fields and total_fields counts — can you deduplicate them and compute a weighted mean so I can see how well-documented my datasets actually are? Use documented_fields as the primary metric."},{"title":"Identifying duplicate coverage entries","prompt":"We've been ingesting catalog coverage logs from multiple pipelines and I suspect there are duplicate rows by row_id. Can you run exact row deduplication on these 80 records and also give me a weighted mean of total_fields grouped by dataset_group?"},{"title":"Weekly coverage completeness summary","prompt":"Here are this week's data catalog coverage records — about 60 rows with documented_fields and total_fields — please deduplicate and give me the secondary-measure weighted mean report so I can track documentation completeness trends across our dataset groups."}],"resultDescription":"Two independent analytical reports: (1) exact row deduplication results showing which rows were removed and the cleaned dataset, and (2) a secondary-measure weighted mean computed over the specified field (documented_fields or total_fields) across the supplied rows, up to 200 rows total.","failureModes":["More than 200 rows submitted — request exceeds maxItems limit","Missing required fields (row_id, date, dataset_group) causes validation error","Invalid date format (non-YYYY-MM-DD) rejected by pattern validation","Null values in both documented_fields and total_fields may affect weighted mean computation","Field enum value other than 'documented_fields' or 'total_fields' causes schema rejection"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and a weighted mean computation on data catalog coverage metrics (documented_fields, total_fields) in a single low-cost call. It is ideal for small to medium catalog datasets (up to 200 rows) where you want local analytical processing without external lookups, predictions, or live data access. Prefer alternatives if you need more than 200 rows, live data enrichment, or metrics beyond field coverage.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:53:17.746Z","isFirstParty":false,"canonicalSlug":"data-catalog-coverage-exact-row-deduplication-secondary-measure-3f6f6c23"}