{"uid":"cap_0_jfW3cRCD61IGGhxAn4f","slug":"join-coverage-string-normalisation-category-frequencies-7d3c0e42","name":"Join Coverage — String Normalisation + Category Frequencies","description":"Join coverage — String normalisation + Category frequencies: String normalisation + Category frequencies for supplied join coverage records (matched_rows, source_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-09-024?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","matched_rows","source_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"matched_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source_rows":1,"matched_rows":10,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_rows":2,"matched_rows":20,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_rows":3,"matched_rows":15,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_rows":4,"matched_rows":30,"dataset_group":"group-b"}],"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_tekNS6t4AKruP8-YuPxZH","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":"Analyzes join coverage data (matched_rows, source_rows) by running string normalization and category frequency reports on up to 200 supplied rows.","exampleAgentPrompt":"Can you run string normalization and category frequency analysis on my join coverage records? I have 4 rows with dataset groups 'group-a' and 'group-b', dated from 2026-10-01 to 2026-10-04, with matched_rows values of 10, 20, 15, 30 and source_rows of 1, 2, 3, 4.","exampleUseCases":[{"title":"ETL pipeline join quality audit","prompt":"I ran a join between two datasets and got these coverage records — can you normalize the group names and show me the frequency breakdown by dataset_group? I have 8 rows across groups 'sales_US', 'sales_uk', and 'Sales_EU' with matched and source row counts for each date in October 2026."},{"title":"Data team weekly join coverage report","prompt":"Give me a category frequency report on these join coverage results from our weekly pipeline run. I've got 50 rows with dataset_group labels like 'customers', 'orders', and 'inventory', dates in November 2026, and matched_rows and source_rows counts for each. I want to see how the groups are distributed and any string normalization issues."},{"title":"Diagnosing low match rates by group","prompt":"Something looks off in our join results — can you analyze these 20 join coverage records to see which dataset_group categories appear most often and normalize the group name strings? Rows span 2025-09-01 to 2025-09-20 with source_rows up to 500 and matched_rows sometimes lower than expected."}],"resultDescription":"Returns two analytical reports for the supplied join coverage rows: (1) a string normalization report that standardizes and cleans string fields like dataset_group and date, and (2) a category frequency report showing how often each category (e.g. dataset_group value) appears across the submitted rows. Both reports are computed locally with no external lookups.","failureModes":["Rows array is empty (minItems: 1 violated) — request rejected","More than 200 rows submitted (maxItems exceeded) — request rejected","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) on any row — validation error","Date field not matching YYYY-MM-DD pattern — validation error","row_id or dataset_group exceeding 80 character limit — validation error","matched_rows or source_rows outside allowed numeric range — validation error","Payment of 0.01 USDC not provided or rejected — 402 response"],"whenToPreferThis":"Choose this endpoint when you have tabular join coverage data with matched_rows and source_rows fields and need both string normalization and category frequency distribution in a single call. It is ideal for data engineers auditing ETL join quality, analysts checking dataset group distributions, or pipelines that need lightweight local analytics without external API calls or predictions. Prefer this over general-purpose analytics tools when you specifically need the combination of string normalization and category frequency for up to 200 join coverage records at low cost.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:40.486Z","isFirstParty":false,"canonicalSlug":"join-coverage-string-normalisation-category-frequencies-7d3c0e42"}