Data Cleaning.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Citi Bike JC Data Cleaning"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "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>tripduration</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",
       "      <th>start date</th>\n",
       "      <th>end date</th>\n",
       "      <th>start time</th>\n",
       "      <th>end time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>201</td>\n",
       "      <td>3183</td>\n",
       "      <td>Exchange Place</td>\n",
       "      <td>40.716247</td>\n",
       "      <td>-74.033459</td>\n",
       "      <td>3214</td>\n",
       "      <td>Essex Light Rail</td>\n",
       "      <td>40.712774</td>\n",
       "      <td>-74.036486</td>\n",
       "      <td>29612</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1993</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-01-01</td>\n",
       "      <td>2019-01-01</td>\n",
       "      <td>03:09:09.7110</td>\n",
       "      <td>03:12:30.8790</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>505</td>\n",
       "      <td>3183</td>\n",
       "      <td>Exchange Place</td>\n",
       "      <td>40.716247</td>\n",
       "      <td>-74.033459</td>\n",
       "      <td>3638</td>\n",
       "      <td>Washington St</td>\n",
       "      <td>40.724294</td>\n",
       "      <td>-74.035483</td>\n",
       "      <td>29213</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1972</td>\n",
       "      <td>2</td>\n",
       "      <td>2019-01-01</td>\n",
       "      <td>2019-01-01</td>\n",
       "      <td>05:18:00.1060</td>\n",
       "      <td>05:26:25.9050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>756</td>\n",
       "      <td>3183</td>\n",
       "      <td>Exchange Place</td>\n",
       "      <td>40.716247</td>\n",
       "      <td>-74.033459</td>\n",
       "      <td>3192</td>\n",
       "      <td>Liberty Light Rail</td>\n",
       "      <td>40.711242</td>\n",
       "      <td>-74.055701</td>\n",
       "      <td>26164</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1985</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-01-01</td>\n",
       "      <td>2019-01-01</td>\n",
       "      <td>10:36:33.3400</td>\n",
       "      <td>10:49:10.2600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1575</td>\n",
       "      <td>3183</td>\n",
       "      <td>Exchange Place</td>\n",
       "      <td>40.716247</td>\n",
       "      <td>-74.033459</td>\n",
       "      <td>3638</td>\n",
       "      <td>Washington St</td>\n",
       "      <td>40.724294</td>\n",
       "      <td>-74.035483</td>\n",
       "      <td>29672</td>\n",
       "      <td>Customer</td>\n",
       "      <td>1969</td>\n",
       "      <td>0</td>\n",
       "      <td>2019-01-01</td>\n",
       "      <td>2019-01-01</td>\n",
       "      <td>12:43:38.6430</td>\n",
       "      <td>13:09:54.5280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1566</td>\n",
       "      <td>3183</td>\n",
       "      <td>Exchange Place</td>\n",
       "      <td>40.716247</td>\n",
       "      <td>-74.033459</td>\n",
       "      <td>3638</td>\n",
       "      <td>Washington St</td>\n",
       "      <td>40.724294</td>\n",
       "      <td>-74.035483</td>\n",
       "      <td>29522</td>\n",
       "      <td>Customer</td>\n",
       "      <td>1969</td>\n",
       "      <td>0</td>\n",
       "      <td>2019-01-01</td>\n",
       "      <td>2019-01-01</td>\n",
       "      <td>12:43:39.6010</td>\n",
       "      <td>13:09:46.5100</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   tripduration  start station id start station name  start station latitude  \\\n",
       "0           201              3183     Exchange Place               40.716247   \n",
       "1           505              3183     Exchange Place               40.716247   \n",
       "2           756              3183     Exchange Place               40.716247   \n",
       "3          1575              3183     Exchange Place               40.716247   \n",
       "4          1566              3183     Exchange Place               40.716247   \n",
       "\n",
       "   start station longitude  end station id    end station name  \\\n",
       "0               -74.033459            3214    Essex Light Rail   \n",
       "1               -74.033459            3638       Washington St   \n",
       "2               -74.033459            3192  Liberty Light Rail   \n",
       "3               -74.033459            3638       Washington St   \n",
       "4               -74.033459            3638       Washington St   \n",
       "\n",
       "   end station latitude  end station longitude  bikeid    usertype  \\\n",
       "0             40.712774             -74.036486   29612  Subscriber   \n",
       "1             40.724294             -74.035483   29213  Subscriber   \n",
       "2             40.711242             -74.055701   26164  Subscriber   \n",
       "3             40.724294             -74.035483   29672    Customer   \n",
       "4             40.724294             -74.035483   29522    Customer   \n",
       "\n",
       "   birth year  gender  start date    end date     start time       end time  \n",
       "0        1993       1  2019-01-01  2019-01-01  03:09:09.7110  03:12:30.8790  \n",
       "1        1972       2  2019-01-01  2019-01-01  05:18:00.1060  05:26:25.9050  \n",
       "2        1985       1  2019-01-01  2019-01-01  10:36:33.3400  10:49:10.2600  \n",
       "3        1969       0  2019-01-01  2019-01-01  12:43:38.6430  13:09:54.5280  \n",
       "4        1969       0  2019-01-01  2019-01-01  12:43:39.6010  13:09:46.5100  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Loading CSV\n",
    "jan_citi_data = \"data/JC-201901-citibike-tripdata.csv\"\n",
    "\n",
    "# Reading CSV into a DF\n",
    "jan_df = pd.read_csv(jan_citi_data)\n",
    "jan_df.dropna(inplace = True)\n",
    "\n",
    "# Splitting the 'starttime' column to have access to more data\n",
    "new = jan_df[\"starttime\"].str.split(\" \", n = 1, expand = True) \n",
    "new2 = jan_df[\"stoptime\"].str.split(\" \", n = 1, expand = True) \n",
    "\n",
    "# Creating new columns and assigning those columns data\n",
    "jan_df[\"start date\"]= new[0] \n",
    "jan_df[\"end date\"]= new2[0]\n",
    "jan_df[\"start time\"]= new[1] \n",
    "jan_df[\"end time\"]= new2[1]\n",
    "\n",
    "# Dropping the previous column\n",
    "jan_df.drop(columns =[\"starttime\"], inplace = True)\n",
    "jan_df.drop(columns =[\"stoptime\"], inplace = True)\n",
    "\n",
    "jan_df.to_csv('data/cleaned/jan_JC_data.csv')\n",
    "jan_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>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",
       "      <th>start date</th>\n",
       "      <th>end date</th>\n",
       "      <th>start time</th>\n",
       "      <th>end time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>142</td>\n",
       "      <td>3183</td>\n",
       "      <td>Exchange Place</td>\n",
       "      <td>40.716247</td>\n",
       "      <td>-74.033459</td>\n",
       "      <td>3639</td>\n",
       "      <td>Harborside</td>\n",
       "      <td>40.719252</td>\n",
       "      <td>-74.034234</td>\n",
       "      <td>29677</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1963</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-02-01</td>\n",
       "      <td>2019-02-01</td>\n",
       "      <td>15:35:02.0820</td>\n",
       "      <td>15:37:24.1360</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>223</td>\n",
       "      <td>3183</td>\n",
       "      <td>Exchange Place</td>\n",
       "      <td>40.716247</td>\n",
       "      <td>-74.033459</td>\n",
       "      <td>3681</td>\n",
       "      <td>Grand St</td>\n",
       "      <td>40.715178</td>\n",
       "      <td>-74.037683</td>\n",
       "      <td>26234</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1992</td>\n",
       "      <td>2</td>\n",
       "      <td>2019-02-01</td>\n",
       "      <td>2019-02-01</td>\n",
       "      <td>17:00:46.8900</td>\n",
       "      <td>17:04:30.5500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>106</td>\n",
       "      <td>3183</td>\n",
       "      <td>Exchange Place</td>\n",
       "      <td>40.716247</td>\n",
       "      <td>-74.033459</td>\n",
       "      <td>3184</td>\n",
       "      <td>Paulus Hook</td>\n",
       "      <td>40.714145</td>\n",
       "      <td>-74.033552</td>\n",
       "      <td>29588</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1960</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-02-01</td>\n",
       "      <td>2019-02-01</td>\n",
       "      <td>17:08:01.3260</td>\n",
       "      <td>17:09:47.4400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>370</td>\n",
       "      <td>3183</td>\n",
       "      <td>Exchange Place</td>\n",
       "      <td>40.716247</td>\n",
       "      <td>-74.033459</td>\n",
       "      <td>3211</td>\n",
       "      <td>Newark Ave</td>\n",
       "      <td>40.721525</td>\n",
       "      <td>-74.046305</td>\n",
       "      <td>29250</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1976</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-02-01</td>\n",
       "      <td>2019-02-01</td>\n",
       "      <td>17:09:31.2100</td>\n",
       "      <td>17:15:41.6550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>315</td>\n",
       "      <td>3183</td>\n",
       "      <td>Exchange Place</td>\n",
       "      <td>40.716247</td>\n",
       "      <td>-74.033459</td>\n",
       "      <td>3273</td>\n",
       "      <td>Manila &amp; 1st</td>\n",
       "      <td>40.721651</td>\n",
       "      <td>-74.042884</td>\n",
       "      <td>29586</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1980</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-02-01</td>\n",
       "      <td>2019-02-01</td>\n",
       "      <td>17:19:53.2490</td>\n",
       "      <td>17:25:09.1400</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   tripduration  start station id start station name  start station latitude  \\\n",
       "0           142              3183     Exchange Place               40.716247   \n",
       "1           223              3183     Exchange Place               40.716247   \n",
       "2           106              3183     Exchange Place               40.716247   \n",
       "3           370              3183     Exchange Place               40.716247   \n",
       "4           315              3183     Exchange Place               40.716247   \n",
       "\n",
       "   start station longitude  end station id end station name  \\\n",
       "0               -74.033459            3639       Harborside   \n",
       "1               -74.033459            3681         Grand St   \n",
       "2               -74.033459            3184      Paulus Hook   \n",
       "3               -74.033459            3211       Newark Ave   \n",
       "4               -74.033459            3273     Manila & 1st   \n",
       "\n",
       "   end station latitude  end station longitude  bikeid    usertype  \\\n",
       "0             40.719252             -74.034234   29677  Subscriber   \n",
       "1             40.715178             -74.037683   26234  Subscriber   \n",
       "2             40.714145             -74.033552   29588  Subscriber   \n",
       "3             40.721525             -74.046305   29250  Subscriber   \n",
       "4             40.721651             -74.042884   29586  Subscriber   \n",
       "\n",
       "   birth year  gender  start date    end date     start time       end time  \n",
       "0        1963       1  2019-02-01  2019-02-01  15:35:02.0820  15:37:24.1360  \n",
       "1        1992       2  2019-02-01  2019-02-01  17:00:46.8900  17:04:30.5500  \n",
       "2        1960       1  2019-02-01  2019-02-01  17:08:01.3260  17:09:47.4400  \n",
       "3        1976       1  2019-02-01  2019-02-01  17:09:31.2100  17:15:41.6550  \n",
       "4        1980       1  2019-02-01  2019-02-01  17:19:53.2490  17:25:09.1400  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Loading CSV\n",
    "feb_citi_data = \"data/JC-201902-citibike-tripdata.csv\"\n",
    "\n",
    "# Reading CSV into a DF\n",
    "feb_df = pd.read_csv(feb_citi_data)\n",
    "feb_df.dropna(inplace = True)\n",
    "\n",
    "# Splitting the 'starttime' column to have access to more data\n",
    "new = feb_df[\"starttime\"].str.split(\" \", n = 1, expand = True) \n",
    "new2 = feb_df[\"stoptime\"].str.split(\" \", n = 1, expand = True) \n",
    "\n",
    "# Creating new columns and assigning those columns data\n",
    "feb_df[\"start date\"]= new[0] \n",
    "feb_df[\"end date\"]= new2[0]\n",
    "feb_df[\"start time\"]= new[1] \n",
    "feb_df[\"end time\"]= new2[1]\n",
    "\n",
    "# Dropping the previous column\n",
    "feb_df.drop(columns =[\"starttime\"], inplace = True)\n",
    "feb_df.drop(columns =[\"stoptime\"], inplace = True)\n",
    "\n",
    "feb_df.to_csv('data/cleaned/feb_JC_data.csv')\n",
    "feb_df.head()"
   ]
  },
  {
   "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>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",
       "      <th>start date</th>\n",
       "      <th>end date</th>\n",
       "      <th>start time</th>\n",
       "      <th>end time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>306</td>\n",
       "      <td>3183</td>\n",
       "      <td>Exchange Place</td>\n",
       "      <td>40.716247</td>\n",
       "      <td>-74.033459</td>\n",
       "      <td>3267</td>\n",
       "      <td>Morris Canal</td>\n",
       "      <td>40.712419</td>\n",
       "      <td>-74.038526</td>\n",
       "      <td>26272</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1989</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-03-01</td>\n",
       "      <td>2019-03-01</td>\n",
       "      <td>06:47:08.2110</td>\n",
       "      <td>06:52:14.7150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>123</td>\n",
       "      <td>3183</td>\n",
       "      <td>Exchange Place</td>\n",
       "      <td>40.716247</td>\n",
       "      <td>-74.033459</td>\n",
       "      <td>3184</td>\n",
       "      <td>Paulus Hook</td>\n",
       "      <td>40.714145</td>\n",
       "      <td>-74.033552</td>\n",
       "      <td>26192</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1966</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-03-01</td>\n",
       "      <td>2019-03-01</td>\n",
       "      <td>07:30:53.0220</td>\n",
       "      <td>07:32:56.7770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>328</td>\n",
       "      <td>3183</td>\n",
       "      <td>Exchange Place</td>\n",
       "      <td>40.716247</td>\n",
       "      <td>-74.033459</td>\n",
       "      <td>3213</td>\n",
       "      <td>Van Vorst Park</td>\n",
       "      <td>40.718489</td>\n",
       "      <td>-74.047727</td>\n",
       "      <td>26226</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1971</td>\n",
       "      <td>2</td>\n",
       "      <td>2019-03-01</td>\n",
       "      <td>2019-03-01</td>\n",
       "      <td>08:18:30.4030</td>\n",
       "      <td>08:23:59.0590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>95</td>\n",
       "      <td>3183</td>\n",
       "      <td>Exchange Place</td>\n",
       "      <td>40.716247</td>\n",
       "      <td>-74.033459</td>\n",
       "      <td>3184</td>\n",
       "      <td>Paulus Hook</td>\n",
       "      <td>40.714145</td>\n",
       "      <td>-74.033552</td>\n",
       "      <td>26204</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1985</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-03-01</td>\n",
       "      <td>2019-03-01</td>\n",
       "      <td>11:04:47.2020</td>\n",
       "      <td>11:06:22.8130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>169</td>\n",
       "      <td>3183</td>\n",
       "      <td>Exchange Place</td>\n",
       "      <td>40.716247</td>\n",
       "      <td>-74.033459</td>\n",
       "      <td>3639</td>\n",
       "      <td>Harborside</td>\n",
       "      <td>40.719252</td>\n",
       "      <td>-74.034234</td>\n",
       "      <td>29449</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1971</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-03-01</td>\n",
       "      <td>2019-03-01</td>\n",
       "      <td>11:51:29.4170</td>\n",
       "      <td>11:54:19.2120</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   tripduration  start station id start station name  start station latitude  \\\n",
       "0           306              3183     Exchange Place               40.716247   \n",
       "1           123              3183     Exchange Place               40.716247   \n",
       "2           328              3183     Exchange Place               40.716247   \n",
       "3            95              3183     Exchange Place               40.716247   \n",
       "4           169              3183     Exchange Place               40.716247   \n",
       "\n",
       "   start station longitude  end station id end station name  \\\n",
       "0               -74.033459            3267     Morris Canal   \n",
       "1               -74.033459            3184      Paulus Hook   \n",
       "2               -74.033459            3213   Van Vorst Park   \n",
       "3               -74.033459            3184      Paulus Hook   \n",
       "4               -74.033459            3639       Harborside   \n",
       "\n",
       "   end station latitude  end station longitude  bikeid    usertype  \\\n",
       "0             40.712419             -74.038526   26272  Subscriber   \n",
       "1             40.714145             -74.033552   26192  Subscriber   \n",
       "2             40.718489             -74.047727   26226  Subscriber   \n",
       "3             40.714145             -74.033552   26204  Subscriber   \n",
       "4             40.719252             -74.034234   29449  Subscriber   \n",
       "\n",
       "   birth year  gender  start date    end date     start time       end time  \n",
       "0        1989       1  2019-03-01  2019-03-01  06:47:08.2110  06:52:14.7150  \n",
       "1        1966       1  2019-03-01  2019-03-01  07:30:53.0220  07:32:56.7770  \n",
       "2        1971       2  2019-03-01  2019-03-01  08:18:30.4030  08:23:59.0590  \n",
       "3        1985       1  2019-03-01  2019-03-01  11:04:47.2020  11:06:22.8130  \n",
       "4        1971       1  2019-03-01  2019-03-01  11:51:29.4170  11:54:19.2120  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Loading CSV\n",
    "mar_citi_data = \"data/JC-201903-citibike-tripdata.csv\"\n",
    "\n",
    "# Reading CSV into a DF\n",
    "mar_df = pd.read_csv(mar_citi_data)\n",
    "mar_df.dropna(inplace = True)\n",
    "\n",
    "# Splitting the 'starttime' column to have access to more data\n",
    "new = mar_df[\"starttime\"].str.split(\" \", n = 1, expand = True) \n",
    "new2 = mar_df[\"stoptime\"].str.split(\" \", n = 1, expand = True) \n",
    "\n",
    "# Creating new columns and assigning those columns data\n",
    "mar_df[\"start date\"]= new[0] \n",
    "mar_df[\"end date\"]= new2[0]\n",
    "mar_df[\"start time\"]= new[1] \n",
    "mar_df[\"end time\"]= new2[1]\n",
    "\n",
    "# Dropping the previous column\n",
    "mar_df.drop(columns =[\"starttime\"], inplace = True)\n",
    "mar_df.drop(columns =[\"stoptime\"], inplace = True)\n",
    "\n",
    "mar_df.to_csv('data/cleaned/mar_JC_data.csv')\n",
    "mar_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>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",
       "      <th>start date</th>\n",
       "      <th>end date</th>\n",
       "      <th>start time</th>\n",
       "      <th>end time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>107</td>\n",
       "      <td>3183</td>\n",
       "      <td>Exchange Place</td>\n",
       "      <td>40.716247</td>\n",
       "      <td>-74.033459</td>\n",
       "      <td>3184</td>\n",
       "      <td>Paulus Hook</td>\n",
       "      <td>40.714145</td>\n",
       "      <td>-74.033552</td>\n",
       "      <td>29536</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1966</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-04-01</td>\n",
       "      <td>2019-04-01</td>\n",
       "      <td>07:48:04.7540</td>\n",
       "      <td>07:49:52.3590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>493</td>\n",
       "      <td>3183</td>\n",
       "      <td>Exchange Place</td>\n",
       "      <td>40.716247</td>\n",
       "      <td>-74.033459</td>\n",
       "      <td>3187</td>\n",
       "      <td>Warren St</td>\n",
       "      <td>40.721124</td>\n",
       "      <td>-74.038051</td>\n",
       "      <td>26191</td>\n",
       "      <td>Customer</td>\n",
       "      <td>1990</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-04-01</td>\n",
       "      <td>2019-04-01</td>\n",
       "      <td>12:41:09.6540</td>\n",
       "      <td>12:49:23.0290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>512</td>\n",
       "      <td>3183</td>\n",
       "      <td>Exchange Place</td>\n",
       "      <td>40.716247</td>\n",
       "      <td>-74.033459</td>\n",
       "      <td>3202</td>\n",
       "      <td>Newport PATH</td>\n",
       "      <td>40.727224</td>\n",
       "      <td>-74.033759</td>\n",
       "      <td>29302</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1987</td>\n",
       "      <td>2</td>\n",
       "      <td>2019-04-01</td>\n",
       "      <td>2019-04-01</td>\n",
       "      <td>14:27:07.9400</td>\n",
       "      <td>14:35:40.9370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>196</td>\n",
       "      <td>3183</td>\n",
       "      <td>Exchange Place</td>\n",
       "      <td>40.716247</td>\n",
       "      <td>-74.033459</td>\n",
       "      <td>3214</td>\n",
       "      <td>Essex Light Rail</td>\n",
       "      <td>40.712774</td>\n",
       "      <td>-74.036486</td>\n",
       "      <td>26220</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1989</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-04-01</td>\n",
       "      <td>2019-04-01</td>\n",
       "      <td>15:07:38.1510</td>\n",
       "      <td>15:10:54.6260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>463</td>\n",
       "      <td>3183</td>\n",
       "      <td>Exchange Place</td>\n",
       "      <td>40.716247</td>\n",
       "      <td>-74.033459</td>\n",
       "      <td>3273</td>\n",
       "      <td>Manila &amp; 1st</td>\n",
       "      <td>40.721651</td>\n",
       "      <td>-74.042884</td>\n",
       "      <td>26228</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1995</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-04-01</td>\n",
       "      <td>2019-04-01</td>\n",
       "      <td>16:19:24.6940</td>\n",
       "      <td>16:27:08.6450</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   tripduration  start station id start station name  start station latitude  \\\n",
       "0           107              3183     Exchange Place               40.716247   \n",
       "1           493              3183     Exchange Place               40.716247   \n",
       "2           512              3183     Exchange Place               40.716247   \n",
       "3           196              3183     Exchange Place               40.716247   \n",
       "4           463              3183     Exchange Place               40.716247   \n",
       "\n",
       "   start station longitude  end station id  end station name  \\\n",
       "0               -74.033459            3184       Paulus Hook   \n",
       "1               -74.033459            3187         Warren St   \n",
       "2               -74.033459            3202      Newport PATH   \n",
       "3               -74.033459            3214  Essex Light Rail   \n",
       "4               -74.033459            3273      Manila & 1st   \n",
       "\n",
       "   end station latitude  end station longitude  bikeid    usertype  \\\n",
       "0             40.714145             -74.033552   29536  Subscriber   \n",
       "1             40.721124             -74.038051   26191    Customer   \n",
       "2             40.727224             -74.033759   29302  Subscriber   \n",
       "3             40.712774             -74.036486   26220  Subscriber   \n",
       "4             40.721651             -74.042884   26228  Subscriber   \n",
       "\n",
       "   birth year  gender  start date    end date     start time       end time  \n",
       "0        1966       1  2019-04-01  2019-04-01  07:48:04.7540  07:49:52.3590  \n",
       "1        1990       1  2019-04-01  2019-04-01  12:41:09.6540  12:49:23.0290  \n",
       "2        1987       2  2019-04-01  2019-04-01  14:27:07.9400  14:35:40.9370  \n",
       "3        1989       1  2019-04-01  2019-04-01  15:07:38.1510  15:10:54.6260  \n",
       "4        1995       1  2019-04-01  2019-04-01  16:19:24.6940  16:27:08.6450  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Loading CSV\n",
    "apr_citi_data = \"data/JC-201904-citibike-tripdata.csv\"\n",
    "\n",
    "# Reading CSV into a DF\n",
    "apr_df = pd.read_csv(apr_citi_data)\n",
    "apr_df.dropna(inplace = True)\n",
    "\n",
    "# Splitting the 'starttime' column to have access to more data\n",
    "new = apr_df[\"starttime\"].str.split(\" \", n = 1, expand = True) \n",
    "new2 = apr_df[\"stoptime\"].str.split(\" \", n = 1, expand = True) \n",
    "\n",
    "# Creating new columns and assigning those columns data\n",
    "apr_df[\"start date\"]= new[0] \n",
    "apr_df[\"end date\"]= new2[0]\n",
    "apr_df[\"start time\"]= new[1] \n",
    "apr_df[\"end time\"]= new2[1]\n",
    "\n",
    "# Dropping the previous column\n",
    "apr_df.drop(columns =[\"starttime\"], inplace = True)\n",
    "apr_df.drop(columns =[\"stoptime\"], inplace = True)\n",
    "\n",
    "apr_df.to_csv('data/cleaned/apr_JC_data.csv')\n",
    "apr_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>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",
       "      <th>start date</th>\n",
       "      <th>end date</th>\n",
       "      <th>start time</th>\n",
       "      <th>end time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>311</td>\n",
       "      <td>3185</td>\n",
       "      <td>City Hall</td>\n",
       "      <td>40.717733</td>\n",
       "      <td>-74.043845</td>\n",
       "      <td>3279</td>\n",
       "      <td>Dixon Mills</td>\n",
       "      <td>40.721630</td>\n",
       "      <td>-74.049968</td>\n",
       "      <td>29224</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1988</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-05-01</td>\n",
       "      <td>2019-05-01</td>\n",
       "      <td>00:07:36.4670</td>\n",
       "      <td>00:12:47.6350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>538</td>\n",
       "      <td>3681</td>\n",
       "      <td>Grand St</td>\n",
       "      <td>40.715178</td>\n",
       "      <td>-74.037683</td>\n",
       "      <td>3203</td>\n",
       "      <td>Hamilton Park</td>\n",
       "      <td>40.727596</td>\n",
       "      <td>-74.044247</td>\n",
       "      <td>26170</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1974</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-05-01</td>\n",
       "      <td>2019-05-01</td>\n",
       "      <td>00:08:29.2840</td>\n",
       "      <td>00:17:27.9410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>178</td>\n",
       "      <td>3638</td>\n",
       "      <td>Washington St</td>\n",
       "      <td>40.724294</td>\n",
       "      <td>-74.035483</td>\n",
       "      <td>3639</td>\n",
       "      <td>Harborside</td>\n",
       "      <td>40.719252</td>\n",
       "      <td>-74.034234</td>\n",
       "      <td>29517</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1988</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-05-01</td>\n",
       "      <td>2019-05-01</td>\n",
       "      <td>00:39:36.4750</td>\n",
       "      <td>00:42:34.9640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>317</td>\n",
       "      <td>3206</td>\n",
       "      <td>Hilltop</td>\n",
       "      <td>40.731169</td>\n",
       "      <td>-74.057574</td>\n",
       "      <td>3212</td>\n",
       "      <td>Christ Hospital</td>\n",
       "      <td>40.734786</td>\n",
       "      <td>-74.050444</td>\n",
       "      <td>29606</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1986</td>\n",
       "      <td>2</td>\n",
       "      <td>2019-05-01</td>\n",
       "      <td>2019-05-01</td>\n",
       "      <td>01:24:28.0220</td>\n",
       "      <td>01:29:45.5730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>354</td>\n",
       "      <td>3639</td>\n",
       "      <td>Harborside</td>\n",
       "      <td>40.719252</td>\n",
       "      <td>-74.034234</td>\n",
       "      <td>3202</td>\n",
       "      <td>Newport PATH</td>\n",
       "      <td>40.727224</td>\n",
       "      <td>-74.033759</td>\n",
       "      <td>26224</td>\n",
       "      <td>Customer</td>\n",
       "      <td>1986</td>\n",
       "      <td>2</td>\n",
       "      <td>2019-05-01</td>\n",
       "      <td>2019-05-01</td>\n",
       "      <td>01:54:39.6660</td>\n",
       "      <td>02:00:34.1750</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   tripduration  start station id start station name  start station latitude  \\\n",
       "0           311              3185          City Hall               40.717733   \n",
       "1           538              3681           Grand St               40.715178   \n",
       "2           178              3638      Washington St               40.724294   \n",
       "3           317              3206            Hilltop               40.731169   \n",
       "4           354              3639         Harborside               40.719252   \n",
       "\n",
       "   start station longitude  end station id end station name  \\\n",
       "0               -74.043845            3279      Dixon Mills   \n",
       "1               -74.037683            3203    Hamilton Park   \n",
       "2               -74.035483            3639       Harborside   \n",
       "3               -74.057574            3212  Christ Hospital   \n",
       "4               -74.034234            3202     Newport PATH   \n",
       "\n",
       "   end station latitude  end station longitude  bikeid    usertype  \\\n",
       "0             40.721630             -74.049968   29224  Subscriber   \n",
       "1             40.727596             -74.044247   26170  Subscriber   \n",
       "2             40.719252             -74.034234   29517  Subscriber   \n",
       "3             40.734786             -74.050444   29606  Subscriber   \n",
       "4             40.727224             -74.033759   26224    Customer   \n",
       "\n",
       "   birth year  gender  start date    end date     start time       end time  \n",
       "0        1988       1  2019-05-01  2019-05-01  00:07:36.4670  00:12:47.6350  \n",
       "1        1974       1  2019-05-01  2019-05-01  00:08:29.2840  00:17:27.9410  \n",
       "2        1988       1  2019-05-01  2019-05-01  00:39:36.4750  00:42:34.9640  \n",
       "3        1986       2  2019-05-01  2019-05-01  01:24:28.0220  01:29:45.5730  \n",
       "4        1986       2  2019-05-01  2019-05-01  01:54:39.6660  02:00:34.1750  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Loading CSV\n",
    "may_citi_data = \"data/JC-201905-citibike-tripdata.csv\"\n",
    "\n",
    "# Reading CSV into a DF\n",
    "may_df = pd.read_csv(may_citi_data)\n",
    "may_df.dropna(inplace = True)\n",
    "\n",
    "# Splitting the 'starttime' column to have access to more data\n",
    "new = may_df[\"starttime\"].str.split(\" \", n = 1, expand = True) \n",
    "new2 = may_df[\"stoptime\"].str.split(\" \", n = 1, expand = True) \n",
    "\n",
    "# Creating new columns and assigning those columns data\n",
    "may_df[\"start date\"]= new[0] \n",
    "may_df[\"end date\"]= new2[0]\n",
    "may_df[\"start time\"]= new[1] \n",
    "may_df[\"end time\"]= new2[1]\n",
    "\n",
    "# Dropping the previous column\n",
    "may_df.drop(columns =[\"starttime\"], inplace = True)\n",
    "may_df.drop(columns =[\"stoptime\"], inplace = True)\n",
    "\n",
    "may_df.to_csv('data/cleaned/may_JC_data.csv')\n",
    "may_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>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",
       "      <th>start date</th>\n",
       "      <th>end date</th>\n",
       "      <th>start time</th>\n",
       "      <th>end time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>316</td>\n",
       "      <td>3187</td>\n",
       "      <td>Warren St</td>\n",
       "      <td>40.721124</td>\n",
       "      <td>-74.038051</td>\n",
       "      <td>3199</td>\n",
       "      <td>Newport Pkwy</td>\n",
       "      <td>40.728745</td>\n",
       "      <td>-74.032108</td>\n",
       "      <td>29677</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1993</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-06-01</td>\n",
       "      <td>2019-06-01</td>\n",
       "      <td>00:05:55.7210</td>\n",
       "      <td>00:11:11.9940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>280</td>\n",
       "      <td>3185</td>\n",
       "      <td>City Hall</td>\n",
       "      <td>40.717733</td>\n",
       "      <td>-74.043845</td>\n",
       "      <td>3267</td>\n",
       "      <td>Morris Canal</td>\n",
       "      <td>40.712419</td>\n",
       "      <td>-74.038526</td>\n",
       "      <td>29571</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1984</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-06-01</td>\n",
       "      <td>2019-06-01</td>\n",
       "      <td>00:08:09.0920</td>\n",
       "      <td>00:12:50.0730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2162</td>\n",
       "      <td>3199</td>\n",
       "      <td>Newport Pkwy</td>\n",
       "      <td>40.728745</td>\n",
       "      <td>-74.032108</td>\n",
       "      <td>3199</td>\n",
       "      <td>Newport Pkwy</td>\n",
       "      <td>40.728745</td>\n",
       "      <td>-74.032108</td>\n",
       "      <td>26208</td>\n",
       "      <td>Customer</td>\n",
       "      <td>1969</td>\n",
       "      <td>0</td>\n",
       "      <td>2019-06-01</td>\n",
       "      <td>2019-06-01</td>\n",
       "      <td>00:13:11.8800</td>\n",
       "      <td>00:49:14.3640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2184</td>\n",
       "      <td>3199</td>\n",
       "      <td>Newport Pkwy</td>\n",
       "      <td>40.728745</td>\n",
       "      <td>-74.032108</td>\n",
       "      <td>3199</td>\n",
       "      <td>Newport Pkwy</td>\n",
       "      <td>40.728745</td>\n",
       "      <td>-74.032108</td>\n",
       "      <td>29487</td>\n",
       "      <td>Customer</td>\n",
       "      <td>1969</td>\n",
       "      <td>0</td>\n",
       "      <td>2019-06-01</td>\n",
       "      <td>2019-06-01</td>\n",
       "      <td>00:13:30.1110</td>\n",
       "      <td>00:49:54.2250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>139</td>\n",
       "      <td>3207</td>\n",
       "      <td>Oakland Ave</td>\n",
       "      <td>40.737604</td>\n",
       "      <td>-74.052478</td>\n",
       "      <td>3207</td>\n",
       "      <td>Oakland Ave</td>\n",
       "      <td>40.737604</td>\n",
       "      <td>-74.052478</td>\n",
       "      <td>29592</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1994</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-06-01</td>\n",
       "      <td>2019-06-01</td>\n",
       "      <td>00:13:31.8520</td>\n",
       "      <td>00:15:51.7880</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   tripduration  start station id start station name  start station latitude  \\\n",
       "0           316              3187          Warren St               40.721124   \n",
       "1           280              3185          City Hall               40.717733   \n",
       "2          2162              3199       Newport Pkwy               40.728745   \n",
       "3          2184              3199       Newport Pkwy               40.728745   \n",
       "4           139              3207        Oakland Ave               40.737604   \n",
       "\n",
       "   start station longitude  end station id end station name  \\\n",
       "0               -74.038051            3199     Newport Pkwy   \n",
       "1               -74.043845            3267     Morris Canal   \n",
       "2               -74.032108            3199     Newport Pkwy   \n",
       "3               -74.032108            3199     Newport Pkwy   \n",
       "4               -74.052478            3207      Oakland Ave   \n",
       "\n",
       "   end station latitude  end station longitude  bikeid    usertype  \\\n",
       "0             40.728745             -74.032108   29677  Subscriber   \n",
       "1             40.712419             -74.038526   29571  Subscriber   \n",
       "2             40.728745             -74.032108   26208    Customer   \n",
       "3             40.728745             -74.032108   29487    Customer   \n",
       "4             40.737604             -74.052478   29592  Subscriber   \n",
       "\n",
       "   birth year  gender  start date    end date     start time       end time  \n",
       "0        1993       1  2019-06-01  2019-06-01  00:05:55.7210  00:11:11.9940  \n",
       "1        1984       1  2019-06-01  2019-06-01  00:08:09.0920  00:12:50.0730  \n",
       "2        1969       0  2019-06-01  2019-06-01  00:13:11.8800  00:49:14.3640  \n",
       "3        1969       0  2019-06-01  2019-06-01  00:13:30.1110  00:49:54.2250  \n",
       "4        1994       1  2019-06-01  2019-06-01  00:13:31.8520  00:15:51.7880  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Loading CSV\n",
    "june_citi_data = \"data/JC-201906-citibike-tripdata.csv\"\n",
    "\n",
    "# Reading CSV into a DF\n",
    "june_df = pd.read_csv(june_citi_data)\n",
    "june_df.dropna(inplace = True)\n",
    "\n",
    "# Splitting the 'starttime' column to have access to more data\n",
    "new = june_df[\"starttime\"].str.split(\" \", n = 1, expand = True) \n",
    "new2 = june_df[\"stoptime\"].str.split(\" \", n = 1, expand = True) \n",
    "\n",
    "# Creating new columns and assigning those columns data\n",
    "june_df[\"start date\"]= new[0] \n",
    "june_df[\"end date\"]= new2[0]\n",
    "june_df[\"start time\"]= new[1] \n",
    "june_df[\"end time\"]= new2[1]\n",
    "\n",
    "# Dropping the previous column\n",
    "june_df.drop(columns =[\"starttime\"], inplace = True)\n",
    "june_df.drop(columns =[\"stoptime\"], inplace = True)\n",
    "\n",
    "june_df.to_csv('data/cleaned/june_JC_data.csv')\n",
    "june_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>tripduration</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",
       "      <th>start date</th>\n",
       "      <th>end date</th>\n",
       "      <th>start time</th>\n",
       "      <th>end time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1793</td>\n",
       "      <td>3186</td>\n",
       "      <td>Grove St PATH</td>\n",
       "      <td>40.719586</td>\n",
       "      <td>-74.043117</td>\n",
       "      <td>3198</td>\n",
       "      <td>Heights Elevator</td>\n",
       "      <td>40.748716</td>\n",
       "      <td>-74.040443</td>\n",
       "      <td>29595</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1978</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-07-01</td>\n",
       "      <td>2019-07-01</td>\n",
       "      <td>00:00:36.6150</td>\n",
       "      <td>00:30:30.5940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>434</td>\n",
       "      <td>3206</td>\n",
       "      <td>Hilltop</td>\n",
       "      <td>40.731169</td>\n",
       "      <td>-74.057574</td>\n",
       "      <td>3280</td>\n",
       "      <td>Astor Place</td>\n",
       "      <td>40.719282</td>\n",
       "      <td>-74.071262</td>\n",
       "      <td>29647</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1988</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-07-01</td>\n",
       "      <td>2019-07-01</td>\n",
       "      <td>00:02:54.6150</td>\n",
       "      <td>00:10:09.0370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>251</td>\n",
       "      <td>3186</td>\n",
       "      <td>Grove St PATH</td>\n",
       "      <td>40.719586</td>\n",
       "      <td>-74.043117</td>\n",
       "      <td>3205</td>\n",
       "      <td>JC Medical Center</td>\n",
       "      <td>40.716540</td>\n",
       "      <td>-74.049638</td>\n",
       "      <td>26271</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1986</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-07-01</td>\n",
       "      <td>2019-07-01</td>\n",
       "      <td>00:03:27.5670</td>\n",
       "      <td>00:07:38.6080</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>636</td>\n",
       "      <td>3206</td>\n",
       "      <td>Hilltop</td>\n",
       "      <td>40.731169</td>\n",
       "      <td>-74.057574</td>\n",
       "      <td>3281</td>\n",
       "      <td>Leonard Gordon Park</td>\n",
       "      <td>40.745910</td>\n",
       "      <td>-74.057271</td>\n",
       "      <td>26225</td>\n",
       "      <td>Customer</td>\n",
       "      <td>1996</td>\n",
       "      <td>2</td>\n",
       "      <td>2019-07-01</td>\n",
       "      <td>2019-07-01</td>\n",
       "      <td>00:03:56.1690</td>\n",
       "      <td>00:14:32.4180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>623</td>\n",
       "      <td>3206</td>\n",
       "      <td>Hilltop</td>\n",
       "      <td>40.731169</td>\n",
       "      <td>-74.057574</td>\n",
       "      <td>3281</td>\n",
       "      <td>Leonard Gordon Park</td>\n",
       "      <td>40.745910</td>\n",
       "      <td>-74.057271</td>\n",
       "      <td>29230</td>\n",
       "      <td>Customer</td>\n",
       "      <td>1989</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-07-01</td>\n",
       "      <td>2019-07-01</td>\n",
       "      <td>00:04:16.2060</td>\n",
       "      <td>00:14:40.0500</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   tripduration  start station id start station name  start station latitude  \\\n",
       "0          1793              3186      Grove St PATH               40.719586   \n",
       "1           434              3206            Hilltop               40.731169   \n",
       "2           251              3186      Grove St PATH               40.719586   \n",
       "3           636              3206            Hilltop               40.731169   \n",
       "4           623              3206            Hilltop               40.731169   \n",
       "\n",
       "   start station longitude  end station id     end station name  \\\n",
       "0               -74.043117            3198     Heights Elevator   \n",
       "1               -74.057574            3280          Astor Place   \n",
       "2               -74.043117            3205    JC Medical Center   \n",
       "3               -74.057574            3281  Leonard Gordon Park   \n",
       "4               -74.057574            3281  Leonard Gordon Park   \n",
       "\n",
       "   end station latitude  end station longitude  bikeid    usertype  \\\n",
       "0             40.748716             -74.040443   29595  Subscriber   \n",
       "1             40.719282             -74.071262   29647  Subscriber   \n",
       "2             40.716540             -74.049638   26271  Subscriber   \n",
       "3             40.745910             -74.057271   26225    Customer   \n",
       "4             40.745910             -74.057271   29230    Customer   \n",
       "\n",
       "   birth year  gender  start date    end date     start time       end time  \n",
       "0        1978       1  2019-07-01  2019-07-01  00:00:36.6150  00:30:30.5940  \n",
       "1        1988       1  2019-07-01  2019-07-01  00:02:54.6150  00:10:09.0370  \n",
       "2        1986       1  2019-07-01  2019-07-01  00:03:27.5670  00:07:38.6080  \n",
       "3        1996       2  2019-07-01  2019-07-01  00:03:56.1690  00:14:32.4180  \n",
       "4        1989       1  2019-07-01  2019-07-01  00:04:16.2060  00:14:40.0500  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Loading CSV\n",
    "july_citi_data = \"data/JC-201907-citibike-tripdata.csv\"\n",
    "\n",
    "# Reading CSV into a DF\n",
    "july_df = pd.read_csv(july_citi_data)\n",
    "july_df.dropna(inplace = True)\n",
    "\n",
    "# Splitting the 'starttime' column to have access to more data\n",
    "new = july_df[\"starttime\"].str.split(\" \", n = 1, expand = True) \n",
    "new2 = july_df[\"stoptime\"].str.split(\" \", n = 1, expand = True) \n",
    "\n",
    "# Creating new columns and assigning those columns data\n",
    "july_df[\"start date\"]= new[0] \n",
    "july_df[\"end date\"]= new2[0]\n",
    "july_df[\"start time\"]= new[1] \n",
    "july_df[\"end time\"]= new2[1]\n",
    "\n",
    "# Dropping the previous column\n",
    "july_df.drop(columns =[\"starttime\"], inplace = True)\n",
    "july_df.drop(columns =[\"stoptime\"], inplace = True)\n",
    "\n",
    "july_df.to_csv('data/cleaned/july_JC_data.csv')\n",
    "july_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>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",
       "      <th>start date</th>\n",
       "      <th>end date</th>\n",
       "      <th>start time</th>\n",
       "      <th>end time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>261</td>\n",
       "      <td>3205</td>\n",
       "      <td>JC Medical Center</td>\n",
       "      <td>40.716540</td>\n",
       "      <td>-74.049638</td>\n",
       "      <td>3192</td>\n",
       "      <td>Liberty Light Rail</td>\n",
       "      <td>40.711242</td>\n",
       "      <td>-74.055701</td>\n",
       "      <td>26268</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1980</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-08-01</td>\n",
       "      <td>2019-08-01</td>\n",
       "      <td>00:14:55.9900</td>\n",
       "      <td>00:19:17.4780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>172</td>\n",
       "      <td>3279</td>\n",
       "      <td>Dixon Mills</td>\n",
       "      <td>40.721630</td>\n",
       "      <td>-74.049968</td>\n",
       "      <td>3186</td>\n",
       "      <td>Grove St PATH</td>\n",
       "      <td>40.719586</td>\n",
       "      <td>-74.043117</td>\n",
       "      <td>26162</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1996</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-08-01</td>\n",
       "      <td>2019-08-01</td>\n",
       "      <td>00:23:06.9910</td>\n",
       "      <td>00:25:59.1480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>525</td>\n",
       "      <td>3199</td>\n",
       "      <td>Newport Pkwy</td>\n",
       "      <td>40.728745</td>\n",
       "      <td>-74.032108</td>\n",
       "      <td>3203</td>\n",
       "      <td>Hamilton Park</td>\n",
       "      <td>40.727596</td>\n",
       "      <td>-74.044247</td>\n",
       "      <td>29279</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1991</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-08-01</td>\n",
       "      <td>2019-08-01</td>\n",
       "      <td>00:23:28.6170</td>\n",
       "      <td>00:32:13.7000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>219</td>\n",
       "      <td>3187</td>\n",
       "      <td>Warren St</td>\n",
       "      <td>40.721124</td>\n",
       "      <td>-74.038051</td>\n",
       "      <td>3185</td>\n",
       "      <td>City Hall</td>\n",
       "      <td>40.717733</td>\n",
       "      <td>-74.043845</td>\n",
       "      <td>29598</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1988</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-08-01</td>\n",
       "      <td>2019-08-01</td>\n",
       "      <td>00:32:36.1410</td>\n",
       "      <td>00:36:15.2730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>262</td>\n",
       "      <td>3186</td>\n",
       "      <td>Grove St PATH</td>\n",
       "      <td>40.719586</td>\n",
       "      <td>-74.043117</td>\n",
       "      <td>3272</td>\n",
       "      <td>Jersey &amp; 3rd</td>\n",
       "      <td>40.723332</td>\n",
       "      <td>-74.045953</td>\n",
       "      <td>26162</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1960</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-08-01</td>\n",
       "      <td>2019-08-01</td>\n",
       "      <td>00:41:26.6700</td>\n",
       "      <td>00:45:49.3530</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   tripduration  start station id start station name  start station latitude  \\\n",
       "0           261              3205  JC Medical Center               40.716540   \n",
       "1           172              3279        Dixon Mills               40.721630   \n",
       "2           525              3199       Newport Pkwy               40.728745   \n",
       "3           219              3187          Warren St               40.721124   \n",
       "4           262              3186      Grove St PATH               40.719586   \n",
       "\n",
       "   start station longitude  end station id    end station name  \\\n",
       "0               -74.049638            3192  Liberty Light Rail   \n",
       "1               -74.049968            3186       Grove St PATH   \n",
       "2               -74.032108            3203       Hamilton Park   \n",
       "3               -74.038051            3185           City Hall   \n",
       "4               -74.043117            3272        Jersey & 3rd   \n",
       "\n",
       "   end station latitude  end station longitude  bikeid    usertype  \\\n",
       "0             40.711242             -74.055701   26268  Subscriber   \n",
       "1             40.719586             -74.043117   26162  Subscriber   \n",
       "2             40.727596             -74.044247   29279  Subscriber   \n",
       "3             40.717733             -74.043845   29598  Subscriber   \n",
       "4             40.723332             -74.045953   26162  Subscriber   \n",
       "\n",
       "   birth year  gender  start date    end date     start time       end time  \n",
       "0        1980       1  2019-08-01  2019-08-01  00:14:55.9900  00:19:17.4780  \n",
       "1        1996       1  2019-08-01  2019-08-01  00:23:06.9910  00:25:59.1480  \n",
       "2        1991       1  2019-08-01  2019-08-01  00:23:28.6170  00:32:13.7000  \n",
       "3        1988       1  2019-08-01  2019-08-01  00:32:36.1410  00:36:15.2730  \n",
       "4        1960       1  2019-08-01  2019-08-01  00:41:26.6700  00:45:49.3530  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Loading CSV\n",
    "aug_citi_data = \"data/JC-201908-citibike-tripdata.csv\"\n",
    "\n",
    "# Reading CSV into a DF\n",
    "aug_df = pd.read_csv(aug_citi_data)\n",
    "aug_df.dropna(inplace = True)\n",
    "\n",
    "# Splitting the 'starttime' column to have access to more data\n",
    "new = aug_df[\"starttime\"].str.split(\" \", n = 1, expand = True) \n",
    "new2 = aug_df[\"stoptime\"].str.split(\" \", n = 1, expand = True) \n",
    "\n",
    "# Creating new columns and assigning those columns data\n",
    "aug_df[\"start date\"]= new[0] \n",
    "aug_df[\"end date\"]= new2[0]\n",
    "aug_df[\"start time\"]= new[1] \n",
    "aug_df[\"end time\"]= new2[1]\n",
    "\n",
    "# Dropping the previous column\n",
    "aug_df.drop(columns =[\"starttime\"], inplace = True)\n",
    "aug_df.drop(columns =[\"stoptime\"], inplace = True)\n",
    "\n",
    "aug_df.to_csv('data/cleaned/aug_JC_data.csv')\n",
    "aug_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>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",
       "      <th>start date</th>\n",
       "      <th>end date</th>\n",
       "      <th>start time</th>\n",
       "      <th>end time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>145</td>\n",
       "      <td>3640</td>\n",
       "      <td>Journal Square</td>\n",
       "      <td>40.733670</td>\n",
       "      <td>-74.062500</td>\n",
       "      <td>3206</td>\n",
       "      <td>Hilltop</td>\n",
       "      <td>40.731169</td>\n",
       "      <td>-74.057574</td>\n",
       "      <td>29303</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1991</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-09-01</td>\n",
       "      <td>2019-09-01</td>\n",
       "      <td>00:00:37.6920</td>\n",
       "      <td>00:03:03.0100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>212</td>\n",
       "      <td>3194</td>\n",
       "      <td>McGinley Square</td>\n",
       "      <td>40.725340</td>\n",
       "      <td>-74.067622</td>\n",
       "      <td>3679</td>\n",
       "      <td>Bergen Ave</td>\n",
       "      <td>40.722104</td>\n",
       "      <td>-74.071455</td>\n",
       "      <td>29297</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1993</td>\n",
       "      <td>2</td>\n",
       "      <td>2019-09-01</td>\n",
       "      <td>2019-09-01</td>\n",
       "      <td>00:03:00.6000</td>\n",
       "      <td>00:06:33.3420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>569</td>\n",
       "      <td>3214</td>\n",
       "      <td>Essex Light Rail</td>\n",
       "      <td>40.712774</td>\n",
       "      <td>-74.036486</td>\n",
       "      <td>3184</td>\n",
       "      <td>Paulus Hook</td>\n",
       "      <td>40.714145</td>\n",
       "      <td>-74.033552</td>\n",
       "      <td>29435</td>\n",
       "      <td>Customer</td>\n",
       "      <td>1977</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-09-01</td>\n",
       "      <td>2019-09-01</td>\n",
       "      <td>00:07:13.0020</td>\n",
       "      <td>00:16:42.8610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1380</td>\n",
       "      <td>3214</td>\n",
       "      <td>Essex Light Rail</td>\n",
       "      <td>40.712774</td>\n",
       "      <td>-74.036486</td>\n",
       "      <td>3792</td>\n",
       "      <td>Columbus Dr at Exchange Pl</td>\n",
       "      <td>40.716870</td>\n",
       "      <td>-74.032810</td>\n",
       "      <td>29509</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1965</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-09-01</td>\n",
       "      <td>2019-09-01</td>\n",
       "      <td>00:07:25.3350</td>\n",
       "      <td>00:30:26.1640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1346</td>\n",
       "      <td>3214</td>\n",
       "      <td>Essex Light Rail</td>\n",
       "      <td>40.712774</td>\n",
       "      <td>-74.036486</td>\n",
       "      <td>3792</td>\n",
       "      <td>Columbus Dr at Exchange Pl</td>\n",
       "      <td>40.716870</td>\n",
       "      <td>-74.032810</td>\n",
       "      <td>29226</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1968</td>\n",
       "      <td>2</td>\n",
       "      <td>2019-09-01</td>\n",
       "      <td>2019-09-01</td>\n",
       "      <td>00:07:56.4670</td>\n",
       "      <td>00:30:22.5440</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   tripduration  start station id start station name  start station latitude  \\\n",
       "0           145              3640     Journal Square               40.733670   \n",
       "1           212              3194    McGinley Square               40.725340   \n",
       "2           569              3214   Essex Light Rail               40.712774   \n",
       "3          1380              3214   Essex Light Rail               40.712774   \n",
       "4          1346              3214   Essex Light Rail               40.712774   \n",
       "\n",
       "   start station longitude  end station id            end station name  \\\n",
       "0               -74.062500            3206                     Hilltop   \n",
       "1               -74.067622            3679                  Bergen Ave   \n",
       "2               -74.036486            3184                 Paulus Hook   \n",
       "3               -74.036486            3792  Columbus Dr at Exchange Pl   \n",
       "4               -74.036486            3792  Columbus Dr at Exchange Pl   \n",
       "\n",
       "   end station latitude  end station longitude  bikeid    usertype  \\\n",
       "0             40.731169             -74.057574   29303  Subscriber   \n",
       "1             40.722104             -74.071455   29297  Subscriber   \n",
       "2             40.714145             -74.033552   29435    Customer   \n",
       "3             40.716870             -74.032810   29509  Subscriber   \n",
       "4             40.716870             -74.032810   29226  Subscriber   \n",
       "\n",
       "   birth year  gender  start date    end date     start time       end time  \n",
       "0        1991       1  2019-09-01  2019-09-01  00:00:37.6920  00:03:03.0100  \n",
       "1        1993       2  2019-09-01  2019-09-01  00:03:00.6000  00:06:33.3420  \n",
       "2        1977       1  2019-09-01  2019-09-01  00:07:13.0020  00:16:42.8610  \n",
       "3        1965       1  2019-09-01  2019-09-01  00:07:25.3350  00:30:26.1640  \n",
       "4        1968       2  2019-09-01  2019-09-01  00:07:56.4670  00:30:22.5440  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Loading CSV\n",
    "sept_citi_data = \"data/JC-201909-citibike-tripdata.csv\"\n",
    "\n",
    "# Reading CSV into a DF\n",
    "sept_df = pd.read_csv(sept_citi_data)\n",
    "sept_df.dropna(inplace = True)\n",
    "\n",
    "# Splitting the 'starttime' column to have access to more data\n",
    "new = sept_df[\"starttime\"].str.split(\" \", n = 1, expand = True) \n",
    "new2 = sept_df[\"stoptime\"].str.split(\" \", n = 1, expand = True) \n",
    "\n",
    "# Creating new columns and assigning those columns data\n",
    "sept_df[\"start date\"]= new[0] \n",
    "sept_df[\"end date\"]= new2[0]\n",
    "sept_df[\"start time\"]= new[1] \n",
    "sept_df[\"end time\"]= new2[1]\n",
    "\n",
    "# Dropping the previous column\n",
    "sept_df.drop(columns =[\"starttime\"], inplace = True)\n",
    "sept_df.drop(columns =[\"stoptime\"], inplace = True)\n",
    "\n",
    "sept_df.to_csv('data/cleaned/sept_JC_data.csv')\n",
    "sept_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>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",
       "      <th>start date</th>\n",
       "      <th>end date</th>\n",
       "      <th>start time</th>\n",
       "      <th>end time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>892</td>\n",
       "      <td>3275</td>\n",
       "      <td>Columbus Drive</td>\n",
       "      <td>40.718355</td>\n",
       "      <td>-74.038914</td>\n",
       "      <td>3280</td>\n",
       "      <td>Astor Place</td>\n",
       "      <td>40.719282</td>\n",
       "      <td>-74.071262</td>\n",
       "      <td>29544</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1976</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-10-01</td>\n",
       "      <td>2019-10-01</td>\n",
       "      <td>00:20:05.0140</td>\n",
       "      <td>00:34:57.3800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>374</td>\n",
       "      <td>3211</td>\n",
       "      <td>Newark Ave</td>\n",
       "      <td>40.721525</td>\n",
       "      <td>-74.046305</td>\n",
       "      <td>3791</td>\n",
       "      <td>Hoboken Ave at Monmouth St</td>\n",
       "      <td>40.735208</td>\n",
       "      <td>-74.046964</td>\n",
       "      <td>29536</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1984</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-10-01</td>\n",
       "      <td>2019-10-01</td>\n",
       "      <td>00:43:48.8790</td>\n",
       "      <td>00:50:03.8190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>170</td>\n",
       "      <td>3194</td>\n",
       "      <td>McGinley Square</td>\n",
       "      <td>40.725340</td>\n",
       "      <td>-74.067622</td>\n",
       "      <td>3679</td>\n",
       "      <td>Bergen Ave</td>\n",
       "      <td>40.722104</td>\n",
       "      <td>-74.071455</td>\n",
       "      <td>26304</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1986</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-10-01</td>\n",
       "      <td>2019-10-01</td>\n",
       "      <td>01:35:51.8630</td>\n",
       "      <td>01:38:42.5470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>946</td>\n",
       "      <td>3272</td>\n",
       "      <td>Jersey &amp; 3rd</td>\n",
       "      <td>40.723332</td>\n",
       "      <td>-74.045953</td>\n",
       "      <td>3679</td>\n",
       "      <td>Bergen Ave</td>\n",
       "      <td>40.722104</td>\n",
       "      <td>-74.071455</td>\n",
       "      <td>29496</td>\n",
       "      <td>Customer</td>\n",
       "      <td>1969</td>\n",
       "      <td>0</td>\n",
       "      <td>2019-10-01</td>\n",
       "      <td>2019-10-01</td>\n",
       "      <td>02:55:53.4000</td>\n",
       "      <td>03:11:40.2710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>517</td>\n",
       "      <td>3206</td>\n",
       "      <td>Hilltop</td>\n",
       "      <td>40.731169</td>\n",
       "      <td>-74.057574</td>\n",
       "      <td>3210</td>\n",
       "      <td>Pershing Field</td>\n",
       "      <td>40.742677</td>\n",
       "      <td>-74.051789</td>\n",
       "      <td>26205</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1969</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-10-01</td>\n",
       "      <td>2019-10-01</td>\n",
       "      <td>03:10:16.1290</td>\n",
       "      <td>03:18:53.6350</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   tripduration  start station id start station name  start station latitude  \\\n",
       "0           892              3275     Columbus Drive               40.718355   \n",
       "1           374              3211         Newark Ave               40.721525   \n",
       "2           170              3194    McGinley Square               40.725340   \n",
       "3           946              3272       Jersey & 3rd               40.723332   \n",
       "4           517              3206            Hilltop               40.731169   \n",
       "\n",
       "   start station longitude  end station id            end station name  \\\n",
       "0               -74.038914            3280                 Astor Place   \n",
       "1               -74.046305            3791  Hoboken Ave at Monmouth St   \n",
       "2               -74.067622            3679                  Bergen Ave   \n",
       "3               -74.045953            3679                  Bergen Ave   \n",
       "4               -74.057574            3210              Pershing Field   \n",
       "\n",
       "   end station latitude  end station longitude  bikeid    usertype  \\\n",
       "0             40.719282             -74.071262   29544  Subscriber   \n",
       "1             40.735208             -74.046964   29536  Subscriber   \n",
       "2             40.722104             -74.071455   26304  Subscriber   \n",
       "3             40.722104             -74.071455   29496    Customer   \n",
       "4             40.742677             -74.051789   26205  Subscriber   \n",
       "\n",
       "   birth year  gender  start date    end date     start time       end time  \n",
       "0        1976       1  2019-10-01  2019-10-01  00:20:05.0140  00:34:57.3800  \n",
       "1        1984       1  2019-10-01  2019-10-01  00:43:48.8790  00:50:03.8190  \n",
       "2        1986       1  2019-10-01  2019-10-01  01:35:51.8630  01:38:42.5470  \n",
       "3        1969       0  2019-10-01  2019-10-01  02:55:53.4000  03:11:40.2710  \n",
       "4        1969       1  2019-10-01  2019-10-01  03:10:16.1290  03:18:53.6350  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Loading CSV\n",
    "oct_citi_data = \"data/JC-201910-citibike-tripdata.csv\"\n",
    "\n",
    "# Reading CSV into a DF\n",
    "oct_df = pd.read_csv(oct_citi_data)\n",
    "oct_df.dropna(inplace = True)\n",
    "\n",
    "# Splitting the 'starttime' column to have access to more data\n",
    "new = oct_df[\"starttime\"].str.split(\" \", n = 1, expand = True) \n",
    "new2 = oct_df[\"stoptime\"].str.split(\" \", n = 1, expand = True) \n",
    "\n",
    "# Creating new columns and assigning those columns data\n",
    "oct_df[\"start date\"]= new[0] \n",
    "oct_df[\"end date\"]= new2[0]\n",
    "oct_df[\"start time\"]= new[1] \n",
    "oct_df[\"end time\"]= new2[1]\n",
    "\n",
    "# Dropping the previous column\n",
    "oct_df.drop(columns =[\"starttime\"], inplace = True)\n",
    "oct_df.drop(columns =[\"stoptime\"], inplace = True)\n",
    "\n",
    "oct_df.to_csv('data/cleaned/oct_JC_data.csv')\n",
    "oct_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>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",
       "      <th>start date</th>\n",
       "      <th>end date</th>\n",
       "      <th>start time</th>\n",
       "      <th>end time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>260</td>\n",
       "      <td>3186</td>\n",
       "      <td>Grove St PATH</td>\n",
       "      <td>40.719586</td>\n",
       "      <td>-74.043117</td>\n",
       "      <td>3203</td>\n",
       "      <td>Hamilton Park</td>\n",
       "      <td>40.727596</td>\n",
       "      <td>-74.044247</td>\n",
       "      <td>26314</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1964</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>00:02:53.8860</td>\n",
       "      <td>00:07:14.6450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>285</td>\n",
       "      <td>3206</td>\n",
       "      <td>Hilltop</td>\n",
       "      <td>40.731169</td>\n",
       "      <td>-74.057574</td>\n",
       "      <td>3212</td>\n",
       "      <td>Christ Hospital</td>\n",
       "      <td>40.734786</td>\n",
       "      <td>-74.050444</td>\n",
       "      <td>26238</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1986</td>\n",
       "      <td>2</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>00:05:38.6360</td>\n",
       "      <td>00:10:24.1930</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>501</td>\n",
       "      <td>3186</td>\n",
       "      <td>Grove St PATH</td>\n",
       "      <td>40.719586</td>\n",
       "      <td>-74.043117</td>\n",
       "      <td>3192</td>\n",
       "      <td>Liberty Light Rail</td>\n",
       "      <td>40.711242</td>\n",
       "      <td>-74.055701</td>\n",
       "      <td>29645</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1995</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>00:05:43.6310</td>\n",
       "      <td>00:14:05.4810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>556</td>\n",
       "      <td>3209</td>\n",
       "      <td>Brunswick St</td>\n",
       "      <td>40.724176</td>\n",
       "      <td>-74.050656</td>\n",
       "      <td>3678</td>\n",
       "      <td>Fairmount Ave</td>\n",
       "      <td>40.725726</td>\n",
       "      <td>-74.071959</td>\n",
       "      <td>29221</td>\n",
       "      <td>Customer</td>\n",
       "      <td>1992</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>00:07:57.0550</td>\n",
       "      <td>00:17:13.9010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>321</td>\n",
       "      <td>3273</td>\n",
       "      <td>Manila &amp; 1st</td>\n",
       "      <td>40.721651</td>\n",
       "      <td>-74.042884</td>\n",
       "      <td>3273</td>\n",
       "      <td>Manila &amp; 1st</td>\n",
       "      <td>40.721651</td>\n",
       "      <td>-74.042884</td>\n",
       "      <td>29591</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1988</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>00:11:44.5660</td>\n",
       "      <td>00:17:05.5930</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   tripduration  start station id start station name  start station latitude  \\\n",
       "0           260              3186      Grove St PATH               40.719586   \n",
       "1           285              3206            Hilltop               40.731169   \n",
       "2           501              3186      Grove St PATH               40.719586   \n",
       "3           556              3209       Brunswick St               40.724176   \n",
       "4           321              3273       Manila & 1st               40.721651   \n",
       "\n",
       "   start station longitude  end station id    end station name  \\\n",
       "0               -74.043117            3203       Hamilton Park   \n",
       "1               -74.057574            3212     Christ Hospital   \n",
       "2               -74.043117            3192  Liberty Light Rail   \n",
       "3               -74.050656            3678       Fairmount Ave   \n",
       "4               -74.042884            3273        Manila & 1st   \n",
       "\n",
       "   end station latitude  end station longitude  bikeid    usertype  \\\n",
       "0             40.727596             -74.044247   26314  Subscriber   \n",
       "1             40.734786             -74.050444   26238  Subscriber   \n",
       "2             40.711242             -74.055701   29645  Subscriber   \n",
       "3             40.725726             -74.071959   29221    Customer   \n",
       "4             40.721651             -74.042884   29591  Subscriber   \n",
       "\n",
       "   birth year  gender  start date    end date     start time       end time  \n",
       "0        1964       1  2019-11-01  2019-11-01  00:02:53.8860  00:07:14.6450  \n",
       "1        1986       2  2019-11-01  2019-11-01  00:05:38.6360  00:10:24.1930  \n",
       "2        1995       1  2019-11-01  2019-11-01  00:05:43.6310  00:14:05.4810  \n",
       "3        1992       1  2019-11-01  2019-11-01  00:07:57.0550  00:17:13.9010  \n",
       "4        1988       1  2019-11-01  2019-11-01  00:11:44.5660  00:17:05.5930  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Loading CSV\n",
    "nov_citi_data = \"data/JC-201911-citibike-tripdata.csv\"\n",
    "\n",
    "# Reading CSV into a DF\n",
    "nov_df = pd.read_csv(nov_citi_data)\n",
    "nov_df.dropna(inplace = True)\n",
    "\n",
    "# Splitting the 'starttime' column to have access to more data\n",
    "new = nov_df[\"starttime\"].str.split(\" \", n = 1, expand = True) \n",
    "new2 = nov_df[\"stoptime\"].str.split(\" \", n = 1, expand = True) \n",
    "\n",
    "# Creating new columns and assigning those columns data\n",
    "nov_df[\"start date\"]= new[0] \n",
    "nov_df[\"end date\"]= new2[0]\n",
    "nov_df[\"start time\"]= new[1] \n",
    "nov_df[\"end time\"]= new2[1]\n",
    "\n",
    "# Dropping the previous column\n",
    "nov_df.drop(columns =[\"starttime\"], inplace = True)\n",
    "nov_df.drop(columns =[\"stoptime\"], inplace = True)\n",
    "\n",
    "nov_df.to_csv('data/cleaned/nov_JC_data.csv')\n",
    "nov_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>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",
       "      <th>start date</th>\n",
       "      <th>end date</th>\n",
       "      <th>start time</th>\n",
       "      <th>end time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1553</td>\n",
       "      <td>3681</td>\n",
       "      <td>Grand St</td>\n",
       "      <td>40.715178</td>\n",
       "      <td>-74.037683</td>\n",
       "      <td>3198</td>\n",
       "      <td>Heights Elevator</td>\n",
       "      <td>40.748716</td>\n",
       "      <td>-74.040443</td>\n",
       "      <td>29462</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1980</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-12-01</td>\n",
       "      <td>2019-12-01</td>\n",
       "      <td>00:07:13.9360</td>\n",
       "      <td>00:33:07.6820</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>416</td>\n",
       "      <td>3195</td>\n",
       "      <td>Sip Ave</td>\n",
       "      <td>40.730897</td>\n",
       "      <td>-74.063913</td>\n",
       "      <td>3679</td>\n",
       "      <td>Bergen Ave</td>\n",
       "      <td>40.722104</td>\n",
       "      <td>-74.071455</td>\n",
       "      <td>29610</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1956</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-12-01</td>\n",
       "      <td>2019-12-01</td>\n",
       "      <td>00:16:40.4700</td>\n",
       "      <td>00:23:36.5700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>294</td>\n",
       "      <td>3195</td>\n",
       "      <td>Sip Ave</td>\n",
       "      <td>40.730897</td>\n",
       "      <td>-74.063913</td>\n",
       "      <td>3678</td>\n",
       "      <td>Fairmount Ave</td>\n",
       "      <td>40.725726</td>\n",
       "      <td>-74.071959</td>\n",
       "      <td>26166</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1977</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-12-01</td>\n",
       "      <td>2019-12-01</td>\n",
       "      <td>00:20:29.7980</td>\n",
       "      <td>00:25:23.9690</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>97</td>\n",
       "      <td>3202</td>\n",
       "      <td>Newport PATH</td>\n",
       "      <td>40.727224</td>\n",
       "      <td>-74.033759</td>\n",
       "      <td>3638</td>\n",
       "      <td>Washington St</td>\n",
       "      <td>40.724294</td>\n",
       "      <td>-74.035483</td>\n",
       "      <td>29492</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>1993</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-12-01</td>\n",
       "      <td>2019-12-01</td>\n",
       "      <td>00:21:13.7580</td>\n",
       "      <td>00:22:51.5970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>286</td>\n",
       "      <td>3195</td>\n",
       "      <td>Sip Ave</td>\n",
       "      <td>40.730897</td>\n",
       "      <td>-74.063913</td>\n",
       "      <td>3679</td>\n",
       "      <td>Bergen Ave</td>\n",
       "      <td>40.722104</td>\n",
       "      <td>-74.071455</td>\n",
       "      <td>29440</td>\n",
       "      <td>Customer</td>\n",
       "      <td>1990</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-12-01</td>\n",
       "      <td>2019-12-01</td>\n",
       "      <td>00:29:58.0230</td>\n",
       "      <td>00:34:44.2280</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   tripduration  start station id start station name  start station latitude  \\\n",
       "0          1553              3681           Grand St               40.715178   \n",
       "1           416              3195            Sip Ave               40.730897   \n",
       "2           294              3195            Sip Ave               40.730897   \n",
       "3            97              3202       Newport PATH               40.727224   \n",
       "4           286              3195            Sip Ave               40.730897   \n",
       "\n",
       "   start station longitude  end station id  end station name  \\\n",
       "0               -74.037683            3198  Heights Elevator   \n",
       "1               -74.063913            3679        Bergen Ave   \n",
       "2               -74.063913            3678     Fairmount Ave   \n",
       "3               -74.033759            3638     Washington St   \n",
       "4               -74.063913            3679        Bergen Ave   \n",
       "\n",
       "   end station latitude  end station longitude  bikeid    usertype  \\\n",
       "0             40.748716             -74.040443   29462  Subscriber   \n",
       "1             40.722104             -74.071455   29610  Subscriber   \n",
       "2             40.725726             -74.071959   26166  Subscriber   \n",
       "3             40.724294             -74.035483   29492  Subscriber   \n",
       "4             40.722104             -74.071455   29440    Customer   \n",
       "\n",
       "   birth year  gender  start date    end date     start time       end time  \n",
       "0        1980       1  2019-12-01  2019-12-01  00:07:13.9360  00:33:07.6820  \n",
       "1        1956       1  2019-12-01  2019-12-01  00:16:40.4700  00:23:36.5700  \n",
       "2        1977       1  2019-12-01  2019-12-01  00:20:29.7980  00:25:23.9690  \n",
       "3        1993       1  2019-12-01  2019-12-01  00:21:13.7580  00:22:51.5970  \n",
       "4        1990       1  2019-12-01  2019-12-01  00:29:58.0230  00:34:44.2280  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Loading CSV\n",
    "dec_citi_data = \"data/JC-201912-citibike-tripdata.csv\"\n",
    "\n",
    "# Reading CSV into a DF\n",
    "dec_df = pd.read_csv(dec_citi_data)\n",
    "dec_df.dropna(inplace = True)\n",
    "\n",
    "# Splitting the 'starttime' column to have access to more data\n",
    "new = dec_df[\"starttime\"].str.split(\" \", n = 1, expand = True) \n",
    "new2 = dec_df[\"stoptime\"].str.split(\" \", n = 1, expand = True) \n",
    "\n",
    "# Creating new columns and assigning those columns data\n",
    "dec_df[\"start date\"]= new[0] \n",
    "dec_df[\"end date\"]= new2[0]\n",
    "dec_df[\"start time\"]= new[1] \n",
    "dec_df[\"end time\"]= new2[1]\n",
    "\n",
    "# Dropping the previous column\n",
    "dec_df.drop(columns =[\"starttime\"], inplace = True)\n",
    "dec_df.drop(columns =[\"stoptime\"], inplace = True)\n",
    "\n",
    "dec_df.to_csv('data/cleaned/dec_JC_data.csv')\n",
    "dec_df.head()"
   ]
  },
  {
   "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.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}