# ---
# jupyter:
#   jupytext:
#     text_representation:
#       extension: .py
#       format_name: light
#       format_version: '1.5'
#       jupytext_version: 1.14.4
#   kernelspec:
#     display_name: hello_spinetoolbox
#     language: python
#     name: hello
# ---

# +
import pandas as pd
import sys
import numpy as np
import  matplotlib.pyplot as plt

Plants = pd.read_excel(sys.path[0] +"/../data/powerplantsGermany/Kraftwerksliste_2020_1.xlsx",
                           sheet_name="Gesamtkraftwerksliste BNetzA",
                           usecols="A:X",
                           skiprows = "1:10"
                           #index_col="Kraftwerksnummer Bundesnetzagentur"# , parse_dates="Commisionedyear"
                           )
# -

# print(Plants.Technology.unique())
# print(Plants.fuel.unique())

# + pycharm={"name": "#%%\n"}
print(Plants.head())

# -

x = range(2128)
plt.scatter(x,Plants["Commisionedyear"])





table = Plants[Plants["Status"]=="in Betrieb"].groupby(['Fuel', 'Commisionedyear'])

print(table)



StarcoderdataJupyterScriptsDedupFiltered