{"uid":"cap_Ix4MBlm3xk4Wmts-mYJS3","slug":"duplicate-observations-category-frequencies-secondary-measure-5a0fa5ec","name":"Duplicate Observations — Category Frequencies + Secondary-Measure Weighted Mean","description":"Duplicate observations — Category frequencies + Secondary-measure weighted mean: Category frequencies + Secondary-measure weighted mean 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-109?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_UoHoab1PyffPLBalfeDNm","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 category-frequency distribution and secondary-measure weighted mean for up to 200 duplicate-observation records in two independent analytical reports.","exampleAgentPrompt":"Run category frequency and weighted mean analysis on these duplicate observation records — I have 4 rows across groups 'group-a' and 'group-b' from October 2026, with duplicate_rows counts of 10, 20, 15, 30 and total_rows of 1, 2, 3, 4. Use duplicate_rows as the primary field.","exampleUseCases":[{"title":"Data quality audit by dataset group","prompt":"I have a table of duplicate row counts across multiple dataset groups from last quarter — can you give me the category frequencies for each group and a weighted mean of duplicate_rows? Here are the records: group-a on 2026-10-01 had 10 duplicate rows out of 1 total, group-b on 2026-10-02 had 20 out of 2, group-a on 2026-10-03 had 15 out of 3, and group-b on 2026-10-04 had 30 out of 4. Use duplicate_rows as the field."},{"title":"ETL pipeline duplicate monitoring report","prompt":"We run nightly ETL jobs and I want to understand our duplicate observation patterns. I have 6 records with row_id, dataset_group, date, duplicate_rows, and total_rows. Please compute the category frequencies by dataset_group and the weighted mean of total_rows across all entries."},{"title":"Comparing duplication rates across table partitions","prompt":"I'm profiling data duplication across our warehouse partitions. I have 8 records per partition labeled as dataset groups. Can you calculate the frequency of each group in the dataset and the weighted mean of duplicate_rows so I can spot which partitions are worst affected?"}],"resultDescription":"Two analytical reports: (1) category frequencies showing how often each dataset_group value appears across the supplied rows, and (2) a secondary-measure weighted mean for either duplicate_rows or total_rows, computed using the other numeric field as weights — all derived locally from the submitted records with no external lookups.","failureModes":["Fewer than 1 or more than 200 rows submitted — request rejected","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) — validation error","Invalid date format (not YYYY-MM-DD) — schema rejection","Null numeric values that affect weighted mean calculation — may produce NaN or skewed results","Invalid 'field' enum value outside ['duplicate_rows','total_rows'] — schema rejection"],"whenToPreferThis":"Choose this endpoint when you need two specific statistical summaries — category frequency counts and a weighted mean — on duplicate-observation records that you already have locally, and you want both reports in a single low-cost API call. It is ideal for data quality workflows where you want to understand the distribution of duplicate records across categorical groups without sending data to an external analytical platform.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:53:55.980Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-category-frequencies-secondary-measure-5a0fa5ec"}