classroom_availability_scraper.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "!pip install BeautifulSoup4 requests lxml"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "from requests.exceptions import RequestException\n",
    "from contextlib import closing\n",
    "from bs4 import BeautifulSoup\n",
    "import json\n",
    "import pandas as pd\n",
    "import time"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "url = 'https://y.byu.edu/class_schedule/cgi/freeRoomChart.cgi'\n",
    "\n",
    "x = requests.post(url, data = {})\n",
    "\n",
    "html = BeautifulSoup(x.text, 'html.parser')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'ARoom': 'A', 'BRoom': 'B', 'RRoom': 'R', 'QRoom': 'Q', 'year_term_type': 'CLASS_DATES', 'use_start_date': '2021-5', 'use_end_date': '', 'building_set': '', 'from_capacity': '', 'to_capacity': '999', 'stationTypeSelectValue': '', 'stationTypeSelectSM': 'Open+area+(not+normally+set+up+with+chairs)', 'floorLevelSelectValue': '', 'floorLevelSelectSM': 'Level', 'c': 'freeRoomChart', 'e': '@Search', 'start_building': '', 'start_room': '', 'search_direction': 'N', 'sort': 'B'}\n"
     ]
    }
   ],
   "source": [
    "\n",
    "# json_text = '{\"ARoom\":\"A\",\"BRoom\":\"B\",\"year_term_type\":\"CLASS_DATES\",\"use_start_date\":\"30+Apr+2019\",\"use_end_date\":\"17+Jun+2019\",\"building_set\":\"ASB\",\"from_capacity\":\"\",\"to_capacity\":\"999\",\"stationTypeSelectValue\":\"\",\"stationTypeSelectSM\":\"Open+area+(not+normally+set+up+with+chairs)\",\"floorLevelSelectValue\":\"\",\"floorLevelSelectSM\":\"Level\",\"brownie\":\"5a3086399345dbb57644791d9cfc01ffe509c9b61a2881e234321bf4cb8c6a18ff51fa9b70dab9c6446fb42866976d39b3d9dea2d71d650b1b99bd589e54ab9362105b6653059d421b6df49f8cf8446136359e30c0aa67adf7693f5745e0d492092f66ce118701543541469d44ef17c3a32370083b10b9606df98b4529eaebaae23b9eabd23339ac7127d7ff8ebc653a2a6b311a1cb0b9e964db2caed81acaaef897871726788d2eab1fabeaf2582d369e7d7f89604bafe950a1562e1e46c28c5f93eb1e59ed9903fa3625f7985eb79b91c3dd2888f6ebc6794dfdc72fc6c0b6b251ea72ae0fdf55045b389d4ff5de07c1c214eb046dcadb3594031bed77e80b78639ef3c6a659f14b5296b5aca260e65d39d7501f11da17b48f0807531fb93f1a3cc6170494cc3d15dd265ff041c7b4f6c6f2cf38797bf288e7ec3376723755f5e7c598f35d37787681\",\"c\":\"freeRoomChart\",\"e\":\"@Search\",\"start_building\":\"\",\"start_room\":\"\",\"search_direction\":\"N\",\"rooms\":\"MCKB##115##20193##MCKB##115##202##B##MTWRF##MTWRF##MTWRF##MTWRF##MTW_F##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MCKB##220##20193##MCKB##220##32##B##MTWRF##M_W_F##____F##____F##_T_RF##____F##____F##____F##M_WRF##M_WRF##M_WRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MCKB##230##20193##MCKB##230##32##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##____F##____F##M_W_F##_T_RF##_T_RF##_T_RF##_T_RF##MTWRF##MTWRF##MTWRF##MCKB##238##20193##MCKB##238##32##B##MTWRF##____F##____F##____F##_T_RF##____F##____F##M_W_F##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MCKB##26##20193##MCKB##26##30##B##M_WRF##M_WRF##M_WRF##__WRF##_TWRF##__W_F##__W_F##__W_F##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MCKB##270##20193##MCKB##270##32##B##MTWRF##MTWRF##M_W_F##M_W_F##MTWRF##_T_RF##_T_RF##_T_RF##MTWRF##M_W_F##M_W_F##M_W_F##M_W_F##MTWRF##MTWRF##MTWRF##MCKB##276##20193##MCKB##276##32##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##_T_RF##_T_RF##_T_RF##M_W_F##M_W_F##M_W_F##MTWRF##MTWRF##MTWRF##MTWRF##MCKB##277##20193##MCKB##277##32##B##MTWRF##MTW_F##MTW_F##MTW_F##MTW_F##MTWRF##MTWRF##MTWRF##_TWRF##_TWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MCKB##280##20193##MCKB##280##32##B##MTWRF##_T_RF##_T_RF##_T_RF##_T_RF##M_W_F##__W_F##__W_F##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MCKB##283##20193##MCKB##283##25##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##_T_RF##_T_RF##_T_RF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MCKB##319##20193##MCKB##319##20##B##MTWRF##MTWRF##_____##_____##_T___##_____##_____##_T_R_##_T_R_##MTWRF##MTWR_##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MCKB##331##20193##MCKB##331##32##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##_T_RF##_T_RF##MTWRF##_T_RF##_T_RF##_T_RF##MTWRF##MTWRF##MTWRF##MTWRF##MCKB##341##20193##MCKB##341##32##B##MTWRF##M_W_F##____F##____F##_T_RF##MTWRF##MTWRF##MTWRF##MTWRF##____F##____F##____F##MTWRF##MTWRF##MTWRF##MTWRF##MCKB##355##20193##MCKB##355##32##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##M_W_F##M_W_F##M_W_F##M_WRF##M___F##M___F##M___F##MTWRF##MTWRF##MTWRF##MTWRF##MCKB##359##20193##MCKB##359##32##B##MTWRF##MTWRF##M_W_F##MTWRF##MTWRF##M_W_F##M_W_F##M_W_F##MTWRF##___RF##___RF##___RF##MTWRF##MTWRF##MTWRF##MTWRF##MSRB##202##20193##MSRB##202##40##B##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##MSRB##211##20193##MSRB##211##20##B##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##MSRB##241##20193##MSRB##241##20##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##_T_R_##_T_R_##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MSRB##250##20193##MSRB##250##60##B##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##MSRB##321##20193##MSRB##321##169##B##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##RB##106##20193##RB##106##80##B##MTWRF##M_W_F##M_W_F##_____##_T_R_##M___F##M___F##MTWRF##MTWRF##MTWRF##M_W_F##M_W_F##M_W_F##MTWRF##MTWRF##MTWRF##RB##177##20193##RB##177##60##A##____F##____F##____F##____F##MTWRF##_____##_____##____F##____F##_____##_____##MTWR_##MTWRF##MTWRF##MTWRF##MTWRF##RB##202##20193##RB##202##26##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##_T_RF##_T_RF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##RB##204##20193##RB##204##35##B##MTWRF##MTWRF##MTWRF##_T_RF##_T_RF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##RB##206##20193##RB##206##42##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##_____##MTWR_##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##RB##257##20193##RB##257##34##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##M_WRF##M_WRF##M_WRF##M_WRF##MTWRF##RB##267##20193##RB##267##236##B##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##RB##271##20193##RB##271##112##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##ROTC##241##20193##ROTC##241##21##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##ROTC##250##20193##ROTC##250##43##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTW_F##MTW_F##MTW_F##MTW_F##MTW_F##ROTC##261##20193##ROTC##261##24##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##SFH##191##20193##SFH##191##49##B##MTWRF##MTWRF##MTWRF##____F##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##M_WRF##M_WRF##M_WRF##M_WRF##MTWRF##MTWRF##MTWRF##SFH##249L##20193##SFH##249L##48##B##MTWRF##MTWRF##MTWRF##M_W_F##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##SFH##255##20193##SFH##255##48##B##MTWRF##MTWRF##MTWRF##_T_R_##_T_R_##M_W_F##M_W_F##M_W_F##MTWRF##MTWRF##MTWRF##M__RF##M__RF##M__RF##M__RF##MTWRF##SFH##277##20193##SFH##277##43##B##MTWRF##____F##____F##____F##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##SFH##281##20193##SFH##281##48##B##MTWRF##_T_R_##_T_R_##MTWRF##MTWRF##_T_RF##_T_RF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##SNLB##170##20193##SNLB##170##42##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TMCB##104##20193##TMCB##104##42##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##_T_R_##_T_R_##_T_R_##_T_R_##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TMCB##108##20193##TMCB##108##42##B##MTWRF##_T_R_##_T_R_##_T_R_##_T_R_##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TMCB##111##20193##TMCB##111##61##B##MTWRF##_____##_____##_____##MTWRF##_____##_____##MTWRF##MTWRF##MTWRF##____F##____F##MTWRF##MTWRF##MTWRF##MTWRF##TMCB##112##20193##TMCB##112##42##B##MTWRF##MTWRF##MTWRF##MTWRF##MT_RF##MTWRF##MTWRF##_T_R_##_T_R_##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TMCB##116##20193##TMCB##116##42##B##MTWRF##MTWRF##_____##_T_R_##_T_R_##_T_R_##_T_R_##_____##_____##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TMCB##1170##20193##TMCB##1170##203##B##MTWRF##MTWRF##MTWRF##_T_R_##_T___##MTW_F##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TMCB##120##20193##TMCB##120##41##B##MTWRF##MTWRF##_T_R_##_T_R_##_T_R_##_T_R_##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TMCB##121##20193##TMCB##121##35##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TMCB##133##20193##TMCB##133##24##B##MTWRF##MTWRF##_____##_____##_T_R_##_____##_____##_____##_____##_____##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TMCB##134##20193##TMCB##134##34##B##MT__F##MT__F##_____##_____##MT__F##MT__F##_T___##_T_R_##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TMCB##135##20193##TMCB##135##42##B##MTWRF##MTWRF##MTWRF##MTWRF##MT_RF##MTWRF##MTWRF##MTWRF##MTWRF##M_W_F##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TMCB##136##20193##TMCB##136##40##B##MTWRF##MTWRF##MTWRF##MTWRF##_T_R_##_T_R_##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TMCB##197##20193##TMCB##197##30##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TMCB##299##20193##TMCB##299##34##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##_T_RF##M_W_F##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TMCB##323##20193##TMCB##323##24##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TNRB##110##20193##TNRB##110##70##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TNRB##120##20193##TNRB##120##70##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##M_W_F##M_W_F##M_W_F##MTWRF##MT_RF##MT_RF##MT_RF##MT_RF##MTWRF##MTWRF##TNRB##130##20193##TNRB##130##70##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##_T_RF##_T_RF##MTWRF##_T_RF##_T_RF##_T_RF##MTWRF##MTWRF##MTWRF##MTWRF##TNRB##151##20193##TNRB##151##344##B##MTWR_##MTWR_##MTWR_##MTWR_##_TW__##_TW__##MTWRF##MTWRF##MTWRF##M_WRF##M_WRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TNRB##164##20193##TNRB##164##37##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TNRB##170##20193##TNRB##170##43##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TNRB##174##20193##TNRB##174##51##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TNRB##180##20193##TNRB##180##51##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TNRB##184##20193##TNRB##184##51##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TNRB##210##20193##TNRB##210##70##B##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##TNRB##220##20193##TNRB##220##70##B##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##TNRB##230##20193##TNRB##230##70##B##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##TNRB##240##20193##TNRB##240##65##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##_T_RF##_T_RF##_T_RF##_T_RF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TNRB##251##20193##TNRB##251##170##B##MTWR_##M_W__##M_W__##M_W__##MTWR_##_T_R_##_T_RF##_T_RF##_T_RF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TNRB##260##20193##TNRB##260##100##B##MTWRF##____F##____F##____F##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##M_W_F##M_W_F##M_W_F##M_W_F##MTWRF##MTWRF##TNRB##264##20193##TNRB##264##28##B##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##TNRB##270##20193##TNRB##270##43##B##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##TNRB##280##20193##TNRB##280##80##B##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##TNRB##284##20193##TNRB##284##80##B##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##_____##TNRB##324##20193##TNRB##324##32##B##MTWRF##_T_RF##_T_R_##_T_R_##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##M_W_F##M_W_F##M_W_F##M_W_F##TNRB##374##20193##TNRB##374##54##B##MTWRF##M____##M____##M____##M____##MTWR_##MTWR_##M_WR_##_____##_____##_____##_T__F##MT__F##MTWRF##MTWRF##MTWRF##TNRB##484##20193##TNRB##484##48##B##MTWRF##M_W_F##M_W_F##M_W_F##MTWRF##M_W_F##M_W_F##M_W_F##M_W_F##MTWRF##MTW_F##MTW_F##MTW_F##MTW_F##MTWRF##MTWRF##TNRB##W108##20193##TNRB##W108##46##B##MTWRF##_T_R_##_T_R_##_T_R_##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##M_WRF##M_WRF##M_WRF##M_WRF##MTWRF##MTWRF##TNRB##W110##20193##TNRB##W110##46##B##MTWRF##_T_R_##_____##_____##_T__F##_T_RF##_T_RF##MTWR_##MTWR_##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TNRB##W118##20193##TNRB##W118##46##B##MTWRF##MTWRF##_____##_____##_____##_____##_____##_____##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TNRB##W122##20193##TNRB##W122##46##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TNRB##W208##20193##TNRB##W208##70##B##MTWRF##M_W_F##M_W_F##M_W_F##_T_RF##_T_RF##_T_RF##MT_RF##MT_RF##M_WRF##M_WRF##M_WRF##M_WRF##MTWRF##MTWRF##MTWRF##TNRB##W210##20193##TNRB##W210##70##B##MTWRF##M_W__##M_W__##M_W__##_T_RF##_T_RF##_T_RF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TNRB##W240##20193##TNRB##W240##70##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TNRB##W242##20193##TNRB##W242##70##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##M_W_F##M_W_F##M_W_F##M_W_F##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TNRB##W308##20193##TNRB##W308##70##B##MTWRF##MTWRF##____F##____F##MTWRF##____F##____F##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##TNRB##W310##20193##TNRB##W310##70##B##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##MTWRF##\",\"sort\":\"B\",\"freeRoomChartTxt\":\"=0104672656520526F6F6D204368617274=020434C533131=00830303130343500436C617373205363686564756C65=04A4E004E0041494D402E2E2F2E2E2F757365725F68656C702F6367692F6D61696E4D656E752E636769=0FF=0AF636F72616C406279752E656475=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0311=0164D434B4200313135=006544E5242005733313=0227=00616=006323031393300434C4153535F4441544553=0263330204170722032303139=0103137204A756E2032303139=0FF=0FF=026E703=00C2741272C274227=0FF=0FF=0864E=0FF=07D4D434B4200313135=0189D=F06=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0B873797374656D4572726F72=0B2506C656173652074727920796F757220616374696F6E20616761696E2E205468652070726F6772616D2077617320756E61626C6520746F20636F6D706C6574652074686520616374696F6E20796F75207265717565737465642E20496620796F7520636F6E74696E756520746F20657870657269656E63652070726F626C656D7320796F75206D61792074727920616761696E2061742061206C617465722074696D65206F7220636F6E74616374206F757220637573746F6D6572207365727669636520737461666620617420312D3830312D3432322D3430303020666F7220617373697374616E63652E=0FF=0FF=0FF=0FF=0FF=0FFF401=00C666F7262696464656E50616765=0AE50616765204E6F7420466F756E642E2057652061726520736F72727920627574207765207765726520756E61626C6520746F2061636365737320746865207365727669636520796F75207265717565737465642E20496620796F752062656C69657665207468697320746F20626520696E206572726F722C20706C6561736520636F6E74616374206F757220637573746F6D6572207365727669636520737461666620617420312D3830312D3432322D3430303020666F7220617373697374616E63652E=0FF=0FF=0FF=0FF=0FF=0FF=04E9301=00C7265736F757263654E6F74466F756E64=0A85265736F75726365206E6F7420666F756E642E=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0B19401=00C6765744D6574686F644E6F74537570706F72746564=09E474554206D6574686F64206E6F7420737570706F727465642E=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0A59501=00C7075744D6574686F644E6F74537570706F72746564=09E505554206D6574686F64206E6F7420737570706F727465642E=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0A59501=00C706F73744D6574686F644E6F74537570706F72746564=09C504F5354206D6574686F64206E6F7420737570706F727465642E=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0A39501=00C707574416E64506F73744D6574686F64734E6F74537570706F72746564=08E50555420616E6420504F5354206D6574686F6473206E6F7420737570706F727465642E=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0919501=00C64656C6574654D6574686F644E6F74537570706F72746564=09844454C455445206D6574686F64206E6F7420737570706F727465642E=0FF=0FF=0FF=0FF=0FF=0FF=0FF=09F9501=00C746F6F4D616E79506174684964656E74696669657273=09C546F6F206D616E792070617468206964656E746966696572732E=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0A39001=00C72657175697265537461727444617465=0A84120737461727420646174652069732072657175697265642E=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0A59001=00C6E6F526F6F6D57697468417474726962757465=0A24E6F20726F6F6D73207765726520666F756E642077697468207468652073706563696669656420617474726962757465732E=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0739001=00C726571756972655061676541747472696275746541626F76653=0954120706167652061747472696275746520697320726571756972656420616E64206D757374206861766520612076616C7565206F662031206F7220677265617465722E=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0519001=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0BC54=00654=0064D434B42003131350002003230313835003230313934004200C3C601CA=00641554449544F5249554D0009357F=08C4D545752465355004D545752465355004D545752465355004D545752465355004D545720465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=0124D434B42003232300002003230313835003230313934004200C3C6012=007434C415353524F4F4D=0059357F=08C4D545752465355004D205720465355002020202046535500202020204653550020542052465355002020202046535500202020204653550020202020465355004D205752465355004D205752465355004D205752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=0124D434B42003233300002003230313835003230313934004200C3C6012=007434C415353524F4F4D=0059357F=08C4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D54575246535500202020204653550020202020465355004D2057204653550020542052465355002054205246535500205420524653550020542052465355004D545752465355004D545752465355004D545752465355=0124D434B42003233380002003230313835003230313934004200C3C6012=007434C415353524F4F4D=0059357F=08C4D545752465355002020202046535500202020204653550020202020465355002054205246535500202020204653550020202020465355004D205720465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=0124D434B42003236=0052003230313835003230313934004200C3C6011E=006434C5353524F4F4D=0079357F=08C4D205752465355004D205752465355004D20575246535500202057524653550020545752465355002020572046535500202057204653550020205720465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=0124D434B42003237300002003230313835003230313934004200C3C6012=007434C415353524F4F4D=0059357F=08C4D545752465355004D545752465355004D205720465355004D205720465355004D545752465355002054205246535500205420524653550020542052465355004D545752465355004D205720465355004D205720465355004D205720465355004D205720465355004D545752465355004D545752465355004D545752465355=0124D434B42003237360002003230313835003230313934004200C3C6012=007434C415353524F4F4D=0059357F=08C4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355002054205246535500205420524653550020542052465355004D205720465355004D205720465355004D205720465355004D545752465355004D545752465355004D545752465355004D545752465355=0124D434B42003237370002003230313835003230313934004200C3C6012=007434C415353524F4F4D=0059357F=08C4D545752465355004D545720465355004D545720465355004D545720465355004D545720465355004D545752465355004D545752465355004D54575246535500205457524653550020545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=0124D434B42003238300002003230313835003230313934004200C3C6012=007434C415353524F4F4D=0059357F=08C4D5457524653550020542052465355002054205246535500205420524653550020542052465355004D20572046535500202057204653550020205720465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=0124D434B42003238330002003230313931003230313934004200C3C60119=006434C415353524F4F4D=0059357F=08C4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355002054205246535500205420524653550020542052465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=0124D434B42003331390002003230313835003230313934004200C3C60114=006434C415353524F4F4D=0059357F=08C4D545752465355004D5457524653550020202020205355002020202020535500205420202053550020202020205355002020202020535500205420522053550020542052205355004D545752465355004D545752205355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=0124D434B4200=30510002003230313835003230313934004200C3C6012=007434C415353524F4F4D=0059357F=08C4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D54575246535500205420524653550020542052465355004D545752465355002054205246535500205420524653550020542052465355004D545752465355004D545752465355004D545752465355004D545752465355=0124D434B42003334310002003230313835003230313934004200C3C6012=007434C415353524F4F4D=0059357F=08C4D545752465355004D205720465355002020202046535500202020204653550020542052465355004D545752465355004D545752465355004D545752465355004D545752465355002020202046535500202020204653550020202020465355004D545752465355004D545752465355004D545752465355004D545752465355=0124D434B42003335350002003230313835003230313934004200C3C6012=007434C415353524F4F4D=0059357F=08C4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D205720465355004D205720465355004D205720465355004D205752465355004D202020465355004D202020465355004D202020465355004D545752465355004D545752465355004D545752465355004D545752465355=0124D434B42003335390002003230313835003230313934004200C3C6012=007434C415353524F4F4D=0059357F=08C4D545752465355004D545752465355004D205720465355004D545752465355004D545752465355004D205720465355004D205720465355004D205720465355004D545752465355002020205246535500202020524653550020202052465355004D545752465355004D545752465355004D545752465355004D545752465355=0124D535242003230320002003230313835003230313934004200C3C60128=006434C415353524F4F4D=0059357F=08C20202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355=0124D535242003231310002003230313835003230313934004200C3C60114=006434C415353524F4F4D=0059357F=08C20202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355=0124D535242003234310002003230313835003230313934004200C3C60114=006434C415353524F4F4D=0059357F=08C4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D54575246535500205420522053550020542052205355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=0124D535242003235300002003230313835003230313934004200C3C6013C=006434C415353524F4F4D=0059357F=08C20202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355=0124D535242003332310002003230313835003230313934004200C3C601A9=0064C4543545552452035394C2031313055=08820202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355=01252420042003130360002003230313835003230313934004200C3C6015=007434C415353524F4F4D004C2031313055=0884D545752465355004D205720465355004D20572046535500202020202053550020542052205355004D202020465355004D202020465355004D545752465355004D545752465355004D545752465355004D205720465355004D205720465355004D205720465355004D545752465355004D545752465355004D545752465355=01252420042003137370002003230313835003230313934004100C3C6013C=0064D554C54492D505552504F534520434C415353524F4F4D=07A20202020465355002020202046535500202020204653550020202020465355004D545752465355002020202020535500202020202053550020202020465355002020202046535500202020202053550020202020205355004D545752205355004D545752465355004D545752465355004D545752465355004D545752465355=01252420042003230320002003230313835003230313934004200C3C6011A=006434C415353524F4F4D004F534520434C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D54575246535500205420524653550020542052465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=01252420042003230340002003230313835003230313934004200C3C60123=006434C415353524F4F4D004F534520434C415353524F4F4D=07A4D545752465355004D545752465355004D54575246535500205420524653550020542052465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=01252420042003230360002003230313835003230313934004200C3C6012A=006434C415353524F4F4D004F534520434C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D5457524653550020202020205355004D545752205355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=01252420042003235370002003230313835003230313934004200C3C60122=006434C415353524F4F4D004F534520434C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D205752465355004D205752465355004D205752465355004D205752465355004D545752465355=01252420042003236370002003230313835003230313934004200C3C601EC=00641554449544F5249554D00534520434C415353524F4F4D=07A20202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355=01252420042003237310002003230313835003230313934004200C3C6017=007434C415353524F4F4D0000534520434C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012524F5443003234310002003230313835003230313934004200C3C60115=006434C415353524F4F4D0000534520434C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012524F5443003235300002003230313835003230313934004200C3C6012B=006434C415353524F4F4D0000534520434C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545720465355004D545720465355004D545720465355004D545720465355004D545720465355=012524F5443003236310002003230313835003230313934004200C3C60118=006434C415353524F4F4D0000534520434C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=01253464800003139310002003230313835003230313934004200C3C60131=006434C415353524F4F4D0000534520434C415353524F4F4D=07A4D545752465355004D545752465355004D5457524653550020202020465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D205752465355004D205752465355004D205752465355004D205752465355004D545752465355004D545752465355004D545752465355=01253464800003234394C00003230313835003230313934004200C3C6013=007434C415353524F4F4D0000534520434C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D205720465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=0125346480000323535=0063230313835003230313934004200C3C6013=007434C415353524F4F4D0000534520434C415353524F4F4D=07A4D545752465355004D545752465355004D54575246535500205420522053550020542052205355004D205720465355004D205720465355004D205720465355004D545752465355004D545752465355004D545752465355004D202052465355004D202052465355004D202052465355004D202052465355004D545752465355=0125346480000323737=0063230313835003230313934004200C3C6012B=006434C415353524F4F4D0000534520434C415353524F4F4D=07A4D545752465355002020202046535500202020204653550020202020465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=0125346480000323831=0063230313835003230313934004200C3C6013=007434C415353524F4F4D0000534520434C415353524F4F4D=07A4D54575246535500205420522053550020542052205355004D545752465355004D54575246535500205420524653550020542052465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012534E4C420031373=0073230313835003230313934004200C3C6012A=006434C415353524F4F4D0000534520434C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544D434200313034=0063230313835003230313934004200C3C6012A=006434C415353524F4F4D0000534520434C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D5457524653550020542052205355002054205220535500205420522053550020542052205355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544D434200313038=0063230313835003230313934004200C3C6012A=006434C415353524F4F4D0000534520434C415353524F4F4D=07A4D5457524653550020542052205355002054205220535500205420522053550020542052205355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544D434200313131=0063230313835003230313934004200C3C6013D=006434C415353524F4F4D0000534520434C415353524F4F4D=07A4D545752465355002020202020535500202020202053550020202020205355004D54575246535500202020202053550020202020205355004D545752465355004D545752465355004D54575246535500202020204653550020202020465355004D545752465355004D545752465355004D545752465355004D545752465355=012544D434200313132=0063230313835003230313934004200C3C6012A=006434C415353524F4F4D0000534520434C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D542052465355004D545752465355004D54575246535500205420522053550020542052205355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544D434200313136=0063230313835003230313934004200C3C6012A=006434C415353524F4F4D0000534520434C415353524F4F4D=07A4D545752465355004D5457524653550020202020205355002054205220535500205420522053550020542052205355002054205220535500202020202053550020202020205355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544D4342003131373=0053230313835003230313934004200C3C601CB=00641554449544F5249554D00534520434C415353524F4F4D=07A4D545752465355004D545752465355004D54575246535500205420522053550020542020205355004D545720465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544D43420031323=0073230313835003230313934004200C3C60129=006434C415353524F4F4D0000534520434C415353524F4F4D=07A4D545752465355004D5457524653550020542052205355002054205220535500205420522053550020542052205355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544D434200313231=0063230313835003230313934004200C3C60123=006434C415353524F4F4D0000534520434C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544D434200313333=0063230313835003230313934004200C3C60118=006434C415353524F4F4D0000534520434C415353524F4F4D=07A4D545752465355004D54575246535500202020202053550020202020205355002054205220535500202020202053550020202020205355002020202020535500202020202053550020202020205355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544D434200313334=0063230313835003230313934004200C3C60122=006434C415353524F4F4D0000534520434C415353524F4F4D=07A4D542020465355004D54202046535500202020202053550020202020205355004D542020465355004D54202046535500205420202053550020542052205355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544D434200313335=0063230313835003230313934004200C3C6012A=006434C415353524F4F4D0000534520434C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D542052465355004D545752465355004D545752465355004D545752465355004D545752465355004D205720465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544D434200313336=0063230313835003230313934004200C3C60128=006434C415353524F4F4D0000534520434C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D54575246535500205420522053550020542052205355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544D434200313937=0063230313835003230313934004200C3C6011E=006434C415353524F4F4D0000534520434C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544D434200323939=0063230313835003230313934004200C3C60122=006434C415353524F4F4D0000534520434C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D5457524653550020542052465355004D205720465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544D434200333233=0063230313835003230313934004200C3C60118=006434C415353524F4F4D0000534520434C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544E52420031313=0073230313835003230313934004200C3C60146=0064341534520434C415353524F4F4D004C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544E52420031323=0073230313835003230313934004200C3C60146=0064341534520434C415353524F4F4D004C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D205720465355004D205720465355004D205720465355004D545752465355004D542052465355004D542052465355004D542052465355004D542052465355004D545752465355004D545752465355=012544E52420031333=0073230313835003230313934004200C3C60146=0064341534520434C415353524F4F4D004C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D54575246535500205420524653550020542052465355004D545752465355002054205246535500205420524653550020542052465355004D545752465355004D545752465355004D545752465355004D545752465355=012544E524200313531=0063230313835003230313934004200C3C6015801000041554449544F5249554D004F4F4D004C415353524F4F4D=07A4D545752205355004D545752205355004D545752205355004D54575220535500205457202053550020545720205355004D545752465355004D545752465355004D545752465355004D205752465355004D205752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544E524200313634=0063230313835003230313934004200C3C60125=006434C415353524F4F4D00004F4F4D004C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544E52420031373=0073230313835003230313934004200C3C6012B=006434C415353524F4F4D00004F4F4D004C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544E524200313734=0063230313835003230313934004200C3C60133=0064341534520434C415353524F4F4D004C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544E52420031383=0073230313835003230313934004200C3C60133=0064341534520434C415353524F4F4D004C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544E524200313834=0063230313835003230313934004200C3C60133=0064341534520434C415353524F4F4D004C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544E52420032313=0073230313835003230313934004200C3C60146=0064341534520434C415353524F4F4D004C415353524F4F4D=07A20202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355=012544E52420032323=0073230313835003230313934004200C3C60146=0064341534520434C415353524F4F4D004C415353524F4F4D=07A20202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355=012544E52420032333=0073230313835003230313934004200C3C60146=0064341534520434C415353524F4F4D004C415353524F4F4D=07A20202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355=012544E52420032343=0073230313835003230313934004200C3C60141=006434C415353524F4F4D00524F4F4D004C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D5457524653550020542052465355002054205246535500205420524653550020542052465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544E524200323531=0063230313835003230313934004200C3C601AA=00641554449544F5249554D004F4F4D004C415353524F4F4D=07A4D545752205355004D205720205355004D205720205355004D205720205355004D5457522053550020542052205355002054205246535500205420524653550020542052465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544E52420032363=0073230313835003230313934004200C3C60164=0064341534520434C415353524F4F4D004C415353524F4F4D=07A4D545752465355002020202046535500202020204653550020202020465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D205720465355004D205720465355004D205720465355004D205720465355004D545752465355004D545752465355=012544E524200323634=0063230313835003230313934004200C3C6011C=006434C415353524F4F4D00524F4F4D004C415353524F4F4D=07A20202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355=012544E52420032373=0073230313835003230313934004200C3C6012B=006434C415353524F4F4D00524F4F4D004C415353524F4F4D=07A20202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355=012544E52420032383=0073230313835003230313934004200C3C6015=007434C415353524F4F4D00524F4F4D004C415353524F4F4D=07A20202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355=012544E524200323834=0063230313835003230313934004200C3C6015=007434C415353524F4F4D00524F4F4D004C415353524F4F4D=07A20202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355=012544E524200333234=0063230313835003230313934004200C3C6012=007434C415353524F4F4D00524F4F4D004C415353524F4F4D=07A4D545752465355002054205246535500205420522053550020542052205355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D205720465355004D205720465355004D205720465355004D205720465355=012544E524200333734=0063230313835003230313934004200C3C60136=006434C415353524F4F4D00524F4F4D004C415353524F4F4D=07A4D545752465355004D202020205355004D202020205355004D202020205355004D202020205355004D545752205355004D545752205355004D2057522053550020202020205355002020202020535500202020202053550020542020465355004D542020465355004D545752465355004D545752465355004D545752465355=012544E524200343834=0063230313835003230313934004200C3C6013=007434C415353524F4F4D00524F4F4D004C415353524F4F4D=07A4D545752465355004D205720462055004D205720462055004D205720462055004D545752462055004D205720462055004D205720462055004D205720462055004D205720462055004D545752465355004D545720465355004D545720465355004D545720465355004D545720465355004D545752465355004D545752465355=012544E5242005731303800003230313835003230313934004200C3C6012E=0064341534520434C415353524F4F4D004C415353524F4F4D=07A4D545752465355002054205220535500205420522053550020542052205355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D205752465355004D205752465355004D205752465355004D205752465355004D545752465355004D545752465355=012544E5242005731313=0053230313835003230313934004200C3C6012E=0064341534520434C415353524F4F4D004C415353524F4F4D=07A4D545752465355002054205220535500202020202053550020202020205355002054202046535500205420524653550020542052465355004D545752205355004D545752205355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544E5242005731313800003230313835003230313934004200C3C6012E=0064341534520434C415353524F4F4D004C415353524F4F4D=07A4D545752465355004D545752465355002020202020535500202020202053550020202020205355002020202020535500202020202053550020202020205355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544E5242005731323200003230313835003230313934004200C3C6012E=0064341534520434C415353524F4F4D004C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544E5242005732303800003230313835003230313934004200C3C60146=0064341534520434C415353524F4F4D004C415353524F4F4D=07A4D545752465355004D205720465355004D205720465355004D205720465355002054205246535500205420524653550020542052465355004D542052465355004D542052465355004D205752465355004D205752465355004D205752465355004D205752465355004D545752465355004D545752465355004D545752465355=012544E5242005732313=0053230313835003230313934004200C3C60146=0064341534520434C415353524F4F4D004C415353524F4F4D=07A4D545752465355004D205720205355004D205720205355004D205720205355002054205246535500205420524653550020542052465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544E5242005732343=0053230313835003230313934004200C3C60146=0064341534520434C415353524F4F4D004C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544E5242005732343200003230313835003230313934004200C3C60146=0064341534520434C415353524F4F4D004C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D205720465355004D205720465355004D205720465355004D205720465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544E5242005733303800003230313835003230313934004200C3C60146=0064341534520434C415353524F4F4D004C415353524F4F4D=07A4D545752465355004D54575246535500202020204653550020202020465355004D54575246535500202020204653550020202020465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=012544E5242005733313=0053230313835003230313934004200C3C60146=0064341534520434C415353524F4F4D004C415353524F4F4D=07A4D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355004D545752465355=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=06273797374656D4572726F72=0B2506C656173652074727920796F757220616374696F6E20616761696E2E205468652070726F6772616D2077617320756E61626C6520746F20636F6D706C6574652074686520616374696F6E20796F75207265717565737465642E20496620796F7520636F6E74696E756520746F20657870657269656E63652070726F626C656D7320796F75206D61792074727920616761696E2061742061206C617465722074696D65206F7220636F6E74616374206F757220637573746F6D6572207365727669636520737461666620617420312D3830312D3432322D3430303020666F7220617373697374616E63652E=0FF=0FF=0FF=0FF=0FF=0FFF401=00C666F7262696464656E50616765=0AE50616765204E6F7420466F756E642E2057652061726520736F72727920627574207765207765726520756E61626C6520746F2061636365737320746865207365727669636520796F75207265717565737465642E20496620796F752062656C69657665207468697320746F20626520696E206572726F722C20706C6561736520636F6E74616374206F757220637573746F6D6572207365727669636520737461666620617420312D3830312D3432322D3430303020666F7220617373697374616E63652E=0FF=0FF=0FF=0FF=0FF=0FF=04E9301=00C7265736F757263654E6F74466F756E64=0A85265736F75726365206E6F7420666F756E642E=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0B19401=00C6765744D6574686F644E6F74537570706F72746564=09E474554206D6574686F64206E6F7420737570706F727465642E=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0A59501=00C7075744D6574686F644E6F74537570706F72746564=09E505554206D6574686F64206E6F7420737570706F727465642E=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0A59501=00C706F73744D6574686F644E6F74537570706F72746564=09C504F5354206D6574686F64206E6F7420737570706F727465642E=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0A39501=00C707574416E64506F73744D6574686F64734E6F74537570706F72746564=08E50555420616E6420504F5354206D6574686F6473206E6F7420737570706F727465642E=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0919501=00C64656C6574654D6574686F644E6F74537570706F72746564=09844454C455445206D6574686F64206E6F7420737570706F727465642E=0FF=0FF=0FF=0FF=0FF=0FF=0FF=09F9501=00C746F6F4D616E79506174684964656E74696669657273=09C546F6F206D616E792070617468206964656E746966696572732E=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0A39001=00C72657175697265537461727444617465=0A84120737461727420646174652069732072657175697265642E=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0A59001=00C6E6F526F6F6D57697468417474726962757465=0A24E6F20726F6F6D73207765726520666F756E642077697468207468652073706563696669656420617474726962757465732E=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0739001=00C726571756972655061676541747472696275746541626F76653=0954120706167652061747472696275746520697320726571756972656420616E64206D757374206861766520612076616C7565206F662031206F7220677265617465722E=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0519001=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0FF=0BC\"}'\n",
    "json_req = {'ARoom': 'A',\n",
    " 'BRoom': 'B',\n",
    " 'RRoom': 'R',\n",
    " 'QRoom': 'Q',\n",
    " 'year_term_type': 'CLASS_DATES',\n",
    " 'use_start_date': '2021-5',\n",
    " 'use_end_date': '',\n",
    " 'building_set': '',\n",
    " 'from_capacity': '',\n",
    " 'to_capacity': '999',\n",
    " 'stationTypeSelectValue': '',\n",
    " 'stationTypeSelectSM': 'Open+area+(not+normally+set+up+with+chairs)',\n",
    " 'floorLevelSelectValue': '',\n",
    " 'floorLevelSelectSM': 'Level',\n",
    " 'c': 'freeRoomChart',\n",
    " 'e': '@Search',\n",
    " 'start_building': '',\n",
    " 'start_room': '',\n",
    " 'search_direction': 'N',\n",
    " 'sort': 'B'}\n",
    "print(json_req)\n",
    "# json_req"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "bldgs_ = ['B66','B67','BNSN','BRMB','CANC','CB','CONF','CTB','DIST','EB','ELLB','ESC','HAWF','HBLL','HCEB','HFAC','HLRA','HOSP','HRCB','IPF','JFSB','JKB','JRCB','JSB','KMBL','LSB','LSGH','LVES','MARB','MB','MC','MCA','MCKB','MLBM','MOA','MSRB','NICB','RB','RBF','ROTC','SAB','SFH','SFLD','SLC','SNLB','TCB','TCF','TLRA','TLRB','TMCB','TNRB','UPC','WSC']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "provo_bldgs = ['B66', 'BNSN','BRMB','CB','CTB','EB','ESC','HBLL','HFAC','HRCB','JFSB','JKB','JRCB','JSB','KMBL','LSB','LSGH','MARB','MCKB','MLBM','MOA','MSRB','NICB','RB','SNLB','TLRB','TMCB','TNRB','WSC']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "slc_bldgs = ['SLC']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "url = 'https://y.byu.edu/class_schedule/cgi/freeRoomChart.cgi'\n",
    "\n",
    "for bldg in bldgs:\n",
    "    \n",
    "    updated_req = json_req\n",
    "    updated_req['building_set'] = bldg\n",
    "    \n",
    "    x = requests.post(url, data = json_req)\n",
    "\n",
    "    html = BeautifulSoup(x.text, 'html.parser')\n",
    "\n",
    "    is_paginated = x.text.count(\"Next Page\") > 0\n",
    "    \n",
    "    print(bldg, is_paginated)\n",
    "    \n",
    "    time.sleep(0.05) # prevent a bunch of requests from firing at once"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Fetching data for B66\n",
      "Fetching data for BNSN\n",
      "Fetching data for BRMB\n",
      "Fetching data for CB\n",
      "Fetching data for CTB\n",
      "Fetching data for EB\n",
      "Fetching data for ESC\n",
      "Fetching data for HBLL\n",
      "Fetching data for HFAC\n",
      "Fetching data for HRCB\n",
      "Fetching data for JFSB\n",
      "Fetching data for JKB\n",
      "Fetching data for JRCB\n",
      "Fetching data for JSB\n",
      "Fetching data for KMBL\n",
      "Fetching data for LSB\n",
      "Fetching data for LSGH\n",
      "Fetching data for MARB\n",
      "Fetching data for MCKB\n",
      "Fetching data for MLBM\n",
      "Fetching data for MOA\n",
      "Fetching data for MSRB\n",
      "Fetching data for NICB\n",
      "Fetching data for RB\n",
      "Fetching data for SNLB\n",
      "Fetching data for TLRB\n",
      "Fetching data for TMCB\n",
      "Fetching data for TNRB\n",
      "Fetching data for WSC\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "{'ARoom': 'A',\n",
       " 'BRoom': 'B',\n",
       " 'RRoom': 'R',\n",
       " 'QRoom': 'Q',\n",
       " 'year_term_type': 'CLASS_DATES',\n",
       " 'use_start_date': '2021-5',\n",
       " 'use_end_date': '',\n",
       " 'building_set': 'WSC',\n",
       " 'from_capacity': '',\n",
       " 'to_capacity': '999',\n",
       " 'stationTypeSelectValue': '',\n",
       " 'stationTypeSelectSM': 'Open+area+(not+normally+set+up+with+chairs)',\n",
       " 'floorLevelSelectValue': '',\n",
       " 'floorLevelSelectSM': 'Level',\n",
       " 'c': 'freeRoomChart',\n",
       " 'e': '@Search',\n",
       " 'start_building': '',\n",
       " 'start_room': '',\n",
       " 'search_direction': 'N',\n",
       " 'sort': 'B'}"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "url = 'https://y.byu.edu/class_schedule/cgi/freeRoomChart.cgi'\n",
    "data = []\n",
    "\n",
    "for bldg in provo_bldgs:\n",
    "    updated_req = json_req\n",
    "    updated_req['building_set'] = bldg\n",
    "    \n",
    "    print(f'Fetching data for {bldg}')\n",
    "    data.append(requests.post(url, data = updated_req))\n",
    "\n",
    "    time.sleep(0.05) # prevent a bunch of requests from firing at once\n",
    "\n",
    "# html = BeautifulSoup(data.text, 'html.parser')\n",
    "\n",
    "# is_paginated = data.text.count(\"Next Page\") > 0\n",
    "\n",
    "# print(is_paginated)\n",
    "updated_req"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>11</th>\n",
       "      <th>12</th>\n",
       "      <th>13</th>\n",
       "      <th>14</th>\n",
       "      <th>15</th>\n",
       "      <th>16</th>\n",
       "      <th>17</th>\n",
       "      <th>18</th>\n",
       "      <th>19</th>\n",
       "      <th>20</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bldg</td>\n",
       "      <td>Room</td>\n",
       "      <td>Cap</td>\n",
       "      <td>Type</td>\n",
       "      <td>7AM</td>\n",
       "      <td>8AM</td>\n",
       "      <td>9AM</td>\n",
       "      <td>10AM</td>\n",
       "      <td>11AM</td>\n",
       "      <td>...</td>\n",
       "      <td>1PM</td>\n",
       "      <td>2PM</td>\n",
       "      <td>3PM</td>\n",
       "      <td>4PM</td>\n",
       "      <td>5PM</td>\n",
       "      <td>6PM</td>\n",
       "      <td>7PM</td>\n",
       "      <td>8PM</td>\n",
       "      <td>9PM</td>\n",
       "      <td>10PM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>102</td>\n",
       "      <td>26</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>__W__</td>\n",
       "      <td>M_W__</td>\n",
       "      <td>MT_R_</td>\n",
       "      <td>...</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>103</td>\n",
       "      <td>69</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>__W_F</td>\n",
       "      <td>____F</td>\n",
       "      <td>_T__F</td>\n",
       "      <td>...</td>\n",
       "      <td>MTWR_</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>_T__F</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>1043</td>\n",
       "      <td>30</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>M_WRF</td>\n",
       "      <td>M_WRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>...</td>\n",
       "      <td>__W_F</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>_TW_F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>105</td>\n",
       "      <td>27</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>...</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>M_WRF</td>\n",
       "      <td>M_WRF</td>\n",
       "      <td>M_WRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>109</td>\n",
       "      <td>33</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>...</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>112</td>\n",
       "      <td>28</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_TW_F</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>MT_R_</td>\n",
       "      <td>...</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>1142</td>\n",
       "      <td>22</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>...</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWR_</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>1150</td>\n",
       "      <td>24</td>\n",
       "      <td>B</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>...</td>\n",
       "      <td>_T___</td>\n",
       "      <td>MTW__</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>1190C</td>\n",
       "      <td>10</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>...</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>130B</td>\n",
       "      <td>8</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>__WRF</td>\n",
       "      <td>__WRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>...</td>\n",
       "      <td>__WRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>133</td>\n",
       "      <td>16</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_TWR_</td>\n",
       "      <td>_TWR_</td>\n",
       "      <td>MTWR_</td>\n",
       "      <td>_TWR_</td>\n",
       "      <td>...</td>\n",
       "      <td>M__R_</td>\n",
       "      <td>M__R_</td>\n",
       "      <td>M__RF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>137</td>\n",
       "      <td>10</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>_TW_F</td>\n",
       "      <td>_TW_F</td>\n",
       "      <td>...</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>149</td>\n",
       "      <td>10</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>_TW_F</td>\n",
       "      <td>_TW_F</td>\n",
       "      <td>...</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>154</td>\n",
       "      <td>16</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_TWR_</td>\n",
       "      <td>__WR_</td>\n",
       "      <td>__WR_</td>\n",
       "      <td>_TWR_</td>\n",
       "      <td>...</td>\n",
       "      <td>__WR_</td>\n",
       "      <td>__W__</td>\n",
       "      <td>__W_F</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>155</td>\n",
       "      <td>16</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWR_</td>\n",
       "      <td>MTWR_</td>\n",
       "      <td>MTWR_</td>\n",
       "      <td>MTWR_</td>\n",
       "      <td>...</td>\n",
       "      <td>M_WR_</td>\n",
       "      <td>M_WR_</td>\n",
       "      <td>M_WRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>156</td>\n",
       "      <td>8</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_TWR_</td>\n",
       "      <td>__WR_</td>\n",
       "      <td>__WR_</td>\n",
       "      <td>_TWR_</td>\n",
       "      <td>...</td>\n",
       "      <td>__WR_</td>\n",
       "      <td>__W__</td>\n",
       "      <td>__W_F</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>157</td>\n",
       "      <td>16</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_TW_F</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>...</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>230</td>\n",
       "      <td>76</td>\n",
       "      <td>B</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_T___</td>\n",
       "      <td>...</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>__W_F</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>M__RF</td>\n",
       "      <td>M__RF</td>\n",
       "      <td>M_WRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>235</td>\n",
       "      <td>18</td>\n",
       "      <td>B</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_T_R_</td>\n",
       "      <td>...</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>M___F</td>\n",
       "      <td>M___F</td>\n",
       "      <td>MT_RF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>240</td>\n",
       "      <td>38</td>\n",
       "      <td>B</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>_____</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>...</td>\n",
       "      <td>_____</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>M_WRF</td>\n",
       "      <td>___RF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>245</td>\n",
       "      <td>23</td>\n",
       "      <td>B</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>_T__F</td>\n",
       "      <td>_T___</td>\n",
       "      <td>...</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MT_RF</td>\n",
       "      <td>MT_RF</td>\n",
       "      <td>MT_RF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>250</td>\n",
       "      <td>284</td>\n",
       "      <td>B</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_T_R_</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>_T___</td>\n",
       "      <td>...</td>\n",
       "      <td>_____</td>\n",
       "      <td>___R_</td>\n",
       "      <td>M_WR_</td>\n",
       "      <td>M__R_</td>\n",
       "      <td>M____</td>\n",
       "      <td>M____</td>\n",
       "      <td>M____</td>\n",
       "      <td>M____</td>\n",
       "      <td>M____</td>\n",
       "      <td>M____</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>262</td>\n",
       "      <td>40</td>\n",
       "      <td>B</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>____F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>...</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>____F</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>270</td>\n",
       "      <td>96</td>\n",
       "      <td>B</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>M__R_</td>\n",
       "      <td>____F</td>\n",
       "      <td>_T___</td>\n",
       "      <td>...</td>\n",
       "      <td>____F</td>\n",
       "      <td>___RF</td>\n",
       "      <td>___RF</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>280</td>\n",
       "      <td>38</td>\n",
       "      <td>B</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_T_R_</td>\n",
       "      <td>...</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>____F</td>\n",
       "      <td>_____</td>\n",
       "      <td>____F</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>285</td>\n",
       "      <td>20</td>\n",
       "      <td>B</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>...</td>\n",
       "      <td>M_W__</td>\n",
       "      <td>M_W__</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>460</td>\n",
       "      <td>15</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>_TW_F</td>\n",
       "      <td>...</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>462</td>\n",
       "      <td>16</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_TWR_</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>_TW_F</td>\n",
       "      <td>...</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>M_WRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>482</td>\n",
       "      <td>40</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>M____</td>\n",
       "      <td>M____</td>\n",
       "      <td>MTWR_</td>\n",
       "      <td>...</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>490</td>\n",
       "      <td>40</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MT_RF</td>\n",
       "      <td>MT_R_</td>\n",
       "      <td>MT___</td>\n",
       "      <td>MT___</td>\n",
       "      <td>...</td>\n",
       "      <td>MT_RF</td>\n",
       "      <td>M__RF</td>\n",
       "      <td>M__RF</td>\n",
       "      <td>M__RF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>620</td>\n",
       "      <td>16</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>...</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>640</td>\n",
       "      <td>40</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_T_R_</td>\n",
       "      <td>...</td>\n",
       "      <td>_____</td>\n",
       "      <td>M_W__</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>M_WRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>660</td>\n",
       "      <td>45</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_____</td>\n",
       "      <td>M_W__</td>\n",
       "      <td>MTWR_</td>\n",
       "      <td>...</td>\n",
       "      <td>_T_R_</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>MT_RF</td>\n",
       "      <td>MT__F</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>680</td>\n",
       "      <td>25</td>\n",
       "      <td>B</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>_____</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>...</td>\n",
       "      <td>_T_R_</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>793</td>\n",
       "      <td>30</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>...</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>M_WRF</td>\n",
       "      <td>M_WRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>893</td>\n",
       "      <td>16</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>_T_R_</td>\n",
       "      <td>...</td>\n",
       "      <td>_T_R_</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>948</td>\n",
       "      <td>38</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>...</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>View...</td>\n",
       "      <td>KMBL</td>\n",
       "      <td>990P</td>\n",
       "      <td>12</td>\n",
       "      <td>R</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>...</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>39 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         0     1      2    3     4      5      6      7      8      9   ...  \\\n",
       "0       NaN  Bldg   Room  Cap  Type    7AM    8AM    9AM   10AM   11AM  ...   \n",
       "1   View...  KMBL    102   26     R  MTWRF  _TWRF  __W__  M_W__  MT_R_  ...   \n",
       "2   View...  KMBL    103   69     R  MTWRF  _TWRF  __W_F  ____F  _T__F  ...   \n",
       "3   View...  KMBL   1043   30     R  MTWRF  MTWRF  M_WRF  M_WRF  MTWRF  ...   \n",
       "4   View...  KMBL    105   27     R  MTWRF  MTWRF  MTWRF  MTWRF  _T_RF  ...   \n",
       "5   View...  KMBL    109   33     R  MTWRF  MTWRF  _T_RF  _T_RF  MTWRF  ...   \n",
       "6   View...  KMBL    112   28     R  MTWRF  _TW_F  _____  _____  MT_R_  ...   \n",
       "7   View...  KMBL   1142   22     R  MTWRF  MTWRF  _T_RF  _T_RF  MTWRF  ...   \n",
       "8   View...  KMBL   1150   24     B  MTWRF  M_W_F  M_W_F  M_W_F  _T_RF  ...   \n",
       "9   View...  KMBL  1190C   10     R  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  ...   \n",
       "10  View...  KMBL   130B    8     R  MTWRF  _TWRF  __WRF  __WRF  _TWRF  ...   \n",
       "11  View...  KMBL    133   16     R  MTWRF  _TWR_  _TWR_  MTWR_  _TWR_  ...   \n",
       "12  View...  KMBL    137   10     R  MTWRF  _TWRF  _TWRF  _TW_F  _TW_F  ...   \n",
       "13  View...  KMBL    149   10     R  MTWRF  _TWRF  _TWRF  _TW_F  _TW_F  ...   \n",
       "14  View...  KMBL    154   16     R  MTWRF  _TWR_  __WR_  __WR_  _TWR_  ...   \n",
       "15  View...  KMBL    155   16     R  MTWRF  MTWR_  MTWR_  MTWR_  MTWR_  ...   \n",
       "16  View...  KMBL    156    8     R  MTWRF  _TWR_  __WR_  __WR_  _TWR_  ...   \n",
       "17  View...  KMBL    157   16     R  MTWRF  _TW_F  MTW_F  MTW_F  MTW_F  ...   \n",
       "18  View...  KMBL    230   76     B  MTWRF  MTWRF  _____  _____  _T___  ...   \n",
       "19  View...  KMBL    235   18     B  M_W_F  MTWRF  _____  _____  _T_R_  ...   \n",
       "20  View...  KMBL    240   38     B  MTWRF  MTWRF  M_W_F  _____  _T_RF  ...   \n",
       "21  View...  KMBL    245   23     B  MTWRF  MTWRF  _T_RF  _T__F  _T___  ...   \n",
       "22  View...  KMBL    250  284     B  MTWRF  _T_R_  ____F  ____F  _T___  ...   \n",
       "23  View...  KMBL    262   40     B  MTWRF  _____  _____  ____F  MTWRF  ...   \n",
       "24  View...  KMBL    270   96     B  MTWRF  MTWRF  M__R_  ____F  _T___  ...   \n",
       "25  View...  KMBL    280   38     B  MTWRF  M_W_F  _____  _____  _T_R_  ...   \n",
       "26  View...  KMBL    285   20     B  MTWRF  M_W_F  ____F  ____F  _T_RF  ...   \n",
       "27  View...  KMBL    460   15     R  MTWRF  _TWRF  _TWRF  MTW_F  _TW_F  ...   \n",
       "28  View...  KMBL    462   16     R  MTWRF  _TWR_  _TWRF  MTW_F  _TW_F  ...   \n",
       "29  View...  KMBL    482   40     R  MTWRF  M_W_F  M____  M____  MTWR_  ...   \n",
       "30  View...  KMBL    490   40     R  MTWRF  MT_RF  MT_R_  MT___  MT___  ...   \n",
       "31  View...  KMBL    620   16     R  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  ...   \n",
       "32  View...  KMBL    640   40     R  MTWRF  M_W_F  _____  _____  _T_R_  ...   \n",
       "33  View...  KMBL    660   45     R  MTWRF  MTWRF  _____  M_W__  MTWR_  ...   \n",
       "34  View...  KMBL    680   25     B  MTWRF  _T_RF  _T_RF  _____  MTWRF  ...   \n",
       "35  View...  KMBL    793   30     R  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  ...   \n",
       "36  View...  KMBL    893   16     R  MTWRF  MTWRF  M_W_F  M_W_F  _T_R_  ...   \n",
       "37  View...  KMBL    948   38     R  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  ...   \n",
       "38  View...  KMBL   990P   12     R  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  ...   \n",
       "\n",
       "       11     12     13     14     15     16     17     18     19     20  \n",
       "0     1PM    2PM    3PM    4PM    5PM    6PM    7PM    8PM    9PM   10PM  \n",
       "1   M_W_F  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "2   MTWR_  ____F  ____F  _T_RF  _T__F  MTW_F  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "3   __W_F  _TWRF  _TW_F  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "4   MTWRF  M_WRF  M_WRF  M_WRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "5   MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "6   M_W_F  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "7   MTWRF  MTWR_  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "8   _T___  MTW__  M_W_F  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "9   MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "10  __WRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "11  M__R_  M__R_  M__RF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "12  _TWRF  _TWRF  _TWRF  _TWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "13  _TWRF  _TWRF  _TWRF  _TWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "14  __WR_  __W__  __W_F  _TWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "15  M_WR_  M_WR_  M_WRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "16  __WR_  __W__  __W_F  _TWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "17  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "18  _____  _____  __W_F  _TWRF  _T_RF  M__RF  M__RF  M_WRF  MTWRF  MTWRF  \n",
       "19  _____  _____  M_W_F  M_W_F  M___F  M___F  MT_RF  MTWRF  MTWRF  MTWRF  \n",
       "20  _____  ____F  ____F  M_WRF  ___RF  _T_RF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "21  _____  _____  M_W_F  MTWRF  MT_RF  MT_RF  MT_RF  MTWRF  MTWRF  MTWRF  \n",
       "22  _____  ___R_  M_WR_  M__R_  M____  M____  M____  M____  M____  M____  \n",
       "23  _T_RF  ____F  _T_RF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "24  ____F  ___RF  ___RF  M_W_F  MTW_F  MTW_F  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "25  _T_RF  ____F  _____  ____F  _TWRF  _TWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "26  M_W__  M_W__  M_W_F  ____F  ____F  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "27  _TWRF  _TWRF  MTWRF  MTWRF  _TWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "28  _TWRF  _TWRF  M_WRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "29  M_W_F  M_W_F  MTWRF  MTWRF  _TWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "30  MT_RF  M__RF  M__RF  M__RF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "31  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "32  _____  M_W__  M_W_F  MTW_F  M_W_F  M_W_F  M_WRF  MTWRF  MTWRF  MTWRF  \n",
       "33  _T_R_  M_W_F  M_W_F  MT_RF  MT__F  MTW_F  MTW_F  MTWRF  MTWRF  MTWRF  \n",
       "34  _T_R_  M_W_F  M_W_F  MTW_F  MTW_F  MTW_F  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "35  MTWRF  ____F  ____F  _T_RF  M_WRF  M_WRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "36  _T_R_  MTWRF  M_W_F  M_W_F  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "37  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "38  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "\n",
       "[39 rows x 21 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_html(data[14].text, attrs={'class': 'tabletrim'})[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Bldg</th>\n",
       "      <th>Room</th>\n",
       "      <th>7AM</th>\n",
       "      <th>8AM</th>\n",
       "      <th>9AM</th>\n",
       "      <th>10AM</th>\n",
       "      <th>11AM</th>\n",
       "      <th>12PM</th>\n",
       "      <th>1PM</th>\n",
       "      <th>2PM</th>\n",
       "      <th>3PM</th>\n",
       "      <th>4PM</th>\n",
       "      <th>5PM</th>\n",
       "      <th>6PM</th>\n",
       "      <th>7PM</th>\n",
       "      <th>8PM</th>\n",
       "      <th>9PM</th>\n",
       "      <th>10PM</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>B66</td>\n",
       "      <td>104</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>B66</td>\n",
       "      <td>120</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>_T_R_</td>\n",
       "      <td>M___F</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>_T__F</td>\n",
       "      <td>_T__F</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>B66</td>\n",
       "      <td>130</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>____F</td>\n",
       "      <td>_T__F</td>\n",
       "      <td>_T__F</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>M___F</td>\n",
       "      <td>____F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>MT_RF</td>\n",
       "      <td>M___F</td>\n",
       "      <td>M___F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>B66</td>\n",
       "      <td>220</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>B66</td>\n",
       "      <td>240</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>M__RF</td>\n",
       "      <td>M__RF</td>\n",
       "      <td>M__RF</td>\n",
       "      <td>M__RF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>661</th>\n",
       "      <td>WSC</td>\n",
       "      <td>3380</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>662</th>\n",
       "      <td>WSC</td>\n",
       "      <td>CBR</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_T_R_</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_T_R_</td>\n",
       "      <td>_____</td>\n",
       "      <td>_T_R_</td>\n",
       "      <td>_T_R_</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>663</th>\n",
       "      <td>WSC</td>\n",
       "      <td>EBR</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_T_R_</td>\n",
       "      <td>_____</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>_TWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>664</th>\n",
       "      <td>WSC</td>\n",
       "      <td>LNA</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>665</th>\n",
       "      <td>WSC</td>\n",
       "      <td>VARTH</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>M_WRF</td>\n",
       "      <td>M_WRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>666 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "0   Bldg   Room    7AM    8AM    9AM   10AM   11AM   12PM    1PM    2PM  \\\n",
       "0    B66    104  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  M_W_F   \n",
       "1    B66    120  MTWRF  M_W_F  ____F  ____F  _T_R_  M___F  M_W_F  ____F   \n",
       "2    B66    130  MTWRF  ____F  _T__F  _T__F  MTW_F  M___F  ____F  MTWRF   \n",
       "3    B66    220  MTWRF  M_W_F  M_W_F  M_W_F  _T_RF  _T_RF  _T_RF  ____F   \n",
       "4    B66    240  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  _T_RF   \n",
       "..   ...    ...    ...    ...    ...    ...    ...    ...    ...    ...   \n",
       "661  WSC   3380  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF   \n",
       "662  WSC    CBR  MTWRF  _T_R_  _____  _____  _T_R_  _____  _T_R_  _T_R_   \n",
       "663  WSC    EBR  MTWRF  M_W_F  _____  _____  _T_R_  _____  M_W_F  M_W_F   \n",
       "664  WSC    LNA  MTWRF  MTWRF  MTWRF  MTWRF  _T_RF  _T_RF  _T_RF  _T_RF   \n",
       "665  WSC  VARTH  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  M_WRF  M_WRF   \n",
       "\n",
       "0      3PM    4PM    5PM    6PM    7PM    8PM    9PM   10PM  \n",
       "0    M_W_F  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "1    ____F  _T__F  _T__F  MTW_F  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "2    _T_RF  MT_RF  M___F  M___F  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "3    ____F  ____F  MTW_F  MTW_F  MTW_F  MTW_F  MTWRF  MTWRF  \n",
       "4    _T_RF  _T_RF  M__RF  M__RF  M__RF  M__RF  MTWRF  MTWRF  \n",
       "..     ...    ...    ...    ...    ...    ...    ...    ...  \n",
       "661  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "662  MTWRF  MTWRF  _TWRF  _TWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "663  MTWRF  MTWRF  _TWRF  _TWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "664  _T_RF  M_W_F  M_W_F  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "665  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  \n",
       "\n",
       "[666 rows x 18 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "base_table = None\n",
    "\n",
    "for result_set, bldg in zip(data, provo_bldgs):\n",
    "    global columns\n",
    "    result_table = None\n",
    "    try:\n",
    "        result_table = pd.read_html(result_set.text, attrs={'class': 'tabletrim'})[0]\n",
    "    except:\n",
    "        print(bldg, \"didn't work\")\n",
    "        continue\n",
    "    \n",
    "    result_table = result_table.drop(result_table.columns[[0, 3, 4]], axis=1)\n",
    "    if not isinstance(base_table, pd.DataFrame):\n",
    "        columns = result_table.iloc[0].copy()\n",
    "    result_table.columns = range(result_table.shape[1])\n",
    "    result_table = result_table.drop(result_table.index[0])\n",
    "    \n",
    "    if not isinstance(base_table, pd.DataFrame):\n",
    "        base_table = result_table\n",
    "#         base_table.columns = columns\n",
    "#         print(base_table)\n",
    "    else:\n",
    "        base_table = pd.concat([base_table, result_table])\n",
    "        \n",
    "base_table = base_table.reset_index(drop=True)\n",
    "base_table.columns = columns\n",
    "base_table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/vin/Library/Python/3.8/lib/python/site-packages/IPython/core/interactiveshell.py:3441: DtypeWarning: Columns (19) have mixed types.Specify dtype option on import or set low_memory=False.\n",
      "  exec(code_obj, self.user_global_ns, self.user_ns)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Bldg</th>\n",
       "      <th>Room</th>\n",
       "      <th>Piano</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>B66</td>\n",
       "      <td>120</td>\n",
       "      <td>pia-no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>B66</td>\n",
       "      <td>130</td>\n",
       "      <td>pia-no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BNSN</td>\n",
       "      <td>W002</td>\n",
       "      <td>pia-no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BNSN</td>\n",
       "      <td>W003</td>\n",
       "      <td>pia-no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BNSN</td>\n",
       "      <td>W005</td>\n",
       "      <td>piano</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>TNRB</td>\n",
       "      <td>280</td>\n",
       "      <td>piano</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>TNRB</td>\n",
       "      <td>284</td>\n",
       "      <td>piano</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>TNRB</td>\n",
       "      <td>324</td>\n",
       "      <td>pia-no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>TNRB</td>\n",
       "      <td>374</td>\n",
       "      <td>pia-no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>TNRB</td>\n",
       "      <td>484</td>\n",
       "      <td>pia-no</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>244 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Bldg  Room   Piano\n",
       "0     B66   120  pia-no\n",
       "1     B66   130  pia-no\n",
       "2    BNSN  W002  pia-no\n",
       "3    BNSN  W003  pia-no\n",
       "4    BNSN  W005   piano\n",
       "..    ...   ...     ...\n",
       "239  TNRB   280   piano\n",
       "240  TNRB   284   piano\n",
       "241  TNRB   324  pia-no\n",
       "242  TNRB   374  pia-no\n",
       "243  TNRB   484  pia-no\n",
       "\n",
       "[244 rows x 3 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "space_data = pd.read_csv(\"space-rf.csv\") \n",
    "blacklist_rooms = [(\"B66\", \"120\")]\n",
    "classroom_filter = space_data[\"Description\"]==\"CLASSROOM\"\n",
    "bldg_filter = space_data[\"Bldg Abv\"].isin(provo_bldgs)\n",
    "classrooms = space_data[classroom_filter & bldg_filter]\n",
    "classrooms = classrooms.reset_index(drop=True)\n",
    "classrooms = classrooms[['Bldg Abv', 'Room', 'Piano']]\n",
    "# Must have the same column names in order to merge\n",
    "classrooms['Piano'] = classrooms['Piano'].apply(lambda value: \"piano\" if value == \"Yes\" else \"pia-no\")\n",
    "classrooms.rename(columns={'Bldg Abv':'Bldg'}, inplace=True)\n",
    "classrooms"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>Bldg</th>\n",
       "      <th>Room</th>\n",
       "      <th>7AM</th>\n",
       "      <th>8AM</th>\n",
       "      <th>9AM</th>\n",
       "      <th>10AM</th>\n",
       "      <th>11AM</th>\n",
       "      <th>12PM</th>\n",
       "      <th>1PM</th>\n",
       "      <th>2PM</th>\n",
       "      <th>3PM</th>\n",
       "      <th>4PM</th>\n",
       "      <th>5PM</th>\n",
       "      <th>6PM</th>\n",
       "      <th>7PM</th>\n",
       "      <th>8PM</th>\n",
       "      <th>9PM</th>\n",
       "      <th>10PM</th>\n",
       "      <th>Piano</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>B66</td>\n",
       "      <td>120</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>_T_R_</td>\n",
       "      <td>M___F</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>_T__F</td>\n",
       "      <td>_T__F</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>pia-no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>B66</td>\n",
       "      <td>130</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>____F</td>\n",
       "      <td>_T__F</td>\n",
       "      <td>_T__F</td>\n",
       "      <td>MTW_F</td>\n",
       "      <td>M___F</td>\n",
       "      <td>____F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>MT_RF</td>\n",
       "      <td>M___F</td>\n",
       "      <td>M___F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>pia-no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BNSN</td>\n",
       "      <td>W002</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>_T___</td>\n",
       "      <td>____F</td>\n",
       "      <td>_____</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>pia-no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BNSN</td>\n",
       "      <td>W003</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_T_R_</td>\n",
       "      <td>__W_F</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_T_R_</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>pia-no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BNSN</td>\n",
       "      <td>W005</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_____</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>_T__F</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>_____</td>\n",
       "      <td>__W_F</td>\n",
       "      <td>__W_F</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>piano</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>TNRB</td>\n",
       "      <td>280</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>MTWR_</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>MTWR_</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>piano</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>TNRB</td>\n",
       "      <td>284</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWR_</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_T_R_</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>MT_RF</td>\n",
       "      <td>MT_RF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>piano</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>TNRB</td>\n",
       "      <td>324</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>M_WRF</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>_TW_F</td>\n",
       "      <td>____F</td>\n",
       "      <td>__W_F</td>\n",
       "      <td>M_WRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>pia-no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>TNRB</td>\n",
       "      <td>374</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>___RF</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>____F</td>\n",
       "      <td>M___F</td>\n",
       "      <td>MT__F</td>\n",
       "      <td>M___F</td>\n",
       "      <td>M_W_F</td>\n",
       "      <td>M_WRF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>pia-no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>TNRB</td>\n",
       "      <td>484</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>_____</td>\n",
       "      <td>____F</td>\n",
       "      <td>_T_RF</td>\n",
       "      <td>_T__F</td>\n",
       "      <td>MT__F</td>\n",
       "      <td>MT_RF</td>\n",
       "      <td>MT_RF</td>\n",
       "      <td>MTWRF</td>\n",
       "      <td>pia-no</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>242 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Bldg  Room    7AM    8AM    9AM   10AM   11AM   12PM    1PM    2PM  \\\n",
       "0     B66   120  MTWRF  M_W_F  ____F  ____F  _T_R_  M___F  M_W_F  ____F   \n",
       "1     B66   130  MTWRF  ____F  _T__F  _T__F  MTW_F  M___F  ____F  MTWRF   \n",
       "2    BNSN  W002  M_W_F  MTWRF  ____F  ____F  _T___  ____F  _____  ____F   \n",
       "3    BNSN  W003  MTWRF  _____  _____  _____  _T_R_  __W_F  M_W_F  _____   \n",
       "4    BNSN  W005  MTWRF  _____  ____F  ____F  _T__F  ____F  ____F  _____   \n",
       "..    ...   ...    ...    ...    ...    ...    ...    ...    ...    ...   \n",
       "237  TNRB   280  MTWRF  _____  _____  _____  MTWR_  _____  _____  _____   \n",
       "238  TNRB   284  MTWRF  MTWR_  _____  _____  _T_R_  _____  _____  _____   \n",
       "239  TNRB   324  MTWRF  M_WRF  ____F  ____F  _T_RF  ____F  ____F  ____F   \n",
       "240  TNRB   374  MTWRF  _____  _____  _____  _T_RF  ___RF  ____F  ____F   \n",
       "241  TNRB   484  MTWRF  _____  _____  _____  _T_RF  _____  _____  _____   \n",
       "\n",
       "       3PM    4PM    5PM    6PM    7PM    8PM    9PM   10PM   Piano  \n",
       "0    ____F  _T__F  _T__F  MTW_F  MTWRF  MTWRF  MTWRF  MTWRF  pia-no  \n",
       "1    _T_RF  MT_RF  M___F  M___F  MTWRF  MTWRF  MTWRF  MTWRF  pia-no  \n",
       "2    ____F  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  pia-no  \n",
       "3    _____  _T_R_  _T_RF  _T_RF  MTWRF  MTWRF  MTWRF  MTWRF  pia-no  \n",
       "4    __W_F  __W_F  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF   piano  \n",
       "..     ...    ...    ...    ...    ...    ...    ...    ...     ...  \n",
       "237  _____  MTWR_  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF  MTWRF   piano  \n",
       "238  _____  _____  M_W_F  MT_RF  MT_RF  MTWRF  MTWRF  MTWRF   piano  \n",
       "239  ____F  _TW_F  ____F  __W_F  M_WRF  MTWRF  MTWRF  MTWRF  pia-no  \n",
       "240  ____F  ____F  M___F  MT__F  M___F  M_W_F  M_WRF  MTWRF  pia-no  \n",
       "241  _____  ____F  _T_RF  _T__F  MT__F  MT_RF  MT_RF  MTWRF  pia-no  \n",
       "\n",
       "[242 rows x 19 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_table = pd.merge(base_table, classrooms, how='inner', on=['Bldg', 'Room'])\n",
    "merged_table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "def process_hours(a):\n",
    "    days = []\n",
    "#     print(a)\n",
    "    for letter in a:\n",
    "        days.append(False if letter == \"_\" else True)\n",
    "#     print(days)\n",
    "    return days\n",
    "\n",
    "def group_hours_by_day(a):\n",
    "#     day_hours = []\n",
    "#     room_name = f\"{a[0]} {a[1]}\"\n",
    "    for i in range(2, 17+1):\n",
    "        a[i] = process_hours(a[i])\n",
    "#     print(a)\n",
    "    return a\n",
    "\n",
    "# Return only the value for the hour of the specified day -- confusing but idc\n",
    "def filter_hours_to_day(day_num):\n",
    "    def input_day_applier(a):\n",
    "        for i in range(2, 17+1):\n",
    "            a[i] = process_hours(a[i])[day_num]\n",
    "        return a\n",
    "    return input_day_applier"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[True, True, True, False, True]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "process_hours(\"MTW_F\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>Bldg</th>\n",
       "      <th>Room</th>\n",
       "      <th>7AM</th>\n",
       "      <th>8AM</th>\n",
       "      <th>9AM</th>\n",
       "      <th>10AM</th>\n",
       "      <th>11AM</th>\n",
       "      <th>12PM</th>\n",
       "      <th>1PM</th>\n",
       "      <th>2PM</th>\n",
       "      <th>3PM</th>\n",
       "      <th>4PM</th>\n",
       "      <th>5PM</th>\n",
       "      <th>6PM</th>\n",
       "      <th>7PM</th>\n",
       "      <th>8PM</th>\n",
       "      <th>9PM</th>\n",
       "      <th>10PM</th>\n",
       "      <th>Piano</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>B66</td>\n",
       "      <td>120</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>pia-no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>B66</td>\n",
       "      <td>130</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>pia-no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BNSN</td>\n",
       "      <td>W002</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>pia-no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BNSN</td>\n",
       "      <td>W003</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>pia-no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BNSN</td>\n",
       "      <td>W005</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>piano</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>TNRB</td>\n",
       "      <td>280</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>piano</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>TNRB</td>\n",
       "      <td>284</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>piano</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>TNRB</td>\n",
       "      <td>324</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>pia-no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>TNRB</td>\n",
       "      <td>374</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>pia-no</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>TNRB</td>\n",
       "      <td>484</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>pia-no</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>242 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Bldg  Room   7AM    8AM    9AM   10AM   11AM   12PM    1PM    2PM    3PM  \\\n",
       "0     B66   120  True   True  False  False  False   True   True  False  False   \n",
       "1     B66   130  True  False  False  False   True   True  False   True  False   \n",
       "2    BNSN  W002  True   True  False  False  False  False  False  False  False   \n",
       "3    BNSN  W003  True  False  False  False  False  False   True  False  False   \n",
       "4    BNSN  W005  True  False  False  False  False  False  False  False  False   \n",
       "..    ...   ...   ...    ...    ...    ...    ...    ...    ...    ...    ...   \n",
       "237  TNRB   280  True  False  False  False   True  False  False  False  False   \n",
       "238  TNRB   284  True   True  False  False  False  False  False  False  False   \n",
       "239  TNRB   324  True   True  False  False  False  False  False  False  False   \n",
       "240  TNRB   374  True  False  False  False  False  False  False  False  False   \n",
       "241  TNRB   484  True  False  False  False  False  False  False  False  False   \n",
       "\n",
       "       4PM    5PM    6PM   7PM   8PM   9PM  10PM   Piano  \n",
       "0    False  False   True  True  True  True  True  pia-no  \n",
       "1     True   True   True  True  True  True  True  pia-no  \n",
       "2     True   True   True  True  True  True  True  pia-no  \n",
       "3    False  False  False  True  True  True  True  pia-no  \n",
       "4    False   True   True  True  True  True  True   piano  \n",
       "..     ...    ...    ...   ...   ...   ...   ...     ...  \n",
       "237   True   True   True  True  True  True  True   piano  \n",
       "238  False   True   True  True  True  True  True   piano  \n",
       "239  False  False  False  True  True  True  True  pia-no  \n",
       "240  False   True   True  True  True  True  True  pia-no  \n",
       "241  False  False  False  True  True  True  True  pia-no  \n",
       "\n",
       "[242 rows x 19 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ex_table = merged_table.copy()\n",
    "ex_table.apply(filter_hours_to_day(0), axis=1)\n",
    "\n",
    "# def color_true_red(val):\n",
    "#     \"\"\"\n",
    "#     Takes a scalar and returns a string with\n",
    "#     the css property `'color: red'` for negative\n",
    "#     strings, black otherwise.\n",
    "#     \"\"\"\n",
    "#     color = 'green' if val == True else 'red' if val == False else 'black'\n",
    "#     return 'color: %s' % color\n",
    "\n",
    "# pd.options.display.max_rows = 50\n",
    "# # day_table = day_table.style.applymap(color_true_red)\n",
    "\n",
    "ex_table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "pd.options.display.max_rows = 999"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "'bool' object is not iterable",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mTypeError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[0;32m/var/folders/gh/vclhd1mj68s1bc_b7rmspns00000gn/T/ipykernel_27480/802771373.py\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mex_table\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mapply\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilter_hours_to_day\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m~/Library/Python/3.8/lib/python/site-packages/pandas/core/frame.py\u001b[0m in \u001b[0;36mapply\u001b[0;34m(self, func, axis, raw, result_type, args, **kwargs)\u001b[0m\n\u001b[1;32m   8739\u001b[0m             \u001b[0mkwargs\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   8740\u001b[0m         )\n\u001b[0;32m-> 8741\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0mop\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mapply\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   8742\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   8743\u001b[0m     def applymap(\n",
      "\u001b[0;32m~/Library/Python/3.8/lib/python/site-packages/pandas/core/apply.py\u001b[0m in \u001b[0;36mapply\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    686\u001b[0m             \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mapply_raw\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    687\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 688\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mapply_standard\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    689\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    690\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0magg\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/Library/Python/3.8/lib/python/site-packages/pandas/core/apply.py\u001b[0m in \u001b[0;36mapply_standard\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    810\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    811\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mapply_standard\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 812\u001b[0;31m         \u001b[0mresults\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mres_index\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mapply_series_generator\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    813\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    814\u001b[0m         \u001b[0;31m# wrap results\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/Library/Python/3.8/lib/python/site-packages/pandas/core/apply.py\u001b[0m in \u001b[0;36mapply_series_generator\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    826\u001b[0m             \u001b[0;32mfor\u001b[0m \u001b[0mi\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mv\u001b[0m \u001b[0;32min\u001b[0m \u001b[0menumerate\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mseries_gen\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    827\u001b[0m                 \u001b[0;31m# ignore SettingWithCopy here in case the user mutates\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 828\u001b[0;31m                 \u001b[0mresults\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mi\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mf\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mv\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    829\u001b[0m                 \u001b[0;32mif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mresults\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mi\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mABCSeries\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    830\u001b[0m                     \u001b[0;31m# If we have a view on v, we need to make a copy because\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/var/folders/gh/vclhd1mj68s1bc_b7rmspns00000gn/T/ipykernel_27480/667435899.py\u001b[0m in \u001b[0;36minput_day_applier\u001b[0;34m(a)\u001b[0m\n\u001b[1;32m     19\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0minput_day_applier\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0ma\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     20\u001b[0m         \u001b[0;32mfor\u001b[0m \u001b[0mi\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mrange\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;36m2\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;36m17\u001b[0m\u001b[0;34m+\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 21\u001b[0;31m             \u001b[0ma\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mi\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mprocess_hours\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0ma\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mi\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mday_num\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     22\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0ma\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     23\u001b[0m     \u001b[0;32mreturn\u001b[0m \u001b[0minput_day_applier\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/var/folders/gh/vclhd1mj68s1bc_b7rmspns00000gn/T/ipykernel_27480/667435899.py\u001b[0m in \u001b[0;36mprocess_hours\u001b[0;34m(a)\u001b[0m\n\u001b[1;32m      2\u001b[0m     \u001b[0mdays\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m[\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      3\u001b[0m \u001b[0;31m#     print(a)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 4\u001b[0;31m     \u001b[0;32mfor\u001b[0m \u001b[0mletter\u001b[0m \u001b[0;32min\u001b[0m \u001b[0ma\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      5\u001b[0m         \u001b[0mdays\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;32mFalse\u001b[0m \u001b[0;32mif\u001b[0m \u001b[0mletter\u001b[0m \u001b[0;34m==\u001b[0m \u001b[0;34m\"_\"\u001b[0m \u001b[0;32melse\u001b[0m \u001b[0;32mTrue\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      6\u001b[0m \u001b[0;31m#     print(days)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mTypeError\u001b[0m: 'bool' object is not iterable"
     ]
    }
   ],
   "source": [
    "ex_table.apply(filter_hours_to_day(1), axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(5):\n",
    "    day_table = merged_table.copy()\n",
    "    day_table = day_table.apply(filter_hours_to_day(i), axis=1)\n",
    "    day_table.to_csv(f'./server/classroom_info/{i}_classrooms.csv', index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Each classroom needs to contain a list of days each containing a list of booleans represented the hours, 7-22.\n",
    "\n",
    "Thus a classroom might look like\n",
    "```python\n",
    "classroomA = [\n",
    "    [True, True, ..., True],\n",
    "    [True, True, ..., True],\n",
    "    .\n",
    "    .\n",
    "    .\n",
    "    [True, True, ..., True],\n",
    "]\n",
    "```\n",
    "\n",
    "And for now we could make a function `is_available_at(classroom_data, day_num, hour_num)` that returns a string with the format `"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "ARoom=A&BRoom=B&year_term_type=CLASS_DATES&use_start_date=2019-5&use_end_date=&building_set=HFAC&from_capacity=&to_capacity=999&stationTypeSelectValue=&stationTypeSelectSM=Open+area+%28not+normally+set+up+with+chairs%29&floorLevelSelectValue=&floorLevelSelectSM=Level&c=freeRoomChart&e=%40Search&start_building=&start_room=&search_direction=N&rooms=&sort=B&&pianoSM=Piano"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}