Problem DefinitionYou are provided with a text file (employees.txt) containing a number of text lines. Each line contains a record of oneemployee. Each record has three attributes:Title: string, Prof. (Professor) or Dr. (Doctor).First and Last names: string.Salary: float number.The attributes are separated by the character (','). Figure 1.a, 1.b, and 1.c show a sample of employees.txt files.Dr., Julia Scott,141518Prof.,Joan Stewart,111673Mr.,Ali Al-Shukaili,122311Prof.,Sana Al-Abri,131673Dr.,Fadi Al-Rasdhi,153790Ms., Salwa Al-Youssfi, 111675Dr.,Lillian Brown,67251Dr.,Julia Scott,141518Prof.,Joan StewartDr., Daniel Cooper,153790Dr.,Lillian Brown,unknownDr., Daniel Cooper,153790Dr.,Lillian Brown,67251Dr.,Benjamin Russel1,117642Prof.,Patrick Bailey,72305Dr., Ralph Flores,118457Dr., Douglas Flores,181793Dr.:Benjamin Russell:117642Figure 1.b: A sample of the text file 'employees.txtFigure 1.a: A sample of the text file'employees.txt without errorsFigure 1.c: A sample of the text file'employees.txt' including 3 invalid recordsincluding 2 records with incorrect titlesYou are requested to write a Python program that reads the contents of the text file, saves the titles, the names and thesalaries of employees in three lists and computes the average salary per title as well as the average for all employees.Your program should display the employees per titles, the number of employees of each title, the average salary of eachtitle, the average for all employees, as well as the number of records with invalid title, and the number of invalid record asshown in Figure 2.a, 2.b, and 2.c:Salaries per category:Salaries per category:Salaries per category:NameSalaryNameSalaryNameSalaryProf.Joan Stewart111673.00Prof.=- - ===--Patrick Bailey72305.00Sana Al-Abri131673.00Dr.141518.00153790.00The average salary of 2 Prof. is: 91989. 00Julia ScottThe average salary of 1 Prof. is: 131673.00Daniel CooperDr.Julia ScottDaniel Cooper141518.00Dr.The average salary of 2 Dr. is: 147654.00153790.0067251.00117642.00Fadi Al-Rasdhi153790.00Lillian BrownLillian Brown67251.00Benjamin RussellRalph FloresDouglas FloresThe number of records having incorrect title is 0118457.00The average salary of 2 Dr. is: 110520.50The number of invalid records is 3181793.00The number of records having incorrect title is 2The number of invalid records is 0The average salary of 6 Dr. is: 130075.17The number of records having incorrect title is 0The number of invalid records is 0Figure 2.a: The output of the programrelated to input file of figure 1.aFigure 2.b: The output of the programrelated to input file of figure 1.bFigure 2.c: The output of the programrelated to input file of figure 1.c

Name: Problem DefinitionYou are provided with a text file (employees.txt) c
Uploaded: 2024-03-20T06:51:23.000Z
Channel: Bartleby
Description: Problem DefinitionYou are provided with a text file (employees.txt) containing a number of text lines. Each line contains a record of oneemployee. Each record has three attributes:Title: string, Prof. (Professor) or Dr. (Doctor).First and Last names

Engineering

Computer Science

Problem Definition You are provided with a text file (employees.txt) containing a number of text lines. Each line contains a record of one employee. Each record has three attributes: Title: string, Prof. (Professor) or Dr. (Doctor). First and Last names: string. Salary: float number. The attributes are separated by the character (','). Figure 1.a, 1.b, and 1.c show a sample of employees.txt files.

Problem Definition You are provided with a text file (employees.txt) containing a number of text lines. Each line contains a record of one employee. Each record has three attributes: Title: string, Prof. (Professor) or Dr. (Doctor). First and Last names: string. Salary: float number. The attributes are separated by the character (','). Figure 1.a, 1.b, and 1.c show a sample of employees.txt files.

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

Similar questions

