{"uid":"cap_zbkxohDg6cZ7pvFxD2flZ","slug":"duplicate-observations-analytics-date-by-category-pivot-missing-value-fcd9b3d7","name":"Duplicate Observations Analytics: Date-by-Category Pivot + Missing Value Fill","description":"Duplicate observations — Date by category pivot + Explicit missing-value fill: Date by category pivot + 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-189?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"}}},"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_Da3QC5WCvjRqqZkGESsey","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":"Pivots duplicate-observation records by date and category, then fills missing values using zero, mean, or median imputation — returns two analytical reports for up to 200 rows.","exampleAgentPrompt":"I have 4 rows of duplicate observation data across two groups (group-a and group-b) dated 2026-10-01 through 2026-10-04 — can you pivot them by date and category and fill any missing duplicate_rows values using median imputation?","exampleUseCases":[{"title":"Data quality audit across pipeline stages","prompt":"I've got records from two dataset groups showing duplicate_rows and total_rows counts by day for October — can you pivot them by date and group, and fill any missing duplicate_rows values with the median so I can see data quality trends clearly?"},{"title":"ETL deduplication monitoring report","prompt":"I'm tracking duplicate rows in my ETL pipeline across groups alpha, beta, and gamma over the past week. Pivot the data by date and category and use zero-fill for any missing total_rows entries so I can spot which days had the most duplication."},{"title":"Missing value imputation for downstream analysis","prompt":"Some of my duplicate observation records have null duplicate_rows values — can you run a pivot by date and dataset group, then fill those nulls with the group mean so the data is ready for downstream reporting?"}],"resultDescription":"Returns two analytical reports: (1) a date-by-category pivot table showing the selected field (duplicate_rows or total_rows) across groups and dates, and (2) the same data with missing values explicitly filled using the chosen method (zero, mean, or median). Both reports are computed locally from the supplied rows without external lookups.","failureModes":["Input array is empty or exceeds 200 rows — validation error","date fields don't match YYYY-MM-DD pattern — schema validation failure","duplicate_rows or total_rows values outside allowed numeric range — validation error","Missing required fields (row_id, dataset_group, date) in any row — rejected","Invalid fill method enum value — schema error"],"whenToPreferThis":"Choose this endpoint when you have tabular duplicate-observation data (with duplicate_rows and total_rows per date and group) that needs to be reshaped into a date-by-category pivot and have missing values imputed — all in a single low-cost call. It is ideal for data quality reporting, ETL monitoring dashboards, and pre-processing before downstream analysis when you need both the pivoted view and the imputed dataset together. It is not suitable for live data fetching, prediction, or analysis of non-duplicate-count datasets.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T07:19:39.443Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-analytics-date-by-category-pivot-missing-value-fcd9b3d7"}