Python Program to process student's Result data

Python Program

#Program to read student's result file and display normalization curve

import pandas

import matplotlib.pyplot as plt

from scipy.stats import norm

import statistics as st

import numpy as np

#object of the data file

df = pandas.read_csv("grade.csv")

df.describe()

rn = df['Roll_Number']

sub1 = df['Sub1']

sub2 = df['Sub2']

sub3 = df['Sub3']

sub4 = df['Sub4']

sub5 = df['Sub5']

# Calculating mean and standard deviation

mean3 = st.mean(sub3)

sd3 = st.stdev(sub3)

mean4 = st.mean(sub4)

sd4 = st.stdev(sub4)

#print(mean1,sd1)

# Set general plot dimensions

plt.rcParams["figure.figsize"] = (20,15)

plt.xlim([0,20])

x_sub4 = np.arange(0,21,0.5)

y_sub4 = norm.pdf(sub4, mean4, sd4)

y_sub3=norm.pdf(sub3,mean3,sd3)

print(x_sub4)

print(y_sub4)

# Build three subplots

plt.subplot(1,2 , 1)

plt.scatter(sub4, y_sub4, label = 'CAD/CAM IA-1 Marks', color = "black")

s2 = plt.hist(df['Sub4'], 18, density = True, color = "black")

plt.title("CAD/CAM IA-1 Marks")

plt.subplot(1, 2, 2)

plt.scatter(sub3, y_sub3, label = 'fitted curve', color = "orange")

s3 = plt.hist(df['Sub3'], 18, density = True, color = "cyan")

plt.title("KOM IA-1 Marks")

# Set the global title

plt.suptitle("Normality check of students scores using histograms")

#plt.hist(sub1,norm.pdf(sub1, mean, sd))

plt.show()