{"uid":"cap_ibUfd9ZBa1wLNysjztuZg","slug":"resource-bookings-numeric-interval-filter-explicit-missing-value-fill-01370930","name":"Resource Bookings — Numeric Interval Filter + Explicit Missing-Value Fill","description":"Resource bookings — Numeric interval filter + Explicit missing-value fill: Numeric interval filter + Explicit missing-value fill for supplied resource bookings records (booked_hours, available_hours). 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-operations-09-135?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","team_group","date","booked_hours","available_hours"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"team_group":{"type":"string","default":"","maxLength":80},"booked_hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"available_hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","team_group":"group-a","booked_hours":10,"available_hours":1},{"date":"2026-10-02","row_id":"row-2","team_group":"group-b","booked_hours":20,"available_hours":2},{"date":"2026-10-03","row_id":"row-3","team_group":"group-a","booked_hours":15,"available_hours":3},{"date":"2026-10-04","row_id":"row-4","team_group":"group-b","booked_hours":30,"available_hours":4}],"maxItems":200,"minItems":1},"field":{"enum":["booked_hours","available_hours"],"type":"string","default":"booked_hours"},"method":{"enum":["zero","mean","median"],"type":"string","default":"median"},"maximum":{"type":"number","default":100,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":0,"maximum":1000000000000,"minimum":-1000000000000}}},"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_xxHn60-v49Vp4R7Er3idy","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":"Filters resource booking rows by a numeric interval on booked_hours or available_hours and fills missing values using zero, mean, or median imputation, returning up to 2 analytical reports for up to 200 rows.","exampleAgentPrompt":"Take these 50 resource booking rows and filter them to only include entries where booked_hours is between 0 and 40, then fill any missing booked_hours values using the median — give me 2 reports on the result.","exampleUseCases":[{"title":"Team utilization data cleanup","prompt":"I have a CSV of team booking records with some null booked_hours entries — can you filter to rows where booked_hours is between 5 and 80, and fill the nulls using the mean? I need 2 reports on the cleaned data."},{"title":"Capacity planning interval analysis","prompt":"Here are 120 rows of resource scheduling data. Filter available_hours to the range 0 through 100, replace any missing available_hours with zero, and return 2 analytical summaries so I can plan capacity."},{"title":"Operations reporting with missing-value imputation","prompt":"Run an analysis on these 75 booking records for our operations team — keep only rows where booked_hours falls between 10 and 60, use median to fill any gaps, and give me 2 reports grouped by team_group."}],"resultDescription":"Returns up to 2 analytical reports on the supplied booking rows after applying the specified numeric interval filter (min/max bounds on the chosen field) and filling any null values in that field using the chosen method (zero, mean, or median). Results cover up to 200 input rows and are computed entirely from supplied data with no external lookups.","failureModes":["Fewer than 1 row supplied — minItems validation error","More than 200 rows supplied — maxItems exceeded error","Invalid date format (not YYYY-MM-DD) — pattern validation failure","minimum greater than maximum — may produce zero matching rows","Unknown field or method enum value — schema validation rejection","All values in chosen field are null — mean/median may be undefined"],"whenToPreferThis":"Choose this endpoint when you have resource booking tabular data (booked_hours, available_hours) that needs both numeric range filtering and missing-value imputation in a single step, without any external data lookup or live system integration. Ideal for preprocessing operations or workforce scheduling datasets before downstream reporting, at very low cost ($0.01 for up to 2 reports on 200 rows).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T12:48:04.874Z","isFirstParty":false,"canonicalSlug":"resource-bookings-numeric-interval-filter-explicit-missing-value-fill-01370930"}