19.Missing Values.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### How to Replace Missing Values(NA) in R: na.omit & na.rm\n",
    "\n",
    "Missing values in data science arise when an observation is missing in a column of a data frame or contains a character value instead of numeric value. Missing values must be dropped or replaced in order to draw correct conclusion from the data.\n",
    "\n",
    "In this tutorial, we will learn how to deal with missing values with the dplyr library. dplyr library is part of an ecosystem to realize a data analysis.\n",
    "![](https://lh3.googleusercontent.com/-IGSi-Cv9-TQ/XcFOZ8l0HtI/AAAAAAAAkR0/DlVV1yrh1h8kQ1AyZ64E6GDG6hLT3FjdwCK8BGAsYHg/s0/2019-11-05.png)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "* mutate()\n",
    "* Exclude Missing Values (NA)\n",
    "* Impute Missing Values (NA) with the Mean and Median\n",
    "\n",
    "**mutate()**:\n",
    "\n",
    "The fourth verb in the dplyr library is helpful to create new variable or change the values of an existing variable.\n",
    "\n",
    "We will proceed in two parts. We will learn how to:\n",
    "\n",
    "* exclude missing values from a data frame\n",
    "* impute missing values with the mean and median\n",
    "\n",
    "The verb mutate() is very easy to use. We can create a new variable following this syntax:"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "mutate(df, name_variable_1 = condition, ...)\n",
    "arguments:\n",
    "-df: Data frame used to create a new variable\n",
    "-name_variable_1: Name and the formula to create the new variable\n",
    "-...: No limit constraint. Possibility to create more than one variable inside mutate()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Exclude Missing Values (NA)**\n",
    "The na.omit() method from the dplyr library is a simple way to exclude missing observation. Dropping all the NA from the data is easy but it does not mean it is the most elegant solution. During analysis, it is wise to use variety of methods to deal with missing values\n",
    "\n",
    "To tackle the problem of missing observations, we will use the titanic dataset. In this dataset, we have access to the information of the passengers on board during the tragedy. This dataset has many NA that need to be taken care of.\n",
    "\n",
    "We will upload the csv file from the internet and then check which columns have NA. To return the columns with missing data, we can use the following code:\n",
    "\n",
    "Let's upload the data and verify the missing data."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<table>\n",
       "<thead><tr><th scope=col>PassengerId</th><th scope=col>Pclass</th><th scope=col>Name</th><th scope=col>Sex</th><th scope=col>Age</th><th scope=col>SibSp</th><th scope=col>Parch</th><th scope=col>Ticket</th><th scope=col>Fare</th><th scope=col>Cabin</th><th scope=col>Embarked</th></tr></thead>\n",
       "<tbody>\n",
       "\t<tr><td>892                                         </td><td>3                                           </td><td>Kelly, Mr. James                            </td><td>male                                        </td><td>34.5                                        </td><td>0                                           </td><td>0                                           </td><td>330911                                      </td><td> 7.8292                                     </td><td>                                            </td><td>Q                                           </td></tr>\n",
       "\t<tr><td>893                                         </td><td>3                                           </td><td>Wilkes, Mrs. James (Ellen Needs)            </td><td>female                                      </td><td>47.0                                        </td><td>1                                           </td><td>0                                           </td><td>363272                                      </td><td> 7.0000                                     </td><td>                                            </td><td>S                                           </td></tr>\n",
       "\t<tr><td>894                                         </td><td>2                                           </td><td>Myles, Mr. Thomas Francis                   </td><td>male                                        </td><td>62.0                                        </td><td>0                                           </td><td>0                                           </td><td>240276                                      </td><td> 9.6875                                     </td><td>                                            </td><td>Q                                           </td></tr>\n",
       "\t<tr><td>895                                         </td><td>3                                           </td><td>Wirz, Mr. Albert                            </td><td>male                                        </td><td>27.0                                        </td><td>0                                           </td><td>0                                           </td><td>315154                                      </td><td> 8.6625                                     </td><td>                                            </td><td>S                                           </td></tr>\n",
       "\t<tr><td>896                                         </td><td>3                                           </td><td>Hirvonen, Mrs. Alexander (Helga E Lindqvist)</td><td>female                                      </td><td>22.0                                        </td><td>1                                           </td><td>1                                           </td><td>3101298                                     </td><td>12.2875                                     </td><td>                                            </td><td>S                                           </td></tr>\n",
       "\t<tr><td>897                                         </td><td>3                                           </td><td>Svensson, Mr. Johan Cervin                  </td><td>male                                        </td><td>14.0                                        </td><td>0                                           </td><td>0                                           </td><td>7538                                        </td><td> 9.2250                                     </td><td>                                            </td><td>S                                           </td></tr>\n",
       "</tbody>\n",
       "</table>\n"
      ],
      "text/latex": [
       "\\begin{tabular}{r|lllllllllll}\n",
       " PassengerId & Pclass & Name & Sex & Age & SibSp & Parch & Ticket & Fare & Cabin & Embarked\\\\\n",
       "\\hline\n",
       "\t 892                                          & 3                                            & Kelly, Mr. James                             & male                                         & 34.5                                         & 0                                            & 0                                            & 330911                                       &  7.8292                                      &                                              & Q                                           \\\\\n",
       "\t 893                                          & 3                                            & Wilkes, Mrs. James (Ellen Needs)             & female                                       & 47.0                                         & 1                                            & 0                                            & 363272                                       &  7.0000                                      &                                              & S                                           \\\\\n",
       "\t 894                                          & 2                                            & Myles, Mr. Thomas Francis                    & male                                         & 62.0                                         & 0                                            & 0                                            & 240276                                       &  9.6875                                      &                                              & Q                                           \\\\\n",
       "\t 895                                          & 3                                            & Wirz, Mr. Albert                             & male                                         & 27.0                                         & 0                                            & 0                                            & 315154                                       &  8.6625                                      &                                              & S                                           \\\\\n",
       "\t 896                                          & 3                                            & Hirvonen, Mrs. Alexander (Helga E Lindqvist) & female                                       & 22.0                                         & 1                                            & 1                                            & 3101298                                      & 12.2875                                      &                                              & S                                           \\\\\n",
       "\t 897                                          & 3                                            & Svensson, Mr. Johan Cervin                   & male                                         & 14.0                                         & 0                                            & 0                                            & 7538                                         &  9.2250                                      &                                              & S                                           \\\\\n",
       "\\end{tabular}\n"
      ],
      "text/markdown": [
       "\n",
       "| PassengerId | Pclass | Name | Sex | Age | SibSp | Parch | Ticket | Fare | Cabin | Embarked |\n",
       "|---|---|---|---|---|---|---|---|---|---|---|\n",
       "| 892                                          | 3                                            | Kelly, Mr. James                             | male                                         | 34.5                                         | 0                                            | 0                                            | 330911                                       |  7.8292                                      |                                              | Q                                            |\n",
       "| 893                                          | 3                                            | Wilkes, Mrs. James (Ellen Needs)             | female                                       | 47.0                                         | 1                                            | 0                                            | 363272                                       |  7.0000                                      |                                              | S                                            |\n",
       "| 894                                          | 2                                            | Myles, Mr. Thomas Francis                    | male                                         | 62.0                                         | 0                                            | 0                                            | 240276                                       |  9.6875                                      |                                              | Q                                            |\n",
       "| 895                                          | 3                                            | Wirz, Mr. Albert                             | male                                         | 27.0                                         | 0                                            | 0                                            | 315154                                       |  8.6625                                      |                                              | S                                            |\n",
       "| 896                                          | 3                                            | Hirvonen, Mrs. Alexander (Helga E Lindqvist) | female                                       | 22.0                                         | 1                                            | 1                                            | 3101298                                      | 12.2875                                      |                                              | S                                            |\n",
       "| 897                                          | 3                                            | Svensson, Mr. Johan Cervin                   | male                                         | 14.0                                         | 0                                            | 0                                            | 7538                                         |  9.2250                                      |                                              | S                                            |\n",
       "\n"
      ],
      "text/plain": [
       "  PassengerId Pclass Name                                         Sex    Age \n",
       "1 892         3      Kelly, Mr. James                             male   34.5\n",
       "2 893         3      Wilkes, Mrs. James (Ellen Needs)             female 47.0\n",
       "3 894         2      Myles, Mr. Thomas Francis                    male   62.0\n",
       "4 895         3      Wirz, Mr. Albert                             male   27.0\n",
       "5 896         3      Hirvonen, Mrs. Alexander (Helga E Lindqvist) female 22.0\n",
       "6 897         3      Svensson, Mr. Johan Cervin                   male   14.0\n",
       "  SibSp Parch Ticket  Fare    Cabin Embarked\n",
       "1 0     0     330911   7.8292       Q       \n",
       "2 1     0     363272   7.0000       S       \n",
       "3 0     0     240276   9.6875       Q       \n",
       "4 0     0     315154   8.6625       S       \n",
       "5 1     1     3101298 12.2875       S       \n",
       "6 0     0     7538     9.2250       S       "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "PATH <- \"DataSets//test.csv\"\n",
    "df_titanic <- read.csv(PATH, sep = \",\")\n",
    "head(df_titanic)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<table>\n",
       "<thead><tr><th></th><th scope=col>PassengerId</th><th scope=col>Pclass</th><th scope=col>Name</th><th scope=col>Sex</th><th scope=col>Age</th><th scope=col>SibSp</th><th scope=col>Parch</th><th scope=col>Ticket</th><th scope=col>Fare</th><th scope=col>Cabin</th><th scope=col>Embarked</th></tr></thead>\n",
       "<tbody>\n",
       "\t<tr><th scope=row>413</th><td>1304                          </td><td>3                             </td><td>Henriksson, Miss. Jenny Lovisa</td><td>female                        </td><td>28.0                          </td><td>0                             </td><td>0                             </td><td>347086                        </td><td>  7.7750                      </td><td>                              </td><td>S                             </td></tr>\n",
       "\t<tr><th scope=row>414</th><td>1305                          </td><td>3                             </td><td>Spector, Mr. Woolf            </td><td>male                          </td><td>  NA                          </td><td>0                             </td><td>0                             </td><td>A.5. 3236                     </td><td>  8.0500                      </td><td>                              </td><td>S                             </td></tr>\n",
       "\t<tr><th scope=row>415</th><td>1306                          </td><td>1                             </td><td>Oliva y Ocana, Dona. Fermina  </td><td>female                        </td><td>39.0                          </td><td>0                             </td><td>0                             </td><td>PC 17758                      </td><td>108.9000                      </td><td>C105                          </td><td>C                             </td></tr>\n",
       "\t<tr><th scope=row>416</th><td>1307                          </td><td>3                             </td><td>Saether, Mr. Simon Sivertsen  </td><td>male                          </td><td>38.5                          </td><td>0                             </td><td>0                             </td><td>SOTON/O.Q. 3101262            </td><td>  7.2500                      </td><td>                              </td><td>S                             </td></tr>\n",
       "\t<tr><th scope=row>417</th><td>1308                          </td><td>3                             </td><td>Ware, Mr. Frederick           </td><td>male                          </td><td>  NA                          </td><td>0                             </td><td>0                             </td><td>359309                        </td><td>  8.0500                      </td><td>                              </td><td>S                             </td></tr>\n",
       "\t<tr><th scope=row>418</th><td>1309                          </td><td>3                             </td><td>Peter, Master. Michael J      </td><td>male                          </td><td>  NA                          </td><td>1                             </td><td>1                             </td><td>2668                          </td><td> 22.3583                      </td><td>                              </td><td>C                             </td></tr>\n",
       "</tbody>\n",
       "</table>\n"
      ],
      "text/latex": [
       "\\begin{tabular}{r|lllllllllll}\n",
       "  & PassengerId & Pclass & Name & Sex & Age & SibSp & Parch & Ticket & Fare & Cabin & Embarked\\\\\n",
       "\\hline\n",
       "\t413 & 1304                           & 3                              & Henriksson, Miss. Jenny Lovisa & female                         & 28.0                           & 0                              & 0                              & 347086                         &   7.7750                       &                                & S                             \\\\\n",
       "\t414 & 1305                           & 3                              & Spector, Mr. Woolf             & male                           &   NA                           & 0                              & 0                              & A.5. 3236                      &   8.0500                       &                                & S                             \\\\\n",
       "\t415 & 1306                           & 1                              & Oliva y Ocana, Dona. Fermina   & female                         & 39.0                           & 0                              & 0                              & PC 17758                       & 108.9000                       & C105                           & C                             \\\\\n",
       "\t416 & 1307                           & 3                              & Saether, Mr. Simon Sivertsen   & male                           & 38.5                           & 0                              & 0                              & SOTON/O.Q. 3101262             &   7.2500                       &                                & S                             \\\\\n",
       "\t417 & 1308                           & 3                              & Ware, Mr. Frederick            & male                           &   NA                           & 0                              & 0                              & 359309                         &   8.0500                       &                                & S                             \\\\\n",
       "\t418 & 1309                           & 3                              & Peter, Master. Michael J       & male                           &   NA                           & 1                              & 1                              & 2668                           &  22.3583                       &                                & C                             \\\\\n",
       "\\end{tabular}\n"
      ],
      "text/markdown": [
       "\n",
       "| <!--/--> | PassengerId | Pclass | Name | Sex | Age | SibSp | Parch | Ticket | Fare | Cabin | Embarked |\n",
       "|---|---|---|---|---|---|---|---|---|---|---|---|\n",
       "| 413 | 1304                           | 3                              | Henriksson, Miss. Jenny Lovisa | female                         | 28.0                           | 0                              | 0                              | 347086                         |   7.7750                       |                                | S                              |\n",
       "| 414 | 1305                           | 3                              | Spector, Mr. Woolf             | male                           |   NA                           | 0                              | 0                              | A.5. 3236                      |   8.0500                       |                                | S                              |\n",
       "| 415 | 1306                           | 1                              | Oliva y Ocana, Dona. Fermina   | female                         | 39.0                           | 0                              | 0                              | PC 17758                       | 108.9000                       | C105                           | C                              |\n",
       "| 416 | 1307                           | 3                              | Saether, Mr. Simon Sivertsen   | male                           | 38.5                           | 0                              | 0                              | SOTON/O.Q. 3101262             |   7.2500                       |                                | S                              |\n",
       "| 417 | 1308                           | 3                              | Ware, Mr. Frederick            | male                           |   NA                           | 0                              | 0                              | 359309                         |   8.0500                       |                                | S                              |\n",
       "| 418 | 1309                           | 3                              | Peter, Master. Michael J       | male                           |   NA                           | 1                              | 1                              | 2668                           |  22.3583                       |                                | C                              |\n",
       "\n"
      ],
      "text/plain": [
       "    PassengerId Pclass Name                           Sex    Age  SibSp Parch\n",
       "413 1304        3      Henriksson, Miss. Jenny Lovisa female 28.0 0     0    \n",
       "414 1305        3      Spector, Mr. Woolf             male     NA 0     0    \n",
       "415 1306        1      Oliva y Ocana, Dona. Fermina   female 39.0 0     0    \n",
       "416 1307        3      Saether, Mr. Simon Sivertsen   male   38.5 0     0    \n",
       "417 1308        3      Ware, Mr. Frederick            male     NA 0     0    \n",
       "418 1309        3      Peter, Master. Michael J       male     NA 1     1    \n",
       "    Ticket             Fare     Cabin Embarked\n",
       "413 347086               7.7750       S       \n",
       "414 A.5. 3236            8.0500       S       \n",
       "415 PC 17758           108.9000 C105  C       \n",
       "416 SOTON/O.Q. 3101262   7.2500       S       \n",
       "417 359309               8.0500       S       \n",
       "418 2668                22.3583       C       "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "tail(df_titanic)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "  PassengerId         Pclass     \n",
       " Min.   : 892.0   Min.   :1.000  \n",
       " 1st Qu.: 996.2   1st Qu.:1.000  \n",
       " Median :1100.5   Median :3.000  \n",
       " Mean   :1100.5   Mean   :2.266  \n",
       " 3rd Qu.:1204.8   3rd Qu.:3.000  \n",
       " Max.   :1309.0   Max.   :3.000  \n",
       "                                 \n",
       "                                        Name         Sex           Age       \n",
       " Abbott, Master. Eugene Joseph            :  1   female:152   Min.   : 0.17  \n",
       " Abelseth, Miss. Karen Marie              :  1   male  :266   1st Qu.:21.00  \n",
       " Abelseth, Mr. Olaus Jorgensen            :  1                Median :27.00  \n",
       " Abrahamsson, Mr. Abraham August Johannes :  1                Mean   :30.27  \n",
       " Abrahim, Mrs. Joseph (Sophie Halaut Easu):  1                3rd Qu.:39.00  \n",
       " Aks, Master. Philip Frank                :  1                Max.   :76.00  \n",
       " (Other)                                  :412                NA's   :86     \n",
       "     SibSp            Parch             Ticket         Fare        \n",
       " Min.   :0.0000   Min.   :0.0000   PC 17608:  5   Min.   :  0.000  \n",
       " 1st Qu.:0.0000   1st Qu.:0.0000   113503  :  4   1st Qu.:  7.896  \n",
       " Median :0.0000   Median :0.0000   CA. 2343:  4   Median : 14.454  \n",
       " Mean   :0.4474   Mean   :0.3923   16966   :  3   Mean   : 35.627  \n",
       " 3rd Qu.:1.0000   3rd Qu.:0.0000   220845  :  3   3rd Qu.: 31.500  \n",
       " Max.   :8.0000   Max.   :9.0000   347077  :  3   Max.   :512.329  \n",
       "                                   (Other) :396   NA's   :1        \n",
       "             Cabin     Embarked\n",
       "                :327   C:102   \n",
       " B57 B59 B63 B66:  3   Q: 46   \n",
       " A34            :  2   S:270   \n",
       " B45            :  2           \n",
       " C101           :  2           \n",
       " C116           :  2           \n",
       " (Other)        : 80           "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "summary(df_titanic)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<ol class=list-inline>\n",
       "\t<li>'Age'</li>\n",
       "\t<li>'Fare'</li>\n",
       "</ol>\n"
      ],
      "text/latex": [
       "\\begin{enumerate*}\n",
       "\\item 'Age'\n",
       "\\item 'Fare'\n",
       "\\end{enumerate*}\n"
      ],
      "text/markdown": [
       "1. 'Age'\n",
       "2. 'Fare'\n",
       "\n",
       "\n"
      ],
      "text/plain": [
       "[1] \"Age\"  \"Fare\""
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Return the column names containing missing observations\n",
    "list_na <- colnames(df_titanic)[ apply(df_titanic, 2, anyNA) ]\n",
    "list_na"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<ol class=list-inline>\n",
       "\t<li>'Age'</li>\n",
       "\t<li>'Fare'</li>\n",
       "</ol>\n"
      ],
      "text/latex": [
       "\\begin{enumerate*}\n",
       "\\item 'Age'\n",
       "\\item 'Fare'\n",
       "\\end{enumerate*}\n"
      ],
      "text/markdown": [
       "1. 'Age'\n",
       "2. 'Fare'\n",
       "\n",
       "\n"
      ],
      "text/plain": [
       "[1] \"Age\"  \"Fare\""
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "colnames(df_titanic)[apply(df_titanic, 2, anyNA)]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Gives the name of columns that do not have data.The columns age and fare have missing values. We can drop them with the na.omit()."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "require(dplyr)\n",
    "library(dplyr)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<ol class=list-inline>\n",
       "\t<li>418</li>\n",
       "\t<li>11</li>\n",
       "</ol>\n"
      ],
      "text/latex": [
       "\\begin{enumerate*}\n",
       "\\item 418\n",
       "\\item 11\n",
       "\\end{enumerate*}\n"
      ],
      "text/markdown": [
       "1. 418\n",
       "2. 11\n",
       "\n",
       "\n"
      ],
      "text/plain": [
       "[1] 418  11"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "dim(df_titanic)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<ol class=list-inline>\n",
       "\t<li>331</li>\n",
       "\t<li>11</li>\n",
       "</ol>\n"
      ],
      "text/latex": [
       "\\begin{enumerate*}\n",
       "\\item 331\n",
       "\\item 11\n",
       "\\end{enumerate*}\n"
      ],
      "text/markdown": [
       "1. 331\n",
       "2. 11\n",
       "\n",
       "\n"
      ],
      "text/plain": [
       "[1] 331  11"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Exclude the missing observations\n",
    "df_titanic_drop <-df_titanic %>%\n",
    "na.omit()\n",
    "dim(df_titanic_drop)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Impute Missing data with the Mean and Median\n",
    "\n",
    "We could also impute(populate) missing values with the median or the mean. A good practice is to create two separate variables for the mean and the median. Once created, we can replace the missing values with the newly formed variables.\n",
    "We will use the apply method to compute the mean of the column with NA. Let's see an example\n",
    "\n",
    "**Step 1)** Earlier in the tutorial, we stored the columns name with the missing values in the list called list_na. We will use this list\n",
    "\n",
    "**Step 2)** Now we need to compute of the mean with the argument na.rm = TRUE. This argument is compulsory because the columns have missing data, and this tells R to ignore them."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<dl class=dl-horizontal>\n",
       "\t<dt>Age</dt>\n",
       "\t\t<dd>30.2725903614458</dd>\n",
       "\t<dt>Fare</dt>\n",
       "\t\t<dd>35.6271884892086</dd>\n",
       "</dl>\n"
      ],
      "text/latex": [
       "\\begin{description*}\n",
       "\\item[Age] 30.2725903614458\n",
       "\\item[Fare] 35.6271884892086\n",
       "\\end{description*}\n"
      ],
      "text/markdown": [
       "Age\n",
       ":   30.2725903614458Fare\n",
       ":   35.6271884892086\n",
       "\n"
      ],
      "text/plain": [
       "     Age     Fare \n",
       "30.27259 35.62719 "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Create mean\n",
    "average_missing <- apply(df_titanic[,colnames(df_titanic) %in% list_na],\n",
    "      2,\n",
    "      mean,\n",
    "      na.rm =  TRUE)\n",
    "average_missing"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Code Explanation:**\n",
    "\n",
    "We pass 4 arguments in the apply method.\n",
    "\n",
    "**df:** df_titanic[,colnames(df_titanic) %in% list_na]. This code will return the columns name from the list_na object (i.e. \"age\" and \"fare\")\n",
    "\n",
    "**2:** Compute the function on the columns\n",
    "\n",
    "**mean:** Compute the mean\n",
    "\n",
    "* na.rm = TRUE: Ignore the missing values\n",
    "\n",
    "We successfully created the mean of the columns containing missing observations. These two values will be used to replace the missing observations.\n",
    "\n",
    "**Step 3) Replace the NA Values**\n",
    "\n",
    "The verb mutate from the dplyr library is useful in creating a new variable. We don't necessarily want to change the original column so we can create a new variable without the NA. mutate is easy to use, we just choose a variable name and define how to create this variable. Here is the complete code"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_titanic_replace <- df_titanic %>%\n",
    "   mutate(replace_mean_age  = ifelse(is.na(Age), average_missing[1], Age),\n",
    "   replace_mean_fare = ifelse(is.na(Fare), average_missing[2], Fare))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<table>\n",
       "<thead><tr><th scope=col>PassengerId</th><th scope=col>Pclass</th><th scope=col>Name</th><th scope=col>Sex</th><th scope=col>Age</th><th scope=col>SibSp</th><th scope=col>Parch</th><th scope=col>Ticket</th><th scope=col>Fare</th><th scope=col>Cabin</th><th scope=col>Embarked</th><th scope=col>replace_mean_age</th><th scope=col>replace_mean_fare</th></tr></thead>\n",
       "<tbody>\n",
       "\t<tr><td>892                                                    </td><td>3                                                      </td><td>Kelly, Mr. James                                       </td><td>male                                                   </td><td>34.5                                                   </td><td>0                                                      </td><td>0                                                      </td><td>330911                                                 </td><td>  7.8292                                               </td><td>                                                       </td><td>Q                                                      </td><td>34.50000                                               </td><td>  7.8292                                               </td></tr>\n",
       "\t<tr><td>893                                                    </td><td>3                                                      </td><td>Wilkes, Mrs. James (Ellen Needs)                       </td><td>female                                                 </td><td>47.0                                                   </td><td>1                                                      </td><td>0                                                      </td><td>363272                                                 </td><td>  7.0000                                               </td><td>                                                       </td><td>S                                                      </td><td>47.00000                                               </td><td>  7.0000                                               </td></tr>\n",
       "\t<tr><td>894                                                    </td><td>2                                                      </td><td>Myles, Mr. Thomas Francis                              </td><td>male                                                   </td><td>62.0                                                   </td><td>0                                                      </td><td>0                                                      </td><td>240276                                                 </td><td>  9.6875                                               </td><td>                                                       </td><td>Q                                                      </td><td>62.00000                                               </td><td>  9.6875                                               </td></tr>\n",
       "\t<tr><td>895                                                    </td><td>3                                                      </td><td>Wirz, Mr. Albert                                       </td><td>male                                                   </td><td>27.0                                                   </td><td>0                                                      </td><td>0                                                      </td><td>315154                                                 </td><td>  8.6625                                               </td><td>                                                       </td><td>S                                                      </td><td>27.00000                                               </td><td>  8.6625                                               </td></tr>\n",
       "\t<tr><td>896                                                    </td><td>3                                                      </td><td>Hirvonen, Mrs. Alexander (Helga E Lindqvist)           </td><td>female                                                 </td><td>22.0                                                   </td><td>1                                                      </td><td>1                                                      </td><td>3101298                                                </td><td> 12.2875                                               </td><td>                                                       </td><td>S                                                      </td><td>22.00000                                               </td><td> 12.2875                                               </td></tr>\n",
       "\t<tr><td>897                                                    </td><td>3                                                      </td><td>Svensson, Mr. Johan Cervin                             </td><td>male                                                   </td><td>14.0                                                   </td><td>0                                                      </td><td>0                                                      </td><td>7538                                                   </td><td>  9.2250                                               </td><td>                                                       </td><td>S                                                      </td><td>14.00000                                               </td><td>  9.2250                                               </td></tr>\n",
       "\t<tr><td>898                                                    </td><td>3                                                      </td><td>Connolly, Miss. Kate                                   </td><td>female                                                 </td><td>30.0                                                   </td><td>0                                                      </td><td>0                                                      </td><td>330972                                                 </td><td>  7.6292                                               </td><td>                                                       </td><td>Q                                                      </td><td>30.00000                                               </td><td>  7.6292                                               </td></tr>\n",
       "\t<tr><td>899                                                    </td><td>2                                                      </td><td>Caldwell, Mr. Albert Francis                           </td><td>male                                                   </td><td>26.0                                                   </td><td>1                                                      </td><td>1                                                      </td><td>248738                                                 </td><td> 29.0000                                               </td><td>                                                       </td><td>S                                                      </td><td>26.00000                                               </td><td> 29.0000                                               </td></tr>\n",
       "\t<tr><td>900                                                    </td><td>3                                                      </td><td>Abrahim, Mrs. Joseph (Sophie Halaut Easu)              </td><td>female                                                 </td><td>18.0                                                   </td><td>0                                                      </td><td>0                                                      </td><td>2657                                                   </td><td>  7.2292                                               </td><td>                                                       </td><td>C                                                      </td><td>18.00000                                               </td><td>  7.2292                                               </td></tr>\n",
       "\t<tr><td>901                                                    </td><td>3                                                      </td><td>Davies, Mr. John Samuel                                </td><td>male                                                   </td><td>21.0                                                   </td><td>2                                                      </td><td>0                                                      </td><td>A/4 48871                                              </td><td> 24.1500                                               </td><td>                                                       </td><td>S                                                      </td><td>21.00000                                               </td><td> 24.1500                                               </td></tr>\n",
       "\t<tr><td>902                                                    </td><td>3                                                      </td><td>Ilieff, Mr. Ylio                                       </td><td>male                                                   </td><td>  NA                                                   </td><td>0                                                      </td><td>0                                                      </td><td>349220                                                 </td><td>  7.8958                                               </td><td>                                                       </td><td>S                                                      </td><td>30.27259                                               </td><td>  7.8958                                               </td></tr>\n",
       "\t<tr><td>903                                                    </td><td>1                                                      </td><td>Jones, Mr. Charles Cresson                             </td><td>male                                                   </td><td>46.0                                                   </td><td>0                                                      </td><td>0                                                      </td><td>694                                                    </td><td> 26.0000                                               </td><td>                                                       </td><td>S                                                      </td><td>46.00000                                               </td><td> 26.0000                                               </td></tr>\n",
       "\t<tr><td>904                                                    </td><td>1                                                      </td><td>Snyder, Mrs. John Pillsbury (Nelle Stevenson)          </td><td>female                                                 </td><td>23.0                                                   </td><td>1                                                      </td><td>0                                                      </td><td>21228                                                  </td><td> 82.2667                                               </td><td>B45                                                    </td><td>S                                                      </td><td>23.00000                                               </td><td> 82.2667                                               </td></tr>\n",
       "\t<tr><td>905                                                    </td><td>2                                                      </td><td>Howard, Mr. Benjamin                                   </td><td>male                                                   </td><td>63.0                                                   </td><td>1                                                      </td><td>0                                                      </td><td>24065                                                  </td><td> 26.0000                                               </td><td>                                                       </td><td>S                                                      </td><td>63.00000                                               </td><td> 26.0000                                               </td></tr>\n",
       "\t<tr><td>906                                                    </td><td>1                                                      </td><td>Chaffee, Mrs. Herbert Fuller (Carrie Constance Toogood)</td><td>female                                                 </td><td>47.0                                                   </td><td>1                                                      </td><td>0                                                      </td><td>W.E.P. 5734                                            </td><td> 61.1750                                               </td><td>E31                                                    </td><td>S                                                      </td><td>47.00000                                               </td><td> 61.1750                                               </td></tr>\n",
       "\t<tr><td>907                                                    </td><td>2                                                      </td><td>del Carlo, Mrs. Sebastiano (Argenia Genovesi)          </td><td>female                                                 </td><td>24.0                                                   </td><td>1                                                      </td><td>0                                                      </td><td>SC/PARIS 2167                                          </td><td> 27.7208                                               </td><td>                                                       </td><td>C                                                      </td><td>24.00000                                               </td><td> 27.7208                                               </td></tr>\n",
       "\t<tr><td>908                                                    </td><td>2                                                      </td><td>Keane, Mr. Daniel                                      </td><td>male                                                   </td><td>35.0                                                   </td><td>0                                                      </td><td>0                                                      </td><td>233734                                                 </td><td> 12.3500                                               </td><td>                                                       </td><td>Q                                                      </td><td>35.00000                                               </td><td> 12.3500                                               </td></tr>\n",
       "\t<tr><td>909                                                    </td><td>3                                                      </td><td>Assaf, Mr. Gerios                                      </td><td>male                                                   </td><td>21.0                                                   </td><td>0                                                      </td><td>0                                                      </td><td>2692                                                   </td><td>  7.2250                                               </td><td>                                                       </td><td>C                                                      </td><td>21.00000                                               </td><td>  7.2250                                               </td></tr>\n",
       "\t<tr><td>910                                                    </td><td>3                                                      </td><td>Ilmakangas, Miss. Ida Livija                           </td><td>female                                                 </td><td>27.0                                                   </td><td>1                                                      </td><td>0                                                      </td><td>STON/O2. 3101270                                       </td><td>  7.9250                                               </td><td>                                                       </td><td>S                                                      </td><td>27.00000                                               </td><td>  7.9250                                               </td></tr>\n",
       "\t<tr><td>911                                                    </td><td>3                                                      </td><td>Assaf Khalil, Mrs. Mariana (Miriam\")\"                  </td><td>female                                                 </td><td>45.0                                                   </td><td>0                                                      </td><td>0                                                      </td><td>2696                                                   </td><td>  7.2250                                               </td><td>                                                       </td><td>C                                                      </td><td>45.00000                                               </td><td>  7.2250                                               </td></tr>\n",
       "\t<tr><td>912                                                    </td><td>1                                                      </td><td>Rothschild, Mr. Martin                                 </td><td>male                                                   </td><td>55.0                                                   </td><td>1                                                      </td><td>0                                                      </td><td>PC 17603                                               </td><td> 59.4000                                               </td><td>                                                       </td><td>C                                                      </td><td>55.00000                                               </td><td> 59.4000                                               </td></tr>\n",
       "\t<tr><td>913                                                    </td><td>3                                                      </td><td>Olsen, Master. Artur Karl                              </td><td>male                                                   </td><td> 9.0                                                   </td><td>0                                                      </td><td>1                                                      </td><td>C 17368                                                </td><td>  3.1708                                               </td><td>                                                       </td><td>S                                                      </td><td> 9.00000                                               </td><td>  3.1708                                               </td></tr>\n",
       "\t<tr><td>914                                                    </td><td>1                                                      </td><td>Flegenheim, Mrs. Alfred (Antoinette)                   </td><td>female                                                 </td><td>  NA                                                   </td><td>0                                                      </td><td>0                                                      </td><td>PC 17598                                               </td><td> 31.6833                                               </td><td>                                                       </td><td>S                                                      </td><td>30.27259                                               </td><td> 31.6833                                               </td></tr>\n",
       "\t<tr><td>915                                                    </td><td>1                                                      </td><td>Williams, Mr. Richard Norris II                        </td><td>male                                                   </td><td>21.0                                                   </td><td>0                                                      </td><td>1                                                      </td><td>PC 17597                                               </td><td> 61.3792                                               </td><td>                                                       </td><td>C                                                      </td><td>21.00000                                               </td><td> 61.3792                                               </td></tr>\n",
       "\t<tr><td>916                                                    </td><td>1                                                      </td><td>Ryerson, Mrs. Arthur Larned (Emily Maria Borie)        </td><td>female                                                 </td><td>48.0                                                   </td><td>1                                                      </td><td>3                                                      </td><td>PC 17608                                               </td><td>262.3750                                               </td><td>B57 B59 B63 B66                                        </td><td>C                                                      </td><td>48.00000                                               </td><td>262.3750                                               </td></tr>\n",
       "\t<tr><td>917                                                    </td><td>3                                                      </td><td>Robins, Mr. Alexander A                                </td><td>male                                                   </td><td>50.0                                                   </td><td>1                                                      </td><td>0                                                      </td><td>A/5. 3337                                              </td><td> 14.5000                                               </td><td>                                                       </td><td>S                                                      </td><td>50.00000                                               </td><td> 14.5000                                               </td></tr>\n",
       "\t<tr><td>918                                                    </td><td>1                                                      </td><td>Ostby, Miss. Helene Ragnhild                           </td><td>female                                                 </td><td>22.0                                                   </td><td>0                                                      </td><td>1                                                      </td><td>113509                                                 </td><td> 61.9792                                               </td><td>B36                                                    </td><td>C                                                      </td><td>22.00000                                               </td><td> 61.9792                                               </td></tr>\n",
       "\t<tr><td>919                                                    </td><td>3                                                      </td><td>Daher, Mr. Shedid                                      </td><td>male                                                   </td><td>22.5                                                   </td><td>0                                                      </td><td>0                                                      </td><td>2698                                                   </td><td>  7.2250                                               </td><td>                                                       </td><td>C                                                      </td><td>22.50000                                               </td><td>  7.2250                                               </td></tr>\n",
       "\t<tr><td>920                                                    </td><td>1                                                      </td><td>Brady, Mr. John Bertram                                </td><td>male                                                   </td><td>41.0                                                   </td><td>0                                                      </td><td>0                                                      </td><td>113054                                                 </td><td> 30.5000                                               </td><td>A21                                                    </td><td>S                                                      </td><td>41.00000                                               </td><td> 30.5000                                               </td></tr>\n",
       "\t<tr><td>921                                                    </td><td>3                                                      </td><td>Samaan, Mr. Elias                                      </td><td>male                                                   </td><td>  NA                                                   </td><td>2                                                      </td><td>0                                                      </td><td>2662                                                   </td><td> 21.6792                                               </td><td>                                                       </td><td>C                                                      </td><td>30.27259                                               </td><td> 21.6792                                               </td></tr>\n",
       "\t<tr><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td></tr>\n",
       "\t<tr><td>1280                                                           </td><td>3                                                              </td><td>Canavan, Mr. Patrick                                           </td><td>male                                                           </td><td>21.0                                                           </td><td>0                                                              </td><td>0                                                              </td><td>364858                                                         </td><td>  7.7500                                                       </td><td>                                                               </td><td>Q                                                              </td><td>21.00000                                                       </td><td>  7.7500                                                       </td></tr>\n",
       "\t<tr><td>1281                                                           </td><td>3                                                              </td><td>Palsson, Master. Paul Folke                                    </td><td>male                                                           </td><td> 6.0                                                           </td><td>3                                                              </td><td>1                                                              </td><td>349909                                                         </td><td> 21.0750                                                       </td><td>                                                               </td><td>S                                                              </td><td> 6.00000                                                       </td><td> 21.0750                                                       </td></tr>\n",
       "\t<tr><td>1282                                                           </td><td>1                                                              </td><td>Payne, Mr. Vivian Ponsonby                                     </td><td>male                                                           </td><td>23.0                                                           </td><td>0                                                              </td><td>0                                                              </td><td>12749                                                          </td><td> 93.5000                                                       </td><td>B24                                                            </td><td>S                                                              </td><td>23.00000                                                       </td><td> 93.5000                                                       </td></tr>\n",
       "\t<tr><td>1283                                                           </td><td>1                                                              </td><td>Lines, Mrs. Ernest H (Elizabeth Lindsey James)                 </td><td>female                                                         </td><td>51.0                                                           </td><td>0                                                              </td><td>1                                                              </td><td>PC 17592                                                       </td><td> 39.4000                                                       </td><td>D28                                                            </td><td>S                                                              </td><td>51.00000                                                       </td><td> 39.4000                                                       </td></tr>\n",
       "\t<tr><td>1284                                                           </td><td>3                                                              </td><td>Abbott, Master. Eugene Joseph                                  </td><td>male                                                           </td><td>13.0                                                           </td><td>0                                                              </td><td>2                                                              </td><td>C.A. 2673                                                      </td><td> 20.2500                                                       </td><td>                                                               </td><td>S                                                              </td><td>13.00000                                                       </td><td> 20.2500                                                       </td></tr>\n",
       "\t<tr><td>1285                                                           </td><td>2                                                              </td><td>Gilbert, Mr. William                                           </td><td>male                                                           </td><td>47.0                                                           </td><td>0                                                              </td><td>0                                                              </td><td>C.A. 30769                                                     </td><td> 10.5000                                                       </td><td>                                                               </td><td>S                                                              </td><td>47.00000                                                       </td><td> 10.5000                                                       </td></tr>\n",
       "\t<tr><td>1286                                                           </td><td>3                                                              </td><td>Kink-Heilmann, Mr. Anton                                       </td><td>male                                                           </td><td>29.0                                                           </td><td>3                                                              </td><td>1                                                              </td><td>315153                                                         </td><td> 22.0250                                                       </td><td>                                                               </td><td>S                                                              </td><td>29.00000                                                       </td><td> 22.0250                                                       </td></tr>\n",
       "\t<tr><td>1287                                                           </td><td>1                                                              </td><td>Smith, Mrs. Lucien Philip (Mary Eloise Hughes)                 </td><td>female                                                         </td><td>18.0                                                           </td><td>1                                                              </td><td>0                                                              </td><td>13695                                                          </td><td> 60.0000                                                       </td><td>C31                                                            </td><td>S                                                              </td><td>18.00000                                                       </td><td> 60.0000                                                       </td></tr>\n",
       "\t<tr><td>1288                                                           </td><td>3                                                              </td><td>Colbert, Mr. Patrick                                           </td><td>male                                                           </td><td>24.0                                                           </td><td>0                                                              </td><td>0                                                              </td><td>371109                                                         </td><td>  7.2500                                                       </td><td>                                                               </td><td>Q                                                              </td><td>24.00000                                                       </td><td>  7.2500                                                       </td></tr>\n",
       "\t<tr><td>1289                                                           </td><td>1                                                              </td><td>Frolicher-Stehli, Mrs. Maxmillian (Margaretha Emerentia Stehli)</td><td>female                                                         </td><td>48.0                                                           </td><td>1                                                              </td><td>1                                                              </td><td>13567                                                          </td><td> 79.2000                                                       </td><td>B41                                                            </td><td>C                                                              </td><td>48.00000                                                       </td><td> 79.2000                                                       </td></tr>\n",
       "\t<tr><td>1290                                                           </td><td>3                                                              </td><td>Larsson-Rondberg, Mr. Edvard A                                 </td><td>male                                                           </td><td>22.0                                                           </td><td>0                                                              </td><td>0                                                              </td><td>347065                                                         </td><td>  7.7750                                                       </td><td>                                                               </td><td>S                                                              </td><td>22.00000                                                       </td><td>  7.7750                                                       </td></tr>\n",
       "\t<tr><td>1291                                                           </td><td>3                                                              </td><td>Conlon, Mr. Thomas Henry                                       </td><td>male                                                           </td><td>31.0                                                           </td><td>0                                                              </td><td>0                                                              </td><td>21332                                                          </td><td>  7.7333                                                       </td><td>                                                               </td><td>Q                                                              </td><td>31.00000                                                       </td><td>  7.7333                                                       </td></tr>\n",
       "\t<tr><td>1292                                                           </td><td>1                                                              </td><td>Bonnell, Miss. Caroline                                        </td><td>female                                                         </td><td>30.0                                                           </td><td>0                                                              </td><td>0                                                              </td><td>36928                                                          </td><td>164.8667                                                       </td><td>C7                                                             </td><td>S                                                              </td><td>30.00000                                                       </td><td>164.8667                                                       </td></tr>\n",
       "\t<tr><td>1293                                                           </td><td>2                                                              </td><td>Gale, Mr. Harry                                                </td><td>male                                                           </td><td>38.0                                                           </td><td>1                                                              </td><td>0                                                              </td><td>28664                                                          </td><td> 21.0000                                                       </td><td>                                                               </td><td>S                                                              </td><td>38.00000                                                       </td><td> 21.0000                                                       </td></tr>\n",
       "\t<tr><td>1294                                                           </td><td>1                                                              </td><td>Gibson, Miss. Dorothy Winifred                                 </td><td>female                                                         </td><td>22.0                                                           </td><td>0                                                              </td><td>1                                                              </td><td>112378                                                         </td><td> 59.4000                                                       </td><td>                                                               </td><td>C                                                              </td><td>22.00000                                                       </td><td> 59.4000                                                       </td></tr>\n",
       "\t<tr><td>1295                                                           </td><td>1                                                              </td><td>Carrau, Mr. Jose Pedro                                         </td><td>male                                                           </td><td>17.0                                                           </td><td>0                                                              </td><td>0                                                              </td><td>113059                                                         </td><td> 47.1000                                                       </td><td>                                                               </td><td>S                                                              </td><td>17.00000                                                       </td><td> 47.1000                                                       </td></tr>\n",
       "\t<tr><td>1296                                                           </td><td>1                                                              </td><td>Frauenthal, Mr. Isaac Gerald                                   </td><td>male                                                           </td><td>43.0                                                           </td><td>1                                                              </td><td>0                                                              </td><td>17765                                                          </td><td> 27.7208                                                       </td><td>D40                                                            </td><td>C                                                              </td><td>43.00000                                                       </td><td> 27.7208                                                       </td></tr>\n",
       "\t<tr><td>1297                                                           </td><td>2                                                              </td><td>Nourney, Mr. Alfred (Baron von Drachstedt\")\"                   </td><td>male                                                           </td><td>20.0                                                           </td><td>0                                                              </td><td>0                                                              </td><td>SC/PARIS 2166                                                  </td><td> 13.8625                                                       </td><td>D38                                                            </td><td>C                                                              </td><td>20.00000                                                       </td><td> 13.8625                                                       </td></tr>\n",
       "\t<tr><td>1298                                                           </td><td>2                                                              </td><td>Ware, Mr. William Jeffery                                      </td><td>male                                                           </td><td>23.0                                                           </td><td>1                                                              </td><td>0                                                              </td><td>28666                                                          </td><td> 10.5000                                                       </td><td>                                                               </td><td>S                                                              </td><td>23.00000                                                       </td><td> 10.5000                                                       </td></tr>\n",
       "\t<tr><td>1299                                                           </td><td>1                                                              </td><td>Widener, Mr. George Dunton                                     </td><td>male                                                           </td><td>50.0                                                           </td><td>1                                                              </td><td>1                                                              </td><td>113503                                                         </td><td>211.5000                                                       </td><td>C80                                                            </td><td>C                                                              </td><td>50.00000                                                       </td><td>211.5000                                                       </td></tr>\n",
       "\t<tr><td>1300                                                           </td><td>3                                                              </td><td>Riordan, Miss. Johanna Hannah\"\"                                </td><td>female                                                         </td><td>  NA                                                           </td><td>0                                                              </td><td>0                                                              </td><td>334915                                                         </td><td>  7.7208                                                       </td><td>                                                               </td><td>Q                                                              </td><td>30.27259                                                       </td><td>  7.7208                                                       </td></tr>\n",
       "\t<tr><td>1301                                                           </td><td>3                                                              </td><td>Peacock, Miss. Treasteall                                      </td><td>female                                                         </td><td> 3.0                                                           </td><td>1                                                              </td><td>1                                                              </td><td>SOTON/O.Q. 3101315                                             </td><td> 13.7750                                                       </td><td>                                                               </td><td>S                                                              </td><td> 3.00000                                                       </td><td> 13.7750                                                       </td></tr>\n",
       "\t<tr><td>1302                                                           </td><td>3                                                              </td><td>Naughton, Miss. Hannah                                         </td><td>female                                                         </td><td>  NA                                                           </td><td>0                                                              </td><td>0                                                              </td><td>365237                                                         </td><td>  7.7500                                                       </td><td>                                                               </td><td>Q                                                              </td><td>30.27259                                                       </td><td>  7.7500                                                       </td></tr>\n",
       "\t<tr><td>1303                                                           </td><td>1                                                              </td><td>Minahan, Mrs. William Edward (Lillian E Thorpe)                </td><td>female                                                         </td><td>37.0                                                           </td><td>1                                                              </td><td>0                                                              </td><td>19928                                                          </td><td> 90.0000                                                       </td><td>C78                                                            </td><td>Q                                                              </td><td>37.00000                                                       </td><td> 90.0000                                                       </td></tr>\n",
       "\t<tr><td>1304                                                           </td><td>3                                                              </td><td>Henriksson, Miss. Jenny Lovisa                                 </td><td>female                                                         </td><td>28.0                                                           </td><td>0                                                              </td><td>0                                                              </td><td>347086                                                         </td><td>  7.7750                                                       </td><td>                                                               </td><td>S                                                              </td><td>28.00000                                                       </td><td>  7.7750                                                       </td></tr>\n",
       "\t<tr><td>1305                                                           </td><td>3                                                              </td><td>Spector, Mr. Woolf                                             </td><td>male                                                           </td><td>  NA                                                           </td><td>0                                                              </td><td>0                                                              </td><td>A.5. 3236                                                      </td><td>  8.0500                                                       </td><td>                                                               </td><td>S                                                              </td><td>30.27259                                                       </td><td>  8.0500                                                       </td></tr>\n",
       "\t<tr><td>1306                                                           </td><td>1                                                              </td><td>Oliva y Ocana, Dona. Fermina                                   </td><td>female                                                         </td><td>39.0                                                           </td><td>0                                                              </td><td>0                                                              </td><td>PC 17758                                                       </td><td>108.9000                                                       </td><td>C105                                                           </td><td>C                                                              </td><td>39.00000                                                       </td><td>108.9000                                                       </td></tr>\n",
       "\t<tr><td>1307                                                           </td><td>3                                                              </td><td>Saether, Mr. Simon Sivertsen                                   </td><td>male                                                           </td><td>38.5                                                           </td><td>0                                                              </td><td>0                                                              </td><td>SOTON/O.Q. 3101262                                             </td><td>  7.2500                                                       </td><td>                                                               </td><td>S                                                              </td><td>38.50000                                                       </td><td>  7.2500                                                       </td></tr>\n",
       "\t<tr><td>1308                                                           </td><td>3                                                              </td><td>Ware, Mr. Frederick                                            </td><td>male                                                           </td><td>  NA                                                           </td><td>0                                                              </td><td>0                                                              </td><td>359309                                                         </td><td>  8.0500                                                       </td><td>                                                               </td><td>S                                                              </td><td>30.27259                                                       </td><td>  8.0500                                                       </td></tr>\n",
       "\t<tr><td>1309                                                           </td><td>3                                                              </td><td>Peter, Master. Michael J                                       </td><td>male                                                           </td><td>  NA                                                           </td><td>1                                                              </td><td>1                                                              </td><td>2668                                                           </td><td> 22.3583                                                       </td><td>                                                               </td><td>C                                                              </td><td>30.27259                                                       </td><td> 22.3583                                                       </td></tr>\n",
       "</tbody>\n",
       "</table>\n"
      ],
      "text/latex": [
       "\\begin{tabular}{r|lllllllllllll}\n",
       " PassengerId & Pclass & Name & Sex & Age & SibSp & Parch & Ticket & Fare & Cabin & Embarked & replace\\_mean\\_age & replace\\_mean\\_fare\\\\\n",
       "\\hline\n",
       "\t 892                                                     & 3                                                       & Kelly, Mr. James                                        & male                                                    & 34.5                                                    & 0                                                       & 0                                                       & 330911                                                  &   7.8292                                                &                                                         & Q                                                       & 34.50000                                                &   7.8292                                               \\\\\n",
       "\t 893                                                     & 3                                                       & Wilkes, Mrs. James (Ellen Needs)                        & female                                                  & 47.0                                                    & 1                                                       & 0                                                       & 363272                                                  &   7.0000                                                &                                                         & S                                                       & 47.00000                                                &   7.0000                                               \\\\\n",
       "\t 894                                                     & 2                                                       & Myles, Mr. Thomas Francis                               & male                                                    & 62.0                                                    & 0                                                       & 0                                                       & 240276                                                  &   9.6875                                                &                                                         & Q                                                       & 62.00000                                                &   9.6875                                               \\\\\n",
       "\t 895                                                     & 3                                                       & Wirz, Mr. Albert                                        & male                                                    & 27.0                                                    & 0                                                       & 0                                                       & 315154                                                  &   8.6625                                                &                                                         & S                                                       & 27.00000                                                &   8.6625                                               \\\\\n",
       "\t 896                                                     & 3                                                       & Hirvonen, Mrs. Alexander (Helga E Lindqvist)            & female                                                  & 22.0                                                    & 1                                                       & 1                                                       & 3101298                                                 &  12.2875                                                &                                                         & S                                                       & 22.00000                                                &  12.2875                                               \\\\\n",
       "\t 897                                                     & 3                                                       & Svensson, Mr. Johan Cervin                              & male                                                    & 14.0                                                    & 0                                                       & 0                                                       & 7538                                                    &   9.2250                                                &                                                         & S                                                       & 14.00000                                                &   9.2250                                               \\\\\n",
       "\t 898                                                     & 3                                                       & Connolly, Miss. Kate                                    & female                                                  & 30.0                                                    & 0                                                       & 0                                                       & 330972                                                  &   7.6292                                                &                                                         & Q                                                       & 30.00000                                                &   7.6292                                               \\\\\n",
       "\t 899                                                     & 2                                                       & Caldwell, Mr. Albert Francis                            & male                                                    & 26.0                                                    & 1                                                       & 1                                                       & 248738                                                  &  29.0000                                                &                                                         & S                                                       & 26.00000                                                &  29.0000                                               \\\\\n",
       "\t 900                                                     & 3                                                       & Abrahim, Mrs. Joseph (Sophie Halaut Easu)               & female                                                  & 18.0                                                    & 0                                                       & 0                                                       & 2657                                                    &   7.2292                                                &                                                         & C                                                       & 18.00000                                                &   7.2292                                               \\\\\n",
       "\t 901                                                     & 3                                                       & Davies, Mr. John Samuel                                 & male                                                    & 21.0                                                    & 2                                                       & 0                                                       & A/4 48871                                               &  24.1500                                                &                                                         & S                                                       & 21.00000                                                &  24.1500                                               \\\\\n",
       "\t 902                                                     & 3                                                       & Ilieff, Mr. Ylio                                        & male                                                    &   NA                                                    & 0                                                       & 0                                                       & 349220                                                  &   7.8958                                                &                                                         & S                                                       & 30.27259                                                &   7.8958                                               \\\\\n",
       "\t 903                                                     & 1                                                       & Jones, Mr. Charles Cresson                              & male                                                    & 46.0                                                    & 0                                                       & 0                                                       & 694                                                     &  26.0000                                                &                                                         & S                                                       & 46.00000                                                &  26.0000                                               \\\\\n",
       "\t 904                                                     & 1                                                       & Snyder, Mrs. John Pillsbury (Nelle Stevenson)           & female                                                  & 23.0                                                    & 1                                                       & 0                                                       & 21228                                                   &  82.2667                                                & B45                                                     & S                                                       & 23.00000                                                &  82.2667                                               \\\\\n",
       "\t 905                                                     & 2                                                       & Howard, Mr. Benjamin                                    & male                                                    & 63.0                                                    & 1                                                       & 0                                                       & 24065                                                   &  26.0000                                                &                                                         & S                                                       & 63.00000                                                &  26.0000                                               \\\\\n",
       "\t 906                                                     & 1                                                       & Chaffee, Mrs. Herbert Fuller (Carrie Constance Toogood) & female                                                  & 47.0                                                    & 1                                                       & 0                                                       & W.E.P. 5734                                             &  61.1750                                                & E31                                                     & S                                                       & 47.00000                                                &  61.1750                                               \\\\\n",
       "\t 907                                                     & 2                                                       & del Carlo, Mrs. Sebastiano (Argenia Genovesi)           & female                                                  & 24.0                                                    & 1                                                       & 0                                                       & SC/PARIS 2167                                           &  27.7208                                                &                                                         & C                                                       & 24.00000                                                &  27.7208                                               \\\\\n",
       "\t 908                                                     & 2                                                       & Keane, Mr. Daniel                                       & male                                                    & 35.0                                                    & 0                                                       & 0                                                       & 233734                                                  &  12.3500                                                &                                                         & Q                                                       & 35.00000                                                &  12.3500                                               \\\\\n",
       "\t 909                                                     & 3                                                       & Assaf, Mr. Gerios                                       & male                                                    & 21.0                                                    & 0                                                       & 0                                                       & 2692                                                    &   7.2250                                                &                                                         & C                                                       & 21.00000                                                &   7.2250                                               \\\\\n",
       "\t 910                                                     & 3                                                       & Ilmakangas, Miss. Ida Livija                            & female                                                  & 27.0                                                    & 1                                                       & 0                                                       & STON/O2. 3101270                                        &   7.9250                                                &                                                         & S                                                       & 27.00000                                                &   7.9250                                               \\\\\n",
       "\t 911                                                     & 3                                                       & Assaf Khalil, Mrs. Mariana (Miriam\")\"                   & female                                                  & 45.0                                                    & 0                                                       & 0                                                       & 2696                                                    &   7.2250                                                &                                                         & C                                                       & 45.00000                                                &   7.2250                                               \\\\\n",
       "\t 912                                                     & 1                                                       & Rothschild, Mr. Martin                                  & male                                                    & 55.0                                                    & 1                                                       & 0                                                       & PC 17603                                                &  59.4000                                                &                                                         & C                                                       & 55.00000                                                &  59.4000                                               \\\\\n",
       "\t 913                                                     & 3                                                       & Olsen, Master. Artur Karl                               & male                                                    &  9.0                                                    & 0                                                       & 1                                                       & C 17368                                                 &   3.1708                                                &                                                         & S                                                       &  9.00000                                                &   3.1708                                               \\\\\n",
       "\t 914                                                     & 1                                                       & Flegenheim, Mrs. Alfred (Antoinette)                    & female                                                  &   NA                                                    & 0                                                       & 0                                                       & PC 17598                                                &  31.6833                                                &                                                         & S                                                       & 30.27259                                                &  31.6833                                               \\\\\n",
       "\t 915                                                     & 1                                                       & Williams, Mr. Richard Norris II                         & male                                                    & 21.0                                                    & 0                                                       & 1                                                       & PC 17597                                                &  61.3792                                                &                                                         & C                                                       & 21.00000                                                &  61.3792                                               \\\\\n",
       "\t 916                                                     & 1                                                       & Ryerson, Mrs. Arthur Larned (Emily Maria Borie)         & female                                                  & 48.0                                                    & 1                                                       & 3                                                       & PC 17608                                                & 262.3750                                                & B57 B59 B63 B66                                         & C                                                       & 48.00000                                                & 262.3750                                               \\\\\n",
       "\t 917                                                     & 3                                                       & Robins, Mr. Alexander A                                 & male                                                    & 50.0                                                    & 1                                                       & 0                                                       & A/5. 3337                                               &  14.5000                                                &                                                         & S                                                       & 50.00000                                                &  14.5000                                               \\\\\n",
       "\t 918                                                     & 1                                                       & Ostby, Miss. Helene Ragnhild                            & female                                                  & 22.0                                                    & 0                                                       & 1                                                       & 113509                                                  &  61.9792                                                & B36                                                     & C                                                       & 22.00000                                                &  61.9792                                               \\\\\n",
       "\t 919                                                     & 3                                                       & Daher, Mr. Shedid                                       & male                                                    & 22.5                                                    & 0                                                       & 0                                                       & 2698                                                    &   7.2250                                                &                                                         & C                                                       & 22.50000                                                &   7.2250                                               \\\\\n",
       "\t 920                                                     & 1                                                       & Brady, Mr. John Bertram                                 & male                                                    & 41.0                                                    & 0                                                       & 0                                                       & 113054                                                  &  30.5000                                                & A21                                                     & S                                                       & 41.00000                                                &  30.5000                                               \\\\\n",
       "\t 921                                                     & 3                                                       & Samaan, Mr. Elias                                       & male                                                    &   NA                                                    & 2                                                       & 0                                                       & 2662                                                    &  21.6792                                                &                                                         & C                                                       & 30.27259                                                &  21.6792                                               \\\\\n",
       "\t ... & ... & ... & ... & ... & ... & ... & ... & ... & ... & ... & ... & ...\\\\\n",
       "\t 1280                                                            & 3                                                               & Canavan, Mr. Patrick                                            & male                                                            & 21.0                                                            & 0                                                               & 0                                                               & 364858                                                          &   7.7500                                                        &                                                                 & Q                                                               & 21.00000                                                        &   7.7500                                                       \\\\\n",
       "\t 1281                                                            & 3                                                               & Palsson, Master. Paul Folke                                     & male                                                            &  6.0                                                            & 3                                                               & 1                                                               & 349909                                                          &  21.0750                                                        &                                                                 & S                                                               &  6.00000                                                        &  21.0750                                                       \\\\\n",
       "\t 1282                                                            & 1                                                               & Payne, Mr. Vivian Ponsonby                                      & male                                                            & 23.0                                                            & 0                                                               & 0                                                               & 12749                                                           &  93.5000                                                        & B24                                                             & S                                                               & 23.00000                                                        &  93.5000                                                       \\\\\n",
       "\t 1283                                                            & 1                                                               & Lines, Mrs. Ernest H (Elizabeth Lindsey James)                  & female                                                          & 51.0                                                            & 0                                                               & 1                                                               & PC 17592                                                        &  39.4000                                                        & D28                                                             & S                                                               & 51.00000                                                        &  39.4000                                                       \\\\\n",
       "\t 1284                                                            & 3                                                               & Abbott, Master. Eugene Joseph                                   & male                                                            & 13.0                                                            & 0                                                               & 2                                                               & C.A. 2673                                                       &  20.2500                                                        &                                                                 & S                                                               & 13.00000                                                        &  20.2500                                                       \\\\\n",
       "\t 1285                                                            & 2                                                               & Gilbert, Mr. William                                            & male                                                            & 47.0                                                            & 0                                                               & 0                                                               & C.A. 30769                                                      &  10.5000                                                        &                                                                 & S                                                               & 47.00000                                                        &  10.5000                                                       \\\\\n",
       "\t 1286                                                            & 3                                                               & Kink-Heilmann, Mr. Anton                                        & male                                                            & 29.0                                                            & 3                                                               & 1                                                               & 315153                                                          &  22.0250                                                        &                                                                 & S                                                               & 29.00000                                                        &  22.0250                                                       \\\\\n",
       "\t 1287                                                            & 1                                                               & Smith, Mrs. Lucien Philip (Mary Eloise Hughes)                  & female                                                          & 18.0                                                            & 1                                                               & 0                                                               & 13695                                                           &  60.0000                                                        & C31                                                             & S                                                               & 18.00000                                                        &  60.0000                                                       \\\\\n",
       "\t 1288                                                            & 3                                                               & Colbert, Mr. Patrick                                            & male                                                            & 24.0                                                            & 0                                                               & 0                                                               & 371109                                                          &   7.2500                                                        &                                                                 & Q                                                               & 24.00000                                                        &   7.2500                                                       \\\\\n",
       "\t 1289                                                            & 1                                                               & Frolicher-Stehli, Mrs. Maxmillian (Margaretha Emerentia Stehli) & female                                                          & 48.0                                                            & 1                                                               & 1                                                               & 13567                                                           &  79.2000                                                        & B41                                                             & C                                                               & 48.00000                                                        &  79.2000                                                       \\\\\n",
       "\t 1290                                                            & 3                                                               & Larsson-Rondberg, Mr. Edvard A                                  & male                                                            & 22.0                                                            & 0                                                               & 0                                                               & 347065                                                          &   7.7750                                                        &                                                                 & S                                                               & 22.00000                                                        &   7.7750                                                       \\\\\n",
       "\t 1291                                                            & 3                                                               & Conlon, Mr. Thomas Henry                                        & male                                                            & 31.0                                                            & 0                                                               & 0                                                               & 21332                                                           &   7.7333                                                        &                                                                 & Q                                                               & 31.00000                                                        &   7.7333                                                       \\\\\n",
       "\t 1292                                                            & 1                                                               & Bonnell, Miss. Caroline                                         & female                                                          & 30.0                                                            & 0                                                               & 0                                                               & 36928                                                           & 164.8667                                                        & C7                                                              & S                                                               & 30.00000                                                        & 164.8667                                                       \\\\\n",
       "\t 1293                                                            & 2                                                               & Gale, Mr. Harry                                                 & male                                                            & 38.0                                                            & 1                                                               & 0                                                               & 28664                                                           &  21.0000                                                        &                                                                 & S                                                               & 38.00000                                                        &  21.0000                                                       \\\\\n",
       "\t 1294                                                            & 1                                                               & Gibson, Miss. Dorothy Winifred                                  & female                                                          & 22.0                                                            & 0                                                               & 1                                                               & 112378                                                          &  59.4000                                                        &                                                                 & C                                                               & 22.00000                                                        &  59.4000                                                       \\\\\n",
       "\t 1295                                                            & 1                                                               & Carrau, Mr. Jose Pedro                                          & male                                                            & 17.0                                                            & 0                                                               & 0                                                               & 113059                                                          &  47.1000                                                        &                                                                 & S                                                               & 17.00000                                                        &  47.1000                                                       \\\\\n",
       "\t 1296                                                            & 1                                                               & Frauenthal, Mr. Isaac Gerald                                    & male                                                            & 43.0                                                            & 1                                                               & 0                                                               & 17765                                                           &  27.7208                                                        & D40                                                             & C                                                               & 43.00000                                                        &  27.7208                                                       \\\\\n",
       "\t 1297                                                            & 2                                                               & Nourney, Mr. Alfred (Baron von Drachstedt\")\"                    & male                                                            & 20.0                                                            & 0                                                               & 0                                                               & SC/PARIS 2166                                                   &  13.8625                                                        & D38                                                             & C                                                               & 20.00000                                                        &  13.8625                                                       \\\\\n",
       "\t 1298                                                            & 2                                                               & Ware, Mr. William Jeffery                                       & male                                                            & 23.0                                                            & 1                                                               & 0                                                               & 28666                                                           &  10.5000                                                        &                                                                 & S                                                               & 23.00000                                                        &  10.5000                                                       \\\\\n",
       "\t 1299                                                            & 1                                                               & Widener, Mr. George Dunton                                      & male                                                            & 50.0                                                            & 1                                                               & 1                                                               & 113503                                                          & 211.5000                                                        & C80                                                             & C                                                               & 50.00000                                                        & 211.5000                                                       \\\\\n",
       "\t 1300                                                            & 3                                                               & Riordan, Miss. Johanna Hannah\"\"                                 & female                                                          &   NA                                                            & 0                                                               & 0                                                               & 334915                                                          &   7.7208                                                        &                                                                 & Q                                                               & 30.27259                                                        &   7.7208                                                       \\\\\n",
       "\t 1301                                                            & 3                                                               & Peacock, Miss. Treasteall                                       & female                                                          &  3.0                                                            & 1                                                               & 1                                                               & SOTON/O.Q. 3101315                                              &  13.7750                                                        &                                                                 & S                                                               &  3.00000                                                        &  13.7750                                                       \\\\\n",
       "\t 1302                                                            & 3                                                               & Naughton, Miss. Hannah                                          & female                                                          &   NA                                                            & 0                                                               & 0                                                               & 365237                                                          &   7.7500                                                        &                                                                 & Q                                                               & 30.27259                                                        &   7.7500                                                       \\\\\n",
       "\t 1303                                                            & 1                                                               & Minahan, Mrs. William Edward (Lillian E Thorpe)                 & female                                                          & 37.0                                                            & 1                                                               & 0                                                               & 19928                                                           &  90.0000                                                        & C78                                                             & Q                                                               & 37.00000                                                        &  90.0000                                                       \\\\\n",
       "\t 1304                                                            & 3                                                               & Henriksson, Miss. Jenny Lovisa                                  & female                                                          & 28.0                                                            & 0                                                               & 0                                                               & 347086                                                          &   7.7750                                                        &                                                                 & S                                                               & 28.00000                                                        &   7.7750                                                       \\\\\n",
       "\t 1305                                                            & 3                                                               & Spector, Mr. Woolf                                              & male                                                            &   NA                                                            & 0                                                               & 0                                                               & A.5. 3236                                                       &   8.0500                                                        &                                                                 & S                                                               & 30.27259                                                        &   8.0500                                                       \\\\\n",
       "\t 1306                                                            & 1                                                               & Oliva y Ocana, Dona. Fermina                                    & female                                                          & 39.0                                                            & 0                                                               & 0                                                               & PC 17758                                                        & 108.9000                                                        & C105                                                            & C                                                               & 39.00000                                                        & 108.9000                                                       \\\\\n",
       "\t 1307                                                            & 3                                                               & Saether, Mr. Simon Sivertsen                                    & male                                                            & 38.5                                                            & 0                                                               & 0                                                               & SOTON/O.Q. 3101262                                              &   7.2500                                                        &                                                                 & S                                                               & 38.50000                                                        &   7.2500                                                       \\\\\n",
       "\t 1308                                                            & 3                                                               & Ware, Mr. Frederick                                             & male                                                            &   NA                                                            & 0                                                               & 0                                                               & 359309                                                          &   8.0500                                                        &                                                                 & S                                                               & 30.27259                                                        &   8.0500                                                       \\\\\n",
       "\t 1309                                                            & 3                                                               & Peter, Master. Michael J                                        & male                                                            &   NA                                                            & 1                                                               & 1                                                               & 2668                                                            &  22.3583                                                        &                                                                 & C                                                               & 30.27259                                                        &  22.3583                                                       \\\\\n",
       "\\end{tabular}\n"
      ],
      "text/markdown": [
       "\n",
       "| PassengerId | Pclass | Name | Sex | Age | SibSp | Parch | Ticket | Fare | Cabin | Embarked | replace_mean_age | replace_mean_fare |\n",
       "|---|---|---|---|---|---|---|---|---|---|---|---|---|\n",
       "| 892                                                     | 3                                                       | Kelly, Mr. James                                        | male                                                    | 34.5                                                    | 0                                                       | 0                                                       | 330911                                                  |   7.8292                                                |                                                         | Q                                                       | 34.50000                                                |   7.8292                                                |\n",
       "| 893                                                     | 3                                                       | Wilkes, Mrs. James (Ellen Needs)                        | female                                                  | 47.0                                                    | 1                                                       | 0                                                       | 363272                                                  |   7.0000                                                |                                                         | S                                                       | 47.00000                                                |   7.0000                                                |\n",
       "| 894                                                     | 2                                                       | Myles, Mr. Thomas Francis                               | male                                                    | 62.0                                                    | 0                                                       | 0                                                       | 240276                                                  |   9.6875                                                |                                                         | Q                                                       | 62.00000                                                |   9.6875                                                |\n",
       "| 895                                                     | 3                                                       | Wirz, Mr. Albert                                        | male                                                    | 27.0                                                    | 0                                                       | 0                                                       | 315154                                                  |   8.6625                                                |                                                         | S                                                       | 27.00000                                                |   8.6625                                                |\n",
       "| 896                                                     | 3                                                       | Hirvonen, Mrs. Alexander (Helga E Lindqvist)            | female                                                  | 22.0                                                    | 1                                                       | 1                                                       | 3101298                                                 |  12.2875                                                |                                                         | S                                                       | 22.00000                                                |  12.2875                                                |\n",
       "| 897                                                     | 3                                                       | Svensson, Mr. Johan Cervin                              | male                                                    | 14.0                                                    | 0                                                       | 0                                                       | 7538                                                    |   9.2250                                                |                                                         | S                                                       | 14.00000                                                |   9.2250                                                |\n",
       "| 898                                                     | 3                                                       | Connolly, Miss. Kate                                    | female                                                  | 30.0                                                    | 0                                                       | 0                                                       | 330972                                                  |   7.6292                                                |                                                         | Q                                                       | 30.00000                                                |   7.6292                                                |\n",
       "| 899                                                     | 2                                                       | Caldwell, Mr. Albert Francis                            | male                                                    | 26.0                                                    | 1                                                       | 1                                                       | 248738                                                  |  29.0000                                                |                                                         | S                                                       | 26.00000                                                |  29.0000                                                |\n",
       "| 900                                                     | 3                                                       | Abrahim, Mrs. Joseph (Sophie Halaut Easu)               | female                                                  | 18.0                                                    | 0                                                       | 0                                                       | 2657                                                    |   7.2292                                                |                                                         | C                                                       | 18.00000                                                |   7.2292                                                |\n",
       "| 901                                                     | 3                                                       | Davies, Mr. John Samuel                                 | male                                                    | 21.0                                                    | 2                                                       | 0                                                       | A/4 48871                                               |  24.1500                                                |                                                         | S                                                       | 21.00000                                                |  24.1500                                                |\n",
       "| 902                                                     | 3                                                       | Ilieff, Mr. Ylio                                        | male                                                    |   NA                                                    | 0                                                       | 0                                                       | 349220                                                  |   7.8958                                                |                                                         | S                                                       | 30.27259                                                |   7.8958                                                |\n",
       "| 903                                                     | 1                                                       | Jones, Mr. Charles Cresson                              | male                                                    | 46.0                                                    | 0                                                       | 0                                                       | 694                                                     |  26.0000                                                |                                                         | S                                                       | 46.00000                                                |  26.0000                                                |\n",
       "| 904                                                     | 1                                                       | Snyder, Mrs. John Pillsbury (Nelle Stevenson)           | female                                                  | 23.0                                                    | 1                                                       | 0                                                       | 21228                                                   |  82.2667                                                | B45                                                     | S                                                       | 23.00000                                                |  82.2667                                                |\n",
       "| 905                                                     | 2                                                       | Howard, Mr. Benjamin                                    | male                                                    | 63.0                                                    | 1                                                       | 0                                                       | 24065                                                   |  26.0000                                                |                                                         | S                                                       | 63.00000                                                |  26.0000                                                |\n",
       "| 906                                                     | 1                                                       | Chaffee, Mrs. Herbert Fuller (Carrie Constance Toogood) | female                                                  | 47.0                                                    | 1                                                       | 0                                                       | W.E.P. 5734                                             |  61.1750                                                | E31                                                     | S                                                       | 47.00000                                                |  61.1750                                                |\n",
       "| 907                                                     | 2                                                       | del Carlo, Mrs. Sebastiano (Argenia Genovesi)           | female                                                  | 24.0                                                    | 1                                                       | 0                                                       | SC/PARIS 2167                                           |  27.7208                                                |                                                         | C                                                       | 24.00000                                                |  27.7208                                                |\n",
       "| 908                                                     | 2                                                       | Keane, Mr. Daniel                                       | male                                                    | 35.0                                                    | 0                                                       | 0                                                       | 233734                                                  |  12.3500                                                |                                                         | Q                                                       | 35.00000                                                |  12.3500                                                |\n",
       "| 909                                                     | 3                                                       | Assaf, Mr. Gerios                                       | male                                                    | 21.0                                                    | 0                                                       | 0                                                       | 2692                                                    |   7.2250                                                |                                                         | C                                                       | 21.00000                                                |   7.2250                                                |\n",
       "| 910                                                     | 3                                                       | Ilmakangas, Miss. Ida Livija                            | female                                                  | 27.0                                                    | 1                                                       | 0                                                       | STON/O2. 3101270                                        |   7.9250                                                |                                                         | S                                                       | 27.00000                                                |   7.9250                                                |\n",
       "| 911                                                     | 3                                                       | Assaf Khalil, Mrs. Mariana (Miriam\")\"                   | female                                                  | 45.0                                                    | 0                                                       | 0                                                       | 2696                                                    |   7.2250                                                |                                                         | C                                                       | 45.00000                                                |   7.2250                                                |\n",
       "| 912                                                     | 1                                                       | Rothschild, Mr. Martin                                  | male                                                    | 55.0                                                    | 1                                                       | 0                                                       | PC 17603                                                |  59.4000                                                |                                                         | C                                                       | 55.00000                                                |  59.4000                                                |\n",
       "| 913                                                     | 3                                                       | Olsen, Master. Artur Karl                               | male                                                    |  9.0                                                    | 0                                                       | 1                                                       | C 17368                                                 |   3.1708                                                |                                                         | S                                                       |  9.00000                                                |   3.1708                                                |\n",
       "| 914                                                     | 1                                                       | Flegenheim, Mrs. Alfred (Antoinette)                    | female                                                  |   NA                                                    | 0                                                       | 0                                                       | PC 17598                                                |  31.6833                                                |                                                         | S                                                       | 30.27259                                                |  31.6833                                                |\n",
       "| 915                                                     | 1                                                       | Williams, Mr. Richard Norris II                         | male                                                    | 21.0                                                    | 0                                                       | 1                                                       | PC 17597                                                |  61.3792                                                |                                                         | C                                                       | 21.00000                                                |  61.3792                                                |\n",
       "| 916                                                     | 1                                                       | Ryerson, Mrs. Arthur Larned (Emily Maria Borie)         | female                                                  | 48.0                                                    | 1                                                       | 3                                                       | PC 17608                                                | 262.3750                                                | B57 B59 B63 B66                                         | C                                                       | 48.00000                                                | 262.3750                                                |\n",
       "| 917                                                     | 3                                                       | Robins, Mr. Alexander A                                 | male                                                    | 50.0                                                    | 1                                                       | 0                                                       | A/5. 3337                                               |  14.5000                                                |                                                         | S                                                       | 50.00000                                                |  14.5000                                                |\n",
       "| 918                                                     | 1                                                       | Ostby, Miss. Helene Ragnhild                            | female                                                  | 22.0                                                    | 0                                                       | 1                                                       | 113509                                                  |  61.9792                                                | B36                                                     | C                                                       | 22.00000                                                |  61.9792                                                |\n",
       "| 919                                                     | 3                                                       | Daher, Mr. Shedid                                       | male                                                    | 22.5                                                    | 0                                                       | 0                                                       | 2698                                                    |   7.2250                                                |                                                         | C                                                       | 22.50000                                                |   7.2250                                                |\n",
       "| 920                                                     | 1                                                       | Brady, Mr. John Bertram                                 | male                                                    | 41.0                                                    | 0                                                       | 0                                                       | 113054                                                  |  30.5000                                                | A21                                                     | S                                                       | 41.00000                                                |  30.5000                                                |\n",
       "| 921                                                     | 3                                                       | Samaan, Mr. Elias                                       | male                                                    |   NA                                                    | 2                                                       | 0                                                       | 2662                                                    |  21.6792                                                |                                                         | C                                                       | 30.27259                                                |  21.6792                                                |\n",
       "| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |\n",
       "| 1280                                                            | 3                                                               | Canavan, Mr. Patrick                                            | male                                                            | 21.0                                                            | 0                                                               | 0                                                               | 364858                                                          |   7.7500                                                        |                                                                 | Q                                                               | 21.00000                                                        |   7.7500                                                        |\n",
       "| 1281                                                            | 3                                                               | Palsson, Master. Paul Folke                                     | male                                                            |  6.0                                                            | 3                                                               | 1                                                               | 349909                                                          |  21.0750                                                        |                                                                 | S                                                               |  6.00000                                                        |  21.0750                                                        |\n",
       "| 1282                                                            | 1                                                               | Payne, Mr. Vivian Ponsonby                                      | male                                                            | 23.0                                                            | 0                                                               | 0                                                               | 12749                                                           |  93.5000                                                        | B24                                                             | S                                                               | 23.00000                                                        |  93.5000                                                        |\n",
       "| 1283                                                            | 1                                                               | Lines, Mrs. Ernest H (Elizabeth Lindsey James)                  | female                                                          | 51.0                                                            | 0                                                               | 1                                                               | PC 17592                                                        |  39.4000                                                        | D28                                                             | S                                                               | 51.00000                                                        |  39.4000                                                        |\n",
       "| 1284                                                            | 3                                                               | Abbott, Master. Eugene Joseph                                   | male                                                            | 13.0                                                            | 0                                                               | 2                                                               | C.A. 2673                                                       |  20.2500                                                        |                                                                 | S                                                               | 13.00000                                                        |  20.2500                                                        |\n",
       "| 1285                                                            | 2                                                               | Gilbert, Mr. William                                            | male                                                            | 47.0                                                            | 0                                                               | 0                                                               | C.A. 30769                                                      |  10.5000                                                        |                                                                 | S                                                               | 47.00000                                                        |  10.5000                                                        |\n",
       "| 1286                                                            | 3                                                               | Kink-Heilmann, Mr. Anton                                        | male                                                            | 29.0                                                            | 3                                                               | 1                                                               | 315153                                                          |  22.0250                                                        |                                                                 | S                                                               | 29.00000                                                        |  22.0250                                                        |\n",
       "| 1287                                                            | 1                                                               | Smith, Mrs. Lucien Philip (Mary Eloise Hughes)                  | female                                                          | 18.0                                                            | 1                                                               | 0                                                               | 13695                                                           |  60.0000                                                        | C31                                                             | S                                                               | 18.00000                                                        |  60.0000                                                        |\n",
       "| 1288                                                            | 3                                                               | Colbert, Mr. Patrick                                            | male                                                            | 24.0                                                            | 0                                                               | 0                                                               | 371109                                                          |   7.2500                                                        |                                                                 | Q                                                               | 24.00000                                                        |   7.2500                                                        |\n",
       "| 1289                                                            | 1                                                               | Frolicher-Stehli, Mrs. Maxmillian (Margaretha Emerentia Stehli) | female                                                          | 48.0                                                            | 1                                                               | 1                                                               | 13567                                                           |  79.2000                                                        | B41                                                             | C                                                               | 48.00000                                                        |  79.2000                                                        |\n",
       "| 1290                                                            | 3                                                               | Larsson-Rondberg, Mr. Edvard A                                  | male                                                            | 22.0                                                            | 0                                                               | 0                                                               | 347065                                                          |   7.7750                                                        |                                                                 | S                                                               | 22.00000                                                        |   7.7750                                                        |\n",
       "| 1291                                                            | 3                                                               | Conlon, Mr. Thomas Henry                                        | male                                                            | 31.0                                                            | 0                                                               | 0                                                               | 21332                                                           |   7.7333                                                        |                                                                 | Q                                                               | 31.00000                                                        |   7.7333                                                        |\n",
       "| 1292                                                            | 1                                                               | Bonnell, Miss. Caroline                                         | female                                                          | 30.0                                                            | 0                                                               | 0                                                               | 36928                                                           | 164.8667                                                        | C7                                                              | S                                                               | 30.00000                                                        | 164.8667                                                        |\n",
       "| 1293                                                            | 2                                                               | Gale, Mr. Harry                                                 | male                                                            | 38.0                                                            | 1                                                               | 0                                                               | 28664                                                           |  21.0000                                                        |                                                                 | S                                                               | 38.00000                                                        |  21.0000                                                        |\n",
       "| 1294                                                            | 1                                                               | Gibson, Miss. Dorothy Winifred                                  | female                                                          | 22.0                                                            | 0                                                               | 1                                                               | 112378                                                          |  59.4000                                                        |                                                                 | C                                                               | 22.00000                                                        |  59.4000                                                        |\n",
       "| 1295                                                            | 1                                                               | Carrau, Mr. Jose Pedro                                          | male                                                            | 17.0                                                            | 0                                                               | 0                                                               | 113059                                                          |  47.1000                                                        |                                                                 | S                                                               | 17.00000                                                        |  47.1000                                                        |\n",
       "| 1296                                                            | 1                                                               | Frauenthal, Mr. Isaac Gerald                                    | male                                                            | 43.0                                                            | 1                                                               | 0                                                               | 17765                                                           |  27.7208                                                        | D40                                                             | C                                                               | 43.00000                                                        |  27.7208                                                        |\n",
       "| 1297                                                            | 2                                                               | Nourney, Mr. Alfred (Baron von Drachstedt\")\"                    | male                                                            | 20.0                                                            | 0                                                               | 0                                                               | SC/PARIS 2166                                                   |  13.8625                                                        | D38                                                             | C                                                               | 20.00000                                                        |  13.8625                                                        |\n",
       "| 1298                                                            | 2                                                               | Ware, Mr. William Jeffery                                       | male                                                            | 23.0                                                            | 1                                                               | 0                                                               | 28666                                                           |  10.5000                                                        |                                                                 | S                                                               | 23.00000                                                        |  10.5000                                                        |\n",
       "| 1299                                                            | 1                                                               | Widener, Mr. George Dunton                                      | male                                                            | 50.0                                                            | 1                                                               | 1                                                               | 113503                                                          | 211.5000                                                        | C80                                                             | C                                                               | 50.00000                                                        | 211.5000                                                        |\n",
       "| 1300                                                            | 3                                                               | Riordan, Miss. Johanna Hannah\"\"                                 | female                                                          |   NA                                                            | 0                                                               | 0                                                               | 334915                                                          |   7.7208                                                        |                                                                 | Q                                                               | 30.27259                                                        |   7.7208                                                        |\n",
       "| 1301                                                            | 3                                                               | Peacock, Miss. Treasteall                                       | female                                                          |  3.0                                                            | 1                                                               | 1                                                               | SOTON/O.Q. 3101315                                              |  13.7750                                                        |                                                                 | S                                                               |  3.00000                                                        |  13.7750                                                        |\n",
       "| 1302                                                            | 3                                                               | Naughton, Miss. Hannah                                          | female                                                          |   NA                                                            | 0                                                               | 0                                                               | 365237                                                          |   7.7500                                                        |                                                                 | Q                                                               | 30.27259                                                        |   7.7500                                                        |\n",
       "| 1303                                                            | 1                                                               | Minahan, Mrs. William Edward (Lillian E Thorpe)                 | female                                                          | 37.0                                                            | 1                                                               | 0                                                               | 19928                                                           |  90.0000                                                        | C78                                                             | Q                                                               | 37.00000                                                        |  90.0000                                                        |\n",
       "| 1304                                                            | 3                                                               | Henriksson, Miss. Jenny Lovisa                                  | female                                                          | 28.0                                                            | 0                                                               | 0                                                               | 347086                                                          |   7.7750                                                        |                                                                 | S                                                               | 28.00000                                                        |   7.7750                                                        |\n",
       "| 1305                                                            | 3                                                               | Spector, Mr. Woolf                                              | male                                                            |   NA                                                            | 0                                                               | 0                                                               | A.5. 3236                                                       |   8.0500                                                        |                                                                 | S                                                               | 30.27259                                                        |   8.0500                                                        |\n",
       "| 1306                                                            | 1                                                               | Oliva y Ocana, Dona. Fermina                                    | female                                                          | 39.0                                                            | 0                                                               | 0                                                               | PC 17758                                                        | 108.9000                                                        | C105                                                            | C                                                               | 39.00000                                                        | 108.9000                                                        |\n",
       "| 1307                                                            | 3                                                               | Saether, Mr. Simon Sivertsen                                    | male                                                            | 38.5                                                            | 0                                                               | 0                                                               | SOTON/O.Q. 3101262                                              |   7.2500                                                        |                                                                 | S                                                               | 38.50000                                                        |   7.2500                                                        |\n",
       "| 1308                                                            | 3                                                               | Ware, Mr. Frederick                                             | male                                                            |   NA                                                            | 0                                                               | 0                                                               | 359309                                                          |   8.0500                                                        |                                                                 | S                                                               | 30.27259                                                        |   8.0500                                                        |\n",
       "| 1309                                                            | 3                                                               | Peter, Master. Michael J                                        | male                                                            |   NA                                                            | 1                                                               | 1                                                               | 2668                                                            |  22.3583                                                        |                                                                 | C                                                               | 30.27259                                                        |  22.3583                                                        |\n",
       "\n"
      ],
      "text/plain": [
       "    PassengerId Pclass\n",
       "1   892         3     \n",
       "2   893         3     \n",
       "3   894         2     \n",
       "4   895         3     \n",
       "5   896         3     \n",
       "6   897         3     \n",
       "7   898         3     \n",
       "8   899         2     \n",
       "9   900         3     \n",
       "10  901         3     \n",
       "11  902         3     \n",
       "12  903         1     \n",
       "13  904         1     \n",
       "14  905         2     \n",
       "15  906         1     \n",
       "16  907         2     \n",
       "17  908         2     \n",
       "18  909         3     \n",
       "19  910         3     \n",
       "20  911         3     \n",
       "21  912         1     \n",
       "22  913         3     \n",
       "23  914         1     \n",
       "24  915         1     \n",
       "25  916         1     \n",
       "26  917         3     \n",
       "27  918         1     \n",
       "28  919         3     \n",
       "29  920         1     \n",
       "30  921         3     \n",
       "... ...         ...   \n",
       "389 1280        3     \n",
       "390 1281        3     \n",
       "391 1282        1     \n",
       "392 1283        1     \n",
       "393 1284        3     \n",
       "394 1285        2     \n",
       "395 1286        3     \n",
       "396 1287        1     \n",
       "397 1288        3     \n",
       "398 1289        1     \n",
       "399 1290        3     \n",
       "400 1291        3     \n",
       "401 1292        1     \n",
       "402 1293        2     \n",
       "403 1294        1     \n",
       "404 1295        1     \n",
       "405 1296        1     \n",
       "406 1297        2     \n",
       "407 1298        2     \n",
       "408 1299        1     \n",
       "409 1300        3     \n",
       "410 1301        3     \n",
       "411 1302        3     \n",
       "412 1303        1     \n",
       "413 1304        3     \n",
       "414 1305        3     \n",
       "415 1306        1     \n",
       "416 1307        3     \n",
       "417 1308        3     \n",
       "418 1309        3     \n",
       "    Name                                                            Sex    Age \n",
       "1   Kelly, Mr. James                                                male   34.5\n",
       "2   Wilkes, Mrs. James (Ellen Needs)                                female 47.0\n",
       "3   Myles, Mr. Thomas Francis                                       male   62.0\n",
       "4   Wirz, Mr. Albert                                                male   27.0\n",
       "5   Hirvonen, Mrs. Alexander (Helga E Lindqvist)                    female 22.0\n",
       "6   Svensson, Mr. Johan Cervin                                      male   14.0\n",
       "7   Connolly, Miss. Kate                                            female 30.0\n",
       "8   Caldwell, Mr. Albert Francis                                    male   26.0\n",
       "9   Abrahim, Mrs. Joseph (Sophie Halaut Easu)                       female 18.0\n",
       "10  Davies, Mr. John Samuel                                         male   21.0\n",
       "11  Ilieff, Mr. Ylio                                                male     NA\n",
       "12  Jones, Mr. Charles Cresson                                      male   46.0\n",
       "13  Snyder, Mrs. John Pillsbury (Nelle Stevenson)                   female 23.0\n",
       "14  Howard, Mr. Benjamin                                            male   63.0\n",
       "15  Chaffee, Mrs. Herbert Fuller (Carrie Constance Toogood)         female 47.0\n",
       "16  del Carlo, Mrs. Sebastiano (Argenia Genovesi)                   female 24.0\n",
       "17  Keane, Mr. Daniel                                               male   35.0\n",
       "18  Assaf, Mr. Gerios                                               male   21.0\n",
       "19  Ilmakangas, Miss. Ida Livija                                    female 27.0\n",
       "20  Assaf Khalil, Mrs. Mariana (Miriam\")\"                           female 45.0\n",
       "21  Rothschild, Mr. Martin                                          male   55.0\n",
       "22  Olsen, Master. Artur Karl                                       male    9.0\n",
       "23  Flegenheim, Mrs. Alfred (Antoinette)                            female   NA\n",
       "24  Williams, Mr. Richard Norris II                                 male   21.0\n",
       "25  Ryerson, Mrs. Arthur Larned (Emily Maria Borie)                 female 48.0\n",
       "26  Robins, Mr. Alexander A                                         male   50.0\n",
       "27  Ostby, Miss. Helene Ragnhild                                    female 22.0\n",
       "28  Daher, Mr. Shedid                                               male   22.5\n",
       "29  Brady, Mr. John Bertram                                         male   41.0\n",
       "30  Samaan, Mr. Elias                                               male     NA\n",
       "... ...                                                             ...    ... \n",
       "389 Canavan, Mr. Patrick                                            male   21.0\n",
       "390 Palsson, Master. Paul Folke                                     male    6.0\n",
       "391 Payne, Mr. Vivian Ponsonby                                      male   23.0\n",
       "392 Lines, Mrs. Ernest H (Elizabeth Lindsey James)                  female 51.0\n",
       "393 Abbott, Master. Eugene Joseph                                   male   13.0\n",
       "394 Gilbert, Mr. William                                            male   47.0\n",
       "395 Kink-Heilmann, Mr. Anton                                        male   29.0\n",
       "396 Smith, Mrs. Lucien Philip (Mary Eloise Hughes)                  female 18.0\n",
       "397 Colbert, Mr. Patrick                                            male   24.0\n",
       "398 Frolicher-Stehli, Mrs. Maxmillian (Margaretha Emerentia Stehli) female 48.0\n",
       "399 Larsson-Rondberg, Mr. Edvard A                                  male   22.0\n",
       "400 Conlon, Mr. Thomas Henry                                        male   31.0\n",
       "401 Bonnell, Miss. Caroline                                         female 30.0\n",
       "402 Gale, Mr. Harry                                                 male   38.0\n",
       "403 Gibson, Miss. Dorothy Winifred                                  female 22.0\n",
       "404 Carrau, Mr. Jose Pedro                                          male   17.0\n",
       "405 Frauenthal, Mr. Isaac Gerald                                    male   43.0\n",
       "406 Nourney, Mr. Alfred (Baron von Drachstedt\")\"                    male   20.0\n",
       "407 Ware, Mr. William Jeffery                                       male   23.0\n",
       "408 Widener, Mr. George Dunton                                      male   50.0\n",
       "409 Riordan, Miss. Johanna Hannah\"\"                                 female   NA\n",
       "410 Peacock, Miss. Treasteall                                       female  3.0\n",
       "411 Naughton, Miss. Hannah                                          female   NA\n",
       "412 Minahan, Mrs. William Edward (Lillian E Thorpe)                 female 37.0\n",
       "413 Henriksson, Miss. Jenny Lovisa                                  female 28.0\n",
       "414 Spector, Mr. Woolf                                              male     NA\n",
       "415 Oliva y Ocana, Dona. Fermina                                    female 39.0\n",
       "416 Saether, Mr. Simon Sivertsen                                    male   38.5\n",
       "417 Ware, Mr. Frederick                                             male     NA\n",
       "418 Peter, Master. Michael J                                        male     NA\n",
       "    SibSp Parch Ticket             Fare     Cabin           Embarked\n",
       "1   0     0     330911               7.8292                 Q       \n",
       "2   1     0     363272               7.0000                 S       \n",
       "3   0     0     240276               9.6875                 Q       \n",
       "4   0     0     315154               8.6625                 S       \n",
       "5   1     1     3101298             12.2875                 S       \n",
       "6   0     0     7538                 9.2250                 S       \n",
       "7   0     0     330972               7.6292                 Q       \n",
       "8   1     1     248738              29.0000                 S       \n",
       "9   0     0     2657                 7.2292                 C       \n",
       "10  2     0     A/4 48871           24.1500                 S       \n",
       "11  0     0     349220               7.8958                 S       \n",
       "12  0     0     694                 26.0000                 S       \n",
       "13  1     0     21228               82.2667 B45             S       \n",
       "14  1     0     24065               26.0000                 S       \n",
       "15  1     0     W.E.P. 5734         61.1750 E31             S       \n",
       "16  1     0     SC/PARIS 2167       27.7208                 C       \n",
       "17  0     0     233734              12.3500                 Q       \n",
       "18  0     0     2692                 7.2250                 C       \n",
       "19  1     0     STON/O2. 3101270     7.9250                 S       \n",
       "20  0     0     2696                 7.2250                 C       \n",
       "21  1     0     PC 17603            59.4000                 C       \n",
       "22  0     1     C 17368              3.1708                 S       \n",
       "23  0     0     PC 17598            31.6833                 S       \n",
       "24  0     1     PC 17597            61.3792                 C       \n",
       "25  1     3     PC 17608           262.3750 B57 B59 B63 B66 C       \n",
       "26  1     0     A/5. 3337           14.5000                 S       \n",
       "27  0     1     113509              61.9792 B36             C       \n",
       "28  0     0     2698                 7.2250                 C       \n",
       "29  0     0     113054              30.5000 A21             S       \n",
       "30  2     0     2662                21.6792                 C       \n",
       "... ...   ...   ...                ...      ...             ...     \n",
       "389 0     0     364858               7.7500                 Q       \n",
       "390 3     1     349909              21.0750                 S       \n",
       "391 0     0     12749               93.5000 B24             S       \n",
       "392 0     1     PC 17592            39.4000 D28             S       \n",
       "393 0     2     C.A. 2673           20.2500                 S       \n",
       "394 0     0     C.A. 30769          10.5000                 S       \n",
       "395 3     1     315153              22.0250                 S       \n",
       "396 1     0     13695               60.0000 C31             S       \n",
       "397 0     0     371109               7.2500                 Q       \n",
       "398 1     1     13567               79.2000 B41             C       \n",
       "399 0     0     347065               7.7750                 S       \n",
       "400 0     0     21332                7.7333                 Q       \n",
       "401 0     0     36928              164.8667 C7              S       \n",
       "402 1     0     28664               21.0000                 S       \n",
       "403 0     1     112378              59.4000                 C       \n",
       "404 0     0     113059              47.1000                 S       \n",
       "405 1     0     17765               27.7208 D40             C       \n",
       "406 0     0     SC/PARIS 2166       13.8625 D38             C       \n",
       "407 1     0     28666               10.5000                 S       \n",
       "408 1     1     113503             211.5000 C80             C       \n",
       "409 0     0     334915               7.7208                 Q       \n",
       "410 1     1     SOTON/O.Q. 3101315  13.7750                 S       \n",
       "411 0     0     365237               7.7500                 Q       \n",
       "412 1     0     19928               90.0000 C78             Q       \n",
       "413 0     0     347086               7.7750                 S       \n",
       "414 0     0     A.5. 3236            8.0500                 S       \n",
       "415 0     0     PC 17758           108.9000 C105            C       \n",
       "416 0     0     SOTON/O.Q. 3101262   7.2500                 S       \n",
       "417 0     0     359309               8.0500                 S       \n",
       "418 1     1     2668                22.3583                 C       \n",
       "    replace_mean_age replace_mean_fare\n",
       "1   34.50000           7.8292         \n",
       "2   47.00000           7.0000         \n",
       "3   62.00000           9.6875         \n",
       "4   27.00000           8.6625         \n",
       "5   22.00000          12.2875         \n",
       "6   14.00000           9.2250         \n",
       "7   30.00000           7.6292         \n",
       "8   26.00000          29.0000         \n",
       "9   18.00000           7.2292         \n",
       "10  21.00000          24.1500         \n",
       "11  30.27259           7.8958         \n",
       "12  46.00000          26.0000         \n",
       "13  23.00000          82.2667         \n",
       "14  63.00000          26.0000         \n",
       "15  47.00000          61.1750         \n",
       "16  24.00000          27.7208         \n",
       "17  35.00000          12.3500         \n",
       "18  21.00000           7.2250         \n",
       "19  27.00000           7.9250         \n",
       "20  45.00000           7.2250         \n",
       "21  55.00000          59.4000         \n",
       "22   9.00000           3.1708         \n",
       "23  30.27259          31.6833         \n",
       "24  21.00000          61.3792         \n",
       "25  48.00000         262.3750         \n",
       "26  50.00000          14.5000         \n",
       "27  22.00000          61.9792         \n",
       "28  22.50000           7.2250         \n",
       "29  41.00000          30.5000         \n",
       "30  30.27259          21.6792         \n",
       "... ...              ...              \n",
       "389 21.00000           7.7500         \n",
       "390  6.00000          21.0750         \n",
       "391 23.00000          93.5000         \n",
       "392 51.00000          39.4000         \n",
       "393 13.00000          20.2500         \n",
       "394 47.00000          10.5000         \n",
       "395 29.00000          22.0250         \n",
       "396 18.00000          60.0000         \n",
       "397 24.00000           7.2500         \n",
       "398 48.00000          79.2000         \n",
       "399 22.00000           7.7750         \n",
       "400 31.00000           7.7333         \n",
       "401 30.00000         164.8667         \n",
       "402 38.00000          21.0000         \n",
       "403 22.00000          59.4000         \n",
       "404 17.00000          47.1000         \n",
       "405 43.00000          27.7208         \n",
       "406 20.00000          13.8625         \n",
       "407 23.00000          10.5000         \n",
       "408 50.00000         211.5000         \n",
       "409 30.27259           7.7208         \n",
       "410  3.00000          13.7750         \n",
       "411 30.27259           7.7500         \n",
       "412 37.00000          90.0000         \n",
       "413 28.00000           7.7750         \n",
       "414 30.27259           8.0500         \n",
       "415 39.00000         108.9000         \n",
       "416 38.50000           7.2500         \n",
       "417 30.27259           8.0500         \n",
       "418 30.27259          22.3583         "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_titanic_replace"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "86"
      ],
      "text/latex": [
       "86"
      ],
      "text/markdown": [
       "86"
      ],
      "text/plain": [
       "[1] 86"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "sum(is.na(df_titanic_replace$Age))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "0"
      ],
      "text/latex": [
       "0"
      ],
      "text/markdown": [
       "0"
      ],
      "text/plain": [
       "[1] 0"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "sum(is.na(df_titanic_replace$replace_mean_age))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Step 4) We can replace the missing observations with the median as well."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<table>\n",
       "<thead><tr><th scope=col>PassengerId</th><th scope=col>Pclass</th><th scope=col>Name</th><th scope=col>Sex</th><th scope=col>Age</th><th scope=col>SibSp</th><th scope=col>Parch</th><th scope=col>Ticket</th><th scope=col>Fare</th><th scope=col>Cabin</th><th scope=col>Embarked</th><th scope=col>replace_median_age</th><th scope=col>replace_median_fare</th></tr></thead>\n",
       "<tbody>\n",
       "\t<tr><td>892                                         </td><td>3                                           </td><td>Kelly, Mr. James                            </td><td>male                                        </td><td>34.5                                        </td><td>0                                           </td><td>0                                           </td><td>330911                                      </td><td> 7.8292                                     </td><td>                                            </td><td>Q                                           </td><td>34.5                                        </td><td> 7.8292                                     </td></tr>\n",
       "\t<tr><td>893                                         </td><td>3                                           </td><td>Wilkes, Mrs. James (Ellen Needs)            </td><td>female                                      </td><td>47.0                                        </td><td>1                                           </td><td>0                                           </td><td>363272                                      </td><td> 7.0000                                     </td><td>                                            </td><td>S                                           </td><td>47.0                                        </td><td> 7.0000                                     </td></tr>\n",
       "\t<tr><td>894                                         </td><td>2                                           </td><td>Myles, Mr. Thomas Francis                   </td><td>male                                        </td><td>62.0                                        </td><td>0                                           </td><td>0                                           </td><td>240276                                      </td><td> 9.6875                                     </td><td>                                            </td><td>Q                                           </td><td>62.0                                        </td><td> 9.6875                                     </td></tr>\n",
       "\t<tr><td>895                                         </td><td>3                                           </td><td>Wirz, Mr. Albert                            </td><td>male                                        </td><td>27.0                                        </td><td>0                                           </td><td>0                                           </td><td>315154                                      </td><td> 8.6625                                     </td><td>                                            </td><td>S                                           </td><td>27.0                                        </td><td> 8.6625                                     </td></tr>\n",
       "\t<tr><td>896                                         </td><td>3                                           </td><td>Hirvonen, Mrs. Alexander (Helga E Lindqvist)</td><td>female                                      </td><td>22.0                                        </td><td>1                                           </td><td>1                                           </td><td>3101298                                     </td><td>12.2875                                     </td><td>                                            </td><td>S                                           </td><td>22.0                                        </td><td>12.2875                                     </td></tr>\n",
       "\t<tr><td>897                                         </td><td>3                                           </td><td>Svensson, Mr. Johan Cervin                  </td><td>male                                        </td><td>14.0                                        </td><td>0                                           </td><td>0                                           </td><td>7538                                        </td><td> 9.2250                                     </td><td>                                            </td><td>S                                           </td><td>14.0                                        </td><td> 9.2250                                     </td></tr>\n",
       "</tbody>\n",
       "</table>\n"
      ],
      "text/latex": [
       "\\begin{tabular}{r|lllllllllllll}\n",
       " PassengerId & Pclass & Name & Sex & Age & SibSp & Parch & Ticket & Fare & Cabin & Embarked & replace\\_median\\_age & replace\\_median\\_fare\\\\\n",
       "\\hline\n",
       "\t 892                                          & 3                                            & Kelly, Mr. James                             & male                                         & 34.5                                         & 0                                            & 0                                            & 330911                                       &  7.8292                                      &                                              & Q                                            & 34.5                                         &  7.8292                                     \\\\\n",
       "\t 893                                          & 3                                            & Wilkes, Mrs. James (Ellen Needs)             & female                                       & 47.0                                         & 1                                            & 0                                            & 363272                                       &  7.0000                                      &                                              & S                                            & 47.0                                         &  7.0000                                     \\\\\n",
       "\t 894                                          & 2                                            & Myles, Mr. Thomas Francis                    & male                                         & 62.0                                         & 0                                            & 0                                            & 240276                                       &  9.6875                                      &                                              & Q                                            & 62.0                                         &  9.6875                                     \\\\\n",
       "\t 895                                          & 3                                            & Wirz, Mr. Albert                             & male                                         & 27.0                                         & 0                                            & 0                                            & 315154                                       &  8.6625                                      &                                              & S                                            & 27.0                                         &  8.6625                                     \\\\\n",
       "\t 896                                          & 3                                            & Hirvonen, Mrs. Alexander (Helga E Lindqvist) & female                                       & 22.0                                         & 1                                            & 1                                            & 3101298                                      & 12.2875                                      &                                              & S                                            & 22.0                                         & 12.2875                                     \\\\\n",
       "\t 897                                          & 3                                            & Svensson, Mr. Johan Cervin                   & male                                         & 14.0                                         & 0                                            & 0                                            & 7538                                         &  9.2250                                      &                                              & S                                            & 14.0                                         &  9.2250                                     \\\\\n",
       "\\end{tabular}\n"
      ],
      "text/markdown": [
       "\n",
       "| PassengerId | Pclass | Name | Sex | Age | SibSp | Parch | Ticket | Fare | Cabin | Embarked | replace_median_age | replace_median_fare |\n",
       "|---|---|---|---|---|---|---|---|---|---|---|---|---|\n",
       "| 892                                          | 3                                            | Kelly, Mr. James                             | male                                         | 34.5                                         | 0                                            | 0                                            | 330911                                       |  7.8292                                      |                                              | Q                                            | 34.5                                         |  7.8292                                      |\n",
       "| 893                                          | 3                                            | Wilkes, Mrs. James (Ellen Needs)             | female                                       | 47.0                                         | 1                                            | 0                                            | 363272                                       |  7.0000                                      |                                              | S                                            | 47.0                                         |  7.0000                                      |\n",
       "| 894                                          | 2                                            | Myles, Mr. Thomas Francis                    | male                                         | 62.0                                         | 0                                            | 0                                            | 240276                                       |  9.6875                                      |                                              | Q                                            | 62.0                                         |  9.6875                                      |\n",
       "| 895                                          | 3                                            | Wirz, Mr. Albert                             | male                                         | 27.0                                         | 0                                            | 0                                            | 315154                                       |  8.6625                                      |                                              | S                                            | 27.0                                         |  8.6625                                      |\n",
       "| 896                                          | 3                                            | Hirvonen, Mrs. Alexander (Helga E Lindqvist) | female                                       | 22.0                                         | 1                                            | 1                                            | 3101298                                      | 12.2875                                      |                                              | S                                            | 22.0                                         | 12.2875                                      |\n",
       "| 897                                          | 3                                            | Svensson, Mr. Johan Cervin                   | male                                         | 14.0                                         | 0                                            | 0                                            | 7538                                         |  9.2250                                      |                                              | S                                            | 14.0                                         |  9.2250                                      |\n",
       "\n"
      ],
      "text/plain": [
       "  PassengerId Pclass Name                                         Sex    Age \n",
       "1 892         3      Kelly, Mr. James                             male   34.5\n",
       "2 893         3      Wilkes, Mrs. James (Ellen Needs)             female 47.0\n",
       "3 894         2      Myles, Mr. Thomas Francis                    male   62.0\n",
       "4 895         3      Wirz, Mr. Albert                             male   27.0\n",
       "5 896         3      Hirvonen, Mrs. Alexander (Helga E Lindqvist) female 22.0\n",
       "6 897         3      Svensson, Mr. Johan Cervin                   male   14.0\n",
       "  SibSp Parch Ticket  Fare    Cabin Embarked replace_median_age\n",
       "1 0     0     330911   7.8292       Q        34.5              \n",
       "2 1     0     363272   7.0000       S        47.0              \n",
       "3 0     0     240276   9.6875       Q        62.0              \n",
       "4 0     0     315154   8.6625       S        27.0              \n",
       "5 1     1     3101298 12.2875       S        22.0              \n",
       "6 0     0     7538     9.2250       S        14.0              \n",
       "  replace_median_fare\n",
       "1  7.8292            \n",
       "2  7.0000            \n",
       "3  9.6875            \n",
       "4  8.6625            \n",
       "5 12.2875            \n",
       "6  9.2250            "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "median_missing <- apply(df_titanic[,colnames(df_titanic) %in% list_na],2,\n",
    "      median,\n",
    "      na.rm =  TRUE)\n",
    "df_titanic_replace <- df_titanic %>%\n",
    "            mutate(replace_median_age  = ifelse(is.na(Age), median_missing[1], Age), \n",
    "            replace_median_fare = ifelse(is.na(Fare), median_missing[2], Fare))\n",
    "head(df_titanic_replace)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Step 5) A big data set could have lots of missing values and the above method could be cumbersome. We can execute all the above steps above in one line of code using sapply() method. Though we would not know the vales of mean and median.\n",
    "\n",
    "sapply does not create a data frame, so we can wrap the sapply() function within data.frame() to create a data frame object."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Quick code to replace missing values with the mean\n",
    "df_titanic_impute_mean <- data.frame(\n",
    "    sapply(\n",
    "        df_titanic,\n",
    "        function(x) ifelse(is.na(x),\n",
    "            mean(x, na.rm = TRUE),\n",
    "            x)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<table>\n",
       "<thead><tr><th scope=col>PassengerId</th><th scope=col>Pclass</th><th scope=col>Name</th><th scope=col>Sex</th><th scope=col>Age</th><th scope=col>SibSp</th><th scope=col>Parch</th><th scope=col>Ticket</th><th scope=col>Fare</th><th scope=col>Cabin</th><th scope=col>Embarked</th></tr></thead>\n",
       "<tbody>\n",
       "\t<tr><td>892     </td><td>3       </td><td>210     </td><td>2       </td><td>34.50000</td><td>0       </td><td>0       </td><td>153     </td><td>  7.8292</td><td> 1      </td><td>2       </td></tr>\n",
       "\t<tr><td>893     </td><td>3       </td><td>409     </td><td>1       </td><td>47.00000</td><td>1       </td><td>0       </td><td>222     </td><td>  7.0000</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>894     </td><td>2       </td><td>273     </td><td>2       </td><td>62.00000</td><td>0       </td><td>0       </td><td> 74     </td><td>  9.6875</td><td> 1      </td><td>2       </td></tr>\n",
       "\t<tr><td>895     </td><td>3       </td><td>414     </td><td>2       </td><td>27.00000</td><td>0       </td><td>0       </td><td>148     </td><td>  8.6625</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>896     </td><td>3       </td><td>182     </td><td>1       </td><td>22.00000</td><td>1       </td><td>1       </td><td>139     </td><td> 12.2875</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>897     </td><td>3       </td><td>370     </td><td>2       </td><td>14.00000</td><td>0       </td><td>0       </td><td>262     </td><td>  9.2250</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>898     </td><td>3       </td><td> 85     </td><td>1       </td><td>30.00000</td><td>0       </td><td>0       </td><td>159     </td><td>  7.6292</td><td> 1      </td><td>2       </td></tr>\n",
       "\t<tr><td>899     </td><td>2       </td><td> 58     </td><td>2       </td><td>26.00000</td><td>1       </td><td>1       </td><td> 85     </td><td> 29.0000</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>900     </td><td>3       </td><td>  5     </td><td>1       </td><td>18.00000</td><td>0       </td><td>0       </td><td>101     </td><td>  7.2292</td><td> 1      </td><td>1       </td></tr>\n",
       "\t<tr><td>901     </td><td>3       </td><td>104     </td><td>2       </td><td>21.00000</td><td>2       </td><td>0       </td><td>270     </td><td> 24.1500</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>902     </td><td>3       </td><td>191     </td><td>2       </td><td>30.27259</td><td>0       </td><td>0       </td><td>196     </td><td>  7.8958</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>903     </td><td>1       </td><td>200     </td><td>2       </td><td>46.00000</td><td>0       </td><td>0       </td><td>260     </td><td> 26.0000</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>904     </td><td>1       </td><td>356     </td><td>1       </td><td>23.00000</td><td>1       </td><td>0       </td><td> 53     </td><td> 82.2667</td><td>14      </td><td>3       </td></tr>\n",
       "\t<tr><td>905     </td><td>2       </td><td>188     </td><td>2       </td><td>63.00000</td><td>1       </td><td>0       </td><td> 75     </td><td> 26.0000</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>906     </td><td>1       </td><td> 70     </td><td>1       </td><td>47.00000</td><td>1       </td><td>0       </td><td>363     </td><td> 61.1750</td><td>62      </td><td>3       </td></tr>\n",
       "\t<tr><td>907     </td><td>2       </td><td>113     </td><td>1       </td><td>24.00000</td><td>1       </td><td>0       </td><td>345     </td><td> 27.7208</td><td> 1      </td><td>1       </td></tr>\n",
       "\t<tr><td>908     </td><td>2       </td><td>208     </td><td>2       </td><td>35.00000</td><td>0       </td><td>0       </td><td> 61     </td><td> 12.3500</td><td> 1      </td><td>2       </td></tr>\n",
       "\t<tr><td>909     </td><td>3       </td><td> 22     </td><td>2       </td><td>21.00000</td><td>0       </td><td>0       </td><td>120     </td><td>  7.2250</td><td> 1      </td><td>1       </td></tr>\n",
       "\t<tr><td>910     </td><td>3       </td><td>192     </td><td>1       </td><td>27.00000</td><td>1       </td><td>0       </td><td>357     </td><td>  7.9250</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>911     </td><td>3       </td><td> 21     </td><td>1       </td><td>45.00000</td><td>0       </td><td>0       </td><td>121     </td><td>  7.2250</td><td> 1      </td><td>1       </td></tr>\n",
       "\t<tr><td>912     </td><td>1       </td><td>328     </td><td>2       </td><td>55.00000</td><td>1       </td><td>0       </td><td>317     </td><td> 59.4000</td><td> 1      </td><td>1       </td></tr>\n",
       "\t<tr><td>913     </td><td>3       </td><td>288     </td><td>2       </td><td> 9.00000</td><td>0       </td><td>1       </td><td>278     </td><td>  3.1708</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>914     </td><td>1       </td><td>142     </td><td>1       </td><td>30.27259</td><td>0       </td><td>0       </td><td>315     </td><td> 31.6833</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>915     </td><td>1       </td><td>412     </td><td>2       </td><td>21.00000</td><td>0       </td><td>1       </td><td>314     </td><td> 61.3792</td><td> 1      </td><td>1       </td></tr>\n",
       "\t<tr><td>916     </td><td>1       </td><td>333     </td><td>1       </td><td>48.00000</td><td>1       </td><td>3       </td><td>320     </td><td>262.3750</td><td>17      </td><td>1       </td></tr>\n",
       "\t<tr><td>917     </td><td>3       </td><td>322     </td><td>2       </td><td>50.00000</td><td>1       </td><td>0       </td><td>274     </td><td> 14.5000</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>918     </td><td>1       </td><td>292     </td><td>1       </td><td>22.00000</td><td>0       </td><td>1       </td><td> 15     </td><td> 61.9792</td><td>12      </td><td>1       </td></tr>\n",
       "\t<tr><td>919     </td><td>3       </td><td> 98     </td><td>2       </td><td>22.50000</td><td>0       </td><td>0       </td><td>122     </td><td>  7.2250</td><td> 1      </td><td>1       </td></tr>\n",
       "\t<tr><td>920     </td><td>1       </td><td> 45     </td><td>2       </td><td>41.00000</td><td>0       </td><td>0       </td><td> 12     </td><td> 30.5000</td><td> 4      </td><td>3       </td></tr>\n",
       "\t<tr><td>921     </td><td>3       </td><td>343     </td><td>2       </td><td>30.27259</td><td>2       </td><td>0       </td><td>105     </td><td> 21.6792</td><td> 1      </td><td>1       </td></tr>\n",
       "\t<tr><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td></tr>\n",
       "\t<tr><td>1280    </td><td>3       </td><td> 59     </td><td>2       </td><td>21.00000</td><td>0       </td><td>0       </td><td>226     </td><td>  7.7500</td><td> 1      </td><td>2       </td></tr>\n",
       "\t<tr><td>1281    </td><td>3       </td><td>296     </td><td>2       </td><td> 6.00000</td><td>3       </td><td>1       </td><td>206     </td><td> 21.0750</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>1282    </td><td>1       </td><td>298     </td><td>2       </td><td>23.00000</td><td>0       </td><td>0       </td><td> 33     </td><td> 93.5000</td><td>10      </td><td>3       </td></tr>\n",
       "\t<tr><td>1283    </td><td>1       </td><td>235     </td><td>1       </td><td>51.00000</td><td>0       </td><td>1       </td><td>312     </td><td> 39.4000</td><td>55      </td><td>3       </td></tr>\n",
       "\t<tr><td>1284    </td><td>3       </td><td>  1     </td><td>2       </td><td>13.00000</td><td>0       </td><td>2       </td><td>282     </td><td> 20.2500</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>1285    </td><td>2       </td><td>159     </td><td>2       </td><td>47.00000</td><td>0       </td><td>0       </td><td>283     </td><td> 10.5000</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>1286    </td><td>3       </td><td>217     </td><td>2       </td><td>29.00000</td><td>3       </td><td>1       </td><td>147     </td><td> 22.0250</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>1287    </td><td>1       </td><td>353     </td><td>1       </td><td>18.00000</td><td>1       </td><td>0       </td><td> 38     </td><td> 60.0000</td><td>32      </td><td>3       </td></tr>\n",
       "\t<tr><td>1288    </td><td>3       </td><td> 80     </td><td>2       </td><td>24.00000</td><td>0       </td><td>0       </td><td>245     </td><td>  7.2500</td><td> 1      </td><td>2       </td></tr>\n",
       "\t<tr><td>1289    </td><td>1       </td><td>154     </td><td>1       </td><td>48.00000</td><td>1       </td><td>1       </td><td> 37     </td><td> 79.2000</td><td>13      </td><td>1       </td></tr>\n",
       "\t<tr><td>1290    </td><td>3       </td><td>228     </td><td>2       </td><td>22.00000</td><td>0       </td><td>0       </td><td>177     </td><td>  7.7750</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>1291    </td><td>3       </td><td> 84     </td><td>2       </td><td>31.00000</td><td>0       </td><td>0       </td><td> 54     </td><td>  7.7333</td><td> 1      </td><td>2       </td></tr>\n",
       "\t<tr><td>1292    </td><td>1       </td><td> 38     </td><td>1       </td><td>30.00000</td><td>0       </td><td>0       </td><td>239     </td><td>164.8667</td><td>42      </td><td>3       </td></tr>\n",
       "\t<tr><td>1293    </td><td>2       </td><td>155     </td><td>2       </td><td>38.00000</td><td>1       </td><td>0       </td><td>129     </td><td> 21.0000</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>1294    </td><td>1       </td><td>157     </td><td>1       </td><td>22.00000</td><td>0       </td><td>1       </td><td>  8     </td><td> 59.4000</td><td> 1      </td><td>1       </td></tr>\n",
       "\t<tr><td>1295    </td><td>1       </td><td> 65     </td><td>2       </td><td>17.00000</td><td>0       </td><td>0       </td><td> 13     </td><td> 47.1000</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>1296    </td><td>1       </td><td>153     </td><td>2       </td><td>43.00000</td><td>1       </td><td>0       </td><td> 45     </td><td> 27.7208</td><td>60      </td><td>1       </td></tr>\n",
       "\t<tr><td>1297    </td><td>2       </td><td>283     </td><td>2       </td><td>20.00000</td><td>0       </td><td>0       </td><td>344     </td><td> 13.8625</td><td>59      </td><td>1       </td></tr>\n",
       "\t<tr><td>1298    </td><td>2       </td><td>392     </td><td>2       </td><td>23.00000</td><td>1       </td><td>0       </td><td>130     </td><td> 10.5000</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>1299    </td><td>1       </td><td>406     </td><td>2       </td><td>50.00000</td><td>1       </td><td>1       </td><td> 14     </td><td>211.5000</td><td>44      </td><td>1       </td></tr>\n",
       "\t<tr><td>1300    </td><td>3       </td><td>320     </td><td>1       </td><td>30.27259</td><td>0       </td><td>0       </td><td>161     </td><td>  7.7208</td><td> 1      </td><td>2       </td></tr>\n",
       "\t<tr><td>1301    </td><td>3       </td><td>300     </td><td>1       </td><td> 3.00000</td><td>1       </td><td>1       </td><td>352     </td><td> 13.7750</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>1302    </td><td>3       </td><td>277     </td><td>1       </td><td>30.27259</td><td>0       </td><td>0       </td><td>229     </td><td>  7.7500</td><td> 1      </td><td>2       </td></tr>\n",
       "\t<tr><td>1303    </td><td>1       </td><td>266     </td><td>1       </td><td>37.00000</td><td>1       </td><td>0       </td><td> 49     </td><td> 90.0000</td><td>43      </td><td>2       </td></tr>\n",
       "\t<tr><td>1304    </td><td>3       </td><td>176     </td><td>1       </td><td>28.00000</td><td>0       </td><td>0       </td><td>185     </td><td>  7.7750</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>1305    </td><td>3       </td><td>357     </td><td>2       </td><td>30.27259</td><td>0       </td><td>0       </td><td>268     </td><td>  8.0500</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>1306    </td><td>1       </td><td>287     </td><td>1       </td><td>39.00000</td><td>0       </td><td>0       </td><td>325     </td><td>108.9000</td><td>24      </td><td>1       </td></tr>\n",
       "\t<tr><td>1307    </td><td>3       </td><td>336     </td><td>2       </td><td>38.50000</td><td>0       </td><td>0       </td><td>347     </td><td>  7.2500</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>1308    </td><td>3       </td><td>390     </td><td>2       </td><td>30.27259</td><td>0       </td><td>0       </td><td>221     </td><td>  8.0500</td><td> 1      </td><td>3       </td></tr>\n",
       "\t<tr><td>1309    </td><td>3       </td><td>306     </td><td>2       </td><td>30.27259</td><td>1       </td><td>1       </td><td>106     </td><td> 22.3583</td><td> 1      </td><td>1       </td></tr>\n",
       "</tbody>\n",
       "</table>\n"
      ],
      "text/latex": [
       "\\begin{tabular}{r|lllllllllll}\n",
       " PassengerId & Pclass & Name & Sex & Age & SibSp & Parch & Ticket & Fare & Cabin & Embarked\\\\\n",
       "\\hline\n",
       "\t 892      & 3        & 210      & 2        & 34.50000 & 0        & 0        & 153      &   7.8292 &  1       & 2       \\\\\n",
       "\t 893      & 3        & 409      & 1        & 47.00000 & 1        & 0        & 222      &   7.0000 &  1       & 3       \\\\\n",
       "\t 894      & 2        & 273      & 2        & 62.00000 & 0        & 0        &  74      &   9.6875 &  1       & 2       \\\\\n",
       "\t 895      & 3        & 414      & 2        & 27.00000 & 0        & 0        & 148      &   8.6625 &  1       & 3       \\\\\n",
       "\t 896      & 3        & 182      & 1        & 22.00000 & 1        & 1        & 139      &  12.2875 &  1       & 3       \\\\\n",
       "\t 897      & 3        & 370      & 2        & 14.00000 & 0        & 0        & 262      &   9.2250 &  1       & 3       \\\\\n",
       "\t 898      & 3        &  85      & 1        & 30.00000 & 0        & 0        & 159      &   7.6292 &  1       & 2       \\\\\n",
       "\t 899      & 2        &  58      & 2        & 26.00000 & 1        & 1        &  85      &  29.0000 &  1       & 3       \\\\\n",
       "\t 900      & 3        &   5      & 1        & 18.00000 & 0        & 0        & 101      &   7.2292 &  1       & 1       \\\\\n",
       "\t 901      & 3        & 104      & 2        & 21.00000 & 2        & 0        & 270      &  24.1500 &  1       & 3       \\\\\n",
       "\t 902      & 3        & 191      & 2        & 30.27259 & 0        & 0        & 196      &   7.8958 &  1       & 3       \\\\\n",
       "\t 903      & 1        & 200      & 2        & 46.00000 & 0        & 0        & 260      &  26.0000 &  1       & 3       \\\\\n",
       "\t 904      & 1        & 356      & 1        & 23.00000 & 1        & 0        &  53      &  82.2667 & 14       & 3       \\\\\n",
       "\t 905      & 2        & 188      & 2        & 63.00000 & 1        & 0        &  75      &  26.0000 &  1       & 3       \\\\\n",
       "\t 906      & 1        &  70      & 1        & 47.00000 & 1        & 0        & 363      &  61.1750 & 62       & 3       \\\\\n",
       "\t 907      & 2        & 113      & 1        & 24.00000 & 1        & 0        & 345      &  27.7208 &  1       & 1       \\\\\n",
       "\t 908      & 2        & 208      & 2        & 35.00000 & 0        & 0        &  61      &  12.3500 &  1       & 2       \\\\\n",
       "\t 909      & 3        &  22      & 2        & 21.00000 & 0        & 0        & 120      &   7.2250 &  1       & 1       \\\\\n",
       "\t 910      & 3        & 192      & 1        & 27.00000 & 1        & 0        & 357      &   7.9250 &  1       & 3       \\\\\n",
       "\t 911      & 3        &  21      & 1        & 45.00000 & 0        & 0        & 121      &   7.2250 &  1       & 1       \\\\\n",
       "\t 912      & 1        & 328      & 2        & 55.00000 & 1        & 0        & 317      &  59.4000 &  1       & 1       \\\\\n",
       "\t 913      & 3        & 288      & 2        &  9.00000 & 0        & 1        & 278      &   3.1708 &  1       & 3       \\\\\n",
       "\t 914      & 1        & 142      & 1        & 30.27259 & 0        & 0        & 315      &  31.6833 &  1       & 3       \\\\\n",
       "\t 915      & 1        & 412      & 2        & 21.00000 & 0        & 1        & 314      &  61.3792 &  1       & 1       \\\\\n",
       "\t 916      & 1        & 333      & 1        & 48.00000 & 1        & 3        & 320      & 262.3750 & 17       & 1       \\\\\n",
       "\t 917      & 3        & 322      & 2        & 50.00000 & 1        & 0        & 274      &  14.5000 &  1       & 3       \\\\\n",
       "\t 918      & 1        & 292      & 1        & 22.00000 & 0        & 1        &  15      &  61.9792 & 12       & 1       \\\\\n",
       "\t 919      & 3        &  98      & 2        & 22.50000 & 0        & 0        & 122      &   7.2250 &  1       & 1       \\\\\n",
       "\t 920      & 1        &  45      & 2        & 41.00000 & 0        & 0        &  12      &  30.5000 &  4       & 3       \\\\\n",
       "\t 921      & 3        & 343      & 2        & 30.27259 & 2        & 0        & 105      &  21.6792 &  1       & 1       \\\\\n",
       "\t ... & ... & ... & ... & ... & ... & ... & ... & ... & ... & ...\\\\\n",
       "\t 1280     & 3        &  59      & 2        & 21.00000 & 0        & 0        & 226      &   7.7500 &  1       & 2       \\\\\n",
       "\t 1281     & 3        & 296      & 2        &  6.00000 & 3        & 1        & 206      &  21.0750 &  1       & 3       \\\\\n",
       "\t 1282     & 1        & 298      & 2        & 23.00000 & 0        & 0        &  33      &  93.5000 & 10       & 3       \\\\\n",
       "\t 1283     & 1        & 235      & 1        & 51.00000 & 0        & 1        & 312      &  39.4000 & 55       & 3       \\\\\n",
       "\t 1284     & 3        &   1      & 2        & 13.00000 & 0        & 2        & 282      &  20.2500 &  1       & 3       \\\\\n",
       "\t 1285     & 2        & 159      & 2        & 47.00000 & 0        & 0        & 283      &  10.5000 &  1       & 3       \\\\\n",
       "\t 1286     & 3        & 217      & 2        & 29.00000 & 3        & 1        & 147      &  22.0250 &  1       & 3       \\\\\n",
       "\t 1287     & 1        & 353      & 1        & 18.00000 & 1        & 0        &  38      &  60.0000 & 32       & 3       \\\\\n",
       "\t 1288     & 3        &  80      & 2        & 24.00000 & 0        & 0        & 245      &   7.2500 &  1       & 2       \\\\\n",
       "\t 1289     & 1        & 154      & 1        & 48.00000 & 1        & 1        &  37      &  79.2000 & 13       & 1       \\\\\n",
       "\t 1290     & 3        & 228      & 2        & 22.00000 & 0        & 0        & 177      &   7.7750 &  1       & 3       \\\\\n",
       "\t 1291     & 3        &  84      & 2        & 31.00000 & 0        & 0        &  54      &   7.7333 &  1       & 2       \\\\\n",
       "\t 1292     & 1        &  38      & 1        & 30.00000 & 0        & 0        & 239      & 164.8667 & 42       & 3       \\\\\n",
       "\t 1293     & 2        & 155      & 2        & 38.00000 & 1        & 0        & 129      &  21.0000 &  1       & 3       \\\\\n",
       "\t 1294     & 1        & 157      & 1        & 22.00000 & 0        & 1        &   8      &  59.4000 &  1       & 1       \\\\\n",
       "\t 1295     & 1        &  65      & 2        & 17.00000 & 0        & 0        &  13      &  47.1000 &  1       & 3       \\\\\n",
       "\t 1296     & 1        & 153      & 2        & 43.00000 & 1        & 0        &  45      &  27.7208 & 60       & 1       \\\\\n",
       "\t 1297     & 2        & 283      & 2        & 20.00000 & 0        & 0        & 344      &  13.8625 & 59       & 1       \\\\\n",
       "\t 1298     & 2        & 392      & 2        & 23.00000 & 1        & 0        & 130      &  10.5000 &  1       & 3       \\\\\n",
       "\t 1299     & 1        & 406      & 2        & 50.00000 & 1        & 1        &  14      & 211.5000 & 44       & 1       \\\\\n",
       "\t 1300     & 3        & 320      & 1        & 30.27259 & 0        & 0        & 161      &   7.7208 &  1       & 2       \\\\\n",
       "\t 1301     & 3        & 300      & 1        &  3.00000 & 1        & 1        & 352      &  13.7750 &  1       & 3       \\\\\n",
       "\t 1302     & 3        & 277      & 1        & 30.27259 & 0        & 0        & 229      &   7.7500 &  1       & 2       \\\\\n",
       "\t 1303     & 1        & 266      & 1        & 37.00000 & 1        & 0        &  49      &  90.0000 & 43       & 2       \\\\\n",
       "\t 1304     & 3        & 176      & 1        & 28.00000 & 0        & 0        & 185      &   7.7750 &  1       & 3       \\\\\n",
       "\t 1305     & 3        & 357      & 2        & 30.27259 & 0        & 0        & 268      &   8.0500 &  1       & 3       \\\\\n",
       "\t 1306     & 1        & 287      & 1        & 39.00000 & 0        & 0        & 325      & 108.9000 & 24       & 1       \\\\\n",
       "\t 1307     & 3        & 336      & 2        & 38.50000 & 0        & 0        & 347      &   7.2500 &  1       & 3       \\\\\n",
       "\t 1308     & 3        & 390      & 2        & 30.27259 & 0        & 0        & 221      &   8.0500 &  1       & 3       \\\\\n",
       "\t 1309     & 3        & 306      & 2        & 30.27259 & 1        & 1        & 106      &  22.3583 &  1       & 1       \\\\\n",
       "\\end{tabular}\n"
      ],
      "text/markdown": [
       "\n",
       "| PassengerId | Pclass | Name | Sex | Age | SibSp | Parch | Ticket | Fare | Cabin | Embarked |\n",
       "|---|---|---|---|---|---|---|---|---|---|---|\n",
       "| 892      | 3        | 210      | 2        | 34.50000 | 0        | 0        | 153      |   7.8292 |  1       | 2        |\n",
       "| 893      | 3        | 409      | 1        | 47.00000 | 1        | 0        | 222      |   7.0000 |  1       | 3        |\n",
       "| 894      | 2        | 273      | 2        | 62.00000 | 0        | 0        |  74      |   9.6875 |  1       | 2        |\n",
       "| 895      | 3        | 414      | 2        | 27.00000 | 0        | 0        | 148      |   8.6625 |  1       | 3        |\n",
       "| 896      | 3        | 182      | 1        | 22.00000 | 1        | 1        | 139      |  12.2875 |  1       | 3        |\n",
       "| 897      | 3        | 370      | 2        | 14.00000 | 0        | 0        | 262      |   9.2250 |  1       | 3        |\n",
       "| 898      | 3        |  85      | 1        | 30.00000 | 0        | 0        | 159      |   7.6292 |  1       | 2        |\n",
       "| 899      | 2        |  58      | 2        | 26.00000 | 1        | 1        |  85      |  29.0000 |  1       | 3        |\n",
       "| 900      | 3        |   5      | 1        | 18.00000 | 0        | 0        | 101      |   7.2292 |  1       | 1        |\n",
       "| 901      | 3        | 104      | 2        | 21.00000 | 2        | 0        | 270      |  24.1500 |  1       | 3        |\n",
       "| 902      | 3        | 191      | 2        | 30.27259 | 0        | 0        | 196      |   7.8958 |  1       | 3        |\n",
       "| 903      | 1        | 200      | 2        | 46.00000 | 0        | 0        | 260      |  26.0000 |  1       | 3        |\n",
       "| 904      | 1        | 356      | 1        | 23.00000 | 1        | 0        |  53      |  82.2667 | 14       | 3        |\n",
       "| 905      | 2        | 188      | 2        | 63.00000 | 1        | 0        |  75      |  26.0000 |  1       | 3        |\n",
       "| 906      | 1        |  70      | 1        | 47.00000 | 1        | 0        | 363      |  61.1750 | 62       | 3        |\n",
       "| 907      | 2        | 113      | 1        | 24.00000 | 1        | 0        | 345      |  27.7208 |  1       | 1        |\n",
       "| 908      | 2        | 208      | 2        | 35.00000 | 0        | 0        |  61      |  12.3500 |  1       | 2        |\n",
       "| 909      | 3        |  22      | 2        | 21.00000 | 0        | 0        | 120      |   7.2250 |  1       | 1        |\n",
       "| 910      | 3        | 192      | 1        | 27.00000 | 1        | 0        | 357      |   7.9250 |  1       | 3        |\n",
       "| 911      | 3        |  21      | 1        | 45.00000 | 0        | 0        | 121      |   7.2250 |  1       | 1        |\n",
       "| 912      | 1        | 328      | 2        | 55.00000 | 1        | 0        | 317      |  59.4000 |  1       | 1        |\n",
       "| 913      | 3        | 288      | 2        |  9.00000 | 0        | 1        | 278      |   3.1708 |  1       | 3        |\n",
       "| 914      | 1        | 142      | 1        | 30.27259 | 0        | 0        | 315      |  31.6833 |  1       | 3        |\n",
       "| 915      | 1        | 412      | 2        | 21.00000 | 0        | 1        | 314      |  61.3792 |  1       | 1        |\n",
       "| 916      | 1        | 333      | 1        | 48.00000 | 1        | 3        | 320      | 262.3750 | 17       | 1        |\n",
       "| 917      | 3        | 322      | 2        | 50.00000 | 1        | 0        | 274      |  14.5000 |  1       | 3        |\n",
       "| 918      | 1        | 292      | 1        | 22.00000 | 0        | 1        |  15      |  61.9792 | 12       | 1        |\n",
       "| 919      | 3        |  98      | 2        | 22.50000 | 0        | 0        | 122      |   7.2250 |  1       | 1        |\n",
       "| 920      | 1        |  45      | 2        | 41.00000 | 0        | 0        |  12      |  30.5000 |  4       | 3        |\n",
       "| 921      | 3        | 343      | 2        | 30.27259 | 2        | 0        | 105      |  21.6792 |  1       | 1        |\n",
       "| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |\n",
       "| 1280     | 3        |  59      | 2        | 21.00000 | 0        | 0        | 226      |   7.7500 |  1       | 2        |\n",
       "| 1281     | 3        | 296      | 2        |  6.00000 | 3        | 1        | 206      |  21.0750 |  1       | 3        |\n",
       "| 1282     | 1        | 298      | 2        | 23.00000 | 0        | 0        |  33      |  93.5000 | 10       | 3        |\n",
       "| 1283     | 1        | 235      | 1        | 51.00000 | 0        | 1        | 312      |  39.4000 | 55       | 3        |\n",
       "| 1284     | 3        |   1      | 2        | 13.00000 | 0        | 2        | 282      |  20.2500 |  1       | 3        |\n",
       "| 1285     | 2        | 159      | 2        | 47.00000 | 0        | 0        | 283      |  10.5000 |  1       | 3        |\n",
       "| 1286     | 3        | 217      | 2        | 29.00000 | 3        | 1        | 147      |  22.0250 |  1       | 3        |\n",
       "| 1287     | 1        | 353      | 1        | 18.00000 | 1        | 0        |  38      |  60.0000 | 32       | 3        |\n",
       "| 1288     | 3        |  80      | 2        | 24.00000 | 0        | 0        | 245      |   7.2500 |  1       | 2        |\n",
       "| 1289     | 1        | 154      | 1        | 48.00000 | 1        | 1        |  37      |  79.2000 | 13       | 1        |\n",
       "| 1290     | 3        | 228      | 2        | 22.00000 | 0        | 0        | 177      |   7.7750 |  1       | 3        |\n",
       "| 1291     | 3        |  84      | 2        | 31.00000 | 0        | 0        |  54      |   7.7333 |  1       | 2        |\n",
       "| 1292     | 1        |  38      | 1        | 30.00000 | 0        | 0        | 239      | 164.8667 | 42       | 3        |\n",
       "| 1293     | 2        | 155      | 2        | 38.00000 | 1        | 0        | 129      |  21.0000 |  1       | 3        |\n",
       "| 1294     | 1        | 157      | 1        | 22.00000 | 0        | 1        |   8      |  59.4000 |  1       | 1        |\n",
       "| 1295     | 1        |  65      | 2        | 17.00000 | 0        | 0        |  13      |  47.1000 |  1       | 3        |\n",
       "| 1296     | 1        | 153      | 2        | 43.00000 | 1        | 0        |  45      |  27.7208 | 60       | 1        |\n",
       "| 1297     | 2        | 283      | 2        | 20.00000 | 0        | 0        | 344      |  13.8625 | 59       | 1        |\n",
       "| 1298     | 2        | 392      | 2        | 23.00000 | 1        | 0        | 130      |  10.5000 |  1       | 3        |\n",
       "| 1299     | 1        | 406      | 2        | 50.00000 | 1        | 1        |  14      | 211.5000 | 44       | 1        |\n",
       "| 1300     | 3        | 320      | 1        | 30.27259 | 0        | 0        | 161      |   7.7208 |  1       | 2        |\n",
       "| 1301     | 3        | 300      | 1        |  3.00000 | 1        | 1        | 352      |  13.7750 |  1       | 3        |\n",
       "| 1302     | 3        | 277      | 1        | 30.27259 | 0        | 0        | 229      |   7.7500 |  1       | 2        |\n",
       "| 1303     | 1        | 266      | 1        | 37.00000 | 1        | 0        |  49      |  90.0000 | 43       | 2        |\n",
       "| 1304     | 3        | 176      | 1        | 28.00000 | 0        | 0        | 185      |   7.7750 |  1       | 3        |\n",
       "| 1305     | 3        | 357      | 2        | 30.27259 | 0        | 0        | 268      |   8.0500 |  1       | 3        |\n",
       "| 1306     | 1        | 287      | 1        | 39.00000 | 0        | 0        | 325      | 108.9000 | 24       | 1        |\n",
       "| 1307     | 3        | 336      | 2        | 38.50000 | 0        | 0        | 347      |   7.2500 |  1       | 3        |\n",
       "| 1308     | 3        | 390      | 2        | 30.27259 | 0        | 0        | 221      |   8.0500 |  1       | 3        |\n",
       "| 1309     | 3        | 306      | 2        | 30.27259 | 1        | 1        | 106      |  22.3583 |  1       | 1        |\n",
       "\n"
      ],
      "text/plain": [
       "    PassengerId Pclass Name Sex Age      SibSp Parch Ticket Fare     Cabin\n",
       "1   892         3      210  2   34.50000 0     0     153      7.8292  1   \n",
       "2   893         3      409  1   47.00000 1     0     222      7.0000  1   \n",
       "3   894         2      273  2   62.00000 0     0      74      9.6875  1   \n",
       "4   895         3      414  2   27.00000 0     0     148      8.6625  1   \n",
       "5   896         3      182  1   22.00000 1     1     139     12.2875  1   \n",
       "6   897         3      370  2   14.00000 0     0     262      9.2250  1   \n",
       "7   898         3       85  1   30.00000 0     0     159      7.6292  1   \n",
       "8   899         2       58  2   26.00000 1     1      85     29.0000  1   \n",
       "9   900         3        5  1   18.00000 0     0     101      7.2292  1   \n",
       "10  901         3      104  2   21.00000 2     0     270     24.1500  1   \n",
       "11  902         3      191  2   30.27259 0     0     196      7.8958  1   \n",
       "12  903         1      200  2   46.00000 0     0     260     26.0000  1   \n",
       "13  904         1      356  1   23.00000 1     0      53     82.2667 14   \n",
       "14  905         2      188  2   63.00000 1     0      75     26.0000  1   \n",
       "15  906         1       70  1   47.00000 1     0     363     61.1750 62   \n",
       "16  907         2      113  1   24.00000 1     0     345     27.7208  1   \n",
       "17  908         2      208  2   35.00000 0     0      61     12.3500  1   \n",
       "18  909         3       22  2   21.00000 0     0     120      7.2250  1   \n",
       "19  910         3      192  1   27.00000 1     0     357      7.9250  1   \n",
       "20  911         3       21  1   45.00000 0     0     121      7.2250  1   \n",
       "21  912         1      328  2   55.00000 1     0     317     59.4000  1   \n",
       "22  913         3      288  2    9.00000 0     1     278      3.1708  1   \n",
       "23  914         1      142  1   30.27259 0     0     315     31.6833  1   \n",
       "24  915         1      412  2   21.00000 0     1     314     61.3792  1   \n",
       "25  916         1      333  1   48.00000 1     3     320    262.3750 17   \n",
       "26  917         3      322  2   50.00000 1     0     274     14.5000  1   \n",
       "27  918         1      292  1   22.00000 0     1      15     61.9792 12   \n",
       "28  919         3       98  2   22.50000 0     0     122      7.2250  1   \n",
       "29  920         1       45  2   41.00000 0     0      12     30.5000  4   \n",
       "30  921         3      343  2   30.27259 2     0     105     21.6792  1   \n",
       "... ...         ...    ...  ... ...      ...   ...   ...    ...      ...  \n",
       "389 1280        3       59  2   21.00000 0     0     226      7.7500  1   \n",
       "390 1281        3      296  2    6.00000 3     1     206     21.0750  1   \n",
       "391 1282        1      298  2   23.00000 0     0      33     93.5000 10   \n",
       "392 1283        1      235  1   51.00000 0     1     312     39.4000 55   \n",
       "393 1284        3        1  2   13.00000 0     2     282     20.2500  1   \n",
       "394 1285        2      159  2   47.00000 0     0     283     10.5000  1   \n",
       "395 1286        3      217  2   29.00000 3     1     147     22.0250  1   \n",
       "396 1287        1      353  1   18.00000 1     0      38     60.0000 32   \n",
       "397 1288        3       80  2   24.00000 0     0     245      7.2500  1   \n",
       "398 1289        1      154  1   48.00000 1     1      37     79.2000 13   \n",
       "399 1290        3      228  2   22.00000 0     0     177      7.7750  1   \n",
       "400 1291        3       84  2   31.00000 0     0      54      7.7333  1   \n",
       "401 1292        1       38  1   30.00000 0     0     239    164.8667 42   \n",
       "402 1293        2      155  2   38.00000 1     0     129     21.0000  1   \n",
       "403 1294        1      157  1   22.00000 0     1       8     59.4000  1   \n",
       "404 1295        1       65  2   17.00000 0     0      13     47.1000  1   \n",
       "405 1296        1      153  2   43.00000 1     0      45     27.7208 60   \n",
       "406 1297        2      283  2   20.00000 0     0     344     13.8625 59   \n",
       "407 1298        2      392  2   23.00000 1     0     130     10.5000  1   \n",
       "408 1299        1      406  2   50.00000 1     1      14    211.5000 44   \n",
       "409 1300        3      320  1   30.27259 0     0     161      7.7208  1   \n",
       "410 1301        3      300  1    3.00000 1     1     352     13.7750  1   \n",
       "411 1302        3      277  1   30.27259 0     0     229      7.7500  1   \n",
       "412 1303        1      266  1   37.00000 1     0      49     90.0000 43   \n",
       "413 1304        3      176  1   28.00000 0     0     185      7.7750  1   \n",
       "414 1305        3      357  2   30.27259 0     0     268      8.0500  1   \n",
       "415 1306        1      287  1   39.00000 0     0     325    108.9000 24   \n",
       "416 1307        3      336  2   38.50000 0     0     347      7.2500  1   \n",
       "417 1308        3      390  2   30.27259 0     0     221      8.0500  1   \n",
       "418 1309        3      306  2   30.27259 1     1     106     22.3583  1   \n",
       "    Embarked\n",
       "1   2       \n",
       "2   3       \n",
       "3   2       \n",
       "4   3       \n",
       "5   3       \n",
       "6   3       \n",
       "7   2       \n",
       "8   3       \n",
       "9   1       \n",
       "10  3       \n",
       "11  3       \n",
       "12  3       \n",
       "13  3       \n",
       "14  3       \n",
       "15  3       \n",
       "16  1       \n",
       "17  2       \n",
       "18  1       \n",
       "19  3       \n",
       "20  1       \n",
       "21  1       \n",
       "22  3       \n",
       "23  3       \n",
       "24  1       \n",
       "25  1       \n",
       "26  3       \n",
       "27  1       \n",
       "28  1       \n",
       "29  3       \n",
       "30  1       \n",
       "... ...     \n",
       "389 2       \n",
       "390 3       \n",
       "391 3       \n",
       "392 3       \n",
       "393 3       \n",
       "394 3       \n",
       "395 3       \n",
       "396 3       \n",
       "397 2       \n",
       "398 1       \n",
       "399 3       \n",
       "400 2       \n",
       "401 3       \n",
       "402 3       \n",
       "403 1       \n",
       "404 3       \n",
       "405 1       \n",
       "406 1       \n",
       "407 3       \n",
       "408 1       \n",
       "409 2       \n",
       "410 3       \n",
       "411 2       \n",
       "412 2       \n",
       "413 3       \n",
       "414 3       \n",
       "415 1       \n",
       "416 3       \n",
       "417 3       \n",
       "418 1       "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_titanic_impute_mean"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "R",
   "language": "R",
   "name": "ir"
  },
  "language_info": {
   "codemirror_mode": "r",
   "file_extension": ".r",
   "mimetype": "text/x-r-source",
   "name": "R",
   "pygments_lexer": "r",
   "version": "3.6.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}