{"uid":"cap_EVLhTCS85wnv4h13xoMuT","slug":"duplicate-observations-record-quality-audit-string-normalisation-b4f8862b","name":"Duplicate Observations — Record Quality Audit, String Normalisation & Duplicate Key Report","description":"Duplicate observations — Record quality audit + String normalisation + Duplicate key report: Record quality audit + String normalisation + Duplicate key report 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-192?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}}},"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__TASko3EXytMi-MZyfKt2","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 supplied duplicate-observation records to produce three local analytical reports: a record quality audit, string normalization output, and a duplicate key report — all without external lookups or live data.","exampleAgentPrompt":"Run a record quality audit, string normalization, and duplicate key report on my observation dataset — I have 4 rows: row-1 for group-a on 2026-10-01 with 10 duplicates out of 1 total, row-2 for group-b on 2026-10-02 with 20 duplicates out of 2 total, row-3 for group-a on 2026-10-03 with 15 duplicates out of 3 total, and row-4 for group-b on 2026-10-04 with 30 duplicates out of 4 total.","exampleUseCases":[{"title":"ETL pipeline duplicate rate audit","prompt":"I just loaded 150 observation records into my pipeline — each has a row ID, dataset group, date, and duplicate and total row counts. Can you run all three reports (quality audit, string normalization, duplicate key report) on them so I can see where duplicates are concentrated and whether any group names need cleaning?"},{"title":"Daily data quality check for grouped observations","prompt":"Every morning I want to audit yesterday's observation batch for duplicate keys and string inconsistencies. Here are 80 rows, each tagged with a row ID, a dataset group like 'group-a' or 'Group A', a date, and their duplicate_rows vs total_rows counts — run the full quality audit and normalization report."},{"title":"Pre-analysis deduplication report for a small dataset","prompt":"Before I run my analysis, can you check these 25 observation records for duplicate keys and normalize the dataset group strings? Each row has an ID, group name, date in YYYY-MM-DD format, and counts of duplicate rows versus total rows."}],"resultDescription":"Returns three independent reports for the submitted rows (up to 200): (1) a record quality audit flagging data integrity issues, (2) a string normalization report cleaning and standardizing text fields like dataset_group, and (3) a duplicate key report identifying rows with matching or suspicious key combinations — all computed locally with no external calls.","failureModes":["More than 200 rows submitted — request will be rejected or truncated","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) causes validation errors","date field not matching YYYY-MM-DD pattern causes schema rejection","duplicate_rows or total_rows values outside allowed numeric range cause errors","Empty rows array (minItems: 1 violated) causes rejection","Payment not fulfilled — x402 payment required before processing"],"whenToPreferThis":"Choose this endpoint when you have up to 200 pre-collected observation records with duplicate counts and need three bundled analytical reports (quality audit, string normalization, duplicate key detection) in a single low-cost call. It is ideal for lightweight, offline-style data quality checks on batch observation data where no live external lookup, prediction, or professional assessment is needed. It is not suitable for datasets exceeding 200 rows or for use cases requiring real-time streaming analysis or ML-based anomaly detection.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T07:12:09.026Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-record-quality-audit-string-normalisation-b4f8862b"}