Trimming

Some of the street values in evanston311 include house numbers with # or / in them. In addition, some street values end in a ..

Remove the house numbers, extra punctuation, and any spaces from the beginning and end of the street values as a first attempt at cleaning up the values.

Bu egzersiz

Exploratory Data Analysis in SQL

kursunun bir parçasıdır

Kursu Görüntüle

Egzersiz talimatları

Trim digits 0-9, #, /, ., and spaces from the beginning and end of street.
Select distinct original street value and the corrected street value.
Order the results by the original street value.

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

SELECT distinct street,
       -- Trim off unwanted characters from street
       trim(___, ___) AS cleaned_street
  FROM evanston311
 ORDER BY ___;

Kodu Düzenle ve Çalıştır