Braulio Barahona brauliobarahona
brauliobarahona
/ _get_swissgrid_data.py
Created
April 21, 2020 19:15
— forked from philshem/_get_swissgrid_data.py
get swiss energy consumption open data, combine with weather measurements https://twitter.com/philshem/status/1252535904918478850
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import os | |
| import pandas as pd | |
| from datetime import datetime | |
| url='https://www.swissgrid.ch/dam/dataimport/energy-statistic/EnergieUebersichtCH-{YEAR}.xls' | |
| dfs = [] | |
| for y in range(2009,datetime.now().year+1): | |
| # generate url with year in it | |
| url_y = url.format(YEAR=str(y)) |