Untitled12dm2.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyPNdSFy5e0Ox2crB29zkvry",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/vaibhavi-kulkarni/DM/blob/main/Untitled12dm2.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 15,
      "metadata": {
        "id": "TXrNfVRA6j5t"
      },
      "outputs": [],
      "source": [
        "# Importing necessary libraries\n",
        "import pandas as pd\n",
        "import numpy as np\n",
        "from sklearn.tree import DecisionTreeClassifier\n",
        "from sklearn.model_selection import train_test_split\n",
        "from sklearn import metrics\n",
        "from sklearn.metrics import classification_report, confusion_matrix"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df = pd.read_csv(\"2016-Q1-Trips-History-Data.csv\")\n",
        "df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "gQb_jIq27c9o",
        "outputId": "95bd1e24-53ca-43a2-d649-6db7f99a44d2"
      },
      "execution_count": 16,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   Duration (ms)       Start date         End date  Start station number  \\\n",
              "0         301295  3/31/2016 23:59    4/1/2016 0:04                 31280   \n",
              "1         557887  3/31/2016 23:59    4/1/2016 0:08                 31275   \n",
              "2         555944  3/31/2016 23:59    4/1/2016 0:08                 31101   \n",
              "3         766916  3/31/2016 23:57    4/1/2016 0:09                 31226   \n",
              "4         139656  3/31/2016 23:57  3/31/2016 23:59                 31011   \n",
              "\n",
              "                    Start station  End station number  \\\n",
              "0                  11th & S St NW               31506   \n",
              "1  New Hampshire Ave & 24th St NW               31114   \n",
              "2                  14th & V St NW               31221   \n",
              "3      34th St & Wisconsin Ave NW               31214   \n",
              "4               23rd & Crystal Dr               31009   \n",
              "\n",
              "                 End station Bike number Member Type  \n",
              "0  1st & Rhode Island Ave NW      W00022  Registered  \n",
              "1   18th St & Wyoming Ave NW      W01294  Registered  \n",
              "2             18th & M St NW      W01416  Registered  \n",
              "3      17th & Corcoran St NW      W01090  Registered  \n",
              "4          27th & Crystal Dr      W21934  Registered  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-673533fa-3081-4b0c-879b-2f82dbf70720\" class=\"colab-df-container\">\n",
              "    <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>Duration (ms)</th>\n",
              "      <th>Start date</th>\n",
              "      <th>End date</th>\n",
              "      <th>Start station number</th>\n",
              "      <th>Start station</th>\n",
              "      <th>End station number</th>\n",
              "      <th>End station</th>\n",
              "      <th>Bike number</th>\n",
              "      <th>Member Type</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>301295</td>\n",
              "      <td>3/31/2016 23:59</td>\n",
              "      <td>4/1/2016 0:04</td>\n",
              "      <td>31280</td>\n",
              "      <td>11th &amp; S St NW</td>\n",
              "      <td>31506</td>\n",
              "      <td>1st &amp; Rhode Island Ave NW</td>\n",
              "      <td>W00022</td>\n",
              "      <td>Registered</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>557887</td>\n",
              "      <td>3/31/2016 23:59</td>\n",
              "      <td>4/1/2016 0:08</td>\n",
              "      <td>31275</td>\n",
              "      <td>New Hampshire Ave &amp; 24th St NW</td>\n",
              "      <td>31114</td>\n",
              "      <td>18th St &amp; Wyoming Ave NW</td>\n",
              "      <td>W01294</td>\n",
              "      <td>Registered</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>555944</td>\n",
              "      <td>3/31/2016 23:59</td>\n",
              "      <td>4/1/2016 0:08</td>\n",
              "      <td>31101</td>\n",
              "      <td>14th &amp; V St NW</td>\n",
              "      <td>31221</td>\n",
              "      <td>18th &amp; M St NW</td>\n",
              "      <td>W01416</td>\n",
              "      <td>Registered</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>766916</td>\n",
              "      <td>3/31/2016 23:57</td>\n",
              "      <td>4/1/2016 0:09</td>\n",
              "      <td>31226</td>\n",
              "      <td>34th St &amp; Wisconsin Ave NW</td>\n",
              "      <td>31214</td>\n",
              "      <td>17th &amp; Corcoran St NW</td>\n",
              "      <td>W01090</td>\n",
              "      <td>Registered</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>139656</td>\n",
              "      <td>3/31/2016 23:57</td>\n",
              "      <td>3/31/2016 23:59</td>\n",
              "      <td>31011</td>\n",
              "      <td>23rd &amp; Crystal Dr</td>\n",
              "      <td>31009</td>\n",
              "      <td>27th &amp; Crystal Dr</td>\n",
              "      <td>W21934</td>\n",
              "      <td>Registered</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-673533fa-3081-4b0c-879b-2f82dbf70720')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-673533fa-3081-4b0c-879b-2f82dbf70720 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-673533fa-3081-4b0c-879b-2f82dbf70720');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-aa84e4bc-91ba-4a77-bc32-6cbe0126c8bb\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-aa84e4bc-91ba-4a77-bc32-6cbe0126c8bb')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-aa84e4bc-91ba-4a77-bc32-6cbe0126c8bb button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "df"
            }
          },
          "metadata": {},
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "address=df['End station'].unique()\n",
        "print(address)\n",
        "df = df.dropna()\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "WyGYyZ8rAXOQ",
        "outputId": "539a6d0f-d795-4042-c9bb-c1cef5a8ac8f"
      },
      "execution_count": 17,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "['1st & Rhode Island Ave NW' '18th St & Wyoming Ave NW' '18th & M St NW'\n",
            " '17th & Corcoran St NW' '27th & Crystal Dr' '5th & K St NW'\n",
            " '18th & R St NW' '20th & O St NW / Dupont South'\n",
            " '5th St & Massachusetts Ave NW' '1st & N St  SE'\n",
            " '21st St N & N Pierce St' '3rd St & Pennsylvania Ave SE'\n",
            " 'Eckington Pl & Q St NE' '34th St & Wisconsin Ave NW'\n",
            " 'Bladensburg Rd & Benning Rd NE' '2nd & G St NE'\n",
            " 'Smithsonian / Jefferson Dr & 12th St SW' '21st & M St NW'\n",
            " 'Lincoln Memorial' 'Lee Hwy & N Cleveland St' '15th & Euclid St  NW'\n",
            " 'M St & New Jersey Ave SE' 'Massachusetts Ave & Dupont Circle NW'\n",
            " 'Gallaudet / 8th St & Florida Ave NE' '10th & Florida Ave NW'\n",
            " 'Constitution Ave & 2nd St NW/DOL' '14th & Belmont St NW'\n",
            " 'Columbus Circle / Union Station' 'Lamont & Mt Pleasant NW'\n",
            " 'Neal St & Trinidad Ave NE' 'N Veitch & Key Blvd'\n",
            " '14th & Rhode Island Ave NW' 'N Quincy St & Wilson Blvd' '14th & V St NW'\n",
            " '14th & Harvard St NW' 'Harvard St & Adams Mill Rd NW'\n",
            " '17th & K St NW / Farragut Square' 'MLK Library/9th & G St NW'\n",
            " 'California St & Florida Ave NW' '14th St & Spring Rd NW'\n",
            " 'Park Rd & Holmead Pl NW' '17th St & Massachusetts Ave NW'\n",
            " 'C & O Canal & Wisconsin Ave NW' '13th & D St NE' '10th & K St NW'\n",
            " '21st & I St NW' '3rd & H St NE' 'Thomas Circle' '1st & M St NE'\n",
            " 'Jefferson Dr & 14th St SW' 'New Hampshire Ave & 24th St NW'\n",
            " 'Georgia Ave and Fairmont St NW' '19th & G St NW'\n",
            " 'Connecticut Ave & Tilden St NW' 'N Quincy St & Glebe Rd' '1st & K St SE'\n",
            " '1st & H St NW' 'King St Metro North / Cameron St'\n",
            " '22nd & I St NW / Foggy Bottom' 'Court House Metro / 15th & N Uhle St '\n",
            " 'Key Blvd & N Quinn St' '11th & M St NW' 'Georgia Ave & Emerson St NW'\n",
            " '4th & M St SW' '25th St & Pennsylvania Ave NW' '9th & Upshur St NW'\n",
            " 'New Jersey Ave & N St NW/Dunbar HS' '3rd & Elm St NW'\n",
            " 'Washington & Independence Ave SW/HHS' '13th & H St NE'\n",
            " 'Wisconsin Ave & O St NW' 'Connecticut & Nebraska Ave NW'\n",
            " '4th & D St NW / Judiciary Square' '13th St & Eastern Ave'\n",
            " '37th & O St NW / Georgetown University' '7th & T St NW'\n",
            " 'New Hampshire Ave & T St NW' '19th & East Capitol St SE'\n",
            " '14th & D St SE' '7th & R St NW / Shaw Library'\n",
            " '14th St Heights / 14th & Crittenden St NW' '11th & Kenyon St NW'\n",
            " '3rd & D St SE' '20th St & Florida Ave NW'\n",
            " 'Pentagon City Metro / 12th & S Hayes St' '4th & East Capitol St NE'\n",
            " 'Metro Center / 12th & G St NW' 'Adams Mill & Columbia Rd NW'\n",
            " 'Georgia & New Hampshire Ave NW' 'M St & Pennsylvania Ave NW'\n",
            " 'Pleasant St & MLK Ave SE' 'Oklahoma Ave & D St NE'\n",
            " 'M St & Delaware Ave NE' 'Mount Vernon Ave & E Del Ray Ave'\n",
            " 'Florida Ave & R St NW' '8th & H St NW' '6th & H St NE' '16th & R St NW'\n",
            " 'Iwo Jima Memorial/N Meade & 14th St N' 'Maryland & Independence Ave SW'\n",
            " '14th & R St NW' 'Ohio Dr & West Basin Dr SW / MLK & FDR Memorials'\n",
            " 'Eastern Market Metro / Pennsylvania Ave & 7th St SE'\n",
            " 'N Pershing Dr & Wayne St' 'Georgetown Harbor / 30th St NW'\n",
            " '11th & S St NW' '8th & O St NW' '10th & U St NW' 'Glebe Rd & 11th St N'\n",
            " '15th & P St NW' 'Calvert & Biltmore St NW' 'Calvert St & Woodley Pl NW'\n",
            " '12th & U St NW' '34th & Water St NW' 'Potomac & Pennsylvania Ave SE'\n",
            " '14th & G St NW' '23rd & E St NW ' 'Lee Hwy & N Scott St'\n",
            " 'Wilson Blvd & N Oakland St' '8th & F St NE' '23rd & Crystal Dr'\n",
            " '15th St & Massachusetts Ave SE'\n",
            " 'Shirlington Transit Center / S Quincy & Randolph St'\n",
            " '8th & Eye St SE / Barracks Row' 'N Randolph St & Fairfax Dr'\n",
            " 'Eisenhower Ave & Mill Race Ln' 'New Jersey Ave & R St NW'\n",
            " 'D St & Maryland Ave NE' '3rd & H St NW' '21st St & Constitution Ave NW'\n",
            " '16th & Irving St NW' '15th & East Capitol St NE' '3rd & Tingey St SE'\n",
            " 'New York Ave & 15th St NW' 'Union Market/6th St & Neal Pl NE'\n",
            " 'Van Ness Metro / UDC' 'North Capitol St & G Pl NE'\n",
            " 'Convention Center / 7th & M St NW' 'North Capitol St & F St NW'\n",
            " '16th & Harvard St NW' 'Anacostia Metro' '15th & L St NW'\n",
            " 'Lynn & 19th St North' 'Columbia Rd & Belmont St NW'\n",
            " 'Rhode Island Ave & V St NE' 'Army Navy Dr & S Nash St'\n",
            " 'Lincoln Park / 13th & East Capitol St NE '\n",
            " '18th St & Rhode Island Ave NE' '17th & K St NW'\n",
            " '39th & Calvert St NW / Stoddert' '4th & W St NE' 'N Veitch  & 20th St N'\n",
            " 'Hains Point/Buckeye & Ohio Dr SW' 'Pershing & N George Mason Dr'\n",
            " '7th & F St NW / National Portrait Gallery' '17th & G St NW'\n",
            " '12th & Army Navy Dr' '20th & E St NW' 'Utah St & 11th St N '\n",
            " 'Fenton St & Gist Ave' '15th & F St NE'\n",
            " 'TJ Cmty Ctr / 2nd St & S Old Glebe Rd' 'Wilson Blvd & Franklin Rd'\n",
            " '12th & L St NW' 'Maryland Ave & E St NE' '4th & E St SW'\n",
            " 'E Montgomery Ave & Maryland Ave' 'Georgia & Missouri Ave NW'\n",
            " 'King St Metro South' \"L'Enfant Plaza / 7th & C St SW\"\n",
            " 'Commerce St & Fayette St' '19th St & Pennsylvania Ave NW'\n",
            " 'Columbia Pike & S Walter Reed Dr' 'Carroll & Ethan Allen Ave'\n",
            " '15th & K St NW' 'Braddock Rd Metro'\n",
            " 'Ballston Metro / N Stuart & 9th St N' '24th & N St NW'\n",
            " '10th St & Constitution Ave NW' 'Ballenger Ave & Dulaney St'\n",
            " '15th & N Scott St' 'S Glebe & Potomac Ave' 'Washington Blvd & 10th St N'\n",
            " 'Bethesda Metro' 'Virginia Square Metro / N Monroe St & 9th St N'\n",
            " 'S Joyce & 16th St S' '11th & H St NE' '19th St & Constitution Ave NW'\n",
            " '21st St & Pennsylvania Ave NW' 'Jefferson Memorial'\n",
            " '8th & East Capitol St NE' 'Washington Blvd & 7th St N'\n",
            " 'Rosslyn Metro / Wilson Blvd & Ft Myer Dr' '5th & Kennedy St NW'\n",
            " '10th & E St NW' '3000 Connecticut Ave NW / National Zoo'\n",
            " 'Old Georgetown Rd & Southwick St' '14th St & New York Ave NW'\n",
            " '3rd & G St SE' '20th & L St NW' 'N Rhodes & 16th St N'\n",
            " 'New York Ave & Hecht Ave NE' '8th & D St NW' '13th St & New York Ave NW'\n",
            " 'Lee Hwy & N Adams St' 'Tenleytown / Wisconsin Ave & Albemarle St NW'\n",
            " 'Carroll & Westmoreland Ave' 'Arlington Blvd & N Queen St'\n",
            " 'Columbia Rd & Georgia Ave NW' 'King St & Patrick St'\n",
            " 'Eastern Market / 7th & North Carolina Ave SE'\n",
            " 'McKinley St & Connecticut Ave NW' 'River Rd & Landy Ln'\n",
            " 'Crystal City Metro / 18th & Bell St' '20th & Crystal Dr'\n",
            " 'Battery Ln & Trolley Trail' 'Columbia Pike & S Courthouse Rd'\n",
            " 'Aurora Hills Community Ctr/18th & Hayes St'\n",
            " 'East West Hwy & Blair Mill Rd' 'Potomac Greens Dr & Slaters Ln'\n",
            " '6th St & Indiana Ave NW' '14th & Upshur St NW'\n",
            " 'Wisconsin Ave & Newark St NW'\n",
            " 'Connecticut Ave & Newark St NW / Cleveland Park'\n",
            " 'Mount Vernon Ave & Kennedy St' 'Offutt Ln & Chevy Chase Dr'\n",
            " '39th & Veazey St NW' 'Central Library / N Quincy St & 10th St N'\n",
            " '12th & Irving St NE' '17th & Rhode Island Ave NW' '5th & F St NW'\n",
            " \"Independence Ave & L'Enfant Plaza SW/DOE\" 'Fairfax Dr & Kenmore St'\n",
            " 'Arlington Blvd & Fillmore St' 'Wilson Blvd & N Edgewood St'\n",
            " 'Benning Branch Library' '6th & Water St SW / SW Waterfront'\n",
            " '36th & Calvert St NW / Glover Park' '6th & S Ball St'\n",
            " 'Clarendon Blvd & Pierce St' '11th & F St NW' 'Potomac Ave & 35th St S'\n",
            " 'John McCormack Dr & Michigan Ave NE'\n",
            " 'S Arlington Mill Dr & Campbell Ave' '19th & L St NW'\n",
            " '20th St & Virginia Ave NW' 'Minnesota Ave Metro/DOES'\n",
            " 'Fairfax Dr & Wilson Blvd' 'Market Square / King St & Royal St'\n",
            " '18th & Eads St.' 'Saint Asaph St & Pendleton  St'\n",
            " 'Garland Ave & Walden Rd' 'Norfolk Ave & Fairmont St'\n",
            " 'Bethesda Ave & Arlington Rd' 'Wisconsin Ave & Ingomar St NW'\n",
            " 'S Stafford & 34th St S' 'Clarendon Blvd & N Fillmore St'\n",
            " 'Barton St & 10th St N' 'Fenton St & New York Ave '\n",
            " 'Clarendon Metro / Wilson Blvd & N Highland St' 'Prince St & Union St'\n",
            " '14th St & Colorado Ave NW'\n",
            " 'US Dept of State / Virginia Ave & 21st St NW' 'Kennedy Center'\n",
            " 'Saint Asaph & Madison St' 'Philadelphia & Maple Ave' '19th & K St NW'\n",
            " '26th & S Clark St' 'Rolfe St & 9th St S' 'Montgomery & East Ln'\n",
            " 'S Four Mile Run & Walter Reed Dr' 'Wilson Blvd & N Uhle St'\n",
            " 'USDA / 12th & Independence Ave SW' 'Wilson Blvd & N Illinois St '\n",
            " 'Maple & Ritchie Ave' '14th & D St NW / Ronald Reagan Building'\n",
            " 'Columbia Pike & S Orme St' '23rd & Eads St' 'Hamlin & 7th St NE'\n",
            " 'Cordell & Norfolk Ave' 'Lee Hwy & N Nelson St'\n",
            " 'George Mason Dr & Wilson Blvd'\n",
            " 'Friendship Hts Metro/Wisconsin Ave & Wisconsin Cir'\n",
            " 'Potomac Ave & 8th St SE' '1st & Washington Hospital Center NW'\n",
            " 'S Joyce & Army Navy Dr' '18th St & Pennsylvania Ave NW'\n",
            " '28th St S & S Meade St' 'Duke St & John Carlyle St'\n",
            " 'Shady Grove Metro West' '19th & E Street NW'\n",
            " 'Pennsylvania & Minnesota Ave SE' 'Mount Vernon Ave & E Nelson Ave'\n",
            " '12th & Newton St NE' 'Washington Blvd & Walter Reed Dr '\n",
            " 'Rhode Island Ave Metro' 'Henry St & Pendleton St'\n",
            " 'Monroe Ave & Leslie Ave' '15th & Crystal Dr'\n",
            " 'Montgomery College/W Campus Dr & Mannakee St'\n",
            " 'Veterans Pl & Pershing Dr ' 'Good Hope Rd & MLK Ave SE' '47th & Elm St'\n",
            " 'Takoma Metro' '10th & Monroe St NE' 'S Troy St & 26th St S'\n",
            " 'Long Bridge Park/Long Bridge Dr & 6th St S'\n",
            " 'Friendship Blvd & Willard Ave' 'Anacostia Library'\n",
            " 'Nannie Helen Burroughs & Minnesota Ave NE'\n",
            " 'S George Mason Dr & Four Mile Run' 'Good Hope Rd & 14th St SE'\n",
            " 'Washington Adventist U / Flower Ave & Division St'\n",
            " 'Fessenden St & Wisconsin Ave NW' 'Connecticut Ave & Chevy Chase Lake Dr'\n",
            " 'Ward Circle / American University' 'Rockville Metro East'\n",
            " 'Walter Reed Community Center / Walter Reed Dr & 16th St S'\n",
            " 'Medical Center Dr & Key West Ave' 'Ripley & Bonifant St'\n",
            " 'S Walter Reed Dr & 8th St S' 'Norfolk & Rugby Ave'\n",
            " 'Rockville Metro West' 'Anacostia Ave & Benning Rd NE / River Terrace '\n",
            " 'Fenton St & Ellsworth Dr ' 'Lee Hwy & N Kirkwood Rd'\n",
            " 'Monroe St & Monroe Pl' 'Arlington Blvd & S George Mason Dr/NFATC'\n",
            " 'S Four Mile Run Dr & S Shirlington Rd' '20th & Bell St'\n",
            " 'Medical Center Metro ' 'King Farm Blvd & Piccard Dr'\n",
            " 'Shady Grove Hospital' 'Georgia Ave & Spring St'\n",
            " 'Crabbs Branch Way & Calhoun Pl' 'Washington Blvd & N Frederick St'\n",
            " 'Taft St & E Gude Dr' 'Yuma St & Tenley Circle NW'\n",
            " 'S George Mason Dr & 13th St S'\n",
            " 'Columbia Pike & S Dinwiddie St / Arlington Mill Community Center'\n",
            " 'Good Hope & Naylor Rd SE' 'Fort Totten Metro' 'Spring St & Second Ave'\n",
            " 'Fallsgrove Blvd & Fallsgrove Dr'\n",
            " 'Silver Spring Metro/Colesville Rd & Wayne Ave'\n",
            " 'King Farm Blvd & Pleasant Dr' 'Lee Hwy & N Woodstock St'\n",
            " 'S Oakland St & Columbia Pike' 'Madison & N Henry St'\n",
            " 'Branch & Pennsylvania Ave SE' 'Traville Gateway Dr & Gudelsky Dr'\n",
            " 'Fallsgrove Dr & W Montgomery Ave' 'Alabama & MLK Ave SE'\n",
            " 'Key West Ave & Siesta Key Way' '31st & Woodrow St S'\n",
            " 'Deanwood Rec Center' 'Montgomery Ave & Waverly St '\n",
            " 'Piccard & W Gude Dr' 'Randle Circle & Minnesota Ave SE'\n",
            " '34th St & Minnesota Ave SE' 'Fleet St & Ritchie Pkwy' 'Fairfax Village'\n",
            " 'Needwood Rd & Eagles Head Ct' 'Congress Heights Metro'\n",
            " 'S Kenmore & 24th St S' 'Broschart & Blackwell Rd'\n",
            " 'Frederick Ave & Horners Ln' 'Crabbs Branch Way & Redland Rd'\n",
            " 'Benning Rd & East Capitol St NE / Benning Rd Metro'\n",
            " 'Nannie Helen Burroughs Ave & 49th St NE']\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "from sklearn.preprocessing import LabelEncoder\n",
        "gle = LabelEncoder()\n",
        "address_labels = gle.fit_transform(df['End station'])\n",
        "address_labels = gle.fit_transform(df['Start station'])\n",
        "address_mappings = {index: label for index, label in\n",
        "                  enumerate(gle.classes_)}\n",
        "address_mappings"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "2z6FCqXoAZ9w",
        "outputId": "77ec5afe-685a-42bf-8d31-f323c418fa88"
      },
      "execution_count": 18,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{0: '10th & E St NW',\n",
              " 1: '10th & Florida Ave NW',\n",
              " 2: '10th & K St NW',\n",
              " 3: '10th & Monroe St NE',\n",
              " 4: '10th & U St NW',\n",
              " 5: '10th St & Constitution Ave NW',\n",
              " 6: '11th & F St NW',\n",
              " 7: '11th & H St NE',\n",
              " 8: '11th & Kenyon St NW',\n",
              " 9: '11th & M St NW',\n",
              " 10: '11th & S St NW',\n",
              " 11: '12th & Army Navy Dr',\n",
              " 12: '12th & Irving St NE',\n",
              " 13: '12th & L St NW',\n",
              " 14: '12th & Newton St NE',\n",
              " 15: '12th & U St NW',\n",
              " 16: '13th & D St NE',\n",
              " 17: '13th & H St NE',\n",
              " 18: '13th St & Eastern Ave',\n",
              " 19: '13th St & New York Ave NW',\n",
              " 20: '14th & Belmont St NW',\n",
              " 21: '14th & D St NW / Ronald Reagan Building',\n",
              " 22: '14th & D St SE',\n",
              " 23: '14th & G St NW',\n",
              " 24: '14th & Harvard St NW',\n",
              " 25: '14th & R St NW',\n",
              " 26: '14th & Rhode Island Ave NW',\n",
              " 27: '14th & Upshur St NW',\n",
              " 28: '14th & V St NW',\n",
              " 29: '14th St & Colorado Ave NW',\n",
              " 30: '14th St & New York Ave NW',\n",
              " 31: '14th St & Spring Rd NW',\n",
              " 32: '14th St Heights / 14th & Crittenden St NW',\n",
              " 33: '15th & Crystal Dr',\n",
              " 34: '15th & East Capitol St NE',\n",
              " 35: '15th & Euclid St  NW',\n",
              " 36: '15th & F St NE',\n",
              " 37: '15th & K St NW',\n",
              " 38: '15th & L St NW',\n",
              " 39: '15th & N Scott St',\n",
              " 40: '15th & P St NW',\n",
              " 41: '15th St & Massachusetts Ave SE',\n",
              " 42: '16th & Harvard St NW',\n",
              " 43: '16th & Irving St NW',\n",
              " 44: '16th & R St NW',\n",
              " 45: '17th & Corcoran St NW',\n",
              " 46: '17th & G St NW',\n",
              " 47: '17th & K St NW',\n",
              " 48: '17th & K St NW / Farragut Square',\n",
              " 49: '17th & Rhode Island Ave NW',\n",
              " 50: '17th St & Massachusetts Ave NW',\n",
              " 51: '18th & Eads St.',\n",
              " 52: '18th & M St NW',\n",
              " 53: '18th & R St NW',\n",
              " 54: '18th St & Pennsylvania Ave NW',\n",
              " 55: '18th St & Rhode Island Ave NE',\n",
              " 56: '18th St & Wyoming Ave NW',\n",
              " 57: '19th & E Street NW',\n",
              " 58: '19th & East Capitol St SE',\n",
              " 59: '19th & G St NW',\n",
              " 60: '19th & K St NW',\n",
              " 61: '19th & L St NW',\n",
              " 62: '19th St & Constitution Ave NW',\n",
              " 63: '19th St & Pennsylvania Ave NW',\n",
              " 64: '1st & H St NW',\n",
              " 65: '1st & K St SE',\n",
              " 66: '1st & M St NE',\n",
              " 67: '1st & N St  SE',\n",
              " 68: '1st & Rhode Island Ave NW',\n",
              " 69: '1st & Washington Hospital Center NW',\n",
              " 70: '20th & Bell St',\n",
              " 71: '20th & Crystal Dr',\n",
              " 72: '20th & E St NW',\n",
              " 73: '20th & L St NW',\n",
              " 74: '20th & O St NW / Dupont South',\n",
              " 75: '20th St & Florida Ave NW',\n",
              " 76: '20th St & Virginia Ave NW',\n",
              " 77: '21st & I St NW',\n",
              " 78: '21st & M St NW',\n",
              " 79: '21st St & Constitution Ave NW',\n",
              " 80: '21st St & Pennsylvania Ave NW',\n",
              " 81: '21st St N & N Pierce St',\n",
              " 82: '22nd & I St NW / Foggy Bottom',\n",
              " 83: '23rd & Crystal Dr',\n",
              " 84: '23rd & E St NW ',\n",
              " 85: '23rd & Eads St',\n",
              " 86: '24th & N St NW',\n",
              " 87: '25th St & Pennsylvania Ave NW',\n",
              " 88: '26th & S Clark St',\n",
              " 89: '27th & Crystal Dr',\n",
              " 90: '28th St S & S Meade St',\n",
              " 91: '2nd & G St NE',\n",
              " 92: '3000 Connecticut Ave NW / National Zoo',\n",
              " 93: '31st & Woodrow St S',\n",
              " 94: '34th & Water St NW',\n",
              " 95: '34th St & Minnesota Ave SE',\n",
              " 96: '34th St & Wisconsin Ave NW',\n",
              " 97: '36th & Calvert St NW / Glover Park',\n",
              " 98: '37th & O St NW / Georgetown University',\n",
              " 99: '39th & Calvert St NW / Stoddert',\n",
              " 100: '39th & Veazey St NW',\n",
              " 101: '3rd & D St SE',\n",
              " 102: '3rd & Elm St NW',\n",
              " 103: '3rd & G St SE',\n",
              " 104: '3rd & H St NE',\n",
              " 105: '3rd & H St NW',\n",
              " 106: '3rd & Tingey St SE',\n",
              " 107: '3rd St & Pennsylvania Ave SE',\n",
              " 108: '47th & Elm St',\n",
              " 109: '4th & D St NW / Judiciary Square',\n",
              " 110: '4th & E St SW',\n",
              " 111: '4th & East Capitol St NE',\n",
              " 112: '4th & M St SW',\n",
              " 113: '4th & W St NE',\n",
              " 114: '5th & F St NW',\n",
              " 115: '5th & K St NW',\n",
              " 116: '5th & Kennedy St NW',\n",
              " 117: '5th St & Massachusetts Ave NW',\n",
              " 118: '6th & H St NE',\n",
              " 119: '6th & S Ball St',\n",
              " 120: '6th & Water St SW / SW Waterfront',\n",
              " 121: '6th St & Indiana Ave NW',\n",
              " 122: '7th & F St NW / National Portrait Gallery',\n",
              " 123: '7th & R St NW / Shaw Library',\n",
              " 124: '7th & T St NW',\n",
              " 125: '8th & D St NW',\n",
              " 126: '8th & East Capitol St NE',\n",
              " 127: '8th & Eye St SE / Barracks Row',\n",
              " 128: '8th & F St NE',\n",
              " 129: '8th & H St NW',\n",
              " 130: '8th & O St NW',\n",
              " 131: '9th & Upshur St NW',\n",
              " 132: 'Adams Mill & Columbia Rd NW',\n",
              " 133: 'Alabama & MLK Ave SE',\n",
              " 134: 'Anacostia Ave & Benning Rd NE / River Terrace ',\n",
              " 135: 'Anacostia Library',\n",
              " 136: 'Anacostia Metro',\n",
              " 137: 'Arlington Blvd & Fillmore St',\n",
              " 138: 'Arlington Blvd & N Queen St',\n",
              " 139: 'Arlington Blvd & S George Mason Dr/NFATC',\n",
              " 140: 'Army Navy Dr & S Nash St',\n",
              " 141: 'Aurora Hills Community Ctr/18th & Hayes St',\n",
              " 142: 'Ballenger Ave & Dulaney St',\n",
              " 143: 'Ballston Metro / N Stuart & 9th St N',\n",
              " 144: 'Barton St & 10th St N',\n",
              " 145: 'Battery Ln & Trolley Trail',\n",
              " 146: 'Benning Branch Library',\n",
              " 147: 'Benning Rd & East Capitol St NE / Benning Rd Metro',\n",
              " 148: 'Bethesda Ave & Arlington Rd',\n",
              " 149: 'Bethesda Metro',\n",
              " 150: 'Bladensburg Rd & Benning Rd NE',\n",
              " 151: 'Braddock Rd Metro',\n",
              " 152: 'Branch & Pennsylvania Ave SE',\n",
              " 153: 'Broschart & Blackwell Rd',\n",
              " 154: 'C & O Canal & Wisconsin Ave NW',\n",
              " 155: 'California St & Florida Ave NW',\n",
              " 156: 'Calvert & Biltmore St NW',\n",
              " 157: 'Calvert St & Woodley Pl NW',\n",
              " 158: 'Carroll & Ethan Allen Ave',\n",
              " 159: 'Carroll & Westmoreland Ave',\n",
              " 160: 'Central Library / N Quincy St & 10th St N',\n",
              " 161: 'Clarendon Blvd & N Fillmore St',\n",
              " 162: 'Clarendon Blvd & Pierce St',\n",
              " 163: 'Clarendon Metro / Wilson Blvd & N Highland St',\n",
              " 164: 'Columbia Pike & S Courthouse Rd',\n",
              " 165: 'Columbia Pike & S Dinwiddie St / Arlington Mill Community Center',\n",
              " 166: 'Columbia Pike & S Orme St',\n",
              " 167: 'Columbia Pike & S Walter Reed Dr',\n",
              " 168: 'Columbia Rd & Belmont St NW',\n",
              " 169: 'Columbia Rd & Georgia Ave NW',\n",
              " 170: 'Columbus Circle / Union Station',\n",
              " 171: 'Commerce St & Fayette St',\n",
              " 172: 'Congress Heights Metro',\n",
              " 173: 'Connecticut & Nebraska Ave NW',\n",
              " 174: 'Connecticut Ave & Chevy Chase Lake Dr',\n",
              " 175: 'Connecticut Ave & Newark St NW / Cleveland Park',\n",
              " 176: 'Connecticut Ave & Tilden St NW',\n",
              " 177: 'Constitution Ave & 2nd St NW/DOL',\n",
              " 178: 'Convention Center / 7th & M St NW',\n",
              " 179: 'Cordell & Norfolk Ave',\n",
              " 180: 'Court House Metro / 15th & N Uhle St ',\n",
              " 181: 'Crabbs Branch Way & Calhoun Pl',\n",
              " 182: 'Crabbs Branch Way & Redland Rd',\n",
              " 183: 'Crystal City Metro / 18th & Bell St',\n",
              " 184: 'D St & Maryland Ave NE',\n",
              " 185: 'Deanwood Rec Center',\n",
              " 186: 'Duke St & John Carlyle St',\n",
              " 187: 'E Montgomery Ave & Maryland Ave',\n",
              " 188: 'East West Hwy & Blair Mill Rd',\n",
              " 189: 'Eastern Market / 7th & North Carolina Ave SE',\n",
              " 190: 'Eastern Market Metro / Pennsylvania Ave & 7th St SE',\n",
              " 191: 'Eckington Pl & Q St NE',\n",
              " 192: 'Eisenhower Ave & Mill Race Ln',\n",
              " 193: 'Fairfax Dr & Kenmore St',\n",
              " 194: 'Fairfax Dr & Wilson Blvd',\n",
              " 195: 'Fairfax Village',\n",
              " 196: 'Fallsgrove Blvd & Fallsgrove Dr',\n",
              " 197: 'Fallsgrove Dr & W Montgomery Ave',\n",
              " 198: 'Fenton St & Ellsworth Dr ',\n",
              " 199: 'Fenton St & Gist Ave',\n",
              " 200: 'Fenton St & New York Ave ',\n",
              " 201: 'Fessenden St & Wisconsin Ave NW',\n",
              " 202: 'Fleet St & Ritchie Pkwy',\n",
              " 203: 'Florida Ave & R St NW',\n",
              " 204: 'Fort Totten Metro',\n",
              " 205: 'Frederick Ave & Horners Ln',\n",
              " 206: 'Friendship Blvd & Willard Ave',\n",
              " 207: 'Friendship Hts Metro/Wisconsin Ave & Wisconsin Cir',\n",
              " 208: 'Gallaudet / 8th St & Florida Ave NE',\n",
              " 209: 'Garland Ave & Walden Rd',\n",
              " 210: 'George Mason Dr & Wilson Blvd',\n",
              " 211: 'Georgetown Harbor / 30th St NW',\n",
              " 212: 'Georgia & Missouri Ave NW',\n",
              " 213: 'Georgia & New Hampshire Ave NW',\n",
              " 214: 'Georgia Ave & Emerson St NW',\n",
              " 215: 'Georgia Ave & Spring St',\n",
              " 216: 'Georgia Ave and Fairmont St NW',\n",
              " 217: 'Glebe Rd & 11th St N',\n",
              " 218: 'Good Hope & Naylor Rd SE',\n",
              " 219: 'Good Hope Rd & 14th St SE',\n",
              " 220: 'Good Hope Rd & MLK Ave SE',\n",
              " 221: 'Hains Point/Buckeye & Ohio Dr SW',\n",
              " 222: 'Hamlin & 7th St NE',\n",
              " 223: 'Harvard St & Adams Mill Rd NW',\n",
              " 224: 'Henry St & Pendleton St',\n",
              " 225: \"Independence Ave & L'Enfant Plaza SW/DOE\",\n",
              " 226: 'Iwo Jima Memorial/N Meade & 14th St N',\n",
              " 227: 'Jefferson Dr & 14th St SW',\n",
              " 228: 'Jefferson Memorial',\n",
              " 229: 'John McCormack Dr & Michigan Ave NE',\n",
              " 230: 'Kennedy Center',\n",
              " 231: 'Key Blvd & N Quinn St',\n",
              " 232: 'Key West Ave & Siesta Key Way',\n",
              " 233: 'King Farm Blvd & Piccard Dr',\n",
              " 234: 'King Farm Blvd & Pleasant Dr',\n",
              " 235: 'King St & Patrick St',\n",
              " 236: 'King St Metro North / Cameron St',\n",
              " 237: 'King St Metro South',\n",
              " 238: \"L'Enfant Plaza / 7th & C St SW\",\n",
              " 239: 'Lamont & Mt Pleasant NW',\n",
              " 240: 'Lee Hwy & N Adams St',\n",
              " 241: 'Lee Hwy & N Cleveland St',\n",
              " 242: 'Lee Hwy & N Kirkwood Rd',\n",
              " 243: 'Lee Hwy & N Nelson St',\n",
              " 244: 'Lee Hwy & N Scott St',\n",
              " 245: 'Lee Hwy & N Woodstock St',\n",
              " 246: 'Lincoln Memorial',\n",
              " 247: 'Lincoln Park / 13th & East Capitol St NE ',\n",
              " 248: 'Long Bridge Park/Long Bridge Dr & 6th St S',\n",
              " 249: 'Lynn & 19th St North',\n",
              " 250: 'M St & Delaware Ave NE',\n",
              " 251: 'M St & New Jersey Ave SE',\n",
              " 252: 'M St & Pennsylvania Ave NW',\n",
              " 253: 'MLK Library/9th & G St NW',\n",
              " 254: 'Madison & N Henry St',\n",
              " 255: 'Maple & Ritchie Ave',\n",
              " 256: 'Market Square / King St & Royal St',\n",
              " 257: 'Maryland & Independence Ave SW',\n",
              " 258: 'Maryland Ave & E St NE',\n",
              " 259: 'Massachusetts Ave & Dupont Circle NW',\n",
              " 260: 'McKinley St & Connecticut Ave NW',\n",
              " 261: 'Medical Center Dr & Key West Ave',\n",
              " 262: 'Medical Center Metro ',\n",
              " 263: 'Metro Center / 12th & G St NW',\n",
              " 264: 'Minnesota Ave Metro/DOES',\n",
              " 265: 'Monroe Ave & Leslie Ave',\n",
              " 266: 'Monroe St & Monroe Pl',\n",
              " 267: 'Montgomery & East Ln',\n",
              " 268: 'Montgomery Ave & Waverly St ',\n",
              " 269: 'Montgomery College/W Campus Dr & Mannakee St',\n",
              " 270: 'Mount Vernon Ave & E Del Ray Ave',\n",
              " 271: 'Mount Vernon Ave & E Nelson Ave',\n",
              " 272: 'Mount Vernon Ave & Kennedy St',\n",
              " 273: 'N Pershing Dr & Wayne St',\n",
              " 274: 'N Quincy St & Glebe Rd',\n",
              " 275: 'N Quincy St & Wilson Blvd',\n",
              " 276: 'N Randolph St & Fairfax Dr',\n",
              " 277: 'N Rhodes & 16th St N',\n",
              " 278: 'N Veitch  & 20th St N',\n",
              " 279: 'N Veitch & Key Blvd',\n",
              " 280: 'Nannie Helen Burroughs & Minnesota Ave NE',\n",
              " 281: 'Nannie Helen Burroughs Ave & 49th St NE',\n",
              " 282: 'Neal St & Trinidad Ave NE',\n",
              " 283: 'Needwood Rd & Eagles Head Ct',\n",
              " 284: 'New Hampshire Ave & 24th St NW',\n",
              " 285: 'New Hampshire Ave & T St NW',\n",
              " 286: 'New Jersey Ave & N St NW/Dunbar HS',\n",
              " 287: 'New Jersey Ave & R St NW',\n",
              " 288: 'New York Ave & 15th St NW',\n",
              " 289: 'New York Ave & Hecht Ave NE',\n",
              " 290: 'Norfolk & Rugby Ave',\n",
              " 291: 'Norfolk Ave & Fairmont St',\n",
              " 292: 'North Capitol St & F St NW',\n",
              " 293: 'North Capitol St & G Pl NE',\n",
              " 294: 'Offutt Ln & Chevy Chase Dr',\n",
              " 295: 'Ohio Dr & West Basin Dr SW / MLK & FDR Memorials',\n",
              " 296: 'Oklahoma Ave & D St NE',\n",
              " 297: 'Old Georgetown Rd & Southwick St',\n",
              " 298: 'Park Rd & Holmead Pl NW',\n",
              " 299: 'Pennsylvania & Minnesota Ave SE',\n",
              " 300: 'Pentagon City Metro / 12th & S Hayes St',\n",
              " 301: 'Pershing & N George Mason Dr',\n",
              " 302: 'Philadelphia & Maple Ave',\n",
              " 303: 'Piccard & W Gude Dr',\n",
              " 304: 'Pleasant St & MLK Ave SE',\n",
              " 305: 'Potomac & Pennsylvania Ave SE',\n",
              " 306: 'Potomac Ave & 35th St S',\n",
              " 307: 'Potomac Ave & 8th St SE',\n",
              " 308: 'Potomac Greens Dr & Slaters Ln',\n",
              " 309: 'Prince St & Union St',\n",
              " 310: 'Randle Circle & Minnesota Ave SE',\n",
              " 311: 'Rhode Island Ave & V St NE',\n",
              " 312: 'Rhode Island Ave Metro',\n",
              " 313: 'Ripley & Bonifant St',\n",
              " 314: 'River Rd & Landy Ln',\n",
              " 315: 'Rockville Metro East',\n",
              " 316: 'Rockville Metro West',\n",
              " 317: 'Rolfe St & 9th St S',\n",
              " 318: 'Rosslyn Metro / Wilson Blvd & Ft Myer Dr',\n",
              " 319: 'S Arlington Mill Dr & Campbell Ave',\n",
              " 320: 'S Four Mile Run & Walter Reed Dr',\n",
              " 321: 'S Four Mile Run Dr & S Shirlington Rd',\n",
              " 322: 'S George Mason Dr & 13th St S',\n",
              " 323: 'S George Mason Dr & Four Mile Run',\n",
              " 324: 'S Glebe & Potomac Ave',\n",
              " 325: 'S Joyce & 16th St S',\n",
              " 326: 'S Joyce & Army Navy Dr',\n",
              " 327: 'S Kenmore & 24th St S',\n",
              " 328: 'S Oakland St & Columbia Pike',\n",
              " 329: 'S Stafford & 34th St S',\n",
              " 330: 'S Troy St & 26th St S',\n",
              " 331: 'S Walter Reed Dr & 8th St S',\n",
              " 332: 'Saint Asaph & Madison St',\n",
              " 333: 'Saint Asaph St & Pendleton  St',\n",
              " 334: 'Shady Grove Hospital',\n",
              " 335: 'Shady Grove Metro West',\n",
              " 336: 'Shirlington Transit Center / S Quincy & Randolph St',\n",
              " 337: 'Silver Spring Metro/Colesville Rd & Wayne Ave',\n",
              " 338: 'Smithsonian / Jefferson Dr & 12th St SW',\n",
              " 339: 'Spring St & Second Ave',\n",
              " 340: 'TJ Cmty Ctr / 2nd St & S Old Glebe Rd',\n",
              " 341: 'Taft St & E Gude Dr',\n",
              " 342: 'Takoma Metro',\n",
              " 343: 'Tenleytown / Wisconsin Ave & Albemarle St NW',\n",
              " 344: 'Thomas Circle',\n",
              " 345: 'Traville Gateway Dr & Gudelsky Dr',\n",
              " 346: 'US Dept of State / Virginia Ave & 21st St NW',\n",
              " 347: 'USDA / 12th & Independence Ave SW',\n",
              " 348: 'Union Market/6th St & Neal Pl NE',\n",
              " 349: 'Utah St & 11th St N ',\n",
              " 350: 'Van Ness Metro / UDC',\n",
              " 351: 'Veterans Pl & Pershing Dr ',\n",
              " 352: 'Virginia Square Metro / N Monroe St & 9th St N',\n",
              " 353: 'Walter Reed Community Center / Walter Reed Dr & 16th St S',\n",
              " 354: 'Ward Circle / American University',\n",
              " 355: 'Washington & Independence Ave SW/HHS',\n",
              " 356: 'Washington Adventist U / Flower Ave & Division St',\n",
              " 357: 'Washington Blvd & 10th St N',\n",
              " 358: 'Washington Blvd & 7th St N',\n",
              " 359: 'Washington Blvd & N Frederick St',\n",
              " 360: 'Washington Blvd & Walter Reed Dr ',\n",
              " 361: 'Wilson Blvd & Franklin Rd',\n",
              " 362: 'Wilson Blvd & N Edgewood St',\n",
              " 363: 'Wilson Blvd & N Illinois St ',\n",
              " 364: 'Wilson Blvd & N Oakland St',\n",
              " 365: 'Wilson Blvd & N Uhle St',\n",
              " 366: 'Wisconsin Ave & Ingomar St NW',\n",
              " 367: 'Wisconsin Ave & Newark St NW',\n",
              " 368: 'Wisconsin Ave & O St NW',\n",
              " 369: 'Yuma St & Tenley Circle NW'}"
            ]
          },
          "metadata": {},
          "execution_count": 18
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df['End station'] = address_labels"
      ],
      "metadata": {
        "id": "Cync5Hd4AiBN"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "gle = LabelEncoder()\n",
        "address_labels = gle.fit_transform(df['Start station'])\n",
        "address_mappings = {index: label for index, label in\n",
        "                  enumerate(gle.classes_)}\n",
        "address_mappings"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "euA8tSHmAnWo",
        "outputId": "b5753f3a-0db3-4592-a4bd-eb35563beab2"
      },
      "execution_count": 19,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{0: '10th & E St NW',\n",
              " 1: '10th & Florida Ave NW',\n",
              " 2: '10th & K St NW',\n",
              " 3: '10th & Monroe St NE',\n",
              " 4: '10th & U St NW',\n",
              " 5: '10th St & Constitution Ave NW',\n",
              " 6: '11th & F St NW',\n",
              " 7: '11th & H St NE',\n",
              " 8: '11th & Kenyon St NW',\n",
              " 9: '11th & M St NW',\n",
              " 10: '11th & S St NW',\n",
              " 11: '12th & Army Navy Dr',\n",
              " 12: '12th & Irving St NE',\n",
              " 13: '12th & L St NW',\n",
              " 14: '12th & Newton St NE',\n",
              " 15: '12th & U St NW',\n",
              " 16: '13th & D St NE',\n",
              " 17: '13th & H St NE',\n",
              " 18: '13th St & Eastern Ave',\n",
              " 19: '13th St & New York Ave NW',\n",
              " 20: '14th & Belmont St NW',\n",
              " 21: '14th & D St NW / Ronald Reagan Building',\n",
              " 22: '14th & D St SE',\n",
              " 23: '14th & G St NW',\n",
              " 24: '14th & Harvard St NW',\n",
              " 25: '14th & R St NW',\n",
              " 26: '14th & Rhode Island Ave NW',\n",
              " 27: '14th & Upshur St NW',\n",
              " 28: '14th & V St NW',\n",
              " 29: '14th St & Colorado Ave NW',\n",
              " 30: '14th St & New York Ave NW',\n",
              " 31: '14th St & Spring Rd NW',\n",
              " 32: '14th St Heights / 14th & Crittenden St NW',\n",
              " 33: '15th & Crystal Dr',\n",
              " 34: '15th & East Capitol St NE',\n",
              " 35: '15th & Euclid St  NW',\n",
              " 36: '15th & F St NE',\n",
              " 37: '15th & K St NW',\n",
              " 38: '15th & L St NW',\n",
              " 39: '15th & N Scott St',\n",
              " 40: '15th & P St NW',\n",
              " 41: '15th St & Massachusetts Ave SE',\n",
              " 42: '16th & Harvard St NW',\n",
              " 43: '16th & Irving St NW',\n",
              " 44: '16th & R St NW',\n",
              " 45: '17th & Corcoran St NW',\n",
              " 46: '17th & G St NW',\n",
              " 47: '17th & K St NW',\n",
              " 48: '17th & K St NW / Farragut Square',\n",
              " 49: '17th & Rhode Island Ave NW',\n",
              " 50: '17th St & Massachusetts Ave NW',\n",
              " 51: '18th & Eads St.',\n",
              " 52: '18th & M St NW',\n",
              " 53: '18th & R St NW',\n",
              " 54: '18th St & Pennsylvania Ave NW',\n",
              " 55: '18th St & Rhode Island Ave NE',\n",
              " 56: '18th St & Wyoming Ave NW',\n",
              " 57: '19th & E Street NW',\n",
              " 58: '19th & East Capitol St SE',\n",
              " 59: '19th & G St NW',\n",
              " 60: '19th & K St NW',\n",
              " 61: '19th & L St NW',\n",
              " 62: '19th St & Constitution Ave NW',\n",
              " 63: '19th St & Pennsylvania Ave NW',\n",
              " 64: '1st & H St NW',\n",
              " 65: '1st & K St SE',\n",
              " 66: '1st & M St NE',\n",
              " 67: '1st & N St  SE',\n",
              " 68: '1st & Rhode Island Ave NW',\n",
              " 69: '1st & Washington Hospital Center NW',\n",
              " 70: '20th & Bell St',\n",
              " 71: '20th & Crystal Dr',\n",
              " 72: '20th & E St NW',\n",
              " 73: '20th & L St NW',\n",
              " 74: '20th & O St NW / Dupont South',\n",
              " 75: '20th St & Florida Ave NW',\n",
              " 76: '20th St & Virginia Ave NW',\n",
              " 77: '21st & I St NW',\n",
              " 78: '21st & M St NW',\n",
              " 79: '21st St & Constitution Ave NW',\n",
              " 80: '21st St & Pennsylvania Ave NW',\n",
              " 81: '21st St N & N Pierce St',\n",
              " 82: '22nd & I St NW / Foggy Bottom',\n",
              " 83: '23rd & Crystal Dr',\n",
              " 84: '23rd & E St NW ',\n",
              " 85: '23rd & Eads St',\n",
              " 86: '24th & N St NW',\n",
              " 87: '25th St & Pennsylvania Ave NW',\n",
              " 88: '26th & S Clark St',\n",
              " 89: '27th & Crystal Dr',\n",
              " 90: '28th St S & S Meade St',\n",
              " 91: '2nd & G St NE',\n",
              " 92: '3000 Connecticut Ave NW / National Zoo',\n",
              " 93: '31st & Woodrow St S',\n",
              " 94: '34th & Water St NW',\n",
              " 95: '34th St & Minnesota Ave SE',\n",
              " 96: '34th St & Wisconsin Ave NW',\n",
              " 97: '36th & Calvert St NW / Glover Park',\n",
              " 98: '37th & O St NW / Georgetown University',\n",
              " 99: '39th & Calvert St NW / Stoddert',\n",
              " 100: '39th & Veazey St NW',\n",
              " 101: '3rd & D St SE',\n",
              " 102: '3rd & Elm St NW',\n",
              " 103: '3rd & G St SE',\n",
              " 104: '3rd & H St NE',\n",
              " 105: '3rd & H St NW',\n",
              " 106: '3rd & Tingey St SE',\n",
              " 107: '3rd St & Pennsylvania Ave SE',\n",
              " 108: '47th & Elm St',\n",
              " 109: '4th & D St NW / Judiciary Square',\n",
              " 110: '4th & E St SW',\n",
              " 111: '4th & East Capitol St NE',\n",
              " 112: '4th & M St SW',\n",
              " 113: '4th & W St NE',\n",
              " 114: '5th & F St NW',\n",
              " 115: '5th & K St NW',\n",
              " 116: '5th & Kennedy St NW',\n",
              " 117: '5th St & Massachusetts Ave NW',\n",
              " 118: '6th & H St NE',\n",
              " 119: '6th & S Ball St',\n",
              " 120: '6th & Water St SW / SW Waterfront',\n",
              " 121: '6th St & Indiana Ave NW',\n",
              " 122: '7th & F St NW / National Portrait Gallery',\n",
              " 123: '7th & R St NW / Shaw Library',\n",
              " 124: '7th & T St NW',\n",
              " 125: '8th & D St NW',\n",
              " 126: '8th & East Capitol St NE',\n",
              " 127: '8th & Eye St SE / Barracks Row',\n",
              " 128: '8th & F St NE',\n",
              " 129: '8th & H St NW',\n",
              " 130: '8th & O St NW',\n",
              " 131: '9th & Upshur St NW',\n",
              " 132: 'Adams Mill & Columbia Rd NW',\n",
              " 133: 'Alabama & MLK Ave SE',\n",
              " 134: 'Anacostia Ave & Benning Rd NE / River Terrace ',\n",
              " 135: 'Anacostia Library',\n",
              " 136: 'Anacostia Metro',\n",
              " 137: 'Arlington Blvd & Fillmore St',\n",
              " 138: 'Arlington Blvd & N Queen St',\n",
              " 139: 'Arlington Blvd & S George Mason Dr/NFATC',\n",
              " 140: 'Army Navy Dr & S Nash St',\n",
              " 141: 'Aurora Hills Community Ctr/18th & Hayes St',\n",
              " 142: 'Ballenger Ave & Dulaney St',\n",
              " 143: 'Ballston Metro / N Stuart & 9th St N',\n",
              " 144: 'Barton St & 10th St N',\n",
              " 145: 'Battery Ln & Trolley Trail',\n",
              " 146: 'Benning Branch Library',\n",
              " 147: 'Benning Rd & East Capitol St NE / Benning Rd Metro',\n",
              " 148: 'Bethesda Ave & Arlington Rd',\n",
              " 149: 'Bethesda Metro',\n",
              " 150: 'Bladensburg Rd & Benning Rd NE',\n",
              " 151: 'Braddock Rd Metro',\n",
              " 152: 'Branch & Pennsylvania Ave SE',\n",
              " 153: 'Broschart & Blackwell Rd',\n",
              " 154: 'C & O Canal & Wisconsin Ave NW',\n",
              " 155: 'California St & Florida Ave NW',\n",
              " 156: 'Calvert & Biltmore St NW',\n",
              " 157: 'Calvert St & Woodley Pl NW',\n",
              " 158: 'Carroll & Ethan Allen Ave',\n",
              " 159: 'Carroll & Westmoreland Ave',\n",
              " 160: 'Central Library / N Quincy St & 10th St N',\n",
              " 161: 'Clarendon Blvd & N Fillmore St',\n",
              " 162: 'Clarendon Blvd & Pierce St',\n",
              " 163: 'Clarendon Metro / Wilson Blvd & N Highland St',\n",
              " 164: 'Columbia Pike & S Courthouse Rd',\n",
              " 165: 'Columbia Pike & S Dinwiddie St / Arlington Mill Community Center',\n",
              " 166: 'Columbia Pike & S Orme St',\n",
              " 167: 'Columbia Pike & S Walter Reed Dr',\n",
              " 168: 'Columbia Rd & Belmont St NW',\n",
              " 169: 'Columbia Rd & Georgia Ave NW',\n",
              " 170: 'Columbus Circle / Union Station',\n",
              " 171: 'Commerce St & Fayette St',\n",
              " 172: 'Congress Heights Metro',\n",
              " 173: 'Connecticut & Nebraska Ave NW',\n",
              " 174: 'Connecticut Ave & Chevy Chase Lake Dr',\n",
              " 175: 'Connecticut Ave & Newark St NW / Cleveland Park',\n",
              " 176: 'Connecticut Ave & Tilden St NW',\n",
              " 177: 'Constitution Ave & 2nd St NW/DOL',\n",
              " 178: 'Convention Center / 7th & M St NW',\n",
              " 179: 'Cordell & Norfolk Ave',\n",
              " 180: 'Court House Metro / 15th & N Uhle St ',\n",
              " 181: 'Crabbs Branch Way & Calhoun Pl',\n",
              " 182: 'Crabbs Branch Way & Redland Rd',\n",
              " 183: 'Crystal City Metro / 18th & Bell St',\n",
              " 184: 'D St & Maryland Ave NE',\n",
              " 185: 'Deanwood Rec Center',\n",
              " 186: 'Duke St & John Carlyle St',\n",
              " 187: 'E Montgomery Ave & Maryland Ave',\n",
              " 188: 'East West Hwy & Blair Mill Rd',\n",
              " 189: 'Eastern Market / 7th & North Carolina Ave SE',\n",
              " 190: 'Eastern Market Metro / Pennsylvania Ave & 7th St SE',\n",
              " 191: 'Eckington Pl & Q St NE',\n",
              " 192: 'Eisenhower Ave & Mill Race Ln',\n",
              " 193: 'Fairfax Dr & Kenmore St',\n",
              " 194: 'Fairfax Dr & Wilson Blvd',\n",
              " 195: 'Fairfax Village',\n",
              " 196: 'Fallsgrove Blvd & Fallsgrove Dr',\n",
              " 197: 'Fallsgrove Dr & W Montgomery Ave',\n",
              " 198: 'Fenton St & Ellsworth Dr ',\n",
              " 199: 'Fenton St & Gist Ave',\n",
              " 200: 'Fenton St & New York Ave ',\n",
              " 201: 'Fessenden St & Wisconsin Ave NW',\n",
              " 202: 'Fleet St & Ritchie Pkwy',\n",
              " 203: 'Florida Ave & R St NW',\n",
              " 204: 'Fort Totten Metro',\n",
              " 205: 'Frederick Ave & Horners Ln',\n",
              " 206: 'Friendship Blvd & Willard Ave',\n",
              " 207: 'Friendship Hts Metro/Wisconsin Ave & Wisconsin Cir',\n",
              " 208: 'Gallaudet / 8th St & Florida Ave NE',\n",
              " 209: 'Garland Ave & Walden Rd',\n",
              " 210: 'George Mason Dr & Wilson Blvd',\n",
              " 211: 'Georgetown Harbor / 30th St NW',\n",
              " 212: 'Georgia & Missouri Ave NW',\n",
              " 213: 'Georgia & New Hampshire Ave NW',\n",
              " 214: 'Georgia Ave & Emerson St NW',\n",
              " 215: 'Georgia Ave & Spring St',\n",
              " 216: 'Georgia Ave and Fairmont St NW',\n",
              " 217: 'Glebe Rd & 11th St N',\n",
              " 218: 'Good Hope & Naylor Rd SE',\n",
              " 219: 'Good Hope Rd & 14th St SE',\n",
              " 220: 'Good Hope Rd & MLK Ave SE',\n",
              " 221: 'Hains Point/Buckeye & Ohio Dr SW',\n",
              " 222: 'Hamlin & 7th St NE',\n",
              " 223: 'Harvard St & Adams Mill Rd NW',\n",
              " 224: 'Henry St & Pendleton St',\n",
              " 225: \"Independence Ave & L'Enfant Plaza SW/DOE\",\n",
              " 226: 'Iwo Jima Memorial/N Meade & 14th St N',\n",
              " 227: 'Jefferson Dr & 14th St SW',\n",
              " 228: 'Jefferson Memorial',\n",
              " 229: 'John McCormack Dr & Michigan Ave NE',\n",
              " 230: 'Kennedy Center',\n",
              " 231: 'Key Blvd & N Quinn St',\n",
              " 232: 'Key West Ave & Siesta Key Way',\n",
              " 233: 'King Farm Blvd & Piccard Dr',\n",
              " 234: 'King Farm Blvd & Pleasant Dr',\n",
              " 235: 'King St & Patrick St',\n",
              " 236: 'King St Metro North / Cameron St',\n",
              " 237: 'King St Metro South',\n",
              " 238: \"L'Enfant Plaza / 7th & C St SW\",\n",
              " 239: 'Lamont & Mt Pleasant NW',\n",
              " 240: 'Lee Hwy & N Adams St',\n",
              " 241: 'Lee Hwy & N Cleveland St',\n",
              " 242: 'Lee Hwy & N Kirkwood Rd',\n",
              " 243: 'Lee Hwy & N Nelson St',\n",
              " 244: 'Lee Hwy & N Scott St',\n",
              " 245: 'Lee Hwy & N Woodstock St',\n",
              " 246: 'Lincoln Memorial',\n",
              " 247: 'Lincoln Park / 13th & East Capitol St NE ',\n",
              " 248: 'Long Bridge Park/Long Bridge Dr & 6th St S',\n",
              " 249: 'Lynn & 19th St North',\n",
              " 250: 'M St & Delaware Ave NE',\n",
              " 251: 'M St & New Jersey Ave SE',\n",
              " 252: 'M St & Pennsylvania Ave NW',\n",
              " 253: 'MLK Library/9th & G St NW',\n",
              " 254: 'Madison & N Henry St',\n",
              " 255: 'Maple & Ritchie Ave',\n",
              " 256: 'Market Square / King St & Royal St',\n",
              " 257: 'Maryland & Independence Ave SW',\n",
              " 258: 'Maryland Ave & E St NE',\n",
              " 259: 'Massachusetts Ave & Dupont Circle NW',\n",
              " 260: 'McKinley St & Connecticut Ave NW',\n",
              " 261: 'Medical Center Dr & Key West Ave',\n",
              " 262: 'Medical Center Metro ',\n",
              " 263: 'Metro Center / 12th & G St NW',\n",
              " 264: 'Minnesota Ave Metro/DOES',\n",
              " 265: 'Monroe Ave & Leslie Ave',\n",
              " 266: 'Monroe St & Monroe Pl',\n",
              " 267: 'Montgomery & East Ln',\n",
              " 268: 'Montgomery Ave & Waverly St ',\n",
              " 269: 'Montgomery College/W Campus Dr & Mannakee St',\n",
              " 270: 'Mount Vernon Ave & E Del Ray Ave',\n",
              " 271: 'Mount Vernon Ave & E Nelson Ave',\n",
              " 272: 'Mount Vernon Ave & Kennedy St',\n",
              " 273: 'N Pershing Dr & Wayne St',\n",
              " 274: 'N Quincy St & Glebe Rd',\n",
              " 275: 'N Quincy St & Wilson Blvd',\n",
              " 276: 'N Randolph St & Fairfax Dr',\n",
              " 277: 'N Rhodes & 16th St N',\n",
              " 278: 'N Veitch  & 20th St N',\n",
              " 279: 'N Veitch & Key Blvd',\n",
              " 280: 'Nannie Helen Burroughs & Minnesota Ave NE',\n",
              " 281: 'Nannie Helen Burroughs Ave & 49th St NE',\n",
              " 282: 'Neal St & Trinidad Ave NE',\n",
              " 283: 'Needwood Rd & Eagles Head Ct',\n",
              " 284: 'New Hampshire Ave & 24th St NW',\n",
              " 285: 'New Hampshire Ave & T St NW',\n",
              " 286: 'New Jersey Ave & N St NW/Dunbar HS',\n",
              " 287: 'New Jersey Ave & R St NW',\n",
              " 288: 'New York Ave & 15th St NW',\n",
              " 289: 'New York Ave & Hecht Ave NE',\n",
              " 290: 'Norfolk & Rugby Ave',\n",
              " 291: 'Norfolk Ave & Fairmont St',\n",
              " 292: 'North Capitol St & F St NW',\n",
              " 293: 'North Capitol St & G Pl NE',\n",
              " 294: 'Offutt Ln & Chevy Chase Dr',\n",
              " 295: 'Ohio Dr & West Basin Dr SW / MLK & FDR Memorials',\n",
              " 296: 'Oklahoma Ave & D St NE',\n",
              " 297: 'Old Georgetown Rd & Southwick St',\n",
              " 298: 'Park Rd & Holmead Pl NW',\n",
              " 299: 'Pennsylvania & Minnesota Ave SE',\n",
              " 300: 'Pentagon City Metro / 12th & S Hayes St',\n",
              " 301: 'Pershing & N George Mason Dr',\n",
              " 302: 'Philadelphia & Maple Ave',\n",
              " 303: 'Piccard & W Gude Dr',\n",
              " 304: 'Pleasant St & MLK Ave SE',\n",
              " 305: 'Potomac & Pennsylvania Ave SE',\n",
              " 306: 'Potomac Ave & 35th St S',\n",
              " 307: 'Potomac Ave & 8th St SE',\n",
              " 308: 'Potomac Greens Dr & Slaters Ln',\n",
              " 309: 'Prince St & Union St',\n",
              " 310: 'Randle Circle & Minnesota Ave SE',\n",
              " 311: 'Rhode Island Ave & V St NE',\n",
              " 312: 'Rhode Island Ave Metro',\n",
              " 313: 'Ripley & Bonifant St',\n",
              " 314: 'River Rd & Landy Ln',\n",
              " 315: 'Rockville Metro East',\n",
              " 316: 'Rockville Metro West',\n",
              " 317: 'Rolfe St & 9th St S',\n",
              " 318: 'Rosslyn Metro / Wilson Blvd & Ft Myer Dr',\n",
              " 319: 'S Arlington Mill Dr & Campbell Ave',\n",
              " 320: 'S Four Mile Run & Walter Reed Dr',\n",
              " 321: 'S Four Mile Run Dr & S Shirlington Rd',\n",
              " 322: 'S George Mason Dr & 13th St S',\n",
              " 323: 'S George Mason Dr & Four Mile Run',\n",
              " 324: 'S Glebe & Potomac Ave',\n",
              " 325: 'S Joyce & 16th St S',\n",
              " 326: 'S Joyce & Army Navy Dr',\n",
              " 327: 'S Kenmore & 24th St S',\n",
              " 328: 'S Oakland St & Columbia Pike',\n",
              " 329: 'S Stafford & 34th St S',\n",
              " 330: 'S Troy St & 26th St S',\n",
              " 331: 'S Walter Reed Dr & 8th St S',\n",
              " 332: 'Saint Asaph & Madison St',\n",
              " 333: 'Saint Asaph St & Pendleton  St',\n",
              " 334: 'Shady Grove Hospital',\n",
              " 335: 'Shady Grove Metro West',\n",
              " 336: 'Shirlington Transit Center / S Quincy & Randolph St',\n",
              " 337: 'Silver Spring Metro/Colesville Rd & Wayne Ave',\n",
              " 338: 'Smithsonian / Jefferson Dr & 12th St SW',\n",
              " 339: 'Spring St & Second Ave',\n",
              " 340: 'TJ Cmty Ctr / 2nd St & S Old Glebe Rd',\n",
              " 341: 'Taft St & E Gude Dr',\n",
              " 342: 'Takoma Metro',\n",
              " 343: 'Tenleytown / Wisconsin Ave & Albemarle St NW',\n",
              " 344: 'Thomas Circle',\n",
              " 345: 'Traville Gateway Dr & Gudelsky Dr',\n",
              " 346: 'US Dept of State / Virginia Ave & 21st St NW',\n",
              " 347: 'USDA / 12th & Independence Ave SW',\n",
              " 348: 'Union Market/6th St & Neal Pl NE',\n",
              " 349: 'Utah St & 11th St N ',\n",
              " 350: 'Van Ness Metro / UDC',\n",
              " 351: 'Veterans Pl & Pershing Dr ',\n",
              " 352: 'Virginia Square Metro / N Monroe St & 9th St N',\n",
              " 353: 'Walter Reed Community Center / Walter Reed Dr & 16th St S',\n",
              " 354: 'Ward Circle / American University',\n",
              " 355: 'Washington & Independence Ave SW/HHS',\n",
              " 356: 'Washington Adventist U / Flower Ave & Division St',\n",
              " 357: 'Washington Blvd & 10th St N',\n",
              " 358: 'Washington Blvd & 7th St N',\n",
              " 359: 'Washington Blvd & N Frederick St',\n",
              " 360: 'Washington Blvd & Walter Reed Dr ',\n",
              " 361: 'Wilson Blvd & Franklin Rd',\n",
              " 362: 'Wilson Blvd & N Edgewood St',\n",
              " 363: 'Wilson Blvd & N Illinois St ',\n",
              " 364: 'Wilson Blvd & N Oakland St',\n",
              " 365: 'Wilson Blvd & N Uhle St',\n",
              " 366: 'Wisconsin Ave & Ingomar St NW',\n",
              " 367: 'Wisconsin Ave & Newark St NW',\n",
              " 368: 'Wisconsin Ave & O St NW',\n",
              " 369: 'Yuma St & Tenley Circle NW'}"
            ]
          },
          "metadata": {},
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df['Start station'] = address_labels"
      ],
      "metadata": {
        "id": "kRRRU9StAtlj"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 310
        },
        "id": "uePUiCf5A2Nx",
        "outputId": "b8e2121f-0e70-4dd7-a46e-3a906fc4bfd6"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   Duration (ms)       Start date         End date  Start station number  \\\n",
              "0         301295  3/31/2016 23:59    4/1/2016 0:04                 31280   \n",
              "1         557887  3/31/2016 23:59    4/1/2016 0:08                 31275   \n",
              "2         555944  3/31/2016 23:59    4/1/2016 0:08                 31101   \n",
              "3         766916  3/31/2016 23:57    4/1/2016 0:09                 31226   \n",
              "4         139656  3/31/2016 23:57  3/31/2016 23:59                 31011   \n",
              "\n",
              "   Start station  End station number  End station Bike number Member Type  \n",
              "0             10               31506           10      W00022  Registered  \n",
              "1            275               31114          275      W01294  Registered  \n",
              "2             28               31221           28      W01416  Registered  \n",
              "3             95               31214           95      W01090  Registered  \n",
              "4             83               31009           83      W21934  Registered  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-2a43eab5-2c1b-4fa2-9e7c-43ffaf8e908e\" class=\"colab-df-container\">\n",
              "    <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>Duration (ms)</th>\n",
              "      <th>Start date</th>\n",
              "      <th>End date</th>\n",
              "      <th>Start station number</th>\n",
              "      <th>Start station</th>\n",
              "      <th>End station number</th>\n",
              "      <th>End station</th>\n",
              "      <th>Bike number</th>\n",
              "      <th>Member Type</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>301295</td>\n",
              "      <td>3/31/2016 23:59</td>\n",
              "      <td>4/1/2016 0:04</td>\n",
              "      <td>31280</td>\n",
              "      <td>10</td>\n",
              "      <td>31506</td>\n",
              "      <td>10</td>\n",
              "      <td>W00022</td>\n",
              "      <td>Registered</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>557887</td>\n",
              "      <td>3/31/2016 23:59</td>\n",
              "      <td>4/1/2016 0:08</td>\n",
              "      <td>31275</td>\n",
              "      <td>275</td>\n",
              "      <td>31114</td>\n",
              "      <td>275</td>\n",
              "      <td>W01294</td>\n",
              "      <td>Registered</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>555944</td>\n",
              "      <td>3/31/2016 23:59</td>\n",
              "      <td>4/1/2016 0:08</td>\n",
              "      <td>31101</td>\n",
              "      <td>28</td>\n",
              "      <td>31221</td>\n",
              "      <td>28</td>\n",
              "      <td>W01416</td>\n",
              "      <td>Registered</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>766916</td>\n",
              "      <td>3/31/2016 23:57</td>\n",
              "      <td>4/1/2016 0:09</td>\n",
              "      <td>31226</td>\n",
              "      <td>95</td>\n",
              "      <td>31214</td>\n",
              "      <td>95</td>\n",
              "      <td>W01090</td>\n",
              "      <td>Registered</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>139656</td>\n",
              "      <td>3/31/2016 23:57</td>\n",
              "      <td>3/31/2016 23:59</td>\n",
              "      <td>31011</td>\n",
              "      <td>83</td>\n",
              "      <td>31009</td>\n",
              "      <td>83</td>\n",
              "      <td>W21934</td>\n",
              "      <td>Registered</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-2a43eab5-2c1b-4fa2-9e7c-43ffaf8e908e')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-2a43eab5-2c1b-4fa2-9e7c-43ffaf8e908e button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-2a43eab5-2c1b-4fa2-9e7c-43ffaf8e908e');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-061c1e3d-8e00-4677-8cfc-e8ebc485bca2\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-061c1e3d-8e00-4677-8cfc-e8ebc485bca2')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-061c1e3d-8e00-4677-8cfc-e8ebc485bca2 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "df",
              "summary": "{\n  \"name\": \"df\",\n  \"rows\": 44221,\n  \"fields\": [\n    {\n      \"column\": \"Duration (ms)\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 2545898,\n        \"min\": 60025,\n        \"max\": 83136399,\n        \"num_unique_values\": 43684,\n        \"samples\": [\n          1377471,\n          1014916,\n          277218\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Start date\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 5034,\n        \"samples\": [\n          \"3/28/2016 17:26\",\n          \"3/29/2016 19:56\",\n          \"3/27/2016 16:58\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"End date\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 5100,\n        \"samples\": [\n          \"3/28/2016 14:36\",\n          \"3/28/2016 18:22\",\n          \"3/31/2016 10:25\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Start station number\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 203,\n        \"min\": 31000,\n        \"max\": 32053,\n        \"num_unique_values\": 358,\n        \"samples\": [\n          31097,\n          31603,\n          31080\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Start station\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 100,\n        \"min\": 0,\n        \"max\": 357,\n        \"num_unique_values\": 358,\n        \"samples\": [\n          320,\n          66,\n          238\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"End station number\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 201,\n        \"min\": 31000,\n        \"max\": 32053,\n        \"num_unique_values\": 356,\n        \"samples\": [\n          31025,\n          31225,\n          31021\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"End station\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 100,\n        \"min\": 0,\n        \"max\": 357,\n        \"num_unique_values\": 358,\n        \"samples\": [\n          320,\n          66,\n          238\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Bike number\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 2792,\n        \"samples\": [\n          \"W21482\",\n          \"W21342\",\n          \"W01387\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Member Type\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 3,\n        \"samples\": [\n          \"Registered\",\n          \"Casual\",\n          \"Registe\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "gle = LabelEncoder()\n",
        "bike_labels = gle.fit_transform(df['Bike number'])\n",
        "bike_mappings = {index: label for index, label in\n",
        "                  enumerate(gle.classes_)}\n",
        "bike_mappings"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "C1RO37iEA-Zv",
        "outputId": "a9d59b78-0905-434e-ebc6-8b651a48fd33"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{0: 'W00005',\n",
              " 1: 'W00006',\n",
              " 2: 'W00008',\n",
              " 3: 'W00009',\n",
              " 4: 'W00010',\n",
              " 5: 'W00011',\n",
              " 6: 'W00012',\n",
              " 7: 'W00013',\n",
              " 8: 'W00014',\n",
              " 9: 'W00015',\n",
              " 10: 'W00016',\n",
              " 11: 'W00017',\n",
              " 12: 'W00019',\n",
              " 13: 'W00020',\n",
              " 14: 'W00021',\n",
              " 15: 'W00022',\n",
              " 16: 'W00025',\n",
              " 17: 'W00027',\n",
              " 18: 'W00028',\n",
              " 19: 'W00029',\n",
              " 20: 'W00030',\n",
              " 21: 'W00031',\n",
              " 22: 'W00032',\n",
              " 23: 'W00033',\n",
              " 24: 'W00034',\n",
              " 25: 'W00035',\n",
              " 26: 'W00036',\n",
              " 27: 'W00037',\n",
              " 28: 'W00038',\n",
              " 29: 'W00039',\n",
              " 30: 'W00041',\n",
              " 31: 'W00042',\n",
              " 32: 'W00043',\n",
              " 33: 'W00044',\n",
              " 34: 'W00045',\n",
              " 35: 'W00046',\n",
              " 36: 'W00047',\n",
              " 37: 'W00049',\n",
              " 38: 'W00050',\n",
              " 39: 'W00054',\n",
              " 40: 'W00055',\n",
              " 41: 'W00057',\n",
              " 42: 'W00058',\n",
              " 43: 'W00060',\n",
              " 44: 'W00064',\n",
              " 45: 'W00065',\n",
              " 46: 'W00066',\n",
              " 47: 'W00068',\n",
              " 48: 'W00069',\n",
              " 49: 'W00074',\n",
              " 50: 'W00075',\n",
              " 51: 'W00076',\n",
              " 52: 'W00077',\n",
              " 53: 'W00078',\n",
              " 54: 'W00080',\n",
              " 55: 'W00083',\n",
              " 56: 'W00084',\n",
              " 57: 'W00085',\n",
              " 58: 'W00086',\n",
              " 59: 'W00088',\n",
              " 60: 'W00089',\n",
              " 61: 'W00090',\n",
              " 62: 'W00091',\n",
              " 63: 'W00092',\n",
              " 64: 'W00093',\n",
              " 65: 'W00098',\n",
              " 66: 'W00102',\n",
              " 67: 'W00105',\n",
              " 68: 'W00106',\n",
              " 69: 'W00108',\n",
              " 70: 'W00112',\n",
              " 71: 'W00113',\n",
              " 72: 'W00114',\n",
              " 73: 'W00117',\n",
              " 74: 'W00118',\n",
              " 75: 'W00120',\n",
              " 76: 'W00121',\n",
              " 77: 'W00122',\n",
              " 78: 'W00123',\n",
              " 79: 'W00124',\n",
              " 80: 'W00125',\n",
              " 81: 'W00127',\n",
              " 82: 'W00128',\n",
              " 83: 'W00129',\n",
              " 84: 'W00130',\n",
              " 85: 'W00131',\n",
              " 86: 'W00132',\n",
              " 87: 'W00133',\n",
              " 88: 'W00134',\n",
              " 89: 'W00135',\n",
              " 90: 'W00136',\n",
              " 91: 'W00137',\n",
              " 92: 'W00139',\n",
              " 93: 'W00142',\n",
              " 94: 'W00143',\n",
              " 95: 'W00144',\n",
              " 96: 'W00147',\n",
              " 97: 'W00148',\n",
              " 98: 'W00149',\n",
              " 99: 'W00150',\n",
              " 100: 'W00151',\n",
              " 101: 'W00152',\n",
              " 102: 'W00153',\n",
              " 103: 'W00155',\n",
              " 104: 'W00157',\n",
              " 105: 'W00158',\n",
              " 106: 'W00162',\n",
              " 107: 'W00163',\n",
              " 108: 'W00164',\n",
              " 109: 'W00167',\n",
              " 110: 'W00168',\n",
              " 111: 'W00169',\n",
              " 112: 'W00170',\n",
              " 113: 'W00172',\n",
              " 114: 'W00173',\n",
              " 115: 'W00175',\n",
              " 116: 'W00176',\n",
              " 117: 'W00178',\n",
              " 118: 'W00179',\n",
              " 119: 'W00180',\n",
              " 120: 'W00181',\n",
              " 121: 'W00183',\n",
              " 122: 'W00185',\n",
              " 123: 'W00186',\n",
              " 124: 'W00187',\n",
              " 125: 'W00189',\n",
              " 126: 'W00190',\n",
              " 127: 'W00191',\n",
              " 128: 'W00192',\n",
              " 129: 'W00193',\n",
              " 130: 'W00194',\n",
              " 131: 'W00195',\n",
              " 132: 'W00196',\n",
              " 133: 'W00197',\n",
              " 134: 'W00199',\n",
              " 135: 'W00200',\n",
              " 136: 'W00202',\n",
              " 137: 'W00204',\n",
              " 138: 'W00205',\n",
              " 139: 'W00206',\n",
              " 140: 'W00207',\n",
              " 141: 'W00209',\n",
              " 142: 'W00211',\n",
              " 143: 'W00212',\n",
              " 144: 'W00213',\n",
              " 145: 'W00214',\n",
              " 146: 'W00217',\n",
              " 147: 'W00218',\n",
              " 148: 'W00219',\n",
              " 149: 'W00220',\n",
              " 150: 'W00221',\n",
              " 151: 'W00222',\n",
              " 152: 'W00224',\n",
              " 153: 'W00225',\n",
              " 154: 'W00226',\n",
              " 155: 'W00227',\n",
              " 156: 'W00230',\n",
              " 157: 'W00231',\n",
              " 158: 'W00232',\n",
              " 159: 'W00233',\n",
              " 160: 'W00234',\n",
              " 161: 'W00236',\n",
              " 162: 'W00238',\n",
              " 163: 'W00239',\n",
              " 164: 'W00240',\n",
              " 165: 'W00243',\n",
              " 166: 'W00244',\n",
              " 167: 'W00245',\n",
              " 168: 'W00246',\n",
              " 169: 'W00248',\n",
              " 170: 'W00249',\n",
              " 171: 'W00251',\n",
              " 172: 'W00252',\n",
              " 173: 'W00253',\n",
              " 174: 'W00254',\n",
              " 175: 'W00255',\n",
              " 176: 'W00256',\n",
              " 177: 'W00258',\n",
              " 178: 'W00259',\n",
              " 179: 'W00261',\n",
              " 180: 'W00264',\n",
              " 181: 'W00265',\n",
              " 182: 'W00267',\n",
              " 183: 'W00268',\n",
              " 184: 'W00269',\n",
              " 185: 'W00270',\n",
              " 186: 'W00272',\n",
              " 187: 'W00273',\n",
              " 188: 'W00275',\n",
              " 189: 'W00276',\n",
              " 190: 'W00277',\n",
              " 191: 'W00278',\n",
              " 192: 'W00279',\n",
              " 193: 'W00280',\n",
              " 194: 'W00281',\n",
              " 195: 'W00283',\n",
              " 196: 'W00286',\n",
              " 197: 'W00287',\n",
              " 198: 'W00288',\n",
              " 199: 'W00289',\n",
              " 200: 'W00290',\n",
              " 201: 'W00291',\n",
              " 202: 'W00293',\n",
              " 203: 'W00295',\n",
              " 204: 'W00300',\n",
              " 205: 'W00302',\n",
              " 206: 'W00304',\n",
              " 207: 'W00308',\n",
              " 208: 'W00309',\n",
              " 209: 'W00316',\n",
              " 210: 'W00317',\n",
              " 211: 'W00318',\n",
              " 212: 'W00319',\n",
              " 213: 'W00322',\n",
              " 214: 'W00325',\n",
              " 215: 'W00326',\n",
              " 216: 'W00328',\n",
              " 217: 'W00330',\n",
              " 218: 'W00331',\n",
              " 219: 'W00332',\n",
              " 220: 'W00336',\n",
              " 221: 'W00337',\n",
              " 222: 'W00338',\n",
              " 223: 'W00339',\n",
              " 224: 'W00340',\n",
              " 225: 'W00341',\n",
              " 226: 'W00342',\n",
              " 227: 'W00343',\n",
              " 228: 'W00345',\n",
              " 229: 'W00346',\n",
              " 230: 'W00347',\n",
              " 231: 'W00348',\n",
              " 232: 'W00351',\n",
              " 233: 'W00352',\n",
              " 234: 'W00353',\n",
              " 235: 'W00354',\n",
              " 236: 'W00355',\n",
              " 237: 'W00356',\n",
              " 238: 'W00358',\n",
              " 239: 'W00359',\n",
              " 240: 'W00360',\n",
              " 241: 'W00361',\n",
              " 242: 'W00362',\n",
              " 243: 'W00364',\n",
              " 244: 'W00367',\n",
              " 245: 'W00370',\n",
              " 246: 'W00372',\n",
              " 247: 'W00373',\n",
              " 248: 'W00375',\n",
              " 249: 'W00376',\n",
              " 250: 'W00377',\n",
              " 251: 'W00379',\n",
              " 252: 'W00381',\n",
              " 253: 'W00382',\n",
              " 254: 'W00384',\n",
              " 255: 'W00386',\n",
              " 256: 'W00387',\n",
              " 257: 'W00388',\n",
              " 258: 'W00389',\n",
              " 259: 'W00390',\n",
              " 260: 'W00391',\n",
              " 261: 'W00392',\n",
              " 262: 'W00393',\n",
              " 263: 'W00394',\n",
              " 264: 'W00395',\n",
              " 265: 'W00397',\n",
              " 266: 'W00399',\n",
              " 267: 'W00400',\n",
              " 268: 'W00402',\n",
              " 269: 'W00404',\n",
              " 270: 'W00405',\n",
              " 271: 'W00408',\n",
              " 272: 'W00409',\n",
              " 273: 'W00410',\n",
              " 274: 'W00411',\n",
              " 275: 'W00412',\n",
              " 276: 'W00413',\n",
              " 277: 'W00414',\n",
              " 278: 'W00415',\n",
              " 279: 'W00416',\n",
              " 280: 'W00417',\n",
              " 281: 'W00418',\n",
              " 282: 'W00420',\n",
              " 283: 'W00422',\n",
              " 284: 'W00425',\n",
              " 285: 'W00426',\n",
              " 286: 'W00428',\n",
              " 287: 'W00429',\n",
              " 288: 'W00430',\n",
              " 289: 'W00431',\n",
              " 290: 'W00432',\n",
              " 291: 'W00433',\n",
              " 292: 'W00434',\n",
              " 293: 'W00435',\n",
              " 294: 'W00437',\n",
              " 295: 'W00440',\n",
              " 296: 'W00441',\n",
              " 297: 'W00443',\n",
              " 298: 'W00444',\n",
              " 299: 'W00445',\n",
              " 300: 'W00447',\n",
              " 301: 'W00448',\n",
              " 302: 'W00449',\n",
              " 303: 'W00450',\n",
              " 304: 'W00452',\n",
              " 305: 'W00454',\n",
              " 306: 'W00456',\n",
              " 307: 'W00458',\n",
              " 308: 'W00459',\n",
              " 309: 'W00460',\n",
              " 310: 'W00462',\n",
              " 311: 'W00463',\n",
              " 312: 'W00465',\n",
              " 313: 'W00466',\n",
              " 314: 'W00468',\n",
              " 315: 'W00473',\n",
              " 316: 'W00474',\n",
              " 317: 'W00475',\n",
              " 318: 'W00476',\n",
              " 319: 'W00477',\n",
              " 320: 'W00478',\n",
              " 321: 'W00479',\n",
              " 322: 'W00480',\n",
              " 323: 'W00482',\n",
              " 324: 'W00485',\n",
              " 325: 'W00486',\n",
              " 326: 'W00487',\n",
              " 327: 'W00489',\n",
              " 328: 'W00490',\n",
              " 329: 'W00492',\n",
              " 330: 'W00493',\n",
              " 331: 'W00498',\n",
              " 332: 'W00500',\n",
              " 333: 'W00501',\n",
              " 334: 'W00502',\n",
              " 335: 'W00505',\n",
              " 336: 'W00506',\n",
              " 337: 'W00507',\n",
              " 338: 'W00508',\n",
              " 339: 'W00510',\n",
              " 340: 'W00511',\n",
              " 341: 'W00513',\n",
              " 342: 'W00514',\n",
              " 343: 'W00515',\n",
              " 344: 'W00517',\n",
              " 345: 'W00518',\n",
              " 346: 'W00520',\n",
              " 347: 'W00521',\n",
              " 348: 'W00522',\n",
              " 349: 'W00523',\n",
              " 350: 'W00525',\n",
              " 351: 'W00526',\n",
              " 352: 'W00528',\n",
              " 353: 'W00529',\n",
              " 354: 'W00532',\n",
              " 355: 'W00533',\n",
              " 356: 'W00534',\n",
              " 357: 'W00535',\n",
              " 358: 'W00536',\n",
              " 359: 'W00537',\n",
              " 360: 'W00540',\n",
              " 361: 'W00542',\n",
              " 362: 'W00543',\n",
              " 363: 'W00544',\n",
              " 364: 'W00545',\n",
              " 365: 'W00546',\n",
              " 366: 'W00547',\n",
              " 367: 'W00548',\n",
              " 368: 'W00550',\n",
              " 369: 'W00552',\n",
              " 370: 'W00553',\n",
              " 371: 'W00554',\n",
              " 372: 'W00555',\n",
              " 373: 'W00557',\n",
              " 374: 'W00558',\n",
              " 375: 'W00559',\n",
              " 376: 'W00561',\n",
              " 377: 'W00562',\n",
              " 378: 'W00563',\n",
              " 379: 'W00566',\n",
              " 380: 'W00568',\n",
              " 381: 'W00569',\n",
              " 382: 'W00570',\n",
              " 383: 'W00571',\n",
              " 384: 'W00572',\n",
              " 385: 'W00573',\n",
              " 386: 'W00574',\n",
              " 387: 'W00575',\n",
              " 388: 'W00577',\n",
              " 389: 'W00579',\n",
              " 390: 'W00580',\n",
              " 391: 'W00581',\n",
              " 392: 'W00582',\n",
              " 393: 'W00585',\n",
              " 394: 'W00586',\n",
              " 395: 'W00589',\n",
              " 396: 'W00590',\n",
              " 397: 'W00591',\n",
              " 398: 'W00592',\n",
              " 399: 'W00593',\n",
              " 400: 'W00594',\n",
              " 401: 'W00595',\n",
              " 402: 'W00598',\n",
              " 403: 'W00599',\n",
              " 404: 'W00600',\n",
              " 405: 'W00601',\n",
              " 406: 'W00602',\n",
              " 407: 'W00604',\n",
              " 408: 'W00606',\n",
              " 409: 'W00607',\n",
              " 410: 'W00608',\n",
              " 411: 'W00609',\n",
              " 412: 'W00613',\n",
              " 413: 'W00614',\n",
              " 414: 'W00615',\n",
              " 415: 'W00616',\n",
              " 416: 'W00617',\n",
              " 417: 'W00618',\n",
              " 418: 'W00621',\n",
              " 419: 'W00622',\n",
              " 420: 'W00624',\n",
              " 421: 'W00625',\n",
              " 422: 'W00626',\n",
              " 423: 'W00628',\n",
              " 424: 'W00629',\n",
              " 425: 'W00630',\n",
              " 426: 'W00634',\n",
              " 427: 'W00635',\n",
              " 428: 'W00636',\n",
              " 429: 'W00637',\n",
              " 430: 'W00638',\n",
              " 431: 'W00639',\n",
              " 432: 'W00640',\n",
              " 433: 'W00641',\n",
              " 434: 'W00642',\n",
              " 435: 'W00643',\n",
              " 436: 'W00645',\n",
              " 437: 'W00646',\n",
              " 438: 'W00649',\n",
              " 439: 'W00650',\n",
              " 440: 'W00652',\n",
              " 441: 'W00654',\n",
              " 442: 'W00655',\n",
              " 443: 'W00657',\n",
              " 444: 'W00658',\n",
              " 445: 'W00659',\n",
              " 446: 'W00660',\n",
              " 447: 'W00661',\n",
              " 448: 'W00662',\n",
              " 449: 'W00663',\n",
              " 450: 'W00664',\n",
              " 451: 'W00665',\n",
              " 452: 'W00666',\n",
              " 453: 'W00667',\n",
              " 454: 'W00670',\n",
              " 455: 'W00671',\n",
              " 456: 'W00672',\n",
              " 457: 'W00673',\n",
              " 458: 'W00674',\n",
              " 459: 'W00675',\n",
              " 460: 'W00676',\n",
              " 461: 'W00677',\n",
              " 462: 'W00679',\n",
              " 463: 'W00680',\n",
              " 464: 'W00681',\n",
              " 465: 'W00682',\n",
              " 466: 'W00683',\n",
              " 467: 'W00684',\n",
              " 468: 'W00685',\n",
              " 469: 'W00687',\n",
              " 470: 'W00688',\n",
              " 471: 'W00689',\n",
              " 472: 'W00690',\n",
              " 473: 'W00691',\n",
              " 474: 'W00692',\n",
              " 475: 'W00693',\n",
              " 476: 'W00694',\n",
              " 477: 'W00695',\n",
              " 478: 'W00696',\n",
              " 479: 'W00699',\n",
              " 480: 'W00700',\n",
              " 481: 'W00702',\n",
              " 482: 'W00703',\n",
              " 483: 'W00704',\n",
              " 484: 'W00705',\n",
              " 485: 'W00706',\n",
              " 486: 'W00707',\n",
              " 487: 'W00708',\n",
              " 488: 'W00710',\n",
              " 489: 'W00711',\n",
              " 490: 'W00712',\n",
              " 491: 'W00713',\n",
              " 492: 'W00714',\n",
              " 493: 'W00715',\n",
              " 494: 'W00717',\n",
              " 495: 'W00719',\n",
              " 496: 'W00720',\n",
              " 497: 'W00721',\n",
              " 498: 'W00724',\n",
              " 499: 'W00725',\n",
              " 500: 'W00726',\n",
              " 501: 'W00727',\n",
              " 502: 'W00728',\n",
              " 503: 'W00729',\n",
              " 504: 'W00731',\n",
              " 505: 'W00733',\n",
              " 506: 'W00734',\n",
              " 507: 'W00735',\n",
              " 508: 'W00736',\n",
              " 509: 'W00737',\n",
              " 510: 'W00739',\n",
              " 511: 'W00740',\n",
              " 512: 'W00741',\n",
              " 513: 'W00742',\n",
              " 514: 'W00743',\n",
              " 515: 'W00744',\n",
              " 516: 'W00745',\n",
              " 517: 'W00746',\n",
              " 518: 'W00750',\n",
              " 519: 'W00751',\n",
              " 520: 'W00756',\n",
              " 521: 'W00761',\n",
              " 522: 'W00762',\n",
              " 523: 'W00763',\n",
              " 524: 'W00764',\n",
              " 525: 'W00766',\n",
              " 526: 'W00767',\n",
              " 527: 'W00769',\n",
              " 528: 'W00770',\n",
              " 529: 'W00771',\n",
              " 530: 'W00772',\n",
              " 531: 'W00773',\n",
              " 532: 'W00774',\n",
              " 533: 'W00775',\n",
              " 534: 'W00776',\n",
              " 535: 'W00777',\n",
              " 536: 'W00778',\n",
              " 537: 'W00779',\n",
              " 538: 'W00782',\n",
              " 539: 'W00783',\n",
              " 540: 'W00784',\n",
              " 541: 'W00787',\n",
              " 542: 'W00788',\n",
              " 543: 'W00789',\n",
              " 544: 'W00791',\n",
              " 545: 'W00792',\n",
              " 546: 'W00794',\n",
              " 547: 'W00795',\n",
              " 548: 'W00798',\n",
              " 549: 'W00799',\n",
              " 550: 'W00803',\n",
              " 551: 'W00804',\n",
              " 552: 'W00805',\n",
              " 553: 'W00807',\n",
              " 554: 'W00810',\n",
              " 555: 'W00811',\n",
              " 556: 'W00812',\n",
              " 557: 'W00813',\n",
              " 558: 'W00815',\n",
              " 559: 'W00816',\n",
              " 560: 'W00817',\n",
              " 561: 'W00818',\n",
              " 562: 'W00819',\n",
              " 563: 'W00820',\n",
              " 564: 'W00822',\n",
              " 565: 'W00823',\n",
              " 566: 'W00824',\n",
              " 567: 'W00825',\n",
              " 568: 'W00826',\n",
              " 569: 'W00831',\n",
              " 570: 'W00832',\n",
              " 571: 'W00833',\n",
              " 572: 'W00834',\n",
              " 573: 'W00835',\n",
              " 574: 'W00836',\n",
              " 575: 'W00837',\n",
              " 576: 'W00838',\n",
              " 577: 'W00839',\n",
              " 578: 'W00842',\n",
              " 579: 'W00843',\n",
              " 580: 'W00844',\n",
              " 581: 'W00845',\n",
              " 582: 'W00846',\n",
              " 583: 'W00847',\n",
              " 584: 'W00848',\n",
              " 585: 'W00849',\n",
              " 586: 'W00851',\n",
              " 587: 'W00852',\n",
              " 588: 'W00855',\n",
              " 589: 'W00856',\n",
              " 590: 'W00857',\n",
              " 591: 'W00859',\n",
              " 592: 'W00860',\n",
              " 593: 'W00862',\n",
              " 594: 'W00864',\n",
              " 595: 'W00866',\n",
              " 596: 'W00867',\n",
              " 597: 'W00869',\n",
              " 598: 'W00870',\n",
              " 599: 'W00872',\n",
              " 600: 'W00873',\n",
              " 601: 'W00874',\n",
              " 602: 'W00875',\n",
              " 603: 'W00876',\n",
              " 604: 'W00877',\n",
              " 605: 'W00878',\n",
              " 606: 'W00879',\n",
              " 607: 'W00880',\n",
              " 608: 'W00881',\n",
              " 609: 'W00882',\n",
              " 610: 'W00883',\n",
              " 611: 'W00884',\n",
              " 612: 'W00885',\n",
              " 613: 'W00886',\n",
              " 614: 'W00887',\n",
              " 615: 'W00889',\n",
              " 616: 'W00890',\n",
              " 617: 'W00891',\n",
              " 618: 'W00892',\n",
              " 619: 'W00894',\n",
              " 620: 'W00897',\n",
              " 621: 'W00898',\n",
              " 622: 'W00899',\n",
              " 623: 'W00900',\n",
              " 624: 'W00901',\n",
              " 625: 'W00902',\n",
              " 626: 'W00903',\n",
              " 627: 'W00904',\n",
              " 628: 'W00905',\n",
              " 629: 'W00908',\n",
              " 630: 'W00909',\n",
              " 631: 'W00912',\n",
              " 632: 'W00913',\n",
              " 633: 'W00914',\n",
              " 634: 'W00915',\n",
              " 635: 'W00916',\n",
              " 636: 'W00917',\n",
              " 637: 'W00918',\n",
              " 638: 'W00920',\n",
              " 639: 'W00922',\n",
              " 640: 'W00923',\n",
              " 641: 'W00926',\n",
              " 642: 'W00928',\n",
              " 643: 'W00929',\n",
              " 644: 'W00930',\n",
              " 645: 'W00931',\n",
              " 646: 'W00932',\n",
              " 647: 'W00933',\n",
              " 648: 'W00935',\n",
              " 649: 'W00940',\n",
              " 650: 'W00942',\n",
              " 651: 'W00944',\n",
              " 652: 'W00945',\n",
              " 653: 'W00946',\n",
              " 654: 'W00947',\n",
              " 655: 'W00948',\n",
              " 656: 'W00950',\n",
              " 657: 'W00951',\n",
              " 658: 'W00952',\n",
              " 659: 'W00953',\n",
              " 660: 'W00954',\n",
              " 661: 'W00956',\n",
              " 662: 'W00957',\n",
              " 663: 'W00960',\n",
              " 664: 'W00961',\n",
              " 665: 'W00962',\n",
              " 666: 'W00963',\n",
              " 667: 'W00964',\n",
              " 668: 'W00966',\n",
              " 669: 'W00967',\n",
              " 670: 'W00968',\n",
              " 671: 'W00969',\n",
              " 672: 'W00974',\n",
              " 673: 'W00977',\n",
              " 674: 'W00978',\n",
              " 675: 'W00979',\n",
              " 676: 'W00980',\n",
              " 677: 'W00981',\n",
              " 678: 'W00982',\n",
              " 679: 'W00983',\n",
              " 680: 'W00986',\n",
              " 681: 'W00987',\n",
              " 682: 'W00988',\n",
              " 683: 'W00990',\n",
              " 684: 'W00991',\n",
              " 685: 'W00993',\n",
              " 686: 'W00994',\n",
              " 687: 'W00995',\n",
              " 688: 'W00996',\n",
              " 689: 'W00997',\n",
              " 690: 'W00999',\n",
              " 691: 'W01000',\n",
              " 692: 'W01001',\n",
              " 693: 'W01002',\n",
              " 694: 'W01003',\n",
              " 695: 'W01004',\n",
              " 696: 'W01005',\n",
              " 697: 'W01006',\n",
              " 698: 'W01007',\n",
              " 699: 'W01008',\n",
              " 700: 'W01009',\n",
              " 701: 'W01010',\n",
              " 702: 'W01011',\n",
              " 703: 'W01012',\n",
              " 704: 'W01014',\n",
              " 705: 'W01015',\n",
              " 706: 'W01016',\n",
              " 707: 'W01017',\n",
              " 708: 'W01018',\n",
              " 709: 'W01020',\n",
              " 710: 'W01021',\n",
              " 711: 'W01023',\n",
              " 712: 'W01025',\n",
              " 713: 'W01026',\n",
              " 714: 'W01028',\n",
              " 715: 'W01030',\n",
              " 716: 'W01031',\n",
              " 717: 'W01033',\n",
              " 718: 'W01035',\n",
              " 719: 'W01036',\n",
              " 720: 'W01037',\n",
              " 721: 'W01039',\n",
              " 722: 'W01040',\n",
              " 723: 'W01041',\n",
              " 724: 'W01043',\n",
              " 725: 'W01044',\n",
              " 726: 'W01046',\n",
              " 727: 'W01048',\n",
              " 728: 'W01049',\n",
              " 729: 'W01050',\n",
              " 730: 'W01051',\n",
              " 731: 'W01052',\n",
              " 732: 'W01056',\n",
              " 733: 'W01057',\n",
              " 734: 'W01060',\n",
              " 735: 'W01061',\n",
              " 736: 'W01062',\n",
              " 737: 'W01064',\n",
              " 738: 'W01065',\n",
              " 739: 'W01066',\n",
              " 740: 'W01067',\n",
              " 741: 'W01068',\n",
              " 742: 'W01069',\n",
              " 743: 'W01070',\n",
              " 744: 'W01071',\n",
              " 745: 'W01073',\n",
              " 746: 'W01074',\n",
              " 747: 'W01075',\n",
              " 748: 'W01078',\n",
              " 749: 'W01080',\n",
              " 750: 'W01081',\n",
              " 751: 'W01083',\n",
              " 752: 'W01085',\n",
              " 753: 'W01087',\n",
              " 754: 'W01088',\n",
              " 755: 'W01090',\n",
              " 756: 'W01091',\n",
              " 757: 'W01092',\n",
              " 758: 'W01093',\n",
              " 759: 'W01094',\n",
              " 760: 'W01096',\n",
              " 761: 'W01097',\n",
              " 762: 'W01098',\n",
              " 763: 'W01101',\n",
              " 764: 'W01102',\n",
              " 765: 'W01104',\n",
              " 766: 'W01105',\n",
              " 767: 'W01106',\n",
              " 768: 'W01107',\n",
              " 769: 'W01110',\n",
              " 770: 'W01111',\n",
              " 771: 'W01112',\n",
              " 772: 'W01113',\n",
              " 773: 'W01119',\n",
              " 774: 'W01120',\n",
              " 775: 'W01121',\n",
              " 776: 'W01122',\n",
              " 777: 'W01123',\n",
              " 778: 'W01124',\n",
              " 779: 'W01125',\n",
              " 780: 'W01127',\n",
              " 781: 'W01128',\n",
              " 782: 'W01130',\n",
              " 783: 'W01131',\n",
              " 784: 'W01133',\n",
              " 785: 'W01134',\n",
              " 786: 'W01137',\n",
              " 787: 'W01138',\n",
              " 788: 'W01139',\n",
              " 789: 'W01140',\n",
              " 790: 'W01141',\n",
              " 791: 'W01142',\n",
              " 792: 'W01143',\n",
              " 793: 'W01144',\n",
              " 794: 'W01145',\n",
              " 795: 'W01147',\n",
              " 796: 'W01148',\n",
              " 797: 'W01151',\n",
              " 798: 'W01152',\n",
              " 799: 'W01153',\n",
              " 800: 'W01156',\n",
              " 801: 'W01158',\n",
              " 802: 'W01159',\n",
              " 803: 'W01160',\n",
              " 804: 'W01163',\n",
              " 805: 'W01164',\n",
              " 806: 'W01165',\n",
              " 807: 'W01166',\n",
              " 808: 'W01167',\n",
              " 809: 'W01168',\n",
              " 810: 'W01169',\n",
              " 811: 'W01170',\n",
              " 812: 'W01171',\n",
              " 813: 'W01172',\n",
              " 814: 'W01173',\n",
              " 815: 'W01175',\n",
              " 816: 'W01176',\n",
              " 817: 'W01177',\n",
              " 818: 'W01178',\n",
              " 819: 'W01180',\n",
              " 820: 'W01181',\n",
              " 821: 'W01182',\n",
              " 822: 'W01184',\n",
              " 823: 'W01185',\n",
              " 824: 'W01187',\n",
              " 825: 'W01189',\n",
              " 826: 'W01191',\n",
              " 827: 'W01192',\n",
              " 828: 'W01193',\n",
              " 829: 'W01194',\n",
              " 830: 'W01196',\n",
              " 831: 'W01197',\n",
              " 832: 'W01198',\n",
              " 833: 'W01199',\n",
              " 834: 'W01200',\n",
              " 835: 'W01201',\n",
              " 836: 'W01203',\n",
              " 837: 'W01204',\n",
              " 838: 'W01205',\n",
              " 839: 'W01206',\n",
              " 840: 'W01207',\n",
              " 841: 'W01209',\n",
              " 842: 'W01210',\n",
              " 843: 'W01211',\n",
              " 844: 'W01212',\n",
              " 845: 'W01213',\n",
              " 846: 'W01214',\n",
              " 847: 'W01215',\n",
              " 848: 'W01216',\n",
              " 849: 'W01218',\n",
              " 850: 'W01221',\n",
              " 851: 'W01222',\n",
              " 852: 'W01223',\n",
              " 853: 'W01224',\n",
              " 854: 'W01225',\n",
              " 855: 'W01226',\n",
              " 856: 'W01229',\n",
              " 857: 'W01230',\n",
              " 858: 'W01233',\n",
              " 859: 'W01235',\n",
              " 860: 'W01236',\n",
              " 861: 'W01237',\n",
              " 862: 'W01238',\n",
              " 863: 'W01239',\n",
              " 864: 'W01240',\n",
              " 865: 'W01241',\n",
              " 866: 'W01242',\n",
              " 867: 'W01245',\n",
              " 868: 'W01246',\n",
              " 869: 'W01250',\n",
              " 870: 'W01251',\n",
              " 871: 'W01252',\n",
              " 872: 'W01253',\n",
              " 873: 'W01255',\n",
              " 874: 'W01256',\n",
              " 875: 'W01257',\n",
              " 876: 'W01259',\n",
              " 877: 'W01261',\n",
              " 878: 'W01262',\n",
              " 879: 'W01263',\n",
              " 880: 'W01265',\n",
              " 881: 'W01266',\n",
              " 882: 'W01268',\n",
              " 883: 'W01271',\n",
              " 884: 'W01272',\n",
              " 885: 'W01273',\n",
              " 886: 'W01274',\n",
              " 887: 'W01275',\n",
              " 888: 'W01277',\n",
              " 889: 'W01278',\n",
              " 890: 'W01279',\n",
              " 891: 'W01280',\n",
              " 892: 'W01282',\n",
              " 893: 'W01283',\n",
              " 894: 'W01284',\n",
              " 895: 'W01285',\n",
              " 896: 'W01286',\n",
              " 897: 'W01287',\n",
              " 898: 'W01288',\n",
              " 899: 'W01291',\n",
              " 900: 'W01292',\n",
              " 901: 'W01294',\n",
              " 902: 'W01298',\n",
              " 903: 'W01299',\n",
              " 904: 'W01301',\n",
              " 905: 'W01303',\n",
              " 906: 'W01304',\n",
              " 907: 'W01307',\n",
              " 908: 'W01308',\n",
              " 909: 'W01309',\n",
              " 910: 'W01310',\n",
              " 911: 'W01311',\n",
              " 912: 'W01313',\n",
              " 913: 'W01314',\n",
              " 914: 'W01315',\n",
              " 915: 'W01316',\n",
              " 916: 'W01318',\n",
              " 917: 'W01319',\n",
              " 918: 'W01320',\n",
              " 919: 'W01321',\n",
              " 920: 'W01322',\n",
              " 921: 'W01323',\n",
              " 922: 'W01324',\n",
              " 923: 'W01325',\n",
              " 924: 'W01327',\n",
              " 925: 'W01328',\n",
              " 926: 'W01329',\n",
              " 927: 'W01330',\n",
              " 928: 'W01332',\n",
              " 929: 'W01333',\n",
              " 930: 'W01334',\n",
              " 931: 'W01335',\n",
              " 932: 'W01336',\n",
              " 933: 'W01337',\n",
              " 934: 'W01338',\n",
              " 935: 'W01339',\n",
              " 936: 'W01340',\n",
              " 937: 'W01341',\n",
              " 938: 'W01342',\n",
              " 939: 'W01345',\n",
              " 940: 'W01346',\n",
              " 941: 'W01347',\n",
              " 942: 'W01348',\n",
              " 943: 'W01349',\n",
              " 944: 'W01350',\n",
              " 945: 'W01351',\n",
              " 946: 'W01352',\n",
              " 947: 'W01354',\n",
              " 948: 'W01355',\n",
              " 949: 'W01356',\n",
              " 950: 'W01357',\n",
              " 951: 'W01358',\n",
              " 952: 'W01359',\n",
              " 953: 'W01361',\n",
              " 954: 'W01362',\n",
              " 955: 'W01364',\n",
              " 956: 'W01365',\n",
              " 957: 'W01366',\n",
              " 958: 'W01367',\n",
              " 959: 'W01368',\n",
              " 960: 'W01369',\n",
              " 961: 'W01370',\n",
              " 962: 'W01372',\n",
              " 963: 'W01373',\n",
              " 964: 'W01374',\n",
              " 965: 'W01376',\n",
              " 966: 'W01377',\n",
              " 967: 'W01378',\n",
              " 968: 'W01380',\n",
              " 969: 'W01381',\n",
              " 970: 'W01384',\n",
              " 971: 'W01385',\n",
              " 972: 'W01386',\n",
              " 973: 'W01387',\n",
              " 974: 'W01388',\n",
              " 975: 'W01389',\n",
              " 976: 'W01391',\n",
              " 977: 'W01392',\n",
              " 978: 'W01393',\n",
              " 979: 'W01394',\n",
              " 980: 'W01395',\n",
              " 981: 'W01397',\n",
              " 982: 'W01398',\n",
              " 983: 'W01399',\n",
              " 984: 'W01400',\n",
              " 985: 'W01401',\n",
              " 986: 'W01402',\n",
              " 987: 'W01403',\n",
              " 988: 'W01404',\n",
              " 989: 'W01408',\n",
              " 990: 'W01409',\n",
              " 991: 'W01410',\n",
              " 992: 'W01411',\n",
              " 993: 'W01413',\n",
              " 994: 'W01414',\n",
              " 995: 'W01415',\n",
              " 996: 'W01416',\n",
              " 997: 'W01417',\n",
              " 998: 'W01419',\n",
              " 999: 'W01420',\n",
              " ...}"
            ]
          },
          "metadata": {},
          "execution_count": 14
        }
      ]
    }
  ]
}