Research (1).ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# TBD College Data "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import csv "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>Id</th>\n",
       "      <th>Semester</th>\n",
       "      <th>AcademicLevel</th>\n",
       "      <th>Subject</th>\n",
       "      <th>Campus</th>\n",
       "      <th>Title</th>\n",
       "      <th>Instructors</th>\n",
       "      <th>DeliveryMode</th>\n",
       "      <th>InstructionalFormat</th>\n",
       "      <th>Schedule</th>\n",
       "      <th>Units</th>\n",
       "      <th>Capacity</th>\n",
       "      <th>Enrolled</th>\n",
       "      <th>Status</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>Co-LocatesWith</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-32606</td>\n",
       "      <td>Fall 2020</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Animation</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ANIMA-1000-1 : Animation 1</td>\n",
       "      <td>Andrew Lyndon</td>\n",
       "      <td>Online</td>\n",
       "      <td>Studio</td>\n",
       "      <td>Mon/Thu 4:00-07:00PM</td>\n",
       "      <td>3.0</td>\n",
       "      <td>18</td>\n",
       "      <td>16</td>\n",
       "      <td>Closed</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>2020-12-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online course sections will be delivered mostl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-33677</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Animation</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ANIMA-1000-1 : Animation 1</td>\n",
       "      <td>Christine Richard</td>\n",
       "      <td>Online</td>\n",
       "      <td>Studio</td>\n",
       "      <td>Wed/Fri 4:00-05:25PM, Online - FA-14</td>\n",
       "      <td>3.0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online course sections will be delivered mostl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-33678</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Animation</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ANIMA-1000-2 : Animation 1</td>\n",
       "      <td>Andrew Lyndon</td>\n",
       "      <td>Online</td>\n",
       "      <td>Studio</td>\n",
       "      <td>Wed/Fri 4:00-05:25PM, Online - FA-1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online course sections will be delivered mostl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-32607</td>\n",
       "      <td>Fall 2020</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Animation</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ANIMA-1000-2 : Animation 1</td>\n",
       "      <td>Christine Richard</td>\n",
       "      <td>Online</td>\n",
       "      <td>Studio</td>\n",
       "      <td>Tue/Fri 4:00-07:00PM</td>\n",
       "      <td>3.0</td>\n",
       "      <td>18</td>\n",
       "      <td>10</td>\n",
       "      <td>Open</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>2020-12-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online course sections will be delivered mostl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-34479</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Animation</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ANIMA-1000-3 : Animation 1</td>\n",
       "      <td>Wallace Keller</td>\n",
       "      <td>Online</td>\n",
       "      <td>Studio</td>\n",
       "      <td>Fri 12:00-02:55PM</td>\n",
       "      <td>3.0</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online course sections will be delivered mostl...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  Id     Semester  AcademicLevel    Subject  \\\n",
       "0  COURSE_SECTION_DEFINITION-3-32606    Fall 2020  Undergraduate  Animation   \n",
       "1  COURSE_SECTION_DEFINITION-3-33677  Spring 2021  Undergraduate  Animation   \n",
       "2  COURSE_SECTION_DEFINITION-3-33678  Spring 2021  Undergraduate  Animation   \n",
       "3  COURSE_SECTION_DEFINITION-3-32607    Fall 2020  Undergraduate  Animation   \n",
       "4  COURSE_SECTION_DEFINITION-3-34479  Spring 2021  Undergraduate  Animation   \n",
       "\n",
       "  Campus                       Title        Instructors DeliveryMode  \\\n",
       "0    TBD  ANIMA-1000-1 : Animation 1      Andrew Lyndon       Online   \n",
       "1    TBD  ANIMA-1000-1 : Animation 1  Christine Richard       Online   \n",
       "2    TBD  ANIMA-1000-2 : Animation 1      Andrew Lyndon       Online   \n",
       "3    TBD  ANIMA-1000-2 : Animation 1  Christine Richard       Online   \n",
       "4    TBD  ANIMA-1000-3 : Animation 1     Wallace Keller       Online   \n",
       "\n",
       "  InstructionalFormat                              Schedule  Units  Capacity  \\\n",
       "0              Studio                  Mon/Thu 4:00-07:00PM    3.0        18   \n",
       "1              Studio  Wed/Fri 4:00-05:25PM, Online - FA-14    3.0        15   \n",
       "2              Studio   Wed/Fri 4:00-05:25PM, Online - FA-1    3.0        18   \n",
       "3              Studio                  Tue/Fri 4:00-07:00PM    3.0        18   \n",
       "4              Studio                     Fri 12:00-02:55PM    3.0        18   \n",
       "\n",
       "   Enrolled  Status   StartDate     EndDate Co-LocatesWith  \\\n",
       "0        16  Closed  2020-09-02  2020-12-15            NaN   \n",
       "1         0    Open  2021-01-25  2021-05-09            NaN   \n",
       "2         0    Open  2021-01-25  2021-05-09            NaN   \n",
       "3        10    Open  2020-09-02  2020-12-15            NaN   \n",
       "4         0    Open  2021-01-25  2021-05-09            NaN   \n",
       "\n",
       "                                         Description  \n",
       "0  Online course sections will be delivered mostl...  \n",
       "1  Online course sections will be delivered mostl...  \n",
       "2  Online course sections will be delivered mostl...  \n",
       "3  Online course sections will be delivered mostl...  \n",
       "4  Online course sections will be delivered mostl...  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=pd.read_csv('test.csv')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "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>Id</th>\n",
       "      <th>Semester</th>\n",
       "      <th>AcademicLevel</th>\n",
       "      <th>Subject</th>\n",
       "      <th>Campus</th>\n",
       "      <th>Title</th>\n",
       "      <th>Instructors</th>\n",
       "      <th>DeliveryMode</th>\n",
       "      <th>InstructionalFormat</th>\n",
       "      <th>Schedule</th>\n",
       "      <th>Units</th>\n",
       "      <th>Capacity</th>\n",
       "      <th>Enrolled</th>\n",
       "      <th>Status</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>Co-LocatesWith</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1574</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-34422</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Writing and Literature</td>\n",
       "      <td>TBD</td>\n",
       "      <td>WRLIT-3600-1 : MH: Literary Theory</td>\n",
       "      <td>Eric Olson</td>\n",
       "      <td>Online</td>\n",
       "      <td>Seminar</td>\n",
       "      <td>Wed 5:00-06:25PM</td>\n",
       "      <td>3.0</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Literary theory&amp;#39;s central concern is how w...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1575</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-34423</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Writing and Literature</td>\n",
       "      <td>TBD</td>\n",
       "      <td>WRLIT-3980-1 : Internship</td>\n",
       "      <td>Eric Olson</td>\n",
       "      <td>Online</td>\n",
       "      <td>Internship</td>\n",
       "      <td>Meeting Time TBD</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1576</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-34424</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Writing and Literature</td>\n",
       "      <td>TBD</td>\n",
       "      <td>WRLIT-4000-1 : L: Influences: Writers on Writi...</td>\n",
       "      <td>Anne F Shea</td>\n",
       "      <td>Online</td>\n",
       "      <td>Workshop</td>\n",
       "      <td>Wed 8:00-09:25AM, Online - HS-7</td>\n",
       "      <td>3.0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Who influenced you to first become a writer or...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1577</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-34425</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Writing and Literature</td>\n",
       "      <td>TBD</td>\n",
       "      <td>WRLIT-4080-1 : Senior Project: Thesis</td>\n",
       "      <td>Faith E Adiele</td>\n",
       "      <td>Online</td>\n",
       "      <td>Thesis</td>\n",
       "      <td>Thu 12:00-01:55PM, Online - HS-1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>VISST-4040-1: Senior Project 2</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1578</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-33621</td>\n",
       "      <td>Fall 2020</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Writing and Literature</td>\n",
       "      <td>TBD</td>\n",
       "      <td>WRLIT-4080-2 : Senior Project: Thesis</td>\n",
       "      <td>Faith E Adiele</td>\n",
       "      <td>Online</td>\n",
       "      <td>Thesis</td>\n",
       "      <td>Fri 12:00-03:00PM, Online - HS-4</td>\n",
       "      <td>3.0</td>\n",
       "      <td>11</td>\n",
       "      <td>6</td>\n",
       "      <td>Open</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>2020-12-15</td>\n",
       "      <td>VISST-4000-1: Senior Project 1</td>\n",
       "      <td>COURSE DESCRIPTIONThis workshop is for majors ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     Id     Semester  AcademicLevel  \\\n",
       "1574  COURSE_SECTION_DEFINITION-3-34422  Spring 2021  Undergraduate   \n",
       "1575  COURSE_SECTION_DEFINITION-3-34423  Spring 2021  Undergraduate   \n",
       "1576  COURSE_SECTION_DEFINITION-3-34424  Spring 2021  Undergraduate   \n",
       "1577  COURSE_SECTION_DEFINITION-3-34425  Spring 2021  Undergraduate   \n",
       "1578  COURSE_SECTION_DEFINITION-3-33621    Fall 2020  Undergraduate   \n",
       "\n",
       "                     Subject Campus  \\\n",
       "1574  Writing and Literature    TBD   \n",
       "1575  Writing and Literature    TBD   \n",
       "1576  Writing and Literature    TBD   \n",
       "1577  Writing and Literature    TBD   \n",
       "1578  Writing and Literature    TBD   \n",
       "\n",
       "                                                  Title     Instructors  \\\n",
       "1574                 WRLIT-3600-1 : MH: Literary Theory      Eric Olson   \n",
       "1575                          WRLIT-3980-1 : Internship      Eric Olson   \n",
       "1576  WRLIT-4000-1 : L: Influences: Writers on Writi...     Anne F Shea   \n",
       "1577              WRLIT-4080-1 : Senior Project: Thesis  Faith E Adiele   \n",
       "1578              WRLIT-4080-2 : Senior Project: Thesis  Faith E Adiele   \n",
       "\n",
       "     DeliveryMode InstructionalFormat                          Schedule  \\\n",
       "1574       Online             Seminar                  Wed 5:00-06:25PM   \n",
       "1575       Online          Internship                  Meeting Time TBD   \n",
       "1576       Online            Workshop   Wed 8:00-09:25AM, Online - HS-7   \n",
       "1577       Online              Thesis  Thu 12:00-01:55PM, Online - HS-1   \n",
       "1578       Online              Thesis  Fri 12:00-03:00PM, Online - HS-4   \n",
       "\n",
       "      Units  Capacity  Enrolled Status   StartDate     EndDate  \\\n",
       "1574    3.0        15         1   Open  2021-01-25  2021-05-09   \n",
       "1575    3.0         1         0   Open  2021-01-25  2021-05-09   \n",
       "1576    3.0        15         0   Open  2021-01-25  2021-05-09   \n",
       "1577    3.0        10         1   Open  2021-01-25  2021-05-09   \n",
       "1578    3.0        11         6   Open  2020-09-02  2020-12-15   \n",
       "\n",
       "                      Co-LocatesWith  \\\n",
       "1574                             NaN   \n",
       "1575                             NaN   \n",
       "1576                             NaN   \n",
       "1577  VISST-4040-1: Senior Project 2   \n",
       "1578  VISST-4000-1: Senior Project 1   \n",
       "\n",
       "                                            Description  \n",
       "1574  Literary theory&#39;s central concern is how w...  \n",
       "1575                                                NaN  \n",
       "1576  Who influenced you to first become a writer or...  \n",
       "1577                                                NaN  \n",
       "1578  COURSE DESCRIPTIONThis workshop is for majors ...  "
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Id', 'Semester', 'AcademicLevel', 'Subject', 'Campus', 'Title',\n",
       "       'Instructors', 'DeliveryMode', 'InstructionalFormat', 'Schedule',\n",
       "       'Units', 'Capacity', 'Enrolled', 'Status', 'StartDate', 'EndDate',\n",
       "       'Co-LocatesWith', 'Description'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# let's see different type of subject."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "total course offer:\n",
      "46\n",
      "total unique scourse are:\n",
      "{'Fine Arts Elective', 'Social Science and History', 'Textiles', 'Film', 'Diversity Studies', 'Interior Design', 'Science and Math', 'Animation', 'Graduate Film', 'Furniture', 'Comics', 'Exchange', 'Grad Wide Elective', 'Graduate Curatorial Practice', 'Graduate Design Strategy', 'Glass', 'Graduate Writing', 'Photography', 'Philosophy and Critical Theory', 'Printmaking', 'Graphic Design', 'Graduate Advanced Architecture Design', 'Visual Studies', 'Graduate Architecture', 'Writing and Literature', 'Graduate Design', 'Upper Level Interdisciplinary Studio', 'Interdisciplinary Critique', 'Graduate Interaction Design', 'Literary and Performing Arts Studies', 'First Year Core Studio (FYCST)', 'Sculpture', 'Community Arts', 'Industrial Design', 'Painting and Drawing', 'Graduate Visual and Critical Studies', 'Jewelry and Metal Arts', 'Architecture', 'Critical Studies', 'Fashion Design', 'Interaction Design', 'Individualized', 'Illustration', 'Craft', 'Graduate Fine Arts', 'Ceramics'}\n"
     ]
    }
   ],
   "source": [
    "print(\"total course offer:\")\n",
    "print(len(set(df['Subject'])))\n",
    "print(\"total unique scourse are:\")\n",
    "print(set(df['Subject']))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# let's see instructor "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "total faculty professor\n",
      "492\n",
      "professor names are:\n",
      "{nan, 'Rebecca Foster', 'Bijan Yashar', 'Steve Jones', 'Blake Hudelson', 'Jake F Dunagan | Robert von Goeben', 'Rebekah Bloyd', 'Jasmin Darznik', 'Helen Klonaris', 'Sahar Khoury', 'Michael Gillette', 'Shawn Sprockett', 'Kim Lauren Bennett', 'Margo Majewska', 'Matthew C Boyko', 'Luca Antonucci', 'David E Gonzalez', 'Juvenal Acosta', 'Hugo Eccles | Sudhu Tewari', 'Alireza Borhani Haghighi', 'Irene C Cheng', 'John I Jennings', 'Marianne Rogoff', 'Shalini Agrawal | Ava Roy', 'Vanessa Chang', 'Allison Yasukawa', 'Anne F Shea', 'Ghazaleh Khalifeh', 'Rod Cavazos', 'Lisa M Brown', 'Adrien R Segal', 'Erik Parra', 'Bryan W Sloan', 'Gloria Frym', 'David Huffman', 'Sara Fenske Bahat | Jake F Dunagan | Ali Draudt', 'Taraneh Hemami', 'Sam Vernon', 'Matt Grigsby | Alex Nah', 'Scott Thorpe', 'Deborah Valoma | Angela Hennessy', 'Caroline de Baere', 'Dan McHale', 'Forrest Hartman', 'Joy Liu', 'Jessica Calvanico', 'Monica Bravo', 'Darell Fields', 'Angela Hennessy', 'Lisa Findley | Janette Kim | Christopher Falliers', 'Gregory Climer | Zoe Cobb', 'Viet H Le', 'Graham S Plumb', 'Leif C Petersson', 'Ana Llorente', 'Kristian Simsarian', 'Rita Bullwinkel', 'Melanie Gillman', 'Clayton Williams | Matt Kendall', 'Antje Steinmuller', 'Leslie Roberts', 'Vince Law | Martin Low', 'Norman Charles DeCarlo', 'Jody Gillerman', 'Brendon Levitt', 'Eddie Yuen', 'Dena Beard', 'Ann Skartvedt', 'Rodney Brett', 'Chip Minnick', 'Gretchen Anderson', 'Sita Kuratomi Bhaumik', 'Amana Harris', 'Mark Donohue', 'Joseph Graham', 'Elizabeth Hille', 'Julie Thi Underhill', 'Modesto R Covarrubias', 'Randel Chavez', 'Mia Feuer | Shalini Agrawal', 'Michael Washington', 'Robert Adams', 'Joshua Ellingson | Michael Gillette', 'David Meyers', 'Tim E Soman | Vaughn Smith', 'Ryan Peter', 'Curtis Arima', 'Alex Nah', 'Michelle Katz', 'Jordan Kantor', 'Zachary Walter', 'Hana Nagel', 'Ajuan Mance', 'Christina Linden', 'Donald Matthew Smith', 'Ren Fiss', 'Acacia Woods Chan', 'Anthony Murray', 'Jane McKinne-Mayer', 'Negar Kalantar | Alireza Borhani Haghighi', 'Clark M Thenhaus | Dylan Krueger', 'Daniel Sevall | Brett Hazlett', 'Kate Rutter', 'Alon Helman', 'Raffi Minasian', 'Amy Bickerton', 'Jon M Stich', 'Alexander Schofield | Dylan Krueger', 'Anthea Black', 'Rafi S Ajl', 'Doris Guerrero', 'Clark M Thenhaus', 'Anthony Murray | Gregory Climer', 'John Mauriello', 'Katherine Lambert', 'Susan Robinson', 'Randy Nakamura', 'Nelson Chan', 'christopher hamamoto', 'Joshua Ellingson', 'George Gantzer', 'Deborah Lozier', 'Ed Bell', 'Erik Scollon', 'Josef Jacques', 'J.D. Zamfirescu-Pereira | Rolf van Widenfelt', 'Mark Fox', 'Deborah Valoma', 'Eugenia M Mitsanas', 'Daniell Cornell', 'Denise Newman', 'Danielle Lawrence', 'Rickey Vincent', 'Katherine Lam', 'Lamarr Nanton | May Liang', 'David Gissen', 'Adam Farcus', 'Brian Gulassa', 'Johannes Seemann', 'Susan Worthman', 'Allen T Passalaqua', 'Amy A Morrell | Crystal Titus', 'Daniel B Olmsted', 'Joyce Rice', 'Joshua Faught', 'Denise Gershbein | Rochelle Ardesher', 'Linda Geary', 'Nidhi Chanani', 'Christine Wang', 'James M Kettner', 'Cathrine A Veikos', 'Amy A Lu', 'Edward J Luce', 'Amy Campos', 'Josh Silverman', 'Yana Ronin', 'Martin Venezky | Matthew C Boyko', 'Robert Ciano', 'Benjamin Shaykin', 'Lynn Robinson', 'George Evelyn', 'Erik Adigard | Ignacio Valero', 'Xandra Castleton', 'Ranu Mukherjee', 'Kseniya Makarova', 'Imani Roach', 'Ryan Keerns', 'Shalle Leeming', 'Emily McVarish', 'Tim E Soman', 'Mark Thompson', 'Matt Grigsby', 'Kari K Marboe | Clifford Rainey', 'Eric Olson', 'Nkiruka Oparah', 'Andrew Atteberry', 'Cindy Bello', 'Gregory Climer', 'James Vanié', 'Eduardo A Pineda', 'Andrew Lyndon', 'Edward Leaman', 'Jesus Garcia Galvez | Alexander Baumgardt', 'Christopher Johnson', 'Maxwell Leung', 'Ivan Iannoli', 'James Graham', 'Carol Elkovich', 'Owen Smith', 'Rudolf Frieling', 'James Voorhies', 'Andrea Moed', 'Michael Toren', 'Juan Carlos Rodriguez Rivera', 'Sara Elizabeth Dean', 'William Rossel', 'Michael Bogan | Anthony Murray', 'Suzanne Redding | Yeban Shin', 'Jordan Kantor | Kota Ezawa | Sam Vernon', 'Christopher Cantor', 'Robert Epstein', 'Michael Wertz', 'Cathy Lu', 'Josef Chytry', 'Mitchell Schwarzer', 'David N Skolnick', 'Jennifer Sonderby', 'Mia Liu', 'Michelle Murillo', 'Suzanne Redding | Sandrine N Lebas', 'Michael Chanover', 'Nathan Shedroff', 'Kacey Ballard', 'Valerie D Mih', 'Sean Negus', 'Evan Jones | Margaret Ikeda', 'Scott Minneman', 'Thorina H Rose', 'Melissa Leventon', 'Erin Algeo', 'Cristina Gaitan', 'Dodie Bellamy', 'Andreas Procopiou', 'Jose A Brunner', 'Karen Seneferu', 'Gregory Cowley', 'Mia Feuer', 'Adam McCauley', 'Glen Helfand', 'Keith Thomas', 'Will Ruby', 'Mel Olivares', 'Mary Banas', 'Daniel Sevall', 'Luis Shein', 'Jean Oppermann', 'Helen De Michiel', 'Faith E Adiele', 'John de Fazio', 'Mariella Poli', 'Brendan Beazley', 'Rob Saunders', 'Devorah Major', 'Rebecca Blum', 'Christine Richard', 'Purvi Shah', 'Trena Noval', 'Florian Grosser', 'Betsy Geist | Susan Worthman', 'Jorge Arango', 'Tim E Soman | Zachary Walter', 'Ishmael Reed', 'Elizabeth Glenewinkel | Sasha Charlemagne', 'Jason Anderson', 'Jacqueline Francis', \"Donald Matthew Smith | Alison O'Daniel\", 'Neal JZ Schwartz', 'Susanne Cockrell', 'Kevin Yeung', 'Robert Hunt', 'Arthur Gonzalez', 'Pallavi Sharma', 'Thomas Ingalls', 'Abner Nolan', 'MontaQue Ruffin', 'Angie Wang', 'William Alschuler', 'William Littmann', 'David Maynard', 'Hossein Khosrowjah | Jane McKinne-Mayer', 'Matt Kendall', 'Helen Maria Nugent', 'Timothy Goodman', 'Blake Hudelson | Sandrine N Lebas', 'Katharine Karnaky', 'Sasha Charlemagne', 'Randolph Ruiz', 'Jon Sueda', 'Erin Malone', 'Brian Conley', 'Tracy Burns', \"Lauren D'Amato\", 'Steven Diller', 'Megan Werner', 'Zoe Cobb', 'Vreni Michelini-Castillo', 'Meg Bisineer', 'Kota Ezawa', \"Marc O'Brien | Sarah Harrison\", 'Jez Flores-García', 'Scott Minneman | Hugo Eccles', 'Michele Turnure-Salleo', 'Michelle Meeker', 'Lynn Kirby', 'Praba Pilar', 'Mara Holt Skov', 'Blake Hudelson | David E Gonzalez', 'Lynda Grose', 'Kristian Simsarian | Nathan Shedroff', 'Annah Anti-Palindrome', 'Nicole J Georges', 'Brooke Lober', 'Genevieve Hyacinthe', 'Kristen Hanley Cardozo', 'Robert Hugel', 'Noam Eisen', 'Matt Silady', 'Margaux Schindler', 'Anita Amirrezvani', 'Natasha Haugnes', 'Paul Montgomery', 'Peter Anderson', 'Breena Nunez', 'Ceci Moss', 'May Liang', 'Leila Weefur', 'Karin C Myint', 'Noah Stern', 'Gia-Bao H Tran', 'Shalini Agrawal', 'Michael Hunter', 'Elizabeth Mangini', 'Federico Villa | Neil Torrefiel', 'Apurva Shah', 'Rebekah L Edwards', 'Raegan Truax', 'Christoph M Steger', 'James Gobel', 'Karla Wozniak', 'Tina B Hardison', 'J.D. Zamfirescu-Pereira', 'Caty Telfair', 'Margaret Ikeda', 'Sudhu Tewari', 'Christina La Sala', 'James D Deasy', 'David Hisaya Asari', 'K.C. Rosenberg', 'Lauren Wooley', 'Yeban Shin', 'Deborah Stein', 'Kari K Marboe', 'Ayize Jama-Everett', 'Shylah Pacheco Hamilton', 'Lisa Findley', 'Hugh Dubberly', 'Amy Bickerton | Jake Rheinfrank', 'Judith Serin', 'Thi P Bui', 'David Cole', 'Patricia Kilroe', 'Nathan Lynch', 'Jeanne Finley', 'Julia Grinkrug | Christopher A Roach', \"Marc O'Brien\", 'Guillermo Galindo', 'Victor Vargas', 'Laura F Hazlett', 'Ben Taube | Edlyn García La Torre | Eric Morrill', 'Leslie Townsend', 'Marty Marfin', 'Ana Llorente | Mary Banas', 'Huma Dar', 'Melinda De Jesus', 'Brian Karl', 'Thomas O Haakenson', 'Sydney Cohen', 'Rachel Berger', 'Patricia Kavanaugh', 'Lynda Grose | Gregory Climer', 'Brooke Hessler', 'Steven Diller | Sara Fenske Bahat', 'Steven Dickison', 'Thom Faulders', 'Brett Macfadden | Sara Elizabeth Dean', 'Aaron Gach', 'Nataly Gattegno', 'Alvaro Villanueva', 'Wallace Keller', 'Maria Porges', 'Sean Nash', 'Amy A Morrell', 'Alexander Schofield', 'Brian Price', 'Martin Venezky', 'Edith Garcia', 'Marilyn Da Silva', 'Lydia Nakashima Degarrod', 'Colin Owen | Hugo Eccles', 'Clifford Rainey', 'Jeanette Roan', 'Paul Montgomery | Martin Venezky', 'Saraleah Fordyce', 'Neeraj Bhatia', 'Cris Applegate', 'Mathew Kneebone', 'Martin Low', 'David A Curiel', 'Ben Taube', 'Becca B. Imrich | Narges Poursadeqi', 'Eric Morrill', 'Christopher Falliers | Nataly Gattegno', \"Alison O'Daniel\", 'James Gobel | Terri Friedman', 'David Kasprzak', 'Justin R Hall', 'Vince Law | Sasha Charlemagne', 'Victoria Wagner', 'James Graham | Irene C Cheng', 'Rekia Jibrin', 'Sang Jin Lee', 'Ryan Malloy', 'Janette Kim', 'Richard Elliott', 'Hossein Khosrowjah', 'Hugh Behm-Steinberg', 'Monica Bravo | Ren Fiss | Genevieve Hyacinthe | Elizabeth Mangini', 'Taro Hattori', 'Eric Heiman', 'Jorge Arango | Alexander Baumgardt', 'Peter Simensky', 'Monica Martinez', 'Lydia Greer', 'Jason Johnson', 'Tamara Porras', 'Craig Scott', 'Emma Berliner', 'Patricia G. Lange', 'Elizabeth Travelslight', 'Jaime Colin Knight', 'Sunny Han', 'Ryan Keerns | Daniel Garcia', 'Nilgun Bayraktar', 'Aynne Valencia', 'Michael Bogan', 'Hugh Hynes | Brian Price', 'Ignacio Valero', 'Silas Munro', 'Negar Kalantar', 'Kathy Zarur', 'Patricia M Maloney', 'Margaret Ikeda | Mark Donohue | Brendon Levitt', 'Christina Worsing', 'Andrew Dayton', 'Tom Barbash', 'Suzanne Redding', 'Aspen Mays', 'Christopher Falliers', 'Martin Low | Nicholas Cawthon', 'Linda Yaven', 'Marina Pugliese', 'Kristen L Smith', 'Ian MacColl', 'David Maynard | Margaret Ikeda | Brendon Levitt', 'Lisa Findley | Christopher Falliers', 'Marina Contro', 'Craig Good', 'Erin Algeo | Melissa Leventon', 'John Wilkins', 'Donna de la Perriere', 'Christopher Loomis', 'Leslie Becker', 'Kim Nguyen', 'Brett Macfadden', 'Shannon Danielle Taylor', 'Jayne Foster', 'Anne Wolf', 'christopher hamamoto | Jon Sueda', 'Terri Friedman', 'Donald Fortescue', 'Cesar Escalante Chinchilla | Matt Kendall', 'Geefwee Boedoe', 'Amy Sims', 'Mary Ellen Hannibal', 'Noga G Wizansky', 'Donald Fortescue | Sung Kim', 'Scott Minneman | Jeremy Mende', 'Caroline Goodwin', 'Sara A Raffo', 'Shari Paladino', 'Julian Carter', 'Cory Barr', 'Kenneth Lee', 'Edlyn García La Torre', 'Taro Hattori | Shalini Agrawal', 'Alexander Baumgardt', 'Julia Grinkrug | Shalini Agrawal', 'Nomi Kane', 'Jeremy Mende', 'Isabel Samaras', 'Kim Anno', 'Jia Yi Gu'}\n"
     ]
    }
   ],
   "source": [
    "print(\"total faculty professor\")\n",
    "print(len(set(df['Instructors'])))\n",
    "print(\"professor names are:\")\n",
    "print(set(df['Instructors']))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "intakes are:\n",
      "{'Spring 2021', 'Fall 2020', 'Summer 2020'}\n",
      "total number of intakes are:\n",
      "3\n"
     ]
    }
   ],
   "source": [
    "print(\"intakes are:\")\n",
    "print(set(df['Semester']))\n",
    "print(\"total number of intakes are:\")\n",
    "print(len(set(df['Semester'])))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [],
   "source": [
    "#let's see popular course."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Graduate Fine Arts                       118\n",
       "Animation                                 93\n",
       "Visual Studies                            93\n",
       "Writing and Literature                    88\n",
       "Architecture                              84\n",
       "Diversity Studies                         79\n",
       "Graduate Architecture                     73\n",
       "Graphic Design                            70\n",
       "Industrial Design                         64\n",
       "Graduate Design                           60\n",
       "Illustration                              48\n",
       "Literary and Performing Arts Studies      43\n",
       "Fashion Design                            42\n",
       "First Year Core Studio (FYCST)            42\n",
       "Interaction Design                        40\n",
       "Film                                      38\n",
       "Interior Design                           36\n",
       "Comics                                    31\n",
       "Printmaking                               29\n",
       "Philosophy and Critical Theory            29\n",
       "Graduate Interaction Design               29\n",
       "Social Science and History                26\n",
       "Painting and Drawing                      25\n",
       "Critical Studies                          25\n",
       "Upper Level Interdisciplinary Studio      21\n",
       "Grad Wide Elective                        20\n",
       "Science and Math                          20\n",
       "Photography                               19\n",
       "Textiles                                  18\n",
       "Sculpture                                 18\n",
       "Graduate Writing                          17\n",
       "Graduate Film                             16\n",
       "Individualized                            16\n",
       "Graduate Design Strategy                  15\n",
       "Graduate Curatorial Practice              14\n",
       "Community Arts                            14\n",
       "Jewelry and Metal Arts                    12\n",
       "Ceramics                                  11\n",
       "Graduate Visual and Critical Studies      11\n",
       "Furniture                                  9\n",
       "Craft                                      7\n",
       "Exchange                                   5\n",
       "Interdisciplinary Critique                 4\n",
       "Graduate Advanced Architecture Design      3\n",
       "Glass                                      3\n",
       "Fine Arts Elective                         1\n",
       "Name: Subject, dtype: int64"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Subject'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    1579.000000\n",
       "mean       13.682077\n",
       "std         7.623525\n",
       "min         0.000000\n",
       "25%        11.000000\n",
       "50%        15.000000\n",
       "75%        16.000000\n",
       "max       150.000000\n",
       "Name: Capacity, dtype: float64"
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Capacity'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    1579.000000\n",
       "mean        5.373654\n",
       "std         6.261392\n",
       "min         0.000000\n",
       "25%         0.000000\n",
       "50%         2.000000\n",
       "75%        10.000000\n",
       "max        36.000000\n",
       "Name: Enrolled, dtype: float64"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Enrolled'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "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>Id</th>\n",
       "      <th>Semester</th>\n",
       "      <th>AcademicLevel</th>\n",
       "      <th>Subject</th>\n",
       "      <th>Campus</th>\n",
       "      <th>Title</th>\n",
       "      <th>Instructors</th>\n",
       "      <th>DeliveryMode</th>\n",
       "      <th>InstructionalFormat</th>\n",
       "      <th>Schedule</th>\n",
       "      <th>Units</th>\n",
       "      <th>Capacity</th>\n",
       "      <th>Enrolled</th>\n",
       "      <th>Status</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>Co-LocatesWith</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-32639</td>\n",
       "      <td>Fall 2020</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Animation</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ANIMA-3600-1 : Media History: History of Anima...</td>\n",
       "      <td>Christoph M Steger</td>\n",
       "      <td>Online</td>\n",
       "      <td>Seminar</td>\n",
       "      <td>Mon 12:00-03:00PM</td>\n",
       "      <td>3.0</td>\n",
       "      <td>36</td>\n",
       "      <td>24</td>\n",
       "      <td>Open</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>2020-12-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online course sections will be delivered mostl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-33709</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Animation</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ANIMA-3600-1 : MH: History of Animation</td>\n",
       "      <td>Christoph M Steger</td>\n",
       "      <td>Online</td>\n",
       "      <td>Seminar</td>\n",
       "      <td>Fri 2:00-03:25PM</td>\n",
       "      <td>3.0</td>\n",
       "      <td>36</td>\n",
       "      <td>1</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online course sections will be delivered mostl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-33740</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Architecture</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ARCHT-3980-1 : Internship</td>\n",
       "      <td>Randolph Ruiz</td>\n",
       "      <td>Online</td>\n",
       "      <td>Internship</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-33746</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Architecture</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ARCHT-5070-1 : PLACEHOLDER: Advanced Studio</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online</td>\n",
       "      <td>Studio</td>\n",
       "      <td>Meeting Time TBD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>This course has two required components. Stude...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-33747</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Architecture</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ARCHT-5070-2 : PLACEHOLDER: Adv Studio Workshop</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online</td>\n",
       "      <td>Workshop</td>\n",
       "      <td>Meeting Time TBD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>75</td>\n",
       "      <td>1</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>This course has two required components. Stude...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-32683</td>\n",
       "      <td>Fall 2020</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Architecture</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ARCHT-5080-1 : Placeholder: Integrated Studio</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online</td>\n",
       "      <td>Workshop</td>\n",
       "      <td>Meeting Time TBD | Mon/Thu 12:30-06:30PM</td>\n",
       "      <td>6.0</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>Open</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>2020-12-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>This studio focuses on the integration and dev...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>512</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-34178</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Graduate</td>\n",
       "      <td>Graduate Architecture</td>\n",
       "      <td>TBD</td>\n",
       "      <td>MARCH-6070-1 : Placeholder: Advanced Studio</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online</td>\n",
       "      <td>Studio</td>\n",
       "      <td>Meeting Time TBD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>This course has two required components. Stude...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>513</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-33408</td>\n",
       "      <td>Fall 2020</td>\n",
       "      <td>Graduate</td>\n",
       "      <td>Graduate Architecture</td>\n",
       "      <td>TBD</td>\n",
       "      <td>MARCH-6070-1 : Placeholder: Advanced Studio</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online</td>\n",
       "      <td>Studio</td>\n",
       "      <td>Mon/Thu 12:30-06:30PM</td>\n",
       "      <td>6.0</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>Open</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>2020-12-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>524</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-35026</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Graduate</td>\n",
       "      <td>Graduate Architecture</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MARCH-6070-10 : Placeholder: Adv Studio Workshop</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online</td>\n",
       "      <td>Workshop</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>75</td>\n",
       "      <td>0</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>This is a vertical studio combining undergradu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>525</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-33412</td>\n",
       "      <td>Fall 2020</td>\n",
       "      <td>Graduate</td>\n",
       "      <td>Graduate Architecture</td>\n",
       "      <td>TBD</td>\n",
       "      <td>MARCH-6080-1 : Placeholder: Integrated Studio</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online</td>\n",
       "      <td>Workshop</td>\n",
       "      <td>Mon/Thu 12:30-06:30PM</td>\n",
       "      <td>6.0</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>Open</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>2020-12-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>This studio focuses on the integration and dev...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    Id     Semester  AcademicLevel  \\\n",
       "63   COURSE_SECTION_DEFINITION-3-32639    Fall 2020  Undergraduate   \n",
       "64   COURSE_SECTION_DEFINITION-3-33709  Spring 2021  Undergraduate   \n",
       "127  COURSE_SECTION_DEFINITION-3-33740  Spring 2021  Undergraduate   \n",
       "142  COURSE_SECTION_DEFINITION-3-33746  Spring 2021  Undergraduate   \n",
       "143  COURSE_SECTION_DEFINITION-3-33747  Spring 2021  Undergraduate   \n",
       "156  COURSE_SECTION_DEFINITION-3-32683    Fall 2020  Undergraduate   \n",
       "512  COURSE_SECTION_DEFINITION-3-34178  Spring 2021       Graduate   \n",
       "513  COURSE_SECTION_DEFINITION-3-33408    Fall 2020       Graduate   \n",
       "524  COURSE_SECTION_DEFINITION-3-35026  Spring 2021       Graduate   \n",
       "525  COURSE_SECTION_DEFINITION-3-33412    Fall 2020       Graduate   \n",
       "\n",
       "                   Subject Campus  \\\n",
       "63               Animation    TBD   \n",
       "64               Animation    TBD   \n",
       "127           Architecture    NaN   \n",
       "142           Architecture    TBD   \n",
       "143           Architecture    TBD   \n",
       "156           Architecture    TBD   \n",
       "512  Graduate Architecture    TBD   \n",
       "513  Graduate Architecture    TBD   \n",
       "524  Graduate Architecture    NaN   \n",
       "525  Graduate Architecture    TBD   \n",
       "\n",
       "                                                 Title         Instructors  \\\n",
       "63   ANIMA-3600-1 : Media History: History of Anima...  Christoph M Steger   \n",
       "64             ANIMA-3600-1 : MH: History of Animation  Christoph M Steger   \n",
       "127                          ARCHT-3980-1 : Internship       Randolph Ruiz   \n",
       "142        ARCHT-5070-1 : PLACEHOLDER: Advanced Studio                 NaN   \n",
       "143    ARCHT-5070-2 : PLACEHOLDER: Adv Studio Workshop                 NaN   \n",
       "156      ARCHT-5080-1 : Placeholder: Integrated Studio                 NaN   \n",
       "512        MARCH-6070-1 : Placeholder: Advanced Studio                 NaN   \n",
       "513        MARCH-6070-1 : Placeholder: Advanced Studio                 NaN   \n",
       "524   MARCH-6070-10 : Placeholder: Adv Studio Workshop                 NaN   \n",
       "525      MARCH-6080-1 : Placeholder: Integrated Studio                 NaN   \n",
       "\n",
       "    DeliveryMode InstructionalFormat  \\\n",
       "63        Online             Seminar   \n",
       "64        Online             Seminar   \n",
       "127       Online          Internship   \n",
       "142       Online              Studio   \n",
       "143       Online            Workshop   \n",
       "156       Online            Workshop   \n",
       "512       Online              Studio   \n",
       "513       Online              Studio   \n",
       "524       Online            Workshop   \n",
       "525       Online            Workshop   \n",
       "\n",
       "                                      Schedule  Units  Capacity  Enrolled  \\\n",
       "63                           Mon 12:00-03:00PM    3.0        36        24   \n",
       "64                            Fri 2:00-03:25PM    3.0        36         1   \n",
       "127                                        NaN    3.0        50         1   \n",
       "142                           Meeting Time TBD    6.0        50         1   \n",
       "143                           Meeting Time TBD    6.0        75         1   \n",
       "156   Meeting Time TBD | Mon/Thu 12:30-06:30PM    6.0        45         0   \n",
       "512                           Meeting Time TBD    6.0        50         0   \n",
       "513                      Mon/Thu 12:30-06:30PM    6.0        50         0   \n",
       "524                                        NaN    6.0        75         0   \n",
       "525                      Mon/Thu 12:30-06:30PM    6.0        50         0   \n",
       "\n",
       "    Status   StartDate     EndDate Co-LocatesWith  \\\n",
       "63    Open  2020-09-02  2020-12-15            NaN   \n",
       "64    Open  2021-01-25  2021-05-09            NaN   \n",
       "127   Open  2021-01-25  2021-05-09            NaN   \n",
       "142   Open  2021-01-25  2021-05-09            NaN   \n",
       "143   Open  2021-01-25  2021-05-09            NaN   \n",
       "156   Open  2020-09-02  2020-12-15            NaN   \n",
       "512   Open  2021-01-25  2021-05-09            NaN   \n",
       "513   Open  2020-09-02  2020-12-15            NaN   \n",
       "524   Open  2021-01-25  2021-05-09            NaN   \n",
       "525   Open  2020-09-02  2020-12-15            NaN   \n",
       "\n",
       "                                           Description  \n",
       "63   Online course sections will be delivered mostl...  \n",
       "64   Online course sections will be delivered mostl...  \n",
       "127                                                NaN  \n",
       "142  This course has two required components. Stude...  \n",
       "143  This course has two required components. Stude...  \n",
       "156  This studio focuses on the integration and dev...  \n",
       "512  This course has two required components. Stude...  \n",
       "513                                                NaN  \n",
       "524  This is a vertical studio combining undergradu...  \n",
       "525  This studio focuses on the integration and dev...  "
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Capacity']>30].head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "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>Id</th>\n",
       "      <th>Semester</th>\n",
       "      <th>AcademicLevel</th>\n",
       "      <th>Subject</th>\n",
       "      <th>Campus</th>\n",
       "      <th>Title</th>\n",
       "      <th>Instructors</th>\n",
       "      <th>DeliveryMode</th>\n",
       "      <th>InstructionalFormat</th>\n",
       "      <th>Schedule</th>\n",
       "      <th>Units</th>\n",
       "      <th>Capacity</th>\n",
       "      <th>Enrolled</th>\n",
       "      <th>Status</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>Co-LocatesWith</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-32606</td>\n",
       "      <td>Fall 2020</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Animation</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ANIMA-1000-1 : Animation 1</td>\n",
       "      <td>Andrew Lyndon</td>\n",
       "      <td>Online</td>\n",
       "      <td>Studio</td>\n",
       "      <td>Mon/Thu 4:00-07:00PM</td>\n",
       "      <td>3.0</td>\n",
       "      <td>18</td>\n",
       "      <td>16</td>\n",
       "      <td>Closed</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>2020-12-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online course sections will be delivered mostl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-32609</td>\n",
       "      <td>Fall 2020</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Animation</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ANIMA-1000-4 : Animation 1</td>\n",
       "      <td>Meg Bisineer</td>\n",
       "      <td>Online</td>\n",
       "      <td>Studio</td>\n",
       "      <td>Mon/Thu 4:00-07:00PM</td>\n",
       "      <td>3.0</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>Closed</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>2020-12-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online course sections will be delivered mostl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-32614</td>\n",
       "      <td>Fall 2020</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Animation</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ANIMA-2300-2 : Drawing for Animation</td>\n",
       "      <td>Christine Richard</td>\n",
       "      <td>Online</td>\n",
       "      <td>Studio</td>\n",
       "      <td>Tue/Fri 12:00-03:00PM</td>\n",
       "      <td>3.0</td>\n",
       "      <td>18</td>\n",
       "      <td>16</td>\n",
       "      <td>Open</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>2020-12-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online course sections will be delivered mostl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-32625</td>\n",
       "      <td>Fall 2020</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Animation</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ANIMA-3000-1 : 3D Computer Animation 1</td>\n",
       "      <td>Amy A Lu</td>\n",
       "      <td>Online</td>\n",
       "      <td>Studio</td>\n",
       "      <td>Wed 12:00-06:00PM</td>\n",
       "      <td>3.0</td>\n",
       "      <td>15</td>\n",
       "      <td>16</td>\n",
       "      <td>Closed</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>2020-12-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online course sections will be delivered mostl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-32627</td>\n",
       "      <td>Fall 2020</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Animation</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ANIMA-3040-1 : Sound for Animation</td>\n",
       "      <td>Daniel B Olmsted</td>\n",
       "      <td>Online</td>\n",
       "      <td>Studio</td>\n",
       "      <td>Tue/Fri 12:00-03:00PM</td>\n",
       "      <td>3.0</td>\n",
       "      <td>18</td>\n",
       "      <td>19</td>\n",
       "      <td>Closed</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>2020-12-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online course sections will be delivered mostl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-32634</td>\n",
       "      <td>Fall 2020</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Animation</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ANIMA-3400-1 : Character Design</td>\n",
       "      <td>Geefwee Boedoe</td>\n",
       "      <td>Online</td>\n",
       "      <td>Studio</td>\n",
       "      <td>Tue/Fri 12:00-03:00PM</td>\n",
       "      <td>3.0</td>\n",
       "      <td>18</td>\n",
       "      <td>17</td>\n",
       "      <td>Open</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>2020-12-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online course sections will be delivered mostl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-32639</td>\n",
       "      <td>Fall 2020</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Animation</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ANIMA-3600-1 : Media History: History of Anima...</td>\n",
       "      <td>Christoph M Steger</td>\n",
       "      <td>Online</td>\n",
       "      <td>Seminar</td>\n",
       "      <td>Mon 12:00-03:00PM</td>\n",
       "      <td>3.0</td>\n",
       "      <td>36</td>\n",
       "      <td>24</td>\n",
       "      <td>Open</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>2020-12-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online course sections will be delivered mostl...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   Id   Semester  AcademicLevel    Subject  \\\n",
       "0   COURSE_SECTION_DEFINITION-3-32606  Fall 2020  Undergraduate  Animation   \n",
       "6   COURSE_SECTION_DEFINITION-3-32609  Fall 2020  Undergraduate  Animation   \n",
       "20  COURSE_SECTION_DEFINITION-3-32614  Fall 2020  Undergraduate  Animation   \n",
       "35  COURSE_SECTION_DEFINITION-3-32625  Fall 2020  Undergraduate  Animation   \n",
       "39  COURSE_SECTION_DEFINITION-3-32627  Fall 2020  Undergraduate  Animation   \n",
       "54  COURSE_SECTION_DEFINITION-3-32634  Fall 2020  Undergraduate  Animation   \n",
       "63  COURSE_SECTION_DEFINITION-3-32639  Fall 2020  Undergraduate  Animation   \n",
       "\n",
       "   Campus                                              Title  \\\n",
       "0     TBD                         ANIMA-1000-1 : Animation 1   \n",
       "6     TBD                         ANIMA-1000-4 : Animation 1   \n",
       "20    TBD               ANIMA-2300-2 : Drawing for Animation   \n",
       "35    TBD             ANIMA-3000-1 : 3D Computer Animation 1   \n",
       "39    TBD                 ANIMA-3040-1 : Sound for Animation   \n",
       "54    TBD                    ANIMA-3400-1 : Character Design   \n",
       "63    TBD  ANIMA-3600-1 : Media History: History of Anima...   \n",
       "\n",
       "           Instructors DeliveryMode InstructionalFormat  \\\n",
       "0        Andrew Lyndon       Online              Studio   \n",
       "6         Meg Bisineer       Online              Studio   \n",
       "20   Christine Richard       Online              Studio   \n",
       "35            Amy A Lu       Online              Studio   \n",
       "39    Daniel B Olmsted       Online              Studio   \n",
       "54      Geefwee Boedoe       Online              Studio   \n",
       "63  Christoph M Steger       Online             Seminar   \n",
       "\n",
       "                 Schedule  Units  Capacity  Enrolled  Status   StartDate  \\\n",
       "0    Mon/Thu 4:00-07:00PM    3.0        18        16  Closed  2020-09-02   \n",
       "6    Mon/Thu 4:00-07:00PM    3.0        18        18  Closed  2020-09-02   \n",
       "20  Tue/Fri 12:00-03:00PM    3.0        18        16    Open  2020-09-02   \n",
       "35      Wed 12:00-06:00PM    3.0        15        16  Closed  2020-09-02   \n",
       "39  Tue/Fri 12:00-03:00PM    3.0        18        19  Closed  2020-09-02   \n",
       "54  Tue/Fri 12:00-03:00PM    3.0        18        17    Open  2020-09-02   \n",
       "63      Mon 12:00-03:00PM    3.0        36        24    Open  2020-09-02   \n",
       "\n",
       "       EndDate Co-LocatesWith  \\\n",
       "0   2020-12-15            NaN   \n",
       "6   2020-12-15            NaN   \n",
       "20  2020-12-15            NaN   \n",
       "35  2020-12-15            NaN   \n",
       "39  2020-12-15            NaN   \n",
       "54  2020-12-15            NaN   \n",
       "63  2020-12-15            NaN   \n",
       "\n",
       "                                          Description  \n",
       "0   Online course sections will be delivered mostl...  \n",
       "6   Online course sections will be delivered mostl...  \n",
       "20  Online course sections will be delivered mostl...  \n",
       "35  Online course sections will be delivered mostl...  \n",
       "39  Online course sections will be delivered mostl...  \n",
       "54  Online course sections will be delivered mostl...  \n",
       "63  Online course sections will be delivered mostl...  "
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Enrolled']>15].head(7)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "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>Id</th>\n",
       "      <th>Semester</th>\n",
       "      <th>AcademicLevel</th>\n",
       "      <th>Subject</th>\n",
       "      <th>Campus</th>\n",
       "      <th>Title</th>\n",
       "      <th>Instructors</th>\n",
       "      <th>DeliveryMode</th>\n",
       "      <th>InstructionalFormat</th>\n",
       "      <th>Schedule</th>\n",
       "      <th>Units</th>\n",
       "      <th>Capacity</th>\n",
       "      <th>Enrolled</th>\n",
       "      <th>Status</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>Co-LocatesWith</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>688</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-32846</td>\n",
       "      <td>Fall 2020</td>\n",
       "      <td>Graduate</td>\n",
       "      <td>Graduate Fine Arts</td>\n",
       "      <td>TBD</td>\n",
       "      <td>FINAR-6000-4 : Contemporary Art History &amp; Theo...</td>\n",
       "      <td>Monica Bravo | Ren Fiss | Genevieve Hyacinthe ...</td>\n",
       "      <td>Online</td>\n",
       "      <td>Lecture</td>\n",
       "      <td>Thu 12:00-02:00PM</td>\n",
       "      <td>3.0</td>\n",
       "      <td>60</td>\n",
       "      <td>36</td>\n",
       "      <td>Open</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>2020-12-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>This course is a series of lectures surveying ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>714</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-32858</td>\n",
       "      <td>Fall 2020</td>\n",
       "      <td>Graduate</td>\n",
       "      <td>Graduate Fine Arts</td>\n",
       "      <td>TBD</td>\n",
       "      <td>FINAR-6100-4 : Dialogues &amp; Practices 1 (lecture)</td>\n",
       "      <td>Jordan Kantor | Kota Ezawa | Sam Vernon</td>\n",
       "      <td>Online</td>\n",
       "      <td>Lecture</td>\n",
       "      <td>Wed 5:35-07:05PM</td>\n",
       "      <td>3.0</td>\n",
       "      <td>55</td>\n",
       "      <td>24</td>\n",
       "      <td>Open</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>2020-12-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>All first-semester MFA in Fine Arts students t...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    Id   Semester AcademicLevel  \\\n",
       "688  COURSE_SECTION_DEFINITION-3-32846  Fall 2020      Graduate   \n",
       "714  COURSE_SECTION_DEFINITION-3-32858  Fall 2020      Graduate   \n",
       "\n",
       "                Subject Campus  \\\n",
       "688  Graduate Fine Arts    TBD   \n",
       "714  Graduate Fine Arts    TBD   \n",
       "\n",
       "                                                 Title  \\\n",
       "688  FINAR-6000-4 : Contemporary Art History & Theo...   \n",
       "714   FINAR-6100-4 : Dialogues & Practices 1 (lecture)   \n",
       "\n",
       "                                           Instructors DeliveryMode  \\\n",
       "688  Monica Bravo | Ren Fiss | Genevieve Hyacinthe ...       Online   \n",
       "714            Jordan Kantor | Kota Ezawa | Sam Vernon       Online   \n",
       "\n",
       "    InstructionalFormat           Schedule  Units  Capacity  Enrolled Status  \\\n",
       "688             Lecture  Thu 12:00-02:00PM    3.0        60        36   Open   \n",
       "714             Lecture   Wed 5:35-07:05PM    3.0        55        24   Open   \n",
       "\n",
       "      StartDate     EndDate Co-LocatesWith  \\\n",
       "688  2020-09-02  2020-12-15            NaN   \n",
       "714  2020-09-02  2020-12-15            NaN   \n",
       "\n",
       "                                           Description  \n",
       "688  This course is a series of lectures surveying ...  \n",
       "714  All first-semester MFA in Fine Arts students t...  "
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#let's divide the data in terms of enrolled and capacity\n",
    "#most popular field\n",
    "df[(df['Capacity']>50) & (df['Enrolled']>20)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "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>Id</th>\n",
       "      <th>Semester</th>\n",
       "      <th>AcademicLevel</th>\n",
       "      <th>Subject</th>\n",
       "      <th>Campus</th>\n",
       "      <th>Title</th>\n",
       "      <th>Instructors</th>\n",
       "      <th>DeliveryMode</th>\n",
       "      <th>InstructionalFormat</th>\n",
       "      <th>Schedule</th>\n",
       "      <th>Units</th>\n",
       "      <th>Capacity</th>\n",
       "      <th>Enrolled</th>\n",
       "      <th>Status</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>Co-LocatesWith</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-33677</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Animation</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ANIMA-1000-1 : Animation 1</td>\n",
       "      <td>Christine Richard</td>\n",
       "      <td>Online</td>\n",
       "      <td>Studio</td>\n",
       "      <td>Wed/Fri 4:00-05:25PM, Online - FA-14</td>\n",
       "      <td>3.0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online course sections will be delivered mostl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-33678</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Animation</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ANIMA-1000-2 : Animation 1</td>\n",
       "      <td>Andrew Lyndon</td>\n",
       "      <td>Online</td>\n",
       "      <td>Studio</td>\n",
       "      <td>Wed/Fri 4:00-05:25PM, Online - FA-1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online course sections will be delivered mostl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-34479</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Animation</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ANIMA-1000-3 : Animation 1</td>\n",
       "      <td>Wallace Keller</td>\n",
       "      <td>Online</td>\n",
       "      <td>Studio</td>\n",
       "      <td>Fri 12:00-02:55PM</td>\n",
       "      <td>3.0</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online course sections will be delivered mostl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-33679</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Animation</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ANIMA-2000-1 : Animation 2</td>\n",
       "      <td>George Evelyn</td>\n",
       "      <td>Online</td>\n",
       "      <td>Studio</td>\n",
       "      <td>Mon/Thu 4:00-05:25PM, Online - FA-9</td>\n",
       "      <td>3.0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online course sections will be delivered mostl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-33680</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Animation</td>\n",
       "      <td>TBD</td>\n",
       "      <td>ANIMA-2000-2 : Animation 2</td>\n",
       "      <td>Amy A Lu</td>\n",
       "      <td>Online</td>\n",
       "      <td>Studio</td>\n",
       "      <td>Mon/Thu 8:00-09:25PM, Online - FA-4</td>\n",
       "      <td>3.0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online course sections will be delivered mostl...</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>1573</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-33611</td>\n",
       "      <td>Fall 2020</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Writing and Literature</td>\n",
       "      <td>TBD</td>\n",
       "      <td>WRLIT-3200-4 : Reading Octavia Butler</td>\n",
       "      <td>Hugh Behm-Steinberg</td>\n",
       "      <td>Online</td>\n",
       "      <td>Seminar</td>\n",
       "      <td>Fri 12:00-03:00PM, Online - HS-2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>Open</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>2020-12-15</td>\n",
       "      <td>LITPA-3000-8: Reading Octavia Butler</td>\n",
       "      <td>Required of students in Writing and Literature...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1574</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-34422</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Writing and Literature</td>\n",
       "      <td>TBD</td>\n",
       "      <td>WRLIT-3600-1 : MH: Literary Theory</td>\n",
       "      <td>Eric Olson</td>\n",
       "      <td>Online</td>\n",
       "      <td>Seminar</td>\n",
       "      <td>Wed 5:00-06:25PM</td>\n",
       "      <td>3.0</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Literary theory&amp;#39;s central concern is how w...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1575</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-34423</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Writing and Literature</td>\n",
       "      <td>TBD</td>\n",
       "      <td>WRLIT-3980-1 : Internship</td>\n",
       "      <td>Eric Olson</td>\n",
       "      <td>Online</td>\n",
       "      <td>Internship</td>\n",
       "      <td>Meeting Time TBD</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1576</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-34424</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Writing and Literature</td>\n",
       "      <td>TBD</td>\n",
       "      <td>WRLIT-4000-1 : L: Influences: Writers on Writi...</td>\n",
       "      <td>Anne F Shea</td>\n",
       "      <td>Online</td>\n",
       "      <td>Workshop</td>\n",
       "      <td>Wed 8:00-09:25AM, Online - HS-7</td>\n",
       "      <td>3.0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Who influenced you to first become a writer or...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1577</th>\n",
       "      <td>COURSE_SECTION_DEFINITION-3-34425</td>\n",
       "      <td>Spring 2021</td>\n",
       "      <td>Undergraduate</td>\n",
       "      <td>Writing and Literature</td>\n",
       "      <td>TBD</td>\n",
       "      <td>WRLIT-4080-1 : Senior Project: Thesis</td>\n",
       "      <td>Faith E Adiele</td>\n",
       "      <td>Online</td>\n",
       "      <td>Thesis</td>\n",
       "      <td>Thu 12:00-01:55PM, Online - HS-1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>Open</td>\n",
       "      <td>2021-01-25</td>\n",
       "      <td>2021-05-09</td>\n",
       "      <td>VISST-4040-1: Senior Project 2</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>890 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     Id     Semester  AcademicLevel  \\\n",
       "1     COURSE_SECTION_DEFINITION-3-33677  Spring 2021  Undergraduate   \n",
       "2     COURSE_SECTION_DEFINITION-3-33678  Spring 2021  Undergraduate   \n",
       "4     COURSE_SECTION_DEFINITION-3-34479  Spring 2021  Undergraduate   \n",
       "7     COURSE_SECTION_DEFINITION-3-33679  Spring 2021  Undergraduate   \n",
       "8     COURSE_SECTION_DEFINITION-3-33680  Spring 2021  Undergraduate   \n",
       "...                                 ...          ...            ...   \n",
       "1573  COURSE_SECTION_DEFINITION-3-33611    Fall 2020  Undergraduate   \n",
       "1574  COURSE_SECTION_DEFINITION-3-34422  Spring 2021  Undergraduate   \n",
       "1575  COURSE_SECTION_DEFINITION-3-34423  Spring 2021  Undergraduate   \n",
       "1576  COURSE_SECTION_DEFINITION-3-34424  Spring 2021  Undergraduate   \n",
       "1577  COURSE_SECTION_DEFINITION-3-34425  Spring 2021  Undergraduate   \n",
       "\n",
       "                     Subject Campus  \\\n",
       "1                  Animation    TBD   \n",
       "2                  Animation    TBD   \n",
       "4                  Animation    TBD   \n",
       "7                  Animation    TBD   \n",
       "8                  Animation    TBD   \n",
       "...                      ...    ...   \n",
       "1573  Writing and Literature    TBD   \n",
       "1574  Writing and Literature    TBD   \n",
       "1575  Writing and Literature    TBD   \n",
       "1576  Writing and Literature    TBD   \n",
       "1577  Writing and Literature    TBD   \n",
       "\n",
       "                                                  Title          Instructors  \\\n",
       "1                            ANIMA-1000-1 : Animation 1    Christine Richard   \n",
       "2                            ANIMA-1000-2 : Animation 1        Andrew Lyndon   \n",
       "4                            ANIMA-1000-3 : Animation 1       Wallace Keller   \n",
       "7                            ANIMA-2000-1 : Animation 2        George Evelyn   \n",
       "8                            ANIMA-2000-2 : Animation 2             Amy A Lu   \n",
       "...                                                 ...                  ...   \n",
       "1573              WRLIT-3200-4 : Reading Octavia Butler  Hugh Behm-Steinberg   \n",
       "1574                 WRLIT-3600-1 : MH: Literary Theory           Eric Olson   \n",
       "1575                          WRLIT-3980-1 : Internship           Eric Olson   \n",
       "1576  WRLIT-4000-1 : L: Influences: Writers on Writi...          Anne F Shea   \n",
       "1577              WRLIT-4080-1 : Senior Project: Thesis       Faith E Adiele   \n",
       "\n",
       "     DeliveryMode InstructionalFormat                              Schedule  \\\n",
       "1          Online              Studio  Wed/Fri 4:00-05:25PM, Online - FA-14   \n",
       "2          Online              Studio   Wed/Fri 4:00-05:25PM, Online - FA-1   \n",
       "4          Online              Studio                     Fri 12:00-02:55PM   \n",
       "7          Online              Studio   Mon/Thu 4:00-05:25PM, Online - FA-9   \n",
       "8          Online              Studio   Mon/Thu 8:00-09:25PM, Online - FA-4   \n",
       "...           ...                 ...                                   ...   \n",
       "1573       Online             Seminar      Fri 12:00-03:00PM, Online - HS-2   \n",
       "1574       Online             Seminar                      Wed 5:00-06:25PM   \n",
       "1575       Online          Internship                      Meeting Time TBD   \n",
       "1576       Online            Workshop       Wed 8:00-09:25AM, Online - HS-7   \n",
       "1577       Online              Thesis      Thu 12:00-01:55PM, Online - HS-1   \n",
       "\n",
       "      Units  Capacity  Enrolled Status   StartDate     EndDate  \\\n",
       "1       3.0        15         0   Open  2021-01-25  2021-05-09   \n",
       "2       3.0        18         0   Open  2021-01-25  2021-05-09   \n",
       "4       3.0        18         0   Open  2021-01-25  2021-05-09   \n",
       "7       3.0        15         0   Open  2021-01-25  2021-05-09   \n",
       "8       3.0        15         0   Open  2021-01-25  2021-05-09   \n",
       "...     ...       ...       ...    ...         ...         ...   \n",
       "1573    3.0         6         4   Open  2020-09-02  2020-12-15   \n",
       "1574    3.0        15         1   Open  2021-01-25  2021-05-09   \n",
       "1575    3.0         1         0   Open  2021-01-25  2021-05-09   \n",
       "1576    3.0        15         0   Open  2021-01-25  2021-05-09   \n",
       "1577    3.0        10         1   Open  2021-01-25  2021-05-09   \n",
       "\n",
       "                            Co-LocatesWith  \\\n",
       "1                                      NaN   \n",
       "2                                      NaN   \n",
       "4                                      NaN   \n",
       "7                                      NaN   \n",
       "8                                      NaN   \n",
       "...                                    ...   \n",
       "1573  LITPA-3000-8: Reading Octavia Butler   \n",
       "1574                                   NaN   \n",
       "1575                                   NaN   \n",
       "1576                                   NaN   \n",
       "1577        VISST-4040-1: Senior Project 2   \n",
       "\n",
       "                                            Description  \n",
       "1     Online course sections will be delivered mostl...  \n",
       "2     Online course sections will be delivered mostl...  \n",
       "4     Online course sections will be delivered mostl...  \n",
       "7     Online course sections will be delivered mostl...  \n",
       "8     Online course sections will be delivered mostl...  \n",
       "...                                                 ...  \n",
       "1573  Required of students in Writing and Literature...  \n",
       "1574  Literary theory&#39;s central concern is how w...  \n",
       "1575                                                NaN  \n",
       "1576  Who influenced you to first become a writer or...  \n",
       "1577                                                NaN  \n",
       "\n",
       "[890 rows x 18 columns]"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#not popular field\n",
    "df[df['Enrolled']<5]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# let's analyze the data through pivot table."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>mean</th>\n",
       "      <th>len</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>Enrolled</th>\n",
       "      <th>Enrolled</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Id</th>\n",
       "      <th>Capacity</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>COURSE_SECTION_DEFINITION-3-25574</th>\n",
       "      <th>15</th>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>COURSE_SECTION_DEFINITION-3-25592</th>\n",
       "      <th>15</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>COURSE_SECTION_DEFINITION-3-25602</th>\n",
       "      <th>17</th>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>COURSE_SECTION_DEFINITION-3-25605</th>\n",
       "      <th>12</th>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>COURSE_SECTION_DEFINITION-3-25608</th>\n",
       "      <th>12</th>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>COURSE_SECTION_DEFINITION-3-35073</th>\n",
       "      <th>12</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>COURSE_SECTION_DEFINITION-3-35074</th>\n",
       "      <th>12</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>COURSE_SECTION_DEFINITION-3-35079</th>\n",
       "      <th>12</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>COURSE_SECTION_DEFINITION-3-35080</th>\n",
       "      <th>12</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>COURSE_SECTION_DEFINITION-3-35081</th>\n",
       "      <th>10</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1579 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               mean      len\n",
       "                                           Enrolled Enrolled\n",
       "Id                                Capacity                  \n",
       "COURSE_SECTION_DEFINITION-3-25574 15              9        1\n",
       "COURSE_SECTION_DEFINITION-3-25592 15              4        1\n",
       "COURSE_SECTION_DEFINITION-3-25602 17             13        1\n",
       "COURSE_SECTION_DEFINITION-3-25605 12              6        1\n",
       "COURSE_SECTION_DEFINITION-3-25608 12              6        1\n",
       "...                                             ...      ...\n",
       "COURSE_SECTION_DEFINITION-3-35073 12              0        1\n",
       "COURSE_SECTION_DEFINITION-3-35074 12              0        1\n",
       "COURSE_SECTION_DEFINITION-3-35079 12              0        1\n",
       "COURSE_SECTION_DEFINITION-3-35080 12              0        1\n",
       "COURSE_SECTION_DEFINITION-3-35081 10              0        1\n",
       "\n",
       "[1579 rows x 2 columns]"
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#pivot table data\n",
    "pivot1=pd.pivot_table(df,index=['Id','Capacity'],values=['Enrolled'],aggfunc=[np.mean,len])\n",
    "pivot1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "MultiIndex([('COURSE_SECTION_DEFINITION-3-25574', 15),\n",
       "            ('COURSE_SECTION_DEFINITION-3-25592', 15),\n",
       "            ('COURSE_SECTION_DEFINITION-3-25602', 17),\n",
       "            ('COURSE_SECTION_DEFINITION-3-25605', 12),\n",
       "            ('COURSE_SECTION_DEFINITION-3-25608', 12),\n",
       "            ('COURSE_SECTION_DEFINITION-3-26018', 15),\n",
       "            ('COURSE_SECTION_DEFINITION-3-32480', 15),\n",
       "            ('COURSE_SECTION_DEFINITION-3-32511', 14),\n",
       "            ('COURSE_SECTION_DEFINITION-3-32606', 18),\n",
       "            ('COURSE_SECTION_DEFINITION-3-32607', 18),\n",
       "            ...\n",
       "            ('COURSE_SECTION_DEFINITION-3-35068', 16),\n",
       "            ('COURSE_SECTION_DEFINITION-3-35069',  0),\n",
       "            ('COURSE_SECTION_DEFINITION-3-35070',  0),\n",
       "            ('COURSE_SECTION_DEFINITION-3-35071',  0),\n",
       "            ('COURSE_SECTION_DEFINITION-3-35072',  0),\n",
       "            ('COURSE_SECTION_DEFINITION-3-35073', 12),\n",
       "            ('COURSE_SECTION_DEFINITION-3-35074', 12),\n",
       "            ('COURSE_SECTION_DEFINITION-3-35079', 12),\n",
       "            ('COURSE_SECTION_DEFINITION-3-35080', 12),\n",
       "            ('COURSE_SECTION_DEFINITION-3-35081', 10)],\n",
       "           names=['Id', 'Capacity'], length=1579)"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pivot1.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>mean</th>\n",
       "      <th>len</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>Enrolled</th>\n",
       "      <th>Enrolled</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Capacity</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             mean      len\n",
       "         Enrolled Enrolled\n",
       "Capacity                  \n",
       "12              6        1"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pivot1.loc['COURSE_SECTION_DEFINITION-3-25608']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}