Exercise

Spotting character data problems

Explore the distinct values of the street column. Select each street value and the count of the number of rows with that value. Sort the results by street to see similar values near each other.

Look at the results.

Which of the following is NOT an issue you see with the values of street?

Instructions

50 XP

Possible answers

The street suffix (e.g. Street, Avenue) is sometimes abbreviated

There are sometimes extra spaces at the beginning and end of values

House/street numbers sometimes appear in the column

Capitalization is not consistent across values

All of the above are potential problems