SPARKWEATHERDANIELCRUZ.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import databricks.koalas as ks"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'/home/h110-10/anaconda3/bin'"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pwd()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "w1=pd.read_csv(\"weather01.txt\", sep ='\\s+')\n",
    "w2=pd.read_csv(\"weather02.txt\", sep ='\\s+')\n",
    "w3=pd.read_csv(\"weather03.txt\", sep ='\\s+')\n",
    "w4=pd.read_csv(\"weather04.txt\", sep ='\\s+')\n",
    "w5=pd.read_csv(\"weather05.txt\", sep ='\\s+')\n",
    "w6=pd.read_csv(\"weather06.txt\", sep ='\\s+')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['X', 'year', 'month', 'measure', 'X1', 'X2'], dtype='object')"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "w1.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['X3', 'X4', 'X5', 'X6', 'X7'], dtype='object')"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "w2.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['X8', 'X9', 'X10', 'X11', 'X12', 'X13', 'X14'], dtype='object')"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "w3.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['X15', 'X16', 'X17', 'X18', 'X19', 'X20'], dtype='object')"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "w4.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['X21', 'X22', 'X23', 'X24', 'X25', 'X26', 'X27'], dtype='object')"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "w5.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['X28', 'X29', 'X30', 'X31'], dtype='object')"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "w6.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "k1=w1.rename(columns={'X':'Number', 'year':'Year', 'month':'Month', 'measure':'Measure', 'X1':'01', 'X2':'02'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "k2=w2.rename(columns={'X3':'03', 'X4':'04','X5':'05', 'X6':'06', 'X7':'07'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "k3=w3.rename(columns={'X8':'08', 'X9':'09','X10':'10', 'X11':'11','X12':'12','X13':'13', 'X14':'14'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "k4=w4.rename(columns={'X15':'15', 'X16':'16','X17':'17', 'X18':'18','X19':'19','X20':'20'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "k5=w5.rename(columns={'X21':'21', 'X22':'22','X23':'23', 'X24':'24','X25':'25','X26':'26', 'X27':'27'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "k6=w6.rename(columns={'X28':'28', 'X29':'29','X30':'30', 'X31':'31'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "kw1=ks.from_pandas(k1)\n",
    "kw2=ks.from_pandas(k2)\n",
    "kw3=ks.from_pandas(k3)\n",
    "kw4=ks.from_pandas(k4)\n",
    "kw5=ks.from_pandas(k5)\n",
    "kw6=ks.from_pandas(k6)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'kw1.reset_index()\\nkw2.reset_index()\\nkw3.reset_index()\\nkw4.reset_index()\\nkw5.reset_index()\\nkw6.reset_index()'"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'''kw1.reset_index()\n",
    "kw2.reset_index()\n",
    "kw3.reset_index()\n",
    "kw4.reset_index()\n",
    "kw5.reset_index()\n",
    "kw6.reset_index()'''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>03</th>\n",
       "      <th>04</th>\n",
       "      <th>05</th>\n",
       "      <th>06</th>\n",
       "      <th>07</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>51</td>\n",
       "      <td>43</td>\n",
       "      <td>42</td>\n",
       "      <td>45</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>44</td>\n",
       "      <td>37</td>\n",
       "      <td>34</td>\n",
       "      <td>42</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>37</td>\n",
       "      <td>30</td>\n",
       "      <td>26</td>\n",
       "      <td>38</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>49</td>\n",
       "      <td>24</td>\n",
       "      <td>37</td>\n",
       "      <td>45</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>42</td>\n",
       "      <td>21</td>\n",
       "      <td>25</td>\n",
       "      <td>40</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   03  04  05  06  07\n",
       "1  51  43  42  45  38\n",
       "2  44  37  34  42  30\n",
       "3  37  30  26  38  21\n",
       "4  49  24  37  45  36\n",
       "5  42  21  25  40  20"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kw2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "databricks.koalas.frame.DataFrame"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(kw1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>Number</th>\n",
       "      <th>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th>Measure</th>\n",
       "      <th>01</th>\n",
       "      <th>02</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2014</td>\n",
       "      <td>12</td>\n",
       "      <td>Max.TemperatureF</td>\n",
       "      <td>64</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2014</td>\n",
       "      <td>12</td>\n",
       "      <td>Mean.TemperatureF</td>\n",
       "      <td>52</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>2014</td>\n",
       "      <td>12</td>\n",
       "      <td>Min.TemperatureF</td>\n",
       "      <td>39</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>2014</td>\n",
       "      <td>12</td>\n",
       "      <td>Max.Dew.PointF</td>\n",
       "      <td>46</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>2014</td>\n",
       "      <td>12</td>\n",
       "      <td>MeanDew.PointF</td>\n",
       "      <td>40</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Number  Year  Month            Measure  01  02\n",
       "1       1  2014     12   Max.TemperatureF  64  42\n",
       "2       2  2014     12  Mean.TemperatureF  52  38\n",
       "3       3  2014     12   Min.TemperatureF  39  33\n",
       "4       4  2014     12     Max.Dew.PointF  46  40\n",
       "5       5  2014     12     MeanDew.PointF  40  27"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kw1.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "kf=pd.concat([k1,k2,k3,k4,k5,k6], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "#df=ks.concat([kw1,kw2,kw3,kw4,kw5,kw6])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "export_csv = kf.to_csv (r'weathero1.csv', index = None, header=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "kf.to_csv(r'weatherincsv.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "log_df=temp_var.toDF(header.split(\"\\\\t\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = sqlContext.read.load('weathero1.csv', \n",
    "                          format='com.databricks.spark.csv', \n",
    "                          header='true', \n",
    "                          inferSchema='true')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[Row(Number=1, Year=2014, Month=12, Measure='Max.TemperatureF', 01='64', 02='42', 03='51', 04='43', 05='42', 06='45', 07='38', 08='29', 09='49', 10='48', 11='39', 12='39', 13='42', 14='45', 15='42', 16='44', 17='49', 18='44', 19='37', 20='36', 21='36', 22='44', 23='47', 24='46', 25='59', 26='50', 27='52', 28='52', 29='41', 30='30', 31='30'),\n",
       " Row(Number=2, Year=2014, Month=12, Measure='Mean.TemperatureF', 01='52', 02='38', 03='44', 04='37', 05='34', 06='42', 07='30', 08='24', 09='39', 10='43', 11='36', 12='35', 13='37', 14='39', 15='37', 16='40', 17='45', 18='40', 19='33', 20='32', 21='33', 22='39', 23='45', 24='44', 25='52', 26='44', 27='45', 28='46', 29='36', 30='26', 31='25'),\n",
       " Row(Number=3, Year=2014, Month=12, Measure='Min.TemperatureF', 01='39', 02='33', 03='37', 04='30', 05='26', 06='38', 07='21', 08='18', 09='29', 10='38', 11='32', 12='31', 13='32', 14='33', 15='32', 16='35', 17='41', 18='36', 19='29', 20='27', 21='30', 22='33', 23='42', 24='41', 25='44', 26='37', 27='38', 28='40', 29='30', 30='22', 31='20'),\n",
       " Row(Number=4, Year=2014, Month=12, Measure='Max.Dew.PointF', 01='46', 02='40', 03='49', 04='24', 05='37', 06='45', 07='36', 08='28', 09='49', 10='45', 11='37', 12='28', 13='28', 14='29', 15='33', 16='42', 17='46', 18='34', 19='25', 20='30', 21='30', 22='39', 23='45', 24='46', 25='58', 26='31', 27='34', 28='42', 29='26', 30='10', 31='8'),\n",
       " Row(Number=5, Year=2014, Month=12, Measure='MeanDew.PointF', 01='40', 02='27', 03='42', 04='21', 05='25', 06='40', 07='20', 08='16', 09='41', 10='39', 11='31', 12='27', 13='26', 14='27', 15='29', 16='36', 17='41', 18='30', 19='22', 20='24', 21='27', 22='34', 23='42', 24='44', 25='43', 26='29', 27='31', 28='35', 29='20', 30='4', 31='5'),\n",
       " Row(Number=6, Year=2014, Month=12, Measure='Min.DewpointF', 01='26', 02='17', 03='24', 04='13', 05='12', 06='36', 07='-3', 08='3', 09='28', 10='37', 11='27', 12='25', 13='24', 14='25', 15='27', 16='30', 17='32', 18='26', 19='20', 20='20', 21='25', 22='25', 23='37', 24='41', 25='29', 26='28', 27='29', 28='27', 29='10', 30='-6', 31='1'),\n",
       " Row(Number=7, Year=2014, Month=12, Measure='Max.Humidity', 01='74', 02='92', 03='100', 04='69', 05='85', 06='100', 07='92', 08='92', 09='100', 10='100', 11='92', 12='85', 13='75', 14='82', 15='89', 16='96', 17='100', 18='89', 19='69', 20='89', 21='85', 22='89', 23='100', 24='100', 25='100', 26='70', 27='70', 28='76', 29='64', 30='50', 31='57'),\n",
       " Row(Number=8, Year=2014, Month=12, Measure='Mean.Humidity', 01='63', 02='72', 03='79', 04='54', 05='66', 06='93', 07='61', 08='70', 09='93', 10='95', 11='87', 12='75', 13='65', 14='68', 15='75', 16='85', 17='85', 18='73', 19='63', 20='79', 21='77', 22='79', 23='91', 24='98', 25='75', 26='60', 27='60', 28='65', 29='51', 30='38', 31='44'),\n",
       " Row(Number=9, Year=2014, Month=12, Measure='Min.Humidity', 01='52', 02='51', 03='57', 04='39', 05='47', 06='85', 07='29', 08='47', 09='86', 10='89', 11='82', 12='64', 13='55', 14='53', 15='60', 16='73', 17='70', 18='57', 19='56', 20='69', 21='69', 22='69', 23='82', 24='96', 25='49', 26='49', 27='50', 28='53', 29='37', 30='26', 31='31'),\n",
       " Row(Number=10, Year=2014, Month=12, Measure='Max.Sea.Level.PressureIn', 01='30.45', 02='30.71', 03='30.4', 04='30.56', 05='30.68', 06='30.42', 07='30.69', 08='30.77', 09='30.51', 10='29.58', 11='29.81', 12='29.88', 13='29.86', 14='29.91', 15='30.15', 16='30.17', 17='29.91', 18='29.87', 19='30.15', 20='30.31', 21='30.37', 22='30.4', 23='30.31', 24='30.13', 25='29.96', 26='30.16', 27='30.22', 28='29.99', 29='30.22', 30='30.36', 31='30.32'),\n",
       " Row(Number=11, Year=2014, Month=12, Measure='Mean.Sea.Level.PressureIn', 01='30.13', 02='30.59', 03='30.07', 04='30.33', 05='30.59', 06='30.24', 07='30.46', 08='30.67', 09='30.04', 10='29.5', 11='29.61', 12='29.85', 13='29.82', 14='29.83', 15='30.05', 16='30.09', 17='29.75', 18='29.78', 19='29.98', 20='30.26', 21='30.32', 22='30.35', 23='30.23', 24='29.9', 25='29.63', 26='30.11', 27='30.14', 28='29.87', 29='30.12', 30='30.32', 31='30.25'),\n",
       " Row(Number=12, Year=2014, Month=12, Measure='Min.Sea.Level.PressureIn', 01='30.01', 02='30.4', 03='29.87', 04='30.09', 05='30.45', 06='30.16', 07='30.24', 08='30.51', 09='29.49', 10='29.43', 11='29.44', 12='29.81', 13='29.78', 14='29.78', 15='29.91', 16='29.92', 17='29.69', 18='29.71', 19='29.86', 20='30.17', 21='30.28', 22='30.3', 23='30.16', 24='29.55', 25='29.47', 26='29.99', 27='30.03', 28='29.77', 29='30', 30='30.23', 31='30.13'),\n",
       " Row(Number=13, Year=2014, Month=12, Measure='Max.VisibilityMiles', 01='10', 02='10', 03='10', 04='10', 05='10', 06='10', 07='10', 08='10', 09='10', 10='10', 11='10', 12='10', 13='10', 14='10', 15='10', 16='10', 17='10', 18='10', 19='10', 20='10', 21='10', 22='10', 23='10', 24='2', 25='10', 26='10', 27='10', 28='10', 29='10', 30='10', 31='10'),\n",
       " Row(Number=14, Year=2014, Month=12, Measure='Mean.VisibilityMiles', 01='10', 02='8', 03='5', 04='10', 05='10', 06='4', 07='10', 08='8', 09='2', 10='3', 11='7', 12='10', 13='10', 14='10', 15='10', 16='9', 17='6', 18='10', 19='10', 20='10', 21='9', 22='10', 23='5', 24='1', 25='8', 26='10', 27='10', 28='10', 29='10', 30='10', 31='10'),\n",
       " Row(Number=15, Year=2014, Month=12, Measure='Min.VisibilityMiles', 01='10', 02='2', 03='1', 04='10', 05='5', 06='0', 07='5', 08='2', 09='1', 10='1', 11='1', 12='7', 13='10', 14='10', 15='10', 16='5', 17='1', 18='10', 19='10', 20='7', 21='6', 22='4', 23='1', 24='0', 25='1', 26='10', 27='10', 28='10', 29='10', 30='10', 31='10'),\n",
       " Row(Number=16, Year=2014, Month=12, Measure='Max.Wind.SpeedMPH', 01='22', 02='24', 03='29', 04='25', 05='22', 06='22', 07='25', 08='21', 09='38', 10='23', 11='21', 12='16', 13='17', 14='15', 15='15', 16='8', 17='20', 18='23', 19='17', 20='21', 21='16', 22='18', 23='20', 24='13', 25='28', 26='18', 27='17', 28='22', 29='15', 30='16', 31='17'),\n",
       " Row(Number=17, Year=2014, Month=12, Measure='Mean.Wind.SpeedMPH', 01='13', 02='15', 03='12', 04='12', 05='10', 06='8', 07='15', 08='13', 09='20', 10='13', 11='13', 12='11', 13='12', 14='10', 15='6', 16='4', 17='11', 18='14', 19='11', 20='10', 21='9', 22='8', 23='13', 24='6', 25='14', 26='11', 27='9', 28='14', 29='9', 30='10', 31='9'),\n",
       " Row(Number=18, Year=2014, Month=12, Measure='Max.Gust.SpeedMPH', 01='29', 02='29', 03='38', 04='33', 05='26', 06='25', 07='32', 08='28', 09='52', 10='29', 11='28', 12='21', 13='23', 14='20', 15='21', 16='10', 17='26', 18='30', 19='23', 20='26', 21='20', 22='22', 23='25', 24='15', 25='40', 26='25', 27='21', 28='31', 29='22', 30='21', 31='22'),\n",
       " Row(Number=19, Year=2014, Month=12, Measure='PrecipitationIn', 01='0.01', 02='0.10', 03='0.44', 04='0.00', 05='0.11', 06='1.09', 07='0.13', 08='0.03', 09='2.90', 10='0.28', 11='0.02', 12='T', 13='T', 14='0.00', 15='0.00', 16='T', 17='0.43', 18='0.01', 19='0.00', 20='T', 21='T', 22='0.05', 23='0.25', 24='0.56', 25='0.14', 26='0.00', 27='0.00', 28='0.01', 29='0.00', 30='0.00', 31='0.00'),\n",
       " Row(Number=20, Year=2014, Month=12, Measure='CloudCover', 01='6', 02='7', 03='8', 04='3', 05='5', 06='8', 07='6', 08='8', 09='8', 10='8', 11='8', 12='7', 13='5', 14='4', 15='2', 16='8', 17='8', 18='7', 19='4', 20='6', 21='8', 22='7', 23='8', 24='8', 25='6', 26='1', 27='3', 28='8', 29='4', 30='2', 31='1'),\n",
       " Row(Number=21, Year=2014, Month=12, Measure='Events', 01='Rain', 02='Rain-Snow', 03='Rain', 04='Rain', 05='Rain', 06='Rain', 07=None, 08='Snow', 09='Rain', 10='Rain', 11='Rain-Snow', 12='Snow', 13=None, 14=None, 15='Rain', 16='Rain', 17='Rain', 18='Snow', 19=None, 20=None, 21='Snow', 22='Rain', 23='Rain', 24='Fog-Rain', 25='Rain', 26=None, 27=None, 28='Rain', 29=None, 30=None, 31=None),\n",
       " Row(Number=22, Year=2014, Month=12, Measure='WindDirDegrees', 01='268', 02='62', 03='254', 04='292', 05='61', 06='313', 07='350', 08='354', 09='38', 10='357', 11='230', 12='286', 13='298', 14='306', 15='324', 16='79', 17='311', 18='281', 19='305', 20='350', 21='2', 22='24', 23='63', 24='12', 25='250', 26='255', 27='251', 28='252', 29='288', 30='313', 31='269'),\n",
       " Row(Number=23, Year=2015, Month=1, Measure='Max.TemperatureF', 01='33', 02='41', 03='37', 04='52', 05='50', 06='18', 07='26', 08='19', 09='30', 10='24', 11='33', 12='38', 13='35', 14='25', 15='31', 16='38', 17='22', 18='51', 19='46', 20='39', 21='34', 22='37', 23='37', 24='34', 25='38', 26='29', 27='19', 28='24', 29='32', 30='34', 31='21'),\n",
       " Row(Number=24, Year=2015, Month=1, Measure='Mean.TemperatureF', 01='28', 02='36', 03='30', 04='44', 05='34', 06='17', 07='15', 08='9', 09='25', 10='21', 11='24', 12='36', 13='25', 14='20', 15='28', 16='27', 17='16', 18='36', 19='39', 20='33', 21='28', 22='33', 23='31', 24='33', 25='29', 26='20', 27='17', 28='19', 29='21', 30='27', 31='16'),\n",
       " Row(Number=25, Year=2015, Month=1, Measure='Min.TemperatureF', 01='22', 02='31', 03='22', 04='35', 05='17', 06='15', 07='4', 08='-1', 09='19', 10='17', 11='15', 12='33', 13='15', 14='14', 15='25', 16='15', 17='9', 18='20', 19='32', 20='27', 21='22', 22='29', 23='24', 24='31', 25='19', 26='11', 27='14', 28='13', 29='10', 30='19', 31='11'),\n",
       " Row(Number=26, Year=2015, Month=1, Measure='Max.Dew.PointF', 01='16', 02='17', 03='36', 04='50', 05='39', 06='11', 07='12', 08='7', 09='22', 10='8', 11='22', 12='36', 13='25', 14='21', 15='27', 16='21', 17='11', 18='45', 19='43', 20='20', 21='25', 22='26', 23='20', 24='32', 25='28', 26='25', 27='14', 28='9', 29='22', 30='31', 31='7'),\n",
       " Row(Number=27, Year=2015, Month=1, Measure='MeanDew.PointF', 01='8', 02='15', 03='20', 04='41', 05='13', 06='5', 07='3', 08='-8', 09='14', 10='3', 11='6', 12='28', 13='5', 14='10', 15='24', 16='10', 17='-3', 18='35', 19='30', 20='13', 21='14', 22='22', 23='15', 24='29', 25='17', 26='15', 27='11', 28='6', 29='10', 30='26', 31='0'),\n",
       " Row(Number=28, Year=2015, Month=1, Measure='Min.DewpointF', 01='5', 02='11', 03='8', 04='34', 05='-6', 06='-5', 07='-13', 08='-18', 09='8', 10='-2', 11='-1', 12='17', 13='-4', 14='-4', 15='13', 16='-4', 17='-9', 18='13', 19='20', 20='5', 21='5', 22='19', 23='9', 24='21', 25='4', 26='-2', 27='7', 28='0', 29='-2', 30='7', 31='-8'),\n",
       " Row(Number=29, Year=2015, Month=1, Measure='Max.Humidity', 01='53', 02='53', 03='100', 04='100', 05='65', 06='80', 07='88', 08='56', 09='88', 10='62', 11='63', 12='100', 13='75', 14='88', 15='92', 16='71', 17='67', 18='93', 19='86', 20='59', 21='75', 22='78', 23='68', 24='100', 25='78', 26='92', 27='92', 28='80', 29='75', 30='92', 31='83'),\n",
       " Row(Number=30, Year=2015, Month=1, Measure='Mean.Humidity', 01='43', 02='45', 03='72', 04='95', 05='47', 06='59', 07='58', 08='49', 09='65', 10='49', 11='49', 12='72', 13='56', 14='67', 15='78', 16='52', 17='46', 18='80', 19='70', 20='44', 21='57', 22='67', 23='54', 24='82', 25='55', 26='71', 27='85', 28='63', 29='57', 30='78', 31='56'),\n",
       " Row(Number=31, Year=2015, Month=1, Measure='Min.Humidity', 01='32', 02='37', 03='43', 04='89', 05='29', 06='37', 07='28', 08='41', 09='42', 10='35', 11='34', 12='44', 13='36', 14='46', 15='63', 16='33', 17='25', 18='67', 19='53', 20='29', 21='38', 22='56', 23='39', 24='63', 25='32', 26='49', 27='77', 28='45', 29='39', 30='63', 31='28'),\n",
       " Row(Number=32, Year=2015, Month=1, Measure='Max.Sea.Level.PressureIn', 01='30.1', 02='30.45', 03='30.68', 04='30.16', 05='30.3', 06='30.37', 07='30.11', 08='30.34', 09='30.15', 10='30.5', 11='30.66', 12='30.45', 13='30.67', 14='30.61', 15='30.18', 16='30.11', 17='30.38', 18='30.26', 19='29.73', 20='29.98', 21='30.21', 22='30.22', 23='30.28', 24='29.92', 25='30.04', 26='30.15', 27='29.76', 28='30.24', 29='30.32', 30='30.06', 31='30.04'),\n",
       " Row(Number=33, Year=2015, Month=1, Measure='Mean.Sea.Level.PressureIn', 01='30', 02='30.13', 03='30.54', 04='29.81', 05='29.93', 06='30.22', 07='29.9', 08='30.25', 09='30', 10='30.34', 11='30.58', 12='30.23', 13='30.52', 14='30.4', 15='30', 16='29.82', 17='30.31', 18='29.93', 19='29.65', 20='29.83', 21='30.15', 22='30.19', 23='30.15', 24='29.52', 25='29.66', 26='30.05', 27='29.59', 28='29.89', 29='30.23', 30='29.82', 31='29.84'),\n",
       " Row(Number=34, Year=2015, Month=1, Measure='Min.Sea.Level.PressureIn', 01='29.92', 02='29.95', 03='30.24', 04='29.57', 05='29.61', 06='30', 07='29.76', 08='30.13', 09='29.89', 10='30.15', 11='30.48', 12='30.11', 13='30.19', 14='30.18', 15='29.81', 16='29.68', 17='30.14', 18='29.55', 19='29.55', 20='29.75', 21='30', 22='30.16', 23='29.93', 24='29.16', 25='29.31', 26='29.81', 27='29.49', 28='29.67', 29='30.06', 30='29.71', 31='29.72'),\n",
       " Row(Number=35, Year=2015, Month=1, Measure='Max.VisibilityMiles', 01='10', 02='10', 03='10', 04='10', 05='10', 06='10', 07='10', 08='10', 09='10', 10='10', 11='10', 12='10', 13='10', 14='10', 15='10', 16='10', 17='10', 18='10', 19='10', 20='10', 21='10', 22='10', 23='10', 24='10', 25='10', 26='10', 27='4', 28='10', 29='10', 30='10', 31='10'),\n",
       " Row(Number=36, Year=2015, Month=1, Measure='Mean.VisibilityMiles', 01='10', 02='10', 03='6', 04='4', 05='10', 06='7', 07='9', 08='10', 09='8', 10='10', 11='10', 12='7', 13='10', 14='10', 15='5', 16='10', 17='10', 18='10', 19='10', 20='10', 21='10', 22='10', 23='10', 24='3', 25='10', 26='5', 27='1', 28='7', 29='10', 30='6', 31='6'),\n",
       " Row(Number=37, Year=2015, Month=1, Measure='Min.VisibilityMiles', 01='10', 02='10', 03='1', 04='0', 05='10', 06='1', 07='2', 08='10', 09='1', 10='10', 11='10', 12='1', 13='10', 14='6', 15='0', 16='9', 17='10', 18='5', 19='10', 20='10', 21='10', 22='8', 23='10', 24='0', 25='10', 26='0', 27='0', 28='1', 29='7', 30='1', 31='0'),\n",
       " Row(Number=38, Year=2015, Month=1, Measure='Max.Wind.SpeedMPH', 01='23', 02='26', 03='22', 04='17', 05='37', 06='22', 07='31', 08='25', 09='25', 10='20', 11='17', 12='17', 13='21', 14='13', 15='15', 16='29', 17='22', 18='26', 19='23', 20='23', 21='14', 22='14', 23='16', 24='18', 25='25', 26='33', 27='32', 28='20', 29='13', 30='32', 31='36'),\n",
       " Row(Number=39, Year=2015, Month=1, Measure='Mean.Wind.SpeedMPH', 01='14', 02='13', 03='10', 04='8', 05='22', 06='9', 07='16', 08='14', 09='14', 10='12', 11='10', 12='9', 13='11', 14='9', 15='10', 16='16', 17='11', 18='10', 19='15', 20='14', 21='7', 22='7', 23='10', 24='10', 25='14', 26='16', 27='22', 28='13', 29='4', 30='12', 31='22'),\n",
       " Row(Number=40, Year=2015, Month=1, Measure='Max.Gust.SpeedMPH', 01='29', 02='32', 03='25', 04='26', 05='49', 06='28', 07='40', 08='32', 09='35', 10='23', 11='24', 12='23', 13='26', 14='16', 15='21', 16='39', 17='31', 18='33', 19='31', 20='30', 21='20', 22='17', 23='22', 24='24', 25='33', 26='43', 27='45', 28='26', 29='17', 30='44', 31='48'),\n",
       " Row(Number=41, Year=2015, Month=1, Measure='PrecipitationIn', 01='0.00', 02='0.00', 03='0.62', 04='0.57', 05='0.00', 06='0.02', 07='T', 08='0.00', 09='0.01', 10='0.00', 11='0.00', 12='0.20', 13='0.00', 14='T', 15='0.12', 16='0.00', 17='0.00', 18='0.15', 19='0.00', 20='0.00', 21='0.00', 22='T', 23='0.00', 24='0.71', 25='0.00', 26='0.10', 27='0.95', 28='0.01', 29='T', 30='0.06', 31='0.05'),\n",
       " Row(Number=42, Year=2015, Month=1, Measure='CloudCover', 01='3', 02='3', 03='7', 04='8', 05='2', 06='6', 07='3', 08='1', 09='4', 10='1', 11='6', 12='8', 13='3', 14='8', 15='8', 16='2', 17='1', 18='8', 19='3', 20='3', 21='5', 22='6', 23='2', 24='8', 25='4', 26='8', 27='8', 28='6', 29='3', 30='8', 31='5'),\n",
       " Row(Number=43, Year=2015, Month=1, Measure='Events', 01=None, 02=None, 03='Rain-Snow', 04='Fog-Rain', 05='Snow', 06='Snow', 07=None, 08='Snow', 09='Rain', 10='Snow', 11=None, 12=None, 13=None, 14=None, 15='Fog-Snow', 16='Rain', 17=None, 18=None, 19=None, 20=None, 21='Snow', 22='Fog-Rain-Snow', 23='Fog-Snow', 24='Fog-Snow', 25=None, 26=None, 27=None, 28='Snow', 29='Snow', 30='Snow', 31=None),\n",
       " Row(Number=44, Year=2015, Month=1, Measure='WindDirDegrees', 01='230', 02='260', 03='81', 04='260', 05='280', 06='262', 07='272', 08='259', 09='240', 10='263', 11='226', 12='242', 13='347', 14='323', 15='302', 16='263', 17='253', 18='164', 19='262', 20='270', 21='357', 22='335', 23='259', 24='290', 25='284', 26='23', 27='335', 28='305', 29='245', 30='223', 31='302'),\n",
       " Row(Number=45, Year=2015, Month=2, Measure='Max.TemperatureF', 01='30', 02='31', 03='22', 04='38', 05='36', 06='21', 07='29', 08='29', 09='25', 10='30', 11='25', 12='30', 13='22', 14='30', 15='20', 16='19', 17='23', 18='29', 19='30', 20='20', 21='34', 22='39', 23='33', 24='19', 25='35', 26='22', 27='27', 28='31', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=46, Year=2015, Month=2, Measure='Mean.TemperatureF', 01='21', 02='21', 03='14', 04='26', 05='22', 06='13', 07='23', 08='21', 09='20', 10='22', 11='20', 12='23', 13='15', 14='17', 15='9', 16='8', 17='17', 18='23', 19='20', 20='13', 21='19', 22='34', 23='19', 24='11', 25='25', 26='20', 27='21', 28='22', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=47, Year=2015, Month=2, Measure='Min.TemperatureF', 01='12', 02='10', 03='6', 04='14', 05='7', 06='5', 07='16', 08='13', 09='14', 10='14', 11='14', 12='16', 13='7', 14='3', 15='-2', 16='-3', 17='10', 18='17', 19='10', 20='5', 21='4', 22='28', 23='4', 24='2', 25='14', 26='17', 27='15', 28='12', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=48, Year=2015, Month=2, Measure='Max.Dew.PointF', 01='11', 02='29', 03='7', 04='30', 05='32', 06='6', 07='27', 08='27', 09='21', 10='21', 11='17', 12='25', 13='11', 14='29', 15='18', 16='-6', 17='18', 18='23', 19='24', 20='-4', 21='32', 22='33', 23='23', 24='15', 25='19', 26='16', 27='1', 28='4', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=49, Year=2015, Month=2, Measure='MeanDew.PointF', 01='2', 02='13', 03='1', 04='17', 05='18', 06='-1', 07='17', 08='20', 09='14', 10='15', 11='12', 12='17', 13='-5', 14='11', 15='9', 16='-11', 17='6', 18='16', 19='14', 20='-6', 21='16', 22='29', 23='2', 24='-4', 25='11', 26='8', 27='-2', 28='1', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=50, Year=2015, Month=2, Measure='Min.DewpointF', 01='-6', 02='-5', 03='-3', 04='3', 05='-7', 06='-8', 07='5', 08='10', 09='10', 10='10', 11='6', 12='7', 13='-10', 14='-9', 15='-13', 16='-16', 17='-7', 18='8', 19='-5', 20='-10', 21='-5', 22='24', 23='-14', 24='-15', 25='2', 26='2', 27='-5', 28='-1', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=51, Year=2015, Month=2, Measure='Max.Humidity', 01='67', 02='100', 03='73', 04='75', 05='89', 06='60', 07='92', 08='100', 09='92', 10='88', 11='77', 12='92', 13='77', 14='100', 15='92', 16='56', 17='84', 18='81', 19='92', 20='55', 21='92', 22='100', 23='72', 24='80', 25='92', 26='84', 27='52', 28='58', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=52, Year=2015, Month=2, Measure='Mean.Humidity', 01='48', 02='67', 03='56', 04='64', 05='66', 06='53', 07='74', 08='90', 09='86', 10='76', 11='69', 12='77', 13='55', 14='73', 15='71', 16='44', 17='63', 18='66', 19='71', 20='45', 21='70', 22='85', 23='51', 24='60', 25='63', 26='65', 27='41', 28='43', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=53, Year=2015, Month=2, Measure='Min.Humidity', 01='29', 02='34', 03='39', 04='53', 05='42', 06='46', 07='55', 08='80', 09='80', 10='63', 11='61', 12='61', 13='33', 14='45', 15='50', 16='31', 17='42', 18='50', 19='50', 20='34', 21='48', 22='70', 23='30', 24='39', 25='33', 26='45', 27='29', 28='27', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=54, Year=2015, Month=2, Measure='Max.Sea.Level.PressureIn', 01='30.16', 02='30.12', 03='30.31', 04='30.32', 05='30.12', 06='30.17', 07='30.1', 08='30.08', 09='30.16', 10='30.13', 11='30.14', 12='29.92', 13='30.11', 14='30.1', 15='29.82', 16='30.04', 17='30.03', 18='29.95', 19='29.73', 20='30.43', 21='30.53', 22='30.17', 23='30.32', 24='30.33', 25='30.01', 26='30.12', 27='30.55', 28='30.75', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=55, Year=2015, Month=2, Measure='Mean.Sea.Level.PressureIn', 01='30.12', 02='29.69', 03='30.12', 04='30.16', 05='29.93', 06='30.1', 07='30.05', 08='30.05', 09='30.12', 10='30.1', 11='30.07', 12='29.76', 13='29.95', 14='29.77', 15='29.49', 16='29.91', 17='29.93', 18='29.83', 19='29.61', 20='30.04', 21='30.36', 22='30.14', 23='30.18', 24='30.18', 25='29.8', 26='30.05', 27='30.34', 28='30.69', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=56, Year=2015, Month=2, Measure='Min.Sea.Level.PressureIn', 01='30.04', 02='29.48', 03='29.72', 04='29.94', 05='29.82', 06='30.04', 07='30.01', 08='30.01', 09='30.08', 10='30.06', 11='29.94', 12='29.69', 13='29.74', 14='29.46', 15='29.3', 16='29.81', 17='29.85', 18='29.7', 19='29.53', 20='29.74', 21='30.16', 22='30.1', 23='30.1', 24='29.88', 25='29.7', 26='29.97', 27='30.14', 28='30.56', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=57, Year=2015, Month=2, Measure='Max.VisibilityMiles', 01='10', 02='10', 03='10', 04='10', 05='10', 06='10', 07='10', 08='7', 09='4', 10='10', 11='10', 12='10', 13='10', 14='10', 15='10', 16='10', 17='10', 18='10', 19='10', 20='10', 21='10', 22='10', 23='10', 24='10', 25='10', 26='10', 27='10', 28='10', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=58, Year=2015, Month=2, Measure='Mean.VisibilityMiles', 01='10', 02='2', 03='9', 04='10', 05='6', 06='10', 07='7', 08='2', 09='1', 10='8', 11='7', 12='6', 13='10', 14='6', 15='3', 16='9', 17='7', 18='8', 19='6', 20='10', 21='5', 22='8', 23='10', 24='10', 25='8', 26='8', 27='10', 28='10', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=59, Year=2015, Month=2, Measure='Min.VisibilityMiles', 01='10', 02='0', 03='4', 04='10', 05='0', 06='10', 07='1', 08='1', 09='0', 10='1', 11='1', 12='0', 13='8', 14='1', 15='0', 16='2', 17='1', 18='1', 19='1', 20='10', 21='1', 22='1', 23='10', 24='5', 25='2', 26='1', 27='10', 28='10', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=60, Year=2015, Month=2, Measure='Max.Wind.SpeedMPH', 01='22', 02='36', 03='24', 04='20', 05='30', 06='21', 07='20', 08='22', 09='26', 10='21', 11='23', 12='16', 13='28', 14='22', 15='33', 16='31', 17='14', 18='14', 19='30', 20='28', 21='26', 22='13', 23='25', 24='20', 25='22', 26='18', 27='14', 28='15', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=61, Year=2015, Month=2, Measure='Mean.Wind.SpeedMPH', 01='12', 02='18', 03='13', 04='9', 05='15', 06='12', 07='11', 08='14', 09='15', 10='11', 11='12', 12='5', 13='17', 14='10', 15='21', 16='20', 17='8', 18='5', 19='14', 20='19', 21='11', 22='5', 23='15', 24='9', 25='11', 26='9', 27='8', 28='9', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=62, Year=2015, Month=2, Measure='Max.Gust.SpeedMPH', 01='29', 02='45', 03='33', 04='26', 05='40', 06='29', 07='26', 08='28', 09='32', 10='24', 11='31', 12='21', 13='37', 14='24', 15='51', 16='41', 17='18', 18='17', 19='40', 20='35', 21='35', 22='16', 23='35', 24='24', 25='29', 26='21', 27='18', 28='20', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=63, Year=2015, Month=2, Measure='PrecipitationIn', 01='0.00', 02='0.78', 03='0.00', 04='0.00', 05='0.09', 06='T', 07='0.07', 08='0.37', 09='0.88', 10='0.05', 11='0.01', 12='0.03', 13='0.00', 14='0.23', 15='0.39', 16='0.00', 17='0.02', 18='0.01', 19='0.06', 20='0.00', 21='0.17', 22='0.11', 23='0.00', 24='T', 25='0.07', 26='0.02', 27='0.00', 28='0.00', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=64, Year=2015, Month=2, Measure='CloudCover', 01='4', 02='7', 03='1', 04='7', 05='7', 06='3', 07='7', 08='8', 09='8', 10='7', 11='7', 12='8', 13='2', 14='6', 15='6', 16='3', 17='7', 18='8', 19='6', 20='2', 21='6', 22='8', 23='5', 24='6', 25='4', 26='8', 27='2', 28='0', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=65, Year=2015, Month=2, Measure='Events', 01='Fog-Snow', 02=None, 03='Snow', 04='Fog-Rain-Snow', 05='Snow', 06=None, 07=None, 08='Snow', 09='Fog-Snow', 10='Snow', 11='Snow', 12='Fog-Snow', 13='Snow', 14=None, 15='Fog-Snow', 16='Snow', 17='Snow', 18='Snow', 19='Snow', 20=None, 21='Rain-Snow', 22='Rain-Snow', 23='Snow', 24='Snow', 25='Snow', 26=None, 27=None, 28='<NA>', 29='<NA>', 30='<NA>', 31=None),\n",
       " Row(Number=66, Year=2015, Month=2, Measure='WindDirDegrees', 01='289', 02='360', 03='265', 04='209', 05='303', 06='263', 07='226', 08='8', 09='351', 10='359', 11='354', 12='321', 13='296', 14='181', 15='320', 16='290', 17='338', 18='337', 19='263', 20='273', 21='201', 22='245', 23='298', 24='221', 25='287', 26='351', 27='305', 28='273', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=67, Year=2015, Month=3, Measure='Max.TemperatureF', 01='30', 02='37', 03='33', 04='43', 05='39', 06='24', 07='38', 08='42', 09='48', 10='48', 11='57', 12='43', 13='40', 14='39', 15='41', 16='45', 17='51', 18='30', 19='34', 20='32', 21='41', 22='39', 23='33', 24='35', 25='49', 26='56', 27='44', 28='40', 29='42', 30='45', 31='50'),\n",
       " Row(Number=68, Year=2015, Month=3, Measure='Mean.TemperatureF', 01='21', 02='32', 03='27', 04='38', 05='29', 06='17', 07='28', 08='33', 09='37', 10='40', 11='47', 12='34', 13='32', 14='35', 15='34', 16='36', 17='40', 18='26', 19='27', 20='28', 21='35', 22='30', 23='26', 24='28', 25='39', 26='47', 27='41', 28='35', 29='34', 30='38', 31='44'),\n",
       " Row(Number=69, Year=2015, Month=3, Measure='Min.TemperatureF', 01='12', 02='26', 03='20', 04='33', 05='18', 06='9', 07='17', 08='24', 09='26', 10='31', 11='37', 12='25', 13='24', 14='31', 15='27', 16='26', 17='28', 18='22', 19='19', 20='23', 21='28', 22='21', 23='18', 24='20', 25='28', 26='38', 27='37', 28='30', 29='26', 30='30', 31='37'),\n",
       " Row(Number=70, Year=2015, Month=3, Measure='Max.Dew.PointF', 01='27', 02='27', 03='31', 04='36', 05='28', 06='11', 07='21', 08='27', 09='22', 10='39', 11='40', 12='27', 13='24', 14='39', 15='34', 16='23', 17='41', 18='7', 19='0', 20='26', 21='33', 22='23', 23='6', 24='24', 25='34', 26='52', 27='43', 28='36', 29='19', 30='33', 31='28'),\n",
       " Row(Number=71, Year=2015, Month=3, Measure='MeanDew.PointF', 01='16', 02='19', 03='14', 04='32', 05='11', 06='-1', 07='12', 08='20', 09='19', 10='28', 11='34', 12='12', 13='7', 14='32', 15='30', 16='14', 17='27', 18='0', 19='-2', 20='13', 21='29', 22='5', 23='0', 24='15', 25='22', 26='45', 27='38', 28='30', 29='11', 30='27', 31='24'),\n",
       " Row(Number=72, Year=2015, Month=3, Measure='Min.DewpointF', 01='2', 02='7', 03='1', 04='29', 05='-4', 06='-8', 07='6', 08='13', 09='16', 10='19', 11='25', 12='1', 13='1', 14='19', 15='19', 16='5', 17='4', 18='-6', 19='-4', 20='0', 21='25', 22='-5', 23='-6', 24='6', 25='16', 26='35', 27='35', 28='19', 29='3', 30='17', 31='18'),\n",
       " Row(Number=73, Year=2015, Month=3, Measure='Max.Humidity', 01='92', 02='92', 03='92', 04='92', 05='76', 06='62', 07='67', 08='78', 09='81', 10='100', 11='100', 12='59', 13='69', 14='100', 15='100', 16='63', 17='100', 18='46', 19='39', 20='100', 21='96', 22='54', 23='49', 24='72', 25='85', 26='100', 27='96', 28='96', 29='59', 30='69', 31='70'),\n",
       " Row(Number=74, Year=2015, Month=3, Measure='Mean.Humidity', 01='66', 02='67', 03='60', 04='75', 05='56', 06='48', 07='48', 08='58', 09='56', 10='69', 11='65', 12='42', 13='45', 14='80', 15='85', 16='41', 17='66', 18='35', 19='30', 20='67', 21='78', 22='38', 23='38', 24='59', 25='60', 26='86', 27='88', 28='78', 29='40', 30='59', 31='51'),\n",
       " Row(Number=75, Year=2015, Month=3, Measure='Min.Humidity', 01='40', 02='41', 03='28', 04='57', 05='35', 06='34', 07='29', 08='38', 09='31', 10='37', 11='30', 12='25', 13='21', 14='59', 15='69', 16='19', 17='31', 18='23', 19='21', 20='33', 21='59', 22='22', 23='26', 24='46', 25='34', 26='71', 27='79', 28='59', 29='20', 30='48', 31='31'),\n",
       " Row(Number=76, Year=2015, Month=3, Measure='Max.Sea.Level.PressureIn', 01='30.71', 02='30.25', 03='30.41', 04='29.87', 05='30.32', 06='30.51', 07='30.29', 08='30.12', 09='30.24', 10='30.34', 11='29.99', 12='30.56', 13='30.64', 14='30.36', 15='29.88', 16='29.95', 17='29.74', 18='30.08', 19='30.34', 20='30.4', 21='30.17', 22='30.11', 23='30.23', 24='30.35', 25='30.42', 26='30.16', 27='29.76', 28='30.02', 29='30.22', 30='30.08', 31='29.79'),\n",
       " Row(Number=77, Year=2015, Month=3, Measure='Mean.Sea.Level.PressureIn', 01='30.46', 02='30.03', 03='30.17', 04='29.75', 05='30.07', 06='30.42', 07='30.11', 08='30.03', 09='30.11', 10='30.19', 11='29.86', 12='30.28', 13='30.53', 14='30.03', 15='29.65', 16='29.86', 17='29.58', 18='29.88', 19='30.19', 20='30.32', 21='29.99', 22='29.93', 23='30.13', 24='30.31', 25='30.33', 26='29.82', 27='29.71', 28='29.81', 29='30.13', 30='29.84', 31='29.73'),\n",
       " Row(Number=78, Year=2015, Month=3, Measure='Min.Sea.Level.PressureIn', 01='30.12', 02='29.93', 03='29.8', 04='29.64', 05='29.85', 06='30.29', 07='29.95', 08='29.94', 09='30.05', 10='30', 11='29.79', 12='29.94', 13='30.37', 14='29.63', 15='29.58', 16='29.77', 17='29.38', 18='29.74', 19='30.09', 20='30.19', 21='29.76', 22='29.76', 23='30.08', 24='30.24', 25='30.17', 26='29.64', 27='29.65', 28='29.71', 29='30.04', 30='29.72', 31='29.69'),\n",
       " Row(Number=79, Year=2015, Month=3, Measure='Max.VisibilityMiles', 01='10', 02='10', 03='10', 04='10', 05='10', 06='10', 07='10', 08='10', 09='10', 10='10', 11='10', 12='10', 13='10', 14='10', 15='10', 16='10', 17='10', 18='10', 19='10', 20='10', 21='10', 22='10', 23='10', 24='10', 25='10', 26='10', 27='10', 28='10', 29='10', 30='10', 31='10'),\n",
       " Row(Number=80, Year=2015, Month=3, Measure='Mean.VisibilityMiles', 01='6', 02='9', 03='6', 04='10', 05='9', 06='10', 07='10', 08='10', 09='10', 10='8', 11='7', 12='10', 13='10', 14='4', 15='5', 16='10', 17='8', 18='10', 19='10', 20='7', 21='5', 22='10', 23='10', 24='10', 25='10', 26='5', 27='9', 28='4', 29='10', 30='9', 31='10'),\n",
       " Row(Number=81, Year=2015, Month=3, Measure='Min.VisibilityMiles', 01='1', 02='1', 03='1', 04='2', 05='2', 06='10', 07='10', 08='7', 09='10', 10='1', 11='0', 12='10', 13='10', 14='0', 15='0', 16='10', 17='2', 18='10', 19='10', 20='1', 21='1', 22='10', 23='10', 24='10', 25='10', 26='0', 27='3', 28='0', 29='10', 30='2', 31='10'),\n",
       " Row(Number=82, Year=2015, Month=3, Measure='Max.Wind.SpeedMPH', 01='20', 02='30', 03='24', 04='21', 05='20', 06='23', 07='21', 08='25', 09='25', 10='17', 11='25', 12='32', 13='18', 14='15', 15='33', 16='18', 17='38', 18='36', 19='30', 20='12', 21='22', 22='33', 23='24', 24='13', 25='22', 26='16', 27='13', 28='24', 29='17', 30='29', 31='20'),\n",
       " Row(Number=83, Year=2015, Month=3, Measure='Mean.Wind.SpeedMPH', 01='6', 02='14', 03='10', 04='11', 05='12', 06='10', 07='11', 08='9', 09='10', 10='7', 11='12', 12='17', 13='11', 14='8', 15='14', 16='9', 17='14', 18='22', 19='16', 20='4', 21='7', 22='18', 23='15', 24='8', 25='9', 26='9', 27='5', 28='13', 29='9', 30='13', 31='12'),\n",
       " Row(Number=84, Year=2015, Month=3, Measure='Max.Gust.SpeedMPH', 01='23', 02='41', 03='32', 04='30', 05='28', 06='29', 07='25', 08='32', 09='37', 10='21', 11='33', 12='41', 13='23', 14='20', 15='40', 16='25', 17='51', 18='52', 19='41', 20='26', 21='31', 22='48', 23='31', 24='16', 25='28', 26='23', 27='15', 28='30', 29='22', 30='35', 31='29'),\n",
       " Row(Number=85, Year=2015, Month=3, Measure='PrecipitationIn', 01='0.17', 02='0.01', 03='0.26', 04='0.02', 05='T', 06='0.00', 07='0.00', 08='T', 09='0.00', 10='0.06', 11='0.01', 12='0.00', 13='0.00', 14='0.80', 15='0.27', 16='0.00', 17='0.14', 18='0.00', 19='0.00', 20='0.05', 21='0.09', 22='0.00', 23='0.00', 24='0.00', 25='0.04', 26='0.80', 27='0.21', 28='0.12', 29='0.00', 30='T', 31='0.00'),\n",
       " Row(Number=86, Year=2015, Month=3, Measure='CloudCover', 01='7', 02='6', 03='6', 04='8', 05='8', 06='2', 07='3', 08='4', 09='3', 10='7', 11='5', 12='2', 13='4', 14='7', 15='8', 16='2', 17='5', 18='1', 19='1', 20='7', 21='7', 22='1', 23='0', 24='4', 25='4', 26='8', 27='8', 28='8', 29='3', 30='6', 31='3'),\n",
       " Row(Number=87, Year=2015, Month=3, Measure='Events', 01='Snow', 02='Rain-Snow', 03='Rain-Snow', 04='Rain', 05='Snow', 06=None, 07=None, 08='Snow', 09='Rain', 10='Fog-Rain', 11='Fog-Rain', 12=None, 13=None, 14=None, 15='Fog-Rain-Snow', 16='Rain-Snow', 17='Snow', 18=None, 19=None, 20=None, 21='Snow', 22='Rain', 23='Fog-Rain', 24='Rain', 25=None, 26=None, 27=None, 28='Fog-Rain-Snow', 29='Rain-Snow', 30=None, 31=None),\n",
       " Row(Number=88, Year=2015, Month=3, Measure='WindDirDegrees', 01='206', 02='280', 03='213', 04='236', 05='316', 06='277', 07='226', 08='247', 09='242', 10='193', 11='245', 12='315', 13='269', 14='56', 15='329', 16='275', 17='250', 18='302', 19='306', 20='150', 21='57', 22='296', 23='290', 24='214', 25='181', 26='223', 27='9', 28='355', 29='272', 30='214', 31='279'),\n",
       " Row(Number=89, Year=2015, Month=4, Measure='Max.TemperatureF', 01='47', 02='61', 03='59', 04='52', 05='49', 06='42', 07='42', 08='42', 09='37', 10='55', 11='57', 12='68', 13='69', 14='65', 15='67', 16='60', 17='65', 18='60', 19='50', 20='51', 21='65', 22='67', 23='51', 24='50', 25='56', 26='56', 27='57', 28='64', 29='54', 30='55', 31='<NA>'),\n",
       " Row(Number=90, Year=2015, Month=4, Measure='Mean.TemperatureF', 01='39', 02='46', 03='52', 04='44', 05='41', 06='39', 07='39', 08='38', 09='35', 10='46', 11='50', 12='54', 13='55', 14='59', 15='59', 16='51', 17='56', 18='52', 19='46', 20='46', 21='56', 22='55', 23='45', 24='44', 25='46', 26='50', 27='51', 28='53', 29='51', 30='50', 31='<NA>'),\n",
       " Row(Number=91, Year=2015, Month=4, Measure='Min.TemperatureF', 01='30', 02='30', 03='45', 04='36', 05='32', 06='36', 07='36', 08='34', 09='33', 10='36', 11='42', 12='39', 13='41', 14='52', 15='50', 16='41', 17='47', 18='43', 19='41', 20='41', 21='46', 22='43', 23='38', 24='37', 25='36', 26='43', 27='45', 28='42', 29='48', 30='44', 31='<NA>'),\n",
       " Row(Number=92, Year=2015, Month=4, Measure='Max.Dew.PointF', 01='16', 02='37', 03='50', 04='48', 05='30', 06='37', 07='37', 08='34', 09='36', 10='52', 11='50', 12='35', 13='42', 14='52', 15='31', 16='32', 17='54', 18='47', 19='38', 20='51', 21='57', 22='46', 23='40', 24='28', 25='33', 26='39', 27='44', 28='42', 29='41', 30='42', 31='<NA>'),\n",
       " Row(Number=93, Year=2015, Month=4, Measure='MeanDew.PointF', 01='7', 02='20', 03='45', 04='36', 05='21', 06='31', 07='36', 08='31', 09='34', 10='42', 11='32', 12='28', 13='34', 14='39', 15='23', 16='23', 17='47', 18='42', 19='34', 20='42', 21='49', 22='39', 23='27', 24='24', 25='26', 26='33', 27='37', 28='35', 29='38', 30='40', 31='<NA>'),\n",
       " Row(Number=94, Year=2015, Month=4, Measure='Min.DewpointF', 01='1', 02='8', 03='39', 04='13', 05='10', 06='26', 07='34', 08='25', 09='32', 10='36', 11='26', 12='25', 13='27', 14='30', 15='16', 16='16', 17='30', 18='38', 19='32', 20='35', 21='36', 22='32', 23='18', 24='20', 25='21', 26='28', 27='32', 28='29', 29='36', 30='37', 31='<NA>'),\n",
       " Row(Number=95, Year=2015, Month=4, Measure='Max.Humidity', 01='40', 02='61', 03='100', 04='100', 05='76', 06='92', 07='92', 08='92', 09='100', 10='100', 11='89', 12='59', 13='66', 14='80', 15='39', 16='67', 17='89', 18='89', 19='76', 20='100', 21='1000', 22='89', 23='71', 24='64', 25='60', 26='71', 27='63', 28='76', 29='77', 30='89', 31='<NA>'),\n",
       " Row(Number=96, Year=2015, Month=4, Measure='Mean.Humidity', 01='29', 02='44', 03='80', 04='66', 05='49', 06='74', 07='84', 08='73', 09='95', 10='95', 11='61', 12='39', 13='43', 14='54', 15='28', 16='46', 17='70', 18='68', 19='66', 20='90', 21='71', 22='59', 23='49', 24='49', 25='46', 26='53', 27='52', 28='51', 29='64', 30='72', 31='<NA>'),\n",
       " Row(Number=97, Year=2015, Month=4, Measure='Min.Humidity', 01='17', 02='27', 03='59', 04='31', 05='21', 06='55', 07='76', 08='54', 09='89', 10='89', 11='32', 12='19', 13='20', 14='28', 15='16', 16='24', 17='50', 18='47', 19='56', 20='79', 21='42', 22='28', 23='27', 24='34', 25='32', 26='35', 27='40', 28='26', 29='50', 30='55', 31='<NA>'),\n",
       " Row(Number=98, Year=2015, Month=4, Measure='Max.Sea.Level.PressureIn', 01='30.17', 02='30.25', 03='29.86', 04='30.08', 05='30.26', 06='30.4', 07='30.4', 08='30.51', 09='30.42', 10='30.3', 11='30.1', 12='30.29', 13='30.36', 14='30.13', 15='30.38', 16='30.51', 17='30.24', 18='30.09', 19='30.29', 20='30.25', 21='29.75', 22='29.8', 23='29.7', 24='29.79', 25='29.79', 26='29.72', 27='29.63', 28='29.78', 29='29.8', 30='29.98', 31='<NA>'),\n",
       " Row(Number=99, Year=2015, Month=4, Measure='Mean.Sea.Level.PressureIn', 01='29.99', 02='30.1', 03='29.76', 04='29.63', 05='30.13', 06='30.3', 07='30.3', 08='30.43', 09='30.37', 10='29.94', 11='29.86', 12='30.21', 13='30.26', 14='30.08', 15='30.15', 16='30.39', 17='29.99', 18='29.94', 19='30.23', 20='30.02', 21='29.6', 22='29.69', 23='29.62', 24='29.73', 25='29.74', 26='29.66', 27='29.59', 28='29.68', 29='29.7', 30='29.88', 31='<NA>'),\n",
       " Row(Number=100, Year=2015, Month=4, Measure='Min.Sea.Level.PressureIn', 01='29.79', 02='29.88', 03='29.65', 04='29.4', 05='30.09', 06='30.22', 07='30.21', 08='30.37', 09='30.3', 10='29.65', 11='29.72', 12='30.12', 13='30.14', 14='30.03', 15='30.06', 16='30.26', 17='29.86', 18='29.83', 19='30.09', 20='29.73', 21='29.53', 22='29.53', 23='29.54', 24='29.7', 25='29.68', 26='29.62', 27='29.53', 28='29.62', 29='29.59', 30='29.79', 31='<NA>'),\n",
       " Row(Number=101, Year=2015, Month=4, Measure='Max.VisibilityMiles', 01='10', 02='10', 03='10', 04='10', 05='10', 06='10', 07='10', 08='10', 09='6', 10='10', 11='10', 12='10', 13='10', 14='10', 15='10', 16='10', 17='10', 18='10', 19='10', 20='10', 21='10', 22='10', 23='10', 24='10', 25='10', 26='10', 27='10', 28='10', 29='10', 30='10', 31='<NA>'),\n",
       " Row(Number=102, Year=2015, Month=4, Measure='Mean.VisibilityMiles', 01='10', 02='10', 03='9', 04='6', 05='10', 06='10', 07='9', 08='8', 09='2', 10='4', 11='10', 12='10', 13='10', 14='10', 15='10', 16='10', 17='10', 18='10', 19='10', 20='6', 21='5', 22='10', 23='10', 24='10', 25='10', 26='10', 27='10', 28='10', 29='10', 30='10', 31='<NA>'),\n",
       " Row(Number=103, Year=2015, Month=4, Measure='Min.VisibilityMiles', 01='10', 02='10', 03='3', 04='0', 05='10', 06='10', 07='7', 08='4', 09='1', 10='0', 11='10', 12='10', 13='10', 14='10', 15='10', 16='10', 17='7', 18='10', 19='10', 20='1', 21='0', 22='10', 23='10', 24='3', 25='10', 26='10', 27='6', 28='4', 29='10', 30='10', 31='<NA>'),\n",
       " Row(Number=104, Year=2015, Month=4, Measure='Max.Wind.SpeedMPH', 01='21', 02='29', 03='24', 04='37', 05='28', 06='17', 07='15', 08='24', 09='25', 10='20', 11='30', 12='16', 13='24', 14='25', 15='25', 16='23', 17='22', 18='28', 19='18', 20='25', 21='20', 22='35', 23='25', 24='23', 25='18', 26='14', 27='22', 28='26', 29='16', 30='15', 31='<NA>'),\n",
       " Row(Number=105, Year=2015, Month=4, Measure='Mean.Wind.SpeedMPH', 01='10', 02='13', 03='12', 04='16', 05='15', 06='9', 07='8', 08='17', 09='17', 10='8', 11='17', 12='9', 13='12', 14='11', 15='12', 16='10', 17='13', 18='9', 19='11', 20='14', 21='10', 22='15', 23='16', 24='16', 25='11', 26='6', 27='12', 28='14', 29='9', 30='9', 31='<NA>'),\n",
       " Row(Number=106, Year=2015, Month=4, Measure='Max.Gust.SpeedMPH', 01='28', 02='37', 03='31', 04='49', 05='36', 06='21', 07='18', 08='30', 09='30', 10='25', 11='39', 12='22', 13='29', 14='35', 15='35', 16='26', 17='28', 18='35', 19='24', 20='32', 21='94', 22='41', 23='33', 24='36', 25='29', 26='20', 27='29', 28='35', 29='18', 30='18', 31='<NA>'),\n",
       " Row(Number=107, Year=2015, Month=4, Measure='PrecipitationIn', 01='0.00', 02='0.00', 03='0.03', 04='0.39', 05='0.00', 06='0.00', 07='0.03', 08='0.26', 09='0.09', 10='0.09', 11='0.00', 12='0.00', 13='0.00', 14='0.01', 15='0.00', 16='0.00', 17='0.06', 18='0.00', 19='0.00', 20='0.61', 21='0.54', 22='T', 23='0.00', 24='T', 25='0.00', 26='0.00', 27='0.10', 28='0.07', 29='0.00', 30='0.00', 31='<NA>'),\n",
       " Row(Number=108, Year=2015, Month=4, Measure='CloudCover', 01='1', 02='5', 03='8', 04='6', 05='4', 06='7', 07='8', 08='6', 09='8', 10='8', 11='1', 12='1', 13='3', 14='6', 15='1', 16='3', 17='6', 18='1', 19='3', 20='8', 21='6', 22='3', 23='5', 24='5', 25='3', 26='7', 27='7', 28='5', 29='5', 30='6', 31='<NA>'),\n",
       " Row(Number=109, Year=2015, Month=4, Measure='Events', 01=None, 02=None, 03='Rain', 04='Fog-Rain-Thunderstorm', 05='Rain', 06=None, 07=None, 08='Rain-Snow', 09='Rain', 10='Rain', 11='Rain', 12=None, 13=None, 14=None, 15='Rain', 16='Rain', 17=None, 18=None, 19=None, 20=None, 21='Fog-Rain-Thunderstorm', 22='Rain', 23='Snow', 24='Rain', 25=None, 26=None, 27=None, 28='Rain', 29='<NA>', 30=None, 31=None),\n",
       " Row(Number=110, Year=2015, Month=4, Measure='WindDirDegrees', 01='332', 02='223', 03='221', 04='269', 05='243', 06='70', 07='29', 08='52', 09='58', 10='114', 11='274', 12='258', 13='194', 14='245', 15='325', 16='130', 17='237', 18='14', 19='75', 20='107', 21='184', 22='186', 23='272', 24='292', 25='315', 26='344', 27='324', 28='8', 29='91', 30='89', 31='<NA>'),\n",
       " Row(Number=111, Year=2015, Month=5, Measure='Max.TemperatureF', 01='49', 02='50', 03='67', 04='84', 05='70', 06='73', 07='79', 08='71', 09='71', 10='89', 11='80', 12='87', 13='69', 14='69', 15='67', 16='71', 17='67', 18='58', 19='65', 20='66', 21='67', 22='76', 23='65', 24='83', 25='81', 26='87', 27='85', 28='86', 29='72', 30='88', 31='77'),\n",
       " Row(Number=112, Year=2015, Month=5, Measure='Mean.TemperatureF', 01='44', 02='45', 03='56', 04='67', 05='62', 06='63', 07='66', 08='59', 09='59', 10='74', 11='65', 12='68', 13='61', 14='59', 15='58', 16='63', 17='60', 18='54', 19='59', 20='59', 21='56', 22='64', 23='55', 24='67', 25='70', 26='76', 27='75', 28='75', 29='64', 30='73', 31='63'),\n",
       " Row(Number=113, Year=2015, Month=5, Measure='Min.TemperatureF', 01='39', 02='39', 03='45', 04='49', 05='54', 06='52', 07='53', 08='46', 09='46', 10='59', 11='50', 12='48', 13='53', 14='49', 15='48', 16='55', 17='52', 18='49', 19='52', 20='51', 21='45', 22='52', 23='44', 24='51', 25='58', 26='64', 27='65', 28='64', 29='55', 30='58', 31='48'),\n",
       " Row(Number=114, Year=2015, Month=5, Measure='Max.Dew.PointF', 01='41', 02='43', 03='48', 04='48', 05='59', 06='52', 07='45', 08='46', 09='60', 10='64', 11='65', 12='61', 13='43', 14='43', 15='49', 16='57', 17='59', 18='52', 19='63', 20='63', 21='41', 22='44', 23='32', 24='48', 25='57', 26='62', 27='66', 28='67', 29='61', 30='63', 31='69'),\n",
       " Row(Number=115, Year=2015, Month=5, Measure='MeanDew.PointF', 01='39', 02='40', 03='42', 04='43', 05='50', 06='40', 07='38', 08='43', 09='50', 10='61', 11='55', 12='52', 13='37', 14='34', 15='39', 16='50', 17='56', 18='48', 19='56', 20='41', 21='36', 22='34', 23='23', 24='39', 25='52', 26='58', 27='63', 28='62', 29='57', 30='60', 31='55'),\n",
       " Row(Number=116, Year=2015, Month=5, Measure='Min.DewpointF', 01='37', 02='37', 03='39', 04='37', 05='41', 06='31', 07='30', 08='40', 09='43', 10='55', 11='48', 12='48', 13='31', 14='23', 15='32', 16='37', 17='52', 18='43', 19='48', 20='30', 21='30', 22='24', 23='18', 24='33', 25='49', 26='53', 27='59', 28='55', 29='54', 30='56', 31='46'),\n",
       " Row(Number=117, Year=2015, Month=5, Measure='Max.Humidity', 01='92', 02='92', 03='76', 04='80', 05='93', 06='89', 07='47', 08='86', 09='97', 10='100', 11='93', 12='100', 13='59', 14='54', 15='64', 16='90', 17='100', 18='100', 19='100', 20='93', 21='61', 22='64', 23='50', 24='59', 25='73', 26='73', 27='87', 28='87', 29='100', 30='93', 31='100'),\n",
       " Row(Number=118, Year=2015, Month=5, Measure='Mean.Humidity', 01='82', 02='82', 03='61', 04='52', 05='66', 06='59', 07='34', 08='61', 09='82', 10='67', 11='78', 12='66', 13='44', 14='36', 15='47', 16='67', 17='89', 18='79', 19='92', 20='65', 21='44', 22='40', 23='34', 24='40', 25='54', 26='59', 27='71', 28='69', 29='80', 30='66', 31='85'),\n",
       " Row(Number=119, Year=2015, Month=5, Measure='Min.Humidity', 01='71', 02='71', 03='45', 04='23', 05='39', 06='29', 07='21', 08='35', 09='66', 10='34', 11='62', 12='31', 13='29', 14='17', 15='29', 16='44', 17='78', 18='57', 19='83', 20='36', 21='26', 22='16', 23='18', 24='20', 25='35', 26='44', 27='55', 28='51', 29='59', 30='39', 31='69'),\n",
       " Row(Number=120, Year=2015, Month=5, Measure='Max.Sea.Level.PressureIn', 01='30.02', 02='30.04', 03='30.15', 04='30.19', 05='30.22', 06='30.31', 07='30.21', 08='30.32', 09='30.37', 10='30.22', 11='30.14', 12='30.04', 13='30.22', 14='30.34', 15='30.31', 16='30.21', 17='30.22', 18='30.3', 19='30.09', 20='29.92', 21='29.98', 22='30.06', 23='30.33', 24='30.29', 25='30.24', 26='30.16', 27='30.16', 28='30.21', 29='30.31', 30='30.22', 31='30.28'),\n",
       " Row(Number=121, Year=2015, Month=5, Measure='Mean.Sea.Level.PressureIn', 01='30', 02='30', 03='30.06', 04='30.13', 05='30.16', 06='30.24', 07='30.14', 08='30.2', 09='30.3', 10='30.12', 11='30.1', 12='29.82', 13='29.97', 14='30.28', 15='30.25', 16='30.17', 17='30.13', 18='30.23', 19='29.9', 20='29.78', 21='29.91', 22='29.86', 23='30.26', 24='30.22', 25='30.2', 26='30.12', 27='30.12', 28='30.12', 29='30.27', 30='30.12', 31='30.14'),\n",
       " Row(Number=122, Year=2015, Month=5, Measure='Min.Sea.Level.PressureIn', 01='29.97', 02='29.96', 03='30.01', 04='30.06', 05='30.07', 06='30.16', 07='30.05', 08='30.09', 09='30.21', 10='30.02', 11='30.06', 12='29.62', 13='29.77', 14='30.24', 15='30.2', 16='30.12', 17='30.09', 18='30.12', 19='29.72', 20='29.7', 21='29.85', 22='29.78', 23='30.07', 24='30.14', 25='30.15', 26='30.09', 27='30.06', 28='30.04', 29='30.22', 30='30.03', 31='30.02'),\n",
       " Row(Number=123, Year=2015, Month=5, Measure='Max.VisibilityMiles', 01='10', 02='10', 03='10', 04='10', 05='10', 06='10', 07='10', 08='10', 09='10', 10='10', 11='10', 12='10', 13='10', 14='10', 15='10', 16='10', 17='10', 18='10', 19='10', 20='10', 21='10', 22='10', 23='10', 24='10', 25='10', 26='10', 27='10', 28='10', 29='10', 30='10', 31='10'),\n",
       " Row(Number=124, Year=2015, Month=5, Measure='Mean.VisibilityMiles', 01='10', 02='10', 03='10', 04='10', 05='10', 06='10', 07='10', 08='10', 09='9', 10='10', 11='9', 12='6', 13='10', 14='10', 15='10', 16='10', 17='8', 18='8', 19='8', 20='10', 21='10', 22='10', 23='10', 24='10', 25='10', 26='10', 27='10', 28='10', 29='8', 30='10', 31='8'),\n",
       " Row(Number=125, Year=2015, Month=5, Measure='Min.VisibilityMiles', 01='10', 02='10', 03='10', 04='10', 05='7', 06='10', 07='10', 08='9', 09='3', 10='7', 11='5', 12='0', 13='10', 14='10', 15='10', 16='10', 17='0', 18='0', 19='2', 20='7', 21='10', 22='10', 23='10', 24='10', 25='10', 26='10', 27='10', 28='10', 29='0', 30='10', 31='1'),\n",
       " Row(Number=126, Year=2015, Month=5, Measure='Max.Wind.SpeedMPH', 01='17', 02='13', 03='17', 04='30', 05='21', 06='20', 07='22', 08='22', 09='18', 10='22', 11='21', 12='25', 13='28', 14='22', 15='15', 16='17', 17='15', 18='16', 19='16', 20='26', 21='17', 22='26', 23='22', 24='23', 25='20', 26='23', 27='26', 28='23', 29='17', 30='26', 31='31'),\n",
       " Row(Number=127, Year=2015, Month=5, Measure='Mean.Wind.SpeedMPH', 01='8', 02='7', 03='9', 04='13', 05='10', 06='9', 07='11', 08='12', 09='8', 10='14', 11='10', 12='9', 13='14', 14='9', 15='6', 16='8', 17='8', 18='10', 19='10', 20='14', 21='10', 22='13', 23='13', 24='16', 25='11', 26='16', 27='16', 28='13', 29='8', 30='15', 31='14'),\n",
       " Row(Number=128, Year=2015, Month=5, Measure='Max.Gust.SpeedMPH', 01='22', 02='16', 03='21', 04='37', 05='25', 06='25', 07='28', 08='25', 09='23', 10='29', 11='24', 12='33', 13='35', 14='24', 15='18', 16='21', 17='18', 18='<NA>', 19='23', 20='35', 21='23', 22='37', 23='32', 24='30', 25='26', 26='28', 27='32', 28='29', 29='20', 30='33', 31='36'),\n",
       " Row(Number=129, Year=2015, Month=5, Measure='PrecipitationIn', 01='0.00', 02='0.00', 03='0.00', 04='0.00', 05='0.02', 06='0.00', 07='0.00', 08='0.00', 09='0.00', 10='0.00', 11='0.00', 12='0.02', 13='0.00', 14='0.00', 15='0.00', 16='T', 17='0.00', 18='0.00', 19='0.27', 20='0.00', 21='0.00', 22='T', 23='0.00', 24='0.00', 25='T', 26='0.00', 27='0.00', 28='T', 29='0.00', 30='0.00', 31='0.91'),\n",
       " Row(Number=130, Year=2015, Month=5, Measure='CloudCover', 01='6', 02='4', 03='4', 04='2', 05='5', 06='3', 07='1', 08='4', 09='7', 10='6', 11='6', 12='7', 13='1', 14='1', 15='5', 16='8', 17='3', 18='6', 19='8', 20='4', 21='4', 22='4', 23='0', 24='3', 25='6', 26='6', 27='4', 28='6', 29='4', 30='2', 31='7'),\n",
       " Row(Number=131, Year=2015, Month=5, Measure='Events', 01=None, 02=None, 03='Rain', 04=None, 05=None, 06=None, 07=None, 08='Rain', 09=None, 10=None, 11=None, 12=None, 13=None, 14=None, 15='Fog', 16='Rain', 17=None, 18=None, 19=None, 20=None, 21='Rain', 22='Rain', 23=None, 24=None, 25=None, 26=None, 27=None, 28='Rain', 29='Fog', 30='Rain', 31=None),\n",
       " Row(Number=132, Year=2015, Month=5, Measure='WindDirDegrees', 01='85', 02='103', 03='176', 04='206', 05='183', 06='122', 07='205', 08='35', 09='117', 10='221', 11='68', 12='75', 13='305', 14='281', 15='134', 16='194', 17='97', 18='72', 19='203', 20='288', 21='211', 22='264', 23='285', 24='237', 25='209', 26='217', 27='207', 28='216', 29='48', 30='205', 31='28'),\n",
       " Row(Number=133, Year=2015, Month=6, Measure='Max.TemperatureF', 01='49', 02='49', 03='56', 04='58', 05='59', 06='67', 07='67', 08='76', 09='78', 10='82', 11='88', 12='79', 13='85', 14='74', 15='63', 16='71', 17='69', 18='76', 19='86', 20='75', 21='76', 22='77', 23='88', 24='84', 25='81', 26='72', 27='68', 28='59', 29='75', 30='75', 31='<NA>'),\n",
       " Row(Number=134, Year=2015, Month=6, Measure='Mean.TemperatureF', 01='48', 02='48', 03='52', 04='54', 05='55', 06='60', 07='60', 08='65', 09='71', 10='72', 11='76', 12='72', 13='75', 14='68', 15='59', 16='64', 17='64', 18='67', 19='75', 20='67', 21='68', 22='69', 23='74', 24='76', 25='73', 26='66', 27='63', 28='56', 29='64', 30='68', 31='<NA>'),\n",
       " Row(Number=135, Year=2015, Month=6, Measure='Min.TemperatureF', 01='47', 02='46', 03='47', 04='49', 05='50', 06='52', 07='53', 08='53', 09='64', 10='62', 11='64', 12='65', 13='64', 14='62', 15='54', 16='56', 17='59', 18='57', 19='63', 20='58', 21='60', 22='61', 23='60', 24='67', 25='64', 26='59', 27='57', 28='52', 29='53', 30='60', 31='<NA>'),\n",
       " Row(Number=136, Year=2015, Month=6, Measure='Max.Dew.PointF', 01='48', 02='46', 03='48', 04='46', 05='51', 06='55', 07='47', 08='58', 09='65', 10='59', 11='66', 12='67', 13='68', 14='56', 15='56', 16='66', 17='56', 18='54', 19='63', 20='58', 21='72', 22='65', 23='72', 24='60', 25='61', 26='58', 27='58', 28='59', 29='61', 30='62', 31='<NA>'),\n",
       " Row(Number=137, Year=2015, Month=6, Measure='MeanDew.PointF', 01='47', 02='45', 03='45', 04='45', 05='48', 06='51', 07='40', 08='53', 09='63', 10='54', 11='58', 12='55', 13='59', 14='51', 15='53', 16='59', 17='46', 18='49', 19='57', 20='51', 21='65', 22='62', 23='66', 24='54', 25='55', 26='53', 27='55', 28='56', 29='56', 30='60', 31='<NA>'),\n",
       " Row(Number=138, Year=2015, Month=6, Measure='Min.DewpointF', 01='46', 02='44', 03='43', 04='42', 05='45', 06='39', 07='35', 08='42', 09='59', 10='47', 11='48', 12='49', 13='47', 14='45', 15='51', 16='56', 17='38', 18='45', 19='47', 20='46', 21='59', 22='60', 23='59', 24='46', 25='52', 26='46', 27='48', 28='51', 29='50', 30='57', 31='<NA>'),\n",
       " Row(Number=139, Year=2015, Month=6, Measure='Max.Humidity', 01='100', 02='100', 03='93', 04='86', 05='93', 06='100', 07='60', 08='89', 09='93', 10='78', 11='78', 12='79', 13='84', 14='73', 15='100', 16='100', 17='73', 18='72', 19='84', 20='78', 21='100', 22='100', 23='100', 24='73', 25='76', 26='84', 27='93', 28='100', 29='93', 30='97', 31='<NA>'),\n",
       " Row(Number=140, Year=2015, Month=6, Measure='Mean.Humidity', 01='97', 02='93', 03='82', 04='74', 05='83', 06='73', 07='47', 08='71', 09='81', 10='54', 11='56', 12='60', 13='56', 14='56', 15='84', 16='91', 17='55', 18='59', 19='64', 20='64', 21='91', 22='84', 23='80', 24='52', 25='56', 26='68', 27='76', 28='94', 29='80', 30='81', 31='<NA>'),\n",
       " Row(Number=141, Year=2015, Month=6, Measure='Min.Humidity', 01='93', 02='86', 03='71', 04='61', 05='72', 06='46', 07='34', 08='52', 09='69', 10='30', 11='33', 12='41', 13='27', 14='38', 15='67', 16='81', 17='37', 18='46', 19='43', 20='49', 21='82', 22='68', 23='60', 24='30', 25='36', 26='52', 27='58', 28='87', 29='66', 30='64', 31='<NA>'),\n",
       " Row(Number=142, Year=2015, Month=6, Measure='Max.Sea.Level.PressureIn', 01='30.27', 02='30.22', 03='30.31', 04='30.35', 05='30.24', 06='30.08', 07='30.23', 08='30.13', 09='29.79', 10='29.85', 11='29.91', 12='30.01', 13='29.99', 14='30.12', 15='30.14', 16='30.01', 17='30.18', 18='30.14', 19='30.05', 20='30.15', 21='29.96', 22='29.99', 23='29.96', 24='29.97', 25='30.03', 26='30.09', 27='30.19', 28='30.07', 29='29.94', 30='30.01', 31='<NA>'),\n",
       " Row(Number=143, Year=2015, Month=6, Measure='Mean.Sea.Level.PressureIn', 01='30.25', 02='30.19', 03='30.24', 04='30.3', 05='30.09', 06='29.94', 07='30.16', 08='29.95', 09='29.7', 10='29.8', 11='29.82', 12='29.92', 13='29.87', 14='30.06', 15='30.09', 16='29.88', 17='30.14', 18='30.04', 19='29.9', 20='30.1', 21='29.74', 22='29.85', 23='29.81', 24='29.9', 25='29.98', 26='30.01', 27='30.14', 28='29.8', 29='29.84', 30='29.97', 31='<NA>'),\n",
       " Row(Number=144, Year=2015, Month=6, Measure='Min.Sea.Level.PressureIn', 01='30.23', 02='30.17', 03='30.19', 04='30.24', 05='29.93', 06='29.85', 07='30.09', 08='29.82', 09='29.63', 10='29.71', 11='29.78', 12='29.77', 13='29.72', 14='29.99', 15='30.04', 16='29.78', 17='30.08', 18='29.93', 19='29.85', 20='30.03', 21='29.63', 22='29.76', 23='29.68', 24='29.78', 25='29.93', 26='29.94', 27='30.09', 28='29.69', 29='29.78', 30='29.94', 31='<NA>'),\n",
       " Row(Number=145, Year=2015, Month=6, Measure='Max.VisibilityMiles', 01='6', 02='10', 03='10', 04='10', 05='10', 06='10', 07='10', 08='10', 09='10', 10='10', 11='10', 12='10', 13='10', 14='10', 15='10', 16='10', 17='10', 18='10', 19='10', 20='10', 21='10', 22='10', 23='10', 24='10', 25='10', 26='10', 27='10', 28='7', 29='10', 30='10', 31='<NA>'),\n",
       " Row(Number=146, Year=2015, Month=6, Measure='Mean.VisibilityMiles', 01='3', 02='7', 03='10', 04='10', 05='10', 06='10', 07='10', 08='10', 09='10', 10='10', 11='9', 12='10', 13='10', 14='10', 15='5', 16='6', 17='10', 18='-1', 19='10', 20='10', 21='5', 22='5', 23='10', 24='10', 25='10', 26='10', 27='10', 28='3', 29='9', 30='10', 31='<NA>'),\n",
       " Row(Number=147, Year=2015, Month=6, Measure='Min.VisibilityMiles', 01='2', 02='2', 03='10', 04='10', 05='10', 06='2', 07='10', 08='10', 09='9', 10='10', 11='7', 12='10', 13='10', 14='10', 15='1', 16='0', 17='10', 18='10', 19='10', 20='10', 21='0', 22='0', 23='9', 24='10', 25='10', 26='10', 27='7', 28='1', 29='2', 30='10', 31='<NA>'),\n",
       " Row(Number=148, Year=2015, Month=6, Measure='Max.Wind.SpeedMPH', 01='21', 02='20', 03='14', 04='16', 05='20', 06='20', 07='21', 08='29', 09='23', 10='20', 11='22', 12='18', 13='21', 14='17', 15='21', 16='13', 17='23', 18='17', 19='20', 20='18', 21='17', 22='13', 23='28', 24='20', 25='15', 26='16', 27='38', 28='29', 29='15', 30='14', 31='<NA>'),\n",
       " Row(Number=149, Year=2015, Month=6, Measure='Mean.Wind.SpeedMPH', 01='14', 02='11', 03='7', 04='6', 05='8', 06='7', 07='11', 08='17', 09='13', 10='11', 11='14', 12='9', 13='9', 14='10', 15='9', 16='5', 17='10', 18='10', 19='10', 20='9', 21='6', 22='6', 23='12', 24='11', 25='7', 26='8', 27='8', 28='18', 29='7', 30='7', 31='<NA>'),\n",
       " Row(Number=150, Year=2015, Month=6, Measure='Max.Gust.SpeedMPH', 01='26', 02='26', 03='<NA>', 04='21', 05='22', 06='28', 07='23', 08='40', 09='26', 10='26', 11='29', 12='24', 13='26', 14='21', 15='23', 16='18', 17='28', 18='23', 19='26', 20='23', 21='22', 22='15', 23='33', 24='28', 25='21', 26='20', 27='0', 28='36', 29='21', 30='17', 31='<NA>'),\n",
       " Row(Number=151, Year=2015, Month=6, Measure='PrecipitationIn', 01='0.38', 02='0.74', 03='0.00', 04='0.00', 05='T', 06='0.09', 07='0.00', 08='T', 09='T', 10='0.00', 11='0.00', 12='0.00', 13='T', 14='0.00', 15='0.40', 16='T', 17='0.00', 18='0.00', 19='0.00', 20='0.04', 21='1.72', 22='0.00', 23='0.01', 24='0.00', 25='0.00', 26='T', 27='0.20', 28='1.43', 29='T', 30='0.00', 31='<NA>'),\n",
       " Row(Number=152, Year=2015, Month=6, Measure='CloudCover', 01='8', 02='8', 03='7', 04='5', 05='5', 06='5', 07='3', 08='6', 09='6', 10='3', 11='7', 12='6', 13='6', 14='5', 15='8', 16='7', 17='5', 18='5', 19='6', 20='5', 21='8', 22='6', 23='6', 24='2', 25='4', 26='5', 27='6', 28='8', 29='7', 30='4', 31='<NA>'),\n",
       " Row(Number=153, Year=2015, Month=6, Measure='Events', 01='Rain', 02='Rain', 03='Rain', 04=None, 05=None, 06=None, 07=None, 08='Rain', 09='Rain', 10=None, 11=None, 12=None, 13=None, 14=None, 15='Rain', 16='Rain', 17=None, 18=None, 19=None, 20=None, 21='Rain', 22='Fog', 23='Rain', 24='Rain', 25='Rain', 26=None, 27=None, 28='Rain', 29='<NA>', 30=None, 31=None),\n",
       " Row(Number=154, Year=2015, Month=6, Measure='WindDirDegrees', 01='43', 02='33', 03='90', 04='113', 05='106', 06='54', 07='76', 08='200', 09='199', 10='245', 11='248', 12='202', 13='2', 14='67', 15='113', 16='87', 17='111', 18='189', 19='272', 20='76', 21='92', 22='89', 23='201', 24='298', 25='292', 26='41', 27='108', 28='39', 29='216', 30='155', 31='<NA>'),\n",
       " Row(Number=155, Year=2015, Month=7, Measure='Max.TemperatureF', 01='82', 02='80', 03='76', 04='72', 05='83', 06='80', 07='84', 08='88', 09='69', 10='77', 11='83', 12='89', 13='77', 14='82', 15='82', 16='68', 17='75', 18='78', 19='90', 20='92', 21='81', 22='84', 23='82', 24='81', 25='69', 26='79', 27='86', 28='86', 29='92', 30='91', 31='89'),\n",
       " Row(Number=156, Year=2015, Month=7, Measure='Mean.TemperatureF', 01='72', 02='72', 03='70', 04='67', 05='72', 06='74', 07='75', 08='79', 09='66', 10='69', 11='76', 12='81', 13='72', 14='74', 15='75', 16='64', 17='68', 18='71', 19='81', 20='81', 21='76', 22='77', 23='75', 24='74', 25='66', 26='71', 27='77', 28='78', 29='82', 30='83', 31='81'),\n",
       " Row(Number=157, Year=2015, Month=7, Measure='Min.TemperatureF', 01='62', 02='64', 03='63', 04='62', 05='61', 06='68', 07='65', 08='69', 09='63', 10='60', 11='68', 12='72', 13='67', 14='65', 15='67', 16='59', 17='60', 18='64', 19='71', 20='70', 21='70', 22='69', 23='67', 24='66', 25='62', 26='63', 27='68', 28='70', 29='71', 30='74', 31='73'),\n",
       " Row(Number=158, Year=2015, Month=7, Measure='Max.Dew.PointF', 01='68', 02='60', 03='56', 04='62', 05='61', 06='66', 07='72', 08='71', 09='60', 10='66', 11='61', 12='67', 13='67', 14='70', 15='72', 16='55', 17='61', 18='68', 19='74', 20='73', 21='68', 22='66', 23='58', 24='61', 25='61', 26='68', 27='69', 28='70', 29='69', 30='73', 31='71'),\n",
       " Row(Number=159, Year=2015, Month=7, Measure='MeanDew.PointF', 01='64', 02='56', 03='53', 04='58', 05='59', 06='63', 07='68', 08='67', 09='57', 10='61', 11='57', 12='61', 13='65', 14='67', 15='68', 16='51', 17='58', 18='65', 19='71', 20='66', 21='63', 22='55', 23='54', 24='56', 25='59', 26='64', 27='67', 28='69', 29='67', 30='70', 31='59'),\n",
       " Row(Number=160, Year=2015, Month=7, Measure='Min.DewpointF', 01='60', 02='54', 03='49', 04='55', 05='57', 06='59', 07='63', 08='55', 09='55', 10='55', 11='54', 12='57', 13='61', 14='60', 15='57', 16='48', 17='53', 18='61', 19='68', 20='52', 21='59', 22='48', 23='52', 24='51', 25='57', 26='60', 27='65', 28='66', 29='63', 30='67', 31='52'),\n",
       " Row(Number=161, Year=2015, Month=7, Measure='Max.Humidity', 01='100', 02='78', 03='73', 04='87', 05='90', 06='84', 07='93', 08='93', 09='93', 10='100', 11='61', 12='67', 13='93', 14='93', 15='100', 16='78', 17='84', 18='93', 19='93', 20='93', 21='79', 22='84', 23='68', 24='81', 25='93', 26='93', 27='93', 28='97', 29='90', 30='93', 31='93'),\n",
       " Row(Number=162, Year=2015, Month=7, Measure='Mean.Humidity', 01='78', 02='60', 03='56', 04='75', 05='67', 06='69', 07='77', 08='68', 09='77', 10='74', 11='49', 12='54', 13='81', 14='72', 15='87', 16='65', 17='72', 18='81', 19='73', 20='62', 21='66', 22='58', 23='52', 24='60', 25='81', 26='79', 27='74', 28='80', 29='66', 30='73', 31='61'),\n",
       " Row(Number=163, Year=2015, Month=7, Measure='Min.Humidity', 01='55', 02='42', 03='38', 04='63', 05='43', 06='54', 07='61', 08='42', 09='61', 10='47', 11='37', 12='40', 13='68', 14='51', 15='73', 16='52', 17='60', 18='69', 19='52', 20='30', 21='52', 22='31', 23='36', 24='39', 25='68', 26='64', 27='55', 28='63', 29='41', 30='52', 31='29'),\n",
       " Row(Number=164, Year=2015, Month=7, Measure='Max.Sea.Level.PressureIn', 01='29.93', 02='29.89', 03='30', 04='30.01', 05='30.13', 06='30.17', 07='30.12', 08='30', 09='30.03', 10='29.96', 11='30.04', 12='30', 13='29.95', 14='29.85', 15='29.89', 16='30.07', 17='30.12', 18='30.04', 19='29.87', 20='29.71', 21='29.66', 22='29.81', 23='29.88', 24='29.94', 25='30.06', 26='30.05', 27='30.03', 28='29.99', 29='29.96', 30='29.89', 31='29.81'),\n",
       " Row(Number=165, Year=2015, Month=7, Measure='Mean.Sea.Level.PressureIn', 01='29.78', 02='29.86', 03='29.94', 04='29.99', 05='30.05', 06='30.13', 07='30.05', 08='29.9', 09='29.98', 10='29.9', 11='30.01', 12='29.95', 13='29.91', 14='29.71', 15='29.67', 16='30.02', 17='30.08', 18='29.95', 19='29.8', 20='29.66', 21='29.61', 22='29.67', 23='29.84', 24='29.9', 25='30.02', 26='30.01', 27='30', 28='29.96', 29='29.92', 30='29.82', 31='29.78'),\n",
       " Row(Number=166, Year=2015, Month=7, Measure='Min.Sea.Level.PressureIn', 01='29.68', 02='29.81', 03='29.87', 04='29.95', 05='29.99', 06='30.09', 07='29.92', 08='29.87', 09='29.87', 10='29.83', 11='29.96', 12='29.9', 13='29.86', 14='29.62', 15='29.58', 16='29.91', 17='30.03', 18='29.86', 19='29.7', 20='29.63', 21='29.55', 22='29.57', 23='29.82', 24='29.88', 25='29.94', 26='29.96', 27='29.97', 28='29.93', 29='29.87', 30='29.75', 31='29.75'),\n",
       " Row(Number=167, Year=2015, Month=7, Measure='Max.VisibilityMiles', 01='10', 02='10', 03='10', 04='10', 05='10', 06='10', 07='10', 08='10', 09='10', 10='10', 11='10', 12='10', 13='10', 14='10', 15='10', 16='10', 17='10', 18='10', 19='10', 20='10', 21='10', 22='10', 23='10', 24='10', 25='10', 26='10', 27='10', 28='10', 29='10', 30='10', 31='10'),\n",
       " Row(Number=168, Year=2015, Month=7, Measure='Mean.VisibilityMiles', 01='8', 02='10', 03='10', 04='10', 05='9', 06='10', 07='10', 08='9', 09='10', 10='7', 11='10', 12='10', 13='10', 14='10', 15='10', 16='10', 17='10', 18='10', 19='10', 20='10', 21='10', 22='10', 23='10', 24='10', 25='10', 26='10', 27='10', 28='10', 29='10', 30='10', 31='10'),\n",
       " Row(Number=169, Year=2015, Month=7, Measure='Min.VisibilityMiles', 01='0', 02='10', 03='10', 04='10', 05='7', 06='8', 07='10', 08='6', 09='5', 10='2', 11='10', 12='10', 13='7', 14='3', 15='7', 16='10', 17='10', 18='2', 19='7', 20='7', 21='10', 22='10', 23='10', 24='7', 25='10', 26='10', 27='10', 28='10', 29='10', 30='7', 31='10'),\n",
       " Row(Number=170, Year=2015, Month=7, Measure='Max.Wind.SpeedMPH', 01='22', 02='16', 03='15', 04='10', 05='13', 06='15', 07='23', 08='20', 09='15', 10='15', 11='13', 12='15', 13='15', 14='21', 15='20', 16='18', 17='17', 18='21', 19='20', 20='20', 21='16', 22='22', 23='14', 24='20', 25='16', 26='14', 27='18', 28='16', 29='16', 30='25', 31='23'),\n",
       " Row(Number=171, Year=2015, Month=7, Measure='Mean.Wind.SpeedMPH', 01='10', 02='9', 03='9', 04='4', 05='8', 06='7', 07='10', 08='11', 09='8', 10='8', 11='8', 12='9', 13='6', 14='8', 15='7', 16='11', 17='9', 18='11', 19='9', 20='9', 21='7', 22='12', 23='7', 24='9', 25='9', 26='8', 27='8', 28='8', 29='7', 30='14', 31='11'),\n",
       " Row(Number=172, Year=2015, Month=7, Measure='Max.Gust.SpeedMPH', 01='28', 02='23', 03='17', 04='12', 05='22', 06='18', 07='29', 08='25', 09='18', 10='17', 11='17', 12='23', 13='17', 14='24', 15='26', 16='25', 17='25', 18='28', 19='25', 20='28', 21='24', 22='29', 23='21', 24='28', 25='20', 26='22', 27='24', 28='18', 29='20', 30='33', 31='31'),\n",
       " Row(Number=173, Year=2015, Month=7, Measure='PrecipitationIn', 01='0.50', 02='0.00', 03='0.00', 04='T', 05='0.00', 06='0.00', 07='0.02', 08='T', 09='0.15', 10='1.12', 11='0.00', 12='0.00', 13='0.00', 14='0.03', 15='T', 16='0.00', 17='T', 18='0.14', 19='T', 20='T', 21='T', 22='0.00', 23='0.00', 24='0.01', 25='0.00', 26='T', 27='0.06', 28='0.00', 29='0.00', 30='0.02', 31='0.00'),\n",
       " Row(Number=174, Year=2015, Month=7, Measure='CloudCover', 01='6', 02='4', 03='2', 04='6', 05='1', 06='3', 07='5', 08='5', 09='6', 10='6', 11='1', 12='4', 13='6', 14='5', 15='7', 16='3', 17='5', 18='7', 19='6', 20='4', 21='5', 22='3', 23='4', 24='4', 25='5', 26='7', 27='5', 28='3', 29='3', 30='5', 31='2'),\n",
       " Row(Number=175, Year=2015, Month=7, Measure='Events', 01='Rain-Thunderstorm', 02=None, 03='Rain', 04=None, 05=None, 06=None, 07=None, 08='Rain', 09='Rain', 10='Rain', 11='Rain', 12=None, 13=None, 14=None, 15='Rain', 16='Rain', 17='Rain', 18=None, 19=None, 20=None, 21='Rain', 22='Rain', 23='Rain', 24=None, 25=None, 26=None, 27=None, 28='Rain', 29=None, 30=None, 31=None),\n",
       " Row(Number=176, Year=2015, Month=7, Measure='WindDirDegrees', 01='164', 02='265', 03='63', 04='126', 05='252', 06='165', 07='160', 08='272', 09='67', 10='85', 11='282', 12='249', 13='68', 14='144', 15='99', 16='59', 17='151', 18='200', 19='206', 20='272', 21='256', 22='309', 23='303', 24='320', 25='50', 26='181', 27='200', 28='181', 29='190', 30='223', 31='263'),\n",
       " Row(Number=177, Year=2015, Month=8, Measure='Max.TemperatureF', 01='90', 02='88', 03='90', 04='89', 05='85', 06='82', 07='73', 08='76', 09='73', 10='83', 11='72', 12='85', 13='82', 14='86', 15='91', 16='90', 17='91', 18='87', 19='88', 20='78', 21='83', 22='73', 23='71', 24='75', 25='81', 26='85', 27='82', 28='75', 29='82', 30='88', 31='90'),\n",
       " Row(Number=178, Year=2015, Month=8, Measure='Mean.TemperatureF', 01='79', 02='78', 03='79', 04='78', 05='75', 06='74', 07='69', 08='69', 09='68', 10='73', 11='68', 12='77', 13='74', 14='75', 15='80', 16='79', 17='81', 18='79', 19='80', 20='73', 21='75', 22='70', 23='69', 24='72', 25='74', 26='77', 27='74', 28='70', 29='73', 30='79', 31='81'),\n",
       " Row(Number=179, Year=2015, Month=8, Measure='Min.TemperatureF', 01='68', 02='68', 03='68', 04='66', 05='65', 06='65', 07='64', 08='61', 09='62', 10='63', 11='64', 12='68', 13='66', 14='63', 15='68', 16='67', 17='71', 18='71', 19='71', 20='68', 21='67', 22='67', 23='67', 24='68', 25='67', 26='69', 27='65', 28='64', 29='63', 30='69', 31='71'),\n",
       " Row(Number=180, Year=2015, Month=8, Measure='Max.Dew.PointF', 01='61', 02='63', 03='68', 04='72', 05='65', 06='55', 07='61', 08='61', 09='61', 10='62', 11='70', 12='70', 13='62', 14='61', 15='69', 16='68', 17='71', 18='71', 19='70', 20='70', 21='75', 22='70', 23='70', 24='69', 25='72', 26='70', 27='56', 28='62', 29='58', 30='65', 31='66'),\n",
       " Row(Number=181, Year=2015, Month=8, Measure='MeanDew.PointF', 01='58', 02='54', 03='64', 04='66', 05='57', 06='53', 07='57', 08='57', 09='59', 10='59', 11='67', 12='63', 13='59', 14='57', 15='63', 16='66', 17='67', 18='69', 19='68', 20='69', 21='70', 22='66', 23='68', 24='68', 25='69', 26='64', 27='54', 28='56', 29='55', 30='61', 31='63'),\n",
       " Row(Number=182, Year=2015, Month=8, Measure='Min.DewpointF', 01='55', 02='51', 03='58', 04='62', 05='51', 06='50', 07='54', 08='54', 09='57', 10='56', 11='62', 12='56', 13='57', 14='52', 15='55', 16='64', 17='64', 18='65', 19='64', 20='68', 21='66', 22='64', 23='66', 24='67', 25='66', 26='56', 27='52', 28='53', 29='53', 30='58', 31='60'),\n",
       " Row(Number=183, Year=2015, Month=8, Measure='Max.Humidity', 01='66', 02='73', 03='100', 04='90', 05='81', 06='67', 07='87', 08='87', 09='93', 10='87', 11='100', 12='100', 13='78', 14='78', 15='87', 16='93', 17='84', 18='90', 19='93', 20='100', 21='100', 22='100', 23='100', 24='100', 25='100', 26='100', 27='68', 28='73', 29='78', 30='78', 31='79'),\n",
       " Row(Number=184, Year=2015, Month=8, Measure='Mean.Humidity', 01='50', 02='52', 03='67', 04='68', 05='58', 06='51', 07='70', 08='68', 09='80', 10='67', 11='94', 12='70', 13='62', 14='57', 15='64', 16='70', 17='64', 18='76', 19='72', 20='88', 21='87', 22='90', 23='97', 24='92', 25='81', 26='71', 27='54', 28='63', 29='59', 30='58', 31='60'),\n",
       " Row(Number=185, Year=2015, Month=8, Measure='Min.Humidity', 01='34', 02='30', 03='34', 04='46', 05='34', 06='35', 07='53', 08='49', 09='66', 10='47', 11='87', 12='40', 13='45', 14='36', 15='41', 16='46', 17='44', 18='61', 19='51', 20='76', 21='74', 22='79', 23='93', 24='84', 25='62', 26='42', 27='39', 28='53', 29='39', 30='37', 31='40'),\n",
       " Row(Number=186, Year=2015, Month=8, Measure='Max.Sea.Level.PressureIn', 01='29.82', 02='29.9', 03='29.87', 04='29.88', 05='29.89', 06='29.93', 07='29.97', 08='30.02', 09='30.05', 10='30.06', 11='30.01', 12='29.88', 13='30.09', 14='30.14', 15='30.11', 16='30.09', 17='30.08', 18='30.03', 19='30.1', 20='30.12', 21='30.05', 22='30.11', 23='30.06', 24='29.96', 25='29.91', 26='29.95', 27='30.07', 28='30.17', 29='30.19', 30='30.09', 31='30'),\n",
       " Row(Number=187, Year=2015, Month=8, Measure='Mean.Sea.Level.PressureIn', 01='29.75', 02='29.86', 03='29.81', 04='29.83', 05='29.85', 06='29.9', 07='29.95', 08='29.99', 09='30.03', 10='30.02', 11='29.84', 12='29.76', 13='29.98', 14='30.11', 15='30.07', 16='30.07', 17='30.04', 18='30.01', 19='30.06', 20='30.09', 21='30.02', 22='30.08', 23='30.01', 24='29.92', 25='29.89', 26='29.89', 27='29.98', 28='30.13', 29='30.14', 30='30.03', 31='29.93'),\n",
       " Row(Number=188, Year=2015, Month=8, Measure='Min.Sea.Level.PressureIn', 01='29.7', 02='29.82', 03='29.75', 04='29.76', 05='29.79', 06='29.86', 07='29.92', 08='29.95', 09='30', 10='29.97', 11='29.73', 12='29.71', 13='29.89', 14='30.06', 15='30.01', 16='30.04', 17='29.99', 18='29.97', 19='30.03', 20='30.04', 21='29.98', 22='30.03', 23='29.96', 24='29.87', 25='29.83', 26='29.86', 27='29.94', 28='30.08', 29='30.08', 30='29.98', 31='29.86'),\n",
       " Row(Number=189, Year=2015, Month=8, Measure='Max.VisibilityMiles', 01='10', 02='10', 03='10', 04='10', 05='10', 06='10', 07='10', 08='10', 09='10', 10='10', 11='10', 12='10', 13='10', 14='10', 15='10', 16='10', 17='10', 18='10', 19='10', 20='10', 21='10', 22='10', 23='10', 24='10', 25='10', 26='10', 27='10', 28='10', 29='10', 30='10', 31='10'),\n",
       " Row(Number=190, Year=2015, Month=8, Measure='Mean.VisibilityMiles', 01='10', 02='10', 03='10', 04='8', 05='10', 06='10', 07='10', 08='10', 09='10', 10='10', 11='7', 12='10', 13='10', 14='10', 15='10', 16='10', 17='10', 18='8', 19='10', 20='9', 21='4', 22='9', 23='3', 24='7', 25='6', 26='10', 27='10', 28='10', 29='10', 30='10', 31='10'),\n",
       " Row(Number=191, Year=2015, Month=8, Measure='Min.VisibilityMiles', 01='10', 02='10', 03='7', 04='0', 05='10', 06='10', 07='10', 08='10', 09='10', 10='10', 11='1', 12='10', 13='10', 14='10', 15='8', 16='10', 17='10', 18='0', 19='7', 20='0', 21='0', 22='0', 23='0', 24='1', 25='0', 26='6', 27='10', 28='10', 29='10', 30='10', 31='10'),\n",
       " Row(Number=192, Year=2015, Month=8, Measure='Max.Wind.SpeedMPH', 01='26', 02='20', 03='23', 04='38', 05='23', 06='18', 07='16', 08='14', 09='20', 10='21', 11='21', 12='15', 13='17', 14='17', 15='20', 16='17', 17='15', 18='29', 19='18', 20='22', 21='14', 22='15', 23='14', 24='14', 25='17', 26='16', 27='17', 28='14', 29='16', 30='17', 31='22'),\n",
       " Row(Number=193, Year=2015, Month=8, Measure='Mean.Wind.SpeedMPH', 01='10', 02='11', 03='13', 04='9', 05='11', 06='9', 07='8', 08='6', 09='9', 10='10', 11='10', 12='9', 13='8', 14='9', 15='8', 16='7', 17='8', 18='8', 19='9', 20='11', 21='6', 22='7', 23='8', 24='6', 25='9', 26='8', 27='10', 28='8', 29='7', 30='9', 31='11'),\n",
       " Row(Number=194, Year=2015, Month=8, Measure='Max.Gust.SpeedMPH', 01='35', 02='26', 03='30', 04='51', 05='29', 06='22', 07='20', 08='<NA>', 09='26', 10='24', 11='24', 12='21', 13='18', 14='23', 15='25', 16='22', 17='21', 18='38', 19='22', 20='25', 21='20', 22='18', 23='25', 24='16', 25='21', 26='22', 27='22', 28='18', 29='22', 30='26', 31='32'),\n",
       " Row(Number=195, Year=2015, Month=8, Measure='PrecipitationIn', 01='T', 02='0.00', 03='0.00', 04='0.49', 05='0.00', 06='0.00', 07='0.00', 08='0.00', 09='0.00', 10='0.00', 11='0.83', 12='0.00', 13='0.00', 14='0.00', 15='0.08', 16='0.00', 17='0.00', 18='0.14', 19='0.00', 20='0.00', 21='0.63', 22='T', 23='0.02', 24='T', 25='0.00', 26='T', 27='0.00', 28='0.00', 29='0.00', 30='0.00', 31='0.00'),\n",
       " Row(Number=196, Year=2015, Month=8, Measure='CloudCover', 01='3', 02='1', 03='2', 04='5', 05='3', 06='3', 07='2', 08='4', 09='5', 10='3', 11='7', 12='4', 13='2', 14='1', 15='6', 16='3', 17='2', 18='4', 19='3', 20='4', 21='7', 22='7', 23='8', 24='7', 25='6', 26='4', 27='2', 28='2', 29='3', 30='5', 31='2'),\n",
       " Row(Number=197, Year=2015, Month=8, Measure='Events', 01='Rain', 02=None, 03='Thunderstorm', 04='Fog-Rain-Hail-Thunderstorm', 05=None, 06=None, 07=None, 08='Rain', 09=None, 10=None, 11=None, 12=None, 13=None, 14=None, 15='Rain-Thunderstorm', 16='Rain-Thunderstorm', 17=None, 18=None, 19=None, 20=None, 21='Fog-Rain-Thunderstorm', 22='Fog', 23='Rain', 24='Fog', 25='Rain', 26=None, 27=None, 28=None, 29=None, 30=None, 31=None),\n",
       " Row(Number=198, Year=2015, Month=8, Measure='WindDirDegrees', 01='251', 02='254', 03='201', 04='222', 05='260', 06='278', 07='37', 08='45', 09='36', 10='212', 11='171', 12='257', 13='296', 14='225', 15='192', 16='221', 17='209', 18='192', 19='204', 20='115', 21='91', 22='53', 23='22', 24='89', 25='133', 26='246', 27='289', 28='188', 29='242', 30='254', 31='265'),\n",
       " Row(Number=199, Year=2015, Month=9, Measure='Max.TemperatureF', 01='79', 02='91', 03='82', 04='72', 05='73', 06='82', 07='93', 08='96', 09='93', 10='77', 11='73', 12='71', 13='66', 14='72', 15='84', 16='81', 17='89', 18='85', 19='79', 20='75', 21='66', 22='68', 23='68', 24='74', 25='66', 26='63', 27='64', 28='78', 29='84', 30='78', 31='<NA>'),\n",
       " Row(Number=200, Year=2015, Month=9, Measure='Mean.TemperatureF', 01='74', 02='79', 03='76', 04='67', 05='66', 06='72', 07='80', 08='84', 09='83', 10='71', 11='68', 12='66', 13='65', 14='65', 15='73', 16='73', 17='77', 18='75', 19='71', 20='66', 21='60', 22='62', 23='61', 24='66', 25='61', 26='57', 27='56', 28='67', 29='75', 30='68', 31='<NA>'),\n",
       " Row(Number=201, Year=2015, Month=9, Measure='Min.TemperatureF', 01='69', 02='66', 03='70', 04='62', 05='58', 06='61', 07='66', 08='72', 09='72', 10='64', 11='63', 12='60', 13='63', 14='57', 15='62', 16='65', 17='64', 18='65', 19='62', 20='57', 21='53', 22='56', 23='54', 24='58', 25='55', 26='50', 27='48', 28='56', 29='65', 30='57', 31='<NA>'),\n",
       " Row(Number=202, Year=2015, Month=9, Measure='Max.Dew.PointF', 01='63', 02='68', 03='68', 04='69', 05='58', 06='63', 07='65', 08='72', 09='71', 10='71', 11='63', 12='63', 13='65', 14='63', 15='58', 16='64', 17='65', 18='62', 19='67', 20='66', 21='48', 22='57', 23='54', 24='54', 25='55', 26='49', 27='57', 28='66', 29='70', 30='73', 31='<NA>'),\n",
       " Row(Number=203, Year=2015, Month=9, Measure='MeanDew.PointF', 01='62', 02='63', 03='66', 04='60', 05='54', 06='59', 07='59', 08='67', 09='68', 10='65', 11='61', 12='61', 13='62', 14='54', 15='54', 16='59', 17='59', 18='60', 19='62', 20='55', 21='46', 22='53', 23='49', 24='52', 25='50', 26='45', 27='49', 28='60', 29='68', 30='67', 31='<NA>'),\n",
       " Row(Number=204, Year=2015, Month=9, Measure='Min.DewpointF', 01='59', 02='59', 03='65', 04='55', 05='49', 06='57', 07='51', 08='64', 09='62', 10='61', 11='59', 12='59', 13='59', 14='51', 15='51', 16='57', 17='53', 18='57', 19='57', 20='46', 21='45', 22='48', 23='42', 24='48', 25='47', 26='39', 27='42', 28='53', 29='64', 30='51', 31='<NA>'),\n",
       " Row(Number=205, Year=2015, Month=9, Measure='Max.Humidity', 01='78', 02='87', 03='84', 04='93', 05='93', 06='90', 07='73', 08='84', 09='84', 10='93', 11='100', 12='100', 13='100', 14='90', 15='67', 16='78', 17='84', 18='87', 19='100', 20='90', 21='72', 22='93', 23='93', 24='78', 25='86', 26='77', 27='93', 28='93', 29='100', 30='100', 31='<NA>'),\n",
       " Row(Number=206, Year=2015, Month=9, Measure='Mean.Humidity', 01='65', 02='63', 03='73', 04='78', 05='70', 06='69', 07='55', 08='63', 09='60', 10='81', 11='84', 12='87', 13='94', 14='70', 15='52', 16='62', 17='58', 18='64', 19='74', 20='63', 21='60', 22='76', 23='68', 24='62', 25='72', 26='64', 27='75', 28='75', 29='79', 30='89', 31='<NA>'),\n",
       " Row(Number=207, Year=2015, Month=9, Measure='Min.Humidity', 01='52', 02='38', 03='62', 04='63', 05='47', 06='48', 07='36', 08='41', 09='36', 10='69', 11='68', 12='73', 13='87', 14='49', 15='36', 16='45', 17='31', 18='40', 19='48', 20='36', 21='48', 22='58', 23='42', 24='46', 25='58', 26='51', 27='57', 28='56', 29='58', 30='78', 31='<NA>'),\n",
       " Row(Number=208, Year=2015, Month=9, Measure='Max.Sea.Level.PressureIn', 01='30.06', 02='30.04', 03='29.94', 04='30.27', 05='30.31', 06='30.22', 07='30.1', 08='29.97', 09='29.94', 10='29.91', 11='29.82', 12='29.89', 13='29.79', 14='30.07', 15='30.25', 16='30.32', 17='30.19', 18='30.04', 19='30', 20='30.13', 21='30.3', 22='30.34', 23='30.27', 24='30.39', 25='30.44', 26='30.53', 27='30.52', 28='30.34', 29='30.14', 30='29.96', 31='<NA>'),\n",
       " Row(Number=209, Year=2015, Month=9, Measure='Mean.Sea.Level.PressureIn', 01='30.02', 02='29.94', 03='29.87', 04='30.14', 05='30.26', 06='30.16', 07='30', 08='29.94', 09='29.85', 10='29.86', 11='29.75', 12='29.84', 13='29.75', 14='29.88', 15='30.2', 16='30.26', 17='30.1', 18='30', 19='29.95', 20='29.96', 21='30.24', 22='30.31', 23='30.24', 24='30.31', 25='30.4', 26='30.49', 27='30.44', 28='30.23', 29='30.06', 30='29.77', 31='<NA>'),\n",
       " Row(Number=210, Year=2015, Month=9, Measure='Min.Sea.Level.PressureIn', 01='29.96', 02='29.85', 03='29.83', 04='29.94', 05='30.22', 06='30.1', 07='29.92', 08='29.9', 09='29.78', 10='29.79', 11='29.69', 12='29.79', 13='29.71', 14='29.72', 15='30.09', 16='30.2', 17='30.02', 18='29.95', 19='29.87', 20='29.83', 21='30.14', 22='30.28', 23='30.21', 24='30.22', 25='30.38', 26='30.4', 27='30.35', 28='30.15', 29='29.98', 30='29.63', 31='<NA>'),\n",
       " Row(Number=211, Year=2015, Month=9, Measure='Max.VisibilityMiles', 01='10', 02='10', 03='10', 04='10', 05='10', 06='10', 07='10', 08='10', 09='10', 10='10', 11='10', 12='10', 13='10', 14='10', 15='10', 16='10', 17='10', 18='10', 19='10', 20='10', 21='10', 22='10', 23='10', 24='10', 25='10', 26='10', 27='10', 28='10', 29='10', 30='10', 31='<NA>'),\n",
       " Row(Number=212, Year=2015, Month=9, Measure='Mean.VisibilityMiles', 01='10', 02='10', 03='9', 04='9', 05='10', 06='10', 07='10', 08='9', 09='10', 10='10', 11='8', 12='10', 13='6', 14='10', 15='10', 16='10', 17='10', 18='10', 19='8', 20='10', 21='10', 22='10', 23='10', 24='10', 25='10', 26='10', 27='10', 28='10', 29='7', 30='6', 31='<NA>'),\n",
       " Row(Number=213, Year=2015, Month=9, Measure='Min.VisibilityMiles', 01='10', 02='9', 03='7', 04='5', 05='10', 06='10', 07='10', 08='6', 09='10', 10='4', 11='2', 12='6', 13='0', 14='10', 15='10', 16='10', 17='10', 18='10', 19='1', 20='10', 21='10', 22='10', 23='10', 24='10', 25='10', 26='10', 27='10', 28='10', 29='0', 30='0', 31='<NA>'),\n",
       " Row(Number=214, Year=2015, Month=9, Measure='Max.Wind.SpeedMPH', 01='15', 02='15', 03='12', 04='23', 05='14', 06='18', 07='21', 08='21', 09='22', 10='21', 11='25', 12='16', 13='20', 14='24', 15='16', 16='13', 17='14', 18='17', 19='17', 20='18', 21='20', 22='16', 23='10', 24='16', 25='17', 26='20', 27='15', 28='16', 29='21', 30='32', 31='<NA>'),\n",
       " Row(Number=215, Year=2015, Month=9, Measure='Mean.Wind.SpeedMPH', 01='9', 02='9', 03='6', 04='11', 05='7', 06='10', 07='12', 08='7', 09='13', 10='11', 11='10', 12='7', 13='10', 14='15', 15='11', 16='7', 17='7', 18='8', 19='10', 20='12', 21='11', 22='9', 23='6', 24='9', 25='9', 26='10', 27='7', 28='7', 29='9', 30='13', 31='<NA>'),\n",
       " Row(Number=216, Year=2015, Month=9, Measure='Max.Gust.SpeedMPH', 01='<NA>', 02='21', 03='14', 04='32', 05='16', 06='23', 07='25', 08='24', 09='28', 10='26', 11='33', 12='17', 13='23', 14='36', 15='22', 16='21', 17='20', 18='22', 19='21', 20='24', 21='24', 22='20', 23='15', 24='20', 25='21', 26='28', 27='18', 28='20', 29='25', 30='38', 31='<NA>'),\n",
       " Row(Number=217, Year=2015, Month=9, Measure='PrecipitationIn', 01='0.00', 02='0.00', 03='0.01', 04='T', 05='0.00', 06='0.00', 07='0.00', 08='0.20', 09='0.00', 10='0.17', 11='0.66', 12='0.01', 13='0.38', 14='0.00', 15='0.00', 16='0.00', 17='0.00', 18='0.00', 19='0.00', 20='T', 21='0.00', 22='0.00', 23='0.00', 24='0.00', 25='0.00', 26='0.00', 27='0.00', 28='0.00', 29='0.04', 30='2.46', 31='<NA>'),\n",
       " Row(Number=218, Year=2015, Month=9, Measure='CloudCover', 01='1', 02='0', 03='4', 04='6', 05='1', 06='1', 07='1', 08='2', 09='3', 10='7', 11='7', 12='6', 13='8', 14='3', 15='0', 16='1', 17='1', 18='1', 19='4', 20='4', 21='3', 22='6', 23='2', 24='1', 25='5', 26='4', 27='2', 28='4', 29='7', 30='8', 31='<NA>'),\n",
       " Row(Number=219, Year=2015, Month=9, Measure='Events', 01=None, 02=None, 03='Rain-Thunderstorm', 04='Rain', 05=None, 06=None, 07=None, 08='Rain', 09='Rain', 10='Rain', 11='Rain', 12=None, 13=None, 14=None, 15=None, 16=None, 17=None, 18=None, 19=None, 20=None, 21=None, 22=None, 23=None, 24=None, 25=None, 26=None, 27=None, 28='Fog-Rain', 29='Fog-Rain', 30='<NA>', 31=None),\n",
       " Row(Number=220, Year=2015, Month=9, Measure='WindDirDegrees', 01='54', 02='231', 03='91', 04='47', 05='94', 06='190', 07='231', 08='225', 09='214', 10='23', 11='15', 12='118', 13='85', 14='267', 15='278', 16='207', 17='231', 18='199', 19='198', 20='295', 21='26', 22='30', 23='61', 24='26', 25='51', 26='42', 27='222', 28='185', 29='186', 30='182', 31='<NA>'),\n",
       " Row(Number=221, Year=2015, Month=10, Measure='Max.TemperatureF', 01='59', 02='54', 03='54', 04='56', 05='61', 06='64', 07='72', 08='62', 09='72', 10='61', 11='68', 12='76', 13='72', 14='68', 15='62', 16='61', 17='56', 18='47', 19='48', 20='66', 21='61', 22='73', 23='59', 24='49', 25='63', 26='52', 27='54', 28='65', 29='75', 30='61', 31='52'),\n",
       " Row(Number=222, Year=2015, Month=10, Measure='Mean.TemperatureF', 01='57', 02='52', 03='52', 04='54', 05='55', 06='56', 07='62', 08='57', 09='62', 10='55', 11='58', 12='64', 13='64', 14='60', 15='55', 16='56', 17='48', 18='40', 19='40', 20='56', 21='57', 22='63', 23='50', 24='44', 25='56', 26='48', 27='46', 28='54', 29='66', 30='52', 31='45'),\n",
       " Row(Number=223, Year=2015, Month=10, Measure='Min.TemperatureF', 01='54', 02='50', 03='49', 04='51', 05='48', 06='48', 07='52', 08='51', 09='52', 10='48', 11='48', 12='51', 13='55', 14='51', 15='47', 16='50', 17='40', 18='33', 19='31', 20='45', 21='53', 22='52', 23='40', 24='38', 25='48', 26='43', 27='38', 28='42', 29='57', 30='42', 31='38'),\n",
       " Row(Number=224, Year=2015, Month=10, Measure='Max.Dew.PointF', 01='50', 02='45', 03='47', 04='45', 05='50', 06='49', 07='54', 08='50', 09='63', 10='55', 11='49', 12='56', 13='62', 14='57', 15='42', 16='45', 17='40', 18='29', 19='31', 20='43', 21='54', 22='56', 23='38', 24='42', 25='54', 26='36', 27='41', 28='61', 29='66', 30='37', 31='39'),\n",
       " Row(Number=225, Year=2015, Month=10, Measure='MeanDew.PointF', 01='48', 02='43', 03='43', 04='42', 05='47', 06='46', 07='47', 08='44', 09='57', 10='40', 11='45', 12='51', 13='58', 14='46', 15='38', 16='40', 17='32', 18='19', 19='20', 20='37', 21='48', 22='52', 23='31', 24='35', 25='47', 26='33', 27='34', 28='48', 29='57', 30='31', 31='31'),\n",
       " Row(Number=226, Year=2015, Month=10, Measure='Min.DewpointF', 01='45', 02='40', 03='41', 04='38', 05='41', 06='43', 07='43', 08='35', 09='49', 10='31', 11='43', 12='48', 13='52', 14='37', 15='36', 16='35', 17='24', 18='13', 19='15', 20='32', 21='42', 22='47', 23='26', 24='28', 25='35', 26='30', 27='28', 28='39', 29='30', 30='26', 31='26'),\n",
       " Row(Number=227, Year=2015, Month=10, Measure='Max.Humidity', 01='77', 02='80', 03='80', 04='77', 05='96', 06='89', 07='77', 08='83', 09='93', 10='74', 11='86', 12='89', 13='100', 14='84', 15='71', 16='74', 17='83', 18='64', 19='69', 20='65', 21='100', 22='100', 23='60', 24='80', 25='89', 26='70', 27='83', 28='100', 29='100', 30='53', 31='71'),\n",
       " Row(Number=228, Year=2015, Month=10, Measure='Mean.Humidity', 01='72', 02='73', 03='72', 04='66', 05='80', 06='71', 07='61', 08='61', 09='75', 10='53', 11='63', 12='65', 13='84', 14='65', 15='55', 16='57', 17='58', 18='46', 19='48', 20='51', 21='76', 22='71', 23='49', 24='71', 25='72', 26='57', 27='62', 28='83', 29='65', 30='41', 31='58'),\n",
       " Row(Number=229, Year=2015, Month=10, Measure='Min.Humidity', 01='67', 02='66', 03='64', 04='54', 05='64', 06='52', 07='44', 08='39', 09='57', 10='32', 11='39', 12='41', 13='68', 14='45', 15='39', 16='39', 17='32', 18='28', 19='26', 20='36', 21='51', 22='41', 23='38', 24='61', 25='55', 26='44', 27='41', 28='66', 29='30', 30='28', 31='44'),\n",
       " Row(Number=230, Year=2015, Month=10, Measure='Max.Sea.Level.PressureIn', 01='30.24', 02='30.36', 03='30.46', 04='30.44', 05='30.29', 06='30.08', 07='29.99', 08='30.16', 09='30.12', 10='30.09', 11='30.03', 12='29.86', 13='29.93', 14='29.81', 15='29.96', 16='29.98', 17='30.14', 18='30.33', 19='30.45', 20='30.21', 21='30.33', 22='30.28', 23='30.37', 24='30.44', 25='30.19', 26='30.53', 27='30.62', 28='30.57', 29='29.75', 30='30.09', 31='30.22'),\n",
       " Row(Number=231, Year=2015, Month=10, Measure='Mean.Sea.Level.PressureIn', 01='30.13', 02='30.28', 03='30.42', 04='30.39', 05='30.2', 06='30', 07='29.95', 08='30.11', 09='29.85', 10='30.02', 11='29.9', 12='29.8', 13='29.6', 14='29.66', 15='29.91', 16='29.9', 17='30.01', 18='30.22', 19='30.34', 20='30.13', 21='30.28', 22='30.13', 23='30.19', 24='30.37', 25='30.07', 26='30.4', 27='30.56', 28='30.27', 29='29.55', 30='29.83', 31='30.14'),\n",
       " Row(Number=232, Year=2015, Month=10, Measure='Min.Sea.Level.PressureIn', 01='29.97', 02='30.22', 03='30.35', 04='30.3', 05='30.09', 06='29.94', 07='29.9', 08='30', 09='29.72', 10='29.8', 11='29.79', 12='29.74', 13='29.47', 14='29.56', 15='29.82', 16='29.84', 17='29.95', 18='30.13', 19='30.18', 20='30.07', 21='30.17', 22='29.96', 23='30.03', 24='30.25', 25='29.98', 26='30.21', 27='30.53', 28='29.79', 29='29.44', 30='29.64', 31='30.06'),\n",
       " Row(Number=233, Year=2015, Month=10, Measure='Max.VisibilityMiles', 01='10', 02='10', 03='10', 04='10', 05='10', 06='10', 07='10', 08='10', 09='10', 10='10', 11='10', 12='10', 13='10', 14='10', 15='10', 16='10', 17='10', 18='10', 19='10', 20='10', 21='10', 22='10', 23='10', 24='10', 25='10', 26='10', 27='10', 28='10', 29='10', 30='10', 31='10'),\n",
       " Row(Number=234, Year=2015, Month=10, Measure='Mean.VisibilityMiles', 01='10', 02='10', 03='9', 04='10', 05='10', 06='10', 07='10', 08='10', 09='8', 10='10', 11='10', 12='10', 13='7', 14='10', 15='10', 16='10', 17='10', 18='10', 19='10', 20='10', 21='9', 22='7', 23='10', 24='10', 25='10', 26='10', 27='10', 28='7', 29='8', 30='10', 31='10'),\n",
       " Row(Number=235, Year=2015, Month=10, Measure='Min.VisibilityMiles', 01='10', 02='7', 03='5', 04='10', 05='10', 06='10', 07='10', 08='10', 09='2', 10='10', 11='10', 12='10', 13='0', 14='10', 15='10', 16='10', 17='10', 18='10', 19='10', 20='10', 21='4', 22='0', 23='10', 24='10', 25='7', 26='10', 27='10', 28='2', 29='2', 30='10', 31='10'),\n",
       " Row(Number=236, Year=2015, Month=10, Measure='Max.Wind.SpeedMPH', 01='30', 02='25', 03='29', 04='28', 05='15', 06='12', 07='13', 08='13', 09='31', 10='29', 11='23', 12='15', 13='16', 14='21', 15='16', 16='22', 17='23', 18='22', 19='17', 20='21', 21='13', 22='24', 23='26', 24='13', 25='24', 26='18', 27='12', 28='29', 29='29', 30='23', 31='13'),\n",
       " Row(Number=237, Year=2015, Month=10, Measure='Mean.Wind.SpeedMPH', 01='17', 02='20', 03='22', 04='18', 05='9', 06='6', 07='7', 08='9', 09='15', 10='10', 11='14', 12='8', 13='8', 14='13', 15='9', 16='12', 17='12', 18='11', 19='11', 20='12', 21='6', 22='11', 23='14', 24='6', 25='12', 26='9', 27='6', 28='17', 29='17', 30='13', 31='7'),\n",
       " Row(Number=238, Year=2015, Month=10, Measure='Max.Gust.SpeedMPH', 01='38', 02='36', 03='37', 04='35', 05='18', 06='15', 07='17', 08='18', 09='40', 10='37', 11='28', 12='<NA>', 13='21', 14='28', 15='24', 16='29', 17='29', 18='30', 19='22', 20='28', 21='16', 22='29', 23='35', 24='16', 25='35', 26='26', 27='22', 28='40', 29='39', 30='31', 31='17'),\n",
       " Row(Number=239, Year=2015, Month=10, Measure='PrecipitationIn', 01='T', 02='0.08', 03='0.01', 04='0.00', 05='0.00', 06='0.00', 07='0.00', 08='0.00', 09='0.34', 10='0.00', 11='0.00', 12='0.00', 13='0.12', 14='0.00', 15='0.00', 16='T', 17='T', 18='T', 19='0.00', 20='T', 21='0.07', 22='T', 23='0.00', 24='0.00', 25='0.03', 26='0.00', 27='0.00', 28='0.36', 29='0.73', 30='0.00', 31='0.00'),\n",
       " Row(Number=240, Year=2015, Month=10, Measure='CloudCover', 01='7', 02='8', 03='8', 04='7', 05='6', 06='1', 07='3', 08='2', 09='7', 10='2', 11='4', 12='0', 13='6', 14='3', 15='1', 16='3', 17='4', 18='2', 19='2', 20='6', 21='8', 22='7', 23='2', 24='8', 25='7', 26='2', 27='4', 28='7', 29='7', 30='1', 31='4'),\n",
       " Row(Number=241, Year=2015, Month=10, Measure='Events', 01='Rain', 02='Rain', 03='Rain', 04=None, 05=None, 06=None, 07=None, 08='Rain', 09='Fog-Rain', 10=None, 11=None, 12=None, 13=None, 14=None, 15='Rain', 16=None, 17=None, 18=None, 19=None, 20=None, 21='Rain', 22='Fog', 23='Rain', 24=None, 25=None, 26=None, 27=None, 28='Rain', 29='Rain', 30=None, 31=None),\n",
       " Row(Number=242, Year=2015, Month=10, Measure='WindDirDegrees', 01='22', 02='28', 03='39', 04='40', 05='14', 06='344', 07='299', 08='14', 09='210', 10='313', 11='222', 12='199', 13='148', 14='262', 15='266', 16='262', 17='287', 18='319', 19='275', 20='234', 21='68', 22='187', 23='320', 24='4', 25='233', 26='294', 27='178', 28='114', 29='206', 30='289', 31='224'),\n",
       " Row(Number=243, Year=2015, Month=11, Measure='Max.TemperatureF', 01='62', 02='64', 03='73', 04='60', 05='76', 06='73', 07='69', 08='56', 09='60', 10='53', 11='50', 12='57', 13='59', 14='47', 15='54', 16='61', 17='45', 18='48', 19='55', 20='61', 21='48', 22='49', 23='42', 24='44', 25='44', 26='59', 27='64', 28='60', 29='44', 30='38', 31='<NA>'),\n",
       " Row(Number=244, Year=2015, Month=11, Measure='Mean.TemperatureF', 01='55', 02='58', 03='60', 04='55', 05='63', 06='68', 07='60', 08='50', 09='51', 10='49', 11='48', 12='52', 13='53', 14='42', 15='46', 16='50', 17='39', 18='40', 19='49', 20='53', 21='43', 22='43', 23='36', 24='37', 25='37', 26='49', 27='56', 28='51', 29='38', 30='33', 31='<NA>'),\n",
       " Row(Number=245, Year=2015, Month=11, Measure='Min.TemperatureF', 01='48', 02='51', 03='47', 04='49', 05='50', 06='62', 07='50', 08='44', 09='41', 10='44', 11='46', 12='46', 13='46', 14='37', 15='37', 16='39', 17='33', 18='31', 19='43', 20='44', 21='38', 22='36', 23='30', 24='29', 25='30', 26='38', 27='48', 28='41', 29='32', 30='28', 31='<NA>'),\n",
       " Row(Number=246, Year=2015, Month=11, Measure='Max.Dew.PointF', 01='50', 02='48', 03='44', 04='49', 05='61', 06='62', 07='45', 08='34', 09='36', 10='47', 11='49', 12='54', 13='54', 14='31', 15='35', 16='37', 17='31', 18='38', 19='50', 20='58', 21='31', 22='44', 23='36', 24='21', 25='34', 26='49', 27='52', 28='50', 29='33', 30='26', 31='<NA>'),\n",
       " Row(Number=247, Year=2015, Month=11, Measure='MeanDew.PointF', 01='46', 02='42', 03='42', 04='45', 05='55', 06='61', 07='38', 08='30', 09='32', 10='40', 11='45', 12='47', 13='39', 14='25', 15='30', 16='29', 17='26', 18='33', 19='44', 20='47', 21='28', 22='39', 23='18', 24='16', 25='27', 26='42', 27='49', 28='43', 29='23', 30='23', 31='<NA>'),\n",
       " Row(Number=248, Year=2015, Month=11, Measure='Min.DewpointF', 01='39', 02='39', 03='40', 04='43', 05='48', 06='54', 07='33', 08='24', 09='30', 10='36', 11='42', 12='42', 13='30', 14='19', 15='25', 16='14', 17='20', 18='29', 19='39', 20='26', 21='23', 22='31', 23='5', 24='11', 25='20', 26='34', 27='47', 28='36', 29='15', 30='18', 31='<NA>'),\n",
       " Row(Number=249, Year=2015, Month=11, Measure='Max.Humidity', 01='80', 02='83', 03='82', 04='83', 05='100', 06='93', 07='57', 08='65', 09='70', 10='80', 11='93', 12='100', 13='86', 14='62', 15='64', 16='66', 17='76', 18='85', 19='89', 20='100', 21='70', 22='89', 23='85', 24='50', 25='76', 26='100', 27='100', 28='93', 29='79', 30='75', 31='<NA>'),\n",
       " Row(Number=250, Year=2015, Month=11, Measure='Mean.Humidity', 01='73', 02='63', 03='57', 04='69', 05='77', 06='79', 07='48', 08='48', 09='52', 10='67', 11='90', 12='90', 13='65', 14='51', 15='54', 16='42', 17='62', 18='69', 19='83', 20='69', 21='60', 22='80', 23='56', 24='42', 25='63', 26='79', 27='78', 28='80', 29='58', 30='65', 31='<NA>'),\n",
       " Row(Number=251, Year=2015, Month=11, Measure='Min.Humidity', 01='65', 02='43', 03='31', 04='55', 05='53', 06='64', 07='39', 08='30', 09='33', 10='54', 11='86', 12='80', 13='44', 14='39', 15='44', 16='17', 17='48', 18='53', 19='77', 20='38', 21='49', 22='70', 23='27', 24='33', 25='49', 26='57', 27='56', 28='67', 29='36', 30='54', 31='<NA>'),\n",
       " Row(Number=252, Year=2015, Month=11, Measure='Max.Sea.Level.PressureIn', 01='30.07', 02='30.11', 03='30.25', 04='30.4', 05='30.3', 06='30.07', 07='30.02', 08='30.38', 09='30.43', 10='30.31', 11='29.98', 12='29.98', 13='29.62', 14='30.12', 15='30.21', 16='30.41', 17='30.6', 18='30.61', 19='30.44', 20='30.18', 21='30.3', 22='30', 23='30.15', 24='30.53', 25='30.88', 26='30.87', 27='30.63', 28='30.2', 29='30.42', 30='30.53', 31='<NA>'),\n",
       " Row(Number=253, Year=2015, Month=11, Measure='Mean.Sea.Level.PressureIn', 01='29.91', 02='30.02', 03='30.13', 04='30.33', 05='30.2', 06='29.9', 07='29.93', 08='30.25', 09='30.37', 10='30.15', 11='29.85', 12='29.75', 13='29.51', 14='29.89', 15='30.12', 16='30.18', 17='30.54', 18='30.55', 19='30.3', 20='30.02', 21='30.2', 22='29.91', 23='29.94', 24='30.33', 25='30.76', 26='30.77', 27='30.41', 28='30.16', 29='30.26', 30='30.46', 31='<NA>'),\n",
       " Row(Number=254, Year=2015, Month=11, Measure='Min.Sea.Level.PressureIn', 01='29.79', 02='29.94', 03='30.06', 04='30.26', 05='30.09', 06='29.71', 07='29.83', 08='30.04', 09='30.32', 10='29.89', 11='29.78', 12='29.42', 13='29.43', 14='29.63', 15='30.05', 16='30.09', 17='30.42', 18='30.46', 19='30.06', 20='29.94', 21='30.04', 22='29.82', 23='29.8', 24='30.16', 25='30.54', 26='30.64', 27='30.15', 28='30.11', 29='30.19', 30='30.39', 31='<NA>'),\n",
       " Row(Number=255, Year=2015, Month=11, Measure='Max.VisibilityMiles', 01='10', 02='10', 03='10', 04='10', 05='10', 06='10', 07='10', 08='10', 09='10', 10='10', 11='10', 12='10', 13='10', 14='10', 15='10', 16='10', 17='10', 18='10', 19='10', 20='10', 21='10', 22='10', 23='10', 24='10', 25='10', 26='10', 27='10', 28='10', 29='10', 30='10', 31='<NA>'),\n",
       " Row(Number=256, Year=2015, Month=11, Measure='Mean.VisibilityMiles', 01='10', 02='10', 03='10', 04='10', 05='9', 06='10', 07='10', 08='10', 09='10', 10='10', 11='4', 12='8', 13='10', 14='10', 15='10', 16='10', 17='10', 18='10', 19='10', 20='7', 21='10', 22='9', 23='10', 24='10', 25='10', 26='9', 27='9', 28='9', 29='10', 30='10', 31='<NA>'),\n",
       " Row(Number=257, Year=2015, Month=11, Measure='Min.VisibilityMiles', 01='10', 02='10', 03='10', 04='10', 05='5', 06='10', 07='10', 08='10', 09='10', 10='7', 11='2', 12='0', 13='10', 14='10', 15='10', 16='10', 17='10', 18='10', 19='10', 20='2', 21='10', 22='5', 23='10', 24='10', 25='10', 26='5', 27='5', 28='4', 29='10', 30='10', 31='<NA>'),\n",
       " Row(Number=258, Year=2015, Month=11, Measure='Max.Wind.SpeedMPH', 01='22', 02='18', 03='16', 04='13', 05='22', 06='26', 07='25', 08='18', 09='16', 10='17', 11='25', 12='18', 13='29', 14='31', 15='18', 16='21', 17='14', 18='15', 19='16', 20='25', 21='13', 22='20', 23='22', 24='15', 25='14', 26='22', 27='26', 28='18', 29='16', 30='14', 31='<NA>'),\n",
       " Row(Number=259, Year=2015, Month=11, Measure='Mean.Wind.SpeedMPH', 01='11', 02='7', 03='8', 04='7', 05='12', 06='15', 07='13', 08='12', 09='9', 10='8', 11='16', 12='7', 13='18', 14='16', 15='10', 16='11', 17='7', 18='6', 19='9', 20='13', 21='8', 22='7', 23='13', 24='8', 25='6', 26='10', 27='14', 28='10', 29='10', 30='9', 31='<NA>'),\n",
       " Row(Number=260, Year=2015, Month=11, Measure='Max.Gust.SpeedMPH', 01='28', 02='23', 03='<NA>', 04='16', 05='31', 06='32', 07='33', 08='25', 09='20', 10='22', 11='33', 12='23', 13='39', 14='43', 15='23', 16='28', 17='17', 18='17', 19='20', 20='29', 21='16', 22='25', 23='31', 24='22', 25='18', 26='28', 27='32', 28='23', 29='20', 30='17', 31='<NA>'),\n",
       " Row(Number=261, Year=2015, Month=11, Measure='PrecipitationIn', 01='T', 02='0.00', 03='0.00', 04='0.00', 05='0.00', 06='0.00', 07='0.00', 08='0.00', 09='0.00', 10='0.07', 11='0.54', 12='0.04', 13='0.01', 14='0.00', 15='0.00', 16='0.00', 17='0.00', 18='0.00', 19='T', 20='0.86', 21='0.00', 22='0.30', 23='0.04', 24='0.00', 25='0.00', 26='0.00', 27='0.00', 28='0.21', 29='0.00', 30='0.00', 31='<NA>'),\n",
       " Row(Number=262, Year=2015, Month=11, Measure='CloudCover', 01='6', 02='2', 03='1', 04='0', 05='4', 06='4', 07='6', 08='0', 09='2', 10='7', 11='8', 12='8', 13='3', 14='2', 15='6', 16='3', 17='1', 18='2', 19='8', 20='6', 21='4', 22='8', 23='3', 24='1', 25='1', 26='6', 27='7', 28='8', 29='4', 30='6', 31='<NA>'),\n",
       " Row(Number=263, Year=2015, Month=11, Measure='Events', 01='Rain', 02=None, 03=None, 04=None, 05=None, 06=None, 07=None, 08='Rain', 09='Rain', 10='Rain', 11='Rain', 12=None, 13=None, 14=None, 15='Rain', 16='Rain', 17=None, 18=None, 19=None, 20=None, 21='Rain', 22='Rain', 23=None, 24=None, 25=None, 26=None, 27=None, 28='Rain', 29='<NA>', 30=None, 31=None),\n",
       " Row(Number=264, Year=2015, Month=11, Measure='WindDirDegrees', 01='207', 02='251', 03='281', 04='129', 05='224', 06='222', 07='280', 08='283', 09='237', 10='37', 11='13', 12='173', 13='257', 14='279', 15='254', 16='306', 17='35', 18='158', 19='132', 20='266', 21='1', 22='341', 23='316', 24='271', 25='83', 26='180', 27='209', 28='358', 29='326', 30='65', 31='<NA>'),\n",
       " Row(Number=265, Year=2015, Month=12, Measure='Max.TemperatureF', 01='45', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=266, Year=2015, Month=12, Measure='Mean.TemperatureF', 01='39', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=267, Year=2015, Month=12, Measure='Min.TemperatureF', 01='32', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=268, Year=2015, Month=12, Measure='Max.Dew.PointF', 01='43', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=269, Year=2015, Month=12, Measure='MeanDew.PointF', 01='35', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=270, Year=2015, Month=12, Measure='Min.DewpointF', 01='25', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=271, Year=2015, Month=12, Measure='Max.Humidity', 01='96', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=272, Year=2015, Month=12, Measure='Mean.Humidity', 01='83', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=273, Year=2015, Month=12, Measure='Min.Humidity', 01='69', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=274, Year=2015, Month=12, Measure='Max.Sea.Level.PressureIn', 01='30.4', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=275, Year=2015, Month=12, Measure='Mean.Sea.Level.PressureIn', 01='30.24', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=276, Year=2015, Month=12, Measure='Min.Sea.Level.PressureIn', 01='30.01', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=277, Year=2015, Month=12, Measure='Max.VisibilityMiles', 01='10', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=278, Year=2015, Month=12, Measure='Mean.VisibilityMiles', 01='8', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=279, Year=2015, Month=12, Measure='Min.VisibilityMiles', 01='1', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=280, Year=2015, Month=12, Measure='Max.Wind.SpeedMPH', 01='15', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=281, Year=2015, Month=12, Measure='Mean.Wind.SpeedMPH', 01='6', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=282, Year=2015, Month=12, Measure='Max.Gust.SpeedMPH', 01='17', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=283, Year=2015, Month=12, Measure='PrecipitationIn', 01='0.14', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=284, Year=2015, Month=12, Measure='CloudCover', 01='7', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=285, Year=2015, Month=12, Measure='Events', 01='Rain', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>'),\n",
       " Row(Number=286, Year=2015, Month=12, Measure='WindDirDegrees', 01='109', 02='<NA>', 03='<NA>', 04='<NA>', 05='<NA>', 06='<NA>', 07='<NA>', 08='<NA>', 09='<NA>', 10='<NA>', 11='<NA>', 12='<NA>', 13='<NA>', 14='<NA>', 15='<NA>', 16='<NA>', 17='<NA>', 18='<NA>', 19='<NA>', 20='<NA>', 21='<NA>', 22='<NA>', 23='<NA>', 24='<NA>', 25='<NA>', 26='<NA>', 27='<NA>', 28='<NA>', 29='<NA>', 30='<NA>', 31='<NA>')]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.collect()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "+-------+-----------------+------------------+------------------+--------------+-----------------+------------------+------------------+----------------+------------------+------------------+-----------------+------------------+------------------+------------------+-----------------+-----------------+------------------+-----------------+-----------------+------------------+-----------------+------------------+------------------+------------------+-----------------+------------------+------------------+------------------+------------------+------------------+------------------+-----------------+------------------+-----------------+----------------+\n",
      "|summary|           Number|              Year|             Month|       Measure|               01|                02|                03|              04|                05|                06|               07|                08|                09|                10|               11|               12|                13|               14|               15|                16|               17|                18|                19|                20|               21|                22|                23|                24|                25|                26|                27|               28|                29|               30|              31|\n",
      "+-------+-----------------+------------------+------------------+--------------+-----------------+------------------+------------------+----------------+------------------+------------------+-----------------+------------------+------------------+------------------+-----------------+-----------------+------------------+-----------------+-----------------+------------------+-----------------+------------------+------------------+------------------+-----------------+------------------+------------------+------------------+------------------+------------------+------------------+-----------------+------------------+-----------------+----------------+\n",
      "|  count|              286|               286|               286|           286|              282|               278|               285|             281|               279|               276|              274|               286|               284|               282|              281|              276|               275|              274|              285|               284|              278|               276|               275|               274|              285|               285|               283|               281|               278|               274|               274|              285|               283|              278|             274|\n",
      "|   mean|            143.5| 2014.923076923077| 6.923076923076923|          null|38.69728624535316|39.829960317460326| 39.08191999999999|        41.06776|40.270960000000024|40.449800796812745|39.08478087649404| 38.43975806451613| 41.01051792828686| 41.64019841269842|41.62742063492065|          42.4834|40.897920000000006|40.61844621513944|42.16988047808765|39.277580645161294|40.69432000000001| 40.59799999999999| 42.15604000000002|41.961209677419355|         41.24936| 41.89842105263157|39.583968253968266| 38.78610441767069|40.453426294820716| 41.20449799196786| 41.70876984126985|41.94529880478088|41.168165938864625|41.46295652173913|40.5065306122449|\n",
      "| stddev|82.70530011230639|0.2669364357460943|3.6323631534130225|          null|44.39159610693774|  48.0865588685978|41.770108202764845|43.3656587499564| 47.34148905794253| 50.20020763662397|48.15257660657209|46.155139066949076|44.097767691014454|50.421588428387956|48.56374792008407|50.73936383726584| 51.61787968608112|50.18283973208467|54.75554131214173| 46.84724920084185|  49.255513932438|48.297255993960825|50.416063712266904| 51.63754416857495|72.86374034744637|49.987316166984705| 52.92875799069194|48.955645071431974| 47.12457786138298|49.278195783596686|50.900803472029885|50.60511413098836|48.597049285456045|46.51071912839982|53.0442537093278|\n",
      "|    min|                1|              2014|                 1|    CloudCover|               -6|                -5|                -3|               0|                -4|                -1|              -13|                -1|                 0|                -2|               -1|                0|               -10|               -4|              -13|               -11|               -3|                -1|                -2|               -10|               -5|                -5|               -14|               -15|                 0|                -2|                -2|               -1|                -2|               -6|              -8|\n",
      "|    max|              286|              2015|                12|WindDirDegrees|                T|         Rain-Snow|      Thunderstorm|               T|                 T|                 T|                T|                 T|                 T|              Snow|             Snow|                T|                 T|                T|                T|                 T|                T|                 T|                 T|                 T|                T|                 T|              Snow|                 T|                 T|                 T|              <NA>|                T|                 T|                T|            <NA>|\n",
      "+-------+-----------------+------------------+------------------+--------------+-----------------+------------------+------------------+----------------+------------------+------------------+-----------------+------------------+------------------+------------------+-----------------+-----------------+------------------+-----------------+-----------------+------------------+-----------------+------------------+------------------+------------------+-----------------+------------------+------------------+------------------+------------------+------------------+------------------+-----------------+------------------+-----------------+----------------+\n",
      "\n"
     ]
    }
   ],
   "source": [
    "df.describe().show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}