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

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 Databases Questions!