Bài tập

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?

Hướng dẫn

50 XP

Các phương án trả lời

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

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Bài tập

Hướng dẫn

Các phương án trả lời

Bài tập