Skip to content

Instantly share code, notes, and snippets.

@linanqiu

linanqiu/Linear Regression.ipynb

Created May 10, 2016 05:51
Show Gist options
  • Save linanqiu/d7280feb1eb7450bc1f48fa95454dcd4 to your computer and use it in GitHub Desktop.
Save linanqiu/d7280feb1eb7450bc1f48fa95454dcd4 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
Linear Regression.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import pandas\n",
"import numpy"
]
},
{
"cell_type": "code",
"execution_count": 17,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"data = pandas.read_csv('CleanDataMay9_v2.csv')\n",
"\n",
"import re\n",
"pattern = re.compile(r'\\s+')\n",
"\n",
"data.columns = [re.sub(pattern, '', header) for header in data.columns]\n",
"data.columns = [header.replace('%', 'P') for header in data.columns]"
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"y = ['MTDUnitSls']\n",
"x = ['Color', 'Style', 'MSRP', 'Month', 'Material', 'Category', 'MTDUnitSTP']\n",
"x_to_dummies = ['Color', 'Style', 'Month', 'Material', 'Category']\n",
"x_non_dummies = ['MSRP', 'MTDUnitSTP']"
]
},
{
"cell_type": "code",
"execution_count": 19,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"x_dummies = pandas.get_dummies(data[x_to_dummies])\n",
"x_dummies.columns = [re.sub(pattern, '', header) for header in x_dummies.columns]\n",
"x_dummies.columns = [header.replace('%', 'P') for header in x_dummies.columns]"
]
},
{
"cell_type": "code",
"execution_count": 21,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>MTDUnitSls</th>\n",
" <th>MSRP</th>\n",
" <th>MTDUnitSTP</th>\n",
" <th>Month</th>\n",
" <th>Color_1</th>\n",
" <th>Color_19</th>\n",
" <th>Color_28</th>\n",
" <th>Color_37</th>\n",
" <th>Color_58</th>\n",
" <th>Color_76</th>\n",
" <th>...</th>\n",
" <th>Category_COMPUTERCOMMUTER</th>\n",
" <th>Category_EARRINGS</th>\n",
" <th>Category_HAIR</th>\n",
" <th>Category_HANDBAGS</th>\n",
" <th>Category_NECKLACES</th>\n",
" <th>Category_PENDANTS</th>\n",
" <th>Category_RINGS</th>\n",
" <th>Category_SLGS</th>\n",
" <th>Category_SLGs</th>\n",
" <th>Category_TABLETCASE</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>88</td>\n",
" <td>168</td>\n",
" <td>0.235294118</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>75</td>\n",
" <td>288</td>\n",
" <td>0.160599572</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>43</td>\n",
" <td>398</td>\n",
" <td>0.12797619</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>34</td>\n",
" <td>428</td>\n",
" <td>0.100890208</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>86</td>\n",
" <td>438</td>\n",
" <td>0.133126935</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>11</td>\n",
" <td>528</td>\n",
" <td>0.036065574</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>484</td>\n",
" <td>138</td>\n",
" <td>0.340126493</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>73</td>\n",
" <td>248</td>\n",
" <td>0.16937355</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>303</td>\n",
" <td>178</td>\n",
" <td>0.325806452</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>609</td>\n",
" <td>198</td>\n",
" <td>0.38740458</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>12</td>\n",
" <td>68</td>\n",
" <td>0.75</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>271</td>\n",
" <td>148</td>\n",
" <td>0.366216216</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>471</td>\n",
" <td>148</td>\n",
" <td>0.405335628</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>3</td>\n",
" <td>168</td>\n",
" <td>0.272727273</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>0</td>\n",
" <td>168</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>0</td>\n",
" <td>168</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>18</td>\n",
" <td>528</td>\n",
" <td>0.171428571</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>0</td>\n",
" <td>78</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>12</td>\n",
" <td>78</td>\n",
" <td>0.255319149</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>-1</td>\n",
" <td>198</td>\n",
" <td>-1</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>38</td>\n",
" <td>198</td>\n",
" <td>0.193877551</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>3</td>\n",
" <td>238</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>31</td>\n",
" <td>198</td>\n",
" <td>0.215277778</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>3</td>\n",
" <td>238</td>\n",
" <td>0.176470588</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td>6</td>\n",
" <td>498</td>\n",
" <td>0.063829787</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td>54</td>\n",
" <td>498</td>\n",
" <td>0.138817481</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>235</td>\n",
" <td>448</td>\n",
" <td>0.26826484</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>461</td>\n",
" <td>448</td>\n",
" <td>0.25971831</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td>1</td>\n",
" <td>268</td>\n",
" <td>0.020408163</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td>28</td>\n",
" <td>478</td>\n",
" <td>0.28</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</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",
" <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>2246</th>\n",
" <td>27</td>\n",
" <td>72</td>\n",
" <td>0.138461538</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2247</th>\n",
" <td>0</td>\n",
" <td>168</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2248</th>\n",
" <td>2</td>\n",
" <td>68</td>\n",
" <td>0.019417476</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2249</th>\n",
" <td>39</td>\n",
" <td>88</td>\n",
" <td>0.144981413</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2250</th>\n",
" <td>0</td>\n",
" <td>68</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2251</th>\n",
" <td>5</td>\n",
" <td>178</td>\n",
" <td>0.04950495</td>\n",
" <td>7</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2252</th>\n",
" <td>3</td>\n",
" <td>198</td>\n",
" <td>0.016393443</td>\n",
" <td>7</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2253</th>\n",
" <td>1</td>\n",
" <td>208</td>\n",
" <td>0.142857143</td>\n",
" <td>7</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2255</th>\n",
" <td>290</td>\n",
" <td>198</td>\n",
" <td>0.21969697</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2256</th>\n",
" <td>468</td>\n",
" <td>298</td>\n",
" <td>0.258278146</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2257</th>\n",
" <td>0</td>\n",
" <td>168</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2258</th>\n",
" <td>255</td>\n",
" <td>198</td>\n",
" <td>0.314426634</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2259</th>\n",
" <td>76</td>\n",
" <td>178</td>\n",
" <td>0.168514412</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2260</th>\n",
" <td>31</td>\n",
" <td>208</td>\n",
" <td>0.122529644</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2261</th>\n",
" <td>1</td>\n",
" <td>118</td>\n",
" <td>0.058823529</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2267</th>\n",
" <td>10</td>\n",
" <td>188</td>\n",
" <td>0.588235294</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2268</th>\n",
" <td>1</td>\n",
" <td>128</td>\n",
" <td>0.2</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2269</th>\n",
" <td>0</td>\n",
" <td>82</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2270</th>\n",
" <td>0</td>\n",
" <td>188</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2271</th>\n",
" <td>1</td>\n",
" <td>188</td>\n",
" <td>0.035714286</td>\n",
" <td>7</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2272</th>\n",
" <td>0</td>\n",
" <td>188</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2273</th>\n",
" <td>0</td>\n",
" <td>78</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2276</th>\n",
" <td>0</td>\n",
" <td>168</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2279</th>\n",
" <td>0</td>\n",
" <td>52</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2285</th>\n",
" <td>-1</td>\n",
" <td>82</td>\n",
" <td>-1</td>\n",
" <td>7</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2287</th>\n",
" <td>0</td>\n",
" <td>158</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2288</th>\n",
" <td>9</td>\n",
" <td>168</td>\n",
" <td>0.5</td>\n",
" <td>7</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2289</th>\n",
" <td>0</td>\n",
" <td>168</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2290</th>\n",
" <td>5</td>\n",
" <td>208</td>\n",
" <td>0.5</td>\n",
" <td>7</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2291</th>\n",
" <td>17</td>\n",
" <td>208</td>\n",
" <td>0.607142857</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1839 rows × 286 columns</p>\n",
"</div>"
],
"text/plain": [
" MTDUnitSls MSRP MTDUnitSTP Month Color_1 Color_19 Color_28 \\\n",
"0 88 168 0.235294118 2 0.0 0.0 0.0 \n",
"4 75 288 0.160599572 2 0.0 0.0 0.0 \n",
"5 43 398 0.12797619 2 0.0 0.0 0.0 \n",
"6 34 428 0.100890208 2 0.0 0.0 0.0 \n",
"7 86 438 0.133126935 2 0.0 0.0 0.0 \n",
"8 11 528 0.036065574 2 0.0 0.0 0.0 \n",
"9 484 138 0.340126493 2 0.0 0.0 0.0 \n",
"10 73 248 0.16937355 2 0.0 0.0 0.0 \n",
"11 303 178 0.325806452 2 0.0 0.0 0.0 \n",
"12 609 198 0.38740458 2 0.0 0.0 0.0 \n",
"15 12 68 0.75 2 0.0 0.0 0.0 \n",
"16 271 148 0.366216216 2 0.0 0.0 0.0 \n",
"17 471 148 0.405335628 2 0.0 0.0 0.0 \n",
"18 3 168 0.272727273 2 0.0 0.0 0.0 \n",
"19 0 168 0 2 0.0 0.0 0.0 \n",
"22 0 168 0 2 0.0 0.0 0.0 \n",
"23 18 528 0.171428571 2 0.0 0.0 0.0 \n",
"24 0 78 0 2 0.0 0.0 0.0 \n",
"25 12 78 0.255319149 2 0.0 0.0 0.0 \n",
"26 -1 198 -1 2 0.0 0.0 0.0 \n",
"27 38 198 0.193877551 2 0.0 0.0 0.0 \n",
"28 3 238 1 2 0.0 0.0 0.0 \n",
"29 31 198 0.215277778 2 0.0 0.0 0.0 \n",
"30 3 238 0.176470588 2 0.0 0.0 0.0 \n",
"31 6 498 0.063829787 2 0.0 0.0 0.0 \n",
"32 54 498 0.138817481 2 0.0 0.0 0.0 \n",
"33 235 448 0.26826484 2 0.0 0.0 0.0 \n",
"34 461 448 0.25971831 2 0.0 0.0 0.0 \n",
"35 1 268 0.020408163 2 0.0 0.0 0.0 \n",
"36 28 478 0.28 2 0.0 0.0 0.0 \n",
"... ... ... ... ... ... ... ... \n",
"2246 27 72 0.138461538 7 1.0 0.0 0.0 \n",
"2247 0 168 0 7 1.0 0.0 0.0 \n",
"2248 2 68 0.019417476 7 1.0 0.0 0.0 \n",
"2249 39 88 0.144981413 7 1.0 0.0 0.0 \n",
"2250 0 68 0 7 1.0 0.0 0.0 \n",
"2251 5 178 0.04950495 7 0.0 0.0 0.0 \n",
"2252 3 198 0.016393443 7 0.0 0.0 0.0 \n",
"2253 1 208 0.142857143 7 0.0 0.0 0.0 \n",
"2255 290 198 0.21969697 7 1.0 0.0 0.0 \n",
"2256 468 298 0.258278146 7 1.0 0.0 0.0 \n",
"2257 0 168 0 7 1.0 0.0 0.0 \n",
"2258 255 198 0.314426634 7 1.0 0.0 0.0 \n",
"2259 76 178 0.168514412 7 1.0 0.0 0.0 \n",
"2260 31 208 0.122529644 7 1.0 0.0 0.0 \n",
"2261 1 118 0.058823529 7 1.0 0.0 0.0 \n",
"2267 10 188 0.588235294 7 1.0 0.0 0.0 \n",
"2268 1 128 0.2 7 1.0 0.0 0.0 \n",
"2269 0 82 0 7 1.0 0.0 0.0 \n",
"2270 0 188 0 7 0.0 0.0 0.0 \n",
"2271 1 188 0.035714286 7 0.0 0.0 0.0 \n",
"2272 0 188 0 7 1.0 0.0 0.0 \n",
"2273 0 78 0 7 1.0 0.0 0.0 \n",
"2276 0 168 0 7 0.0 0.0 0.0 \n",
"2279 0 52 0 7 0.0 0.0 0.0 \n",
"2285 -1 82 -1 7 0.0 0.0 0.0 \n",
"2287 0 158 0 7 1.0 0.0 0.0 \n",
"2288 9 168 0.5 7 0.0 0.0 0.0 \n",
"2289 0 168 0 7 1.0 0.0 0.0 \n",
"2290 5 208 0.5 7 0.0 0.0 0.0 \n",
"2291 17 208 0.607142857 7 1.0 0.0 0.0 \n",
"\n",
" Color_37 Color_58 Color_76 ... \\\n",
"0 0.0 0.0 0.0 ... \n",
"4 0.0 0.0 0.0 ... \n",
"5 0.0 0.0 0.0 ... \n",
"6 0.0 0.0 0.0 ... \n",
"7 0.0 0.0 0.0 ... \n",
"8 0.0 0.0 0.0 ... \n",
"9 0.0 0.0 0.0 ... \n",
"10 0.0 0.0 0.0 ... \n",
"11 0.0 0.0 0.0 ... \n",
"12 0.0 0.0 0.0 ... \n",
"15 0.0 0.0 0.0 ... \n",
"16 0.0 0.0 0.0 ... \n",
"17 0.0 0.0 0.0 ... \n",
"18 0.0 0.0 0.0 ... \n",
"19 0.0 0.0 0.0 ... \n",
"22 0.0 0.0 0.0 ... \n",
"23 0.0 0.0 0.0 ... \n",
"24 0.0 0.0 0.0 ... \n",
"25 0.0 0.0 0.0 ... \n",
"26 0.0 0.0 0.0 ... \n",
"27 0.0 0.0 0.0 ... \n",
"28 0.0 0.0 0.0 ... \n",
"29 0.0 0.0 0.0 ... \n",
"30 0.0 0.0 0.0 ... \n",
"31 0.0 0.0 0.0 ... \n",
"32 0.0 0.0 0.0 ... \n",
"33 0.0 0.0 0.0 ... \n",
"34 0.0 0.0 0.0 ... \n",
"35 0.0 0.0 0.0 ... \n",
"36 0.0 0.0 0.0 ... \n",
"... ... ... ... ... \n",
"2246 0.0 0.0 0.0 ... \n",
"2247 0.0 0.0 0.0 ... \n",
"2248 0.0 0.0 0.0 ... \n",
"2249 0.0 0.0 0.0 ... \n",
"2250 0.0 0.0 0.0 ... \n",
"2251 0.0 0.0 0.0 ... \n",
"2252 0.0 0.0 0.0 ... \n",
"2253 0.0 0.0 0.0 ... \n",
"2255 0.0 0.0 0.0 ... \n",
"2256 0.0 0.0 0.0 ... \n",
"2257 0.0 0.0 0.0 ... \n",
"2258 0.0 0.0 0.0 ... \n",
"2259 0.0 0.0 0.0 ... \n",
"2260 0.0 0.0 0.0 ... \n",
"2261 0.0 0.0 0.0 ... \n",
"2267 0.0 0.0 0.0 ... \n",
"2268 0.0 0.0 0.0 ... \n",
"2269 0.0 0.0 0.0 ... \n",
"2270 0.0 0.0 0.0 ... \n",
"2271 0.0 1.0 0.0 ... \n",
"2272 0.0 0.0 0.0 ... \n",
"2273 0.0 0.0 0.0 ... \n",
"2276 0.0 0.0 0.0 ... \n",
"2279 0.0 0.0 0.0 ... \n",
"2285 0.0 1.0 0.0 ... \n",
"2287 0.0 0.0 0.0 ... \n",
"2288 0.0 1.0 0.0 ... \n",
"2289 0.0 0.0 0.0 ... \n",
"2290 0.0 1.0 0.0 ... \n",
"2291 0.0 0.0 0.0 ... \n",
"\n",
" Category_COMPUTERCOMMUTER Category_EARRINGS Category_HAIR \\\n",
"0 0.0 0.0 0.0 \n",
"4 0.0 0.0 0.0 \n",
"5 0.0 0.0 0.0 \n",
"6 0.0 0.0 0.0 \n",
"7 0.0 0.0 0.0 \n",
"8 0.0 0.0 0.0 \n",
"9 0.0 0.0 0.0 \n",
"10 0.0 0.0 0.0 \n",
"11 0.0 0.0 0.0 \n",
"12 0.0 0.0 0.0 \n",
"15 0.0 0.0 0.0 \n",
"16 0.0 0.0 0.0 \n",
"17 0.0 0.0 0.0 \n",
"18 0.0 0.0 0.0 \n",
"19 0.0 0.0 0.0 \n",
"22 0.0 0.0 0.0 \n",
"23 0.0 0.0 0.0 \n",
"24 0.0 0.0 0.0 \n",
"25 0.0 0.0 0.0 \n",
"26 0.0 0.0 0.0 \n",
"27 0.0 0.0 0.0 \n",
"28 0.0 0.0 0.0 \n",
"29 0.0 0.0 0.0 \n",
"30 0.0 0.0 0.0 \n",
"31 0.0 0.0 0.0 \n",
"32 0.0 0.0 0.0 \n",
"33 0.0 0.0 0.0 \n",
"34 0.0 0.0 0.0 \n",
"35 0.0 0.0 0.0 \n",
"36 0.0 0.0 0.0 \n",
"... ... ... ... \n",
"2246 0.0 0.0 0.0 \n",
"2247 0.0 0.0 0.0 \n",
"2248 0.0 0.0 0.0 \n",
"2249 0.0 0.0 0.0 \n",
"2250 0.0 0.0 0.0 \n",
"2251 0.0 0.0 0.0 \n",
"2252 0.0 0.0 0.0 \n",
"2253 0.0 0.0 0.0 \n",
"2255 0.0 0.0 0.0 \n",
"2256 0.0 0.0 0.0 \n",
"2257 0.0 0.0 0.0 \n",
"2258 0.0 0.0 0.0 \n",
"2259 0.0 0.0 0.0 \n",
"2260 0.0 0.0 0.0 \n",
"2261 1.0 0.0 0.0 \n",
"2267 0.0 0.0 0.0 \n",
"2268 1.0 0.0 0.0 \n",
"2269 0.0 0.0 0.0 \n",
"2270 0.0 0.0 0.0 \n",
"2271 0.0 0.0 0.0 \n",
"2272 0.0 0.0 0.0 \n",
"2273 0.0 0.0 0.0 \n",
"2276 0.0 0.0 0.0 \n",
"2279 0.0 0.0 0.0 \n",
"2285 0.0 0.0 0.0 \n",
"2287 0.0 0.0 0.0 \n",
"2288 0.0 0.0 0.0 \n",
"2289 0.0 0.0 0.0 \n",
"2290 0.0 0.0 0.0 \n",
"2291 0.0 0.0 0.0 \n",
"\n",
" Category_HANDBAGS Category_NECKLACES Category_PENDANTS \\\n",
"0 1.0 0.0 0.0 \n",
"4 1.0 0.0 0.0 \n",
"5 1.0 0.0 0.0 \n",
"6 1.0 0.0 0.0 \n",
"7 1.0 0.0 0.0 \n",
"8 1.0 0.0 0.0 \n",
"9 1.0 0.0 0.0 \n",
"10 1.0 0.0 0.0 \n",
"11 1.0 0.0 0.0 \n",
"12 1.0 0.0 0.0 \n",
"15 0.0 0.0 0.0 \n",
"16 0.0 0.0 0.0 \n",
"17 0.0 0.0 0.0 \n",
"18 1.0 0.0 0.0 \n",
"19 1.0 0.0 0.0 \n",
"22 0.0 0.0 0.0 \n",
"23 1.0 0.0 0.0 \n",
"24 0.0 0.0 0.0 \n",
"25 0.0 0.0 0.0 \n",
"26 1.0 0.0 0.0 \n",
"27 1.0 0.0 0.0 \n",
"28 1.0 0.0 0.0 \n",
"29 1.0 0.0 0.0 \n",
"30 1.0 0.0 0.0 \n",
"31 1.0 0.0 0.0 \n",
"32 1.0 0.0 0.0 \n",
"33 1.0 0.0 0.0 \n",
"34 1.0 0.0 0.0 \n",
"35 1.0 0.0 0.0 \n",
"36 1.0 0.0 0.0 \n",
"... ... ... ... \n",
"2246 0.0 0.0 0.0 \n",
"2247 0.0 0.0 0.0 \n",
"2248 0.0 0.0 0.0 \n",
"2249 0.0 0.0 0.0 \n",
"2250 0.0 0.0 0.0 \n",
"2251 1.0 0.0 0.0 \n",
"2252 1.0 0.0 0.0 \n",
"2253 1.0 0.0 0.0 \n",
"2255 1.0 0.0 0.0 \n",
"2256 1.0 0.0 0.0 \n",
"2257 1.0 0.0 0.0 \n",
"2258 1.0 0.0 0.0 \n",
"2259 1.0 0.0 0.0 \n",
"2260 1.0 0.0 0.0 \n",
"2261 0.0 0.0 0.0 \n",
"2267 1.0 0.0 0.0 \n",
"2268 0.0 0.0 0.0 \n",
"2269 0.0 0.0 0.0 \n",
"2270 1.0 0.0 0.0 \n",
"2271 1.0 0.0 0.0 \n",
"2272 1.0 0.0 0.0 \n",
"2273 0.0 0.0 0.0 \n",
"2276 1.0 0.0 0.0 \n",
"2279 0.0 0.0 0.0 \n",
"2285 0.0 0.0 0.0 \n",
"2287 1.0 0.0 0.0 \n",
"2288 1.0 0.0 0.0 \n",
"2289 1.0 0.0 0.0 \n",
"2290 1.0 0.0 0.0 \n",
"2291 1.0 0.0 0.0 \n",
"\n",
" Category_RINGS Category_SLGS Category_SLGs Category_TABLETCASE \n",
"0 0.0 0.0 0.0 0.0 \n",
"4 0.0 0.0 0.0 0.0 \n",
"5 0.0 0.0 0.0 0.0 \n",
"6 0.0 0.0 0.0 0.0 \n",
"7 0.0 0.0 0.0 0.0 \n",
"8 0.0 0.0 0.0 0.0 \n",
"9 0.0 0.0 0.0 0.0 \n",
"10 0.0 0.0 0.0 0.0 \n",
"11 0.0 0.0 0.0 0.0 \n",
"12 0.0 0.0 0.0 0.0 \n",
"15 0.0 0.0 1.0 0.0 \n",
"16 0.0 0.0 1.0 0.0 \n",
"17 0.0 0.0 1.0 0.0 \n",
"18 0.0 0.0 0.0 0.0 \n",
"19 0.0 0.0 0.0 0.0 \n",
"22 0.0 0.0 1.0 0.0 \n",
"23 0.0 0.0 0.0 0.0 \n",
"24 0.0 0.0 1.0 0.0 \n",
"25 0.0 0.0 1.0 0.0 \n",
"26 0.0 0.0 0.0 0.0 \n",
"27 0.0 0.0 0.0 0.0 \n",
"28 0.0 0.0 0.0 0.0 \n",
"29 0.0 0.0 0.0 0.0 \n",
"30 0.0 0.0 0.0 0.0 \n",
"31 0.0 0.0 0.0 0.0 \n",
"32 0.0 0.0 0.0 0.0 \n",
"33 0.0 0.0 0.0 0.0 \n",
"34 0.0 0.0 0.0 0.0 \n",
"35 0.0 0.0 0.0 0.0 \n",
"36 0.0 0.0 0.0 0.0 \n",
"... ... ... ... ... \n",
"2246 0.0 0.0 1.0 0.0 \n",
"2247 0.0 0.0 1.0 0.0 \n",
"2248 0.0 0.0 1.0 0.0 \n",
"2249 0.0 0.0 1.0 0.0 \n",
"2250 0.0 0.0 0.0 1.0 \n",
"2251 0.0 0.0 0.0 0.0 \n",
"2252 0.0 0.0 0.0 0.0 \n",
"2253 0.0 0.0 0.0 0.0 \n",
"2255 0.0 0.0 0.0 0.0 \n",
"2256 0.0 0.0 0.0 0.0 \n",
"2257 0.0 0.0 0.0 0.0 \n",
"2258 0.0 0.0 0.0 0.0 \n",
"2259 0.0 0.0 0.0 0.0 \n",
"2260 0.0 0.0 0.0 0.0 \n",
"2261 0.0 0.0 0.0 0.0 \n",
"2267 0.0 0.0 0.0 0.0 \n",
"2268 0.0 0.0 0.0 0.0 \n",
"2269 0.0 0.0 0.0 0.0 \n",
"2270 0.0 0.0 0.0 0.0 \n",
"2271 0.0 0.0 0.0 0.0 \n",
"2272 0.0 0.0 0.0 0.0 \n",
"2273 0.0 0.0 0.0 0.0 \n",
"2276 0.0 0.0 0.0 0.0 \n",
"2279 0.0 0.0 1.0 0.0 \n",
"2285 0.0 0.0 1.0 0.0 \n",
"2287 0.0 0.0 0.0 0.0 \n",
"2288 0.0 0.0 0.0 0.0 \n",
"2289 0.0 0.0 0.0 0.0 \n",
"2290 0.0 0.0 0.0 0.0 \n",
"2291 0.0 0.0 0.0 0.0 \n",
"\n",
"[1839 rows x 286 columns]"
]
},
"execution_count": 21,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"x_with_dummies = data[x_non_dummies].merge(x_dummies, left_index=True, right_index=True)\n",
"data_with_dummies = data[y].merge(x_with_dummies, left_index=True, right_index=True)\n",
"data_with_dummies = data_with_dummies[data_with_dummies['MSRP'] != '-']\n",
"data_with_dummies = data_with_dummies[data_with_dummies['MTDUnitSTP'] != '-']\n",
"data_with_dummies"
]
},
{
"cell_type": "code",
"execution_count": 22,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"size = len(data_with_dummies)\n",
"data_train = data_with_dummies[:(7 * size / 10)]\n",
"data_test = data_with_dummies[:(3 * size / 10)]"
]
},
{
"cell_type": "code",
"execution_count": 23,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import sklearn.linear_model as linear_model"
]
},
{
"cell_type": "code",
"execution_count": 27,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"LinearRegression(copy_X=True, fit_intercept=True, n_jobs=1, normalize=False)"
]
},
"execution_count": 27,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"y_columns = y[0]\n",
"x_columns = x_with_dummies.columns\n",
"\n",
"model_lm = linear_model.LinearRegression()\n",
"model_lm.fit(data_train[x_columns], data_train[y_columns])"
]
},
{
"cell_type": "code",
"execution_count": 28,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"0.817069455077\n"
]
}
],
"source": [
"from sklearn.metrics import r2_score\n",
"\n",
"print r2_score(data_test[y_columns], model_lm.predict(data_test[x_columns]))"
]
},
{
"cell_type": "code",
"execution_count": 29,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import sklearn.decomposition as decomposition"
]
},
{
"cell_type": "code",
"execution_count": 37,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"array([ 9.99599452e-01, 1.08018936e-04])"
]
},
"execution_count": 37,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"model_pca = decomposition.PCA(n_components=2)\n",
"data_train_transformed = model_pca.fit_transform(data_train[x_columns], data_train[y_columns])\n",
"model_pca.explained_variance_ratio_"
]
},
{
"cell_type": "code",
"execution_count": 50,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"array([[ 128.04562224, 3.46624577],\n",
" [ 129.04534446, 3.45783075],\n",
" [ 129.04486681, 2.46721598],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04418549, 3.44149314],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04564364, 3.46643446],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04593539, 3.47078962],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04562741, 3.46542552],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04632255, 3.47070584],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04574955, 3.46778888],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04613776, 3.46625815],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04559867, 3.46569548],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04484979, 3.46141804],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04568758, 3.46977618],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04561097, 3.46203334],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.0456468 , 3.46551692],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04562741, 3.46542306],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04584891, 3.46507119],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04418549, 3.44149314],\n",
" [ 129.04563124, 3.46531017],\n",
" [ 129.04550473, 3.47208582],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04559867, 3.46569548],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04564364, 3.46643446],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04484979, 3.46141804],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04568758, 3.46977618],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04593539, 3.47078962],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04561097, 3.46203334],\n",
" [ 129.04563244, 3.46562888],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.0456468 , 3.46551692],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04562741, 3.46542306],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04584891, 3.46507119],\n",
" [ 129.04571483, 3.46601199],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04562741, 3.46542552],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04632255, 3.47070584],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04574955, 3.46778888],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04613776, 3.46625815],\n",
" [ 129.04561783, 3.46542526],\n",
" [ 129.04558727, 3.46784317],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.0455963 , 3.46546263],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04551972, 3.46614034],\n",
" [ 129.04557022, 3.46596929],\n",
" [ 129.04558937, 3.46579922],\n",
" [ 129.04560108, 3.46547423],\n",
" [ 129.04563053, 3.46528387],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04561202, 3.46613535],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04562645, 3.46528634],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04559869, 3.46560375],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04562023, 3.46529857],\n",
" [ 129.04557979, 3.46587965],\n",
" [ 129.0455939 , 3.46564574],\n",
" [ 129.04561927, 3.46530691],\n",
" [ 129.04560826, 3.46540455],\n",
" [ 129.0455939 , 3.46552697],\n",
" [ 129.04557948, 3.46646508],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04561065, 3.46538304],\n",
" [ 129.04558912, 3.46557769],\n",
" [ 129.04559337, 3.46587309],\n",
" [ 129.04559151, 3.46555513],\n",
" [ 129.04559869, 3.46549596],\n",
" [ 129.04556758, 3.46576253],\n",
" [ 129.04559151, 3.46555581],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04558912, 3.46568497],\n",
" [ 129.04559151, 3.46566594],\n",
" [ 129.0455963 , 3.46562305],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04561783, 3.46525098],\n",
" [ 129.04562262, 3.46521154],\n",
" [ 129.04559869, 3.46542066],\n",
" [ 129.04562166, 3.46521823],\n",
" [ 129.04561783, 3.46535977],\n",
" [ 129.04562262, 3.4653185 ],\n",
" [ 129.04562166, 3.46532717],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04561083, 3.46502622],\n",
" [ 129.04560826, 3.46540319],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04560999, 3.46517251],\n",
" [ 129.04560826, 3.46552426],\n",
" [ 129.04559151, 3.46567381],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04556758, 3.46588343],\n",
" [ 129.04558912, 3.4656972 ],\n",
" [ 129.04559151, 3.46567758],\n",
" [ 129.0455963 , 3.4656361 ],\n",
" [ 129.04561783, 3.46537349],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04559869, 3.46553519],\n",
" [ 129.04562166, 3.46533933],\n",
" [ 129.0455963 , 3.46551459],\n",
" [ 129.04559869, 3.46549515],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04546493, 3.46676715],\n",
" [ 129.04546493, 3.46676555],\n",
" [ 129.04547935, 3.46695536],\n",
" [ 129.04541228, 3.46722478],\n",
" [ 129.04557501, 3.46564798],\n",
" [ 129.04554629, 3.4659023 ],\n",
" [ 129.04548886, 3.46655614],\n",
" [ 129.04551972, 3.46613922],\n",
" [ 129.04556676, 3.46296251],\n",
" [ 129.04556077, 3.46300934],\n",
" [ 129.04556676, 3.46296215],\n",
" [ 129.0455814 , 3.46413525],\n",
" [ 129.04559636, 3.46399601],\n",
" [ 129.04560533, 3.46392987],\n",
" [ 129.04562658, 3.46244378],\n",
" [ 129.0456173 , 3.46381976],\n",
" [ 129.04564453, 3.46228099],\n",
" [ 129.04539925, 3.46461586],\n",
" [ 129.04556645, 3.46436454],\n",
" [ 129.04539811, 3.46494315],\n",
" [ 129.04538728, 3.46472395],\n",
" [ 129.04557542, 3.46433889],\n",
" [ 129.04558738, 3.46423352],\n",
" [ 129.04559498, 3.46663308],\n",
" [ 129.04559151, 3.46567008],\n",
" [ 129.04559976, 3.46659308],\n",
" [ 129.04562328, 3.46382499],\n",
" [ 129.04562328, 3.46396313],\n",
" [ 129.04548867, 3.46503949],\n",
" [ 129.04559636, 3.46399996],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04559636, 3.46415603],\n",
" [ 129.04559403, 3.46295999],\n",
" [ 129.04559667, 3.46269197],\n",
" [ 129.04562262, 3.46519912],\n",
" [ 129.04562262, 3.46307168],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04558738, 3.46423039],\n",
" [ 129.04559337, 3.4641783 ],\n",
" [ 129.04557243, 3.46436525],\n",
" [ 129.04560533, 3.46407444],\n",
" [ 129.04548867, 3.46503755],\n",
" [ 129.04551559, 3.46480278],\n",
" [ 129.04551859, 3.46477768],\n",
" [ 129.04552756, 3.46469981],\n",
" [ 129.04556046, 3.4644119 ],\n",
" [ 129.04558912, 3.46323833],\n",
" [ 129.04558912, 3.46324318],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04559636, 3.46415208],\n",
" [ 129.0456298 , 3.46542774],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.0456298 , 3.46542794],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04562501, 3.46545339],\n",
" [ 129.04562501, 3.46545339],\n",
" [ 129.0456298 , 3.46542947],\n",
" [ 129.04562076, 3.4662469 ],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04565902, 3.46575341],\n",
" [ 129.0456468 , 3.46556939],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04562741, 3.46544538],\n",
" [ 129.04564967, 3.4655486 ],\n",
" [ 129.04564967, 3.46553989],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04570983, 3.46624419],\n",
" [ 129.04564967, 3.46554728],\n",
" [ 129.04564967, 3.46554288],\n",
" [ 129.0456298 , 3.46542947],\n",
" [ 129.04560926, 3.46637229],\n",
" [ 129.04562501, 3.46545538],\n",
" [ 129.0456662 , 3.46550487],\n",
" [ 129.04565052, 3.46665093],\n",
" [ 129.04562741, 3.46545031],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04571216, 3.4655946 ],\n",
" [ 129.04565184, 3.46568801],\n",
" [ 129.0456565 , 3.46663483],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04567602, 3.46580541],\n",
" [ 129.04565872, 3.46586856],\n",
" [ 129.04563723, 3.46551154],\n",
" [ 129.0456298 , 3.46542809],\n",
" [ 129.0456468 , 3.46556858],\n",
" [ 129.04563855, 3.46675534],\n",
" [ 129.0456303 , 3.46585951],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04564489, 3.46542126],\n",
" [ 129.04565052, 3.46659569],\n",
" [ 129.0456468 , 3.46546195],\n",
" [ 129.0456473 , 3.46604013],\n",
" [ 129.04568559, 3.46581792],\n",
" [ 129.04567602, 3.46583269],\n",
" [ 129.04562328, 3.46622958],\n",
" [ 129.0456303 , 3.46584584],\n",
" [ 129.04563226, 3.46617985],\n",
" [ 129.04565902, 3.46557296],\n",
" [ 129.04570014, 3.4663641 ],\n",
" [ 129.0456133 , 3.46572626],\n",
" [ 129.04562816, 3.46626602],\n",
" [ 129.04564967, 3.46553996],\n",
" [ 129.0456662 , 3.46568275],\n",
" [ 129.0456468 , 3.46556883],\n",
" [ 129.04567602, 3.46590922],\n",
" [ 129.04564818, 3.46302712],\n",
" [ 129.04562287, 3.46575392],\n",
" [ 129.04564201, 3.46546611],\n",
" [ 129.0456355 , 3.46591388],\n",
" [ 129.04564201, 3.46545302],\n",
" [ 129.0456355 , 3.46587849],\n",
" [ 129.04564393, 3.46548278],\n",
" [ 129.04562766, 3.46543822],\n",
" [ 129.04560851, 3.46576498],\n",
" [ 129.0456495 , 3.46572326],\n",
" [ 129.04563124, 3.46531017],\n",
" [ 129.04564202, 3.46555474],\n",
" [ 129.04564202, 3.46555909],\n",
" [ 129.04564202, 3.4654492 ],\n",
" [ 129.04563723, 3.46565748],\n",
" [ 129.04564202, 3.4656108 ],\n",
" [ 129.04558723, 3.46616254],\n",
" [ 129.0456303 , 3.46595992],\n",
" [ 129.04561594, 3.46604541],\n",
" [ 129.04560839, 3.46229089],\n",
" [ 129.04560801, 3.46530676],\n",
" [ 129.04563748, 3.46571024],\n",
" [ 129.04564466, 3.46562191],\n",
" [ 129.04565184, 3.46580866],\n",
" [ 129.0456662 , 3.46568861],\n",
" [ 129.04563351, 3.46208222],\n",
" [ 129.04563723, 3.46550776],\n",
" [ 129.04561927, 3.46530587],\n",
" [ 129.04562023, 3.46529729],\n",
" [ 129.04562262, 3.46527447],\n",
" [ 129.04560826, 3.46540123],\n",
" [ 129.04561065, 3.46538084],\n",
" [ 129.04561927, 3.46542708],\n",
" [ 129.04562023, 3.46541749],\n",
" [ 129.04562262, 3.46539485],\n",
" [ 129.04560826, 3.46551056],\n",
" [ 129.04561066, 3.46550202],\n",
" [ 129.04563531, 3.46537008],\n",
" [ 129.04563723, 3.46535312],\n",
" [ 129.0456401 , 3.46532618],\n",
" [ 129.04564201, 3.46531125],\n",
" [ 129.04564201, 3.46531252],\n",
" [ 129.04562287, 3.46548024],\n",
" [ 129.04564489, 3.4652882 ],\n",
" [ 129.0456133 , 3.46556149],\n",
" [ 129.04769492, 3.49086525],\n",
" [ 129.04563124, 3.46531017],\n",
" [ 129.04564818, 3.46302712],\n",
" [ 129.04319868, 3.44387507],\n",
" [ 129.04562766, 3.46543822],\n",
" [ 129.04547294, 3.46394757],\n",
" [ 129.04574358, 3.46432677],\n",
" [ 129.0458469 , 3.46566387],\n",
" [ 129.04574181, 3.46845545],\n",
" [ 129.04591496, 3.4649496 ],\n",
" [ 129.04580385, 3.4653725 ],\n",
" [ 129.04562446, 3.46648288],\n",
" [ 129.04693203, 3.47657064],\n",
" [ 129.04563124, 3.46531017],\n",
" [ 129.04282424, 3.47033508],\n",
" [ 129.04576784, 3.47040248],\n",
" [ 129.04579928, 3.46856964],\n",
" [ 129.04601334, 3.46568018],\n",
" [ 129.0455963 , 3.46546263],\n",
" [ 129.04553188, 3.43587331],\n",
" [ 129.04572296, 3.46552327]])"
]
},
"execution_count": 50,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"i = numpy.identity(data_train[x_columns].shape[1])\n",
"coef = model_pca.transform(i)\n",
"coef"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 2",
"language": "python",
"name": "python2"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 2
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython2",
"version": "2.7.9"
}
},
"nbformat": 4,
"nbformat_minor": 0
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment