random_foest_Fraud Model.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib \n",
    "df = pd.read_csv(r'/Users/calyamp/Downloads/1625247454.3564217.CSV',encoding='latin-1')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>User Name</th>\n",
       "      <th>Driver Id</th>\n",
       "      <th>Policy Number</th>\n",
       "      <th>D.O.P</th>\n",
       "      <th>Block Id</th>\n",
       "      <th>Location</th>\n",
       "      <th>Issue</th>\n",
       "      <th>D.O.I</th>\n",
       "      <th>D.O.R</th>\n",
       "      <th>Amount</th>\n",
       "      <th>Asset</th>\n",
       "      <th>Sybil Attack</th>\n",
       "      <th>Claim Id</th>\n",
       "      <th>Age</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>James Stanley</td>\n",
       "      <td>4308341</td>\n",
       "      <td>9498470</td>\n",
       "      <td>3/3/2020</td>\n",
       "      <td>28254</td>\n",
       "      <td>McKenzie, AL</td>\n",
       "      <td>Hit and Run</td>\n",
       "      <td>05/19/2021</td>\n",
       "      <td>06/22/2021</td>\n",
       "      <td>2578</td>\n",
       "      <td>20626</td>\n",
       "      <td>1</td>\n",
       "      <td>9776250</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Paul Brandenburg</td>\n",
       "      <td>3277845</td>\n",
       "      <td>9981126</td>\n",
       "      <td>6/19/2020</td>\n",
       "      <td>43452</td>\n",
       "      <td>Otis Orchards-East Farms, WA</td>\n",
       "      <td>Hit and Run</td>\n",
       "      <td>05/26/2021</td>\n",
       "      <td>05/28/2021</td>\n",
       "      <td>12622</td>\n",
       "      <td>5169</td>\n",
       "      <td>0</td>\n",
       "      <td>3301936</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Wilma Rodgers</td>\n",
       "      <td>2592850</td>\n",
       "      <td>5301267</td>\n",
       "      <td>4/7/2020</td>\n",
       "      <td>69887</td>\n",
       "      <td>Fifty-Six, AR</td>\n",
       "      <td>Bike &amp; Car Accident</td>\n",
       "      <td>12/03/2020</td>\n",
       "      <td>06/03/2021</td>\n",
       "      <td>15577</td>\n",
       "      <td>5234</td>\n",
       "      <td>0</td>\n",
       "      <td>7280014</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Rhonda Jones</td>\n",
       "      <td>6937168</td>\n",
       "      <td>4294524</td>\n",
       "      <td>10/1/2020</td>\n",
       "      <td>55092</td>\n",
       "      <td>Cidra, PR</td>\n",
       "      <td>Hit and Run</td>\n",
       "      <td>01/25/2021</td>\n",
       "      <td>03/17/2021</td>\n",
       "      <td>19605</td>\n",
       "      <td>26827</td>\n",
       "      <td>0</td>\n",
       "      <td>5169910</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>John Mayo</td>\n",
       "      <td>4308616</td>\n",
       "      <td>8584296</td>\n",
       "      <td>4/4/2020</td>\n",
       "      <td>13330</td>\n",
       "      <td>Vintondale, PA</td>\n",
       "      <td>Hit and Run</td>\n",
       "      <td>01/24/2021</td>\n",
       "      <td>02/14/2021</td>\n",
       "      <td>12961</td>\n",
       "      <td>49696</td>\n",
       "      <td>0</td>\n",
       "      <td>9167296</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81299</th>\n",
       "      <td>Diane Joiner</td>\n",
       "      <td>2539231</td>\n",
       "      <td>9803605</td>\n",
       "      <td>7/3/2020</td>\n",
       "      <td>64541</td>\n",
       "      <td>East Prairie, MO</td>\n",
       "      <td>Auto Theft</td>\n",
       "      <td>11/10/2020</td>\n",
       "      <td>03/27/2021</td>\n",
       "      <td>9948</td>\n",
       "      <td>36522</td>\n",
       "      <td>0</td>\n",
       "      <td>4484900</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81300</th>\n",
       "      <td>Geneva Beard</td>\n",
       "      <td>7597027</td>\n",
       "      <td>3792630</td>\n",
       "      <td>7/3/2020</td>\n",
       "      <td>20035</td>\n",
       "      <td>Snowflake, AZ</td>\n",
       "      <td>Single Car Accident</td>\n",
       "      <td>03/10/2021</td>\n",
       "      <td>06/19/2021</td>\n",
       "      <td>12909</td>\n",
       "      <td>52060</td>\n",
       "      <td>0</td>\n",
       "      <td>9268155</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81301</th>\n",
       "      <td>Carole Garcia</td>\n",
       "      <td>1683676</td>\n",
       "      <td>5957932</td>\n",
       "      <td>9/3/2020</td>\n",
       "      <td>52249</td>\n",
       "      <td>Millport, AL</td>\n",
       "      <td>Multiple Car Accident</td>\n",
       "      <td>03/23/2021</td>\n",
       "      <td>06/20/2021</td>\n",
       "      <td>3535</td>\n",
       "      <td>34720</td>\n",
       "      <td>0</td>\n",
       "      <td>8672841</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81302</th>\n",
       "      <td>Elizabeth Herrera</td>\n",
       "      <td>3393152</td>\n",
       "      <td>1773937</td>\n",
       "      <td>12/9/2020</td>\n",
       "      <td>27938</td>\n",
       "      <td>Ozawkie, KS</td>\n",
       "      <td>Bike &amp; Car Accident</td>\n",
       "      <td>05/13/2021</td>\n",
       "      <td>06/15/2021</td>\n",
       "      <td>15004</td>\n",
       "      <td>16123</td>\n",
       "      <td>0</td>\n",
       "      <td>4128732</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81303</th>\n",
       "      <td>Robert Davis</td>\n",
       "      <td>8326057</td>\n",
       "      <td>8682785</td>\n",
       "      <td>7/1/2020</td>\n",
       "      <td>39759</td>\n",
       "      <td>Miramiguoa Park, MO</td>\n",
       "      <td>Multiple Car Accident</td>\n",
       "      <td>12/19/2020</td>\n",
       "      <td>02/06/2021</td>\n",
       "      <td>7986</td>\n",
       "      <td>6348</td>\n",
       "      <td>0</td>\n",
       "      <td>6744426</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>81304 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               User Name  Driver Id  Policy Number      D.O.P  Block Id  \\\n",
       "0          James Stanley    4308341        9498470   3/3/2020     28254   \n",
       "1       Paul Brandenburg    3277845        9981126  6/19/2020     43452   \n",
       "2          Wilma Rodgers    2592850        5301267   4/7/2020     69887   \n",
       "3           Rhonda Jones    6937168        4294524  10/1/2020     55092   \n",
       "4              John Mayo    4308616        8584296   4/4/2020     13330   \n",
       "...                  ...        ...            ...        ...       ...   \n",
       "81299       Diane Joiner    2539231        9803605   7/3/2020     64541   \n",
       "81300       Geneva Beard    7597027        3792630   7/3/2020     20035   \n",
       "81301      Carole Garcia    1683676        5957932   9/3/2020     52249   \n",
       "81302  Elizabeth Herrera    3393152        1773937  12/9/2020     27938   \n",
       "81303       Robert Davis    8326057        8682785   7/1/2020     39759   \n",
       "\n",
       "                           Location                  Issue       D.O.I  \\\n",
       "0                      McKenzie, AL            Hit and Run  05/19/2021   \n",
       "1      Otis Orchards-East Farms, WA            Hit and Run  05/26/2021   \n",
       "2                     Fifty-Six, AR    Bike & Car Accident  12/03/2020   \n",
       "3                         Cidra, PR            Hit and Run  01/25/2021   \n",
       "4                    Vintondale, PA            Hit and Run  01/24/2021   \n",
       "...                             ...                    ...         ...   \n",
       "81299              East Prairie, MO             Auto Theft  11/10/2020   \n",
       "81300                 Snowflake, AZ    Single Car Accident  03/10/2021   \n",
       "81301                  Millport, AL  Multiple Car Accident  03/23/2021   \n",
       "81302                   Ozawkie, KS    Bike & Car Accident  05/13/2021   \n",
       "81303           Miramiguoa Park, MO  Multiple Car Accident  12/19/2020   \n",
       "\n",
       "            D.O.R  Amount  Asset  Sybil Attack  Claim Id  Age  \n",
       "0      06/22/2021    2578  20626             1   9776250   40  \n",
       "1      05/28/2021   12622   5169             0   3301936   54  \n",
       "2      06/03/2021   15577   5234             0   7280014   58  \n",
       "3      03/17/2021   19605  26827             0   5169910   55  \n",
       "4      02/14/2021   12961  49696             0   9167296   55  \n",
       "...           ...     ...    ...           ...       ...  ...  \n",
       "81299  03/27/2021    9948  36522             0   4484900   39  \n",
       "81300  06/19/2021   12909  52060             0   9268155   32  \n",
       "81301  06/20/2021    3535  34720             0   8672841   17  \n",
       "81302  06/15/2021   15004  16123             0   4128732   53  \n",
       "81303  02/06/2021    7986   6348             0   6744426   39  \n",
       "\n",
       "[81304 rows x 14 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "X = df.drop(['Sybil Attack'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>User Name</th>\n",
       "      <th>Driver Id</th>\n",
       "      <th>Policy Number</th>\n",
       "      <th>D.O.P</th>\n",
       "      <th>Block Id</th>\n",
       "      <th>Location</th>\n",
       "      <th>Issue</th>\n",
       "      <th>D.O.I</th>\n",
       "      <th>D.O.R</th>\n",
       "      <th>Amount</th>\n",
       "      <th>Asset</th>\n",
       "      <th>Claim Id</th>\n",
       "      <th>Age</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>James Stanley</td>\n",
       "      <td>4308341</td>\n",
       "      <td>9498470</td>\n",
       "      <td>3/3/2020</td>\n",
       "      <td>28254</td>\n",
       "      <td>McKenzie, AL</td>\n",
       "      <td>Hit and Run</td>\n",
       "      <td>05/19/2021</td>\n",
       "      <td>06/22/2021</td>\n",
       "      <td>2578</td>\n",
       "      <td>20626</td>\n",
       "      <td>9776250</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Paul Brandenburg</td>\n",
       "      <td>3277845</td>\n",
       "      <td>9981126</td>\n",
       "      <td>6/19/2020</td>\n",
       "      <td>43452</td>\n",
       "      <td>Otis Orchards-East Farms, WA</td>\n",
       "      <td>Hit and Run</td>\n",
       "      <td>05/26/2021</td>\n",
       "      <td>05/28/2021</td>\n",
       "      <td>12622</td>\n",
       "      <td>5169</td>\n",
       "      <td>3301936</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Wilma Rodgers</td>\n",
       "      <td>2592850</td>\n",
       "      <td>5301267</td>\n",
       "      <td>4/7/2020</td>\n",
       "      <td>69887</td>\n",
       "      <td>Fifty-Six, AR</td>\n",
       "      <td>Bike &amp; Car Accident</td>\n",
       "      <td>12/03/2020</td>\n",
       "      <td>06/03/2021</td>\n",
       "      <td>15577</td>\n",
       "      <td>5234</td>\n",
       "      <td>7280014</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Rhonda Jones</td>\n",
       "      <td>6937168</td>\n",
       "      <td>4294524</td>\n",
       "      <td>10/1/2020</td>\n",
       "      <td>55092</td>\n",
       "      <td>Cidra, PR</td>\n",
       "      <td>Hit and Run</td>\n",
       "      <td>01/25/2021</td>\n",
       "      <td>03/17/2021</td>\n",
       "      <td>19605</td>\n",
       "      <td>26827</td>\n",
       "      <td>5169910</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>John Mayo</td>\n",
       "      <td>4308616</td>\n",
       "      <td>8584296</td>\n",
       "      <td>4/4/2020</td>\n",
       "      <td>13330</td>\n",
       "      <td>Vintondale, PA</td>\n",
       "      <td>Hit and Run</td>\n",
       "      <td>01/24/2021</td>\n",
       "      <td>02/14/2021</td>\n",
       "      <td>12961</td>\n",
       "      <td>49696</td>\n",
       "      <td>9167296</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81299</th>\n",
       "      <td>Diane Joiner</td>\n",
       "      <td>2539231</td>\n",
       "      <td>9803605</td>\n",
       "      <td>7/3/2020</td>\n",
       "      <td>64541</td>\n",
       "      <td>East Prairie, MO</td>\n",
       "      <td>Auto Theft</td>\n",
       "      <td>11/10/2020</td>\n",
       "      <td>03/27/2021</td>\n",
       "      <td>9948</td>\n",
       "      <td>36522</td>\n",
       "      <td>4484900</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81300</th>\n",
       "      <td>Geneva Beard</td>\n",
       "      <td>7597027</td>\n",
       "      <td>3792630</td>\n",
       "      <td>7/3/2020</td>\n",
       "      <td>20035</td>\n",
       "      <td>Snowflake, AZ</td>\n",
       "      <td>Single Car Accident</td>\n",
       "      <td>03/10/2021</td>\n",
       "      <td>06/19/2021</td>\n",
       "      <td>12909</td>\n",
       "      <td>52060</td>\n",
       "      <td>9268155</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81301</th>\n",
       "      <td>Carole Garcia</td>\n",
       "      <td>1683676</td>\n",
       "      <td>5957932</td>\n",
       "      <td>9/3/2020</td>\n",
       "      <td>52249</td>\n",
       "      <td>Millport, AL</td>\n",
       "      <td>Multiple Car Accident</td>\n",
       "      <td>03/23/2021</td>\n",
       "      <td>06/20/2021</td>\n",
       "      <td>3535</td>\n",
       "      <td>34720</td>\n",
       "      <td>8672841</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81302</th>\n",
       "      <td>Elizabeth Herrera</td>\n",
       "      <td>3393152</td>\n",
       "      <td>1773937</td>\n",
       "      <td>12/9/2020</td>\n",
       "      <td>27938</td>\n",
       "      <td>Ozawkie, KS</td>\n",
       "      <td>Bike &amp; Car Accident</td>\n",
       "      <td>05/13/2021</td>\n",
       "      <td>06/15/2021</td>\n",
       "      <td>15004</td>\n",
       "      <td>16123</td>\n",
       "      <td>4128732</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81303</th>\n",
       "      <td>Robert Davis</td>\n",
       "      <td>8326057</td>\n",
       "      <td>8682785</td>\n",
       "      <td>7/1/2020</td>\n",
       "      <td>39759</td>\n",
       "      <td>Miramiguoa Park, MO</td>\n",
       "      <td>Multiple Car Accident</td>\n",
       "      <td>12/19/2020</td>\n",
       "      <td>02/06/2021</td>\n",
       "      <td>7986</td>\n",
       "      <td>6348</td>\n",
       "      <td>6744426</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>81304 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               User Name  Driver Id  Policy Number      D.O.P  Block Id  \\\n",
       "0          James Stanley    4308341        9498470   3/3/2020     28254   \n",
       "1       Paul Brandenburg    3277845        9981126  6/19/2020     43452   \n",
       "2          Wilma Rodgers    2592850        5301267   4/7/2020     69887   \n",
       "3           Rhonda Jones    6937168        4294524  10/1/2020     55092   \n",
       "4              John Mayo    4308616        8584296   4/4/2020     13330   \n",
       "...                  ...        ...            ...        ...       ...   \n",
       "81299       Diane Joiner    2539231        9803605   7/3/2020     64541   \n",
       "81300       Geneva Beard    7597027        3792630   7/3/2020     20035   \n",
       "81301      Carole Garcia    1683676        5957932   9/3/2020     52249   \n",
       "81302  Elizabeth Herrera    3393152        1773937  12/9/2020     27938   \n",
       "81303       Robert Davis    8326057        8682785   7/1/2020     39759   \n",
       "\n",
       "                           Location                  Issue       D.O.I  \\\n",
       "0                      McKenzie, AL            Hit and Run  05/19/2021   \n",
       "1      Otis Orchards-East Farms, WA            Hit and Run  05/26/2021   \n",
       "2                     Fifty-Six, AR    Bike & Car Accident  12/03/2020   \n",
       "3                         Cidra, PR            Hit and Run  01/25/2021   \n",
       "4                    Vintondale, PA            Hit and Run  01/24/2021   \n",
       "...                             ...                    ...         ...   \n",
       "81299              East Prairie, MO             Auto Theft  11/10/2020   \n",
       "81300                 Snowflake, AZ    Single Car Accident  03/10/2021   \n",
       "81301                  Millport, AL  Multiple Car Accident  03/23/2021   \n",
       "81302                   Ozawkie, KS    Bike & Car Accident  05/13/2021   \n",
       "81303           Miramiguoa Park, MO  Multiple Car Accident  12/19/2020   \n",
       "\n",
       "            D.O.R  Amount  Asset  Claim Id  Age  \n",
       "0      06/22/2021    2578  20626   9776250   40  \n",
       "1      05/28/2021   12622   5169   3301936   54  \n",
       "2      06/03/2021   15577   5234   7280014   58  \n",
       "3      03/17/2021   19605  26827   5169910   55  \n",
       "4      02/14/2021   12961  49696   9167296   55  \n",
       "...           ...     ...    ...       ...  ...  \n",
       "81299  03/27/2021    9948  36522   4484900   39  \n",
       "81300  06/19/2021   12909  52060   9268155   32  \n",
       "81301  06/20/2021    3535  34720   8672841   17  \n",
       "81302  06/15/2021   15004  16123   4128732   53  \n",
       "81303  02/06/2021    7986   6348   6744426   39  \n",
       "\n",
       "[81304 rows x 13 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "X"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "Y = df.iloc[:,11]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        1\n",
       "1        0\n",
       "2        0\n",
       "3        0\n",
       "4        0\n",
       "        ..\n",
       "81299    0\n",
       "81300    0\n",
       "81301    0\n",
       "81302    0\n",
       "81303    0\n",
       "Name: Sybil Attack, Length: 81304, dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Y"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.preprocessing import LabelEncoder\n",
    "labelencoder_X = LabelEncoder()\n",
    "X = X.apply(LabelEncoder().fit_transform)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(56912, 13)\n",
      "(24392, 13)\n",
      "(56912,)\n",
      "(24392,)\n"
     ]
    }
   ],
   "source": [
    "from sklearn.model_selection import train_test_split\n",
    "from sklearn.ensemble import RandomForestClassifier\n",
    "X_train, X_test, Y_train, Y_test = train_test_split(X, Y, test_size=0.3, train_size=0.7, random_state = 42)\n",
    "print(X_train.shape)\n",
    "print(X_test.shape)\n",
    "print(Y_train.shape)\n",
    "print(Y_test.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([1, 0, 0, ..., 0, 0, 0])"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn.ensemble import RandomForestClassifier\n",
    "rfc = RandomForestClassifier(n_estimators = 100, criterion = \"entropy\")\n",
    "rfc.fit(X_train, Y_train) \n",
    "  \n",
    "#Predict the value for new, unseen data\n",
    "Y_pred = rfc.predict(X_test)\n",
    "Y_pred"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Accuracy is: 0.7922269596589046\n",
      "CPU times: user 480 ms, sys: 2.14 ms, total: 482 ms\n",
      "Wall time: 481 ms\n"
     ]
    }
   ],
   "source": [
    "%%time\n",
    "accuracy = rfc.score(X_test, Y_test)\n",
    "print(\"Accuracy is:\", accuracy)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[[19321   111]\n",
      " [ 4957     3]]\n",
      "              precision    recall  f1-score   support\n",
      "\n",
      "           0       0.80      0.99      0.88     19432\n",
      "           1       0.03      0.00      0.00      4960\n",
      "\n",
      "    accuracy                           0.79     24392\n",
      "   macro avg       0.41      0.50      0.44     24392\n",
      "weighted avg       0.64      0.79      0.70     24392\n",
      "\n",
      "CPU times: user 39.7 ms, sys: 2.22 ms, total: 41.9 ms\n",
      "Wall time: 40.3 ms\n"
     ]
    }
   ],
   "source": [
    "%%time\n",
    "from sklearn.metrics import classification_report, confusion_matrix\n",
    "print(confusion_matrix(Y_test,Y_pred))\n",
    "print(classification_report(Y_test,Y_pred))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CPU times: user 254 ms, sys: 60.7 ms, total: 315 ms\n",
      "Wall time: 1.35 s\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "Text(0, 0.5, 'Packets')"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYIAAAEGCAYAAABo25JHAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAAUG0lEQVR4nO3df7CeZX3n8ffHEwF/8EMl7SDBJrTUllaxeESwuy7FWhPswLbD7EDb1bp1Mkyh2x87qzid1jrd/cP+sI6KZjNKtdtW3LZsm2Wi6LaVzqxjTWiBEDAaAUkE5WBXEFwJge/+8dyHPJycJCdwrjzPnfv9mnnm3Pd138/1fHJyku+57h/XnapCkjRcz5p0AEnSZFkIJGngLASSNHAWAkkaOAuBJA3cikkHOFwnn3xyrV69etIxJKlXbrrppgeqauVi23pXCFavXs3WrVsnHUOSeiXJVw+0zUNDkjRwFgJJGjgLgSQNnIVAkgbOQiBJA9esECS5Jsn9SW47wPYkeV+SnUluTXJ2qyySpANrOSL4KLD2INvXAWd0r/XAhxpmkSQdQLP7CKrqH5KsPsguFwN/UqN5sD+f5KQkp1TVfS3yvOxjL3tyedtd97T4CElq67knw9u+suzdTvIcwanArrH13V3bfpKsT7I1yda5ubkjEk6Sps53HmjS7SQLQRZpW/QpOVW1sapmq2p25cpF75CWJD1NkywEu4HTxtZXAfdOKIskTb8TVjXpdpKFYBPwpu7qoXOBB1udH5Cko8IP/3STbpudLE7yceB84OQku4F3As8GqKoNwGbgQmAn8B3gLa2ySNJR4YWnN+m25VVDlx1iewFXtPp8STrqHHtCk269s1iS+uK4E5t0ayGQpL449vgm3VoIJKkvVhzXpFsLgST1xYpjmnRrIZCkvpixEEjSsFkIJGngLASSNHAWAkkaOE8WS9LAOSKQpIGbObZJtxYCSeqLZ8206bZJr5Kk5ZfFnuf1zFkIJGngLASSNHAWAkkaOAuBJA2chUCSBs5CIEkDZyGQpIGzEEjSwFkIJGngLASS1AeN5hkCC4Ek9cNxJzbr2kIgSX1w3AnNurYQSFIfOCKQpIGzEEjSwFkIJGngjvUcgSQN27HHN+vaQiBJfbDiuGZdNy0ESdYm2ZFkZ5KrFtl+YpL/leSWJNuTvKVlHknqrRU9vKEsyQxwNbAOOBO4LMmZC3a7Ari9qs4Czgf+MMkxrTJJUm/NPLtZ1y1HBOcAO6vqzqraA1wLXLxgnwKOTxLg+cC/AHsbZpKkfurpFBOnArvG1nd3beM+APwwcC+wDfjVqnpiYUdJ1ifZmmTr3Nxcq7ySNL16OiLIIm21YP0NwM3Ai4FXAB9Ist81UlW1sapmq2p25cqVy51TkqZfH88RMBoBnDa2vorRb/7j3gJcVyM7gbuAH2qYSZL6aabd6dOWhWALcEaSNd0J4EuBTQv2uQd4HUCS7wVeCtzZMJMk9VPDQrCiVcdVtTfJlcANwAxwTVVtT3J5t30D8LvAR5NsY3Qo6e1V9UCrTJLUW30sBABVtRnYvKBtw9jyvcBPtcwgSUeFnh4akiQtlxUWAkkaNkcEkjRwPb2hTJK0XHp6Q5kkabn09IYySdJycUQgSQPnyWJJGjhPFkvSwHloSJIGzpPFkjRwniOQpIF71ky7rpv1LEnqBQuBJA2chUCSBs5CIEkDZyGQpIGzEEjSwFkIJGngLASSNHAWAkmadmn7X7WFQJKmXcOZR8FCIEnTb0W7eYbAQiBJ088RgSQNXMMpqMFCIEnTr+EU1GAhkKTp54hAkgbOEYEkDZwjAkkauD6PCJKsTbIjyc4kVx1gn/OT3Jxke5IbW+aRpF5qPCJY0arjJDPA1cDrgd3AliSbqur2sX1OAj4IrK2qe5J8T6s8ktRbPb6P4BxgZ1XdWVV7gGuBixfs83PAdVV1D0BV3d8wjyT1U4/vLD4V2DW2vrtrG/eDwAuSfDbJTUnetFhHSdYn2Zpk69zcXKO4kjSlejwiyCJttWB9BfBK4I3AG4DfSvKD+72pamNVzVbV7MqVK5c/qSRNs8YjgmbnCBiNAE4bW18F3LvIPg9U1SPAI0n+ATgL+FLDXJLULz0eEWwBzkiyJskxwKXApgX7/A3wr5OsSPJc4NXAHQ0zSVL/TNtVQ0leAJxWVbcebL+q2pvkSuAGYAa4pqq2J7m8276hqu5I8ingVuAJ4MNVddth/ykk6WjW+D6CJRWCJJ8FLur2vxmYS3JjVf3Gwd5XVZuBzQvaNixY/33g95ceWZIGZkruLD6xqh4Cfhb446p6JfCT7WJJkp40JXcWr0hyCvDvgOsb5pEkLTQlI4J3MTrWv7OqtiQ5Hfhyu1iSpCdNwzkC4L6qevn8SlXdmeQ9jTJJksZNyYjg/UtskyQtt8b3ERx0RJDkPOA1wMok41cIncDoklBJUmsTvrP4GOD53X7Hj7U/BFzSKpQkacwkRwRVdSNwY5KPVtVXkzyvmw5CknSkTMnsoy9Ocjvd9A9JzkrywXaxJElPmpK5ht7LaHbQbwJU1S3AaxtlkiSNm5KrhqiqXQuaHl/mLJKkxUzJfQS7krwGqG4m0f+Is4RK0pExJSOCy4ErGD1hbDfwCuCXG2WSJI1LyycGLH1E8Kqq+vnxhm466Q0H2F+S1BNLLTO/leSC+ZUkb2P/B9FLkppY7Mm/y2epI4KLgOuT/GdgLfBDXZskqbVMQSGoqgeSXAT8b+Am4JKqWvggeklSDx1qrqFvA8VoXFKMppw4HbgkSVXVCe0jStLQTXBEUFXHH2y7JKn/lnSyOMnPJDlxbP2kJP+2WSpJ0j6NzxEs9aqhd1bVg/MrVfUt4J1NEkmSjqilFoLF9lvqFUeSpCm21EKwNcl7knx/ktOT/BGjq4ckST231ELwK8Ae4BPAXwDfZTTlhCSptSm5j+AR4KqmSSRJBzAFhSDJSuBtwI8Ax823V9UFB3yTJKkXlnpo6M+ALwJrgHcBdwNbGmWSJB1BSy0EL6qqjwCPVdWNVfUfgHMb5pIkPantjD5LvQT0se7rfUneCNwLrGoTSZL0FI2ndltqIfgv3Z3F/wl4P3AC8OvNUkmS9qknmnZ/qEnnjmP0dLIfYPR0so9U1U80TSRJeqrGI4JDnSP4GDALbAPWAX94OJ0nWZtkR5KdSQ54+WmSVyV5PMklh9O/JA3CJEcEwJlV9TKAJB8BvrDUjpPMAFcDr2f0nOMtSTZV1e2L7Pdu4IbDCS5Jg9G4EBxqRDB/kpiq2nuYfZ8D7KyqO6tqD3Atiz/e8leAvwLuP8z+JWkYJjwiOCvJQ91ygOd06wEO9WCaU4FdY+u7gVeP75DkVOBngAuAVx2ooyTrgfUAL3nJSw4RWZKOMpMsBFU18wz6Xuye6IVnPN4LvL2qHs9B5tKoqo3ARoDZ2VkfkSlpWCY8IngmdgOnja2vYnT/wbhZ4NquCJwMXJhkb1X9dcNcktQvPS4EW4AzkqwBvgZcCvzc+A5VtWZ+OclHgestApK0wJTcUHbYqmpvkisZXQ00A1xTVduTXN5t39DqsyXpqNLjEQFVtRnYvKBt0QJQVb/YMosk9daELx+VJE2ahUCSBs5CIElDN9m5hiRJk+aIQJIGzkIgSQNnIZCkgbMQSNLATfjBNJKkSXNEIEkDZyGQpIGzEEjSwFkIJGngLASSNHAWAkkaOAuBJA2c9xFI0sBZCCRp4Dw0JEkDZyGQpIGzEEjSwFkIJGngLASSNHAWAkkaOAuBJA2chUCSBu6x7zTt3kIgSdPuuw817d5CIEnT7tFvN+3eQiBJ0+5RRwSSNGx9HhEkWZtkR5KdSa5aZPvPJ7m1e30uyVkt80hSL333wabdNysESWaAq4F1wJnAZUnOXLDbXcC/qaqXA78LbGyVR5J6q6+FADgH2FlVd1bVHuBa4OLxHarqc1X1f7vVzwOrGuaRpH565IGm3bcsBKcCu8bWd3dtB/JLwCcX25BkfZKtSbbOzc0tY0RJ6oGHv9G0+5aFIIu0LfqYnSQ/wagQvH2x7VW1sapmq2p25cqVyxhRknqgHm/a/YqGfe8GThtbXwXcu3CnJC8HPgysq6pvNswjSVpEyxHBFuCMJGuSHANcCmwa3yHJS4DrgH9fVV9qmEWSdADNRgRVtTfJlcANwAxwTVVtT3J5t30D8NvAi4APJgHYW1WzrTJJkvbX8tAQVbUZ2LygbcPY8luBt7bMIEk6OO8slqSBsxBI0sBZCCRp4CwEkjRwFgJJGjgLgSQNnIVAkvpg755mXVsIJKkP9jzcrGsLgST1gYVAkgZuzyPNurYQSFIfPOqIQJKGbU+7B9hbCCSpDzw0JEkD56EhSRq4Rz00JEnD9u39nvS7bCwEktQH37qnWdcWAknqAwuBJA3ct3Y169pCIEl98PDXm3VtIZCkgbMQSNLAWQgkaeAsBJI0cBYCSRo4C4EkDZyFQJL64onHm3RrIZCkvmg0FbWFQJL64pG5Jt1aCCSpLx5sM82EhUCS+qLRxHNNC0GStUl2JNmZ5KpFtifJ+7rttyY5u2UeSeq1B77UpNtmhSDJDHA1sA44E7gsyZkLdlsHnNG91gMfapVHknrvc+9v0m3LEcE5wM6qurOq9gDXAhcv2Odi4E9q5PPASUlOaZhJkrRAy0JwKjB+ZmN313a4+5BkfZKtSbbOzbU5ay5JQ7WiYd9ZpK2exj5U1UZgI8Ds7Ox+25di25u3PZ23SdJRr+WIYDdw2tj6KmDh05eXso8kqaGWhWALcEaSNUmOAS4FNi3YZxPwpu7qoXOBB6vqvoaZJEkLNDs0VFV7k1wJ3ADMANdU1fYkl3fbNwCbgQuBncB3gLe0yiNJWlzLcwRU1WZG/9mPt20YWy7gipYZJEkH553FkjRwFgJJGjgLgSQNnIVAkgYuo/O1/ZFkDvjq03z7ycADyxhnuUxjrmnMBNOZaxozwXTmMtPSLXeu76uqlYtt6F0heCaSbK2q2UnnWGgac01jJpjOXNOYCaYzl5mW7kjm8tCQJA2chUCSBm5ohWDjpAMcwDTmmsZMMJ25pjETTGcuMy3dEcs1qHMEkqT9DW1EIElawEIgSQM3mEKQZG2SHUl2JrmqQf/XJLk/yW1jbS9M8pkkX+6+vmBs2zu6LDuSvGGs/ZVJtnXb3pckXfuxST7Rtf9jktVLyHRakr9PckeS7Ul+dUpyHZfkC0lu6XK9axpyde+bSfLPSa6fhkxJ7u76ujnJ1mnI1L3vpCR/meSL3c/XeZPMleSl3fdo/vVQkl+bku/Vr3c/57cl+XhGP/8Tz/UUVXXUvxhNg/0V4HTgGOAW4Mxl/ozXAmcDt421/R5wVbd8FfDubvnMLsOxwJou20y37QvAeYye3vZJYF3X/svAhm75UuATS8h0CnB2t3w88KXusyedK8Dzu+VnA/8InDvpXN2+vwH8OXD9lPwd3g2cvKBtGr5PHwPe2i0fA5w0DbnG/r1/Hfi+SWdi9Ojdu4DndOv/A/jFSefaL+fhvqGPr+6bd8PY+juAdzT4nNU8tRDsAE7plk8Bdiz2+Yye2XBet88Xx9ovA/7b+D7d8gpGdxzmMPP9DfD6acoFPBf4J+DVk87F6Al5fwtcwL5CMOlMd7N/IZh0phMY/eeWaco11s9PAf9nGjKx77nsL+zec32Xbyq+V/OvoRwamv/LmLe7a2vte6t74lr39XsOkefUbnmxnE++p6r2Ag8CL1pqkG64+GOMfvueeK7uEMzNwP3AZ6pqGnK9F3gb8MRY26QzFfDpJDclWT8lmU4H5oA/7g6jfTjJ86Yg17xLgY93yxPNVFVfA/4AuAe4j9FTGD896VwLDaUQZJG2SV43e6A8B8v5tP8MSZ4P/BXwa1X10DTkqqrHq+oVjH4LPyfJj04yV5KfBu6vqpsOkuOIZur8eFWdDawDrkjy2inItILRYdAPVdWPAY8wOrwx6Vxk9Fjci4C/ONSuRyJTd+z/YkaHeV4MPC/JL0w610JDKQS7gdPG1lcB9x6Bz/1GklMAuq/3HyLP7m55sZxPvifJCuBE4F8OFSDJsxkVgT+rquumJde8qvoW8Flg7YRz/ThwUZK7gWuBC5L86YQzUVX3dl/vB/4ncM6kM3Xv2d2N4gD+klFhmHQuGBXMf6qqb3Trk870k8BdVTVXVY8B1wGvmYJcTzGUQrAFOCPJmu43hkuBTUfgczcBb+6W38zoGP18+6Xd2f41wBnAF7oh4reTnNtdEfCmBe+Z7+sS4O+qOyh4IF0fHwHuqKr3TFGulUlO6pafw+gfyxcnmauq3lFVq6pqNaOfj7+rql+YZKYkz0ty/Pwyo2PLt00yU/e9+jqwK8lLu6bXAbdPOlfnMvYdFlrYzyQy3QOcm+S5XX+vA+6YglxPdTgnFPr8Ai5kdNXMV4DfbND/xxkdA3yMUYX+JUbH6f4W+HL39YVj+/9ml2UH3dn/rn2W0T/2rwAfYN/d38cxGu7uZHT1wOlLyPSvGA0RbwVu7l4XTkGulwP/3OW6Dfjtrn2iucb6PJ99J4snlonRsfhbutf2+Z/bafg+Aa8AtnZ/h38NvGDSuRhdePBN4MSxtmn4Xr2L0S86twH/ndEVQRPPNf5yiglJGrihHBqSJB2AhUCSBs5CIEkDZyGQpIGzEEjSwFkIpANI8qLsm83y60m+1i0/nOSDk84nLRcvH5WWIMnvAA9X1R9MOou03BwRSIcpyfnZ97yC30nysSSfzujZAT+b5Pe6eeM/1U3xMT+X/I3d5HE3zE8vIE0DC4H0zH0/8EZGk4v9KfD3VfUy4P8Bb+yKwfuBS6rqlcA1wH+dVFhpoRWTDiAdBT5ZVY8l2cbooSif6tq3MXpGxUuBHwU+M5omhhlG05FIU8FCID1zjwJU1RNJHqt9J96eYPRvLMD2qjpvUgGlg/HQkNTeDmBlkvNgNDV4kh+ZcCbpSRYCqbGq2sNoeuB3J7mF0Sywr5loKGmMl49K0sA5IpCkgbMQSNLAWQgkaeAsBJI0cBYCSRo4C4EkDZyFQJIG7v8Du9t6DKD2nmwAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "%%time\n",
    "import matplotlib.pyplot as plt\n",
    "# for plotting the graph inside the notebook itself\n",
    "%matplotlib inline\n",
    "\n",
    "plt.plot(X, Y)\n",
    "plt.xlabel('Time')\n",
    "plt.ylabel('Packets')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[[19321   111]\n",
      " [ 4957     3]]\n",
      "              precision    recall  f1-score   support\n",
      "\n",
      "           0       0.80      0.99      0.88     19432\n",
      "           1       0.03      0.00      0.00      4960\n",
      "\n",
      "    accuracy                           0.79     24392\n",
      "   macro avg       0.41      0.50      0.44     24392\n",
      "weighted avg       0.64      0.79      0.70     24392\n",
      "\n",
      "CPU times: user 46 ms, sys: 2.52 ms, total: 48.6 ms\n",
      "Wall time: 47.1 ms\n"
     ]
    }
   ],
   "source": [
    "%%time\n",
    "from sklearn.metrics import classification_report, confusion_matrix\n",
    "print(confusion_matrix(Y_test,Y_pred))\n",
    "print(classification_report(Y_test,Y_pred))"
   ]
  },
  {
   "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}