us_epa_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Dependancies\n",
    "import pandas as pd\n",
    "import shutil\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_1995.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_1996.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_1997.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_1998.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_1999.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_2000.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_2001.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_2002.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_2003.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_2004.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_2005.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_2006.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_2007.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_2008.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_2009.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_2010.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_2011.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_2012.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_2013.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_2014.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_2015.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_2016.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_2017.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_2018.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_2019.zip\n",
      "-------------------------------------\n",
      "Loading file Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_2020.zip\n",
      "-------------------------------------\n"
     ]
    },
    {
     "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>State Code</th>\n",
       "      <th>County Code</th>\n",
       "      <th>Site Num</th>\n",
       "      <th>Parameter Code</th>\n",
       "      <th>POC</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Datum</th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Sample Duration</th>\n",
       "      <th>...</th>\n",
       "      <th>75th Percentile</th>\n",
       "      <th>50th Percentile</th>\n",
       "      <th>10th Percentile</th>\n",
       "      <th>Local Site Name</th>\n",
       "      <th>Address</th>\n",
       "      <th>State Name</th>\n",
       "      <th>County Name</th>\n",
       "      <th>City Name</th>\n",
       "      <th>CBSA Name</th>\n",
       "      <th>Date of Last Change</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>01</td>\n",
       "      <td>015</td>\n",
       "      <td>0001</td>\n",
       "      <td>81102</td>\n",
       "      <td>1</td>\n",
       "      <td>33.656771</td>\n",
       "      <td>-85.824409</td>\n",
       "      <td>WGS84</td>\n",
       "      <td>PM10 Total 0-10um STP</td>\n",
       "      <td>24 HOUR</td>\n",
       "      <td>...</td>\n",
       "      <td>27</td>\n",
       "      <td>21</td>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>309 EAST 8TH STREET</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Calhoun</td>\n",
       "      <td>Anniston</td>\n",
       "      <td>Anniston-Oxford-Jacksonville, AL</td>\n",
       "      <td>2020-05-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>01</td>\n",
       "      <td>027</td>\n",
       "      <td>0001</td>\n",
       "      <td>44201</td>\n",
       "      <td>1</td>\n",
       "      <td>33.284928</td>\n",
       "      <td>-85.803608</td>\n",
       "      <td>NAD83</td>\n",
       "      <td>Ozone</td>\n",
       "      <td>1 HOUR</td>\n",
       "      <td>...</td>\n",
       "      <td>0.067</td>\n",
       "      <td>0.056</td>\n",
       "      <td>0.037</td>\n",
       "      <td>ASHLAND</td>\n",
       "      <td>ASHLAND AIRPORT</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Clay</td>\n",
       "      <td>Ashland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-05-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>01</td>\n",
       "      <td>027</td>\n",
       "      <td>0001</td>\n",
       "      <td>44201</td>\n",
       "      <td>1</td>\n",
       "      <td>33.284928</td>\n",
       "      <td>-85.803608</td>\n",
       "      <td>NAD83</td>\n",
       "      <td>Ozone</td>\n",
       "      <td>8-HR RUN AVG BEGIN HOUR</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061</td>\n",
       "      <td>0.051</td>\n",
       "      <td>0.033</td>\n",
       "      <td>ASHLAND</td>\n",
       "      <td>ASHLAND AIRPORT</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Clay</td>\n",
       "      <td>Ashland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-05-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>01</td>\n",
       "      <td>027</td>\n",
       "      <td>0001</td>\n",
       "      <td>44201</td>\n",
       "      <td>1</td>\n",
       "      <td>33.284928</td>\n",
       "      <td>-85.803608</td>\n",
       "      <td>NAD83</td>\n",
       "      <td>Ozone</td>\n",
       "      <td>8-HR RUN AVG BEGIN HOUR</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061</td>\n",
       "      <td>0.051</td>\n",
       "      <td>0.033</td>\n",
       "      <td>ASHLAND</td>\n",
       "      <td>ASHLAND AIRPORT</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Clay</td>\n",
       "      <td>Ashland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-05-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>01</td>\n",
       "      <td>027</td>\n",
       "      <td>0001</td>\n",
       "      <td>44201</td>\n",
       "      <td>1</td>\n",
       "      <td>33.284928</td>\n",
       "      <td>-85.803608</td>\n",
       "      <td>NAD83</td>\n",
       "      <td>Ozone</td>\n",
       "      <td>8-HR RUN AVG BEGIN HOUR</td>\n",
       "      <td>...</td>\n",
       "      <td>0.061</td>\n",
       "      <td>0.051</td>\n",
       "      <td>0.033</td>\n",
       "      <td>ASHLAND</td>\n",
       "      <td>ASHLAND AIRPORT</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Clay</td>\n",
       "      <td>Ashland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-05-21</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 55 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  State Code County Code Site Num Parameter Code POC   Latitude   Longitude  \\\n",
       "0         01         015     0001          81102   1  33.656771  -85.824409   \n",
       "1         01         027     0001          44201   1  33.284928  -85.803608   \n",
       "2         01         027     0001          44201   1  33.284928  -85.803608   \n",
       "3         01         027     0001          44201   1  33.284928  -85.803608   \n",
       "4         01         027     0001          44201   1  33.284928  -85.803608   \n",
       "\n",
       "   Datum         Parameter Name          Sample Duration  ... 75th Percentile  \\\n",
       "0  WGS84  PM10 Total 0-10um STP                  24 HOUR  ...              27   \n",
       "1  NAD83                  Ozone                   1 HOUR  ...           0.067   \n",
       "2  NAD83                  Ozone  8-HR RUN AVG BEGIN HOUR  ...           0.061   \n",
       "3  NAD83                  Ozone  8-HR RUN AVG BEGIN HOUR  ...           0.061   \n",
       "4  NAD83                  Ozone  8-HR RUN AVG BEGIN HOUR  ...           0.061   \n",
       "\n",
       "  50th Percentile 10th Percentile Local Site Name              Address  \\\n",
       "0              21              10             NaN  309 EAST 8TH STREET   \n",
       "1           0.056           0.037         ASHLAND      ASHLAND AIRPORT   \n",
       "2           0.051           0.033         ASHLAND      ASHLAND AIRPORT   \n",
       "3           0.051           0.033         ASHLAND      ASHLAND AIRPORT   \n",
       "4           0.051           0.033         ASHLAND      ASHLAND AIRPORT   \n",
       "\n",
       "  State Name County Name City Name                         CBSA Name  \\\n",
       "0    Alabama     Calhoun  Anniston  Anniston-Oxford-Jacksonville, AL   \n",
       "1    Alabama        Clay   Ashland                               NaN   \n",
       "2    Alabama        Clay   Ashland                               NaN   \n",
       "3    Alabama        Clay   Ashland                               NaN   \n",
       "4    Alabama        Clay   Ashland                               NaN   \n",
       "\n",
       "  Date of Last Change  \n",
       "0          2020-05-21  \n",
       "1          2020-05-21  \n",
       "2          2020-05-21  \n",
       "3          2020-05-21  \n",
       "4          2020-05-21  \n",
       "\n",
       "[5 rows x 55 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "base_epa_file = \"Resources/EPA_annual_conc_by_monitor/annual_conc_by_monitor_\"\n",
    "\n",
    "# Read the first csv file and put into our combined_epa_df\n",
    "epa_file = base_epa_file + '1995.zip'\n",
    "print('Loading file ' + epa_file)\n",
    "print('-------------------------------------')\n",
    "combined_epa_df = pd.read_csv(epa_file,compression='zip', header=0, sep=',', quotechar='\"',dtype='unicode')\n",
    "\n",
    "\n",
    "# Loop through the rest of the files and combine into combined_epa_df\n",
    "for year in range(1996,2021):\n",
    "    epa_file = base_epa_file + str(year) + '.zip'\n",
    "    print('Loading file ' + epa_file)\n",
    "    print('-------------------------------------')    \n",
    "    epa_df = pd.read_csv(epa_file,compression='zip', header=0, sep=',', quotechar='\"',dtype='unicode')\n",
    "    combined_epa_df = pd.concat([combined_epa_df,epa_df])\n",
    "\n",
    "# Output the DataFrame\n",
    "combined_epa_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "extracted_epa_first_df = combined_epa_df[['Parameter Name', 'Year', 'Sample Duration', 'Pollutant Standard','Metric Used',\n",
    "                                   'Method Name','Units of Measure','1st Max Value','1st Max DateTime','State Name','County Name','City Name']].copy()\n",
    "extracted_epa_second_df = combined_epa_df[['Parameter Name', 'Year', 'Sample Duration', 'Pollutant Standard','Metric Used',\n",
    "                                   'Method Name','Units of Measure','2nd Max Value','2nd Max DateTime','State Name','County Name','City Name']].copy()\n",
    "extracted_epa_third_df = combined_epa_df[['Parameter Name', 'Year', 'Sample Duration', 'Pollutant Standard','Metric Used',\n",
    "                                   'Method Name','Units of Measure','3rd Max Value','3rd Max DateTime','State Name','County Name','City Name']].copy()\n",
    "extracted_epa_fourth_df = combined_epa_df[['Parameter Name', 'Year', 'Sample Duration', 'Pollutant Standard','Metric Used',\n",
    "                                   'Method Name','Units of Measure','4th Max Value','4th Max DateTime','State Name','County Name','City Name']].copy()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "extracted_epa_first_df = extracted_epa_first_df.rename(columns = {'1st Max Value':'Max Value','1st Max DateTime':'Max DateTime'})\n",
    "extracted_epa_second_df = extracted_epa_second_df.rename(columns = {'2nd Max Value':'Max Value','2nd Max DateTime':'Max DateTime'})\n",
    "extracted_epa_third_df = extracted_epa_third_df.rename(columns = {'3rd Max Value':'Max Value','3rd Max DateTime':'Max DateTime'})\n",
    "extracted_epa_fourth_df = extracted_epa_fourth_df.rename(columns = {'4th Max Value':'Max Value','4th Max DateTime':'Max DateTime'})\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>Parameter Name</th>\n",
       "      <th>Year</th>\n",
       "      <th>Sample Duration</th>\n",
       "      <th>Pollutant Standard</th>\n",
       "      <th>Metric Used</th>\n",
       "      <th>Method Name</th>\n",
       "      <th>Units of Measure</th>\n",
       "      <th>Max Value</th>\n",
       "      <th>Max DateTime</th>\n",
       "      <th>State Name</th>\n",
       "      <th>County Name</th>\n",
       "      <th>City Name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>PM10 Total 0-10um STP</td>\n",
       "      <td>1995</td>\n",
       "      <td>24 HOUR</td>\n",
       "      <td>PM10 24-hour 2006</td>\n",
       "      <td>Daily Mean</td>\n",
       "      <td>HI-VOL SA/GMW-1200 - GRAVIMETRIC</td>\n",
       "      <td>Micrograms/cubic meter (25 C)</td>\n",
       "      <td>68</td>\n",
       "      <td>1995-08-19 00:00</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Calhoun</td>\n",
       "      <td>Anniston</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ozone</td>\n",
       "      <td>1995</td>\n",
       "      <td>1 HOUR</td>\n",
       "      <td>Ozone 1-hour 1979</td>\n",
       "      <td>Daily maxima of observed hourly values (betwee...</td>\n",
       "      <td>Multiple Methods Used</td>\n",
       "      <td>Parts per million</td>\n",
       "      <td>0.126</td>\n",
       "      <td>1995-08-12 15:00</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Clay</td>\n",
       "      <td>Ashland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ozone</td>\n",
       "      <td>1995</td>\n",
       "      <td>8-HR RUN AVG BEGIN HOUR</td>\n",
       "      <td>Ozone 8-Hour 1997</td>\n",
       "      <td>Daily maximum of 8 hour running average of obs...</td>\n",
       "      <td>Multiple Methods Used</td>\n",
       "      <td>Parts per million</td>\n",
       "      <td>0.104</td>\n",
       "      <td>1995-08-23 11:00</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Clay</td>\n",
       "      <td>Ashland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ozone</td>\n",
       "      <td>1995</td>\n",
       "      <td>8-HR RUN AVG BEGIN HOUR</td>\n",
       "      <td>Ozone 8-Hour 2008</td>\n",
       "      <td>Daily maximum of 8 hour running average of obs...</td>\n",
       "      <td>Multiple Methods Used</td>\n",
       "      <td>Parts per million</td>\n",
       "      <td>0.104</td>\n",
       "      <td>1995-08-23 11:00</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Clay</td>\n",
       "      <td>Ashland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ozone</td>\n",
       "      <td>1995</td>\n",
       "      <td>8-HR RUN AVG BEGIN HOUR</td>\n",
       "      <td>Ozone 8-hour 2015</td>\n",
       "      <td>Daily maximum of 8-hour running average</td>\n",
       "      <td>Multiple Methods Used</td>\n",
       "      <td>Parts per million</td>\n",
       "      <td>0.104</td>\n",
       "      <td>1995-08-23 11:00</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Clay</td>\n",
       "      <td>Ashland</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Parameter Name  Year          Sample Duration Pollutant Standard  \\\n",
       "0  PM10 Total 0-10um STP  1995                  24 HOUR  PM10 24-hour 2006   \n",
       "1                  Ozone  1995                   1 HOUR  Ozone 1-hour 1979   \n",
       "2                  Ozone  1995  8-HR RUN AVG BEGIN HOUR  Ozone 8-Hour 1997   \n",
       "3                  Ozone  1995  8-HR RUN AVG BEGIN HOUR  Ozone 8-Hour 2008   \n",
       "4                  Ozone  1995  8-HR RUN AVG BEGIN HOUR  Ozone 8-hour 2015   \n",
       "\n",
       "                                         Metric Used  \\\n",
       "0                                         Daily Mean   \n",
       "1  Daily maxima of observed hourly values (betwee...   \n",
       "2  Daily maximum of 8 hour running average of obs...   \n",
       "3  Daily maximum of 8 hour running average of obs...   \n",
       "4            Daily maximum of 8-hour running average   \n",
       "\n",
       "                        Method Name               Units of Measure Max Value  \\\n",
       "0  HI-VOL SA/GMW-1200 - GRAVIMETRIC  Micrograms/cubic meter (25 C)        68   \n",
       "1             Multiple Methods Used              Parts per million     0.126   \n",
       "2             Multiple Methods Used              Parts per million     0.104   \n",
       "3             Multiple Methods Used              Parts per million     0.104   \n",
       "4             Multiple Methods Used              Parts per million     0.104   \n",
       "\n",
       "       Max DateTime State Name County Name City Name  \n",
       "0  1995-08-19 00:00    Alabama     Calhoun  Anniston  \n",
       "1  1995-08-12 15:00    Alabama        Clay   Ashland  \n",
       "2  1995-08-23 11:00    Alabama        Clay   Ashland  \n",
       "3  1995-08-23 11:00    Alabama        Clay   Ashland  \n",
       "4  1995-08-23 11:00    Alabama        Clay   Ashland  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined_extracted_epa_df = pd.concat([extracted_epa_first_df,extracted_epa_second_df,extracted_epa_third_df,extracted_epa_fourth_df])\n",
    "combined_extracted_epa_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create the first zip file\n",
    "compression_opts = dict(method='zip',\n",
    "                        archive_name='US_EPA_1995_2020_first.csv')  \n",
    "extracted_epa_first_df.to_csv('US_EPA_1995_2020_first.zip', index=False,\n",
    "                              compression=compression_opts)  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create the second zip file\n",
    "compression_opts = dict(method='zip',\n",
    "                        archive_name='US_EPA_1995_2020_second.csv')  \n",
    "extracted_epa_second_df.to_csv('US_EPA_1995_2020_second.zip', index=False,\n",
    "                              compression=compression_opts)  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create the third zip file\n",
    "compression_opts = dict(method='zip',\n",
    "                        archive_name='US_EPA_1995_2020_third.csv')  \n",
    "extracted_epa_third_df.to_csv('US_EPA_1995_2020_third.zip', index=False,\n",
    "                              compression=compression_opts)  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create the fourth zip file\n",
    "compression_opts = dict(method='zip',\n",
    "                        archive_name='US_EPA_1995_2020_fourth.csv')  \n",
    "extracted_epa_fourth_df.to_csv('US_EPA_1995_2020_fourth.zip', index=False,\n",
    "                              compression=compression_opts)  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Move the zip files to Resources\n",
    "curr_dir = os.getcwd()\n",
    "files = ['US_EPA_1995_2020_first.zip','US_EPA_1995_2020_second.zip','US_EPA_1995_2020_third.zip','US_EPA_1995_2020_fourth.zip']\n",
    "\n",
    "for zip_file in files:\n",
    "\n",
    "    source = curr_dir + '/' + zip_file\n",
    "    destination = curr_dir + '/Resources/' + zip_file\n",
    "    # Move the content of \n",
    "    # source to destination \n",
    "    dest = shutil.move(source, destination) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [conda env:PythonData]",
   "language": "python",
   "name": "conda-env-PythonData-py"
  },
  "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": 2
}