{"uid":"cap_VmUkwePNWFBaqmpaPMSOA","slug":"data-ingestion-batches-grouped-numeric-summary-explicit-missing-value-4b8cb885","name":"Data Ingestion Batches — Grouped Numeric Summary + Explicit Missing-Value Fill","description":"Data ingestion batches — Grouped numeric summary + Explicit missing-value fill: Grouped numeric summary + Explicit missing-value fill for supplied data ingestion batches records (received_rows, accepted_rows). 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-01-099?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","received_rows","accepted_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"accepted_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"received_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","accepted_rows":1,"dataset_group":"group-a","received_rows":10},{"date":"2026-10-02","row_id":"row-2","accepted_rows":2,"dataset_group":"group-b","received_rows":20},{"date":"2026-10-03","row_id":"row-3","accepted_rows":3,"dataset_group":"group-a","received_rows":15},{"date":"2026-10-04","row_id":"row-4","accepted_rows":4,"dataset_group":"group-b","received_rows":30}],"maxItems":200,"minItems":1},"field":{"enum":["received_rows","accepted_rows"],"type":"string","default":"received_rows"},"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_sbN1_Va6iXei1epZwEM-i","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 grouped numeric summary and fills missing values (zero/mean/median) for up to 200 data ingestion batch records across received_rows and accepted_rows fields.","exampleAgentPrompt":"Can you summarize my data ingestion batch records by dataset group and fill any missing accepted_rows values using the median? I have up to 50 rows with fields like row_id, dataset_group, date, received_rows, and accepted_rows.","exampleUseCases":[{"title":"ETL pipeline quality audit","prompt":"I have 80 rows of daily ingestion batch data with dataset_group, received_rows, and accepted_rows — some accepted_rows values are null. Can you fill those nulls using the mean and give me a grouped numeric summary by dataset group?"},{"title":"Received row count group comparison","prompt":"Summarize my received_rows figures grouped by dataset for these 120 ingestion batch records, and fill any missing received_rows values with zero so nothing is skipped in the report."},{"title":"Acceptance rate analysis by dataset","prompt":"I want to understand how many rows are being accepted vs received across different dataset groups. Here are 40 ingestion batch records — please group them and give me a numeric summary, filling any missing accepted_rows with the median."}],"resultDescription":"Returns two analytical reports: (1) a grouped numeric summary of the chosen field (received_rows or accepted_rows) broken down by dataset_group, and (2) the same dataset with missing values explicitly filled using the selected method (zero, mean, or median). Both reports operate on up to 200 supplied rows using local analytical engines with no external lookups.","failureModes":["More than 200 rows submitted — request exceeds the maxItems limit and will be rejected","Missing required fields (row_id, dataset_group, date, received_rows, or accepted_rows) on any row causes validation failure","Invalid date format (not YYYY-MM-DD) triggers schema validation error","Numeric values outside the ±1,000,000,000,000 range are rejected","Invalid fill method or field enum value causes a bad request error","Empty rows array (minItems: 1 violated) returns an error"],"whenToPreferThis":"Choose this endpoint when you have a batch of data ingestion records (up to 200 rows) with received_rows and accepted_rows metrics and need both a grouped statistical summary by dataset group AND explicit missing-value imputation in a single call. It is especially suited for data engineering teams monitoring ETL pipeline quality without needing external data sources or real-time lookups. Prefer this over general analytics tools when cost-efficiency matters ($0.01 USDC for two reports) and the data is already structured with the required schema fields.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:58:27.531Z","isFirstParty":false,"canonicalSlug":"data-ingestion-batches-grouped-numeric-summary-explicit-missing-value-4b8cb885"}