A hotel keeps records of its sales in a text file (called "hotel.txt"; provided in the MOODLE).Each line contains the following information separated by semicolons (“:"): The client's name,the service sold (such as Dining, conference...), and the amount of the sale. Figure 2 shows afew lines of input file. Write a program that reads such a file and displays the total and averageamount for each service category. Knowing that there are four services (Dining, Lodging,Conference, and Parking). Display an error using the proper exception if:The file does not open/existThe format of the data in the file is incorrect (e.g. sale amount = "230;9" or "12ab")Dividing by zero (when computing average)Make sure you close any open files even if an error occurs.Benjamin Bayer:Dining:26.5English Joyce A:Lodging:120.14Zalaya:Lodging:173.6Chung-cha kim:Conference:425ServiceTotal AverageDiningLodging220.844.16544.0 181,35Conference 425.0 425.00Dividing by Zero, this hotel service not usedFigure 2a input file sample exe2Figure 2b Output sample exe2Optional:Try to resolve the division by zero error so the output becomes as shown in figure 2c**********ServiceTotal AverageDiningLodgingConference 425.0 425.00Parking220.844.16544.0 181.350.00,00Figure 2e Output Sample2 exe2Benjamin Bayer:Dining:26.5English Joyce A:Lodging:120.14Zalaya:Lodging:173.6Chung-cha kim:Conference:425Davidson:Dining:15.6Rohan Panchal:Dining:36.9Barbara Benson:Dining:45.8Smith John B:Lodging:250.3Wong, Fanklin:Dining:96(Hotel text file )

A hotel keeps records of its sales in a text file (called "hotel.txt"; provided in the MOODLE). Each line contains the following information separated by semicolons (":"): The client's name, the service sold (such as Dining, conference...), and the amount of the sale. Figure 2 shows a few lines of input file. Write a program that reads such a file and displays the total and average amount for each service category. Knowing that there are four services (Dining, Lodging,

A hotel keeps records of its sales in a text file (called "hotel.txt"; provided in the MOODLE). Each line contains the following information separated by semicolons (":"): The client's name, the service sold (such as Dining, conference...), and the amount of the sale. Figure 2 shows a few lines of input file. Write a program that reads such a file and displays the total and average amount for each service category. Knowing that there are four services (Dining, Lodging,

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

The File class contains file input and output operations. In other words, you can use the File class to read and write content from and to files. True False
C++ Language : Write a program to write the numbers from 1 to 10 in a file called "test.txt" and then read the contents of same file and display it on screen
This Python Lab 9 Lab: Write a file copying program. The program asks for the name of the file to copy from (source file) and the name of the file to copy to (destination file). The program opens the source file for reading and the destination file for writing. As the program reads each line from the source file and it writes the line to the destination file. When every line from the source file has been written to the destination file, it close both files and print “Copy is successful.” In the sample run, “add.py” is the source file and “add-copy.py” is the destination file. Note that both “add-copy.py” is identical to “add.py” because “add-copy.py” is a copy of “add.py”. Sample run: Enter file to copy from: add.py Enter file to copy to : add-copy.py Copy is successful. Source file: add.py print("This program adds two numbers") a = int(input("Enter first number: ")) b = int(input("Enter second number: ")) print(f"{a} + {b} = {a+b}") Destination file:…
Python programming language Write a program that asks the user for a number. Write the number to a file called total.txt. Then ask the user for a second number. Write the new number on line 2 with the total for both numbers next to it separated by a comma. Then ask the user for a third number and do the same. Keep asking for numbers until the person puts in a zero to terminate the program. Close the file. Be sure to use at least 2 functions [main() and total_numbers(number, total)]. Put all inputs and outputs into the main function, with all calculations into the total_numbers function. Give me a number: 13 Give me another number: 14 14 + 13 = 27 Give me another number: 3 3 + 27 = 30 Give me another number: 4 4 + 30 = 34 Give me another number (0 for quit): 0 Your total is 34. Write a program that displays the lines from the total.txt file in the following output. Use a try catch phrase to check for errors. Use only one function for this portion [main()]. 13 14, 27 3,…
please save number random and file and when print on monitor read from file and every num in single line
Creates a sales receipt, displays the receipt entries and totals, and saves the receipt entries to a file .Prompt the user to enter the - Item Name Item Quantity Item Price Display the item name, the quantity, and item price, and the extended price (Item Quantity multiplied by Item Price) after the entry is made Save the item name, quantity, item price, and extended price to a file When you create the file, prompt the user for the name they want to give the file Separate the items saved with commas Each entry should be on a separate line in the text file Ask the user if they have more items to enter Once the user has finished entering items Close the file with the items entered Display the sales total If the sales total is more than $100 Calculate and display a 10% discount Calculate and display the sales tax using 8% as the sales tax rate The sales tax should be calculated on the sales total after the discount Display the total for the sales receipt
in C# Code in VS studio: Create a program that has 2 options for a user to select. The first option accepts information from the user and then save that data to a file on disk. The second option loads all data stored on that file.
Phone Book Program Data to Input/Output Name Contact Number Age Address Email Address Description Name of the contact in the Phone Book Cellular number of the contact in the Phone Book Current age of the contact in the Phone Book Current address of the contact in the Phone Book Email address contact in the Phone Book Your program should ask the user which task he'she wants to do in your program: Example: Tasks: Tasks: A- Add a contact V- View a contact U- Update a contact D- Delete a contaet A- Add a contact V- View a contact U-Update a contact D- Delete a contact Chonen Task is: A Chosen Task is: V
A Company wants to produce a product orders report from its product orders file. Each record on the file contains the product number of the item ordered, the product description, the number of units ordered, the retail price per unit, the freight charges per unit, and the packaging costs per unit. Your algorithm is to read the product orders file, calculate the total amount due for each product ordered and print these details on the product orders report. The amount due for each product is calculated as the product of the number of units ordered and the retail price of the unit. A discount of 10% is allowed on the amount due for all orders over GHC100.00. The freight charges and packaging costs per unit must be added to this resulting value to determine the total amount due. Answer should be in pseudo code
Design an application for the ABC Company that will process inventory from a file called ABC_Inventory.txt (attached to this assignment). The file contains Item ID, Description and list price stored on a separate line in the file. The program should display the contents of each record and then calculate and display the average list price. it is important that this is done in Thonny for python w
Data File: Example #1AAAAABBBBBCCCCCDDDDDAAEBCBAFBBCDCECDADDEFEEFFFExample #2AAATAABTBBBBCCCCTCDDTDDDAASAABBSBBCCSCCDSDDDEEEAEEFBFFFDDF Write a program that will give the user a brief introduction, then allow the user to type in the name of the file to be analyzed, the name of the data file to generate, and then process the data to match the output that is shown below. This DNA test measures the various parts of the sequence and assigns them a letter. While the letters could be anything from A to Z, the only letters that matter for this test are the letters {A,B,C,D} all other letters can be ignored completely. A sample will be tested, given a length of time and then tested again. Each time the scientist will generate a line of data. Here is one Example: Example #1 AAAAABBBBBCCCCCDDDDD AAEBCBAFBBCDCECDADDEFEEFFF At first glance the sample looks significantly different after the second test. But if you look at the data, you will note that since we only care about A,B,C,D’s that the…
Open the project or solution named mpg in this folder: ex_starts\ch07_ex1_mpg Review the code and run the program to refresh your memory on how it works. Notice that, unlike the program in this chapter, this program lets the user perform more than one calculation, it stores the values the user enters in a text file, and it displays the total miles, total gallons, and average miles per gallon when the program starts and after each entry. Add a function that calculates the miles per gallon Define a function named calculate_mpg() before the main() function that calculates the miles per gallon. This function should accept two double values for the miles and gallons, round the result to two decimal places, and return the result as a double type. Modify the code in the main() function so it uses the calculate_mpg() function. Note that the miles per gallon is calculated in three different places. Move the definition for the calculate_mpg() function after the main() function. When you run…