gobikeVisualization.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import seaborn as sns\n",
    "sns.set()\n",
    "\n",
    "%matplotlib inline\n",
    "import matplotlib\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "metadata": {},
   "outputs": [],
   "source": [
    "# import data\n",
    "parse_dates=['start_time', 'end_time']\n",
    "df = pd.read_csv('./201902-fordgobike-tripdata.csv', parse_dates=parse_dates)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "metadata": {},
   "outputs": [],
   "source": [
    "# create date col\n",
    "df['trip_date']=df['end_time'].dt.date"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>duration_sec</th>\n",
       "      <th>start_time</th>\n",
       "      <th>end_time</th>\n",
       "      <th>start_station_id</th>\n",
       "      <th>start_station_name</th>\n",
       "      <th>start_station_latitude</th>\n",
       "      <th>start_station_longitude</th>\n",
       "      <th>end_station_id</th>\n",
       "      <th>end_station_name</th>\n",
       "      <th>end_station_latitude</th>\n",
       "      <th>end_station_longitude</th>\n",
       "      <th>bike_id</th>\n",
       "      <th>user_type</th>\n",
       "      <th>member_birth_year</th>\n",
       "      <th>member_gender</th>\n",
       "      <th>bike_share_for_all_trip</th>\n",
       "      <th>trip_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>183407</th>\n",
       "      <td>480</td>\n",
       "      <td>2019-02-01 00:04:49.724</td>\n",
       "      <td>2019-02-01 00:12:50.034</td>\n",
       "      <td>27.0</td>\n",
       "      <td>Beale St at Harrison St</td>\n",
       "      <td>37.788059</td>\n",
       "      <td>-122.391865</td>\n",
       "      <td>324.0</td>\n",
       "      <td>Union Square (Powell St at Post St)</td>\n",
       "      <td>37.788300</td>\n",
       "      <td>-122.408531</td>\n",
       "      <td>4832</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>No</td>\n",
       "      <td>2019-02-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183408</th>\n",
       "      <td>313</td>\n",
       "      <td>2019-02-01 00:05:34.744</td>\n",
       "      <td>2019-02-01 00:10:48.502</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Montgomery St BART Station (Market St at 2nd St)</td>\n",
       "      <td>37.789625</td>\n",
       "      <td>-122.400811</td>\n",
       "      <td>66.0</td>\n",
       "      <td>3rd St at Townsend St</td>\n",
       "      <td>37.778742</td>\n",
       "      <td>-122.392741</td>\n",
       "      <td>4960</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1984.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>No</td>\n",
       "      <td>2019-02-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183409</th>\n",
       "      <td>141</td>\n",
       "      <td>2019-02-01 00:06:05.549</td>\n",
       "      <td>2019-02-01 00:08:27.220</td>\n",
       "      <td>278.0</td>\n",
       "      <td>The Alameda at Bush St</td>\n",
       "      <td>37.331932</td>\n",
       "      <td>-121.904888</td>\n",
       "      <td>277.0</td>\n",
       "      <td>Morrison Ave at Julian St</td>\n",
       "      <td>37.333658</td>\n",
       "      <td>-121.908586</td>\n",
       "      <td>3824</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Yes</td>\n",
       "      <td>2019-02-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183410</th>\n",
       "      <td>139</td>\n",
       "      <td>2019-02-01 00:05:34.360</td>\n",
       "      <td>2019-02-01 00:07:54.287</td>\n",
       "      <td>220.0</td>\n",
       "      <td>San Pablo Ave at MLK Jr Way</td>\n",
       "      <td>37.811351</td>\n",
       "      <td>-122.273422</td>\n",
       "      <td>216.0</td>\n",
       "      <td>San Pablo Ave at 27th St</td>\n",
       "      <td>37.817827</td>\n",
       "      <td>-122.275698</td>\n",
       "      <td>5095</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1988.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>No</td>\n",
       "      <td>2019-02-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183411</th>\n",
       "      <td>271</td>\n",
       "      <td>2019-02-01 00:00:20.636</td>\n",
       "      <td>2019-02-01 00:04:52.058</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Spear St at Folsom St</td>\n",
       "      <td>37.789677</td>\n",
       "      <td>-122.390428</td>\n",
       "      <td>37.0</td>\n",
       "      <td>2nd St at Folsom St</td>\n",
       "      <td>37.785000</td>\n",
       "      <td>-122.395936</td>\n",
       "      <td>1057</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1989.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>No</td>\n",
       "      <td>2019-02-01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        duration_sec              start_time                end_time  \\\n",
       "183407           480 2019-02-01 00:04:49.724 2019-02-01 00:12:50.034   \n",
       "183408           313 2019-02-01 00:05:34.744 2019-02-01 00:10:48.502   \n",
       "183409           141 2019-02-01 00:06:05.549 2019-02-01 00:08:27.220   \n",
       "183410           139 2019-02-01 00:05:34.360 2019-02-01 00:07:54.287   \n",
       "183411           271 2019-02-01 00:00:20.636 2019-02-01 00:04:52.058   \n",
       "\n",
       "        start_station_id                                start_station_name  \\\n",
       "183407              27.0                           Beale St at Harrison St   \n",
       "183408              21.0  Montgomery St BART Station (Market St at 2nd St)   \n",
       "183409             278.0                            The Alameda at Bush St   \n",
       "183410             220.0                       San Pablo Ave at MLK Jr Way   \n",
       "183411              24.0                             Spear St at Folsom St   \n",
       "\n",
       "        start_station_latitude  start_station_longitude  end_station_id  \\\n",
       "183407               37.788059              -122.391865           324.0   \n",
       "183408               37.789625              -122.400811            66.0   \n",
       "183409               37.331932              -121.904888           277.0   \n",
       "183410               37.811351              -122.273422           216.0   \n",
       "183411               37.789677              -122.390428            37.0   \n",
       "\n",
       "                           end_station_name  end_station_latitude  \\\n",
       "183407  Union Square (Powell St at Post St)             37.788300   \n",
       "183408                3rd St at Townsend St             37.778742   \n",
       "183409            Morrison Ave at Julian St             37.333658   \n",
       "183410             San Pablo Ave at 27th St             37.817827   \n",
       "183411                  2nd St at Folsom St             37.785000   \n",
       "\n",
       "        end_station_longitude  bike_id   user_type  member_birth_year  \\\n",
       "183407            -122.408531     4832  Subscriber             1996.0   \n",
       "183408            -122.392741     4960  Subscriber             1984.0   \n",
       "183409            -121.908586     3824  Subscriber             1990.0   \n",
       "183410            -122.275698     5095  Subscriber             1988.0   \n",
       "183411            -122.395936     1057  Subscriber             1989.0   \n",
       "\n",
       "       member_gender bike_share_for_all_trip   trip_date  \n",
       "183407          Male                      No  2019-02-01  \n",
       "183408          Male                      No  2019-02-01  \n",
       "183409          Male                     Yes  2019-02-01  \n",
       "183410          Male                      No  2019-02-01  \n",
       "183411          Male                      No  2019-02-01  "
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# quick summary\n",
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>duration_sec</th>\n",
       "      <th>start_time</th>\n",
       "      <th>end_time</th>\n",
       "      <th>start_station_id</th>\n",
       "      <th>start_station_name</th>\n",
       "      <th>start_station_latitude</th>\n",
       "      <th>start_station_longitude</th>\n",
       "      <th>end_station_id</th>\n",
       "      <th>end_station_name</th>\n",
       "      <th>end_station_latitude</th>\n",
       "      <th>end_station_longitude</th>\n",
       "      <th>bike_id</th>\n",
       "      <th>user_type</th>\n",
       "      <th>member_birth_year</th>\n",
       "      <th>member_gender</th>\n",
       "      <th>bike_share_for_all_trip</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>trip_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",
       "      <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>2019-02-01</th>\n",
       "      <td>6118</td>\n",
       "      <td>6118</td>\n",
       "      <td>6118</td>\n",
       "      <td>6114</td>\n",
       "      <td>6114</td>\n",
       "      <td>6118</td>\n",
       "      <td>6118</td>\n",
       "      <td>6114</td>\n",
       "      <td>6114</td>\n",
       "      <td>6118</td>\n",
       "      <td>6118</td>\n",
       "      <td>6118</td>\n",
       "      <td>6118</td>\n",
       "      <td>5818</td>\n",
       "      <td>5818</td>\n",
       "      <td>6118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-02</th>\n",
       "      <td>3241</td>\n",
       "      <td>3241</td>\n",
       "      <td>3241</td>\n",
       "      <td>3239</td>\n",
       "      <td>3239</td>\n",
       "      <td>3241</td>\n",
       "      <td>3241</td>\n",
       "      <td>3239</td>\n",
       "      <td>3239</td>\n",
       "      <td>3241</td>\n",
       "      <td>3241</td>\n",
       "      <td>3241</td>\n",
       "      <td>3241</td>\n",
       "      <td>3014</td>\n",
       "      <td>3014</td>\n",
       "      <td>3241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-03</th>\n",
       "      <td>2841</td>\n",
       "      <td>2841</td>\n",
       "      <td>2841</td>\n",
       "      <td>2840</td>\n",
       "      <td>2840</td>\n",
       "      <td>2841</td>\n",
       "      <td>2841</td>\n",
       "      <td>2840</td>\n",
       "      <td>2840</td>\n",
       "      <td>2841</td>\n",
       "      <td>2841</td>\n",
       "      <td>2841</td>\n",
       "      <td>2841</td>\n",
       "      <td>2710</td>\n",
       "      <td>2710</td>\n",
       "      <td>2841</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-04</th>\n",
       "      <td>5487</td>\n",
       "      <td>5487</td>\n",
       "      <td>5487</td>\n",
       "      <td>5487</td>\n",
       "      <td>5487</td>\n",
       "      <td>5487</td>\n",
       "      <td>5487</td>\n",
       "      <td>5487</td>\n",
       "      <td>5487</td>\n",
       "      <td>5487</td>\n",
       "      <td>5487</td>\n",
       "      <td>5487</td>\n",
       "      <td>5487</td>\n",
       "      <td>5268</td>\n",
       "      <td>5268</td>\n",
       "      <td>5487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-05</th>\n",
       "      <td>8485</td>\n",
       "      <td>8485</td>\n",
       "      <td>8485</td>\n",
       "      <td>8483</td>\n",
       "      <td>8483</td>\n",
       "      <td>8485</td>\n",
       "      <td>8485</td>\n",
       "      <td>8483</td>\n",
       "      <td>8483</td>\n",
       "      <td>8485</td>\n",
       "      <td>8485</td>\n",
       "      <td>8485</td>\n",
       "      <td>8485</td>\n",
       "      <td>8139</td>\n",
       "      <td>8139</td>\n",
       "      <td>8485</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-06</th>\n",
       "      <td>9056</td>\n",
       "      <td>9056</td>\n",
       "      <td>9056</td>\n",
       "      <td>9051</td>\n",
       "      <td>9051</td>\n",
       "      <td>9056</td>\n",
       "      <td>9056</td>\n",
       "      <td>9051</td>\n",
       "      <td>9051</td>\n",
       "      <td>9056</td>\n",
       "      <td>9056</td>\n",
       "      <td>9056</td>\n",
       "      <td>9056</td>\n",
       "      <td>8658</td>\n",
       "      <td>8658</td>\n",
       "      <td>9056</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-07</th>\n",
       "      <td>9229</td>\n",
       "      <td>9229</td>\n",
       "      <td>9229</td>\n",
       "      <td>9225</td>\n",
       "      <td>9225</td>\n",
       "      <td>9229</td>\n",
       "      <td>9229</td>\n",
       "      <td>9225</td>\n",
       "      <td>9225</td>\n",
       "      <td>9229</td>\n",
       "      <td>9229</td>\n",
       "      <td>9229</td>\n",
       "      <td>9229</td>\n",
       "      <td>8801</td>\n",
       "      <td>8801</td>\n",
       "      <td>9229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-08</th>\n",
       "      <td>6362</td>\n",
       "      <td>6362</td>\n",
       "      <td>6362</td>\n",
       "      <td>6358</td>\n",
       "      <td>6358</td>\n",
       "      <td>6362</td>\n",
       "      <td>6362</td>\n",
       "      <td>6358</td>\n",
       "      <td>6358</td>\n",
       "      <td>6362</td>\n",
       "      <td>6362</td>\n",
       "      <td>6362</td>\n",
       "      <td>6362</td>\n",
       "      <td>6100</td>\n",
       "      <td>6100</td>\n",
       "      <td>6362</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-09</th>\n",
       "      <td>2732</td>\n",
       "      <td>2732</td>\n",
       "      <td>2732</td>\n",
       "      <td>2723</td>\n",
       "      <td>2723</td>\n",
       "      <td>2732</td>\n",
       "      <td>2732</td>\n",
       "      <td>2723</td>\n",
       "      <td>2723</td>\n",
       "      <td>2732</td>\n",
       "      <td>2732</td>\n",
       "      <td>2732</td>\n",
       "      <td>2732</td>\n",
       "      <td>2560</td>\n",
       "      <td>2560</td>\n",
       "      <td>2732</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-10</th>\n",
       "      <td>3953</td>\n",
       "      <td>3953</td>\n",
       "      <td>3953</td>\n",
       "      <td>3943</td>\n",
       "      <td>3943</td>\n",
       "      <td>3953</td>\n",
       "      <td>3953</td>\n",
       "      <td>3943</td>\n",
       "      <td>3943</td>\n",
       "      <td>3953</td>\n",
       "      <td>3953</td>\n",
       "      <td>3953</td>\n",
       "      <td>3953</td>\n",
       "      <td>3700</td>\n",
       "      <td>3700</td>\n",
       "      <td>3953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-11</th>\n",
       "      <td>8679</td>\n",
       "      <td>8679</td>\n",
       "      <td>8679</td>\n",
       "      <td>8662</td>\n",
       "      <td>8662</td>\n",
       "      <td>8679</td>\n",
       "      <td>8679</td>\n",
       "      <td>8662</td>\n",
       "      <td>8662</td>\n",
       "      <td>8679</td>\n",
       "      <td>8679</td>\n",
       "      <td>8679</td>\n",
       "      <td>8679</td>\n",
       "      <td>8331</td>\n",
       "      <td>8331</td>\n",
       "      <td>8679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-12</th>\n",
       "      <td>8481</td>\n",
       "      <td>8481</td>\n",
       "      <td>8481</td>\n",
       "      <td>8474</td>\n",
       "      <td>8474</td>\n",
       "      <td>8481</td>\n",
       "      <td>8481</td>\n",
       "      <td>8474</td>\n",
       "      <td>8474</td>\n",
       "      <td>8481</td>\n",
       "      <td>8481</td>\n",
       "      <td>8481</td>\n",
       "      <td>8481</td>\n",
       "      <td>8169</td>\n",
       "      <td>8169</td>\n",
       "      <td>8481</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-13</th>\n",
       "      <td>3208</td>\n",
       "      <td>3208</td>\n",
       "      <td>3208</td>\n",
       "      <td>3206</td>\n",
       "      <td>3206</td>\n",
       "      <td>3208</td>\n",
       "      <td>3208</td>\n",
       "      <td>3206</td>\n",
       "      <td>3206</td>\n",
       "      <td>3208</td>\n",
       "      <td>3208</td>\n",
       "      <td>3208</td>\n",
       "      <td>3208</td>\n",
       "      <td>3087</td>\n",
       "      <td>3087</td>\n",
       "      <td>3208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-14</th>\n",
       "      <td>6586</td>\n",
       "      <td>6586</td>\n",
       "      <td>6586</td>\n",
       "      <td>6586</td>\n",
       "      <td>6586</td>\n",
       "      <td>6586</td>\n",
       "      <td>6586</td>\n",
       "      <td>6586</td>\n",
       "      <td>6586</td>\n",
       "      <td>6586</td>\n",
       "      <td>6586</td>\n",
       "      <td>6586</td>\n",
       "      <td>6586</td>\n",
       "      <td>6335</td>\n",
       "      <td>6335</td>\n",
       "      <td>6586</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-15</th>\n",
       "      <td>7292</td>\n",
       "      <td>7292</td>\n",
       "      <td>7292</td>\n",
       "      <td>7292</td>\n",
       "      <td>7292</td>\n",
       "      <td>7292</td>\n",
       "      <td>7292</td>\n",
       "      <td>7292</td>\n",
       "      <td>7292</td>\n",
       "      <td>7292</td>\n",
       "      <td>7292</td>\n",
       "      <td>7292</td>\n",
       "      <td>7292</td>\n",
       "      <td>6978</td>\n",
       "      <td>6978</td>\n",
       "      <td>7292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-16</th>\n",
       "      <td>3988</td>\n",
       "      <td>3988</td>\n",
       "      <td>3988</td>\n",
       "      <td>3987</td>\n",
       "      <td>3987</td>\n",
       "      <td>3988</td>\n",
       "      <td>3988</td>\n",
       "      <td>3987</td>\n",
       "      <td>3987</td>\n",
       "      <td>3988</td>\n",
       "      <td>3988</td>\n",
       "      <td>3988</td>\n",
       "      <td>3988</td>\n",
       "      <td>3730</td>\n",
       "      <td>3730</td>\n",
       "      <td>3988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-17</th>\n",
       "      <td>4227</td>\n",
       "      <td>4227</td>\n",
       "      <td>4227</td>\n",
       "      <td>4225</td>\n",
       "      <td>4225</td>\n",
       "      <td>4227</td>\n",
       "      <td>4227</td>\n",
       "      <td>4225</td>\n",
       "      <td>4225</td>\n",
       "      <td>4227</td>\n",
       "      <td>4227</td>\n",
       "      <td>4227</td>\n",
       "      <td>4227</td>\n",
       "      <td>3885</td>\n",
       "      <td>3885</td>\n",
       "      <td>4227</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-18</th>\n",
       "      <td>5651</td>\n",
       "      <td>5651</td>\n",
       "      <td>5651</td>\n",
       "      <td>5631</td>\n",
       "      <td>5631</td>\n",
       "      <td>5651</td>\n",
       "      <td>5651</td>\n",
       "      <td>5631</td>\n",
       "      <td>5631</td>\n",
       "      <td>5651</td>\n",
       "      <td>5651</td>\n",
       "      <td>5651</td>\n",
       "      <td>5651</td>\n",
       "      <td>5317</td>\n",
       "      <td>5317</td>\n",
       "      <td>5651</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-19</th>\n",
       "      <td>9468</td>\n",
       "      <td>9468</td>\n",
       "      <td>9468</td>\n",
       "      <td>9454</td>\n",
       "      <td>9454</td>\n",
       "      <td>9468</td>\n",
       "      <td>9468</td>\n",
       "      <td>9454</td>\n",
       "      <td>9454</td>\n",
       "      <td>9468</td>\n",
       "      <td>9468</td>\n",
       "      <td>9468</td>\n",
       "      <td>9468</td>\n",
       "      <td>9110</td>\n",
       "      <td>9110</td>\n",
       "      <td>9468</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-20</th>\n",
       "      <td>9664</td>\n",
       "      <td>9664</td>\n",
       "      <td>9664</td>\n",
       "      <td>9648</td>\n",
       "      <td>9648</td>\n",
       "      <td>9664</td>\n",
       "      <td>9664</td>\n",
       "      <td>9648</td>\n",
       "      <td>9648</td>\n",
       "      <td>9664</td>\n",
       "      <td>9664</td>\n",
       "      <td>9664</td>\n",
       "      <td>9664</td>\n",
       "      <td>9257</td>\n",
       "      <td>9257</td>\n",
       "      <td>9664</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-21</th>\n",
       "      <td>9540</td>\n",
       "      <td>9540</td>\n",
       "      <td>9540</td>\n",
       "      <td>9531</td>\n",
       "      <td>9531</td>\n",
       "      <td>9540</td>\n",
       "      <td>9540</td>\n",
       "      <td>9531</td>\n",
       "      <td>9531</td>\n",
       "      <td>9540</td>\n",
       "      <td>9540</td>\n",
       "      <td>9540</td>\n",
       "      <td>9540</td>\n",
       "      <td>9134</td>\n",
       "      <td>9134</td>\n",
       "      <td>9540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-22</th>\n",
       "      <td>9193</td>\n",
       "      <td>9193</td>\n",
       "      <td>9193</td>\n",
       "      <td>9182</td>\n",
       "      <td>9182</td>\n",
       "      <td>9193</td>\n",
       "      <td>9193</td>\n",
       "      <td>9182</td>\n",
       "      <td>9182</td>\n",
       "      <td>9193</td>\n",
       "      <td>9193</td>\n",
       "      <td>9193</td>\n",
       "      <td>9193</td>\n",
       "      <td>8764</td>\n",
       "      <td>8764</td>\n",
       "      <td>9193</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-23</th>\n",
       "      <td>5452</td>\n",
       "      <td>5452</td>\n",
       "      <td>5452</td>\n",
       "      <td>5436</td>\n",
       "      <td>5436</td>\n",
       "      <td>5452</td>\n",
       "      <td>5452</td>\n",
       "      <td>5436</td>\n",
       "      <td>5436</td>\n",
       "      <td>5452</td>\n",
       "      <td>5452</td>\n",
       "      <td>5452</td>\n",
       "      <td>5452</td>\n",
       "      <td>5146</td>\n",
       "      <td>5146</td>\n",
       "      <td>5452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-24</th>\n",
       "      <td>4502</td>\n",
       "      <td>4502</td>\n",
       "      <td>4502</td>\n",
       "      <td>4495</td>\n",
       "      <td>4495</td>\n",
       "      <td>4502</td>\n",
       "      <td>4502</td>\n",
       "      <td>4495</td>\n",
       "      <td>4495</td>\n",
       "      <td>4502</td>\n",
       "      <td>4502</td>\n",
       "      <td>4502</td>\n",
       "      <td>4502</td>\n",
       "      <td>4244</td>\n",
       "      <td>4244</td>\n",
       "      <td>4502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-25</th>\n",
       "      <td>7042</td>\n",
       "      <td>7042</td>\n",
       "      <td>7042</td>\n",
       "      <td>7034</td>\n",
       "      <td>7034</td>\n",
       "      <td>7042</td>\n",
       "      <td>7042</td>\n",
       "      <td>7034</td>\n",
       "      <td>7034</td>\n",
       "      <td>7042</td>\n",
       "      <td>7042</td>\n",
       "      <td>7042</td>\n",
       "      <td>7042</td>\n",
       "      <td>6770</td>\n",
       "      <td>6770</td>\n",
       "      <td>7042</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-26</th>\n",
       "      <td>5386</td>\n",
       "      <td>5386</td>\n",
       "      <td>5386</td>\n",
       "      <td>5377</td>\n",
       "      <td>5377</td>\n",
       "      <td>5386</td>\n",
       "      <td>5386</td>\n",
       "      <td>5377</td>\n",
       "      <td>5377</td>\n",
       "      <td>5386</td>\n",
       "      <td>5386</td>\n",
       "      <td>5386</td>\n",
       "      <td>5386</td>\n",
       "      <td>5205</td>\n",
       "      <td>5205</td>\n",
       "      <td>5386</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-27</th>\n",
       "      <td>7703</td>\n",
       "      <td>7703</td>\n",
       "      <td>7703</td>\n",
       "      <td>7694</td>\n",
       "      <td>7694</td>\n",
       "      <td>7703</td>\n",
       "      <td>7703</td>\n",
       "      <td>7694</td>\n",
       "      <td>7694</td>\n",
       "      <td>7703</td>\n",
       "      <td>7703</td>\n",
       "      <td>7703</td>\n",
       "      <td>7703</td>\n",
       "      <td>7445</td>\n",
       "      <td>7445</td>\n",
       "      <td>7703</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-28</th>\n",
       "      <td>9830</td>\n",
       "      <td>9830</td>\n",
       "      <td>9830</td>\n",
       "      <td>9822</td>\n",
       "      <td>9822</td>\n",
       "      <td>9830</td>\n",
       "      <td>9830</td>\n",
       "      <td>9822</td>\n",
       "      <td>9822</td>\n",
       "      <td>9830</td>\n",
       "      <td>9830</td>\n",
       "      <td>9830</td>\n",
       "      <td>9830</td>\n",
       "      <td>9458</td>\n",
       "      <td>9458</td>\n",
       "      <td>9830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-03-01</th>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            duration_sec  start_time  end_time  start_station_id  \\\n",
       "trip_date                                                          \n",
       "2019-02-01          6118        6118      6118              6114   \n",
       "2019-02-02          3241        3241      3241              3239   \n",
       "2019-02-03          2841        2841      2841              2840   \n",
       "2019-02-04          5487        5487      5487              5487   \n",
       "2019-02-05          8485        8485      8485              8483   \n",
       "2019-02-06          9056        9056      9056              9051   \n",
       "2019-02-07          9229        9229      9229              9225   \n",
       "2019-02-08          6362        6362      6362              6358   \n",
       "2019-02-09          2732        2732      2732              2723   \n",
       "2019-02-10          3953        3953      3953              3943   \n",
       "2019-02-11          8679        8679      8679              8662   \n",
       "2019-02-12          8481        8481      8481              8474   \n",
       "2019-02-13          3208        3208      3208              3206   \n",
       "2019-02-14          6586        6586      6586              6586   \n",
       "2019-02-15          7292        7292      7292              7292   \n",
       "2019-02-16          3988        3988      3988              3987   \n",
       "2019-02-17          4227        4227      4227              4225   \n",
       "2019-02-18          5651        5651      5651              5631   \n",
       "2019-02-19          9468        9468      9468              9454   \n",
       "2019-02-20          9664        9664      9664              9648   \n",
       "2019-02-21          9540        9540      9540              9531   \n",
       "2019-02-22          9193        9193      9193              9182   \n",
       "2019-02-23          5452        5452      5452              5436   \n",
       "2019-02-24          4502        4502      4502              4495   \n",
       "2019-02-25          7042        7042      7042              7034   \n",
       "2019-02-26          5386        5386      5386              5377   \n",
       "2019-02-27          7703        7703      7703              7694   \n",
       "2019-02-28          9830        9830      9830              9822   \n",
       "2019-03-01            16          16        16                16   \n",
       "\n",
       "            start_station_name  start_station_latitude  \\\n",
       "trip_date                                                \n",
       "2019-02-01                6114                    6118   \n",
       "2019-02-02                3239                    3241   \n",
       "2019-02-03                2840                    2841   \n",
       "2019-02-04                5487                    5487   \n",
       "2019-02-05                8483                    8485   \n",
       "2019-02-06                9051                    9056   \n",
       "2019-02-07                9225                    9229   \n",
       "2019-02-08                6358                    6362   \n",
       "2019-02-09                2723                    2732   \n",
       "2019-02-10                3943                    3953   \n",
       "2019-02-11                8662                    8679   \n",
       "2019-02-12                8474                    8481   \n",
       "2019-02-13                3206                    3208   \n",
       "2019-02-14                6586                    6586   \n",
       "2019-02-15                7292                    7292   \n",
       "2019-02-16                3987                    3988   \n",
       "2019-02-17                4225                    4227   \n",
       "2019-02-18                5631                    5651   \n",
       "2019-02-19                9454                    9468   \n",
       "2019-02-20                9648                    9664   \n",
       "2019-02-21                9531                    9540   \n",
       "2019-02-22                9182                    9193   \n",
       "2019-02-23                5436                    5452   \n",
       "2019-02-24                4495                    4502   \n",
       "2019-02-25                7034                    7042   \n",
       "2019-02-26                5377                    5386   \n",
       "2019-02-27                7694                    7703   \n",
       "2019-02-28                9822                    9830   \n",
       "2019-03-01                  16                      16   \n",
       "\n",
       "            start_station_longitude  end_station_id  end_station_name  \\\n",
       "trip_date                                                               \n",
       "2019-02-01                     6118            6114              6114   \n",
       "2019-02-02                     3241            3239              3239   \n",
       "2019-02-03                     2841            2840              2840   \n",
       "2019-02-04                     5487            5487              5487   \n",
       "2019-02-05                     8485            8483              8483   \n",
       "2019-02-06                     9056            9051              9051   \n",
       "2019-02-07                     9229            9225              9225   \n",
       "2019-02-08                     6362            6358              6358   \n",
       "2019-02-09                     2732            2723              2723   \n",
       "2019-02-10                     3953            3943              3943   \n",
       "2019-02-11                     8679            8662              8662   \n",
       "2019-02-12                     8481            8474              8474   \n",
       "2019-02-13                     3208            3206              3206   \n",
       "2019-02-14                     6586            6586              6586   \n",
       "2019-02-15                     7292            7292              7292   \n",
       "2019-02-16                     3988            3987              3987   \n",
       "2019-02-17                     4227            4225              4225   \n",
       "2019-02-18                     5651            5631              5631   \n",
       "2019-02-19                     9468            9454              9454   \n",
       "2019-02-20                     9664            9648              9648   \n",
       "2019-02-21                     9540            9531              9531   \n",
       "2019-02-22                     9193            9182              9182   \n",
       "2019-02-23                     5452            5436              5436   \n",
       "2019-02-24                     4502            4495              4495   \n",
       "2019-02-25                     7042            7034              7034   \n",
       "2019-02-26                     5386            5377              5377   \n",
       "2019-02-27                     7703            7694              7694   \n",
       "2019-02-28                     9830            9822              9822   \n",
       "2019-03-01                       16              16                16   \n",
       "\n",
       "            end_station_latitude  end_station_longitude  bike_id  user_type  \\\n",
       "trip_date                                                                     \n",
       "2019-02-01                  6118                   6118     6118       6118   \n",
       "2019-02-02                  3241                   3241     3241       3241   \n",
       "2019-02-03                  2841                   2841     2841       2841   \n",
       "2019-02-04                  5487                   5487     5487       5487   \n",
       "2019-02-05                  8485                   8485     8485       8485   \n",
       "2019-02-06                  9056                   9056     9056       9056   \n",
       "2019-02-07                  9229                   9229     9229       9229   \n",
       "2019-02-08                  6362                   6362     6362       6362   \n",
       "2019-02-09                  2732                   2732     2732       2732   \n",
       "2019-02-10                  3953                   3953     3953       3953   \n",
       "2019-02-11                  8679                   8679     8679       8679   \n",
       "2019-02-12                  8481                   8481     8481       8481   \n",
       "2019-02-13                  3208                   3208     3208       3208   \n",
       "2019-02-14                  6586                   6586     6586       6586   \n",
       "2019-02-15                  7292                   7292     7292       7292   \n",
       "2019-02-16                  3988                   3988     3988       3988   \n",
       "2019-02-17                  4227                   4227     4227       4227   \n",
       "2019-02-18                  5651                   5651     5651       5651   \n",
       "2019-02-19                  9468                   9468     9468       9468   \n",
       "2019-02-20                  9664                   9664     9664       9664   \n",
       "2019-02-21                  9540                   9540     9540       9540   \n",
       "2019-02-22                  9193                   9193     9193       9193   \n",
       "2019-02-23                  5452                   5452     5452       5452   \n",
       "2019-02-24                  4502                   4502     4502       4502   \n",
       "2019-02-25                  7042                   7042     7042       7042   \n",
       "2019-02-26                  5386                   5386     5386       5386   \n",
       "2019-02-27                  7703                   7703     7703       7703   \n",
       "2019-02-28                  9830                   9830     9830       9830   \n",
       "2019-03-01                    16                     16       16         16   \n",
       "\n",
       "            member_birth_year  member_gender  bike_share_for_all_trip  \n",
       "trip_date                                                              \n",
       "2019-02-01               5818           5818                     6118  \n",
       "2019-02-02               3014           3014                     3241  \n",
       "2019-02-03               2710           2710                     2841  \n",
       "2019-02-04               5268           5268                     5487  \n",
       "2019-02-05               8139           8139                     8485  \n",
       "2019-02-06               8658           8658                     9056  \n",
       "2019-02-07               8801           8801                     9229  \n",
       "2019-02-08               6100           6100                     6362  \n",
       "2019-02-09               2560           2560                     2732  \n",
       "2019-02-10               3700           3700                     3953  \n",
       "2019-02-11               8331           8331                     8679  \n",
       "2019-02-12               8169           8169                     8481  \n",
       "2019-02-13               3087           3087                     3208  \n",
       "2019-02-14               6335           6335                     6586  \n",
       "2019-02-15               6978           6978                     7292  \n",
       "2019-02-16               3730           3730                     3988  \n",
       "2019-02-17               3885           3885                     4227  \n",
       "2019-02-18               5317           5317                     5651  \n",
       "2019-02-19               9110           9110                     9468  \n",
       "2019-02-20               9257           9257                     9664  \n",
       "2019-02-21               9134           9134                     9540  \n",
       "2019-02-22               8764           8764                     9193  \n",
       "2019-02-23               5146           5146                     5452  \n",
       "2019-02-24               4244           4244                     4502  \n",
       "2019-02-25               6770           6770                     7042  \n",
       "2019-02-26               5205           5205                     5386  \n",
       "2019-02-27               7445           7445                     7703  \n",
       "2019-02-28               9458           9458                     9830  \n",
       "2019-03-01                 14             14                       16  "
      ]
     },
     "execution_count": 96,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# get trip counts per day\n",
    "# df.groupby('trip_date').count()\n",
    "df.groupby('trip_date').count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "metadata": {},
   "outputs": [],
   "source": [
    "# for a day \n",
    "# get count of bike trips per day \n",
    "# This will set the date column as an index \n",
    "isFebFirst=df['start_time']=='2019-02-01'\n",
    "df = df.set_index(['start_time'])\n",
    "df1=df.loc['2019-2-1':'2019-2-1']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>duration_sec</th>\n",
       "      <th>end_time</th>\n",
       "      <th>start_station_id</th>\n",
       "      <th>start_station_name</th>\n",
       "      <th>start_station_latitude</th>\n",
       "      <th>start_station_longitude</th>\n",
       "      <th>end_station_id</th>\n",
       "      <th>end_station_name</th>\n",
       "      <th>end_station_latitude</th>\n",
       "      <th>end_station_longitude</th>\n",
       "      <th>bike_id</th>\n",
       "      <th>user_type</th>\n",
       "      <th>member_birth_year</th>\n",
       "      <th>member_gender</th>\n",
       "      <th>bike_share_for_all_trip</th>\n",
       "      <th>trip_date</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>start_time</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",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2019-02-01 00:00:20.636</th>\n",
       "      <td>271</td>\n",
       "      <td>2019-02-01 00:04:52.058</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Spear St at Folsom St</td>\n",
       "      <td>37.789677</td>\n",
       "      <td>-122.390428</td>\n",
       "      <td>37.0</td>\n",
       "      <td>2nd St at Folsom St</td>\n",
       "      <td>37.785000</td>\n",
       "      <td>-122.395936</td>\n",
       "      <td>1057</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1989.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>No</td>\n",
       "      <td>2019-02-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-01 00:04:40.616</th>\n",
       "      <td>706</td>\n",
       "      <td>2019-02-01 00:16:27.080</td>\n",
       "      <td>138.0</td>\n",
       "      <td>Jersey St at Church St</td>\n",
       "      <td>37.750900</td>\n",
       "      <td>-122.427411</td>\n",
       "      <td>78.0</td>\n",
       "      <td>Folsom St at 9th St</td>\n",
       "      <td>37.773717</td>\n",
       "      <td>-122.411647</td>\n",
       "      <td>5017</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1988.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>No</td>\n",
       "      <td>2019-02-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-01 00:04:49.724</th>\n",
       "      <td>480</td>\n",
       "      <td>2019-02-01 00:12:50.034</td>\n",
       "      <td>27.0</td>\n",
       "      <td>Beale St at Harrison St</td>\n",
       "      <td>37.788059</td>\n",
       "      <td>-122.391865</td>\n",
       "      <td>324.0</td>\n",
       "      <td>Union Square (Powell St at Post St)</td>\n",
       "      <td>37.788300</td>\n",
       "      <td>-122.408531</td>\n",
       "      <td>4832</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>No</td>\n",
       "      <td>2019-02-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-01 00:05:34.360</th>\n",
       "      <td>139</td>\n",
       "      <td>2019-02-01 00:07:54.287</td>\n",
       "      <td>220.0</td>\n",
       "      <td>San Pablo Ave at MLK Jr Way</td>\n",
       "      <td>37.811351</td>\n",
       "      <td>-122.273422</td>\n",
       "      <td>216.0</td>\n",
       "      <td>San Pablo Ave at 27th St</td>\n",
       "      <td>37.817827</td>\n",
       "      <td>-122.275698</td>\n",
       "      <td>5095</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1988.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>No</td>\n",
       "      <td>2019-02-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-02-01 00:05:34.744</th>\n",
       "      <td>313</td>\n",
       "      <td>2019-02-01 00:10:48.502</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Montgomery St BART Station (Market St at 2nd St)</td>\n",
       "      <td>37.789625</td>\n",
       "      <td>-122.400811</td>\n",
       "      <td>66.0</td>\n",
       "      <td>3rd St at Townsend St</td>\n",
       "      <td>37.778742</td>\n",
       "      <td>-122.392741</td>\n",
       "      <td>4960</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1984.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>No</td>\n",
       "      <td>2019-02-01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         duration_sec                end_time  \\\n",
       "start_time                                                      \n",
       "2019-02-01 00:00:20.636           271 2019-02-01 00:04:52.058   \n",
       "2019-02-01 00:04:40.616           706 2019-02-01 00:16:27.080   \n",
       "2019-02-01 00:04:49.724           480 2019-02-01 00:12:50.034   \n",
       "2019-02-01 00:05:34.360           139 2019-02-01 00:07:54.287   \n",
       "2019-02-01 00:05:34.744           313 2019-02-01 00:10:48.502   \n",
       "\n",
       "                         start_station_id  \\\n",
       "start_time                                  \n",
       "2019-02-01 00:00:20.636              24.0   \n",
       "2019-02-01 00:04:40.616             138.0   \n",
       "2019-02-01 00:04:49.724              27.0   \n",
       "2019-02-01 00:05:34.360             220.0   \n",
       "2019-02-01 00:05:34.744              21.0   \n",
       "\n",
       "                                                       start_station_name  \\\n",
       "start_time                                                                  \n",
       "2019-02-01 00:00:20.636                             Spear St at Folsom St   \n",
       "2019-02-01 00:04:40.616                            Jersey St at Church St   \n",
       "2019-02-01 00:04:49.724                           Beale St at Harrison St   \n",
       "2019-02-01 00:05:34.360                       San Pablo Ave at MLK Jr Way   \n",
       "2019-02-01 00:05:34.744  Montgomery St BART Station (Market St at 2nd St)   \n",
       "\n",
       "                         start_station_latitude  start_station_longitude  \\\n",
       "start_time                                                                 \n",
       "2019-02-01 00:00:20.636               37.789677              -122.390428   \n",
       "2019-02-01 00:04:40.616               37.750900              -122.427411   \n",
       "2019-02-01 00:04:49.724               37.788059              -122.391865   \n",
       "2019-02-01 00:05:34.360               37.811351              -122.273422   \n",
       "2019-02-01 00:05:34.744               37.789625              -122.400811   \n",
       "\n",
       "                         end_station_id                     end_station_name  \\\n",
       "start_time                                                                     \n",
       "2019-02-01 00:00:20.636            37.0                  2nd St at Folsom St   \n",
       "2019-02-01 00:04:40.616            78.0                  Folsom St at 9th St   \n",
       "2019-02-01 00:04:49.724           324.0  Union Square (Powell St at Post St)   \n",
       "2019-02-01 00:05:34.360           216.0             San Pablo Ave at 27th St   \n",
       "2019-02-01 00:05:34.744            66.0                3rd St at Townsend St   \n",
       "\n",
       "                         end_station_latitude  end_station_longitude  bike_id  \\\n",
       "start_time                                                                      \n",
       "2019-02-01 00:00:20.636             37.785000            -122.395936     1057   \n",
       "2019-02-01 00:04:40.616             37.773717            -122.411647     5017   \n",
       "2019-02-01 00:04:49.724             37.788300            -122.408531     4832   \n",
       "2019-02-01 00:05:34.360             37.817827            -122.275698     5095   \n",
       "2019-02-01 00:05:34.744             37.778742            -122.392741     4960   \n",
       "\n",
       "                          user_type  member_birth_year member_gender  \\\n",
       "start_time                                                             \n",
       "2019-02-01 00:00:20.636  Subscriber             1989.0          Male   \n",
       "2019-02-01 00:04:40.616  Subscriber             1988.0          Male   \n",
       "2019-02-01 00:04:49.724  Subscriber             1996.0          Male   \n",
       "2019-02-01 00:05:34.360  Subscriber             1988.0          Male   \n",
       "2019-02-01 00:05:34.744  Subscriber             1984.0          Male   \n",
       "\n",
       "                        bike_share_for_all_trip   trip_date  \n",
       "start_time                                                   \n",
       "2019-02-01 00:00:20.636                      No  2019-02-01  \n",
       "2019-02-01 00:04:40.616                      No  2019-02-01  \n",
       "2019-02-01 00:04:49.724                      No  2019-02-01  \n",
       "2019-02-01 00:05:34.360                      No  2019-02-01  \n",
       "2019-02-01 00:05:34.744                      No  2019-02-01  "
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# work with data from feb first\n",
    "# sort data based on start_time\n",
    "df1=df1.sort_values(by=['start_time'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {},
   "outputs": [],
   "source": [
    "# counts per bike id for a day \n",
    "df1bikeCount = df1.groupby('bike_id').count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Draw "
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}