{"uid":"cap_mMQgnyOfBhFEixLp68XdG","slug":"supplier-qualification-date-by-category-pivot-with-missing-value-fill-b99d6343","name":"Supplier Qualification Date-by-Category Pivot with Missing-Value Fill","description":"Supplier qualification — Date by category pivot + Explicit missing-value fill: Date by category pivot + 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-189?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_PAUKRH2Tbib_5oibEypJr","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":"Pivots supplier qualification records by date and category, filling missing values explicitly, for up to 200 rows across two analytical reports.","exampleAgentPrompt":"I have up to 200 supplier qualification rows with row_id, company_group, date, checked_criteria, and met_criteria — can you pivot them by date and category and fill any missing checked_criteria values using the median method?","exampleUseCases":[{"title":"Quarterly supplier criteria pivot report","prompt":"I have this quarter's supplier qualification records for group-a and group-b — can you pivot the met_criteria field by date and company group, filling any gaps with the mean, for all 150 rows I'm sending?"},{"title":"Missing-value imputation before audit","prompt":"Before our audit, I need to clean up our supplier data — can you take these 80 qualification rows and fill in any null checked_criteria values using median imputation, then give me the date-by-category pivot?"},{"title":"Compare two criteria fields across supplier groups","prompt":"Can you run two reports on our 60 supplier qualification records — one pivoting checked_criteria by date and company group, and one doing the same for met_criteria, filling zeros for any missing entries?"}],"resultDescription":"Two analytical reports derived from the supplied rows: (1) a date-by-category pivot of the selected field (checked_criteria or met_criteria) across company groups, and (2) the same dataset with missing values explicitly filled using the chosen method (zero, mean, or median). No external lookups or live data are involved.","failureModes":["Input array is empty or exceeds 200 rows — validation error returned","Required fields (row_id, company_group, date, checked_criteria, met_criteria) missing from one or more rows — row rejected or error","Date strings not matching YYYY-MM-DD pattern — pattern validation failure","Numeric values outside allowed range (-1,000,000,000,000 to 1,000,000,000,000) — schema rejection","Invalid enum value for field or method parameters — schema validation error","Payment not received or insufficient — x402 payment required response"],"whenToPreferThis":"Choose this endpoint when you have up to 200 supplier qualification records with date and company group dimensions and need both a pivot table and missing-value-imputed output in one call. It is ideal for lightweight, local analytical transformations without requiring an external BI tool, database, or live data connection. Prefer it when you need two reports (pivot + fill) cheaply and quickly from pre-assembled row data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:39:11.104Z","isFirstParty":false,"canonicalSlug":"supplier-qualification-date-by-category-pivot-with-missing-value-fill-b99d6343"}