{"uid":"cap_gqkg1bibjGBOacTnxu8cq","slug":"contract-renewal-inventories-category-frequencies-missing-value-fill-cd4e3fec","name":"Contract Renewal Inventories — Category Frequencies & Missing-Value Fill","description":"Contract renewal inventories — Category frequencies + Explicit missing-value fill: Category frequencies + Explicit missing-value fill for supplied contract renewal inventories records (expiring_contracts, renewed_contracts). 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-20-112?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","expiring_contracts","renewed_contracts"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"company_group":{"type":"string","default":"","maxLength":80},"renewed_contracts":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"expiring_contracts":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","renewed_contracts":1,"expiring_contracts":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","renewed_contracts":2,"expiring_contracts":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","renewed_contracts":3,"expiring_contracts":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","renewed_contracts":4,"expiring_contracts":30}],"maxItems":200,"minItems":1},"field":{"enum":["expiring_contracts","renewed_contracts"],"type":"string","default":"expiring_contracts"},"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_di260PbxClEQorsSHS9X7","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":"Computes category frequency distributions and fills missing values in contract renewal inventory records (expiring and renewed contracts) for up to 200 rows, returning two independent analytical reports.","exampleAgentPrompt":"Can you analyze my contract renewal data for groups A and B across October 2026 — give me the category frequencies for expiring_contracts and fill any missing values using the median method? I have about 4 rows.","exampleUseCases":[{"title":"Frequency audit of expiring contracts by group","prompt":"I have a dataset of contract renewals across different company groups for Q4. Can you compute the category frequencies for the expiring_contracts field and fill any missing values using the median? Here are the rows: group-a on 2026-10-01 had 10 expiring and 1 renewed, group-b on 2026-10-02 had 20 expiring and 2 renewed, group-a on 2026-10-03 had 15 expiring and null renewed."},{"title":"Null imputation for renewed contracts reporting","prompt":"My renewals tracking spreadsheet has some null entries in the renewed_contracts column. Can you fill those missing values using zero and also show me the category frequency breakdown by company_group? I'll send you the rows — up to 50 records from November 2026."},{"title":"Monthly contract renewal data quality check","prompt":"Before I send this contract renewal inventory to our dashboard, can you run a category frequency analysis on the renewed_contracts field and fill any gaps using mean imputation? I have about 120 rows with dates in 2026 and groups like enterprise, smb, and startup."}],"resultDescription":"Returns two reports: (1) a category frequency table showing how often each company_group or category value appears in the selected field, and (2) the dataset with missing values in the specified field replaced using the chosen fill method (zero, mean, or median). Both reports are computed locally with no external lookups.","failureModes":["Rows array is empty or exceeds 200 items — rejected with validation error","Invalid date format (not YYYY-MM-DD) causes row rejection","Field enum value not in ['expiring_contracts','renewed_contracts'] causes error","Method enum value not in ['zero','mean','median'] causes error","Numeric values outside ±1,000,000,000,000 range cause validation failure","Missing required fields (row_id, company_group, date) cause row-level errors"],"whenToPreferThis":"Choose this endpoint when you have up to 200 rows of contract renewal records and need both a category frequency breakdown and missing-value imputation in a single low-cost call ($0.01 USDC). It is ideal for lightweight, self-contained data quality and summary analytics on contract inventory data without requiring any external data sources or live predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T12:48:32.312Z","isFirstParty":false,"canonicalSlug":"contract-renewal-inventories-category-frequencies-missing-value-fill-cd4e3fec"}