{"uid":"cap_Un89FEQ__xwdOFKJl8RdN","slug":"tutorial-completion-numeric-interval-filter-explicit-missing-value-fill-ff6cd0c2","name":"Tutorial Completion Numeric Interval Filter + Explicit Missing-Value Fill","description":"Tutorial completion — Numeric interval filter + Explicit missing-value fill: Numeric interval filter + Explicit missing-value fill for supplied tutorial completion records (starts, completions). 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-game-20-135?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","game_area","date","starts","completions"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"starts":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"game_area":{"type":"string","default":"","maxLength":80},"completions":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","starts":10,"game_area":"group-a","completions":1},{"date":"2026-10-02","row_id":"row-2","starts":20,"game_area":"group-b","completions":2},{"date":"2026-10-03","row_id":"row-3","starts":15,"game_area":"group-a","completions":3},{"date":"2026-10-04","row_id":"row-4","starts":30,"game_area":"group-b","completions":4}],"maxItems":200,"minItems":1},"field":{"enum":["starts","completions"],"type":"string","default":"starts"},"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_u7hs4Q6xLWLNMeLXI4pP-","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 tutorial completion records (starts, completions) to a numeric interval and fills missing values using zero, mean, or median — returning 2 analytical reports for up to 200 rows.","exampleAgentPrompt":"I have tutorial completion data for my game — up to 150 rows with starts and completions per game area — can you filter the 'completions' field to only values between 0 and 500, and fill any missing values using median?","exampleUseCases":[{"title":"Game tutorial funnel data cleaning","prompt":"I've got daily tutorial starts and completions across two game areas for October — about 80 rows — please filter 'starts' to values between 5 and 1000 and fill any nulls with the mean so I can run a clean funnel report."},{"title":"Outlier removal for completion metrics","prompt":"My tutorial dataset has 120 rows with some extreme outlier completions way above 200 — can you filter 'completions' to between 0 and 200 and replace any missing completions with zero?"},{"title":"Preparing imputed data for downstream analytics","prompt":"I need to prep 60 rows of game tutorial data where some starts values are missing — filter starts to between 10 and 5000 and use median imputation for the missing ones, and give me 2 reports on the result."}],"resultDescription":"Two independent analytical reports based on the supplied tutorial completion rows (up to 200): one applying the numeric interval filter to the specified field, and one filling missing values using the chosen method (zero, mean, or median). Reports are computed locally from the provided data with no external lookups.","failureModes":["Input array has 0 rows — minItems:1 violated, request rejected","rows exceed 200 items — maxItems exceeded, request rejected","date field doesn't match YYYY-MM-DD pattern — schema validation error","minimum value greater than maximum value — may produce empty filtered result","field enum value not 'starts' or 'completions' — schema validation error","method enum value not 'zero', 'mean', or 'median' — schema validation error","Payment of 0.01 USDC not provided — x402 payment required error"],"whenToPreferThis":"Choose this endpoint when you have tutorial completion records (starts and completions per game area and date) and need both numeric interval filtering AND missing-value imputation in a single call returning two reports. Ideal for game analytics pipelines that need to clean raw completion data before downstream aggregation, especially when data contains nulls and out-of-range values. Not suitable for live data lookup, prediction, or datasets exceeding 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T18:37:49.183Z","isFirstParty":false,"canonicalSlug":"tutorial-completion-numeric-interval-filter-explicit-missing-value-fill-ff6cd0c2"}