-
Notifications
You must be signed in to change notification settings - Fork 0
/
calculator.py
179 lines (144 loc) · 5.34 KB
/
calculator.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
import tkinter as tk
from tkinter import messagebox
from tkinter import *
from csv import DictWriter
from csv import DictReader
import pandas as pd
import numpy as np
# Clear Data
def clearData():
firstNameEntry.delete(0, END)
lastNameEntry.delete(0, END)
gradeEntry.delete(0, END)
matricEntry.delete(0, END)
def loadData(file: str):
newList = []
with open(file, "r") as f:
reader = DictReader(f, delimiter=",")
for row in reader:
name = row["Name"]
grade = row["Grade"]
matric = row["Matric"]
data = {'Name': name, 'Grade': int(grade), 'Matric': int(matric)}
newList.append(data)
return newList
def enterData():
firstName = firstNameEntry.get()
lastName = lastNameEntry.get()
# Conditional statement to check if firstName and lastName exits
if firstName and lastName:
grade = gradeEntry.get()
matric = matricEntry.get()
if grade and matric:
clearData()
filepath = "data.csv"
with open(filepath, 'a') as file:
field_names = ['Name', 'Matric', 'Grade']
input = DictWriter(file, fieldnames=field_names)
row = {'Name': firstName + " " + lastName,
'Matric': matric, 'Grade': grade+''}
input.writerow(row)
file.close()
else:
messagebox.showerror(None, 'Grade and Score is required')
else:
messagebox.showerror(None, 'Firstname and Lastname is required')
def solveCSV():
file = "data.csv"
df = pd.read_csv(file, usecols=['Name', 'Grade'])
table = df.loc[:, 'Grade']
students = np.array(df)
# Create a new Tkinter window
window = tk.Tk()
window.title('Data Summary')
# Add a label to the window that displays the mean
mean_label = tk.Label(window, text="Mean: " + str(np.mean(table)))
mean_label.pack()
# Add a label to the window that displays the maximum score
max_label = tk.Label(window, text="Maximum Score: " + str(max(table)))
max_label.pack()
# Add a label to the window that displays the minimum score
min_label = tk.Label(window, text="Minimum Score: " + str(min(table)))
min_label.pack()
# Add a label to the window that displays the minimum score
median_label = tk.Label(window, text="Median Score: " + str(solveMedian(file)))
median_label.pack()
above_label = tk.Label(window, text="Students that score 70 and above are: " + str(solveMoreOrLess(file, 70, "greater")))
above_label.pack()
below_label = tk.Label(window, text="Students that failed are: " + str(solveMoreOrLess(file, 45, "less")))
below_label.pack()
window.mainloop()
# Define stats functions
def solveMedian(file: str):
newList = []
with open(file, "r") as f:
reader = DictReader(f, delimiter=",")
for row in reader:
grade = row["Grade"]
if grade is not None:
newList.append(int(row['Grade']))
newList.sort()
n = len(newList)
median = newList[n // 2]
if n % 2 == 0:
median = (median + newList[n // 2-1]) / 2
return median
def solveBest(file: str, best: int):
newList = []
with open(file, "r") as f:
reader = DictReader(f, delimiter=",")
for row in reader:
name = row["Name"]
grade = row["Grade"]
data = {'Name': name, 'Grade': int(grade)}
newList.append(data)
best_student = []
for i in newList:
if i['Grade'] >= best:
best_student.append(i['Name'])
return ", ".join(best_student)
def solveMoreOrLess(file: str, num: int, type: str):
newList = {}
with open(file, "r") as f:
reader = DictReader(f, delimiter=",")
for row in reader:
name = row["Name"]
grade = row["Grade"]
newList[name] = int(grade)
solved_data = []
for name, grade in newList.items():
if type == 'greater':
if grade > num:
solved_data.append(name)
elif type == "less":
if grade < num:
solved_data.append(name)
return ", ".join(solved_data)
window = Tk()
window.geometry("600x300")
window.title("Student Data Grade Entry App")
frame = Frame(window)
frame.pack()
user_info_frame = LabelFrame(frame, text="Student Details")
user_info_frame.grid(row=0, column=0, padx=20, pady=20)
first_name_label = Label(user_info_frame, text="First Name")
first_name_label.grid(row=0, column=0)
last_name_label = Label(user_info_frame, text="Last Name")
last_name_label.grid(row=0, column=1)
firstNameEntry = Entry(user_info_frame)
firstNameEntry.grid(row=1, column=0)
lastNameEntry = Entry(user_info_frame)
lastNameEntry.grid(row=1, column=1)
grade_label = Label(user_info_frame, text="Grade")
gradeEntry = Entry(user_info_frame)
grade_label.grid(row=2, column=0)
gradeEntry.grid(row=3, column=0)
matric_label = Label(user_info_frame, text="Matric Number")
matricEntry = Entry(user_info_frame)
matric_label.grid(row=2, column=1)
matricEntry.grid(row=3, column=1)
button = Button(frame, text="Enter Data", command=enterData)
button.grid(row=1, column=0, sticky="news", padx=50, pady=10)
stats_button = Button(frame, text="Solve Stats", command=solveCSV)
stats_button.grid(row=3, column=0, sticky="news", padx=50, pady=10)
window.mainloop()