Question: Assignment & DiscussionWestVirginiaHotDogsnowhasaconsolidatedemployeelistthankstoyoureffortsfromPA 3 . Nowthose employees need to be placed into the list of Current Employees, which is in CSV table format.Your mission in

Assignment & DiscussionWestVirginiaHotDogsnowhasaconsolidatedemployeelistthankstoyoureffortsfromPA3. Nowthose employees need to be placed into the list of Current Employees, which is in CSV table format.Your mission in this homework assignment is to create and manipulate CSV and JSON files. Remember to think what each task is trying to accomplish and break them down one at a time into the steps neededtoachievethetasks. FollowtheTasklistforbestresults.TasksWrite a Python 3 program to accomplish the following:1. Remember from Chapter 9(pp.204-205) that given the pieces of a directory structure, Python can create the actual path name and help ensure the code runs on various machine types. Instead of a full hardcode of the path name, practice letting Python create the Desktop directorypathbeforechangingtotheDesktop. Thatis,ensuretheprogramscurrentworking directory is the Desktop by using the following code:homeFolder='/' #ForMac. IfyouuseWindows,yourhomeFolderis# the Windows root directory.desktopPath = os.path.join (homeFolder, 'Users', yourUserDirectory, 'Desktop') os.chdir (desktopPath)2. Create a new CSV file called CurrentEmpList. Assign the file name to a variable and then use the variable name thereafter.3. Eachrowinthisfileshoulddenote things: theemployeenameandjobtitle. Employees from both work locations are in a consolidated file, WVDogsNewHires.txt.- Read the list from the provided file, one line at a time.- Pull each employees name and job title from the file. Readlines() and Split() methodsmay be useful.- Place each employee entry on a separate CSV file.Note: thefirstlineinthefilecontainsemployeeinformation.Youmayneedtoaddthe following column names: Name, Job Title4. To verify the data wrote correctly, read the data from CurrentEmpList and print it to the screen.Notes- Follow the Sample Output for screen output and file content. These examples give you a good idea of what Ill look for in your CSV file.- Remember to develop your algorithm via pseudocode before you put fingers to the keyboard.- Pay close attention to indentation. Understanding the purpose of the code will help you determinethe correct indentation.WVDogsNewHires.txt:Linda JohnsonBusiness AnalystJames SmithCustomer Service RepresentativeMary BrownFinancial AnalystPatricia GarciaQuality Assurance EngineerMary BrownGraphic DesignerPatricia GarciaWeb DeveloperJames SmithSales RepresentativeJohn MillerGraphic DesignerMary BrownUI/UX DesignerPatricia GarciaPublic Relations ManagerLinda JohnsonFinancial AnalystMichael WilliamsCustomer Service RepresentativeJohn MillerMarketing SpecialistMichael WilliamsBusiness AnalystDavid WilsonSupply Chain CoordinatorMary BrownBusiness AnalystBarbara DavisSupply Chain CoordinatorPatricia GarciaCustomer Service RepresentativeMichael WilliamsGraphic DesignerPatricia GarciaQuality Assurance Engineer
Thank you in advance for your help!!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!