{"uid":"cap_nZE7k3diQinVU9rJizGs_","slug":"time-series-completeness-string-normalisation-exact-row-deduplication-4a41db08","name":"Time Series Completeness — String Normalisation + Exact Row Deduplication","description":"Time series completeness — String normalisation + Exact row deduplication: String normalisation + Exact row deduplication 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-020?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}}},"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_UJ8KVf8l2G-Oz0hKu7HxV","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":"Normalises strings and deduplicates exact rows in time series completeness records (observed_points vs expected_points) for up to 200 rows, producing 2 independent analytical reports.","exampleAgentPrompt":"Can you normalise the strings and remove any exact duplicate rows from my time series completeness records? I have 4 rows across two dataset groups — group-a and group-b — with dates from 2026-10-01 to 2026-10-04, and observed/expected point counts for each day.","exampleUseCases":[{"title":"Deduplicating daily sensor completeness logs","prompt":"I've got daily completeness logs for two sensor groups — 'sensor-north' and 'sensor-south' — covering the past week, with observed and expected data points for each date. Can you normalise the strings and strip out any exact duplicate rows before I load this into our dashboard?"},{"title":"Cleaning pipeline completeness records before reporting","prompt":"Before I generate our monthly data quality report, I need to clean up these completeness records for our ETL pipeline — there are about 120 rows with dataset groups like 'pipeline-A' and 'pipeline-B' from October, and I suspect there are duplicates and inconsistent string casing. Can you normalise and deduplicate them?"},{"title":"Standardising multi-group time series for QA audit","prompt":"We have completeness data from three dataset groups collected over 60 days — observed points and expected points per date — and I need to normalise all the string fields and remove any exact row duplicates before passing this to our QA team. Can you run the string normalisation and deduplication analysis on these rows?"}],"resultDescription":"Returns 2 independent analytical reports covering the input rows: one addressing string normalisation (standardising casing, whitespace, and formatting in string fields like dataset_group and row_id), and one performing exact row deduplication (identifying and removing rows where all fields are identical). No live lookups, predictions, or external actions are performed — all processing is local and analytical.","failureModes":["More than 200 rows submitted — request exceeds the maxItems limit and will be rejected","Missing required fields (row_id, date, observed_points, expected_points) cause row-level validation errors","Malformed date strings not matching YYYY-MM-DD pattern will fail schema validation","Null values in observed_points or expected_points may affect deduplication logic depending on null handling","Empty rows array (minItems: 1 not met) will be rejected"],"whenToPreferThis":"Choose this endpoint when you need to clean and deduplicate time series completeness records (observed vs expected point counts) locally without any external API calls, live data lookups, or predictions. It is ideal for pre-processing small-to-medium batches (up to 200 rows) of completeness data before ingestion into dashboards, QA pipelines, or reporting systems. Prefer this over general-purpose deduplication tools when your data specifically follows the date/dataset_group/observed_points/expected_points schema and you need both string normalisation and exact deduplication in a single low-cost call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T19:42:02.302Z","isFirstParty":false,"canonicalSlug":"time-series-completeness-string-normalisation-exact-row-deduplication-4a41db08"}