1. Learn
    2. /
  2. Courses
    3. /
  3. Cleaning Data in R

Exercise

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.

Instructions 1/3

undefined XP
    1
    2
    3
  • Remove opening and closing parentheses from the phone column. Store this as a variable called phone_no_parens. Remember to use fixed()!