Class-Visualizer.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# import urllib library\n",
    "from urllib.request import urlopen\n",
    "  \n",
    "# import json\n",
    "import json\n",
    "# store the URL in url as \n",
    "# parameter for urlopen\n",
    "url = \"https://classes.cornell.edu/api/2.0/search/classes.json?roster=SP23&subject=CS\" # get SP 22 CS classes\n",
    "  \n",
    "# store the response of URL\n",
    "response = urlopen(url)\n",
    "  \n",
    "# storing the JSON response \n",
    "# from url in data\n",
    "data_json = json.loads(response.read())\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "classes = data_json['data']['classes']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "url2 = 'https://classes.cornell.edu/api/2.0/config/subjects.json?roster=SP23'\n",
    "response2 = urlopen(url2)\n",
    "subjects_json = json.loads(response2.read())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "subject_list = []\n",
    "for i in subjects_json['data']['subjects']:\n",
    "    subject_list.append(i['value'])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "631\n",
      "{'strm': 2839, 'crseId': 365420, 'crseOfferNbr': 1, 'subject': 'ASRC', 'catalogNbr': '3508', 'titleShort': 'Afr Am Lit: 1930s- Present', 'titleLong': 'African American Literature: 1930s - Present', 'enrollGroups': [{'classSections': [{'ssrComponent': 'LEC', 'ssrComponentLong': 'Lecture', 'section': '001', 'classNbr': 18924, 'meetings': [], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'P', 'instrModeDescrshort': 'In Person', 'instrModeDescr': 'In Person', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 4, 'unitsMaximum': 4, 'componentsOptional': [], 'componentsRequired': ['LEC'], 'gradingBasis': 'GRD', 'gradingBasisShort': 'Graded', 'gradingBasisLong': 'Letter grades only', 'simpleCombinations': [{'subject': 'ENGL', 'catalogNbr': '3508', 'type': 'C'}], 'sessionCode': '1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Regular Academic Session', 'exploreCriteriaIds': []}], 'description': None, 'catalogBreadth': None, 'catalogDistr': None, 'catalogLang': None, 'catalogForbiddenOverlaps': None, 'catalogAttribute': None, 'catalogWhenOffered': None, 'catalogComments': None, 'catalogPrereqCoreq': None, 'catalogFee': None, 'catalogSatisfiesReq': None, 'catalogPermission': None, 'catalogCourseSubfield': None, 'catalogOutcomes': None, 'acadCareer': 'UG', 'acadGroup': 'AS', 'exploreCriteriaIds': []}\n",
      "\n",
      "\n",
      "list index out of range\n",
      "\n",
      "\n",
      "1222\n",
      "{'strm': 2839, 'crseId': 361873, 'crseOfferNbr': 1, 'subject': 'CRP', 'catalogNbr': '3072', 'titleShort': 'Land Use, Envir Plng, Urb wrks', 'titleLong': 'Land Use, Environmental Planning, and Urban Design Workshop', 'enrollGroups': [{'classSections': [{'ssrComponent': 'FLD', 'ssrComponentLong': 'Field Studies', 'section': '802', 'classNbr': 3189, 'meetings': [], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'P', 'instrModeDescrshort': 'In Person', 'instrModeDescr': 'In Person', 'topicDescription': 'Seneca Nation of Indians Planning Field Workshop', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 4, 'unitsMaximum': 4, 'componentsOptional': [], 'componentsRequired': ['FLD'], 'gradingBasis': 'GRD', 'gradingBasisShort': 'Graded', 'gradingBasisLong': 'Letter grades only', 'simpleCombinations': [], 'sessionCode': '1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Regular Academic Session', 'exploreCriteriaIds': []}], 'description': 'Land Use and Environmental Planning workshop courses focus on the forces and actions that directly affect the physical character, transformation, rehabilitation, and preservation of natural landscapes, cities, and regions. Participants provide technical assistance to communities, and have the opportunity to work with communities in resolving critical planning issues. Topics may include development of land use and natural conservation plans, community redevelopment plans,\\xa0design and analysis of public spaces,\\xa0and strategies for making communities more environmentally and economically sustainable.', 'catalogBreadth': '', 'catalogDistr': '', 'catalogLang': '', 'catalogForbiddenOverlaps': '', 'catalogAttribute': '(CU-CEL, CU-SBY)', 'catalogWhenOffered': 'Fall, Spring.', 'catalogComments': '', 'catalogPrereqCoreq': '', 'catalogFee': '', 'catalogSatisfiesReq': '', 'catalogPermission': '', 'catalogCourseSubfield': '', 'catalogOutcomes': None, 'acadCareer': 'UG', 'acadGroup': 'AR', 'exploreCriteriaIds': []}\n",
      "\n",
      "\n",
      "list index out of range\n",
      "\n",
      "\n",
      "1416\n",
      "{'strm': 2839, 'crseId': 371548, 'crseOfferNbr': 1, 'subject': 'DESIGN', 'catalogNbr': '4297', 'titleShort': 'Coding for Design II', 'titleLong': 'Coding for Design II', 'enrollGroups': [{'classSections': [{'ssrComponent': 'SEM', 'ssrComponentLong': 'Seminar', 'section': '101', 'classNbr': 3256, 'meetings': [], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'OL', 'instrModeDescrshort': 'OL', 'instrModeDescr': 'Online', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 3, 'unitsMaximum': 3, 'componentsOptional': [], 'componentsRequired': ['SEM'], 'gradingBasis': 'OPI', 'gradingBasisShort': 'Opt NoAud', 'gradingBasisLong': 'Letter or S/U grades (no audit)', 'simpleCombinations': [], 'sessionCode': '1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Regular Academic Session', 'exploreCriteriaIds': []}], 'description': \"This course addresses pertinent issues relative to the subject of design and coding. The instructor(s) of the course are drawn from the permanent and visiting faculty who may either broadly or narrowly define the course's scope and content.\", 'catalogBreadth': '', 'catalogDistr': '', 'catalogLang': '', 'catalogForbiddenOverlaps': '', 'catalogAttribute': '', 'catalogWhenOffered': 'Fall, Spring, Summer.', 'catalogComments': '', 'catalogPrereqCoreq': 'Prerequisite: second-year standing, or permission of instructor.', 'catalogFee': '', 'catalogSatisfiesReq': '', 'catalogPermission': '', 'catalogCourseSubfield': '', 'catalogOutcomes': None, 'acadCareer': 'UG', 'acadGroup': 'AR', 'exploreCriteriaIds': []}\n",
      "\n",
      "\n",
      "list index out of range\n",
      "\n",
      "\n",
      "1419\n",
      "{'strm': 2839, 'crseId': 371255, 'crseOfferNbr': 1, 'subject': 'DESIGN', 'catalogNbr': '6297', 'titleShort': 'Coding for Design III', 'titleLong': 'Coding for Design III', 'enrollGroups': [{'classSections': [{'ssrComponent': 'SEM', 'ssrComponentLong': 'Seminar', 'section': '101', 'classNbr': 3254, 'meetings': [], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'OL', 'instrModeDescrshort': 'OL', 'instrModeDescr': 'Online', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 3, 'unitsMaximum': 3, 'componentsOptional': [], 'componentsRequired': ['SEM'], 'gradingBasis': 'OPI', 'gradingBasisShort': 'Opt NoAud', 'gradingBasisLong': 'Letter or S/U grades (no audit)', 'simpleCombinations': [], 'sessionCode': '1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Regular Academic Session', 'exploreCriteriaIds': []}], 'description': \"This course addresses pertinent issues relative to the subject of design and coding. The instructor(s) of the course are drawn from the permanent and visiting faculty who may either broadly or narrowly define the course's scope and content.\", 'catalogBreadth': '', 'catalogDistr': '', 'catalogLang': '', 'catalogForbiddenOverlaps': '', 'catalogAttribute': '', 'catalogWhenOffered': 'Fall, Spring, Summer.', 'catalogComments': '', 'catalogPrereqCoreq': 'Prerequisite: Graduate student, or permission of instructor.', 'catalogFee': '', 'catalogSatisfiesReq': '', 'catalogPermission': '', 'catalogCourseSubfield': '', 'catalogOutcomes': None, 'acadCareer': 'GR', 'acadGroup': 'AR', 'exploreCriteriaIds': []}\n",
      "\n",
      "\n",
      "list index out of range\n",
      "\n",
      "\n",
      "1456\n",
      "{'strm': 2839, 'crseId': 367842, 'crseOfferNbr': 1, 'subject': 'EAS', 'catalogNbr': '5740', 'titleShort': 'Quant Data Anlys in Geosci', 'titleLong': 'Quantitative Data Analysis for the Geosciences', 'enrollGroups': [{'classSections': [{'ssrComponent': 'LEC', 'ssrComponentLong': 'Lecture', 'section': '001', 'classNbr': 10056, 'meetings': [], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'P', 'instrModeDescrshort': 'In Person', 'instrModeDescr': 'In Person', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 3, 'unitsMaximum': 3, 'componentsOptional': [], 'componentsRequired': ['LEC'], 'gradingBasis': 'OPT', 'gradingBasisShort': 'Stdnt Opt', 'gradingBasisLong': 'Letter or S/U grades', 'simpleCombinations': [], 'sessionCode': '1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Regular Academic Session', 'exploreCriteriaIds': []}], 'description': 'Geoscientists cannot perform controlled experiments, and they study processes that occur over time and distance scales that cannot fit into a laboratory, leading to unusual data analysis problems. This course first covers basic statistical methods for handling and treating noisy data of this sort, then parameter estimation from incomplete and noisy measurements, then basics of time series analysis. Examples include spatial, temporal, sequential and directional problems derived from climate science, seismology, sedimentology, structural geology, geochemistry and related fields.', 'catalogBreadth': '', 'catalogDistr': '', 'catalogLang': '', 'catalogForbiddenOverlaps': '', 'catalogAttribute': '', 'catalogWhenOffered': 'Spring.', 'catalogComments': 'Students enrolled in EAS 5740 will be required to complete additional work in the form of an in-class presentation.', 'catalogPrereqCoreq': 'Prerequisite: two semesters of calculus, and coursework in earth and atmospheric sciences at 3000-level or above. Recommended prerequisite: linear algebra.', 'catalogFee': '', 'catalogSatisfiesReq': '', 'catalogPermission': '', 'catalogCourseSubfield': '', 'catalogOutcomes': None, 'acadCareer': 'GR', 'acadGroup': 'EN', 'exploreCriteriaIds': []}\n",
      "\n",
      "\n",
      "list index out of range\n",
      "\n",
      "\n",
      "1639\n",
      "{'strm': 2839, 'crseId': 365420, 'crseOfferNbr': 2, 'subject': 'ENGL', 'catalogNbr': '3508', 'titleShort': 'Afr Am Lit: 1930s- Present', 'titleLong': 'African American Literature: 1930s - Present', 'enrollGroups': [{'classSections': [{'ssrComponent': 'LEC', 'ssrComponentLong': 'Lecture', 'section': '001', 'classNbr': 19148, 'meetings': [], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'P', 'instrModeDescrshort': 'In Person', 'instrModeDescr': 'In Person', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 4, 'unitsMaximum': 4, 'componentsOptional': [], 'componentsRequired': ['LEC'], 'gradingBasis': 'GRD', 'gradingBasisShort': 'Graded', 'gradingBasisLong': 'Letter grades only', 'simpleCombinations': [{'subject': 'ASRC', 'catalogNbr': '3508', 'type': 'C'}], 'sessionCode': '1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Regular Academic Session', 'exploreCriteriaIds': []}], 'description': None, 'catalogBreadth': None, 'catalogDistr': None, 'catalogLang': None, 'catalogForbiddenOverlaps': None, 'catalogAttribute': None, 'catalogWhenOffered': None, 'catalogComments': None, 'catalogPrereqCoreq': None, 'catalogFee': None, 'catalogSatisfiesReq': None, 'catalogPermission': None, 'catalogCourseSubfield': None, 'catalogOutcomes': None, 'acadCareer': 'UG', 'acadGroup': 'AS', 'exploreCriteriaIds': []}\n",
      "\n",
      "\n",
      "list index out of range\n",
      "\n",
      "\n",
      "1796\n",
      "{'strm': 2839, 'crseId': 354041, 'crseOfferNbr': 1, 'subject': 'FDSC', 'catalogNbr': '4250', 'titleShort': 'Conv Tech in Food Processing', 'titleLong': 'Conventional and Emerging Technologies in Food Processing', 'enrollGroups': [{'classSections': [{'ssrComponent': 'LEC', 'ssrComponentLong': 'Lecture', 'section': '001', 'classNbr': 1202, 'meetings': [], 'notes': [{'classNotesSeq': 1, 'descrlong': 'Prerequisite: 3210, 4180, 4230, or permission of instructor. Students enrolling in just the lecture (Lec 001) will receive 2 credits for the course.'}], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'P', 'instrModeDescrshort': 'In Person', 'instrModeDescr': 'In Person', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 2, 'unitsMaximum': 2, 'componentsOptional': [], 'componentsRequired': ['LEC'], 'gradingBasis': 'OPT', 'gradingBasisShort': 'Stdnt Opt', 'gradingBasisLong': 'Letter or S/U grades', 'simpleCombinations': [{'subject': 'FDSC', 'catalogNbr': '6250', 'type': 'B'}], 'sessionCode': '1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Regular Academic Session', 'exploreCriteriaIds': []}], 'description': 'This course is focused on discussing principles and practices fundamental to the processing and storage of foods, using both conventional and emerging food processing technologies. Material covered includes: i) emerging food processing technologies, ii) processing principles for animal products and plant based foods, iii) cleaning and disinfection ion food processing; and iv) byproduct &amp; waste handling and processing. The various concepts will be demonstrated with case studies from commercial processing.', 'catalogBreadth': '', 'catalogDistr': '', 'catalogLang': '', 'catalogForbiddenOverlaps': '', 'catalogAttribute': '', 'catalogWhenOffered': 'Spring.', 'catalogComments': '', 'catalogPrereqCoreq': 'Prerequisite: FDSC 4210\\xa0or permission of instructor.', 'catalogFee': '', 'catalogSatisfiesReq': '', 'catalogPermission': '', 'catalogCourseSubfield': '', 'catalogOutcomes': ['Discuss the principles behind conventional and emerging technologies.', 'Build and explain process flow diagrams and identify the processing equipment used to manufacture of a variety of animal and plant based food products.', 'Describe the unit operations and processing steps used in the processing of animal and plant based food products and waste streams foin food processing, their principles and underlying mechanisms of action.', 'Identify and discuss the critical parameters that affect the processing and quality of a variety of food products.', 'Communicate effectively on critical current issues related to food processing, including controversial issues.'], 'acadCareer': 'UG', 'acadGroup': 'AG', 'exploreCriteriaIds': []}\n",
      "\n",
      "\n",
      "list index out of range\n",
      "\n",
      "\n",
      "1807\n",
      "{'strm': 2839, 'crseId': 372323, 'crseOfferNbr': 1, 'subject': 'FDSC', 'catalogNbr': '5010', 'titleShort': 'Product Development', 'titleLong': 'Concepts of Food Product Development', 'enrollGroups': [{'classSections': [{'ssrComponent': 'LEC', 'ssrComponentLong': 'Lecture', 'section': '001', 'classNbr': 2468, 'meetings': [], 'notes': [{'classNotesSeq': 1, 'descrlong': 'Restricted to food science seniors and graduate students.'}], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'P', 'instrModeDescrshort': 'In Person', 'instrModeDescr': 'In Person', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 2, 'unitsMaximum': 2, 'componentsOptional': [], 'componentsRequired': ['LEC'], 'gradingBasis': 'GRD', 'gradingBasisShort': 'Graded', 'gradingBasisLong': 'Letter grades only', 'simpleCombinations': [], 'sessionCode': '1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Regular Academic Session', 'exploreCriteriaIds': []}], 'description': 'Introduction to topics and events sequence that provide the foundation for development of new food products, building upon knowledge acquired from other food science courses. The course allows students to integrate and apply basic concepts into case-based learning experiences to enhance professional skills, utilizing individual assessments and team-work assignments.', 'catalogBreadth': '', 'catalogDistr': '', 'catalogLang': '', 'catalogForbiddenOverlaps': '', 'catalogAttribute': '', 'catalogWhenOffered': 'Fall.', 'catalogComments': '', 'catalogPrereqCoreq': 'Prerequisite: FDSC 3940, FDSC 4170, and FDSC 4210\\xa0or permission of instructor.', 'catalogFee': '', 'catalogSatisfiesReq': '', 'catalogPermission': 'Enrollment limited to: graduate students.', 'catalogCourseSubfield': '', 'catalogOutcomes': ['Evaluate the complexities/intricacies governing the development of new and improved food products.', 'Apply food science and marketing principles to the food product development process.', 'Demonstrate awareness of the variety of product testing protocols available to evaluate food product quality and consumer acceptance.', 'Identify challenges associated with various sourcing ingredients, manufacturing venues and distribution channels and diverse consumer preferences and needs.', 'Effectively utilize synergistic team-work to solve problems, enhance critical thinking, include diverse viewpoints, and strengthen communication skills.', 'Identify and apply appropriate food regulations and safety measures to ensure the safety of new products.'], 'acadCareer': 'GR', 'acadGroup': 'AG', 'exploreCriteriaIds': []}\n",
      "\n",
      "\n",
      "list index out of range\n",
      "\n",
      "\n",
      "1817\n",
      "{'strm': 2839, 'crseId': 372330, 'crseOfferNbr': 1, 'subject': 'FDSC', 'catalogNbr': '6250', 'titleShort': 'Conv Tech in Food Processing', 'titleLong': 'Conventional and Emerging Technologies in Food Processing', 'enrollGroups': [{'classSections': [{'ssrComponent': 'LEC', 'ssrComponentLong': 'Lecture', 'section': '001', 'classNbr': 2470, 'meetings': [], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'P', 'instrModeDescrshort': 'In Person', 'instrModeDescr': 'In Person', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 2, 'unitsMaximum': 3, 'componentsOptional': [], 'componentsRequired': ['LEC'], 'gradingBasis': 'OPT', 'gradingBasisShort': 'Stdnt Opt', 'gradingBasisLong': 'Letter or S/U grades', 'simpleCombinations': [{'subject': 'FDSC', 'catalogNbr': '4250', 'type': 'B'}], 'sessionCode': '1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Regular Academic Session', 'exploreCriteriaIds': []}], 'description': 'This course is focused on discussing principles and practices fundamental to the processing and storage of foods, using both conventional and emerging food processing technologies. Material covered includes: i) emerging food processing technologies, ii) processing principles for animal products and plant based foods, iii) cleaning and disinfection ion food processing; and iv) byproduct &amp; waste handling and processing. The various concepts will be demonstrated with case studies from commercial processing.', 'catalogBreadth': '', 'catalogDistr': '', 'catalogLang': '', 'catalogForbiddenOverlaps': '', 'catalogAttribute': '', 'catalogWhenOffered': 'Spring.', 'catalogComments': '', 'catalogPrereqCoreq': 'Prerequisite: FDSC 4210\\xa0or permission of instructor.', 'catalogFee': '', 'catalogSatisfiesReq': '', 'catalogPermission': '', 'catalogCourseSubfield': '', 'catalogOutcomes': ['Discuss the principles behind conventional and emerging technologies.', 'Build and explain process flow diagrams and identify the processing equipment used to manufacture of a variety of animal and plant based food products.', 'Describe the unit operations and processing steps used in the processing of animal and plant based food products and waste streams foin food processing, their principles and underlying mechanisms of action.', 'Identify and discuss the critical parameters that affect the processing and quality of a variety of food products.', 'Communicate effectively on critical current issues related to food processing, including controversial issues.'], 'acadCareer': 'GR', 'acadGroup': 'AG', 'exploreCriteriaIds': []}\n",
      "\n",
      "\n",
      "list index out of range\n",
      "\n",
      "\n",
      "1819\n",
      "{'strm': 2839, 'crseId': 372214, 'crseOfferNbr': 1, 'subject': 'FDSC', 'catalogNbr': '6280', 'titleShort': 'Toxic Substances', 'titleLong': 'Toxic Substances in Food Systems', 'enrollGroups': [{'classSections': [{'ssrComponent': 'LEC', 'ssrComponentLong': 'Lecture', 'section': '001', 'classNbr': 2476, 'meetings': [], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'P', 'instrModeDescrshort': 'In Person', 'instrModeDescr': 'In Person', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 2, 'unitsMaximum': 2, 'componentsOptional': [], 'componentsRequired': ['LEC'], 'gradingBasis': 'GRD', 'gradingBasisShort': 'Graded', 'gradingBasisLong': 'Letter grades only', 'simpleCombinations': [], 'sessionCode': '1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Regular Academic Session', 'exploreCriteriaIds': []}], 'description': 'This course covers basic concepts in toxicology and discusses toxicological effects of substances (pesticides, herbicides, by-products of food processing, etc.) that can make their way into our food systems through environmental contamination, agricultural practices and food processing. Focus will be on substances that are harmful to human/animal health. This will be a 1.5 hr course, with the first half of lecture-based instruction on basic concepts of toxicology, impacts, regulations, and examples with different classifications of toxins/toxicants, their toxicological effects, mechanisms, and mitigation/prevention methods. In the second hour, a student will be asked to prepare and present a classic/recent toxicology case or issues followed by a moderated discussion on the same topic.', 'catalogBreadth': '', 'catalogDistr': '', 'catalogLang': '', 'catalogForbiddenOverlaps': '', 'catalogAttribute': '', 'catalogWhenOffered': 'Spring.', 'catalogComments': '', 'catalogPrereqCoreq': 'Prerequisite: BIOG 1140/BIOG 1440/BIOG 1500, and BIOMG 3300/BIOMG 3310\\xa0(or equivalent).', 'catalogFee': '', 'catalogSatisfiesReq': '', 'catalogPermission': '', 'catalogCourseSubfield': '', 'catalogOutcomes': ['Demonstrate a basic understanding of principles and key terminology used in toxicology.', 'Be able to list classic/recent examples of toxic substances reported in food systems and explain the effects and basic toxicological mechanisms.', \"Be able to explain the importance of 'dose' in toxicity assessments and obtain a general grasp of how risk assessments are done.\", 'Demonstrate understanding of the regulatory aspects of chemical food contamination/residues, and how regulations differ internationally, and the challenges they pose.', 'Be able to explain how risk perception can be affected by a variety of factors, and become a better evidence-based scientific communicator with the public in mind.', 'Critically evaluate, provide constructive criticism, and articulate informed opinions based on solid scientific evidence (peer-reviewed literature) in dealing with cases of toxicology.'], 'acadCareer': 'GR', 'acadGroup': 'AG', 'exploreCriteriaIds': []}\n",
      "\n",
      "\n",
      "list index out of range\n",
      "\n",
      "\n",
      "2846\n",
      "{'strm': 2839, 'crseId': 351012, 'crseOfferNbr': 1, 'subject': 'LSP', 'catalogNbr': '6210', 'titleShort': 'Grad Student Independent Study', 'titleLong': 'Graduate Student Independent Study', 'enrollGroups': [{'classSections': [{'ssrComponent': 'IND', 'ssrComponentLong': 'Independent Study', 'section': '601', 'classNbr': 4536, 'meetings': [], 'notes': [{'classNotesSeq': 1, 'descrlong': 'Guided independent study.'}], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'I', 'addConsentDescr': 'Instructor Consent Required', 'isComponentGraded': True, 'instructionMode': 'IS', 'instrModeDescrshort': 'Indp Stds', 'instrModeDescr': 'Independent Studies', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 2, 'unitsMaximum': 4, 'componentsOptional': [], 'componentsRequired': ['IND'], 'gradingBasis': 'OPT', 'gradingBasisShort': 'Stdnt Opt', 'gradingBasisLong': 'Letter or S/U grades', 'simpleCombinations': [], 'sessionCode': '1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Regular Academic Session', 'exploreCriteriaIds': []}, {'classSections': [{'ssrComponent': 'IND', 'ssrComponentLong': 'Independent Study', 'section': '607', 'classNbr': 4812, 'meetings': [{'classMtgNbr': 1, 'timeStart': '', 'timeEnd': '', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'instructors': [{'instrAssignSeq': 5, 'netid': 'sig35', 'firstName': 'Sergio', 'middleName': 'I', 'lastName': 'Garcia-Rios'}], 'pattern': '', 'facilityDescr': None, 'bldgDescr': None, 'facilityDescrshort': None, 'meetingTopicDescription': ''}], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'I', 'addConsentDescr': 'Instructor Consent Required', 'isComponentGraded': True, 'instructionMode': 'IS', 'instrModeDescrshort': 'Indp Stds', 'instrModeDescr': 'Independent Studies', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 2, 'unitsMaximum': 4, 'componentsOptional': [], 'componentsRequired': ['IND'], 'gradingBasis': 'OPT', 'gradingBasisShort': 'Stdnt Opt', 'gradingBasisLong': 'Letter or S/U grades', 'simpleCombinations': [], 'sessionCode': '1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Regular Academic Session', 'exploreCriteriaIds': []}, {'classSections': [{'ssrComponent': 'IND', 'ssrComponentLong': 'Independent Study', 'section': '611', 'classNbr': 4998, 'meetings': [{'classMtgNbr': 1, 'timeStart': '', 'timeEnd': '', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'instructors': [{'instrAssignSeq': 1, 'netid': 'dac9', 'firstName': 'Debra', 'middleName': 'Ann', 'lastName': 'Castillo'}], 'pattern': '', 'facilityDescr': None, 'bldgDescr': None, 'facilityDescrshort': None, 'meetingTopicDescription': ''}], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'I', 'addConsentDescr': 'Instructor Consent Required', 'isComponentGraded': True, 'instructionMode': 'IS', 'instrModeDescrshort': 'Indp Stds', 'instrModeDescr': 'Independent Studies', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 2, 'unitsMaximum': 4, 'componentsOptional': [], 'componentsRequired': ['IND'], 'gradingBasis': 'OPT', 'gradingBasisShort': 'Stdnt Opt', 'gradingBasisLong': 'Letter or S/U grades', 'simpleCombinations': [], 'sessionCode': '1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Regular Academic Session', 'exploreCriteriaIds': []}], 'description': 'Guided independent study.', 'catalogBreadth': '', 'catalogDistr': '', 'catalogLang': '', 'catalogForbiddenOverlaps': '', 'catalogAttribute': '', 'catalogWhenOffered': 'Fall, Spring.', 'catalogComments': '', 'catalogPrereqCoreq': '', 'catalogFee': '', 'catalogSatisfiesReq': '', 'catalogPermission': '', 'catalogCourseSubfield': '', 'catalogOutcomes': None, 'acadCareer': 'GR', 'acadGroup': 'AS', 'exploreCriteriaIds': []}\n",
      "\n",
      "\n",
      "list index out of range\n",
      "\n",
      "\n",
      "3316\n",
      "{'strm': 2839, 'crseId': 362651, 'crseOfferNbr': 1, 'subject': 'NS', 'catalogNbr': '3600', 'titleShort': 'Epidemiology', 'titleLong': 'Epidemiology', 'enrollGroups': [{'classSections': [{'ssrComponent': 'LEC', 'ssrComponentLong': 'Lecture', 'section': '001', 'classNbr': 10888, 'meetings': [], 'notes': [{'classNotesSeq': 1, 'descrlong': 'Required prerequisite: STSCI 2150. Global Public Health Sciences majors may open enroll, all others please add yourself to the online waitlist in Student Center.'}], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'D', 'addConsentDescr': 'Department Consent Required', 'isComponentGraded': True, 'instructionMode': 'P', 'instrModeDescrshort': 'In Person', 'instrModeDescr': 'In Person', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 3, 'unitsMaximum': 3, 'componentsOptional': [], 'componentsRequired': ['LEC'], 'gradingBasis': 'GRD', 'gradingBasisShort': 'Graded', 'gradingBasisLong': 'Letter grades only', 'simpleCombinations': [], 'sessionCode': '1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Regular Academic Session', 'exploreCriteriaIds': []}], 'description': 'This course introduces the principles and methods used in epidemiologic research. NS 3600 will use a combination of didactic lectures, classroom discussions, applied projects, and in-depth case studies to explore epidemiologic research, including disease occurrence, measures of association, causal inference in quantitative research, and applications of epidemiologic methods to global and public health research. Epidemiologic principles in the design, conduct, and interpretation of findings from observational and experimental studies will be explored in detail, including strengths and limitations of study designs. The final project of the course will require integration of methodological concepts with applications to develop a scientific question and design an epidemiologic research study to address a threat to public and global health.', 'catalogBreadth': '', 'catalogDistr': '', 'catalogLang': '', 'catalogForbiddenOverlaps': '', 'catalogAttribute': '', 'catalogWhenOffered': 'Spring.', 'catalogComments': '', 'catalogPrereqCoreq': 'Prerequisite: STSCI 2150.\\xa0', 'catalogFee': '', 'catalogSatisfiesReq': '', 'catalogPermission': '', 'catalogCourseSubfield': '', 'catalogOutcomes': ['To understand the basic principles and methods used in epidemiology research.', 'To evaluate the scientific literature, with emphasis on epidemiologic studies, including interpretation of findings and critical examination of strengths and limitations of different study designs.', 'To apply methodological concepts to develop a scientific question and design an epidemiologic research study to address a threat to public and global health.'], 'acadCareer': 'UG', 'acadGroup': 'HE', 'exploreCriteriaIds': []}\n",
      "\n",
      "\n",
      "list index out of range\n",
      "\n",
      "\n",
      "3385\n",
      "{'strm': 2839, 'crseId': 353190, 'crseOfferNbr': 1, 'subject': 'ORIE', 'catalogNbr': '4990', 'titleShort': 'Teaching in ORIE', 'titleLong': 'Teaching in ORIE', 'enrollGroups': [{'classSections': [{'ssrComponent': 'IND', 'ssrComponentLong': 'Independent Study', 'section': '601', 'classNbr': 12699, 'meetings': [], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'IS', 'instrModeDescrshort': 'Indp Stds', 'instrModeDescr': 'Independent Studies', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 1, 'unitsMaximum': 4, 'componentsOptional': [], 'componentsRequired': ['IND'], 'gradingBasis': 'OPT', 'gradingBasisShort': 'Stdnt Opt', 'gradingBasisLong': 'Letter or S/U grades', 'simpleCombinations': [], 'sessionCode': 'PR1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Project Session Full', 'exploreCriteriaIds': []}, {'classSections': [{'ssrComponent': 'IND', 'ssrComponentLong': 'Independent Study', 'section': '602', 'classNbr': 13269, 'meetings': [{'classMtgNbr': 1, 'timeStart': '', 'timeEnd': '', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'instructors': [{'instrAssignSeq': 1, 'netid': 'dsd95', 'firstName': 'Damek', 'middleName': 'Shea', 'lastName': 'Davis'}], 'pattern': '', 'facilityDescr': None, 'bldgDescr': None, 'facilityDescrshort': None, 'meetingTopicDescription': ''}], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'IS', 'instrModeDescrshort': 'Indp Stds', 'instrModeDescr': 'Independent Studies', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 1, 'unitsMaximum': 4, 'componentsOptional': [], 'componentsRequired': ['IND'], 'gradingBasis': 'OPT', 'gradingBasisShort': 'Stdnt Opt', 'gradingBasisLong': 'Letter or S/U grades', 'simpleCombinations': [], 'sessionCode': 'PR1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Project Session Full', 'exploreCriteriaIds': []}, {'classSections': [{'ssrComponent': 'IND', 'ssrComponentLong': 'Independent Study', 'section': '603', 'classNbr': 13270, 'meetings': [{'classMtgNbr': 1, 'timeStart': '', 'timeEnd': '', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'instructors': [{'instrAssignSeq': 1, 'netid': 'pf98', 'firstName': 'Peter', 'middleName': '', 'lastName': 'Frazier'}], 'pattern': '', 'facilityDescr': None, 'bldgDescr': None, 'facilityDescrshort': None, 'meetingTopicDescription': ''}], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'IS', 'instrModeDescrshort': 'Indp Stds', 'instrModeDescr': 'Independent Studies', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 1, 'unitsMaximum': 4, 'componentsOptional': [], 'componentsRequired': ['IND'], 'gradingBasis': 'OPT', 'gradingBasisShort': 'Stdnt Opt', 'gradingBasisLong': 'Letter or S/U grades', 'simpleCombinations': [], 'sessionCode': 'PR1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Project Session Full', 'exploreCriteriaIds': []}, {'classSections': [{'ssrComponent': 'IND', 'ssrComponentLong': 'Independent Study', 'section': '604', 'classNbr': 13271, 'meetings': [{'classMtgNbr': 1, 'timeStart': '', 'timeEnd': '', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'instructors': [{'instrAssignSeq': 1, 'netid': 'dw36', 'firstName': 'David', 'middleName': 'P.', 'lastName': 'Williamson'}], 'pattern': '', 'facilityDescr': None, 'bldgDescr': None, 'facilityDescrshort': None, 'meetingTopicDescription': ''}], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'IS', 'instrModeDescrshort': 'Indp Stds', 'instrModeDescr': 'Independent Studies', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 1, 'unitsMaximum': 4, 'componentsOptional': [], 'componentsRequired': ['IND'], 'gradingBasis': 'OPT', 'gradingBasisShort': 'Stdnt Opt', 'gradingBasisLong': 'Letter or S/U grades', 'simpleCombinations': [], 'sessionCode': 'PR1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Project Session Full', 'exploreCriteriaIds': []}, {'classSections': [{'ssrComponent': 'IND', 'ssrComponentLong': 'Independent Study', 'section': '605', 'classNbr': 13272, 'meetings': [{'classMtgNbr': 1, 'timeStart': '', 'timeEnd': '', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'instructors': [{'instrAssignSeq': 1, 'netid': 'gs18', 'firstName': 'Gennady', 'middleName': '', 'lastName': 'Samorodnitsky'}], 'pattern': '', 'facilityDescr': None, 'bldgDescr': None, 'facilityDescrshort': None, 'meetingTopicDescription': ''}], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'IS', 'instrModeDescrshort': 'Indp Stds', 'instrModeDescr': 'Independent Studies', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 1, 'unitsMaximum': 4, 'componentsOptional': [], 'componentsRequired': ['IND'], 'gradingBasis': 'OPT', 'gradingBasisShort': 'Stdnt Opt', 'gradingBasisLong': 'Letter or S/U grades', 'simpleCombinations': [], 'sessionCode': 'PR1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Project Session Full', 'exploreCriteriaIds': []}, {'classSections': [{'ssrComponent': 'IND', 'ssrComponentLong': 'Independent Study', 'section': '606', 'classNbr': 13291, 'meetings': [{'classMtgNbr': 1, 'timeStart': '', 'timeEnd': '', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'instructors': [{'instrAssignSeq': 1, 'netid': 'jc62', 'firstName': 'John Richard', 'middleName': '', 'lastName': 'Callister'}], 'pattern': '', 'facilityDescr': None, 'bldgDescr': None, 'facilityDescrshort': None, 'meetingTopicDescription': ''}], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'IS', 'instrModeDescrshort': 'Indp Stds', 'instrModeDescr': 'Independent Studies', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 1, 'unitsMaximum': 4, 'componentsOptional': [], 'componentsRequired': ['IND'], 'gradingBasis': 'OPT', 'gradingBasisShort': 'Stdnt Opt', 'gradingBasisLong': 'Letter or S/U grades', 'simpleCombinations': [], 'sessionCode': 'PR1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Project Session Full', 'exploreCriteriaIds': []}, {'classSections': [{'ssrComponent': 'IND', 'ssrComponentLong': 'Independent Study', 'section': '607', 'classNbr': 13316, 'meetings': [{'classMtgNbr': 1, 'timeStart': '', 'timeEnd': '', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'instructors': [{'instrAssignSeq': 2, 'netid': 'jjp274', 'firstName': 'Jamol', 'middleName': 'J', 'lastName': 'Pender'}], 'pattern': '', 'facilityDescr': None, 'bldgDescr': None, 'facilityDescrshort': None, 'meetingTopicDescription': ''}], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'IS', 'instrModeDescrshort': 'Indp Stds', 'instrModeDescr': 'Independent Studies', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 1, 'unitsMaximum': 4, 'componentsOptional': [], 'componentsRequired': ['IND'], 'gradingBasis': 'OPT', 'gradingBasisShort': 'Stdnt Opt', 'gradingBasisLong': 'Letter or S/U grades', 'simpleCombinations': [], 'sessionCode': 'PR1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Project Session Full', 'exploreCriteriaIds': []}, {'classSections': [{'ssrComponent': 'IND', 'ssrComponentLong': 'Independent Study', 'section': '609', 'classNbr': 13318, 'meetings': [{'classMtgNbr': 1, 'timeStart': '', 'timeEnd': '', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'instructors': [{'instrAssignSeq': 1, 'netid': 'fms9', 'firstName': 'Frans', 'middleName': '', 'lastName': 'Schalekamp'}], 'pattern': '', 'facilityDescr': None, 'bldgDescr': None, 'facilityDescrshort': None, 'meetingTopicDescription': ''}], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'IS', 'instrModeDescrshort': 'Indp Stds', 'instrModeDescr': 'Independent Studies', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 1, 'unitsMaximum': 4, 'componentsOptional': [], 'componentsRequired': ['IND'], 'gradingBasis': 'OPT', 'gradingBasisShort': 'Stdnt Opt', 'gradingBasisLong': 'Letter or S/U grades', 'simpleCombinations': [], 'sessionCode': 'PR1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Project Session Full', 'exploreCriteriaIds': []}, {'classSections': [{'ssrComponent': 'IND', 'ssrComponentLong': 'Independent Study', 'section': '610', 'classNbr': 13319, 'meetings': [{'classMtgNbr': 1, 'timeStart': '', 'timeEnd': '', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'instructors': [{'instrAssignSeq': 2, 'netid': 'jd694', 'firstName': 'Jim', 'middleName': '', 'lastName': 'Dai'}], 'pattern': '', 'facilityDescr': None, 'bldgDescr': None, 'facilityDescrshort': None, 'meetingTopicDescription': ''}], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'IS', 'instrModeDescrshort': 'Indp Stds', 'instrModeDescr': 'Independent Studies', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 1, 'unitsMaximum': 4, 'componentsOptional': [], 'componentsRequired': ['IND'], 'gradingBasis': 'OPT', 'gradingBasisShort': 'Stdnt Opt', 'gradingBasisLong': 'Letter or S/U grades', 'simpleCombinations': [], 'sessionCode': 'PR1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Project Session Full', 'exploreCriteriaIds': []}, {'classSections': [{'ssrComponent': 'IND', 'ssrComponentLong': 'Independent Study', 'section': '611', 'classNbr': 13320, 'meetings': [{'classMtgNbr': 1, 'timeStart': '', 'timeEnd': '', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'instructors': [{'instrAssignSeq': 2, 'netid': 'kec4', 'firstName': 'Kathryn', 'middleName': 'Elizabeth', 'lastName': 'Caggiano'}], 'pattern': '', 'facilityDescr': None, 'bldgDescr': None, 'facilityDescrshort': None, 'meetingTopicDescription': ''}], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'IS', 'instrModeDescrshort': 'Indp Stds', 'instrModeDescr': 'Independent Studies', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 1, 'unitsMaximum': 4, 'componentsOptional': [], 'componentsRequired': ['IND'], 'gradingBasis': 'OPT', 'gradingBasisShort': 'Stdnt Opt', 'gradingBasisLong': 'Letter or S/U grades', 'simpleCombinations': [], 'sessionCode': 'PR1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Project Session Full', 'exploreCriteriaIds': []}, {'classSections': [{'ssrComponent': 'IND', 'ssrComponentLong': 'Independent Study', 'section': '612', 'classNbr': 13351, 'meetings': [{'classMtgNbr': 1, 'timeStart': '', 'timeEnd': '', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'instructors': [{'instrAssignSeq': 2, 'netid': 'cel85', 'firstName': 'Christina', 'middleName': 'Lee', 'lastName': 'Yu'}], 'pattern': '', 'facilityDescr': None, 'bldgDescr': None, 'facilityDescrshort': None, 'meetingTopicDescription': ''}], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'IS', 'instrModeDescrshort': 'Indp Stds', 'instrModeDescr': 'Independent Studies', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 1, 'unitsMaximum': 4, 'componentsOptional': [], 'componentsRequired': ['IND'], 'gradingBasis': 'OPT', 'gradingBasisShort': 'Stdnt Opt', 'gradingBasisLong': 'Letter or S/U grades', 'simpleCombinations': [], 'sessionCode': 'PR1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Project Session Full', 'exploreCriteriaIds': []}, {'classSections': [{'ssrComponent': 'IND', 'ssrComponentLong': 'Independent Study', 'section': '613', 'classNbr': 15858, 'meetings': [{'classMtgNbr': 1, 'timeStart': '', 'timeEnd': '', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'instructors': [{'instrAssignSeq': 1, 'netid': 'elg46', 'firstName': 'Eric', 'middleName': 'Lewis', 'lastName': 'Gentsch'}], 'pattern': '', 'facilityDescr': 'To Be Assigned', 'bldgDescr': None, 'facilityDescrshort': 'TBA', 'meetingTopicDescription': ''}], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'IS', 'instrModeDescrshort': 'Indp Stds', 'instrModeDescr': 'Independent Studies', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 1, 'unitsMaximum': 4, 'componentsOptional': [], 'componentsRequired': ['IND'], 'gradingBasis': 'OPT', 'gradingBasisShort': 'Stdnt Opt', 'gradingBasisLong': 'Letter or S/U grades', 'simpleCombinations': [], 'sessionCode': 'PR1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Project Session Full', 'exploreCriteriaIds': []}, {'classSections': [{'ssrComponent': 'IND', 'ssrComponentLong': 'Independent Study', 'section': '614', 'classNbr': 16268, 'meetings': [{'classMtgNbr': 1, 'timeStart': '', 'timeEnd': '', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'instructors': [{'instrAssignSeq': 1, 'netid': 'ong5', 'firstName': 'Oktay', 'middleName': 'N.', 'lastName': 'Gunluk'}], 'pattern': '', 'facilityDescr': None, 'bldgDescr': None, 'facilityDescrshort': None, 'meetingTopicDescription': ''}], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'P', 'instrModeDescrshort': 'In Person', 'instrModeDescr': 'In Person', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 1, 'unitsMaximum': 4, 'componentsOptional': [], 'componentsRequired': ['IND'], 'gradingBasis': 'OPT', 'gradingBasisShort': 'Stdnt Opt', 'gradingBasisLong': 'Letter or S/U grades', 'simpleCombinations': [], 'sessionCode': 'PR1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Project Session Full', 'exploreCriteriaIds': []}], 'description': 'Involves working as a TA in an ORIE course. The instructor assigns credits (the guideline is 1 credit per four hours per week of work with a limit of 3 credits).', 'catalogBreadth': '', 'catalogDistr': '', 'catalogLang': '', 'catalogForbiddenOverlaps': '', 'catalogAttribute': '(CU-UGR)', 'catalogWhenOffered': 'Fall, Spring.', 'catalogComments': '', 'catalogPrereqCoreq': '', 'catalogFee': '', 'catalogSatisfiesReq': '', 'catalogPermission': '', 'catalogCourseSubfield': '', 'catalogOutcomes': None, 'acadCareer': 'UG', 'acadGroup': 'EN', 'exploreCriteriaIds': []}\n",
      "\n",
      "\n",
      "list index out of range\n",
      "\n",
      "\n",
      "3420\n",
      "{'strm': 2839, 'crseId': 372477, 'crseOfferNbr': 1, 'subject': 'PADM', 'catalogNbr': '4717', 'titleShort': 'Energy Transition', 'titleLong': 'Energy Transition: Policy, Financial, and Business Interactions', 'enrollGroups': [{'classSections': [{'ssrComponent': 'LEC', 'ssrComponentLong': 'Lecture', 'section': '001', 'classNbr': 19205, 'meetings': [], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'P', 'instrModeDescrshort': 'In Person', 'instrModeDescr': 'In Person', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 3, 'unitsMaximum': 3, 'componentsOptional': [], 'componentsRequired': ['LEC'], 'gradingBasis': 'GRD', 'gradingBasisShort': 'Graded', 'gradingBasisLong': 'Letter grades only', 'simpleCombinations': [{'subject': 'PAM', 'catalogNbr': '4717', 'type': 'C'}], 'sessionCode': '1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Regular Academic Session', 'exploreCriteriaIds': []}], 'description': 'The course utilizes discussions, presentations, research papers, and simulations to explore the policy, financial, and business implications, opportunities, and risks, of climate change, specifically the energy transition to a low-carbon economy. We will explore potential public policies in the context of their business impacts, effectiveness, and political viability. How does different policy design encourage distinct long-term pathways within a highly capital-intensive industry? What industries are most impacted by a transition to a lower carbon economy? How do incentives and structures influence business actors toward a smoother transition, or toward wasted capital expenditures, and stranded assets? Are financial markets pricing in an energy transition? What is the role of financial and market regulators in ensuring long-term \"beneficial\" capital allocation? With an industry in decline, what are the business strategy options for management of a fossil fuel producer? What are the policy, financial, and business implications for clean energy firms, electric vehicle manufacturers, and the metals and mining industry? Additional readings, research, and presentations are required of Master\\'s students.', 'catalogBreadth': '', 'catalogDistr': '(SBA-HE)', 'catalogLang': '', 'catalogForbiddenOverlaps': '', 'catalogAttribute': '(CU-SBY)', 'catalogWhenOffered': 'Spring.', 'catalogComments': '', 'catalogPrereqCoreq': 'Prerequisite: Intermediate Microeconomics (PADM 5210,\\xa0ECON 3030, or equivalent).', 'catalogFee': '', 'catalogSatisfiesReq': '', 'catalogPermission': '', 'catalogCourseSubfield': '', 'catalogOutcomes': ['Students will describe potential impacts of the energy transition and related public policy interactions on business outcomes.', \"Students will explain why market actors' incentives and other structural impediments can impede an effective and smooth transition and may also result in stranded assets and destruction of shareholder value.\", 'Students will examine financial and strategic approaches in assessing transition risk, and investor and management decisions-making in a carbon-constrained global economy.', 'Students will explain the catalysts driving the speed and magnitude of the energy transition.'], 'acadCareer': 'UG', 'acadGroup': 'HE', 'exploreCriteriaIds': []}\n",
      "\n",
      "\n",
      "list index out of range\n",
      "\n",
      "\n",
      "3493\n",
      "{'strm': 2839, 'crseId': 372477, 'crseOfferNbr': 2, 'subject': 'PAM', 'catalogNbr': '4717', 'titleShort': 'Energy Transition', 'titleLong': 'Energy Transition: Policy, Financial, and Business Interactions', 'enrollGroups': [{'classSections': [{'ssrComponent': 'LEC', 'ssrComponentLong': 'Lecture', 'section': '001', 'classNbr': 18741, 'meetings': [], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'P', 'instrModeDescrshort': 'In Person', 'instrModeDescr': 'In Person', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 3, 'unitsMaximum': 3, 'componentsOptional': [], 'componentsRequired': ['LEC'], 'gradingBasis': 'GRD', 'gradingBasisShort': 'Graded', 'gradingBasisLong': 'Letter grades only', 'simpleCombinations': [{'subject': 'PADM', 'catalogNbr': '4717', 'type': 'C'}], 'sessionCode': '1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Regular Academic Session', 'exploreCriteriaIds': []}], 'description': 'The course utilizes discussions, presentations, research papers, and simulations to explore the policy, financial, and business implications, opportunities, and risks, of climate change, specifically the energy transition to a low-carbon economy. We will explore potential public policies in the context of their business impacts, effectiveness, and political viability. How does different policy design encourage distinct long-term pathways within a highly capital-intensive industry? What industries are most impacted by a transition to a lower carbon economy? How do incentives and structures influence business actors toward a smoother transition, or toward wasted capital expenditures, and stranded assets? Are financial markets pricing in an energy transition? What is the role of financial and market regulators in ensuring long-term \"beneficial\" capital allocation? With an industry in decline, what are the business strategy options for management of a fossil fuel producer? What are the policy, financial, and business implications for clean energy firms, electric vehicle manufacturers, and the metals and mining industry? Additional readings, research, and presentations are required of Master\\'s students.', 'catalogBreadth': '', 'catalogDistr': '(SBA-HE) (CU-SBY)', 'catalogLang': '', 'catalogForbiddenOverlaps': '', 'catalogAttribute': '', 'catalogWhenOffered': 'Spring.', 'catalogComments': '', 'catalogPrereqCoreq': '', 'catalogFee': '', 'catalogSatisfiesReq': '', 'catalogPermission': '', 'catalogCourseSubfield': '', 'catalogOutcomes': ['Students will describe potential impacts of the energy transition and related public policy interactions on business outcomes.', \"Students will explain why market actors' incentives and other structural impediments can impede an effective and smooth transition and may also result in stranded assets and destruction of shareholder value.\", 'Students will examine financial and strategic approaches in assessing transition risk, and investor and management decisions-making in a carbon-constrained global economy.', 'Students will explain the catalysts driving the speed and magnitude of the energy transition.'], 'acadCareer': 'UG', 'acadGroup': 'HE', 'exploreCriteriaIds': []}\n",
      "\n",
      "\n",
      "list index out of range\n",
      "\n",
      "\n",
      "3797\n",
      "{'strm': 2839, 'crseId': 370582, 'crseOfferNbr': 1, 'subject': 'PLBIO', 'catalogNbr': '5431', 'titleShort': 'LabMolec Bio&Gen Eng of Plants', 'titleLong': 'Laboratory in Molecular Biology and Genetic Engineering of Plants', 'enrollGroups': [{'classSections': [{'ssrComponent': 'LAB', 'ssrComponentLong': 'Laboratory', 'section': '401', 'classNbr': 2103, 'meetings': [], 'notes': [], 'campus': 'MAIN', 'campusDescr': 'Ithaca', 'location': 'ITH', 'locationDescr': 'Ithaca, NY (Main Campus)', 'startDt': '01/23/2023', 'endDt': '05/20/2023', 'addConsent': 'N', 'addConsentDescr': 'No Special Consent Required', 'isComponentGraded': True, 'instructionMode': 'P', 'instrModeDescrshort': 'In Person', 'instrModeDescr': 'In Person', 'topicDescription': '', 'exploreCriteriaIds': [], 'materials': []}], 'unitsMinimum': 2, 'unitsMaximum': 2, 'componentsOptional': [], 'componentsRequired': ['LAB'], 'gradingBasis': 'OPT', 'gradingBasisShort': 'Stdnt Opt', 'gradingBasisLong': 'Letter or S/U grades', 'simpleCombinations': [], 'sessionCode': '1', 'sessionBeginDt': '01/23/2023', 'sessionEndDt': '05/20/2023', 'sessionLong': 'Regular Academic Session', 'exploreCriteriaIds': []}], 'description': 'Companion to PLBIO 3430\\xa0with laboratory activities that focus on the practice of plant biotechnology. Students construct transgenes using recombinant DNA methods, transfer genes to plants by a variety of approaches including tissue culture-based methods, assess the integration of transgenes in the host genome and analyze their expression by use of reporter gene assays and by preparing and analyzing nucleic acids. Students will also gain basic skills in bioinformatics.', 'catalogBreadth': '', 'catalogDistr': '', 'catalogLang': '', 'catalogForbiddenOverlaps': '', 'catalogAttribute': '', 'catalogWhenOffered': 'Spring.', 'catalogComments': '', 'catalogPrereqCoreq': '', 'catalogFee': '', 'catalogSatisfiesReq': '', 'catalogPermission': '', 'catalogCourseSubfield': '', 'catalogOutcomes': ['Describe the fundamental concepts underlying modern plant molecular biology.', 'Gain hands-on experience in implementing methods typically used in plant molecular biological studies.'], 'acadCareer': 'GR', 'acadGroup': 'AG', 'exploreCriteriaIds': []}\n",
      "\n",
      "\n",
      "list index out of range\n",
      "\n",
      "\n",
      "16\n"
     ]
    }
   ],
   "source": [
    "df = []\n",
    "missedClasses = 0\n",
    "cntr = 0\n",
    "for subject in subject_list: \n",
    "    url = f\"https://classes.cornell.edu/api/2.0/search/classes.json?roster=SP23&subject={subject}\"\n",
    "    response = urlopen(url)\n",
    "\n",
    "    data_json = json.loads(response.read())\n",
    "\n",
    "    classes = data_json['data']['classes']\n",
    "\n",
    "    for class_ in classes:\n",
    "        try:        \n",
    "            obj = class_['enrollGroups'][0]['classSections'][0]['meetings'][0]\n",
    "            try:\n",
    "                obj2 = obj['instructors'][0]\n",
    "                prof = obj2['firstName'].strip() + ' ' + obj2['lastName'].strip()\n",
    "            except:\n",
    "                prof = \"\"\n",
    "\n",
    "            startTime = obj['timeStart']\n",
    "            endTime = obj['timeEnd']\n",
    "            location = obj['facilityDescr']\n",
    "            #x = [class_['subject'] , class_['catalogNbr'] , class_['titleLong'], obj2['firstName'].strip() + ' ' + obj2['lastName'].strip(), startTime, endTime, location, class_['description'], class_['catalogPrereqCoreq'], class_['catalogWhenOffered']]\n",
    "            x = [class_['subject'] , class_['catalogNbr'] , class_['titleLong'], prof, startTime, endTime, location, class_['description'], class_['catalogPrereqCoreq'], class_['catalogWhenOffered']]\n",
    "\n",
    "            df.append(x)\n",
    "        except Exception as e:\n",
    "            print(cntr)\n",
    "            print(class_)\n",
    "            print('\\n')\n",
    "            print(e)\n",
    "            print('\\n')\n",
    "            missedClasses += 1\n",
    "        cntr +=1\n",
    "print(missedClasses)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(4519, 10)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1 = pd.DataFrame(np.array(df))\n",
    "df1.shape\n",
    "#Sp22: 4544, FA22: 4162"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1 = df1.rename(columns={0:\"Dept\", 1:\"Number\", 2:\"Course_Name\", 3:\"Professor\", 4:\"Start_Time\", 5:\"End_Time\", 6:\"Location\",7:\"Description\",8:\"Pre/coreqs\",9:\"Offered\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "median_grades = pd.read_csv(\"Cleaned_Medians.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>Unnamed: 0</th>\n",
       "      <th>Dept + Number</th>\n",
       "      <th>Professor</th>\n",
       "      <th>Median Grade</th>\n",
       "      <th>Semester (Ex: SP21)</th>\n",
       "      <th># of Students</th>\n",
       "      <th>Notes</th>\n",
       "      <th>Semester</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>AAS 2130</td>\n",
       "      <td>Chang</td>\n",
       "      <td>A</td>\n",
       "      <td>FA21</td>\n",
       "      <td>52</td>\n",
       "      <td>crosslisted with AMST 2640, HIST 2640</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>289</td>\n",
       "      <td>ENGL 1158 (FWS: Asian American Food Writing)</td>\n",
       "      <td>Rhee</td>\n",
       "      <td>A</td>\n",
       "      <td>FA21</td>\n",
       "      <td>17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>585</td>\n",
       "      <td>PLBIO 2300</td>\n",
       "      <td>Nixon</td>\n",
       "      <td>A</td>\n",
       "      <td>FA21</td>\n",
       "      <td>13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>287</td>\n",
       "      <td>ENGL 1105</td>\n",
       "      <td>Various (FWS)</td>\n",
       "      <td>A+</td>\n",
       "      <td>FA21</td>\n",
       "      <td>49</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>286</td>\n",
       "      <td>EDUC 2610</td>\n",
       "      <td>Steinhall</td>\n",
       "      <td>A</td>\n",
       "      <td>FA21</td>\n",
       "      <td>86</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519</th>\n",
       "      <td>227</td>\n",
       "      <td>DEA 3510</td>\n",
       "      <td>Hedge</td>\n",
       "      <td>B</td>\n",
       "      <td>FA18</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>520</th>\n",
       "      <td>175</td>\n",
       "      <td>COMM 2200</td>\n",
       "      <td>Humphreys</td>\n",
       "      <td>A-</td>\n",
       "      <td>FA18</td>\n",
       "      <td>95</td>\n",
       "      <td>Cookie Cutter Essays</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>521</th>\n",
       "      <td>140</td>\n",
       "      <td>CEE 4510</td>\n",
       "      <td>Richardson</td>\n",
       "      <td>A-</td>\n",
       "      <td>FA17</td>\n",
       "      <td>44</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>522</th>\n",
       "      <td>171</td>\n",
       "      <td>COML 1109</td>\n",
       "      <td>Various (FWS)</td>\n",
       "      <td>A-</td>\n",
       "      <td>FA17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>523</th>\n",
       "      <td>0</td>\n",
       "      <td>SEARCH BEFORE ADDING YOUR CLASS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>524 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0                                 Dept + Number      Professor  \\\n",
       "0             1                                      AAS 2130          Chang   \n",
       "1           289  ENGL 1158 (FWS: Asian American Food Writing)           Rhee   \n",
       "2           585                                    PLBIO 2300          Nixon   \n",
       "3           287                                     ENGL 1105  Various (FWS)   \n",
       "4           286                                     EDUC 2610      Steinhall   \n",
       "..          ...                                           ...            ...   \n",
       "519         227                                      DEA 3510          Hedge   \n",
       "520         175                                     COMM 2200      Humphreys   \n",
       "521         140                                      CEE 4510     Richardson   \n",
       "522         171                                     COML 1109  Various (FWS)   \n",
       "523           0               SEARCH BEFORE ADDING YOUR CLASS            NaN   \n",
       "\n",
       "    Median Grade Semester (Ex: SP21) # of Students  \\\n",
       "0              A                FA21            52   \n",
       "1              A                FA21            17   \n",
       "2              A                FA21            13   \n",
       "3             A+                FA21            49   \n",
       "4              A                FA21            86   \n",
       "..           ...                 ...           ...   \n",
       "519            B                FA18            14   \n",
       "520           A-                FA18            95   \n",
       "521           A-                FA17            44   \n",
       "522           A-                FA17           NaN   \n",
       "523          NaN                 NaN           NaN   \n",
       "\n",
       "                                     Notes  Semester  \n",
       "0    crosslisted with AMST 2640, HIST 2640       0.0  \n",
       "1                                      NaN       0.0  \n",
       "2                                      NaN       0.0  \n",
       "3                                      NaN       0.0  \n",
       "4                                      NaN       0.0  \n",
       "..                                     ...       ...  \n",
       "519                                    NaN       6.0  \n",
       "520                   Cookie Cutter Essays       6.0  \n",
       "521                                    NaN       8.0  \n",
       "522                                    NaN       8.0  \n",
       "523                                    NaN       NaN  \n",
       "\n",
       "[524 rows x 8 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "median_grades"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "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>Class_Name</th>\n",
       "      <th>professor</th>\n",
       "      <th>median</th>\n",
       "      <th>semester</th>\n",
       "      <th>size</th>\n",
       "      <th>notes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AAS 2130</td>\n",
       "      <td>Chang</td>\n",
       "      <td>A</td>\n",
       "      <td>FA21</td>\n",
       "      <td>52</td>\n",
       "      <td>crosslisted with AMST 2640, HIST 2640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AAS 2130</td>\n",
       "      <td>Moghimi</td>\n",
       "      <td>A</td>\n",
       "      <td>FA21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AEM 2010</td>\n",
       "      <td>Moghimi</td>\n",
       "      <td>A+</td>\n",
       "      <td>SP22</td>\n",
       "      <td>145</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AEM 2100</td>\n",
       "      <td>Van Es</td>\n",
       "      <td>A</td>\n",
       "      <td>FA21</td>\n",
       "      <td>252</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AEM 2210</td>\n",
       "      <td>Riley</td>\n",
       "      <td>A</td>\n",
       "      <td>SP21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>794</th>\n",
       "      <td>STSCI 2100</td>\n",
       "      <td>Packard/Karns</td>\n",
       "      <td>B+</td>\n",
       "      <td>FA21</td>\n",
       "      <td>234</td>\n",
       "      <td>crosslisted with ILRST 2100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>795</th>\n",
       "      <td>STSCI 2150</td>\n",
       "      <td>Smith</td>\n",
       "      <td>B+</td>\n",
       "      <td>SP22</td>\n",
       "      <td>211</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>796</th>\n",
       "      <td>Dept + Number</td>\n",
       "      <td>Professor</td>\n",
       "      <td>Median Grade</td>\n",
       "      <td>SP22</td>\n",
       "      <td># of Students</td>\n",
       "      <td>Notes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>797</th>\n",
       "      <td>GOVT 3867</td>\n",
       "      <td>Ward</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FA20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>798</th>\n",
       "      <td>SEARCH BEFORE ADDING YOUR CLASS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>799 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                          Class_Name      professor        median semester  \\\n",
       "0                           AAS 2130          Chang             A     FA21   \n",
       "1                           AAS 2130        Moghimi             A     FA21   \n",
       "2                           AEM 2010        Moghimi            A+     SP22   \n",
       "3                           AEM 2100         Van Es             A     FA21   \n",
       "4                           AEM 2210          Riley             A     SP21   \n",
       "..                               ...            ...           ...      ...   \n",
       "794                       STSCI 2100  Packard/Karns            B+     FA21   \n",
       "795                       STSCI 2150          Smith            B+     SP22   \n",
       "796                    Dept + Number      Professor  Median Grade     SP22   \n",
       "797                        GOVT 3867           Ward           NaN     FA20   \n",
       "798  SEARCH BEFORE ADDING YOUR CLASS            NaN           NaN      NaN   \n",
       "\n",
       "              size                                  notes  \n",
       "0               52  crosslisted with AMST 2640, HIST 2640  \n",
       "1              NaN                                    NaN  \n",
       "2              145                                    NaN  \n",
       "3              252                                    NaN  \n",
       "4              NaN                                    NaN  \n",
       "..             ...                                    ...  \n",
       "794            234            crosslisted with ILRST 2100  \n",
       "795            211                                    NaN  \n",
       "796  # of Students                                  Notes  \n",
       "797            NaN                                    NaN  \n",
       "798            NaN                                    NaN  \n",
       "\n",
       "[799 rows x 6 columns]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "median_grades_v2 = pd.read_csv(\"Cornell_Median_Grades.csv\", names = [\"Class_Name\", \"professor\", \"median\", \"semester\", \"size\",\"notes\"])\n",
    "median_grades_v2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "#UPDATE THIS IF NEEDED WHEN RE RUN\n",
    "semesterdict = {\"FA22\":-2,\"SP22\":-1, \"FA21\":0, 'SP21':1, 'FA20':2, 'SP20':3, 'FA19':4,'SP19':5,'FA18':6,'SP18':7,'FA17':8,'SP17':9,'FA16':10}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "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>Class_Name</th>\n",
       "      <th>professor</th>\n",
       "      <th>median</th>\n",
       "      <th>semester</th>\n",
       "      <th>size</th>\n",
       "      <th>notes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AAS 2130</td>\n",
       "      <td>Chang</td>\n",
       "      <td>A</td>\n",
       "      <td>FA21</td>\n",
       "      <td>52</td>\n",
       "      <td>crosslisted with AMST 2640, HIST 2640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AAS 2130</td>\n",
       "      <td>Moghimi</td>\n",
       "      <td>A</td>\n",
       "      <td>FA21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AEM 2010</td>\n",
       "      <td>Moghimi</td>\n",
       "      <td>A+</td>\n",
       "      <td>SP22</td>\n",
       "      <td>145</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AEM 2100</td>\n",
       "      <td>Van Es</td>\n",
       "      <td>A</td>\n",
       "      <td>FA21</td>\n",
       "      <td>252</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AEM 2210</td>\n",
       "      <td>Riley</td>\n",
       "      <td>A</td>\n",
       "      <td>SP21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Class_Name professor median semester size  \\\n",
       "0   AAS 2130     Chang      A     FA21   52   \n",
       "1   AAS 2130   Moghimi      A     FA21  NaN   \n",
       "2   AEM 2010   Moghimi     A+     SP22  145   \n",
       "3   AEM 2100    Van Es      A     FA21  252   \n",
       "4   AEM 2210     Riley      A     SP21  NaN   \n",
       "\n",
       "                                   notes  \n",
       "0  crosslisted with AMST 2640, HIST 2640  \n",
       "1                                    NaN  \n",
       "2                                    NaN  \n",
       "3                                    NaN  \n",
       "4                                    NaN  "
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "median_grades_v2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Data cleaning for medians\n",
    "median_grades_v2['SemesterN'] = median_grades_v2['semester']\n",
    "median_grades_v2 = median_grades_v2.replace({\"SemesterN\": semesterdict})\n",
    "median_grades_v2['SemesterN'] = median_grades_v2['SemesterN'].astype(int, errors = \"ignore\")\n",
    "median_grades_v2 = median_grades_v2.sort_values(by=\"SemesterN\")\n",
    "median_grades_v2 = median_grades_v2.drop_duplicates(subset=\"Class_Name\", keep=\"first\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "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>Class_Name</th>\n",
       "      <th>professor</th>\n",
       "      <th>median</th>\n",
       "      <th>semester</th>\n",
       "      <th>size</th>\n",
       "      <th>notes</th>\n",
       "      <th>SemesterN</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>495</th>\n",
       "      <td>ILRID 1520</td>\n",
       "      <td>Bohns</td>\n",
       "      <td>A-</td>\n",
       "      <td>FA22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.5 Credit Class</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>769</th>\n",
       "      <td>PAM 2000</td>\n",
       "      <td>Tripp</td>\n",
       "      <td>B+</td>\n",
       "      <td>SP22</td>\n",
       "      <td>87</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>457</th>\n",
       "      <td>PAM 3764</td>\n",
       "      <td>Manne</td>\n",
       "      <td>A-</td>\n",
       "      <td>SP22</td>\n",
       "      <td>70</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>PSYCH 1102</td>\n",
       "      <td>Nichols</td>\n",
       "      <td>A</td>\n",
       "      <td>SP22</td>\n",
       "      <td>271</td>\n",
       "      <td>crosslisted with COGST 1101, LING 1170, PHIL 1...</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>ENGRI 1100</td>\n",
       "      <td>McMahon</td>\n",
       "      <td>A</td>\n",
       "      <td>SP22</td>\n",
       "      <td>26</td>\n",
       "      <td>crosslisted with AEP 1100</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Class_Name professor median semester size  \\\n",
       "495  ILRID 1520     Bohns     A-     FA22  NaN   \n",
       "769    PAM 2000     Tripp     B+     SP22   87   \n",
       "457    PAM 3764     Manne     A-     SP22   70   \n",
       "229  PSYCH 1102   Nichols      A     SP22  271   \n",
       "119  ENGRI 1100   McMahon      A     SP22   26   \n",
       "\n",
       "                                                 notes  SemesterN  \n",
       "495                                   1.5 Credit Class       -2.0  \n",
       "769                                                NaN       -1.0  \n",
       "457                                                NaN       -1.0  \n",
       "229  crosslisted with COGST 1101, LING 1170, PHIL 1...       -1.0  \n",
       "119                          crosslisted with AEP 1100       -1.0  "
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#median_grades_v2 = median_grades_v2[['Dept + Number', 'Median Grade', 'Semester (Ex: SP21)', 'Semester']]\n",
    "median_grades_v2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "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>Dept</th>\n",
       "      <th>Number</th>\n",
       "      <th>Course_Name</th>\n",
       "      <th>Professor</th>\n",
       "      <th>Start_Time</th>\n",
       "      <th>End_Time</th>\n",
       "      <th>Location</th>\n",
       "      <th>Description</th>\n",
       "      <th>Pre/coreqs</th>\n",
       "      <th>Offered</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AAS</td>\n",
       "      <td>1100</td>\n",
       "      <td>Introduction to Asian American Studies</td>\n",
       "      <td>Viranjini Munasinghe</td>\n",
       "      <td>02:55PM</td>\n",
       "      <td>04:10PM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>This interdisciplinary course offers an introd...</td>\n",
       "      <td></td>\n",
       "      <td>Spring.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AAS</td>\n",
       "      <td>2620</td>\n",
       "      <td>Introduction to Asian American Literature</td>\n",
       "      <td>Juliana Hu Pegues</td>\n",
       "      <td>11:25AM</td>\n",
       "      <td>12:40PM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>This course will introduce both a variety of w...</td>\n",
       "      <td></td>\n",
       "      <td>Spring.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AAS</td>\n",
       "      <td>3312</td>\n",
       "      <td>Afro-Asia: Futurism and Feminism</td>\n",
       "      <td>Tao Goffe</td>\n",
       "      <td>10:10AM</td>\n",
       "      <td>11:25AM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>This course explores cultural representations ...</td>\n",
       "      <td></td>\n",
       "      <td>Spring.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AAS</td>\n",
       "      <td>3378</td>\n",
       "      <td>Korean American Literature</td>\n",
       "      <td>Ivanna Yi</td>\n",
       "      <td>11:25AM</td>\n",
       "      <td>12:40PM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>The rapidly growing literature of the Korean d...</td>\n",
       "      <td></td>\n",
       "      <td>Spring.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AAS</td>\n",
       "      <td>4950</td>\n",
       "      <td>Independent Study</td>\n",
       "      <td>Viranjini Munasinghe</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>Independent reading course in topics not cover...</td>\n",
       "      <td></td>\n",
       "      <td>Fall, Spring.</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4514</th>\n",
       "      <td>YORUB</td>\n",
       "      <td>2111</td>\n",
       "      <td>Intermediate Yoruba II</td>\n",
       "      <td>Adeolu Ademoyo</td>\n",
       "      <td>09:05AM</td>\n",
       "      <td>09:55AM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>Intermediate Yoruba II is a follow-up to Inter...</td>\n",
       "      <td>Prerequisite: YORUB 1108 and YORUB 1109.</td>\n",
       "      <td>Spring.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4515</th>\n",
       "      <td>YORUB</td>\n",
       "      <td>3111</td>\n",
       "      <td>Advanced Yoruba II</td>\n",
       "      <td>Adeolu Ademoyo</td>\n",
       "      <td>07:30PM</td>\n",
       "      <td>09:25PM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>This course will help students expand their un...</td>\n",
       "      <td>Prerequisite: YORUB 3110.</td>\n",
       "      <td>Spring.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4516</th>\n",
       "      <td>ZULU</td>\n",
       "      <td>1116</td>\n",
       "      <td>Elementary Zulu II</td>\n",
       "      <td>Angelika Kraemer</td>\n",
       "      <td>11:35AM</td>\n",
       "      <td>12:25PM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>Development of communication skills through di...</td>\n",
       "      <td></td>\n",
       "      <td>Spring.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4517</th>\n",
       "      <td>ZULU</td>\n",
       "      <td>2117</td>\n",
       "      <td>Intermediate Zulu II</td>\n",
       "      <td>Angelika Kraemer</td>\n",
       "      <td>09:25AM</td>\n",
       "      <td>10:12AM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>Students read longer texts from popular media ...</td>\n",
       "      <td></td>\n",
       "      <td>Spring.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4518</th>\n",
       "      <td>ZULU</td>\n",
       "      <td>3114</td>\n",
       "      <td>Advanced Zulu II</td>\n",
       "      <td>Angelika Kraemer</td>\n",
       "      <td>02:30PM</td>\n",
       "      <td>03:45PM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>Readings may include short stories, a novel, p...</td>\n",
       "      <td></td>\n",
       "      <td>Spring.</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4519 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Dept Number                                Course_Name  \\\n",
       "0       AAS   1100     Introduction to Asian American Studies   \n",
       "1       AAS   2620  Introduction to Asian American Literature   \n",
       "2       AAS   3312           Afro-Asia: Futurism and Feminism   \n",
       "3       AAS   3378                 Korean American Literature   \n",
       "4       AAS   4950                          Independent Study   \n",
       "...     ...    ...                                        ...   \n",
       "4514  YORUB   2111                     Intermediate Yoruba II   \n",
       "4515  YORUB   3111                         Advanced Yoruba II   \n",
       "4516   ZULU   1116                         Elementary Zulu II   \n",
       "4517   ZULU   2117                       Intermediate Zulu II   \n",
       "4518   ZULU   3114                           Advanced Zulu II   \n",
       "\n",
       "                 Professor Start_Time End_Time        Location  \\\n",
       "0     Viranjini Munasinghe    02:55PM  04:10PM  To Be Assigned   \n",
       "1        Juliana Hu Pegues    11:25AM  12:40PM  To Be Assigned   \n",
       "2                Tao Goffe    10:10AM  11:25AM  To Be Assigned   \n",
       "3                Ivanna Yi    11:25AM  12:40PM  To Be Assigned   \n",
       "4     Viranjini Munasinghe                                None   \n",
       "...                    ...        ...      ...             ...   \n",
       "4514        Adeolu Ademoyo    09:05AM  09:55AM  To Be Assigned   \n",
       "4515        Adeolu Ademoyo    07:30PM  09:25PM  To Be Assigned   \n",
       "4516      Angelika Kraemer    11:35AM  12:25PM  To Be Assigned   \n",
       "4517      Angelika Kraemer    09:25AM  10:12AM  To Be Assigned   \n",
       "4518      Angelika Kraemer    02:30PM  03:45PM  To Be Assigned   \n",
       "\n",
       "                                            Description  \\\n",
       "0     This interdisciplinary course offers an introd...   \n",
       "1     This course will introduce both a variety of w...   \n",
       "2     This course explores cultural representations ...   \n",
       "3     The rapidly growing literature of the Korean d...   \n",
       "4     Independent reading course in topics not cover...   \n",
       "...                                                 ...   \n",
       "4514  Intermediate Yoruba II is a follow-up to Inter...   \n",
       "4515  This course will help students expand their un...   \n",
       "4516  Development of communication skills through di...   \n",
       "4517  Students read longer texts from popular media ...   \n",
       "4518  Readings may include short stories, a novel, p...   \n",
       "\n",
       "                                    Pre/coreqs        Offered  \n",
       "0                                                     Spring.  \n",
       "1                                                     Spring.  \n",
       "2                                                     Spring.  \n",
       "3                                                     Spring.  \n",
       "4                                               Fall, Spring.  \n",
       "...                                        ...            ...  \n",
       "4514  Prerequisite: YORUB 1108 and YORUB 1109.        Spring.  \n",
       "4515                 Prerequisite: YORUB 3110.        Spring.  \n",
       "4516                                                  Spring.  \n",
       "4517                                                  Spring.  \n",
       "4518                                                  Spring.  \n",
       "\n",
       "[4519 rows x 10 columns]"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1[\"Dept + Number\"] = df1[\"Dept\"] + ' ' + df1[\"Number\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "LATA 6000     1\n",
       "LAW 7762      1\n",
       "ENGRG 4815    1\n",
       "HIST 2354     1\n",
       "ARTH 2221     1\n",
       "             ..\n",
       "GOVT 6223     1\n",
       "PE 1333       1\n",
       "ALS 6016      1\n",
       "NRE 5030      1\n",
       "HD 4940       1\n",
       "Name: Dept + Number, Length: 4519, dtype: int64"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1['Dept + Number'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2 = df1.merge(median_grades_v2, left_on='Dept + Number', right_on = \"Class_Name\", how=\"outer\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2 = df2.dropna(subset=['Dept'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "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>Dept</th>\n",
       "      <th>Number</th>\n",
       "      <th>Course_Name</th>\n",
       "      <th>Professor</th>\n",
       "      <th>Start_Time</th>\n",
       "      <th>End_Time</th>\n",
       "      <th>Location</th>\n",
       "      <th>Description</th>\n",
       "      <th>Pre/coreqs</th>\n",
       "      <th>Offered</th>\n",
       "      <th>Dept + Number</th>\n",
       "      <th>Class_Name</th>\n",
       "      <th>professor</th>\n",
       "      <th>median</th>\n",
       "      <th>semester</th>\n",
       "      <th>size</th>\n",
       "      <th>notes</th>\n",
       "      <th>SemesterN</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2379</th>\n",
       "      <td>INFO</td>\n",
       "      <td>1300</td>\n",
       "      <td>Introductory Design and Programming for the Web</td>\n",
       "      <td>Royal Westwater</td>\n",
       "      <td>11:25AM</td>\n",
       "      <td>12:40PM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>The World Wide Web is both a technology and a ...</td>\n",
       "      <td></td>\n",
       "      <td>Fall, Spring.</td>\n",
       "      <td>INFO 1300</td>\n",
       "      <td>INFO 1300</td>\n",
       "      <td>Harms</td>\n",
       "      <td>A</td>\n",
       "      <td>FA21</td>\n",
       "      <td>264</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2380</th>\n",
       "      <td>INFO</td>\n",
       "      <td>1380</td>\n",
       "      <td>Data Science for All</td>\n",
       "      <td>Sumanta Basu</td>\n",
       "      <td>09:40AM</td>\n",
       "      <td>10:55AM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>This course provides an introduction to data s...</td>\n",
       "      <td></td>\n",
       "      <td>Spring.</td>\n",
       "      <td>INFO 1380</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2381</th>\n",
       "      <td>INFO</td>\n",
       "      <td>1998</td>\n",
       "      <td>Freshmen Team Projects</td>\n",
       "      <td>Walker White</td>\n",
       "      <td>07:30PM</td>\n",
       "      <td>08:20PM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>Independent work in information science as par...</td>\n",
       "      <td></td>\n",
       "      <td>Fall, Spring.</td>\n",
       "      <td>INFO 1998</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2382</th>\n",
       "      <td>INFO</td>\n",
       "      <td>2300</td>\n",
       "      <td>Intermediate Design and Programming for the Web</td>\n",
       "      <td>Kyle Harms</td>\n",
       "      <td>09:05AM</td>\n",
       "      <td>09:55AM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>Web programming requires the cooperation of tw...</td>\n",
       "      <td>Prerequisite: INFO 1300.</td>\n",
       "      <td>Spring.</td>\n",
       "      <td>INFO 2300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2383</th>\n",
       "      <td>INFO</td>\n",
       "      <td>2770</td>\n",
       "      <td>Excursions in Computational Sustainability</td>\n",
       "      <td>Carla Gomes</td>\n",
       "      <td>01:00PM</td>\n",
       "      <td>02:15PM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>Balancing environmental, economic, and societa...</td>\n",
       "      <td></td>\n",
       "      <td>Spring.</td>\n",
       "      <td>INFO 2770</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2384</th>\n",
       "      <td>INFO</td>\n",
       "      <td>2921</td>\n",
       "      <td>Inventing an Information Society</td>\n",
       "      <td>Gili Vidan</td>\n",
       "      <td>09:40AM</td>\n",
       "      <td>10:55AM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>Provides an introduction to the role computing...</td>\n",
       "      <td></td>\n",
       "      <td>Spring.</td>\n",
       "      <td>INFO 2921</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2385</th>\n",
       "      <td>INFO</td>\n",
       "      <td>2950</td>\n",
       "      <td>Introduction to Data Science</td>\n",
       "      <td>Benjamin Soltoff</td>\n",
       "      <td>09:40AM</td>\n",
       "      <td>10:55AM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>Teaches basic mathematical methods for informa...</td>\n",
       "      <td>Prerequisite: MATH 1710 or equivalent, CS 1110...</td>\n",
       "      <td>Fall.</td>\n",
       "      <td>INFO 2950</td>\n",
       "      <td>INFO 2950</td>\n",
       "      <td>Wilkens</td>\n",
       "      <td>A-</td>\n",
       "      <td>SP22</td>\n",
       "      <td>217</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2386</th>\n",
       "      <td>INFO</td>\n",
       "      <td>3140</td>\n",
       "      <td>Computational Psychology</td>\n",
       "      <td>Shimon Edelman</td>\n",
       "      <td>09:40AM</td>\n",
       "      <td>10:55AM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>This course states and motivates the observati...</td>\n",
       "      <td>Prerequisite: one course each in psychology an...</td>\n",
       "      <td>Spring.</td>\n",
       "      <td>INFO 3140</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2387</th>\n",
       "      <td>INFO</td>\n",
       "      <td>3152</td>\n",
       "      <td>Introduction to Computer Game Design</td>\n",
       "      <td>Walker White</td>\n",
       "      <td>12:25PM</td>\n",
       "      <td>01:15PM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>A project-based course in which programmers an...</td>\n",
       "      <td>Prerequisite for programmers: CS 2110, or perm...</td>\n",
       "      <td>Spring.</td>\n",
       "      <td>INFO 3152</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2388</th>\n",
       "      <td>INFO</td>\n",
       "      <td>3200</td>\n",
       "      <td>New Media and Society</td>\n",
       "      <td>Chao Yu</td>\n",
       "      <td>09:40AM</td>\n",
       "      <td>10:55AM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>Media and culture are undergoing a series of t...</td>\n",
       "      <td></td>\n",
       "      <td>Spring, Summer.</td>\n",
       "      <td>INFO 3200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2389</th>\n",
       "      <td>INFO</td>\n",
       "      <td>3312</td>\n",
       "      <td>Data Communication</td>\n",
       "      <td>Benjamin Soltoff</td>\n",
       "      <td>01:00PM</td>\n",
       "      <td>02:15PM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>INFO 3312</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2390</th>\n",
       "      <td>INFO</td>\n",
       "      <td>3370</td>\n",
       "      <td>Studying Social Inequality Using Data Science</td>\n",
       "      <td>Ian Lundberg</td>\n",
       "      <td>11:20AM</td>\n",
       "      <td>12:10PM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>INFO 3370</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2391</th>\n",
       "      <td>INFO</td>\n",
       "      <td>3450</td>\n",
       "      <td>Human-Computer Interaction Design</td>\n",
       "      <td>Qian Yang</td>\n",
       "      <td>01:00PM</td>\n",
       "      <td>02:15PM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>This course focuses on user experience design ...</td>\n",
       "      <td></td>\n",
       "      <td>Fall, Spring.</td>\n",
       "      <td>INFO 3450</td>\n",
       "      <td>INFO 3450</td>\n",
       "      <td>Yang</td>\n",
       "      <td>A</td>\n",
       "      <td>FA21</td>\n",
       "      <td>92</td>\n",
       "      <td>All assignments graded by TAs -&gt; very arbitrary</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2392</th>\n",
       "      <td>INFO</td>\n",
       "      <td>3950</td>\n",
       "      <td>Data Analytics for Information Science</td>\n",
       "      <td>Paul Ginsparg</td>\n",
       "      <td>11:25AM</td>\n",
       "      <td>12:40PM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>This course will cover intermediate-level appl...</td>\n",
       "      <td>Prerequisite: INFO 2950 or equivalent, plus su...</td>\n",
       "      <td>Spring.</td>\n",
       "      <td>INFO 3950</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2393</th>\n",
       "      <td>INFO</td>\n",
       "      <td>4152</td>\n",
       "      <td>Advanced Topics in Computer Game Design</td>\n",
       "      <td>Walker White</td>\n",
       "      <td>11:20AM</td>\n",
       "      <td>12:10PM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>Project-based follow-up course to INFO 3152. S...</td>\n",
       "      <td>Prerequisite for programmers: INFO 3152, CS 33...</td>\n",
       "      <td>Spring.</td>\n",
       "      <td>INFO 4152</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2394</th>\n",
       "      <td>INFO</td>\n",
       "      <td>4210</td>\n",
       "      <td>Artificial Intelligence: Law, Ethics, and Poli...</td>\n",
       "      <td>Sarah Kreps</td>\n",
       "      <td>09:40AM</td>\n",
       "      <td>10:55AM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>In the coming decades machine intelligence wil...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>INFO 4210</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2395</th>\n",
       "      <td>INFO</td>\n",
       "      <td>4220</td>\n",
       "      <td>Networks II: Market Design</td>\n",
       "      <td>Cristobal Cheyre Forestier</td>\n",
       "      <td>09:40AM</td>\n",
       "      <td>10:55AM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>Networks II builds on its prerequisite course ...</td>\n",
       "      <td>Prerequisite: INFO 2040, CS 2800 or equivalent.</td>\n",
       "      <td>Spring.</td>\n",
       "      <td>INFO 4220</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2396</th>\n",
       "      <td>INFO</td>\n",
       "      <td>4250</td>\n",
       "      <td>Surveillance and Privacy</td>\n",
       "      <td>Tracy Mitrano</td>\n",
       "      <td>02:40PM</td>\n",
       "      <td>05:10PM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>This course explores the social, legal, and et...</td>\n",
       "      <td>Prerequisite: INFO 1200 or permission of instr...</td>\n",
       "      <td>Fall.</td>\n",
       "      <td>INFO 4250</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2397</th>\n",
       "      <td>INFO</td>\n",
       "      <td>4260</td>\n",
       "      <td>Computing On Earth: Planetary Dimensions and C...</td>\n",
       "      <td>Steven Jackson</td>\n",
       "      <td>02:40PM</td>\n",
       "      <td>05:10PM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>INFO 4260</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2398</th>\n",
       "      <td>INFO</td>\n",
       "      <td>4300</td>\n",
       "      <td>Language and Information</td>\n",
       "      <td>Cristian Danescu-Niculescu-Mizil</td>\n",
       "      <td>02:45PM</td>\n",
       "      <td>04:00PM</td>\n",
       "      <td>To Be Assigned</td>\n",
       "      <td>How to make sense of the vast amounts of infor...</td>\n",
       "      <td>Prerequisite: 1) Linear algebra: strong perfor...</td>\n",
       "      <td>Spring.</td>\n",
       "      <td>INFO 4300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Dept Number                                        Course_Name  \\\n",
       "2379  INFO   1300    Introductory Design and Programming for the Web   \n",
       "2380  INFO   1380                               Data Science for All   \n",
       "2381  INFO   1998                             Freshmen Team Projects   \n",
       "2382  INFO   2300    Intermediate Design and Programming for the Web   \n",
       "2383  INFO   2770         Excursions in Computational Sustainability   \n",
       "2384  INFO   2921                   Inventing an Information Society   \n",
       "2385  INFO   2950                       Introduction to Data Science   \n",
       "2386  INFO   3140                           Computational Psychology   \n",
       "2387  INFO   3152               Introduction to Computer Game Design   \n",
       "2388  INFO   3200                              New Media and Society   \n",
       "2389  INFO   3312                                 Data Communication   \n",
       "2390  INFO   3370      Studying Social Inequality Using Data Science   \n",
       "2391  INFO   3450                  Human-Computer Interaction Design   \n",
       "2392  INFO   3950             Data Analytics for Information Science   \n",
       "2393  INFO   4152            Advanced Topics in Computer Game Design   \n",
       "2394  INFO   4210  Artificial Intelligence: Law, Ethics, and Poli...   \n",
       "2395  INFO   4220                         Networks II: Market Design   \n",
       "2396  INFO   4250                           Surveillance and Privacy   \n",
       "2397  INFO   4260  Computing On Earth: Planetary Dimensions and C...   \n",
       "2398  INFO   4300                           Language and Information   \n",
       "\n",
       "                             Professor Start_Time End_Time        Location  \\\n",
       "2379                   Royal Westwater    11:25AM  12:40PM  To Be Assigned   \n",
       "2380                      Sumanta Basu    09:40AM  10:55AM  To Be Assigned   \n",
       "2381                      Walker White    07:30PM  08:20PM  To Be Assigned   \n",
       "2382                        Kyle Harms    09:05AM  09:55AM  To Be Assigned   \n",
       "2383                       Carla Gomes    01:00PM  02:15PM  To Be Assigned   \n",
       "2384                        Gili Vidan    09:40AM  10:55AM  To Be Assigned   \n",
       "2385                  Benjamin Soltoff    09:40AM  10:55AM  To Be Assigned   \n",
       "2386                    Shimon Edelman    09:40AM  10:55AM  To Be Assigned   \n",
       "2387                      Walker White    12:25PM  01:15PM  To Be Assigned   \n",
       "2388                           Chao Yu    09:40AM  10:55AM  To Be Assigned   \n",
       "2389                  Benjamin Soltoff    01:00PM  02:15PM  To Be Assigned   \n",
       "2390                      Ian Lundberg    11:20AM  12:10PM  To Be Assigned   \n",
       "2391                         Qian Yang    01:00PM  02:15PM  To Be Assigned   \n",
       "2392                     Paul Ginsparg    11:25AM  12:40PM  To Be Assigned   \n",
       "2393                      Walker White    11:20AM  12:10PM  To Be Assigned   \n",
       "2394                       Sarah Kreps    09:40AM  10:55AM  To Be Assigned   \n",
       "2395        Cristobal Cheyre Forestier    09:40AM  10:55AM  To Be Assigned   \n",
       "2396                     Tracy Mitrano    02:40PM  05:10PM  To Be Assigned   \n",
       "2397                    Steven Jackson    02:40PM  05:10PM  To Be Assigned   \n",
       "2398  Cristian Danescu-Niculescu-Mizil    02:45PM  04:00PM  To Be Assigned   \n",
       "\n",
       "                                            Description  \\\n",
       "2379  The World Wide Web is both a technology and a ...   \n",
       "2380  This course provides an introduction to data s...   \n",
       "2381  Independent work in information science as par...   \n",
       "2382  Web programming requires the cooperation of tw...   \n",
       "2383  Balancing environmental, economic, and societa...   \n",
       "2384  Provides an introduction to the role computing...   \n",
       "2385  Teaches basic mathematical methods for informa...   \n",
       "2386  This course states and motivates the observati...   \n",
       "2387  A project-based course in which programmers an...   \n",
       "2388  Media and culture are undergoing a series of t...   \n",
       "2389                                               None   \n",
       "2390                                               None   \n",
       "2391  This course focuses on user experience design ...   \n",
       "2392  This course will cover intermediate-level appl...   \n",
       "2393  Project-based follow-up course to INFO 3152. S...   \n",
       "2394  In the coming decades machine intelligence wil...   \n",
       "2395  Networks II builds on its prerequisite course ...   \n",
       "2396  This course explores the social, legal, and et...   \n",
       "2397                                               None   \n",
       "2398  How to make sense of the vast amounts of infor...   \n",
       "\n",
       "                                             Pre/coreqs          Offered  \\\n",
       "2379                                                       Fall, Spring.   \n",
       "2380                                                             Spring.   \n",
       "2381                                                       Fall, Spring.   \n",
       "2382                           Prerequisite: INFO 1300.          Spring.   \n",
       "2383                                                             Spring.   \n",
       "2384                                                             Spring.   \n",
       "2385  Prerequisite: MATH 1710 or equivalent, CS 1110...            Fall.   \n",
       "2386  Prerequisite: one course each in psychology an...          Spring.   \n",
       "2387  Prerequisite for programmers: CS 2110, or perm...          Spring.   \n",
       "2388                                                     Spring, Summer.   \n",
       "2389                                               None             None   \n",
       "2390                                               None             None   \n",
       "2391                                                       Fall, Spring.   \n",
       "2392  Prerequisite: INFO 2950 or equivalent, plus su...          Spring.   \n",
       "2393  Prerequisite for programmers: INFO 3152, CS 33...          Spring.   \n",
       "2394                                               None             None   \n",
       "2395    Prerequisite: INFO 2040, CS 2800 or equivalent.          Spring.   \n",
       "2396  Prerequisite: INFO 1200 or permission of instr...            Fall.   \n",
       "2397                                               None             None   \n",
       "2398  Prerequisite: 1) Linear algebra: strong perfor...          Spring.   \n",
       "\n",
       "     Dept + Number Class_Name professor median semester size  \\\n",
       "2379     INFO 1300  INFO 1300     Harms      A     FA21  264   \n",
       "2380     INFO 1380        NaN       NaN    NaN      NaN  NaN   \n",
       "2381     INFO 1998        NaN       NaN    NaN      NaN  NaN   \n",
       "2382     INFO 2300        NaN       NaN    NaN      NaN  NaN   \n",
       "2383     INFO 2770        NaN       NaN    NaN      NaN  NaN   \n",
       "2384     INFO 2921        NaN       NaN    NaN      NaN  NaN   \n",
       "2385     INFO 2950  INFO 2950   Wilkens     A-     SP22  217   \n",
       "2386     INFO 3140        NaN       NaN    NaN      NaN  NaN   \n",
       "2387     INFO 3152        NaN       NaN    NaN      NaN  NaN   \n",
       "2388     INFO 3200        NaN       NaN    NaN      NaN  NaN   \n",
       "2389     INFO 3312        NaN       NaN    NaN      NaN  NaN   \n",
       "2390     INFO 3370        NaN       NaN    NaN      NaN  NaN   \n",
       "2391     INFO 3450  INFO 3450      Yang      A     FA21   92   \n",
       "2392     INFO 3950        NaN       NaN    NaN      NaN  NaN   \n",
       "2393     INFO 4152        NaN       NaN    NaN      NaN  NaN   \n",
       "2394     INFO 4210        NaN       NaN    NaN      NaN  NaN   \n",
       "2395     INFO 4220        NaN       NaN    NaN      NaN  NaN   \n",
       "2396     INFO 4250        NaN       NaN    NaN      NaN  NaN   \n",
       "2397     INFO 4260        NaN       NaN    NaN      NaN  NaN   \n",
       "2398     INFO 4300        NaN       NaN    NaN      NaN  NaN   \n",
       "\n",
       "                                                notes  SemesterN  \n",
       "2379                                              NaN        0.0  \n",
       "2380                                              NaN        NaN  \n",
       "2381                                              NaN        NaN  \n",
       "2382                                              NaN        NaN  \n",
       "2383                                              NaN        NaN  \n",
       "2384                                              NaN        NaN  \n",
       "2385                                              NaN       -1.0  \n",
       "2386                                              NaN        NaN  \n",
       "2387                                              NaN        NaN  \n",
       "2388                                              NaN        NaN  \n",
       "2389                                              NaN        NaN  \n",
       "2390                                              NaN        NaN  \n",
       "2391  All assignments graded by TAs -> very arbitrary        0.0  \n",
       "2392                                              NaN        NaN  \n",
       "2393                                              NaN        NaN  \n",
       "2394                                              NaN        NaN  \n",
       "2395                                              NaN        NaN  \n",
       "2396                                              NaN        NaN  \n",
       "2397                                              NaN        NaN  \n",
       "2398                                              NaN        NaN  "
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2[df2['Dept'] == 'INFO'].head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2.to_csv(\"Classes_With_Medians_SP23.csv\")"
   ]
  },
  {
   "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.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}