cfgen = CounterfactGenerator(iogen, envgen) for series_code in config.env_series.keys(): cfgen.set_series_code(series_code) for year in config.STUDY_YEARS: iotable = "%s.io_%d" % (config.SCHEMA, year) if year > 2006: # use fake IxI table iotable = "%s.io_view_%d" % (config.SCHEMA, year) iogen = cfgen.get_iogen() iogen.set_table(iotable) iogen.set_fd_sectors(config.final_demand[year]) iogen.blacklist_from_sectors(config.from_blacklists[year]) iogen.blacklist_to_sectors(config.to_blacklists[year]) iogen.set_harmonized_rows(config.io_harmonized_sectors[year]) exchange_rate = wiod.common.get_exchange_rate("TWN", year) # tons / (million ntd * exchange_rate) = tons / M usd iogen.set_exchange_rate(exchange_rate) iogen.set_pce_col(config.pce_sector[year]) iogen.set_export_col(config.export_sector[year]) envtable = "%s.env_%d" % (config.SCHEMA, year) envgen = cfgen.get_envgen() envgen.set_table(envtable) env_blacklist = sqlhelper.set_repr(config.env_blacklist[year]) env_condition = "sector NOT IN " + env_blacklist envgen.set_universal_conditions([env_condition]) map_table = "%s.sector_map_%d" % (config.SCHEMA, year)