1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
| yearly_consumption = dict({})
| """
| {
| "2025": [
| [3.4, 4.6, 3.7, 2.5],
| [...]
| ],
| "2026": [],
| }
| """
| year = None
|
| def start_new_year(line: str) -> (bool,int|None):
| try:
| year_part = line.strip()[1:].strip()
| int(year_part)
| return (True, year_part)
| except :
| return (False, None)
|
| def convert_line_to_consumpt(line:str) -> [float]:
| line = line.replace(',', '.')
| line = line.split(';')
| values = []
| for txt in line:
| txt = txt.strip()
| values.append(float(txt))
| return values
|
| with open('./verbrauch-2025.csv') as f:
| for line in f.readlines():
| (is_new_year, year_nr) = start_new_year(line)
| print(is_new_year, year_nr)
| if is_new_year:
| year = [] # new list
| yearly_consumption[year_nr] = year
| continue
| year.append( convert_line_to_consumpt(line) )
|
| # debug
| print(yearly_consumption)
|
|
