Chicago Data_Descriptive Statistics.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>Unnamed: 0</th>\n",
       "      <th>Start Time</th>\n",
       "      <th>End Time</th>\n",
       "      <th>Trip Duration</th>\n",
       "      <th>Start Station</th>\n",
       "      <th>End Station</th>\n",
       "      <th>User Type</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Birth Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1423854</td>\n",
       "      <td>2017-06-23 15:09:32</td>\n",
       "      <td>2017-06-23 15:14:53</td>\n",
       "      <td>321</td>\n",
       "      <td>Wood St &amp; Hubbard St</td>\n",
       "      <td>Damen Ave &amp; Chicago Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1992.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>955915</td>\n",
       "      <td>2017-05-25 18:19:03</td>\n",
       "      <td>2017-05-25 18:45:53</td>\n",
       "      <td>1610</td>\n",
       "      <td>Theater on the Lake</td>\n",
       "      <td>Sheffield Ave &amp; Waveland Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1992.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>9031</td>\n",
       "      <td>2017-01-04 08:27:49</td>\n",
       "      <td>2017-01-04 08:34:45</td>\n",
       "      <td>416</td>\n",
       "      <td>May St &amp; Taylor St</td>\n",
       "      <td>Wood St &amp; Taylor St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1981.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>304487</td>\n",
       "      <td>2017-03-06 13:49:38</td>\n",
       "      <td>2017-03-06 13:55:28</td>\n",
       "      <td>350</td>\n",
       "      <td>Christiana Ave &amp; Lawrence Ave</td>\n",
       "      <td>St. Louis Ave &amp; Balmoral Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1986.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>45207</td>\n",
       "      <td>2017-01-17 14:53:07</td>\n",
       "      <td>2017-01-17 15:02:01</td>\n",
       "      <td>534</td>\n",
       "      <td>Clark St &amp; Randolph St</td>\n",
       "      <td>Desplaines St &amp; Jackson Blvd</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1975.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1473887</td>\n",
       "      <td>2017-06-26 09:01:20</td>\n",
       "      <td>2017-06-26 09:11:06</td>\n",
       "      <td>586</td>\n",
       "      <td>Clinton St &amp; Washington Blvd</td>\n",
       "      <td>Canal St &amp; Taylor St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>961916</td>\n",
       "      <td>2017-05-26 09:41:44</td>\n",
       "      <td>2017-05-26 09:46:25</td>\n",
       "      <td>281</td>\n",
       "      <td>Ashland Ave &amp; Lake St</td>\n",
       "      <td>Wood St &amp; Hubbard St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1983.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>65924</td>\n",
       "      <td>2017-01-21 14:28:38</td>\n",
       "      <td>2017-01-21 14:40:41</td>\n",
       "      <td>723</td>\n",
       "      <td>Larrabee St &amp; Kingsbury St</td>\n",
       "      <td>Larrabee St &amp; Armitage Ave</td>\n",
       "      <td>Customer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>606841</td>\n",
       "      <td>2017-04-20 16:08:51</td>\n",
       "      <td>2017-04-20 16:20:20</td>\n",
       "      <td>689</td>\n",
       "      <td>Sedgwick St &amp; Huron St</td>\n",
       "      <td>Halsted St &amp; Blackhawk St (*)</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1984.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>135470</td>\n",
       "      <td>2017-02-06 18:00:47</td>\n",
       "      <td>2017-02-06 18:09:00</td>\n",
       "      <td>493</td>\n",
       "      <td>Stetson Ave &amp; South Water St</td>\n",
       "      <td>Clinton St &amp; Washington Blvd</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1979.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>175805</td>\n",
       "      <td>2017-02-15 07:09:55</td>\n",
       "      <td>2017-02-15 07:14:56</td>\n",
       "      <td>301</td>\n",
       "      <td>Broadway &amp; Barry Ave</td>\n",
       "      <td>Wilton Ave &amp; Belmont Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1993.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>71678</td>\n",
       "      <td>2017-01-22 15:15:45</td>\n",
       "      <td>2017-01-22 15:31:02</td>\n",
       "      <td>917</td>\n",
       "      <td>Southport Ave &amp; Wellington Ave</td>\n",
       "      <td>Clark St &amp; Schiller St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1964.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>19061</td>\n",
       "      <td>2017-01-08 16:03:00</td>\n",
       "      <td>2017-01-08 16:07:37</td>\n",
       "      <td>277</td>\n",
       "      <td>Green St &amp; Madison St</td>\n",
       "      <td>Ada St &amp; Washington Blvd</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1961.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1023296</td>\n",
       "      <td>2017-05-30 15:46:18</td>\n",
       "      <td>2017-05-30 15:52:12</td>\n",
       "      <td>354</td>\n",
       "      <td>Larrabee St &amp; Kingsbury St</td>\n",
       "      <td>Clark St &amp; Elm St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1985.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>611000</td>\n",
       "      <td>2017-04-20 19:26:33</td>\n",
       "      <td>2017-04-20 19:35:08</td>\n",
       "      <td>515</td>\n",
       "      <td>Canal St &amp; Madison St</td>\n",
       "      <td>Racine Ave (May St) &amp; Fulton St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1984.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>958716</td>\n",
       "      <td>2017-05-25 22:59:33</td>\n",
       "      <td>2017-05-25 23:07:19</td>\n",
       "      <td>466</td>\n",
       "      <td>Clark St &amp; Armitage Ave</td>\n",
       "      <td>Sheffield Ave &amp; Wrightwood Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1985.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>718598</td>\n",
       "      <td>2017-05-03 13:20:38</td>\n",
       "      <td>2017-05-03 13:31:13</td>\n",
       "      <td>635</td>\n",
       "      <td>Ada St &amp; Washington Blvd</td>\n",
       "      <td>Daley Center Plaza</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1967.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>931608</td>\n",
       "      <td>2017-05-23 08:08:25</td>\n",
       "      <td>2017-05-23 08:11:09</td>\n",
       "      <td>164</td>\n",
       "      <td>Damen Ave &amp; Cortland St</td>\n",
       "      <td>Marshfield Ave &amp; Cortland St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1469705</td>\n",
       "      <td>2017-06-25 21:26:30</td>\n",
       "      <td>2017-06-25 21:33:44</td>\n",
       "      <td>434</td>\n",
       "      <td>State St &amp; Pearson St</td>\n",
       "      <td>Clark St &amp; Schiller St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1987.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>475456</td>\n",
       "      <td>2017-04-08 11:37:55</td>\n",
       "      <td>2017-04-08 11:51:55</td>\n",
       "      <td>840</td>\n",
       "      <td>Adler Planetarium</td>\n",
       "      <td>Burnham Harbor</td>\n",
       "      <td>Customer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>849468</td>\n",
       "      <td>2017-05-16 06:36:17</td>\n",
       "      <td>2017-05-16 06:59:34</td>\n",
       "      <td>1397</td>\n",
       "      <td>Michigan Ave &amp; Oak St</td>\n",
       "      <td>Halsted St &amp; Wrightwood Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1992.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1420915</td>\n",
       "      <td>2017-06-23 12:21:01</td>\n",
       "      <td>2017-06-23 12:32:54</td>\n",
       "      <td>713</td>\n",
       "      <td>Rush St &amp; Cedar St</td>\n",
       "      <td>Halsted St &amp; Willow St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1985.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>161454</td>\n",
       "      <td>2017-02-12 15:24:29</td>\n",
       "      <td>2017-02-12 15:38:43</td>\n",
       "      <td>854</td>\n",
       "      <td>Clarendon Ave &amp; Leland Ave</td>\n",
       "      <td>Lake Shore Dr &amp; Belmont Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1980.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1413814</td>\n",
       "      <td>2017-06-22 19:14:37</td>\n",
       "      <td>2017-06-22 19:29:54</td>\n",
       "      <td>917</td>\n",
       "      <td>Bissell St &amp; Armitage Ave</td>\n",
       "      <td>Orleans St &amp; Chestnut St (NEXT Apts)</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1989.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>717248</td>\n",
       "      <td>2017-05-03 09:41:11</td>\n",
       "      <td>2017-05-03 09:49:10</td>\n",
       "      <td>479</td>\n",
       "      <td>Wabash Ave &amp; Roosevelt Rd</td>\n",
       "      <td>Halsted St &amp; Roosevelt Rd</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1992.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1451810</td>\n",
       "      <td>2017-06-24 20:47:40</td>\n",
       "      <td>2017-06-24 21:13:39</td>\n",
       "      <td>1559</td>\n",
       "      <td>Rush St &amp; Cedar St</td>\n",
       "      <td>Halsted St &amp; Roscoe St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1968.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>385517</td>\n",
       "      <td>2017-03-23 09:38:27</td>\n",
       "      <td>2017-03-23 09:42:41</td>\n",
       "      <td>254</td>\n",
       "      <td>Loomis St &amp; Jackson Blvd</td>\n",
       "      <td>Peoria St &amp; Jackson Blvd</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1985.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1186035</td>\n",
       "      <td>2017-06-09 07:48:55</td>\n",
       "      <td>2017-06-09 07:52:30</td>\n",
       "      <td>215</td>\n",
       "      <td>Canal St &amp; Madison St</td>\n",
       "      <td>Clark St &amp; Randolph St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1974.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>512692</td>\n",
       "      <td>2017-04-11 18:49:57</td>\n",
       "      <td>2017-04-11 18:59:36</td>\n",
       "      <td>579</td>\n",
       "      <td>Clinton St &amp; Lake St</td>\n",
       "      <td>Mies van der Rohe Way &amp; Chestnut St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1989.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>261757</td>\n",
       "      <td>2017-02-25 19:01:19</td>\n",
       "      <td>2017-02-25 19:08:10</td>\n",
       "      <td>411</td>\n",
       "      <td>Halsted St &amp; Dickens Ave</td>\n",
       "      <td>Halsted St &amp; Wrightwood Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1970.0</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299970</th>\n",
       "      <td>1225370</td>\n",
       "      <td>2017-06-11 11:13:43</td>\n",
       "      <td>2017-06-11 11:21:48</td>\n",
       "      <td>485</td>\n",
       "      <td>Cornell Ave &amp; Hyde Park Blvd</td>\n",
       "      <td>Ellis Ave &amp; 55th St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299971</th>\n",
       "      <td>852513</td>\n",
       "      <td>2017-05-16 09:18:52</td>\n",
       "      <td>2017-05-16 09:38:02</td>\n",
       "      <td>1150</td>\n",
       "      <td>Dusable Harbor</td>\n",
       "      <td>Theater on the Lake</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1976.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299972</th>\n",
       "      <td>44015</td>\n",
       "      <td>2017-01-17 08:42:37</td>\n",
       "      <td>2017-01-17 08:53:20</td>\n",
       "      <td>643</td>\n",
       "      <td>Racine Ave &amp; Wrightwood Ave</td>\n",
       "      <td>Clark St &amp; Wellington Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1978.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299973</th>\n",
       "      <td>199144</td>\n",
       "      <td>2017-02-18 12:30:15</td>\n",
       "      <td>2017-02-18 12:51:14</td>\n",
       "      <td>1259</td>\n",
       "      <td>Indiana Ave &amp; Roosevelt Rd</td>\n",
       "      <td>Adler Planetarium</td>\n",
       "      <td>Customer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299974</th>\n",
       "      <td>568663</td>\n",
       "      <td>2017-04-17 07:16:38</td>\n",
       "      <td>2017-04-17 07:25:08</td>\n",
       "      <td>510</td>\n",
       "      <td>Halsted St &amp; Maxwell St</td>\n",
       "      <td>Clark St &amp; 9th St (AMLI)</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>2000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299975</th>\n",
       "      <td>49643</td>\n",
       "      <td>2017-01-18 11:28:36</td>\n",
       "      <td>2017-01-18 11:31:14</td>\n",
       "      <td>158</td>\n",
       "      <td>Dayton St &amp; North Ave</td>\n",
       "      <td>Sheffield Ave &amp; Kingsbury St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1958.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299976</th>\n",
       "      <td>722876</td>\n",
       "      <td>2017-05-03 18:45:24</td>\n",
       "      <td>2017-05-03 22:42:09</td>\n",
       "      <td>14205</td>\n",
       "      <td>Paulina Ave &amp; North Ave</td>\n",
       "      <td>Bissell St &amp; Armitage Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299977</th>\n",
       "      <td>685382</td>\n",
       "      <td>2017-04-27 17:30:16</td>\n",
       "      <td>2017-04-27 17:45:16</td>\n",
       "      <td>900</td>\n",
       "      <td>Clinton St &amp; Jackson Blvd</td>\n",
       "      <td>Dearborn Pkwy &amp; Delaware Pl</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1989.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299978</th>\n",
       "      <td>1242195</td>\n",
       "      <td>2017-06-12 08:35:11</td>\n",
       "      <td>2017-06-12 08:44:20</td>\n",
       "      <td>549</td>\n",
       "      <td>St. Clair St &amp; Erie St</td>\n",
       "      <td>Michigan Ave &amp; Lake St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1971.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299979</th>\n",
       "      <td>441330</td>\n",
       "      <td>2017-04-02 12:42:10</td>\n",
       "      <td>2017-04-02 12:51:33</td>\n",
       "      <td>563</td>\n",
       "      <td>Bissell St &amp; Armitage Ave</td>\n",
       "      <td>Clark St &amp; Armitage Ave</td>\n",
       "      <td>Customer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299980</th>\n",
       "      <td>474051</td>\n",
       "      <td>2017-04-08 09:26:36</td>\n",
       "      <td>2017-04-08 09:43:50</td>\n",
       "      <td>1034</td>\n",
       "      <td>Theater on the Lake</td>\n",
       "      <td>Michigan Ave &amp; Oak St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1976.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299981</th>\n",
       "      <td>1212375</td>\n",
       "      <td>2017-06-10 14:52:58</td>\n",
       "      <td>2017-06-10 15:29:52</td>\n",
       "      <td>2214</td>\n",
       "      <td>Franklin St &amp; Jackson Blvd</td>\n",
       "      <td>Lake Shore Dr &amp; North Blvd</td>\n",
       "      <td>Customer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299982</th>\n",
       "      <td>845283</td>\n",
       "      <td>2017-05-15 17:59:48</td>\n",
       "      <td>2017-05-15 18:05:29</td>\n",
       "      <td>341</td>\n",
       "      <td>Kingsbury St &amp; Kinzie St</td>\n",
       "      <td>Clinton St &amp; Jackson Blvd</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1993.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299983</th>\n",
       "      <td>216083</td>\n",
       "      <td>2017-02-19 14:46:44</td>\n",
       "      <td>2017-02-19 14:58:48</td>\n",
       "      <td>724</td>\n",
       "      <td>Lakeview Ave &amp; Fullerton Pkwy</td>\n",
       "      <td>Halsted St &amp; Roscoe St</td>\n",
       "      <td>Customer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299984</th>\n",
       "      <td>454645</td>\n",
       "      <td>2017-04-04 17:16:49</td>\n",
       "      <td>2017-04-04 17:35:00</td>\n",
       "      <td>1091</td>\n",
       "      <td>Damen Ave &amp; Wellington Ave</td>\n",
       "      <td>Clifton Ave &amp; Lawrence Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1987.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299985</th>\n",
       "      <td>712351</td>\n",
       "      <td>2017-05-02 17:45:19</td>\n",
       "      <td>2017-05-02 17:52:00</td>\n",
       "      <td>401</td>\n",
       "      <td>Canal St &amp; Monroe St (*)</td>\n",
       "      <td>Milwaukee Ave &amp; Grand Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1991.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299986</th>\n",
       "      <td>1464340</td>\n",
       "      <td>2017-06-25 16:17:53</td>\n",
       "      <td>2017-06-25 16:51:21</td>\n",
       "      <td>2008</td>\n",
       "      <td>Shedd Aquarium</td>\n",
       "      <td>LaSalle St &amp; Washington St</td>\n",
       "      <td>Customer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299987</th>\n",
       "      <td>436160</td>\n",
       "      <td>2017-04-01 15:18:51</td>\n",
       "      <td>2017-04-01 15:34:55</td>\n",
       "      <td>964</td>\n",
       "      <td>Sheffield Ave &amp; Wellington Ave</td>\n",
       "      <td>Larrabee St &amp; Armitage Ave</td>\n",
       "      <td>Customer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299988</th>\n",
       "      <td>634638</td>\n",
       "      <td>2017-04-23 13:40:15</td>\n",
       "      <td>2017-04-23 14:00:33</td>\n",
       "      <td>1218</td>\n",
       "      <td>Lake Shore Dr &amp; Monroe St</td>\n",
       "      <td>Adler Planetarium</td>\n",
       "      <td>Customer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299989</th>\n",
       "      <td>1005203</td>\n",
       "      <td>2017-05-29 13:45:56</td>\n",
       "      <td>2017-05-29 13:54:15</td>\n",
       "      <td>499</td>\n",
       "      <td>Green St &amp; Madison St</td>\n",
       "      <td>Canal St &amp; Taylor St</td>\n",
       "      <td>Customer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299990</th>\n",
       "      <td>1444489</td>\n",
       "      <td>2017-06-24 15:28:12</td>\n",
       "      <td>2017-06-24 16:08:11</td>\n",
       "      <td>2399</td>\n",
       "      <td>Rush St &amp; Cedar St</td>\n",
       "      <td>Pine Grove Ave &amp; Waveland Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1989.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299991</th>\n",
       "      <td>723217</td>\n",
       "      <td>2017-05-03 19:15:23</td>\n",
       "      <td>2017-05-03 19:29:32</td>\n",
       "      <td>849</td>\n",
       "      <td>Milwaukee Ave &amp; Wabansia Ave</td>\n",
       "      <td>Ashland Ave &amp; Chicago Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1982.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299992</th>\n",
       "      <td>1327248</td>\n",
       "      <td>2017-06-17 16:44:16</td>\n",
       "      <td>2017-06-17 16:50:57</td>\n",
       "      <td>401</td>\n",
       "      <td>Sheffield Ave &amp; Willow St</td>\n",
       "      <td>Halsted St &amp; Dickens Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1955.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299993</th>\n",
       "      <td>68299</td>\n",
       "      <td>2017-01-21 17:16:02</td>\n",
       "      <td>2017-01-21 17:55:11</td>\n",
       "      <td>2349</td>\n",
       "      <td>Lake Shore Dr &amp; Monroe St</td>\n",
       "      <td>McClurg Ct &amp; Erie St</td>\n",
       "      <td>Customer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299994</th>\n",
       "      <td>935129</td>\n",
       "      <td>2017-05-23 17:08:04</td>\n",
       "      <td>2017-05-23 17:11:37</td>\n",
       "      <td>213</td>\n",
       "      <td>Indiana Ave &amp; 31st St</td>\n",
       "      <td>MLK Jr Dr &amp; 29th St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1988.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299995</th>\n",
       "      <td>64825</td>\n",
       "      <td>2017-01-21 13:18:00</td>\n",
       "      <td>2017-01-21 13:27:50</td>\n",
       "      <td>590</td>\n",
       "      <td>Orleans St &amp; Elm St (*)</td>\n",
       "      <td>Sheffield Ave &amp; Webster Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1965.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299996</th>\n",
       "      <td>695993</td>\n",
       "      <td>2017-04-28 19:32:19</td>\n",
       "      <td>2017-04-28 19:51:18</td>\n",
       "      <td>1139</td>\n",
       "      <td>Ashland Ave &amp; Blackhawk St</td>\n",
       "      <td>Clark St &amp; Elm St</td>\n",
       "      <td>Customer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299997</th>\n",
       "      <td>159685</td>\n",
       "      <td>2017-02-12 09:59:01</td>\n",
       "      <td>2017-02-12 10:21:49</td>\n",
       "      <td>1368</td>\n",
       "      <td>Ravenswood Ave &amp; Lawrence Ave</td>\n",
       "      <td>Stockton Dr &amp; Wrightwood Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1988.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299998</th>\n",
       "      <td>564681</td>\n",
       "      <td>2017-04-16 17:07:15</td>\n",
       "      <td>2017-04-16 17:19:00</td>\n",
       "      <td>705</td>\n",
       "      <td>Sheffield Ave &amp; Willow St</td>\n",
       "      <td>Clark St &amp; Chicago Ave</td>\n",
       "      <td>Customer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299999</th>\n",
       "      <td>1021247</td>\n",
       "      <td>2017-05-30 12:38:28</td>\n",
       "      <td>2017-05-30 12:55:36</td>\n",
       "      <td>1028</td>\n",
       "      <td>Wacker Dr &amp; Washington St</td>\n",
       "      <td>Damen Ave &amp; Division St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1984.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>300000 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Unnamed: 0           Start Time             End Time  Trip Duration  \\\n",
       "0          1423854  2017-06-23 15:09:32  2017-06-23 15:14:53            321   \n",
       "1           955915  2017-05-25 18:19:03  2017-05-25 18:45:53           1610   \n",
       "2             9031  2017-01-04 08:27:49  2017-01-04 08:34:45            416   \n",
       "3           304487  2017-03-06 13:49:38  2017-03-06 13:55:28            350   \n",
       "4            45207  2017-01-17 14:53:07  2017-01-17 15:02:01            534   \n",
       "5          1473887  2017-06-26 09:01:20  2017-06-26 09:11:06            586   \n",
       "6           961916  2017-05-26 09:41:44  2017-05-26 09:46:25            281   \n",
       "7            65924  2017-01-21 14:28:38  2017-01-21 14:40:41            723   \n",
       "8           606841  2017-04-20 16:08:51  2017-04-20 16:20:20            689   \n",
       "9           135470  2017-02-06 18:00:47  2017-02-06 18:09:00            493   \n",
       "10          175805  2017-02-15 07:09:55  2017-02-15 07:14:56            301   \n",
       "11           71678  2017-01-22 15:15:45  2017-01-22 15:31:02            917   \n",
       "12           19061  2017-01-08 16:03:00  2017-01-08 16:07:37            277   \n",
       "13         1023296  2017-05-30 15:46:18  2017-05-30 15:52:12            354   \n",
       "14          611000  2017-04-20 19:26:33  2017-04-20 19:35:08            515   \n",
       "15          958716  2017-05-25 22:59:33  2017-05-25 23:07:19            466   \n",
       "16          718598  2017-05-03 13:20:38  2017-05-03 13:31:13            635   \n",
       "17          931608  2017-05-23 08:08:25  2017-05-23 08:11:09            164   \n",
       "18         1469705  2017-06-25 21:26:30  2017-06-25 21:33:44            434   \n",
       "19          475456  2017-04-08 11:37:55  2017-04-08 11:51:55            840   \n",
       "20          849468  2017-05-16 06:36:17  2017-05-16 06:59:34           1397   \n",
       "21         1420915  2017-06-23 12:21:01  2017-06-23 12:32:54            713   \n",
       "22          161454  2017-02-12 15:24:29  2017-02-12 15:38:43            854   \n",
       "23         1413814  2017-06-22 19:14:37  2017-06-22 19:29:54            917   \n",
       "24          717248  2017-05-03 09:41:11  2017-05-03 09:49:10            479   \n",
       "25         1451810  2017-06-24 20:47:40  2017-06-24 21:13:39           1559   \n",
       "26          385517  2017-03-23 09:38:27  2017-03-23 09:42:41            254   \n",
       "27         1186035  2017-06-09 07:48:55  2017-06-09 07:52:30            215   \n",
       "28          512692  2017-04-11 18:49:57  2017-04-11 18:59:36            579   \n",
       "29          261757  2017-02-25 19:01:19  2017-02-25 19:08:10            411   \n",
       "...            ...                  ...                  ...            ...   \n",
       "299970     1225370  2017-06-11 11:13:43  2017-06-11 11:21:48            485   \n",
       "299971      852513  2017-05-16 09:18:52  2017-05-16 09:38:02           1150   \n",
       "299972       44015  2017-01-17 08:42:37  2017-01-17 08:53:20            643   \n",
       "299973      199144  2017-02-18 12:30:15  2017-02-18 12:51:14           1259   \n",
       "299974      568663  2017-04-17 07:16:38  2017-04-17 07:25:08            510   \n",
       "299975       49643  2017-01-18 11:28:36  2017-01-18 11:31:14            158   \n",
       "299976      722876  2017-05-03 18:45:24  2017-05-03 22:42:09          14205   \n",
       "299977      685382  2017-04-27 17:30:16  2017-04-27 17:45:16            900   \n",
       "299978     1242195  2017-06-12 08:35:11  2017-06-12 08:44:20            549   \n",
       "299979      441330  2017-04-02 12:42:10  2017-04-02 12:51:33            563   \n",
       "299980      474051  2017-04-08 09:26:36  2017-04-08 09:43:50           1034   \n",
       "299981     1212375  2017-06-10 14:52:58  2017-06-10 15:29:52           2214   \n",
       "299982      845283  2017-05-15 17:59:48  2017-05-15 18:05:29            341   \n",
       "299983      216083  2017-02-19 14:46:44  2017-02-19 14:58:48            724   \n",
       "299984      454645  2017-04-04 17:16:49  2017-04-04 17:35:00           1091   \n",
       "299985      712351  2017-05-02 17:45:19  2017-05-02 17:52:00            401   \n",
       "299986     1464340  2017-06-25 16:17:53  2017-06-25 16:51:21           2008   \n",
       "299987      436160  2017-04-01 15:18:51  2017-04-01 15:34:55            964   \n",
       "299988      634638  2017-04-23 13:40:15  2017-04-23 14:00:33           1218   \n",
       "299989     1005203  2017-05-29 13:45:56  2017-05-29 13:54:15            499   \n",
       "299990     1444489  2017-06-24 15:28:12  2017-06-24 16:08:11           2399   \n",
       "299991      723217  2017-05-03 19:15:23  2017-05-03 19:29:32            849   \n",
       "299992     1327248  2017-06-17 16:44:16  2017-06-17 16:50:57            401   \n",
       "299993       68299  2017-01-21 17:16:02  2017-01-21 17:55:11           2349   \n",
       "299994      935129  2017-05-23 17:08:04  2017-05-23 17:11:37            213   \n",
       "299995       64825  2017-01-21 13:18:00  2017-01-21 13:27:50            590   \n",
       "299996      695993  2017-04-28 19:32:19  2017-04-28 19:51:18           1139   \n",
       "299997      159685  2017-02-12 09:59:01  2017-02-12 10:21:49           1368   \n",
       "299998      564681  2017-04-16 17:07:15  2017-04-16 17:19:00            705   \n",
       "299999     1021247  2017-05-30 12:38:28  2017-05-30 12:55:36           1028   \n",
       "\n",
       "                         Start Station                           End Station  \\\n",
       "0                 Wood St & Hubbard St               Damen Ave & Chicago Ave   \n",
       "1                  Theater on the Lake          Sheffield Ave & Waveland Ave   \n",
       "2                   May St & Taylor St                   Wood St & Taylor St   \n",
       "3        Christiana Ave & Lawrence Ave          St. Louis Ave & Balmoral Ave   \n",
       "4               Clark St & Randolph St          Desplaines St & Jackson Blvd   \n",
       "5         Clinton St & Washington Blvd                  Canal St & Taylor St   \n",
       "6                Ashland Ave & Lake St                  Wood St & Hubbard St   \n",
       "7           Larrabee St & Kingsbury St            Larrabee St & Armitage Ave   \n",
       "8               Sedgwick St & Huron St         Halsted St & Blackhawk St (*)   \n",
       "9         Stetson Ave & South Water St          Clinton St & Washington Blvd   \n",
       "10                Broadway & Barry Ave              Wilton Ave & Belmont Ave   \n",
       "11      Southport Ave & Wellington Ave                Clark St & Schiller St   \n",
       "12               Green St & Madison St              Ada St & Washington Blvd   \n",
       "13          Larrabee St & Kingsbury St                     Clark St & Elm St   \n",
       "14               Canal St & Madison St       Racine Ave (May St) & Fulton St   \n",
       "15             Clark St & Armitage Ave        Sheffield Ave & Wrightwood Ave   \n",
       "16            Ada St & Washington Blvd                    Daley Center Plaza   \n",
       "17             Damen Ave & Cortland St          Marshfield Ave & Cortland St   \n",
       "18               State St & Pearson St                Clark St & Schiller St   \n",
       "19                   Adler Planetarium                        Burnham Harbor   \n",
       "20               Michigan Ave & Oak St           Halsted St & Wrightwood Ave   \n",
       "21                  Rush St & Cedar St                Halsted St & Willow St   \n",
       "22          Clarendon Ave & Leland Ave           Lake Shore Dr & Belmont Ave   \n",
       "23           Bissell St & Armitage Ave  Orleans St & Chestnut St (NEXT Apts)   \n",
       "24           Wabash Ave & Roosevelt Rd             Halsted St & Roosevelt Rd   \n",
       "25                  Rush St & Cedar St                Halsted St & Roscoe St   \n",
       "26            Loomis St & Jackson Blvd              Peoria St & Jackson Blvd   \n",
       "27               Canal St & Madison St                Clark St & Randolph St   \n",
       "28                Clinton St & Lake St   Mies van der Rohe Way & Chestnut St   \n",
       "29            Halsted St & Dickens Ave           Halsted St & Wrightwood Ave   \n",
       "...                                ...                                   ...   \n",
       "299970    Cornell Ave & Hyde Park Blvd                   Ellis Ave & 55th St   \n",
       "299971                  Dusable Harbor                   Theater on the Lake   \n",
       "299972     Racine Ave & Wrightwood Ave             Clark St & Wellington Ave   \n",
       "299973      Indiana Ave & Roosevelt Rd                     Adler Planetarium   \n",
       "299974         Halsted St & Maxwell St              Clark St & 9th St (AMLI)   \n",
       "299975           Dayton St & North Ave          Sheffield Ave & Kingsbury St   \n",
       "299976         Paulina Ave & North Ave             Bissell St & Armitage Ave   \n",
       "299977       Clinton St & Jackson Blvd           Dearborn Pkwy & Delaware Pl   \n",
       "299978          St. Clair St & Erie St                Michigan Ave & Lake St   \n",
       "299979       Bissell St & Armitage Ave               Clark St & Armitage Ave   \n",
       "299980             Theater on the Lake                 Michigan Ave & Oak St   \n",
       "299981      Franklin St & Jackson Blvd            Lake Shore Dr & North Blvd   \n",
       "299982        Kingsbury St & Kinzie St             Clinton St & Jackson Blvd   \n",
       "299983   Lakeview Ave & Fullerton Pkwy                Halsted St & Roscoe St   \n",
       "299984      Damen Ave & Wellington Ave            Clifton Ave & Lawrence Ave   \n",
       "299985        Canal St & Monroe St (*)             Milwaukee Ave & Grand Ave   \n",
       "299986                  Shedd Aquarium            LaSalle St & Washington St   \n",
       "299987  Sheffield Ave & Wellington Ave            Larrabee St & Armitage Ave   \n",
       "299988       Lake Shore Dr & Monroe St                     Adler Planetarium   \n",
       "299989           Green St & Madison St                  Canal St & Taylor St   \n",
       "299990              Rush St & Cedar St         Pine Grove Ave & Waveland Ave   \n",
       "299991    Milwaukee Ave & Wabansia Ave             Ashland Ave & Chicago Ave   \n",
       "299992       Sheffield Ave & Willow St              Halsted St & Dickens Ave   \n",
       "299993       Lake Shore Dr & Monroe St                  McClurg Ct & Erie St   \n",
       "299994           Indiana Ave & 31st St                   MLK Jr Dr & 29th St   \n",
       "299995         Orleans St & Elm St (*)           Sheffield Ave & Webster Ave   \n",
       "299996      Ashland Ave & Blackhawk St                     Clark St & Elm St   \n",
       "299997   Ravenswood Ave & Lawrence Ave          Stockton Dr & Wrightwood Ave   \n",
       "299998       Sheffield Ave & Willow St                Clark St & Chicago Ave   \n",
       "299999       Wacker Dr & Washington St               Damen Ave & Division St   \n",
       "\n",
       "         User Type  Gender  Birth Year  \n",
       "0       Subscriber    Male      1992.0  \n",
       "1       Subscriber  Female      1992.0  \n",
       "2       Subscriber    Male      1981.0  \n",
       "3       Subscriber    Male      1986.0  \n",
       "4       Subscriber    Male      1975.0  \n",
       "5       Subscriber    Male      1990.0  \n",
       "6       Subscriber  Female      1983.0  \n",
       "7         Customer     NaN         NaN  \n",
       "8       Subscriber    Male      1984.0  \n",
       "9       Subscriber    Male      1979.0  \n",
       "10      Subscriber  Female      1993.0  \n",
       "11      Subscriber    Male      1964.0  \n",
       "12      Subscriber    Male      1961.0  \n",
       "13      Subscriber    Male      1985.0  \n",
       "14      Subscriber    Male      1984.0  \n",
       "15      Subscriber  Female      1985.0  \n",
       "16      Subscriber    Male      1967.0  \n",
       "17      Subscriber    Male      1990.0  \n",
       "18      Subscriber    Male      1987.0  \n",
       "19        Customer     NaN         NaN  \n",
       "20      Subscriber  Female      1992.0  \n",
       "21      Subscriber    Male      1985.0  \n",
       "22      Subscriber    Male      1980.0  \n",
       "23      Subscriber  Female      1989.0  \n",
       "24      Subscriber    Male      1992.0  \n",
       "25      Subscriber    Male      1968.0  \n",
       "26      Subscriber  Female      1985.0  \n",
       "27      Subscriber    Male      1974.0  \n",
       "28      Subscriber    Male      1989.0  \n",
       "29      Subscriber    Male      1970.0  \n",
       "...            ...     ...         ...  \n",
       "299970  Subscriber    Male      1990.0  \n",
       "299971  Subscriber    Male      1976.0  \n",
       "299972  Subscriber  Female      1978.0  \n",
       "299973    Customer     NaN         NaN  \n",
       "299974  Subscriber    Male      2000.0  \n",
       "299975  Subscriber    Male      1958.0  \n",
       "299976  Subscriber    Male      1990.0  \n",
       "299977  Subscriber    Male      1989.0  \n",
       "299978  Subscriber  Female      1971.0  \n",
       "299979    Customer     NaN         NaN  \n",
       "299980  Subscriber  Female      1976.0  \n",
       "299981    Customer     NaN         NaN  \n",
       "299982  Subscriber    Male      1993.0  \n",
       "299983    Customer     NaN         NaN  \n",
       "299984  Subscriber    Male      1987.0  \n",
       "299985  Subscriber    Male      1991.0  \n",
       "299986    Customer     NaN         NaN  \n",
       "299987    Customer     NaN         NaN  \n",
       "299988    Customer     NaN         NaN  \n",
       "299989    Customer     NaN         NaN  \n",
       "299990  Subscriber    Male      1989.0  \n",
       "299991  Subscriber  Female      1982.0  \n",
       "299992  Subscriber    Male      1955.0  \n",
       "299993    Customer     NaN         NaN  \n",
       "299994  Subscriber    Male      1988.0  \n",
       "299995  Subscriber    Male      1965.0  \n",
       "299996    Customer     NaN         NaN  \n",
       "299997  Subscriber  Female      1988.0  \n",
       "299998    Customer     NaN         NaN  \n",
       "299999  Subscriber    Male      1984.0  \n",
       "\n",
       "[300000 rows x 9 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#importing packages\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import seaborn as sns\n",
    "#loading data\n",
    "chicago=pd.read_csv('chicago.csv')\n",
    "#printing data\n",
    "chicago"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Start Time</th>\n",
       "      <th>End Time</th>\n",
       "      <th>Trip Duration</th>\n",
       "      <th>Start Station</th>\n",
       "      <th>End Station</th>\n",
       "      <th>User Type</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Birth Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1423854</td>\n",
       "      <td>2017-06-23 15:09:32</td>\n",
       "      <td>2017-06-23 15:14:53</td>\n",
       "      <td>321</td>\n",
       "      <td>Wood St &amp; Hubbard St</td>\n",
       "      <td>Damen Ave &amp; Chicago Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1992.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>955915</td>\n",
       "      <td>2017-05-25 18:19:03</td>\n",
       "      <td>2017-05-25 18:45:53</td>\n",
       "      <td>1610</td>\n",
       "      <td>Theater on the Lake</td>\n",
       "      <td>Sheffield Ave &amp; Waveland Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1992.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>9031</td>\n",
       "      <td>2017-01-04 08:27:49</td>\n",
       "      <td>2017-01-04 08:34:45</td>\n",
       "      <td>416</td>\n",
       "      <td>May St &amp; Taylor St</td>\n",
       "      <td>Wood St &amp; Taylor St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1981.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>304487</td>\n",
       "      <td>2017-03-06 13:49:38</td>\n",
       "      <td>2017-03-06 13:55:28</td>\n",
       "      <td>350</td>\n",
       "      <td>Christiana Ave &amp; Lawrence Ave</td>\n",
       "      <td>St. Louis Ave &amp; Balmoral Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1986.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>45207</td>\n",
       "      <td>2017-01-17 14:53:07</td>\n",
       "      <td>2017-01-17 15:02:01</td>\n",
       "      <td>534</td>\n",
       "      <td>Clark St &amp; Randolph St</td>\n",
       "      <td>Desplaines St &amp; Jackson Blvd</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1975.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0           Start Time             End Time  Trip Duration  \\\n",
       "0     1423854  2017-06-23 15:09:32  2017-06-23 15:14:53            321   \n",
       "1      955915  2017-05-25 18:19:03  2017-05-25 18:45:53           1610   \n",
       "2        9031  2017-01-04 08:27:49  2017-01-04 08:34:45            416   \n",
       "3      304487  2017-03-06 13:49:38  2017-03-06 13:55:28            350   \n",
       "4       45207  2017-01-17 14:53:07  2017-01-17 15:02:01            534   \n",
       "\n",
       "                   Start Station                   End Station   User Type  \\\n",
       "0           Wood St & Hubbard St       Damen Ave & Chicago Ave  Subscriber   \n",
       "1            Theater on the Lake  Sheffield Ave & Waveland Ave  Subscriber   \n",
       "2             May St & Taylor St           Wood St & Taylor St  Subscriber   \n",
       "3  Christiana Ave & Lawrence Ave  St. Louis Ave & Balmoral Ave  Subscriber   \n",
       "4         Clark St & Randolph St  Desplaines St & Jackson Blvd  Subscriber   \n",
       "\n",
       "   Gender  Birth Year  \n",
       "0    Male      1992.0  \n",
       "1  Female      1992.0  \n",
       "2    Male      1981.0  \n",
       "3    Male      1986.0  \n",
       "4    Male      1975.0  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#performing head()\n",
    "chicago.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Start Time</th>\n",
       "      <th>End Time</th>\n",
       "      <th>Trip Duration</th>\n",
       "      <th>Start Station</th>\n",
       "      <th>End Station</th>\n",
       "      <th>User Type</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Birth Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>299995</th>\n",
       "      <td>64825</td>\n",
       "      <td>2017-01-21 13:18:00</td>\n",
       "      <td>2017-01-21 13:27:50</td>\n",
       "      <td>590</td>\n",
       "      <td>Orleans St &amp; Elm St (*)</td>\n",
       "      <td>Sheffield Ave &amp; Webster Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1965.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299996</th>\n",
       "      <td>695993</td>\n",
       "      <td>2017-04-28 19:32:19</td>\n",
       "      <td>2017-04-28 19:51:18</td>\n",
       "      <td>1139</td>\n",
       "      <td>Ashland Ave &amp; Blackhawk St</td>\n",
       "      <td>Clark St &amp; Elm St</td>\n",
       "      <td>Customer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299997</th>\n",
       "      <td>159685</td>\n",
       "      <td>2017-02-12 09:59:01</td>\n",
       "      <td>2017-02-12 10:21:49</td>\n",
       "      <td>1368</td>\n",
       "      <td>Ravenswood Ave &amp; Lawrence Ave</td>\n",
       "      <td>Stockton Dr &amp; Wrightwood Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1988.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299998</th>\n",
       "      <td>564681</td>\n",
       "      <td>2017-04-16 17:07:15</td>\n",
       "      <td>2017-04-16 17:19:00</td>\n",
       "      <td>705</td>\n",
       "      <td>Sheffield Ave &amp; Willow St</td>\n",
       "      <td>Clark St &amp; Chicago Ave</td>\n",
       "      <td>Customer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299999</th>\n",
       "      <td>1021247</td>\n",
       "      <td>2017-05-30 12:38:28</td>\n",
       "      <td>2017-05-30 12:55:36</td>\n",
       "      <td>1028</td>\n",
       "      <td>Wacker Dr &amp; Washington St</td>\n",
       "      <td>Damen Ave &amp; Division St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1984.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Unnamed: 0           Start Time             End Time  Trip Duration  \\\n",
       "299995       64825  2017-01-21 13:18:00  2017-01-21 13:27:50            590   \n",
       "299996      695993  2017-04-28 19:32:19  2017-04-28 19:51:18           1139   \n",
       "299997      159685  2017-02-12 09:59:01  2017-02-12 10:21:49           1368   \n",
       "299998      564681  2017-04-16 17:07:15  2017-04-16 17:19:00            705   \n",
       "299999     1021247  2017-05-30 12:38:28  2017-05-30 12:55:36           1028   \n",
       "\n",
       "                        Start Station                   End Station  \\\n",
       "299995        Orleans St & Elm St (*)   Sheffield Ave & Webster Ave   \n",
       "299996     Ashland Ave & Blackhawk St             Clark St & Elm St   \n",
       "299997  Ravenswood Ave & Lawrence Ave  Stockton Dr & Wrightwood Ave   \n",
       "299998      Sheffield Ave & Willow St        Clark St & Chicago Ave   \n",
       "299999      Wacker Dr & Washington St       Damen Ave & Division St   \n",
       "\n",
       "         User Type  Gender  Birth Year  \n",
       "299995  Subscriber    Male      1965.0  \n",
       "299996    Customer     NaN         NaN  \n",
       "299997  Subscriber  Female      1988.0  \n",
       "299998    Customer     NaN         NaN  \n",
       "299999  Subscriber    Male      1984.0  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#performing tail()\n",
    "chicago.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 300000 entries, 0 to 299999\n",
      "Data columns (total 9 columns):\n",
      "Unnamed: 0       300000 non-null int64\n",
      "Start Time       300000 non-null object\n",
      "End Time         300000 non-null object\n",
      "Trip Duration    300000 non-null int64\n",
      "Start Station    300000 non-null object\n",
      "End Station      300000 non-null object\n",
      "User Type        300000 non-null object\n",
      "Gender           238948 non-null object\n",
      "Birth Year       238981 non-null float64\n",
      "dtypes: float64(1), int64(2), object(6)\n",
      "memory usage: 20.6+ MB\n"
     ]
    }
   ],
   "source": [
    "#performing information\n",
    "chicago.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Trip Duration</th>\n",
       "      <th>Birth Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>3.000000e+05</td>\n",
       "      <td>300000.000000</td>\n",
       "      <td>238981.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>7.763458e+05</td>\n",
       "      <td>936.239290</td>\n",
       "      <td>1980.858223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>4.481464e+05</td>\n",
       "      <td>1548.792767</td>\n",
       "      <td>11.003329</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>4.000000e+00</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>1899.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>3.871368e+05</td>\n",
       "      <td>393.000000</td>\n",
       "      <td>1975.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>7.771035e+05</td>\n",
       "      <td>670.000000</td>\n",
       "      <td>1984.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>1.164065e+06</td>\n",
       "      <td>1125.000000</td>\n",
       "      <td>1989.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1.551500e+06</td>\n",
       "      <td>86224.000000</td>\n",
       "      <td>2016.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Unnamed: 0  Trip Duration     Birth Year\n",
       "count  3.000000e+05  300000.000000  238981.000000\n",
       "mean   7.763458e+05     936.239290    1980.858223\n",
       "std    4.481464e+05    1548.792767      11.003329\n",
       "min    4.000000e+00      60.000000    1899.000000\n",
       "25%    3.871368e+05     393.000000    1975.000000\n",
       "50%    7.771035e+05     670.000000    1984.000000\n",
       "75%    1.164065e+06    1125.000000    1989.000000\n",
       "max    1.551500e+06   86224.000000    2016.000000"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#performing describe\n",
    "chicago.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}