$title Splitting of labels using the embedded code facility

$onText
The embedded code facility allows to integrate external code (e.g. Python) during
both compile and execution time of a GAMS program. GAMS symbols are shared with
the external code, so no communication via disk is necessary.

This example demonstrates how to split GAMS labels in Python at GAMS compilation
time to generate new set elements.

Contributor: Lutz Westermann, July 2017
$offText

* On the major platforms (Windows, Linux, Mac), GMSPYTHONLIB gets automatically set 
* to use the internal Python installation in sysdir/GMSPython.
$if not setEnv GMSPYTHONLIB $abort.noError Embedded code Python not ready to be used
$log --- Using Python library %sysEnv.GMSPYTHONLIB%

Set cc      / "France - Paris", "France - Lille", "France - Toulouse"
              "Spain - Madrid", "Spain - Cordoba", "Spain - Seville", "Spain - Bilbao"
              "USA - Washington DC", "USA - Houston", "USA - New York",
              "Germany - Berlin", "Germany - Munich", "Germany - Bonn" /
    country 
    city    
    mccCountry(cc,country<)  Mapping between country and related elements in set cc
    mccCity(cc,city<)        Mapping between city and related elements in set cc;

* Embedded Python code:
* - GAMS set "cc" is read from GAMS as a list
* - Each element of "cc" is split into two elements stored in "country" and "city"
* - The mappings "mccCountry" and "mccCity" are built up in parallel
* - "Country", "city", "mccCountry" and "mccCity" get written back to GAMS
$onEmbeddedCode Python:
  mccCountry = []
  mccCity = []
  for cc in gams.get("cc"):
    r = str.split(cc, " - ", 1)
    mccCountry.append((cc,r[0]))
    mccCity.append((cc,r[1]))
  gams.set("mccCountry",mccCountry)
  gams.set("mccCity",mccCity)
$offEmbeddedCode mccCountry mccCity

option mccCountry:0:0:1, mccCity:0:0:1;
display country, city, mccCountry ,mccCity;