Untitled.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "batch ='E7'\n",
    "index_col_2_yr=\"B.TECH. II Yr.(IV SEMESTER TIMETABLE)EVEN SEMESTER 2019(Combined) JIIT128(Eff. FROM 03/01/2019)\"\n",
    "\n",
    "data=pd.read_excel(\"timetable2.xlsx\", index_col=index_col_2_yr)\n",
    "    #sperating cols\n",
    "data.columns=[1,2,3,4,5,6,7,8,9]\n",
    "\n",
    "data.columns.name=\" \"\n",
    "\n",
    "#seprating days\n",
    "\n",
    "mon=data.loc[\"MON\":\"TUE\"].iloc[:-1]\n",
    "tue=data.loc[\"TUE\":\"WED\"].iloc[:-1]\n",
    "wed=data.loc[\"WED\":\"THURSDAY\"].iloc[:-1]\n",
    "thu=data.loc[\"THURSDAY\":\"FRI\"].iloc[:-1]\n",
    "fri=data.loc[\"FRI\":\"SAT\"].iloc[:-1]\n",
    "sat=data.loc[\"SAT\":].iloc[:-1]\n",
    "\n",
    "\n",
    "\n",
    "#list of df\n",
    "data2=[mon,tue,wed,thu,fri,sat]\n",
    "\n",
    "final=data.dropna()\n",
    "#data2\n",
    "#final=data.dropna()\n",
    "#final\n",
    "#edit data frame here . make first row the column labels\n",
    "\n",
    "rows=[]\n",
    "\n",
    "\n",
    "\n",
    "#realgame\n",
    "#move all to class and fns\n",
    "\n",
    "for i in range (0,6):\n",
    "    newlist=[]\n",
    "    for j in range(1,10):\n",
    "        new=data2[i][j].dropna()\n",
    "        new2=new.str.contains(batch)\n",
    "        new3=new.str.contains('ALL')\n",
    "        new2=new2|new3\n",
    "        if not ((new[new2]).empty):\n",
    "            temp=new[new2].tolist()[0].replace(\"\\n\",\"\")\n",
    "\n",
    "            #comment to show subject code\n",
    "            # temp1=temp.find('(')\n",
    "            # temp2=temp.find(')')\n",
    "            # temp=temp[:temp1]+temp[temp2+1:]\n",
    "            #comment to show subject code\n",
    "\n",
    "            temp3=temp.find('/')\n",
    "            temp=temp[:temp3]\n",
    "            newlist.append(temp)\n",
    "            #method 2\n",
    "            #newlist.append(new[new2].tolist().replace('\\n',''))\n",
    "        else:\n",
    "            newlist.append(\" \")\n",
    "    rows.append(newlist)\n",
    "\n",
    "\n",
    "#final.append(new[new2])\n",
    "#final\n",
    "\n",
    "final=pd.DataFrame(rows,index=[\"Mon\",\"Tue\",\"Wed\",\"Thu\",\"Fri\",\"Sat\"],columns=data.iloc[0])\n",
    "final.columns.name=\"Days/Time\"\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B.TECH. II Yr.(IV SEMESTER TIMETABLE)EVEN SEMESTER 2019(Combined) JIIT128(Eff. FROM 03/01/2019)</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>9-9:50 AM</td>\n",
       "      <td>9:55-10:45 AM</td>\n",
       "      <td>10:50-11:40 AM</td>\n",
       "      <td>11:45-12:35 PM</td>\n",
       "      <td>12:40- 1:30 PM</td>\n",
       "      <td>1:35-2:25PM</td>\n",
       "      <td>2:30-3:20 PM</td>\n",
       "      <td>3:25-4:15 PM</td>\n",
       "      <td>4:20 PM - 5:10 PM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MON</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PE5(EC471)-134/BHC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LE3E4(EC411)- 118A/ANURAD HA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>PE2(EC471)-142/VG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PE6(EC474)-142/PK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PE4(EC473)-142/KULDEEP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PE7(EC472)-133/RAGHVENDRA</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>LE3E4(EC412)-118A/ATUL</td>\n",
       "      <td>LE3E4(EC414)-118A/SK</td>\n",
       "      <td>PE1(EC472)-133/SHS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LE7E8(EC414)-117/DCH</td>\n",
       "      <td>LE1E2(EC414)- 118A/SK</td>\n",
       "      <td>PF4(CI471)-238/PM/VARSHA</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>TF1F2F3F4E7F8(16B1NHS43 5)-127/SKVA</td>\n",
       "      <td>LE5E6(EC413)- 118B/PARUL</td>\n",
       "      <td>LE7E8(EC413)- 118A/JV</td>\n",
       "      <td>LF5F6(MA301)- 117/PINKEY</td>\n",
       "      <td>LE7E8(EC412)- 117/RAGHVEN DRA</td>\n",
       "      <td>LF7F8(MA301)-254/PKS</td>\n",
       "      <td>TF6(MA301)-113/PKS</td>\n",
       "      <td>PF3(CI471)-132/ARG/RASHMI</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>TF1F2F3F4F5F6F7F8(16B1N HS434)-126/EKTA</td>\n",
       "      <td>LF1F2F3F4F5F6F7F8(16B1 NHS431)-117/PRV</td>\n",
       "      <td>LF1F2(CI411)- 153/VARSHA</td>\n",
       "      <td>LF1F2(CI412)- 153/PUSHP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LF1F2(MA301)- 148/PINKEY</td>\n",
       "      <td>LE7E8(EC411)- 117/HEMANT</td>\n",
       "      <td>LE5E6(EC412)- 118B/YOGESH</td>\n",
       "      <td>TF7F8(16B1NCI432)- 121/MS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>TF1F2F3F4F5F6F7F8(19B12 HS412)-121/AA</td>\n",
       "      <td>LF1F2F3F4F5F6F7F8(16B1 NHS433)-148/SKVA</td>\n",
       "      <td>LF5F6(CI411)-117/PM</td>\n",
       "      <td>TF7(MA301)-113/PKS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LF3F4(CI412)- 153/RUPESH</td>\n",
       "      <td>TF1(CI412)-121/PUSHP</td>\n",
       "      <td>LF7F8(CI411)-148/MS</td>\n",
       "      <td>TE1E2E3E4E5E6E8(16B1 NHS435)-113/EKTA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>TE5E6E7E816B1NHS431)- 229/PRV</td>\n",
       "      <td>TE1(EC411)- 116/ANURADHA</td>\n",
       "      <td>TF3(CI412)- 127/RUPESH</td>\n",
       "      <td>TE2(EC412)-225/ATUL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TF2(CI411)- 225/VARSHA</td>\n",
       "      <td>TF1(MA301)- 116/PINKEY</td>\n",
       "      <td>TF5(CI412)-225/PUSHP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>TE7(EC412)- 229/RAGHVENDRA</td>\n",
       "      <td>TE2(EC413)- 225/KULDEEP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LF3F4(CI411)- 153/NEERAJ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TE4(EC411)- 229/HEMANT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LF7F8(CI412)- 254/NFCS1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TUE</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>PF1(CI471)-132/ARG/RASHMI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LE1E2E3E4E5E6E7E8 (16B1NHS431)- 118A/PRV</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LE3E4(EC411)- 118B/ANURAD HA</td>\n",
       "      <td>PE1(EC471)-134/BS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PF3(CI471)-132/ARG/RASHMI</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>PF2(CI471)-238/VARSHA/PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LE1E2E3E4E5E6E7E8 (16B1NHS433)- 117/SKVA</td>\n",
       "      <td>LF1F2F7F8(16B1NCI432\\n)-117/MS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PE2(EC474)-142/DCH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PF4(CI471)-238/VARSHA/PM</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>PE7(EC473)-134/JV</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LALL(16B1NHS434)- 148/EKTA</td>\n",
       "      <td>LF3F4F5F6(16B1NCI432\\n)-259/SHARIQ</td>\n",
       "      <td>LE5E6(EC414)- 118A/PK</td>\n",
       "      <td>PE8(EC472)-133/ATUL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LE1E2(EC411)- 118A/ANURADHA</td>\n",
       "      <td>LE1E2(EC412)- 118A/ATUL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>PE8(EC474)-142/DCH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LALL(16B1NHS435)- 254/ALKA</td>\n",
       "      <td>LF1F2F3F4F7(16B1NCI 438)-254/AVP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LE3E4(EC413)- 153/KULDEEP</td>\n",
       "      <td>LE3E4(EC414)-153/SK</td>\n",
       "      <td>LE7E8(EC413)- 118B/JV</td>\n",
       "      <td>LE7E8(EC411)- 118B/HEMANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>PE5(EC472)-133/SHS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LALL(19B12HS412)- 153/AA</td>\n",
       "      <td>LF5F6F8(16B1NCI438)- 257/ARG</td>\n",
       "      <td>LE1E2(EC413)- 228/KULDEEP</td>\n",
       "      <td>LF1F2(CI412)-148/PUSHP</td>\n",
       "      <td>LF1F2(CI411)- 148/VARSHA</td>\n",
       "      <td>TF1F2(16B1NCI432)- 126/MS</td>\n",
       "      <td>TF2(CI412)-121/PUSHP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>LF3F4(MA301)-117/AMS</td>\n",
       "      <td>LE3E4(EC411)- 118A/ANURADHA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LF3F4(CI412)- 117/RUPESH</td>\n",
       "      <td>TF4(CI412)- 121/RUPESH</td>\n",
       "      <td>TF5F6(16B1NCI432)- 121/SHARIQ</td>\n",
       "      <td>TF8(CI412)-113/GN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>LF5F6(MA301)-148/PINKEY</td>\n",
       "      <td>LF7F8(MA301)-254/PKS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LE7E8(EC412)- 148/RAGHVEN DRA</td>\n",
       "      <td>TF6(CI411)-127/PM</td>\n",
       "      <td>TF8(CI411)-225/RP</td>\n",
       "      <td>PE4(EC472)-133/YOGESH</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>LF7F8(CI411)-254/MS</td>\n",
       "      <td>LF3F4(CI411)-153/NEERAJ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TF5(CI412)-126/DVP</td>\n",
       "      <td>TF5(MA301)-113/PKS</td>\n",
       "      <td>TF7(CI412)-137/CG</td>\n",
       "      <td>TF5F6F7(16B1NHS431)- 230/PRV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>TE1(EC414)-126/SK</td>\n",
       "      <td>LF5F6(CI412)-148/DVP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LF7F8(CI412)-254/NFCS1</td>\n",
       "      <td>TE5(EC414)-229/PK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>TE4(EC412)- 229/RAGHVENDRA</td>\n",
       "      <td>TE1(EC413)-126/KULDEEP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TE5(EC411)-229/VG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WED</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>PF1(CI471)-132/ARG/RASHMI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LE1E2E3E4E5E6E7E8 (16B1NHS431)-\\n118A/PRV</td>\n",
       "      <td>TF4(MA301)-217/AMS</td>\n",
       "      <td>LE5E6(EC414)- 118A/PK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>PF2(CI471)-238/VARSHA/PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LE1E2E3E4E5E6E7E8 (16B1NHS433)- 117/SKVA</td>\n",
       "      <td>TF1F2F3F5F7(16B1NHS 431)-118A/PRV</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PF7F8(CI472)-AR,   PUSHP/GN/NFCS1/35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PF5(CI471)-132/RP/NEERAJ</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>PF5F6(CI472)-AR,PUSHP/RUPESH/NFCS1/35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LALL(16B1NHS434)- 148/EKTA</td>\n",
       "      <td>TE3(EC414)-137/PK</td>\n",
       "      <td>LE1E2(EC413)- 117/KULDEEP</td>\n",
       "      <td>PE7(EC474)-142/ABHAY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TF1(CI411)- 225/VARSHA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>PE5(EC474)-142/SK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LALL(16B1NHS435)- 254/ALKA</td>\n",
       "      <td>TE4(EC413)- 244(A)/PARUL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PE2(EC473)-134/BAJRANG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PE6(EC472)-133/YOGESH</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>PE6(EC471)-134/HEMANT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LALL(19B12HS412)- 118B/AA</td>\n",
       "      <td>TF1F2F3(16B1NHS433)- 228/SKVA</td>\n",
       "      <td>LE7E8(EC412)- 148/RAGHVEN DRA</td>\n",
       "      <td>LE5E6(EC413)- 118B/PARUL</td>\n",
       "      <td>LE5E6(EC411)- 118B/VG</td>\n",
       "      <td>PF6(CI471)-238/SHARIQ/NFCS1</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>LF7F8(CI412)-148/NFCS1</td>\n",
       "      <td>LF3F4F5F6(16B1NCI432)- 118B/SHARIQ</td>\n",
       "      <td>LE3E4(EC414)- 118A/SK</td>\n",
       "      <td>TF3(CI411)- 127/VARSHA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LF1F2F3F4F5F6F7F8(1 6B1NHS433)-148/SKVA</td>\n",
       "      <td>PE3(EC474)-142/VKT</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>LF1F2(GE301)- 254/MANISHA</td>\n",
       "      <td>LF1F2F3F4F7(16B1NCI438)- 148/AVP</td>\n",
       "      <td>LE5E6(EC411)- 118B/VG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LE1E2(EC413)- 117/KULDEEP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LE5E6(EC412)- 118B/YOGESH</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>TE5(EC412)-229/YOGESH</td>\n",
       "      <td>LF5F6F8(16B1NCI438)- 153/ARG</td>\n",
       "      <td>LF7F8(GE301)- 254/MANISHA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TF5(CI411)-127/PM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>TE6(EC411)-225/VG</td>\n",
       "      <td>TE5(EC413)-229/PARUL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>LE1E2(EC411)- 117/ANURADHA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAT</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>TE1E2E3E4(16B1NHS433)- 126/SKVA</td>\n",
       "      <td>PE3(EC471)-134/ANURADHA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LE3E4(EC413)- 153/KULDEEP</td>\n",
       "      <td>LE3E4(EC412)- 153/ATUL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>TE1E2E3E4(16B1NHS431)- 121/PRV</td>\n",
       "      <td>PE4(EC474)-142/VKT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LF3F4(GE301)- 254/MANISHA</td>\n",
       "      <td>LF5F6(GE301)- 254/MANISHA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>TE1E2E3E4E5E6E7E8(16B1 NHS434)-113/EKTA</td>\n",
       "      <td>TF6F8(16B1NCI438)- 121/ARG</td>\n",
       "      <td>LF5F6(CI412)- 153/DVP</td>\n",
       "      <td>LF5F6(CI411)-118A/PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>TE1E2E3E4E5E6E7E8(19B1 2HS412)-225/AA</td>\n",
       "      <td>LF1F2(CI412)-148/PUSHP</td>\n",
       "      <td>LF1F2(CI411)- 118A/VARSHA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>LF1F2(GE301)- 254/MANISHA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LF7F8(GE301)- 254/MANISHA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NOTE: COURSE CODES MENTIONED IN THE TIMETABLE ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>Wriiten Code</td>\n",
       "      <td>Subject code</td>\n",
       "      <td>Subject Name</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Written Code</td>\n",
       "      <td>Subject code</td>\n",
       "      <td>Subject Name</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>EC411</td>\n",
       "      <td>15B11EC411</td>\n",
       "      <td>Analogue  Electronics</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MA301</td>\n",
       "      <td>15B11MA301</td>\n",
       "      <td>Probability &amp; Random Processes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>EC412</td>\n",
       "      <td>15B11EC412</td>\n",
       "      <td>Analogue Communications</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NCI432</td>\n",
       "      <td>16B1NCI432</td>\n",
       "      <td>Fuzzy Logic and Neural Networks</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>EC413</td>\n",
       "      <td>15B11EC413</td>\n",
       "      <td>Digital Signal Processing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16B1NHS434</td>\n",
       "      <td>16B1NHS434</td>\n",
       "      <td>INTRODUCTION TO CONTEMPORARY FORM OF LITERATURE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>EC414</td>\n",
       "      <td>15B11EC414</td>\n",
       "      <td>VLSI Technology and Applications</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NCI438</td>\n",
       "      <td>16B1NCI438</td>\n",
       "      <td>INTRODUCTION TO DATA WAREHOUSE AND DATA MINING</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>EC471</td>\n",
       "      <td>15B17EC471</td>\n",
       "      <td>Analogue Electronics Lab</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CI411</td>\n",
       "      <td>15B11CI411</td>\n",
       "      <td>Algorithms and Problem Solving</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>EC472</td>\n",
       "      <td>15B17EC472</td>\n",
       "      <td>Analogue Communications Lab</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CI412</td>\n",
       "      <td>15B11CI412</td>\n",
       "      <td>Operating Systems and Systems Programming</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>EC473</td>\n",
       "      <td>15B17EC473</td>\n",
       "      <td>Digital Signal Processing Lab</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CI471</td>\n",
       "      <td>15B17CI471</td>\n",
       "      <td>Algorithms and Problem Solving Lab</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>EC474</td>\n",
       "      <td>15B17EC474</td>\n",
       "      <td>142</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CI472</td>\n",
       "      <td>15B17CI472</td>\n",
       "      <td>Operating Systems and Systems Programming Lab</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NCI432</td>\n",
       "      <td>16B1NCI432</td>\n",
       "      <td>FUZZY LOGIC AND NEURAL NETWORKS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16B11NHS433</td>\n",
       "      <td>16B11NHS433</td>\n",
       "      <td>FINANCIAL MANAGEMENT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NCI433</td>\n",
       "      <td>16B1NCI433</td>\n",
       "      <td>ANIMATION AND MULTIMEDIA\\nDEVELOPMENT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GE301</td>\n",
       "      <td>15B11GE301</td>\n",
       "      <td>Environmental Science</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NCI437</td>\n",
       "      <td>16B1NCI437</td>\n",
       "      <td>UNIX PROGRAMMING</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19B12HS412</td>\n",
       "      <td>19B12HS412</td>\n",
       "      <td>INDUSTRIAL ECONOMICS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>16B1NHS431</td>\n",
       "      <td>16B1NHS431</td>\n",
       "      <td>HUMAN RESOURCE MANAGEMENT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16B1NHS435</td>\n",
       "      <td>16B1NHS435</td>\n",
       "      <td>SOCIOLOGY OF MEDIA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>16B1NHS432</td>\n",
       "      <td>16B1NHS432</td>\n",
       "      <td>POSITIVE PSYCHOLOGY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>86 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                                    1  \\\n",
       "B.TECH. II Yr.(IV SEMESTER TIMETABLE)EVEN SEMES...                                                      \n",
       "NaN                                                                                         9-9:50 AM   \n",
       "MON                                                                                               NaN   \n",
       "NaN                                                                                 PE2(EC471)-142/VG   \n",
       "NaN                                                                            LE3E4(EC412)-118A/ATUL   \n",
       "NaN                                                               TF1F2F3F4E7F8(16B1NHS43 5)-127/SKVA   \n",
       "NaN                                                           TF1F2F3F4F5F6F7F8(16B1N HS434)-126/EKTA   \n",
       "NaN                                                             TF1F2F3F4F5F6F7F8(19B12 HS412)-121/AA   \n",
       "NaN                                                                     TE5E6E7E816B1NHS431)- 229/PRV   \n",
       "NaN                                                                                               NaN   \n",
       "NaN                                                                                               NaN   \n",
       "NaN                                                                                               NaN   \n",
       "NaN                                                                                               NaN   \n",
       "TUE                                                                                               NaN   \n",
       "NaN                                                                         PF1(CI471)-132/ARG/RASHMI   \n",
       "NaN                                                                          PF2(CI471)-238/VARSHA/PM   \n",
       "NaN                                                                                 PE7(EC473)-134/JV   \n",
       "NaN                                                                                PE8(EC474)-142/DCH   \n",
       "NaN                                                                                PE5(EC472)-133/SHS   \n",
       "NaN                                                                              LF3F4(MA301)-117/AMS   \n",
       "NaN                                                                           LF5F6(MA301)-148/PINKEY   \n",
       "NaN                                                                               LF7F8(CI411)-254/MS   \n",
       "NaN                                                                                 TE1(EC414)-126/SK   \n",
       "NaN                                                                        TE4(EC412)- 229/RAGHVENDRA   \n",
       "NaN                                                                                               NaN   \n",
       "WED                                                                                               NaN   \n",
       "NaN                                                                         PF1(CI471)-132/ARG/RASHMI   \n",
       "NaN                                                                          PF2(CI471)-238/VARSHA/PM   \n",
       "NaN                                                             PF5F6(CI472)-AR,PUSHP/RUPESH/NFCS1/35   \n",
       "NaN                                                                                 PE5(EC474)-142/SK   \n",
       "NaN                                                                             PE6(EC471)-134/HEMANT   \n",
       "...                                                                                               ...   \n",
       "NaN                                                                            LF7F8(CI412)-148/NFCS1   \n",
       "NaN                                                                         LF1F2(GE301)- 254/MANISHA   \n",
       "NaN                                                                             TE5(EC412)-229/YOGESH   \n",
       "NaN                                                                                 TE6(EC411)-225/VG   \n",
       "NaN                                                                        LE1E2(EC411)- 117/ANURADHA   \n",
       "NaN                                                                                               NaN   \n",
       "NaN                                                                                               NaN   \n",
       "SAT                                                                                               NaN   \n",
       "NaN                                                                   TE1E2E3E4(16B1NHS433)- 126/SKVA   \n",
       "NaN                                                                    TE1E2E3E4(16B1NHS431)- 121/PRV   \n",
       "NaN                                                           TE1E2E3E4E5E6E7E8(16B1 NHS434)-113/EKTA   \n",
       "NaN                                                             TE1E2E3E4E5E6E7E8(19B1 2HS412)-225/AA   \n",
       "NaN                                                                         LF1F2(GE301)- 254/MANISHA   \n",
       "NaN                                                                                               NaN   \n",
       "NaN                                                                                               NaN   \n",
       "NaN                                                 NOTE: COURSE CODES MENTIONED IN THE TIMETABLE ...   \n",
       "NaN                                                                                      Wriiten Code   \n",
       "NaN                                                                                             EC411   \n",
       "NaN                                                                                             EC412   \n",
       "NaN                                                                                             EC413   \n",
       "NaN                                                                                             EC414   \n",
       "NaN                                                                                             EC471   \n",
       "NaN                                                                                             EC472   \n",
       "NaN                                                                                             EC473   \n",
       "NaN                                                                                             EC474   \n",
       "NaN                                                                                            NCI432   \n",
       "NaN                                                                                            NCI433   \n",
       "NaN                                                                                            NCI437   \n",
       "NaN                                                                                        16B1NHS431   \n",
       "NaN                                                                                        16B1NHS432   \n",
       "\n",
       "                                                                                          2  \\\n",
       "B.TECH. II Yr.(IV SEMESTER TIMETABLE)EVEN SEMES...                                            \n",
       "NaN                                                                           9:55-10:45 AM   \n",
       "MON                                                                                     NaN   \n",
       "NaN                                                                                     NaN   \n",
       "NaN                                                                    LE3E4(EC414)-118A/SK   \n",
       "NaN                                                                LE5E6(EC413)- 118B/PARUL   \n",
       "NaN                                                  LF1F2F3F4F5F6F7F8(16B1 NHS431)-117/PRV   \n",
       "NaN                                                 LF1F2F3F4F5F6F7F8(16B1 NHS433)-148/SKVA   \n",
       "NaN                                                                TE1(EC411)- 116/ANURADHA   \n",
       "NaN                                                              TE7(EC412)- 229/RAGHVENDRA   \n",
       "NaN                                                                                     NaN   \n",
       "NaN                                                                                     NaN   \n",
       "NaN                                                                                     NaN   \n",
       "TUE                                                                                     NaN   \n",
       "NaN                                                                                     NaN   \n",
       "NaN                                                                                     NaN   \n",
       "NaN                                                                                     NaN   \n",
       "NaN                                                                                     NaN   \n",
       "NaN                                                                                     NaN   \n",
       "NaN                                                             LE3E4(EC411)- 118A/ANURADHA   \n",
       "NaN                                                                    LF7F8(MA301)-254/PKS   \n",
       "NaN                                                                 LF3F4(CI411)-153/NEERAJ   \n",
       "NaN                                                                    LF5F6(CI412)-148/DVP   \n",
       "NaN                                                                  TE1(EC413)-126/KULDEEP   \n",
       "NaN                                                                                     NaN   \n",
       "WED                                                                                     NaN   \n",
       "NaN                                                                                     NaN   \n",
       "NaN                                                                                     NaN   \n",
       "NaN                                                                                     NaN   \n",
       "NaN                                                                                     NaN   \n",
       "NaN                                                                                     NaN   \n",
       "...                                                                                     ...   \n",
       "NaN                                                      LF3F4F5F6(16B1NCI432)- 118B/SHARIQ   \n",
       "NaN                                                        LF1F2F3F4F7(16B1NCI438)- 148/AVP   \n",
       "NaN                                                            LF5F6F8(16B1NCI438)- 153/ARG   \n",
       "NaN                                                                    TE5(EC413)-229/PARUL   \n",
       "NaN                                                                                     NaN   \n",
       "NaN                                                                                     NaN   \n",
       "NaN                                                                                     NaN   \n",
       "SAT                                                                                     NaN   \n",
       "NaN                                                                 PE3(EC471)-134/ANURADHA   \n",
       "NaN                                                                      PE4(EC474)-142/VKT   \n",
       "NaN                                                              TF6F8(16B1NCI438)- 121/ARG   \n",
       "NaN                                                                  LF1F2(CI412)-148/PUSHP   \n",
       "NaN                                                                                     NaN   \n",
       "NaN                                                                                     NaN   \n",
       "NaN                                                                                     NaN   \n",
       "NaN                                                                                     NaN   \n",
       "NaN                                                                            Subject code   \n",
       "NaN                                                                              15B11EC411   \n",
       "NaN                                                                              15B11EC412   \n",
       "NaN                                                                              15B11EC413   \n",
       "NaN                                                                              15B11EC414   \n",
       "NaN                                                                              15B17EC471   \n",
       "NaN                                                                              15B17EC472   \n",
       "NaN                                                                              15B17EC473   \n",
       "NaN                                                                              15B17EC474   \n",
       "NaN                                                                              16B1NCI432   \n",
       "NaN                                                                              16B1NCI433   \n",
       "NaN                                                                              16B1NCI437   \n",
       "NaN                                                                              16B1NHS431   \n",
       "NaN                                                                              16B1NHS432   \n",
       "\n",
       "                                                                                            3  \\\n",
       "B.TECH. II Yr.(IV SEMESTER TIMETABLE)EVEN SEMES...                                              \n",
       "NaN                                                                            10:50-11:40 AM   \n",
       "MON                                                                        PE5(EC471)-134/BHC   \n",
       "NaN                                                                         PE6(EC474)-142/PK   \n",
       "NaN                                                                        PE1(EC472)-133/SHS   \n",
       "NaN                                                                     LE7E8(EC413)- 118A/JV   \n",
       "NaN                                                                  LF1F2(CI411)- 153/VARSHA   \n",
       "NaN                                                                       LF5F6(CI411)-117/PM   \n",
       "NaN                                                                    TF3(CI412)- 127/RUPESH   \n",
       "NaN                                                                   TE2(EC413)- 225/KULDEEP   \n",
       "NaN                                                                    TE4(EC411)- 229/HEMANT   \n",
       "NaN                                                                                       NaN   \n",
       "NaN                                                                                       NaN   \n",
       "TUE                                                                                       NaN   \n",
       "NaN                                                  LE1E2E3E4E5E6E7E8 (16B1NHS431)- 118A/PRV   \n",
       "NaN                                                  LE1E2E3E4E5E6E7E8 (16B1NHS433)- 117/SKVA   \n",
       "NaN                                                                LALL(16B1NHS434)- 148/EKTA   \n",
       "NaN                                                                LALL(16B1NHS435)- 254/ALKA   \n",
       "NaN                                                                  LALL(19B12HS412)- 153/AA   \n",
       "NaN                                                                                       NaN   \n",
       "NaN                                                                                       NaN   \n",
       "NaN                                                                                       NaN   \n",
       "NaN                                                                                       NaN   \n",
       "NaN                                                                                       NaN   \n",
       "NaN                                                                                       NaN   \n",
       "WED                                                                                       NaN   \n",
       "NaN                                                 LE1E2E3E4E5E6E7E8 (16B1NHS431)-\\n118A/PRV   \n",
       "NaN                                                  LE1E2E3E4E5E6E7E8 (16B1NHS433)- 117/SKVA   \n",
       "NaN                                                                LALL(16B1NHS434)- 148/EKTA   \n",
       "NaN                                                                LALL(16B1NHS435)- 254/ALKA   \n",
       "NaN                                                                 LALL(19B12HS412)- 118B/AA   \n",
       "...                                                                                       ...   \n",
       "NaN                                                                     LE3E4(EC414)- 118A/SK   \n",
       "NaN                                                                     LE5E6(EC411)- 118B/VG   \n",
       "NaN                                                                 LF7F8(GE301)- 254/MANISHA   \n",
       "NaN                                                                                       NaN   \n",
       "NaN                                                                                       NaN   \n",
       "NaN                                                                                       NaN   \n",
       "NaN                                                                                       NaN   \n",
       "SAT                                                                                       NaN   \n",
       "NaN                                                                                       NaN   \n",
       "NaN                                                                                       NaN   \n",
       "NaN                                                                     LF5F6(CI412)- 153/DVP   \n",
       "NaN                                                                 LF1F2(CI411)- 118A/VARSHA   \n",
       "NaN                                                                 LF7F8(GE301)- 254/MANISHA   \n",
       "NaN                                                                                       NaN   \n",
       "NaN                                                                                       NaN   \n",
       "NaN                                                                                       NaN   \n",
       "NaN                                                                              Subject Name   \n",
       "NaN                                                                     Analogue  Electronics   \n",
       "NaN                                                                   Analogue Communications   \n",
       "NaN                                                                 Digital Signal Processing   \n",
       "NaN                                                          VLSI Technology and Applications   \n",
       "NaN                                                                  Analogue Electronics Lab   \n",
       "NaN                                                               Analogue Communications Lab   \n",
       "NaN                                                             Digital Signal Processing Lab   \n",
       "NaN                                                                                       142   \n",
       "NaN                                                           FUZZY LOGIC AND NEURAL NETWORKS   \n",
       "NaN                                                     ANIMATION AND MULTIMEDIA\\nDEVELOPMENT   \n",
       "NaN                                                                          UNIX PROGRAMMING   \n",
       "NaN                                                                 HUMAN RESOURCE MANAGEMENT   \n",
       "NaN                                                                       POSITIVE PSYCHOLOGY   \n",
       "\n",
       "                                                                                     4  \\\n",
       "B.TECH. II Yr.(IV SEMESTER TIMETABLE)EVEN SEMES...                                       \n",
       "NaN                                                                     11:45-12:35 PM   \n",
       "MON                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                           LF5F6(MA301)- 117/PINKEY   \n",
       "NaN                                                            LF1F2(CI412)- 153/PUSHP   \n",
       "NaN                                                                 TF7(MA301)-113/PKS   \n",
       "NaN                                                                TE2(EC412)-225/ATUL   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "TUE                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                     LF1F2F7F8(16B1NCI432\\n)-117/MS   \n",
       "NaN                                                 LF3F4F5F6(16B1NCI432\\n)-259/SHARIQ   \n",
       "NaN                                                   LF1F2F3F4F7(16B1NCI 438)-254/AVP   \n",
       "NaN                                                       LF5F6F8(16B1NCI438)- 257/ARG   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "WED                                                                                NaN   \n",
       "NaN                                                                 TF4(MA301)-217/AMS   \n",
       "NaN                                                  TF1F2F3F5F7(16B1NHS 431)-118A/PRV   \n",
       "NaN                                                                  TE3(EC414)-137/PK   \n",
       "NaN                                                           TE4(EC413)- 244(A)/PARUL   \n",
       "NaN                                                      TF1F2F3(16B1NHS433)- 228/SKVA   \n",
       "...                                                                                ...   \n",
       "NaN                                                             TF3(CI411)- 127/VARSHA   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "SAT                                                                                NaN   \n",
       "NaN                                                          LE3E4(EC413)- 153/KULDEEP   \n",
       "NaN                                                          LF3F4(GE301)- 254/MANISHA   \n",
       "NaN                                                               LF5F6(CI411)-118A/PM   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "NaN                                                                                NaN   \n",
       "\n",
       "                                                                                5  \\\n",
       "B.TECH. II Yr.(IV SEMESTER TIMETABLE)EVEN SEMES...                                  \n",
       "NaN                                                                12:40- 1:30 PM   \n",
       "MON                                                  LE3E4(EC411)- 118A/ANURAD HA   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                 LE7E8(EC412)- 117/RAGHVEN DRA   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "TUE                                                                           NaN   \n",
       "NaN                                                  LE3E4(EC411)- 118B/ANURAD HA   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                         LE5E6(EC414)- 118A/PK   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                     LE1E2(EC413)- 228/KULDEEP   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                 LE7E8(EC412)- 148/RAGHVEN DRA   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "WED                                                                           NaN   \n",
       "NaN                                                         LE5E6(EC414)- 118A/PK   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                     LE1E2(EC413)- 117/KULDEEP   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                 LE7E8(EC412)- 148/RAGHVEN DRA   \n",
       "...                                                                           ...   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                     LE1E2(EC413)- 117/KULDEEP   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "SAT                                                                           NaN   \n",
       "NaN                                                        LE3E4(EC412)- 153/ATUL   \n",
       "NaN                                                     LF5F6(GE301)- 254/MANISHA   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                  Written Code   \n",
       "NaN                                                                         MA301   \n",
       "NaN                                                                        NCI432   \n",
       "NaN                                                                    16B1NHS434   \n",
       "NaN                                                                        NCI438   \n",
       "NaN                                                                         CI411   \n",
       "NaN                                                                         CI412   \n",
       "NaN                                                                         CI471   \n",
       "NaN                                                                         CI472   \n",
       "NaN                                                                   16B11NHS433   \n",
       "NaN                                                                         GE301   \n",
       "NaN                                                                    19B12HS412   \n",
       "NaN                                                                    16B1NHS435   \n",
       "NaN                                                                           NaN   \n",
       "\n",
       "                                                                                       6  \\\n",
       "B.TECH. II Yr.(IV SEMESTER TIMETABLE)EVEN SEMES...                                         \n",
       "NaN                                                                          1:35-2:25PM   \n",
       "MON                                                                                  NaN   \n",
       "NaN                                                               PE4(EC473)-142/KULDEEP   \n",
       "NaN                                                                 LE7E8(EC414)-117/DCH   \n",
       "NaN                                                                 LF7F8(MA301)-254/PKS   \n",
       "NaN                                                             LF1F2(MA301)- 148/PINKEY   \n",
       "NaN                                                             LF3F4(CI412)- 153/RUPESH   \n",
       "NaN                                                                                  NaN   \n",
       "NaN                                                                                  NaN   \n",
       "NaN                                                                                  NaN   \n",
       "NaN                                                                                  NaN   \n",
       "NaN                                                                                  NaN   \n",
       "TUE                                                                                  NaN   \n",
       "NaN                                                                    PE1(EC471)-134/BS   \n",
       "NaN                                                                   PE2(EC474)-142/DCH   \n",
       "NaN                                                                  PE8(EC472)-133/ATUL   \n",
       "NaN                                                            LE3E4(EC413)- 153/KULDEEP   \n",
       "NaN                                                               LF1F2(CI412)-148/PUSHP   \n",
       "NaN                                                             LF3F4(CI412)- 117/RUPESH   \n",
       "NaN                                                                    TF6(CI411)-127/PM   \n",
       "NaN                                                                   TF5(CI412)-126/DVP   \n",
       "NaN                                                               LF7F8(CI412)-254/NFCS1   \n",
       "NaN                                                                    TE5(EC411)-229/VG   \n",
       "NaN                                                                                  NaN   \n",
       "WED                                                                                  NaN   \n",
       "NaN                                                                                  NaN   \n",
       "NaN                                                 PF7F8(CI472)-AR,   PUSHP/GN/NFCS1/35   \n",
       "NaN                                                                 PE7(EC474)-142/ABHAY   \n",
       "NaN                                                               PE2(EC473)-134/BAJRANG   \n",
       "NaN                                                             LE5E6(EC413)- 118B/PARUL   \n",
       "...                                                                                  ...   \n",
       "NaN                                                                                  NaN   \n",
       "NaN                                                                                  NaN   \n",
       "NaN                                                                                  NaN   \n",
       "NaN                                                                                  NaN   \n",
       "NaN                                                                                  NaN   \n",
       "NaN                                                                                  NaN   \n",
       "NaN                                                                                  NaN   \n",
       "SAT                                                                                  NaN   \n",
       "NaN                                                                                  NaN   \n",
       "NaN                                                                                  NaN   \n",
       "NaN                                                                                  NaN   \n",
       "NaN                                                                                  NaN   \n",
       "NaN                                                                                  NaN   \n",
       "NaN                                                                                  NaN   \n",
       "NaN                                                                                  NaN   \n",
       "NaN                                                                                  NaN   \n",
       "NaN                                                                         Subject code   \n",
       "NaN                                                                           15B11MA301   \n",
       "NaN                                                                           16B1NCI432   \n",
       "NaN                                                                           16B1NHS434   \n",
       "NaN                                                                           16B1NCI438   \n",
       "NaN                                                                           15B11CI411   \n",
       "NaN                                                                           15B11CI412   \n",
       "NaN                                                                           15B17CI471   \n",
       "NaN                                                                           15B17CI472   \n",
       "NaN                                                                          16B11NHS433   \n",
       "NaN                                                                           15B11GE301   \n",
       "NaN                                                                           19B12HS412   \n",
       "NaN                                                                           16B1NHS435   \n",
       "NaN                                                                                  NaN   \n",
       "\n",
       "                                                                                                  7  \\\n",
       "B.TECH. II Yr.(IV SEMESTER TIMETABLE)EVEN SEMES...                                                    \n",
       "NaN                                                                                    2:30-3:20 PM   \n",
       "MON                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                           LE1E2(EC414)- 118A/SK   \n",
       "NaN                                                                              TF6(MA301)-113/PKS   \n",
       "NaN                                                                        LE7E8(EC411)- 117/HEMANT   \n",
       "NaN                                                                            TF1(CI412)-121/PUSHP   \n",
       "NaN                                                                          TF2(CI411)- 225/VARSHA   \n",
       "NaN                                                                        LF3F4(CI411)- 153/NEERAJ   \n",
       "NaN                                                                         LF7F8(CI412)- 254/NFCS1   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "TUE                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                             LE3E4(EC414)-153/SK   \n",
       "NaN                                                                        LF1F2(CI411)- 148/VARSHA   \n",
       "NaN                                                                          TF4(CI412)- 121/RUPESH   \n",
       "NaN                                                                               TF8(CI411)-225/RP   \n",
       "NaN                                                                              TF5(MA301)-113/PKS   \n",
       "NaN                                                                               TE5(EC414)-229/PK   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "WED                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                           LE5E6(EC411)- 118B/VG   \n",
       "...                                                                                             ...   \n",
       "NaN                                                         LF1F2F3F4F5F6F7F8(1 6B1NHS433)-148/SKVA   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "SAT                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                                             NaN   \n",
       "NaN                                                                                    Subject Name   \n",
       "NaN                                                                  Probability & Random Processes   \n",
       "NaN                                                                 Fuzzy Logic and Neural Networks   \n",
       "NaN                                                 INTRODUCTION TO CONTEMPORARY FORM OF LITERATURE   \n",
       "NaN                                                  INTRODUCTION TO DATA WAREHOUSE AND DATA MINING   \n",
       "NaN                                                                  Algorithms and Problem Solving   \n",
       "NaN                                                       Operating Systems and Systems Programming   \n",
       "NaN                                                              Algorithms and Problem Solving Lab   \n",
       "NaN                                                   Operating Systems and Systems Programming Lab   \n",
       "NaN                                                                            FINANCIAL MANAGEMENT   \n",
       "NaN                                                                           Environmental Science   \n",
       "NaN                                                                            INDUSTRIAL ECONOMICS   \n",
       "NaN                                                                              SOCIOLOGY OF MEDIA   \n",
       "NaN                                                                                             NaN   \n",
       "\n",
       "                                                                                8  \\\n",
       "B.TECH. II Yr.(IV SEMESTER TIMETABLE)EVEN SEMES...                                  \n",
       "NaN                                                                  3:25-4:15 PM   \n",
       "MON                                                                           NaN   \n",
       "NaN                                                     PE7(EC472)-133/RAGHVENDRA   \n",
       "NaN                                                      PF4(CI471)-238/PM/VARSHA   \n",
       "NaN                                                     PF3(CI471)-132/ARG/RASHMI   \n",
       "NaN                                                     LE5E6(EC412)- 118B/YOGESH   \n",
       "NaN                                                           LF7F8(CI411)-148/MS   \n",
       "NaN                                                        TF1(MA301)- 116/PINKEY   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "TUE                                                                           NaN   \n",
       "NaN                                                     PF3(CI471)-132/ARG/RASHMI   \n",
       "NaN                                                      PF4(CI471)-238/VARSHA/PM   \n",
       "NaN                                                   LE1E2(EC411)- 118A/ANURADHA   \n",
       "NaN                                                         LE7E8(EC413)- 118B/JV   \n",
       "NaN                                                     TF1F2(16B1NCI432)- 126/MS   \n",
       "NaN                                                 TF5F6(16B1NCI432)- 121/SHARIQ   \n",
       "NaN                                                         PE4(EC472)-133/YOGESH   \n",
       "NaN                                                             TF7(CI412)-137/CG   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "WED                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                      PF5(CI471)-132/RP/NEERAJ   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                         PE6(EC472)-133/YOGESH   \n",
       "NaN                                                   PF6(CI471)-238/SHARIQ/NFCS1   \n",
       "...                                                                           ...   \n",
       "NaN                                                            PE3(EC474)-142/VKT   \n",
       "NaN                                                     LE5E6(EC412)- 118B/YOGESH   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "SAT                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "NaN                                                                           NaN   \n",
       "\n",
       "                                                                                        9  \n",
       "B.TECH. II Yr.(IV SEMESTER TIMETABLE)EVEN SEMES...                                         \n",
       "NaN                                                                     4:20 PM - 5:10 PM  \n",
       "MON                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                             TF7F8(16B1NCI432)- 121/MS  \n",
       "NaN                                                 TE1E2E3E4E5E6E8(16B1 NHS435)-113/EKTA  \n",
       "NaN                                                                  TF5(CI412)-225/PUSHP  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "TUE                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                               LE1E2(EC412)- 118A/ATUL  \n",
       "NaN                                                             LE7E8(EC411)- 118B/HEMANT  \n",
       "NaN                                                                  TF2(CI412)-121/PUSHP  \n",
       "NaN                                                                     TF8(CI412)-113/GN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                          TF5F6F7(16B1NHS431)- 230/PRV  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "WED                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                TF1(CI411)- 225/VARSHA  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "...                                                                                   ...  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                     TF5(CI411)-127/PM  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "SAT                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "NaN                                                                                   NaN  \n",
       "\n",
       "[86 rows x 9 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "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.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}