{"uid":"cap_yvuSk1s6TkXMaEe4j5h9Q","slug":"supplier-qualification-duplicate-key-report-and-missing-value-fill-d39367b5","name":"Supplier Qualification Duplicate Key Report and Missing Value Fill","description":"Supplier qualification — Duplicate key report + Explicit missing-value fill: Duplicate key report + Explicit missing-value fill for supplied supplier qualification records (checked_criteria, met_criteria). 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-company-02-070?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","checked_criteria","met_criteria"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"met_criteria":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"company_group":{"type":"string","default":"","maxLength":80},"checked_criteria":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","met_criteria":1,"company_group":"group-a","checked_criteria":10},{"date":"2026-10-02","row_id":"row-2","met_criteria":2,"company_group":"group-b","checked_criteria":20},{"date":"2026-10-03","row_id":"row-3","met_criteria":3,"company_group":"group-a","checked_criteria":15},{"date":"2026-10-04","row_id":"row-4","met_criteria":4,"company_group":"group-b","checked_criteria":30}],"maxItems":200,"minItems":1},"field":{"enum":["checked_criteria","met_criteria"],"type":"string","default":"checked_criteria"},"method":{"enum":["zero","mean","median"],"type":"string","default":"median"}}},"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_5G3lfvBUOX0OURbZyI9-G","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":"Detects duplicate row_id keys and fills missing values in supplier qualification records (checked_criteria, met_criteria) using zero, mean, or median imputation","exampleAgentPrompt":"I have a batch of up to 200 supplier qualification rows with row_id, company_group, date, checked_criteria, and met_criteria — can you run a duplicate key check on them and fill any missing checked_criteria values using median imputation?","exampleUseCases":[{"title":"Procurement data cleanup before reporting","prompt":"I've got 150 supplier qualification records with row_id, company_group, date, checked_criteria, and met_criteria — some rows might have duplicate IDs and some checked_criteria values are null. Can you find the duplicates and fill the missing checked_criteria using median?"},{"title":"Auditing supplier criteria for null met_criteria","prompt":"Before I hand off our supplier qualification dataset to the finance team, I need to flag any duplicate row IDs and replace missing met_criteria values with zero. The dataset has about 80 rows with company_group, date, and both criteria columns."},{"title":"Vendor onboarding data validation","prompt":"We're onboarding new vendors and our qualification records have some gaps — can you check for duplicate row IDs across these 60 entries and fill any blank met_criteria fields using the mean of the available values?"}],"resultDescription":"Returns two independent reports: (1) a duplicate key report identifying any row_ids that appear more than once across the submitted rows, and (2) a missing value fill report showing original null values in the chosen field (checked_criteria or met_criteria) replaced by the selected imputation method (zero, mean, or median), covering up to 200 submitted rows.","failureModes":["Exceeding 200 rows causes rejection","Missing required fields (row_id, company_group, date, checked_criteria, met_criteria) causes validation error","Invalid date format (not YYYY-MM-DD) causes schema rejection","Numeric values outside ±1,000,000,000,000 range are rejected","Invalid enum value for field or method causes error","Empty rows array is rejected (minItems: 1)"],"whenToPreferThis":"Choose this endpoint when you need simultaneous duplicate key detection and missing value imputation on supplier qualification records (checked_criteria and met_criteria fields) in a single low-cost call ($0.01 USDC for both reports). It is ideal for batch data quality checks on datasets up to 200 rows before downstream analysis or reporting, with no external lookups or live data dependencies required.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:39:47.212Z","isFirstParty":false,"canonicalSlug":"supplier-qualification-duplicate-key-report-and-missing-value-fill-d39367b5"}