1
|
|
|
"""Create a basic scenario from the internal data structure. |
2
|
|
|
|
3
|
|
|
SPDX-FileCopyrightText: 2016-2019 Uwe Krien <[email protected]> |
4
|
|
|
|
5
|
|
|
SPDX-License-Identifier: MIT |
6
|
|
|
""" |
7
|
|
|
|
8
|
|
|
import pandas as pd |
9
|
|
|
from reegis import mobility |
10
|
|
|
|
11
|
|
|
from scenario_builder import config as cfg |
12
|
|
|
|
13
|
|
|
|
14
|
|
|
def scenario_mobility(year, table): |
15
|
|
|
""" |
16
|
|
|
|
17
|
|
|
Parameters |
18
|
|
|
---------- |
19
|
|
|
year |
20
|
|
|
table |
21
|
|
|
|
22
|
|
|
Returns |
23
|
|
|
------- |
24
|
|
|
|
25
|
|
|
Examples |
26
|
|
|
-------- |
27
|
|
|
>>> my_table = scenario_mobility(2015, {}) |
28
|
|
|
>>> my_table["mobility_mileage"]["DE"].sum() |
29
|
|
|
diesel 3.769021e+11 |
30
|
|
|
petrol 3.272263e+11 |
31
|
|
|
other 1.334462e+10 |
32
|
|
|
dtype: float64 |
33
|
|
|
>>> my_table["mobility_spec_demand"]["DE"].loc["passenger car"] |
34
|
|
|
diesel 0.067 |
35
|
|
|
petrol 0.079 |
36
|
|
|
other 0.000 |
37
|
|
|
Name: passenger car, dtype: float64 |
38
|
|
|
>>> my_table["mobility_energy_content"]["DE"]["diesel"] |
39
|
|
|
energy_per_liter [MJ/l] 34.7 |
40
|
|
|
Name: diesel, dtype: float64 |
41
|
|
|
""" |
42
|
|
|
|
43
|
|
|
table["mobility_mileage"] = mobility.get_mileage_by_type_and_fuel(year) |
44
|
|
|
|
45
|
|
|
# fetch table of specific demand by fuel and vehicle type (from 2011) |
46
|
|
|
table["mobility_spec_demand"] = ( |
47
|
|
|
pd.DataFrame( |
48
|
|
|
cfg.get_dict_list("fuel consumption"), |
49
|
|
|
index=["diesel", "petrol", "other"], |
50
|
|
|
) |
51
|
|
|
.astype(float) |
52
|
|
|
.transpose() |
53
|
|
|
) |
54
|
|
|
|
55
|
|
|
# fetch the energy content of the different fuel types |
56
|
|
|
table["mobility_energy_content"] = pd.DataFrame( |
57
|
|
|
cfg.get_dict("energy_per_liter"), index=["energy_per_liter [MJ/l]"] |
58
|
|
|
)[["diesel", "petrol", "other"]] |
59
|
|
|
|
60
|
|
|
for key in [ |
61
|
|
|
"mobility_mileage", |
62
|
|
|
"mobility_spec_demand", |
63
|
|
|
"mobility_energy_content", |
64
|
|
|
]: |
65
|
|
|
# Add "DE" as region level to be consistent to other tables |
66
|
|
|
table[key].columns = pd.MultiIndex.from_product( |
67
|
|
|
[["DE"], table[key].columns] |
68
|
|
|
) |
69
|
|
|
return table |
70
|
|
|
|