Yep, been there! Once had a survey where "No" was "N", "Nope", and "Negative". Like, come on, people.
For regex haters, Trifacta Wrangler is a great no-code tool for fixing bad data terms.
Also, *always* assume your data is dirty. It usually is.
For regex haters, Trifacta Wrangler is a great no-code tool for fixing bad data terms.
Also, *always* assume your data is dirty. It usually is.
