{"uid":"cap_KY_1gZx3D08kjJcdjlE1B","slug":"duplicate-observations-grouped-numeric-summary-category-frequencies-23358901","name":"Duplicate Observations — Grouped Numeric Summary + Category Frequencies","description":"Duplicate observations — Grouped numeric summary + Category frequencies: Grouped numeric summary + Category frequencies 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-086?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"}}},"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_JVs6rmuQWCo_TvbcexE1T","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":"Runs two local analytical reports on duplicate observation data: a grouped numeric summary and category frequency breakdown for duplicate_rows and total_rows fields across up to 200 rows.","exampleAgentPrompt":"Can you run a grouped numeric summary and category frequency report on my duplicate observation data? I have 4 rows covering groups A and B from October 2026, with duplicate_rows counts like 10, 20, 15, and 30 against total_rows of 1 through 4 — analyze the duplicate_rows field.","exampleUseCases":[{"title":"Data quality audit by dataset group","prompt":"I have a list of 50 duplicate observation records across 5 dataset groups with their duplicate_rows and total_rows counts. Can you give me a grouped numeric summary and show me how frequently each dataset_group appears, analyzing the duplicate_rows field?"},{"title":"Deduplication rate analysis across partitions","prompt":"My ETL pipeline flagged duplicates across 8 table partitions — I have the counts as rows with dataset_group, date, duplicate_rows, and total_rows. Can you group those numerically and tell me the category breakdown by dataset_group for total_rows?"},{"title":"Weekly duplicate trend summary by category","prompt":"Here are my weekly duplicate observation records for the past month across groups 'raw', 'staging', and 'prod'. Can you run a grouped numeric summary and category frequency analysis on duplicate_rows so I can see which group is generating the most duplicates?"}],"resultDescription":"Two analytical reports: (1) a grouped numeric summary showing descriptive statistics (e.g. mean, min, max, count) for the selected numeric field (duplicate_rows or total_rows) broken down by dataset_group, and (2) a category frequency table showing how often each dataset_group value appears across the supplied rows. Both reports are computed locally on the supplied data with no external lookups.","failureModes":["Fewer than 1 row submitted returns a validation error","More than 200 rows submitted exceeds the maxItems limit","Invalid date format (not YYYY-MM-DD) fails pattern validation","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) cause schema rejection","Field enum value not in ['duplicate_rows','total_rows'] causes rejection","Numeric values outside ±1,000,000,000,000 fail min/max validation"],"whenToPreferThis":"Choose this endpoint when you have duplicate observation records with a dataset_group dimension and need both grouped numeric statistics and category frequency counts in a single call at low cost ($0.01 USDC for up to 200 rows). It is ideal for data quality workflows where you want to profile duplication rates across named groups without making any external API calls or predictions. Prefer it over general analytics tools when your data already conforms to the duplicate_rows/total_rows schema and you need lightweight, deterministic profiling.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:18.192Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-grouped-numeric-summary-category-frequencies-23358901"}