NYC_CitiBike_Challenge.ipynb

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