In python please 14.5 LAB^: Course GradeWrite a program that reads the student information from a comma separated values (csv) file. The program then creates a text file thatrecords the course grades of the students. Each row of the file contains the Last Name, First Name, Midterm1 score, Midterm2 score, andthe Final score of a student each separated by a comma. A sample of the student information is provided in Studentlnfo.txt. Assume thenumber of students is at least 1 and at most 20. The program performs the following tasks:• Read the file name of the file from the user.Open the text 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:o A: 90 =< xo B: 80 =< x < 90o C: 70 =< x < 80o D: 60 =< x < 70o F:x< 60• Compute the average of each exam.• Output the last names, first names, exam scores, and letter grades of the students into a text file named report.txt. Output onestudent per row and separate the values with a tab character.• Output the average of each exam, with two digits after the decimal point, at the end of report.txt. Hint: Use the precision sub-specifierto format the output.Ex: If the input of the program is:StudentInfo.txtand the contents of Studentlnfo.txt are:Barrett,Edan,70,45,59Bradshaw, Reagan, 96,97,88Charlton, Caius,73,94, 80Mayo, Tyrese, 88,61,36Stern, Brenda,90,86,45the file report.txt should contain:BarrettEdan704559 FBradshawReagan969788ACharltonCaius739480BMayoTyrese886136 DSternBrenda068645Averages: Midterm1 83.40, Midterm2 76.60, Final 61.60

Write a program that reads the student information from a comma separated values (csv) file. The program then creates a text file that records the course grades of the students. Each row of the file contains the Last Name, First Name, Midterm1 score, Midterm2 score, and the Final score of a student each separated by a comma. A sample of the student information is provided in StudentInfo.txt. 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 file from the user. • Open the text 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: o A: 90 =< x o B: 80 =< x < 90

Write a program that reads the student information from a comma separated values (csv) file. The program then creates a text file that records the course grades of the students. Each row of the file contains the Last Name, First Name, Midterm1 score, Midterm2 score, and the Final score of a student each separated by a comma. A sample of the student information is provided in StudentInfo.txt. 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 file from the user. • Open the text 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: o A: 90 =< x o B: 80 =< x < 90

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

