Re: [Help-glpk] How I include a table of 1000 records

[luisjaime]

Hi Noli,

I already see the example that you suggest me, thanks.  It's functional 
but my problem remain.  The examples from AMPL book not work completely 
in glpk but fixing they a little, they work fine.

The example writed in the mail before is wrong, sorry.  The correct is this:

set KF; #for the key field on the table

param field1{KF}; #for the field one, subscribed by the set KF
param field2{KF}; #for the field two, subscribed by the set KF
param field3{KF}; #for the field three, subscribed by the set KF

table data IN "CSV" "tablename.csv":
    KF <- [key], field1 ~ f1, field2 ~ f2, field3 ~ f3;

display KF, field1, field2, field3;
end;

The table file named "tablename.csv" in disk, would have the next 
information:

key,f1,f2,f3
1,0.3,0.2,-7
2,-0.5,7,3.2
3,0.2,0.1,0.0

This example work fine.

Greetings,


luis jaime

El 20/10/15 a las 21:36, Noli Sicad escribió:
> Hi Luis,
>
> If you want to use GLPK/MathProg, please have a look at the csv
> example (i.e. transp_csv.mod) included in the glpk source code.
>
> ~~~~~~~
> e.g.
>
> table tab_plant IN "CSV" "plants.csv" :
>    I <- [plant], a ~ capacity;
>
> table tab_market IN "CSV" "markets.csv" :
>    J <- [market], b ~ demand;
>
> table tab_distance IN "CSV" "distances.csv" :
>    K <- [plant, market], d ~ distance;
>
> ~~~~~~~~
>
> AMPL table is very different from GLPK/MathProg table. AMPL table
> scripts does work in GLPK/MathProg
>
>
> Noli
>
>
>
>
>
>
>
> On 10/21/15, luisjaime <address@hidden> wrote:
> > Thanks Noli.
> >
> > It's your suggestion better.  Google"ing" I find a book: AMPL writed for
> > Robert Fourer, David M. Gay and Brian W. Kernighan, and I'm reading it.
> > Find that for read a table, It will see like:
> >
> > set KF;  #for the key field on the table
> > param field1{LI}; #for the field one
> > param field2{LI}; #for the field two
> > param field3{LI}; #for the field three
> >
> > table data IN "CSV" "tablename.csv":
> >       KF <- [key], field1 ~ f1, field2 ~ f2, field3 ~ f3;
> >
> > The table file named "tablename.csv" in disk, would have the next:
> >
> > key,f1,f2,f3
> > 1,0.3,0.2,-7
> > 2,-0.5,7,3.2
> > 3,0.2,0.1,0.0
> >
> > If any body find utilitarian this information...
> >
> > If some body don't have the book, I've complete in a only file.
> >
> > Thanks.
> >
> > luis jaime
> >
> >
> > El 14/10/15 a las 22:03, Noli Sicad escribió:
> > > Hi Luis,
> > >
> > > Just do this:
> > >
> > > set I:= {1..6};
> > > /* Las i muestras */
> > >
> > > For 10,000 records,
> > >
> > > set I:= {1..1000};
> > >
> > > For CSV file, read and write, you can see the example in
> > > glpk-4.56/examples/csv folder.
> > >
> > > transp_csv.mod
> > >
> > >
> > > Regards, Noli
> > >
> > > On 10/15/15, luisjaime <address@hidden> wrote:
> > > > Good day for all people in this list:
> > > >
> > > > I've the next model:
> > > >
> > > >
> > > > set I;
> > > > /* Las i muestras */
> > > > set J;
> > > > /* los j instrumentos */
> > > >
> > > > param r{i in I, j in J};
> > > > /* cada una de las muestras de los retornos */
> > > >
> > > > var x {j in J};
> > > > /* el portafolio */
> > > >
> > > > minimize obj: sum{i in I, j in J} r[i,j]*x[j];
> > > > /* La función objetivo */
> > > >
> > > > s.t. porc_total: sum {j in J} x[j] = 1;
> > > >
> > > > data;
> > > >
> > > > set I := 1 2 3 4 5 6;
> > > >
> > > > set J := 1 2 3;
> > > >
> > > > param r: 1 2 3:=
> > > >            1 0.04300620 0.06094491 0.8793238
> > > >            2 0.08306441 0.05640739 0.6835024
> > > >            3 0.05271815 0.08390957 1.2346929
> > > >            4 0.09064139 0.08094768 1.1428601
> > > >            5 0.09523738 0.05262512 0.6908464
> > > >            6 0.02364452 0.06848395 1.3471945 ;
> > > >
> > > > end;
> > > >
> > > > this run ok, but, how I do for include 1000 records?  It's imposible
> > > > write set I:= 1 2 3 .... 999 1000; there are a short form?  I tried with
> > > > "set I:=1..1000;" form, but glpsol don't understand.   And, if I will
> > > > like read from a csv file, How I can do it?  Of course I've ready a file
> > > > with the records.
> > > >
> > > > I have readed the gmpl.pdf but if there are examples, all are related
> > > > for the specific item in the guide but haven't examples complete showing
> > > > situations like mine, exception the tsp problem.
> > > >
> > > > Thanks a lot!
> > > >
> > > >
> > > > luis jaime
> > > >
> > > > _______________________________________________
> > > > Help-glpk mailing list
> > > > address@hidden
> > > > https://lists.gnu.org/mailman/listinfo/help-glpk