{"uid":"cap_Ac0w0ii2oxGf-qBBXy9ia","slug":"contract-renewal-inventories-grouped-numeric-summary-explicit-missing-b5a3247d","name":"Contract Renewal Inventories — Grouped Numeric Summary + Explicit Missing-Value Fill","description":"Contract renewal inventories — Grouped numeric summary + Explicit missing-value fill: Grouped numeric summary + 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-099?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_-FRwFEQmP_onJIlKHg_lb","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 grouped numeric summaries and fills missing values for contract renewal inventory data (expiring and renewed contracts) across up to 200 rows.","exampleAgentPrompt":"I have a table of contract renewal records by company group with some missing values — can you group-summarize the expiring_contracts field and fill any nulls using median imputation? Here are up to 200 rows with columns row_id, company_group, date, expiring_contracts, and renewed_contracts.","exampleUseCases":[{"title":"Monthly contract renewal audit by division","prompt":"I have 150 rows of contract data split across group-a and group-b, with some nulls in the renewed_contracts column. Can you give me a grouped numeric summary of renewed_contracts by company group and fill the missing values using zero imputation?"},{"title":"Expiring contract gap analysis","prompt":"Run a grouped summary on my expiring_contracts data across these company groups and use mean fill to handle any missing entries — I need to understand which groups have the most exposure before end of quarter."},{"title":"Data quality fix for renewal pipeline report","prompt":"My renewal pipeline CSV has null values scattered in the expiring_contracts field. Can you impute those nulls with the median and also give me the grouped numeric summary broken down by company_group so I can review the cleaned output?"}],"resultDescription":"Two analytical reports: (1) a grouped numeric summary of the selected field (expiring_contracts or renewed_contracts) aggregated by company_group, and (2) a version of the dataset with missing values in the selected field explicitly filled using the chosen method (zero, mean, or median). Both reports are computed locally from the supplied rows with no external data lookups.","failureModes":["Fewer than 1 row supplied returns a validation error","More than 200 rows provided exceeds the row limit","Invalid date format (not YYYY-MM-DD) causes schema rejection","row_id missing or empty triggers required-field error","Unknown fill method or field value outside enum causes rejection","All values null in selected field may result in mean/median being undefined"],"whenToPreferThis":"Choose this endpoint when you need both grouped aggregation statistics and missing-value imputation on contract renewal data in a single call for up to 200 rows. It is ideal for lightweight, offline analytical tasks on structured tabular data without needing a full data warehouse or external ML service. Prefer it over general-purpose analytics APIs when working specifically with expiring_contracts and renewed_contracts metrics grouped by company.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T12:48:53.202Z","isFirstParty":false,"canonicalSlug":"contract-renewal-inventories-grouped-numeric-summary-explicit-missing-b5a3247d"}