12.12 LAB: File name change 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. Ex: If the input of the program is:
12.12 LAB: File name change 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. Ex: If the input of the program is: ParkPhotos.txt and the contents of ParkPhotos.txt are: Acadia2003_photo.jpg AmericanSamoa1989_photo.jpg BlackCanyonoftheGunnison1983_photo.jpg CarlsbadCaverns2010_photo.jpg CraterLake1996_photo.jpg GrandCanyon1996_photo.jpg IndianaDunes1987_photo.jpg LakeClark2009_photo.jpg…
8.7 LAB: File name change 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. Ex: If the input of the program is: ParkPhotos.txt and the contents of ParkPhotos.txt are: Acadia2003_photo.jpg AmericanSamoa1989_photo.jpg BlackCanyonoftheGunnison1983_photo.jpg CarlsbadCaverns2010_photo.jpg CraterLake1996_photo.jpg GrandCanyon1996_photo.jpg IndianaDunes1987_photo.jpg LakeClark2009_photo.jpg…
task 14.1 in java Follow these steps:● Create a new java file called MyFile.java● Write code to read the content of the text file input.txt. For each line ininput.txt, write a new line in the new text file output.txt that computesthe answer to some operation on a list of numbers.● If the input.txt has the following:Min: 1,2,3,5,6Max: 1,2,3,5,6Avg: 1,2,3,5,6Your program should generate output.txt as follows:The min [1, 2, 3, 5, 6] is 1.The max of [1, 2, 3, 5, 6] is 6.The avg of [1, 2, 3, 5, 6] is 3.4.● Assume that the only operations given in the input file are min, max andavg and that a list of comma-separated integers always follows theoperation. You should define the functions min, max and avg that take ina list of integers and return the min, max or avg of the list.● Your program should handle any combination of operations and anylength of input numbers. You can assume that the list of input numbersare always valid integers and that the list is never empty.● Compile, save and run…
3.6.5: Printing array elements separated by commas. Write a for loop to print all NUM_VALS elements of array hourlyTemp. Separate elements with a comma and space. Ex: If hourlyTemp = {90, 92, 94, 95}, print:90, 92, 94, 95 Your code's output should end with the last element, without a subsequent comma, space, or newline.
11.17 (Bucket Sort) Use Python. Show the whole code input and output when done. A bucket sort begins with a one-dimensional array of positive integers to be sorted and a two-dimensional array of integers with rows indexed from 0 to 9 and columns indexed from 0 to n – 1, where n is the number of values to be sorted. Each row of the two-dimensional array is referred to as a bucket. Write a class named BucketSort containing a function called sort that operates as follows: a) Place each value of the one-dimensional array into a row of the bucket array, based on the value’s “ones” (rightmost) digit. For example, 97 is placed in row 7, 3 is placed in row 3, and 100 is placed in row 0. This procedure is called a distribution pass. b) Loop through the bucket array row by row, and copy the values back to the original array. This procedure is called a gathering pass. The new order of the preceding values in the one-dimensional array is 100, 3 and 97. c) Repeat this process for each subsequent…
13.14 LAB: Library book sorting Two sorted lists have been created, one implemented using a linked list (LinkedListLibrary linkedListLibrary) and the other implemented using the built-in ArrayList class (ArrayListLibrary arrayListLibrary). Each list contains 100 books (title, ISBN number, author), sorted in ascending order by ISBN number. Complete main() by inserting a new book into each list using the respective LinkedListLibrary and ArrayListLibrary insertSorted() methods and outputting the number of operations the computer must perform to insert the new book. Each insertSorted() returns the number of operations the computer performs. Ex: If the input is: The Catcher in the Rye 9787543321724 J.D. Salinger the output is: Number of linked list operations: 1 Number of ArrayList operations: 1 Which list do you think will require the most operations? Why?
13.14 LAB: Library book sorting Two sorted lists have been created, one implemented using a linked list (LinkedListLibrary linkedListLibrary) and the other implemented using the built-in ArrayList class (ArrayListLibrary arrayListLibrary). Each list contains 100 books (title, ISBN number, author), sorted in ascending order by ISBN number. Complete main() by inserting a new book into each list using the respective LinkedListLibrary and ArrayListLibrary insertSorted() methods and outputting the number of operations the computer must perform to insert the new book. Each insertSorted() returns the number of operations the computer performs. Ex: If the input is: The Catcher in the Rye 9787543321724 J.D. Salinger the output is: Number of linked list operations: 1 Number of ArrayList operations: 1 Which list do you think will require the most operations? Why?…
10.13 LAB: Thesaurus Given a set of text files containing synonyms for different words, complete the main program to output the synonyms for a specific word. Each text file contains synonyms for the word specified in the file’s name, and each row within the file lists the word’s synonyms that begin with the same letter, separated by a space. The program reads a word and a letter from the user and opens the text file associated with the input word. The program then stores the contents of the text file into a dictionary predefined in the program. Finally the program searches the dictionary and outputs all the synonyms that begin with the input letter, one synonym per line, or a message if no synonyms that begin with the input letter are found. Hints: Use the first letter of a synonym as the key when storing the synonym into the dictionary. Assume all letters are in lowercase. Ex: If the input of the program is: educate c the program opens the file educate.txt, which contains:…
Implement the class Document. [15M] b) Implement a Test program that will create File object for an input file named upm.txt contained in directory C:\MyDocument\. This program will create Document object for the created File object. This program will print out number of characters, number of words, and number of lines in upm.txt file into an output file called output.txt.
5.23 LAB: Adjust values in a list by normalizing When analyzing data sets, such as data for human heights or for human weights, a common step is to adjust the data. This adjustment can be done by normalizing to values between 0 and 1, or throwing away outliers. For this program, adjust the values by dividing all values by the largest value. The input begins with an integer indicating the number of floating-point values that follow. Output each floating-point value with two digits after the decimal point, which can be achieved as follows:print('{:.2f}'.format(your_value)) Ex: If the input is: 5 30.0 50.0 10.0 100.0 65.0 the output is: 0.30 0.50 0.10 1.00 0.65 The 5 indicates that there are five floating-point values in the list, namely 30.0, 50.0, 10.0, 100.0, and 65.0. 100.0 is the largest value in the list, so each value is divided by 100.0. Use Python, please.
(5) Create or add another source file called Business.cpp . In this file, declare and implement a function weeklySalesSummary which passes the 2D array, the row number of rows and number of columns which is a 4x6 matrix or table. The row data represents the daily sales for each item and column data represents each day’s sales for all items. Refer to the table in Question 7 below for reference. void weeklySalesSummary(double sales[][6], int row, int col) The function calculates the total of each row and updates the last column under Total with the calculated total on the right which is the 6th and final column. The function also calculates the total for daily sales for all items, and sets it at the last row along Total: row-header. This will include the total for the final 6th column. The coding will require two sets of nested loops. (6) Create and implement another function called printWeeklySalesSummary which passes the same parameter as those of Question 5, and this function prints…