{"uid":"cap_LXomYvg_Mg_ZzCPEc9T4G","slug":"transcript-preparation-numeric-distribution-explicit-missing-value-fill-34db0246","name":"Transcript Preparation — Numeric Distribution + Explicit Missing-Value Fill","description":"Transcript preparation — Numeric distribution + Explicit missing-value fill: Numeric distribution + Explicit missing-value fill for supplied transcript preparation records (transcribed_minutes, source_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-writing-12-085?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","document_group","date","transcribed_minutes","source_minutes"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"document_group":{"type":"string","default":"","maxLength":80},"source_minutes":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"transcribed_minutes":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","document_group":"group-a","source_minutes":1,"transcribed_minutes":10},{"date":"2026-10-02","row_id":"row-2","document_group":"group-b","source_minutes":2,"transcribed_minutes":20},{"date":"2026-10-03","row_id":"row-3","document_group":"group-a","source_minutes":3,"transcribed_minutes":15},{"date":"2026-10-04","row_id":"row-4","document_group":"group-b","source_minutes":4,"transcribed_minutes":30}],"maxItems":200,"minItems":1},"field":{"enum":["transcribed_minutes","source_minutes"],"type":"string","default":"transcribed_minutes"},"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_Nf7QxJxavE87n09ohzMSV","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":"Computes numeric distribution statistics and fills missing values (zero, mean, or median) for up to 200 rows of transcript timing data (transcribed_minutes, source_minutes), returning two analytical reports.","exampleAgentPrompt":"Can you analyze the numeric distribution and fill any missing transcribed_minutes values using median imputation for my transcript batch? Here are my rows: row-1 group-a 2026-10-01 transcribed=10 source=1, row-2 group-b 2026-10-02 transcribed=null source=2, row-3 group-a 2026-10-03 transcribed=15 source=3.","exampleUseCases":[{"title":"Impute missing transcription durations before reporting","prompt":"I have a batch of 50 transcript records where some transcribed_minutes fields are null — can you fill those missing values using the mean and also give me the numeric distribution of transcribed_minutes across all rows?"},{"title":"QA check on source audio lengths","prompt":"Before I archive these transcripts, I need a distribution report on source_minutes for my 120 document rows and want any missing source_minutes replaced with zero so every row has a value."},{"title":"Prep transcript data for downstream pipeline","prompt":"I'm cleaning up transcript preparation records for group-a and group-b documents dated in October 2026 — run numeric distribution analysis and median missing-value fill on the transcribed_minutes field for all 80 rows so the dataset is ready for the next step."}],"resultDescription":"Two analytical reports: (1) a numeric distribution report covering statistics such as min, max, mean, median, and spread for the chosen field across up to 200 rows; (2) a missing-value fill report showing which rows had nulls replaced and what values were substituted, using the specified fill method (zero, mean, or median). No external lookups or predictions are made; analysis is performed locally on the supplied data.","failureModes":["Rows array exceeds 200 items — request rejected or truncated","Invalid date format (not YYYY-MM-DD) — validation error","Unknown fill method or field enum value — schema validation failure","All values missing for chosen field — mean/median fill may be undefined or return zero","Empty rows array — no output generated","row_id missing or exceeding 80 characters — row rejected"],"whenToPreferThis":"Choose this endpoint when you need both a numeric distribution summary and explicit missing-value imputation for transcript timing fields (transcribed_minutes or source_minutes) in a single $0.01 call covering up to 200 rows. Ideal for data preparation pipelines that must handle nulls before downstream analytics. Prefer it over general-purpose stats tools when working specifically with transcript preparation records and needing two coordinated reports (distribution + fill) in one round-trip without any live lookups or external dependencies.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T12:31:28.053Z","isFirstParty":false,"canonicalSlug":"transcript-preparation-numeric-distribution-explicit-missing-value-fill-34db0246"}