{"uid":"cap_pNRifLgVdjP6_lL2leOsz","slug":"duplicate-observations-analytics-record-quality-audit-string-a24179a5","name":"Duplicate Observations Analytics — Record Quality Audit + String Normalisation + Category Frequencies","description":"Duplicate observations — Record quality audit + String normalisation + Category frequencies: Record quality audit + String normalisation + Category frequencies for supplied duplicate observations records (duplicate_rows, total_rows). Up to 200 rows; 3 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 3 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-analytics-04-195?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}}},"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_JfBDkeAT-bIFD6gysS4d7","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 three local analytical reports (record quality audit, string normalisation, and category frequencies) on up to 200 rows of duplicate-observation data (duplicate_rows, total_rows) without any external lookups or predictions.","exampleAgentPrompt":"Can you run a full quality audit on my duplicate observations data — I have 4 rows for groups 'group-a' and 'group-b' dated 2026-10-01 through 2026-10-04 with duplicate_rows values of 10, 20, 15, and 30 against total_rows of 1, 2, 3, and 4 — and give me the record quality audit, string normalisation, and category frequency reports all at once?","exampleUseCases":[{"title":"Deduplication pipeline health check","prompt":"I have a batch of 50 dataset records from our ETL pipeline — each has a dataset_group, a date, and counts of duplicate_rows vs total_rows. Can you run the record quality audit, string normalisation check, and category frequency breakdown on all of them so I can see where data quality is weakest?"},{"title":"Dataset group label consistency audit","prompt":"Our data team uses various spellings and casings for dataset group names like 'Group-A', 'group_a', 'GROUPA' across about 80 rows of duplicate tracking logs from Q3. Can you run the string normalisation and category frequency reports to flag inconsistencies and show me how often each group appears?"},{"title":"Weekly duplicate observation monitoring","prompt":"Every Monday I want to review last week's duplicate observation stats — I'll give you 200 rows with row IDs, dates, dataset groups, and duplicate vs total row counts. Please produce the record quality audit and category frequency report so I can spot any groups with unusually high duplicate rates."}],"resultDescription":"Three structured analytical reports returned together: (1) a record quality audit flagging missing, null, or out-of-range values across the supplied rows; (2) a string normalisation report identifying inconsistencies and suggested normalised forms for text fields like dataset_group; and (3) a category frequency table showing the distribution and counts of each unique dataset_group value across the supplied rows.","failureModes":["Fewer than 1 row supplied — request rejected (minItems: 1)","More than 200 rows supplied — request rejected (maxItems: 200)","Invalid date format (not YYYY-MM-DD) — schema validation error","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) — schema validation error","row_id exceeds 80 characters — schema validation error","Payment of 0.01 USDC not fulfilled — 402 Payment Required response","Numeric values outside allowed range (±1,000,000,000,000) — schema validation error"],"whenToPreferThis":"Choose this endpoint when you need three bundled analytical reports (quality audit, string normalisation, category frequencies) on duplicate-observation records in a single low-cost call. It is ideal for batch profiling up to 200 rows of deduplification tracking data without any external data lookups, predictions, or live integrations. Prefer it over single-report alternatives when you need all three report types simultaneously on the same dataset to save on per-call costs.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:44:51.642Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-analytics-record-quality-audit-string-a24179a5"}