{"uid":"cap_R2V_NYnabDPEzF_KWIrKt","slug":"procurement-research-trailing-mean-series-explicit-missing-value-fill-b943b2b4","name":"Procurement Research — Trailing Mean Series + Explicit Missing-Value Fill","description":"Procurement research — Trailing mean series + Explicit missing-value fill: Trailing mean series + Explicit missing-value fill for supplied procurement research records (quoted_amount, quoted_units). 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-11-154?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","quoted_amount","quoted_units"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"quoted_units":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"company_group":{"type":"string","default":"","maxLength":80},"quoted_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","quoted_units":1,"company_group":"group-a","quoted_amount":10},{"date":"2026-10-02","row_id":"row-2","quoted_units":2,"company_group":"group-b","quoted_amount":20},{"date":"2026-10-03","row_id":"row-3","quoted_units":3,"company_group":"group-a","quoted_amount":15},{"date":"2026-10-04","row_id":"row-4","quoted_units":4,"company_group":"group-b","quoted_amount":30}],"maxItems":200,"minItems":1},"field":{"enum":["quoted_amount","quoted_units"],"type":"string","default":"quoted_amount"},"method":{"enum":["zero","mean","median"],"type":"string","default":"median"},"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_oF6DQTUsBmrZGHnprPE1t","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 a trailing moving-average time series and fills missing values in procurement records (quoted_amount or quoted_units) for up to 200 rows, returning two analytical reports.","exampleAgentPrompt":"I have 150 procurement records with quoted_amount and some missing values — can you compute a trailing mean series with a window of 5 and fill the missing quoted_amount values using the median method?","exampleUseCases":[{"title":"Smoothing supplier quote price history","prompt":"I've got 80 rows of supplier quote data by date and company group — run a trailing mean with window size 3 on quoted_amount and fill any missing values using the mean method so I can see a clean price trend."},{"title":"Imputing missing units in procurement dataset","prompt":"Some of my procurement records have null quoted_units values — can you fill those in using median and also give me a trailing mean series with a window of 4 so I can analyze volume trends?"},{"title":"Preparing procurement data for reporting","prompt":"Before I run our procurement report, I need to clean up 120 rows of quote data — use a window of 6 for the trailing mean on quoted_amount and fill any gaps with zero so everything lines up for the analysis."}],"resultDescription":"Returns two analytical reports: (1) a trailing mean series showing the rolling average of the selected field (quoted_amount or quoted_units) over the specified window, and (2) a missing-value fill report showing the original and imputed values for null entries using the chosen method (zero, mean, or median). All computations are performed locally on the supplied data with no external lookups.","failureModes":["Fewer than 1 row supplied — request rejected","More than 200 rows supplied — exceeds row limit","Invalid date format (not YYYY-MM-DD) — schema validation error","Window size less than 2 or greater than 200 — validation error","Unrecognized fill method or field value — enum validation error","Missing required fields (row_id, company_group, date) — schema error"],"whenToPreferThis":"Choose this endpoint when you have procurement records with quoted_amount or quoted_units fields that contain missing values and you want both a trailing moving-average series and explicit null imputation in a single call. Ideal for pre-processing procurement time series data before reporting or visualization. Not suitable for live data lookups, predictive forecasting, or datasets exceeding 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:12.159Z","isFirstParty":false,"canonicalSlug":"procurement-research-trailing-mean-series-explicit-missing-value-fill-b943b2b4"}