union_data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'/home/adalaber/Documents/Python'"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "os.getcwd()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "os.chdir('../ejercicios-de-adalab/project-DA-promo-B-module-3-team-3/Datos/data_trips/archivos_separados')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['201910-capitalbikeshare-tripdata.csv',\n",
       " '201911-capitalbikeshare-tripdata.csv',\n",
       " '201802-capitalbikeshare-tripdata.csv',\n",
       " '201907-capitalbikeshare-tripdata.csv',\n",
       " '201901-capitalbikeshare-tripdata.csv',\n",
       " '201810-capitalbikeshare-tripdata.csv',\n",
       " '201803-capitalbikeshare-tripdata.csv',\n",
       " '201902-capitalbikeshare-tripdata.csv',\n",
       " '201903-capitalbikeshare-tripdata.csv',\n",
       " '201808-capitalbikeshare-tripdata.csv',\n",
       " '201905-capitalbikeshare-tripdata.csv',\n",
       " '201809-capitalbikeshare-tripdata.csv',\n",
       " '201909-capitalbikeshare-tripdata.csv',\n",
       " '201904-capitalbikeshare-tripdata.csv',\n",
       " '201804-capitalbikeshare-tripdata.csv',\n",
       " '201812-capitalbikeshare-tripdata.csv',\n",
       " '201805-capitalbikeshare-tripdata.csv',\n",
       " '201811-capitalbikeshare-tripdata.csv',\n",
       " '201912-capitalbikeshare-tripdata.csv',\n",
       " '201806-capitalbikeshare-tripdata.csv',\n",
       " '201807-capitalbikeshare-tripdata.csv',\n",
       " '201908-capitalbikeshare-tripdata.csv',\n",
       " '201801_capitalbikeshare_tripdata.csv',\n",
       " '201906-capitalbikeshare-tripdata.csv']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "archivos = os.listdir()\n",
    "archivos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'201910_capitalbikeshare_tripdata'"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "archivos[0].split('.')[0].replace('-','_')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "fechas_dict = {arc.split('.')[0].replace('-','_') : pd.DataFrame() for arc in archivos}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'201910_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201911_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201802_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201907_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201901_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201810_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201803_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201902_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201903_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201808_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201905_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201809_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201909_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201904_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201804_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201812_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201805_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201811_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201912_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201806_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201807_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201908_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201801_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " '201906_capitalbikeshare_tripdata': Empty DataFrame\n",
       " Columns: []\n",
       " Index: []}"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fechas_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>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",
       "    <tr>\n",
       "      <th>Duration</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>429</th>\n",
       "      <td>2019-10-01 00:01:59</td>\n",
       "      <td>2019-10-01 00:09:08</td>\n",
       "      <td>31214</td>\n",
       "      <td>17th &amp; Corcoran St NW</td>\n",
       "      <td>31203</td>\n",
       "      <td>14th &amp; Rhode Island Ave NW</td>\n",
       "      <td>W23731</td>\n",
       "      <td>Member</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1935</th>\n",
       "      <td>2019-10-01 00:03:07</td>\n",
       "      <td>2019-10-01 00:35:23</td>\n",
       "      <td>31269</td>\n",
       "      <td>3rd St &amp; Pennsylvania Ave SE</td>\n",
       "      <td>31269</td>\n",
       "      <td>3rd St &amp; Pennsylvania Ave SE</td>\n",
       "      <td>W22377</td>\n",
       "      <td>Member</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>563</th>\n",
       "      <td>2019-10-01 00:03:51</td>\n",
       "      <td>2019-10-01 00:13:14</td>\n",
       "      <td>31214</td>\n",
       "      <td>17th &amp; Corcoran St NW</td>\n",
       "      <td>31251</td>\n",
       "      <td>12th &amp; L St NW</td>\n",
       "      <td>W23473</td>\n",
       "      <td>Member</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>625</th>\n",
       "      <td>2019-10-01 00:05:34</td>\n",
       "      <td>2019-10-01 00:15:59</td>\n",
       "      <td>31301</td>\n",
       "      <td>Ward Circle / American University</td>\n",
       "      <td>31317</td>\n",
       "      <td>Wisconsin Ave &amp; Ingomar St NW</td>\n",
       "      <td>W21371</td>\n",
       "      <td>Member</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>312</th>\n",
       "      <td>2019-10-01 00:05:47</td>\n",
       "      <td>2019-10-01 00:10:59</td>\n",
       "      <td>31519</td>\n",
       "      <td>1st &amp; O St NW</td>\n",
       "      <td>31109</td>\n",
       "      <td>7th &amp; T St NW</td>\n",
       "      <td>W23666</td>\n",
       "      <td>Member</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760</th>\n",
       "      <td>2019-10-31 23:51:10</td>\n",
       "      <td>2019-11-01 00:03:50</td>\n",
       "      <td>31128</td>\n",
       "      <td>23rd &amp; M St NW</td>\n",
       "      <td>31228</td>\n",
       "      <td>8th &amp; H St NW</td>\n",
       "      <td>W24640</td>\n",
       "      <td>Member</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>340</th>\n",
       "      <td>2019-10-31 23:51:13</td>\n",
       "      <td>2019-10-31 23:56:54</td>\n",
       "      <td>31203</td>\n",
       "      <td>14th &amp; Rhode Island Ave NW</td>\n",
       "      <td>31600</td>\n",
       "      <td>5th &amp; K St NW</td>\n",
       "      <td>W00238</td>\n",
       "      <td>Member</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>2019-10-31 23:51:35</td>\n",
       "      <td>2019-10-31 23:53:56</td>\n",
       "      <td>31296</td>\n",
       "      <td>Columbia &amp; Ontario Rd NW</td>\n",
       "      <td>31113</td>\n",
       "      <td>Columbia Rd &amp; Belmont St NW</td>\n",
       "      <td>W20631</td>\n",
       "      <td>Member</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>644</th>\n",
       "      <td>2019-10-31 23:56:21</td>\n",
       "      <td>2019-11-01 00:07:05</td>\n",
       "      <td>31408</td>\n",
       "      <td>Takoma Metro</td>\n",
       "      <td>32412</td>\n",
       "      <td>New Hampshire Ave &amp; East-West Hwy</td>\n",
       "      <td>W01190</td>\n",
       "      <td>Member</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>2019-10-31 23:59:10</td>\n",
       "      <td>2019-11-01 00:02:25</td>\n",
       "      <td>31089</td>\n",
       "      <td>Court House Metro / 15th St &amp; N Uhle St</td>\n",
       "      <td>31089</td>\n",
       "      <td>Court House Metro / 15th St &amp; N Uhle St</td>\n",
       "      <td>W23213</td>\n",
       "      <td>Member</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>337552 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Start date             End date  Start station number  \\\n",
       "Duration                                                                   \n",
       "429       2019-10-01 00:01:59  2019-10-01 00:09:08                 31214   \n",
       "1935      2019-10-01 00:03:07  2019-10-01 00:35:23                 31269   \n",
       "563       2019-10-01 00:03:51  2019-10-01 00:13:14                 31214   \n",
       "625       2019-10-01 00:05:34  2019-10-01 00:15:59                 31301   \n",
       "312       2019-10-01 00:05:47  2019-10-01 00:10:59                 31519   \n",
       "...                       ...                  ...                   ...   \n",
       "760       2019-10-31 23:51:10  2019-11-01 00:03:50                 31128   \n",
       "340       2019-10-31 23:51:13  2019-10-31 23:56:54                 31203   \n",
       "140       2019-10-31 23:51:35  2019-10-31 23:53:56                 31296   \n",
       "644       2019-10-31 23:56:21  2019-11-01 00:07:05                 31408   \n",
       "194       2019-10-31 23:59:10  2019-11-01 00:02:25                 31089   \n",
       "\n",
       "                                    Start station  End station number  \\\n",
       "Duration                                                                \n",
       "429                         17th & Corcoran St NW               31203   \n",
       "1935                 3rd St & Pennsylvania Ave SE               31269   \n",
       "563                         17th & Corcoran St NW               31251   \n",
       "625             Ward Circle / American University               31317   \n",
       "312                                 1st & O St NW               31109   \n",
       "...                                           ...                 ...   \n",
       "760                                23rd & M St NW               31228   \n",
       "340                    14th & Rhode Island Ave NW               31600   \n",
       "140                      Columbia & Ontario Rd NW               31113   \n",
       "644                                  Takoma Metro               32412   \n",
       "194       Court House Metro / 15th St & N Uhle St               31089   \n",
       "\n",
       "                                      End station Bike number Member type  \n",
       "Duration                                                                   \n",
       "429                    14th & Rhode Island Ave NW      W23731      Member  \n",
       "1935                 3rd St & Pennsylvania Ave SE      W22377      Member  \n",
       "563                                12th & L St NW      W23473      Member  \n",
       "625                 Wisconsin Ave & Ingomar St NW      W21371      Member  \n",
       "312                                 7th & T St NW      W23666      Member  \n",
       "...                                           ...         ...         ...  \n",
       "760                                 8th & H St NW      W24640      Member  \n",
       "340                                 5th & K St NW      W00238      Member  \n",
       "140                   Columbia Rd & Belmont St NW      W20631      Member  \n",
       "644             New Hampshire Ave & East-West Hwy      W01190      Member  \n",
       "194       Court House Metro / 15th St & N Uhle St      W23213      Member  \n",
       "\n",
       "[337552 rows x 8 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fechas_dict[archivos[0]] = pd.read_csv(archivos[0], index_col=0)\n",
    "fechas_dict[archivos[0]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in archivos:\n",
    "    fechas_dict[i] = pd.read_csv(i, index_col=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       " Empty DataFrame\n",
       " Columns: []\n",
       " Index: [],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 429       2019-10-01 00:01:59  2019-10-01 00:09:08                 31214   \n",
       " 1935      2019-10-01 00:03:07  2019-10-01 00:35:23                 31269   \n",
       " 563       2019-10-01 00:03:51  2019-10-01 00:13:14                 31214   \n",
       " 625       2019-10-01 00:05:34  2019-10-01 00:15:59                 31301   \n",
       " 312       2019-10-01 00:05:47  2019-10-01 00:10:59                 31519   \n",
       " ...                       ...                  ...                   ...   \n",
       " 760       2019-10-31 23:51:10  2019-11-01 00:03:50                 31128   \n",
       " 340       2019-10-31 23:51:13  2019-10-31 23:56:54                 31203   \n",
       " 140       2019-10-31 23:51:35  2019-10-31 23:53:56                 31296   \n",
       " 644       2019-10-31 23:56:21  2019-11-01 00:07:05                 31408   \n",
       " 194       2019-10-31 23:59:10  2019-11-01 00:02:25                 31089   \n",
       " \n",
       "                                     Start station  End station number  \\\n",
       " Duration                                                                \n",
       " 429                         17th & Corcoran St NW               31203   \n",
       " 1935                 3rd St & Pennsylvania Ave SE               31269   \n",
       " 563                         17th & Corcoran St NW               31251   \n",
       " 625             Ward Circle / American University               31317   \n",
       " 312                                 1st & O St NW               31109   \n",
       " ...                                           ...                 ...   \n",
       " 760                                23rd & M St NW               31228   \n",
       " 340                    14th & Rhode Island Ave NW               31600   \n",
       " 140                      Columbia & Ontario Rd NW               31113   \n",
       " 644                                  Takoma Metro               32412   \n",
       " 194       Court House Metro / 15th St & N Uhle St               31089   \n",
       " \n",
       "                                       End station Bike number Member type  \n",
       " Duration                                                                   \n",
       " 429                    14th & Rhode Island Ave NW      W23731      Member  \n",
       " 1935                 3rd St & Pennsylvania Ave SE      W22377      Member  \n",
       " 563                                12th & L St NW      W23473      Member  \n",
       " 625                 Wisconsin Ave & Ingomar St NW      W21371      Member  \n",
       " 312                                 7th & T St NW      W23666      Member  \n",
       " ...                                           ...         ...         ...  \n",
       " 760                                 8th & H St NW      W24640      Member  \n",
       " 340                                 5th & K St NW      W00238      Member  \n",
       " 140                   Columbia Rd & Belmont St NW      W20631      Member  \n",
       " 644             New Hampshire Ave & East-West Hwy      W01190      Member  \n",
       " 194       Court House Metro / 15th St & N Uhle St      W23213      Member  \n",
       " \n",
       " [337552 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 145       2019-11-01 00:01:54  2019-11-01 00:04:19                 31020   \n",
       " 445       2019-11-01 00:02:21  2019-11-01 00:09:47                 31201   \n",
       " 870       2019-11-01 00:03:37  2019-11-01 00:18:08                 31293   \n",
       " 2658      2019-11-01 00:07:33  2019-11-01 00:51:52                 31509   \n",
       " 1180      2019-11-01 00:09:35  2019-11-01 00:29:16                 31243   \n",
       " ...                       ...                  ...                   ...   \n",
       " 145       2019-11-30 23:57:29  2019-11-30 23:59:54                 31646   \n",
       " 790       2019-11-30 23:57:35  2019-12-01 00:10:45                 31215   \n",
       " 1817      2019-11-30 23:58:48  2019-12-01 00:29:06                 31127   \n",
       " 498       2019-11-30 23:59:14  2019-12-01 00:07:32                 31601   \n",
       " 160       2019-11-30 23:59:41  2019-12-01 00:02:21                 31020   \n",
       " \n",
       "                            Start station  End station number  \\\n",
       " Duration                                                       \n",
       " 145          Wilson Blvd & N Franklin Rd               31030   \n",
       " 445                       15th & P St NW               31110   \n",
       " 870                   31st & Water St NW               31229   \n",
       " 2658            New Jersey Ave & R St NW               31130   \n",
       " 1180                       4th & C St SW               31625   \n",
       " ...                                  ...                 ...   \n",
       " 145                Maine Ave & 9th St SW               31294   \n",
       " 790       Georgetown Harbor / 30th St NW               31278   \n",
       " 1817                      22nd & H St NW               31322   \n",
       " 498            19th & East Capitol St SE               31611   \n",
       " 160          Wilson Blvd & N Franklin Rd               31030   \n",
       " \n",
       "                           End station Bike number Member type  \n",
       " Duration                                                       \n",
       " 145              Lee Hwy & N Adams St      W23365      Member  \n",
       " 445          20th St & Florida Ave NW      W21220      Member  \n",
       " 870       New Hampshire Ave & T St NW      W00770      Member  \n",
       " 2658                    7th & S St NW      W22072      Member  \n",
       " 1180                    3rd & G St SE      W20688      Member  \n",
       " ...                               ...         ...         ...  \n",
       " 145                     7th & E St SW      W20281      Member  \n",
       " 790                    18th & R St NW      W23787      Member  \n",
       " 1817      48th Pl & MacArthur Blvd NW       78532      Member  \n",
       " 498                    13th & H St NE      W20348      Member  \n",
       " 160              Lee Hwy & N Adams St      W20072      Member  \n",
       " \n",
       " [223512 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 892       2018-02-01 00:01:29  2018-02-01 00:16:21                 31312   \n",
       " 501       2018-02-01 00:04:19  2018-02-01 00:12:40                 31089   \n",
       " 788       2018-02-01 00:05:03  2018-02-01 00:18:12                 32048   \n",
       " 406       2018-02-01 00:18:11  2018-02-01 00:24:57                 31224   \n",
       " 161       2018-02-01 00:18:11  2018-02-01 00:20:53                 31126   \n",
       " ...                       ...                  ...                   ...   \n",
       " 418       2018-02-28 23:57:06  2018-03-01 00:04:04                 31201   \n",
       " 565       2018-02-28 23:57:10  2018-03-01 00:06:35                 31507   \n",
       " 651       2018-02-28 23:58:18  2018-03-01 00:09:10                 31312   \n",
       " 779       2018-02-28 23:59:45  2018-03-01 00:12:44                 31114   \n",
       " 1972      2018-02-28 23:59:53  2018-03-01 00:32:46                 31519   \n",
       " \n",
       "                                   Start station  End station number  \\\n",
       " Duration                                                              \n",
       " 892                     Wisconsin Ave & O St NW               31267   \n",
       " 501       Court House Metro / 15th & N Uhle St                31079   \n",
       " 788                              Bethesda Metro               31315   \n",
       " 406                              19th & L St NW               31214   \n",
       " 161                         11th & Girard St NW               31115   \n",
       " ...                                         ...                 ...   \n",
       " 418                              15th & P St NW               31110   \n",
       " 565         1st & Washington Hospital Center NW               31109   \n",
       " 651                     Wisconsin Ave & O St NW               31278   \n",
       " 779                    18th St & Wyoming Ave NW               31266   \n",
       " 1972                              1st & O St NW               31519   \n",
       " \n",
       "                                End station Bike number Member type  \n",
       " Duration                                                            \n",
       " 892         17th St & Massachusetts Ave NW      W21967      Member  \n",
       " 501               Lee Hwy & N Cleveland St      W00938      Member  \n",
       " 788       McKinley St & Connecticut Ave NW      W00792      Member  \n",
       " 406                  17th & Corcoran St NW      W21087      Member  \n",
       " 161           Columbia Rd & Georgia Ave NW      W01068      Member  \n",
       " ...                                    ...         ...         ...  \n",
       " 418               20th St & Florida Ave NW      W21083      Member  \n",
       " 565                          7th & T St NW      W20402      Member  \n",
       " 651                         18th & R St NW      W21049      Member  \n",
       " 779                         11th & M St NW      W22520      Casual  \n",
       " 1972                         1st & O St NW      W22966      Member  \n",
       " \n",
       " [182378 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 528       2019-07-01 00:00:05  2019-07-01 00:08:53                 31312   \n",
       " 548       2019-07-01 00:00:17  2019-07-01 00:09:26                 31321   \n",
       " 1612      2019-07-01 00:00:23  2019-07-01 00:27:16                 31211   \n",
       " 534       2019-07-01 00:00:36  2019-07-01 00:09:30                 31321   \n",
       " 530       2019-07-01 00:00:52  2019-07-01 00:09:43                 31201   \n",
       " ...                       ...                  ...                   ...   \n",
       " 1596      2019-07-31 23:55:36  2019-08-01 00:22:12                 31249   \n",
       " 588       2019-07-31 23:56:09  2019-08-01 00:05:58                 31104   \n",
       " 737       2019-07-31 23:57:44  2019-08-01 00:10:01                 31115   \n",
       " 359       2019-07-31 23:57:47  2019-08-01 00:03:46                 31117   \n",
       " 513       2019-07-31 23:59:55  2019-08-01 00:08:29                 31516   \n",
       " \n",
       "                           Start station  End station number  \\\n",
       " Duration                                                      \n",
       " 528             Wisconsin Ave & O St NW               31234   \n",
       " 548       15th St & Constitution Ave NW               31270   \n",
       " 1612                     Kennedy Center               31289   \n",
       " 534       15th St & Constitution Ave NW               31270   \n",
       " 530                      15th & P St NW               31109   \n",
       " ...                                 ...                 ...   \n",
       " 1596                 Jefferson Memorial               31290   \n",
       " 588         Adams Mill & Columbia Rd NW               31128   \n",
       " 737        Columbia Rd & Georgia Ave NW               31267   \n",
       " 359                15th & Euclid St  NW               31282   \n",
       " 513              Rhode Island Ave Metro               31510   \n",
       " \n",
       "                                           End station Bike number Member type  \n",
       " Duration                                                                       \n",
       " 528                     20th & O St NW / Dupont South      W23055      Member  \n",
       " 548                                     8th & D St NW      W20124      Member  \n",
       " 1612      Henry Bacon Dr & Lincoln Memorial Circle NW      W00461      Member  \n",
       " 534                                     8th & D St NW      W23106      Member  \n",
       " 530                                     7th & T St NW      W22710      Casual  \n",
       " ...                                               ...         ...         ...  \n",
       " 1596                    17th St & Independence Ave SW       78598      Member  \n",
       " 588                                    23rd & M St NW      W24040      Member  \n",
       " 737                    17th St & Massachusetts Ave NW      W23142      Member  \n",
       " 359                                    16th & R St NW      W22184      Member  \n",
       " 513                     18th St & Rhode Island Ave NE      W22855      Member  \n",
       " \n",
       " [356645 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 230       2019-01-01 00:04:48  2019-01-01 00:08:39                 31203   \n",
       " 1549      2019-01-01 00:06:37  2019-01-01 00:32:27                 31321   \n",
       " 177       2019-01-01 00:08:46  2019-01-01 00:11:44                 31104   \n",
       " 228       2019-01-01 00:08:47  2019-01-01 00:12:35                 31281   \n",
       " 1300      2019-01-01 00:12:29  2019-01-01 00:34:10                 31014   \n",
       " ...                       ...                  ...                   ...   \n",
       " 1070      2019-01-31 23:47:11  2019-02-01 00:05:02                 31268   \n",
       " 180       2019-01-31 23:52:07  2019-01-31 23:55:08                 31603   \n",
       " 732       2019-01-31 23:58:33  2019-02-01 00:10:45                 31638   \n",
       " 688       2019-01-31 23:58:52  2019-02-01 00:10:21                 31114   \n",
       " 681       2019-01-31 23:58:54  2019-02-01 00:10:15                 31114   \n",
       " \n",
       "                           Start station  End station number  \\\n",
       " Duration                                                      \n",
       " 230          14th & Rhode Island Ave NW               31200   \n",
       " 1549      15th St & Constitution Ave NW               31114   \n",
       " 177         Adams Mill & Columbia Rd NW               31323   \n",
       " 228                       8th & O St NW               31280   \n",
       " 1300               Lynn & 19th St North               31923   \n",
       " ...                                 ...                 ...   \n",
       " 1070                     12th & U St NW               31618   \n",
       " 180                       1st & M St NE               31616   \n",
       " 732                       1st & H St NW               31214   \n",
       " 688            18th St & Wyoming Ave NW               31128   \n",
       " 681            18th St & Wyoming Ave NW               31128   \n",
       " \n",
       "                                                 End station Bike number  \\\n",
       " Duration                                                                  \n",
       " 230                    Massachusetts Ave & Dupont Circle NW      E00141   \n",
       " 1549                               18th St & Wyoming Ave NW      W24067   \n",
       " 177       Woodley Park Metro / Calvert St & Connecticut ...      W22654   \n",
       " 228                                          11th & S St NW      W22336   \n",
       " 1300                            Columbia Pike & S Taylor St       70004   \n",
       " ...                                                     ...         ...   \n",
       " 1070                               4th & East Capitol St NE      W21008   \n",
       " 180                                           3rd & H St NE      W23095   \n",
       " 732                                   17th & Corcoran St NW      W21341   \n",
       " 688                                          23rd & M St NW      W22170   \n",
       " 681                                          23rd & M St NW      E00128   \n",
       " \n",
       "          Member type  \n",
       " Duration              \n",
       " 230           Member  \n",
       " 1549          Casual  \n",
       " 177           Casual  \n",
       " 228           Member  \n",
       " 1300          Member  \n",
       " ...              ...  \n",
       " 1070          Member  \n",
       " 180           Member  \n",
       " 732           Member  \n",
       " 688           Member  \n",
       " 681           Member  \n",
       " \n",
       " [150780 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 1480      2018-10-01 00:02:22  2018-10-01 00:27:02                 31104   \n",
       " 337       2018-10-01 00:02:49  2018-10-01 00:08:27                 31281   \n",
       " 2197      2018-10-01 00:03:38  2018-10-01 00:40:16                 31506   \n",
       " 1107      2018-10-01 00:03:59  2018-10-01 00:22:27                 31271   \n",
       " 519       2018-10-01 00:06:23  2018-10-01 00:15:03                 31506   \n",
       " ...                       ...                  ...                   ...   \n",
       " 842       2018-10-31 23:57:36  2018-11-01 00:11:39                 31609   \n",
       " 1045      2018-10-31 23:57:55  2018-11-01 00:15:21                 31082   \n",
       " 1004      2018-10-31 23:58:05  2018-11-01 00:14:49                 31228   \n",
       " 1187      2018-10-31 23:58:09  2018-11-01 00:17:56                 31270   \n",
       " 893       2018-10-31 23:59:22  2018-11-01 00:14:15                 31229   \n",
       " \n",
       "                              Start station  End station number  \\\n",
       " Duration                                                         \n",
       " 1480           Adams Mill & Columbia Rd NW               31108   \n",
       " 337                          8th & O St NW               31203   \n",
       " 2197             1st & Rhode Island Ave NW               31312   \n",
       " 1107      Constitution Ave & 2nd St NW/DOL               31263   \n",
       " 519              1st & Rhode Island Ave NW               31223   \n",
       " ...                                    ...                 ...   \n",
       " 842                  Maine Ave & 7th St SW               31232   \n",
       " 1045         Eisenhower Ave & Mill Race Ln               31082   \n",
       " 1004                         8th & H St NW               31649   \n",
       " 1187                         8th & D St NW               31266   \n",
       " 893            New Hampshire Ave & T St NW               31401   \n",
       " \n",
       "                                         End station Bike number Member type  \n",
       " Duration                                                                     \n",
       " 1480                                  4th & M St SW      W23481      Member  \n",
       " 337                      14th & Rhode Island Ave NW      W20140      Member  \n",
       " 2197                        Wisconsin Ave & O St NW      W23671      Member  \n",
       " 1107                                 10th & K St NW      W00972      Casual  \n",
       " 519               Convention Center / 7th & M St NW      W22170      Member  \n",
       " ...                                             ...         ...         ...  \n",
       " 842       7th & F St NW / National Portrait Gallery      E00125      Member  \n",
       " 1045                  Eisenhower Ave & Mill Race Ln      W23032      Member  \n",
       " 1004                            14th & Newton St NW      W20732      Member  \n",
       " 1187                                 11th & M St NW      W21220      Member  \n",
       " 893                          14th St & Spring Rd NW      W21215      Member  \n",
       " \n",
       " [343021 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 106       2018-03-01 00:00:17  2018-03-01 00:02:03                 31638   \n",
       " 172       2018-03-01 00:00:19  2018-03-01 00:03:11                 31241   \n",
       " 877       2018-03-01 00:00:40  2018-03-01 00:15:18                 31503   \n",
       " 1235      2018-03-01 00:01:54  2018-03-01 00:22:29                 31314   \n",
       " 471       2018-03-01 00:02:40  2018-03-01 00:10:32                 31247   \n",
       " ...                       ...                  ...                   ...   \n",
       " 1553      2018-03-31 23:57:12  2018-04-01 00:23:05                 31290   \n",
       " 301       2018-03-31 23:58:35  2018-04-01 00:03:36                 31104   \n",
       " 1709      2018-03-31 23:59:12  2018-04-01 00:27:42                 31243   \n",
       " 1329      2018-03-31 23:59:20  2018-04-01 00:21:30                 31290   \n",
       " 1003      2018-03-31 23:59:58  2018-04-01 00:16:41                 31252   \n",
       " \n",
       "                           Start station  End station number  \\\n",
       " Duration                                                      \n",
       " 106                       1st & H St NW               31642   \n",
       " 172                       Thomas Circle               31222   \n",
       " 877               Florida Ave & R St NW               31126   \n",
       " 1235                 34th & Water St NW               31289   \n",
       " 471           Jefferson Dr & 14th St SW               31244   \n",
       " ...                                 ...                 ...   \n",
       " 1553      17th St & Independence Ave SW               31633   \n",
       " 301         Adams Mill & Columbia Rd NW               31124   \n",
       " 1709                      4th & C St SW               31053   \n",
       " 1329      17th St & Independence Ave SW               31206   \n",
       " 1003      21st St & Pennsylvania Ave NW               31258   \n",
       " \n",
       "                                           End station Bike number Member type  \n",
       " Duration                                                                       \n",
       " 106                          New Jersey Ave & L St NW      W22183      Member  \n",
       " 172                         New York Ave & 15th St NW      W22132      Member  \n",
       " 877                               11th & Girard St NW      W23191      Member  \n",
       " 1235      Henry Bacon Dr & Lincoln Memorial Circle NW      W00459      Casual  \n",
       " 471                                     4th & E St SW      W22781      Casual  \n",
       " ...                                               ...         ...         ...  \n",
       " 1553         Independence Ave & L'Enfant Plaza SW/DOE      W00918      Casual  \n",
       " 301                               14th & Irving St NW      W22335      Member  \n",
       " 1709                  Columbia Pike & S Courthouse Rd      W22879      Member  \n",
       " 1329                               19th & E Street NW      W22034      Casual  \n",
       " 1003                                 Lincoln Memorial      W21090      Casual  \n",
       " \n",
       " [238998 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 206       2019-02-01 00:00:20  2019-02-01 00:03:47                 31509   \n",
       " 297       2019-02-01 00:04:40  2019-02-01 00:09:38                 31203   \n",
       " 165       2019-02-01 00:06:34  2019-02-01 00:09:20                 31303   \n",
       " 176       2019-02-01 00:06:49  2019-02-01 00:09:45                 31400   \n",
       " 105       2019-02-01 00:10:41  2019-02-01 00:12:27                 31270   \n",
       " ...                       ...                  ...                   ...   \n",
       " 886       2019-02-28 23:55:21  2019-03-01 00:10:08                 31223   \n",
       " 404       2019-02-28 23:57:03  2019-03-01 00:03:47                 31203   \n",
       " 972       2019-02-28 23:57:03  2019-03-01 00:13:16                 31101   \n",
       " 925       2019-02-28 23:57:32  2019-03-01 00:12:58                 31613   \n",
       " 773       2019-02-28 23:59:15  2019-03-01 00:12:08                 31255   \n",
       " \n",
       "                                               Start station  \\\n",
       " Duration                                                      \n",
       " 206                                New Jersey Ave & R St NW   \n",
       " 297                              14th & Rhode Island Ave NW   \n",
       " 165            Tenleytown / Wisconsin Ave & Albemarle St NW   \n",
       " 176                          Georgia & New Hampshire Ave NW   \n",
       " 105                                           8th & D St NW   \n",
       " ...                                                     ...   \n",
       " 886                       Convention Center / 7th & M St NW   \n",
       " 404                              14th & Rhode Island Ave NW   \n",
       " 972                                          14th & V St NW   \n",
       " 925       Eastern Market Metro / Pennsylvania Ave & 7th ...   \n",
       " 773                                          24th & N St NW   \n",
       " \n",
       "           End station number                         End station Bike number  \\\n",
       " Duration                                                                       \n",
       " 206                    31636  New Jersey Ave & N St NW/Dunbar HS      W21713   \n",
       " 297                    31519                       1st & O St NW      E00013   \n",
       " 165                    31308                 39th & Veazey St NW      W21703   \n",
       " 176                    31401              14th St & Spring Rd NW      W21699   \n",
       " 105                    31256                      10th & E St NW      W21710   \n",
       " ...                      ...                                 ...         ...   \n",
       " 886                    31612              D St & Maryland Ave NE      W23129   \n",
       " 404                    31223   Convention Center / 7th & M St NW      W00316   \n",
       " 972                    31600                       5th & K St NW      W21796   \n",
       " 925                    31642            New Jersey Ave & L St NW      W23576   \n",
       " 773                    31233    17th & K St NW / Farragut Square      W22068   \n",
       " \n",
       "          Member type  \n",
       " Duration              \n",
       " 206           Member  \n",
       " 297           Member  \n",
       " 165           Member  \n",
       " 176           Member  \n",
       " 105           Member  \n",
       " ...              ...  \n",
       " 886           Member  \n",
       " 404           Member  \n",
       " 972           Member  \n",
       " 925           Member  \n",
       " 773           Member  \n",
       " \n",
       " [158130 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 896       2019-03-01 00:02:23  2019-03-01 00:17:19                 31234   \n",
       " 613       2019-03-01 00:03:10  2019-03-01 00:13:23                 31323   \n",
       " 652       2019-03-01 00:04:14  2019-03-01 00:15:06                 31651   \n",
       " 676       2019-03-01 00:05:11  2019-03-01 00:16:27                 31400   \n",
       " 587       2019-03-01 00:08:04  2019-03-01 00:17:51                 31293   \n",
       " ...                       ...                  ...                   ...   \n",
       " 159       2019-03-31 23:48:43  2019-03-31 23:51:23                 31202   \n",
       " 379       2019-03-31 23:49:26  2019-03-31 23:55:45                 31127   \n",
       " 374       2019-03-31 23:52:26  2019-03-31 23:58:41                 31119   \n",
       " 734       2019-03-31 23:54:33  2019-04-01 00:06:47                 31267   \n",
       " 742       2019-03-31 23:54:36  2019-04-01 00:06:59                 31267   \n",
       " \n",
       "                                               Start station  \\\n",
       " Duration                                                      \n",
       " 896                           20th & O St NW / Dupont South   \n",
       " 613       Woodley Park Metro / Calvert St & Connecticut ...   \n",
       " 652                                       11th & Park Rd NW   \n",
       " 676                          Georgia & New Hampshire Ave NW   \n",
       " 587                                      31st & Water St NW   \n",
       " ...                                                     ...   \n",
       " 159                                          14th & R St NW   \n",
       " 379                                          22nd & H St NW   \n",
       " 374                                    14th & Belmont St NW   \n",
       " 734                          17th St & Massachusetts Ave NW   \n",
       " 742                          17th St & Massachusetts Ave NW   \n",
       " \n",
       "           End station number  \\\n",
       " Duration                       \n",
       " 896                    31306   \n",
       " 613                    31214   \n",
       " 652                    31506   \n",
       " 676                    31212   \n",
       " 587                    31250   \n",
       " ...                      ...   \n",
       " 159                    31101   \n",
       " 379                    31225   \n",
       " 374                    31110   \n",
       " 734                    31523   \n",
       " 742                    31523   \n",
       " \n",
       "                                                 End station Bike number  \\\n",
       " Duration                                                                  \n",
       " 896                         39th & Calvert St NW / Stoddert      W01259   \n",
       " 613                                   17th & Corcoran St NW      W22263   \n",
       " 652                               1st & Rhode Island Ave NW      W00825   \n",
       " 676                                          21st & M St NW      W24162   \n",
       " 587                                          20th & L St NW      W21644   \n",
       " ...                                                     ...         ...   \n",
       " 159                                          14th & U St NW      W00684   \n",
       " 379                          C & O Canal & Wisconsin Ave NW      W21832   \n",
       " 374                                20th St & Florida Ave NW      W20398   \n",
       " 734       Lincoln Rd & Seaton Pl NE/Harry Thomas Rec Center      W23834   \n",
       " 742       Lincoln Rd & Seaton Pl NE/Harry Thomas Rec Center      W00818   \n",
       " \n",
       "          Member type  \n",
       " Duration              \n",
       " 896           Member  \n",
       " 613           Member  \n",
       " 652           Member  \n",
       " 676           Member  \n",
       " 587           Member  \n",
       " ...              ...  \n",
       " 159           Member  \n",
       " 379           Member  \n",
       " 374           Member  \n",
       " 734           Member  \n",
       " 742           Member  \n",
       " \n",
       " [253811 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 435       2018-08-01 00:00:48  2018-08-01 00:08:04                 31621   \n",
       " 1001      2018-08-01 00:01:30  2018-08-01 00:18:11                 31278   \n",
       " 1075      2018-08-01 00:04:01  2018-08-01 00:21:56                 31503   \n",
       " 896       2018-08-01 00:04:18  2018-08-01 00:19:15                 31018   \n",
       " 1517      2018-08-01 00:04:26  2018-08-01 00:29:43                 31289   \n",
       " ...                       ...                  ...                   ...   \n",
       " 1111      2018-08-31 23:56:30  2018-09-01 00:15:01                 31270   \n",
       " 1302      2018-08-31 23:57:27  2018-09-01 00:19:10                 31228   \n",
       " 951       2018-08-31 23:57:28  2018-09-01 00:13:20                 31111   \n",
       " 405       2018-08-31 23:58:02  2018-09-01 00:04:47                 31241   \n",
       " 79        2018-08-31 23:58:42  2018-09-01 00:00:02                 31081   \n",
       " \n",
       "                                         Start station  End station number  \\\n",
       " Duration                                                                    \n",
       " 435                  4th & D St NW / Judiciary Square               31647   \n",
       " 1001                                   18th & R St NW               31105   \n",
       " 1075                            Florida Ave & R St NW               31105   \n",
       " 896                              N Rhodes & 16th St N               31257   \n",
       " 1517      Henry Bacon Dr & Lincoln Memorial Circle NW               31226   \n",
       " ...                                               ...                 ...   \n",
       " 1111                                    8th & D St NW               31228   \n",
       " 1302                                    8th & H St NW               31281   \n",
       " 951                                    10th & U St NW               31252   \n",
       " 405                                     Thomas Circle               31285   \n",
       " 79                          Duke St & John Carlyle St               31048   \n",
       " \n",
       "                             End station Bike number Member type  \n",
       " Duration                                                         \n",
       " 435       7th St & Massachusetts Ave NE      W20369      Member  \n",
       " 1001               14th & Harvard St NW      W21068      Member  \n",
       " 1075               14th & Harvard St NW      W21003      Member  \n",
       " 896       22nd & I St NW / Foggy Bottom      W22766      Casual  \n",
       " 1517         34th St & Wisconsin Ave NW      W00232      Member  \n",
       " ...                                 ...         ...         ...  \n",
       " 1111                      8th & H St NW      W01306      Member  \n",
       " 1302                      8th & O St NW      W20466      Member  \n",
       " 951       21st St & Pennsylvania Ave NW      W20835      Member  \n",
       " 405                      22nd & P ST NW      W23481      Member  \n",
       " 79                  King St Metro South      W23455      Member  \n",
       " \n",
       " [403866 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 653       2019-05-01 00:00:02  2019-05-01 00:10:55                 31127   \n",
       " 297       2019-05-01 00:00:13  2019-05-01 00:05:11                 31641   \n",
       " 129       2019-05-01 00:00:36  2019-05-01 00:02:46                 31255   \n",
       " 1119      2019-05-01 00:01:08  2019-05-01 00:19:48                 31655   \n",
       " 533       2019-05-01 00:01:20  2019-05-01 00:10:13                 31203   \n",
       " ...                       ...                  ...                   ...   \n",
       " 434       2019-05-31 23:59:15  2019-06-01 00:06:30                 31281   \n",
       " 227       2019-05-31 23:59:45  2019-06-01 00:03:32                 31201   \n",
       " 1638      2019-05-31 23:59:45  2019-06-01 00:27:03                 31261   \n",
       " 1621      2019-05-31 23:59:51  2019-06-01 00:26:53                 31261   \n",
       " 373       2019-05-31 23:59:51  2019-06-01 00:06:04                 31281   \n",
       " \n",
       "                           Start station  End station number  \\\n",
       " Duration                                                      \n",
       " 653                      22nd & H St NW               31202   \n",
       " 297       2nd St & Massachusetts Ave NE               31603   \n",
       " 129                      24th & N St NW               31237   \n",
       " 1119           New Jersey Ave & F St NW               31244   \n",
       " 533          14th & Rhode Island Ave NW               31223   \n",
       " ...                                 ...                 ...   \n",
       " 434                       8th & O St NW               31627   \n",
       " 227                      15th & P St NW               31229   \n",
       " 1638      21st St & Constitution Ave NW               31247   \n",
       " 1621      21st St & Constitution Ave NW               31247   \n",
       " 373                       8th & O St NW               31201   \n",
       " \n",
       "                                 End station Bike number Member type  \n",
       " Duration                                                             \n",
       " 653                          14th & R St NW      W00233      Member  \n",
       " 297                           1st & M St NE      W00555      Member  \n",
       " 129           25th St & Pennsylvania Ave NW      W23383      Member  \n",
       " 1119                          4th & E St SW      W20337      Member  \n",
       " 533       Convention Center / 7th & M St NW      W23707      Member  \n",
       " ...                                     ...         ...         ...  \n",
       " 434                           3rd & M St NE      W23767      Member  \n",
       " 227             New Hampshire Ave & T St NW      W23691      Member  \n",
       " 1638              Jefferson Dr & 14th St SW      W20810      Member  \n",
       " 1621              Jefferson Dr & 14th St SW      W21714      Casual  \n",
       " 373                          15th & P St NW      W21769      Member  \n",
       " \n",
       " [337704 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 950       2018-09-01 00:01:16  2018-09-01 00:17:06                 31293   \n",
       " 310       2018-09-01 00:01:40  2018-09-01 00:06:50                 31401   \n",
       " 243       2018-09-01 00:01:41  2018-09-01 00:05:44                 31615   \n",
       " 518       2018-09-01 00:02:14  2018-09-01 00:10:52                 31615   \n",
       " 500       2018-09-01 00:02:22  2018-09-01 00:10:43                 31615   \n",
       " ...                       ...                  ...                   ...   \n",
       " 568       2018-09-30 23:57:07  2018-10-01 00:06:35                 31504   \n",
       " 873       2018-09-30 23:58:47  2018-10-01 00:13:20                 31246   \n",
       " 1565      2018-09-30 23:59:05  2018-10-01 00:25:10                 31609   \n",
       " 949       2018-09-30 23:59:18  2018-10-01 00:15:07                 31404   \n",
       " 349       2018-09-30 23:59:56  2018-10-01 00:05:45                 31127   \n",
       " \n",
       "                        Start station  End station number  \\\n",
       " Duration                                                   \n",
       " 950               31st & Water St NW               31080   \n",
       " 310           14th St & Spring Rd NW               31124   \n",
       " 243                    6th & H St NE               31623   \n",
       " 518                    6th & H St NE               31622   \n",
       " 500                    6th & H St NE               31622   \n",
       " ...                              ...                 ...   \n",
       " 568              10th & Monroe St NE               31502   \n",
       " 873       M St & Pennsylvania Ave NW               31600   \n",
       " 1565           Maine Ave & 7th St SW               31275   \n",
       " 949               9th & Upshur St NW               31505   \n",
       " 349                   22nd & H St NW               31295   \n",
       " \n",
       "                                   End station Bike number Member type  \n",
       " Duration                                                               \n",
       " 950                      Lee Hwy & N Scott St      W23491      Member  \n",
       " 310                       14th & Irving St NW      W23478      Member  \n",
       " 243           Columbus Circle / Union Station      W20202      Member  \n",
       " 518                            13th & D St NE      W21223      Member  \n",
       " 500                            13th & D St NE      W00509      Member  \n",
       " ...                                       ...         ...         ...  \n",
       " 568       John McCormack Dr & Michigan Ave NE      W21858      Member  \n",
       " 873                             5th & K St NW      W23151      Member  \n",
       " 1565           New Hampshire Ave & 24th St NW      W20163      Casual  \n",
       " 949                    Eckington Pl & Q St NE      W22096      Member  \n",
       " 349                         Potomac & M St NW      W22315      Member  \n",
       " \n",
       " [325800 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 207       2019-09-01 00:00:27  2019-09-01 00:03:54                 31246   \n",
       " 726       2019-09-01 00:00:46  2019-09-01 00:12:52                 31124   \n",
       " 4401      2019-09-01 00:00:48  2019-09-01 01:14:10                 31129   \n",
       " 388       2019-09-01 00:01:01  2019-09-01 00:07:30                 31648   \n",
       " 537       2019-09-01 00:01:09  2019-09-01 00:10:07                 31200   \n",
       " ...                       ...                  ...                   ...   \n",
       " 320       2019-09-30 23:56:02  2019-10-01 00:01:22                 31278   \n",
       " 3169      2019-09-30 23:56:19  2019-10-01 00:49:09                 31904   \n",
       " 2329      2019-09-30 23:57:39  2019-10-01 00:36:29                 31634   \n",
       " 1070      2019-09-30 23:58:23  2019-10-01 00:16:13                 31245   \n",
       " 269       2019-09-30 23:58:24  2019-10-01 00:02:53                 31017   \n",
       " \n",
       "                                               Start station  \\\n",
       " Duration                                                      \n",
       " 207                              M St & Pennsylvania Ave NW   \n",
       " 726                                     14th & Irving St NW   \n",
       " 4401                          15th St & Pennsylvania Ave NW   \n",
       " 388                                Potomac Ave & Half St SW   \n",
       " 537                    Massachusetts Ave & Dupont Circle NW   \n",
       " ...                                                     ...   \n",
       " 320                                          18th & R St NW   \n",
       " 3169      East Falls Church Metro / Sycamore St & 19th St N   \n",
       " 2329                                     3rd & Tingey St SE   \n",
       " 1070                           7th & R St NW / Shaw Library   \n",
       " 269                                 Wilson Blvd & N Uhle St   \n",
       " \n",
       "           End station number                     End station Bike number  \\\n",
       " Duration                                                                   \n",
       " 207                    31128                  23rd & M St NW      W21128   \n",
       " 726                    31116  California St & Florida Ave NW      W01208   \n",
       " 4401                   31277                  17th & G St NW      W23690   \n",
       " 388                    31609           Maine Ave & 7th St SW      W20449   \n",
       " 537                    31229     New Hampshire Ave & T St NW      W20206   \n",
       " ...                      ...                             ...         ...   \n",
       " 320                    31275  New Hampshire Ave & 24th St NW      W24335   \n",
       " 3169                   31324     18th & New Hampshire Ave NW      W23890   \n",
       " 2329                   31634              3rd & Tingey St SE      W22924   \n",
       " 1070                   31656       Maryland Ave & 17th St NE      W23228   \n",
       " 269                    31027           Key Blvd & N Quinn St      W24102   \n",
       " \n",
       "          Member type  \n",
       " Duration              \n",
       " 207           Member  \n",
       " 726           Member  \n",
       " 4401          Casual  \n",
       " 388           Member  \n",
       " 537           Member  \n",
       " ...              ...  \n",
       " 320           Member  \n",
       " 3169          Member  \n",
       " 2329          Member  \n",
       " 1070          Member  \n",
       " 269           Member  \n",
       " \n",
       " [360225 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 313       2019-04-01 00:03:03  2019-04-01 00:08:16                 31618   \n",
       " 453       2019-04-01 00:07:37  2019-04-01 00:15:10                 31119   \n",
       " 333       2019-04-01 00:09:31  2019-04-01 00:15:05                 31203   \n",
       " 568       2019-04-01 00:10:20  2019-04-01 00:19:49                 31202   \n",
       " 1609      2019-04-01 00:10:38  2019-04-01 00:37:28                 31517   \n",
       " ...                       ...                  ...                   ...   \n",
       " 1217      2019-04-30 23:54:03  2019-05-01 00:14:20                 31634   \n",
       " 1662      2019-04-30 23:55:16  2019-05-01 00:22:59                 31600   \n",
       " 1262      2019-04-30 23:55:56  2019-05-01 00:16:58                 31234   \n",
       " 453       2019-04-30 23:57:15  2019-05-01 00:04:48                 31245   \n",
       " 81        2019-04-30 23:58:29  2019-04-30 23:59:51                 31023   \n",
       " \n",
       "                           Start station  End station number  \\\n",
       " Duration                                                      \n",
       " 313            4th & East Capitol St NE               31630   \n",
       " 453                14th & Belmont St NW               31298   \n",
       " 333          14th & Rhode Island Ave NW               31519   \n",
       " 568                      14th & R St NW               31103   \n",
       " 1609                       Union Market               31655   \n",
       " ...                                 ...                 ...   \n",
       " 1217                 3rd & Tingey St SE               31601   \n",
       " 1662                      5th & K St NW               31703   \n",
       " 1262      20th & O St NW / Dupont South               31400   \n",
       " 453        7th & R St NW / Shaw Library               31229   \n",
       " 81             Fairfax Dr & Wilson Blvd               31040   \n",
       " \n",
       "                              End station Bike number Member type  \n",
       " Duration                                                          \n",
       " 313            15th & East Capitol St NE      W24063      Member  \n",
       " 453                       15th & M St NW      W22080      Member  \n",
       " 333                        1st & O St NW      W00276      Member  \n",
       " 568                 16th & Harvard St NW      W21582      Member  \n",
       " 1609            New Jersey Ave & F St NW       75558      Member  \n",
       " ...                                  ...         ...         ...  \n",
       " 1217           19th & East Capitol St SE      W23326      Casual  \n",
       " 1662            Minnesota Ave Metro/DOES      W24114      Member  \n",
       " 1262      Georgia & New Hampshire Ave NW      W23071      Member  \n",
       " 453          New Hampshire Ave & T St NW      W23786      Member  \n",
       " 81         GMU / Fairfax Dr & Kenmore St      W20818      Member  \n",
       " \n",
       " [347992 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 367       2018-04-01 00:00:07  2018-04-01 00:06:14                 31103   \n",
       " 653       2018-04-01 00:00:56  2018-04-01 00:11:49                 31201   \n",
       " 598       2018-04-01 00:02:06  2018-04-01 00:12:05                 31268   \n",
       " 2015      2018-04-01 00:03:47  2018-04-01 00:37:23                 31505   \n",
       " 563       2018-04-01 00:04:36  2018-04-01 00:14:00                 31214   \n",
       " ...                       ...                  ...                   ...   \n",
       " 3150      2018-04-30 23:57:07  2018-05-01 00:49:37                 31294   \n",
       " 3124      2018-04-30 23:57:12  2018-05-01 00:49:16                 31294   \n",
       " 383       2018-04-30 23:58:18  2018-05-01 00:04:41                 31299   \n",
       " 2977      2018-04-30 23:59:36  2018-05-01 00:49:13                 31294   \n",
       " 2960      2018-04-30 23:59:45  2018-05-01 00:49:06                 31294   \n",
       " \n",
       "                       Start station  End station number  \\\n",
       " Duration                                                  \n",
       " 367            16th & Harvard St NW               31214   \n",
       " 653                  15th & P St NW               31503   \n",
       " 598                  12th & U St NW               31251   \n",
       " 2015         Eckington Pl & Q St NE               31228   \n",
       " 563           17th & Corcoran St NW               31223   \n",
       " ...                             ...                 ...   \n",
       " 3150                  7th & E St SW               31044   \n",
       " 3124                  7th & E St SW               31044   \n",
       " 383       Connecticut Ave & R St NW               31251   \n",
       " 2977                  7th & E St SW               31044   \n",
       " 2960                  7th & E St SW               31044   \n",
       " \n",
       "                                 End station Bike number Member type  \n",
       " Duration                                                             \n",
       " 367                   17th & Corcoran St NW      W20968      Member  \n",
       " 653                   Florida Ave & R St NW      W20887      Member  \n",
       " 598                          12th & L St NW      W00133      Member  \n",
       " 2015                          8th & H St NW      W20534      Casual  \n",
       " 563       Convention Center / 7th & M St NW      W23117      Member  \n",
       " ...                                     ...         ...         ...  \n",
       " 3150                   King St & Patrick St      W21661      Casual  \n",
       " 3124                   King St & Patrick St      W20619      Casual  \n",
       " 383                          12th & L St NW      W21255      Member  \n",
       " 2977                   King St & Patrick St      W20534      Casual  \n",
       " 2960                   King St & Patrick St      W01125      Casual  \n",
       " \n",
       " [328907 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 790       2018-12-01 00:00:44  2018-12-01 00:13:54                 31203   \n",
       " 771       2018-12-01 00:00:55  2018-12-01 00:13:46                 31203   \n",
       " 775       2018-12-01 00:00:55  2018-12-01 00:13:51                 31203   \n",
       " 750       2018-12-01 00:01:08  2018-12-01 00:13:39                 31203   \n",
       " 146       2018-12-01 00:02:45  2018-12-01 00:05:11                 31124   \n",
       " ...                       ...                  ...                   ...   \n",
       " 3313      2018-12-31 23:37:22  2019-01-01 00:32:36                 31615   \n",
       " 888       2018-12-31 23:42:18  2018-12-31 23:57:07                 31618   \n",
       " 2332      2018-12-31 23:44:23  2019-01-01 00:23:16                 31907   \n",
       " 307       2018-12-31 23:52:42  2018-12-31 23:57:50                 31114   \n",
       " 1062      2018-12-31 23:54:09  2019-01-01 00:11:52                 31110   \n",
       " \n",
       "                        Start station  End station number  \\\n",
       " Duration                                                   \n",
       " 790       14th & Rhode Island Ave NW               31116   \n",
       " 771       14th & Rhode Island Ave NW               31116   \n",
       " 775       14th & Rhode Island Ave NW               31116   \n",
       " 750       14th & Rhode Island Ave NW               31116   \n",
       " 146              14th & Irving St NW               31102   \n",
       " ...                              ...                 ...   \n",
       " 3313                   6th & H St NE               31624   \n",
       " 888         4th & East Capitol St NE               31509   \n",
       " 2332      Franklin & S Washington St               32406   \n",
       " 307         18th St & Wyoming Ave NW               31103   \n",
       " 1062        20th St & Florida Ave NW               31014   \n",
       " \n",
       "                              End station Bike number Member type  \n",
       " Duration                                                          \n",
       " 790       California St & Florida Ave NW      W21477      Member  \n",
       " 771       California St & Florida Ave NW      W22810      Member  \n",
       " 775       California St & Florida Ave NW      W21144      Member  \n",
       " 750       California St & Florida Ave NW      W23321      Member  \n",
       " 146                  11th & Kenyon St NW      W22304      Member  \n",
       " ...                                  ...         ...         ...  \n",
       " 3313          North Capitol St & F St NW      W00159      Member  \n",
       " 888             New Jersey Ave & R St NW      W22026      Member  \n",
       " 2332            Fleet St & Waterfront St      W23900      Member  \n",
       " 307                 16th & Harvard St NW      W00761      Member  \n",
       " 1062                Lynn & 19th St North      W21324      Member  \n",
       " \n",
       " [158853 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 679       2018-05-01 00:00:00  2018-05-01 00:11:19                 31302   \n",
       " 578       2018-05-01 00:00:20  2018-05-01 00:09:59                 31232   \n",
       " 580       2018-05-01 00:00:28  2018-05-01 00:10:09                 31232   \n",
       " 606       2018-05-01 00:01:22  2018-05-01 00:11:29                 31104   \n",
       " 582       2018-05-01 00:04:52  2018-05-01 00:14:34                 31129   \n",
       " ...                       ...                  ...                   ...   \n",
       " 297       2018-05-31 23:57:30  2018-06-01 00:02:27                 31296   \n",
       " 179       2018-05-31 23:58:05  2018-06-01 00:01:04                 31116   \n",
       " 496       2018-05-31 23:59:00  2018-06-01 00:07:16                 31268   \n",
       " 761       2018-05-31 23:59:01  2018-06-01 00:11:42                 31110   \n",
       " 610       2018-05-31 23:59:01  2018-06-01 00:09:12                 31312   \n",
       " \n",
       "                                         Start station  End station number  \\\n",
       " Duration                                                                    \n",
       " 679                      Wisconsin Ave & Newark St NW               31307   \n",
       " 578         7th & F St NW / National Portrait Gallery               31609   \n",
       " 580         7th & F St NW / National Portrait Gallery               31609   \n",
       " 606                       Adams Mill & Columbia Rd NW               31509   \n",
       " 582       15th St & Pennsylvania Ave NW/Pershing Park               31118   \n",
       " ...                                               ...                 ...   \n",
       " 297                          Columbia & Ontario Rd NW               31116   \n",
       " 179                    California St & Florida Ave NW               31214   \n",
       " 496                                    12th & U St NW               31124   \n",
       " 761                          20th St & Florida Ave NW               31228   \n",
       " 610                           Wisconsin Ave & O St NW               31278   \n",
       " \n",
       "                                      End station Bike number Member type  \n",
       " Duration                                                                  \n",
       " 679       3000 Connecticut Ave NW / National Zoo      W22771      Member  \n",
       " 578                        Maine Ave & 7th St SW      W21320      Casual  \n",
       " 580                        Maine Ave & 7th St SW      W20863      Casual  \n",
       " 606                     New Jersey Ave & R St NW      W00822      Member  \n",
       " 582                              3rd & Elm St NW      W21846      Member  \n",
       " ...                                          ...         ...         ...  \n",
       " 297               California St & Florida Ave NW      W01336      Member  \n",
       " 179                        17th & Corcoran St NW      W22902      Member  \n",
       " 496                          14th & Irving St NW      W00969      Member  \n",
       " 761                                8th & H St NW      W23398      Member  \n",
       " 610                               18th & R St NW      W00808      Member  \n",
       " \n",
       " [374115 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 876       2018-11-01 00:00:45  2018-11-01 00:15:21                 31237   \n",
       " 308       2018-11-01 00:00:52  2018-11-01 00:06:00                 32204   \n",
       " 186       2018-11-01 00:01:46  2018-11-01 00:04:52                 31611   \n",
       " 988       2018-11-01 00:01:52  2018-11-01 00:18:20                 31289   \n",
       " 1454      2018-11-01 00:05:08  2018-11-01 00:29:23                 31107   \n",
       " ...                       ...                  ...                   ...   \n",
       " 434       2018-12-04 10:24:35  2018-12-04 10:31:50                 31638   \n",
       " 412       2018-12-04 10:24:54  2018-12-04 10:31:46                 31638   \n",
       " 461       2018-12-04 10:24:56  2018-12-04 10:32:38                 31282   \n",
       " 129       2018-12-04 10:24:57  2018-12-04 10:27:07                 31415   \n",
       " 263       2018-12-04 10:28:27  2018-12-04 10:32:50                 31016   \n",
       " \n",
       "                                         Start station  End station number  \\\n",
       " Duration                                                                    \n",
       " 876                     25th St & Pennsylvania Ave NW               31604   \n",
       " 308                             Tysons Corner Station               32229   \n",
       " 186                                    13th & H St NE               31632   \n",
       " 988       Henry Bacon Dr & Lincoln Memorial Circle NW               31204   \n",
       " 1454                          Lamont & Mt Pleasant NW               31509   \n",
       " ...                                               ...                 ...   \n",
       " 434                                     1st & H St NW               31603   \n",
       " 412                                     1st & H St NW               31603   \n",
       " 461                                    16th & R St NW               31117   \n",
       " 129                       Georgia Ave & Kennedy St NW               31407   \n",
       " 263                        Clarendon Blvd & Pierce St               31014   \n",
       " \n",
       "                         End station Bike number Member type  \n",
       " Duration                                                     \n",
       " 876                   3rd & H St NW      W00277      Member  \n",
       " 308              Park Run & Onyx Dr      W22007      Casual  \n",
       " 186                  15th & F St NE      W01105      Member  \n",
       " 988                  20th & E St NW      W21689      Casual  \n",
       " 1454       New Jersey Ave & R St NW      W22586      Casual  \n",
       " ...                             ...         ...         ...  \n",
       " 434                   1st & M St NE      W23394      Member  \n",
       " 412                   1st & M St NE      W21044      Member  \n",
       " 461            15th & Euclid St  NW      E00144      Member  \n",
       " 129       14th St & Colorado Ave NW      W01220      Member  \n",
       " 263            Lynn & 19th St North      W20983      Member  \n",
       " \n",
       " [221057 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 163       2019-12-01 00:00:25  2019-12-01 00:03:08                 31609   \n",
       " 309       2019-12-01 00:02:41  2019-12-01 00:07:50                 31104   \n",
       " 1527      2019-12-01 00:05:34  2019-12-01 00:31:02                 31106   \n",
       " 1509      2019-12-01 00:05:43  2019-12-01 00:30:53                 31106   \n",
       " 81        2019-12-01 00:06:04  2019-12-01 00:07:26                 31265   \n",
       " ...                       ...                  ...                   ...   \n",
       " 130       2019-12-31 23:57:36  2019-12-31 23:59:46                 31011   \n",
       " 664       2019-12-31 23:57:47  2020-01-01 00:08:51                 31125   \n",
       " 389       2019-12-31 23:59:37  2020-01-01 00:06:06                 31047   \n",
       " 962       2019-12-31 23:59:38  2020-01-01 00:15:40                 31236   \n",
       " 183       2019-12-31 23:59:55  2020-01-01 00:02:58                 31227   \n",
       " \n",
       "                                    Start station  End station number  \\\n",
       " Duration                                                               \n",
       " 163                        Maine Ave & 7th St SW               31294   \n",
       " 309                  Adams Mill & Columbia Rd NW               31602   \n",
       " 1527                    Calvert & Biltmore St NW               31301   \n",
       " 1509                    Calvert & Biltmore St NW               31301   \n",
       " 81                 5th St & Massachusetts Ave NW               31600   \n",
       " ...                                          ...                 ...   \n",
       " 130                       Crystal Dr & 23rd St S               31009   \n",
       " 664                               15th & W St NW               31281   \n",
       " 389                            Braddock Rd Metro               31085   \n",
       " 962       37th & O St NW / Georgetown University               31214   \n",
       " 183                    13th St & New York Ave NW               31254   \n",
       " \n",
       "                                 End station Bike number Member type  \n",
       " Duration                                                             \n",
       " 163                           7th & E St SW      W21186      Member  \n",
       " 309                 Park Rd & Holmead Pl NW      W23636      Member  \n",
       " 1527      Ward Circle / American University      W00501      Member  \n",
       " 1509      Ward Circle / American University      W22863      Member  \n",
       " 81                            5th & K St NW      W00236      Member  \n",
       " ...                                     ...         ...         ...  \n",
       " 130                  Crystal Dr & 27th St S      W21285      Member  \n",
       " 664                           8th & O St NW      W24197      Member  \n",
       " 389         Mount Vernon Ave & E Nelson Ave      W21281      Member  \n",
       " 962                   17th & Corcoran St NW      W00534      Member  \n",
       " 183                          15th & K St NW      W22782      Member  \n",
       " \n",
       " [161878 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 350       2018-06-01 00:01:28  2018-06-01 00:07:18                 31621   \n",
       " 234       2018-06-01 00:01:49  2018-06-01 00:05:44                 31234   \n",
       " 861       2018-06-01 00:03:01  2018-06-01 00:17:23                 31232   \n",
       " 848       2018-06-01 00:03:13  2018-06-01 00:17:22                 31232   \n",
       " 607       2018-06-01 00:04:28  2018-06-01 00:14:36                 31241   \n",
       " ...                       ...                  ...                   ...   \n",
       " 346       2018-06-30 23:58:24  2018-07-01 00:04:10                 32008   \n",
       " 335       2018-06-30 23:58:27  2018-07-01 00:04:02                 32008   \n",
       " 228       2018-06-30 23:59:22  2018-07-01 00:03:10                 31314   \n",
       " 266       2018-06-30 23:59:26  2018-07-01 00:03:52                 31638   \n",
       " 724       2018-06-30 23:59:44  2018-07-01 00:11:49                 31288   \n",
       " \n",
       "                                       Start station  End station number  \\\n",
       " Duration                                                                  \n",
       " 350                4th & D St NW / Judiciary Square               31641   \n",
       " 234                   20th & O St NW / Dupont South               31234   \n",
       " 861       7th & F St NW / National Portrait Gallery               31286   \n",
       " 848       7th & F St NW / National Portrait Gallery               31286   \n",
       " 607                                   Thomas Circle               31120   \n",
       " ...                                             ...                 ...   \n",
       " 346                           Cordell & Norfolk Ave               32055   \n",
       " 335                           Cordell & Norfolk Ave               32055   \n",
       " 228                              34th & Water St NW               31314   \n",
       " 266                                   1st & H St NW               31519   \n",
       " 724                          4th St & Madison Dr NW               31623   \n",
       " \n",
       "                               End station Bike number Member type  \n",
       " Duration                                                           \n",
       " 350         2nd St & Massachusetts Ave NE      W22714      Member  \n",
       " 234         20th & O St NW / Dupont South      W00190      Member  \n",
       " 861                        11th & O St NW      W22248      Casual  \n",
       " 848                        11th & O St NW      W20568      Casual  \n",
       " 607                 10th & Florida Ave NW      W23042      Member  \n",
       " ...                                   ...         ...         ...  \n",
       " 346          Woodmont Ave & Strathmore St      W00601      Member  \n",
       " 335          Woodmont Ave & Strathmore St      W23464      Member  \n",
       " 228                    34th & Water St NW      W22940      Member  \n",
       " 266                         1st & O St NW      W21868      Member  \n",
       " 724       Columbus Circle / Union Station      W20655      Casual  \n",
       " \n",
       " [392338 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 267       2018-07-01 00:00:58  2018-07-01 00:05:26                 31608   \n",
       " 530       2018-07-01 00:01:00  2018-07-01 00:09:50                 31230   \n",
       " 3223      2018-07-01 00:01:07  2018-07-01 00:54:50                 31620   \n",
       " 2153      2018-07-01 00:01:13  2018-07-01 00:37:06                 31258   \n",
       " 3214      2018-07-01 00:01:13  2018-07-01 00:54:47                 31620   \n",
       " ...                       ...                  ...                   ...   \n",
       " 434       2018-07-31 23:56:06  2018-08-01 00:03:20                 31204   \n",
       " 574       2018-07-31 23:56:35  2018-08-01 00:06:10                 31114   \n",
       " 557       2018-07-31 23:57:39  2018-08-01 00:06:57                 31278   \n",
       " 1202      2018-07-31 23:58:17  2018-08-01 00:18:19                 31646   \n",
       " 1149      2018-07-31 23:59:08  2018-08-01 00:18:18                 31646   \n",
       " \n",
       "                            Start station  End station number  \\\n",
       " Duration                                                       \n",
       " 267       8th & Eye St SE / Barracks Row               31610   \n",
       " 530        Metro Center / 12th & G St NW               31266   \n",
       " 3223                       5th & F St NW               31289   \n",
       " 2153                    Lincoln Memorial               31208   \n",
       " 3214                       5th & F St NW               31289   \n",
       " ...                                  ...                 ...   \n",
       " 434                       20th & E St NW               31257   \n",
       " 574             18th St & Wyoming Ave NW               31121   \n",
       " 557                       18th & R St NW               31281   \n",
       " 1202               Maine Ave & 9th St SW               31634   \n",
       " 1149               Maine Ave & 9th St SW               31634   \n",
       " \n",
       "                                            End station Bike number Member type  \n",
       " Duration                                                                        \n",
       " 267       Eastern Market / 7th & North Carolina Ave SE      W23296      Member  \n",
       " 530                                     11th & M St NW      W20838      Member  \n",
       " 3223       Henry Bacon Dr & Lincoln Memorial Circle NW      W22733      Member  \n",
       " 2153                          M St & New Jersey Ave SE      W00196      Casual  \n",
       " 3214       Henry Bacon Dr & Lincoln Memorial Circle NW      W21070      Member  \n",
       " ...                                                ...         ...         ...  \n",
       " 434                      22nd & I St NW / Foggy Bottom      W00440      Casual  \n",
       " 574                         Calvert St & Woodley Pl NW      W00172      Member  \n",
       " 557                                      8th & O St NW      W22875      Member  \n",
       " 1202                                3rd & Tingey St SE      W21951      Casual  \n",
       " 1149                                3rd & Tingey St SE      W22431      Casual  \n",
       " \n",
       " [404761 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 357       2019-08-01 00:00:34  2019-08-01 00:06:31                 31117   \n",
       " 1100      2019-08-01 00:01:48  2019-08-01 00:20:09                 31407   \n",
       " 1406      2019-08-01 00:04:04  2019-08-01 00:27:31                 31407   \n",
       " 3667      2019-08-01 00:05:09  2019-08-01 01:06:16                 31907   \n",
       " 282       2019-08-01 00:05:13  2019-08-01 00:09:56                 31201   \n",
       " ...                       ...                  ...                   ...   \n",
       " 228       2019-08-31 23:57:21  2019-09-01 00:01:10                 31102   \n",
       " 1587      2019-08-31 23:57:25  2019-09-01 00:23:53                 31256   \n",
       " 2187      2019-08-31 23:57:38  2019-09-01 00:34:06                 31288   \n",
       " 4473      2019-08-31 23:58:51  2019-09-01 01:13:25                 31129   \n",
       " 537       2019-08-31 23:59:10  2019-09-01 00:08:07                 31035   \n",
       " \n",
       "                           Start station  End station number  \\\n",
       " Duration                                                      \n",
       " 357                15th & Euclid St  NW               31115   \n",
       " 1100          14th St & Colorado Ave NW               31115   \n",
       " 1406          14th St & Colorado Ave NW               31234   \n",
       " 3667      Franklin St & S Washington St               31907   \n",
       " 282                      15th & P St NW               31234   \n",
       " ...                                 ...                 ...   \n",
       " 228                 11th & Kenyon St NW               31131   \n",
       " 1587                     10th & E St NW               31637   \n",
       " 2187             4th St & Madison Dr NW               31284   \n",
       " 4473      15th St & Pennsylvania Ave NW               31277   \n",
       " 537              N Quincy St & Glebe Rd               31020   \n",
       " \n",
       "                             End station Bike number Member type  \n",
       " Duration                                                         \n",
       " 357        Columbia Rd & Georgia Ave NW      W21052      Member  \n",
       " 1100       Columbia Rd & Georgia Ave NW      W01101      Member  \n",
       " 1406      20th & O St NW / Dupont South      W20870      Casual  \n",
       " 3667      Franklin St & S Washington St      W00966      Member  \n",
       " 282       20th & O St NW / Dupont South      W20443      Member  \n",
       " ...                                 ...         ...         ...  \n",
       " 228                   14th & Otis Pl NW      W22247      Member  \n",
       " 1587         North Capitol St & G Pl NE      W00444      Member  \n",
       " 2187                     18th & C St NW      W23287      Casual  \n",
       " 4473                     17th & G St NW      W01012      Casual  \n",
       " 537         Wilson Blvd & N Franklin Rd      W23816      Member  \n",
       " \n",
       " [360044 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 552       2018-01-01 00:05:06  2018-01-01 00:14:18                 31104   \n",
       " 1282      2018-01-01 00:14:30  2018-01-01 00:35:53                 31321   \n",
       " 1265      2018-01-01 00:14:53  2018-01-01 00:35:58                 31321   \n",
       " 578       2018-01-01 00:15:31  2018-01-01 00:25:09                 31406   \n",
       " 372       2018-01-01 00:18:02  2018-01-01 00:24:15                 31618   \n",
       " ...                       ...                  ...                   ...   \n",
       " 1377      2018-01-31 23:50:17  2018-02-01 00:13:14                 31200   \n",
       " 761       2018-01-31 23:52:43  2018-02-01 00:05:24                 31603   \n",
       " 738       2018-01-31 23:54:27  2018-02-01 00:06:45                 31107   \n",
       " 247       2018-01-31 23:56:31  2018-02-01 00:00:38                 31623   \n",
       " 953       2018-01-31 23:58:28  2018-02-01 00:14:22                 31634   \n",
       " \n",
       "                                  Start station  End station number  \\\n",
       " Duration                                                             \n",
       " 552                Adams Mill & Columbia Rd NW               31400   \n",
       " 1282             15th St & Constitution Ave NW               31321   \n",
       " 1265             15th St & Constitution Ave NW               31321   \n",
       " 578                        14th & Upshur St NW               31103   \n",
       " 372                   4th & East Capitol St NE               31619   \n",
       " ...                                        ...                 ...   \n",
       " 1377      Massachusetts Ave & Dupont Circle NW               31265   \n",
       " 761                              1st & M St NE               31628   \n",
       " 738                    Lamont & Mt Pleasant NW               31114   \n",
       " 247            Columbus Circle / Union Station               31612   \n",
       " 953                         3rd & Tingey St SE               31802   \n",
       " \n",
       "                                         End station Bike number Member type  \n",
       " Duration                                                                     \n",
       " 552                  Georgia & New Hampshire Ave NW      W00886      Member  \n",
       " 1282                  15th St & Constitution Ave NW      W01435      Casual  \n",
       " 1265                  15th St & Constitution Ave NW      W21242      Casual  \n",
       " 578                            16th & Harvard St NW      W21322      Casual  \n",
       " 372       Lincoln Park / 13th & East Capitol St NE       W00119      Member  \n",
       " ...                                             ...         ...         ...  \n",
       " 1377                  5th St & Massachusetts Ave NW      W21414      Casual  \n",
       " 761                                   1st & K St SE      W23213      Member  \n",
       " 738                        18th St & Wyoming Ave NW      W21373      Member  \n",
       " 247                          D St & Maryland Ave NE      W20936      Member  \n",
       " 953                       Good Hope Rd & MLK Ave SE      W01409      Member  \n",
       " \n",
       " [168590 rows x 8 columns],\n",
       "                    Start date             End date  Start station number  \\\n",
       " Duration                                                                   \n",
       " 839       2019-06-01 00:00:04  2019-06-01 00:14:03                 31245   \n",
       " 389       2019-06-01 00:00:13  2019-06-01 00:06:43                 31639   \n",
       " 270       2019-06-01 00:00:15  2019-06-01 00:04:46                 31228   \n",
       " 1029      2019-06-01 00:00:32  2019-06-01 00:17:41                 31251   \n",
       " 892       2019-06-01 00:00:33  2019-06-01 00:15:25                 31082   \n",
       " ...                       ...                  ...                   ...   \n",
       " 733       2019-06-30 23:57:17  2019-07-01 00:09:30                 31609   \n",
       " 5127      2019-06-30 23:58:11  2019-07-01 01:23:39                 31292   \n",
       " 5145      2019-06-30 23:58:24  2019-07-01 01:24:10                 31292   \n",
       " 331       2019-06-30 23:59:08  2019-07-01 00:04:39                 31610   \n",
       " 467       2019-06-30 23:59:17  2019-07-01 00:07:05                 31319   \n",
       " \n",
       "                                          Start station  End station number  \\\n",
       " Duration                                                                     \n",
       " 839                       7th & R St NW / Shaw Library               31508   \n",
       " 389                                      2nd & G St NE               31647   \n",
       " 270                                      8th & H St NW               31266   \n",
       " 1029                                    12th & L St NW               31508   \n",
       " 892                      Eisenhower Ave & Mill Race Ln               31088   \n",
       " ...                                                ...                 ...   \n",
       " 733                              Maine Ave & 7th St SW               31610   \n",
       " 5127                     22nd St & Constitution Ave NW               31261   \n",
       " 5145                     22nd St & Constitution Ave NW               31261   \n",
       " 331       Eastern Market / 7th & North Carolina Ave SE               31612   \n",
       " 467                   Wisconsin Ave & Brandywine St NW               32014   \n",
       " \n",
       "                                                 End station Bike number  \\\n",
       " Duration                                                                  \n",
       " 839                     Gallaudet / 8th St & Florida Ave NE      W23489   \n",
       " 389                           7th St & Massachusetts Ave NE      W00660   \n",
       " 270                                          11th & M St NW      W01010   \n",
       " 1029                    Gallaudet / 8th St & Florida Ave NE      W01313   \n",
       " 892                           Mount Vernon Ave & Kennedy St      W00623   \n",
       " ...                                                     ...         ...   \n",
       " 733            Eastern Market / 7th & North Carolina Ave SE      W22399   \n",
       " 5127                          21st St & Constitution Ave NW      W20536   \n",
       " 5145                          21st St & Constitution Ave NW      W20531   \n",
       " 331                                  D St & Maryland Ave NE      W00795   \n",
       " 467       Friendship Hts Metro / Wisconsin Ave & Wiscons...      W23253   \n",
       " \n",
       "          Member type  \n",
       " Duration              \n",
       " 839           Member  \n",
       " 389           Member  \n",
       " 270           Member  \n",
       " 1029          Member  \n",
       " 892           Member  \n",
       " ...              ...  \n",
       " 733           Casual  \n",
       " 5127          Casual  \n",
       " 5145          Casual  \n",
       " 331           Member  \n",
       " 467           Casual  \n",
       " \n",
       " [350144 rows x 8 columns]]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_list = [ v for k,v in fechas_dict.items()] \n",
    "df_list\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "trips_info = pd.concat(df_list, axis=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>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",
       "    <tr>\n",
       "      <th>Duration</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>429</th>\n",
       "      <td>2019-10-01 00:01:59</td>\n",
       "      <td>2019-10-01 00:09:08</td>\n",
       "      <td>31214</td>\n",
       "      <td>17th &amp; Corcoran St NW</td>\n",
       "      <td>31203</td>\n",
       "      <td>14th &amp; Rhode Island Ave NW</td>\n",
       "      <td>W23731</td>\n",
       "      <td>Member</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1935</th>\n",
       "      <td>2019-10-01 00:03:07</td>\n",
       "      <td>2019-10-01 00:35:23</td>\n",
       "      <td>31269</td>\n",
       "      <td>3rd St &amp; Pennsylvania Ave SE</td>\n",
       "      <td>31269</td>\n",
       "      <td>3rd St &amp; Pennsylvania Ave SE</td>\n",
       "      <td>W22377</td>\n",
       "      <td>Member</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>563</th>\n",
       "      <td>2019-10-01 00:03:51</td>\n",
       "      <td>2019-10-01 00:13:14</td>\n",
       "      <td>31214</td>\n",
       "      <td>17th &amp; Corcoran St NW</td>\n",
       "      <td>31251</td>\n",
       "      <td>12th &amp; L St NW</td>\n",
       "      <td>W23473</td>\n",
       "      <td>Member</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>625</th>\n",
       "      <td>2019-10-01 00:05:34</td>\n",
       "      <td>2019-10-01 00:15:59</td>\n",
       "      <td>31301</td>\n",
       "      <td>Ward Circle / American University</td>\n",
       "      <td>31317</td>\n",
       "      <td>Wisconsin Ave &amp; Ingomar St NW</td>\n",
       "      <td>W21371</td>\n",
       "      <td>Member</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>312</th>\n",
       "      <td>2019-10-01 00:05:47</td>\n",
       "      <td>2019-10-01 00:10:59</td>\n",
       "      <td>31519</td>\n",
       "      <td>1st &amp; O St NW</td>\n",
       "      <td>31109</td>\n",
       "      <td>7th &amp; T St NW</td>\n",
       "      <td>W23666</td>\n",
       "      <td>Member</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Start date             End date  Start station number  \\\n",
       "Duration                                                                   \n",
       "429       2019-10-01 00:01:59  2019-10-01 00:09:08                 31214   \n",
       "1935      2019-10-01 00:03:07  2019-10-01 00:35:23                 31269   \n",
       "563       2019-10-01 00:03:51  2019-10-01 00:13:14                 31214   \n",
       "625       2019-10-01 00:05:34  2019-10-01 00:15:59                 31301   \n",
       "312       2019-10-01 00:05:47  2019-10-01 00:10:59                 31519   \n",
       "\n",
       "                              Start station  End station number  \\\n",
       "Duration                                                          \n",
       "429                   17th & Corcoran St NW               31203   \n",
       "1935           3rd St & Pennsylvania Ave SE               31269   \n",
       "563                   17th & Corcoran St NW               31251   \n",
       "625       Ward Circle / American University               31317   \n",
       "312                           1st & O St NW               31109   \n",
       "\n",
       "                            End station Bike number Member type  \n",
       "Duration                                                         \n",
       "429          14th & Rhode Island Ave NW      W23731      Member  \n",
       "1935       3rd St & Pennsylvania Ave SE      W22377      Member  \n",
       "563                      12th & L St NW      W23473      Member  \n",
       "625       Wisconsin Ave & Ingomar St NW      W21371      Member  \n",
       "312                       7th & T St NW      W23666      Member  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "trips_info.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'/home/adalaber/Documents/ejercicios-de-adalab/project-DA-promo-B-module-3-team-3/Datos/data_trips/archivos_separados'"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "os.getcwd()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'/home/adalaber/Documents/ejercicios-de-adalab/project-DA-promo-B-module-3-team-3/Datos/data_trips/archivos_separados'"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "os.getcwd()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "trips_info.to_csv('/home/adalaber/Documents/ejercicios-de-adalab/project-DA-promo-B-module-3-team-3/Datos/data_trips/trips_bikes.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Columbus Circle / Union Station                122026\n",
       "Lincoln Memorial                                89137\n",
       "Jefferson Dr & 14th St SW                       76173\n",
       "Henry Bacon Dr & Lincoln Memorial Circle NW     75205\n",
       "4th St & Madison Dr NW                          74812\n",
       "                                                ...  \n",
       "Silver Spring Transit Center - Top Level           26\n",
       "Kenilworth Terrace & Hayes St. NE                  21\n",
       "Valley Ave & Wheeler Rd SE                          4\n",
       "Fort Stanton Rec Center                             2\n",
       "Ridge Rd Community Center                           1\n",
       "Name: Start station, Length: 665, dtype: int64"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "trips_info['Start station'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>data</th>\n",
       "      <th>last_updated</th>\n",
       "      <th>ttl</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>stations</th>\n",
       "      <td>[{'short_name': '31000', 'legacy_id': '1', 'st...</td>\n",
       "      <td>1665508146</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                       data  last_updated  ttl\n",
       "stations  [{'short_name': '31000', 'legacy_id': '1', 'st...    1665508146    5"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "station_info = pd.read_json('/home/adalaber/Documents/Python/station_information.json')\n",
    "station_info"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>687</th>\n",
       "      <th>688</th>\n",
       "      <th>689</th>\n",
       "      <th>690</th>\n",
       "      <th>691</th>\n",
       "      <th>692</th>\n",
       "      <th>693</th>\n",
       "      <th>694</th>\n",
       "      <th>695</th>\n",
       "      <th>696</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>{'short_name': '31000', 'legacy_id': '1', 'sta...</td>\n",
       "      <td>{'short_name': '31002', 'legacy_id': '3', 'sta...</td>\n",
       "      <td>{'short_name': '31003', 'legacy_id': '4', 'sta...</td>\n",
       "      <td>{'short_name': '31004', 'legacy_id': '5', 'sta...</td>\n",
       "      <td>{'short_name': '31005', 'legacy_id': '6', 'sta...</td>\n",
       "      <td>{'short_name': '31006', 'legacy_id': '7', 'sta...</td>\n",
       "      <td>{'short_name': '31007', 'legacy_id': '8', 'sta...</td>\n",
       "      <td>{'short_name': '31009', 'legacy_id': '10', 'st...</td>\n",
       "      <td>{'short_name': '31010', 'legacy_id': '11', 'st...</td>\n",
       "      <td>{'short_name': '31011', 'legacy_id': '12', 'st...</td>\n",
       "      <td>...</td>\n",
       "      <td>{'short_name': '31136', 'legacy_id': '742', 's...</td>\n",
       "      <td>{'short_name': '31676', 'legacy_id': '743', 's...</td>\n",
       "      <td>{'short_name': '31424', 'legacy_id': '744', 's...</td>\n",
       "      <td>{'short_name': '31974', 'legacy_id': '745', 's...</td>\n",
       "      <td>{'short_name': '31137', 'legacy_id': '746', 's...</td>\n",
       "      <td>{'short_name': '31828', 'legacy_id': '747', 's...</td>\n",
       "      <td>{'short_name': '31721', 'legacy_id': '748', 's...</td>\n",
       "      <td>{'short_name': '31138', 'legacy_id': '749', 's...</td>\n",
       "      <td>{'short_name': '31536', 'legacy_id': '750', 's...</td>\n",
       "      <td>{'short_name': '31976', 'legacy_id': '751', 's...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 697 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 0    \\\n",
       "0  {'short_name': '31000', 'legacy_id': '1', 'sta...   \n",
       "\n",
       "                                                 1    \\\n",
       "0  {'short_name': '31002', 'legacy_id': '3', 'sta...   \n",
       "\n",
       "                                                 2    \\\n",
       "0  {'short_name': '31003', 'legacy_id': '4', 'sta...   \n",
       "\n",
       "                                                 3    \\\n",
       "0  {'short_name': '31004', 'legacy_id': '5', 'sta...   \n",
       "\n",
       "                                                 4    \\\n",
       "0  {'short_name': '31005', 'legacy_id': '6', 'sta...   \n",
       "\n",
       "                                                 5    \\\n",
       "0  {'short_name': '31006', 'legacy_id': '7', 'sta...   \n",
       "\n",
       "                                                 6    \\\n",
       "0  {'short_name': '31007', 'legacy_id': '8', 'sta...   \n",
       "\n",
       "                                                 7    \\\n",
       "0  {'short_name': '31009', 'legacy_id': '10', 'st...   \n",
       "\n",
       "                                                 8    \\\n",
       "0  {'short_name': '31010', 'legacy_id': '11', 'st...   \n",
       "\n",
       "                                                 9    ...  \\\n",
       "0  {'short_name': '31011', 'legacy_id': '12', 'st...  ...   \n",
       "\n",
       "                                                 687  \\\n",
       "0  {'short_name': '31136', 'legacy_id': '742', 's...   \n",
       "\n",
       "                                                 688  \\\n",
       "0  {'short_name': '31676', 'legacy_id': '743', 's...   \n",
       "\n",
       "                                                 689  \\\n",
       "0  {'short_name': '31424', 'legacy_id': '744', 's...   \n",
       "\n",
       "                                                 690  \\\n",
       "0  {'short_name': '31974', 'legacy_id': '745', 's...   \n",
       "\n",
       "                                                 691  \\\n",
       "0  {'short_name': '31137', 'legacy_id': '746', 's...   \n",
       "\n",
       "                                                 692  \\\n",
       "0  {'short_name': '31828', 'legacy_id': '747', 's...   \n",
       "\n",
       "                                                 693  \\\n",
       "0  {'short_name': '31721', 'legacy_id': '748', 's...   \n",
       "\n",
       "                                                 694  \\\n",
       "0  {'short_name': '31138', 'legacy_id': '749', 's...   \n",
       "\n",
       "                                                 695  \\\n",
       "0  {'short_name': '31536', 'legacy_id': '750', 's...   \n",
       "\n",
       "                                                 696  \n",
       "0  {'short_name': '31976', 'legacy_id': '751', 's...  \n",
       "\n",
       "[1 rows x 697 columns]"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "station_info2 = station_info['data'].apply(pd.Series)\n",
    "station_info2.reset_index(inplace=True, drop=True)\n",
    "station_info2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>{'short_name': '31000', 'legacy_id': '1', 'sta...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>{'short_name': '31002', 'legacy_id': '3', 'sta...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>{'short_name': '31003', 'legacy_id': '4', 'sta...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>{'short_name': '31004', 'legacy_id': '5', 'sta...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>{'short_name': '31005', 'legacy_id': '6', 'sta...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>692</th>\n",
       "      <td>{'short_name': '31828', 'legacy_id': '747', 's...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>693</th>\n",
       "      <td>{'short_name': '31721', 'legacy_id': '748', 's...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>694</th>\n",
       "      <td>{'short_name': '31138', 'legacy_id': '749', 's...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>695</th>\n",
       "      <td>{'short_name': '31536', 'legacy_id': '750', 's...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>696</th>\n",
       "      <td>{'short_name': '31976', 'legacy_id': '751', 's...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>697 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                     0\n",
       "0    {'short_name': '31000', 'legacy_id': '1', 'sta...\n",
       "1    {'short_name': '31002', 'legacy_id': '3', 'sta...\n",
       "2    {'short_name': '31003', 'legacy_id': '4', 'sta...\n",
       "3    {'short_name': '31004', 'legacy_id': '5', 'sta...\n",
       "4    {'short_name': '31005', 'legacy_id': '6', 'sta...\n",
       "..                                                 ...\n",
       "692  {'short_name': '31828', 'legacy_id': '747', 's...\n",
       "693  {'short_name': '31721', 'legacy_id': '748', 's...\n",
       "694  {'short_name': '31138', 'legacy_id': '749', 's...\n",
       "695  {'short_name': '31536', 'legacy_id': '750', 's...\n",
       "696  {'short_name': '31976', 'legacy_id': '751', 's...\n",
       "\n",
       "[697 rows x 1 columns]"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stations = station_info2.T\n",
    "stations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>short_name</th>\n",
       "      <th>legacy_id</th>\n",
       "      <th>station_type</th>\n",
       "      <th>capacity</th>\n",
       "      <th>name</th>\n",
       "      <th>region_id</th>\n",
       "      <th>external_id</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>eightd_station_services</th>\n",
       "      <th>eightd_has_key_dispenser</th>\n",
       "      <th>station_id</th>\n",
       "      <th>rental_uris</th>\n",
       "      <th>rental_methods</th>\n",
       "      <th>has_kiosk</th>\n",
       "      <th>electric_bike_surcharge_waiver</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>31000</td>\n",
       "      <td>1</td>\n",
       "      <td>classic</td>\n",
       "      <td>15</td>\n",
       "      <td>Eads St &amp; 15th St S</td>\n",
       "      <td>41</td>\n",
       "      <td>082469cc-1f3f-11e7-bf6b-3863bb334450</td>\n",
       "      <td>38.858971</td>\n",
       "      <td>-77.053230</td>\n",
       "      <td>[]</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>{'android': 'https://dc.lft.to/lastmile_qr_sca...</td>\n",
       "      <td>[CREDITCARD, KEY]</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>31002</td>\n",
       "      <td>3</td>\n",
       "      <td>classic</td>\n",
       "      <td>17</td>\n",
       "      <td>Crystal Dr &amp; 20th St S</td>\n",
       "      <td>41</td>\n",
       "      <td>08246c35-1f3f-11e7-bf6b-3863bb334450</td>\n",
       "      <td>38.856425</td>\n",
       "      <td>-77.049232</td>\n",
       "      <td>[]</td>\n",
       "      <td>False</td>\n",
       "      <td>3</td>\n",
       "      <td>{'android': 'https://dc.lft.to/lastmile_qr_sca...</td>\n",
       "      <td>[CREDITCARD, KEY]</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>31003</td>\n",
       "      <td>4</td>\n",
       "      <td>classic</td>\n",
       "      <td>16</td>\n",
       "      <td>Crystal Dr &amp; 15th St S</td>\n",
       "      <td>41</td>\n",
       "      <td>08246cd5-1f3f-11e7-bf6b-3863bb334450</td>\n",
       "      <td>38.861056</td>\n",
       "      <td>-77.049417</td>\n",
       "      <td>[]</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>{'android': 'https://dc.lft.to/lastmile_qr_sca...</td>\n",
       "      <td>[CREDITCARD, KEY]</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>31004</td>\n",
       "      <td>5</td>\n",
       "      <td>classic</td>\n",
       "      <td>12</td>\n",
       "      <td>Aurora Hills Cmty Ctr / 18th St &amp; S Hayes St</td>\n",
       "      <td>41</td>\n",
       "      <td>08246d68-1f3f-11e7-bf6b-3863bb334450</td>\n",
       "      <td>38.857866</td>\n",
       "      <td>-77.059490</td>\n",
       "      <td>[]</td>\n",
       "      <td>False</td>\n",
       "      <td>5</td>\n",
       "      <td>{'android': 'https://dc.lft.to/lastmile_qr_sca...</td>\n",
       "      <td>[CREDITCARD, KEY]</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>31005</td>\n",
       "      <td>6</td>\n",
       "      <td>classic</td>\n",
       "      <td>19</td>\n",
       "      <td>Pentagon City Metro / 12th St &amp; S Hayes St</td>\n",
       "      <td>41</td>\n",
       "      <td>08246df5-1f3f-11e7-bf6b-3863bb334450</td>\n",
       "      <td>38.862303</td>\n",
       "      <td>-77.059936</td>\n",
       "      <td>[]</td>\n",
       "      <td>False</td>\n",
       "      <td>6</td>\n",
       "      <td>{'android': 'https://dc.lft.to/lastmile_qr_sca...</td>\n",
       "      <td>[CREDITCARD, KEY]</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  short_name legacy_id station_type  capacity  \\\n",
       "0      31000         1      classic        15   \n",
       "1      31002         3      classic        17   \n",
       "2      31003         4      classic        16   \n",
       "3      31004         5      classic        12   \n",
       "4      31005         6      classic        19   \n",
       "\n",
       "                                           name region_id  \\\n",
       "0                           Eads St & 15th St S        41   \n",
       "1                        Crystal Dr & 20th St S        41   \n",
       "2                        Crystal Dr & 15th St S        41   \n",
       "3  Aurora Hills Cmty Ctr / 18th St & S Hayes St        41   \n",
       "4    Pentagon City Metro / 12th St & S Hayes St        41   \n",
       "\n",
       "                            external_id        lat        lon  \\\n",
       "0  082469cc-1f3f-11e7-bf6b-3863bb334450  38.858971 -77.053230   \n",
       "1  08246c35-1f3f-11e7-bf6b-3863bb334450  38.856425 -77.049232   \n",
       "2  08246cd5-1f3f-11e7-bf6b-3863bb334450  38.861056 -77.049417   \n",
       "3  08246d68-1f3f-11e7-bf6b-3863bb334450  38.857866 -77.059490   \n",
       "4  08246df5-1f3f-11e7-bf6b-3863bb334450  38.862303 -77.059936   \n",
       "\n",
       "  eightd_station_services  eightd_has_key_dispenser station_id  \\\n",
       "0                      []                     False          1   \n",
       "1                      []                     False          3   \n",
       "2                      []                     False          4   \n",
       "3                      []                     False          5   \n",
       "4                      []                     False          6   \n",
       "\n",
       "                                         rental_uris     rental_methods  \\\n",
       "0  {'android': 'https://dc.lft.to/lastmile_qr_sca...  [CREDITCARD, KEY]   \n",
       "1  {'android': 'https://dc.lft.to/lastmile_qr_sca...  [CREDITCARD, KEY]   \n",
       "2  {'android': 'https://dc.lft.to/lastmile_qr_sca...  [CREDITCARD, KEY]   \n",
       "3  {'android': 'https://dc.lft.to/lastmile_qr_sca...  [CREDITCARD, KEY]   \n",
       "4  {'android': 'https://dc.lft.to/lastmile_qr_sca...  [CREDITCARD, KEY]   \n",
       "\n",
       "   has_kiosk  electric_bike_surcharge_waiver  \n",
       "0       True                           False  \n",
       "1       True                           False  \n",
       "2       True                           False  \n",
       "3       True                           False  \n",
       "4       True                           False  "
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stations = stations[0].apply(pd.Series)\n",
    "stations.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>short_name</th>\n",
       "      <th>capacity</th>\n",
       "      <th>name</th>\n",
       "      <th>region_id</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>31000</td>\n",
       "      <td>15</td>\n",
       "      <td>Eads St &amp; 15th St S</td>\n",
       "      <td>41</td>\n",
       "      <td>38.858971</td>\n",
       "      <td>-77.053230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>31002</td>\n",
       "      <td>17</td>\n",
       "      <td>Crystal Dr &amp; 20th St S</td>\n",
       "      <td>41</td>\n",
       "      <td>38.856425</td>\n",
       "      <td>-77.049232</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>31003</td>\n",
       "      <td>16</td>\n",
       "      <td>Crystal Dr &amp; 15th St S</td>\n",
       "      <td>41</td>\n",
       "      <td>38.861056</td>\n",
       "      <td>-77.049417</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>31004</td>\n",
       "      <td>12</td>\n",
       "      <td>Aurora Hills Cmty Ctr / 18th St &amp; S Hayes St</td>\n",
       "      <td>41</td>\n",
       "      <td>38.857866</td>\n",
       "      <td>-77.059490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>31005</td>\n",
       "      <td>19</td>\n",
       "      <td>Pentagon City Metro / 12th St &amp; S Hayes St</td>\n",
       "      <td>41</td>\n",
       "      <td>38.862303</td>\n",
       "      <td>-77.059936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>692</th>\n",
       "      <td>31828</td>\n",
       "      <td>19</td>\n",
       "      <td>New Jersey Ave &amp; H St SE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>38.880761</td>\n",
       "      <td>-77.005741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>693</th>\n",
       "      <td>31721</td>\n",
       "      <td>19</td>\n",
       "      <td>Anacostia Ave &amp; East Capitol St NE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>38.890461</td>\n",
       "      <td>-76.961280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>694</th>\n",
       "      <td>31138</td>\n",
       "      <td>15</td>\n",
       "      <td>4th &amp; College St NW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>38.921233</td>\n",
       "      <td>-77.018135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>695</th>\n",
       "      <td>31536</td>\n",
       "      <td>19</td>\n",
       "      <td>5th &amp; Morse St NE</td>\n",
       "      <td>42</td>\n",
       "      <td>38.907287</td>\n",
       "      <td>-76.999167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>696</th>\n",
       "      <td>31976</td>\n",
       "      <td>15</td>\n",
       "      <td>Virginia Hospital Center</td>\n",
       "      <td>41</td>\n",
       "      <td>38.887914</td>\n",
       "      <td>-77.128015</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>697 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    short_name  capacity                                          name  \\\n",
       "0        31000        15                           Eads St & 15th St S   \n",
       "1        31002        17                        Crystal Dr & 20th St S   \n",
       "2        31003        16                        Crystal Dr & 15th St S   \n",
       "3        31004        12  Aurora Hills Cmty Ctr / 18th St & S Hayes St   \n",
       "4        31005        19    Pentagon City Metro / 12th St & S Hayes St   \n",
       "..         ...       ...                                           ...   \n",
       "692      31828        19                      New Jersey Ave & H St SE   \n",
       "693      31721        19            Anacostia Ave & East Capitol St NE   \n",
       "694      31138        15                           4th & College St NW   \n",
       "695      31536        19                             5th & Morse St NE   \n",
       "696      31976        15                      Virginia Hospital Center   \n",
       "\n",
       "    region_id        lat        lon  \n",
       "0          41  38.858971 -77.053230  \n",
       "1          41  38.856425 -77.049232  \n",
       "2          41  38.861056 -77.049417  \n",
       "3          41  38.857866 -77.059490  \n",
       "4          41  38.862303 -77.059936  \n",
       "..        ...        ...        ...  \n",
       "692       NaN  38.880761 -77.005741  \n",
       "693       NaN  38.890461 -76.961280  \n",
       "694       NaN  38.921233 -77.018135  \n",
       "695        42  38.907287 -76.999167  \n",
       "696        41  38.887914 -77.128015  \n",
       "\n",
       "[697 rows x 6 columns]"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stations= stations[['short_name', 'capacity', 'name', 'region_id', 'lat', 'lon']]\n",
    "stations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "stations.to_csv('stations_info.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "42     345\n",
       "41     108\n",
       "40      60\n",
       "44      56\n",
       "104     54\n",
       "43      31\n",
       "133     27\n",
       "152     10\n",
       "Name: region_id, dtype: int64"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stations.region_id.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "6"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stations.region_id.isnull().sum()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.9.13 ('base')",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "0620710c65b0f5ccc651a2aa8870ae0eb4c70492424a8d7866846658189426a3"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}