{"uid":"cap_6D47dLIXyHKHfGOzjWDfO","slug":"third-party-reviews-date-category-pivot-explicit-missing-value-fill-ad47ce84","name":"Third-Party Reviews — Date×Category Pivot + Explicit Missing-Value Fill","description":"Third party reviews — Date by category pivot + Explicit missing-value fill: Date by category pivot + Explicit missing-value fill for supplied third party reviews records (vendors_reviewed, outstanding_actions). 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-security-24-189?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","control_group","date","vendors_reviewed","outstanding_actions"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"control_group":{"type":"string","default":"","maxLength":80},"vendors_reviewed":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"outstanding_actions":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","control_group":"group-a","vendors_reviewed":10,"outstanding_actions":1},{"date":"2026-10-02","row_id":"row-2","control_group":"group-b","vendors_reviewed":20,"outstanding_actions":2},{"date":"2026-10-03","row_id":"row-3","control_group":"group-a","vendors_reviewed":15,"outstanding_actions":3},{"date":"2026-10-04","row_id":"row-4","control_group":"group-b","vendors_reviewed":30,"outstanding_actions":4}],"maxItems":200,"minItems":1},"field":{"enum":["vendors_reviewed","outstanding_actions"],"type":"string","default":"vendors_reviewed"},"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_fz1sp4ib4KWePzu0K_aSp","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 third-party review data by date and category, then fills missing values using a chosen method (zero, mean, or median) across vendors_reviewed and outstanding_actions fields.","exampleAgentPrompt":"I have up to 200 rows of third-party review records with dates, control groups, vendors_reviewed and outstanding_actions — can you run a date-by-category pivot and fill any missing vendors_reviewed values using median imputation?","exampleUseCases":[{"title":"Vendor Review Dashboard Prep","prompt":"I have 150 rows of third-party vendor review records with dates and control groups. Can you pivot them by date and category and fill any missing vendors_reviewed counts using median so I can build a clean dashboard?"},{"title":"Outstanding Actions Gap Analysis","prompt":"Can you take my third-party review data — up to 200 rows with row_id, date, control_group, and outstanding_actions — pivot it by date and category, and fill nulls in the outstanding_actions field using zero fill so I can see where we have gaps?"},{"title":"Monthly Security Review Reshaping","prompt":"I need to reshape my monthly security review records into a date-by-control-group pivot table. The dataset has vendors_reviewed and outstanding_actions columns with some missing values — please fill the gaps using mean imputation."}],"resultDescription":"Returns two analytical reports derived from the supplied rows: (1) a date-by-category pivot table for the selected field, and (2) the same dataset with missing values explicitly filled using the specified method (zero, mean, or median). Both reports are based purely on the provided data with no external lookups.","failureModes":["Rows array exceeds 200 items — request rejected","Missing required fields (row_id, date, control_group) in any row — validation error","Invalid date format (must be YYYY-MM-DD) — schema rejection","Field enum value not recognized — bad request","All values null for the chosen field — fill method may produce degenerate output","Payment of 0.01 USDC not received — 402 payment required"],"whenToPreferThis":"Choose this endpoint when you have up to 200 rows of third-party review records that need both a date×category pivot and missing-value imputation in a single call. Ideal for vendor risk reporting workflows where data has sparse nulls and needs reshaping before visualization or downstream analysis. Prefer this over general pivot tools when your schema exactly matches vendors_reviewed and outstanding_actions fields with control groups.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T18:50:52.953Z","isFirstParty":false,"canonicalSlug":"third-party-reviews-date-category-pivot-explicit-missing-value-fill-ad47ce84"}