usp-alloc.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from z3 import *\n",
    "from time import time\n",
    "from copy import copy\n",
    "\n",
    "floors = set(range(4, 22))\n",
    "\n",
    "male_floors = set([8, 10, 16, 19])\n",
    "female_floors = set([7, 14, 18, 20])\n",
    "mixed_floors = floors.difference(male_floors).difference(female_floors)\n",
    "\n",
    "rf_floors = set(range(5, 22, 4))\n",
    "laundry_floors = set([9, 17])\n",
    "\n",
    "freshmen_floors = set([6, 8, 11, 14, 16, 17, 20])\n",
    "senior_floors = floors.difference(freshmen_floors)\n",
    "\n",
    "corridor_nonaircon_pos = set(map(str, range(101, 107) + range(115, 120)))\n",
    "corridor_aircon_pos = set(map(str, range(109, 115)))\n",
    "suite_room_letters = map(lambda x: chr(ord('A') + x), range(6))\n",
    "suite_nonaircon_pos = set([str(suite_num) + letter for suite_num in [100, 107] for letter in suite_room_letters])\n",
    "suite_aircon_pos = set([str(suite_num) + letter for suite_num in [108] for letter in suite_room_letters])\n",
    "aircon_pos = corridor_aircon_pos.union(suite_aircon_pos)\n",
    "nonaircon_pos = corridor_nonaircon_pos.union(suite_nonaircon_pos)\n",
    "corridor_pos = corridor_nonaircon_pos.union(corridor_aircon_pos)\n",
    "suite_room_pos = suite_nonaircon_pos.union(suite_aircon_pos)\n",
    "absent_laundry_pos = set(map(str, range(103, 107)))\n",
    "room_pos = corridor_pos.union(suite_room_pos)\n",
    "\n",
    "def get_valid_floors(is_male, pref_mixed, is_freshmen):\n",
    "    gender_floors = male_floors if is_male else female_floors\n",
    "    gender_floors = gender_floors.union(mixed_floors) if pref_mixed else gender_floors\n",
    "    seniority_floors = freshmen_floors if is_freshmen else senior_floors\n",
    "    return gender_floors.intersection(seniority_floors)\n",
    "\n",
    "def get_valid_pos(floor_num, is_suite, is_aircon):\n",
    "    pos = room_pos\n",
    "    pos = pos.difference(corridor_pos) if is_suite else pos.difference(suite_room_pos)\n",
    "    pos = pos.difference(nonaircon_pos) if is_aircon else pos.difference(aircon_pos)\n",
    "        \n",
    "    if floor_num not in floors:\n",
    "        pos = pos.difference(room_pos)\n",
    "        \n",
    "    if floor_num in rf_floors:\n",
    "        pos = pos.difference(suite_aircon_pos)\n",
    "    \n",
    "    if floor_num in laundry_floors:\n",
    "        pos = pos.difference(absent_laundry_pos)\n",
    "\n",
    "    return pos\n",
    "\n",
    "def get_valid_rooms(is_male=True, pref_mixed=False, is_freshmen=False, is_suite=True, is_aircon=False):\n",
    "    valid_floors = get_valid_floors(is_male, pref_mixed, is_freshmen)\n",
    "    valid_rooms = [str(floor_num) + '-' + pos for floor_num in valid_floors for pos in get_valid_pos(floor_num, is_suite, is_aircon)]    \n",
    "    return set(valid_rooms)\n",
    "\n",
    "def get_all_rooms():\n",
    "    rooms = []\n",
    "    for floor_num in floors:\n",
    "        if floor_num in laundry_floors:\n",
    "            rooms.extend([str(floor_num) + '-' + pos for pos in room_pos.difference(absent_laundry_pos)])\n",
    "        elif floor_num in rf_floors:\n",
    "            rooms.extend([str(floor_num) + '-' + pos for pos in room_pos.difference(suite_aircon_pos)])\n",
    "        else:\n",
    "            rooms.extend([str(floor_num) + '-' + pos for pos in room_pos])\n",
    "    return rooms\n",
    "    \n",
    "class Person():\n",
    "    def __init__(self, name, gender, pref_mixed, usp_status, is_suite, is_aircon, floor_pref, room_pref):\n",
    "        self.name = name\n",
    "        self.gender = gender\n",
    "        self.pref_mixed = pref_mixed\n",
    "        self.usp_status = usp_status\n",
    "        self.is_suite = is_suite\n",
    "        self.is_aircon = is_aircon\n",
    "        self.floor_pref = floor_pref\n",
    "        self.room_pref = room_pref\n",
    "    \n",
    "    def __str__(self):\n",
    "        return self.name\n",
    "    \n",
    "    def valid_pos(self):\n",
    "        return get_valid_pos(16,\n",
    "                             self.is_suite == \"suite\",\n",
    "                             self.is_aircon == \"aircon\"\n",
    "                            )\n",
    "        \n",
    "    def valid_floors(self):\n",
    "        return get_valid_floors(self.gender == \"male\",\n",
    "                               self.pref_mixed == \"yes\",\n",
    "                               self.usp_status == \"freshmen\"\n",
    "                               )\n",
    "    \n",
    "    def valid_rooms(self):\n",
    "        return get_valid_rooms(self.gender == \"male\",\n",
    "                               self.pref_mixed == \"yes\",\n",
    "                               self.usp_status == \"freshmen\",\n",
    "                               self.is_suite == \"suite\",\n",
    "                               self.is_aircon == \"aircon\"\n",
    "                              )\n",
    "    \n",
    "    __repr__ = __str__"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "class Person:\n",
    "    def __init__(self, entry_id, gender, person_type):\n",
    "        self.entry_id = entry_id\n",
    "        self.gender = gender\n",
    "        self.person_type = person_type"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "class Room:\n",
    "    def __init__(self, level, position):\n",
    "        self.level = level\n",
    "        self.position = position\n",
    "        self.room_type = RoomType(self.is_suite(), self.is_aircon())\n",
    "        \n",
    "    def __init__(self, room_string):\n",
    "        self.level = room_string.split('-')[0]\n",
    "        self.position = room_string.split('-')[1]\n",
    "        self.room_type = RoomType(self.is_suite(), self.is_aircon())\n",
    "\n",
    "        \n",
    "    def __str__(self):\n",
    "        return str(self.level) + '-' + str(self.position)\n",
    "\n",
    "    def is_aircon(self):\n",
    "        return self.position in aircon_pos\n",
    "    \n",
    "    def is_suite(self):\n",
    "        return self.position in suite_room_pos\n",
    "    \n",
    "    def get_type(self):\n",
    "        return self.room_type.get_attributes()\n",
    "\n",
    "    def get_inverse_type(self):\n",
    "        return self.room_type.get_inverse_attributes()\n",
    "\n",
    "\n",
    "class RoomType:\n",
    "    def __init__(self, is_suite, is_aircon):\n",
    "        self.is_suite = is_suite\n",
    "        self.is_aircon = is_aircon\n",
    "        \n",
    "    # Initialises from description Eg. USP, Single (6 bdrm Apt, Non Air-Con)\n",
    "    @staticmethod \n",
    "    def make_room_type(description):\n",
    "        is_suite = '6 bdrm Apt' in description\n",
    "        is_aircon = 'Non Air-Con' not in description\n",
    "        return RoomType(is_suite, is_aircon)\n",
    "        \n",
    "\n",
    "    def __str__(self):\n",
    "        return 'Suite: {}, Aircon: {} '.format(self.is_suite, self.is_aircon)\n",
    "    \n",
    "    def get_attributes(self):\n",
    "        suite_string = ''\n",
    "        aircon_string = ''\n",
    "        \n",
    "        if self.is_suite:\n",
    "            suite_string = 'suite'\n",
    "        else:\n",
    "            suite_string = 'non-suite'\n",
    "\n",
    "        if self.is_aircon:\n",
    "            aircon_string = 'aircon'\n",
    "        else:\n",
    "            aircon_string = 'non-aircon'\n",
    "\n",
    "        return [suite_string, aircon_string]\n",
    "    \n",
    "    def get_inverse_attributes(self):\n",
    "        suite_string = ''\n",
    "        aircon_string = ''\n",
    "        \n",
    "        if self.is_suite:\n",
    "            suite_string = 'non-suite'\n",
    "        else:\n",
    "            suite_string = 'suite'\n",
    "\n",
    "        if self.is_aircon:\n",
    "            aircon_string = 'non-aircon'\n",
    "        else:\n",
    "            aircon_string = 'aircon'\n",
    "\n",
    "        return [suite_string, aircon_string]\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['suite', 'non-aircon']\n",
      "['non-suite', 'aircon']\n"
     ]
    }
   ],
   "source": [
    "k = Room('4-100C')\n",
    "print k.get_type()\n",
    "print k.get_inverse_type()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "def solve(nrows=None):\n",
    "    input_data_frame = pd.read_csv('data/usprc.csv', nrows=nrows, dtype=object).fillna('').values\n",
    "    constraints = []\n",
    "    standard_implications = []\n",
    "    preferences = []\n",
    "    opt = Optimize()\n",
    "\n",
    "    # Populate people\n",
    "    all_people = []\n",
    "    for row in input_data_frame:\n",
    "        person = Person(*row[:3])\n",
    "        all_people.append(person)\n",
    "        \n",
    "        # Populate First Preferences\n",
    "        preferred_type = RoomType.make_room_type(row[3])\n",
    "        \n",
    "        for room_attribute in preferred_type.get_attributes():\n",
    "            preference_implication = Bool(\"{} gets {}\".format(person.entry_id, room_attribute))\n",
    "            preferences.append(preference_implication)\n",
    "\n",
    "       \n",
    "    # Populate rooms\n",
    "    all_rooms = map(Room, get_all_rooms())\n",
    "        \n",
    "        \n",
    "    # Add obvious implcations\n",
    "    for person in all_people:\n",
    "        gets_suite = Bool(\"{} gets {} room\".format(person.entry_id, 'suite'))\n",
    "        gets_non_suite = Bool(\"{} gets {} room\".format(person.entry_id, 'non-suite'))\n",
    "        \n",
    "        standard_implications.append(Or(gets_suite, gets_non_suite))\n",
    "\n",
    "        gets_aircon = Bool(\"{} gets {} room\".format(person.entry_id, 'aircon'))\n",
    "        gets_non_aircon = Bool(\"{} gets {} room\".format(person.entry_id, 'non-aircon'))\n",
    "        \n",
    "        standard_implications.append(Or(gets_aircon, gets_non_aircon))\n",
    "    \n",
    "    \n",
    "    \n",
    "    # Populate all room possible assignments\n",
    "    assignments = {}\n",
    "    for person in all_people:\n",
    "        assignments[person] = {}\n",
    "\n",
    "        for room in all_rooms:\n",
    "            possibility = Bool(\"{} gets {}\".format(person.entry_id, room))\n",
    "            \n",
    "            # Add possibility to possible assignments\n",
    "            assignments[person][room] = possibility\n",
    "            \n",
    "            # Add the possibility's implication (i.e the person gets this room type etc..)\n",
    "            for attribute in room.get_type():\n",
    "                implication = Bool(\"{} gets {} room\".format(person.entry_id, attribute))\n",
    "                standard_implications.append(Implies(possibility, implication))\n",
    "\n",
    "            for attribute in room.get_inverse_type():\n",
    "                inverse_implication = Bool(\"{} gets {} room\".format(person.entry_id, attribute))\n",
    "                standard_implications.append(Implies(possibility, Not(inverse_implication)))\n",
    "     \n",
    "    # One person can only get one room\n",
    "    for person in all_people:\n",
    "        constraints.append(Or(assignments[person].values()))\n",
    "\n",
    "    # One room can only be assigned to one person\n",
    "    for person in all_people:\n",
    "        for room in all_rooms:\n",
    "            for other_person in all_people:\n",
    "                if other_person == person:\n",
    "                    continue\n",
    "            \n",
    "                implication = Implies(assignments[person][room], Not(assignments[other_person][room]))\n",
    "                constraints.append(implication)\n",
    "            \n",
    "    # Solve\n",
    "    for constraint in constraints:\n",
    "        opt.add(constraint)\n",
    "    \n",
    "    for implication in standard_implications:\n",
    "        opt.add(implication)\n",
    "    \n",
    "    for preference in preferences:\n",
    "        opt.add(preference)\n",
    "        \n",
    "        \n",
    "    opt.check()\n",
    "    model = opt.model()\n",
    "    \n",
    "    all_symbols = [assignments[person][room] for person in all_people for room in all_rooms]\n",
    "    return filter(lambda x: is_true(model.eval(x)), all_symbols)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CPU times: user 9.02 s, sys: 61 ms, total: 9.08 s\n",
      "Wall time: 9.11 s\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[132083 gets 7-108C,\n",
       " 133621 gets 7-108E,\n",
       " 131858 gets 7-108F,\n",
       " 105327 gets 11-108A,\n",
       " 167885 gets 6-108D,\n",
       " 167320 gets 15-108B,\n",
       " 168255 gets 16-108E,\n",
       " 171415 gets 11-108E,\n",
       " 170839 gets 4-108D,\n",
       " 101335 gets 20-108C]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%time solve(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 174,
   "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>Entry ID</th>\n",
       "      <th>Gender Description</th>\n",
       "      <th>Classification Description 9</th>\n",
       "      <th>Room Preference Description 1</th>\n",
       "      <th>Room Preference Description 2</th>\n",
       "      <th>Room Preference Description 3</th>\n",
       "      <th>Room Preference Comments</th>\n",
       "      <th>Floor Gender Preference</th>\n",
       "      <th>Nationality Description 4</th>\n",
       "      <th>PR Status</th>\n",
       "      <th>Admit Term</th>\n",
       "      <th>Enrollment Term</th>\n",
       "      <th>Faculty</th>\n",
       "      <th>Medical</th>\n",
       "      <th>Enrollment Status</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>132083</td>\n",
       "      <td>Male</td>\n",
       "      <td>USP Senior UG</td>\n",
       "      <td>USP, Single (Corridor, Air-Con)</td>\n",
       "      <td>USP, Single (6 bdrm Apt, Air-Con)</td>\n",
       "      <td>USP, Single (6 bdrm Apt, Non Air-Con)</td>\n",
       "      <td>15100</td>\n",
       "      <td>Mixed Gender Floor</td>\n",
       "      <td>SINGAPORE CITIZEN</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>1510</td>\n",
       "      <td>4</td>\n",
       "      <td>ARTS &amp; SOCIAL SCIENCES</td>\n",
       "      <td></td>\n",
       "      <td>CURRENT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>133621</td>\n",
       "      <td>Female</td>\n",
       "      <td>USP Senior UG</td>\n",
       "      <td>USP, Single (Corridor, Non Air-Con)</td>\n",
       "      <td>USP, Single (6 bdrm Apt, Non Air-Con)</td>\n",
       "      <td></td>\n",
       "      <td>#18-103 or #07-103. facing CAPT.</td>\n",
       "      <td>Single Gender Floor</td>\n",
       "      <td>SINGAPORE CITIZEN</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>1510</td>\n",
       "      <td>4</td>\n",
       "      <td>SCIENCE</td>\n",
       "      <td></td>\n",
       "      <td>CURRENT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>131858</td>\n",
       "      <td>Female</td>\n",
       "      <td>USP Senior UG</td>\n",
       "      <td>USP, Single (Corridor, Air-Con)</td>\n",
       "      <td>USP, Single (6 bdrm Apt, Air-Con)</td>\n",
       "      <td></td>\n",
       "      <td>#18-110</td>\n",
       "      <td>Single Gender Floor</td>\n",
       "      <td>SINGAPORE CITIZEN</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>1510</td>\n",
       "      <td>4</td>\n",
       "      <td>ARTS &amp; SOCIAL SCIENCES</td>\n",
       "      <td>Respiratory/breathing difficulties if the air ...</td>\n",
       "      <td>CURRENT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>105327</td>\n",
       "      <td>Male</td>\n",
       "      <td>USP Senior UG</td>\n",
       "      <td>USP, Single (Corridor, Air-Con)</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>#19-113 my current room</td>\n",
       "      <td>Single Gender Floor</td>\n",
       "      <td>Indonesian</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>1410</td>\n",
       "      <td>6</td>\n",
       "      <td>SCIENCE</td>\n",
       "      <td></td>\n",
       "      <td>CURRENT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>167885</td>\n",
       "      <td>Female</td>\n",
       "      <td>USP Senior UG</td>\n",
       "      <td>USP, Single (6 bdrm Apt, Non Air-Con)</td>\n",
       "      <td>USP, Single (6 bdrm Apt, Air-Con)</td>\n",
       "      <td>USP, Single (Corridor, Air-Con)</td>\n",
       "      <td>#feefivefuudfam</td>\n",
       "      <td>No Preference</td>\n",
       "      <td>SINGAPORE CITIZEN</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>1610</td>\n",
       "      <td>2</td>\n",
       "      <td>ARTS &amp; SOCIAL SCIENCES</td>\n",
       "      <td></td>\n",
       "      <td>CURRENT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>167320</td>\n",
       "      <td>Female</td>\n",
       "      <td>USP Senior UG</td>\n",
       "      <td>USP, Single (6 bdrm Apt, Non Air-Con)</td>\n",
       "      <td>USP, Single (6 bdrm Apt, Air-Con)</td>\n",
       "      <td>USP, Single (Corridor, Non Air-Con)</td>\n",
       "      <td>#feefivefuudfam</td>\n",
       "      <td>No Preference</td>\n",
       "      <td>SINGAPORE CITIZEN</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>1610</td>\n",
       "      <td>2</td>\n",
       "      <td>ARTS &amp; SOCIAL SCIENCES</td>\n",
       "      <td></td>\n",
       "      <td>CURRENT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>168255</td>\n",
       "      <td>Female</td>\n",
       "      <td>USP Senior UG</td>\n",
       "      <td>USP, Single (6 bdrm Apt, Non Air-Con)</td>\n",
       "      <td>USP, Single (6 bdrm Apt, Air-Con)</td>\n",
       "      <td>USP, Single (Corridor, Non Air-Con)</td>\n",
       "      <td>#feefivefuudfam</td>\n",
       "      <td>No Preference</td>\n",
       "      <td>SINGAPORE CITIZEN</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>1610</td>\n",
       "      <td>2</td>\n",
       "      <td>ARTS &amp; SOCIAL SCIENCES</td>\n",
       "      <td></td>\n",
       "      <td>CURRENT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>171415</td>\n",
       "      <td>Female</td>\n",
       "      <td>USP Senior UG</td>\n",
       "      <td>USP, Single (6 bdrm Apt, Non Air-Con)</td>\n",
       "      <td>USP, Single (6 bdrm Apt, Air-Con)</td>\n",
       "      <td>USP, Single (Corridor, Non Air-Con)</td>\n",
       "      <td>#feefivefuudfam</td>\n",
       "      <td>No Preference</td>\n",
       "      <td>SINGAPORE CITIZEN</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>1610</td>\n",
       "      <td>2</td>\n",
       "      <td>ARTS &amp; SOCIAL SCIENCES</td>\n",
       "      <td></td>\n",
       "      <td>CURRENT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>170839</td>\n",
       "      <td>Female</td>\n",
       "      <td>USP Senior UG</td>\n",
       "      <td>USP, Single (6 bdrm Apt, Non Air-Con)</td>\n",
       "      <td>USP, Single (Corridor, Non Air-Con)</td>\n",
       "      <td></td>\n",
       "      <td>#feefivefuudfam</td>\n",
       "      <td>No Preference</td>\n",
       "      <td>SINGAPORE CITIZEN</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>1610</td>\n",
       "      <td>2</td>\n",
       "      <td>ARTS &amp; SOCIAL SCIENCES</td>\n",
       "      <td></td>\n",
       "      <td>CURRENT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>101335</td>\n",
       "      <td>Male</td>\n",
       "      <td>USP Senior UG</td>\n",
       "      <td>USP, Single (Corridor, Air-Con)</td>\n",
       "      <td>USP, Single (6 bdrm Apt, Air-Con)</td>\n",
       "      <td></td>\n",
       "      <td>#greenhousebesthouse OR #seniorfloor15</td>\n",
       "      <td>Mixed Gender Floor</td>\n",
       "      <td>SINGAPORE CITIZEN</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>1410</td>\n",
       "      <td>6</td>\n",
       "      <td>ENGINEERING</td>\n",
       "      <td>Nil</td>\n",
       "      <td>CURRENT</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Entry ID Gender Description Classification Description 9  \\\n",
       "0   132083               Male                USP Senior UG   \n",
       "1   133621             Female                USP Senior UG   \n",
       "2   131858             Female                USP Senior UG   \n",
       "3   105327               Male                USP Senior UG   \n",
       "4   167885             Female                USP Senior UG   \n",
       "5   167320             Female                USP Senior UG   \n",
       "6   168255             Female                USP Senior UG   \n",
       "7   171415             Female                USP Senior UG   \n",
       "8   170839             Female                USP Senior UG   \n",
       "9   101335               Male                USP Senior UG   \n",
       "\n",
       "           Room Preference Description 1  \\\n",
       "0        USP, Single (Corridor, Air-Con)   \n",
       "1    USP, Single (Corridor, Non Air-Con)   \n",
       "2        USP, Single (Corridor, Air-Con)   \n",
       "3        USP, Single (Corridor, Air-Con)   \n",
       "4  USP, Single (6 bdrm Apt, Non Air-Con)   \n",
       "5  USP, Single (6 bdrm Apt, Non Air-Con)   \n",
       "6  USP, Single (6 bdrm Apt, Non Air-Con)   \n",
       "7  USP, Single (6 bdrm Apt, Non Air-Con)   \n",
       "8  USP, Single (6 bdrm Apt, Non Air-Con)   \n",
       "9        USP, Single (Corridor, Air-Con)   \n",
       "\n",
       "           Room Preference Description 2  \\\n",
       "0      USP, Single (6 bdrm Apt, Air-Con)   \n",
       "1  USP, Single (6 bdrm Apt, Non Air-Con)   \n",
       "2      USP, Single (6 bdrm Apt, Air-Con)   \n",
       "3                                          \n",
       "4      USP, Single (6 bdrm Apt, Air-Con)   \n",
       "5      USP, Single (6 bdrm Apt, Air-Con)   \n",
       "6      USP, Single (6 bdrm Apt, Air-Con)   \n",
       "7      USP, Single (6 bdrm Apt, Air-Con)   \n",
       "8    USP, Single (Corridor, Non Air-Con)   \n",
       "9      USP, Single (6 bdrm Apt, Air-Con)   \n",
       "\n",
       "           Room Preference Description 3  \\\n",
       "0  USP, Single (6 bdrm Apt, Non Air-Con)   \n",
       "1                                          \n",
       "2                                          \n",
       "3                                          \n",
       "4        USP, Single (Corridor, Air-Con)   \n",
       "5    USP, Single (Corridor, Non Air-Con)   \n",
       "6    USP, Single (Corridor, Non Air-Con)   \n",
       "7    USP, Single (Corridor, Non Air-Con)   \n",
       "8                                          \n",
       "9                                          \n",
       "\n",
       "                 Room Preference Comments Floor Gender Preference  \\\n",
       "0                                   15100      Mixed Gender Floor   \n",
       "1        #18-103 or #07-103. facing CAPT.     Single Gender Floor   \n",
       "2                                 #18-110     Single Gender Floor   \n",
       "3                 #19-113 my current room     Single Gender Floor   \n",
       "4                         #feefivefuudfam           No Preference   \n",
       "5                         #feefivefuudfam           No Preference   \n",
       "6                         #feefivefuudfam           No Preference   \n",
       "7                         #feefivefuudfam           No Preference   \n",
       "8                         #feefivefuudfam           No Preference   \n",
       "9  #greenhousebesthouse OR #seniorfloor15      Mixed Gender Floor   \n",
       "\n",
       "  Nationality Description 4 PR Status Admit Term Enrollment Term  \\\n",
       "0         SINGAPORE CITIZEN     FALSE       1510               4   \n",
       "1         SINGAPORE CITIZEN     FALSE       1510               4   \n",
       "2         SINGAPORE CITIZEN     FALSE       1510               4   \n",
       "3                Indonesian     FALSE       1410               6   \n",
       "4         SINGAPORE CITIZEN     FALSE       1610               2   \n",
       "5         SINGAPORE CITIZEN     FALSE       1610               2   \n",
       "6         SINGAPORE CITIZEN     FALSE       1610               2   \n",
       "7         SINGAPORE CITIZEN     FALSE       1610               2   \n",
       "8         SINGAPORE CITIZEN     FALSE       1610               2   \n",
       "9         SINGAPORE CITIZEN     FALSE       1410               6   \n",
       "\n",
       "                  Faculty                                            Medical  \\\n",
       "0  ARTS & SOCIAL SCIENCES                                                      \n",
       "1                 SCIENCE                                                      \n",
       "2  ARTS & SOCIAL SCIENCES  Respiratory/breathing difficulties if the air ...   \n",
       "3                 SCIENCE                                                      \n",
       "4  ARTS & SOCIAL SCIENCES                                                      \n",
       "5  ARTS & SOCIAL SCIENCES                                                      \n",
       "6  ARTS & SOCIAL SCIENCES                                                      \n",
       "7  ARTS & SOCIAL SCIENCES                                                      \n",
       "8  ARTS & SOCIAL SCIENCES                                                      \n",
       "9             ENGINEERING                                                Nil   \n",
       "\n",
       "  Enrollment Status  \n",
       "0           CURRENT  \n",
       "1           CURRENT  \n",
       "2           CURRENT  \n",
       "3           CURRENT  \n",
       "4           CURRENT  \n",
       "5           CURRENT  \n",
       "6           CURRENT  \n",
       "7           CURRENT  \n",
       "8           CURRENT  \n",
       "9           CURRENT  "
      ]
     },
     "execution_count": 174,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_csv('data/usprc.csv', nrows=10, dtype=object).fillna('')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}