Skip to content

Instantly share code, notes, and snippets.

View nesnoj's full-sized avatar

nesnoj

15 followers · 11 following
View GitHub Profile
@nesnoj
nesnoj / ego_dp_powerflow_create_pp_mview.sql
Created October 31, 2017 14:56
supply MVIEWs for dp pre-release v0.3.0pre1
/*
SQL Script to create mviews displaying power plants by scenario.
__copyright__ = "Europa-Universität Flensburg - ZNES"
__license__ = "GNU Affero General Public License Version 3 (AGPL-3.0)"
__url__ = "https://github.com/openego/data_processing/blob/master/LICENSE"
__author__ = "wolfbunke"
*/
@nesnoj
nesnoj / eDisGo grid extension.ipynb
Last active November 1, 2017 17:39 — forked from gplssm/eDisGo grid extension.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@nesnoj
nesnoj / ding0_grids__1010.pkl
Last active June 14, 2018 10:34
This file has been truncated, but you can view the full file.
View raw
@nesnoj
nesnoj / 2017_12_Veroeff_RegDaten.xlsx
Last active August 13, 2018 09:00
BNetzA data 12/2017
This file has been truncated, but you can view the full file.
View raw
@nesnoj
nesnoj / README.md
Last active November 5, 2018 15:01
Jupyter Notebook aus der DINGO-Session auf des open_eGo-Abschlussworkshops vom 30.10.18
@nesnoj
nesnoj / feedin_test.py
Last active February 7, 2019 16:18
Test max. turbine output of windpowerlib
import pandas as pd
from windpowerlib import ModelChain
from windpowerlib.wind_turbine import WindTurbine
weather_df = pd.read_csv('weather.csv', index_col=0, header=[0, 1])
# change type of index to datetime and set time zone
weather_df.index = pd.to_datetime(weather_df.index).tz_localize(
'UTC').tz_convert('Europe/Berlin')
# change type of height from str to int by resetting columns
weather_df.columns = [weather_df.axes[1].levels[0][
@nesnoj
nesnoj / powerplants2db.py
Created April 11, 2019 18:01
Write reegis powerplant data to db
import pandas as pd
import geopandas as gpd
from geoalchemy2 import Geometry, WKTElement
from shapely import wkt
from sqlalchemy import create_engine
from sqlalchemy.types import BIGINT
import getpass
import logging
filename = 'reegis_pp_ABW.h5'
@nesnoj
nesnoj / ashp_test_system.ipynb
Last active February 28, 2020 12:35
Testing COPs of ASHP and GSHP using oemof thermal
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@nesnoj
nesnoj / line_invest_min_example.py
Created June 14, 2020 08:11
Minimal example for line invest, based upon example from oemof-examples
# original example: https://github.com/oemof/oemof-examples/blob/master/oemof_examples/oemof.solph/v0.3.x/electrical/transshipment.py
import pandas as pd
# solph imports
from oemof.solph import (EnergySystem, Model, Bus, Flow, Source, Sink,
custom, Investment)
from oemof.outputlib import processing, views
from oemof.graph import create_nx_graph
@nesnoj
nesnoj / meta_stemp_abw.json
Created January 11, 2021 11:52
StEmp ABW Sources Metadata
{"id":25,"meta_data":{"name": "", "title": "Zeitreihen elektrisch Haushalte, GHD und Landwirtschaft", "review": {"path": "none", "badge": "none"}, "context": {"contact": "https://github.com/nesnoj", "grantNo": "03SFK4E1", "homepage": "https://reiner-lemoine-institut.de/kopernikus-projekt-enavi/", "sourceCode": "https://github.com/rl-institut/WAM_APP_stemp_abw", "documentation": "https://github.com/rl-institut/WAM_APP_stemp_abw"}, "sources": [{"path": "https://openenergy-platform.org/dataedit/view/demand/ego_dp_loadarea", "title": " eGo dataprocessing - Loadarea", "license": "Open Data Commons Open Database License 1.0 (ODbL-1.0) ", "copyright": "© Reiner Lemoine Institut", "description": "Below is the data that is contained in the table you selected. Only a limited amout of data is fetched at one time. You can browse different chuncks of data using the data view interface."}, {"path": "https://www.uni-flensburg.de/fileadmin/content/abteilungen/industrial/dokumente/downloads/veroeffentlichungen/forschungsergeb