Skip to content

Instantly share code, notes, and snippets.

@boltbeard
boltbeard / Keybase.md
Created January 30, 2020 00:29
Keybase Proof Boltbeard

Keybase proof

I hereby claim:

  • I am boltbeard on github.
  • I am boltbeard (https://keybase.io/boltbeard) on keybase.
  • I have a public key ASBynFQbVCrh5tEqMn3xcpPHyJn2tMzWjh3X-EqDuCgmSwo

To claim this, I am signing this object:

@boltbeard
boltbeard / routing_test_build.ipynb
Created March 25, 2019 11:23
Ding0 Testing Prototypes
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@boltbeard
boltbeard / eDisGo_issue-43-profiling_results_part1.ipynb
Created February 23, 2018 13:49
Profiling Results for eDisGo issue 43
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@boltbeard
boltbeard / grid_id_counts.sql
Last active March 20, 2018 16:33
various_grid_id_counts_why?
-- Overall question: how to get the feedin time series of all technologies (wind, solar, biomass) along with their weather cell_id given mv_grid_id?
-- to find the number of DISTINCT "mv_grid_id" in model_draft.ego_grid_mv_griddistrict
SELECT DISTINCT COUNT(subst_id)
FROM model_draft.ego_grid_mv_griddistrict;
-- Result 1 = 3608
-- Question 1 : Base data (assuming this is the fundamental start point), Base numbering ranges from 1 to 3608
-- to find the number of DISTINCT "generator_id" model_draft.ego_grid_pf_hv_generator in scenario "Status Quo"
SELECT COUNT(DISTINCT generator_id)
@boltbeard
boltbeard / speed_test_eDisGo.py
Created December 15, 2017 13:51
code for testing overall speed of the importing of ding0 data
from edisgo.grid.network import Network, Scenario, TimeSeries
import cProfile
# Define a scenario including a TimeSeries instance
scenario = Scenario(power_flow='worst-case',
timeseries=TimeSeries())
# Get the grid topology data
cProfile.run("network = Network.import_from_ding0(\"ding0_grids__178.pkl\", id='178', scenario=scenario)")
@boltbeard
boltbeard / speed_test_nodes_by_attribute.ipynb
Last active December 15, 2017 13:05
Speed Tests on various implementations of the function nodes_by_attribute()
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.