{"uid":"cap_HCjWLJdH09NzyIGShmX97","slug":"process-handoffs-numeric-interval-filter-explicit-missing-value-fill-96913cad","name":"Process Handoffs — Numeric Interval Filter + Explicit Missing-Value Fill","description":"Process handoffs — Numeric interval filter + Explicit missing-value fill: Numeric interval filter + Explicit missing-value fill for supplied process handoffs records (handoff_count, wait_minutes). 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-18-135?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","team_group","date","handoff_count","wait_minutes"],"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},"wait_minutes":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"handoff_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","team_group":"group-a","wait_minutes":1,"handoff_count":10},{"date":"2026-10-02","row_id":"row-2","team_group":"group-b","wait_minutes":2,"handoff_count":20},{"date":"2026-10-03","row_id":"row-3","team_group":"group-a","wait_minutes":3,"handoff_count":15},{"date":"2026-10-04","row_id":"row-4","team_group":"group-b","wait_minutes":4,"handoff_count":30}],"maxItems":200,"minItems":1},"field":{"enum":["handoff_count","wait_minutes"],"type":"string","default":"handoff_count"},"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_NklEZvjwvMrb_UQFGgybe","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 process handoff records to a numeric interval and fills missing values using zero, mean, or median — returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"Take these process handoff records for our ops teams and filter handoff_count to only rows between 5 and 50, then fill any missing handoff_count values using the median — I have about 80 rows across group-a and group-b from October 2026.","exampleUseCases":[{"title":"Clean ops handoff data for reporting","prompt":"I've got 120 rows of process handoff data with some nulls in the wait_minutes field — filter them to only rows where wait_minutes is between 0 and 60, and fill any missing wait_minutes with the mean so I can get a clean report."},{"title":"Outlier removal for handoff count metrics","prompt":"Can you filter our handoff_count records to only values between 10 and 100, and replace any null handoff_count entries with zero? I have about 150 rows from three team groups across Q4 2026."},{"title":"Multi-team handoff quality audit","prompt":"I need two analytical reports on our team handoff data — first filter wait_minutes to the range 1 through 30, then fill any missing wait_minutes using the median. There are around 90 rows covering group-a and group-b from last quarter."}],"resultDescription":"Two analytical reports covering: (1) rows filtered to the specified numeric interval for the chosen field (handoff_count or wait_minutes), and (2) the same dataset with missing values explicitly filled using the selected method (zero, mean, or median). Results are computed locally without external lookups, covering up to 200 input rows.","failureModes":["More than 200 rows submitted — request will be rejected or truncated","Invalid date format (non-YYYY-MM-DD strings) causing row rejection","min greater than max causing empty interval filter result","Field name not in allowed enum (handoff_count or wait_minutes)","All rows missing values for the target field — fill result may be degenerate","Payment not included or insufficient USDC — 402 response"],"whenToPreferThis":"Use this endpoint when you have process handoff records (handoff_count, wait_minutes) and need to both restrict data to a valid numeric range and handle missing values in a single operation, receiving two combined reports for $0.01 USDC. Prefer this over general-purpose analytics tools when working with operations handoff data up to 200 rows and needing a lightweight, paid-per-call batch computation with no external data dependencies.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T18:50:50.664Z","isFirstParty":false,"canonicalSlug":"process-handoffs-numeric-interval-filter-explicit-missing-value-fill-96913cad"}