{"uid":"cap_iWt_03Ntopo5VHGL8jDdG","slug":"duplicate-observations-grouped-numeric-summary-explicit-missing-value-34f326fe","name":"Duplicate Observations — Grouped Numeric Summary + Explicit Missing-Value Fill","description":"Duplicate observations — Grouped numeric summary + Explicit missing-value fill: Grouped numeric summary + Explicit missing-value fill for supplied duplicate observations records (duplicate_rows, total_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-04-099?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","duplicate_rows","total_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"total_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"duplicate_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","total_rows":1,"dataset_group":"group-a","duplicate_rows":10},{"date":"2026-10-02","row_id":"row-2","total_rows":2,"dataset_group":"group-b","duplicate_rows":20},{"date":"2026-10-03","row_id":"row-3","total_rows":3,"dataset_group":"group-a","duplicate_rows":15},{"date":"2026-10-04","row_id":"row-4","total_rows":4,"dataset_group":"group-b","duplicate_rows":30}],"maxItems":200,"minItems":1},"field":{"enum":["duplicate_rows","total_rows"],"type":"string","default":"duplicate_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_QDOJQeVQHrZ-SX40LyoJv","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 for duplicate_rows and total_rows fields across up to 200 supplied observation records.","exampleAgentPrompt":"I have up to 200 rows of duplicate observation records with dataset_group, date, duplicate_rows, and total_rows fields — can you give me a grouped numeric summary of the duplicate_rows field and fill any missing values using the median method?","exampleUseCases":[{"title":"Data quality audit by group","prompt":"I have 150 rows of duplicate observation records across two dataset groups — can you summarize the duplicate_rows field grouped by dataset_group and fill any nulls with the median?"},{"title":"Missing value imputation for total rows","prompt":"My dataset has some null total_rows values across groups A and B — can you fill those missing values using the mean method and give me a grouped numeric summary at the same time?"},{"title":"ETL pipeline duplicate tracking","prompt":"I'm tracking duplicates across my ETL pipeline — here are 80 rows with dataset_group, date, duplicate_rows, and total_rows. Can you group them and summarize the duplicate_rows field, filling any gaps with zero?"}],"resultDescription":"Returns two analytical reports: (1) a grouped numeric summary of the specified field (duplicate_rows or total_rows) broken down by dataset_group, and (2) the same dataset with explicit missing-value fills applied using the chosen method (zero, mean, or median). Both reports are computed locally from the supplied data with no external lookups.","failureModes":["Exceeds 200-row limit — request rejected","Missing required fields (row_id, dataset_group, date) — validation error","Invalid date format (must be YYYY-MM-DD) — schema validation failure","Invalid fill method enum value — rejected","All values null for a group — mean/median fill may be undefined","Numeric values outside allowed range — schema rejection"],"whenToPreferThis":"Use this endpoint when you have tabular duplicate-observation data (with duplicate_rows and total_rows fields) and need both a grouped statistical summary and missing-value imputation in a single call. It is purpose-built for data quality analytics on duplicate record metrics and handles up to 200 rows per call at very low cost. Prefer this over general analytics services when your data fits the duplicate_rows/total_rows schema and you need both aggregation and null-filling together.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T07:15:25.758Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-grouped-numeric-summary-explicit-missing-value-34f326fe"}