National_Parks_Census_Merge.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [],
   "source": [
    "###Other possible imports needed later\n",
    "#from config import (census_key, gkey)\n",
    "#import gmaps\n",
    "#from census import Census\n",
    "#import numpy as np\n",
    "#import requests\n",
    "#import time\n",
    "#from scipy.stats import linregress\n",
    "#from matplotlib import pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [],
   "source": [
    "park_path = \"../bootcamp_project_1/Resources/national_parks_clean_with_zip.csv\"\n",
    "census_path = \"../bootcamp_project_1/Resources/dataclean1.csv\"\n",
    "\n",
    "parks_df = pd.read_csv(park_path)\n",
    "census_df = pd.read_csv(census_path)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0     04609\n",
      "1     84532\n",
      "2     57750\n",
      "3     79834\n",
      "4     33033\n",
      "5     81401\n",
      "6     84764\n",
      "7     84532\n",
      "8     84775\n",
      "9     88220\n",
      "10    93001\n",
      "11    29061\n",
      "12    97604\n",
      "13    44141\n",
      "14    92328\n",
      "15    99755\n",
      "16    33034\n",
      "17    33034\n",
      "18    99701\n",
      "19    63102\n",
      "20    59936\n",
      "21    99826\n",
      "22    86023\n",
      "23    83012\n",
      "24    89311\n",
      "25    81146\n",
      "26    37738\n",
      "27    79847\n",
      "28    96768\n",
      "29    96718\n",
      "30    71901\n",
      "31    46304\n",
      "32    49931\n",
      "33    92277\n",
      "34    99613\n",
      "35    99664\n",
      "36    93271\n",
      "37    99752\n",
      "38    99653\n",
      "39    96063\n",
      "40    42259\n",
      "41    81330\n",
      "42    98304\n",
      "43    98284\n",
      "44    98362\n",
      "45    86028\n",
      "46    95043\n",
      "47    95531\n",
      "48    80517\n",
      "49    85730\n",
      "50    93271\n",
      "51    22835\n",
      "52    58645\n",
      "53    56649\n",
      "54    88310\n",
      "55    57747\n",
      "56    99573\n",
      "57    82190\n",
      "58    95389\n",
      "59    84767\n",
      "Name: Zipcode, dtype: object\n"
     ]
    }
   ],
   "source": [
    "merge_ready_parks_df = parks_df.rename(columns={'postalCode': 'Zipcode'})\n",
    "\n",
    "new_zip = []\n",
    "for code in merge_ready_parks_df['Zipcode']:    \n",
    "    if ('-' in code) == True:\n",
    "        new_zip.append(code.split('-', 1)[0])\n",
    "\n",
    "    else:\n",
    "        new_zip.append(code)\n",
    "        \n",
    "merge_ready_parks_df['Zipcode'] = new_zip\n",
    "print(merge_ready_parks_df['Zipcode'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Unnamed: 0      int64\n",
       "Zipcode        object\n",
       "City           object\n",
       "State          object\n",
       "Latitude      float64\n",
       "Longitude     float64\n",
       "Total_POP     float64\n",
       "TMale         float64\n",
       "TMale21       float64\n",
       "TMale35       float64\n",
       "TMale65       float64\n",
       "TFemale21     float64\n",
       "TFemale35     float64\n",
       "TFemale65     float64\n",
       "TFemal        float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#merge_ready_parks_df['Zipcode'] = merge_ready_parks_df['Zipcode'].astype(str).astype(int)\n",
    "#merge_ready_parks_df.dtypes\n",
    "\n",
    "census_df['Zipcode'] = census_df['Zipcode'].astype(int).astype(str)\n",
    "census_df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "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>Name</th>\n",
       "      <th>Location</th>\n",
       "      <th>coordinates</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>Date established as park</th>\n",
       "      <th>Area, acres</th>\n",
       "      <th>area, acres</th>\n",
       "      <th>area, km^2</th>\n",
       "      <th>Recreation visitors</th>\n",
       "      <th>...</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Total_POP</th>\n",
       "      <th>TMale</th>\n",
       "      <th>TMale21</th>\n",
       "      <th>TMale35</th>\n",
       "      <th>TMale65</th>\n",
       "      <th>TFemale21</th>\n",
       "      <th>TFemale35</th>\n",
       "      <th>TFemale65</th>\n",
       "      <th>TFemal</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Acadia</td>\n",
       "      <td>Maine</td>\n",
       "      <td>44.35°N 68.21°W</td>\n",
       "      <td>44.35</td>\n",
       "      <td>-68.21</td>\n",
       "      <td>26-Feb-19</td>\n",
       "      <td>49,076.63 acres (198.6 km2)</td>\n",
       "      <td>49,076.63</td>\n",
       "      <td>198.6</td>\n",
       "      <td>3,537,575</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Arches</td>\n",
       "      <td>Utah</td>\n",
       "      <td>38.68°N 109.57°W</td>\n",
       "      <td>38.68</td>\n",
       "      <td>-109.57</td>\n",
       "      <td>12-Nov-71</td>\n",
       "      <td>76,678.98 acres (310.3 km2)</td>\n",
       "      <td>76,678.98</td>\n",
       "      <td>310.3</td>\n",
       "      <td>1,663,557</td>\n",
       "      <td>...</td>\n",
       "      <td>-109.49392</td>\n",
       "      <td>10043.0</td>\n",
       "      <td>4929.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>317.0</td>\n",
       "      <td>103.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>321.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>5114.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Canyonlands</td>\n",
       "      <td>Utah</td>\n",
       "      <td>38.2°N 109.93°W</td>\n",
       "      <td>38.20</td>\n",
       "      <td>-109.93</td>\n",
       "      <td>12-Sep-64</td>\n",
       "      <td>337,597.83 acres (1,366.2 km2)</td>\n",
       "      <td>337,597.83</td>\n",
       "      <td>1,366.20</td>\n",
       "      <td>739,449</td>\n",
       "      <td>...</td>\n",
       "      <td>-109.49392</td>\n",
       "      <td>10043.0</td>\n",
       "      <td>4929.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>317.0</td>\n",
       "      <td>103.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>321.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>5114.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Badlands</td>\n",
       "      <td>South Dakota</td>\n",
       "      <td>43.75°N 102.50°W</td>\n",
       "      <td>43.75</td>\n",
       "      <td>-102.50</td>\n",
       "      <td>10-Nov-78</td>\n",
       "      <td>242,755.94 acres (982.4 km2)</td>\n",
       "      <td>242,755.94</td>\n",
       "      <td>982.4</td>\n",
       "      <td>1,008,942</td>\n",
       "      <td>...</td>\n",
       "      <td>-101.94355</td>\n",
       "      <td>224.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>124.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Big Bend</td>\n",
       "      <td>Texas</td>\n",
       "      <td>29.25°N 103.25°W</td>\n",
       "      <td>29.25</td>\n",
       "      <td>-103.25</td>\n",
       "      <td>12-Jun-44</td>\n",
       "      <td>801,163.21 acres (3,242.2 km2)</td>\n",
       "      <td>801,163.21</td>\n",
       "      <td>3,242.20</td>\n",
       "      <td>440,091</td>\n",
       "      <td>...</td>\n",
       "      <td>-103.21085</td>\n",
       "      <td>213.0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>102.0</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32903</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>-83.63554</td>\n",
       "      <td>566.0</td>\n",
       "      <td>321.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>245.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32904</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>-73.50767</td>\n",
       "      <td>153.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>78.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32905</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>-79.93414</td>\n",
       "      <td>11324.0</td>\n",
       "      <td>5442.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>351.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>375.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>5882.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32906</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>-91.54559</td>\n",
       "      <td>210.0</td>\n",
       "      <td>112.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>98.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32907</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>-78.07012</td>\n",
       "      <td>348.0</td>\n",
       "      <td>186.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>162.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>32908 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              Name      Location       coordinates    lat     lon  \\\n",
       "0           Acadia         Maine   44.35°N 68.21°W  44.35  -68.21   \n",
       "1           Arches          Utah  38.68°N 109.57°W  38.68 -109.57   \n",
       "2      Canyonlands          Utah   38.2°N 109.93°W  38.20 -109.93   \n",
       "3         Badlands  South Dakota  43.75°N 102.50°W  43.75 -102.50   \n",
       "4         Big Bend         Texas  29.25°N 103.25°W  29.25 -103.25   \n",
       "...            ...           ...               ...    ...     ...   \n",
       "32903          NaN           NaN               NaN    NaN     NaN   \n",
       "32904          NaN           NaN               NaN    NaN     NaN   \n",
       "32905          NaN           NaN               NaN    NaN     NaN   \n",
       "32906          NaN           NaN               NaN    NaN     NaN   \n",
       "32907          NaN           NaN               NaN    NaN     NaN   \n",
       "\n",
       "      Date established as park                     Area, acres area, acres  \\\n",
       "0                    26-Feb-19     49,076.63 acres (198.6 km2)   49,076.63   \n",
       "1                    12-Nov-71     76,678.98 acres (310.3 km2)   76,678.98   \n",
       "2                    12-Sep-64  337,597.83 acres (1,366.2 km2)  337,597.83   \n",
       "3                    10-Nov-78    242,755.94 acres (982.4 km2)  242,755.94   \n",
       "4                    12-Jun-44  801,163.21 acres (3,242.2 km2)  801,163.21   \n",
       "...                        ...                             ...         ...   \n",
       "32903                      NaN                             NaN         NaN   \n",
       "32904                      NaN                             NaN         NaN   \n",
       "32905                      NaN                             NaN         NaN   \n",
       "32906                      NaN                             NaN         NaN   \n",
       "32907                      NaN                             NaN         NaN   \n",
       "\n",
       "      area, km^2 Recreation visitors  ...  Longitude Total_POP   TMale  \\\n",
       "0          198.6           3,537,575  ...        NaN       NaN     NaN   \n",
       "1          310.3           1,663,557  ... -109.49392   10043.0  4929.0   \n",
       "2       1,366.20             739,449  ... -109.49392   10043.0  4929.0   \n",
       "3          982.4           1,008,942  ... -101.94355     224.0   100.0   \n",
       "4       3,242.20             440,091  ... -103.21085     213.0   111.0   \n",
       "...          ...                 ...  ...        ...       ...     ...   \n",
       "32903        NaN                 NaN  ...  -83.63554     566.0   321.0   \n",
       "32904        NaN                 NaN  ...  -73.50767     153.0    75.0   \n",
       "32905        NaN                 NaN  ...  -79.93414   11324.0  5442.0   \n",
       "32906        NaN                 NaN  ...  -91.54559     210.0   112.0   \n",
       "32907        NaN                 NaN  ...  -78.07012     348.0   186.0   \n",
       "\n",
       "      TMale21  TMale35 TMale65 TFemale21 TFemale35  TFemale65  TFemal  \n",
       "0          NaN     NaN     NaN       NaN       NaN        NaN     NaN  \n",
       "1         80.0   317.0   103.0      29.0     321.0      162.0  5114.0  \n",
       "2         80.0   317.0   103.0      29.0     321.0      162.0  5114.0  \n",
       "3          0.0    11.0     0.0       0.0       3.0        0.0   124.0  \n",
       "4          0.0     9.0     0.0       0.0       4.0        8.0   102.0  \n",
       "...        ...     ...     ...       ...       ...        ...     ...  \n",
       "32903      0.0    15.0     0.0       0.0       0.0        5.0   245.0  \n",
       "32904      0.0     0.0     2.0       0.0       0.0        0.0    78.0  \n",
       "32905      0.0   351.0   125.0      26.0     375.0       99.0  5882.0  \n",
       "32906      2.0    10.0     1.0       2.0      14.0        1.0    98.0  \n",
       "32907      0.0     8.0     1.0       0.0      13.0       12.0   162.0  \n",
       "\n",
       "[32908 rows x 29 columns]"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined_park_census_df = pd.merge(merge_ready_parks_df, census_df, how='outer', on = 'Zipcode')\n",
    "\n",
    "combined_park_census_df = combined_park_census_df.drop(columns = ['Unnamed: 0_x'])\n",
    "combined_park_census_df = combined_park_census_df.drop(columns = ['Unnamed: 0_y'])\n",
    "\n",
    "combined_park_census_df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "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>Name</th>\n",
       "      <th>Location</th>\n",
       "      <th>coordinates</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>Date established as park</th>\n",
       "      <th>Area, acres</th>\n",
       "      <th>area, acres</th>\n",
       "      <th>area, km^2</th>\n",
       "      <th>Recreation visitors</th>\n",
       "      <th>...</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Total_POP</th>\n",
       "      <th>TMale</th>\n",
       "      <th>TMale21</th>\n",
       "      <th>TMale35</th>\n",
       "      <th>TMale65</th>\n",
       "      <th>TFemale21</th>\n",
       "      <th>TFemale35</th>\n",
       "      <th>TFemale65</th>\n",
       "      <th>TFemal</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Arches</td>\n",
       "      <td>Utah</td>\n",
       "      <td>38.68°N 109.57°W</td>\n",
       "      <td>38.6800</td>\n",
       "      <td>-109.5700</td>\n",
       "      <td>12-Nov-71</td>\n",
       "      <td>76,678.98 acres (310.3 km2)</td>\n",
       "      <td>76,678.98</td>\n",
       "      <td>310.3</td>\n",
       "      <td>1,663,557</td>\n",
       "      <td>...</td>\n",
       "      <td>-109.493920</td>\n",
       "      <td>10043.0</td>\n",
       "      <td>4929.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>317.0</td>\n",
       "      <td>103.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>321.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>5114.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Canyonlands</td>\n",
       "      <td>Utah</td>\n",
       "      <td>38.2°N 109.93°W</td>\n",
       "      <td>38.2000</td>\n",
       "      <td>-109.9300</td>\n",
       "      <td>12-Sep-64</td>\n",
       "      <td>337,597.83 acres (1,366.2 km2)</td>\n",
       "      <td>337,597.83</td>\n",
       "      <td>1,366.20</td>\n",
       "      <td>739,449</td>\n",
       "      <td>...</td>\n",
       "      <td>-109.493920</td>\n",
       "      <td>10043.0</td>\n",
       "      <td>4929.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>317.0</td>\n",
       "      <td>103.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>321.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>5114.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Badlands</td>\n",
       "      <td>South Dakota</td>\n",
       "      <td>43.75°N 102.50°W</td>\n",
       "      <td>43.7500</td>\n",
       "      <td>-102.5000</td>\n",
       "      <td>10-Nov-78</td>\n",
       "      <td>242,755.94 acres (982.4 km2)</td>\n",
       "      <td>242,755.94</td>\n",
       "      <td>982.4</td>\n",
       "      <td>1,008,942</td>\n",
       "      <td>...</td>\n",
       "      <td>-101.943550</td>\n",
       "      <td>224.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>124.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Big Bend</td>\n",
       "      <td>Texas</td>\n",
       "      <td>29.25°N 103.25°W</td>\n",
       "      <td>29.2500</td>\n",
       "      <td>-103.2500</td>\n",
       "      <td>12-Jun-44</td>\n",
       "      <td>801,163.21 acres (3,242.2 km2)</td>\n",
       "      <td>801,163.21</td>\n",
       "      <td>3,242.20</td>\n",
       "      <td>440,091</td>\n",
       "      <td>...</td>\n",
       "      <td>-103.210850</td>\n",
       "      <td>213.0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>102.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Biscayne</td>\n",
       "      <td>Florida</td>\n",
       "      <td>25.65°N 80.08°W</td>\n",
       "      <td>25.6500</td>\n",
       "      <td>-80.0800</td>\n",
       "      <td>28-Jun-80</td>\n",
       "      <td>172,971.11 acres (700.0 km2)</td>\n",
       "      <td>172,971.11</td>\n",
       "      <td>700</td>\n",
       "      <td>469,253</td>\n",
       "      <td>...</td>\n",
       "      <td>-80.426920</td>\n",
       "      <td>58224.0</td>\n",
       "      <td>28526.0</td>\n",
       "      <td>343.0</td>\n",
       "      <td>1966.0</td>\n",
       "      <td>506.0</td>\n",
       "      <td>457.0</td>\n",
       "      <td>2416.0</td>\n",
       "      <td>599.0</td>\n",
       "      <td>29698.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Black Canyon of The Gunnison</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>38.57°N 107.72°W</td>\n",
       "      <td>38.5700</td>\n",
       "      <td>-107.7200</td>\n",
       "      <td>21-Oct-99</td>\n",
       "      <td>30,779.83 acres (124.6 km2)</td>\n",
       "      <td>30,779.83</td>\n",
       "      <td>124.6</td>\n",
       "      <td>308,962</td>\n",
       "      <td>...</td>\n",
       "      <td>-107.862500</td>\n",
       "      <td>22633.0</td>\n",
       "      <td>10950.0</td>\n",
       "      <td>183.0</td>\n",
       "      <td>590.0</td>\n",
       "      <td>312.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>598.0</td>\n",
       "      <td>466.0</td>\n",
       "      <td>11683.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Bryce Canyon</td>\n",
       "      <td>Utah</td>\n",
       "      <td>37.57°N 112.18°W</td>\n",
       "      <td>37.5700</td>\n",
       "      <td>-112.1800</td>\n",
       "      <td>25-Feb-28</td>\n",
       "      <td>35,835.08 acres (145.0 km2)</td>\n",
       "      <td>35,835.08</td>\n",
       "      <td>145</td>\n",
       "      <td>2,679,478</td>\n",
       "      <td>...</td>\n",
       "      <td>-112.208570</td>\n",
       "      <td>270.0</td>\n",
       "      <td>128.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>142.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Capitol Reef</td>\n",
       "      <td>Utah</td>\n",
       "      <td>38.20°N 111.17°W</td>\n",
       "      <td>38.2000</td>\n",
       "      <td>-111.1700</td>\n",
       "      <td>18-Dec-71</td>\n",
       "      <td>241,904.50 acres (979.0 km2)</td>\n",
       "      <td>241,904.50</td>\n",
       "      <td>979</td>\n",
       "      <td>1,227,627</td>\n",
       "      <td>...</td>\n",
       "      <td>-111.002200</td>\n",
       "      <td>301.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>188.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Carlsbad Caverns</td>\n",
       "      <td>New Mexico</td>\n",
       "      <td>32.17°N 104.44°W</td>\n",
       "      <td>32.1700</td>\n",
       "      <td>-104.4400</td>\n",
       "      <td>14-May-30</td>\n",
       "      <td>46,766.45 acres (189.3 km2)</td>\n",
       "      <td>46,766.45</td>\n",
       "      <td>189.3</td>\n",
       "      <td>465,912</td>\n",
       "      <td>...</td>\n",
       "      <td>-104.291340</td>\n",
       "      <td>36708.0</td>\n",
       "      <td>18602.0</td>\n",
       "      <td>233.0</td>\n",
       "      <td>1236.0</td>\n",
       "      <td>345.0</td>\n",
       "      <td>240.0</td>\n",
       "      <td>1060.0</td>\n",
       "      <td>366.0</td>\n",
       "      <td>18106.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Channel Islands</td>\n",
       "      <td>California</td>\n",
       "      <td>34.01°N 119.42°W</td>\n",
       "      <td>34.0100</td>\n",
       "      <td>-119.4200</td>\n",
       "      <td>5-Mar-80</td>\n",
       "      <td>249,561.00 acres (1,009.9 km2)</td>\n",
       "      <td>249,561.00</td>\n",
       "      <td>1,009.90</td>\n",
       "      <td>366,250</td>\n",
       "      <td>...</td>\n",
       "      <td>-119.301640</td>\n",
       "      <td>33185.0</td>\n",
       "      <td>16763.0</td>\n",
       "      <td>189.0</td>\n",
       "      <td>1077.0</td>\n",
       "      <td>369.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>897.0</td>\n",
       "      <td>490.0</td>\n",
       "      <td>16422.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Congaree</td>\n",
       "      <td>South Carolina</td>\n",
       "      <td>33.78°N 80.78°W</td>\n",
       "      <td>33.7800</td>\n",
       "      <td>-80.7800</td>\n",
       "      <td>10-Nov-03</td>\n",
       "      <td>26,476.47 acres (107.1 km2)</td>\n",
       "      <td>26,476.47</td>\n",
       "      <td>107.1</td>\n",
       "      <td>145,929</td>\n",
       "      <td>...</td>\n",
       "      <td>-80.845350</td>\n",
       "      <td>14605.0</td>\n",
       "      <td>7235.0</td>\n",
       "      <td>138.0</td>\n",
       "      <td>336.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>457.0</td>\n",
       "      <td>206.0</td>\n",
       "      <td>7370.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Crater Lake</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>42.94°N 122.1°W</td>\n",
       "      <td>42.9400</td>\n",
       "      <td>-122.1000</td>\n",
       "      <td>22-May-02</td>\n",
       "      <td>183,224.05 acres (741.5 km2)</td>\n",
       "      <td>183,224.05</td>\n",
       "      <td>741.5</td>\n",
       "      <td>720,659</td>\n",
       "      <td>...</td>\n",
       "      <td>-122.274430</td>\n",
       "      <td>152.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>42.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Cuyahoga Valley</td>\n",
       "      <td>Ohio</td>\n",
       "      <td>41.24°N 81.55°W</td>\n",
       "      <td>41.2400</td>\n",
       "      <td>-81.5500</td>\n",
       "      <td>11-Oct-00</td>\n",
       "      <td>32,571.88 acres (131.8 km2)</td>\n",
       "      <td>32,571.88</td>\n",
       "      <td>131.8</td>\n",
       "      <td>2,096,053</td>\n",
       "      <td>...</td>\n",
       "      <td>-81.618350</td>\n",
       "      <td>13830.0</td>\n",
       "      <td>6861.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>292.0</td>\n",
       "      <td>315.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>273.0</td>\n",
       "      <td>227.0</td>\n",
       "      <td>6969.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Death Valley</td>\n",
       "      <td>California, Nevada</td>\n",
       "      <td>36.24°N 116.82°W</td>\n",
       "      <td>36.2400</td>\n",
       "      <td>-116.8200</td>\n",
       "      <td>31-Oct-94</td>\n",
       "      <td>3,408,406.73 acres (13,793.3 km2)</td>\n",
       "      <td>3,408,406.73</td>\n",
       "      <td>13,793.30</td>\n",
       "      <td>1,678,660</td>\n",
       "      <td>...</td>\n",
       "      <td>-117.202960</td>\n",
       "      <td>354.0</td>\n",
       "      <td>205.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>149.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Denali</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>63.33°N 150.50°W</td>\n",
       "      <td>63.3300</td>\n",
       "      <td>-150.5000</td>\n",
       "      <td>26-Feb-17</td>\n",
       "      <td>4,740,911.16 acres (19,185.8 km2)</td>\n",
       "      <td>4,740,911.16</td>\n",
       "      <td>19,185.80</td>\n",
       "      <td>594,660</td>\n",
       "      <td>...</td>\n",
       "      <td>-148.833960</td>\n",
       "      <td>856.0</td>\n",
       "      <td>414.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>442.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Dry Tortugas</td>\n",
       "      <td>Florida</td>\n",
       "      <td>24.63°N 82.87°W</td>\n",
       "      <td>24.6300</td>\n",
       "      <td>-82.8700</td>\n",
       "      <td>26-Oct-92</td>\n",
       "      <td>64,701.22 acres (261.8 km2)</td>\n",
       "      <td>64,701.22</td>\n",
       "      <td>261.8</td>\n",
       "      <td>56,810</td>\n",
       "      <td>...</td>\n",
       "      <td>-80.513820</td>\n",
       "      <td>23281.0</td>\n",
       "      <td>12004.0</td>\n",
       "      <td>188.0</td>\n",
       "      <td>904.0</td>\n",
       "      <td>148.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>679.0</td>\n",
       "      <td>433.0</td>\n",
       "      <td>11277.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Everglades</td>\n",
       "      <td>Florida</td>\n",
       "      <td>25.32°N 80.93°W</td>\n",
       "      <td>25.3200</td>\n",
       "      <td>-80.9300</td>\n",
       "      <td>30-May-34</td>\n",
       "      <td>1,508,938.57 acres (6,106.5 km2)</td>\n",
       "      <td>1,508,938.57</td>\n",
       "      <td>6,106.50</td>\n",
       "      <td>597,124</td>\n",
       "      <td>...</td>\n",
       "      <td>-80.513820</td>\n",
       "      <td>23281.0</td>\n",
       "      <td>12004.0</td>\n",
       "      <td>188.0</td>\n",
       "      <td>904.0</td>\n",
       "      <td>148.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>679.0</td>\n",
       "      <td>433.0</td>\n",
       "      <td>11277.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Gates of The Arctic</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>67.78°N 153.30°W</td>\n",
       "      <td>67.7800</td>\n",
       "      <td>-153.3000</td>\n",
       "      <td>2-Dec-80</td>\n",
       "      <td>7,523,897.45 acres (30,448.1 km2)</td>\n",
       "      <td>7,523,897.45</td>\n",
       "      <td>30,448.10</td>\n",
       "      <td>9,591</td>\n",
       "      <td>...</td>\n",
       "      <td>-147.720450</td>\n",
       "      <td>17510.0</td>\n",
       "      <td>8941.0</td>\n",
       "      <td>279.0</td>\n",
       "      <td>603.0</td>\n",
       "      <td>271.0</td>\n",
       "      <td>243.0</td>\n",
       "      <td>431.0</td>\n",
       "      <td>244.0</td>\n",
       "      <td>8569.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Gateway Arch</td>\n",
       "      <td>Missouri</td>\n",
       "      <td>38.63°N 90.19°W</td>\n",
       "      <td>38.6300</td>\n",
       "      <td>-90.1900</td>\n",
       "      <td>February 22, 2018[45]</td>\n",
       "      <td>192.83 acres (0.8 km2)</td>\n",
       "      <td>192.83</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2,016,180</td>\n",
       "      <td>...</td>\n",
       "      <td>-90.187020</td>\n",
       "      <td>2201.0</td>\n",
       "      <td>1551.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>156.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>650.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Glacier</td>\n",
       "      <td>Montana</td>\n",
       "      <td>48.80°N 114.00°W</td>\n",
       "      <td>48.8000</td>\n",
       "      <td>-114.0000</td>\n",
       "      <td>11-May-10</td>\n",
       "      <td>1,013,125.99 acres (4,100.0 km2)</td>\n",
       "      <td>1,013,125.99</td>\n",
       "      <td>4,100.00</td>\n",
       "      <td>2,965,309</td>\n",
       "      <td>...</td>\n",
       "      <td>-113.925990</td>\n",
       "      <td>401.0</td>\n",
       "      <td>208.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>193.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Glacier Bay</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>58.50°N 137.00°W</td>\n",
       "      <td>58.5000</td>\n",
       "      <td>-137.0000</td>\n",
       "      <td>2-Dec-80</td>\n",
       "      <td>3,223,383.43 acres (13,044.6 km2)</td>\n",
       "      <td>3,223,383.43</td>\n",
       "      <td>13,044.60</td>\n",
       "      <td>597,915</td>\n",
       "      <td>...</td>\n",
       "      <td>-135.730880</td>\n",
       "      <td>416.0</td>\n",
       "      <td>192.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>224.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Grand Canyon</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>36.06°N 112.14°W</td>\n",
       "      <td>36.0600</td>\n",
       "      <td>-112.1400</td>\n",
       "      <td>26-Feb-19</td>\n",
       "      <td>1,201,647.03 acres (4,862.9 km2)</td>\n",
       "      <td>1,201,647.03</td>\n",
       "      <td>4,862.90</td>\n",
       "      <td>6,380,495</td>\n",
       "      <td>...</td>\n",
       "      <td>-112.064980</td>\n",
       "      <td>2485.0</td>\n",
       "      <td>1212.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>118.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1273.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Grand Teton</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>43.73°N 110.80°W</td>\n",
       "      <td>43.7300</td>\n",
       "      <td>-110.8000</td>\n",
       "      <td>26-Feb-29</td>\n",
       "      <td>310,044.36 acres (1,254.7 km2)</td>\n",
       "      <td>310,044.36</td>\n",
       "      <td>1,254.70</td>\n",
       "      <td>3,491,151</td>\n",
       "      <td>...</td>\n",
       "      <td>-110.832150</td>\n",
       "      <td>226.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>151.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Great Basin</td>\n",
       "      <td>Nevada</td>\n",
       "      <td>38.98°N 114.30°W</td>\n",
       "      <td>38.9800</td>\n",
       "      <td>-114.3000</td>\n",
       "      <td>27-Oct-86</td>\n",
       "      <td>77,180.00 acres (312.3 km2)</td>\n",
       "      <td>77,180.00</td>\n",
       "      <td>312.3</td>\n",
       "      <td>153,094</td>\n",
       "      <td>...</td>\n",
       "      <td>-114.125920</td>\n",
       "      <td>121.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Great Sand Dunes</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>37.73°N 105.51°W</td>\n",
       "      <td>37.7300</td>\n",
       "      <td>-105.5100</td>\n",
       "      <td>13-Sep-04</td>\n",
       "      <td>107,341.87 acres (434.4 km2)</td>\n",
       "      <td>107,341.87</td>\n",
       "      <td>434.4</td>\n",
       "      <td>442,905</td>\n",
       "      <td>...</td>\n",
       "      <td>-105.731010</td>\n",
       "      <td>772.0</td>\n",
       "      <td>377.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>395.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Great Smoky Mountains</td>\n",
       "      <td>North Carolina, Tennessee</td>\n",
       "      <td>35.68°N 83.53°W</td>\n",
       "      <td>35.6800</td>\n",
       "      <td>-83.5300</td>\n",
       "      <td>15-Jun-34</td>\n",
       "      <td>522,426.88 acres (2,114.2 km2)</td>\n",
       "      <td>522,426.88</td>\n",
       "      <td>2,114.20</td>\n",
       "      <td>11,421,200</td>\n",
       "      <td>...</td>\n",
       "      <td>-83.471560</td>\n",
       "      <td>5555.0</td>\n",
       "      <td>2802.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>149.0</td>\n",
       "      <td>108.0</td>\n",
       "      <td>2753.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Guadalupe Mountains</td>\n",
       "      <td>Texas</td>\n",
       "      <td>31.92°N 104.87°W</td>\n",
       "      <td>31.9200</td>\n",
       "      <td>-104.8700</td>\n",
       "      <td>15-Oct-66</td>\n",
       "      <td>86,367.10 acres (349.5 km2)</td>\n",
       "      <td>86,367.10</td>\n",
       "      <td>349.5</td>\n",
       "      <td>172,347</td>\n",
       "      <td>...</td>\n",
       "      <td>-105.308820</td>\n",
       "      <td>156.0</td>\n",
       "      <td>129.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Haleakala</td>\n",
       "      <td>Hawaii</td>\n",
       "      <td>20.72°N 156.17°W</td>\n",
       "      <td>20.7200</td>\n",
       "      <td>-156.1700</td>\n",
       "      <td>1-Jul-61</td>\n",
       "      <td>33,264.62 acres (134.6 km2)</td>\n",
       "      <td>33,264.62</td>\n",
       "      <td>134.6</td>\n",
       "      <td>1,044,084</td>\n",
       "      <td>...</td>\n",
       "      <td>-156.331580</td>\n",
       "      <td>18155.0</td>\n",
       "      <td>9313.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>228.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>522.0</td>\n",
       "      <td>336.0</td>\n",
       "      <td>8842.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Hot Springs</td>\n",
       "      <td>Arkansas</td>\n",
       "      <td>34.51°N 93.05°W</td>\n",
       "      <td>34.5100</td>\n",
       "      <td>-93.0500</td>\n",
       "      <td>4-Mar-21</td>\n",
       "      <td>5,554.15 acres (22.5 km2)</td>\n",
       "      <td>5,554.15</td>\n",
       "      <td>22.5</td>\n",
       "      <td>1,506,887</td>\n",
       "      <td>...</td>\n",
       "      <td>-93.019410</td>\n",
       "      <td>30003.0</td>\n",
       "      <td>14240.0</td>\n",
       "      <td>119.0</td>\n",
       "      <td>671.0</td>\n",
       "      <td>268.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>1198.0</td>\n",
       "      <td>376.0</td>\n",
       "      <td>15763.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Indiana Dunes</td>\n",
       "      <td>Indiana</td>\n",
       "      <td>41.6533°N 87.0524°W</td>\n",
       "      <td>41.6533</td>\n",
       "      <td>-87.0524</td>\n",
       "      <td>15-Feb-19</td>\n",
       "      <td>15,349.08 acres (62.1 km2)</td>\n",
       "      <td>15,349.08</td>\n",
       "      <td>62.1</td>\n",
       "      <td>1,756,079</td>\n",
       "      <td>...</td>\n",
       "      <td>-87.058830</td>\n",
       "      <td>24906.0</td>\n",
       "      <td>12714.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>882.0</td>\n",
       "      <td>283.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>851.0</td>\n",
       "      <td>444.0</td>\n",
       "      <td>12192.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Isle Royale</td>\n",
       "      <td>Michigan</td>\n",
       "      <td>48.10°N 88.55°W</td>\n",
       "      <td>48.1000</td>\n",
       "      <td>-88.5500</td>\n",
       "      <td>3-Apr-40</td>\n",
       "      <td>571,790.30 acres (2,314.0 km2)</td>\n",
       "      <td>571,790.30</td>\n",
       "      <td>2,314.00</td>\n",
       "      <td>25,798</td>\n",
       "      <td>...</td>\n",
       "      <td>-88.572590</td>\n",
       "      <td>9642.0</td>\n",
       "      <td>6043.0</td>\n",
       "      <td>628.0</td>\n",
       "      <td>153.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>149.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>3599.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Joshua Tree</td>\n",
       "      <td>California</td>\n",
       "      <td>33.79°N 115.90°W</td>\n",
       "      <td>33.7900</td>\n",
       "      <td>-115.9000</td>\n",
       "      <td>31-Oct-94</td>\n",
       "      <td>795,155.85 acres (3,217.9 km2)</td>\n",
       "      <td>795,155.85</td>\n",
       "      <td>3,217.90</td>\n",
       "      <td>2,942,382</td>\n",
       "      <td>...</td>\n",
       "      <td>-116.033430</td>\n",
       "      <td>23517.0</td>\n",
       "      <td>11950.0</td>\n",
       "      <td>286.0</td>\n",
       "      <td>755.0</td>\n",
       "      <td>121.0</td>\n",
       "      <td>359.0</td>\n",
       "      <td>529.0</td>\n",
       "      <td>225.0</td>\n",
       "      <td>11567.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Katmai</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>58.50°N 155.00°W</td>\n",
       "      <td>58.5000</td>\n",
       "      <td>-155.0000</td>\n",
       "      <td>2-Dec-80</td>\n",
       "      <td>3,674,529.33 acres (14,870.3 km2)</td>\n",
       "      <td>3,674,529.33</td>\n",
       "      <td>14,870.30</td>\n",
       "      <td>37,818</td>\n",
       "      <td>...</td>\n",
       "      <td>-156.640070</td>\n",
       "      <td>455.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>189.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Kenai Fjords</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>59.92°N 149.65°W</td>\n",
       "      <td>59.9200</td>\n",
       "      <td>-149.6500</td>\n",
       "      <td>2-Dec-80</td>\n",
       "      <td>669,650.05 acres (2,710.0 km2)</td>\n",
       "      <td>669,650.05</td>\n",
       "      <td>2,710.00</td>\n",
       "      <td>321,596</td>\n",
       "      <td>...</td>\n",
       "      <td>-149.412710</td>\n",
       "      <td>4575.0</td>\n",
       "      <td>2670.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>1905.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Kings Canyon</td>\n",
       "      <td>California</td>\n",
       "      <td>36.80°N 118.55°W</td>\n",
       "      <td>36.8000</td>\n",
       "      <td>-118.5500</td>\n",
       "      <td>4-Mar-40</td>\n",
       "      <td>461,901.20 acres (1,869.2 km2)</td>\n",
       "      <td>461,901.20</td>\n",
       "      <td>1,869.20</td>\n",
       "      <td>699,023</td>\n",
       "      <td>...</td>\n",
       "      <td>-118.862960</td>\n",
       "      <td>2432.0</td>\n",
       "      <td>1292.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>1140.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Sequoia</td>\n",
       "      <td>California</td>\n",
       "      <td>36.43°N 118.68°W</td>\n",
       "      <td>36.4300</td>\n",
       "      <td>-118.6800</td>\n",
       "      <td>September 25, 1890</td>\n",
       "      <td>404,062.63 acres (1,635.2 km2)</td>\n",
       "      <td>404,062.63</td>\n",
       "      <td>1,635.20</td>\n",
       "      <td>1,229,594</td>\n",
       "      <td>...</td>\n",
       "      <td>-118.862960</td>\n",
       "      <td>2432.0</td>\n",
       "      <td>1292.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>1140.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Kobuk Valley</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>67.55°N 159.28°W</td>\n",
       "      <td>67.5500</td>\n",
       "      <td>-159.2800</td>\n",
       "      <td>2-Dec-80</td>\n",
       "      <td>1,750,716.16 acres (7,084.9 km2)</td>\n",
       "      <td>1,750,716.16</td>\n",
       "      <td>7,084.90</td>\n",
       "      <td>14,937</td>\n",
       "      <td>...</td>\n",
       "      <td>-162.585440</td>\n",
       "      <td>3370.0</td>\n",
       "      <td>1811.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>116.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>1559.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Lake Clark</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>60.97°N 153.42°W</td>\n",
       "      <td>60.9700</td>\n",
       "      <td>-153.4200</td>\n",
       "      <td>2-Dec-80</td>\n",
       "      <td>2,619,816.49 acres (10,602.0 km2)</td>\n",
       "      <td>2,619,816.49</td>\n",
       "      <td>10,602.00</td>\n",
       "      <td>14,479</td>\n",
       "      <td>...</td>\n",
       "      <td>-154.557080</td>\n",
       "      <td>151.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>79.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Lassen Volcanic</td>\n",
       "      <td>California</td>\n",
       "      <td>40.49°N 121.51°W</td>\n",
       "      <td>40.4900</td>\n",
       "      <td>-121.5100</td>\n",
       "      <td>9-Aug-16</td>\n",
       "      <td>106,589.02 acres (431.4 km2)</td>\n",
       "      <td>106,589.02</td>\n",
       "      <td>431.4</td>\n",
       "      <td>499,435</td>\n",
       "      <td>...</td>\n",
       "      <td>-121.582450</td>\n",
       "      <td>292.0</td>\n",
       "      <td>184.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>108.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Mammoth Cave</td>\n",
       "      <td>Kentucky</td>\n",
       "      <td>37.18°N 86.10°W</td>\n",
       "      <td>37.1800</td>\n",
       "      <td>-86.1000</td>\n",
       "      <td>1-Jul-41</td>\n",
       "      <td>54,011.91 acres (218.6 km2)</td>\n",
       "      <td>54,011.91</td>\n",
       "      <td>218.6</td>\n",
       "      <td>533,206</td>\n",
       "      <td>...</td>\n",
       "      <td>-86.198180</td>\n",
       "      <td>1256.0</td>\n",
       "      <td>732.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>524.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Mesa Verde</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>37.18°N 108.49°W</td>\n",
       "      <td>37.1800</td>\n",
       "      <td>-108.4900</td>\n",
       "      <td>29-Jun-06</td>\n",
       "      <td>52,485.17 acres (212.4 km2)</td>\n",
       "      <td>52,485.17</td>\n",
       "      <td>212.4</td>\n",
       "      <td>563,420</td>\n",
       "      <td>...</td>\n",
       "      <td>-108.504240</td>\n",
       "      <td>94.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>47.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Mount Rainier</td>\n",
       "      <td>Washington</td>\n",
       "      <td>46.85°N 121.75°W</td>\n",
       "      <td>46.8500</td>\n",
       "      <td>-121.7500</td>\n",
       "      <td>March 2, 1899</td>\n",
       "      <td>236,381.64 acres (956.6 km2)</td>\n",
       "      <td>236,381.64</td>\n",
       "      <td>956.6</td>\n",
       "      <td>1,518,491</td>\n",
       "      <td>...</td>\n",
       "      <td>-122.015440</td>\n",
       "      <td>634.0</td>\n",
       "      <td>356.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>278.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>North Cascades</td>\n",
       "      <td>Washington</td>\n",
       "      <td>48.70°N 121.20°W</td>\n",
       "      <td>48.7000</td>\n",
       "      <td>-121.2000</td>\n",
       "      <td>2-Oct-68</td>\n",
       "      <td>504,780.94 acres (2,042.8 km2)</td>\n",
       "      <td>504,780.94</td>\n",
       "      <td>2,042.80</td>\n",
       "      <td>30,085</td>\n",
       "      <td>...</td>\n",
       "      <td>-122.165450</td>\n",
       "      <td>26961.0</td>\n",
       "      <td>13470.0</td>\n",
       "      <td>312.0</td>\n",
       "      <td>964.0</td>\n",
       "      <td>321.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>658.0</td>\n",
       "      <td>291.0</td>\n",
       "      <td>13491.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Olympic</td>\n",
       "      <td>Washington</td>\n",
       "      <td>47.97°N 123.50°W</td>\n",
       "      <td>47.9700</td>\n",
       "      <td>-123.5000</td>\n",
       "      <td>29-Jun-38</td>\n",
       "      <td>922,649.41 acres (3,733.8 km2)</td>\n",
       "      <td>922,649.41</td>\n",
       "      <td>3,733.80</td>\n",
       "      <td>3,104,455</td>\n",
       "      <td>...</td>\n",
       "      <td>-123.406280</td>\n",
       "      <td>23740.0</td>\n",
       "      <td>11671.0</td>\n",
       "      <td>204.0</td>\n",
       "      <td>537.0</td>\n",
       "      <td>356.0</td>\n",
       "      <td>129.0</td>\n",
       "      <td>534.0</td>\n",
       "      <td>465.0</td>\n",
       "      <td>12069.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Petrified Forest</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>35.07°N 109.78°W</td>\n",
       "      <td>35.0700</td>\n",
       "      <td>-109.7800</td>\n",
       "      <td>9-Dec-62</td>\n",
       "      <td>221,390.21 acres (895.9 km2)</td>\n",
       "      <td>221,390.21</td>\n",
       "      <td>895.9</td>\n",
       "      <td>644,922</td>\n",
       "      <td>...</td>\n",
       "      <td>-109.522950</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Pinnacles</td>\n",
       "      <td>California</td>\n",
       "      <td>36.48°N 121.16°W</td>\n",
       "      <td>36.4800</td>\n",
       "      <td>-121.1600</td>\n",
       "      <td>10-Jan-13</td>\n",
       "      <td>26,685.73 acres (108.0 km2)</td>\n",
       "      <td>26,685.73</td>\n",
       "      <td>108</td>\n",
       "      <td>222,152</td>\n",
       "      <td>...</td>\n",
       "      <td>-121.015150</td>\n",
       "      <td>732.0</td>\n",
       "      <td>376.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>356.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Redwood</td>\n",
       "      <td>California</td>\n",
       "      <td>41.30°N 124.00°W</td>\n",
       "      <td>41.3000</td>\n",
       "      <td>-124.0000</td>\n",
       "      <td>2-Oct-68</td>\n",
       "      <td>138,999.37 acres (562.5 km2)</td>\n",
       "      <td>138,999.37</td>\n",
       "      <td>562.5</td>\n",
       "      <td>482,536</td>\n",
       "      <td>...</td>\n",
       "      <td>-124.167030</td>\n",
       "      <td>23470.0</td>\n",
       "      <td>12672.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>1146.0</td>\n",
       "      <td>359.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>654.0</td>\n",
       "      <td>290.0</td>\n",
       "      <td>10798.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Rocky Mountain</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>40.40°N 105.58°W</td>\n",
       "      <td>40.4000</td>\n",
       "      <td>-105.5800</td>\n",
       "      <td>26-Jan-15</td>\n",
       "      <td>265,807.25 acres (1,075.7 km2)</td>\n",
       "      <td>265,807.25</td>\n",
       "      <td>1,075.70</td>\n",
       "      <td>4,590,493</td>\n",
       "      <td>...</td>\n",
       "      <td>-105.517220</td>\n",
       "      <td>10012.0</td>\n",
       "      <td>4717.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>227.0</td>\n",
       "      <td>229.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>179.0</td>\n",
       "      <td>234.0</td>\n",
       "      <td>5295.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Saguaro</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>32.25°N 110.50°W</td>\n",
       "      <td>32.2500</td>\n",
       "      <td>-110.5000</td>\n",
       "      <td>14-Oct-94</td>\n",
       "      <td>91,715.72 acres (371.2 km2)</td>\n",
       "      <td>91,715.72</td>\n",
       "      <td>371.2</td>\n",
       "      <td>957,405</td>\n",
       "      <td>...</td>\n",
       "      <td>-110.810320</td>\n",
       "      <td>38219.0</td>\n",
       "      <td>18411.0</td>\n",
       "      <td>469.0</td>\n",
       "      <td>1086.0</td>\n",
       "      <td>364.0</td>\n",
       "      <td>384.0</td>\n",
       "      <td>1153.0</td>\n",
       "      <td>709.0</td>\n",
       "      <td>19808.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Shenandoah</td>\n",
       "      <td>Virginia</td>\n",
       "      <td>38.53°N 78.35°W</td>\n",
       "      <td>38.5300</td>\n",
       "      <td>-78.3500</td>\n",
       "      <td>26-Dec-35</td>\n",
       "      <td>199,223.77 acres (806.2 km2)</td>\n",
       "      <td>199,223.77</td>\n",
       "      <td>806.2</td>\n",
       "      <td>1,264,880</td>\n",
       "      <td>...</td>\n",
       "      <td>-78.456210</td>\n",
       "      <td>11636.0</td>\n",
       "      <td>5750.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>282.0</td>\n",
       "      <td>194.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>419.0</td>\n",
       "      <td>172.0</td>\n",
       "      <td>5886.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Theodore Roosevelt</td>\n",
       "      <td>North Dakota</td>\n",
       "      <td>46.97°N 103.45°W</td>\n",
       "      <td>46.9700</td>\n",
       "      <td>-103.4500</td>\n",
       "      <td>10-Nov-78</td>\n",
       "      <td>70,446.89 acres (285.1 km2)</td>\n",
       "      <td>70,446.89</td>\n",
       "      <td>285.1</td>\n",
       "      <td>749,389</td>\n",
       "      <td>...</td>\n",
       "      <td>-103.568720</td>\n",
       "      <td>282.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Voyageurs</td>\n",
       "      <td>Minnesota</td>\n",
       "      <td>48.50°N 92.88°W</td>\n",
       "      <td>48.5000</td>\n",
       "      <td>-92.8800</td>\n",
       "      <td>8-Jan-71</td>\n",
       "      <td>218,222.35 acres (883.1 km2)</td>\n",
       "      <td>218,222.35</td>\n",
       "      <td>883.1</td>\n",
       "      <td>239,656</td>\n",
       "      <td>...</td>\n",
       "      <td>-93.381420</td>\n",
       "      <td>9210.0</td>\n",
       "      <td>4587.0</td>\n",
       "      <td>117.0</td>\n",
       "      <td>236.0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>172.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>4623.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>White Sands</td>\n",
       "      <td>New Mexico</td>\n",
       "      <td>32.78°N 106.17°W</td>\n",
       "      <td>32.7800</td>\n",
       "      <td>-106.1700</td>\n",
       "      <td>December 20, 2019[107]</td>\n",
       "      <td>146,344.31 acres (592.2 km2)</td>\n",
       "      <td>146,344.31</td>\n",
       "      <td>592.2</td>\n",
       "      <td>603,008</td>\n",
       "      <td>...</td>\n",
       "      <td>-105.975610</td>\n",
       "      <td>36282.0</td>\n",
       "      <td>17986.0</td>\n",
       "      <td>480.0</td>\n",
       "      <td>962.0</td>\n",
       "      <td>434.0</td>\n",
       "      <td>196.0</td>\n",
       "      <td>1213.0</td>\n",
       "      <td>524.0</td>\n",
       "      <td>18296.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Wind Cave</td>\n",
       "      <td>South Dakota</td>\n",
       "      <td>43.57°N 103.48°W</td>\n",
       "      <td>43.5700</td>\n",
       "      <td>-103.4800</td>\n",
       "      <td>9-Jan-03</td>\n",
       "      <td>33,970.84 acres (137.5 km2)</td>\n",
       "      <td>33,970.84</td>\n",
       "      <td>137.5</td>\n",
       "      <td>656,397</td>\n",
       "      <td>...</td>\n",
       "      <td>-103.505100</td>\n",
       "      <td>5915.0</td>\n",
       "      <td>2936.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>2979.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Wrangell</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>61.00°N 142.00°W</td>\n",
       "      <td>61.0000</td>\n",
       "      <td>-142.0000</td>\n",
       "      <td>2-Dec-80</td>\n",
       "      <td>8,323,146.48 acres (33,682.6 km2)</td>\n",
       "      <td>8,323,146.48</td>\n",
       "      <td>33,682.60</td>\n",
       "      <td>79,450</td>\n",
       "      <td>...</td>\n",
       "      <td>-145.230800</td>\n",
       "      <td>540.0</td>\n",
       "      <td>261.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>279.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Yellowstone</td>\n",
       "      <td>Wyoming, Montana, Idaho</td>\n",
       "      <td>44.60°N 110.50°W</td>\n",
       "      <td>44.6000</td>\n",
       "      <td>-110.5000</td>\n",
       "      <td>March 1, 1872</td>\n",
       "      <td>2,219,790.71 acres (8,983.2 km2)</td>\n",
       "      <td>2,219,790.71</td>\n",
       "      <td>8,983.20</td>\n",
       "      <td>4,115,000</td>\n",
       "      <td>...</td>\n",
       "      <td>-110.894210</td>\n",
       "      <td>1075.0</td>\n",
       "      <td>533.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>542.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Yosemite</td>\n",
       "      <td>California</td>\n",
       "      <td>37.83°N 119.50°W</td>\n",
       "      <td>37.8300</td>\n",
       "      <td>-119.5000</td>\n",
       "      <td>October 1, 1890</td>\n",
       "      <td>761,747.50 acres (3,082.7 km2)</td>\n",
       "      <td>761,747.50</td>\n",
       "      <td>3,082.70</td>\n",
       "      <td>4,009,436</td>\n",
       "      <td>...</td>\n",
       "      <td>-119.675290</td>\n",
       "      <td>1392.0</td>\n",
       "      <td>882.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>510.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Zion</td>\n",
       "      <td>Utah</td>\n",
       "      <td>37.30°N 113.05°W</td>\n",
       "      <td>37.3000</td>\n",
       "      <td>-113.0500</td>\n",
       "      <td>19-Nov-19</td>\n",
       "      <td>147,242.66 acres (595.9 km2)</td>\n",
       "      <td>147,242.66</td>\n",
       "      <td>595.9</td>\n",
       "      <td>4,320,033</td>\n",
       "      <td>...</td>\n",
       "      <td>-113.013922</td>\n",
       "      <td>540.0</td>\n",
       "      <td>291.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>249.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>58 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            Name                   Location  \\\n",
       "1                         Arches                       Utah   \n",
       "2                    Canyonlands                       Utah   \n",
       "3                       Badlands               South Dakota   \n",
       "4                       Big Bend                      Texas   \n",
       "5                       Biscayne                    Florida   \n",
       "6   Black Canyon of The Gunnison                   Colorado   \n",
       "7                   Bryce Canyon                       Utah   \n",
       "8                   Capitol Reef                       Utah   \n",
       "9               Carlsbad Caverns                 New Mexico   \n",
       "10               Channel Islands                 California   \n",
       "11                      Congaree             South Carolina   \n",
       "12                   Crater Lake                     Oregon   \n",
       "13               Cuyahoga Valley                       Ohio   \n",
       "14                  Death Valley         California, Nevada   \n",
       "15                        Denali                     Alaska   \n",
       "16                  Dry Tortugas                    Florida   \n",
       "17                    Everglades                    Florida   \n",
       "18           Gates of The Arctic                     Alaska   \n",
       "19                  Gateway Arch                   Missouri   \n",
       "20                       Glacier                    Montana   \n",
       "21                   Glacier Bay                     Alaska   \n",
       "22                  Grand Canyon                    Arizona   \n",
       "23                   Grand Teton                    Wyoming   \n",
       "24                   Great Basin                     Nevada   \n",
       "25              Great Sand Dunes                   Colorado   \n",
       "26         Great Smoky Mountains  North Carolina, Tennessee   \n",
       "27           Guadalupe Mountains                      Texas   \n",
       "28                     Haleakala                     Hawaii   \n",
       "30                   Hot Springs                   Arkansas   \n",
       "31                 Indiana Dunes                    Indiana   \n",
       "32                   Isle Royale                   Michigan   \n",
       "33                   Joshua Tree                 California   \n",
       "34                        Katmai                     Alaska   \n",
       "35                  Kenai Fjords                     Alaska   \n",
       "36                  Kings Canyon                 California   \n",
       "37                       Sequoia                 California   \n",
       "38                  Kobuk Valley                     Alaska   \n",
       "39                    Lake Clark                     Alaska   \n",
       "40               Lassen Volcanic                 California   \n",
       "41                  Mammoth Cave                   Kentucky   \n",
       "42                    Mesa Verde                   Colorado   \n",
       "43                 Mount Rainier                 Washington   \n",
       "44                North Cascades                 Washington   \n",
       "45                       Olympic                 Washington   \n",
       "46              Petrified Forest                    Arizona   \n",
       "47                     Pinnacles                 California   \n",
       "48                       Redwood                 California   \n",
       "49                Rocky Mountain                   Colorado   \n",
       "50                       Saguaro                    Arizona   \n",
       "51                    Shenandoah                   Virginia   \n",
       "52            Theodore Roosevelt               North Dakota   \n",
       "53                     Voyageurs                  Minnesota   \n",
       "54                   White Sands                 New Mexico   \n",
       "55                     Wind Cave               South Dakota   \n",
       "56                      Wrangell                     Alaska   \n",
       "57                   Yellowstone    Wyoming, Montana, Idaho   \n",
       "58                      Yosemite                 California   \n",
       "59                          Zion                       Utah   \n",
       "\n",
       "            coordinates      lat       lon Date established as park  \\\n",
       "1      38.68°N 109.57°W  38.6800 -109.5700                12-Nov-71   \n",
       "2       38.2°N 109.93°W  38.2000 -109.9300                12-Sep-64   \n",
       "3      43.75°N 102.50°W  43.7500 -102.5000                10-Nov-78   \n",
       "4      29.25°N 103.25°W  29.2500 -103.2500                12-Jun-44   \n",
       "5       25.65°N 80.08°W  25.6500  -80.0800                28-Jun-80   \n",
       "6      38.57°N 107.72°W  38.5700 -107.7200                21-Oct-99   \n",
       "7      37.57°N 112.18°W  37.5700 -112.1800                25-Feb-28   \n",
       "8      38.20°N 111.17°W  38.2000 -111.1700                18-Dec-71   \n",
       "9      32.17°N 104.44°W  32.1700 -104.4400                14-May-30   \n",
       "10     34.01°N 119.42°W  34.0100 -119.4200                 5-Mar-80   \n",
       "11      33.78°N 80.78°W  33.7800  -80.7800                10-Nov-03   \n",
       "12      42.94°N 122.1°W  42.9400 -122.1000                22-May-02   \n",
       "13      41.24°N 81.55°W  41.2400  -81.5500                11-Oct-00   \n",
       "14     36.24°N 116.82°W  36.2400 -116.8200                31-Oct-94   \n",
       "15     63.33°N 150.50°W  63.3300 -150.5000                26-Feb-17   \n",
       "16      24.63°N 82.87°W  24.6300  -82.8700                26-Oct-92   \n",
       "17      25.32°N 80.93°W  25.3200  -80.9300                30-May-34   \n",
       "18     67.78°N 153.30°W  67.7800 -153.3000                 2-Dec-80   \n",
       "19      38.63°N 90.19°W  38.6300  -90.1900    February 22, 2018[45]   \n",
       "20     48.80°N 114.00°W  48.8000 -114.0000                11-May-10   \n",
       "21     58.50°N 137.00°W  58.5000 -137.0000                 2-Dec-80   \n",
       "22     36.06°N 112.14°W  36.0600 -112.1400                26-Feb-19   \n",
       "23     43.73°N 110.80°W  43.7300 -110.8000                26-Feb-29   \n",
       "24     38.98°N 114.30°W  38.9800 -114.3000                27-Oct-86   \n",
       "25     37.73°N 105.51°W  37.7300 -105.5100                13-Sep-04   \n",
       "26      35.68°N 83.53°W  35.6800  -83.5300                15-Jun-34   \n",
       "27     31.92°N 104.87°W  31.9200 -104.8700                15-Oct-66   \n",
       "28     20.72°N 156.17°W  20.7200 -156.1700                 1-Jul-61   \n",
       "30      34.51°N 93.05°W  34.5100  -93.0500                 4-Mar-21   \n",
       "31  41.6533°N 87.0524°W  41.6533  -87.0524                15-Feb-19   \n",
       "32      48.10°N 88.55°W  48.1000  -88.5500                 3-Apr-40   \n",
       "33     33.79°N 115.90°W  33.7900 -115.9000                31-Oct-94   \n",
       "34     58.50°N 155.00°W  58.5000 -155.0000                 2-Dec-80   \n",
       "35     59.92°N 149.65°W  59.9200 -149.6500                 2-Dec-80   \n",
       "36     36.80°N 118.55°W  36.8000 -118.5500                 4-Mar-40   \n",
       "37     36.43°N 118.68°W  36.4300 -118.6800       September 25, 1890   \n",
       "38     67.55°N 159.28°W  67.5500 -159.2800                 2-Dec-80   \n",
       "39     60.97°N 153.42°W  60.9700 -153.4200                 2-Dec-80   \n",
       "40     40.49°N 121.51°W  40.4900 -121.5100                 9-Aug-16   \n",
       "41      37.18°N 86.10°W  37.1800  -86.1000                 1-Jul-41   \n",
       "42     37.18°N 108.49°W  37.1800 -108.4900                29-Jun-06   \n",
       "43     46.85°N 121.75°W  46.8500 -121.7500            March 2, 1899   \n",
       "44     48.70°N 121.20°W  48.7000 -121.2000                 2-Oct-68   \n",
       "45     47.97°N 123.50°W  47.9700 -123.5000                29-Jun-38   \n",
       "46     35.07°N 109.78°W  35.0700 -109.7800                 9-Dec-62   \n",
       "47     36.48°N 121.16°W  36.4800 -121.1600                10-Jan-13   \n",
       "48     41.30°N 124.00°W  41.3000 -124.0000                 2-Oct-68   \n",
       "49     40.40°N 105.58°W  40.4000 -105.5800                26-Jan-15   \n",
       "50     32.25°N 110.50°W  32.2500 -110.5000                14-Oct-94   \n",
       "51      38.53°N 78.35°W  38.5300  -78.3500                26-Dec-35   \n",
       "52     46.97°N 103.45°W  46.9700 -103.4500                10-Nov-78   \n",
       "53      48.50°N 92.88°W  48.5000  -92.8800                 8-Jan-71   \n",
       "54     32.78°N 106.17°W  32.7800 -106.1700   December 20, 2019[107]   \n",
       "55     43.57°N 103.48°W  43.5700 -103.4800                 9-Jan-03   \n",
       "56     61.00°N 142.00°W  61.0000 -142.0000                 2-Dec-80   \n",
       "57     44.60°N 110.50°W  44.6000 -110.5000            March 1, 1872   \n",
       "58     37.83°N 119.50°W  37.8300 -119.5000          October 1, 1890   \n",
       "59     37.30°N 113.05°W  37.3000 -113.0500                19-Nov-19   \n",
       "\n",
       "                          Area, acres   area, acres area, km^2  \\\n",
       "1         76,678.98 acres (310.3 km2)     76,678.98      310.3   \n",
       "2      337,597.83 acres (1,366.2 km2)    337,597.83   1,366.20   \n",
       "3        242,755.94 acres (982.4 km2)    242,755.94      982.4   \n",
       "4      801,163.21 acres (3,242.2 km2)    801,163.21   3,242.20   \n",
       "5        172,971.11 acres (700.0 km2)    172,971.11        700   \n",
       "6         30,779.83 acres (124.6 km2)     30,779.83      124.6   \n",
       "7         35,835.08 acres (145.0 km2)     35,835.08        145   \n",
       "8        241,904.50 acres (979.0 km2)    241,904.50        979   \n",
       "9         46,766.45 acres (189.3 km2)     46,766.45      189.3   \n",
       "10     249,561.00 acres (1,009.9 km2)    249,561.00   1,009.90   \n",
       "11        26,476.47 acres (107.1 km2)     26,476.47      107.1   \n",
       "12       183,224.05 acres (741.5 km2)    183,224.05      741.5   \n",
       "13        32,571.88 acres (131.8 km2)     32,571.88      131.8   \n",
       "14  3,408,406.73 acres (13,793.3 km2)  3,408,406.73  13,793.30   \n",
       "15  4,740,911.16 acres (19,185.8 km2)  4,740,911.16  19,185.80   \n",
       "16        64,701.22 acres (261.8 km2)     64,701.22      261.8   \n",
       "17   1,508,938.57 acres (6,106.5 km2)  1,508,938.57   6,106.50   \n",
       "18  7,523,897.45 acres (30,448.1 km2)  7,523,897.45  30,448.10   \n",
       "19             192.83 acres (0.8 km2)        192.83        0.8   \n",
       "20   1,013,125.99 acres (4,100.0 km2)  1,013,125.99   4,100.00   \n",
       "21  3,223,383.43 acres (13,044.6 km2)  3,223,383.43  13,044.60   \n",
       "22   1,201,647.03 acres (4,862.9 km2)  1,201,647.03   4,862.90   \n",
       "23     310,044.36 acres (1,254.7 km2)    310,044.36   1,254.70   \n",
       "24        77,180.00 acres (312.3 km2)     77,180.00      312.3   \n",
       "25       107,341.87 acres (434.4 km2)    107,341.87      434.4   \n",
       "26     522,426.88 acres (2,114.2 km2)    522,426.88   2,114.20   \n",
       "27        86,367.10 acres (349.5 km2)     86,367.10      349.5   \n",
       "28        33,264.62 acres (134.6 km2)     33,264.62      134.6   \n",
       "30          5,554.15 acres (22.5 km2)      5,554.15       22.5   \n",
       "31         15,349.08 acres (62.1 km2)     15,349.08       62.1   \n",
       "32     571,790.30 acres (2,314.0 km2)    571,790.30   2,314.00   \n",
       "33     795,155.85 acres (3,217.9 km2)    795,155.85   3,217.90   \n",
       "34  3,674,529.33 acres (14,870.3 km2)  3,674,529.33  14,870.30   \n",
       "35     669,650.05 acres (2,710.0 km2)    669,650.05   2,710.00   \n",
       "36     461,901.20 acres (1,869.2 km2)    461,901.20   1,869.20   \n",
       "37     404,062.63 acres (1,635.2 km2)    404,062.63   1,635.20   \n",
       "38   1,750,716.16 acres (7,084.9 km2)  1,750,716.16   7,084.90   \n",
       "39  2,619,816.49 acres (10,602.0 km2)  2,619,816.49  10,602.00   \n",
       "40       106,589.02 acres (431.4 km2)    106,589.02      431.4   \n",
       "41        54,011.91 acres (218.6 km2)     54,011.91      218.6   \n",
       "42        52,485.17 acres (212.4 km2)     52,485.17      212.4   \n",
       "43       236,381.64 acres (956.6 km2)    236,381.64      956.6   \n",
       "44     504,780.94 acres (2,042.8 km2)    504,780.94   2,042.80   \n",
       "45     922,649.41 acres (3,733.8 km2)    922,649.41   3,733.80   \n",
       "46       221,390.21 acres (895.9 km2)    221,390.21      895.9   \n",
       "47        26,685.73 acres (108.0 km2)     26,685.73        108   \n",
       "48       138,999.37 acres (562.5 km2)    138,999.37      562.5   \n",
       "49     265,807.25 acres (1,075.7 km2)    265,807.25   1,075.70   \n",
       "50        91,715.72 acres (371.2 km2)     91,715.72      371.2   \n",
       "51       199,223.77 acres (806.2 km2)    199,223.77      806.2   \n",
       "52        70,446.89 acres (285.1 km2)     70,446.89      285.1   \n",
       "53       218,222.35 acres (883.1 km2)    218,222.35      883.1   \n",
       "54       146,344.31 acres (592.2 km2)    146,344.31      592.2   \n",
       "55        33,970.84 acres (137.5 km2)     33,970.84      137.5   \n",
       "56  8,323,146.48 acres (33,682.6 km2)  8,323,146.48  33,682.60   \n",
       "57   2,219,790.71 acres (8,983.2 km2)  2,219,790.71   8,983.20   \n",
       "58     761,747.50 acres (3,082.7 km2)    761,747.50   3,082.70   \n",
       "59       147,242.66 acres (595.9 km2)    147,242.66      595.9   \n",
       "\n",
       "   Recreation visitors  ...   Longitude Total_POP    TMale TMale21  TMale35  \\\n",
       "1            1,663,557  ... -109.493920   10043.0   4929.0     80.0   317.0   \n",
       "2              739,449  ... -109.493920   10043.0   4929.0     80.0   317.0   \n",
       "3            1,008,942  ... -101.943550     224.0    100.0      0.0    11.0   \n",
       "4              440,091  ... -103.210850     213.0    111.0      0.0     9.0   \n",
       "5              469,253  ...  -80.426920   58224.0  28526.0    343.0  1966.0   \n",
       "6              308,962  ... -107.862500   22633.0  10950.0    183.0   590.0   \n",
       "7            2,679,478  ... -112.208570     270.0    128.0      3.0     6.0   \n",
       "8            1,227,627  ... -111.002200     301.0    113.0      4.0     0.0   \n",
       "9              465,912  ... -104.291340   36708.0  18602.0    233.0  1236.0   \n",
       "10             366,250  ... -119.301640   33185.0  16763.0    189.0  1077.0   \n",
       "11             145,929  ...  -80.845350   14605.0   7235.0    138.0   336.0   \n",
       "12             720,659  ... -122.274430     152.0    110.0      0.0     0.0   \n",
       "13           2,096,053  ...  -81.618350   13830.0   6861.0     38.0   292.0   \n",
       "14           1,678,660  ... -117.202960     354.0    205.0      2.0    30.0   \n",
       "15             594,660  ... -148.833960     856.0    414.0     20.0     8.0   \n",
       "16              56,810  ...  -80.513820   23281.0  12004.0    188.0   904.0   \n",
       "17             597,124  ...  -80.513820   23281.0  12004.0    188.0   904.0   \n",
       "18               9,591  ... -147.720450   17510.0   8941.0    279.0   603.0   \n",
       "19           2,016,180  ...  -90.187020    2201.0   1551.0     57.0   156.0   \n",
       "20           2,965,309  ... -113.925990     401.0    208.0      6.0     2.0   \n",
       "21             597,915  ... -135.730880     416.0    192.0      0.0     8.0   \n",
       "22           6,380,495  ... -112.064980    2485.0   1212.0     38.0   162.0   \n",
       "23           3,491,151  ... -110.832150     226.0     75.0      0.0     0.0   \n",
       "24             153,094  ... -114.125920     121.0     57.0     11.0     0.0   \n",
       "25             442,905  ... -105.731010     772.0    377.0      9.0    39.0   \n",
       "26          11,421,200  ...  -83.471560    5555.0   2802.0     56.0    96.0   \n",
       "27             172,347  ... -105.308820     156.0    129.0      0.0    19.0   \n",
       "28           1,044,084  ... -156.331580   18155.0   9313.0     68.0   548.0   \n",
       "30           1,506,887  ...  -93.019410   30003.0  14240.0    119.0   671.0   \n",
       "31           1,756,079  ...  -87.058830   24906.0  12714.0    106.0   882.0   \n",
       "32              25,798  ...  -88.572590    9642.0   6043.0    628.0   153.0   \n",
       "33           2,942,382  ... -116.033430   23517.0  11950.0    286.0   755.0   \n",
       "34              37,818  ... -156.640070     455.0    266.0      1.0    29.0   \n",
       "35             321,596  ... -149.412710    4575.0   2670.0     23.0   187.0   \n",
       "36             699,023  ... -118.862960    2432.0   1292.0      8.0    47.0   \n",
       "37           1,229,594  ... -118.862960    2432.0   1292.0      8.0    47.0   \n",
       "38              14,937  ... -162.585440    3370.0   1811.0     39.0   116.0   \n",
       "39              14,479  ... -154.557080     151.0     72.0      0.0    10.0   \n",
       "40             499,435  ... -121.582450     292.0    184.0      0.0    18.0   \n",
       "41             533,206  ...  -86.198180    1256.0    732.0     38.0    32.0   \n",
       "42             563,420  ... -108.504240      94.0     47.0      0.0     0.0   \n",
       "43           1,518,491  ... -122.015440     634.0    356.0      0.0    26.0   \n",
       "44              30,085  ... -122.165450   26961.0  13470.0    312.0   964.0   \n",
       "45           3,104,455  ... -123.406280   23740.0  11671.0    204.0   537.0   \n",
       "46             644,922  ... -109.522950       0.0      0.0      0.0     0.0   \n",
       "47             222,152  ... -121.015150     732.0    376.0      0.0    15.0   \n",
       "48             482,536  ... -124.167030   23470.0  12672.0     48.0  1146.0   \n",
       "49           4,590,493  ... -105.517220   10012.0   4717.0     37.0   227.0   \n",
       "50             957,405  ... -110.810320   38219.0  18411.0    469.0  1086.0   \n",
       "51           1,264,880  ...  -78.456210   11636.0   5750.0     34.0   282.0   \n",
       "52             749,389  ... -103.568720     282.0    160.0      0.0    17.0   \n",
       "53             239,656  ...  -93.381420    9210.0   4587.0    117.0   236.0   \n",
       "54             603,008  ... -105.975610   36282.0  17986.0    480.0   962.0   \n",
       "55             656,397  ... -103.505100    5915.0   2936.0      0.0    96.0   \n",
       "56              79,450  ... -145.230800     540.0    261.0      0.0    15.0   \n",
       "57           4,115,000  ... -110.894210    1075.0    533.0     34.0     3.0   \n",
       "58           4,009,436  ... -119.675290    1392.0    882.0     19.0   136.0   \n",
       "59           4,320,033  ... -113.013922     540.0    291.0      0.0    31.0   \n",
       "\n",
       "   TMale65 TFemale21 TFemale35  TFemale65   TFemal  \n",
       "1    103.0      29.0     321.0      162.0   5114.0  \n",
       "2    103.0      29.0     321.0      162.0   5114.0  \n",
       "3      0.0       0.0       3.0        0.0    124.0  \n",
       "4      0.0       0.0       4.0        8.0    102.0  \n",
       "5    506.0     457.0    2416.0      599.0  29698.0  \n",
       "6    312.0      83.0     598.0      466.0  11683.0  \n",
       "7      0.0       0.0       0.0        0.0    142.0  \n",
       "8      0.0       7.0       6.0        0.0    188.0  \n",
       "9    345.0     240.0    1060.0      366.0  18106.0  \n",
       "10   369.0     141.0     897.0      490.0  16422.0  \n",
       "11   220.0      37.0     457.0      206.0   7370.0  \n",
       "12     0.0       0.0       0.0        0.0     42.0  \n",
       "13   315.0       8.0     273.0      227.0   6969.0  \n",
       "14     0.0       2.0      15.0       10.0    149.0  \n",
       "15     0.0      15.0      87.0        5.0    442.0  \n",
       "16   148.0      82.0     679.0      433.0  11277.0  \n",
       "17   148.0      82.0     679.0      433.0  11277.0  \n",
       "18   271.0     243.0     431.0      244.0   8569.0  \n",
       "19    43.0       0.0      69.0       15.0    650.0  \n",
       "20     4.0       0.0       0.0       17.0    193.0  \n",
       "21    23.0       0.0       4.0       19.0    224.0  \n",
       "22    61.0      44.0     118.0        0.0   1273.0  \n",
       "23     0.0       0.0       0.0        0.0    151.0  \n",
       "24     9.0       0.0       0.0        0.0     64.0  \n",
       "25    11.0       0.0      50.0       11.0    395.0  \n",
       "26    75.0      10.0     149.0      108.0   2753.0  \n",
       "27     0.0       0.0       0.0        0.0     27.0  \n",
       "28   228.0      50.0     522.0      336.0   8842.0  \n",
       "30   268.0      73.0    1198.0      376.0  15763.0  \n",
       "31   283.0       0.0     851.0      444.0  12192.0  \n",
       "32    58.0     141.0     149.0       30.0   3599.0  \n",
       "33   121.0     359.0     529.0      225.0  11567.0  \n",
       "34     5.0       3.0      15.0        0.0    189.0  \n",
       "35    34.0      45.0      61.0       67.0   1905.0  \n",
       "36    72.0       0.0      74.0       70.0   1140.0  \n",
       "37    72.0       0.0      74.0       70.0   1140.0  \n",
       "38    21.0      30.0      87.0       24.0   1559.0  \n",
       "39     1.0       0.0       7.0        0.0     79.0  \n",
       "40     2.0       0.0       0.0        0.0    108.0  \n",
       "41    11.0       2.0      16.0       14.0    524.0  \n",
       "42     0.0       0.0      22.0        0.0     47.0  \n",
       "43    15.0       0.0       0.0       29.0    278.0  \n",
       "44   321.0     105.0     658.0      291.0  13491.0  \n",
       "45   356.0     129.0     534.0      465.0  12069.0  \n",
       "46     0.0       0.0       0.0        0.0      0.0  \n",
       "47    15.0       8.0      23.0       13.0    356.0  \n",
       "48   359.0      75.0     654.0      290.0  10798.0  \n",
       "49   229.0      43.0     179.0      234.0   5295.0  \n",
       "50   364.0     384.0    1153.0      709.0  19808.0  \n",
       "51   194.0      47.0     419.0      172.0   5886.0  \n",
       "52     6.0       0.0       5.0        7.0    122.0  \n",
       "53   104.0      65.0     172.0      122.0   4623.0  \n",
       "54   434.0     196.0    1213.0      524.0  18296.0  \n",
       "55   120.0       5.0      70.0      135.0   2979.0  \n",
       "56     1.0       2.0      27.0        5.0    279.0  \n",
       "57     7.0      29.0       4.0        9.0    542.0  \n",
       "58    39.0       5.0      21.0        0.0    510.0  \n",
       "59     6.0      13.0       8.0       12.0    249.0  \n",
       "\n",
       "[58 rows x 29 columns]"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cleaned_park_census_df = combined_park_census_df.dropna()\n",
    "\n",
    "cleaned_park_census_df\n",
    "#cleaned_park_census_df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [],
   "source": [
    "cleaned_park_census_df.to_csv('Park_Census_forHeat.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [],
   "source": [
    "combined_park_census_df.to_csv('NationalPark_Census_Merge.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}