data_utils2.py

import pandas as pd

class Schedule:
    def __init__(self,filename):
        '''
        Object Schedule has 6 attributes, inherited from the excel file with the schedule, as lists:
        - subjects, - catalog, - capacity, - section, - days, - slot.
        '''
        attributes=self.build_atributes(filename)
        self.subjects=attributes[0]
        self.catalog=attributes[1]
        self.capacity=attributes[2]
        self.section=attributes[3]
        self.days=attributes[4]
        self.slot=attributes[5]
        self.component=attributes[6]
    def build_atributes(self, filename):
        '''
        Build, from excel file, all 6 Schedule atributes
        '''
        classes = pd.read_excel(filename)
        subjects=classes['Subject'].to_list()
        catalog=classes['Catalog'].to_list()
        capacity=classes['Enrl Capacity'].to_list()
        section=classes['Section'].to_list()
        days=classes['zc.days'].to_list()
        slot=classes['Mtg Time'].to_list()
        component=classes['Component'].to_list()
        return subjects, catalog, capacity, section, days, slot, component