{"uid":"cap_EYwBFPfxe_Mn2GEH6djmx","slug":"supplier-qualification-exact-row-deduplication-explicit-missing-value-46d9c877","name":"Supplier Qualification — Exact Row Deduplication + Explicit Missing-Value Fill","description":"Supplier qualification — Exact row deduplication + Explicit missing-value fill: Exact row deduplication + 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-054?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_7_Ce2s2nSw4PEXxqRZGqU","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":"Deduplicates exact rows and fills missing values in supplier qualification records (checked_criteria, met_criteria) for up to 200 rows, returning 2 analytical reports.","exampleAgentPrompt":"Can you clean this supplier qualification dataset — remove any exact duplicate rows and fill missing checked_criteria values using the median method? I have about 50 rows with company_group, date, checked_criteria, and met_criteria fields.","exampleUseCases":[{"title":"Deduplicate supplier batch before scoring","prompt":"I have a batch of 120 supplier qualification rows from our procurement system that likely has duplicate entries — can you remove the exact duplicate rows and fill any missing checked_criteria values using the median, then give me the cleaned report?"},{"title":"Impute missing met_criteria for quarterly review","prompt":"Our Q3 supplier qualification export has null values in met_criteria across several company groups — please fill those nulls using the mean method and deduplicate the records so our data is clean before the quarterly review."},{"title":"Normalize zero-fill for supplier compliance records","prompt":"I need to prep our supplier compliance data before uploading it to our dashboard — fill any missing checked_criteria values with zero and strip out exact duplicate rows for these 80 records across group-a and group-b."}],"resultDescription":"Returns 2 independent reports covering: (1) exact row deduplication results showing which rows were removed as duplicates, and (2) a missing-value fill report showing which cells in checked_criteria or met_criteria were null and what values were imputed using the chosen method (zero, mean, or median). No external data is fetched; all analysis is performed on the supplied rows.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, company_group, date) on any row — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Invalid method enum value (not zero/mean/median) — rejected","Invalid field enum value (not checked_criteria/met_criteria) — rejected","Empty rows array — minItems violation"],"whenToPreferThis":"Choose this endpoint when you have a tabular supplier qualification dataset (up to 200 rows) with potential exact duplicates and/or null numeric values in checked_criteria or met_criteria, and you need a fast, offline data cleaning step before downstream analysis. It is ideal for procurement pipelines that need deterministic deduplication and imputation without any external lookup, ML prediction, or live data access. Not suitable for fuzzy deduplication, large datasets over 200 rows, or enrichment from external supplier databases.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:16.195Z","isFirstParty":false,"canonicalSlug":"supplier-qualification-exact-row-deduplication-explicit-missing-value-46d9c877"}