Cleaning Messy Data in SQL: The Patterns You Will Use Every Week
Nobody warns you about this part. You learn joins, you learn aggregation, you land a job, and then you discover that the field called district contains “Pune”, “pune”, ” Pune “, “PUNE”, “Pune ” and “Punr”. And a number. And, for reasons nobody can explain, the word “test”. Cleaning data is the majority of analytics … Read more