A company stores payment information for their employee working on a project and paid on a project basis, in a text file whose name is entered through keyboard (see a sample input file below). The first line of the file indicates the number of employees and each subsequent line corresponds to information related to an employee payment (employee name, number of hours vorked and his/her hourly wage). Write a python program that reads such a file and displays he employees' names, their hours worked, and their salaries. Finally, it displays the total payment. Your program should consider the following erroneous cases: • The file does not open/exist • The format of the data in the file is incorrect (e.g. hours = "I-" or salary = "unkown") in which case a RuntimeError exception should be raised and the processing should %3D continue

A company stores payment information for their employee working on a project and paid on a project basis, in a text file whose name is entered through keyboard (see a sample input file below). The first line of the file indicates the number of employees and each subsequent line corresponds to information related to an employee payment (employee name, number of hours vorked and his/her hourly wage). Write a python program that reads such a file and displays he employees' names, their hours worked, and their salaries. Finally, it displays the total payment. Your program should consider the following erroneous cases: • The file does not open/exist • The format of the data in the file is incorrect (e.g. hours = "I-" or salary = "unkown") in which case a RuntimeError exception should be raised and the processing should %3D continue

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

Design a python program that reads a file named "scores.txt containing lines of test scores separated by commas. Read each line in the file and put each line of scores in a list. Sort the scores in each list in decreasing order and display each list. The contents of "scores.txt" are as follows: 85.6, 92.2, 57.9, 45.7 39.4, 55,6, 99.9, 46.3 98.8, 90.4, 79.3, 66.7
Please do this in PYTHON PROGRAMMING Write an address book program that stores your contacts' names and their email addresses. The names and email addresses are originally stored in a file called phonebook.in, in the format:Harry P..d@hogwarts.eduHermione G..h@hogwarts.eduRon W..b@hogwarts.eduDraco M..s@hogwarts.eduSeverus S..e@hogwarts.eduAlbus D..x@hogwarts.eduYour program should read from the file, storing the names and corresponding email addresses in a dictionary as key-value pairs. Then, the program should display a menu that lets the user enter the numbers 1 through 5, each corresponding to a different menu item:1) look up an email address2) add a new name and email address3) change an email address4) delete a name and email address5) save address book and exitWhen the user enters 1, the program should prompt them for a name, and then print the corresponding email address. If there is no dictionary entry under that name, the program should print, "Sorry, no contact exists…
Write a complete python program with a main function that reads from a file called numbers.txt and outputs to a file called answers.txt Numbers.txt has one or more lines where each line contains two numbers Your program should read through numbers.txt and with each line. Multiplies the first number by the second and outputs the results to answers.txt If inputs.txt contained 5 4 3 4 6 4 After your program runs answers.txt should contain 20 12 24
Write a JAVA program that reads the student information from a tab separated values (tsv) file. The program then creates a text file that records the course grades of the students. Each row of the tsv file contains the Last Name, First Name, Midterm1 score, Midterm2 score, and the Final score of a student. A sample of the student information is provided in StudentInfo.tsv. Assume the number of students is at least 1 and at most 20. Assume also the last names and first names do not contain whitespaces. The program performs the following tasks: Read the file name of the tsv file from the user. Open the tsv file and read the student information. Compute the average exam score of each student. Assign a letter grade to each student based on the average exam score in the following scale: A: 90 =< x B: 80 =< x < 90 C: 70 =< x < 80 D: 60 =< x < 70 F: x < 60 Compute the average of each exam. Output the last names, first names, exam scores, and letter grades of the…
Write a java program that will read a text file that displays a list of the largest US Cities and their 2019 population. The user will be prompted to enter a file name and your program will print a title (“City Population”) and the list of cities in the file. Use either Scanner or JOptionPane to query the user for the filename. (The file provided is named “USCities.txt”.) The output should appear as follows: Enter the filename: USCities.txt City Population New York City 8,336,817 Los Angeles 3,979,576 Chicago 2,693,976 Houston 2,320,268 Phoenix 1,680,992 Philadelphia 1,584,064 San Antonio 1,547,253 San Diego 1,423,851 Dallas 1,353,573 San Jose 1,021,795
Write a Python program in a .py file that includes the following: Program reads, formats and prints a restaurant menu from menu.txt (see at the bottom).Customer orders menu items by name or an assigned item number until a key word is entered such as "I'm Done" or "Exit".Customer order and net total is printed as output to a new text file. -----------------menu.txt-----------------Ham and Egg Sandwich $15.75Bacon and Cheese Plate $9.50Tuna Salad $12.30Beef Soup $9.00Spicy Beef Barbeque $20.00Pork Barbeque $18.00Oven Chicken Barbeque $15.00Pulled Beef Barbeque Burger $25.00House Salad $5.00Pellegrino $5.40White Wine $7.50Red Wine $11.00
You are required to write a C++ program that reads several hundreds of movie ratings from an input file, and output a list of Number of times rated (#Rated), sum of ratings (Total Ratings) and average ratings of the movies.The application program reads in several hundreds of movie ratings from an input file “Rating_list.txt”. Each line in the input file represents one review, indicating the title of the movie and a rating (between 0 and 5) separated by a space. Sample lines from the input file is shown below. Titanic 5 The_Full_Monty 3 Liar_Liar 4 Apollo_13 3 Liar_Liar 3 Titanic 4 The_Silence_of_the_Lambs 2 Star_Wars 1 Men_in_Black 4 Dead_Man_Walking 2 Toy_Story…
You are required to write a C++ program that reads several hundreds of movie ratings from an input file, and output a list of Number of times rated (#Rated), sum of ratings (Total Ratings) and average ratings of the movies. The application program reads in several hundreds of movie ratings from an input file “Rating_list.txt”. Each line in the input file represents one review, indicating the title of the movie and a rating (between 0 and 5) separated by a space. Sample lines from the input file is shown below. Titanic 5 The_Full_Monty 3 Liar_Liar 4 Apollo_13 3 Liar_Liar 3 Titanic 4 The output must be formatted as shown below (see the columns and decimal places). In addition, the output must include the total number of unique movie titles and the total number of ratings found in the input file as shown in the sample output. Movie Mname #Rated Total Ratings Average…
You are required to write a C++ program that reads several hundreds of movie ratings from an input file, and output a list of Number of times rated (#Rated), sum of ratings (Total Ratings) and average ratings of the movies. The application program reads in several hundreds of movie ratings from an input file "Rating_list.txt". Each line in the input file represents one review, indicating the title of the movie and a rating (between 0 and 5) separated by a space. Sample lines from the input file is shown below. Rating_list - Notepad Eile Edit Format View Help Titanic 5 The_Full_Monty 3 Liar_Liar Apollo 13 3 Liar Liar 3 Titanic 4 4 Windo in 1, C 100% The output must be formatted as shown below (see the columns and decimal places). In addition, the output must include the total number of unique movie titles and the total number of ratings found in the input file as shown in the sample output. CAWindows\system32\cmd.exe Movie Mname #Rated Total Ratings Average Rating Liar_Liar 87…
Write a C Program which reads the contents of the attached sequential file - customers.txt Print the surname of people who agreed to share their data. This is denoted by the final field in the file (1 for agree, 0 for not agreed). Print the average age of these people (age is the 4th column in the data) Print the average age for people who live in Dublin and have agreed to share their data. This is denoted by the first field in the file. customers.txt New York Dunne 865463389 21 1New York Milford 865438990 22 0New York Mowlds 876765443 24 1New York Wang 873456789 22 1New York Smith 875432234 25 1New York Henry 876654429 22 0New York Gupta 896765443 24 1Los Angeles Monahan 865432245 22 1Los Angeles Brunsdon 865678894 22 1Alabama Tyson 865434566 22 0Alabama Browne 865564766 20 1New York Dunne 890065443 27 1New…
Write a C++ program using classes that readslines from a file until the end of file. The program should prompt the user for the file name to read from. The program should open the file for reading, and if the filecannot be opened, print the message “File couldn’t be opened”, followed by a space and the filename, and exit. The program should keep track of the number of lines, the number of non-blank lines, the number of words, and the number of integers read from the file.
Write a program that reads student information from a text file, then creates a text file that records the course grades of the students and a final grade. Each row of the .txt file contains the Last Name, First Name, Midterm1 score, Midterm2 score, and the Final score of a student, each separated by a space. A sample of the student information is provided in StudentInfo.txt below. Assume the number of students is at least 1 and at most 20. The program performs the following tasks: • Read the file name of the .txt file from the user. • Open the .txt file and read the student information using readline() or readlines(). • Compute the average exam score of each student. • Assign a letter grade to each student based on the average exam score in the following scale: ◦ A: 90 =< x ◦ B: 80 =< x < 90 ◦ C: 70 =< x < 80 ◦ D: 60 =< x < 70 ◦ F: x < 60 • Output the first names, last names, exam scores, and letter…