Learn practical skills, build real-world projects, and advance your career
# 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()