6. Write 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. output.txt: 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. student.txt: ID 20181867 20197541 Zakaria 20183245 Ahmed 20199876 Iqbal 20185432 Saem Name Mohammed Class Report Quiz (40%) 90 91 79 66 30 There are total of 5 students The average of total marks is 71.48 Final (60%) 93 89 84 60 60 Mohammed scored the highest marks as 91.8% Saem scored the lowest marks as 48%

6. Write 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. output.txt: 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. student.txt: ID 20181867 20197541 Zakaria 20183245 Ahmed 20199876 Iqbal 20185432 Saem Name Mohammed Class Report Quiz (40%) 90 91 79 66 30 There are total of 5 students The average of total marks is 71.48 Final (60%) 93 89 84 60 60 Mohammed scored the highest marks as 91.8% Saem scored the lowest marks as 48%

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

Python Please! Create a program that will allow a user to do either of the following things: Get input from the user to write the following information to a file: Student name Assignment average grade Mid-term test grade Fi-nal project grade Fi-nal test grade Allow the user to search the file by student name and output a weighted average (15%, 25%, 25%, and 35%, respectively) based on the grades for that student in the file. The user should be able to choose either of the two options until they want to stop.
Python - Next Birthdate In this task, we will write a program that reads birthdate data from a given CSV file, and given the current date, determines which person's birthday will be celebrated next. Create a function with the following signature: nextBirthdate(filename, date) filename: parameter, which represents the CSV filename. date: parameter, which represents the current date. The function should open the CSV file, read the birthdate data, and determine which person's birthday will be celebrated next, given the current date. The name of the person should be returned. In other words, given a date, find the person whose birthday is next. Sample Run birthdates.csv Draven Brock, 01/21/1952 Easton Mclean, 09/02/1954 Destiny Pacheco, 10/10/1958 Ariella Wood, 12/20/1961 Keely Sanders, 08/03/1985 Bryan Sloan,04/06/1986 Shannon Brewer, 05/11/1986 Julianne Farrell,01/29/2000 Makhi Weeks, 03/20/2000 Lucian Fields, 08/02/2018 Function Call nextBirthdate("birthdates.csv", "01/01/2022") Output…
6. Write 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. output.txt: 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. student.txt: ID 20181867 20197541 20183245 20199876 20185432 20179807 Class Report Name Alia Shamma Zainab Noora Hamda Fatma Quiz (40%) 65 97 79 66 30 78 Test (60%) 50 90 84 75 55 82 There are total of 6 students The average of total marks is 71.267 Shamma (20197541) scored the lowest marks as 45 Hamda (20185432) scored the highest marks as 92.8
Code should be in Python. 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'). (Examples in image)
Exercise 5: Write a python program that reads from a text file whose name is provided by the user (see a sample below) blood glucose readings recorded during the last week. Each line contains a certain number of blood glucose readings followed by the patient id. Your program should then display for each patient, their id number, the number of readings, the average value of the readings followed by the patient status (Normal range: 90–120 mg/dl, Low range: less than 90 mg/dl, High otherwise). Your program should consider the following erroneous cases and display appropriate message as shown in the sample output below: • The file does not open/exist • The readings are invalid (non-integer values or negative) or missing, in which case a ValueError exception should be raised and the processing should continue. Enter input filename: patients.txt Patient Id #Readings Average Status ========== ========= ======= ====== 120 150 150 P1111 P1111 3 140 High 100 90 90 100 P2222 P2222 4 95 Normal…
Code should be in Python. A photographer is organizing a photo collection about the national parks in the US and would like to annotate the information about each of the photos into a separate set of files. Write a program that reads the name of a text file containing a list of photo file names. The program then reads the photo file names from the text file, replaces the "_photo.jpg" portion of the file names with "_info.txt", and outputs the modified file names. Assume the unchanged portion of the photo file names contains only letters and numbers, and the text file stores one photo file name per line. If the text file is empty, the program produces no output. (Examples in image)
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.
The Directir file contains namés línhe employees and their phone numbers in the following order: Last name, First name, Phone. The creator of this file made several mistakes by typing commas and dots inconsistently. Write a Python program to read this file and produce an output file with the name DirectoryNew.txt. This file should format the phone directory as follows: Phone First name Number 1 First name 1 Number 2 First name 2 The file MUST end with: End of directory Edit Metadata Edit Metadata Content of the input file The output should be as follows Springsteen, Bruce, 2587. Hassan, Amir, 6958. Phone First name Homes, Rebecca, 5263 Smith, John, 5252 MacDonald, Mirna, 8965! Pichai, Sundar, 9632. Jobs, Steve, 1002 2587 Bruce 6958 Amir 5263 Rebecca 5252 John 8965 Mirna 9632 1002 Goldsmith, Micheal, 5478. Sundar Yassir, Ammar, 8885 Steve Nicholas, Jack, 4696 5478 Micheal 8885 Pang, Chee, 9898 Lee, Andrew, 7412. Jimenez, Dragos, 6547 Ammar 4696 Jack 9898 Chee 7412 Andrew 6547 Dragos…
scores.txt : Jan,86 Drew,92 Blake,85 Alex,81 Taylor,88 Jordan ,72Cam,89 The file scores.txt (attached) contains a list of names and test scores. Create a program that reads each line of the file and determines the highest score and who obtained it. This is an exercise in strings. You are required to use at least one string method to determine the names and the scores. Your output should resemble the following: Highest Score: 100Achieved by: Jay Note; i could not send an attachment of the actual file but i have copied its contents.
PLEASE COMMENT CODE In a python program, create a new file and call it “ tracking”. Write to it four lines each contains information about an order like this: 1-00654-021 Dell charger Toronto-WEST 99-49-ZAD011-76540-022 ASUS battery Milton-EAST 34-56-CBH561-09239-026 HP HD Scarborough-NORTH 12-98-AZC451-12349-029 Mac FD North York-LAWRENCE 34-49-ZWL01Add the file two more lines: 1-34567-055 Lenovo SSD Milton-ON 34-09-MT04 1-90432-091 Lenovo battery Oakville-ON 78-KL98 Define a function that searches for a brand (e.g. Dell, ASUS, etc.). Test the function in your program.
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.
scores.txt : Jan,86 Drew,92 Blake,85 Alex,81 Taylor,88 Jordan ,72Cam,89 Note: code is written in python please The file scores.txt (attached) contains a list of names and test scores. Create a program that reads each line of the file and determines the highest score and who obtained it. This is an exercise in strings. You are required to use at least one string method to determine the names and the scores. Your output should resemble the following: Highest Score: 100Achieved by: Jay Note; i could not send an attachment of the actual file but i have copied its contents.