Question: Task description: You are given a student result data file (result_withoutTotal.csv). It has columns: ID: student id Ass1 ~ Ass4: assignment scores (out of 100);

Task description: You are given a student result data file (result_withoutTotal.csv). It has columns: ID: student id Ass1 ~ Ass4: assignment scores (out of 100); weight of ass1, ass2, ass3 and ass4 is 5%, 15%, 5%, and 15%, respectively. Exam: examination score (out of 120); weight is 60%. ID Ass1 Ass2 Ass3 Ass4 Exam 1 89.1 50 85 88.9 65 N 95.1 82.5 90.5 94.5 52 3 74.3 54.4 63 63.9 31 4 89.8 81.3 82 90.4 37 5 91.3 98.8 92.5 95.9 79 (The above data is for demonstration purposes only. Please download the full version of result_withoutTotal.csv.) Read students' result data from file result_withoutTotal.csv, . Print average of ass1, ass2, ass3, ass4 and exam column, respectively. Print min of ass1, ass2, ass3, ass4 and exam column, respectively. . . . Print max of ass1, ass2, ass3, ass4 and exam column, respectively. Select the students with the highest ass1, ass2, ass3, ass4 and exam, respectively, and print their information (ID, Ass1, Ass2, ..., Exam) (Sample output as shown in the following figure is for demonstration purposes only.) assi average: 79.08241758241758 ass1 min: 50.0 8551 max: 99.1 8552 average: 72.01978021978024 8552 min: 43.0 9552 mox! 108.0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

(1a) DESCRIPITION Write a Java program that will compute and display the final grades for students in a class. A student's final grade is determined from the scores obtained in the class test. Each...

need this done as soon as possible please. Preferably in the next day if possible. College of Engineering and Science NIT1202 Operating Systems Semester 2, 2017 Assignment 1, Part 1 (15%) The aim of...

code javascript: Given a list of transactions within one year, calculate the final balance of an account. Add a fee for each month that did not include at least three card payments for a total sum of...

code javascript: Find the next integer with no two identical consecutive digits. Task description You are given a positive integer N . Your task is to find the smallest integer greater than N that...

code javascript: Given an array of strings, find a pair of strings that share the same letter at the same position. Task description You are given an array S consisting of N strings. Every string is...

code javascript: Check whether the given graph contains a path going through all vertices, one by one, in increasing order of their numbers. Task description You are given an undirected graph...

Code Javascript: Given an array of N numbers within the range [ 1 . . N ] , find the minimum number of increments and decrements of a single element required to make the array a permutation. Task...

Javascript: Given an array of N numbers within the range [ 1 . . N ] , find the minimum number of increments and decrements of a single element required to make the array a permutation. Task...

SIT384 Cyber security analytics Credit Task 5.2C: Linear Regression Task description: You are given one dataset "admission_predict.cav". Its description is as follows: Context This dataset is created...

Code javascript: Find the maximum number of non - intersecting segments of length 2 with equal sums in a given array of integers. Task description You are given an array A of integers. Find the...

When the girl in Figure 7.16 jacks up a car, how can applying so little force produce sufficient force to raise the car?

Identify some possible causal factors for the following support departments: (Appendix 5B) a. Cafeteria b. Custodial services c. Laundry d. Receiving, shipping, and storage e. Maintenance f....

5 This is part of Ivan's homework. Question Write the bearing of B from A in this diagram. Answers Bearing is 152 Is Ivan correct? Explain your answer. N Z- 152 A 208 B

Why did ulta beauty choose cost leadership as its generic strategy? describe at least two factors (drivers) that led to the use of this strategy. What prompted the company to use this strategy at...