{"uid":"cap_2j85NpLRCWnPWDdpUURzY","slug":"shipment-costs-explicit-missing-value-fill-178f949a","name":"Shipment Costs – Explicit Missing-Value Fill","description":"Shipment costs - Explicit missing-value fill: Explicit missing-value fill for Shipment costs. Up to 200 supplied typed records. Local numeric and data-quality processing; no external enrichment or forecasting. One of 25 profiles or calculations across 20 shared operations in this sector. 0.01 USDC includes one bounded explicit missing-value fill deliverable.","url":"https://market.datapackvibe.com/x402/assistant-sector-analytics-shipment-costs-fill-missing?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","carrier","date","weight_kg","shipping_cost"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"carrier":{"type":"string","default":"","maxLength":80},"weight_kg":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"shipping_cost":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","carrier":"group-a","weight_kg":10,"shipping_cost":1},{"date":"2026-10-02","row_id":"row-2","carrier":"group-b","weight_kg":20,"shipping_cost":2},{"date":"2026-10-03","row_id":"row-3","carrier":"group-a","weight_kg":15,"shipping_cost":3},{"date":"2026-10-04","row_id":"row-4","carrier":"group-b","weight_kg":30,"shipping_cost":4}],"maxItems":200,"minItems":1},"field":{"enum":["weight_kg","shipping_cost"],"type":"string","default":"weight_kg"},"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_KD_bzmpNp7fC9owC6-c1h","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":"Fills missing numeric values (weight_kg or shipping_cost) in shipment cost records using zero, mean, or median imputation across up to 200 rows.","exampleAgentPrompt":"I have a batch of shipment records where some shipping_cost values are null — can you fill those missing values using median imputation across up to 200 rows, with fields like row_id, carrier, date, weight_kg, and shipping_cost?","exampleUseCases":[{"title":"Clean freight data before cost analysis","prompt":"I've got a CSV of shipment records from two carriers where about 30 rows have null shipping_cost values — fill those missing costs using median imputation so I can run a cost analysis."},{"title":"Impute missing weights for logistics report","prompt":"Some of our shipment records are missing the weight_kg field. Can you fill those nulls using the mean of the available weight values across all 150 rows before I generate the monthly logistics report?"},{"title":"Zero-fill missing costs for accounting reconciliation","prompt":"For our accounting reconciliation, I need any null shipping_cost entries in these 80 shipment rows filled with zero — carrier is either group-a or group-b, and dates run from 2026-10-01 onward."}],"resultDescription":"Returns shipment records with the specified numeric field (weight_kg or shipping_cost) filled in wherever null values were present, using the selected imputation strategy (zero, mean, or median). No external data is introduced — all fill values are derived from the supplied records themselves.","failureModes":["Fewer than 1 or more than 200 rows supplied — rejected with validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Unknown imputation method or field enum value — schema rejection","All values in the target field are null (mean/median undefined) — may return zeros or error","row_id missing or empty string — required field validation failure"],"whenToPreferThis":"Choose this endpoint when you have tabular shipment cost records with sparse null values in weight_kg or shipping_cost and need a quick, local statistical imputation (zero, mean, or median) without sending data to an external enrichment or forecasting service. Ideal for pre-processing pipelines where data cleanliness is needed before downstream analytics. Not suitable for time-series forecasting, outlier detection, or enrichment with external reference data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T18:47:58.794Z","isFirstParty":false,"canonicalSlug":"shipment-costs-explicit-missing-value-fill-178f949a"}