Write a program (mileage.py) that reads gallons and miles from input file “mileage.txt" and compute the ratio column and the average miles per gallon and write results in a new file. The results must be also displayed on screen as shown in Figure 1. 12.89 287 %============ 10.30 200 Gallons Miles Ratio %========= 5.25 120 Figure 1. Sample input file "mileage.txt 12.89 10.30 5.25 287 200 120 22.27 19.42 22.86 ========== The Overall Average was = 21.5 Figure 2. Sample screen output

Write a program (mileage.py) that reads gallons and miles from input file “mileage.txt" and compute the ratio column and the average miles per gallon and write results in a new file. The results must be also displayed on screen as shown in Figure 1. 12.89 287 %============ 10.30 200 Gallons Miles Ratio %========= 5.25 120 Figure 1. Sample input file "mileage.txt 12.89 10.30 5.25 287 200 120 22.27 19.42 22.86 ========== The Overall Average was = 21.5 Figure 2. Sample screen output

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

2. The manager of a basketball stadium wants you to write a program that calculates the total ticket sales after each game. There are four types of tickets – box, sideline, premium, and general admission. After each game, data is stored in a file in the following forms: ticketPrice numberOfTicketsSold Sample data are shown below: 250 5750 100 28000 50 35750 25 18750 The first line indicates that the box ticket price is 250 pesos and that 5750 Tickets were sold at that price. Output the number of the tickets sold and the total sale amount. Format your output with two decimal places.
Exercise 3: Write a program that reads from an input file “scores.txt” student test scores inthe range 0 – 100 and store these scores in a list. Your program should determine the numberof students having scores in each of the following ranges: 0-59, 60-79, 80-89, and 90-100.Display the score ranges and the number of students. (Hint: store the ranges as a list). If yourun your program with the following data:76, 89, 100, 95, 90, 100, 76, 100, 50, 67, 78, 89, 77, 89, 98Your output should be as follows:Number of students: 15 0-59 60-79 80-89 90-100 ===== ===== ===== ====== 1 5 3 6 Your program should have at least these 3 functions:1. main(): displays the ranges and the number of students in each range2. readData(): reads data from input file into a list3. splitIntoRanges(): takes a list of scores and determines the number of studentsin each score range
Program - Python Create a simple text file called mycandy The first line of the file will be Candy Name, Candy Calories, Total Fat Grams Next, add five lines to the file by hand using your favorite five candy bars information. Each line's data will be separated by commas.
The objective of this problem is to show that you can write a program that reads a text file and uses string methods to manipulate the text. File cart.txt contains shopping cart type data from golfsmith.com representing the gifts you have purchased for your dad for this past Fathers Day. Good for you. You have been very generous! The first item in each row of the file is the part number, the second the quantity, the third the price and the fourth the description. Your program will read the file line by line and compute the total cost of all of the items in the list. You will then display a message that looks like this, assuming the cost of each item adds up to 168.42: Here's what your output should look like: The total price for the awesome Fathers Day gifts you bought is $168.42. The shopping cart can be found here: cart.txt. Right click on the link and save the file to the folder where you have your Python files.
The manager of a football stadium wants you to write a program that calculates the total ticket sales after each game. There are four types of tickets—box, sideline, premium, and general admission. After each game, data is stored in a file in the following form: ticketPrice numberOfTicketsSold … Sample data are shown below: 250.75 5750 100.50 28000 50.25 35750 25.00 18750 The first value indicates that the ticket price is Php 250.75 and that 5750 tickets were sold at that price. Output the total number of tickets sold and the total sale amount using c++ compiler. Format your output with two decimal places.
Each input line consists of an employee's last name, first name, current salary, and percent pay increase. For example, in the first input line, the last name of the employee is Miller, the first name is Andrew, the current salary is 65789.87, and the pay increase is 5%. Write a program that reads data from the specified file and stores the output in the file Ch3_Ex6Output.dat. For each employee, the data must beoutputinthefollowingform:firstNamelastName updatedSalary. Format the output of decimal numbers to two decimal places.
Computer Science C++ Create a text file "input.txt" with a certain amount of integers (you decide how many). Write a program that reads these numbers from the file, adds them, and when you have reached the end of the file, calculates the average of these numbers. Print a message and the average to the console. Code this program twice, demonstrating the two methods to detect the end of the file, part A: reading a value from Instream and storing it (boolean expression) in the while loop part B: using the eof() member function
Problem A straight line can be defined by a pair of points p:(x1, yı) and p2(x2, y2). The slope m of a line is defined as follow: У — У X2 - X1 Your program reads the points from a text file called 'points.txt' which contains the coordinates of unknown number of pairs of points as shown in Figure 1. Each line contains four values x1, y1, x2, y2, where x1, yl are the coordinates of the first point and x2, y2 are the coordinates of the second point. m = 10 -2 7.5 -3.2 4 15.5 -4.6 21 -2 Зр 12.5 6 5 -3 -6 10 3 10 15 Figure 1. Input file contains unknown number of point pairs Use Spider, to create the following files: (i) The input file 'points.txt' shown in Figure 1. Your Python program that reads from the input file 'points.txt', the coordinates of unknown (ii) number of pairs of points, computes the corresponding slopes then prints the results on the screen as shown in Figure 2. ==== Line # X1 Y1 X2 Y2 Slope ========= ===== 10.00 0.48 -0.64 inf 1 -2.00 7.50 -3.20 4.00 -4.60 15.50 0.00…
Exercise 4: Write a python program that reads from a text file whose name is provided by the user, a list of a coffee shop products ordered by a customer (a sample input file is shown below). Each line contains item name, quantity and price (in biza) per product. Compute and display the total payment amount (in riyals) for each product as well as the total bill. 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. quantity = “!” or price “8&0”), in which case RuntimeError exception should be raised and the processing stops. Note: Make sure you close any open file even if an error occurs.
Use C++ In a student file, there are names and scores. Find the max score and print out the names of the students with the max score. • You must get a filename as standard input. See two sample outputs on the next page. • The number of students in the file is at most 50. • You need to make two arrays (see the next page). 1. Create a string array with size 50. The array will store the names of the students. 2. Create an integer array with a size of 50. The array will store the scores of the students.
Please use python not java or C++ A straight line can be defined by a pair of points p1(x1, y1) and p2(x2, y2). The slope m of a line is defined as follow: ? = ?% − ?' ?% − ?' Your program reads the points from a text file called ‘points.txt’ which contains the coordinates of unknown number of pairs of points as shown in Figure 1. Each line contains four values x1, y1, x2, y2, where x1, y1 are the coordinates of the first point and x2, y2 are the coordinates of the second point. Figure 1. Input file contains unknown number of point pairs Use Spider, to create the following files: (i) The input file ‘points.txt’ shown in Figure 1. (ii) Your Python program that reads from the input file ‘points.txt’, the coordinates of unknown number of pairs of points, computes the corresponding slopes then prints the results on the screen as shown in Figure 2. Figure 2. The output on screen Your program must define and use the following functions: 1. printHeader(...): prints on screen the three lines…
Computer Science use putty Write a program that includes a function that calculates the equation F= xn sin x. Write the values n, x, and F on the screen and in a file 'data_f.data'. Repeat the program for positive n. Write a program that includes a function that calculates the equation F= x" sin x. Write the values n, x, and F on the screen and in a file data f.data'. Repeat the program for positive n.