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

Exercise

Detecting inconsistent text data

You've recently received some news that the customer support team wants to ask the SFO survey participants some follow-up questions. However, the auto-dialer that the call center uses isn't able to parse all of the phone numbers since they're all in different formats. After some investigation, you found that some phone numbers are written with hyphens (-) and some are written with parentheses ((,)). In this exercise, you'll figure out which phone numbers have these issues so that you know which ones need fixing.

dplyr and stringr are loaded, and sfo_survey is available.

Instructions 1/2

undefined XP
  • 1
    • Filter for rows with phone numbers that contain "-"s.
  • 2
    • Filter for rows with phone numbers that contain "(", or ")". Remember to use fixed() when searching for parentheses.