{"uid":"cap_oDCQ81diQ_jzBPnj7j4lX","slug":"numeric-precision-comparisons-exact-row-deduplication-numeric-5a61fcb6","name":"Numeric Precision Comparisons — Exact Row Deduplication + Numeric Distribution","description":"Numeric precision comparisons — Exact row deduplication + Numeric distribution: Exact row deduplication + Numeric distribution 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-039?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"}}},"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_8rHI9RlZpUGLMZ4Km3ORM","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 two local analytical reports on supplied source/transformed numeric value pairs: exact row deduplication and numeric distribution analysis, for up to 200 rows.","exampleAgentPrompt":"I have up to 200 rows of source-to-transformed numeric comparison records — each with a row_id, dataset_group, date, source_value, and transformed_value — can you run exact row deduplication and a numeric distribution report on the source_value field for me?","exampleUseCases":[{"title":"ETL pipeline output deduplication check","prompt":"I just ran an ETL job and I have a table of up to 150 rows with source_value and transformed_value pairs, each tagged with a row_id, dataset_group, and date. Can you run exact row deduplication on them and also give me the numeric distribution of the source_value field so I can spot anomalies?"},{"title":"Data quality audit across dataset groups","prompt":"I need a data quality check on my comparison records — I have around 80 rows split across two dataset groups with source and transformed values. Please deduplicate the rows exactly and show me the numeric distribution for transformed_value across all the rows."},{"title":"Precision transformation validation","prompt":"After applying a numeric precision transformation to my dataset, I want to check for any exact duplicate rows and understand the statistical distribution of the source_value field. I have 60 rows with row_id, date, dataset_group, source_value, and transformed_value — can you run both reports?"}],"resultDescription":"Returns two independent analytical reports: (1) an exact row deduplication report identifying duplicate records across the supplied rows, and (2) a numeric distribution report summarizing the statistical spread and distribution characteristics of the selected numeric field (source_value or transformed_value). Both reports are computed locally with no external lookups or predictions.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, dataset_group, date, source_value, transformed_value) on any row — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Numeric values outside allowed range (-1,000,000,000,000 to 1,000,000,000,000) — schema rejection","Empty rows array — minItems violation","Invalid field selector (must be 'source_value' or 'transformed_value') — enum validation error"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously run exact deduplication and numeric distribution analysis on a batch of numeric precision comparison records (source vs transformed values) without any external data lookups or predictions. It is ideal for data quality checks on ETL pipeline outputs, transformation validation, or any scenario where you have up to 200 paired numeric records and need both reports in a single $0.01 call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:39:40.522Z","isFirstParty":false,"canonicalSlug":"numeric-precision-comparisons-exact-row-deduplication-numeric-5a61fcb6"}