{"uid":"cap_1C_YShokhwmMG5Ej3X0L8","slug":"validation-rule-results-exact-row-deduplication-explicit-missing-8ea1f971","name":"Validation Rule Results — Exact Row Deduplication + Explicit Missing-Value Fill","description":"Validation rule results — Exact row deduplication + Explicit missing-value fill: Exact row deduplication + Explicit missing-value fill for supplied validation rule results records (passed_rules, total_rules). 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-08-054?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","passed_rules","total_rules"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"total_rules":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"passed_rules":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","total_rules":1,"passed_rules":10,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","total_rules":2,"passed_rules":20,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","total_rules":3,"passed_rules":15,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","total_rules":4,"passed_rules":30,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["passed_rules","total_rules"],"type":"string","default":"passed_rules"},"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_80WBfYaueNP6-6Vu0gpTg","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":"Deduplicates exact duplicate rows and fills missing values in validation rule result records (passed_rules, total_rules) using a chosen fill strategy, producing 2 analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you deduplicate my validation rule results and fill any missing passed_rules values using median — here are up to 200 rows with row_id, dataset_group, date, passed_rules, and total_rules fields?","exampleUseCases":[{"title":"Clean data quality pipeline results","prompt":"I have validation rule results from my data pipeline with some duplicate rows and missing passed_rules values — can you deduplicate the records and fill the blanks using the median strategy? I'll send up to 150 rows with row_id, dataset_group, date, passed_rules, and total_rules."},{"title":"Impute missing total_rules with zero fill","prompt":"My dataset has validation rule records where total_rules is sometimes null — can you remove any exact duplicate rows and fill those missing total_rules values with zero across my 80 rows?"},{"title":"Prep validation metrics for reporting","prompt":"Before I run my weekly data quality report, I need to deduplicate my validation results and fill any gaps in the passed_rules column using the mean — can you clean up these 200 rows covering multiple dataset groups and dates?"}],"resultDescription":"Two analytical reports covering the supplied validation rule result records: one for passed_rules and one for total_rules. Each report reflects the dataset after exact duplicate rows have been removed and missing values in the specified field have been filled using the chosen method (zero, mean, or median). No external lookups or predictions are performed; all processing uses local analytical engines.","failureModes":["Fewer than 1 row supplied — request rejected","More than 200 rows supplied — request rejected","Invalid date format (not YYYY-MM-DD) — validation error","Missing required fields (row_id, dataset_group, date) — schema error","Numeric values outside allowed range — validation error","Invalid fill method enum value — schema error","Invalid field enum value — schema error"],"whenToPreferThis":"Choose this endpoint when you have validation rule result records (passed_rules, total_rules) that contain exact duplicate rows or missing numeric values and you need lightweight, local data cleaning without any external lookups, predictions, or side effects. It is ideal for pre-processing data quality metrics before reporting or downstream analysis, especially when you need both deduplication and missing-value imputation in a single call for up to 200 rows at minimal cost.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-11T12:48:34.730Z","isFirstParty":false,"canonicalSlug":"validation-rule-results-exact-row-deduplication-explicit-missing-8ea1f971"}