{"uid":"cap_JLja8lzzmX_M06oDrvTGg","slug":"duplicate-observations-analytics-trailing-mean-series-missing-value-880a9274","name":"Duplicate Observations Analytics: Trailing Mean Series + Missing-Value Fill","description":"Duplicate observations — Trailing mean series + Explicit missing-value fill: Trailing mean series + Explicit missing-value fill for supplied duplicate observations records (duplicate_rows, total_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-04-154?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","duplicate_rows","total_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"total_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"duplicate_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","total_rows":1,"dataset_group":"group-a","duplicate_rows":10},{"date":"2026-10-02","row_id":"row-2","total_rows":2,"dataset_group":"group-b","duplicate_rows":20},{"date":"2026-10-03","row_id":"row-3","total_rows":3,"dataset_group":"group-a","duplicate_rows":15},{"date":"2026-10-04","row_id":"row-4","total_rows":4,"dataset_group":"group-b","duplicate_rows":30}],"maxItems":200,"minItems":1},"field":{"enum":["duplicate_rows","total_rows"],"type":"string","default":"duplicate_rows"},"method":{"enum":["zero","mean","median"],"type":"string","default":"median"},"window":{"type":"integer","default":2,"maximum":200,"minimum":2}}},"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_Hytk_FWf065_VzCIlvFGB","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 a trailing mean time series and fills explicit missing values for up to 200 duplicate-observation records, returning two analytical reports per call.","exampleAgentPrompt":"I have 5 rows of duplicate observation records for two dataset groups (group-a and group-b) with dates from 2026-10-01 to 2026-10-05, each with duplicate_rows and total_rows values — can you run the trailing mean series with a window of 3 on the duplicate_rows field and fill any missing values using the median method?","exampleUseCases":[{"title":"Data quality audit smoothing","prompt":"I'm auditing data quality for our pipeline and have 20 daily records across three dataset groups with duplicate_rows and total_rows counts. Can you compute a trailing mean with a window of 5 on the duplicate_rows field and fill any nulls using the mean method so I can see the smoothed trend?"},{"title":"Missing value imputation for reporting","prompt":"Some entries in my duplicate observation log have null values for total_rows. I have 50 rows across two groups dated over the past two months — can you fill those missing values using the median method and also give me the trailing mean series with a window of 7?"},{"title":"Rolling average for dataset group comparison","prompt":"I want to compare duplicate row trends across group-a and group-b over the last quarter. I have 100 daily records — please compute a trailing mean series with window size 4 on the duplicate_rows field and zero-fill any missing entries."}],"resultDescription":"Two analytical reports per call: (1) a trailing mean time series computed over the specified window for the chosen field (duplicate_rows or total_rows), and (2) an explicit missing-value filled series using the selected method (zero, mean, or median). Both reports are derived locally from the supplied rows with no external lookups.","failureModes":["More than 200 rows submitted — exceeds maximum batch size","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) causes validation failure","Date strings not in YYYY-MM-DD format rejected by pattern validation","Window size outside range 2–200 returns error","Invalid enum value for field or method parameter causes schema rejection","Payment of 0.01 USDC not included or declined results in 402 response"],"whenToPreferThis":"Choose this endpoint when you need both a trailing mean time series and explicit missing-value imputation for duplicate-observation metrics (duplicate_rows, total_rows) in a single call. It is ideal for lightweight, offline data quality analytics on up to 200 rows without needing a full analytics platform. Prefer it over general-purpose statistics APIs when your data is already structured as duplicate observation records with dataset groups and dates, and you need two complementary views — smoothed trend and gap-filled series — delivered together at low cost.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T07:19:32.910Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-analytics-trailing-mean-series-missing-value-880a9274"}