{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Geocode London Stations\n",
    "\n",
    "Source: https://data.london.gov.uk/dataset/london-underground-performance-reports"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas\n",
    "from cartoframes.auth import set_default_credentials\n",
    "from cartoframes.data import Dataset\n",
    "from cartoframes.data.services import Geocoding\n",
    "\n",
    "set_default_credentials('you_username', 'your_credentials')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# ! pip install xlrd"
   ]
  },
  {
   "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>nlc</th>\n",
       "      <th>Station</th>\n",
       "      <th>Borough</th>\n",
       "      <th>Note</th>\n",
       "      <th>Weekday</th>\n",
       "      <th>Saturday</th>\n",
       "      <th>Sunday</th>\n",
       "      <th>Weekday.1</th>\n",
       "      <th>Saturday.1</th>\n",
       "      <th>Sunday.1</th>\n",
       "      <th>million</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>Acton Town</td>\n",
       "      <td>Ealing</td>\n",
       "      <td></td>\n",
       "      <td>9531.0</td>\n",
       "      <td>6716.0</td>\n",
       "      <td>4744.0</td>\n",
       "      <td>9382.0</td>\n",
       "      <td>6617.0</td>\n",
       "      <td>4785.0</td>\n",
       "      <td>6.040516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>502.0</td>\n",
       "      <td>Aldgate</td>\n",
       "      <td>City of London</td>\n",
       "      <td></td>\n",
       "      <td>15080.0</td>\n",
       "      <td>4397.0</td>\n",
       "      <td>3261.0</td>\n",
       "      <td>16023.0</td>\n",
       "      <td>5909.0</td>\n",
       "      <td>4230.0</td>\n",
       "      <td>8.846940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>503.0</td>\n",
       "      <td>Aldgate East</td>\n",
       "      <td>Tower Hamlets</td>\n",
       "      <td></td>\n",
       "      <td>22327.0</td>\n",
       "      <td>16166.0</td>\n",
       "      <td>13323.0</td>\n",
       "      <td>21071.0</td>\n",
       "      <td>13893.0</td>\n",
       "      <td>11347.0</td>\n",
       "      <td>13.998292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>505.0</td>\n",
       "      <td>Alperton</td>\n",
       "      <td>Brent</td>\n",
       "      <td></td>\n",
       "      <td>4495.0</td>\n",
       "      <td>3279.0</td>\n",
       "      <td>2345.0</td>\n",
       "      <td>5081.0</td>\n",
       "      <td>3392.0</td>\n",
       "      <td>2445.0</td>\n",
       "      <td>3.052230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>506.0</td>\n",
       "      <td>Amersham</td>\n",
       "      <td>Chiltern</td>\n",
       "      <td></td>\n",
       "      <td>3848.0</td>\n",
       "      <td>1876.0</td>\n",
       "      <td>1232.0</td>\n",
       "      <td>4025.0</td>\n",
       "      <td>1797.0</td>\n",
       "      <td>1121.0</td>\n",
       "      <td>2.321692</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     nlc       Station         Borough Note  Weekday  Saturday   Sunday  \\\n",
       "0  500.0    Acton Town          Ealing        9531.0    6716.0   4744.0   \n",
       "1  502.0       Aldgate  City of London       15080.0    4397.0   3261.0   \n",
       "2  503.0  Aldgate East   Tower Hamlets       22327.0   16166.0  13323.0   \n",
       "3  505.0      Alperton           Brent        4495.0    3279.0   2345.0   \n",
       "4  506.0      Amersham        Chiltern        3848.0    1876.0   1232.0   \n",
       "\n",
       "   Weekday.1  Saturday.1  Sunday.1    million  \n",
       "0     9382.0      6617.0    4785.0   6.040516  \n",
       "1    16023.0      5909.0    4230.0   8.846940  \n",
       "2    21071.0     13893.0   11347.0  13.998292  \n",
       "3     5081.0      3392.0    2445.0   3.052230  \n",
       "4     4025.0      1797.0    1121.0   2.321692  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "local_file_path = '../files/london_stations.xls'\n",
    "df = pandas.read_excel(local_file_path, header=6, sheet_name=1)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>nlc</th>\n",
       "      <th>Station</th>\n",
       "      <th>Borough</th>\n",
       "      <th>Note</th>\n",
       "      <th>weekday_entry</th>\n",
       "      <th>saturday_entry</th>\n",
       "      <th>sunday_entry</th>\n",
       "      <th>weekday_exit</th>\n",
       "      <th>saturday_exit</th>\n",
       "      <th>sunday_exit</th>\n",
       "      <th>million</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>Acton Town</td>\n",
       "      <td>Ealing</td>\n",
       "      <td></td>\n",
       "      <td>9531.0</td>\n",
       "      <td>6716.0</td>\n",
       "      <td>4744.0</td>\n",
       "      <td>9382.0</td>\n",
       "      <td>6617.0</td>\n",
       "      <td>4785.0</td>\n",
       "      <td>6.040516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>502.0</td>\n",
       "      <td>Aldgate</td>\n",
       "      <td>City of London</td>\n",
       "      <td></td>\n",
       "      <td>15080.0</td>\n",
       "      <td>4397.0</td>\n",
       "      <td>3261.0</td>\n",
       "      <td>16023.0</td>\n",
       "      <td>5909.0</td>\n",
       "      <td>4230.0</td>\n",
       "      <td>8.846940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>503.0</td>\n",
       "      <td>Aldgate East</td>\n",
       "      <td>Tower Hamlets</td>\n",
       "      <td></td>\n",
       "      <td>22327.0</td>\n",
       "      <td>16166.0</td>\n",
       "      <td>13323.0</td>\n",
       "      <td>21071.0</td>\n",
       "      <td>13893.0</td>\n",
       "      <td>11347.0</td>\n",
       "      <td>13.998292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>505.0</td>\n",
       "      <td>Alperton</td>\n",
       "      <td>Brent</td>\n",
       "      <td></td>\n",
       "      <td>4495.0</td>\n",
       "      <td>3279.0</td>\n",
       "      <td>2345.0</td>\n",
       "      <td>5081.0</td>\n",
       "      <td>3392.0</td>\n",
       "      <td>2445.0</td>\n",
       "      <td>3.052230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>506.0</td>\n",
       "      <td>Amersham</td>\n",
       "      <td>Chiltern</td>\n",
       "      <td></td>\n",
       "      <td>3848.0</td>\n",
       "      <td>1876.0</td>\n",
       "      <td>1232.0</td>\n",
       "      <td>4025.0</td>\n",
       "      <td>1797.0</td>\n",
       "      <td>1121.0</td>\n",
       "      <td>2.321692</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     nlc       Station         Borough Note  weekday_entry  saturday_entry  \\\n",
       "0  500.0    Acton Town          Ealing              9531.0          6716.0   \n",
       "1  502.0       Aldgate  City of London             15080.0          4397.0   \n",
       "2  503.0  Aldgate East   Tower Hamlets             22327.0         16166.0   \n",
       "3  505.0      Alperton           Brent              4495.0          3279.0   \n",
       "4  506.0      Amersham        Chiltern              3848.0          1876.0   \n",
       "\n",
       "   sunday_entry  weekday_exit  saturday_exit  sunday_exit    million  \n",
       "0        4744.0        9382.0         6617.0       4785.0   6.040516  \n",
       "1        3261.0       16023.0         5909.0       4230.0   8.846940  \n",
       "2       13323.0       21071.0        13893.0      11347.0  13.998292  \n",
       "3        2345.0        5081.0         3392.0       2445.0   3.052230  \n",
       "4        1232.0        4025.0         1797.0       1121.0   2.321692  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df.rename(columns={\n",
    "    \"Saturday.1\": \"saturday_exit\",\n",
    "    \"Sunday.1\": \"sunday_exit\",\n",
    "    \"Weekday.1\": \"weekday_exit\",\n",
    "    \"Saturday\": \"saturday_entry\",\n",
    "    \"Sunday\": \"sunday_entry\",\n",
    "    \"Weekday\": \"weekday_entry\"\n",
    "})\n",
    "\n",
    "df.head()"
   ]
  },
  {
   "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>nlc</th>\n",
       "      <th>station</th>\n",
       "      <th>borough</th>\n",
       "      <th>note</th>\n",
       "      <th>weekday_entry</th>\n",
       "      <th>saturday_entry</th>\n",
       "      <th>sunday_entry</th>\n",
       "      <th>weekday_exit</th>\n",
       "      <th>saturday_exit</th>\n",
       "      <th>sunday_exit</th>\n",
       "      <th>million</th>\n",
       "      <th>gc_status_rel</th>\n",
       "      <th>carto_geocode_hash</th>\n",
       "      <th>the_geom</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cartodb_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>Acton Town</td>\n",
       "      <td>Ealing</td>\n",
       "      <td></td>\n",
       "      <td>9531.0</td>\n",
       "      <td>6716.0</td>\n",
       "      <td>4744.0</td>\n",
       "      <td>9382.0</td>\n",
       "      <td>6617.0</td>\n",
       "      <td>4785.0</td>\n",
       "      <td>6.040516</td>\n",
       "      <td>0.55</td>\n",
       "      <td>985f9d318280297b6108bc30e92d92e1</td>\n",
       "      <td>0101000020E61000002A6F47382D78D3BF68B3EA73B5C1...</td>\n",
       "      <td>POINT (-0.30421 51.51335)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>502.0</td>\n",
       "      <td>Aldgate</td>\n",
       "      <td>City of London</td>\n",
       "      <td></td>\n",
       "      <td>15080.0</td>\n",
       "      <td>4397.0</td>\n",
       "      <td>3261.0</td>\n",
       "      <td>16023.0</td>\n",
       "      <td>5909.0</td>\n",
       "      <td>4230.0</td>\n",
       "      <td>8.846940</td>\n",
       "      <td>0.88</td>\n",
       "      <td>7abfcd5c0283e877a275f0d059836a09</td>\n",
       "      <td>0101000020E6100000DAACFA5C6DC5B6BF210725CCB4C1...</td>\n",
       "      <td>POINT (-0.08895 51.51333)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>503.0</td>\n",
       "      <td>Aldgate East</td>\n",
       "      <td>Tower Hamlets</td>\n",
       "      <td></td>\n",
       "      <td>22327.0</td>\n",
       "      <td>16166.0</td>\n",
       "      <td>13323.0</td>\n",
       "      <td>21071.0</td>\n",
       "      <td>13893.0</td>\n",
       "      <td>11347.0</td>\n",
       "      <td>13.998292</td>\n",
       "      <td>0.74</td>\n",
       "      <td>c1ba0efb09cc8e5caf79092547a7a3e7</td>\n",
       "      <td>0101000020E610000005FA449E245D93BF8FC2F5285CCB...</td>\n",
       "      <td>POINT (-0.01891 51.58875)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>505.0</td>\n",
       "      <td>Alperton</td>\n",
       "      <td>Brent</td>\n",
       "      <td></td>\n",
       "      <td>4495.0</td>\n",
       "      <td>3279.0</td>\n",
       "      <td>2345.0</td>\n",
       "      <td>5081.0</td>\n",
       "      <td>3392.0</td>\n",
       "      <td>2445.0</td>\n",
       "      <td>3.052230</td>\n",
       "      <td>0.55</td>\n",
       "      <td>c9f07eb29a060527ca81a613cca80007</td>\n",
       "      <td>0101000020E6100000AE64C746205ED3BFA69BC420B0C6...</td>\n",
       "      <td>POINT (-0.30262 51.55225)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>506.0</td>\n",
       "      <td>Amersham</td>\n",
       "      <td>Chiltern</td>\n",
       "      <td></td>\n",
       "      <td>3848.0</td>\n",
       "      <td>1876.0</td>\n",
       "      <td>1232.0</td>\n",
       "      <td>4025.0</td>\n",
       "      <td>1797.0</td>\n",
       "      <td>1121.0</td>\n",
       "      <td>2.321692</td>\n",
       "      <td>0.53</td>\n",
       "      <td>518e37ccd63a56df5d5758fb8e52a5dd</td>\n",
       "      <td>0101000020E6100000C095ECD808C4ABBF87FE092E56C8...</td>\n",
       "      <td>POINT (-0.05423 51.56513)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              nlc       station         borough note  weekday_entry  \\\n",
       "cartodb_id                                                            \n",
       "0           500.0    Acton Town          Ealing              9531.0   \n",
       "1           502.0       Aldgate  City of London             15080.0   \n",
       "2           503.0  Aldgate East   Tower Hamlets             22327.0   \n",
       "3           505.0      Alperton           Brent              4495.0   \n",
       "4           506.0      Amersham        Chiltern              3848.0   \n",
       "\n",
       "            saturday_entry  sunday_entry  weekday_exit  saturday_exit  \\\n",
       "cartodb_id                                                              \n",
       "0                   6716.0        4744.0        9382.0         6617.0   \n",
       "1                   4397.0        3261.0       16023.0         5909.0   \n",
       "2                  16166.0       13323.0       21071.0        13893.0   \n",
       "3                   3279.0        2345.0        5081.0         3392.0   \n",
       "4                   1876.0        1232.0        4025.0         1797.0   \n",
       "\n",
       "            sunday_exit    million  gc_status_rel  \\\n",
       "cartodb_id                                          \n",
       "0                4785.0   6.040516           0.55   \n",
       "1                4230.0   8.846940           0.88   \n",
       "2               11347.0  13.998292           0.74   \n",
       "3                2445.0   3.052230           0.55   \n",
       "4                1121.0   2.321692           0.53   \n",
       "\n",
       "                          carto_geocode_hash  \\\n",
       "cartodb_id                                     \n",
       "0           985f9d318280297b6108bc30e92d92e1   \n",
       "1           7abfcd5c0283e877a275f0d059836a09   \n",
       "2           c1ba0efb09cc8e5caf79092547a7a3e7   \n",
       "3           c9f07eb29a060527ca81a613cca80007   \n",
       "4           518e37ccd63a56df5d5758fb8e52a5dd   \n",
       "\n",
       "                                                     the_geom  \\\n",
       "cartodb_id                                                      \n",
       "0           0101000020E61000002A6F47382D78D3BF68B3EA73B5C1...   \n",
       "1           0101000020E6100000DAACFA5C6DC5B6BF210725CCB4C1...   \n",
       "2           0101000020E610000005FA449E245D93BF8FC2F5285CCB...   \n",
       "3           0101000020E6100000AE64C746205ED3BFA69BC420B0C6...   \n",
       "4           0101000020E6100000C095ECD808C4ABBF87FE092E56C8...   \n",
       "\n",
       "                             geometry  \n",
       "cartodb_id                             \n",
       "0           POINT (-0.30421 51.51335)  \n",
       "1           POINT (-0.08895 51.51333)  \n",
       "2           POINT (-0.01891 51.58875)  \n",
       "3           POINT (-0.30262 51.55225)  \n",
       "4           POINT (-0.05423 51.56513)  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gc = Geocoding()\n",
    "\n",
    "london_df, london_df_metadata = gc.geocode(\n",
    "    df,\n",
    "    street='Borough',\n",
    "    city={'value': 'London'},\n",
    "    country={'value': 'United Kingdom'},\n",
    "    table_name='london_stations',\n",
    "    if_exists=Dataset.IF_EXISTS_REPLACE\n",
    ")\n",
    "\n",
    "london_df.head()"
   ]
  },
  {
   "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>nlc</th>\n",
       "      <th>station</th>\n",
       "      <th>borough</th>\n",
       "      <th>note</th>\n",
       "      <th>weekday_entry</th>\n",
       "      <th>saturday_entry</th>\n",
       "      <th>sunday_entry</th>\n",
       "      <th>weekday_exit</th>\n",
       "      <th>saturday_exit</th>\n",
       "      <th>sunday_exit</th>\n",
       "      <th>million</th>\n",
       "      <th>gc_status_rel</th>\n",
       "      <th>carto_geocode_hash</th>\n",
       "      <th>the_geom</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cartodb_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>Acton Town</td>\n",
       "      <td>Ealing</td>\n",
       "      <td></td>\n",
       "      <td>9531.0</td>\n",
       "      <td>6716.0</td>\n",
       "      <td>4744.0</td>\n",
       "      <td>9382.0</td>\n",
       "      <td>6617.0</td>\n",
       "      <td>4785.0</td>\n",
       "      <td>6.040516</td>\n",
       "      <td>0.55</td>\n",
       "      <td>985f9d318280297b6108bc30e92d92e1</td>\n",
       "      <td>0101000020E61000002A6F47382D78D3BF68B3EA73B5C1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>502.0</td>\n",
       "      <td>Aldgate</td>\n",
       "      <td>City of London</td>\n",
       "      <td></td>\n",
       "      <td>15080.0</td>\n",
       "      <td>4397.0</td>\n",
       "      <td>3261.0</td>\n",
       "      <td>16023.0</td>\n",
       "      <td>5909.0</td>\n",
       "      <td>4230.0</td>\n",
       "      <td>8.846940</td>\n",
       "      <td>0.88</td>\n",
       "      <td>7abfcd5c0283e877a275f0d059836a09</td>\n",
       "      <td>0101000020E6100000DAACFA5C6DC5B6BF210725CCB4C1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>503.0</td>\n",
       "      <td>Aldgate East</td>\n",
       "      <td>Tower Hamlets</td>\n",
       "      <td></td>\n",
       "      <td>22327.0</td>\n",
       "      <td>16166.0</td>\n",
       "      <td>13323.0</td>\n",
       "      <td>21071.0</td>\n",
       "      <td>13893.0</td>\n",
       "      <td>11347.0</td>\n",
       "      <td>13.998292</td>\n",
       "      <td>0.74</td>\n",
       "      <td>c1ba0efb09cc8e5caf79092547a7a3e7</td>\n",
       "      <td>0101000020E610000005FA449E245D93BF8FC2F5285CCB...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>505.0</td>\n",
       "      <td>Alperton</td>\n",
       "      <td>Brent</td>\n",
       "      <td></td>\n",
       "      <td>4495.0</td>\n",
       "      <td>3279.0</td>\n",
       "      <td>2345.0</td>\n",
       "      <td>5081.0</td>\n",
       "      <td>3392.0</td>\n",
       "      <td>2445.0</td>\n",
       "      <td>3.052230</td>\n",
       "      <td>0.55</td>\n",
       "      <td>c9f07eb29a060527ca81a613cca80007</td>\n",
       "      <td>0101000020E6100000AE64C746205ED3BFA69BC420B0C6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>506.0</td>\n",
       "      <td>Amersham</td>\n",
       "      <td>Chiltern</td>\n",
       "      <td></td>\n",
       "      <td>3848.0</td>\n",
       "      <td>1876.0</td>\n",
       "      <td>1232.0</td>\n",
       "      <td>4025.0</td>\n",
       "      <td>1797.0</td>\n",
       "      <td>1121.0</td>\n",
       "      <td>2.321692</td>\n",
       "      <td>0.53</td>\n",
       "      <td>518e37ccd63a56df5d5758fb8e52a5dd</td>\n",
       "      <td>0101000020E6100000C095ECD808C4ABBF87FE092E56C8...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              nlc       station         borough note  weekday_entry  \\\n",
       "cartodb_id                                                            \n",
       "0           500.0    Acton Town          Ealing              9531.0   \n",
       "1           502.0       Aldgate  City of London             15080.0   \n",
       "2           503.0  Aldgate East   Tower Hamlets             22327.0   \n",
       "3           505.0      Alperton           Brent              4495.0   \n",
       "4           506.0      Amersham        Chiltern              3848.0   \n",
       "\n",
       "            saturday_entry  sunday_entry  weekday_exit  saturday_exit  \\\n",
       "cartodb_id                                                              \n",
       "0                   6716.0        4744.0        9382.0         6617.0   \n",
       "1                   4397.0        3261.0       16023.0         5909.0   \n",
       "2                  16166.0       13323.0       21071.0        13893.0   \n",
       "3                   3279.0        2345.0        5081.0         3392.0   \n",
       "4                   1876.0        1232.0        4025.0         1797.0   \n",
       "\n",
       "            sunday_exit    million  gc_status_rel  \\\n",
       "cartodb_id                                          \n",
       "0                4785.0   6.040516           0.55   \n",
       "1                4230.0   8.846940           0.88   \n",
       "2               11347.0  13.998292           0.74   \n",
       "3                2445.0   3.052230           0.55   \n",
       "4                1121.0   2.321692           0.53   \n",
       "\n",
       "                          carto_geocode_hash  \\\n",
       "cartodb_id                                     \n",
       "0           985f9d318280297b6108bc30e92d92e1   \n",
       "1           7abfcd5c0283e877a275f0d059836a09   \n",
       "2           c1ba0efb09cc8e5caf79092547a7a3e7   \n",
       "3           c9f07eb29a060527ca81a613cca80007   \n",
       "4           518e37ccd63a56df5d5758fb8e52a5dd   \n",
       "\n",
       "                                                     the_geom  \n",
       "cartodb_id                                                     \n",
       "0           0101000020E61000002A6F47382D78D3BF68B3EA73B5C1...  \n",
       "1           0101000020E6100000DAACFA5C6DC5B6BF210725CCB4C1...  \n",
       "2           0101000020E610000005FA449E245D93BF8FC2F5285CCB...  \n",
       "3           0101000020E6100000AE64C746205ED3BFA69BC420B0C6...  \n",
       "4           0101000020E6100000C095ECD808C4ABBF87FE092E56C8...  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "london_stations_df = Dataset('london_stations').download()\n",
    "london_stations_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<iframe\n",
       "  frameborder=\"0\"\n",
       "  style=\"\n",
       "    border: 1px solid #cfcfcf;\n",
       "    width: 100%;\n",
       "    height: 632px;\n",
       "    \"\n",
       "  srcDoc=\"\n",
       "  <!DOCTYPE html>\n",
       "<html lang=&quot;en&quot;>\n",
       "<head>\n",
       "  <title>None</title>\n",
       "  <meta name=&quot;description&quot; content=&quot;None&quot;>\n",
       "  <meta name=&quot;viewport&quot; content=&quot;width=device-width, initial-scale=1.0&quot;>\n",
       "  <meta charset=&quot;UTF-8&quot;>\n",
       "  <!-- Include CARTO VL JS -->\n",
       "  <script src=&quot;https://libs.cartocdn.com/carto-vl/v1.4/carto-vl.min.js&quot;></script>\n",
       "  <!-- Include Mapbox GL JS -->\n",
       "  <script src=&quot;https://api.tiles.mapbox.com/mapbox-gl-js/v1.0.0/mapbox-gl.js&quot;></script>\n",
       "  <!-- Include Mapbox GL CSS -->\n",
       "  <link href=&quot;https://api.tiles.mapbox.com/mapbox-gl-js/v1.0.0/mapbox-gl.css&quot; rel=&quot;stylesheet&quot; />\n",
       "\n",
       "  <!-- Include Airship -->\n",
       "  <script nomodule=&quot;&quot; src=&quot;https://libs.cartocdn.com/airship-components/v2.2.0-rc.2.1/airship.js&quot;></script>\n",
       "  <script type=&quot;module&quot; src=&quot;https://libs.cartocdn.com/airship-components/v2.2.0-rc.2.1/airship/airship.esm.js&quot;></script>\n",
       "  <script src=&quot;https://libs.cartocdn.com/airship-bridge/v2.2.0-rc.2.1/asbridge.min.js&quot;></script>\n",
       "  <link href=&quot;https://libs.cartocdn.com/airship-style/v2.2.0-rc.2.1/airship.min.css&quot; rel=&quot;stylesheet&quot;>\n",
       "  <link href=&quot;https://libs.cartocdn.com/airship-icons/v2.2.0-rc.2.1/icons.css&quot; rel=&quot;stylesheet&quot;>\n",
       "\n",
       "  <link href=&quot;https://fonts.googleapis.com/css?family=Roboto&quot; rel=&quot;stylesheet&quot; type=&quot;text/css&quot;>\n",
       "\n",
       "  <!-- External libraries -->\n",
       "  \n",
       "  <!-- base64-js -->\n",
       "  <script src='https://libs.cartocdn.com/cartoframes/dependencies/base64.js'></script>\n",
       "  \n",
       "  <!-- html2canvas -->\n",
       "  \n",
       "\n",
       "  \n",
       "  <style>\n",
       "  body {\n",
       "    margin: 0;\n",
       "    padding: 0;\n",
       "  }\n",
       "\n",
       "  aside.as-sidebar {\n",
       "    min-width: 300px;\n",
       "  }\n",
       "\n",
       "  .map-image {\n",
       "    display: none;\n",
       "    max-width: 100%;\n",
       "    height: auto;\n",
       "  }\n",
       "</style>\n",
       "  <style>\n",
       "  .map {\n",
       "    position: absolute;\n",
       "    height: 100%;\n",
       "    width: 100%;\n",
       "  }\n",
       "\n",
       "  .map-info {\n",
       "    position: absolute;\n",
       "    bottom: 0;\n",
       "    padding: 0 5px;\n",
       "    background-color: rgba(255, 255, 255, 0.5);\n",
       "    margin: 0;\n",
       "    color: rgba(0, 0, 0, 0.75);\n",
       "    font-size: 12px;\n",
       "    width: auto;\n",
       "    height: 18px;\n",
       "    font-family: 'Open Sans';\n",
       "  }\n",
       "\n",
       "  .map-footer {\n",
       "    background: #F2F6F9;\n",
       "    font-family: Roboto;\n",
       "    font-size: 12px;\n",
       "    line-height: 24px;\n",
       "    color: #162945;\n",
       "    text-align: center;\n",
       "    z-index: 2;\n",
       "  }\n",
       "\n",
       "  .map-footer a {\n",
       "    text-decoration: none;\n",
       "  }\n",
       "\n",
       "  .map-footer a:hover {\n",
       "    text-decoration: underline;\n",
       "  }\n",
       "</style>\n",
       "    <style>\n",
       "    #error-container {\n",
       "      position: absolute;\n",
       "      width: 100%;\n",
       "      height: 100%;\n",
       "      background-color: white;\n",
       "      visibility: hidden;\n",
       "      padding: 1em;\n",
       "      font-family: &quot;Courier New&quot;, Courier, monospace;\n",
       "      margin: 0 auto;\n",
       "      font-size: 14px;\n",
       "      overflow: auto;\n",
       "      z-index: 1000;\n",
       "      color: black;\n",
       "    }\n",
       "\n",
       "    .error-section {\n",
       "      padding: 1em;\n",
       "      border-radius: 5px;\n",
       "      background-color: #fee;\n",
       "    }\n",
       "\n",
       "    #error-container #error-highlight {\n",
       "      font-weight: bold;\n",
       "      color: inherit;\n",
       "    }\n",
       "\n",
       "    #error-container #error-type {\n",
       "      color: #008000;\n",
       "    }\n",
       "\n",
       "    #error-container #error-name {\n",
       "      color: #ba2121;\n",
       "    }\n",
       "\n",
       "    #error-container #error-content {\n",
       "      margin-top: 0.4em;\n",
       "    }\n",
       "\n",
       "    .error-details {\n",
       "      margin-top: 1em;\n",
       "    }\n",
       "\n",
       "    #error-stacktrace {\n",
       "      list-style: none;\n",
       "    }\n",
       "</style>\n",
       "  <style>\n",
       "    .popup-content {\n",
       "      display: flex;\n",
       "      flex-direction: column;\n",
       "      padding: 8px;\n",
       "    }\n",
       "\n",
       "    .popup-name {\n",
       "      font-size: 12px;\n",
       "      font-weight: 400;\n",
       "      line-height: 20px;\n",
       "      margin-bottom: 4px;\n",
       "    }\n",
       "\n",
       "    .popup-value {\n",
       "      font-size: 16px;\n",
       "      font-weight: 600;\n",
       "      line-height: 20px;\n",
       "    }\n",
       "\n",
       "    .popup-value:not(:last-of-type) {\n",
       "      margin-bottom: 16px;\n",
       "    }\n",
       "</style>\n",
       "  <style>\n",
       "  as-widget-header .as-widget-header__header {\n",
       "    margin-bottom: 8px;\n",
       "    overflow-wrap: break-word;\n",
       "  }\n",
       "\n",
       "  as-widget-header .as-widget-header__subheader {\n",
       "    margin-bottom: 12px;\n",
       "  }\n",
       "\n",
       "  as-category-widget {\n",
       "    max-height: 250px;\n",
       "  }\n",
       "</style>\n",
       "</head>\n",
       "\n",
       "<body class=&quot;as-app-body as-app&quot;>\n",
       "  <img id=&quot;map-image&quot; class=&quot;map-image&quot; alt='Static map image' />\n",
       "  <as-responsive-content id=&quot;main-container&quot;>\n",
       "    \n",
       "    <main class=&quot;as-main&quot;>\n",
       "      <div class=&quot;as-map-area&quot;>\n",
       "        <div id=&quot;map&quot; class=&quot;map&quot;></div>\n",
       "        \n",
       "        \n",
       "      </div> <!-- as-map-area -->\n",
       "    </main> <!-- as-main -->\n",
       "  </as-responsive-content>\n",
       "\n",
       "  \n",
       "\n",
       "  <div id=&quot;error-container&quot; class=&quot;error&quot;>\n",
       "  <p>There is a <span class=&quot;errors&quot; id=&quot;error-highlight&quot;></span>\n",
       "  from the <a href=&quot;https://carto.com/developers/carto-vl/&quot; target=&quot;_blank&quot;>CARTO VL</a> library:</p>\n",
       "  <section class=&quot;error-section&quot;>\n",
       "    <span class=&quot;errors&quot; id=&quot;error-name&quot;></span>:\n",
       "    <section id=&quot;error-content&quot;>\n",
       "      <span class=&quot;errors&quot; id=&quot;error-type&quot;></span>\n",
       "      <span class=&quot;errors&quot; id=&quot;error-message&quot;></span>\n",
       "    </section>\n",
       "  </section>\n",
       "\n",
       "  <details class=&quot;error-details&quot;>\n",
       "    <summary>StackTrace</summary>\n",
       "    <ul id=&quot;error-stacktrace&quot;></ul>\n",
       "  </details>\n",
       "</div>\n",
       "</body>\n",
       "\n",
       "<script>\n",
       "  var init = (function () {\n",
       "  'use strict';\n",
       "\n",
       "  const BASEMAPS = {\n",
       "    DarkMatter: carto.basemaps.darkmatter,\n",
       "    Voyager: carto.basemaps.voyager,\n",
       "    Positron: carto.basemaps.positron\n",
       "  };\n",
       "\n",
       "  const attributionControl = new mapboxgl.AttributionControl({\n",
       "    compact: false\n",
       "  });\n",
       "\n",
       "  const FIT_BOUNDS_SETTINGS = { animate: false, padding: 50, maxZoom: 14 };\n",
       "\n",
       "  function format(value) {\n",
       "    if (Array.isArray(value)) {\n",
       "      const [first, second] = value;\n",
       "      if (first === -Infinity) {\n",
       "        return `< ${formatValue(second)}`;\n",
       "      }\n",
       "      if (second === Infinity) {\n",
       "        return `> ${formatValue(first)}`;\n",
       "      }\n",
       "      return `${formatValue(first)} - ${formatValue(second)}`;\n",
       "    }\n",
       "    return formatValue(value);\n",
       "  }\n",
       "\n",
       "  function formatValue(value) {\n",
       "    if (typeof value === 'number') {\n",
       "      return formatNumber(value);\n",
       "    }\n",
       "    return value;\n",
       "  }\n",
       "\n",
       "  function formatNumber(value) {\n",
       "    const log = Math.log10(Math.abs(value));\n",
       "\n",
       "    if ((log > 4 || log < -2.00000001) && value) {\n",
       "      return value.toExponential(2);\n",
       "    }\n",
       "    \n",
       "    if (!Number.isInteger(value)) {\n",
       "      return value.toLocaleString(undefined, {\n",
       "        minimumFractionDigits: 2,\n",
       "        maximumFractionDigits: 3\n",
       "      });\n",
       "    }\n",
       "    \n",
       "    return value.toLocaleString();\n",
       "  }\n",
       "\n",
       "  function updateViewport(map) {\n",
       "    function updateMapInfo() {\n",
       "      const mapInfo$ = document.getElementById('map-info');\n",
       "      const center = map.getCenter();\n",
       "      const lat = center.lat.toFixed(6);\n",
       "      const lng = center.lng.toFixed(6);\n",
       "      const zoom = map.getZoom().toFixed(2);\n",
       "    \n",
       "      mapInfo$.innerText = `viewport={'zoom': ${zoom}, 'lat': ${lat}, 'lng': ${lng}}`;\n",
       "    }\n",
       "\n",
       "    updateMapInfo();\n",
       "\n",
       "    map.on('zoom', updateMapInfo);\n",
       "    map.on('move', updateMapInfo); \n",
       "  }\n",
       "\n",
       "  function getBasecolorSettings(basecolor) {\n",
       "    return {\n",
       "      'version': 8,\n",
       "      'sources': {},\n",
       "      'layers': [{\n",
       "          'id': 'background',\n",
       "          'type': 'background',\n",
       "          'paint': {\n",
       "              'background-color': basecolor\n",
       "          }\n",
       "      }]\n",
       "    };\n",
       "  }\n",
       "\n",
       "  function getImageElement(mapIndex) {\n",
       "    const id = mapIndex !== undefined ? `map-image-${mapIndex}` : 'map-image';\n",
       "    return document.getElementById(id);\n",
       "  }\n",
       "\n",
       "  function getContainerElement(mapIndex) {\n",
       "    const id = mapIndex !== undefined ? `main-container-${mapIndex}` : 'main-container';\n",
       "    return document.getElementById(id);\n",
       "  }\n",
       "\n",
       "  function saveImage(mapIndex) {\n",
       "    const img = getImageElement(mapIndex);\n",
       "    const container = getContainerElement(mapIndex);\n",
       "\n",
       "    html2canvas(container)\n",
       "      .then((canvas) => setMapImage(canvas, img, container));\n",
       "  }\n",
       "\n",
       "  function setMapImage(canvas, img, container) {\n",
       "    const src = canvas.toDataURL();\n",
       "    img.setAttribute('src', src);\n",
       "    img.style.display = 'block';\n",
       "    container.style.display = 'none';\n",
       "  }\n",
       "\n",
       "  function createDefaultLegend(layers) {\n",
       "    const defaultLegendContainer = document.getElementById('default-legend-container');\n",
       "    defaultLegendContainer.style.display = 'none';\n",
       "\n",
       "    AsBridge.VL.Legends.layersLegend(\n",
       "      '#default-legend',\n",
       "      layers,\n",
       "      {\n",
       "        onLoad: () => defaultLegendContainer.style.display = 'unset'\n",
       "      }\n",
       "    );\n",
       "  }\n",
       "\n",
       "  function createLegend(layer, legendData, layerIndex, mapIndex=0) {\n",
       "    const element = document.querySelector(`#layer${layerIndex}_map${mapIndex}_legend`);\n",
       "    \n",
       "    if (legendData.length) {\n",
       "      legendData.forEach((legend, legendIndex) => _createLegend(layer, legend, layerIndex, legendIndex, mapIndex));\n",
       "    } else {\n",
       "      _createLegend(layer, legendData, layerIndex, 0, mapIndex);\n",
       "    }\n",
       "  }\n",
       "\n",
       "  function _createLegend(layer, legend, layerIndex, legendIndex, mapIndex=0) {\n",
       "    const element = document.querySelector(`#layer${layerIndex}_map${mapIndex}_legend${legendIndex}`);\n",
       "\n",
       "    if (legend.prop) {\n",
       "      const othersLabel = 'Others';   // TODO: i18n\n",
       "      const prop = legend.prop;\n",
       "      const dynamic = legend.dynamic;\n",
       "      const variable = legend.variable;\n",
       "      const config = { othersLabel, variable };\n",
       "      const options = { format, config, dynamic };\n",
       "\n",
       "      if (legend.type.startsWith('size-continuous')) {\n",
       "        config.samples = 4;\n",
       "      }\n",
       "      \n",
       "      AsBridge.VL.Legends.rampLegend(element, layer, prop, options);\n",
       "    }\n",
       "  }\n",
       "\n",
       "  /** From https://github.com/errwischt/stacktrace-parser/blob/master/src/stack-trace-parser.js */\n",
       "\n",
       "  /**\n",
       "   * This parses the different stack traces and puts them into one format\n",
       "   * This borrows heavily from TraceKit (https://github.com/csnover/TraceKit)\n",
       "   */\n",
       "\n",
       "  const UNKNOWN_FUNCTION = '<unknown>';\n",
       "  const chromeRe = /^\\s*at (.*?) ?\\(((?:file|https?|blob|chrome-extension|native|eval|webpack|<anonymous>|\\/).*?)(?::(\\d+))?(?::(\\d+))?\\)?\\s*$/i;\n",
       "  const chromeEvalRe = /\\((\\S*)(?::(\\d+))(?::(\\d+))\\)/;\n",
       "  const winjsRe = /^\\s*at (?:((?:\\[object object\\])?.+) )?\\(?((?:file|ms-appx|https?|webpack|blob):.*?):(\\d+)(?::(\\d+))?\\)?\\s*$/i;\n",
       "  const geckoRe = /^\\s*(.*?)(?:\\((.*?)\\))?(?:^|@)((?:file|https?|blob|chrome|webpack|resource|\\[native).*?|[^@]*bundle)(?::(\\d+))?(?::(\\d+))?\\s*$/i;\n",
       "  const geckoEvalRe = /(\\S+) line (\\d+)(?: > eval line \\d+)* > eval/i;\n",
       "\n",
       "  function parse(stackString) {\n",
       "    const lines = stackString.split('\\n');\n",
       "\n",
       "    return lines.reduce((stack, line) => {\n",
       "      const parseResult =\n",
       "        parseChrome(line) ||\n",
       "        parseWinjs(line) ||\n",
       "        parseGecko(line);\n",
       "\n",
       "      if (parseResult) {\n",
       "        stack.push(parseResult);\n",
       "      }\n",
       "\n",
       "      return stack;\n",
       "    }, []);\n",
       "  }\n",
       "\n",
       "  function parseChrome(line) {\n",
       "    const parts = chromeRe.exec(line);\n",
       "\n",
       "    if (!parts) {\n",
       "      return null;\n",
       "    }\n",
       "\n",
       "    const isNative = parts[2] && parts[2].indexOf('native') === 0; // start of line\n",
       "    const isEval = parts[2] && parts[2].indexOf('eval') === 0; // start of line\n",
       "\n",
       "    const submatch = chromeEvalRe.exec(parts[2]);\n",
       "    if (isEval && submatch != null) {\n",
       "      // throw out eval line/column and use top-most line/column number\n",
       "      parts[2] = submatch[1]; // url\n",
       "      parts[3] = submatch[2]; // line\n",
       "      parts[4] = submatch[3]; // column\n",
       "    }\n",
       "\n",
       "    return {\n",
       "      file: !isNative ? parts[2] : null,\n",
       "      methodName: parts[1] || UNKNOWN_FUNCTION,\n",
       "      arguments: isNative ? [parts[2]] : [],\n",
       "      lineNumber: parts[3] ? +parts[3] : null,\n",
       "      column: parts[4] ? +parts[4] : null,\n",
       "    };\n",
       "  }\n",
       "\n",
       "  function parseWinjs(line) {\n",
       "    const parts = winjsRe.exec(line);\n",
       "\n",
       "    if (!parts) {\n",
       "      return null;\n",
       "    }\n",
       "\n",
       "    return {\n",
       "      file: parts[2],\n",
       "      methodName: parts[1] || UNKNOWN_FUNCTION,\n",
       "      arguments: [],\n",
       "      lineNumber: +parts[3],\n",
       "      column: parts[4] ? +parts[4] : null,\n",
       "    };\n",
       "  }\n",
       "\n",
       "  function parseGecko(line) {\n",
       "    const parts = geckoRe.exec(line);\n",
       "\n",
       "    if (!parts) {\n",
       "      return null;\n",
       "    }\n",
       "\n",
       "    const isEval = parts[3] && parts[3].indexOf(' > eval') > -1;\n",
       "\n",
       "    const submatch = geckoEvalRe.exec(parts[3]);\n",
       "    if (isEval && submatch != null) {\n",
       "      // throw out eval line/column and use top-most line number\n",
       "      parts[3] = submatch[1];\n",
       "      parts[4] = submatch[2];\n",
       "      parts[5] = null; // no column when eval\n",
       "    }\n",
       "\n",
       "    return {\n",
       "      file: parts[3],\n",
       "      methodName: parts[1] || UNKNOWN_FUNCTION,\n",
       "      arguments: parts[2] ? parts[2].split(',') : [],\n",
       "      lineNumber: parts[4] ? +parts[4] : null,\n",
       "      column: parts[5] ? +parts[5] : null,\n",
       "    };\n",
       "  }\n",
       "\n",
       "  function displayError(e) {\n",
       "    const error$ = document.getElementById('error-container');\n",
       "    const errors$ = error$.getElementsByClassName('errors');\n",
       "    const stacktrace$ = document.getElementById('error-stacktrace');\n",
       "\n",
       "    errors$[0].innerHTML = e.name;\n",
       "    errors$[1].innerHTML = e.name;\n",
       "    errors$[2].innerHTML = e.type;\n",
       "    errors$[3].innerHTML = e.message.replace(e.type, '');\n",
       "\n",
       "    error$.style.visibility = 'visible';\n",
       "\n",
       "    const stack = parse(e.stack);\n",
       "    const list = stack.map(item => {\n",
       "      return `<li>\n",
       "      at <span class=&quot;stacktrace-method&quot;>${item.methodName}:</span>\n",
       "      (${item.file}:${item.lineNumber}:${item.column})\n",
       "    </li>`;\n",
       "    });\n",
       "\n",
       "    stacktrace$.innerHTML = list.join('\\n');\n",
       "  }\n",
       "\n",
       "  function resetPopupClick(interactivity) {\n",
       "    interactivity.off('featureClick');\n",
       "  }\n",
       "\n",
       "  function resetPopupHover(interactivity) {\n",
       "    interactivity.off('featureHover');\n",
       "  }\n",
       "\n",
       "  function setPopupsClick(map, popup, interactivity, attrs) {\n",
       "    interactivity.on('featureClick', (event) => {\n",
       "      updatePopup(map, popup, event, attrs);\n",
       "    });\n",
       "  }\n",
       "\n",
       "  function setPopupsHover(map, popup, interactivity, attrs) {\n",
       "    interactivity.on('featureHover', (event) => {\n",
       "      updatePopup(map, popup, event, attrs);\n",
       "    });\n",
       "  }\n",
       "\n",
       "  function updatePopup(map, popup, event, attrs) {\n",
       "    if (event.features.length > 0) {\n",
       "      let popupHTML = '';\n",
       "      const layerIDs = [];\n",
       "\n",
       "      for (const feature of event.features) {\n",
       "        if (layerIDs.includes(feature.layerId)) {\n",
       "          continue;\n",
       "        }\n",
       "        // Track layers to add only one feature per layer\n",
       "        layerIDs.push(feature.layerId);\n",
       "    \n",
       "        for (const item of attrs) {\n",
       "          const variable = feature.variables[item.name];\n",
       "          if (variable) {\n",
       "            let value = variable.value;\n",
       "            value = formatValue(value);\n",
       "\n",
       "            popupHTML = `\n",
       "            <span class=&quot;popup-name&quot;>${item.title}</span>\n",
       "            <span class=&quot;popup-value&quot;>${value}</span>\n",
       "          ` + popupHTML;\n",
       "          }\n",
       "        }\n",
       "      }\n",
       "\n",
       "      popup\n",
       "          .setLngLat([event.coordinates.lng, event.coordinates.lat])\n",
       "          .setHTML(`<div class=&quot;popup-content&quot;>${popupHTML}</div>`);\n",
       "\n",
       "      if (!popup.isOpen()) {\n",
       "        popup.addTo(map);\n",
       "      }\n",
       "    } else {\n",
       "      popup.remove();\n",
       "    }\n",
       "  }\n",
       "\n",
       "  function setInteractivity(map, interactiveLayers, interactiveMapLayers) {\n",
       "    const interactivity = new carto.Interactivity(interactiveMapLayers);\n",
       "    const popup = new mapboxgl.Popup({\n",
       "      closeButton: false,\n",
       "      closeOnClick: false\n",
       "    });\n",
       "\n",
       "    const { clickAttrs, hoverAttrs } = _setInteractivityAttrs(interactiveLayers);\n",
       "\n",
       "    resetPopupClick(map);\n",
       "    resetPopupHover(map);\n",
       "\n",
       "    if (clickAttrs.length > 0) {\n",
       "      setPopupsClick(map, popup, interactivity, clickAttrs);\n",
       "    }\n",
       "\n",
       "    if (hoverAttrs.length > 0) {\n",
       "      setPopupsHover(map, popup, interactivity, hoverAttrs);\n",
       "    }\n",
       "  }\n",
       "\n",
       "  function _setInteractivityAttrs(interactiveLayers) {\n",
       "    let clickAttrs = [];\n",
       "    let hoverAttrs = [];\n",
       "\n",
       "    interactiveLayers.forEach((interactiveLayer) => {\n",
       "      interactiveLayer.interactivity.forEach((interactivityDef) => {\n",
       "        if (interactivityDef.event === 'click') {\n",
       "          clickAttrs = clickAttrs.concat(interactivityDef.attrs);\n",
       "        } else if (interactivityDef.event === 'hover') {\n",
       "          hoverAttrs = hoverAttrs.concat(interactivityDef.attrs);\n",
       "        }\n",
       "      });\n",
       "    });\n",
       "\n",
       "    return { clickAttrs, hoverAttrs };\n",
       "  }\n",
       "\n",
       "  function renderWidget(widget, value) {\n",
       "    widget.element = widget.element || document.querySelector(`#${widget.id}-value`);\n",
       "\n",
       "    if (value && widget.element) {\n",
       "      widget.element.innerText = typeof value === 'number' ? format(value) : value;\n",
       "    }\n",
       "  }\n",
       "\n",
       "  function renderBridge(bridge, widget, mapLayer) {\n",
       "    widget.element = widget.element || document.querySelector(`#${widget.id}`);\n",
       "\n",
       "    switch (widget.type) {\n",
       "      case 'histogram':\n",
       "        const type = _getWidgetType(mapLayer, widget.value, widget.prop);\n",
       "        const histogram = type === 'category' ? 'categoricalHistogram' : 'numericalHistogram';\n",
       "        bridge[histogram](widget.element, widget.value, widget.options);\n",
       "\n",
       "        break;\n",
       "      case 'category':\n",
       "        bridge.category(widget.element, widget.value, widget.options);\n",
       "        break;\n",
       "      case 'animation':\n",
       "        widget.options.propertyName = widget.prop;\n",
       "        bridge.animationControls(widget.element, widget.value, widget.options);\n",
       "        break;\n",
       "      case 'time-series':\n",
       "        widget.options.propertyName = widget.prop;\n",
       "        bridge.timeSeries(widget.element, widget.value, widget.options);\n",
       "        break;\n",
       "    }\n",
       "  }\n",
       "\n",
       "  function bridgeLayerWidgets(map, mapLayer, mapSource, widgets) {\n",
       "    const bridge = new AsBridge.VL.Bridge({\n",
       "      carto: carto,\n",
       "      layer: mapLayer,\n",
       "      source: mapSource,\n",
       "      map: map\n",
       "    });\n",
       "\n",
       "    widgets\n",
       "      .filter((widget) => widget.has_bridge)\n",
       "      .forEach((widget) => renderBridge(bridge, widget, mapLayer));\n",
       "\n",
       "    bridge.build();\n",
       "  }\n",
       "\n",
       "  function _getWidgetType(layer, property, value) {\n",
       "    return layer.metadata && layer.metadata.properties[value] ?\n",
       "      layer.metadata.properties[value].type\n",
       "      : _getWidgetPropertyType(layer, property);\n",
       "  }\n",
       "\n",
       "  function _getWidgetPropertyType(layer, property) {\n",
       "    return layer.metadata && layer.metadata.properties[property] ?\n",
       "      layer.metadata.properties[property].type\n",
       "      : null;\n",
       "  }\n",
       "\n",
       "  function SourceFactory() {\n",
       "    const sourceTypes = { GeoJSON, Query, MVT };\n",
       "\n",
       "    this.createSource = (layer) => {\n",
       "      return sourceTypes[layer.type](layer);\n",
       "    };\n",
       "  }\n",
       "\n",
       "  function GeoJSON(layer) {\n",
       "    return new carto.source.GeoJSON(_decodeJSONQuery(layer.query));\n",
       "  }\n",
       "\n",
       "  function Query(layer) {\n",
       "    const auth = {\n",
       "      username: layer.credentials.username,\n",
       "      apiKey: layer.credentials.api_key || 'default_public'\n",
       "    };\n",
       "\n",
       "    const config = {\n",
       "      serverURL: layer.credentials.base_url || `https://${layer.credentials.username}.carto.com/`\n",
       "    };\n",
       "\n",
       "    return new carto.source.SQL(layer.query, auth, config);\n",
       "  }\n",
       "\n",
       "  function MVT(layer) {\n",
       "    return new carto.source.MVT(layer.query.file, JSON.parse(layer.query.metadata));\n",
       "  }\n",
       "\n",
       "  function _decodeJSONQuery(query) {\n",
       "    return JSON.parse(Base64.decode(query.replace(/b\\'/, '\\'')));\n",
       "  }\n",
       "\n",
       "  const factory = new SourceFactory();\n",
       "\n",
       "  function initMapLayer(layer, layerIndex, numLayers, hasLegends, map, mapIndex) {\n",
       "    const mapSource = factory.createSource(layer);\n",
       "    const mapViz = new carto.Viz(layer.viz);\n",
       "    const mapLayer = new carto.Layer(`layer${layerIndex}`, mapSource, mapViz);\n",
       "    const mapLayerIndex = numLayers - layerIndex - 1;\n",
       "\n",
       "    try {\n",
       "      mapLayer._updateLayer.catch(displayError);\n",
       "    } catch (e) {\n",
       "      throw e;\n",
       "    }\n",
       "\n",
       "\n",
       "    mapLayer.addTo(map);\n",
       "\n",
       "    setLayerLegend(layer, mapLayerIndex, mapLayer, mapIndex, hasLegends);\n",
       "    setLayerWidgets(map, layer, mapLayer, mapLayerIndex, mapSource);\n",
       "\n",
       "    return mapLayer;\n",
       "  }\n",
       "\n",
       "  function getInteractiveLayers(layers, mapLayers) {\n",
       "    const interactiveLayers = [];\n",
       "    const interactiveMapLayers = [];\n",
       "\n",
       "    layers.forEach((layer, index) => {\n",
       "      if (layer.interactivity) {\n",
       "        interactiveLayers.push(layer);\n",
       "        interactiveMapLayers.push(mapLayers[index]);\n",
       "      }\n",
       "    });\n",
       "\n",
       "    return { interactiveLayers, interactiveMapLayers };\n",
       "  }\n",
       "\n",
       "  function setLayerLegend(layer, mapLayerIndex, mapLayer, mapIndex, hasLegends) {\n",
       "    if (hasLegends && layer.legend) {\n",
       "      createLegend(mapLayer, layer.legend, mapLayerIndex, mapIndex);\n",
       "    }\n",
       "  }\n",
       "\n",
       "  function setLayerWidgets(map, layer, mapLayer, mapLayerIndex, mapSource) {\n",
       "    if (layer.widgets.length) {\n",
       "      initLayerWidgets(layer.widgets, mapLayerIndex);\n",
       "      updateLayerWidgets(layer.widgets, mapLayer);\n",
       "      bridgeLayerWidgets(map, mapLayer, mapSource, layer.widgets);\n",
       "    }\n",
       "  }\n",
       "\n",
       "  function initLayerWidgets(widgets, mapLayerIndex) {\n",
       "    widgets.forEach((widget, widgetIndex) => {\n",
       "      const id = `layer${mapLayerIndex}_widget${widgetIndex}`;\n",
       "      widget.id = id;\n",
       "    });\n",
       "  }\n",
       "\n",
       "  function updateLayerWidgets(widgets, mapLayer) {\n",
       "    mapLayer.on('updated', () => renderLayerWidgets(widgets, mapLayer));\n",
       "  }\n",
       "\n",
       "  function renderLayerWidgets(widgets, mapLayer) {\n",
       "    const variables = mapLayer.viz.variables;\n",
       "\n",
       "    widgets\n",
       "      .filter((widget) => !widget.has_bridge)\n",
       "      .forEach((widget) => {\n",
       "        const name = widget.variable_name;\n",
       "        const value = getWidgetValue(name, variables);\n",
       "        renderWidget(widget, value);\n",
       "      });\n",
       "  }\n",
       "\n",
       "  function getWidgetValue(name, variables) {\n",
       "    return name && variables[name] ? variables[name].value : null;\n",
       "  }\n",
       "\n",
       "  function setReady(settings) {\n",
       "    try {\n",
       "      return settings.maps ? initMaps(settings.maps) : initMap(settings);\n",
       "    } catch (e) {\n",
       "      displayError(e);\n",
       "    }\n",
       "  }\n",
       "\n",
       "  function initMaps(maps) {\n",
       "    return maps.map((mapSettings, mapIndex) => {\n",
       "      return initMap(mapSettings, mapIndex);\n",
       "    });\n",
       "  }\n",
       "\n",
       "  function initMap(settings, mapIndex) {\n",
       "    const basecolor = getBasecolorSettings(settings.basecolor);\n",
       "    const basemapStyle =  BASEMAPS[settings.basemap] || settings.basemap || basecolor;\n",
       "    const container = mapIndex !== undefined ? `map-${mapIndex}` : 'map';\n",
       "    const map = createMap(container, basemapStyle, settings.bounds, settings.mapboxtoken);\n",
       "\n",
       "    if (settings.show_info) {\n",
       "      updateViewport(map);\n",
       "    }\n",
       "\n",
       "    if (settings.camera) {\n",
       "      map.flyTo(settings.camera);\n",
       "    }\n",
       "\n",
       "    return initLayers(map, settings, mapIndex);\n",
       "  }\n",
       "\n",
       "  function initLayers(map, settings, mapIndex) {\n",
       "    const numLayers = settings.layers.length;\n",
       "    const hasLegends = settings.has_legends;\n",
       "    const isDefaultLegend = settings.default_legend;\n",
       "    const isStatic = settings.is_static;\n",
       "    const layers = settings.layers;\n",
       "    const mapLayers = getMapLayers(\n",
       "      layers,\n",
       "      numLayers,\n",
       "      hasLegends,\n",
       "      map,\n",
       "      mapIndex\n",
       "    );\n",
       "\n",
       "    createLegend$1(isDefaultLegend, mapLayers);\n",
       "    setInteractiveLayers(map, layers, mapLayers);\n",
       "\n",
       "    return waitForMapLayersLoad(isStatic, mapIndex, mapLayers);\n",
       "  }\n",
       "\n",
       "  function waitForMapLayersLoad(isStatic, mapIndex, mapLayers) {\n",
       "    return new Promise((resolve) => {\n",
       "      carto.on('loaded', mapLayers, onMapLayersLoaded.bind(\n",
       "        this, isStatic, mapIndex, mapLayers, resolve)\n",
       "      );\n",
       "    });\n",
       "  }\n",
       "\n",
       "  function onMapLayersLoaded(isStatic, mapIndex, mapLayers, resolve) {\n",
       "    if (isStatic) {\n",
       "      saveImage(mapIndex);\n",
       "    }\n",
       "\n",
       "    resolve(mapLayers);\n",
       "  }\n",
       "\n",
       "  function getMapLayers(layers, numLayers, hasLegends, map, mapIndex) {\n",
       "    return layers.map((layer, layerIndex) => {\n",
       "      return initMapLayer(layer, layerIndex, numLayers, hasLegends, map, mapIndex);\n",
       "    });\n",
       "  }\n",
       "\n",
       "  function setInteractiveLayers(map, layers, mapLayers) {\n",
       "    const { interactiveLayers, interactiveMapLayers } = getInteractiveLayers(layers, mapLayers);\n",
       "\n",
       "    if (interactiveLayers && interactiveLayers.length > 0) {\n",
       "      setInteractivity(map, interactiveLayers, interactiveMapLayers);\n",
       "    }\n",
       "  }\n",
       "\n",
       "  function createLegend$1(isDefaultLegend, mapLayers) {\n",
       "    if (isDefaultLegend) {\n",
       "      createDefaultLegend(mapLayers);\n",
       "    }\n",
       "  }\n",
       "\n",
       "  function createMap(container, basemapStyle, bounds, accessToken) {\n",
       "    const map = createMapboxGLMap(container, basemapStyle, accessToken);\n",
       "\n",
       "    map.addControl(attributionControl);\n",
       "    map.fitBounds(bounds, FIT_BOUNDS_SETTINGS);\n",
       "\n",
       "    return map;\n",
       "  }\n",
       "\n",
       "  function createMapboxGLMap(container, style, accessToken) {\n",
       "    if (accessToken) {\n",
       "      mapboxgl.accessToken = accessToken;\n",
       "    }\n",
       "\n",
       "    return new mapboxgl.Map({\n",
       "      container,\n",
       "      style,\n",
       "      zoom: 9,\n",
       "      dragRotate: false,\n",
       "      attributionControl: false\n",
       "    });\n",
       "  }\n",
       "\n",
       "  function init(settings) {\n",
       "    setReady(settings);\n",
       "  }\n",
       "\n",
       "  return init;\n",
       "\n",
       "}());\n",
       "</script>\n",
       "<script>\n",
       "  document\n",
       "  .querySelector('as-responsive-content')\n",
       "  .addEventListener('ready', () => {\n",
       "    const basecolor = '';\n",
       "    const basemap = 'Positron';\n",
       "    const bounds = [[-88.89408, -41.75968], [147.35097, 51.65293]];\n",
       "    const camera = {&quot;bearing&quot;: null, &quot;center&quot;: [-0.09, 51.53], &quot;pitch&quot;: null, &quot;zoom&quot;: 10};\n",
       "    const default_legend = 'False' === 'true';\n",
       "    const has_legends = 'False' === 'true';\n",
       "    const is_static = 'None' === 'true';\n",
       "    const layers = [{&quot;credentials&quot;: {&quot;api_key&quot;: &quot;26b674ea4f1f5e751ccb9559e4bb4ac4f9e65126&quot;, &quot;base_url&quot;: &quot;https://arroyo-carto.carto.com&quot;, &quot;username&quot;: &quot;arroyo-carto&quot;}, &quot;has_legend_list&quot;: false, &quot;interactivity&quot;: [], &quot;legend&quot;: {}, &quot;query&quot;: &quot;SELECT * FROM \\&quot;arroyo-carto\\&quot;.\\&quot;london_stations\\&quot;&quot;, &quot;type&quot;: &quot;Query&quot;, &quot;viz&quot;: &quot;color: hex(\\&quot;#EE4D5A\\&quot;)\\nwidth: ramp(linear(zoom(),0,18),[2,10])\\nstrokeWidth: ramp(linear(zoom(),0,18),[0,1])\\nstrokeColor: opacity(#222,ramp(linear(zoom(),0,18),[0,0.6]))\\n&quot;, &quot;widgets&quot;: []}];\n",
       "    const mapboxtoken = '';\n",
       "    const show_info = 'None' === 'true';\n",
       "\n",
       "    init({\n",
       "      basecolor,\n",
       "      basemap,\n",
       "      bounds,\n",
       "      camera,\n",
       "      default_legend,\n",
       "      has_legends,\n",
       "      is_static,\n",
       "      layers,\n",
       "      mapboxtoken,\n",
       "      show_info\n",
       "    });\n",
       "});\n",
       "</script>\n",
       "</html>\n",
       "\">\n",
       "\n",
       "</iframe>"
      ],
      "text/plain": [
       "<cartoframes.viz.map.Map at 0x7faf0770f320>"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from cartoframes.viz import Map, Layer\n",
    "\n",
    "Map(Layer('london_stations'), viewport={'zoom': 10, 'lat': 51.53, 'lng': -0.09})"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}