{"uid":"cap_Kp3o1Pk2AxyXH6oeHxhXi","slug":"numeric-precision-comparisons-exact-row-deduplication-trailing-mean-b2c7e0a1","name":"Numeric Precision Comparisons — Exact Row Deduplication + Trailing Mean Series","description":"Numeric precision comparisons — Exact row deduplication + Trailing mean series: Exact row deduplication + 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-045?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_GjhbLU5KHn3WJcfnnFZEb","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":"Performs exact row deduplication and trailing moving-average computation on numeric source/transformed value pairs for up to 200 rows.","exampleAgentPrompt":"I have 150 rows of source vs transformed numeric values across two groups — can you run exact row deduplication and a trailing mean series with a window of 5 on the source_value field? Each row has a row_id, dataset_group, and date.","exampleUseCases":[{"title":"ETL pipeline deduplication audit","prompt":"I just ran my ETL pipeline and have 120 rows with source_value and transformed_value fields — can you deduplicate them exactly and also compute a trailing mean with a window of 3 on source_value to spot any smoothed trends?"},{"title":"Numeric transformation accuracy review","prompt":"I need to audit 80 records from our data transformation job — run exact row deduplication and generate a trailing mean series with window 4 on the transformed_value field so I can see where values are drifting."},{"title":"Financial data reconciliation check","prompt":"Here are 200 rows of financial source and transformed values by date and group — please deduplicate any exact duplicates and show me a rolling mean series with window 7 on source_value to help me spot anomalies."}],"resultDescription":"Returns two independent analytical reports: (1) an exact row deduplication report identifying fully duplicated rows across the supplied dataset, and (2) a trailing mean series computed over the specified field using the given window size, covering up to 200 input rows.","failureModes":["Fewer than 1 row supplied — rejected by minItems constraint","More than 200 rows supplied — rejected by maxItems constraint","Invalid date format (not YYYY-MM-DD) — schema validation failure","source_value or transformed_value outside [-1e12, 1e12] range — rejected","window value less than 2 or greater than 200 — schema validation failure","field value not one of 'source_value' or 'transformed_value' — enum validation failure","Missing required fields (row_id, dataset_group, date) — rejected"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and trailing moving-average analysis on a set of numeric source/transformed value pairs in a single call. It is ideal for data quality auditing of transformation pipelines, ETL validation, or any scenario where you have paired numeric records and want to identify redundancy while also computing smoothed trends — all without needing an external data connection or prediction service.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:39:48.250Z","isFirstParty":false,"canonicalSlug":"numeric-precision-comparisons-exact-row-deduplication-trailing-mean-b2c7e0a1"}