{"uid":"cap_p30OJR0tvWmLIS9iNDMVG","slug":"company-headcount-observations-record-quality-audit-exact-row-351bf0fb","name":"Company Headcount Observations — Record Quality Audit, Exact Row Deduplication & Trailing Mean Series","description":"Company headcount observations — Record quality audit + Exact row deduplication + Trailing mean series: Record quality audit + Exact row deduplication + Trailing mean series for supplied company headcount observations records (headcount, open_roles). Up to 200 rows; 3 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 3 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-company-12-216?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"},"window":{"type":"integer","default":2,"maximum":200,"minimum":2}}},"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_NJIaKNg31HKDi1d-Jmc55","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, deduplicates exact rows, and computes trailing mean series for up to 200 company headcount observation records across headcount and open_roles fields.","exampleAgentPrompt":"Can you audit the data quality, remove exact duplicate rows, and compute a trailing mean with a window of 3 for the headcount field across these 50 company headcount observations grouped by company group and date?","exampleUseCases":[{"title":"HR data cleanup before quarterly report","prompt":"I have 120 rows of headcount observations for our business units — can you run a quality audit, strip any exact duplicate rows, and give me a trailing mean series with a window of 4 for headcount so we can verify the data before we finalize the quarterly workforce report?"},{"title":"Open roles trend analysis by company group","prompt":"We track open roles across several company groups weekly — can you audit the record quality of these 80 rows, deduplicate them, and generate a trailing mean series with window 5 on the open_roles field so I can spot hiring trends?"},{"title":"Validating imported headcount data from external system","prompt":"I just imported 150 headcount records from our HR system and I'm worried about data integrity issues — please run a record quality audit, flag and remove exact duplicate rows, and compute a 2-period trailing mean on headcount so I can see if the numbers make sense."}],"resultDescription":"Returns three independent analytical reports: (1) a record quality audit highlighting issues such as nulls, invalid values, and malformed dates across the headcount and open_roles fields; (2) an exact row deduplication report identifying and removing fully identical rows; and (3) a trailing mean time series computed over the specified field (headcount or open_roles) using the given window size, grouped by company_group and ordered by date.","failureModes":["Rows array exceeds 200 items — request rejected","Missing required fields (row_id, company_group, date, headcount, or open_roles) cause validation errors","Invalid date format (not YYYY-MM-DD) results in pattern mismatch error","Window size outside 2–200 range causes schema validation failure","Empty rows array (minItems: 1 not met) returns error","Numeric values outside allowed range cause validation failure"],"whenToPreferThis":"Choose this endpoint when you need three bundled analytical operations — quality audit, deduplication, and trailing mean series — on company headcount data (up to 200 rows) in a single low-cost call. It is ideal for pre-processing HR or workforce datasets before reporting or downstream analysis, especially when you want to validate data integrity and compute rolling averages without building custom pipelines. It does not perform live lookups, predictions, or external data enrichment.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:27.141Z","isFirstParty":false,"canonicalSlug":"company-headcount-observations-record-quality-audit-exact-row-351bf0fb"}