Data Cleaning-checkpoint.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import datetime as dt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Read into CSV for 2016 data\n",
    "df_2016 = pd.read_csv('2016.csv', encoding='cp1252')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Get a list of column headers to reorganize the data\n",
    "list_columns = list(df_2016.columns)\n",
    "# list_columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Select desired columns and reorganize data\n",
    "select_columns = ['OrderNumber', 'Park', 'SiteType', 'FacilityID', 'FacilityState', 'StartDate', 'EndDate', 'NumberOfPeople']\n",
    "\n",
    "new_df16 = df_2016.loc[:, select_columns]\n",
    "# new_df16"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "#General check of information\n",
    "# new_df16.count()\n",
    "# len(new_df16)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Filter data for Colorado only\n",
    "filter_16CO  = new_df16[new_df16['FacilityState'] == 'CO']\n",
    "# filter_16CO.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'LOOKOUT',\n",
       " 'Historic Tour',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'LOOKOUT',\n",
       " 'LOOKOUT',\n",
       " 'Cliff Dwelling Tour',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'LOOKOUT',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'GROUP STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'Cliff Dwelling Tour',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'Cliff Dwelling Tour',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'GROUP SHELTER ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'LOOKOUT',\n",
       " 'CABIN ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP WALK TO',\n",
       " 'LOOKOUT',\n",
       " 'CABIN ELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'GROUP WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'Cliff Dwelling Tour',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'CABIN ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'GROUP PICNIC AREA',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'CABIN ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'CABIN ELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'Historic Tour',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'LOOKOUT',\n",
       " 'LOOKOUT',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'GROUP SHELTER NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'GROUP PICNIC AREA',\n",
       " 'GROUP PICNIC AREA',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD ELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'LOOKOUT',\n",
       " 'CABIN ELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'LOOKOUT',\n",
       " 'RV NONELECTRIC',\n",
       " 'GROUP WALK TO',\n",
       " 'RV NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP SHELTER ELECTRIC',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'RV NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'LOOKOUT',\n",
       " 'LOOKOUT',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'GROUP STANDARD ELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD ELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'GROUP STANDARD ELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'GROUP SHELTER NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'GROUP PICNIC AREA',\n",
       " 'GROUP WALK TO',\n",
       " 'LOOKOUT',\n",
       " 'RV NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'RV ELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP SHELTER NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'LOOKOUT',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'LOOKOUT',\n",
       " 'RV NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP PICNIC AREA',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'RV NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'RV ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'RV ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'RV ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'RV ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'RV ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'RV ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'WALK TO',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'RV NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " ...]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Suspect that 'SiteType' data is including more than just overnight bookings, i.e. 'Historic Tour' = 'activity'\n",
    "#Therefore, list value types in column 'SiteType' to filter our activity like bookings\n",
    "list(filter_16CO['SiteType'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Construct a list which specifies the type of data values desired for SiteType\n",
    "site16List = ['CABIN ELECTRIC', 'CABIN NONELECTRIC', 'EQUESTRIAN NONELECTRIC', 'GROUP PICNIC AREA', 'GROUP SHELTER ELECTRIC',\n",
    "            'GROUP SHELTER NONELECTRIC', 'GROUP STANDARD AREA NONELECTRIC', 'GROUP STANDARD ELECTRIC', 'GROUP STANDARD NONELECTRIC',\n",
    "            'GROUP TENT ONLY AREA NONELECTRIC', 'GROUP WALK TO', 'LOOKOUT', 'RV ELECTRIC', 'STANDARD ELECTRIC', 'STANDARD NONELECTRIC', \n",
    "            'TENT ONLY NONELECTRIC', 'WALK TO']\n",
    "\n",
    "#Use the .isin() method to filter/set specified values for SiteType column\n",
    "return16 = filter_16CO[filter_16CO['SiteType'].isin(site16List)]\n",
    "# return16"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Check to see if SiteType returns unwanted values\n",
    "# check = return16[return16['SiteType'] == 'Combo Tour']\n",
    "# check"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "#If check passes, save into a clean CSV\n",
    "return16.to_csv('clean_res16', index=False, header=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Repeat steps for 2017 data cleaning. Set list to filter exactly the same values for all data sets 2016-2020. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_2017 = pd.read_csv('2017.csv', encoding='cp1252')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "list17_columns = list(df_2017.columns)\n",
    "# list17_columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "select_columns17 = ['OrderNumber', 'Park', 'SiteType', 'FacilityID', 'FacilityState', 'StartDate', 'EndDate', 'NumberOfPeople', 'Tent',\n",
    " 'Trailer', 'RVMotorhome']\n",
    "\n",
    "new_df17 = df_2017.loc[:, select_columns17]\n",
    "# new_df17"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [],
   "source": [
    "filter_17CO = new_df17[new_df17['FacilityState'] == 'CO']\n",
    "# filter_17CO"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'WALK TO',\n",
       " 'CABIN ELECTRIC',\n",
       " 'WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'GROUP WALK TO',\n",
       " 'CABIN ELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'WALK TO',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'EQUESTRIAN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'Cliff Dwelling Tour',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'LOOKOUT',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP WALK TO',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Entry Point',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'WALK TO',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Cliff Dwelling Tour',\n",
       " 'GROUP WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP SHELTER NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'Historic Tour',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'EQUESTRIAN NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'WALK TO',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'WALK TO',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'WALK TO',\n",
       " 'WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Historic Tour',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'Cliff Dwelling Tour',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'LOOKOUT',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Cliff Dwelling Tour',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Cliff Dwelling Tour',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'CABIN ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Cliff Dwelling Tour',\n",
       " 'WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'WALK TO',\n",
       " 'Historic Tour',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP SHELTER ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP SHELTER NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'Historic Tour',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Historic Tour',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'GROUP SHELTER NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'GROUP SHELTER NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'GROUP SHELTER NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Historic Tour',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Historic Tour',\n",
       " 'Campsite',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'LOOKOUT',\n",
       " 'CABIN ELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP SHELTER ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'LOOKOUT',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'LOOKOUT',\n",
       " 'Campsite',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'LOOKOUT',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'LOOKOUT',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'GROUP STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'Entry Point',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'LOOKOUT',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'Historic Tour',\n",
       " 'GROUP WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP PICNIC AREA',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'LOOKOUT',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'LOOKOUT',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'LOOKOUT',\n",
       " 'CABIN ELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'CABIN ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'GROUP STANDARD ELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'Campsite',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'GROUP SHELTER NONELECTRIC',\n",
       " 'GROUP WALK TO',\n",
       " 'LOOKOUT',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'GROUP SHELTER ELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'CABIN ELECTRIC',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'LOOKOUT',\n",
       " 'Campsite',\n",
       " 'LOOKOUT',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'CABIN NONELECTRIC',\n",
       " 'Campsite',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'GROUP TENT ONLY AREA NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'Campsite',\n",
       " 'CABIN ELECTRIC',\n",
       " 'Entry Point',\n",
       " 'GROUP STANDARD AREA NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'CABIN ELECTRIC',\n",
       " 'LOOKOUT',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " 'Campsite',\n",
       " ...]"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(filter_17CO['SiteType'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [],
   "source": [
    "siteList = ['CABIN ELECTRIC', 'CABIN NONELECTRIC', 'EQUESTRIAN NONELECTRIC', 'GROUP PICNIC AREA', 'GROUP SHELTER ELECTRIC',\n",
    "            'GROUP SHELTER NONELECTRIC', 'GROUP STANDARD AREA NONELECTRIC', 'GROUP STANDARD ELECTRIC', 'GROUP STANDARD NONELECTRIC',\n",
    "            'GROUP TENT ONLY AREA NONELECTRIC', 'GROUP WALK TO', 'LOOKOUT', 'RV ELECTRIC', 'STANDARD ELECTRIC', 'STANDARD NONELECTRIC', \n",
    "            'TENT ONLY NONELECTRIC', 'WALK TO']\n",
    "\n",
    "return17 = filter_17CO[filter_17CO['SiteType'].isin(siteList)]\n",
    "# return17"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [],
   "source": [
    "# check = return17[return17['SiteType'] == 'Natural and Cultural Hike']\n",
    "# check"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "return17.to_csv('clean_res17', index=False, header=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Repeat steps for 2018 data cleaning. Set list to filter exactly the same values for all data sets 2016-2020. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "c:\\users\\jrose\\appdata\\local\\programs\\python\\python39\\lib\\site-packages\\IPython\\core\\interactiveshell.py:3146: DtypeWarning: Columns (12,17,29,31,55) have mixed types.Specify dtype option on import or set low_memory=False.\n",
      "  has_raised = await self.run_ast_nodes(code_ast.body, cell_name,\n"
     ]
    }
   ],
   "source": [
    "filepath = ('reservations2018.csv')\n",
    "df_2018 = pd.read_csv(filepath, encoding='latin_1')\n",
    "# df_2018"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [],
   "source": [
    "list18_columns = list(df_2018.columns)\n",
    "# list18_columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "metadata": {},
   "outputs": [],
   "source": [
    "select_columns18 = ['OrderNumber', 'Park', 'SiteType', 'FacilityID', 'FacilityState', 'StartDate', 'EndDate', 'NumberOfPeople', 'Tent',\n",
    " 'Trailer', 'RVMotorhome']\n",
    "\n",
    "new_df18 = df_2018.loc[:, select_columns18]\n",
    "# new_df18"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "metadata": {},
   "outputs": [],
   "source": [
    "filter_18CO = new_df18[new_df18['FacilityState'] == 'CO']\n",
    "# filter_18CO.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'GROUP WALK TO',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'GROUP STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD ELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'TENT ONLY NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " 'STANDARD NONELECTRIC',\n",
       " ...]"
      ]
     },
     "execution_count": 99,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(filter_18CO['SiteType'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "metadata": {},
   "outputs": [],
   "source": [
    "siteList18 = ['CABIN ELECTRIC', 'CABIN NONELECTRIC', 'EQUESTRIAN NONELECTRIC', 'GROUP PICNIC AREA', 'GROUP SHELTER ELECTRIC',\n",
    "            'GROUP SHELTER NONELECTRIC', 'GROUP STANDARD AREA NONELECTRIC', 'GROUP STANDARD ELECTRIC', 'GROUP STANDARD NONELECTRIC',\n",
    "            'GROUP TENT ONLY AREA NONELECTRIC', 'GROUP WALK TO', 'LOOKOUT', 'RV ELECTRIC', 'STANDARD ELECTRIC', 'STANDARD NONELECTRIC', \n",
    "            'TENT ONLY NONELECTRIC', 'WALK TO']\n",
    "\n",
    "return18 = filter_18CO[filter_18CO['SiteType'].isin(siteList18)]\n",
    "# return18"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "metadata": {},
   "outputs": [],
   "source": [
    "# check = return18[return18['SiteType'] == 'Cliff Dwelling Tour']\n",
    "# check"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "metadata": {},
   "outputs": [],
   "source": [
    "return18.to_csv('clean_res18', index=False, header=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Repeat steps for 2019 data cleaning. Set list to filter exactly the same values for all data sets 2016-2020."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "c:\\users\\jrose\\appdata\\local\\programs\\python\\python39\\lib\\site-packages\\IPython\\core\\interactiveshell.py:3146: DtypeWarning: Columns (5,6,7,12,17,20,31,34) have mixed types.Specify dtype option on import or set low_memory=False.\n",
      "  has_raised = await self.run_ast_nodes(code_ast.body, cell_name,\n"
     ]
    }
   ],
   "source": [
    "filepath2 = ('reservations2019.csv')\n",
    "df_2019 = pd.read_csv(filepath2, encoding='latin_1')\n",
    "# df_2019"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['historicalreservationid',\n",
       " 'ordernumber',\n",
       " 'agency',\n",
       " 'orgid',\n",
       " 'codehierarchy',\n",
       " 'regioncode',\n",
       " 'regiondescription',\n",
       " 'parentlocationid',\n",
       " 'parentlocation',\n",
       " 'legacyfacilityid',\n",
       " 'park',\n",
       " 'sitetype',\n",
       " 'usetype',\n",
       " 'productid',\n",
       " 'inventorytype',\n",
       " 'facilityid',\n",
       " 'facilityzip',\n",
       " 'facilitystate',\n",
       " 'facilitylongitude',\n",
       " 'facilitylatitude',\n",
       " 'customerzip',\n",
       " 'customerstate',\n",
       " 'customercountry',\n",
       " 'tax',\n",
       " 'usefee',\n",
       " 'tranfee',\n",
       " 'attrfee',\n",
       " 'totalbeforetax',\n",
       " 'discount',\n",
       " 'totalpaid',\n",
       " 'startdate',\n",
       " 'enddate',\n",
       " 'orderdate',\n",
       " 'numberofpeople',\n",
       " 'equipmentdescription',\n",
       " 'equipmentlength']"
      ]
     },
     "execution_count": 135,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list19_columns = list(df_2019.columns)\n",
    "list19_columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "metadata": {},
   "outputs": [],
   "source": [
    "# list(df_2019['equipmentdescription'])\n",
    "#Returns NaN"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Need to rename columns before reorganizing dataframe\n",
    "rename19 = df_2019.rename(columns = {'ordernumber' : 'OrderNumber', 'park' : 'Park', 'sitetype' : 'SiteType',\n",
    "                          'facilityid' : 'FacilityID', 'facilitystate' : 'FacilityState', 'startdate' : 'StartDate',\n",
    "                          'enddate' : 'EndDate', 'numberofpeople' : 'NumberOfPeople'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "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>OrderNumber</th>\n",
       "      <th>Park</th>\n",
       "      <th>SiteType</th>\n",
       "      <th>FacilityID</th>\n",
       "      <th>FacilityState</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>NumberOfPeople</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0100084620-1</td>\n",
       "      <td>White Mountains National Recreation Area - Ala...</td>\n",
       "      <td>CABIN NONELECTRIC</td>\n",
       "      <td>252494</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>2019-01-26 00:00:00</td>\n",
       "      <td>2019-01-27 00:00:00</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0100162496-1</td>\n",
       "      <td>White Mountains National Recreation Area - Ala...</td>\n",
       "      <td>CABIN NONELECTRIC</td>\n",
       "      <td>252494</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>2019-03-26 00:00:00</td>\n",
       "      <td>2019-03-27 00:00:00</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0100328335-1</td>\n",
       "      <td>White Mountains National Recreation Area - Ala...</td>\n",
       "      <td>CABIN NONELECTRIC</td>\n",
       "      <td>252494</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>2019-08-26 00:00:00</td>\n",
       "      <td>2019-08-27 00:00:00</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0100404611-1</td>\n",
       "      <td>White Mountains National Recreation Area - Ala...</td>\n",
       "      <td>CABIN NONELECTRIC</td>\n",
       "      <td>252494</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>2018-11-23 00:00:00</td>\n",
       "      <td>2018-11-25 00:00:00</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0100444692-1</td>\n",
       "      <td>White Mountains National Recreation Area - Ala...</td>\n",
       "      <td>CABIN NONELECTRIC</td>\n",
       "      <td>252494</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>2019-08-28 00:00:00</td>\n",
       "      <td>2019-08-29 00:00:00</td>\n",
       "      <td>2.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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3479638</th>\n",
       "      <td>4-4609121-1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79052</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-11-02 00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3479639</th>\n",
       "      <td>4-4618681-1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79052</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-11-04 00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3479640</th>\n",
       "      <td>4-4626415-1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79052</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-11-20 00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3479641</th>\n",
       "      <td>4-4628875-1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79052</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-12-08 00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>47.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3479642</th>\n",
       "      <td>4-4635424-1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79052</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-11-02 00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3479643 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          OrderNumber                                               Park  \\\n",
       "0        0100084620-1  White Mountains National Recreation Area - Ala...   \n",
       "1        0100162496-1  White Mountains National Recreation Area - Ala...   \n",
       "2        0100328335-1  White Mountains National Recreation Area - Ala...   \n",
       "3        0100404611-1  White Mountains National Recreation Area - Ala...   \n",
       "4        0100444692-1  White Mountains National Recreation Area - Ala...   \n",
       "...               ...                                                ...   \n",
       "3479638   4-4609121-1                                                NaN   \n",
       "3479639   4-4618681-1                                                NaN   \n",
       "3479640   4-4626415-1                                                NaN   \n",
       "3479641   4-4628875-1                                                NaN   \n",
       "3479642   4-4635424-1                                                NaN   \n",
       "\n",
       "                  SiteType  FacilityID FacilityState            StartDate  \\\n",
       "0        CABIN NONELECTRIC      252494        Alaska  2019-01-26 00:00:00   \n",
       "1        CABIN NONELECTRIC      252494        Alaska  2019-03-26 00:00:00   \n",
       "2        CABIN NONELECTRIC      252494        Alaska  2019-08-26 00:00:00   \n",
       "3        CABIN NONELECTRIC      252494        Alaska  2018-11-23 00:00:00   \n",
       "4        CABIN NONELECTRIC      252494        Alaska  2019-08-28 00:00:00   \n",
       "...                    ...         ...           ...                  ...   \n",
       "3479638                NaN       79052           NaN  2018-11-02 00:00:00   \n",
       "3479639                NaN       79052           NaN  2018-11-04 00:00:00   \n",
       "3479640                NaN       79052           NaN  2018-11-20 00:00:00   \n",
       "3479641                NaN       79052           NaN  2018-12-08 00:00:00   \n",
       "3479642                NaN       79052           NaN  2018-11-02 00:00:00   \n",
       "\n",
       "                     EndDate  NumberOfPeople  \n",
       "0        2019-01-27 00:00:00             4.0  \n",
       "1        2019-03-27 00:00:00             1.0  \n",
       "2        2019-08-27 00:00:00             2.0  \n",
       "3        2018-11-25 00:00:00             5.0  \n",
       "4        2019-08-29 00:00:00             2.0  \n",
       "...                      ...             ...  \n",
       "3479638                  NaN             6.0  \n",
       "3479639                  NaN             4.0  \n",
       "3479640                  NaN             4.0  \n",
       "3479641                  NaN            47.0  \n",
       "3479642                  NaN             3.0  \n",
       "\n",
       "[3479643 rows x 8 columns]"
      ]
     },
     "execution_count": 138,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "select_columns19 = ['OrderNumber', 'Park', 'SiteType', 'FacilityID', 'FacilityState', 'StartDate', 'EndDate', 'NumberOfPeople']\n",
    "\n",
    "new_df19 = rename19.loc[:, select_columns19]\n",
    "new_df19"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>OrderNumber</th>\n",
       "      <th>Park</th>\n",
       "      <th>SiteType</th>\n",
       "      <th>FacilityID</th>\n",
       "      <th>FacilityState</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>NumberOfPeople</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8643</th>\n",
       "      <td>0100001554-1</td>\n",
       "      <td>Ruby Horsethief Canyon Permits</td>\n",
       "      <td>Campsite</td>\n",
       "      <td>74466</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>2019-06-09 00:00:00</td>\n",
       "      <td>2019-06-10 00:00:00</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8644</th>\n",
       "      <td>0100006365-1</td>\n",
       "      <td>Ruby Horsethief Canyon Permits</td>\n",
       "      <td>Campsite</td>\n",
       "      <td>74466</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>2019-07-18 00:00:00</td>\n",
       "      <td>2019-07-18 00:00:00</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8645</th>\n",
       "      <td>0100026514-1</td>\n",
       "      <td>Ruby Horsethief Canyon Permits</td>\n",
       "      <td>Campsite</td>\n",
       "      <td>74466</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>2019-09-07 00:00:00</td>\n",
       "      <td>2019-09-07 00:00:00</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8646</th>\n",
       "      <td>0100128589-1</td>\n",
       "      <td>Ruby Horsethief Canyon Permits</td>\n",
       "      <td>Campsite</td>\n",
       "      <td>74466</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>2019-04-25 00:00:00</td>\n",
       "      <td>2019-04-26 00:00:00</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8647</th>\n",
       "      <td>0100148549-1</td>\n",
       "      <td>Ruby Horsethief Canyon Permits</td>\n",
       "      <td>Campsite</td>\n",
       "      <td>74466</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>2019-04-19 00:00:00</td>\n",
       "      <td>2019-04-20 00:00:00</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       OrderNumber                            Park  SiteType  FacilityID  \\\n",
       "8643  0100001554-1  Ruby Horsethief Canyon Permits  Campsite       74466   \n",
       "8644  0100006365-1  Ruby Horsethief Canyon Permits  Campsite       74466   \n",
       "8645  0100026514-1  Ruby Horsethief Canyon Permits  Campsite       74466   \n",
       "8646  0100128589-1  Ruby Horsethief Canyon Permits  Campsite       74466   \n",
       "8647  0100148549-1  Ruby Horsethief Canyon Permits  Campsite       74466   \n",
       "\n",
       "     FacilityState            StartDate              EndDate  NumberOfPeople  \n",
       "8643      Colorado  2019-06-09 00:00:00  2019-06-10 00:00:00            14.0  \n",
       "8644      Colorado  2019-07-18 00:00:00  2019-07-18 00:00:00            25.0  \n",
       "8645      Colorado  2019-09-07 00:00:00  2019-09-07 00:00:00            14.0  \n",
       "8646      Colorado  2019-04-25 00:00:00  2019-04-26 00:00:00             3.0  \n",
       "8647      Colorado  2019-04-19 00:00:00  2019-04-20 00:00:00            25.0  "
      ]
     },
     "execution_count": 134,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filter_19CO = new_df19[new_df19['FacilityState'] == 'Colorado']\n",
    "filter_19CO.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "metadata": {},
   "outputs": [],
   "source": [
    "# check = filter_19CO[filter_19CO['SiteType'] == 'Historic Tour']\n",
    "# check"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "metadata": {},
   "outputs": [],
   "source": [
    "# list(filter_19CO['SiteType'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "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>OrderNumber</th>\n",
       "      <th>Park</th>\n",
       "      <th>SiteType</th>\n",
       "      <th>FacilityID</th>\n",
       "      <th>FacilityState</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>NumberOfPeople</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>123450</th>\n",
       "      <td>0100021594-1</td>\n",
       "      <td>SADDLEHORN CAMPGROUND</td>\n",
       "      <td>STANDARD NONELECTRIC</td>\n",
       "      <td>234778</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>2019-09-15 00:00:00</td>\n",
       "      <td>2019-09-16 00:00:00</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123451</th>\n",
       "      <td>0100064964-1</td>\n",
       "      <td>SADDLEHORN CAMPGROUND</td>\n",
       "      <td>STANDARD NONELECTRIC</td>\n",
       "      <td>234778</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>2019-07-13 00:00:00</td>\n",
       "      <td>2019-07-14 00:00:00</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123452</th>\n",
       "      <td>0100064964-2</td>\n",
       "      <td>SADDLEHORN CAMPGROUND</td>\n",
       "      <td>STANDARD NONELECTRIC</td>\n",
       "      <td>234778</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>2019-07-13 00:00:00</td>\n",
       "      <td>2019-07-14 00:00:00</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123453</th>\n",
       "      <td>0100106046-1</td>\n",
       "      <td>SADDLEHORN CAMPGROUND</td>\n",
       "      <td>STANDARD NONELECTRIC</td>\n",
       "      <td>234778</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>2019-05-28 00:00:00</td>\n",
       "      <td>2019-05-31 00:00:00</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123454</th>\n",
       "      <td>0100171248-1</td>\n",
       "      <td>SADDLEHORN CAMPGROUND</td>\n",
       "      <td>STANDARD NONELECTRIC</td>\n",
       "      <td>234778</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>2019-06-28 00:00:00</td>\n",
       "      <td>2019-06-29 00:00:00</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         OrderNumber                   Park              SiteType  FacilityID  \\\n",
       "123450  0100021594-1  SADDLEHORN CAMPGROUND  STANDARD NONELECTRIC      234778   \n",
       "123451  0100064964-1  SADDLEHORN CAMPGROUND  STANDARD NONELECTRIC      234778   \n",
       "123452  0100064964-2  SADDLEHORN CAMPGROUND  STANDARD NONELECTRIC      234778   \n",
       "123453  0100106046-1  SADDLEHORN CAMPGROUND  STANDARD NONELECTRIC      234778   \n",
       "123454  0100171248-1  SADDLEHORN CAMPGROUND  STANDARD NONELECTRIC      234778   \n",
       "\n",
       "       FacilityState            StartDate              EndDate  NumberOfPeople  \n",
       "123450      Colorado  2019-09-15 00:00:00  2019-09-16 00:00:00             2.0  \n",
       "123451      Colorado  2019-07-13 00:00:00  2019-07-14 00:00:00             3.0  \n",
       "123452      Colorado  2019-07-13 00:00:00  2019-07-14 00:00:00             2.0  \n",
       "123453      Colorado  2019-05-28 00:00:00  2019-05-31 00:00:00             4.0  \n",
       "123454      Colorado  2019-06-28 00:00:00  2019-06-29 00:00:00             1.0  "
      ]
     },
     "execution_count": 147,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "siteList19 = ['CABIN ELECTRIC', 'CABIN NONELECTRIC', 'EQUESTRIAN NONELECTRIC', 'GROUP PICNIC AREA', 'GROUP SHELTER ELECTRIC',\n",
    "            'GROUP SHELTER NONELECTRIC', 'GROUP STANDARD AREA NONELECTRIC', 'GROUP STANDARD ELECTRIC', 'GROUP STANDARD NONELECTRIC',\n",
    "            'GROUP TENT ONLY AREA NONELECTRIC', 'GROUP WALK TO', 'LOOKOUT', 'RV ELECTRIC', 'STANDARD ELECTRIC', 'STANDARD NONELECTRIC', \n",
    "            'TENT ONLY NONELECTRIC', 'WALK TO']\n",
    "\n",
    "return19 = filter_19CO[filter_19CO['SiteType'].isin(siteList19)]\n",
    "return19.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>OrderNumber</th>\n",
       "      <th>Park</th>\n",
       "      <th>SiteType</th>\n",
       "      <th>FacilityID</th>\n",
       "      <th>FacilityState</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>NumberOfPeople</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [OrderNumber, Park, SiteType, FacilityID, FacilityState, StartDate, EndDate, NumberOfPeople]\n",
       "Index: []"
      ]
     },
     "execution_count": 148,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# check = return19[return19['SiteType'] == 'Cliff Dwelling Tour']\n",
    "# check"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "return19.to_csv('clean_res19', index=False, header=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Repeat steps for 2020 data cleaning. Set list to filter exactly the same values for all data sets 2016-2020."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 152,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "c:\\users\\jrose\\appdata\\local\\programs\\python\\python39\\lib\\site-packages\\IPython\\core\\interactiveshell.py:3146: DtypeWarning: Columns (5,6,7,11,12,13,15,17,35) have mixed types.Specify dtype option on import or set low_memory=False.\n",
      "  has_raised = await self.run_ast_nodes(code_ast.body, cell_name,\n"
     ]
    }
   ],
   "source": [
    "df_2020 = pd.read_csv('FY20 Historical Reservations Full.csv', encoding='latin_1')\n",
    "# df_2020"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 153,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['historicalreservationid',\n",
       " 'ordernumber',\n",
       " 'agency',\n",
       " 'orgid',\n",
       " 'codehierarchy',\n",
       " 'regioncode',\n",
       " 'regiondescription',\n",
       " 'parentlocationid',\n",
       " 'parentlocation',\n",
       " 'legacyfacilityid',\n",
       " 'park',\n",
       " 'sitetype',\n",
       " 'usetype',\n",
       " 'productid',\n",
       " 'inventorytype',\n",
       " 'facilityid',\n",
       " 'facilityzip',\n",
       " 'facilitystate',\n",
       " 'facilitylongitude',\n",
       " 'facilitylatitude',\n",
       " 'customerzip',\n",
       " 'customerstate',\n",
       " 'customercountry',\n",
       " 'tax',\n",
       " 'usefee',\n",
       " 'tranfee',\n",
       " 'attrfee',\n",
       " 'totalbeforetax',\n",
       " 'discount',\n",
       " 'totalpaid',\n",
       " 'startdate',\n",
       " 'enddate',\n",
       " 'orderdate',\n",
       " 'nights',\n",
       " 'numberofpeople',\n",
       " 'equipmentdescription',\n",
       " 'equipmentlength']"
      ]
     },
     "execution_count": 153,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list20_columns = list(df_2020.columns)\n",
    "list20_columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 154,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Need to rename columns before reorganizing dataframe\n",
    "rename20 = df_2020.rename(columns = {'ordernumber' : 'OrderNumber', 'park' : 'Park', 'sitetype' : 'SiteType',\n",
    "                          'facilityid' : 'FacilityID', 'facilitystate' : 'FacilityState', 'startdate' : 'StartDate',\n",
    "                          'enddate' : 'EndDate', 'numberofpeople' : 'NumberOfPeople'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 155,
   "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>OrderNumber</th>\n",
       "      <th>Park</th>\n",
       "      <th>SiteType</th>\n",
       "      <th>FacilityID</th>\n",
       "      <th>FacilityState</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>NumberOfPeople</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0121072064-1</td>\n",
       "      <td>White Mountains National Recreation Area - Ala...</td>\n",
       "      <td>CABIN NONELECTRIC</td>\n",
       "      <td>252494</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>2019-10-17 00:00:00</td>\n",
       "      <td>2019-10-18 00:00:00</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0200063847-1</td>\n",
       "      <td>White Mountains National Recreation Area - Ala...</td>\n",
       "      <td>CABIN NONELECTRIC</td>\n",
       "      <td>252494</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>2020-04-11 00:00:00</td>\n",
       "      <td>2020-04-12 00:00:00</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0200087454-1</td>\n",
       "      <td>White Mountains National Recreation Area - Ala...</td>\n",
       "      <td>CABIN NONELECTRIC</td>\n",
       "      <td>252494</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>2020-09-07 00:00:00</td>\n",
       "      <td>2020-09-10 00:00:00</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0200102788-1</td>\n",
       "      <td>White Mountains National Recreation Area - Ala...</td>\n",
       "      <td>CABIN NONELECTRIC</td>\n",
       "      <td>252494</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>2020-03-21 00:00:00</td>\n",
       "      <td>2020-03-22 00:00:00</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0200147542-1</td>\n",
       "      <td>White Mountains National Recreation Area - Ala...</td>\n",
       "      <td>CABIN NONELECTRIC</td>\n",
       "      <td>252494</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>2019-12-07 00:00:00</td>\n",
       "      <td>2019-12-08 00:00:00</td>\n",
       "      <td>2.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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5114784</th>\n",
       "      <td>0299936603-1</td>\n",
       "      <td>Reservaciones para El Yunque / El Yunque Reser...</td>\n",
       "      <td>Nature Hike</td>\n",
       "      <td>300017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-09-05 00:00:00</td>\n",
       "      <td>2020-09-05 00:00:00</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5114785</th>\n",
       "      <td>0299948467-1</td>\n",
       "      <td>Reservaciones para El Yunque / El Yunque Reser...</td>\n",
       "      <td>Nature Hike</td>\n",
       "      <td>300017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-07-17 00:00:00</td>\n",
       "      <td>2020-07-17 00:00:00</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5114786</th>\n",
       "      <td>0299955580-1</td>\n",
       "      <td>Reservaciones para El Yunque / El Yunque Reser...</td>\n",
       "      <td>Nature Hike</td>\n",
       "      <td>300017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-07-12 00:00:00</td>\n",
       "      <td>2020-07-12 00:00:00</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5114787</th>\n",
       "      <td>0299963410-1</td>\n",
       "      <td>Reservaciones para El Yunque / El Yunque Reser...</td>\n",
       "      <td>Nature Hike</td>\n",
       "      <td>300017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-07-30 00:00:00</td>\n",
       "      <td>2020-07-30 00:00:00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5114788</th>\n",
       "      <td>0299996835-1</td>\n",
       "      <td>Reservaciones para El Yunque / El Yunque Reser...</td>\n",
       "      <td>Nature Hike</td>\n",
       "      <td>300017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-08-02 00:00:00</td>\n",
       "      <td>2020-08-02 00:00:00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5114789 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          OrderNumber                                               Park  \\\n",
       "0        0121072064-1  White Mountains National Recreation Area - Ala...   \n",
       "1        0200063847-1  White Mountains National Recreation Area - Ala...   \n",
       "2        0200087454-1  White Mountains National Recreation Area - Ala...   \n",
       "3        0200102788-1  White Mountains National Recreation Area - Ala...   \n",
       "4        0200147542-1  White Mountains National Recreation Area - Ala...   \n",
       "...               ...                                                ...   \n",
       "5114784  0299936603-1  Reservaciones para El Yunque / El Yunque Reser...   \n",
       "5114785  0299948467-1  Reservaciones para El Yunque / El Yunque Reser...   \n",
       "5114786  0299955580-1  Reservaciones para El Yunque / El Yunque Reser...   \n",
       "5114787  0299963410-1  Reservaciones para El Yunque / El Yunque Reser...   \n",
       "5114788  0299996835-1  Reservaciones para El Yunque / El Yunque Reser...   \n",
       "\n",
       "                  SiteType FacilityID FacilityState            StartDate  \\\n",
       "0        CABIN NONELECTRIC     252494        Alaska  2019-10-17 00:00:00   \n",
       "1        CABIN NONELECTRIC     252494        Alaska  2020-04-11 00:00:00   \n",
       "2        CABIN NONELECTRIC     252494        Alaska  2020-09-07 00:00:00   \n",
       "3        CABIN NONELECTRIC     252494        Alaska  2020-03-21 00:00:00   \n",
       "4        CABIN NONELECTRIC     252494        Alaska  2019-12-07 00:00:00   \n",
       "...                    ...        ...           ...                  ...   \n",
       "5114784        Nature Hike     300017           NaN  2020-09-05 00:00:00   \n",
       "5114785        Nature Hike     300017           NaN  2020-07-17 00:00:00   \n",
       "5114786        Nature Hike     300017           NaN  2020-07-12 00:00:00   \n",
       "5114787        Nature Hike     300017           NaN  2020-07-30 00:00:00   \n",
       "5114788        Nature Hike     300017           NaN  2020-08-02 00:00:00   \n",
       "\n",
       "                     EndDate  NumberOfPeople  \n",
       "0        2019-10-18 00:00:00             6.0  \n",
       "1        2020-04-12 00:00:00             1.0  \n",
       "2        2020-09-10 00:00:00             2.0  \n",
       "3        2020-03-22 00:00:00             3.0  \n",
       "4        2019-12-08 00:00:00             2.0  \n",
       "...                      ...             ...  \n",
       "5114784  2020-09-05 00:00:00             2.0  \n",
       "5114785  2020-07-17 00:00:00             1.0  \n",
       "5114786  2020-07-12 00:00:00             1.0  \n",
       "5114787  2020-07-30 00:00:00             0.0  \n",
       "5114788  2020-08-02 00:00:00             0.0  \n",
       "\n",
       "[5114789 rows x 8 columns]"
      ]
     },
     "execution_count": 155,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "select_columns20 = ['OrderNumber', 'Park', 'SiteType', 'FacilityID', 'FacilityState', 'StartDate', 'EndDate', 'NumberOfPeople']\n",
    "\n",
    "new_df20 = rename20.loc[:, select_columns20]\n",
    "new_df20"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "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>OrderNumber</th>\n",
       "      <th>Park</th>\n",
       "      <th>SiteType</th>\n",
       "      <th>FacilityID</th>\n",
       "      <th>FacilityState</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>NumberOfPeople</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10496</th>\n",
       "      <td>0100423628-1</td>\n",
       "      <td>Ruby Horsethief Canyon Permits</td>\n",
       "      <td>Campsite</td>\n",
       "      <td>74466</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>2019-10-11 00:00:00</td>\n",
       "      <td>2019-10-12 00:00:00</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10497</th>\n",
       "      <td>0101048363-1</td>\n",
       "      <td>Ruby Horsethief Canyon Permits</td>\n",
       "      <td>Campsite</td>\n",
       "      <td>74466</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>2019-11-26 00:00:00</td>\n",
       "      <td>2019-11-29 00:00:00</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10498</th>\n",
       "      <td>0102040859-1</td>\n",
       "      <td>Ruby Horsethief Canyon Permits</td>\n",
       "      <td>Campsite</td>\n",
       "      <td>74466</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>2019-10-25 00:00:00</td>\n",
       "      <td>2019-10-27 00:00:00</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10499</th>\n",
       "      <td>0102354306-1</td>\n",
       "      <td>Ruby Horsethief Canyon Permits</td>\n",
       "      <td>Campsite</td>\n",
       "      <td>74466</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>2019-10-11 00:00:00</td>\n",
       "      <td>2019-10-12 00:00:00</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10500</th>\n",
       "      <td>0102533033-1</td>\n",
       "      <td>Ruby Horsethief Canyon Permits</td>\n",
       "      <td>Campsite</td>\n",
       "      <td>74466</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>2019-11-03 00:00:00</td>\n",
       "      <td>2019-11-09 00:00:00</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        OrderNumber                            Park  SiteType FacilityID  \\\n",
       "10496  0100423628-1  Ruby Horsethief Canyon Permits  Campsite      74466   \n",
       "10497  0101048363-1  Ruby Horsethief Canyon Permits  Campsite      74466   \n",
       "10498  0102040859-1  Ruby Horsethief Canyon Permits  Campsite      74466   \n",
       "10499  0102354306-1  Ruby Horsethief Canyon Permits  Campsite      74466   \n",
       "10500  0102533033-1  Ruby Horsethief Canyon Permits  Campsite      74466   \n",
       "\n",
       "      FacilityState            StartDate              EndDate  NumberOfPeople  \n",
       "10496      Colorado  2019-10-11 00:00:00  2019-10-12 00:00:00            14.0  \n",
       "10497      Colorado  2019-11-26 00:00:00  2019-11-29 00:00:00            10.0  \n",
       "10498      Colorado  2019-10-25 00:00:00  2019-10-27 00:00:00            25.0  \n",
       "10499      Colorado  2019-10-11 00:00:00  2019-10-12 00:00:00             9.0  \n",
       "10500      Colorado  2019-11-03 00:00:00  2019-11-09 00:00:00             4.0  "
      ]
     },
     "execution_count": 158,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filter_20CO = new_df20[new_df20['FacilityState'] == 'Colorado']\n",
    "filter_20CO.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 157,
   "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>OrderNumber</th>\n",
       "      <th>Park</th>\n",
       "      <th>SiteType</th>\n",
       "      <th>FacilityID</th>\n",
       "      <th>FacilityState</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>NumberOfPeople</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>123450</th>\n",
       "      <td>0100021594-1</td>\n",
       "      <td>SADDLEHORN CAMPGROUND</td>\n",
       "      <td>STANDARD NONELECTRIC</td>\n",
       "      <td>234778</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>2019-09-15 00:00:00</td>\n",
       "      <td>2019-09-16 00:00:00</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123451</th>\n",
       "      <td>0100064964-1</td>\n",
       "      <td>SADDLEHORN CAMPGROUND</td>\n",
       "      <td>STANDARD NONELECTRIC</td>\n",
       "      <td>234778</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>2019-07-13 00:00:00</td>\n",
       "      <td>2019-07-14 00:00:00</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123452</th>\n",
       "      <td>0100064964-2</td>\n",
       "      <td>SADDLEHORN CAMPGROUND</td>\n",
       "      <td>STANDARD NONELECTRIC</td>\n",
       "      <td>234778</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>2019-07-13 00:00:00</td>\n",
       "      <td>2019-07-14 00:00:00</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123453</th>\n",
       "      <td>0100106046-1</td>\n",
       "      <td>SADDLEHORN CAMPGROUND</td>\n",
       "      <td>STANDARD NONELECTRIC</td>\n",
       "      <td>234778</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>2019-05-28 00:00:00</td>\n",
       "      <td>2019-05-31 00:00:00</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123454</th>\n",
       "      <td>0100171248-1</td>\n",
       "      <td>SADDLEHORN CAMPGROUND</td>\n",
       "      <td>STANDARD NONELECTRIC</td>\n",
       "      <td>234778</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>2019-06-28 00:00:00</td>\n",
       "      <td>2019-06-29 00:00:00</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         OrderNumber                   Park              SiteType  FacilityID  \\\n",
       "123450  0100021594-1  SADDLEHORN CAMPGROUND  STANDARD NONELECTRIC      234778   \n",
       "123451  0100064964-1  SADDLEHORN CAMPGROUND  STANDARD NONELECTRIC      234778   \n",
       "123452  0100064964-2  SADDLEHORN CAMPGROUND  STANDARD NONELECTRIC      234778   \n",
       "123453  0100106046-1  SADDLEHORN CAMPGROUND  STANDARD NONELECTRIC      234778   \n",
       "123454  0100171248-1  SADDLEHORN CAMPGROUND  STANDARD NONELECTRIC      234778   \n",
       "\n",
       "       FacilityState            StartDate              EndDate  NumberOfPeople  \n",
       "123450      Colorado  2019-09-15 00:00:00  2019-09-16 00:00:00             2.0  \n",
       "123451      Colorado  2019-07-13 00:00:00  2019-07-14 00:00:00             3.0  \n",
       "123452      Colorado  2019-07-13 00:00:00  2019-07-14 00:00:00             2.0  \n",
       "123453      Colorado  2019-05-28 00:00:00  2019-05-31 00:00:00             4.0  \n",
       "123454      Colorado  2019-06-28 00:00:00  2019-06-29 00:00:00             1.0  "
      ]
     },
     "execution_count": 157,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "siteList20 = ['CABIN ELECTRIC', 'CABIN NONELECTRIC', 'EQUESTRIAN NONELECTRIC', 'GROUP PICNIC AREA', 'GROUP SHELTER ELECTRIC',\n",
    "            'GROUP SHELTER NONELECTRIC', 'GROUP STANDARD AREA NONELECTRIC', 'GROUP STANDARD ELECTRIC', 'GROUP STANDARD NONELECTRIC',\n",
    "            'GROUP TENT ONLY AREA NONELECTRIC', 'GROUP WALK TO', 'LOOKOUT', 'RV ELECTRIC', 'STANDARD ELECTRIC', 'STANDARD NONELECTRIC', \n",
    "            'TENT ONLY NONELECTRIC', 'WALK TO']\n",
    "\n",
    "return20 = filter_20CO[filter_20CO['SiteType'].isin(siteList20)]\n",
    "return20.head()"
   ]
  }
 ],
 "metadata": {
  "hide_input": false,
  "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.9.1"
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}