{"uid":"cap_7jenezgC6NEQCVya82n7Z","slug":"duplicate-observations-analytics-record-quality-audit-string-dd4005d5","name":"Duplicate Observations Analytics — Record Quality Audit, String Normalisation & Keyed Dataset Comparison","description":"Duplicate observations — Record quality audit + String normalisation + Keyed dataset comparison: Record quality audit + String normalisation + Keyed dataset comparison for supplied duplicate observations records (duplicate_rows, total_rows). Up to 200 rows; 3 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 3 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-analytics-04-207?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","duplicate_rows","total_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"total_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"duplicate_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","total_rows":1,"dataset_group":"group-a","duplicate_rows":10},{"date":"2026-10-02","row_id":"row-2","total_rows":2,"dataset_group":"group-b","duplicate_rows":20},{"date":"2026-10-03","row_id":"row-3","total_rows":3,"dataset_group":"group-a","duplicate_rows":15},{"date":"2026-10-04","row_id":"row-4","total_rows":4,"dataset_group":"group-b","duplicate_rows":30}],"maxItems":200,"minItems":1},"other":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","duplicate_rows","total_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"total_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"duplicate_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","total_rows":1,"dataset_group":"group-a","duplicate_rows":10},{"date":"2026-10-02","row_id":"row-2","total_rows":2,"dataset_group":"group-b","duplicate_rows":21},{"date":"2026-10-03","row_id":"row-3","total_rows":3,"dataset_group":"group-a","duplicate_rows":17},{"date":"2026-10-04","row_id":"row-4","total_rows":4,"dataset_group":"group-b","duplicate_rows":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_eC9GrZwhJ1zspPXccA03H","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":"Runs three independent analytical reports (record quality audit, string normalisation, and keyed dataset comparison) on up to 200 duplicate-observation records containing duplicate_rows and total_rows fields.","exampleAgentPrompt":"Can you run a full quality audit, string normalisation, and keyed comparison on my two duplicate-observation datasets? The first dataset has rows like row-1 on 2026-10-01 in group-a with 10 duplicate_rows out of 1 total_rows, and I want to compare it against a second dataset with slightly different duplicate counts for the same row IDs.","exampleUseCases":[{"title":"Pipeline deduplication output validation","prompt":"I've got two snapshots of my ETL pipeline's duplicate detection results — one from before tuning and one after — each with up to 50 rows tracking duplicate_rows and total_rows per dataset_group and date. Can you run a quality audit, string normalisation, and keyed comparison between the two so I can see what changed?"},{"title":"Cross-team dataset duplicate discrepancy check","prompt":"My team and the data engineering team produced separate duplicate-observation exports for the same dataset groups and dates. Can you compare the two sets — each up to 100 rows with row_id, dataset_group, date, duplicate_rows, and total_rows — and give me a record quality audit and keyed comparison report showing where the counts differ?"},{"title":"Monthly duplicate rate quality review","prompt":"I need a record quality audit and string normalisation report on my monthly duplicate tracking data — about 80 rows covering different dataset_groups through October 2026, each with duplicate_rows and total_rows counts. Can you flag any quality issues or malformed string fields?"}],"resultDescription":"Returns three independent analytical reports: (1) a record quality audit flagging issues such as null values, out-of-range counts, or suspicious duplicate_rows/total_rows ratios; (2) a string normalisation report covering dataset_group and other string fields; and (3) a keyed dataset comparison report matching records from the 'rows' and 'other' input arrays by row_id to surface discrepancies in duplicate_rows and total_rows values. All analysis is performed locally with no external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) — validation error","Invalid date format (must be YYYY-MM-DD) — schema validation failure","Numeric values outside allowed range (-1e12 to 1e12) — schema rejection","Empty rows array (minItems:1 not satisfied) — bad request","Mismatched row_id keys between rows and other arrays — comparison report may show unmatched records"],"whenToPreferThis":"Choose this endpoint when you need a bundled set of three analytical reports — quality audit, string normalisation, and keyed comparison — specifically for duplicate-observation records with duplicate_rows and total_rows fields, at low cost ($0.01 USDC for all three reports on up to 200 rows). It is ideal when you want local, offline analysis with no external data lookups, and when you have two parallel datasets to compare by key. Prefer alternatives if you need real-time deduplication, live database queries, or analysis of datasets larger than 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T07:14:54.851Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-analytics-record-quality-audit-string-dd4005d5"}