Closed ozterz closed 1 year ago
Don't forget the famous saying:
Some people, when confronted with a problem, think "I know, I'll use regular expressions." Now they have two problems.
Regex is powerful, but can get complex VERY fast. There are coding strategies to combine "procedural" code with simpler regexes so you can keep your sanity. Let's talk.
Proposed solution:
Create general categories of crimes and map the dirty values to the standardized values. Use a regex to fuzzy match data rows to standardized categories.