{"uid":"cap_u2LcKnBf8Ou6Cq9jSIOBm","slug":"company-headcount-observations-exact-row-deduplication-explicit-fdaf93fd","name":"Company Headcount Observations — Exact Row Deduplication + Explicit Missing-Value Fill","description":"Company headcount observations — Exact row deduplication + Explicit missing-value fill: Exact row deduplication + Explicit missing-value fill for supplied company headcount observations records (headcount, open_roles). 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-12-054?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","headcount","open_roles"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"headcount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"open_roles":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"company_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","headcount":10,"open_roles":1,"company_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","headcount":20,"open_roles":2,"company_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","headcount":15,"open_roles":3,"company_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","headcount":30,"open_roles":4,"company_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["headcount","open_roles"],"type":"string","default":"headcount"},"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_PJlixLDO4zecziLC7E4Xl","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 rows and fills missing headcount or open_roles values in company headcount observation records using zero, mean, or median imputation.","exampleAgentPrompt":"I have a list of up to 50 company headcount observations with some duplicate rows and missing headcount values — can you deduplicate them exactly and fill in the missing headcount numbers using the median?","exampleUseCases":[{"title":"HR dataset deduplication before reporting","prompt":"I've got a batch of workforce records for group-a and group-b companies across several dates, and there are some exact duplicate rows I need removed — can you deduplicate these headcount observations and fill any null headcount values using the median?"},{"title":"Filling missing open_roles with zero","prompt":"My company headcount dataset has some missing open_roles entries across multiple date snapshots — can you clean it up by keeping only unique rows and filling the missing open_roles values with zero?"},{"title":"Preparing HR data with mean imputation","prompt":"Before I run my workforce trend analysis, I need to clean up these 120 company headcount records by removing exact duplicates and filling in any missing headcount figures using the mean — can you do that for me?"}],"resultDescription":"Two analytical reports covering: (1) exact duplicate row removal from the supplied headcount observations, and (2) explicit imputation of missing values in the specified field (headcount or open_roles) using the chosen method (zero, mean, or median). Results are based solely on the supplied data with no external lookups.","failureModes":["Input exceeds 200 rows — request rejected","Invalid date format (non-YYYY-MM-DD) causes row rejection","Missing required fields (row_id, company_group, date) causes validation error","Invalid method enum value causes error","Invalid field enum value causes error","Empty rows array rejected (minItems: 1)"],"whenToPreferThis":"Choose this endpoint when you have up to 200 company headcount or open_roles observation records that need exact duplicate removal and/or missing-value imputation in a single low-cost call. Ideal for lightweight data cleaning pipelines prior to analytics or reporting, where no external data lookup or prediction is needed and results must be reproducible from the supplied data alone.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:32.083Z","isFirstParty":false,"canonicalSlug":"company-headcount-observations-exact-row-deduplication-explicit-fdaf93fd"}