Washington Data_Descriptive Statistics.ipynb

{
 "cells": [
  {
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1621326</td>\n",
       "      <td>2017-06-21 08:36:34</td>\n",
       "      <td>2017-06-21 08:44:43</td>\n",
       "      <td>489.066</td>\n",
       "      <td>14th &amp; Belmont St NW</td>\n",
       "      <td>15th &amp; K St NW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>482740</td>\n",
       "      <td>2017-03-11 10:40:00</td>\n",
       "      <td>2017-03-11 10:46:00</td>\n",
       "      <td>402.549</td>\n",
       "      <td>Yuma St &amp; Tenley Circle NW</td>\n",
       "      <td>Connecticut Ave &amp; Yuma St NW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1330037</td>\n",
       "      <td>2017-05-30 01:02:59</td>\n",
       "      <td>2017-05-30 01:13:37</td>\n",
       "      <td>637.251</td>\n",
       "      <td>17th St &amp; Massachusetts Ave NW</td>\n",
       "      <td>5th &amp; K St NW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>665458</td>\n",
       "      <td>2017-04-02 07:48:35</td>\n",
       "      <td>2017-04-02 08:19:03</td>\n",
       "      <td>1827.341</td>\n",
       "      <td>Constitution Ave &amp; 2nd St NW/DOL</td>\n",
       "      <td>M St &amp; Pennsylvania Ave NW</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1481135</td>\n",
       "      <td>2017-06-10 08:36:28</td>\n",
       "      <td>2017-06-10 09:02:17</td>\n",
       "      <td>1549.427</td>\n",
       "      <td>Henry Bacon Dr &amp; Lincoln Memorial Circle NW</td>\n",
       "      <td>Maine Ave &amp; 7th St SW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1148202</td>\n",
       "      <td>2017-05-14 07:18:18</td>\n",
       "      <td>2017-05-14 07:24:56</td>\n",
       "      <td>398.000</td>\n",
       "      <td>1st &amp; K St SE</td>\n",
       "      <td>Eastern Market Metro / Pennsylvania Ave &amp; 7th ...</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1594275</td>\n",
       "      <td>2017-06-19 08:41:43</td>\n",
       "      <td>2017-06-19 09:00:08</td>\n",
       "      <td>1105.429</td>\n",
       "      <td>Park Rd &amp; Holmead Pl NW</td>\n",
       "      <td>8th &amp; H St NW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1601832</td>\n",
       "      <td>2017-06-20 05:54:42</td>\n",
       "      <td>2017-06-20 06:05:18</td>\n",
       "      <td>636.218</td>\n",
       "      <td>1st &amp; D St SE</td>\n",
       "      <td>Potomac &amp; Pennsylvania Ave SE</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>574182</td>\n",
       "      <td>2017-03-24 20:37:00</td>\n",
       "      <td>2017-03-24 20:42:00</td>\n",
       "      <td>328.530</td>\n",
       "      <td>18th &amp; R St NW</td>\n",
       "      <td>15th &amp; P St NW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>327058</td>\n",
       "      <td>2017-02-20 21:12:00</td>\n",
       "      <td>2017-02-20 21:31:00</td>\n",
       "      <td>1188.090</td>\n",
       "      <td>17th &amp; Corcoran St NW</td>\n",
       "      <td>Lynn &amp; 19th St North</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>854729</td>\n",
       "      <td>2017-04-17 02:50:51</td>\n",
       "      <td>2017-04-17 03:05:17</td>\n",
       "      <td>866.689</td>\n",
       "      <td>37th &amp; O St NW / Georgetown University</td>\n",
       "      <td>37th &amp; O St NW / Georgetown University</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>721887</td>\n",
       "      <td>2017-04-08 01:12:48</td>\n",
       "      <td>2017-04-08 01:52:33</td>\n",
       "      <td>2385.411</td>\n",
       "      <td>10th &amp; G St NW</td>\n",
       "      <td>5th St &amp; Massachusetts Ave NW</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>143181</td>\n",
       "      <td>2017-01-26 20:01:00</td>\n",
       "      <td>2017-01-26 20:17:00</td>\n",
       "      <td>951.457</td>\n",
       "      <td>10th St &amp; L'Enfant Plaza SW</td>\n",
       "      <td>1st &amp; Rhode Island Ave NW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>26953</td>\n",
       "      <td>2017-01-06 17:36:00</td>\n",
       "      <td>2017-01-06 17:43:00</td>\n",
       "      <td>448.628</td>\n",
       "      <td>North Capitol St &amp; F St NW</td>\n",
       "      <td>1st &amp; M St NE</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1308542</td>\n",
       "      <td>2017-05-28 03:50:26</td>\n",
       "      <td>2017-05-28 04:24:26</td>\n",
       "      <td>2039.472</td>\n",
       "      <td>Henry Bacon Dr &amp; Lincoln Memorial Circle NW</td>\n",
       "      <td>Lincoln Memorial</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1592744</td>\n",
       "      <td>2017-06-19 07:46:35</td>\n",
       "      <td>2017-06-19 07:55:00</td>\n",
       "      <td>505.482</td>\n",
       "      <td>Metro Center / 12th &amp; G St NW</td>\n",
       "      <td>North Capitol St &amp; G Pl NE</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1139713</td>\n",
       "      <td>2017-05-13 11:29:16</td>\n",
       "      <td>2017-05-13 11:55:47</td>\n",
       "      <td>1591.326</td>\n",
       "      <td>16th &amp; Harvard St NW</td>\n",
       "      <td>New York Ave &amp; 15th St NW</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1478516</td>\n",
       "      <td>2017-06-10 06:04:41</td>\n",
       "      <td>2017-06-10 06:32:33</td>\n",
       "      <td>1672.075</td>\n",
       "      <td>17th St &amp; Massachusetts Ave NW</td>\n",
       "      <td>15th &amp; East Capitol St NE</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>679837</td>\n",
       "      <td>2017-04-03 10:22:19</td>\n",
       "      <td>2017-04-03 10:26:11</td>\n",
       "      <td>231.952</td>\n",
       "      <td>20th &amp; Crystal Dr</td>\n",
       "      <td>6th &amp; S Ball St</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1392498</td>\n",
       "      <td>2017-06-03 11:42:54</td>\n",
       "      <td>2017-06-03 12:21:05</td>\n",
       "      <td>2291.454</td>\n",
       "      <td>22nd &amp; I St NW / Foggy Bottom</td>\n",
       "      <td>Lamont &amp; Mt Pleasant NW</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>746605</td>\n",
       "      <td>2017-04-09 11:05:42</td>\n",
       "      <td>2017-04-09 11:26:44</td>\n",
       "      <td>1261.363</td>\n",
       "      <td>Henry Bacon Dr &amp; Lincoln Memorial Circle NW</td>\n",
       "      <td>Smithsonian-National Mall / Jefferson Dr &amp; 12t...</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>868881</td>\n",
       "      <td>2017-04-18 05:42:04</td>\n",
       "      <td>2017-04-18 06:31:28</td>\n",
       "      <td>2964.818</td>\n",
       "      <td>Anacostia Metro</td>\n",
       "      <td>Congress Heights Metro</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1161275</td>\n",
       "      <td>2017-05-15 07:35:21</td>\n",
       "      <td>2017-05-15 07:49:06</td>\n",
       "      <td>825.590</td>\n",
       "      <td>3rd &amp; H St NE</td>\n",
       "      <td>Oklahoma Ave &amp; D St NE</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>305000</td>\n",
       "      <td>2017-02-19 00:43:00</td>\n",
       "      <td>2017-02-19 00:46:00</td>\n",
       "      <td>226.006</td>\n",
       "      <td>18th St &amp; Wyoming Ave NW</td>\n",
       "      <td>Calvert St &amp; Woodley Pl NW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1174029</td>\n",
       "      <td>2017-05-16 07:34:43</td>\n",
       "      <td>2017-05-16 07:50:04</td>\n",
       "      <td>920.840</td>\n",
       "      <td>Florida Ave &amp; R St NW</td>\n",
       "      <td>L'Enfant Plaza / 7th &amp; C St SW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1157984</td>\n",
       "      <td>2017-05-15 05:39:22</td>\n",
       "      <td>2017-05-15 06:02:14</td>\n",
       "      <td>1371.512</td>\n",
       "      <td>Lincoln Memorial</td>\n",
       "      <td>Arlington Blvd &amp; Fillmore St</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>694527</td>\n",
       "      <td>2017-04-05 01:36:31</td>\n",
       "      <td>2017-04-05 01:40:45</td>\n",
       "      <td>254.076</td>\n",
       "      <td>13th St &amp; New York Ave NW</td>\n",
       "      <td>11th &amp; M St NW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>228536</td>\n",
       "      <td>2017-02-08 09:17:00</td>\n",
       "      <td>2017-02-08 09:31:00</td>\n",
       "      <td>834.780</td>\n",
       "      <td>39th &amp; Calvert St NW / Stoddert</td>\n",
       "      <td>Massachusetts Ave &amp; Dupont Circle NW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>669432</td>\n",
       "      <td>2017-04-02 12:11:35</td>\n",
       "      <td>2017-04-02 02:15:22</td>\n",
       "      <td>7427.749</td>\n",
       "      <td>2nd St &amp; Massachusetts Ave NE</td>\n",
       "      <td>2nd St &amp; Massachusetts Ave NE</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1036255</td>\n",
       "      <td>2017-05-02 11:49:43</td>\n",
       "      <td>2017-05-02 12:09:09</td>\n",
       "      <td>1165.698</td>\n",
       "      <td>10th &amp; K St NW</td>\n",
       "      <td>Georgetown Harbor / 30th St NW</td>\n",
       "      <td>Subscriber</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299970</th>\n",
       "      <td>1471550</td>\n",
       "      <td>2017-06-09 11:43:16</td>\n",
       "      <td>2017-06-09 11:58:37</td>\n",
       "      <td>920.918</td>\n",
       "      <td>17th St &amp; Independence Ave SW</td>\n",
       "      <td>Lincoln Memorial</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299971</th>\n",
       "      <td>177387</td>\n",
       "      <td>2017-02-01 09:40:00</td>\n",
       "      <td>2017-02-01 09:50:00</td>\n",
       "      <td>592.126</td>\n",
       "      <td>12th &amp; U St NW</td>\n",
       "      <td>North Capitol St &amp; F St NW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299972</th>\n",
       "      <td>1467942</td>\n",
       "      <td>2017-06-09 08:30:21</td>\n",
       "      <td>2017-06-09 08:36:00</td>\n",
       "      <td>338.889</td>\n",
       "      <td>Neal St &amp; Trinidad Ave NE</td>\n",
       "      <td>6th &amp; H St NE</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299973</th>\n",
       "      <td>1647779</td>\n",
       "      <td>2017-06-23 08:56:52</td>\n",
       "      <td>2017-06-23 09:07:28</td>\n",
       "      <td>636.448</td>\n",
       "      <td>8th &amp; O St NW</td>\n",
       "      <td>Eckington Pl &amp; Q St NE</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299974</th>\n",
       "      <td>1268465</td>\n",
       "      <td>2017-05-24 06:40:53</td>\n",
       "      <td>2017-05-24 06:49:44</td>\n",
       "      <td>531.641</td>\n",
       "      <td>5th &amp; F St NW</td>\n",
       "      <td>New Jersey Ave &amp; R St NW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299975</th>\n",
       "      <td>529787</td>\n",
       "      <td>2017-03-20 07:44:00</td>\n",
       "      <td>2017-03-20 07:50:00</td>\n",
       "      <td>376.236</td>\n",
       "      <td>Lee Center</td>\n",
       "      <td>King St Metro South</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299976</th>\n",
       "      <td>1387742</td>\n",
       "      <td>2017-06-03 07:36:32</td>\n",
       "      <td>2017-06-03 09:59:27</td>\n",
       "      <td>8574.520</td>\n",
       "      <td>5th &amp; F St NW</td>\n",
       "      <td>Metro Center / 12th &amp; G St NW</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299977</th>\n",
       "      <td>381662</td>\n",
       "      <td>2017-02-26 14:02:00</td>\n",
       "      <td>2017-02-26 14:14:00</td>\n",
       "      <td>695.843</td>\n",
       "      <td>Aurora Hills Community Ctr/18th &amp; Hayes St</td>\n",
       "      <td>Potomac Ave &amp; 35th St S</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299978</th>\n",
       "      <td>1497660</td>\n",
       "      <td>2017-06-11 11:36:59</td>\n",
       "      <td>2017-06-11 12:19:48</td>\n",
       "      <td>2569.064</td>\n",
       "      <td>18th &amp; C St NW</td>\n",
       "      <td>Lincoln Memorial</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299979</th>\n",
       "      <td>19230</td>\n",
       "      <td>2017-01-05 12:17:00</td>\n",
       "      <td>2017-01-05 12:35:00</td>\n",
       "      <td>1116.895</td>\n",
       "      <td>King St Metro South</td>\n",
       "      <td>King St &amp; Patrick St</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299980</th>\n",
       "      <td>1463439</td>\n",
       "      <td>2017-06-09 05:48:17</td>\n",
       "      <td>2017-06-09 05:55:36</td>\n",
       "      <td>438.578</td>\n",
       "      <td>Eastern Market Metro / Pennsylvania Ave &amp; 7th ...</td>\n",
       "      <td>M St &amp; New Jersey Ave SE</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299981</th>\n",
       "      <td>19978</td>\n",
       "      <td>2017-01-05 15:21:00</td>\n",
       "      <td>2017-01-05 15:45:00</td>\n",
       "      <td>1418.325</td>\n",
       "      <td>Kennebec St &amp; 11th St N</td>\n",
       "      <td>Court House Metro / 15th &amp; N Uhle St</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299982</th>\n",
       "      <td>285046</td>\n",
       "      <td>2017-02-16 17:42:00</td>\n",
       "      <td>2017-02-16 17:50:00</td>\n",
       "      <td>533.109</td>\n",
       "      <td>Adams Mill &amp; Columbia Rd NW</td>\n",
       "      <td>11th &amp; Kenyon St NW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299983</th>\n",
       "      <td>197387</td>\n",
       "      <td>2017-02-04 07:29:00</td>\n",
       "      <td>2017-02-04 07:40:00</td>\n",
       "      <td>656.070</td>\n",
       "      <td>1st &amp; N St  SE</td>\n",
       "      <td>Eastern Market Metro / Pennsylvania Ave &amp; 7th ...</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299984</th>\n",
       "      <td>306826</td>\n",
       "      <td>2017-02-19 11:21:00</td>\n",
       "      <td>2017-02-19 18:36:00</td>\n",
       "      <td>26104.597</td>\n",
       "      <td>22nd &amp; I St NW / Foggy Bottom</td>\n",
       "      <td>20th &amp; L St NW</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299985</th>\n",
       "      <td>1272681</td>\n",
       "      <td>2017-05-24 09:16:44</td>\n",
       "      <td>2017-05-24 09:34:24</td>\n",
       "      <td>1060.293</td>\n",
       "      <td>21st &amp; M St NW</td>\n",
       "      <td>Convention Center / 7th &amp; M St NW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299986</th>\n",
       "      <td>806988</td>\n",
       "      <td>2017-04-13 11:54:34</td>\n",
       "      <td>2017-04-13 12:18:57</td>\n",
       "      <td>1462.967</td>\n",
       "      <td>USDA / 12th &amp; Independence Ave SW</td>\n",
       "      <td>4th &amp; East Capitol St NE</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299987</th>\n",
       "      <td>477958</td>\n",
       "      <td>2017-03-10 12:30:00</td>\n",
       "      <td>2017-03-10 12:53:00</td>\n",
       "      <td>1365.523</td>\n",
       "      <td>Jefferson Memorial</td>\n",
       "      <td>New York Ave &amp; 15th St NW</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299988</th>\n",
       "      <td>1207507</td>\n",
       "      <td>2017-05-19 04:16:14</td>\n",
       "      <td>2017-05-19 04:23:06</td>\n",
       "      <td>411.963</td>\n",
       "      <td>Lincoln Park / 13th &amp; East Capitol St NE</td>\n",
       "      <td>Eastern Market Metro / Pennsylvania Ave &amp; 7th ...</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299989</th>\n",
       "      <td>102918</td>\n",
       "      <td>2017-01-20 17:43:00</td>\n",
       "      <td>2017-01-20 17:48:00</td>\n",
       "      <td>284.685</td>\n",
       "      <td>14th &amp; V St NW</td>\n",
       "      <td>15th &amp; P St NW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299990</th>\n",
       "      <td>776923</td>\n",
       "      <td>2017-04-11 11:11:57</td>\n",
       "      <td>2017-04-11 11:40:55</td>\n",
       "      <td>1738.345</td>\n",
       "      <td>1st &amp; O St NW</td>\n",
       "      <td>8th &amp; O St NW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299991</th>\n",
       "      <td>8834</td>\n",
       "      <td>2017-01-03 19:28:00</td>\n",
       "      <td>2017-01-03 19:40:00</td>\n",
       "      <td>714.928</td>\n",
       "      <td>Washington &amp; Independence Ave SW/HHS</td>\n",
       "      <td>3rd &amp; H St NE</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299992</th>\n",
       "      <td>32912</td>\n",
       "      <td>2017-01-09 08:11:00</td>\n",
       "      <td>2017-01-09 08:14:00</td>\n",
       "      <td>191.131</td>\n",
       "      <td>Thomas Circle</td>\n",
       "      <td>17th &amp; K St NW / Farragut Square</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299993</th>\n",
       "      <td>894445</td>\n",
       "      <td>2017-04-20 05:50:30</td>\n",
       "      <td>2017-04-20 06:10:35</td>\n",
       "      <td>1205.379</td>\n",
       "      <td>8th &amp; H St NW</td>\n",
       "      <td>13th &amp; H St NE</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299994</th>\n",
       "      <td>101489</td>\n",
       "      <td>2017-01-20 14:03:00</td>\n",
       "      <td>2017-01-20 15:11:00</td>\n",
       "      <td>4086.828</td>\n",
       "      <td>Henry Bacon Dr &amp; Lincoln Memorial Circle NW</td>\n",
       "      <td>24th &amp; N St NW</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299995</th>\n",
       "      <td>945535</td>\n",
       "      <td>2017-04-26 03:12:14</td>\n",
       "      <td>2017-04-26 03:41:19</td>\n",
       "      <td>1745.528</td>\n",
       "      <td>Lincoln Memorial</td>\n",
       "      <td>Jefferson Dr &amp; 14th St SW</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299996</th>\n",
       "      <td>1495781</td>\n",
       "      <td>2017-06-11 09:48:52</td>\n",
       "      <td>2017-06-11 10:22:31</td>\n",
       "      <td>2018.450</td>\n",
       "      <td>Key Blvd &amp; N Quinn St</td>\n",
       "      <td>5th &amp; K St NW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299997</th>\n",
       "      <td>12860</td>\n",
       "      <td>2017-01-04 14:33:00</td>\n",
       "      <td>2017-01-04 14:43:00</td>\n",
       "      <td>583.897</td>\n",
       "      <td>17th &amp; K St NW / Farragut Square</td>\n",
       "      <td>7th &amp; F St NW/Portrait Gallery</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299998</th>\n",
       "      <td>977621</td>\n",
       "      <td>2017-04-28 07:17:47</td>\n",
       "      <td>2017-04-28 07:56:31</td>\n",
       "      <td>2324.170</td>\n",
       "      <td>Jefferson Dr &amp; 14th St SW</td>\n",
       "      <td>Washington &amp; Independence Ave SW/HHS</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299999</th>\n",
       "      <td>1553359</td>\n",
       "      <td>2017-06-16 04:08:16</td>\n",
       "      <td>2017-06-16 04:29:38</td>\n",
       "      <td>1281.459</td>\n",
       "      <td>10th &amp; Monroe St NE</td>\n",
       "      <td>3rd &amp; H St NW</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>300000 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Unnamed: 0           Start Time             End Time  Trip Duration  \\\n",
       "0          1621326  2017-06-21 08:36:34  2017-06-21 08:44:43        489.066   \n",
       "1           482740  2017-03-11 10:40:00  2017-03-11 10:46:00        402.549   \n",
       "2          1330037  2017-05-30 01:02:59  2017-05-30 01:13:37        637.251   \n",
       "3           665458  2017-04-02 07:48:35  2017-04-02 08:19:03       1827.341   \n",
       "4          1481135  2017-06-10 08:36:28  2017-06-10 09:02:17       1549.427   \n",
       "5          1148202  2017-05-14 07:18:18  2017-05-14 07:24:56        398.000   \n",
       "6          1594275  2017-06-19 08:41:43  2017-06-19 09:00:08       1105.429   \n",
       "7          1601832  2017-06-20 05:54:42  2017-06-20 06:05:18        636.218   \n",
       "8           574182  2017-03-24 20:37:00  2017-03-24 20:42:00        328.530   \n",
       "9           327058  2017-02-20 21:12:00  2017-02-20 21:31:00       1188.090   \n",
       "10          854729  2017-04-17 02:50:51  2017-04-17 03:05:17        866.689   \n",
       "11          721887  2017-04-08 01:12:48  2017-04-08 01:52:33       2385.411   \n",
       "12          143181  2017-01-26 20:01:00  2017-01-26 20:17:00        951.457   \n",
       "13           26953  2017-01-06 17:36:00  2017-01-06 17:43:00        448.628   \n",
       "14         1308542  2017-05-28 03:50:26  2017-05-28 04:24:26       2039.472   \n",
       "15         1592744  2017-06-19 07:46:35  2017-06-19 07:55:00        505.482   \n",
       "16         1139713  2017-05-13 11:29:16  2017-05-13 11:55:47       1591.326   \n",
       "17         1478516  2017-06-10 06:04:41  2017-06-10 06:32:33       1672.075   \n",
       "18          679837  2017-04-03 10:22:19  2017-04-03 10:26:11        231.952   \n",
       "19         1392498  2017-06-03 11:42:54  2017-06-03 12:21:05       2291.454   \n",
       "20          746605  2017-04-09 11:05:42  2017-04-09 11:26:44       1261.363   \n",
       "21          868881  2017-04-18 05:42:04  2017-04-18 06:31:28       2964.818   \n",
       "22         1161275  2017-05-15 07:35:21  2017-05-15 07:49:06        825.590   \n",
       "23          305000  2017-02-19 00:43:00  2017-02-19 00:46:00        226.006   \n",
       "24         1174029  2017-05-16 07:34:43  2017-05-16 07:50:04        920.840   \n",
       "25         1157984  2017-05-15 05:39:22  2017-05-15 06:02:14       1371.512   \n",
       "26          694527  2017-04-05 01:36:31  2017-04-05 01:40:45        254.076   \n",
       "27          228536  2017-02-08 09:17:00  2017-02-08 09:31:00        834.780   \n",
       "28          669432  2017-04-02 12:11:35  2017-04-02 02:15:22       7427.749   \n",
       "29         1036255  2017-05-02 11:49:43  2017-05-02 12:09:09       1165.698   \n",
       "...            ...                  ...                  ...            ...   \n",
       "299970     1471550  2017-06-09 11:43:16  2017-06-09 11:58:37        920.918   \n",
       "299971      177387  2017-02-01 09:40:00  2017-02-01 09:50:00        592.126   \n",
       "299972     1467942  2017-06-09 08:30:21  2017-06-09 08:36:00        338.889   \n",
       "299973     1647779  2017-06-23 08:56:52  2017-06-23 09:07:28        636.448   \n",
       "299974     1268465  2017-05-24 06:40:53  2017-05-24 06:49:44        531.641   \n",
       "299975      529787  2017-03-20 07:44:00  2017-03-20 07:50:00        376.236   \n",
       "299976     1387742  2017-06-03 07:36:32  2017-06-03 09:59:27       8574.520   \n",
       "299977      381662  2017-02-26 14:02:00  2017-02-26 14:14:00        695.843   \n",
       "299978     1497660  2017-06-11 11:36:59  2017-06-11 12:19:48       2569.064   \n",
       "299979       19230  2017-01-05 12:17:00  2017-01-05 12:35:00       1116.895   \n",
       "299980     1463439  2017-06-09 05:48:17  2017-06-09 05:55:36        438.578   \n",
       "299981       19978  2017-01-05 15:21:00  2017-01-05 15:45:00       1418.325   \n",
       "299982      285046  2017-02-16 17:42:00  2017-02-16 17:50:00        533.109   \n",
       "299983      197387  2017-02-04 07:29:00  2017-02-04 07:40:00        656.070   \n",
       "299984      306826  2017-02-19 11:21:00  2017-02-19 18:36:00      26104.597   \n",
       "299985     1272681  2017-05-24 09:16:44  2017-05-24 09:34:24       1060.293   \n",
       "299986      806988  2017-04-13 11:54:34  2017-04-13 12:18:57       1462.967   \n",
       "299987      477958  2017-03-10 12:30:00  2017-03-10 12:53:00       1365.523   \n",
       "299988     1207507  2017-05-19 04:16:14  2017-05-19 04:23:06        411.963   \n",
       "299989      102918  2017-01-20 17:43:00  2017-01-20 17:48:00        284.685   \n",
       "299990      776923  2017-04-11 11:11:57  2017-04-11 11:40:55       1738.345   \n",
       "299991        8834  2017-01-03 19:28:00  2017-01-03 19:40:00        714.928   \n",
       "299992       32912  2017-01-09 08:11:00  2017-01-09 08:14:00        191.131   \n",
       "299993      894445  2017-04-20 05:50:30  2017-04-20 06:10:35       1205.379   \n",
       "299994      101489  2017-01-20 14:03:00  2017-01-20 15:11:00       4086.828   \n",
       "299995      945535  2017-04-26 03:12:14  2017-04-26 03:41:19       1745.528   \n",
       "299996     1495781  2017-06-11 09:48:52  2017-06-11 10:22:31       2018.450   \n",
       "299997       12860  2017-01-04 14:33:00  2017-01-04 14:43:00        583.897   \n",
       "299998      977621  2017-04-28 07:17:47  2017-04-28 07:56:31       2324.170   \n",
       "299999     1553359  2017-06-16 04:08:16  2017-06-16 04:29:38       1281.459   \n",
       "\n",
       "                                            Start Station  \\\n",
       "0                                    14th & Belmont St NW   \n",
       "1                              Yuma St & Tenley Circle NW   \n",
       "2                          17th St & Massachusetts Ave NW   \n",
       "3                        Constitution Ave & 2nd St NW/DOL   \n",
       "4             Henry Bacon Dr & Lincoln Memorial Circle NW   \n",
       "5                                           1st & K St SE   \n",
       "6                                 Park Rd & Holmead Pl NW   \n",
       "7                                           1st & D St SE   \n",
       "8                                          18th & R St NW   \n",
       "9                                   17th & Corcoran St NW   \n",
       "10                 37th & O St NW / Georgetown University   \n",
       "11                                         10th & G St NW   \n",
       "12                            10th St & L'Enfant Plaza SW   \n",
       "13                             North Capitol St & F St NW   \n",
       "14            Henry Bacon Dr & Lincoln Memorial Circle NW   \n",
       "15                          Metro Center / 12th & G St NW   \n",
       "16                                   16th & Harvard St NW   \n",
       "17                         17th St & Massachusetts Ave NW   \n",
       "18                                      20th & Crystal Dr   \n",
       "19                          22nd & I St NW / Foggy Bottom   \n",
       "20            Henry Bacon Dr & Lincoln Memorial Circle NW   \n",
       "21                                        Anacostia Metro   \n",
       "22                                          3rd & H St NE   \n",
       "23                               18th St & Wyoming Ave NW   \n",
       "24                                  Florida Ave & R St NW   \n",
       "25                                       Lincoln Memorial   \n",
       "26                              13th St & New York Ave NW   \n",
       "27                        39th & Calvert St NW / Stoddert   \n",
       "28                          2nd St & Massachusetts Ave NE   \n",
       "29                                         10th & K St NW   \n",
       "...                                                   ...   \n",
       "299970                      17th St & Independence Ave SW   \n",
       "299971                                     12th & U St NW   \n",
       "299972                          Neal St & Trinidad Ave NE   \n",
       "299973                                      8th & O St NW   \n",
       "299974                                      5th & F St NW   \n",
       "299975                                         Lee Center   \n",
       "299976                                      5th & F St NW   \n",
       "299977         Aurora Hills Community Ctr/18th & Hayes St   \n",
       "299978                                     18th & C St NW   \n",
       "299979                                King St Metro South   \n",
       "299980  Eastern Market Metro / Pennsylvania Ave & 7th ...   \n",
       "299981                            Kennebec St & 11th St N   \n",
       "299982                        Adams Mill & Columbia Rd NW   \n",
       "299983                                     1st & N St  SE   \n",
       "299984                      22nd & I St NW / Foggy Bottom   \n",
       "299985                                     21st & M St NW   \n",
       "299986                  USDA / 12th & Independence Ave SW   \n",
       "299987                                 Jefferson Memorial   \n",
       "299988          Lincoln Park / 13th & East Capitol St NE    \n",
       "299989                                     14th & V St NW   \n",
       "299990                                      1st & O St NW   \n",
       "299991               Washington & Independence Ave SW/HHS   \n",
       "299992                                      Thomas Circle   \n",
       "299993                                      8th & H St NW   \n",
       "299994        Henry Bacon Dr & Lincoln Memorial Circle NW   \n",
       "299995                                   Lincoln Memorial   \n",
       "299996                              Key Blvd & N Quinn St   \n",
       "299997                   17th & K St NW / Farragut Square   \n",
       "299998                          Jefferson Dr & 14th St SW   \n",
       "299999                                10th & Monroe St NE   \n",
       "\n",
       "                                              End Station   User Type  \n",
       "0                                          15th & K St NW  Subscriber  \n",
       "1                            Connecticut Ave & Yuma St NW  Subscriber  \n",
       "2                                           5th & K St NW  Subscriber  \n",
       "3                              M St & Pennsylvania Ave NW    Customer  \n",
       "4                                   Maine Ave & 7th St SW  Subscriber  \n",
       "5       Eastern Market Metro / Pennsylvania Ave & 7th ...  Subscriber  \n",
       "6                                           8th & H St NW  Subscriber  \n",
       "7                           Potomac & Pennsylvania Ave SE  Subscriber  \n",
       "8                                          15th & P St NW  Subscriber  \n",
       "9                                    Lynn & 19th St North  Subscriber  \n",
       "10                 37th & O St NW / Georgetown University    Customer  \n",
       "11                          5th St & Massachusetts Ave NW    Customer  \n",
       "12                              1st & Rhode Island Ave NW  Subscriber  \n",
       "13                                          1st & M St NE  Subscriber  \n",
       "14                                       Lincoln Memorial    Customer  \n",
       "15                             North Capitol St & G Pl NE  Subscriber  \n",
       "16                              New York Ave & 15th St NW    Customer  \n",
       "17                              15th & East Capitol St NE  Subscriber  \n",
       "18                                        6th & S Ball St  Subscriber  \n",
       "19                                Lamont & Mt Pleasant NW    Customer  \n",
       "20      Smithsonian-National Mall / Jefferson Dr & 12t...    Customer  \n",
       "21                                 Congress Heights Metro  Subscriber  \n",
       "22                                 Oklahoma Ave & D St NE  Subscriber  \n",
       "23                             Calvert St & Woodley Pl NW  Subscriber  \n",
       "24                         L'Enfant Plaza / 7th & C St SW  Subscriber  \n",
       "25                           Arlington Blvd & Fillmore St  Subscriber  \n",
       "26                                         11th & M St NW  Subscriber  \n",
       "27                   Massachusetts Ave & Dupont Circle NW  Subscriber  \n",
       "28                          2nd St & Massachusetts Ave NE    Customer  \n",
       "29                         Georgetown Harbor / 30th St NW  Subscriber  \n",
       "...                                                   ...         ...  \n",
       "299970                                   Lincoln Memorial    Customer  \n",
       "299971                         North Capitol St & F St NW  Subscriber  \n",
       "299972                                      6th & H St NE  Subscriber  \n",
       "299973                             Eckington Pl & Q St NE  Subscriber  \n",
       "299974                           New Jersey Ave & R St NW  Subscriber  \n",
       "299975                                King St Metro South  Subscriber  \n",
       "299976                      Metro Center / 12th & G St NW    Customer  \n",
       "299977                            Potomac Ave & 35th St S  Subscriber  \n",
       "299978                                   Lincoln Memorial    Customer  \n",
       "299979                               King St & Patrick St    Customer  \n",
       "299980                           M St & New Jersey Ave SE  Subscriber  \n",
       "299981              Court House Metro / 15th & N Uhle St   Subscriber  \n",
       "299982                                11th & Kenyon St NW  Subscriber  \n",
       "299983  Eastern Market Metro / Pennsylvania Ave & 7th ...  Subscriber  \n",
       "299984                                     20th & L St NW    Customer  \n",
       "299985                  Convention Center / 7th & M St NW  Subscriber  \n",
       "299986                           4th & East Capitol St NE    Customer  \n",
       "299987                          New York Ave & 15th St NW    Customer  \n",
       "299988  Eastern Market Metro / Pennsylvania Ave & 7th ...  Subscriber  \n",
       "299989                                     15th & P St NW  Subscriber  \n",
       "299990                                      8th & O St NW  Subscriber  \n",
       "299991                                      3rd & H St NE  Subscriber  \n",
       "299992                   17th & K St NW / Farragut Square  Subscriber  \n",
       "299993                                     13th & H St NE    Customer  \n",
       "299994                                     24th & N St NW    Customer  \n",
       "299995                          Jefferson Dr & 14th St SW    Customer  \n",
       "299996                                      5th & K St NW  Subscriber  \n",
       "299997                     7th & F St NW/Portrait Gallery  Subscriber  \n",
       "299998               Washington & Independence Ave SW/HHS    Customer  \n",
       "299999                                      3rd & H St NW    Customer  \n",
       "\n",
       "[300000 rows x 7 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#import packages\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import seaborn as sns\n",
    "\n",
    "#Loading Washington data\n",
    "washington=pd.read_csv('washington.csv')\n",
    "#printing data\n",
    "washington\n"
   ]
  },
  {
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1621326</td>\n",
       "      <td>2017-06-21 08:36:34</td>\n",
       "      <td>2017-06-21 08:44:43</td>\n",
       "      <td>489.066</td>\n",
       "      <td>14th &amp; Belmont St NW</td>\n",
       "      <td>15th &amp; K St NW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>482740</td>\n",
       "      <td>2017-03-11 10:40:00</td>\n",
       "      <td>2017-03-11 10:46:00</td>\n",
       "      <td>402.549</td>\n",
       "      <td>Yuma St &amp; Tenley Circle NW</td>\n",
       "      <td>Connecticut Ave &amp; Yuma St NW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1330037</td>\n",
       "      <td>2017-05-30 01:02:59</td>\n",
       "      <td>2017-05-30 01:13:37</td>\n",
       "      <td>637.251</td>\n",
       "      <td>17th St &amp; Massachusetts Ave NW</td>\n",
       "      <td>5th &amp; K St NW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>665458</td>\n",
       "      <td>2017-04-02 07:48:35</td>\n",
       "      <td>2017-04-02 08:19:03</td>\n",
       "      <td>1827.341</td>\n",
       "      <td>Constitution Ave &amp; 2nd St NW/DOL</td>\n",
       "      <td>M St &amp; Pennsylvania Ave NW</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1481135</td>\n",
       "      <td>2017-06-10 08:36:28</td>\n",
       "      <td>2017-06-10 09:02:17</td>\n",
       "      <td>1549.427</td>\n",
       "      <td>Henry Bacon Dr &amp; Lincoln Memorial Circle NW</td>\n",
       "      <td>Maine Ave &amp; 7th St SW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0           Start Time             End Time  Trip Duration  \\\n",
       "0     1621326  2017-06-21 08:36:34  2017-06-21 08:44:43        489.066   \n",
       "1      482740  2017-03-11 10:40:00  2017-03-11 10:46:00        402.549   \n",
       "2     1330037  2017-05-30 01:02:59  2017-05-30 01:13:37        637.251   \n",
       "3      665458  2017-04-02 07:48:35  2017-04-02 08:19:03       1827.341   \n",
       "4     1481135  2017-06-10 08:36:28  2017-06-10 09:02:17       1549.427   \n",
       "\n",
       "                                 Start Station                   End Station  \\\n",
       "0                         14th & Belmont St NW                15th & K St NW   \n",
       "1                   Yuma St & Tenley Circle NW  Connecticut Ave & Yuma St NW   \n",
       "2               17th St & Massachusetts Ave NW                 5th & K St NW   \n",
       "3             Constitution Ave & 2nd St NW/DOL    M St & Pennsylvania Ave NW   \n",
       "4  Henry Bacon Dr & Lincoln Memorial Circle NW         Maine Ave & 7th St SW   \n",
       "\n",
       "    User Type  \n",
       "0  Subscriber  \n",
       "1  Subscriber  \n",
       "2  Subscriber  \n",
       "3    Customer  \n",
       "4  Subscriber  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#1.Performing head()\n",
    "washington.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>299995</th>\n",
       "      <td>945535</td>\n",
       "      <td>2017-04-26 03:12:14</td>\n",
       "      <td>2017-04-26 03:41:19</td>\n",
       "      <td>1745.528</td>\n",
       "      <td>Lincoln Memorial</td>\n",
       "      <td>Jefferson Dr &amp; 14th St SW</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299996</th>\n",
       "      <td>1495781</td>\n",
       "      <td>2017-06-11 09:48:52</td>\n",
       "      <td>2017-06-11 10:22:31</td>\n",
       "      <td>2018.450</td>\n",
       "      <td>Key Blvd &amp; N Quinn St</td>\n",
       "      <td>5th &amp; K St NW</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299997</th>\n",
       "      <td>12860</td>\n",
       "      <td>2017-01-04 14:33:00</td>\n",
       "      <td>2017-01-04 14:43:00</td>\n",
       "      <td>583.897</td>\n",
       "      <td>17th &amp; K St NW / Farragut Square</td>\n",
       "      <td>7th &amp; F St NW/Portrait Gallery</td>\n",
       "      <td>Subscriber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299998</th>\n",
       "      <td>977621</td>\n",
       "      <td>2017-04-28 07:17:47</td>\n",
       "      <td>2017-04-28 07:56:31</td>\n",
       "      <td>2324.170</td>\n",
       "      <td>Jefferson Dr &amp; 14th St SW</td>\n",
       "      <td>Washington &amp; Independence Ave SW/HHS</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299999</th>\n",
       "      <td>1553359</td>\n",
       "      <td>2017-06-16 04:08:16</td>\n",
       "      <td>2017-06-16 04:29:38</td>\n",
       "      <td>1281.459</td>\n",
       "      <td>10th &amp; Monroe St NE</td>\n",
       "      <td>3rd &amp; H St NW</td>\n",
       "      <td>Customer</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Unnamed: 0           Start Time             End Time  Trip Duration  \\\n",
       "299995      945535  2017-04-26 03:12:14  2017-04-26 03:41:19       1745.528   \n",
       "299996     1495781  2017-06-11 09:48:52  2017-06-11 10:22:31       2018.450   \n",
       "299997       12860  2017-01-04 14:33:00  2017-01-04 14:43:00        583.897   \n",
       "299998      977621  2017-04-28 07:17:47  2017-04-28 07:56:31       2324.170   \n",
       "299999     1553359  2017-06-16 04:08:16  2017-06-16 04:29:38       1281.459   \n",
       "\n",
       "                           Start Station  \\\n",
       "299995                  Lincoln Memorial   \n",
       "299996             Key Blvd & N Quinn St   \n",
       "299997  17th & K St NW / Farragut Square   \n",
       "299998         Jefferson Dr & 14th St SW   \n",
       "299999               10th & Monroe St NE   \n",
       "\n",
       "                                 End Station   User Type  \n",
       "299995             Jefferson Dr & 14th St SW    Customer  \n",
       "299996                         5th & K St NW  Subscriber  \n",
       "299997        7th & F St NW/Portrait Gallery  Subscriber  \n",
       "299998  Washington & Independence Ave SW/HHS    Customer  \n",
       "299999                         3rd & H St NW    Customer  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#performing tail()\n",
    "washington.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 300000 entries, 0 to 299999\n",
      "Data columns (total 7 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 float64\n",
      "Start Station    300000 non-null object\n",
      "End Station      300000 non-null object\n",
      "User Type        300000 non-null object\n",
      "dtypes: float64(1), int64(1), object(5)\n",
      "memory usage: 16.0+ MB\n"
     ]
    }
   ],
   "source": [
    "#performing information\n",
    "washington.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>3.000000e+05</td>\n",
       "      <td>3.000000e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>8.754044e+05</td>\n",
       "      <td>1.237280e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>5.059335e+05</td>\n",
       "      <td>5.461997e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>6.001000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>4.363938e+05</td>\n",
       "      <td>4.106230e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>8.750635e+05</td>\n",
       "      <td>7.065015e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>1.313148e+06</td>\n",
       "      <td>1.229427e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1.751446e+06</td>\n",
       "      <td>1.235662e+06</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Unnamed: 0  Trip Duration\n",
       "count  3.000000e+05   3.000000e+05\n",
       "mean   8.754044e+05   1.237280e+03\n",
       "std    5.059335e+05   5.461997e+03\n",
       "min    7.000000e+00   6.001000e+01\n",
       "25%    4.363938e+05   4.106230e+02\n",
       "50%    8.750635e+05   7.065015e+02\n",
       "75%    1.313148e+06   1.229427e+03\n",
       "max    1.751446e+06   1.235662e+06"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#performing describe\n",
    "washington.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "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
}