{"uid":"cap_lNh6F2phs-_oX0F_sD6AA","slug":"null-coverage-analytics-exact-row-deduplication-keyed-dataset-acf719fa","name":"Null Coverage Analytics: Exact Row Deduplication + Keyed Dataset Comparison","description":"Null coverage — Exact row deduplication + Keyed dataset comparison: Exact row deduplication + Keyed dataset comparison 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-053?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},"other":{"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":21},{"date":"2026-10-03","row_id":"row-3","total_values":3,"dataset_group":"group-a","missing_values":17},{"date":"2026-10-04","row_id":"row-4","total_values":4,"dataset_group":"group-b","missing_values":33}],"maxItems":200,"minItems":0}}},"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_zB88QqwXviF-8RFsNybHL","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 compares two null-coverage datasets (missing_values, total_values) using local analytical engines, returning two independent reports for up to 200 rows.","exampleAgentPrompt":"I have two versions of my null coverage records — each with row_id, dataset_group, date, missing_values, and total_values — can you deduplicate the rows in the first set and then compare both datasets to show me what changed between them? Here are the rows and the comparison set.","exampleUseCases":[{"title":"Pipeline data quality regression check","prompt":"I ran my ETL pipeline twice and want to know if the null coverage changed. Here's the first run's records and the second run's records — each has row_id, dataset_group, date, missing_values, and total_values. Can you deduplicate each set and compare them to show me which rows have different missing value counts?"},{"title":"Deduplicating a merged null coverage export","prompt":"I merged two exports of null coverage data and I'm worried there are duplicate rows. Can you deduplicate this list of records by exact row match — each record has a row_id, dataset_group, date, missing_values, and total_values — and also compare it against my reference dataset to highlight any differences?"},{"title":"Cross-team dataset consistency validation","prompt":"My team and the data engineering team each produced a null coverage snapshot for the same date range. Can you run a keyed comparison between the two sets of records — both have row_id, dataset_group, date, missing_values, and total_values — and tell me where the missing_values or total_values disagree?"}],"resultDescription":"Returns two independent analytical reports: (1) an exact row deduplication report identifying duplicate rows within the supplied dataset, and (2) a keyed dataset comparison report highlighting rows that differ between the 'rows' and 'other' input arrays based on row_id and other key fields, including discrepancies in missing_values and total_values. No external lookups or predictions are made; all analysis uses local engines.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, dataset_group, date, missing_values, total_values) on any row — validation error","Date field does not match YYYY-MM-DD pattern — schema validation failure","Numeric values outside allowed range (-1e12 to 1e12) — validation error","Empty rows array (minItems: 1 violated) — request rejected","Payment not included or insufficient USDC — x402 payment required error"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and a keyed comparison of two null-coverage datasets in a single paid call, and your dataset is up to 200 rows. It is ideal for data quality workflows where you want to validate consistency between two pipeline runs or dataset versions without sending data to an external ML or prediction service — all analysis is local and deterministic.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:57:55.654Z","isFirstParty":false,"canonicalSlug":"null-coverage-analytics-exact-row-deduplication-keyed-dataset-acf719fa"}