Courses.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Shivam\\Anaconda3\\lib\\site-packages\\IPython\\core\\interactiveshell.py:3020: DtypeWarning: Columns (14) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    }
   ],
   "source": [
    "edu_courses=pd.read_csv(r\"C:\\Users\\Shivam\\Desktop\\Mini project\\2015_16\\2015_16_educational_institution_course.csv\")\n",
    "course=pd.read_csv(r\"C:\\Users\\Shivam\\Desktop\\Mini project\\2015_16\\2015_16_course.csv\")\n",
    "broad_disc=pd.read_csv(r\"C:\\Users\\Shivam\\Desktop\\Mini project\\2015_16\\2015_16_ref_broad_discipline_group.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['institution_category', 'institution_id', 'state_code', 'faculty_id', 'department_id', 'course_id', 'survey_year']\n",
      "['University' 'College Institution' 'Standalone Institution']\n"
     ]
    }
   ],
   "source": [
    "print(list(edu_courses.columns))\n",
    "print(edu_courses.institution_category.unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "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>institution_category</th>\n",
       "      <th>institution_id</th>\n",
       "      <th>state_code</th>\n",
       "      <th>course_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>34510</th>\n",
       "      <td>College Institution</td>\n",
       "      <td>13438</td>\n",
       "      <td>9</td>\n",
       "      <td>1071979</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34511</th>\n",
       "      <td>College Institution</td>\n",
       "      <td>13438</td>\n",
       "      <td>9</td>\n",
       "      <td>1071978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34512</th>\n",
       "      <td>College Institution</td>\n",
       "      <td>13438</td>\n",
       "      <td>9</td>\n",
       "      <td>1071977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34513</th>\n",
       "      <td>College Institution</td>\n",
       "      <td>13438</td>\n",
       "      <td>9</td>\n",
       "      <td>1071976</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34514</th>\n",
       "      <td>College Institution</td>\n",
       "      <td>55446</td>\n",
       "      <td>20</td>\n",
       "      <td>1072024</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      institution_category  institution_id  state_code  course_id\n",
       "34510  College Institution           13438           9    1071979\n",
       "34511  College Institution           13438           9    1071978\n",
       "34512  College Institution           13438           9    1071977\n",
       "34513  College Institution           13438           9    1071976\n",
       "34514  College Institution           55446          20    1072024"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "edu_courses=edu_courses.drop(['faculty_id', 'department_id','survey_year'],axis=1)\n",
    "col_inst_course=edu_courses[edu_courses['institution_category']=='College Institution']\n",
    "col_inst_course.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>mode_id</th>\n",
       "      <th>only_through_colleges</th>\n",
       "      <th>level_id</th>\n",
       "      <th>programme_id</th>\n",
       "      <th>discipline</th>\n",
       "      <th>broad_discipline_group</th>\n",
       "      <th>intake</th>\n",
       "      <th>no_of_applicants</th>\n",
       "      <th>duration_year</th>\n",
       "      <th>duration_month</th>\n",
       "      <th>type_id</th>\n",
       "      <th>examination_system_id</th>\n",
       "      <th>approving_statutory_body_id</th>\n",
       "      <th>approving_university_id</th>\n",
       "      <th>broad_discipline_group_category_id</th>\n",
       "      <th>admission_criterion_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>949531</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>157</td>\n",
       "      <td>Horticulture</td>\n",
       "      <td>5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>949532</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>3</td>\n",
       "      <td>111</td>\n",
       "      <td>Horticulture</td>\n",
       "      <td>5</td>\n",
       "      <td>51.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>949533</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>6</td>\n",
       "      <td>82</td>\n",
       "      <td>Horticulture</td>\n",
       "      <td>5</td>\n",
       "      <td>99.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>949534</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>180</td>\n",
       "      <td>Horticuture</td>\n",
       "      <td>107</td>\n",
       "      <td>187.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>957860</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>8</td>\n",
       "      <td>39</td>\n",
       "      <td>Law</td>\n",
       "      <td>52</td>\n",
       "      <td>144.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       id  mode_id  only_through_colleges  level_id  programme_id  \\\n",
       "0  949531        1                  False         1           157   \n",
       "1  949532        1                  False         3           111   \n",
       "2  949533        1                  False         6            82   \n",
       "3  949534        1                  False         4           180   \n",
       "4  957860        1                  False         8            39   \n",
       "\n",
       "     discipline  broad_discipline_group  intake  no_of_applicants  \\\n",
       "0  Horticulture                       5     8.0               NaN   \n",
       "1  Horticulture                       5    51.0               NaN   \n",
       "2  Horticulture                       5    99.0               NaN   \n",
       "3   Horticuture                     107   187.0               NaN   \n",
       "4           Law                      52   144.0               NaN   \n",
       "\n",
       "   duration_year  duration_month  type_id  examination_system_id  \\\n",
       "0              3               0        1                      2   \n",
       "1              2               0        1                      2   \n",
       "2              2               0        1                      2   \n",
       "3              4               0        1                      2   \n",
       "4              5               0        2                      2   \n",
       "\n",
       "   approving_statutory_body_id approving_university_id  \\\n",
       "0                          NaN                     NaN   \n",
       "1                          NaN                     NaN   \n",
       "2                          NaN                     NaN   \n",
       "3                          NaN                     NaN   \n",
       "4                          NaN                     NaN   \n",
       "\n",
       "   broad_discipline_group_category_id  admission_criterion_id  \n",
       "0                                   1                     NaN  \n",
       "1                                   1                     NaN  \n",
       "2                                   1                     NaN  \n",
       "3                                  24                     NaN  \n",
       "4                                  15                     1.0  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "course=pd.read_csv(r\"C:\\Users\\Shivam\\Desktop\\Mini project\\2015_16\\2015_16_course.csv\")\n",
    "course.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "course=course.drop(['mode_id','only_through_colleges','level_id','discipline','no_of_applicants','duration_month','type_id','examination_system_id','approving_statutory_body_id','approving_university_id','admission_criterion_id'],axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['id',\n",
       " 'programme_id',\n",
       " 'broad_discipline_group',\n",
       " 'intake',\n",
       " 'duration_year',\n",
       " 'broad_discipline_group_category_id']"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(course.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "course.columns=['course_id',\n",
    " 'programme_id',\n",
    " 'broad_discipline_group_id',\n",
    " 'intake',\n",
    " 'duration_year',\n",
    " 'broad_discipline_group_category_id']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>category_id</th>\n",
       "      <th>discipline_group</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3</td>\n",
       "      <td>31</td>\n",
       "      <td>Fisheries Science</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7</td>\n",
       "      <td>34</td>\n",
       "      <td>Veterinary &amp; Animal Sciences</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>120</td>\n",
       "      <td>34</td>\n",
       "      <td>Dairy Science</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>121</td>\n",
       "      <td>3</td>\n",
       "      <td>Foreign Trade</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>122</td>\n",
       "      <td>7</td>\n",
       "      <td>Aeronautical Engineering</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    id  category_id              discipline_group\n",
       "0    3           31             Fisheries Science\n",
       "1    7           34  Veterinary & Animal Sciences\n",
       "2  120           34                 Dairy Science\n",
       "3  121            3                 Foreign Trade\n",
       "4  122            7      Aeronautical Engineering"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "broad_disc.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "broad_disc=broad_disc.drop(['category_id'],axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "broad_disc.columns=['broad_discipline_group_id','discipline_group']\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>course_id</th>\n",
       "      <th>programme_id</th>\n",
       "      <th>broad_discipline_group_id</th>\n",
       "      <th>intake</th>\n",
       "      <th>duration_year</th>\n",
       "      <th>broad_discipline_group_category_id</th>\n",
       "      <th>discipline_group</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>949531</td>\n",
       "      <td>157</td>\n",
       "      <td>5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>Horticulture</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>949532</td>\n",
       "      <td>111</td>\n",
       "      <td>5</td>\n",
       "      <td>51.0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Horticulture</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>949533</td>\n",
       "      <td>82</td>\n",
       "      <td>5</td>\n",
       "      <td>99.0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Horticulture</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1047300</td>\n",
       "      <td>155</td>\n",
       "      <td>5</td>\n",
       "      <td>51.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Horticulture</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1005659</td>\n",
       "      <td>111</td>\n",
       "      <td>5</td>\n",
       "      <td>25.0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Horticulture</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   course_id  programme_id  broad_discipline_group_id  intake  duration_year  \\\n",
       "0     949531           157                          5     8.0              3   \n",
       "1     949532           111                          5    51.0              2   \n",
       "2     949533            82                          5    99.0              2   \n",
       "3    1047300           155                          5    51.0              1   \n",
       "4    1005659           111                          5    25.0              2   \n",
       "\n",
       "   broad_discipline_group_category_id discipline_group  \n",
       "0                                   1     Horticulture  \n",
       "1                                   1     Horticulture  \n",
       "2                                   1     Horticulture  \n",
       "3                                   1     Horticulture  \n",
       "4                                   1     Horticulture  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "m_course=pd.merge(course,broad_disc,on='broad_discipline_group_id',how='inner')\n",
    "m_course.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "m_col_inst_course=pd.merge(col_inst_course,m_course,on='course_id',how='inner')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['institution_category',\n",
       " 'institution_id',\n",
       " 'state_code',\n",
       " 'course_id',\n",
       " 'programme_id',\n",
       " 'broad_discipline_group_id',\n",
       " 'intake',\n",
       " 'duration_year',\n",
       " 'broad_discipline_group_category_id',\n",
       " 'discipline_group']"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "m_col_inst_course.head()\n",
    "list(m_col_inst_course.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "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>institution_category</th>\n",
       "      <th>college_institution_id</th>\n",
       "      <th>state_code</th>\n",
       "      <th>course_id</th>\n",
       "      <th>programme_id</th>\n",
       "      <th>broad_discipline_group_id</th>\n",
       "      <th>intake</th>\n",
       "      <th>duration_year</th>\n",
       "      <th>broad_discipline_group_category_id</th>\n",
       "      <th>discipline_group</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>College Institution</td>\n",
       "      <td>13438</td>\n",
       "      <td>9</td>\n",
       "      <td>1071979</td>\n",
       "      <td>182</td>\n",
       "      <td>12</td>\n",
       "      <td>50.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Education</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>College Institution</td>\n",
       "      <td>13438</td>\n",
       "      <td>9</td>\n",
       "      <td>1071978</td>\n",
       "      <td>30</td>\n",
       "      <td>171</td>\n",
       "      <td>480.0</td>\n",
       "      <td>3</td>\n",
       "      <td>24</td>\n",
       "      <td>Science</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>College Institution</td>\n",
       "      <td>13438</td>\n",
       "      <td>9</td>\n",
       "      <td>1071977</td>\n",
       "      <td>12</td>\n",
       "      <td>9</td>\n",
       "      <td>240.0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>Commerce</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>College Institution</td>\n",
       "      <td>13438</td>\n",
       "      <td>9</td>\n",
       "      <td>1071976</td>\n",
       "      <td>17</td>\n",
       "      <td>12</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>Education</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>College Institution</td>\n",
       "      <td>55446</td>\n",
       "      <td>20</td>\n",
       "      <td>1072024</td>\n",
       "      <td>17</td>\n",
       "      <td>12</td>\n",
       "      <td>100.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Education</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  institution_category  college_institution_id  state_code  course_id  \\\n",
       "0  College Institution                   13438           9    1071979   \n",
       "1  College Institution                   13438           9    1071978   \n",
       "2  College Institution                   13438           9    1071977   \n",
       "3  College Institution                   13438           9    1071976   \n",
       "4  College Institution                   55446          20    1072024   \n",
       "\n",
       "   programme_id  broad_discipline_group_id  intake  duration_year  \\\n",
       "0           182                         12    50.0              2   \n",
       "1            30                        171   480.0              3   \n",
       "2            12                          9   240.0              3   \n",
       "3            17                         12   100.0              1   \n",
       "4            17                         12   100.0              2   \n",
       "\n",
       "   broad_discipline_group_category_id discipline_group  \n",
       "0                                   6        Education  \n",
       "1                                  24          Science  \n",
       "2                                   3         Commerce  \n",
       "3                                   6        Education  \n",
       "4                                   6        Education  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#col_courses={'college_institution_id':[],'courses':[]}\n",
    "\n",
    "m_col_inst_course.columns=['institution_category',\n",
    " 'college_institution_id',\n",
    " 'state_code',\n",
    " 'course_id',\n",
    " 'programme_id',\n",
    " 'broad_discipline_group_id',\n",
    " 'intake',\n",
    " 'duration_year',\n",
    " 'broad_discipline_group_category_id',\n",
    " 'discipline_group']\n",
    "m_col_inst_course.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "35187"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "col_inst_ids=list(m_col_inst_course.college_institution_id.unique())\n",
    "len(col_inst_ids)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>discipline_group_category</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Agriculture</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Area Studies</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Commerce</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Criminology &amp; Forensic Science</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Defence Studies</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id       discipline_group_category\n",
       "0   1                     Agriculture\n",
       "1   2                    Area Studies\n",
       "2   3                        Commerce\n",
       "3   4  Criminology & Forensic Science\n",
       "4   5                 Defence Studies"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "broad_disc_category=pd.read_csv(r\"C:\\Users\\Shivam\\Desktop\\Mini project\\2015_16\\2015_16_ref_broad_discipline_group_category.csv\")\n",
    "broad_disc_category.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "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>broad_discipline_group_category_id</th>\n",
       "      <th>discipline_group_category</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Agriculture</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Area Studies</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Commerce</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Criminology &amp; Forensic Science</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Defence Studies</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   broad_discipline_group_category_id       discipline_group_category\n",
       "0                                   1                     Agriculture\n",
       "1                                   2                    Area Studies\n",
       "2                                   3                        Commerce\n",
       "3                                   4  Criminology & Forensic Science\n",
       "4                                   5                 Defence Studies"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "broad_disc_category.columns=['broad_discipline_group_category_id','discipline_group_category']\n",
    "broad_disc_category.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "m_col_inst_course=pd.merge(m_col_inst_course,broad_disc_category,on='broad_discipline_group_category_id',how='inner')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "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>institution_category</th>\n",
       "      <th>college_institution_id</th>\n",
       "      <th>state_code</th>\n",
       "      <th>course_id</th>\n",
       "      <th>programme_id</th>\n",
       "      <th>broad_discipline_group_id</th>\n",
       "      <th>intake</th>\n",
       "      <th>duration_year</th>\n",
       "      <th>broad_discipline_group_category_id</th>\n",
       "      <th>discipline_group</th>\n",
       "      <th>discipline_group_category</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>College Institution</td>\n",
       "      <td>13438</td>\n",
       "      <td>9</td>\n",
       "      <td>1071979</td>\n",
       "      <td>182</td>\n",
       "      <td>12</td>\n",
       "      <td>50.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Education</td>\n",
       "      <td>Education</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>College Institution</td>\n",
       "      <td>13438</td>\n",
       "      <td>9</td>\n",
       "      <td>1071976</td>\n",
       "      <td>17</td>\n",
       "      <td>12</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>Education</td>\n",
       "      <td>Education</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>College Institution</td>\n",
       "      <td>55446</td>\n",
       "      <td>20</td>\n",
       "      <td>1072024</td>\n",
       "      <td>17</td>\n",
       "      <td>12</td>\n",
       "      <td>100.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Education</td>\n",
       "      <td>Education</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>College Institution</td>\n",
       "      <td>15282</td>\n",
       "      <td>9</td>\n",
       "      <td>1073618</td>\n",
       "      <td>17</td>\n",
       "      <td>12</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>Education</td>\n",
       "      <td>Education</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>College Institution</td>\n",
       "      <td>54842</td>\n",
       "      <td>9</td>\n",
       "      <td>1073725</td>\n",
       "      <td>17</td>\n",
       "      <td>12</td>\n",
       "      <td>100.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Education</td>\n",
       "      <td>Education</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  institution_category  college_institution_id  state_code  course_id  \\\n",
       "0  College Institution                   13438           9    1071979   \n",
       "1  College Institution                   13438           9    1071976   \n",
       "2  College Institution                   55446          20    1072024   \n",
       "3  College Institution                   15282           9    1073618   \n",
       "4  College Institution                   54842           9    1073725   \n",
       "\n",
       "   programme_id  broad_discipline_group_id  intake  duration_year  \\\n",
       "0           182                         12    50.0              2   \n",
       "1            17                         12   100.0              1   \n",
       "2            17                         12   100.0              2   \n",
       "3            17                         12   100.0              1   \n",
       "4            17                         12   100.0              2   \n",
       "\n",
       "   broad_discipline_group_category_id discipline_group  \\\n",
       "0                                   6        Education   \n",
       "1                                   6        Education   \n",
       "2                                   6        Education   \n",
       "3                                   6        Education   \n",
       "4                                   6        Education   \n",
       "\n",
       "  discipline_group_category  \n",
       "0                 Education  \n",
       "1                 Education  \n",
       "2                 Education  \n",
       "3                 Education  \n",
       "4                 Education  "
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "m_col_inst_course.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "34"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(list(m_col_inst_course.discipline_group_category.unique()))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {
    "scrolled": true
   },
   "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>c_Agriculture</th>\n",
       "      <th>c_Area Studies</th>\n",
       "      <th>c_Arts</th>\n",
       "      <th>c_Commerce</th>\n",
       "      <th>c_Criminology &amp; Forensic Science</th>\n",
       "      <th>c_Cultural Studies</th>\n",
       "      <th>c_Defence Studies</th>\n",
       "      <th>c_Design</th>\n",
       "      <th>c_Disability Studies</th>\n",
       "      <th>c_Education</th>\n",
       "      <th>...</th>\n",
       "      <th>c_Marine Science / Oceanography</th>\n",
       "      <th>c_Medical Science</th>\n",
       "      <th>c_Oriental Learning</th>\n",
       "      <th>c_Physical Education</th>\n",
       "      <th>c_Religious Studies</th>\n",
       "      <th>c_Science</th>\n",
       "      <th>c_Social Science</th>\n",
       "      <th>c_Social Work</th>\n",
       "      <th>c_Veterinary &amp; Animal Sciences</th>\n",
       "      <th>c_Women Studies</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158350</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158351</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158352</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158353</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158354</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158355</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158356</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158357</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158358</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158359</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158360</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158361</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158362</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158363</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158364</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158365</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158366</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158367</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158368</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158369</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158370</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158371</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158372</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158373</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158374</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158375</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158376</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158377</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158378</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158379</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>158380 rows × 34 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        c_Agriculture  c_Area Studies  c_Arts  c_Commerce  \\\n",
       "0                   0               0       0           0   \n",
       "1                   0               0       0           0   \n",
       "2                   0               0       0           0   \n",
       "3                   0               0       0           0   \n",
       "4                   0               0       0           0   \n",
       "5                   0               0       0           0   \n",
       "6                   0               0       0           0   \n",
       "7                   0               0       0           0   \n",
       "8                   0               0       0           0   \n",
       "9                   0               0       0           0   \n",
       "10                  0               0       0           0   \n",
       "11                  0               0       0           0   \n",
       "12                  0               0       0           0   \n",
       "13                  0               0       0           0   \n",
       "14                  0               0       0           0   \n",
       "15                  0               0       0           0   \n",
       "16                  0               0       0           0   \n",
       "17                  0               0       0           0   \n",
       "18                  0               0       0           0   \n",
       "19                  0               0       0           0   \n",
       "20                  0               0       0           0   \n",
       "21                  0               0       0           0   \n",
       "22                  0               0       0           0   \n",
       "23                  0               0       0           0   \n",
       "24                  0               0       0           0   \n",
       "25                  0               0       0           0   \n",
       "26                  0               0       0           0   \n",
       "27                  0               0       0           0   \n",
       "28                  0               0       0           0   \n",
       "29                  0               0       0           0   \n",
       "...               ...             ...     ...         ...   \n",
       "158350              0               0       0           0   \n",
       "158351              0               0       0           0   \n",
       "158352              0               0       0           0   \n",
       "158353              0               0       0           0   \n",
       "158354              0               0       0           0   \n",
       "158355              0               0       0           0   \n",
       "158356              0               0       0           0   \n",
       "158357              0               0       0           0   \n",
       "158358              0               0       0           0   \n",
       "158359              0               0       0           0   \n",
       "158360              0               0       0           0   \n",
       "158361              0               0       0           0   \n",
       "158362              0               0       0           0   \n",
       "158363              0               0       0           0   \n",
       "158364              0               0       0           0   \n",
       "158365              0               0       0           0   \n",
       "158366              0               0       0           0   \n",
       "158367              0               0       0           0   \n",
       "158368              0               0       0           0   \n",
       "158369              0               0       0           0   \n",
       "158370              0               0       0           0   \n",
       "158371              0               0       0           0   \n",
       "158372              0               0       0           0   \n",
       "158373              0               0       0           0   \n",
       "158374              0               0       0           0   \n",
       "158375              0               0       0           0   \n",
       "158376              0               0       0           0   \n",
       "158377              0               0       0           0   \n",
       "158378              0               0       0           0   \n",
       "158379              0               0       0           0   \n",
       "\n",
       "        c_Criminology & Forensic Science  c_Cultural Studies  \\\n",
       "0                                      0                   0   \n",
       "1                                      0                   0   \n",
       "2                                      0                   0   \n",
       "3                                      0                   0   \n",
       "4                                      0                   0   \n",
       "5                                      0                   0   \n",
       "6                                      0                   0   \n",
       "7                                      0                   0   \n",
       "8                                      0                   0   \n",
       "9                                      0                   0   \n",
       "10                                     0                   0   \n",
       "11                                     0                   0   \n",
       "12                                     0                   0   \n",
       "13                                     0                   0   \n",
       "14                                     0                   0   \n",
       "15                                     0                   0   \n",
       "16                                     0                   0   \n",
       "17                                     0                   0   \n",
       "18                                     0                   0   \n",
       "19                                     0                   0   \n",
       "20                                     0                   0   \n",
       "21                                     0                   0   \n",
       "22                                     0                   0   \n",
       "23                                     0                   0   \n",
       "24                                     0                   0   \n",
       "25                                     0                   0   \n",
       "26                                     0                   0   \n",
       "27                                     0                   0   \n",
       "28                                     0                   0   \n",
       "29                                     0                   0   \n",
       "...                                  ...                 ...   \n",
       "158350                                 0                   0   \n",
       "158351                                 0                   0   \n",
       "158352                                 0                   0   \n",
       "158353                                 0                   0   \n",
       "158354                                 0                   0   \n",
       "158355                                 0                   0   \n",
       "158356                                 0                   0   \n",
       "158357                                 0                   0   \n",
       "158358                                 0                   0   \n",
       "158359                                 0                   0   \n",
       "158360                                 0                   0   \n",
       "158361                                 0                   0   \n",
       "158362                                 0                   0   \n",
       "158363                                 0                   0   \n",
       "158364                                 0                   0   \n",
       "158365                                 0                   0   \n",
       "158366                                 0                   0   \n",
       "158367                                 0                   0   \n",
       "158368                                 0                   0   \n",
       "158369                                 0                   0   \n",
       "158370                                 0                   0   \n",
       "158371                                 0                   0   \n",
       "158372                                 0                   0   \n",
       "158373                                 0                   0   \n",
       "158374                                 0                   0   \n",
       "158375                                 0                   0   \n",
       "158376                                 0                   0   \n",
       "158377                                 0                   0   \n",
       "158378                                 0                   0   \n",
       "158379                                 0                   0   \n",
       "\n",
       "        c_Defence Studies  c_Design  c_Disability Studies\\r\\n  c_Education  \\\n",
       "0                       0         0                         0            1   \n",
       "1                       0         0                         0            1   \n",
       "2                       0         0                         0            1   \n",
       "3                       0         0                         0            1   \n",
       "4                       0         0                         0            1   \n",
       "5                       0         0                         0            1   \n",
       "6                       0         0                         0            1   \n",
       "7                       0         0                         0            1   \n",
       "8                       0         0                         0            1   \n",
       "9                       0         0                         0            1   \n",
       "10                      0         0                         0            1   \n",
       "11                      0         0                         0            1   \n",
       "12                      0         0                         0            1   \n",
       "13                      0         0                         0            1   \n",
       "14                      0         0                         0            1   \n",
       "15                      0         0                         0            1   \n",
       "16                      0         0                         0            1   \n",
       "17                      0         0                         0            1   \n",
       "18                      0         0                         0            1   \n",
       "19                      0         0                         0            1   \n",
       "20                      0         0                         0            1   \n",
       "21                      0         0                         0            1   \n",
       "22                      0         0                         0            1   \n",
       "23                      0         0                         0            1   \n",
       "24                      0         0                         0            1   \n",
       "25                      0         0                         0            1   \n",
       "26                      0         0                         0            1   \n",
       "27                      0         0                         0            1   \n",
       "28                      0         0                         0            1   \n",
       "29                      0         0                         0            1   \n",
       "...                   ...       ...                       ...          ...   \n",
       "158350                  0         0                         0            0   \n",
       "158351                  0         0                         0            0   \n",
       "158352                  0         0                         0            0   \n",
       "158353                  0         0                         0            0   \n",
       "158354                  0         0                         0            0   \n",
       "158355                  0         0                         0            0   \n",
       "158356                  0         0                         0            0   \n",
       "158357                  0         0                         0            0   \n",
       "158358                  0         0                         0            0   \n",
       "158359                  0         0                         0            0   \n",
       "158360                  0         0                         0            0   \n",
       "158361                  0         0                         0            0   \n",
       "158362                  0         0                         0            0   \n",
       "158363                  0         0                         0            0   \n",
       "158364                  0         0                         0            0   \n",
       "158365                  0         0                         0            0   \n",
       "158366                  0         0                         0            0   \n",
       "158367                  0         0                         0            0   \n",
       "158368                  0         0                         0            0   \n",
       "158369                  0         0                         0            0   \n",
       "158370                  0         0                         0            0   \n",
       "158371                  0         0                         0            0   \n",
       "158372                  0         0                         0            0   \n",
       "158373                  0         0                         0            0   \n",
       "158374                  0         0                         0            0   \n",
       "158375                  0         0                         0            0   \n",
       "158376                  0         0                         0            0   \n",
       "158377                  0         0                         0            0   \n",
       "158378                  0         0                         0            0   \n",
       "158379                  0         0                         0            0   \n",
       "\n",
       "             ...         c_Marine Science / Oceanography  c_Medical Science  \\\n",
       "0            ...                                       0                  0   \n",
       "1            ...                                       0                  0   \n",
       "2            ...                                       0                  0   \n",
       "3            ...                                       0                  0   \n",
       "4            ...                                       0                  0   \n",
       "5            ...                                       0                  0   \n",
       "6            ...                                       0                  0   \n",
       "7            ...                                       0                  0   \n",
       "8            ...                                       0                  0   \n",
       "9            ...                                       0                  0   \n",
       "10           ...                                       0                  0   \n",
       "11           ...                                       0                  0   \n",
       "12           ...                                       0                  0   \n",
       "13           ...                                       0                  0   \n",
       "14           ...                                       0                  0   \n",
       "15           ...                                       0                  0   \n",
       "16           ...                                       0                  0   \n",
       "17           ...                                       0                  0   \n",
       "18           ...                                       0                  0   \n",
       "19           ...                                       0                  0   \n",
       "20           ...                                       0                  0   \n",
       "21           ...                                       0                  0   \n",
       "22           ...                                       0                  0   \n",
       "23           ...                                       0                  0   \n",
       "24           ...                                       0                  0   \n",
       "25           ...                                       0                  0   \n",
       "26           ...                                       0                  0   \n",
       "27           ...                                       0                  0   \n",
       "28           ...                                       0                  0   \n",
       "29           ...                                       0                  0   \n",
       "...          ...                                     ...                ...   \n",
       "158350       ...                                       0                  0   \n",
       "158351       ...                                       0                  0   \n",
       "158352       ...                                       0                  0   \n",
       "158353       ...                                       0                  0   \n",
       "158354       ...                                       0                  0   \n",
       "158355       ...                                       0                  0   \n",
       "158356       ...                                       0                  0   \n",
       "158357       ...                                       0                  0   \n",
       "158358       ...                                       0                  0   \n",
       "158359       ...                                       0                  0   \n",
       "158360       ...                                       0                  0   \n",
       "158361       ...                                       0                  0   \n",
       "158362       ...                                       0                  0   \n",
       "158363       ...                                       0                  0   \n",
       "158364       ...                                       0                  0   \n",
       "158365       ...                                       0                  0   \n",
       "158366       ...                                       1                  0   \n",
       "158367       ...                                       1                  0   \n",
       "158368       ...                                       1                  0   \n",
       "158369       ...                                       1                  0   \n",
       "158370       ...                                       1                  0   \n",
       "158371       ...                                       1                  0   \n",
       "158372       ...                                       1                  0   \n",
       "158373       ...                                       1                  0   \n",
       "158374       ...                                       1                  0   \n",
       "158375       ...                                       1                  0   \n",
       "158376       ...                                       1                  0   \n",
       "158377       ...                                       1                  0   \n",
       "158378       ...                                       1                  0   \n",
       "158379       ...                                       1                  0   \n",
       "\n",
       "        c_Oriental Learning  c_Physical Education  c_Religious Studies  \\\n",
       "0                         0                     0                    0   \n",
       "1                         0                     0                    0   \n",
       "2                         0                     0                    0   \n",
       "3                         0                     0                    0   \n",
       "4                         0                     0                    0   \n",
       "5                         0                     0                    0   \n",
       "6                         0                     0                    0   \n",
       "7                         0                     0                    0   \n",
       "8                         0                     0                    0   \n",
       "9                         0                     0                    0   \n",
       "10                        0                     0                    0   \n",
       "11                        0                     0                    0   \n",
       "12                        0                     0                    0   \n",
       "13                        0                     0                    0   \n",
       "14                        0                     0                    0   \n",
       "15                        0                     0                    0   \n",
       "16                        0                     0                    0   \n",
       "17                        0                     0                    0   \n",
       "18                        0                     0                    0   \n",
       "19                        0                     0                    0   \n",
       "20                        0                     0                    0   \n",
       "21                        0                     0                    0   \n",
       "22                        0                     0                    0   \n",
       "23                        0                     0                    0   \n",
       "24                        0                     0                    0   \n",
       "25                        0                     0                    0   \n",
       "26                        0                     0                    0   \n",
       "27                        0                     0                    0   \n",
       "28                        0                     0                    0   \n",
       "29                        0                     0                    0   \n",
       "...                     ...                   ...                  ...   \n",
       "158350                    0                     0                    0   \n",
       "158351                    0                     0                    0   \n",
       "158352                    0                     0                    0   \n",
       "158353                    0                     0                    0   \n",
       "158354                    0                     0                    0   \n",
       "158355                    0                     0                    0   \n",
       "158356                    0                     0                    0   \n",
       "158357                    0                     0                    0   \n",
       "158358                    0                     0                    0   \n",
       "158359                    0                     0                    0   \n",
       "158360                    0                     0                    0   \n",
       "158361                    0                     0                    0   \n",
       "158362                    0                     0                    0   \n",
       "158363                    0                     0                    0   \n",
       "158364                    0                     0                    0   \n",
       "158365                    0                     0                    0   \n",
       "158366                    0                     0                    0   \n",
       "158367                    0                     0                    0   \n",
       "158368                    0                     0                    0   \n",
       "158369                    0                     0                    0   \n",
       "158370                    0                     0                    0   \n",
       "158371                    0                     0                    0   \n",
       "158372                    0                     0                    0   \n",
       "158373                    0                     0                    0   \n",
       "158374                    0                     0                    0   \n",
       "158375                    0                     0                    0   \n",
       "158376                    0                     0                    0   \n",
       "158377                    0                     0                    0   \n",
       "158378                    0                     0                    0   \n",
       "158379                    0                     0                    0   \n",
       "\n",
       "        c_Science  c_Social Science  c_Social Work  \\\n",
       "0               0                 0              0   \n",
       "1               0                 0              0   \n",
       "2               0                 0              0   \n",
       "3               0                 0              0   \n",
       "4               0                 0              0   \n",
       "5               0                 0              0   \n",
       "6               0                 0              0   \n",
       "7               0                 0              0   \n",
       "8               0                 0              0   \n",
       "9               0                 0              0   \n",
       "10              0                 0              0   \n",
       "11              0                 0              0   \n",
       "12              0                 0              0   \n",
       "13              0                 0              0   \n",
       "14              0                 0              0   \n",
       "15              0                 0              0   \n",
       "16              0                 0              0   \n",
       "17              0                 0              0   \n",
       "18              0                 0              0   \n",
       "19              0                 0              0   \n",
       "20              0                 0              0   \n",
       "21              0                 0              0   \n",
       "22              0                 0              0   \n",
       "23              0                 0              0   \n",
       "24              0                 0              0   \n",
       "25              0                 0              0   \n",
       "26              0                 0              0   \n",
       "27              0                 0              0   \n",
       "28              0                 0              0   \n",
       "29              0                 0              0   \n",
       "...           ...               ...            ...   \n",
       "158350          0                 0              0   \n",
       "158351          0                 0              0   \n",
       "158352          0                 0              0   \n",
       "158353          0                 0              0   \n",
       "158354          0                 0              0   \n",
       "158355          0                 0              0   \n",
       "158356          0                 0              0   \n",
       "158357          0                 0              0   \n",
       "158358          0                 0              0   \n",
       "158359          0                 0              0   \n",
       "158360          0                 0              0   \n",
       "158361          0                 0              0   \n",
       "158362          0                 0              0   \n",
       "158363          0                 0              0   \n",
       "158364          0                 0              0   \n",
       "158365          0                 0              0   \n",
       "158366          0                 0              0   \n",
       "158367          0                 0              0   \n",
       "158368          0                 0              0   \n",
       "158369          0                 0              0   \n",
       "158370          0                 0              0   \n",
       "158371          0                 0              0   \n",
       "158372          0                 0              0   \n",
       "158373          0                 0              0   \n",
       "158374          0                 0              0   \n",
       "158375          0                 0              0   \n",
       "158376          0                 0              0   \n",
       "158377          0                 0              0   \n",
       "158378          0                 0              0   \n",
       "158379          0                 0              0   \n",
       "\n",
       "        c_Veterinary & Animal Sciences  c_Women Studies  \n",
       "0                                    0                0  \n",
       "1                                    0                0  \n",
       "2                                    0                0  \n",
       "3                                    0                0  \n",
       "4                                    0                0  \n",
       "5                                    0                0  \n",
       "6                                    0                0  \n",
       "7                                    0                0  \n",
       "8                                    0                0  \n",
       "9                                    0                0  \n",
       "10                                   0                0  \n",
       "11                                   0                0  \n",
       "12                                   0                0  \n",
       "13                                   0                0  \n",
       "14                                   0                0  \n",
       "15                                   0                0  \n",
       "16                                   0                0  \n",
       "17                                   0                0  \n",
       "18                                   0                0  \n",
       "19                                   0                0  \n",
       "20                                   0                0  \n",
       "21                                   0                0  \n",
       "22                                   0                0  \n",
       "23                                   0                0  \n",
       "24                                   0                0  \n",
       "25                                   0                0  \n",
       "26                                   0                0  \n",
       "27                                   0                0  \n",
       "28                                   0                0  \n",
       "29                                   0                0  \n",
       "...                                ...              ...  \n",
       "158350                               0                0  \n",
       "158351                               0                0  \n",
       "158352                               0                0  \n",
       "158353                               0                0  \n",
       "158354                               0                0  \n",
       "158355                               0                0  \n",
       "158356                               0                0  \n",
       "158357                               0                0  \n",
       "158358                               0                0  \n",
       "158359                               0                0  \n",
       "158360                               0                0  \n",
       "158361                               0                0  \n",
       "158362                               0                0  \n",
       "158363                               0                0  \n",
       "158364                               0                0  \n",
       "158365                               0                0  \n",
       "158366                               0                0  \n",
       "158367                               0                0  \n",
       "158368                               0                0  \n",
       "158369                               0                0  \n",
       "158370                               0                0  \n",
       "158371                               0                0  \n",
       "158372                               0                0  \n",
       "158373                               0                0  \n",
       "158374                               0                0  \n",
       "158375                               0                0  \n",
       "158376                               0                0  \n",
       "158377                               0                0  \n",
       "158378                               0                0  \n",
       "158379                               0                0  \n",
       "\n",
       "[158380 rows x 34 columns]"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "m_col_inst_course['discipline_group_category'] = pd.Categorical(m_col_inst_course['discipline_group_category'])\n",
    "dfDummies = pd.get_dummies(m_col_inst_course['discipline_group_category'], prefix = 'c')\n",
    "dfDummies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['c_Agriculture', 'c_Area_Studies', 'c_Arts', 'c_Commerce', 'c_Criminology_&_Forensic_Science', 'c_Cultural_Studies', 'c_Defence_Studies', 'c_Design', 'c_Disability_Studies', 'c_Education', 'c_Engineering_&_Technology', 'c_Fashion_Technology', 'c_Fine_Arts', 'c_Fisheries_Science', 'c_Foreign_Language', 'c_Gandhian_Studies', 'c_Home_Science', 'c_IT_&_Computer', 'c_Indian_Language', 'c_Journalism_&_Mass_Communication', 'c_Law', 'c_Library_&_Information_Science', 'c_Linguistics', 'c_Management', 'c_Marine_Science_/_Oceanography', 'c_Medical_Science', 'c_Oriental_Learning', 'c_Physical_Education', 'c_Religious_Studies', 'c_Science', 'c_Social_Science', 'c_Social_Work', 'c_Veterinary_&_Animal_Sciences', 'c_Women_Studies']\n"
     ]
    }
   ],
   "source": [
    "columns=list(dfDummies.columns)\n",
    "columns1=[]\n",
    "for i in columns:\n",
    "    i=i.replace(\" \",\"_\")\n",
    "    columns1.append(i)\n",
    "print(columns1)\n",
    "dfDummies.columns=['c_Agriculture', 'c_Area_Studies', 'c_Arts', 'c_Commerce', 'c_Criminology_&_Forensic_Science', 'c_Cultural_Studies', 'c_Defence_Studies', 'c_Design', 'c_Disability_Studies', 'c_Education', 'c_Engineering_&_Technology', 'c_Fashion_Technology', 'c_Fine_Arts', 'c_Fisheries_Science', 'c_Foreign_Language', 'c_Gandhian_Studies', 'c_Home_Science', 'c_IT_&_Computer', 'c_Indian_Language', 'c_Journalism_&_Mass_Communication', 'c_Law', 'c_Library_&_Information_Science', 'c_Linguistics', 'c_Management', 'c_Marine_Science_/_Oceanography', 'c_Medical_Science', 'c_Oriental_Learning', 'c_Physical_Education', 'c_Religious_Studies', 'c_Science', 'c_Social_Science', 'c_Social_Work', 'c_Veterinary_&_Animal_Sciences', 'c_Women_Studies']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "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>c_Agriculture</th>\n",
       "      <th>c_Area_Studies</th>\n",
       "      <th>c_Arts</th>\n",
       "      <th>c_Commerce</th>\n",
       "      <th>c_Criminology_&amp;_Forensic_Science</th>\n",
       "      <th>c_Cultural_Studies</th>\n",
       "      <th>c_Defence_Studies</th>\n",
       "      <th>c_Design</th>\n",
       "      <th>c_Disability_Studies</th>\n",
       "      <th>c_Education</th>\n",
       "      <th>...</th>\n",
       "      <th>c_Marine_Science_/_Oceanography</th>\n",
       "      <th>c_Medical_Science</th>\n",
       "      <th>c_Oriental_Learning</th>\n",
       "      <th>c_Physical_Education</th>\n",
       "      <th>c_Religious_Studies</th>\n",
       "      <th>c_Science</th>\n",
       "      <th>c_Social_Science</th>\n",
       "      <th>c_Social_Work</th>\n",
       "      <th>c_Veterinary_&amp;_Animal_Sciences</th>\n",
       "      <th>c_Women_Studies</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 34 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   c_Agriculture  c_Area_Studies  c_Arts  c_Commerce  \\\n",
       "0              0               0       0           0   \n",
       "1              0               0       0           0   \n",
       "2              0               0       0           0   \n",
       "3              0               0       0           0   \n",
       "4              0               0       0           0   \n",
       "\n",
       "   c_Criminology_&_Forensic_Science  c_Cultural_Studies  c_Defence_Studies  \\\n",
       "0                                 0                   0                  0   \n",
       "1                                 0                   0                  0   \n",
       "2                                 0                   0                  0   \n",
       "3                                 0                   0                  0   \n",
       "4                                 0                   0                  0   \n",
       "\n",
       "   c_Design  c_Disability_Studies  c_Education       ...         \\\n",
       "0         0                     0            1       ...          \n",
       "1         0                     0            1       ...          \n",
       "2         0                     0            1       ...          \n",
       "3         0                     0            1       ...          \n",
       "4         0                     0            1       ...          \n",
       "\n",
       "   c_Marine_Science_/_Oceanography  c_Medical_Science  c_Oriental_Learning  \\\n",
       "0                                0                  0                    0   \n",
       "1                                0                  0                    0   \n",
       "2                                0                  0                    0   \n",
       "3                                0                  0                    0   \n",
       "4                                0                  0                    0   \n",
       "\n",
       "   c_Physical_Education  c_Religious_Studies  c_Science  c_Social_Science  \\\n",
       "0                     0                    0          0                 0   \n",
       "1                     0                    0          0                 0   \n",
       "2                     0                    0          0                 0   \n",
       "3                     0                    0          0                 0   \n",
       "4                     0                    0          0                 0   \n",
       "\n",
       "   c_Social_Work  c_Veterinary_&_Animal_Sciences  c_Women_Studies  \n",
       "0              0                               0                0  \n",
       "1              0                               0                0  \n",
       "2              0                               0                0  \n",
       "3              0                               0                0  \n",
       "4              0                               0                0  \n",
       "\n",
       "[5 rows x 34 columns]"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfDummies.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "m_col_inst_course = pd.concat([m_col_inst_course, dfDummies], axis=1)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['institution_category',\n",
       " 'college_institution_id',\n",
       " 'state_code',\n",
       " 'course_id',\n",
       " 'programme_id',\n",
       " 'broad_discipline_group_id',\n",
       " 'intake',\n",
       " 'duration_year',\n",
       " 'broad_discipline_group_category_id',\n",
       " 'discipline_group',\n",
       " 'discipline_group_category',\n",
       " 'c_Agriculture',\n",
       " 'c_Area_Studies',\n",
       " 'c_Arts',\n",
       " 'c_Commerce',\n",
       " 'c_Criminology_&_Forensic_Science',\n",
       " 'c_Cultural_Studies',\n",
       " 'c_Defence_Studies',\n",
       " 'c_Design',\n",
       " 'c_Disability_Studies',\n",
       " 'c_Education',\n",
       " 'c_Engineering_&_Technology',\n",
       " 'c_Fashion_Technology',\n",
       " 'c_Fine_Arts',\n",
       " 'c_Fisheries_Science',\n",
       " 'c_Foreign_Language',\n",
       " 'c_Gandhian_Studies',\n",
       " 'c_Home_Science',\n",
       " 'c_IT_&_Computer',\n",
       " 'c_Indian_Language',\n",
       " 'c_Journalism_&_Mass_Communication',\n",
       " 'c_Law',\n",
       " 'c_Library_&_Information_Science',\n",
       " 'c_Linguistics',\n",
       " 'c_Management',\n",
       " 'c_Marine_Science_/_Oceanography',\n",
       " 'c_Medical_Science',\n",
       " 'c_Oriental_Learning',\n",
       " 'c_Physical_Education',\n",
       " 'c_Religious_Studies',\n",
       " 'c_Science',\n",
       " 'c_Social_Science',\n",
       " 'c_Social_Work',\n",
       " 'c_Veterinary_&_Animal_Sciences',\n",
       " 'c_Women_Studies']"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(c.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\"['Education' 'Education' 'Science' 'Commerce']\""
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=m_col_inst_course[m_col_inst_course['college_institution_id']==13438]\n",
    "str(df.discipline_group.values)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [],
   "source": [
    "col_courses={'college_institution_id':[],'courses':[]}\n",
    "for i in col_inst_ids:\n",
    "    courses=''\n",
    "    df=m_col_inst_course[m_col_inst_course['college_institution_id']==i]\n",
    "    disc=list(df.discipline_group.values)\n",
    "    for j in disc:\n",
    "        courses=courses+j+' '    \n",
    "    col_courses['college_institution_id'].append(i)\n",
    "    col_courses['courses'].append(courses.strip())\n",
    "col_courses=pd.DataFrame(col_courses)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "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>college_institution_id</th>\n",
       "      <th>courses</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>13438</td>\n",
       "      <td>Education Education Science Commerce</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>55446</td>\n",
       "      <td>Education</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>15927</td>\n",
       "      <td>Arts</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>51377</td>\n",
       "      <td>Arts</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>51411</td>\n",
       "      <td>Arts</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   college_institution_id                               courses\n",
       "0                   13438  Education Education Science Commerce\n",
       "1                   55446                             Education\n",
       "2                   15927                                  Arts\n",
       "3                   51377                                  Arts\n",
       "4                   51411                                  Arts"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "col_courses.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "college_institution_id    35187\n",
       "courses                   35187\n",
       "dtype: int64"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "col_courses.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "#col_courses.to_csv('col_courses.csv',index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "df=m_col_inst_course[[\n",
    " 'college_institution_id',\n",
    " 'c_Agriculture',\n",
    " 'c_Area_Studies',\n",
    " 'c_Arts',\n",
    " 'c_Commerce',\n",
    " 'c_Criminology_&_Forensic_Science',\n",
    " 'c_Cultural_Studies',\n",
    " 'c_Defence_Studies',\n",
    " 'c_Design',\n",
    " 'c_Disability_Studies',\n",
    " 'c_Education',\n",
    " 'c_Engineering_&_Technology',\n",
    " 'c_Fashion_Technology',\n",
    " 'c_Fine_Arts',\n",
    " 'c_Fisheries_Science',\n",
    " 'c_Foreign_Language',\n",
    " 'c_Gandhian_Studies',\n",
    " 'c_Home_Science',\n",
    " 'c_IT_&_Computer',\n",
    " 'c_Indian_Language',\n",
    " 'c_Journalism_&_Mass_Communication',\n",
    " 'c_Law',\n",
    " 'c_Library_&_Information_Science',\n",
    " 'c_Linguistics',\n",
    " 'c_Management',\n",
    " 'c_Marine_Science_/_Oceanography',\n",
    " 'c_Medical_Science',\n",
    " 'c_Oriental_Learning',\n",
    " 'c_Physical_Education',\n",
    " 'c_Religious_Studies',\n",
    " 'c_Science',\n",
    " 'c_Social_Science',\n",
    " 'c_Social_Work',\n",
    " 'c_Veterinary_&_Animal_Sciences',\n",
    " 'c_Women_Studies']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1=df_new = df.groupby('college_institution_id', as_index=False).max().reindex(columns=df.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "949    0\n",
       "Name: c_Law, dtype: uint8"
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1[df1['college_institution_id']==1331]['c_Law']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2=pd.merge(col_courses,df1,on='college_institution_id',how='inner')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>college_institution_id</th>\n",
       "      <th>courses</th>\n",
       "      <th>c_Agriculture</th>\n",
       "      <th>c_Area_Studies</th>\n",
       "      <th>c_Arts</th>\n",
       "      <th>c_Commerce</th>\n",
       "      <th>c_Criminology_&amp;_Forensic_Science</th>\n",
       "      <th>c_Cultural_Studies</th>\n",
       "      <th>c_Defence_Studies</th>\n",
       "      <th>c_Design</th>\n",
       "      <th>...</th>\n",
       "      <th>c_Marine_Science_/_Oceanography</th>\n",
       "      <th>c_Medical_Science</th>\n",
       "      <th>c_Oriental_Learning</th>\n",
       "      <th>c_Physical_Education</th>\n",
       "      <th>c_Religious_Studies</th>\n",
       "      <th>c_Science</th>\n",
       "      <th>c_Social_Science</th>\n",
       "      <th>c_Social_Work</th>\n",
       "      <th>c_Veterinary_&amp;_Animal_Sciences</th>\n",
       "      <th>c_Women_Studies</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>13438</td>\n",
       "      <td>Education Education Science Commerce</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>55446</td>\n",
       "      <td>Education</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>15927</td>\n",
       "      <td>Arts</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>51377</td>\n",
       "      <td>Arts</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>51411</td>\n",
       "      <td>Arts</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>49749</td>\n",
       "      <td>Science Commerce Arts</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>15282</td>\n",
       "      <td>Education</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>17135</td>\n",
       "      <td>Commerce Commerce Commerce Commerce Business A...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>52568</td>\n",
       "      <td>Science Arts</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>25509</td>\n",
       "      <td>Arts</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>50188</td>\n",
       "      <td>Science Arts</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>51311</td>\n",
       "      <td>Arts</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>23967</td>\n",
       "      <td>Science Commerce</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>51476</td>\n",
       "      <td>Arts</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>54842</td>\n",
       "      <td>Education Science Arts</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>28718</td>\n",
       "      <td>Education Chemistry Science Mathematics Physic...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>55228</td>\n",
       "      <td>Education</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>45134</td>\n",
       "      <td>Science Commerce Arts</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>46000</td>\n",
       "      <td>Education</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>47866</td>\n",
       "      <td>Information Technology Chemical Engineering Me...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>30358</td>\n",
       "      <td>Nursing</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>18396</td>\n",
       "      <td>Commerce</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>15930</td>\n",
       "      <td>Arts</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>15243</td>\n",
       "      <td>Arts</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>6845</td>\n",
       "      <td>Computer Science</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>17869</td>\n",
       "      <td>Computer Application</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>8649</td>\n",
       "      <td>Social Work</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>47925</td>\n",
       "      <td>Computer Application</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>6234</td>\n",
       "      <td>Business Administration Computer Application</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>33926</td>\n",
       "      <td>Science Commerce Commerce</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35157</th>\n",
       "      <td>20911</td>\n",
       "      <td>Education Education Education Education Educat...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35158</th>\n",
       "      <td>13218</td>\n",
       "      <td>Science Commerce Arts Business Administration ...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35159</th>\n",
       "      <td>31329</td>\n",
       "      <td>Computer Application Computer Application Comp...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35160</th>\n",
       "      <td>14051</td>\n",
       "      <td>Ayurveda Ayurveda</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35161</th>\n",
       "      <td>54242</td>\n",
       "      <td>Commerce</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35162</th>\n",
       "      <td>16298</td>\n",
       "      <td>Arts Other Medical Science</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35163</th>\n",
       "      <td>54993</td>\n",
       "      <td>Science Commerce</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35164</th>\n",
       "      <td>34284</td>\n",
       "      <td>Science Arts</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35165</th>\n",
       "      <td>13351</td>\n",
       "      <td>Arts</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35166</th>\n",
       "      <td>21114</td>\n",
       "      <td>Commerce Arts</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35167</th>\n",
       "      <td>26432</td>\n",
       "      <td>Psychiatry Anesthesiology Gastroenterology Der...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35168</th>\n",
       "      <td>54823</td>\n",
       "      <td>Science Arts</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35169</th>\n",
       "      <td>15507</td>\n",
       "      <td>Science Arts</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35170</th>\n",
       "      <td>53805</td>\n",
       "      <td>Education Education</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35171</th>\n",
       "      <td>53868</td>\n",
       "      <td>Computer Application Computer Application</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35172</th>\n",
       "      <td>9628</td>\n",
       "      <td>Oriental Learning Oriental Learning Oriental L...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35173</th>\n",
       "      <td>15186</td>\n",
       "      <td>Education Science Commerce Arts</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35174</th>\n",
       "      <td>28975</td>\n",
       "      <td>Education Commerce Business Administration Com...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35175</th>\n",
       "      <td>47486</td>\n",
       "      <td>Arts</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35176</th>\n",
       "      <td>6708</td>\n",
       "      <td>Arts Hindi Sanskrit</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35177</th>\n",
       "      <td>55370</td>\n",
       "      <td>Bio-Physics</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35178</th>\n",
       "      <td>36266</td>\n",
       "      <td>Electrical Engineering Civil Engineering Compu...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35179</th>\n",
       "      <td>55543</td>\n",
       "      <td>General Medicine</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35180</th>\n",
       "      <td>55541</td>\n",
       "      <td>Science Commerce</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35181</th>\n",
       "      <td>29453</td>\n",
       "      <td>Business Administration Agriculture Agricultur...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35182</th>\n",
       "      <td>46520</td>\n",
       "      <td>Oriental Learning</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35183</th>\n",
       "      <td>9650</td>\n",
       "      <td>Oriental Learning</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35184</th>\n",
       "      <td>27131</td>\n",
       "      <td>Science Commerce Arts</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35185</th>\n",
       "      <td>30507</td>\n",
       "      <td>Nursing</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35186</th>\n",
       "      <td>17638</td>\n",
       "      <td>Mathematics Zoology Botany Chemistry Physics C...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>35187 rows × 36 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       college_institution_id  \\\n",
       "0                       13438   \n",
       "1                       55446   \n",
       "2                       15927   \n",
       "3                       51377   \n",
       "4                       51411   \n",
       "5                       49749   \n",
       "6                       15282   \n",
       "7                       17135   \n",
       "8                       52568   \n",
       "9                       25509   \n",
       "10                      50188   \n",
       "11                      51311   \n",
       "12                      23967   \n",
       "13                      51476   \n",
       "14                      54842   \n",
       "15                      28718   \n",
       "16                      55228   \n",
       "17                      45134   \n",
       "18                      46000   \n",
       "19                      47866   \n",
       "20                      30358   \n",
       "21                      18396   \n",
       "22                      15930   \n",
       "23                      15243   \n",
       "24                       6845   \n",
       "25                      17869   \n",
       "26                       8649   \n",
       "27                      47925   \n",
       "28                       6234   \n",
       "29                      33926   \n",
       "...                       ...   \n",
       "35157                   20911   \n",
       "35158                   13218   \n",
       "35159                   31329   \n",
       "35160                   14051   \n",
       "35161                   54242   \n",
       "35162                   16298   \n",
       "35163                   54993   \n",
       "35164                   34284   \n",
       "35165                   13351   \n",
       "35166                   21114   \n",
       "35167                   26432   \n",
       "35168                   54823   \n",
       "35169                   15507   \n",
       "35170                   53805   \n",
       "35171                   53868   \n",
       "35172                    9628   \n",
       "35173                   15186   \n",
       "35174                   28975   \n",
       "35175                   47486   \n",
       "35176                    6708   \n",
       "35177                   55370   \n",
       "35178                   36266   \n",
       "35179                   55543   \n",
       "35180                   55541   \n",
       "35181                   29453   \n",
       "35182                   46520   \n",
       "35183                    9650   \n",
       "35184                   27131   \n",
       "35185                   30507   \n",
       "35186                   17638   \n",
       "\n",
       "                                                 courses  c_Agriculture  \\\n",
       "0                   Education Education Science Commerce              0   \n",
       "1                                              Education              0   \n",
       "2                                                   Arts              0   \n",
       "3                                                   Arts              0   \n",
       "4                                                   Arts              0   \n",
       "5                                  Science Commerce Arts              0   \n",
       "6                                              Education              0   \n",
       "7      Commerce Commerce Commerce Commerce Business A...              0   \n",
       "8                                           Science Arts              0   \n",
       "9                                                   Arts              0   \n",
       "10                                          Science Arts              0   \n",
       "11                                                  Arts              0   \n",
       "12                                      Science Commerce              0   \n",
       "13                                                  Arts              0   \n",
       "14                                Education Science Arts              0   \n",
       "15     Education Chemistry Science Mathematics Physic...              0   \n",
       "16                                             Education              0   \n",
       "17                                 Science Commerce Arts              0   \n",
       "18                                             Education              0   \n",
       "19     Information Technology Chemical Engineering Me...              0   \n",
       "20                                               Nursing              0   \n",
       "21                                              Commerce              0   \n",
       "22                                                  Arts              0   \n",
       "23                                                  Arts              0   \n",
       "24                                      Computer Science              0   \n",
       "25                                  Computer Application              0   \n",
       "26                                           Social Work              0   \n",
       "27                                  Computer Application              0   \n",
       "28          Business Administration Computer Application              0   \n",
       "29                             Science Commerce Commerce              0   \n",
       "...                                                  ...            ...   \n",
       "35157  Education Education Education Education Educat...              0   \n",
       "35158  Science Commerce Arts Business Administration ...              0   \n",
       "35159  Computer Application Computer Application Comp...              0   \n",
       "35160                                  Ayurveda Ayurveda              0   \n",
       "35161                                           Commerce              0   \n",
       "35162                         Arts Other Medical Science              0   \n",
       "35163                                   Science Commerce              0   \n",
       "35164                                       Science Arts              0   \n",
       "35165                                               Arts              0   \n",
       "35166                                      Commerce Arts              0   \n",
       "35167  Psychiatry Anesthesiology Gastroenterology Der...              0   \n",
       "35168                                       Science Arts              0   \n",
       "35169                                       Science Arts              0   \n",
       "35170                                Education Education              0   \n",
       "35171          Computer Application Computer Application              0   \n",
       "35172  Oriental Learning Oriental Learning Oriental L...              0   \n",
       "35173                    Education Science Commerce Arts              0   \n",
       "35174  Education Commerce Business Administration Com...              0   \n",
       "35175                                               Arts              0   \n",
       "35176                                Arts Hindi Sanskrit              0   \n",
       "35177                                        Bio-Physics              0   \n",
       "35178  Electrical Engineering Civil Engineering Compu...              0   \n",
       "35179                                   General Medicine              0   \n",
       "35180                                   Science Commerce              0   \n",
       "35181  Business Administration Agriculture Agricultur...              1   \n",
       "35182                                  Oriental Learning              0   \n",
       "35183                                  Oriental Learning              0   \n",
       "35184                              Science Commerce Arts              0   \n",
       "35185                                            Nursing              0   \n",
       "35186  Mathematics Zoology Botany Chemistry Physics C...              0   \n",
       "\n",
       "       c_Area_Studies  c_Arts  c_Commerce  c_Criminology_&_Forensic_Science  \\\n",
       "0                   0       0           1                                 0   \n",
       "1                   0       0           0                                 0   \n",
       "2                   0       1           0                                 0   \n",
       "3                   0       1           0                                 0   \n",
       "4                   0       1           0                                 0   \n",
       "5                   0       1           1                                 0   \n",
       "6                   0       0           0                                 0   \n",
       "7                   0       0           1                                 0   \n",
       "8                   0       1           0                                 0   \n",
       "9                   0       1           0                                 0   \n",
       "10                  0       1           0                                 0   \n",
       "11                  0       1           0                                 0   \n",
       "12                  0       0           1                                 0   \n",
       "13                  0       1           0                                 0   \n",
       "14                  0       1           0                                 0   \n",
       "15                  0       1           1                                 0   \n",
       "16                  0       0           0                                 0   \n",
       "17                  0       1           1                                 0   \n",
       "18                  0       0           0                                 0   \n",
       "19                  0       0           0                                 0   \n",
       "20                  0       0           0                                 0   \n",
       "21                  0       0           1                                 0   \n",
       "22                  0       1           0                                 0   \n",
       "23                  0       1           0                                 0   \n",
       "24                  0       0           0                                 0   \n",
       "25                  0       0           0                                 0   \n",
       "26                  0       0           0                                 0   \n",
       "27                  0       0           0                                 0   \n",
       "28                  0       0           0                                 0   \n",
       "29                  0       0           1                                 0   \n",
       "...               ...     ...         ...                               ...   \n",
       "35157               0       0           0                                 0   \n",
       "35158               0       1           1                                 0   \n",
       "35159               0       0           0                                 0   \n",
       "35160               0       0           0                                 0   \n",
       "35161               0       0           1                                 0   \n",
       "35162               0       1           0                                 0   \n",
       "35163               0       0           1                                 0   \n",
       "35164               0       1           0                                 0   \n",
       "35165               0       1           0                                 0   \n",
       "35166               0       1           1                                 0   \n",
       "35167               0       0           0                                 0   \n",
       "35168               0       1           0                                 0   \n",
       "35169               0       1           0                                 0   \n",
       "35170               0       0           0                                 0   \n",
       "35171               0       0           0                                 0   \n",
       "35172               0       0           0                                 0   \n",
       "35173               0       1           1                                 0   \n",
       "35174               0       0           1                                 0   \n",
       "35175               0       1           0                                 0   \n",
       "35176               0       1           0                                 0   \n",
       "35177               0       0           0                                 0   \n",
       "35178               0       0           0                                 0   \n",
       "35179               0       0           0                                 0   \n",
       "35180               0       0           1                                 0   \n",
       "35181               0       0           0                                 0   \n",
       "35182               0       0           0                                 0   \n",
       "35183               0       0           0                                 0   \n",
       "35184               0       1           1                                 0   \n",
       "35185               0       0           0                                 0   \n",
       "35186               0       0           1                                 0   \n",
       "\n",
       "       c_Cultural_Studies  c_Defence_Studies  c_Design       ...         \\\n",
       "0                       0                  0         0       ...          \n",
       "1                       0                  0         0       ...          \n",
       "2                       0                  0         0       ...          \n",
       "3                       0                  0         0       ...          \n",
       "4                       0                  0         0       ...          \n",
       "5                       0                  0         0       ...          \n",
       "6                       0                  0         0       ...          \n",
       "7                       0                  0         0       ...          \n",
       "8                       0                  0         0       ...          \n",
       "9                       0                  0         0       ...          \n",
       "10                      0                  0         0       ...          \n",
       "11                      0                  0         0       ...          \n",
       "12                      0                  0         0       ...          \n",
       "13                      0                  0         0       ...          \n",
       "14                      0                  0         0       ...          \n",
       "15                      0                  0         0       ...          \n",
       "16                      0                  0         0       ...          \n",
       "17                      0                  0         0       ...          \n",
       "18                      0                  0         0       ...          \n",
       "19                      0                  0         0       ...          \n",
       "20                      0                  0         0       ...          \n",
       "21                      0                  0         0       ...          \n",
       "22                      0                  0         0       ...          \n",
       "23                      0                  0         0       ...          \n",
       "24                      0                  0         0       ...          \n",
       "25                      0                  0         0       ...          \n",
       "26                      0                  0         0       ...          \n",
       "27                      0                  0         0       ...          \n",
       "28                      0                  0         0       ...          \n",
       "29                      0                  0         0       ...          \n",
       "...                   ...                ...       ...       ...          \n",
       "35157                   0                  0         0       ...          \n",
       "35158                   0                  0         0       ...          \n",
       "35159                   0                  0         0       ...          \n",
       "35160                   0                  0         0       ...          \n",
       "35161                   0                  0         0       ...          \n",
       "35162                   0                  0         0       ...          \n",
       "35163                   0                  0         0       ...          \n",
       "35164                   0                  0         0       ...          \n",
       "35165                   0                  0         0       ...          \n",
       "35166                   0                  0         0       ...          \n",
       "35167                   0                  0         0       ...          \n",
       "35168                   0                  0         0       ...          \n",
       "35169                   0                  0         0       ...          \n",
       "35170                   0                  0         0       ...          \n",
       "35171                   0                  0         0       ...          \n",
       "35172                   0                  0         0       ...          \n",
       "35173                   0                  0         0       ...          \n",
       "35174                   0                  0         0       ...          \n",
       "35175                   0                  0         0       ...          \n",
       "35176                   0                  0         0       ...          \n",
       "35177                   0                  0         0       ...          \n",
       "35178                   0                  0         0       ...          \n",
       "35179                   0                  0         0       ...          \n",
       "35180                   0                  0         0       ...          \n",
       "35181                   0                  0         0       ...          \n",
       "35182                   0                  0         0       ...          \n",
       "35183                   0                  0         0       ...          \n",
       "35184                   0                  0         0       ...          \n",
       "35185                   0                  0         0       ...          \n",
       "35186                   0                  0         0       ...          \n",
       "\n",
       "       c_Marine_Science_/_Oceanography  c_Medical_Science  \\\n",
       "0                                    0                  0   \n",
       "1                                    0                  0   \n",
       "2                                    0                  0   \n",
       "3                                    0                  0   \n",
       "4                                    0                  0   \n",
       "5                                    0                  0   \n",
       "6                                    0                  0   \n",
       "7                                    0                  0   \n",
       "8                                    0                  0   \n",
       "9                                    0                  0   \n",
       "10                                   0                  0   \n",
       "11                                   0                  0   \n",
       "12                                   0                  0   \n",
       "13                                   0                  0   \n",
       "14                                   0                  0   \n",
       "15                                   0                  0   \n",
       "16                                   0                  0   \n",
       "17                                   0                  0   \n",
       "18                                   0                  0   \n",
       "19                                   0                  0   \n",
       "20                                   0                  1   \n",
       "21                                   0                  0   \n",
       "22                                   0                  0   \n",
       "23                                   0                  0   \n",
       "24                                   0                  0   \n",
       "25                                   0                  0   \n",
       "26                                   0                  0   \n",
       "27                                   0                  0   \n",
       "28                                   0                  0   \n",
       "29                                   0                  0   \n",
       "...                                ...                ...   \n",
       "35157                                0                  0   \n",
       "35158                                0                  0   \n",
       "35159                                0                  0   \n",
       "35160                                0                  1   \n",
       "35161                                0                  0   \n",
       "35162                                0                  1   \n",
       "35163                                0                  0   \n",
       "35164                                0                  0   \n",
       "35165                                0                  0   \n",
       "35166                                0                  0   \n",
       "35167                                0                  1   \n",
       "35168                                0                  0   \n",
       "35169                                0                  0   \n",
       "35170                                0                  0   \n",
       "35171                                0                  0   \n",
       "35172                                0                  0   \n",
       "35173                                0                  0   \n",
       "35174                                0                  0   \n",
       "35175                                0                  0   \n",
       "35176                                0                  0   \n",
       "35177                                0                  1   \n",
       "35178                                0                  0   \n",
       "35179                                0                  1   \n",
       "35180                                0                  0   \n",
       "35181                                0                  0   \n",
       "35182                                0                  0   \n",
       "35183                                0                  0   \n",
       "35184                                0                  0   \n",
       "35185                                0                  1   \n",
       "35186                                0                  0   \n",
       "\n",
       "       c_Oriental_Learning  c_Physical_Education  c_Religious_Studies  \\\n",
       "0                        0                     0                    0   \n",
       "1                        0                     0                    0   \n",
       "2                        0                     0                    0   \n",
       "3                        0                     0                    0   \n",
       "4                        0                     0                    0   \n",
       "5                        0                     0                    0   \n",
       "6                        0                     0                    0   \n",
       "7                        0                     0                    0   \n",
       "8                        0                     0                    0   \n",
       "9                        0                     0                    0   \n",
       "10                       0                     0                    0   \n",
       "11                       0                     0                    0   \n",
       "12                       0                     0                    0   \n",
       "13                       0                     0                    0   \n",
       "14                       0                     0                    0   \n",
       "15                       0                     0                    0   \n",
       "16                       0                     0                    0   \n",
       "17                       0                     0                    0   \n",
       "18                       0                     0                    0   \n",
       "19                       0                     0                    0   \n",
       "20                       0                     0                    0   \n",
       "21                       0                     0                    0   \n",
       "22                       0                     0                    0   \n",
       "23                       0                     0                    0   \n",
       "24                       0                     0                    0   \n",
       "25                       0                     0                    0   \n",
       "26                       0                     0                    0   \n",
       "27                       0                     0                    0   \n",
       "28                       0                     0                    0   \n",
       "29                       0                     0                    0   \n",
       "...                    ...                   ...                  ...   \n",
       "35157                    0                     0                    0   \n",
       "35158                    0                     0                    0   \n",
       "35159                    0                     0                    0   \n",
       "35160                    0                     0                    0   \n",
       "35161                    0                     0                    0   \n",
       "35162                    0                     0                    0   \n",
       "35163                    0                     0                    0   \n",
       "35164                    0                     0                    0   \n",
       "35165                    0                     0                    0   \n",
       "35166                    0                     0                    0   \n",
       "35167                    0                     0                    0   \n",
       "35168                    0                     0                    0   \n",
       "35169                    0                     0                    0   \n",
       "35170                    0                     0                    0   \n",
       "35171                    0                     0                    0   \n",
       "35172                    1                     0                    0   \n",
       "35173                    0                     0                    0   \n",
       "35174                    0                     0                    0   \n",
       "35175                    0                     0                    0   \n",
       "35176                    0                     0                    0   \n",
       "35177                    0                     0                    0   \n",
       "35178                    0                     0                    0   \n",
       "35179                    0                     0                    0   \n",
       "35180                    0                     0                    0   \n",
       "35181                    0                     0                    0   \n",
       "35182                    1                     0                    0   \n",
       "35183                    1                     0                    0   \n",
       "35184                    0                     0                    0   \n",
       "35185                    0                     0                    0   \n",
       "35186                    0                     0                    0   \n",
       "\n",
       "       c_Science  c_Social_Science  c_Social_Work  \\\n",
       "0              1                 0              0   \n",
       "1              0                 0              0   \n",
       "2              0                 0              0   \n",
       "3              0                 0              0   \n",
       "4              0                 0              0   \n",
       "5              1                 0              0   \n",
       "6              0                 0              0   \n",
       "7              0                 0              0   \n",
       "8              1                 0              0   \n",
       "9              0                 0              0   \n",
       "10             1                 0              0   \n",
       "11             0                 0              0   \n",
       "12             1                 0              0   \n",
       "13             0                 0              0   \n",
       "14             1                 0              0   \n",
       "15             1                 1              0   \n",
       "16             0                 0              0   \n",
       "17             1                 0              0   \n",
       "18             0                 0              0   \n",
       "19             0                 0              0   \n",
       "20             0                 0              0   \n",
       "21             0                 0              0   \n",
       "22             0                 0              0   \n",
       "23             0                 0              0   \n",
       "24             0                 0              0   \n",
       "25             0                 0              0   \n",
       "26             0                 0              1   \n",
       "27             0                 0              0   \n",
       "28             0                 0              0   \n",
       "29             1                 0              0   \n",
       "...          ...               ...            ...   \n",
       "35157          0                 0              0   \n",
       "35158          1                 0              0   \n",
       "35159          0                 0              0   \n",
       "35160          0                 0              0   \n",
       "35161          0                 0              0   \n",
       "35162          0                 0              0   \n",
       "35163          1                 0              0   \n",
       "35164          1                 0              0   \n",
       "35165          0                 0              0   \n",
       "35166          0                 0              0   \n",
       "35167          0                 0              0   \n",
       "35168          1                 0              0   \n",
       "35169          1                 0              0   \n",
       "35170          0                 0              0   \n",
       "35171          0                 0              0   \n",
       "35172          0                 0              0   \n",
       "35173          1                 0              0   \n",
       "35174          0                 0              0   \n",
       "35175          0                 0              0   \n",
       "35176          0                 0              0   \n",
       "35177          0                 0              0   \n",
       "35178          0                 0              0   \n",
       "35179          0                 0              0   \n",
       "35180          1                 0              0   \n",
       "35181          0                 0              0   \n",
       "35182          0                 0              0   \n",
       "35183          0                 0              0   \n",
       "35184          1                 0              0   \n",
       "35185          0                 0              0   \n",
       "35186          1                 1              0   \n",
       "\n",
       "       c_Veterinary_&_Animal_Sciences  c_Women_Studies  \n",
       "0                                   0                0  \n",
       "1                                   0                0  \n",
       "2                                   0                0  \n",
       "3                                   0                0  \n",
       "4                                   0                0  \n",
       "5                                   0                0  \n",
       "6                                   0                0  \n",
       "7                                   0                0  \n",
       "8                                   0                0  \n",
       "9                                   0                0  \n",
       "10                                  0                0  \n",
       "11                                  0                0  \n",
       "12                                  0                0  \n",
       "13                                  0                0  \n",
       "14                                  0                0  \n",
       "15                                  0                0  \n",
       "16                                  0                0  \n",
       "17                                  0                0  \n",
       "18                                  0                0  \n",
       "19                                  0                0  \n",
       "20                                  0                0  \n",
       "21                                  0                0  \n",
       "22                                  0                0  \n",
       "23                                  0                0  \n",
       "24                                  0                0  \n",
       "25                                  0                0  \n",
       "26                                  0                0  \n",
       "27                                  0                0  \n",
       "28                                  0                0  \n",
       "29                                  0                0  \n",
       "...                               ...              ...  \n",
       "35157                               0                0  \n",
       "35158                               0                0  \n",
       "35159                               0                0  \n",
       "35160                               0                0  \n",
       "35161                               0                0  \n",
       "35162                               0                0  \n",
       "35163                               0                0  \n",
       "35164                               0                0  \n",
       "35165                               0                0  \n",
       "35166                               0                0  \n",
       "35167                               0                0  \n",
       "35168                               0                0  \n",
       "35169                               0                0  \n",
       "35170                               0                0  \n",
       "35171                               0                0  \n",
       "35172                               0                0  \n",
       "35173                               0                0  \n",
       "35174                               0                0  \n",
       "35175                               0                0  \n",
       "35176                               0                0  \n",
       "35177                               0                0  \n",
       "35178                               0                0  \n",
       "35179                               0                0  \n",
       "35180                               0                0  \n",
       "35181                               0                0  \n",
       "35182                               0                0  \n",
       "35183                               0                0  \n",
       "35184                               0                0  \n",
       "35185                               0                0  \n",
       "35186                               0                0  \n",
       "\n",
       "[35187 rows x 36 columns]"
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2.to_csv('col_courses_field.csv',index=False)"
   ]
  },
  {
   "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.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}