national park cleanup.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Dependencies and Setup\n",
    "import matplotlib.pyplot as plt\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import requests\n",
    "import time\n",
    "from scipy.stats import linregress\n",
    "from datetime import datetime\n",
    "import re\n",
    "\n",
    "csv_file = 'national_parks.csv'\n",
    "csv_clean = 'national_parks_clean.csv'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "scrolled": true
   },
   "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>Date established as park[5][10]</th>\n",
       "      <th>Area (2019)[11]</th>\n",
       "      <th>Recreation visitors (2018)[8]</th>\n",
       "      <th>Description</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>26-Feb-19</td>\n",
       "      <td>49,076.63 acres (198.6 km2)</td>\n",
       "      <td>3,537,575</td>\n",
       "      <td>Covering most of Mount Desert Island and other...</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>12-Nov-71</td>\n",
       "      <td>76,678.98 acres (310.3 km2)</td>\n",
       "      <td>1,663,557</td>\n",
       "      <td>This site features more than 2,000 natural san...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Badlands</td>\n",
       "      <td>South Dakota</td>\n",
       "      <td>43.75°N 102.50°W</td>\n",
       "      <td>10-Nov-78</td>\n",
       "      <td>242,755.94 acres (982.4 km2)</td>\n",
       "      <td>1,008,942</td>\n",
       "      <td>The Badlands are a collection of buttes, pinna...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Big Bend dagger</td>\n",
       "      <td>Texas</td>\n",
       "      <td>29.25°N 103.25°W</td>\n",
       "      <td>12-Jun-44</td>\n",
       "      <td>801,163.21 acres (3,242.2 km2)</td>\n",
       "      <td>440,091</td>\n",
       "      <td>Named for the prominent bend in the Rio Grande...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Biscayne</td>\n",
       "      <td>Florida</td>\n",
       "      <td>25.65°N 80.08°W</td>\n",
       "      <td>28-Jun-80</td>\n",
       "      <td>172,971.11 acres (700.0 km2)</td>\n",
       "      <td>469,253</td>\n",
       "      <td>Located in Biscayne Bay, this park at the nort...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Wind Cave</td>\n",
       "      <td>South Dakota</td>\n",
       "      <td>43.57°N 103.48°W</td>\n",
       "      <td>9-Jan-03</td>\n",
       "      <td>33,970.84 acres (137.5 km2)</td>\n",
       "      <td>656,397</td>\n",
       "      <td>Wind Cave is distinctive for its calcite fin f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Wrangell</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>61.00°N 142.00°W</td>\n",
       "      <td>2-Dec-80</td>\n",
       "      <td>8,323,146.48 acres (33,682.6 km2)</td>\n",
       "      <td>79,450</td>\n",
       "      <td>An over 8 million acres (32,375 km2) plot of m...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Yellowstone double-dagger</td>\n",
       "      <td>Wyoming, Montana, Idaho</td>\n",
       "      <td>44.60°N 110.50°W</td>\n",
       "      <td>March 1, 1872</td>\n",
       "      <td>2,219,790.71 acres (8,983.2 km2)</td>\n",
       "      <td>4,115,000</td>\n",
       "      <td>Situated on the Yellowstone Caldera, the park ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Yosemite *</td>\n",
       "      <td>California</td>\n",
       "      <td>37.83°N 119.50°W</td>\n",
       "      <td>October 1, 1890</td>\n",
       "      <td>761,747.50 acres (3,082.7 km2)</td>\n",
       "      <td>4,009,436</td>\n",
       "      <td>Yosemite features sheer granite cliffs, except...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Zion</td>\n",
       "      <td>Utah</td>\n",
       "      <td>37.30°N 113.05°W</td>\n",
       "      <td>19-Nov-19</td>\n",
       "      <td>147,242.66 acres (595.9 km2)</td>\n",
       "      <td>4,320,033</td>\n",
       "      <td>Located at the junction of the Colorado Platea...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>61 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Name                 Location       coordinates  \\\n",
       "0                      Acadia                    Maine   44.35°N 68.21°W   \n",
       "1                      Arches                     Utah  38.68°N 109.57°W   \n",
       "2                    Badlands             South Dakota  43.75°N 102.50°W   \n",
       "3             Big Bend dagger                    Texas  29.25°N 103.25°W   \n",
       "4                    Biscayne                  Florida   25.65°N 80.08°W   \n",
       "..                        ...                      ...               ...   \n",
       "56                  Wind Cave             South Dakota  43.57°N 103.48°W   \n",
       "57                   Wrangell                   Alaska  61.00°N 142.00°W   \n",
       "58  Yellowstone double-dagger  Wyoming, Montana, Idaho  44.60°N 110.50°W   \n",
       "59                 Yosemite *               California  37.83°N 119.50°W   \n",
       "60                       Zion                     Utah  37.30°N 113.05°W   \n",
       "\n",
       "   Date established as park[5][10]                    Area (2019)[11]  \\\n",
       "0                        26-Feb-19        49,076.63 acres (198.6 km2)   \n",
       "1                        12-Nov-71        76,678.98 acres (310.3 km2)   \n",
       "2                        10-Nov-78       242,755.94 acres (982.4 km2)   \n",
       "3                        12-Jun-44     801,163.21 acres (3,242.2 km2)   \n",
       "4                        28-Jun-80       172,971.11 acres (700.0 km2)   \n",
       "..                             ...                                ...   \n",
       "56                        9-Jan-03        33,970.84 acres (137.5 km2)   \n",
       "57                        2-Dec-80  8,323,146.48 acres (33,682.6 km2)   \n",
       "58                   March 1, 1872   2,219,790.71 acres (8,983.2 km2)   \n",
       "59                 October 1, 1890     761,747.50 acres (3,082.7 km2)   \n",
       "60                       19-Nov-19       147,242.66 acres (595.9 km2)   \n",
       "\n",
       "   Recreation visitors (2018)[8]  \\\n",
       "0                      3,537,575   \n",
       "1                      1,663,557   \n",
       "2                      1,008,942   \n",
       "3                        440,091   \n",
       "4                        469,253   \n",
       "..                           ...   \n",
       "56                       656,397   \n",
       "57                        79,450   \n",
       "58                     4,115,000   \n",
       "59                     4,009,436   \n",
       "60                     4,320,033   \n",
       "\n",
       "                                          Description  \n",
       "0   Covering most of Mount Desert Island and other...  \n",
       "1   This site features more than 2,000 natural san...  \n",
       "2   The Badlands are a collection of buttes, pinna...  \n",
       "3   Named for the prominent bend in the Rio Grande...  \n",
       "4   Located in Biscayne Bay, this park at the nort...  \n",
       "..                                                ...  \n",
       "56  Wind Cave is distinctive for its calcite fin f...  \n",
       "57  An over 8 million acres (32,375 km2) plot of m...  \n",
       "58  Situated on the Yellowstone Caldera, the park ...  \n",
       "59  Yosemite features sheer granite cliffs, except...  \n",
       "60  Located at the junction of the Colorado Platea...  \n",
       "\n",
       "[61 rows x 7 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "park_df = pd.read_csv(csv_file)\n",
    "park_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0      44.35°N 68.21°W\n",
       "1     38.68°N 109.57°W\n",
       "2     43.75°N 102.50°W\n",
       "3     29.25°N 103.25°W\n",
       "4      25.65°N 80.08°W\n",
       "            ...       \n",
       "56    43.57°N 103.48°W\n",
       "57    61.00°N 142.00°W\n",
       "58    44.60°N 110.50°W\n",
       "59    37.83°N 119.50°W\n",
       "60    37.30°N 113.05°W\n",
       "Name: coordinates, Length: 61, dtype: object"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "park_df['coordinates']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "park_df['lat'] = 0\n",
    "park_df['lon'] = 0\n",
    "park_df['new_name'] = 0\n",
    "park_df['area, acres'] = 0\n",
    "park_df['area, km^2'] = 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Biscayne'"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "re.split(' dagger| ', park_df[:][4:5]['Name'].item())[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0           49,076.63 acres (198.6 km2)\n",
       "1           76,678.98 acres (310.3 km2)\n",
       "2          242,755.94 acres (982.4 km2)\n",
       "3        801,163.21 acres (3,242.2 km2)\n",
       "4          172,971.11 acres (700.0 km2)\n",
       "                    ...                \n",
       "56          33,970.84 acres (137.5 km2)\n",
       "57    8,323,146.48 acres (33,682.6 km2)\n",
       "58     2,219,790.71 acres (8,983.2 km2)\n",
       "59       761,747.50 acres (3,082.7 km2)\n",
       "60         147,242.66 acres (595.9 km2)\n",
       "Name: Area (2019)[11], Length: 61, dtype: object"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "park_df['Area (2019)[11]']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Wrangell–St. Elias'"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "re.split(' dagger| double-dagger| \\*','Wrangell–St. Elias *')[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Yellowstone double-dagger'"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "park_df['Name'][58:59].item()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'68.21'"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "re.split('°W|°N |°S ', park_df.loc[park_df['Name'] == 'Acadia', 'coordinates'].item())[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['49,076.63', ' ', '198.6', '', '']"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "re.split(' acres|\\n|\\xa0km2|\\)|\\(',park_df.loc[park_df['Name'] == 'Acadia', 'Area (2019)[11]'].item())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Acadia\n",
      "Arches\n",
      "Badlands\n",
      "Big Bend dagger\n",
      "Biscayne\n",
      "Black Canyon of The Gunnison\n",
      "Bryce Canyon\n",
      "Canyonlands\n",
      "Capitol Reef\n",
      "Carlsbad Caverns\n",
      "Channel Islands\n",
      "Congaree\n",
      "Crater Lake\n",
      "Cuyahoga Valley\n",
      "Death Valley\n",
      "Denali dagger\n",
      "Dry Tortugas dagger\n",
      "Everglades double-dagger\n",
      "Gates of The Arctic\n",
      "Gateway Arch\n",
      "Glacier double-dagger\n",
      "Glacier Bay double-dagger\n",
      "Grand Canyon *\n",
      "Grand Teton dagger\n",
      "Great Basin\n",
      "Great Sand Dunes\n",
      "Great Smoky Mountains\n",
      "Guadalupe Mountains\n",
      "Haleakala\n",
      "Hawaii Volcanoes\n",
      "Hot Springs\n",
      "Indiana Dunes\n",
      "Isle Royale dagger\n",
      "Joshua Tree dagger\n",
      "Katmai\n",
      "Kenai Fjords\n",
      "Kings Canyon\n",
      "Kobuk Valley\n",
      "Lake Clark\n",
      "Lassen Volcanic\n",
      "Mammoth Cave double-dagger\n",
      "Mesa Verde *\n",
      "Mount Rainier\n",
      "North Cascades\n",
      "Olympic double-dagger\n",
      "Petrified Forest\n",
      "Pinnacles\n",
      "Redwood\n",
      "Rocky Mountain dagger\n",
      "Saguaro\n",
      "Sequoia dagger\n",
      "Shenandoah\n",
      "Theodore Roosevelt\n",
      "Virgin Islands\n",
      "Voyageurs\n",
      "White Sands\n",
      "Wind Cave\n",
      "Wrangell\n",
      "Yellowstone double-dagger\n",
      "Yosemite *\n",
      "Zion\n"
     ]
    }
   ],
   "source": [
    "new_name = []\n",
    "for name in park_df['Name']:\n",
    "    print(name)\n",
    "    acre_split = ' acres|\\n|\\xa0km2\\)|\\('\n",
    "    old_name = park_df.loc[park_df['Name'] == name, 'Name'].item()\n",
    "    new_name.append(re.split(' dagger| double-dagger| \\*', old_name)[0])\n",
    "    park_df.loc[park_df['Name'] == name, 'lat'] = re.split('°W|°N |°S ',park_df.loc[park_df['Name'] == name, 'coordinates'].item())[0]\n",
    "    park_df.loc[park_df['Name'] == name, 'lon'] = '-' + re.split('°W|°N |°S ',park_df.loc[park_df['Name'] == name, 'coordinates'].item())[1]\n",
    "    park_df.loc[park_df['Name'] == name, 'area, acres'] = re.split(acre_split,park_df.loc[park_df['Name'] == name, 'Area (2019)[11]'].item())[0]\n",
    "    park_df.loc[park_df['Name'] == name, 'area, km^2'] = re.split(acre_split,park_df.loc[park_df['Name'] == name, 'Area (2019)[11]'].item())[2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "park_df.loc[park_df['Name'] == 'American Samoa', 'lat'] = '-' + park_df.loc[park_df['Name'] == 'American Samoa', 'lat']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0           49,076.63 acres (198.6 km2)\n",
       "1           76,678.98 acres (310.3 km2)\n",
       "2          242,755.94 acres (982.4 km2)\n",
       "3        801,163.21 acres (3,242.2 km2)\n",
       "4          172,971.11 acres (700.0 km2)\n",
       "                    ...                \n",
       "56          33,970.84 acres (137.5 km2)\n",
       "57    8,323,146.48 acres (33,682.6 km2)\n",
       "58     2,219,790.71 acres (8,983.2 km2)\n",
       "59       761,747.50 acres (3,082.7 km2)\n",
       "60         147,242.66 acres (595.9 km2)\n",
       "Name: Area (2019)[11], Length: 61, dtype: object"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "park_df['Area (2019)[11]']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     44.35\n",
       "1     38.68\n",
       "2     43.75\n",
       "3     29.25\n",
       "4     25.65\n",
       "      ...  \n",
       "56    43.57\n",
       "57    61.00\n",
       "58    44.60\n",
       "59    37.83\n",
       "60    37.30\n",
       "Name: lat, Length: 61, dtype: object"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "park_df['lat']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0      -68.21\n",
       "1     -109.57\n",
       "2     -102.50\n",
       "3     -103.25\n",
       "4      -80.08\n",
       "       ...   \n",
       "56    -103.48\n",
       "57    -142.00\n",
       "58    -110.50\n",
       "59    -119.50\n",
       "60    -113.05\n",
       "Name: lon, Length: 61, dtype: object"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "park_df['lon']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Acadia',\n",
       " 'Arches',\n",
       " 'Badlands',\n",
       " 'Big Bend',\n",
       " 'Biscayne',\n",
       " 'Black Canyon of The Gunnison',\n",
       " 'Bryce Canyon',\n",
       " 'Canyonlands',\n",
       " 'Capitol Reef',\n",
       " 'Carlsbad Caverns',\n",
       " 'Channel Islands',\n",
       " 'Congaree',\n",
       " 'Crater Lake',\n",
       " 'Cuyahoga Valley',\n",
       " 'Death Valley',\n",
       " 'Denali',\n",
       " 'Dry Tortugas',\n",
       " 'Everglades',\n",
       " 'Gates of The Arctic',\n",
       " 'Gateway Arch',\n",
       " 'Glacier',\n",
       " 'Glacier Bay',\n",
       " 'Grand Canyon',\n",
       " 'Grand Teton',\n",
       " 'Great Basin',\n",
       " 'Great Sand Dunes',\n",
       " 'Great Smoky Mountains',\n",
       " 'Guadalupe Mountains',\n",
       " 'Haleakala',\n",
       " 'Hawaii Volcanoes',\n",
       " 'Hot Springs',\n",
       " 'Indiana Dunes',\n",
       " 'Isle Royale',\n",
       " 'Joshua Tree',\n",
       " 'Katmai',\n",
       " 'Kenai Fjords',\n",
       " 'Kings Canyon',\n",
       " 'Kobuk Valley',\n",
       " 'Lake Clark',\n",
       " 'Lassen Volcanic',\n",
       " 'Mammoth Cave',\n",
       " 'Mesa Verde',\n",
       " 'Mount Rainier',\n",
       " 'North Cascades',\n",
       " 'Olympic',\n",
       " 'Petrified Forest',\n",
       " 'Pinnacles',\n",
       " 'Redwood',\n",
       " 'Rocky Mountain',\n",
       " 'Saguaro',\n",
       " 'Sequoia',\n",
       " 'Shenandoah',\n",
       " 'Theodore Roosevelt',\n",
       " 'Virgin Islands',\n",
       " 'Voyageurs',\n",
       " 'White Sands',\n",
       " 'Wind Cave',\n",
       " 'Wrangell',\n",
       " 'Yellowstone',\n",
       " 'Yosemite',\n",
       " 'Zion']"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "park_df['Name'] = new_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0          Acadia\n",
       "1          Arches\n",
       "2        Badlands\n",
       "3        Big Bend\n",
       "4        Biscayne\n",
       "         ...     \n",
       "56      Wind Cave\n",
       "57       Wrangell\n",
       "58    Yellowstone\n",
       "59       Yosemite\n",
       "60           Zion\n",
       "Name: Name, Length: 61, dtype: object"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "park_df['Name']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Name', 'Location', 'coordinates', 'Date established as park[5][10]',\n",
       "       'Area (2019)[11]', 'Recreation visitors (2018)[8]', 'Description',\n",
       "       'lat', 'lon', 'new_name', 'area, acres', 'area, km^2'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "park_df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "new_cols = ['Name', 'Location', 'coordinates','lat', 'lon', 'Date established as park[5][10]',\n",
    "       'Area (2019)[11]','area, acres', 'area, km^2', 'Recreation visitors (2018)[8]', 'Description']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "park_df = park_df[new_cols]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "park_clean_df = park_df.rename(columns = {'Date established as park[5][10]':'Date established as park', 'Area (2019)[11]':'Area, acres', 'Recreation visitors (2018)[8]' : 'Recreation visitors'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>Description</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>Covering most of Mount Desert Island and other...</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>This site features more than 2,000 natural san...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</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>The Badlands are a collection of buttes, pinna...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</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.2</td>\n",
       "      <td>440,091</td>\n",
       "      <td>Named for the prominent bend in the Rio Grande...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Biscayne</td>\n",
       "      <td>Florida</td>\n",
       "      <td>25.65°N 80.08°W</td>\n",
       "      <td>25.65</td>\n",
       "      <td>-80.08</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.0</td>\n",
       "      <td>469,253</td>\n",
       "      <td>Located in Biscayne Bay, this park at the nort...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Wind Cave</td>\n",
       "      <td>South Dakota</td>\n",
       "      <td>43.57°N 103.48°W</td>\n",
       "      <td>43.57</td>\n",
       "      <td>-103.48</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>Wind Cave is distinctive for its calcite fin f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Wrangell</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>61.00°N 142.00°W</td>\n",
       "      <td>61.00</td>\n",
       "      <td>-142.00</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.6</td>\n",
       "      <td>79,450</td>\n",
       "      <td>An over 8 million acres (32,375 km2) plot of m...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Yellowstone</td>\n",
       "      <td>Wyoming, Montana, Idaho</td>\n",
       "      <td>44.60°N 110.50°W</td>\n",
       "      <td>44.60</td>\n",
       "      <td>-110.50</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.2</td>\n",
       "      <td>4,115,000</td>\n",
       "      <td>Situated on the Yellowstone Caldera, the park ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Yosemite</td>\n",
       "      <td>California</td>\n",
       "      <td>37.83°N 119.50°W</td>\n",
       "      <td>37.83</td>\n",
       "      <td>-119.50</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.7</td>\n",
       "      <td>4,009,436</td>\n",
       "      <td>Yosemite features sheer granite cliffs, except...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Zion</td>\n",
       "      <td>Utah</td>\n",
       "      <td>37.30°N 113.05°W</td>\n",
       "      <td>37.30</td>\n",
       "      <td>-113.05</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>Located at the junction of the Colorado Platea...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>61 rows × 11 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      Badlands             South Dakota  43.75°N 102.50°W  43.75  -102.50   \n",
       "3      Big Bend                    Texas  29.25°N 103.25°W  29.25  -103.25   \n",
       "4      Biscayne                  Florida   25.65°N 80.08°W  25.65   -80.08   \n",
       "..          ...                      ...               ...    ...      ...   \n",
       "56    Wind Cave             South Dakota  43.57°N 103.48°W  43.57  -103.48   \n",
       "57     Wrangell                   Alaska  61.00°N 142.00°W  61.00  -142.00   \n",
       "58  Yellowstone  Wyoming, Montana, Idaho  44.60°N 110.50°W  44.60  -110.50   \n",
       "59     Yosemite               California  37.83°N 119.50°W  37.83  -119.50   \n",
       "60         Zion                     Utah  37.30°N 113.05°W  37.30  -113.05   \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                 10-Nov-78       242,755.94 acres (982.4 km2)    242,755.94   \n",
       "3                 12-Jun-44     801,163.21 acres (3,242.2 km2)    801,163.21   \n",
       "4                 28-Jun-80       172,971.11 acres (700.0 km2)    172,971.11   \n",
       "..                      ...                                ...           ...   \n",
       "56                 9-Jan-03        33,970.84 acres (137.5 km2)     33,970.84   \n",
       "57                 2-Dec-80  8,323,146.48 acres (33,682.6 km2)  8,323,146.48   \n",
       "58            March 1, 1872   2,219,790.71 acres (8,983.2 km2)  2,219,790.71   \n",
       "59          October 1, 1890     761,747.50 acres (3,082.7 km2)    761,747.50   \n",
       "60                19-Nov-19       147,242.66 acres (595.9 km2)    147,242.66   \n",
       "\n",
       "   area, km^2 Recreation visitors  \\\n",
       "0       198.6           3,537,575   \n",
       "1       310.3           1,663,557   \n",
       "2       982.4           1,008,942   \n",
       "3     3,242.2             440,091   \n",
       "4       700.0             469,253   \n",
       "..        ...                 ...   \n",
       "56      137.5             656,397   \n",
       "57   33,682.6              79,450   \n",
       "58    8,983.2           4,115,000   \n",
       "59    3,082.7           4,009,436   \n",
       "60      595.9           4,320,033   \n",
       "\n",
       "                                          Description  \n",
       "0   Covering most of Mount Desert Island and other...  \n",
       "1   This site features more than 2,000 natural san...  \n",
       "2   The Badlands are a collection of buttes, pinna...  \n",
       "3   Named for the prominent bend in the Rio Grande...  \n",
       "4   Located in Biscayne Bay, this park at the nort...  \n",
       "..                                                ...  \n",
       "56  Wind Cave is distinctive for its calcite fin f...  \n",
       "57  An over 8 million acres (32,375 km2) plot of m...  \n",
       "58  Situated on the Yellowstone Caldera, the park ...  \n",
       "59  Yosemite features sheer granite cliffs, except...  \n",
       "60  Located at the junction of the Colorado Platea...  \n",
       "\n",
       "[61 rows x 11 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "park_clean_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "park_clean_df.to_csv(csv_clean, index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "np_dataset_df = pd.read_csv('np_dataset_from_api.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>State</th>\n",
       "      <th>Park Designation</th>\n",
       "      <th>national park full name</th>\n",
       "      <th>Park Code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>IN</td>\n",
       "      <td>National Park</td>\n",
       "      <td>Indiana Dunes National Park</td>\n",
       "      <td>indu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>KY</td>\n",
       "      <td>National Park</td>\n",
       "      <td>Mammoth Cave National Park</td>\n",
       "      <td>maca</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>ME</td>\n",
       "      <td>National Park</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>acad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>MI</td>\n",
       "      <td>National Park</td>\n",
       "      <td>Isle Royale National Park</td>\n",
       "      <td>isro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>MN</td>\n",
       "      <td>National Park</td>\n",
       "      <td>Voyageurs National Park</td>\n",
       "      <td>voya</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>MO</td>\n",
       "      <td>National Park</td>\n",
       "      <td>Gateway Arch National Park</td>\n",
       "      <td>jeff</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>MT</td>\n",
       "      <td>National Park</td>\n",
       "      <td>Glacier National Park</td>\n",
       "      <td>glac</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>MT</td>\n",
       "      <td>National Park</td>\n",
       "      <td>Yellowstone National Park</td>\n",
       "      <td>yell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>NV</td>\n",
       "      <td>National Park</td>\n",
       "      <td>Death Valley National Park</td>\n",
       "      <td>deva</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>NV</td>\n",
       "      <td>National Park</td>\n",
       "      <td>Great Basin National Park</td>\n",
       "      <td>grba</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   State Park Designation      national park full name Park Code\n",
       "30    IN    National Park  Indiana Dunes National Park      indu\n",
       "31    KY    National Park   Mammoth Cave National Park      maca\n",
       "32    ME    National Park         Acadia National Park      acad\n",
       "33    MI    National Park    Isle Royale National Park      isro\n",
       "34    MN    National Park      Voyageurs National Park      voya\n",
       "35    MO    National Park   Gateway Arch National Park      jeff\n",
       "36    MT    National Park        Glacier National Park      glac\n",
       "37    MT    National Park    Yellowstone National Park      yell\n",
       "38    NV    National Park   Death Valley National Park      deva\n",
       "39    NV    National Park    Great Basin National Park      grba"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np_dataset_df[30:40]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "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>Description</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>Covering most of Mount Desert Island and other...</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>This site features more than 2,000 natural san...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</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>The Badlands are a collection of buttes, pinna...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</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.2</td>\n",
       "      <td>440,091</td>\n",
       "      <td>Named for the prominent bend in the Rio Grande...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Biscayne</td>\n",
       "      <td>Florida</td>\n",
       "      <td>25.65°N 80.08°W</td>\n",
       "      <td>25.65</td>\n",
       "      <td>-80.08</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.0</td>\n",
       "      <td>469,253</td>\n",
       "      <td>Located in Biscayne Bay, this park at the nort...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Wind Cave</td>\n",
       "      <td>South Dakota</td>\n",
       "      <td>43.57°N 103.48°W</td>\n",
       "      <td>43.57</td>\n",
       "      <td>-103.48</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>Wind Cave is distinctive for its calcite fin f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Wrangell</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>61.00°N 142.00°W</td>\n",
       "      <td>61.00</td>\n",
       "      <td>-142.00</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.6</td>\n",
       "      <td>79,450</td>\n",
       "      <td>An over 8 million acres (32,375 km2) plot of m...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Yellowstone</td>\n",
       "      <td>Wyoming, Montana, Idaho</td>\n",
       "      <td>44.60°N 110.50°W</td>\n",
       "      <td>44.60</td>\n",
       "      <td>-110.50</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.2</td>\n",
       "      <td>4,115,000</td>\n",
       "      <td>Situated on the Yellowstone Caldera, the park ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Yosemite</td>\n",
       "      <td>California</td>\n",
       "      <td>37.83°N 119.50°W</td>\n",
       "      <td>37.83</td>\n",
       "      <td>-119.50</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.7</td>\n",
       "      <td>4,009,436</td>\n",
       "      <td>Yosemite features sheer granite cliffs, except...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Zion</td>\n",
       "      <td>Utah</td>\n",
       "      <td>37.30°N 113.05°W</td>\n",
       "      <td>37.30</td>\n",
       "      <td>-113.05</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>Located at the junction of the Colorado Platea...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>61 rows × 11 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      Badlands             South Dakota  43.75°N 102.50°W  43.75  -102.50   \n",
       "3      Big Bend                    Texas  29.25°N 103.25°W  29.25  -103.25   \n",
       "4      Biscayne                  Florida   25.65°N 80.08°W  25.65   -80.08   \n",
       "..          ...                      ...               ...    ...      ...   \n",
       "56    Wind Cave             South Dakota  43.57°N 103.48°W  43.57  -103.48   \n",
       "57     Wrangell                   Alaska  61.00°N 142.00°W  61.00  -142.00   \n",
       "58  Yellowstone  Wyoming, Montana, Idaho  44.60°N 110.50°W  44.60  -110.50   \n",
       "59     Yosemite               California  37.83°N 119.50°W  37.83  -119.50   \n",
       "60         Zion                     Utah  37.30°N 113.05°W  37.30  -113.05   \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                 10-Nov-78       242,755.94 acres (982.4 km2)    242,755.94   \n",
       "3                 12-Jun-44     801,163.21 acres (3,242.2 km2)    801,163.21   \n",
       "4                 28-Jun-80       172,971.11 acres (700.0 km2)    172,971.11   \n",
       "..                      ...                                ...           ...   \n",
       "56                 9-Jan-03        33,970.84 acres (137.5 km2)     33,970.84   \n",
       "57                 2-Dec-80  8,323,146.48 acres (33,682.6 km2)  8,323,146.48   \n",
       "58            March 1, 1872   2,219,790.71 acres (8,983.2 km2)  2,219,790.71   \n",
       "59          October 1, 1890     761,747.50 acres (3,082.7 km2)    761,747.50   \n",
       "60                19-Nov-19       147,242.66 acres (595.9 km2)    147,242.66   \n",
       "\n",
       "   area, km^2 Recreation visitors  \\\n",
       "0       198.6           3,537,575   \n",
       "1       310.3           1,663,557   \n",
       "2       982.4           1,008,942   \n",
       "3     3,242.2             440,091   \n",
       "4       700.0             469,253   \n",
       "..        ...                 ...   \n",
       "56      137.5             656,397   \n",
       "57   33,682.6              79,450   \n",
       "58    8,983.2           4,115,000   \n",
       "59    3,082.7           4,009,436   \n",
       "60      595.9           4,320,033   \n",
       "\n",
       "                                          Description  \n",
       "0   Covering most of Mount Desert Island and other...  \n",
       "1   This site features more than 2,000 natural san...  \n",
       "2   The Badlands are a collection of buttes, pinna...  \n",
       "3   Named for the prominent bend in the Rio Grande...  \n",
       "4   Located in Biscayne Bay, this park at the nort...  \n",
       "..                                                ...  \n",
       "56  Wind Cave is distinctive for its calcite fin f...  \n",
       "57  An over 8 million acres (32,375 km2) plot of m...  \n",
       "58  Situated on the Yellowstone Caldera, the park ...  \n",
       "59  Yosemite features sheer granite cliffs, except...  \n",
       "60  Located at the junction of the Colorado Platea...  \n",
       "\n",
       "[61 rows x 11 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "park_clean_df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "park_clean_df['national park full name'] = 0\n",
    "park_clean_df['State'] = 0\n",
    "park_clean_df['Park Designation'] = 0\n",
    "park_clean_df['Park Code'] = 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "park_clean_df['Name'][0] in np_dataset_df['national park full name'][30:31].item()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Acadia\n",
      "Arches\n",
      "Badlands\n",
      "Big Bend\n",
      "Biscayne\n",
      "Bryce Canyon\n",
      "Canyonlands\n",
      "Capitol Reef\n",
      "Carlsbad Caverns\n",
      "Channel Islands\n",
      "Congaree\n",
      "Crater Lake\n",
      "Cuyahoga Valley\n",
      "Death Valley\n",
      "Death Valley\n",
      "Denali\n",
      "Dry Tortugas\n",
      "Everglades\n",
      "Gateway Arch\n",
      "Glacier\n",
      "Glacier\n",
      "Glacier Bay\n",
      "Grand Canyon\n",
      "Grand Teton\n",
      "Great Basin\n",
      "Great Sand Dunes\n",
      "Great Smoky Mountains\n",
      "Great Smoky Mountains\n",
      "Guadalupe Mountains\n",
      "Hot Springs\n",
      "Indiana Dunes\n",
      "Isle Royale\n",
      "Joshua Tree\n",
      "Katmai\n",
      "Kenai Fjords\n",
      "Kings Canyon\n",
      "Kobuk Valley\n",
      "Lake Clark\n",
      "Lassen Volcanic\n",
      "Mammoth Cave\n",
      "Mesa Verde\n",
      "Mount Rainier\n",
      "North Cascades\n",
      "Olympic\n",
      "Petrified Forest\n",
      "Pinnacles\n",
      "Redwood\n",
      "Rocky Mountain\n",
      "Saguaro\n",
      "Sequoia\n",
      "Shenandoah\n",
      "Theodore Roosevelt\n",
      "Voyageurs\n",
      "White Sands\n",
      "Wind Cave\n",
      "Wrangell\n",
      "Yellowstone\n",
      "Yellowstone\n",
      "Yellowstone\n",
      "Yosemite\n",
      "Zion\n"
     ]
    }
   ],
   "source": [
    "for i in range(len(park_clean_df)):\n",
    "    for j in range(len(np_dataset_df)):\n",
    "        if (park_clean_df.loc[i,'Name'] in np_dataset_df.loc[j,'national park full name']):\n",
    "            print(park_clean_df.loc[i,'Name'])\n",
    "            park_clean_df.loc[i, 'national park full name'] = np_dataset_df.loc[j, 'national park full name']\n",
    "            park_clean_df.loc[i, 'State'] = np_dataset_df.loc[j, 'State']\n",
    "            park_clean_df.loc[i, 'Park Designation'] = np_dataset_df.loc[j, 'Park Designation']\n",
    "            park_clean_df.loc[i, 'Park Code'] = np_dataset_df.loc[j, 'Park Code']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Zion National Park'"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "park_clean_df.loc[i, 'national park full name']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Yellowstone National Park'"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np_dataset_df.loc[j, 'national park full name']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "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>Description</th>\n",
       "      <th>national park full name</th>\n",
       "      <th>State</th>\n",
       "      <th>Park Designation</th>\n",
       "      <th>Park Code</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>Covering most of Mount Desert Island and other...</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>ME</td>\n",
       "      <td>National Park</td>\n",
       "      <td>acad</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>This site features more than 2,000 natural san...</td>\n",
       "      <td>Arches National Park</td>\n",
       "      <td>UT</td>\n",
       "      <td>National Park</td>\n",
       "      <td>arch</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</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>The Badlands are a collection of buttes, pinna...</td>\n",
       "      <td>Badlands National Park</td>\n",
       "      <td>SD</td>\n",
       "      <td>National Park</td>\n",
       "      <td>badl</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</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.2</td>\n",
       "      <td>440,091</td>\n",
       "      <td>Named for the prominent bend in the Rio Grande...</td>\n",
       "      <td>Big Bend National Park</td>\n",
       "      <td>TX</td>\n",
       "      <td>National Park</td>\n",
       "      <td>bibe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Biscayne</td>\n",
       "      <td>Florida</td>\n",
       "      <td>25.65°N 80.08°W</td>\n",
       "      <td>25.65</td>\n",
       "      <td>-80.08</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.0</td>\n",
       "      <td>469,253</td>\n",
       "      <td>Located in Biscayne Bay, this park at the nort...</td>\n",
       "      <td>Biscayne National Park</td>\n",
       "      <td>FL</td>\n",
       "      <td>National Park</td>\n",
       "      <td>bisc</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Wind Cave</td>\n",
       "      <td>South Dakota</td>\n",
       "      <td>43.57°N 103.48°W</td>\n",
       "      <td>43.57</td>\n",
       "      <td>-103.48</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>Wind Cave is distinctive for its calcite fin f...</td>\n",
       "      <td>Wind Cave National Park</td>\n",
       "      <td>SD</td>\n",
       "      <td>National Park</td>\n",
       "      <td>wica</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Wrangell</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>61.00°N 142.00°W</td>\n",
       "      <td>61.00</td>\n",
       "      <td>-142.00</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.6</td>\n",
       "      <td>79,450</td>\n",
       "      <td>An over 8 million acres (32,375 km2) plot of m...</td>\n",
       "      <td>Wrangell - St Elias National Park &amp; Preserve</td>\n",
       "      <td>AK</td>\n",
       "      <td>National Park &amp; Preserve</td>\n",
       "      <td>wrst</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Yellowstone</td>\n",
       "      <td>Wyoming, Montana, Idaho</td>\n",
       "      <td>44.60°N 110.50°W</td>\n",
       "      <td>44.60</td>\n",
       "      <td>-110.50</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.2</td>\n",
       "      <td>4,115,000</td>\n",
       "      <td>Situated on the Yellowstone Caldera, the park ...</td>\n",
       "      <td>Yellowstone National Park</td>\n",
       "      <td>WY</td>\n",
       "      <td>National Park</td>\n",
       "      <td>yell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Yosemite</td>\n",
       "      <td>California</td>\n",
       "      <td>37.83°N 119.50°W</td>\n",
       "      <td>37.83</td>\n",
       "      <td>-119.50</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.7</td>\n",
       "      <td>4,009,436</td>\n",
       "      <td>Yosemite features sheer granite cliffs, except...</td>\n",
       "      <td>Yosemite National Park</td>\n",
       "      <td>CA</td>\n",
       "      <td>National Park</td>\n",
       "      <td>yose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Zion</td>\n",
       "      <td>Utah</td>\n",
       "      <td>37.30°N 113.05°W</td>\n",
       "      <td>37.30</td>\n",
       "      <td>-113.05</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>Located at the junction of the Colorado Platea...</td>\n",
       "      <td>Zion National Park</td>\n",
       "      <td>UT</td>\n",
       "      <td>National Park</td>\n",
       "      <td>zion</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>61 rows × 15 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      Badlands             South Dakota  43.75°N 102.50°W  43.75  -102.50   \n",
       "3      Big Bend                    Texas  29.25°N 103.25°W  29.25  -103.25   \n",
       "4      Biscayne                  Florida   25.65°N 80.08°W  25.65   -80.08   \n",
       "..          ...                      ...               ...    ...      ...   \n",
       "56    Wind Cave             South Dakota  43.57°N 103.48°W  43.57  -103.48   \n",
       "57     Wrangell                   Alaska  61.00°N 142.00°W  61.00  -142.00   \n",
       "58  Yellowstone  Wyoming, Montana, Idaho  44.60°N 110.50°W  44.60  -110.50   \n",
       "59     Yosemite               California  37.83°N 119.50°W  37.83  -119.50   \n",
       "60         Zion                     Utah  37.30°N 113.05°W  37.30  -113.05   \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                 10-Nov-78       242,755.94 acres (982.4 km2)    242,755.94   \n",
       "3                 12-Jun-44     801,163.21 acres (3,242.2 km2)    801,163.21   \n",
       "4                 28-Jun-80       172,971.11 acres (700.0 km2)    172,971.11   \n",
       "..                      ...                                ...           ...   \n",
       "56                 9-Jan-03        33,970.84 acres (137.5 km2)     33,970.84   \n",
       "57                 2-Dec-80  8,323,146.48 acres (33,682.6 km2)  8,323,146.48   \n",
       "58            March 1, 1872   2,219,790.71 acres (8,983.2 km2)  2,219,790.71   \n",
       "59          October 1, 1890     761,747.50 acres (3,082.7 km2)    761,747.50   \n",
       "60                19-Nov-19       147,242.66 acres (595.9 km2)    147,242.66   \n",
       "\n",
       "   area, km^2 Recreation visitors  \\\n",
       "0       198.6           3,537,575   \n",
       "1       310.3           1,663,557   \n",
       "2       982.4           1,008,942   \n",
       "3     3,242.2             440,091   \n",
       "4       700.0             469,253   \n",
       "..        ...                 ...   \n",
       "56      137.5             656,397   \n",
       "57   33,682.6              79,450   \n",
       "58    8,983.2           4,115,000   \n",
       "59    3,082.7           4,009,436   \n",
       "60      595.9           4,320,033   \n",
       "\n",
       "                                          Description  \\\n",
       "0   Covering most of Mount Desert Island and other...   \n",
       "1   This site features more than 2,000 natural san...   \n",
       "2   The Badlands are a collection of buttes, pinna...   \n",
       "3   Named for the prominent bend in the Rio Grande...   \n",
       "4   Located in Biscayne Bay, this park at the nort...   \n",
       "..                                                ...   \n",
       "56  Wind Cave is distinctive for its calcite fin f...   \n",
       "57  An over 8 million acres (32,375 km2) plot of m...   \n",
       "58  Situated on the Yellowstone Caldera, the park ...   \n",
       "59  Yosemite features sheer granite cliffs, except...   \n",
       "60  Located at the junction of the Colorado Platea...   \n",
       "\n",
       "                         national park full name State  \\\n",
       "0                           Acadia National Park    ME   \n",
       "1                           Arches National Park    UT   \n",
       "2                         Badlands National Park    SD   \n",
       "3                         Big Bend National Park    TX   \n",
       "4                         Biscayne National Park    FL   \n",
       "..                                           ...   ...   \n",
       "56                       Wind Cave National Park    SD   \n",
       "57  Wrangell - St Elias National Park & Preserve    AK   \n",
       "58                     Yellowstone National Park    WY   \n",
       "59                        Yosemite National Park    CA   \n",
       "60                            Zion National Park    UT   \n",
       "\n",
       "            Park Designation Park Code  \n",
       "0              National Park      acad  \n",
       "1              National Park      arch  \n",
       "2              National Park      badl  \n",
       "3              National Park      bibe  \n",
       "4              National Park      bisc  \n",
       "..                       ...       ...  \n",
       "56             National Park      wica  \n",
       "57  National Park & Preserve      wrst  \n",
       "58             National Park      yell  \n",
       "59             National Park      yose  \n",
       "60             National Park      zion  \n",
       "\n",
       "[61 rows x 15 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "park_clean_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "park_clean_df.to_csv(csv_clean, index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "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.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}