import csv
import re

years = ['1995','1996','1997','1998','1999','2000','2001','2002','2003','2004','2005','2006','2007','2008','2009']
regions = csv.reader(open('regions.csv'))
eur  = csv.reader(open('nama_r_e2gdp_1_Data.csv'))
eurp = csv.reader(open('nama_r_e2gdp_2_Data.csv'))
mil  = csv.reader(open('nama_r_e2gdp_3_Data.csv'))
pps  = csv.reader(open('nama_r_e2gdp_4_Data.csv'))
ppsp = csv.reader(open('nama_r_e2gdp_5_Data.csv'))

nuts2 = open('regions.txt','w')
eurfile = open('eur.txt','w');
eurpfile = open('eurp.txt','w');
milfile = open('mil.txt','w');
ppsfile = open('pps.txt','w');
ppspfile = open('ppsp.txt','w');

def processnum(s):
  if s==':':
    return 'NaN '
  else:
    return re.sub(',','',s)+' '
next(regions)
next(regions)
for i in range(30):
  next(eur)
  next(eurp)
  next(mil)
  next(pps)
  next(ppsp)
for i in range(35):
  country = next(regions)[0]
  if re.match('European Free',country):
    continue
  for t in range(15):
    next(eur)
    next(eurp)
    next(mil)
    next(pps)
    next(ppsp)
  while True:
    r = next(regions)[0]
    extra = re.match('Extra-Regio',r)
    if extra:
      next(regions)
      for i in range(30):
        next(eur)
        next(eurp)
        next(mil)
        next(pps)
        next(ppsp)
      break
    else:
      nuts2.write("%s: %s\n" % (country, r))
      for t in range (15):
        eurfile.write(processnum(next(eur)[3]))
        eurpfile.write(processnum(next(eurp)[3]))
        milfile.write(processnum(next(mil)[3]))
        ppsfile.write(processnum(next(pps)[3]))
        ppspfile.write(processnum(next(ppsp)[3]))
      eurfile.write('\n')
      eurpfile.write('\n')
      milfile.write('\n')
      ppsfile.write('\n')
      ppspfile.write('\n')

nuts2.close()
eurfile.close()
eurpfile.close()
milfile.close()
ppsfile.close()
ppspfile.close()