{"uid":"cap_6wDMfoh6guwYHCnUPp5wr","slug":"partnership-pipeline-string-normalisation-iqr-outlier-flags-bd6dc2b8","name":"Partnership Pipeline — String Normalisation + IQR Outlier Flags","description":"Partnership pipeline — String normalisation + IQR outlier flags: String normalisation + IQR outlier flags for supplied partnership pipeline records (qualified_partners, active_partners). 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-09-032?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","qualified_partners","active_partners"],"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},"active_partners":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"qualified_partners":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","active_partners":1,"qualified_partners":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","active_partners":2,"qualified_partners":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","active_partners":3,"qualified_partners":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","active_partners":4,"qualified_partners":30}],"maxItems":200,"minItems":1},"field":{"enum":["qualified_partners","active_partners"],"type":"string","default":"qualified_partners"}}},"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_NHVyeb06JOLKPl7RoRSjK","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":"Applies string normalisation and IQR-based outlier flagging to partnership pipeline records (qualified_partners, active_partners) for up to 200 rows, producing two independent analytical reports.","exampleAgentPrompt":"Can you run string normalisation and IQR outlier flagging on my partnership pipeline data? I have up to 50 rows with company_group, date, qualified_partners, and active_partners — flag the qualified_partners field for outliers and normalise the strings.","exampleUseCases":[{"title":"Quarterly partner pipeline audit","prompt":"I have 120 rows of partnership pipeline records from Q3, each with a company_group, date, qualified_partners count, and active_partners count. Can you normalise the string fields and flag any IQR outliers in the qualified_partners column so I know which rows look statistically unusual?"},{"title":"Active partner anomaly detection","prompt":"Run IQR outlier detection on the active_partners field across these 80 partnership records grouped by company — I want to see which rows are flagged as outliers and get the string normalisation report too."},{"title":"Pre-reporting data clean for partner metrics","prompt":"Before I send my partner pipeline report to leadership, can you normalise the company_group strings and flag any outlier values in qualified_partners across my 60 rows of data so I can review them first?"}],"resultDescription":"Two independent analytical reports per call: (1) a string normalisation report cleaning and standardising string fields across the submitted rows, and (2) an IQR outlier flagging report identifying statistically anomalous rows in the selected numeric field (qualified_partners or active_partners). Results are based entirely on the supplied data with no external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, company_group, date, qualified_partners, active_partners) — validation error","Date field does not match YYYY-MM-DD pattern — validation error","Numeric fields outside allowed range (-1e12 to 1e12) — validation error","Insufficient data variance for IQR computation (e.g. all-null numeric column) — may return degenerate outlier results","Invalid field enum value (must be 'qualified_partners' or 'active_partners') — rejection"],"whenToPreferThis":"Choose this endpoint when you need both string normalisation and IQR outlier detection on partnership pipeline data (qualified_partners and active_partners) in a single low-cost call. Ideal for pre-reporting data quality checks, batch cleansing of up to 200 partner records, and detecting statistically anomalous partner counts without needing external data sources or predictive models. Prefer alternatives if you need deduplication, date pivoting, or record quality audits, which are handled by sibling endpoints on the same platform.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:39:55.767Z","isFirstParty":false,"canonicalSlug":"partnership-pipeline-string-normalisation-iqr-outlier-flags-bd6dc2b8"}