Keyerror

Hi,

I am importing the data in my python code using excel sheet. It has been working alright until I changed some values in the excel. Everything seems to be defined and looks correct to me. I keep getting the following KeyError: (1, 'SANDY', 'PORTLAND')

I am getting the error in this line particularly:

Obj1 = gp.quicksum((t_g[p,i,j]*y_kg[p,i,j,k] + t_a[p,i,j]*y_ka[p,i,j,k]) for p in P for i in I for j in J for k in K)

Here is the excerpt of the code which uses this line:

from gurobipy import *
import os
import gurobipy as gp
from gurobipy import GRB
import numpy as np
import pandas as pd
import random
import matplotlib.pyplot as plt

ExcelFile = 'C:/Users/Admin/Desktop/Final_Code/RealTime_FinalData.xlsx'

m = gp.Model()

# Create sets and parameters
K = ["FOOD", "WATER", "MEDICINE"]
I = ["SANDY", "OREGON CITY","ROSENBURG","MADRAS","BEND"]
J = ["BEAVERTON", "PORTLAND", "ASTORIA","MCMINNVILLE","SALEM","CORVALLIS","ALBANY","EUGENE","MEDFORD"]
N = ["GROUND", "AIR"]
P = [1,2,3]


file = pd.read_excel(ExcelFile, sheet_name=0)
C    = file.set_index('DC')['Cost'].to_dict()
file = pd.read_excel(ExcelFile, sheet_name=1)
C_g  = file.set_index(['DC','Node'])['C_g'].to_dict()
file = pd.read_excel(ExcelFile, sheet_name=2)
C_a  = file.set_index(['DC','Node'])['C_a'].to_dict()
file = pd.read_excel(ExcelFile, sheet_name=3)
t_g  = file.set_index(['P','DC','Node'])['t_g'].to_dict()
file = pd.read_excel(ExcelFile, sheet_name=4)
t_a  = file.set_index(['P','DC','Node'])['t_a'].to_dict()
file = pd.read_excel(ExcelFile, sheet_name=5)
d_j  = file.set_index(['P','Node','Commodity'])['d_j'].to_dict()
file = pd.read_excel(ExcelFile, sheet_name=6)
L    = file.set_index(['DC'])['L'].to_dict()
file = pd.read_excel(ExcelFile, sheet_name=7)
w    = file.set_index('Commodity')['w'].to_dict()
file = pd.read_excel(ExcelFile, sheet_name=8)
s_k  = file.set_index(['P','DC','Commodity'])['s_k'].to_dict()





# decision variables
x = m.addVars(I, vtype=GRB.BINARY, name="x")
y_kg = m.addVars(P,I, J, K, vtype=GRB.BINARY,  name="y_kg")
y_ka = m.addVars(P,I, J, K, vtype=GRB.BINARY,  name="y_ka")
z_kg = m.addVars(P,I, J, K, vtype=GRB.INTEGER, name="z_kg")
z_ka = m.addVars(P,I, J, K, vtype=GRB.INTEGER, name="z_ka")
u_d  = m.addVars(P,J, K,    vtype=GRB.INTEGER, name="u_d")
r_jk = m.addVars(P,J, K,    vtype=GRB.CONTINUOUS, name="r_jk")
r_k  = m.addVars(P,K,       vtype=GRB.CONTINUOUS, name="r_k")  


V_g = 18
V_a = 10
L_g = 2500
L_a = 800
G = 80000000
M = 10000000


# # set objective function
Obj1 = gp.quicksum((t_g[p,i,j]*y_kg[p,i,j,k] + t_a[p,i,j]*y_ka[p,i,j,k]) for p in P for i in I for j in J for k in K)
Obj2 = gp.quicksum(u_d[p,j,k] for p in P for j in J for k in K)

This is the snip  of the excel data from which the code is extracting the data:

Please let me know if you can spot the mistake here. It would be really helpful.

Thanks
Purnima