SIT719_Prac03_Task01_SupervisedML_fraudCreditCardData_detection.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "#import libraries\n",
    "\n",
    "import pandas as pd\n",
    "import os\n",
    "from sklearn.metrics import confusion_matrix\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "link_to_data = 'https://raw.githubusercontent.com/SIT719/2020-S2/master/data/payment_fraud.csv'\n",
    "dfp = pd.read_csv(link_to_data, error_bad_lines=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>accountAgeDays</th>\n",
       "      <th>numItems</th>\n",
       "      <th>localTime</th>\n",
       "      <th>paymentMethod</th>\n",
       "      <th>paymentMethodAgeDays</th>\n",
       "      <th>label</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>29</td>\n",
       "      <td>1</td>\n",
       "      <td>4.745402</td>\n",
       "      <td>paypal</td>\n",
       "      <td>28.204861</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>725</td>\n",
       "      <td>1</td>\n",
       "      <td>4.742303</td>\n",
       "      <td>storecredit</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>845</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921318</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>503</td>\n",
       "      <td>1</td>\n",
       "      <td>4.886641</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>5.040929</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>119</td>\n",
       "      <td>1</td>\n",
       "      <td>4.962055</td>\n",
       "      <td>paypal</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921349</td>\n",
       "      <td>paypal</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>371</td>\n",
       "      <td>1</td>\n",
       "      <td>4.876771</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.748314</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>4.461622</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>26</td>\n",
       "      <td>1</td>\n",
       "      <td>4.745402</td>\n",
       "      <td>paypal</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.505662</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.000694</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>4.962055</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>2.690972</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921318</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>2.069444</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>4.745402</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.001389</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921349</td>\n",
       "      <td>paypal</td>\n",
       "      <td>4.036111</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1208</td>\n",
       "      <td>1</td>\n",
       "      <td>4.836982</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.000694</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921349</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>10.865972</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>123</td>\n",
       "      <td>1</td>\n",
       "      <td>4.748314</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.000694</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.895263</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>248.774306</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1672</td>\n",
       "      <td>1</td>\n",
       "      <td>5.034622</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>978.752778</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>36</td>\n",
       "      <td>1</td>\n",
       "      <td>4.742303</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.014583</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>4.886641</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>15.796528</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>278</td>\n",
       "      <td>1</td>\n",
       "      <td>5.034622</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>6.892361</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>223</td>\n",
       "      <td>1</td>\n",
       "      <td>4.748314</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>4.057414</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921349</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>3.483951</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>503.425000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1936</td>\n",
       "      <td>1</td>\n",
       "      <td>4.057414</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>635.641667</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921318</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>948.806944</td>\n",
       "      <td>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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39191</th>\n",
       "      <td>137</td>\n",
       "      <td>1</td>\n",
       "      <td>4.461622</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>136.703472</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39192</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.876771</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39193</th>\n",
       "      <td>156</td>\n",
       "      <td>1</td>\n",
       "      <td>4.886641</td>\n",
       "      <td>paypal</td>\n",
       "      <td>91.781944</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39194</th>\n",
       "      <td>225</td>\n",
       "      <td>1</td>\n",
       "      <td>4.461622</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39195</th>\n",
       "      <td>1631</td>\n",
       "      <td>1</td>\n",
       "      <td>4.876771</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39196</th>\n",
       "      <td>491</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921318</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>22.220833</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39197</th>\n",
       "      <td>490</td>\n",
       "      <td>1</td>\n",
       "      <td>4.748314</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.005556</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39198</th>\n",
       "      <td>83</td>\n",
       "      <td>1</td>\n",
       "      <td>4.057414</td>\n",
       "      <td>paypal</td>\n",
       "      <td>82.795139</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39199</th>\n",
       "      <td>150</td>\n",
       "      <td>1</td>\n",
       "      <td>4.895263</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>149.981944</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39200</th>\n",
       "      <td>936</td>\n",
       "      <td>1</td>\n",
       "      <td>4.745402</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>1.772917</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39201</th>\n",
       "      <td>84</td>\n",
       "      <td>1</td>\n",
       "      <td>4.895263</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>83.018056</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39202</th>\n",
       "      <td>124</td>\n",
       "      <td>1</td>\n",
       "      <td>4.524580</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>123.047917</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39203</th>\n",
       "      <td>131</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921318</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39204</th>\n",
       "      <td>192</td>\n",
       "      <td>1</td>\n",
       "      <td>2.948940</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>181.184722</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39205</th>\n",
       "      <td>241</td>\n",
       "      <td>1</td>\n",
       "      <td>5.017904</td>\n",
       "      <td>paypal</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39206</th>\n",
       "      <td>1116</td>\n",
       "      <td>1</td>\n",
       "      <td>4.895263</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39207</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921349</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>410.779167</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39208</th>\n",
       "      <td>508</td>\n",
       "      <td>1</td>\n",
       "      <td>4.748314</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>357.716667</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39209</th>\n",
       "      <td>629</td>\n",
       "      <td>1</td>\n",
       "      <td>4.876771</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>258.222222</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39210</th>\n",
       "      <td>1607</td>\n",
       "      <td>1</td>\n",
       "      <td>4.886641</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39211</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.886641</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39212</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>5.040929</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>185.286806</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39213</th>\n",
       "      <td>108</td>\n",
       "      <td>1</td>\n",
       "      <td>4.748314</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>48.965278</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39214</th>\n",
       "      <td>101</td>\n",
       "      <td>2</td>\n",
       "      <td>4.524580</td>\n",
       "      <td>storecredit</td>\n",
       "      <td>100.746528</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39215</th>\n",
       "      <td>1257</td>\n",
       "      <td>1</td>\n",
       "      <td>4.965339</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>813.097222</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39216</th>\n",
       "      <td>986</td>\n",
       "      <td>1</td>\n",
       "      <td>4.836982</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39217</th>\n",
       "      <td>1647</td>\n",
       "      <td>1</td>\n",
       "      <td>4.876771</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>377.930556</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39218</th>\n",
       "      <td>1591</td>\n",
       "      <td>1</td>\n",
       "      <td>4.742303</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39219</th>\n",
       "      <td>237</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921318</td>\n",
       "      <td>creditcard</td>\n",
       "      <td>236.082639</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39220</th>\n",
       "      <td>272</td>\n",
       "      <td>1</td>\n",
       "      <td>5.040929</td>\n",
       "      <td>paypal</td>\n",
       "      <td>0.000694</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>39221 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       accountAgeDays  numItems  localTime paymentMethod  \\\n",
       "0                  29         1   4.745402        paypal   \n",
       "1                 725         1   4.742303   storecredit   \n",
       "2                 845         1   4.921318    creditcard   \n",
       "3                 503         1   4.886641    creditcard   \n",
       "4                2000         1   5.040929    creditcard   \n",
       "5                 119         1   4.962055        paypal   \n",
       "6                2000         1   4.921349        paypal   \n",
       "7                 371         1   4.876771    creditcard   \n",
       "8                2000         1   4.748314    creditcard   \n",
       "9                   4         1   4.461622    creditcard   \n",
       "10                 26         1   4.745402        paypal   \n",
       "11               2000         1   4.505662    creditcard   \n",
       "12                  3         1   4.962055    creditcard   \n",
       "13                  3         1   4.921318    creditcard   \n",
       "14                 23         1   4.745402    creditcard   \n",
       "15                  5         1   4.921349        paypal   \n",
       "16               1208         1   4.836982    creditcard   \n",
       "17                 11         1   4.921349    creditcard   \n",
       "18                123         1   4.748314    creditcard   \n",
       "19               2000         1   4.895263    creditcard   \n",
       "20               1672         1   5.034622    creditcard   \n",
       "21                 36         1   4.742303    creditcard   \n",
       "22                 16         1   4.886641    creditcard   \n",
       "23                278         1   5.034622    creditcard   \n",
       "24                223         1   4.748314    creditcard   \n",
       "25                 30         1   4.057414    creditcard   \n",
       "26                  2         1   4.921349    creditcard   \n",
       "27               2000         1   3.483951    creditcard   \n",
       "28               1936         1   4.057414    creditcard   \n",
       "29               2000         1   4.921318    creditcard   \n",
       "...               ...       ...        ...           ...   \n",
       "39191             137         1   4.461622    creditcard   \n",
       "39192            2000         1   4.876771    creditcard   \n",
       "39193             156         1   4.886641        paypal   \n",
       "39194             225         1   4.461622    creditcard   \n",
       "39195            1631         1   4.876771    creditcard   \n",
       "39196             491         1   4.921318    creditcard   \n",
       "39197             490         1   4.748314    creditcard   \n",
       "39198              83         1   4.057414        paypal   \n",
       "39199             150         1   4.895263    creditcard   \n",
       "39200             936         1   4.745402    creditcard   \n",
       "39201              84         1   4.895263    creditcard   \n",
       "39202             124         1   4.524580    creditcard   \n",
       "39203             131         1   4.921318    creditcard   \n",
       "39204             192         1   2.948940    creditcard   \n",
       "39205             241         1   5.017904        paypal   \n",
       "39206            1116         1   4.895263    creditcard   \n",
       "39207            2000         1   4.921349    creditcard   \n",
       "39208             508         1   4.748314    creditcard   \n",
       "39209             629         1   4.876771    creditcard   \n",
       "39210            1607         1   4.886641    creditcard   \n",
       "39211            2000         1   4.886641    creditcard   \n",
       "39212            2000         1   5.040929    creditcard   \n",
       "39213             108         1   4.748314    creditcard   \n",
       "39214             101         2   4.524580   storecredit   \n",
       "39215            1257         1   4.965339    creditcard   \n",
       "39216             986         1   4.836982    creditcard   \n",
       "39217            1647         1   4.876771    creditcard   \n",
       "39218            1591         1   4.742303    creditcard   \n",
       "39219             237         1   4.921318    creditcard   \n",
       "39220             272         1   5.040929        paypal   \n",
       "\n",
       "       paymentMethodAgeDays  label  \n",
       "0                 28.204861      0  \n",
       "1                  0.000000      0  \n",
       "2                  0.000000      0  \n",
       "3                  0.000000      0  \n",
       "4                  0.000000      0  \n",
       "5                  0.000000      0  \n",
       "6                  0.000000      0  \n",
       "7                  0.000000      0  \n",
       "8                  0.000000      0  \n",
       "9                  0.000000      0  \n",
       "10                 0.000000      0  \n",
       "11                 0.000694      0  \n",
       "12                 2.690972      0  \n",
       "13                 2.069444      0  \n",
       "14                 0.001389      0  \n",
       "15                 4.036111      0  \n",
       "16                 0.000694      0  \n",
       "17                10.865972      0  \n",
       "18                 0.000694      0  \n",
       "19               248.774306      0  \n",
       "20               978.752778      0  \n",
       "21                 0.014583      0  \n",
       "22                15.796528      0  \n",
       "23                 6.892361      0  \n",
       "24                 0.000000      0  \n",
       "25                 0.000000      0  \n",
       "26                 0.000000      0  \n",
       "27               503.425000      0  \n",
       "28               635.641667      0  \n",
       "29               948.806944      0  \n",
       "...                     ...    ...  \n",
       "39191            136.703472      0  \n",
       "39192              0.000000      0  \n",
       "39193             91.781944      0  \n",
       "39194              0.000000      0  \n",
       "39195              0.000000      0  \n",
       "39196             22.220833      0  \n",
       "39197              0.005556      0  \n",
       "39198             82.795139      0  \n",
       "39199            149.981944      0  \n",
       "39200              1.772917      0  \n",
       "39201             83.018056      0  \n",
       "39202            123.047917      0  \n",
       "39203              0.000000      0  \n",
       "39204            181.184722      0  \n",
       "39205              0.000000      0  \n",
       "39206              0.000000      0  \n",
       "39207            410.779167      0  \n",
       "39208            357.716667      0  \n",
       "39209            258.222222      0  \n",
       "39210              0.000000      0  \n",
       "39211              0.000000      0  \n",
       "39212            185.286806      0  \n",
       "39213             48.965278      0  \n",
       "39214            100.746528      0  \n",
       "39215            813.097222      0  \n",
       "39216              0.000000      0  \n",
       "39217            377.930556      0  \n",
       "39218              0.000000      0  \n",
       "39219            236.082639      0  \n",
       "39220              0.000694      0  \n",
       "\n",
       "[39221 rows x 6 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfp "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.get_dummies(dfp, columns=['paymentMethod'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>accountAgeDays</th>\n",
       "      <th>numItems</th>\n",
       "      <th>localTime</th>\n",
       "      <th>paymentMethodAgeDays</th>\n",
       "      <th>label</th>\n",
       "      <th>paymentMethod_creditcard</th>\n",
       "      <th>paymentMethod_paypal</th>\n",
       "      <th>paymentMethod_storecredit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>29</td>\n",
       "      <td>1</td>\n",
       "      <td>4.745402</td>\n",
       "      <td>28.204861</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>725</td>\n",
       "      <td>1</td>\n",
       "      <td>4.742303</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>845</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921318</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>503</td>\n",
       "      <td>1</td>\n",
       "      <td>4.886641</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>5.040929</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>119</td>\n",
       "      <td>1</td>\n",
       "      <td>4.962055</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921349</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>371</td>\n",
       "      <td>1</td>\n",
       "      <td>4.876771</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.748314</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>4.461622</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>26</td>\n",
       "      <td>1</td>\n",
       "      <td>4.745402</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.505662</td>\n",
       "      <td>0.000694</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>4.962055</td>\n",
       "      <td>2.690972</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921318</td>\n",
       "      <td>2.069444</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>4.745402</td>\n",
       "      <td>0.001389</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921349</td>\n",
       "      <td>4.036111</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1208</td>\n",
       "      <td>1</td>\n",
       "      <td>4.836982</td>\n",
       "      <td>0.000694</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921349</td>\n",
       "      <td>10.865972</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>123</td>\n",
       "      <td>1</td>\n",
       "      <td>4.748314</td>\n",
       "      <td>0.000694</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.895263</td>\n",
       "      <td>248.774306</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1672</td>\n",
       "      <td>1</td>\n",
       "      <td>5.034622</td>\n",
       "      <td>978.752778</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>36</td>\n",
       "      <td>1</td>\n",
       "      <td>4.742303</td>\n",
       "      <td>0.014583</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>4.886641</td>\n",
       "      <td>15.796528</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>278</td>\n",
       "      <td>1</td>\n",
       "      <td>5.034622</td>\n",
       "      <td>6.892361</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>223</td>\n",
       "      <td>1</td>\n",
       "      <td>4.748314</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>4.057414</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921349</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>3.483951</td>\n",
       "      <td>503.425000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1936</td>\n",
       "      <td>1</td>\n",
       "      <td>4.057414</td>\n",
       "      <td>635.641667</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921318</td>\n",
       "      <td>948.806944</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39191</th>\n",
       "      <td>137</td>\n",
       "      <td>1</td>\n",
       "      <td>4.461622</td>\n",
       "      <td>136.703472</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39192</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.876771</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39193</th>\n",
       "      <td>156</td>\n",
       "      <td>1</td>\n",
       "      <td>4.886641</td>\n",
       "      <td>91.781944</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39194</th>\n",
       "      <td>225</td>\n",
       "      <td>1</td>\n",
       "      <td>4.461622</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39195</th>\n",
       "      <td>1631</td>\n",
       "      <td>1</td>\n",
       "      <td>4.876771</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39196</th>\n",
       "      <td>491</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921318</td>\n",
       "      <td>22.220833</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39197</th>\n",
       "      <td>490</td>\n",
       "      <td>1</td>\n",
       "      <td>4.748314</td>\n",
       "      <td>0.005556</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39198</th>\n",
       "      <td>83</td>\n",
       "      <td>1</td>\n",
       "      <td>4.057414</td>\n",
       "      <td>82.795139</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39199</th>\n",
       "      <td>150</td>\n",
       "      <td>1</td>\n",
       "      <td>4.895263</td>\n",
       "      <td>149.981944</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39200</th>\n",
       "      <td>936</td>\n",
       "      <td>1</td>\n",
       "      <td>4.745402</td>\n",
       "      <td>1.772917</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39201</th>\n",
       "      <td>84</td>\n",
       "      <td>1</td>\n",
       "      <td>4.895263</td>\n",
       "      <td>83.018056</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39202</th>\n",
       "      <td>124</td>\n",
       "      <td>1</td>\n",
       "      <td>4.524580</td>\n",
       "      <td>123.047917</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39203</th>\n",
       "      <td>131</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921318</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39204</th>\n",
       "      <td>192</td>\n",
       "      <td>1</td>\n",
       "      <td>2.948940</td>\n",
       "      <td>181.184722</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39205</th>\n",
       "      <td>241</td>\n",
       "      <td>1</td>\n",
       "      <td>5.017904</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39206</th>\n",
       "      <td>1116</td>\n",
       "      <td>1</td>\n",
       "      <td>4.895263</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39207</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921349</td>\n",
       "      <td>410.779167</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39208</th>\n",
       "      <td>508</td>\n",
       "      <td>1</td>\n",
       "      <td>4.748314</td>\n",
       "      <td>357.716667</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39209</th>\n",
       "      <td>629</td>\n",
       "      <td>1</td>\n",
       "      <td>4.876771</td>\n",
       "      <td>258.222222</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39210</th>\n",
       "      <td>1607</td>\n",
       "      <td>1</td>\n",
       "      <td>4.886641</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39211</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.886641</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39212</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>5.040929</td>\n",
       "      <td>185.286806</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39213</th>\n",
       "      <td>108</td>\n",
       "      <td>1</td>\n",
       "      <td>4.748314</td>\n",
       "      <td>48.965278</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39214</th>\n",
       "      <td>101</td>\n",
       "      <td>2</td>\n",
       "      <td>4.524580</td>\n",
       "      <td>100.746528</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39215</th>\n",
       "      <td>1257</td>\n",
       "      <td>1</td>\n",
       "      <td>4.965339</td>\n",
       "      <td>813.097222</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39216</th>\n",
       "      <td>986</td>\n",
       "      <td>1</td>\n",
       "      <td>4.836982</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39217</th>\n",
       "      <td>1647</td>\n",
       "      <td>1</td>\n",
       "      <td>4.876771</td>\n",
       "      <td>377.930556</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39218</th>\n",
       "      <td>1591</td>\n",
       "      <td>1</td>\n",
       "      <td>4.742303</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39219</th>\n",
       "      <td>237</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921318</td>\n",
       "      <td>236.082639</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39220</th>\n",
       "      <td>272</td>\n",
       "      <td>1</td>\n",
       "      <td>5.040929</td>\n",
       "      <td>0.000694</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>39221 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       accountAgeDays  numItems  localTime  paymentMethodAgeDays  label  \\\n",
       "0                  29         1   4.745402             28.204861      0   \n",
       "1                 725         1   4.742303              0.000000      0   \n",
       "2                 845         1   4.921318              0.000000      0   \n",
       "3                 503         1   4.886641              0.000000      0   \n",
       "4                2000         1   5.040929              0.000000      0   \n",
       "5                 119         1   4.962055              0.000000      0   \n",
       "6                2000         1   4.921349              0.000000      0   \n",
       "7                 371         1   4.876771              0.000000      0   \n",
       "8                2000         1   4.748314              0.000000      0   \n",
       "9                   4         1   4.461622              0.000000      0   \n",
       "10                 26         1   4.745402              0.000000      0   \n",
       "11               2000         1   4.505662              0.000694      0   \n",
       "12                  3         1   4.962055              2.690972      0   \n",
       "13                  3         1   4.921318              2.069444      0   \n",
       "14                 23         1   4.745402              0.001389      0   \n",
       "15                  5         1   4.921349              4.036111      0   \n",
       "16               1208         1   4.836982              0.000694      0   \n",
       "17                 11         1   4.921349             10.865972      0   \n",
       "18                123         1   4.748314              0.000694      0   \n",
       "19               2000         1   4.895263            248.774306      0   \n",
       "20               1672         1   5.034622            978.752778      0   \n",
       "21                 36         1   4.742303              0.014583      0   \n",
       "22                 16         1   4.886641             15.796528      0   \n",
       "23                278         1   5.034622              6.892361      0   \n",
       "24                223         1   4.748314              0.000000      0   \n",
       "25                 30         1   4.057414              0.000000      0   \n",
       "26                  2         1   4.921349              0.000000      0   \n",
       "27               2000         1   3.483951            503.425000      0   \n",
       "28               1936         1   4.057414            635.641667      0   \n",
       "29               2000         1   4.921318            948.806944      0   \n",
       "...               ...       ...        ...                   ...    ...   \n",
       "39191             137         1   4.461622            136.703472      0   \n",
       "39192            2000         1   4.876771              0.000000      0   \n",
       "39193             156         1   4.886641             91.781944      0   \n",
       "39194             225         1   4.461622              0.000000      0   \n",
       "39195            1631         1   4.876771              0.000000      0   \n",
       "39196             491         1   4.921318             22.220833      0   \n",
       "39197             490         1   4.748314              0.005556      0   \n",
       "39198              83         1   4.057414             82.795139      0   \n",
       "39199             150         1   4.895263            149.981944      0   \n",
       "39200             936         1   4.745402              1.772917      0   \n",
       "39201              84         1   4.895263             83.018056      0   \n",
       "39202             124         1   4.524580            123.047917      0   \n",
       "39203             131         1   4.921318              0.000000      0   \n",
       "39204             192         1   2.948940            181.184722      0   \n",
       "39205             241         1   5.017904              0.000000      0   \n",
       "39206            1116         1   4.895263              0.000000      0   \n",
       "39207            2000         1   4.921349            410.779167      0   \n",
       "39208             508         1   4.748314            357.716667      0   \n",
       "39209             629         1   4.876771            258.222222      0   \n",
       "39210            1607         1   4.886641              0.000000      0   \n",
       "39211            2000         1   4.886641              0.000000      0   \n",
       "39212            2000         1   5.040929            185.286806      0   \n",
       "39213             108         1   4.748314             48.965278      0   \n",
       "39214             101         2   4.524580            100.746528      0   \n",
       "39215            1257         1   4.965339            813.097222      0   \n",
       "39216             986         1   4.836982              0.000000      0   \n",
       "39217            1647         1   4.876771            377.930556      0   \n",
       "39218            1591         1   4.742303              0.000000      0   \n",
       "39219             237         1   4.921318            236.082639      0   \n",
       "39220             272         1   5.040929              0.000694      0   \n",
       "\n",
       "       paymentMethod_creditcard  paymentMethod_paypal  \\\n",
       "0                             0                     1   \n",
       "1                             0                     0   \n",
       "2                             1                     0   \n",
       "3                             1                     0   \n",
       "4                             1                     0   \n",
       "5                             0                     1   \n",
       "6                             0                     1   \n",
       "7                             1                     0   \n",
       "8                             1                     0   \n",
       "9                             1                     0   \n",
       "10                            0                     1   \n",
       "11                            1                     0   \n",
       "12                            1                     0   \n",
       "13                            1                     0   \n",
       "14                            1                     0   \n",
       "15                            0                     1   \n",
       "16                            1                     0   \n",
       "17                            1                     0   \n",
       "18                            1                     0   \n",
       "19                            1                     0   \n",
       "20                            1                     0   \n",
       "21                            1                     0   \n",
       "22                            1                     0   \n",
       "23                            1                     0   \n",
       "24                            1                     0   \n",
       "25                            1                     0   \n",
       "26                            1                     0   \n",
       "27                            1                     0   \n",
       "28                            1                     0   \n",
       "29                            1                     0   \n",
       "...                         ...                   ...   \n",
       "39191                         1                     0   \n",
       "39192                         1                     0   \n",
       "39193                         0                     1   \n",
       "39194                         1                     0   \n",
       "39195                         1                     0   \n",
       "39196                         1                     0   \n",
       "39197                         1                     0   \n",
       "39198                         0                     1   \n",
       "39199                         1                     0   \n",
       "39200                         1                     0   \n",
       "39201                         1                     0   \n",
       "39202                         1                     0   \n",
       "39203                         1                     0   \n",
       "39204                         1                     0   \n",
       "39205                         0                     1   \n",
       "39206                         1                     0   \n",
       "39207                         1                     0   \n",
       "39208                         1                     0   \n",
       "39209                         1                     0   \n",
       "39210                         1                     0   \n",
       "39211                         1                     0   \n",
       "39212                         1                     0   \n",
       "39213                         1                     0   \n",
       "39214                         0                     0   \n",
       "39215                         1                     0   \n",
       "39216                         1                     0   \n",
       "39217                         1                     0   \n",
       "39218                         1                     0   \n",
       "39219                         1                     0   \n",
       "39220                         0                     1   \n",
       "\n",
       "       paymentMethod_storecredit  \n",
       "0                              0  \n",
       "1                              1  \n",
       "2                              0  \n",
       "3                              0  \n",
       "4                              0  \n",
       "5                              0  \n",
       "6                              0  \n",
       "7                              0  \n",
       "8                              0  \n",
       "9                              0  \n",
       "10                             0  \n",
       "11                             0  \n",
       "12                             0  \n",
       "13                             0  \n",
       "14                             0  \n",
       "15                             0  \n",
       "16                             0  \n",
       "17                             0  \n",
       "18                             0  \n",
       "19                             0  \n",
       "20                             0  \n",
       "21                             0  \n",
       "22                             0  \n",
       "23                             0  \n",
       "24                             0  \n",
       "25                             0  \n",
       "26                             0  \n",
       "27                             0  \n",
       "28                             0  \n",
       "29                             0  \n",
       "...                          ...  \n",
       "39191                          0  \n",
       "39192                          0  \n",
       "39193                          0  \n",
       "39194                          0  \n",
       "39195                          0  \n",
       "39196                          0  \n",
       "39197                          0  \n",
       "39198                          0  \n",
       "39199                          0  \n",
       "39200                          0  \n",
       "39201                          0  \n",
       "39202                          0  \n",
       "39203                          0  \n",
       "39204                          0  \n",
       "39205                          0  \n",
       "39206                          0  \n",
       "39207                          0  \n",
       "39208                          0  \n",
       "39209                          0  \n",
       "39210                          0  \n",
       "39211                          0  \n",
       "39212                          0  \n",
       "39213                          0  \n",
       "39214                          1  \n",
       "39215                          0  \n",
       "39216                          0  \n",
       "39217                          0  \n",
       "39218                          0  \n",
       "39219                          0  \n",
       "39220                          0  \n",
       "\n",
       "[39221 rows x 8 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.model_selection import train_test_split"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "X_train, X_test, y_train, y_test = train_test_split(\n",
    "    df.drop('label', axis=1), df['label'],\n",
    "    test_size=0.33, random_state=17)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>accountAgeDays</th>\n",
       "      <th>numItems</th>\n",
       "      <th>localTime</th>\n",
       "      <th>paymentMethodAgeDays</th>\n",
       "      <th>paymentMethod_creditcard</th>\n",
       "      <th>paymentMethod_paypal</th>\n",
       "      <th>paymentMethod_storecredit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>13272</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>4.886641</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22716</th>\n",
       "      <td>1554</td>\n",
       "      <td>1</td>\n",
       "      <td>4.461622</td>\n",
       "      <td>0.256944</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30255</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>4.742303</td>\n",
       "      <td>1.840278</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7676</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.748314</td>\n",
       "      <td>0.584028</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15105</th>\n",
       "      <td>157</td>\n",
       "      <td>1</td>\n",
       "      <td>5.017904</td>\n",
       "      <td>156.022222</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31782</th>\n",
       "      <td>644</td>\n",
       "      <td>1</td>\n",
       "      <td>4.895263</td>\n",
       "      <td>1.568056</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33547</th>\n",
       "      <td>100</td>\n",
       "      <td>1</td>\n",
       "      <td>5.017904</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9009</th>\n",
       "      <td>260</td>\n",
       "      <td>1</td>\n",
       "      <td>5.034622</td>\n",
       "      <td>259.775000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16172</th>\n",
       "      <td>1213</td>\n",
       "      <td>3</td>\n",
       "      <td>5.040929</td>\n",
       "      <td>0.013194</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22553</th>\n",
       "      <td>892</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921349</td>\n",
       "      <td>97.968750</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35976</th>\n",
       "      <td>337</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921318</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17282</th>\n",
       "      <td>1903</td>\n",
       "      <td>1</td>\n",
       "      <td>4.836982</td>\n",
       "      <td>0.000694</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24434</th>\n",
       "      <td>889</td>\n",
       "      <td>1</td>\n",
       "      <td>4.745402</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14254</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>4.962055</td>\n",
       "      <td>0.001389</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13591</th>\n",
       "      <td>579</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921318</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3822</th>\n",
       "      <td>77</td>\n",
       "      <td>1</td>\n",
       "      <td>4.836982</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12972</th>\n",
       "      <td>204</td>\n",
       "      <td>1</td>\n",
       "      <td>4.962055</td>\n",
       "      <td>73.897917</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29868</th>\n",
       "      <td>1016</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921318</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38599</th>\n",
       "      <td>127</td>\n",
       "      <td>1</td>\n",
       "      <td>5.034622</td>\n",
       "      <td>41.326389</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17640</th>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921318</td>\n",
       "      <td>4.133333</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15671</th>\n",
       "      <td>1941</td>\n",
       "      <td>1</td>\n",
       "      <td>4.748314</td>\n",
       "      <td>2.820833</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4399</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.505662</td>\n",
       "      <td>674.019444</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10136</th>\n",
       "      <td>1459</td>\n",
       "      <td>1</td>\n",
       "      <td>4.836982</td>\n",
       "      <td>100.588194</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32326</th>\n",
       "      <td>919</td>\n",
       "      <td>1</td>\n",
       "      <td>5.017904</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21101</th>\n",
       "      <td>580</td>\n",
       "      <td>5</td>\n",
       "      <td>4.895263</td>\n",
       "      <td>91.688889</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34233</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.748314</td>\n",
       "      <td>0.002083</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27831</th>\n",
       "      <td>563</td>\n",
       "      <td>1</td>\n",
       "      <td>4.461622</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29159</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.886641</td>\n",
       "      <td>356.706944</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9164</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.524580</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28458</th>\n",
       "      <td>39</td>\n",
       "      <td>1</td>\n",
       "      <td>4.524580</td>\n",
       "      <td>38.020833</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17434</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.745402</td>\n",
       "      <td>0.009722</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10199</th>\n",
       "      <td>1386</td>\n",
       "      <td>1</td>\n",
       "      <td>4.524580</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20347</th>\n",
       "      <td>210</td>\n",
       "      <td>1</td>\n",
       "      <td>4.876771</td>\n",
       "      <td>179.807639</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29682</th>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>3.954522</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18715</th>\n",
       "      <td>1701</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921349</td>\n",
       "      <td>0.002083</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19464</th>\n",
       "      <td>559</td>\n",
       "      <td>1</td>\n",
       "      <td>4.057414</td>\n",
       "      <td>1.003472</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12665</th>\n",
       "      <td>143</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921318</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15409</th>\n",
       "      <td>539</td>\n",
       "      <td>1</td>\n",
       "      <td>4.057414</td>\n",
       "      <td>6.044444</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4379</th>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>5.040929</td>\n",
       "      <td>0.000694</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19000</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4.742303</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23929</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921318</td>\n",
       "      <td>3.215972</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3116</th>\n",
       "      <td>13</td>\n",
       "      <td>2</td>\n",
       "      <td>4.895263</td>\n",
       "      <td>0.000694</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5122</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>4.876771</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2877</th>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>5.017904</td>\n",
       "      <td>3.246528</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34848</th>\n",
       "      <td>135</td>\n",
       "      <td>1</td>\n",
       "      <td>4.895263</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37870</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4.836982</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3345</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>4.965339</td>\n",
       "      <td>2.904861</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21177</th>\n",
       "      <td>459</td>\n",
       "      <td>1</td>\n",
       "      <td>4.886641</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1833</th>\n",
       "      <td>115</td>\n",
       "      <td>1</td>\n",
       "      <td>4.836982</td>\n",
       "      <td>114.260417</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7334</th>\n",
       "      <td>510</td>\n",
       "      <td>1</td>\n",
       "      <td>5.017904</td>\n",
       "      <td>0.006944</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5763</th>\n",
       "      <td>1637</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921318</td>\n",
       "      <td>154.180556</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19210</th>\n",
       "      <td>320</td>\n",
       "      <td>1</td>\n",
       "      <td>4.745402</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1774</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.965339</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14252</th>\n",
       "      <td>937</td>\n",
       "      <td>1</td>\n",
       "      <td>4.836982</td>\n",
       "      <td>173.538889</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37332</th>\n",
       "      <td>1631</td>\n",
       "      <td>1</td>\n",
       "      <td>4.962055</td>\n",
       "      <td>0.004861</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31044</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.921349</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25631</th>\n",
       "      <td>47</td>\n",
       "      <td>1</td>\n",
       "      <td>4.962055</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33174</th>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>4.748314</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34959</th>\n",
       "      <td>82</td>\n",
       "      <td>1</td>\n",
       "      <td>4.745402</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10863</th>\n",
       "      <td>481</td>\n",
       "      <td>1</td>\n",
       "      <td>4.965339</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>26278 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       accountAgeDays  numItems  localTime  paymentMethodAgeDays  \\\n",
       "13272               4         1   4.886641              0.000000   \n",
       "22716            1554         1   4.461622              0.256944   \n",
       "30255               2         1   4.742303              1.840278   \n",
       "7676             2000         1   4.748314              0.584028   \n",
       "15105             157         1   5.017904            156.022222   \n",
       "31782             644         1   4.895263              1.568056   \n",
       "33547             100         1   5.017904              0.000000   \n",
       "9009              260         1   5.034622            259.775000   \n",
       "16172            1213         3   5.040929              0.013194   \n",
       "22553             892         1   4.921349             97.968750   \n",
       "35976             337         1   4.921318              0.000000   \n",
       "17282            1903         1   4.836982              0.000694   \n",
       "24434             889         1   4.745402              0.000000   \n",
       "14254               4         1   4.962055              0.001389   \n",
       "13591             579         1   4.921318              0.000000   \n",
       "3822               77         1   4.836982              0.000000   \n",
       "12972             204         1   4.962055             73.897917   \n",
       "29868            1016         1   4.921318              0.000000   \n",
       "38599             127         1   5.034622             41.326389   \n",
       "17640               7         1   4.921318              4.133333   \n",
       "15671            1941         1   4.748314              2.820833   \n",
       "4399             2000         1   4.505662            674.019444   \n",
       "10136            1459         1   4.836982            100.588194   \n",
       "32326             919         1   5.017904              0.000000   \n",
       "21101             580         5   4.895263             91.688889   \n",
       "34233            2000         1   4.748314              0.002083   \n",
       "27831             563         1   4.461622              0.000000   \n",
       "29159            2000         1   4.886641            356.706944   \n",
       "9164             2000         1   4.524580              0.000000   \n",
       "28458              39         1   4.524580             38.020833   \n",
       "...               ...       ...        ...                   ...   \n",
       "17434            2000         1   4.745402              0.009722   \n",
       "10199            1386         1   4.524580              0.000000   \n",
       "20347             210         1   4.876771            179.807639   \n",
       "29682              40         1   3.954522              0.000000   \n",
       "18715            1701         1   4.921349              0.002083   \n",
       "19464             559         1   4.057414              1.003472   \n",
       "12665             143         1   4.921318              0.000000   \n",
       "15409             539         1   4.057414              6.044444   \n",
       "4379               27         1   5.040929              0.000694   \n",
       "19000               1         1   4.742303              0.000000   \n",
       "23929               4         1   4.921318              3.215972   \n",
       "3116               13         2   4.895263              0.000694   \n",
       "5122                2         1   4.876771              0.000000   \n",
       "2877                4         2   5.017904              3.246528   \n",
       "34848             135         1   4.895263              0.000000   \n",
       "37870               1         1   4.836982              0.000000   \n",
       "3345                3         1   4.965339              2.904861   \n",
       "21177             459         1   4.886641              0.000000   \n",
       "1833              115         1   4.836982            114.260417   \n",
       "7334              510         1   5.017904              0.006944   \n",
       "5763             1637         1   4.921318            154.180556   \n",
       "19210             320         1   4.745402              0.000000   \n",
       "1774             2000         1   4.965339              0.000000   \n",
       "14252             937         1   4.836982            173.538889   \n",
       "37332            1631         1   4.962055              0.004861   \n",
       "31044            2000         1   4.921349              0.000000   \n",
       "25631              47         1   4.962055              0.000000   \n",
       "33174            2000         1   4.748314              0.000000   \n",
       "34959              82         1   4.745402              0.000000   \n",
       "10863             481         1   4.965339              0.000000   \n",
       "\n",
       "       paymentMethod_creditcard  paymentMethod_paypal  \\\n",
       "13272                         1                     0   \n",
       "22716                         0                     0   \n",
       "30255                         1                     0   \n",
       "7676                          1                     0   \n",
       "15105                         1                     0   \n",
       "31782                         0                     0   \n",
       "33547                         0                     1   \n",
       "9009                          0                     1   \n",
       "16172                         1                     0   \n",
       "22553                         0                     1   \n",
       "35976                         0                     1   \n",
       "17282                         1                     0   \n",
       "24434                         0                     1   \n",
       "14254                         0                     1   \n",
       "13591                         1                     0   \n",
       "3822                          0                     1   \n",
       "12972                         1                     0   \n",
       "29868                         0                     1   \n",
       "38599                         1                     0   \n",
       "17640                         1                     0   \n",
       "15671                         1                     0   \n",
       "4399                          1                     0   \n",
       "10136                         1                     0   \n",
       "32326                         1                     0   \n",
       "21101                         1                     0   \n",
       "34233                         0                     1   \n",
       "27831                         1                     0   \n",
       "29159                         0                     0   \n",
       "9164                          1                     0   \n",
       "28458                         1                     0   \n",
       "...                         ...                   ...   \n",
       "17434                         0                     1   \n",
       "10199                         0                     1   \n",
       "20347                         0                     1   \n",
       "29682                         1                     0   \n",
       "18715                         0                     1   \n",
       "19464                         1                     0   \n",
       "12665                         0                     1   \n",
       "15409                         0                     1   \n",
       "4379                          1                     0   \n",
       "19000                         0                     1   \n",
       "23929                         1                     0   \n",
       "3116                          0                     0   \n",
       "5122                          0                     1   \n",
       "2877                          1                     0   \n",
       "34848                         1                     0   \n",
       "37870                         0                     1   \n",
       "3345                          1                     0   \n",
       "21177                         1                     0   \n",
       "1833                          1                     0   \n",
       "7334                          1                     0   \n",
       "5763                          1                     0   \n",
       "19210                         1                     0   \n",
       "1774                          1                     0   \n",
       "14252                         0                     0   \n",
       "37332                         1                     0   \n",
       "31044                         0                     1   \n",
       "25631                         1                     0   \n",
       "33174                         1                     0   \n",
       "34959                         1                     0   \n",
       "10863                         1                     0   \n",
       "\n",
       "       paymentMethod_storecredit  \n",
       "13272                          0  \n",
       "22716                          1  \n",
       "30255                          0  \n",
       "7676                           0  \n",
       "15105                          0  \n",
       "31782                          1  \n",
       "33547                          0  \n",
       "9009                           0  \n",
       "16172                          0  \n",
       "22553                          0  \n",
       "35976                          0  \n",
       "17282                          0  \n",
       "24434                          0  \n",
       "14254                          0  \n",
       "13591                          0  \n",
       "3822                           0  \n",
       "12972                          0  \n",
       "29868                          0  \n",
       "38599                          0  \n",
       "17640                          0  \n",
       "15671                          0  \n",
       "4399                           0  \n",
       "10136                          0  \n",
       "32326                          0  \n",
       "21101                          0  \n",
       "34233                          0  \n",
       "27831                          0  \n",
       "29159                          1  \n",
       "9164                           0  \n",
       "28458                          0  \n",
       "...                          ...  \n",
       "17434                          0  \n",
       "10199                          0  \n",
       "20347                          0  \n",
       "29682                          0  \n",
       "18715                          0  \n",
       "19464                          0  \n",
       "12665                          0  \n",
       "15409                          0  \n",
       "4379                           0  \n",
       "19000                          0  \n",
       "23929                          0  \n",
       "3116                           1  \n",
       "5122                           0  \n",
       "2877                           0  \n",
       "34848                          0  \n",
       "37870                          0  \n",
       "3345                           0  \n",
       "21177                          0  \n",
       "1833                           0  \n",
       "7334                           0  \n",
       "5763                           0  \n",
       "19210                          0  \n",
       "1774                           0  \n",
       "14252                          1  \n",
       "37332                          0  \n",
       "31044                          0  \n",
       "25631                          0  \n",
       "33174                          0  \n",
       "34959                          0  \n",
       "10863                          0  \n",
       "\n",
       "[26278 rows x 7 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "X_train"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "13272    0\n",
       "22716    0\n",
       "30255    0\n",
       "7676     0\n",
       "15105    0\n",
       "31782    0\n",
       "33547    0\n",
       "9009     0\n",
       "16172    0\n",
       "22553    0\n",
       "35976    0\n",
       "17282    0\n",
       "24434    0\n",
       "14254    0\n",
       "13591    0\n",
       "3822     0\n",
       "12972    0\n",
       "29868    0\n",
       "38599    0\n",
       "17640    0\n",
       "15671    0\n",
       "4399     0\n",
       "10136    0\n",
       "32326    0\n",
       "21101    0\n",
       "34233    0\n",
       "27831    0\n",
       "29159    0\n",
       "9164     0\n",
       "28458    0\n",
       "        ..\n",
       "17434    0\n",
       "10199    0\n",
       "20347    0\n",
       "29682    0\n",
       "18715    0\n",
       "19464    0\n",
       "12665    0\n",
       "15409    0\n",
       "4379     0\n",
       "19000    1\n",
       "23929    0\n",
       "3116     0\n",
       "5122     0\n",
       "2877     0\n",
       "34848    0\n",
       "37870    1\n",
       "3345     0\n",
       "21177    0\n",
       "1833     0\n",
       "7334     0\n",
       "5763     0\n",
       "19210    0\n",
       "1774     0\n",
       "14252    0\n",
       "37332    0\n",
       "31044    0\n",
       "25631    0\n",
       "33174    0\n",
       "34959    0\n",
       "10863    0\n",
       "Name: label, Length: 26278, dtype: int64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y_train"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "c:\\Anaconda3\\lib\\site-packages\\sklearn\\linear_model\\logistic.py:433: FutureWarning: Default solver will be changed to 'lbfgs' in 0.22. Specify a solver to silence this warning.\n",
      "  FutureWarning)\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "LogisticRegression(C=1.0, class_weight=None, dual=False, fit_intercept=True,\n",
       "          intercept_scaling=1, max_iter=100, multi_class='warn',\n",
       "          n_jobs=None, penalty='l2', random_state=None, solver='warn',\n",
       "          tol=0.0001, verbose=0, warm_start=False)"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn.linear_model import LogisticRegression\n",
    "clf = LogisticRegression()\n",
    "clf.fit(X_train, y_train)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "y_pred = clf.predict(X_test)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.metrics import accuracy_score"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0.999922738159623\n"
     ]
    }
   ],
   "source": [
    "print(accuracy_score(y_pred, y_test))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[[12753     0]\n",
      " [    1   189]]\n"
     ]
    }
   ],
   "source": [
    "print(confusion_matrix(y_test, y_pred))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}