{"uid":"cap_dM0ErllKZpW0Pnikd2Gk_","slug":"simulation-caches-record-quality-audit-exact-row-deduplication-5c7cbf69","name":"Simulation Caches — Record Quality Audit + Exact Row Deduplication + Trailing Mean Series","description":"Simulation caches — Record quality audit + Exact row deduplication + Trailing mean series: Record quality audit + Exact row deduplication + Trailing mean series for supplied simulation caches records (cache_gb, simulation_seconds). Up to 200 rows; 3 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 3 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-creative-08-216?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_jZUfQmsFis7FOV2F2xAEF","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 three analytical reports on simulation cache records: a data quality audit, exact row deduplication, and a trailing moving average series for a chosen numeric field.","exampleAgentPrompt":"Run the three-report analysis on my simulation cache dataset — quality audit, exact deduplication, and a trailing mean for cache_gb with a window of 3 — here are my rows: row-1 on 2026-10-01 for group-a with cache_gb=10 and simulation_seconds=120, row-2 on 2026-10-02 for group-b with cache_gb=20 and simulation_seconds=240, row-3 on 2026-10-03 for group-a with cache_gb=15 and simulation_seconds=180.","exampleUseCases":[{"title":"Audit weekly simulation cache logs","prompt":"I have 50 rows of weekly simulation cache logs with cache_gb and simulation_seconds fields — can you run a quality audit, deduplicate exact matches, and compute a trailing mean for cache_gb with a window of 4? Here are the rows: row-1 2026-10-01 group-a cache_gb=10 simulation_seconds=100, row-2 2026-10-02 group-b cache_gb=20 simulation_seconds=200 ..."},{"title":"Deduplicate simulation performance records","prompt":"My simulation performance dataset has some suspected duplicate entries across asset groups. Can you run the exact row deduplication plus quality audit on these 30 records, and also give me a trailing mean of simulation_seconds with a window of 5? Fields are row_id, asset_group, date, cache_gb, simulation_seconds."},{"title":"Rolling average for cache sizing analysis","prompt":"I need to analyze cache growth trends — please run the trailing mean series for cache_gb with a window of 3 on my simulation dataset, and also include the record quality audit and deduplication reports. I have 80 rows across groups group-alpha and group-beta from 2026-09-01 onward."}],"resultDescription":"Returns three independent analytical reports: (1) a record quality audit flagging missing, null, or malformed values in the input rows; (2) an exact row deduplication report identifying fully duplicate records; and (3) a trailing mean time series for the selected numeric field (cache_gb or simulation_seconds) computed with the specified window size. All three reports are computed locally from the supplied data with no external lookups.","failureModes":["Fewer than 1 row supplied — request rejected","More than 200 rows supplied — exceeds maximum row limit","Invalid date format (not YYYY-MM-DD) — row fails schema validation","Window size smaller than 2 or larger than 200 — parameter rejected","Field value not one of 'cache_gb' or 'simulation_seconds' — invalid enum","Null numeric values may reduce trailing mean coverage for those rows","Missing required fields (row_id, asset_group, date) — row rejected"],"whenToPreferThis":"Choose this endpoint when you need all three of: a data quality audit, exact deduplication, and a rolling/trailing mean series computed together in a single call on simulation cache records (cache_gb, simulation_seconds) with up to 200 rows. It is cost-effective at $0.01 for all three reports simultaneously. Prefer alternatives if you only need one of these operations, need more than 200 rows, require live external data lookups, or need to analyze fields beyond cache_gb and simulation_seconds.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-21T18:55:48.366Z","isFirstParty":false,"canonicalSlug":"simulation-caches-record-quality-audit-exact-row-deduplication-5c7cbf69"}