Code Duplication    Length = 63-66 lines in 2 locations

src/egon/data/datasets/power_plants/__init__.py 1 location

@@ 569-634 (lines=66) @@
566
    return mastr_loc.voltage_level
567
568
569
def assign_bus_id(power_plants, cfg, drop_missing=False):
570
    """Assigns bus_ids to power plants according to location and voltage level
571
572
    Parameters
573
    ----------
574
    power_plants : pandas.DataFrame
575
        Power plants including voltage level
576
577
    Returns
578
    -------
579
    power_plants : pandas.DataFrame
580
        Power plants including voltage level and bus_id
581
582
    """
583
584
    mv_grid_districts = db.select_geodataframe(
585
        f"""
586
        SELECT * FROM {cfg['sources']['egon_mv_grid_district']}
587
        """,
588
        epsg=4326,
589
    )
590
591
    ehv_grid_districts = db.select_geodataframe(
592
        f"""
593
        SELECT * FROM {cfg['sources']['ehv_voronoi']}
594
        """,
595
        epsg=4326,
596
    )
597
598
    # Assign power plants in hv and below to hvmv bus
599
    power_plants_hv = power_plants[power_plants.voltage_level >= 3].index
600
    if len(power_plants_hv) > 0:
601
        power_plants.loc[power_plants_hv, "bus_id"] = gpd.sjoin(
602
            power_plants[power_plants.index.isin(power_plants_hv)],
603
            mv_grid_districts,
604
        ).bus_id
605
606
    # Assign power plants in ehv to ehv bus
607
    power_plants_ehv = power_plants[power_plants.voltage_level < 3].index
608
609
    if len(power_plants_ehv) > 0:
610
        ehv_join = gpd.sjoin(
611
            power_plants[power_plants.index.isin(power_plants_ehv)],
612
            ehv_grid_districts,
613
        )
614
615
        if "bus_id_right" in ehv_join.columns:
616
            power_plants.loc[power_plants_ehv, "bus_id"] = gpd.sjoin(
617
                power_plants[power_plants.index.isin(power_plants_ehv)],
618
                ehv_grid_districts,
619
            ).bus_id_right
620
621
        else:
622
            power_plants.loc[power_plants_ehv, "bus_id"] = gpd.sjoin(
623
                power_plants[power_plants.index.isin(power_plants_ehv)],
624
                ehv_grid_districts,
625
            ).bus_id
626
627
    if drop_missing:
628
        power_plants = power_plants[~power_plants.bus_id.isnull()]
629
630
    # Assert that all power plants have a bus_id
631
    assert power_plants.bus_id.notnull().all(), f"""Some power plants are
632
    not attached to a bus: {power_plants[power_plants.bus_id.isnull()]}"""
633
634
    return power_plants
635
636
637
def insert_hydro_biomass():

src/egon/data/datasets/power_plants/assign_weather_data.py 1 location

@@ 7-69 (lines=63) @@
4
from egon.data.datasets.power_plants.pv_rooftop_buildings import timer_func
5
6
7
def assign_bus_id(power_plants, cfg):
8
    """Assigns bus_ids to power plants according to location and voltage level
9
10
    Parameters
11
    ----------
12
    power_plants : pandas.DataFrame
13
        Power plants including voltage level
14
15
    Returns
16
    -------
17
    power_plants : pandas.DataFrame
18
        Power plants including voltage level and bus_id
19
20
    """
21
22
    mv_grid_districts = db.select_geodataframe(
23
        f"""
24
        SELECT * FROM {cfg['sources']['egon_mv_grid_district']}
25
        """,
26
        epsg=4326,
27
    )
28
29
    ehv_grid_districts = db.select_geodataframe(
30
        f"""
31
        SELECT * FROM {cfg['sources']['ehv_voronoi']}
32
        """,
33
        epsg=4326,
34
    )
35
36
    # Assign power plants in hv and below to hvmv bus
37
    power_plants_hv = power_plants[power_plants.voltage_level >= 3].index
38
    if len(power_plants_hv) > 0:
39
        power_plants.loc[power_plants_hv, "bus_id"] = gpd.sjoin(
40
            power_plants[power_plants.index.isin(power_plants_hv)],
41
            mv_grid_districts,
42
        ).bus_id
43
44
    # Assign power plants in ehv to ehv bus
45
    power_plants_ehv = power_plants[power_plants.voltage_level < 3].index
46
47
    if len(power_plants_ehv) > 0:
48
        ehv_join = gpd.sjoin(
49
            power_plants[power_plants.index.isin(power_plants_ehv)],
50
            ehv_grid_districts,
51
        )
52
53
        if "bus_id_right" in ehv_join.columns:
54
            power_plants.loc[power_plants_ehv, "bus_id"] = gpd.sjoin(
55
                power_plants[power_plants.index.isin(power_plants_ehv)],
56
                ehv_grid_districts,
57
            ).bus_id_right
58
59
        else:
60
            power_plants.loc[power_plants_ehv, "bus_id"] = gpd.sjoin(
61
                power_plants[power_plants.index.isin(power_plants_ehv)],
62
                ehv_grid_districts,
63
            ).bus_id
64
65
    # Assert that all power plants have a bus_id
66
    assert power_plants.bus_id.notnull().all(), f"""Some power plants are
67
    not attached to a bus: {power_plants[power_plants.bus_id.isnull()]}"""
68
69
    return power_plants
70
71
72
@timer_func