Replacing and removing
In the last exercise, you saw that the phone
column of sfo_survey
is plagued with unnecessary parentheses and hyphens. The customer support team has requested that all phone numbers be in the format "123 456 7890"
. In this exercise, you'll use your new stringr
skills to fulfill this request.
dplyr
and stringr
are loaded and sfo_survey
is available.
This exercise is part of the course
Cleaning Data in R
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Remove parentheses from phone column
phone_no_parens <- sfo_survey$phone %>%
# Remove "("s
___(fixed(___)) %>%
# Remove ")"s
___