SuggestedSchedules.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import json\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "txt_directory = 'txt/'\n",
    "json_directory = 'json/suggested/'\n",
    "majors = ['act', 'ce', 'ee', 'cs']\n",
    "addendum = '_suggested'\n",
    "csv_ending = '.csv'\n",
    "json_ending = '.json'\n",
    "classes = dict()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "section     MATH\n",
      "number       221\n",
      "semester       F\n",
      "year           1\n",
      "Name: 0, dtype: object\n",
      "section     ECON\n",
      "number       102\n",
      "semester       F\n",
      "year           1\n",
      "Name: 1, dtype: object\n",
      "section     AAS\n",
      "number      100\n",
      "semester      F\n",
      "year          1\n",
      "Name: 2, dtype: object\n",
      "section     HIST\n",
      "number       100\n",
      "semester       F\n",
      "year           1\n",
      "Name: 3, dtype: object\n",
      "section      CS\n",
      "number      101\n",
      "semester      S\n",
      "year          1\n",
      "Name: 4, dtype: object\n",
      "section     MATH\n",
      "number       231\n",
      "semester       S\n",
      "year           1\n",
      "Name: 5, dtype: object\n",
      "section     ECON\n",
      "number       103\n",
      "semester       S\n",
      "year           1\n",
      "Name: 6, dtype: object\n",
      "section     PHYS\n",
      "number       211\n",
      "semester       S\n",
      "year           1\n",
      "Name: 7, dtype: object\n",
      "section     MATH\n",
      "number       241\n",
      "semester       F\n",
      "year           2\n",
      "Name: 8, dtype: object\n",
      "section     MATH\n",
      "number       210\n",
      "semester       F\n",
      "year           2\n",
      "Name: 9, dtype: object\n",
      "section     HIST\n",
      "number       172\n",
      "semester       F\n",
      "year           2\n",
      "Name: 10, dtype: object\n",
      "section     MUS\n",
      "number      133\n",
      "semester      F\n",
      "year          2\n",
      "Name: 11, dtype: object\n",
      "section     ECON\n",
      "number       202\n",
      "semester       F\n",
      "year           2\n",
      "Name: 12, dtype: object\n",
      "section     MATH\n",
      "number       408\n",
      "semester       S\n",
      "year           2\n",
      "Name: 13, dtype: object\n",
      "section     ACCY\n",
      "number       200\n",
      "semester       S\n",
      "year           2\n",
      "Name: 14, dtype: object\n",
      "section     STAT\n",
      "number       400\n",
      "semester       S\n",
      "year           2\n",
      "Name: 15, dtype: object\n",
      "section     ECON\n",
      "number       203\n",
      "semester       S\n",
      "year           2\n",
      "Name: 16, dtype: object\n",
      "section     MATH\n",
      "number       409\n",
      "semester       F\n",
      "year           3\n",
      "Name: 17, dtype: object\n",
      "section     MATH\n",
      "number       471\n",
      "semester       F\n",
      "year           3\n",
      "Name: 18, dtype: object\n",
      "section     FIN\n",
      "number      230\n",
      "semester      F\n",
      "year          3\n",
      "Name: 19, dtype: object\n",
      "section     FIN\n",
      "number      221\n",
      "semester      F\n",
      "year          3\n",
      "Name: 20, dtype: object\n",
      "section     MATH\n",
      "number       472\n",
      "semester       S\n",
      "year           3\n",
      "Name: 21, dtype: object\n",
      "section     MATH\n",
      "number       410\n",
      "semester       S\n",
      "year           3\n",
      "Name: 22, dtype: object\n",
      "section     FIN\n",
      "number      300\n",
      "semester      S\n",
      "year          3\n",
      "Name: 23, dtype: object\n",
      "section     ECON\n",
      "number       220\n",
      "semester       S\n",
      "year           3\n",
      "Name: 24, dtype: object\n",
      "section     MATH\n",
      "number       476\n",
      "semester       F\n",
      "year           4\n",
      "Name: 25, dtype: object\n",
      "section     FIN\n",
      "number      321\n",
      "semester      F\n",
      "year          4\n",
      "Name: 26, dtype: object\n",
      "section     PHYS\n",
      "number       212\n",
      "semester       F\n",
      "year           4\n",
      "Name: 27, dtype: object\n",
      "section     ECON\n",
      "number       302\n",
      "semester       F\n",
      "year           4\n",
      "Name: 28, dtype: object\n",
      "section     MATH\n",
      "number       478\n",
      "semester       S\n",
      "year           4\n",
      "Name: 29, dtype: object\n",
      "section     MATH\n",
      "number       469\n",
      "semester       S\n",
      "year           4\n",
      "Name: 30, dtype: object\n",
      "section     ECON\n",
      "number       303\n",
      "semester       S\n",
      "year           4\n",
      "Name: 31, dtype: object\n",
      "section     ECON\n",
      "number       420\n",
      "semester       S\n",
      "year           4\n",
      "Name: 32, dtype: object\n",
      "section     ENG\n",
      "number      100\n",
      "semester      F\n",
      "year          1\n",
      "Name: 0, dtype: object\n",
      "section     MATH\n",
      "number       221\n",
      "semester       F\n",
      "year           1\n",
      "Name: 1, dtype: object\n",
      "section     ECON\n",
      "number       102\n",
      "semester       F\n",
      "year           1\n",
      "Name: 2, dtype: object\n",
      "section     ECE\n",
      "number      120\n",
      "semester      F\n",
      "year          1\n",
      "Name: 3, dtype: object\n",
      "section     RHET\n",
      "number       105\n",
      "semester       F\n",
      "year           1\n",
      "Name: 4, dtype: object\n",
      "section     ECON\n",
      "number       103\n",
      "semester       S\n",
      "year           1\n",
      "Name: 5, dtype: object\n",
      "section     PHYS\n",
      "number       211\n",
      "semester       S\n",
      "year           1\n",
      "Name: 6, dtype: object\n",
      "section     CHEM\n",
      "number       102\n",
      "semester       S\n",
      "year           1\n",
      "Name: 7, dtype: object\n",
      "section     CHEM\n",
      "number       103\n",
      "semester       S\n",
      "year           1\n",
      "Name: 8, dtype: object\n",
      "section     ECE\n",
      "number      110\n",
      "semester      S\n",
      "year          1\n",
      "Name: 9, dtype: object\n",
      "section     MATH\n",
      "number       231\n",
      "semester       S\n",
      "year           1\n",
      "Name: 10, dtype: object\n",
      "section     MATH\n",
      "number       241\n",
      "semester       F\n",
      "year           2\n",
      "Name: 11, dtype: object\n",
      "section     PHYS\n",
      "number       212\n",
      "semester       F\n",
      "year           2\n",
      "Name: 12, dtype: object\n",
      "section      CS\n",
      "number      173\n",
      "semester      F\n",
      "year          2\n",
      "Name: 13, dtype: object\n",
      "section     ECE\n",
      "number      220\n",
      "semester      F\n",
      "year          2\n",
      "Name: 14, dtype: object\n",
      "section     HIST\n",
      "number       100\n",
      "semester       S\n",
      "year           2\n",
      "Name: 15, dtype: object\n",
      "section     MATH\n",
      "number       286\n",
      "semester       S\n",
      "year           2\n",
      "Name: 16, dtype: object\n",
      "section     ECE\n",
      "number      210\n",
      "semester      S\n",
      "year          2\n",
      "Name: 17, dtype: object\n",
      "section      CS\n",
      "number      225\n",
      "semester      S\n",
      "year          2\n",
      "Name: 18, dtype: object\n",
      "section     PHYS\n",
      "number       214\n",
      "semester       S\n",
      "year           2\n",
      "Name: 19, dtype: object\n",
      "section     ECE\n",
      "number      313\n",
      "semester      F\n",
      "year          3\n",
      "Name: 20, dtype: object\n",
      "section     ECE\n",
      "number      428\n",
      "semester      F\n",
      "year          3\n",
      "Name: 21, dtype: object\n",
      "section     ECE\n",
      "number      329\n",
      "semester      F\n",
      "year          3\n",
      "Name: 22, dtype: object\n",
      "section     PHYS\n",
      "number       213\n",
      "semester       F\n",
      "year           3\n",
      "Name: 23, dtype: object\n",
      "section     PSYC\n",
      "number       100\n",
      "semester       F\n",
      "year           3\n",
      "Name: 24, dtype: object\n",
      "section     HIST\n",
      "number       172\n",
      "semester       S\n",
      "year           3\n",
      "Name: 25, dtype: object\n",
      "section     ECE\n",
      "number      391\n",
      "semester      S\n",
      "year          3\n",
      "Name: 26, dtype: object\n",
      "section      CS\n",
      "number      498\n",
      "semester      S\n",
      "year          3\n",
      "Name: 27, dtype: object\n",
      "section     ECE\n",
      "number      448\n",
      "semester      S\n",
      "year          3\n",
      "Name: 28, dtype: object\n",
      "section     MATH\n",
      "number       461\n",
      "semester       S\n",
      "year           3\n",
      "Name: 29, dtype: object\n",
      "section     HIST\n",
      "number       120\n",
      "semester       F\n",
      "year           4\n",
      "Name: 30, dtype: object\n",
      "section     ECE\n",
      "number      411\n",
      "semester      F\n",
      "year          4\n",
      "Name: 31, dtype: object\n",
      "section     ECE\n",
      "number      422\n",
      "semester      F\n",
      "year          4\n",
      "Name: 32, dtype: object\n",
      "section     ECE\n",
      "number      402\n",
      "semester      F\n",
      "year          4\n",
      "Name: 33, dtype: object\n",
      "section     MATH\n",
      "number       412\n",
      "semester       F\n",
      "year           4\n",
      "Name: 34, dtype: object\n",
      "section     MATH\n",
      "number       464\n",
      "semester       S\n",
      "year           4\n",
      "Name: 35, dtype: object\n",
      "section     ECE\n",
      "number      403\n",
      "semester      S\n",
      "year          4\n",
      "Name: 36, dtype: object\n",
      "section     ECE\n",
      "number      438\n",
      "semester      S\n",
      "year          4\n",
      "Name: 37, dtype: object\n",
      "section     ECE\n",
      "number      414\n",
      "semester      S\n",
      "year          4\n",
      "Name: 38, dtype: object\n",
      "section     ECE\n",
      "number      453\n",
      "semester      S\n",
      "year          4\n",
      "Name: 39, dtype: object\n",
      "section     CHEM\n",
      "number       102\n",
      "semester       F\n",
      "year           1\n",
      "Name: 0, dtype: object\n",
      "section     CHEM\n",
      "number       103\n",
      "semester       F\n",
      "year           1\n",
      "Name: 1, dtype: object\n",
      "section     MATH\n",
      "number       221\n",
      "semester       F\n",
      "year           1\n",
      "Name: 2, dtype: object\n",
      "section     RHET\n",
      "number       105\n",
      "semester       F\n",
      "year           1\n",
      "Name: 3, dtype: object\n",
      "section     ENG\n",
      "number      100\n",
      "semester      F\n",
      "year          1\n",
      "Name: 4, dtype: object\n",
      "section     ECE\n",
      "number      110\n",
      "semester      F\n",
      "year          1\n",
      "Name: 5, dtype: object\n",
      "section     ECE\n",
      "number      120\n",
      "semester      S\n",
      "year          1\n",
      "Name: 6, dtype: object\n",
      "section     MATH\n",
      "number       231\n",
      "semester       S\n",
      "year           1\n",
      "Name: 7, dtype: object\n",
      "section     ECON\n",
      "number       102\n",
      "semester       S\n",
      "year           1\n",
      "Name: 8, dtype: object\n",
      "section     PHYS\n",
      "number       211\n",
      "semester       S\n",
      "year           1\n",
      "Name: 9, dtype: object\n",
      "section     PSYC\n",
      "number       100\n",
      "semester       S\n",
      "year           1\n",
      "Name: 10, dtype: object\n",
      "section     MATH\n",
      "number       241\n",
      "semester       F\n",
      "year           2\n",
      "Name: 11, dtype: object\n",
      "section     PHYS\n",
      "number       212\n",
      "semester       F\n",
      "year           2\n",
      "Name: 12, dtype: object\n",
      "section     ECE\n",
      "number      220\n",
      "semester      F\n",
      "year          2\n",
      "Name: 13, dtype: object\n",
      "section     HIST\n",
      "number       100\n",
      "semester       F\n",
      "year           2\n",
      "Name: 14, dtype: object\n",
      "section     PHYS\n",
      "number       213\n",
      "semester       S\n",
      "year           2\n",
      "Name: 15, dtype: object\n",
      "section     PHYS\n",
      "number       214\n",
      "semester       S\n",
      "year           2\n",
      "Name: 16, dtype: object\n",
      "section     ECE\n",
      "number      210\n",
      "semester      S\n",
      "year          2\n",
      "Name: 17, dtype: object\n",
      "section     MATH\n",
      "number       286\n",
      "semester       S\n",
      "year           2\n",
      "Name: 18, dtype: object\n",
      "section     ECON\n",
      "number       103\n",
      "semester       S\n",
      "year           2\n",
      "Name: 19, dtype: object\n",
      "section     ECE\n",
      "number      313\n",
      "semester      F\n",
      "year          3\n",
      "Name: 20, dtype: object\n",
      "section     ECE\n",
      "number      329\n",
      "semester      F\n",
      "year          3\n",
      "Name: 21, dtype: object\n",
      "section     HIST\n",
      "number       172\n",
      "semester       F\n",
      "year           3\n",
      "Name: 22, dtype: object\n",
      "section     ECE\n",
      "number      415\n",
      "semester      F\n",
      "year          3\n",
      "Name: 23, dtype: object\n",
      "section     ECE\n",
      "number      422\n",
      "semester      F\n",
      "year          3\n",
      "Name: 24, dtype: object\n",
      "section     ECE\n",
      "number      340\n",
      "semester      S\n",
      "year          3\n",
      "Name: 25, dtype: object\n",
      "section     ECE\n",
      "number      385\n",
      "semester      S\n",
      "year          3\n",
      "Name: 26, dtype: object\n",
      "section     ECE\n",
      "number      418\n",
      "semester      S\n",
      "year          3\n",
      "Name: 27, dtype: object\n",
      "section     ECE\n",
      "number      463\n",
      "semester      S\n",
      "year          3\n",
      "Name: 28, dtype: object\n",
      "section     HIST\n",
      "number       106\n",
      "semester       S\n",
      "year           3\n",
      "Name: 29, dtype: object\n",
      "section     ECE\n",
      "number      445\n",
      "semester      F\n",
      "year          4\n",
      "Name: 30, dtype: object\n",
      "section     ECE\n",
      "number      428\n",
      "semester      F\n",
      "year          4\n",
      "Name: 31, dtype: object\n",
      "section     ECE\n",
      "number      402\n",
      "semester      F\n",
      "year          4\n",
      "Name: 32, dtype: object\n",
      "section     ECE\n",
      "number      476\n",
      "semester      F\n",
      "year          4\n",
      "Name: 33, dtype: object\n",
      "section     MATH\n",
      "number       461\n",
      "semester       F\n",
      "year           4\n",
      "Name: 34, dtype: object\n",
      "section     ECE\n",
      "number      498\n",
      "semester      S\n",
      "year          4\n",
      "Name: 35, dtype: object\n",
      "section     ECE\n",
      "number      391\n",
      "semester      S\n",
      "year          4\n",
      "Name: 36, dtype: object\n",
      "section     ECE\n",
      "number      403\n",
      "semester      S\n",
      "year          4\n",
      "Name: 37, dtype: object\n",
      "section     ECE\n",
      "number      411\n",
      "semester      S\n",
      "year          4\n",
      "Name: 38, dtype: object\n",
      "section     ECE\n",
      "number      414\n",
      "semester      S\n",
      "year          4\n",
      "Name: 39, dtype: object\n",
      "section     CHEM\n",
      "number       102\n",
      "semester       F\n",
      "year           1\n",
      "Name: 0, dtype: object\n",
      "section     CHEM\n",
      "number       103\n",
      "semester       F\n",
      "year           1\n",
      "Name: 1, dtype: object\n",
      "section     MATH\n",
      "number       221\n",
      "semester       F\n",
      "year           1\n",
      "Name: 2, dtype: object\n",
      "section     RHET\n",
      "number       105\n",
      "semester       F\n",
      "year           1\n",
      "Name: 3, dtype: object\n",
      "section      CS\n",
      "number      100\n",
      "semester      F\n",
      "year          1\n",
      "Name: 4, dtype: object\n",
      "section      CS\n",
      "number      125\n",
      "semester      F\n",
      "year          1\n",
      "Name: 5, dtype: object\n",
      "section     ENG\n",
      "number      100\n",
      "semester      F\n",
      "year          1\n",
      "Name: 6, dtype: object\n",
      "section      CS\n",
      "number      173\n",
      "semester      S\n",
      "year          1\n",
      "Name: 7, dtype: object\n",
      "section     MATH\n",
      "number       231\n",
      "semester       S\n",
      "year           1\n",
      "Name: 8, dtype: object\n",
      "section     ECON\n",
      "number       102\n",
      "semester       S\n",
      "year           1\n",
      "Name: 9, dtype: object\n",
      "section     PHYS\n",
      "number       211\n",
      "semester       S\n",
      "year           1\n",
      "Name: 10, dtype: object\n",
      "section     PSYC\n",
      "number       100\n",
      "semester       S\n",
      "year           1\n",
      "Name: 11, dtype: object\n",
      "section      CS\n",
      "number      225\n",
      "semester      F\n",
      "year          2\n",
      "Name: 12, dtype: object\n",
      "section     MATH\n",
      "number       241\n",
      "semester       F\n",
      "year           2\n",
      "Name: 13, dtype: object\n",
      "section     PHYS\n",
      "number       212\n",
      "semester       F\n",
      "year           2\n",
      "Name: 14, dtype: object\n",
      "section     HIST\n",
      "number       100\n",
      "semester       F\n",
      "year           2\n",
      "Name: 15, dtype: object\n",
      "section      CS\n",
      "number      241\n",
      "semester      S\n",
      "year          2\n",
      "Name: 16, dtype: object\n",
      "section      CS\n",
      "number      233\n",
      "semester      S\n",
      "year          2\n",
      "Name: 17, dtype: object\n",
      "section     MATH\n",
      "number       415\n",
      "semester       S\n",
      "year           2\n",
      "Name: 18, dtype: object\n",
      "section     PHYS\n",
      "number       214\n",
      "semester       S\n",
      "year           2\n",
      "Name: 19, dtype: object\n",
      "section     HIST\n",
      "number       120\n",
      "semester       S\n",
      "year           2\n",
      "Name: 20, dtype: object\n",
      "section      CS\n",
      "number      210\n",
      "semester      F\n",
      "year          3\n",
      "Name: 21, dtype: object\n",
      "section      CS\n",
      "number      242\n",
      "semester      F\n",
      "year          3\n",
      "Name: 22, dtype: object\n",
      "section      CS\n",
      "number      498\n",
      "semester      F\n",
      "year          3\n",
      "Name: 23, dtype: object\n",
      "section     HIST\n",
      "number       172\n",
      "semester       F\n",
      "year           3\n",
      "Name: 24, dtype: object\n",
      "section     ECON\n",
      "number       103\n",
      "semester       F\n",
      "year           3\n",
      "Name: 25, dtype: object\n",
      "section     STAT\n",
      "number       400\n",
      "semester       S\n",
      "year           3\n",
      "Name: 26, dtype: object\n",
      "section      CS\n",
      "number      418\n",
      "semester      S\n",
      "year          3\n",
      "Name: 27, dtype: object\n",
      "section      CS\n",
      "number      465\n",
      "semester      S\n",
      "year          3\n",
      "Name: 28, dtype: object\n",
      "section      CS\n",
      "number      411\n",
      "semester      S\n",
      "year          3\n",
      "Name: 29, dtype: object\n",
      "section      CS\n",
      "number      357\n",
      "semester      S\n",
      "year          3\n",
      "Name: 30, dtype: object\n",
      "section      CS\n",
      "number      421\n",
      "semester      F\n",
      "year          4\n",
      "Name: 31, dtype: object\n",
      "section      CS\n",
      "number      440\n",
      "semester      F\n",
      "year          4\n",
      "Name: 32, dtype: object\n",
      "section      CS\n",
      "number      461\n",
      "semester      F\n",
      "year          4\n",
      "Name: 33, dtype: object\n",
      "section      CS\n",
      "number      492\n",
      "semester      F\n",
      "year          4\n",
      "Name: 34, dtype: object\n",
      "section      CS\n",
      "number      493\n",
      "semester      S\n",
      "year          4\n",
      "Name: 35, dtype: object\n",
      "section      CS\n",
      "number      467\n",
      "semester      S\n",
      "year          4\n",
      "Name: 36, dtype: object\n",
      "section      CS\n",
      "number      412\n",
      "semester      S\n",
      "year          4\n",
      "Name: 37, dtype: object\n",
      "section     MATH\n",
      "number       461\n",
      "semester       S\n",
      "year           4\n",
      "Name: 38, dtype: object\n",
      "section      CS\n",
      "number      412\n",
      "semester      S\n",
      "year          4\n",
      "Name: 39, dtype: object\n"
     ]
    }
   ],
   "source": [
    "for major in majors:\n",
    "    path = txt_directory + major + addendum + csv_ending\n",
    "    df = pd.read_csv(path, header=0)\n",
    "    for i in range(1, 5):\n",
    "        df_year = df.where(df['year'] == i).dropna()\n",
    "        classes[i] = dict()\n",
    "        for s in ['F', 'S']:\n",
    "            df_year_s = df_year.where(df['semester'] == s).dropna()\n",
    "            classes[i][s] = []\n",
    "            for index, row in df_year_s.iterrows():\n",
    "                print(row)\n",
    "                c = dict()\n",
    "                c['section'] = row['section']\n",
    "                c['number'] = row['number']\n",
    "                classes[i][s].append(c)\n",
    "    j_path = json_directory + major + addendum + json_ending\n",
    "    with open(j_path, 'w') as jsonfile:\n",
    "        json.dump(classes, jsonfile)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "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.5.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}