06_Basic_working_KeplerGL.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Importing essential libraries\n",
    "#### keplergl can be installed by ``pip install keplergl``"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import geopandas as gpd \n",
    "from keplergl import KeplerGl"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "User Guide: https://docs.kepler.gl/docs/keplergl-jupyter\n"
     ]
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "386f990add3d49cc87b90330f0e15d7b",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "KeplerGl(height=600)"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#Creating a empty KeplerGL map \n",
    "\n",
    "mp = KeplerGl(height=600,width=800)\n",
    "#show the map\n",
    "mp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>City</th>\n",
       "      <th>Country</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Shanghai</td>\n",
       "      <td>China</td>\n",
       "      <td>31.045556</td>\n",
       "      <td>121.399722</td>\n",
       "      <td>14608512</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Sao Paulo</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>-23.473293</td>\n",
       "      <td>-46.665803</td>\n",
       "      <td>10021437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Cairo</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>30.050000</td>\n",
       "      <td>31.250000</td>\n",
       "      <td>7734602</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>London</td>\n",
       "      <td>England</td>\n",
       "      <td>51.514125</td>\n",
       "      <td>-0.093689</td>\n",
       "      <td>7421228</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Toronto</td>\n",
       "      <td>Canada</td>\n",
       "      <td>43.666670</td>\n",
       "      <td>-79.416667</td>\n",
       "      <td>4612187</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Sydney</td>\n",
       "      <td>Australia</td>\n",
       "      <td>-33.861481</td>\n",
       "      <td>151.205475</td>\n",
       "      <td>4394585</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        City    Country   Latitude   Longitude  Population\n",
       "0   Shanghai      China  31.045556  121.399722    14608512\n",
       "1  Sao Paulo     Brazil -23.473293  -46.665803    10021437\n",
       "2      Cairo      Egypt  30.050000   31.250000     7734602\n",
       "3     London    England  51.514125   -0.093689     7421228\n",
       "4    Toronto     Canada  43.666670  -79.416667     4612187\n",
       "5     Sydney  Australia -33.861481  151.205475     4394585"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#creating a dataframe\n",
    "\n",
    "df = pd.DataFrame (\n",
    "    {\n",
    "        \"City\":['Shanghai','Sao Paulo','Cairo','London','Toronto','Sydney'],\n",
    "        \"Country\":['China','Brazil','Egypt','England','Canada','Australia'],\n",
    "        \"Latitude\":[31.045556,-23.473293,30.05,51.514125,43.66667,-33.861481],\n",
    "        \"Longitude\":[121.399722,-46.665803,31.25,-0.093689,-79.416667,151.205475],\n",
    "        \"Population\":[14608512,10021437,7734602,7421228,4612187,4394585]\n",
    "    }\n",
    ")\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "386f990add3d49cc87b90330f0e15d7b",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "KeplerGl(data={'cities': {'index': [0, 1, 2, 3, 4, 5], 'columns': ['City', 'Country', 'Latitude', 'Longitude',…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#Adding data into out empty map previously created under name \"cities\" using\n",
    "#keplerGL\n",
    "\n",
    "mp.add_data(data=df, name=\"cities\")\n",
    "\n",
    "# and customizing it afterwards, with population size as radius dimension\n",
    "mp"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Adding Geographic data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>anon_ticket_number</th>\n",
       "      <th>issue_datetime</th>\n",
       "      <th>anon_plate_id</th>\n",
       "      <th>violation_desc</th>\n",
       "      <th>fine</th>\n",
       "      <th>issuing_agency</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4674379</td>\n",
       "      <td>01/01/2015 00:00</td>\n",
       "      <td>934383</td>\n",
       "      <td>BLOCKNG MASS TRANSIT</td>\n",
       "      <td>101</td>\n",
       "      <td>SEPTA</td>\n",
       "      <td>39.975789</td>\n",
       "      <td>-75.163471</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4707189</td>\n",
       "      <td>01/01/2015 00:00</td>\n",
       "      <td>1065037</td>\n",
       "      <td>BLOCKNG MASS TRANSIT</td>\n",
       "      <td>101</td>\n",
       "      <td>SEPTA</td>\n",
       "      <td>39.975789</td>\n",
       "      <td>-75.163471</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4584526</td>\n",
       "      <td>01/01/2015 00:01</td>\n",
       "      <td>1262953</td>\n",
       "      <td>SIDEWALK   CC</td>\n",
       "      <td>76</td>\n",
       "      <td>POLICE</td>\n",
       "      <td>39.954927</td>\n",
       "      <td>-75.140262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4669046</td>\n",
       "      <td>01/01/2015 00:01</td>\n",
       "      <td>47082</td>\n",
       "      <td>SIDEWALK   CC</td>\n",
       "      <td>76</td>\n",
       "      <td>POLICE</td>\n",
       "      <td>39.954927</td>\n",
       "      <td>-75.140262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4588341</td>\n",
       "      <td>01/01/2015 00:02</td>\n",
       "      <td>1509569</td>\n",
       "      <td>SIDEWALK   CC</td>\n",
       "      <td>76</td>\n",
       "      <td>POLICE</td>\n",
       "      <td>39.954927</td>\n",
       "      <td>-75.140262</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   anon_ticket_number    issue_datetime  anon_plate_id        violation_desc  \\\n",
       "0             4674379  01/01/2015 00:00         934383  BLOCKNG MASS TRANSIT   \n",
       "1             4707189  01/01/2015 00:00        1065037  BLOCKNG MASS TRANSIT   \n",
       "2             4584526  01/01/2015 00:01        1262953         SIDEWALK   CC   \n",
       "3             4669046  01/01/2015 00:01          47082         SIDEWALK   CC   \n",
       "4             4588341  01/01/2015 00:02        1509569         SIDEWALK   CC   \n",
       "\n",
       "   fine issuing_agency        lat        lon  \n",
       "0   101          SEPTA  39.975789 -75.163471  \n",
       "1   101          SEPTA  39.975789 -75.163471  \n",
       "2    76         POLICE  39.954927 -75.140262  \n",
       "3    76         POLICE  39.954927 -75.140262  \n",
       "4    76         POLICE  39.954927 -75.140262  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## parking violation dataset from philadelphia\n",
    "\n",
    "parking_df = pd.read_csv(\"data/parking_violations_2015.csv\")\n",
    "parking_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(119910, 8)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "parking_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "parking_df.dropna(subset=[\"lat\",\"lon\"],how='all',inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(107710, 8)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "parking_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "gdf = gpd.GeoDataFrame(parking_df,geometry=gpd.points_from_xy(parking_df.lon,parking_df.lat),crs=\"EPSG:4326\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>anon_ticket_number</th>\n",
       "      <th>issue_datetime</th>\n",
       "      <th>anon_plate_id</th>\n",
       "      <th>violation_desc</th>\n",
       "      <th>fine</th>\n",
       "      <th>issuing_agency</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4674379</td>\n",
       "      <td>01/01/2015 00:00</td>\n",
       "      <td>934383</td>\n",
       "      <td>BLOCKNG MASS TRANSIT</td>\n",
       "      <td>101</td>\n",
       "      <td>SEPTA</td>\n",
       "      <td>39.975789</td>\n",
       "      <td>-75.163471</td>\n",
       "      <td>POINT (-75.16347 39.97579)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4707189</td>\n",
       "      <td>01/01/2015 00:00</td>\n",
       "      <td>1065037</td>\n",
       "      <td>BLOCKNG MASS TRANSIT</td>\n",
       "      <td>101</td>\n",
       "      <td>SEPTA</td>\n",
       "      <td>39.975789</td>\n",
       "      <td>-75.163471</td>\n",
       "      <td>POINT (-75.16347 39.97579)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4584526</td>\n",
       "      <td>01/01/2015 00:01</td>\n",
       "      <td>1262953</td>\n",
       "      <td>SIDEWALK   CC</td>\n",
       "      <td>76</td>\n",
       "      <td>POLICE</td>\n",
       "      <td>39.954927</td>\n",
       "      <td>-75.140262</td>\n",
       "      <td>POINT (-75.14026 39.95493)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4669046</td>\n",
       "      <td>01/01/2015 00:01</td>\n",
       "      <td>47082</td>\n",
       "      <td>SIDEWALK   CC</td>\n",
       "      <td>76</td>\n",
       "      <td>POLICE</td>\n",
       "      <td>39.954927</td>\n",
       "      <td>-75.140262</td>\n",
       "      <td>POINT (-75.14026 39.95493)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4588341</td>\n",
       "      <td>01/01/2015 00:02</td>\n",
       "      <td>1509569</td>\n",
       "      <td>SIDEWALK   CC</td>\n",
       "      <td>76</td>\n",
       "      <td>POLICE</td>\n",
       "      <td>39.954927</td>\n",
       "      <td>-75.140262</td>\n",
       "      <td>POINT (-75.14026 39.95493)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   anon_ticket_number    issue_datetime  anon_plate_id        violation_desc  \\\n",
       "0             4674379  01/01/2015 00:00         934383  BLOCKNG MASS TRANSIT   \n",
       "1             4707189  01/01/2015 00:00        1065037  BLOCKNG MASS TRANSIT   \n",
       "2             4584526  01/01/2015 00:01        1262953         SIDEWALK   CC   \n",
       "3             4669046  01/01/2015 00:01          47082         SIDEWALK   CC   \n",
       "4             4588341  01/01/2015 00:02        1509569         SIDEWALK   CC   \n",
       "\n",
       "   fine issuing_agency        lat        lon                    geometry  \n",
       "0   101          SEPTA  39.975789 -75.163471  POINT (-75.16347 39.97579)  \n",
       "1   101          SEPTA  39.975789 -75.163471  POINT (-75.16347 39.97579)  \n",
       "2    76         POLICE  39.954927 -75.140262  POINT (-75.14026 39.95493)  \n",
       "3    76         POLICE  39.954927 -75.140262  POINT (-75.14026 39.95493)  \n",
       "4    76         POLICE  39.954927 -75.140262  POINT (-75.14026 39.95493)  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gdf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Python39\\lib\\site-packages\\geopandas\\io\\file.py:362: FutureWarning: pandas.Int64Index is deprecated and will be removed from pandas in a future version. Use pandas.Index with the appropriate dtype instead.\n",
      "  pd.Int64Index,\n"
     ]
    }
   ],
   "source": [
    "#Adding parking - GeoJSON data now\n",
    "gdf.to_file(\"data/parking_2015.geojson\",drivers=\"GeoJSON\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "User Guide: https://docs.kepler.gl/docs/keplergl-jupyter\n"
     ]
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "dec7d0a4729d44ac85e0eb11cd4b7a83",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "KeplerGl(data={'parking_points': {'index': [0, 1, 2, 3, 4, 5, 7, 8, 10, 12, 13, 14, 15, 17, 20, 21, 22, 23, 24…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#now using KeplerGL to create geomaps for parking violations\n",
    "mp = KeplerGl(height=900)\n",
    "mp.add_data(data=gdf,name='parking_points')\n",
    "mp"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 3D Hexagon"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "import geopandas as gpd\n",
    "from keplergl import KeplerGl"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>anon_ticket_number</th>\n",
       "      <th>issue_datetime</th>\n",
       "      <th>anon_plate_id</th>\n",
       "      <th>violation_desc</th>\n",
       "      <th>fine</th>\n",
       "      <th>issuing_agency</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4674379</td>\n",
       "      <td>01/01/2015 00:00</td>\n",
       "      <td>934383</td>\n",
       "      <td>BLOCKNG MASS TRANSIT</td>\n",
       "      <td>101</td>\n",
       "      <td>SEPTA</td>\n",
       "      <td>39.975789</td>\n",
       "      <td>-75.163471</td>\n",
       "      <td>POINT (-75.16347 39.97579)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4707189</td>\n",
       "      <td>01/01/2015 00:00</td>\n",
       "      <td>1065037</td>\n",
       "      <td>BLOCKNG MASS TRANSIT</td>\n",
       "      <td>101</td>\n",
       "      <td>SEPTA</td>\n",
       "      <td>39.975789</td>\n",
       "      <td>-75.163471</td>\n",
       "      <td>POINT (-75.16347 39.97579)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4584526</td>\n",
       "      <td>01/01/2015 00:01</td>\n",
       "      <td>1262953</td>\n",
       "      <td>SIDEWALK   CC</td>\n",
       "      <td>76</td>\n",
       "      <td>POLICE</td>\n",
       "      <td>39.954927</td>\n",
       "      <td>-75.140262</td>\n",
       "      <td>POINT (-75.14026 39.95493)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4669046</td>\n",
       "      <td>01/01/2015 00:01</td>\n",
       "      <td>47082</td>\n",
       "      <td>SIDEWALK   CC</td>\n",
       "      <td>76</td>\n",
       "      <td>POLICE</td>\n",
       "      <td>39.954927</td>\n",
       "      <td>-75.140262</td>\n",
       "      <td>POINT (-75.14026 39.95493)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4588341</td>\n",
       "      <td>01/01/2015 00:02</td>\n",
       "      <td>1509569</td>\n",
       "      <td>SIDEWALK   CC</td>\n",
       "      <td>76</td>\n",
       "      <td>POLICE</td>\n",
       "      <td>39.954927</td>\n",
       "      <td>-75.140262</td>\n",
       "      <td>POINT (-75.14026 39.95493)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   anon_ticket_number    issue_datetime  anon_plate_id        violation_desc  \\\n",
       "0             4674379  01/01/2015 00:00         934383  BLOCKNG MASS TRANSIT   \n",
       "1             4707189  01/01/2015 00:00        1065037  BLOCKNG MASS TRANSIT   \n",
       "2             4584526  01/01/2015 00:01        1262953         SIDEWALK   CC   \n",
       "3             4669046  01/01/2015 00:01          47082         SIDEWALK   CC   \n",
       "4             4588341  01/01/2015 00:02        1509569         SIDEWALK   CC   \n",
       "\n",
       "   fine issuing_agency        lat        lon                    geometry  \n",
       "0   101          SEPTA  39.975789 -75.163471  POINT (-75.16347 39.97579)  \n",
       "1   101          SEPTA  39.975789 -75.163471  POINT (-75.16347 39.97579)  \n",
       "2    76         POLICE  39.954927 -75.140262  POINT (-75.14026 39.95493)  \n",
       "3    76         POLICE  39.954927 -75.140262  POINT (-75.14026 39.95493)  \n",
       "4    76         POLICE  39.954927 -75.140262  POINT (-75.14026 39.95493)  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gdf = gpd.read_file(\"data/parking_2015.geojson\")\n",
    "gdf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "User Guide: https://docs.kepler.gl/docs/keplergl-jupyter\n"
     ]
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "7f83541b72ba4459a28b59af13f08952",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "KeplerGl(data={'3dHexagon': {'index': [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 2…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "mp = KeplerGl(height=900)\n",
    "mp.add_data(data=gdf,name='3dHexagon')\n",
    "mp"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Animation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>anon_ticket_number</th>\n",
       "      <th>issue_datetime</th>\n",
       "      <th>anon_plate_id</th>\n",
       "      <th>violation_desc</th>\n",
       "      <th>fine</th>\n",
       "      <th>issuing_agency</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4674379</td>\n",
       "      <td>01/01/2015 00:00</td>\n",
       "      <td>934383</td>\n",
       "      <td>BLOCKNG MASS TRANSIT</td>\n",
       "      <td>101</td>\n",
       "      <td>SEPTA</td>\n",
       "      <td>39.975789</td>\n",
       "      <td>-75.163471</td>\n",
       "      <td>POINT (-75.16347 39.97579)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4707189</td>\n",
       "      <td>01/01/2015 00:00</td>\n",
       "      <td>1065037</td>\n",
       "      <td>BLOCKNG MASS TRANSIT</td>\n",
       "      <td>101</td>\n",
       "      <td>SEPTA</td>\n",
       "      <td>39.975789</td>\n",
       "      <td>-75.163471</td>\n",
       "      <td>POINT (-75.16347 39.97579)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4584526</td>\n",
       "      <td>01/01/2015 00:01</td>\n",
       "      <td>1262953</td>\n",
       "      <td>SIDEWALK   CC</td>\n",
       "      <td>76</td>\n",
       "      <td>POLICE</td>\n",
       "      <td>39.954927</td>\n",
       "      <td>-75.140262</td>\n",
       "      <td>POINT (-75.14026 39.95493)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4669046</td>\n",
       "      <td>01/01/2015 00:01</td>\n",
       "      <td>47082</td>\n",
       "      <td>SIDEWALK   CC</td>\n",
       "      <td>76</td>\n",
       "      <td>POLICE</td>\n",
       "      <td>39.954927</td>\n",
       "      <td>-75.140262</td>\n",
       "      <td>POINT (-75.14026 39.95493)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4588341</td>\n",
       "      <td>01/01/2015 00:02</td>\n",
       "      <td>1509569</td>\n",
       "      <td>SIDEWALK   CC</td>\n",
       "      <td>76</td>\n",
       "      <td>POLICE</td>\n",
       "      <td>39.954927</td>\n",
       "      <td>-75.140262</td>\n",
       "      <td>POINT (-75.14026 39.95493)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   anon_ticket_number    issue_datetime  anon_plate_id        violation_desc  \\\n",
       "0             4674379  01/01/2015 00:00         934383  BLOCKNG MASS TRANSIT   \n",
       "1             4707189  01/01/2015 00:00        1065037  BLOCKNG MASS TRANSIT   \n",
       "2             4584526  01/01/2015 00:01        1262953         SIDEWALK   CC   \n",
       "3             4669046  01/01/2015 00:01          47082         SIDEWALK   CC   \n",
       "4             4588341  01/01/2015 00:02        1509569         SIDEWALK   CC   \n",
       "\n",
       "   fine issuing_agency        lat        lon                    geometry  \n",
       "0   101          SEPTA  39.975789 -75.163471  POINT (-75.16347 39.97579)  \n",
       "1   101          SEPTA  39.975789 -75.163471  POINT (-75.16347 39.97579)  \n",
       "2    76         POLICE  39.954927 -75.140262  POINT (-75.14026 39.95493)  \n",
       "3    76         POLICE  39.954927 -75.140262  POINT (-75.14026 39.95493)  \n",
       "4    76         POLICE  39.954927 -75.140262  POINT (-75.14026 39.95493)  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "gdf = gpd.read_file(\"data/parking_2015.geojson\",parse_dates=True)\n",
    "gdf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>anon_ticket_number</th>\n",
       "      <th>issue_datetime</th>\n",
       "      <th>anon_plate_id</th>\n",
       "      <th>violation_desc</th>\n",
       "      <th>fine</th>\n",
       "      <th>issuing_agency</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>30153</th>\n",
       "      <td>4674565</td>\n",
       "      <td>2015-01-10 22:07:00</td>\n",
       "      <td>350683</td>\n",
       "      <td>STOP PROHIBITED CC</td>\n",
       "      <td>76</td>\n",
       "      <td>PPA</td>\n",
       "      <td>39.948225</td>\n",
       "      <td>-75.142874</td>\n",
       "      <td>POINT (-75.14287 39.94822)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100239</th>\n",
       "      <td>4789959</td>\n",
       "      <td>2015-01-30 12:13:00</td>\n",
       "      <td>1660814</td>\n",
       "      <td>STOPPING PROHIBITED</td>\n",
       "      <td>51</td>\n",
       "      <td>PPA</td>\n",
       "      <td>39.995410</td>\n",
       "      <td>-75.115334</td>\n",
       "      <td>POINT (-75.11533 39.99541)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73703</th>\n",
       "      <td>4520828</td>\n",
       "      <td>2015-01-22 13:34:00</td>\n",
       "      <td>1323519</td>\n",
       "      <td>METER EXPIRED</td>\n",
       "      <td>26</td>\n",
       "      <td>PPA</td>\n",
       "      <td>39.917732</td>\n",
       "      <td>-75.171215</td>\n",
       "      <td>POINT (-75.17121 39.91773)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57109</th>\n",
       "      <td>4686287</td>\n",
       "      <td>2015-01-17 20:10:00</td>\n",
       "      <td>6998</td>\n",
       "      <td>METER EXPIRED CC</td>\n",
       "      <td>36</td>\n",
       "      <td>PPA</td>\n",
       "      <td>39.941346</td>\n",
       "      <td>-75.150600</td>\n",
       "      <td>POINT (-75.15060 39.94135)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39568</th>\n",
       "      <td>4532560</td>\n",
       "      <td>2015-01-13 20:50:00</td>\n",
       "      <td>298908</td>\n",
       "      <td>METER EXPIRED CC</td>\n",
       "      <td>36</td>\n",
       "      <td>PPA</td>\n",
       "      <td>39.954289</td>\n",
       "      <td>-75.170578</td>\n",
       "      <td>POINT (-75.17058 39.95429)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69798</th>\n",
       "      <td>4564099</td>\n",
       "      <td>2015-01-21 14:09:00</td>\n",
       "      <td>1148245</td>\n",
       "      <td>METER EXPIRED CC</td>\n",
       "      <td>36</td>\n",
       "      <td>PPA</td>\n",
       "      <td>39.941456</td>\n",
       "      <td>-75.147851</td>\n",
       "      <td>POINT (-75.14785 39.94146)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30846</th>\n",
       "      <td>4551415</td>\n",
       "      <td>2015-01-11 14:14:00</td>\n",
       "      <td>365392</td>\n",
       "      <td>PARKING PROHBITED CC</td>\n",
       "      <td>51</td>\n",
       "      <td>PPA</td>\n",
       "      <td>39.948860</td>\n",
       "      <td>-75.169801</td>\n",
       "      <td>POINT (-75.16980 39.94886)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89855</th>\n",
       "      <td>4676876</td>\n",
       "      <td>2015-01-27 19:57:00</td>\n",
       "      <td>198831</td>\n",
       "      <td>METER EXPIRED CC</td>\n",
       "      <td>36</td>\n",
       "      <td>PPA</td>\n",
       "      <td>39.947447</td>\n",
       "      <td>-75.158427</td>\n",
       "      <td>POINT (-75.15843 39.94745)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81613</th>\n",
       "      <td>4709485</td>\n",
       "      <td>2015-01-24 08:42:00</td>\n",
       "      <td>1495426</td>\n",
       "      <td>METER EXPIRED CC</td>\n",
       "      <td>36</td>\n",
       "      <td>PPA</td>\n",
       "      <td>39.964213</td>\n",
       "      <td>-75.175244</td>\n",
       "      <td>POINT (-75.17524 39.96421)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12577</th>\n",
       "      <td>4570712</td>\n",
       "      <td>2015-01-06 11:40:00</td>\n",
       "      <td>1695056</td>\n",
       "      <td>PARKING PROHBITED CC</td>\n",
       "      <td>51</td>\n",
       "      <td>PPA</td>\n",
       "      <td>39.949713</td>\n",
       "      <td>-75.154705</td>\n",
       "      <td>POINT (-75.15471 39.94971)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        anon_ticket_number      issue_datetime  anon_plate_id  \\\n",
       "30153              4674565 2015-01-10 22:07:00         350683   \n",
       "100239             4789959 2015-01-30 12:13:00        1660814   \n",
       "73703              4520828 2015-01-22 13:34:00        1323519   \n",
       "57109              4686287 2015-01-17 20:10:00           6998   \n",
       "39568              4532560 2015-01-13 20:50:00         298908   \n",
       "69798              4564099 2015-01-21 14:09:00        1148245   \n",
       "30846              4551415 2015-01-11 14:14:00         365392   \n",
       "89855              4676876 2015-01-27 19:57:00         198831   \n",
       "81613              4709485 2015-01-24 08:42:00        1495426   \n",
       "12577              4570712 2015-01-06 11:40:00        1695056   \n",
       "\n",
       "              violation_desc  fine issuing_agency        lat        lon  \\\n",
       "30153     STOP PROHIBITED CC    76            PPA  39.948225 -75.142874   \n",
       "100239   STOPPING PROHIBITED    51            PPA  39.995410 -75.115334   \n",
       "73703          METER EXPIRED    26            PPA  39.917732 -75.171215   \n",
       "57109       METER EXPIRED CC    36            PPA  39.941346 -75.150600   \n",
       "39568       METER EXPIRED CC    36            PPA  39.954289 -75.170578   \n",
       "69798       METER EXPIRED CC    36            PPA  39.941456 -75.147851   \n",
       "30846   PARKING PROHBITED CC    51            PPA  39.948860 -75.169801   \n",
       "89855       METER EXPIRED CC    36            PPA  39.947447 -75.158427   \n",
       "81613       METER EXPIRED CC    36            PPA  39.964213 -75.175244   \n",
       "12577   PARKING PROHBITED CC    51            PPA  39.949713 -75.154705   \n",
       "\n",
       "                          geometry  \n",
       "30153   POINT (-75.14287 39.94822)  \n",
       "100239  POINT (-75.11533 39.99541)  \n",
       "73703   POINT (-75.17121 39.91773)  \n",
       "57109   POINT (-75.15060 39.94135)  \n",
       "39568   POINT (-75.17058 39.95429)  \n",
       "69798   POINT (-75.14785 39.94146)  \n",
       "30846   POINT (-75.16980 39.94886)  \n",
       "89855   POINT (-75.15843 39.94745)  \n",
       "81613   POINT (-75.17524 39.96421)  \n",
       "12577   POINT (-75.15471 39.94971)  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gdf[\"issue_datetime\"] = pd.to_datetime(gdf[\"issue_datetime\"], dayfirst=True)\n",
    "gdf.sample(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "User Guide: https://docs.kepler.gl/docs/keplergl-jupyter\n"
     ]
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "264a496f2cac479c9021b30bbe8a76f1",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "KeplerGl(data={'animation': {'index': [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 2…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "mp = KeplerGl(height=900)\n",
    "mp.add_data(data=gdf,name='animation')\n",
    "mp"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Chloropeth Maps"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>NAME</th>\n",
       "      <th>LISTNAME</th>\n",
       "      <th>MAPNAME</th>\n",
       "      <th>Shape_Leng</th>\n",
       "      <th>Shape_Area</th>\n",
       "      <th>NUMPOINTS</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BRIDESBURG</td>\n",
       "      <td>Bridesburg</td>\n",
       "      <td>Bridesburg</td>\n",
       "      <td>27814.546521</td>\n",
       "      <td>4.458626e+07</td>\n",
       "      <td>149.0</td>\n",
       "      <td>MULTIPOLYGON (((2719789.837 256235.538, 271981...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BUSTLETON</td>\n",
       "      <td>Bustleton</td>\n",
       "      <td>Bustleton</td>\n",
       "      <td>48868.458365</td>\n",
       "      <td>1.140504e+08</td>\n",
       "      <td>228.0</td>\n",
       "      <td>MULTIPOLYGON (((2733378.171 289259.945, 273281...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CEDARBROOK</td>\n",
       "      <td>Cedarbrook</td>\n",
       "      <td>Cedarbrook</td>\n",
       "      <td>20021.415802</td>\n",
       "      <td>2.487174e+07</td>\n",
       "      <td>129.0</td>\n",
       "      <td>MULTIPOLYGON (((2685267.950 279747.336, 268527...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CHESTNUT_HILL</td>\n",
       "      <td>Chestnut Hill</td>\n",
       "      <td>Chestnut Hill</td>\n",
       "      <td>56394.297195</td>\n",
       "      <td>7.966498e+07</td>\n",
       "      <td>7783.0</td>\n",
       "      <td>MULTIPOLYGON (((2678490.151 284400.400, 267851...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>EAST_FALLS</td>\n",
       "      <td>East Falls</td>\n",
       "      <td>East Falls</td>\n",
       "      <td>27400.776417</td>\n",
       "      <td>4.057689e+07</td>\n",
       "      <td>3715.0</td>\n",
       "      <td>MULTIPOLYGON (((2686769.727 263625.367, 268692...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            NAME       LISTNAME        MAPNAME    Shape_Leng    Shape_Area  \\\n",
       "0     BRIDESBURG     Bridesburg     Bridesburg  27814.546521  4.458626e+07   \n",
       "1      BUSTLETON      Bustleton      Bustleton  48868.458365  1.140504e+08   \n",
       "2     CEDARBROOK     Cedarbrook     Cedarbrook  20021.415802  2.487174e+07   \n",
       "3  CHESTNUT_HILL  Chestnut Hill  Chestnut Hill  56394.297195  7.966498e+07   \n",
       "4     EAST_FALLS     East Falls     East Falls  27400.776417  4.057689e+07   \n",
       "\n",
       "   NUMPOINTS                                           geometry  \n",
       "0      149.0  MULTIPOLYGON (((2719789.837 256235.538, 271981...  \n",
       "1      228.0  MULTIPOLYGON (((2733378.171 289259.945, 273281...  \n",
       "2      129.0  MULTIPOLYGON (((2685267.950 279747.336, 268527...  \n",
       "3     7783.0  MULTIPOLYGON (((2678490.151 284400.400, 267851...  \n",
       "4     3715.0  MULTIPOLYGON (((2686769.727 263625.367, 268692...  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "neighbourhoods = gpd.read_file(\"data/neighbrhoods.geojson\")\n",
    "neighbourhoods.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Derived Projected CRS: EPSG:2272>\n",
       "Name: NAD83 / Pennsylvania South (ftUS)\n",
       "Axis Info [cartesian]:\n",
       "- X[east]: Easting (US survey foot)\n",
       "- Y[north]: Northing (US survey foot)\n",
       "Area of Use:\n",
       "- name: United States (USA) - Pennsylvania - counties of Adams; Allegheny; Armstrong; Beaver; Bedford; Berks; Blair; Bucks; Butler; Cambria; Chester; Cumberland; Dauphin; Delaware; Fayette; Franklin; Fulton; Greene; Huntingdon; Indiana; Juniata; Lancaster; Lawrence; Lebanon; Lehigh; Mifflin; Montgomery; Northampton; Perry; Philadelphia; Schuylkill; Snyder; Somerset; Washington; Westmoreland; York.\n",
       "- bounds: (-80.53, 39.71, -74.72, 41.18)\n",
       "Coordinate Operation:\n",
       "- name: SPCS83 Pennsylvania South zone (US Survey feet)\n",
       "- method: Lambert Conic Conformal (2SP)\n",
       "Datum: North American Datum 1983\n",
       "- Ellipsoid: GRS 1980\n",
       "- Prime Meridian: Greenwich"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "neighbourhoods.crs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "neighbourhoods = neighbourhoods.to_crs(\"EPSG:4326\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "User Guide: https://docs.kepler.gl/docs/keplergl-jupyter\n"
     ]
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "092a6a2916164c50a9de15a84a0fe8ac",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "KeplerGl(data={'Chloropeth Maps': {'index': [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18,…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "mp = KeplerGl(height=900)\n",
    "mp.add_data(data=neighbourhoods,name='Chloropeth Maps')\n",
    "mp"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Spatial join Preprocessing"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>anon_ticket_number</th>\n",
       "      <th>issue_datetime</th>\n",
       "      <th>anon_plate_id</th>\n",
       "      <th>violation_desc</th>\n",
       "      <th>fine</th>\n",
       "      <th>issuing_agency</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4674379</td>\n",
       "      <td>01/01/2015 00:00</td>\n",
       "      <td>934383</td>\n",
       "      <td>BLOCKNG MASS TRANSIT</td>\n",
       "      <td>101</td>\n",
       "      <td>SEPTA</td>\n",
       "      <td>39.975789</td>\n",
       "      <td>-75.163471</td>\n",
       "      <td>POINT (-75.16347 39.97579)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4707189</td>\n",
       "      <td>01/01/2015 00:00</td>\n",
       "      <td>1065037</td>\n",
       "      <td>BLOCKNG MASS TRANSIT</td>\n",
       "      <td>101</td>\n",
       "      <td>SEPTA</td>\n",
       "      <td>39.975789</td>\n",
       "      <td>-75.163471</td>\n",
       "      <td>POINT (-75.16347 39.97579)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4584526</td>\n",
       "      <td>01/01/2015 00:01</td>\n",
       "      <td>1262953</td>\n",
       "      <td>SIDEWALK   CC</td>\n",
       "      <td>76</td>\n",
       "      <td>POLICE</td>\n",
       "      <td>39.954927</td>\n",
       "      <td>-75.140262</td>\n",
       "      <td>POINT (-75.14026 39.95493)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4669046</td>\n",
       "      <td>01/01/2015 00:01</td>\n",
       "      <td>47082</td>\n",
       "      <td>SIDEWALK   CC</td>\n",
       "      <td>76</td>\n",
       "      <td>POLICE</td>\n",
       "      <td>39.954927</td>\n",
       "      <td>-75.140262</td>\n",
       "      <td>POINT (-75.14026 39.95493)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4588341</td>\n",
       "      <td>01/01/2015 00:02</td>\n",
       "      <td>1509569</td>\n",
       "      <td>SIDEWALK   CC</td>\n",
       "      <td>76</td>\n",
       "      <td>POLICE</td>\n",
       "      <td>39.954927</td>\n",
       "      <td>-75.140262</td>\n",
       "      <td>POINT (-75.14026 39.95493)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   anon_ticket_number    issue_datetime  anon_plate_id        violation_desc  \\\n",
       "0             4674379  01/01/2015 00:00         934383  BLOCKNG MASS TRANSIT   \n",
       "1             4707189  01/01/2015 00:00        1065037  BLOCKNG MASS TRANSIT   \n",
       "2             4584526  01/01/2015 00:01        1262953         SIDEWALK   CC   \n",
       "3             4669046  01/01/2015 00:01          47082         SIDEWALK   CC   \n",
       "4             4588341  01/01/2015 00:02        1509569         SIDEWALK   CC   \n",
       "\n",
       "   fine issuing_agency        lat        lon                    geometry  \n",
       "0   101          SEPTA  39.975789 -75.163471  POINT (-75.16347 39.97579)  \n",
       "1   101          SEPTA  39.975789 -75.163471  POINT (-75.16347 39.97579)  \n",
       "2    76         POLICE  39.954927 -75.140262  POINT (-75.14026 39.95493)  \n",
       "3    76         POLICE  39.954927 -75.140262  POINT (-75.14026 39.95493)  \n",
       "4    76         POLICE  39.954927 -75.140262  POINT (-75.14026 39.95493)  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gdf = gpd.read_file('data/parking_2015.geojson')\n",
    "gdf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>NAME</th>\n",
       "      <th>LISTNAME</th>\n",
       "      <th>MAPNAME</th>\n",
       "      <th>Shape_Leng</th>\n",
       "      <th>Shape_Area</th>\n",
       "      <th>NUMPOINTS</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BRIDESBURG</td>\n",
       "      <td>Bridesburg</td>\n",
       "      <td>Bridesburg</td>\n",
       "      <td>27814.546521</td>\n",
       "      <td>4.458626e+07</td>\n",
       "      <td>149.0</td>\n",
       "      <td>MULTIPOLYGON (((2719789.837 256235.538, 271981...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BUSTLETON</td>\n",
       "      <td>Bustleton</td>\n",
       "      <td>Bustleton</td>\n",
       "      <td>48868.458365</td>\n",
       "      <td>1.140504e+08</td>\n",
       "      <td>228.0</td>\n",
       "      <td>MULTIPOLYGON (((2733378.171 289259.945, 273281...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CEDARBROOK</td>\n",
       "      <td>Cedarbrook</td>\n",
       "      <td>Cedarbrook</td>\n",
       "      <td>20021.415802</td>\n",
       "      <td>2.487174e+07</td>\n",
       "      <td>129.0</td>\n",
       "      <td>MULTIPOLYGON (((2685267.950 279747.336, 268527...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CHESTNUT_HILL</td>\n",
       "      <td>Chestnut Hill</td>\n",
       "      <td>Chestnut Hill</td>\n",
       "      <td>56394.297195</td>\n",
       "      <td>7.966498e+07</td>\n",
       "      <td>7783.0</td>\n",
       "      <td>MULTIPOLYGON (((2678490.151 284400.400, 267851...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>EAST_FALLS</td>\n",
       "      <td>East Falls</td>\n",
       "      <td>East Falls</td>\n",
       "      <td>27400.776417</td>\n",
       "      <td>4.057689e+07</td>\n",
       "      <td>3715.0</td>\n",
       "      <td>MULTIPOLYGON (((2686769.727 263625.367, 268692...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            NAME       LISTNAME        MAPNAME    Shape_Leng    Shape_Area  \\\n",
       "0     BRIDESBURG     Bridesburg     Bridesburg  27814.546521  4.458626e+07   \n",
       "1      BUSTLETON      Bustleton      Bustleton  48868.458365  1.140504e+08   \n",
       "2     CEDARBROOK     Cedarbrook     Cedarbrook  20021.415802  2.487174e+07   \n",
       "3  CHESTNUT_HILL  Chestnut Hill  Chestnut Hill  56394.297195  7.966498e+07   \n",
       "4     EAST_FALLS     East Falls     East Falls  27400.776417  4.057689e+07   \n",
       "\n",
       "   NUMPOINTS                                           geometry  \n",
       "0      149.0  MULTIPOLYGON (((2719789.837 256235.538, 271981...  \n",
       "1      228.0  MULTIPOLYGON (((2733378.171 289259.945, 273281...  \n",
       "2      129.0  MULTIPOLYGON (((2685267.950 279747.336, 268527...  \n",
       "3     7783.0  MULTIPOLYGON (((2678490.151 284400.400, 267851...  \n",
       "4     3715.0  MULTIPOLYGON (((2686769.727 263625.367, 268692...  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "neighbourhoods = gpd.read_file('data/neighbrhoods.geojson')\n",
    "neighbourhoods.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gdf.crs == neighbourhoods.crs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "neighbourhoods = neighbourhoods.to_crs(\"EPSG:4326\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gdf.crs == neighbourhoods.crs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Python39\\lib\\site-packages\\IPython\\core\\interactiveshell.py:3337: FutureWarning: The `op` parameter is deprecated and will be removed in a future release. Please use the `predicate` parameter instead.\n",
      "  if await self.run_code(code, result, async_=asy):\n"
     ]
    }
   ],
   "source": [
    "location_join = gpd.sjoin(gdf,neighbourhoods,op=\"within\")"
   ]
  },
  {
   "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>anon_ticket_number</th>\n",
       "      <th>issue_datetime</th>\n",
       "      <th>anon_plate_id</th>\n",
       "      <th>violation_desc</th>\n",
       "      <th>fine</th>\n",
       "      <th>issuing_agency</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>geometry</th>\n",
       "      <th>index_right</th>\n",
       "      <th>NAME</th>\n",
       "      <th>LISTNAME</th>\n",
       "      <th>MAPNAME</th>\n",
       "      <th>Shape_Leng</th>\n",
       "      <th>Shape_Area</th>\n",
       "      <th>NUMPOINTS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>55161</th>\n",
       "      <td>4770060</td>\n",
       "      <td>17/01/2015 12:14</td>\n",
       "      <td>892358</td>\n",
       "      <td>METER EXPIRED CC</td>\n",
       "      <td>36</td>\n",
       "      <td>PPA</td>\n",
       "      <td>39.955252</td>\n",
       "      <td>-75.202351</td>\n",
       "      <td>POINT (-75.20235 39.95525)</td>\n",
       "      <td>125</td>\n",
       "      <td>UNIVERSITY_CITY</td>\n",
       "      <td>University City</td>\n",
       "      <td>University City</td>\n",
       "      <td>26985.308865</td>\n",
       "      <td>3.299364e+07</td>\n",
       "      <td>56759.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11265</th>\n",
       "      <td>4683890</td>\n",
       "      <td>05/01/2015 18:20</td>\n",
       "      <td>1548896</td>\n",
       "      <td>CORNER CLEARANCE</td>\n",
       "      <td>51</td>\n",
       "      <td>POLICE</td>\n",
       "      <td>39.996076</td>\n",
       "      <td>-75.171048</td>\n",
       "      <td>POINT (-75.17105 39.99608)</td>\n",
       "      <td>142</td>\n",
       "      <td>STRAWBERRY_MANSION</td>\n",
       "      <td>Strawberry Mansion</td>\n",
       "      <td>Strawberry Mansion</td>\n",
       "      <td>28308.168132</td>\n",
       "      <td>2.575296e+07</td>\n",
       "      <td>769.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89746</th>\n",
       "      <td>4674519</td>\n",
       "      <td>27/01/2015 17:44</td>\n",
       "      <td>468950</td>\n",
       "      <td>STOP PROHIBITED CC</td>\n",
       "      <td>76</td>\n",
       "      <td>PPA</td>\n",
       "      <td>39.952977</td>\n",
       "      <td>-75.193443</td>\n",
       "      <td>POINT (-75.19344 39.95298)</td>\n",
       "      <td>125</td>\n",
       "      <td>UNIVERSITY_CITY</td>\n",
       "      <td>University City</td>\n",
       "      <td>University City</td>\n",
       "      <td>26985.308865</td>\n",
       "      <td>3.299364e+07</td>\n",
       "      <td>56759.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24848</th>\n",
       "      <td>4694954</td>\n",
       "      <td>09/01/2015 15:15</td>\n",
       "      <td>92560</td>\n",
       "      <td>METER EXPIRED</td>\n",
       "      <td>26</td>\n",
       "      <td>PPA</td>\n",
       "      <td>39.958600</td>\n",
       "      <td>-75.226177</td>\n",
       "      <td>POINT (-75.22618 39.95860)</td>\n",
       "      <td>118</td>\n",
       "      <td>COBBS_CREEK</td>\n",
       "      <td>Cobbs Creek</td>\n",
       "      <td>Cobbs Creek</td>\n",
       "      <td>25355.994460</td>\n",
       "      <td>3.755230e+07</td>\n",
       "      <td>8194.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80554</th>\n",
       "      <td>4602636</td>\n",
       "      <td>23/01/2015 19:34</td>\n",
       "      <td>2761</td>\n",
       "      <td>BUS ONLY ZONE</td>\n",
       "      <td>51</td>\n",
       "      <td>PPA</td>\n",
       "      <td>39.942899</td>\n",
       "      <td>-75.170636</td>\n",
       "      <td>POINT (-75.17064 39.94290)</td>\n",
       "      <td>101</td>\n",
       "      <td>GRADUATE_HOSPITAL</td>\n",
       "      <td>Graduate Hospital</td>\n",
       "      <td>Graduate Hospital</td>\n",
       "      <td>18603.011746</td>\n",
       "      <td>1.412651e+07</td>\n",
       "      <td>18261.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101736</th>\n",
       "      <td>4621203</td>\n",
       "      <td>30/01/2015 15:03</td>\n",
       "      <td>1083614</td>\n",
       "      <td>METER EXPIRED CC</td>\n",
       "      <td>36</td>\n",
       "      <td>PPA</td>\n",
       "      <td>39.956780</td>\n",
       "      <td>-75.192789</td>\n",
       "      <td>POINT (-75.19279 39.95678)</td>\n",
       "      <td>125</td>\n",
       "      <td>UNIVERSITY_CITY</td>\n",
       "      <td>University City</td>\n",
       "      <td>University City</td>\n",
       "      <td>26985.308865</td>\n",
       "      <td>3.299364e+07</td>\n",
       "      <td>56759.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77346</th>\n",
       "      <td>4796247</td>\n",
       "      <td>23/01/2015 11:00</td>\n",
       "      <td>513860</td>\n",
       "      <td>STOP PROHIBITED CC</td>\n",
       "      <td>76</td>\n",
       "      <td>PPA</td>\n",
       "      <td>39.951768</td>\n",
       "      <td>-75.161515</td>\n",
       "      <td>POINT (-75.16151 39.95177)</td>\n",
       "      <td>94</td>\n",
       "      <td>WASHINGTON_SQUARE</td>\n",
       "      <td>Washington Square West</td>\n",
       "      <td>Washington Square West</td>\n",
       "      <td>12119.268253</td>\n",
       "      <td>9.148299e+06</td>\n",
       "      <td>63167.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69670</th>\n",
       "      <td>4571912</td>\n",
       "      <td>21/01/2015 13:50</td>\n",
       "      <td>320487</td>\n",
       "      <td>OVER TIME LIMIT</td>\n",
       "      <td>26</td>\n",
       "      <td>PPA</td>\n",
       "      <td>39.937101</td>\n",
       "      <td>-75.147559</td>\n",
       "      <td>POINT (-75.14756 39.93710)</td>\n",
       "      <td>105</td>\n",
       "      <td>QUEEN_VILLAGE</td>\n",
       "      <td>Queen Village</td>\n",
       "      <td>Queen Village</td>\n",
       "      <td>10414.195744</td>\n",
       "      <td>6.631988e+06</td>\n",
       "      <td>18243.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52860</th>\n",
       "      <td>4711883</td>\n",
       "      <td>16/01/2015 19:42</td>\n",
       "      <td>23709</td>\n",
       "      <td>OVER TIME LIMIT</td>\n",
       "      <td>26</td>\n",
       "      <td>PPA</td>\n",
       "      <td>39.936377</td>\n",
       "      <td>-75.174476</td>\n",
       "      <td>POINT (-75.17448 39.93638)</td>\n",
       "      <td>102</td>\n",
       "      <td>POINT_BREEZE</td>\n",
       "      <td>Point Breeze</td>\n",
       "      <td>Point Breeze</td>\n",
       "      <td>17529.283714</td>\n",
       "      <td>1.693772e+07</td>\n",
       "      <td>9796.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15494</th>\n",
       "      <td>4728034</td>\n",
       "      <td>07/01/2015 10:10</td>\n",
       "      <td>18636</td>\n",
       "      <td>IMPROPER ON 2WAY HWY</td>\n",
       "      <td>31</td>\n",
       "      <td>PPA</td>\n",
       "      <td>39.949433</td>\n",
       "      <td>-75.143035</td>\n",
       "      <td>POINT (-75.14304 39.94943)</td>\n",
       "      <td>91</td>\n",
       "      <td>OLD_CITY</td>\n",
       "      <td>Old City</td>\n",
       "      <td>Old City</td>\n",
       "      <td>14323.371697</td>\n",
       "      <td>1.255444e+07</td>\n",
       "      <td>49234.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        anon_ticket_number    issue_datetime  anon_plate_id  \\\n",
       "55161              4770060  17/01/2015 12:14         892358   \n",
       "11265              4683890  05/01/2015 18:20        1548896   \n",
       "89746              4674519  27/01/2015 17:44         468950   \n",
       "24848              4694954  09/01/2015 15:15          92560   \n",
       "80554              4602636  23/01/2015 19:34           2761   \n",
       "101736             4621203  30/01/2015 15:03        1083614   \n",
       "77346              4796247  23/01/2015 11:00         513860   \n",
       "69670              4571912  21/01/2015 13:50         320487   \n",
       "52860              4711883  16/01/2015 19:42          23709   \n",
       "15494              4728034  07/01/2015 10:10          18636   \n",
       "\n",
       "              violation_desc  fine issuing_agency        lat        lon  \\\n",
       "55161       METER EXPIRED CC    36            PPA  39.955252 -75.202351   \n",
       "11265       CORNER CLEARANCE    51         POLICE  39.996076 -75.171048   \n",
       "89746     STOP PROHIBITED CC    76            PPA  39.952977 -75.193443   \n",
       "24848          METER EXPIRED    26            PPA  39.958600 -75.226177   \n",
       "80554          BUS ONLY ZONE    51            PPA  39.942899 -75.170636   \n",
       "101736      METER EXPIRED CC    36            PPA  39.956780 -75.192789   \n",
       "77346     STOP PROHIBITED CC    76            PPA  39.951768 -75.161515   \n",
       "69670        OVER TIME LIMIT    26            PPA  39.937101 -75.147559   \n",
       "52860        OVER TIME LIMIT    26            PPA  39.936377 -75.174476   \n",
       "15494   IMPROPER ON 2WAY HWY    31            PPA  39.949433 -75.143035   \n",
       "\n",
       "                          geometry  index_right                NAME  \\\n",
       "55161   POINT (-75.20235 39.95525)          125     UNIVERSITY_CITY   \n",
       "11265   POINT (-75.17105 39.99608)          142  STRAWBERRY_MANSION   \n",
       "89746   POINT (-75.19344 39.95298)          125     UNIVERSITY_CITY   \n",
       "24848   POINT (-75.22618 39.95860)          118         COBBS_CREEK   \n",
       "80554   POINT (-75.17064 39.94290)          101   GRADUATE_HOSPITAL   \n",
       "101736  POINT (-75.19279 39.95678)          125     UNIVERSITY_CITY   \n",
       "77346   POINT (-75.16151 39.95177)           94   WASHINGTON_SQUARE   \n",
       "69670   POINT (-75.14756 39.93710)          105       QUEEN_VILLAGE   \n",
       "52860   POINT (-75.17448 39.93638)          102        POINT_BREEZE   \n",
       "15494   POINT (-75.14304 39.94943)           91            OLD_CITY   \n",
       "\n",
       "                      LISTNAME                 MAPNAME    Shape_Leng  \\\n",
       "55161          University City         University City  26985.308865   \n",
       "11265       Strawberry Mansion      Strawberry Mansion  28308.168132   \n",
       "89746          University City         University City  26985.308865   \n",
       "24848              Cobbs Creek             Cobbs Creek  25355.994460   \n",
       "80554        Graduate Hospital       Graduate Hospital  18603.011746   \n",
       "101736         University City         University City  26985.308865   \n",
       "77346   Washington Square West  Washington Square West  12119.268253   \n",
       "69670            Queen Village           Queen Village  10414.195744   \n",
       "52860             Point Breeze            Point Breeze  17529.283714   \n",
       "15494                 Old City                Old City  14323.371697   \n",
       "\n",
       "          Shape_Area  NUMPOINTS  \n",
       "55161   3.299364e+07    56759.0  \n",
       "11265   2.575296e+07      769.0  \n",
       "89746   3.299364e+07    56759.0  \n",
       "24848   3.755230e+07     8194.0  \n",
       "80554   1.412651e+07    18261.0  \n",
       "101736  3.299364e+07    56759.0  \n",
       "77346   9.148299e+06    63167.0  \n",
       "69670   6.631988e+06    18243.0  \n",
       "52860   1.693772e+07     9796.0  \n",
       "15494   1.255444e+07    49234.0  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "location_join.sample(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "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>NAME</th>\n",
       "      <th>LISTNAME</th>\n",
       "      <th>MAPNAME</th>\n",
       "      <th>Shape_Leng</th>\n",
       "      <th>Shape_Area</th>\n",
       "      <th>NUMPOINTS</th>\n",
       "      <th>geometry</th>\n",
       "      <th>Count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BRIDESBURG</td>\n",
       "      <td>Bridesburg</td>\n",
       "      <td>Bridesburg</td>\n",
       "      <td>27814.546521</td>\n",
       "      <td>4.458626e+07</td>\n",
       "      <td>149.0</td>\n",
       "      <td>MULTIPOLYGON (((-75.06773 40.00540, -75.06765 ...</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BUSTLETON</td>\n",
       "      <td>Bustleton</td>\n",
       "      <td>Bustleton</td>\n",
       "      <td>48868.458365</td>\n",
       "      <td>1.140504e+08</td>\n",
       "      <td>228.0</td>\n",
       "      <td>MULTIPOLYGON (((-75.01560 40.09487, -75.01768 ...</td>\n",
       "      <td>59.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CEDARBROOK</td>\n",
       "      <td>Cedarbrook</td>\n",
       "      <td>Cedarbrook</td>\n",
       "      <td>20021.415802</td>\n",
       "      <td>2.487174e+07</td>\n",
       "      <td>129.0</td>\n",
       "      <td>MULTIPOLYGON (((-75.18848 40.07273, -75.18846 ...</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CHESTNUT_HILL</td>\n",
       "      <td>Chestnut Hill</td>\n",
       "      <td>Chestnut Hill</td>\n",
       "      <td>56394.297195</td>\n",
       "      <td>7.966498e+07</td>\n",
       "      <td>7783.0</td>\n",
       "      <td>MULTIPOLYGON (((-75.21221 40.08603, -75.21211 ...</td>\n",
       "      <td>716.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>EAST_FALLS</td>\n",
       "      <td>East Falls</td>\n",
       "      <td>East Falls</td>\n",
       "      <td>27400.776417</td>\n",
       "      <td>4.057689e+07</td>\n",
       "      <td>3715.0</td>\n",
       "      <td>MULTIPOLYGON (((-75.18479 40.02837, -75.18426 ...</td>\n",
       "      <td>547.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            NAME       LISTNAME        MAPNAME    Shape_Leng    Shape_Area  \\\n",
       "0     BRIDESBURG     Bridesburg     Bridesburg  27814.546521  4.458626e+07   \n",
       "1      BUSTLETON      Bustleton      Bustleton  48868.458365  1.140504e+08   \n",
       "2     CEDARBROOK     Cedarbrook     Cedarbrook  20021.415802  2.487174e+07   \n",
       "3  CHESTNUT_HILL  Chestnut Hill  Chestnut Hill  56394.297195  7.966498e+07   \n",
       "4     EAST_FALLS     East Falls     East Falls  27400.776417  4.057689e+07   \n",
       "\n",
       "   NUMPOINTS                                           geometry  Count  \n",
       "0      149.0  MULTIPOLYGON (((-75.06773 40.00540, -75.06765 ...   22.0  \n",
       "1      228.0  MULTIPOLYGON (((-75.01560 40.09487, -75.01768 ...   59.0  \n",
       "2      129.0  MULTIPOLYGON (((-75.18848 40.07273, -75.18846 ...   10.0  \n",
       "3     7783.0  MULTIPOLYGON (((-75.21221 40.08603, -75.21211 ...  716.0  \n",
       "4     3715.0  MULTIPOLYGON (((-75.18479 40.02837, -75.18426 ...  547.0  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def count_numpoints(joined, polygons, merge_on):\n",
    "    grouped = joined.groupby(merge_on).size()\n",
    "    df = grouped.to_frame().reset_index()\n",
    "    df.columns = [merge_on,\"Count\"]\n",
    "    return polygons.merge(df, on=merge_on,how=\"outer\")\n",
    "\n",
    "numpoints_per_neigh = count_numpoints(location_join, neighbourhoods, \"NAME\")\n",
    "numpoints_per_neigh.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "User Guide: https://docs.kepler.gl/docs/keplergl-jupyter\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Python39\\lib\\site-packages\\jupyter_client\\session.py:718: UserWarning: Message serialization failed with:\n",
      "Out of range float values are not JSON compliant\n",
      "Supporting this message is deprecated in jupyter-client 7, please make sure your message is JSON-compliant\n",
      "  content = self.pack(content)\n"
     ]
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "ce1972c8eb5541c995af551f46ab07dc",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "KeplerGl(data={'chloropeth_map': {'index': [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, …"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "mp = KeplerGl(height=900)\n",
    "mp.add_data(data=numpoints_per_neigh, name=\"chloropeth_map\")\n",
    "mp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.9"
  },
  "vscode": {
   "interpreter": {
    "hash": "81794d4967e6c3204c66dcd87b604927b115b27c00565d3d43f05ba2f3a2cb0d"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}