Created
April 11, 2020 15:01
-
-
Save craine/df0a79c5b16438dbfd5b538210bd8d0c to your computer and use it in GitHub Desktop.
Titanic - how to drop rows in pandas.ipynb
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"nbformat": 4, | |
"nbformat_minor": 0, | |
"metadata": { | |
"colab": { | |
"name": "Titanic - how to drop rows in pandas.ipynb", | |
"provenance": [], | |
"include_colab_link": true | |
}, | |
"kernelspec": { | |
"name": "python3", | |
"display_name": "Python 3" | |
} | |
}, | |
"cells": [ | |
{ | |
"cell_type": "markdown", | |
"metadata": { | |
"id": "view-in-github", | |
"colab_type": "text" | |
}, | |
"source": [ | |
"<a href=\"https://colab.research.google.com/gist/craine/df0a79c5b16438dbfd5b538210bd8d0c/titanic-how-to-drop-rows-in-pandas.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>" | |
] | |
}, | |
{ | |
"cell_type": "markdown", | |
"metadata": { | |
"id": "6DSpykHJR20e", | |
"colab_type": "text" | |
}, | |
"source": [ | |
"**Goal**:\n", | |
"Learn how to drop columns in pandas" | |
] | |
}, | |
{ | |
"cell_type": "markdown", | |
"metadata": { | |
"id": "m5w8W0PrSK-O", | |
"colab_type": "text" | |
}, | |
"source": [ | |
"We need data. Titanic data works great for this exercise. " | |
] | |
}, | |
{ | |
"cell_type": "code", | |
"metadata": { | |
"id": "XMDAawmHRtAc", | |
"colab_type": "code", | |
"colab": {} | |
}, | |
"source": [ | |
"#load pandas library\n", | |
"import pandas as pd\n", | |
"\n", | |
"#load the Titanic CSV to the dataset\n", | |
"titanic = pd.read_csv('https://raw.githubusercontent.com/pcsanwald/kaggle-titanic/master/train.csv')" | |
], | |
"execution_count": 0, | |
"outputs": [] | |
}, | |
{ | |
"cell_type": "code", | |
"metadata": { | |
"id": "rFs-P0_TVIdp", | |
"colab_type": "code", | |
"outputId": "1cdd9244-179f-4bb0-dded-74a82a61e8ae", | |
"colab": { | |
"base_uri": "https://localhost:8080/", | |
"height": 204 | |
} | |
}, | |
"source": [ | |
"#view the first five rows of the titanic dataframe \n", | |
"titanic.head(5)" | |
], | |
"execution_count": 2, | |
"outputs": [ | |
{ | |
"output_type": "execute_result", | |
"data": { | |
"text/html": [ | |
"<div>\n", | |
"<style scoped>\n", | |
" .dataframe tbody tr th:only-of-type {\n", | |
" vertical-align: middle;\n", | |
" }\n", | |
"\n", | |
" .dataframe tbody tr th {\n", | |
" vertical-align: top;\n", | |
" }\n", | |
"\n", | |
" .dataframe thead th {\n", | |
" text-align: right;\n", | |
" }\n", | |
"</style>\n", | |
"<table border=\"1\" class=\"dataframe\">\n", | |
" <thead>\n", | |
" <tr style=\"text-align: right;\">\n", | |
" <th></th>\n", | |
" <th>survived</th>\n", | |
" <th>pclass</th>\n", | |
" <th>name</th>\n", | |
" <th>sex</th>\n", | |
" <th>age</th>\n", | |
" <th>sibsp</th>\n", | |
" <th>parch</th>\n", | |
" <th>ticket</th>\n", | |
" <th>fare</th>\n", | |
" <th>cabin</th>\n", | |
" <th>embarked</th>\n", | |
" </tr>\n", | |
" </thead>\n", | |
" <tbody>\n", | |
" <tr>\n", | |
" <th>0</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Braund, Mr. Owen Harris</td>\n", | |
" <td>male</td>\n", | |
" <td>22.0</td>\n", | |
" <td>1</td>\n", | |
" <td>0</td>\n", | |
" <td>A/5 21171</td>\n", | |
" <td>7.2500</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>1</th>\n", | |
" <td>1</td>\n", | |
" <td>1</td>\n", | |
" <td>Cumings, Mrs. John Bradley (Florence Briggs Th...</td>\n", | |
" <td>female</td>\n", | |
" <td>38.0</td>\n", | |
" <td>1</td>\n", | |
" <td>0</td>\n", | |
" <td>PC 17599</td>\n", | |
" <td>71.2833</td>\n", | |
" <td>C85</td>\n", | |
" <td>C</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2</th>\n", | |
" <td>1</td>\n", | |
" <td>3</td>\n", | |
" <td>Heikkinen, Miss. Laina</td>\n", | |
" <td>female</td>\n", | |
" <td>26.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>STON/O2. 3101282</td>\n", | |
" <td>7.9250</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>3</th>\n", | |
" <td>1</td>\n", | |
" <td>1</td>\n", | |
" <td>Futrelle, Mrs. Jacques Heath (Lily May Peel)</td>\n", | |
" <td>female</td>\n", | |
" <td>35.0</td>\n", | |
" <td>1</td>\n", | |
" <td>0</td>\n", | |
" <td>113803</td>\n", | |
" <td>53.1000</td>\n", | |
" <td>C123</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>4</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Allen, Mr. William Henry</td>\n", | |
" <td>male</td>\n", | |
" <td>35.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>373450</td>\n", | |
" <td>8.0500</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" </tbody>\n", | |
"</table>\n", | |
"</div>" | |
], | |
"text/plain": [ | |
" survived pclass ... cabin embarked\n", | |
"0 0 3 ... NaN S\n", | |
"1 1 1 ... C85 C\n", | |
"2 1 3 ... NaN S\n", | |
"3 1 1 ... C123 S\n", | |
"4 0 3 ... NaN S\n", | |
"\n", | |
"[5 rows x 11 columns]" | |
] | |
}, | |
"metadata": { | |
"tags": [] | |
}, | |
"execution_count": 2 | |
} | |
] | |
}, | |
{ | |
"cell_type": "markdown", | |
"metadata": { | |
"id": "Ld7jLgN-SIHn", | |
"colab_type": "text" | |
}, | |
"source": [ | |
"Next, we will drop the 0 row with Mr. Owen Harris Braund\n" | |
] | |
}, | |
{ | |
"cell_type": "code", | |
"metadata": { | |
"id": "ogvHOHNYVGRM", | |
"colab_type": "code", | |
"outputId": "4f201a42-f47f-428d-8756-99765a2841b9", | |
"colab": { | |
"base_uri": "https://localhost:8080/", | |
"height": 419 | |
} | |
}, | |
"source": [ | |
"titanic.drop([0], axis=0)" | |
], | |
"execution_count": 7, | |
"outputs": [ | |
{ | |
"output_type": "execute_result", | |
"data": { | |
"text/html": [ | |
"<div>\n", | |
"<style scoped>\n", | |
" .dataframe tbody tr th:only-of-type {\n", | |
" vertical-align: middle;\n", | |
" }\n", | |
"\n", | |
" .dataframe tbody tr th {\n", | |
" vertical-align: top;\n", | |
" }\n", | |
"\n", | |
" .dataframe thead th {\n", | |
" text-align: right;\n", | |
" }\n", | |
"</style>\n", | |
"<table border=\"1\" class=\"dataframe\">\n", | |
" <thead>\n", | |
" <tr style=\"text-align: right;\">\n", | |
" <th></th>\n", | |
" <th>survived</th>\n", | |
" <th>pclass</th>\n", | |
" <th>name</th>\n", | |
" <th>sex</th>\n", | |
" <th>age</th>\n", | |
" <th>sibsp</th>\n", | |
" <th>parch</th>\n", | |
" <th>ticket</th>\n", | |
" <th>fare</th>\n", | |
" <th>cabin</th>\n", | |
" <th>embarked</th>\n", | |
" </tr>\n", | |
" </thead>\n", | |
" <tbody>\n", | |
" <tr>\n", | |
" <th>1</th>\n", | |
" <td>1</td>\n", | |
" <td>1</td>\n", | |
" <td>Cumings, Mrs. John Bradley (Florence Briggs Th...</td>\n", | |
" <td>female</td>\n", | |
" <td>38.0</td>\n", | |
" <td>1</td>\n", | |
" <td>0</td>\n", | |
" <td>PC 17599</td>\n", | |
" <td>71.2833</td>\n", | |
" <td>C85</td>\n", | |
" <td>C</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2</th>\n", | |
" <td>1</td>\n", | |
" <td>3</td>\n", | |
" <td>Heikkinen, Miss. Laina</td>\n", | |
" <td>female</td>\n", | |
" <td>26.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>STON/O2. 3101282</td>\n", | |
" <td>7.9250</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>3</th>\n", | |
" <td>1</td>\n", | |
" <td>1</td>\n", | |
" <td>Futrelle, Mrs. Jacques Heath (Lily May Peel)</td>\n", | |
" <td>female</td>\n", | |
" <td>35.0</td>\n", | |
" <td>1</td>\n", | |
" <td>0</td>\n", | |
" <td>113803</td>\n", | |
" <td>53.1000</td>\n", | |
" <td>C123</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>4</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Allen, Mr. William Henry</td>\n", | |
" <td>male</td>\n", | |
" <td>35.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>373450</td>\n", | |
" <td>8.0500</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>5</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Moran, Mr. James</td>\n", | |
" <td>male</td>\n", | |
" <td>NaN</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>330877</td>\n", | |
" <td>8.4583</td>\n", | |
" <td>NaN</td>\n", | |
" <td>Q</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>...</th>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>886</th>\n", | |
" <td>0</td>\n", | |
" <td>2</td>\n", | |
" <td>Montvila, Rev. Juozas</td>\n", | |
" <td>male</td>\n", | |
" <td>27.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>211536</td>\n", | |
" <td>13.0000</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>887</th>\n", | |
" <td>1</td>\n", | |
" <td>1</td>\n", | |
" <td>Graham, Miss. Margaret Edith</td>\n", | |
" <td>female</td>\n", | |
" <td>19.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>112053</td>\n", | |
" <td>30.0000</td>\n", | |
" <td>B42</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>888</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Johnston, Miss. Catherine Helen \"Carrie\"</td>\n", | |
" <td>female</td>\n", | |
" <td>NaN</td>\n", | |
" <td>1</td>\n", | |
" <td>2</td>\n", | |
" <td>W./C. 6607</td>\n", | |
" <td>23.4500</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>889</th>\n", | |
" <td>1</td>\n", | |
" <td>1</td>\n", | |
" <td>Behr, Mr. Karl Howell</td>\n", | |
" <td>male</td>\n", | |
" <td>26.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>111369</td>\n", | |
" <td>30.0000</td>\n", | |
" <td>C148</td>\n", | |
" <td>C</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>890</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Dooley, Mr. Patrick</td>\n", | |
" <td>male</td>\n", | |
" <td>32.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>370376</td>\n", | |
" <td>7.7500</td>\n", | |
" <td>NaN</td>\n", | |
" <td>Q</td>\n", | |
" </tr>\n", | |
" </tbody>\n", | |
"</table>\n", | |
"<p>890 rows × 11 columns</p>\n", | |
"</div>" | |
], | |
"text/plain": [ | |
" survived pclass ... cabin embarked\n", | |
"1 1 1 ... C85 C\n", | |
"2 1 3 ... NaN S\n", | |
"3 1 1 ... C123 S\n", | |
"4 0 3 ... NaN S\n", | |
"5 0 3 ... NaN Q\n", | |
".. ... ... ... ... ...\n", | |
"886 0 2 ... NaN S\n", | |
"887 1 1 ... B42 S\n", | |
"888 0 3 ... NaN S\n", | |
"889 1 1 ... C148 C\n", | |
"890 0 3 ... NaN Q\n", | |
"\n", | |
"[890 rows x 11 columns]" | |
] | |
}, | |
"metadata": { | |
"tags": [] | |
}, | |
"execution_count": 7 | |
} | |
] | |
}, | |
{ | |
"cell_type": "markdown", | |
"metadata": { | |
"id": "K-rb_2jDVgyZ", | |
"colab_type": "text" | |
}, | |
"source": [ | |
"Now, you can see how we can drop two rows at the same time\n" | |
] | |
}, | |
{ | |
"cell_type": "code", | |
"metadata": { | |
"id": "xOwOgEtxVXpM", | |
"colab_type": "code", | |
"outputId": "1edcf4e9-3456-41de-90f3-2a86c79c3785", | |
"colab": { | |
"base_uri": "https://localhost:8080/", | |
"height": 419 | |
} | |
}, | |
"source": [ | |
"titanic.drop([1, 2], axis=0)" | |
], | |
"execution_count": 8, | |
"outputs": [ | |
{ | |
"output_type": "execute_result", | |
"data": { | |
"text/html": [ | |
"<div>\n", | |
"<style scoped>\n", | |
" .dataframe tbody tr th:only-of-type {\n", | |
" vertical-align: middle;\n", | |
" }\n", | |
"\n", | |
" .dataframe tbody tr th {\n", | |
" vertical-align: top;\n", | |
" }\n", | |
"\n", | |
" .dataframe thead th {\n", | |
" text-align: right;\n", | |
" }\n", | |
"</style>\n", | |
"<table border=\"1\" class=\"dataframe\">\n", | |
" <thead>\n", | |
" <tr style=\"text-align: right;\">\n", | |
" <th></th>\n", | |
" <th>survived</th>\n", | |
" <th>pclass</th>\n", | |
" <th>name</th>\n", | |
" <th>sex</th>\n", | |
" <th>age</th>\n", | |
" <th>sibsp</th>\n", | |
" <th>parch</th>\n", | |
" <th>ticket</th>\n", | |
" <th>fare</th>\n", | |
" <th>cabin</th>\n", | |
" <th>embarked</th>\n", | |
" </tr>\n", | |
" </thead>\n", | |
" <tbody>\n", | |
" <tr>\n", | |
" <th>0</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Braund, Mr. Owen Harris</td>\n", | |
" <td>male</td>\n", | |
" <td>22.0</td>\n", | |
" <td>1</td>\n", | |
" <td>0</td>\n", | |
" <td>A/5 21171</td>\n", | |
" <td>7.2500</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>3</th>\n", | |
" <td>1</td>\n", | |
" <td>1</td>\n", | |
" <td>Futrelle, Mrs. Jacques Heath (Lily May Peel)</td>\n", | |
" <td>female</td>\n", | |
" <td>35.0</td>\n", | |
" <td>1</td>\n", | |
" <td>0</td>\n", | |
" <td>113803</td>\n", | |
" <td>53.1000</td>\n", | |
" <td>C123</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>4</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Allen, Mr. William Henry</td>\n", | |
" <td>male</td>\n", | |
" <td>35.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>373450</td>\n", | |
" <td>8.0500</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>5</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Moran, Mr. James</td>\n", | |
" <td>male</td>\n", | |
" <td>NaN</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>330877</td>\n", | |
" <td>8.4583</td>\n", | |
" <td>NaN</td>\n", | |
" <td>Q</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>6</th>\n", | |
" <td>0</td>\n", | |
" <td>1</td>\n", | |
" <td>McCarthy, Mr. Timothy J</td>\n", | |
" <td>male</td>\n", | |
" <td>54.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>17463</td>\n", | |
" <td>51.8625</td>\n", | |
" <td>E46</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>...</th>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>886</th>\n", | |
" <td>0</td>\n", | |
" <td>2</td>\n", | |
" <td>Montvila, Rev. Juozas</td>\n", | |
" <td>male</td>\n", | |
" <td>27.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>211536</td>\n", | |
" <td>13.0000</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>887</th>\n", | |
" <td>1</td>\n", | |
" <td>1</td>\n", | |
" <td>Graham, Miss. Margaret Edith</td>\n", | |
" <td>female</td>\n", | |
" <td>19.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>112053</td>\n", | |
" <td>30.0000</td>\n", | |
" <td>B42</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>888</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Johnston, Miss. Catherine Helen \"Carrie\"</td>\n", | |
" <td>female</td>\n", | |
" <td>NaN</td>\n", | |
" <td>1</td>\n", | |
" <td>2</td>\n", | |
" <td>W./C. 6607</td>\n", | |
" <td>23.4500</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>889</th>\n", | |
" <td>1</td>\n", | |
" <td>1</td>\n", | |
" <td>Behr, Mr. Karl Howell</td>\n", | |
" <td>male</td>\n", | |
" <td>26.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>111369</td>\n", | |
" <td>30.0000</td>\n", | |
" <td>C148</td>\n", | |
" <td>C</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>890</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Dooley, Mr. Patrick</td>\n", | |
" <td>male</td>\n", | |
" <td>32.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>370376</td>\n", | |
" <td>7.7500</td>\n", | |
" <td>NaN</td>\n", | |
" <td>Q</td>\n", | |
" </tr>\n", | |
" </tbody>\n", | |
"</table>\n", | |
"<p>889 rows × 11 columns</p>\n", | |
"</div>" | |
], | |
"text/plain": [ | |
" survived pclass ... cabin embarked\n", | |
"0 0 3 ... NaN S\n", | |
"3 1 1 ... C123 S\n", | |
"4 0 3 ... NaN S\n", | |
"5 0 3 ... NaN Q\n", | |
"6 0 1 ... E46 S\n", | |
".. ... ... ... ... ...\n", | |
"886 0 2 ... NaN S\n", | |
"887 1 1 ... B42 S\n", | |
"888 0 3 ... NaN S\n", | |
"889 1 1 ... C148 C\n", | |
"890 0 3 ... NaN Q\n", | |
"\n", | |
"[889 rows x 11 columns]" | |
] | |
}, | |
"metadata": { | |
"tags": [] | |
}, | |
"execution_count": 8 | |
} | |
] | |
}, | |
{ | |
"cell_type": "code", | |
"metadata": { | |
"id": "7qjP0y7YWZZl", | |
"colab_type": "code", | |
"outputId": "44e19915-1d07-49fb-b07a-904ec78af644", | |
"colab": { | |
"base_uri": "https://localhost:8080/", | |
"height": 419 | |
} | |
}, | |
"source": [ | |
"titanic.drop([3])" | |
], | |
"execution_count": 11, | |
"outputs": [ | |
{ | |
"output_type": "execute_result", | |
"data": { | |
"text/html": [ | |
"<div>\n", | |
"<style scoped>\n", | |
" .dataframe tbody tr th:only-of-type {\n", | |
" vertical-align: middle;\n", | |
" }\n", | |
"\n", | |
" .dataframe tbody tr th {\n", | |
" vertical-align: top;\n", | |
" }\n", | |
"\n", | |
" .dataframe thead th {\n", | |
" text-align: right;\n", | |
" }\n", | |
"</style>\n", | |
"<table border=\"1\" class=\"dataframe\">\n", | |
" <thead>\n", | |
" <tr style=\"text-align: right;\">\n", | |
" <th></th>\n", | |
" <th>survived</th>\n", | |
" <th>pclass</th>\n", | |
" <th>name</th>\n", | |
" <th>sex</th>\n", | |
" <th>age</th>\n", | |
" <th>sibsp</th>\n", | |
" <th>parch</th>\n", | |
" <th>ticket</th>\n", | |
" <th>fare</th>\n", | |
" <th>cabin</th>\n", | |
" <th>embarked</th>\n", | |
" </tr>\n", | |
" </thead>\n", | |
" <tbody>\n", | |
" <tr>\n", | |
" <th>0</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Braund, Mr. Owen Harris</td>\n", | |
" <td>male</td>\n", | |
" <td>22.0</td>\n", | |
" <td>1</td>\n", | |
" <td>0</td>\n", | |
" <td>A/5 21171</td>\n", | |
" <td>7.2500</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>1</th>\n", | |
" <td>1</td>\n", | |
" <td>1</td>\n", | |
" <td>Cumings, Mrs. John Bradley (Florence Briggs Th...</td>\n", | |
" <td>female</td>\n", | |
" <td>38.0</td>\n", | |
" <td>1</td>\n", | |
" <td>0</td>\n", | |
" <td>PC 17599</td>\n", | |
" <td>71.2833</td>\n", | |
" <td>C85</td>\n", | |
" <td>C</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2</th>\n", | |
" <td>1</td>\n", | |
" <td>3</td>\n", | |
" <td>Heikkinen, Miss. Laina</td>\n", | |
" <td>female</td>\n", | |
" <td>26.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>STON/O2. 3101282</td>\n", | |
" <td>7.9250</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>4</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Allen, Mr. William Henry</td>\n", | |
" <td>male</td>\n", | |
" <td>35.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>373450</td>\n", | |
" <td>8.0500</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>5</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Moran, Mr. James</td>\n", | |
" <td>male</td>\n", | |
" <td>NaN</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>330877</td>\n", | |
" <td>8.4583</td>\n", | |
" <td>NaN</td>\n", | |
" <td>Q</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>...</th>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>886</th>\n", | |
" <td>0</td>\n", | |
" <td>2</td>\n", | |
" <td>Montvila, Rev. Juozas</td>\n", | |
" <td>male</td>\n", | |
" <td>27.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>211536</td>\n", | |
" <td>13.0000</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>887</th>\n", | |
" <td>1</td>\n", | |
" <td>1</td>\n", | |
" <td>Graham, Miss. Margaret Edith</td>\n", | |
" <td>female</td>\n", | |
" <td>19.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>112053</td>\n", | |
" <td>30.0000</td>\n", | |
" <td>B42</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>888</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Johnston, Miss. Catherine Helen \"Carrie\"</td>\n", | |
" <td>female</td>\n", | |
" <td>NaN</td>\n", | |
" <td>1</td>\n", | |
" <td>2</td>\n", | |
" <td>W./C. 6607</td>\n", | |
" <td>23.4500</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>889</th>\n", | |
" <td>1</td>\n", | |
" <td>1</td>\n", | |
" <td>Behr, Mr. Karl Howell</td>\n", | |
" <td>male</td>\n", | |
" <td>26.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>111369</td>\n", | |
" <td>30.0000</td>\n", | |
" <td>C148</td>\n", | |
" <td>C</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>890</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Dooley, Mr. Patrick</td>\n", | |
" <td>male</td>\n", | |
" <td>32.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>370376</td>\n", | |
" <td>7.7500</td>\n", | |
" <td>NaN</td>\n", | |
" <td>Q</td>\n", | |
" </tr>\n", | |
" </tbody>\n", | |
"</table>\n", | |
"<p>890 rows × 11 columns</p>\n", | |
"</div>" | |
], | |
"text/plain": [ | |
" survived pclass ... cabin embarked\n", | |
"0 0 3 ... NaN S\n", | |
"1 1 1 ... C85 C\n", | |
"2 1 3 ... NaN S\n", | |
"4 0 3 ... NaN S\n", | |
"5 0 3 ... NaN Q\n", | |
".. ... ... ... ... ...\n", | |
"886 0 2 ... NaN S\n", | |
"887 1 1 ... B42 S\n", | |
"888 0 3 ... NaN S\n", | |
"889 1 1 ... C148 C\n", | |
"890 0 3 ... NaN Q\n", | |
"\n", | |
"[890 rows x 11 columns]" | |
] | |
}, | |
"metadata": { | |
"tags": [] | |
}, | |
"execution_count": 11 | |
} | |
] | |
}, | |
{ | |
"cell_type": "code", | |
"metadata": { | |
"id": "_mCHzKmFt9D_", | |
"colab_type": "code", | |
"colab": { | |
"base_uri": "https://localhost:8080/", | |
"height": 204 | |
}, | |
"outputId": "e445c846-6ea9-4bda-fc82-795cfefcc361" | |
}, | |
"source": [ | |
"titanic.head()" | |
], | |
"execution_count": 16, | |
"outputs": [ | |
{ | |
"output_type": "execute_result", | |
"data": { | |
"text/html": [ | |
"<div>\n", | |
"<style scoped>\n", | |
" .dataframe tbody tr th:only-of-type {\n", | |
" vertical-align: middle;\n", | |
" }\n", | |
"\n", | |
" .dataframe tbody tr th {\n", | |
" vertical-align: top;\n", | |
" }\n", | |
"\n", | |
" .dataframe thead th {\n", | |
" text-align: right;\n", | |
" }\n", | |
"</style>\n", | |
"<table border=\"1\" class=\"dataframe\">\n", | |
" <thead>\n", | |
" <tr style=\"text-align: right;\">\n", | |
" <th></th>\n", | |
" <th>survived</th>\n", | |
" <th>pclass</th>\n", | |
" <th>name</th>\n", | |
" <th>sex</th>\n", | |
" <th>age</th>\n", | |
" <th>sibsp</th>\n", | |
" <th>parch</th>\n", | |
" <th>ticket</th>\n", | |
" <th>fare</th>\n", | |
" <th>cabin</th>\n", | |
" <th>embarked</th>\n", | |
" </tr>\n", | |
" </thead>\n", | |
" <tbody>\n", | |
" <tr>\n", | |
" <th>0</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Braund, Mr. Owen Harris</td>\n", | |
" <td>male</td>\n", | |
" <td>22.0</td>\n", | |
" <td>1</td>\n", | |
" <td>0</td>\n", | |
" <td>A/5 21171</td>\n", | |
" <td>7.2500</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>1</th>\n", | |
" <td>1</td>\n", | |
" <td>1</td>\n", | |
" <td>Cumings, Mrs. John Bradley (Florence Briggs Th...</td>\n", | |
" <td>female</td>\n", | |
" <td>38.0</td>\n", | |
" <td>1</td>\n", | |
" <td>0</td>\n", | |
" <td>PC 17599</td>\n", | |
" <td>71.2833</td>\n", | |
" <td>C85</td>\n", | |
" <td>C</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2</th>\n", | |
" <td>1</td>\n", | |
" <td>3</td>\n", | |
" <td>Heikkinen, Miss. Laina</td>\n", | |
" <td>female</td>\n", | |
" <td>26.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>STON/O2. 3101282</td>\n", | |
" <td>7.9250</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>3</th>\n", | |
" <td>1</td>\n", | |
" <td>1</td>\n", | |
" <td>Futrelle, Mrs. Jacques Heath (Lily May Peel)</td>\n", | |
" <td>female</td>\n", | |
" <td>35.0</td>\n", | |
" <td>1</td>\n", | |
" <td>0</td>\n", | |
" <td>113803</td>\n", | |
" <td>53.1000</td>\n", | |
" <td>C123</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>4</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Allen, Mr. William Henry</td>\n", | |
" <td>male</td>\n", | |
" <td>35.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>373450</td>\n", | |
" <td>8.0500</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" </tbody>\n", | |
"</table>\n", | |
"</div>" | |
], | |
"text/plain": [ | |
" survived pclass ... cabin embarked\n", | |
"0 0 3 ... NaN S\n", | |
"1 1 1 ... C85 C\n", | |
"2 1 3 ... NaN S\n", | |
"3 1 1 ... C123 S\n", | |
"4 0 3 ... NaN S\n", | |
"\n", | |
"[5 rows x 11 columns]" | |
] | |
}, | |
"metadata": { | |
"tags": [] | |
}, | |
"execution_count": 16 | |
} | |
] | |
}, | |
{ | |
"cell_type": "code", | |
"metadata": { | |
"id": "LlCHNRVTtqQy", | |
"colab_type": "code", | |
"colab": { | |
"base_uri": "https://localhost:8080/", | |
"height": 419 | |
}, | |
"outputId": "fb7b1811-2c06-47ef-9e37-297d8a1627f1" | |
}, | |
"source": [ | |
"titanic[titanic.sex != 'male']" | |
], | |
"execution_count": 19, | |
"outputs": [ | |
{ | |
"output_type": "execute_result", | |
"data": { | |
"text/html": [ | |
"<div>\n", | |
"<style scoped>\n", | |
" .dataframe tbody tr th:only-of-type {\n", | |
" vertical-align: middle;\n", | |
" }\n", | |
"\n", | |
" .dataframe tbody tr th {\n", | |
" vertical-align: top;\n", | |
" }\n", | |
"\n", | |
" .dataframe thead th {\n", | |
" text-align: right;\n", | |
" }\n", | |
"</style>\n", | |
"<table border=\"1\" class=\"dataframe\">\n", | |
" <thead>\n", | |
" <tr style=\"text-align: right;\">\n", | |
" <th></th>\n", | |
" <th>survived</th>\n", | |
" <th>pclass</th>\n", | |
" <th>name</th>\n", | |
" <th>sex</th>\n", | |
" <th>age</th>\n", | |
" <th>sibsp</th>\n", | |
" <th>parch</th>\n", | |
" <th>ticket</th>\n", | |
" <th>fare</th>\n", | |
" <th>cabin</th>\n", | |
" <th>embarked</th>\n", | |
" </tr>\n", | |
" </thead>\n", | |
" <tbody>\n", | |
" <tr>\n", | |
" <th>1</th>\n", | |
" <td>1</td>\n", | |
" <td>1</td>\n", | |
" <td>Cumings, Mrs. John Bradley (Florence Briggs Th...</td>\n", | |
" <td>female</td>\n", | |
" <td>38.0</td>\n", | |
" <td>1</td>\n", | |
" <td>0</td>\n", | |
" <td>PC 17599</td>\n", | |
" <td>71.2833</td>\n", | |
" <td>C85</td>\n", | |
" <td>C</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2</th>\n", | |
" <td>1</td>\n", | |
" <td>3</td>\n", | |
" <td>Heikkinen, Miss. Laina</td>\n", | |
" <td>female</td>\n", | |
" <td>26.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>STON/O2. 3101282</td>\n", | |
" <td>7.9250</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>3</th>\n", | |
" <td>1</td>\n", | |
" <td>1</td>\n", | |
" <td>Futrelle, Mrs. Jacques Heath (Lily May Peel)</td>\n", | |
" <td>female</td>\n", | |
" <td>35.0</td>\n", | |
" <td>1</td>\n", | |
" <td>0</td>\n", | |
" <td>113803</td>\n", | |
" <td>53.1000</td>\n", | |
" <td>C123</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>8</th>\n", | |
" <td>1</td>\n", | |
" <td>3</td>\n", | |
" <td>Johnson, Mrs. Oscar W (Elisabeth Vilhelmina Berg)</td>\n", | |
" <td>female</td>\n", | |
" <td>27.0</td>\n", | |
" <td>0</td>\n", | |
" <td>2</td>\n", | |
" <td>347742</td>\n", | |
" <td>11.1333</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>9</th>\n", | |
" <td>1</td>\n", | |
" <td>2</td>\n", | |
" <td>Nasser, Mrs. Nicholas (Adele Achem)</td>\n", | |
" <td>female</td>\n", | |
" <td>14.0</td>\n", | |
" <td>1</td>\n", | |
" <td>0</td>\n", | |
" <td>237736</td>\n", | |
" <td>30.0708</td>\n", | |
" <td>NaN</td>\n", | |
" <td>C</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>...</th>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>880</th>\n", | |
" <td>1</td>\n", | |
" <td>2</td>\n", | |
" <td>Shelley, Mrs. William (Imanita Parrish Hall)</td>\n", | |
" <td>female</td>\n", | |
" <td>25.0</td>\n", | |
" <td>0</td>\n", | |
" <td>1</td>\n", | |
" <td>230433</td>\n", | |
" <td>26.0000</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>882</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Dahlberg, Miss. Gerda Ulrika</td>\n", | |
" <td>female</td>\n", | |
" <td>22.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>7552</td>\n", | |
" <td>10.5167</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>885</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Rice, Mrs. William (Margaret Norton)</td>\n", | |
" <td>female</td>\n", | |
" <td>39.0</td>\n", | |
" <td>0</td>\n", | |
" <td>5</td>\n", | |
" <td>382652</td>\n", | |
" <td>29.1250</td>\n", | |
" <td>NaN</td>\n", | |
" <td>Q</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>887</th>\n", | |
" <td>1</td>\n", | |
" <td>1</td>\n", | |
" <td>Graham, Miss. Margaret Edith</td>\n", | |
" <td>female</td>\n", | |
" <td>19.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>112053</td>\n", | |
" <td>30.0000</td>\n", | |
" <td>B42</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>888</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Johnston, Miss. Catherine Helen \"Carrie\"</td>\n", | |
" <td>female</td>\n", | |
" <td>NaN</td>\n", | |
" <td>1</td>\n", | |
" <td>2</td>\n", | |
" <td>W./C. 6607</td>\n", | |
" <td>23.4500</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" </tbody>\n", | |
"</table>\n", | |
"<p>314 rows × 11 columns</p>\n", | |
"</div>" | |
], | |
"text/plain": [ | |
" survived pclass ... cabin embarked\n", | |
"1 1 1 ... C85 C\n", | |
"2 1 3 ... NaN S\n", | |
"3 1 1 ... C123 S\n", | |
"8 1 3 ... NaN S\n", | |
"9 1 2 ... NaN C\n", | |
".. ... ... ... ... ...\n", | |
"880 1 2 ... NaN S\n", | |
"882 0 3 ... NaN S\n", | |
"885 0 3 ... NaN Q\n", | |
"887 1 1 ... B42 S\n", | |
"888 0 3 ... NaN S\n", | |
"\n", | |
"[314 rows x 11 columns]" | |
] | |
}, | |
"metadata": { | |
"tags": [] | |
}, | |
"execution_count": 19 | |
} | |
] | |
}, | |
{ | |
"cell_type": "code", | |
"metadata": { | |
"id": "Ul751NYIuSBD", | |
"colab_type": "code", | |
"colab": { | |
"base_uri": "https://localhost:8080/", | |
"height": 419 | |
}, | |
"outputId": "21e91e84-1525-490d-83bd-62f2a3d18a9f" | |
}, | |
"source": [ | |
"titanic.drop(titanic.index[[2,3]])" | |
], | |
"execution_count": 21, | |
"outputs": [ | |
{ | |
"output_type": "execute_result", | |
"data": { | |
"text/html": [ | |
"<div>\n", | |
"<style scoped>\n", | |
" .dataframe tbody tr th:only-of-type {\n", | |
" vertical-align: middle;\n", | |
" }\n", | |
"\n", | |
" .dataframe tbody tr th {\n", | |
" vertical-align: top;\n", | |
" }\n", | |
"\n", | |
" .dataframe thead th {\n", | |
" text-align: right;\n", | |
" }\n", | |
"</style>\n", | |
"<table border=\"1\" class=\"dataframe\">\n", | |
" <thead>\n", | |
" <tr style=\"text-align: right;\">\n", | |
" <th></th>\n", | |
" <th>survived</th>\n", | |
" <th>pclass</th>\n", | |
" <th>name</th>\n", | |
" <th>sex</th>\n", | |
" <th>age</th>\n", | |
" <th>sibsp</th>\n", | |
" <th>parch</th>\n", | |
" <th>ticket</th>\n", | |
" <th>fare</th>\n", | |
" <th>cabin</th>\n", | |
" <th>embarked</th>\n", | |
" </tr>\n", | |
" </thead>\n", | |
" <tbody>\n", | |
" <tr>\n", | |
" <th>0</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Braund, Mr. Owen Harris</td>\n", | |
" <td>male</td>\n", | |
" <td>22.0</td>\n", | |
" <td>1</td>\n", | |
" <td>0</td>\n", | |
" <td>A/5 21171</td>\n", | |
" <td>7.2500</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>1</th>\n", | |
" <td>1</td>\n", | |
" <td>1</td>\n", | |
" <td>Cumings, Mrs. John Bradley (Florence Briggs Th...</td>\n", | |
" <td>female</td>\n", | |
" <td>38.0</td>\n", | |
" <td>1</td>\n", | |
" <td>0</td>\n", | |
" <td>PC 17599</td>\n", | |
" <td>71.2833</td>\n", | |
" <td>C85</td>\n", | |
" <td>C</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>4</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Allen, Mr. William Henry</td>\n", | |
" <td>male</td>\n", | |
" <td>35.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>373450</td>\n", | |
" <td>8.0500</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>5</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Moran, Mr. James</td>\n", | |
" <td>male</td>\n", | |
" <td>NaN</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>330877</td>\n", | |
" <td>8.4583</td>\n", | |
" <td>NaN</td>\n", | |
" <td>Q</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>6</th>\n", | |
" <td>0</td>\n", | |
" <td>1</td>\n", | |
" <td>McCarthy, Mr. Timothy J</td>\n", | |
" <td>male</td>\n", | |
" <td>54.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>17463</td>\n", | |
" <td>51.8625</td>\n", | |
" <td>E46</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>...</th>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" <td>...</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>886</th>\n", | |
" <td>0</td>\n", | |
" <td>2</td>\n", | |
" <td>Montvila, Rev. Juozas</td>\n", | |
" <td>male</td>\n", | |
" <td>27.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>211536</td>\n", | |
" <td>13.0000</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>887</th>\n", | |
" <td>1</td>\n", | |
" <td>1</td>\n", | |
" <td>Graham, Miss. Margaret Edith</td>\n", | |
" <td>female</td>\n", | |
" <td>19.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>112053</td>\n", | |
" <td>30.0000</td>\n", | |
" <td>B42</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>888</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Johnston, Miss. Catherine Helen \"Carrie\"</td>\n", | |
" <td>female</td>\n", | |
" <td>NaN</td>\n", | |
" <td>1</td>\n", | |
" <td>2</td>\n", | |
" <td>W./C. 6607</td>\n", | |
" <td>23.4500</td>\n", | |
" <td>NaN</td>\n", | |
" <td>S</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>889</th>\n", | |
" <td>1</td>\n", | |
" <td>1</td>\n", | |
" <td>Behr, Mr. Karl Howell</td>\n", | |
" <td>male</td>\n", | |
" <td>26.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>111369</td>\n", | |
" <td>30.0000</td>\n", | |
" <td>C148</td>\n", | |
" <td>C</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>890</th>\n", | |
" <td>0</td>\n", | |
" <td>3</td>\n", | |
" <td>Dooley, Mr. Patrick</td>\n", | |
" <td>male</td>\n", | |
" <td>32.0</td>\n", | |
" <td>0</td>\n", | |
" <td>0</td>\n", | |
" <td>370376</td>\n", | |
" <td>7.7500</td>\n", | |
" <td>NaN</td>\n", | |
" <td>Q</td>\n", | |
" </tr>\n", | |
" </tbody>\n", | |
"</table>\n", | |
"<p>889 rows × 11 columns</p>\n", | |
"</div>" | |
], | |
"text/plain": [ | |
" survived pclass ... cabin embarked\n", | |
"0 0 3 ... NaN S\n", | |
"1 1 1 ... C85 C\n", | |
"4 0 3 ... NaN S\n", | |
"5 0 3 ... NaN Q\n", | |
"6 0 1 ... E46 S\n", | |
".. ... ... ... ... ...\n", | |
"886 0 2 ... NaN S\n", | |
"887 1 1 ... B42 S\n", | |
"888 0 3 ... NaN S\n", | |
"889 1 1 ... C148 C\n", | |
"890 0 3 ... NaN Q\n", | |
"\n", | |
"[889 rows x 11 columns]" | |
] | |
}, | |
"metadata": { | |
"tags": [] | |
}, | |
"execution_count": 21 | |
} | |
] | |
} | |
] | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment