Exemplos de ExcelImporter em Python, exemplos de bw2io.ExcelImporter em Python

Exemplo n.º 1

0

Exibir arquivo

Arquivo: with_products.py Projeto: pjamesjoyce/brightway2-io

def test_excel_products_lca():
    ei = ExcelImporter(os.path.join(EXCEL_FIXTURES_DIR, "with_products.xlsx"))
    ei.strategies = [
        csv_restore_tuples,
        csv_restore_booleans,
        csv_numerize,
        csv_drop_unknown,
        csv_add_missing_exchanges_section,
        normalize_units,
        set_code_by_activity_hash,
        assign_only_product_as_production,
        link_technosphere_by_activity_hash,
        drop_falsey_uncertainty_fields_but_keep_zeros,
        convert_uncertainty_types_to_integers,
    ]
    ei.apply_strategies()
    ei.match_database()
    ei.write_database()
    lca = LCA({('Product example', 'B'): 1})
    lca.lci()
    keys = {('Product example', 'B'), ('Product example', 'C'),
            ('Product example', 'E')}
    for key in lca.product_dict:
        assert key in keys
    keys = {('Product example', 'A'), ('Product example', 'C'),
            ('Product example', 'D')}
    for key in lca.activity_dict:
        assert key in keys
    for value in lca.supply_array:
        assert np.allclose(value, 1) or np.allclose(
            value, 0.539) or np.allclose(value, 0.539 * 0.00805)

Exemplo n.º 2

0

Exibir arquivo

def test_process_activities(no_init, monkeypatch):
    monkeypatch.setattr("bw2io.importers.excel.ExcelImporter.get_activity",
                        lambda a, b, c: c)
    ei = ExcelImporter()
    with pytest.raises(ValueError):
        assert ei.process_activities([("name", [["cutoff", "foo"]])])

    given = [("n", [["cutoff", "2"], ["", ""], ["activity", "foo", "bar"],
                    ["1", "2", "3"]])]
    expected = [[["activity", "foo"], ["1", "2"]]]
    assert ei.process_activities(given) == expected

Exemplo n.º 3

0

Exibir arquivo

def test_process_activities(no_init, monkeypatch):
    monkeypatch.setattr('bw2io.importers.excel.ExcelImporter.get_activity',
                        lambda a, b, c: c)
    ei = ExcelImporter()
    with pytest.raises(ValueError):
        assert ei.process_activities([('name', [['cutoff', 'foo']])])

    given = [('n', [['cutoff', '2'], ['', ''], ['activity', 'foo', 'bar'],
                    ['1', '2', '3']])]
    expected = [[['activity', 'foo'], ['1', '2']]]
    assert ei.process_activities(given) == expected

Exemplo n.º 4

0

Exibir arquivo

class BiofuelInventory(BaseInventoryImport):
    """
    Biofuel datasets from the master thesis of Francesco Cozzolino (2018).
    """
    def load_inventory(self, path):
        self.import_db = ExcelImporter(path)

    def prepare_inventory(self):

        # Migrations for 3.6
        if self.version == 3.6:
            migrations = {
                'fields': ['name', 'reference product', 'location'],
                'data':
                [(('market for transport, freight, sea, transoceanic tanker', (
                    'transport, freight, sea, transoceanic tanker',
                ), 'GLO'), {
                    'name':
                    ('market for transport, freight, sea, tanker for liquid goods other than petroleum and liquefied natural gas'
                     ),
                    'reference product':
                    ('transport, freight, sea, tanker for liquid goods other than petroleum and liquefied natural gas'
                     ),
                }),
                 (('market for water, decarbonised, at user',
                   ('water, decarbonised, at user', ), 'GLO'), {
                       'name': ('market for water, decarbonised'),
                       'reference product': ('water, decarbonised'),
                       'location': ('DE'),
                   }),
                 (('market for water, completely softened, from decarbonised water, at user',
                   ('water, completely softened, from decarbonised water, at user',
                    ), 'GLO'), {
                        'name': ('market for water, completely softened'),
                        'reference product': ('water, completely softened'),
                        'location': ('RER'),
                    }),
                 (('market for concrete block', ('concrete block', ), 'GLO'), {
                     'location': ('DE'),
                 })]
            }

            Migration("biofuels_ecoinvent_36").write(
                migrations,
                description=
                "Change technosphere names due to change from 3.5 to 3.6")
            self.import_db.migrate("biofuels_ecoinvent_36")

        self.add_biosphere_links()
        self.add_product_field_to_exchanges()

Exemplo n.º 5

0

Exibir arquivo

Arquivo: generic_excel.py Projeto: pjamesjoyce/brightway2-io

def test_write_only_activity_parameters(no_init):
    assert not ActivityParameter.select().count()
    Database("PCB").register()
    obj = ExcelImporter()
    obj.db_name = "PCB"
    obj.data = deepcopy(DATA)
    obj.write_database()
    assert ActivityParameter.select().count() == 1
    assert ActivityParameter.get().amount != 7

    NEW = [{
        'code':
        '32aa5ab78beda5b8c8efbc89587de7a5',
        'database':
        'PCB',
        'parameters': [{
            'name': 'PCB_mass_total',
            'amount': 11,
            'formula': '7'
        }],
    }]
    obj.write_activity_parameters(NEW)
    assert ActivityParameter.select().count() == 1
    a = ActivityParameter.get()
    assert a.formula == '7'
    assert a.amount == 7

Exemplo n.º 6

0

Exibir arquivo

def test_example_notebook():
    ei = ExcelImporter(os.path.join(EXCEL_FIXTURES_DIR, "sample_activities_with_variables.xlsx"))
    ei.strategies = [
        csv_restore_tuples,
        csv_restore_booleans,
        csv_numerize,
        csv_drop_unknown,
        csv_add_missing_exchanges_section,
        normalize_units,
        set_code_by_activity_hash,
        assign_only_product_as_production,
        link_technosphere_by_activity_hash,
        drop_falsey_uncertainty_fields_but_keep_zeros,
        convert_uncertainty_types_to_integers,
        convert_activity_parameters_to_list,
    ]
    ei.apply_strategies()
    ei.match_database(fields=['name'])
    ei.write_database()

Exemplo n.º 7

0

Exibir arquivo

def test_excel_products_lca():
    ei = ExcelImporter(os.path.join(EXCEL_FIXTURES_DIR, "with_products.xlsx"))
    ei.strategies = [
        csv_restore_tuples,
        csv_restore_booleans,
        csv_numerize,
        csv_drop_unknown,
        csv_add_missing_exchanges_section,
        normalize_units,
        set_code_by_activity_hash,
        assign_only_product_as_production,
        link_technosphere_by_activity_hash,
        drop_falsey_uncertainty_fields_but_keep_zeros,
        convert_uncertainty_types_to_integers,
    ]
    print(ei.data)
    ei.apply_strategies()
    ei.match_database()
    ei.write_database()
    fu, data_objs, _ = prepare_lca_inputs({("Product example", "B"): 1})
    lca = LCA(fu, data_objs=data_objs)
    lca.lci()
    keys = {
        get_id(("Product example", "B")),
        get_id(("Product example", "C")),
        get_id(("Product example", "E")),
    }
    for key in lca.dicts.product:
        assert key in keys
    keys = {
        get_id(("Product example", "A")),
        get_id(("Product example", "C")),
        get_id(("Product example", "D")),
    }
    for key in lca.dicts.activity:
        assert key in keys
    for value in lca.supply_array:
        assert (np.allclose(value, 1) or np.allclose(value, 0.539)
                or np.allclose(value, 0.539 * 0.00805))

Exemplo n.º 8

0

Exibir arquivo

Arquivo: simple.py Projeto: pjamesjoyce/brightway2-io

def test_parameterized_import():
    ei = ExcelImporter(os.path.join(EXCEL_FIXTURES_DIR, "basic_example.xlsx"))
    ei.strategies = [
        csv_restore_tuples,
        csv_restore_booleans,
        csv_numerize,
        csv_drop_unknown,
        csv_add_missing_exchanges_section,
        normalize_units,
        set_code_by_activity_hash,
        assign_only_product_as_production,
        link_technosphere_by_activity_hash,
        drop_falsey_uncertainty_fields_but_keep_zeros,
        convert_uncertainty_types_to_integers,
    ]
    ei.apply_strategies()
    ei.match_database()
    assert ei.data == expected

Exemplo n.º 9

0

Exibir arquivo