ValueError: cannot join with no overlapping index names

Answered

Santiago Ospina

• July 13, 2023 00:12

I am trying to minimize:

sum (Xij * Cij )
sum (flow from node i to node j * transportation cost from node i to node j)

X is a gurobi.var object 

in: type(x)
out: pandas.core.series.Series

in: x
out:
i j 
CAL CAL <gurobi.Var x[CAL,CAL]>  
    CAR <gurobi.Var x[CAL,CAR]>  
    CENT <gurobi.Var x[CAL,CENT]>      
    FLA <gurobi.Var x[CAL,FLA]>  
    MIDA <gurobi.Var x[CAL,MIDA]>  
... 
TEX NY <gurobi.Var x[TEX,NY]>  
    SE <gurobi.Var x[TEX,SE]>  
    SW <gurobi.Var x[TEX,SW]>  
    TEN <gurobi.Var x[TEX,TEN]>  
    TEX <gurobi.Var x[TEX,TEX]>

c is in a Pandas DataFrame because when I used c.stack() to convert it into a series it was not letting me process it or multiply it with x either

in: type(c)
out:pandas.core.frame.DataFrame

in: c
out:

	Cost $/MWh
i	j
CAL	CAL	0.000000
	CAR	87.773848
	CENT	46.406115
	FLA	96.928160
	MIDA	88.485428
...	...	...
TEX	NY	62.685476
	SE	28.679621
	SW	31.323380
	TEN	31.253810
	TEX	0.000000

 

I am working with Pandas MultiIndex (followed the gurobipy-pandas webinar recommended path for modeling)

When I check if both x and c have the same index it says that they DO have the same index

in: x.index == c.index

out: array([ True, True, ... , True, True]) # 169 True values

But when I want to define the multiplication gives me the ValueError: cannot join with no overlapping index names

 

in: x * c 

out: ValueError: cannot join with no overlapping index names

How can I fix this? 

Thanks!

Related to

• Pandas

0

• 

  Santiago Ospina

  • July 13, 2023 01:27

  

  

  

  Already managed to solve it!! 

  in: x * c['Cost $/MWh']
  out: 
  i j 
  CAL CAL 0.0 x[CAL,CAL]  
      CAR 87.77384785166932 x[CAL,CAR]  
      CENT 46.406115430596955 x[CAL,CENT]  
      FLA 96.92815957953998 x[CAL,FLA]  
      MIDA 88.48542831091272 x[CAL,MIDA]  
  ... 
  TEX NY 62.68547569529123 x[TEX,NY]  
      SE 28.679621289877527 x[TEX,SE]  
      SW 31.32338030560834 x[TEX,SW]  
      TEN 31.253810487553967 x[TEX,TEN]  
      TEX 0.0 x[TEX,TEX]

  1

Please sign in to leave a comment.