## This function is used to generate the input file Directory.txt#def generateInputFile():try:lines=['Springsteen, Bruce, 2587.\n','Hassan, Amir, 6958.\n','Homes, Rebecca, 5263\n','Smith, John, 5252\n','MacDonald, Mirna, 8965!\n','Pichai, Sundar, 9632.\n','Jobs, Steve, 1002\n','Goldsmith, Micheal, 5478.\n','Yassir, Ammar, 8885\n','Nicholas, Jack, 4696\n','Pang, Chee, 9898\n','Lee, Andrew, 7412.\n','Jimenez, Dragos, 6547\n'] outfile = open("Directory.txt",'w')for line in lines:outfile.write(line) except Exception as ex:print(ex)finally:outfile.close()generateInputFile()use this code to get the file and please match the answer with the sample run The Directory.txt file contains names of the employees and their phone numbers in the following order:Last name, First name, Phone.The creator of this file made several mistakes by typing commas and dots inconsistently.Write a Python program to read this file and produce an output file with the name DirectoryNew.txt. This fileshould format the phone directory as follows:PhoneFirst nameNumber 1First name 1Number 2First name 2The file MUST end with:########## End of directory ##########Edit MetadataEdit MetadataContent of the input fileThe output should be as followsPhoneSpringsteen, Bruce, 2587.Hassan, Amir, 6958.Homes, Rebecca, 5263Smith, John, 5252MacDonald, Mirna, 8965!Pichai, Sundar, 9632.Jobs, Steve, 1002Goldsmith, Micheal, 5478.Yassir, Ammar,Nicholas, Jack,Pang, Chee, 9898Lee, Andrew, 7412.Jimenez, Dragos,First name258769585263BruceAmirRebecca525289659632JohnMirnaSundar10025478888546969898Steve8885Micheal4696AmmarJackChee65477412Andrew Edit MetadataEdit MetadataContent of the input fileThe output should be as followsSpringsteen, Bruce, 2587.Hassan, Amir, 6958.Homes, Rebecca, 5263Smith, John, 5252MacDonald, Mirna, 8965!Pichai, undar,Jobs, Steve, 1002Goldsmith, Micheal, 5478.Yassir, Ammar, 8885Nicholas, Jack, 4696Pang, Chee, 9898Lee, Andrew, 7412.Jimenez,PhoneFirst name25876958BruceAmir5263525289659632100254788885469698987412RebeccaJohn9632.MirnaSundarSteveMichealAmmarJackCheeDragos, 6547Andrew6547Dragos##3# End of directory#3%231] :Edit Metadata

Answered: Image /qna-images/answer/8e3343b5-3284-4433-810a-362d701579b1.jpg

Answered: ## This function is used to generate…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

## This function is used to generate the input file Directory.txt

#

def generateInputFile():
try:
lines=['Springsteen, Bruce, 2587.\n','Hassan, Amir, 6958.\n','Homes, Rebecca, 5263\n',
'Smith, John, 5252\n','MacDonald, Mirna, 8965!\n','Pichai, Sundar, 9632.\n',
'Jobs, Steve, 1002\n','Goldsmith, Micheal, 5478.\n','Yassir, Ammar, 8885\n',
'Nicholas, Jack, 4696\n','Pang, Chee, 9898\n','Lee, Andrew, 7412.\n',
'Jimenez, Dragos, 6547\n']
outfile = open("Directory.txt",'w')
for line in lines:
outfile.write(line)
except Exception as ex:
print(ex)
finally:
outfile.close()
generateInputFile()

use this code to get the file and please match the answer with the sample run

The Directory.txt file contains names of the employees and their phone numbers in the following order:
Last name, First name, Phone.
The creator of this file made several mistakes by typing commas and dots inconsistently.
Write a Python program to read this file and produce an output file with the name DirectoryNew.txt. This file
should format the phone directory as follows:
Phone
First name
Number 1
First name 1
Number 2
First name 2
The file MUST end with:
########## End of directory ##########
Edit Metadata
Edit Metadata
Content of the input file
The output should be as follows
Phone
Springsteen, Bruce, 2587.
Hassan, Amir, 6958.
Homes, Rebecca, 5263
Smith, John, 5252
MacDonald, Mirna, 8965!
Pichai, Sundar, 9632.
Jobs, Steve, 1002
Goldsmith, Micheal, 5478.
Yassir, Ammar,
Nicholas, Jack,
Pang, Chee, 9898
Lee, Andrew, 7412.
Jimenez, Dragos,
First name
2587
6958
5263
Bruce
Amir
Rebecca
5252
8965
9632
John
Mirna
Sundar
1002
5478
8885
4696
9898
Steve
8885
Micheal
4696
Ammar
Jack
Chee
6547
7412
Andrew

Edit Metadata
Edit Metadata
Content of the input file
The output should be as follows
Springsteen, Bruce, 2587.
Hassan, Amir, 6958.
Homes, Rebecca, 5263
Smith, John, 5252
MacDonald, Mirna, 8965!
Pichai, undar,
Jobs, Steve, 1002
Goldsmith, Micheal, 5478.
Yassir, Ammar, 8885
Nicholas, Jack, 4696
Pang, Chee, 9898
Lee, Andrew, 7412.
Jimenez,
Phone
First name
2587
6958
Bruce
Amir
5263
5252
8965
9632
1002
5478
8885
4696
9898
7412
Rebecca
John
9632.
Mirna
Sundar
Steve
Micheal
Ammar
Jack
Chee
Dragos, 6547
Andrew
6547
Dragos
##3# End of directory
#3%23
1] :
Edit Metadata

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions