Question: Write a program to load a given dataset called Student_Grades.csv into a NumPy array. Then determine the following items: a) Display all data on screen.
Write a program to load a given dataset called Student_Grades.csv into a NumPy array. Then determine the following items:
a) Display all data on screen.
b) Determine how many students were in the dataset?
c) Display the number of rows and columns of your numpy array.
d) Display the array data types.
e) Display the following Descriptive Statistics of students overall percentage scores:
a. Min score
b. Max score
c. Mean value
d. Median
e. Mode
f. Standard Deviation
g. 25% and 75% percentile
f) Determine how many students achieved an A grade, B, C, D and F grades.
g) Create a pie chart based on the above grade achievements (option f)
Program output should be like this
The following is a sample of Question #2 program output: Display data [[ 15. 50. 50. ... 207. 1442. 94.1868 ] [ 15. 50. 50. ... 197. 1322. 86.34879] [ 15. 50. 50. ... 210. 1510. 98.62834] ... [ 15. 50. 50. ... 200. 1374. 89.74526] [ 15. 50. 50. ... 195. 1287. 84.0627 ] [ 15. 50. 50. ... 210. 1490. 97.32201]] There are 33 students Display numbers of rows and columns (33, 32) Display data type float64
Descriptive Statistics ... Min overall score: 29.65382 Max overall score: 99.86936 Mean: 87.66996787878789 Median: 92.88047 Std. Dev.: 15.553686425410683 Percentile (25%, 75%): [87.1979 96.73416]
Number of students achieved in each grade category: 21 A 8 B 1 C 1 D 2 F
Please provide the solution using python at the earliest.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
