[Solved]-Python 3 Spyder Resources File Https Drivegooglecom File D 19frvrcltbhnu8cbotwnqxseear3isp Q37198453
Python 3 spyder
Resources file:https://drive.google.com/file/d/19FRV_RCLTBhNu8CbOtWnQXSEeAr3ISp3/view
Task description You are given a student result data file (result.csv). It has columns: ID: student id Ass1 ~ Ass4: assignment scores (out of 100); weight of assi, ass2, ass3 and ass4 is 5%, 15%, 596, and 15%, respectively Exam: examination score (out of 120); weight is 60%. Hurdle is 40% of exam total (48) Total: weighted total result (596″ (ass1+ass3) + 15%”(ass2+ass4) + 60%”exam) Exam Total 65 ID Ass2 Ass3 Ass4 89.1 95.1 74.3 89.8 91.3 50 82.5 54.4 81.3 98.8 85 90.5 63 82 92.5 88.9 94.5 63.9 90.4 95.9 63 53 79 (The above data is for demonstration purposes only. Please download the full version of result.csv.) To pass the unit, a student must achieve at least total >= 50 and exam score > 48, Total score has been provided in the .csv. There is no need for you to re-calculate it Read students’ result data from file result.csv, display students with exam score < 48. Please also save the students’ records to a file called failedhurdle.csv students with exam score < 48 and total> 50 students with exam score 100 (Hints: import pandas, use DataFrame and display) (Sample output as shown in the following figure is for demonstration purposes only.) failedhurdle.csv ExamTotal ID Ass1 Ass2 Ass3 Ass4 74.3 89.8 66.3 57.7 84.7 84.7 64.2 54.4 81.3 53.7 76.3 65 53.8 50 63.9 90.4 81.9 87.7 88.9 78.1 0 63 82 53 42 53 40 45 48 49 37 30 35 34 36 0 15 24 25 26 73 75 18 42 81.5 71.9 50 76.1 73.9 52.9 43.8 61.3 71.3 50 53.2 53.2 0 76 56 50 74 50 0 94.5 93.8 50 95.9 50 0 38 34 14 49 41 40 47 39 47 54 60 78 34 36 Display output students with exam score 48 Ass1 Ass2 Ass3 Ass4 Exam Total 42 53 40 45 48 49 15 14 49 41 40 47 39 3 74.3 54.4 63.0 63.9 31 4 89.8 81.3 82.0 90.4 37 15 66.3 53.7 53.0 81.9 30 24 57.7 76.3 71.0 87.7 35 25 84.7 65.0 73.0 88.9 34 26 84.7 53.8 75.0 78.1 36 33 64.2 50.0 18.0 0.0 42 81.5 43.8 0.0 0.0 44 71.9 61.3 76.0 94.538 47 50.0 71.3 56.0 93.8 34 54 76.1 50.0 50.0 50.0 33 60 73.9 53.2 74.0 95.9 34 78 52.9 53.2 50.0 50.0 36 0 Ass1 Ass2 Ass3 Ass4 Exam Total ID 4 89.8 81.3 82.0 90.4 37 53 students with exam Ass1 Ass2 Ass3 Ass4 Exam Total ID 11 96.6 100.0 98.0 97.3 102 84 93.6 100.0 96.0 100.0 106 90 91 Submission Submit the following files to OnTrack: Your program source code (e.g. task3_2.py) A screen shot of your program running 1. 2. Check the following things before submitting 1. 2. Try to make your code match the supplied code in format and layout Add proper comments to your code Show transcribed image text Task description You are given a student result data file (result.csv). It has columns: ID: student id Ass1 ~ Ass4: assignment scores (out of 100); weight of assi, ass2, ass3 and ass4 is 5%, 15%, 596, and 15%, respectively Exam: examination score (out of 120); weight is 60%. Hurdle is 40% of exam total (48) Total: weighted total result (596″ (ass1+ass3) + 15%”(ass2+ass4) + 60%”exam) Exam Total 65 ID Ass2 Ass3 Ass4 89.1 95.1 74.3 89.8 91.3 50 82.5 54.4 81.3 98.8 85 90.5 63 82 92.5 88.9 94.5 63.9 90.4 95.9 63 53 79 (The above data is for demonstration purposes only. Please download the full version of result.csv.) To pass the unit, a student must achieve at least total >= 50 and exam score > 48, Total score has been provided in the .csv. There is no need for you to re-calculate it Read students’ result data from file result.csv, display students with exam score
Expert Answer
Answer to Python 3 spyder Resources file: https://drive.google.com/file/d/19FRV_RCLTBhNu8CbOtWnQXSEeAr3ISp3/view… . . .
OR
