Integrate hh demand curves in function 'demands_per_bus'

[IlkaCu]

As soon as the household demand curves are available (PR #260) the data need to be included here:

eGon-data/src/egon/data/datasets/electricity_demand_etrago.py

Lines 13 to 83 in 7de1a83

	def demands_per_bus(scenario):
	"""Sum all electricity demand curves up per bus
	Parameters
	----------
	scenario : str
	Scenario name.
	Returns
	-------
	pandas.DataFrame
	Aggregated electrical demand timeseries per bus
	"""
	# Read information from configuration file
	sources = egon.data.config.datasets()["etrago_electricity"]["sources"]
	# Select data on CTS electricity demands per bus
	cts_curves = db.select_dataframe(
	f"""SELECT subst_id, p_set FROM
	{sources['cts_curves']['schema']}.
	{sources['cts_curves']['table']}
	WHERE scn_name = '{scenario}'""",
	index_col="subst_id",
	)
	# Rename index
	cts_curves.index.rename("bus", inplace=True)
	# Select data on industrial demands assigned to osm landuse areas
	ind_curves_osm = db.select_dataframe(
	f"""SELECT bus, p_set FROM
	{sources['osm_curves']['schema']}.
	{sources['osm_curves']['table']}
	WHERE scn_name = '{scenario}'""",
	index_col="bus",
	)
	# Select data on industrial demands assigned to industrial sites
	ind_curves_sites = db.select_dataframe(
	f"""SELECT bus, p_set FROM
	{sources['sites_curves']['schema']}.
	{sources['sites_curves']['table']}
	WHERE scn_name = '{scenario}'""",
	index_col="bus",
	)
	# Create one df by appending all imported dataframes
	demand_curves = cts_curves.append([ind_curves_osm, ind_curves_sites])
	# Split array to single columns in the dataframe
	demand_curves_split = demand_curves
	demand_curves_split = pd.DataFrame(
	demand_curves.p_set.tolist(), index=demand_curves_split.index
	)
	# Group all rows with the same bus
	demand_curves_bus = demand_curves_split.groupby(
	demand_curves_split.index
	).sum()
	# Initzialize and fill resulsting dataframe
	curves = pd.DataFrame(columns=["bus", "p_set"])
	curves["bus"] = demand_curves_bus.index
	curves["p_set"] = demand_curves_bus.values.tolist()
	return curves