{"uid":"cap_mrHrauFYUYphgBmtVGEI9","slug":"data-collection-completeness-exact-row-deduplication-numeric-339ed481","name":"Data Collection Completeness — Exact Row Deduplication + Numeric Distribution","description":"Data collection completeness — Exact row deduplication + Numeric distribution: Exact row deduplication + Numeric distribution for supplied data collection completeness records (observed_values, expected_values). 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-education-22-039?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","course_group","date","observed_values","expected_values"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"course_group":{"type":"string","default":"","maxLength":80},"expected_values":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"observed_values":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","course_group":"group-a","expected_values":1,"observed_values":10},{"date":"2026-10-02","row_id":"row-2","course_group":"group-b","expected_values":2,"observed_values":20},{"date":"2026-10-03","row_id":"row-3","course_group":"group-a","expected_values":3,"observed_values":15},{"date":"2026-10-04","row_id":"row-4","course_group":"group-b","expected_values":4,"observed_values":30}],"maxItems":200,"minItems":1},"field":{"enum":["observed_values","expected_values"],"type":"string","default":"observed_values"}}},"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_qlyk9nZv2Qi-QRyMoptea","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 education data collection completeness records: exact row deduplication and numeric distribution analysis for observed vs. expected values, across up to 200 rows.","exampleAgentPrompt":"Can you run deduplication and numeric distribution analysis on my education data completeness records? I have rows with course_group, date, observed_values, and expected_values — I want to analyze the observed_values field across up to 50 rows to spot duplicates and understand the value spread.","exampleUseCases":[{"title":"Course completion data audit","prompt":"I have a dataset of up to 80 rows tracking observed vs expected completions per course group by date — can you deduplicate the records and show me the numeric distribution of observed_values so I can spot anomalies?"},{"title":"Expected enrollment targets distribution check","prompt":"Run a numeric distribution and exact deduplication report on my education data completeness rows using the expected_values field — I have about 120 rows with course_group and date fields included."},{"title":"Multi-group data quality review","prompt":"I need to check data quality across my course group completeness records — please deduplicate the rows and give me a distribution breakdown of observed_values for these 60 records so I can see if anything looks off."}],"resultDescription":"Two analytical reports: (1) an exact row deduplication report identifying duplicate records in the submitted dataset, and (2) a numeric distribution summary for the selected field (observed_values or expected_values), covering statistics such as frequency, spread, and value ranges — all computed locally on the supplied data with no external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, date, observed_values, expected_values) causes schema rejection","Invalid date format (not YYYY-MM-DD) fails pattern validation","Numeric values outside ±1,000,000,000,000 are rejected","Empty rows array is not accepted (minItems: 1)","Invalid field enum value (anything other than observed_values or expected_values) causes error"],"whenToPreferThis":"Choose this endpoint when you need lightweight, local deduplication and numeric distribution analysis specifically on education data completeness records (observed vs. expected values) without any external data lookups or predictions. Ideal for small-to-medium batches (up to 200 rows) where you want two bundled analytical reports at low cost ($0.01 USDC). Prefer this over general-purpose analytics when your data is already structured with course_group, date, and observed/expected value fields and you want a quick completeness audit.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T12:33:05.543Z","isFirstParty":false,"canonicalSlug":"data-collection-completeness-exact-row-deduplication-numeric-339ed481"}