Learn practical skills, build real-world projects, and advance your career
Created 3 years ago
# Importing Libraries
import pandas as pd
import numpy as np
import math
from pyomo.environ import *
from __future__ import division
from pyomo.opt import SolverFactory
# Reading the data from Excel workbook
StaffAv = pd.read_excel("Staffing+Data.xlsx", sheet_name="StaffAvailability")
Cost = pd.read_excel("Staffing+Data.xlsx", sheet_name="Cost")
transcost = pd.read_excel("Staffing+Data.xlsx", sheet_name='ServiceRate')
MgDemandDist = pd.read_excel("Staffing+Data.xlsx", sheet_name='DemandData')
MgDemandDist.head()
Cost.head()