{"uid":"cap_uoUKQY4FYymCoC3_vX2Qi","slug":"contract-renewal-inventories-date-category-pivot-missing-value-fill-ff5e159f","name":"Contract Renewal Inventories — Date×Category Pivot + Missing-Value Fill","description":"Contract renewal inventories — Date by category pivot + Explicit missing-value fill: Date by category pivot + 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-189?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_rL4YPIhMSA_APA-w3yO5u","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 contract renewal inventory data (expiring and renewed contracts) by date and category, then fills missing values using zero, mean, or median imputation — returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"I have a set of contract renewal records with company groups like 'group-a' and 'group-b', dates, and expiring/renewed contract counts — some values are missing. Can you pivot this data by date and category for the expiring_contracts field, filling in the blanks using median imputation, and give me the two analytical reports?","exampleUseCases":[{"title":"Monthly renewal pipeline review","prompt":"I have 150 rows of contract renewal data across several business units with dates from Q1. Pivot the expiring_contracts field by date and company group, and fill any missing values using the median so I can review the full renewal pipeline without gaps."},{"title":"Renewal rate gap analysis","prompt":"My contract inventory records have some null values in renewed_contracts. Can you run a date-by-category pivot on those records — using mean fill for missing values — and give me the two summary reports so I can spot which groups had weak renewal rates?"},{"title":"Zero-fill audit for compliance reporting","prompt":"I need to prepare contract renewal inventory data for a compliance report. Please pivot the expiring_contracts figures by date and company group, and explicitly fill any missing entries with zero so the report shows complete coverage across all categories."}],"resultDescription":"Returns two independent analytical reports derived from the supplied contract renewal rows: (1) a date-by-category pivot table for the selected field (expiring_contracts or renewed_contracts), and (2) a version of that same data with missing values explicitly filled using the chosen method (zero, mean, or median). All processing is local with no external lookups. Covers up to 200 input rows.","failureModes":["Missing required fields (row_id, date, company_group) cause row rejection or validation error","Dates not matching YYYY-MM-DD pattern are rejected","More than 200 rows submitted exceeds the row limit and may be truncated or rejected","Invalid enum values for field (must be expiring_contracts or renewed_contracts) or method (must be zero, mean, median) cause request failure","Empty rows array returns an error","Numeric values outside ±1,000,000,000,000 are rejected"],"whenToPreferThis":"Choose this endpoint when you have pre-collected contract renewal inventory records and need a structured pivot by date and company group, plus explicit missing-value imputation, all in a single low-cost call. It is ideal for offline or batch analytical workflows where no live data lookup, prediction, or external enrichment is needed. Best suited for datasets up to 200 rows needing two complementary views of the same data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T12:48:31.541Z","isFirstParty":false,"canonicalSlug":"contract-renewal-inventories-date-category-pivot-missing-value-fill-ff5e159f"}