{"uid":"cap_MNRNZ-LQH17LDVpf-L_b1","slug":"contract-renewal-inventories-adjacent-row-changes-explicit-missing-414ec8cc","name":"Contract Renewal Inventories — Adjacent Row Changes + Explicit Missing-Value Fill","description":"Contract renewal inventories — Adjacent row changes + Explicit missing-value fill: Adjacent row changes + 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-162?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_0a4dLSEFNGy5MlvVpTh91","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 data by computing adjacent row changes and filling missing values using zero, mean, or median strategies across up to 200 rows.","exampleAgentPrompt":"Can you run two analytical reports on my contract renewal inventory data — compute adjacent row changes and fill any missing values using the median — for these 50 rows of expiring_contracts and renewed_contracts grouped by company?","exampleUseCases":[{"title":"Clean contract pipeline for monthly reporting","prompt":"I have a dataset of 120 rows tracking expiring and renewed contracts by company group with some nulls in the renewed_contracts column — can you fill those missing values using the mean and also show me how each row changed from the previous one?"},{"title":"Spot gaps in renewal tracking by group","prompt":"Here are our Q4 contract renewal records across two company groups with dates from October through December — run the adjacent row change analysis and fill any missing expiring_contracts values with zero so I can see where tracking broke down."},{"title":"Prepare contract data for executive dashboard","prompt":"Before I upload this contract inventory to our dashboard, can you clean it up by filling null values in both expiring_contracts and renewed_contracts using median, and also compute the row-to-row differences so we can spot anomalies?"}],"resultDescription":"Returns two independent analytical reports: (1) an adjacent row changes report showing the delta between consecutive rows for the specified field, and (2) an explicit missing-value fill report where nulls in the target field are replaced using the chosen strategy (zero, mean, or median). Both reports are computed locally from the supplied data with no external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, date, company_group) — validation error","Invalid date format (must be YYYY-MM-DD) — pattern mismatch error","Invalid method enum value (must be zero, mean, or median) — schema error","Invalid field enum value (must be expiring_contracts or renewed_contracts) — schema error","Payment of 0.01 USDC not included or rejected — 402 response"],"whenToPreferThis":"Choose this endpoint when you need two specific data-cleaning and analysis operations on contract renewal inventory data — adjacent row change computation and explicit null filling — without any external lookups or predictions. Ideal for preprocessing contract datasets before dashboarding or reporting, especially when working with up to 200 rows of timestamped, group-labeled renewal records.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T12:48:32.311Z","isFirstParty":false,"canonicalSlug":"contract-renewal-inventories-adjacent-row-changes-explicit-missing-414ec8cc"}