Practice / strings dates nulls
The Daily Grind imported phone numbers from three different systems, each formatted its own way. Normalise them to bare digits.
contacts
Your task: return id and digits — the phone with every non-digit character removed.
Assign your answer DataFrame to result. Row order doesn't matter.
contactsinput DataFrame| column | type |
|---|---|
| id | long |
| phone | string |
| id | phone |
|---|---|
| 1 | (555) 123-4567 |
| 2 | 555.987.6543 |
iddigits· 2 rowsF.regexp_replace("phone", "[^0-9]", "") deletes every character that is NOT a
digit. Alias it digits and select it alongside id.
This problem builds on Strings, Dates & Nulls (~8 min). Pop it open in a new tab if you want a quick recap.