NYC_CitiBike_Challenge.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n"
   ]
  },
  {
   "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>tripduration</th>\n",
       "      <th>starttime</th>\n",
       "      <th>stoptime</th>\n",
       "      <th>start station id</th>\n",
       "      <th>start station name</th>\n",
       "      <th>start station latitude</th>\n",
       "      <th>start station longitude</th>\n",
       "      <th>end station id</th>\n",
       "      <th>end station name</th>\n",
       "      <th>end station latitude</th>\n",
       "      <th>end station longitude</th>\n",
       "      <th>bikeid</th>\n",
       "      <th>usertype</th>\n",
       "      <th>birth year</th>\n",
       "      <th>gender</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>393</td>\n",
       "      <td>2019-08-01 00:00:01.4680</td>\n",
       "      <td>2019-08-01 00:06:35.3780</td>\n",
       "      <td>531.0</td>\n",
       "      <td>Forsyth St &amp; Broome St</td>\n",
       "      <td>40.718939</td>\n",
       "      <td>-73.992663</td>\n",
       "      <td>408.0</td>\n",
       "      <td>Market St &amp; Cherry St</td>\n",
       "      <td>40.710762</td>\n",
       "      <td>-73.994004</td>\n",
       "      <td>35305</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1996</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>627</td>\n",
       "      <td>2019-08-01 00:00:01.9290</td>\n",
       "      <td>2019-08-01 00:10:29.7840</td>\n",
       "      <td>274.0</td>\n",
       "      <td>Lafayette Ave &amp; Fort Greene Pl</td>\n",
       "      <td>40.686919</td>\n",
       "      <td>-73.976682</td>\n",
       "      <td>3409.0</td>\n",
       "      <td>Bergen St &amp; Smith St</td>\n",
       "      <td>40.686744</td>\n",
       "      <td>-73.990632</td>\n",
       "      <td>38822</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1998</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1132</td>\n",
       "      <td>2019-08-01 00:00:04.0480</td>\n",
       "      <td>2019-08-01 00:18:56.1650</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>Front St &amp; Washington St</td>\n",
       "      <td>40.702551</td>\n",
       "      <td>-73.989402</td>\n",
       "      <td>3388.0</td>\n",
       "      <td>President St &amp; Henry St</td>\n",
       "      <td>40.682800</td>\n",
       "      <td>-73.999904</td>\n",
       "      <td>18373</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1988</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1780</td>\n",
       "      <td>2019-08-01 00:00:04.1630</td>\n",
       "      <td>2019-08-01 00:29:44.7940</td>\n",
       "      <td>479.0</td>\n",
       "      <td>9 Ave &amp; W 45 St</td>\n",
       "      <td>40.760193</td>\n",
       "      <td>-73.991255</td>\n",
       "      <td>473.0</td>\n",
       "      <td>Rivington St &amp; Chrystie St</td>\n",
       "      <td>40.721101</td>\n",
       "      <td>-73.991925</td>\n",
       "      <td>25002</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1988</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1517</td>\n",
       "      <td>2019-08-01 00:00:05.4580</td>\n",
       "      <td>2019-08-01 00:25:23.4550</td>\n",
       "      <td>3312.0</td>\n",
       "      <td>1 Ave &amp; E 94 St</td>\n",
       "      <td>40.781721</td>\n",
       "      <td>-73.945940</td>\n",
       "      <td>3312.0</td>\n",
       "      <td>1 Ave &amp; E 94 St</td>\n",
       "      <td>40.781721</td>\n",
       "      <td>-73.945940</td>\n",
       "      <td>31198</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1965</td>\n",
       "      <td>2</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2344219</th>\n",
       "      <td>216</td>\n",
       "      <td>2019-08-31 23:59:46.2930</td>\n",
       "      <td>2019-09-01 00:03:23.0360</td>\n",
       "      <td>116.0</td>\n",
       "      <td>W 17 St &amp; 8 Ave</td>\n",
       "      <td>40.741776</td>\n",
       "      <td>-74.001497</td>\n",
       "      <td>509.0</td>\n",
       "      <td>9 Ave &amp; W 22 St</td>\n",
       "      <td>40.745497</td>\n",
       "      <td>-74.001971</td>\n",
       "      <td>38655</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1972</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2344220</th>\n",
       "      <td>117</td>\n",
       "      <td>2019-08-31 23:59:47.7970</td>\n",
       "      <td>2019-09-01 00:01:45.7440</td>\n",
       "      <td>3429.0</td>\n",
       "      <td>Hanson Pl &amp; Ashland Pl</td>\n",
       "      <td>40.685068</td>\n",
       "      <td>-73.977908</td>\n",
       "      <td>353.0</td>\n",
       "      <td>S Portland Ave &amp; Hanson Pl</td>\n",
       "      <td>40.685396</td>\n",
       "      <td>-73.974315</td>\n",
       "      <td>25264</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1982</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2344221</th>\n",
       "      <td>1614</td>\n",
       "      <td>2019-08-31 23:59:48.1560</td>\n",
       "      <td>2019-09-01 00:26:42.7760</td>\n",
       "      <td>387.0</td>\n",
       "      <td>Centre St &amp; Chambers St</td>\n",
       "      <td>40.712733</td>\n",
       "      <td>-74.004607</td>\n",
       "      <td>3440.0</td>\n",
       "      <td>Fulton St &amp; Adams St</td>\n",
       "      <td>40.692418</td>\n",
       "      <td>-73.989495</td>\n",
       "      <td>28485</td>\n",
       "      <td>Customer</td>\n",
       "      <td>1969</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2344222</th>\n",
       "      <td>1301</td>\n",
       "      <td>2019-08-31 23:59:58.3620</td>\n",
       "      <td>2019-09-01 00:21:39.7040</td>\n",
       "      <td>3168.0</td>\n",
       "      <td>Central Park West &amp; W 85 St</td>\n",
       "      <td>40.784727</td>\n",
       "      <td>-73.969617</td>\n",
       "      <td>423.0</td>\n",
       "      <td>W 54 St &amp; 9 Ave</td>\n",
       "      <td>40.765849</td>\n",
       "      <td>-73.986905</td>\n",
       "      <td>38664</td>\n",
       "      <td>Customer</td>\n",
       "      <td>1969</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2344223</th>\n",
       "      <td>419</td>\n",
       "      <td>2019-08-31 23:59:59.4520</td>\n",
       "      <td>2019-09-01 00:06:59.0210</td>\n",
       "      <td>447.0</td>\n",
       "      <td>8 Ave &amp; W 52 St</td>\n",
       "      <td>40.763707</td>\n",
       "      <td>-73.985162</td>\n",
       "      <td>529.0</td>\n",
       "      <td>W 42 St &amp; 8 Ave</td>\n",
       "      <td>40.757570</td>\n",
       "      <td>-73.990985</td>\n",
       "      <td>35210</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1994</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2344224 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         tripduration                 starttime                  stoptime  \\\n",
       "0                 393  2019-08-01 00:00:01.4680  2019-08-01 00:06:35.3780   \n",
       "1                 627  2019-08-01 00:00:01.9290  2019-08-01 00:10:29.7840   \n",
       "2                1132  2019-08-01 00:00:04.0480  2019-08-01 00:18:56.1650   \n",
       "3                1780  2019-08-01 00:00:04.1630  2019-08-01 00:29:44.7940   \n",
       "4                1517  2019-08-01 00:00:05.4580  2019-08-01 00:25:23.4550   \n",
       "...               ...                       ...                       ...   \n",
       "2344219           216  2019-08-31 23:59:46.2930  2019-09-01 00:03:23.0360   \n",
       "2344220           117  2019-08-31 23:59:47.7970  2019-09-01 00:01:45.7440   \n",
       "2344221          1614  2019-08-31 23:59:48.1560  2019-09-01 00:26:42.7760   \n",
       "2344222          1301  2019-08-31 23:59:58.3620  2019-09-01 00:21:39.7040   \n",
       "2344223           419  2019-08-31 23:59:59.4520  2019-09-01 00:06:59.0210   \n",
       "\n",
       "         start station id              start station name  \\\n",
       "0                   531.0          Forsyth St & Broome St   \n",
       "1                   274.0  Lafayette Ave & Fort Greene Pl   \n",
       "2                  2000.0        Front St & Washington St   \n",
       "3                   479.0                 9 Ave & W 45 St   \n",
       "4                  3312.0                 1 Ave & E 94 St   \n",
       "...                   ...                             ...   \n",
       "2344219             116.0                 W 17 St & 8 Ave   \n",
       "2344220            3429.0          Hanson Pl & Ashland Pl   \n",
       "2344221             387.0         Centre St & Chambers St   \n",
       "2344222            3168.0     Central Park West & W 85 St   \n",
       "2344223             447.0                 8 Ave & W 52 St   \n",
       "\n",
       "         start station latitude  start station longitude  end station id  \\\n",
       "0                     40.718939               -73.992663           408.0   \n",
       "1                     40.686919               -73.976682          3409.0   \n",
       "2                     40.702551               -73.989402          3388.0   \n",
       "3                     40.760193               -73.991255           473.0   \n",
       "4                     40.781721               -73.945940          3312.0   \n",
       "...                         ...                      ...             ...   \n",
       "2344219               40.741776               -74.001497           509.0   \n",
       "2344220               40.685068               -73.977908           353.0   \n",
       "2344221               40.712733               -74.004607          3440.0   \n",
       "2344222               40.784727               -73.969617           423.0   \n",
       "2344223               40.763707               -73.985162           529.0   \n",
       "\n",
       "                   end station name  end station latitude  \\\n",
       "0             Market St & Cherry St             40.710762   \n",
       "1              Bergen St & Smith St             40.686744   \n",
       "2           President St & Henry St             40.682800   \n",
       "3        Rivington St & Chrystie St             40.721101   \n",
       "4                   1 Ave & E 94 St             40.781721   \n",
       "...                             ...                   ...   \n",
       "2344219             9 Ave & W 22 St             40.745497   \n",
       "2344220  S Portland Ave & Hanson Pl             40.685396   \n",
       "2344221        Fulton St & Adams St             40.692418   \n",
       "2344222             W 54 St & 9 Ave             40.765849   \n",
       "2344223             W 42 St & 8 Ave             40.757570   \n",
       "\n",
       "         end station longitude  bikeid    usertype  birth year  gender  \n",
       "0                   -73.994004   35305  Subscriber        1996       2  \n",
       "1                   -73.990632   38822  Subscriber        1998       2  \n",
       "2                   -73.999904   18373  Subscriber        1988       1  \n",
       "3                   -73.991925   25002  Subscriber        1988       1  \n",
       "4                   -73.945940   31198  Subscriber        1965       2  \n",
       "...                        ...     ...         ...         ...     ...  \n",
       "2344219             -74.001971   38655  Subscriber        1972       1  \n",
       "2344220             -73.974315   25264  Subscriber        1982       2  \n",
       "2344221             -73.989495   28485    Customer        1969       0  \n",
       "2344222             -73.986905   38664    Customer        1969       0  \n",
       "2344223             -73.990985   35210  Subscriber        1994       1  \n",
       "\n",
       "[2344224 rows x 15 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 1. Create a DataFrame for the 201908-citibike-tripdata data. \n",
    "citibike_tripdata_df = pd.read_csv(\"201908-citibike-tripdata.csv\")\n",
    "citibike_tripdata_df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "tripduration                 int64\n",
       "starttime                   object\n",
       "stoptime                    object\n",
       "start station id           float64\n",
       "start station name          object\n",
       "start station latitude     float64\n",
       "start station longitude    float64\n",
       "end station id             float64\n",
       "end station name            object\n",
       "end station latitude       float64\n",
       "end station longitude      float64\n",
       "bikeid                       int64\n",
       "usertype                    object\n",
       "birth year                   int64\n",
       "gender                       int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 2. Check the datatypes of your columns. \n",
    "citibike_tripdata_df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>tripduration</th>\n",
       "      <th>starttime</th>\n",
       "      <th>stoptime</th>\n",
       "      <th>start station id</th>\n",
       "      <th>start station name</th>\n",
       "      <th>start station latitude</th>\n",
       "      <th>start station longitude</th>\n",
       "      <th>end station id</th>\n",
       "      <th>end station name</th>\n",
       "      <th>end station latitude</th>\n",
       "      <th>end station longitude</th>\n",
       "      <th>bikeid</th>\n",
       "      <th>usertype</th>\n",
       "      <th>birth year</th>\n",
       "      <th>gender</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1970-01-01 00:06:33</td>\n",
       "      <td>2019-08-01 00:00:01.4680</td>\n",
       "      <td>2019-08-01 00:06:35.3780</td>\n",
       "      <td>531.0</td>\n",
       "      <td>Forsyth St &amp; Broome St</td>\n",
       "      <td>40.718939</td>\n",
       "      <td>-73.992663</td>\n",
       "      <td>408.0</td>\n",
       "      <td>Market St &amp; Cherry St</td>\n",
       "      <td>40.710762</td>\n",
       "      <td>-73.994004</td>\n",
       "      <td>35305</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1996</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1970-01-01 00:10:27</td>\n",
       "      <td>2019-08-01 00:00:01.9290</td>\n",
       "      <td>2019-08-01 00:10:29.7840</td>\n",
       "      <td>274.0</td>\n",
       "      <td>Lafayette Ave &amp; Fort Greene Pl</td>\n",
       "      <td>40.686919</td>\n",
       "      <td>-73.976682</td>\n",
       "      <td>3409.0</td>\n",
       "      <td>Bergen St &amp; Smith St</td>\n",
       "      <td>40.686744</td>\n",
       "      <td>-73.990632</td>\n",
       "      <td>38822</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1998</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1970-01-01 00:18:52</td>\n",
       "      <td>2019-08-01 00:00:04.0480</td>\n",
       "      <td>2019-08-01 00:18:56.1650</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>Front St &amp; Washington St</td>\n",
       "      <td>40.702551</td>\n",
       "      <td>-73.989402</td>\n",
       "      <td>3388.0</td>\n",
       "      <td>President St &amp; Henry St</td>\n",
       "      <td>40.682800</td>\n",
       "      <td>-73.999904</td>\n",
       "      <td>18373</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1988</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1970-01-01 00:29:40</td>\n",
       "      <td>2019-08-01 00:00:04.1630</td>\n",
       "      <td>2019-08-01 00:29:44.7940</td>\n",
       "      <td>479.0</td>\n",
       "      <td>9 Ave &amp; W 45 St</td>\n",
       "      <td>40.760193</td>\n",
       "      <td>-73.991255</td>\n",
       "      <td>473.0</td>\n",
       "      <td>Rivington St &amp; Chrystie St</td>\n",
       "      <td>40.721101</td>\n",
       "      <td>-73.991925</td>\n",
       "      <td>25002</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1988</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1970-01-01 00:25:17</td>\n",
       "      <td>2019-08-01 00:00:05.4580</td>\n",
       "      <td>2019-08-01 00:25:23.4550</td>\n",
       "      <td>3312.0</td>\n",
       "      <td>1 Ave &amp; E 94 St</td>\n",
       "      <td>40.781721</td>\n",
       "      <td>-73.945940</td>\n",
       "      <td>3312.0</td>\n",
       "      <td>1 Ave &amp; E 94 St</td>\n",
       "      <td>40.781721</td>\n",
       "      <td>-73.945940</td>\n",
       "      <td>31198</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1965</td>\n",
       "      <td>2</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2344219</th>\n",
       "      <td>1970-01-01 00:03:36</td>\n",
       "      <td>2019-08-31 23:59:46.2930</td>\n",
       "      <td>2019-09-01 00:03:23.0360</td>\n",
       "      <td>116.0</td>\n",
       "      <td>W 17 St &amp; 8 Ave</td>\n",
       "      <td>40.741776</td>\n",
       "      <td>-74.001497</td>\n",
       "      <td>509.0</td>\n",
       "      <td>9 Ave &amp; W 22 St</td>\n",
       "      <td>40.745497</td>\n",
       "      <td>-74.001971</td>\n",
       "      <td>38655</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1972</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2344220</th>\n",
       "      <td>1970-01-01 00:01:57</td>\n",
       "      <td>2019-08-31 23:59:47.7970</td>\n",
       "      <td>2019-09-01 00:01:45.7440</td>\n",
       "      <td>3429.0</td>\n",
       "      <td>Hanson Pl &amp; Ashland Pl</td>\n",
       "      <td>40.685068</td>\n",
       "      <td>-73.977908</td>\n",
       "      <td>353.0</td>\n",
       "      <td>S Portland Ave &amp; Hanson Pl</td>\n",
       "      <td>40.685396</td>\n",
       "      <td>-73.974315</td>\n",
       "      <td>25264</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1982</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2344221</th>\n",
       "      <td>1970-01-01 00:26:54</td>\n",
       "      <td>2019-08-31 23:59:48.1560</td>\n",
       "      <td>2019-09-01 00:26:42.7760</td>\n",
       "      <td>387.0</td>\n",
       "      <td>Centre St &amp; Chambers St</td>\n",
       "      <td>40.712733</td>\n",
       "      <td>-74.004607</td>\n",
       "      <td>3440.0</td>\n",
       "      <td>Fulton St &amp; Adams St</td>\n",
       "      <td>40.692418</td>\n",
       "      <td>-73.989495</td>\n",
       "      <td>28485</td>\n",
       "      <td>Customer</td>\n",
       "      <td>1969</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2344222</th>\n",
       "      <td>1970-01-01 00:21:41</td>\n",
       "      <td>2019-08-31 23:59:58.3620</td>\n",
       "      <td>2019-09-01 00:21:39.7040</td>\n",
       "      <td>3168.0</td>\n",
       "      <td>Central Park West &amp; W 85 St</td>\n",
       "      <td>40.784727</td>\n",
       "      <td>-73.969617</td>\n",
       "      <td>423.0</td>\n",
       "      <td>W 54 St &amp; 9 Ave</td>\n",
       "      <td>40.765849</td>\n",
       "      <td>-73.986905</td>\n",
       "      <td>38664</td>\n",
       "      <td>Customer</td>\n",
       "      <td>1969</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2344223</th>\n",
       "      <td>1970-01-01 00:06:59</td>\n",
       "      <td>2019-08-31 23:59:59.4520</td>\n",
       "      <td>2019-09-01 00:06:59.0210</td>\n",
       "      <td>447.0</td>\n",
       "      <td>8 Ave &amp; W 52 St</td>\n",
       "      <td>40.763707</td>\n",
       "      <td>-73.985162</td>\n",
       "      <td>529.0</td>\n",
       "      <td>W 42 St &amp; 8 Ave</td>\n",
       "      <td>40.757570</td>\n",
       "      <td>-73.990985</td>\n",
       "      <td>35210</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1994</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2344224 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               tripduration                 starttime  \\\n",
       "0       1970-01-01 00:06:33  2019-08-01 00:00:01.4680   \n",
       "1       1970-01-01 00:10:27  2019-08-01 00:00:01.9290   \n",
       "2       1970-01-01 00:18:52  2019-08-01 00:00:04.0480   \n",
       "3       1970-01-01 00:29:40  2019-08-01 00:00:04.1630   \n",
       "4       1970-01-01 00:25:17  2019-08-01 00:00:05.4580   \n",
       "...                     ...                       ...   \n",
       "2344219 1970-01-01 00:03:36  2019-08-31 23:59:46.2930   \n",
       "2344220 1970-01-01 00:01:57  2019-08-31 23:59:47.7970   \n",
       "2344221 1970-01-01 00:26:54  2019-08-31 23:59:48.1560   \n",
       "2344222 1970-01-01 00:21:41  2019-08-31 23:59:58.3620   \n",
       "2344223 1970-01-01 00:06:59  2019-08-31 23:59:59.4520   \n",
       "\n",
       "                         stoptime  start station id  \\\n",
       "0        2019-08-01 00:06:35.3780             531.0   \n",
       "1        2019-08-01 00:10:29.7840             274.0   \n",
       "2        2019-08-01 00:18:56.1650            2000.0   \n",
       "3        2019-08-01 00:29:44.7940             479.0   \n",
       "4        2019-08-01 00:25:23.4550            3312.0   \n",
       "...                           ...               ...   \n",
       "2344219  2019-09-01 00:03:23.0360             116.0   \n",
       "2344220  2019-09-01 00:01:45.7440            3429.0   \n",
       "2344221  2019-09-01 00:26:42.7760             387.0   \n",
       "2344222  2019-09-01 00:21:39.7040            3168.0   \n",
       "2344223  2019-09-01 00:06:59.0210             447.0   \n",
       "\n",
       "                     start station name  start station latitude  \\\n",
       "0                Forsyth St & Broome St               40.718939   \n",
       "1        Lafayette Ave & Fort Greene Pl               40.686919   \n",
       "2              Front St & Washington St               40.702551   \n",
       "3                       9 Ave & W 45 St               40.760193   \n",
       "4                       1 Ave & E 94 St               40.781721   \n",
       "...                                 ...                     ...   \n",
       "2344219                 W 17 St & 8 Ave               40.741776   \n",
       "2344220          Hanson Pl & Ashland Pl               40.685068   \n",
       "2344221         Centre St & Chambers St               40.712733   \n",
       "2344222     Central Park West & W 85 St               40.784727   \n",
       "2344223                 8 Ave & W 52 St               40.763707   \n",
       "\n",
       "         start station longitude  end station id            end station name  \\\n",
       "0                     -73.992663           408.0       Market St & Cherry St   \n",
       "1                     -73.976682          3409.0        Bergen St & Smith St   \n",
       "2                     -73.989402          3388.0     President St & Henry St   \n",
       "3                     -73.991255           473.0  Rivington St & Chrystie St   \n",
       "4                     -73.945940          3312.0             1 Ave & E 94 St   \n",
       "...                          ...             ...                         ...   \n",
       "2344219               -74.001497           509.0             9 Ave & W 22 St   \n",
       "2344220               -73.977908           353.0  S Portland Ave & Hanson Pl   \n",
       "2344221               -74.004607          3440.0        Fulton St & Adams St   \n",
       "2344222               -73.969617           423.0             W 54 St & 9 Ave   \n",
       "2344223               -73.985162           529.0             W 42 St & 8 Ave   \n",
       "\n",
       "         end station latitude  end station longitude  bikeid    usertype  \\\n",
       "0                   40.710762             -73.994004   35305  Subscriber   \n",
       "1                   40.686744             -73.990632   38822  Subscriber   \n",
       "2                   40.682800             -73.999904   18373  Subscriber   \n",
       "3                   40.721101             -73.991925   25002  Subscriber   \n",
       "4                   40.781721             -73.945940   31198  Subscriber   \n",
       "...                       ...                    ...     ...         ...   \n",
       "2344219             40.745497             -74.001971   38655  Subscriber   \n",
       "2344220             40.685396             -73.974315   25264  Subscriber   \n",
       "2344221             40.692418             -73.989495   28485    Customer   \n",
       "2344222             40.765849             -73.986905   38664    Customer   \n",
       "2344223             40.757570             -73.990985   35210  Subscriber   \n",
       "\n",
       "         birth year  gender  \n",
       "0              1996       2  \n",
       "1              1998       2  \n",
       "2              1988       1  \n",
       "3              1988       1  \n",
       "4              1965       2  \n",
       "...             ...     ...  \n",
       "2344219        1972       1  \n",
       "2344220        1982       2  \n",
       "2344221        1969       0  \n",
       "2344222        1969       0  \n",
       "2344223        1994       1  \n",
       "\n",
       "[2344224 rows x 15 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 3. Convert the 'tripduration' column to datetime datatype.\n",
    "citibike_tripdata_df['tripduration'] = pd.to_datetime(citibike_tripdata_df['tripduration'], unit = 's')\n",
    "citibike_tripdata_df\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "tripduration               datetime64[ns]\n",
       "starttime                          object\n",
       "stoptime                           object\n",
       "start station id                  float64\n",
       "start station name                 object\n",
       "start station latitude            float64\n",
       "start station longitude           float64\n",
       "end station id                    float64\n",
       "end station name                   object\n",
       "end station latitude              float64\n",
       "end station longitude             float64\n",
       "bikeid                              int64\n",
       "usertype                           object\n",
       "birth year                          int64\n",
       "gender                              int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 4. Check the datatypes of your columns. \n",
    "citibike_tripdata_df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 5. Export the Dataframe as a new CSV file without the index.\n",
    "citibike_tripdata_df.to_csv('formatted_citibike_data.csv', index = False )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "PythonData",
   "language": "python",
   "name": "pythondata"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}