Asana.ipynb

{
  "cells": [
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "id": "dvf7WH1lr622"
      },
      "outputs": [],
      "source": [
        "#import all libraries\n",
        "import requests\n",
        "from requests.auth import HTTPBasicAuth\n",
        "import json\n",
        "import pandas as pd\n",
        "import csv\n",
        "import os\n",
        "from dotenv import load_dotenv\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 2,
      "metadata": {
        "id": "SAvrbsWF0Nxz"
      },
      "outputs": [],
      "source": [
        "starrez_url = \"https://cornell.starrezhousing.com/StarRezRest/services/\""
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 3,
      "metadata": {
        "id": "T0EWqQgfsf43"
      },
      "outputs": [],
      "source": [
        "load_dotenv(\".env\")\n",
        "basic = HTTPBasicAuth(os.environ.get('STARREZ_USERNAME'), os.environ.get('STARREZ_TOKEN'))\n",
        "headers =  {\"accept\": \"application/json\",\"content-type\": \"application/json\", \"authorization\": \"Basic\"}\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 14,
      "metadata": {
        "id": "-gySNKw19LIu"
      },
      "outputs": [],
      "source": [
        "#report id for chapi room base\n",
        "roomreportID = 70725\n",
        "#report id for chapi events\n",
        "eventreportID = 84711"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 15,
      "metadata": {
        "id": "1KLPk0N_9FEg"
      },
      "outputs": [],
      "source": [
        "room_command = f\"getreport/{roomreportID}.csv\"\n",
        "event_command  = f\"getreport/{eventreportID}.csv\""
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 17,
      "metadata": {
        "id": "eG870afOS1Lw"
      },
      "outputs": [],
      "source": [
        "room_response = requests.get(starrez_url + room_command,headers=headers,auth = basic)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 20,
      "metadata": {},
      "outputs": [],
      "source": [
        "event_response = requests.get(starrez_url+event_command,headers=headers,auth = basic)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 22,
      "metadata": {},
      "outputs": [],
      "source": [
        "with open(\"conferences.csv\",'w',encoding= 'utf-8') as events:\n",
        "  events.write(event_response.text)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 23,
      "metadata": {
        "id": "46_h34XXoqlb"
      },
      "outputs": [],
      "source": [
        "with open(\"rooms.csv\",'w',encoding ='utf-8') as rooms:\n",
        "    rooms.write(room_response.text)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 24,
      "metadata": {},
      "outputs": [],
      "source": [
        "conferences = pd.read_csv('conferences.csv')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 25,
      "metadata": {
        "id": "rU-EQxspLk8I"
      },
      "outputs": [],
      "source": [
        "beds = pd.read_csv('rooms.csv')\n",
        "count_per_room = beds['Building'].value_counts()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 12,
      "metadata": {},
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "Building\n",
            "Clara Dickson Hall          637\n",
            "Ganedago: Hall              583\n",
            "Ruth Bader Ginsburg Hall    506\n",
            "Mary Donlon Hall            480\n",
            "Hu Shih Hall                431\n",
            "Becker House                381\n",
            "Cascadilla Hall             376\n",
            "Bethe House - Main          324\n",
            "Townhouse                   322\n",
            "Keeton House                316\n",
            "Barbara McClintock Hall     315\n",
            "Toni Morrison Hall          314\n",
            "Balch Hall                  271\n",
            "High Rise 5                 260\n",
            "Jameson Hall                256\n",
            "Mews Hall                   252\n",
            "Risley                      197\n",
            "Holland International LC    186\n",
            "Rose House - Main           183\n",
            "Low Rise 6                  173\n",
            "Sheldon Court               172\n",
            "Just About Music            167\n",
            "Low Rise 7                  166\n",
            "Ujamaa                      145\n",
            "Schuyler House              134\n",
            "Cook House - Main           126\n",
            "Cook House - Baker Tower    121\n",
            "Ecology House               100\n",
            "Court Hall                   97\n",
            "Bauer Hall                   93\n",
            "Kay Hall                     93\n",
            "McLLU                        86\n",
            "Cook House - Baker North     85\n",
            "Rose House - Founders        83\n",
            "Rose House - Baker South     73\n",
            "Cook House - Boldt Hall      66\n",
            "Rose House - Lyon Hall       63\n",
            "Bethe House - McFaddin       60\n",
            "Latino Living Center         59\n",
            "109 McGraw Place             41\n",
            "Rose House - Mennen Hall     39\n",
            "Akwe:kon                     38\n",
            "Equity & Engagement LLC      37\n",
            "Veterans House               37\n",
            "Loving House                 31\n",
            "112 Edgemoor                 21\n",
            "Cook House - Boldt Tower     16\n",
            "118 McGraw Place              1\n",
            "319 Wait Ave                  1\n",
            "Name: count, dtype: int64\n"
          ]
        }
      ],
      "source": [
        "print(count_per_room)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 26,
      "metadata": {},
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>University Program / Conference</th>\n",
              "      <th>Start Date</th>\n",
              "      <th>End Date</th>\n",
              "      <th>Event Code</th>\n",
              "      <th>Attendee Estimate</th>\n",
              "      <th>Housing Estimate</th>\n",
              "      <th>Event Type Description</th>\n",
              "      <th>Require Housing</th>\n",
              "      <th>Housing Location</th>\n",
              "      <th>Dining</th>\n",
              "      <th>Returning Program?</th>\n",
              "      <th>Service Center</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Statler Intern Housing 22</td>\n",
              "      <td>5/25/2022</td>\n",
              "      <td>6/1/2022</td>\n",
              "      <td>H19 3800 20175 2022</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>Summer Program</td>\n",
              "      <td>True</td>\n",
              "      <td>Cascadilla</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>West Campus</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Engineering Cooperative Education Program 22, ...</td>\n",
              "      <td>5/25/2022</td>\n",
              "      <td>8/18/2022</td>\n",
              "      <td>H193800 10771 2019</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "      <td>Conference</td>\n",
              "      <td>False</td>\n",
              "      <td>Cascadilla</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Afghan Student Summer Housing 22</td>\n",
              "      <td>5/25/2022</td>\n",
              "      <td>8/13/2022</td>\n",
              "      <td>H193800 10800 2022</td>\n",
              "      <td>9</td>\n",
              "      <td>9</td>\n",
              "      <td>Summer Program</td>\n",
              "      <td>True</td>\n",
              "      <td>Becker House</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>West Campus</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>SRCCS 22 - Summer Research for Community Colle...</td>\n",
              "      <td>5/29/2022</td>\n",
              "      <td>7/24/2022</td>\n",
              "      <td>H193800 18830 2019</td>\n",
              "      <td>11</td>\n",
              "      <td>11</td>\n",
              "      <td>Conference</td>\n",
              "      <td>False</td>\n",
              "      <td>Cascadilla then Keeton</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>REU STC CROPPS 22</td>\n",
              "      <td>5/30/2022</td>\n",
              "      <td>8/5/2022</td>\n",
              "      <td>H193800 20154 2022</td>\n",
              "      <td>0</td>\n",
              "      <td>5</td>\n",
              "      <td>Summer Program</td>\n",
              "      <td>True</td>\n",
              "      <td>Becker House</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>REU BTI 22 (Boyce Thompson Institute Research ...</td>\n",
              "      <td>5/30/2022</td>\n",
              "      <td>8/5/2022</td>\n",
              "      <td>H193800 16090 2022</td>\n",
              "      <td>38</td>\n",
              "      <td>38</td>\n",
              "      <td>Summer Program</td>\n",
              "      <td>True</td>\n",
              "      <td>Rose House</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Summer Session 22</td>\n",
              "      <td>5/30/2022</td>\n",
              "      <td>8/10/2022</td>\n",
              "      <td>H193800 10773 2019</td>\n",
              "      <td>100</td>\n",
              "      <td>100</td>\n",
              "      <td>Summer Program</td>\n",
              "      <td>False</td>\n",
              "      <td>Rose House, Keeton House, cascadilla</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Engineering Cooperative Education Program 22, ...</td>\n",
              "      <td>5/30/2022</td>\n",
              "      <td>8/12/2022</td>\n",
              "      <td>H193800 10772 2020</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>Conference</td>\n",
              "      <td>False</td>\n",
              "      <td>Cascadilla</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>CVM PhD Visiting Student 22</td>\n",
              "      <td>5/31/2022</td>\n",
              "      <td>7/29/2022</td>\n",
              "      <td>H193800 ?????</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>Conference</td>\n",
              "      <td>True</td>\n",
              "      <td>Becker House</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>West Campus</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Dean's Leader's Program 22</td>\n",
              "      <td>5/31/2022</td>\n",
              "      <td>8/6/2022</td>\n",
              "      <td>H193800  20156 2022</td>\n",
              "      <td>0</td>\n",
              "      <td>30</td>\n",
              "      <td>Conference</td>\n",
              "      <td>False</td>\n",
              "      <td>Comstock</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>CSTEP 22, Session 1 (Collegiate Science and Te...</td>\n",
              "      <td>5/31/2022</td>\n",
              "      <td>8/6/2022</td>\n",
              "      <td>H193800 20131 2021</td>\n",
              "      <td>12</td>\n",
              "      <td>8</td>\n",
              "      <td>Summer Program</td>\n",
              "      <td>False</td>\n",
              "      <td>Becker House</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>NSF-PREM Faculty Housing 22</td>\n",
              "      <td>6/1/2022</td>\n",
              "      <td>7/1/2022</td>\n",
              "      <td>H193800 20170  2022</td>\n",
              "      <td>4</td>\n",
              "      <td>10</td>\n",
              "      <td>Conference</td>\n",
              "      <td>True</td>\n",
              "      <td>Townhouses</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Community-Based Collaborative Global Learning ...</td>\n",
              "      <td>6/1/2022</td>\n",
              "      <td>6/4/2022</td>\n",
              "      <td>H193800  20161  2022</td>\n",
              "      <td>30</td>\n",
              "      <td>40</td>\n",
              "      <td>Conference</td>\n",
              "      <td>True</td>\n",
              "      <td>Townhouses</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>North Campus</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>CrawFly Invertebrate Neurophysiology Course 22</td>\n",
              "      <td>6/1/2022</td>\n",
              "      <td>6/5/2022</td>\n",
              "      <td>H193800 16210 2022</td>\n",
              "      <td>0</td>\n",
              "      <td>20</td>\n",
              "      <td>Conference</td>\n",
              "      <td>True</td>\n",
              "      <td>Ecology House</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>PSSP 22 (Precollegiate Summer Scholars Program...</td>\n",
              "      <td>6/1/2022</td>\n",
              "      <td>8/5/2022</td>\n",
              "      <td>H193800 10830 2022</td>\n",
              "      <td>230</td>\n",
              "      <td>230</td>\n",
              "      <td>Summer Academic with RIC</td>\n",
              "      <td>True</td>\n",
              "      <td>Bethe House</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>Summer Program</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>REU Plant Biology 2 (Research Experience for U...</td>\n",
              "      <td>6/1/2022</td>\n",
              "      <td>8/10/2022</td>\n",
              "      <td>H193800 20099 2022</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>Conference</td>\n",
              "      <td>False</td>\n",
              "      <td>Cascadilla</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Classics Department MA Student (Grad Program) 22</td>\n",
              "      <td>6/1/2022</td>\n",
              "      <td>8/13/2022</td>\n",
              "      <td>H193800 20149 2022</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>Summer Program</td>\n",
              "      <td>False</td>\n",
              "      <td>Keeton House</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Upstate NY Summer Math Exam 22</td>\n",
              "      <td>6/3/2022</td>\n",
              "      <td>6/4/2022</td>\n",
              "      <td>H193800 19650</td>\n",
              "      <td>15</td>\n",
              "      <td>18</td>\n",
              "      <td>Conference</td>\n",
              "      <td>True</td>\n",
              "      <td>Mews</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>North Campus</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>NYSPHSAA Golf Championship 22 (New York State ...</td>\n",
              "      <td>6/3/2022</td>\n",
              "      <td>6/6/2022</td>\n",
              "      <td>H193800 18790 2019</td>\n",
              "      <td>185</td>\n",
              "      <td>160</td>\n",
              "      <td>Conference</td>\n",
              "      <td>False</td>\n",
              "      <td>LR 7, LR8, Townhouse</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>REU Plant Biology 22 (Research Experience for ...</td>\n",
              "      <td>6/3/2022</td>\n",
              "      <td>8/12/2022</td>\n",
              "      <td>H193800 20099 2019</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>Conference</td>\n",
              "      <td>False</td>\n",
              "      <td>Cascadilla</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                      University Program / Conference Start Date   End Date  \\\n",
              "0                           Statler Intern Housing 22  5/25/2022   6/1/2022   \n",
              "1   Engineering Cooperative Education Program 22, ...  5/25/2022  8/18/2022   \n",
              "2                    Afghan Student Summer Housing 22  5/25/2022  8/13/2022   \n",
              "3   SRCCS 22 - Summer Research for Community Colle...  5/29/2022  7/24/2022   \n",
              "4                                   REU STC CROPPS 22  5/30/2022   8/5/2022   \n",
              "5   REU BTI 22 (Boyce Thompson Institute Research ...  5/30/2022   8/5/2022   \n",
              "6                                   Summer Session 22  5/30/2022  8/10/2022   \n",
              "7   Engineering Cooperative Education Program 22, ...  5/30/2022  8/12/2022   \n",
              "8                         CVM PhD Visiting Student 22  5/31/2022  7/29/2022   \n",
              "9                          Dean's Leader's Program 22  5/31/2022   8/6/2022   \n",
              "10  CSTEP 22, Session 1 (Collegiate Science and Te...  5/31/2022   8/6/2022   \n",
              "11                        NSF-PREM Faculty Housing 22   6/1/2022   7/1/2022   \n",
              "12  Community-Based Collaborative Global Learning ...   6/1/2022   6/4/2022   \n",
              "13     CrawFly Invertebrate Neurophysiology Course 22   6/1/2022   6/5/2022   \n",
              "14  PSSP 22 (Precollegiate Summer Scholars Program...   6/1/2022   8/5/2022   \n",
              "15  REU Plant Biology 2 (Research Experience for U...   6/1/2022  8/10/2022   \n",
              "16   Classics Department MA Student (Grad Program) 22   6/1/2022  8/13/2022   \n",
              "17                     Upstate NY Summer Math Exam 22   6/3/2022   6/4/2022   \n",
              "18  NYSPHSAA Golf Championship 22 (New York State ...   6/3/2022   6/6/2022   \n",
              "19  REU Plant Biology 22 (Research Experience for ...   6/3/2022  8/12/2022   \n",
              "\n",
              "              Event Code  Attendee Estimate  Housing Estimate  \\\n",
              "0    H19 3800 20175 2022                  2                 2   \n",
              "1     H193800 10771 2019                  5                 5   \n",
              "2     H193800 10800 2022                  9                 9   \n",
              "3     H193800 18830 2019                 11                11   \n",
              "4     H193800 20154 2022                  0                 5   \n",
              "5     H193800 16090 2022                 38                38   \n",
              "6     H193800 10773 2019                100               100   \n",
              "7     H193800 10772 2020                 10                10   \n",
              "8          H193800 ?????                  1                 0   \n",
              "9    H193800  20156 2022                  0                30   \n",
              "10    H193800 20131 2021                 12                 8   \n",
              "11   H193800 20170  2022                  4                10   \n",
              "12  H193800  20161  2022                 30                40   \n",
              "13    H193800 16210 2022                  0                20   \n",
              "14    H193800 10830 2022                230               230   \n",
              "15    H193800 20099 2022                  0                 2   \n",
              "16    H193800 20149 2022                  1                 1   \n",
              "17         H193800 19650                 15                18   \n",
              "18    H193800 18790 2019                185               160   \n",
              "19    H193800 20099 2019                  0                 2   \n",
              "\n",
              "      Event Type Description  Require Housing  \\\n",
              "0             Summer Program             True   \n",
              "1                 Conference            False   \n",
              "2             Summer Program             True   \n",
              "3                 Conference            False   \n",
              "4             Summer Program             True   \n",
              "5             Summer Program             True   \n",
              "6             Summer Program            False   \n",
              "7                 Conference            False   \n",
              "8                 Conference             True   \n",
              "9                 Conference            False   \n",
              "10            Summer Program            False   \n",
              "11                Conference             True   \n",
              "12                Conference             True   \n",
              "13                Conference             True   \n",
              "14  Summer Academic with RIC             True   \n",
              "15                Conference            False   \n",
              "16            Summer Program            False   \n",
              "17                Conference             True   \n",
              "18                Conference            False   \n",
              "19                Conference            False   \n",
              "\n",
              "                        Housing Location  Dining  Returning Program?  \\\n",
              "0                             Cascadilla   False               False   \n",
              "1                             Cascadilla   False                True   \n",
              "2                           Becker House    True               False   \n",
              "3                 Cascadilla then Keeton   False                True   \n",
              "4                           Becker House   False               False   \n",
              "5                             Rose House   False                True   \n",
              "6   Rose House, Keeton House, cascadilla   False                True   \n",
              "7                             Cascadilla   False                True   \n",
              "8                           Becker House   False               False   \n",
              "9                               Comstock   False               False   \n",
              "10                          Becker House   False               False   \n",
              "11                            Townhouses   False                True   \n",
              "12                            Townhouses   False               False   \n",
              "13                         Ecology House   False                True   \n",
              "14                           Bethe House    True                True   \n",
              "15                            Cascadilla   False               False   \n",
              "16                          Keeton House   False               False   \n",
              "17                                  Mews   False               False   \n",
              "18                  LR 7, LR8, Townhouse   False                True   \n",
              "19                            Cascadilla   False               False   \n",
              "\n",
              "    Service Center  \n",
              "0      West Campus  \n",
              "1              NaN  \n",
              "2      West Campus  \n",
              "3              NaN  \n",
              "4              NaN  \n",
              "5              NaN  \n",
              "6              NaN  \n",
              "7              NaN  \n",
              "8      West Campus  \n",
              "9              NaN  \n",
              "10             NaN  \n",
              "11             NaN  \n",
              "12    North Campus  \n",
              "13             NaN  \n",
              "14  Summer Program  \n",
              "15             NaN  \n",
              "16             NaN  \n",
              "17    North Campus  \n",
              "18             NaN  \n",
              "19             NaN  "
            ]
          },
          "execution_count": 26,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "conferences.head(20)"
      ]
    }
  ],
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "display_name": "Python 3",
      "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.8"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}