{"uid":"cap_bwSC3s1krKvs9b8Armdj7","slug":"aggregation-checks-two-measure-correlation-explicit-missing-value-fill-99a5df6f","name":"Aggregation Checks — Two-Measure Correlation + Explicit Missing-Value Fill","description":"Aggregation checks — Two-measure correlation + Explicit missing-value fill: Two-measure correlation + Explicit missing-value fill for supplied aggregation checks records (source_sum, aggregate_sum). 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-17-184?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","source_sum","aggregate_sum"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_sum":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"aggregate_sum":{"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_sum":10,"aggregate_sum":1,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_sum":20,"aggregate_sum":2,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_sum":15,"aggregate_sum":3,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_sum":30,"aggregate_sum":4,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["source_sum","aggregate_sum"],"type":"string","default":"source_sum"},"method":{"enum":["zero","mean","median"],"type":"string","default":"median"}}},"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_5zzWiiKuZfuGJ3VHNxgE8","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 Pearson correlation between source_sum and aggregate_sum columns and fills missing values in a chosen field using zero, mean, or median imputation, across up to 200 aggregation check rows.","exampleAgentPrompt":"I have up to 200 rows of aggregation check records each with a row_id, dataset_group, date, source_sum, and aggregate_sum — can you run a two-measure correlation between source_sum and aggregate_sum, and also fill any missing values in source_sum using median imputation?","exampleUseCases":[{"title":"Reconciling source vs aggregate financial sums","prompt":"I've got a table of daily reconciliation records — each row has a row_id, group, date, source_sum, and aggregate_sum — can you calculate the correlation between the two sum columns and fill any nulls in aggregate_sum using the mean?"},{"title":"Imputing missing values in pipeline aggregation data","prompt":"My partnership pipeline export has up to 150 rows with source_sum and aggregate_sum fields but some values are null — please fill the missing source_sum values using median and also tell me how correlated source_sum and aggregate_sum are."},{"title":"Data quality check on grouped aggregation records","prompt":"Before I send this batch of aggregation check records to our reporting system, can you run a correlation check between source_sum and aggregate_sum and zero-fill any missing aggregate_sum entries? There are about 80 rows grouped by dataset_group and dated from last month."}],"resultDescription":"Returns two analytical reports: (1) a Pearson correlation result quantifying the linear relationship between source_sum and aggregate_sum across all supplied rows, and (2) a missing-value fill report showing which rows had null values in the specified field and what values were substituted using the chosen method (zero, mean, or median). No external data is fetched; all analysis is performed on the supplied rows only.","failureModes":["Fewer than 1 row submitted — request rejected","More than 200 rows submitted — exceeds row limit","Invalid date format (not YYYY-MM-DD) — schema validation error","Both source_sum and aggregate_sum are null for most rows — correlation undefined or NaN","Field enum value not one of source_sum or aggregate_sum — validation error","Method enum not one of zero, mean, median — validation error","row_id missing or empty string — required field error","Insufficient non-null pairs for correlation — may return NaN or undefined correlation"],"whenToPreferThis":"Choose this endpoint when you have tabular aggregation check data with source_sum and aggregate_sum columns and need both a statistical correlation measure between those two fields and a missing-value imputation pass in a single API call. It is best suited for data reconciliation workflows, financial auditing, and pipeline QA where you want offline, local analytical computation (no external lookups) on up to 200 rows at low cost. Prefer alternatives if you need more than 2 analytical reports, more than 200 rows, live data enrichment, or a different pair of columns.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:55:24.005Z","isFirstParty":false,"canonicalSlug":"aggregation-checks-two-measure-correlation-explicit-missing-value-fill-99a5df6f"}