Citibike_data_merged.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "Q1_2017 = pd.read_csv(\"Citibike_data/2017Q1.csv\")\n",
    "Q2_2017 = pd.read_csv(\"Citibike_data/2017Q2.csv\")\n",
    "Q3_2017 = pd.read_csv(\"Citibike_data/2017Q3.csv\")\n",
    "Q4_2017 = pd.read_csv(\"Citibike_data/2017Q4.csv\")"
   ]
  },
  {
   "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>Date</th>\n",
       "      <th>Trips over the past 24-hours (midnight to 11:59pm)</th>\n",
       "      <th>Miles traveled today (midnight to 11:59 pm)</th>\n",
       "      <th>Total Annual Members (All Time)</th>\n",
       "      <th>24-Hour Passes Purchased (midnight to 11:59 pm)</th>\n",
       "      <th>3-Day Passes Purchased (midnight to 11:59 pm)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1/1/17</td>\n",
       "      <td>16009</td>\n",
       "      <td>50761</td>\n",
       "      <td>206624</td>\n",
       "      <td>1237</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1/2/17</td>\n",
       "      <td>8921</td>\n",
       "      <td>21545</td>\n",
       "      <td>206675</td>\n",
       "      <td>142</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1/3/17</td>\n",
       "      <td>14198</td>\n",
       "      <td>25879</td>\n",
       "      <td>206728</td>\n",
       "      <td>42</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1/4/17</td>\n",
       "      <td>34039</td>\n",
       "      <td>69966</td>\n",
       "      <td>206778</td>\n",
       "      <td>475</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1/5/17</td>\n",
       "      <td>28393</td>\n",
       "      <td>52446</td>\n",
       "      <td>206845</td>\n",
       "      <td>214</td>\n",
       "      <td>17</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>360</th>\n",
       "      <td>12/27/17</td>\n",
       "      <td>16365</td>\n",
       "      <td>31793</td>\n",
       "      <td>253346</td>\n",
       "      <td>234</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>361</th>\n",
       "      <td>12/28/17</td>\n",
       "      <td>13419</td>\n",
       "      <td>34438</td>\n",
       "      <td>253365</td>\n",
       "      <td>121</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <td>12/29/17</td>\n",
       "      <td>13759</td>\n",
       "      <td>29284</td>\n",
       "      <td>253395</td>\n",
       "      <td>177</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>363</th>\n",
       "      <td>12/30/17</td>\n",
       "      <td>5956</td>\n",
       "      <td>13910</td>\n",
       "      <td>253407</td>\n",
       "      <td>53</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364</th>\n",
       "      <td>12/31/17</td>\n",
       "      <td>6569</td>\n",
       "      <td>18326</td>\n",
       "      <td>253443</td>\n",
       "      <td>94</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>365 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         Date  Trips over the past 24-hours (midnight to 11:59pm)  \\\n",
       "0      1/1/17                                              16009    \n",
       "1      1/2/17                                               8921    \n",
       "2      1/3/17                                              14198    \n",
       "3      1/4/17                                              34039    \n",
       "4      1/5/17                                              28393    \n",
       "..        ...                                                ...    \n",
       "360  12/27/17                                              16365    \n",
       "361  12/28/17                                              13419    \n",
       "362  12/29/17                                              13759    \n",
       "363  12/30/17                                               5956    \n",
       "364  12/31/17                                               6569    \n",
       "\n",
       "     Miles traveled today (midnight to 11:59 pm)  \\\n",
       "0                                          50761   \n",
       "1                                          21545   \n",
       "2                                          25879   \n",
       "3                                          69966   \n",
       "4                                          52446   \n",
       "..                                           ...   \n",
       "360                                        31793   \n",
       "361                                        34438   \n",
       "362                                        29284   \n",
       "363                                        13910   \n",
       "364                                        18326   \n",
       "\n",
       "     Total Annual Members (All Time)  \\\n",
       "0                             206624   \n",
       "1                             206675   \n",
       "2                             206728   \n",
       "3                             206778   \n",
       "4                             206845   \n",
       "..                               ...   \n",
       "360                           253346   \n",
       "361                           253365   \n",
       "362                           253395   \n",
       "363                           253407   \n",
       "364                           253443   \n",
       "\n",
       "     24-Hour Passes Purchased (midnight to 11:59 pm)  \\\n",
       "0                                               1237   \n",
       "1                                                142   \n",
       "2                                                 42   \n",
       "3                                                475   \n",
       "4                                                214   \n",
       "..                                               ...   \n",
       "360                                              234   \n",
       "361                                              121   \n",
       "362                                              177   \n",
       "363                                               53   \n",
       "364                                               94   \n",
       "\n",
       "     3-Day Passes Purchased (midnight to 11:59 pm)  \n",
       "0                                               33  \n",
       "1                                               15  \n",
       "2                                               15  \n",
       "3                                               29  \n",
       "4                                               17  \n",
       "..                                             ...  \n",
       "360                                             33  \n",
       "361                                             17  \n",
       "362                                             17  \n",
       "363                                             10  \n",
       "364                                              2  \n",
       "\n",
       "[365 rows x 6 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataframes = [Q1_2017, Q2_2017, Q3_2017, Q4_2017]\n",
    "merged_citibike = pd.concat(dataframes)\n",
    "merged_citibike = merged_citibike.reset_index(drop = True)\n",
    "merged_citibike.to_csv(\"Citibike_data/merged_citibike.csv\")\n",
    "merged_citibike\n"
   ]
  },
  {
   "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.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}