def query_entsoe_load(start, end): client = EntsoePandasClient(api_key=os.environ['ENTSOE_TOKEN']) data = client.query_load("ES", start=pd.Timestamp(start, tz='UTC'), end=pd.Timestamp(end, tz='UTC')) return data
def query_entsoe_load(start, end): client = EntsoePandasClient( api_key='909addb7-e4ae-4702-acc7-6b4f4fd9667b') data = client.query_load("ES", start=pd.Timestamp(start, tz='UTC'), end=pd.Timestamp(end, tz='UTC')) return data
def get_entsoe_data(key, country='ES', date=None, period=None): start, end = get_date_range() client = EntsoePandasClient(api_key=key) data = client.query_load(country, start=start, end=end) return data
# ============================================================================= # Get Data from Entso-E # API Wrapper: https://github.com/EnergieID/entsoe-py # ============================================================================= #""" key = str(np.genfromtxt('entsoe.txt', dtype='str')) client = EntsoePandasClient(api_key=key) # Time Series # NoMatchingDataError # ts_day_ahead = client.query_day_ahead_prices(country_code, start=start,end=end) ts_load = client.query_load(country_code, start=start, end=end) ts_load.to_csv('data_base/ts_load.csv') ts_load_forecast = client.query_load_forecast(country_code, start=start, end=end) ts_load_forecast.to_csv('data_base/ts_load_forecast.csv') ts_generation_forecast = client.query_generation_forecast(country_code, start=start, end=end) ts_generation_forecast.to_csv('data_base/ts_generation_forecast.csv') # Dataframes df_wind_and_solar_forecast = client.query_wind_and_solar_forecast(
start, end = pd.Timestamp('20190101', tz='Europe/Brussels'), pd.Timestamp( '20190501', tz='Europe/Brussels') start2, end2 = pd.Timestamp('20200101', tz='Europe/Brussels'), pd.Timestamp( '20200501', tz='Europe/Brussels') for country_code in [ 'DE-LU', 'BE', 'DK', 'AT', 'BG', 'CH', 'CZ', 'EE', 'ES', 'FI', 'FR', 'GB', 'GR', 'HR', 'HU', 'IE', 'IT', 'NL', 'NO', 'PL', 'PT', 'RO', 'SE' ]: try: #download load data pd.concat([ client.query_load(country_code, start=start, end=end), client.query_load(country_code, start=start2, end=end2) ]).to_csv('./data/load_' + country_code + '.csv') #download generation data pd.concat([ client.query_generation(country_code, start=start, end=end, psr_type=None), client.query_generation(country_code, start=start2, end=end2, psr_type=None) ]).to_csv('./data/gen' + country_code + '.csv') except:
from entsoe import EntsoePandasClient import sqlite3 import pandas as pd from datetime import date, timedelta import time end_date = date.today() + timedelta(days=1) current_date = end_date.strftime("%Y%m%d") client = EntsoePandasClient(api_key='444fc771-5d0f-499f-9328-90c05c459219') start = pd.Timestamp('20201109', tz='Europe/Brussels') end = pd.Timestamp(current_date, tz='Europe/Brussels') country_code = 'DE' generation = client.query_load(country_code, start=start, end=end) generation1.to_csv('outfile1.csv') print(generation1) start = pd.Timestamp('20201109', tz='Europe/Brussels') end_date = date.today() + timedelta(days=2) current_date = end_date.strftime("%Y%m%d") end = pd.Timestamp(current_date, tz='Europe/Brussels') country_code = 'DE' generation2 = client.query_load_forecast(country_code, start=start, end=end) generation2.to_csv('outfile2.csv') print(generation2)