GAMS World Forum

Posted: **Fri Dec 07, 2018 9:00 am**

Hi all,

Is there any way to refer to the CSV files in a loop?
All my files have systematic names: file1.csv, file2.csv etc. How do I create a loop including all the files?

I am looking for something like this:

set j /1*10/
loop(j,
$include "filej.csv")
How do I go about it?

Posted: **Fri Dec 14, 2018 10:06 am**

Hi Richard

Just starting to learn how to use embededded code in Gams. Here a solution with python:

Code: Select all

$onEmbeddedCode Python:
  f = open('myinclude.inc', 'w')
  for i in range(10):
     f.write('$include'+'" file' + str(i)+'.csv"\n')
  f.close()
$offEmbeddedCode

$include myinclude.inc

Hope this helps
Cheers
Renger

Posted: **Fri Dec 14, 2018 11:05 am**

Hi @Renger , Thanks a lot ! It was very helpful.

GAMS World Forum

Created a loop including CSVs

Created a loop including CSVs

Re: Created a loop including CSVs

Re: Created a loop including CSVs