Missing_Data.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# How to Deal with Missing Data in Python"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Learning Objectives\n",
    "During the process of data exploration, it is not uncommon to realize that the data we have is incomplete. Missing data could arise as a result of changes in data collection methods, human error, bias, or simply the lack of reliable input. There are several ways to deal with missing data. By the end of the tutorial, you will have learned:\n",
    "\n",
    "+ how to detect missing data\n",
    "+ how to remove missing data\n",
    "+ how to resolve missing data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "H4h5CV-p3fsD"
   },
   "source": [
    "## How to Detect Missing Values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "ZBtXnome3fr0"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>FirstName</th>\n",
       "      <th>LastName</th>\n",
       "      <th>Major</th>\n",
       "      <th>Minor</th>\n",
       "      <th>Age</th>\n",
       "      <th>Gender</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Zip</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1869</td>\n",
       "      <td>Hana</td>\n",
       "      <td>Barton</td>\n",
       "      <td>Finance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2010</td>\n",
       "      <td>Alicia</td>\n",
       "      <td>Kanuri</td>\n",
       "      <td>Management</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Berrien Springs</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2075</td>\n",
       "      <td>Becca</td>\n",
       "      <td>Swanson</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>IL</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2228</td>\n",
       "      <td>Halima</td>\n",
       "      <td>Aminu</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>GA</td>\n",
       "      <td>30303.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2442</td>\n",
       "      <td>Holly</td>\n",
       "      <td>Robinson</td>\n",
       "      <td>Finance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Charlotte</td>\n",
       "      <td>NC</td>\n",
       "      <td>28202.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2858</td>\n",
       "      <td>Carla</td>\n",
       "      <td>Harding</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Female</td>\n",
       "      <td>Youngstown</td>\n",
       "      <td>OH</td>\n",
       "      <td>44502.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3459</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Swanson</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Granger</td>\n",
       "      <td>IN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3585</td>\n",
       "      <td>Aminah</td>\n",
       "      <td>Zalim</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Ashburn</td>\n",
       "      <td>VA</td>\n",
       "      <td>20147.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5170</td>\n",
       "      <td>Gus</td>\n",
       "      <td>Cunningham</td>\n",
       "      <td>Finance</td>\n",
       "      <td>Innovation</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Massillon</td>\n",
       "      <td>OH</td>\n",
       "      <td>44646.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5317</td>\n",
       "      <td>Rafael</td>\n",
       "      <td>Solis</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>ACMS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>South Bend</td>\n",
       "      <td>IN</td>\n",
       "      <td>46601.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>5336</td>\n",
       "      <td>Homer</td>\n",
       "      <td>White</td>\n",
       "      <td>Finance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Male</td>\n",
       "      <td>St. Paul</td>\n",
       "      <td>MN</td>\n",
       "      <td>55101.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5495</td>\n",
       "      <td>Lara</td>\n",
       "      <td>Woods</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dallas</td>\n",
       "      <td>TX</td>\n",
       "      <td>75201.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>6453</td>\n",
       "      <td>Otis</td>\n",
       "      <td>Johnson</td>\n",
       "      <td>Management</td>\n",
       "      <td>Political Science</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Anchorage</td>\n",
       "      <td>AK</td>\n",
       "      <td>99501.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>6504</td>\n",
       "      <td>Chantelle</td>\n",
       "      <td>Woods</td>\n",
       "      <td>Business Technology</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>6768</td>\n",
       "      <td>Caroline</td>\n",
       "      <td>Marsh</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>ACMS</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Niles</td>\n",
       "      <td>MI</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>7511</td>\n",
       "      <td>Laila</td>\n",
       "      <td>Carroll</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>Innovation</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>New York</td>\n",
       "      <td>NY</td>\n",
       "      <td>10001.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>7965</td>\n",
       "      <td>Rocco</td>\n",
       "      <td>Decola</td>\n",
       "      <td>Finance</td>\n",
       "      <td>Innovation</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Oakland</td>\n",
       "      <td>CA</td>\n",
       "      <td>94603.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>9232</td>\n",
       "      <td>Julie</td>\n",
       "      <td>Holmes</td>\n",
       "      <td>Business Technology</td>\n",
       "      <td>Innovation</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Webster</td>\n",
       "      <td>NY</td>\n",
       "      <td>14580.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>9268</td>\n",
       "      <td>Albert</td>\n",
       "      <td>Palmer</td>\n",
       "      <td>Management</td>\n",
       "      <td>Real Estate</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Detroit</td>\n",
       "      <td>MI</td>\n",
       "      <td>48201.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>9941</td>\n",
       "      <td>Zoya</td>\n",
       "      <td>Doyle</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>IL</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      ID  FirstName    LastName                Major              Minor   Age  \\\n",
       "0   1869       Hana      Barton              Finance                NaN  22.0   \n",
       "1   2010     Alicia      Kanuri           Management                NaN  21.0   \n",
       "2   2075      Becca     Swanson            Marketing                NaN  22.0   \n",
       "3   2228     Halima       Aminu   Business Analytics                NaN  20.0   \n",
       "4   2442      Holly    Robinson              Finance                NaN  20.0   \n",
       "5   2858      Carla     Harding          Accountancy                NaN   NaN   \n",
       "6   3459       Alex     Swanson          Accountancy                NaN   NaN   \n",
       "7   3585     Aminah       Zalim            Marketing                NaN  20.0   \n",
       "8   5170        Gus  Cunningham              Finance         Innovation  21.0   \n",
       "9   5317     Rafael       Solis   Business Analytics               ACMS   NaN   \n",
       "10  5336      Homer       White              Finance                NaN   NaN   \n",
       "11  5495       Lara       Woods          Accountancy                NaN   NaN   \n",
       "12  6453       Otis     Johnson           Management  Political Science  19.0   \n",
       "13  6504  Chantelle       Woods  Business Technology                NaN  18.0   \n",
       "14  6768   Caroline       Marsh   Business Analytics               ACMS  22.0   \n",
       "15  7511      Laila     Carroll            Marketing         Innovation  20.0   \n",
       "16  7965      Rocco      Decola              Finance         Innovation  21.0   \n",
       "17  9232      Julie      Holmes  Business Technology         Innovation  18.0   \n",
       "18  9268     Albert      Palmer           Management        Real Estate  21.0   \n",
       "19  9941       Zoya       Doyle   Business Analytics                NaN   NaN   \n",
       "\n",
       "    Gender             City State      Zip  \n",
       "0   Female              NaN   NaN      NaN  \n",
       "1   Female  Berrien Springs   NaN      NaN  \n",
       "2   Female          Chicago    IL  60608.0  \n",
       "3   Female          Atlanta    GA  30303.0  \n",
       "4   Female        Charlotte    NC  28202.0  \n",
       "5   Female       Youngstown    OH  44502.0  \n",
       "6      NaN          Granger    IN      NaN  \n",
       "7   Female          Ashburn    VA  20147.0  \n",
       "8     Male        Massillon    OH  44646.0  \n",
       "9      NaN       South Bend    IN  46601.0  \n",
       "10    Male         St. Paul    MN  55101.0  \n",
       "11     NaN           Dallas    TX  75201.0  \n",
       "12    Male        Anchorage    AK  99501.0  \n",
       "13  Female          Chicago   NaN  60608.0  \n",
       "14  Female            Niles    MI      NaN  \n",
       "15  Female         New York    NY  10001.0  \n",
       "16    Male          Oakland    CA  94603.0  \n",
       "17  Female          Webster    NY  14580.0  \n",
       "18    Male          Detroit    MI  48201.0  \n",
       "19  Female          Chicago    IL  60608.0  "
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "students = pd.read_excel(\"students.xlsx\")\n",
    "students"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0      True\n",
       "1      True\n",
       "2     False\n",
       "3     False\n",
       "4     False\n",
       "5     False\n",
       "6     False\n",
       "7     False\n",
       "8     False\n",
       "9     False\n",
       "10    False\n",
       "11    False\n",
       "12    False\n",
       "13     True\n",
       "14    False\n",
       "15    False\n",
       "16    False\n",
       "17    False\n",
       "18    False\n",
       "19    False\n",
       "Name: State, dtype: bool"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mask = students['State'].isnull()\n",
    "mask"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>FirstName</th>\n",
       "      <th>LastName</th>\n",
       "      <th>Major</th>\n",
       "      <th>Minor</th>\n",
       "      <th>Age</th>\n",
       "      <th>Gender</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Zip</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1869</td>\n",
       "      <td>Hana</td>\n",
       "      <td>Barton</td>\n",
       "      <td>Finance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2010</td>\n",
       "      <td>Alicia</td>\n",
       "      <td>Kanuri</td>\n",
       "      <td>Management</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Berrien Springs</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>6504</td>\n",
       "      <td>Chantelle</td>\n",
       "      <td>Woods</td>\n",
       "      <td>Business Technology</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      ID  FirstName LastName                Major Minor   Age  Gender  \\\n",
       "0   1869       Hana   Barton              Finance   NaN  22.0  Female   \n",
       "1   2010     Alicia   Kanuri           Management   NaN  21.0  Female   \n",
       "13  6504  Chantelle    Woods  Business Technology   NaN  18.0  Female   \n",
       "\n",
       "               City State      Zip  \n",
       "0               NaN   NaN      NaN  \n",
       "1   Berrien Springs   NaN      NaN  \n",
       "13          Chicago   NaN  60608.0  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "students[mask]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## How to Remove Missing Values"
   ]
  },
  {
   "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>ID</th>\n",
       "      <th>FirstName</th>\n",
       "      <th>LastName</th>\n",
       "      <th>Major</th>\n",
       "      <th>Minor</th>\n",
       "      <th>Age</th>\n",
       "      <th>Gender</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Zip</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5170</td>\n",
       "      <td>Gus</td>\n",
       "      <td>Cunningham</td>\n",
       "      <td>Finance</td>\n",
       "      <td>Innovation</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Massillon</td>\n",
       "      <td>OH</td>\n",
       "      <td>44646.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>6453</td>\n",
       "      <td>Otis</td>\n",
       "      <td>Johnson</td>\n",
       "      <td>Management</td>\n",
       "      <td>Political Science</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Anchorage</td>\n",
       "      <td>AK</td>\n",
       "      <td>99501.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>7511</td>\n",
       "      <td>Laila</td>\n",
       "      <td>Carroll</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>Innovation</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>New York</td>\n",
       "      <td>NY</td>\n",
       "      <td>10001.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>7965</td>\n",
       "      <td>Rocco</td>\n",
       "      <td>Decola</td>\n",
       "      <td>Finance</td>\n",
       "      <td>Innovation</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Oakland</td>\n",
       "      <td>CA</td>\n",
       "      <td>94603.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>9232</td>\n",
       "      <td>Julie</td>\n",
       "      <td>Holmes</td>\n",
       "      <td>Business Technology</td>\n",
       "      <td>Innovation</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Webster</td>\n",
       "      <td>NY</td>\n",
       "      <td>14580.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>9268</td>\n",
       "      <td>Albert</td>\n",
       "      <td>Palmer</td>\n",
       "      <td>Management</td>\n",
       "      <td>Real Estate</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Detroit</td>\n",
       "      <td>MI</td>\n",
       "      <td>48201.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      ID FirstName    LastName                Major              Minor   Age  \\\n",
       "8   5170       Gus  Cunningham              Finance         Innovation  21.0   \n",
       "12  6453      Otis     Johnson           Management  Political Science  19.0   \n",
       "15  7511     Laila     Carroll            Marketing         Innovation  20.0   \n",
       "16  7965     Rocco      Decola              Finance         Innovation  21.0   \n",
       "17  9232     Julie      Holmes  Business Technology         Innovation  18.0   \n",
       "18  9268    Albert      Palmer           Management        Real Estate  21.0   \n",
       "\n",
       "    Gender       City State      Zip  \n",
       "8     Male  Massillon    OH  44646.0  \n",
       "12    Male  Anchorage    AK  99501.0  \n",
       "15  Female   New York    NY  10001.0  \n",
       "16    Male    Oakland    CA  94603.0  \n",
       "17  Female    Webster    NY  14580.0  \n",
       "18    Male    Detroit    MI  48201.0  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "students.dropna()"
   ]
  },
  {
   "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>ID</th>\n",
       "      <th>FirstName</th>\n",
       "      <th>LastName</th>\n",
       "      <th>Major</th>\n",
       "      <th>Minor</th>\n",
       "      <th>Age</th>\n",
       "      <th>Gender</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Zip</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2075</td>\n",
       "      <td>Becca</td>\n",
       "      <td>Swanson</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>IL</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2228</td>\n",
       "      <td>Halima</td>\n",
       "      <td>Aminu</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>GA</td>\n",
       "      <td>30303.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2442</td>\n",
       "      <td>Holly</td>\n",
       "      <td>Robinson</td>\n",
       "      <td>Finance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Charlotte</td>\n",
       "      <td>NC</td>\n",
       "      <td>28202.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2858</td>\n",
       "      <td>Carla</td>\n",
       "      <td>Harding</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Female</td>\n",
       "      <td>Youngstown</td>\n",
       "      <td>OH</td>\n",
       "      <td>44502.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3459</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Swanson</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Granger</td>\n",
       "      <td>IN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3585</td>\n",
       "      <td>Aminah</td>\n",
       "      <td>Zalim</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Ashburn</td>\n",
       "      <td>VA</td>\n",
       "      <td>20147.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5170</td>\n",
       "      <td>Gus</td>\n",
       "      <td>Cunningham</td>\n",
       "      <td>Finance</td>\n",
       "      <td>Innovation</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Massillon</td>\n",
       "      <td>OH</td>\n",
       "      <td>44646.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5317</td>\n",
       "      <td>Rafael</td>\n",
       "      <td>Solis</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>ACMS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>South Bend</td>\n",
       "      <td>IN</td>\n",
       "      <td>46601.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>5336</td>\n",
       "      <td>Homer</td>\n",
       "      <td>White</td>\n",
       "      <td>Finance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Male</td>\n",
       "      <td>St. Paul</td>\n",
       "      <td>MN</td>\n",
       "      <td>55101.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5495</td>\n",
       "      <td>Lara</td>\n",
       "      <td>Woods</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dallas</td>\n",
       "      <td>TX</td>\n",
       "      <td>75201.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>6453</td>\n",
       "      <td>Otis</td>\n",
       "      <td>Johnson</td>\n",
       "      <td>Management</td>\n",
       "      <td>Political Science</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Anchorage</td>\n",
       "      <td>AK</td>\n",
       "      <td>99501.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>6504</td>\n",
       "      <td>Chantelle</td>\n",
       "      <td>Woods</td>\n",
       "      <td>Business Technology</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>6768</td>\n",
       "      <td>Caroline</td>\n",
       "      <td>Marsh</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>ACMS</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Niles</td>\n",
       "      <td>MI</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>7511</td>\n",
       "      <td>Laila</td>\n",
       "      <td>Carroll</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>Innovation</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>New York</td>\n",
       "      <td>NY</td>\n",
       "      <td>10001.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>7965</td>\n",
       "      <td>Rocco</td>\n",
       "      <td>Decola</td>\n",
       "      <td>Finance</td>\n",
       "      <td>Innovation</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Oakland</td>\n",
       "      <td>CA</td>\n",
       "      <td>94603.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>9232</td>\n",
       "      <td>Julie</td>\n",
       "      <td>Holmes</td>\n",
       "      <td>Business Technology</td>\n",
       "      <td>Innovation</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Webster</td>\n",
       "      <td>NY</td>\n",
       "      <td>14580.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>9268</td>\n",
       "      <td>Albert</td>\n",
       "      <td>Palmer</td>\n",
       "      <td>Management</td>\n",
       "      <td>Real Estate</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Detroit</td>\n",
       "      <td>MI</td>\n",
       "      <td>48201.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>9941</td>\n",
       "      <td>Zoya</td>\n",
       "      <td>Doyle</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>IL</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      ID  FirstName    LastName                Major              Minor   Age  \\\n",
       "2   2075      Becca     Swanson            Marketing                NaN  22.0   \n",
       "3   2228     Halima       Aminu   Business Analytics                NaN  20.0   \n",
       "4   2442      Holly    Robinson              Finance                NaN  20.0   \n",
       "5   2858      Carla     Harding          Accountancy                NaN   NaN   \n",
       "6   3459       Alex     Swanson          Accountancy                NaN   NaN   \n",
       "7   3585     Aminah       Zalim            Marketing                NaN  20.0   \n",
       "8   5170        Gus  Cunningham              Finance         Innovation  21.0   \n",
       "9   5317     Rafael       Solis   Business Analytics               ACMS   NaN   \n",
       "10  5336      Homer       White              Finance                NaN   NaN   \n",
       "11  5495       Lara       Woods          Accountancy                NaN   NaN   \n",
       "12  6453       Otis     Johnson           Management  Political Science  19.0   \n",
       "13  6504  Chantelle       Woods  Business Technology                NaN  18.0   \n",
       "14  6768   Caroline       Marsh   Business Analytics               ACMS  22.0   \n",
       "15  7511      Laila     Carroll            Marketing         Innovation  20.0   \n",
       "16  7965      Rocco      Decola              Finance         Innovation  21.0   \n",
       "17  9232      Julie      Holmes  Business Technology         Innovation  18.0   \n",
       "18  9268     Albert      Palmer           Management        Real Estate  21.0   \n",
       "19  9941       Zoya       Doyle   Business Analytics                NaN   NaN   \n",
       "\n",
       "    Gender        City State      Zip  \n",
       "2   Female     Chicago    IL  60608.0  \n",
       "3   Female     Atlanta    GA  30303.0  \n",
       "4   Female   Charlotte    NC  28202.0  \n",
       "5   Female  Youngstown    OH  44502.0  \n",
       "6      NaN     Granger    IN      NaN  \n",
       "7   Female     Ashburn    VA  20147.0  \n",
       "8     Male   Massillon    OH  44646.0  \n",
       "9      NaN  South Bend    IN  46601.0  \n",
       "10    Male    St. Paul    MN  55101.0  \n",
       "11     NaN      Dallas    TX  75201.0  \n",
       "12    Male   Anchorage    AK  99501.0  \n",
       "13  Female     Chicago   NaN  60608.0  \n",
       "14  Female       Niles    MI      NaN  \n",
       "15  Female    New York    NY  10001.0  \n",
       "16    Male     Oakland    CA  94603.0  \n",
       "17  Female     Webster    NY  14580.0  \n",
       "18    Male     Detroit    MI  48201.0  \n",
       "19  Female     Chicago    IL  60608.0  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "students = students.dropna(subset = ['State', 'Zip'], how = 'all')\n",
    "students"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>FirstName</th>\n",
       "      <th>LastName</th>\n",
       "      <th>Major</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2075</td>\n",
       "      <td>Becca</td>\n",
       "      <td>Swanson</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>Chicago</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2228</td>\n",
       "      <td>Halima</td>\n",
       "      <td>Aminu</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>Atlanta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2442</td>\n",
       "      <td>Holly</td>\n",
       "      <td>Robinson</td>\n",
       "      <td>Finance</td>\n",
       "      <td>Charlotte</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2858</td>\n",
       "      <td>Carla</td>\n",
       "      <td>Harding</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>Youngstown</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3459</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Swanson</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>Granger</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3585</td>\n",
       "      <td>Aminah</td>\n",
       "      <td>Zalim</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>Ashburn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5170</td>\n",
       "      <td>Gus</td>\n",
       "      <td>Cunningham</td>\n",
       "      <td>Finance</td>\n",
       "      <td>Massillon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5317</td>\n",
       "      <td>Rafael</td>\n",
       "      <td>Solis</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>South Bend</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>5336</td>\n",
       "      <td>Homer</td>\n",
       "      <td>White</td>\n",
       "      <td>Finance</td>\n",
       "      <td>St. Paul</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5495</td>\n",
       "      <td>Lara</td>\n",
       "      <td>Woods</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>Dallas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>6453</td>\n",
       "      <td>Otis</td>\n",
       "      <td>Johnson</td>\n",
       "      <td>Management</td>\n",
       "      <td>Anchorage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>6504</td>\n",
       "      <td>Chantelle</td>\n",
       "      <td>Woods</td>\n",
       "      <td>Business Technology</td>\n",
       "      <td>Chicago</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>6768</td>\n",
       "      <td>Caroline</td>\n",
       "      <td>Marsh</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>Niles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>7511</td>\n",
       "      <td>Laila</td>\n",
       "      <td>Carroll</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>New York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>7965</td>\n",
       "      <td>Rocco</td>\n",
       "      <td>Decola</td>\n",
       "      <td>Finance</td>\n",
       "      <td>Oakland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>9232</td>\n",
       "      <td>Julie</td>\n",
       "      <td>Holmes</td>\n",
       "      <td>Business Technology</td>\n",
       "      <td>Webster</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>9268</td>\n",
       "      <td>Albert</td>\n",
       "      <td>Palmer</td>\n",
       "      <td>Management</td>\n",
       "      <td>Detroit</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>9941</td>\n",
       "      <td>Zoya</td>\n",
       "      <td>Doyle</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>Chicago</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      ID  FirstName    LastName                Major        City\n",
       "2   2075      Becca     Swanson            Marketing     Chicago\n",
       "3   2228     Halima       Aminu   Business Analytics     Atlanta\n",
       "4   2442      Holly    Robinson              Finance   Charlotte\n",
       "5   2858      Carla     Harding          Accountancy  Youngstown\n",
       "6   3459       Alex     Swanson          Accountancy     Granger\n",
       "7   3585     Aminah       Zalim            Marketing     Ashburn\n",
       "8   5170        Gus  Cunningham              Finance   Massillon\n",
       "9   5317     Rafael       Solis   Business Analytics  South Bend\n",
       "10  5336      Homer       White              Finance    St. Paul\n",
       "11  5495       Lara       Woods          Accountancy      Dallas\n",
       "12  6453       Otis     Johnson           Management   Anchorage\n",
       "13  6504  Chantelle       Woods  Business Technology     Chicago\n",
       "14  6768   Caroline       Marsh   Business Analytics       Niles\n",
       "15  7511      Laila     Carroll            Marketing    New York\n",
       "16  7965      Rocco      Decola              Finance     Oakland\n",
       "17  9232      Julie      Holmes  Business Technology     Webster\n",
       "18  9268     Albert      Palmer           Management     Detroit\n",
       "19  9941       Zoya       Doyle   Business Analytics     Chicago"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "students.dropna(axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>FirstName</th>\n",
       "      <th>LastName</th>\n",
       "      <th>Major</th>\n",
       "      <th>Age</th>\n",
       "      <th>Gender</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Zip</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2075</td>\n",
       "      <td>Becca</td>\n",
       "      <td>Swanson</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>IL</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2228</td>\n",
       "      <td>Halima</td>\n",
       "      <td>Aminu</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>GA</td>\n",
       "      <td>30303.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2442</td>\n",
       "      <td>Holly</td>\n",
       "      <td>Robinson</td>\n",
       "      <td>Finance</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Charlotte</td>\n",
       "      <td>NC</td>\n",
       "      <td>28202.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2858</td>\n",
       "      <td>Carla</td>\n",
       "      <td>Harding</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Female</td>\n",
       "      <td>Youngstown</td>\n",
       "      <td>OH</td>\n",
       "      <td>44502.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3459</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Swanson</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Granger</td>\n",
       "      <td>IN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3585</td>\n",
       "      <td>Aminah</td>\n",
       "      <td>Zalim</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Ashburn</td>\n",
       "      <td>VA</td>\n",
       "      <td>20147.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5170</td>\n",
       "      <td>Gus</td>\n",
       "      <td>Cunningham</td>\n",
       "      <td>Finance</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Massillon</td>\n",
       "      <td>OH</td>\n",
       "      <td>44646.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5317</td>\n",
       "      <td>Rafael</td>\n",
       "      <td>Solis</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>South Bend</td>\n",
       "      <td>IN</td>\n",
       "      <td>46601.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>5336</td>\n",
       "      <td>Homer</td>\n",
       "      <td>White</td>\n",
       "      <td>Finance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Male</td>\n",
       "      <td>St. Paul</td>\n",
       "      <td>MN</td>\n",
       "      <td>55101.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5495</td>\n",
       "      <td>Lara</td>\n",
       "      <td>Woods</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dallas</td>\n",
       "      <td>TX</td>\n",
       "      <td>75201.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>6453</td>\n",
       "      <td>Otis</td>\n",
       "      <td>Johnson</td>\n",
       "      <td>Management</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Anchorage</td>\n",
       "      <td>AK</td>\n",
       "      <td>99501.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>6504</td>\n",
       "      <td>Chantelle</td>\n",
       "      <td>Woods</td>\n",
       "      <td>Business Technology</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>6768</td>\n",
       "      <td>Caroline</td>\n",
       "      <td>Marsh</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Niles</td>\n",
       "      <td>MI</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>7511</td>\n",
       "      <td>Laila</td>\n",
       "      <td>Carroll</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>New York</td>\n",
       "      <td>NY</td>\n",
       "      <td>10001.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>7965</td>\n",
       "      <td>Rocco</td>\n",
       "      <td>Decola</td>\n",
       "      <td>Finance</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Oakland</td>\n",
       "      <td>CA</td>\n",
       "      <td>94603.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>9232</td>\n",
       "      <td>Julie</td>\n",
       "      <td>Holmes</td>\n",
       "      <td>Business Technology</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Webster</td>\n",
       "      <td>NY</td>\n",
       "      <td>14580.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>9268</td>\n",
       "      <td>Albert</td>\n",
       "      <td>Palmer</td>\n",
       "      <td>Management</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Detroit</td>\n",
       "      <td>MI</td>\n",
       "      <td>48201.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>9941</td>\n",
       "      <td>Zoya</td>\n",
       "      <td>Doyle</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>IL</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      ID  FirstName    LastName                Major   Age  Gender  \\\n",
       "2   2075      Becca     Swanson            Marketing  22.0  Female   \n",
       "3   2228     Halima       Aminu   Business Analytics  20.0  Female   \n",
       "4   2442      Holly    Robinson              Finance  20.0  Female   \n",
       "5   2858      Carla     Harding          Accountancy   NaN  Female   \n",
       "6   3459       Alex     Swanson          Accountancy   NaN     NaN   \n",
       "7   3585     Aminah       Zalim            Marketing  20.0  Female   \n",
       "8   5170        Gus  Cunningham              Finance  21.0    Male   \n",
       "9   5317     Rafael       Solis   Business Analytics   NaN     NaN   \n",
       "10  5336      Homer       White              Finance   NaN    Male   \n",
       "11  5495       Lara       Woods          Accountancy   NaN     NaN   \n",
       "12  6453       Otis     Johnson           Management  19.0    Male   \n",
       "13  6504  Chantelle       Woods  Business Technology  18.0  Female   \n",
       "14  6768   Caroline       Marsh   Business Analytics  22.0  Female   \n",
       "15  7511      Laila     Carroll            Marketing  20.0  Female   \n",
       "16  7965      Rocco      Decola              Finance  21.0    Male   \n",
       "17  9232      Julie      Holmes  Business Technology  18.0  Female   \n",
       "18  9268     Albert      Palmer           Management  21.0    Male   \n",
       "19  9941       Zoya       Doyle   Business Analytics   NaN  Female   \n",
       "\n",
       "          City State      Zip  \n",
       "2      Chicago    IL  60608.0  \n",
       "3      Atlanta    GA  30303.0  \n",
       "4    Charlotte    NC  28202.0  \n",
       "5   Youngstown    OH  44502.0  \n",
       "6      Granger    IN      NaN  \n",
       "7      Ashburn    VA  20147.0  \n",
       "8    Massillon    OH  44646.0  \n",
       "9   South Bend    IN  46601.0  \n",
       "10    St. Paul    MN  55101.0  \n",
       "11      Dallas    TX  75201.0  \n",
       "12   Anchorage    AK  99501.0  \n",
       "13     Chicago   NaN  60608.0  \n",
       "14       Niles    MI      NaN  \n",
       "15    New York    NY  10001.0  \n",
       "16     Oakland    CA  94603.0  \n",
       "17     Webster    NY  14580.0  \n",
       "18     Detroit    MI  48201.0  \n",
       "19     Chicago    IL  60608.0  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "students = students.dropna(axis = 1, thresh = 10)\n",
    "students"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## How to Resolve Missing Values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>FirstName</th>\n",
       "      <th>LastName</th>\n",
       "      <th>Major</th>\n",
       "      <th>Age</th>\n",
       "      <th>Gender</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Zip</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2075</td>\n",
       "      <td>Becca</td>\n",
       "      <td>Swanson</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>IL</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2228</td>\n",
       "      <td>Halima</td>\n",
       "      <td>Aminu</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>GA</td>\n",
       "      <td>30303.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2442</td>\n",
       "      <td>Holly</td>\n",
       "      <td>Robinson</td>\n",
       "      <td>Finance</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Charlotte</td>\n",
       "      <td>NC</td>\n",
       "      <td>28202.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2858</td>\n",
       "      <td>Carla</td>\n",
       "      <td>Harding</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Female</td>\n",
       "      <td>Youngstown</td>\n",
       "      <td>OH</td>\n",
       "      <td>44502.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3459</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Swanson</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Female</td>\n",
       "      <td>Granger</td>\n",
       "      <td>IN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3585</td>\n",
       "      <td>Aminah</td>\n",
       "      <td>Zalim</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Ashburn</td>\n",
       "      <td>VA</td>\n",
       "      <td>20147.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5170</td>\n",
       "      <td>Gus</td>\n",
       "      <td>Cunningham</td>\n",
       "      <td>Finance</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Massillon</td>\n",
       "      <td>OH</td>\n",
       "      <td>44646.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5317</td>\n",
       "      <td>Rafael</td>\n",
       "      <td>Solis</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Female</td>\n",
       "      <td>South Bend</td>\n",
       "      <td>IN</td>\n",
       "      <td>46601.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>5336</td>\n",
       "      <td>Homer</td>\n",
       "      <td>White</td>\n",
       "      <td>Finance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Male</td>\n",
       "      <td>St. Paul</td>\n",
       "      <td>MN</td>\n",
       "      <td>55101.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5495</td>\n",
       "      <td>Lara</td>\n",
       "      <td>Woods</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Female</td>\n",
       "      <td>Dallas</td>\n",
       "      <td>TX</td>\n",
       "      <td>75201.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>6453</td>\n",
       "      <td>Otis</td>\n",
       "      <td>Johnson</td>\n",
       "      <td>Management</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Anchorage</td>\n",
       "      <td>AK</td>\n",
       "      <td>99501.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>6504</td>\n",
       "      <td>Chantelle</td>\n",
       "      <td>Woods</td>\n",
       "      <td>Business Technology</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>6768</td>\n",
       "      <td>Caroline</td>\n",
       "      <td>Marsh</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Niles</td>\n",
       "      <td>MI</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>7511</td>\n",
       "      <td>Laila</td>\n",
       "      <td>Carroll</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>New York</td>\n",
       "      <td>NY</td>\n",
       "      <td>10001.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>7965</td>\n",
       "      <td>Rocco</td>\n",
       "      <td>Decola</td>\n",
       "      <td>Finance</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Oakland</td>\n",
       "      <td>CA</td>\n",
       "      <td>94603.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>9232</td>\n",
       "      <td>Julie</td>\n",
       "      <td>Holmes</td>\n",
       "      <td>Business Technology</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Webster</td>\n",
       "      <td>NY</td>\n",
       "      <td>14580.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>9268</td>\n",
       "      <td>Albert</td>\n",
       "      <td>Palmer</td>\n",
       "      <td>Management</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Detroit</td>\n",
       "      <td>MI</td>\n",
       "      <td>48201.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>9941</td>\n",
       "      <td>Zoya</td>\n",
       "      <td>Doyle</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>IL</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      ID  FirstName    LastName                Major   Age  Gender  \\\n",
       "2   2075      Becca     Swanson            Marketing  22.0  Female   \n",
       "3   2228     Halima       Aminu   Business Analytics  20.0  Female   \n",
       "4   2442      Holly    Robinson              Finance  20.0  Female   \n",
       "5   2858      Carla     Harding          Accountancy   NaN  Female   \n",
       "6   3459       Alex     Swanson          Accountancy   NaN  Female   \n",
       "7   3585     Aminah       Zalim            Marketing  20.0  Female   \n",
       "8   5170        Gus  Cunningham              Finance  21.0    Male   \n",
       "9   5317     Rafael       Solis   Business Analytics   NaN  Female   \n",
       "10  5336      Homer       White              Finance   NaN    Male   \n",
       "11  5495       Lara       Woods          Accountancy   NaN  Female   \n",
       "12  6453       Otis     Johnson           Management  19.0    Male   \n",
       "13  6504  Chantelle       Woods  Business Technology  18.0  Female   \n",
       "14  6768   Caroline       Marsh   Business Analytics  22.0  Female   \n",
       "15  7511      Laila     Carroll            Marketing  20.0  Female   \n",
       "16  7965      Rocco      Decola              Finance  21.0    Male   \n",
       "17  9232      Julie      Holmes  Business Technology  18.0  Female   \n",
       "18  9268     Albert      Palmer           Management  21.0    Male   \n",
       "19  9941       Zoya       Doyle   Business Analytics   NaN  Female   \n",
       "\n",
       "          City State      Zip  \n",
       "2      Chicago    IL  60608.0  \n",
       "3      Atlanta    GA  30303.0  \n",
       "4    Charlotte    NC  28202.0  \n",
       "5   Youngstown    OH  44502.0  \n",
       "6      Granger    IN      NaN  \n",
       "7      Ashburn    VA  20147.0  \n",
       "8    Massillon    OH  44646.0  \n",
       "9   South Bend    IN  46601.0  \n",
       "10    St. Paul    MN  55101.0  \n",
       "11      Dallas    TX  75201.0  \n",
       "12   Anchorage    AK  99501.0  \n",
       "13     Chicago   NaN  60608.0  \n",
       "14       Niles    MI      NaN  \n",
       "15    New York    NY  10001.0  \n",
       "16     Oakland    CA  94603.0  \n",
       "17     Webster    NY  14580.0  \n",
       "18     Detroit    MI  48201.0  \n",
       "19     Chicago    IL  60608.0  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "students = students.fillna({'Gender': 'Female'})\n",
    "students"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>FirstName</th>\n",
       "      <th>LastName</th>\n",
       "      <th>Major</th>\n",
       "      <th>Age</th>\n",
       "      <th>Gender</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Zip</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2075</td>\n",
       "      <td>Becca</td>\n",
       "      <td>Swanson</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>IL</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2228</td>\n",
       "      <td>Halima</td>\n",
       "      <td>Aminu</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>GA</td>\n",
       "      <td>30303.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2442</td>\n",
       "      <td>Holly</td>\n",
       "      <td>Robinson</td>\n",
       "      <td>Finance</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Charlotte</td>\n",
       "      <td>NC</td>\n",
       "      <td>28202.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2858</td>\n",
       "      <td>Carla</td>\n",
       "      <td>Harding</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Youngstown</td>\n",
       "      <td>OH</td>\n",
       "      <td>44502.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3459</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Swanson</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Granger</td>\n",
       "      <td>IN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3585</td>\n",
       "      <td>Aminah</td>\n",
       "      <td>Zalim</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Ashburn</td>\n",
       "      <td>VA</td>\n",
       "      <td>20147.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5170</td>\n",
       "      <td>Gus</td>\n",
       "      <td>Cunningham</td>\n",
       "      <td>Finance</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Massillon</td>\n",
       "      <td>OH</td>\n",
       "      <td>44646.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5317</td>\n",
       "      <td>Rafael</td>\n",
       "      <td>Solis</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>South Bend</td>\n",
       "      <td>IN</td>\n",
       "      <td>46601.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>5336</td>\n",
       "      <td>Homer</td>\n",
       "      <td>White</td>\n",
       "      <td>Finance</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>St. Paul</td>\n",
       "      <td>MN</td>\n",
       "      <td>55101.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5495</td>\n",
       "      <td>Lara</td>\n",
       "      <td>Woods</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Dallas</td>\n",
       "      <td>TX</td>\n",
       "      <td>75201.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>6453</td>\n",
       "      <td>Otis</td>\n",
       "      <td>Johnson</td>\n",
       "      <td>Management</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Anchorage</td>\n",
       "      <td>AK</td>\n",
       "      <td>99501.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>6504</td>\n",
       "      <td>Chantelle</td>\n",
       "      <td>Woods</td>\n",
       "      <td>Business Technology</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>6768</td>\n",
       "      <td>Caroline</td>\n",
       "      <td>Marsh</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Niles</td>\n",
       "      <td>MI</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>7511</td>\n",
       "      <td>Laila</td>\n",
       "      <td>Carroll</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>New York</td>\n",
       "      <td>NY</td>\n",
       "      <td>10001.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>7965</td>\n",
       "      <td>Rocco</td>\n",
       "      <td>Decola</td>\n",
       "      <td>Finance</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Oakland</td>\n",
       "      <td>CA</td>\n",
       "      <td>94603.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>9232</td>\n",
       "      <td>Julie</td>\n",
       "      <td>Holmes</td>\n",
       "      <td>Business Technology</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Webster</td>\n",
       "      <td>NY</td>\n",
       "      <td>14580.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>9268</td>\n",
       "      <td>Albert</td>\n",
       "      <td>Palmer</td>\n",
       "      <td>Management</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Detroit</td>\n",
       "      <td>MI</td>\n",
       "      <td>48201.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>9941</td>\n",
       "      <td>Zoya</td>\n",
       "      <td>Doyle</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>IL</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      ID  FirstName    LastName                Major   Age  Gender  \\\n",
       "2   2075      Becca     Swanson            Marketing  22.0  Female   \n",
       "3   2228     Halima       Aminu   Business Analytics  20.0  Female   \n",
       "4   2442      Holly    Robinson              Finance  20.0  Female   \n",
       "5   2858      Carla     Harding          Accountancy  20.0  Female   \n",
       "6   3459       Alex     Swanson          Accountancy  20.0  Female   \n",
       "7   3585     Aminah       Zalim            Marketing  20.0  Female   \n",
       "8   5170        Gus  Cunningham              Finance  21.0    Male   \n",
       "9   5317     Rafael       Solis   Business Analytics  20.0  Female   \n",
       "10  5336      Homer       White              Finance  20.0    Male   \n",
       "11  5495       Lara       Woods          Accountancy  20.0  Female   \n",
       "12  6453       Otis     Johnson           Management  19.0    Male   \n",
       "13  6504  Chantelle       Woods  Business Technology  18.0  Female   \n",
       "14  6768   Caroline       Marsh   Business Analytics  22.0  Female   \n",
       "15  7511      Laila     Carroll            Marketing  20.0  Female   \n",
       "16  7965      Rocco      Decola              Finance  21.0    Male   \n",
       "17  9232      Julie      Holmes  Business Technology  18.0  Female   \n",
       "18  9268     Albert      Palmer           Management  21.0    Male   \n",
       "19  9941       Zoya       Doyle   Business Analytics  20.0  Female   \n",
       "\n",
       "          City State      Zip  \n",
       "2      Chicago    IL  60608.0  \n",
       "3      Atlanta    GA  30303.0  \n",
       "4    Charlotte    NC  28202.0  \n",
       "5   Youngstown    OH  44502.0  \n",
       "6      Granger    IN      NaN  \n",
       "7      Ashburn    VA  20147.0  \n",
       "8    Massillon    OH  44646.0  \n",
       "9   South Bend    IN  46601.0  \n",
       "10    St. Paul    MN  55101.0  \n",
       "11      Dallas    TX  75201.0  \n",
       "12   Anchorage    AK  99501.0  \n",
       "13     Chicago   NaN  60608.0  \n",
       "14       Niles    MI      NaN  \n",
       "15    New York    NY  10001.0  \n",
       "16     Oakland    CA  94603.0  \n",
       "17     Webster    NY  14580.0  \n",
       "18     Detroit    MI  48201.0  \n",
       "19     Chicago    IL  60608.0  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "students = students.fillna({'Age': students['Age'].median()})\n",
    "students"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2     False\n",
       "3     False\n",
       "4     False\n",
       "5     False\n",
       "6      True\n",
       "7     False\n",
       "8     False\n",
       "9     False\n",
       "10    False\n",
       "11    False\n",
       "12    False\n",
       "13    False\n",
       "14    False\n",
       "15    False\n",
       "16    False\n",
       "17    False\n",
       "18    False\n",
       "19    False\n",
       "dtype: bool"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mask = (students['City'] == 'Granger') & (students['State'] == 'IN')\n",
    "mask"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>FirstName</th>\n",
       "      <th>LastName</th>\n",
       "      <th>Major</th>\n",
       "      <th>Age</th>\n",
       "      <th>Gender</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Zip</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3459</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Swanson</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Granger</td>\n",
       "      <td>IN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     ID FirstName LastName        Major   Age  Gender     City State  Zip\n",
       "6  3459      Alex  Swanson  Accountancy  20.0  Female  Granger    IN  NaN"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "students.loc[mask,:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>FirstName</th>\n",
       "      <th>LastName</th>\n",
       "      <th>Major</th>\n",
       "      <th>Age</th>\n",
       "      <th>Gender</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Zip</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2075</td>\n",
       "      <td>Becca</td>\n",
       "      <td>Swanson</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>IL</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2228</td>\n",
       "      <td>Halima</td>\n",
       "      <td>Aminu</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>GA</td>\n",
       "      <td>30303.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2442</td>\n",
       "      <td>Holly</td>\n",
       "      <td>Robinson</td>\n",
       "      <td>Finance</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Charlotte</td>\n",
       "      <td>NC</td>\n",
       "      <td>28202.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2858</td>\n",
       "      <td>Carla</td>\n",
       "      <td>Harding</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Youngstown</td>\n",
       "      <td>OH</td>\n",
       "      <td>44502.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3459</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Swanson</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Granger</td>\n",
       "      <td>IN</td>\n",
       "      <td>46530.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3585</td>\n",
       "      <td>Aminah</td>\n",
       "      <td>Zalim</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Ashburn</td>\n",
       "      <td>VA</td>\n",
       "      <td>20147.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5170</td>\n",
       "      <td>Gus</td>\n",
       "      <td>Cunningham</td>\n",
       "      <td>Finance</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Massillon</td>\n",
       "      <td>OH</td>\n",
       "      <td>44646.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5317</td>\n",
       "      <td>Rafael</td>\n",
       "      <td>Solis</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>South Bend</td>\n",
       "      <td>IN</td>\n",
       "      <td>46601.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>5336</td>\n",
       "      <td>Homer</td>\n",
       "      <td>White</td>\n",
       "      <td>Finance</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>St. Paul</td>\n",
       "      <td>MN</td>\n",
       "      <td>55101.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5495</td>\n",
       "      <td>Lara</td>\n",
       "      <td>Woods</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Dallas</td>\n",
       "      <td>TX</td>\n",
       "      <td>75201.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>6453</td>\n",
       "      <td>Otis</td>\n",
       "      <td>Johnson</td>\n",
       "      <td>Management</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Anchorage</td>\n",
       "      <td>AK</td>\n",
       "      <td>99501.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>6504</td>\n",
       "      <td>Chantelle</td>\n",
       "      <td>Woods</td>\n",
       "      <td>Business Technology</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>6768</td>\n",
       "      <td>Caroline</td>\n",
       "      <td>Marsh</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Niles</td>\n",
       "      <td>MI</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>7511</td>\n",
       "      <td>Laila</td>\n",
       "      <td>Carroll</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>New York</td>\n",
       "      <td>NY</td>\n",
       "      <td>10001.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>7965</td>\n",
       "      <td>Rocco</td>\n",
       "      <td>Decola</td>\n",
       "      <td>Finance</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Oakland</td>\n",
       "      <td>CA</td>\n",
       "      <td>94603.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>9232</td>\n",
       "      <td>Julie</td>\n",
       "      <td>Holmes</td>\n",
       "      <td>Business Technology</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Webster</td>\n",
       "      <td>NY</td>\n",
       "      <td>14580.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>9268</td>\n",
       "      <td>Albert</td>\n",
       "      <td>Palmer</td>\n",
       "      <td>Management</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Detroit</td>\n",
       "      <td>MI</td>\n",
       "      <td>48201.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>9941</td>\n",
       "      <td>Zoya</td>\n",
       "      <td>Doyle</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>IL</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      ID  FirstName    LastName                Major   Age  Gender  \\\n",
       "2   2075      Becca     Swanson            Marketing  22.0  Female   \n",
       "3   2228     Halima       Aminu   Business Analytics  20.0  Female   \n",
       "4   2442      Holly    Robinson              Finance  20.0  Female   \n",
       "5   2858      Carla     Harding          Accountancy  20.0  Female   \n",
       "6   3459       Alex     Swanson          Accountancy  20.0  Female   \n",
       "7   3585     Aminah       Zalim            Marketing  20.0  Female   \n",
       "8   5170        Gus  Cunningham              Finance  21.0    Male   \n",
       "9   5317     Rafael       Solis   Business Analytics  20.0  Female   \n",
       "10  5336      Homer       White              Finance  20.0    Male   \n",
       "11  5495       Lara       Woods          Accountancy  20.0  Female   \n",
       "12  6453       Otis     Johnson           Management  19.0    Male   \n",
       "13  6504  Chantelle       Woods  Business Technology  18.0  Female   \n",
       "14  6768   Caroline       Marsh   Business Analytics  22.0  Female   \n",
       "15  7511      Laila     Carroll            Marketing  20.0  Female   \n",
       "16  7965      Rocco      Decola              Finance  21.0    Male   \n",
       "17  9232      Julie      Holmes  Business Technology  18.0  Female   \n",
       "18  9268     Albert      Palmer           Management  21.0    Male   \n",
       "19  9941       Zoya       Doyle   Business Analytics  20.0  Female   \n",
       "\n",
       "          City State      Zip  \n",
       "2      Chicago    IL  60608.0  \n",
       "3      Atlanta    GA  30303.0  \n",
       "4    Charlotte    NC  28202.0  \n",
       "5   Youngstown    OH  44502.0  \n",
       "6      Granger    IN  46530.0  \n",
       "7      Ashburn    VA  20147.0  \n",
       "8    Massillon    OH  44646.0  \n",
       "9   South Bend    IN  46601.0  \n",
       "10    St. Paul    MN  55101.0  \n",
       "11      Dallas    TX  75201.0  \n",
       "12   Anchorage    AK  99501.0  \n",
       "13     Chicago   NaN  60608.0  \n",
       "14       Niles    MI      NaN  \n",
       "15    New York    NY  10001.0  \n",
       "16     Oakland    CA  94603.0  \n",
       "17     Webster    NY  14580.0  \n",
       "18     Detroit    MI  48201.0  \n",
       "19     Chicago    IL  60608.0  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "students.loc[mask,'Zip'] = 46530\n",
    "students"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>FirstName</th>\n",
       "      <th>LastName</th>\n",
       "      <th>Major</th>\n",
       "      <th>Age</th>\n",
       "      <th>Gender</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Zip</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2075</td>\n",
       "      <td>Becca</td>\n",
       "      <td>Swanson</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>IL</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2228</td>\n",
       "      <td>Halima</td>\n",
       "      <td>Aminu</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Atlanta</td>\n",
       "      <td>GA</td>\n",
       "      <td>30303.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2442</td>\n",
       "      <td>Holly</td>\n",
       "      <td>Robinson</td>\n",
       "      <td>Finance</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Charlotte</td>\n",
       "      <td>NC</td>\n",
       "      <td>28202.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2858</td>\n",
       "      <td>Carla</td>\n",
       "      <td>Harding</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Youngstown</td>\n",
       "      <td>OH</td>\n",
       "      <td>44502.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3459</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Swanson</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Granger</td>\n",
       "      <td>IN</td>\n",
       "      <td>46530.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3585</td>\n",
       "      <td>Aminah</td>\n",
       "      <td>Zalim</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Ashburn</td>\n",
       "      <td>VA</td>\n",
       "      <td>20147.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5170</td>\n",
       "      <td>Gus</td>\n",
       "      <td>Cunningham</td>\n",
       "      <td>Finance</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Massillon</td>\n",
       "      <td>OH</td>\n",
       "      <td>44646.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5317</td>\n",
       "      <td>Rafael</td>\n",
       "      <td>Solis</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>South Bend</td>\n",
       "      <td>IN</td>\n",
       "      <td>46601.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>5336</td>\n",
       "      <td>Homer</td>\n",
       "      <td>White</td>\n",
       "      <td>Finance</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>St. Paul</td>\n",
       "      <td>MN</td>\n",
       "      <td>55101.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5495</td>\n",
       "      <td>Lara</td>\n",
       "      <td>Woods</td>\n",
       "      <td>Accountancy</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Dallas</td>\n",
       "      <td>TX</td>\n",
       "      <td>75201.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>6453</td>\n",
       "      <td>Otis</td>\n",
       "      <td>Johnson</td>\n",
       "      <td>Management</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Anchorage</td>\n",
       "      <td>AK</td>\n",
       "      <td>99501.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>6504</td>\n",
       "      <td>Chantelle</td>\n",
       "      <td>Woods</td>\n",
       "      <td>Business Technology</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>6768</td>\n",
       "      <td>Caroline</td>\n",
       "      <td>Marsh</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Niles</td>\n",
       "      <td>MI</td>\n",
       "      <td>49120.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>7511</td>\n",
       "      <td>Laila</td>\n",
       "      <td>Carroll</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>New York</td>\n",
       "      <td>NY</td>\n",
       "      <td>10001.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>7965</td>\n",
       "      <td>Rocco</td>\n",
       "      <td>Decola</td>\n",
       "      <td>Finance</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Oakland</td>\n",
       "      <td>CA</td>\n",
       "      <td>94603.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>9232</td>\n",
       "      <td>Julie</td>\n",
       "      <td>Holmes</td>\n",
       "      <td>Business Technology</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Webster</td>\n",
       "      <td>NY</td>\n",
       "      <td>14580.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>9268</td>\n",
       "      <td>Albert</td>\n",
       "      <td>Palmer</td>\n",
       "      <td>Management</td>\n",
       "      <td>21.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>Detroit</td>\n",
       "      <td>MI</td>\n",
       "      <td>48201.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>9941</td>\n",
       "      <td>Zoya</td>\n",
       "      <td>Doyle</td>\n",
       "      <td>Business Analytics</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>IL</td>\n",
       "      <td>60608.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      ID  FirstName    LastName                Major   Age  Gender  \\\n",
       "2   2075      Becca     Swanson            Marketing  22.0  Female   \n",
       "3   2228     Halima       Aminu   Business Analytics  20.0  Female   \n",
       "4   2442      Holly    Robinson              Finance  20.0  Female   \n",
       "5   2858      Carla     Harding          Accountancy  20.0  Female   \n",
       "6   3459       Alex     Swanson          Accountancy  20.0  Female   \n",
       "7   3585     Aminah       Zalim            Marketing  20.0  Female   \n",
       "8   5170        Gus  Cunningham              Finance  21.0    Male   \n",
       "9   5317     Rafael       Solis   Business Analytics  20.0  Female   \n",
       "10  5336      Homer       White              Finance  20.0    Male   \n",
       "11  5495       Lara       Woods          Accountancy  20.0  Female   \n",
       "12  6453       Otis     Johnson           Management  19.0    Male   \n",
       "13  6504  Chantelle       Woods  Business Technology  18.0  Female   \n",
       "14  6768   Caroline       Marsh   Business Analytics  22.0  Female   \n",
       "15  7511      Laila     Carroll            Marketing  20.0  Female   \n",
       "16  7965      Rocco      Decola              Finance  21.0    Male   \n",
       "17  9232      Julie      Holmes  Business Technology  18.0  Female   \n",
       "18  9268     Albert      Palmer           Management  21.0    Male   \n",
       "19  9941       Zoya       Doyle   Business Analytics  20.0  Female   \n",
       "\n",
       "          City State      Zip  \n",
       "2      Chicago    IL  60608.0  \n",
       "3      Atlanta    GA  30303.0  \n",
       "4    Charlotte    NC  28202.0  \n",
       "5   Youngstown    OH  44502.0  \n",
       "6      Granger    IN  46530.0  \n",
       "7      Ashburn    VA  20147.0  \n",
       "8    Massillon    OH  44646.0  \n",
       "9   South Bend    IN  46601.0  \n",
       "10    St. Paul    MN  55101.0  \n",
       "11      Dallas    TX  75201.0  \n",
       "12   Anchorage    AK  99501.0  \n",
       "13     Chicago   NaN  60608.0  \n",
       "14       Niles    MI  49120.0  \n",
       "15    New York    NY  10001.0  \n",
       "16     Oakland    CA  94603.0  \n",
       "17     Webster    NY  14580.0  \n",
       "18     Detroit    MI  48201.0  \n",
       "19     Chicago    IL  60608.0  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mask = (students['City'] == 'Niles') & (students['State'] == 'MI')\n",
    "students.loc[mask, 'Zip'] = 49120\n",
    "students"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "colab": {
   "collapsed_sections": [],
   "name": "3.3 - Pandas Data Selection.ipynb",
   "provenance": [],
   "toc_visible": true,
   "version": "0.3.2"
  },
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}