Scripts - study bike sharing.ipynb

{
    "cells": [
        {
            "cell_type": "code",
            "execution_count": 1,
            "source": [
                "import os\n",
                "import fiona\n",
                "import requests\n",
                "import pandas as pd\n",
                "import seaborn as sns\n",
                "import numpy as np\n",
                "import scipy as sc\n",
                "import matplotlib.pyplot as plt\n",
                "import matplotlib.tri as tri\n",
                "import matplotlib.cm as cm\n",
                "import geopandas as geo\n",
                "from matplotlib.colors import ListedColormap, LinearSegmentedColormap\n",
                "\n",
                "viridis = cm.get_cmap(\"viridis\", 6)\n",
                "sns.set_palette(\"viridis\")\n",
                "sns.color_palette(\"viridis\", as_cmap=True)"
            ],
            "outputs": [
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "<matplotlib.colors.ListedColormap at 0x7fec67440a20>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 1
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [
                "## Data Informations\n",
                "All data shared from \n",
                "[CapitalBikeShare](https://www.capitalbikeshare.com/system-data)\n",
                "\n",
                "## Tasks to make\n",
                "- Identify the variables that most impact hourly ridership\n",
                "- Develop a model to predict hourly bikeshare demand in the region based on historical ridership and weather data for next year\n",
                "- Get a total of members and casual clients\n",
                "- Explore how many clients use in normal hushtime 6~9 12~14 18~20\n",
                "- Get the most stations used\n",
                "- Get the most bikes used by the time used\n"
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 2,
            "source": [
                "dataframe_stations_raw = pd.read_json('https://gbfs.capitalbikeshare.com/gbfs/en/station_information.json', orient='values')"
            ],
            "outputs": [],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 3,
            "source": [
                "dataframe_stations = dataframe_stations_raw.copy()\n",
                "dataframe_stations = pd.DataFrame(dataframe_stations.data.stations).set_index('station_id')\n",
                "print('dataframe_stations Length: ',len(dataframe_stations))\n",
                "dataframe_stations.head()"
            ],
            "outputs": [
                {
                    "output_type": "stream",
                    "name": "stdout",
                    "text": [
                        "dataframe_stations Length:  650\n"
                    ]
                },
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "                  lat short_name eightd_station_services  \\\n",
                            "station_id                                                 \n",
                            "1           38.858971      31000                      []   \n",
                            "2           38.857250      31001                      []   \n",
                            "3           38.856425      31002                      []   \n",
                            "4           38.861056      31003                      []   \n",
                            "5           38.857866      31004                      []   \n",
                            "\n",
                            "            electric_bike_surcharge_waiver  capacity        lon station_type  \\\n",
                            "station_id                                                                     \n",
                            "1                                    False        15 -77.053230      classic   \n",
                            "2                                    False        11 -77.053320      classic   \n",
                            "3                                    False        17 -77.049232      classic   \n",
                            "4                                    False        16 -77.049417      classic   \n",
                            "5                                    False        12 -77.059490      classic   \n",
                            "\n",
                            "           region_id                           external_id  \\\n",
                            "station_id                                                   \n",
                            "1                 41  082469cc-1f3f-11e7-bf6b-3863bb334450   \n",
                            "2                 41  08246b69-1f3f-11e7-bf6b-3863bb334450   \n",
                            "3                 41  08246c35-1f3f-11e7-bf6b-3863bb334450   \n",
                            "4                 41  08246cd5-1f3f-11e7-bf6b-3863bb334450   \n",
                            "5                 41  08246d68-1f3f-11e7-bf6b-3863bb334450   \n",
                            "\n",
                            "                                                  rental_uris  \\\n",
                            "station_id                                                      \n",
                            "1           {'ios': 'https://dc.lft.to/lastmile_qr_scan', ...   \n",
                            "2           {'ios': 'https://dc.lft.to/lastmile_qr_scan', ...   \n",
                            "3           {'ios': 'https://dc.lft.to/lastmile_qr_scan', ...   \n",
                            "4           {'ios': 'https://dc.lft.to/lastmile_qr_scan', ...   \n",
                            "5           {'ios': 'https://dc.lft.to/lastmile_qr_scan', ...   \n",
                            "\n",
                            "            eightd_has_key_dispenser legacy_id  has_kiosk  \\\n",
                            "station_id                                                  \n",
                            "1                              False         1       True   \n",
                            "2                              False         2       True   \n",
                            "3                              False         3       True   \n",
                            "4                              False         4       True   \n",
                            "5                              False         5       True   \n",
                            "\n",
                            "                                                    name     rental_methods  \n",
                            "station_id                                                                   \n",
                            "1                                    Eads St & 15th St S  [KEY, CREDITCARD]  \n",
                            "2                                    18th St & S Eads St  [KEY, CREDITCARD]  \n",
                            "3                                 Crystal Dr & 20th St S  [KEY, CREDITCARD]  \n",
                            "4                                 Crystal Dr & 15th St S  [KEY, CREDITCARD]  \n",
                            "5           Aurora Hills Cmty Ctr / 18th St & S Hayes St  [KEY, CREDITCARD]  "
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>lat</th>\n",
                            "      <th>short_name</th>\n",
                            "      <th>eightd_station_services</th>\n",
                            "      <th>electric_bike_surcharge_waiver</th>\n",
                            "      <th>capacity</th>\n",
                            "      <th>lon</th>\n",
                            "      <th>station_type</th>\n",
                            "      <th>region_id</th>\n",
                            "      <th>external_id</th>\n",
                            "      <th>rental_uris</th>\n",
                            "      <th>eightd_has_key_dispenser</th>\n",
                            "      <th>legacy_id</th>\n",
                            "      <th>has_kiosk</th>\n",
                            "      <th>name</th>\n",
                            "      <th>rental_methods</th>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>station_id</th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "    </tr>\n",
                            "  </thead>\n",
                            "  <tbody>\n",
                            "    <tr>\n",
                            "      <th>1</th>\n",
                            "      <td>38.858971</td>\n",
                            "      <td>31000</td>\n",
                            "      <td>[]</td>\n",
                            "      <td>False</td>\n",
                            "      <td>15</td>\n",
                            "      <td>-77.053230</td>\n",
                            "      <td>classic</td>\n",
                            "      <td>41</td>\n",
                            "      <td>082469cc-1f3f-11e7-bf6b-3863bb334450</td>\n",
                            "      <td>{'ios': 'https://dc.lft.to/lastmile_qr_scan', ...</td>\n",
                            "      <td>False</td>\n",
                            "      <td>1</td>\n",
                            "      <td>True</td>\n",
                            "      <td>Eads St &amp; 15th St S</td>\n",
                            "      <td>[KEY, CREDITCARD]</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2</th>\n",
                            "      <td>38.857250</td>\n",
                            "      <td>31001</td>\n",
                            "      <td>[]</td>\n",
                            "      <td>False</td>\n",
                            "      <td>11</td>\n",
                            "      <td>-77.053320</td>\n",
                            "      <td>classic</td>\n",
                            "      <td>41</td>\n",
                            "      <td>08246b69-1f3f-11e7-bf6b-3863bb334450</td>\n",
                            "      <td>{'ios': 'https://dc.lft.to/lastmile_qr_scan', ...</td>\n",
                            "      <td>False</td>\n",
                            "      <td>2</td>\n",
                            "      <td>True</td>\n",
                            "      <td>18th St &amp; S Eads St</td>\n",
                            "      <td>[KEY, CREDITCARD]</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>3</th>\n",
                            "      <td>38.856425</td>\n",
                            "      <td>31002</td>\n",
                            "      <td>[]</td>\n",
                            "      <td>False</td>\n",
                            "      <td>17</td>\n",
                            "      <td>-77.049232</td>\n",
                            "      <td>classic</td>\n",
                            "      <td>41</td>\n",
                            "      <td>08246c35-1f3f-11e7-bf6b-3863bb334450</td>\n",
                            "      <td>{'ios': 'https://dc.lft.to/lastmile_qr_scan', ...</td>\n",
                            "      <td>False</td>\n",
                            "      <td>3</td>\n",
                            "      <td>True</td>\n",
                            "      <td>Crystal Dr &amp; 20th St S</td>\n",
                            "      <td>[KEY, CREDITCARD]</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>4</th>\n",
                            "      <td>38.861056</td>\n",
                            "      <td>31003</td>\n",
                            "      <td>[]</td>\n",
                            "      <td>False</td>\n",
                            "      <td>16</td>\n",
                            "      <td>-77.049417</td>\n",
                            "      <td>classic</td>\n",
                            "      <td>41</td>\n",
                            "      <td>08246cd5-1f3f-11e7-bf6b-3863bb334450</td>\n",
                            "      <td>{'ios': 'https://dc.lft.to/lastmile_qr_scan', ...</td>\n",
                            "      <td>False</td>\n",
                            "      <td>4</td>\n",
                            "      <td>True</td>\n",
                            "      <td>Crystal Dr &amp; 15th St S</td>\n",
                            "      <td>[KEY, CREDITCARD]</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>5</th>\n",
                            "      <td>38.857866</td>\n",
                            "      <td>31004</td>\n",
                            "      <td>[]</td>\n",
                            "      <td>False</td>\n",
                            "      <td>12</td>\n",
                            "      <td>-77.059490</td>\n",
                            "      <td>classic</td>\n",
                            "      <td>41</td>\n",
                            "      <td>08246d68-1f3f-11e7-bf6b-3863bb334450</td>\n",
                            "      <td>{'ios': 'https://dc.lft.to/lastmile_qr_scan', ...</td>\n",
                            "      <td>False</td>\n",
                            "      <td>5</td>\n",
                            "      <td>True</td>\n",
                            "      <td>Aurora Hills Cmty Ctr / 18th St &amp; S Hayes St</td>\n",
                            "      <td>[KEY, CREDITCARD]</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 3
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 4,
            "source": [
                "dataframe_tripdata_raw = pd.read_csv('2017Q1-capitalbikeshare-tripdata.csv')\n",
                "print('dataframe_tripdata_raw Length: ',len(dataframe_tripdata_raw))\n",
                "dataframe_tripdata_raw.head()"
            ],
            "outputs": [
                {
                    "output_type": "stream",
                    "name": "stdout",
                    "text": [
                        "dataframe_tripdata_raw Length:  552399\n"
                    ]
                },
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "   Duration           Start date             End date  Start station number  \\\n",
                            "0       166  2016-01-01 00:06:58  2016-01-01 00:09:44                 31102   \n",
                            "1       448  2016-01-01 00:10:20  2016-01-01 00:17:48                 32039   \n",
                            "2       715  2016-01-01 00:13:52  2016-01-01 00:25:48                 31222   \n",
                            "3       213  2016-01-01 00:15:29  2016-01-01 00:19:03                 31506   \n",
                            "4       872  2016-01-01 00:16:16  2016-01-01 00:30:49                 31041   \n",
                            "\n",
                            "                      Start station  End station number  \\\n",
                            "0               11th & Kenyon St NW               31105   \n",
                            "1  Old Georgetown Rd & Southwick St               32002   \n",
                            "2         New York Ave & 15th St NW               31214   \n",
                            "3         1st & Rhode Island Ave NW               31509   \n",
                            "4              Prince St & Union St               31048   \n",
                            "\n",
                            "                   End station Bike number Member type  \n",
                            "0         14th & Harvard St NW      W01346      Member  \n",
                            "1  Bethesda Ave & Arlington Rd      W22202      Member  \n",
                            "2        17th & Corcoran St NW      W21427      Member  \n",
                            "3     New Jersey Ave & R St NW      W01294      Member  \n",
                            "4          King St Metro South      W22058      Member  "
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>Duration</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>166</td>\n",
                            "      <td>2016-01-01 00:06:58</td>\n",
                            "      <td>2016-01-01 00:09:44</td>\n",
                            "      <td>31102</td>\n",
                            "      <td>11th &amp; Kenyon St NW</td>\n",
                            "      <td>31105</td>\n",
                            "      <td>14th &amp; Harvard St NW</td>\n",
                            "      <td>W01346</td>\n",
                            "      <td>Member</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1</th>\n",
                            "      <td>448</td>\n",
                            "      <td>2016-01-01 00:10:20</td>\n",
                            "      <td>2016-01-01 00:17:48</td>\n",
                            "      <td>32039</td>\n",
                            "      <td>Old Georgetown Rd &amp; Southwick St</td>\n",
                            "      <td>32002</td>\n",
                            "      <td>Bethesda Ave &amp; Arlington Rd</td>\n",
                            "      <td>W22202</td>\n",
                            "      <td>Member</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2</th>\n",
                            "      <td>715</td>\n",
                            "      <td>2016-01-01 00:13:52</td>\n",
                            "      <td>2016-01-01 00:25:48</td>\n",
                            "      <td>31222</td>\n",
                            "      <td>New York Ave &amp; 15th St NW</td>\n",
                            "      <td>31214</td>\n",
                            "      <td>17th &amp; Corcoran St NW</td>\n",
                            "      <td>W21427</td>\n",
                            "      <td>Member</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>3</th>\n",
                            "      <td>213</td>\n",
                            "      <td>2016-01-01 00:15:29</td>\n",
                            "      <td>2016-01-01 00:19:03</td>\n",
                            "      <td>31506</td>\n",
                            "      <td>1st &amp; Rhode Island Ave NW</td>\n",
                            "      <td>31509</td>\n",
                            "      <td>New Jersey Ave &amp; R St NW</td>\n",
                            "      <td>W01294</td>\n",
                            "      <td>Member</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>4</th>\n",
                            "      <td>872</td>\n",
                            "      <td>2016-01-01 00:16:16</td>\n",
                            "      <td>2016-01-01 00:30:49</td>\n",
                            "      <td>31041</td>\n",
                            "      <td>Prince St &amp; Union St</td>\n",
                            "      <td>31048</td>\n",
                            "      <td>King St Metro South</td>\n",
                            "      <td>W22058</td>\n",
                            "      <td>Member</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 4
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 5,
            "source": [
                "dataframe_tripdata = dataframe_tripdata_raw.copy()\n",
                "print('dataframe_tripdata Length: ',len(dataframe_tripdata))\n",
                "dataframe_tripdata.head()"
            ],
            "outputs": [
                {
                    "output_type": "stream",
                    "name": "stdout",
                    "text": [
                        "dataframe_tripdata Length:  552399\n"
                    ]
                },
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "   Duration           Start date             End date  Start station number  \\\n",
                            "0       166  2016-01-01 00:06:58  2016-01-01 00:09:44                 31102   \n",
                            "1       448  2016-01-01 00:10:20  2016-01-01 00:17:48                 32039   \n",
                            "2       715  2016-01-01 00:13:52  2016-01-01 00:25:48                 31222   \n",
                            "3       213  2016-01-01 00:15:29  2016-01-01 00:19:03                 31506   \n",
                            "4       872  2016-01-01 00:16:16  2016-01-01 00:30:49                 31041   \n",
                            "\n",
                            "                      Start station  End station number  \\\n",
                            "0               11th & Kenyon St NW               31105   \n",
                            "1  Old Georgetown Rd & Southwick St               32002   \n",
                            "2         New York Ave & 15th St NW               31214   \n",
                            "3         1st & Rhode Island Ave NW               31509   \n",
                            "4              Prince St & Union St               31048   \n",
                            "\n",
                            "                   End station Bike number Member type  \n",
                            "0         14th & Harvard St NW      W01346      Member  \n",
                            "1  Bethesda Ave & Arlington Rd      W22202      Member  \n",
                            "2        17th & Corcoran St NW      W21427      Member  \n",
                            "3     New Jersey Ave & R St NW      W01294      Member  \n",
                            "4          King St Metro South      W22058      Member  "
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>Duration</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>166</td>\n",
                            "      <td>2016-01-01 00:06:58</td>\n",
                            "      <td>2016-01-01 00:09:44</td>\n",
                            "      <td>31102</td>\n",
                            "      <td>11th &amp; Kenyon St NW</td>\n",
                            "      <td>31105</td>\n",
                            "      <td>14th &amp; Harvard St NW</td>\n",
                            "      <td>W01346</td>\n",
                            "      <td>Member</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1</th>\n",
                            "      <td>448</td>\n",
                            "      <td>2016-01-01 00:10:20</td>\n",
                            "      <td>2016-01-01 00:17:48</td>\n",
                            "      <td>32039</td>\n",
                            "      <td>Old Georgetown Rd &amp; Southwick St</td>\n",
                            "      <td>32002</td>\n",
                            "      <td>Bethesda Ave &amp; Arlington Rd</td>\n",
                            "      <td>W22202</td>\n",
                            "      <td>Member</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2</th>\n",
                            "      <td>715</td>\n",
                            "      <td>2016-01-01 00:13:52</td>\n",
                            "      <td>2016-01-01 00:25:48</td>\n",
                            "      <td>31222</td>\n",
                            "      <td>New York Ave &amp; 15th St NW</td>\n",
                            "      <td>31214</td>\n",
                            "      <td>17th &amp; Corcoran St NW</td>\n",
                            "      <td>W21427</td>\n",
                            "      <td>Member</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>3</th>\n",
                            "      <td>213</td>\n",
                            "      <td>2016-01-01 00:15:29</td>\n",
                            "      <td>2016-01-01 00:19:03</td>\n",
                            "      <td>31506</td>\n",
                            "      <td>1st &amp; Rhode Island Ave NW</td>\n",
                            "      <td>31509</td>\n",
                            "      <td>New Jersey Ave &amp; R St NW</td>\n",
                            "      <td>W01294</td>\n",
                            "      <td>Member</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>4</th>\n",
                            "      <td>872</td>\n",
                            "      <td>2016-01-01 00:16:16</td>\n",
                            "      <td>2016-01-01 00:30:49</td>\n",
                            "      <td>31041</td>\n",
                            "      <td>Prince St &amp; Union St</td>\n",
                            "      <td>31048</td>\n",
                            "      <td>King St Metro South</td>\n",
                            "      <td>W22058</td>\n",
                            "      <td>Member</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 5
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 6,
            "source": [
                "dataframe_tripdata['Member type'] = np.where((dataframe_tripdata['Member type'] == \"Member\"), 1, dataframe_tripdata[\"Member type\"])\n",
                "dataframe_tripdata['Member type'] = np.where((dataframe_tripdata['Member type'] == \"Casual\"), 0, dataframe_tripdata[\"Member type\"])\n",
                "dataframe_tripdata.head()"
            ],
            "outputs": [
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "   Duration           Start date             End date  Start station number  \\\n",
                            "0       166  2016-01-01 00:06:58  2016-01-01 00:09:44                 31102   \n",
                            "1       448  2016-01-01 00:10:20  2016-01-01 00:17:48                 32039   \n",
                            "2       715  2016-01-01 00:13:52  2016-01-01 00:25:48                 31222   \n",
                            "3       213  2016-01-01 00:15:29  2016-01-01 00:19:03                 31506   \n",
                            "4       872  2016-01-01 00:16:16  2016-01-01 00:30:49                 31041   \n",
                            "\n",
                            "                      Start station  End station number  \\\n",
                            "0               11th & Kenyon St NW               31105   \n",
                            "1  Old Georgetown Rd & Southwick St               32002   \n",
                            "2         New York Ave & 15th St NW               31214   \n",
                            "3         1st & Rhode Island Ave NW               31509   \n",
                            "4              Prince St & Union St               31048   \n",
                            "\n",
                            "                   End station Bike number Member type  \n",
                            "0         14th & Harvard St NW      W01346           1  \n",
                            "1  Bethesda Ave & Arlington Rd      W22202           1  \n",
                            "2        17th & Corcoran St NW      W21427           1  \n",
                            "3     New Jersey Ave & R St NW      W01294           1  \n",
                            "4          King St Metro South      W22058           1  "
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>Duration</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>166</td>\n",
                            "      <td>2016-01-01 00:06:58</td>\n",
                            "      <td>2016-01-01 00:09:44</td>\n",
                            "      <td>31102</td>\n",
                            "      <td>11th &amp; Kenyon St NW</td>\n",
                            "      <td>31105</td>\n",
                            "      <td>14th &amp; Harvard St NW</td>\n",
                            "      <td>W01346</td>\n",
                            "      <td>1</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1</th>\n",
                            "      <td>448</td>\n",
                            "      <td>2016-01-01 00:10:20</td>\n",
                            "      <td>2016-01-01 00:17:48</td>\n",
                            "      <td>32039</td>\n",
                            "      <td>Old Georgetown Rd &amp; Southwick St</td>\n",
                            "      <td>32002</td>\n",
                            "      <td>Bethesda Ave &amp; Arlington Rd</td>\n",
                            "      <td>W22202</td>\n",
                            "      <td>1</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2</th>\n",
                            "      <td>715</td>\n",
                            "      <td>2016-01-01 00:13:52</td>\n",
                            "      <td>2016-01-01 00:25:48</td>\n",
                            "      <td>31222</td>\n",
                            "      <td>New York Ave &amp; 15th St NW</td>\n",
                            "      <td>31214</td>\n",
                            "      <td>17th &amp; Corcoran St NW</td>\n",
                            "      <td>W21427</td>\n",
                            "      <td>1</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>3</th>\n",
                            "      <td>213</td>\n",
                            "      <td>2016-01-01 00:15:29</td>\n",
                            "      <td>2016-01-01 00:19:03</td>\n",
                            "      <td>31506</td>\n",
                            "      <td>1st &amp; Rhode Island Ave NW</td>\n",
                            "      <td>31509</td>\n",
                            "      <td>New Jersey Ave &amp; R St NW</td>\n",
                            "      <td>W01294</td>\n",
                            "      <td>1</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>4</th>\n",
                            "      <td>872</td>\n",
                            "      <td>2016-01-01 00:16:16</td>\n",
                            "      <td>2016-01-01 00:30:49</td>\n",
                            "      <td>31041</td>\n",
                            "      <td>Prince St &amp; Union St</td>\n",
                            "      <td>31048</td>\n",
                            "      <td>King St Metro South</td>\n",
                            "      <td>W22058</td>\n",
                            "      <td>1</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 6
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 7,
            "source": [
                "dataframe_tripdata[\"Member type\"].describe()"
            ],
            "outputs": [
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "count     552399\n",
                            "unique         2\n",
                            "top            1\n",
                            "freq      467432\n",
                            "Name: Member type, dtype: int64"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 7
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 8,
            "source": [
                "dataframe_tripdata.isna().head()"
            ],
            "outputs": [
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "   Duration  Start date  End date  Start station number  Start station  \\\n",
                            "0     False       False     False                 False          False   \n",
                            "1     False       False     False                 False          False   \n",
                            "2     False       False     False                 False          False   \n",
                            "3     False       False     False                 False          False   \n",
                            "4     False       False     False                 False          False   \n",
                            "\n",
                            "   End station number  End station  Bike number  Member type  \n",
                            "0               False        False        False        False  \n",
                            "1               False        False        False        False  \n",
                            "2               False        False        False        False  \n",
                            "3               False        False        False        False  \n",
                            "4               False        False        False        False  "
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>Duration</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>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1</th>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2</th>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>3</th>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>4</th>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "      <td>False</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 8
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [
                "### Total of clients by the type"
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 9,
            "source": [
                "dataframe_tripdata_mean = dataframe_tripdata[['Duration','Member type']].groupby(['Member type'], as_index=False).count().sort_values(by='Member type', ascending=False)\n",
                "dataframe_tripdata_mean"
            ],
            "outputs": [
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "   Member type  Duration\n",
                            "1            1    467432\n",
                            "0            0     84967"
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>Member type</th>\n",
                            "      <th>Duration</th>\n",
                            "    </tr>\n",
                            "  </thead>\n",
                            "  <tbody>\n",
                            "    <tr>\n",
                            "      <th>1</th>\n",
                            "      <td>1</td>\n",
                            "      <td>467432</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>0</th>\n",
                            "      <td>0</td>\n",
                            "      <td>84967</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 9
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [
                "### DataFrame Casual Clients"
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 11,
            "source": [
                "dataframe_casualclients = dataframe_tripdata[dataframe_tripdata['Member type'] == 0]\n",
                "print('dataframe_casualclients Length: ',len(dataframe_casualclients))\n",
                "dataframe_casualclients.head()"
            ],
            "outputs": [
                {
                    "output_type": "stream",
                    "name": "stdout",
                    "text": [
                        "dataframe_casualclients Length:  84967\n"
                    ]
                },
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "    Duration           Start date             End date  Start station number  \\\n",
                            "5        859  2016-01-01 00:16:18  2016-01-01 00:30:37                 31041   \n",
                            "11       278  2016-01-01 00:27:26  2016-01-01 00:32:05                 31231   \n",
                            "23      2018  2016-01-01 00:32:51  2016-01-01 01:06:30                 31246   \n",
                            "35      1285  2016-01-01 00:39:53  2016-01-01 01:01:18                 31632   \n",
                            "39      1187  2016-01-01 00:43:49  2016-01-01 01:03:36                 31258   \n",
                            "\n",
                            "                              Start station  End station number  \\\n",
                            "5                      Prince St & Union St               31048   \n",
                            "11  14th & D St NW / Ronald Reagan Building               31262   \n",
                            "23               M St & Pennsylvania Ave NW               31513   \n",
                            "35                           15th & F St NE               31632   \n",
                            "39                         Lincoln Memorial               31077   \n",
                            "\n",
                            "                              End station Bike number Member type  \n",
                            "5                     King St Metro South      W01122           0  \n",
                            "11                         11th & F St NW      W00922           0  \n",
                            "23             Rhode Island Ave & V St NE      W22120           0  \n",
                            "35                         15th & F St NE      W21072           0  \n",
                            "39  Iwo Jima Memorial/N Meade & 14th St N      W20562           0  "
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>Duration</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>5</th>\n",
                            "      <td>859</td>\n",
                            "      <td>2016-01-01 00:16:18</td>\n",
                            "      <td>2016-01-01 00:30:37</td>\n",
                            "      <td>31041</td>\n",
                            "      <td>Prince St &amp; Union St</td>\n",
                            "      <td>31048</td>\n",
                            "      <td>King St Metro South</td>\n",
                            "      <td>W01122</td>\n",
                            "      <td>0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>11</th>\n",
                            "      <td>278</td>\n",
                            "      <td>2016-01-01 00:27:26</td>\n",
                            "      <td>2016-01-01 00:32:05</td>\n",
                            "      <td>31231</td>\n",
                            "      <td>14th &amp; D St NW / Ronald Reagan Building</td>\n",
                            "      <td>31262</td>\n",
                            "      <td>11th &amp; F St NW</td>\n",
                            "      <td>W00922</td>\n",
                            "      <td>0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>23</th>\n",
                            "      <td>2018</td>\n",
                            "      <td>2016-01-01 00:32:51</td>\n",
                            "      <td>2016-01-01 01:06:30</td>\n",
                            "      <td>31246</td>\n",
                            "      <td>M St &amp; Pennsylvania Ave NW</td>\n",
                            "      <td>31513</td>\n",
                            "      <td>Rhode Island Ave &amp; V St NE</td>\n",
                            "      <td>W22120</td>\n",
                            "      <td>0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>35</th>\n",
                            "      <td>1285</td>\n",
                            "      <td>2016-01-01 00:39:53</td>\n",
                            "      <td>2016-01-01 01:01:18</td>\n",
                            "      <td>31632</td>\n",
                            "      <td>15th &amp; F St NE</td>\n",
                            "      <td>31632</td>\n",
                            "      <td>15th &amp; F St NE</td>\n",
                            "      <td>W21072</td>\n",
                            "      <td>0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>39</th>\n",
                            "      <td>1187</td>\n",
                            "      <td>2016-01-01 00:43:49</td>\n",
                            "      <td>2016-01-01 01:03:36</td>\n",
                            "      <td>31258</td>\n",
                            "      <td>Lincoln Memorial</td>\n",
                            "      <td>31077</td>\n",
                            "      <td>Iwo Jima Memorial/N Meade &amp; 14th St N</td>\n",
                            "      <td>W20562</td>\n",
                            "      <td>0</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 11
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [
                "### DataFrame Member Clients"
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 12,
            "source": [
                "dataframe_memberclients = dataframe_tripdata[dataframe_tripdata['Member type'] == 1]\n",
                "print('dataframe_memberclients Length: ',len(dataframe_memberclients))\n",
                "dataframe_memberclients.head()"
            ],
            "outputs": [
                {
                    "output_type": "stream",
                    "name": "stdout",
                    "text": [
                        "dataframe_memberclients Length:  467432\n"
                    ]
                },
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "   Duration           Start date             End date  Start station number  \\\n",
                            "0       166  2016-01-01 00:06:58  2016-01-01 00:09:44                 31102   \n",
                            "1       448  2016-01-01 00:10:20  2016-01-01 00:17:48                 32039   \n",
                            "2       715  2016-01-01 00:13:52  2016-01-01 00:25:48                 31222   \n",
                            "3       213  2016-01-01 00:15:29  2016-01-01 00:19:03                 31506   \n",
                            "4       872  2016-01-01 00:16:16  2016-01-01 00:30:49                 31041   \n",
                            "\n",
                            "                      Start station  End station number  \\\n",
                            "0               11th & Kenyon St NW               31105   \n",
                            "1  Old Georgetown Rd & Southwick St               32002   \n",
                            "2         New York Ave & 15th St NW               31214   \n",
                            "3         1st & Rhode Island Ave NW               31509   \n",
                            "4              Prince St & Union St               31048   \n",
                            "\n",
                            "                   End station Bike number Member type  \n",
                            "0         14th & Harvard St NW      W01346           1  \n",
                            "1  Bethesda Ave & Arlington Rd      W22202           1  \n",
                            "2        17th & Corcoran St NW      W21427           1  \n",
                            "3     New Jersey Ave & R St NW      W01294           1  \n",
                            "4          King St Metro South      W22058           1  "
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>Duration</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>166</td>\n",
                            "      <td>2016-01-01 00:06:58</td>\n",
                            "      <td>2016-01-01 00:09:44</td>\n",
                            "      <td>31102</td>\n",
                            "      <td>11th &amp; Kenyon St NW</td>\n",
                            "      <td>31105</td>\n",
                            "      <td>14th &amp; Harvard St NW</td>\n",
                            "      <td>W01346</td>\n",
                            "      <td>1</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1</th>\n",
                            "      <td>448</td>\n",
                            "      <td>2016-01-01 00:10:20</td>\n",
                            "      <td>2016-01-01 00:17:48</td>\n",
                            "      <td>32039</td>\n",
                            "      <td>Old Georgetown Rd &amp; Southwick St</td>\n",
                            "      <td>32002</td>\n",
                            "      <td>Bethesda Ave &amp; Arlington Rd</td>\n",
                            "      <td>W22202</td>\n",
                            "      <td>1</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2</th>\n",
                            "      <td>715</td>\n",
                            "      <td>2016-01-01 00:13:52</td>\n",
                            "      <td>2016-01-01 00:25:48</td>\n",
                            "      <td>31222</td>\n",
                            "      <td>New York Ave &amp; 15th St NW</td>\n",
                            "      <td>31214</td>\n",
                            "      <td>17th &amp; Corcoran St NW</td>\n",
                            "      <td>W21427</td>\n",
                            "      <td>1</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>3</th>\n",
                            "      <td>213</td>\n",
                            "      <td>2016-01-01 00:15:29</td>\n",
                            "      <td>2016-01-01 00:19:03</td>\n",
                            "      <td>31506</td>\n",
                            "      <td>1st &amp; Rhode Island Ave NW</td>\n",
                            "      <td>31509</td>\n",
                            "      <td>New Jersey Ave &amp; R St NW</td>\n",
                            "      <td>W01294</td>\n",
                            "      <td>1</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>4</th>\n",
                            "      <td>872</td>\n",
                            "      <td>2016-01-01 00:16:16</td>\n",
                            "      <td>2016-01-01 00:30:49</td>\n",
                            "      <td>31041</td>\n",
                            "      <td>Prince St &amp; Union St</td>\n",
                            "      <td>31048</td>\n",
                            "      <td>King St Metro South</td>\n",
                            "      <td>W22058</td>\n",
                            "      <td>1</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 12
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [
                "### DataFrame Total Casual Clients By Stations"
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 13,
            "source": [
                "dataframe_casual_by_station = dataframe_casualclients.groupby('Start station number')['Member type'].count().reset_index()\n",
                "dataframe_casual_by_station.rename(columns={'Start station number':'station_id','Member type':'total'}, inplace=True)\n",
                "print('dataframe_casual_by_station Length: ',len(dataframe_casual_by_station))\n",
                "dataframe_casual_by_station.head()"
            ],
            "outputs": [
                {
                    "output_type": "stream",
                    "name": "stdout",
                    "text": [
                        "dataframe_casual_by_station Length:  355\n"
                    ]
                },
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "   station_id  total\n",
                            "0       31000     73\n",
                            "1       31001     75\n",
                            "2       31002    225\n",
                            "3       31003    199\n",
                            "4       31004     16"
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>station_id</th>\n",
                            "      <th>total</th>\n",
                            "    </tr>\n",
                            "  </thead>\n",
                            "  <tbody>\n",
                            "    <tr>\n",
                            "      <th>0</th>\n",
                            "      <td>31000</td>\n",
                            "      <td>73</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1</th>\n",
                            "      <td>31001</td>\n",
                            "      <td>75</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2</th>\n",
                            "      <td>31002</td>\n",
                            "      <td>225</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>3</th>\n",
                            "      <td>31003</td>\n",
                            "      <td>199</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>4</th>\n",
                            "      <td>31004</td>\n",
                            "      <td>16</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 13
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [
                "### DataFrame Member Clients By Stations"
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 14,
            "source": [
                "dataframe_member_by_station = dataframe_memberclients.groupby('Start station number')['Member type'].count().reset_index()\n",
                "dataframe_member_by_station.rename(columns={'Start station number':'station_id','Member type':'total'}, inplace=True)\n",
                "print('dataframe_member_by_station Length: ',len(dataframe_member_by_station))\n",
                "dataframe_member_by_station.head()"
            ],
            "outputs": [
                {
                    "output_type": "stream",
                    "name": "stdout",
                    "text": [
                        "dataframe_member_by_station Length:  370\n"
                    ]
                },
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "   station_id  total\n",
                            "0       31000    226\n",
                            "1       31001    294\n",
                            "2       31002    695\n",
                            "3       31003    713\n",
                            "4       31004    657"
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>station_id</th>\n",
                            "      <th>total</th>\n",
                            "    </tr>\n",
                            "  </thead>\n",
                            "  <tbody>\n",
                            "    <tr>\n",
                            "      <th>0</th>\n",
                            "      <td>31000</td>\n",
                            "      <td>226</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1</th>\n",
                            "      <td>31001</td>\n",
                            "      <td>294</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2</th>\n",
                            "      <td>31002</td>\n",
                            "      <td>695</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>3</th>\n",
                            "      <td>31003</td>\n",
                            "      <td>713</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>4</th>\n",
                            "      <td>31004</td>\n",
                            "      <td>657</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 14
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [
                "# Day Users\n",
                "## Morning Clients\n",
                "6am ~ 9am"
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 15,
            "source": [
                "dataframe_morning_clients = dataframe_tripdata.copy()\n",
                "dataframe_morning_clients['Start date'] = pd.to_datetime(dataframe_morning_clients['Start date'])\n",
                "dataframe_morning_clients.set_index('Start date',inplace=True)\n",
                "dataframe_morning_clients = dataframe_morning_clients.between_time('06:00:00','09:00:00')\n",
                "print('Total Morning Clients: ',len(dataframe_morning_clients))\n",
                "dataframe_morning_clients.head()"
            ],
            "outputs": [
                {
                    "output_type": "stream",
                    "name": "stdout",
                    "text": [
                        "Total Morning Clients:  95095\n"
                    ]
                },
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "                     Duration             End date  Start station number  \\\n",
                            "Start date                                                                 \n",
                            "2016-01-01 06:10:51       468  2016-01-01 06:18:39                 31600   \n",
                            "2016-01-01 06:19:47       271  2016-01-01 06:24:18                 31047   \n",
                            "2016-01-01 06:28:01       344  2016-01-01 06:33:46                 31117   \n",
                            "2016-01-01 06:31:06      1132  2016-01-01 06:49:58                 31026   \n",
                            "2016-01-01 06:31:13      1406  2016-01-01 06:54:40                 31117   \n",
                            "\n",
                            "                                   Start station  End station number  \\\n",
                            "Start date                                                             \n",
                            "2016-01-01 06:10:51                5th & K St NW               31200   \n",
                            "2016-01-01 06:19:47            Braddock Rd Metro               31048   \n",
                            "2016-01-01 06:28:01         15th & Euclid St  NW               31201   \n",
                            "2016-01-01 06:31:06  Washington Blvd & 10th St N               31076   \n",
                            "2016-01-01 06:31:13         15th & Euclid St  NW               31108   \n",
                            "\n",
                            "                                                           End station  \\\n",
                            "Start date                                                               \n",
                            "2016-01-01 06:10:51               Massachusetts Ave & Dupont Circle NW   \n",
                            "2016-01-01 06:19:47                                King St Metro South   \n",
                            "2016-01-01 06:28:01                                     15th & P St NW   \n",
                            "2016-01-01 06:31:06  Shirlington Transit Center / S Quincy & Randol...   \n",
                            "2016-01-01 06:31:13                                      4th & M St SW   \n",
                            "\n",
                            "                    Bike number Member type  \n",
                            "Start date                                   \n",
                            "2016-01-01 06:10:51      W20027           1  \n",
                            "2016-01-01 06:19:47      W00503           1  \n",
                            "2016-01-01 06:28:01      W21372           1  \n",
                            "2016-01-01 06:31:06      W21086           0  \n",
                            "2016-01-01 06:31:13      W01030           1  "
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>Duration</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",
                            "    <tr>\n",
                            "      <th>Start date</th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "    </tr>\n",
                            "  </thead>\n",
                            "  <tbody>\n",
                            "    <tr>\n",
                            "      <th>2016-01-01 06:10:51</th>\n",
                            "      <td>468</td>\n",
                            "      <td>2016-01-01 06:18:39</td>\n",
                            "      <td>31600</td>\n",
                            "      <td>5th &amp; K St NW</td>\n",
                            "      <td>31200</td>\n",
                            "      <td>Massachusetts Ave &amp; Dupont Circle NW</td>\n",
                            "      <td>W20027</td>\n",
                            "      <td>1</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2016-01-01 06:19:47</th>\n",
                            "      <td>271</td>\n",
                            "      <td>2016-01-01 06:24:18</td>\n",
                            "      <td>31047</td>\n",
                            "      <td>Braddock Rd Metro</td>\n",
                            "      <td>31048</td>\n",
                            "      <td>King St Metro South</td>\n",
                            "      <td>W00503</td>\n",
                            "      <td>1</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2016-01-01 06:28:01</th>\n",
                            "      <td>344</td>\n",
                            "      <td>2016-01-01 06:33:46</td>\n",
                            "      <td>31117</td>\n",
                            "      <td>15th &amp; Euclid St  NW</td>\n",
                            "      <td>31201</td>\n",
                            "      <td>15th &amp; P St NW</td>\n",
                            "      <td>W21372</td>\n",
                            "      <td>1</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2016-01-01 06:31:06</th>\n",
                            "      <td>1132</td>\n",
                            "      <td>2016-01-01 06:49:58</td>\n",
                            "      <td>31026</td>\n",
                            "      <td>Washington Blvd &amp; 10th St N</td>\n",
                            "      <td>31076</td>\n",
                            "      <td>Shirlington Transit Center / S Quincy &amp; Randol...</td>\n",
                            "      <td>W21086</td>\n",
                            "      <td>0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2016-01-01 06:31:13</th>\n",
                            "      <td>1406</td>\n",
                            "      <td>2016-01-01 06:54:40</td>\n",
                            "      <td>31117</td>\n",
                            "      <td>15th &amp; Euclid St  NW</td>\n",
                            "      <td>31108</td>\n",
                            "      <td>4th &amp; M St SW</td>\n",
                            "      <td>W01030</td>\n",
                            "      <td>1</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 15
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 16,
            "source": [
                "dataframe_morning_clients_total_by_type = dataframe_morning_clients.groupby('Member type')['Duration'].count().reset_index()\n",
                "dataframe_morning_clients_total_by_type.rename(columns={'Duration':'Total'}, inplace=True)\n",
                "dataframe_morning_clients_total_by_type"
            ],
            "outputs": [
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "   Member type  Total\n",
                            "0            0   3273\n",
                            "1            1  91822"
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>Member type</th>\n",
                            "      <th>Total</th>\n",
                            "    </tr>\n",
                            "  </thead>\n",
                            "  <tbody>\n",
                            "    <tr>\n",
                            "      <th>0</th>\n",
                            "      <td>0</td>\n",
                            "      <td>3273</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1</th>\n",
                            "      <td>1</td>\n",
                            "      <td>91822</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 16
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [
                "## Lunch Clients \n",
                "12am ~ 14pm"
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 17,
            "source": [
                "dataframe_lunch_clients = dataframe_tripdata.copy()\n",
                "dataframe_lunch_clients['Start date'] = pd.to_datetime(dataframe_lunch_clients['Start date'])\n",
                "dataframe_lunch_clients.set_index('Start date',inplace=True)\n",
                "dataframe_lunch_clients = dataframe_lunch_clients.between_time('12:00:00','14:00:00')\n",
                "print('Total LunchTime Clients: ',len(dataframe_lunch_clients))\n",
                "dataframe_lunch_clients.head()"
            ],
            "outputs": [
                {
                    "output_type": "stream",
                    "name": "stdout",
                    "text": [
                        "Total LunchTime Clients:  61398\n"
                    ]
                },
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "                     Duration             End date  Start station number  \\\n",
                            "Start date                                                                 \n",
                            "2016-01-01 12:00:07      1358  2016-01-01 12:22:45                 31242   \n",
                            "2016-01-01 12:00:11      1334  2016-01-01 12:22:26                 31242   \n",
                            "2016-01-01 12:00:13       234  2016-01-01 12:04:08                 31619   \n",
                            "2016-01-01 12:00:20      8377  2016-01-01 14:19:58                 31618   \n",
                            "2016-01-01 12:00:21       392  2016-01-01 12:06:53                 31245   \n",
                            "\n",
                            "                                                 Start station  \\\n",
                            "Start date                                                       \n",
                            "2016-01-01 12:00:07              18th St & Pennsylvania Ave NW   \n",
                            "2016-01-01 12:00:11              18th St & Pennsylvania Ave NW   \n",
                            "2016-01-01 12:00:13  Lincoln Park / 13th & East Capitol St NE    \n",
                            "2016-01-01 12:00:20                   4th & East Capitol St NE   \n",
                            "2016-01-01 12:00:21               7th & R St NW / Shaw Library   \n",
                            "\n",
                            "                     End station number  \\\n",
                            "Start date                                \n",
                            "2016-01-01 12:00:07               31248   \n",
                            "2016-01-01 12:00:11               31248   \n",
                            "2016-01-01 12:00:13               31612   \n",
                            "2016-01-01 12:00:20               31639   \n",
                            "2016-01-01 12:00:21               31232   \n",
                            "\n",
                            "                                                           End station  \\\n",
                            "Start date                                                               \n",
                            "2016-01-01 12:00:07  Smithsonian-National Mall / Jefferson Dr & 12t...   \n",
                            "2016-01-01 12:00:11  Smithsonian-National Mall / Jefferson Dr & 12t...   \n",
                            "2016-01-01 12:00:13                             D St & Maryland Ave NE   \n",
                            "2016-01-01 12:00:20                                      2nd & G St NE   \n",
                            "2016-01-01 12:00:21          7th & F St NW / National Portrait Gallery   \n",
                            "\n",
                            "                    Bike number Member type  \n",
                            "Start date                                   \n",
                            "2016-01-01 12:00:07      W20537           0  \n",
                            "2016-01-01 12:00:11      W20312           0  \n",
                            "2016-01-01 12:00:13      W20463           1  \n",
                            "2016-01-01 12:00:20      W00172           1  \n",
                            "2016-01-01 12:00:21      W21769           1  "
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>Duration</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",
                            "    <tr>\n",
                            "      <th>Start date</th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "    </tr>\n",
                            "  </thead>\n",
                            "  <tbody>\n",
                            "    <tr>\n",
                            "      <th>2016-01-01 12:00:07</th>\n",
                            "      <td>1358</td>\n",
                            "      <td>2016-01-01 12:22:45</td>\n",
                            "      <td>31242</td>\n",
                            "      <td>18th St &amp; Pennsylvania Ave NW</td>\n",
                            "      <td>31248</td>\n",
                            "      <td>Smithsonian-National Mall / Jefferson Dr &amp; 12t...</td>\n",
                            "      <td>W20537</td>\n",
                            "      <td>0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2016-01-01 12:00:11</th>\n",
                            "      <td>1334</td>\n",
                            "      <td>2016-01-01 12:22:26</td>\n",
                            "      <td>31242</td>\n",
                            "      <td>18th St &amp; Pennsylvania Ave NW</td>\n",
                            "      <td>31248</td>\n",
                            "      <td>Smithsonian-National Mall / Jefferson Dr &amp; 12t...</td>\n",
                            "      <td>W20312</td>\n",
                            "      <td>0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2016-01-01 12:00:13</th>\n",
                            "      <td>234</td>\n",
                            "      <td>2016-01-01 12:04:08</td>\n",
                            "      <td>31619</td>\n",
                            "      <td>Lincoln Park / 13th &amp; East Capitol St NE</td>\n",
                            "      <td>31612</td>\n",
                            "      <td>D St &amp; Maryland Ave NE</td>\n",
                            "      <td>W20463</td>\n",
                            "      <td>1</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2016-01-01 12:00:20</th>\n",
                            "      <td>8377</td>\n",
                            "      <td>2016-01-01 14:19:58</td>\n",
                            "      <td>31618</td>\n",
                            "      <td>4th &amp; East Capitol St NE</td>\n",
                            "      <td>31639</td>\n",
                            "      <td>2nd &amp; G St NE</td>\n",
                            "      <td>W00172</td>\n",
                            "      <td>1</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2016-01-01 12:00:21</th>\n",
                            "      <td>392</td>\n",
                            "      <td>2016-01-01 12:06:53</td>\n",
                            "      <td>31245</td>\n",
                            "      <td>7th &amp; R St NW / Shaw Library</td>\n",
                            "      <td>31232</td>\n",
                            "      <td>7th &amp; F St NW / National Portrait Gallery</td>\n",
                            "      <td>W21769</td>\n",
                            "      <td>1</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 17
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 18,
            "source": [
                "dataframe_lunch_clients_total_by_type = dataframe_lunch_clients.groupby('Member type')['Duration'].count().reset_index()\n",
                "dataframe_lunch_clients_total_by_type.rename(columns={'Duration':'Total'}, inplace=True)\n",
                "dataframe_lunch_clients_total_by_type"
            ],
            "outputs": [
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "   Member type  Total\n",
                            "0            0  15889\n",
                            "1            1  45509"
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>Member type</th>\n",
                            "      <th>Total</th>\n",
                            "    </tr>\n",
                            "  </thead>\n",
                            "  <tbody>\n",
                            "    <tr>\n",
                            "      <th>0</th>\n",
                            "      <td>0</td>\n",
                            "      <td>15889</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1</th>\n",
                            "      <td>1</td>\n",
                            "      <td>45509</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 18
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [
                "## Go Night Clients\n",
                "18pm ~ 20pm"
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 19,
            "source": [
                "dataframe_night_clients = dataframe_tripdata.copy()\n",
                "dataframe_night_clients['Start date'] = pd.to_datetime(dataframe_night_clients['Start date'])\n",
                "dataframe_night_clients.set_index('Start date',inplace=True)\n",
                "dataframe_night_clients = dataframe_night_clients.between_time('18:00:00','20:00:00')\n",
                "print('Total Night Clients: ',len(dataframe_night_clients))\n",
                "dataframe_night_clients.head()"
            ],
            "outputs": [
                {
                    "output_type": "stream",
                    "name": "stdout",
                    "text": [
                        "Total Night Clients:  85083\n"
                    ]
                },
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "                     Duration             End date  Start station number  \\\n",
                            "Start date                                                                 \n",
                            "2016-01-01 18:01:54       229  2016-01-01 18:05:44                 31109   \n",
                            "2016-01-01 18:02:04       384  2016-01-01 18:08:29                 31202   \n",
                            "2016-01-01 18:02:26      1161  2016-01-01 18:21:48                 31103   \n",
                            "2016-01-01 18:02:29       516  2016-01-01 18:11:06                 31229   \n",
                            "2016-01-01 18:02:32      1162  2016-01-01 18:21:54                 31103   \n",
                            "\n",
                            "                                   Start station  End station number  \\\n",
                            "Start date                                                             \n",
                            "2016-01-01 18:01:54                7th & T St NW               31506   \n",
                            "2016-01-01 18:02:04               14th & R St NW               31116   \n",
                            "2016-01-01 18:02:26         16th & Harvard St NW               31276   \n",
                            "2016-01-01 18:02:29  New Hampshire Ave & T St NW               31509   \n",
                            "2016-01-01 18:02:32         16th & Harvard St NW               31276   \n",
                            "\n",
                            "                                        End station Bike number Member type  \n",
                            "Start date                                                                   \n",
                            "2016-01-01 18:01:54       1st & Rhode Island Ave NW      W00272           1  \n",
                            "2016-01-01 18:02:04  California St & Florida Ave NW      W20429           1  \n",
                            "2016-01-01 18:02:26                  15th & L St NW      W00129           0  \n",
                            "2016-01-01 18:02:29        New Jersey Ave & R St NW      W00153           1  \n",
                            "2016-01-01 18:02:32                  15th & L St NW      W22180           0  "
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>Duration</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",
                            "    <tr>\n",
                            "      <th>Start date</th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "      <th></th>\n",
                            "    </tr>\n",
                            "  </thead>\n",
                            "  <tbody>\n",
                            "    <tr>\n",
                            "      <th>2016-01-01 18:01:54</th>\n",
                            "      <td>229</td>\n",
                            "      <td>2016-01-01 18:05:44</td>\n",
                            "      <td>31109</td>\n",
                            "      <td>7th &amp; T St NW</td>\n",
                            "      <td>31506</td>\n",
                            "      <td>1st &amp; Rhode Island Ave NW</td>\n",
                            "      <td>W00272</td>\n",
                            "      <td>1</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2016-01-01 18:02:04</th>\n",
                            "      <td>384</td>\n",
                            "      <td>2016-01-01 18:08:29</td>\n",
                            "      <td>31202</td>\n",
                            "      <td>14th &amp; R St NW</td>\n",
                            "      <td>31116</td>\n",
                            "      <td>California St &amp; Florida Ave NW</td>\n",
                            "      <td>W20429</td>\n",
                            "      <td>1</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2016-01-01 18:02:26</th>\n",
                            "      <td>1161</td>\n",
                            "      <td>2016-01-01 18:21:48</td>\n",
                            "      <td>31103</td>\n",
                            "      <td>16th &amp; Harvard St NW</td>\n",
                            "      <td>31276</td>\n",
                            "      <td>15th &amp; L St NW</td>\n",
                            "      <td>W00129</td>\n",
                            "      <td>0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2016-01-01 18:02:29</th>\n",
                            "      <td>516</td>\n",
                            "      <td>2016-01-01 18:11:06</td>\n",
                            "      <td>31229</td>\n",
                            "      <td>New Hampshire Ave &amp; T St NW</td>\n",
                            "      <td>31509</td>\n",
                            "      <td>New Jersey Ave &amp; R St NW</td>\n",
                            "      <td>W00153</td>\n",
                            "      <td>1</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2016-01-01 18:02:32</th>\n",
                            "      <td>1162</td>\n",
                            "      <td>2016-01-01 18:21:54</td>\n",
                            "      <td>31103</td>\n",
                            "      <td>16th &amp; Harvard St NW</td>\n",
                            "      <td>31276</td>\n",
                            "      <td>15th &amp; L St NW</td>\n",
                            "      <td>W22180</td>\n",
                            "      <td>0</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 19
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 20,
            "source": [
                "dataframe_night_clients_total_by_type = dataframe_night_clients.groupby('Member type')['Duration'].count().reset_index()\n",
                "dataframe_night_clients_total_by_type.rename(columns={'Duration':'Total'}, inplace=True)\n",
                "dataframe_night_clients_total_by_type"
            ],
            "outputs": [
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "   Member type  Total\n",
                            "0            0   8878\n",
                            "1            1  76205"
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>Member type</th>\n",
                            "      <th>Total</th>\n",
                            "    </tr>\n",
                            "  </thead>\n",
                            "  <tbody>\n",
                            "    <tr>\n",
                            "      <th>0</th>\n",
                            "      <td>0</td>\n",
                            "      <td>8878</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1</th>\n",
                            "      <td>1</td>\n",
                            "      <td>76205</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 20
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [
                "## Clients by Day"
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 21,
            "source": [
                "dataframe_casualclients_by_day = dataframe_casualclients.copy()\n",
                "dataframe_casualclients_by_day[\"Start date\"] = pd.to_datetime(dataframe_casualclients_by_day[\"Start date\"])\n",
                "dataframe_casualclients_by_day.set_index(\"Start date\", inplace=True)\n",
                "dataframe_casualclients_by_day = dataframe_casualclients_by_day.groupby(pd.Grouper(freq=\"D\")).count()\n",
                "dataframe_casualclients_by_day.drop(columns=[\"End date\", \"Start station number\", \"Start station\", \"End station number\",\"End station\", \"Bike number\", \"Member type\"], inplace=True)\n",
                "dataframe_casualclients_by_day.rename(columns={\"Duration\":\"Total\"}, inplace=True)\n",
                "dataframe_casualclients_by_day.head()\n"
            ],
            "outputs": [
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "            Total\n",
                            "Start date       \n",
                            "2016-01-01    999\n",
                            "2016-01-02   1522\n",
                            "2016-01-03   1242\n",
                            "2016-01-04    274\n",
                            "2016-01-05    249"
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>Total</th>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>Start date</th>\n",
                            "      <th></th>\n",
                            "    </tr>\n",
                            "  </thead>\n",
                            "  <tbody>\n",
                            "    <tr>\n",
                            "      <th>2016-01-01</th>\n",
                            "      <td>999</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2016-01-02</th>\n",
                            "      <td>1522</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2016-01-03</th>\n",
                            "      <td>1242</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2016-01-04</th>\n",
                            "      <td>274</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2016-01-05</th>\n",
                            "      <td>249</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 21
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 22,
            "source": [
                "dataframe_memberclients_by_day = dataframe_memberclients.copy()\n",
                "dataframe_memberclients_by_day[\"Start date\"] = pd.to_datetime(dataframe_memberclients_by_day[\"Start date\"])\n",
                "dataframe_memberclients_by_day.set_index(\"Start date\", inplace=True)\n",
                "dataframe_memberclients_by_day = dataframe_memberclients_by_day.groupby(pd.Grouper(freq=\"D\")).count()\n",
                "dataframe_memberclients_by_day.drop(columns=[\"End date\", \"Start station number\", \"Start station\", \"End station number\",\"End station\", \"Bike number\", \"Member type\"], inplace=True)\n",
                "dataframe_memberclients_by_day.rename(columns={\"Duration\":\"Total\"}, inplace=True)\n",
                "dataframe_memberclients_by_day.head()"
            ],
            "outputs": [
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "            Total\n",
                            "Start date       \n",
                            "2016-01-01   2221\n",
                            "2016-01-02   3399\n",
                            "2016-01-03   3723\n",
                            "2016-01-04   4859\n",
                            "2016-01-05   4601"
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>Total</th>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>Start date</th>\n",
                            "      <th></th>\n",
                            "    </tr>\n",
                            "  </thead>\n",
                            "  <tbody>\n",
                            "    <tr>\n",
                            "      <th>2016-01-01</th>\n",
                            "      <td>2221</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2016-01-02</th>\n",
                            "      <td>3399</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2016-01-03</th>\n",
                            "      <td>3723</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2016-01-04</th>\n",
                            "      <td>4859</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2016-01-05</th>\n",
                            "      <td>4601</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 22
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [
                "# Most used stations\n",
                "top 10 stations"
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 23,
            "source": [
                "dataframe_sort_stations = dataframe_tripdata.groupby('Start station number')['Duration'].count().reset_index()\n",
                "dataframe_sort_stations.rename(columns={'Start station number':'station_id', 'Duration':'Total'}, inplace=True)\n",
                "dataframe_sort_stations.sort_values(by=['Total'],axis=0,ascending=False,inplace=True)\n",
                "print('Top 10 Stations')\n",
                "dataframe_sort_stations[:10]"
            ],
            "outputs": [
                {
                    "output_type": "stream",
                    "name": "stdout",
                    "text": [
                        "Top 10 Stations\n"
                    ]
                },
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "     station_id  Total\n",
                            "274       31623  13120\n",
                            "123       31200   9560\n",
                            "180       31258   9388\n",
                            "169       31247   8138\n",
                            "163       31241   7479\n",
                            "124       31201   7401\n",
                            "101       31101   6568\n",
                            "151       31229   6491\n",
                            "264       31613   5649\n",
                            "136       31214   5514"
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>station_id</th>\n",
                            "      <th>Total</th>\n",
                            "    </tr>\n",
                            "  </thead>\n",
                            "  <tbody>\n",
                            "    <tr>\n",
                            "      <th>274</th>\n",
                            "      <td>31623</td>\n",
                            "      <td>13120</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>123</th>\n",
                            "      <td>31200</td>\n",
                            "      <td>9560</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>180</th>\n",
                            "      <td>31258</td>\n",
                            "      <td>9388</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>169</th>\n",
                            "      <td>31247</td>\n",
                            "      <td>8138</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>163</th>\n",
                            "      <td>31241</td>\n",
                            "      <td>7479</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>124</th>\n",
                            "      <td>31201</td>\n",
                            "      <td>7401</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>101</th>\n",
                            "      <td>31101</td>\n",
                            "      <td>6568</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>151</th>\n",
                            "      <td>31229</td>\n",
                            "      <td>6491</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>264</th>\n",
                            "      <td>31613</td>\n",
                            "      <td>5649</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>136</th>\n",
                            "      <td>31214</td>\n",
                            "      <td>5514</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 23
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [
                "# Most used bikes\n",
                "top 10 of bikes"
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 24,
            "source": [
                "dataframe_sort_bikes = dataframe_tripdata.groupby('Bike number')['Duration'].count().reset_index()\n",
                "dataframe_sort_bikes.rename(columns={'Bike number':'bike_id', 'Duration':'Total'}, inplace=True)\n",
                "dataframe_sort_bikes.sort_values(by=['Total'],axis=0,ascending=False,inplace=True)\n",
                "print('Top 10 Bikes most used')\n",
                "dataframe_sort_bikes[:10]"
            ],
            "outputs": [
                {
                    "output_type": "stream",
                    "name": "stdout",
                    "text": [
                        "Top 10 Bikes most used\n"
                    ]
                },
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "     bike_id  Total\n",
                            "3017  W21797    345\n",
                            "3400  W22227    337\n",
                            "2845  W21609    337\n",
                            "38    W00045    332\n",
                            "1694  W20384    328\n",
                            "1931  W20632    324\n",
                            "294   W00346    322\n",
                            "1561  W20242    322\n",
                            "2489  W21239    320\n",
                            "2440  W21186    320"
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>bike_id</th>\n",
                            "      <th>Total</th>\n",
                            "    </tr>\n",
                            "  </thead>\n",
                            "  <tbody>\n",
                            "    <tr>\n",
                            "      <th>3017</th>\n",
                            "      <td>W21797</td>\n",
                            "      <td>345</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>3400</th>\n",
                            "      <td>W22227</td>\n",
                            "      <td>337</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2845</th>\n",
                            "      <td>W21609</td>\n",
                            "      <td>337</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>38</th>\n",
                            "      <td>W00045</td>\n",
                            "      <td>332</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1694</th>\n",
                            "      <td>W20384</td>\n",
                            "      <td>328</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1931</th>\n",
                            "      <td>W20632</td>\n",
                            "      <td>324</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>294</th>\n",
                            "      <td>W00346</td>\n",
                            "      <td>322</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1561</th>\n",
                            "      <td>W20242</td>\n",
                            "      <td>322</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2489</th>\n",
                            "      <td>W21239</td>\n",
                            "      <td>320</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2440</th>\n",
                            "      <td>W21186</td>\n",
                            "      <td>320</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 24
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [
                "## Time of use bike\n",
                "Trying to find the total of used bikes\n",
                "looks like it's in seconds\n",
                ">Probably I'll convert to hours or days "
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 25,
            "source": [
                "dataframe_time_used = dataframe_tripdata.groupby('Bike number')['Duration'].sum().reset_index()\n",
                "dataframe_time_used.sort_values(by=['Duration'],axis=0,ascending=False,inplace=True)\n",
                "dataframe_time_used"
            ],
            "outputs": [
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "     Bike number  Duration\n",
                            "1273      W01410    386143\n",
                            "1436      W20098    384611\n",
                            "2503      W21253    368121\n",
                            "364       W00420    367593\n",
                            "2338      W21068    366573\n",
                            "...          ...       ...\n",
                            "2039      W20745       463\n",
                            "1492      W20162       344\n",
                            "820       W00919       262\n",
                            "283       W00335       251\n",
                            "638       W00723       221\n",
                            "\n",
                            "[3442 rows x 2 columns]"
                        ],
                        "text/html": [
                            "<div>\n",
                            "<style scoped>\n",
                            "    .dataframe tbody tr th:only-of-type {\n",
                            "        vertical-align: middle;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe tbody tr th {\n",
                            "        vertical-align: top;\n",
                            "    }\n",
                            "\n",
                            "    .dataframe thead th {\n",
                            "        text-align: right;\n",
                            "    }\n",
                            "</style>\n",
                            "<table border=\"1\" class=\"dataframe\">\n",
                            "  <thead>\n",
                            "    <tr style=\"text-align: right;\">\n",
                            "      <th></th>\n",
                            "      <th>Bike number</th>\n",
                            "      <th>Duration</th>\n",
                            "    </tr>\n",
                            "  </thead>\n",
                            "  <tbody>\n",
                            "    <tr>\n",
                            "      <th>1273</th>\n",
                            "      <td>W01410</td>\n",
                            "      <td>386143</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1436</th>\n",
                            "      <td>W20098</td>\n",
                            "      <td>384611</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2503</th>\n",
                            "      <td>W21253</td>\n",
                            "      <td>368121</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>364</th>\n",
                            "      <td>W00420</td>\n",
                            "      <td>367593</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2338</th>\n",
                            "      <td>W21068</td>\n",
                            "      <td>366573</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>...</th>\n",
                            "      <td>...</td>\n",
                            "      <td>...</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2039</th>\n",
                            "      <td>W20745</td>\n",
                            "      <td>463</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1492</th>\n",
                            "      <td>W20162</td>\n",
                            "      <td>344</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>820</th>\n",
                            "      <td>W00919</td>\n",
                            "      <td>262</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>283</th>\n",
                            "      <td>W00335</td>\n",
                            "      <td>251</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>638</th>\n",
                            "      <td>W00723</td>\n",
                            "      <td>221</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "<p>3442 rows × 2 columns</p>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 25
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [
                "# Time for plot the data\n",
                "Distribution Subscriber Type"
            ],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [
                "## Import maps with GeoPandas\n",
                "Search for Virginia USA"
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": null,
            "source": [
                "usamap = geo.read_file(\"https://raw.githubusercontent.com/PublicaMundi/MappingAPI/master/data/geojson/us-states.json\")"
            ],
            "outputs": [],
            "metadata": {}
        }
    ],
    "metadata": {
        "orig_nbformat": 4,
        "language_info": {
            "name": "python",
            "version": "3.6.9",
            "mimetype": "text/x-python",
            "codemirror_mode": {
                "name": "ipython",
                "version": 3
            },
            "pygments_lexer": "ipython3",
            "nbconvert_exporter": "python",
            "file_extension": ".py"
        },
        "kernelspec": {
            "name": "python3",
            "display_name": "Python 3.6.9 64-bit"
        },
        "interpreter": {
            "hash": "31f2aee4e71d21fbe5cf8b01ff0e069b9275f58929596ceb00d14d90e3e16cd6"
        }
    },
    "nbformat": 4,
    "nbformat_minor": 2
}