Repeatability
High
The transformation rules are fully specified and structurally identical across all 950 rows — strip whitespace, normalize enums, parse currency, standardize dates, fill nulls. This is a repeatable pipeline, not a judgment call.
Ambiguity Tolerance
High
Success criteria are crisp: no leading/trailing spaces, a single canonical project-type value per category, numeric USD amounts, ISO-formatted dates, and 'Uncategorized' for missing industries. A script can verify all of these programmatically.
Data & Tool Availability
High
The user provides the CSV directly; no external APIs, credentials, or live data access are needed. A code-capable agent can process the file entirely in-session with pandas or similar.
Error Cost
Low
The original CSV is preserved and the output is a new file, so nothing is overwritten or irreversible. Any errors in normalization are visible on inspection and trivially correctable before the data is used for analysis.
Human Judgment Required
Low
The only judgment call is mapping variant project-type strings ('web' / 'Web copy' / 'WEB COPY') to a canonical label — but the user's own data makes the intent obvious, and a short deduplication pass or confirmation step handles it cleanly.