{"uid":"cap_aRIoe3-v-fFtxaZt9LeRQ","slug":"contract-renewal-inventories-iqr-outlier-flags-explicit-missing-value-bc14e950","name":"Contract Renewal Inventories — IQR Outlier Flags + Explicit Missing-Value Fill","description":"Contract renewal inventories — IQR outlier flags + Explicit missing-value fill: IQR outlier flags + 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-180?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_MHM_8PL-zgtk_Jqx8KtYB","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":"Analyzes contract renewal inventory records to flag IQR-based outliers and fill missing values, producing two analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you run IQR outlier detection and fill any missing values using median imputation on our expiring_contracts field across these 4 contract renewal rows — group-a and group-b from October 2026 — and give me two reports?","exampleUseCases":[{"title":"Monthly contract renewal data cleanup","prompt":"I have our monthly contract renewal records for group-a and group-b with some nulls in the renewed_contracts column — can you flag any IQR outliers and fill the missing values using mean imputation, then give me both reports?"},{"title":"Detecting anomalous expiring contract volumes","prompt":"Run IQR outlier flagging on this batch of 50 contract renewal rows I'm uploading, targeting the expiring_contracts field, and also fill any missing entries using zero fill — I need both analytical reports."},{"title":"Pre-quarter renewal data quality audit","prompt":"Before our Q4 review I need to clean up our contract renewal inventory data — can you flag statistical outliers using IQR and impute any missing expiring_contracts values with the median across all company groups?"}],"resultDescription":"Returns two independent analytical reports: (1) IQR outlier flags identifying which rows in the expiring_contracts or renewed_contracts field fall outside the interquartile range, and (2) an explicit missing-value fill report showing which null entries were replaced and what values were used, based on the selected fill method (zero, mean, or median). Both reports are generated locally with no external lookups.","failureModes":["Fewer than 1 row submitted — minItems violation returns validation error","More than 200 rows submitted — maxItems exceeded returns rejection","Invalid date format (not YYYY-MM-DD) causes schema validation failure","Non-numeric values in expiring_contracts or renewed_contracts fields cause parse errors","Missing required fields (row_id, company_group, date) cause row-level rejection","Invalid method enum value (not zero/mean/median) causes parameter error","Invalid field enum value (not expiring_contracts/renewed_contracts) causes parameter error"],"whenToPreferThis":"Choose this endpoint when you have up to 200 contract renewal inventory records (expiring_contracts, renewed_contracts) and need both IQR-based outlier detection and missing-value imputation in a single $0.01 call. It is ideal for lightweight, offline statistical cleaning of structured contract data without requiring external data sources, live predictions, or professional assessment. Prefer this over generic data-cleaning tools when your data specifically involves contract renewal metrics grouped by company and date.","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-iqr-outlier-flags-explicit-missing-value-bc14e950"}