test_catalog.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "ename": "ConnectionError",
     "evalue": "HTTPSConnectionPool(host='connectora', port=8080): Max retries exceeded with url: /api/ids/description?recipient=https%3A%2F%2Fconnectorb%3A8081%2Fapi%2Fids%2Fdata (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x7f366a0023b0>: Failed to establish a new connection: [Errno -5] No address associated with hostname'))",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mgaierror\u001b[0m                                  Traceback (most recent call last)",
      "File \u001b[0;32m~/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connection.py:174\u001b[0m, in \u001b[0;36mHTTPConnection._new_conn\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connection.py?line=172'>173</a>\u001b[0m \u001b[39mtry\u001b[39;00m:\n\u001b[0;32m--> <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connection.py?line=173'>174</a>\u001b[0m     conn \u001b[39m=\u001b[39m connection\u001b[39m.\u001b[39;49mcreate_connection(\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connection.py?line=174'>175</a>\u001b[0m         (\u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_dns_host, \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49mport), \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49mtimeout, \u001b[39m*\u001b[39;49m\u001b[39m*\u001b[39;49mextra_kw\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connection.py?line=175'>176</a>\u001b[0m     )\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connection.py?line=177'>178</a>\u001b[0m \u001b[39mexcept\u001b[39;00m SocketTimeout:\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/util/connection.py:72\u001b[0m, in \u001b[0;36mcreate_connection\u001b[0;34m(address, timeout, source_address, socket_options)\u001b[0m\n\u001b[1;32m     <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/util/connection.py?line=67'>68</a>\u001b[0m     \u001b[39mreturn\u001b[39;00m six\u001b[39m.\u001b[39mraise_from(\n\u001b[1;32m     <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/util/connection.py?line=68'>69</a>\u001b[0m         LocationParseError(\u001b[39mu\u001b[39m\u001b[39m\"\u001b[39m\u001b[39m'\u001b[39m\u001b[39m%s\u001b[39;00m\u001b[39m'\u001b[39m\u001b[39m, label empty or too long\u001b[39m\u001b[39m\"\u001b[39m \u001b[39m%\u001b[39m host), \u001b[39mNone\u001b[39;00m\n\u001b[1;32m     <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/util/connection.py?line=69'>70</a>\u001b[0m     )\n\u001b[0;32m---> <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/util/connection.py?line=71'>72</a>\u001b[0m \u001b[39mfor\u001b[39;00m res \u001b[39min\u001b[39;00m socket\u001b[39m.\u001b[39;49mgetaddrinfo(host, port, family, socket\u001b[39m.\u001b[39;49mSOCK_STREAM):\n\u001b[1;32m     <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/util/connection.py?line=72'>73</a>\u001b[0m     af, socktype, proto, canonname, sa \u001b[39m=\u001b[39m res\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.5/lib/python3.10/socket.py:955\u001b[0m, in \u001b[0;36mgetaddrinfo\u001b[0;34m(host, port, family, type, proto, flags)\u001b[0m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/lib/python3.10/socket.py?line=953'>954</a>\u001b[0m addrlist \u001b[39m=\u001b[39m []\n\u001b[0;32m--> <a href='file:///home/omer/.pyenv/versions/3.10.5/lib/python3.10/socket.py?line=954'>955</a>\u001b[0m \u001b[39mfor\u001b[39;00m res \u001b[39min\u001b[39;00m _socket\u001b[39m.\u001b[39;49mgetaddrinfo(host, port, family, \u001b[39mtype\u001b[39;49m, proto, flags):\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/lib/python3.10/socket.py?line=955'>956</a>\u001b[0m     af, socktype, proto, canonname, sa \u001b[39m=\u001b[39m res\n",
      "\u001b[0;31mgaierror\u001b[0m: [Errno -5] No address associated with hostname",
      "\nDuring handling of the above exception, another exception occurred:\n",
      "\u001b[0;31mNewConnectionError\u001b[0m                        Traceback (most recent call last)",
      "File \u001b[0;32m~/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py:703\u001b[0m, in \u001b[0;36mHTTPConnectionPool.urlopen\u001b[0;34m(self, method, url, body, headers, retries, redirect, assert_same_host, timeout, pool_timeout, release_conn, chunked, body_pos, **response_kw)\u001b[0m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=701'>702</a>\u001b[0m \u001b[39m# Make the request on the httplib connection object.\u001b[39;00m\n\u001b[0;32m--> <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=702'>703</a>\u001b[0m httplib_response \u001b[39m=\u001b[39m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_make_request(\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=703'>704</a>\u001b[0m     conn,\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=704'>705</a>\u001b[0m     method,\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=705'>706</a>\u001b[0m     url,\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=706'>707</a>\u001b[0m     timeout\u001b[39m=\u001b[39;49mtimeout_obj,\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=707'>708</a>\u001b[0m     body\u001b[39m=\u001b[39;49mbody,\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=708'>709</a>\u001b[0m     headers\u001b[39m=\u001b[39;49mheaders,\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=709'>710</a>\u001b[0m     chunked\u001b[39m=\u001b[39;49mchunked,\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=710'>711</a>\u001b[0m )\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=712'>713</a>\u001b[0m \u001b[39m# If we're going to release the connection in ``finally:``, then\u001b[39;00m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=713'>714</a>\u001b[0m \u001b[39m# the response doesn't need to know about the connection. Otherwise\u001b[39;00m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=714'>715</a>\u001b[0m \u001b[39m# it will also try to release it and we'll have a double-release\u001b[39;00m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=715'>716</a>\u001b[0m \u001b[39m# mess.\u001b[39;00m\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py:386\u001b[0m, in \u001b[0;36mHTTPConnectionPool._make_request\u001b[0;34m(self, conn, method, url, timeout, chunked, **httplib_request_kw)\u001b[0m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=384'>385</a>\u001b[0m \u001b[39mtry\u001b[39;00m:\n\u001b[0;32m--> <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=385'>386</a>\u001b[0m     \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_validate_conn(conn)\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=386'>387</a>\u001b[0m \u001b[39mexcept\u001b[39;00m (SocketTimeout, BaseSSLError) \u001b[39mas\u001b[39;00m e:\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=387'>388</a>\u001b[0m     \u001b[39m# Py2 raises this as a BaseSSLError, Py3 raises it as socket timeout.\u001b[39;00m\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py:1042\u001b[0m, in \u001b[0;36mHTTPSConnectionPool._validate_conn\u001b[0;34m(self, conn)\u001b[0m\n\u001b[1;32m   <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=1040'>1041</a>\u001b[0m \u001b[39mif\u001b[39;00m \u001b[39mnot\u001b[39;00m \u001b[39mgetattr\u001b[39m(conn, \u001b[39m\"\u001b[39m\u001b[39msock\u001b[39m\u001b[39m\"\u001b[39m, \u001b[39mNone\u001b[39;00m):  \u001b[39m# AppEngine might not have  `.sock`\u001b[39;00m\n\u001b[0;32m-> <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=1041'>1042</a>\u001b[0m     conn\u001b[39m.\u001b[39;49mconnect()\n\u001b[1;32m   <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=1043'>1044</a>\u001b[0m \u001b[39mif\u001b[39;00m \u001b[39mnot\u001b[39;00m conn\u001b[39m.\u001b[39mis_verified:\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connection.py:358\u001b[0m, in \u001b[0;36mHTTPSConnection.connect\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connection.py?line=355'>356</a>\u001b[0m \u001b[39mdef\u001b[39;00m \u001b[39mconnect\u001b[39m(\u001b[39mself\u001b[39m):\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connection.py?line=356'>357</a>\u001b[0m     \u001b[39m# Add certificate verification\u001b[39;00m\n\u001b[0;32m--> <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connection.py?line=357'>358</a>\u001b[0m     \u001b[39mself\u001b[39m\u001b[39m.\u001b[39msock \u001b[39m=\u001b[39m conn \u001b[39m=\u001b[39m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_new_conn()\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connection.py?line=358'>359</a>\u001b[0m     hostname \u001b[39m=\u001b[39m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mhost\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connection.py:186\u001b[0m, in \u001b[0;36mHTTPConnection._new_conn\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connection.py?line=184'>185</a>\u001b[0m \u001b[39mexcept\u001b[39;00m SocketError \u001b[39mas\u001b[39;00m e:\n\u001b[0;32m--> <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connection.py?line=185'>186</a>\u001b[0m     \u001b[39mraise\u001b[39;00m NewConnectionError(\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connection.py?line=186'>187</a>\u001b[0m         \u001b[39mself\u001b[39m, \u001b[39m\"\u001b[39m\u001b[39mFailed to establish a new connection: \u001b[39m\u001b[39m%s\u001b[39;00m\u001b[39m\"\u001b[39m \u001b[39m%\u001b[39m e\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connection.py?line=187'>188</a>\u001b[0m     )\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connection.py?line=189'>190</a>\u001b[0m \u001b[39mreturn\u001b[39;00m conn\n",
      "\u001b[0;31mNewConnectionError\u001b[0m: <urllib3.connection.HTTPSConnection object at 0x7f366a0023b0>: Failed to establish a new connection: [Errno -5] No address associated with hostname",
      "\nDuring handling of the above exception, another exception occurred:\n",
      "\u001b[0;31mMaxRetryError\u001b[0m                             Traceback (most recent call last)",
      "File \u001b[0;32m~/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py:489\u001b[0m, in \u001b[0;36mHTTPAdapter.send\u001b[0;34m(self, request, stream, timeout, verify, cert, proxies)\u001b[0m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py?line=487'>488</a>\u001b[0m \u001b[39mif\u001b[39;00m \u001b[39mnot\u001b[39;00m chunked:\n\u001b[0;32m--> <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py?line=488'>489</a>\u001b[0m     resp \u001b[39m=\u001b[39m conn\u001b[39m.\u001b[39;49murlopen(\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py?line=489'>490</a>\u001b[0m         method\u001b[39m=\u001b[39;49mrequest\u001b[39m.\u001b[39;49mmethod,\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py?line=490'>491</a>\u001b[0m         url\u001b[39m=\u001b[39;49murl,\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py?line=491'>492</a>\u001b[0m         body\u001b[39m=\u001b[39;49mrequest\u001b[39m.\u001b[39;49mbody,\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py?line=492'>493</a>\u001b[0m         headers\u001b[39m=\u001b[39;49mrequest\u001b[39m.\u001b[39;49mheaders,\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py?line=493'>494</a>\u001b[0m         redirect\u001b[39m=\u001b[39;49m\u001b[39mFalse\u001b[39;49;00m,\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py?line=494'>495</a>\u001b[0m         assert_same_host\u001b[39m=\u001b[39;49m\u001b[39mFalse\u001b[39;49;00m,\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py?line=495'>496</a>\u001b[0m         preload_content\u001b[39m=\u001b[39;49m\u001b[39mFalse\u001b[39;49;00m,\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py?line=496'>497</a>\u001b[0m         decode_content\u001b[39m=\u001b[39;49m\u001b[39mFalse\u001b[39;49;00m,\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py?line=497'>498</a>\u001b[0m         retries\u001b[39m=\u001b[39;49m\u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49mmax_retries,\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py?line=498'>499</a>\u001b[0m         timeout\u001b[39m=\u001b[39;49mtimeout,\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py?line=499'>500</a>\u001b[0m     )\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py?line=501'>502</a>\u001b[0m \u001b[39m# Send the request.\u001b[39;00m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py?line=502'>503</a>\u001b[0m \u001b[39melse\u001b[39;00m:\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py:787\u001b[0m, in \u001b[0;36mHTTPConnectionPool.urlopen\u001b[0;34m(self, method, url, body, headers, retries, redirect, assert_same_host, timeout, pool_timeout, release_conn, chunked, body_pos, **response_kw)\u001b[0m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=784'>785</a>\u001b[0m     e \u001b[39m=\u001b[39m ProtocolError(\u001b[39m\"\u001b[39m\u001b[39mConnection aborted.\u001b[39m\u001b[39m\"\u001b[39m, e)\n\u001b[0;32m--> <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=786'>787</a>\u001b[0m retries \u001b[39m=\u001b[39m retries\u001b[39m.\u001b[39;49mincrement(\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=787'>788</a>\u001b[0m     method, url, error\u001b[39m=\u001b[39;49me, _pool\u001b[39m=\u001b[39;49m\u001b[39mself\u001b[39;49m, _stacktrace\u001b[39m=\u001b[39;49msys\u001b[39m.\u001b[39;49mexc_info()[\u001b[39m2\u001b[39;49m]\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=788'>789</a>\u001b[0m )\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/connectionpool.py?line=789'>790</a>\u001b[0m retries\u001b[39m.\u001b[39msleep()\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/util/retry.py:592\u001b[0m, in \u001b[0;36mRetry.increment\u001b[0;34m(self, method, url, response, error, _pool, _stacktrace)\u001b[0m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/util/retry.py?line=590'>591</a>\u001b[0m \u001b[39mif\u001b[39;00m new_retry\u001b[39m.\u001b[39mis_exhausted():\n\u001b[0;32m--> <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/util/retry.py?line=591'>592</a>\u001b[0m     \u001b[39mraise\u001b[39;00m MaxRetryError(_pool, url, error \u001b[39mor\u001b[39;00m ResponseError(cause))\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/urllib3/util/retry.py?line=593'>594</a>\u001b[0m log\u001b[39m.\u001b[39mdebug(\u001b[39m\"\u001b[39m\u001b[39mIncremented Retry for (url=\u001b[39m\u001b[39m'\u001b[39m\u001b[39m%s\u001b[39;00m\u001b[39m'\u001b[39m\u001b[39m): \u001b[39m\u001b[39m%r\u001b[39;00m\u001b[39m\"\u001b[39m, url, new_retry)\n",
      "\u001b[0;31mMaxRetryError\u001b[0m: HTTPSConnectionPool(host='connectora', port=8080): Max retries exceeded with url: /api/ids/description?recipient=https%3A%2F%2Fconnectorb%3A8081%2Fapi%2Fids%2Fdata (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x7f366a0023b0>: Failed to establish a new connection: [Errno -5] No address associated with hostname'))",
      "\nDuring handling of the above exception, another exception occurred:\n",
      "\u001b[0;31mConnectionError\u001b[0m                           Traceback (most recent call last)",
      "\u001b[1;32m/home/omer/ids/BA/intake-ids/test_catalog.ipynb Cell 1'\u001b[0m in \u001b[0;36m<cell line: 8>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      <a href='vscode-notebook-cell://ssh-remote%2Boakleaf.duckdns.org/home/omer/ids/BA/intake-ids/test_catalog.ipynb#ch0000000vscode-remote?line=4'>5</a>\u001b[0m provider_url \u001b[39m=\u001b[39m \u001b[39m\"\u001b[39m\u001b[39mhttps://connectorb:8081\u001b[39m\u001b[39m\"\u001b[39m\n\u001b[1;32m      <a href='vscode-notebook-cell://ssh-remote%2Boakleaf.duckdns.org/home/omer/ids/BA/intake-ids/test_catalog.ipynb#ch0000000vscode-remote?line=5'>6</a>\u001b[0m consumer_url \u001b[39m=\u001b[39m \u001b[39m\"\u001b[39m\u001b[39mhttps://connectora:8080\u001b[39m\u001b[39m\"\u001b[39m\n\u001b[0;32m----> <a href='vscode-notebook-cell://ssh-remote%2Boakleaf.duckdns.org/home/omer/ids/BA/intake-ids/test_catalog.ipynb#ch0000000vscode-remote?line=7'>8</a>\u001b[0m catalog \u001b[39m=\u001b[39m ConnectorCatalog(provider_url\u001b[39m=\u001b[39;49mprovider_url, consumer_url\u001b[39m=\u001b[39;49mconsumer_url, name\u001b[39m=\u001b[39;49m\u001b[39m\"\u001b[39;49m\u001b[39mtestcat\u001b[39;49m\u001b[39m\"\u001b[39;49m, auth\u001b[39m=\u001b[39;49m(\u001b[39m\"\u001b[39;49m\u001b[39madmin\u001b[39;49m\u001b[39m\"\u001b[39;49m, \u001b[39m\"\u001b[39;49m\u001b[39mpassword\u001b[39;49m\u001b[39m\"\u001b[39;49m))\n\u001b[1;32m      <a href='vscode-notebook-cell://ssh-remote%2Boakleaf.duckdns.org/home/omer/ids/BA/intake-ids/test_catalog.ipynb#ch0000000vscode-remote?line=8'>9</a>\u001b[0m catalog\n",
      "File \u001b[0;32m~/ids/BA/intake-ids/intake_ids/catalog.py:21\u001b[0m, in \u001b[0;36mConnectorCatalog.__init__\u001b[0;34m(self, provider_url, consumer_url, name, auth, catalog_id, metadata, **kwargs)\u001b[0m\n\u001b[1;32m     <a href='file:///home/omer/ids/BA/intake-ids/intake_ids/catalog.py?line=16'>17</a>\u001b[0m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mrecipient_url \u001b[39m=\u001b[39m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mprovider_url \u001b[39m+\u001b[39m \u001b[39m\"\u001b[39m\u001b[39m/api/ids/data\u001b[39m\u001b[39m\"\u001b[39m\n\u001b[1;32m     <a href='file:///home/omer/ids/BA/intake-ids/intake_ids/catalog.py?line=18'>19</a>\u001b[0m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_offers \u001b[39m=\u001b[39m {}\n\u001b[0;32m---> <a href='file:///home/omer/ids/BA/intake-ids/intake_ids/catalog.py?line=20'>21</a>\u001b[0m \u001b[39msuper\u001b[39;49m()\u001b[39m.\u001b[39;49m\u001b[39m__init__\u001b[39;49m(name\u001b[39m=\u001b[39;49mname, metadata\u001b[39m=\u001b[39;49mmetadata, \u001b[39m*\u001b[39;49m\u001b[39m*\u001b[39;49mkwargs)\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/intake/catalog/base.py:110\u001b[0m, in \u001b[0;36mCatalog.__init__\u001b[0;34m(self, entries, name, description, metadata, ttl, getenv, getshell, persist_mode, storage_options, user_parameters)\u001b[0m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/intake/catalog/base.py?line=107'>108</a>\u001b[0m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mupdated \u001b[39m=\u001b[39m time\u001b[39m.\u001b[39mtime()\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/intake/catalog/base.py?line=108'>109</a>\u001b[0m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_entries \u001b[39m=\u001b[39m entries \u001b[39mif\u001b[39;00m entries \u001b[39mis\u001b[39;00m \u001b[39mnot\u001b[39;00m \u001b[39mNone\u001b[39;00m \u001b[39melse\u001b[39;00m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_make_entries_container()\n\u001b[0;32m--> <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/intake/catalog/base.py?line=109'>110</a>\u001b[0m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49mforce_reload()\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/intake/catalog/base.py:168\u001b[0m, in \u001b[0;36mCatalog.force_reload\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/intake/catalog/base.py?line=165'>166</a>\u001b[0m \u001b[39m\"\"\"Imperative reload data now\"\"\"\u001b[39;00m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/intake/catalog/base.py?line=166'>167</a>\u001b[0m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mupdated \u001b[39m=\u001b[39m time\u001b[39m.\u001b[39mtime()\n\u001b[0;32m--> <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/intake/catalog/base.py?line=167'>168</a>\u001b[0m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_load()\n",
      "File \u001b[0;32m~/ids/BA/intake-ids/intake_ids/catalog.py:27\u001b[0m, in \u001b[0;36mConnectorCatalog._load\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m     <a href='file:///home/omer/ids/BA/intake-ids/intake_ids/catalog.py?line=24'>25</a>\u001b[0m     \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_load_catalog(\u001b[39mself\u001b[39m\u001b[39m.\u001b[39mcatalog_id)\n\u001b[1;32m     <a href='file:///home/omer/ids/BA/intake-ids/intake_ids/catalog.py?line=25'>26</a>\u001b[0m \u001b[39melse\u001b[39;00m:\n\u001b[0;32m---> <a href='file:///home/omer/ids/BA/intake-ids/intake_ids/catalog.py?line=26'>27</a>\u001b[0m     connector \u001b[39m=\u001b[39m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49mconsumer\u001b[39m.\u001b[39;49mdescriptionRequest(\u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49mrecipient_url)\n\u001b[1;32m     <a href='file:///home/omer/ids/BA/intake-ids/intake_ids/catalog.py?line=27'>28</a>\u001b[0m     \u001b[39mfor\u001b[39;00m cat \u001b[39min\u001b[39;00m connector\u001b[39m.\u001b[39mget(\u001b[39m'\u001b[39m\u001b[39mids:resourceCatalog\u001b[39m\u001b[39m'\u001b[39m, []):\n\u001b[1;32m     <a href='file:///home/omer/ids/BA/intake-ids/intake_ids/catalog.py?line=28'>29</a>\u001b[0m         \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_load_catalog(cat[\u001b[39m'\u001b[39m\u001b[39m@id\u001b[39m\u001b[39m'\u001b[39m])\n",
      "File \u001b[0;32m~/ids/BA/intake-ids/intake_ids/vendor/idsapi.py:43\u001b[0m, in \u001b[0;36mIdsApi.descriptionRequest\u001b[0;34m(self, recipient, elementId)\u001b[0m\n\u001b[1;32m     <a href='file:///home/omer/ids/BA/intake-ids/intake_ids/vendor/idsapi.py?line=39'>40</a>\u001b[0m \u001b[39mif\u001b[39;00m elementId \u001b[39mis\u001b[39;00m \u001b[39mnot\u001b[39;00m \u001b[39mNone\u001b[39;00m:\n\u001b[1;32m     <a href='file:///home/omer/ids/BA/intake-ids/intake_ids/vendor/idsapi.py?line=40'>41</a>\u001b[0m     params[\u001b[39m\"\u001b[39m\u001b[39melementId\u001b[39m\u001b[39m\"\u001b[39m] \u001b[39m=\u001b[39m elementId\n\u001b[0;32m---> <a href='file:///home/omer/ids/BA/intake-ids/intake_ids/vendor/idsapi.py?line=42'>43</a>\u001b[0m response \u001b[39m=\u001b[39m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49msession\u001b[39m.\u001b[39;49mpost(url, params\u001b[39m=\u001b[39;49mparams)\n\u001b[1;32m     <a href='file:///home/omer/ids/BA/intake-ids/intake_ids/vendor/idsapi.py?line=43'>44</a>\u001b[0m \u001b[39mreturn\u001b[39;00m json\u001b[39m.\u001b[39mloads(response\u001b[39m.\u001b[39mtext)\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py:635\u001b[0m, in \u001b[0;36mSession.post\u001b[0;34m(self, url, data, json, **kwargs)\u001b[0m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py?line=623'>624</a>\u001b[0m \u001b[39mdef\u001b[39;00m \u001b[39mpost\u001b[39m(\u001b[39mself\u001b[39m, url, data\u001b[39m=\u001b[39m\u001b[39mNone\u001b[39;00m, json\u001b[39m=\u001b[39m\u001b[39mNone\u001b[39;00m, \u001b[39m*\u001b[39m\u001b[39m*\u001b[39mkwargs):\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py?line=624'>625</a>\u001b[0m     \u001b[39mr\u001b[39m\u001b[39m\"\"\"Sends a POST request. Returns :class:`Response` object.\u001b[39;00m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py?line=625'>626</a>\u001b[0m \n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py?line=626'>627</a>\u001b[0m \u001b[39m    :param url: URL for the new :class:`Request` object.\u001b[39;00m\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py?line=631'>632</a>\u001b[0m \u001b[39m    :rtype: requests.Response\u001b[39;00m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py?line=632'>633</a>\u001b[0m \u001b[39m    \"\"\"\u001b[39;00m\n\u001b[0;32m--> <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py?line=634'>635</a>\u001b[0m     \u001b[39mreturn\u001b[39;00m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49mrequest(\u001b[39m\"\u001b[39;49m\u001b[39mPOST\u001b[39;49m\u001b[39m\"\u001b[39;49m, url, data\u001b[39m=\u001b[39;49mdata, json\u001b[39m=\u001b[39;49mjson, \u001b[39m*\u001b[39;49m\u001b[39m*\u001b[39;49mkwargs)\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py:587\u001b[0m, in \u001b[0;36mSession.request\u001b[0;34m(self, method, url, params, data, headers, cookies, files, auth, timeout, allow_redirects, proxies, hooks, stream, verify, cert, json)\u001b[0m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py?line=581'>582</a>\u001b[0m send_kwargs \u001b[39m=\u001b[39m {\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py?line=582'>583</a>\u001b[0m     \u001b[39m\"\u001b[39m\u001b[39mtimeout\u001b[39m\u001b[39m\"\u001b[39m: timeout,\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py?line=583'>584</a>\u001b[0m     \u001b[39m\"\u001b[39m\u001b[39mallow_redirects\u001b[39m\u001b[39m\"\u001b[39m: allow_redirects,\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py?line=584'>585</a>\u001b[0m }\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py?line=585'>586</a>\u001b[0m send_kwargs\u001b[39m.\u001b[39mupdate(settings)\n\u001b[0;32m--> <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py?line=586'>587</a>\u001b[0m resp \u001b[39m=\u001b[39m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49msend(prep, \u001b[39m*\u001b[39;49m\u001b[39m*\u001b[39;49msend_kwargs)\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py?line=588'>589</a>\u001b[0m \u001b[39mreturn\u001b[39;00m resp\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py:701\u001b[0m, in \u001b[0;36mSession.send\u001b[0;34m(self, request, **kwargs)\u001b[0m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py?line=697'>698</a>\u001b[0m start \u001b[39m=\u001b[39m preferred_clock()\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py?line=699'>700</a>\u001b[0m \u001b[39m# Send the request\u001b[39;00m\n\u001b[0;32m--> <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py?line=700'>701</a>\u001b[0m r \u001b[39m=\u001b[39m adapter\u001b[39m.\u001b[39;49msend(request, \u001b[39m*\u001b[39;49m\u001b[39m*\u001b[39;49mkwargs)\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py?line=702'>703</a>\u001b[0m \u001b[39m# Total elapsed time of the request (approximately)\u001b[39;00m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/sessions.py?line=703'>704</a>\u001b[0m elapsed \u001b[39m=\u001b[39m preferred_clock() \u001b[39m-\u001b[39m start\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py:565\u001b[0m, in \u001b[0;36mHTTPAdapter.send\u001b[0;34m(self, request, stream, timeout, verify, cert, proxies)\u001b[0m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py?line=560'>561</a>\u001b[0m     \u001b[39mif\u001b[39;00m \u001b[39misinstance\u001b[39m(e\u001b[39m.\u001b[39mreason, _SSLError):\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py?line=561'>562</a>\u001b[0m         \u001b[39m# This branch is for urllib3 v1.22 and later.\u001b[39;00m\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py?line=562'>563</a>\u001b[0m         \u001b[39mraise\u001b[39;00m SSLError(e, request\u001b[39m=\u001b[39mrequest)\n\u001b[0;32m--> <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py?line=564'>565</a>\u001b[0m     \u001b[39mraise\u001b[39;00m \u001b[39mConnectionError\u001b[39;00m(e, request\u001b[39m=\u001b[39mrequest)\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py?line=566'>567</a>\u001b[0m \u001b[39mexcept\u001b[39;00m ClosedPoolError \u001b[39mas\u001b[39;00m e:\n\u001b[1;32m    <a href='file:///home/omer/.pyenv/versions/3.10.5/envs/INTAKEIDS/lib/python3.10/site-packages/requests/adapters.py?line=567'>568</a>\u001b[0m     \u001b[39mraise\u001b[39;00m \u001b[39mConnectionError\u001b[39;00m(e, request\u001b[39m=\u001b[39mrequest)\n",
      "\u001b[0;31mConnectionError\u001b[0m: HTTPSConnectionPool(host='connectora', port=8080): Max retries exceeded with url: /api/ids/description?recipient=https%3A%2F%2Fconnectorb%3A8081%2Fapi%2Fids%2Fdata (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x7f366a0023b0>: Failed to establish a new connection: [Errno -5] No address associated with hostname'))"
     ]
    }
   ],
   "source": [
    "from intake_ids import ConnectorCatalog\n",
    "\n",
    "provider_url = \"https://provider:8080\"\n",
    "consumer_url = \"https://consumer:8080\"\n",
    "# provider_url = \"https://connectorb:8081\"\n",
    "# consumer_url = \"https://connectora:8080\"\n",
    "\n",
    "catalog = ConnectorCatalog(provider_url=provider_url, consumer_url=consumer_url, name=\"testcat\", auth=(\"admin\", \"password\"))\n",
    "catalog"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(list(catalog))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "last_entry: any\n",
    "for entry_id, entry in catalog.items():\n",
    "    # display(entry)\n",
    "    last_entry = entry"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "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>_id</th>\n",
       "      <th>Date and time (YYYY-MM-DD HH:MM:SS)</th>\n",
       "      <th>Temperature (Degree Celcius)</th>\n",
       "      <th>Global irradiance (W/m^2)</th>\n",
       "      <th>Humidity (%)</th>\n",
       "      <th>Atmospheric pressure (hPa; not normalized to sea level)</th>\n",
       "      <th>Precipitation (mm)</th>\n",
       "      <th>Average wind speed (km/h; 10min window)</th>\n",
       "      <th>Wind direction (Degree)</th>\n",
       "      <th>Dew point (Degree Celcius)</th>\n",
       "      <th>Apparent temperature (Degree Celcius)</th>\n",
       "      <th>Maximum wind speed (km/h; 10min window)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2017-12-01T00:05:00</td>\n",
       "      <td>1.70</td>\n",
       "      <td>-0.48</td>\n",
       "      <td>87.77</td>\n",
       "      <td>993.14</td>\n",
       "      <td>0.000</td>\n",
       "      <td>3.22</td>\n",
       "      <td>227</td>\n",
       "      <td>-0.11</td>\n",
       "      <td>1.70</td>\n",
       "      <td>4.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2017-12-01T00:15:00</td>\n",
       "      <td>1.66</td>\n",
       "      <td>-0.52</td>\n",
       "      <td>88.24</td>\n",
       "      <td>993.14</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.64</td>\n",
       "      <td>239</td>\n",
       "      <td>-0.07</td>\n",
       "      <td>1.66</td>\n",
       "      <td>3.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>2017-12-01T00:25:00</td>\n",
       "      <td>1.62</td>\n",
       "      <td>-0.38</td>\n",
       "      <td>88.49</td>\n",
       "      <td>993.08</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2.84</td>\n",
       "      <td>233</td>\n",
       "      <td>-0.08</td>\n",
       "      <td>1.62</td>\n",
       "      <td>3.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>2017-12-01T00:35:00</td>\n",
       "      <td>1.60</td>\n",
       "      <td>-0.44</td>\n",
       "      <td>88.76</td>\n",
       "      <td>993.08</td>\n",
       "      <td>0.000</td>\n",
       "      <td>3.12</td>\n",
       "      <td>230</td>\n",
       "      <td>-0.05</td>\n",
       "      <td>1.60</td>\n",
       "      <td>5.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>2017-12-01T00:45:00</td>\n",
       "      <td>1.58</td>\n",
       "      <td>-0.45</td>\n",
       "      <td>89.07</td>\n",
       "      <td>993.02</td>\n",
       "      <td>0.000</td>\n",
       "      <td>4.48</td>\n",
       "      <td>202</td>\n",
       "      <td>-0.02</td>\n",
       "      <td>1.58</td>\n",
       "      <td>7.67</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>996</td>\n",
       "      <td>2017-12-07T23:25:00</td>\n",
       "      <td>7.46</td>\n",
       "      <td>-0.43</td>\n",
       "      <td>75.33</td>\n",
       "      <td>996.96</td>\n",
       "      <td>0.190</td>\n",
       "      <td>17.82</td>\n",
       "      <td>230</td>\n",
       "      <td>3.39</td>\n",
       "      <td>7.46</td>\n",
       "      <td>23.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>997</td>\n",
       "      <td>2017-12-07T23:35:00</td>\n",
       "      <td>7.20</td>\n",
       "      <td>-0.49</td>\n",
       "      <td>77.99</td>\n",
       "      <td>996.81</td>\n",
       "      <td>0.205</td>\n",
       "      <td>16.67</td>\n",
       "      <td>231</td>\n",
       "      <td>3.63</td>\n",
       "      <td>7.20</td>\n",
       "      <td>22.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>998</td>\n",
       "      <td>2017-12-07T23:45:00</td>\n",
       "      <td>7.04</td>\n",
       "      <td>-0.45</td>\n",
       "      <td>79.92</td>\n",
       "      <td>996.70</td>\n",
       "      <td>0.105</td>\n",
       "      <td>14.00</td>\n",
       "      <td>232</td>\n",
       "      <td>3.81</td>\n",
       "      <td>7.04</td>\n",
       "      <td>20.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>999</td>\n",
       "      <td>2017-12-07T23:55:00</td>\n",
       "      <td>7.14</td>\n",
       "      <td>-0.41</td>\n",
       "      <td>79.36</td>\n",
       "      <td>996.70</td>\n",
       "      <td>0.045</td>\n",
       "      <td>16.20</td>\n",
       "      <td>244</td>\n",
       "      <td>3.81</td>\n",
       "      <td>7.14</td>\n",
       "      <td>20.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>1000</td>\n",
       "      <td>2017-12-08T00:05:00</td>\n",
       "      <td>7.10</td>\n",
       "      <td>-0.44</td>\n",
       "      <td>79.88</td>\n",
       "      <td>996.72</td>\n",
       "      <td>0.025</td>\n",
       "      <td>15.33</td>\n",
       "      <td>238</td>\n",
       "      <td>3.87</td>\n",
       "      <td>7.10</td>\n",
       "      <td>23.88</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      _id Date and time (YYYY-MM-DD HH:MM:SS)  Temperature (Degree Celcius)  \\\n",
       "0       1                 2017-12-01T00:05:00                          1.70   \n",
       "1       2                 2017-12-01T00:15:00                          1.66   \n",
       "2       3                 2017-12-01T00:25:00                          1.62   \n",
       "3       4                 2017-12-01T00:35:00                          1.60   \n",
       "4       5                 2017-12-01T00:45:00                          1.58   \n",
       "..    ...                                 ...                           ...   \n",
       "995   996                 2017-12-07T23:25:00                          7.46   \n",
       "996   997                 2017-12-07T23:35:00                          7.20   \n",
       "997   998                 2017-12-07T23:45:00                          7.04   \n",
       "998   999                 2017-12-07T23:55:00                          7.14   \n",
       "999  1000                 2017-12-08T00:05:00                          7.10   \n",
       "\n",
       "     Global irradiance (W/m^2)  Humidity (%)  \\\n",
       "0                        -0.48         87.77   \n",
       "1                        -0.52         88.24   \n",
       "2                        -0.38         88.49   \n",
       "3                        -0.44         88.76   \n",
       "4                        -0.45         89.07   \n",
       "..                         ...           ...   \n",
       "995                      -0.43         75.33   \n",
       "996                      -0.49         77.99   \n",
       "997                      -0.45         79.92   \n",
       "998                      -0.41         79.36   \n",
       "999                      -0.44         79.88   \n",
       "\n",
       "     Atmospheric pressure (hPa; not normalized to sea level)  \\\n",
       "0                                               993.14         \n",
       "1                                               993.14         \n",
       "2                                               993.08         \n",
       "3                                               993.08         \n",
       "4                                               993.02         \n",
       "..                                                 ...         \n",
       "995                                             996.96         \n",
       "996                                             996.81         \n",
       "997                                             996.70         \n",
       "998                                             996.70         \n",
       "999                                             996.72         \n",
       "\n",
       "     Precipitation (mm)  Average wind speed (km/h; 10min window)  \\\n",
       "0                 0.000                                     3.22   \n",
       "1                 0.000                                     1.64   \n",
       "2                 0.000                                     2.84   \n",
       "3                 0.000                                     3.12   \n",
       "4                 0.000                                     4.48   \n",
       "..                  ...                                      ...   \n",
       "995               0.190                                    17.82   \n",
       "996               0.205                                    16.67   \n",
       "997               0.105                                    14.00   \n",
       "998               0.045                                    16.20   \n",
       "999               0.025                                    15.33   \n",
       "\n",
       "     Wind direction (Degree)  Dew point (Degree Celcius)  \\\n",
       "0                        227                       -0.11   \n",
       "1                        239                       -0.07   \n",
       "2                        233                       -0.08   \n",
       "3                        230                       -0.05   \n",
       "4                        202                       -0.02   \n",
       "..                       ...                         ...   \n",
       "995                      230                        3.39   \n",
       "996                      231                        3.63   \n",
       "997                      232                        3.81   \n",
       "998                      244                        3.81   \n",
       "999                      238                        3.87   \n",
       "\n",
       "     Apparent temperature (Degree Celcius)  \\\n",
       "0                                     1.70   \n",
       "1                                     1.66   \n",
       "2                                     1.62   \n",
       "3                                     1.60   \n",
       "4                                     1.58   \n",
       "..                                     ...   \n",
       "995                                   7.46   \n",
       "996                                   7.20   \n",
       "997                                   7.04   \n",
       "998                                   7.14   \n",
       "999                                   7.10   \n",
       "\n",
       "     Maximum wind speed (km/h; 10min window)  \n",
       "0                                       4.54  \n",
       "1                                       3.60  \n",
       "2                                       3.67  \n",
       "3                                       5.04  \n",
       "4                                       7.67  \n",
       "..                                       ...  \n",
       "995                                    23.07  \n",
       "996                                    22.64  \n",
       "997                                    20.90  \n",
       "998                                    20.02  \n",
       "999                                    23.88  \n",
       "\n",
       "[1000 rows x 12 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>_id</th>\n",
       "      <th>Date and time (YYYY-MM-DD HH:MM:SS)</th>\n",
       "      <th>Temperature (Degree Celcius)</th>\n",
       "      <th>Global irradiance (W/m^2)</th>\n",
       "      <th>Humidity (%)</th>\n",
       "      <th>Atmospheric pressure (hPa; not normalized to sea level)</th>\n",
       "      <th>Precipitation (mm)</th>\n",
       "      <th>Average wind speed (km/h; 10min window)</th>\n",
       "      <th>Wind direction (Degree)</th>\n",
       "      <th>Dew point (Degree Celcius)</th>\n",
       "      <th>Apparent temperature (Degree Celcius)</th>\n",
       "      <th>Maximum wind speed (km/h; 10min window)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2017-11-01T00:05:00</td>\n",
       "      <td>6.85</td>\n",
       "      <td>-0.29</td>\n",
       "      <td>78.11</td>\n",
       "      <td>1011.31</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.09</td>\n",
       "      <td>217</td>\n",
       "      <td>3.30</td>\n",
       "      <td>6.85</td>\n",
       "      <td>6.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2017-11-01T00:15:00</td>\n",
       "      <td>7.00</td>\n",
       "      <td>-0.23</td>\n",
       "      <td>77.68</td>\n",
       "      <td>1011.25</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.78</td>\n",
       "      <td>242</td>\n",
       "      <td>3.37</td>\n",
       "      <td>7.00</td>\n",
       "      <td>3.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>2017-11-01T00:25:00</td>\n",
       "      <td>7.09</td>\n",
       "      <td>-0.32</td>\n",
       "      <td>78.00</td>\n",
       "      <td>1011.25</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.48</td>\n",
       "      <td>238</td>\n",
       "      <td>3.51</td>\n",
       "      <td>7.09</td>\n",
       "      <td>6.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>2017-11-01T00:35:00</td>\n",
       "      <td>6.78</td>\n",
       "      <td>-0.32</td>\n",
       "      <td>79.14</td>\n",
       "      <td>1011.29</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.25</td>\n",
       "      <td>240</td>\n",
       "      <td>3.43</td>\n",
       "      <td>6.78</td>\n",
       "      <td>8.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>2017-11-01T00:45:00</td>\n",
       "      <td>6.81</td>\n",
       "      <td>-0.33</td>\n",
       "      <td>79.35</td>\n",
       "      <td>1011.19</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.16</td>\n",
       "      <td>234</td>\n",
       "      <td>3.49</td>\n",
       "      <td>6.81</td>\n",
       "      <td>8.21</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1245</th>\n",
       "      <td>1246</td>\n",
       "      <td>2017-11-09T15:44:00</td>\n",
       "      <td>6.86</td>\n",
       "      <td>10.23</td>\n",
       "      <td>92.26</td>\n",
       "      <td>1009.55</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.66</td>\n",
       "      <td>216</td>\n",
       "      <td>5.69</td>\n",
       "      <td>6.86</td>\n",
       "      <td>10.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1246</th>\n",
       "      <td>1247</td>\n",
       "      <td>2017-11-09T15:55:00</td>\n",
       "      <td>6.84</td>\n",
       "      <td>8.59</td>\n",
       "      <td>92.32</td>\n",
       "      <td>1009.58</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.57</td>\n",
       "      <td>214</td>\n",
       "      <td>5.68</td>\n",
       "      <td>6.84</td>\n",
       "      <td>11.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1247</th>\n",
       "      <td>1248</td>\n",
       "      <td>2017-11-09T16:05:00</td>\n",
       "      <td>6.84</td>\n",
       "      <td>6.59</td>\n",
       "      <td>92.21</td>\n",
       "      <td>1009.64</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.32</td>\n",
       "      <td>218</td>\n",
       "      <td>5.67</td>\n",
       "      <td>6.84</td>\n",
       "      <td>11.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1248</th>\n",
       "      <td>1249</td>\n",
       "      <td>2017-11-09T16:15:00</td>\n",
       "      <td>6.96</td>\n",
       "      <td>6.41</td>\n",
       "      <td>91.72</td>\n",
       "      <td>1009.71</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.70</td>\n",
       "      <td>207</td>\n",
       "      <td>5.71</td>\n",
       "      <td>6.96</td>\n",
       "      <td>10.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1249</th>\n",
       "      <td>1250</td>\n",
       "      <td>2017-11-09T16:24:00</td>\n",
       "      <td>6.92</td>\n",
       "      <td>7.09</td>\n",
       "      <td>91.77</td>\n",
       "      <td>1009.81</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.42</td>\n",
       "      <td>217</td>\n",
       "      <td>5.68</td>\n",
       "      <td>6.92</td>\n",
       "      <td>13.83</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1250 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       _id Date and time (YYYY-MM-DD HH:MM:SS)  Temperature (Degree Celcius)  \\\n",
       "0        1                 2017-11-01T00:05:00                          6.85   \n",
       "1        2                 2017-11-01T00:15:00                          7.00   \n",
       "2        3                 2017-11-01T00:25:00                          7.09   \n",
       "3        4                 2017-11-01T00:35:00                          6.78   \n",
       "4        5                 2017-11-01T00:45:00                          6.81   \n",
       "...    ...                                 ...                           ...   \n",
       "1245  1246                 2017-11-09T15:44:00                          6.86   \n",
       "1246  1247                 2017-11-09T15:55:00                          6.84   \n",
       "1247  1248                 2017-11-09T16:05:00                          6.84   \n",
       "1248  1249                 2017-11-09T16:15:00                          6.96   \n",
       "1249  1250                 2017-11-09T16:24:00                          6.92   \n",
       "\n",
       "      Global irradiance (W/m^2)  Humidity (%)  \\\n",
       "0                         -0.29         78.11   \n",
       "1                         -0.23         77.68   \n",
       "2                         -0.32         78.00   \n",
       "3                         -0.32         79.14   \n",
       "4                         -0.33         79.35   \n",
       "...                         ...           ...   \n",
       "1245                      10.23         92.26   \n",
       "1246                       8.59         92.32   \n",
       "1247                       6.59         92.21   \n",
       "1248                       6.41         91.72   \n",
       "1249                       7.09         91.77   \n",
       "\n",
       "      Atmospheric pressure (hPa; not normalized to sea level)  \\\n",
       "0                                               1011.31         \n",
       "1                                               1011.25         \n",
       "2                                               1011.25         \n",
       "3                                               1011.29         \n",
       "4                                               1011.19         \n",
       "...                                                 ...         \n",
       "1245                                            1009.55         \n",
       "1246                                            1009.58         \n",
       "1247                                            1009.64         \n",
       "1248                                            1009.71         \n",
       "1249                                            1009.81         \n",
       "\n",
       "      Precipitation (mm)  Average wind speed (km/h; 10min window)  \\\n",
       "0                    0.0                                     4.09   \n",
       "1                    0.0                                     2.78   \n",
       "2                    0.0                                     3.48   \n",
       "3                    0.0                                     6.25   \n",
       "4                    0.0                                     6.16   \n",
       "...                  ...                                      ...   \n",
       "1245                 0.0                                     7.66   \n",
       "1246                 0.0                                     7.57   \n",
       "1247                 0.0                                     8.32   \n",
       "1248                 0.0                                     7.70   \n",
       "1249                 0.0                                     8.42   \n",
       "\n",
       "      Wind direction (Degree)  Dew point (Degree Celcius)  \\\n",
       "0                         217                        3.30   \n",
       "1                         242                        3.37   \n",
       "2                         238                        3.51   \n",
       "3                         240                        3.43   \n",
       "4                         234                        3.49   \n",
       "...                       ...                         ...   \n",
       "1245                      216                        5.69   \n",
       "1246                      214                        5.68   \n",
       "1247                      218                        5.67   \n",
       "1248                      207                        5.71   \n",
       "1249                      217                        5.68   \n",
       "\n",
       "      Apparent temperature (Degree Celcius)  \\\n",
       "0                                      6.85   \n",
       "1                                      7.00   \n",
       "2                                      7.09   \n",
       "3                                      6.78   \n",
       "4                                      6.81   \n",
       "...                                     ...   \n",
       "1245                                   6.86   \n",
       "1246                                   6.84   \n",
       "1247                                   6.84   \n",
       "1248                                   6.96   \n",
       "1249                                   6.92   \n",
       "\n",
       "      Maximum wind speed (km/h; 10min window)  \n",
       "0                                        6.26  \n",
       "1                                        3.93  \n",
       "2                                        6.80  \n",
       "3                                        8.64  \n",
       "4                                        8.21  \n",
       "...                                       ...  \n",
       "1245                                    10.80  \n",
       "1246                                    11.30  \n",
       "1247                                    11.89  \n",
       "1248                                    10.10  \n",
       "1249                                    13.83  \n",
       "\n",
       "[1250 rows x 12 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>_id</th>\n",
       "      <th>Date and time (YYYY-MM-DD HH:MM:SS)</th>\n",
       "      <th>Temperature (Degree Celcius)</th>\n",
       "      <th>Global irradiance (W/m^2)</th>\n",
       "      <th>Humidity (%)</th>\n",
       "      <th>Atmospheric pressure (hPa; not normalized to sea level)</th>\n",
       "      <th>Precipitation (mm)</th>\n",
       "      <th>Average wind speed (km/h; 10min window)</th>\n",
       "      <th>Wind direction (Degree)</th>\n",
       "      <th>Dew point (Degree Celcius)</th>\n",
       "      <th>Apparent temperature (Degree Celcius)</th>\n",
       "      <th>Maximum wind speed (km/h; 10min window)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2017-10-01T00:02:00</td>\n",
       "      <td>12.27</td>\n",
       "      <td>-0.21</td>\n",
       "      <td>94.09</td>\n",
       "      <td>1006.33</td>\n",
       "      <td>0.010</td>\n",
       "      <td>9.49</td>\n",
       "      <td>229</td>\n",
       "      <td>11.35</td>\n",
       "      <td>12.27</td>\n",
       "      <td>12.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2017-10-01T00:12:00</td>\n",
       "      <td>12.31</td>\n",
       "      <td>-0.22</td>\n",
       "      <td>93.77</td>\n",
       "      <td>1006.47</td>\n",
       "      <td>0.000</td>\n",
       "      <td>7.94</td>\n",
       "      <td>233</td>\n",
       "      <td>11.33</td>\n",
       "      <td>12.31</td>\n",
       "      <td>12.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>2017-10-01T00:22:00</td>\n",
       "      <td>12.36</td>\n",
       "      <td>-0.19</td>\n",
       "      <td>93.50</td>\n",
       "      <td>1006.45</td>\n",
       "      <td>0.005</td>\n",
       "      <td>8.37</td>\n",
       "      <td>229</td>\n",
       "      <td>11.34</td>\n",
       "      <td>12.36</td>\n",
       "      <td>11.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>2017-10-01T00:32:00</td>\n",
       "      <td>12.34</td>\n",
       "      <td>-0.19</td>\n",
       "      <td>93.42</td>\n",
       "      <td>1006.43</td>\n",
       "      <td>0.000</td>\n",
       "      <td>7.66</td>\n",
       "      <td>229</td>\n",
       "      <td>11.31</td>\n",
       "      <td>12.34</td>\n",
       "      <td>11.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>2017-10-01T00:42:00</td>\n",
       "      <td>12.37</td>\n",
       "      <td>-0.23</td>\n",
       "      <td>93.49</td>\n",
       "      <td>1006.43</td>\n",
       "      <td>0.000</td>\n",
       "      <td>7.77</td>\n",
       "      <td>222</td>\n",
       "      <td>11.35</td>\n",
       "      <td>12.37</td>\n",
       "      <td>10.34</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3495</th>\n",
       "      <td>3496</td>\n",
       "      <td>2017-10-25T06:56:00</td>\n",
       "      <td>13.59</td>\n",
       "      <td>-0.13</td>\n",
       "      <td>84.74</td>\n",
       "      <td>1009.17</td>\n",
       "      <td>0.000</td>\n",
       "      <td>6.79</td>\n",
       "      <td>196</td>\n",
       "      <td>11.07</td>\n",
       "      <td>13.59</td>\n",
       "      <td>9.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3496</th>\n",
       "      <td>3497</td>\n",
       "      <td>2017-10-25T07:06:00</td>\n",
       "      <td>13.64</td>\n",
       "      <td>-0.12</td>\n",
       "      <td>84.32</td>\n",
       "      <td>1009.07</td>\n",
       "      <td>0.000</td>\n",
       "      <td>5.98</td>\n",
       "      <td>196</td>\n",
       "      <td>11.05</td>\n",
       "      <td>13.64</td>\n",
       "      <td>8.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3497</th>\n",
       "      <td>3498</td>\n",
       "      <td>2017-10-25T07:16:00</td>\n",
       "      <td>13.65</td>\n",
       "      <td>-0.14</td>\n",
       "      <td>84.18</td>\n",
       "      <td>1008.93</td>\n",
       "      <td>0.000</td>\n",
       "      <td>7.52</td>\n",
       "      <td>192</td>\n",
       "      <td>11.03</td>\n",
       "      <td>13.65</td>\n",
       "      <td>9.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3498</th>\n",
       "      <td>3499</td>\n",
       "      <td>2017-10-25T07:26:00</td>\n",
       "      <td>13.56</td>\n",
       "      <td>-0.11</td>\n",
       "      <td>84.29</td>\n",
       "      <td>1008.99</td>\n",
       "      <td>0.000</td>\n",
       "      <td>6.16</td>\n",
       "      <td>191</td>\n",
       "      <td>10.96</td>\n",
       "      <td>13.56</td>\n",
       "      <td>7.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3499</th>\n",
       "      <td>3500</td>\n",
       "      <td>2017-10-25T07:36:00</td>\n",
       "      <td>13.46</td>\n",
       "      <td>-0.01</td>\n",
       "      <td>85.18</td>\n",
       "      <td>1009.04</td>\n",
       "      <td>0.000</td>\n",
       "      <td>5.00</td>\n",
       "      <td>205</td>\n",
       "      <td>11.02</td>\n",
       "      <td>13.46</td>\n",
       "      <td>7.12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3500 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       _id Date and time (YYYY-MM-DD HH:MM:SS)  Temperature (Degree Celcius)  \\\n",
       "0        1                 2017-10-01T00:02:00                         12.27   \n",
       "1        2                 2017-10-01T00:12:00                         12.31   \n",
       "2        3                 2017-10-01T00:22:00                         12.36   \n",
       "3        4                 2017-10-01T00:32:00                         12.34   \n",
       "4        5                 2017-10-01T00:42:00                         12.37   \n",
       "...    ...                                 ...                           ...   \n",
       "3495  3496                 2017-10-25T06:56:00                         13.59   \n",
       "3496  3497                 2017-10-25T07:06:00                         13.64   \n",
       "3497  3498                 2017-10-25T07:16:00                         13.65   \n",
       "3498  3499                 2017-10-25T07:26:00                         13.56   \n",
       "3499  3500                 2017-10-25T07:36:00                         13.46   \n",
       "\n",
       "      Global irradiance (W/m^2)  Humidity (%)  \\\n",
       "0                         -0.21         94.09   \n",
       "1                         -0.22         93.77   \n",
       "2                         -0.19         93.50   \n",
       "3                         -0.19         93.42   \n",
       "4                         -0.23         93.49   \n",
       "...                         ...           ...   \n",
       "3495                      -0.13         84.74   \n",
       "3496                      -0.12         84.32   \n",
       "3497                      -0.14         84.18   \n",
       "3498                      -0.11         84.29   \n",
       "3499                      -0.01         85.18   \n",
       "\n",
       "      Atmospheric pressure (hPa; not normalized to sea level)  \\\n",
       "0                                               1006.33         \n",
       "1                                               1006.47         \n",
       "2                                               1006.45         \n",
       "3                                               1006.43         \n",
       "4                                               1006.43         \n",
       "...                                                 ...         \n",
       "3495                                            1009.17         \n",
       "3496                                            1009.07         \n",
       "3497                                            1008.93         \n",
       "3498                                            1008.99         \n",
       "3499                                            1009.04         \n",
       "\n",
       "      Precipitation (mm)  Average wind speed (km/h; 10min window)  \\\n",
       "0                  0.010                                     9.49   \n",
       "1                  0.000                                     7.94   \n",
       "2                  0.005                                     8.37   \n",
       "3                  0.000                                     7.66   \n",
       "4                  0.000                                     7.77   \n",
       "...                  ...                                      ...   \n",
       "3495               0.000                                     6.79   \n",
       "3496               0.000                                     5.98   \n",
       "3497               0.000                                     7.52   \n",
       "3498               0.000                                     6.16   \n",
       "3499               0.000                                     5.00   \n",
       "\n",
       "      Wind direction (Degree)  Dew point (Degree Celcius)  \\\n",
       "0                         229                       11.35   \n",
       "1                         233                       11.33   \n",
       "2                         229                       11.34   \n",
       "3                         229                       11.31   \n",
       "4                         222                       11.35   \n",
       "...                       ...                         ...   \n",
       "3495                      196                       11.07   \n",
       "3496                      196                       11.05   \n",
       "3497                      192                       11.03   \n",
       "3498                      191                       10.96   \n",
       "3499                      205                       11.02   \n",
       "\n",
       "      Apparent temperature (Degree Celcius)  \\\n",
       "0                                     12.27   \n",
       "1                                     12.31   \n",
       "2                                     12.36   \n",
       "3                                     12.34   \n",
       "4                                     12.37   \n",
       "...                                     ...   \n",
       "3495                                  13.59   \n",
       "3496                                  13.64   \n",
       "3497                                  13.65   \n",
       "3498                                  13.56   \n",
       "3499                                  13.46   \n",
       "\n",
       "      Maximum wind speed (km/h; 10min window)  \n",
       "0                                       12.96  \n",
       "1                                       12.09  \n",
       "2                                       11.17  \n",
       "3                                       11.86  \n",
       "4                                       10.34  \n",
       "...                                       ...  \n",
       "3495                                     9.01  \n",
       "3496                                     8.80  \n",
       "3497                                     9.34  \n",
       "3498                                     7.54  \n",
       "3499                                     7.12  \n",
       "\n",
       "[3500 rows x 12 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>_id</th>\n",
       "      <th>Date and time (YYYY-MM-DD HH:MM:SS)</th>\n",
       "      <th>Temperature (Degree Celcius)</th>\n",
       "      <th>Global irradiance (W/m^2)</th>\n",
       "      <th>Humidity (%)</th>\n",
       "      <th>Atmospheric pressure (hPa; not normalized to sea level)</th>\n",
       "      <th>Precipitation (mm)</th>\n",
       "      <th>Average wind speed (km/h; 10min window)</th>\n",
       "      <th>Wind direction (Degree)</th>\n",
       "      <th>Dew point (Degree Celcius)</th>\n",
       "      <th>Apparent temperature (Degree Celcius)</th>\n",
       "      <th>Maximum wind speed (km/h; 10min window)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2017-09-01T00:03:00</td>\n",
       "      <td>15.92</td>\n",
       "      <td>-0.10</td>\n",
       "      <td>79.82</td>\n",
       "      <td>1007.02</td>\n",
       "      <td>0.000</td>\n",
       "      <td>6.12</td>\n",
       "      <td>224</td>\n",
       "      <td>12.45</td>\n",
       "      <td>15.92</td>\n",
       "      <td>10.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2017-09-01T00:13:00</td>\n",
       "      <td>15.88</td>\n",
       "      <td>-0.11</td>\n",
       "      <td>79.66</td>\n",
       "      <td>1007.08</td>\n",
       "      <td>0.000</td>\n",
       "      <td>5.93</td>\n",
       "      <td>223</td>\n",
       "      <td>12.38</td>\n",
       "      <td>15.88</td>\n",
       "      <td>7.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>2017-09-01T00:23:00</td>\n",
       "      <td>15.91</td>\n",
       "      <td>-0.03</td>\n",
       "      <td>79.32</td>\n",
       "      <td>1007.04</td>\n",
       "      <td>0.000</td>\n",
       "      <td>6.05</td>\n",
       "      <td>227</td>\n",
       "      <td>12.34</td>\n",
       "      <td>15.91</td>\n",
       "      <td>9.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>2017-09-01T00:33:00</td>\n",
       "      <td>15.90</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>79.14</td>\n",
       "      <td>1007.08</td>\n",
       "      <td>0.000</td>\n",
       "      <td>4.18</td>\n",
       "      <td>242</td>\n",
       "      <td>12.29</td>\n",
       "      <td>15.90</td>\n",
       "      <td>9.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>2017-09-01T00:43:00</td>\n",
       "      <td>15.89</td>\n",
       "      <td>-0.01</td>\n",
       "      <td>79.33</td>\n",
       "      <td>1007.00</td>\n",
       "      <td>0.000</td>\n",
       "      <td>5.41</td>\n",
       "      <td>230</td>\n",
       "      <td>12.32</td>\n",
       "      <td>15.89</td>\n",
       "      <td>7.50</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4314</th>\n",
       "      <td>4315</td>\n",
       "      <td>2017-09-30T23:12:00</td>\n",
       "      <td>12.35</td>\n",
       "      <td>-0.20</td>\n",
       "      <td>94.30</td>\n",
       "      <td>1006.45</td>\n",
       "      <td>0.045</td>\n",
       "      <td>6.25</td>\n",
       "      <td>243</td>\n",
       "      <td>11.46</td>\n",
       "      <td>12.35</td>\n",
       "      <td>8.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4315</th>\n",
       "      <td>4316</td>\n",
       "      <td>2017-09-30T23:22:00</td>\n",
       "      <td>12.24</td>\n",
       "      <td>-0.20</td>\n",
       "      <td>94.36</td>\n",
       "      <td>1006.45</td>\n",
       "      <td>0.075</td>\n",
       "      <td>5.30</td>\n",
       "      <td>238</td>\n",
       "      <td>11.36</td>\n",
       "      <td>12.24</td>\n",
       "      <td>9.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4316</th>\n",
       "      <td>4317</td>\n",
       "      <td>2017-09-30T23:32:00</td>\n",
       "      <td>12.24</td>\n",
       "      <td>-0.20</td>\n",
       "      <td>94.56</td>\n",
       "      <td>1006.45</td>\n",
       "      <td>0.075</td>\n",
       "      <td>6.14</td>\n",
       "      <td>236</td>\n",
       "      <td>11.39</td>\n",
       "      <td>12.24</td>\n",
       "      <td>8.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4317</th>\n",
       "      <td>4318</td>\n",
       "      <td>2017-09-30T23:42:00</td>\n",
       "      <td>12.20</td>\n",
       "      <td>-0.23</td>\n",
       "      <td>94.69</td>\n",
       "      <td>1006.45</td>\n",
       "      <td>0.030</td>\n",
       "      <td>5.19</td>\n",
       "      <td>237</td>\n",
       "      <td>11.37</td>\n",
       "      <td>12.20</td>\n",
       "      <td>8.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4318</th>\n",
       "      <td>4319</td>\n",
       "      <td>2017-09-30T23:52:00</td>\n",
       "      <td>12.19</td>\n",
       "      <td>-0.25</td>\n",
       "      <td>94.50</td>\n",
       "      <td>1006.45</td>\n",
       "      <td>0.025</td>\n",
       "      <td>8.81</td>\n",
       "      <td>227</td>\n",
       "      <td>11.34</td>\n",
       "      <td>12.19</td>\n",
       "      <td>11.68</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4319 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       _id Date and time (YYYY-MM-DD HH:MM:SS)  Temperature (Degree Celcius)  \\\n",
       "0        1                 2017-09-01T00:03:00                         15.92   \n",
       "1        2                 2017-09-01T00:13:00                         15.88   \n",
       "2        3                 2017-09-01T00:23:00                         15.91   \n",
       "3        4                 2017-09-01T00:33:00                         15.90   \n",
       "4        5                 2017-09-01T00:43:00                         15.89   \n",
       "...    ...                                 ...                           ...   \n",
       "4314  4315                 2017-09-30T23:12:00                         12.35   \n",
       "4315  4316                 2017-09-30T23:22:00                         12.24   \n",
       "4316  4317                 2017-09-30T23:32:00                         12.24   \n",
       "4317  4318                 2017-09-30T23:42:00                         12.20   \n",
       "4318  4319                 2017-09-30T23:52:00                         12.19   \n",
       "\n",
       "      Global irradiance (W/m^2)  Humidity (%)  \\\n",
       "0                         -0.10         79.82   \n",
       "1                         -0.11         79.66   \n",
       "2                         -0.03         79.32   \n",
       "3                         -0.04         79.14   \n",
       "4                         -0.01         79.33   \n",
       "...                         ...           ...   \n",
       "4314                      -0.20         94.30   \n",
       "4315                      -0.20         94.36   \n",
       "4316                      -0.20         94.56   \n",
       "4317                      -0.23         94.69   \n",
       "4318                      -0.25         94.50   \n",
       "\n",
       "      Atmospheric pressure (hPa; not normalized to sea level)  \\\n",
       "0                                               1007.02         \n",
       "1                                               1007.08         \n",
       "2                                               1007.04         \n",
       "3                                               1007.08         \n",
       "4                                               1007.00         \n",
       "...                                                 ...         \n",
       "4314                                            1006.45         \n",
       "4315                                            1006.45         \n",
       "4316                                            1006.45         \n",
       "4317                                            1006.45         \n",
       "4318                                            1006.45         \n",
       "\n",
       "      Precipitation (mm)  Average wind speed (km/h; 10min window)  \\\n",
       "0                  0.000                                     6.12   \n",
       "1                  0.000                                     5.93   \n",
       "2                  0.000                                     6.05   \n",
       "3                  0.000                                     4.18   \n",
       "4                  0.000                                     5.41   \n",
       "...                  ...                                      ...   \n",
       "4314               0.045                                     6.25   \n",
       "4315               0.075                                     5.30   \n",
       "4316               0.075                                     6.14   \n",
       "4317               0.030                                     5.19   \n",
       "4318               0.025                                     8.81   \n",
       "\n",
       "      Wind direction (Degree)  Dew point (Degree Celcius)  \\\n",
       "0                         224                       12.45   \n",
       "1                         223                       12.38   \n",
       "2                         227                       12.34   \n",
       "3                         242                       12.29   \n",
       "4                         230                       12.32   \n",
       "...                       ...                         ...   \n",
       "4314                      243                       11.46   \n",
       "4315                      238                       11.36   \n",
       "4316                      236                       11.39   \n",
       "4317                      237                       11.37   \n",
       "4318                      227                       11.34   \n",
       "\n",
       "      Apparent temperature (Degree Celcius)  \\\n",
       "0                                     15.92   \n",
       "1                                     15.88   \n",
       "2                                     15.91   \n",
       "3                                     15.90   \n",
       "4                                     15.89   \n",
       "...                                     ...   \n",
       "4314                                  12.35   \n",
       "4315                                  12.24   \n",
       "4316                                  12.24   \n",
       "4317                                  12.20   \n",
       "4318                                  12.19   \n",
       "\n",
       "      Maximum wind speed (km/h; 10min window)  \n",
       "0                                       10.22  \n",
       "1                                        7.96  \n",
       "2                                        9.54  \n",
       "3                                        9.61  \n",
       "4                                        7.50  \n",
       "...                                       ...  \n",
       "4314                                     8.38  \n",
       "4315                                     9.11  \n",
       "4316                                     8.03  \n",
       "4317                                     8.70  \n",
       "4318                                    11.68  \n",
       "\n",
       "[4319 rows x 12 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>_id</th>\n",
       "      <th>Date and time (YYYY-MM-DD HH:MM:SS)</th>\n",
       "      <th>Temperature (Degree Celcius)</th>\n",
       "      <th>Global irradiance (W/m^2)</th>\n",
       "      <th>Humidity (%)</th>\n",
       "      <th>Atmospheric pressure (hPa; not normalized to sea level)</th>\n",
       "      <th>Precipitation (mm)</th>\n",
       "      <th>Average wind speed (km/h; 10min window)</th>\n",
       "      <th>Wind direction (Degree)</th>\n",
       "      <th>Dew point (Degree Celcius)</th>\n",
       "      <th>Apparent temperature (Degree Celcius)</th>\n",
       "      <th>Maximum wind speed (km/h; 10min window)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2017-08-01T00:02:00</td>\n",
       "      <td>20.88</td>\n",
       "      <td>0.00</td>\n",
       "      <td>91.63</td>\n",
       "      <td>998.08</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.14</td>\n",
       "      <td>2</td>\n",
       "      <td>19.47</td>\n",
       "      <td>27.87</td>\n",
       "      <td>8.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2017-08-01T00:12:00</td>\n",
       "      <td>20.99</td>\n",
       "      <td>0.01</td>\n",
       "      <td>91.26</td>\n",
       "      <td>997.98</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.05</td>\n",
       "      <td>16</td>\n",
       "      <td>19.51</td>\n",
       "      <td>28.02</td>\n",
       "      <td>8.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>2017-08-01T00:22:00</td>\n",
       "      <td>20.94</td>\n",
       "      <td>0.01</td>\n",
       "      <td>91.08</td>\n",
       "      <td>997.90</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.41</td>\n",
       "      <td>31</td>\n",
       "      <td>19.43</td>\n",
       "      <td>27.90</td>\n",
       "      <td>10.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>2017-08-01T00:32:00</td>\n",
       "      <td>21.00</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>90.74</td>\n",
       "      <td>997.75</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.24</td>\n",
       "      <td>33</td>\n",
       "      <td>19.43</td>\n",
       "      <td>27.96</td>\n",
       "      <td>8.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>2017-08-01T00:42:00</td>\n",
       "      <td>20.98</td>\n",
       "      <td>-0.01</td>\n",
       "      <td>90.72</td>\n",
       "      <td>997.78</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.16</td>\n",
       "      <td>13</td>\n",
       "      <td>19.40</td>\n",
       "      <td>27.92</td>\n",
       "      <td>7.62</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4410</th>\n",
       "      <td>4411</td>\n",
       "      <td>2017-08-31T23:13:00</td>\n",
       "      <td>16.20</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>76.63</td>\n",
       "      <td>1006.98</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.57</td>\n",
       "      <td>218</td>\n",
       "      <td>12.10</td>\n",
       "      <td>16.20</td>\n",
       "      <td>8.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4411</th>\n",
       "      <td>4412</td>\n",
       "      <td>2017-08-31T23:23:00</td>\n",
       "      <td>16.24</td>\n",
       "      <td>-0.05</td>\n",
       "      <td>78.11</td>\n",
       "      <td>1007.19</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.67</td>\n",
       "      <td>213</td>\n",
       "      <td>12.43</td>\n",
       "      <td>16.24</td>\n",
       "      <td>6.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4412</th>\n",
       "      <td>4413</td>\n",
       "      <td>2017-08-31T23:33:00</td>\n",
       "      <td>16.15</td>\n",
       "      <td>-0.13</td>\n",
       "      <td>78.91</td>\n",
       "      <td>1007.10</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.60</td>\n",
       "      <td>212</td>\n",
       "      <td>12.50</td>\n",
       "      <td>16.15</td>\n",
       "      <td>9.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4413</th>\n",
       "      <td>4414</td>\n",
       "      <td>2017-08-31T23:43:00</td>\n",
       "      <td>15.99</td>\n",
       "      <td>-0.05</td>\n",
       "      <td>79.42</td>\n",
       "      <td>1007.10</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.56</td>\n",
       "      <td>212</td>\n",
       "      <td>12.44</td>\n",
       "      <td>15.99</td>\n",
       "      <td>8.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4414</th>\n",
       "      <td>4415</td>\n",
       "      <td>2017-08-31T23:53:00</td>\n",
       "      <td>15.99</td>\n",
       "      <td>-0.08</td>\n",
       "      <td>79.60</td>\n",
       "      <td>1007.08</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.93</td>\n",
       "      <td>221</td>\n",
       "      <td>12.47</td>\n",
       "      <td>15.99</td>\n",
       "      <td>9.60</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4415 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       _id Date and time (YYYY-MM-DD HH:MM:SS)  Temperature (Degree Celcius)  \\\n",
       "0        1                 2017-08-01T00:02:00                         20.88   \n",
       "1        2                 2017-08-01T00:12:00                         20.99   \n",
       "2        3                 2017-08-01T00:22:00                         20.94   \n",
       "3        4                 2017-08-01T00:32:00                         21.00   \n",
       "4        5                 2017-08-01T00:42:00                         20.98   \n",
       "...    ...                                 ...                           ...   \n",
       "4410  4411                 2017-08-31T23:13:00                         16.20   \n",
       "4411  4412                 2017-08-31T23:23:00                         16.24   \n",
       "4412  4413                 2017-08-31T23:33:00                         16.15   \n",
       "4413  4414                 2017-08-31T23:43:00                         15.99   \n",
       "4414  4415                 2017-08-31T23:53:00                         15.99   \n",
       "\n",
       "      Global irradiance (W/m^2)  Humidity (%)  \\\n",
       "0                          0.00         91.63   \n",
       "1                          0.01         91.26   \n",
       "2                          0.01         91.08   \n",
       "3                         -0.04         90.74   \n",
       "4                         -0.01         90.72   \n",
       "...                         ...           ...   \n",
       "4410                      -0.04         76.63   \n",
       "4411                      -0.05         78.11   \n",
       "4412                      -0.13         78.91   \n",
       "4413                      -0.05         79.42   \n",
       "4414                      -0.08         79.60   \n",
       "\n",
       "      Atmospheric pressure (hPa; not normalized to sea level)  \\\n",
       "0                                                998.08         \n",
       "1                                                997.98         \n",
       "2                                                997.90         \n",
       "3                                                997.75         \n",
       "4                                                997.78         \n",
       "...                                                 ...         \n",
       "4410                                            1006.98         \n",
       "4411                                            1007.19         \n",
       "4412                                            1007.10         \n",
       "4413                                            1007.10         \n",
       "4414                                            1007.08         \n",
       "\n",
       "      Precipitation (mm)  Average wind speed (km/h; 10min window)  \\\n",
       "0                    0.0                                     8.14   \n",
       "1                    0.0                                     7.05   \n",
       "2                    0.0                                     8.41   \n",
       "3                    0.0                                     7.24   \n",
       "4                    0.0                                     5.16   \n",
       "...                  ...                                      ...   \n",
       "4410                 0.0                                     5.57   \n",
       "4411                 0.0                                     4.67   \n",
       "4412                 0.0                                     5.60   \n",
       "4413                 0.0                                     5.56   \n",
       "4414                 0.0                                     6.93   \n",
       "\n",
       "      Wind direction (Degree)  Dew point (Degree Celcius)  \\\n",
       "0                           2                       19.47   \n",
       "1                          16                       19.51   \n",
       "2                          31                       19.43   \n",
       "3                          33                       19.43   \n",
       "4                          13                       19.40   \n",
       "...                       ...                         ...   \n",
       "4410                      218                       12.10   \n",
       "4411                      213                       12.43   \n",
       "4412                      212                       12.50   \n",
       "4413                      212                       12.44   \n",
       "4414                      221                       12.47   \n",
       "\n",
       "      Apparent temperature (Degree Celcius)  \\\n",
       "0                                     27.87   \n",
       "1                                     28.02   \n",
       "2                                     27.90   \n",
       "3                                     27.96   \n",
       "4                                     27.92   \n",
       "...                                     ...   \n",
       "4410                                  16.20   \n",
       "4411                                  16.24   \n",
       "4412                                  16.15   \n",
       "4413                                  15.99   \n",
       "4414                                  15.99   \n",
       "\n",
       "      Maximum wind speed (km/h; 10min window)  \n",
       "0                                        8.86  \n",
       "1                                        8.16  \n",
       "2                                       10.75  \n",
       "3                                        8.75  \n",
       "4                                        7.62  \n",
       "...                                       ...  \n",
       "4410                                     8.43  \n",
       "4411                                     6.33  \n",
       "4412                                     9.37  \n",
       "4413                                     8.18  \n",
       "4414                                     9.60  \n",
       "\n",
       "[4415 rows x 12 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>_id</th>\n",
       "      <th>Date and time (YYYY-MM-DD HH:MM:SS)</th>\n",
       "      <th>Temperature (Degree Celcius)</th>\n",
       "      <th>Global irradiance (W/m^2)</th>\n",
       "      <th>Humidity (%)</th>\n",
       "      <th>Atmospheric pressure (hPa; not normalized to sea level)</th>\n",
       "      <th>Precipitation (mm)</th>\n",
       "      <th>Average wind speed (km/h; 10min window)</th>\n",
       "      <th>Wind direction (Degree)</th>\n",
       "      <th>Dew point (Degree Celcius)</th>\n",
       "      <th>Apparent temperature (Degree Celcius)</th>\n",
       "      <th>Maximum wind speed (km/h; 10min window)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2017-07-01T00:13:00</td>\n",
       "      <td>17.88</td>\n",
       "      <td>-0.03</td>\n",
       "      <td>58.37</td>\n",
       "      <td>994.80</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.43</td>\n",
       "      <td>251</td>\n",
       "      <td>9.60</td>\n",
       "      <td>17.88</td>\n",
       "      <td>13.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2017-07-01T00:23:00</td>\n",
       "      <td>17.76</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>59.40</td>\n",
       "      <td>994.86</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.24</td>\n",
       "      <td>251</td>\n",
       "      <td>9.76</td>\n",
       "      <td>17.76</td>\n",
       "      <td>13.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>2017-07-01T00:33:00</td>\n",
       "      <td>17.64</td>\n",
       "      <td>-0.05</td>\n",
       "      <td>60.24</td>\n",
       "      <td>994.80</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.20</td>\n",
       "      <td>241</td>\n",
       "      <td>9.85</td>\n",
       "      <td>17.64</td>\n",
       "      <td>14.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>2017-07-01T00:43:00</td>\n",
       "      <td>17.71</td>\n",
       "      <td>0.06</td>\n",
       "      <td>60.70</td>\n",
       "      <td>994.87</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.90</td>\n",
       "      <td>238</td>\n",
       "      <td>10.03</td>\n",
       "      <td>17.71</td>\n",
       "      <td>9.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>2017-07-01T00:53:00</td>\n",
       "      <td>17.52</td>\n",
       "      <td>0.02</td>\n",
       "      <td>61.49</td>\n",
       "      <td>994.91</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.76</td>\n",
       "      <td>226</td>\n",
       "      <td>10.04</td>\n",
       "      <td>17.52</td>\n",
       "      <td>13.37</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4453</th>\n",
       "      <td>4454</td>\n",
       "      <td>2017-07-31T23:12:00</td>\n",
       "      <td>21.38</td>\n",
       "      <td>0.06</td>\n",
       "      <td>90.10</td>\n",
       "      <td>998.28</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.37</td>\n",
       "      <td>333</td>\n",
       "      <td>19.69</td>\n",
       "      <td>28.54</td>\n",
       "      <td>7.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4454</th>\n",
       "      <td>4455</td>\n",
       "      <td>2017-07-31T23:22:00</td>\n",
       "      <td>21.18</td>\n",
       "      <td>0.04</td>\n",
       "      <td>91.08</td>\n",
       "      <td>998.22</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.28</td>\n",
       "      <td>9</td>\n",
       "      <td>19.67</td>\n",
       "      <td>28.33</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4455</th>\n",
       "      <td>4456</td>\n",
       "      <td>2017-07-31T23:32:00</td>\n",
       "      <td>21.06</td>\n",
       "      <td>0.01</td>\n",
       "      <td>91.58</td>\n",
       "      <td>998.18</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.25</td>\n",
       "      <td>6</td>\n",
       "      <td>19.63</td>\n",
       "      <td>28.18</td>\n",
       "      <td>13.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4456</th>\n",
       "      <td>4457</td>\n",
       "      <td>2017-07-31T23:42:00</td>\n",
       "      <td>20.97</td>\n",
       "      <td>0.05</td>\n",
       "      <td>91.38</td>\n",
       "      <td>998.20</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.32</td>\n",
       "      <td>354</td>\n",
       "      <td>19.52</td>\n",
       "      <td>28.00</td>\n",
       "      <td>10.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4457</th>\n",
       "      <td>4458</td>\n",
       "      <td>2017-07-31T23:52:00</td>\n",
       "      <td>20.81</td>\n",
       "      <td>-0.01</td>\n",
       "      <td>91.83</td>\n",
       "      <td>998.05</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.74</td>\n",
       "      <td>355</td>\n",
       "      <td>19.43</td>\n",
       "      <td>27.77</td>\n",
       "      <td>9.78</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4458 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       _id Date and time (YYYY-MM-DD HH:MM:SS)  Temperature (Degree Celcius)  \\\n",
       "0        1                 2017-07-01T00:13:00                         17.88   \n",
       "1        2                 2017-07-01T00:23:00                         17.76   \n",
       "2        3                 2017-07-01T00:33:00                         17.64   \n",
       "3        4                 2017-07-01T00:43:00                         17.71   \n",
       "4        5                 2017-07-01T00:53:00                         17.52   \n",
       "...    ...                                 ...                           ...   \n",
       "4453  4454                 2017-07-31T23:12:00                         21.38   \n",
       "4454  4455                 2017-07-31T23:22:00                         21.18   \n",
       "4455  4456                 2017-07-31T23:32:00                         21.06   \n",
       "4456  4457                 2017-07-31T23:42:00                         20.97   \n",
       "4457  4458                 2017-07-31T23:52:00                         20.81   \n",
       "\n",
       "      Global irradiance (W/m^2)  Humidity (%)  \\\n",
       "0                         -0.03         58.37   \n",
       "1                         -0.04         59.40   \n",
       "2                         -0.05         60.24   \n",
       "3                          0.06         60.70   \n",
       "4                          0.02         61.49   \n",
       "...                         ...           ...   \n",
       "4453                       0.06         90.10   \n",
       "4454                       0.04         91.08   \n",
       "4455                       0.01         91.58   \n",
       "4456                       0.05         91.38   \n",
       "4457                      -0.01         91.83   \n",
       "\n",
       "      Atmospheric pressure (hPa; not normalized to sea level)  \\\n",
       "0                                                994.80         \n",
       "1                                                994.86         \n",
       "2                                                994.80         \n",
       "3                                                994.87         \n",
       "4                                                994.91         \n",
       "...                                                 ...         \n",
       "4453                                             998.28         \n",
       "4454                                             998.22         \n",
       "4455                                             998.18         \n",
       "4456                                             998.20         \n",
       "4457                                             998.05         \n",
       "\n",
       "      Precipitation (mm)  Average wind speed (km/h; 10min window)  \\\n",
       "0                    0.0                                     9.43   \n",
       "1                    0.0                                     9.24   \n",
       "2                    0.0                                     8.20   \n",
       "3                    0.0                                     5.90   \n",
       "4                    0.0                                     8.76   \n",
       "...                  ...                                      ...   \n",
       "4453                 0.0                                     5.37   \n",
       "4454                 0.0                                     8.28   \n",
       "4455                 0.0                                     8.25   \n",
       "4456                 0.0                                     8.32   \n",
       "4457                 0.0                                     7.74   \n",
       "\n",
       "      Wind direction (Degree)  Dew point (Degree Celcius)  \\\n",
       "0                         251                        9.60   \n",
       "1                         251                        9.76   \n",
       "2                         241                        9.85   \n",
       "3                         238                       10.03   \n",
       "4                         226                       10.04   \n",
       "...                       ...                         ...   \n",
       "4453                      333                       19.69   \n",
       "4454                        9                       19.67   \n",
       "4455                        6                       19.63   \n",
       "4456                      354                       19.52   \n",
       "4457                      355                       19.43   \n",
       "\n",
       "      Apparent temperature (Degree Celcius)  \\\n",
       "0                                     17.88   \n",
       "1                                     17.76   \n",
       "2                                     17.64   \n",
       "3                                     17.71   \n",
       "4                                     17.52   \n",
       "...                                     ...   \n",
       "4453                                  28.54   \n",
       "4454                                  28.33   \n",
       "4455                                  28.18   \n",
       "4456                                  28.00   \n",
       "4457                                  27.77   \n",
       "\n",
       "      Maximum wind speed (km/h; 10min window)  \n",
       "0                                       13.48  \n",
       "1                                       13.85  \n",
       "2                                       14.27  \n",
       "3                                        9.60  \n",
       "4                                       13.37  \n",
       "...                                       ...  \n",
       "4453                                     7.11  \n",
       "4454                                    10.00  \n",
       "4455                                    13.01  \n",
       "4456                                    10.33  \n",
       "4457                                     9.78  \n",
       "\n",
       "[4458 rows x 12 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>_id</th>\n",
       "      <th>Date and time (YYYY-MM-DD HH:MM:SS)</th>\n",
       "      <th>Temperature (Degree Celcius)</th>\n",
       "      <th>Global irradiance (W/m^2)</th>\n",
       "      <th>Humidity (%)</th>\n",
       "      <th>Atmospheric pressure (hPa; not normalized to sea level)</th>\n",
       "      <th>Precipitation (mm)</th>\n",
       "      <th>Average wind speed (km/h; 10min window)</th>\n",
       "      <th>Wind direction (Degree)</th>\n",
       "      <th>Dew point (Degree Celcius)</th>\n",
       "      <th>Apparent temperature (Degree Celcius)</th>\n",
       "      <th>Maximum wind speed (km/h; 10min window)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2017-06-01T00:03:00</td>\n",
       "      <td>20.56</td>\n",
       "      <td>0.00</td>\n",
       "      <td>53.00</td>\n",
       "      <td>1005.98</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.33</td>\n",
       "      <td>100</td>\n",
       "      <td>10.66</td>\n",
       "      <td>22.12</td>\n",
       "      <td>6.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2017-06-01T00:13:00</td>\n",
       "      <td>20.36</td>\n",
       "      <td>-0.06</td>\n",
       "      <td>54.12</td>\n",
       "      <td>1006.08</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.73</td>\n",
       "      <td>103</td>\n",
       "      <td>10.79</td>\n",
       "      <td>21.99</td>\n",
       "      <td>5.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>2017-06-01T00:23:00</td>\n",
       "      <td>20.24</td>\n",
       "      <td>-0.13</td>\n",
       "      <td>54.75</td>\n",
       "      <td>1006.10</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.30</td>\n",
       "      <td>87</td>\n",
       "      <td>10.85</td>\n",
       "      <td>21.89</td>\n",
       "      <td>4.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>2017-06-01T00:33:00</td>\n",
       "      <td>20.20</td>\n",
       "      <td>-0.22</td>\n",
       "      <td>55.52</td>\n",
       "      <td>1006.06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.43</td>\n",
       "      <td>60</td>\n",
       "      <td>11.02</td>\n",
       "      <td>21.94</td>\n",
       "      <td>4.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>2017-06-01T00:43:00</td>\n",
       "      <td>20.10</td>\n",
       "      <td>-0.24</td>\n",
       "      <td>56.78</td>\n",
       "      <td>1006.12</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.56</td>\n",
       "      <td>29</td>\n",
       "      <td>11.27</td>\n",
       "      <td>21.95</td>\n",
       "      <td>3.47</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4311</th>\n",
       "      <td>4312</td>\n",
       "      <td>2017-06-30T23:23:00</td>\n",
       "      <td>18.07</td>\n",
       "      <td>-0.03</td>\n",
       "      <td>56.21</td>\n",
       "      <td>994.79</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.66</td>\n",
       "      <td>229</td>\n",
       "      <td>9.22</td>\n",
       "      <td>18.07</td>\n",
       "      <td>13.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4312</th>\n",
       "      <td>4313</td>\n",
       "      <td>2017-06-30T23:28:00</td>\n",
       "      <td>18.03</td>\n",
       "      <td>-0.02</td>\n",
       "      <td>56.26</td>\n",
       "      <td>994.71</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.74</td>\n",
       "      <td>233</td>\n",
       "      <td>9.20</td>\n",
       "      <td>18.03</td>\n",
       "      <td>13.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4313</th>\n",
       "      <td>4314</td>\n",
       "      <td>2017-06-30T23:43:00</td>\n",
       "      <td>17.98</td>\n",
       "      <td>0.00</td>\n",
       "      <td>56.92</td>\n",
       "      <td>994.78</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.13</td>\n",
       "      <td>236</td>\n",
       "      <td>9.33</td>\n",
       "      <td>17.98</td>\n",
       "      <td>10.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4314</th>\n",
       "      <td>4315</td>\n",
       "      <td>2017-06-30T23:53:00</td>\n",
       "      <td>17.92</td>\n",
       "      <td>0.04</td>\n",
       "      <td>57.10</td>\n",
       "      <td>994.80</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.26</td>\n",
       "      <td>240</td>\n",
       "      <td>9.31</td>\n",
       "      <td>17.92</td>\n",
       "      <td>12.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4315</th>\n",
       "      <td>4316</td>\n",
       "      <td>2017-06-30T23:58:00</td>\n",
       "      <td>17.86</td>\n",
       "      <td>0.01</td>\n",
       "      <td>57.57</td>\n",
       "      <td>994.78</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.97</td>\n",
       "      <td>241</td>\n",
       "      <td>9.38</td>\n",
       "      <td>17.86</td>\n",
       "      <td>13.01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4316 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       _id Date and time (YYYY-MM-DD HH:MM:SS)  Temperature (Degree Celcius)  \\\n",
       "0        1                 2017-06-01T00:03:00                         20.56   \n",
       "1        2                 2017-06-01T00:13:00                         20.36   \n",
       "2        3                 2017-06-01T00:23:00                         20.24   \n",
       "3        4                 2017-06-01T00:33:00                         20.20   \n",
       "4        5                 2017-06-01T00:43:00                         20.10   \n",
       "...    ...                                 ...                           ...   \n",
       "4311  4312                 2017-06-30T23:23:00                         18.07   \n",
       "4312  4313                 2017-06-30T23:28:00                         18.03   \n",
       "4313  4314                 2017-06-30T23:43:00                         17.98   \n",
       "4314  4315                 2017-06-30T23:53:00                         17.92   \n",
       "4315  4316                 2017-06-30T23:58:00                         17.86   \n",
       "\n",
       "      Global irradiance (W/m^2)  Humidity (%)  \\\n",
       "0                          0.00         53.00   \n",
       "1                         -0.06         54.12   \n",
       "2                         -0.13         54.75   \n",
       "3                         -0.22         55.52   \n",
       "4                         -0.24         56.78   \n",
       "...                         ...           ...   \n",
       "4311                      -0.03         56.21   \n",
       "4312                      -0.02         56.26   \n",
       "4313                       0.00         56.92   \n",
       "4314                       0.04         57.10   \n",
       "4315                       0.01         57.57   \n",
       "\n",
       "      Atmospheric pressure (hPa; not normalized to sea level)  \\\n",
       "0                                               1005.98         \n",
       "1                                               1006.08         \n",
       "2                                               1006.10         \n",
       "3                                               1006.06         \n",
       "4                                               1006.12         \n",
       "...                                                 ...         \n",
       "4311                                             994.79         \n",
       "4312                                             994.71         \n",
       "4313                                             994.78         \n",
       "4314                                             994.80         \n",
       "4315                                             994.78         \n",
       "\n",
       "      Precipitation (mm)  Average wind speed (km/h; 10min window)  \\\n",
       "0                    0.0                                     4.33   \n",
       "1                    0.0                                     3.73   \n",
       "2                    0.0                                     3.30   \n",
       "3                    0.0                                     2.43   \n",
       "4                    0.0                                     2.56   \n",
       "...                  ...                                      ...   \n",
       "4311                 0.0                                    10.66   \n",
       "4312                 0.0                                     9.74   \n",
       "4313                 0.0                                     8.13   \n",
       "4314                 0.0                                     8.26   \n",
       "4315                 0.0                                     9.97   \n",
       "\n",
       "      Wind direction (Degree)  Dew point (Degree Celcius)  \\\n",
       "0                         100                       10.66   \n",
       "1                         103                       10.79   \n",
       "2                          87                       10.85   \n",
       "3                          60                       11.02   \n",
       "4                          29                       11.27   \n",
       "...                       ...                         ...   \n",
       "4311                      229                        9.22   \n",
       "4312                      233                        9.20   \n",
       "4313                      236                        9.33   \n",
       "4314                      240                        9.31   \n",
       "4315                      241                        9.38   \n",
       "\n",
       "      Apparent temperature (Degree Celcius)  \\\n",
       "0                                     22.12   \n",
       "1                                     21.99   \n",
       "2                                     21.89   \n",
       "3                                     21.94   \n",
       "4                                     21.95   \n",
       "...                                     ...   \n",
       "4311                                  18.07   \n",
       "4312                                  18.03   \n",
       "4313                                  17.98   \n",
       "4314                                  17.92   \n",
       "4315                                  17.86   \n",
       "\n",
       "      Maximum wind speed (km/h; 10min window)  \n",
       "0                                        6.76  \n",
       "1                                        5.29  \n",
       "2                                        4.60  \n",
       "3                                        4.03  \n",
       "4                                        3.47  \n",
       "...                                       ...  \n",
       "4311                                    13.63  \n",
       "4312                                    13.63  \n",
       "4313                                    10.76  \n",
       "4314                                    12.42  \n",
       "4315                                    13.01  \n",
       "\n",
       "[4316 rows x 12 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>_id</th>\n",
       "      <th>Date and time (YYYY-MM-DD HH:MM:SS)</th>\n",
       "      <th>Temperature (Degree Celcius)</th>\n",
       "      <th>Global irradiance (W/m^2)</th>\n",
       "      <th>Humidity (%)</th>\n",
       "      <th>Atmospheric pressure (hPa; not normalized to sea level)</th>\n",
       "      <th>Precipitation (mm)</th>\n",
       "      <th>Average wind speed (km/h; 10min window)</th>\n",
       "      <th>Wind direction (Degree)</th>\n",
       "      <th>Dew point (Degree Celcius)</th>\n",
       "      <th>Apparent temperature (Degree Celcius)</th>\n",
       "      <th>Maximum wind speed (km/h; 10min window)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2017-05-01T00:05:00</td>\n",
       "      <td>14.28</td>\n",
       "      <td>-0.19</td>\n",
       "      <td>40.25</td>\n",
       "      <td>990.84</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.60</td>\n",
       "      <td>89</td>\n",
       "      <td>0.96</td>\n",
       "      <td>14.28</td>\n",
       "      <td>9.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2017-05-01T00:15:00</td>\n",
       "      <td>14.22</td>\n",
       "      <td>-0.24</td>\n",
       "      <td>40.48</td>\n",
       "      <td>990.80</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.19</td>\n",
       "      <td>89</td>\n",
       "      <td>0.98</td>\n",
       "      <td>14.22</td>\n",
       "      <td>7.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>2017-05-01T00:25:00</td>\n",
       "      <td>14.04</td>\n",
       "      <td>-0.23</td>\n",
       "      <td>40.70</td>\n",
       "      <td>990.62</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.03</td>\n",
       "      <td>83</td>\n",
       "      <td>0.90</td>\n",
       "      <td>14.04</td>\n",
       "      <td>8.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>2017-05-01T00:35:00</td>\n",
       "      <td>13.96</td>\n",
       "      <td>-0.23</td>\n",
       "      <td>40.87</td>\n",
       "      <td>990.51</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.98</td>\n",
       "      <td>91</td>\n",
       "      <td>0.88</td>\n",
       "      <td>13.96</td>\n",
       "      <td>11.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>2017-05-01T00:45:00</td>\n",
       "      <td>13.92</td>\n",
       "      <td>-0.28</td>\n",
       "      <td>40.96</td>\n",
       "      <td>990.47</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.10</td>\n",
       "      <td>88</td>\n",
       "      <td>0.88</td>\n",
       "      <td>13.92</td>\n",
       "      <td>9.10</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4391</th>\n",
       "      <td>4392</td>\n",
       "      <td>2017-05-31T23:13:00</td>\n",
       "      <td>21.02</td>\n",
       "      <td>-0.05</td>\n",
       "      <td>50.77</td>\n",
       "      <td>1006.09</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.59</td>\n",
       "      <td>72</td>\n",
       "      <td>10.43</td>\n",
       "      <td>22.47</td>\n",
       "      <td>5.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4392</th>\n",
       "      <td>4393</td>\n",
       "      <td>2017-05-31T23:23:00</td>\n",
       "      <td>20.98</td>\n",
       "      <td>-0.08</td>\n",
       "      <td>51.42</td>\n",
       "      <td>1006.07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.36</td>\n",
       "      <td>94</td>\n",
       "      <td>10.60</td>\n",
       "      <td>22.52</td>\n",
       "      <td>4.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4393</th>\n",
       "      <td>4394</td>\n",
       "      <td>2017-05-31T23:33:00</td>\n",
       "      <td>20.85</td>\n",
       "      <td>-0.18</td>\n",
       "      <td>51.79</td>\n",
       "      <td>1006.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.67</td>\n",
       "      <td>76</td>\n",
       "      <td>10.58</td>\n",
       "      <td>22.37</td>\n",
       "      <td>5.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4394</th>\n",
       "      <td>4395</td>\n",
       "      <td>2017-05-31T23:43:00</td>\n",
       "      <td>20.89</td>\n",
       "      <td>-0.14</td>\n",
       "      <td>51.88</td>\n",
       "      <td>1005.95</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.30</td>\n",
       "      <td>57</td>\n",
       "      <td>10.64</td>\n",
       "      <td>22.44</td>\n",
       "      <td>5.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4395</th>\n",
       "      <td>4396</td>\n",
       "      <td>2017-05-31T23:53:00</td>\n",
       "      <td>20.79</td>\n",
       "      <td>-0.12</td>\n",
       "      <td>52.41</td>\n",
       "      <td>1005.96</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.01</td>\n",
       "      <td>69</td>\n",
       "      <td>10.70</td>\n",
       "      <td>22.37</td>\n",
       "      <td>5.94</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4396 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       _id Date and time (YYYY-MM-DD HH:MM:SS)  Temperature (Degree Celcius)  \\\n",
       "0        1                 2017-05-01T00:05:00                         14.28   \n",
       "1        2                 2017-05-01T00:15:00                         14.22   \n",
       "2        3                 2017-05-01T00:25:00                         14.04   \n",
       "3        4                 2017-05-01T00:35:00                         13.96   \n",
       "4        5                 2017-05-01T00:45:00                         13.92   \n",
       "...    ...                                 ...                           ...   \n",
       "4391  4392                 2017-05-31T23:13:00                         21.02   \n",
       "4392  4393                 2017-05-31T23:23:00                         20.98   \n",
       "4393  4394                 2017-05-31T23:33:00                         20.85   \n",
       "4394  4395                 2017-05-31T23:43:00                         20.89   \n",
       "4395  4396                 2017-05-31T23:53:00                         20.79   \n",
       "\n",
       "      Global irradiance (W/m^2)  Humidity (%)  \\\n",
       "0                         -0.19         40.25   \n",
       "1                         -0.24         40.48   \n",
       "2                         -0.23         40.70   \n",
       "3                         -0.23         40.87   \n",
       "4                         -0.28         40.96   \n",
       "...                         ...           ...   \n",
       "4391                      -0.05         50.77   \n",
       "4392                      -0.08         51.42   \n",
       "4393                      -0.18         51.79   \n",
       "4394                      -0.14         51.88   \n",
       "4395                      -0.12         52.41   \n",
       "\n",
       "      Atmospheric pressure (hPa; not normalized to sea level)  \\\n",
       "0                                                990.84         \n",
       "1                                                990.80         \n",
       "2                                                990.62         \n",
       "3                                                990.51         \n",
       "4                                                990.47         \n",
       "...                                                 ...         \n",
       "4391                                            1006.09         \n",
       "4392                                            1006.07         \n",
       "4393                                            1006.01         \n",
       "4394                                            1005.95         \n",
       "4395                                            1005.96         \n",
       "\n",
       "      Precipitation (mm)  Average wind speed (km/h; 10min window)  \\\n",
       "0                    0.0                                     6.60   \n",
       "1                    0.0                                     6.19   \n",
       "2                    0.0                                     7.03   \n",
       "3                    0.0                                     8.98   \n",
       "4                    0.0                                     7.10   \n",
       "...                  ...                                      ...   \n",
       "4391                 0.0                                     3.59   \n",
       "4392                 0.0                                     3.36   \n",
       "4393                 0.0                                     3.67   \n",
       "4394                 0.0                                     4.30   \n",
       "4395                 0.0                                     4.01   \n",
       "\n",
       "      Wind direction (Degree)  Dew point (Degree Celcius)  \\\n",
       "0                          89                        0.96   \n",
       "1                          89                        0.98   \n",
       "2                          83                        0.90   \n",
       "3                          91                        0.88   \n",
       "4                          88                        0.88   \n",
       "...                       ...                         ...   \n",
       "4391                       72                       10.43   \n",
       "4392                       94                       10.60   \n",
       "4393                       76                       10.58   \n",
       "4394                       57                       10.64   \n",
       "4395                       69                       10.70   \n",
       "\n",
       "      Apparent temperature (Degree Celcius)  \\\n",
       "0                                     14.28   \n",
       "1                                     14.22   \n",
       "2                                     14.04   \n",
       "3                                     13.96   \n",
       "4                                     13.92   \n",
       "...                                     ...   \n",
       "4391                                  22.47   \n",
       "4392                                  22.52   \n",
       "4393                                  22.37   \n",
       "4394                                  22.44   \n",
       "4395                                  22.37   \n",
       "\n",
       "      Maximum wind speed (km/h; 10min window)  \n",
       "0                                        9.13  \n",
       "1                                        7.97  \n",
       "2                                        8.64  \n",
       "3                                       11.63  \n",
       "4                                        9.10  \n",
       "...                                       ...  \n",
       "4391                                     5.43  \n",
       "4392                                     4.91  \n",
       "4393                                     5.82  \n",
       "4394                                     5.79  \n",
       "4395                                     5.94  \n",
       "\n",
       "[4396 rows x 12 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>_id</th>\n",
       "      <th>Date and time (YYYY-MM-DD HH:MM:SS)</th>\n",
       "      <th>Temperature (Degree Celcius)</th>\n",
       "      <th>Global irradiance (W/m^2)</th>\n",
       "      <th>Humidity (%)</th>\n",
       "      <th>Atmospheric pressure (hPa; not normalized to sea level)</th>\n",
       "      <th>Precipitation (mm)</th>\n",
       "      <th>Average wind speed (km/h; 10min window)</th>\n",
       "      <th>Wind direction (Degree)</th>\n",
       "      <th>Dew point (Degree Celcius)</th>\n",
       "      <th>Apparent temperature (Degree Celcius)</th>\n",
       "      <th>Maximum wind speed (km/h; 10min window)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2017-04-01T00:05:00</td>\n",
       "      <td>15.30</td>\n",
       "      <td>-0.13</td>\n",
       "      <td>38.92</td>\n",
       "      <td>999.04</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.70</td>\n",
       "      <td>125</td>\n",
       "      <td>1.41</td>\n",
       "      <td>15.30</td>\n",
       "      <td>1.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2017-04-01T00:10:00</td>\n",
       "      <td>15.42</td>\n",
       "      <td>0.22</td>\n",
       "      <td>39.21</td>\n",
       "      <td>998.99</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.37</td>\n",
       "      <td>123</td>\n",
       "      <td>1.61</td>\n",
       "      <td>15.42</td>\n",
       "      <td>2.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>2017-04-01T00:25:00</td>\n",
       "      <td>15.21</td>\n",
       "      <td>0.02</td>\n",
       "      <td>39.29</td>\n",
       "      <td>999.02</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.16</td>\n",
       "      <td>97</td>\n",
       "      <td>1.46</td>\n",
       "      <td>15.21</td>\n",
       "      <td>3.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>2017-04-01T00:35:00</td>\n",
       "      <td>15.10</td>\n",
       "      <td>0.02</td>\n",
       "      <td>40.72</td>\n",
       "      <td>999.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.71</td>\n",
       "      <td>103</td>\n",
       "      <td>1.85</td>\n",
       "      <td>15.10</td>\n",
       "      <td>4.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>2017-04-01T00:45:00</td>\n",
       "      <td>14.84</td>\n",
       "      <td>-0.01</td>\n",
       "      <td>41.48</td>\n",
       "      <td>998.94</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.91</td>\n",
       "      <td>150</td>\n",
       "      <td>1.88</td>\n",
       "      <td>14.84</td>\n",
       "      <td>3.81</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4309</th>\n",
       "      <td>4310</td>\n",
       "      <td>2017-04-30T23:15:00</td>\n",
       "      <td>14.97</td>\n",
       "      <td>-0.22</td>\n",
       "      <td>37.72</td>\n",
       "      <td>990.66</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.76</td>\n",
       "      <td>94</td>\n",
       "      <td>0.68</td>\n",
       "      <td>14.97</td>\n",
       "      <td>14.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4310</th>\n",
       "      <td>4311</td>\n",
       "      <td>2017-04-30T23:25:00</td>\n",
       "      <td>14.80</td>\n",
       "      <td>-0.12</td>\n",
       "      <td>38.33</td>\n",
       "      <td>990.57</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.76</td>\n",
       "      <td>97</td>\n",
       "      <td>0.75</td>\n",
       "      <td>14.80</td>\n",
       "      <td>13.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4311</th>\n",
       "      <td>4312</td>\n",
       "      <td>2017-04-30T23:35:00</td>\n",
       "      <td>14.67</td>\n",
       "      <td>-0.21</td>\n",
       "      <td>38.96</td>\n",
       "      <td>990.65</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.25</td>\n",
       "      <td>99</td>\n",
       "      <td>0.86</td>\n",
       "      <td>14.67</td>\n",
       "      <td>14.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4312</th>\n",
       "      <td>4313</td>\n",
       "      <td>2017-04-30T23:45:00</td>\n",
       "      <td>14.43</td>\n",
       "      <td>-0.16</td>\n",
       "      <td>39.53</td>\n",
       "      <td>990.67</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.29</td>\n",
       "      <td>92</td>\n",
       "      <td>0.85</td>\n",
       "      <td>14.43</td>\n",
       "      <td>9.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4313</th>\n",
       "      <td>4314</td>\n",
       "      <td>2017-04-30T23:55:00</td>\n",
       "      <td>14.35</td>\n",
       "      <td>-0.23</td>\n",
       "      <td>40.01</td>\n",
       "      <td>990.72</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.97</td>\n",
       "      <td>86</td>\n",
       "      <td>0.94</td>\n",
       "      <td>14.35</td>\n",
       "      <td>8.45</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4314 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       _id Date and time (YYYY-MM-DD HH:MM:SS)  Temperature (Degree Celcius)  \\\n",
       "0        1                 2017-04-01T00:05:00                         15.30   \n",
       "1        2                 2017-04-01T00:10:00                         15.42   \n",
       "2        3                 2017-04-01T00:25:00                         15.21   \n",
       "3        4                 2017-04-01T00:35:00                         15.10   \n",
       "4        5                 2017-04-01T00:45:00                         14.84   \n",
       "...    ...                                 ...                           ...   \n",
       "4309  4310                 2017-04-30T23:15:00                         14.97   \n",
       "4310  4311                 2017-04-30T23:25:00                         14.80   \n",
       "4311  4312                 2017-04-30T23:35:00                         14.67   \n",
       "4312  4313                 2017-04-30T23:45:00                         14.43   \n",
       "4313  4314                 2017-04-30T23:55:00                         14.35   \n",
       "\n",
       "      Global irradiance (W/m^2)  Humidity (%)  \\\n",
       "0                         -0.13         38.92   \n",
       "1                          0.22         39.21   \n",
       "2                          0.02         39.29   \n",
       "3                          0.02         40.72   \n",
       "4                         -0.01         41.48   \n",
       "...                         ...           ...   \n",
       "4309                      -0.22         37.72   \n",
       "4310                      -0.12         38.33   \n",
       "4311                      -0.21         38.96   \n",
       "4312                      -0.16         39.53   \n",
       "4313                      -0.23         40.01   \n",
       "\n",
       "      Atmospheric pressure (hPa; not normalized to sea level)  \\\n",
       "0                                                999.04         \n",
       "1                                                998.99         \n",
       "2                                                999.02         \n",
       "3                                                999.00         \n",
       "4                                                998.94         \n",
       "...                                                 ...         \n",
       "4309                                             990.66         \n",
       "4310                                             990.57         \n",
       "4311                                             990.65         \n",
       "4312                                             990.67         \n",
       "4313                                             990.72         \n",
       "\n",
       "      Precipitation (mm)  Average wind speed (km/h; 10min window)  \\\n",
       "0                    0.0                                     0.70   \n",
       "1                    0.0                                     1.37   \n",
       "2                    0.0                                     3.16   \n",
       "3                    0.0                                     3.71   \n",
       "4                    0.0                                     1.91   \n",
       "...                  ...                                      ...   \n",
       "4309                 0.0                                     9.76   \n",
       "4310                 0.0                                    11.76   \n",
       "4311                 0.0                                    11.25   \n",
       "4312                 0.0                                     8.29   \n",
       "4313                 0.0                                     6.97   \n",
       "\n",
       "      Wind direction (Degree)  Dew point (Degree Celcius)  \\\n",
       "0                         125                        1.41   \n",
       "1                         123                        1.61   \n",
       "2                          97                        1.46   \n",
       "3                         103                        1.85   \n",
       "4                         150                        1.88   \n",
       "...                       ...                         ...   \n",
       "4309                       94                        0.68   \n",
       "4310                       97                        0.75   \n",
       "4311                       99                        0.86   \n",
       "4312                       92                        0.85   \n",
       "4313                       86                        0.94   \n",
       "\n",
       "      Apparent temperature (Degree Celcius)  \\\n",
       "0                                     15.30   \n",
       "1                                     15.42   \n",
       "2                                     15.21   \n",
       "3                                     15.10   \n",
       "4                                     14.84   \n",
       "...                                     ...   \n",
       "4309                                  14.97   \n",
       "4310                                  14.80   \n",
       "4311                                  14.67   \n",
       "4312                                  14.43   \n",
       "4313                                  14.35   \n",
       "\n",
       "      Maximum wind speed (km/h; 10min window)  \n",
       "0                                        1.91  \n",
       "1                                        2.51  \n",
       "2                                        3.59  \n",
       "3                                        4.19  \n",
       "4                                        3.81  \n",
       "...                                       ...  \n",
       "4309                                    14.54  \n",
       "4310                                    13.77  \n",
       "4311                                    14.35  \n",
       "4312                                     9.62  \n",
       "4313                                     8.45  \n",
       "\n",
       "[4314 rows x 12 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>_id</th>\n",
       "      <th>Date and time (YYYY-MM-DD HH:MM:SS)</th>\n",
       "      <th>Temperature (Degree Celcius)</th>\n",
       "      <th>Global irradiance (W/m^2)</th>\n",
       "      <th>Humidity (%)</th>\n",
       "      <th>Atmospheric pressure (hPa; not normalized to sea level)</th>\n",
       "      <th>Precipitation (mm)</th>\n",
       "      <th>Average wind speed (km/h; 10min window)</th>\n",
       "      <th>Wind direction (Degree)</th>\n",
       "      <th>Dew point (Degree Celcius)</th>\n",
       "      <th>Apparent temperature (Degree Celcius)</th>\n",
       "      <th>Maximum wind speed (km/h; 10min window)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2017-03-01T00:03:00</td>\n",
       "      <td>5.25</td>\n",
       "      <td>-0.46</td>\n",
       "      <td>78.69</td>\n",
       "      <td>988.40</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.55</td>\n",
       "      <td>238</td>\n",
       "      <td>1.85</td>\n",
       "      <td>5.25</td>\n",
       "      <td>20.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2017-03-01T00:13:00</td>\n",
       "      <td>5.21</td>\n",
       "      <td>-0.45</td>\n",
       "      <td>78.74</td>\n",
       "      <td>988.40</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.15</td>\n",
       "      <td>237</td>\n",
       "      <td>1.82</td>\n",
       "      <td>5.21</td>\n",
       "      <td>18.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>2017-03-01T00:23:00</td>\n",
       "      <td>5.25</td>\n",
       "      <td>-0.45</td>\n",
       "      <td>77.25</td>\n",
       "      <td>988.30</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.22</td>\n",
       "      <td>237</td>\n",
       "      <td>1.60</td>\n",
       "      <td>5.25</td>\n",
       "      <td>23.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>2017-03-01T00:33:00</td>\n",
       "      <td>5.36</td>\n",
       "      <td>-0.49</td>\n",
       "      <td>74.60</td>\n",
       "      <td>988.47</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.36</td>\n",
       "      <td>226</td>\n",
       "      <td>1.21</td>\n",
       "      <td>5.36</td>\n",
       "      <td>25.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>2017-03-01T00:43:00</td>\n",
       "      <td>5.31</td>\n",
       "      <td>-0.48</td>\n",
       "      <td>74.42</td>\n",
       "      <td>988.53</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.21</td>\n",
       "      <td>233</td>\n",
       "      <td>1.13</td>\n",
       "      <td>5.31</td>\n",
       "      <td>25.68</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4432</th>\n",
       "      <td>4433</td>\n",
       "      <td>2017-03-31T23:15:00</td>\n",
       "      <td>16.67</td>\n",
       "      <td>0.02</td>\n",
       "      <td>34.10</td>\n",
       "      <td>999.07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.52</td>\n",
       "      <td>109</td>\n",
       "      <td>0.79</td>\n",
       "      <td>16.67</td>\n",
       "      <td>4.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4433</th>\n",
       "      <td>4434</td>\n",
       "      <td>2017-03-31T23:25:00</td>\n",
       "      <td>16.22</td>\n",
       "      <td>0.14</td>\n",
       "      <td>35.51</td>\n",
       "      <td>999.07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.49</td>\n",
       "      <td>102</td>\n",
       "      <td>0.95</td>\n",
       "      <td>16.22</td>\n",
       "      <td>4.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4434</th>\n",
       "      <td>4435</td>\n",
       "      <td>2017-03-31T23:35:00</td>\n",
       "      <td>16.07</td>\n",
       "      <td>0.27</td>\n",
       "      <td>35.85</td>\n",
       "      <td>999.03</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.00</td>\n",
       "      <td>113</td>\n",
       "      <td>0.95</td>\n",
       "      <td>16.07</td>\n",
       "      <td>3.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4435</th>\n",
       "      <td>4436</td>\n",
       "      <td>2017-03-31T23:45:00</td>\n",
       "      <td>15.92</td>\n",
       "      <td>0.05</td>\n",
       "      <td>36.28</td>\n",
       "      <td>999.03</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.18</td>\n",
       "      <td>117</td>\n",
       "      <td>0.98</td>\n",
       "      <td>15.92</td>\n",
       "      <td>4.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4436</th>\n",
       "      <td>4437</td>\n",
       "      <td>2017-03-31T23:55:00</td>\n",
       "      <td>15.51</td>\n",
       "      <td>-0.20</td>\n",
       "      <td>37.46</td>\n",
       "      <td>998.99</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.91</td>\n",
       "      <td>158</td>\n",
       "      <td>1.07</td>\n",
       "      <td>15.51</td>\n",
       "      <td>1.92</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4437 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       _id Date and time (YYYY-MM-DD HH:MM:SS)  Temperature (Degree Celcius)  \\\n",
       "0        1                 2017-03-01T00:03:00                          5.25   \n",
       "1        2                 2017-03-01T00:13:00                          5.21   \n",
       "2        3                 2017-03-01T00:23:00                          5.25   \n",
       "3        4                 2017-03-01T00:33:00                          5.36   \n",
       "4        5                 2017-03-01T00:43:00                          5.31   \n",
       "...    ...                                 ...                           ...   \n",
       "4432  4433                 2017-03-31T23:15:00                         16.67   \n",
       "4433  4434                 2017-03-31T23:25:00                         16.22   \n",
       "4434  4435                 2017-03-31T23:35:00                         16.07   \n",
       "4435  4436                 2017-03-31T23:45:00                         15.92   \n",
       "4436  4437                 2017-03-31T23:55:00                         15.51   \n",
       "\n",
       "      Global irradiance (W/m^2)  Humidity (%)  \\\n",
       "0                         -0.46         78.69   \n",
       "1                         -0.45         78.74   \n",
       "2                         -0.45         77.25   \n",
       "3                         -0.49         74.60   \n",
       "4                         -0.48         74.42   \n",
       "...                         ...           ...   \n",
       "4432                       0.02         34.10   \n",
       "4433                       0.14         35.51   \n",
       "4434                       0.27         35.85   \n",
       "4435                       0.05         36.28   \n",
       "4436                      -0.20         37.46   \n",
       "\n",
       "      Atmospheric pressure (hPa; not normalized to sea level)  \\\n",
       "0                                                988.40         \n",
       "1                                                988.40         \n",
       "2                                                988.30         \n",
       "3                                                988.47         \n",
       "4                                                988.53         \n",
       "...                                                 ...         \n",
       "4432                                             999.07         \n",
       "4433                                             999.07         \n",
       "4434                                             999.03         \n",
       "4435                                             999.03         \n",
       "4436                                             998.99         \n",
       "\n",
       "      Precipitation (mm)  Average wind speed (km/h; 10min window)  \\\n",
       "0                    0.0                                    13.55   \n",
       "1                    0.0                                    15.15   \n",
       "2                    0.0                                    15.22   \n",
       "3                    0.0                                    19.36   \n",
       "4                    0.0                                    17.21   \n",
       "...                  ...                                      ...   \n",
       "4432                 0.0                                     3.52   \n",
       "4433                 0.0                                     3.49   \n",
       "4434                 0.0                                     3.00   \n",
       "4435                 0.0                                     3.18   \n",
       "4436                 0.0                                     0.91   \n",
       "\n",
       "      Wind direction (Degree)  Dew point (Degree Celcius)  \\\n",
       "0                         238                        1.85   \n",
       "1                         237                        1.82   \n",
       "2                         237                        1.60   \n",
       "3                         226                        1.21   \n",
       "4                         233                        1.13   \n",
       "...                       ...                         ...   \n",
       "4432                      109                        0.79   \n",
       "4433                      102                        0.95   \n",
       "4434                      113                        0.95   \n",
       "4435                      117                        0.98   \n",
       "4436                      158                        1.07   \n",
       "\n",
       "      Apparent temperature (Degree Celcius)  \\\n",
       "0                                      5.25   \n",
       "1                                      5.21   \n",
       "2                                      5.25   \n",
       "3                                      5.36   \n",
       "4                                      5.31   \n",
       "...                                     ...   \n",
       "4432                                  16.67   \n",
       "4433                                  16.22   \n",
       "4434                                  16.07   \n",
       "4435                                  15.92   \n",
       "4436                                  15.51   \n",
       "\n",
       "      Maximum wind speed (km/h; 10min window)  \n",
       "0                                       20.25  \n",
       "1                                       18.97  \n",
       "2                                       23.43  \n",
       "3                                       25.71  \n",
       "4                                       25.68  \n",
       "...                                       ...  \n",
       "4432                                     4.55  \n",
       "4433                                     4.28  \n",
       "4434                                     3.77  \n",
       "4435                                     4.02  \n",
       "4436                                     1.92  \n",
       "\n",
       "[4437 rows x 12 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>_id</th>\n",
       "      <th>Date and time (YYYY-MM-DD HH:MM:SS)</th>\n",
       "      <th>Temperature (Degree Celcius)</th>\n",
       "      <th>Global irradiance (W/m^2)</th>\n",
       "      <th>Humidity (%)</th>\n",
       "      <th>Atmospheric pressure (hPa; not normalized to sea level)</th>\n",
       "      <th>Precipitation (mm)</th>\n",
       "      <th>Average wind speed (km/h; 10min window)</th>\n",
       "      <th>Wind direction (Degree)</th>\n",
       "      <th>Dew point (Degree Celcius)</th>\n",
       "      <th>Apparent temperature (Degree Celcius)</th>\n",
       "      <th>Maximum wind speed (km/h; 10min window)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2017-02-01T00:03:00</td>\n",
       "      <td>2.68</td>\n",
       "      <td>-0.60</td>\n",
       "      <td>82.92</td>\n",
       "      <td>1003.90</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.36</td>\n",
       "      <td>45</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1.30</td>\n",
       "      <td>7.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2017-02-01T00:13:00</td>\n",
       "      <td>2.70</td>\n",
       "      <td>-0.58</td>\n",
       "      <td>83.23</td>\n",
       "      <td>1003.90</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.26</td>\n",
       "      <td>41</td>\n",
       "      <td>0.14</td>\n",
       "      <td>2.70</td>\n",
       "      <td>5.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>2017-02-01T00:23:00</td>\n",
       "      <td>2.51</td>\n",
       "      <td>-0.54</td>\n",
       "      <td>83.93</td>\n",
       "      <td>1004.02</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.42</td>\n",
       "      <td>35</td>\n",
       "      <td>0.07</td>\n",
       "      <td>0.38</td>\n",
       "      <td>9.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>2017-02-01T00:33:00</td>\n",
       "      <td>2.40</td>\n",
       "      <td>-0.52</td>\n",
       "      <td>84.80</td>\n",
       "      <td>1003.92</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.99</td>\n",
       "      <td>35</td>\n",
       "      <td>0.11</td>\n",
       "      <td>0.09</td>\n",
       "      <td>10.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>2017-02-01T00:43:00</td>\n",
       "      <td>2.26</td>\n",
       "      <td>-0.51</td>\n",
       "      <td>85.35</td>\n",
       "      <td>1004.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.79</td>\n",
       "      <td>35</td>\n",
       "      <td>0.06</td>\n",
       "      <td>-0.56</td>\n",
       "      <td>11.50</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3940</th>\n",
       "      <td>3941</td>\n",
       "      <td>2017-02-28T23:13:00</td>\n",
       "      <td>5.15</td>\n",
       "      <td>-0.49</td>\n",
       "      <td>80.95</td>\n",
       "      <td>987.90</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.35</td>\n",
       "      <td>237</td>\n",
       "      <td>2.16</td>\n",
       "      <td>5.15</td>\n",
       "      <td>19.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3941</th>\n",
       "      <td>3942</td>\n",
       "      <td>2017-02-28T23:23:00</td>\n",
       "      <td>5.14</td>\n",
       "      <td>-0.45</td>\n",
       "      <td>80.83</td>\n",
       "      <td>987.95</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.12</td>\n",
       "      <td>239</td>\n",
       "      <td>2.12</td>\n",
       "      <td>5.14</td>\n",
       "      <td>23.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3942</th>\n",
       "      <td>3943</td>\n",
       "      <td>2017-02-28T23:33:00</td>\n",
       "      <td>5.13</td>\n",
       "      <td>-0.51</td>\n",
       "      <td>80.94</td>\n",
       "      <td>988.15</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.68</td>\n",
       "      <td>230</td>\n",
       "      <td>2.13</td>\n",
       "      <td>5.13</td>\n",
       "      <td>22.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3943</th>\n",
       "      <td>3944</td>\n",
       "      <td>2017-02-28T23:43:00</td>\n",
       "      <td>5.14</td>\n",
       "      <td>-0.49</td>\n",
       "      <td>79.69</td>\n",
       "      <td>988.12</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.10</td>\n",
       "      <td>233</td>\n",
       "      <td>1.93</td>\n",
       "      <td>5.14</td>\n",
       "      <td>25.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3944</th>\n",
       "      <td>3945</td>\n",
       "      <td>2017-02-28T23:53:00</td>\n",
       "      <td>5.19</td>\n",
       "      <td>-0.45</td>\n",
       "      <td>78.99</td>\n",
       "      <td>988.28</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.71</td>\n",
       "      <td>235</td>\n",
       "      <td>1.85</td>\n",
       "      <td>5.19</td>\n",
       "      <td>20.69</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3945 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       _id Date and time (YYYY-MM-DD HH:MM:SS)  Temperature (Degree Celcius)  \\\n",
       "0        1                 2017-02-01T00:03:00                          2.68   \n",
       "1        2                 2017-02-01T00:13:00                          2.70   \n",
       "2        3                 2017-02-01T00:23:00                          2.51   \n",
       "3        4                 2017-02-01T00:33:00                          2.40   \n",
       "4        5                 2017-02-01T00:43:00                          2.26   \n",
       "...    ...                                 ...                           ...   \n",
       "3940  3941                 2017-02-28T23:13:00                          5.15   \n",
       "3941  3942                 2017-02-28T23:23:00                          5.14   \n",
       "3942  3943                 2017-02-28T23:33:00                          5.13   \n",
       "3943  3944                 2017-02-28T23:43:00                          5.14   \n",
       "3944  3945                 2017-02-28T23:53:00                          5.19   \n",
       "\n",
       "      Global irradiance (W/m^2)  Humidity (%)  \\\n",
       "0                         -0.60         82.92   \n",
       "1                         -0.58         83.23   \n",
       "2                         -0.54         83.93   \n",
       "3                         -0.52         84.80   \n",
       "4                         -0.51         85.35   \n",
       "...                         ...           ...   \n",
       "3940                      -0.49         80.95   \n",
       "3941                      -0.45         80.83   \n",
       "3942                      -0.51         80.94   \n",
       "3943                      -0.49         79.69   \n",
       "3944                      -0.45         78.99   \n",
       "\n",
       "      Atmospheric pressure (hPa; not normalized to sea level)  \\\n",
       "0                                               1003.90         \n",
       "1                                               1003.90         \n",
       "2                                               1004.02         \n",
       "3                                               1003.92         \n",
       "4                                               1004.01         \n",
       "...                                                 ...         \n",
       "3940                                             987.90         \n",
       "3941                                             987.95         \n",
       "3942                                             988.15         \n",
       "3943                                             988.12         \n",
       "3944                                             988.28         \n",
       "\n",
       "      Precipitation (mm)  Average wind speed (km/h; 10min window)  \\\n",
       "0                    0.0                                     5.36   \n",
       "1                    0.0                                     4.26   \n",
       "2                    0.0                                     7.42   \n",
       "3                    0.0                                     7.99   \n",
       "4                    0.0                                     9.79   \n",
       "...                  ...                                      ...   \n",
       "3940                 0.0                                    13.35   \n",
       "3941                 0.0                                    16.12   \n",
       "3942                 0.0                                    16.68   \n",
       "3943                 0.0                                    17.10   \n",
       "3944                 0.0                                    15.71   \n",
       "\n",
       "      Wind direction (Degree)  Dew point (Degree Celcius)  \\\n",
       "0                          45                        0.08   \n",
       "1                          41                        0.14   \n",
       "2                          35                        0.07   \n",
       "3                          35                        0.11   \n",
       "4                          35                        0.06   \n",
       "...                       ...                         ...   \n",
       "3940                      237                        2.16   \n",
       "3941                      239                        2.12   \n",
       "3942                      230                        2.13   \n",
       "3943                      233                        1.93   \n",
       "3944                      235                        1.85   \n",
       "\n",
       "      Apparent temperature (Degree Celcius)  \\\n",
       "0                                      1.30   \n",
       "1                                      2.70   \n",
       "2                                      0.38   \n",
       "3                                      0.09   \n",
       "4                                     -0.56   \n",
       "...                                     ...   \n",
       "3940                                   5.15   \n",
       "3941                                   5.14   \n",
       "3942                                   5.13   \n",
       "3943                                   5.14   \n",
       "3944                                   5.19   \n",
       "\n",
       "      Maximum wind speed (km/h; 10min window)  \n",
       "0                                        7.28  \n",
       "1                                        5.81  \n",
       "2                                        9.84  \n",
       "3                                       10.31  \n",
       "4                                       11.50  \n",
       "...                                       ...  \n",
       "3940                                    19.24  \n",
       "3941                                    23.17  \n",
       "3942                                    22.55  \n",
       "3943                                    25.10  \n",
       "3944                                    20.69  \n",
       "\n",
       "[3945 rows x 12 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>_id</th>\n",
       "      <th>Date and time (YYYY-MM-DD HH:MM:SS)</th>\n",
       "      <th>Temperature (Degree Celcius)</th>\n",
       "      <th>Global irradiance (W/m^2)</th>\n",
       "      <th>Humidity (%)</th>\n",
       "      <th>Atmospheric pressure (hPa; not normalized to sea level)</th>\n",
       "      <th>Precipitation (mm)</th>\n",
       "      <th>Average wind speed (km/h; 10min window)</th>\n",
       "      <th>Wind direction (Degree)</th>\n",
       "      <th>Dew point (Degree Celcius)</th>\n",
       "      <th>Apparent temperature (Degree Celcius)</th>\n",
       "      <th>Maximum wind speed (km/h; 10min window)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2017-01-01T00:03:00</td>\n",
       "      <td>-4.06</td>\n",
       "      <td>-0.65</td>\n",
       "      <td>98.68</td>\n",
       "      <td>1014.66</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.60</td>\n",
       "      <td>169</td>\n",
       "      <td>-4.24</td>\n",
       "      <td>-7.36</td>\n",
       "      <td>10.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2017-01-01T00:13:00</td>\n",
       "      <td>-3.83</td>\n",
       "      <td>-0.63</td>\n",
       "      <td>98.77</td>\n",
       "      <td>1014.55</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.06</td>\n",
       "      <td>185</td>\n",
       "      <td>-3.99</td>\n",
       "      <td>-6.45</td>\n",
       "      <td>8.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>2017-01-01T00:23:00</td>\n",
       "      <td>-3.69</td>\n",
       "      <td>-0.65</td>\n",
       "      <td>98.67</td>\n",
       "      <td>1014.43</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.93</td>\n",
       "      <td>188</td>\n",
       "      <td>-3.87</td>\n",
       "      <td>-6.67</td>\n",
       "      <td>8.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>2017-01-01T00:33:00</td>\n",
       "      <td>-3.94</td>\n",
       "      <td>-0.63</td>\n",
       "      <td>98.71</td>\n",
       "      <td>1014.29</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.88</td>\n",
       "      <td>190</td>\n",
       "      <td>-4.12</td>\n",
       "      <td>-6.94</td>\n",
       "      <td>8.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>2017-01-01T00:43:00</td>\n",
       "      <td>-4.09</td>\n",
       "      <td>-0.64</td>\n",
       "      <td>98.73</td>\n",
       "      <td>1014.06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.67</td>\n",
       "      <td>192</td>\n",
       "      <td>-4.27</td>\n",
       "      <td>-7.43</td>\n",
       "      <td>10.60</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4450</th>\n",
       "      <td>4451</td>\n",
       "      <td>2017-01-31T23:13:00</td>\n",
       "      <td>2.77</td>\n",
       "      <td>-0.45</td>\n",
       "      <td>81.72</td>\n",
       "      <td>1003.78</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.46</td>\n",
       "      <td>53</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>2.77</td>\n",
       "      <td>8.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4451</th>\n",
       "      <td>4452</td>\n",
       "      <td>2017-01-31T23:23:00</td>\n",
       "      <td>2.81</td>\n",
       "      <td>-0.49</td>\n",
       "      <td>82.02</td>\n",
       "      <td>1003.79</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.35</td>\n",
       "      <td>49</td>\n",
       "      <td>0.05</td>\n",
       "      <td>2.81</td>\n",
       "      <td>6.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4452</th>\n",
       "      <td>4453</td>\n",
       "      <td>2017-01-31T23:33:00</td>\n",
       "      <td>2.87</td>\n",
       "      <td>-0.54</td>\n",
       "      <td>81.86</td>\n",
       "      <td>1003.88</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.29</td>\n",
       "      <td>32</td>\n",
       "      <td>0.08</td>\n",
       "      <td>2.87</td>\n",
       "      <td>6.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4453</th>\n",
       "      <td>4454</td>\n",
       "      <td>2017-01-31T23:43:00</td>\n",
       "      <td>2.82</td>\n",
       "      <td>-0.50</td>\n",
       "      <td>81.98</td>\n",
       "      <td>1003.90</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.49</td>\n",
       "      <td>42</td>\n",
       "      <td>0.05</td>\n",
       "      <td>2.82</td>\n",
       "      <td>6.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4454</th>\n",
       "      <td>4455</td>\n",
       "      <td>2017-01-31T23:53:00</td>\n",
       "      <td>2.71</td>\n",
       "      <td>-0.52</td>\n",
       "      <td>82.99</td>\n",
       "      <td>1003.90</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.46</td>\n",
       "      <td>49</td>\n",
       "      <td>0.11</td>\n",
       "      <td>0.93</td>\n",
       "      <td>8.19</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4455 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       _id Date and time (YYYY-MM-DD HH:MM:SS)  Temperature (Degree Celcius)  \\\n",
       "0        1                 2017-01-01T00:03:00                         -4.06   \n",
       "1        2                 2017-01-01T00:13:00                         -3.83   \n",
       "2        3                 2017-01-01T00:23:00                         -3.69   \n",
       "3        4                 2017-01-01T00:33:00                         -3.94   \n",
       "4        5                 2017-01-01T00:43:00                         -4.09   \n",
       "...    ...                                 ...                           ...   \n",
       "4450  4451                 2017-01-31T23:13:00                          2.77   \n",
       "4451  4452                 2017-01-31T23:23:00                          2.81   \n",
       "4452  4453                 2017-01-31T23:33:00                          2.87   \n",
       "4453  4454                 2017-01-31T23:43:00                          2.82   \n",
       "4454  4455                 2017-01-31T23:53:00                          2.71   \n",
       "\n",
       "      Global irradiance (W/m^2)  Humidity (%)  \\\n",
       "0                         -0.65         98.68   \n",
       "1                         -0.63         98.77   \n",
       "2                         -0.65         98.67   \n",
       "3                         -0.63         98.71   \n",
       "4                         -0.64         98.73   \n",
       "...                         ...           ...   \n",
       "4450                      -0.45         81.72   \n",
       "4451                      -0.49         82.02   \n",
       "4452                      -0.54         81.86   \n",
       "4453                      -0.50         81.98   \n",
       "4454                      -0.52         82.99   \n",
       "\n",
       "      Atmospheric pressure (hPa; not normalized to sea level)  \\\n",
       "0                                               1014.66         \n",
       "1                                               1014.55         \n",
       "2                                               1014.43         \n",
       "3                                               1014.29         \n",
       "4                                               1014.06         \n",
       "...                                                 ...         \n",
       "4450                                            1003.78         \n",
       "4451                                            1003.79         \n",
       "4452                                            1003.88         \n",
       "4453                                            1003.90         \n",
       "4454                                            1003.90         \n",
       "\n",
       "      Precipitation (mm)  Average wind speed (km/h; 10min window)  \\\n",
       "0                    0.0                                     7.60   \n",
       "1                    0.0                                     6.06   \n",
       "2                    0.0                                     6.93   \n",
       "3                    0.0                                     6.88   \n",
       "4                    0.0                                     7.67   \n",
       "...                  ...                                      ...   \n",
       "4450                 0.0                                     4.46   \n",
       "4451                 0.0                                     3.35   \n",
       "4452                 0.0                                     3.29   \n",
       "4453                 0.0                                     4.49   \n",
       "4454                 0.0                                     6.46   \n",
       "\n",
       "      Wind direction (Degree)  Dew point (Degree Celcius)  \\\n",
       "0                         169                       -4.24   \n",
       "1                         185                       -3.99   \n",
       "2                         188                       -3.87   \n",
       "3                         190                       -4.12   \n",
       "4                         192                       -4.27   \n",
       "...                       ...                         ...   \n",
       "4450                       53                       -0.04   \n",
       "4451                       49                        0.05   \n",
       "4452                       32                        0.08   \n",
       "4453                       42                        0.05   \n",
       "4454                       49                        0.11   \n",
       "\n",
       "      Apparent temperature (Degree Celcius)  \\\n",
       "0                                     -7.36   \n",
       "1                                     -6.45   \n",
       "2                                     -6.67   \n",
       "3                                     -6.94   \n",
       "4                                     -7.43   \n",
       "...                                     ...   \n",
       "4450                                   2.77   \n",
       "4451                                   2.81   \n",
       "4452                                   2.87   \n",
       "4453                                   2.82   \n",
       "4454                                   0.93   \n",
       "\n",
       "      Maximum wind speed (km/h; 10min window)  \n",
       "0                                       10.84  \n",
       "1                                        8.59  \n",
       "2                                        8.64  \n",
       "3                                        8.93  \n",
       "4                                       10.60  \n",
       "...                                       ...  \n",
       "4450                                     8.19  \n",
       "4451                                     6.03  \n",
       "4452                                     6.33  \n",
       "4453                                     6.54  \n",
       "4454                                     8.19  \n",
       "\n",
       "[4455 rows x 12 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "for chunk in last_entry.read_chunked(): display(chunk)"
   ]
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "fb4beda5a4c69f137057243dbc2dc0588fffe352cba42b265875a1e8d9564f47"
  },
  "kernelspec": {
   "display_name": "Python 3.10.5 64-bit ('INTAKEIDS')",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.5"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "fb4beda5a4c69f137057243dbc2dc0588fffe352cba42b265875a1e8d9564f47"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}