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

Related questions

Q: C

A: Take a string to read the text from the file. Create an object of a fstream class for the file…

Q: Given a text file containing the availability of food items, write a program that reads the…

A: I have provided PYTHON CODE , TXT FILE screenshot, CODE SCREENSHOT and OUTPUT…

Q: Given a text file containing the availability of food items, write a program that reads the…

A: The steps to create the program are listed below. Input the name of the file from the user. Create…

Q: Language: Python 1. The sample input will have to be in Text File (.TXT) 2. By using the first…

Q: Create a C++ program that manages a list of cars. The list of cars is stored in a file named…

A: Algorithm:Read Cars from File Algorithm (readCarsFromFile):Open the "Cars.txt" file.While not…

Q: the output of the program is: Ham sandwich (Sandwiches) -- Classic ham sandwich Caesar salad…

A: 1. Prompt the user to enter the name of the input file.2. Open the file in read mode using a context…

Q: Summary In this lab, you open a file and read input from that file in a prewritten Python program.…

A: In Python, open() method is been used to open the file in read mode by default. readline() method…

Q: perform the following operations on this Text File Using Java. Display the length of the Text File,…

A: Answer : Here is the code : import java.io.*;import java.util.Scanner; public class Main { //…

Q: Program - Python Create a simple text file called mycandy The first line of the file will be…

A: Solution: Given, Create a simple text file called mycandy The first line of the file will be…

Q: containing a list of photo file names. The program then reads the photo file names from the text…

A: Code: file = open("ParkPhotos.txt") for i in file: temp = i.strip().replace(…

Q: The top 100 songs for each year are available from Wikipedia at:…

A: To achieve this task, we can use the requests library to fetch the Wikipedia pages and the…

Q: charts the daily high and low temperatures in NYC in nyc weather 2021.csv

A: station = 'IEDINBUR6' # Edinburghdata_raw = pd.read_csv('data/{}_weather.csv'.format(station)) #…

Q: Problem 2. Date Printer - Write a program that reads a string from the user containing a date in the…

A: ALGORITHM : 1. Start 2. Split the date into 3 parts: month, day, and year. 3. Use a list to store…

Q: create a Python program that: Opens a file and reads the contents of the following file…

A: Create four empty lists named dates, fuel_used, miles_traveled, and mileage. Open the file named…

Concept explainers

Variables and Constant

Constants and variables are widely used in mathematical equations and expressions. They are also commonly found in the domain of programming, where each language has its own way to differentiate between a constant and a variable. Since they have all sorts of applications, knowing their differences is a good place to start.

Question

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
The following is an example of the contents of temps.txt:
Muscat : 35 : 33 : 40
Nizwa : 40 : 42 : 41 :
Sur : 45 : 47 : 40
Rustaq : 45: 44 : b4
Salalah : 28 : 20 : 17
Sohar : 38 : 39 : 41
Sample input file temps.txt
Error: Wrong content in Nizwa : 40 : 42 : 41 :
Error: Invalid temperature value in Rustaq : 45 : 44 : b4
City
Temp Avg
====
========
Muscat
Sur
36.00
44.00
Salalah
21.67
Sohar
39.33
The average temperature is 35.25
The highest temperature is 44.00 recorded in Sur
Cities with temperature above the average:
City
Temp Avg
====
========
Muscat
36.00
Sur
44.00
Sohar
39.33
Sample Run
Your program must define and use the following functions only:
1. readFile(): reads the city names and temperatures from the input file and stores
the names and temperature averages into two lists cities and tempAvg.
2. findAverage(): returns the average temperature of the list passed as an
argument.
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

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: code

VIEW

Step 2: output

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Problem: Write a Python program that reads from an input file given by a user students information after a summer semester which allow students to take two courses. The program will calculate the accumulated semester grade point average (GPA) according to the courses grades and the number of credit hours of the courses. The GPA scores are shown in table 1. The accumulate GPA is calculated as the following equation GPAcourse 1 Creditscourse 1 + GPAcourse 2 • Credits.course 2 A Credits.course 1 + Creditscourse 2 Accumulate GPA = The input file contains student id and student name in the first line. The rest lines contain courses information (course code, course credit hours, student grade). Suppose the input files always in the same format as in the given sample inputs in Figures 2 and 3. The program should display the result in an output file with name "result ID.txt" where ID is the student Id. Your output files should be in the same format as shown in the given sample outputs in…
PYTHON: I need to get the avg statement out of the loop so that the output prints correctly. Any suggestions. Write a 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. 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…
1. Read a list of fictional characters from a file named "Characters.txt" and store them in a Python list of dictionaries. Characters.txt: "Harry Potter", "Harry Potter series", "J.K. Rowling" "Frodo Baggins", "The Lord of the Rings series", "J.R.R. Tolkien" "Sherlock Holmes", "Sherlock Holmes series", "Arthur Conan Doyle" "Lara Croft", "Tomb Raider series", "Core Design" "James Bond", "James Bond series", "lan Fleming" "Katniss Everdeen", "The Hunger Games series", "Suzanne Collins" 1. Output all the fictional characters in your list. 2. Output all characters created by J.K. Rowling. 3. Output all characters from book series. 4. Count how many characters are from the "Harry Potter" series. 5. Create a histogram of the authors. Each element in the histogram should represent the count of characters created by a specific author. 6. Take all the characters in "Characters.txt" and store them in a Python set of tuples where each tuple represents (character name, book/series, author). 7.…
In Python, Use number.txt file (below). create a program that opens num.txt, a file consisting of a series of integers. Display all of the numbers in the file. num.txt 10 25 36 45 89 42 54 please write code as simply as you can. Please have good variables.
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. Enter filename: order1.txt Product Qty Payment Expresso:2 1200 Turkish coffee:3 1250 2.40 3.75 Expresso Turkish coffee File contents invalid. invalid literal for int() with base 10: '880' Shish tawook:2 8&0 Coca cola:! 1300 3 Water 1/2L: 100 Total: 6.15 Sample input file Sample output
Problem A straight line can be defined by a pair of points p1(x1, yı) and p2(x2, y2). The slope m of a line is defined as follow: У2 — У1 m = 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. 10 -2 7.5 -3.2 4 15.5 -4.6 21 -2 Зр 12.5 6. 2 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 number of pairs of points, computes the corresponding slopes then prints the results on the screen as shown in Figure 2. (ii) Line # X1 Y1 X2 Y2 slope 1 10.00 -2.00 7.50 -3.20 0.48 2 4.00 15.50 -4.60 21.00 -0.64 3 0.00 0.00 0.00…
9b_act2. Please help me answer this in python programming.
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…