{"uid":"cap_eyzxy46Bt1cL5C1BzyZ32","slug":"proposal-preparation-exact-row-deduplication-and-numeric-distribution-4a4f0637","name":"Proposal Preparation Exact Row Deduplication and Numeric Distribution","description":"Proposal preparation — Exact row deduplication + Numeric distribution: Exact row deduplication + Numeric distribution for supplied proposal preparation records (completed_sections, planned_sections). 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-writing-08-039?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","document_group","date","completed_sections","planned_sections"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"document_group":{"type":"string","default":"","maxLength":80},"planned_sections":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"completed_sections":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","document_group":"group-a","planned_sections":1,"completed_sections":10},{"date":"2026-10-02","row_id":"row-2","document_group":"group-b","planned_sections":2,"completed_sections":20},{"date":"2026-10-03","row_id":"row-3","document_group":"group-a","planned_sections":3,"completed_sections":15},{"date":"2026-10-04","row_id":"row-4","document_group":"group-b","planned_sections":4,"completed_sections":30}],"maxItems":200,"minItems":1},"field":{"enum":["completed_sections","planned_sections"],"type":"string","default":"completed_sections"}}},"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_vXFTPjYasWTbxmLNwjYOw","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 rows and computes numeric distribution statistics for proposal preparation records with completed_sections and planned_sections fields.","exampleAgentPrompt":"I have a dataset of proposal preparation records with completed_sections and planned_sections counts — can you deduplicate the rows exactly and show me the numeric distribution of completed_sections across up to 200 rows?","exampleUseCases":[{"title":"Proposal pipeline data cleanup","prompt":"I have 150 proposal tracking rows with document_group, date, completed_sections, and planned_sections — some rows are exact duplicates. Can you deduplicate them and also show me the numeric distribution of planned_sections so I can understand the spread?"},{"title":"Grant proposal section completion analysis","prompt":"Here are our grant proposal records for Q4 — each row has a row_id, document_group, date, and completed_sections count. Please remove any exact duplicate rows and give me a numeric distribution report for completed_sections."},{"title":"Proposal audit before submission","prompt":"Before we submit our proposal batch, I need to check for exact duplicate rows and understand how completed_sections values are distributed across all 80 records. Can you run both the deduplication and numeric distribution reports on this data?"}],"resultDescription":"Returns two reports: (1) an exact row deduplication report identifying and removing duplicate rows from the supplied proposal preparation dataset, and (2) a numeric distribution report summarizing the statistical spread (e.g. min, max, mean, histogram buckets) of the selected field (completed_sections or planned_sections) across up to 200 rows. No external lookups or predictions are made; all analysis is performed locally on the supplied data.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, date, document_group, completed_sections, planned_sections) — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Numeric values outside allowed range (-1e12 to 1e12) — rejection","Empty rows array — minimum 1 item required","Invalid field enum value — must be completed_sections or planned_sections"],"whenToPreferThis":"Choose this endpoint when you have proposal preparation records (with completed_sections and planned_sections) and need both exact duplicate removal and a numeric distribution summary in a single low-cost call. It is ideal for small-to-medium datasets up to 200 rows where you want offline, deterministic analytics without any external API calls, predictions, or professional assessments. Prefer alternatives if you need fuzzy deduplication, live data enrichment, or analysis of fields beyond the two supported numeric columns.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T12:33:57.190Z","isFirstParty":false,"canonicalSlug":"proposal-preparation-exact-row-deduplication-and-numeric-distribution-4a4f0637"}