saio
In [ ]:
import saio
import getpass
import oedialect
import sqlalchemy as sa
from sqlalchemy.orm import sessionmaker

In [ ]:
user = input('Enter OEP-username:')
token = getpass.getpass('Token:')

In [ ]:
oep_url = 'openenergy-platform.org' #'193.175.187.164' #'oep.iks.cs.ovgu.de'
oed = f'postgresql+oedialect://{user}:{token}@{oep_url}'

In [ ]:
engine = sa.create_engine(oed)

In [ ]:
saio.register_schema("supply", engine)

In [ ]:
from saio.supply import wind_turbine_library as wind_turbine_library

In [ ]:
# the structure of the table in the local object wind_turbine_library
wind_turbine_library.__table__

In [ ]:
# using saio to download data into a pandas dataframe
Session = sessionmaker(bind=engine) # creates session class
session = Session() # instantiates a session
turbines = saio.as_pandas(session.query(wind_turbine_library))

In [ ]:
# the data of the table is now in the local pandas dataframe turbines
turbines


If you find bugs or if you have ideas to improve the Open Energy Platform, you are welcome to add your comments to the existing issues on GitHub.
You can also fork the project and get involved.

Please note that the platform is still under construction and therefore the design of this page is still highly volatile!