{"uid":"cap_4i2T8MWWDYiGOvk4KlIEN","slug":"company-headcount-observations-record-quality-audit-explicit-missing-aa4180c4","name":"Company Headcount Observations — Record Quality Audit + Explicit Missing-Value Fill","description":"Company headcount observations — Record quality audit + Explicit missing-value fill: Record quality audit + 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-019?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_t49Q0TAHwSzybm4qIwWRu","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":"Audits data quality and fills missing headcount or open_roles values (using zero, mean, or median) for up to 200 company headcount observation records.","exampleAgentPrompt":"Can you audit the data quality and fill any missing headcount values using median imputation for these 5 company headcount records: [{row_id: 'r1', company_group: 'engineering', date: '2024-03-01', headcount: 120, open_roles: null}, {row_id: 'r2', company_group: 'sales', date: '2024-03-01', headcount: null, open_roles: 8}]?","exampleUseCases":[{"title":"Monthly workforce data cleanup","prompt":"I have 150 rows of monthly headcount snapshots across our business units and some headcount values are missing — can you run a quality audit on the records and fill the missing headcount entries using the median of the other rows?"},{"title":"Open roles data gap filling","prompt":"Our recruiting dashboard exports have null values in the open_roles column for several company groups — can you audit these 80 records for quality issues and impute the missing open_roles using the mean?"},{"title":"HR dataset pre-processing validation","prompt":"Before I load this company headcount dataset into our BI tool, can you check all 200 rows for data quality problems and replace any missing headcount values with zero so there are no nulls?"}],"resultDescription":"Returns two independent reports: (1) a record quality audit identifying issues such as nulls, out-of-range values, or formatting problems across the supplied rows; and (2) an explicit missing-value fill report showing which rows had null headcount or open_roles values and what replacement values were applied using the chosen method (zero, mean, or median). No external data sources are consulted — analysis is performed on the supplied data only.","failureModes":["Fewer than 1 row supplied — rejected by minItems constraint","More than 200 rows supplied — rejected by maxItems constraint","Invalid date format (not YYYY-MM-DD) — validation error","row_id missing or empty — required field error","Unknown imputation method or field enum value — schema validation error","All values in target field are null — mean/median imputation may be undefined"],"whenToPreferThis":"Choose this endpoint when you need both a data quality audit AND missing-value imputation for company headcount or open_roles data in a single low-cost call. It is ideal for pre-processing workforce datasets before loading into analytics or BI tools, when you want zero, mean, or median imputation and do not need live workforce data lookups, predictions, or external enrichment.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:32.357Z","isFirstParty":false,"canonicalSlug":"company-headcount-observations-record-quality-audit-explicit-missing-aa4180c4"}