How can I create a multidict with data from excel file?

Answered

Susana Carmona

• March 14, 2022 16:19
• Edited

Hello everyone,

I started computing data by myself like this:

jobs, endate , qty, pph, setup, weight = gp.multidict({

 ('1'): [date(2022,1,5), 7111, 160, 10, 5],

 ('2'): [date(2022,1,5), 2801, 180, 10, 1],

 ('3'): [date(2022,1,5), 5432, 100, 10, 6]

 })

in order to create a multidict.

Now, I want to create the same (a multidict) but from data export from an excel. I tried this:

df3.to_dict()["jobs"]

 

but I only can added one key value as "jobs". I want to add more values: endate , qty, pph, setup and weight as I done in the first example manually.

 

Thank you!

 

 

0

• 

  Jaromił Najman

  Gurobi Staff

  • March 15, 2022 12:40

  Hi Susana,

  One possible way would be to read your excel data column by column or sheet by sheet and move the respective entries into lists in a correct order. Then, you can construct the multidict by using all of the lists you constructed.

  Best regards, 
  Jaromił

  1

Please sign in to leave a comment.