{"uid":"cap_hChDyNfONq7fCcGaj8-lA","slug":"data-reconciliation-string-normalisation-numeric-distribution-analysis-fc0e7ce5","name":"Data Reconciliation: String Normalisation + Numeric Distribution Analysis","description":"Data reconciliation — String normalisation + Numeric distribution: String normalisation + Numeric distribution 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-022?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},"field":{"enum":["source_total","target_total"],"type":"string","default":"source_total"}}},"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_nad1myB2TeAuMUNsp0wIH","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 — string normalisation and numeric distribution — on supplied source/target reconciliation row data (up to 200 rows) for $0.01 USDC.","exampleAgentPrompt":"Can you run a string normalisation and numeric distribution analysis on my reconciliation data? I have 4 rows: row-1 on 2026-10-01 in group-a with source_total 10 and target_total 1, row-2 on 2026-10-02 in group-b with source_total 20 and target_total 2, row-3 on 2026-10-03 in group-a with source_total 15 and target_total 3, row-4 on 2026-10-04 in group-b with source_total 30 and target_total 4 — analyze the source_total field.","exampleUseCases":[{"title":"Monthly finance reconciliation audit","prompt":"I have 50 rows of monthly finance reconciliation data with source and target totals across two groups — can you run string normalisation and numeric distribution reports on the source_total field so I can see how the values are spread and whether anything looks off?"},{"title":"Multi-group dataset discrepancy review","prompt":"We have reconciliation records from group-a and group-b covering dates in Q4 2026 — run both the string normalisation and numeric distribution reports on target_total across all 120 rows so we can identify distribution anomalies between the groups."},{"title":"Daily ETL pipeline output validation","prompt":"Our ETL pipeline outputs daily source and target totals — here are 30 rows from this week's run, can you analyze the target_total field with string normalisation and a numeric distribution summary to confirm the data looks consistent before we sign off?"}],"resultDescription":"Two independent analytical reports: (1) a string normalisation report covering the text/categorical fields in the supplied rows, and (2) a numeric distribution report summarising the statistical spread of the selected field (source_total or target_total) across up to 200 reconciliation rows. Reports are generated locally with no external lookups or predictions.","failureModes":["Fewer than 1 or more than 200 rows submitted — rejected with validation error","Row missing required fields (row_id, dataset_group, date, source_total, target_total) — row-level validation failure","Date field not matching YYYY-MM-DD pattern — schema validation error","Numeric values outside ±1,000,000,000,000 range — validation error","Invalid field enum value (not source_total or target_total) — schema rejection","Payment of 0.01 USDC not completed — 402 payment required response"],"whenToPreferThis":"Choose this endpoint when you need lightweight, low-cost (0.01 USDC) local analytical reports — specifically string normalisation and numeric distribution — on a batch of up to 200 data reconciliation rows with source and target totals. Ideal when no external data lookup, prediction, or professional assessment is needed and you want two bundled reports in a single call. Not suited for real-time lookups, machine learning predictions, or datasets exceeding 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:58.549Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-string-normalisation-numeric-distribution-analysis-fc0e7ce5"}