{"uid":"cap_zdXqPJ1_Q-PKBBfygYcRm","slug":"event-attendance-missing-value-fill-d7dc6a51","name":"Event Attendance Missing-Value Fill","description":"Event attendance - Explicit missing-value fill: Explicit missing-value fill for Event attendance. Up to 200 supplied typed records. Local numeric and data-quality processing; no external enrichment or forecasting. One of 25 profiles or calculations across 20 shared operations in this sector. 0.01 USDC includes one bounded explicit missing-value fill deliverable.","url":"https://market.datapackvibe.com/x402/assistant-sector-analytics-event-attendance-fill-missing?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","event_type","date","registrations","attendees"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"attendees":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"event_type":{"type":"string","default":"","maxLength":80},"registrations":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","attendees":1,"event_type":"group-a","registrations":10},{"date":"2026-10-02","row_id":"row-2","attendees":2,"event_type":"group-b","registrations":20},{"date":"2026-10-03","row_id":"row-3","attendees":3,"event_type":"group-a","registrations":15},{"date":"2026-10-04","row_id":"row-4","attendees":4,"event_type":"group-b","registrations":30}],"maxItems":200,"minItems":1},"field":{"enum":["registrations","attendees"],"type":"string","default":"registrations"},"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_0Q80DiGTVL10lvb31B9kA","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":"Fills missing numeric values in event attendance records (registrations or attendees) using zero, mean, or median imputation across up to 200 rows.","exampleAgentPrompt":"I have a batch of event attendance records with some null attendees values — can you fill those missing values using the median of the non-null rows? Here are up to 50 records with row_id, event_type, date, registrations, and attendees fields.","exampleUseCases":[{"title":"Impute missing attendee counts for reporting","prompt":"I'm preparing a monthly event report and several rows have null attendees counts. Can you fill those missing attendee values using the median of the other rows? I've got about 80 records with event_type, date, registrations, and attendees columns."},{"title":"Zero-fill missing registrations before dashboard load","prompt":"Before I load my event data into the dashboard, I need to replace any null registrations values with zero. Can you process these 120 event attendance rows and fill any missing registrations fields with zero?"},{"title":"Mean imputation for event analytics pipeline","prompt":"My analytics pipeline chokes on nulls in the registrations column. Can you fill those missing registrations values using the mean across all the records I'm sending? I have about 150 rows of event attendance data with event_type and date fields."}],"resultDescription":"Returns the submitted event attendance records with previously null or missing values in the specified field (registrations or attendees) replaced by the chosen imputation value (zero, mean of non-null values, or median of non-null values). Output maintains the original row structure with filled numeric values ready for downstream analytics.","failureModes":["Rows array is empty or missing — validation error","More than 200 rows submitted — request rejected with maxItems violation","Invalid date format (not YYYY-MM-DD) — schema validation failure","Unknown field or method enum value — validation error","All values for the target field are null — mean/median undefined, may return zero or error","Row missing required fields (row_id, event_type, date) — row-level validation failure"],"whenToPreferThis":"Choose this endpoint when you have a bounded batch of up to 200 event attendance records with null or missing numeric values that need to be filled locally using simple statistical imputation (zero, mean, or median) — no external data sources or forecasting required. Ideal for data-cleaning steps in ETL pipelines, report preparation, or dashboard ingestion where nulls must be resolved before aggregation.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T19:01:12.763Z","isFirstParty":false,"canonicalSlug":"event-attendance-missing-value-fill-d7dc6a51"}