{"uid":"cap_FpIPQEHUuqIPXSWQzWV5k","slug":"patch-inventories-string-normalisation-explicit-missing-value-fill-c799c24c","name":"Patch Inventories — String Normalisation + Explicit Missing-Value Fill","description":"Patch inventories — String normalisation + Explicit missing-value fill: String normalisation + Explicit missing-value fill for supplied patch inventories records (affected_hosts, patched_hosts). 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-security-02-037?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","control_group","date","affected_hosts","patched_hosts"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"control_group":{"type":"string","default":"","maxLength":80},"patched_hosts":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"affected_hosts":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","control_group":"group-a","patched_hosts":1,"affected_hosts":10},{"date":"2026-10-02","row_id":"row-2","control_group":"group-b","patched_hosts":2,"affected_hosts":20},{"date":"2026-10-03","row_id":"row-3","control_group":"group-a","patched_hosts":3,"affected_hosts":15},{"date":"2026-10-04","row_id":"row-4","control_group":"group-b","patched_hosts":4,"affected_hosts":30}],"maxItems":200,"minItems":1},"field":{"enum":["affected_hosts","patched_hosts"],"type":"string","default":"affected_hosts"},"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_P4OMr4oyqtVaD80Vvdbat","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":"Normalises strings and fills missing values (zero, mean, or median) in patch inventory records containing affected_hosts and patched_hosts fields, up to 200 rows across 2 reports.","exampleAgentPrompt":"Can you clean up my patch inventory data? I have 4 rows with control groups 'group-a' and 'group-b', dates from 2026-10-01 to 2026-10-04, and some null values in the affected_hosts field — please fill those missing values using the median method.","exampleUseCases":[{"title":"Impute missing affected host counts","prompt":"I have a patch inventory CSV with 50 rows — some of the affected_hosts values are null. Can you fill in those missing values using the median of the existing ones? The rows each have a row_id, control_group, date, affected_hosts, and patched_hosts."},{"title":"Zero-fill missing patched hosts for reporting","prompt":"Before I generate my weekly patch compliance report, I need to fill any null patched_hosts values with zero for my 120-row inventory dataset covering groups 'prod' and 'staging' — can you do that and also normalise the strings?"},{"title":"Clean patch data across two control groups","prompt":"I've got patch tracking records for two control groups, 'datacenter-east' and 'datacenter-west', across 80 rows from October 2026, and several affected_hosts entries are missing. Fill those using the mean and normalise any messy string fields so the data is ready to use."}],"resultDescription":"Returns up to 2 cleaned analytical reports covering the supplied patch inventory rows, with string fields normalised and missing numeric values in the specified field (affected_hosts or patched_hosts) explicitly filled using the chosen method (zero, mean, or median). Each report covers up to 200 input rows.","failureModes":["Input array exceeds 200 rows — request rejected","Invalid date format (not YYYY-MM-DD) — validation error","Missing required fields (row_id, control_group, date) — schema error","Invalid fill method enum value — validation error","Invalid field enum value — validation error","Payment not received or insufficient — 402 response"],"whenToPreferThis":"Choose this endpoint when you need lightweight, local data-quality processing for patch inventory records specifically — normalising string fields and imputing missing numeric host-count values without any external lookup or live data. It is best suited for batch pre-processing of up to 200 rows at very low cost ($0.01 USDC for 2 reports). Prefer it over general-purpose data-cleaning services when your data matches the patch inventory schema (affected_hosts, patched_hosts, control_group, date).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-22T12:45:15.318Z","isFirstParty":false,"canonicalSlug":"patch-inventories-string-normalisation-explicit-missing-value-fill-c799c24c"}