visuelle_Kontrolle
Bibliotheken importieren
# Name des aktuellen Notebooks für die exportierten Datein
file_name = "visuelle_Kontrolle"
# Ordner auf dem Server (nach files/)
ftp_folder = 'Notebooks/Aufbereitung'
## Bibliotheken, Module und Text- bzw- Grafikformatierungen aus zentraler Datei laden
%run ../Template/libraries_and_styles.ipynb
## Warum auch immer muss rcParams.update() in eine eigene Zelle...
mpl.use('WebAgg')
mpl.use("pgf")
mpl.rcParams.update(params)
Daten Import
daten = pd.read_csv('Arbeitsdaten/Daten_15s.csv') ## dauert bei 15s ne Stunde!
daten.set_index(['Zeit'], inplace=True)
daten.index = pd.to_datetime(daten.index)
Nullwerte löschen
## Nullwerte löschen
## Damit die Histogramme sinnvoll skalieren werden bei den Datensätzen, die viele Werte = 0 haben, diese gelöscht
daten['S_Solar_Vpunkt'][daten['S_Solar_Vpunkt']<1] = np.nan
daten['S_Solar_Pumpe_PWM'][daten['S_Solar_Pumpe_PWM']<1] = np.nan
daten['S_Solarstrahlung'][daten['S_Solarstrahlung']<1] = np.nan
daten['S_Heizung_Vpunkt'][daten['S_Heizung_Vpunkt']<1] = np.nan
daten['S_Kessel_Vpunkt'][daten['S_Kessel_Vpunkt']<1] = np.nan
daten['S_FriWa_RL_Prim'][daten['S_FriWa_RL_Prim']<1] = np.nan
daten['S_FriWa_Vpunkt_Prim'][daten['S_FriWa_Vpunkt_Prim']<1] = np.nan
daten['S_FriWa_VL_Prim'][daten['S_FriWa_VL_Prim']<1] = np.nan
daten['S_Gas_Vpunkt'][daten['S_Gas_Vpunkt']<1] = np.nan
daten['S_FriWa_Pumpe_PWM_Sek'][daten['S_FriWa_Pumpe_PWM_Sek']<1] = np.nan
daten['S_Kessel_Heizung_Vpunkt'][daten['S_Kessel_Heizung_Vpunkt']<1] = np.nan
daten['S_Kessel_Speicher_Vpunkt'][daten['S_Kessel_Speicher_Vpunkt']<1] = np.nan
daten['W_Globalstrahlung'][daten['W_Globalstrahlung']<10] = np.nan
Alle Messpunkte als Liniendia- und Histogramm plotten
von = pd.to_datetime("2017-05-01 00:00:00",infer_datetime_format=True)
bis = pd.to_datetime("2018-04-30 23:00:00",infer_datetime_format=True)
for column in daten:
name = column.replace('L_','').replace('S_','').replace('W_','').replace('_',' ')
print_md('### ' + name)
fig, ax = plt.subplots(nrows=2, ncols=1)
## Liniendiagramm
daten[column].plot(ax=ax[0],linewidth=0.5,color=colo('blau',1))
ax[0].set_title(name)
ax[0].set_xlabel('')
ax[0].set_xlim(von, bis)
ax[0].xaxis.set_major_formatter(mdates.DateFormatter('%b'))
plt.setp(ax[0].get_xticklabels(), rotation=0, horizontalalignment='left')
## Histogramm
daten[column].plot.hist(bins=600, density=True, color=colo('rot',1), ax=ax[1])
ax[1].set_ylabel('')
display(fig)
plt.close('all')
print_md('<br><br>')
Aussenlufttemperatur 1
Aussenlufttemperatur 2
Aussentemperatur ged
Zulufttemperatur
Ablufttemperatur
Fortlufttemperatur
Duschen Ablufttfeuchte
Duschen Ablufttemperatur
Zuluft 1 VPunkt
Zuluft 2 VPunkt
Zuluft 3 VPunkt
Zuluft Druck
Abluft Druck
Seminarraum 1 CO2
Seminarraum 2 CO2
Nacherhitzer VL
Nacherhitzer RL
Solarstrahlung
Kollektortemperatur
Dachbodentemperatur
Speicher 1
---------------------------------------------------------------------------
RuntimeError Traceback (most recent call last)
c:\users\kolja\appdata\local\programs\python\python37\lib\site-packages\IPython\core\formatters.py in __call__(self, obj)
339 pass
340 else:
--> 341 return printer(obj)
342 # Finally look for special method names
343 method = get_real_method(obj, self.print_method)
c:\users\kolja\appdata\local\programs\python\python37\lib\site-packages\IPython\core\pylabtools.py in <lambda>(fig)
242
243 if 'png' in formats:
--> 244 png_formatter.for_type(Figure, lambda fig: print_figure(fig, 'png', **kwargs))
245 if 'retina' in formats or 'png2x' in formats:
246 png_formatter.for_type(Figure, lambda fig: retina_figure(fig, **kwargs))
c:\users\kolja\appdata\local\programs\python\python37\lib\site-packages\IPython\core\pylabtools.py in print_figure(fig, fmt, bbox_inches, **kwargs)
126
127 bytes_io = BytesIO()
--> 128 fig.canvas.print_figure(bytes_io, **kw)
129 data = bytes_io.getvalue()
130 if fmt == 'svg':
c:\users\kolja\appdata\local\programs\python\python37\lib\site-packages\matplotlib\backend_bases.py in print_figure(self, filename, dpi, facecolor, edgecolor, orientation, format, bbox_inches, **kwargs)
2124 orientation=orientation,
2125 bbox_inches_restore=_bbox_inches_restore,
-> 2126 **kwargs)
2127 finally:
2128 if bbox_inches and restore_bbox:
c:\users\kolja\appdata\local\programs\python\python37\lib\site-packages\matplotlib\backends\backend_pgf.py in print_png(self, fname_or_fh, *args, **kwargs)
966 return
967 with cbook.open_file_cm(fname_or_fh, "wb") as file:
--> 968 self._print_png_to_fh(file, *args, **kwargs)
969
970 def get_renderer(self):
c:\users\kolja\appdata\local\programs\python\python37\lib\site-packages\matplotlib\backends\backend_pgf.py in _print_png_to_fh(self, fh, *args, **kwargs)
949 fname_png = os.path.join(tmpdir, "figure.png")
950 # create pdf and try to convert it to png
--> 951 self.print_pdf(fname_pdf, *args, **kwargs)
952 converter(fname_pdf, fname_png, dpi=self.figure.dpi)
953 # copy file contents to target
c:\users\kolja\appdata\local\programs\python\python37\lib\site-packages\matplotlib\backends\backend_pgf.py in print_pdf(self, fname_or_fh, *args, **kwargs)
938 return
939 with cbook.open_file_cm(fname_or_fh, "wb") as file:
--> 940 self._print_pdf_to_fh(file, *args, **kwargs)
941
942 def _print_png_to_fh(self, fh, *args, **kwargs):
c:\users\kolja\appdata\local\programs\python\python37\lib\site-packages\matplotlib\backends\backend_pgf.py in _print_pdf_to_fh(self, fh, *args, **kwargs)
921 cbook._check_and_log_subprocess(
922 [texcommand, "-interaction=nonstopmode", "-halt-on-error",
--> 923 "figure.tex"], _log, cwd=tmpdir)
924
925 # copy file contents to target
c:\users\kolja\appdata\local\programs\python\python37\lib\site-packages\matplotlib\cbook\__init__.py in _check_and_log_subprocess(command, logger, **kwargs)
2078 if proc.returncode:
2079 raise RuntimeError(
-> 2080 f"The command\n"
2081 f" {_pformat_subprocess(command)}\n"
2082 f"failed and generated the following output:\n"
RuntimeError: The command
xelatex -interaction=nonstopmode -halt-on-error figure.tex
failed and generated the following output:
This is XeTeX, Version 3.14159265-2.6-0.999992 (MiKTeX 2.9.7400 64-bit)
entering extended mode
(figure.tex
LaTeX2e <2020-02-02> patch level 5
L3 programming layer <2020-04-06>
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/base\minimal.cls"
Document Class: minimal 2001/05/25 Standard LaTeX minimal class
)
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/geometry\geometry.
sty"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/graphics\keyval.st
y")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/iftex\ifvtex.sty
" ("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/iftex\iftex.st
y"))
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/xelatex/xetexconfig\geom
etry.cfg"))
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/fontspec\fontspec.
sty"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/l3packages/xparse\
xparse.sty"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/l3kernel\expl3.sty
"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/l3backend\l3backen
d-xdvipdfmx.def")))
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/fontspec\fontspec-
xetex.sty"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/base\fontenc.sty")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/fontspec\fontspec.
cfg")))
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/underscore\undersc
ore.sty")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/amsmath\amsmath.st
y"
For additional information on amsmath, use the `?' option.
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/amsmath\amstext.st
y"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/amsmath\amsgen.sty
"))
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/amsmath\amsbsy.sty
")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/amsmath\amsopn.sty
"))
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/pgf/basiclayer\pgf
.sty"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/pgf/utilities\pgfr
cs.sty"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/utilities\pg
futil-common.tex"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/utilities\pg
futil-common-lists.tex"))
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/utilities\pg
futil-latex.def"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/ms\everyshi.sty"))
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/utilities\pg
frcs.code.tex"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf\pgf.revision
.tex")))
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/pgf/basiclayer\pgf
core.sty"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/graphics\graphicx.
sty"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/graphics\graphics.
sty"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/graphics\trig.sty"
)
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/graphics-cfg\graph
ics.cfg")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/graphics-def\xetex
.def")))
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/pgf/systemlayer\pg
fsys.sty"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/systemlayer\
pgfsys.code.tex"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/utilities\pg
fkeys.code.tex"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/utilities\pg
fkeysfiltered.code.tex"))
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/systemlayer\
pgf.cfg")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/systemlayer\
pgfsys-xetex.def"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/systemlayer\
pgfsys-dvipdfmx.def"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/systemlayer\
pgfsys-common-pdf.def"))))
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/systemlayer\
pgfsyssoftpath.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/systemlayer\
pgfsysprotocol.code.tex"))
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/xcolor\xcolor.sty"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/graphics-cfg\color
.cfg"))
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/basiclayer\p
gfcore.code.tex"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/math\pgfmath
.code.tex"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/math\pgfmath
calc.code.tex"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/math\pgfmath
util.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/math\pgfmath
parser.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/math\pgfmath
functions.code.tex"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/math\pgfmath
functions.basic.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/math\pgfmath
functions.trigonometric.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/math\pgfmath
functions.random.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/math\pgfmath
functions.comparison.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/math\pgfmath
functions.base.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/math\pgfmath
functions.round.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/math\pgfmath
functions.misc.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/math\pgfmath
functions.integerarithmetics.code.tex")))
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/math\pgfmath
float.code.tex"))
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/math\pgfint.
code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/basiclayer\p
gfcorepoints.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/basiclayer\p
gfcorepathconstruct.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/basiclayer\p
gfcorepathusage.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/basiclayer\p
gfcorescopes.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/basiclayer\p
gfcoregraphicstate.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/basiclayer\p
gfcoretransformations.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/basiclayer\p
gfcorequick.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/basiclayer\p
gfcoreobjects.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/basiclayer\p
gfcorepathprocessing.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/basiclayer\p
gfcorearrows.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/basiclayer\p
gfcoreshade.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/basiclayer\p
gfcoreimage.code.tex"
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/basiclayer\p
gfcoreexternal.code.tex"))
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/basiclayer\p
gfcorelayers.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/basiclayer\p
gfcoretransparency.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/basiclayer\p
gfcorepatterns.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/basiclayer\p
gfcorerdf.code.tex")))
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/modules\pgfm
oduleshapes.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/generic/pgf/modules\pgfm
oduleplot.code.tex")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/pgf/compatibility\
pgfcomp-version-0-65.sty")
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/pgf/compatibility\
pgfcomp-version-1-18.sty"))
No file figure.aux.
("C:\Users\Kolja\AppData\Local\Programs\MiKTeX 2.9\tex/latex/base\ts1cmr.fd")
*geometry* detected driver: pdftex
ABD: EveryShipout initializing macros (figure.pgf
! TeX capacity exceeded, sorry [main memory size=3000000].
\pgfsys@invoke #1->\special
{pdf:code #1}
l.29116 \pgfusepath{fill}
%
No pages of output.
Transcript written on figure.log.
and the following error:
<Figure size 1180x600 with 2 Axes>
Speicher 2
Speicher 3
Speicher 4
Speicher 5
Solar VL
Solar RL
Solar Vpunkt
Heizung VL
Heizung RL
Heizung Vpunkt
Kessel VL
Kessel RL
Kessel Vpunkt
FriWa VSek
FriWa RSek
FriWa Vpunkt Sek
FriWa VPrim
FriWa RPrim
FriWa Vpunkt Prim
Gas Vpunkt
Solar Pumpe PWM
FriWa Pumpe PWM Sek
Speicher Ventil
Kessel Ventil
Temperatur
Luftfeuchtigkeit
Globalstrahlung
Windgeschwindigkeit
Windrichtung
Luftdruck
Kessel Heizung Vpunkt
Kessel Speicher Vpunkt
Speicher UA
Save & Upload
## Skriptlaufzeit Ende (Funktion in: libraries_and_styles.ipynb)
hours, minutes, seconds = laufzeit()
## Notebook speichern vor dem Upload (Funktion in: libraries_and_styles.ipynb)
save_notebook()
## Notebook als Markdown Datei mit eingebetten Grafiken speichern und auf den Server laden
%run ../Template/save_and_upload.ipynb
Dachbodentemperatur Kontrolle_Trubel_WRG
