main/stage-0/colab/netcdf-flattening.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "netcdf-flattening.ipynb",
      "version": "0.3.2",
      "provenance": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/edenau/Machine-Learning-Climate-Parameterization/blob/master/work/NN/colab/netcdf-flattening.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "metadata": {
        "id": "f5F9OJ5ehj-R",
        "colab_type": "code",
        "outputId": "fe6fd7f3-8c69-4f8a-bb68-a85cc4f8e489",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 5848
        }
      },
      "cell_type": "code",
      "source": [
        "# Install xarray using conda\n",
        "#!pip install xarray\n",
        "#!pip install netcdf4\n",
        "!wget -c https://repo.continuum.io/archive/Anaconda3-5.1.0-Linux-x86_64.sh\n",
        "!chmod +x Anaconda3-5.1.0-Linux-x86_64.sh\n",
        "!bash ./Anaconda3-5.1.0-Linux-x86_64.sh -b -f -p /usr/local\n",
        "!conda install -q -y --prefix /usr/local -c conda-forge xarray dask netCDF4 bottleneck\n",
        "\n",
        "import sys\n",
        "sys.path.append('/usr/local/lib/python3.6/site-packages/')"
      ],
      "execution_count": 1,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "--2019-01-20 15:50:38--  https://repo.continuum.io/archive/Anaconda3-5.1.0-Linux-x86_64.sh\n",
            "Resolving repo.continuum.io (repo.continuum.io)... 104.16.19.10, 104.16.18.10, 2606:4700::6810:130a, ...\n",
            "Connecting to repo.continuum.io (repo.continuum.io)|104.16.19.10|:443... connected.\n",
            "HTTP request sent, awaiting response... 200 OK\n",
            "Length: 577996269 (551M) [application/x-sh]\n",
            "Saving to: ‘Anaconda3-5.1.0-Linux-x86_64.sh’\n",
            "\n",
            "Anaconda3-5.1.0-Lin 100%[===================>] 551.22M   101MB/s    in 5.0s    \n",
            "\n",
            "2019-01-20 15:50:43 (111 MB/s) - ‘Anaconda3-5.1.0-Linux-x86_64.sh’ saved [577996269/577996269]\n",
            "\n",
            "PREFIX=/usr/local\n",
            "installing: python-3.6.4-hc3d631a_1 ...\n",
            "Python 3.6.4 :: Anaconda, Inc.\n",
            "installing: ca-certificates-2017.08.26-h1d4fec5_0 ...\n",
            "installing: conda-env-2.6.0-h36134e3_1 ...\n",
            "installing: intel-openmp-2018.0.0-hc7b2577_8 ...\n",
            "installing: libgcc-ng-7.2.0-h7cc24e2_2 ...\n",
            "installing: libgfortran-ng-7.2.0-h9f7466a_2 ...\n",
            "installing: libstdcxx-ng-7.2.0-h7a57d05_2 ...\n",
            "installing: bzip2-1.0.6-h9a117a8_4 ...\n",
            "installing: expat-2.2.5-he0dffb1_0 ...\n",
            "installing: gmp-6.1.2-h6c8ec71_1 ...\n",
            "installing: graphite2-1.3.10-hf63cedd_1 ...\n",
            "installing: icu-58.2-h9c2bf20_1 ...\n",
            "installing: jbig-2.1-hdba287a_0 ...\n",
            "installing: jpeg-9b-h024ee3a_2 ...\n",
            "installing: libffi-3.2.1-hd88cf55_4 ...\n",
            "installing: libsodium-1.0.15-hf101ebd_0 ...\n",
            "installing: libtool-2.4.6-h544aabb_3 ...\n",
            "installing: libxcb-1.12-hcd93eb1_4 ...\n",
            "installing: lzo-2.10-h49e0be7_2 ...\n",
            "installing: mkl-2018.0.1-h19d6760_4 ...\n",
            "installing: ncurses-6.0-h9df7e31_2 ...\n",
            "installing: openssl-1.0.2n-hb7f436b_0 ...\n",
            "installing: patchelf-0.9-hf79760b_2 ...\n",
            "installing: pcre-8.41-hc27e229_1 ...\n",
            "installing: pixman-0.34.0-hceecf20_3 ...\n",
            "installing: tk-8.6.7-hc745277_3 ...\n",
            "installing: unixodbc-2.3.4-hc36303a_1 ...\n",
            "installing: xz-5.2.3-h55aa19d_2 ...\n",
            "installing: yaml-0.1.7-had09818_2 ...\n",
            "installing: zlib-1.2.11-ha838bed_2 ...\n",
            "installing: glib-2.53.6-h5d9569c_2 ...\n",
            "installing: hdf5-1.10.1-h9caa474_1 ...\n",
            "installing: libedit-3.1-heed3624_0 ...\n",
            "installing: libpng-1.6.34-hb9fc6fc_0 ...\n",
            "installing: libssh2-1.8.0-h9cfc8f7_4 ...\n",
            "installing: libtiff-4.0.9-h28f6b97_0 ...\n",
            "installing: libxml2-2.9.7-h26e45fe_0 ...\n",
            "installing: mpfr-3.1.5-h11a74b3_2 ...\n",
            "installing: pandoc-1.19.2.1-hea2e7c5_1 ...\n",
            "installing: readline-7.0-ha6073c6_4 ...\n",
            "installing: zeromq-4.2.2-hbedb6e5_2 ...\n",
            "installing: dbus-1.12.2-hc3f9b76_1 ...\n",
            "installing: freetype-2.8-hab7d2ae_1 ...\n",
            "installing: gstreamer-1.12.4-hb53b477_0 ...\n",
            "installing: libcurl-7.58.0-h1ad7b7a_0 ...\n",
            "installing: libxslt-1.1.32-h1312cb7_0 ...\n",
            "installing: mpc-1.0.3-hec55b23_5 ...\n",
            "installing: sqlite-3.22.0-h1bed415_0 ...\n",
            "installing: curl-7.58.0-h84994c4_0 ...\n",
            "installing: fontconfig-2.12.4-h88586e7_1 ...\n",
            "installing: gst-plugins-base-1.12.4-h33fb286_0 ...\n",
            "installing: alabaster-0.7.10-py36h306e16b_0 ...\n",
            "installing: asn1crypto-0.24.0-py36_0 ...\n",
            "installing: attrs-17.4.0-py36_0 ...\n",
            "installing: backports-1.0-py36hfa02d7e_1 ...\n",
            "installing: beautifulsoup4-4.6.0-py36h49b8c8c_1 ...\n",
            "installing: bitarray-0.8.1-py36h14c3975_1 ...\n",
            "installing: boto-2.48.0-py36h6e4cd66_1 ...\n",
            "installing: cairo-1.14.12-h77bcde2_0 ...\n",
            "installing: certifi-2018.1.18-py36_0 ...\n",
            "installing: chardet-3.0.4-py36h0f667ec_1 ...\n",
            "installing: click-6.7-py36h5253387_0 ...\n",
            "installing: cloudpickle-0.5.2-py36_1 ...\n",
            "installing: colorama-0.3.9-py36h489cec4_0 ...\n",
            "installing: contextlib2-0.5.5-py36h6c84a62_0 ...\n",
            "installing: dask-core-0.16.1-py36_0 ...\n",
            "installing: decorator-4.2.1-py36_0 ...\n",
            "installing: docutils-0.14-py36hb0f60f5_0 ...\n",
            "installing: entrypoints-0.2.3-py36h1aec115_2 ...\n",
            "installing: et_xmlfile-1.0.1-py36hd6bccc3_0 ...\n",
            "installing: fastcache-1.0.2-py36h14c3975_2 ...\n",
            "installing: filelock-2.0.13-py36h646ffb5_0 ...\n",
            "installing: glob2-0.6-py36he249c77_0 ...\n",
            "installing: gmpy2-2.0.8-py36hc8893dd_2 ...\n",
            "installing: greenlet-0.4.12-py36h2d503a6_0 ...\n",
            "installing: heapdict-1.0.0-py36_2 ...\n",
            "installing: idna-2.6-py36h82fb2a8_1 ...\n",
            "installing: imagesize-0.7.1-py36h52d8127_0 ...\n",
            "installing: ipython_genutils-0.2.0-py36hb52b0d5_0 ...\n",
            "installing: itsdangerous-0.24-py36h93cc618_1 ...\n",
            "installing: jdcal-1.3-py36h4c697fb_0 ...\n",
            "installing: lazy-object-proxy-1.3.1-py36h10fcdad_0 ...\n",
            "installing: llvmlite-0.21.0-py36ha241eea_0 ...\n",
            "installing: locket-0.2.0-py36h787c0ad_1 ...\n",
            "installing: lxml-4.1.1-py36hf71bdeb_1 ...\n",
            "installing: markupsafe-1.0-py36hd9260cd_1 ...\n",
            "installing: mccabe-0.6.1-py36h5ad9710_1 ...\n",
            "installing: mistune-0.8.3-py36_0 ...\n",
            "installing: mkl-service-1.1.2-py36h17a0993_4 ...\n",
            "installing: mpmath-1.0.0-py36hfeacd6b_2 ...\n",
            "installing: msgpack-python-0.5.1-py36h6bb024c_0 ...\n",
            "installing: multipledispatch-0.4.9-py36h41da3fb_0 ...\n",
            "installing: numpy-1.14.0-py36h3dfced4_1 ...\n",
            "installing: olefile-0.45.1-py36_0 ...\n",
            "installing: pandocfilters-1.4.2-py36ha6701b7_1 ...\n",
            "installing: parso-0.1.1-py36h35f843b_0 ...\n",
            "installing: path.py-10.5-py36h55ceabb_0 ...\n",
            "installing: pep8-1.7.1-py36_0 ...\n",
            "installing: pickleshare-0.7.4-py36h63277f8_0 ...\n",
            "installing: pkginfo-1.4.1-py36h215d178_1 ...\n",
            "installing: pluggy-0.6.0-py36hb689045_0 ...\n",
            "installing: ply-3.10-py36hed35086_0 ...\n",
            "installing: psutil-5.4.3-py36h14c3975_0 ...\n",
            "installing: ptyprocess-0.5.2-py36h69acd42_0 ...\n",
            "installing: py-1.5.2-py36h29bf505_0 ...\n",
            "installing: pycodestyle-2.3.1-py36hf609f19_0 ...\n",
            "installing: pycosat-0.6.3-py36h0a5515d_0 ...\n",
            "installing: pycparser-2.18-py36hf9f622e_1 ...\n",
            "installing: pycrypto-2.6.1-py36h14c3975_7 ...\n",
            "installing: pycurl-7.43.0.1-py36hb7f436b_0 ...\n",
            "installing: pyodbc-4.0.22-py36hf484d3e_0 ...\n",
            "installing: pyparsing-2.2.0-py36hee85983_1 ...\n",
            "installing: pysocks-1.6.7-py36hd97a5b1_1 ...\n",
            "installing: pytz-2017.3-py36h63b9c63_0 ...\n",
            "installing: pyyaml-3.12-py36hafb9ca4_1 ...\n",
            "installing: pyzmq-16.0.3-py36he2533c7_0 ...\n",
            "installing: qt-5.6.2-h974d657_12 ...\n",
            "installing: qtpy-1.3.1-py36h3691cc8_0 ...\n",
            "installing: rope-0.10.7-py36h147e2ec_0 ...\n",
            "installing: ruamel_yaml-0.15.35-py36h14c3975_1 ...\n",
            "installing: send2trash-1.4.2-py36_0 ...\n",
            "installing: simplegeneric-0.8.1-py36_2 ...\n",
            "installing: sip-4.18.1-py36h51ed4ed_2 ...\n",
            "installing: six-1.11.0-py36h372c433_1 ...\n",
            "installing: snowballstemmer-1.2.1-py36h6febd40_0 ...\n",
            "installing: sortedcontainers-1.5.9-py36_0 ...\n",
            "installing: sphinxcontrib-1.0-py36h6d0f590_1 ...\n",
            "installing: sqlalchemy-1.2.1-py36h14c3975_0 ...\n",
            "installing: tblib-1.3.2-py36h34cf8b6_0 ...\n",
            "installing: testpath-0.3.1-py36h8cadb63_0 ...\n",
            "installing: toolz-0.9.0-py36_0 ...\n",
            "installing: tornado-4.5.3-py36_0 ...\n",
            "installing: typing-3.6.2-py36h7da032a_0 ...\n",
            "installing: unicodecsv-0.14.1-py36ha668878_0 ...\n",
            "installing: wcwidth-0.1.7-py36hdf4376a_0 ...\n",
            "installing: webencodings-0.5.1-py36h800622e_1 ...\n",
            "installing: werkzeug-0.14.1-py36_0 ...\n",
            "installing: wrapt-1.10.11-py36h28b7045_0 ...\n",
            "installing: xlrd-1.1.0-py36h1db9f0c_1 ...\n",
            "installing: xlsxwriter-1.0.2-py36h3de1aca_0 ...\n",
            "installing: xlwt-1.3.0-py36h7b00a1f_0 ...\n",
            "installing: babel-2.5.3-py36_0 ...\n",
            "installing: backports.shutil_get_terminal_size-1.0.0-py36hfea85ff_2 ...\n",
            "installing: bottleneck-1.2.1-py36haac1ea0_0 ...\n",
            "installing: cffi-1.11.4-py36h9745a5d_0 ...\n",
            "installing: conda-verify-2.0.0-py36h98955d8_0 ...\n",
            "installing: cycler-0.10.0-py36h93f1223_0 ...\n",
            "installing: cytoolz-0.9.0-py36h14c3975_0 ...\n",
            "installing: h5py-2.7.1-py36h3585f63_0 ...\n",
            "installing: harfbuzz-1.7.4-hc5b324e_0 ...\n",
            "installing: html5lib-1.0.1-py36h2f9c1c0_0 ...\n",
            "installing: jedi-0.11.1-py36_0 ...\n",
            "installing: networkx-2.1-py36_0 ...\n",
            "installing: nltk-3.2.5-py36h7532b22_0 ...\n",
            "installing: numba-0.36.2-np114py36hc6662d5_0 ...\n",
            "installing: numexpr-2.6.4-py36hc4a3f9a_0 ...\n",
            "installing: openpyxl-2.4.10-py36_0 ...\n",
            "installing: packaging-16.8-py36ha668100_1 ...\n",
            "installing: partd-0.3.8-py36h36fd896_0 ...\n",
            "installing: pathlib2-2.3.0-py36h49efa8e_0 ...\n",
            "installing: pexpect-4.3.1-py36_0 ...\n",
            "installing: pillow-5.0.0-py36h3deb7b8_0 ...\n",
            "installing: pyqt-5.6.0-py36h0386399_5 ...\n",
            "installing: python-dateutil-2.6.1-py36h88d3b88_1 ...\n",
            "installing: pywavelets-0.5.2-py36he602eb0_0 ...\n",
            "installing: qtawesome-0.4.4-py36h609ed8c_0 ...\n",
            "installing: scipy-1.0.0-py36hbf646e7_0 ...\n",
            "installing: setuptools-38.4.0-py36_0 ...\n",
            "installing: singledispatch-3.4.0.3-py36h7a266c3_0 ...\n",
            "installing: sortedcollections-0.5.3-py36h3c761f9_0 ...\n",
            "installing: sphinxcontrib-websupport-1.0.1-py36hb5cb234_1 ...\n",
            "installing: sympy-1.1.1-py36hc6d1c1c_0 ...\n",
            "installing: terminado-0.8.1-py36_1 ...\n",
            "installing: traitlets-4.3.2-py36h674d592_0 ...\n",
            "installing: zict-0.1.3-py36h3a3bf81_0 ...\n",
            "installing: astroid-1.6.1-py36_0 ...\n",
            "installing: bleach-2.1.2-py36_0 ...\n",
            "installing: clyent-1.2.2-py36h7e57e65_1 ...\n",
            "installing: cryptography-2.1.4-py36hd09be54_0 ...\n",
            "installing: cython-0.27.3-py36h1860423_0 ...\n",
            "installing: datashape-0.5.4-py36h3ad6b5c_0 ...\n",
            "installing: distributed-1.20.2-py36_0 ...\n",
            "installing: get_terminal_size-1.0.0-haa9412d_0 ...\n",
            "installing: gevent-1.2.2-py36h2fe25dc_0 ...\n",
            "installing: imageio-2.2.0-py36he555465_0 ...\n",
            "installing: isort-4.2.15-py36had401c0_0 ...\n",
            "installing: jinja2-2.10-py36ha16c418_0 ...\n",
            "installing: jsonschema-2.6.0-py36h006f8b5_0 ...\n",
            "installing: jupyter_core-4.4.0-py36h7c827e3_0 ...\n",
            "installing: matplotlib-2.1.2-py36h0e671d2_0 ...\n",
            "installing: navigator-updater-0.1.0-py36h14770f7_0 ...\n",
            "installing: nose-1.3.7-py36hcdf7029_2 ...\n",
            "installing: pandas-0.22.0-py36hf484d3e_0 ...\n",
            "installing: pango-1.41.0-hd475d92_0 ...\n",
            "installing: patsy-0.5.0-py36_0 ...\n",
            "installing: pyflakes-1.6.0-py36h7bd6a15_0 ...\n",
            "installing: pygments-2.2.0-py36h0d3125c_0 ...\n",
            "installing: pytables-3.4.2-py36h3b5282a_2 ...\n",
            "installing: pytest-3.3.2-py36_0 ...\n",
            "installing: scikit-learn-0.19.1-py36h7aa7ec6_0 ...\n",
            "installing: wheel-0.30.0-py36hfd4bba0_1 ...\n",
            "installing: astropy-2.0.3-py36h14c3975_0 ...\n",
            "installing: bkcharts-0.2-py36h735825a_0 ...\n",
            "installing: bokeh-0.12.13-py36h2f9c1c0_0 ...\n",
            "installing: flask-0.12.2-py36hb24657c_0 ...\n",
            "installing: jupyter_client-5.2.2-py36_0 ...\n",
            "installing: nbformat-4.4.0-py36h31c9010_0 ...\n",
            "installing: pip-9.0.1-py36h6c6f9ce_4 ...\n",
            "installing: prompt_toolkit-1.0.15-py36h17d85b1_0 ...\n",
            "installing: pylint-1.8.2-py36_0 ...\n",
            "installing: pyopenssl-17.5.0-py36h20ba746_0 ...\n",
            "installing: statsmodels-0.8.0-py36h8533d0b_0 ...\n",
            "installing: dask-0.16.1-py36_0 ...\n",
            "installing: flask-cors-3.0.3-py36h2d857d3_0 ...\n",
            "installing: ipython-6.2.1-py36h88c514a_1 ...\n",
            "installing: nbconvert-5.3.1-py36hb41ffb7_0 ...\n",
            "installing: seaborn-0.8.1-py36hfad7ec4_0 ...\n",
            "installing: urllib3-1.22-py36hbe7ace6_0 ...\n",
            "installing: ipykernel-4.8.0-py36_0 ...\n",
            "installing: odo-0.5.1-py36h90ed295_0 ...\n",
            "installing: requests-2.18.4-py36he2e5f8d_1 ...\n",
            "installing: scikit-image-0.13.1-py36h14c3975_1 ...\n",
            "installing: anaconda-client-1.6.9-py36_0 ...\n",
            "installing: blaze-0.11.3-py36h4e06776_0 ...\n",
            "installing: jupyter_console-5.2.0-py36he59e554_1 ...\n",
            "installing: notebook-5.4.0-py36_0 ...\n",
            "installing: qtconsole-4.3.1-py36h8f73b5b_0 ...\n",
            "installing: sphinx-1.6.6-py36_0 ...\n",
            "installing: anaconda-project-0.8.2-py36h44fb852_0 ...\n",
            "installing: jupyterlab_launcher-0.10.2-py36_0 ...\n",
            "installing: numpydoc-0.7.0-py36h18f165f_0 ...\n",
            "installing: widgetsnbextension-3.1.0-py36_0 ...\n",
            "installing: anaconda-navigator-1.7.0-py36_0 ...\n",
            "installing: ipywidgets-7.1.1-py36_0 ...\n",
            "installing: jupyterlab-0.31.5-py36_0 ...\n",
            "installing: spyder-3.2.6-py36_0 ...\n",
            "installing: _ipyw_jlab_nb_ext_conf-0.1.0-py36he11e457_0 ...\n",
            "installing: jupyter-1.0.0-py36_4 ...\n",
            "installing: anaconda-5.1.0-py36_2 ...\n",
            "installing: conda-4.4.10-py36_0 ...\n",
            "installing: conda-build-3.4.1-py36_0 ...\n",
            "installation finished.\n",
            "WARNING:\n",
            "    You currently have a PYTHONPATH environment variable set. This may cause\n",
            "    unexpected behavior when running the Python interpreter in Anaconda3.\n",
            "    For best results, please verify that your PYTHONPATH only points to\n",
            "    directories of packages that are compatible with the Python interpreter\n",
            "    in Anaconda3: /usr/local\n",
            "Solving environment: ...working... done\n",
            "\n",
            "\n",
            "==> WARNING: A newer version of conda exists. <==\n",
            "  current version: 4.4.10\n",
            "  latest version: 4.5.12\n",
            "\n",
            "Please update conda by running\n",
            "\n",
            "    $ conda update -n base conda\n",
            "\n",
            "\n",
            "\n",
            "## Package Plan ##\n",
            "\n",
            "  environment location: /usr/local\n",
            "\n",
            "  added / updated specs: \n",
            "    - bottleneck\n",
            "    - dask\n",
            "    - netcdf4\n",
            "    - xarray\n",
            "\n",
            "\n",
            "The following packages will be downloaded:\n",
            "\n",
            "    package                    |            build\n",
            "    ---------------------------|-----------------\n",
            "    pandas-0.23.4              |   py36hf8a1672_0        27.8 MB  conda-forge\n",
            "    hdf4-4.2.13                |       h951d187_2         970 KB  conda-forge\n",
            "    krb5-1.14.6                |                0         4.0 MB  conda-forge\n",
            "    distributed-1.25.2         |        py36_1000         815 KB  conda-forge\n",
            "    bottleneck-1.2.1           |   py36h7eb728f_1         309 KB  conda-forge\n",
            "    numpy-1.14.2               |   py36hdbf6ddf_0         4.0 MB\n",
            "    curl-7.61.0                |       h93b3f91_2         859 KB  conda-forge\n",
            "    xarray-0.11.2              |        py36_1000         844 KB  conda-forge\n",
            "    certifi-2018.11.29         |        py36_1000         145 KB  conda-forge\n",
            "    blas-1.0                   |              mkl           6 KB\n",
            "    libnetcdf-4.6.2            |       h85b088c_1         1.2 MB  conda-forge\n",
            "    libgfortran-3.0.0          |                1         281 KB  conda-forge\n",
            "    bokeh-1.0.4                |        py36_1000         5.4 MB  conda-forge\n",
            "    openssl-1.0.2p             |       h470a237_2         3.1 MB  conda-forge\n",
            "    netcdf4-1.4.2              |   py36hf4e5497_1         1.9 MB  conda-forge\n",
            "    cftime-1.0.3.4             |   py36h7eb728f_0         1.1 MB  conda-forge\n",
            "    ca-certificates-2018.11.29 |       ha4d7672_0         143 KB  conda-forge\n",
            "    dask-core-1.0.0            |             py_0         514 KB  conda-forge\n",
            "    hdf5-1.10.4                |nompi_h5598ddc_1105         4.8 MB  conda-forge\n",
            "    dask-1.0.0                 |             py_1           4 KB  conda-forge\n",
            "    jpeg-9c                    |       h470a237_1         229 KB  conda-forge\n",
            "    ------------------------------------------------------------\n",
            "                                           Total:        58.4 MB\n",
            "\n",
            "The following NEW packages will be INSTALLED:\n",
            "\n",
            "    blas:            1.0-mkl                           \n",
            "    cftime:          1.0.3.4-py36h7eb728f_0 conda-forge\n",
            "    hdf4:            4.2.13-h951d187_2      conda-forge\n",
            "    krb5:            1.14.6-0               conda-forge\n",
            "    libgfortran:     3.0.0-1                conda-forge\n",
            "    libnetcdf:       4.6.2-h85b088c_1       conda-forge\n",
            "    netcdf4:         1.4.2-py36hf4e5497_1   conda-forge\n",
            "    xarray:          0.11.2-py36_1000       conda-forge\n",
            "\n",
            "The following packages will be UPDATED:\n",
            "\n",
            "    bokeh:           0.12.13-py36h2f9c1c0_0             --> 1.0.4-py36_1000            conda-forge\n",
            "    bottleneck:      1.2.1-py36haac1ea0_0               --> 1.2.1-py36h7eb728f_1       conda-forge\n",
            "    ca-certificates: 2017.08.26-h1d4fec5_0              --> 2018.11.29-ha4d7672_0      conda-forge\n",
            "    certifi:         2018.1.18-py36_0                   --> 2018.11.29-py36_1000       conda-forge\n",
            "    curl:            7.58.0-h84994c4_0                  --> 7.61.0-h93b3f91_2          conda-forge\n",
            "    dask:            0.16.1-py36_0                      --> 1.0.0-py_1                 conda-forge\n",
            "    dask-core:       0.16.1-py36_0                      --> 1.0.0-py_0                 conda-forge\n",
            "    distributed:     1.20.2-py36_0                      --> 1.25.2-py36_1000           conda-forge\n",
            "    hdf5:            1.10.1-h9caa474_1                  --> 1.10.4-nompi_h5598ddc_1105 conda-forge\n",
            "    jpeg:            9b-h024ee3a_2                      --> 9c-h470a237_1              conda-forge\n",
            "    numpy:           1.14.0-py36h3dfced4_1              --> 1.14.2-py36hdbf6ddf_0                 \n",
            "    openssl:         1.0.2n-hb7f436b_0                  --> 1.0.2p-h470a237_2          conda-forge\n",
            "    pandas:          0.22.0-py36hf484d3e_0              --> 0.23.4-py36hf8a1672_0      conda-forge\n",
            "\n",
            "Preparing transaction: ...working... done\n",
            "Verifying transaction: ...working... done\n",
            "Executing transaction: ...working... done\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "4fMyTxA7LpGV",
        "colab_type": "code",
        "outputId": "31530b7b-30da-41fa-e1c7-1e2fdebd9bcd",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "cell_type": "code",
      "source": [
        "# Import packages\n",
        "import numpy as np\n",
        "import pandas as pd\n",
        "import matplotlib.pyplot as plt\n",
        "from math import floor, ceil\n",
        "import seaborn as sns\n",
        "\n",
        "import xarray as xr\n",
        "#import tensorflow as tf\n",
        "print('All packages imported.')"
      ],
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "All packages imported.\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "ej0uLvkNLv3a",
        "colab_type": "code",
        "outputId": "24c7b766-0885-4586-c0cd-68945850b0ff",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "cell_type": "code",
      "source": [
        "# Mount Google Drive locally\n",
        "from google.colab import drive\n",
        "drive.mount('/content/gdrive')"
      ],
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Drive already mounted at /content/gdrive; to attempt to forcibly remount, call drive.mount(\"/content/gdrive\", force_remount=True).\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "qDgHlBhsRcX1",
        "colab_type": "code",
        "outputId": "f5efc6ed-0b8b-4a2e-c27f-49d195bc045e",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 85
        }
      },
      "cell_type": "code",
      "source": [
        "# Check data list\n",
        "!ls \"/content/gdrive/My Drive/Colab Notebooks/NN/data/\""
      ],
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "ARM_1hrlater.csv\t\t\t      ARM_6hrcumul.csv\n",
            "ARM_1hrlater.gsheet\t\t\t      ARM_no_dropna.cdf\n",
            "ARM_1hrlater_RFclassified.csv\t\t      ARM_strict_dropna.csv\n",
            "ARM_1hrlater_RFclassified_threshold_0.05.csv  pairplot_month_ALL.png\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "-77VilC9SYJU",
        "colab_type": "code",
        "outputId": "c548cfc6-dd73-44e6-8856-86b63b2b3b2b",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 204
        }
      },
      "cell_type": "code",
      "source": [
        "  # Read data\n",
        "  f = \"/content/gdrive/My Drive/Colab Notebooks/NN/data/ARM_no_dropna.cdf\"\n",
        "  DS = xr.open_dataset(f)\n",
        "  DS = DS.drop(['z10','z2'])\n",
        "  DS"
      ],
      "execution_count": 70,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<xarray.Dataset>\n",
              "Dimensions:   (p: 37, time: 131496)\n",
              "Coordinates:\n",
              "  * time      (time) datetime64[ns] 1996-01-01T00:30:00 ... 2010-12-31T23:30:00\n",
              "  * p         (p) float32 1000.0 975.0 950.0 925.0 ... 175.0 150.0 125.0 100.0\n",
              "Data variables:\n",
              "    T_p       (time, p) float64 ...\n",
              "    rh_p      (time, p) float64 ...\n",
              "    u_p       (time, p) float64 ...\n",
              "    v_p       (time, p) float64 ...\n",
              "    prec_sfc  (time) float64 ..."
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 70
        }
      ]
    },
    {
      "metadata": {
        "id": "hlMchuUuuXS3",
        "colab_type": "code",
        "outputId": "eb143fb9-e44e-4099-8777-2364d054711e",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 347
        }
      },
      "cell_type": "code",
      "source": [
        "# Build multiple DataArray to collapse pressure coord\n",
        "precip = DS['prec_sfc'] # the only DataArray with no pressure coord\n",
        "binwidth = 5 # 5mm range for each bin of histogram\n",
        "plt.hist(precip.dropna(dim='time'), bins=range(20, 100, binwidth)) # ignore rains with <20mm\n",
        "plt.show()\n",
        "\n",
        "da_list = ['precip'] # initialize list of DataArray\n",
        "\n",
        "plev = DS['p'].values.astype(np.int32) # array of pressure level\n",
        "var_p_list = ['T_p','rh_p','u_p','v_p'] # array of variables with pressure coord\n",
        "\n",
        "for _var in var_p_list:\n",
        "  for _p in plev:\n",
        "    new_var_str = (_var + str(_p)) # new variable name (in string)\n",
        "    da_list.append(new_var_str) # append the new variable\n",
        "    exec(\"{} = DS[_var].sel(p=_p).drop('p')\".format(new_var_str)) # assign DataArray\n",
        "    exec(\"{} = {}.rename('{}')\".format(new_var_str,new_var_str,new_var_str)) # rename data variables to avoid merge collision"
      ],
      "execution_count": 71,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAeQAAAFKCAYAAADMuCxnAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4yLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvOIA7rQAAGoJJREFUeJzt3XtwVPXdx/FPnmzWTMJSkrjLiCMU\nmQpaAsjATEPDzYSLWCuKXJoCOqKVEi61oRDTjMRhWgmgw8W0IPdJmhpZW4hTZ5KhloqdkA6mkxKn\nDIKtAwGSDSYESRYhnOcPx33k0RJcNpvfOXm//krOLuf3+44Z39mzl8RYlmUJAAB0q//p7g0AAACC\nDACAEQgyAAAGIMgAABiAIAMAYACCDACAAVzduXggcDGi50tKSlBzc1tEz2kCp84lOXc25rIX5rIX\nO8/l9Xr+622OeoTscsV29xa6hFPnkpw7G3PZC3PZi1PnclSQAQCwq5sK8vHjx5WZmamSkhJJ0pUr\nV5STk6PHH39cTzzxhC5cuCBJKi8v14wZMzRz5kzt3bu363YNAIDDdBrktrY2rV69WmlpaaFjb7zx\nhpKSkuT3+zVt2jQdOXJEbW1tKioq0u7du1VcXKw9e/aopaWlSzcPAIBTdBpkt9utbdu2yefzhY79\n5S9/0Q9/+ENJ0uzZs5WRkaHa2lqlpqbK4/EoPj5eI0eOVE1NTdftHAAAB+k0yC6XS/Hx8dcdq6+v\n17vvvqt58+bpueeeU0tLi5qampScnBy6T3JysgKBQOR3DACAA4X1tifLsjRw4EAtXrxYv/nNb7R1\n61bdd999X7lPZ5KSEiL+arkbvaTczpw6l+Tc2ZjLXpjLXpw4V1hBvv322zV69GhJUnp6ujZv3qwJ\nEyaoqakpdJ/GxkaNGDHihueJ9PvIvF5PxN/bbAKnziU5dzbmshfmshc7zxXx9yGPGzdOhw4dkiR9\n8MEHGjhwoIYPH66jR4+qtbVVly5dUk1NjUaNGhXejgEA6GE6fYRcV1enwsJC1dfXy+VyqaKiQuvX\nr9evfvUr+f1+JSQkqLCwUPHx8crJydGCBQsUExOj7OxseTzOu6QAAEBXiLFu5sneLhLpSw52voxx\nI06dS3LubMxlL8xlL3aeq8d8dCYAAHZFkAEAMEC3/rWnSHs4Z3/U1tqZ+0DU1gIAOB+PkAEAMABB\nBgDAAAQZAAADEGQAAAxAkAEAMABBBgDAAAQZAAADEGQAAAxAkAEAMABBBgDAAAQZAAADEGQAAAxA\nkAEAMABBBgDAAAQZAAADEGQAAAxAkAEAMABBBgDAAAQZAAADEGQAAAxAkAEAMABBBgDAAAQZAAAD\nEGQAAAxAkAEAMMBNBfn48ePKzMxUSUnJdccPHTqkwYMHh74vLy/XjBkzNHPmTO3duzeyOwUAwMFc\nnd2hra1Nq1evVlpa2nXHL1++rNdee01erzd0v6KiIvn9fsXFxenxxx/XpEmT1KdPn67ZOQAADtLp\nI2S3261t27bJ5/Ndd3zLli3KysqS2+2WJNXW1io1NVUej0fx8fEaOXKkampqumbXAAA4TKePkF0u\nl1yu6+/273//W8eOHdOyZcu0bt06SVJTU5OSk5ND90lOTlYgELjhuZOSEuRyxYaz727n9XocvV40\nOXU25rIX5rIXJ87VaZC/zksvvaT8/Pwb3seyrE7P09zcFs7yRggELkZtLa/XE9X1osmpszGXvTCX\nvdh5rhv9IvGNX2Xd0NCgjz76SMuXL9esWbPU2NiouXPnyufzqampKXS/xsbGr1zmBgAAX+8bP0Lu\n27evDhw4EPr+gQceUElJiYLBoPLz89Xa2qrY2FjV1NQoLy8vopsFAMCpOg1yXV2dCgsLVV9fL5fL\npYqKCm3evPkrr56Oj49XTk6OFixYoJiYGGVnZ8vjcd41fgAAukKnQR46dKiKi4v/6+3vvPNO6Oup\nU6dq6tSpkdkZAAA9CJ/UBQCAAQgyAAAGIMgAABiAIAMAYACCDACAAQgyAAAGIMgAABiAIAMAYACC\nDACAAQgyAAAGIMgAABiAIAMAYACCDACAAQgyAAAGIMgAABiAIAMAYACCDACAAQgyAAAGIMgAABiA\nIAMAYACCDACAAQgyAAAGIMgAABiAIAMAYACCDACAAQgyAAAGIMgAABjgpoJ8/PhxZWZmqqSkRJJ0\n9uxZPfnkk5o7d66efPJJBQIBSVJ5eblmzJihmTNnau/evV23awAAHKbTILe1tWn16tVKS0sLHduw\nYYNmzZqlkpISTZo0Sbt27VJbW5uKioq0e/duFRcXa8+ePWppaenSzQMA4BSdBtntdmvbtm3y+Xyh\nY6tWrdKUKVMkSUlJSWppaVFtba1SU1Pl8XgUHx+vkSNHqqamput2DgCAg3QaZJfLpfj4+OuOJSQk\nKDY2Vh0dHSotLdXDDz+spqYmJScnh+6TnJwcupQNAABuzBXuP+zo6NCKFSv0ve99T2lpaXrrrbeu\nu92yrE7PkZSUIJcrNtwtdCuv1+Po9aLJqbMxl70wl704ca6wg/z8889rwIABWrx4sSTJ5/Opqakp\ndHtjY6NGjBhxw3M0N7eFu3y3CwQuRm0tr9cT1fWiyamzMZe9MJe92HmuG/0iEdbbnsrLyxUXF6el\nS5eGjg0fPlxHjx5Va2urLl26pJqaGo0aNSqc0wMA0ON0+gi5rq5OhYWFqq+vl8vlUkVFhc6fP6/b\nbrtN8+bNkyQNGjRIBQUFysnJ0YIFCxQTE6Ps7Gx5PM67pAAAQFfoNMhDhw5VcXHxTZ1s6tSpmjp1\n6i1vCgCAnoZP6gIAwAAEGQAAAxBkAAAMQJABADAAQQYAwAAEGQAAAxBkAAAMQJABADAAQQYAwAAE\nGQAAAxBkAAAMQJABADAAQQYAwAAEGQAAAxBkAAAMQJABADAAQQYAwAAEGQAAAxBkAAAMQJABADAA\nQQYAwAAEGQAAAxBkAAAMQJABADAAQQYAwAAEGQAAAxBkAAAMQJABADDATQX5+PHjyszMVElJiSTp\n7NmzmjdvnrKysrRs2TJ99tlnkqTy8nLNmDFDM2fO1N69e7tu1wAAOEynQW5ra9Pq1auVlpYWOrZp\n0yZlZWWptLRUAwYMkN/vV1tbm4qKirR7924VFxdrz549amlp6dLNAwDgFJ0G2e12a9u2bfL5fKFj\n1dXVysjIkCRNnDhRVVVVqq2tVWpqqjwej+Lj4zVy5EjV1NR03c4BAHAQV6d3cLnkcl1/t/b2drnd\nbklSSkqKAoGAmpqalJycHLpPcnKyAoHADc+dlJQglys2nH13O6/X4+j1osmpszGXvTCXvThxrk6D\n3BnLsr7R8S9rbm671eW7TSBwMWpreb2eqK4XTU6djbnshbnsxc5z3egXibBeZZ2QkKBgMChJamho\nkM/nk8/nU1NTU+g+jY2N113mBgAA/11YQR4zZowqKiokSZWVlRo7dqyGDx+uo0ePqrW1VZcuXVJN\nTY1GjRoV0c0CAOBUnV6yrqurU2Fhoerr6+VyuVRRUaH169crNzdXZWVl6tevn6ZPn664uDjl5ORo\nwYIFiomJUXZ2tjwe513j/8JTa96J2lpvvfxI1NYCAHSPToM8dOhQFRcXf+X4rl27vnJs6tSpmjp1\namR2BgBAD8IndQEAYACCDACAAQgyAAAGIMgAABiAIAMAYACCDACAAQgyAAAGIMgAABiAIAMAYACC\nDACAAQgyAAAGIMgAABiAIAMAYACCDACAAQgyAAAGIMgAABiAIAMAYACCDACAAQgyAAAGIMgAABiA\nIAMAYACCDACAAQgyAAAGIMgAABiAIAMAYACCDACAAQgyAAAGcIXzjy5duqSVK1fqwoULunLlirKz\ns+X1elVQUCBJGjx4sF588cVI7hMAAEcLK8h//OMfNXDgQOXk5KihoUFPPPGEvF6v8vLyNGzYMOXk\n5Oivf/2rxo8fH+n9AgDgSGFdsk5KSlJLS4skqbW1VX369FF9fb2GDRsmSZo4caKqqqoit0sAABwu\nrCA/9NBDOnPmjCZNmqS5c+dqxYoV6t27d+j2lJQUBQKBiG0SAACnC+uS9f79+9WvXz/t2LFDx44d\nU3Z2tjweT+h2y7Ju6jxJSQlyuWLD2UKP4/V6Or+TTTl1NuayF+ayFyfOFVaQa2pqlJ6eLkkaMmSI\nLl++rKtXr4Zub2hokM/n6/Q8zc1t4SzfIwUCF7t7C13C6/U4cjbmshfmshc7z3WjXyTCumQ9YMAA\n1dbWSpLq6+uVmJioQYMG6ciRI5KkyspKjR07NpxTAwDQI4X1CHn27NnKy8vT3LlzdfXqVRUUFMjr\n9eqFF17QtWvXNHz4cI0ZMybSewUAwLHCCnJiYqI2btz4leOlpaW3vCEAAHoiPqkLAAADEGQAAAwQ\n1iVrRNfDOfujut7O3Aeiuh4AgEfIAAAYgSADAGAAggwAgAEIMgAABiDIAAAYgCADAGAAggwAgAEI\nMgAABiDIAAAYgCADAGAAggwAgAEIMgAABiDIAAAYgCADAGAAggwAgAEIMgAABiDIAAAYgCADAGAA\nggwAgAEIMgAABiDIAAAYgCADAGAAggwAgAEIMgAABiDIAAAYwBXuPywvL9f27dvlcrm0dOlSDR48\nWCtWrFBHR4e8Xq/WrVsnt9sdyb0CAOBYYT1Cbm5uVlFRkUpLS7Vlyxb9+c9/1qZNm5SVlaXS0lIN\nGDBAfr8/0nsFAMCxwgpyVVWV0tLS1KtXL/l8Pq1evVrV1dXKyMiQJE2cOFFVVVUR3SgAAE4W1iXr\n06dPKxgMauHChWptbdWSJUvU3t4eukSdkpKiQCDQ6XmSkhLkcsWGswV0Ia/X4+j1ooW57IW57MWJ\nc4X9HHJLS4teffVVnTlzRvPnz5dlWaHbvvz1jTQ3t4W7PLpQIHAxamt5vZ6orhctzGUvzGUvdp7r\nRr9IhHXJOiUlRffff79cLpf69++vxMREJSYmKhgMSpIaGhrk8/nC2y0AAD1QWEFOT0/X4cOHde3a\nNTU3N6utrU1jxoxRRUWFJKmyslJjx46N6EYBAHCysC5Z9+3bV1OmTNGsWbMkSfn5+UpNTdXKlStV\nVlamfv36afr06RHdKAAAThb2c8hz5szRnDlzrju2a9euW94QAAA9EZ/UBQCAAQgyAAAGIMgAABgg\n7OeQ4VxPrXknamu99fIjUVsLAEzGI2QAAAxAkAEAMABBBgDAAAQZAAADEGQAAAxAkAEAMABBBgDA\nAAQZAAADEGQAAAxAkAEAMABBBgDAAAQZAAADEGQAAAxAkAEAMABBBgDAAAQZAAADEGQAAAxAkAEA\nMABBBgDAAAQZAAADEGQAAAxAkAEAMABBBgDAALcU5GAwqMzMTP3hD3/Q2bNnNW/ePGVlZWnZsmX6\n7LPPIrVHAAAc75aC/Nvf/lbf+ta3JEmbNm1SVlaWSktLNWDAAPn9/ohsEACAniDsIJ88eVInTpzQ\nhAkTJEnV1dXKyMiQJE2cOFFVVVUR2SAAAD1B2EEuLCxUbm5u6Pv29na53W5JUkpKigKBwK3vDgCA\nHsIVzj/at2+fRowYobvuuutrb7cs66bOk5SUIJcrNpwtwEG8Xk93b6FLMJe9MJe9OHGusIJ88OBB\nnTp1SgcPHtS5c+fkdruVkJCgYDCo+Ph4NTQ0yOfzdXqe5ua2cJaHwwQCF7t7CxHn9XqYy0aYy17s\nPNeNfpEIK8gbNmwIfb1582bdeeed+sc//qGKigo98sgjqqys1NixY8M5NQAAPVLE3oe8ZMkS7du3\nT1lZWWppadH06dMjdWoAABwvrEfIX7ZkyZLQ17t27brV0wEA0CPxSV0AABiAIAMAYACCDACAAQgy\nAAAGIMgAABiAIAMAYACCDACAAQgyAAAGuOUPBgFuxcM5+6O21s7cB6K2FgB8UzxCBgDAAAQZAAAD\nEGQAAAxAkAEAMABBBgDAAAQZAAADEGQAAAxAkAEAMABBBgDAAAQZAAADEGQAAAxAkAEAMABBBgDA\nAAQZAAADEGQAAAzA30NGj/HUmneittZbLz8StbUAOAOPkAEAMABBBgDAAAQZAAADhP0c8tq1a/X+\n++/r6tWrevbZZ5WamqoVK1aoo6NDXq9X69atk9vtjuReAQBwrLCCfPjwYX344YcqKytTc3OzHn30\nUaWlpSkrK0sPPvigXnnlFfn9fmVlZUV6vwAAOFJYl6xHjx6tjRs3SpJ69+6t9vZ2VVdXKyMjQ5I0\nceJEVVVVRW6XAAA4XFiPkGNjY5WQkCBJ8vv9GjdunN57773QJeqUlBQFAoFOz5OUlCCXKzacLQDG\n83o93b2FLsFc9sJc9nFL70M+cOCA/H6/du7cqcmTJ4eOW5Z1U/++ubntVpYHjBYIXOzuLUSc1+th\nLhthLvPc6BeJsF9lfejQIW3ZskXbtm2Tx+NRQkKCgsGgJKmhoUE+ny/cUwMA0OOEFeSLFy9q7dq1\n2rp1q/r06SNJGjNmjCoqKiRJlZWVGjt2bOR2CQCAw4V1yfrtt99Wc3Ozfvazn4WOrVmzRvn5+Sor\nK1O/fv00ffr0iG0SAACnCyvIs2fP1uzZs79yfNeuXbe8IQAAeiI+qQsAAAMQZAAADECQAQAwAEEG\nAMAABBkAAAMQZAAADECQAQAwAEEGAMAABBkAAAPc0l97AvD1Hs7ZH7W1duY+ELW1AHQdHiEDAGAA\nggwAgAEIMgAABuA5ZMDmnlrzTtTWeuvlR6K2FtDTEGQAN40XqwFdh0vWAAAYgCADAGAAggwAgAEI\nMgAABiDIAAAYgCADAGAAggwAgAF4HzIAIzn1A0+cOhduHY+QAQAwAEEGAMAABBkAAAMQZAAADBDx\nF3X9+te/Vm1trWJiYpSXl6dhw4ZFegkAABwnokH++9//ro8//lhlZWU6efKk8vLyVFZWFsklAABw\npIgGuaqqSpmZmZKkQYMG6cKFC/r000/Vq1evSC4DABEVzT8r6VS8nevWRfQ55KamJiUlJYW+T05O\nViAQiOQSAAA4Upd+MIhlWTe83ev1RHQ9p/7WBADhivT/Z/+baP//N1pzRVNEHyH7fD41NTWFvm9s\nbJTX643kEgAAOFJEg/z9739fFRUVkqQPPvhAPp+P548BALgJEb1kPXLkSH33u9/VnDlzFBMTo1Wr\nVkXy9AAAOFaM1dkTvQAAoMvxSV0AABiAIAMAYABb/z3ktWvX6v3339fVq1f17LPPKjU1VStWrFBH\nR4e8Xq/WrVsnt9vd3dv8Rtrb25Wbm6vz58/r8uXLWrRokYYMGWL7ub4QDAb1gx/8QIsWLVJaWpoj\n5qqurtayZcv0ne98R5J0zz336Omnn3bEbOXl5dq+fbtcLpeWLl2qwYMH236uvXv3qry8PPR9XV2d\nfv/736ugoECSNHjwYL344ovdtLvwXbp0SStXrtSFCxd05coVZWdny+v12n6ua9euadWqVfrwww8V\nFxengoICJSQk2P7n8GtZNlVVVWU9/fTTlmVZ1ieffGKNHz/eys3Ntd5++23Lsizr5Zdftn73u991\n5xbD8qc//cl67bXXLMuyrNOnT1uTJ092xFxfeOWVV6zHHnvMevPNNx0z1+HDh60lS5Zcd8wJs33y\nySfW5MmTrYsXL1oNDQ1Wfn6+I+b6surqaqugoMCaO3euVVtba1mWZf385z+3Dh482M07++aKi4ut\n9evXW5ZlWefOnbOmTJniiLkqKyutZcuWWZZlWR9//LH1k5/8xHE/h1+w7SXr0aNHa+PGjZKk3r17\nq729XdXV1crIyJAkTZw4UVVVVd25xbBMmzZNzzzzjCTp7Nmz6tu3ryPmkqSTJ0/qxIkTmjBhgiQ5\nZq6v44TZqqqqlJaWpl69esnn82n16tWOmOvLioqK9Mwzz6i+vj70h3DsOldSUpJaWlokSa2trerT\np48j5vrPf/4TmqF///46c+aM434Ov2DbIMfGxiohIUGS5Pf7NW7cOLW3t4cuW6SkpNj6YzvnzJmj\n5cuXKy8vzzFzFRYWKjc3N/S9U+aSpBMnTmjhwoX60Y9+pL/97W+OmO306dMKBoNauHChsrKyVFVV\n5Yi5vvDPf/5Td9xxh2JjY9W7d+/QcbvO9dBDD+nMmTOaNGmS5s6dqxUrVjhirnvuuUfvvfeeOjo6\n9NFHH+nUqVOqr693zM/hl9n6OWRJOnDggPx+v3bu3KnJkyeHjls2fzfX66+/rn/961/6xS9+cd0s\ndp1r3759GjFihO66666vvd2uc0nSt7/9bS1evFgPPvigTp06pfnz56ujoyN0u51na2lp0auvvqoz\nZ85o/vz5jvhZ/ILf79ejjz76leN2nWv//v3q16+fduzYoWPHjik7O1sez/99vKRd5xo/frxqamr0\n4x//WIMHD9bdd9+t48ePh26361xfx9ZBPnTokLZs2aLt27fL4/EoISFBwWBQ8fHxamhokM/n6+4t\nfmN1dXVKSUnRHXfcoXvvvVcdHR1KTEy0/VwHDx7UqVOndPDgQZ07d05ut9sR/70kqW/fvpo2bZqk\nzy+p3X777Tp69KjtZ0tJSdH9998vl8ul/v37KzExUbGxsbaf6wvV1dXKz89XTExM6FKvJNvOVVNT\no/T0dEnSkCFDdPnyZV29ejV0u13nkqTnnnsu9HVmZqb69u3rmJ/DL7PtJeuLFy9q7dq12rp1q/r0\n6SNJGjNmTOijOysrKzV27Nju3GJYjhw5op07d0r6/K9ntbW1OWKuDRs26M0339Qbb7yhmTNnatGi\nRY6YS/r8lcg7duyQJAUCAZ0/f16PPfaY7WdLT0/X4cOHde3aNTU3NzvmZ1H6PE6JiYlyu92Ki4vT\n3XffrSNHjkiy71wDBgxQbW2tJKm+vl6JiYkaNGiQ7ec6duyYnn/+eUnSu+++q/vuu88xP4f/n20/\nqausrEybN2/WwIEDQ8fWrFmj/Px8Xb58Wf369dNLL72kuLi4btzlNxcMBvXLX/5SZ8+eVTAY1OLF\nizV06FCtXLnS1nN92ebNm3XnnXcqPT3dEXN9+umnWr58uVpbW3XlyhUtXrxY9957ryNme/311+X3\n+yVJP/3pT5WamuqIuerq6rRhwwZt375d0uevAXjhhRd07do1DR8+PBQAO7l06ZLy8vJ0/vx5Xb16\nVcuWLZPX67X9XNeuXVNeXp5OnDih2267TevXr1dsbKwjfg7/P9sGGQAAJ7HtJWsAAJyEIAMAYACC\nDACAAQgyAAAGIMgAABiAIAMAYACCDACAAQgyAAAG+F/QpQOTip8rfAAAAABJRU5ErkJggg==\n",
            "text/plain": [
              "<Figure size 576x396 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "metadata": {
        "id": "8VpjwY0nz3h4",
        "colab_type": "code",
        "outputId": "7f3e5f09-b9ad-4eba-e095-afa3d5db5aa1",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 2635
        }
      },
      "cell_type": "code",
      "source": [
        "# Merge DataArray and Build a new DataSet\n",
        "DS_new = xr.Dataset()\n",
        "for _var in da_list:\n",
        "  exec(\"DS_new = xr.merge([DS_new,{}])\".format(_var))\n",
        "  \n",
        "DS_new"
      ],
      "execution_count": 72,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<xarray.Dataset>\n",
              "Dimensions:   (time: 131496)\n",
              "Coordinates:\n",
              "  * time      (time) datetime64[ns] 1996-01-01T00:30:00 ... 2010-12-31T23:30:00\n",
              "Data variables:\n",
              "    prec_sfc  (time) float64 nan nan nan nan nan nan ... nan nan nan nan nan nan\n",
              "    T_p1000   (time) float64 ...\n",
              "    T_p975    (time) float64 ...\n",
              "    T_p950    (time) float64 ...\n",
              "    T_p925    (time) float64 ...\n",
              "    T_p900    (time) float64 ...\n",
              "    T_p875    (time) float64 ...\n",
              "    T_p850    (time) float64 ...\n",
              "    T_p825    (time) float64 ...\n",
              "    T_p800    (time) float64 ...\n",
              "    T_p775    (time) float64 ...\n",
              "    T_p750    (time) float64 ...\n",
              "    T_p725    (time) float64 ...\n",
              "    T_p700    (time) float64 ...\n",
              "    T_p675    (time) float64 ...\n",
              "    T_p650    (time) float64 ...\n",
              "    T_p625    (time) float64 ...\n",
              "    T_p600    (time) float64 ...\n",
              "    T_p575    (time) float64 ...\n",
              "    T_p550    (time) float64 ...\n",
              "    T_p525    (time) float64 ...\n",
              "    T_p500    (time) float64 ...\n",
              "    T_p475    (time) float64 ...\n",
              "    T_p450    (time) float64 ...\n",
              "    T_p425    (time) float64 ...\n",
              "    T_p400    (time) float64 ...\n",
              "    T_p375    (time) float64 ...\n",
              "    T_p350    (time) float64 ...\n",
              "    T_p325    (time) float64 ...\n",
              "    T_p300    (time) float64 ...\n",
              "    T_p275    (time) float64 ...\n",
              "    T_p250    (time) float64 ...\n",
              "    T_p225    (time) float64 ...\n",
              "    T_p200    (time) float64 ...\n",
              "    T_p175    (time) float64 ...\n",
              "    T_p150    (time) float64 ...\n",
              "    T_p125    (time) float64 ...\n",
              "    T_p100    (time) float64 ...\n",
              "    rh_p1000  (time) float64 ...\n",
              "    rh_p975   (time) float64 ...\n",
              "    rh_p950   (time) float64 ...\n",
              "    rh_p925   (time) float64 ...\n",
              "    rh_p900   (time) float64 ...\n",
              "    rh_p875   (time) float64 ...\n",
              "    rh_p850   (time) float64 ...\n",
              "    rh_p825   (time) float64 ...\n",
              "    rh_p800   (time) float64 ...\n",
              "    rh_p775   (time) float64 ...\n",
              "    rh_p750   (time) float64 ...\n",
              "    rh_p725   (time) float64 ...\n",
              "    rh_p700   (time) float64 ...\n",
              "    rh_p675   (time) float64 ...\n",
              "    rh_p650   (time) float64 ...\n",
              "    rh_p625   (time) float64 ...\n",
              "    rh_p600   (time) float64 ...\n",
              "    rh_p575   (time) float64 ...\n",
              "    rh_p550   (time) float64 ...\n",
              "    rh_p525   (time) float64 ...\n",
              "    rh_p500   (time) float64 ...\n",
              "    rh_p475   (time) float64 ...\n",
              "    rh_p450   (time) float64 ...\n",
              "    rh_p425   (time) float64 ...\n",
              "    rh_p400   (time) float64 ...\n",
              "    rh_p375   (time) float64 ...\n",
              "    rh_p350   (time) float64 ...\n",
              "    rh_p325   (time) float64 ...\n",
              "    rh_p300   (time) float64 ...\n",
              "    rh_p275   (time) float64 ...\n",
              "    rh_p250   (time) float64 ...\n",
              "    rh_p225   (time) float64 ...\n",
              "    rh_p200   (time) float64 ...\n",
              "    rh_p175   (time) float64 ...\n",
              "    rh_p150   (time) float64 ...\n",
              "    rh_p125   (time) float64 ...\n",
              "    rh_p100   (time) float64 ...\n",
              "    u_p1000   (time) float64 ...\n",
              "    u_p975    (time) float64 ...\n",
              "    u_p950    (time) float64 ...\n",
              "    u_p925    (time) float64 ...\n",
              "    u_p900    (time) float64 ...\n",
              "    u_p875    (time) float64 ...\n",
              "    u_p850    (time) float64 ...\n",
              "    u_p825    (time) float64 ...\n",
              "    u_p800    (time) float64 ...\n",
              "    u_p775    (time) float64 ...\n",
              "    u_p750    (time) float64 ...\n",
              "    u_p725    (time) float64 ...\n",
              "    u_p700    (time) float64 ...\n",
              "    u_p675    (time) float64 ...\n",
              "    u_p650    (time) float64 ...\n",
              "    u_p625    (time) float64 ...\n",
              "    u_p600    (time) float64 ...\n",
              "    u_p575    (time) float64 ...\n",
              "    u_p550    (time) float64 ...\n",
              "    u_p525    (time) float64 ...\n",
              "    u_p500    (time) float64 ...\n",
              "    u_p475    (time) float64 ...\n",
              "    u_p450    (time) float64 ...\n",
              "    u_p425    (time) float64 ...\n",
              "    u_p400    (time) float64 ...\n",
              "    u_p375    (time) float64 ...\n",
              "    u_p350    (time) float64 ...\n",
              "    u_p325    (time) float64 ...\n",
              "    u_p300    (time) float64 ...\n",
              "    u_p275    (time) float64 ...\n",
              "    u_p250    (time) float64 ...\n",
              "    u_p225    (time) float64 ...\n",
              "    u_p200    (time) float64 ...\n",
              "    u_p175    (time) float64 ...\n",
              "    u_p150    (time) float64 ...\n",
              "    u_p125    (time) float64 ...\n",
              "    u_p100    (time) float64 ...\n",
              "    v_p1000   (time) float64 ...\n",
              "    v_p975    (time) float64 ...\n",
              "    v_p950    (time) float64 ...\n",
              "    v_p925    (time) float64 ...\n",
              "    v_p900    (time) float64 ...\n",
              "    v_p875    (time) float64 ...\n",
              "    v_p850    (time) float64 ...\n",
              "    v_p825    (time) float64 ...\n",
              "    v_p800    (time) float64 ...\n",
              "    v_p775    (time) float64 ...\n",
              "    v_p750    (time) float64 ...\n",
              "    v_p725    (time) float64 ...\n",
              "    v_p700    (time) float64 ...\n",
              "    v_p675    (time) float64 ...\n",
              "    v_p650    (time) float64 ...\n",
              "    v_p625    (time) float64 ...\n",
              "    v_p600    (time) float64 ...\n",
              "    v_p575    (time) float64 ...\n",
              "    v_p550    (time) float64 ...\n",
              "    v_p525    (time) float64 ...\n",
              "    v_p500    (time) float64 ...\n",
              "    v_p475    (time) float64 ...\n",
              "    v_p450    (time) float64 ...\n",
              "    v_p425    (time) float64 ...\n",
              "    v_p400    (time) float64 ...\n",
              "    v_p375    (time) float64 ...\n",
              "    v_p350    (time) float64 ...\n",
              "    v_p325    (time) float64 ...\n",
              "    v_p300    (time) float64 ...\n",
              "    v_p275    (time) float64 ...\n",
              "    v_p250    (time) float64 ...\n",
              "    v_p225    (time) float64 ...\n",
              "    v_p200    (time) float64 ...\n",
              "    v_p175    (time) float64 ...\n",
              "    v_p150    (time) float64 ...\n",
              "    v_p125    (time) float64 ...\n",
              "    v_p100    (time) float64 ..."
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 72
        }
      ]
    },
    {
      "metadata": {
        "id": "4tcr917vQy1T",
        "colab_type": "code",
        "outputId": "fb3026f5-6532-4084-c3fc-6a3539ef2a74",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "cell_type": "code",
      "source": [
        "# Convert DataSet to dataframe\n",
        "df = DS_new.to_dataframe().reset_index() # convert index (time) to a column\n",
        "\n",
        "# Find time difference between consecutive entries\n",
        "hour_delta = df['time'].astype(np.int64).rolling(window=2).apply(lambda j: j[1] - j[0]) / 10**9 / 3600\n",
        "for _hd in range(1,24+1):\n",
        "  _cnt = hour_delta[hour_delta==_hd].count()\n",
        "  if _cnt > 0:\n",
        "    print('hour_delta= {}, count= {}'.format(_hd,_cnt))"
      ],
      "execution_count": 73,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "hour_delta= 1, count= 131495\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "luT6u6CpdFCZ",
        "colab_type": "code",
        "outputId": "1709daf4-52dd-409a-9faa-9b44d6a20013",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 425
        }
      },
      "cell_type": "code",
      "source": [
        "# Find out the shift of the parameter (column) of interest that maximizes our non-NaN sample size\n",
        "\n",
        "for shift in range(1,24+1):\n",
        "  df_shift = df.copy() # deep copy\n",
        "  prec_sfc_next = df['prec_sfc'][shift:].values # turn to np values to get rid of index\n",
        "  for j in range(1,shift+1):\n",
        "    prec_sfc_next = np.append(prec_sfc_next,float('NaN')) # consistent length\n",
        "  df_shift.insert(loc=0, column='prec_sfc_next', value=prec_sfc_next) # insert the shifted column\n",
        "  print('#shifted hour= ' + str(shift) + ', sample size= ' + str((~df_shift.isnull().T.any()).sum()))"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "#shifted hour= 1, sample size= 4847\n",
            "#shifted hour= 2, sample size= 4848\n",
            "#shifted hour= 3, sample size= 4846\n",
            "#shifted hour= 4, sample size= 4845\n",
            "#shifted hour= 5, sample size= 4845\n",
            "#shifted hour= 6, sample size= 4843\n",
            "#shifted hour= 7, sample size= 4842\n",
            "#shifted hour= 8, sample size= 4841\n",
            "#shifted hour= 9, sample size= 4842\n",
            "#shifted hour= 10, sample size= 4841\n",
            "#shifted hour= 11, sample size= 4843\n",
            "#shifted hour= 12, sample size= 4840\n",
            "#shifted hour= 13, sample size= 4837\n",
            "#shifted hour= 14, sample size= 4836\n",
            "#shifted hour= 15, sample size= 4835\n",
            "#shifted hour= 16, sample size= 4835\n",
            "#shifted hour= 17, sample size= 4835\n",
            "#shifted hour= 18, sample size= 4835\n",
            "#shifted hour= 19, sample size= 4834\n",
            "#shifted hour= 20, sample size= 4831\n",
            "#shifted hour= 21, sample size= 4832\n",
            "#shifted hour= 22, sample size= 4832\n",
            "#shifted hour= 23, sample size= 4833\n",
            "#shifted hour= 24, sample size= 4829\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "e6R0OvuP-Cpn",
        "colab_type": "code",
        "outputId": "9731e1ca-ed05-4580-be45-bd3ea2e78df9",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 4046
        }
      },
      "cell_type": "code",
      "source": [
        "# Decided to take 1-hour shifted precipitation as labels\n",
        "\n",
        "prec_sfc_1hrlater = df['prec_sfc'][1:].values # ditto\n",
        "prec_sfc_1hrlater = np.append(prec_sfc_1hrlater,float('NaN')) \n",
        "try: # enable re-run\n",
        "  df.insert(loc=0, column='prec_sfc_1hrlater', value=prec_sfc_1hrlater)\n",
        "except:\n",
        "  print('Column prec_sfc_1hrlater has already inserted.')\n",
        "\n",
        "df_no_nan = df[~df.isnull().T.any()] # delete rows with incomplete data\n",
        "print('#shifted hour= ' + str(1) + ', sample size= ' + str(len(df_no_nan)) + ', it should match the previous')\n",
        "df_no_nan"
      ],
      "execution_count": 74,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "#shifted hour= 1, sample size= 4847, it should match the previous\n"
          ],
          "name": "stdout"
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>prec_sfc_1hrlater</th>\n",
              "      <th>time</th>\n",
              "      <th>prec_sfc</th>\n",
              "      <th>T_p1000</th>\n",
              "      <th>T_p975</th>\n",
              "      <th>T_p950</th>\n",
              "      <th>T_p925</th>\n",
              "      <th>T_p900</th>\n",
              "      <th>T_p875</th>\n",
              "      <th>T_p850</th>\n",
              "      <th>...</th>\n",
              "      <th>v_p325</th>\n",
              "      <th>v_p300</th>\n",
              "      <th>v_p275</th>\n",
              "      <th>v_p250</th>\n",
              "      <th>v_p225</th>\n",
              "      <th>v_p200</th>\n",
              "      <th>v_p175</th>\n",
              "      <th>v_p150</th>\n",
              "      <th>v_p125</th>\n",
              "      <th>v_p100</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>14524</th>\n",
              "      <td>0.049667</td>\n",
              "      <td>1997-08-28 04:30:00</td>\n",
              "      <td>0.047667</td>\n",
              "      <td>299.979401</td>\n",
              "      <td>297.850006</td>\n",
              "      <td>295.649994</td>\n",
              "      <td>294.116669</td>\n",
              "      <td>292.449982</td>\n",
              "      <td>291.121796</td>\n",
              "      <td>290.321411</td>\n",
              "      <td>...</td>\n",
              "      <td>-3.694841</td>\n",
              "      <td>-8.905457</td>\n",
              "      <td>-8.430822</td>\n",
              "      <td>-11.832866</td>\n",
              "      <td>-15.014605</td>\n",
              "      <td>-13.703352</td>\n",
              "      <td>-4.340648</td>\n",
              "      <td>3.429173</td>\n",
              "      <td>0.061024</td>\n",
              "      <td>-2.429142</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14758</th>\n",
              "      <td>0.050000</td>\n",
              "      <td>1997-09-06 22:30:00</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>299.540466</td>\n",
              "      <td>297.363037</td>\n",
              "      <td>295.245453</td>\n",
              "      <td>294.180420</td>\n",
              "      <td>295.295441</td>\n",
              "      <td>292.979156</td>\n",
              "      <td>290.387482</td>\n",
              "      <td>...</td>\n",
              "      <td>3.635570</td>\n",
              "      <td>0.696846</td>\n",
              "      <td>-5.836888</td>\n",
              "      <td>-6.929137</td>\n",
              "      <td>-16.164400</td>\n",
              "      <td>-16.350965</td>\n",
              "      <td>-8.582373</td>\n",
              "      <td>2.699558</td>\n",
              "      <td>1.369764</td>\n",
              "      <td>2.531068</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14782</th>\n",
              "      <td>0.050492</td>\n",
              "      <td>1997-09-07 22:30:00</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>300.308807</td>\n",
              "      <td>297.945831</td>\n",
              "      <td>295.690002</td>\n",
              "      <td>293.509094</td>\n",
              "      <td>291.936371</td>\n",
              "      <td>292.528259</td>\n",
              "      <td>291.256226</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.570785</td>\n",
              "      <td>-6.294807</td>\n",
              "      <td>-5.568968</td>\n",
              "      <td>-2.439126</td>\n",
              "      <td>-3.171939</td>\n",
              "      <td>-3.827843</td>\n",
              "      <td>-1.925839</td>\n",
              "      <td>0.171745</td>\n",
              "      <td>4.252823</td>\n",
              "      <td>0.654523</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15046</th>\n",
              "      <td>0.050000</td>\n",
              "      <td>1997-09-18 22:30:00</td>\n",
              "      <td>0.051311</td>\n",
              "      <td>299.845459</td>\n",
              "      <td>297.649994</td>\n",
              "      <td>295.542297</td>\n",
              "      <td>293.750000</td>\n",
              "      <td>292.582153</td>\n",
              "      <td>292.483337</td>\n",
              "      <td>290.667236</td>\n",
              "      <td>...</td>\n",
              "      <td>-1.414140</td>\n",
              "      <td>-6.250647</td>\n",
              "      <td>-13.632689</td>\n",
              "      <td>-19.243462</td>\n",
              "      <td>-23.677080</td>\n",
              "      <td>-24.335115</td>\n",
              "      <td>-17.825041</td>\n",
              "      <td>-12.481750</td>\n",
              "      <td>3.124845</td>\n",
              "      <td>1.017899</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15142</th>\n",
              "      <td>0.050000</td>\n",
              "      <td>1997-09-22 22:30:00</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>299.509094</td>\n",
              "      <td>297.286346</td>\n",
              "      <td>295.541656</td>\n",
              "      <td>294.620270</td>\n",
              "      <td>292.957153</td>\n",
              "      <td>291.267487</td>\n",
              "      <td>290.323151</td>\n",
              "      <td>...</td>\n",
              "      <td>-2.055194</td>\n",
              "      <td>-0.635155</td>\n",
              "      <td>0.038826</td>\n",
              "      <td>-0.884923</td>\n",
              "      <td>-3.075891</td>\n",
              "      <td>-3.622608</td>\n",
              "      <td>-4.358087</td>\n",
              "      <td>-0.225894</td>\n",
              "      <td>1.109643</td>\n",
              "      <td>-4.608153</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15166</th>\n",
              "      <td>0.050000</td>\n",
              "      <td>1997-09-23 22:30:00</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>299.473816</td>\n",
              "      <td>297.358337</td>\n",
              "      <td>295.208313</td>\n",
              "      <td>293.661438</td>\n",
              "      <td>293.036835</td>\n",
              "      <td>291.484985</td>\n",
              "      <td>290.468597</td>\n",
              "      <td>...</td>\n",
              "      <td>-1.871192</td>\n",
              "      <td>0.079552</td>\n",
              "      <td>1.479049</td>\n",
              "      <td>-2.326284</td>\n",
              "      <td>-11.745255</td>\n",
              "      <td>-13.823651</td>\n",
              "      <td>-8.587365</td>\n",
              "      <td>-0.627821</td>\n",
              "      <td>4.487830</td>\n",
              "      <td>-2.143723</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15214</th>\n",
              "      <td>0.045902</td>\n",
              "      <td>1997-09-25 22:30:00</td>\n",
              "      <td>0.980678</td>\n",
              "      <td>299.505005</td>\n",
              "      <td>297.845642</td>\n",
              "      <td>296.184784</td>\n",
              "      <td>295.038452</td>\n",
              "      <td>293.588470</td>\n",
              "      <td>291.712067</td>\n",
              "      <td>290.653229</td>\n",
              "      <td>...</td>\n",
              "      <td>7.619709</td>\n",
              "      <td>7.176747</td>\n",
              "      <td>4.833903</td>\n",
              "      <td>-1.715490</td>\n",
              "      <td>-1.584804</td>\n",
              "      <td>-2.180600</td>\n",
              "      <td>-5.345045</td>\n",
              "      <td>6.249083</td>\n",
              "      <td>7.325176</td>\n",
              "      <td>0.537335</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15238</th>\n",
              "      <td>0.050000</td>\n",
              "      <td>1997-09-26 22:30:00</td>\n",
              "      <td>0.048197</td>\n",
              "      <td>300.169037</td>\n",
              "      <td>297.968170</td>\n",
              "      <td>296.011902</td>\n",
              "      <td>294.509094</td>\n",
              "      <td>293.063629</td>\n",
              "      <td>292.125000</td>\n",
              "      <td>290.736847</td>\n",
              "      <td>...</td>\n",
              "      <td>-3.801949</td>\n",
              "      <td>-1.510288</td>\n",
              "      <td>-0.065602</td>\n",
              "      <td>1.140482</td>\n",
              "      <td>1.721500</td>\n",
              "      <td>0.712793</td>\n",
              "      <td>-1.762484</td>\n",
              "      <td>-5.165653</td>\n",
              "      <td>-5.962721</td>\n",
              "      <td>-3.889105</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15286</th>\n",
              "      <td>0.057627</td>\n",
              "      <td>1997-09-28 22:30:00</td>\n",
              "      <td>0.050339</td>\n",
              "      <td>299.997833</td>\n",
              "      <td>297.831818</td>\n",
              "      <td>296.725006</td>\n",
              "      <td>295.858582</td>\n",
              "      <td>294.429413</td>\n",
              "      <td>293.002930</td>\n",
              "      <td>291.541412</td>\n",
              "      <td>...</td>\n",
              "      <td>0.789057</td>\n",
              "      <td>-4.094765</td>\n",
              "      <td>-8.825696</td>\n",
              "      <td>-11.111882</td>\n",
              "      <td>-13.857169</td>\n",
              "      <td>-13.698687</td>\n",
              "      <td>-9.175197</td>\n",
              "      <td>-2.952761</td>\n",
              "      <td>-4.772560</td>\n",
              "      <td>-6.912055</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15382</th>\n",
              "      <td>0.050000</td>\n",
              "      <td>1997-10-02 22:30:00</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>299.795441</td>\n",
              "      <td>297.564270</td>\n",
              "      <td>295.384979</td>\n",
              "      <td>293.574982</td>\n",
              "      <td>292.259094</td>\n",
              "      <td>291.237488</td>\n",
              "      <td>290.362000</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.079788</td>\n",
              "      <td>-3.749264</td>\n",
              "      <td>-5.678204</td>\n",
              "      <td>-9.683691</td>\n",
              "      <td>-10.290372</td>\n",
              "      <td>1.890432</td>\n",
              "      <td>9.836006</td>\n",
              "      <td>9.294689</td>\n",
              "      <td>-3.343925</td>\n",
              "      <td>-8.170444</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15454</th>\n",
              "      <td>0.050164</td>\n",
              "      <td>1997-10-05 22:30:00</td>\n",
              "      <td>0.050820</td>\n",
              "      <td>299.802612</td>\n",
              "      <td>297.545227</td>\n",
              "      <td>295.835724</td>\n",
              "      <td>294.717743</td>\n",
              "      <td>294.001984</td>\n",
              "      <td>292.545654</td>\n",
              "      <td>290.621429</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.574042</td>\n",
              "      <td>-1.214316</td>\n",
              "      <td>-4.495208</td>\n",
              "      <td>-7.807476</td>\n",
              "      <td>-8.506917</td>\n",
              "      <td>-9.347400</td>\n",
              "      <td>-5.561154</td>\n",
              "      <td>3.231571</td>\n",
              "      <td>7.453132</td>\n",
              "      <td>-4.492843</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15622</th>\n",
              "      <td>0.050000</td>\n",
              "      <td>1997-10-12 22:30:00</td>\n",
              "      <td>0.043279</td>\n",
              "      <td>299.514709</td>\n",
              "      <td>297.464294</td>\n",
              "      <td>295.928253</td>\n",
              "      <td>294.521423</td>\n",
              "      <td>293.195007</td>\n",
              "      <td>291.138000</td>\n",
              "      <td>289.975006</td>\n",
              "      <td>...</td>\n",
              "      <td>-1.716966</td>\n",
              "      <td>-3.833446</td>\n",
              "      <td>-4.791119</td>\n",
              "      <td>-5.502052</td>\n",
              "      <td>-6.485824</td>\n",
              "      <td>-8.174824</td>\n",
              "      <td>-11.204121</td>\n",
              "      <td>-8.862458</td>\n",
              "      <td>2.027360</td>\n",
              "      <td>2.486079</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15646</th>\n",
              "      <td>1.541148</td>\n",
              "      <td>1997-10-13 22:30:00</td>\n",
              "      <td>0.095082</td>\n",
              "      <td>300.856659</td>\n",
              "      <td>298.465790</td>\n",
              "      <td>296.278564</td>\n",
              "      <td>294.549988</td>\n",
              "      <td>293.359528</td>\n",
              "      <td>291.622711</td>\n",
              "      <td>290.095459</td>\n",
              "      <td>...</td>\n",
              "      <td>6.148317</td>\n",
              "      <td>1.874338</td>\n",
              "      <td>-1.785443</td>\n",
              "      <td>-6.252535</td>\n",
              "      <td>-6.364130</td>\n",
              "      <td>-6.491885</td>\n",
              "      <td>-9.787130</td>\n",
              "      <td>-8.186864</td>\n",
              "      <td>1.077030</td>\n",
              "      <td>3.526639</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15670</th>\n",
              "      <td>0.047869</td>\n",
              "      <td>1997-10-14 22:30:00</td>\n",
              "      <td>0.049508</td>\n",
              "      <td>300.507874</td>\n",
              "      <td>298.218170</td>\n",
              "      <td>296.149994</td>\n",
              "      <td>294.428253</td>\n",
              "      <td>292.867371</td>\n",
              "      <td>291.667389</td>\n",
              "      <td>290.199982</td>\n",
              "      <td>...</td>\n",
              "      <td>0.186238</td>\n",
              "      <td>-0.826191</td>\n",
              "      <td>-2.395772</td>\n",
              "      <td>-8.527872</td>\n",
              "      <td>-10.473539</td>\n",
              "      <td>-8.262249</td>\n",
              "      <td>-5.635159</td>\n",
              "      <td>-0.867642</td>\n",
              "      <td>7.614470</td>\n",
              "      <td>0.054471</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15694</th>\n",
              "      <td>0.050000</td>\n",
              "      <td>1997-10-15 22:30:00</td>\n",
              "      <td>0.049180</td>\n",
              "      <td>300.602936</td>\n",
              "      <td>298.484985</td>\n",
              "      <td>296.323669</td>\n",
              "      <td>294.240479</td>\n",
              "      <td>292.649994</td>\n",
              "      <td>291.318176</td>\n",
              "      <td>289.783325</td>\n",
              "      <td>...</td>\n",
              "      <td>-3.006945</td>\n",
              "      <td>-2.858124</td>\n",
              "      <td>-2.728866</td>\n",
              "      <td>-4.143253</td>\n",
              "      <td>-6.146730</td>\n",
              "      <td>-5.743268</td>\n",
              "      <td>-6.115375</td>\n",
              "      <td>-4.539102</td>\n",
              "      <td>0.859108</td>\n",
              "      <td>-2.470370</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15766</th>\n",
              "      <td>0.044576</td>\n",
              "      <td>1997-10-18 22:30:00</td>\n",
              "      <td>0.048688</td>\n",
              "      <td>300.165771</td>\n",
              "      <td>298.068176</td>\n",
              "      <td>296.057678</td>\n",
              "      <td>295.224182</td>\n",
              "      <td>293.449982</td>\n",
              "      <td>291.912170</td>\n",
              "      <td>290.769989</td>\n",
              "      <td>...</td>\n",
              "      <td>-4.457522</td>\n",
              "      <td>-5.280304</td>\n",
              "      <td>-8.256284</td>\n",
              "      <td>-11.077329</td>\n",
              "      <td>-10.390654</td>\n",
              "      <td>-12.399014</td>\n",
              "      <td>-18.003187</td>\n",
              "      <td>-17.675085</td>\n",
              "      <td>-9.244912</td>\n",
              "      <td>-1.914489</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15886</th>\n",
              "      <td>0.049672</td>\n",
              "      <td>1997-10-23 22:30:00</td>\n",
              "      <td>0.049836</td>\n",
              "      <td>300.943756</td>\n",
              "      <td>298.576080</td>\n",
              "      <td>296.406525</td>\n",
              "      <td>294.787018</td>\n",
              "      <td>293.208069</td>\n",
              "      <td>291.227783</td>\n",
              "      <td>290.411285</td>\n",
              "      <td>...</td>\n",
              "      <td>0.868040</td>\n",
              "      <td>-0.826427</td>\n",
              "      <td>-3.866060</td>\n",
              "      <td>-4.795523</td>\n",
              "      <td>-8.622511</td>\n",
              "      <td>-11.028801</td>\n",
              "      <td>-13.859491</td>\n",
              "      <td>-7.205518</td>\n",
              "      <td>-1.394403</td>\n",
              "      <td>3.815901</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15910</th>\n",
              "      <td>0.050000</td>\n",
              "      <td>1997-10-24 22:30:00</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>300.208801</td>\n",
              "      <td>298.164276</td>\n",
              "      <td>296.140900</td>\n",
              "      <td>294.395447</td>\n",
              "      <td>293.202148</td>\n",
              "      <td>292.658691</td>\n",
              "      <td>291.162506</td>\n",
              "      <td>...</td>\n",
              "      <td>-2.650353</td>\n",
              "      <td>-1.625398</td>\n",
              "      <td>-3.184672</td>\n",
              "      <td>-2.637162</td>\n",
              "      <td>-5.807591</td>\n",
              "      <td>-7.695199</td>\n",
              "      <td>-7.138307</td>\n",
              "      <td>-9.210431</td>\n",
              "      <td>-0.537811</td>\n",
              "      <td>2.243870</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15934</th>\n",
              "      <td>32.556438</td>\n",
              "      <td>1997-10-25 22:30:00</td>\n",
              "      <td>0.610656</td>\n",
              "      <td>299.818756</td>\n",
              "      <td>298.164276</td>\n",
              "      <td>296.106506</td>\n",
              "      <td>294.350006</td>\n",
              "      <td>292.781799</td>\n",
              "      <td>291.410858</td>\n",
              "      <td>290.007690</td>\n",
              "      <td>...</td>\n",
              "      <td>1.443448</td>\n",
              "      <td>2.590680</td>\n",
              "      <td>-2.639284</td>\n",
              "      <td>-7.213702</td>\n",
              "      <td>-6.434023</td>\n",
              "      <td>-3.483778</td>\n",
              "      <td>-1.567073</td>\n",
              "      <td>2.979946</td>\n",
              "      <td>3.114442</td>\n",
              "      <td>-2.303572</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16030</th>\n",
              "      <td>0.050833</td>\n",
              "      <td>1997-10-29 22:30:00</td>\n",
              "      <td>0.050339</td>\n",
              "      <td>300.908813</td>\n",
              "      <td>298.549988</td>\n",
              "      <td>296.371033</td>\n",
              "      <td>295.130951</td>\n",
              "      <td>293.760529</td>\n",
              "      <td>292.280426</td>\n",
              "      <td>290.934998</td>\n",
              "      <td>...</td>\n",
              "      <td>1.080005</td>\n",
              "      <td>0.632882</td>\n",
              "      <td>-0.582796</td>\n",
              "      <td>1.365543</td>\n",
              "      <td>-1.650876</td>\n",
              "      <td>-4.842235</td>\n",
              "      <td>-5.374320</td>\n",
              "      <td>-3.026091</td>\n",
              "      <td>4.781385</td>\n",
              "      <td>5.994557</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16078</th>\n",
              "      <td>0.050000</td>\n",
              "      <td>1997-10-31 22:30:00</td>\n",
              "      <td>0.050492</td>\n",
              "      <td>301.032349</td>\n",
              "      <td>298.813141</td>\n",
              "      <td>296.565002</td>\n",
              "      <td>294.777252</td>\n",
              "      <td>294.284790</td>\n",
              "      <td>293.236938</td>\n",
              "      <td>291.727264</td>\n",
              "      <td>...</td>\n",
              "      <td>5.616391</td>\n",
              "      <td>3.951925</td>\n",
              "      <td>0.819317</td>\n",
              "      <td>-1.160635</td>\n",
              "      <td>-1.667662</td>\n",
              "      <td>1.499117</td>\n",
              "      <td>4.633341</td>\n",
              "      <td>-0.464859</td>\n",
              "      <td>-0.443762</td>\n",
              "      <td>-5.399498</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16102</th>\n",
              "      <td>0.091803</td>\n",
              "      <td>1997-11-01 22:30:00</td>\n",
              "      <td>0.047288</td>\n",
              "      <td>300.470001</td>\n",
              "      <td>298.424988</td>\n",
              "      <td>296.426910</td>\n",
              "      <td>294.510712</td>\n",
              "      <td>292.824982</td>\n",
              "      <td>291.129150</td>\n",
              "      <td>290.260803</td>\n",
              "      <td>...</td>\n",
              "      <td>3.151057</td>\n",
              "      <td>10.231236</td>\n",
              "      <td>8.192634</td>\n",
              "      <td>1.463737</td>\n",
              "      <td>0.623486</td>\n",
              "      <td>-2.026322</td>\n",
              "      <td>-3.262095</td>\n",
              "      <td>-0.210679</td>\n",
              "      <td>-2.721932</td>\n",
              "      <td>-8.680048</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16132</th>\n",
              "      <td>0.050000</td>\n",
              "      <td>1997-11-03 04:30:00</td>\n",
              "      <td>0.053279</td>\n",
              "      <td>300.565796</td>\n",
              "      <td>298.458313</td>\n",
              "      <td>296.389130</td>\n",
              "      <td>294.078003</td>\n",
              "      <td>292.529175</td>\n",
              "      <td>291.416656</td>\n",
              "      <td>290.725006</td>\n",
              "      <td>...</td>\n",
              "      <td>11.643619</td>\n",
              "      <td>6.315861</td>\n",
              "      <td>3.471717</td>\n",
              "      <td>-1.352153</td>\n",
              "      <td>-8.550925</td>\n",
              "      <td>-11.392529</td>\n",
              "      <td>-16.661461</td>\n",
              "      <td>-10.058272</td>\n",
              "      <td>-3.688515</td>\n",
              "      <td>-10.134279</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16156</th>\n",
              "      <td>0.050000</td>\n",
              "      <td>1997-11-04 04:30:00</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>301.267639</td>\n",
              "      <td>298.919983</td>\n",
              "      <td>296.750000</td>\n",
              "      <td>294.759094</td>\n",
              "      <td>293.142303</td>\n",
              "      <td>292.990723</td>\n",
              "      <td>291.739990</td>\n",
              "      <td>...</td>\n",
              "      <td>3.801957</td>\n",
              "      <td>6.310259</td>\n",
              "      <td>2.638773</td>\n",
              "      <td>2.094060</td>\n",
              "      <td>-0.614813</td>\n",
              "      <td>-4.257584</td>\n",
              "      <td>-14.277884</td>\n",
              "      <td>-11.061947</td>\n",
              "      <td>-4.462640</td>\n",
              "      <td>4.856185</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16174</th>\n",
              "      <td>0.050000</td>\n",
              "      <td>1997-11-04 22:30:00</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>300.281586</td>\n",
              "      <td>298.009094</td>\n",
              "      <td>296.697601</td>\n",
              "      <td>296.794983</td>\n",
              "      <td>295.294983</td>\n",
              "      <td>293.063629</td>\n",
              "      <td>291.802368</td>\n",
              "      <td>...</td>\n",
              "      <td>5.356645</td>\n",
              "      <td>3.792663</td>\n",
              "      <td>-0.134115</td>\n",
              "      <td>1.908189</td>\n",
              "      <td>3.849470</td>\n",
              "      <td>0.664804</td>\n",
              "      <td>1.043680</td>\n",
              "      <td>3.859556</td>\n",
              "      <td>13.751688</td>\n",
              "      <td>14.851539</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16198</th>\n",
              "      <td>0.050000</td>\n",
              "      <td>1997-11-05 22:30:00</td>\n",
              "      <td>0.051017</td>\n",
              "      <td>300.415009</td>\n",
              "      <td>298.329987</td>\n",
              "      <td>296.453979</td>\n",
              "      <td>294.949982</td>\n",
              "      <td>293.901520</td>\n",
              "      <td>292.477783</td>\n",
              "      <td>291.570587</td>\n",
              "      <td>...</td>\n",
              "      <td>2.131374</td>\n",
              "      <td>2.361863</td>\n",
              "      <td>-2.466990</td>\n",
              "      <td>-5.663918</td>\n",
              "      <td>-5.290195</td>\n",
              "      <td>-5.992301</td>\n",
              "      <td>4.825192</td>\n",
              "      <td>14.319605</td>\n",
              "      <td>18.801739</td>\n",
              "      <td>14.490557</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16270</th>\n",
              "      <td>0.050656</td>\n",
              "      <td>1997-11-08 22:30:00</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>300.494995</td>\n",
              "      <td>298.280426</td>\n",
              "      <td>296.654541</td>\n",
              "      <td>295.273804</td>\n",
              "      <td>293.783325</td>\n",
              "      <td>292.183319</td>\n",
              "      <td>290.821991</td>\n",
              "      <td>...</td>\n",
              "      <td>2.375225</td>\n",
              "      <td>-0.027572</td>\n",
              "      <td>-7.857867</td>\n",
              "      <td>-9.601642</td>\n",
              "      <td>2.119840</td>\n",
              "      <td>6.715693</td>\n",
              "      <td>5.654685</td>\n",
              "      <td>3.195407</td>\n",
              "      <td>5.843157</td>\n",
              "      <td>-0.166409</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16294</th>\n",
              "      <td>0.050164</td>\n",
              "      <td>1997-11-09 22:30:00</td>\n",
              "      <td>0.050820</td>\n",
              "      <td>300.195007</td>\n",
              "      <td>298.273804</td>\n",
              "      <td>296.470001</td>\n",
              "      <td>294.904999</td>\n",
              "      <td>293.259521</td>\n",
              "      <td>291.754547</td>\n",
              "      <td>290.523895</td>\n",
              "      <td>...</td>\n",
              "      <td>-1.774813</td>\n",
              "      <td>-5.731592</td>\n",
              "      <td>-0.598125</td>\n",
              "      <td>2.603852</td>\n",
              "      <td>4.247229</td>\n",
              "      <td>8.932425</td>\n",
              "      <td>3.984121</td>\n",
              "      <td>-0.770112</td>\n",
              "      <td>-1.057764</td>\n",
              "      <td>3.122505</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16366</th>\n",
              "      <td>0.056721</td>\n",
              "      <td>1997-11-12 22:30:00</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>300.975006</td>\n",
              "      <td>298.790894</td>\n",
              "      <td>296.812500</td>\n",
              "      <td>295.623901</td>\n",
              "      <td>294.098145</td>\n",
              "      <td>292.432129</td>\n",
              "      <td>290.649994</td>\n",
              "      <td>...</td>\n",
              "      <td>11.209023</td>\n",
              "      <td>11.216011</td>\n",
              "      <td>7.005546</td>\n",
              "      <td>5.277328</td>\n",
              "      <td>2.624231</td>\n",
              "      <td>-1.778901</td>\n",
              "      <td>-5.347286</td>\n",
              "      <td>-8.114300</td>\n",
              "      <td>-2.317430</td>\n",
              "      <td>-4.718018</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16390</th>\n",
              "      <td>0.051148</td>\n",
              "      <td>1997-11-13 22:30:00</td>\n",
              "      <td>0.049836</td>\n",
              "      <td>300.549988</td>\n",
              "      <td>298.460510</td>\n",
              "      <td>296.309998</td>\n",
              "      <td>294.411102</td>\n",
              "      <td>293.104553</td>\n",
              "      <td>292.350006</td>\n",
              "      <td>291.479156</td>\n",
              "      <td>...</td>\n",
              "      <td>-1.020682</td>\n",
              "      <td>-5.541191</td>\n",
              "      <td>-5.142968</td>\n",
              "      <td>-1.490302</td>\n",
              "      <td>1.991504</td>\n",
              "      <td>1.546775</td>\n",
              "      <td>-1.783376</td>\n",
              "      <td>-5.431945</td>\n",
              "      <td>-3.920298</td>\n",
              "      <td>3.254073</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128027</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-09 11:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.631409</td>\n",
              "      <td>298.882263</td>\n",
              "      <td>297.089996</td>\n",
              "      <td>295.360260</td>\n",
              "      <td>293.808746</td>\n",
              "      <td>292.428986</td>\n",
              "      <td>291.301575</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.143740</td>\n",
              "      <td>3.248850</td>\n",
              "      <td>3.716591</td>\n",
              "      <td>4.709014</td>\n",
              "      <td>6.653915</td>\n",
              "      <td>8.348306</td>\n",
              "      <td>5.416325</td>\n",
              "      <td>0.043322</td>\n",
              "      <td>2.781286</td>\n",
              "      <td>1.592121</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128039</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-09 23:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.699554</td>\n",
              "      <td>299.127502</td>\n",
              "      <td>297.638702</td>\n",
              "      <td>295.712952</td>\n",
              "      <td>294.315796</td>\n",
              "      <td>292.220581</td>\n",
              "      <td>290.664368</td>\n",
              "      <td>...</td>\n",
              "      <td>6.086284</td>\n",
              "      <td>5.853918</td>\n",
              "      <td>7.830789</td>\n",
              "      <td>7.354771</td>\n",
              "      <td>6.856345</td>\n",
              "      <td>4.907825</td>\n",
              "      <td>3.785929</td>\n",
              "      <td>-1.433738</td>\n",
              "      <td>4.648457</td>\n",
              "      <td>0.695950</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128051</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-10 11:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.874481</td>\n",
              "      <td>299.201996</td>\n",
              "      <td>297.684540</td>\n",
              "      <td>295.986938</td>\n",
              "      <td>294.117706</td>\n",
              "      <td>292.197388</td>\n",
              "      <td>290.749237</td>\n",
              "      <td>...</td>\n",
              "      <td>-1.461149</td>\n",
              "      <td>-1.076025</td>\n",
              "      <td>-4.048060</td>\n",
              "      <td>-2.313075</td>\n",
              "      <td>-0.454277</td>\n",
              "      <td>-0.641948</td>\n",
              "      <td>0.680149</td>\n",
              "      <td>2.261919</td>\n",
              "      <td>3.942022</td>\n",
              "      <td>4.910818</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128063</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-10 23:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.850006</td>\n",
              "      <td>298.523315</td>\n",
              "      <td>296.585632</td>\n",
              "      <td>295.301666</td>\n",
              "      <td>294.201385</td>\n",
              "      <td>293.239349</td>\n",
              "      <td>292.195160</td>\n",
              "      <td>...</td>\n",
              "      <td>-2.788443</td>\n",
              "      <td>-4.080852</td>\n",
              "      <td>-4.587708</td>\n",
              "      <td>-2.693874</td>\n",
              "      <td>0.858664</td>\n",
              "      <td>1.845596</td>\n",
              "      <td>-0.012737</td>\n",
              "      <td>1.149589</td>\n",
              "      <td>5.140675</td>\n",
              "      <td>1.464196</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128075</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-11 11:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.403992</td>\n",
              "      <td>298.693146</td>\n",
              "      <td>297.033508</td>\n",
              "      <td>295.952362</td>\n",
              "      <td>294.550476</td>\n",
              "      <td>293.125458</td>\n",
              "      <td>291.579071</td>\n",
              "      <td>...</td>\n",
              "      <td>-3.991415</td>\n",
              "      <td>-4.477642</td>\n",
              "      <td>-3.600425</td>\n",
              "      <td>-2.627179</td>\n",
              "      <td>0.387704</td>\n",
              "      <td>0.727637</td>\n",
              "      <td>-0.955489</td>\n",
              "      <td>-0.982771</td>\n",
              "      <td>2.768246</td>\n",
              "      <td>-0.841986</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128087</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-11 23:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>301.536194</td>\n",
              "      <td>299.602814</td>\n",
              "      <td>297.543915</td>\n",
              "      <td>295.783112</td>\n",
              "      <td>294.198425</td>\n",
              "      <td>293.192413</td>\n",
              "      <td>291.952087</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.736046</td>\n",
              "      <td>-0.436770</td>\n",
              "      <td>0.551084</td>\n",
              "      <td>-1.568495</td>\n",
              "      <td>0.330352</td>\n",
              "      <td>-1.459406</td>\n",
              "      <td>-5.015362</td>\n",
              "      <td>2.486673</td>\n",
              "      <td>-0.348639</td>\n",
              "      <td>-0.261705</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128100</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-12 12:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.242371</td>\n",
              "      <td>298.390900</td>\n",
              "      <td>296.937592</td>\n",
              "      <td>295.334442</td>\n",
              "      <td>293.703217</td>\n",
              "      <td>292.228271</td>\n",
              "      <td>290.313599</td>\n",
              "      <td>...</td>\n",
              "      <td>1.092464</td>\n",
              "      <td>1.341130</td>\n",
              "      <td>-0.634546</td>\n",
              "      <td>0.655195</td>\n",
              "      <td>0.281414</td>\n",
              "      <td>-0.233786</td>\n",
              "      <td>2.998835</td>\n",
              "      <td>4.820245</td>\n",
              "      <td>-0.751912</td>\n",
              "      <td>4.886592</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128111</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-12 23:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.141357</td>\n",
              "      <td>297.785645</td>\n",
              "      <td>296.367004</td>\n",
              "      <td>294.661499</td>\n",
              "      <td>293.582550</td>\n",
              "      <td>292.671661</td>\n",
              "      <td>291.666260</td>\n",
              "      <td>...</td>\n",
              "      <td>3.012034</td>\n",
              "      <td>-0.472823</td>\n",
              "      <td>1.751277</td>\n",
              "      <td>3.161802</td>\n",
              "      <td>4.943165</td>\n",
              "      <td>6.822298</td>\n",
              "      <td>10.159986</td>\n",
              "      <td>11.083560</td>\n",
              "      <td>4.262793</td>\n",
              "      <td>5.660259</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128123</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-13 11:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>299.371826</td>\n",
              "      <td>297.868744</td>\n",
              "      <td>296.454407</td>\n",
              "      <td>295.027313</td>\n",
              "      <td>293.340302</td>\n",
              "      <td>291.575714</td>\n",
              "      <td>290.724548</td>\n",
              "      <td>...</td>\n",
              "      <td>-2.764803</td>\n",
              "      <td>-2.558042</td>\n",
              "      <td>1.302029</td>\n",
              "      <td>6.372724</td>\n",
              "      <td>5.871500</td>\n",
              "      <td>5.671649</td>\n",
              "      <td>7.892204</td>\n",
              "      <td>7.053923</td>\n",
              "      <td>2.191829</td>\n",
              "      <td>-0.451303</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128135</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-13 23:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.439087</td>\n",
              "      <td>298.313324</td>\n",
              "      <td>297.104797</td>\n",
              "      <td>296.042175</td>\n",
              "      <td>294.320007</td>\n",
              "      <td>292.496674</td>\n",
              "      <td>290.972076</td>\n",
              "      <td>...</td>\n",
              "      <td>0.781096</td>\n",
              "      <td>-1.544967</td>\n",
              "      <td>-1.138334</td>\n",
              "      <td>-1.164169</td>\n",
              "      <td>1.023019</td>\n",
              "      <td>0.777334</td>\n",
              "      <td>-1.789608</td>\n",
              "      <td>1.681504</td>\n",
              "      <td>3.765103</td>\n",
              "      <td>2.346743</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128148</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-14 12:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.845001</td>\n",
              "      <td>298.932617</td>\n",
              "      <td>296.899200</td>\n",
              "      <td>295.289581</td>\n",
              "      <td>295.262909</td>\n",
              "      <td>294.059021</td>\n",
              "      <td>293.634979</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.156123</td>\n",
              "      <td>-0.069101</td>\n",
              "      <td>0.579056</td>\n",
              "      <td>0.151105</td>\n",
              "      <td>-0.004582</td>\n",
              "      <td>-2.974836</td>\n",
              "      <td>-6.811464</td>\n",
              "      <td>0.281898</td>\n",
              "      <td>3.310838</td>\n",
              "      <td>-6.220196</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128159</th>\n",
              "      <td>0.010770</td>\n",
              "      <td>2010-08-14 23:30:00</td>\n",
              "      <td>0.007050</td>\n",
              "      <td>301.403564</td>\n",
              "      <td>299.096466</td>\n",
              "      <td>297.235321</td>\n",
              "      <td>295.617004</td>\n",
              "      <td>294.094208</td>\n",
              "      <td>292.934387</td>\n",
              "      <td>291.822937</td>\n",
              "      <td>...</td>\n",
              "      <td>-6.108386</td>\n",
              "      <td>-2.666012</td>\n",
              "      <td>0.511577</td>\n",
              "      <td>0.615649</td>\n",
              "      <td>-0.024289</td>\n",
              "      <td>-0.514866</td>\n",
              "      <td>-3.309121</td>\n",
              "      <td>-7.458372</td>\n",
              "      <td>-6.925994</td>\n",
              "      <td>-0.951789</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128171</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-15 11:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>301.417999</td>\n",
              "      <td>299.464752</td>\n",
              "      <td>297.452759</td>\n",
              "      <td>296.888153</td>\n",
              "      <td>295.098511</td>\n",
              "      <td>293.342346</td>\n",
              "      <td>292.059143</td>\n",
              "      <td>...</td>\n",
              "      <td>1.691359</td>\n",
              "      <td>-2.849754</td>\n",
              "      <td>-6.070728</td>\n",
              "      <td>-6.754097</td>\n",
              "      <td>-5.116881</td>\n",
              "      <td>-7.626099</td>\n",
              "      <td>-8.840965</td>\n",
              "      <td>-6.325871</td>\n",
              "      <td>5.442287</td>\n",
              "      <td>0.188584</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128183</th>\n",
              "      <td>0.000770</td>\n",
              "      <td>2010-08-15 23:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>302.043976</td>\n",
              "      <td>299.653137</td>\n",
              "      <td>297.534454</td>\n",
              "      <td>295.641296</td>\n",
              "      <td>294.385895</td>\n",
              "      <td>293.125519</td>\n",
              "      <td>291.535675</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.191065</td>\n",
              "      <td>-1.732803</td>\n",
              "      <td>-3.778023</td>\n",
              "      <td>-6.538071</td>\n",
              "      <td>-4.057776</td>\n",
              "      <td>-4.555000</td>\n",
              "      <td>-1.976557</td>\n",
              "      <td>2.587701</td>\n",
              "      <td>4.176077</td>\n",
              "      <td>-1.044215</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128207</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-16 23:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>301.967224</td>\n",
              "      <td>299.592926</td>\n",
              "      <td>297.360992</td>\n",
              "      <td>296.503510</td>\n",
              "      <td>295.418579</td>\n",
              "      <td>294.267151</td>\n",
              "      <td>292.511902</td>\n",
              "      <td>...</td>\n",
              "      <td>-2.479708</td>\n",
              "      <td>-2.587006</td>\n",
              "      <td>-2.179526</td>\n",
              "      <td>-2.530857</td>\n",
              "      <td>-0.674372</td>\n",
              "      <td>2.418041</td>\n",
              "      <td>1.533864</td>\n",
              "      <td>1.067336</td>\n",
              "      <td>2.223611</td>\n",
              "      <td>-2.240059</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128231</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-17 23:30:00</td>\n",
              "      <td>0.000783</td>\n",
              "      <td>300.999084</td>\n",
              "      <td>298.644348</td>\n",
              "      <td>296.682678</td>\n",
              "      <td>295.117340</td>\n",
              "      <td>293.766785</td>\n",
              "      <td>292.550995</td>\n",
              "      <td>290.964691</td>\n",
              "      <td>...</td>\n",
              "      <td>4.288654</td>\n",
              "      <td>3.570866</td>\n",
              "      <td>0.144704</td>\n",
              "      <td>1.039387</td>\n",
              "      <td>-0.866369</td>\n",
              "      <td>2.298328</td>\n",
              "      <td>3.901718</td>\n",
              "      <td>1.640025</td>\n",
              "      <td>2.081653</td>\n",
              "      <td>6.997237</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128243</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-18 11:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>296.567505</td>\n",
              "      <td>297.010437</td>\n",
              "      <td>297.256348</td>\n",
              "      <td>295.760376</td>\n",
              "      <td>293.977203</td>\n",
              "      <td>292.770874</td>\n",
              "      <td>291.531586</td>\n",
              "      <td>...</td>\n",
              "      <td>7.130852</td>\n",
              "      <td>4.465802</td>\n",
              "      <td>4.793193</td>\n",
              "      <td>6.094720</td>\n",
              "      <td>7.063475</td>\n",
              "      <td>5.720361</td>\n",
              "      <td>4.514696</td>\n",
              "      <td>5.219525</td>\n",
              "      <td>3.257084</td>\n",
              "      <td>8.006403</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128255</th>\n",
              "      <td>0.001311</td>\n",
              "      <td>2010-08-18 23:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>301.093994</td>\n",
              "      <td>298.875916</td>\n",
              "      <td>296.822723</td>\n",
              "      <td>295.338318</td>\n",
              "      <td>293.762482</td>\n",
              "      <td>292.492676</td>\n",
              "      <td>291.529388</td>\n",
              "      <td>...</td>\n",
              "      <td>8.801022</td>\n",
              "      <td>9.442595</td>\n",
              "      <td>5.896638</td>\n",
              "      <td>4.428885</td>\n",
              "      <td>7.031782</td>\n",
              "      <td>11.773011</td>\n",
              "      <td>11.032416</td>\n",
              "      <td>6.963593</td>\n",
              "      <td>5.759221</td>\n",
              "      <td>0.118873</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128267</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-19 11:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>301.191895</td>\n",
              "      <td>299.387268</td>\n",
              "      <td>297.194763</td>\n",
              "      <td>295.141296</td>\n",
              "      <td>293.593903</td>\n",
              "      <td>292.371216</td>\n",
              "      <td>291.399414</td>\n",
              "      <td>...</td>\n",
              "      <td>12.918739</td>\n",
              "      <td>13.624829</td>\n",
              "      <td>12.041734</td>\n",
              "      <td>10.763762</td>\n",
              "      <td>7.883071</td>\n",
              "      <td>6.368198</td>\n",
              "      <td>8.047240</td>\n",
              "      <td>8.768102</td>\n",
              "      <td>6.121773</td>\n",
              "      <td>-3.539099</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128291</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-20 11:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>301.242340</td>\n",
              "      <td>299.612854</td>\n",
              "      <td>297.622253</td>\n",
              "      <td>296.247711</td>\n",
              "      <td>294.998688</td>\n",
              "      <td>293.579071</td>\n",
              "      <td>291.789032</td>\n",
              "      <td>...</td>\n",
              "      <td>5.656305</td>\n",
              "      <td>4.211630</td>\n",
              "      <td>1.252815</td>\n",
              "      <td>1.947173</td>\n",
              "      <td>-0.770487</td>\n",
              "      <td>0.234254</td>\n",
              "      <td>-0.001992</td>\n",
              "      <td>-0.120523</td>\n",
              "      <td>-2.833424</td>\n",
              "      <td>-2.720163</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128303</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-20 23:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>302.154449</td>\n",
              "      <td>299.356995</td>\n",
              "      <td>297.440002</td>\n",
              "      <td>296.136993</td>\n",
              "      <td>294.703339</td>\n",
              "      <td>293.265717</td>\n",
              "      <td>291.721344</td>\n",
              "      <td>...</td>\n",
              "      <td>3.009147</td>\n",
              "      <td>2.772398</td>\n",
              "      <td>1.157311</td>\n",
              "      <td>0.535431</td>\n",
              "      <td>-0.660579</td>\n",
              "      <td>-1.804381</td>\n",
              "      <td>-2.217197</td>\n",
              "      <td>-2.198260</td>\n",
              "      <td>-1.878057</td>\n",
              "      <td>1.413931</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128315</th>\n",
              "      <td>1.021016</td>\n",
              "      <td>2010-08-21 11:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.438934</td>\n",
              "      <td>299.074982</td>\n",
              "      <td>297.292847</td>\n",
              "      <td>295.554993</td>\n",
              "      <td>294.130463</td>\n",
              "      <td>292.463806</td>\n",
              "      <td>290.704773</td>\n",
              "      <td>...</td>\n",
              "      <td>-1.457484</td>\n",
              "      <td>-4.433584</td>\n",
              "      <td>-5.882339</td>\n",
              "      <td>-3.055200</td>\n",
              "      <td>-3.600837</td>\n",
              "      <td>-1.631050</td>\n",
              "      <td>-4.099631</td>\n",
              "      <td>-4.650328</td>\n",
              "      <td>-0.902460</td>\n",
              "      <td>1.325610</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128339</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-22 11:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.594696</td>\n",
              "      <td>298.737610</td>\n",
              "      <td>296.951721</td>\n",
              "      <td>295.534668</td>\n",
              "      <td>294.185211</td>\n",
              "      <td>293.132843</td>\n",
              "      <td>291.620544</td>\n",
              "      <td>...</td>\n",
              "      <td>2.738983</td>\n",
              "      <td>2.586395</td>\n",
              "      <td>1.444473</td>\n",
              "      <td>1.787430</td>\n",
              "      <td>1.026227</td>\n",
              "      <td>-0.158767</td>\n",
              "      <td>-1.520651</td>\n",
              "      <td>-1.878652</td>\n",
              "      <td>0.945031</td>\n",
              "      <td>0.134775</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128351</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-22 23:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>301.955994</td>\n",
              "      <td>299.549042</td>\n",
              "      <td>297.411163</td>\n",
              "      <td>295.055420</td>\n",
              "      <td>293.437225</td>\n",
              "      <td>292.455994</td>\n",
              "      <td>291.483093</td>\n",
              "      <td>...</td>\n",
              "      <td>4.146044</td>\n",
              "      <td>2.930655</td>\n",
              "      <td>1.433477</td>\n",
              "      <td>-0.660221</td>\n",
              "      <td>-0.731360</td>\n",
              "      <td>-2.855155</td>\n",
              "      <td>-4.413352</td>\n",
              "      <td>-4.996109</td>\n",
              "      <td>1.768509</td>\n",
              "      <td>1.300404</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128364</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-23 12:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>301.392181</td>\n",
              "      <td>299.378174</td>\n",
              "      <td>297.269989</td>\n",
              "      <td>295.476959</td>\n",
              "      <td>294.304535</td>\n",
              "      <td>292.315002</td>\n",
              "      <td>292.139679</td>\n",
              "      <td>...</td>\n",
              "      <td>-1.239383</td>\n",
              "      <td>-1.936114</td>\n",
              "      <td>-3.591222</td>\n",
              "      <td>-3.878377</td>\n",
              "      <td>-5.426520</td>\n",
              "      <td>-7.986885</td>\n",
              "      <td>-7.264223</td>\n",
              "      <td>0.154587</td>\n",
              "      <td>2.675886</td>\n",
              "      <td>0.941399</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128375</th>\n",
              "      <td>0.011656</td>\n",
              "      <td>2010-08-23 23:30:00</td>\n",
              "      <td>0.004383</td>\n",
              "      <td>302.100983</td>\n",
              "      <td>299.102509</td>\n",
              "      <td>296.904083</td>\n",
              "      <td>294.820465</td>\n",
              "      <td>292.982483</td>\n",
              "      <td>291.977295</td>\n",
              "      <td>290.662598</td>\n",
              "      <td>...</td>\n",
              "      <td>-4.174069</td>\n",
              "      <td>-2.821472</td>\n",
              "      <td>-1.282145</td>\n",
              "      <td>-1.073880</td>\n",
              "      <td>0.405268</td>\n",
              "      <td>-2.303877</td>\n",
              "      <td>-4.666933</td>\n",
              "      <td>-0.214716</td>\n",
              "      <td>-1.483704</td>\n",
              "      <td>-1.849459</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128387</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-24 11:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.928894</td>\n",
              "      <td>299.132111</td>\n",
              "      <td>297.136993</td>\n",
              "      <td>295.891418</td>\n",
              "      <td>294.466492</td>\n",
              "      <td>292.677673</td>\n",
              "      <td>290.986542</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.528829</td>\n",
              "      <td>-1.079299</td>\n",
              "      <td>-0.023689</td>\n",
              "      <td>-2.420923</td>\n",
              "      <td>-3.919263</td>\n",
              "      <td>-2.801473</td>\n",
              "      <td>-3.904569</td>\n",
              "      <td>-3.803766</td>\n",
              "      <td>-3.702935</td>\n",
              "      <td>-1.328969</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128399</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-24 23:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>301.811005</td>\n",
              "      <td>299.419983</td>\n",
              "      <td>298.342682</td>\n",
              "      <td>296.610718</td>\n",
              "      <td>294.897827</td>\n",
              "      <td>293.079987</td>\n",
              "      <td>291.503845</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.301660</td>\n",
              "      <td>-4.349506</td>\n",
              "      <td>-5.073596</td>\n",
              "      <td>-4.466963</td>\n",
              "      <td>-4.356104</td>\n",
              "      <td>-2.683553</td>\n",
              "      <td>-6.230660</td>\n",
              "      <td>-2.792666</td>\n",
              "      <td>1.118804</td>\n",
              "      <td>4.657021</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128411</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-25 11:30:00</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.706482</td>\n",
              "      <td>299.132294</td>\n",
              "      <td>297.411163</td>\n",
              "      <td>296.004059</td>\n",
              "      <td>294.446411</td>\n",
              "      <td>292.721710</td>\n",
              "      <td>291.320312</td>\n",
              "      <td>...</td>\n",
              "      <td>3.054992</td>\n",
              "      <td>0.185968</td>\n",
              "      <td>-1.103522</td>\n",
              "      <td>-1.493171</td>\n",
              "      <td>0.013349</td>\n",
              "      <td>1.677324</td>\n",
              "      <td>2.667127</td>\n",
              "      <td>3.297233</td>\n",
              "      <td>1.788885</td>\n",
              "      <td>0.325670</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128423</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>2010-08-25 23:30:00</td>\n",
              "      <td>0.448773</td>\n",
              "      <td>300.252075</td>\n",
              "      <td>299.223206</td>\n",
              "      <td>297.342010</td>\n",
              "      <td>295.683044</td>\n",
              "      <td>294.239136</td>\n",
              "      <td>292.822754</td>\n",
              "      <td>291.693817</td>\n",
              "      <td>...</td>\n",
              "      <td>0.305224</td>\n",
              "      <td>-1.085414</td>\n",
              "      <td>-0.474090</td>\n",
              "      <td>1.200796</td>\n",
              "      <td>0.313302</td>\n",
              "      <td>2.511165</td>\n",
              "      <td>-0.284950</td>\n",
              "      <td>-0.564313</td>\n",
              "      <td>6.709367</td>\n",
              "      <td>2.644853</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>4847 rows × 151 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "        prec_sfc_1hrlater                time  prec_sfc     T_p1000  \\\n",
              "14524            0.049667 1997-08-28 04:30:00  0.047667  299.979401   \n",
              "14758            0.050000 1997-09-06 22:30:00  0.050000  299.540466   \n",
              "14782            0.050492 1997-09-07 22:30:00  0.050000  300.308807   \n",
              "15046            0.050000 1997-09-18 22:30:00  0.051311  299.845459   \n",
              "15142            0.050000 1997-09-22 22:30:00  0.050000  299.509094   \n",
              "15166            0.050000 1997-09-23 22:30:00  0.050000  299.473816   \n",
              "15214            0.045902 1997-09-25 22:30:00  0.980678  299.505005   \n",
              "15238            0.050000 1997-09-26 22:30:00  0.048197  300.169037   \n",
              "15286            0.057627 1997-09-28 22:30:00  0.050339  299.997833   \n",
              "15382            0.050000 1997-10-02 22:30:00  0.050000  299.795441   \n",
              "15454            0.050164 1997-10-05 22:30:00  0.050820  299.802612   \n",
              "15622            0.050000 1997-10-12 22:30:00  0.043279  299.514709   \n",
              "15646            1.541148 1997-10-13 22:30:00  0.095082  300.856659   \n",
              "15670            0.047869 1997-10-14 22:30:00  0.049508  300.507874   \n",
              "15694            0.050000 1997-10-15 22:30:00  0.049180  300.602936   \n",
              "15766            0.044576 1997-10-18 22:30:00  0.048688  300.165771   \n",
              "15886            0.049672 1997-10-23 22:30:00  0.049836  300.943756   \n",
              "15910            0.050000 1997-10-24 22:30:00  0.050000  300.208801   \n",
              "15934           32.556438 1997-10-25 22:30:00  0.610656  299.818756   \n",
              "16030            0.050833 1997-10-29 22:30:00  0.050339  300.908813   \n",
              "16078            0.050000 1997-10-31 22:30:00  0.050492  301.032349   \n",
              "16102            0.091803 1997-11-01 22:30:00  0.047288  300.470001   \n",
              "16132            0.050000 1997-11-03 04:30:00  0.053279  300.565796   \n",
              "16156            0.050000 1997-11-04 04:30:00  0.050000  301.267639   \n",
              "16174            0.050000 1997-11-04 22:30:00  0.050000  300.281586   \n",
              "16198            0.050000 1997-11-05 22:30:00  0.051017  300.415009   \n",
              "16270            0.050656 1997-11-08 22:30:00  0.050000  300.494995   \n",
              "16294            0.050164 1997-11-09 22:30:00  0.050820  300.195007   \n",
              "16366            0.056721 1997-11-12 22:30:00  0.050000  300.975006   \n",
              "16390            0.051148 1997-11-13 22:30:00  0.049836  300.549988   \n",
              "...                   ...                 ...       ...         ...   \n",
              "128027           0.000000 2010-08-09 11:30:00  0.000000  300.631409   \n",
              "128039           0.000000 2010-08-09 23:30:00  0.000000  300.699554   \n",
              "128051           0.000000 2010-08-10 11:30:00  0.000000  300.874481   \n",
              "128063           0.000000 2010-08-10 23:30:00  0.000000  300.850006   \n",
              "128075           0.000000 2010-08-11 11:30:00  0.000000  300.403992   \n",
              "128087           0.000000 2010-08-11 23:30:00  0.000000  301.536194   \n",
              "128100           0.000000 2010-08-12 12:30:00  0.000000  300.242371   \n",
              "128111           0.000000 2010-08-12 23:30:00  0.000000  300.141357   \n",
              "128123           0.000000 2010-08-13 11:30:00  0.000000  299.371826   \n",
              "128135           0.000000 2010-08-13 23:30:00  0.000000  300.439087   \n",
              "128148           0.000000 2010-08-14 12:30:00  0.000000  300.845001   \n",
              "128159           0.010770 2010-08-14 23:30:00  0.007050  301.403564   \n",
              "128171           0.000000 2010-08-15 11:30:00  0.000000  301.417999   \n",
              "128183           0.000770 2010-08-15 23:30:00  0.000000  302.043976   \n",
              "128207           0.000000 2010-08-16 23:30:00  0.000000  301.967224   \n",
              "128231           0.000000 2010-08-17 23:30:00  0.000783  300.999084   \n",
              "128243           0.000000 2010-08-18 11:30:00  0.000000  296.567505   \n",
              "128255           0.001311 2010-08-18 23:30:00  0.000000  301.093994   \n",
              "128267           0.000000 2010-08-19 11:30:00  0.000000  301.191895   \n",
              "128291           0.000000 2010-08-20 11:30:00  0.000000  301.242340   \n",
              "128303           0.000000 2010-08-20 23:30:00  0.000000  302.154449   \n",
              "128315           1.021016 2010-08-21 11:30:00  0.000000  300.438934   \n",
              "128339           0.000000 2010-08-22 11:30:00  0.000000  300.594696   \n",
              "128351           0.000000 2010-08-22 23:30:00  0.000000  301.955994   \n",
              "128364           0.000000 2010-08-23 12:30:00  0.000000  301.392181   \n",
              "128375           0.011656 2010-08-23 23:30:00  0.004383  302.100983   \n",
              "128387           0.000000 2010-08-24 11:30:00  0.000000  300.928894   \n",
              "128399           0.000000 2010-08-24 23:30:00  0.000000  301.811005   \n",
              "128411           0.000000 2010-08-25 11:30:00  0.000000  300.706482   \n",
              "128423           0.000000 2010-08-25 23:30:00  0.448773  300.252075   \n",
              "\n",
              "            T_p975      T_p950      T_p925      T_p900      T_p875  \\\n",
              "14524   297.850006  295.649994  294.116669  292.449982  291.121796   \n",
              "14758   297.363037  295.245453  294.180420  295.295441  292.979156   \n",
              "14782   297.945831  295.690002  293.509094  291.936371  292.528259   \n",
              "15046   297.649994  295.542297  293.750000  292.582153  292.483337   \n",
              "15142   297.286346  295.541656  294.620270  292.957153  291.267487   \n",
              "15166   297.358337  295.208313  293.661438  293.036835  291.484985   \n",
              "15214   297.845642  296.184784  295.038452  293.588470  291.712067   \n",
              "15238   297.968170  296.011902  294.509094  293.063629  292.125000   \n",
              "15286   297.831818  296.725006  295.858582  294.429413  293.002930   \n",
              "15382   297.564270  295.384979  293.574982  292.259094  291.237488   \n",
              "15454   297.545227  295.835724  294.717743  294.001984  292.545654   \n",
              "15622   297.464294  295.928253  294.521423  293.195007  291.138000   \n",
              "15646   298.465790  296.278564  294.549988  293.359528  291.622711   \n",
              "15670   298.218170  296.149994  294.428253  292.867371  291.667389   \n",
              "15694   298.484985  296.323669  294.240479  292.649994  291.318176   \n",
              "15766   298.068176  296.057678  295.224182  293.449982  291.912170   \n",
              "15886   298.576080  296.406525  294.787018  293.208069  291.227783   \n",
              "15910   298.164276  296.140900  294.395447  293.202148  292.658691   \n",
              "15934   298.164276  296.106506  294.350006  292.781799  291.410858   \n",
              "16030   298.549988  296.371033  295.130951  293.760529  292.280426   \n",
              "16078   298.813141  296.565002  294.777252  294.284790  293.236938   \n",
              "16102   298.424988  296.426910  294.510712  292.824982  291.129150   \n",
              "16132   298.458313  296.389130  294.078003  292.529175  291.416656   \n",
              "16156   298.919983  296.750000  294.759094  293.142303  292.990723   \n",
              "16174   298.009094  296.697601  296.794983  295.294983  293.063629   \n",
              "16198   298.329987  296.453979  294.949982  293.901520  292.477783   \n",
              "16270   298.280426  296.654541  295.273804  293.783325  292.183319   \n",
              "16294   298.273804  296.470001  294.904999  293.259521  291.754547   \n",
              "16366   298.790894  296.812500  295.623901  294.098145  292.432129   \n",
              "16390   298.460510  296.309998  294.411102  293.104553  292.350006   \n",
              "...            ...         ...         ...         ...         ...   \n",
              "128027  298.882263  297.089996  295.360260  293.808746  292.428986   \n",
              "128039  299.127502  297.638702  295.712952  294.315796  292.220581   \n",
              "128051  299.201996  297.684540  295.986938  294.117706  292.197388   \n",
              "128063  298.523315  296.585632  295.301666  294.201385  293.239349   \n",
              "128075  298.693146  297.033508  295.952362  294.550476  293.125458   \n",
              "128087  299.602814  297.543915  295.783112  294.198425  293.192413   \n",
              "128100  298.390900  296.937592  295.334442  293.703217  292.228271   \n",
              "128111  297.785645  296.367004  294.661499  293.582550  292.671661   \n",
              "128123  297.868744  296.454407  295.027313  293.340302  291.575714   \n",
              "128135  298.313324  297.104797  296.042175  294.320007  292.496674   \n",
              "128148  298.932617  296.899200  295.289581  295.262909  294.059021   \n",
              "128159  299.096466  297.235321  295.617004  294.094208  292.934387   \n",
              "128171  299.464752  297.452759  296.888153  295.098511  293.342346   \n",
              "128183  299.653137  297.534454  295.641296  294.385895  293.125519   \n",
              "128207  299.592926  297.360992  296.503510  295.418579  294.267151   \n",
              "128231  298.644348  296.682678  295.117340  293.766785  292.550995   \n",
              "128243  297.010437  297.256348  295.760376  293.977203  292.770874   \n",
              "128255  298.875916  296.822723  295.338318  293.762482  292.492676   \n",
              "128267  299.387268  297.194763  295.141296  293.593903  292.371216   \n",
              "128291  299.612854  297.622253  296.247711  294.998688  293.579071   \n",
              "128303  299.356995  297.440002  296.136993  294.703339  293.265717   \n",
              "128315  299.074982  297.292847  295.554993  294.130463  292.463806   \n",
              "128339  298.737610  296.951721  295.534668  294.185211  293.132843   \n",
              "128351  299.549042  297.411163  295.055420  293.437225  292.455994   \n",
              "128364  299.378174  297.269989  295.476959  294.304535  292.315002   \n",
              "128375  299.102509  296.904083  294.820465  292.982483  291.977295   \n",
              "128387  299.132111  297.136993  295.891418  294.466492  292.677673   \n",
              "128399  299.419983  298.342682  296.610718  294.897827  293.079987   \n",
              "128411  299.132294  297.411163  296.004059  294.446411  292.721710   \n",
              "128423  299.223206  297.342010  295.683044  294.239136  292.822754   \n",
              "\n",
              "            T_p850    ...         v_p325     v_p300     v_p275     v_p250  \\\n",
              "14524   290.321411    ...      -3.694841  -8.905457  -8.430822 -11.832866   \n",
              "14758   290.387482    ...       3.635570   0.696846  -5.836888  -6.929137   \n",
              "14782   291.256226    ...      -0.570785  -6.294807  -5.568968  -2.439126   \n",
              "15046   290.667236    ...      -1.414140  -6.250647 -13.632689 -19.243462   \n",
              "15142   290.323151    ...      -2.055194  -0.635155   0.038826  -0.884923   \n",
              "15166   290.468597    ...      -1.871192   0.079552   1.479049  -2.326284   \n",
              "15214   290.653229    ...       7.619709   7.176747   4.833903  -1.715490   \n",
              "15238   290.736847    ...      -3.801949  -1.510288  -0.065602   1.140482   \n",
              "15286   291.541412    ...       0.789057  -4.094765  -8.825696 -11.111882   \n",
              "15382   290.362000    ...      -0.079788  -3.749264  -5.678204  -9.683691   \n",
              "15454   290.621429    ...      -0.574042  -1.214316  -4.495208  -7.807476   \n",
              "15622   289.975006    ...      -1.716966  -3.833446  -4.791119  -5.502052   \n",
              "15646   290.095459    ...       6.148317   1.874338  -1.785443  -6.252535   \n",
              "15670   290.199982    ...       0.186238  -0.826191  -2.395772  -8.527872   \n",
              "15694   289.783325    ...      -3.006945  -2.858124  -2.728866  -4.143253   \n",
              "15766   290.769989    ...      -4.457522  -5.280304  -8.256284 -11.077329   \n",
              "15886   290.411285    ...       0.868040  -0.826427  -3.866060  -4.795523   \n",
              "15910   291.162506    ...      -2.650353  -1.625398  -3.184672  -2.637162   \n",
              "15934   290.007690    ...       1.443448   2.590680  -2.639284  -7.213702   \n",
              "16030   290.934998    ...       1.080005   0.632882  -0.582796   1.365543   \n",
              "16078   291.727264    ...       5.616391   3.951925   0.819317  -1.160635   \n",
              "16102   290.260803    ...       3.151057  10.231236   8.192634   1.463737   \n",
              "16132   290.725006    ...      11.643619   6.315861   3.471717  -1.352153   \n",
              "16156   291.739990    ...       3.801957   6.310259   2.638773   2.094060   \n",
              "16174   291.802368    ...       5.356645   3.792663  -0.134115   1.908189   \n",
              "16198   291.570587    ...       2.131374   2.361863  -2.466990  -5.663918   \n",
              "16270   290.821991    ...       2.375225  -0.027572  -7.857867  -9.601642   \n",
              "16294   290.523895    ...      -1.774813  -5.731592  -0.598125   2.603852   \n",
              "16366   290.649994    ...      11.209023  11.216011   7.005546   5.277328   \n",
              "16390   291.479156    ...      -1.020682  -5.541191  -5.142968  -1.490302   \n",
              "...            ...    ...            ...        ...        ...        ...   \n",
              "128027  291.301575    ...      -0.143740   3.248850   3.716591   4.709014   \n",
              "128039  290.664368    ...       6.086284   5.853918   7.830789   7.354771   \n",
              "128051  290.749237    ...      -1.461149  -1.076025  -4.048060  -2.313075   \n",
              "128063  292.195160    ...      -2.788443  -4.080852  -4.587708  -2.693874   \n",
              "128075  291.579071    ...      -3.991415  -4.477642  -3.600425  -2.627179   \n",
              "128087  291.952087    ...      -0.736046  -0.436770   0.551084  -1.568495   \n",
              "128100  290.313599    ...       1.092464   1.341130  -0.634546   0.655195   \n",
              "128111  291.666260    ...       3.012034  -0.472823   1.751277   3.161802   \n",
              "128123  290.724548    ...      -2.764803  -2.558042   1.302029   6.372724   \n",
              "128135  290.972076    ...       0.781096  -1.544967  -1.138334  -1.164169   \n",
              "128148  293.634979    ...      -0.156123  -0.069101   0.579056   0.151105   \n",
              "128159  291.822937    ...      -6.108386  -2.666012   0.511577   0.615649   \n",
              "128171  292.059143    ...       1.691359  -2.849754  -6.070728  -6.754097   \n",
              "128183  291.535675    ...      -0.191065  -1.732803  -3.778023  -6.538071   \n",
              "128207  292.511902    ...      -2.479708  -2.587006  -2.179526  -2.530857   \n",
              "128231  290.964691    ...       4.288654   3.570866   0.144704   1.039387   \n",
              "128243  291.531586    ...       7.130852   4.465802   4.793193   6.094720   \n",
              "128255  291.529388    ...       8.801022   9.442595   5.896638   4.428885   \n",
              "128267  291.399414    ...      12.918739  13.624829  12.041734  10.763762   \n",
              "128291  291.789032    ...       5.656305   4.211630   1.252815   1.947173   \n",
              "128303  291.721344    ...       3.009147   2.772398   1.157311   0.535431   \n",
              "128315  290.704773    ...      -1.457484  -4.433584  -5.882339  -3.055200   \n",
              "128339  291.620544    ...       2.738983   2.586395   1.444473   1.787430   \n",
              "128351  291.483093    ...       4.146044   2.930655   1.433477  -0.660221   \n",
              "128364  292.139679    ...      -1.239383  -1.936114  -3.591222  -3.878377   \n",
              "128375  290.662598    ...      -4.174069  -2.821472  -1.282145  -1.073880   \n",
              "128387  290.986542    ...      -0.528829  -1.079299  -0.023689  -2.420923   \n",
              "128399  291.503845    ...      -0.301660  -4.349506  -5.073596  -4.466963   \n",
              "128411  291.320312    ...       3.054992   0.185968  -1.103522  -1.493171   \n",
              "128423  291.693817    ...       0.305224  -1.085414  -0.474090   1.200796   \n",
              "\n",
              "           v_p225     v_p200     v_p175     v_p150     v_p125     v_p100  \n",
              "14524  -15.014605 -13.703352  -4.340648   3.429173   0.061024  -2.429142  \n",
              "14758  -16.164400 -16.350965  -8.582373   2.699558   1.369764   2.531068  \n",
              "14782   -3.171939  -3.827843  -1.925839   0.171745   4.252823   0.654523  \n",
              "15046  -23.677080 -24.335115 -17.825041 -12.481750   3.124845   1.017899  \n",
              "15142   -3.075891  -3.622608  -4.358087  -0.225894   1.109643  -4.608153  \n",
              "15166  -11.745255 -13.823651  -8.587365  -0.627821   4.487830  -2.143723  \n",
              "15214   -1.584804  -2.180600  -5.345045   6.249083   7.325176   0.537335  \n",
              "15238    1.721500   0.712793  -1.762484  -5.165653  -5.962721  -3.889105  \n",
              "15286  -13.857169 -13.698687  -9.175197  -2.952761  -4.772560  -6.912055  \n",
              "15382  -10.290372   1.890432   9.836006   9.294689  -3.343925  -8.170444  \n",
              "15454   -8.506917  -9.347400  -5.561154   3.231571   7.453132  -4.492843  \n",
              "15622   -6.485824  -8.174824 -11.204121  -8.862458   2.027360   2.486079  \n",
              "15646   -6.364130  -6.491885  -9.787130  -8.186864   1.077030   3.526639  \n",
              "15670  -10.473539  -8.262249  -5.635159  -0.867642   7.614470   0.054471  \n",
              "15694   -6.146730  -5.743268  -6.115375  -4.539102   0.859108  -2.470370  \n",
              "15766  -10.390654 -12.399014 -18.003187 -17.675085  -9.244912  -1.914489  \n",
              "15886   -8.622511 -11.028801 -13.859491  -7.205518  -1.394403   3.815901  \n",
              "15910   -5.807591  -7.695199  -7.138307  -9.210431  -0.537811   2.243870  \n",
              "15934   -6.434023  -3.483778  -1.567073   2.979946   3.114442  -2.303572  \n",
              "16030   -1.650876  -4.842235  -5.374320  -3.026091   4.781385   5.994557  \n",
              "16078   -1.667662   1.499117   4.633341  -0.464859  -0.443762  -5.399498  \n",
              "16102    0.623486  -2.026322  -3.262095  -0.210679  -2.721932  -8.680048  \n",
              "16132   -8.550925 -11.392529 -16.661461 -10.058272  -3.688515 -10.134279  \n",
              "16156   -0.614813  -4.257584 -14.277884 -11.061947  -4.462640   4.856185  \n",
              "16174    3.849470   0.664804   1.043680   3.859556  13.751688  14.851539  \n",
              "16198   -5.290195  -5.992301   4.825192  14.319605  18.801739  14.490557  \n",
              "16270    2.119840   6.715693   5.654685   3.195407   5.843157  -0.166409  \n",
              "16294    4.247229   8.932425   3.984121  -0.770112  -1.057764   3.122505  \n",
              "16366    2.624231  -1.778901  -5.347286  -8.114300  -2.317430  -4.718018  \n",
              "16390    1.991504   1.546775  -1.783376  -5.431945  -3.920298   3.254073  \n",
              "...           ...        ...        ...        ...        ...        ...  \n",
              "128027   6.653915   8.348306   5.416325   0.043322   2.781286   1.592121  \n",
              "128039   6.856345   4.907825   3.785929  -1.433738   4.648457   0.695950  \n",
              "128051  -0.454277  -0.641948   0.680149   2.261919   3.942022   4.910818  \n",
              "128063   0.858664   1.845596  -0.012737   1.149589   5.140675   1.464196  \n",
              "128075   0.387704   0.727637  -0.955489  -0.982771   2.768246  -0.841986  \n",
              "128087   0.330352  -1.459406  -5.015362   2.486673  -0.348639  -0.261705  \n",
              "128100   0.281414  -0.233786   2.998835   4.820245  -0.751912   4.886592  \n",
              "128111   4.943165   6.822298  10.159986  11.083560   4.262793   5.660259  \n",
              "128123   5.871500   5.671649   7.892204   7.053923   2.191829  -0.451303  \n",
              "128135   1.023019   0.777334  -1.789608   1.681504   3.765103   2.346743  \n",
              "128148  -0.004582  -2.974836  -6.811464   0.281898   3.310838  -6.220196  \n",
              "128159  -0.024289  -0.514866  -3.309121  -7.458372  -6.925994  -0.951789  \n",
              "128171  -5.116881  -7.626099  -8.840965  -6.325871   5.442287   0.188584  \n",
              "128183  -4.057776  -4.555000  -1.976557   2.587701   4.176077  -1.044215  \n",
              "128207  -0.674372   2.418041   1.533864   1.067336   2.223611  -2.240059  \n",
              "128231  -0.866369   2.298328   3.901718   1.640025   2.081653   6.997237  \n",
              "128243   7.063475   5.720361   4.514696   5.219525   3.257084   8.006403  \n",
              "128255   7.031782  11.773011  11.032416   6.963593   5.759221   0.118873  \n",
              "128267   7.883071   6.368198   8.047240   8.768102   6.121773  -3.539099  \n",
              "128291  -0.770487   0.234254  -0.001992  -0.120523  -2.833424  -2.720163  \n",
              "128303  -0.660579  -1.804381  -2.217197  -2.198260  -1.878057   1.413931  \n",
              "128315  -3.600837  -1.631050  -4.099631  -4.650328  -0.902460   1.325610  \n",
              "128339   1.026227  -0.158767  -1.520651  -1.878652   0.945031   0.134775  \n",
              "128351  -0.731360  -2.855155  -4.413352  -4.996109   1.768509   1.300404  \n",
              "128364  -5.426520  -7.986885  -7.264223   0.154587   2.675886   0.941399  \n",
              "128375   0.405268  -2.303877  -4.666933  -0.214716  -1.483704  -1.849459  \n",
              "128387  -3.919263  -2.801473  -3.904569  -3.803766  -3.702935  -1.328969  \n",
              "128399  -4.356104  -2.683553  -6.230660  -2.792666   1.118804   4.657021  \n",
              "128411   0.013349   1.677324   2.667127   3.297233   1.788885   0.325670  \n",
              "128423   0.313302   2.511165  -0.284950  -0.564313   6.709367   2.644853  \n",
              "\n",
              "[4847 rows x 151 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 74
        }
      ]
    },
    {
      "metadata": {
        "id": "kN-UUmsa-yTx",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 340
        },
        "outputId": "c67a77dc-4ece-4e04-bd11-7af17b851996"
      },
      "cell_type": "code",
      "source": [
        "import datetime as dt\n",
        "\n",
        "df_no_nan['hour'] = hour24 = df_no_nan['time'].dt.hour.values\n",
        "hour_dis = df_no_nan.groupby(['hour']).count().iloc[:,0]\n",
        "hour_dis"
      ],
      "execution_count": 75,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.6/dist-packages/ipykernel_launcher.py:3: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame.\n",
            "Try using .loc[row_indexer,col_indexer] = value instead\n",
            "\n",
            "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
            "  This is separate from the ipykernel package so we can avoid doing imports until\n"
          ],
          "name": "stderr"
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "hour\n",
              "0      166\n",
              "1        2\n",
              "2        1\n",
              "4        6\n",
              "5        1\n",
              "11    2005\n",
              "12     225\n",
              "13       4\n",
              "14       1\n",
              "22     223\n",
              "23    2213\n",
              "Name: prec_sfc_1hrlater, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 75
        }
      ]
    },
    {
      "metadata": {
        "id": "qZlYBrx4CEwF",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 361
        },
        "outputId": "44189d1f-3a43-4ca4-e1f4-66b893bf9617"
      },
      "cell_type": "code",
      "source": [
        "plt.bar(hour_dis.index, hour_dis)\n",
        "plt.xlabel('Hour')\n",
        "plt.ylabel('#Data')\n",
        "f = \"/content/gdrive/My Drive/Colab Notebooks/NN/fig/hour_inbalance.eps\"\n",
        "plt.savefig(f)\n",
        "plt.show()"
      ],
      "execution_count": 76,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAfgAAAFYCAYAAAC/NO6RAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4yLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvOIA7rQAAGKVJREFUeJzt3XtM1ff9x/HXgcMZJR5ElGPmMlu3\nWbXKsI7WgFOHikVWI65ihajZyjJN1WjFWNa0085N8BovNVFJdU67hkmbjHWtuK4s0Urp1rNQ7eao\nTebQGTxHqTewopzfH0351Spa6LnAm+fjr/qBw3mfD9/0yfd7OAdHIBAICAAAmBIV6QEAAEDwEXgA\nAAwi8AAAGETgAQAwiMADAGAQgQcAwCBnpAcIJp/vUtjuq0+fODU2NoXt/noC9jT42NPQYF+Djz3t\nnKQkd7sf4wy+k5zO6EiPYA57GnzsaWiwr8HHngYfgQcAwCACDwCAQQQeAACDCDwAAAYReAAADCLw\nAAAYROABADCIwAMAYBCBBwDAIAIPAIBBBB4AAIMIPAAABpn6a3IAAITDEyVvdep2u4omBHmS9nEG\nDwCAQQQeAACDCDwAAAYReAAADCLwAAAYROABADCIwAMAYBCBBwDAIAIPAIBBBB4AAIMIPAAABhF4\nAAAMIvAAABhE4AEAMIjAAwBgEIEHAMAgAg8AgEEEHgAAgwg8AAAGEXgAAAwi8AAAGETgAQAwiMAD\nAGCQM5RffO3atXrvvfd0/fp1zZs3T8nJyVq+fLlu3LihpKQkrVu3Ti6XSxUVFdqzZ4+ioqI0c+ZM\n5ebmqqWlRUVFRfrf//6n6OhoFRcX65vf/GYoxwUAwIyQBf6dd97Rhx9+qLKyMjU2Nmr69OlKS0tT\nfn6+pkyZoo0bN6q8vFw5OTnatm2bysvLFRMToxkzZigzM1NVVVWKj4/Xhg0bdPjwYW3YsEGbNm0K\n1bgAAJgSskv0Dz30kDZv3ixJio+PV3Nzs2pqajRx4kRJUkZGhqqrq1VbW6vk5GS53W7FxsZq1KhR\n8nq9qq6uVmZmpiQpPT1dXq83VKMCAGBOyM7go6OjFRcXJ0kqLy/XuHHjdPjwYblcLklS37595fP5\n5Pf7lZiY2Ha7xMTEW9ajoqLkcDh07dq1ttvfTp8+cXI6o0P1kG6RlOQO2331FOxp8H3ZPZ1a+IcO\nf+0/bpjW4dtYwbEafD1hT8P5GEP6HLwkvfnmmyovL9euXbs0efLktvVAIHDbz+/o+uc1NjZ1bshO\nSEpyy+e7FLb76wnY0+AL9Z721O8Xx2rw9ZQ9DfZjvNMPDCH9LfpDhw5p+/btKi0tldvtVlxcnK5e\nvSpJamhokMfjkcfjkd/vb7vN2bNn29Z9Pp8kqaWlRYFA4I5n7wAA4P+FLPCXLl3S2rVrtWPHDiUk\nJEj69Ln0yspKSdLBgwc1duxYpaSk6OjRo7p48aKuXLkir9er1NRUjRkzRgcOHJAkVVVVafTo0aEa\nFQAAc0J2if71119XY2OjlixZ0rZWUlKiZ599VmVlZRowYIBycnIUExOjwsJCFRQUyOFwaMGCBXK7\n3crOztaRI0eUl5cnl8ulkpKSUI0KAIA5IQv8448/rscff/yW9d27d9+ylpWVpaysrJvWPnvtOwAA\n6DjeyQ4AAIMIPAAABhF4AAAMIvAAABhE4AEAMIjAAwBgEIEHAMAgAg8AgEEEHgAAgwg8AAAGEXgA\nAAwi8AAAGETgAQAwiMADAGAQgQcAwCACDwCAQQQeAACDCDwAAAYReAAADCLwAAAYROABADCIwAMA\nYBCBBwDAIAIPAIBBBB4AAIMIPAAABhF4AAAMIvAAABhE4AEAMIjAAwBgEIEHAMAgAg8AgEEEHgAA\ngwg8AAAGEXgAAAwi8AAAGETgAQAwiMADAGAQgQcAwCACDwCAQQQeAACDCDwAAAYReAAADCLwAAAY\nROABADCIwAMAYBCBBwDAIAIPAIBBBB4AAIMIPAAABhF4AAAMIvAAABhE4AEAMIjAAwBgEIEHAMCg\nkAa+rq5OkyZN0r59+yRJRUVFmjp1qubMmaM5c+bor3/9qySpoqJCjz32mHJzc7V//35JUktLiwoL\nC5WXl6fZs2ervr4+lKMCAGCKM1RfuKmpSatWrVJaWtpN60uXLlVGRsZNn7dt2zaVl5crJiZGM2bM\nUGZmpqqqqhQfH68NGzbo8OHD2rBhgzZt2hSqcQEAMCVkZ/Aul0ulpaXyeDx3/Lza2lolJyfL7XYr\nNjZWo0aNktfrVXV1tTIzMyVJ6enp8nq9oRoVAABzQhZ4p9Op2NjYW9b37dunuXPn6qmnntL58+fl\n9/uVmJjY9vHExET5fL6b1qOiouRwOHTt2rVQjQsAgCkhu0R/O9OmTVNCQoKGDRumnTt36oUXXtCD\nDz540+cEAoHb3ra99c/r0ydOTmd0UGb9MpKS3GG7r56CPQ2+UO5pT/5+9eTHHio9YU/D+RjDGvjP\nPx8/YcIErVy5Uo888oj8fn/b+tmzZzVy5Eh5PB75fD4NHTpULS0tCgQCcrlcd/z6jY1NIZv9i5KS\n3PL5LoXt/noC9jT4Qr2nPfX7xbEafD1lT4P9GO/0A0NYXya3aNGitt+Gr6mp0eDBg5WSkqKjR4/q\n4sWLunLlirxer1JTUzVmzBgdOHBAklRVVaXRo0eHc1QAALq1kJ3BHzt2TGvWrNHp06fldDpVWVmp\n2bNna8mSJbrnnnsUFxen4uJixcbGqrCwUAUFBXI4HFqwYIHcbreys7N15MgR5eXlyeVyqaSkJFSj\nAgBgTsgCP2LECO3du/eW9UceeeSWtaysLGVlZd20Fh0dreLi4lCNBwCAabyTHQAABhF4AAAMIvAA\nABhE4AEAMIjAAwBgEIEHAMAgAg8AgEEEHgAAgwg8AAAGEXgAAAwi8AAAGETgAQAwiMADAGAQgQcA\nwCACDwCAQQQeAACDCDwAAAYReAAADCLwAAAYROABADCIwAMAYBCBBwDAIAIPAIBBBB4AAIMIPAAA\nBnUq8F6vN9hzAACAIHLe7RMuX76sP/zhD2psbJQktbS06JVXXtHhw4dDPhwAAOicu57BL1myRP/+\n97/16quv6sqVK6qqqtLKlSvDMBoAAOisuwb+k08+0S9/+Ut94xvf0NNPP63f/va3euONN8IxGwAA\n6KS7Br6lpUVNTU1qbW1VY2OjEhISVF9fH47ZAABAJ931Ofhp06bp97//vXJzc5Wdna3ExETde++9\n4ZgNAAB00l0D/8Mf/lDx8fGSpLS0NJ07d05utzvkgwEAgM674yX61tZWLViwQIFAQK2trUpKStJ3\nvvMdPfnkk+GaDwAAdEK7Z/Cvvfaatm7dqpMnT+qBBx5QIBCQJEVFRen73/9+2AYEAAAd127gH330\nUT366KPaunWrFi1adNPHLl26FPLBAABA5931OfhFixbpxIkTbW90c+3aNf3qV7/ipXIAAHRhdw38\nr3/9ax0+fFh+v18DBw5UfX29nnjiiXDMBgAAOumur4N///339cYbb2jo0KF65ZVXtGvXLjU3N4dj\nNgAA0El3DbzL5ZL06RveBAIBjRgxgj82AwBAF3fXS/SDBg3SSy+9pNTUVP3kJz/RoEGD+CU7AAC6\nuLsG/vnnn9eFCxcUHx+vP/3pTzp37pzmzZsXjtkAAEAn3THwgUBAhw4dUl1dnaKjozV8+HBNnTo1\nXLMBAIBOajfwH3/8sQoKCvS1r31NKSkpunz5sl599VW53W7t2LGDt6sFAKALazfwmzZt0uTJk2+5\nHL9161YVFxdr9erVIR8OAAB0Tru/RV9XV6ef/exnt6wvWrRIx44dC+lQAADgq2k38NHR0XI4HLf9\nWO/evUM2EAAA+Oru+kt2n/2RGQAA0H20G/i//e1veuCBBySpLfIOh0OBQKDdM3sAANA1tHuJfvv2\n7Xr77bc1c+ZMHT9+XMePH1dubq6OHz+uf/3rX+GcEQAAdFC7Z/AOh0MvvfSSvF6vVq5cqX79+ukf\n//iHzpw5o69//evhnBEAAHRQu4EfP368xo8fL7/fr5UrV8rv9+vPf/6z/vjHP+rMmTNasWJFOOcE\nAAAd0G7gV6xYod69e+vUqVM6efKkBg4cqN69e9/2pXMAAKBraTfwzz//vC5fvqxly5bprbfe0n//\n+1/95z//UUlJiYYOHaqcnJxwzgkAADrgji+T69WrlyZMmKCZM2dKkk6dOqWlS5fqn//8Z1iGAwAA\nnXPXvyb3WdwlqbS0VJI0cuTI0E0EAAC+snZfJgcAALqvkAa+rq5OkyZN0r59+yRJZ86c0Zw5c5Sf\nn6/Fixfr2rVrkqSKigo99thjys3N1f79+yVJLS0tKiwsVF5enmbPnq36+vpQjgoAgCkhC3xTU5NW\nrVqltLS0trUtW7YoPz9fv/vd73TvvfeqvLxcTU1N2rZtm37zm99o79692rNnjz7++GO99tprio+P\n18svv6z58+drw4YNoRoVAABzQhZ4l8ul0tJSeTyetrWamhpNnDhRkpSRkaHq6mrV1tYqOTlZbrdb\nsbGxGjVqlLxer6qrq5WZmSlJSk9Pl9frDdWoAACYc9dfsuv0F3Y65XTe/OWbm5vlcrkkSX379pXP\n55Pf71diYmLb5yQmJt6yHhUVJYfDoWvXrrXd/nb69ImT0xkdgkdze0lJ7rDdV0/BngZfKPe0J3+/\nevJjD5WesKfhfIwhC/zdtPdX6jq6/nmNjU1faaaOSEpyy+e7FLb76wnY0+AL9Z721O8Xx2rw9ZQ9\nDfZjvNMPDGH9Lfq4uDhdvXpVktTQ0CCPxyOPxyO/39/2OWfPnm1b9/l8kj79hbtAIHDHs3cAAPD/\nwhr49PR0VVZWSpIOHjyosWPHKiUlRUePHtXFixd15coVeb1epaamasyYMTpw4IAkqaqqSqNHjw7n\nqAAAdGshu0R/7NgxrVmzRqdPn5bT6VRlZaXWr1+voqIilZWVacCAAcrJyVFMTIwKCwtVUFAgh8Oh\nBQsWyO12Kzs7W0eOHFFeXp5cLpdKSkpCNSoAAOaELPAjRozQ3r17b1nfvXv3LWtZWVnKysq6aS06\nOlrFxcWhGg8AANN4JzsAAAwi8AAAGETgAQAwiMADAGAQgQcAwCACDwCAQQQeAACDCDwAAAYReAAA\nDCLwAAAYROABADCIwAMAYBCBBwDAIAIPAIBBBB4AAIMIPAAABhF4AAAMIvAAABhE4AEAMIjAAwBg\nEIEHAMAgAg8AgEEEHgAAgwg8AAAGEXgAAAwi8AAAGETgAQAwiMADAGAQgQcAwCACDwCAQQQeAACD\nCDwAAAYReAAADCLwAAAYROABADCIwAMAYBCBBwDAIAIPAIBBBB4AAIMIPAAABhF4AAAMIvAAABhE\n4AEAMIjAAwBgEIEHAMAgAg8AgEEEHgAAgwg8AAAGEXgAAAwi8AAAGETgAQAwiMADAGAQgQcAwCAC\nDwCAQQQeAACDnOG8s5qaGi1evFiDBw+WJN1///366U9/quXLl+vGjRtKSkrSunXr5HK5VFFRoT17\n9igqKkozZ85Ubm5uOEcFAKBbC2vgJenhhx/Wli1b2v7985//XPn5+ZoyZYo2btyo8vJy5eTkaNu2\nbSovL1dMTIxmzJihzMxMJSQkhHtcAAC6pYhfoq+pqdHEiRMlSRkZGaqurlZtba2Sk5PldrsVGxur\nUaNGyev1RnhSAAC6j7CfwZ84cULz58/XhQsXtHDhQjU3N8vlckmS+vbtK5/PJ7/fr8TExLbbJCYm\nyufz3fVr9+kTJ6czOmSzf1FSkjts99VTsKfBF8o97cnfr5782EOlJ+xpOB9jWAN/3333aeHChZoy\nZYrq6+s1d+5c3bhxo+3jgUDgtrdrb/2LGhubgjLnl5GU5JbPdyls99cTsKfBF+o97anfL47V4Osp\nexrsx3inHxjCeom+f//+ys7OlsPh0MCBA9WvXz9duHBBV69elSQ1NDTI4/HI4/HI7/e33e7s2bPy\neDzhHBUAgG4trIGvqKjQiy++KEny+Xw6d+6cfvSjH6myslKSdPDgQY0dO1YpKSk6evSoLl68qCtX\nrsjr9So1NTWcowIA0K2F9RL9hAkTtGzZMv3lL39RS0uLVq5cqWHDhunpp59WWVmZBgwYoJycHMXE\nxKiwsFAFBQVyOBxasGCB3G77z80AABAsYQ18r169tH379lvWd+/efctaVlaWsrKywjEWAADmRPxl\ncgAAIPgIPAAABhF4AAAMIvAAABhE4AEAMIjAAwBgEIEHAMAgAg8AgEEEHgAAgwg8AAAGEXgAAAwi\n8AAAGETgAQAwiMADAGAQgQcAwCACDwCAQQQeAACDCDwAAAYReAAADCLwAAAYROABADCIwAMAYBCB\nBwDAIAIPAIBBBB4AAIMIPAAABhF4AAAMIvAAABhE4AEAMIjAAwBgkDPSAwCw44mStzp8m11FE0Iw\nCdC+zhynUvc7VjmDBwDAIAIPAIBBBB4AAIMIPAAABhF4AAAMIvAAABjEy+TuoKe8lAIAYA9n8AAA\nGETgAQAwiMADAGAQgQcAwCACDwCAQQQeAACDCDwAAAYReAAADCLwAAAYROABADCIwAMAYBCBBwDA\nIAIPAIBBBB4AAIMIPAAABhF4AAAMIvAAABjkjPQAd7J69WrV1tbK4XDomWee0Xe/+91IjwQAQLfQ\nZQP/7rvv6uTJkyorK9NHH32kZ555RmVlZZEeCwCAbqHLXqKvrq7WpEmTJEnf/va3deHCBV2+fDnC\nUwEA0D102TN4v9+v4cOHt/07MTFRPp9PvXr1iuBUPdsTJW916na7iiYEeRJY1pnjjGMMuJUjEAgE\nIj3E7Tz33HMaP35821l8Xl6eVq9erUGDBkV4MgAAur4ue4ne4/HI7/e3/fvs2bNKSkqK4EQAAHQf\nXTbwY8aMUWVlpSTpgw8+kMfj4fI8AABfUpd9Dn7UqFEaPny4Zs2aJYfDoRUrVkR6JAAAuo0u+xw8\nAADovC57iR4AAHQegQcAwKAu+xx8V8Xb5wZfTU2NFi9erMGDB0uS7r//fj333HMRnqp7qqur05NP\nPqkf//jHmj17ts6cOaPly5frxo0bSkpK0rp16+RyuSI9ZrfzxX0tKirSBx98oISEBElSQUGBfvCD\nH0R2yG5m7dq1eu+993T9+nXNmzdPycnJHKtBRuA7gLfPDZ2HH35YW7ZsifQY3VpTU5NWrVqltLS0\ntrUtW7YoPz9fU6ZM0caNG1VeXq78/PwITtn93G5fJWnp0qXKyMiI0FTd2zvvvKMPP/xQZWVlamxs\n1PTp05WWlsaxGmRcou8A3j4XXZnL5VJpaak8Hk/bWk1NjSZOnChJysjIUHV1daTG67Zut6/4ah56\n6CFt3rxZkhQfH6/m5maO1RAg8B3g9/vVp0+ftn9/9va5+OpOnDih+fPnKy8vT2+//Xakx+mWnE6n\nYmNjb1prbm5uu8zZt29fjtdOuN2+StK+ffs0d+5cPfXUUzp//nwEJuu+oqOjFRcXJ0kqLy/XuHHj\nOFZDgEv0XwGvMAyO++67TwsXLtSUKVNUX1+vuXPn6uDBgzz/FmQcr8Ezbdo0JSQkaNiwYdq5c6de\neOEF/eIXv4j0WN3Om2++qfLycu3atUuTJ09uW+dYDQ7O4DuAt88Njf79+ys7O1sOh0MDBw5Uv379\n1NDQEOmxTIiLi9PVq1clSQ0NDVxmDpK0tDQNGzZMkjRhwgTV1dVFeKLu59ChQ9q+fbtKS0vldrs5\nVkOAwHcAb58bGhUVFXrxxRclST6fT+fOnVP//v0jPJUN6enpbcfswYMHNXbs2AhPZMOiRYtUX18v\n6dPfc/jsFSD4ci5duqS1a9dqx44dba9E4FgNPt7JroPWr1+vv//9721vnzt06NBIj9TtXb58WcuW\nLdPFixfV0tKihQsXavz48ZEeq9s5duyY1qxZo9OnT8vpdKp///5av369ioqK9Mknn2jAgAEqLi5W\nTExMpEftVm63r7Nnz9bOnTt1zz33KC4uTsXFxerbt2+kR+02ysrKtHXr1pv+OmhJSYmeffZZjtUg\nIvAAABjEJXoAAAwi8AAAGETgAQAwiMADAGAQgQcAwCACD+C2Tp06pXHjxt2yPmTIEF2/fj0CEwHo\nCAIPAIBBBB5Ah7W2tmrVqlWaNWuWZs2apU2bNkn69F3d8vLy2j6vqKhI+/fv16lTpzR16lQVFhZq\n+/btkRob6FH4YzMAOuz111/XqVOn9PLLL6u1tVWzZs1Senr6HW/z0UcfafPmzfrWt74VpimBno3A\nA2jX+fPnNWfOnFvW33//faWlpcnhcCg6Olqpqak6evSoRowY0e7X6t27N3EHwojAA2hXYmKi9u7d\ne9PakCFD5HTe/L+OQCAgh8Mhh8Nx03pLS0vbf/O+4kB48Rw8gA4bOXKkjhw5okAgoOvXr+vdd99V\nSkqKevXqpYaGBgUCATU3N6u2tjbSowI9FmfwADps0qRJ8nq9ysvLU2trqyZNmqTvfe97am1t1ZAh\nQzR9+nQNHDhQDz74YKRHBXos/pocAAAGcYkeAACDCDwAAAYReAAADCLwAAAYROABADCIwAMAYBCB\nBwDAIAIPAIBB/wdih4QCTiY7CwAAAABJRU5ErkJggg==\n",
            "text/plain": [
              "<Figure size 576x396 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "metadata": {
        "id": "KkdLueBjBXsG",
        "colab_type": "code",
        "outputId": "c0c820f0-fb11-4460-c8d6-498ae957b9d0",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 3009
        }
      },
      "cell_type": "code",
      "source": [
        "# Generate cyclic hour\n",
        "hour24 = df_no_nan['time'].dt.hour.values\n",
        "theta_hour = 2*np.pi * hour24/24\n",
        "try:\n",
        "  df_no_nan.insert(loc=0, column='hour_sin', value=np.sin(theta_hour))\n",
        "except:\n",
        "  print('Column hour_sin has already inserted.')\n",
        "try:\n",
        "  df_no_nan.insert(loc=0, column='hour_cos', value=np.cos(theta_hour))\n",
        "except:\n",
        "  print('Column hour_cos has already inserted.')\n",
        "  \n",
        "df_nn = df_no_nan.reset_index().drop(columns=['time','index']) # delete time column, reset index\n",
        "df_nn"
      ],
      "execution_count": 77,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>hour_cos</th>\n",
              "      <th>hour_sin</th>\n",
              "      <th>prec_sfc_1hrlater</th>\n",
              "      <th>prec_sfc</th>\n",
              "      <th>T_p1000</th>\n",
              "      <th>T_p975</th>\n",
              "      <th>T_p950</th>\n",
              "      <th>T_p925</th>\n",
              "      <th>T_p900</th>\n",
              "      <th>T_p875</th>\n",
              "      <th>...</th>\n",
              "      <th>v_p300</th>\n",
              "      <th>v_p275</th>\n",
              "      <th>v_p250</th>\n",
              "      <th>v_p225</th>\n",
              "      <th>v_p200</th>\n",
              "      <th>v_p175</th>\n",
              "      <th>v_p150</th>\n",
              "      <th>v_p125</th>\n",
              "      <th>v_p100</th>\n",
              "      <th>hour</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0.500000</td>\n",
              "      <td>8.660254e-01</td>\n",
              "      <td>0.049667</td>\n",
              "      <td>0.047667</td>\n",
              "      <td>299.979401</td>\n",
              "      <td>297.850006</td>\n",
              "      <td>295.649994</td>\n",
              "      <td>294.116669</td>\n",
              "      <td>292.449982</td>\n",
              "      <td>291.121796</td>\n",
              "      <td>...</td>\n",
              "      <td>-8.905457</td>\n",
              "      <td>-8.430822</td>\n",
              "      <td>-11.832866</td>\n",
              "      <td>-15.014605</td>\n",
              "      <td>-13.703352</td>\n",
              "      <td>-4.340648</td>\n",
              "      <td>3.429173</td>\n",
              "      <td>0.061024</td>\n",
              "      <td>-2.429142</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>299.540466</td>\n",
              "      <td>297.363037</td>\n",
              "      <td>295.245453</td>\n",
              "      <td>294.180420</td>\n",
              "      <td>295.295441</td>\n",
              "      <td>292.979156</td>\n",
              "      <td>...</td>\n",
              "      <td>0.696846</td>\n",
              "      <td>-5.836888</td>\n",
              "      <td>-6.929137</td>\n",
              "      <td>-16.164400</td>\n",
              "      <td>-16.350965</td>\n",
              "      <td>-8.582373</td>\n",
              "      <td>2.699558</td>\n",
              "      <td>1.369764</td>\n",
              "      <td>2.531068</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.050492</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>300.308807</td>\n",
              "      <td>297.945831</td>\n",
              "      <td>295.690002</td>\n",
              "      <td>293.509094</td>\n",
              "      <td>291.936371</td>\n",
              "      <td>292.528259</td>\n",
              "      <td>...</td>\n",
              "      <td>-6.294807</td>\n",
              "      <td>-5.568968</td>\n",
              "      <td>-2.439126</td>\n",
              "      <td>-3.171939</td>\n",
              "      <td>-3.827843</td>\n",
              "      <td>-1.925839</td>\n",
              "      <td>0.171745</td>\n",
              "      <td>4.252823</td>\n",
              "      <td>0.654523</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>0.051311</td>\n",
              "      <td>299.845459</td>\n",
              "      <td>297.649994</td>\n",
              "      <td>295.542297</td>\n",
              "      <td>293.750000</td>\n",
              "      <td>292.582153</td>\n",
              "      <td>292.483337</td>\n",
              "      <td>...</td>\n",
              "      <td>-6.250647</td>\n",
              "      <td>-13.632689</td>\n",
              "      <td>-19.243462</td>\n",
              "      <td>-23.677080</td>\n",
              "      <td>-24.335115</td>\n",
              "      <td>-17.825041</td>\n",
              "      <td>-12.481750</td>\n",
              "      <td>3.124845</td>\n",
              "      <td>1.017899</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>299.509094</td>\n",
              "      <td>297.286346</td>\n",
              "      <td>295.541656</td>\n",
              "      <td>294.620270</td>\n",
              "      <td>292.957153</td>\n",
              "      <td>291.267487</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.635155</td>\n",
              "      <td>0.038826</td>\n",
              "      <td>-0.884923</td>\n",
              "      <td>-3.075891</td>\n",
              "      <td>-3.622608</td>\n",
              "      <td>-4.358087</td>\n",
              "      <td>-0.225894</td>\n",
              "      <td>1.109643</td>\n",
              "      <td>-4.608153</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>299.473816</td>\n",
              "      <td>297.358337</td>\n",
              "      <td>295.208313</td>\n",
              "      <td>293.661438</td>\n",
              "      <td>293.036835</td>\n",
              "      <td>291.484985</td>\n",
              "      <td>...</td>\n",
              "      <td>0.079552</td>\n",
              "      <td>1.479049</td>\n",
              "      <td>-2.326284</td>\n",
              "      <td>-11.745255</td>\n",
              "      <td>-13.823651</td>\n",
              "      <td>-8.587365</td>\n",
              "      <td>-0.627821</td>\n",
              "      <td>4.487830</td>\n",
              "      <td>-2.143723</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.045902</td>\n",
              "      <td>0.980678</td>\n",
              "      <td>299.505005</td>\n",
              "      <td>297.845642</td>\n",
              "      <td>296.184784</td>\n",
              "      <td>295.038452</td>\n",
              "      <td>293.588470</td>\n",
              "      <td>291.712067</td>\n",
              "      <td>...</td>\n",
              "      <td>7.176747</td>\n",
              "      <td>4.833903</td>\n",
              "      <td>-1.715490</td>\n",
              "      <td>-1.584804</td>\n",
              "      <td>-2.180600</td>\n",
              "      <td>-5.345045</td>\n",
              "      <td>6.249083</td>\n",
              "      <td>7.325176</td>\n",
              "      <td>0.537335</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>0.048197</td>\n",
              "      <td>300.169037</td>\n",
              "      <td>297.968170</td>\n",
              "      <td>296.011902</td>\n",
              "      <td>294.509094</td>\n",
              "      <td>293.063629</td>\n",
              "      <td>292.125000</td>\n",
              "      <td>...</td>\n",
              "      <td>-1.510288</td>\n",
              "      <td>-0.065602</td>\n",
              "      <td>1.140482</td>\n",
              "      <td>1.721500</td>\n",
              "      <td>0.712793</td>\n",
              "      <td>-1.762484</td>\n",
              "      <td>-5.165653</td>\n",
              "      <td>-5.962721</td>\n",
              "      <td>-3.889105</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.057627</td>\n",
              "      <td>0.050339</td>\n",
              "      <td>299.997833</td>\n",
              "      <td>297.831818</td>\n",
              "      <td>296.725006</td>\n",
              "      <td>295.858582</td>\n",
              "      <td>294.429413</td>\n",
              "      <td>293.002930</td>\n",
              "      <td>...</td>\n",
              "      <td>-4.094765</td>\n",
              "      <td>-8.825696</td>\n",
              "      <td>-11.111882</td>\n",
              "      <td>-13.857169</td>\n",
              "      <td>-13.698687</td>\n",
              "      <td>-9.175197</td>\n",
              "      <td>-2.952761</td>\n",
              "      <td>-4.772560</td>\n",
              "      <td>-6.912055</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>299.795441</td>\n",
              "      <td>297.564270</td>\n",
              "      <td>295.384979</td>\n",
              "      <td>293.574982</td>\n",
              "      <td>292.259094</td>\n",
              "      <td>291.237488</td>\n",
              "      <td>...</td>\n",
              "      <td>-3.749264</td>\n",
              "      <td>-5.678204</td>\n",
              "      <td>-9.683691</td>\n",
              "      <td>-10.290372</td>\n",
              "      <td>1.890432</td>\n",
              "      <td>9.836006</td>\n",
              "      <td>9.294689</td>\n",
              "      <td>-3.343925</td>\n",
              "      <td>-8.170444</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.050164</td>\n",
              "      <td>0.050820</td>\n",
              "      <td>299.802612</td>\n",
              "      <td>297.545227</td>\n",
              "      <td>295.835724</td>\n",
              "      <td>294.717743</td>\n",
              "      <td>294.001984</td>\n",
              "      <td>292.545654</td>\n",
              "      <td>...</td>\n",
              "      <td>-1.214316</td>\n",
              "      <td>-4.495208</td>\n",
              "      <td>-7.807476</td>\n",
              "      <td>-8.506917</td>\n",
              "      <td>-9.347400</td>\n",
              "      <td>-5.561154</td>\n",
              "      <td>3.231571</td>\n",
              "      <td>7.453132</td>\n",
              "      <td>-4.492843</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>0.043279</td>\n",
              "      <td>299.514709</td>\n",
              "      <td>297.464294</td>\n",
              "      <td>295.928253</td>\n",
              "      <td>294.521423</td>\n",
              "      <td>293.195007</td>\n",
              "      <td>291.138000</td>\n",
              "      <td>...</td>\n",
              "      <td>-3.833446</td>\n",
              "      <td>-4.791119</td>\n",
              "      <td>-5.502052</td>\n",
              "      <td>-6.485824</td>\n",
              "      <td>-8.174824</td>\n",
              "      <td>-11.204121</td>\n",
              "      <td>-8.862458</td>\n",
              "      <td>2.027360</td>\n",
              "      <td>2.486079</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>1.541148</td>\n",
              "      <td>0.095082</td>\n",
              "      <td>300.856659</td>\n",
              "      <td>298.465790</td>\n",
              "      <td>296.278564</td>\n",
              "      <td>294.549988</td>\n",
              "      <td>293.359528</td>\n",
              "      <td>291.622711</td>\n",
              "      <td>...</td>\n",
              "      <td>1.874338</td>\n",
              "      <td>-1.785443</td>\n",
              "      <td>-6.252535</td>\n",
              "      <td>-6.364130</td>\n",
              "      <td>-6.491885</td>\n",
              "      <td>-9.787130</td>\n",
              "      <td>-8.186864</td>\n",
              "      <td>1.077030</td>\n",
              "      <td>3.526639</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.047869</td>\n",
              "      <td>0.049508</td>\n",
              "      <td>300.507874</td>\n",
              "      <td>298.218170</td>\n",
              "      <td>296.149994</td>\n",
              "      <td>294.428253</td>\n",
              "      <td>292.867371</td>\n",
              "      <td>291.667389</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.826191</td>\n",
              "      <td>-2.395772</td>\n",
              "      <td>-8.527872</td>\n",
              "      <td>-10.473539</td>\n",
              "      <td>-8.262249</td>\n",
              "      <td>-5.635159</td>\n",
              "      <td>-0.867642</td>\n",
              "      <td>7.614470</td>\n",
              "      <td>0.054471</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>0.049180</td>\n",
              "      <td>300.602936</td>\n",
              "      <td>298.484985</td>\n",
              "      <td>296.323669</td>\n",
              "      <td>294.240479</td>\n",
              "      <td>292.649994</td>\n",
              "      <td>291.318176</td>\n",
              "      <td>...</td>\n",
              "      <td>-2.858124</td>\n",
              "      <td>-2.728866</td>\n",
              "      <td>-4.143253</td>\n",
              "      <td>-6.146730</td>\n",
              "      <td>-5.743268</td>\n",
              "      <td>-6.115375</td>\n",
              "      <td>-4.539102</td>\n",
              "      <td>0.859108</td>\n",
              "      <td>-2.470370</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.044576</td>\n",
              "      <td>0.048688</td>\n",
              "      <td>300.165771</td>\n",
              "      <td>298.068176</td>\n",
              "      <td>296.057678</td>\n",
              "      <td>295.224182</td>\n",
              "      <td>293.449982</td>\n",
              "      <td>291.912170</td>\n",
              "      <td>...</td>\n",
              "      <td>-5.280304</td>\n",
              "      <td>-8.256284</td>\n",
              "      <td>-11.077329</td>\n",
              "      <td>-10.390654</td>\n",
              "      <td>-12.399014</td>\n",
              "      <td>-18.003187</td>\n",
              "      <td>-17.675085</td>\n",
              "      <td>-9.244912</td>\n",
              "      <td>-1.914489</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.049672</td>\n",
              "      <td>0.049836</td>\n",
              "      <td>300.943756</td>\n",
              "      <td>298.576080</td>\n",
              "      <td>296.406525</td>\n",
              "      <td>294.787018</td>\n",
              "      <td>293.208069</td>\n",
              "      <td>291.227783</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.826427</td>\n",
              "      <td>-3.866060</td>\n",
              "      <td>-4.795523</td>\n",
              "      <td>-8.622511</td>\n",
              "      <td>-11.028801</td>\n",
              "      <td>-13.859491</td>\n",
              "      <td>-7.205518</td>\n",
              "      <td>-1.394403</td>\n",
              "      <td>3.815901</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>300.208801</td>\n",
              "      <td>298.164276</td>\n",
              "      <td>296.140900</td>\n",
              "      <td>294.395447</td>\n",
              "      <td>293.202148</td>\n",
              "      <td>292.658691</td>\n",
              "      <td>...</td>\n",
              "      <td>-1.625398</td>\n",
              "      <td>-3.184672</td>\n",
              "      <td>-2.637162</td>\n",
              "      <td>-5.807591</td>\n",
              "      <td>-7.695199</td>\n",
              "      <td>-7.138307</td>\n",
              "      <td>-9.210431</td>\n",
              "      <td>-0.537811</td>\n",
              "      <td>2.243870</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>32.556438</td>\n",
              "      <td>0.610656</td>\n",
              "      <td>299.818756</td>\n",
              "      <td>298.164276</td>\n",
              "      <td>296.106506</td>\n",
              "      <td>294.350006</td>\n",
              "      <td>292.781799</td>\n",
              "      <td>291.410858</td>\n",
              "      <td>...</td>\n",
              "      <td>2.590680</td>\n",
              "      <td>-2.639284</td>\n",
              "      <td>-7.213702</td>\n",
              "      <td>-6.434023</td>\n",
              "      <td>-3.483778</td>\n",
              "      <td>-1.567073</td>\n",
              "      <td>2.979946</td>\n",
              "      <td>3.114442</td>\n",
              "      <td>-2.303572</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.050833</td>\n",
              "      <td>0.050339</td>\n",
              "      <td>300.908813</td>\n",
              "      <td>298.549988</td>\n",
              "      <td>296.371033</td>\n",
              "      <td>295.130951</td>\n",
              "      <td>293.760529</td>\n",
              "      <td>292.280426</td>\n",
              "      <td>...</td>\n",
              "      <td>0.632882</td>\n",
              "      <td>-0.582796</td>\n",
              "      <td>1.365543</td>\n",
              "      <td>-1.650876</td>\n",
              "      <td>-4.842235</td>\n",
              "      <td>-5.374320</td>\n",
              "      <td>-3.026091</td>\n",
              "      <td>4.781385</td>\n",
              "      <td>5.994557</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>0.050492</td>\n",
              "      <td>301.032349</td>\n",
              "      <td>298.813141</td>\n",
              "      <td>296.565002</td>\n",
              "      <td>294.777252</td>\n",
              "      <td>294.284790</td>\n",
              "      <td>293.236938</td>\n",
              "      <td>...</td>\n",
              "      <td>3.951925</td>\n",
              "      <td>0.819317</td>\n",
              "      <td>-1.160635</td>\n",
              "      <td>-1.667662</td>\n",
              "      <td>1.499117</td>\n",
              "      <td>4.633341</td>\n",
              "      <td>-0.464859</td>\n",
              "      <td>-0.443762</td>\n",
              "      <td>-5.399498</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.091803</td>\n",
              "      <td>0.047288</td>\n",
              "      <td>300.470001</td>\n",
              "      <td>298.424988</td>\n",
              "      <td>296.426910</td>\n",
              "      <td>294.510712</td>\n",
              "      <td>292.824982</td>\n",
              "      <td>291.129150</td>\n",
              "      <td>...</td>\n",
              "      <td>10.231236</td>\n",
              "      <td>8.192634</td>\n",
              "      <td>1.463737</td>\n",
              "      <td>0.623486</td>\n",
              "      <td>-2.026322</td>\n",
              "      <td>-3.262095</td>\n",
              "      <td>-0.210679</td>\n",
              "      <td>-2.721932</td>\n",
              "      <td>-8.680048</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>0.500000</td>\n",
              "      <td>8.660254e-01</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>0.053279</td>\n",
              "      <td>300.565796</td>\n",
              "      <td>298.458313</td>\n",
              "      <td>296.389130</td>\n",
              "      <td>294.078003</td>\n",
              "      <td>292.529175</td>\n",
              "      <td>291.416656</td>\n",
              "      <td>...</td>\n",
              "      <td>6.315861</td>\n",
              "      <td>3.471717</td>\n",
              "      <td>-1.352153</td>\n",
              "      <td>-8.550925</td>\n",
              "      <td>-11.392529</td>\n",
              "      <td>-16.661461</td>\n",
              "      <td>-10.058272</td>\n",
              "      <td>-3.688515</td>\n",
              "      <td>-10.134279</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>0.500000</td>\n",
              "      <td>8.660254e-01</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>301.267639</td>\n",
              "      <td>298.919983</td>\n",
              "      <td>296.750000</td>\n",
              "      <td>294.759094</td>\n",
              "      <td>293.142303</td>\n",
              "      <td>292.990723</td>\n",
              "      <td>...</td>\n",
              "      <td>6.310259</td>\n",
              "      <td>2.638773</td>\n",
              "      <td>2.094060</td>\n",
              "      <td>-0.614813</td>\n",
              "      <td>-4.257584</td>\n",
              "      <td>-14.277884</td>\n",
              "      <td>-11.061947</td>\n",
              "      <td>-4.462640</td>\n",
              "      <td>4.856185</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>300.281586</td>\n",
              "      <td>298.009094</td>\n",
              "      <td>296.697601</td>\n",
              "      <td>296.794983</td>\n",
              "      <td>295.294983</td>\n",
              "      <td>293.063629</td>\n",
              "      <td>...</td>\n",
              "      <td>3.792663</td>\n",
              "      <td>-0.134115</td>\n",
              "      <td>1.908189</td>\n",
              "      <td>3.849470</td>\n",
              "      <td>0.664804</td>\n",
              "      <td>1.043680</td>\n",
              "      <td>3.859556</td>\n",
              "      <td>13.751688</td>\n",
              "      <td>14.851539</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>0.051017</td>\n",
              "      <td>300.415009</td>\n",
              "      <td>298.329987</td>\n",
              "      <td>296.453979</td>\n",
              "      <td>294.949982</td>\n",
              "      <td>293.901520</td>\n",
              "      <td>292.477783</td>\n",
              "      <td>...</td>\n",
              "      <td>2.361863</td>\n",
              "      <td>-2.466990</td>\n",
              "      <td>-5.663918</td>\n",
              "      <td>-5.290195</td>\n",
              "      <td>-5.992301</td>\n",
              "      <td>4.825192</td>\n",
              "      <td>14.319605</td>\n",
              "      <td>18.801739</td>\n",
              "      <td>14.490557</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.050656</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>300.494995</td>\n",
              "      <td>298.280426</td>\n",
              "      <td>296.654541</td>\n",
              "      <td>295.273804</td>\n",
              "      <td>293.783325</td>\n",
              "      <td>292.183319</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.027572</td>\n",
              "      <td>-7.857867</td>\n",
              "      <td>-9.601642</td>\n",
              "      <td>2.119840</td>\n",
              "      <td>6.715693</td>\n",
              "      <td>5.654685</td>\n",
              "      <td>3.195407</td>\n",
              "      <td>5.843157</td>\n",
              "      <td>-0.166409</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.050164</td>\n",
              "      <td>0.050820</td>\n",
              "      <td>300.195007</td>\n",
              "      <td>298.273804</td>\n",
              "      <td>296.470001</td>\n",
              "      <td>294.904999</td>\n",
              "      <td>293.259521</td>\n",
              "      <td>291.754547</td>\n",
              "      <td>...</td>\n",
              "      <td>-5.731592</td>\n",
              "      <td>-0.598125</td>\n",
              "      <td>2.603852</td>\n",
              "      <td>4.247229</td>\n",
              "      <td>8.932425</td>\n",
              "      <td>3.984121</td>\n",
              "      <td>-0.770112</td>\n",
              "      <td>-1.057764</td>\n",
              "      <td>3.122505</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.056721</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>300.975006</td>\n",
              "      <td>298.790894</td>\n",
              "      <td>296.812500</td>\n",
              "      <td>295.623901</td>\n",
              "      <td>294.098145</td>\n",
              "      <td>292.432129</td>\n",
              "      <td>...</td>\n",
              "      <td>11.216011</td>\n",
              "      <td>7.005546</td>\n",
              "      <td>5.277328</td>\n",
              "      <td>2.624231</td>\n",
              "      <td>-1.778901</td>\n",
              "      <td>-5.347286</td>\n",
              "      <td>-8.114300</td>\n",
              "      <td>-2.317430</td>\n",
              "      <td>-4.718018</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>0.866025</td>\n",
              "      <td>-5.000000e-01</td>\n",
              "      <td>0.051148</td>\n",
              "      <td>0.049836</td>\n",
              "      <td>300.549988</td>\n",
              "      <td>298.460510</td>\n",
              "      <td>296.309998</td>\n",
              "      <td>294.411102</td>\n",
              "      <td>293.104553</td>\n",
              "      <td>292.350006</td>\n",
              "      <td>...</td>\n",
              "      <td>-5.541191</td>\n",
              "      <td>-5.142968</td>\n",
              "      <td>-1.490302</td>\n",
              "      <td>1.991504</td>\n",
              "      <td>1.546775</td>\n",
              "      <td>-1.783376</td>\n",
              "      <td>-5.431945</td>\n",
              "      <td>-3.920298</td>\n",
              "      <td>3.254073</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4817</th>\n",
              "      <td>-0.965926</td>\n",
              "      <td>2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.631409</td>\n",
              "      <td>298.882263</td>\n",
              "      <td>297.089996</td>\n",
              "      <td>295.360260</td>\n",
              "      <td>293.808746</td>\n",
              "      <td>292.428986</td>\n",
              "      <td>...</td>\n",
              "      <td>3.248850</td>\n",
              "      <td>3.716591</td>\n",
              "      <td>4.709014</td>\n",
              "      <td>6.653915</td>\n",
              "      <td>8.348306</td>\n",
              "      <td>5.416325</td>\n",
              "      <td>0.043322</td>\n",
              "      <td>2.781286</td>\n",
              "      <td>1.592121</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4818</th>\n",
              "      <td>0.965926</td>\n",
              "      <td>-2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.699554</td>\n",
              "      <td>299.127502</td>\n",
              "      <td>297.638702</td>\n",
              "      <td>295.712952</td>\n",
              "      <td>294.315796</td>\n",
              "      <td>292.220581</td>\n",
              "      <td>...</td>\n",
              "      <td>5.853918</td>\n",
              "      <td>7.830789</td>\n",
              "      <td>7.354771</td>\n",
              "      <td>6.856345</td>\n",
              "      <td>4.907825</td>\n",
              "      <td>3.785929</td>\n",
              "      <td>-1.433738</td>\n",
              "      <td>4.648457</td>\n",
              "      <td>0.695950</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4819</th>\n",
              "      <td>-0.965926</td>\n",
              "      <td>2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.874481</td>\n",
              "      <td>299.201996</td>\n",
              "      <td>297.684540</td>\n",
              "      <td>295.986938</td>\n",
              "      <td>294.117706</td>\n",
              "      <td>292.197388</td>\n",
              "      <td>...</td>\n",
              "      <td>-1.076025</td>\n",
              "      <td>-4.048060</td>\n",
              "      <td>-2.313075</td>\n",
              "      <td>-0.454277</td>\n",
              "      <td>-0.641948</td>\n",
              "      <td>0.680149</td>\n",
              "      <td>2.261919</td>\n",
              "      <td>3.942022</td>\n",
              "      <td>4.910818</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4820</th>\n",
              "      <td>0.965926</td>\n",
              "      <td>-2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.850006</td>\n",
              "      <td>298.523315</td>\n",
              "      <td>296.585632</td>\n",
              "      <td>295.301666</td>\n",
              "      <td>294.201385</td>\n",
              "      <td>293.239349</td>\n",
              "      <td>...</td>\n",
              "      <td>-4.080852</td>\n",
              "      <td>-4.587708</td>\n",
              "      <td>-2.693874</td>\n",
              "      <td>0.858664</td>\n",
              "      <td>1.845596</td>\n",
              "      <td>-0.012737</td>\n",
              "      <td>1.149589</td>\n",
              "      <td>5.140675</td>\n",
              "      <td>1.464196</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4821</th>\n",
              "      <td>-0.965926</td>\n",
              "      <td>2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.403992</td>\n",
              "      <td>298.693146</td>\n",
              "      <td>297.033508</td>\n",
              "      <td>295.952362</td>\n",
              "      <td>294.550476</td>\n",
              "      <td>293.125458</td>\n",
              "      <td>...</td>\n",
              "      <td>-4.477642</td>\n",
              "      <td>-3.600425</td>\n",
              "      <td>-2.627179</td>\n",
              "      <td>0.387704</td>\n",
              "      <td>0.727637</td>\n",
              "      <td>-0.955489</td>\n",
              "      <td>-0.982771</td>\n",
              "      <td>2.768246</td>\n",
              "      <td>-0.841986</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4822</th>\n",
              "      <td>0.965926</td>\n",
              "      <td>-2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>301.536194</td>\n",
              "      <td>299.602814</td>\n",
              "      <td>297.543915</td>\n",
              "      <td>295.783112</td>\n",
              "      <td>294.198425</td>\n",
              "      <td>293.192413</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.436770</td>\n",
              "      <td>0.551084</td>\n",
              "      <td>-1.568495</td>\n",
              "      <td>0.330352</td>\n",
              "      <td>-1.459406</td>\n",
              "      <td>-5.015362</td>\n",
              "      <td>2.486673</td>\n",
              "      <td>-0.348639</td>\n",
              "      <td>-0.261705</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4823</th>\n",
              "      <td>-1.000000</td>\n",
              "      <td>1.224647e-16</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.242371</td>\n",
              "      <td>298.390900</td>\n",
              "      <td>296.937592</td>\n",
              "      <td>295.334442</td>\n",
              "      <td>293.703217</td>\n",
              "      <td>292.228271</td>\n",
              "      <td>...</td>\n",
              "      <td>1.341130</td>\n",
              "      <td>-0.634546</td>\n",
              "      <td>0.655195</td>\n",
              "      <td>0.281414</td>\n",
              "      <td>-0.233786</td>\n",
              "      <td>2.998835</td>\n",
              "      <td>4.820245</td>\n",
              "      <td>-0.751912</td>\n",
              "      <td>4.886592</td>\n",
              "      <td>12</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4824</th>\n",
              "      <td>0.965926</td>\n",
              "      <td>-2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.141357</td>\n",
              "      <td>297.785645</td>\n",
              "      <td>296.367004</td>\n",
              "      <td>294.661499</td>\n",
              "      <td>293.582550</td>\n",
              "      <td>292.671661</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.472823</td>\n",
              "      <td>1.751277</td>\n",
              "      <td>3.161802</td>\n",
              "      <td>4.943165</td>\n",
              "      <td>6.822298</td>\n",
              "      <td>10.159986</td>\n",
              "      <td>11.083560</td>\n",
              "      <td>4.262793</td>\n",
              "      <td>5.660259</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4825</th>\n",
              "      <td>-0.965926</td>\n",
              "      <td>2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>299.371826</td>\n",
              "      <td>297.868744</td>\n",
              "      <td>296.454407</td>\n",
              "      <td>295.027313</td>\n",
              "      <td>293.340302</td>\n",
              "      <td>291.575714</td>\n",
              "      <td>...</td>\n",
              "      <td>-2.558042</td>\n",
              "      <td>1.302029</td>\n",
              "      <td>6.372724</td>\n",
              "      <td>5.871500</td>\n",
              "      <td>5.671649</td>\n",
              "      <td>7.892204</td>\n",
              "      <td>7.053923</td>\n",
              "      <td>2.191829</td>\n",
              "      <td>-0.451303</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4826</th>\n",
              "      <td>0.965926</td>\n",
              "      <td>-2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.439087</td>\n",
              "      <td>298.313324</td>\n",
              "      <td>297.104797</td>\n",
              "      <td>296.042175</td>\n",
              "      <td>294.320007</td>\n",
              "      <td>292.496674</td>\n",
              "      <td>...</td>\n",
              "      <td>-1.544967</td>\n",
              "      <td>-1.138334</td>\n",
              "      <td>-1.164169</td>\n",
              "      <td>1.023019</td>\n",
              "      <td>0.777334</td>\n",
              "      <td>-1.789608</td>\n",
              "      <td>1.681504</td>\n",
              "      <td>3.765103</td>\n",
              "      <td>2.346743</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4827</th>\n",
              "      <td>-1.000000</td>\n",
              "      <td>1.224647e-16</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.845001</td>\n",
              "      <td>298.932617</td>\n",
              "      <td>296.899200</td>\n",
              "      <td>295.289581</td>\n",
              "      <td>295.262909</td>\n",
              "      <td>294.059021</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.069101</td>\n",
              "      <td>0.579056</td>\n",
              "      <td>0.151105</td>\n",
              "      <td>-0.004582</td>\n",
              "      <td>-2.974836</td>\n",
              "      <td>-6.811464</td>\n",
              "      <td>0.281898</td>\n",
              "      <td>3.310838</td>\n",
              "      <td>-6.220196</td>\n",
              "      <td>12</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4828</th>\n",
              "      <td>0.965926</td>\n",
              "      <td>-2.588190e-01</td>\n",
              "      <td>0.010770</td>\n",
              "      <td>0.007050</td>\n",
              "      <td>301.403564</td>\n",
              "      <td>299.096466</td>\n",
              "      <td>297.235321</td>\n",
              "      <td>295.617004</td>\n",
              "      <td>294.094208</td>\n",
              "      <td>292.934387</td>\n",
              "      <td>...</td>\n",
              "      <td>-2.666012</td>\n",
              "      <td>0.511577</td>\n",
              "      <td>0.615649</td>\n",
              "      <td>-0.024289</td>\n",
              "      <td>-0.514866</td>\n",
              "      <td>-3.309121</td>\n",
              "      <td>-7.458372</td>\n",
              "      <td>-6.925994</td>\n",
              "      <td>-0.951789</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4829</th>\n",
              "      <td>-0.965926</td>\n",
              "      <td>2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>301.417999</td>\n",
              "      <td>299.464752</td>\n",
              "      <td>297.452759</td>\n",
              "      <td>296.888153</td>\n",
              "      <td>295.098511</td>\n",
              "      <td>293.342346</td>\n",
              "      <td>...</td>\n",
              "      <td>-2.849754</td>\n",
              "      <td>-6.070728</td>\n",
              "      <td>-6.754097</td>\n",
              "      <td>-5.116881</td>\n",
              "      <td>-7.626099</td>\n",
              "      <td>-8.840965</td>\n",
              "      <td>-6.325871</td>\n",
              "      <td>5.442287</td>\n",
              "      <td>0.188584</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4830</th>\n",
              "      <td>0.965926</td>\n",
              "      <td>-2.588190e-01</td>\n",
              "      <td>0.000770</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>302.043976</td>\n",
              "      <td>299.653137</td>\n",
              "      <td>297.534454</td>\n",
              "      <td>295.641296</td>\n",
              "      <td>294.385895</td>\n",
              "      <td>293.125519</td>\n",
              "      <td>...</td>\n",
              "      <td>-1.732803</td>\n",
              "      <td>-3.778023</td>\n",
              "      <td>-6.538071</td>\n",
              "      <td>-4.057776</td>\n",
              "      <td>-4.555000</td>\n",
              "      <td>-1.976557</td>\n",
              "      <td>2.587701</td>\n",
              "      <td>4.176077</td>\n",
              "      <td>-1.044215</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4831</th>\n",
              "      <td>0.965926</td>\n",
              "      <td>-2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>301.967224</td>\n",
              "      <td>299.592926</td>\n",
              "      <td>297.360992</td>\n",
              "      <td>296.503510</td>\n",
              "      <td>295.418579</td>\n",
              "      <td>294.267151</td>\n",
              "      <td>...</td>\n",
              "      <td>-2.587006</td>\n",
              "      <td>-2.179526</td>\n",
              "      <td>-2.530857</td>\n",
              "      <td>-0.674372</td>\n",
              "      <td>2.418041</td>\n",
              "      <td>1.533864</td>\n",
              "      <td>1.067336</td>\n",
              "      <td>2.223611</td>\n",
              "      <td>-2.240059</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4832</th>\n",
              "      <td>0.965926</td>\n",
              "      <td>-2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000783</td>\n",
              "      <td>300.999084</td>\n",
              "      <td>298.644348</td>\n",
              "      <td>296.682678</td>\n",
              "      <td>295.117340</td>\n",
              "      <td>293.766785</td>\n",
              "      <td>292.550995</td>\n",
              "      <td>...</td>\n",
              "      <td>3.570866</td>\n",
              "      <td>0.144704</td>\n",
              "      <td>1.039387</td>\n",
              "      <td>-0.866369</td>\n",
              "      <td>2.298328</td>\n",
              "      <td>3.901718</td>\n",
              "      <td>1.640025</td>\n",
              "      <td>2.081653</td>\n",
              "      <td>6.997237</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4833</th>\n",
              "      <td>-0.965926</td>\n",
              "      <td>2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>296.567505</td>\n",
              "      <td>297.010437</td>\n",
              "      <td>297.256348</td>\n",
              "      <td>295.760376</td>\n",
              "      <td>293.977203</td>\n",
              "      <td>292.770874</td>\n",
              "      <td>...</td>\n",
              "      <td>4.465802</td>\n",
              "      <td>4.793193</td>\n",
              "      <td>6.094720</td>\n",
              "      <td>7.063475</td>\n",
              "      <td>5.720361</td>\n",
              "      <td>4.514696</td>\n",
              "      <td>5.219525</td>\n",
              "      <td>3.257084</td>\n",
              "      <td>8.006403</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4834</th>\n",
              "      <td>0.965926</td>\n",
              "      <td>-2.588190e-01</td>\n",
              "      <td>0.001311</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>301.093994</td>\n",
              "      <td>298.875916</td>\n",
              "      <td>296.822723</td>\n",
              "      <td>295.338318</td>\n",
              "      <td>293.762482</td>\n",
              "      <td>292.492676</td>\n",
              "      <td>...</td>\n",
              "      <td>9.442595</td>\n",
              "      <td>5.896638</td>\n",
              "      <td>4.428885</td>\n",
              "      <td>7.031782</td>\n",
              "      <td>11.773011</td>\n",
              "      <td>11.032416</td>\n",
              "      <td>6.963593</td>\n",
              "      <td>5.759221</td>\n",
              "      <td>0.118873</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4835</th>\n",
              "      <td>-0.965926</td>\n",
              "      <td>2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>301.191895</td>\n",
              "      <td>299.387268</td>\n",
              "      <td>297.194763</td>\n",
              "      <td>295.141296</td>\n",
              "      <td>293.593903</td>\n",
              "      <td>292.371216</td>\n",
              "      <td>...</td>\n",
              "      <td>13.624829</td>\n",
              "      <td>12.041734</td>\n",
              "      <td>10.763762</td>\n",
              "      <td>7.883071</td>\n",
              "      <td>6.368198</td>\n",
              "      <td>8.047240</td>\n",
              "      <td>8.768102</td>\n",
              "      <td>6.121773</td>\n",
              "      <td>-3.539099</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4836</th>\n",
              "      <td>-0.965926</td>\n",
              "      <td>2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>301.242340</td>\n",
              "      <td>299.612854</td>\n",
              "      <td>297.622253</td>\n",
              "      <td>296.247711</td>\n",
              "      <td>294.998688</td>\n",
              "      <td>293.579071</td>\n",
              "      <td>...</td>\n",
              "      <td>4.211630</td>\n",
              "      <td>1.252815</td>\n",
              "      <td>1.947173</td>\n",
              "      <td>-0.770487</td>\n",
              "      <td>0.234254</td>\n",
              "      <td>-0.001992</td>\n",
              "      <td>-0.120523</td>\n",
              "      <td>-2.833424</td>\n",
              "      <td>-2.720163</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4837</th>\n",
              "      <td>0.965926</td>\n",
              "      <td>-2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>302.154449</td>\n",
              "      <td>299.356995</td>\n",
              "      <td>297.440002</td>\n",
              "      <td>296.136993</td>\n",
              "      <td>294.703339</td>\n",
              "      <td>293.265717</td>\n",
              "      <td>...</td>\n",
              "      <td>2.772398</td>\n",
              "      <td>1.157311</td>\n",
              "      <td>0.535431</td>\n",
              "      <td>-0.660579</td>\n",
              "      <td>-1.804381</td>\n",
              "      <td>-2.217197</td>\n",
              "      <td>-2.198260</td>\n",
              "      <td>-1.878057</td>\n",
              "      <td>1.413931</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4838</th>\n",
              "      <td>-0.965926</td>\n",
              "      <td>2.588190e-01</td>\n",
              "      <td>1.021016</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.438934</td>\n",
              "      <td>299.074982</td>\n",
              "      <td>297.292847</td>\n",
              "      <td>295.554993</td>\n",
              "      <td>294.130463</td>\n",
              "      <td>292.463806</td>\n",
              "      <td>...</td>\n",
              "      <td>-4.433584</td>\n",
              "      <td>-5.882339</td>\n",
              "      <td>-3.055200</td>\n",
              "      <td>-3.600837</td>\n",
              "      <td>-1.631050</td>\n",
              "      <td>-4.099631</td>\n",
              "      <td>-4.650328</td>\n",
              "      <td>-0.902460</td>\n",
              "      <td>1.325610</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4839</th>\n",
              "      <td>-0.965926</td>\n",
              "      <td>2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.594696</td>\n",
              "      <td>298.737610</td>\n",
              "      <td>296.951721</td>\n",
              "      <td>295.534668</td>\n",
              "      <td>294.185211</td>\n",
              "      <td>293.132843</td>\n",
              "      <td>...</td>\n",
              "      <td>2.586395</td>\n",
              "      <td>1.444473</td>\n",
              "      <td>1.787430</td>\n",
              "      <td>1.026227</td>\n",
              "      <td>-0.158767</td>\n",
              "      <td>-1.520651</td>\n",
              "      <td>-1.878652</td>\n",
              "      <td>0.945031</td>\n",
              "      <td>0.134775</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4840</th>\n",
              "      <td>0.965926</td>\n",
              "      <td>-2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>301.955994</td>\n",
              "      <td>299.549042</td>\n",
              "      <td>297.411163</td>\n",
              "      <td>295.055420</td>\n",
              "      <td>293.437225</td>\n",
              "      <td>292.455994</td>\n",
              "      <td>...</td>\n",
              "      <td>2.930655</td>\n",
              "      <td>1.433477</td>\n",
              "      <td>-0.660221</td>\n",
              "      <td>-0.731360</td>\n",
              "      <td>-2.855155</td>\n",
              "      <td>-4.413352</td>\n",
              "      <td>-4.996109</td>\n",
              "      <td>1.768509</td>\n",
              "      <td>1.300404</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4841</th>\n",
              "      <td>-1.000000</td>\n",
              "      <td>1.224647e-16</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>301.392181</td>\n",
              "      <td>299.378174</td>\n",
              "      <td>297.269989</td>\n",
              "      <td>295.476959</td>\n",
              "      <td>294.304535</td>\n",
              "      <td>292.315002</td>\n",
              "      <td>...</td>\n",
              "      <td>-1.936114</td>\n",
              "      <td>-3.591222</td>\n",
              "      <td>-3.878377</td>\n",
              "      <td>-5.426520</td>\n",
              "      <td>-7.986885</td>\n",
              "      <td>-7.264223</td>\n",
              "      <td>0.154587</td>\n",
              "      <td>2.675886</td>\n",
              "      <td>0.941399</td>\n",
              "      <td>12</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4842</th>\n",
              "      <td>0.965926</td>\n",
              "      <td>-2.588190e-01</td>\n",
              "      <td>0.011656</td>\n",
              "      <td>0.004383</td>\n",
              "      <td>302.100983</td>\n",
              "      <td>299.102509</td>\n",
              "      <td>296.904083</td>\n",
              "      <td>294.820465</td>\n",
              "      <td>292.982483</td>\n",
              "      <td>291.977295</td>\n",
              "      <td>...</td>\n",
              "      <td>-2.821472</td>\n",
              "      <td>-1.282145</td>\n",
              "      <td>-1.073880</td>\n",
              "      <td>0.405268</td>\n",
              "      <td>-2.303877</td>\n",
              "      <td>-4.666933</td>\n",
              "      <td>-0.214716</td>\n",
              "      <td>-1.483704</td>\n",
              "      <td>-1.849459</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4843</th>\n",
              "      <td>-0.965926</td>\n",
              "      <td>2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.928894</td>\n",
              "      <td>299.132111</td>\n",
              "      <td>297.136993</td>\n",
              "      <td>295.891418</td>\n",
              "      <td>294.466492</td>\n",
              "      <td>292.677673</td>\n",
              "      <td>...</td>\n",
              "      <td>-1.079299</td>\n",
              "      <td>-0.023689</td>\n",
              "      <td>-2.420923</td>\n",
              "      <td>-3.919263</td>\n",
              "      <td>-2.801473</td>\n",
              "      <td>-3.904569</td>\n",
              "      <td>-3.803766</td>\n",
              "      <td>-3.702935</td>\n",
              "      <td>-1.328969</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4844</th>\n",
              "      <td>0.965926</td>\n",
              "      <td>-2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>301.811005</td>\n",
              "      <td>299.419983</td>\n",
              "      <td>298.342682</td>\n",
              "      <td>296.610718</td>\n",
              "      <td>294.897827</td>\n",
              "      <td>293.079987</td>\n",
              "      <td>...</td>\n",
              "      <td>-4.349506</td>\n",
              "      <td>-5.073596</td>\n",
              "      <td>-4.466963</td>\n",
              "      <td>-4.356104</td>\n",
              "      <td>-2.683553</td>\n",
              "      <td>-6.230660</td>\n",
              "      <td>-2.792666</td>\n",
              "      <td>1.118804</td>\n",
              "      <td>4.657021</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4845</th>\n",
              "      <td>-0.965926</td>\n",
              "      <td>2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>300.706482</td>\n",
              "      <td>299.132294</td>\n",
              "      <td>297.411163</td>\n",
              "      <td>296.004059</td>\n",
              "      <td>294.446411</td>\n",
              "      <td>292.721710</td>\n",
              "      <td>...</td>\n",
              "      <td>0.185968</td>\n",
              "      <td>-1.103522</td>\n",
              "      <td>-1.493171</td>\n",
              "      <td>0.013349</td>\n",
              "      <td>1.677324</td>\n",
              "      <td>2.667127</td>\n",
              "      <td>3.297233</td>\n",
              "      <td>1.788885</td>\n",
              "      <td>0.325670</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4846</th>\n",
              "      <td>0.965926</td>\n",
              "      <td>-2.588190e-01</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.448773</td>\n",
              "      <td>300.252075</td>\n",
              "      <td>299.223206</td>\n",
              "      <td>297.342010</td>\n",
              "      <td>295.683044</td>\n",
              "      <td>294.239136</td>\n",
              "      <td>292.822754</td>\n",
              "      <td>...</td>\n",
              "      <td>-1.085414</td>\n",
              "      <td>-0.474090</td>\n",
              "      <td>1.200796</td>\n",
              "      <td>0.313302</td>\n",
              "      <td>2.511165</td>\n",
              "      <td>-0.284950</td>\n",
              "      <td>-0.564313</td>\n",
              "      <td>6.709367</td>\n",
              "      <td>2.644853</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>4847 rows × 153 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "      hour_cos      hour_sin  prec_sfc_1hrlater  prec_sfc     T_p1000  \\\n",
              "0     0.500000  8.660254e-01           0.049667  0.047667  299.979401   \n",
              "1     0.866025 -5.000000e-01           0.050000  0.050000  299.540466   \n",
              "2     0.866025 -5.000000e-01           0.050492  0.050000  300.308807   \n",
              "3     0.866025 -5.000000e-01           0.050000  0.051311  299.845459   \n",
              "4     0.866025 -5.000000e-01           0.050000  0.050000  299.509094   \n",
              "5     0.866025 -5.000000e-01           0.050000  0.050000  299.473816   \n",
              "6     0.866025 -5.000000e-01           0.045902  0.980678  299.505005   \n",
              "7     0.866025 -5.000000e-01           0.050000  0.048197  300.169037   \n",
              "8     0.866025 -5.000000e-01           0.057627  0.050339  299.997833   \n",
              "9     0.866025 -5.000000e-01           0.050000  0.050000  299.795441   \n",
              "10    0.866025 -5.000000e-01           0.050164  0.050820  299.802612   \n",
              "11    0.866025 -5.000000e-01           0.050000  0.043279  299.514709   \n",
              "12    0.866025 -5.000000e-01           1.541148  0.095082  300.856659   \n",
              "13    0.866025 -5.000000e-01           0.047869  0.049508  300.507874   \n",
              "14    0.866025 -5.000000e-01           0.050000  0.049180  300.602936   \n",
              "15    0.866025 -5.000000e-01           0.044576  0.048688  300.165771   \n",
              "16    0.866025 -5.000000e-01           0.049672  0.049836  300.943756   \n",
              "17    0.866025 -5.000000e-01           0.050000  0.050000  300.208801   \n",
              "18    0.866025 -5.000000e-01          32.556438  0.610656  299.818756   \n",
              "19    0.866025 -5.000000e-01           0.050833  0.050339  300.908813   \n",
              "20    0.866025 -5.000000e-01           0.050000  0.050492  301.032349   \n",
              "21    0.866025 -5.000000e-01           0.091803  0.047288  300.470001   \n",
              "22    0.500000  8.660254e-01           0.050000  0.053279  300.565796   \n",
              "23    0.500000  8.660254e-01           0.050000  0.050000  301.267639   \n",
              "24    0.866025 -5.000000e-01           0.050000  0.050000  300.281586   \n",
              "25    0.866025 -5.000000e-01           0.050000  0.051017  300.415009   \n",
              "26    0.866025 -5.000000e-01           0.050656  0.050000  300.494995   \n",
              "27    0.866025 -5.000000e-01           0.050164  0.050820  300.195007   \n",
              "28    0.866025 -5.000000e-01           0.056721  0.050000  300.975006   \n",
              "29    0.866025 -5.000000e-01           0.051148  0.049836  300.549988   \n",
              "...        ...           ...                ...       ...         ...   \n",
              "4817 -0.965926  2.588190e-01           0.000000  0.000000  300.631409   \n",
              "4818  0.965926 -2.588190e-01           0.000000  0.000000  300.699554   \n",
              "4819 -0.965926  2.588190e-01           0.000000  0.000000  300.874481   \n",
              "4820  0.965926 -2.588190e-01           0.000000  0.000000  300.850006   \n",
              "4821 -0.965926  2.588190e-01           0.000000  0.000000  300.403992   \n",
              "4822  0.965926 -2.588190e-01           0.000000  0.000000  301.536194   \n",
              "4823 -1.000000  1.224647e-16           0.000000  0.000000  300.242371   \n",
              "4824  0.965926 -2.588190e-01           0.000000  0.000000  300.141357   \n",
              "4825 -0.965926  2.588190e-01           0.000000  0.000000  299.371826   \n",
              "4826  0.965926 -2.588190e-01           0.000000  0.000000  300.439087   \n",
              "4827 -1.000000  1.224647e-16           0.000000  0.000000  300.845001   \n",
              "4828  0.965926 -2.588190e-01           0.010770  0.007050  301.403564   \n",
              "4829 -0.965926  2.588190e-01           0.000000  0.000000  301.417999   \n",
              "4830  0.965926 -2.588190e-01           0.000770  0.000000  302.043976   \n",
              "4831  0.965926 -2.588190e-01           0.000000  0.000000  301.967224   \n",
              "4832  0.965926 -2.588190e-01           0.000000  0.000783  300.999084   \n",
              "4833 -0.965926  2.588190e-01           0.000000  0.000000  296.567505   \n",
              "4834  0.965926 -2.588190e-01           0.001311  0.000000  301.093994   \n",
              "4835 -0.965926  2.588190e-01           0.000000  0.000000  301.191895   \n",
              "4836 -0.965926  2.588190e-01           0.000000  0.000000  301.242340   \n",
              "4837  0.965926 -2.588190e-01           0.000000  0.000000  302.154449   \n",
              "4838 -0.965926  2.588190e-01           1.021016  0.000000  300.438934   \n",
              "4839 -0.965926  2.588190e-01           0.000000  0.000000  300.594696   \n",
              "4840  0.965926 -2.588190e-01           0.000000  0.000000  301.955994   \n",
              "4841 -1.000000  1.224647e-16           0.000000  0.000000  301.392181   \n",
              "4842  0.965926 -2.588190e-01           0.011656  0.004383  302.100983   \n",
              "4843 -0.965926  2.588190e-01           0.000000  0.000000  300.928894   \n",
              "4844  0.965926 -2.588190e-01           0.000000  0.000000  301.811005   \n",
              "4845 -0.965926  2.588190e-01           0.000000  0.000000  300.706482   \n",
              "4846  0.965926 -2.588190e-01           0.000000  0.448773  300.252075   \n",
              "\n",
              "          T_p975      T_p950      T_p925      T_p900      T_p875  ...   \\\n",
              "0     297.850006  295.649994  294.116669  292.449982  291.121796  ...    \n",
              "1     297.363037  295.245453  294.180420  295.295441  292.979156  ...    \n",
              "2     297.945831  295.690002  293.509094  291.936371  292.528259  ...    \n",
              "3     297.649994  295.542297  293.750000  292.582153  292.483337  ...    \n",
              "4     297.286346  295.541656  294.620270  292.957153  291.267487  ...    \n",
              "5     297.358337  295.208313  293.661438  293.036835  291.484985  ...    \n",
              "6     297.845642  296.184784  295.038452  293.588470  291.712067  ...    \n",
              "7     297.968170  296.011902  294.509094  293.063629  292.125000  ...    \n",
              "8     297.831818  296.725006  295.858582  294.429413  293.002930  ...    \n",
              "9     297.564270  295.384979  293.574982  292.259094  291.237488  ...    \n",
              "10    297.545227  295.835724  294.717743  294.001984  292.545654  ...    \n",
              "11    297.464294  295.928253  294.521423  293.195007  291.138000  ...    \n",
              "12    298.465790  296.278564  294.549988  293.359528  291.622711  ...    \n",
              "13    298.218170  296.149994  294.428253  292.867371  291.667389  ...    \n",
              "14    298.484985  296.323669  294.240479  292.649994  291.318176  ...    \n",
              "15    298.068176  296.057678  295.224182  293.449982  291.912170  ...    \n",
              "16    298.576080  296.406525  294.787018  293.208069  291.227783  ...    \n",
              "17    298.164276  296.140900  294.395447  293.202148  292.658691  ...    \n",
              "18    298.164276  296.106506  294.350006  292.781799  291.410858  ...    \n",
              "19    298.549988  296.371033  295.130951  293.760529  292.280426  ...    \n",
              "20    298.813141  296.565002  294.777252  294.284790  293.236938  ...    \n",
              "21    298.424988  296.426910  294.510712  292.824982  291.129150  ...    \n",
              "22    298.458313  296.389130  294.078003  292.529175  291.416656  ...    \n",
              "23    298.919983  296.750000  294.759094  293.142303  292.990723  ...    \n",
              "24    298.009094  296.697601  296.794983  295.294983  293.063629  ...    \n",
              "25    298.329987  296.453979  294.949982  293.901520  292.477783  ...    \n",
              "26    298.280426  296.654541  295.273804  293.783325  292.183319  ...    \n",
              "27    298.273804  296.470001  294.904999  293.259521  291.754547  ...    \n",
              "28    298.790894  296.812500  295.623901  294.098145  292.432129  ...    \n",
              "29    298.460510  296.309998  294.411102  293.104553  292.350006  ...    \n",
              "...          ...         ...         ...         ...         ...  ...    \n",
              "4817  298.882263  297.089996  295.360260  293.808746  292.428986  ...    \n",
              "4818  299.127502  297.638702  295.712952  294.315796  292.220581  ...    \n",
              "4819  299.201996  297.684540  295.986938  294.117706  292.197388  ...    \n",
              "4820  298.523315  296.585632  295.301666  294.201385  293.239349  ...    \n",
              "4821  298.693146  297.033508  295.952362  294.550476  293.125458  ...    \n",
              "4822  299.602814  297.543915  295.783112  294.198425  293.192413  ...    \n",
              "4823  298.390900  296.937592  295.334442  293.703217  292.228271  ...    \n",
              "4824  297.785645  296.367004  294.661499  293.582550  292.671661  ...    \n",
              "4825  297.868744  296.454407  295.027313  293.340302  291.575714  ...    \n",
              "4826  298.313324  297.104797  296.042175  294.320007  292.496674  ...    \n",
              "4827  298.932617  296.899200  295.289581  295.262909  294.059021  ...    \n",
              "4828  299.096466  297.235321  295.617004  294.094208  292.934387  ...    \n",
              "4829  299.464752  297.452759  296.888153  295.098511  293.342346  ...    \n",
              "4830  299.653137  297.534454  295.641296  294.385895  293.125519  ...    \n",
              "4831  299.592926  297.360992  296.503510  295.418579  294.267151  ...    \n",
              "4832  298.644348  296.682678  295.117340  293.766785  292.550995  ...    \n",
              "4833  297.010437  297.256348  295.760376  293.977203  292.770874  ...    \n",
              "4834  298.875916  296.822723  295.338318  293.762482  292.492676  ...    \n",
              "4835  299.387268  297.194763  295.141296  293.593903  292.371216  ...    \n",
              "4836  299.612854  297.622253  296.247711  294.998688  293.579071  ...    \n",
              "4837  299.356995  297.440002  296.136993  294.703339  293.265717  ...    \n",
              "4838  299.074982  297.292847  295.554993  294.130463  292.463806  ...    \n",
              "4839  298.737610  296.951721  295.534668  294.185211  293.132843  ...    \n",
              "4840  299.549042  297.411163  295.055420  293.437225  292.455994  ...    \n",
              "4841  299.378174  297.269989  295.476959  294.304535  292.315002  ...    \n",
              "4842  299.102509  296.904083  294.820465  292.982483  291.977295  ...    \n",
              "4843  299.132111  297.136993  295.891418  294.466492  292.677673  ...    \n",
              "4844  299.419983  298.342682  296.610718  294.897827  293.079987  ...    \n",
              "4845  299.132294  297.411163  296.004059  294.446411  292.721710  ...    \n",
              "4846  299.223206  297.342010  295.683044  294.239136  292.822754  ...    \n",
              "\n",
              "         v_p300     v_p275     v_p250     v_p225     v_p200     v_p175  \\\n",
              "0     -8.905457  -8.430822 -11.832866 -15.014605 -13.703352  -4.340648   \n",
              "1      0.696846  -5.836888  -6.929137 -16.164400 -16.350965  -8.582373   \n",
              "2     -6.294807  -5.568968  -2.439126  -3.171939  -3.827843  -1.925839   \n",
              "3     -6.250647 -13.632689 -19.243462 -23.677080 -24.335115 -17.825041   \n",
              "4     -0.635155   0.038826  -0.884923  -3.075891  -3.622608  -4.358087   \n",
              "5      0.079552   1.479049  -2.326284 -11.745255 -13.823651  -8.587365   \n",
              "6      7.176747   4.833903  -1.715490  -1.584804  -2.180600  -5.345045   \n",
              "7     -1.510288  -0.065602   1.140482   1.721500   0.712793  -1.762484   \n",
              "8     -4.094765  -8.825696 -11.111882 -13.857169 -13.698687  -9.175197   \n",
              "9     -3.749264  -5.678204  -9.683691 -10.290372   1.890432   9.836006   \n",
              "10    -1.214316  -4.495208  -7.807476  -8.506917  -9.347400  -5.561154   \n",
              "11    -3.833446  -4.791119  -5.502052  -6.485824  -8.174824 -11.204121   \n",
              "12     1.874338  -1.785443  -6.252535  -6.364130  -6.491885  -9.787130   \n",
              "13    -0.826191  -2.395772  -8.527872 -10.473539  -8.262249  -5.635159   \n",
              "14    -2.858124  -2.728866  -4.143253  -6.146730  -5.743268  -6.115375   \n",
              "15    -5.280304  -8.256284 -11.077329 -10.390654 -12.399014 -18.003187   \n",
              "16    -0.826427  -3.866060  -4.795523  -8.622511 -11.028801 -13.859491   \n",
              "17    -1.625398  -3.184672  -2.637162  -5.807591  -7.695199  -7.138307   \n",
              "18     2.590680  -2.639284  -7.213702  -6.434023  -3.483778  -1.567073   \n",
              "19     0.632882  -0.582796   1.365543  -1.650876  -4.842235  -5.374320   \n",
              "20     3.951925   0.819317  -1.160635  -1.667662   1.499117   4.633341   \n",
              "21    10.231236   8.192634   1.463737   0.623486  -2.026322  -3.262095   \n",
              "22     6.315861   3.471717  -1.352153  -8.550925 -11.392529 -16.661461   \n",
              "23     6.310259   2.638773   2.094060  -0.614813  -4.257584 -14.277884   \n",
              "24     3.792663  -0.134115   1.908189   3.849470   0.664804   1.043680   \n",
              "25     2.361863  -2.466990  -5.663918  -5.290195  -5.992301   4.825192   \n",
              "26    -0.027572  -7.857867  -9.601642   2.119840   6.715693   5.654685   \n",
              "27    -5.731592  -0.598125   2.603852   4.247229   8.932425   3.984121   \n",
              "28    11.216011   7.005546   5.277328   2.624231  -1.778901  -5.347286   \n",
              "29    -5.541191  -5.142968  -1.490302   1.991504   1.546775  -1.783376   \n",
              "...         ...        ...        ...        ...        ...        ...   \n",
              "4817   3.248850   3.716591   4.709014   6.653915   8.348306   5.416325   \n",
              "4818   5.853918   7.830789   7.354771   6.856345   4.907825   3.785929   \n",
              "4819  -1.076025  -4.048060  -2.313075  -0.454277  -0.641948   0.680149   \n",
              "4820  -4.080852  -4.587708  -2.693874   0.858664   1.845596  -0.012737   \n",
              "4821  -4.477642  -3.600425  -2.627179   0.387704   0.727637  -0.955489   \n",
              "4822  -0.436770   0.551084  -1.568495   0.330352  -1.459406  -5.015362   \n",
              "4823   1.341130  -0.634546   0.655195   0.281414  -0.233786   2.998835   \n",
              "4824  -0.472823   1.751277   3.161802   4.943165   6.822298  10.159986   \n",
              "4825  -2.558042   1.302029   6.372724   5.871500   5.671649   7.892204   \n",
              "4826  -1.544967  -1.138334  -1.164169   1.023019   0.777334  -1.789608   \n",
              "4827  -0.069101   0.579056   0.151105  -0.004582  -2.974836  -6.811464   \n",
              "4828  -2.666012   0.511577   0.615649  -0.024289  -0.514866  -3.309121   \n",
              "4829  -2.849754  -6.070728  -6.754097  -5.116881  -7.626099  -8.840965   \n",
              "4830  -1.732803  -3.778023  -6.538071  -4.057776  -4.555000  -1.976557   \n",
              "4831  -2.587006  -2.179526  -2.530857  -0.674372   2.418041   1.533864   \n",
              "4832   3.570866   0.144704   1.039387  -0.866369   2.298328   3.901718   \n",
              "4833   4.465802   4.793193   6.094720   7.063475   5.720361   4.514696   \n",
              "4834   9.442595   5.896638   4.428885   7.031782  11.773011  11.032416   \n",
              "4835  13.624829  12.041734  10.763762   7.883071   6.368198   8.047240   \n",
              "4836   4.211630   1.252815   1.947173  -0.770487   0.234254  -0.001992   \n",
              "4837   2.772398   1.157311   0.535431  -0.660579  -1.804381  -2.217197   \n",
              "4838  -4.433584  -5.882339  -3.055200  -3.600837  -1.631050  -4.099631   \n",
              "4839   2.586395   1.444473   1.787430   1.026227  -0.158767  -1.520651   \n",
              "4840   2.930655   1.433477  -0.660221  -0.731360  -2.855155  -4.413352   \n",
              "4841  -1.936114  -3.591222  -3.878377  -5.426520  -7.986885  -7.264223   \n",
              "4842  -2.821472  -1.282145  -1.073880   0.405268  -2.303877  -4.666933   \n",
              "4843  -1.079299  -0.023689  -2.420923  -3.919263  -2.801473  -3.904569   \n",
              "4844  -4.349506  -5.073596  -4.466963  -4.356104  -2.683553  -6.230660   \n",
              "4845   0.185968  -1.103522  -1.493171   0.013349   1.677324   2.667127   \n",
              "4846  -1.085414  -0.474090   1.200796   0.313302   2.511165  -0.284950   \n",
              "\n",
              "         v_p150     v_p125     v_p100  hour  \n",
              "0      3.429173   0.061024  -2.429142     4  \n",
              "1      2.699558   1.369764   2.531068    22  \n",
              "2      0.171745   4.252823   0.654523    22  \n",
              "3    -12.481750   3.124845   1.017899    22  \n",
              "4     -0.225894   1.109643  -4.608153    22  \n",
              "5     -0.627821   4.487830  -2.143723    22  \n",
              "6      6.249083   7.325176   0.537335    22  \n",
              "7     -5.165653  -5.962721  -3.889105    22  \n",
              "8     -2.952761  -4.772560  -6.912055    22  \n",
              "9      9.294689  -3.343925  -8.170444    22  \n",
              "10     3.231571   7.453132  -4.492843    22  \n",
              "11    -8.862458   2.027360   2.486079    22  \n",
              "12    -8.186864   1.077030   3.526639    22  \n",
              "13    -0.867642   7.614470   0.054471    22  \n",
              "14    -4.539102   0.859108  -2.470370    22  \n",
              "15   -17.675085  -9.244912  -1.914489    22  \n",
              "16    -7.205518  -1.394403   3.815901    22  \n",
              "17    -9.210431  -0.537811   2.243870    22  \n",
              "18     2.979946   3.114442  -2.303572    22  \n",
              "19    -3.026091   4.781385   5.994557    22  \n",
              "20    -0.464859  -0.443762  -5.399498    22  \n",
              "21    -0.210679  -2.721932  -8.680048    22  \n",
              "22   -10.058272  -3.688515 -10.134279     4  \n",
              "23   -11.061947  -4.462640   4.856185     4  \n",
              "24     3.859556  13.751688  14.851539    22  \n",
              "25    14.319605  18.801739  14.490557    22  \n",
              "26     3.195407   5.843157  -0.166409    22  \n",
              "27    -0.770112  -1.057764   3.122505    22  \n",
              "28    -8.114300  -2.317430  -4.718018    22  \n",
              "29    -5.431945  -3.920298   3.254073    22  \n",
              "...         ...        ...        ...   ...  \n",
              "4817   0.043322   2.781286   1.592121    11  \n",
              "4818  -1.433738   4.648457   0.695950    23  \n",
              "4819   2.261919   3.942022   4.910818    11  \n",
              "4820   1.149589   5.140675   1.464196    23  \n",
              "4821  -0.982771   2.768246  -0.841986    11  \n",
              "4822   2.486673  -0.348639  -0.261705    23  \n",
              "4823   4.820245  -0.751912   4.886592    12  \n",
              "4824  11.083560   4.262793   5.660259    23  \n",
              "4825   7.053923   2.191829  -0.451303    11  \n",
              "4826   1.681504   3.765103   2.346743    23  \n",
              "4827   0.281898   3.310838  -6.220196    12  \n",
              "4828  -7.458372  -6.925994  -0.951789    23  \n",
              "4829  -6.325871   5.442287   0.188584    11  \n",
              "4830   2.587701   4.176077  -1.044215    23  \n",
              "4831   1.067336   2.223611  -2.240059    23  \n",
              "4832   1.640025   2.081653   6.997237    23  \n",
              "4833   5.219525   3.257084   8.006403    11  \n",
              "4834   6.963593   5.759221   0.118873    23  \n",
              "4835   8.768102   6.121773  -3.539099    11  \n",
              "4836  -0.120523  -2.833424  -2.720163    11  \n",
              "4837  -2.198260  -1.878057   1.413931    23  \n",
              "4838  -4.650328  -0.902460   1.325610    11  \n",
              "4839  -1.878652   0.945031   0.134775    11  \n",
              "4840  -4.996109   1.768509   1.300404    23  \n",
              "4841   0.154587   2.675886   0.941399    12  \n",
              "4842  -0.214716  -1.483704  -1.849459    23  \n",
              "4843  -3.803766  -3.702935  -1.328969    11  \n",
              "4844  -2.792666   1.118804   4.657021    23  \n",
              "4845   3.297233   1.788885   0.325670    11  \n",
              "4846  -0.564313   6.709367   2.644853    23  \n",
              "\n",
              "[4847 rows x 153 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 77
        }
      ]
    },
    {
      "metadata": {
        "id": "eQbG38rrUexL",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "# Export it into .csv\n",
        "f = \"/content/gdrive/My Drive/Colab Notebooks/data/ARM_1hrlater.csv\"\n",
        "df_nn.to_csv(f)"
      ],
      "execution_count": 0,
      "outputs": []
    }
  ]
}