{"uid":"cap_3EGO5g1W_7Yai6H0YwA34","slug":"contract-renewal-inventories-exact-row-deduplication-explicit-missing-d3639b01","name":"Contract Renewal Inventories — Exact Row Deduplication + Explicit Missing-Value Fill","description":"Contract renewal inventories — Exact row deduplication + Explicit missing-value fill: Exact row deduplication + 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-054?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_lk4Nad79Q1unhFuYeUcRZ","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 exact rows and fills missing values in contract renewal inventory records (expiring_contracts, renewed_contracts) for up to 200 rows, producing 2 analytical reports.","exampleAgentPrompt":"Clean up my contract renewal inventory data by removing exact duplicate rows and filling any missing expiring_contracts values using the median method — here are my records: row-1, group-a, 2026-10-01, expiring=10, renewed=1; row-2, group-b, 2026-10-02, expiring=20, renewed=2; and row-3, group-a, 2026-10-03, expiring=null, renewed=3.","exampleUseCases":[{"title":"Monthly renewal data quality check","prompt":"I have my monthly contract renewal records for two company groups and some rows have null values in expiring_contracts — can you deduplicate the dataset and fill those missing values using the median so I get clean reports for both fields?"},{"title":"Quarterly duplicate audit for renewals","prompt":"Run a deduplication pass on these 50 contract renewal rows across group-a and group-b and also fill any missing renewed_contracts figures using the mean — I need two reports back covering both expiring and renewed contracts."},{"title":"Data prep before renewal analytics","prompt":"Before I run my renewal rate analysis, I need to clean this dataset: strip out exact duplicate rows and replace any null expiring_contracts entries with zero for all 120 rows I'm supplying across our four company groups."}],"resultDescription":"Returns two analytical reports for the supplied contract renewal inventory records: one for expiring_contracts and one for renewed_contracts. Each report reflects exact-row deduplication (identifying and removing identical rows) and explicit missing-value fill applied to the selected field using the chosen method (zero, mean, or median). Reports cover up to 200 input rows and are generated using local analytical engines 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 not matching YYYY-MM-DD pattern — rejected","Numeric values outside allowed range (±1,000,000,000,000) — validation error","Empty rows array — minimum 1 item required"],"whenToPreferThis":"Choose this endpoint when you have tabular contract renewal data (expiring_contracts and renewed_contracts) that needs both duplicate row removal and missing-value imputation in a single step, without any external data enrichment, predictions, or live lookups. Ideal for preprocessing pipelines where data quality must be ensured before downstream renewal rate analysis, and when you want two simultaneous field-level reports at low cost ($0.01 USDC for both).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T12:48:37.825Z","isFirstParty":false,"canonicalSlug":"contract-renewal-inventories-exact-row-deduplication-explicit-missing-d3639b01"}