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
___