CleanAuthorsData.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "authors_df = pd.read_csv('authors2018')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(893, 5)"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "authors_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>Surname</th>\n",
       "      <th>Name</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>Student</th>\n",
       "      <th>Male</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Hardy</td>\n",
       "      <td>L.~K.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Bouwhuis</td>\n",
       "      <td>M.~C.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Littlefair</td>\n",
       "      <td>S.~P.</td>\n",
       "      <td>UK</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kreter</td>\n",
       "      <td>M.</td>\n",
       "      <td>DE</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Buckley</td>\n",
       "      <td>D.~A.~H.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Ridolfi</td>\n",
       "      <td>A.</td>\n",
       "      <td>DE</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Sokolowski</td>\n",
       "      <td>M.</td>\n",
       "      <td>PL</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Trovato</td>\n",
       "      <td>A.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Forbes</td>\n",
       "      <td>D.~A.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Rumsey</td>\n",
       "      <td>C.</td>\n",
       "      <td>UK</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Acernese</td>\n",
       "      <td>F.</td>\n",
       "      <td>IT</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Cohn</td>\n",
       "      <td>Jonathan H.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Sadler</td>\n",
       "      <td>E.~M.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Perley</td>\n",
       "      <td>D. A.</td>\n",
       "      <td>US</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Wiseman</td>\n",
       "      <td>P.</td>\n",
       "      <td>UK</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Gruen</td>\n",
       "      <td>D.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Eberl</td>\n",
       "      <td>T.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Hofestadt</td>\n",
       "      <td>J.</td>\n",
       "      <td>DE</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Domi</td>\n",
       "      <td>A.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Kiessling</td>\n",
       "      <td>D.</td>\n",
       "      <td>I</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Surname         Name Nationality Student   Male\n",
       "0        Hardy        L.~K.         NaN     NaN    NaN\n",
       "1     Bouwhuis        M.~C.           A   False   True\n",
       "2   Littlefair        S.~P.          UK   False   True\n",
       "3       Kreter           M.          DE   False   True\n",
       "4      Buckley     D.~A.~H.           A   False   True\n",
       "5      Ridolfi           A.          DE   False   True\n",
       "6   Sokolowski           M.          PL   False   True\n",
       "7      Trovato           A.           I   False   True\n",
       "8       Forbes        D.~A.           A   False   True\n",
       "9       Rumsey           C.          UK   False  False\n",
       "10    Acernese           F.          IT   False   True\n",
       "11        Cohn  Jonathan H.           I   False   True\n",
       "12      Sadler        E.~M.           A   False  False\n",
       "13      Perley        D. A.          US   False   True\n",
       "14     Wiseman           P.          UK   False   True\n",
       "15       Gruen           D.           I   False   True\n",
       "16       Eberl           T.           I   False   True\n",
       "17   Hofestadt           J.          DE   False   True\n",
       "18        Domi           A.         NaN     NaN    NaN\n",
       "19   Kiessling           D.           I     NaN    NaN"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "authors_df.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method NDFrame.describe of              Surname         Name Nationality Student   Male\n",
       "0              Hardy        L.~K.         NaN     NaN    NaN\n",
       "1           Bouwhuis        M.~C.           A   False   True\n",
       "2         Littlefair        S.~P.          UK   False   True\n",
       "3             Kreter           M.          DE   False   True\n",
       "4            Buckley     D.~A.~H.           A   False   True\n",
       "5            Ridolfi           A.          DE   False   True\n",
       "6         Sokolowski           M.          PL   False   True\n",
       "7            Trovato           A.           I   False   True\n",
       "8             Forbes        D.~A.           A   False   True\n",
       "9             Rumsey           C.          UK   False  False\n",
       "10          Acernese           F.          IT   False   True\n",
       "11              Cohn  Jonathan H.           I   False   True\n",
       "12            Sadler        E.~M.           A   False  False\n",
       "13            Perley        D. A.          US   False   True\n",
       "14           Wiseman           P.          UK   False   True\n",
       "15             Gruen           D.           I   False   True\n",
       "16             Eberl           T.           I   False   True\n",
       "17         Hofestadt           J.          DE   False   True\n",
       "18              Domi           A.         NaN     NaN    NaN\n",
       "19         Kiessling           D.           I     NaN    NaN\n",
       "20      Blagorodnova          N.           US   False  False\n",
       "21        Enzenhofer           A.           I     NaN    NaN\n",
       "22       Kreykenbohm           I.          UK   False   True\n",
       "23           Bolejko           K.           A   False   True\n",
       "24            Lupton        R.~H.          US   False   True\n",
       "25            Wilson        R.~W.          US   False   True\n",
       "26             Crisp           H.           I   False   True\n",
       "27          Bromberg           O.          IL   False   True\n",
       "28            Dodson           R.           A   False    NaN\n",
       "29              Dent     W.~R.~F.          UK   False    NaN\n",
       "..               ...          ...         ...     ...    ...\n",
       "863            Bassa           C.           I    True    NaN\n",
       "864            Madau           P.           I   False    NaN\n",
       "865          Farrell        T.~J.         NaN     NaN    NaN\n",
       "866        Brandeker           A.         NaN     NaN    NaN\n",
       "867            Jiang        J.-a.         NaN     NaN    NaN\n",
       "868         da Cunha          E.          NaN     NaN    NaN\n",
       "869          Gronnow           A.         NaN     NaN    NaN\n",
       "870       Pastorello           N.           A    True    NaN\n",
       "871       Coniglione           R.         NaN     NaN    NaN\n",
       "872        Salvadori           I.         NaN     NaN    NaN\n",
       "873            Oesch       P.~A.          NaN     NaN    NaN\n",
       "874          Kotuv s       S.~M.          NaN     NaN    NaN\n",
       "875           Juhasz           A.         NaN     NaN    NaN\n",
       "876            Croom        S.~M.           A   False    NaN\n",
       "877  Seyedmahmoudian           M.         NaN     NaN    NaN\n",
       "878           Booler           T.         NaN     NaN    NaN\n",
       "879        Broussard           A.           I   False    NaN\n",
       "880            Bower          R.          NaN     NaN    NaN\n",
       "881            Lynch           C.         NaN     NaN    NaN\n",
       "882        Samtleben     D.~F.~E.         NaN     NaN    NaN\n",
       "883             Lima           M.         NaN   False    NaN\n",
       "884    Carrasco Kind           M.           I   False    NaN\n",
       "885        Cantiello           M.         NaN     NaN    NaN\n",
       "886          Franzen           T.         NaN     NaN    NaN\n",
       "887          Coccato           L.           I   False    NaN\n",
       "888          Bessell        M.~S.         NaN     NaN    NaN\n",
       "889          Gilbank           D.         NaN     NaN    NaN\n",
       "890        Carretero           J.           I   False    NaN\n",
       "891      Nanayakkara           T.           A    True    NaN\n",
       "892             Doel           P.         NaN   False    NaN\n",
       "\n",
       "[893 rows x 5 columns]>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "authors_df.describe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>Surname</th>\n",
       "      <th>Name</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>Student</th>\n",
       "      <th>Male</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Hardy</td>\n",
       "      <td>L.~K.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Domi</td>\n",
       "      <td>A.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Scarpine</td>\n",
       "      <td>V.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Khayati</td>\n",
       "      <td>N.~E.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Ali</td>\n",
       "      <td>K.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>Orange</td>\n",
       "      <td>N.~B.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>Bojaddaini</td>\n",
       "      <td>I.~E.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Federico Frascoli</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>Kochanek</td>\n",
       "      <td>C.~S.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>Zhou</td>\n",
       "      <td>J.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>Hallmann</td>\n",
       "      <td>S.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>Vaisanen</td>\n",
       "      <td>P.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>White</td>\n",
       "      <td>H.~A.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>Pv avv alac s</td>\n",
       "      <td>G.~E.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>Donzaud</td>\n",
       "      <td>C.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>Emrich</td>\n",
       "      <td>D.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>Kate H. R. Rubin</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>Duv ska</td>\n",
       "      <td>M.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>Hales</td>\n",
       "      <td>A.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>Shao</td>\n",
       "      <td>L.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>Acharyya</td>\n",
       "      <td>A.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>Aubert</td>\n",
       "      <td>J.-J.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>Tayalati</td>\n",
       "      <td>Y.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>Riemer-Sorensen</td>\n",
       "      <td>S.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>Laporte</td>\n",
       "      <td>N.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>Adya</td>\n",
       "      <td>V.~B.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>Maccarone</td>\n",
       "      <td>T.~J.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>Pradier</td>\n",
       "      <td>T.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>Leontini</td>\n",
       "      <td>Justin S.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>Moussa</td>\n",
       "      <td>A.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>849</th>\n",
       "      <td>Salcido</td>\n",
       "      <td>J.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>850</th>\n",
       "      <td>Klotz</td>\n",
       "      <td>A.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>851</th>\n",
       "      <td>Prasad</td>\n",
       "      <td>Krishnamurthy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>853</th>\n",
       "      <td>Gordon</td>\n",
       "      <td>Y.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>856</th>\n",
       "      <td>Cortese</td>\n",
       "      <td>L.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>857</th>\n",
       "      <td>Bellstedt</td>\n",
       "      <td>S.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>859</th>\n",
       "      <td>H. L. Vu</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>861</th>\n",
       "      <td>Guerou</td>\n",
       "      <td>A.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>862</th>\n",
       "      <td>Pellegrino</td>\n",
       "      <td>C.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>865</th>\n",
       "      <td>Farrell</td>\n",
       "      <td>T.~J.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>866</th>\n",
       "      <td>Brandeker</td>\n",
       "      <td>A.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>867</th>\n",
       "      <td>Jiang</td>\n",
       "      <td>J.-a.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>868</th>\n",
       "      <td>da Cunha</td>\n",
       "      <td>E.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>869</th>\n",
       "      <td>Gronnow</td>\n",
       "      <td>A.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>871</th>\n",
       "      <td>Coniglione</td>\n",
       "      <td>R.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>872</th>\n",
       "      <td>Salvadori</td>\n",
       "      <td>I.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>873</th>\n",
       "      <td>Oesch</td>\n",
       "      <td>P.~A.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>874</th>\n",
       "      <td>Kotuv s</td>\n",
       "      <td>S.~M.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>875</th>\n",
       "      <td>Juhasz</td>\n",
       "      <td>A.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>877</th>\n",
       "      <td>Seyedmahmoudian</td>\n",
       "      <td>M.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>878</th>\n",
       "      <td>Booler</td>\n",
       "      <td>T.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>880</th>\n",
       "      <td>Bower</td>\n",
       "      <td>R.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>881</th>\n",
       "      <td>Lynch</td>\n",
       "      <td>C.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>882</th>\n",
       "      <td>Samtleben</td>\n",
       "      <td>D.~F.~E.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>883</th>\n",
       "      <td>Lima</td>\n",
       "      <td>M.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>885</th>\n",
       "      <td>Cantiello</td>\n",
       "      <td>M.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>886</th>\n",
       "      <td>Franzen</td>\n",
       "      <td>T.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>888</th>\n",
       "      <td>Bessell</td>\n",
       "      <td>M.~S.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>889</th>\n",
       "      <td>Gilbank</td>\n",
       "      <td>D.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>892</th>\n",
       "      <td>Doel</td>\n",
       "      <td>P.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>519 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               Surname           Name Nationality Student Male\n",
       "0                Hardy          L.~K.         NaN     NaN  NaN\n",
       "18                Domi             A.         NaN     NaN  NaN\n",
       "38            Scarpine             V.         NaN   False  NaN\n",
       "72             Khayati          N.~E.         NaN     NaN  NaN\n",
       "79                 Ali            K.          NaN     NaN  NaN\n",
       "89              Orange          N.~B.         NaN     NaN  NaN\n",
       "90          Bojaddaini          I.~E.         NaN     NaN  NaN\n",
       "95   Federico Frascoli                        NaN     NaN  NaN\n",
       "100           Kochanek          C.~S.         NaN     NaN  NaN\n",
       "110               Zhou             J.         NaN     NaN  NaN\n",
       "111           Hallmann             S.         NaN     NaN  NaN\n",
       "112           Vaisanen             P.         NaN     NaN  NaN\n",
       "115              White         H.~A.          NaN     NaN  NaN\n",
       "116      Pv avv alac s          G.~E.         NaN     NaN  NaN\n",
       "117            Donzaud             C.         NaN     NaN  NaN\n",
       "125             Emrich             D.         NaN     NaN  NaN\n",
       "132   Kate H. R. Rubin                        NaN   False  NaN\n",
       "133            Duv ska             M.         NaN     NaN  NaN\n",
       "134              Hales             A.         NaN     NaN  NaN\n",
       "135               Shao             L.         NaN     NaN  NaN\n",
       "138           Acharyya             A.         NaN     NaN  NaN\n",
       "148             Aubert          J.-J.         NaN     NaN  NaN\n",
       "151           Tayalati             Y.         NaN     NaN  NaN\n",
       "152    Riemer-Sorensen            S.          NaN     NaN  NaN\n",
       "155            Laporte             N.         NaN     NaN  NaN\n",
       "156               Adya          V.~B.         NaN     NaN  NaN\n",
       "157          Maccarone          T.~J.         NaN     NaN  NaN\n",
       "159            Pradier             T.         NaN     NaN  NaN\n",
       "161           Leontini      Justin S.         NaN     NaN  NaN\n",
       "162             Moussa             A.         NaN     NaN  NaN\n",
       "..                 ...            ...         ...     ...  ...\n",
       "849            Salcido             J.         NaN     NaN  NaN\n",
       "850              Klotz             A.         NaN     NaN  NaN\n",
       "851             Prasad  Krishnamurthy         NaN     NaN  NaN\n",
       "853             Gordon             Y.         NaN     NaN  NaN\n",
       "856            Cortese            L.          NaN     NaN  NaN\n",
       "857          Bellstedt            S.          NaN     NaN  NaN\n",
       "859           H. L. Vu                        NaN     NaN  NaN\n",
       "861             Guerou             A.         NaN     NaN  NaN\n",
       "862         Pellegrino             C.         NaN     NaN  NaN\n",
       "865            Farrell          T.~J.         NaN     NaN  NaN\n",
       "866          Brandeker             A.         NaN     NaN  NaN\n",
       "867              Jiang          J.-a.         NaN     NaN  NaN\n",
       "868           da Cunha            E.          NaN     NaN  NaN\n",
       "869            Gronnow             A.         NaN     NaN  NaN\n",
       "871         Coniglione             R.         NaN     NaN  NaN\n",
       "872          Salvadori             I.         NaN     NaN  NaN\n",
       "873              Oesch         P.~A.          NaN     NaN  NaN\n",
       "874            Kotuv s         S.~M.          NaN     NaN  NaN\n",
       "875             Juhasz             A.         NaN     NaN  NaN\n",
       "877    Seyedmahmoudian             M.         NaN     NaN  NaN\n",
       "878             Booler             T.         NaN     NaN  NaN\n",
       "880              Bower            R.          NaN     NaN  NaN\n",
       "881              Lynch             C.         NaN     NaN  NaN\n",
       "882          Samtleben       D.~F.~E.         NaN     NaN  NaN\n",
       "883               Lima             M.         NaN   False  NaN\n",
       "885          Cantiello             M.         NaN     NaN  NaN\n",
       "886            Franzen             T.         NaN     NaN  NaN\n",
       "888            Bessell          M.~S.         NaN     NaN  NaN\n",
       "889            Gilbank             D.         NaN     NaN  NaN\n",
       "892               Doel             P.         NaN   False  NaN\n",
       "\n",
       "[519 rows x 5 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "authors_df[pd.isna(authors_df.Nationality)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>Surname</th>\n",
       "      <th>Name</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>Student</th>\n",
       "      <th>Male</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Qiu</td>\n",
       "      <td>Siyao</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Barat</td>\n",
       "      <td>D.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Pointon</td>\n",
       "      <td>S.~K.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Caleb</td>\n",
       "      <td>M.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>205</th>\n",
       "      <td>Pota</td>\n",
       "      <td>V.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>275</th>\n",
       "      <td>Jankowski</td>\n",
       "      <td>F.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284</th>\n",
       "      <td>Petroff</td>\n",
       "      <td>E.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>327</th>\n",
       "      <td>Hutchison</td>\n",
       "      <td>M.~A.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <td>Curtin</td>\n",
       "      <td>C.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>394</th>\n",
       "      <td>Bekiaris</td>\n",
       "      <td>G.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>446</th>\n",
       "      <td>Denes</td>\n",
       "      <td>H.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>Allen</td>\n",
       "      <td>R.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>461</th>\n",
       "      <td>Andreoni</td>\n",
       "      <td>I.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>Jones</td>\n",
       "      <td>H.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>469</th>\n",
       "      <td>Ravi</td>\n",
       "      <td>V.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>486</th>\n",
       "      <td>Zhu</td>\n",
       "      <td>X.-J.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>522</th>\n",
       "      <td>Bhandari</td>\n",
       "      <td>S.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>543</th>\n",
       "      <td>Krishnan</td>\n",
       "      <td>V.~V.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>607</th>\n",
       "      <td>Wong</td>\n",
       "      <td>O.~I.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>608</th>\n",
       "      <td>Wong</td>\n",
       "      <td>O.~I.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>615</th>\n",
       "      <td>Jacobs</td>\n",
       "      <td>D.~C.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>641</th>\n",
       "      <td>Johnson</td>\n",
       "      <td>A.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>647</th>\n",
       "      <td>Bainbridge</td>\n",
       "      <td>M.~B.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>669</th>\n",
       "      <td>Dai</td>\n",
       "      <td>S.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>676</th>\n",
       "      <td>Usher</td>\n",
       "      <td>C.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>748</th>\n",
       "      <td>Shannon</td>\n",
       "      <td>R.~M.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>860</th>\n",
       "      <td>Kartha</td>\n",
       "      <td>S.~S.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>870</th>\n",
       "      <td>Pastorello</td>\n",
       "      <td>N.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>891</th>\n",
       "      <td>Nanayakkara</td>\n",
       "      <td>T.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Surname   Name Nationality Student   Male\n",
       "30           Qiu  Siyao           A    True  False\n",
       "43         Barat    D.            A    True   True\n",
       "56       Pointon  S.~K.           A    True  False\n",
       "77         Caleb     M.           A    True    NaN\n",
       "205         Pota     V.           A    True    NaN\n",
       "275    Jankowski     F.           A    True    NaN\n",
       "284      Petroff     E.           A    True    NaN\n",
       "327    Hutchison  M.~A.           A    True    NaN\n",
       "358       Curtin     C.           A    True    NaN\n",
       "394     Bekiaris     G.           A    True    NaN\n",
       "446        Denes     H.           A    True    NaN\n",
       "450        Allen     R.           A    True    NaN\n",
       "461     Andreoni     I.           A    True    NaN\n",
       "468        Jones     H.           A    True    NaN\n",
       "469         Ravi     V.           A    True    NaN\n",
       "486          Zhu  X.-J.           A    True    NaN\n",
       "522     Bhandari     S.           A    True    NaN\n",
       "543     Krishnan  V.~V.           A    True    NaN\n",
       "607         Wong  O.~I.           A    True    NaN\n",
       "608         Wong  O.~I.           A    True    NaN\n",
       "615       Jacobs  D.~C.           A    True    NaN\n",
       "641      Johnson     A.           A    True    NaN\n",
       "647   Bainbridge  M.~B.           A    True    NaN\n",
       "669          Dai     S.           A    True    NaN\n",
       "676        Usher     C.           A    True    NaN\n",
       "748      Shannon  R.~M.           A    True    NaN\n",
       "860       Kartha  S.~S.           A    True    NaN\n",
       "870   Pastorello     N.           A    True    NaN\n",
       "891  Nanayakkara     T.           A    True    NaN"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "authors_df[(authors_df.Nationality == 'A') & (authors_df.Student == True)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Pota\n",
    "authors_df.iloc[205].Student = False"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Surname         Pota\n",
       "Name              V.\n",
       "Nationality        A\n",
       "Student        False\n",
       "Male             NaN\n",
       "Name: 205, dtype: object"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "authors_df.iloc[205]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Petroff\n",
    "authors_df.iloc[284].Student = False\n",
    "authors_df.iloc[284].Male = False"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Huchison\n",
    "authors_df.iloc[327].Student = False\n",
    "authors_df.iloc[327].Male = True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Duplicate 'Wong'\n",
    "#authors_df.drop(index=608,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "#George Bekiaris\n",
    "authors_df.iloc[394].Student = False\n",
    "authors_df.iloc[394].Male = True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Helga Denes\n",
    "authors_df.iloc[446].Student = False\n",
    "authors_df.iloc[446].Male = False"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Rebecca Allen\n",
    "authors_df.iloc[450].Student = False\n",
    "authors_df.iloc[450].Male = False"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Andreoni\n",
    "authors_df.iloc[461].Male = True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "# David Heath Jones\n",
    "authors_df.iloc[468].Student = False\n",
    "authors_df.iloc[468].Male = True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Vikram Ravi\n",
    "authors_df.iloc[469].Student = False\n",
    "authors_df.iloc[469].Male = True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Krishnan\n",
    "authors_df.iloc[543].Male = True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Oiwei (Ivy) Wong\n",
    "authors_df.iloc[607].Student = False\n",
    "authors_df.iloc[607].Male = False"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Daniel C. Jacobs\n",
    "authors_df.iloc[615].Student = False\n",
    "authors_df.iloc[615].Male = True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Daniel C. Jacobs\n",
    "authors_df.iloc[615].Student = False\n",
    "authors_df.iloc[615].Male = True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Andrew Austin Johnson\n",
    "authors_df.iloc[641].Student = False\n",
    "authors_df.iloc[641].Male = True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Matthew B. Bainbridge\n",
    "authors_df.iloc[647].Student = False\n",
    "authors_df.iloc[647].Male = True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Shou-Huang Dai\n",
    "authors_df.iloc[669].Student = False\n",
    "authors_df.iloc[669].Male = True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Christopher Usher\n",
    "authors_df.iloc[676].Student = False\n",
    "authors_df.iloc[676].Male = True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Ryan M. Shannon\n",
    "authors_df.iloc[748].Student = False\n",
    "authors_df.iloc[748].Male = True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Sreeja S. Kartha\n",
    "authors_df.iloc[860].Student = False\n",
    "authors_df.iloc[860].Male = False"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Nicola Pastorello\n",
    "authors_df.iloc[870].Student = False\n",
    "authors_df.iloc[870].Male = True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Nanayakkara, Themiya\n",
    "authors_df.iloc[891].Student = False\n",
    "authors_df.iloc[891].Male = True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "authors_df.to_csv('authors_2018_1',columns=['Surname','Name','Nationality','Student','Male'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Surname</th>\n",
       "      <th>Name</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>Student</th>\n",
       "      <th>Male</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Bouwhuis</td>\n",
       "      <td>M.~C.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Littlefair</td>\n",
       "      <td>S.~P.</td>\n",
       "      <td>UK</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kreter</td>\n",
       "      <td>M.</td>\n",
       "      <td>DE</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Buckley</td>\n",
       "      <td>D.~A.~H.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Ridolfi</td>\n",
       "      <td>A.</td>\n",
       "      <td>DE</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Sokolowski</td>\n",
       "      <td>M.</td>\n",
       "      <td>PL</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Trovato</td>\n",
       "      <td>A.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Forbes</td>\n",
       "      <td>D.~A.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Rumsey</td>\n",
       "      <td>C.</td>\n",
       "      <td>UK</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Acernese</td>\n",
       "      <td>F.</td>\n",
       "      <td>IT</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Cohn</td>\n",
       "      <td>Jonathan H.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Sadler</td>\n",
       "      <td>E.~M.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Perley</td>\n",
       "      <td>D. A.</td>\n",
       "      <td>US</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Wiseman</td>\n",
       "      <td>P.</td>\n",
       "      <td>UK</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Gruen</td>\n",
       "      <td>D.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Eberl</td>\n",
       "      <td>T.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Hofestadt</td>\n",
       "      <td>J.</td>\n",
       "      <td>DE</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Kiessling</td>\n",
       "      <td>D.</td>\n",
       "      <td>I</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Blagorodnova</td>\n",
       "      <td>N.</td>\n",
       "      <td>US</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Enzenhofer</td>\n",
       "      <td>A.</td>\n",
       "      <td>I</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Kreykenbohm</td>\n",
       "      <td>I.</td>\n",
       "      <td>UK</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Bolejko</td>\n",
       "      <td>K.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Lupton</td>\n",
       "      <td>R.~H.</td>\n",
       "      <td>US</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Wilson</td>\n",
       "      <td>R.~W.</td>\n",
       "      <td>US</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Crisp</td>\n",
       "      <td>H.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Bromberg</td>\n",
       "      <td>O.</td>\n",
       "      <td>IL</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Dodson</td>\n",
       "      <td>R.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Dent</td>\n",
       "      <td>W.~R.~F.</td>\n",
       "      <td>UK</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Qiu</td>\n",
       "      <td>Siyao</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Freire</td>\n",
       "      <td>P.~C.~C.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>802</th>\n",
       "      <td>Yuan</td>\n",
       "      <td>F.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>804</th>\n",
       "      <td>Romanowsky</td>\n",
       "      <td>A.~J.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>805</th>\n",
       "      <td>Kocevski</td>\n",
       "      <td>D.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>808</th>\n",
       "      <td>Prochaska</td>\n",
       "      <td>J.~X.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>809</th>\n",
       "      <td>Johnston</td>\n",
       "      <td>S.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>810</th>\n",
       "      <td>Mould</td>\n",
       "      <td>J.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>812</th>\n",
       "      <td>Yasuda</td>\n",
       "      <td>N.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>816</th>\n",
       "      <td>Ryan-Weber</td>\n",
       "      <td>E.~V.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>820</th>\n",
       "      <td>Mickaliger</td>\n",
       "      <td>M.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>827</th>\n",
       "      <td>Amon</td>\n",
       "      <td>A.</td>\n",
       "      <td>I</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>833</th>\n",
       "      <td>Hopkins</td>\n",
       "      <td>A.~M.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>834</th>\n",
       "      <td>Davis</td>\n",
       "      <td>C.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>835</th>\n",
       "      <td>Davis</td>\n",
       "      <td>C.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>840</th>\n",
       "      <td>Totani</td>\n",
       "      <td>T.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>842</th>\n",
       "      <td>Beutler</td>\n",
       "      <td>F.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>843</th>\n",
       "      <td>Carollo</td>\n",
       "      <td>C.~M.</td>\n",
       "      <td>I</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>852</th>\n",
       "      <td>Carnero Rosell</td>\n",
       "      <td>A.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>854</th>\n",
       "      <td>Wen</td>\n",
       "      <td>L.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>855</th>\n",
       "      <td>Sako</td>\n",
       "      <td>M.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>858</th>\n",
       "      <td>Cunha</td>\n",
       "      <td>C.~E.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>860</th>\n",
       "      <td>Kartha</td>\n",
       "      <td>S.~S.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>863</th>\n",
       "      <td>Bassa</td>\n",
       "      <td>C.</td>\n",
       "      <td>I</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>864</th>\n",
       "      <td>Madau</td>\n",
       "      <td>P.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>870</th>\n",
       "      <td>Pastorello</td>\n",
       "      <td>N.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>876</th>\n",
       "      <td>Croom</td>\n",
       "      <td>S.~M.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>879</th>\n",
       "      <td>Broussard</td>\n",
       "      <td>A.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>884</th>\n",
       "      <td>Carrasco Kind</td>\n",
       "      <td>M.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>887</th>\n",
       "      <td>Coccato</td>\n",
       "      <td>L.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>890</th>\n",
       "      <td>Carretero</td>\n",
       "      <td>J.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>891</th>\n",
       "      <td>Nanayakkara</td>\n",
       "      <td>T.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>374 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Surname         Name Nationality Student   Male\n",
       "1          Bouwhuis        M.~C.           A   False   True\n",
       "2        Littlefair        S.~P.          UK   False   True\n",
       "3            Kreter           M.          DE   False   True\n",
       "4           Buckley     D.~A.~H.           A   False   True\n",
       "5           Ridolfi           A.          DE   False   True\n",
       "6        Sokolowski           M.          PL   False   True\n",
       "7           Trovato           A.           I   False   True\n",
       "8            Forbes        D.~A.           A   False   True\n",
       "9            Rumsey           C.          UK   False  False\n",
       "10         Acernese           F.          IT   False   True\n",
       "11             Cohn  Jonathan H.           I   False   True\n",
       "12           Sadler        E.~M.           A   False  False\n",
       "13           Perley        D. A.          US   False   True\n",
       "14          Wiseman           P.          UK   False   True\n",
       "15            Gruen           D.           I   False   True\n",
       "16            Eberl           T.           I   False   True\n",
       "17        Hofestadt           J.          DE   False   True\n",
       "19        Kiessling           D.           I     NaN    NaN\n",
       "20     Blagorodnova          N.           US   False  False\n",
       "21       Enzenhofer           A.           I     NaN    NaN\n",
       "22      Kreykenbohm           I.          UK   False   True\n",
       "23          Bolejko           K.           A   False   True\n",
       "24           Lupton        R.~H.          US   False   True\n",
       "25           Wilson        R.~W.          US   False   True\n",
       "26            Crisp           H.           I   False   True\n",
       "27         Bromberg           O.          IL   False   True\n",
       "28           Dodson           R.           A   False    NaN\n",
       "29             Dent     W.~R.~F.          UK   False    NaN\n",
       "30              Qiu        Siyao           A    True  False\n",
       "31           Freire     P.~C.~C.           I   False   True\n",
       "..              ...          ...         ...     ...    ...\n",
       "802            Yuan           F.           A   False    NaN\n",
       "804      Romanowsky        A.~J.           I   False    NaN\n",
       "805        Kocevski           D.           I   False    NaN\n",
       "808       Prochaska        J.~X.           I   False    NaN\n",
       "809        Johnston           S.           A   False    NaN\n",
       "810           Mould           J.           A   False    NaN\n",
       "812          Yasuda           N.           I   False    NaN\n",
       "816      Ryan-Weber        E.~V.           A   False    NaN\n",
       "820      Mickaliger           M.           I   False    NaN\n",
       "827            Amon           A.           I    True    NaN\n",
       "833         Hopkins        A.~M.           A   False    NaN\n",
       "834           Davis           C.           A   False    NaN\n",
       "835           Davis           C.           A   False    NaN\n",
       "840          Totani           T.           I   False    NaN\n",
       "842         Beutler           F.           I   False    NaN\n",
       "843         Carollo        C.~M.           I    True    NaN\n",
       "852  Carnero Rosell           A.           I   False    NaN\n",
       "854             Wen           L.           A   False    NaN\n",
       "855            Sako           M.           I   False    NaN\n",
       "858           Cunha        C.~E.           A   False    NaN\n",
       "860          Kartha        S.~S.           A   False  False\n",
       "863           Bassa           C.           I    True    NaN\n",
       "864           Madau           P.           I   False    NaN\n",
       "870      Pastorello           N.           A   False   True\n",
       "876           Croom        S.~M.           A   False    NaN\n",
       "879       Broussard           A.           I   False    NaN\n",
       "884   Carrasco Kind           M.           I   False    NaN\n",
       "887         Coccato           L.           I   False    NaN\n",
       "890       Carretero           J.           I   False    NaN\n",
       "891     Nanayakkara           T.           A   False   True\n",
       "\n",
       "[374 rows x 5 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "authors_df[authors_df.Nationality.isna() != True]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "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>Surname</th>\n",
       "      <th>Name</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>Student</th>\n",
       "      <th>Male</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Bouwhuis</td>\n",
       "      <td>M.~C.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Buckley</td>\n",
       "      <td>D.~A.~H.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Forbes</td>\n",
       "      <td>D.~A.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Sadler</td>\n",
       "      <td>E.~M.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Bolejko</td>\n",
       "      <td>K.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Dodson</td>\n",
       "      <td>R.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Qiu</td>\n",
       "      <td>Siyao</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Barat</td>\n",
       "      <td>D.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Uddin</td>\n",
       "      <td>S.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Filipovic</td>\n",
       "      <td>M.~D.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Koribalski</td>\n",
       "      <td>B.~S.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Pointon</td>\n",
       "      <td>S.~K.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Panda</td>\n",
       "      <td>Manoj</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Barr</td>\n",
       "      <td>E.~D.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Thompson</td>\n",
       "      <td>Mark C.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Caleb</td>\n",
       "      <td>M.</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Moser</td>\n",
       "      <td>I.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Alabi</td>\n",
       "      <td>A.~B.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>Lenc</td>\n",
       "      <td>E.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>Tucker</td>\n",
       "      <td>D.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>Wurster</td>\n",
       "      <td>J.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>Fisher</td>\n",
       "      <td>D.~B.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>Griffith</td>\n",
       "      <td>Martin D.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>Couch</td>\n",
       "      <td>W.~J.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>Kewley</td>\n",
       "      <td>L.~J.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>Cowley</td>\n",
       "      <td>M.~J.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>Green</td>\n",
       "      <td>A.~J.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>McDermid</td>\n",
       "      <td>R.~M.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>Tescari</td>\n",
       "      <td>E.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>Stevens</td>\n",
       "      <td>A.~R.~H.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>686</th>\n",
       "      <td>Kacprzak</td>\n",
       "      <td>G.~G.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>694</th>\n",
       "      <td>Joudaki</td>\n",
       "      <td>S.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>719</th>\n",
       "      <td>James</td>\n",
       "      <td>D.~J.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>720</th>\n",
       "      <td>James</td>\n",
       "      <td>D.~J.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>730</th>\n",
       "      <td>Hobbs</td>\n",
       "      <td>G.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>736</th>\n",
       "      <td>Schmidt</td>\n",
       "      <td>B.~P.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>747</th>\n",
       "      <td>Lewis</td>\n",
       "      <td>G.~F.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>748</th>\n",
       "      <td>Shannon</td>\n",
       "      <td>R.~M.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>751</th>\n",
       "      <td>Hill</td>\n",
       "      <td>G.~C.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>754</th>\n",
       "      <td>Campbell-Wilson</td>\n",
       "      <td>D.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>762</th>\n",
       "      <td>Brough</td>\n",
       "      <td>S.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>764</th>\n",
       "      <td>Obreschkow</td>\n",
       "      <td>D.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>772</th>\n",
       "      <td>Sharp</td>\n",
       "      <td>R.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>781</th>\n",
       "      <td>Colless</td>\n",
       "      <td>M.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>790</th>\n",
       "      <td>Wayth</td>\n",
       "      <td>R.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>794</th>\n",
       "      <td>van Straten</td>\n",
       "      <td>W.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>797</th>\n",
       "      <td>Lidman</td>\n",
       "      <td>C.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>802</th>\n",
       "      <td>Yuan</td>\n",
       "      <td>F.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>809</th>\n",
       "      <td>Johnston</td>\n",
       "      <td>S.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>810</th>\n",
       "      <td>Mould</td>\n",
       "      <td>J.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>816</th>\n",
       "      <td>Ryan-Weber</td>\n",
       "      <td>E.~V.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>833</th>\n",
       "      <td>Hopkins</td>\n",
       "      <td>A.~M.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>834</th>\n",
       "      <td>Davis</td>\n",
       "      <td>C.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>835</th>\n",
       "      <td>Davis</td>\n",
       "      <td>C.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>854</th>\n",
       "      <td>Wen</td>\n",
       "      <td>L.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>858</th>\n",
       "      <td>Cunha</td>\n",
       "      <td>C.~E.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>860</th>\n",
       "      <td>Kartha</td>\n",
       "      <td>S.~S.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>870</th>\n",
       "      <td>Pastorello</td>\n",
       "      <td>N.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>876</th>\n",
       "      <td>Croom</td>\n",
       "      <td>S.~M.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>891</th>\n",
       "      <td>Nanayakkara</td>\n",
       "      <td>T.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>141 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Surname        Name Nationality Student   Male\n",
       "1           Bouwhuis       M.~C.           A   False   True\n",
       "4            Buckley    D.~A.~H.           A   False   True\n",
       "8             Forbes       D.~A.           A   False   True\n",
       "12            Sadler       E.~M.           A   False  False\n",
       "23           Bolejko          K.           A   False   True\n",
       "28            Dodson          R.           A   False    NaN\n",
       "30               Qiu       Siyao           A    True  False\n",
       "43             Barat         D.            A    True   True\n",
       "44             Uddin          S.           A   False   True\n",
       "47         Filipovic       M.~D.           A   False    NaN\n",
       "48        Koribalski       B.~S.           A   False    NaN\n",
       "56           Pointon       S.~K.           A    True  False\n",
       "60             Panda       Manoj           A   False   True\n",
       "62              Barr       E.~D.           A   False    NaN\n",
       "70          Thompson     Mark C.           A   False   True\n",
       "77             Caleb          M.           A    True    NaN\n",
       "85             Moser          I.           A   False  False\n",
       "91             Alabi       A.~B.           A   False   True\n",
       "97              Lenc          E.           A   False    NaN\n",
       "101           Tucker          D.           A   False   True\n",
       "118          Wurster          J.           A   False    NaN\n",
       "121           Fisher       D.~B.           A   False    NaN\n",
       "122         Griffith  Martin D.            A   False   True\n",
       "130            Couch       W.~J.           A   False    NaN\n",
       "131           Kewley       L.~J.           A   False    NaN\n",
       "137           Cowley       M.~J.           A   False    NaN\n",
       "142            Green       A.~J.           A   False    NaN\n",
       "143         McDermid      R.~M.            A   False   True\n",
       "146          Tescari         E.            A   False   True\n",
       "149          Stevens    A.~R.~H.           A   False   True\n",
       "..               ...         ...         ...     ...    ...\n",
       "686         Kacprzak       G.~G.           A   False    NaN\n",
       "694          Joudaki          S.           A   False    NaN\n",
       "719            James       D.~J.           A   False    NaN\n",
       "720            James       D.~J.           A   False    NaN\n",
       "730            Hobbs          G.           A   False    NaN\n",
       "736          Schmidt       B.~P.           A   False    NaN\n",
       "747            Lewis       G.~F.           A   False    NaN\n",
       "748          Shannon       R.~M.           A   False   True\n",
       "751             Hill       G.~C.           A   False    NaN\n",
       "754  Campbell-Wilson          D.           A   False    NaN\n",
       "762           Brough          S.           A   False    NaN\n",
       "764       Obreschkow          D.           A   False    NaN\n",
       "772            Sharp          R.           A   False    NaN\n",
       "781          Colless          M.           A   False    NaN\n",
       "790            Wayth          R.           A   False    NaN\n",
       "794      van Straten          W.           A   False    NaN\n",
       "797           Lidman          C.           A   False    NaN\n",
       "802             Yuan          F.           A   False    NaN\n",
       "809         Johnston          S.           A   False    NaN\n",
       "810            Mould          J.           A   False    NaN\n",
       "816       Ryan-Weber       E.~V.           A   False    NaN\n",
       "833          Hopkins       A.~M.           A   False    NaN\n",
       "834            Davis          C.           A   False    NaN\n",
       "835            Davis          C.           A   False    NaN\n",
       "854              Wen          L.           A   False    NaN\n",
       "858            Cunha       C.~E.           A   False    NaN\n",
       "860           Kartha       S.~S.           A   False  False\n",
       "870       Pastorello          N.           A   False   True\n",
       "876            Croom       S.~M.           A   False    NaN\n",
       "891      Nanayakkara          T.           A   False   True\n",
       "\n",
       "[141 rows x 5 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "authors_df[authors_df.Nationality == 'A']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "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>Surname</th>\n",
       "      <th>Name</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>Student</th>\n",
       "      <th>Male</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Littlefair</td>\n",
       "      <td>S.~P.</td>\n",
       "      <td>UK</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kreter</td>\n",
       "      <td>M.</td>\n",
       "      <td>DE</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Ridolfi</td>\n",
       "      <td>A.</td>\n",
       "      <td>DE</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Sokolowski</td>\n",
       "      <td>M.</td>\n",
       "      <td>PL</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Trovato</td>\n",
       "      <td>A.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Rumsey</td>\n",
       "      <td>C.</td>\n",
       "      <td>UK</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Acernese</td>\n",
       "      <td>F.</td>\n",
       "      <td>IT</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Cohn</td>\n",
       "      <td>Jonathan H.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Perley</td>\n",
       "      <td>D. A.</td>\n",
       "      <td>US</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Wiseman</td>\n",
       "      <td>P.</td>\n",
       "      <td>UK</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Gruen</td>\n",
       "      <td>D.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Eberl</td>\n",
       "      <td>T.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Hofestadt</td>\n",
       "      <td>J.</td>\n",
       "      <td>DE</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Kiessling</td>\n",
       "      <td>D.</td>\n",
       "      <td>I</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Blagorodnova</td>\n",
       "      <td>N.</td>\n",
       "      <td>US</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Enzenhofer</td>\n",
       "      <td>A.</td>\n",
       "      <td>I</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Kreykenbohm</td>\n",
       "      <td>I.</td>\n",
       "      <td>UK</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Lupton</td>\n",
       "      <td>R.~H.</td>\n",
       "      <td>US</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Wilson</td>\n",
       "      <td>R.~W.</td>\n",
       "      <td>US</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Crisp</td>\n",
       "      <td>H.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Bromberg</td>\n",
       "      <td>O.</td>\n",
       "      <td>IL</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Dent</td>\n",
       "      <td>W.~R.~F.</td>\n",
       "      <td>UK</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Freire</td>\n",
       "      <td>P.~C.~C.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Baade</td>\n",
       "      <td>D.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Tomczak</td>\n",
       "      <td>A.~R.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Fosalba</td>\n",
       "      <td>P.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Coleiro</td>\n",
       "      <td>A.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Bilicki</td>\n",
       "      <td>M.</td>\n",
       "      <td>PL</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Wisnioski</td>\n",
       "      <td>E.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Ferguson</td>\n",
       "      <td>A.~M.~N.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>708</th>\n",
       "      <td>Buckley-Geer</td>\n",
       "      <td>E.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>711</th>\n",
       "      <td>Williams</td>\n",
       "      <td>A.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>712</th>\n",
       "      <td>Williams</td>\n",
       "      <td>A.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>725</th>\n",
       "      <td>Straatman</td>\n",
       "      <td>C.~M.~S.</td>\n",
       "      <td>I</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>727</th>\n",
       "      <td>Joachimi</td>\n",
       "      <td>B.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>728</th>\n",
       "      <td>Possenti</td>\n",
       "      <td>A.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>732</th>\n",
       "      <td>Quadri</td>\n",
       "      <td>R.~F.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760</th>\n",
       "      <td>Tilvi</td>\n",
       "      <td>V.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>777</th>\n",
       "      <td>Lyne</td>\n",
       "      <td>A.~G.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>783</th>\n",
       "      <td>Jennings</td>\n",
       "      <td>Z.~G.</td>\n",
       "      <td>I</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>785</th>\n",
       "      <td>Abdalla</td>\n",
       "      <td>F.~B.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>787</th>\n",
       "      <td>Morrison</td>\n",
       "      <td>G.~E.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>801</th>\n",
       "      <td>Labbe</td>\n",
       "      <td>I.</td>\n",
       "      <td>I</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>804</th>\n",
       "      <td>Romanowsky</td>\n",
       "      <td>A.~J.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>805</th>\n",
       "      <td>Kocevski</td>\n",
       "      <td>D.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>808</th>\n",
       "      <td>Prochaska</td>\n",
       "      <td>J.~X.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>812</th>\n",
       "      <td>Yasuda</td>\n",
       "      <td>N.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>820</th>\n",
       "      <td>Mickaliger</td>\n",
       "      <td>M.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>827</th>\n",
       "      <td>Amon</td>\n",
       "      <td>A.</td>\n",
       "      <td>I</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>840</th>\n",
       "      <td>Totani</td>\n",
       "      <td>T.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>842</th>\n",
       "      <td>Beutler</td>\n",
       "      <td>F.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>843</th>\n",
       "      <td>Carollo</td>\n",
       "      <td>C.~M.</td>\n",
       "      <td>I</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>852</th>\n",
       "      <td>Carnero Rosell</td>\n",
       "      <td>A.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>855</th>\n",
       "      <td>Sako</td>\n",
       "      <td>M.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>863</th>\n",
       "      <td>Bassa</td>\n",
       "      <td>C.</td>\n",
       "      <td>I</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>864</th>\n",
       "      <td>Madau</td>\n",
       "      <td>P.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>879</th>\n",
       "      <td>Broussard</td>\n",
       "      <td>A.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>884</th>\n",
       "      <td>Carrasco Kind</td>\n",
       "      <td>M.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>887</th>\n",
       "      <td>Coccato</td>\n",
       "      <td>L.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>890</th>\n",
       "      <td>Carretero</td>\n",
       "      <td>J.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>233 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Surname         Name Nationality Student   Male\n",
       "2        Littlefair        S.~P.          UK   False   True\n",
       "3            Kreter           M.          DE   False   True\n",
       "5           Ridolfi           A.          DE   False   True\n",
       "6        Sokolowski           M.          PL   False   True\n",
       "7           Trovato           A.           I   False   True\n",
       "9            Rumsey           C.          UK   False  False\n",
       "10         Acernese           F.          IT   False   True\n",
       "11             Cohn  Jonathan H.           I   False   True\n",
       "13           Perley        D. A.          US   False   True\n",
       "14          Wiseman           P.          UK   False   True\n",
       "15            Gruen           D.           I   False   True\n",
       "16            Eberl           T.           I   False   True\n",
       "17        Hofestadt           J.          DE   False   True\n",
       "19        Kiessling           D.           I     NaN    NaN\n",
       "20     Blagorodnova          N.           US   False  False\n",
       "21       Enzenhofer           A.           I     NaN    NaN\n",
       "22      Kreykenbohm           I.          UK   False   True\n",
       "24           Lupton        R.~H.          US   False   True\n",
       "25           Wilson        R.~W.          US   False   True\n",
       "26            Crisp           H.           I   False   True\n",
       "27         Bromberg           O.          IL   False   True\n",
       "29             Dent     W.~R.~F.          UK   False    NaN\n",
       "31           Freire     P.~C.~C.           I   False   True\n",
       "32            Baade          D.            I   False   True\n",
       "33          Tomczak        A.~R.           I   False   True\n",
       "34          Fosalba           P.           I   False   True\n",
       "35          Coleiro           A.           I   False   True\n",
       "36          Bilicki          M.           PL   False   True\n",
       "37        Wisnioski           E.           I   False    NaN\n",
       "39         Ferguson     A.~M.~N.           I   False    NaN\n",
       "..              ...          ...         ...     ...    ...\n",
       "708    Buckley-Geer           E.           I   False    NaN\n",
       "711        Williams           A.           I   False    NaN\n",
       "712        Williams           A.           I   False    NaN\n",
       "725       Straatman     C.~M.~S.           I    True    NaN\n",
       "727        Joachimi           B.           I   False    NaN\n",
       "728        Possenti           A.           I   False    NaN\n",
       "732          Quadri        R.~F.           I   False    NaN\n",
       "760           Tilvi           V.           I   False    NaN\n",
       "777            Lyne        A.~G.           I   False    NaN\n",
       "783        Jennings        Z.~G.           I    True    NaN\n",
       "785         Abdalla        F.~B.           I   False    NaN\n",
       "787        Morrison        G.~E.           I   False    NaN\n",
       "801           Labbe           I.           I    True    NaN\n",
       "804      Romanowsky        A.~J.           I   False    NaN\n",
       "805        Kocevski           D.           I   False    NaN\n",
       "808       Prochaska        J.~X.           I   False    NaN\n",
       "812          Yasuda           N.           I   False    NaN\n",
       "820      Mickaliger           M.           I   False    NaN\n",
       "827            Amon           A.           I    True    NaN\n",
       "840          Totani           T.           I   False    NaN\n",
       "842         Beutler           F.           I   False    NaN\n",
       "843         Carollo        C.~M.           I    True    NaN\n",
       "852  Carnero Rosell           A.           I   False    NaN\n",
       "855            Sako           M.           I   False    NaN\n",
       "863           Bassa           C.           I    True    NaN\n",
       "864           Madau           P.           I   False    NaN\n",
       "879       Broussard           A.           I   False    NaN\n",
       "884   Carrasco Kind           M.           I   False    NaN\n",
       "887         Coccato           L.           I   False    NaN\n",
       "890       Carretero           J.           I   False    NaN\n",
       "\n",
       "[233 rows x 5 columns]"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "authors_df[((authors_df.Nationality != 'A') & (authors_df.Nationality.isna() != True))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "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>Surname</th>\n",
       "      <th>Name</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>Student</th>\n",
       "      <th>Male</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Bouwhuis</td>\n",
       "      <td>M.~C.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Littlefair</td>\n",
       "      <td>S.~P.</td>\n",
       "      <td>UK</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kreter</td>\n",
       "      <td>M.</td>\n",
       "      <td>DE</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Buckley</td>\n",
       "      <td>D.~A.~H.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Ridolfi</td>\n",
       "      <td>A.</td>\n",
       "      <td>DE</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Sokolowski</td>\n",
       "      <td>M.</td>\n",
       "      <td>PL</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Trovato</td>\n",
       "      <td>A.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Forbes</td>\n",
       "      <td>D.~A.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Rumsey</td>\n",
       "      <td>C.</td>\n",
       "      <td>UK</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Acernese</td>\n",
       "      <td>F.</td>\n",
       "      <td>IT</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Cohn</td>\n",
       "      <td>Jonathan H.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Sadler</td>\n",
       "      <td>E.~M.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Perley</td>\n",
       "      <td>D. A.</td>\n",
       "      <td>US</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Wiseman</td>\n",
       "      <td>P.</td>\n",
       "      <td>UK</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Gruen</td>\n",
       "      <td>D.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Eberl</td>\n",
       "      <td>T.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Hofestadt</td>\n",
       "      <td>J.</td>\n",
       "      <td>DE</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Blagorodnova</td>\n",
       "      <td>N.</td>\n",
       "      <td>US</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Kreykenbohm</td>\n",
       "      <td>I.</td>\n",
       "      <td>UK</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Bolejko</td>\n",
       "      <td>K.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Lupton</td>\n",
       "      <td>R.~H.</td>\n",
       "      <td>US</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Wilson</td>\n",
       "      <td>R.~W.</td>\n",
       "      <td>US</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Crisp</td>\n",
       "      <td>H.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Bromberg</td>\n",
       "      <td>O.</td>\n",
       "      <td>IL</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Dodson</td>\n",
       "      <td>R.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Dent</td>\n",
       "      <td>W.~R.~F.</td>\n",
       "      <td>UK</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Qiu</td>\n",
       "      <td>Siyao</td>\n",
       "      <td>A</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Freire</td>\n",
       "      <td>P.~C.~C.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Baade</td>\n",
       "      <td>D.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Tomczak</td>\n",
       "      <td>A.~R.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>809</th>\n",
       "      <td>Johnston</td>\n",
       "      <td>S.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>810</th>\n",
       "      <td>Mould</td>\n",
       "      <td>J.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>812</th>\n",
       "      <td>Yasuda</td>\n",
       "      <td>N.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>816</th>\n",
       "      <td>Ryan-Weber</td>\n",
       "      <td>E.~V.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>820</th>\n",
       "      <td>Mickaliger</td>\n",
       "      <td>M.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>827</th>\n",
       "      <td>Amon</td>\n",
       "      <td>A.</td>\n",
       "      <td>I</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>831</th>\n",
       "      <td>Frieman</td>\n",
       "      <td>J.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>833</th>\n",
       "      <td>Hopkins</td>\n",
       "      <td>A.~M.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>834</th>\n",
       "      <td>Davis</td>\n",
       "      <td>C.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>835</th>\n",
       "      <td>Davis</td>\n",
       "      <td>C.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>838</th>\n",
       "      <td>Zhang</td>\n",
       "      <td>B.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>840</th>\n",
       "      <td>Totani</td>\n",
       "      <td>T.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>842</th>\n",
       "      <td>Beutler</td>\n",
       "      <td>F.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>843</th>\n",
       "      <td>Carollo</td>\n",
       "      <td>C.~M.</td>\n",
       "      <td>I</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>852</th>\n",
       "      <td>Carnero Rosell</td>\n",
       "      <td>A.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>854</th>\n",
       "      <td>Wen</td>\n",
       "      <td>L.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>855</th>\n",
       "      <td>Sako</td>\n",
       "      <td>M.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>858</th>\n",
       "      <td>Cunha</td>\n",
       "      <td>C.~E.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>860</th>\n",
       "      <td>Kartha</td>\n",
       "      <td>S.~S.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>863</th>\n",
       "      <td>Bassa</td>\n",
       "      <td>C.</td>\n",
       "      <td>I</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>864</th>\n",
       "      <td>Madau</td>\n",
       "      <td>P.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>870</th>\n",
       "      <td>Pastorello</td>\n",
       "      <td>N.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>876</th>\n",
       "      <td>Croom</td>\n",
       "      <td>S.~M.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>879</th>\n",
       "      <td>Broussard</td>\n",
       "      <td>A.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>883</th>\n",
       "      <td>Lima</td>\n",
       "      <td>M.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>884</th>\n",
       "      <td>Carrasco Kind</td>\n",
       "      <td>M.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>887</th>\n",
       "      <td>Coccato</td>\n",
       "      <td>L.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>890</th>\n",
       "      <td>Carretero</td>\n",
       "      <td>J.</td>\n",
       "      <td>I</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>891</th>\n",
       "      <td>Nanayakkara</td>\n",
       "      <td>T.</td>\n",
       "      <td>A</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>892</th>\n",
       "      <td>Doel</td>\n",
       "      <td>P.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>395 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Surname         Name Nationality Student   Male\n",
       "1          Bouwhuis        M.~C.           A   False   True\n",
       "2        Littlefair        S.~P.          UK   False   True\n",
       "3            Kreter           M.          DE   False   True\n",
       "4           Buckley     D.~A.~H.           A   False   True\n",
       "5           Ridolfi           A.          DE   False   True\n",
       "6        Sokolowski           M.          PL   False   True\n",
       "7           Trovato           A.           I   False   True\n",
       "8            Forbes        D.~A.           A   False   True\n",
       "9            Rumsey           C.          UK   False  False\n",
       "10         Acernese           F.          IT   False   True\n",
       "11             Cohn  Jonathan H.           I   False   True\n",
       "12           Sadler        E.~M.           A   False  False\n",
       "13           Perley        D. A.          US   False   True\n",
       "14          Wiseman           P.          UK   False   True\n",
       "15            Gruen           D.           I   False   True\n",
       "16            Eberl           T.           I   False   True\n",
       "17        Hofestadt           J.          DE   False   True\n",
       "20     Blagorodnova          N.           US   False  False\n",
       "22      Kreykenbohm           I.          UK   False   True\n",
       "23          Bolejko           K.           A   False   True\n",
       "24           Lupton        R.~H.          US   False   True\n",
       "25           Wilson        R.~W.          US   False   True\n",
       "26            Crisp           H.           I   False   True\n",
       "27         Bromberg           O.          IL   False   True\n",
       "28           Dodson           R.           A   False    NaN\n",
       "29             Dent     W.~R.~F.          UK   False    NaN\n",
       "30              Qiu        Siyao           A    True  False\n",
       "31           Freire     P.~C.~C.           I   False   True\n",
       "32            Baade          D.            I   False   True\n",
       "33          Tomczak        A.~R.           I   False   True\n",
       "..              ...          ...         ...     ...    ...\n",
       "809        Johnston           S.           A   False    NaN\n",
       "810           Mould           J.           A   False    NaN\n",
       "812          Yasuda           N.           I   False    NaN\n",
       "816      Ryan-Weber        E.~V.           A   False    NaN\n",
       "820      Mickaliger           M.           I   False    NaN\n",
       "827            Amon           A.           I    True    NaN\n",
       "831         Frieman           J.         NaN   False    NaN\n",
       "833         Hopkins        A.~M.           A   False    NaN\n",
       "834           Davis           C.           A   False    NaN\n",
       "835           Davis           C.           A   False    NaN\n",
       "838           Zhang           B.         NaN   False    NaN\n",
       "840          Totani           T.           I   False    NaN\n",
       "842         Beutler           F.           I   False    NaN\n",
       "843         Carollo        C.~M.           I    True    NaN\n",
       "852  Carnero Rosell           A.           I   False    NaN\n",
       "854             Wen           L.           A   False    NaN\n",
       "855            Sako           M.           I   False    NaN\n",
       "858           Cunha        C.~E.           A   False    NaN\n",
       "860          Kartha        S.~S.           A   False  False\n",
       "863           Bassa           C.           I    True    NaN\n",
       "864           Madau           P.           I   False    NaN\n",
       "870      Pastorello           N.           A   False   True\n",
       "876           Croom        S.~M.           A   False    NaN\n",
       "879       Broussard           A.           I   False    NaN\n",
       "883            Lima           M.         NaN   False    NaN\n",
       "884   Carrasco Kind           M.           I   False    NaN\n",
       "887         Coccato           L.           I   False    NaN\n",
       "890       Carretero           J.           I   False    NaN\n",
       "891     Nanayakkara           T.           A   False   True\n",
       "892            Doel           P.         NaN   False    NaN\n",
       "\n",
       "[395 rows x 5 columns]"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "authors_df[authors_df.Student.isna() != True]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False    361\n",
       "True      34\n",
       "Name: Student, dtype: int64"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "authors_df.Student.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [default]",
   "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.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}