{"uid":"cap_SrnzrAx7so1TG1yqBEL3i","slug":"data-reconciliation-category-frequencies-two-measure-correlation-fdf55b92","name":"Data Reconciliation — Category Frequencies + Two-Measure Correlation","description":"Data reconciliation — Category frequencies + Two-measure correlation: Category frequencies + Two-measure correlation for supplied data reconciliation records (source_total, target_total). 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-11-108?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","source_total","target_total"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_total":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"target_total":{"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_total":10,"target_total":1,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_total":20,"target_total":2,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_total":15,"target_total":3,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_total":30,"target_total":4,"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_YmnEhoc_jxMFPpdz_k1gf","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 data reconciliation records to produce category frequency distributions and a two-measure correlation report between source_total and target_total values.","exampleAgentPrompt":"Analyze these reconciliation records for me — I have up to 50 rows with row IDs, dates, dataset groups like 'region-A' and 'region-B', plus source_total and target_total values for each. Give me the category frequency breakdown by group and the correlation between source and target totals.","exampleUseCases":[{"title":"ETL pipeline source-target drift audit","prompt":"I've got 120 rows from our nightly ETL run with source_total and target_total figures across three dataset groups: 'accounts', 'transactions', and 'adjustments'. Can you compute the category frequencies by group and tell me how correlated the source and target totals are?"},{"title":"Finance team reconciliation reporting","prompt":"Here are 80 reconciliation rows from our monthly close process, each tagged with a date, a row ID, a dataset group like 'GL' or 'subledger', and source vs target amounts. Run the category frequency analysis and two-measure correlation so I can see where things align and where they diverge."},{"title":"Data migration validation check","prompt":"We just migrated data from our old system and I want to validate it — I have 45 rows with source_total and target_total for each record, grouped into 'legacy' and 'new-platform'. Can you give me the group frequency counts and measure the correlation between source and target totals?"}],"resultDescription":"Returns two independent analytical reports: (1) a category frequency distribution showing counts and proportions per dataset_group, and (2) a two-measure correlation report quantifying the statistical relationship between source_total and target_total values across the supplied rows. Covers up to 200 rows per call with no external lookups.","failureModes":["Input array exceeds 200 rows — request will be rejected or truncated","Missing required fields (row_id, dataset_group, date, source_total, target_total) cause row-level validation errors","Dates not matching YYYY-MM-DD pattern will fail schema validation","All-null source_total or target_total values may produce undefined or degenerate correlation results","Fewer than 2 distinct groups yields a trivial frequency report","Single-row input produces no meaningful correlation"],"whenToPreferThis":"Choose this endpoint when you have data reconciliation records with source and target totals grouped by category and need both a frequency breakdown and a correlation statistic in a single low-cost call. It is ideal for ETL auditing, monthly close validation, and data migration checks where you want fast, local statistical analysis without sending data to an external model or prediction service. Prefer it over general analytics APIs when your data fits the source_total/target_total/dataset_group schema and you want both reports bundled for $0.01.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:46.661Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-category-frequencies-two-measure-correlation-fdf55b92"}