{"uid":"cap_zl6prO43l5GaNQAdfdoOX","slug":"commercial-proposal-comparisons-date-category-pivot-missing-value-fill-4ef1fd0a","name":"Commercial Proposal Comparisons — Date×Category Pivot + Missing-Value Fill","description":"Commercial proposal comparisons — Date by category pivot + Explicit missing-value fill: Date by category pivot + Explicit missing-value fill for supplied commercial proposal comparisons records (quoted_amount, delivery_days). 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-company-24-189?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","quoted_amount","delivery_days"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"company_group":{"type":"string","default":"","maxLength":80},"delivery_days":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"quoted_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","delivery_days":1,"quoted_amount":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","delivery_days":2,"quoted_amount":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","delivery_days":3,"quoted_amount":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","delivery_days":4,"quoted_amount":30}],"maxItems":200,"minItems":1},"field":{"enum":["quoted_amount","delivery_days"],"type":"string","default":"quoted_amount"},"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_Yrlypu2A1vY1_LFea30SE","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 commercial proposal data by date and company category, then fills missing values, returning two analytical reports for up to 200 rows of quoted_amount or delivery_days data.","exampleAgentPrompt":"I have 150 rows of commercial proposal data with company groups and dates — can you pivot it so rows are dates and columns are company categories, filling any missing quoted_amount values using the median, and give me both the pivot table and the filled dataset?","exampleUseCases":[{"title":"Supplier bid comparison over time","prompt":"I've got proposal comparison records from three vendor groups across the last quarter — can you pivot the quoted_amount data by date and company group, fill any gaps with the median, and give me the two reports?"},{"title":"Delivery time analysis by vendor category","prompt":"Can you take my 80 rows of proposal data and create a date-by-category pivot for delivery_days, filling missing values with zero so I can see which supplier groups are slowest on which dates?"},{"title":"Procurement data cleanup before reporting","prompt":"Before I send this proposal comparison dataset to the team, can you pivot it by date and company group, use mean to fill in any missing quoted_amount entries, and give me the cleaned analytical reports?"}],"resultDescription":"Two analytical reports: (1) a date-by-category pivot table of the selected field (quoted_amount or delivery_days) with rows as dates and columns as company groups, and (2) the same dataset with missing values explicitly filled using the chosen method (zero, mean, or median). Covers up to 200 input rows.","failureModes":["Input exceeds 200 rows — request will be rejected","Missing required fields (row_id, company_group, date, quoted_amount, delivery_days) — validation error","Date strings not in YYYY-MM-DD format — pattern validation failure","Numeric values outside allowed range (±1,000,000,000,000) — schema rejection","Empty rows array — minItems violation"],"whenToPreferThis":"Choose this endpoint when you need to reshape commercial proposal or procurement comparison data into a date-by-category matrix and simultaneously handle missing values in a single paid call. It is purpose-built for quoted_amount and delivery_days fields and delivers two reports for $0.01 USDC with no external data lookup — ideal for offline batch analytical workflows on supplier bid datasets up to 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-17T12:41:44.395Z","isFirstParty":false,"canonicalSlug":"commercial-proposal-comparisons-date-category-pivot-missing-value-fill-4ef1fd0a"}