Newer
Older
import random
import pandas as pd
import os
import statistics
import re
from IPython.display import display
from tabulate import tabulate
all_course_BAC1 = ("Anglais 1", "Fondements du droit public", "Fondements du droit de l'entreprise", "Economie", "Espagnol 1", "Comptabilité", "Informatique de gestion", "Mathématiques de gestion 1", "Statistiques et probabilités", "Pilosophie", "Psychologie", "Sociologie", "Séminaire de travail universitaire en gestion")
all_course_BAC2 = ("Anglais 2", "Droit de l'entreprise", "Macroéconomie", "Microéconomie", "Espagnol 2", "Marketing", "Production", "Informatique et algorithmique", "Finance", "Inférences statistiques", "Mathématiques de gestion 2", "Technologies industrielles")
all_course_BAC3 = ("Anglais 3", "Economie industrielle", "Espagnol 3", "Séminaire : organisations et transformation digitale", "Management humain", "Projet entrepreneurial", "Comptabilité et contrôle de gestion", "Gestion de données", "Coding project", "Econométrie", "Recherche opérationnelle", "Optimization", "Séminaire : organisation et mutations sociales", "Questions de sciences religieuses")
all_course_MA1 = ("Advanced English 1", "Español avanzado 1", "Data analytics", "Projet quantitatif et gestion de projet", "Data Mining", "Nouvelles technologies et pratiques émergentes", "Web mining", "Machine learning", "Quantitative Decision Making", "Recommender Systems", "Pilotage stratégique de l'entreprise", "Séminaire on Current Managerial Issues")
all_course_MA2 = ("Advanced English 2", "Español avanzado 1", "Responsabilité sociétale de l'entreprise","Integrated Information Systems", "Mémoire", "Séminaire d'accompagnement du mémoire")
file_path = '/Users/adrien/vscodeworkspace/coding-project/Data_Base.xlsx'
name_pattern = re.compile(r'^[A-Za-zéèêëàâäôöûüçÉÈÊËÀÂÄÔÖÛÜÇ][A-Za-zéèêëàâäôöûüçÉÈÊËÀÂÄÔÖÛÜÇ\'\-]*$')
date_pattern = re.compile(r'^(0[1-9]|[12][0-9]|3[01])/(0[1-9]|1[0-2])/\d{4}$')
place_of_birth_pattern = re.compile(r'^[A-Za-zÀ-ÖØ-öø-ÿ\s]+$')
address_pattern = re.compile(r'^[A-Za-z\s]+ \d+, [A-Za-z\s]+$')
telephone_pattern = re.compile(r'^\d{3}/\d{2}\.\d{2}\.\d{2}$')
email_pattern = re.compile(r'^[a-zA-Z0-9._%+-]+@student\.uclouvain\.be$')
gender_pattern = re.compile(r'^[MFO]$')
academic_year_pattern = re.compile(r'^(BAC[123]|MA[12])$')
campus_pattern = re.compile(r'^(Louvain-la-Neuve|Mons)$', re.IGNORECASE)
def register_student(data):
# Setting up the patterns to follow for entering information
while True:
Firstname = input("What is the student's firstname? ") # Ask the user for the name
if name_pattern.match(Firstname): # Check if the name matches the specified format
print(f"The firstname is valid : {Firstname}")
print("The firstname is not valid. Make sure to follow the specified format.")
Lastname = input("What is the student's lastname? ") # Ask the user for the surname
if name_pattern.match(Lastname):
print(f"The lastname is valid : {Lastname}")
print("The lastname is not valid. Make sure to follow the specified format.")
while True:
Date_of_birth = input("Please enter a date in the format dd/mm/yyyy: ")
if date_pattern.match(Date_of_birth):
print("The date is not valid. Make sure to follow the format dd/mm/yyyy.")
while True:
Place_of_birth = input("What is the city of birth? ")
if place_of_birth_pattern.match(Place_of_birth):
print(f"The place of birth is valid : {Place_of_birth}")
print("The city of birth is not valid. Make sure to use only letters and spaces.")
while True:
Address = input("Please enter an address in the format 'street number, city': ")
if address_pattern.match(Address):
print("The address is not valid. Make sure to follow the format 'street number, city'.")
while True:
Telephone = input("What is the telephone number? (in the format 000/00.00.00) ")
if telephone_pattern.match(Telephone):
print(f"The telephone number is valid : {Telephone}")
break # Exit the loop if the telephone number is valid
else:
print("The telephone number is not valid. Make sure to follow the requested format.")
while True:
Email = input("Enter the university email (@student.uclouvain.be): ")
if email_pattern.match(Email):
break # Exit the loop if the email is valid
else:
print("The email is not valid. Make sure to follow the requested format.")
while True:
Gender = input("What is your gender? (For Male enter M, for Female enter F, and for another type enter O): ")
if gender_pattern.match(Gender):
break # Exit the loop if the gender is valid
else:
print("The gender is not valid. Make sure to follow the requested format.")
while True:
Academic_year = input("What is your academic year? (BAC1/BAC2/BAC3/MA1/MA2): ")
if academic_year_pattern.match(Academic_year):
print(f"The academic year is valid : {Academic_year}")
break # Exit the loop if the academic year is valid
else:
print("The academic year is not valid. Make sure to follow the requested format.")
if Academic_year in ['BAC1', 'BAC2', 'BAC3'] :
Curriculum = "INGM1BA"
else :
Curriculum = "INGM2M"
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
Courses_and_grade = {}
if Academic_year == 'MA2':
for course in all_course_BAC1 + all_course_BAC2 + all_course_BAC3 + all_course_MA1 + all_course_MA2:
grade = input(f"What is the grade for {course}? ")
while not grade.isdigit() or int(grade) not in range(0, 21):
print("The grade must be an integer between 0 and 20.")
grade = input(f"What is the grade for {course}? ")
Courses_and_grade[course] = int(grade)
elif Academic_year == 'MA1':
for course in all_course_BAC1 + all_course_BAC2 + all_course_BAC3 + all_course_MA1:
grade = input(f"What is the grade for {course}? ")
while not grade.isdigit() or int(grade) not in range(0, 21):
print("The grade must be an integer between 0 and 20.")
grade = input(f"What is the grade for {course}? ")
Courses_and_grade[course] = int(grade)
elif Academic_year == 'BAC3':
for course in all_course_BAC1 + all_course_BAC2 + all_course_BAC3:
grade = input(f"What is the grade for {course}? ")
while not grade.isdigit() or int(grade) not in range(0, 21):
print("The grade must be an integer between 0 and 20.")
grade = input(f"What is the grade for {course}? ")
Courses_and_grade[course] = int(grade)
elif Academic_year == 'BAC2':
for course in all_course_BAC1 + all_course_BAC2:
grade = input(f"What is the grade for {course}? ")
while not grade.isdigit() or int(grade) not in range(0, 21):
print("The grade must be an integer between 0 and 20.")
grade = input(f"What is the grade for {course}? ")
Courses_and_grade[course] = int(grade)
elif Academic_year == 'BAC1':
for course in all_course_BAC1:
grade = input(f"What is the grade for {course}? ")
while not grade.isdigit() or int(grade) not in range(0, 21):
print("The grade must be an integer between 0 and 20.")
grade = input(f"What is the grade for {course}? ")
Courses_and_grade[course] = int(grade)
while True:
Campus = input("Enter 'Louvain-la-Neuve' or 'Mons' depending on the campus: ")
if campus_pattern.match(Campus):
print("The campus choice is valid.")
break # Exit the loop if the campus choice is valid
else:
print("The campus choice is not valid. Make sure to follow the requested format.")
register(data, Firstname, Lastname, Curriculum, Date_of_birth, Place_of_birth, Address, Telephone, Email, Gender, Academic_year, Courses_and_grade, Campus)
def register(data, firstname, lastname,Curriculum, date_of_birth, place_of_birth, address, telephone, email, gender, academic_year, courses_and_grade, campus):
matricule = generate_matricule(firstname, lastname, date_of_birth)
"Date of Birth": date_of_birth,
"Place of Birth": place_of_birth,
"Address": address,
"Telephone": telephone,
"Email": email,
"Gender": gender,
"Academic Year": academic_year,
"Campus": campus,
"Matricule": matricule
for course, grade in courses_and_grade.items():
student[course] = grade
def generate_matricule(firstname, lastname, date_of_birth):
consonant_of_firstname = ''.join([c for c in firstname if c.lower() not in 'aeiou'])[:3]
consonant_of_lastname = ''.join([c for c in lastname if c.lower() not in 'aeiou'])[:2]
last_consonant_of_lastname = ''.join([c for c in lastname if c.lower() not in 'aeiou']).lower()[-1] # ne sait pas si c'est la consonne du prénom ou du nom
year_of_birth_string = str(date_of_birth)[-4:]
matricule = f"{consonant_of_lastname }{consonant_of_firstname}{last_consonant_of_lastname}{year_of_birth_string}{random_integer}"
matricule = matricule.lower()
def modify(data):
while True:
matricule_to_modify = input("Enter the matricule of the student you want to modify (or 'q' to quit): ")
if matricule_to_modify.lower() == 'q':
print("Operation canceled.")
break
student_row = data[data['Matricule'] == matricule_to_modify.lower()]
print("No student found with the specified matricule.")
return
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
print("\nDetails of the student before modification:")
print(student_row[['Matricule', 'Firstname', 'Lastname']])
confirmation = input("Do you really want to modify this student? (YES/NO) ").upper()
if confirmation == "YES":
student_index = student_row.index[0]
print(f"\nModifying the student with matricule {matricule_to_modify}:\n")
print("1. Firstname")
print("2. Lastname")
print("3. Date of Birth")
print("4. Place of Birth")
print("5. Address")
print("6. Telephone")
print("7. Email")
print("8. Sex (M | F | O)")
print("9. Academic Year")
print("10. Curriculum")
print("11. Courses already passed and their grade")
print("12. Campus")
field_to_modify = int(input("Enter the number of the field you want to modify: "))
field_name_to_modify = field_mapping.get(field_to_modify, None)
print(f"You are modifying the field: {field_name_to_modify}")
if field_to_modify == 1: # If the field to modify is the name (Name)
while True:
firstname = input("What is the name you want to modify? ")
if name_pattern.match(firstname):
print(f"The firstname is valid : {firstname}")
if field_to_modify in (1, 2, 3):
matricule = generate_matricule(firstname, data.at[student_index, 'Lastname'], data.at[student_index, 'Date of Birth'])
data.at[student_index, 'Firstame'] = firstname
break # Exit the loop if the name is valid
else:
print("The name is not valid. Make sure to follow the specified format.")
elif field_to_modify == 2:
while True: # Ask the user for the surname
lastname = input("What is the surname? ")
if name_pattern.match(lastname):
print(f"The lastname is valid : {lastname}")
if field_to_modify in (1, 2, 3):
matricule = generate_matricule(data.at[student_index, 'Firstname'], lastname, data.at[student_index, 'Date of Birth'])
data.at[student_index, 'Lastname'] = lastname
break # Exit the loop if the surname is valid
else:
print("The surname is not valid. Make sure to follow the specified format.")
elif field_to_modify == 3:
while True:
date_of_birth = input("Please enter a date in the format dd/mm/yyyy: ")
if date_pattern.match(date_of_birth):
print(f"The date is valid : {date_of_birth}")
if field_to_modify in (1, 2, 3):
matricule = generate_matricule(data.at[student_index, 'Firstname'], data.at[student_index, 'Lastname'], date_of_birth)
data.at[student_index, 'Date of Birth'] = date_of_birth
break # Exit the loop if the date is valid
else:
print("The date is not valid. Make sure to follow the format dd/mm/yyyy.")
elif field_to_modify == 4:
while True:
place_of_birth = input("What is the city of birth? ")
if place_of_birth_pattern.match(place_of_birth):
print(f"The city of birth is valid : {place_of_birth}")
data.at[student_index, 'Place of Birth'] = place_of_birth
break # Exit the loop if the city of birth is valid
else:
print("The city of birth is not valid. Make sure to use only letters and spaces.")
elif field_to_modify == 5:
while True:
address = input("Please enter an address in the format 'street number, city': ")
if address_pattern.match(address):
print(f"The address is valid : {address}")
data.at[student_index, 'Address'] = address
break # Exit the loop if the address is valid
else:
print("The address is not valid. Make sure to follow the format 'street number, city'.")
elif field_to_modify == 6:
while True:
telephone = input("What is the telephone number? (in the format 000/00.00.00) ")
if telephone_pattern.match(telephone):
print(f"The telephone number is valid : {telephone}")
data.at[student_index, 'Telephone'] = telephone
break # Exit the loop if the telephone number is valid
else:
print("The telephone number is not valid. Make sure to follow the requested format.")
elif field_to_modify == 7:
while True:
email = input("Enter the university email (@student.uclouvain.be): ")
if email_pattern.match(email):
print(f"The email is valid : {email}")
data.at[student_index, 'Email'] = email
break # Exit the loop if the email is valid
else:
print("The email is not valid. Make sure to follow the requested format.")
elif field_to_modify == 8:
while True:
gender = input("What is your gender? (For Male enter M, for Female enter F, and for other type enter O): ")
if gender_pattern.match(gender):
print(f"The gender is valid : {gender}")
data.at[student_index, 'Gender'] = gender
break # Exit the loop if the gender is valid
else:
print("The gender is not valid. Make sure to follow the requested format.")
elif field_to_modify == 9:
while True:
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
academic_year = input("What is your academic year? (BAC1/BAC2/BAC3/MA1/MA2): ")
if academic_year_pattern.match(academic_year):
print(f"The academic year is valid: {academic_year}")
if academic_year in ['BAC1', 'BAC2', 'BAC3']:
curriculum = "INGM1BA"
elif academic_year in ['MA1', 'MA2']:
curriculum = "INGM2M"
else:
print("Invalid academic year for curriculum assignment.")
continue
data.at[student_index, 'Academic Year'] = academic_year
data.at[student_index, 'Curriculum'] = curriculum
break # Exit the loop if the academic year is valid
else:
print("The academic year is not valid. Make sure to follow the requested format.")
elif field_to_modify == 10:
while True:
curriculum = input("What is your curriculum? (INGM1BA/INGM2M): ")
if curriculum_pattern.match(curriculum):
if curriculum == 'INGM1BA':
valid_academic_years = ['BAC1', 'BAC2', 'BAC3']
elif curriculum == 'INGM2M':
valid_academic_years = ['MA1', 'MA2']
academic_year = input(f"What is your academic year? ({'/'.join(valid_academic_years)}): ")
if academic_year in valid_academic_years and academic_year_pattern.match(academic_year):
print(f"The academic year for {curriculum} is valid: {academic_year}")
data.at[student_index, 'Academic Year'] = academic_year
data.at[student_index, 'Curriculum'] = curriculum
break # Exit the loop if both curriculum and academic year are valid
else:
print("Invalid academic year for the selected curriculum. Make sure to follow the requested format.")
elif field_to_modify == 11: # Courses and grades
print("Courses already passed and their grade:\n")
for course, grade in data.iloc[student_index].items():
if course not in field_mapping.values():
print(f"{course}: {grade}")
while True:
course_to_modify = input("Enter the course you want to modify: ")
if course_to_modify in data.columns: # The course has been found, you can continue with the rest of your code
print("The specified course has been found.")
break # Exit the loop since the course has been found
else:
print("The specified course has not been found. Please select a new one.")
new_grade = input(f"Enter the new grade for {course_to_modify}: ")
while not new_grade.isdigit() or int(new_grade) not in range(0, 21):
print("The grade must be an integer between 0 and 20.")
new_grade = input(f"Enter the new grade for {course_to_modify}: ")
# Update the grade
data.at[student_index, course_to_modify] = int(new_grade)
elif field_to_modify == 12:
while True:
campus = input("Enter 'Louvain-la-Neuve' or 'Mons' depending on the campus: ")
if campus_pattern.match(campus):
print(f"The campus choice is valid : {campus}")
data.at[student_index, 'Campus'] = campus
break # Exit the loop if the campus choice is valid
else:
print("The campus choice is not valid. Make sure to follow the requested format.")
print("Modification canceled.")
break # Exit the loop if modification is canceled
data.at[student_index, 'Matricule'] = matricule # Update the Matricule column with the new matricule
print("Be careful because of a modification the registration number has changed :")
# Save the modified data to the Excel file
data.to_excel(file_path, index=False)
print("Modification successfully done.")
1: 'Name',
2: 'Surname',
3: 'Date of Birth',
4: 'Place of Birth',
5: 'Address',
6: 'Telephone',
7: 'Email',
8: 'Gender',
9: 'Academic Year',
# DELETION OF A STUDENT BASED ON HIS MATRICULE BECAUSE IT'S UNIQUE
def delete(data):
matricule_to_delete = input("Enter the matricule of the student you want to delete: ")
student_index = data[data['Matricule'] == matricule_to_delete.lower()].index.tolist()
if not student_index:
print("No student found with the specified matricule.")
print(f"\nDeleting the student with matricule {matricule_to_delete}:\n")
# Display the details of the student before deletion
print("Details of the student before deletion:")
confirmation = input("Do you really want to delete this student? (YES/NO) ").upper()
if confirmation == "YES":
# Delete the student
print("Below the search criteria : ")
print("1. By his/her lastname")
print("2. By his/her firstname")
print("3. By his/her matricule")
search_criteria = input("Enter the number of what you want to do: ")
if search_criteria == "1":
surname_search = input("Enter the lastname of the student: ")
results = data[data['Lastname'].str.contains(surname_search, case=False, na=False)]
elif search_criteria == "2":
name_search = input("Enter the firstname of the student: ")
results = data[data['Firstname'].str.contains(name_search, case=False, na=False)]
elif search_criteria == "3":
matricule_search = input("Enter the matricule of the student: ")
results = data[data['Matricule'].str.contains(matricule_search, case=False, na=False)]
if results.empty:
print("No student found with the specified criteria.")
print("Student(s) found:")
for index, row in results.iterrows():
print(f"Firstname: {row['Firstname']}, Lastname: {row['Lastname']}, Matricule: {row['Matricule']}")
table_data.append([row['Firstname'], row['Lastname'], row['Matricule']])
headers = ["Firstname", "Lastname", "Matricule"]
print(tabulate(table_data, headers=headers, tablefmt="pretty"))
export_choice = input("Do you want to export the list to an Excel file? (YES/NO): ").upper()
if export_choice == "YES":
read_choice = input("Do you want to read the exported list from an Excel file? (YES/NO): ").upper()
if read_choice == "YES":
def export_to_excel(data):
excel_filename = input("Enter the name of the Excel file (without extension): ")
excel_filename += ".xlsx"
try:
data.to_excel(excel_filename, index=False)
print(f"List successfully exported to {excel_filename}.")
except Exception as e:
print(f"An error occurred during export: {e}")
def read_exported_list():
excel_filename = input("Enter the name of the Excel file to read (include .xlsx extension): ")
exported_data = pd.read_excel(excel_filename)
print("\nExported List:")
print(exported_data)
print("\nExported list successfully read from Excel.")
except FileNotFoundError:
print(f"File not found: {excel_filename}")
print(f"An error occurred during reading: {e}")
print('1. Sort in ascending alphabetical order')
print('2. Sort in descending alphabetical order')
print('3. Sort by date of birth')
print('4. Sort by age')
print('5. Sort by matricule')
print('6. Sort by academic year')
print('7. Get all people who passed a course')
print('8. Get all people who failed a course')
print('9. Get all Bachelor students')
sorting_choice = input("Enter the number of what you want to do: ")
if sorting_choice == "1":
sort_ascending(data)
elif sorting_choice == "2":
sort_descending(data)
elif sorting_choice == "3":
sort_by_date(data)
elif sorting_choice == "4":
sort_by_age(data)
elif sorting_choice == "5":
sort_by_matricule(data)
elif sorting_choice == "6":
sort_by_academic_year(data)
elif sorting_choice == "7":
sort_passed(data)
elif sorting_choice == "8":
sort_failed(data)
elif sorting_choice == "9":
sort_bachelor(data)
elif sorting_choice == "10":
sort_master(data)
return
def sort_ascending(data):
sorted_data = data.sort_values(by='Firstname', ascending=True)
see_the_data(sorted_data, columns_to_show=['Firstname', 'Lastname', 'Matricule'])
export_option(sorted_data)
def sort_descending(data):
sorted_data = data.sort_values(by='Firstname', ascending=False)
see_the_data(sorted_data, columns_to_show=['Firstname', 'Lastname', 'Matricule'])
export_option(sorted_data)
def sort_by_date(data):
data['Date of Birth'] = pd.to_datetime(data['Date of Birth'], format='%d/%m/%Y')
sorted_data = data.sort_values(by='Date of Birth')
sorted_data['Date of Birth'] = sorted_data['Date of Birth'].dt.strftime('%d/%m/%Y')
see_the_data(sorted_data, columns_to_show=['Firstname', 'Lastname', 'Date of Birth'])
export_option(sorted_data)
def sort_by_age(data):
data['Date of Birth'] = pd.to_datetime(data['Date of Birth'], format='%d/%m/%Y')
today = pd.to_datetime('today')
age_timedelta = today - data['Date of Birth']
data['Age'] = (age_timedelta / pd.Timedelta(days=365.25)).astype(int)
sorted_data = data.sort_values(by='Age', ascending=True)
see_the_data(sorted_data, columns_to_show=['Firstname', 'Lastname', 'Age'])
export_option(sorted_data)
def sort_by_matricule(data):
sorted_data = data.sort_values(by='Matricule', ascending=True)
see_the_data(sorted_data, columns_to_show=['Firstname', 'Lastname', 'Matricule'])
export_option(sorted_data)
def sort_by_academic_year(data):
sorted_data = data.sort_values(by='Academic Year', ascending=True)
see_the_data(sorted_data, columns_to_show=['Firstname', 'Lastname', 'Academic Year'])
export_option(sorted_data)
def sort_passed(data):
course_columns = data.columns[11:]
print("Available Courses:")
for i, course in enumerate(course_columns, 1):
print(f"{i}. {course}")
while True:
try:
choice = int(input("Enter the number of the course you want to display: "))
selected_course = course_columns[choice - 1]
break
except (ValueError, IndexError):
print("Invalid choice. Please enter a valid number.")
passed_data = data[data[selected_course] >= 10]
# Notez que 'selected_course' doit être passé comme une liste pour inclure la note du cours dans 'columns_to_show'
see_the_data(passed_data, columns_to_show=['Firstname', 'Lastname', selected_course])
def sort_failed(data):
course_columns = data.columns[11:]
print("Available Courses:")
for i, course in enumerate(course_columns, 1):
print(f"{i}. {course}")
while True:
try:
choice = int(input("Enter the number of the course you want to display: "))
selected_course = course_columns[choice - 1]
break
except (ValueError, IndexError):
print("Invalid choice. Please enter a valid number.")
failed_data = data[data[selected_course] < 10]
see_the_data( failed_data, columns_to_show=['Firstname', 'Lastname', selected_course])
export_option( failed_data)
bachelor_data = data[data['Academic Year'].isin(['BAC1', 'BAC2', 'BAC3'])].sort_values(by=['Academic Year', 'Lastname'], ascending=[True, True])
see_the_data(bachelor_data, columns_to_show=['Firstname', 'Lastname', 'Academic Year'])
export_option(bachelor_data)
def sort_master(data):
master_data = data[data['Academic Year'].isin(['MA1', 'MA2'])].sort_values(by=['Academic Year', 'Lastname'], ascending=[True, True])
see_the_data(master_data, columns_to_show=['Firstname', 'Lastname', 'Academic Year'])
export_option(master_data)
# export the data into an excel
def export_option(data):
export = input("Do you want to export in a file? (YES/NO) ").upper()
if export == "YES":
filename = input("Enter the filename: ")
filename = filename + '.xlsx'
export_data_to_excel(data, filename)
def export_data_to_excel(data, filename):
data.to_excel(filename, index=False)
print(f"\nData exported to {filename}")
# see the data needed
def see_the_data(data, columns_to_show=None):
if columns_to_show is None:
columns_to_show = data.columns
data_to_show = data[columns_to_show]
table = tabulate(data_to_show, headers='keys', tablefmt='grid')
print(table)
print_menu([
"Get basic statistics",
"Get all student grades",
"Get all grades for a course",
])
stats_choice = get_valid_input("Enter the number of what you want to do: ", 1, 3)
if stats_choice == 1 :
results = search_and_display_stats(data, "Statistics")
elif stats_choice == 2:
results = search_and_display_stats(data, "Grades")
elif stats_choice == 3:
results = course_grades(data)
def print_menu(options):
for index, option in enumerate(options, start=1):
print(f"{index}. {option}")
def get_valid_input(prompt, lower_limit, upper_limit):
user_input = input(prompt)
if user_input.isdigit():
user_choice = int(user_input)
if lower_limit <= user_choice <= upper_limit:
return user_choice
print(f"The choice must be between {lower_limit} and {upper_limit}.")
else:
print("Invalid input. Please enter a valid number.")
def search_and_display_stats(data, stats_type):
print_menu(["Search by Firstname", "Search by Lastname", "Search by Matricule"])
search_criteria = get_valid_input(f"Enter the number of the search criteria for student {stats_type}: ", 1, 3)
if search_criteria == 1:
field_name = "Firstname"
elif search_criteria == 2:
field_name = "Lastname"
elif search_criteria == 3:
field_name = "Matricule"
search_term = input(f"Enter the {field_name.lower()} of the student: ")
results = data[data[field_name].str.contains(search_term, case=False, na=False)]
if not results.empty:
if stats_type == "Statistics":
display_statistics(results)
elif stats_type == "Grades":
display_student_grades(results)
else:
print(f"No students found with the specified {field_name}.")
def display_statistics(results):
numeric_columns = results.select_dtypes(include=['number']).columns
student_name = f"{row['Firstname']} {row['Lastname']}"
student_grades = [row[column] for column in numeric_columns if not pd.isnull(row[column])]
if student_grades:
print_student_statistics(student_name, student_grades)
print(f"\nNo grades found for student {student_name}.")
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
export_choice = input("Do you want to export these statistics? (YES/NO): ").upper()
if export_choice == 'YES':
export_stats(results)
def print_student_statistics(student_name, student_grades):
lowest_grade = min(student_grades)
highest_grade = max(student_grades)
average_grade = statistics.mean(student_grades)
median_grade = statistics.median(student_grades)
std_deviation = statistics.stdev(student_grades)
table = [
["Lowest grade", lowest_grade],
["Highest grade", highest_grade],
["Average grade", average_grade],
["Median grade", median_grade],
["Standard deviation of grades", std_deviation]
]
print(f"\nStatistics for student {student_name}:")
print(tabulate(table, headers=["Metric", "Value"], tablefmt="pretty"))
def display_student_grades(results):
for index, row in results.iterrows():
student_name = f"{row['Firstname']} {row['Lastname']}"
print(f"\nGrades for student {student_name}:")
table = [[column, grade] for column, grade in row.iteritems() if pd.notnull(grade)]
print(tabulate(table, headers=["Course", "Grade"], tablefmt="pretty"))
export_choice = input("Do you want to export these statistics? (YES/NO): ").upper()
if export_choice == 'YES':
export_stats(results)
def course_grades(data):
print("Here is the list of courses:")
print(data.select_dtypes(include=['number']).columns)
course_name = input("For which course do you want to display grades? ")
if course_name in data.columns:
students_in_course = data[data[course_name].notnull()]
if not students_in_course.empty:
display_course_grades(students_in_course, course_name)
else:
print(f"No students participated in the course {course_name}.")
else:
print(f"The specified course ({course_name}) was not found.")
export_choice = input("Do you want to export these statistics? (YES/NO): ").upper()
if export_choice == 'YES':
export_stats(students_in_course)
def display_course_grades(students_in_course, course_name):
print(f"\nGrades of students for the course {course_name}:")
table = [
["Matricule", "Grade"],
*[[row['Matricule'], row[course_name]] for _, row in students_in_course.iterrows() if not pd.isnull(row[course_name])]
]
print(tabulate(table, headers="firstrow", tablefmt="pretty"))
def export_stats(data):
# Ensure numeric columns only
numeric_columns = data.select_dtypes(include=['number']).columns
# Calculate overall statistics
overall_stats = calculate_overall_stats(data, numeric_columns)
# Save overall statistics to Excel
overall_stats.to_excel("overall_statistics.xlsx", index=False)
# Calculate and save statistics for each student
for index, row in data.iterrows():
student_name = f"{row['Firstname']} {row['Lastname']}"
student_stats = calculate_student_stats(row, numeric_columns)
student_stats.to_excel(f"{student_name}_statistics.xlsx", index=False)
def calculate_overall_stats(data, numeric_columns):
all_grades = [row[column] for column in numeric_columns for _, row in data.iterrows() if not pd.isnull(row[column])]
overall_stats = {
"Lowest grade": min(all_grades),
"Highest grade": max(all_grades),
"Average grade": statistics.mean(all_grades),
"Median grade": statistics.median(all_grades),
"Standard deviation of grades": statistics.stdev(all_grades)
}
return pd.DataFrame(list(overall_stats.items()), columns=["Metric", "Value"])
def calculate_student_stats(row, numeric_columns):
student_grades = [row[column] for column in numeric_columns if not pd.isnull(row[column])]
student_stats = {
"Lowest grade": min(student_grades),
"Highest grade": max(student_grades),
"Average grade": statistics.mean(student_grades),
"Median grade": statistics.median(student_grades),
"Standard deviation of grades": statistics.stdev(student_grades)
}
return pd.DataFrame(list(student_stats.items()), columns=["Metric", "Value"])
# Example of usage
# Make sure you have defined and loaded your DataFrame 'data' before calling this function
# Replace 'Course_Name' with the actual name of the course you are looking for
# display_course_grades(data, 'Course_Name')
print("What do you want to do?\nBelow, you will find what is possible followed by the commands to type.")
print("1. Register a student")
print("2. Modify one or more fields")
print("3. Delete a student")
print("4. Find a student")
print("5. Show")
print("6. Sort, display, or export the list")
print("7. View statistics")
print("... To stop the program")
command = input("Enter the number of what you want to do: ") # Check if the command is an integer
if command.isdigit(): # Convert the command to an integer
command_int = int(command) # Check if the command is between 1 and 8
if 1 <= command_int <= 8:
print("The command is valid.")
break # Exit the loop if the command is valid
else:
print("The command must be one of those proposed.")
if command == "1":
register_student(data)
elif command == "2":
modify(data)
elif command == "3":
delete(data)
elif command == "4":
find_student(data)
elif command == "5":
elif command == "6":
sort(data)
elif command == "7":
if response == True:
menu = []
else:
menu.append(response)