{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Python Questions\n",
"## Due: "
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"import numpy as np\n",
"import pandas as pd\n",
"import sqlite3 as sql\n",
"from sklearn import linear_model"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Question 1\n",
"\n",
"## Prepare the ship data stored in \"ship.csv\" for future analytics tasks using functions and methods of NumPy and pandas, respectively. \n",
"\n",
"### (A) Design your own Python program to carry out the following tasks:\n",
"\n",
"#### (i) Read in \"ship.csv\" as pandas DataFrame called \"ship\". Since there are 6 observations where MS and Y are \".\" to indicate that they are missing values, declare this character as missing values in your program accordingly. "
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [
{
"data": {
   "text/html": [
   "<div>\n",
   "<style scoped>\n",
   " .dataframe tbody tr th:only-of-type {\n",
   "    vertical-align: middle;\n",
   " }\n",
   "\n",
   " .dataframe tbody tr th {\n",
   "    vertical-align: top;\n",
   " }\n",
   "\n",
   " .dataframe thead th {\n",
   "    text-align: right;\n",
   " }\n",
   "</style>\n",
   "<table border=\"1\" class=\"dataframe\">\n",
   " <thead>\n",
   " <tr style=\"text-align: right;\">\n",
   "    <th></th>\n",
   "    <th>T</th>\n",
   "    <th>A</th>\n",
   "    <th>P</th>\n",
   "    <th>MS</th>\n",
   "    <th>Y</th>\n",
   " </tr>\n",
   " </thead>\n",
   " <tbody>\n",
   " <tr>\n",
   "    <th>0</th>\n",
   "    <td>1</td>\n",
   "    <td>1</td>\n",
   "    <td>1</td>\n",
   "    <td>127</td>\n",
   "    <td>0</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>1</th>\n",
   "    <td>1</td>\n",
   "    <td>1</td>\n",
   "    <td>2</td>\n",
   "    <td>63</td>\n",
   "    <td>0</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>2</th>\n",
   "    <td>1</td>\n",
   "    <td>2</td>\n",
   "    <td>1</td>\n",
   "    <td>1095</td>\n",
   "    <td>3</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>3</th>\n",
   "    <td>1</td>\n",
   "    <td>2</td>\n",
   "    <td>2</td>\n",
   "    <td>1095</td>\n",
   "    <td>4</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>4</th>\n",
   "    <td>1</td>\n",
   "    <td>3</td>\n",
   "    <td>1</td>\n",
   "    <td>1512</td>\n",
   "    <td>6</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>5</th>\n",
   "    <td>1</td>\n",
   "    <td>3</td>\n",
   "    <td>2</td>\n",
   "    <td>3353</td>\n",
   "    <td>18</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>6</th>\n",
   "    <td>1</td>\n",
   "    <td>4</td>\n",
   "    <td>1</td>\n",
   "    <td>-1</td>\n",
   "    <td>-1</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>7</th>\n",
   "    <td>1</td>\n",
   "    <td>4</td>\n",
   "    <td>2</td>\n",
   "    <td>2244</td>\n",
   "    <td>11</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>8</th>\n",
   "    <td>2</td>\n",
   "    <td>1</td>\n",
   "    <td>1</td>\n",
   "    <td>44882</td>\n",
   "    <td>39</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>9</th>\n",
   "    <td>2</td>\n",
   "    <td>1</td>\n",
   "    <td>2</td>\n",
   "    <td>17176</td>\n",
   "    <td>29</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>10</th>\n",
   "    <td>2</td>\n",
   "    <td>2</td>\n",
   "    <td>1</td>\n",
   "    <td>28609</td>\n",
   "    <td>58</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>11</th>\n",
   "    <td>2</td>\n",
   "    <td>2</td>\n",
   "    <td>2</td>\n",
   "    <td>20370</td>\n",
   "    <td>53</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>12</th>\n",
   "    <td>2</td>\n",
   "    <td>3</td>\n",
   "    <td>1</td>\n",
   "    <td>7064</td>\n",
   "    <td>12</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>13</th>\n",
   "    <td>2</td>\n",
   "    <td>3</td>\n",
   "    <td>2</td>\n",
   "    <td>13099</td>\n",
   "    <td>44</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>14</th>\n",
   "    <td>2</td>\n",
   "    <td>4</td>\n",
   "    <td>1</td>\n",
   "    <td>-1</td>\n",
   "    <td>-1</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>15</th>\n",
   "    <td>2</td>\n",
   "    <td>4</td>\n",
   "    <td>2</td>\n",
   "    <td>7117</td>\n",
   "    <td>18</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>16</th>\n",
   "    <td>3</td>\n",
   "    <td>1</td>\n",
   "    <td>1</td>\n",
   "    <td>1179</td>\n",
   "    <td>1</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>17</th>\n",
   "    <td>3</td>\n",
   "    <td>1</td>\n",
   "    <td>2</td>\n",
   "    <td>552</td>\n",
   "    <td>1</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>18</th>\n",
   "    <td>3</td>\n",
   "    <td>2</td>\n",
   "    <td>1</td>\n",
   "    <td>781</td>\n",
   "    <td>0</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>19</th>\n",
   "    <td>3</td>\n",
   "    <td>2</td>\n",
   "    <td>2</td>\n",
   "    <td>676</td>\n",
   "    <td>1</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>20</th>\n",
   "    <td>3</td>\n",
   "    <td>3</td>\n",
   "    <td>1</td>\n",
   "    <td>783</td>\n",
   "    <td>6</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>21</th>\n",
   "    <td>3</td>\n",
   "    <td>3</td>\n",
   "    <td>2</td>\n",
   "    <td>1948</td>\n",
   "    <td>2</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>22</th>\n",
   "    <td>3</td>\n",
   "    <td>4</td>\n",
   "    <td>1</td>\n",
   "    <td>-1</td>\n",
   "    <td>-1</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>23</th>\n",
   "    <td>3</td>\n",
   "    <td>4</td>\n",
   "    <td>2</td>\n",
   "    <td>274</td>\n",
   "    <td>1</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>24</th>\n",
   "    <td>4</td>\n",
   "    <td>1</td>\n",
   "    <td>1</td>\n",
   "    <td>251</td>\n",
   "    <td>0</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>25</th>\n",
   "    <td>4</td>\n",
   "    <td>1</td>\n",
   "    <td>2</td>\n",
   "    <td>105</td>\n",
   "    <td>0</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>26</th>\n",
   "    <td>4</td>\n",
   "    <td>2</td>\n",
   "    <td>1</td>\n",
   "    <td>288</td>\n",
   "    <td>0</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>27</th>\n",
   "    <td>4</td>\n",
   "    <td>2</td>\n",
   "    <td>2</td>\n",
   "    <td>192</td>\n",
   "    <td>0</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>28</th>\n",
   "    <td>4</td>\n",
   "    <td>3</td>\n",
   "    <td>1</td>\n",
   "    <td>349</td>\n",
   "    <td>2</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>29</th>\n",
   "    <td>4</td>\n",
   "    <td>3</td>\n",
   "    <td>2</td>\n",
   "    <td>1208</td>\n",
   "    <td>11</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>30</th>\n",
   "    <td>4</td>\n",
   "    <td>4</td>\n",
   "    <td>1</td>\n",
   "    <td>-1</td>\n",
   "    <td>-1</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>31</th>\n",
   "    <td>4</td>\n",
   "    <td>4</td>\n",
   "    <td>2</td>\n",
   "    <td>2051</td>\n",
   "    <td>4</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>32</th>\n",
   "    <td>5</td>\n",
   "    <td>1</td>\n",
   "    <td>1</td>\n",
   "    <td>45</td>\n",
   "    <td>0</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>33</th>\n",
   "    <td>5</td>\n",
   "    <td>1</td>\n",
   "    <td>2</td>\n",
   "    <td>-1</td>\n",
   "    <td>-1</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>34</th>\n",
   "    <td>5</td>\n",
   "    <td>2</td>\n",
   "    <td>1</td>\n",
   "    <td>789</td>\n",
   "    <td>7</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>35</th>\n",
   "    <td>5</td>\n",
   "    <td>2</td>\n",
   "    <td>2</td>\n",
   "    <td>437</td>\n",
   "    <td>7</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>36</th>\n",
   "    <td>5</td>\n",
   "    <td>3</td>\n",
   "    <td>1</td>\n",
   "    <td>1157</td>\n",
   "    <td>5</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>37</th>\n",
   "    <td>5</td>\n",
   "    <td>3</td>\n",
   "    <td>2</td>\n",
   "    <td>2161</td>\n",
   "    <td>12</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>38</th>\n",
   "    <td>5</td>\n",
   "    <td>4</td>\n",
   "    <td>1</td>\n",
   "    <td>-1</td>\n",
   "    <td>-1</td>\n",
   " </tr>\n",
   " <tr>\n",
   "    <th>39</th>\n",
   "    <td>5</td>\n",
   "    <td>4</td>\n",
   "    <td>2</td>\n",
   "    <td>542</td>\n",
   "    <td>1</td>\n",
   " </tr>\n",
   " </tbody>\n",
   "</table>\n",
   "</div>"
   ],
   "text/plain": [
   " T A P MS Y\n",
   "0 1 1 1 127 0\n",
   "1 1 1 2 63 0\n",
   "2 1 2 1 1095 3\n",
   "3 1 2 2 1095 4\n",
   "4 1 3 1 1512 6\n",

Project 2: O-O Blackjack In this project,you will write a multi-cl...