{"uid":"cap_rQsJZsSEWGe4tpKAvcSBV","slug":"numeric-precision-comparisons-exact-row-deduplication-equal-width-15f26dc3","name":"Numeric Precision Comparisons — Exact Row Deduplication + Equal-Width Histogram","description":"Numeric precision comparisons — Exact row deduplication + Equal-width histogram: Exact row deduplication + Equal-width histogram 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-048?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"bins":{"type":"integer","default":5,"maximum":30,"minimum":1},"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_ykQv0sH9VwqAWn_3Y-ugQ","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 numeric comparison rows: exact duplicate row detection and an equal-width histogram distribution over a chosen numeric field.","exampleAgentPrompt":"I have up to 200 rows of source_value vs transformed_value pairs — can you run an exact duplicate row check and an equal-width histogram (10 bins) over the source_value field for me? The rows include row_id, dataset_group, date, source_value, and transformed_value.","exampleUseCases":[{"title":"ETL pipeline deduplication audit","prompt":"I just ran a data transformation job and I want to check whether any rows came out identical — can you run a deduplication report on these 150 rows of source and transformed values, and also show me a histogram of the source_value field with 8 bins so I can see the distribution?"},{"title":"Numeric transformation quality check","prompt":"Here are 80 records from my data pipeline with source_value and transformed_value fields — can you find any exact duplicate rows and give me an equal-width histogram over transformed_value using 5 bins?"},{"title":"Dataset group distribution analysis","prompt":"I have 120 comparison rows across two dataset groups from 2024-01-01 to 2024-03-31 and I need to know if there are any exact row duplicates, plus a histogram of source_value in 10 bins to understand how values are spread."}],"resultDescription":"Returns two independent reports: (1) an exact row deduplication report identifying any fully duplicate rows across all supplied fields, and (2) an equal-width histogram showing bin boundaries and row counts for the selected numeric field (source_value or transformed_value), computed locally with no external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required row fields (row_id, dataset_group, date, source_value, transformed_value) causes rejection","Invalid date format (not YYYY-MM-DD) fails schema validation","bins value outside 1–30 range is rejected","Values outside ±1,000,000,000,000 are rejected","Sending an empty rows array returns an error"],"whenToPreferThis":"Choose this endpoint when you need two specific offline analytical reports — exact row deduplication and equal-width histogram — over a small dataset (up to 200 rows) of numeric source/transformed value pairs, without any need for external data, predictions, or live lookups. It is ideal for ETL validation, data quality audits, or numeric transformation QA workflows where you want both a duplicate check and a distribution view in a single low-cost call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:55.145Z","isFirstParty":false,"canonicalSlug":"numeric-precision-comparisons-exact-row-deduplication-equal-width-15f26dc3"}