Exercise 1: Write a Python program that reads from an input files temps.txt city names andtemperatures averages for the last 3 months and displays the following information:• The city names and their 3-month average temperature• The average temperature of all the cities• The highest temperature and its city name• The city names and temperatures for the cities with temperature above the averagetemperatureThe following is an example of the contents of temps.txt:Muscat : 35 : 33 : 40Nizwa : 40 : 42 : 41 :Sur : 45 : 47 : 40Rustaq : 45: 44 : b4Salalah : 28 : 20 : 17Sohar : 38 : 39 : 41Sample input file temps.txtError: Wrong content in Nizwa : 40 : 42 : 41 :Error: Invalid temperature value in Rustaq : 45 : 44 : b4CityTemp Avg============MuscatSur36.0044.00Salalah21.67Sohar39.33The average temperature is 35.25The highest temperature is 44.00 recorded in SurCities with temperature above the average:CityTemp Avg============Muscat36.00Sur44.00Sohar39.33Sample RunYour program must define and use the following functions only:1. readFile(): reads the city names and temperatures from the input file and storesthe names and temperature averages into two lists cities and tempAvg.2. findAverage(): returns the average temperature of the list passed as anargument.3. findMaxTempPos (): returns the position of the highest temperatures in the list.4. displayResults(): displays the output shown in the above sample run.Note:All the displays should be done in displayResults() function.• Use Exception handling when reading data

def readFile(cities,tempAvg): #open file in read mode file=open('temps.txt','r') #read all…

Exercise 1: Write a Python program that reads from an input files temps.txt city names and temperatures averages for the last 3 months and displays the following information: • The city names and their 3-month average temperature • The average temperature of all the cities • The highest temperature and its city name • The city names and temperatures for the cities with temperature above the average temperature

Exercise 1: Write a Python program that reads from an input files temps.txt city names and temperatures averages for the last 3 months and displays the following information: • The city names and their 3-month average temperature • The average temperature of all the cities • The highest temperature and its city name • The city names and temperatures for the cities with temperature above the average temperature

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 program that reads a file called sales.txt containing the following data: Jane, 215.5,445.5,910.0 John, 825.0,250.5,675.0 Bill,0.0,999.15 Each line has a employee's name and their weekly sales totals all separated by commas. Some employees have taken vacation some weeks so no numbers are captured for those weeks. Create a function that takes a list of floats and returns the average value for those numbers. After reading the information from the file, use a for loop to calculate the sales average using your new average function for each employee and display the following output to the screen. Jane, average sales: 523.67 John, average sales: 583.50 Bill, average sales: 499.56
Python Create a program that reads the file (create a paragraph in a file). It should analyze each character of the file. For output, it should produce a well-formatted table indicating: The total number of printable characters The total number of capital letters The total number of lowercase letters The total number of numbers The total number of sentences (which end in a period) The total number of paragraphs (which end in a newline) Since the lab is an exercise in strings, you must use at least TWO different string methods to required information. And each stastic will need its own function.
Write a python program that prompts the user for their favorite basketball team. It should be able to read the list of teams provided below in a file called favorite_teams.txt and check if their team is in that file. Teams in the file:JazzBullsMavericksSpursIf the team is in the file let the user know that their team is in the list of favorites. If the team is not in the file, add the team to the end of the file. Also, let the user know that their team will be added to the file.Sample Run in File:What is your favorite NBA team? Jazz [Enter]Your team Jazz is in the listFile before and after run: JazzBullsMavericksSpurs Sample Run not in File:What is your favorite NBA team? Pelicans [Enter]Your team Pelicans is not in the list. It will be added.File before run: JazzBullsMavericksSpursFile after run:JazzBullsMavericksSpursPelicans
For this assignment, you will write a Python program that uses a file named scores.txt to store sets of bowling scores for different dates. scores.txt should store the data so that each line has a month, day, and the scores the user earned on that date. As an example, scores.txt might look something like this: January 15 200 300 126 200 250April 20 125 100 May 17 300 100 215 The very first time your program starts, scores.txt should not exist (i.e. create it with Python code the first time the program runs). In your main function, continuously give the user the following five options: Quit the program. View all Scores. If the user selects this option, call a function named view_scores. This function should print the scores in a nicely formatted manner. For example: "On January 15, you scored 200, 300, and 126", etc.. Add a Score. If the user selects this option, call a function named add_score. This function should ask the user for a month, day, and as many scores as they want to…
Using Java PrintWriter, write a program that prompts the user for information and saves it to a text file File name is musicians.txt Use this information below: George,Thoroughgood,54321 Ludwig,Van Beethoven,90111 Edward,Van Halen,12345
Exercise 3: Write a program that reads from an input file "scores.txť" student test scores in the 0-100 and store these scores in a list. Your program should determine the number range of 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 you run your program with the following data: 76, 89, 100, 95, 90, 100, 76, 100, 50, 67, 78, 89, 77, 89, 98 Your output should be as follows: Number of students: 15 0-59 60-79 80-89 90-100 ===== ===== ===== ====== 1 Your program should have at least these 3 functions: 1. main(): displays the ranges and the number of students in each range 2. readData(): reads data from input file into a list 3. splitIntoRanges(): takes a list of scores and determines the number of students in each score range
In Python Write a program that consists of (at least) two function: A function that creates and saves data in a file. The saved data represents exam grades. In the function, you will create n random numbers in the range [0,100], where n is the number of students. The function can be called as follows: createFile(filename, n) Main function, in which the user inputs the file name and the number of students, then the main calls function createFile. The main should perform validation for n (should be > 0), and the filename (should end with .txt). I will explain how to validate strings in the coming lecture. Hint: a good developer will write four functions to solve the problem.
Given a text file containing the availability of food items, write a program that reads the information from the text file and outputs the available food items. The program first reads the name of the text file from the user. The program then reads the text file, stores the information into four separate lists, and outputs the available food items in the following format: name (category) - description Assume the text file contains the category, name, description, and availability of at least one food item, separated by a tab character ('\t'). Ex: If the input of the program is: food.txt and the contents of food.txt are: Classic ham sandwich Available sandwich Chicken salad sandwich Not available Classic cheeseburger Cheeseburger Not available Salads Water 16oz bottled water Available Caesar salad Chunks of romaine heart lettuce dressed with lemon juice Available Salads Asian salad Mixed greens with ginger dressing, sprinkled with sesame Not available Beverages Beverages Mexican food…
Python Problem Description: Kevin is a freelance video producer who makes TV commercials for local businesses. When he makes a commercial, he usually films several short videos. Later, he puts these short videos together to make the final commercial. He has asked you to write the following two programs. A program that allows him to enter the running time (in seconds) of each short video in a project. The running times are saved to a file. A successful test run for this program would be as shown below: A program that reads the contents of the file, displays the running times, and then displays the total running time of all the segments. A successful test run for this program would be as shown below:
I see you guys are providing many solutions for this program but it is not giving the output I am being asked for. Write a program that reads a file consisting of students’ test scores in the range 0–200. It should then determine the number of students having scores in each of the following ranges:0–24, 25–49, 50–74, 75–99, 100–124, 125–149, 150–174, and 175–200.Output the score ranges and the number of students. (Run your program with the following input data: 76, 89, 150, 135, 200, 76, 12, 100, 150, 28, 178, 189, 167, 200, 175, 150, 87, 99, 129, 149, 176, 200, 87, 35, 157, 189