{"uid":"cap_Y98SyC6O1gF6cdVG-oFcs","slug":"contract-renewal-inventories-exact-row-deduplication-trailing-mean-0d0e5c25","name":"Contract Renewal Inventories — Exact Row Deduplication + Trailing Mean Series","description":"Contract renewal inventories — Exact row deduplication + Trailing mean series: Exact row deduplication + Trailing mean series 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-045?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"},"window":{"type":"integer","default":2,"maximum":200,"minimum":2}}},"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_U4nEyGiKH8-uisR_Ya1OM","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":"Deduplicates rows and computes trailing mean time series for contract renewal inventory data (expiring_contracts, renewed_contracts) across up to 200 rows.","exampleAgentPrompt":"Deduplicate my contract renewal inventory rows and compute a trailing mean series with a window of 3 for the expiring_contracts field — here are the records: row-1 / group-a / 2026-10-01 / expiring=10 / renewed=1, row-2 / group-b / 2026-10-02 / expiring=20 / renewed=2, row-3 / group-a / 2026-10-03 / expiring=15 / renewed=3.","exampleUseCases":[{"title":"Monthly renewal pipeline deduplication","prompt":"I have 150 rows of contract renewal data for Q4 across three company groups and I need you to remove any exact duplicate rows and then compute a trailing mean with a window of 4 for the renewed_contracts field — can you run both reports?"},{"title":"Expiring contract trend smoothing","prompt":"Take these daily expiring_contracts records for group-a and group-b, deduplicate them, and give me a trailing mean series using a window of 7 so I can see the smoothed trend over the past month."},{"title":"Renewal rate analysis by company group","prompt":"Here are 80 rows of contract renewal inventory data — please deduplicate them first, then compute a trailing mean with window size 5 on the expiring_contracts field so I can spot any anomalies in renewal rates across company groups."}],"resultDescription":"Returns two analytical reports: (1) the input rows after exact deduplication, and (2) a trailing mean time series computed over the specified rolling window for the chosen field (expiring_contracts or renewed_contracts), covering up to 200 input rows.","failureModes":["Input array exceeds 200 rows — request will be rejected","Invalid date format (non-YYYY-MM-DD) causes schema validation failure","Window size larger than number of rows may produce sparse or empty series","Missing required fields (row_id, date, company_group) cause validation errors","Null numeric values in the target field may affect trailing mean calculation"],"whenToPreferThis":"Choose this endpoint when you have tabular contract renewal data (expiring and renewed contract counts by date and company group) and need to both clean it via exact deduplication and compute a rolling/trailing mean series in a single call. It is ideal for lightweight, offline analytical tasks on small-to-medium datasets (up to 200 rows) where no live data lookup, prediction, or external integration is required.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T12:48:57.029Z","isFirstParty":false,"canonicalSlug":"contract-renewal-inventories-exact-row-deduplication-trailing-mean-0d0e5c25"}