Grouping houly data into days to find max parameter values

New to AMPL
,
2

For each d in Day and h in Hour, does your data have a value consumption[d,h] and a value insolation[d,h]? Then your data could be defined in the AMPL model like this:

set Day;
set Hour;
param consumption {Day,Hour} >= 0;
param insolation {Day,Hour} >= 0;

There’s a discussion of reading similar data, in this topic: Reading two sets and 2D data in matrix from one sheet in Excel. It refers to a “2D” spreadsheet table, but the same approach works just as well for a csv table with two index columns and two value columns, like you describe. The table statement would be set up something like this:

set DayHour dimen 2;
set Day = setof {(i,j) in DayHour} i;
set Hour = setof {(i,j) in DayHour} j;

param consumption {Day,Hour} >= 0;
param insolation {Day,Hour} >= 0;

table dayhour IN "amplcsv" "testload.csv":
   DayHour <- [Day,Hour], consumption, insolation;

(If you want the data to be defined differently in AMPL, however, then please show the set and param statements that you have in mind.)