{"uid":"cap_BTCfDLV9RIMZ2au2SGJl4","slug":"commercial-proposal-comparisons-grouped-numeric-summary-explicit-db0eee3a","name":"Commercial Proposal Comparisons — Grouped Numeric Summary + Explicit Missing-Value Fill","description":"Commercial proposal comparisons — Grouped numeric summary + Explicit missing-value fill: Grouped numeric summary + 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-099?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_2RpIa9Shdj0WbN2IWQ025","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":"Performs grouped numeric summary statistics and explicit missing-value filling on commercial proposal comparison records (quoted_amount, delivery_days) for up to 200 rows, returning two analytical reports per call.","exampleAgentPrompt":"I have 4 supplier proposals — row-1 from group-a on 2026-10-01 quoting $10 with 1 delivery day, row-2 from group-b on 2026-10-02 quoting $20 with 2 days, row-3 from group-a on 2026-10-03 quoting $15 with 3 days, and row-4 from group-b on 2026-10-04 quoting $30 with 4 days. Can you give me a grouped numeric summary of quoted_amount by company group and fill any missing values using median imputation?","exampleUseCases":[{"title":"Vendor bid amount comparison by group","prompt":"I have 50 supplier bids across three company groups — GroupA, GroupB, and GroupC — with quoted amounts and delivery days. Some quoted_amount values are missing. Can you give me a grouped summary of quoted_amount by company group and fill in the missing values using median imputation?"},{"title":"Delivery time analysis for procurement","prompt":"We received 120 commercial proposals from two supplier groups, Alpha and Beta, dated throughout Q3 2026. Some delivery_days values are null. Please summarize the delivery_days field grouped by supplier group and fill missing values using the mean of each group."},{"title":"Pre-award proposal data cleanup and summary","prompt":"Before we make our vendor selection, I need a grouped numeric summary of quoted amounts across our four supplier groups and want any missing quoted_amount entries filled with zero. Here are the 80 proposal rows — can you run both reports?"}],"resultDescription":"The endpoint returns two analytical reports: (1) a grouped numeric summary (e.g., min, max, mean, count) of the specified field (quoted_amount or delivery_days) broken down by company_group, and (2) the dataset with missing values in the specified field explicitly filled using the chosen method (zero, mean, or median). Both reports are computed locally without any external lookups or predictions.","failureModes":["Empty rows array — rejected if minItems:1 not satisfied","More than 200 rows submitted — exceeds maxItems limit","Invalid date format — must match YYYY-MM-DD pattern","Missing required fields (row_id, company_group, date) — schema validation failure","Invalid enum values for field or method — request rejected","Numeric values outside ±1,000,000,000,000 range — schema validation failure","Payment failure — insufficient USDC balance for $0.01 fee"],"whenToPreferThis":"Choose this endpoint when you have tabular commercial proposal data (up to 200 rows) with quoted_amount and delivery_days fields grouped by company, and you need both grouped summary statistics and missing-value imputation in a single $0.01 call. It is ideal for procurement workflows where you want to compare supplier bids across vendor groups and clean incomplete data before making award decisions. It is not suitable for real-time price lookups, external data enrichment, predictions, or datasets exceeding 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-17T12:42:31.689Z","isFirstParty":false,"canonicalSlug":"commercial-proposal-comparisons-grouped-numeric-summary-explicit-db0eee3a"}