{"uid":"cap_6UI9DsMeRSTKg4GrbBmB7","slug":"time-series-completeness-iqr-outlier-flags-explicit-missing-value-fill-a97b3234","name":"Time Series Completeness — IQR Outlier Flags + Explicit Missing-Value Fill","description":"Time series completeness — IQR outlier flags + Explicit missing-value fill: IQR outlier flags + Explicit missing-value fill for supplied time series completeness records (observed_points, expected_points). 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-16-180?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","observed_points","expected_points"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"dataset_group":{"type":"string","default":"","maxLength":80},"expected_points":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"observed_points":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","dataset_group":"group-a","expected_points":1,"observed_points":10},{"date":"2026-10-02","row_id":"row-2","dataset_group":"group-b","expected_points":2,"observed_points":20},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","expected_points":3,"observed_points":15},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","expected_points":4,"observed_points":30}],"maxItems":200,"minItems":1},"field":{"enum":["observed_points","expected_points"],"type":"string","default":"observed_points"},"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_uj05aoWN-woqjN3KdpcNK","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 time series completeness records (observed vs expected points) using IQR-based outlier detection and explicit missing-value filling, returning two independent analytical reports for up to 200 rows.","exampleAgentPrompt":"I have 50 rows of daily completeness records with observed_points and expected_points from 2024-01-01 to 2024-02-19 across two dataset groups — can you flag IQR outliers and fill any missing observed_points using the median, then give me both reports?","exampleUseCases":[{"title":"Daily pipeline completeness audit","prompt":"I have 120 daily records from our data pipeline with observed_points and expected_points per dataset group — please flag any IQR outliers in observed_points and fill in any missing values using median so I can see both the outlier report and the filled data."},{"title":"Sensor coverage gap detection","prompt":"Here are 90 rows of sensor coverage data by date and group, each with expected_points and observed_points. Can you run IQR outlier flagging on expected_points and fill the missing ones with zero, giving me two separate analysis reports?"},{"title":"ETL completeness QA before reporting","prompt":"Before I finalize my weekly report, can you check these 60 completeness records for outliers using IQR and also fill any null observed_points with the mean? I need both the outlier flags and the filled dataset back."}],"resultDescription":"Two independent analytical reports: (1) IQR outlier flag report identifying which rows have outlying values in the specified field across all rows, and (2) an explicit missing-value fill report where null/missing values in the specified field are replaced using the chosen method (zero, mean, or median). Results are scoped to the supplied rows (up to 200) and computed locally without external lookups.","failureModes":["Exceeding 200 rows returns an error or truncation","Invalid date format (not YYYY-MM-DD) causes validation failure","Missing required fields (row_id, observed_points, expected_points) cause rejection","Providing all-null values for the target field may produce degenerate fill results","Non-numeric values in observed_points or expected_points fail schema validation","Empty rows array is rejected (minItems: 1)"],"whenToPreferThis":"Choose this endpoint when you need both IQR-based outlier detection AND missing-value imputation applied to time series completeness data in a single paid call. It is particularly suited for data quality workflows involving observed vs expected point counts grouped by date and category, with up to 200 rows. It is purely local/analytical — no predictions, live data lookups, or external actions are performed. Prefer it over single-report endpoints when you need both outlier flags and filled data simultaneously at low cost ($0.01 for both reports).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:45.562Z","isFirstParty":false,"canonicalSlug":"time-series-completeness-iqr-outlier-flags-explicit-missing-value-fill-a97b3234"}