NP_Bio_Data_Preproccesing_Part1.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Import Packages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Step 1: Load Data Tables\n",
    "Dataset Link: https://www.kaggle.com/nationalparkservice/park-biodiversity"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Load parks table\n",
    "parks = pd.read_csv('parks.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/elizabethfabio/opt/miniconda3/lib/python3.8/site-packages/IPython/core/interactiveshell.py:3146: DtypeWarning: Columns (13) have mixed types.Specify dtype option on import or set low_memory=False.\n",
      "  has_raised = await self.run_ast_nodes(code_ast.body, cell_name,\n"
     ]
    }
   ],
   "source": [
    "# Load species table\n",
    "species = pd.read_csv('species.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Dataset Link: [NPS Stats](https://irma.nps.gov/STATS/SSRSReports/National%20Reports/Annual%20Visitation%20and%20Record%20Year%20by%20Park%20(1904%20-%20Last%20Calendar%20Year))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 122,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Load annual visitation numbers\n",
    "visits = pd.read_csv('Annual_NP_Visitation.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Check Data Tables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "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>Park Code</th>\n",
       "      <th>Park Name</th>\n",
       "      <th>State</th>\n",
       "      <th>Acres</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ACAD</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>ME</td>\n",
       "      <td>47390</td>\n",
       "      <td>44.35</td>\n",
       "      <td>-68.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ARCH</td>\n",
       "      <td>Arches National Park</td>\n",
       "      <td>UT</td>\n",
       "      <td>76519</td>\n",
       "      <td>38.68</td>\n",
       "      <td>-109.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BADL</td>\n",
       "      <td>Badlands National Park</td>\n",
       "      <td>SD</td>\n",
       "      <td>242756</td>\n",
       "      <td>43.75</td>\n",
       "      <td>-102.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BIBE</td>\n",
       "      <td>Big Bend National Park</td>\n",
       "      <td>TX</td>\n",
       "      <td>801163</td>\n",
       "      <td>29.25</td>\n",
       "      <td>-103.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BISC</td>\n",
       "      <td>Biscayne National Park</td>\n",
       "      <td>FL</td>\n",
       "      <td>172924</td>\n",
       "      <td>25.65</td>\n",
       "      <td>-80.08</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Park Code               Park Name State   Acres  Latitude  Longitude\n",
       "0      ACAD    Acadia National Park    ME   47390     44.35     -68.21\n",
       "1      ARCH    Arches National Park    UT   76519     38.68    -109.57\n",
       "2      BADL  Badlands National Park    SD  242756     43.75    -102.50\n",
       "3      BIBE  Big Bend National Park    TX  801163     29.25    -103.25\n",
       "4      BISC  Biscayne National Park    FL  172924     25.65     -80.08"
      ]
     },
     "execution_count": 123,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check first 5 rows of parks\n",
    "parks.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 124,
   "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>Species ID</th>\n",
       "      <th>Park Name</th>\n",
       "      <th>Category</th>\n",
       "      <th>Order</th>\n",
       "      <th>Family</th>\n",
       "      <th>Scientific Name</th>\n",
       "      <th>Common Names</th>\n",
       "      <th>Record Status</th>\n",
       "      <th>Occurrence</th>\n",
       "      <th>Nativeness</th>\n",
       "      <th>Abundance</th>\n",
       "      <th>Seasonality</th>\n",
       "      <th>Conservation Status</th>\n",
       "      <th>Unnamed: 13</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ACAD-1000</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Artiodactyla</td>\n",
       "      <td>Cervidae</td>\n",
       "      <td>Alces alces</td>\n",
       "      <td>Moose</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Native</td>\n",
       "      <td>Rare</td>\n",
       "      <td>Resident</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ACAD-1001</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Artiodactyla</td>\n",
       "      <td>Cervidae</td>\n",
       "      <td>Odocoileus virginianus</td>\n",
       "      <td>Northern White-Tailed Deer, Virginia Deer, Whi...</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Native</td>\n",
       "      <td>Abundant</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ACAD-1002</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Carnivora</td>\n",
       "      <td>Canidae</td>\n",
       "      <td>Canis latrans</td>\n",
       "      <td>Coyote, Eastern Coyote</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Not Native</td>\n",
       "      <td>Common</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Species of Concern</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ACAD-1003</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Carnivora</td>\n",
       "      <td>Canidae</td>\n",
       "      <td>Canis lupus</td>\n",
       "      <td>Eastern Timber Wolf, Gray Wolf, Timber Wolf</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Not Confirmed</td>\n",
       "      <td>Native</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Endangered</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ACAD-1004</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Carnivora</td>\n",
       "      <td>Canidae</td>\n",
       "      <td>Vulpes vulpes</td>\n",
       "      <td>Black Fox, Cross Fox, Eastern Red Fox, Fox, Re...</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Common</td>\n",
       "      <td>Breeder</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Species ID             Park Name Category         Order    Family  \\\n",
       "0  ACAD-1000  Acadia National Park   Mammal  Artiodactyla  Cervidae   \n",
       "1  ACAD-1001  Acadia National Park   Mammal  Artiodactyla  Cervidae   \n",
       "2  ACAD-1002  Acadia National Park   Mammal     Carnivora   Canidae   \n",
       "3  ACAD-1003  Acadia National Park   Mammal     Carnivora   Canidae   \n",
       "4  ACAD-1004  Acadia National Park   Mammal     Carnivora   Canidae   \n",
       "\n",
       "          Scientific Name                                       Common Names  \\\n",
       "0             Alces alces                                              Moose   \n",
       "1  Odocoileus virginianus  Northern White-Tailed Deer, Virginia Deer, Whi...   \n",
       "2           Canis latrans                             Coyote, Eastern Coyote   \n",
       "3             Canis lupus        Eastern Timber Wolf, Gray Wolf, Timber Wolf   \n",
       "4           Vulpes vulpes  Black Fox, Cross Fox, Eastern Red Fox, Fox, Re...   \n",
       "\n",
       "  Record Status     Occurrence  Nativeness Abundance Seasonality  \\\n",
       "0      Approved        Present      Native      Rare    Resident   \n",
       "1      Approved        Present      Native  Abundant         NaN   \n",
       "2      Approved        Present  Not Native    Common         NaN   \n",
       "3      Approved  Not Confirmed      Native       NaN         NaN   \n",
       "4      Approved        Present     Unknown    Common     Breeder   \n",
       "\n",
       "  Conservation Status Unnamed: 13  \n",
       "0                 NaN         NaN  \n",
       "1                 NaN         NaN  \n",
       "2  Species of Concern         NaN  \n",
       "3          Endangered         NaN  \n",
       "4                 NaN         NaN  "
      ]
     },
     "execution_count": 124,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check first 5 rows of species\n",
    "species.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 125,
   "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>RegionName</th>\n",
       "      <th>ParkName</th>\n",
       "      <th>ParkType</th>\n",
       "      <th>Year</th>\n",
       "      <th>TRV</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Alaska Region</td>\n",
       "      <td>Denali NP &amp; PRES</td>\n",
       "      <td>National Park</td>\n",
       "      <td>1904</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Alaska Region</td>\n",
       "      <td>Denali NP &amp; PRES</td>\n",
       "      <td>National Park</td>\n",
       "      <td>1905</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Alaska Region</td>\n",
       "      <td>Denali NP &amp; PRES</td>\n",
       "      <td>National Park</td>\n",
       "      <td>1906</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Alaska Region</td>\n",
       "      <td>Denali NP &amp; PRES</td>\n",
       "      <td>National Park</td>\n",
       "      <td>1907</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alaska Region</td>\n",
       "      <td>Denali NP &amp; PRES</td>\n",
       "      <td>National Park</td>\n",
       "      <td>1908</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      RegionName          ParkName       ParkType  Year  TRV\n",
       "0  Alaska Region  Denali NP & PRES  National Park  1904  NaN\n",
       "1  Alaska Region  Denali NP & PRES  National Park  1905  NaN\n",
       "2  Alaska Region  Denali NP & PRES  National Park  1906  NaN\n",
       "3  Alaska Region  Denali NP & PRES  National Park  1907  NaN\n",
       "4  Alaska Region  Denali NP & PRES  National Park  1908  NaN"
      ]
     },
     "execution_count": 125,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check first 5 rows of visits\n",
    "visits.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 126,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(56, 6)"
      ]
     },
     "execution_count": 126,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check shape of parks\n",
    "parks.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 127,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(119248, 14)"
      ]
     },
     "execution_count": 127,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check shape of species\n",
    "species.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 128,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(7371, 5)"
      ]
     },
     "execution_count": 128,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check shape of visits\n",
    "visits.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Step 2: Join National Park Visitor Count to Parks Table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RegionName    object\n",
       "ParkName      object\n",
       "ParkType      object\n",
       "Year           int64\n",
       "TRV           object\n",
       "dtype: object"
      ]
     },
     "execution_count": 129,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check the datatypes of the columns in visits\n",
    "visits.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "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>RegionName</th>\n",
       "      <th>ParkName</th>\n",
       "      <th>ParkType</th>\n",
       "      <th>Year</th>\n",
       "      <th>TRV</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Alaska Region</td>\n",
       "      <td>Denali National Park and Preserve</td>\n",
       "      <td>National Park</td>\n",
       "      <td>1904</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Alaska Region</td>\n",
       "      <td>Denali National Park and Preserve</td>\n",
       "      <td>National Park</td>\n",
       "      <td>1905</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Alaska Region</td>\n",
       "      <td>Denali National Park and Preserve</td>\n",
       "      <td>National Park</td>\n",
       "      <td>1906</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Alaska Region</td>\n",
       "      <td>Denali National Park and Preserve</td>\n",
       "      <td>National Park</td>\n",
       "      <td>1907</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alaska Region</td>\n",
       "      <td>Denali National Park and Preserve</td>\n",
       "      <td>National Park</td>\n",
       "      <td>1908</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7366</th>\n",
       "      <td>Southeast  Region</td>\n",
       "      <td>Virgin Islands NP</td>\n",
       "      <td>National Park</td>\n",
       "      <td>2016</td>\n",
       "      <td>411,343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7367</th>\n",
       "      <td>Southeast  Region</td>\n",
       "      <td>Virgin Islands NP</td>\n",
       "      <td>National Park</td>\n",
       "      <td>2017</td>\n",
       "      <td>304,408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7368</th>\n",
       "      <td>Southeast  Region</td>\n",
       "      <td>Virgin Islands NP</td>\n",
       "      <td>National Park</td>\n",
       "      <td>2018</td>\n",
       "      <td>112,287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7369</th>\n",
       "      <td>Southeast  Region</td>\n",
       "      <td>Virgin Islands NP</td>\n",
       "      <td>National Park</td>\n",
       "      <td>2019</td>\n",
       "      <td>133,398</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7370</th>\n",
       "      <td>Southeast  Region</td>\n",
       "      <td>Virgin Islands NP</td>\n",
       "      <td>National Park</td>\n",
       "      <td>2020</td>\n",
       "      <td>167,540</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7371 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             RegionName                           ParkName       ParkType  \\\n",
       "0         Alaska Region  Denali National Park and Preserve  National Park   \n",
       "1         Alaska Region  Denali National Park and Preserve  National Park   \n",
       "2         Alaska Region  Denali National Park and Preserve  National Park   \n",
       "3         Alaska Region  Denali National Park and Preserve  National Park   \n",
       "4         Alaska Region  Denali National Park and Preserve  National Park   \n",
       "...                 ...                                ...            ...   \n",
       "7366  Southeast  Region                  Virgin Islands NP  National Park   \n",
       "7367  Southeast  Region                  Virgin Islands NP  National Park   \n",
       "7368  Southeast  Region                  Virgin Islands NP  National Park   \n",
       "7369  Southeast  Region                  Virgin Islands NP  National Park   \n",
       "7370  Southeast  Region                  Virgin Islands NP  National Park   \n",
       "\n",
       "      Year      TRV  \n",
       "0     1904      NaN  \n",
       "1     1905      NaN  \n",
       "2     1906      NaN  \n",
       "3     1907      NaN  \n",
       "4     1908      NaN  \n",
       "...    ...      ...  \n",
       "7366  2016  411,343  \n",
       "7367  2017  304,408  \n",
       "7368  2018  112,287  \n",
       "7369  2019  133,398  \n",
       "7370  2020  167,540  \n",
       "\n",
       "[7371 rows x 5 columns]"
      ]
     },
     "execution_count": 130,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Modify ParkName to reflect the same format in parks table\n",
    "# Replace NP & PRES\n",
    "visits['ParkName'] = visits.ParkName.str.replace('NP & PRES','National Park and Preserve')\n",
    "# Check visits table\n",
    "visits"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "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>RegionName</th>\n",
       "      <th>ParkName</th>\n",
       "      <th>ParkType</th>\n",
       "      <th>Year</th>\n",
       "      <th>TRV</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Alaska Region</td>\n",
       "      <td>Denali National Park and Preserve</td>\n",
       "      <td>National Park</td>\n",
       "      <td>1904</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Alaska Region</td>\n",
       "      <td>Denali National Park and Preserve</td>\n",
       "      <td>National Park</td>\n",
       "      <td>1905</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Alaska Region</td>\n",
       "      <td>Denali National Park and Preserve</td>\n",
       "      <td>National Park</td>\n",
       "      <td>1906</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Alaska Region</td>\n",
       "      <td>Denali National Park and Preserve</td>\n",
       "      <td>National Park</td>\n",
       "      <td>1907</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alaska Region</td>\n",
       "      <td>Denali National Park and Preserve</td>\n",
       "      <td>National Park</td>\n",
       "      <td>1908</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7366</th>\n",
       "      <td>Southeast  Region</td>\n",
       "      <td>Virgin Islands National Park</td>\n",
       "      <td>National Park</td>\n",
       "      <td>2016</td>\n",
       "      <td>411,343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7367</th>\n",
       "      <td>Southeast  Region</td>\n",
       "      <td>Virgin Islands National Park</td>\n",
       "      <td>National Park</td>\n",
       "      <td>2017</td>\n",
       "      <td>304,408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7368</th>\n",
       "      <td>Southeast  Region</td>\n",
       "      <td>Virgin Islands National Park</td>\n",
       "      <td>National Park</td>\n",
       "      <td>2018</td>\n",
       "      <td>112,287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7369</th>\n",
       "      <td>Southeast  Region</td>\n",
       "      <td>Virgin Islands National Park</td>\n",
       "      <td>National Park</td>\n",
       "      <td>2019</td>\n",
       "      <td>133,398</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7370</th>\n",
       "      <td>Southeast  Region</td>\n",
       "      <td>Virgin Islands National Park</td>\n",
       "      <td>National Park</td>\n",
       "      <td>2020</td>\n",
       "      <td>167,540</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7371 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             RegionName                           ParkName       ParkType  \\\n",
       "0         Alaska Region  Denali National Park and Preserve  National Park   \n",
       "1         Alaska Region  Denali National Park and Preserve  National Park   \n",
       "2         Alaska Region  Denali National Park and Preserve  National Park   \n",
       "3         Alaska Region  Denali National Park and Preserve  National Park   \n",
       "4         Alaska Region  Denali National Park and Preserve  National Park   \n",
       "...                 ...                                ...            ...   \n",
       "7366  Southeast  Region       Virgin Islands National Park  National Park   \n",
       "7367  Southeast  Region       Virgin Islands National Park  National Park   \n",
       "7368  Southeast  Region       Virgin Islands National Park  National Park   \n",
       "7369  Southeast  Region       Virgin Islands National Park  National Park   \n",
       "7370  Southeast  Region       Virgin Islands National Park  National Park   \n",
       "\n",
       "      Year      TRV  \n",
       "0     1904      NaN  \n",
       "1     1905      NaN  \n",
       "2     1906      NaN  \n",
       "3     1907      NaN  \n",
       "4     1908      NaN  \n",
       "...    ...      ...  \n",
       "7366  2016  411,343  \n",
       "7367  2017  304,408  \n",
       "7368  2018  112,287  \n",
       "7369  2019  133,398  \n",
       "7370  2020  167,540  \n",
       "\n",
       "[7371 rows x 5 columns]"
      ]
     },
     "execution_count": 131,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Modify ParkName to reflect the same format in parks table\n",
    "# Replace NP\n",
    "visits['ParkName'] = visits.ParkName.str.replace('NP','National Park')\n",
    "# Check visits table\n",
    "visits"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Year Selection\n",
    "**Note on Kaggle**: \"Plant and animal species in parks (downloaded 6 January 2017)\"\n",
    "\n",
    "**Action**: Filter Total Record Visitors (TRV) from 2016."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "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>RegionName</th>\n",
       "      <th>ParkName</th>\n",
       "      <th>ParkType</th>\n",
       "      <th>Year</th>\n",
       "      <th>TRV</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>Alaska Region</td>\n",
       "      <td>Denali National Park and Preserve</td>\n",
       "      <td>National Park</td>\n",
       "      <td>2016</td>\n",
       "      <td>587,412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>Alaska Region</td>\n",
       "      <td>Gates of the Arctic National Park and Preserve</td>\n",
       "      <td>National Park</td>\n",
       "      <td>2016</td>\n",
       "      <td>10,047</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>346</th>\n",
       "      <td>Alaska Region</td>\n",
       "      <td>Glacier Bay National Park and Preserve</td>\n",
       "      <td>National Park</td>\n",
       "      <td>2016</td>\n",
       "      <td>520,171</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>463</th>\n",
       "      <td>Alaska Region</td>\n",
       "      <td>Katmai National Park and Preserve</td>\n",
       "      <td>National Park</td>\n",
       "      <td>2016</td>\n",
       "      <td>37,818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>580</th>\n",
       "      <td>Alaska Region</td>\n",
       "      <td>Kenai Fjords National Park</td>\n",
       "      <td>National Park</td>\n",
       "      <td>2016</td>\n",
       "      <td>346,534</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6898</th>\n",
       "      <td>Southeast  Region</td>\n",
       "      <td>Dry Tortugas National Park</td>\n",
       "      <td>National Park</td>\n",
       "      <td>2016</td>\n",
       "      <td>73,661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7015</th>\n",
       "      <td>Southeast  Region</td>\n",
       "      <td>Everglades National Park</td>\n",
       "      <td>National Park</td>\n",
       "      <td>2016</td>\n",
       "      <td>930,907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7132</th>\n",
       "      <td>Southeast  Region</td>\n",
       "      <td>Great Smoky Mountains National Park</td>\n",
       "      <td>National Park</td>\n",
       "      <td>2016</td>\n",
       "      <td>11,312,786</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7249</th>\n",
       "      <td>Southeast  Region</td>\n",
       "      <td>Mammoth Cave National Park</td>\n",
       "      <td>National Park</td>\n",
       "      <td>2016</td>\n",
       "      <td>586,514</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7366</th>\n",
       "      <td>Southeast  Region</td>\n",
       "      <td>Virgin Islands National Park</td>\n",
       "      <td>National Park</td>\n",
       "      <td>2016</td>\n",
       "      <td>411,343</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>63 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             RegionName                                        ParkName  \\\n",
       "112       Alaska Region               Denali National Park and Preserve   \n",
       "229       Alaska Region  Gates of the Arctic National Park and Preserve   \n",
       "346       Alaska Region          Glacier Bay National Park and Preserve   \n",
       "463       Alaska Region               Katmai National Park and Preserve   \n",
       "580       Alaska Region                      Kenai Fjords National Park   \n",
       "...                 ...                                             ...   \n",
       "6898  Southeast  Region                      Dry Tortugas National Park   \n",
       "7015  Southeast  Region                        Everglades National Park   \n",
       "7132  Southeast  Region             Great Smoky Mountains National Park   \n",
       "7249  Southeast  Region                      Mammoth Cave National Park   \n",
       "7366  Southeast  Region                    Virgin Islands National Park   \n",
       "\n",
       "           ParkType  Year         TRV  \n",
       "112   National Park  2016     587,412  \n",
       "229   National Park  2016      10,047  \n",
       "346   National Park  2016     520,171  \n",
       "463   National Park  2016      37,818  \n",
       "580   National Park  2016     346,534  \n",
       "...             ...   ...         ...  \n",
       "6898  National Park  2016      73,661  \n",
       "7015  National Park  2016     930,907  \n",
       "7132  National Park  2016  11,312,786  \n",
       "7249  National Park  2016     586,514  \n",
       "7366  National Park  2016     411,343  \n",
       "\n",
       "[63 rows x 5 columns]"
      ]
     },
     "execution_count": 132,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "visit2016 = visits[visits[\"Year\"]==2016]\n",
    "# Check visits in 2016\n",
    "visit2016"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "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>ParkName</th>\n",
       "      <th>TRV</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>Denali National Park and Preserve</td>\n",
       "      <td>587,412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>Gates of the Arctic National Park and Preserve</td>\n",
       "      <td>10,047</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>346</th>\n",
       "      <td>Glacier Bay National Park and Preserve</td>\n",
       "      <td>520,171</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>463</th>\n",
       "      <td>Katmai National Park and Preserve</td>\n",
       "      <td>37,818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>580</th>\n",
       "      <td>Kenai Fjords National Park</td>\n",
       "      <td>346,534</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6898</th>\n",
       "      <td>Dry Tortugas National Park</td>\n",
       "      <td>73,661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7015</th>\n",
       "      <td>Everglades National Park</td>\n",
       "      <td>930,907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7132</th>\n",
       "      <td>Great Smoky Mountains National Park</td>\n",
       "      <td>11,312,786</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7249</th>\n",
       "      <td>Mammoth Cave National Park</td>\n",
       "      <td>586,514</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7366</th>\n",
       "      <td>Virgin Islands National Park</td>\n",
       "      <td>411,343</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>63 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            ParkName         TRV\n",
       "112                Denali National Park and Preserve     587,412\n",
       "229   Gates of the Arctic National Park and Preserve      10,047\n",
       "346           Glacier Bay National Park and Preserve     520,171\n",
       "463                Katmai National Park and Preserve      37,818\n",
       "580                       Kenai Fjords National Park     346,534\n",
       "...                                              ...         ...\n",
       "6898                      Dry Tortugas National Park      73,661\n",
       "7015                        Everglades National Park     930,907\n",
       "7132             Great Smoky Mountains National Park  11,312,786\n",
       "7249                      Mammoth Cave National Park     586,514\n",
       "7366                    Virgin Islands National Park     411,343\n",
       "\n",
       "[63 rows x 2 columns]"
      ]
     },
     "execution_count": 133,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Modify visit2016 to select only the needed columns\n",
    "visit2016 = visit2016[['ParkName', 'TRV']]\n",
    "# Check modified visits in 2016\n",
    "visit2016"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "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>Species ID</th>\n",
       "      <th>Park Name</th>\n",
       "      <th>Category</th>\n",
       "      <th>Order</th>\n",
       "      <th>Family</th>\n",
       "      <th>Scientific Name</th>\n",
       "      <th>Common Names</th>\n",
       "      <th>Record Status</th>\n",
       "      <th>Occurrence</th>\n",
       "      <th>Nativeness</th>\n",
       "      <th>Abundance</th>\n",
       "      <th>Seasonality</th>\n",
       "      <th>Conservation Status</th>\n",
       "      <th>Unnamed: 13</th>\n",
       "      <th>ParkName</th>\n",
       "      <th>TRV</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ACAD-1000</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Artiodactyla</td>\n",
       "      <td>Cervidae</td>\n",
       "      <td>Alces alces</td>\n",
       "      <td>Moose</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Native</td>\n",
       "      <td>Rare</td>\n",
       "      <td>Resident</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>3,303,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ACAD-1001</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Artiodactyla</td>\n",
       "      <td>Cervidae</td>\n",
       "      <td>Odocoileus virginianus</td>\n",
       "      <td>Northern White-Tailed Deer, Virginia Deer, Whi...</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Native</td>\n",
       "      <td>Abundant</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>3,303,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ACAD-1002</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Carnivora</td>\n",
       "      <td>Canidae</td>\n",
       "      <td>Canis latrans</td>\n",
       "      <td>Coyote, Eastern Coyote</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Not Native</td>\n",
       "      <td>Common</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Species of Concern</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>3,303,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ACAD-1003</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Carnivora</td>\n",
       "      <td>Canidae</td>\n",
       "      <td>Canis lupus</td>\n",
       "      <td>Eastern Timber Wolf, Gray Wolf, Timber Wolf</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Not Confirmed</td>\n",
       "      <td>Native</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>3,303,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ACAD-1004</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Carnivora</td>\n",
       "      <td>Canidae</td>\n",
       "      <td>Vulpes vulpes</td>\n",
       "      <td>Black Fox, Cross Fox, Eastern Red Fox, Fox, Re...</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Common</td>\n",
       "      <td>Breeder</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>3,303,393</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119243</th>\n",
       "      <td>ZION-2791</td>\n",
       "      <td>Zion National Park</td>\n",
       "      <td>Vascular Plant</td>\n",
       "      <td>Solanales</td>\n",
       "      <td>Solanaceae</td>\n",
       "      <td>Solanum triflorum</td>\n",
       "      <td>Cut-Leaf Nightshade</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Native</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Zion National Park</td>\n",
       "      <td>4,295,127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119244</th>\n",
       "      <td>ZION-2792</td>\n",
       "      <td>Zion National Park</td>\n",
       "      <td>Vascular Plant</td>\n",
       "      <td>Vitales</td>\n",
       "      <td>Vitaceae</td>\n",
       "      <td>Vitis arizonica</td>\n",
       "      <td>Canyon Grape</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Native</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Zion National Park</td>\n",
       "      <td>4,295,127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119245</th>\n",
       "      <td>ZION-2793</td>\n",
       "      <td>Zion National Park</td>\n",
       "      <td>Vascular Plant</td>\n",
       "      <td>Vitales</td>\n",
       "      <td>Vitaceae</td>\n",
       "      <td>Vitis vinifera</td>\n",
       "      <td>Wine Grape</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Not Native</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Zion National Park</td>\n",
       "      <td>4,295,127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119246</th>\n",
       "      <td>ZION-2794</td>\n",
       "      <td>Zion National Park</td>\n",
       "      <td>Vascular Plant</td>\n",
       "      <td>Zygophyllales</td>\n",
       "      <td>Zygophyllaceae</td>\n",
       "      <td>Larrea tridentata</td>\n",
       "      <td>Creosote Bush</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Native</td>\n",
       "      <td>Rare</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Zion National Park</td>\n",
       "      <td>4,295,127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119247</th>\n",
       "      <td>ZION-2795</td>\n",
       "      <td>Zion National Park</td>\n",
       "      <td>Vascular Plant</td>\n",
       "      <td>Zygophyllales</td>\n",
       "      <td>Zygophyllaceae</td>\n",
       "      <td>Tribulus terrestris</td>\n",
       "      <td>Puncture Vine</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Not Native</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Zion National Park</td>\n",
       "      <td>4,295,127</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>119248 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Species ID             Park Name        Category          Order  \\\n",
       "0       ACAD-1000  Acadia National Park          Mammal   Artiodactyla   \n",
       "1       ACAD-1001  Acadia National Park          Mammal   Artiodactyla   \n",
       "2       ACAD-1002  Acadia National Park          Mammal      Carnivora   \n",
       "3       ACAD-1003  Acadia National Park          Mammal      Carnivora   \n",
       "4       ACAD-1004  Acadia National Park          Mammal      Carnivora   \n",
       "...           ...                   ...             ...            ...   \n",
       "119243  ZION-2791    Zion National Park  Vascular Plant      Solanales   \n",
       "119244  ZION-2792    Zion National Park  Vascular Plant        Vitales   \n",
       "119245  ZION-2793    Zion National Park  Vascular Plant        Vitales   \n",
       "119246  ZION-2794    Zion National Park  Vascular Plant  Zygophyllales   \n",
       "119247  ZION-2795    Zion National Park  Vascular Plant  Zygophyllales   \n",
       "\n",
       "                Family         Scientific Name  \\\n",
       "0             Cervidae             Alces alces   \n",
       "1             Cervidae  Odocoileus virginianus   \n",
       "2              Canidae           Canis latrans   \n",
       "3              Canidae             Canis lupus   \n",
       "4              Canidae           Vulpes vulpes   \n",
       "...                ...                     ...   \n",
       "119243      Solanaceae       Solanum triflorum   \n",
       "119244        Vitaceae         Vitis arizonica   \n",
       "119245        Vitaceae          Vitis vinifera   \n",
       "119246  Zygophyllaceae       Larrea tridentata   \n",
       "119247  Zygophyllaceae     Tribulus terrestris   \n",
       "\n",
       "                                             Common Names Record Status  \\\n",
       "0                                                   Moose      Approved   \n",
       "1       Northern White-Tailed Deer, Virginia Deer, Whi...      Approved   \n",
       "2                                  Coyote, Eastern Coyote      Approved   \n",
       "3             Eastern Timber Wolf, Gray Wolf, Timber Wolf      Approved   \n",
       "4       Black Fox, Cross Fox, Eastern Red Fox, Fox, Re...      Approved   \n",
       "...                                                   ...           ...   \n",
       "119243                                Cut-Leaf Nightshade      Approved   \n",
       "119244                                       Canyon Grape      Approved   \n",
       "119245                                         Wine Grape      Approved   \n",
       "119246                                      Creosote Bush      Approved   \n",
       "119247                                      Puncture Vine      Approved   \n",
       "\n",
       "           Occurrence  Nativeness Abundance Seasonality Conservation Status  \\\n",
       "0             Present      Native      Rare    Resident                 NaN   \n",
       "1             Present      Native  Abundant         NaN                 NaN   \n",
       "2             Present  Not Native    Common         NaN  Species of Concern   \n",
       "3       Not Confirmed      Native       NaN         NaN          Endangered   \n",
       "4             Present     Unknown    Common     Breeder                 NaN   \n",
       "...               ...         ...       ...         ...                 ...   \n",
       "119243        Present      Native  Uncommon         NaN                 NaN   \n",
       "119244        Present      Native  Uncommon         NaN                 NaN   \n",
       "119245        Present  Not Native  Uncommon         NaN                 NaN   \n",
       "119246        Present      Native      Rare         NaN                 NaN   \n",
       "119247        Present  Not Native  Uncommon         NaN                 NaN   \n",
       "\n",
       "       Unnamed: 13              ParkName        TRV  \n",
       "0              NaN  Acadia National Park  3,303,393  \n",
       "1              NaN  Acadia National Park  3,303,393  \n",
       "2              NaN  Acadia National Park  3,303,393  \n",
       "3              NaN  Acadia National Park  3,303,393  \n",
       "4              NaN  Acadia National Park  3,303,393  \n",
       "...            ...                   ...        ...  \n",
       "119243         NaN    Zion National Park  4,295,127  \n",
       "119244         NaN    Zion National Park  4,295,127  \n",
       "119245         NaN    Zion National Park  4,295,127  \n",
       "119246         NaN    Zion National Park  4,295,127  \n",
       "119247         NaN    Zion National Park  4,295,127  \n",
       "\n",
       "[119248 rows x 16 columns]"
      ]
     },
     "execution_count": 134,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "species = pd.merge(species, visit2016, how='left', left_on='Park Name', right_on='ParkName')\n",
    "species"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Remove Extra Park Name Column (ParkName)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Drop ParkName\n",
    "species.drop('ParkName', inplace=True, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "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>Species ID</th>\n",
       "      <th>Park Name</th>\n",
       "      <th>Category</th>\n",
       "      <th>Order</th>\n",
       "      <th>Family</th>\n",
       "      <th>Scientific Name</th>\n",
       "      <th>Common Names</th>\n",
       "      <th>Record Status</th>\n",
       "      <th>Occurrence</th>\n",
       "      <th>Nativeness</th>\n",
       "      <th>Abundance</th>\n",
       "      <th>Seasonality</th>\n",
       "      <th>Conservation Status</th>\n",
       "      <th>Unnamed: 13</th>\n",
       "      <th>TRV</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ACAD-1000</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Artiodactyla</td>\n",
       "      <td>Cervidae</td>\n",
       "      <td>Alces alces</td>\n",
       "      <td>Moose</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Native</td>\n",
       "      <td>Rare</td>\n",
       "      <td>Resident</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3,303,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ACAD-1001</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Artiodactyla</td>\n",
       "      <td>Cervidae</td>\n",
       "      <td>Odocoileus virginianus</td>\n",
       "      <td>Northern White-Tailed Deer, Virginia Deer, Whi...</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Native</td>\n",
       "      <td>Abundant</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3,303,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ACAD-1002</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Carnivora</td>\n",
       "      <td>Canidae</td>\n",
       "      <td>Canis latrans</td>\n",
       "      <td>Coyote, Eastern Coyote</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Not Native</td>\n",
       "      <td>Common</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Species of Concern</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3,303,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ACAD-1003</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Carnivora</td>\n",
       "      <td>Canidae</td>\n",
       "      <td>Canis lupus</td>\n",
       "      <td>Eastern Timber Wolf, Gray Wolf, Timber Wolf</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Not Confirmed</td>\n",
       "      <td>Native</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3,303,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ACAD-1004</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Carnivora</td>\n",
       "      <td>Canidae</td>\n",
       "      <td>Vulpes vulpes</td>\n",
       "      <td>Black Fox, Cross Fox, Eastern Red Fox, Fox, Re...</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Common</td>\n",
       "      <td>Breeder</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3,303,393</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>119243</th>\n",
       "      <td>ZION-2791</td>\n",
       "      <td>Zion National Park</td>\n",
       "      <td>Vascular Plant</td>\n",
       "      <td>Solanales</td>\n",
       "      <td>Solanaceae</td>\n",
       "      <td>Solanum triflorum</td>\n",
       "      <td>Cut-Leaf Nightshade</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Native</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4,295,127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119244</th>\n",
       "      <td>ZION-2792</td>\n",
       "      <td>Zion National Park</td>\n",
       "      <td>Vascular Plant</td>\n",
       "      <td>Vitales</td>\n",
       "      <td>Vitaceae</td>\n",
       "      <td>Vitis arizonica</td>\n",
       "      <td>Canyon Grape</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Native</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4,295,127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119245</th>\n",
       "      <td>ZION-2793</td>\n",
       "      <td>Zion National Park</td>\n",
       "      <td>Vascular Plant</td>\n",
       "      <td>Vitales</td>\n",
       "      <td>Vitaceae</td>\n",
       "      <td>Vitis vinifera</td>\n",
       "      <td>Wine Grape</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Not Native</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4,295,127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119246</th>\n",
       "      <td>ZION-2794</td>\n",
       "      <td>Zion National Park</td>\n",
       "      <td>Vascular Plant</td>\n",
       "      <td>Zygophyllales</td>\n",
       "      <td>Zygophyllaceae</td>\n",
       "      <td>Larrea tridentata</td>\n",
       "      <td>Creosote Bush</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Native</td>\n",
       "      <td>Rare</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4,295,127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119247</th>\n",
       "      <td>ZION-2795</td>\n",
       "      <td>Zion National Park</td>\n",
       "      <td>Vascular Plant</td>\n",
       "      <td>Zygophyllales</td>\n",
       "      <td>Zygophyllaceae</td>\n",
       "      <td>Tribulus terrestris</td>\n",
       "      <td>Puncture Vine</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Not Native</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4,295,127</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>119248 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Species ID             Park Name        Category          Order  \\\n",
       "0       ACAD-1000  Acadia National Park          Mammal   Artiodactyla   \n",
       "1       ACAD-1001  Acadia National Park          Mammal   Artiodactyla   \n",
       "2       ACAD-1002  Acadia National Park          Mammal      Carnivora   \n",
       "3       ACAD-1003  Acadia National Park          Mammal      Carnivora   \n",
       "4       ACAD-1004  Acadia National Park          Mammal      Carnivora   \n",
       "...           ...                   ...             ...            ...   \n",
       "119243  ZION-2791    Zion National Park  Vascular Plant      Solanales   \n",
       "119244  ZION-2792    Zion National Park  Vascular Plant        Vitales   \n",
       "119245  ZION-2793    Zion National Park  Vascular Plant        Vitales   \n",
       "119246  ZION-2794    Zion National Park  Vascular Plant  Zygophyllales   \n",
       "119247  ZION-2795    Zion National Park  Vascular Plant  Zygophyllales   \n",
       "\n",
       "                Family         Scientific Name  \\\n",
       "0             Cervidae             Alces alces   \n",
       "1             Cervidae  Odocoileus virginianus   \n",
       "2              Canidae           Canis latrans   \n",
       "3              Canidae             Canis lupus   \n",
       "4              Canidae           Vulpes vulpes   \n",
       "...                ...                     ...   \n",
       "119243      Solanaceae       Solanum triflorum   \n",
       "119244        Vitaceae         Vitis arizonica   \n",
       "119245        Vitaceae          Vitis vinifera   \n",
       "119246  Zygophyllaceae       Larrea tridentata   \n",
       "119247  Zygophyllaceae     Tribulus terrestris   \n",
       "\n",
       "                                             Common Names Record Status  \\\n",
       "0                                                   Moose      Approved   \n",
       "1       Northern White-Tailed Deer, Virginia Deer, Whi...      Approved   \n",
       "2                                  Coyote, Eastern Coyote      Approved   \n",
       "3             Eastern Timber Wolf, Gray Wolf, Timber Wolf      Approved   \n",
       "4       Black Fox, Cross Fox, Eastern Red Fox, Fox, Re...      Approved   \n",
       "...                                                   ...           ...   \n",
       "119243                                Cut-Leaf Nightshade      Approved   \n",
       "119244                                       Canyon Grape      Approved   \n",
       "119245                                         Wine Grape      Approved   \n",
       "119246                                      Creosote Bush      Approved   \n",
       "119247                                      Puncture Vine      Approved   \n",
       "\n",
       "           Occurrence  Nativeness Abundance Seasonality Conservation Status  \\\n",
       "0             Present      Native      Rare    Resident                 NaN   \n",
       "1             Present      Native  Abundant         NaN                 NaN   \n",
       "2             Present  Not Native    Common         NaN  Species of Concern   \n",
       "3       Not Confirmed      Native       NaN         NaN          Endangered   \n",
       "4             Present     Unknown    Common     Breeder                 NaN   \n",
       "...               ...         ...       ...         ...                 ...   \n",
       "119243        Present      Native  Uncommon         NaN                 NaN   \n",
       "119244        Present      Native  Uncommon         NaN                 NaN   \n",
       "119245        Present  Not Native  Uncommon         NaN                 NaN   \n",
       "119246        Present      Native      Rare         NaN                 NaN   \n",
       "119247        Present  Not Native  Uncommon         NaN                 NaN   \n",
       "\n",
       "       Unnamed: 13        TRV  \n",
       "0              NaN  3,303,393  \n",
       "1              NaN  3,303,393  \n",
       "2              NaN  3,303,393  \n",
       "3              NaN  3,303,393  \n",
       "4              NaN  3,303,393  \n",
       "...            ...        ...  \n",
       "119243         NaN  4,295,127  \n",
       "119244         NaN  4,295,127  \n",
       "119245         NaN  4,295,127  \n",
       "119246         NaN  4,295,127  \n",
       "119247         NaN  4,295,127  \n",
       "\n",
       "[119248 rows x 15 columns]"
      ]
     },
     "execution_count": 136,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check species\n",
    "species"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 140,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(119248, 15)"
      ]
     },
     "execution_count": 140,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check species shape\n",
    "species.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Step 3: Join Parks Table to Species Table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 141,
   "metadata": {},
   "outputs": [],
   "source": [
    "sp = pd.merge(parks, species, how='left', on='Park Name')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Check Merged Table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "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>Park Code</th>\n",
       "      <th>Park Name</th>\n",
       "      <th>State</th>\n",
       "      <th>Acres</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Species ID</th>\n",
       "      <th>Category</th>\n",
       "      <th>Order</th>\n",
       "      <th>Family</th>\n",
       "      <th>Scientific Name</th>\n",
       "      <th>Common Names</th>\n",
       "      <th>Record Status</th>\n",
       "      <th>Occurrence</th>\n",
       "      <th>Nativeness</th>\n",
       "      <th>Abundance</th>\n",
       "      <th>Seasonality</th>\n",
       "      <th>Conservation Status</th>\n",
       "      <th>Unnamed: 13</th>\n",
       "      <th>TRV</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ACAD</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>ME</td>\n",
       "      <td>47390</td>\n",
       "      <td>44.35</td>\n",
       "      <td>-68.21</td>\n",
       "      <td>ACAD-1000</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Artiodactyla</td>\n",
       "      <td>Cervidae</td>\n",
       "      <td>Alces alces</td>\n",
       "      <td>Moose</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Native</td>\n",
       "      <td>Rare</td>\n",
       "      <td>Resident</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3,303,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ACAD</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>ME</td>\n",
       "      <td>47390</td>\n",
       "      <td>44.35</td>\n",
       "      <td>-68.21</td>\n",
       "      <td>ACAD-1001</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Artiodactyla</td>\n",
       "      <td>Cervidae</td>\n",
       "      <td>Odocoileus virginianus</td>\n",
       "      <td>Northern White-Tailed Deer, Virginia Deer, Whi...</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Native</td>\n",
       "      <td>Abundant</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3,303,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ACAD</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>ME</td>\n",
       "      <td>47390</td>\n",
       "      <td>44.35</td>\n",
       "      <td>-68.21</td>\n",
       "      <td>ACAD-1002</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Carnivora</td>\n",
       "      <td>Canidae</td>\n",
       "      <td>Canis latrans</td>\n",
       "      <td>Coyote, Eastern Coyote</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Not Native</td>\n",
       "      <td>Common</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Species of Concern</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3,303,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ACAD</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>ME</td>\n",
       "      <td>47390</td>\n",
       "      <td>44.35</td>\n",
       "      <td>-68.21</td>\n",
       "      <td>ACAD-1003</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Carnivora</td>\n",
       "      <td>Canidae</td>\n",
       "      <td>Canis lupus</td>\n",
       "      <td>Eastern Timber Wolf, Gray Wolf, Timber Wolf</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Not Confirmed</td>\n",
       "      <td>Native</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3,303,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ACAD</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>ME</td>\n",
       "      <td>47390</td>\n",
       "      <td>44.35</td>\n",
       "      <td>-68.21</td>\n",
       "      <td>ACAD-1004</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Carnivora</td>\n",
       "      <td>Canidae</td>\n",
       "      <td>Vulpes vulpes</td>\n",
       "      <td>Black Fox, Cross Fox, Eastern Red Fox, Fox, Re...</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Common</td>\n",
       "      <td>Breeder</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3,303,393</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Park Code             Park Name State  Acres  Latitude  Longitude  \\\n",
       "0      ACAD  Acadia National Park    ME  47390     44.35     -68.21   \n",
       "1      ACAD  Acadia National Park    ME  47390     44.35     -68.21   \n",
       "2      ACAD  Acadia National Park    ME  47390     44.35     -68.21   \n",
       "3      ACAD  Acadia National Park    ME  47390     44.35     -68.21   \n",
       "4      ACAD  Acadia National Park    ME  47390     44.35     -68.21   \n",
       "\n",
       "  Species ID Category         Order    Family         Scientific Name  \\\n",
       "0  ACAD-1000   Mammal  Artiodactyla  Cervidae             Alces alces   \n",
       "1  ACAD-1001   Mammal  Artiodactyla  Cervidae  Odocoileus virginianus   \n",
       "2  ACAD-1002   Mammal     Carnivora   Canidae           Canis latrans   \n",
       "3  ACAD-1003   Mammal     Carnivora   Canidae             Canis lupus   \n",
       "4  ACAD-1004   Mammal     Carnivora   Canidae           Vulpes vulpes   \n",
       "\n",
       "                                        Common Names Record Status  \\\n",
       "0                                              Moose      Approved   \n",
       "1  Northern White-Tailed Deer, Virginia Deer, Whi...      Approved   \n",
       "2                             Coyote, Eastern Coyote      Approved   \n",
       "3        Eastern Timber Wolf, Gray Wolf, Timber Wolf      Approved   \n",
       "4  Black Fox, Cross Fox, Eastern Red Fox, Fox, Re...      Approved   \n",
       "\n",
       "      Occurrence  Nativeness Abundance Seasonality Conservation Status  \\\n",
       "0        Present      Native      Rare    Resident                 NaN   \n",
       "1        Present      Native  Abundant         NaN                 NaN   \n",
       "2        Present  Not Native    Common         NaN  Species of Concern   \n",
       "3  Not Confirmed      Native       NaN         NaN          Endangered   \n",
       "4        Present     Unknown    Common     Breeder                 NaN   \n",
       "\n",
       "  Unnamed: 13        TRV  \n",
       "0         NaN  3,303,393  \n",
       "1         NaN  3,303,393  \n",
       "2         NaN  3,303,393  \n",
       "3         NaN  3,303,393  \n",
       "4         NaN  3,303,393  "
      ]
     },
     "execution_count": 142,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check first 5 rows of sp\n",
    "sp.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 143,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(119248, 20)"
      ]
     },
     "execution_count": 143,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check shape of sp\n",
    "sp.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Remove Remaining Unnecessary Columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Park Code', 'Park Name', 'State', 'Acres', 'Latitude', 'Longitude',\n",
       "       'Species ID', 'Category', 'Order', 'Family', 'Scientific Name',\n",
       "       'Common Names', 'Record Status', 'Occurrence', 'Nativeness',\n",
       "       'Abundance', 'Seasonality', 'Conservation Status', 'Unnamed: 13',\n",
       "       'TRV'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 144,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sp.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0         NaN\n",
       "1         NaN\n",
       "2         NaN\n",
       "3         NaN\n",
       "4         NaN\n",
       "         ... \n",
       "119243    NaN\n",
       "119244    NaN\n",
       "119245    NaN\n",
       "119246    NaN\n",
       "119247    NaN\n",
       "Name: Unnamed: 13, Length: 119248, dtype: object"
      ]
     },
     "execution_count": 145,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sp['Unnamed: 13']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Drop 'Unnamed: 13' column\n",
    "sp.drop('Unnamed: 13', inplace=True, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Park Code', 'Park Name', 'State', 'Acres', 'Latitude', 'Longitude',\n",
       "       'Species ID', 'Category', 'Order', 'Family', 'Scientific Name',\n",
       "       'Common Names', 'Record Status', 'Occurrence', 'Nativeness',\n",
       "       'Abundance', 'Seasonality', 'Conservation Status', 'TRV'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 147,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check columns\n",
    "sp.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "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>Park Code</th>\n",
       "      <th>Park Name</th>\n",
       "      <th>State</th>\n",
       "      <th>Acres</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Species ID</th>\n",
       "      <th>Category</th>\n",
       "      <th>Order</th>\n",
       "      <th>Family</th>\n",
       "      <th>Scientific Name</th>\n",
       "      <th>Common Names</th>\n",
       "      <th>Record Status</th>\n",
       "      <th>Occurrence</th>\n",
       "      <th>Nativeness</th>\n",
       "      <th>Abundance</th>\n",
       "      <th>Seasonality</th>\n",
       "      <th>Conservation Status</th>\n",
       "      <th>TRV</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ACAD</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>ME</td>\n",
       "      <td>47390</td>\n",
       "      <td>44.35</td>\n",
       "      <td>-68.21</td>\n",
       "      <td>ACAD-1000</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Artiodactyla</td>\n",
       "      <td>Cervidae</td>\n",
       "      <td>Alces alces</td>\n",
       "      <td>Moose</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Native</td>\n",
       "      <td>Rare</td>\n",
       "      <td>Resident</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3,303,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ACAD</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>ME</td>\n",
       "      <td>47390</td>\n",
       "      <td>44.35</td>\n",
       "      <td>-68.21</td>\n",
       "      <td>ACAD-1001</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Artiodactyla</td>\n",
       "      <td>Cervidae</td>\n",
       "      <td>Odocoileus virginianus</td>\n",
       "      <td>Northern White-Tailed Deer, Virginia Deer, Whi...</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Native</td>\n",
       "      <td>Abundant</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3,303,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ACAD</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>ME</td>\n",
       "      <td>47390</td>\n",
       "      <td>44.35</td>\n",
       "      <td>-68.21</td>\n",
       "      <td>ACAD-1002</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Carnivora</td>\n",
       "      <td>Canidae</td>\n",
       "      <td>Canis latrans</td>\n",
       "      <td>Coyote, Eastern Coyote</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Not Native</td>\n",
       "      <td>Common</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Species of Concern</td>\n",
       "      <td>3,303,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ACAD</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>ME</td>\n",
       "      <td>47390</td>\n",
       "      <td>44.35</td>\n",
       "      <td>-68.21</td>\n",
       "      <td>ACAD-1003</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Carnivora</td>\n",
       "      <td>Canidae</td>\n",
       "      <td>Canis lupus</td>\n",
       "      <td>Eastern Timber Wolf, Gray Wolf, Timber Wolf</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Not Confirmed</td>\n",
       "      <td>Native</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Endangered</td>\n",
       "      <td>3,303,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ACAD</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>ME</td>\n",
       "      <td>47390</td>\n",
       "      <td>44.35</td>\n",
       "      <td>-68.21</td>\n",
       "      <td>ACAD-1004</td>\n",
       "      <td>Mammal</td>\n",
       "      <td>Carnivora</td>\n",
       "      <td>Canidae</td>\n",
       "      <td>Vulpes vulpes</td>\n",
       "      <td>Black Fox, Cross Fox, Eastern Red Fox, Fox, Re...</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Common</td>\n",
       "      <td>Breeder</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3,303,393</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119243</th>\n",
       "      <td>ZION</td>\n",
       "      <td>Zion National Park</td>\n",
       "      <td>UT</td>\n",
       "      <td>146598</td>\n",
       "      <td>37.30</td>\n",
       "      <td>-113.05</td>\n",
       "      <td>ZION-2791</td>\n",
       "      <td>Vascular Plant</td>\n",
       "      <td>Solanales</td>\n",
       "      <td>Solanaceae</td>\n",
       "      <td>Solanum triflorum</td>\n",
       "      <td>Cut-Leaf Nightshade</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Native</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4,295,127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119244</th>\n",
       "      <td>ZION</td>\n",
       "      <td>Zion National Park</td>\n",
       "      <td>UT</td>\n",
       "      <td>146598</td>\n",
       "      <td>37.30</td>\n",
       "      <td>-113.05</td>\n",
       "      <td>ZION-2792</td>\n",
       "      <td>Vascular Plant</td>\n",
       "      <td>Vitales</td>\n",
       "      <td>Vitaceae</td>\n",
       "      <td>Vitis arizonica</td>\n",
       "      <td>Canyon Grape</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Native</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4,295,127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119245</th>\n",
       "      <td>ZION</td>\n",
       "      <td>Zion National Park</td>\n",
       "      <td>UT</td>\n",
       "      <td>146598</td>\n",
       "      <td>37.30</td>\n",
       "      <td>-113.05</td>\n",
       "      <td>ZION-2793</td>\n",
       "      <td>Vascular Plant</td>\n",
       "      <td>Vitales</td>\n",
       "      <td>Vitaceae</td>\n",
       "      <td>Vitis vinifera</td>\n",
       "      <td>Wine Grape</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Not Native</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4,295,127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119246</th>\n",
       "      <td>ZION</td>\n",
       "      <td>Zion National Park</td>\n",
       "      <td>UT</td>\n",
       "      <td>146598</td>\n",
       "      <td>37.30</td>\n",
       "      <td>-113.05</td>\n",
       "      <td>ZION-2794</td>\n",
       "      <td>Vascular Plant</td>\n",
       "      <td>Zygophyllales</td>\n",
       "      <td>Zygophyllaceae</td>\n",
       "      <td>Larrea tridentata</td>\n",
       "      <td>Creosote Bush</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Native</td>\n",
       "      <td>Rare</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4,295,127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119247</th>\n",
       "      <td>ZION</td>\n",
       "      <td>Zion National Park</td>\n",
       "      <td>UT</td>\n",
       "      <td>146598</td>\n",
       "      <td>37.30</td>\n",
       "      <td>-113.05</td>\n",
       "      <td>ZION-2795</td>\n",
       "      <td>Vascular Plant</td>\n",
       "      <td>Zygophyllales</td>\n",
       "      <td>Zygophyllaceae</td>\n",
       "      <td>Tribulus terrestris</td>\n",
       "      <td>Puncture Vine</td>\n",
       "      <td>Approved</td>\n",
       "      <td>Present</td>\n",
       "      <td>Not Native</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4,295,127</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>119248 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Park Code             Park Name State   Acres  Latitude  Longitude  \\\n",
       "0           ACAD  Acadia National Park    ME   47390     44.35     -68.21   \n",
       "1           ACAD  Acadia National Park    ME   47390     44.35     -68.21   \n",
       "2           ACAD  Acadia National Park    ME   47390     44.35     -68.21   \n",
       "3           ACAD  Acadia National Park    ME   47390     44.35     -68.21   \n",
       "4           ACAD  Acadia National Park    ME   47390     44.35     -68.21   \n",
       "...          ...                   ...   ...     ...       ...        ...   \n",
       "119243      ZION    Zion National Park    UT  146598     37.30    -113.05   \n",
       "119244      ZION    Zion National Park    UT  146598     37.30    -113.05   \n",
       "119245      ZION    Zion National Park    UT  146598     37.30    -113.05   \n",
       "119246      ZION    Zion National Park    UT  146598     37.30    -113.05   \n",
       "119247      ZION    Zion National Park    UT  146598     37.30    -113.05   \n",
       "\n",
       "       Species ID        Category          Order          Family  \\\n",
       "0       ACAD-1000          Mammal   Artiodactyla        Cervidae   \n",
       "1       ACAD-1001          Mammal   Artiodactyla        Cervidae   \n",
       "2       ACAD-1002          Mammal      Carnivora         Canidae   \n",
       "3       ACAD-1003          Mammal      Carnivora         Canidae   \n",
       "4       ACAD-1004          Mammal      Carnivora         Canidae   \n",
       "...           ...             ...            ...             ...   \n",
       "119243  ZION-2791  Vascular Plant      Solanales      Solanaceae   \n",
       "119244  ZION-2792  Vascular Plant        Vitales        Vitaceae   \n",
       "119245  ZION-2793  Vascular Plant        Vitales        Vitaceae   \n",
       "119246  ZION-2794  Vascular Plant  Zygophyllales  Zygophyllaceae   \n",
       "119247  ZION-2795  Vascular Plant  Zygophyllales  Zygophyllaceae   \n",
       "\n",
       "               Scientific Name  \\\n",
       "0                  Alces alces   \n",
       "1       Odocoileus virginianus   \n",
       "2                Canis latrans   \n",
       "3                  Canis lupus   \n",
       "4                Vulpes vulpes   \n",
       "...                        ...   \n",
       "119243       Solanum triflorum   \n",
       "119244         Vitis arizonica   \n",
       "119245          Vitis vinifera   \n",
       "119246       Larrea tridentata   \n",
       "119247     Tribulus terrestris   \n",
       "\n",
       "                                             Common Names Record Status  \\\n",
       "0                                                   Moose      Approved   \n",
       "1       Northern White-Tailed Deer, Virginia Deer, Whi...      Approved   \n",
       "2                                  Coyote, Eastern Coyote      Approved   \n",
       "3             Eastern Timber Wolf, Gray Wolf, Timber Wolf      Approved   \n",
       "4       Black Fox, Cross Fox, Eastern Red Fox, Fox, Re...      Approved   \n",
       "...                                                   ...           ...   \n",
       "119243                                Cut-Leaf Nightshade      Approved   \n",
       "119244                                       Canyon Grape      Approved   \n",
       "119245                                         Wine Grape      Approved   \n",
       "119246                                      Creosote Bush      Approved   \n",
       "119247                                      Puncture Vine      Approved   \n",
       "\n",
       "           Occurrence  Nativeness Abundance Seasonality Conservation Status  \\\n",
       "0             Present      Native      Rare    Resident                 NaN   \n",
       "1             Present      Native  Abundant         NaN                 NaN   \n",
       "2             Present  Not Native    Common         NaN  Species of Concern   \n",
       "3       Not Confirmed      Native       NaN         NaN          Endangered   \n",
       "4             Present     Unknown    Common     Breeder                 NaN   \n",
       "...               ...         ...       ...         ...                 ...   \n",
       "119243        Present      Native  Uncommon         NaN                 NaN   \n",
       "119244        Present      Native  Uncommon         NaN                 NaN   \n",
       "119245        Present  Not Native  Uncommon         NaN                 NaN   \n",
       "119246        Present      Native      Rare         NaN                 NaN   \n",
       "119247        Present  Not Native  Uncommon         NaN                 NaN   \n",
       "\n",
       "              TRV  \n",
       "0       3,303,393  \n",
       "1       3,303,393  \n",
       "2       3,303,393  \n",
       "3       3,303,393  \n",
       "4       3,303,393  \n",
       "...           ...  \n",
       "119243  4,295,127  \n",
       "119244  4,295,127  \n",
       "119245  4,295,127  \n",
       "119246  4,295,127  \n",
       "119247  4,295,127  \n",
       "\n",
       "[119248 rows x 19 columns]"
      ]
     },
     "execution_count": 148,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sp"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Step 4: Create CSV File\n",
    "Take sp and create a CSV file."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 209,
   "metadata": {},
   "outputs": [],
   "source": [
    "sp.to_csv('species_parks.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Step 5: Check Distinct Values\n",
    "Need to check distinct values for the following columns:\n",
    "- Category\n",
    "- Order\n",
    "- Family\n",
    "- Record Status\n",
    "- Occurrence\n",
    "- Nativeness\n",
    "- Abundance\n",
    "- Seasonality\n",
    "- Conservation Status"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 188,
   "metadata": {},
   "outputs": [],
   "source": [
    "def uniqcol(sp, col):\n",
    "    return sp[col].nunique()\n",
    "\n",
    "def cncol(sp, col):\n",
    "    return sp[col].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Category"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 195,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Vascular Plant         65221\n",
      "Bird                   14601\n",
      "Insect                 14349\n",
      "Fungi                   6203\n",
      "Nonvascular Plant       4278\n",
      "Fish                    3956\n",
      "Mammal                  3867\n",
      "Invertebrate            1566\n",
      "Reptile                 1343\n",
      "Algae                    976\n",
      "Slug/Snail               787\n",
      "Spider/Scorpion          776\n",
      "Amphibian                743\n",
      "Crab/Lobster/Shrimp      582\n",
      "Name: Category, dtype: int64\n",
      "Length: 14\n"
     ]
    }
   ],
   "source": [
    "print(cncol(sp,'Category'))\n",
    "print('Length:', uniqcol(sp,'Category'))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Order"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 197,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Poales                  11453\n",
      "Asterales                9174\n",
      "Passeriformes            7362\n",
      "Caryophyllales           5241\n",
      "Lamiales                 4404\n",
      "                        ...  \n",
      "Cryptonemiales              1\n",
      "Pseudoscorpionida           1\n",
      "Euphausiacea                1\n",
      "Saprolegniales              1\n",
      "Stephanoberyciformes        1\n",
      "Name: Order, Length: 554, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "print(cncol(sp,'Order'))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Family"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 198,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Asteraceae      8843\n",
      "Poaceae         6709\n",
      "Cyperaceae      3585\n",
      "Fabaceae        3359\n",
      "Brassicaceae    2644\n",
      "                ... \n",
      "Arisfotela         1\n",
      "Nolidae            1\n",
      "Ranellidae         1\n",
      "Fryeellaceae       1\n",
      "Dipluridae         1\n",
      "Name: Family, Length: 2332, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "print(cncol(sp,'Family'))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Record Status"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 200,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Approved                86254\n",
      "In Review               32937\n",
      "None                        6\n",
      " Catbird                    1\n",
      " American Crow              1\n",
      " Shadbush                   1\n",
      " Storksbill                 1\n",
      " Whortleberry               1\n",
      " Liver Leaf*                1\n",
      " Bushtit                    1\n",
      " Grass-Leaf Loco            1\n",
      " Manati                     1\n",
      " Ground Daisy               1\n",
      " Cenizo                     1\n",
      " Skyrocket Gilia            1\n",
      "P.Nut Sedge                 1\n",
      " Speckled Trout             1\n",
      " Dames Rocket               1\n",
      " Willowherb                 1\n",
      " Common Poorwill            1\n",
      " Speedwell                  1\n",
      " Ranchers' Fireweed         1\n",
      " Claret Cup                 1\n",
      " Kinnikinnick               1\n",
      " Cocodrilo De Tumbes        1\n",
      " Cranesbill                 1\n",
      " Golden Pea                 1\n",
      " Osha                       1\n",
      " Purple Cockle              1\n",
      " Goosefoot                  1\n",
      " Wild Rose                  1\n",
      " Bluebell                   1\n",
      " Pigeon Hawk                1\n",
      " Wiregrass                  1\n",
      " Short-Tailed Weasel        1\n",
      " Common Mullein             1\n",
      " Fringed Sage               1\n",
      " Chico                      1\n",
      " White-Footed Mouse         1\n",
      " Filaree                    1\n",
      " Wapiti                     1\n",
      " Skunkbush                  1\n",
      " *                          1\n",
      " Verdolagas                 1\n",
      " Northern Pintail           1\n",
      " Wild Iris                  1\n",
      " Robin                      1\n",
      " Downy Chess                1\n",
      " Rushpink                   1\n",
      " Leather Flower             1\n",
      " Devil's Shoelaces          1\n",
      " Northern Goshawk           1\n",
      " Cabezon                    1\n",
      " Clover Bush                1\n",
      "Name: Record Status, dtype: int64\n",
      "Length: 54\n"
     ]
    }
   ],
   "source": [
    "print(cncol(sp,'Record Status'))\n",
    "print('Length:', uniqcol(sp,'Record Status'))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Occurrence"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 203,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Present                            83278\n",
      "Not Confirmed                      11958\n",
      "Not Present (False Report)          2072\n",
      "Not Present (Historical Report)     1310\n",
      "Not Present                          431\n",
      "Approved                              51\n",
      "In Review                              6\n",
      "Name: Occurrence, dtype: int64\n",
      "Length: 7\n"
     ]
    }
   ],
   "source": [
    "print(cncol(sp,'Occurrence'))\n",
    "print('Length:', uniqcol(sp,'Occurrence'))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Nativeness"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 205,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Native           75950\n",
      "Not Native       11095\n",
      "Unknown           7101\n",
      "Present             53\n",
      "Not Confirmed        4\n",
      "Name: Nativeness, dtype: int64\n",
      "Length: 5\n"
     ]
    }
   ],
   "source": [
    "print(cncol(sp,'Nativeness'))\n",
    "print('Length:', uniqcol(sp,'Nativeness'))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Abundance"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 206,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Unknown       28119\n",
      "Uncommon      18779\n",
      "Common        12913\n",
      "Rare          10768\n",
      "Occasional     3312\n",
      "Abundant       2365\n",
      "Native           40\n",
      "Not Native       10\n",
      "Name: Abundance, dtype: int64\n",
      "Length: 8\n"
     ]
    }
   ],
   "source": [
    "print(cncol(sp,'Abundance'))\n",
    "print('Length:', uniqcol(sp,'Abundance'))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Seasonality"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 207,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Breeder                                 12214\n",
      "Resident                                 3215\n",
      "Migratory                                2825\n",
      "Vagrant                                  1660\n",
      "Breeder, Winter                            64\n",
      "Rare                                       35\n",
      "Summer                                     26\n",
      "Migratory, Winter                          24\n",
      "Breeder, Resident                          20\n",
      "Winter                                     20\n",
      "Breeder, Migratory                         13\n",
      "Resident, Winter                            9\n",
      "Uncommon                                    5\n",
      "Common                                      4\n",
      "Migratory, Vagrant                          4\n",
      "Summer, Vagrant                             3\n",
      "Unknown                                     3\n",
      "Breeder, Resident, Summer                   3\n",
      "Migratory, Summer                           3\n",
      "Resident, Summer                            2\n",
      "Breeder, Summer                             2\n",
      "Breeder, Resident, Summer, Winter           1\n",
      "Breeder, Resident, Migratory, Summer        1\n",
      "Winter, Vagrant                             1\n",
      "Name: Seasonality, dtype: int64\n",
      "Length: 24\n"
     ]
    }
   ],
   "source": [
    "print(cncol(sp,'Seasonality'))\n",
    "print('Length:', uniqcol(sp,'Seasonality'))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Conservation Status "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 208,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Species of Concern     3843\n",
      "Endangered              374\n",
      "Under Review            194\n",
      "Threatened              184\n",
      "In Recovery              77\n",
      "Proposed Endangered      24\n",
      "Breeder                   7\n",
      "Proposed Threatened       7\n",
      "Resident                  5\n",
      "Migratory                 2\n",
      "Extinct                   1\n",
      "Name: Conservation Status, dtype: int64\n",
      "Length: 11\n"
     ]
    }
   ],
   "source": [
    "print(cncol(sp,'Conservation Status'))\n",
    "print('Length:', uniqcol(sp,'Conservation Status'))"
   ]
  }
 ],
 "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.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}