iit_mum.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "iit_mum=pd.read_html('https://opac.library.iitb.ac.in/cgi-bin/koha/opac-search.pl?idx=kw&q=computer%20science&limit=mc-itype%3ATD&offset=0&sort_by=relevance_dsc')\n",
    "iit_mum=iit_mum[0]\n",
    "for i in range(10,1000,10):\n",
    "    url=\"https://opac.library.iitb.ac.in/cgi-bin/koha/opac-search.pl?idx=kw&q=computer%20science&limit=mc-itype%3ATD&offset=\"+str(i)+\"&sort_by=relevance_dsc\"\n",
    "    time.sleep(random.randint(10,15))\n",
    "    tmp=pd.read_html(url)\n",
    "    if len(tmp) != 0:\n",
    "        iit_mum=pd.concat([iit_mum, tmp[0]])\n",
    "    else:\n",
    "        break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "iit_mum1=iit_mum[2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "metadata": {},
   "outputs": [],
   "source": [
    "iit_mum2=iit_mum[2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {},
   "outputs": [],
   "source": [
    "iit_mum2.to_csv('./college/iit_mum.csv', header=False, index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "a=pd.read_html('https://opac.library.iitb.ac.in/cgi-bin/koha/opac-search.pl?idx=kw&\n",
    "               q=computer%20science&limit=mc-itype%3ATD&offset=600&sort_by=relevance_dsc')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [],
   "source": [
    "iit_mum1=iit_mum1.replace('No cover image available  ','',regex=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "iit_mum1=iit_mum1.reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "iit_mum1=iit_mum1.drop(columns=['index'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "iit_mum1[['title','other']]=iit_mum1[2].str.split(\" by \",1,expand=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [],
   "source": [
    "iit_mum1[['author','other']]=iit_mum1['other'].str.split('|',1,expand=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [],
   "source": [
    "iit_mum1[['supervisor','other']]=iit_mum1['other'].str.split('Edition',1,expand=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [],
   "source": [
    "iit_mum1[['year','other']]=iit_mum1['other'].str.split('Online',1,expand=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [],
   "source": [
    "iit_mum1[['publisher','year']]=iit_mum1['year'].str.split(';',1,expand=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [],
   "source": [
    "iit_mum1=iit_mum1.drop(columns=[2])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [],
   "source": [
    "iit_mum1[['sup1','sup2','other1']]=iit_mum1['supervisor'].str.split('|',2,expand=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "metadata": {},
   "outputs": [],
   "source": [
    "iit_mum1[['date']]=iit_mum1['supervisor'].str.extract('(\\d+)')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Shoreline change and coastal vulnerability considering projected climate (R)',\n",
       "       None, 'Rajasree, B.R ',\n",
       "       ' Deo, M.C [Supervisor] | Indian Institute of Technology Bombay. Department of Civil Engineering.Material type: Book; Format: print  ; Literary form: Not fiction  Publisher: Mumbai IIT 2018Dissertation note: Thesis Ph.D. Indian Institute of Technology Bombay. Department of Civil Engineering 2018 Availability: Items available for reference: [Call number: 043:551.465:681.342 Raj] (1). Lists:  Display List 27/05/2019-02/06/2019.  Add to cart',\n",
       "       None, None, ' Deo, M.C [Supervisor] ',\n",
       "       ' Indian Institute of Technology Bombay. Department of Civil Engineering.Material type: Book; Format: print  ; Literary form: Not fiction  Publisher: Mumbai IIT 2018Dissertation note: Thesis Ph.D. Indian Institute of Technology Bombay. Department of Civil Engineering 2018 Availability: Items available for reference: [Call number: 043:551.465:681.342 Raj] (1). Lists:  Display List 27/05/2019-02/06/2019.  Add to cart',\n",
       "       None], dtype=object)"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "iit_mum1.values[539]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "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>title</th>\n",
       "      <th>other</th>\n",
       "      <th>author</th>\n",
       "      <th>supervisor</th>\n",
       "      <th>year</th>\n",
       "      <th>publisher</th>\n",
       "      <th>sup1</th>\n",
       "      <th>sup2</th>\n",
       "      <th>other1</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Expert system for network topology determinati...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Vidya Sagar, V.S.K.E</td>\n",
       "      <td>Khaparde, S.A. and Biswas, S.</td>\n",
       "      <td>IIT ; 1988</td>\n",
       "      <td>: Publisher: Bombay</td>\n",
       "      <td>Khaparde, S.A. and Biswas, S.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Theme based planning in an uncertain environme...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Khemani, Deepak</td>\n",
       "      <td>Ramakrishna, R.S.</td>\n",
       "      <td>IIT ; 1988</td>\n",
       "      <td>: Publisher: Bombay</td>\n",
       "      <td>Ramakrishna, R.S.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Software development for discrete time nonline...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Behera, Srinibas</td>\n",
       "      <td>Srisailam, M.C.</td>\n",
       "      <td>IIT ; 1989</td>\n",
       "      <td>: Bombay : I Publisher: Bombay</td>\n",
       "      <td>Srisailam, M.C.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sequential decision making in farm level water...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Maadelat, M</td>\n",
       "      <td>Murthy, J.S.R.</td>\n",
       "      <td>IIT ; 1989</td>\n",
       "      <td>: Publisher: Bombay</td>\n",
       "      <td>Murthy, J.S.R.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Analysis and design of vector quantizers (R)</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Joshi, Rajan Laxman</td>\n",
       "      <td>Poonacha, P.G.</td>\n",
       "      <td>IIT ; 1990</td>\n",
       "      <td>: Bombay : I Publisher: Bombay</td>\n",
       "      <td>Poonacha, P.G.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Development and evaluation of expert system fo...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Upadhye, S.A</td>\n",
       "      <td>Subash Babu, A.</td>\n",
       "      <td>IIT ; 1990</td>\n",
       "      <td>: Bombay : I Publisher: Bombay</td>\n",
       "      <td>Subash Babu, A.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Steady state security evaluation of power syst...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Nandapurkar, U.P</td>\n",
       "      <td>Khaparde, S.A.</td>\n",
       "      <td>IIT ; 1990</td>\n",
       "      <td>: Bombay, II Publisher: Bombay</td>\n",
       "      <td>Khaparde, S.A.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Knowledge-based expert systems for thermodynam...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Paranjape, Prakash K</td>\n",
       "      <td>Kudchadkar, A.P.</td>\n",
       "      <td>IIT ; 1989</td>\n",
       "      <td>: Bomaby : C Publisher: Bombay</td>\n",
       "      <td>Kudchadkar, A.P.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Rule based expert system for image classificat...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Borwankar, Mohan V</td>\n",
       "      <td>Sahasrabudhe, S.C. and Shevgaonkar, R.K.</td>\n",
       "      <td>IIT ; 1991</td>\n",
       "      <td>: Publisher: Bombay</td>\n",
       "      <td>Sahasrabudhe, S.C. and Shevgaonkar, R.K.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Algorithms for training artificial neural netw...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Krishna Ramesh, V.N.V</td>\n",
       "      <td>Poonacha, P.G.</td>\n",
       "      <td>IIT ; 1990</td>\n",
       "      <td>: Bombay : I Publisher: Bombay</td>\n",
       "      <td>Poonacha, P.G.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Development of an expert diagnostic system (R)</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Venketa, Narayana V</td>\n",
       "      <td>Verma, A.K.</td>\n",
       "      <td>IIT ; 1990</td>\n",
       "      <td>: Bombay : I Publisher: Bombay</td>\n",
       "      <td>Verma, A.K.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Extrun : an expert system for process planning...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Desai, Vidyadhar S</td>\n",
       "      <td>Pande, S.S. and Somasundaram, S.</td>\n",
       "      <td>IIT ; 1991</td>\n",
       "      <td>: Publisher: Bombay</td>\n",
       "      <td>Pande, S.S. and Somasundaram, S.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Knowledge based system for productivity manage...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Janakiram, Nanduri</td>\n",
       "      <td>Arunkumar, S.</td>\n",
       "      <td>IIT ; 1989</td>\n",
       "      <td>: Publisher: Bombay</td>\n",
       "      <td>Arunkumar, S.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Expert system controller for HVDC system (R)</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Patra, Pradeep Kumar</td>\n",
       "      <td>Banerjee, S.K.</td>\n",
       "      <td>IIT ; 1992</td>\n",
       "      <td>: Publisher: Bombay</td>\n",
       "      <td>Banerjee, S.K.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Functional framework : towards unification of ...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Rane, Prerana</td>\n",
       "      <td>Isaac, J.R.</td>\n",
       "      <td>IIT ; 1991</td>\n",
       "      <td>: Publisher: Bombay</td>\n",
       "      <td>Isaac, J.R.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Development of fault simulator for an on-line ...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Gurumurthy, T</td>\n",
       "      <td>Khemchandani, M.V. and Verma, A.K.</td>\n",
       "      <td>IIT ; 1991</td>\n",
       "      <td>: Publisher: Bombay</td>\n",
       "      <td>Khemchandani, M.V. and Verma, A.K.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Troubleshooting analysis of control valve asse...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Joby, George</td>\n",
       "      <td>Ramaswamy, N.</td>\n",
       "      <td>IIT ; 1993</td>\n",
       "      <td>: Publisher: Bombay</td>\n",
       "      <td>Ramaswamy, N.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Application of expert system to power system f...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Jadid, Shahram</td>\n",
       "      <td>Khaparde, S.A.</td>\n",
       "      <td>IIT ; 1992</td>\n",
       "      <td>: Publisher: Bombay</td>\n",
       "      <td>Khaparde, S.A.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Expert systems in image processing (R)</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Seshachalam, M</td>\n",
       "      <td>Sahasrabudhe, S.C.</td>\n",
       "      <td>IIT ; 1993</td>\n",
       "      <td>: Publisher: Bombay</td>\n",
       "      <td>Sahasrabudhe, S.C.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Hemorheology-supported profile-driven knowledg...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Sahasrabudhe, Gajanan</td>\n",
       "      <td>Arunkumar, S. and Puniyani, R.R.</td>\n",
       "      <td>IIT ; 1993</td>\n",
       "      <td>: Publisher: Bombay</td>\n",
       "      <td>Arunkumar, S. and Puniyani, R.R.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Expert system for on-line failure diagnosis of...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Sahoo, Janmejay</td>\n",
       "      <td>Sundarsingh, V.P.</td>\n",
       "      <td>IIT ; 1994</td>\n",
       "      <td>: Publisher: Bombay</td>\n",
       "      <td>Sundarsingh, V.P.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Data reconciliation of heat exchanger networks...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Panditrao, Sunil S</td>\n",
       "      <td>Malik, R.K. and Shenoy, U.V.</td>\n",
       "      <td>IIT ; 1994</td>\n",
       "      <td>: Publisher: Bombay</td>\n",
       "      <td>Malik, R.K. and Shenoy, U.V.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>FPGA based design of memory management unit (R)</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Rajadnya, Samir G</td>\n",
       "      <td>Sahasrabudhe, S.C. and Rao, S.S.S.P.</td>\n",
       "      <td>IIT ; 1995</td>\n",
       "      <td>: Publisher: Bombay</td>\n",
       "      <td>Sahasrabudhe, S.C. and Rao, S.S.S.P.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Neural networks in control systems (R)</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Joshi, Santosh V</td>\n",
       "      <td>Chandrasekhar, J.</td>\n",
       "      <td>IIT ; 1996</td>\n",
       "      <td>: Publisher: Bombay</td>\n",
       "      <td>Chandrasekhar, J.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Real time flood forecasting using neural netow...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Bhadke, Raju</td>\n",
       "      <td>Deo, M.C.</td>\n",
       "      <td>IIT ; 1996</td>\n",
       "      <td>: Publisher: Bombay</td>\n",
       "      <td>Deo, M.C.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Application of artificial neural networks in e...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Baskaran, S</td>\n",
       "      <td>Banerji, Pradipta.</td>\n",
       "      <td>IIT ; 1996</td>\n",
       "      <td>: Publisher: Bombay</td>\n",
       "      <td>Banerji, Pradipta.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Kohonen self-organizing maps in classification...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>artificial neural networks (R) by Dakshinamurt...</td>\n",
       "      <td>Rao, C.S. and Mohan, B.K.</td>\n",
       "      <td>IIT ; 1997</td>\n",
       "      <td>: Publisher: Mumbai</td>\n",
       "      <td>Rao, C.S. and Mohan, B.K.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Wave forecasting using neural networks (R)</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Chaphekar, Anil S</td>\n",
       "      <td>Deo, M.C.</td>\n",
       "      <td>IIT ; 1998</td>\n",
       "      <td>: Publisher: Mumbai</td>\n",
       "      <td>Deo, M.C.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Trip distribution using artificial neural netw...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Vijay Bhaskar, V</td>\n",
       "      <td>Dhingra, S.L.</td>\n",
       "      <td>IIT ; 1998</td>\n",
       "      <td>: Publisher: Mumbai</td>\n",
       "      <td>Dhingra, S.L.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Electromyographic signal decomposition and cla...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Manelkar, Ninad Raghuvir</td>\n",
       "      <td>Devasahayam, Suresh R.</td>\n",
       "      <td>IIT ; 1997</td>\n",
       "      <td>: Publisher: Mumbai</td>\n",
       "      <td>Devasahayam, Suresh R.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>514</th>\n",
       "      <td>Scalar point multiplication using zeckendorf w...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Pal, Om</td>\n",
       "      <td>Menezes, Bernard L.</td>\n",
       "      <td>IIT ; 2015</td>\n",
       "      <td>: Publisher: Mumbai</td>\n",
       "      <td>Menezes, Bernard L.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>515</th>\n",
       "      <td>Exploring relational features and learning und...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Nagesh, Ajay</td>\n",
       "      <td>Ramakrishnan, Ganesh and Bhattacharyya, Pushpak.</td>\n",
       "      <td>IIT ; 2015</td>\n",
       "      <td>: Publisher: Mumbai</td>\n",
       "      <td>Ramakrishnan, Ganesh and Bhattacharyya, Pushpak.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516</th>\n",
       "      <td>Impact of climate change on extreme waves (R)</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Satyavathi, Pentapati</td>\n",
       "      <td>Deo, M.C.</td>\n",
       "      <td>IIT ; 2015</td>\n",
       "      <td>: Publisher: Mumbai</td>\n",
       "      <td>Deo, M.C.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>517</th>\n",
       "      <td>Short term prediction of ocean currents using ...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Saha, Dauji</td>\n",
       "      <td>Deo, M.C.</td>\n",
       "      <td>IIT ; 2016</td>\n",
       "      <td>: Publisher: Mumbai</td>\n",
       "      <td>Deo, M.C.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>518</th>\n",
       "      <td>Design and enrichment of multilingual lexical ...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Bhatt, Brijesh S</td>\n",
       "      <td>Bhattacharyya, Pushpak.</td>\n",
       "      <td>IIT ; 2016</td>\n",
       "      <td>: Publisher: Mumbai</td>\n",
       "      <td>Bhattacharyya, Pushpak.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519</th>\n",
       "      <td>Generalization of the Los-Tarski preservation ...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Sankaran, Abhisekh</td>\n",
       "      <td>Chakraborty, Supratik and Adsul, Bharat.</td>\n",
       "      <td>IIT ; 2016</td>\n",
       "      <td>: Publisher: Mumbai</td>\n",
       "      <td>Chakraborty, Supratik and Adsul, Bharat.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>520</th>\n",
       "      <td>Modeling of operational and commercial process...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Chandramohan, Laakshmana Sabari</td>\n",
       "      <td>Khaparde, S.A. and Doolla, Suryanarayana.</td>\n",
       "      <td>IIT ; 2016</td>\n",
       "      <td>: Publisher: Mumbai</td>\n",
       "      <td>Khaparde, S.A. and Doolla, Suryanarayana.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>521</th>\n",
       "      <td>Wiretapped oblivious transfer (R)</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Mishra, Manoj</td>\n",
       "      <td>Dey, Bikash Kumar and Prabhakaran, Vinod M.</td>\n",
       "      <td>IIT ; 2016</td>\n",
       "      <td>: Publisher: Mumbai</td>\n",
       "      <td>Dey, Bikash Kumar and Prabhakaran, Vinod M.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>522</th>\n",
       "      <td>Data as graph : discovery, search, retrieval (R)</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Agarwal, Manoj Kumar</td>\n",
       "      <td>Ramamritham, Krithi.</td>\n",
       "      <td>IIT ; 2016</td>\n",
       "      <td>: Publisher: Mumbai</td>\n",
       "      <td>Ramamritham, Krithi.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>523</th>\n",
       "      <td>Enabling symbiotic resource management in virt...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Mishra, Debadatta</td>\n",
       "      <td>Kulkarni, Purushottam.</td>\n",
       "      <td>IIT ; 2017</td>\n",
       "      <td>: Publisher: Mumbai</td>\n",
       "      <td>Kulkarni, Purushottam.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>524</th>\n",
       "      <td>Harnessing cognitive information for natural l...</td>\n",
       "      <td>access: Click here to access online Availabil...</td>\n",
       "      <td>Mishra, Abhijit</td>\n",
       "      <td>Bhattacharyya, Pushpak.</td>\n",
       "      <td>IIT ; 2017</td>\n",
       "      <td>: Publisher: Mumbai</td>\n",
       "      <td>Bhattacharyya, Pushpak.</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>525</th>\n",
       "      <td>Investigations in computational sarcasm (R)</td>\n",
       "      <td>None</td>\n",
       "      <td>Joshi, Aditya Madhav Manda</td>\n",
       "      <td>Bhattacharyya, Pushpak [Supervisor] | Carman,...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Bhattacharyya, Pushpak [Supervisor]</td>\n",
       "      <td>Carman, Mark J [Supervisor]</td>\n",
       "      <td>Indian Institute of Technology Bombay. Depart...</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>526</th>\n",
       "      <td>Adaptive organization of digital documents usi...</td>\n",
       "      <td>None</td>\n",
       "      <td>Bairi, Ramakrishna B</td>\n",
       "      <td>Ramakrishnan, Ganesh [Supervisor] | Carman, M...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Ramakrishnan, Ganesh [Supervisor]</td>\n",
       "      <td>Carman, Mark [Supervisor]</td>\n",
       "      <td>Department of Computer Science and Engineerin...</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>527</th>\n",
       "      <td>Towards improved provisioning and utilization ...</td>\n",
       "      <td>None</td>\n",
       "      <td>Sudevalayam, Sujesha</td>\n",
       "      <td>Kulkarni, Purushottam [Supervisor] | Indian I...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Kulkarni, Purushottam [Supervisor]</td>\n",
       "      <td>Indian Institute of Technology Bombay Departm...</td>\n",
       "      <td>None</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>528</th>\n",
       "      <td>Machine learning models for predicting aggrega...</td>\n",
       "      <td>None</td>\n",
       "      <td>Bhagyalaxmi, Iyer Arun Shankar</td>\n",
       "      <td>Sarawagi, Sunita [Supervisor] | Nath, Saketha...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Sarawagi, Sunita [Supervisor]</td>\n",
       "      <td>Nath, Saketha [Supervisor]</td>\n",
       "      <td>Indian Institute of Technology Bombay. Depart...</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>529</th>\n",
       "      <td>Framework for mining massive remote sensing da...</td>\n",
       "      <td>None</td>\n",
       "      <td>Bhangale, Ujwala M</td>\n",
       "      <td>Durbha, Surya S | Indian Institute of Technol...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Durbha, Surya S</td>\n",
       "      <td>Indian Institute of Technology Bombay. Depart...</td>\n",
       "      <td>None</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>530</th>\n",
       "      <td>Bridging chasms in Hindustani music retrieval (R)</td>\n",
       "      <td>None</td>\n",
       "      <td>Ross, Joe Cheri</td>\n",
       "      <td>Rao, Preeti [Supervisor] | Bhattacharyya, Pus...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Rao, Preeti [Supervisor]</td>\n",
       "      <td>Bhattacharyya, Pushpak [Supervisor]</td>\n",
       "      <td>Indian Institute of Technology Bombay. Depart...</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>531</th>\n",
       "      <td>Structure cognizant multilingual query expansi...</td>\n",
       "      <td>None</td>\n",
       "      <td>Atreya V., Arjun</td>\n",
       "      <td>Bhattacharyya, Pushpak [Supervisor] | Ramakri...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Bhattacharyya, Pushpak [Supervisor]</td>\n",
       "      <td>Ramakrishnan, Ganesh [Supervisor]</td>\n",
       "      <td>Indian Institute of Technology Bombay. Depart...</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>532</th>\n",
       "      <td>Increasing the precision of static analysis of...</td>\n",
       "      <td>None</td>\n",
       "      <td>Kanvar, Vini</td>\n",
       "      <td>Khedker, Uday P [Supervisor] | Indian Institu...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Khedker, Uday P [Supervisor]</td>\n",
       "      <td>Indian Institute of Technology Bombay. Depart...</td>\n",
       "      <td>None</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>533</th>\n",
       "      <td>Generalized points-to graph : a new abstractio...</td>\n",
       "      <td>None</td>\n",
       "      <td>Gharat, Pritam M</td>\n",
       "      <td>Khedker, Uday [Supervisor] | Indian Institute...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Khedker, Uday [Supervisor]</td>\n",
       "      <td>Indian Institute of Technology Bombay. Depart...</td>\n",
       "      <td>None</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>534</th>\n",
       "      <td>Impact of social network site use on career su...</td>\n",
       "      <td>None</td>\n",
       "      <td>Sethi, Vidhya</td>\n",
       "      <td>Purang, Pooja [Supervisor] | Indian Institute...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Purang, Pooja [Supervisor]</td>\n",
       "      <td>Indian Institute of Technology Bombay. Depart...</td>\n",
       "      <td>None</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>535</th>\n",
       "      <td>Theory of dynamic evolution in petri net model...</td>\n",
       "      <td>None</td>\n",
       "      <td>Pradhan, Ahana</td>\n",
       "      <td>Joshi, Rushikesh K [Supervisor] | Indian Inst...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Joshi, Rushikesh K [Supervisor]</td>\n",
       "      <td>Indian Institute of Technology Bombay. Depart...</td>\n",
       "      <td>None</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>536</th>\n",
       "      <td>Impact of PDS supply chain computerization on ...</td>\n",
       "      <td>None</td>\n",
       "      <td>Kalliyil, Muneer</td>\n",
       "      <td>Shaw, Tara Shankar [Supervisor] | Indian Inst...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Shaw, Tara Shankar [Supervisor]</td>\n",
       "      <td>Indian Institute of Technology Bombay. Depart...</td>\n",
       "      <td>None</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>537</th>\n",
       "      <td>Sex work and erotic capital : narratives of wo...</td>\n",
       "      <td>None</td>\n",
       "      <td>Kadambari</td>\n",
       "      <td>Waghmore, Suryakant | Indian Institute of Tec...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Waghmore, Suryakant</td>\n",
       "      <td>Indian Institute of Technology Bombay. Depart...</td>\n",
       "      <td>None</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>538</th>\n",
       "      <td>Machine translation and trasliteration involvi...</td>\n",
       "      <td>None</td>\n",
       "      <td>Kunchukuttaj, Anoop</td>\n",
       "      <td>Bhattacharyya, Pushpak [Supervisor] | Indian ...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Bhattacharyya, Pushpak [Supervisor]</td>\n",
       "      <td>Indian Institute of Technology Bombay Departm...</td>\n",
       "      <td>None</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>539</th>\n",
       "      <td>Shoreline change and coastal vulnerability con...</td>\n",
       "      <td>None</td>\n",
       "      <td>Rajasree, B.R</td>\n",
       "      <td>Deo, M.C [Supervisor] | Indian Institute of T...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Deo, M.C [Supervisor]</td>\n",
       "      <td>Indian Institute of Technology Bombay. Depart...</td>\n",
       "      <td>None</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>540</th>\n",
       "      <td>Climate change impact on ocean waves and coast...</td>\n",
       "      <td>None</td>\n",
       "      <td>Chowdhury, Piyali</td>\n",
       "      <td>Behera, Manasa Ranjan [Supervisor] | Indian I...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Behera, Manasa Ranjan [Supervisor]</td>\n",
       "      <td>Indian Institute of Technology Bombay. Interd...</td>\n",
       "      <td>None</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541</th>\n",
       "      <td>Improved predictions of sea surface temperatur...</td>\n",
       "      <td>None</td>\n",
       "      <td>Patil, Kalpesh Ravindra</td>\n",
       "      <td>Deo, M.C [Supervisor] | Indian Institute of T...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Deo, M.C [Supervisor]</td>\n",
       "      <td>Indian Institute of Technology Bombay. Depart...</td>\n",
       "      <td>None</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>542</th>\n",
       "      <td>Impact of climate change on interrupted shorel...</td>\n",
       "      <td>None</td>\n",
       "      <td>Gopikrishna, Bollapragada</td>\n",
       "      <td>Deo, M.C [Supervisor] | Indian Institute of T...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Deo, M.C [Supervisor]</td>\n",
       "      <td>Indian Institute of Technology Bombay. Depart...</td>\n",
       "      <td>None</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>543</th>\n",
       "      <td>Leaky integrate and fire neuron on SOI CMOS te...</td>\n",
       "      <td>None</td>\n",
       "      <td>Dutta, Sangya</td>\n",
       "      <td>Ganguly, Udayan [Supervisor] | Lodha, Saurabh...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Ganguly, Udayan [Supervisor]</td>\n",
       "      <td>Lodha, Saurabh [Supervisor]</td>\n",
       "      <td>Indian Institute of Technology Bombay. Depart...</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>544 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 title  \\\n",
       "0    Expert system for network topology determinati...   \n",
       "1    Theme based planning in an uncertain environme...   \n",
       "2    Software development for discrete time nonline...   \n",
       "3    Sequential decision making in farm level water...   \n",
       "4         Analysis and design of vector quantizers (R)   \n",
       "..                                                 ...   \n",
       "539  Shoreline change and coastal vulnerability con...   \n",
       "540  Climate change impact on ocean waves and coast...   \n",
       "541  Improved predictions of sea surface temperatur...   \n",
       "542  Impact of climate change on interrupted shorel...   \n",
       "543  Leaky integrate and fire neuron on SOI CMOS te...   \n",
       "\n",
       "                                                 other  \\\n",
       "0     access: Click here to access online Availabil...   \n",
       "1     access: Click here to access online Availabil...   \n",
       "2     access: Click here to access online Availabil...   \n",
       "3     access: Click here to access online Availabil...   \n",
       "4     access: Click here to access online Availabil...   \n",
       "..                                                 ...   \n",
       "539                                               None   \n",
       "540                                               None   \n",
       "541                                               None   \n",
       "542                                               None   \n",
       "543                                               None   \n",
       "\n",
       "                         author  \\\n",
       "0         Vidya Sagar, V.S.K.E    \n",
       "1              Khemani, Deepak    \n",
       "2             Behera, Srinibas    \n",
       "3                  Maadelat, M    \n",
       "4          Joshi, Rajan Laxman    \n",
       "..                          ...   \n",
       "539              Rajasree, B.R    \n",
       "540          Chowdhury, Piyali    \n",
       "541    Patil, Kalpesh Ravindra    \n",
       "542  Gopikrishna, Bollapragada    \n",
       "543              Dutta, Sangya    \n",
       "\n",
       "                                            supervisor         year  \\\n",
       "0                        Khaparde, S.A. and Biswas, S.   IIT ; 1988   \n",
       "1                                    Ramakrishna, R.S.   IIT ; 1988   \n",
       "2                                      Srisailam, M.C.   IIT ; 1989   \n",
       "3                                       Murthy, J.S.R.   IIT ; 1989   \n",
       "4                                       Poonacha, P.G.   IIT ; 1990   \n",
       "..                                                 ...          ...   \n",
       "539   Deo, M.C [Supervisor] | Indian Institute of T...         None   \n",
       "540   Behera, Manasa Ranjan [Supervisor] | Indian I...         None   \n",
       "541   Deo, M.C [Supervisor] | Indian Institute of T...         None   \n",
       "542   Deo, M.C [Supervisor] | Indian Institute of T...         None   \n",
       "543   Ganguly, Udayan [Supervisor] | Lodha, Saurabh...         None   \n",
       "\n",
       "                           publisher                                  sup1  \\\n",
       "0               : Publisher: Bombay          Khaparde, S.A. and Biswas, S.   \n",
       "1               : Publisher: Bombay                      Ramakrishna, R.S.   \n",
       "2    : Bombay : I Publisher: Bombay                        Srisailam, M.C.   \n",
       "3               : Publisher: Bombay                         Murthy, J.S.R.   \n",
       "4    : Bombay : I Publisher: Bombay                         Poonacha, P.G.   \n",
       "..                               ...                                   ...   \n",
       "539                             None                Deo, M.C [Supervisor]    \n",
       "540                             None   Behera, Manasa Ranjan [Supervisor]    \n",
       "541                             None                Deo, M.C [Supervisor]    \n",
       "542                             None                Deo, M.C [Supervisor]    \n",
       "543                             None         Ganguly, Udayan [Supervisor]    \n",
       "\n",
       "                                                  sup2  \\\n",
       "0                                                 None   \n",
       "1                                                 None   \n",
       "2                                                 None   \n",
       "3                                                 None   \n",
       "4                                                 None   \n",
       "..                                                 ...   \n",
       "539   Indian Institute of Technology Bombay. Depart...   \n",
       "540   Indian Institute of Technology Bombay. Interd...   \n",
       "541   Indian Institute of Technology Bombay. Depart...   \n",
       "542   Indian Institute of Technology Bombay. Depart...   \n",
       "543                       Lodha, Saurabh [Supervisor]    \n",
       "\n",
       "                                                other1  date  \n",
       "0                                                 None   NaN  \n",
       "1                                                 None   NaN  \n",
       "2                                                 None   NaN  \n",
       "3                                                 None   NaN  \n",
       "4                                                 None   NaN  \n",
       "..                                                 ...   ...  \n",
       "539                                               None  2018  \n",
       "540                                               None  2019  \n",
       "541                                               None  2018  \n",
       "542                                               None  2019  \n",
       "543   Indian Institute of Technology Bombay. Depart...  2018  \n",
       "\n",
       "[544 rows x 10 columns]"
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "iit_mum1=iit_mum1.drop(columns=[])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "iit_mum=pd.read_html('https://opac.library.iitb.ac.in/cgi-bin/koha/opac-search.pl?idx=kw&q=computer%20science&limit=mc-itype%3ATD&offset=0&sort_by=relevance_dsc')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "iit_mum1=pd.read_html('https://opac.library.iitb.ac.in/cgi-bin/koha/opac-search.pl?idx=kw&q=computer%20science&limit=mc-itype%3ATD&offset=10&sort_by=relevance_dsc')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Int64Index([0, 1, 2], dtype='int64')"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "iit_mum1[0].columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 228,
   "metadata": {},
   "outputs": [],
   "source": [
    "iitmm=iitmm[1].str.split('|',expand=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 224,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Knowledge-based expert systems for thermodynamic choices in chemical plant simulation (R) by Paranjape, Prakash K | Kudchadkar, A.P.Edition: Bomaby : C Publisher: Bombay ; IIT ; 1989Online access: Click here to access online Availability: Items available for reference: [Call number: 043:66.01:681.342Par] (1). Add to cart'"
      ]
     },
     "execution_count": 224,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "iitm.values[7]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 230,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "' Khaparde, S.A. and Biswas, S.Edition: Publisher: Bombay ; IIT ; 1988Online access: Click here to access online Availability: Items available for reference: [Call number: 043:621.316.2:681.342Vid] (1). Add to cart'"
      ]
     },
     "execution_count": 230,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "iitmm.values[0,1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 252,
   "metadata": {},
   "outputs": [],
   "source": [
    "iitmm[['a','b']]=iitmm[1].str.split('Edition',expand=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 258,
   "metadata": {},
   "outputs": [],
   "source": [
    "iitmm[['c','d','e']]=iitmm['b'].str.split(';',2,expand=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 263,
   "metadata": {},
   "outputs": [],
   "source": [
    "iitmm[['y','ex']]=iitmm['e'].str.split('Online',1,expand=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 267,
   "metadata": {},
   "outputs": [],
   "source": [
    "s1 = pd.Series(['a', 'b'])\n",
    "s2 = pd.Series(['c', 'd'])\n",
    "s1=pd.concat([s1, s2])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 268,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    a\n",
       "1    b\n",
       "0    c\n",
       "1    d\n",
       "dtype: object"
      ]
     },
     "execution_count": 268,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The original string : There are 22355 apples for 4 persons\n"
     ]
    }
   ],
   "source": [
    "import re \n",
    "  \n",
    "# initializing string  \n",
    "test_string = \"There are 22355 apples for 4 persons\"\n",
    "  \n",
    "# printing original string  \n",
    "print(\"The original string : \" + test_string) \n",
    "  \n",
    "# using re.findall() \n",
    "# getting numbers from string  \n",
    "temp =re.findall(r'\\d+', test_string \n",
    "res = list(map(int, temp)) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['22355', '4']"
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "temp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "b'Hans-J\\xf6rg Schek'\n"
     ]
    }
   ],
   "source": [
    "print('Hans-Jörg Schek'.encode('ISO-8859-1'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "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.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}