algorithme_gestion_etudiants.py

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'
data = pd.read_excel(file_path)

excel_file_path = 'export_names.xlsx'

menu = []

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)


# REGISTER
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}")
            break  # Exit the loop if the name is valid
        else:
            print("The firstname is not valid. Make sure to follow the specified format.")

    while True:
        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}")
            break  # Exit the loop if the surname is valid
        else:
            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(f"The date is valid : {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.")

    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}")
            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.")

    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}")
            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'.")

    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):
            print(f"The email is valid : {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):
            print(f"The gender is valid : {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.")

    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, Date_of_birth, Place_of_birth, Address, Telephone, Email, Gender, Academic_year, Courses_and_grade, Campus)


def register(data, firstname, lastname, date_of_birth, place_of_birth, address, telephone, email, gender, academic_year, courses_and_grade, campus):
    matricule = generate_matricule(firstname, lastname, date_of_birth)

    student = {
        "Name": firstname,
        "Surname": lastname,
        "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

    data = pd.concat([data, student], ignore_index=True)
    data.to_excel(file_path, index=False)

    print('The person has been registered.\n')

    return

def generate_matricule(firstname, lastname, date_of_birth):
    consonants_name = ''.join([c for c in firstname if c.lower() not in 'aeiouy'])[:3]
    consonants_surname = ''.join([c for c in lastname if c.lower() not in 'aeiouy'])[:2]
    last_consonant_surname = ''.join([c for c in lastname if c.lower() not in 'aeiouy']).lower()[-1]  # not sure if it's the consonant of the first name or the last name
    birth_year_last_two_digits = str(date_of_birth)[-2:]
    random_integer = random.randint(0, 10)
    matricule_e = f"{consonants_name}{consonants_surname}{last_consonant_surname}{birth_year_last_two_digits}{random_integer}"
    matricule_e = matricule_e.lower()

    return matricule_e

# MODIFYING THE DATA OF A STUDENT
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()]

        if student_row.empty:
            print("No student found with the specified matricule.")
            return

        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:
                    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}")
                        data.at[student_index, 'Academic Year'] = 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.")
            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.")

        else:
            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 :")

        print(f"the new matricule is : {matricule}")

        # Save the modified data to the Excel file
        data.to_excel(file_path, index=False)
        print("Modification successfully done.")

# Mapping for field names to DataFrame column names
field_mapping = {
    1: 'Name',
    2: 'Surname',
    3: 'Date of Birth',
    4: 'Place of Birth',
    5: 'Address',
    6: 'Telephone',
    7: 'Email',
    8: 'Gender',
    9: 'Academic Year',
    10: 'Curriculum',
    12: 'Campus'
}


# 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.")
        return

    student_index = student_index[0]
    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:")
    print(data.iloc[student_index])

    confirmation = input("Do you really want to delete this student? (YES/NO) ").upper()
    if confirmation == "YES":
        # Delete the student
        data = data.drop(index=student_index)

        # Save the modified data to the Excel file
        data.to_excel(file_path, index=False)
        print("Deletion successful.")
    else:
        print("Deletion canceled.")



# FIND
def find_student(data):

    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)]
    else:
          print("Invalid search criteria.")
          return

    if results.empty:
        print("No student found with the specified criteria.")
    else:
        print("Student(s) found:")
        for index, row in results.iterrows():
            print(f"Firstname: {row['Firstname']}, Lastname: {row['Lastname']}, Matricule: {row['Matricule']}")


# SHOW
def filter_students(data):
    if data.empty:
        print("The list of students is empty.")
    else:
        table_data = []
        for index, row in data.iterrows():
            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): ").lower()
    if export_choice == "yes":
        export_to_excel(data)
    read_choice = input("Do you want to read the exported list from an Excel file? (yes/no): ").lower()
    if read_choice == "yes":
        read_exported_list()


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): ")

    try:
        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}")
    except Exception as e:
        print(f"An error occurred during reading: {e}")



# SORTING
def sort(data):
    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')
    print('10. Get all Master 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):
    sorted_data = data.sort_values(by='Date of Birth')
    see_the_data(sorted_data, columns_to_show=['Firstname', 'Lastname', 'Date of Birth'])
    export_option(sorted_data)

def sort_by_age(data):
    data['Age'] = (pd.to_datetime('today') - pd.to_datetime(data['Date of Birth'])).astype('<m8[Y]')
    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='AcademicYear', ascending=True)
    see_the_data(sorted_data, columns_to_show=['Firstname', 'Lastname', 'AcademicYear'])
    export_option(sorted_data)




# attention il faut pouvoir matcher ceci avec les résultats obtenus
def sort_passed(data):
    passed_data = data[data['PassedCourse'] == True]
    see_the_data(passed_data, columns_to_show=['Firstname', 'Lastname', 'PassedCourse'])
    export_option(passed_data)

