{"uid":"cap_UVbrx73Sd6PIj7tkYGNJW","slug":"numeric-precision-comparisons-duplicate-key-report-trailing-mean-series-bb21d6f2","name":"Numeric Precision Comparisons — Duplicate Key Report + Trailing Mean Series","description":"Numeric precision comparisons — Duplicate key report + Trailing mean series: Duplicate key report + Trailing mean series for supplied numeric precision comparisons records (source_value, transformed_value). 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-20-061?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","source_value","transformed_value"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_value":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"transformed_value":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source_value":10,"dataset_group":"group-a","transformed_value":1},{"date":"2026-10-02","row_id":"row-2","source_value":20,"dataset_group":"group-b","transformed_value":2},{"date":"2026-10-03","row_id":"row-3","source_value":15,"dataset_group":"group-a","transformed_value":3},{"date":"2026-10-04","row_id":"row-4","source_value":30,"dataset_group":"group-b","transformed_value":4}],"maxItems":200,"minItems":1},"field":{"enum":["source_value","transformed_value"],"type":"string","default":"source_value"},"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_nRdwrLwW13u9otnHblK-t","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 up to 200 rows of source/transformed numeric pairs to produce a duplicate key report and a trailing mean series for a chosen field.","exampleAgentPrompt":"Can you run a duplicate key report and a trailing mean series on this dataset — I have 50 rows each with a row_id, dataset_group, date, source_value, and transformed_value, and I want the trailing mean computed on source_value with a window of 3?","exampleUseCases":[{"title":"ETL pipeline duplicate key audit","prompt":"I just ran an ETL transform and I want to check whether any row_id values appear more than once across my source and transformed value pairs — can you run a duplicate key report on these 120 rows?"},{"title":"Rolling average for financial precision check","prompt":"I have 80 rows of source vs. transformed financial figures by date and dataset group — can you compute a trailing mean series on the transformed_value column with a window of 5 so I can spot drift?"},{"title":"Data quality validation before database load","prompt":"Before I load this numeric dataset into the database, can you give me both a duplicate row ID report and a rolling mean on source_value with a window of 4 for these 150 records so I can catch any anomalies?"}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying any row_ids that appear more than once across the supplied rows, and (2) a trailing mean series computed over the chosen field (source_value or transformed_value) using the specified window size. Both reports are derived entirely from the supplied data with no external lookups.","failureModes":["Fewer than 1 row supplied — returns validation error","More than 200 rows submitted — request rejected with max-items error","Invalid date format (not YYYY-MM-DD) — schema validation failure","window value outside 2–200 range — rejected with bounds error","Numeric values outside ±1,000,000,000,000 — schema validation failure","Missing required fields (row_id, dataset_group, date, source_value, transformed_value) — rejected"],"whenToPreferThis":"Choose this endpoint when you need both a duplicate key check and a rolling/trailing mean computed in a single call over a batch of up to 200 numeric source-vs-transformed records, without needing any external data sources, live lookups, or predictions. It is ideal for ETL validation workflows, data quality checks before loading, and quick analytical summaries of numeric precision comparison datasets.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:51.401Z","isFirstParty":false,"canonicalSlug":"numeric-precision-comparisons-duplicate-key-report-trailing-mean-series-bb21d6f2"}