I'm building a database using 'csv', I need to have the program read the tables and calculate the constraint and goal indices, to get the optimal solution, which commands should I use?


#1

I’m building a database using ‘csv’, I need to have the program read the tables and calculate the constraint and goal indices, to get the optimal solution, which commands should I use?


#2

Most of that sounds like it’s specific to your problem and difficult to give guidance on without more detail.

Surely you’ll want to use CSV.jl for parsing the csv's. You’ll probably also want to familiarize yourself with DataFrames.jl which is nice and light-weight and simple. They actually play fairly nicely with optimization problems due to the fact that their columns are just AbstractVectors.

(I was assuming here that you were talking about using your own csv’s, and not one of the optimization format files.)


#4

Yes, I am using a csv that I created and exported, I am already using DataFrames.jl, but I would like the program to read only the field and assign the values to the field, for example:


| Table: Toy | Table: Profit |

| Ball | 12 |

| Doll | 60 |

In the case, I would like the program to take only the names Toy and Profit, and assign the objective function, without putting the values in the code, and the same would be for the constraints.
(Not if I could explain perfect what I’m thinking of doing)