{"uid":"cap_VcPD4cEHBGYhOlUmsfiCN","slug":"tutorial-completion-data-deduplication-and-missing-value-fill-e0ade401","name":"Tutorial Completion Data Deduplication and Missing-Value Fill","description":"Tutorial completion — Exact row deduplication + Explicit missing-value fill: Exact row deduplication + 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-054?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"}}},"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_zZmF8pqzSwit1eVYnKSK7","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":"Deduplicates exact rows and fills missing values (starts or completions) in tutorial completion records using statistical methods (zero, mean, or median)","exampleAgentPrompt":"Clean my tutorial completion data by removing exact duplicate rows and filling any missing 'completions' values using the median — here are my records with date, game_area, starts, and completions for up to 200 rows.","exampleUseCases":[{"title":"Game tutorial funnel data cleanup","prompt":"I have tutorial tracking data for our game areas with starts and completions by date, but some rows are duplicated and some completions values are null. Can you deduplicate the exact duplicate rows and fill the missing completions using the median?"},{"title":"Impute missing starts with zero fill","prompt":"Here's my tutorial completion dataset with rows for different game areas — some 'starts' values are missing. Can you remove any exact duplicate rows and fill all null starts values with zero?"},{"title":"Normalize tutorial data before reporting","prompt":"Before I run my weekly report, I need to clean this tutorial data: deduplicate any identical rows and fill missing 'completions' values using the mean across my game_area and date records."}],"resultDescription":"Two analytical reports covering: (1) exact row deduplication results showing which rows were removed, and (2) a missing-value-filled dataset where null starts or completions fields are replaced using the chosen method (zero, mean, or median). Reports are derived from locally supplied data only — no external lookups.","failureModes":["Input array is empty or exceeds 200 rows — rejected with validation error","Invalid date format (not YYYY-MM-DD) causes row rejection","Field not in enum ['starts','completions'] causes parameter error","Method not in enum ['zero','mean','median'] causes parameter error","Missing required fields (row_id, game_area, date, starts, completions) causes row-level validation failure","Payment not included or insufficient USDC causes 402 response"],"whenToPreferThis":"Choose this endpoint when you have tutorial completion records (with starts/completions counts, game area, and date) that need both exact duplicate row removal and statistical missing-value imputation in a single call. Ideal for small-to-medium datasets up to 200 rows where no external data lookup or prediction is needed — just local data cleaning and two structured reports for $0.01 USDC.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T18:38:06.646Z","isFirstParty":false,"canonicalSlug":"tutorial-completion-data-deduplication-and-missing-value-fill-e0ade401"}