{"uid":"cap_6hnwJx2oBGw-XwXWgEV96","slug":"aggregation-checks-weighted-mean-missing-value-fill-27e9b6e2","name":"Aggregation Checks: Weighted Mean & Missing-Value Fill","description":"Aggregation checks — Secondary-measure weighted mean + Explicit missing-value fill: Secondary-measure weighted mean + Explicit missing-value fill for supplied aggregation checks records (source_sum, aggregate_sum). 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-analytics-17-187?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","source_sum","aggregate_sum"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_sum":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"aggregate_sum":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source_sum":10,"aggregate_sum":1,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_sum":20,"aggregate_sum":2,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_sum":15,"aggregate_sum":3,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_sum":30,"aggregate_sum":4,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["source_sum","aggregate_sum"],"type":"string","default":"source_sum"},"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_MLZmzCYqy1b-gAx6v5sl3","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 a secondary-measure weighted mean and fills explicit missing values for up to 200 aggregation-check records (source_sum, aggregate_sum)","exampleAgentPrompt":"I have 4 rows of aggregation check data across two groups — row-1 (group-a, 2026-10-01, source_sum=10, aggregate_sum=1), row-2 (group-b, 2026-10-02, source_sum=20, aggregate_sum=2), row-3 (group-a, 2026-10-03, source_sum=15, aggregate_sum=3), row-4 (group-b, 2026-10-04, source_sum=30, aggregate_sum=4) — can you run a weighted mean and median missing-value fill on the source_sum field and give me both reports?","exampleUseCases":[{"title":"Fill nulls in aggregation pipeline output","prompt":"I have 12 rows of aggregation check data with some null source_sum values — can you fill those missing values using the mean of the non-null rows and give me the report?"},{"title":"Weighted mean across dataset groups","prompt":"Here are 50 aggregation records across three dataset groups with source_sum and aggregate_sum columns — please compute the secondary-measure weighted mean on aggregate_sum for me."},{"title":"Audit aggregation totals for data quality","prompt":"I want to run two aggregation-check analytical reports on this batch of 80 rows — one weighted mean on source_sum and one with zero-fill for the missing values — can you do both?"}],"resultDescription":"Returns two independent analytical reports for the supplied rows: (1) a secondary-measure weighted mean computed over the chosen field (source_sum or aggregate_sum), and (2) explicit missing-value fill results using the selected method (zero, mean, or median). Reports are generated locally without live lookup or external data.","failureModes":["Rows array is empty or exceeds 200 items — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","source_sum or aggregate_sum values outside ±1,000,000,000,000 range — rejected","Unrecognized fill method or field enum value — request rejected","Missing required fields (row_id, dataset_group, date) — schema validation error"],"whenToPreferThis":"Choose this endpoint when you need fast, local statistical computation on small-to-medium batches (up to 200 rows) of aggregation check records — specifically when you need a weighted mean on a secondary measure AND missing-value imputation in a single paid call. It is not suitable for live data lookups, predictions, large datasets, or professional audit assessments.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T12:38:57.799Z","isFirstParty":false,"canonicalSlug":"aggregation-checks-weighted-mean-missing-value-fill-27e9b6e2"}