{"uid":"cap_lX_ZBrT-L36NKd9uFrrOD","slug":"duplicate-observations-analytics-record-quality-audit-string-ea8a0dd2","name":"Duplicate Observations Analytics — Record Quality Audit, String Normalisation & Trailing Mean Series","description":"Duplicate observations — Record quality audit + String normalisation + Trailing mean series: Record quality audit + String normalisation + Trailing mean series 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-199?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},"field":{"enum":["duplicate_rows","total_rows"],"type":"string","default":"duplicate_rows"},"window":{"type":"integer","default":2,"maximum":200,"minimum":2}}},"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_-kAbukaezdirRL3qy_FsU","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 local analytical reports (record quality audit, string normalisation, and trailing mean series) on up to 200 rows of duplicate-observation data containing duplicate_rows and total_rows counts.","exampleAgentPrompt":"Can you run the three analytics reports — record quality audit, string normalisation, and trailing mean series — on my duplicate observations data? I have 4 rows for groups 'group-a' and 'group-b' from 2026-10-01 to 2026-10-04, with duplicate_rows values of 10, 20, 15, and 30 against total_rows of 1, 2, 3, and 4. Use 'duplicate_rows' as the field and a window of 2.","exampleUseCases":[{"title":"Data pipeline duplicate rate audit","prompt":"I've got a batch of 50 date-stamped records across four dataset groups, each with a duplicate_rows and total_rows count. Can you run the record quality audit and string normalisation reports on them using a trailing mean window of 3 over the duplicate_rows field?"},{"title":"Trailing mean trend analysis for deduplication","prompt":"Here are 100 rows of duplicate observation data spanning three months for groups like 'sales' and 'marketing' — can you compute a trailing mean series with a window of 5 over the total_rows field and include the quality audit?"},{"title":"Dataset group string consistency check","prompt":"I suspect the dataset_group labels in my 30 duplicate-observation records are inconsistently capitalised or spaced. Can you run the string normalisation report alongside the record quality audit so I can see what needs cleaning?"}],"resultDescription":"Three independent analytical reports: (1) a record quality audit flagging issues in the supplied rows, (2) a string normalisation report identifying and correcting inconsistencies in string fields like dataset_group, and (3) a trailing mean series computed over the chosen numeric field (duplicate_rows or total_rows) using the specified window size. All reports are computed locally from the supplied data with no external lookups.","failureModes":["More than 200 rows submitted — exceeds maxItems limit and will be rejected","Invalid date format not matching YYYY-MM-DD pattern","Window value outside the 2–200 integer range","Numeric values for duplicate_rows or total_rows outside the allowed ±1,000,000,000,000 range","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) on any row","Invalid field enum — must be exactly 'duplicate_rows' or 'total_rows'","Payment failure via x402 protocol preventing execution"],"whenToPreferThis":"Choose this endpoint when you need three simultaneous analytical reports on duplicate-observation data in a single low-cost call — specifically record quality auditing, string normalisation of group labels, and a trailing moving average — without requiring any external lookups, predictions, or live data. It is best suited for data engineers auditing ETL pipeline output, analysts reviewing deduplication metrics over time, or automated agents performing scheduled data quality checks on batch record sets of up to 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T07:19:37.738Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-analytics-record-quality-audit-string-ea8a0dd2"}