info_data.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Cleaning Process\n",
    "This notebook contain the necessary steps like getting the data info such as data size, number of feature, number of records, mean value, max value, etc. Clean the data which includes dropping some columns and rows, adding more information, joining the dataframes and more"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from CleaningPR import *"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Crime Dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "crime_data = pd.read_csv('csv_files/Crimes_2001_to_Present.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 8000075 entries, 0 to 8000074\n",
      "Data columns (total 22 columns):\n",
      " #   Column                Dtype  \n",
      "---  ------                -----  \n",
      " 0   ID                    int64  \n",
      " 1   Case Number           object \n",
      " 2   Date                  object \n",
      " 3   Block                 object \n",
      " 4   IUCR                  object \n",
      " 5   Primary Type          object \n",
      " 6   Description           object \n",
      " 7   Location Description  object \n",
      " 8   Arrest                bool   \n",
      " 9   Domestic              bool   \n",
      " 10  Beat                  int64  \n",
      " 11  District              float64\n",
      " 12  Ward                  float64\n",
      " 13  Community Area        float64\n",
      " 14  FBI Code              object \n",
      " 15  X Coordinate          float64\n",
      " 16  Y Coordinate          float64\n",
      " 17  Year                  int64  \n",
      " 18  Updated On            object \n",
      " 19  Latitude              float64\n",
      " 20  Longitude             float64\n",
      " 21  Location              object \n",
      "dtypes: bool(2), float64(7), int64(3), object(10)\n",
      "memory usage: 1.2+ GB\n"
     ]
    }
   ],
   "source": [
    "crime_data.info()\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Converting the Date\n",
    "#### step 1) changing the data type to a much suitable format"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/rajpatel/Documents/UIC spring 2024/CS 418/group-project-kungfu-pandas/CleaningPR.py:127: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  crime_data['RegionName'] = crime_data['Community Area'].apply(get_community) # change coordinates to neighborhood name\n"
     ]
    }
   ],
   "source": [
    "crime_data = convertCrimeData(crime_data) # Convert the crime data to a much suitable format\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>Case Number</th>\n",
       "      <th>Date</th>\n",
       "      <th>Block</th>\n",
       "      <th>IUCR</th>\n",
       "      <th>Primary Type</th>\n",
       "      <th>Description</th>\n",
       "      <th>Location Description</th>\n",
       "      <th>Arrest</th>\n",
       "      <th>Domestic</th>\n",
       "      <th>...</th>\n",
       "      <th>FBI Code</th>\n",
       "      <th>X Coordinate</th>\n",
       "      <th>Y Coordinate</th>\n",
       "      <th>Year</th>\n",
       "      <th>Updated On</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Location</th>\n",
       "      <th>New_Date</th>\n",
       "      <th>RegionName</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12045583</td>\n",
       "      <td>JD226426</td>\n",
       "      <td>05/07/2020 10:24:00 AM</td>\n",
       "      <td>035XX S INDIANA AVE</td>\n",
       "      <td>0820</td>\n",
       "      <td>THEFT</td>\n",
       "      <td>$500 AND UNDER</td>\n",
       "      <td>APARTMENT</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>06</td>\n",
       "      <td>1178180.0</td>\n",
       "      <td>1881621.0</td>\n",
       "      <td>2020</td>\n",
       "      <td>05/14/2020 08:47:15 AM</td>\n",
       "      <td>41.830482</td>\n",
       "      <td>-87.621752</td>\n",
       "      <td>(41.830481843, -87.621751752)</td>\n",
       "      <td>2020-05-07 10:24:00</td>\n",
       "      <td>Douglas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12031001</td>\n",
       "      <td>JD209965</td>\n",
       "      <td>04/16/2020 05:00:00 AM</td>\n",
       "      <td>005XX W 32ND ST</td>\n",
       "      <td>0460</td>\n",
       "      <td>BATTERY</td>\n",
       "      <td>SIMPLE</td>\n",
       "      <td>APARTMENT</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>08B</td>\n",
       "      <td>1173292.0</td>\n",
       "      <td>1883705.0</td>\n",
       "      <td>2020</td>\n",
       "      <td>04/23/2020 03:45:11 PM</td>\n",
       "      <td>41.836310</td>\n",
       "      <td>-87.639624</td>\n",
       "      <td>(41.836310224, -87.639624112)</td>\n",
       "      <td>2020-04-16 05:00:00</td>\n",
       "      <td>Bridgeport</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>12093529</td>\n",
       "      <td>JD282112</td>\n",
       "      <td>07/01/2020 10:16:00 AM</td>\n",
       "      <td>081XX S COLES AVE</td>\n",
       "      <td>051A</td>\n",
       "      <td>ASSAULT</td>\n",
       "      <td>AGGRAVATED - HANDGUN</td>\n",
       "      <td>STREET</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>04A</td>\n",
       "      <td>1198234.0</td>\n",
       "      <td>1851595.0</td>\n",
       "      <td>2020</td>\n",
       "      <td>07/08/2020 03:41:45 PM</td>\n",
       "      <td>41.747610</td>\n",
       "      <td>-87.549179</td>\n",
       "      <td>(41.747609555, -87.549179329)</td>\n",
       "      <td>2020-07-01 10:16:00</td>\n",
       "      <td>South Chicago</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>12178140</td>\n",
       "      <td>JD381597</td>\n",
       "      <td>09/27/2020 11:29:00 PM</td>\n",
       "      <td>065XX S WOLCOTT AVE</td>\n",
       "      <td>0460</td>\n",
       "      <td>BATTERY</td>\n",
       "      <td>SIMPLE</td>\n",
       "      <td>RESIDENCE - PORCH / HALLWAY</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>08B</td>\n",
       "      <td>1164812.0</td>\n",
       "      <td>1861251.0</td>\n",
       "      <td>2020</td>\n",
       "      <td>10/04/2020 03:43:55 PM</td>\n",
       "      <td>41.774878</td>\n",
       "      <td>-87.671375</td>\n",
       "      <td>(41.77487752, -87.671374872)</td>\n",
       "      <td>2020-09-27 23:29:00</td>\n",
       "      <td>West Englewood</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>4144897</td>\n",
       "      <td>HL474854</td>\n",
       "      <td>07/10/2005 03:00:00 PM</td>\n",
       "      <td>062XX S ABERDEEN ST</td>\n",
       "      <td>0430</td>\n",
       "      <td>BATTERY</td>\n",
       "      <td>AGGRAVATED: OTHER DANG WEAPON</td>\n",
       "      <td>STREET</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>04B</td>\n",
       "      <td>1170050.0</td>\n",
       "      <td>1863524.0</td>\n",
       "      <td>2005</td>\n",
       "      <td>02/28/2018 03:56:25 PM</td>\n",
       "      <td>41.781003</td>\n",
       "      <td>-87.652107</td>\n",
       "      <td>(41.781002663, -87.652107119)</td>\n",
       "      <td>2005-07-10 15:00:00</td>\n",
       "      <td>Englewood</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          ID Case Number                    Date                Block  IUCR  \\\n",
       "11  12045583    JD226426  05/07/2020 10:24:00 AM  035XX S INDIANA AVE  0820   \n",
       "12  12031001    JD209965  04/16/2020 05:00:00 AM      005XX W 32ND ST  0460   \n",
       "13  12093529    JD282112  07/01/2020 10:16:00 AM    081XX S COLES AVE  051A   \n",
       "14  12178140    JD381597  09/27/2020 11:29:00 PM  065XX S WOLCOTT AVE  0460   \n",
       "15   4144897    HL474854  07/10/2005 03:00:00 PM  062XX S ABERDEEN ST  0430   \n",
       "\n",
       "   Primary Type                    Description         Location Description  \\\n",
       "11        THEFT                 $500 AND UNDER                    APARTMENT   \n",
       "12      BATTERY                         SIMPLE                    APARTMENT   \n",
       "13      ASSAULT           AGGRAVATED - HANDGUN                       STREET   \n",
       "14      BATTERY                         SIMPLE  RESIDENCE - PORCH / HALLWAY   \n",
       "15      BATTERY  AGGRAVATED: OTHER DANG WEAPON                       STREET   \n",
       "\n",
       "    Arrest  Domestic  ...  FBI Code  X Coordinate  Y Coordinate  Year  \\\n",
       "11       0     False  ...        06     1178180.0     1881621.0  2020   \n",
       "12       1     False  ...       08B     1173292.0     1883705.0  2020   \n",
       "13       1     False  ...       04A     1198234.0     1851595.0  2020   \n",
       "14       0     False  ...       08B     1164812.0     1861251.0  2020   \n",
       "15       0     False  ...       04B     1170050.0     1863524.0  2005   \n",
       "\n",
       "                Updated On   Latitude  Longitude  \\\n",
       "11  05/14/2020 08:47:15 AM  41.830482 -87.621752   \n",
       "12  04/23/2020 03:45:11 PM  41.836310 -87.639624   \n",
       "13  07/08/2020 03:41:45 PM  41.747610 -87.549179   \n",
       "14  10/04/2020 03:43:55 PM  41.774878 -87.671375   \n",
       "15  02/28/2018 03:56:25 PM  41.781003 -87.652107   \n",
       "\n",
       "                         Location            New_Date      RegionName  \n",
       "11  (41.830481843, -87.621751752) 2020-05-07 10:24:00         Douglas  \n",
       "12  (41.836310224, -87.639624112) 2020-04-16 05:00:00      Bridgeport  \n",
       "13  (41.747609555, -87.549179329) 2020-07-01 10:16:00   South Chicago  \n",
       "14   (41.77487752, -87.671374872) 2020-09-27 23:29:00  West Englewood  \n",
       "15  (41.781002663, -87.652107119) 2005-07-10 15:00:00       Englewood  \n",
       "\n",
       "[5 rows x 24 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "crime_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([0, 1])"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# crime_data['Arrest'] = crime_data['Arrest'].replace({\n",
    "#     True:1,\n",
    "#     False:0\n",
    "# })\n",
    "\n",
    "crime_data['Arrest'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "# crime_data['New_Date'] = pd.to_datetime(crime_data['Date'])\n",
    "# crime_data['New_Date'] = crime_data['New_Date'].dt.strftime('%m-%d-%Y %H:%M:%S')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# comparing the old date value format to the datetime value format\n",
    "# crime_data[['Date', 'New_Date']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Max new_date value:  2024-02-10 00:00:00\n",
      "Min new_date value:  2001-01-01 00:00:00\n"
     ]
    }
   ],
   "source": [
    "# Print the Latest and Earliest record to veryfiy the range\n",
    "print(\"Max new_date value: \", crime_data['New_Date'].max()) # Latest record of 2024\n",
    "print(\"Min new_date value: \", crime_data['New_Date'].min()) # Earliest record of 2021"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Step 2) Dropping the unecessary columns such as X & Y Coordinate, Date, Block, IUCR, Description, Domestic, Beat, District, FBI code, Ward, Updated on, Latitude, Longitude "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Index: 7297146 entries, 11 to 8000074\n",
      "Data columns (total 7 columns):\n",
      " #   Column                Dtype         \n",
      "---  ------                -----         \n",
      " 0   ID                    int64         \n",
      " 1   New_Date              datetime64[ns]\n",
      " 2   Primary Type          object        \n",
      " 3   Location Description  object        \n",
      " 4   Arrest                int64         \n",
      " 5   Community Area        float64       \n",
      " 6   RegionName            object        \n",
      "dtypes: datetime64[ns](1), float64(1), int64(2), object(3)\n",
      "memory usage: 445.4+ MB\n"
     ]
    }
   ],
   "source": [
    "col = ['ID', 'New_Date', 'Primary Type', 'Location Description', 'Arrest', 'Community Area', 'RegionName']\n",
    "crime_data =  dropCrimeDataColumns(col, crime_data)\n",
    "crime_data.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Step 3) Filtering"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "(crime_data_2017_2019, crime_data_2021_present) = pre_covid_post_covid(crime_data)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### (Pre Covid)\n",
    "Extracting the data for crime report from 2017-2019"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# crime_data_2017_2019 = crime_data[(crime_data['New_Date'].dt.year >= 2017) & (crime_data['New_Date'].dt.year <= 2019)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Min new_date value:  2017-01-01 00:00:00\n",
      "Min new_date value:  2019-12-31 23:55:00\n",
      "[2019 2018 2017]\n"
     ]
    }
   ],
   "source": [
    "# Print the Latest and Earliest record to veryfiy the range\n",
    "print(\"Min new_date value: \", crime_data_2017_2019['New_Date'].min()) # Earliest record of 2017\n",
    "print(\"Min new_date value: \", crime_data_2017_2019['New_Date'].max()) # Earliest record of 2019\n",
    "print(crime_data_2017_2019['New_Date'].dt.year.unique()) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0\n",
      "0\n",
      "0\n",
      "0\n"
     ]
    }
   ],
   "source": [
    "print(crime_data_2017_2019['RegionName'].isna().sum())\n",
    "print(crime_data_2017_2019['Location Description'].isna().sum())\n",
    "print(crime_data_2017_2019['Community Area'].isna().sum())\n",
    "print(crime_data_2017_2019['Primary Type'].isna().sum())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# crime_data_2017_2019.dropna(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "77"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(crime_data_2017_2019['Community Area'].unique())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### (Post Covid)\n",
    "Extracting the data for crime report from 2021 - present"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# crime_data_2021_present = crime_data[crime_data['New_Date'].dt.year >= 2021]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Min new_date value:  2021-01-01 00:00:00\n",
      "[2023 2021 2022 2024]\n"
     ]
    }
   ],
   "source": [
    "print(\"Min new_date value: \", crime_data_2021_present['New_Date'].min()) # Earliest record of 2021\n",
    "print(crime_data_2021_present['New_Date'].dt.year.unique()) # Making sure that the range (2021-2024)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0\n",
      "0\n",
      "0\n",
      "0\n"
     ]
    }
   ],
   "source": [
    "print(crime_data_2021_present['RegionName'].isna().sum())\n",
    "print(crime_data_2021_present['Location Description'].isna().sum())\n",
    "print(crime_data_2021_present['Community Area'].isna().sum())\n",
    "print(crime_data_2021_present['Primary Type'].isna().sum())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# crime_data_2021_present.dropna(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "77"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "len(crime_data_2021_present['Community Area'].unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# community_areas = {\n",
    "#     1: \"Rogers Park\",\n",
    "#     2: \"West Ridge\",\n",
    "#     3: \"Uptown\",\n",
    "#     4: \"Lincoln Square\",\n",
    "#     5: \"North Center\",\n",
    "#     6: \"Lake View\",\n",
    "#     7: \"Lincoln Park\",\n",
    "#     8: \"Near North Side\",\n",
    "#     9: \"Edison Park\",\n",
    "#     10: \"Norwood Park\",\n",
    "#     11: \"Jefferson Park\",\n",
    "#     12: \"Forest Glen\",\n",
    "#     13: \"North Park\",\n",
    "#     14: \"Albany Park\",\n",
    "#     15: \"Portage Park\",\n",
    "#     16: \"Irving Park\",\n",
    "#     17: \"Dunning\",\n",
    "#     18: \"Montclare\",\n",
    "#     19: \"Belmont Cragin\",\n",
    "#     20: \"Hermosa\",\n",
    "#     21: \"Avondale\",\n",
    "#     22: \"Logan Square\",\n",
    "#     23: \"Humboldt Park\",\n",
    "#     24: \"West Town\",\n",
    "#     25: \"Austin\",\n",
    "#     26: \"West Garfield Park\",\n",
    "#     27: \"East Garfield Park\",\n",
    "#     28: \"Near West Side\",\n",
    "#     29: \"North Lawndale\",\n",
    "#     30: \"South Lawndale\",\n",
    "#     31: \"Lower West Side\",\n",
    "#     32: \"Loop\",\n",
    "#     33: \"Near South Side\",\n",
    "#     34: \"Armour Square\",\n",
    "#     35: \"Douglas\",\n",
    "#     36: \"Oakland\",\n",
    "#     37: \"Fuller Park\",\n",
    "#     38: \"Grand Boulevard\",\n",
    "#     39: \"Kenwood\",\n",
    "#     40: \"Washington Park\",\n",
    "#     41: \"Hyde Park\",\n",
    "#     42: \"Woodlawn\",\n",
    "#     43: \"South Shore\",\n",
    "#     44: \"Chatham\",\n",
    "#     45: \"Avalon Park\",\n",
    "#     46: \"South Chicago\",\n",
    "#     47: \"Burnside\",\n",
    "#     48: \"Calumet Heights\",\n",
    "#     49: \"Roseland\",\n",
    "#     50: \"Pullman\",\n",
    "#     51: \"South Deering\",\n",
    "#     52: \"East Side\",\n",
    "#     53: \"West Pullman\",\n",
    "#     54: \"Riverdale\",\n",
    "#     55: \"Hegewisch\",\n",
    "#     56: \"Garfield Ridge\",\n",
    "#     57: \"Archer Heights\",\n",
    "#     58: \"Brighton Park\",\n",
    "#     59: \"McKinley Park\",\n",
    "#     60: \"Bridgeport\",\n",
    "#     61: \"New City\",\n",
    "#     62: \"West Elsdon\",\n",
    "#     63: \"Gage Park\",\n",
    "#     64: \"Clearing\",\n",
    "#     65: \"West Lawn\",\n",
    "#     66: \"Chicago Lawn\",\n",
    "#     67: \"West Englewood\",\n",
    "#     68: \"Englewood\",\n",
    "#     69: \"Greater Grand Crossing\",\n",
    "#     70: \"Ashburn\",\n",
    "#     71: \"Auburn Gresham\",\n",
    "#     72: \"Beverly\",\n",
    "#     73: \"Washington Heights\",\n",
    "#     74: \"Mount Greenwood\",\n",
    "#     75: \"Morgan Park\",\n",
    "#     76: \"O'Hare\",\n",
    "#     77: \"Edgewater\"\n",
    "# }"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# def get_community(code):\n",
    "#     return community_areas[code]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# crime_data_2017_2019.loc[:, 'Location'] = crime_data_2017_2019['Community Area'].apply(get_community)\n",
    "# crime_data_2021_present.loc[:, 'Location'] = crime_data_2021_present['Community Area'].apply(get_community)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# crime_data_2017_2019.rename(columns={'Location':'RegionName'}, inplace = True)\n",
    "# crime_data_2021_present.rename(columns={'Location':'RegionName'}, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>New_Date</th>\n",
       "      <th>Primary Type</th>\n",
       "      <th>Location Description</th>\n",
       "      <th>Arrest</th>\n",
       "      <th>Community Area</th>\n",
       "      <th>RegionName</th>\n",
       "      <th>Severity_Score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>371</th>\n",
       "      <td>13204489</td>\n",
       "      <td>2023-09-06 11:00:00</td>\n",
       "      <td>THEFT</td>\n",
       "      <td>PARKING LOT / GARAGE (NON RESIDENTIAL)</td>\n",
       "      <td>0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>Loop</td>\n",
       "      <td>Low</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>643</th>\n",
       "      <td>12342615</td>\n",
       "      <td>2021-04-17 15:20:00</td>\n",
       "      <td>ROBBERY</td>\n",
       "      <td>RESIDENCE</td>\n",
       "      <td>1</td>\n",
       "      <td>44.0</td>\n",
       "      <td>Chatham</td>\n",
       "      <td>High</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>646</th>\n",
       "      <td>12589893</td>\n",
       "      <td>2022-01-11 15:00:00</td>\n",
       "      <td>SEX OFFENSE</td>\n",
       "      <td>RESIDENCE</td>\n",
       "      <td>0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>South Chicago</td>\n",
       "      <td>High</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>647</th>\n",
       "      <td>12592454</td>\n",
       "      <td>2022-01-14 15:55:00</td>\n",
       "      <td>OTHER OFFENSE</td>\n",
       "      <td>RESIDENCE</td>\n",
       "      <td>0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>Englewood</td>\n",
       "      <td>Medium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>648</th>\n",
       "      <td>12785595</td>\n",
       "      <td>2022-08-05 21:00:00</td>\n",
       "      <td>SEX OFFENSE</td>\n",
       "      <td>APARTMENT</td>\n",
       "      <td>1</td>\n",
       "      <td>69.0</td>\n",
       "      <td>Greater Grand Crossing</td>\n",
       "      <td>High</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2336176</th>\n",
       "      <td>26479</td>\n",
       "      <td>2021-12-03 20:37:00</td>\n",
       "      <td>HOMICIDE</td>\n",
       "      <td>PORCH</td>\n",
       "      <td>1</td>\n",
       "      <td>69.0</td>\n",
       "      <td>Greater Grand Crossing</td>\n",
       "      <td>High</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2336315</th>\n",
       "      <td>27289</td>\n",
       "      <td>2023-01-06 21:25:00</td>\n",
       "      <td>HOMICIDE</td>\n",
       "      <td>HOUSE</td>\n",
       "      <td>1</td>\n",
       "      <td>67.0</td>\n",
       "      <td>West Englewood</td>\n",
       "      <td>High</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2336416</th>\n",
       "      <td>27015</td>\n",
       "      <td>2022-08-31 09:30:00</td>\n",
       "      <td>HOMICIDE</td>\n",
       "      <td>GAS STATION</td>\n",
       "      <td>0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>West Pullman</td>\n",
       "      <td>High</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2336534</th>\n",
       "      <td>27577</td>\n",
       "      <td>2023-06-20 12:42:00</td>\n",
       "      <td>HOMICIDE</td>\n",
       "      <td>STREET</td>\n",
       "      <td>0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>West Garfield Park</td>\n",
       "      <td>High</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7264756</th>\n",
       "      <td>11138622</td>\n",
       "      <td>2021-05-21 00:01:00</td>\n",
       "      <td>OFFENSE INVOLVING CHILDREN</td>\n",
       "      <td>RESIDENCE</td>\n",
       "      <td>0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Hermosa</td>\n",
       "      <td>High</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>720579 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               ID            New_Date                Primary Type  \\\n",
       "371      13204489 2023-09-06 11:00:00                       THEFT   \n",
       "643      12342615 2021-04-17 15:20:00                     ROBBERY   \n",
       "646      12589893 2022-01-11 15:00:00                 SEX OFFENSE   \n",
       "647      12592454 2022-01-14 15:55:00               OTHER OFFENSE   \n",
       "648      12785595 2022-08-05 21:00:00                 SEX OFFENSE   \n",
       "...           ...                 ...                         ...   \n",
       "2336176     26479 2021-12-03 20:37:00                    HOMICIDE   \n",
       "2336315     27289 2023-01-06 21:25:00                    HOMICIDE   \n",
       "2336416     27015 2022-08-31 09:30:00                    HOMICIDE   \n",
       "2336534     27577 2023-06-20 12:42:00                    HOMICIDE   \n",
       "7264756  11138622 2021-05-21 00:01:00  OFFENSE INVOLVING CHILDREN   \n",
       "\n",
       "                           Location Description  Arrest  Community Area  \\\n",
       "371      PARKING LOT / GARAGE (NON RESIDENTIAL)       0            32.0   \n",
       "643                                   RESIDENCE       1            44.0   \n",
       "646                                   RESIDENCE       0            46.0   \n",
       "647                                   RESIDENCE       0            68.0   \n",
       "648                                   APARTMENT       1            69.0   \n",
       "...                                         ...     ...             ...   \n",
       "2336176                                   PORCH       1            69.0   \n",
       "2336315                                   HOUSE       1            67.0   \n",
       "2336416                             GAS STATION       0            53.0   \n",
       "2336534                                  STREET       0            26.0   \n",
       "7264756                               RESIDENCE       0            20.0   \n",
       "\n",
       "                     RegionName Severity_Score  \n",
       "371                        Loop            Low  \n",
       "643                     Chatham           High  \n",
       "646               South Chicago           High  \n",
       "647                   Englewood         Medium  \n",
       "648      Greater Grand Crossing           High  \n",
       "...                         ...            ...  \n",
       "2336176  Greater Grand Crossing           High  \n",
       "2336315          West Englewood           High  \n",
       "2336416            West Pullman           High  \n",
       "2336534      West Garfield Park           High  \n",
       "7264756                 Hermosa           High  \n",
       "\n",
       "[720579 rows x 8 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>New_Date</th>\n",
       "      <th>Primary Type</th>\n",
       "      <th>Location Description</th>\n",
       "      <th>Arrest</th>\n",
       "      <th>Community Area</th>\n",
       "      <th>RegionName</th>\n",
       "      <th>Severity_Score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>12098557</td>\n",
       "      <td>2019-02-01 00:01:00</td>\n",
       "      <td>BATTERY</td>\n",
       "      <td>RESIDENCE</td>\n",
       "      <td>0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>Gage Park</td>\n",
       "      <td>Medium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>283</th>\n",
       "      <td>12082526</td>\n",
       "      <td>2019-09-24 12:00:00</td>\n",
       "      <td>DECEPTIVE PRACTICE</td>\n",
       "      <td>RESIDENCE</td>\n",
       "      <td>0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Uptown</td>\n",
       "      <td>Medium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>527</th>\n",
       "      <td>11859264</td>\n",
       "      <td>2019-10-13 06:40:00</td>\n",
       "      <td>CRIMINAL DAMAGE</td>\n",
       "      <td>APARTMENT</td>\n",
       "      <td>0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>North Lawndale</td>\n",
       "      <td>Medium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>641</th>\n",
       "      <td>11662417</td>\n",
       "      <td>2019-04-21 12:30:00</td>\n",
       "      <td>ROBBERY</td>\n",
       "      <td>RESIDENCE</td>\n",
       "      <td>0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>Chatham</td>\n",
       "      <td>High</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>663</th>\n",
       "      <td>12990873</td>\n",
       "      <td>2019-08-17 13:14:00</td>\n",
       "      <td>OFFENSE INVOLVING CHILDREN</td>\n",
       "      <td>RESIDENCE</td>\n",
       "      <td>1</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Humboldt Park</td>\n",
       "      <td>High</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7999292</th>\n",
       "      <td>12022897</td>\n",
       "      <td>2019-12-05 00:00:00</td>\n",
       "      <td>DECEPTIVE PRACTICE</td>\n",
       "      <td>RESIDENCE</td>\n",
       "      <td>0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>Armour Square</td>\n",
       "      <td>Medium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7999338</th>\n",
       "      <td>12056523</td>\n",
       "      <td>2019-12-20 09:00:00</td>\n",
       "      <td>DECEPTIVE PRACTICE</td>\n",
       "      <td>RESIDENCE</td>\n",
       "      <td>1</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Near North Side</td>\n",
       "      <td>Medium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7999342</th>\n",
       "      <td>12056116</td>\n",
       "      <td>2019-04-09 00:00:00</td>\n",
       "      <td>OFFENSE INVOLVING CHILDREN</td>\n",
       "      <td>RESIDENCE</td>\n",
       "      <td>0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>Calumet Heights</td>\n",
       "      <td>High</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7999778</th>\n",
       "      <td>12166069</td>\n",
       "      <td>2019-02-01 09:00:00</td>\n",
       "      <td>DECEPTIVE PRACTICE</td>\n",
       "      <td>RESIDENCE</td>\n",
       "      <td>0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>Irving Park</td>\n",
       "      <td>Medium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7999779</th>\n",
       "      <td>12002967</td>\n",
       "      <td>2018-05-06 16:58:00</td>\n",
       "      <td>OFFENSE INVOLVING CHILDREN</td>\n",
       "      <td>RESIDENCE</td>\n",
       "      <td>0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>South Lawndale</td>\n",
       "      <td>High</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>785236 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               ID            New_Date                Primary Type  \\\n",
       "96       12098557 2019-02-01 00:01:00                     BATTERY   \n",
       "283      12082526 2019-09-24 12:00:00          DECEPTIVE PRACTICE   \n",
       "527      11859264 2019-10-13 06:40:00             CRIMINAL DAMAGE   \n",
       "641      11662417 2019-04-21 12:30:00                     ROBBERY   \n",
       "663      12990873 2019-08-17 13:14:00  OFFENSE INVOLVING CHILDREN   \n",
       "...           ...                 ...                         ...   \n",
       "7999292  12022897 2019-12-05 00:00:00          DECEPTIVE PRACTICE   \n",
       "7999338  12056523 2019-12-20 09:00:00          DECEPTIVE PRACTICE   \n",
       "7999342  12056116 2019-04-09 00:00:00  OFFENSE INVOLVING CHILDREN   \n",
       "7999778  12166069 2019-02-01 09:00:00          DECEPTIVE PRACTICE   \n",
       "7999779  12002967 2018-05-06 16:58:00  OFFENSE INVOLVING CHILDREN   \n",
       "\n",
       "        Location Description  Arrest  Community Area       RegionName  \\\n",
       "96                 RESIDENCE       0            63.0        Gage Park   \n",
       "283                RESIDENCE       0             3.0           Uptown   \n",
       "527                APARTMENT       0            29.0   North Lawndale   \n",
       "641                RESIDENCE       0            44.0          Chatham   \n",
       "663                RESIDENCE       1            23.0    Humboldt Park   \n",
       "...                      ...     ...             ...              ...   \n",
       "7999292            RESIDENCE       0            34.0    Armour Square   \n",
       "7999338            RESIDENCE       1             8.0  Near North Side   \n",
       "7999342            RESIDENCE       0            48.0  Calumet Heights   \n",
       "7999778            RESIDENCE       0            16.0      Irving Park   \n",
       "7999779            RESIDENCE       0            30.0   South Lawndale   \n",
       "\n",
       "        Severity_Score  \n",
       "96              Medium  \n",
       "283             Medium  \n",
       "527             Medium  \n",
       "641               High  \n",
       "663               High  \n",
       "...                ...  \n",
       "7999292         Medium  \n",
       "7999338         Medium  \n",
       "7999342           High  \n",
       "7999778         Medium  \n",
       "7999779           High  \n",
       "\n",
       "[785236 rows x 8 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(crime_data_2021_present)\n",
    "display(crime_data_2017_2019)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Step 4) Saving the Dataframe to a CSV file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "crime_data_2021_present.to_csv('csv_files/Crimes_2021_to_Present.csv', index=False)\n",
    "crime_data_2017_2019.to_csv('csv_files/Crimes_2017_to_2019.csv', index=False)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Neighborhood Dataset\n",
    "https://www.zillow.com/research/data/\n",
    "\n",
    "Contains information like Region Name, State, City, County Name, Average price of a house for every month since 2000"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "neighborhood_data = pd.read_csv('csv_files/Neighborhood_House_Price.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "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>RegionID</th>\n",
       "      <th>SizeRank</th>\n",
       "      <th>RegionName</th>\n",
       "      <th>RegionType</th>\n",
       "      <th>StateName</th>\n",
       "      <th>State</th>\n",
       "      <th>City</th>\n",
       "      <th>Metro</th>\n",
       "      <th>CountyName</th>\n",
       "      <th>2000-01-31</th>\n",
       "      <th>...</th>\n",
       "      <th>2023-04-30</th>\n",
       "      <th>2023-05-31</th>\n",
       "      <th>2023-06-30</th>\n",
       "      <th>2023-07-31</th>\n",
       "      <th>2023-08-31</th>\n",
       "      <th>2023-09-30</th>\n",
       "      <th>2023-10-31</th>\n",
       "      <th>2023-11-30</th>\n",
       "      <th>2023-12-31</th>\n",
       "      <th>2024-01-31</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>112345</td>\n",
       "      <td>0</td>\n",
       "      <td>Maryvale</td>\n",
       "      <td>neighborhood</td>\n",
       "      <td>AZ</td>\n",
       "      <td>AZ</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>Phoenix-Mesa-Chandler, AZ</td>\n",
       "      <td>Maricopa County</td>\n",
       "      <td>66775.313666</td>\n",
       "      <td>...</td>\n",
       "      <td>3.134925e+05</td>\n",
       "      <td>3.147765e+05</td>\n",
       "      <td>3.166145e+05</td>\n",
       "      <td>3.190725e+05</td>\n",
       "      <td>3.220546e+05</td>\n",
       "      <td>3.246938e+05</td>\n",
       "      <td>3.271008e+05</td>\n",
       "      <td>3.291411e+05</td>\n",
       "      <td>3.307035e+05</td>\n",
       "      <td>3.317141e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>192689</td>\n",
       "      <td>1</td>\n",
       "      <td>Paradise</td>\n",
       "      <td>neighborhood</td>\n",
       "      <td>NV</td>\n",
       "      <td>NV</td>\n",
       "      <td>Las Vegas</td>\n",
       "      <td>Las Vegas-Henderson-Paradise, NV</td>\n",
       "      <td>Clark County</td>\n",
       "      <td>132638.938818</td>\n",
       "      <td>...</td>\n",
       "      <td>3.585637e+05</td>\n",
       "      <td>3.580372e+05</td>\n",
       "      <td>3.587546e+05</td>\n",
       "      <td>3.605508e+05</td>\n",
       "      <td>3.634265e+05</td>\n",
       "      <td>3.662741e+05</td>\n",
       "      <td>3.687446e+05</td>\n",
       "      <td>3.708867e+05</td>\n",
       "      <td>3.729634e+05</td>\n",
       "      <td>3.748541e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>270958</td>\n",
       "      <td>2</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>neighborhood</td>\n",
       "      <td>NY</td>\n",
       "      <td>NY</td>\n",
       "      <td>New York</td>\n",
       "      <td>New York-Newark-Jersey City, NY-NJ-PA</td>\n",
       "      <td>New York County</td>\n",
       "      <td>387530.423074</td>\n",
       "      <td>...</td>\n",
       "      <td>1.276836e+06</td>\n",
       "      <td>1.270266e+06</td>\n",
       "      <td>1.264532e+06</td>\n",
       "      <td>1.258336e+06</td>\n",
       "      <td>1.248721e+06</td>\n",
       "      <td>1.238858e+06</td>\n",
       "      <td>1.227969e+06</td>\n",
       "      <td>1.216308e+06</td>\n",
       "      <td>1.208912e+06</td>\n",
       "      <td>1.203406e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>270957</td>\n",
       "      <td>3</td>\n",
       "      <td>Upper East Side</td>\n",
       "      <td>neighborhood</td>\n",
       "      <td>NY</td>\n",
       "      <td>NY</td>\n",
       "      <td>New York</td>\n",
       "      <td>New York-Newark-Jersey City, NY-NJ-PA</td>\n",
       "      <td>New York County</td>\n",
       "      <td>634533.128812</td>\n",
       "      <td>...</td>\n",
       "      <td>1.259968e+06</td>\n",
       "      <td>1.250928e+06</td>\n",
       "      <td>1.245395e+06</td>\n",
       "      <td>1.241081e+06</td>\n",
       "      <td>1.236655e+06</td>\n",
       "      <td>1.232169e+06</td>\n",
       "      <td>1.224024e+06</td>\n",
       "      <td>1.212976e+06</td>\n",
       "      <td>1.202819e+06</td>\n",
       "      <td>1.196051e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>118208</td>\n",
       "      <td>4</td>\n",
       "      <td>South Los Angeles</td>\n",
       "      <td>neighborhood</td>\n",
       "      <td>CA</td>\n",
       "      <td>CA</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>Los Angeles-Long Beach-Anaheim, CA</td>\n",
       "      <td>Los Angeles County</td>\n",
       "      <td>127876.428774</td>\n",
       "      <td>...</td>\n",
       "      <td>6.198684e+05</td>\n",
       "      <td>6.208305e+05</td>\n",
       "      <td>6.245314e+05</td>\n",
       "      <td>6.317380e+05</td>\n",
       "      <td>6.413973e+05</td>\n",
       "      <td>6.511754e+05</td>\n",
       "      <td>6.594772e+05</td>\n",
       "      <td>6.659235e+05</td>\n",
       "      <td>6.701266e+05</td>\n",
       "      <td>6.678988e+05</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>21658</th>\n",
       "      <td>416956</td>\n",
       "      <td>27095</td>\n",
       "      <td>Enclave at Breckinridge</td>\n",
       "      <td>neighborhood</td>\n",
       "      <td>TX</td>\n",
       "      <td>TX</td>\n",
       "      <td>Richardson</td>\n",
       "      <td>Dallas-Fort Worth-Arlington, TX</td>\n",
       "      <td>Collin County</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5.731472e+05</td>\n",
       "      <td>5.756044e+05</td>\n",
       "      <td>5.784355e+05</td>\n",
       "      <td>5.820318e+05</td>\n",
       "      <td>5.832007e+05</td>\n",
       "      <td>5.843683e+05</td>\n",
       "      <td>5.855589e+05</td>\n",
       "      <td>5.868283e+05</td>\n",
       "      <td>5.871518e+05</td>\n",
       "      <td>5.869640e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21659</th>\n",
       "      <td>830770</td>\n",
       "      <td>27095</td>\n",
       "      <td>Silver Lake</td>\n",
       "      <td>neighborhood</td>\n",
       "      <td>NJ</td>\n",
       "      <td>NJ</td>\n",
       "      <td>Blairstown Township</td>\n",
       "      <td>Allentown-Bethlehem-Easton, PA-NJ</td>\n",
       "      <td>Warren County</td>\n",
       "      <td>NaN</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>3.128810e+05</td>\n",
       "      <td>3.129203e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21660</th>\n",
       "      <td>267809</td>\n",
       "      <td>27095</td>\n",
       "      <td>Rock Springs</td>\n",
       "      <td>neighborhood</td>\n",
       "      <td>NC</td>\n",
       "      <td>NC</td>\n",
       "      <td>Greenville</td>\n",
       "      <td>Greenville, NC</td>\n",
       "      <td>Pitt County</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7.755061e+05</td>\n",
       "      <td>7.853695e+05</td>\n",
       "      <td>7.965433e+05</td>\n",
       "      <td>8.053492e+05</td>\n",
       "      <td>8.125551e+05</td>\n",
       "      <td>8.162749e+05</td>\n",
       "      <td>8.203457e+05</td>\n",
       "      <td>8.235215e+05</td>\n",
       "      <td>8.257521e+05</td>\n",
       "      <td>8.240167e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21661</th>\n",
       "      <td>251134</td>\n",
       "      <td>27095</td>\n",
       "      <td>Lind</td>\n",
       "      <td>neighborhood</td>\n",
       "      <td>CO</td>\n",
       "      <td>CO</td>\n",
       "      <td>Fort Collins</td>\n",
       "      <td>Fort Collins, CO</td>\n",
       "      <td>Larimer County</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4.906780e+05</td>\n",
       "      <td>4.897856e+05</td>\n",
       "      <td>4.897932e+05</td>\n",
       "      <td>4.908824e+05</td>\n",
       "      <td>4.926296e+05</td>\n",
       "      <td>4.944977e+05</td>\n",
       "      <td>4.952402e+05</td>\n",
       "      <td>4.959083e+05</td>\n",
       "      <td>4.961843e+05</td>\n",
       "      <td>4.971330e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21662</th>\n",
       "      <td>831177</td>\n",
       "      <td>27095</td>\n",
       "      <td>Sanctuary</td>\n",
       "      <td>neighborhood</td>\n",
       "      <td>FL</td>\n",
       "      <td>FL</td>\n",
       "      <td>Riverview</td>\n",
       "      <td>Tampa-St. Petersburg-Clearwater, FL</td>\n",
       "      <td>Hillsborough County</td>\n",
       "      <td>NaN</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>3.706494e+05</td>\n",
       "      <td>3.701160e+05</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21663 rows × 298 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       RegionID  SizeRank               RegionName    RegionType StateName  \\\n",
       "0        112345         0                 Maryvale  neighborhood        AZ   \n",
       "1        192689         1                 Paradise  neighborhood        NV   \n",
       "2        270958         2          Upper West Side  neighborhood        NY   \n",
       "3        270957         3          Upper East Side  neighborhood        NY   \n",
       "4        118208         4        South Los Angeles  neighborhood        CA   \n",
       "...         ...       ...                      ...           ...       ...   \n",
       "21658    416956     27095  Enclave at Breckinridge  neighborhood        TX   \n",
       "21659    830770     27095              Silver Lake  neighborhood        NJ   \n",
       "21660    267809     27095             Rock Springs  neighborhood        NC   \n",
       "21661    251134     27095                     Lind  neighborhood        CO   \n",
       "21662    831177     27095                Sanctuary  neighborhood        FL   \n",
       "\n",
       "      State                 City                                  Metro  \\\n",
       "0        AZ              Phoenix              Phoenix-Mesa-Chandler, AZ   \n",
       "1        NV            Las Vegas       Las Vegas-Henderson-Paradise, NV   \n",
       "2        NY             New York  New York-Newark-Jersey City, NY-NJ-PA   \n",
       "3        NY             New York  New York-Newark-Jersey City, NY-NJ-PA   \n",
       "4        CA          Los Angeles     Los Angeles-Long Beach-Anaheim, CA   \n",
       "...     ...                  ...                                    ...   \n",
       "21658    TX           Richardson        Dallas-Fort Worth-Arlington, TX   \n",
       "21659    NJ  Blairstown Township      Allentown-Bethlehem-Easton, PA-NJ   \n",
       "21660    NC           Greenville                         Greenville, NC   \n",
       "21661    CO         Fort Collins                       Fort Collins, CO   \n",
       "21662    FL            Riverview    Tampa-St. Petersburg-Clearwater, FL   \n",
       "\n",
       "                CountyName     2000-01-31  ...    2023-04-30    2023-05-31  \\\n",
       "0          Maricopa County   66775.313666  ...  3.134925e+05  3.147765e+05   \n",
       "1             Clark County  132638.938818  ...  3.585637e+05  3.580372e+05   \n",
       "2          New York County  387530.423074  ...  1.276836e+06  1.270266e+06   \n",
       "3          New York County  634533.128812  ...  1.259968e+06  1.250928e+06   \n",
       "4       Los Angeles County  127876.428774  ...  6.198684e+05  6.208305e+05   \n",
       "...                    ...            ...  ...           ...           ...   \n",
       "21658        Collin County            NaN  ...  5.731472e+05  5.756044e+05   \n",
       "21659        Warren County            NaN  ...           NaN           NaN   \n",
       "21660          Pitt County            NaN  ...  7.755061e+05  7.853695e+05   \n",
       "21661       Larimer County            NaN  ...  4.906780e+05  4.897856e+05   \n",
       "21662  Hillsborough County            NaN  ...           NaN           NaN   \n",
       "\n",
       "         2023-06-30    2023-07-31    2023-08-31    2023-09-30    2023-10-31  \\\n",
       "0      3.166145e+05  3.190725e+05  3.220546e+05  3.246938e+05  3.271008e+05   \n",
       "1      3.587546e+05  3.605508e+05  3.634265e+05  3.662741e+05  3.687446e+05   \n",
       "2      1.264532e+06  1.258336e+06  1.248721e+06  1.238858e+06  1.227969e+06   \n",
       "3      1.245395e+06  1.241081e+06  1.236655e+06  1.232169e+06  1.224024e+06   \n",
       "4      6.245314e+05  6.317380e+05  6.413973e+05  6.511754e+05  6.594772e+05   \n",
       "...             ...           ...           ...           ...           ...   \n",
       "21658  5.784355e+05  5.820318e+05  5.832007e+05  5.843683e+05  5.855589e+05   \n",
       "21659           NaN           NaN           NaN           NaN           NaN   \n",
       "21660  7.965433e+05  8.053492e+05  8.125551e+05  8.162749e+05  8.203457e+05   \n",
       "21661  4.897932e+05  4.908824e+05  4.926296e+05  4.944977e+05  4.952402e+05   \n",
       "21662           NaN           NaN           NaN           NaN           NaN   \n",
       "\n",
       "         2023-11-30    2023-12-31    2024-01-31  \n",
       "0      3.291411e+05  3.307035e+05  3.317141e+05  \n",
       "1      3.708867e+05  3.729634e+05  3.748541e+05  \n",
       "2      1.216308e+06  1.208912e+06  1.203406e+06  \n",
       "3      1.212976e+06  1.202819e+06  1.196051e+06  \n",
       "4      6.659235e+05  6.701266e+05  6.678988e+05  \n",
       "...             ...           ...           ...  \n",
       "21658  5.868283e+05  5.871518e+05  5.869640e+05  \n",
       "21659           NaN  3.128810e+05  3.129203e+05  \n",
       "21660  8.235215e+05  8.257521e+05  8.240167e+05  \n",
       "21661  4.959083e+05  4.961843e+05  4.971330e+05  \n",
       "21662           NaN  3.706494e+05  3.701160e+05  \n",
       "\n",
       "[21663 rows x 298 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "neighborhood_data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Filtering\n",
    "Only want to focus on Chicago, IL housing prices. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "neighborhood_data = filterNeighborhood(neighborhood_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "# neighborhood_data = neighborhood_data[(neighborhood_data['State'] == 'IL') & (neighborhood_data['City'] == 'Chicago')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "(neighborhood_data_2017_2019, neighborhood_data_2021_present) = pre_covid_hd_post_covid_hd(neighborhood_data)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Pre Covid\n",
    "# first_half_column = neighborhood_data.loc[0:, ['RegionName']]\n",
    "# second_half_column =  neighborhood_data.loc[0:, '2017-01-31':'2019-12-31']\n",
    "\n",
    "# # Post Covid\n",
    "# first_half_column_2 = neighborhood_data.loc[0:, ['RegionName']]\n",
    "# second_half_column_2 =  neighborhood_data.loc[0:, '2021-01-31':]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "# neighborhood_data_2017_2019 = pd.concat([first_half_column, second_half_column], axis=1)\n",
    "# neighborhood_data_2021_present = pd.concat([first_half_column_2, second_half_column_2], axis=1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Transposing the Data\n",
    "Reseting the Index, Rotating the Dataframe and Renaming the colums to neighborhood to make it easier to do EDA\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "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>date</th>\n",
       "      <th>Lake View</th>\n",
       "      <th>West Ridge</th>\n",
       "      <th>Little Village</th>\n",
       "      <th>Logan Square</th>\n",
       "      <th>Lincoln Park</th>\n",
       "      <th>South Austin</th>\n",
       "      <th>Irving Park</th>\n",
       "      <th>Rogers Park</th>\n",
       "      <th>Uptown</th>\n",
       "      <th>...</th>\n",
       "      <th>Beverly Woods</th>\n",
       "      <th>Sleepy Hollow</th>\n",
       "      <th>Lithuanian Plaza</th>\n",
       "      <th>Forest Glen</th>\n",
       "      <th>Beverly View</th>\n",
       "      <th>Heart of Italy</th>\n",
       "      <th>Golden Gate</th>\n",
       "      <th>Marycrest</th>\n",
       "      <th>Mount Greenwood Heights</th>\n",
       "      <th>Schorsch Forest View</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-01-31</td>\n",
       "      <td>320800.53</td>\n",
       "      <td>187637.44</td>\n",
       "      <td>90925.08</td>\n",
       "      <td>385189.74</td>\n",
       "      <td>527941.39</td>\n",
       "      <td>104123.27</td>\n",
       "      <td>308905.87</td>\n",
       "      <td>156084.35</td>\n",
       "      <td>222163.90</td>\n",
       "      <td>...</td>\n",
       "      <td>196512.18</td>\n",
       "      <td>150302.70</td>\n",
       "      <td>109474.19</td>\n",
       "      <td>353627.49</td>\n",
       "      <td>115870.21</td>\n",
       "      <td>174695.62</td>\n",
       "      <td>25263.13</td>\n",
       "      <td>222620.47</td>\n",
       "      <td>247078.01</td>\n",
       "      <td>267835.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017-02-28</td>\n",
       "      <td>323403.88</td>\n",
       "      <td>189553.40</td>\n",
       "      <td>92159.98</td>\n",
       "      <td>387715.94</td>\n",
       "      <td>530161.42</td>\n",
       "      <td>104668.31</td>\n",
       "      <td>311086.23</td>\n",
       "      <td>157619.44</td>\n",
       "      <td>223640.40</td>\n",
       "      <td>...</td>\n",
       "      <td>198572.76</td>\n",
       "      <td>152146.67</td>\n",
       "      <td>114100.98</td>\n",
       "      <td>357398.54</td>\n",
       "      <td>117361.01</td>\n",
       "      <td>177001.34</td>\n",
       "      <td>25686.90</td>\n",
       "      <td>224828.56</td>\n",
       "      <td>248058.67</td>\n",
       "      <td>269378.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-03-31</td>\n",
       "      <td>325554.65</td>\n",
       "      <td>191027.03</td>\n",
       "      <td>93255.23</td>\n",
       "      <td>388969.13</td>\n",
       "      <td>532967.82</td>\n",
       "      <td>105138.79</td>\n",
       "      <td>313207.54</td>\n",
       "      <td>158774.66</td>\n",
       "      <td>224694.87</td>\n",
       "      <td>...</td>\n",
       "      <td>200222.71</td>\n",
       "      <td>153710.00</td>\n",
       "      <td>117062.46</td>\n",
       "      <td>360254.80</td>\n",
       "      <td>118906.74</td>\n",
       "      <td>178717.89</td>\n",
       "      <td>26756.02</td>\n",
       "      <td>227139.69</td>\n",
       "      <td>248698.29</td>\n",
       "      <td>270910.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017-04-30</td>\n",
       "      <td>326994.07</td>\n",
       "      <td>191889.95</td>\n",
       "      <td>93859.98</td>\n",
       "      <td>389250.31</td>\n",
       "      <td>535106.28</td>\n",
       "      <td>104823.29</td>\n",
       "      <td>314064.33</td>\n",
       "      <td>159399.12</td>\n",
       "      <td>225477.48</td>\n",
       "      <td>...</td>\n",
       "      <td>201977.06</td>\n",
       "      <td>154409.58</td>\n",
       "      <td>116186.07</td>\n",
       "      <td>363148.26</td>\n",
       "      <td>120138.56</td>\n",
       "      <td>180467.27</td>\n",
       "      <td>27796.86</td>\n",
       "      <td>228359.51</td>\n",
       "      <td>248938.92</td>\n",
       "      <td>272070.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017-05-31</td>\n",
       "      <td>327962.34</td>\n",
       "      <td>192260.37</td>\n",
       "      <td>94812.11</td>\n",
       "      <td>388709.64</td>\n",
       "      <td>538274.75</td>\n",
       "      <td>104754.83</td>\n",
       "      <td>314049.22</td>\n",
       "      <td>159471.94</td>\n",
       "      <td>225828.91</td>\n",
       "      <td>...</td>\n",
       "      <td>203294.72</td>\n",
       "      <td>155492.11</td>\n",
       "      <td>115115.95</td>\n",
       "      <td>365085.52</td>\n",
       "      <td>120869.52</td>\n",
       "      <td>181256.70</td>\n",
       "      <td>28691.81</td>\n",
       "      <td>228371.01</td>\n",
       "      <td>249231.38</td>\n",
       "      <td>272600.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2017-06-30</td>\n",
       "      <td>327811.48</td>\n",
       "      <td>191657.65</td>\n",
       "      <td>95124.03</td>\n",
       "      <td>387398.50</td>\n",
       "      <td>540584.69</td>\n",
       "      <td>104495.21</td>\n",
       "      <td>312965.46</td>\n",
       "      <td>159051.81</td>\n",
       "      <td>225370.08</td>\n",
       "      <td>...</td>\n",
       "      <td>203623.69</td>\n",
       "      <td>155826.90</td>\n",
       "      <td>114375.45</td>\n",
       "      <td>364827.71</td>\n",
       "      <td>120708.67</td>\n",
       "      <td>181725.54</td>\n",
       "      <td>29155.30</td>\n",
       "      <td>226888.91</td>\n",
       "      <td>249169.39</td>\n",
       "      <td>271903.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2017-07-31</td>\n",
       "      <td>327962.79</td>\n",
       "      <td>191412.15</td>\n",
       "      <td>95401.55</td>\n",
       "      <td>386883.97</td>\n",
       "      <td>544013.40</td>\n",
       "      <td>105456.98</td>\n",
       "      <td>312033.22</td>\n",
       "      <td>159263.84</td>\n",
       "      <td>225391.15</td>\n",
       "      <td>...</td>\n",
       "      <td>203924.57</td>\n",
       "      <td>156080.19</td>\n",
       "      <td>115932.30</td>\n",
       "      <td>362801.74</td>\n",
       "      <td>119757.39</td>\n",
       "      <td>182351.22</td>\n",
       "      <td>29502.31</td>\n",
       "      <td>225638.92</td>\n",
       "      <td>249098.50</td>\n",
       "      <td>271082.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2017-08-31</td>\n",
       "      <td>327437.85</td>\n",
       "      <td>191274.53</td>\n",
       "      <td>95832.13</td>\n",
       "      <td>386048.66</td>\n",
       "      <td>545448.30</td>\n",
       "      <td>106777.03</td>\n",
       "      <td>310987.59</td>\n",
       "      <td>159557.20</td>\n",
       "      <td>225711.37</td>\n",
       "      <td>...</td>\n",
       "      <td>203588.83</td>\n",
       "      <td>155547.43</td>\n",
       "      <td>116634.89</td>\n",
       "      <td>360938.60</td>\n",
       "      <td>119547.39</td>\n",
       "      <td>182371.62</td>\n",
       "      <td>29721.06</td>\n",
       "      <td>225330.79</td>\n",
       "      <td>248786.88</td>\n",
       "      <td>270401.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2017-09-30</td>\n",
       "      <td>327554.60</td>\n",
       "      <td>192094.14</td>\n",
       "      <td>97255.88</td>\n",
       "      <td>386580.05</td>\n",
       "      <td>546221.20</td>\n",
       "      <td>109238.10</td>\n",
       "      <td>310692.37</td>\n",
       "      <td>160237.74</td>\n",
       "      <td>226615.06</td>\n",
       "      <td>...</td>\n",
       "      <td>203998.04</td>\n",
       "      <td>155771.45</td>\n",
       "      <td>118506.15</td>\n",
       "      <td>361452.55</td>\n",
       "      <td>120030.85</td>\n",
       "      <td>182801.55</td>\n",
       "      <td>30255.16</td>\n",
       "      <td>226455.82</td>\n",
       "      <td>250024.69</td>\n",
       "      <td>270636.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>327374.26</td>\n",
       "      <td>193383.13</td>\n",
       "      <td>99462.73</td>\n",
       "      <td>387643.20</td>\n",
       "      <td>544315.29</td>\n",
       "      <td>111912.99</td>\n",
       "      <td>310430.04</td>\n",
       "      <td>161239.95</td>\n",
       "      <td>227167.70</td>\n",
       "      <td>...</td>\n",
       "      <td>204119.45</td>\n",
       "      <td>156728.64</td>\n",
       "      <td>120980.46</td>\n",
       "      <td>363847.90</td>\n",
       "      <td>121869.02</td>\n",
       "      <td>184368.60</td>\n",
       "      <td>30990.41</td>\n",
       "      <td>228289.68</td>\n",
       "      <td>252361.45</td>\n",
       "      <td>271321.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2017-11-30</td>\n",
       "      <td>327222.64</td>\n",
       "      <td>194938.31</td>\n",
       "      <td>102048.39</td>\n",
       "      <td>389748.32</td>\n",
       "      <td>540715.18</td>\n",
       "      <td>114541.56</td>\n",
       "      <td>311324.72</td>\n",
       "      <td>162732.61</td>\n",
       "      <td>227498.09</td>\n",
       "      <td>...</td>\n",
       "      <td>204868.29</td>\n",
       "      <td>158282.77</td>\n",
       "      <td>125532.82</td>\n",
       "      <td>365953.10</td>\n",
       "      <td>123878.13</td>\n",
       "      <td>187488.11</td>\n",
       "      <td>31852.72</td>\n",
       "      <td>229843.63</td>\n",
       "      <td>254696.20</td>\n",
       "      <td>271979.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>327342.98</td>\n",
       "      <td>196559.37</td>\n",
       "      <td>105019.86</td>\n",
       "      <td>392343.40</td>\n",
       "      <td>537072.74</td>\n",
       "      <td>117061.25</td>\n",
       "      <td>313162.96</td>\n",
       "      <td>164723.30</td>\n",
       "      <td>228027.52</td>\n",
       "      <td>...</td>\n",
       "      <td>206369.67</td>\n",
       "      <td>159944.10</td>\n",
       "      <td>130026.92</td>\n",
       "      <td>368465.04</td>\n",
       "      <td>126617.57</td>\n",
       "      <td>191771.39</td>\n",
       "      <td>32727.30</td>\n",
       "      <td>231934.47</td>\n",
       "      <td>256593.51</td>\n",
       "      <td>273245.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2018-01-31</td>\n",
       "      <td>328085.09</td>\n",
       "      <td>198175.35</td>\n",
       "      <td>108444.43</td>\n",
       "      <td>396007.83</td>\n",
       "      <td>535358.70</td>\n",
       "      <td>119670.25</td>\n",
       "      <td>315978.55</td>\n",
       "      <td>166755.60</td>\n",
       "      <td>229210.96</td>\n",
       "      <td>...</td>\n",
       "      <td>208059.37</td>\n",
       "      <td>162035.40</td>\n",
       "      <td>133645.77</td>\n",
       "      <td>370980.85</td>\n",
       "      <td>129458.39</td>\n",
       "      <td>195460.17</td>\n",
       "      <td>33835.84</td>\n",
       "      <td>234449.10</td>\n",
       "      <td>258026.08</td>\n",
       "      <td>274095.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2018-02-28</td>\n",
       "      <td>329273.75</td>\n",
       "      <td>200078.56</td>\n",
       "      <td>111546.15</td>\n",
       "      <td>399741.15</td>\n",
       "      <td>536565.79</td>\n",
       "      <td>122095.59</td>\n",
       "      <td>318470.28</td>\n",
       "      <td>168752.34</td>\n",
       "      <td>230462.74</td>\n",
       "      <td>...</td>\n",
       "      <td>209816.80</td>\n",
       "      <td>164568.98</td>\n",
       "      <td>135716.69</td>\n",
       "      <td>374226.90</td>\n",
       "      <td>132739.29</td>\n",
       "      <td>199067.06</td>\n",
       "      <td>34976.05</td>\n",
       "      <td>237303.95</td>\n",
       "      <td>259610.65</td>\n",
       "      <td>275495.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2018-03-31</td>\n",
       "      <td>331229.15</td>\n",
       "      <td>202515.50</td>\n",
       "      <td>114452.80</td>\n",
       "      <td>404328.91</td>\n",
       "      <td>539922.96</td>\n",
       "      <td>124468.14</td>\n",
       "      <td>320893.16</td>\n",
       "      <td>171007.02</td>\n",
       "      <td>232301.11</td>\n",
       "      <td>...</td>\n",
       "      <td>211800.62</td>\n",
       "      <td>167650.07</td>\n",
       "      <td>136958.20</td>\n",
       "      <td>377233.56</td>\n",
       "      <td>135568.89</td>\n",
       "      <td>201917.05</td>\n",
       "      <td>36201.33</td>\n",
       "      <td>239887.74</td>\n",
       "      <td>261002.75</td>\n",
       "      <td>277223.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2018-04-30</td>\n",
       "      <td>333296.58</td>\n",
       "      <td>204336.33</td>\n",
       "      <td>116636.34</td>\n",
       "      <td>408310.78</td>\n",
       "      <td>543917.82</td>\n",
       "      <td>127032.34</td>\n",
       "      <td>322800.66</td>\n",
       "      <td>172969.47</td>\n",
       "      <td>234143.93</td>\n",
       "      <td>...</td>\n",
       "      <td>213357.08</td>\n",
       "      <td>169689.52</td>\n",
       "      <td>137968.58</td>\n",
       "      <td>380303.85</td>\n",
       "      <td>137542.79</td>\n",
       "      <td>203670.16</td>\n",
       "      <td>37453.41</td>\n",
       "      <td>241447.33</td>\n",
       "      <td>261510.30</td>\n",
       "      <td>279664.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2018-05-31</td>\n",
       "      <td>334771.35</td>\n",
       "      <td>205433.04</td>\n",
       "      <td>117966.38</td>\n",
       "      <td>410901.96</td>\n",
       "      <td>546847.77</td>\n",
       "      <td>129655.85</td>\n",
       "      <td>323790.58</td>\n",
       "      <td>174220.15</td>\n",
       "      <td>235276.59</td>\n",
       "      <td>...</td>\n",
       "      <td>214663.00</td>\n",
       "      <td>170834.12</td>\n",
       "      <td>138772.14</td>\n",
       "      <td>381723.15</td>\n",
       "      <td>138043.98</td>\n",
       "      <td>204392.57</td>\n",
       "      <td>38572.38</td>\n",
       "      <td>241842.21</td>\n",
       "      <td>261724.45</td>\n",
       "      <td>281572.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2018-06-30</td>\n",
       "      <td>334726.44</td>\n",
       "      <td>204852.66</td>\n",
       "      <td>117982.09</td>\n",
       "      <td>411483.59</td>\n",
       "      <td>545835.72</td>\n",
       "      <td>131675.42</td>\n",
       "      <td>323689.66</td>\n",
       "      <td>174117.69</td>\n",
       "      <td>234654.78</td>\n",
       "      <td>...</td>\n",
       "      <td>214246.70</td>\n",
       "      <td>170828.02</td>\n",
       "      <td>139043.75</td>\n",
       "      <td>381229.63</td>\n",
       "      <td>137196.37</td>\n",
       "      <td>204500.33</td>\n",
       "      <td>39492.82</td>\n",
       "      <td>241086.49</td>\n",
       "      <td>261490.30</td>\n",
       "      <td>281923.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2018-07-31</td>\n",
       "      <td>333399.78</td>\n",
       "      <td>203958.92</td>\n",
       "      <td>117803.35</td>\n",
       "      <td>410400.83</td>\n",
       "      <td>543101.18</td>\n",
       "      <td>133727.36</td>\n",
       "      <td>322940.69</td>\n",
       "      <td>173853.25</td>\n",
       "      <td>233245.30</td>\n",
       "      <td>...</td>\n",
       "      <td>214462.09</td>\n",
       "      <td>170401.79</td>\n",
       "      <td>140102.22</td>\n",
       "      <td>378627.93</td>\n",
       "      <td>135926.64</td>\n",
       "      <td>205006.04</td>\n",
       "      <td>40683.72</td>\n",
       "      <td>239959.21</td>\n",
       "      <td>261573.20</td>\n",
       "      <td>281647.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2018-08-31</td>\n",
       "      <td>331878.37</td>\n",
       "      <td>202870.80</td>\n",
       "      <td>118505.78</td>\n",
       "      <td>409564.62</td>\n",
       "      <td>540331.23</td>\n",
       "      <td>135220.57</td>\n",
       "      <td>322214.13</td>\n",
       "      <td>173788.79</td>\n",
       "      <td>231691.06</td>\n",
       "      <td>...</td>\n",
       "      <td>214351.80</td>\n",
       "      <td>170018.40</td>\n",
       "      <td>141502.35</td>\n",
       "      <td>376431.26</td>\n",
       "      <td>135125.00</td>\n",
       "      <td>204941.68</td>\n",
       "      <td>42093.00</td>\n",
       "      <td>239503.03</td>\n",
       "      <td>261756.03</td>\n",
       "      <td>281480.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2018-09-30</td>\n",
       "      <td>330543.97</td>\n",
       "      <td>202477.59</td>\n",
       "      <td>119674.16</td>\n",
       "      <td>409014.50</td>\n",
       "      <td>538706.22</td>\n",
       "      <td>136370.75</td>\n",
       "      <td>321595.64</td>\n",
       "      <td>174167.57</td>\n",
       "      <td>230789.38</td>\n",
       "      <td>...</td>\n",
       "      <td>214401.27</td>\n",
       "      <td>169317.74</td>\n",
       "      <td>143793.91</td>\n",
       "      <td>375189.15</td>\n",
       "      <td>135012.80</td>\n",
       "      <td>204848.40</td>\n",
       "      <td>43218.52</td>\n",
       "      <td>239555.15</td>\n",
       "      <td>261820.18</td>\n",
       "      <td>281449.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2018-10-31</td>\n",
       "      <td>329633.40</td>\n",
       "      <td>202389.00</td>\n",
       "      <td>120544.64</td>\n",
       "      <td>409054.57</td>\n",
       "      <td>537063.79</td>\n",
       "      <td>136836.07</td>\n",
       "      <td>321571.79</td>\n",
       "      <td>174379.18</td>\n",
       "      <td>230022.41</td>\n",
       "      <td>...</td>\n",
       "      <td>213841.90</td>\n",
       "      <td>169216.33</td>\n",
       "      <td>146017.37</td>\n",
       "      <td>375373.74</td>\n",
       "      <td>134651.29</td>\n",
       "      <td>205487.09</td>\n",
       "      <td>43523.11</td>\n",
       "      <td>240927.43</td>\n",
       "      <td>262084.85</td>\n",
       "      <td>281462.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2018-11-30</td>\n",
       "      <td>328606.98</td>\n",
       "      <td>202596.38</td>\n",
       "      <td>121063.51</td>\n",
       "      <td>408805.88</td>\n",
       "      <td>534700.11</td>\n",
       "      <td>137987.51</td>\n",
       "      <td>321390.46</td>\n",
       "      <td>174280.09</td>\n",
       "      <td>229685.35</td>\n",
       "      <td>...</td>\n",
       "      <td>213286.06</td>\n",
       "      <td>169402.96</td>\n",
       "      <td>149090.91</td>\n",
       "      <td>376167.33</td>\n",
       "      <td>134483.67</td>\n",
       "      <td>206075.82</td>\n",
       "      <td>43242.48</td>\n",
       "      <td>241519.43</td>\n",
       "      <td>261836.92</td>\n",
       "      <td>281337.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>327986.23</td>\n",
       "      <td>202911.08</td>\n",
       "      <td>121946.40</td>\n",
       "      <td>409206.00</td>\n",
       "      <td>533153.66</td>\n",
       "      <td>139396.79</td>\n",
       "      <td>321380.00</td>\n",
       "      <td>174565.33</td>\n",
       "      <td>229638.98</td>\n",
       "      <td>...</td>\n",
       "      <td>213084.83</td>\n",
       "      <td>170556.56</td>\n",
       "      <td>151169.54</td>\n",
       "      <td>377107.56</td>\n",
       "      <td>134149.72</td>\n",
       "      <td>207442.88</td>\n",
       "      <td>42788.48</td>\n",
       "      <td>241720.73</td>\n",
       "      <td>261359.48</td>\n",
       "      <td>281467.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2019-01-31</td>\n",
       "      <td>327538.13</td>\n",
       "      <td>203538.80</td>\n",
       "      <td>123040.44</td>\n",
       "      <td>410238.90</td>\n",
       "      <td>532656.24</td>\n",
       "      <td>140011.39</td>\n",
       "      <td>321310.77</td>\n",
       "      <td>174888.68</td>\n",
       "      <td>229850.72</td>\n",
       "      <td>...</td>\n",
       "      <td>213274.00</td>\n",
       "      <td>172170.58</td>\n",
       "      <td>152564.48</td>\n",
       "      <td>377887.65</td>\n",
       "      <td>134538.22</td>\n",
       "      <td>208478.37</td>\n",
       "      <td>42438.75</td>\n",
       "      <td>240589.36</td>\n",
       "      <td>260103.29</td>\n",
       "      <td>281275.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2019-02-28</td>\n",
       "      <td>327553.58</td>\n",
       "      <td>204439.33</td>\n",
       "      <td>123969.23</td>\n",
       "      <td>412457.98</td>\n",
       "      <td>533630.65</td>\n",
       "      <td>139977.79</td>\n",
       "      <td>322189.54</td>\n",
       "      <td>175494.50</td>\n",
       "      <td>230124.27</td>\n",
       "      <td>...</td>\n",
       "      <td>214216.92</td>\n",
       "      <td>173543.67</td>\n",
       "      <td>152138.09</td>\n",
       "      <td>379180.04</td>\n",
       "      <td>135364.86</td>\n",
       "      <td>210482.30</td>\n",
       "      <td>41930.78</td>\n",
       "      <td>240036.99</td>\n",
       "      <td>259083.78</td>\n",
       "      <td>281959.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2019-03-31</td>\n",
       "      <td>327436.11</td>\n",
       "      <td>204783.41</td>\n",
       "      <td>124782.84</td>\n",
       "      <td>414528.09</td>\n",
       "      <td>533113.72</td>\n",
       "      <td>139612.85</td>\n",
       "      <td>322726.20</td>\n",
       "      <td>175450.88</td>\n",
       "      <td>229830.90</td>\n",
       "      <td>...</td>\n",
       "      <td>215139.20</td>\n",
       "      <td>174518.27</td>\n",
       "      <td>151346.79</td>\n",
       "      <td>380416.17</td>\n",
       "      <td>136655.71</td>\n",
       "      <td>211387.28</td>\n",
       "      <td>41621.83</td>\n",
       "      <td>239572.56</td>\n",
       "      <td>258493.30</td>\n",
       "      <td>282809.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2019-04-30</td>\n",
       "      <td>327638.94</td>\n",
       "      <td>204814.59</td>\n",
       "      <td>126055.98</td>\n",
       "      <td>416111.23</td>\n",
       "      <td>531744.03</td>\n",
       "      <td>140574.68</td>\n",
       "      <td>323414.38</td>\n",
       "      <td>175422.90</td>\n",
       "      <td>229587.02</td>\n",
       "      <td>...</td>\n",
       "      <td>215851.20</td>\n",
       "      <td>175337.10</td>\n",
       "      <td>150511.42</td>\n",
       "      <td>381213.92</td>\n",
       "      <td>138327.24</td>\n",
       "      <td>211614.71</td>\n",
       "      <td>41514.06</td>\n",
       "      <td>239978.80</td>\n",
       "      <td>258668.04</td>\n",
       "      <td>283935.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2019-05-31</td>\n",
       "      <td>327428.13</td>\n",
       "      <td>204405.01</td>\n",
       "      <td>126805.51</td>\n",
       "      <td>415797.19</td>\n",
       "      <td>528767.62</td>\n",
       "      <td>141771.40</td>\n",
       "      <td>322749.40</td>\n",
       "      <td>175245.71</td>\n",
       "      <td>229265.44</td>\n",
       "      <td>...</td>\n",
       "      <td>215506.04</td>\n",
       "      <td>176022.33</td>\n",
       "      <td>150667.73</td>\n",
       "      <td>380016.49</td>\n",
       "      <td>139418.97</td>\n",
       "      <td>210971.35</td>\n",
       "      <td>42116.31</td>\n",
       "      <td>240549.15</td>\n",
       "      <td>258522.94</td>\n",
       "      <td>283764.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2019-06-30</td>\n",
       "      <td>326810.85</td>\n",
       "      <td>204249.90</td>\n",
       "      <td>127412.09</td>\n",
       "      <td>414317.80</td>\n",
       "      <td>527003.18</td>\n",
       "      <td>143941.11</td>\n",
       "      <td>322316.18</td>\n",
       "      <td>175093.21</td>\n",
       "      <td>228949.40</td>\n",
       "      <td>...</td>\n",
       "      <td>215311.25</td>\n",
       "      <td>176988.45</td>\n",
       "      <td>151411.11</td>\n",
       "      <td>377888.89</td>\n",
       "      <td>139790.76</td>\n",
       "      <td>210925.98</td>\n",
       "      <td>42738.85</td>\n",
       "      <td>240891.29</td>\n",
       "      <td>259107.68</td>\n",
       "      <td>283086.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2019-07-31</td>\n",
       "      <td>325654.37</td>\n",
       "      <td>203823.41</td>\n",
       "      <td>126981.80</td>\n",
       "      <td>412092.45</td>\n",
       "      <td>525522.95</td>\n",
       "      <td>145402.06</td>\n",
       "      <td>321152.25</td>\n",
       "      <td>174533.78</td>\n",
       "      <td>228182.33</td>\n",
       "      <td>...</td>\n",
       "      <td>215367.77</td>\n",
       "      <td>176866.37</td>\n",
       "      <td>152207.26</td>\n",
       "      <td>375089.93</td>\n",
       "      <td>138914.70</td>\n",
       "      <td>210781.09</td>\n",
       "      <td>43075.21</td>\n",
       "      <td>240668.96</td>\n",
       "      <td>259501.42</td>\n",
       "      <td>281545.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2019-08-31</td>\n",
       "      <td>324470.26</td>\n",
       "      <td>203506.38</td>\n",
       "      <td>127537.23</td>\n",
       "      <td>410604.33</td>\n",
       "      <td>524547.08</td>\n",
       "      <td>146952.45</td>\n",
       "      <td>320265.33</td>\n",
       "      <td>174182.92</td>\n",
       "      <td>227689.31</td>\n",
       "      <td>...</td>\n",
       "      <td>216085.43</td>\n",
       "      <td>176547.74</td>\n",
       "      <td>152828.05</td>\n",
       "      <td>372990.28</td>\n",
       "      <td>137861.98</td>\n",
       "      <td>210695.12</td>\n",
       "      <td>43220.25</td>\n",
       "      <td>240444.08</td>\n",
       "      <td>260679.82</td>\n",
       "      <td>280313.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2019-09-30</td>\n",
       "      <td>323266.43</td>\n",
       "      <td>202946.68</td>\n",
       "      <td>127830.79</td>\n",
       "      <td>409346.87</td>\n",
       "      <td>522445.25</td>\n",
       "      <td>147366.52</td>\n",
       "      <td>318828.63</td>\n",
       "      <td>173627.45</td>\n",
       "      <td>227449.44</td>\n",
       "      <td>...</td>\n",
       "      <td>216496.59</td>\n",
       "      <td>175218.09</td>\n",
       "      <td>153329.63</td>\n",
       "      <td>371524.31</td>\n",
       "      <td>136815.48</td>\n",
       "      <td>209817.31</td>\n",
       "      <td>43592.47</td>\n",
       "      <td>240122.75</td>\n",
       "      <td>260902.81</td>\n",
       "      <td>278990.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2019-10-31</td>\n",
       "      <td>322409.46</td>\n",
       "      <td>203030.56</td>\n",
       "      <td>128503.41</td>\n",
       "      <td>408934.38</td>\n",
       "      <td>521778.08</td>\n",
       "      <td>147615.49</td>\n",
       "      <td>317883.74</td>\n",
       "      <td>173666.07</td>\n",
       "      <td>227981.25</td>\n",
       "      <td>...</td>\n",
       "      <td>216915.20</td>\n",
       "      <td>174412.09</td>\n",
       "      <td>154893.29</td>\n",
       "      <td>371318.50</td>\n",
       "      <td>136212.95</td>\n",
       "      <td>209887.86</td>\n",
       "      <td>44341.41</td>\n",
       "      <td>240710.73</td>\n",
       "      <td>261775.68</td>\n",
       "      <td>278549.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2019-11-30</td>\n",
       "      <td>321944.60</td>\n",
       "      <td>203433.10</td>\n",
       "      <td>129227.47</td>\n",
       "      <td>409406.78</td>\n",
       "      <td>520769.32</td>\n",
       "      <td>147956.85</td>\n",
       "      <td>317850.36</td>\n",
       "      <td>173612.53</td>\n",
       "      <td>228689.14</td>\n",
       "      <td>...</td>\n",
       "      <td>216660.24</td>\n",
       "      <td>174276.51</td>\n",
       "      <td>157244.76</td>\n",
       "      <td>372173.36</td>\n",
       "      <td>135956.70</td>\n",
       "      <td>210484.31</td>\n",
       "      <td>44976.63</td>\n",
       "      <td>241326.82</td>\n",
       "      <td>262210.50</td>\n",
       "      <td>278265.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2019-12-31</td>\n",
       "      <td>322010.51</td>\n",
       "      <td>204670.64</td>\n",
       "      <td>130157.11</td>\n",
       "      <td>411298.17</td>\n",
       "      <td>520116.84</td>\n",
       "      <td>148747.61</td>\n",
       "      <td>318325.51</td>\n",
       "      <td>174201.90</td>\n",
       "      <td>229565.24</td>\n",
       "      <td>...</td>\n",
       "      <td>216412.54</td>\n",
       "      <td>175541.17</td>\n",
       "      <td>159673.19</td>\n",
       "      <td>373932.88</td>\n",
       "      <td>135646.63</td>\n",
       "      <td>212598.77</td>\n",
       "      <td>45283.53</td>\n",
       "      <td>242843.24</td>\n",
       "      <td>262427.22</td>\n",
       "      <td>279195.96</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>36 rows × 180 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         date  Lake View  West Ridge  Little Village  Logan Square  \\\n",
       "0  2017-01-31  320800.53   187637.44        90925.08     385189.74   \n",
       "1  2017-02-28  323403.88   189553.40        92159.98     387715.94   \n",
       "2  2017-03-31  325554.65   191027.03        93255.23     388969.13   \n",
       "3  2017-04-30  326994.07   191889.95        93859.98     389250.31   \n",
       "4  2017-05-31  327962.34   192260.37        94812.11     388709.64   \n",
       "5  2017-06-30  327811.48   191657.65        95124.03     387398.50   \n",
       "6  2017-07-31  327962.79   191412.15        95401.55     386883.97   \n",
       "7  2017-08-31  327437.85   191274.53        95832.13     386048.66   \n",
       "8  2017-09-30  327554.60   192094.14        97255.88     386580.05   \n",
       "9  2017-10-31  327374.26   193383.13        99462.73     387643.20   \n",
       "10 2017-11-30  327222.64   194938.31       102048.39     389748.32   \n",
       "11 2017-12-31  327342.98   196559.37       105019.86     392343.40   \n",
       "12 2018-01-31  328085.09   198175.35       108444.43     396007.83   \n",
       "13 2018-02-28  329273.75   200078.56       111546.15     399741.15   \n",
       "14 2018-03-31  331229.15   202515.50       114452.80     404328.91   \n",
       "15 2018-04-30  333296.58   204336.33       116636.34     408310.78   \n",
       "16 2018-05-31  334771.35   205433.04       117966.38     410901.96   \n",
       "17 2018-06-30  334726.44   204852.66       117982.09     411483.59   \n",
       "18 2018-07-31  333399.78   203958.92       117803.35     410400.83   \n",
       "19 2018-08-31  331878.37   202870.80       118505.78     409564.62   \n",
       "20 2018-09-30  330543.97   202477.59       119674.16     409014.50   \n",
       "21 2018-10-31  329633.40   202389.00       120544.64     409054.57   \n",
       "22 2018-11-30  328606.98   202596.38       121063.51     408805.88   \n",
       "23 2018-12-31  327986.23   202911.08       121946.40     409206.00   \n",
       "24 2019-01-31  327538.13   203538.80       123040.44     410238.90   \n",
       "25 2019-02-28  327553.58   204439.33       123969.23     412457.98   \n",
       "26 2019-03-31  327436.11   204783.41       124782.84     414528.09   \n",
       "27 2019-04-30  327638.94   204814.59       126055.98     416111.23   \n",
       "28 2019-05-31  327428.13   204405.01       126805.51     415797.19   \n",
       "29 2019-06-30  326810.85   204249.90       127412.09     414317.80   \n",
       "30 2019-07-31  325654.37   203823.41       126981.80     412092.45   \n",
       "31 2019-08-31  324470.26   203506.38       127537.23     410604.33   \n",
       "32 2019-09-30  323266.43   202946.68       127830.79     409346.87   \n",
       "33 2019-10-31  322409.46   203030.56       128503.41     408934.38   \n",
       "34 2019-11-30  321944.60   203433.10       129227.47     409406.78   \n",
       "35 2019-12-31  322010.51   204670.64       130157.11     411298.17   \n",
       "\n",
       "    Lincoln Park  South Austin  Irving Park  Rogers Park     Uptown  ...  \\\n",
       "0      527941.39     104123.27    308905.87    156084.35  222163.90  ...   \n",
       "1      530161.42     104668.31    311086.23    157619.44  223640.40  ...   \n",
       "2      532967.82     105138.79    313207.54    158774.66  224694.87  ...   \n",
       "3      535106.28     104823.29    314064.33    159399.12  225477.48  ...   \n",
       "4      538274.75     104754.83    314049.22    159471.94  225828.91  ...   \n",
       "5      540584.69     104495.21    312965.46    159051.81  225370.08  ...   \n",
       "6      544013.40     105456.98    312033.22    159263.84  225391.15  ...   \n",
       "7      545448.30     106777.03    310987.59    159557.20  225711.37  ...   \n",
       "8      546221.20     109238.10    310692.37    160237.74  226615.06  ...   \n",
       "9      544315.29     111912.99    310430.04    161239.95  227167.70  ...   \n",
       "10     540715.18     114541.56    311324.72    162732.61  227498.09  ...   \n",
       "11     537072.74     117061.25    313162.96    164723.30  228027.52  ...   \n",
       "12     535358.70     119670.25    315978.55    166755.60  229210.96  ...   \n",
       "13     536565.79     122095.59    318470.28    168752.34  230462.74  ...   \n",
       "14     539922.96     124468.14    320893.16    171007.02  232301.11  ...   \n",
       "15     543917.82     127032.34    322800.66    172969.47  234143.93  ...   \n",
       "16     546847.77     129655.85    323790.58    174220.15  235276.59  ...   \n",
       "17     545835.72     131675.42    323689.66    174117.69  234654.78  ...   \n",
       "18     543101.18     133727.36    322940.69    173853.25  233245.30  ...   \n",
       "19     540331.23     135220.57    322214.13    173788.79  231691.06  ...   \n",
       "20     538706.22     136370.75    321595.64    174167.57  230789.38  ...   \n",
       "21     537063.79     136836.07    321571.79    174379.18  230022.41  ...   \n",
       "22     534700.11     137987.51    321390.46    174280.09  229685.35  ...   \n",
       "23     533153.66     139396.79    321380.00    174565.33  229638.98  ...   \n",
       "24     532656.24     140011.39    321310.77    174888.68  229850.72  ...   \n",
       "25     533630.65     139977.79    322189.54    175494.50  230124.27  ...   \n",
       "26     533113.72     139612.85    322726.20    175450.88  229830.90  ...   \n",
       "27     531744.03     140574.68    323414.38    175422.90  229587.02  ...   \n",
       "28     528767.62     141771.40    322749.40    175245.71  229265.44  ...   \n",
       "29     527003.18     143941.11    322316.18    175093.21  228949.40  ...   \n",
       "30     525522.95     145402.06    321152.25    174533.78  228182.33  ...   \n",
       "31     524547.08     146952.45    320265.33    174182.92  227689.31  ...   \n",
       "32     522445.25     147366.52    318828.63    173627.45  227449.44  ...   \n",
       "33     521778.08     147615.49    317883.74    173666.07  227981.25  ...   \n",
       "34     520769.32     147956.85    317850.36    173612.53  228689.14  ...   \n",
       "35     520116.84     148747.61    318325.51    174201.90  229565.24  ...   \n",
       "\n",
       "    Beverly Woods  Sleepy Hollow  Lithuanian Plaza  Forest Glen  Beverly View  \\\n",
       "0       196512.18      150302.70         109474.19    353627.49     115870.21   \n",
       "1       198572.76      152146.67         114100.98    357398.54     117361.01   \n",
       "2       200222.71      153710.00         117062.46    360254.80     118906.74   \n",
       "3       201977.06      154409.58         116186.07    363148.26     120138.56   \n",
       "4       203294.72      155492.11         115115.95    365085.52     120869.52   \n",
       "5       203623.69      155826.90         114375.45    364827.71     120708.67   \n",
       "6       203924.57      156080.19         115932.30    362801.74     119757.39   \n",
       "7       203588.83      155547.43         116634.89    360938.60     119547.39   \n",
       "8       203998.04      155771.45         118506.15    361452.55     120030.85   \n",
       "9       204119.45      156728.64         120980.46    363847.90     121869.02   \n",
       "10      204868.29      158282.77         125532.82    365953.10     123878.13   \n",
       "11      206369.67      159944.10         130026.92    368465.04     126617.57   \n",
       "12      208059.37      162035.40         133645.77    370980.85     129458.39   \n",
       "13      209816.80      164568.98         135716.69    374226.90     132739.29   \n",
       "14      211800.62      167650.07         136958.20    377233.56     135568.89   \n",
       "15      213357.08      169689.52         137968.58    380303.85     137542.79   \n",
       "16      214663.00      170834.12         138772.14    381723.15     138043.98   \n",
       "17      214246.70      170828.02         139043.75    381229.63     137196.37   \n",
       "18      214462.09      170401.79         140102.22    378627.93     135926.64   \n",
       "19      214351.80      170018.40         141502.35    376431.26     135125.00   \n",
       "20      214401.27      169317.74         143793.91    375189.15     135012.80   \n",
       "21      213841.90      169216.33         146017.37    375373.74     134651.29   \n",
       "22      213286.06      169402.96         149090.91    376167.33     134483.67   \n",
       "23      213084.83      170556.56         151169.54    377107.56     134149.72   \n",
       "24      213274.00      172170.58         152564.48    377887.65     134538.22   \n",
       "25      214216.92      173543.67         152138.09    379180.04     135364.86   \n",
       "26      215139.20      174518.27         151346.79    380416.17     136655.71   \n",
       "27      215851.20      175337.10         150511.42    381213.92     138327.24   \n",
       "28      215506.04      176022.33         150667.73    380016.49     139418.97   \n",
       "29      215311.25      176988.45         151411.11    377888.89     139790.76   \n",
       "30      215367.77      176866.37         152207.26    375089.93     138914.70   \n",
       "31      216085.43      176547.74         152828.05    372990.28     137861.98   \n",
       "32      216496.59      175218.09         153329.63    371524.31     136815.48   \n",
       "33      216915.20      174412.09         154893.29    371318.50     136212.95   \n",
       "34      216660.24      174276.51         157244.76    372173.36     135956.70   \n",
       "35      216412.54      175541.17         159673.19    373932.88     135646.63   \n",
       "\n",
       "    Heart of Italy  Golden Gate  Marycrest  Mount Greenwood Heights  \\\n",
       "0        174695.62     25263.13  222620.47                247078.01   \n",
       "1        177001.34     25686.90  224828.56                248058.67   \n",
       "2        178717.89     26756.02  227139.69                248698.29   \n",
       "3        180467.27     27796.86  228359.51                248938.92   \n",
       "4        181256.70     28691.81  228371.01                249231.38   \n",
       "5        181725.54     29155.30  226888.91                249169.39   \n",
       "6        182351.22     29502.31  225638.92                249098.50   \n",
       "7        182371.62     29721.06  225330.79                248786.88   \n",
       "8        182801.55     30255.16  226455.82                250024.69   \n",
       "9        184368.60     30990.41  228289.68                252361.45   \n",
       "10       187488.11     31852.72  229843.63                254696.20   \n",
       "11       191771.39     32727.30  231934.47                256593.51   \n",
       "12       195460.17     33835.84  234449.10                258026.08   \n",
       "13       199067.06     34976.05  237303.95                259610.65   \n",
       "14       201917.05     36201.33  239887.74                261002.75   \n",
       "15       203670.16     37453.41  241447.33                261510.30   \n",
       "16       204392.57     38572.38  241842.21                261724.45   \n",
       "17       204500.33     39492.82  241086.49                261490.30   \n",
       "18       205006.04     40683.72  239959.21                261573.20   \n",
       "19       204941.68     42093.00  239503.03                261756.03   \n",
       "20       204848.40     43218.52  239555.15                261820.18   \n",
       "21       205487.09     43523.11  240927.43                262084.85   \n",
       "22       206075.82     43242.48  241519.43                261836.92   \n",
       "23       207442.88     42788.48  241720.73                261359.48   \n",
       "24       208478.37     42438.75  240589.36                260103.29   \n",
       "25       210482.30     41930.78  240036.99                259083.78   \n",
       "26       211387.28     41621.83  239572.56                258493.30   \n",
       "27       211614.71     41514.06  239978.80                258668.04   \n",
       "28       210971.35     42116.31  240549.15                258522.94   \n",
       "29       210925.98     42738.85  240891.29                259107.68   \n",
       "30       210781.09     43075.21  240668.96                259501.42   \n",
       "31       210695.12     43220.25  240444.08                260679.82   \n",
       "32       209817.31     43592.47  240122.75                260902.81   \n",
       "33       209887.86     44341.41  240710.73                261775.68   \n",
       "34       210484.31     44976.63  241326.82                262210.50   \n",
       "35       212598.77     45283.53  242843.24                262427.22   \n",
       "\n",
       "    Schorsch Forest View  \n",
       "0              267835.82  \n",
       "1              269378.31  \n",
       "2              270910.81  \n",
       "3              272070.80  \n",
       "4              272600.60  \n",
       "5              271903.45  \n",
       "6              271082.51  \n",
       "7              270401.83  \n",
       "8              270636.65  \n",
       "9              271321.60  \n",
       "10             271979.37  \n",
       "11             273245.64  \n",
       "12             274095.31  \n",
       "13             275495.89  \n",
       "14             277223.83  \n",
       "15             279664.84  \n",
       "16             281572.10  \n",
       "17             281923.39  \n",
       "18             281647.18  \n",
       "19             281480.51  \n",
       "20             281449.87  \n",
       "21             281462.84  \n",
       "22             281337.41  \n",
       "23             281467.26  \n",
       "24             281275.32  \n",
       "25             281959.96  \n",
       "26             282809.44  \n",
       "27             283935.87  \n",
       "28             283764.89  \n",
       "29             283086.99  \n",
       "30             281545.59  \n",
       "31             280313.13  \n",
       "32             278990.52  \n",
       "33             278549.68  \n",
       "34             278265.91  \n",
       "35             279195.96  \n",
       "\n",
       "[36 rows x 180 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "neighborhood_data_2017_2019 = transpose_data(data=neighborhood_data_2017_2019)\n",
    "neighborhood_data_2017_2019"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "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>date</th>\n",
       "      <th>Lake View</th>\n",
       "      <th>West Ridge</th>\n",
       "      <th>Little Village</th>\n",
       "      <th>Logan Square</th>\n",
       "      <th>Lincoln Park</th>\n",
       "      <th>South Austin</th>\n",
       "      <th>Irving Park</th>\n",
       "      <th>Rogers Park</th>\n",
       "      <th>Uptown</th>\n",
       "      <th>...</th>\n",
       "      <th>Beverly Woods</th>\n",
       "      <th>Sleepy Hollow</th>\n",
       "      <th>Lithuanian Plaza</th>\n",
       "      <th>Forest Glen</th>\n",
       "      <th>Beverly View</th>\n",
       "      <th>Heart of Italy</th>\n",
       "      <th>Golden Gate</th>\n",
       "      <th>Marycrest</th>\n",
       "      <th>Mount Greenwood Heights</th>\n",
       "      <th>Schorsch Forest View</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-01-31</td>\n",
       "      <td>335152.96</td>\n",
       "      <td>213600.23</td>\n",
       "      <td>150609.69</td>\n",
       "      <td>438745.60</td>\n",
       "      <td>521486.14</td>\n",
       "      <td>180917.37</td>\n",
       "      <td>338774.43</td>\n",
       "      <td>179522.20</td>\n",
       "      <td>238384.29</td>\n",
       "      <td>...</td>\n",
       "      <td>240022.62</td>\n",
       "      <td>205658.71</td>\n",
       "      <td>190487.83</td>\n",
       "      <td>395487.22</td>\n",
       "      <td>151295.22</td>\n",
       "      <td>230912.58</td>\n",
       "      <td>55617.85</td>\n",
       "      <td>275760.18</td>\n",
       "      <td>280946.44</td>\n",
       "      <td>307632.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-02-28</td>\n",
       "      <td>337100.07</td>\n",
       "      <td>215838.54</td>\n",
       "      <td>154491.46</td>\n",
       "      <td>442793.48</td>\n",
       "      <td>522856.82</td>\n",
       "      <td>185608.39</td>\n",
       "      <td>342486.69</td>\n",
       "      <td>181330.85</td>\n",
       "      <td>239973.93</td>\n",
       "      <td>...</td>\n",
       "      <td>244533.10</td>\n",
       "      <td>210608.34</td>\n",
       "      <td>194609.02</td>\n",
       "      <td>399358.90</td>\n",
       "      <td>155797.67</td>\n",
       "      <td>233706.65</td>\n",
       "      <td>57571.20</td>\n",
       "      <td>280995.20</td>\n",
       "      <td>285493.77</td>\n",
       "      <td>311662.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-03-31</td>\n",
       "      <td>338529.20</td>\n",
       "      <td>217654.91</td>\n",
       "      <td>159032.56</td>\n",
       "      <td>446040.07</td>\n",
       "      <td>523647.18</td>\n",
       "      <td>191007.91</td>\n",
       "      <td>346194.55</td>\n",
       "      <td>182732.26</td>\n",
       "      <td>241113.30</td>\n",
       "      <td>...</td>\n",
       "      <td>248901.59</td>\n",
       "      <td>216042.02</td>\n",
       "      <td>198440.91</td>\n",
       "      <td>403079.57</td>\n",
       "      <td>161320.13</td>\n",
       "      <td>235914.92</td>\n",
       "      <td>60538.07</td>\n",
       "      <td>286359.51</td>\n",
       "      <td>289930.03</td>\n",
       "      <td>316208.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-04-30</td>\n",
       "      <td>339798.57</td>\n",
       "      <td>219105.80</td>\n",
       "      <td>163509.69</td>\n",
       "      <td>448541.71</td>\n",
       "      <td>523534.46</td>\n",
       "      <td>196147.32</td>\n",
       "      <td>349930.12</td>\n",
       "      <td>183811.50</td>\n",
       "      <td>241846.05</td>\n",
       "      <td>...</td>\n",
       "      <td>253083.58</td>\n",
       "      <td>220828.19</td>\n",
       "      <td>201429.10</td>\n",
       "      <td>407398.15</td>\n",
       "      <td>166625.77</td>\n",
       "      <td>236975.40</td>\n",
       "      <td>63795.06</td>\n",
       "      <td>290788.40</td>\n",
       "      <td>293810.50</td>\n",
       "      <td>320674.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-05-31</td>\n",
       "      <td>340754.04</td>\n",
       "      <td>219738.82</td>\n",
       "      <td>166556.65</td>\n",
       "      <td>449749.18</td>\n",
       "      <td>522886.53</td>\n",
       "      <td>199573.26</td>\n",
       "      <td>352042.45</td>\n",
       "      <td>184104.01</td>\n",
       "      <td>242134.79</td>\n",
       "      <td>...</td>\n",
       "      <td>256385.20</td>\n",
       "      <td>224200.84</td>\n",
       "      <td>202531.69</td>\n",
       "      <td>410880.33</td>\n",
       "      <td>171526.91</td>\n",
       "      <td>237436.86</td>\n",
       "      <td>66521.93</td>\n",
       "      <td>294977.07</td>\n",
       "      <td>297387.52</td>\n",
       "      <td>323826.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2021-06-30</td>\n",
       "      <td>341788.37</td>\n",
       "      <td>220295.25</td>\n",
       "      <td>168400.35</td>\n",
       "      <td>449763.28</td>\n",
       "      <td>522981.14</td>\n",
       "      <td>201319.72</td>\n",
       "      <td>353057.32</td>\n",
       "      <td>184583.48</td>\n",
       "      <td>242853.84</td>\n",
       "      <td>...</td>\n",
       "      <td>259212.10</td>\n",
       "      <td>226557.33</td>\n",
       "      <td>202418.71</td>\n",
       "      <td>413127.15</td>\n",
       "      <td>175019.39</td>\n",
       "      <td>238114.89</td>\n",
       "      <td>68435.03</td>\n",
       "      <td>299432.03</td>\n",
       "      <td>301473.58</td>\n",
       "      <td>325993.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2021-07-31</td>\n",
       "      <td>343067.92</td>\n",
       "      <td>221027.00</td>\n",
       "      <td>169456.45</td>\n",
       "      <td>450720.80</td>\n",
       "      <td>524273.73</td>\n",
       "      <td>201058.55</td>\n",
       "      <td>354129.82</td>\n",
       "      <td>185376.33</td>\n",
       "      <td>243888.71</td>\n",
       "      <td>...</td>\n",
       "      <td>260569.13</td>\n",
       "      <td>227806.19</td>\n",
       "      <td>200293.88</td>\n",
       "      <td>414040.68</td>\n",
       "      <td>177032.42</td>\n",
       "      <td>241895.70</td>\n",
       "      <td>69220.69</td>\n",
       "      <td>303617.61</td>\n",
       "      <td>304741.52</td>\n",
       "      <td>326625.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2021-08-31</td>\n",
       "      <td>344281.14</td>\n",
       "      <td>221449.95</td>\n",
       "      <td>169831.82</td>\n",
       "      <td>452165.58</td>\n",
       "      <td>525620.49</td>\n",
       "      <td>199220.35</td>\n",
       "      <td>355132.72</td>\n",
       "      <td>186228.67</td>\n",
       "      <td>244498.74</td>\n",
       "      <td>...</td>\n",
       "      <td>260052.48</td>\n",
       "      <td>227743.38</td>\n",
       "      <td>196555.88</td>\n",
       "      <td>414459.79</td>\n",
       "      <td>177094.06</td>\n",
       "      <td>246815.77</td>\n",
       "      <td>69192.87</td>\n",
       "      <td>305550.92</td>\n",
       "      <td>305578.71</td>\n",
       "      <td>325521.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2021-09-30</td>\n",
       "      <td>344721.73</td>\n",
       "      <td>220854.56</td>\n",
       "      <td>169697.53</td>\n",
       "      <td>453102.62</td>\n",
       "      <td>525261.09</td>\n",
       "      <td>196644.02</td>\n",
       "      <td>355049.79</td>\n",
       "      <td>186063.96</td>\n",
       "      <td>244482.27</td>\n",
       "      <td>...</td>\n",
       "      <td>257600.17</td>\n",
       "      <td>225882.82</td>\n",
       "      <td>191266.12</td>\n",
       "      <td>414358.08</td>\n",
       "      <td>175381.03</td>\n",
       "      <td>252009.64</td>\n",
       "      <td>68358.36</td>\n",
       "      <td>305999.25</td>\n",
       "      <td>304024.16</td>\n",
       "      <td>322763.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2021-10-31</td>\n",
       "      <td>345330.26</td>\n",
       "      <td>220143.28</td>\n",
       "      <td>169068.58</td>\n",
       "      <td>454160.75</td>\n",
       "      <td>525413.69</td>\n",
       "      <td>194897.10</td>\n",
       "      <td>354782.15</td>\n",
       "      <td>185500.21</td>\n",
       "      <td>244576.85</td>\n",
       "      <td>...</td>\n",
       "      <td>255546.85</td>\n",
       "      <td>223523.95</td>\n",
       "      <td>187047.49</td>\n",
       "      <td>415099.06</td>\n",
       "      <td>173394.54</td>\n",
       "      <td>255475.83</td>\n",
       "      <td>68157.50</td>\n",
       "      <td>306452.39</td>\n",
       "      <td>302053.10</td>\n",
       "      <td>320649.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2021-11-30</td>\n",
       "      <td>346229.69</td>\n",
       "      <td>219765.57</td>\n",
       "      <td>168425.69</td>\n",
       "      <td>455393.92</td>\n",
       "      <td>527436.20</td>\n",
       "      <td>194339.77</td>\n",
       "      <td>355036.85</td>\n",
       "      <td>184897.95</td>\n",
       "      <td>245400.60</td>\n",
       "      <td>...</td>\n",
       "      <td>254608.53</td>\n",
       "      <td>222322.72</td>\n",
       "      <td>185198.38</td>\n",
       "      <td>416454.30</td>\n",
       "      <td>172198.61</td>\n",
       "      <td>258055.69</td>\n",
       "      <td>68563.31</td>\n",
       "      <td>308317.61</td>\n",
       "      <td>301321.48</td>\n",
       "      <td>319959.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2021-12-31</td>\n",
       "      <td>347988.77</td>\n",
       "      <td>220259.73</td>\n",
       "      <td>168078.62</td>\n",
       "      <td>458006.38</td>\n",
       "      <td>531400.33</td>\n",
       "      <td>194390.67</td>\n",
       "      <td>356591.05</td>\n",
       "      <td>185376.92</td>\n",
       "      <td>246960.13</td>\n",
       "      <td>...</td>\n",
       "      <td>255125.87</td>\n",
       "      <td>222871.56</td>\n",
       "      <td>185778.40</td>\n",
       "      <td>417917.64</td>\n",
       "      <td>172744.03</td>\n",
       "      <td>260673.30</td>\n",
       "      <td>69277.06</td>\n",
       "      <td>311130.54</td>\n",
       "      <td>302123.86</td>\n",
       "      <td>320359.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2022-01-31</td>\n",
       "      <td>349287.14</td>\n",
       "      <td>220915.77</td>\n",
       "      <td>169403.50</td>\n",
       "      <td>457955.85</td>\n",
       "      <td>534880.08</td>\n",
       "      <td>196033.11</td>\n",
       "      <td>357225.99</td>\n",
       "      <td>186330.53</td>\n",
       "      <td>248355.69</td>\n",
       "      <td>...</td>\n",
       "      <td>257273.57</td>\n",
       "      <td>225699.19</td>\n",
       "      <td>188378.23</td>\n",
       "      <td>419811.00</td>\n",
       "      <td>176111.79</td>\n",
       "      <td>262373.65</td>\n",
       "      <td>70298.41</td>\n",
       "      <td>314868.64</td>\n",
       "      <td>304876.81</td>\n",
       "      <td>321650.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2022-02-28</td>\n",
       "      <td>350710.53</td>\n",
       "      <td>222263.17</td>\n",
       "      <td>172517.67</td>\n",
       "      <td>457233.02</td>\n",
       "      <td>538574.55</td>\n",
       "      <td>199637.41</td>\n",
       "      <td>358282.56</td>\n",
       "      <td>187942.00</td>\n",
       "      <td>249952.31</td>\n",
       "      <td>...</td>\n",
       "      <td>261608.83</td>\n",
       "      <td>230323.99</td>\n",
       "      <td>192774.22</td>\n",
       "      <td>422957.98</td>\n",
       "      <td>181868.42</td>\n",
       "      <td>264093.33</td>\n",
       "      <td>71624.75</td>\n",
       "      <td>319972.35</td>\n",
       "      <td>308978.49</td>\n",
       "      <td>324188.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2022-03-31</td>\n",
       "      <td>352712.49</td>\n",
       "      <td>224436.35</td>\n",
       "      <td>176952.06</td>\n",
       "      <td>456647.37</td>\n",
       "      <td>543973.56</td>\n",
       "      <td>204924.38</td>\n",
       "      <td>360754.20</td>\n",
       "      <td>189910.21</td>\n",
       "      <td>252167.53</td>\n",
       "      <td>...</td>\n",
       "      <td>267261.21</td>\n",
       "      <td>236529.50</td>\n",
       "      <td>198383.39</td>\n",
       "      <td>429412.44</td>\n",
       "      <td>189051.30</td>\n",
       "      <td>265594.66</td>\n",
       "      <td>73961.96</td>\n",
       "      <td>325935.03</td>\n",
       "      <td>313915.13</td>\n",
       "      <td>328748.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2022-04-30</td>\n",
       "      <td>355410.22</td>\n",
       "      <td>227196.75</td>\n",
       "      <td>180259.94</td>\n",
       "      <td>458333.41</td>\n",
       "      <td>550854.10</td>\n",
       "      <td>208314.38</td>\n",
       "      <td>364886.14</td>\n",
       "      <td>192246.12</td>\n",
       "      <td>254697.62</td>\n",
       "      <td>...</td>\n",
       "      <td>272199.56</td>\n",
       "      <td>242295.83</td>\n",
       "      <td>203667.94</td>\n",
       "      <td>436798.84</td>\n",
       "      <td>194467.02</td>\n",
       "      <td>268659.92</td>\n",
       "      <td>76051.94</td>\n",
       "      <td>330643.41</td>\n",
       "      <td>318457.66</td>\n",
       "      <td>334245.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2022-05-31</td>\n",
       "      <td>356874.98</td>\n",
       "      <td>228566.52</td>\n",
       "      <td>181410.16</td>\n",
       "      <td>459587.15</td>\n",
       "      <td>555104.09</td>\n",
       "      <td>208401.76</td>\n",
       "      <td>367835.49</td>\n",
       "      <td>193260.76</td>\n",
       "      <td>255820.74</td>\n",
       "      <td>...</td>\n",
       "      <td>274659.30</td>\n",
       "      <td>245823.52</td>\n",
       "      <td>206534.07</td>\n",
       "      <td>442683.83</td>\n",
       "      <td>196285.12</td>\n",
       "      <td>270804.14</td>\n",
       "      <td>77108.74</td>\n",
       "      <td>332707.59</td>\n",
       "      <td>321019.10</td>\n",
       "      <td>338016.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2022-06-30</td>\n",
       "      <td>358031.70</td>\n",
       "      <td>228372.37</td>\n",
       "      <td>181416.51</td>\n",
       "      <td>460254.00</td>\n",
       "      <td>558090.22</td>\n",
       "      <td>206771.52</td>\n",
       "      <td>369518.55</td>\n",
       "      <td>193003.67</td>\n",
       "      <td>255567.70</td>\n",
       "      <td>...</td>\n",
       "      <td>275693.17</td>\n",
       "      <td>246669.30</td>\n",
       "      <td>206908.58</td>\n",
       "      <td>446017.87</td>\n",
       "      <td>196361.48</td>\n",
       "      <td>272665.90</td>\n",
       "      <td>77403.36</td>\n",
       "      <td>332660.46</td>\n",
       "      <td>322330.41</td>\n",
       "      <td>340263.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2022-07-31</td>\n",
       "      <td>357870.03</td>\n",
       "      <td>226765.49</td>\n",
       "      <td>179543.97</td>\n",
       "      <td>459129.77</td>\n",
       "      <td>557616.94</td>\n",
       "      <td>203990.72</td>\n",
       "      <td>368716.84</td>\n",
       "      <td>191635.99</td>\n",
       "      <td>254452.73</td>\n",
       "      <td>...</td>\n",
       "      <td>275344.00</td>\n",
       "      <td>244989.76</td>\n",
       "      <td>203862.94</td>\n",
       "      <td>444932.23</td>\n",
       "      <td>194378.15</td>\n",
       "      <td>272161.76</td>\n",
       "      <td>77017.26</td>\n",
       "      <td>330911.09</td>\n",
       "      <td>321427.47</td>\n",
       "      <td>339645.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2022-08-31</td>\n",
       "      <td>357158.89</td>\n",
       "      <td>225060.05</td>\n",
       "      <td>176697.99</td>\n",
       "      <td>456181.40</td>\n",
       "      <td>555540.34</td>\n",
       "      <td>200665.90</td>\n",
       "      <td>366558.71</td>\n",
       "      <td>190538.43</td>\n",
       "      <td>253209.68</td>\n",
       "      <td>...</td>\n",
       "      <td>273971.51</td>\n",
       "      <td>242214.11</td>\n",
       "      <td>199948.97</td>\n",
       "      <td>441027.49</td>\n",
       "      <td>192107.82</td>\n",
       "      <td>271040.19</td>\n",
       "      <td>76186.44</td>\n",
       "      <td>328353.22</td>\n",
       "      <td>319314.89</td>\n",
       "      <td>337930.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2022-09-30</td>\n",
       "      <td>354939.02</td>\n",
       "      <td>223618.48</td>\n",
       "      <td>173122.41</td>\n",
       "      <td>451504.53</td>\n",
       "      <td>550923.50</td>\n",
       "      <td>196927.16</td>\n",
       "      <td>362995.69</td>\n",
       "      <td>189763.65</td>\n",
       "      <td>252059.70</td>\n",
       "      <td>...</td>\n",
       "      <td>270801.38</td>\n",
       "      <td>238486.63</td>\n",
       "      <td>195648.23</td>\n",
       "      <td>434812.44</td>\n",
       "      <td>189181.34</td>\n",
       "      <td>269268.65</td>\n",
       "      <td>75408.53</td>\n",
       "      <td>325026.41</td>\n",
       "      <td>315288.54</td>\n",
       "      <td>334949.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2022-10-31</td>\n",
       "      <td>353137.13</td>\n",
       "      <td>222828.44</td>\n",
       "      <td>170684.72</td>\n",
       "      <td>447496.14</td>\n",
       "      <td>547546.00</td>\n",
       "      <td>194551.78</td>\n",
       "      <td>360459.16</td>\n",
       "      <td>189415.70</td>\n",
       "      <td>251076.78</td>\n",
       "      <td>...</td>\n",
       "      <td>267887.52</td>\n",
       "      <td>235163.43</td>\n",
       "      <td>192847.38</td>\n",
       "      <td>430472.44</td>\n",
       "      <td>187076.55</td>\n",
       "      <td>267833.86</td>\n",
       "      <td>75222.87</td>\n",
       "      <td>322492.96</td>\n",
       "      <td>312543.86</td>\n",
       "      <td>332820.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2022-11-30</td>\n",
       "      <td>352371.09</td>\n",
       "      <td>222701.22</td>\n",
       "      <td>169480.80</td>\n",
       "      <td>445021.21</td>\n",
       "      <td>546011.76</td>\n",
       "      <td>193515.54</td>\n",
       "      <td>359225.65</td>\n",
       "      <td>189353.58</td>\n",
       "      <td>250492.38</td>\n",
       "      <td>...</td>\n",
       "      <td>266131.49</td>\n",
       "      <td>232765.70</td>\n",
       "      <td>190498.22</td>\n",
       "      <td>428189.02</td>\n",
       "      <td>185427.32</td>\n",
       "      <td>267179.86</td>\n",
       "      <td>75333.79</td>\n",
       "      <td>320419.53</td>\n",
       "      <td>311054.05</td>\n",
       "      <td>331724.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2022-12-31</td>\n",
       "      <td>351981.99</td>\n",
       "      <td>222145.87</td>\n",
       "      <td>168545.22</td>\n",
       "      <td>443207.67</td>\n",
       "      <td>545617.93</td>\n",
       "      <td>192236.90</td>\n",
       "      <td>358523.59</td>\n",
       "      <td>189411.80</td>\n",
       "      <td>249526.20</td>\n",
       "      <td>...</td>\n",
       "      <td>265774.42</td>\n",
       "      <td>231513.41</td>\n",
       "      <td>188280.50</td>\n",
       "      <td>427179.87</td>\n",
       "      <td>183828.79</td>\n",
       "      <td>266581.15</td>\n",
       "      <td>74903.57</td>\n",
       "      <td>318821.03</td>\n",
       "      <td>311097.39</td>\n",
       "      <td>331232.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2023-01-31</td>\n",
       "      <td>350177.24</td>\n",
       "      <td>220987.92</td>\n",
       "      <td>167334.70</td>\n",
       "      <td>440358.49</td>\n",
       "      <td>544450.38</td>\n",
       "      <td>189945.01</td>\n",
       "      <td>356783.57</td>\n",
       "      <td>189155.72</td>\n",
       "      <td>247956.13</td>\n",
       "      <td>...</td>\n",
       "      <td>264669.66</td>\n",
       "      <td>230861.90</td>\n",
       "      <td>186298.25</td>\n",
       "      <td>425966.43</td>\n",
       "      <td>182247.86</td>\n",
       "      <td>266483.44</td>\n",
       "      <td>73594.85</td>\n",
       "      <td>317289.12</td>\n",
       "      <td>309848.29</td>\n",
       "      <td>330186.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2023-02-28</td>\n",
       "      <td>347147.56</td>\n",
       "      <td>219554.01</td>\n",
       "      <td>166543.41</td>\n",
       "      <td>437330.30</td>\n",
       "      <td>541232.66</td>\n",
       "      <td>188172.61</td>\n",
       "      <td>355333.51</td>\n",
       "      <td>189152.35</td>\n",
       "      <td>246415.72</td>\n",
       "      <td>...</td>\n",
       "      <td>263741.15</td>\n",
       "      <td>231525.61</td>\n",
       "      <td>185138.92</td>\n",
       "      <td>426097.49</td>\n",
       "      <td>182056.11</td>\n",
       "      <td>266609.22</td>\n",
       "      <td>72320.45</td>\n",
       "      <td>317081.41</td>\n",
       "      <td>309282.42</td>\n",
       "      <td>329869.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2023-03-31</td>\n",
       "      <td>345203.47</td>\n",
       "      <td>218970.73</td>\n",
       "      <td>166856.37</td>\n",
       "      <td>436360.21</td>\n",
       "      <td>538479.25</td>\n",
       "      <td>188023.09</td>\n",
       "      <td>355479.13</td>\n",
       "      <td>189805.04</td>\n",
       "      <td>245788.51</td>\n",
       "      <td>...</td>\n",
       "      <td>262522.28</td>\n",
       "      <td>233337.55</td>\n",
       "      <td>185302.98</td>\n",
       "      <td>426711.43</td>\n",
       "      <td>182655.72</td>\n",
       "      <td>268878.45</td>\n",
       "      <td>71088.47</td>\n",
       "      <td>317434.23</td>\n",
       "      <td>308964.74</td>\n",
       "      <td>330412.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2023-04-30</td>\n",
       "      <td>345791.99</td>\n",
       "      <td>219505.47</td>\n",
       "      <td>168529.73</td>\n",
       "      <td>438170.58</td>\n",
       "      <td>537512.79</td>\n",
       "      <td>189108.42</td>\n",
       "      <td>358222.05</td>\n",
       "      <td>191179.18</td>\n",
       "      <td>246581.80</td>\n",
       "      <td>...</td>\n",
       "      <td>261982.86</td>\n",
       "      <td>235372.20</td>\n",
       "      <td>185283.89</td>\n",
       "      <td>428402.03</td>\n",
       "      <td>183979.71</td>\n",
       "      <td>272724.19</td>\n",
       "      <td>70320.63</td>\n",
       "      <td>317947.36</td>\n",
       "      <td>310257.67</td>\n",
       "      <td>332068.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2023-05-31</td>\n",
       "      <td>348243.72</td>\n",
       "      <td>220873.40</td>\n",
       "      <td>170215.55</td>\n",
       "      <td>441159.95</td>\n",
       "      <td>539139.27</td>\n",
       "      <td>189711.94</td>\n",
       "      <td>361269.65</td>\n",
       "      <td>192618.34</td>\n",
       "      <td>248266.81</td>\n",
       "      <td>...</td>\n",
       "      <td>261374.32</td>\n",
       "      <td>236103.42</td>\n",
       "      <td>184920.21</td>\n",
       "      <td>429767.96</td>\n",
       "      <td>184575.51</td>\n",
       "      <td>277481.55</td>\n",
       "      <td>69738.05</td>\n",
       "      <td>318242.75</td>\n",
       "      <td>311483.75</td>\n",
       "      <td>333953.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2023-06-30</td>\n",
       "      <td>351331.96</td>\n",
       "      <td>222693.53</td>\n",
       "      <td>171405.52</td>\n",
       "      <td>444235.24</td>\n",
       "      <td>541588.44</td>\n",
       "      <td>189203.01</td>\n",
       "      <td>364612.13</td>\n",
       "      <td>193903.59</td>\n",
       "      <td>250400.95</td>\n",
       "      <td>...</td>\n",
       "      <td>261696.02</td>\n",
       "      <td>236527.88</td>\n",
       "      <td>183812.28</td>\n",
       "      <td>432952.69</td>\n",
       "      <td>185247.77</td>\n",
       "      <td>281176.12</td>\n",
       "      <td>68916.98</td>\n",
       "      <td>319146.60</td>\n",
       "      <td>313023.10</td>\n",
       "      <td>337033.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2023-07-31</td>\n",
       "      <td>354372.11</td>\n",
       "      <td>224815.40</td>\n",
       "      <td>172511.52</td>\n",
       "      <td>446830.28</td>\n",
       "      <td>543950.92</td>\n",
       "      <td>188467.82</td>\n",
       "      <td>367761.28</td>\n",
       "      <td>195224.57</td>\n",
       "      <td>252601.72</td>\n",
       "      <td>...</td>\n",
       "      <td>263419.39</td>\n",
       "      <td>237722.62</td>\n",
       "      <td>183485.19</td>\n",
       "      <td>436836.27</td>\n",
       "      <td>186418.24</td>\n",
       "      <td>284109.94</td>\n",
       "      <td>67902.77</td>\n",
       "      <td>320886.28</td>\n",
       "      <td>314335.60</td>\n",
       "      <td>341258.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2023-08-31</td>\n",
       "      <td>358274.51</td>\n",
       "      <td>227233.66</td>\n",
       "      <td>174512.51</td>\n",
       "      <td>449198.96</td>\n",
       "      <td>546390.82</td>\n",
       "      <td>187581.11</td>\n",
       "      <td>371154.80</td>\n",
       "      <td>197540.05</td>\n",
       "      <td>255978.46</td>\n",
       "      <td>...</td>\n",
       "      <td>265378.73</td>\n",
       "      <td>240612.20</td>\n",
       "      <td>183745.73</td>\n",
       "      <td>440417.66</td>\n",
       "      <td>187879.05</td>\n",
       "      <td>287336.59</td>\n",
       "      <td>66675.58</td>\n",
       "      <td>322325.70</td>\n",
       "      <td>315228.32</td>\n",
       "      <td>345718.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2023-09-30</td>\n",
       "      <td>361767.24</td>\n",
       "      <td>228789.69</td>\n",
       "      <td>176942.11</td>\n",
       "      <td>449859.67</td>\n",
       "      <td>548270.86</td>\n",
       "      <td>186463.56</td>\n",
       "      <td>373269.57</td>\n",
       "      <td>199982.45</td>\n",
       "      <td>259731.43</td>\n",
       "      <td>...</td>\n",
       "      <td>266263.31</td>\n",
       "      <td>243670.78</td>\n",
       "      <td>184363.62</td>\n",
       "      <td>442668.58</td>\n",
       "      <td>188627.39</td>\n",
       "      <td>289204.66</td>\n",
       "      <td>65910.21</td>\n",
       "      <td>322872.76</td>\n",
       "      <td>315700.38</td>\n",
       "      <td>349568.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2023-10-31</td>\n",
       "      <td>364245.14</td>\n",
       "      <td>229263.49</td>\n",
       "      <td>178664.61</td>\n",
       "      <td>449269.55</td>\n",
       "      <td>549318.71</td>\n",
       "      <td>185643.66</td>\n",
       "      <td>374300.39</td>\n",
       "      <td>202238.38</td>\n",
       "      <td>262676.20</td>\n",
       "      <td>...</td>\n",
       "      <td>266047.85</td>\n",
       "      <td>245922.55</td>\n",
       "      <td>185488.11</td>\n",
       "      <td>444410.99</td>\n",
       "      <td>188145.25</td>\n",
       "      <td>289954.46</td>\n",
       "      <td>65409.90</td>\n",
       "      <td>322881.47</td>\n",
       "      <td>316257.42</td>\n",
       "      <td>352424.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2023-11-30</td>\n",
       "      <td>365404.24</td>\n",
       "      <td>229190.54</td>\n",
       "      <td>179329.07</td>\n",
       "      <td>448226.59</td>\n",
       "      <td>549895.69</td>\n",
       "      <td>184930.20</td>\n",
       "      <td>374722.64</td>\n",
       "      <td>203437.92</td>\n",
       "      <td>264078.74</td>\n",
       "      <td>...</td>\n",
       "      <td>265434.43</td>\n",
       "      <td>246968.84</td>\n",
       "      <td>186211.46</td>\n",
       "      <td>445701.27</td>\n",
       "      <td>186652.71</td>\n",
       "      <td>289743.07</td>\n",
       "      <td>65276.62</td>\n",
       "      <td>322911.15</td>\n",
       "      <td>316753.79</td>\n",
       "      <td>354896.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2023-12-31</td>\n",
       "      <td>365273.87</td>\n",
       "      <td>229300.29</td>\n",
       "      <td>179274.98</td>\n",
       "      <td>447136.44</td>\n",
       "      <td>549323.12</td>\n",
       "      <td>184507.54</td>\n",
       "      <td>374176.99</td>\n",
       "      <td>204149.62</td>\n",
       "      <td>264046.60</td>\n",
       "      <td>...</td>\n",
       "      <td>265225.51</td>\n",
       "      <td>247468.61</td>\n",
       "      <td>187271.25</td>\n",
       "      <td>446746.05</td>\n",
       "      <td>185334.93</td>\n",
       "      <td>290485.43</td>\n",
       "      <td>64771.16</td>\n",
       "      <td>323036.43</td>\n",
       "      <td>317284.42</td>\n",
       "      <td>356164.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2024-01-31</td>\n",
       "      <td>364719.92</td>\n",
       "      <td>229288.17</td>\n",
       "      <td>179381.86</td>\n",
       "      <td>446721.93</td>\n",
       "      <td>548638.64</td>\n",
       "      <td>184515.94</td>\n",
       "      <td>373477.02</td>\n",
       "      <td>204126.84</td>\n",
       "      <td>263371.44</td>\n",
       "      <td>...</td>\n",
       "      <td>265754.80</td>\n",
       "      <td>248063.84</td>\n",
       "      <td>188107.75</td>\n",
       "      <td>447353.07</td>\n",
       "      <td>185017.99</td>\n",
       "      <td>291655.16</td>\n",
       "      <td>64550.67</td>\n",
       "      <td>323600.65</td>\n",
       "      <td>317851.66</td>\n",
       "      <td>356733.60</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>37 rows × 181 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         date  Lake View  West Ridge  Little Village  Logan Square  \\\n",
       "0  2021-01-31  335152.96   213600.23       150609.69     438745.60   \n",
       "1  2021-02-28  337100.07   215838.54       154491.46     442793.48   \n",
       "2  2021-03-31  338529.20   217654.91       159032.56     446040.07   \n",
       "3  2021-04-30  339798.57   219105.80       163509.69     448541.71   \n",
       "4  2021-05-31  340754.04   219738.82       166556.65     449749.18   \n",
       "5  2021-06-30  341788.37   220295.25       168400.35     449763.28   \n",
       "6  2021-07-31  343067.92   221027.00       169456.45     450720.80   \n",
       "7  2021-08-31  344281.14   221449.95       169831.82     452165.58   \n",
       "8  2021-09-30  344721.73   220854.56       169697.53     453102.62   \n",
       "9  2021-10-31  345330.26   220143.28       169068.58     454160.75   \n",
       "10 2021-11-30  346229.69   219765.57       168425.69     455393.92   \n",
       "11 2021-12-31  347988.77   220259.73       168078.62     458006.38   \n",
       "12 2022-01-31  349287.14   220915.77       169403.50     457955.85   \n",
       "13 2022-02-28  350710.53   222263.17       172517.67     457233.02   \n",
       "14 2022-03-31  352712.49   224436.35       176952.06     456647.37   \n",
       "15 2022-04-30  355410.22   227196.75       180259.94     458333.41   \n",
       "16 2022-05-31  356874.98   228566.52       181410.16     459587.15   \n",
       "17 2022-06-30  358031.70   228372.37       181416.51     460254.00   \n",
       "18 2022-07-31  357870.03   226765.49       179543.97     459129.77   \n",
       "19 2022-08-31  357158.89   225060.05       176697.99     456181.40   \n",
       "20 2022-09-30  354939.02   223618.48       173122.41     451504.53   \n",
       "21 2022-10-31  353137.13   222828.44       170684.72     447496.14   \n",
       "22 2022-11-30  352371.09   222701.22       169480.80     445021.21   \n",
       "23 2022-12-31  351981.99   222145.87       168545.22     443207.67   \n",
       "24 2023-01-31  350177.24   220987.92       167334.70     440358.49   \n",
       "25 2023-02-28  347147.56   219554.01       166543.41     437330.30   \n",
       "26 2023-03-31  345203.47   218970.73       166856.37     436360.21   \n",
       "27 2023-04-30  345791.99   219505.47       168529.73     438170.58   \n",
       "28 2023-05-31  348243.72   220873.40       170215.55     441159.95   \n",
       "29 2023-06-30  351331.96   222693.53       171405.52     444235.24   \n",
       "30 2023-07-31  354372.11   224815.40       172511.52     446830.28   \n",
       "31 2023-08-31  358274.51   227233.66       174512.51     449198.96   \n",
       "32 2023-09-30  361767.24   228789.69       176942.11     449859.67   \n",
       "33 2023-10-31  364245.14   229263.49       178664.61     449269.55   \n",
       "34 2023-11-30  365404.24   229190.54       179329.07     448226.59   \n",
       "35 2023-12-31  365273.87   229300.29       179274.98     447136.44   \n",
       "36 2024-01-31  364719.92   229288.17       179381.86     446721.93   \n",
       "\n",
       "    Lincoln Park  South Austin  Irving Park  Rogers Park     Uptown  ...  \\\n",
       "0      521486.14     180917.37    338774.43    179522.20  238384.29  ...   \n",
       "1      522856.82     185608.39    342486.69    181330.85  239973.93  ...   \n",
       "2      523647.18     191007.91    346194.55    182732.26  241113.30  ...   \n",
       "3      523534.46     196147.32    349930.12    183811.50  241846.05  ...   \n",
       "4      522886.53     199573.26    352042.45    184104.01  242134.79  ...   \n",
       "5      522981.14     201319.72    353057.32    184583.48  242853.84  ...   \n",
       "6      524273.73     201058.55    354129.82    185376.33  243888.71  ...   \n",
       "7      525620.49     199220.35    355132.72    186228.67  244498.74  ...   \n",
       "8      525261.09     196644.02    355049.79    186063.96  244482.27  ...   \n",
       "9      525413.69     194897.10    354782.15    185500.21  244576.85  ...   \n",
       "10     527436.20     194339.77    355036.85    184897.95  245400.60  ...   \n",
       "11     531400.33     194390.67    356591.05    185376.92  246960.13  ...   \n",
       "12     534880.08     196033.11    357225.99    186330.53  248355.69  ...   \n",
       "13     538574.55     199637.41    358282.56    187942.00  249952.31  ...   \n",
       "14     543973.56     204924.38    360754.20    189910.21  252167.53  ...   \n",
       "15     550854.10     208314.38    364886.14    192246.12  254697.62  ...   \n",
       "16     555104.09     208401.76    367835.49    193260.76  255820.74  ...   \n",
       "17     558090.22     206771.52    369518.55    193003.67  255567.70  ...   \n",
       "18     557616.94     203990.72    368716.84    191635.99  254452.73  ...   \n",
       "19     555540.34     200665.90    366558.71    190538.43  253209.68  ...   \n",
       "20     550923.50     196927.16    362995.69    189763.65  252059.70  ...   \n",
       "21     547546.00     194551.78    360459.16    189415.70  251076.78  ...   \n",
       "22     546011.76     193515.54    359225.65    189353.58  250492.38  ...   \n",
       "23     545617.93     192236.90    358523.59    189411.80  249526.20  ...   \n",
       "24     544450.38     189945.01    356783.57    189155.72  247956.13  ...   \n",
       "25     541232.66     188172.61    355333.51    189152.35  246415.72  ...   \n",
       "26     538479.25     188023.09    355479.13    189805.04  245788.51  ...   \n",
       "27     537512.79     189108.42    358222.05    191179.18  246581.80  ...   \n",
       "28     539139.27     189711.94    361269.65    192618.34  248266.81  ...   \n",
       "29     541588.44     189203.01    364612.13    193903.59  250400.95  ...   \n",
       "30     543950.92     188467.82    367761.28    195224.57  252601.72  ...   \n",
       "31     546390.82     187581.11    371154.80    197540.05  255978.46  ...   \n",
       "32     548270.86     186463.56    373269.57    199982.45  259731.43  ...   \n",
       "33     549318.71     185643.66    374300.39    202238.38  262676.20  ...   \n",
       "34     549895.69     184930.20    374722.64    203437.92  264078.74  ...   \n",
       "35     549323.12     184507.54    374176.99    204149.62  264046.60  ...   \n",
       "36     548638.64     184515.94    373477.02    204126.84  263371.44  ...   \n",
       "\n",
       "    Beverly Woods  Sleepy Hollow  Lithuanian Plaza  Forest Glen  Beverly View  \\\n",
       "0       240022.62      205658.71         190487.83    395487.22     151295.22   \n",
       "1       244533.10      210608.34         194609.02    399358.90     155797.67   \n",
       "2       248901.59      216042.02         198440.91    403079.57     161320.13   \n",
       "3       253083.58      220828.19         201429.10    407398.15     166625.77   \n",
       "4       256385.20      224200.84         202531.69    410880.33     171526.91   \n",
       "5       259212.10      226557.33         202418.71    413127.15     175019.39   \n",
       "6       260569.13      227806.19         200293.88    414040.68     177032.42   \n",
       "7       260052.48      227743.38         196555.88    414459.79     177094.06   \n",
       "8       257600.17      225882.82         191266.12    414358.08     175381.03   \n",
       "9       255546.85      223523.95         187047.49    415099.06     173394.54   \n",
       "10      254608.53      222322.72         185198.38    416454.30     172198.61   \n",
       "11      255125.87      222871.56         185778.40    417917.64     172744.03   \n",
       "12      257273.57      225699.19         188378.23    419811.00     176111.79   \n",
       "13      261608.83      230323.99         192774.22    422957.98     181868.42   \n",
       "14      267261.21      236529.50         198383.39    429412.44     189051.30   \n",
       "15      272199.56      242295.83         203667.94    436798.84     194467.02   \n",
       "16      274659.30      245823.52         206534.07    442683.83     196285.12   \n",
       "17      275693.17      246669.30         206908.58    446017.87     196361.48   \n",
       "18      275344.00      244989.76         203862.94    444932.23     194378.15   \n",
       "19      273971.51      242214.11         199948.97    441027.49     192107.82   \n",
       "20      270801.38      238486.63         195648.23    434812.44     189181.34   \n",
       "21      267887.52      235163.43         192847.38    430472.44     187076.55   \n",
       "22      266131.49      232765.70         190498.22    428189.02     185427.32   \n",
       "23      265774.42      231513.41         188280.50    427179.87     183828.79   \n",
       "24      264669.66      230861.90         186298.25    425966.43     182247.86   \n",
       "25      263741.15      231525.61         185138.92    426097.49     182056.11   \n",
       "26      262522.28      233337.55         185302.98    426711.43     182655.72   \n",
       "27      261982.86      235372.20         185283.89    428402.03     183979.71   \n",
       "28      261374.32      236103.42         184920.21    429767.96     184575.51   \n",
       "29      261696.02      236527.88         183812.28    432952.69     185247.77   \n",
       "30      263419.39      237722.62         183485.19    436836.27     186418.24   \n",
       "31      265378.73      240612.20         183745.73    440417.66     187879.05   \n",
       "32      266263.31      243670.78         184363.62    442668.58     188627.39   \n",
       "33      266047.85      245922.55         185488.11    444410.99     188145.25   \n",
       "34      265434.43      246968.84         186211.46    445701.27     186652.71   \n",
       "35      265225.51      247468.61         187271.25    446746.05     185334.93   \n",
       "36      265754.80      248063.84         188107.75    447353.07     185017.99   \n",
       "\n",
       "    Heart of Italy  Golden Gate  Marycrest  Mount Greenwood Heights  \\\n",
       "0        230912.58     55617.85  275760.18                280946.44   \n",
       "1        233706.65     57571.20  280995.20                285493.77   \n",
       "2        235914.92     60538.07  286359.51                289930.03   \n",
       "3        236975.40     63795.06  290788.40                293810.50   \n",
       "4        237436.86     66521.93  294977.07                297387.52   \n",
       "5        238114.89     68435.03  299432.03                301473.58   \n",
       "6        241895.70     69220.69  303617.61                304741.52   \n",
       "7        246815.77     69192.87  305550.92                305578.71   \n",
       "8        252009.64     68358.36  305999.25                304024.16   \n",
       "9        255475.83     68157.50  306452.39                302053.10   \n",
       "10       258055.69     68563.31  308317.61                301321.48   \n",
       "11       260673.30     69277.06  311130.54                302123.86   \n",
       "12       262373.65     70298.41  314868.64                304876.81   \n",
       "13       264093.33     71624.75  319972.35                308978.49   \n",
       "14       265594.66     73961.96  325935.03                313915.13   \n",
       "15       268659.92     76051.94  330643.41                318457.66   \n",
       "16       270804.14     77108.74  332707.59                321019.10   \n",
       "17       272665.90     77403.36  332660.46                322330.41   \n",
       "18       272161.76     77017.26  330911.09                321427.47   \n",
       "19       271040.19     76186.44  328353.22                319314.89   \n",
       "20       269268.65     75408.53  325026.41                315288.54   \n",
       "21       267833.86     75222.87  322492.96                312543.86   \n",
       "22       267179.86     75333.79  320419.53                311054.05   \n",
       "23       266581.15     74903.57  318821.03                311097.39   \n",
       "24       266483.44     73594.85  317289.12                309848.29   \n",
       "25       266609.22     72320.45  317081.41                309282.42   \n",
       "26       268878.45     71088.47  317434.23                308964.74   \n",
       "27       272724.19     70320.63  317947.36                310257.67   \n",
       "28       277481.55     69738.05  318242.75                311483.75   \n",
       "29       281176.12     68916.98  319146.60                313023.10   \n",
       "30       284109.94     67902.77  320886.28                314335.60   \n",
       "31       287336.59     66675.58  322325.70                315228.32   \n",
       "32       289204.66     65910.21  322872.76                315700.38   \n",
       "33       289954.46     65409.90  322881.47                316257.42   \n",
       "34       289743.07     65276.62  322911.15                316753.79   \n",
       "35       290485.43     64771.16  323036.43                317284.42   \n",
       "36       291655.16     64550.67  323600.65                317851.66   \n",
       "\n",
       "    Schorsch Forest View  \n",
       "0              307632.09  \n",
       "1              311662.78  \n",
       "2              316208.50  \n",
       "3              320674.89  \n",
       "4              323826.16  \n",
       "5              325993.12  \n",
       "6              326625.97  \n",
       "7              325521.20  \n",
       "8              322763.98  \n",
       "9              320649.74  \n",
       "10             319959.21  \n",
       "11             320359.63  \n",
       "12             321650.39  \n",
       "13             324188.74  \n",
       "14             328748.11  \n",
       "15             334245.38  \n",
       "16             338016.28  \n",
       "17             340263.39  \n",
       "18             339645.59  \n",
       "19             337930.15  \n",
       "20             334949.78  \n",
       "21             332820.96  \n",
       "22             331724.76  \n",
       "23             331232.42  \n",
       "24             330186.40  \n",
       "25             329869.86  \n",
       "26             330412.60  \n",
       "27             332068.43  \n",
       "28             333953.62  \n",
       "29             337033.15  \n",
       "30             341258.35  \n",
       "31             345718.14  \n",
       "32             349568.78  \n",
       "33             352424.33  \n",
       "34             354896.00  \n",
       "35             356164.83  \n",
       "36             356733.60  \n",
       "\n",
       "[37 rows x 181 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "neighborhood_data_2021_present = transpose_data(data=neighborhood_data_2021_present)\n",
    "neighborhood_data_2021_present"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "# neighborhood_data_2017_2019.reset_index(inplace=True)\n",
    "# neighborhood_data_2021_present.reset_index(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "# neighborhood_names_list = neighborhood_data_2017_2019[\"RegionName\"].to_list()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "# neighborhood_data_2017_2019.drop(columns='index', inplace=True)\n",
    "# neighborhood_data_2021_present.drop(columns='index', inplace=True)\n",
    "# neighborhood_data_2017_2019"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "# map = {}\n",
    "# for num in range(0,181):\n",
    "#     map[num] = neighborhood_names_list[num]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "# #display(neighborhood_data_2017_2019[neighborhood_data_2017_2019['RegionName'] == 'Lake View'])\n",
    "# neighborhood_data_2017_2019 = neighborhood_data_2017_2019.transpose()\n",
    "# neighborhood_data_2017_2019.rename(columns=map, inplace= True)\n",
    "# neighborhood_data_2021_present = neighborhood_data_2021_present.transpose()\n",
    "# neighborhood_data_2021_present.rename(columns=map, inplace= True)\n",
    "# #display(neighborhood_data_2021_present)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "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>date</th>\n",
       "      <th>Lake View</th>\n",
       "      <th>West Ridge</th>\n",
       "      <th>Little Village</th>\n",
       "      <th>Logan Square</th>\n",
       "      <th>Lincoln Park</th>\n",
       "      <th>South Austin</th>\n",
       "      <th>Irving Park</th>\n",
       "      <th>Rogers Park</th>\n",
       "      <th>Uptown</th>\n",
       "      <th>...</th>\n",
       "      <th>Beverly Woods</th>\n",
       "      <th>Sleepy Hollow</th>\n",
       "      <th>Lithuanian Plaza</th>\n",
       "      <th>Forest Glen</th>\n",
       "      <th>Beverly View</th>\n",
       "      <th>Heart of Italy</th>\n",
       "      <th>Golden Gate</th>\n",
       "      <th>Marycrest</th>\n",
       "      <th>Mount Greenwood Heights</th>\n",
       "      <th>Schorsch Forest View</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-01-31</td>\n",
       "      <td>320800.53</td>\n",
       "      <td>187637.44</td>\n",
       "      <td>90925.08</td>\n",
       "      <td>385189.74</td>\n",
       "      <td>527941.39</td>\n",
       "      <td>104123.27</td>\n",
       "      <td>308905.87</td>\n",
       "      <td>156084.35</td>\n",
       "      <td>222163.90</td>\n",
       "      <td>...</td>\n",
       "      <td>196512.18</td>\n",
       "      <td>150302.70</td>\n",
       "      <td>109474.19</td>\n",
       "      <td>353627.49</td>\n",
       "      <td>115870.21</td>\n",
       "      <td>174695.62</td>\n",
       "      <td>25263.13</td>\n",
       "      <td>222620.47</td>\n",
       "      <td>247078.01</td>\n",
       "      <td>267835.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017-02-28</td>\n",
       "      <td>323403.88</td>\n",
       "      <td>189553.40</td>\n",
       "      <td>92159.98</td>\n",
       "      <td>387715.94</td>\n",
       "      <td>530161.42</td>\n",
       "      <td>104668.31</td>\n",
       "      <td>311086.23</td>\n",
       "      <td>157619.44</td>\n",
       "      <td>223640.40</td>\n",
       "      <td>...</td>\n",
       "      <td>198572.76</td>\n",
       "      <td>152146.67</td>\n",
       "      <td>114100.98</td>\n",
       "      <td>357398.54</td>\n",
       "      <td>117361.01</td>\n",
       "      <td>177001.34</td>\n",
       "      <td>25686.90</td>\n",
       "      <td>224828.56</td>\n",
       "      <td>248058.67</td>\n",
       "      <td>269378.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-03-31</td>\n",
       "      <td>325554.65</td>\n",
       "      <td>191027.03</td>\n",
       "      <td>93255.23</td>\n",
       "      <td>388969.13</td>\n",
       "      <td>532967.82</td>\n",
       "      <td>105138.79</td>\n",
       "      <td>313207.54</td>\n",
       "      <td>158774.66</td>\n",
       "      <td>224694.87</td>\n",
       "      <td>...</td>\n",
       "      <td>200222.71</td>\n",
       "      <td>153710.00</td>\n",
       "      <td>117062.46</td>\n",
       "      <td>360254.80</td>\n",
       "      <td>118906.74</td>\n",
       "      <td>178717.89</td>\n",
       "      <td>26756.02</td>\n",
       "      <td>227139.69</td>\n",
       "      <td>248698.29</td>\n",
       "      <td>270910.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017-04-30</td>\n",
       "      <td>326994.07</td>\n",
       "      <td>191889.95</td>\n",
       "      <td>93859.98</td>\n",
       "      <td>389250.31</td>\n",
       "      <td>535106.28</td>\n",
       "      <td>104823.29</td>\n",
       "      <td>314064.33</td>\n",
       "      <td>159399.12</td>\n",
       "      <td>225477.48</td>\n",
       "      <td>...</td>\n",
       "      <td>201977.06</td>\n",
       "      <td>154409.58</td>\n",
       "      <td>116186.07</td>\n",
       "      <td>363148.26</td>\n",
       "      <td>120138.56</td>\n",
       "      <td>180467.27</td>\n",
       "      <td>27796.86</td>\n",
       "      <td>228359.51</td>\n",
       "      <td>248938.92</td>\n",
       "      <td>272070.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017-05-31</td>\n",
       "      <td>327962.34</td>\n",
       "      <td>192260.37</td>\n",
       "      <td>94812.11</td>\n",
       "      <td>388709.64</td>\n",
       "      <td>538274.75</td>\n",
       "      <td>104754.83</td>\n",
       "      <td>314049.22</td>\n",
       "      <td>159471.94</td>\n",
       "      <td>225828.91</td>\n",
       "      <td>...</td>\n",
       "      <td>203294.72</td>\n",
       "      <td>155492.11</td>\n",
       "      <td>115115.95</td>\n",
       "      <td>365085.52</td>\n",
       "      <td>120869.52</td>\n",
       "      <td>181256.70</td>\n",
       "      <td>28691.81</td>\n",
       "      <td>228371.01</td>\n",
       "      <td>249231.38</td>\n",
       "      <td>272600.60</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 180 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        date  Lake View  West Ridge  Little Village  Logan Square  \\\n",
       "0 2017-01-31  320800.53   187637.44        90925.08     385189.74   \n",
       "1 2017-02-28  323403.88   189553.40        92159.98     387715.94   \n",
       "2 2017-03-31  325554.65   191027.03        93255.23     388969.13   \n",
       "3 2017-04-30  326994.07   191889.95        93859.98     389250.31   \n",
       "4 2017-05-31  327962.34   192260.37        94812.11     388709.64   \n",
       "\n",
       "   Lincoln Park  South Austin  Irving Park  Rogers Park     Uptown  ...  \\\n",
       "0     527941.39     104123.27    308905.87    156084.35  222163.90  ...   \n",
       "1     530161.42     104668.31    311086.23    157619.44  223640.40  ...   \n",
       "2     532967.82     105138.79    313207.54    158774.66  224694.87  ...   \n",
       "3     535106.28     104823.29    314064.33    159399.12  225477.48  ...   \n",
       "4     538274.75     104754.83    314049.22    159471.94  225828.91  ...   \n",
       "\n",
       "   Beverly Woods  Sleepy Hollow  Lithuanian Plaza  Forest Glen  Beverly View  \\\n",
       "0      196512.18      150302.70         109474.19    353627.49     115870.21   \n",
       "1      198572.76      152146.67         114100.98    357398.54     117361.01   \n",
       "2      200222.71      153710.00         117062.46    360254.80     118906.74   \n",
       "3      201977.06      154409.58         116186.07    363148.26     120138.56   \n",
       "4      203294.72      155492.11         115115.95    365085.52     120869.52   \n",
       "\n",
       "   Heart of Italy  Golden Gate  Marycrest  Mount Greenwood Heights  \\\n",
       "0       174695.62     25263.13  222620.47                247078.01   \n",
       "1       177001.34     25686.90  224828.56                248058.67   \n",
       "2       178717.89     26756.02  227139.69                248698.29   \n",
       "3       180467.27     27796.86  228359.51                248938.92   \n",
       "4       181256.70     28691.81  228371.01                249231.38   \n",
       "\n",
       "   Schorsch Forest View  \n",
       "0             267835.82  \n",
       "1             269378.31  \n",
       "2             270910.81  \n",
       "3             272070.80  \n",
       "4             272600.60  \n",
       "\n",
       "[5 rows x 180 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>Lake View</th>\n",
       "      <th>West Ridge</th>\n",
       "      <th>Little Village</th>\n",
       "      <th>Logan Square</th>\n",
       "      <th>Lincoln Park</th>\n",
       "      <th>South Austin</th>\n",
       "      <th>Irving Park</th>\n",
       "      <th>Rogers Park</th>\n",
       "      <th>Uptown</th>\n",
       "      <th>...</th>\n",
       "      <th>Beverly Woods</th>\n",
       "      <th>Sleepy Hollow</th>\n",
       "      <th>Lithuanian Plaza</th>\n",
       "      <th>Forest Glen</th>\n",
       "      <th>Beverly View</th>\n",
       "      <th>Heart of Italy</th>\n",
       "      <th>Golden Gate</th>\n",
       "      <th>Marycrest</th>\n",
       "      <th>Mount Greenwood Heights</th>\n",
       "      <th>Schorsch Forest View</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-01-31</td>\n",
       "      <td>335152.96</td>\n",
       "      <td>213600.23</td>\n",
       "      <td>150609.69</td>\n",
       "      <td>438745.60</td>\n",
       "      <td>521486.14</td>\n",
       "      <td>180917.37</td>\n",
       "      <td>338774.43</td>\n",
       "      <td>179522.20</td>\n",
       "      <td>238384.29</td>\n",
       "      <td>...</td>\n",
       "      <td>240022.62</td>\n",
       "      <td>205658.71</td>\n",
       "      <td>190487.83</td>\n",
       "      <td>395487.22</td>\n",
       "      <td>151295.22</td>\n",
       "      <td>230912.58</td>\n",
       "      <td>55617.85</td>\n",
       "      <td>275760.18</td>\n",
       "      <td>280946.44</td>\n",
       "      <td>307632.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-02-28</td>\n",
       "      <td>337100.07</td>\n",
       "      <td>215838.54</td>\n",
       "      <td>154491.46</td>\n",
       "      <td>442793.48</td>\n",
       "      <td>522856.82</td>\n",
       "      <td>185608.39</td>\n",
       "      <td>342486.69</td>\n",
       "      <td>181330.85</td>\n",
       "      <td>239973.93</td>\n",
       "      <td>...</td>\n",
       "      <td>244533.10</td>\n",
       "      <td>210608.34</td>\n",
       "      <td>194609.02</td>\n",
       "      <td>399358.90</td>\n",
       "      <td>155797.67</td>\n",
       "      <td>233706.65</td>\n",
       "      <td>57571.20</td>\n",
       "      <td>280995.20</td>\n",
       "      <td>285493.77</td>\n",
       "      <td>311662.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-03-31</td>\n",
       "      <td>338529.20</td>\n",
       "      <td>217654.91</td>\n",
       "      <td>159032.56</td>\n",
       "      <td>446040.07</td>\n",
       "      <td>523647.18</td>\n",
       "      <td>191007.91</td>\n",
       "      <td>346194.55</td>\n",
       "      <td>182732.26</td>\n",
       "      <td>241113.30</td>\n",
       "      <td>...</td>\n",
       "      <td>248901.59</td>\n",
       "      <td>216042.02</td>\n",
       "      <td>198440.91</td>\n",
       "      <td>403079.57</td>\n",
       "      <td>161320.13</td>\n",
       "      <td>235914.92</td>\n",
       "      <td>60538.07</td>\n",
       "      <td>286359.51</td>\n",
       "      <td>289930.03</td>\n",
       "      <td>316208.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-04-30</td>\n",
       "      <td>339798.57</td>\n",
       "      <td>219105.80</td>\n",
       "      <td>163509.69</td>\n",
       "      <td>448541.71</td>\n",
       "      <td>523534.46</td>\n",
       "      <td>196147.32</td>\n",
       "      <td>349930.12</td>\n",
       "      <td>183811.50</td>\n",
       "      <td>241846.05</td>\n",
       "      <td>...</td>\n",
       "      <td>253083.58</td>\n",
       "      <td>220828.19</td>\n",
       "      <td>201429.10</td>\n",
       "      <td>407398.15</td>\n",
       "      <td>166625.77</td>\n",
       "      <td>236975.40</td>\n",
       "      <td>63795.06</td>\n",
       "      <td>290788.40</td>\n",
       "      <td>293810.50</td>\n",
       "      <td>320674.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-05-31</td>\n",
       "      <td>340754.04</td>\n",
       "      <td>219738.82</td>\n",
       "      <td>166556.65</td>\n",
       "      <td>449749.18</td>\n",
       "      <td>522886.53</td>\n",
       "      <td>199573.26</td>\n",
       "      <td>352042.45</td>\n",
       "      <td>184104.01</td>\n",
       "      <td>242134.79</td>\n",
       "      <td>...</td>\n",
       "      <td>256385.20</td>\n",
       "      <td>224200.84</td>\n",
       "      <td>202531.69</td>\n",
       "      <td>410880.33</td>\n",
       "      <td>171526.91</td>\n",
       "      <td>237436.86</td>\n",
       "      <td>66521.93</td>\n",
       "      <td>294977.07</td>\n",
       "      <td>297387.52</td>\n",
       "      <td>323826.16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 181 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        date  Lake View  West Ridge  Little Village  Logan Square  \\\n",
       "0 2021-01-31  335152.96   213600.23       150609.69     438745.60   \n",
       "1 2021-02-28  337100.07   215838.54       154491.46     442793.48   \n",
       "2 2021-03-31  338529.20   217654.91       159032.56     446040.07   \n",
       "3 2021-04-30  339798.57   219105.80       163509.69     448541.71   \n",
       "4 2021-05-31  340754.04   219738.82       166556.65     449749.18   \n",
       "\n",
       "   Lincoln Park  South Austin  Irving Park  Rogers Park     Uptown  ...  \\\n",
       "0     521486.14     180917.37    338774.43    179522.20  238384.29  ...   \n",
       "1     522856.82     185608.39    342486.69    181330.85  239973.93  ...   \n",
       "2     523647.18     191007.91    346194.55    182732.26  241113.30  ...   \n",
       "3     523534.46     196147.32    349930.12    183811.50  241846.05  ...   \n",
       "4     522886.53     199573.26    352042.45    184104.01  242134.79  ...   \n",
       "\n",
       "   Beverly Woods  Sleepy Hollow  Lithuanian Plaza  Forest Glen  Beverly View  \\\n",
       "0      240022.62      205658.71         190487.83    395487.22     151295.22   \n",
       "1      244533.10      210608.34         194609.02    399358.90     155797.67   \n",
       "2      248901.59      216042.02         198440.91    403079.57     161320.13   \n",
       "3      253083.58      220828.19         201429.10    407398.15     166625.77   \n",
       "4      256385.20      224200.84         202531.69    410880.33     171526.91   \n",
       "\n",
       "   Heart of Italy  Golden Gate  Marycrest  Mount Greenwood Heights  \\\n",
       "0       230912.58     55617.85  275760.18                280946.44   \n",
       "1       233706.65     57571.20  280995.20                285493.77   \n",
       "2       235914.92     60538.07  286359.51                289930.03   \n",
       "3       236975.40     63795.06  290788.40                293810.50   \n",
       "4       237436.86     66521.93  294977.07                297387.52   \n",
       "\n",
       "   Schorsch Forest View  \n",
       "0             307632.09  \n",
       "1             311662.78  \n",
       "2             316208.50  \n",
       "3             320674.89  \n",
       "4             323826.16  \n",
       "\n",
       "[5 rows x 181 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(neighborhood_data_2017_2019.head())\n",
    "display(neighborhood_data_2021_present.head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "# neighborhood_data_2017_2019 = neighborhood_data_2017_2019.iloc[1:]\n",
    "# neighborhood_data_2021_present = neighborhood_data_2021_present.iloc[1:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "# neighborhood_data_2017_2019.reset_index(inplace=True)\n",
    "# neighborhood_data_2021_present.reset_index(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "# neighborhood_data_2017_2019.rename(columns={'index':'date'}, inplace=True)\n",
    "# neighborhood_data_2021_present.rename(columns={'index':'date'}, inplace=True)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "neighborhood_data_2017_2019.to_csv('csv_files/neighborhood_data_2017_2019.csv', index = False)\n",
    "neighborhood_data_2021_present.to_csv('csv_files/neighborhood_data_2021_present.csv', index = False)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<H1><I>END OF CLEANING PROCESS<I><H1>"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "cs418env",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}