Spaces:
Running
Running
| # -*- coding: utf-8 -*- | |
| """ | |
| Created on Fri Mar 3 12:57:17 2023 | |
| @author: BorowyP | |
| """ | |
| import pandas as pd | |
| import numpy as np | |
| import hvplot.pandas # Adds .hvplot and .interactive methods to Pandas dataframes | |
| import panel as pn # Panel is a simple, flexible and enterprise-ready data app framework | |
| import holoviews as hv | |
| from holoviews.operation.timeseries import rolling, rolling_outlier_std | |
| PALETTE = ["#ff6f69", "#ffcc5c", "#88d8b0", ] | |
| df_nied = pd.read_csv('Nied_holzdeko_csv.csv' , | |
| encoding_errors='ignore', | |
| sep=';', | |
| usecols=[1,2, 3, 4,5,6], | |
| decimal=',') | |
| def createStndrt(stnd_kennz, Stndrt,K_nK): | |
| df = df_nied.loc[df_nied['FNR + NWP'] == stnd_kennz].copy() | |
| df['Standort'] = Stndrt | |
| df['K_nK'] = K_nK | |
| df.index = pd.to_datetime(df_nied.loc[df_nied['FNR + NWP'] == '3NE']['MessDat'], dayfirst=True) | |
| if K_nK == 'K': | |
| df['K'] = df['Menge'] | |
| else: | |
| df['nK'] = df['Menge'] | |
| return df | |
| glienig_nied_K = createStndrt('3NE', 'Glienig','K') | |
| glienig_nied_nK = createStndrt('3NW', 'Glienig','nK') | |
| grlieb_nied_K = createStndrt('4SE', 'Groß Liebitz','K') | |
| grlieb_nied_nK= createStndrt('4NW', 'Groß Liebitz','nK') | |
| krausnick_nied_K = createStndrt('9NE', 'Krausnick','K') | |
| krausnick_nied_nK = createStndrt('9NW', 'Krausnick','nK') | |
| hberg_nied_K = createStndrt('10SE', 'Hangelsberg','K') | |
| hberg_nied_nK = createStndrt('10SW', 'Hangelsberg','nK') | |
| halbe_nied_K = createStndrt('12NE', 'Halbe','K') | |
| halbe_nied_nK = createStndrt('12NW', 'Halbe','nK') | |
| spreeau_nied_K = createStndrt('19NE', 'Spreeau','K') | |
| spreeau_nied_nK = createStndrt('19NW', 'Spreeau','nK') | |
| nied = pd.concat([glienig_nied_K,glienig_nied_nK, | |
| grlieb_nied_K, grlieb_nied_nK, | |
| krausnick_nied_K, krausnick_nied_nK, | |
| hberg_nied_K, hberg_nied_nK, | |
| halbe_nied_K, halbe_nied_nK, | |
| spreeau_nied_K, spreeau_nied_nK]) | |
| nied = nied.drop(nied.columns[[1]], axis=1) | |
| nied_inter = nied.interactive() | |
| yaxis = pn.widgets.ToggleGroup( | |
| name='Kalkung', | |
| options=['K','nK'], | |
| value=['K'], | |
| button_type='success') | |
| nied_date_slider = pn.widgets.DateRangeSlider(name='Date', start=nied.index.min(), end=nied.index.max()) | |
| Stndrt = pn.widgets.RadioButtonGroup(name='Standort', options=['Glienig', 'Groß Liebitz', 'Krausnick', 'Halbe', 'Spreeau', 'Hangelsberg'],button_type='success') | |
| nied_pipe = ( | |
| nied_inter[ | |
| (nied_inter.Standort == Stndrt ) & | |
| (nied_inter.K_nK.isin(yaxis)) & | |
| (nied_inter.index >= nied_date_slider.param.value_start) & | |
| (nied_inter.index <= nied_date_slider.param.value_end) | |
| ] | |
| .groupby(['MessDat'])[yaxis].mean() | |
| ) | |
| nied_lin_plot = nied_pipe.hvplot(x='MessDat', | |
| xlabel='Datum', | |
| y=yaxis, | |
| #y='Menge', | |
| ylabel= 'Niederschlag [mm]', | |
| title=Stndrt, | |
| #by='origin', | |
| color=PALETTE, | |
| line_width=2) | |
| nied_lin_plot | |
| summe = ( | |
| nied_inter[ | |
| (nied_inter.index >= nied_date_slider.param.value_start) & | |
| (nied_inter.index <= nied_date_slider.param.value_end)] | |
| .groupby(['Standort', 'K_nK']).sum() | |
| ) | |
| summe_plot = summe.hvplot(x='Standort', y=('Menge'), by='K_nK', kind='bar', | |
| title='Summe Niederschlag', xlabel='Standort', ylabel='Menge [mm]') | |
| hd_logo = pn.pane.PNG('HD_Logo.png', width=100) | |
| hd_logo | |
| lfe_logo = pn.pane.PNG('LFE_Logo.png', width=100) | |
| fnr_logo = pn.pane.PNG('fnr_logo.png', width=100) | |
| template = pn.template.FastListTemplate( | |
| title='Holzdeko Dashboard', | |
| sidebar=[hd_logo, | |
| pn.pane.Markdown("## Einstellungen"), | |
| 'Standort',Stndrt, | |
| 'gekalkt/ungekalkt', yaxis, | |
| lfe_logo, | |
| fnr_logo | |
| #'Boden', | |
| #'Gekalkt/ungekalkt', yaxis, | |
| ], | |
| main=[pn.pane.Markdown("## Niederschlag"), | |
| nied_date_slider, | |
| nied_lin_plot.panel(), | |
| summe_plot,#.panel() #NIEDERSCHLAG | |
| #accent_base_color="#88d8b0", | |
| #header_background="#88d8b0", | |
| ]) | |
| template.servable(); | |
| #print('fertig!') | |
| # To launch this dashboard as a web server, we can simply run | |
| # cd C:\Users\BorowyP\Desktop\Dashboard-Preasi\soil_air\ | |
| # panel serve 20230303_niederschlag_docker.ipynb --autoreload |