Ensemble.ipynb

{
 "metadata": {
  "name": "",
  "signature": "sha256:c7417992e631028eac9c1ad15d468e7d74caf5f56d6974c8483397bce0cdedc4"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import sys\n",
      "\n",
      "import os\n",
      "import numpy as np\n",
      "import pandas as pd\n"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 2
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "RF = pd.read_csv('./sample_sub_RF_4-6.csv')\n",
      "XGBPP = pd.read_csv('./sample_sub_XGB_4-6_2.csv')\n",
      "XGBOL = pd.read_csv('./submission-XGB-OL-4-10.csv')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 11
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "ensemble = RF.copy()\n",
      "\n",
      "ensemble['TARGET'] = XGBOL['TARGET']*0.75+XGBPP['TARGET']*0.15+RF['TARGET']*0.1\n",
      "\n",
      "ensemble.to_csv('sub_ensemble_4-14.csv',index=False)\n",
      "\n",
      "\n"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 13
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "ensemble\n"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>ID</th>\n",
        "      <th>TARGET</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>2</td>\n",
        "      <td>0.080513</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td>5</td>\n",
        "      <td>0.060563</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td>6</td>\n",
        "      <td>0.001604</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td>7</td>\n",
        "      <td>0.013955</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td>9</td>\n",
        "      <td>0.003583</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5</th>\n",
        "      <td>11</td>\n",
        "      <td>0.233884</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6</th>\n",
        "      <td>12</td>\n",
        "      <td>0.028616</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7</th>\n",
        "      <td>15</td>\n",
        "      <td>0.161232</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8</th>\n",
        "      <td>16</td>\n",
        "      <td>0.055297</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>9</th>\n",
        "      <td>17</td>\n",
        "      <td>0.021293</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>10</th>\n",
        "      <td>19</td>\n",
        "      <td>0.028494</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>11</th>\n",
        "      <td>21</td>\n",
        "      <td>0.008683</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>12</th>\n",
        "      <td>22</td>\n",
        "      <td>0.017179</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>13</th>\n",
        "      <td>24</td>\n",
        "      <td>0.012247</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>14</th>\n",
        "      <td>27</td>\n",
        "      <td>0.014942</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>15</th>\n",
        "      <td>28</td>\n",
        "      <td>0.018874</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>16</th>\n",
        "      <td>30</td>\n",
        "      <td>0.144397</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>17</th>\n",
        "      <td>33</td>\n",
        "      <td>0.003436</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>18</th>\n",
        "      <td>35</td>\n",
        "      <td>0.014490</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>19</th>\n",
        "      <td>37</td>\n",
        "      <td>0.019029</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>20</th>\n",
        "      <td>38</td>\n",
        "      <td>0.033048</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>21</th>\n",
        "      <td>40</td>\n",
        "      <td>0.181485</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>22</th>\n",
        "      <td>41</td>\n",
        "      <td>0.028789</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>23</th>\n",
        "      <td>44</td>\n",
        "      <td>0.012602</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>24</th>\n",
        "      <td>46</td>\n",
        "      <td>0.085907</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>25</th>\n",
        "      <td>47</td>\n",
        "      <td>0.018917</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>26</th>\n",
        "      <td>48</td>\n",
        "      <td>0.009625</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>27</th>\n",
        "      <td>50</td>\n",
        "      <td>0.011705</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>28</th>\n",
        "      <td>52</td>\n",
        "      <td>0.164862</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>29</th>\n",
        "      <td>53</td>\n",
        "      <td>0.011419</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>...</th>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75788</th>\n",
        "      <td>151772</td>\n",
        "      <td>0.005486</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75789</th>\n",
        "      <td>151773</td>\n",
        "      <td>0.032328</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75790</th>\n",
        "      <td>151776</td>\n",
        "      <td>0.015348</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75791</th>\n",
        "      <td>151777</td>\n",
        "      <td>0.055989</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75792</th>\n",
        "      <td>151780</td>\n",
        "      <td>0.009926</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75793</th>\n",
        "      <td>151781</td>\n",
        "      <td>0.018147</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75794</th>\n",
        "      <td>151782</td>\n",
        "      <td>0.173360</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75795</th>\n",
        "      <td>151784</td>\n",
        "      <td>0.275275</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75796</th>\n",
        "      <td>151785</td>\n",
        "      <td>0.025204</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75797</th>\n",
        "      <td>151786</td>\n",
        "      <td>0.128440</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75798</th>\n",
        "      <td>151788</td>\n",
        "      <td>0.006028</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75799</th>\n",
        "      <td>151789</td>\n",
        "      <td>0.004485</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75800</th>\n",
        "      <td>151790</td>\n",
        "      <td>0.027306</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75801</th>\n",
        "      <td>151791</td>\n",
        "      <td>0.022801</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75802</th>\n",
        "      <td>151803</td>\n",
        "      <td>0.121081</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75803</th>\n",
        "      <td>151812</td>\n",
        "      <td>0.037270</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75804</th>\n",
        "      <td>151814</td>\n",
        "      <td>0.029947</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75805</th>\n",
        "      <td>151817</td>\n",
        "      <td>0.033004</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75806</th>\n",
        "      <td>151819</td>\n",
        "      <td>0.055138</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75807</th>\n",
        "      <td>151822</td>\n",
        "      <td>0.004943</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75808</th>\n",
        "      <td>151823</td>\n",
        "      <td>0.068624</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75809</th>\n",
        "      <td>151824</td>\n",
        "      <td>0.157468</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75810</th>\n",
        "      <td>151826</td>\n",
        "      <td>0.005771</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75811</th>\n",
        "      <td>151827</td>\n",
        "      <td>0.022121</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75812</th>\n",
        "      <td>151828</td>\n",
        "      <td>0.036326</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75813</th>\n",
        "      <td>151831</td>\n",
        "      <td>0.065307</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75814</th>\n",
        "      <td>151832</td>\n",
        "      <td>0.021175</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75815</th>\n",
        "      <td>151833</td>\n",
        "      <td>0.008805</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75816</th>\n",
        "      <td>151834</td>\n",
        "      <td>0.055842</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75817</th>\n",
        "      <td>151837</td>\n",
        "      <td>0.001403</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>75818 rows \u00d7 2 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 14,
       "text": [
        "           ID    TARGET\n",
        "0           2  0.080513\n",
        "1           5  0.060563\n",
        "2           6  0.001604\n",
        "3           7  0.013955\n",
        "4           9  0.003583\n",
        "5          11  0.233884\n",
        "6          12  0.028616\n",
        "7          15  0.161232\n",
        "8          16  0.055297\n",
        "9          17  0.021293\n",
        "10         19  0.028494\n",
        "11         21  0.008683\n",
        "12         22  0.017179\n",
        "13         24  0.012247\n",
        "14         27  0.014942\n",
        "15         28  0.018874\n",
        "16         30  0.144397\n",
        "17         33  0.003436\n",
        "18         35  0.014490\n",
        "19         37  0.019029\n",
        "20         38  0.033048\n",
        "21         40  0.181485\n",
        "22         41  0.028789\n",
        "23         44  0.012602\n",
        "24         46  0.085907\n",
        "25         47  0.018917\n",
        "26         48  0.009625\n",
        "27         50  0.011705\n",
        "28         52  0.164862\n",
        "29         53  0.011419\n",
        "...       ...       ...\n",
        "75788  151772  0.005486\n",
        "75789  151773  0.032328\n",
        "75790  151776  0.015348\n",
        "75791  151777  0.055989\n",
        "75792  151780  0.009926\n",
        "75793  151781  0.018147\n",
        "75794  151782  0.173360\n",
        "75795  151784  0.275275\n",
        "75796  151785  0.025204\n",
        "75797  151786  0.128440\n",
        "75798  151788  0.006028\n",
        "75799  151789  0.004485\n",
        "75800  151790  0.027306\n",
        "75801  151791  0.022801\n",
        "75802  151803  0.121081\n",
        "75803  151812  0.037270\n",
        "75804  151814  0.029947\n",
        "75805  151817  0.033004\n",
        "75806  151819  0.055138\n",
        "75807  151822  0.004943\n",
        "75808  151823  0.068624\n",
        "75809  151824  0.157468\n",
        "75810  151826  0.005771\n",
        "75811  151827  0.022121\n",
        "75812  151828  0.036326\n",
        "75813  151831  0.065307\n",
        "75814  151832  0.021175\n",
        "75815  151833  0.008805\n",
        "75816  151834  0.055842\n",
        "75817  151837  0.001403\n",
        "\n",
        "[75818 rows x 2 columns]"
       ]
      }
     ],
     "prompt_number": 14
    }
   ],
   "metadata": {}
  }
 ]
}