Top 30 Zip Codes.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Zip Codes\n",
       "10002    4\n",
       "10003    4\n",
       "10009    4\n",
       "10011    4\n",
       "10012    4\n",
       "10013    1\n",
       "10014    4\n",
       "10016    4\n",
       "10019    4\n",
       "10023    4\n",
       "10024    3\n",
       "10025    4\n",
       "10027    4\n",
       "10029    4\n",
       "10031    4\n",
       "10032    1\n",
       "10036    4\n",
       "10128    1\n",
       "11201    3\n",
       "11205    4\n",
       "11206    4\n",
       "11211    4\n",
       "11213    1\n",
       "11215    4\n",
       "11216    4\n",
       "11217    4\n",
       "11221    4\n",
       "11222    4\n",
       "11225    3\n",
       "11226    4\n",
       "11233    3\n",
       "11237    4\n",
       "11238    4\n",
       "11249    4\n",
       "Name: Zip Codes, dtype: int64"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd \n",
    "\n",
    "#Import csv files generated by each group member\n",
    "file_2015 = \"2015_Top30zipcodes.csv\"\n",
    "file_2016 = \"2016_Top30zipcodes.csv\"\n",
    "file_2017 = \"2017_Top30codes\"\n",
    "file_2018 = \"2018_Top30zipcodes.csv\"\n",
    "\n",
    "#read each csv file\n",
    "df1 = pd.read_csv(file_2015)\n",
    "df2 = pd.read_csv(file_2016)\n",
    "df3 = pd.read_csv(file_2017)\n",
    "df4 = pd.read_csv(file_2018)\n",
    "\n",
    "#concatenate all of the csv files into one csv file\n",
    "merge = pd.concat([df1[\"Zip Code\"],df2[\"Zip Code\"],df3[\"Zip Code\"],df4[\"zipcode\"]],ignore_index=True)\n",
    "#merge and convert to dataframe\n",
    "convert = merge.to_frame()\n",
    "\n",
    "#create final df and con\n",
    "final_df = convert.rename(index=str, columns={0: \"Zip Codes\"})\n",
    "final_df.to_csv(\"consolidated.csv\", sep=\",\")\n",
    "zipcodes = final_df.groupby([\"Zip Codes\"])[\"Zip Codes\"].count()\n",
    "zipcodes\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Count</th>\n",
       "      <th>Zip Codes</th>\n",
       "      <th>Borough</th>\n",
       "      <th>Neighborhood</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4</td>\n",
       "      <td>11206</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Bushwick and Williamsburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4</td>\n",
       "      <td>11221</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Bushwick and Williamsburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4</td>\n",
       "      <td>11237</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Bushwick and Williamsburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>11216</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Central Brooklyn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3</td>\n",
       "      <td>11233</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Central Brooklyn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>4</td>\n",
       "      <td>11238</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Central Brooklyn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>4</td>\n",
       "      <td>10027</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Central Harlem</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4</td>\n",
       "      <td>10011</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Chelsea and Clinton</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>4</td>\n",
       "      <td>10019</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Chelsea and Clinton</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>4</td>\n",
       "      <td>10036</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Chelsea and Clinton</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>4</td>\n",
       "      <td>10029</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>East Harlem</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>3</td>\n",
       "      <td>11225</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Flatbush</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>4</td>\n",
       "      <td>11226</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Flatbush</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>4</td>\n",
       "      <td>10016</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Gramercy Park and Murray Hill</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>4</td>\n",
       "      <td>11211</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>4</td>\n",
       "      <td>11222</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>4</td>\n",
       "      <td>10012</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Greenwich Village and Soho</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>4</td>\n",
       "      <td>10014</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Greenwich Village and Soho</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>4</td>\n",
       "      <td>10031</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Inwood and Washington Heights</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>4</td>\n",
       "      <td>10002</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Lower East Side</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>4</td>\n",
       "      <td>10003</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Lower East Side</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>4</td>\n",
       "      <td>10009</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Lower East Side</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>3</td>\n",
       "      <td>11201</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Northwest Brooklyn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>4</td>\n",
       "      <td>11205</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Northwest Brooklyn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>4</td>\n",
       "      <td>11215</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Northwest Brooklyn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>4</td>\n",
       "      <td>11217</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Northwest Brooklyn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>4</td>\n",
       "      <td>10023</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>3</td>\n",
       "      <td>10024</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>4</td>\n",
       "      <td>10025</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Count  Zip Codes    Borough                   Neighborhood\n",
       "0       4      11206   Brooklyn      Bushwick and Williamsburg\n",
       "1       4      11221   Brooklyn      Bushwick and Williamsburg\n",
       "2       4      11237   Brooklyn      Bushwick and Williamsburg\n",
       "3       4      11216   Brooklyn               Central Brooklyn\n",
       "4       3      11233   Brooklyn               Central Brooklyn\n",
       "5       4      11238   Brooklyn               Central Brooklyn\n",
       "6       4      10027  Manhattan                 Central Harlem\n",
       "7       4      10011  Manhattan            Chelsea and Clinton\n",
       "8       4      10019  Manhattan            Chelsea and Clinton\n",
       "9       4      10036  Manhattan            Chelsea and Clinton\n",
       "10      4      10029  Manhattan                    East Harlem\n",
       "11      3      11225   Brooklyn                       Flatbush\n",
       "12      4      11226   Brooklyn                       Flatbush\n",
       "13      4      10016  Manhattan  Gramercy Park and Murray Hill\n",
       "14      4      11211   Brooklyn                     Greenpoint\n",
       "15      4      11222   Brooklyn                     Greenpoint\n",
       "16      4      10012  Manhattan     Greenwich Village and Soho\n",
       "17      4      10014  Manhattan     Greenwich Village and Soho\n",
       "18      4      10031  Manhattan  Inwood and Washington Heights\n",
       "19      4      10002  Manhattan                Lower East Side\n",
       "20      4      10003  Manhattan                Lower East Side\n",
       "21      4      10009  Manhattan                Lower East Side\n",
       "22      3      11201   Brooklyn             Northwest Brooklyn\n",
       "23      4      11205   Brooklyn             Northwest Brooklyn\n",
       "24      4      11215   Brooklyn             Northwest Brooklyn\n",
       "25      4      11217   Brooklyn             Northwest Brooklyn\n",
       "26      4      10023  Manhattan                Upper West Side\n",
       "27      3      10024  Manhattan                Upper West Side\n",
       "28      4      10025  Manhattan                Upper West Side"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#consolidated3.csv is a csv containing the ouput from the previous code with 'Borough' and 'Neighborhood information' (See https://www.health.ny.gov/statistics/cancer/registry/appendix/neighborhoods.htm) that was externally added\n",
    "consoldf = pd.read_csv(\"consolidated3.csv\")\n",
    "consoldf"
   ]
  },
  {
   "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.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}