{"uid":"cap_fVHkdTmtU4EM92m0psEQi","slug":"duplicate-observations-deduplication-and-trailing-mean-analytics-924324f0","name":"Duplicate Observations Deduplication and Trailing Mean Analytics","description":"Duplicate observations — Exact row deduplication + Trailing mean series: Exact row deduplication + Trailing mean series for supplied duplicate observations records (duplicate_rows, total_rows). 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-04-045?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_lRJ3n1KkfOkQ0qrgAKsB0","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 exact row deduplication stats and a trailing mean time series for up to 200 rows.","exampleAgentPrompt":"I have 4 rows of duplicate-observation data for groups A and B from October 2026 — can you run the exact row deduplication report and compute a trailing mean with a window of 2 for the duplicate_rows field?","exampleUseCases":[{"title":"Data quality audit for ETL pipeline","prompt":"I've got a week's worth of records from two dataset groups showing duplicate_rows and total_rows counts per day — can you run exact row deduplication and a trailing mean with a window of 3 on the duplicate_rows field so I can see where data quality is degrading?"},{"title":"Rolling average of total rows over time","prompt":"Here are 10 daily observation records across three dataset groups with their total_rows counts. Can you compute a trailing mean with a window of 5 on the total_rows field and also give me the deduplication report?"},{"title":"Spot-checking duplicate density in a dataset snapshot","prompt":"I have a snapshot of 50 rows from my analytics dataset with duplicate_rows and total_rows for each record. Run the exact row deduplication analysis and a 2-period trailing mean on duplicate_rows so I can report on data hygiene."}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication summary identifying duplicate records within the supplied data, and (2) a trailing mean time series computed over the specified window for the chosen field (duplicate_rows or total_rows), covering up to 200 input rows.","failureModes":["Input array empty or missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows)","More than 200 rows submitted — exceeds maxItems limit","Window size outside valid range (must be 2–200)","Invalid date format — must match YYYY-MM-DD pattern","Payment not provided or insufficient — x402 protocol requires 0.01 USDC per call"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication statistics and a trailing mean time series computed from supplied duplicate-observation records in a single call. It is well-suited for offline or batch data quality audits where you already have the data locally and need structured analytical output without live lookup or external data sources. Use it when your dataset is 200 rows or fewer and you want two independent reports (deduplication + rolling mean) from a single low-cost API call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:57:53.743Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-deduplication-and-trailing-mean-analytics-924324f0"}