
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question

Transcribed Image Text:Exercise 2:
Write a Python program that reads from each line of an input file called grades.txt, a student id
followed by the student grades in 3 exams. The program will then calculate the average of the
student and save in a file called results.txt the student id followed by the calculated average. For
example, if the grades.txt contains
S111 60 60 90
S222 89.5 90 89
S333 42 50 43
The file results.txt will contain
S111: 70.00
S222: 89.50
S333: 45.00
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
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps with 3 images

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
- Write a program that reads a text file named as “input.txt” and performs the following operations:1. Write each word in the text file in reverse order to the file named as“output.txt” . (Example: If the text file contains ”Hello World!”, then itshould write to the output file ”olleH dlroW!”)2. Print the number of words.3. Print the number of words starting with a capital letter.4. Print the number of words that contain no characters other than Englishletters.In this challenge you are supposed to:1. Comment every function with a description explaining what it does andhow it does it.2. Research and learn how to read and write into text files by using properlibrary functions in C.In your program, you can assume that1. Both the input file (input.txt) and the output file (output.txt) will beplaced on the same folder as your program’s executable (.exe).2. In the input file, the length of the words will be at most 100.arrow_forwardQI: Write a program to calculate the average of four integer score, and find the grade for 7 students. The program should do the following: 1. Read the first, second name and the four score of the 7 student from the file (E:lexam.txt), 2. Calculate the average and find the grade of the average by using the if and if else. 3. Save the first, second name, average and the grade for each student in file (E:grade.txt). (10 columns for the first and second name. 4 columns, precision 2, for the average and grade)arrow_forwardWrite a program that creates the file "LetterGrades.txt" filled with 1000 randomly generated letter grades. Letter grades: A+, A, B+, B, C+, C, D+, D, and F. Python programarrow_forward
- Exercise 6 : Given a text file containing numbers. Write a Python program that reads the text file line by line, and then calculates the number of even and odd digits in each line. At the end, your program should calculate the total number as well as the probability of even and odd numbers throughout the file, as shown in Figure 3. Input text file 12 3 4 56 78 2 39 89 34 56 73 900 12 45 67 23 90 11 1 12 34 56 77 2 Program output: In line 1 there are In line 2 In line 3 there are In line 4 In total there are 19 even digits and 25 The probability of evens digits is: 0.43. The probability of evens digita is: 0.57. 5 even digits and 6 odd digits. odd digits. 7 odd digits. even digits and 5 odd digita. odd digits. even digita and even digits and there are there are Figure 3. Input text file and Program outputarrow_forwardJava Your program must read a file called personin.txt. Each line of the file will be a person's name, the time they arrived at the professor's office, and the amount of time they want to meet with the professor. These entries will be sorted by the time the person arrived. Your program must then print out a schedule for the day, printing each person's arrival, and printing when each person goes in to meet with the professor. You need to print the events in order of the time they happen. In other words, your output will be sorted by the arrival times and the times the person goes into the professor's office. In your output you need to print out a schedule. In the schedule, new students go to the end of the line. Whenever the professor is free, the professor will either meet with the first person in line, or meet with the first person in line if nobody is waiting. Assume no two people arrive at the same time. You should solve this problem using a stack and a queue. You can only…arrow_forwardWrite a Python program that reads a text file called student.txt. The input text file contains student_ID, student_name, Quiz_grade as well as Test_grade for each student. Your program should read each student details from the file Then calculate the average of Quizzes and Tests marks Display the students’ details: Total number of students, total average, the total highest and lowest marks. The program should output the report into a file called output.txt. A sample of output text file is given below.arrow_forward
- Write a program that reads student's IDs and exam scores (type int) for a particular exam in a course from each line of an input file (the input file is included). You need to compute the average of these scores and assign grades to each student according to the following regulation: If a student's score is within 10 points (above or below) of the average, assign a grade of satisfactory. If a student's score is more than 10 points above average, the grade will be outstanding. If a student's score is more than 10 points below the average, the grade will be unsatisfactory. The output of your program should consist of a three-column table that shows each ID, score, and corresponding grade. A sample output is shown below. ID SOLS SENTO 0 1 2 3 4 8 9 Score 75 99 66 43 87 65 82 91 84 76 Grade Satisfactory Outstanding Unsatisfactory Unsatisfactory Outstanding Unsatisfactory Satisfactory Outstanding Satisfactory Satisfactory Write necessary functions and put them in a module to process this…arrow_forwardPython Write a program that requests five grades as input. Your program should drop the lowest two grades. It should then display the range and average of the remaining three grades. Your program should use a function that returns two values. Name your file: grades.pyarrow_forwardWrite a program that reads data from a file containing integers that ends with -999. Output the numbers that are divisible by 7 Output the numbers that are divisible by 11 Output the numbers that are not divisible by 7 or 11arrow_forward
- urgent plzarrow_forwardThe Payroll Department keeps a list of employee information for each pay period in a text file. The format of each line of the file is the following: <last name> <hours worked> <hourly wage> Write a program that inputs a filename from the user and prints to the terminal a report of the wages paid to the employees for the given period in Python. The report should be in tabular format with the appropriate header. Each line should contain: An employee’s name The hours worked The wages paid for that period.arrow_forwardDesign a modular program in Python to process payroll for all hourly paid employees, save all the data into a text file and make a backup file as well. The program should allow user enter each employee's ID, name, hours worked, and hourly pay rate. And then calculate gross pay with overtime hours(hours beyond 40) paid 50% more. And then the program should display pay statement for each employee and store them into a same text file. The program should display total number of employees, total number of hours worked by all employees, and total gross pay and save them at the end of the same text file as well. The program should contain the following functions: main(), get_employee_info(), calc_gross_pay(hours, rate), display_pay_statement(emp_id, emp_name, hours_horked, hourly_pay_rate, gross_pay), save_pay_statement_to_file(file_object, emp_id, emp_name, hours_worked, hourly_pay_rate, gross_pay), save_summary_to_file(file_object, number_of_employees, total_hours_worked, total_gross_pay).…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education

Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON

Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education