def sort_failed(data):
    failed_data = data[data['PassedCourse'] == False]
    see_the_data(failed_data, columns_to_show=['Firstname', 'Lastname', 'PassedCourse'])
    export_option(failed_data)





def sort_bachelor(data):
    bachelor_data = data[data['Academic Year'] == 'BAC1' or 'BAC2' or 'BAC3']
    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'] == 'MA1' or 'MA2']
    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)



# Example usage
# Replace 'data' with the name of your DataFrame












# STATS

def statistics_analysis(data):
    print('1. Get basic statistics')
    print('2. Get all student grades')
    print('3. Get all grades for a course')
    print('4. Export all statistics')

    while True:
        stats_choice = input("Enter the number of what you want to do: ")
        if stats_choice.isdigit():
            stats_int = int(stats_choice)
            if 1 <= stats_int <= 4:
                print("The choice is valid.")
                break
            else:
                print("The choice must be one of those proposed.")

    if stats_choice == "1":
        basic_stats(data)
    elif stats_choice == "2":
        all_grades(data)
    elif stats_choice == "3":
        course_grades(data)
    elif stats_choice == "4":
        export_stats(data)

def basic_stats(data):
    search_criteria = input("Enter the search criteria for student statistics (Name/Surname/Matricule): ").capitalize()

    if search_criteria == "Name":
        name_search = input("Enter the name of the student: ")
        results = data[data['Name'].str.contains(name_search, case=False, na=False)]
    elif search_criteria == "Surname":
        surname_search = input("Enter the surname of the student: ")
        results = data[data['Surname'].str.contains(surname_search, case=False, na=False)]
    elif search_criteria == "Matricule":
        matricule_search = input("Enter the matricule of the student: ")
        results = data[data['Matricule'].str.contains(matricule_search, case=False, na=False)]
    else:
        print("Invalid search criteria.")
        return

    numeric_columns = results.select_dtypes(include=['number']).columns

    for index, row in results.iterrows():
        student_name = f"{row['Name']} {row['Surname']}"
        student_grades = [row[column] for column in numeric_columns if not pd.isnull(row[column])]

        if 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)

            print(f"\nStatistics for student {student_name}:")
            print(f"Lowest grade: {lowest_grade}")
            print(f"Highest grade: {highest_grade}")
            print(f"Average grade: {average_grade}")
            print(f"Median grade: {median_grade}")
            print(f"Standard deviation of grades: {std_deviation}")
        else:
            print(f"\nNo grades found for student {student_name}.")

def all_grades(data):
    search_criteria = input("Enter the search criteria for student grades (Name/Surname/Matricule): ").capitalize()

    if search_criteria == "Name":
        name_search = input("Enter the name of the student: ")
        results = data[data['Name'].str.contains(name_search, case=False, na=False)]
    elif search_criteria == "Surname":
        surname_search = input("Enter the surname of the student: ")
        results = data[data['Surname'].str.contains(surname_search, case=False, na=False)]
    elif search_criteria == "Matricule":
        matricule_search = input("Enter the matricule of the student: ")
        results = data[data['Matricule'].str.contains(matricule_search, case=False, na=False)]
    else:
        print("Invalid search criteria.")
        return

    student = data[data['Matricule'].str.contains(matricule_search, case=False, na=False)]

    if student.empty:
        print(f"No student found with matricule {matricule_search}.")
        return

    # Select columns containing grades
    grade_columns = student.select_dtypes(include=['number']).columns

    # Display student's grades
    print(f"Grades for student with matricule {matricule_search}:")
    for column in grade_columns:
        if not pd.isnull(student[column].values[0]):
            print(f"{column}: {student[column].values[0]}")

def course_grades(data):

    numeric_columns = data.select_dtypes(include=['number']).columns.tolist()
    print("Here is the list of courses:")
    for column in numeric_columns:
        print(column)

    course_name = input(print("For which course do you want to display grades?"))

    if course_name not in data.columns:
        print(f"The specified course ({course_name}) was not found.")
        return

    # Filter students who participated in this course (non-null grade)
    students_in_course = data[data[course_name].notnull()]

    if students_in_course.empty:
        print(f"No student participated in the course {course_name}.")
        return

    # Display grades of students for the specified course
    print(f"Grades of students for the course {course_name}:")
    for index, row in students_in_course.iterrows():
        print(f"Matricule: {row['Matricule']}, Grade: {row[course_name]}")

def export_stats(data):

    return

# 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')

# Action

def action():
    print("What do you want to do?\nBelow, you will find what is possible followed by the commands to type.\n")
    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("8. Stop the program")

    while True:
        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":
        filter_students(data)
    elif command == "6":
        sort(data)
    elif command == "7":
        statistics_analysis(data)
    elif command == "8":
        return False

menu = []

while True:
    response = action()
    if response is False:
        break
    else:
        if response == True:
            menu = []
        else:
            menu.append(response)