C++ Language Write a program that prints a custom conversion table from Celsius temperatures to Fahrenheit and Newton (Links to an external site.) temperatures. The formula for the conversion from Celsius to Fahrenheit is : F=9/5*C+32 F is the Fahrenheit temperature, and C is the Celsius temperature. The formula for the conversion from Celsius to Newton is C = 100/33*N N is the Newton Temperature and C is the Celsius temperature Your program should prompt the user for a lower value and upper value for a range of temperatures in Celsius. It should then prompt the user for the amount they want to increment by. Then use a loop to output to a file named conversion_table.txt a table of the Celsius temperatures and their Fahrenheit and Newton equivalents within the range of values using the increment given by the user. Make sure to format your output to 2 decimal places. INPUT VALIDATION: Ensure the second number is greater than the first number, and make sure the increment is greater…
Computer Science C# Programming Object Orientation Please use Arrays or ArrayLists where appropriate Implement a menu driven program that has some operations for a food truck. A food truck has multiple food items as well as a menu which contains a selection of the food items which will be sold for that day. A maximum of 10 food items can appear on the menu for any day. For each food item keep a code, description, category, price and quantity in stock (code, description and category are not usually changed). Create a comma delimited text file called "items.txt" for 15 or more food items, indicating the item's description, category, price and quantity in stock. Read all the food items from the text file “Items.txt” Display all the food items available for this food truck. Continuously prompt the user for a food item’s code to be placed on the menu until the menu is full or the user enters -1. Note that only food items which have a positive quantity in stock may be added to…
Part C - advanced file reading You will need a Python repl to solve part C. Define a Python function named expensive_counties that has two parameters. The first parameter is a string representing the name of a text file. Each line of this text file will be a state code. The second parameter is a string representing the name of a CSV file. The CSV file will be portion of the US government's dataset documenting median rents in each US county. Each row in the CSV file has the format: Area Name, Efficiency, 1-Bedroom, 2-Bedroom, 3-Bedroom, 4-Bedroom, State Code Your function will need to use the accumulator pattern to return a new list. You will need to add to this list the Area Name from every row that meets 2 criteria: (1) The state code (the column at index 6) was a line in the text file named in the first parameter; AND (2) The median rent on a 1-bedroom apartment (the column at index 2) is over 1000. Important Hints: * You will really, really want to use the built-in csv library…
A is a data type that you may construct that includes one or more fields. structure b. collection c. volume d. list a. structure b. collection c. volume d. list a. structure b.
Cargo Container Report. You will be producing a program which will allow the user to generate the container report on the following page in Container Number order or Ship Name order. The program will also the user to lookup the data for any given Container by number. The % cargo weight is the percentage of the cargo of the gross weight (cargo weight/gross weight), % total is the percentage of the cargo for that container of the total amount of cargo unloaded (cargo weight for the container / total cargo unloaded. Hint: you are expected to use methods for your calculations. The accompanying file has the data for the containers unloaded today. The data includes container number int ship name. String tare weight of the container (empty weight) int the gross weight (container plus the cargo). Int You will need to computer the cargo weight as the gross weight minus the tare weight. If you have issues reading the data with the String, you may remove the String. However, you will lose points.…
7. World Series Winners In this chapter's source code folder (available on the Computer Science Portal at www. pearsonhighered.com/gaddis), you will find a text file named WorldSeriesWinners. txt. This file contains a chronological list of the World Series' winning teams from 1903 through 2009. The first line in the file is the name of the team that won in 1903, and the last line is the name of the team that won in 2009. (Note the World Series was not played in 1904 or 1994. There are entries in the file indicating this.) Write a program that reads this file and creates a dictionary in which the keys are the names of the teams, and each key's associated value is the number of times the team has won the World Series. The program should also create a dictionary in which the keys are the years, and each key's associated value is the name of the team that won that year. The program should prompt the user for a year in the range of 1903 through 2009. It should then display the name of the…
Code in Perl Create an array which holds a list of Video Games, consisting of title, the year it was released (guess if you don’t know) , platform (NES, XBOX One, etc) and publisher (in that order). Add at least ten albums to the list. Then, use the split function and a for or foreach loop to display the publisher followed by the title and platform for each list element.
IN C LANGUAGE Create a structure called employee that holds information like employee code, name, date of joining, department, designation. Write a program to declare 10 employees using array and enter some data into it. Then ask the user to enter the current date. Display and write in a file named “ emp.txt” the records of those employees who are working for 3 or more than 3 years according to the given current date.
Problem description Write a program that will read in a file of student academic credit data and create a list of students on academic warning. The list of students on warning will be written to a file. Each line of the input file will contain the student name (a single String with no spaces), the number of semester hours earned (an integer), the total quality points earned (a double). The program should compute the GPA (grade point or quality point average) for each student (the total quality points divided by the number of semester hours) then write the student information to the output file if that student should be put on academic warning. A student will be on warning if he/she has a GPA less than 1.5 for students with fewer than 30 semester hours credit, 1.75 for students with fewer than 60 semester hours credit, and 2.0 for all other students. Do the following: 1. Create a text data file "students.dat". The following shows part of a typical data file: Smith 27 83.7 Jones 21 28.35…
Problem description Write a program that will read in a file of student academic credit data and create a list of students on academic warning. The list of students on warning will be written to a file. Each line of the input file will contain the student name (a single String with no spaces), the number of semester hours earned (an integer), the total quality points earned (a double). The program should compute the GPA (grade point or quality point average) for each student (the total quality points divided by the number of semester hours) then write the student information to the output file if that student should be put on academic warning. A student will be on warning if he/she has a GPA less than 1.5 for students with fewer than 30 semester hours credit, 1.75 for students with fewer than 60 semester hours credit, and 2.0 for all other students. Do the following:
Python Programming Assignment: Create a dictionary that takes a basketball team's information (that includes team's name and points) as parameter, creates a teams_dict and returns it. Also, create a parameter for write_file parameter that opens current results text file in write mode and writes the dictionary information to file as per format and closes the file.
Assignment 5C: Level Map Creator. There are a variety of ways that game developers store their level layouts. One simple method is to associate level elements with certain symbols, and then storing them in a 2D grid inside a text file. We will use our knowledge of 2D arrays to create a very simple Level Map Creator tool. The program should prompt the user to enter a width and height for the level. Then it should initialize a 2D array and fill every element with the *" symbol. Afterwards, the user should be given the following options via a menu: 1. Clear Level 2. Add Platform Prompt the user to enter a starting point and length for the Re-initialize the 2D array and fill every element with the "** symbol. horizontal platform. Replace those elements in the 2D array with the "=" symbol. If the length is longer than the number of columns |(or out of bounds), notify the user that this is not possible. Prompt the user to enter a column and row index. Replace that element in the 2D array…