{"uid":"cap_WOSHamPVzjyM8Le0wDmLu","slug":"simulation-caches-exact-row-deduplication-trailing-mean-series-f9878559","name":"Simulation Caches — Exact Row Deduplication + Trailing Mean Series","description":"Simulation caches — Exact row deduplication + Trailing mean series: Exact row deduplication + Trailing mean series for supplied simulation caches records (cache_gb, simulation_seconds). 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-creative-08-045?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","cache_gb","simulation_seconds"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"cache_gb":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"asset_group":{"type":"string","default":"","maxLength":80},"simulation_seconds":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","cache_gb":10,"asset_group":"group-a","simulation_seconds":1},{"date":"2026-10-02","row_id":"row-2","cache_gb":20,"asset_group":"group-b","simulation_seconds":2},{"date":"2026-10-03","row_id":"row-3","cache_gb":15,"asset_group":"group-a","simulation_seconds":3},{"date":"2026-10-04","row_id":"row-4","cache_gb":30,"asset_group":"group-b","simulation_seconds":4}],"maxItems":200,"minItems":1},"field":{"enum":["cache_gb","simulation_seconds"],"type":"string","default":"cache_gb"},"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_IjRPlxvK-ysY21vz5CE6V","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":"Performs exact row deduplication and trailing mean series analysis on simulation cache records (cache_gb, simulation_seconds) for up to 200 rows.","exampleAgentPrompt":"Deduplicate my simulation cache records and compute a trailing mean series with a window of 3 for cache_gb — here are my rows: row-1 on 2026-10-01 with cache_gb=10, simulation_seconds=1 for group-a; row-2 on 2026-10-02 with cache_gb=20, simulation_seconds=2 for group-b; row-3 on 2026-10-03 with cache_gb=15, simulation_seconds=3 for group-a.","exampleUseCases":[{"title":"Deduplicating simulation cache logs","prompt":"I have about 50 daily simulation cache records across two asset groups and I think some rows are exact duplicates — can you deduplicate them and also give me a trailing mean series for cache_gb with a window of 4?"},{"title":"Rolling average for simulation seconds","prompt":"Run a trailing mean series on simulation_seconds with a window of 5 across my 120 simulation cache rows, and also flag any exact duplicate records in the dataset."},{"title":"Data quality check before cache reporting","prompt":"Before I generate my weekly simulation cache report, please deduplicate my records and compute a 3-period rolling mean of cache_gb so I can spot anomalies — I'll send you up to 80 rows."}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying and removing identical records from the supplied simulation cache dataset, and (2) a trailing mean series for the selected field (cache_gb or simulation_seconds) computed over the specified rolling window, both derived locally from the supplied rows without external lookups.","failureModes":["Fewer than 1 row supplied — minimum row count not met","More than 200 rows supplied — exceeds maximum row limit","Invalid date format (must be YYYY-MM-DD)","Missing required fields (row_id, asset_group, date, cache_gb, simulation_seconds)","Window size less than 2 or greater than 200","Field value not one of the allowed enum values: cache_gb or simulation_seconds","Numeric values outside the allowed range (-1e12 to 1e12)"],"whenToPreferThis":"Choose this endpoint when you need both exact duplicate detection and rolling mean computation on simulation cache time-series data (cache_gb or simulation_seconds) in a single call for up to 200 rows, without requiring any external data enrichment, predictions, or live lookups. It is ideal for data cleaning and trend analysis workflows on simulation infrastructure metrics at very low cost ($0.01 USDC for both reports).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-21T18:57:34.549Z","isFirstParty":false,"canonicalSlug":"simulation-caches-exact-row-deduplication-trailing-mean-series-f9878559"}