weather_data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The next three cells were just used to practice pulling data from tables from a website."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "url = 'https://www.usclimatedata.com/climate/anderson/indiana/united-states/usin0010'\n",
    "#med_abbreviations = ['BMR', 'BP', 'ECG', 'MRI', 'qid', 'WBC']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[                                 Unnamed: 0  JanJa  FebFe  MarMa  AprAp  \\\n",
       " 0              Average high in ºFAv. highHi  51.00  64.00  76.00  83.00   \n",
       " 1                Average low in ºFAv. lowLo  34.00  43.00  54.00  62.00   \n",
       " 2  Av. precipitation in inchAv. precip.Pre.   3.78   3.09   2.97   3.36   \n",
       " 3            Av. snowfall in inchSnowfallSn   1.00   0.00   0.00   0.00   \n",
       " \n",
       "    MayMa  JunJu  \n",
       " 0  84.00  81.00  \n",
       " 1  64.00  60.00  \n",
       " 2   4.43   4.28  \n",
       " 3   0.00   0.00  ,\n",
       "                                  Unnamed: 0  JulJu  AugAu  SepSe  OctOc  \\\n",
       " 0              Average high in ºFAv. highHi  72.00  62.00  39.00   50.0   \n",
       " 1                Average low in ºFAv. lowLo  51.00  41.00  23.00   31.0   \n",
       " 2  Av. precipitation in inchAv. precip.Pre.   4.44   3.86   2.26    3.3   \n",
       " 3            Av. snowfall in inchSnowfallSn   0.00   0.00   5.00    2.0   \n",
       " \n",
       "    NovNo  DecDe  \n",
       " 0  34.00  38.00  \n",
       " 1  19.00  23.00  \n",
       " 2   2.51   3.16  \n",
       " 3   7.00   5.00  ,\n",
       "        Day  HighºF  LowºF  Prec/moinch  Prec/yrinch  Snow/moinch  Snow/yrinch\n",
       " 0    1 Jan    34.3   19.7         0.08         0.08         0.20          0.5\n",
       " 1    2 Jan    34.3   19.6         0.20         0.20         0.39          1.0\n",
       " 2    3 Jan    34.2   19.5         0.28         0.28         0.71          1.8\n",
       " 3    4 Jan    34.1   19.4         0.35         0.35         0.91          2.3\n",
       " 4    5 Jan    34.1   19.3         0.47         0.47         1.10          2.8\n",
       " 5    6 Jan    34.0   19.3         0.55         0.55         1.30          3.3\n",
       " 6    7 Jan    34.0   19.2         0.63         0.63         1.61          4.1\n",
       " 7    8 Jan    33.9   19.2         0.71         0.71         1.81          4.6\n",
       " 8    9 Jan    33.9   19.1         0.79         0.79         2.01          5.1\n",
       " 9   10 Jan    33.9   19.1         0.91         0.91         2.20          5.6\n",
       " 10  11 Jan    33.9   19.0         0.98         0.98         2.40          6.1\n",
       " 11  12 Jan    33.9   19.0         1.06         1.06         2.60          6.6\n",
       " 12  13 Jan    33.9   19.0         1.14         1.14         2.80          7.1\n",
       " 13  14 Jan    33.9   19.0         1.22         1.22         3.11          7.9\n",
       " 14  15 Jan    33.9   19.0         1.30         1.30         3.31          8.4\n",
       " 15  16 Jan    33.9   19.0         1.38         1.38         3.58          9.1\n",
       " 16  17 Jan    33.9   19.0         1.46         1.46         3.90          9.9\n",
       " 17  18 Jan    34.0   19.0         1.54         1.54         4.21         10.7\n",
       " 18  19 Jan    34.0   19.1         1.61         1.61         4.41         11.2\n",
       " 19  20 Jan    34.1   19.1         1.69         1.69         4.61         11.7\n",
       " 20  21 Jan    34.1   19.2         1.77         1.77         4.88         12.4\n",
       " 21  22 Jan    34.2   19.2         1.81         1.81         5.12         13.0\n",
       " 22  23 Jan    34.3   19.3         1.89         1.89         5.39         13.7\n",
       " 23  24 Jan    34.4   19.3         1.97         1.97         5.59         14.2\n",
       " 24  25 Jan    34.4   19.4         2.05         2.05         5.91         15.0\n",
       " 25  26 Jan    34.5   19.5         2.13         2.13         6.10         15.5\n",
       " 26  27 Jan    34.6   19.6         2.20         2.20         6.42         16.3\n",
       " 27  28 Jan    34.8   19.6         2.28         2.28         6.61         16.8\n",
       " 28  29 Jan    34.9   19.7         2.36         2.36         6.89         17.5\n",
       " 29  30 Jan    35.0   19.8         2.44         2.44         7.09         18.0\n",
       " 30  31 Jan    35.2   20.0         2.52         2.52         7.40         18.8,\n",
       "        Day HighºF LowºF Precip.inch  Snowinch  Snow d.inch\n",
       " 0   01 Sep      -  62.1        0.40       0.0          0.0\n",
       " 1   02 Sep   81.0  62.1        0.00       0.0          0.0\n",
       " 2   03 Sep      -  61.0           T       0.0          0.0\n",
       " 3   04 Sep      -  60.1        0.00       0.0          0.0\n",
       " 4   05 Sep   75.0  54.0        0.00       0.0          0.0\n",
       " 5   06 Sep      -  57.9        0.00       0.0          0.0\n",
       " 6   07 Sep      -  60.1        0.00       0.0          0.0\n",
       " 7   08 Sep      -  57.9        0.00       0.0          0.0\n",
       " 8   09 Sep      -  60.1           T       0.0          0.0\n",
       " 9   10 Sep      -     -        0.00       0.0          0.0\n",
       " 10  11 Sep      -  68.0        0.00       0.0          0.0\n",
       " 11  12 Sep      -  70.0        0.00       0.0          0.0\n",
       " 12  13 Sep      -  70.0           T       0.0          0.0\n",
       " 13  14 Sep   90.0  66.0        0.00       0.0          0.0\n",
       " 14  15 Sep      -  57.9        0.00       0.0          0.0\n",
       " 15  16 Sep      -  61.0           T       0.0          0.0\n",
       " 16  17 Sep   98.1  63.0        0.00       0.0          0.0\n",
       " 17  18 Sep   78.1  63.0        0.00       0.0          0.0\n",
       " 18  19 Sep      -  60.1        0.00       0.0          0.0\n",
       " 19  20 Sep      -  60.1        0.00       0.0          0.0\n",
       " 20  21 Sep      -  64.0        0.00       0.0          0.0\n",
       " 21  22 Sep      -  69.1        0.00       0.0          0.0\n",
       " 22  23 Sep      -  69.1        0.00       0.0          0.0\n",
       " 23  24 Sep      -  71.1        0.22       0.0          0.0\n",
       " 24  25 Sep      -     -           T       0.0          0.0\n",
       " 25  26 Sep      -     -        0.00       0.0          0.0\n",
       " 26  27 Sep      -     -        0.00       0.0          0.0\n",
       " 27  28 Sep      -     -        0.00       0.0          0.0\n",
       " 28  29 Sep      -     -        0.00       0.0          0.0\n",
       " 29  30 Sep      -     -        0.54       0.0          0.0,\n",
       "                                  Unnamed: 0     Sep 19  Unnamed: 2     Normal\n",
       " 0    Average high temperatureAv. high temp.       - ºF         NaN      76 ºF\n",
       " 1      Average low temperatureAv. low temp.    62.9 ºF         NaN      54 ºF\n",
       " 2          Total precipitationTotal precip.  1.16 inch         NaN  2.97 inch\n",
       " 3              Total snowfallTotal snowfall  0.00 inch         NaN     0 inch\n",
       " 4                                       NaN        NaN         NaN        NaN\n",
       " 5  Highest max temperatureHighest max temp.    98.1 ºF         NaN          -\n",
       " 6    Lowest max temperatureLowest max temp.    75.0 ºF         NaN          -\n",
       " 7  Highest min temperatureHighest min temp.    71.1 ºF         NaN          -\n",
       " 8    Lowest min temperatureLowest min temp.    54.0 ºF         NaN          -,\n",
       "              Unnamed: 0         Unnamed: 1  Unnamed: 2\n",
       " 0               Country      United States         NaN\n",
       " 1                 State            Indiana         NaN\n",
       " 2                County            Madison         NaN\n",
       " 3                  City           Anderson         NaN\n",
       " 4              Zip code              46017         NaN\n",
       " 5             Longitude  -85.61 dec. degr.         NaN\n",
       " 6              Latitude   40.11 dec. degr.         NaN\n",
       " 7  Altitude - Elevation              896ft         NaN\n",
       " 8                  ICAO                  -         NaN\n",
       " 9                  IATA                  -         NaN,\n",
       "     Unnamed: 0                    Unnamed: 1  Unnamed: 2\n",
       " 0   Local Time                      10:44 PM         NaN\n",
       " 1      Sunrise                      07:19 AM         NaN\n",
       " 2       Sunset                      06:31 PM         NaN\n",
       " 3  Day / Night                         Night         NaN\n",
       " 4     Timezone                        Unkown         NaN\n",
       " 5  Timezone DB  America/Indiana/Indianapolis         NaN,\n",
       "                 Unnamed: 0  Unnamed: 1\n",
       " 0  Annual high temperature        61ºF\n",
       " 1   Annual low temperature        42ºF\n",
       " 2   Average annual precip.  41.44 inch\n",
       " 3      Av. annual snowfall     20 inch]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Use Panda's `read_html` to parse the url\n",
    "### BEGIN SOLUTION\n",
    "tables = pd.read_html(url)\n",
    "tables\n",
    "### END SOLUTION"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": true
   },
   "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>Unnamed: 0</th>\n",
       "      <th>JulJu</th>\n",
       "      <th>AugAu</th>\n",
       "      <th>SepSe</th>\n",
       "      <th>OctOc</th>\n",
       "      <th>NovNo</th>\n",
       "      <th>DecDe</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Average high in ºFAv. highHi</td>\n",
       "      <td>72.00</td>\n",
       "      <td>62.00</td>\n",
       "      <td>39.00</td>\n",
       "      <td>50.0</td>\n",
       "      <td>34.00</td>\n",
       "      <td>38.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Average low in ºFAv. lowLo</td>\n",
       "      <td>51.00</td>\n",
       "      <td>41.00</td>\n",
       "      <td>23.00</td>\n",
       "      <td>31.0</td>\n",
       "      <td>19.00</td>\n",
       "      <td>23.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Av. precipitation in inchAv. precip.Pre.</td>\n",
       "      <td>4.44</td>\n",
       "      <td>3.86</td>\n",
       "      <td>2.26</td>\n",
       "      <td>3.3</td>\n",
       "      <td>2.51</td>\n",
       "      <td>3.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Av. snowfall in inchSnowfallSn</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.00</td>\n",
       "      <td>5.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 Unnamed: 0  JulJu  AugAu  SepSe  OctOc  \\\n",
       "0              Average high in ºFAv. highHi  72.00  62.00  39.00   50.0   \n",
       "1                Average low in ºFAv. lowLo  51.00  41.00  23.00   31.0   \n",
       "2  Av. precipitation in inchAv. precip.Pre.   4.44   3.86   2.26    3.3   \n",
       "3            Av. snowfall in inchSnowfallSn   0.00   0.00   5.00    2.0   \n",
       "\n",
       "   NovNo  DecDe  \n",
       "0  34.00  38.00  \n",
       "1  19.00  23.00  \n",
       "2   2.51   3.16  \n",
       "3   7.00   5.00  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Find the medical abbreviations DataFrame in the list of DataFrames as assign it to `df`\n",
    "# Assign the columns `['abb', 'full_name', 'other']`\n",
    "### BEGIN SOLUTION\n",
    "df = tables[1]\n",
    "#df.columns = ['abb', 'full_name', 'other']\n",
    "df.head()\n",
    "### END SOLUTION"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "#import dependencies\n",
    "from splinter import Browser\n",
    "from bs4 import BeautifulSoup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "/usr/local/bin/chromedriver\r\n"
     ]
    }
   ],
   "source": [
    "# https://splinter.readthedocs.io/en/latest/drivers/chrome.html\n",
    "!which chromedriver"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "executable_path = {'executable_path': '/usr/local/bin/chromedriver'}\n",
    "browser = Browser('chrome', **executable_path, headless=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "url = 'https://www.usclimatedata.com/climate/indiana/united-states/3184'\n",
    "browser.visit(url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "cities_list = []\n",
    "\n",
    "# HTML object\n",
    "html = browser.html\n",
    "# Parse HTML with Beautiful Soup\n",
    "soup = BeautifulSoup(html, 'html.parser')\n",
    "    \n",
    "cities = soup.find_all('div', class_='col-6 col-sm-4 state_name')\n",
    "\n",
    "# Loop through returned results\n",
    "for city in cities:\n",
    "    \n",
    "    name = city.a.text\n",
    "    cities_list.append(name)\n",
    "    \n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The url endpoint was pulled using the following code."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "url_list = []\n",
    "\n",
    "# HTML object\n",
    "html = browser.html\n",
    "# Parse HTML with Beautiful Soup\n",
    "soup = BeautifulSoup(html, 'html.parser')\n",
    "    \n",
    "urls = soup.find_all('div', class_='col-6 col-sm-4 state_name')\n",
    "\n",
    "# Loop through returned results\n",
    "for url in urls:\n",
    "    \n",
    "    name = url.a\n",
    "    #print(name['href'])\n",
    "    url_list.append(name['href'])\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['/climate/anderson/indiana/united-states/usin0010', '/climate/angola/indiana/united-states/usin0012', '/climate/atlanta/indiana/united-states/usin0845', '/climate/attica/indiana/united-states/usin0846', '/climate/auburn/indiana/united-states/usin0022', '/climate/bedford/indiana/united-states/usin0853', '/climate/berne/indiana/united-states/usin0037', '/climate/bloomfield/indiana/united-states/usin0864', '/climate/bloomington/indiana/united-states/usin0046', '/climate/bluffton/indiana/united-states/usin0047', '/climate/boonville/indiana/united-states/usin0050', '/climate/boswell/indiana/united-states/usin0053', '/climate/brookville/indiana/united-states/usin0068', '/climate/cambridge-city/indiana/united-states/usin0084', '/climate/carmel/indiana/united-states/usin0907', '/climate/chalmers/indiana/united-states/usin0914', '/climate/charlestown/indiana/united-states/usin0105', '/climate/columbia-city/indiana/united-states/usin0125', '/climate/columbus/indiana/united-states/usin0126', '/climate/crane/indiana/united-states/usin0137', '/climate/crawfordsville/indiana/united-states/usin0138', '/climate/decatur/indiana/united-states/usin0953', '/climate/delphi/indiana/united-states/usin0156', '/climate/dubois/indiana/united-states/usin0165', '/climate/elwood/indiana/united-states/usin0185', '/climate/english/indiana/united-states/usin0187', '/climate/evansville/indiana/united-states/usin0190', '/climate/farmland/indiana/united-states/usin0197', '/climate/fort-wayne/indiana/united-states/usin0211', '/climate/fowler/indiana/united-states/usin0998', '/climate/francesville/indiana/united-states/usin1002', '/climate/frankfort/indiana/united-states/usin0219', '/climate/franklin/indiana/united-states/usin1003', '/climate/freelandville/indiana/united-states/usin0224', '/climate/garrett/indiana/united-states/usin0232', '/climate/goshen/indiana/united-states/usin0242', '/climate/grantsburg/indiana/united-states/usin0744', '/climate/greencastle/indiana/united-states/usin0251', '/climate/greenfield/indiana/united-states/usin0252', '/climate/greensburg/indiana/united-states/usin0255', '/climate/hartford-city/indiana/united-states/usin0275', '/climate/hobart/indiana/united-states/usin0291', '/climate/huntington/indiana/united-states/usin0301', '/climate/indianapolis/indiana/united-states/usin1068', '/climate/indianapolis-eagle-creek-airpark/indiana/united-states/usin0306', '/climate/jamestown/indiana/united-states/usin1071', '/climate/kentland/indiana/united-states/usin0320', '/climate/knox/indiana/united-states/usin1089', '/climate/kokomo/indiana/united-states/usin0331', '/climate/la-porte/indiana/united-states/usin0337', '/climate/lafayette/indiana/united-states/usin0340', '/climate/lagrange/indiana/united-states/usin0341', '/climate/lexington/indiana/united-states/usin0769', '/climate/logansport/indiana/united-states/usin0376', '/climate/lowell/indiana/united-states/usin0379', '/climate/madison/indiana/united-states/usin0386', '/climate/marion/indiana/united-states/usin0390', '/climate/martinsville/indiana/united-states/usin0394', '/climate/milan/indiana/united-states/usin0417', '/climate/mishawaka/indiana/united-states/usin1157', '/climate/mount-vernon/indiana/united-states/usin0450', '/climate/muncie/indiana/united-states/usin0452', '/climate/new-castle/indiana/united-states/usin0462', '/climate/north-manchester/indiana/united-states/usin1202', '/climate/north-vernon/indiana/united-states/usin0490', '/climate/oakland-city/indiana/united-states/usin0494', '/climate/oolitic/indiana/united-states/usin0500', '/climate/paoli/indiana/united-states/usin0515', '/climate/perrysville/indiana/united-states/usin0526', '/climate/petersburg/indiana/united-states/usin0529', '/climate/plymouth/indiana/united-states/usin0540', '/climate/portland/indiana/united-states/usin0544', '/climate/princeton/indiana/united-states/usin0549', '/climate/rensselaer/indiana/united-states/usin0557', '/climate/richmond/indiana/united-states/usin0560', '/climate/rochester/indiana/united-states/usin0567', '/climate/rockville/indiana/united-states/usin0570', '/climate/rushville/indiana/united-states/usin0579', '/climate/saint-meinrad/indiana/united-states/usin0588', '/climate/salem/indiana/united-states/usin0591', '/climate/scottsburg/indiana/united-states/usin0601', '/climate/seymour/indiana/united-states/usin0607', '/climate/shelburn/indiana/united-states/usin1290', '/climate/shelbyville/indiana/united-states/usin0611', '/climate/shoals/indiana/united-states/usin0616', '/climate/south-bend/indiana/united-states/usin0624', '/climate/spencer/indiana/united-states/usin0627', '/climate/spurgeon/indiana/united-states/usin0632', '/climate/stendal/indiana/united-states/usin1311', '/climate/syracuse/indiana/united-states/usin1323', '/climate/tell-city/indiana/united-states/usin0657', '/climate/terre-haute/indiana/united-states/usin0660', '/climate/tipton/indiana/united-states/usin0664', '/climate/valparaiso/indiana/united-states/usin0680', '/climate/vevay/indiana/united-states/usin0686', '/climate/vincennes/indiana/united-states/usin0687', '/climate/wabash/indiana/united-states/usin0688', '/climate/wanatah/indiana/united-states/usin0695', '/climate/warsaw/indiana/united-states/usin0697', '/climate/washington/indiana/united-states/usin0698', '/climate/west-lafayette/indiana/united-states/usin0707', '/climate/wheatfield/indiana/united-states/usin0717', '/climate/whiteland/indiana/united-states/usin1372', '/climate/whitestown/indiana/united-states/usin0721', '/climate/winamac/indiana/united-states/usin0727', '/climate/winchester/indiana/united-states/usin0728', '/climate/woodburn/indiana/united-states/usin1385']\n"
     ]
    }
   ],
   "source": [
    "print(url_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Anderson', 'Angola', 'Atlanta', 'Attica', 'Auburn', 'Bedford', 'Berne', 'Bloomfield', 'Bloomington', 'Bluffton', 'Boonville', 'Boswell', 'Brookville', 'Cambridge City', 'Carmel', 'Chalmers', 'Charlestown', 'Columbia City', 'Columbus', 'Crane', 'Crawfordsville', 'Decatur', 'Delphi', 'Dubois', 'Elwood', 'English', 'Evansville', 'Farmland', 'Fort Wayne', 'Fowler', 'Francesville', 'Frankfort', 'Franklin', 'Freelandville', 'Garrett', 'Goshen', 'Grantsburg', 'Greencastle', 'Greenfield', 'Greensburg', 'Hartford City', 'Hobart', 'Huntington', 'Indianapolis', 'Indianapolis-Eagle Creek Airpark', 'Jamestown', 'Kentland', 'Knox', 'Kokomo', 'La Porte', 'Lafayette', 'Lagrange', 'Lexington', 'Logansport', 'Lowell', 'Madison', 'Marion', 'Martinsville', 'Milan', 'Mishawaka', 'Mount Vernon', 'Muncie', 'New Castle', 'North Manchester', 'North Vernon', 'Oakland City', 'Oolitic', 'Paoli', 'Perrysville', 'Petersburg', 'Plymouth', 'Portland', 'Princeton', 'Rensselaer', 'Richmond', 'Rochester', 'Rockville', 'Rushville', 'Saint Meinrad', 'Salem', 'Scottsburg', 'Seymour', 'Shelburn', 'Shelbyville', 'Shoals', 'South Bend', 'Spencer', 'Spurgeon', 'Stendal', 'Syracuse', 'Tell City', 'Terre Haute', 'Tipton', 'Valparaiso', 'Vevay', 'Vincennes', 'Wabash', 'Wanatah', 'Warsaw', 'Washington', 'West Lafayette', 'Wheatfield', 'Whiteland', 'Whitestown', 'Winamac', 'Winchester', 'Woodburn']\n"
     ]
    }
   ],
   "source": [
    "print(cities_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "city_list_lower = []\n",
    "for city in cities_list:\n",
    "    city_lower = city.lower()\n",
    "    city_list_lower.append(city_lower)\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['anderson', 'angola', 'atlanta', 'attica', 'auburn', 'bedford', 'berne', 'bloomfield', 'bloomington', 'bluffton', 'boonville', 'boswell', 'brookville', 'cambridge city', 'carmel', 'chalmers', 'charlestown', 'columbia city', 'columbus', 'crane', 'crawfordsville', 'decatur', 'delphi', 'dubois', 'elwood', 'english', 'evansville', 'farmland', 'fort wayne', 'fowler', 'francesville', 'frankfort', 'franklin', 'freelandville', 'garrett', 'goshen', 'grantsburg', 'greencastle', 'greenfield', 'greensburg', 'hartford city', 'hobart', 'huntington', 'indianapolis', 'indianapolis-eagle creek airpark', 'jamestown', 'kentland', 'knox', 'kokomo', 'la porte', 'lafayette', 'lagrange', 'lexington', 'logansport', 'lowell', 'madison', 'marion', 'martinsville', 'milan', 'mishawaka', 'mount vernon', 'muncie', 'new castle', 'north manchester', 'north vernon', 'oakland city', 'oolitic', 'paoli', 'perrysville', 'petersburg', 'plymouth', 'portland', 'princeton', 'rensselaer', 'richmond', 'rochester', 'rockville', 'rushville', 'saint meinrad', 'salem', 'scottsburg', 'seymour', 'shelburn', 'shelbyville', 'shoals', 'south bend', 'spencer', 'spurgeon', 'stendal', 'syracuse', 'tell city', 'terre haute', 'tipton', 'valparaiso', 'vevay', 'vincennes', 'wabash', 'wanatah', 'warsaw', 'washington', 'west lafayette', 'wheatfield', 'whiteland', 'whitestown', 'winamac', 'winchester', 'woodburn']\n"
     ]
    }
   ],
   "source": [
    "print(city_list_lower)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "bedford\n",
      "107\n"
     ]
    }
   ],
   "source": [
    "print(city_list_lower[5])\n",
    "print(len(city_list_lower))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "average_monthly = pd.DataFrame()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "for url in url_list:\n",
    "    main_url = \"https://www.usclimatedata.com\" + url\n",
    "    tables = pd.read_html(main_url)\n",
    "    df_1 = tables[0]\n",
    "    df_2 = tables[1]\n",
    "    df_3 = pd.merge(df_1,df_2, on = \"Unnamed: 0\",how=\"inner\")\n",
    "    url_split = url.split(\"/\")\n",
    "    df_3[\"City\"] = url_split[2].upper()\n",
    "    average_monthly = average_monthly.append(df_3)\n",
    "    \n",
    "\n",
    "  \n",
    "#/climate/woodburn/indiana/united-states/usin1385"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "scrolled": false
   },
   "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>Unnamed: 0</th>\n",
       "      <th>JanJa</th>\n",
       "      <th>FebFe</th>\n",
       "      <th>MarMa</th>\n",
       "      <th>AprAp</th>\n",
       "      <th>MayMa</th>\n",
       "      <th>JunJu</th>\n",
       "      <th>JulJu</th>\n",
       "      <th>AugAu</th>\n",
       "      <th>SepSe</th>\n",
       "      <th>OctOc</th>\n",
       "      <th>NovNo</th>\n",
       "      <th>DecDe</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Average high in ºFAv. highHi</td>\n",
       "      <td>51.00</td>\n",
       "      <td>64.00</td>\n",
       "      <td>76.00</td>\n",
       "      <td>83.00</td>\n",
       "      <td>84.00</td>\n",
       "      <td>81.00</td>\n",
       "      <td>72.00</td>\n",
       "      <td>62.00</td>\n",
       "      <td>39.00</td>\n",
       "      <td>50.0</td>\n",
       "      <td>34.00</td>\n",
       "      <td>38.00</td>\n",
       "      <td>ANDERSON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Average low in ºFAv. lowLo</td>\n",
       "      <td>34.00</td>\n",
       "      <td>43.00</td>\n",
       "      <td>54.00</td>\n",
       "      <td>62.00</td>\n",
       "      <td>64.00</td>\n",
       "      <td>60.00</td>\n",
       "      <td>51.00</td>\n",
       "      <td>41.00</td>\n",
       "      <td>23.00</td>\n",
       "      <td>31.0</td>\n",
       "      <td>19.00</td>\n",
       "      <td>23.00</td>\n",
       "      <td>ANDERSON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Av. precipitation in inchAv. precip.Pre.</td>\n",
       "      <td>3.78</td>\n",
       "      <td>3.09</td>\n",
       "      <td>2.97</td>\n",
       "      <td>3.36</td>\n",
       "      <td>4.43</td>\n",
       "      <td>4.28</td>\n",
       "      <td>4.44</td>\n",
       "      <td>3.86</td>\n",
       "      <td>2.26</td>\n",
       "      <td>3.3</td>\n",
       "      <td>2.51</td>\n",
       "      <td>3.16</td>\n",
       "      <td>ANDERSON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Av. snowfall in inchSnowfallSn</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>ANDERSON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Average high in ºFAv. highHi</td>\n",
       "      <td>30.00</td>\n",
       "      <td>34.00</td>\n",
       "      <td>45.00</td>\n",
       "      <td>58.00</td>\n",
       "      <td>69.00</td>\n",
       "      <td>78.00</td>\n",
       "      <td>82.00</td>\n",
       "      <td>80.00</td>\n",
       "      <td>73.00</td>\n",
       "      <td>61.0</td>\n",
       "      <td>48.00</td>\n",
       "      <td>34.00</td>\n",
       "      <td>ANGOLA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Average high in ºFAv. highHi</td>\n",
       "      <td>32.00</td>\n",
       "      <td>36.00</td>\n",
       "      <td>47.00</td>\n",
       "      <td>60.00</td>\n",
       "      <td>70.00</td>\n",
       "      <td>80.00</td>\n",
       "      <td>83.00</td>\n",
       "      <td>81.00</td>\n",
       "      <td>75.00</td>\n",
       "      <td>63.0</td>\n",
       "      <td>49.00</td>\n",
       "      <td>37.00</td>\n",
       "      <td>WINCHESTER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Average low in ºFAv. lowLo</td>\n",
       "      <td>16.00</td>\n",
       "      <td>19.00</td>\n",
       "      <td>29.00</td>\n",
       "      <td>40.00</td>\n",
       "      <td>51.00</td>\n",
       "      <td>60.00</td>\n",
       "      <td>63.00</td>\n",
       "      <td>61.00</td>\n",
       "      <td>54.00</td>\n",
       "      <td>42.0</td>\n",
       "      <td>33.00</td>\n",
       "      <td>22.00</td>\n",
       "      <td>WINCHESTER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Av. precipitation in inchAv. precip.Pre.</td>\n",
       "      <td>1.93</td>\n",
       "      <td>1.61</td>\n",
       "      <td>2.91</td>\n",
       "      <td>3.62</td>\n",
       "      <td>4.13</td>\n",
       "      <td>4.33</td>\n",
       "      <td>4.29</td>\n",
       "      <td>3.62</td>\n",
       "      <td>2.80</td>\n",
       "      <td>2.6</td>\n",
       "      <td>3.19</td>\n",
       "      <td>2.76</td>\n",
       "      <td>WINCHESTER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Average high in ºFAv. highHi</td>\n",
       "      <td>31.00</td>\n",
       "      <td>35.00</td>\n",
       "      <td>47.00</td>\n",
       "      <td>60.00</td>\n",
       "      <td>71.00</td>\n",
       "      <td>80.00</td>\n",
       "      <td>84.00</td>\n",
       "      <td>82.00</td>\n",
       "      <td>75.00</td>\n",
       "      <td>63.0</td>\n",
       "      <td>49.00</td>\n",
       "      <td>35.00</td>\n",
       "      <td>WOODBURN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Average low in ºFAv. lowLo</td>\n",
       "      <td>16.00</td>\n",
       "      <td>19.00</td>\n",
       "      <td>28.00</td>\n",
       "      <td>38.00</td>\n",
       "      <td>48.00</td>\n",
       "      <td>60.00</td>\n",
       "      <td>61.00</td>\n",
       "      <td>60.00</td>\n",
       "      <td>51.00</td>\n",
       "      <td>41.0</td>\n",
       "      <td>31.00</td>\n",
       "      <td>22.00</td>\n",
       "      <td>WOODBURN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>385 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  Unnamed: 0  JanJa  FebFe  MarMa  AprAp  \\\n",
       "0               Average high in ºFAv. highHi  51.00  64.00  76.00  83.00   \n",
       "1                 Average low in ºFAv. lowLo  34.00  43.00  54.00  62.00   \n",
       "2   Av. precipitation in inchAv. precip.Pre.   3.78   3.09   2.97   3.36   \n",
       "3             Av. snowfall in inchSnowfallSn   1.00   0.00   0.00   0.00   \n",
       "0               Average high in ºFAv. highHi  30.00  34.00  45.00  58.00   \n",
       "..                                       ...    ...    ...    ...    ...   \n",
       "0               Average high in ºFAv. highHi  32.00  36.00  47.00  60.00   \n",
       "1                 Average low in ºFAv. lowLo  16.00  19.00  29.00  40.00   \n",
       "2   Av. precipitation in inchAv. precip.Pre.   1.93   1.61   2.91   3.62   \n",
       "0               Average high in ºFAv. highHi  31.00  35.00  47.00  60.00   \n",
       "1                 Average low in ºFAv. lowLo  16.00  19.00  28.00  38.00   \n",
       "\n",
       "    MayMa  JunJu  JulJu  AugAu  SepSe  OctOc  NovNo  DecDe        City  \n",
       "0   84.00  81.00  72.00  62.00  39.00   50.0  34.00  38.00    ANDERSON  \n",
       "1   64.00  60.00  51.00  41.00  23.00   31.0  19.00  23.00    ANDERSON  \n",
       "2    4.43   4.28   4.44   3.86   2.26    3.3   2.51   3.16    ANDERSON  \n",
       "3    0.00   0.00   0.00   0.00   5.00    2.0   7.00   5.00    ANDERSON  \n",
       "0   69.00  78.00  82.00  80.00  73.00   61.0  48.00  34.00      ANGOLA  \n",
       "..    ...    ...    ...    ...    ...    ...    ...    ...         ...  \n",
       "0   70.00  80.00  83.00  81.00  75.00   63.0  49.00  37.00  WINCHESTER  \n",
       "1   51.00  60.00  63.00  61.00  54.00   42.0  33.00  22.00  WINCHESTER  \n",
       "2    4.13   4.33   4.29   3.62   2.80    2.6   3.19   2.76  WINCHESTER  \n",
       "0   71.00  80.00  84.00  82.00  75.00   63.0  49.00  35.00    WOODBURN  \n",
       "1   48.00  60.00  61.00  60.00  51.00   41.0  31.00  22.00    WOODBURN  \n",
       "\n",
       "[385 rows x 14 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "average_monthly"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The following cell is just to practice the splitting and the indexing the right component."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "for url in url_list:\n",
    "    url_split = url.split(\"/\")\n",
    "    #print(url_split[2].upper())\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "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>Unnamed: 0</th>\n",
       "      <th>January</th>\n",
       "      <th>February</th>\n",
       "      <th>March</th>\n",
       "      <th>April</th>\n",
       "      <th>May</th>\n",
       "      <th>June</th>\n",
       "      <th>July</th>\n",
       "      <th>August</th>\n",
       "      <th>September</th>\n",
       "      <th>October</th>\n",
       "      <th>November</th>\n",
       "      <th>December</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Average high in ºFAv. highHi</td>\n",
       "      <td>51.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>ANDERSON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Average high in ºFAv. highHi</td>\n",
       "      <td>30.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>ANGOLA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Average high in ºFAv. highHi</td>\n",
       "      <td>33.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>ATLANTA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Average high in ºFAv. highHi</td>\n",
       "      <td>33.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>ATTICA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Average high in ºFAv. highHi</td>\n",
       "      <td>31.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>AUBURN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Unnamed: 0  January  February  March  April   May  June  \\\n",
       "0  Average high in ºFAv. highHi     51.0      64.0   76.0   83.0  84.0  81.0   \n",
       "0  Average high in ºFAv. highHi     30.0      34.0   45.0   58.0  69.0  78.0   \n",
       "0  Average high in ºFAv. highHi     33.0      37.0   48.0   61.0  71.0  81.0   \n",
       "0  Average high in ºFAv. highHi     33.0      37.0   49.0   62.0  72.0  82.0   \n",
       "0  Average high in ºFAv. highHi     31.0      36.0   48.0   60.0  72.0  81.0   \n",
       "\n",
       "   July  August  September  October  November  December      City  \n",
       "0  72.0    62.0       39.0     50.0      34.0      38.0  ANDERSON  \n",
       "0  82.0    80.0       73.0     61.0      48.0      34.0    ANGOLA  \n",
       "0  84.0    82.0       77.0     64.0      51.0      37.0   ATLANTA  \n",
       "0  84.0    82.0       77.0     65.0      51.0      37.0    ATTICA  \n",
       "0  84.0    82.0       75.0     63.0      49.0      37.0    AUBURN  "
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "highs = average_monthly.loc[average_monthly[\"Unnamed: 0\"]==\"Average high in ºFAv. highHi\"]\n",
    "#jan_high = highs[\"JanJa\"]\n",
    "#jan_high\n",
    "#jan_high_transpose = jan_high.transpose()\n",
    "#jan_high_transpose\n",
    "highs = highs.rename(columns = {\"JanJa\":\"January\",\"FebFe\":\"February\",\"MarMa\":\"March\",\"AprAp\":\"April\",\"MayMa\":\"May\",\n",
    "                     \"JunJu\":\"June\",\"JulJu\":\"July\",\"AugAu\":\"August\",\"SepSe\":\"September\",\"OctOc\":\"October\",\n",
    "                     \"NovNo\":\"November\",\"DecDe\":\"December\"})\n",
    "highs.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "metadata": {
    "scrolled": false
   },
   "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>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ANDERSON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ANGOLA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ATLANTA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ATTICA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AUBURN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       City\n",
       "0  ANDERSON\n",
       "0    ANGOLA\n",
       "0   ATLANTA\n",
       "0    ATTICA\n",
       "0    AUBURN"
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "month_list = [\"January\",\"February\",\"March\",\"April\",\"May\",\"June\",\"July\",\"August\",\"September\",\"October\",\"November\",\"December\"]\n",
    "monthly_highs = pd.DataFrame(highs[\"City\"])\n",
    "monthly_highs.head()\n",
    "#print(len(monthly_highs[\"City\"]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "\n",
    "for month in month_list:\n",
    "    #highs_list = highs[month].to_list()\n",
    "    #df_transpose = df.transpose()\n",
    "    cities = highs[\"City\"].to_list()\n",
    "    highs_data = highs[month].to_list()\n",
    "    monthly_highs[month + \" Avg High\"] = highs_data\n",
    "    #new_df = pd.DataFrame(cities,highs_data,columns = [\"City\",month])\n",
    "    #monthly_highs = monthly_highs.append(new_df)\n",
    "    #monthly_highs = pd.merge(monthly_highs,new_df, on = \"City\",how=\"inner\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "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>City</th>\n",
       "      <th>January Avg High</th>\n",
       "      <th>February Avg High</th>\n",
       "      <th>March Avg High</th>\n",
       "      <th>April Avg High</th>\n",
       "      <th>May Avg High</th>\n",
       "      <th>June Avg High</th>\n",
       "      <th>July Avg High</th>\n",
       "      <th>August Avg High</th>\n",
       "      <th>September Avg High</th>\n",
       "      <th>October Avg High</th>\n",
       "      <th>November Avg High</th>\n",
       "      <th>December Avg High</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ANDERSON</td>\n",
       "      <td>51.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ANGOLA</td>\n",
       "      <td>30.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>34.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ATLANTA</td>\n",
       "      <td>33.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>37.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ATTICA</td>\n",
       "      <td>33.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>37.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AUBURN</td>\n",
       "      <td>31.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>37.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>WHITELAND</td>\n",
       "      <td>35.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>WHITESTOWN</td>\n",
       "      <td>34.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>37.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>WINAMAC</td>\n",
       "      <td>32.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>WINCHESTER</td>\n",
       "      <td>32.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>37.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>WOODBURN</td>\n",
       "      <td>31.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>107 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          City  January Avg High  February Avg High  March Avg High  \\\n",
       "0     ANDERSON              51.0               64.0            76.0   \n",
       "0       ANGOLA              30.0               34.0            45.0   \n",
       "0      ATLANTA              33.0               37.0            48.0   \n",
       "0       ATTICA              33.0               37.0            49.0   \n",
       "0       AUBURN              31.0               36.0            48.0   \n",
       "..         ...               ...                ...             ...   \n",
       "0    WHITELAND              35.0               39.0            51.0   \n",
       "0   WHITESTOWN              34.0               39.0            51.0   \n",
       "0      WINAMAC              32.0               36.0            48.0   \n",
       "0   WINCHESTER              32.0               36.0            47.0   \n",
       "0     WOODBURN              31.0               35.0            47.0   \n",
       "\n",
       "    April Avg High  May Avg High  June Avg High  July Avg High  \\\n",
       "0             83.0          84.0           81.0           72.0   \n",
       "0             58.0          69.0           78.0           82.0   \n",
       "0             61.0          71.0           81.0           84.0   \n",
       "0             62.0          72.0           82.0           84.0   \n",
       "0             60.0          72.0           81.0           84.0   \n",
       "..             ...           ...            ...            ...   \n",
       "0             63.0          73.0           81.0           84.0   \n",
       "0             64.0          74.0           82.0           85.0   \n",
       "0             60.0          71.0           80.0           83.0   \n",
       "0             60.0          70.0           80.0           83.0   \n",
       "0             60.0          71.0           80.0           84.0   \n",
       "\n",
       "    August Avg High  September Avg High  October Avg High  November Avg High  \\\n",
       "0              62.0                39.0              50.0               34.0   \n",
       "0              80.0                73.0              61.0               48.0   \n",
       "0              82.0                77.0              64.0               51.0   \n",
       "0              82.0                77.0              65.0               51.0   \n",
       "0              82.0                75.0              63.0               49.0   \n",
       "..              ...                 ...               ...                ...   \n",
       "0              83.0                78.0              65.0               52.0   \n",
       "0              83.0                77.0              65.0               51.0   \n",
       "0              81.0                76.0              64.0               49.0   \n",
       "0              81.0                75.0              63.0               49.0   \n",
       "0              82.0                75.0              63.0               49.0   \n",
       "\n",
       "    December Avg High  \n",
       "0                38.0  \n",
       "0                34.0  \n",
       "0                37.0  \n",
       "0                37.0  \n",
       "0                37.0  \n",
       "..                ...  \n",
       "0                38.0  \n",
       "0                37.0  \n",
       "0                35.0  \n",
       "0                37.0  \n",
       "0                35.0  \n",
       "\n",
       "[107 rows x 13 columns]"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "monthly_highs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "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>Unnamed: 0</th>\n",
       "      <th>January</th>\n",
       "      <th>February</th>\n",
       "      <th>March</th>\n",
       "      <th>April</th>\n",
       "      <th>May</th>\n",
       "      <th>June</th>\n",
       "      <th>July</th>\n",
       "      <th>August</th>\n",
       "      <th>September</th>\n",
       "      <th>October</th>\n",
       "      <th>November</th>\n",
       "      <th>December</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Average low in ºFAv. lowLo</td>\n",
       "      <td>34.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>ANDERSON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Average low in ºFAv. lowLo</td>\n",
       "      <td>15.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>ANGOLA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Average low in ºFAv. lowLo</td>\n",
       "      <td>17.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>ATLANTA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Average low in ºFAv. lowLo</td>\n",
       "      <td>16.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>ATTICA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Average low in ºFAv. lowLo</td>\n",
       "      <td>17.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>AUBURN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Unnamed: 0  January  February  March  April   May  June  \\\n",
       "1  Average low in ºFAv. lowLo     34.0      43.0   54.0   62.0  64.0  60.0   \n",
       "1  Average low in ºFAv. lowLo     15.0      17.0   25.0   36.0  47.0  57.0   \n",
       "1  Average low in ºFAv. lowLo     17.0      20.0   28.0   38.0  49.0  59.0   \n",
       "1  Average low in ºFAv. lowLo     16.0      20.0   29.0   40.0  51.0  61.0   \n",
       "1  Average low in ºFAv. lowLo     17.0      20.0   29.0   39.0  49.0  58.0   \n",
       "\n",
       "   July  August  September  October  November  December      City  \n",
       "1  51.0    41.0       23.0     31.0      19.0      23.0  ANDERSON  \n",
       "1  61.0    59.0       50.0     39.0      30.0      20.0    ANGOLA  \n",
       "1  62.0    59.0       52.0     40.0      32.0      21.0   ATLANTA  \n",
       "1  63.0    61.0       53.0     42.0      32.0      21.0    ATTICA  \n",
       "1  62.0    60.0       54.0     43.0      34.0      23.0    AUBURN  "
      ]
     },
     "execution_count": 93,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lows = average_monthly.loc[average_monthly[\"Unnamed: 0\"]==\"Average low in ºFAv. lowLo\"]\n",
    "\n",
    "lows = lows.rename(columns = {\"JanJa\":\"January\",\"FebFe\":\"February\",\"MarMa\":\"March\",\"AprAp\":\"April\",\"MayMa\":\"May\",\n",
    "                     \"JunJu\":\"June\",\"JulJu\":\"July\",\"AugAu\":\"August\",\"SepSe\":\"September\",\"OctOc\":\"October\",\n",
    "                     \"NovNo\":\"November\",\"DecDe\":\"December\"})\n",
    "lows.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "metadata": {},
   "outputs": [],
   "source": [
    "monthly_lows = pd.DataFrame(lows[\"City\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "metadata": {},
   "outputs": [],
   "source": [
    "for month in month_list:\n",
    "    cities = lows[\"City\"].to_list()\n",
    "    lows_data = lows[month].to_list()\n",
    "    monthly_lows[month + \" Avg Low\"] = lows_data\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 177,
   "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>City</th>\n",
       "      <th>January Avg Low</th>\n",
       "      <th>February Avg Low</th>\n",
       "      <th>March Avg Low</th>\n",
       "      <th>April Avg Low</th>\n",
       "      <th>May Avg Low</th>\n",
       "      <th>June Avg Low</th>\n",
       "      <th>July Avg Low</th>\n",
       "      <th>August Avg Low</th>\n",
       "      <th>September Avg Low</th>\n",
       "      <th>October Avg Low</th>\n",
       "      <th>November Avg Low</th>\n",
       "      <th>December Avg Low</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ANDERSON</td>\n",
       "      <td>34.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ANGOLA</td>\n",
       "      <td>15.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ATLANTA</td>\n",
       "      <td>17.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ATTICA</td>\n",
       "      <td>16.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AUBURN</td>\n",
       "      <td>17.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>WHITELAND</td>\n",
       "      <td>18.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>WHITESTOWN</td>\n",
       "      <td>19.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>WINAMAC</td>\n",
       "      <td>16.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>WINCHESTER</td>\n",
       "      <td>16.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>WOODBURN</td>\n",
       "      <td>16.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>107 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          City  January Avg Low  February Avg Low  March Avg Low  \\\n",
       "1     ANDERSON             34.0              43.0           54.0   \n",
       "1       ANGOLA             15.0              17.0           25.0   \n",
       "1      ATLANTA             17.0              20.0           28.0   \n",
       "1       ATTICA             16.0              20.0           29.0   \n",
       "1       AUBURN             17.0              20.0           29.0   \n",
       "..         ...              ...               ...            ...   \n",
       "1    WHITELAND             18.0              22.0           30.0   \n",
       "1   WHITESTOWN             19.0              23.0           32.0   \n",
       "1      WINAMAC             16.0              19.0           28.0   \n",
       "1   WINCHESTER             16.0              19.0           29.0   \n",
       "1     WOODBURN             16.0              19.0           28.0   \n",
       "\n",
       "    April Avg Low  May Avg Low  June Avg Low  July Avg Low  August Avg Low  \\\n",
       "1            62.0         64.0          60.0          51.0            41.0   \n",
       "1            36.0         47.0          57.0          61.0            59.0   \n",
       "1            38.0         49.0          59.0          62.0            59.0   \n",
       "1            40.0         51.0          61.0          63.0            61.0   \n",
       "1            39.0         49.0          58.0          62.0            60.0   \n",
       "..            ...          ...           ...           ...             ...   \n",
       "1            42.0         52.0          61.0          64.0            61.0   \n",
       "1            42.0         52.0          61.0          64.0            62.0   \n",
       "1            39.0         50.0          59.0          63.0            61.0   \n",
       "1            40.0         51.0          60.0          63.0            61.0   \n",
       "1            38.0         48.0          60.0          61.0            60.0   \n",
       "\n",
       "    September Avg Low  October Avg Low  November Avg Low  December Avg Low  \n",
       "1                23.0             31.0              19.0              23.0  \n",
       "1                50.0             39.0              30.0              20.0  \n",
       "1                52.0             40.0              32.0              21.0  \n",
       "1                53.0             42.0              32.0              21.0  \n",
       "1                54.0             43.0              34.0              23.0  \n",
       "..                ...              ...               ...               ...  \n",
       "1                53.0             42.0              33.0              23.0  \n",
       "1                54.0             44.0              35.0              24.0  \n",
       "1                53.0             41.0              32.0              20.0  \n",
       "1                54.0             42.0              33.0              22.0  \n",
       "1                51.0             41.0              31.0              22.0  \n",
       "\n",
       "[107 rows x 13 columns]"
      ]
     },
     "execution_count": 177,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "monthly_lows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "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>Unnamed: 0</th>\n",
       "      <th>January</th>\n",
       "      <th>February</th>\n",
       "      <th>March</th>\n",
       "      <th>April</th>\n",
       "      <th>May</th>\n",
       "      <th>June</th>\n",
       "      <th>July</th>\n",
       "      <th>August</th>\n",
       "      <th>September</th>\n",
       "      <th>October</th>\n",
       "      <th>November</th>\n",
       "      <th>December</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Av. precipitation in inchAv. precip.Pre.</td>\n",
       "      <td>3.78</td>\n",
       "      <td>3.09</td>\n",
       "      <td>2.97</td>\n",
       "      <td>3.36</td>\n",
       "      <td>4.43</td>\n",
       "      <td>4.28</td>\n",
       "      <td>4.44</td>\n",
       "      <td>3.86</td>\n",
       "      <td>2.26</td>\n",
       "      <td>3.30</td>\n",
       "      <td>2.51</td>\n",
       "      <td>3.16</td>\n",
       "      <td>ANDERSON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Av. precipitation in inchAv. precip.Pre.</td>\n",
       "      <td>2.28</td>\n",
       "      <td>2.12</td>\n",
       "      <td>2.61</td>\n",
       "      <td>3.37</td>\n",
       "      <td>4.37</td>\n",
       "      <td>3.88</td>\n",
       "      <td>4.00</td>\n",
       "      <td>4.14</td>\n",
       "      <td>3.37</td>\n",
       "      <td>2.95</td>\n",
       "      <td>3.15</td>\n",
       "      <td>2.74</td>\n",
       "      <td>ANGOLA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Av. precipitation in inchAv. precip.Pre.</td>\n",
       "      <td>2.26</td>\n",
       "      <td>2.11</td>\n",
       "      <td>3.03</td>\n",
       "      <td>3.72</td>\n",
       "      <td>4.52</td>\n",
       "      <td>4.49</td>\n",
       "      <td>4.30</td>\n",
       "      <td>2.91</td>\n",
       "      <td>3.11</td>\n",
       "      <td>2.83</td>\n",
       "      <td>3.39</td>\n",
       "      <td>2.94</td>\n",
       "      <td>ATLANTA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Av. precipitation in inchAv. precip.Pre.</td>\n",
       "      <td>1.97</td>\n",
       "      <td>1.91</td>\n",
       "      <td>2.81</td>\n",
       "      <td>3.73</td>\n",
       "      <td>4.48</td>\n",
       "      <td>4.13</td>\n",
       "      <td>4.54</td>\n",
       "      <td>3.65</td>\n",
       "      <td>2.79</td>\n",
       "      <td>3.19</td>\n",
       "      <td>3.38</td>\n",
       "      <td>2.55</td>\n",
       "      <td>ATTICA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Av. precipitation in inchAv. precip.Pre.</td>\n",
       "      <td>1.81</td>\n",
       "      <td>1.42</td>\n",
       "      <td>2.56</td>\n",
       "      <td>3.35</td>\n",
       "      <td>3.70</td>\n",
       "      <td>4.17</td>\n",
       "      <td>3.70</td>\n",
       "      <td>2.83</td>\n",
       "      <td>3.62</td>\n",
       "      <td>2.64</td>\n",
       "      <td>3.15</td>\n",
       "      <td>2.52</td>\n",
       "      <td>AUBURN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 Unnamed: 0  January  February  March  April  \\\n",
       "2  Av. precipitation in inchAv. precip.Pre.     3.78      3.09   2.97   3.36   \n",
       "2  Av. precipitation in inchAv. precip.Pre.     2.28      2.12   2.61   3.37   \n",
       "2  Av. precipitation in inchAv. precip.Pre.     2.26      2.11   3.03   3.72   \n",
       "2  Av. precipitation in inchAv. precip.Pre.     1.97      1.91   2.81   3.73   \n",
       "2  Av. precipitation in inchAv. precip.Pre.     1.81      1.42   2.56   3.35   \n",
       "\n",
       "    May  June  July  August  September  October  November  December      City  \n",
       "2  4.43  4.28  4.44    3.86       2.26     3.30      2.51      3.16  ANDERSON  \n",
       "2  4.37  3.88  4.00    4.14       3.37     2.95      3.15      2.74    ANGOLA  \n",
       "2  4.52  4.49  4.30    2.91       3.11     2.83      3.39      2.94   ATLANTA  \n",
       "2  4.48  4.13  4.54    3.65       2.79     3.19      3.38      2.55    ATTICA  \n",
       "2  3.70  4.17  3.70    2.83       3.62     2.64      3.15      2.52    AUBURN  "
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "precipitation = average_monthly.loc[average_monthly[\"Unnamed: 0\"]==\"Av. precipitation in inchAv. precip.Pre.\"]\n",
    "\n",
    "precipitation = precipitation.rename(columns = {\"JanJa\":\"January\",\"FebFe\":\"February\",\"MarMa\":\"March\",\"AprAp\":\"April\",\"MayMa\":\"May\",\n",
    "                     \"JunJu\":\"June\",\"JulJu\":\"July\",\"AugAu\":\"August\",\"SepSe\":\"September\",\"OctOc\":\"October\",\n",
    "                     \"NovNo\":\"November\",\"DecDe\":\"December\"})\n",
    "precipitation.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "metadata": {},
   "outputs": [],
   "source": [
    "monthly_precipitation = pd.DataFrame(precipitation[\"City\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "metadata": {},
   "outputs": [],
   "source": [
    "for month in month_list:\n",
    "    cities = precipitation[\"City\"].to_list()\n",
    "    precip_data = precipitation[month].to_list()\n",
    "    monthly_precipitation[month + \" Avg Precipitation\"] = precip_data\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 178,
   "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>City</th>\n",
       "      <th>January Avg Precipitation</th>\n",
       "      <th>February Avg Precipitation</th>\n",
       "      <th>March Avg Precipitation</th>\n",
       "      <th>April Avg Precipitation</th>\n",
       "      <th>May Avg Precipitation</th>\n",
       "      <th>June Avg Precipitation</th>\n",
       "      <th>July Avg Precipitation</th>\n",
       "      <th>August Avg Precipitation</th>\n",
       "      <th>September Avg Precipitation</th>\n",
       "      <th>October Avg Precipitation</th>\n",
       "      <th>November Avg Precipitation</th>\n",
       "      <th>December Avg Precipitation</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ANDERSON</td>\n",
       "      <td>3.78</td>\n",
       "      <td>3.09</td>\n",
       "      <td>2.97</td>\n",
       "      <td>3.36</td>\n",
       "      <td>4.43</td>\n",
       "      <td>4.28</td>\n",
       "      <td>4.44</td>\n",
       "      <td>3.86</td>\n",
       "      <td>2.26</td>\n",
       "      <td>3.30</td>\n",
       "      <td>2.51</td>\n",
       "      <td>3.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ANGOLA</td>\n",
       "      <td>2.28</td>\n",
       "      <td>2.12</td>\n",
       "      <td>2.61</td>\n",
       "      <td>3.37</td>\n",
       "      <td>4.37</td>\n",
       "      <td>3.88</td>\n",
       "      <td>4.00</td>\n",
       "      <td>4.14</td>\n",
       "      <td>3.37</td>\n",
       "      <td>2.95</td>\n",
       "      <td>3.15</td>\n",
       "      <td>2.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ATLANTA</td>\n",
       "      <td>2.26</td>\n",
       "      <td>2.11</td>\n",
       "      <td>3.03</td>\n",
       "      <td>3.72</td>\n",
       "      <td>4.52</td>\n",
       "      <td>4.49</td>\n",
       "      <td>4.30</td>\n",
       "      <td>2.91</td>\n",
       "      <td>3.11</td>\n",
       "      <td>2.83</td>\n",
       "      <td>3.39</td>\n",
       "      <td>2.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ATTICA</td>\n",
       "      <td>1.97</td>\n",
       "      <td>1.91</td>\n",
       "      <td>2.81</td>\n",
       "      <td>3.73</td>\n",
       "      <td>4.48</td>\n",
       "      <td>4.13</td>\n",
       "      <td>4.54</td>\n",
       "      <td>3.65</td>\n",
       "      <td>2.79</td>\n",
       "      <td>3.19</td>\n",
       "      <td>3.38</td>\n",
       "      <td>2.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AUBURN</td>\n",
       "      <td>1.81</td>\n",
       "      <td>1.42</td>\n",
       "      <td>2.56</td>\n",
       "      <td>3.35</td>\n",
       "      <td>3.70</td>\n",
       "      <td>4.17</td>\n",
       "      <td>3.70</td>\n",
       "      <td>2.83</td>\n",
       "      <td>3.62</td>\n",
       "      <td>2.64</td>\n",
       "      <td>3.15</td>\n",
       "      <td>2.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>WEST-LAFAYETTE</td>\n",
       "      <td>1.92</td>\n",
       "      <td>1.86</td>\n",
       "      <td>2.61</td>\n",
       "      <td>3.58</td>\n",
       "      <td>4.76</td>\n",
       "      <td>4.09</td>\n",
       "      <td>4.20</td>\n",
       "      <td>3.61</td>\n",
       "      <td>2.82</td>\n",
       "      <td>3.05</td>\n",
       "      <td>3.24</td>\n",
       "      <td>2.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>WHEATFIELD</td>\n",
       "      <td>1.65</td>\n",
       "      <td>1.42</td>\n",
       "      <td>2.72</td>\n",
       "      <td>3.70</td>\n",
       "      <td>3.86</td>\n",
       "      <td>4.61</td>\n",
       "      <td>4.13</td>\n",
       "      <td>3.66</td>\n",
       "      <td>3.46</td>\n",
       "      <td>2.64</td>\n",
       "      <td>2.91</td>\n",
       "      <td>2.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>WHITESTOWN</td>\n",
       "      <td>2.69</td>\n",
       "      <td>2.55</td>\n",
       "      <td>3.31</td>\n",
       "      <td>3.90</td>\n",
       "      <td>4.91</td>\n",
       "      <td>4.47</td>\n",
       "      <td>4.38</td>\n",
       "      <td>3.11</td>\n",
       "      <td>3.32</td>\n",
       "      <td>3.01</td>\n",
       "      <td>3.77</td>\n",
       "      <td>3.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>WINAMAC</td>\n",
       "      <td>2.13</td>\n",
       "      <td>1.90</td>\n",
       "      <td>2.44</td>\n",
       "      <td>3.31</td>\n",
       "      <td>4.14</td>\n",
       "      <td>3.97</td>\n",
       "      <td>4.82</td>\n",
       "      <td>3.95</td>\n",
       "      <td>3.17</td>\n",
       "      <td>3.35</td>\n",
       "      <td>3.22</td>\n",
       "      <td>2.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>WINCHESTER</td>\n",
       "      <td>1.93</td>\n",
       "      <td>1.61</td>\n",
       "      <td>2.91</td>\n",
       "      <td>3.62</td>\n",
       "      <td>4.13</td>\n",
       "      <td>4.33</td>\n",
       "      <td>4.29</td>\n",
       "      <td>3.62</td>\n",
       "      <td>2.80</td>\n",
       "      <td>2.60</td>\n",
       "      <td>3.19</td>\n",
       "      <td>2.76</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>103 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              City  January Avg Precipitation  February Avg Precipitation  \\\n",
       "2         ANDERSON                       3.78                        3.09   \n",
       "2           ANGOLA                       2.28                        2.12   \n",
       "2          ATLANTA                       2.26                        2.11   \n",
       "2           ATTICA                       1.97                        1.91   \n",
       "2           AUBURN                       1.81                        1.42   \n",
       "..             ...                        ...                         ...   \n",
       "2   WEST-LAFAYETTE                       1.92                        1.86   \n",
       "2       WHEATFIELD                       1.65                        1.42   \n",
       "2       WHITESTOWN                       2.69                        2.55   \n",
       "2          WINAMAC                       2.13                        1.90   \n",
       "2       WINCHESTER                       1.93                        1.61   \n",
       "\n",
       "    March Avg Precipitation  April Avg Precipitation  May Avg Precipitation  \\\n",
       "2                      2.97                     3.36                   4.43   \n",
       "2                      2.61                     3.37                   4.37   \n",
       "2                      3.03                     3.72                   4.52   \n",
       "2                      2.81                     3.73                   4.48   \n",
       "2                      2.56                     3.35                   3.70   \n",
       "..                      ...                      ...                    ...   \n",
       "2                      2.61                     3.58                   4.76   \n",
       "2                      2.72                     3.70                   3.86   \n",
       "2                      3.31                     3.90                   4.91   \n",
       "2                      2.44                     3.31                   4.14   \n",
       "2                      2.91                     3.62                   4.13   \n",
       "\n",
       "    June Avg Precipitation  July Avg Precipitation  August Avg Precipitation  \\\n",
       "2                     4.28                    4.44                      3.86   \n",
       "2                     3.88                    4.00                      4.14   \n",
       "2                     4.49                    4.30                      2.91   \n",
       "2                     4.13                    4.54                      3.65   \n",
       "2                     4.17                    3.70                      2.83   \n",
       "..                     ...                     ...                       ...   \n",
       "2                     4.09                    4.20                      3.61   \n",
       "2                     4.61                    4.13                      3.66   \n",
       "2                     4.47                    4.38                      3.11   \n",
       "2                     3.97                    4.82                      3.95   \n",
       "2                     4.33                    4.29                      3.62   \n",
       "\n",
       "    September Avg Precipitation  October Avg Precipitation  \\\n",
       "2                          2.26                       3.30   \n",
       "2                          3.37                       2.95   \n",
       "2                          3.11                       2.83   \n",
       "2                          2.79                       3.19   \n",
       "2                          3.62                       2.64   \n",
       "..                          ...                        ...   \n",
       "2                          2.82                       3.05   \n",
       "2                          3.46                       2.64   \n",
       "2                          3.32                       3.01   \n",
       "2                          3.17                       3.35   \n",
       "2                          2.80                       2.60   \n",
       "\n",
       "    November Avg Precipitation  December Avg Precipitation  \n",
       "2                         2.51                        3.16  \n",
       "2                         3.15                        2.74  \n",
       "2                         3.39                        2.94  \n",
       "2                         3.38                        2.55  \n",
       "2                         3.15                        2.52  \n",
       "..                         ...                         ...  \n",
       "2                         3.24                        2.45  \n",
       "2                         2.91                        2.64  \n",
       "2                         3.77                        3.33  \n",
       "2                         3.22                        2.50  \n",
       "2                         3.19                        2.76  \n",
       "\n",
       "[103 rows x 13 columns]"
      ]
     },
     "execution_count": 178,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "monthly_precipitation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "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>Unnamed: 0</th>\n",
       "      <th>January</th>\n",
       "      <th>February</th>\n",
       "      <th>March</th>\n",
       "      <th>April</th>\n",
       "      <th>May</th>\n",
       "      <th>June</th>\n",
       "      <th>July</th>\n",
       "      <th>August</th>\n",
       "      <th>September</th>\n",
       "      <th>October</th>\n",
       "      <th>November</th>\n",
       "      <th>December</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Av. snowfall in inchSnowfallSn</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>ANDERSON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Av. snowfall in inchSnowfallSn</td>\n",
       "      <td>11.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>ANGOLA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Av. snowfall in inchSnowfallSn</td>\n",
       "      <td>10.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>ATLANTA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Av. snowfall in inchSnowfallSn</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>ATTICA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Av. snowfall in inchSnowfallSn</td>\n",
       "      <td>8.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>BERNE</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Unnamed: 0  January  February  March  April  May  June  \\\n",
       "3  Av. snowfall in inchSnowfallSn      1.0       0.0    0.0    0.0  0.0   0.0   \n",
       "3  Av. snowfall in inchSnowfallSn     11.0       9.0    5.0    1.0  0.0   0.0   \n",
       "3  Av. snowfall in inchSnowfallSn     10.0       6.0    3.0    0.0  0.0   0.0   \n",
       "3  Av. snowfall in inchSnowfallSn      8.0       6.0    3.0    0.0  0.0   0.0   \n",
       "3  Av. snowfall in inchSnowfallSn      8.0       7.0    4.0    1.0  0.0   0.0   \n",
       "\n",
       "   July  August  September  October  November  December      City  \n",
       "3   0.0     0.0        5.0      2.0       7.0       5.0  ANDERSON  \n",
       "3   0.0     0.0        0.0      0.0       2.0      10.0    ANGOLA  \n",
       "3   0.0     0.0        0.0      0.0       1.0       8.0   ATLANTA  \n",
       "3   0.0     0.0        0.0      0.0       1.0       6.0    ATTICA  \n",
       "3   0.0     0.0        0.0      0.0       1.0       6.0     BERNE  "
      ]
     },
     "execution_count": 105,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "snowfall = average_monthly.loc[average_monthly[\"Unnamed: 0\"]==\"Av. snowfall in inchSnowfallSn\"]\n",
    "\n",
    "snowfall = snowfall.rename(columns = {\"JanJa\":\"January\",\"FebFe\":\"February\",\"MarMa\":\"March\",\"AprAp\":\"April\",\"MayMa\":\"May\",\n",
    "                     \"JunJu\":\"June\",\"JulJu\":\"July\",\"AugAu\":\"August\",\"SepSe\":\"September\",\"OctOc\":\"October\",\n",
    "                     \"NovNo\":\"November\",\"DecDe\":\"December\"})\n",
    "snowfall.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {},
   "outputs": [],
   "source": [
    "monthly_snowfall = pd.DataFrame(snowfall[\"City\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "metadata": {},
   "outputs": [],
   "source": [
    "for month in month_list:\n",
    "    cities = snowfall[\"City\"].to_list()\n",
    "    snowfall_data = snowfall[month].to_list()\n",
    "    monthly_snowfall[month + \" Avg Snowfall (in)\"] = snowfall_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 179,
   "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>City</th>\n",
       "      <th>January Avg Snowfall (in)</th>\n",
       "      <th>February Avg Snowfall (in)</th>\n",
       "      <th>March Avg Snowfall (in)</th>\n",
       "      <th>April Avg Snowfall (in)</th>\n",
       "      <th>May Avg Snowfall (in)</th>\n",
       "      <th>June Avg Snowfall (in)</th>\n",
       "      <th>July Avg Snowfall (in)</th>\n",
       "      <th>August Avg Snowfall (in)</th>\n",
       "      <th>September Avg Snowfall (in)</th>\n",
       "      <th>October Avg Snowfall (in)</th>\n",
       "      <th>November Avg Snowfall (in)</th>\n",
       "      <th>December Avg Snowfall (in)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ANDERSON</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ANGOLA</td>\n",
       "      <td>11.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ATLANTA</td>\n",
       "      <td>10.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ATTICA</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BERNE</td>\n",
       "      <td>8.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>WANATAH</td>\n",
       "      <td>12.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>WASHINGTON</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>WEST-LAFAYETTE</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>WHITESTOWN</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>WINAMAC</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>64 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              City  January Avg Snowfall (in)  February Avg Snowfall (in)  \\\n",
       "3         ANDERSON                        1.0                         0.0   \n",
       "3           ANGOLA                       11.0                         9.0   \n",
       "3          ATLANTA                       10.0                         6.0   \n",
       "3           ATTICA                        8.0                         6.0   \n",
       "3            BERNE                        8.0                         7.0   \n",
       "..             ...                        ...                         ...   \n",
       "3          WANATAH                       12.0                         9.0   \n",
       "3       WASHINGTON                        3.0                         2.0   \n",
       "3   WEST-LAFAYETTE                        5.0                         5.0   \n",
       "3       WHITESTOWN                        7.0                         7.0   \n",
       "3          WINAMAC                        9.0                         5.0   \n",
       "\n",
       "    March Avg Snowfall (in)  April Avg Snowfall (in)  May Avg Snowfall (in)  \\\n",
       "3                       0.0                      0.0                    0.0   \n",
       "3                       5.0                      1.0                    0.0   \n",
       "3                       3.0                      0.0                    0.0   \n",
       "3                       3.0                      0.0                    0.0   \n",
       "3                       4.0                      1.0                    0.0   \n",
       "..                      ...                      ...                    ...   \n",
       "3                       5.0                      1.0                    0.0   \n",
       "3                       1.0                      0.0                    0.0   \n",
       "3                       2.0                      1.0                    0.0   \n",
       "3                       2.0                      0.0                    0.0   \n",
       "3                       3.0                      1.0                    0.0   \n",
       "\n",
       "    June Avg Snowfall (in)  July Avg Snowfall (in)  August Avg Snowfall (in)  \\\n",
       "3                      0.0                     0.0                       0.0   \n",
       "3                      0.0                     0.0                       0.0   \n",
       "3                      0.0                     0.0                       0.0   \n",
       "3                      0.0                     0.0                       0.0   \n",
       "3                      0.0                     0.0                       0.0   \n",
       "..                     ...                     ...                       ...   \n",
       "3                      0.0                     0.0                       0.0   \n",
       "3                      0.0                     0.0                       0.0   \n",
       "3                      0.0                     0.0                       0.0   \n",
       "3                      0.0                     0.0                       0.0   \n",
       "3                      0.0                     0.0                       0.0   \n",
       "\n",
       "    September Avg Snowfall (in)  October Avg Snowfall (in)  \\\n",
       "3                           5.0                        2.0   \n",
       "3                           0.0                        0.0   \n",
       "3                           0.0                        0.0   \n",
       "3                           0.0                        0.0   \n",
       "3                           0.0                        0.0   \n",
       "..                          ...                        ...   \n",
       "3                           0.0                        0.0   \n",
       "3                           0.0                        0.0   \n",
       "3                           0.0                        0.0   \n",
       "3                           0.0                        0.0   \n",
       "3                           0.0                        0.0   \n",
       "\n",
       "    November Avg Snowfall (in)  December Avg Snowfall (in)  \n",
       "3                          7.0                         5.0  \n",
       "3                          2.0                        10.0  \n",
       "3                          1.0                         8.0  \n",
       "3                          1.0                         6.0  \n",
       "3                          1.0                         6.0  \n",
       "..                         ...                         ...  \n",
       "3                          2.0                         9.0  \n",
       "3                          0.0                         3.0  \n",
       "3                          0.0                         5.0  \n",
       "3                          0.0                         6.0  \n",
       "3                          1.0                         6.0  \n",
       "\n",
       "[64 rows x 13 columns]"
      ]
     },
     "execution_count": 179,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "monthly_snowfall"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 180,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "weather1 = pd.merge(monthly_highs,monthly_lows, on = \"City\",how = \"outer\")\n",
    "weather2 = pd.merge(weather1,monthly_precipitation,on = \"City\",how = \"outer\")\n",
    "weather_final = pd.merge(weather2,monthly_snowfall,on = \"City\",how = \"outer\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 182,
   "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>City</th>\n",
       "      <th>January Avg High</th>\n",
       "      <th>February Avg High</th>\n",
       "      <th>March Avg High</th>\n",
       "      <th>April Avg High</th>\n",
       "      <th>May Avg High</th>\n",
       "      <th>June Avg High</th>\n",
       "      <th>July Avg High</th>\n",
       "      <th>August Avg High</th>\n",
       "      <th>September Avg High</th>\n",
       "      <th>...</th>\n",
       "      <th>March Avg Snowfall (in)</th>\n",
       "      <th>April Avg Snowfall (in)</th>\n",
       "      <th>May Avg Snowfall (in)</th>\n",
       "      <th>June Avg Snowfall (in)</th>\n",
       "      <th>July Avg Snowfall (in)</th>\n",
       "      <th>August Avg Snowfall (in)</th>\n",
       "      <th>September Avg Snowfall (in)</th>\n",
       "      <th>October Avg Snowfall (in)</th>\n",
       "      <th>November Avg Snowfall (in)</th>\n",
       "      <th>December Avg Snowfall (in)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ANDERSON</td>\n",
       "      <td>51.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ANGOLA</td>\n",
       "      <td>30.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ATLANTA</td>\n",
       "      <td>33.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ATTICA</td>\n",
       "      <td>33.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AUBURN</td>\n",
       "      <td>31.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>WHITELAND</td>\n",
       "      <td>35.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>WHITESTOWN</td>\n",
       "      <td>34.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>WINAMAC</td>\n",
       "      <td>32.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>WINCHESTER</td>\n",
       "      <td>32.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>WOODBURN</td>\n",
       "      <td>31.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>107 rows × 49 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           City  January Avg High  February Avg High  March Avg High  \\\n",
       "0      ANDERSON              51.0               64.0            76.0   \n",
       "1        ANGOLA              30.0               34.0            45.0   \n",
       "2       ATLANTA              33.0               37.0            48.0   \n",
       "3        ATTICA              33.0               37.0            49.0   \n",
       "4        AUBURN              31.0               36.0            48.0   \n",
       "..          ...               ...                ...             ...   \n",
       "102   WHITELAND              35.0               39.0            51.0   \n",
       "103  WHITESTOWN              34.0               39.0            51.0   \n",
       "104     WINAMAC              32.0               36.0            48.0   \n",
       "105  WINCHESTER              32.0               36.0            47.0   \n",
       "106    WOODBURN              31.0               35.0            47.0   \n",
       "\n",
       "     April Avg High  May Avg High  June Avg High  July Avg High  \\\n",
       "0              83.0          84.0           81.0           72.0   \n",
       "1              58.0          69.0           78.0           82.0   \n",
       "2              61.0          71.0           81.0           84.0   \n",
       "3              62.0          72.0           82.0           84.0   \n",
       "4              60.0          72.0           81.0           84.0   \n",
       "..              ...           ...            ...            ...   \n",
       "102            63.0          73.0           81.0           84.0   \n",
       "103            64.0          74.0           82.0           85.0   \n",
       "104            60.0          71.0           80.0           83.0   \n",
       "105            60.0          70.0           80.0           83.0   \n",
       "106            60.0          71.0           80.0           84.0   \n",
       "\n",
       "     August Avg High  September Avg High  ...  March Avg Snowfall (in)  \\\n",
       "0               62.0                39.0  ...                      0.0   \n",
       "1               80.0                73.0  ...                      5.0   \n",
       "2               82.0                77.0  ...                      3.0   \n",
       "3               82.0                77.0  ...                      3.0   \n",
       "4               82.0                75.0  ...                      NaN   \n",
       "..               ...                 ...  ...                      ...   \n",
       "102             83.0                78.0  ...                      NaN   \n",
       "103             83.0                77.0  ...                      2.0   \n",
       "104             81.0                76.0  ...                      3.0   \n",
       "105             81.0                75.0  ...                      NaN   \n",
       "106             82.0                75.0  ...                      NaN   \n",
       "\n",
       "     April Avg Snowfall (in)  May Avg Snowfall (in)  June Avg Snowfall (in)  \\\n",
       "0                        0.0                    0.0                     0.0   \n",
       "1                        1.0                    0.0                     0.0   \n",
       "2                        0.0                    0.0                     0.0   \n",
       "3                        0.0                    0.0                     0.0   \n",
       "4                        NaN                    NaN                     NaN   \n",
       "..                       ...                    ...                     ...   \n",
       "102                      NaN                    NaN                     NaN   \n",
       "103                      0.0                    0.0                     0.0   \n",
       "104                      1.0                    0.0                     0.0   \n",
       "105                      NaN                    NaN                     NaN   \n",
       "106                      NaN                    NaN                     NaN   \n",
       "\n",
       "     July Avg Snowfall (in)  August Avg Snowfall (in)  \\\n",
       "0                       0.0                       0.0   \n",
       "1                       0.0                       0.0   \n",
       "2                       0.0                       0.0   \n",
       "3                       0.0                       0.0   \n",
       "4                       NaN                       NaN   \n",
       "..                      ...                       ...   \n",
       "102                     NaN                       NaN   \n",
       "103                     0.0                       0.0   \n",
       "104                     0.0                       0.0   \n",
       "105                     NaN                       NaN   \n",
       "106                     NaN                       NaN   \n",
       "\n",
       "     September Avg Snowfall (in)  October Avg Snowfall (in)  \\\n",
       "0                            5.0                        2.0   \n",
       "1                            0.0                        0.0   \n",
       "2                            0.0                        0.0   \n",
       "3                            0.0                        0.0   \n",
       "4                            NaN                        NaN   \n",
       "..                           ...                        ...   \n",
       "102                          NaN                        NaN   \n",
       "103                          0.0                        0.0   \n",
       "104                          0.0                        0.0   \n",
       "105                          NaN                        NaN   \n",
       "106                          NaN                        NaN   \n",
       "\n",
       "     November Avg Snowfall (in)  December Avg Snowfall (in)  \n",
       "0                           7.0                         5.0  \n",
       "1                           2.0                        10.0  \n",
       "2                           1.0                         8.0  \n",
       "3                           1.0                         6.0  \n",
       "4                           NaN                         NaN  \n",
       "..                          ...                         ...  \n",
       "102                         NaN                         NaN  \n",
       "103                         0.0                         6.0  \n",
       "104                         1.0                         6.0  \n",
       "105                         NaN                         NaN  \n",
       "106                         NaN                         NaN  \n",
       "\n",
       "[107 rows x 49 columns]"
      ]
     },
     "execution_count": 182,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "weather_final"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 183,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "107\n"
     ]
    }
   ],
   "source": [
    "print(len(weather_final[\"City\"]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 184,
   "metadata": {},
   "outputs": [],
   "source": [
    "city_list_high = ['ANDERSON', 'ANGOLA', 'ATLANTA', 'ATTICA', 'AUBURN', 'BEDFORD', 'BERNE', 'BLOOMFIELD', 'BLOOMINGTON', 'BLUFFTON', 'BOONVILLE', 'BOSWELL', 'BROOKVILLE', 'CAMBRIDGE CITY', 'CARMEL', 'CHALMERS', 'CHARLESTOWN', 'COLUMBIA CITY', 'COLUMBUS', 'CRANE', 'CRAWFORDSVILLE', 'DECATUR', 'DELPHI', 'DUBOIS', 'ELWOOD', 'ENGLISH', 'EVANSVILLE', 'FARMLAND', 'FORT WAYNE', 'FOWLER', 'FRANCESVILLE', 'FRANKFORT', 'FRANKLIN', 'FREELANDVILLE', 'GARRETT', 'GOSHEN', 'GRANTSBURG', 'GREENCASTLE', 'GREENFIELD', 'GREENSBURG', 'HARTFORD CITY', 'HOBART', 'HUNTINGTON', 'INDIANAPOLIS', 'INDIANAPOLIS-EAGLE CREEK AIRPARK', 'JAMESTOWN', 'KENTLAND', 'KNOX', 'KOKOMO', 'LA PORTE', 'LAFAYETTE', 'LAGRANGE', 'LEXINGTON', 'LOGANSPORT', 'LOWELL', 'MADISON', 'MARION', 'MARTINSVILLE', 'MILAN', 'MISHAWAKA', 'MOUNT VERNON', 'MUNCIE', 'NEW CASTLE', 'NORTH MANCHESTER', 'NORTH VERNON', 'OAKLAND CITY', 'OOLITIC', 'PAOLI', 'PERRYSVILLE', 'PETERSBURG', 'PLYMOUTH', 'PORTLAND', 'PRINCETON', 'RENSSELAER', 'RICHMOND', 'ROCHESTER', 'ROCKVILLE', 'RUSHVILLE', 'SAINT MEINRAD', 'SALEM', 'SCOTTSBURG', 'SEYMOUR', 'SHELBURN', 'SHELBYVILLE', 'SHOALS', 'SOUTH BEND', 'SPENCER', 'SPURGEON', 'STENDAL', 'SYRACUSE', 'TELL CITY', 'TERRE HAUTE', 'TIPTON', 'VALPARAISO', 'VEVAY', 'VINCENNES', 'WABASH', 'WANATAH', 'WARSAW', 'WASHINGTON', 'WEST LAFAYETTE', 'WHEATFIELD', 'WHITELAND', 'WHITESTOWN', 'WINAMAC', 'WINCHESTER', 'WOODBURN']\n",
    "county_list = [\"Madison County\",\"Stueben County\",\"Hamilton County\",\"Fountain County\",\"DeKalb County\",\"Lawrence County\",\n",
    "              \"Adams County\",\"Greene County\",\"Monroe County\",\"Wells County\",\"Warrick County\",\"Benton County\",\n",
    "              \"Franklin County\",\"Wayne County\",\"Hamilton County\",\"White County\",\"Clark County\",\n",
    "              \"Whitely County\",\"Bartholomew County\",\"Martin County\",\"Montgomery County\",\"Adams County\",\"Carroll County\",\n",
    "              \"Dubois County\",\"Madison County\",\"Crawford County\",\"Vanderburgh County\",\"Randolph County\",\"Allen County\",\n",
    "              \"Benton County\",\"Pulaski County\",\"Clinton County\",\"Johnson County\",\"Knox County\",\"DeKalb County\",\"Elkhart County\",\n",
    "              \"Crawford County\",\"Putnam County\",\"Hancock County\",\"Decatur County\",\"Blackford County\",\"Lake County\",\n",
    "              \"Huntington County\",\"Marion County\",\"Marion County\",\"Hendricks County\",\"Newton County\",\"Starke County\",\"Howard County\",\n",
    "              \"LaPorte County\",\"Tippecanoe County\",\"LaGrange County\",\"Scott County\",\"Cass County\",\"Lake County\",\"Jefferson County\",\n",
    "              \"Grant County\",\"Morgan County\",\"Ripley County\",\"St. Joseph County\",\"Posey County\",\"Delaware County\",\"Henry County\",\n",
    "              \"Wabash County\",\"Jennings County\",\"Gibson County\",\"Lawrence County\",\"Orange County\",\"Vermillion County\",\"Pike County\",\"Marshall County\",\n",
    "              \"Marshall County\",\"Jay County\",\"Gibson County\",\"Jasper County\",\"Wayne County\",\"Fulton County\",\"Parke County\",\n",
    "              \"Spencer County\",\"Washington County\",\"Scott County\",\"Jackson County\",\"Sullivan County\",\"Shelby County\",\"Martin County\",\n",
    "              \"Martin County\",\"St. Joseph County\",\"Owen County\",\"Pike County\",\"Pike County\",\"Kosciusko County\",\"Perry County\",\n",
    "              \"Vigo County\",\"Porter County\",\"Switzerland County\",\"Knox County\",\"Wabash County\",\"LaPorte County\",\"Kosciuto County\",\n",
    "              \"Daviess County\",\"Tippecanoe County\",\"Jasper County\",\"Johnson County\",\"Boone County\",\"Pulaski County\",\n",
    "              \"Randolph County\",\"Allen County\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 185,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "107\n"
     ]
    }
   ],
   "source": [
    "print(len(county_list))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 186,
   "metadata": {},
   "outputs": [],
   "source": [
    "weather_final[\"County\"] = county_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 187,
   "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>City</th>\n",
       "      <th>January Avg High</th>\n",
       "      <th>February Avg High</th>\n",
       "      <th>March Avg High</th>\n",
       "      <th>April Avg High</th>\n",
       "      <th>May Avg High</th>\n",
       "      <th>June Avg High</th>\n",
       "      <th>July Avg High</th>\n",
       "      <th>August Avg High</th>\n",
       "      <th>September Avg High</th>\n",
       "      <th>...</th>\n",
       "      <th>April Avg Snowfall (in)</th>\n",
       "      <th>May Avg Snowfall (in)</th>\n",
       "      <th>June Avg Snowfall (in)</th>\n",
       "      <th>July Avg Snowfall (in)</th>\n",
       "      <th>August Avg Snowfall (in)</th>\n",
       "      <th>September Avg Snowfall (in)</th>\n",
       "      <th>October Avg Snowfall (in)</th>\n",
       "      <th>November Avg Snowfall (in)</th>\n",
       "      <th>December Avg Snowfall (in)</th>\n",
       "      <th>County</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ANDERSON</td>\n",
       "      <td>51.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Madison County</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ANGOLA</td>\n",
       "      <td>30.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Stueben County</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ATLANTA</td>\n",
       "      <td>33.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Hamilton County</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ATTICA</td>\n",
       "      <td>33.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Fountain County</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AUBURN</td>\n",
       "      <td>31.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DeKalb County</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>WHITELAND</td>\n",
       "      <td>35.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Johnson County</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>WHITESTOWN</td>\n",
       "      <td>34.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Boone County</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>WINAMAC</td>\n",
       "      <td>32.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Pulaski County</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>WINCHESTER</td>\n",
       "      <td>32.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Randolph County</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>WOODBURN</td>\n",
       "      <td>31.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Allen County</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>107 rows × 50 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           City  January Avg High  February Avg High  March Avg High  \\\n",
       "0      ANDERSON              51.0               64.0            76.0   \n",
       "1        ANGOLA              30.0               34.0            45.0   \n",
       "2       ATLANTA              33.0               37.0            48.0   \n",
       "3        ATTICA              33.0               37.0            49.0   \n",
       "4        AUBURN              31.0               36.0            48.0   \n",
       "..          ...               ...                ...             ...   \n",
       "102   WHITELAND              35.0               39.0            51.0   \n",
       "103  WHITESTOWN              34.0               39.0            51.0   \n",
       "104     WINAMAC              32.0               36.0            48.0   \n",
       "105  WINCHESTER              32.0               36.0            47.0   \n",
       "106    WOODBURN              31.0               35.0            47.0   \n",
       "\n",
       "     April Avg High  May Avg High  June Avg High  July Avg High  \\\n",
       "0              83.0          84.0           81.0           72.0   \n",
       "1              58.0          69.0           78.0           82.0   \n",
       "2              61.0          71.0           81.0           84.0   \n",
       "3              62.0          72.0           82.0           84.0   \n",
       "4              60.0          72.0           81.0           84.0   \n",
       "..              ...           ...            ...            ...   \n",
       "102            63.0          73.0           81.0           84.0   \n",
       "103            64.0          74.0           82.0           85.0   \n",
       "104            60.0          71.0           80.0           83.0   \n",
       "105            60.0          70.0           80.0           83.0   \n",
       "106            60.0          71.0           80.0           84.0   \n",
       "\n",
       "     August Avg High  September Avg High  ...  April Avg Snowfall (in)  \\\n",
       "0               62.0                39.0  ...                      0.0   \n",
       "1               80.0                73.0  ...                      1.0   \n",
       "2               82.0                77.0  ...                      0.0   \n",
       "3               82.0                77.0  ...                      0.0   \n",
       "4               82.0                75.0  ...                      NaN   \n",
       "..               ...                 ...  ...                      ...   \n",
       "102             83.0                78.0  ...                      NaN   \n",
       "103             83.0                77.0  ...                      0.0   \n",
       "104             81.0                76.0  ...                      1.0   \n",
       "105             81.0                75.0  ...                      NaN   \n",
       "106             82.0                75.0  ...                      NaN   \n",
       "\n",
       "     May Avg Snowfall (in)  June Avg Snowfall (in)  July Avg Snowfall (in)  \\\n",
       "0                      0.0                     0.0                     0.0   \n",
       "1                      0.0                     0.0                     0.0   \n",
       "2                      0.0                     0.0                     0.0   \n",
       "3                      0.0                     0.0                     0.0   \n",
       "4                      NaN                     NaN                     NaN   \n",
       "..                     ...                     ...                     ...   \n",
       "102                    NaN                     NaN                     NaN   \n",
       "103                    0.0                     0.0                     0.0   \n",
       "104                    0.0                     0.0                     0.0   \n",
       "105                    NaN                     NaN                     NaN   \n",
       "106                    NaN                     NaN                     NaN   \n",
       "\n",
       "     August Avg Snowfall (in)  September Avg Snowfall (in)  \\\n",
       "0                         0.0                          5.0   \n",
       "1                         0.0                          0.0   \n",
       "2                         0.0                          0.0   \n",
       "3                         0.0                          0.0   \n",
       "4                         NaN                          NaN   \n",
       "..                        ...                          ...   \n",
       "102                       NaN                          NaN   \n",
       "103                       0.0                          0.0   \n",
       "104                       0.0                          0.0   \n",
       "105                       NaN                          NaN   \n",
       "106                       NaN                          NaN   \n",
       "\n",
       "     October Avg Snowfall (in)  November Avg Snowfall (in)  \\\n",
       "0                          2.0                         7.0   \n",
       "1                          0.0                         2.0   \n",
       "2                          0.0                         1.0   \n",
       "3                          0.0                         1.0   \n",
       "4                          NaN                         NaN   \n",
       "..                         ...                         ...   \n",
       "102                        NaN                         NaN   \n",
       "103                        0.0                         0.0   \n",
       "104                        0.0                         1.0   \n",
       "105                        NaN                         NaN   \n",
       "106                        NaN                         NaN   \n",
       "\n",
       "     December Avg Snowfall (in)           County  \n",
       "0                           5.0   Madison County  \n",
       "1                          10.0   Stueben County  \n",
       "2                           8.0  Hamilton County  \n",
       "3                           6.0  Fountain County  \n",
       "4                           NaN    DeKalb County  \n",
       "..                          ...              ...  \n",
       "102                         NaN   Johnson County  \n",
       "103                         6.0     Boone County  \n",
       "104                         6.0   Pulaski County  \n",
       "105                         NaN  Randolph County  \n",
       "106                         NaN     Allen County  \n",
       "\n",
       "[107 rows x 50 columns]"
      ]
     },
     "execution_count": 187,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "weather_final"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 188,
   "metadata": {},
   "outputs": [],
   "source": [
    "weather_final.to_csv(\"average_indiana_weather.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "\n",
    "\n",
    "    "
   ]
  },
  {
   "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 [conda env:PythonData] *",
   "language": "python",
   "name": "conda-env-PythonData-py"
  },
  "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.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}