Question

We're working with a csv file, which contains employee information. Each record has a name field, followed by a phone number field, and a role field. The phone number field contains U.S. phone numbers, and needs to be modified to the international format, with "+1-" in front of the phone number. Fill in the regular expression, using groups, to use the transform_record function to do that. 4 1 import re 2 - def transform_record(record): 3 new_record = re.sub(_) return new_record 5 6 print(transform_record("Sabrina Green, 802-867-5309, System Administrator")) 7 # Sabrina Green, +1-802-867-5309,System Administrator print(transform_record("Eli Jones, 684-3481127, IT specialist")) 10 # Eli Jones, +1-684-3481127,IT specialist 11 12 print(transform_record("Melody Daniels,846-687-7436, Programmer")) 13 # Melody Daniels, +1-846-687-7436, Programmer 14 15 print(transform_record("Charlie Rivera, 698-746-3357, Web Developer")) 16 # Charlie Rivera, +1-698-746-3357, Web Developer 8 9 Run Reset

Answer 1

If you have any doubts please comment below. Please give upvote if you like this.

Python Code:

#Import re module

import re

#Method to transform records

def transform_record( record ):

  #Apply sub method it replace the pattern math in a string

  new_record = re.sub("\d{3}-\d{3}-\d{4}|\d{3}-\d{7}","+1-"+record.split(",")[1],record)

  #Return the result string

  return new_record

  

# Here display the results based on problem

print(transform_record("Sabrina Green,802-867-5309,System Administrator"))

print(transform_record("Eli Jones,684-3481127,IT Specialist"))

print(transform_record("Melody Daniels,846-687-7436,Programmer"))

print(transform_record("Charlie Revera,698-746-3357,Web Developer"))

6 7 1 #Import re module 2 import re 3 #Method to transform records 4 def transform_record record ): 5 #Apply sub method it replace the pattern math in a string new_record = re. sub("\d{3}-\d{3}-\d{4}|\d{3}-\d{7}","+1-"+record. split(",")[1], record) #Return the result string 8 return new record 9 10 # Here display the results based on problem 11 print(transform_record("Sabrina Green, 802-867-5309, System Administrator")) 12 print(transform_record("Eli Jones, 684-3481127,IT Specialist")) 13 print(transform_record("Melody Daniels,846-687-7436,Programmer")) 14 print(transform_record("Charlie Revera, 698-746-3357, Web Developer")) Sabrina Green, +1-802-867-5309, System Administrator Eli Jones, +1-684-3481127,IT Specialist Melody Daniels, +1-846-687-7436,Programmer Charlie Revera,+1-698-746-3357, Web Developer