Question
The first line shows the attributes. Each line shows one students scores Write the python code to get the answer of following tasks. Use python
The first line shows the attributes. Each line shows one students scores
Write the python code to get the answer of following tasks. Use python code to directly write the result to a file called result.txt. And save the plot to figure.png.
Manual counting of the results will get 0 point. Need to use for/while loop to get the results.
suppose the ID of first student is 0, the ID of second student is 1. Suppose missing value is 0
4. How many scores are less than 80?
5. How many students this course has?
6. What is average score of the Assignment: Test 1 (Lecture) (Real)? The Assignment: Test 1 (Lecture)(Real) column is cell AJ and the scores underneath
7. plot the distribution of first students score. (ignore the missing value, x axis is the ID of the assignment, y axis is the score. Assume the ID of first assignment is 0, the second one is 1.)
Use plt.savefig() function to save the figure as figure.png
You should add x and y legend for the figure
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Conceptual Database Design An Entity Relationship Approach
Authors: Carol Batini, Stefano Ceri, Shamkant B. Navathe
1st Edition
0805302441, 978-0805302448
