Python get_rate Examples

Example #1

    envtable="%s.emissions_quantity" % config.SCHEMA,
    ind_col_name="industry",
    series_col_name="1")  # we just have emissions, no series, need hack

cfgen = CounterfactGenerator(iogen, envgen)

cfgen.set_series_code(["1"], "emissions")

for year in config.STUDY_YEARS:
    print(year)
    iogen = cfgen.get_iogen()
    iogen.set_table("%s.ixi_%d" % (config.SCHEMA, year))

    exchange_rate = wiod.common.get_exchange_rate("CAN", year)
    if exchange_rate is None:
        exchange_rate = exrate.get_rate("ca", year)

    iogen.set_exchange_rate(exchange_rate)

    envgen = cfgen.get_envgen()
    envgen.set_universal_conditions([
        "year = %d" % year,
        "industry not in %s" % sqlhelper.set_repr(config.env_blacklist),
    ])

    io_harmonizer = matrixutils.generate_selector_matrix(
        "%s.sector_map" % config.SCHEMA, iogen.get_sectors(), "io_code",
        "harmonized", ["io_code is not null"])

    env_harmonizer = matrixutils.generate_selector_matrix(
        "%s.sector_map" % config.SCHEMA, envgen.get_sectors(), "env_code",

Example #2

File: counterfact.py Project: sonya/eea

for series_code in config.env_series.keys():
    cfgen.set_series_code(series_code)

    for year in config.STUDY_YEARS:
        iogen = cfgen.get_iogen()
        iogen.set_table("%s.ixi_%d" % (config.SCHEMA, year))
        iogen.set_fd_sectors(config.fd_sectors[year])
        iogen.blacklist_from_sectors(config.from_blacklists[year])
        iogen.blacklist_to_sectors(config.to_blacklists[year])
        iogen.set_pce_col(config.pce_sector[year])
        iogen.set_export_col(config.export_sector[year])

        exchange_rate = wiod.common.get_exchange_rate("JPN", year)
        if exchange_rate is None:
            exchange_rate = 1 / exrate.get_rate("jp", year)

        # tons co2 / (M jpy * exchange rate) = tons co2 / M usd
        # GJ / (M jpy * exchange rate) = GJ / M usd
        # exchange_rate * 1000 gives us kilotons and terrajoules
        iogen.set_exchange_rate(exchange_rate * 1000)

        envgen = cfgen.get_envgen()
        envgen.set_table("%s.env_%d" % (config.SCHEMA, year))

        env_harmonizer = matrixutils.generate_selector_matrix(
            "%s.env_map_%d" % (config.SCHEMA, year), envgen.get_sectors(),
            "env_sector", "harmonized")
        io_harmonizer = matrixutils.generate_selector_matrix(
            "%s.io_map_%d" % (config.SCHEMA, year), iogen.get_sectors(),
            "io_sector", "harmonized")

Example #3

File: counterfact.py Project: sonya/eea

    ind_col_name="sector",
    series_col_name="series",
    value_col_name="value")

cfgen = CounterfactGenerator(iogen, envgen)

for env_series_code in config.env_series:
    cfgen.set_series_code(env_series_code)
    
    for year in config.STUDY_YEARS:
        iogen = cfgen.get_iogen()
        iogen.set_table("%s.ixi_view_%d" % (config.SCHEMA, year))
    
        exchange_rate = wiod.common.get_exchange_rate("GBR", year)
        if exchange_rate is None:
            exchange_rate = exrate.get_rate("uk", year)

        # k tons / (M pounds * exchange_rate) = k tons / million usd
        iogen.set_exchange_rate(exchange_rate)
    
        envgen = cfgen.get_envgen()
        envgen.set_table("%s.env_%d" % (config.SCHEMA, year))
    
        # we need to keep building this up because
        # some years are missing sectors
        env_harmonizer = matrixutils.generate_selector_matrix(
            "%s.code_map" % config.SCHEMA,
            envgen.get_sectors(), "env_code", "harmonized",
            ["env_code is not null"])
    
        series = env_series_code

Example #4

File: counterfact.py Project: sonya/eea

    envtable="%s.emissions_quantity" % config.SCHEMA,
    ind_col_name="industry",
    series_col_name="1") # we just have emissions, no series, need hack

cfgen = CounterfactGenerator(iogen, envgen)

cfgen.set_series_code(["1"], "emissions")
    
for year in config.STUDY_YEARS:
    print(year)
    iogen = cfgen.get_iogen()
    iogen.set_table("%s.ixi_%d" % (config.SCHEMA, year))

    exchange_rate = wiod.common.get_exchange_rate("CAN", year)
    if exchange_rate is None:
        exchange_rate = exrate.get_rate("ca", year)

    iogen.set_exchange_rate(exchange_rate)
    
    envgen = cfgen.get_envgen()
    envgen.set_universal_conditions([
            "year = %d" % year,
            "industry not in %s" % sqlhelper.set_repr(config.env_blacklist),
            ])

    io_harmonizer = matrixutils.generate_selector_matrix(
        "%s.sector_map" % config.SCHEMA,
        iogen.get_sectors(), "io_code", "harmonized",
        ["io_code is not null"])

    env_harmonizer = matrixutils.generate_selector_matrix(

Example #5

File: counterfact.py Project: sonya/eea

for series_code in config.env_series.keys():
    cfgen.set_series_code(series_code)
    
    for year in config.STUDY_YEARS:
        iogen = cfgen.get_iogen()
        iogen.set_table("%s.ixi_%d" % (config.SCHEMA, year))
        iogen.set_fd_sectors(config.fd_sectors[year])
        iogen.blacklist_from_sectors(config.from_blacklists[year])
        iogen.blacklist_to_sectors(config.to_blacklists[year])
        iogen.set_pce_col(config.pce_sector[year])
        iogen.set_export_col(config.export_sector[year])
    
        exchange_rate = wiod.common.get_exchange_rate("JPN", year)
        if exchange_rate is None:
            exchange_rate = 1 / exrate.get_rate("jp", year)

        # tons co2 / (M jpy * exchange rate) = tons co2 / M usd
        # GJ / (M jpy * exchange rate) = GJ / M usd
        # exchange_rate * 1000 gives us kilotons and terrajoules
        iogen.set_exchange_rate(exchange_rate * 1000)
    
        envgen = cfgen.get_envgen()
        envgen.set_table("%s.env_%d" % (config.SCHEMA, year))
    
        env_harmonizer = matrixutils.generate_selector_matrix(
            "%s.env_map_%d" % (config.SCHEMA, year),
            envgen.get_sectors(), "env_sector", "harmonized")
        io_harmonizer = matrixutils.generate_selector_matrix(
            "%s.io_map_%d" % (config.SCHEMA, year),
            iogen.get_sectors(), "io_sector", "harmonized")