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