Ethereum_Fraud_Detection_Model.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 295,
   "id": "5a0c6771",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import plotly.express as px\n",
    "from sklearn.impute import SimpleImputer\n",
    "from sklearn.model_selection import train_test_split \n",
    "from sklearn.tree import DecisionTreeClassifier\n",
    "from sklearn.linear_model import LogisticRegression as lg\n",
    "from sklearn.ensemble import RandomForestClassifier as rdc\n",
    "from sklearn.tree import plot_tree as plt\n",
    "from sklearn import metrics\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "88aa385a",
   "metadata": {},
   "source": [
    "# Importing the Dataset \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 296,
   "id": "360a3dc4",
   "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>Unnamed: 0</th>\n",
       "      <th>Index</th>\n",
       "      <th>Address</th>\n",
       "      <th>FLAG</th>\n",
       "      <th>Avg min between sent tnx</th>\n",
       "      <th>Avg min between received tnx</th>\n",
       "      <th>Time Diff between first and last (Mins)</th>\n",
       "      <th>Sent tnx</th>\n",
       "      <th>Received Tnx</th>\n",
       "      <th>Number of Created Contracts</th>\n",
       "      <th>...</th>\n",
       "      <th>ERC20 min val sent</th>\n",
       "      <th>ERC20 max val sent</th>\n",
       "      <th>ERC20 avg val sent</th>\n",
       "      <th>ERC20 min val sent contract</th>\n",
       "      <th>ERC20 max val sent contract</th>\n",
       "      <th>ERC20 avg val sent contract</th>\n",
       "      <th>ERC20 uniq sent token name</th>\n",
       "      <th>ERC20 uniq rec token name</th>\n",
       "      <th>ERC20 most sent token type</th>\n",
       "      <th>ERC20_most_rec_token_type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0x00009277775ac7d0d59eaad8fee3d10ac6c805e8</td>\n",
       "      <td>0</td>\n",
       "      <td>844.26</td>\n",
       "      <td>1093.71</td>\n",
       "      <td>704785.63</td>\n",
       "      <td>721</td>\n",
       "      <td>89</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.683100e+07</td>\n",
       "      <td>271779.920000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>Cofoundit</td>\n",
       "      <td>Numeraire</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0x0002b44ddb1476db43c868bd494422ee4c136fed</td>\n",
       "      <td>0</td>\n",
       "      <td>12709.07</td>\n",
       "      <td>2958.44</td>\n",
       "      <td>1218216.73</td>\n",
       "      <td>94</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2.260809</td>\n",
       "      <td>2.260809e+00</td>\n",
       "      <td>2.260809</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Livepeer Token</td>\n",
       "      <td>Livepeer Token</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>0x0002bda54cb772d040f779e88eb453cac0daa244</td>\n",
       "      <td>0</td>\n",
       "      <td>246194.54</td>\n",
       "      <td>2434.02</td>\n",
       "      <td>516729.30</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>None</td>\n",
       "      <td>XENON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>0x00038e6ba2fd5c09aedb96697c8d7b8fa6632e5e</td>\n",
       "      <td>0</td>\n",
       "      <td>10219.60</td>\n",
       "      <td>15785.09</td>\n",
       "      <td>397555.90</td>\n",
       "      <td>25</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>9.029231e+03</td>\n",
       "      <td>3804.076893</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Raiden</td>\n",
       "      <td>XENON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>0x00062d1dd1afb6fb02540ddad9cdebfe568e0d89</td>\n",
       "      <td>0</td>\n",
       "      <td>36.61</td>\n",
       "      <td>10707.77</td>\n",
       "      <td>382472.42</td>\n",
       "      <td>4598</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>4.500000e+04</td>\n",
       "      <td>13726.659220</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>StatusNetwork</td>\n",
       "      <td>EOS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>0x000895ad78f4403ecd9468900e68d6ee506136fd</td>\n",
       "      <td>0</td>\n",
       "      <td>9900.12</td>\n",
       "      <td>375.48</td>\n",
       "      <td>20926.68</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>0x000d63fc5df52b0204374c2f5a3249779805d5d1</td>\n",
       "      <td>0</td>\n",
       "      <td>69.46</td>\n",
       "      <td>629.44</td>\n",
       "      <td>8660.35</td>\n",
       "      <td>25</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>0x000e001ab444fa8d6dc4a402f8d7cfc88fe8c64d</td>\n",
       "      <td>0</td>\n",
       "      <td>1497.39</td>\n",
       "      <td>176.84</td>\n",
       "      <td>319828.05</td>\n",
       "      <td>213</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>None</td>\n",
       "      <td>XENON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>0x0012cb699c836049a4bbeaac2d8c4d47c688e0e4</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>496.62</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>0x0012f247c9f980eea0a9ad06893bfd95c3145794</td>\n",
       "      <td>0</td>\n",
       "      <td>2570.59</td>\n",
       "      <td>3336.01</td>\n",
       "      <td>30572.70</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>None</td>\n",
       "      <td>AICRYPTO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 51 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  Index                                     Address  FLAG  \\\n",
       "0           0      1  0x00009277775ac7d0d59eaad8fee3d10ac6c805e8     0   \n",
       "1           1      2  0x0002b44ddb1476db43c868bd494422ee4c136fed     0   \n",
       "2           2      3  0x0002bda54cb772d040f779e88eb453cac0daa244     0   \n",
       "3           3      4  0x00038e6ba2fd5c09aedb96697c8d7b8fa6632e5e     0   \n",
       "4           4      5  0x00062d1dd1afb6fb02540ddad9cdebfe568e0d89     0   \n",
       "5           5      6  0x000895ad78f4403ecd9468900e68d6ee506136fd     0   \n",
       "6           6      7  0x000d63fc5df52b0204374c2f5a3249779805d5d1     0   \n",
       "7           7      8  0x000e001ab444fa8d6dc4a402f8d7cfc88fe8c64d     0   \n",
       "8           8      9  0x0012cb699c836049a4bbeaac2d8c4d47c688e0e4     0   \n",
       "9           9     10  0x0012f247c9f980eea0a9ad06893bfd95c3145794     0   \n",
       "\n",
       "   Avg min between sent tnx  Avg min between received tnx  \\\n",
       "0                    844.26                       1093.71   \n",
       "1                  12709.07                       2958.44   \n",
       "2                 246194.54                       2434.02   \n",
       "3                  10219.60                      15785.09   \n",
       "4                     36.61                      10707.77   \n",
       "5                   9900.12                        375.48   \n",
       "6                     69.46                        629.44   \n",
       "7                   1497.39                        176.84   \n",
       "8                      0.00                          0.00   \n",
       "9                   2570.59                       3336.01   \n",
       "\n",
       "   Time Diff between first and last (Mins)  Sent tnx  Received Tnx  \\\n",
       "0                                704785.63       721            89   \n",
       "1                               1218216.73        94             8   \n",
       "2                                516729.30         2            10   \n",
       "3                                397555.90        25             9   \n",
       "4                                382472.42      4598            20   \n",
       "5                                 20926.68         2             3   \n",
       "6                                  8660.35        25            11   \n",
       "7                                319828.05       213             5   \n",
       "8                                   496.62         1             1   \n",
       "9                                 30572.70         8             3   \n",
       "\n",
       "   Number of Created Contracts  ...   ERC20 min val sent   ERC20 max val sent  \\\n",
       "0                            0  ...             0.000000         1.683100e+07   \n",
       "1                            0  ...             2.260809         2.260809e+00   \n",
       "2                            0  ...             0.000000         0.000000e+00   \n",
       "3                            0  ...           100.000000         9.029231e+03   \n",
       "4                            1  ...             0.000000         4.500000e+04   \n",
       "5                            0  ...             0.000000         0.000000e+00   \n",
       "6                            0  ...             0.000000         0.000000e+00   \n",
       "7                            0  ...             0.000000         0.000000e+00   \n",
       "8                            0  ...             0.000000         0.000000e+00   \n",
       "9                            0  ...             0.000000         0.000000e+00   \n",
       "\n",
       "    ERC20 avg val sent   ERC20 min val sent contract  \\\n",
       "0        271779.920000                           0.0   \n",
       "1             2.260809                           0.0   \n",
       "2             0.000000                           0.0   \n",
       "3          3804.076893                           0.0   \n",
       "4         13726.659220                           0.0   \n",
       "5             0.000000                           0.0   \n",
       "6             0.000000                           0.0   \n",
       "7             0.000000                           0.0   \n",
       "8             0.000000                           0.0   \n",
       "9             0.000000                           0.0   \n",
       "\n",
       "    ERC20 max val sent contract   ERC20 avg val sent contract  \\\n",
       "0                           0.0                           0.0   \n",
       "1                           0.0                           0.0   \n",
       "2                           0.0                           0.0   \n",
       "3                           0.0                           0.0   \n",
       "4                           0.0                           0.0   \n",
       "5                           0.0                           0.0   \n",
       "6                           0.0                           0.0   \n",
       "7                           0.0                           0.0   \n",
       "8                           0.0                           0.0   \n",
       "9                           0.0                           0.0   \n",
       "\n",
       "    ERC20 uniq sent token name   ERC20 uniq rec token name  \\\n",
       "0                         39.0                        57.0   \n",
       "1                          1.0                         7.0   \n",
       "2                          0.0                         8.0   \n",
       "3                          1.0                        11.0   \n",
       "4                          6.0                        27.0   \n",
       "5                          0.0                         0.0   \n",
       "6                          0.0                         0.0   \n",
       "7                          0.0                         7.0   \n",
       "8                          0.0                         0.0   \n",
       "9                          0.0                         1.0   \n",
       "\n",
       "    ERC20 most sent token type   ERC20_most_rec_token_type  \n",
       "0                    Cofoundit                   Numeraire  \n",
       "1               Livepeer Token              Livepeer Token  \n",
       "2                         None                       XENON  \n",
       "3                       Raiden                       XENON  \n",
       "4                StatusNetwork                         EOS  \n",
       "5                            0                           0  \n",
       "6                            0                           0  \n",
       "7                         None                       XENON  \n",
       "8                            0                           0  \n",
       "9                         None                    AICRYPTO  \n",
       "\n",
       "[10 rows x 51 columns]"
      ]
     },
     "execution_count": 296,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('transaction_dataset.csv')\n",
    "df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 297,
   "id": "723568be",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.replace(['NO DATA','NaN',''],np.nan)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 298,
   "id": "1351db13",
   "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>Unnamed: 0</th>\n",
       "      <th>Index</th>\n",
       "      <th>Address</th>\n",
       "      <th>FLAG</th>\n",
       "      <th>Avg min between sent tnx</th>\n",
       "      <th>Avg min between received tnx</th>\n",
       "      <th>Time Diff between first and last (Mins)</th>\n",
       "      <th>Sent tnx</th>\n",
       "      <th>Received Tnx</th>\n",
       "      <th>Number of Created Contracts</th>\n",
       "      <th>...</th>\n",
       "      <th>ERC20 min val sent</th>\n",
       "      <th>ERC20 max val sent</th>\n",
       "      <th>ERC20 avg val sent</th>\n",
       "      <th>ERC20 min val sent contract</th>\n",
       "      <th>ERC20 max val sent contract</th>\n",
       "      <th>ERC20 avg val sent contract</th>\n",
       "      <th>ERC20 uniq sent token name</th>\n",
       "      <th>ERC20 uniq rec token name</th>\n",
       "      <th>ERC20 most sent token type</th>\n",
       "      <th>ERC20_most_rec_token_type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9836</th>\n",
       "      <td>9836</td>\n",
       "      <td>2175</td>\n",
       "      <td>0xff481ca14e6c16b79fc8ab299b4d2387ec8ecdd2</td>\n",
       "      <td>1</td>\n",
       "      <td>12635.10</td>\n",
       "      <td>631.39</td>\n",
       "      <td>58748.48</td>\n",
       "      <td>4</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td></td>\n",
       "      <td>GSENetwork</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9837</th>\n",
       "      <td>9837</td>\n",
       "      <td>2176</td>\n",
       "      <td>0xff718805bb9199ebf024ab6acd333e603ad77c85</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td></td>\n",
       "      <td>Blockwell say NOTSAFU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9838</th>\n",
       "      <td>9838</td>\n",
       "      <td>2177</td>\n",
       "      <td>0xff8e6af02d41a576a0c82f7835535193e1a6bccc</td>\n",
       "      <td>1</td>\n",
       "      <td>2499.44</td>\n",
       "      <td>2189.29</td>\n",
       "      <td>261601.88</td>\n",
       "      <td>67</td>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td></td>\n",
       "      <td>Free BOB Tokens - BobsRepair.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9839</th>\n",
       "      <td>9839</td>\n",
       "      <td>2178</td>\n",
       "      <td>0xffde23396d57e10abf58bd929bb1e856c7718218</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9840</th>\n",
       "      <td>9840</td>\n",
       "      <td>2179</td>\n",
       "      <td>0xd624d046edbdef805c5e4140dce5fb5ec1b39a3c</td>\n",
       "      <td>1</td>\n",
       "      <td>37242.70</td>\n",
       "      <td>149.56</td>\n",
       "      <td>670817.33</td>\n",
       "      <td>18</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td></td>\n",
       "      <td>INS Promo1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 51 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0  Index                                     Address  FLAG  \\\n",
       "9836        9836   2175  0xff481ca14e6c16b79fc8ab299b4d2387ec8ecdd2     1   \n",
       "9837        9837   2176  0xff718805bb9199ebf024ab6acd333e603ad77c85     1   \n",
       "9838        9838   2177  0xff8e6af02d41a576a0c82f7835535193e1a6bccc     1   \n",
       "9839        9839   2178  0xffde23396d57e10abf58bd929bb1e856c7718218     1   \n",
       "9840        9840   2179  0xd624d046edbdef805c5e4140dce5fb5ec1b39a3c     1   \n",
       "\n",
       "      Avg min between sent tnx  Avg min between received tnx  \\\n",
       "9836                  12635.10                        631.39   \n",
       "9837                      0.00                          0.00   \n",
       "9838                   2499.44                       2189.29   \n",
       "9839                      0.00                          0.00   \n",
       "9840                  37242.70                        149.56   \n",
       "\n",
       "      Time Diff between first and last (Mins)  Sent tnx  Received Tnx  \\\n",
       "9836                                 58748.48         4            13   \n",
       "9837                                     0.00         0             0   \n",
       "9838                                261601.88        67            43   \n",
       "9839                                     0.00         0             1   \n",
       "9840                                670817.33        18             3   \n",
       "\n",
       "      Number of Created Contracts  ...   ERC20 min val sent  \\\n",
       "9836                            0  ...                  0.0   \n",
       "9837                            0  ...                  0.0   \n",
       "9838                            0  ...                  0.0   \n",
       "9839                            0  ...                  NaN   \n",
       "9840                            0  ...                  0.0   \n",
       "\n",
       "       ERC20 max val sent   ERC20 avg val sent   ERC20 min val sent contract  \\\n",
       "9836                  0.0                  0.0                           0.0   \n",
       "9837                  0.0                  0.0                           0.0   \n",
       "9838                  0.0                  0.0                           0.0   \n",
       "9839                  NaN                  NaN                           NaN   \n",
       "9840                  0.0                  0.0                           0.0   \n",
       "\n",
       "       ERC20 max val sent contract   ERC20 avg val sent contract  \\\n",
       "9836                           0.0                           0.0   \n",
       "9837                           0.0                           0.0   \n",
       "9838                           0.0                           0.0   \n",
       "9839                           NaN                           NaN   \n",
       "9840                           0.0                           0.0   \n",
       "\n",
       "       ERC20 uniq sent token name   ERC20 uniq rec token name  \\\n",
       "9836                          0.0                         2.0   \n",
       "9837                          0.0                         1.0   \n",
       "9838                          0.0                         5.0   \n",
       "9839                          NaN                         NaN   \n",
       "9840                          0.0                        42.0   \n",
       "\n",
       "       ERC20 most sent token type         ERC20_most_rec_token_type  \n",
       "9836                                                     GSENetwork  \n",
       "9837                                          Blockwell say NOTSAFU  \n",
       "9838                               Free BOB Tokens - BobsRepair.com  \n",
       "9839                          NaN                               NaN  \n",
       "9840                                                     INS Promo1  \n",
       "\n",
       "[5 rows x 51 columns]"
      ]
     },
     "execution_count": 298,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "52736cc9",
   "metadata": {},
   "source": [
    "## Understanding the Dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 299,
   "id": "0572331f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Unnamed: 0', 'Index', 'Address', 'FLAG', 'Avg min between sent tnx',\n",
       "       'Avg min between received tnx',\n",
       "       'Time Diff between first and last (Mins)', 'Sent tnx', 'Received Tnx',\n",
       "       'Number of Created Contracts', 'Unique Received From Addresses',\n",
       "       'Unique Sent To Addresses', 'min value received', 'max value received ',\n",
       "       'avg val received', 'min val sent', 'max val sent', 'avg val sent',\n",
       "       'min value sent to contract', 'max val sent to contract',\n",
       "       'avg value sent to contract',\n",
       "       'total transactions (including tnx to create contract',\n",
       "       'total Ether sent', 'total ether received',\n",
       "       'total ether sent contracts', 'total ether balance',\n",
       "       ' Total ERC20 tnxs', ' ERC20 total Ether received',\n",
       "       ' ERC20 total ether sent', ' ERC20 total Ether sent contract',\n",
       "       ' ERC20 uniq sent addr', ' ERC20 uniq rec addr',\n",
       "       ' ERC20 uniq sent addr.1', ' ERC20 uniq rec contract addr',\n",
       "       ' ERC20 avg time between sent tnx', ' ERC20 avg time between rec tnx',\n",
       "       ' ERC20 avg time between rec 2 tnx',\n",
       "       ' ERC20 avg time between contract tnx', ' ERC20 min val rec',\n",
       "       ' ERC20 max val rec', ' ERC20 avg val rec', ' ERC20 min val sent',\n",
       "       ' ERC20 max val sent', ' ERC20 avg val sent',\n",
       "       ' ERC20 min val sent contract', ' ERC20 max val sent contract',\n",
       "       ' ERC20 avg val sent contract', ' ERC20 uniq sent token name',\n",
       "       ' ERC20 uniq rec token name', ' ERC20 most sent token type',\n",
       "       ' ERC20_most_rec_token_type'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 299,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 300,
   "id": "d5a216e7",
   "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>Unnamed: 0</th>\n",
       "      <th>Index</th>\n",
       "      <th>FLAG</th>\n",
       "      <th>Avg min between sent tnx</th>\n",
       "      <th>Avg min between received tnx</th>\n",
       "      <th>Time Diff between first and last (Mins)</th>\n",
       "      <th>Sent tnx</th>\n",
       "      <th>Received Tnx</th>\n",
       "      <th>Number of Created Contracts</th>\n",
       "      <th>Unique Received From Addresses</th>\n",
       "      <th>...</th>\n",
       "      <th>ERC20 max val rec</th>\n",
       "      <th>ERC20 avg val rec</th>\n",
       "      <th>ERC20 min val sent</th>\n",
       "      <th>ERC20 max val sent</th>\n",
       "      <th>ERC20 avg val sent</th>\n",
       "      <th>ERC20 min val sent contract</th>\n",
       "      <th>ERC20 max val sent contract</th>\n",
       "      <th>ERC20 avg val sent contract</th>\n",
       "      <th>ERC20 uniq sent token name</th>\n",
       "      <th>ERC20 uniq rec token name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>9841.000000</td>\n",
       "      <td>9841.000000</td>\n",
       "      <td>9841.000000</td>\n",
       "      <td>9841.000000</td>\n",
       "      <td>9841.000000</td>\n",
       "      <td>9.841000e+03</td>\n",
       "      <td>9841.000000</td>\n",
       "      <td>9841.000000</td>\n",
       "      <td>9841.000000</td>\n",
       "      <td>9841.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>9.012000e+03</td>\n",
       "      <td>9.012000e+03</td>\n",
       "      <td>9.012000e+03</td>\n",
       "      <td>9.012000e+03</td>\n",
       "      <td>9.012000e+03</td>\n",
       "      <td>9012.0</td>\n",
       "      <td>9012.0</td>\n",
       "      <td>9012.0</td>\n",
       "      <td>9012.000000</td>\n",
       "      <td>9012.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>4920.000000</td>\n",
       "      <td>1815.049893</td>\n",
       "      <td>0.221421</td>\n",
       "      <td>5086.878721</td>\n",
       "      <td>8004.851184</td>\n",
       "      <td>2.183333e+05</td>\n",
       "      <td>115.931714</td>\n",
       "      <td>163.700945</td>\n",
       "      <td>3.729702</td>\n",
       "      <td>30.360939</td>\n",
       "      <td>...</td>\n",
       "      <td>1.252524e+08</td>\n",
       "      <td>4.346203e+06</td>\n",
       "      <td>1.174126e+04</td>\n",
       "      <td>1.303594e+07</td>\n",
       "      <td>6.318389e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.384931</td>\n",
       "      <td>4.826676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>2840.996333</td>\n",
       "      <td>1222.621830</td>\n",
       "      <td>0.415224</td>\n",
       "      <td>21486.549974</td>\n",
       "      <td>23081.714801</td>\n",
       "      <td>3.229379e+05</td>\n",
       "      <td>757.226361</td>\n",
       "      <td>940.836550</td>\n",
       "      <td>141.445583</td>\n",
       "      <td>298.621112</td>\n",
       "      <td>...</td>\n",
       "      <td>1.053741e+10</td>\n",
       "      <td>2.141192e+08</td>\n",
       "      <td>1.053567e+06</td>\n",
       "      <td>1.179905e+09</td>\n",
       "      <td>5.914764e+08</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.735121</td>\n",
       "      <td>16.678607</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2460.000000</td>\n",
       "      <td>821.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>3.169300e+02</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>4920.000000</td>\n",
       "      <td>1641.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>17.340000</td>\n",
       "      <td>509.770000</td>\n",
       "      <td>4.663703e+04</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>7380.000000</td>\n",
       "      <td>2601.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>565.470000</td>\n",
       "      <td>5480.390000</td>\n",
       "      <td>3.040710e+05</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>27.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>9.900000e+01</td>\n",
       "      <td>2.946467e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>9840.000000</td>\n",
       "      <td>4729.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>430287.670000</td>\n",
       "      <td>482175.490000</td>\n",
       "      <td>1.954861e+06</td>\n",
       "      <td>10000.000000</td>\n",
       "      <td>10000.000000</td>\n",
       "      <td>9995.000000</td>\n",
       "      <td>9999.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.000000e+12</td>\n",
       "      <td>1.724181e+10</td>\n",
       "      <td>1.000000e+08</td>\n",
       "      <td>1.120000e+11</td>\n",
       "      <td>5.614756e+10</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>213.000000</td>\n",
       "      <td>737.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 48 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Unnamed: 0        Index         FLAG  Avg min between sent tnx  \\\n",
       "count  9841.000000  9841.000000  9841.000000               9841.000000   \n",
       "mean   4920.000000  1815.049893     0.221421               5086.878721   \n",
       "std    2840.996333  1222.621830     0.415224              21486.549974   \n",
       "min       0.000000     1.000000     0.000000                  0.000000   \n",
       "25%    2460.000000   821.000000     0.000000                  0.000000   \n",
       "50%    4920.000000  1641.000000     0.000000                 17.340000   \n",
       "75%    7380.000000  2601.000000     0.000000                565.470000   \n",
       "max    9840.000000  4729.000000     1.000000             430287.670000   \n",
       "\n",
       "       Avg min between received tnx  Time Diff between first and last (Mins)  \\\n",
       "count                   9841.000000                             9.841000e+03   \n",
       "mean                    8004.851184                             2.183333e+05   \n",
       "std                    23081.714801                             3.229379e+05   \n",
       "min                        0.000000                             0.000000e+00   \n",
       "25%                        0.000000                             3.169300e+02   \n",
       "50%                      509.770000                             4.663703e+04   \n",
       "75%                     5480.390000                             3.040710e+05   \n",
       "max                   482175.490000                             1.954861e+06   \n",
       "\n",
       "           Sent tnx  Received Tnx  Number of Created Contracts  \\\n",
       "count   9841.000000   9841.000000                  9841.000000   \n",
       "mean     115.931714    163.700945                     3.729702   \n",
       "std      757.226361    940.836550                   141.445583   \n",
       "min        0.000000      0.000000                     0.000000   \n",
       "25%        1.000000      1.000000                     0.000000   \n",
       "50%        3.000000      4.000000                     0.000000   \n",
       "75%       11.000000     27.000000                     0.000000   \n",
       "max    10000.000000  10000.000000                  9995.000000   \n",
       "\n",
       "       Unique Received From Addresses  ...   ERC20 max val rec  \\\n",
       "count                     9841.000000  ...        9.012000e+03   \n",
       "mean                        30.360939  ...        1.252524e+08   \n",
       "std                        298.621112  ...        1.053741e+10   \n",
       "min                          0.000000  ...        0.000000e+00   \n",
       "25%                          1.000000  ...        0.000000e+00   \n",
       "50%                          2.000000  ...        0.000000e+00   \n",
       "75%                          5.000000  ...        9.900000e+01   \n",
       "max                       9999.000000  ...        1.000000e+12   \n",
       "\n",
       "        ERC20 avg val rec   ERC20 min val sent   ERC20 max val sent  \\\n",
       "count        9.012000e+03         9.012000e+03         9.012000e+03   \n",
       "mean         4.346203e+06         1.174126e+04         1.303594e+07   \n",
       "std          2.141192e+08         1.053567e+06         1.179905e+09   \n",
       "min          0.000000e+00         0.000000e+00         0.000000e+00   \n",
       "25%          0.000000e+00         0.000000e+00         0.000000e+00   \n",
       "50%          0.000000e+00         0.000000e+00         0.000000e+00   \n",
       "75%          2.946467e+01         0.000000e+00         0.000000e+00   \n",
       "max          1.724181e+10         1.000000e+08         1.120000e+11   \n",
       "\n",
       "        ERC20 avg val sent   ERC20 min val sent contract  \\\n",
       "count         9.012000e+03                        9012.0   \n",
       "mean          6.318389e+06                           0.0   \n",
       "std           5.914764e+08                           0.0   \n",
       "min           0.000000e+00                           0.0   \n",
       "25%           0.000000e+00                           0.0   \n",
       "50%           0.000000e+00                           0.0   \n",
       "75%           0.000000e+00                           0.0   \n",
       "max           5.614756e+10                           0.0   \n",
       "\n",
       "        ERC20 max val sent contract   ERC20 avg val sent contract  \\\n",
       "count                        9012.0                        9012.0   \n",
       "mean                            0.0                           0.0   \n",
       "std                             0.0                           0.0   \n",
       "min                             0.0                           0.0   \n",
       "25%                             0.0                           0.0   \n",
       "50%                             0.0                           0.0   \n",
       "75%                             0.0                           0.0   \n",
       "max                             0.0                           0.0   \n",
       "\n",
       "        ERC20 uniq sent token name   ERC20 uniq rec token name  \n",
       "count                  9012.000000                 9012.000000  \n",
       "mean                      1.384931                    4.826676  \n",
       "std                       6.735121                   16.678607  \n",
       "min                       0.000000                    0.000000  \n",
       "25%                       0.000000                    0.000000  \n",
       "50%                       0.000000                    1.000000  \n",
       "75%                       0.000000                    2.000000  \n",
       "max                     213.000000                  737.000000  \n",
       "\n",
       "[8 rows x 48 columns]"
      ]
     },
     "execution_count": 300,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b3627038",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "0c00014d",
   "metadata": {},
   "source": [
    "### Checking missing value percentage in dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 301,
   "id": "53cd5391",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       " ERC20_most_rec_token_type                              8.647495\n",
       " ERC20 most sent token type                             8.545879\n",
       " ERC20 min val rec                                      8.423941\n",
       " ERC20 total ether sent                                 8.423941\n",
       " ERC20 total Ether sent contract                        8.423941\n",
       " ERC20 uniq sent addr                                   8.423941\n",
       " ERC20 uniq rec addr                                    8.423941\n",
       " ERC20 uniq sent addr.1                                 8.423941\n",
       " ERC20 uniq rec contract addr                           8.423941\n",
       " ERC20 avg time between sent tnx                        8.423941\n",
       " ERC20 avg time between rec tnx                         8.423941\n",
       " ERC20 avg time between rec 2 tnx                       8.423941\n",
       " ERC20 avg time between contract tnx                    8.423941\n",
       " ERC20 max val rec                                      8.423941\n",
       " Total ERC20 tnxs                                       8.423941\n",
       " ERC20 avg val rec                                      8.423941\n",
       " ERC20 min val sent                                     8.423941\n",
       " ERC20 max val sent                                     8.423941\n",
       " ERC20 avg val sent                                     8.423941\n",
       " ERC20 min val sent contract                            8.423941\n",
       " ERC20 max val sent contract                            8.423941\n",
       " ERC20 avg val sent contract                            8.423941\n",
       " ERC20 uniq sent token name                             8.423941\n",
       " ERC20 uniq rec token name                              8.423941\n",
       " ERC20 total Ether received                             8.423941\n",
       "Unnamed: 0                                              0.000000\n",
       "Index                                                   0.000000\n",
       "min value received                                      0.000000\n",
       "Address                                                 0.000000\n",
       "FLAG                                                    0.000000\n",
       "Avg min between sent tnx                                0.000000\n",
       "Avg min between received tnx                            0.000000\n",
       "Time Diff between first and last (Mins)                 0.000000\n",
       "Sent tnx                                                0.000000\n",
       "Received Tnx                                            0.000000\n",
       "Number of Created Contracts                             0.000000\n",
       "Unique Received From Addresses                          0.000000\n",
       "Unique Sent To Addresses                                0.000000\n",
       "max value received                                      0.000000\n",
       "total ether sent contracts                              0.000000\n",
       "avg val received                                        0.000000\n",
       "min val sent                                            0.000000\n",
       "max val sent                                            0.000000\n",
       "avg val sent                                            0.000000\n",
       "min value sent to contract                              0.000000\n",
       "max val sent to contract                                0.000000\n",
       "avg value sent to contract                              0.000000\n",
       "total transactions (including tnx to create contract    0.000000\n",
       "total Ether sent                                        0.000000\n",
       "total ether received                                    0.000000\n",
       "total ether balance                                     0.000000\n",
       "dtype: float64"
      ]
     },
     "execution_count": 301,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "percent_missing = df.isnull().sum() * 100 / len(df)\n",
    "percent_missing.sort_values(ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 302,
   "id": "4b80df61",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Text(0, 0.5, 'Number of rows')"
      ]
     },
     "execution_count": 302,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYkAAAEGCAYAAACQO2mwAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/NK7nSAAAACXBIWXMAAAsTAAALEwEAmpwYAAAXf0lEQVR4nO3de5QmdX3n8feHixtDcwBl7Z0QdNRoPERWhF7jCpJGDavigKJxZYmLQnb0RBMTdSNRo+yyOcEYzFnJRVFYyTrLeAdUvCCZBk28DQgMV0F23MjCjCwINEEi8N0/nmrtNF3dzzzdz214v87p0/XU9dvFM/WhflX1q1QVkiQtZpdhFyBJGl2GhCSplSEhSWplSEiSWhkSkqRWuw27gG7su+++tXbt2p6Wvffee9ljjz1Wt6ABGMe6x7FmsO5BGseaYTzrvvfee7n++utvr6p/uaIVVdXI/xxyyCHVq02bNvW87DCNY93jWHOVdQ/SONZcNZ51b9q0qYDNtcLjr81NkqRWhoQkqZUhIUlqZUhIkloZEpKkVoaEJKmVISFJamVISJJaGRKSpFZj0S3HSmy55S5ec/Lnh7LtracdNZTtStJq8UxCktTKkJAktTIkJEmtDAlJUqu+hUSS/ZNsSnJtkmuSvKkZf0qSW5Jc0fy8uF81SJJWpp93Nz0AvKWqLk+yJ3BZkouaaX9eVX/Wx21LklZB30Kiqm4Fbm2G70lyHbBfv7YnSVp9qar+byRZC1wKPB14M/Aa4G5gM52zjTsXWWY9sB5gcnLykI0bN/a07e133MW2+3padMUO3G+vnpednZ1lYmJiFavpv3GsGax7kMaxZhjP48js7Czr1q27rKqmVrL9vodEkgngEuCPq+rTSSaB24ECTgXWVNWJS61jamqqNm/e3NP2z9hwPqdvGc4zgyt5mG5mZobp6enVK2YAxrFmsO5BGseaYTyPIzMzMxxxxBErDom+3t2UZHfgU8CGqvo0QFVtq6oHq+oh4EPAs/pZgySpd/28uynAWcB1VfW+eePXzJvtZcDV/apBkrQy/Tx/OhR4NbAlyRXNuLcDxyU5iE5z01bgdX2sQZK0Av28u+lrQBaZdGG/tilJWl0+cS1JamVISJJaGRKSpFaGhCSplSEhSWplSEiSWhkSkqRWhoQkqZUhIUlqZUhIkloZEpKkVoaEJKmVISFJamVISJJaGRKSpFaGhCSplSEhSWplSEiSWhkSkqRWhoQkqZUhIUlqZUhIkloZEpKkVoaEJKmVISFJamVISJJaGRKSpFaGhCSplSEhSWplSEiSWvUtJJLsn2RTkmuTXJPkTc34xyS5KMmNze99+lWDJGll+nkm8QDwlqo6AHg28IYkBwAnAxdX1VOAi5vPkqQR1LeQqKpbq+ryZvge4DpgP+AY4JxmtnOAl/arBknSygzkmkSStcAzgW8Ck1V1azPpNmByEDVIknZcqqq/G0gmgEuAP66qTyf5UVXtPW/6nVX1sOsSSdYD6wEmJycP2bhxY0/b337HXWy7r6dFV+zA/fbqednZ2VkmJiZWsZr+G8eawboHaRxrhvE8jszOzrJu3brLqmpqJdvfbSULLyfJ7sCngA1V9elm9LYka6rq1iRrgO2LLVtVZwJnAkxNTdX09HRPNZyx4XxO39LXP7PV1uOne152ZmaGXv/mYRnHmsG6B2kca4bxPI7MzMysyvb7eXdTgLOA66rqffMmXQCc0AyfAJzfrxokSSvTz2g8FHg1sCXJFc24twOnAR9PchLwfeCVfaxBkrQCfQuJqvoakJbJz+/XdiVJq8cnriVJrQwJSVIrQ0KS1MqQkCS1MiQkSa0MCUlSK0NCktRq2ZBIcmiSPZrh30zyviRP6H9pkqRh6+ZM4q+Bf0zyDOAtwPeAv+lrVZKkkdBNSDxQna5ijwH+oqr+Etizv2VJkkZBN91y3JPkD4HfBA5Psguwe3/LkiSNgm7OJP49cD9wUlXdBvwi8N6+ViVJGgndnEkcBXy2qm4EqKr/g9ckJOkRoZuQeDzwweYVpJcBlwKXVtWV/SxMkjR8yzY3VdW7q+p5wK8AXwX+M3B5vwuTJA3fsmcSSd5J5wVCE8B3gLfSCQtJ0k6um+amY4EHgM8DlwBfr6r7+1qVJGkkdNPcdDDwAuBbwK/TeR3p1/pdmCRp+Lppbno68Fzg14Ap4B+wuUmSHhG6aW46jU4ovB/4dlX9pL8lSZJGxbIhUVUvSfIo4KnALye5waCQpEeGbpqbfo3Ow3NbgQD7Jzmhqi7tc22SpCHrprnpfcCRVXUDQJKnAucCh/SzMEnS8HXTd9PucwEBUFXfxQ7+JOkRoZszicuSfBj4aPP5eGBz/0qSJI2KbkLi9cAbgN9tPn8V+Ku+VSRJGhlLhkSSXYErq+ppdK5NSJIeQZa8JlFVDwI3JHn8gOqRJI2Qbpqb9gGuSfIt4N65kVV1dN+qkiSNhG5C4o/6XoUkaSR188T1JYMoRJI0erp5TqInSc5Osj3J1fPGnZLkliRXND8v7tf2JUkr17eQAD4CvHCR8X9eVQc1Pxf2cfuSpBVqDYkkFze/39PLipu+ne7osS5J0ghIVS0+IbkW+C3gLOA/0Onc76eqatn3XCdZC3yuqp7efD4FeA1wN52ntt9SVXe2LLseWA8wOTl5yMaNG7v5ex5m+x13se2+nhZdsQP326vnZWdnZ5mYmFjFavpvHGsG6x6kcawZxvM4Mjs7y7p16y6rqqmVbH+pkHgFcBJwGA/vhqOq6nnLrvzhITEJ3A4UcCqwpqpOXG49U1NTtXlzbz2BnLHhfE7f0s1NXKtv62lH9bzszMwM09PTq1fMAIxjzWDdgzSONcN4HkdmZmY44ogjVhwSrX91VX0S+GSSP6qqU1eykXnr3DY3nORDwOdWY72SpP7o5hbYU5McDRzejJqpqp4O7knWVNWtzceXAVcvNb8kabi6eenQnwDPAjY0o96U5DlV9fZlljsXmAb2TfID4N3AdJKD6DQ3bQVe13PlkqS+66aR7SjgoKp6CCDJOcB3gCVDoqqOW2T0WTtcoSRpaLp9TmLvecO937IjSRor3ZxJ/AnwnSSb6NwGezhwcl+rkiSNhG4uXJ+bZAb4N82ot1XVbX2tSpI0Erq68be5I+mCPtciSRox/ey7SZI05gwJSVKrJUMiya5Jrh9UMZKk0eI7riVJrXzHtSSple+4liS16uod10meADylqr6S5OeBXftfmiRp2Ja9uynJfwI+CXywGbUfcF4fa5IkjYhuboF9A3AonbfJUVU3Ao/rZ1GSpNHQTUjcX1X/NPchyW50uvqWJO3kugmJS5K8HXh0kl8HPgF8tr9lSZJGQTchcTLwQ2ALnZcEXQi8s59FSZJGQzd3Nz3UvGjom3SamW6oKpubJOkRoJvXlx4FfAD4Hp33STwxyeuq6gv9Lk6SNFzdPEx3OnBEVd0EkOTJwOcBQ0KSdnLdXJO4Zy4gGjcD9/SpHknSCGk9k0hybDO4OcmFwMfpXJP4DeDbA6hNkjRkSzU3rZs3vA34tWb4h8Cj+1aRJGlktIZEVb12kIVIkkZPN3c3PRH4HWDt/PntKlySdn7d3N10HnAWnaesH+prNZKkkdJNSPy4qt7f90okSSOnm5D470neDXwZuH9uZFVd3reqJEkjoZuQOBB4NfA8ftbcVM1nSdJOrJuQ+A3gSfO7C5ckPTJ088T11cDefa5DkjSCujmT2Bu4Psm3+efXJLwFVpJ2ct2ExLt7WXGSs4GXANur6unNuMcAH6PzzMVW4JVVdWcv65ck9d+yzU1VdcliP12s+yPACxeMOxm4uKqeAlzcfJYkjahlQyLJPUnubn5+nOTBJHcvt1xVXQrcsWD0McA5zfA5wEt3tGBJ0uBkR14ylyR0DvTPrqplzwKSrAU+N6+56UdVtfe8dd0593mRZdcD6wEmJycP2bhxY9d1zrf9jrvYdl9Pi67Ygfvt1fOys7OzTExMrGI1/TeONYN1D9I41gzjeRyZnZ1l3bp1l1XV1Eq23801iZ9qXlt6XvNw3YqaiqqqkrQmVFWdCZwJMDU1VdPT0z1t54wN53P6lh36M1fN1uOne152ZmaGXv/mYRnHmsG6B2kca4bxPI7MzMysyva76eDv2HkfdwGmgB/3uL1tSdZU1a1J1gDbe1yPJGkAuonG+e+VeIDOXUnH9Li9C4ATgNOa3+f3uB5J0gAsGxK9vlciybnANLBvkh/QuZX2NODjSU4Cvg+8spd1S5IGY6nXl75rieWqqk5dasVVdVzLpOd3U5gkafiWOpO4d5FxewAnAY8FlgwJSdL4W+r1pafPDSfZE3gT8FpgI3B623KSpJ3Hktckmm403gwcT+fht4PtRkOSHjmWuibxXuBYOs8qHFhVswOrSpI0EpbqluMtwC8A7wT+77yuOe7pplsOSdL4W+qaRDfvmpAk7cQMAklSK0NCktTKkJAktTIkJEmtDAlJUitDQpLUypCQJLUyJCRJrQwJSVIrQ0KS1MqQkCS1MiQkSa0MCUlSK0NCktTKkJAktTIkJEmtDAlJUitDQpLUypCQJLUyJCRJrQwJSVIrQ0KS1MqQkCS1MiQkSa0MCUlSq92GsdEkW4F7gAeBB6pqahh1SJKWNpSQaBxRVbcPcfuSpGXY3CRJapWqGvxGk/8N3AkU8MGqOnORedYD6wEmJycP2bhxY0/b2n7HXWy7bwXFrsCB++3V87Kzs7NMTEysYjX9N441g3UP0jjWDON5HJmdnWXdunWXrbQ5f1jNTYdV1S1JHgdclOT6qrp0/gxNcJwJMDU1VdPT0z1t6IwN53P6luH8mVuPn+552ZmZGXr9m4dlHGsG6x6kcawZxvM4MjMzsyrbH0pzU1Xd0vzeDnwGeNYw6pAkLW3gIZFkjyR7zg0DRwJXD7oOSdLyhnH+NAl8Jsnc9v9XVX1xCHVIkpYx8JCoqpuBZwx6u5KkHectsJKkVoaEJKmVISFJamVISJJaGRKSpFaGhCSplSEhSWplSEiSWhkSkqRWhoQkqZUhIUlqZUhIkloZEpKkVoaEJKmVISFJamVISJJaGRKSpFaGhCSplSEhSWplSEiSWhkSkqRWhoQkqZUhIUlqZUhIkloZEpKkVoaEJKmVISFJamVISJJaGRKSpFaGhCSplSEhSWo1lJBI8sIkNyS5KcnJw6hBkrS8gYdEkl2BvwReBBwAHJfkgEHXIUla3jDOJJ4F3FRVN1fVPwEbgWOGUIckaRm7DWGb+wH/MO/zD4BfXThTkvXA+ubjbJIbetzevsDtPS67InnPihYfWt0rMI41g3UP0jjWDON5HNkXeMJKtz+MkOhKVZ0JnLnS9STZXFVTq1DSQI1j3eNYM1j3II1jzTCedTc1r13peobR3HQLsP+8z7/YjJMkjZhhhMS3gackeWKSRwGvAi4YQh2SpGUMvLmpqh5I8kbgS8CuwNlVdU0fN7niJqshGce6x7FmsO5BGseaYTzrXpWaU1WrsR5J0k7IJ64lSa0MCUlSq50mJJbr6iPJv0jysWb6N5OsHUKZC2vaP8mmJNcmuSbJmxaZZzrJXUmuaH7eNYxaF9S0NcmWpp7Ni0xPkvc3+/qqJAcPo84FNf3yvH14RZK7k/zegnlGYl8nOTvJ9iRXzxv3mCQXJbmx+b1Py7InNPPcmOSEIdf83iTXN9+BzyTZu2XZJb9P/dRS9ylJbpn3PXhxy7JD6V6opeaPzat3a5IrWpbd8X1dVWP/Q+cC+PeAJwGPAq4EDlgwz28DH2iGXwV8bATqXgMc3AzvCXx3kbqngc8Nu9YFNW0F9l1i+ouBLwABng18c9g1L/J9uQ14wijua+Bw4GDg6nnj/hQ4uRk+GXjPIss9Bri5+b1PM7zPEGs+EtitGX7PYjV3830aQt2nAG/t4ju05DFnkDUvmH468K7V2tc7y5lEN119HAOc0wx/Enh+kgywxoepqlur6vJm+B7gOjpPpI+7Y4C/qY5vAHsnWTPsouZ5PvC9qvr+sAtZTFVdCtyxYPT87+85wEsXWfTfARdV1R1VdSdwEfDCftU532I1V9WXq+qB5uM36DwTNVJa9nU3hta90FI1N8e0VwLnrtb2dpaQWKyrj4UH25/O03xx7wIeO5DqutA0fz0T+OYik/9tkiuTfCHJrwy2skUV8OUklzXdpyzUzX+PYXoV7f+IRm1fz5msqlub4duAyUXmGeX9fiKds8vFLPd9GoY3Ns1kZ7c07Y3qvn4usK2qbmyZvsP7emcJibGWZAL4FPB7VXX3gsmX02kWeQZwBnDegMtbzGFVdTCdnnzfkOTwYRfUreYBzqOBTywyeRT39cNUp91gbO5dT/IO4AFgQ8sso/Z9+mvgycBBwK10mm/GxXEsfRaxw/t6ZwmJbrr6+Ok8SXYD9gL+30CqW0KS3ekExIaq+vTC6VV1d1XNNsMXArsn2XfAZS6s6Zbm93bgM3ROvecb5a5XXgRcXlXbFk4YxX09z7a5Jrvm9/ZF5hm5/Z7kNcBLgOObcHuYLr5PA1VV26rqwap6CPhQSz2juK93A44FPtY2Ty/7emcJiW66+rgAmLvb4xXA37Z9aQelaT88C7iuqt7XMs+/mrt2kuRZdP6bDS3ckuyRZM+5YToXJ69eMNsFwH9s7nJ6NnDXvKaSYWv9P61R29cLzP/+ngCcv8g8XwKOTLJP00RyZDNuKJK8EPgD4Oiq+seWebr5Pg3UgutnL2Pxekaxe6EXANdX1Q8Wm9jzvh7E1fhB/NC5o+a7dO44eEcz7r/S+YIC/BydJoabgG8BTxqBmg+j02xwFXBF8/Ni4PXA65t53ghcQ+fuiW8AzxlyzU9qarmyqWtuX8+vOXReLPU9YAswNex93dS1B52D/l7zxo3cvqYTYrcCP6HT1n0SnetnFwM3Al8BHtPMOwV8eN6yJzbf8ZuA1w655pvotNvPfbfn7i78BeDCpb5PQ677fzbf26voHPjXLKy7+fywY86wam7Gf2Tuuzxv3hXva7vlkCS12lmamyRJfWBISJJaGRKSpFaGhCSplSEhSWplSGgsJHmw6bny6iSfSPLzQ6hhOslzVriODyc5YAeXOXqQvYxK83kLrMZCktmqmmiGNwCXVcsDiAuW261+1sncSms4BZitqj9bjfVJ48AzCY2jrwK/1DxBenaSbyX5TpJjoNMVRJILkvwtcHGSiST/o+lH/6okL2/mOzLJ15Nc3pydzIXQ1iT/pRm/JcnTmg4YXw/8fnNG89z5BaXzDoJzknw1yfeTHJvkT5vlv9h0v0KSmSRTSXZN8pHmzGhLkt9vpv9uOu8XuSrJxnl/z180wx9J510df5/k5iSvaMbvkuSv0nl/w0VJLpybJq3EbsMuQNoRTf80LwK+CLyDTvcqJ6bzQptvJflKM+vBwL+uqjuSvIdO1yAHNuvYp+mT6Z3AC6rq3iRvA95M5yl9gNur6uAkv03n3QK/leQDLH0m8WTgCOAA4OvAy6vqD5J8BjiKf95h4EHAflX19KamvZvxJwNPrKr70/KSHjrvITkMeBqdJ4I/SafPnrXNth9Hp9v5s1uWl7pmSGhcPDo/e9vWV+n0efX3wNFJ3tqM/zng8c3wRVU11+f+C+j0rQNAVd2Z5CV0Dqh/13TX9Cg6B/Y5c50tXkbnANyNL1TVT5JsofNSmi8247fQOYDPdzPwpCRnAJ8HvtyMvwrYkOQ82nuhPa86nc9dm2Suy/DDgE80429LsqnLmqUlGRIaF/dV1UHzRzSd8b28qm5YMP5XgXuXWV/oBMlxLdPvb34/SPf/Tu4HqKqHkvykfnbB76GF62iC6hl0XhT0ejovijmRzhnH4cA64B1JDlyitrm/Q+obr0lonH0J+J15Pbc+s2W+i4A3zH1oekj9BnBokl9qxu2R5KnLbO8eOq+ZXbGmuWuXqvoUnWavg5PsAuxfVZuAt9Hpzn6iy1X+HfDy5trEJJ1XsUorZkhonJ0K7A5cleSa5vNi/huwT3OR+ErgiKr6IfAa4NwkV9FpanraMtv7LPCyxS5c92A/YKZpQvso8Id0mqg+2jRXfQd4f1X9qMv1fYpOj6DXNuu7nM7bF6UV8RZYaSeRZKKqZpM8lk53+IdW1W3DrkvjzWsS0s7jc80dUY8CTjUgtBo8k5AktfKahCSplSEhSWplSEiSWhkSkqRWhoQkqdX/ByoQdOg7cRCwAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "percent_missing_rows = df.isnull().sum(axis=0) / len(df.columns)\n",
    "missing_plt = percent_missing_rows.hist()\n",
    "missing_plt.set_xlabel('Percent missing')\n",
    "missing_plt.set_ylabel('Number of rows')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d1c03ab5",
   "metadata": {},
   "source": [
    "# Cleaning Dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 303,
   "id": "b55be4da",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfCopy = df.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 304,
   "id": "1855dbfc",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfCopy = dfCopy.replace(['NO DATA', 'N/A', '', 'NaN'],np.nan)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 305,
   "id": "956c1007",
   "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>Unnamed: 0</th>\n",
       "      <th>Index</th>\n",
       "      <th>Address</th>\n",
       "      <th>FLAG</th>\n",
       "      <th>Avg min between sent tnx</th>\n",
       "      <th>Avg min between received tnx</th>\n",
       "      <th>Time Diff between first and last (Mins)</th>\n",
       "      <th>Sent tnx</th>\n",
       "      <th>Received Tnx</th>\n",
       "      <th>Number of Created Contracts</th>\n",
       "      <th>...</th>\n",
       "      <th>ERC20 min val sent</th>\n",
       "      <th>ERC20 max val sent</th>\n",
       "      <th>ERC20 avg val sent</th>\n",
       "      <th>ERC20 min val sent contract</th>\n",
       "      <th>ERC20 max val sent contract</th>\n",
       "      <th>ERC20 avg val sent contract</th>\n",
       "      <th>ERC20 uniq sent token name</th>\n",
       "      <th>ERC20 uniq rec token name</th>\n",
       "      <th>ERC20 most sent token type</th>\n",
       "      <th>ERC20_most_rec_token_type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0x00009277775ac7d0d59eaad8fee3d10ac6c805e8</td>\n",
       "      <td>0</td>\n",
       "      <td>844.26</td>\n",
       "      <td>1093.71</td>\n",
       "      <td>704785.63</td>\n",
       "      <td>721</td>\n",
       "      <td>89</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.683100e+07</td>\n",
       "      <td>271779.920000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>Cofoundit</td>\n",
       "      <td>Numeraire</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0x0002b44ddb1476db43c868bd494422ee4c136fed</td>\n",
       "      <td>0</td>\n",
       "      <td>12709.07</td>\n",
       "      <td>2958.44</td>\n",
       "      <td>1218216.73</td>\n",
       "      <td>94</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2.260809</td>\n",
       "      <td>2.260809e+00</td>\n",
       "      <td>2.260809</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Livepeer Token</td>\n",
       "      <td>Livepeer Token</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>0x0002bda54cb772d040f779e88eb453cac0daa244</td>\n",
       "      <td>0</td>\n",
       "      <td>246194.54</td>\n",
       "      <td>2434.02</td>\n",
       "      <td>516729.30</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>None</td>\n",
       "      <td>XENON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>0x00038e6ba2fd5c09aedb96697c8d7b8fa6632e5e</td>\n",
       "      <td>0</td>\n",
       "      <td>10219.60</td>\n",
       "      <td>15785.09</td>\n",
       "      <td>397555.90</td>\n",
       "      <td>25</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>9.029231e+03</td>\n",
       "      <td>3804.076893</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Raiden</td>\n",
       "      <td>XENON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>0x00062d1dd1afb6fb02540ddad9cdebfe568e0d89</td>\n",
       "      <td>0</td>\n",
       "      <td>36.61</td>\n",
       "      <td>10707.77</td>\n",
       "      <td>382472.42</td>\n",
       "      <td>4598</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>4.500000e+04</td>\n",
       "      <td>13726.659220</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>StatusNetwork</td>\n",
       "      <td>EOS</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 51 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  Index                                     Address  FLAG  \\\n",
       "0           0      1  0x00009277775ac7d0d59eaad8fee3d10ac6c805e8     0   \n",
       "1           1      2  0x0002b44ddb1476db43c868bd494422ee4c136fed     0   \n",
       "2           2      3  0x0002bda54cb772d040f779e88eb453cac0daa244     0   \n",
       "3           3      4  0x00038e6ba2fd5c09aedb96697c8d7b8fa6632e5e     0   \n",
       "4           4      5  0x00062d1dd1afb6fb02540ddad9cdebfe568e0d89     0   \n",
       "\n",
       "   Avg min between sent tnx  Avg min between received tnx  \\\n",
       "0                    844.26                       1093.71   \n",
       "1                  12709.07                       2958.44   \n",
       "2                 246194.54                       2434.02   \n",
       "3                  10219.60                      15785.09   \n",
       "4                     36.61                      10707.77   \n",
       "\n",
       "   Time Diff between first and last (Mins)  Sent tnx  Received Tnx  \\\n",
       "0                                704785.63       721            89   \n",
       "1                               1218216.73        94             8   \n",
       "2                                516729.30         2            10   \n",
       "3                                397555.90        25             9   \n",
       "4                                382472.42      4598            20   \n",
       "\n",
       "   Number of Created Contracts  ...   ERC20 min val sent   ERC20 max val sent  \\\n",
       "0                            0  ...             0.000000         1.683100e+07   \n",
       "1                            0  ...             2.260809         2.260809e+00   \n",
       "2                            0  ...             0.000000         0.000000e+00   \n",
       "3                            0  ...           100.000000         9.029231e+03   \n",
       "4                            1  ...             0.000000         4.500000e+04   \n",
       "\n",
       "    ERC20 avg val sent   ERC20 min val sent contract  \\\n",
       "0        271779.920000                           0.0   \n",
       "1             2.260809                           0.0   \n",
       "2             0.000000                           0.0   \n",
       "3          3804.076893                           0.0   \n",
       "4         13726.659220                           0.0   \n",
       "\n",
       "    ERC20 max val sent contract   ERC20 avg val sent contract  \\\n",
       "0                           0.0                           0.0   \n",
       "1                           0.0                           0.0   \n",
       "2                           0.0                           0.0   \n",
       "3                           0.0                           0.0   \n",
       "4                           0.0                           0.0   \n",
       "\n",
       "    ERC20 uniq sent token name   ERC20 uniq rec token name  \\\n",
       "0                         39.0                        57.0   \n",
       "1                          1.0                         7.0   \n",
       "2                          0.0                         8.0   \n",
       "3                          1.0                        11.0   \n",
       "4                          6.0                        27.0   \n",
       "\n",
       "    ERC20 most sent token type   ERC20_most_rec_token_type  \n",
       "0                    Cofoundit                   Numeraire  \n",
       "1               Livepeer Token              Livepeer Token  \n",
       "2                         None                       XENON  \n",
       "3                       Raiden                       XENON  \n",
       "4                StatusNetwork                         EOS  \n",
       "\n",
       "[5 rows x 51 columns]"
      ]
     },
     "execution_count": 305,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfCopy.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 306,
   "id": "3fda4ddc",
   "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>Unnamed: 0</th>\n",
       "      <th>FLAG</th>\n",
       "      <th>Avg min between sent tnx</th>\n",
       "      <th>Avg min between received tnx</th>\n",
       "      <th>Time Diff between first and last (Mins)</th>\n",
       "      <th>Sent tnx</th>\n",
       "      <th>Received Tnx</th>\n",
       "      <th>Number of Created Contracts</th>\n",
       "      <th>Unique Received From Addresses</th>\n",
       "      <th>Unique Sent To Addresses</th>\n",
       "      <th>...</th>\n",
       "      <th>ERC20 min val sent</th>\n",
       "      <th>ERC20 max val sent</th>\n",
       "      <th>ERC20 avg val sent</th>\n",
       "      <th>ERC20 min val sent contract</th>\n",
       "      <th>ERC20 max val sent contract</th>\n",
       "      <th>ERC20 avg val sent contract</th>\n",
       "      <th>ERC20 uniq sent token name</th>\n",
       "      <th>ERC20 uniq rec token name</th>\n",
       "      <th>ERC20 most sent token type</th>\n",
       "      <th>ERC20_most_rec_token_type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>844.26</td>\n",
       "      <td>1093.71</td>\n",
       "      <td>704785.63</td>\n",
       "      <td>721</td>\n",
       "      <td>89</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>118</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.683100e+07</td>\n",
       "      <td>271779.920000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>Cofoundit</td>\n",
       "      <td>Numeraire</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>12709.07</td>\n",
       "      <td>2958.44</td>\n",
       "      <td>1218216.73</td>\n",
       "      <td>94</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>14</td>\n",
       "      <td>...</td>\n",
       "      <td>2.260809</td>\n",
       "      <td>2.260809e+00</td>\n",
       "      <td>2.260809</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Livepeer Token</td>\n",
       "      <td>Livepeer Token</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>246194.54</td>\n",
       "      <td>2434.02</td>\n",
       "      <td>516729.30</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>None</td>\n",
       "      <td>XENON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>10219.60</td>\n",
       "      <td>15785.09</td>\n",
       "      <td>397555.90</td>\n",
       "      <td>25</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>13</td>\n",
       "      <td>...</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>9.029231e+03</td>\n",
       "      <td>3804.076893</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Raiden</td>\n",
       "      <td>XENON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>36.61</td>\n",
       "      <td>10707.77</td>\n",
       "      <td>382472.42</td>\n",
       "      <td>4598</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>4.500000e+04</td>\n",
       "      <td>13726.659220</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>StatusNetwork</td>\n",
       "      <td>EOS</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 49 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  FLAG  Avg min between sent tnx  Avg min between received tnx  \\\n",
       "0           0     0                    844.26                       1093.71   \n",
       "1           1     0                  12709.07                       2958.44   \n",
       "2           2     0                 246194.54                       2434.02   \n",
       "3           3     0                  10219.60                      15785.09   \n",
       "4           4     0                     36.61                      10707.77   \n",
       "\n",
       "   Time Diff between first and last (Mins)  Sent tnx  Received Tnx  \\\n",
       "0                                704785.63       721            89   \n",
       "1                               1218216.73        94             8   \n",
       "2                                516729.30         2            10   \n",
       "3                                397555.90        25             9   \n",
       "4                                382472.42      4598            20   \n",
       "\n",
       "   Number of Created Contracts  Unique Received From Addresses  \\\n",
       "0                            0                              40   \n",
       "1                            0                               5   \n",
       "2                            0                              10   \n",
       "3                            0                               7   \n",
       "4                            1                               7   \n",
       "\n",
       "   Unique Sent To Addresses  ...   ERC20 min val sent   ERC20 max val sent  \\\n",
       "0                       118  ...             0.000000         1.683100e+07   \n",
       "1                        14  ...             2.260809         2.260809e+00   \n",
       "2                         2  ...             0.000000         0.000000e+00   \n",
       "3                        13  ...           100.000000         9.029231e+03   \n",
       "4                        19  ...             0.000000         4.500000e+04   \n",
       "\n",
       "    ERC20 avg val sent   ERC20 min val sent contract  \\\n",
       "0        271779.920000                           0.0   \n",
       "1             2.260809                           0.0   \n",
       "2             0.000000                           0.0   \n",
       "3          3804.076893                           0.0   \n",
       "4         13726.659220                           0.0   \n",
       "\n",
       "    ERC20 max val sent contract   ERC20 avg val sent contract  \\\n",
       "0                           0.0                           0.0   \n",
       "1                           0.0                           0.0   \n",
       "2                           0.0                           0.0   \n",
       "3                           0.0                           0.0   \n",
       "4                           0.0                           0.0   \n",
       "\n",
       "    ERC20 uniq sent token name   ERC20 uniq rec token name  \\\n",
       "0                         39.0                        57.0   \n",
       "1                          1.0                         7.0   \n",
       "2                          0.0                         8.0   \n",
       "3                          1.0                        11.0   \n",
       "4                          6.0                        27.0   \n",
       "\n",
       "    ERC20 most sent token type   ERC20_most_rec_token_type  \n",
       "0                    Cofoundit                   Numeraire  \n",
       "1               Livepeer Token              Livepeer Token  \n",
       "2                         None                       XENON  \n",
       "3                       Raiden                       XENON  \n",
       "4                StatusNetwork                         EOS  \n",
       "\n",
       "[5 rows x 49 columns]"
      ]
     },
     "execution_count": 306,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfCopy = dfCopy.drop(['Index', 'Address'], axis = 1)\n",
    "dfCopy.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "28dc1967",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "6d60082f",
   "metadata": {},
   "source": [
    "#### Checking the number of different strings in last 2 columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 307,
   "id": "f749114c",
   "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>ERC20 most sent token type</th>\n",
       "      <th>ERC20_most_rec_token_type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Cofoundit</td>\n",
       "      <td>Numeraire</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Livepeer Token</td>\n",
       "      <td>Livepeer Token</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>None</td>\n",
       "      <td>XENON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Raiden</td>\n",
       "      <td>XENON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>StatusNetwork</td>\n",
       "      <td>EOS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>None</td>\n",
       "      <td>XENON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>None</td>\n",
       "      <td>AICRYPTO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>None</td>\n",
       "      <td>XENON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>None</td>\n",
       "      <td>DATAcoin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>None</td>\n",
       "      <td>PoSToken</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>TenXPay</td>\n",
       "      <td>KyberNetwork</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    ERC20 most sent token type  ERC20_most_rec_token_type\n",
       "0                    Cofoundit                  Numeraire\n",
       "1               Livepeer Token             Livepeer Token\n",
       "2                         None                      XENON\n",
       "3                       Raiden                      XENON\n",
       "4                StatusNetwork                        EOS\n",
       "5                            0                          0\n",
       "6                            0                          0\n",
       "7                         None                      XENON\n",
       "8                            0                          0\n",
       "9                         None                   AICRYPTO\n",
       "10                           0                          0\n",
       "11                        None                      XENON\n",
       "12                        None                   DATAcoin\n",
       "13                        None                   PoSToken\n",
       "14                     TenXPay               KyberNetwork"
      ]
     },
     "execution_count": 307,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfCopy.iloc[:, 47:49].head(15)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "756ce5c5",
   "metadata": {},
   "source": [
    "#### Replace the 0 and None values by np.nan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 308,
   "id": "e99dfa92",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfCopy.iloc[:, 47:49] = dfCopy.iloc[:, 47:49].replace(['NO DATA', 'N/A', \" \", 'NaN', 0, '0', 'None'],np.nan)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 309,
   "id": "6a0d7619",
   "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>ERC20 most sent token type</th>\n",
       "      <th>ERC20_most_rec_token_type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9836</th>\n",
       "      <td>NaN</td>\n",
       "      <td>GSENetwork</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9837</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Blockwell say NOTSAFU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9838</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Free BOB Tokens - BobsRepair.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9839</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9840</th>\n",
       "      <td>NaN</td>\n",
       "      <td>INS Promo1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      ERC20 most sent token type         ERC20_most_rec_token_type\n",
       "9836                         NaN                        GSENetwork\n",
       "9837                         NaN             Blockwell say NOTSAFU\n",
       "9838                         NaN  Free BOB Tokens - BobsRepair.com\n",
       "9839                         NaN                               NaN\n",
       "9840                         NaN                        INS Promo1"
      ]
     },
     "execution_count": 309,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfCopy.iloc[:, 47:49].tail(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 310,
   "id": "17ab127f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "EOS                                                       138\n",
       "OmiseGO                                                   137\n",
       "Golem                                                     130\n",
       "blockwell.ai KYC Casper Token                             128\n",
       "StatusNetwork                                              61\n",
       "                                                         ... \n",
       "RCoinVer70                                                  1\n",
       "Covalent Token                                              1\n",
       "Nebula AI Token                                             1\n",
       "Blocktix                                                    1\n",
       "eosDAC Community Owned EOS Block Producer ERC20 Tokens      1\n",
       "Name:  ERC20 most sent token type, Length: 302, dtype: int64"
      ]
     },
     "execution_count": 310,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "noOfUniqueTokenSent = dfCopy.iloc[:, 47].value_counts(dropna=True)\n",
    "noOfUniqueTokenSent"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 311,
   "id": "87966004",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "OmiseGO                  873\n",
       "Blockwell say NOTSAFU    779\n",
       "DATAcoin                 358\n",
       "Livepeer Token           207\n",
       "EOS                      161\n",
       "                        ... \n",
       "BCDN                       1\n",
       "Egretia                    1\n",
       "UG Coin                    1\n",
       "Yun Planet                 1\n",
       "INS Promo1                 1\n",
       "Name:  ERC20_most_rec_token_type, Length: 464, dtype: int64"
      ]
     },
     "execution_count": 311,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "noOfUniqueTokenRec = dfCopy.iloc[:, 48].value_counts(dropna=True)\n",
    "noOfUniqueTokenRec"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 312,
   "id": "8a54a7a7",
   "metadata": {},
   "outputs": [],
   "source": [
    "imputer = SimpleImputer(missing_values = np.nan, strategy ='mean')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 313,
   "id": "f6634847",
   "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>Unnamed: 0</th>\n",
       "      <th>FLAG</th>\n",
       "      <th>Avg min between sent tnx</th>\n",
       "      <th>Avg min between received tnx</th>\n",
       "      <th>Time Diff between first and last (Mins)</th>\n",
       "      <th>Sent tnx</th>\n",
       "      <th>Received Tnx</th>\n",
       "      <th>Number of Created Contracts</th>\n",
       "      <th>Unique Received From Addresses</th>\n",
       "      <th>Unique Sent To Addresses</th>\n",
       "      <th>...</th>\n",
       "      <th>ERC20 min val sent</th>\n",
       "      <th>ERC20 max val sent</th>\n",
       "      <th>ERC20 avg val sent</th>\n",
       "      <th>ERC20 min val sent contract</th>\n",
       "      <th>ERC20 max val sent contract</th>\n",
       "      <th>ERC20 avg val sent contract</th>\n",
       "      <th>ERC20 uniq sent token name</th>\n",
       "      <th>ERC20 uniq rec token name</th>\n",
       "      <th>ERC20 most sent token type</th>\n",
       "      <th>ERC20_most_rec_token_type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9836</th>\n",
       "      <td>9836</td>\n",
       "      <td>1</td>\n",
       "      <td>12635.10</td>\n",
       "      <td>631.39</td>\n",
       "      <td>58748.48</td>\n",
       "      <td>4</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GSENetwork</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9837</th>\n",
       "      <td>9837</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blockwell say NOTSAFU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9838</th>\n",
       "      <td>9838</td>\n",
       "      <td>1</td>\n",
       "      <td>2499.44</td>\n",
       "      <td>2189.29</td>\n",
       "      <td>261601.88</td>\n",
       "      <td>67</td>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>44</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Free BOB Tokens - BobsRepair.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9839</th>\n",
       "      <td>9839</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9840</th>\n",
       "      <td>9840</td>\n",
       "      <td>1</td>\n",
       "      <td>37242.70</td>\n",
       "      <td>149.56</td>\n",
       "      <td>670817.33</td>\n",
       "      <td>18</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>INS Promo1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 49 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0  FLAG  Avg min between sent tnx  \\\n",
       "9836        9836     1                  12635.10   \n",
       "9837        9837     1                      0.00   \n",
       "9838        9838     1                   2499.44   \n",
       "9839        9839     1                      0.00   \n",
       "9840        9840     1                  37242.70   \n",
       "\n",
       "      Avg min between received tnx  Time Diff between first and last (Mins)  \\\n",
       "9836                        631.39                                 58748.48   \n",
       "9837                          0.00                                     0.00   \n",
       "9838                       2189.29                                261601.88   \n",
       "9839                          0.00                                     0.00   \n",
       "9840                        149.56                                670817.33   \n",
       "\n",
       "      Sent tnx  Received Tnx  Number of Created Contracts  \\\n",
       "9836         4            13                            0   \n",
       "9837         0             0                            0   \n",
       "9838        67            43                            0   \n",
       "9839         0             1                            0   \n",
       "9840        18             3                            0   \n",
       "\n",
       "      Unique Received From Addresses  Unique Sent To Addresses  ...  \\\n",
       "9836                              11                         4  ...   \n",
       "9837                               0                         0  ...   \n",
       "9838                              31                        44  ...   \n",
       "9839                               1                         0  ...   \n",
       "9840                               1                         5  ...   \n",
       "\n",
       "       ERC20 min val sent   ERC20 max val sent   ERC20 avg val sent  \\\n",
       "9836                  0.0                  0.0                  0.0   \n",
       "9837                  0.0                  0.0                  0.0   \n",
       "9838                  0.0                  0.0                  0.0   \n",
       "9839                  NaN                  NaN                  NaN   \n",
       "9840                  0.0                  0.0                  0.0   \n",
       "\n",
       "       ERC20 min val sent contract   ERC20 max val sent contract  \\\n",
       "9836                           0.0                           0.0   \n",
       "9837                           0.0                           0.0   \n",
       "9838                           0.0                           0.0   \n",
       "9839                           NaN                           NaN   \n",
       "9840                           0.0                           0.0   \n",
       "\n",
       "       ERC20 avg val sent contract   ERC20 uniq sent token name  \\\n",
       "9836                           0.0                          0.0   \n",
       "9837                           0.0                          0.0   \n",
       "9838                           0.0                          0.0   \n",
       "9839                           NaN                          NaN   \n",
       "9840                           0.0                          0.0   \n",
       "\n",
       "       ERC20 uniq rec token name   ERC20 most sent token type  \\\n",
       "9836                         2.0                          NaN   \n",
       "9837                         1.0                          NaN   \n",
       "9838                         5.0                          NaN   \n",
       "9839                         NaN                          NaN   \n",
       "9840                        42.0                          NaN   \n",
       "\n",
       "             ERC20_most_rec_token_type  \n",
       "9836                        GSENetwork  \n",
       "9837             Blockwell say NOTSAFU  \n",
       "9838  Free BOB Tokens - BobsRepair.com  \n",
       "9839                               NaN  \n",
       "9840                        INS Promo1  \n",
       "\n",
       "[5 rows x 49 columns]"
      ]
     },
     "execution_count": 313,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfCopy.tail(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 314,
   "id": "19589035",
   "metadata": {},
   "outputs": [],
   "source": [
    "imputer = imputer.fit(dfCopy.iloc[:, 2:47])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 315,
   "id": "3b01b999",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfCopy.iloc[:, 2:47] = imputer.transform(dfCopy.iloc[:, 2:47])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 316,
   "id": "73a36357",
   "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>Avg min between sent tnx</th>\n",
       "      <th>Avg min between received tnx</th>\n",
       "      <th>Time Diff between first and last (Mins)</th>\n",
       "      <th>Sent tnx</th>\n",
       "      <th>Received Tnx</th>\n",
       "      <th>Number of Created Contracts</th>\n",
       "      <th>Unique Received From Addresses</th>\n",
       "      <th>Unique Sent To Addresses</th>\n",
       "      <th>min value received</th>\n",
       "      <th>max value received</th>\n",
       "      <th>...</th>\n",
       "      <th>ERC20 max val rec</th>\n",
       "      <th>ERC20 avg val rec</th>\n",
       "      <th>ERC20 min val sent</th>\n",
       "      <th>ERC20 max val sent</th>\n",
       "      <th>ERC20 avg val sent</th>\n",
       "      <th>ERC20 min val sent contract</th>\n",
       "      <th>ERC20 max val sent contract</th>\n",
       "      <th>ERC20 avg val sent contract</th>\n",
       "      <th>ERC20 uniq sent token name</th>\n",
       "      <th>ERC20 uniq rec token name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9836</th>\n",
       "      <td>12635.10</td>\n",
       "      <td>631.39</td>\n",
       "      <td>58748.48</td>\n",
       "      <td>4.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.004082</td>\n",
       "      <td>12.00</td>\n",
       "      <td>...</td>\n",
       "      <td>1.337000e+00</td>\n",
       "      <td>6.685000e-01</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9837</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>1.337000e+01</td>\n",
       "      <td>1.337000e+01</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9838</th>\n",
       "      <td>2499.44</td>\n",
       "      <td>2189.29</td>\n",
       "      <td>261601.88</td>\n",
       "      <td>67.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>0.001078</td>\n",
       "      <td>21.31</td>\n",
       "      <td>...</td>\n",
       "      <td>1.500000e+03</td>\n",
       "      <td>3.006939e+02</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9839</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.50</td>\n",
       "      <td>...</td>\n",
       "      <td>1.252524e+08</td>\n",
       "      <td>4.346203e+06</td>\n",
       "      <td>11741.257297</td>\n",
       "      <td>1.303594e+07</td>\n",
       "      <td>6.318389e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.384931</td>\n",
       "      <td>4.826676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9840</th>\n",
       "      <td>37242.70</td>\n",
       "      <td>149.56</td>\n",
       "      <td>670817.33</td>\n",
       "      <td>18.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.795233</td>\n",
       "      <td>18998.00</td>\n",
       "      <td>...</td>\n",
       "      <td>2.018061e+04</td>\n",
       "      <td>1.365244e+03</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>42.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 45 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Avg min between sent tnx  Avg min between received tnx  \\\n",
       "9836                  12635.10                        631.39   \n",
       "9837                      0.00                          0.00   \n",
       "9838                   2499.44                       2189.29   \n",
       "9839                      0.00                          0.00   \n",
       "9840                  37242.70                        149.56   \n",
       "\n",
       "      Time Diff between first and last (Mins)  Sent tnx  Received Tnx  \\\n",
       "9836                                 58748.48       4.0          13.0   \n",
       "9837                                     0.00       0.0           0.0   \n",
       "9838                                261601.88      67.0          43.0   \n",
       "9839                                     0.00       0.0           1.0   \n",
       "9840                                670817.33      18.0           3.0   \n",
       "\n",
       "      Number of Created Contracts  Unique Received From Addresses  \\\n",
       "9836                          0.0                            11.0   \n",
       "9837                          0.0                             0.0   \n",
       "9838                          0.0                            31.0   \n",
       "9839                          0.0                             1.0   \n",
       "9840                          0.0                             1.0   \n",
       "\n",
       "      Unique Sent To Addresses  min value received  max value received   ...  \\\n",
       "9836                       4.0            0.004082                12.00  ...   \n",
       "9837                       0.0            0.000000                 0.00  ...   \n",
       "9838                      44.0            0.001078                21.31  ...   \n",
       "9839                       0.0            0.500000                 0.50  ...   \n",
       "9840                       5.0            0.795233             18998.00  ...   \n",
       "\n",
       "       ERC20 max val rec   ERC20 avg val rec   ERC20 min val sent  \\\n",
       "9836        1.337000e+00        6.685000e-01             0.000000   \n",
       "9837        1.337000e+01        1.337000e+01             0.000000   \n",
       "9838        1.500000e+03        3.006939e+02             0.000000   \n",
       "9839        1.252524e+08        4.346203e+06         11741.257297   \n",
       "9840        2.018061e+04        1.365244e+03             0.000000   \n",
       "\n",
       "       ERC20 max val sent   ERC20 avg val sent   ERC20 min val sent contract  \\\n",
       "9836         0.000000e+00         0.000000e+00                           0.0   \n",
       "9837         0.000000e+00         0.000000e+00                           0.0   \n",
       "9838         0.000000e+00         0.000000e+00                           0.0   \n",
       "9839         1.303594e+07         6.318389e+06                           0.0   \n",
       "9840         0.000000e+00         0.000000e+00                           0.0   \n",
       "\n",
       "       ERC20 max val sent contract   ERC20 avg val sent contract  \\\n",
       "9836                           0.0                           0.0   \n",
       "9837                           0.0                           0.0   \n",
       "9838                           0.0                           0.0   \n",
       "9839                           0.0                           0.0   \n",
       "9840                           0.0                           0.0   \n",
       "\n",
       "       ERC20 uniq sent token name   ERC20 uniq rec token name  \n",
       "9836                     0.000000                    2.000000  \n",
       "9837                     0.000000                    1.000000  \n",
       "9838                     0.000000                    5.000000  \n",
       "9839                     1.384931                    4.826676  \n",
       "9840                     0.000000                   42.000000  \n",
       "\n",
       "[5 rows x 45 columns]"
      ]
     },
     "execution_count": 316,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfCopy.iloc[:, 2:47].tail(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "900dc0e5",
   "metadata": {},
   "source": [
    "## Standardizing the data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 317,
   "id": "e6c18596",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.preprocessing import StandardScaler"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 318,
   "id": "de49735e",
   "metadata": {},
   "outputs": [],
   "source": [
    "scaler = StandardScaler()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 319,
   "id": "af4c4245",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>#sk-container-id-10 {color: black;background-color: white;}#sk-container-id-10 pre{padding: 0;}#sk-container-id-10 div.sk-toggleable {background-color: white;}#sk-container-id-10 label.sk-toggleable__label {cursor: pointer;display: block;width: 100%;margin-bottom: 0;padding: 0.3em;box-sizing: border-box;text-align: center;}#sk-container-id-10 label.sk-toggleable__label-arrow:before {content: \"▸\";float: left;margin-right: 0.25em;color: #696969;}#sk-container-id-10 label.sk-toggleable__label-arrow:hover:before {color: black;}#sk-container-id-10 div.sk-estimator:hover label.sk-toggleable__label-arrow:before {color: black;}#sk-container-id-10 div.sk-toggleable__content {max-height: 0;max-width: 0;overflow: hidden;text-align: left;background-color: #f0f8ff;}#sk-container-id-10 div.sk-toggleable__content pre {margin: 0.2em;color: black;border-radius: 0.25em;background-color: #f0f8ff;}#sk-container-id-10 input.sk-toggleable__control:checked~div.sk-toggleable__content {max-height: 200px;max-width: 100%;overflow: auto;}#sk-container-id-10 input.sk-toggleable__control:checked~label.sk-toggleable__label-arrow:before {content: \"▾\";}#sk-container-id-10 div.sk-estimator input.sk-toggleable__control:checked~label.sk-toggleable__label {background-color: #d4ebff;}#sk-container-id-10 div.sk-label input.sk-toggleable__control:checked~label.sk-toggleable__label {background-color: #d4ebff;}#sk-container-id-10 input.sk-hidden--visually {border: 0;clip: rect(1px 1px 1px 1px);clip: rect(1px, 1px, 1px, 1px);height: 1px;margin: -1px;overflow: hidden;padding: 0;position: absolute;width: 1px;}#sk-container-id-10 div.sk-estimator {font-family: monospace;background-color: #f0f8ff;border: 1px dotted black;border-radius: 0.25em;box-sizing: border-box;margin-bottom: 0.5em;}#sk-container-id-10 div.sk-estimator:hover {background-color: #d4ebff;}#sk-container-id-10 div.sk-parallel-item::after {content: \"\";width: 100%;border-bottom: 1px solid gray;flex-grow: 1;}#sk-container-id-10 div.sk-label:hover label.sk-toggleable__label {background-color: #d4ebff;}#sk-container-id-10 div.sk-serial::before {content: \"\";position: absolute;border-left: 1px solid gray;box-sizing: border-box;top: 0;bottom: 0;left: 50%;z-index: 0;}#sk-container-id-10 div.sk-serial {display: flex;flex-direction: column;align-items: center;background-color: white;padding-right: 0.2em;padding-left: 0.2em;position: relative;}#sk-container-id-10 div.sk-item {position: relative;z-index: 1;}#sk-container-id-10 div.sk-parallel {display: flex;align-items: stretch;justify-content: center;background-color: white;position: relative;}#sk-container-id-10 div.sk-item::before, #sk-container-id-10 div.sk-parallel-item::before {content: \"\";position: absolute;border-left: 1px solid gray;box-sizing: border-box;top: 0;bottom: 0;left: 50%;z-index: -1;}#sk-container-id-10 div.sk-parallel-item {display: flex;flex-direction: column;z-index: 1;position: relative;background-color: white;}#sk-container-id-10 div.sk-parallel-item:first-child::after {align-self: flex-end;width: 50%;}#sk-container-id-10 div.sk-parallel-item:last-child::after {align-self: flex-start;width: 50%;}#sk-container-id-10 div.sk-parallel-item:only-child::after {width: 0;}#sk-container-id-10 div.sk-dashed-wrapped {border: 1px dashed gray;margin: 0 0.4em 0.5em 0.4em;box-sizing: border-box;padding-bottom: 0.4em;background-color: white;}#sk-container-id-10 div.sk-label label {font-family: monospace;font-weight: bold;display: inline-block;line-height: 1.2em;}#sk-container-id-10 div.sk-label-container {text-align: center;}#sk-container-id-10 div.sk-container {/* jupyter's `normalize.less` sets `[hidden] { display: none; }` but bootstrap.min.css set `[hidden] { display: none !important; }` so we also need the `!important` here to be able to override the default hidden behavior on the sphinx rendered scikit-learn.org. See: https://github.com/scikit-learn/scikit-learn/issues/21755 */display: inline-block !important;position: relative;}#sk-container-id-10 div.sk-text-repr-fallback {display: none;}</style><div id=\"sk-container-id-10\" class=\"sk-top-container\"><div class=\"sk-text-repr-fallback\"><pre>StandardScaler()</pre><b>In a Jupyter environment, please rerun this cell to show the HTML representation or trust the notebook. <br />On GitHub, the HTML representation is unable to render, please try loading this page with nbviewer.org.</b></div><div class=\"sk-container\" hidden><div class=\"sk-item\"><div class=\"sk-estimator sk-toggleable\"><input class=\"sk-toggleable__control sk-hidden--visually\" id=\"sk-estimator-id-10\" type=\"checkbox\" checked><label for=\"sk-estimator-id-10\" class=\"sk-toggleable__label sk-toggleable__label-arrow\">StandardScaler</label><div class=\"sk-toggleable__content\"><pre>StandardScaler()</pre></div></div></div></div></div>"
      ],
      "text/plain": [
       "StandardScaler()"
      ]
     },
     "execution_count": 319,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "scaler.fit(dfCopy.iloc[:, 2:47])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 320,
   "id": "d78d481f",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfCopy.iloc[:, 2:47] = scaler.transform(dfCopy.iloc[:, 2:47])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 321,
   "id": "c78de716",
   "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>Avg min between sent tnx</th>\n",
       "      <th>Avg min between received tnx</th>\n",
       "      <th>Time Diff between first and last (Mins)</th>\n",
       "      <th>Sent tnx</th>\n",
       "      <th>Received Tnx</th>\n",
       "      <th>Number of Created Contracts</th>\n",
       "      <th>Unique Received From Addresses</th>\n",
       "      <th>Unique Sent To Addresses</th>\n",
       "      <th>min value received</th>\n",
       "      <th>max value received</th>\n",
       "      <th>...</th>\n",
       "      <th>ERC20 max val rec</th>\n",
       "      <th>ERC20 avg val rec</th>\n",
       "      <th>ERC20 min val sent</th>\n",
       "      <th>ERC20 max val sent</th>\n",
       "      <th>ERC20 avg val sent</th>\n",
       "      <th>ERC20 min val sent contract</th>\n",
       "      <th>ERC20 max val sent contract</th>\n",
       "      <th>ERC20 avg val sent contract</th>\n",
       "      <th>ERC20 uniq sent token name</th>\n",
       "      <th>ERC20 uniq rec token name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9836</th>\n",
       "      <td>0.351318</td>\n",
       "      <td>-0.319467</td>\n",
       "      <td>-0.494191</td>\n",
       "      <td>-0.147826</td>\n",
       "      <td>-0.160186</td>\n",
       "      <td>-0.02637</td>\n",
       "      <td>-0.064838</td>\n",
       "      <td>-0.082788</td>\n",
       "      <td>-0.134518</td>\n",
       "      <td>-0.039295</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.242182e-02</td>\n",
       "      <td>-2.121228e-02</td>\n",
       "      <td>-1.164623e-02</td>\n",
       "      <td>-1.154591e-02</td>\n",
       "      <td>-1.116354e-02</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.21489</td>\n",
       "      <td>-1.771125e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9837</th>\n",
       "      <td>-0.236759</td>\n",
       "      <td>-0.346822</td>\n",
       "      <td>-0.676119</td>\n",
       "      <td>-0.153108</td>\n",
       "      <td>-0.174004</td>\n",
       "      <td>-0.02637</td>\n",
       "      <td>-0.101676</td>\n",
       "      <td>-0.097951</td>\n",
       "      <td>-0.134530</td>\n",
       "      <td>-0.040217</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.242182e-02</td>\n",
       "      <td>-2.121222e-02</td>\n",
       "      <td>-1.164623e-02</td>\n",
       "      <td>-1.154591e-02</td>\n",
       "      <td>-1.116354e-02</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.21489</td>\n",
       "      <td>-2.397701e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9838</th>\n",
       "      <td>-0.120427</td>\n",
       "      <td>-0.251968</td>\n",
       "      <td>0.133991</td>\n",
       "      <td>-0.064623</td>\n",
       "      <td>-0.128298</td>\n",
       "      <td>-0.02637</td>\n",
       "      <td>0.002140</td>\n",
       "      <td>0.068838</td>\n",
       "      <td>-0.134527</td>\n",
       "      <td>-0.038579</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.242167e-02</td>\n",
       "      <td>-2.121082e-02</td>\n",
       "      <td>-1.164623e-02</td>\n",
       "      <td>-1.154591e-02</td>\n",
       "      <td>-1.116354e-02</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.21489</td>\n",
       "      <td>1.086008e-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9839</th>\n",
       "      <td>-0.236759</td>\n",
       "      <td>-0.346822</td>\n",
       "      <td>-0.676119</td>\n",
       "      <td>-0.153108</td>\n",
       "      <td>-0.172941</td>\n",
       "      <td>-0.02637</td>\n",
       "      <td>-0.098327</td>\n",
       "      <td>-0.097951</td>\n",
       "      <td>-0.132996</td>\n",
       "      <td>-0.040179</td>\n",
       "      <td>...</td>\n",
       "      <td>1.477813e-18</td>\n",
       "      <td>4.545457e-18</td>\n",
       "      <td>-1.804268e-18</td>\n",
       "      <td>-1.649742e-18</td>\n",
       "      <td>1.645492e-18</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>5.565108e-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9840</th>\n",
       "      <td>1.496632</td>\n",
       "      <td>-0.340343</td>\n",
       "      <td>1.401220</td>\n",
       "      <td>-0.129336</td>\n",
       "      <td>-0.170815</td>\n",
       "      <td>-0.02637</td>\n",
       "      <td>-0.098327</td>\n",
       "      <td>-0.078998</td>\n",
       "      <td>-0.132090</td>\n",
       "      <td>1.420251</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.241982e-02</td>\n",
       "      <td>-2.120562e-02</td>\n",
       "      <td>-1.164623e-02</td>\n",
       "      <td>-1.154591e-02</td>\n",
       "      <td>-1.116354e-02</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.21489</td>\n",
       "      <td>2.329189e+00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 45 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Avg min between sent tnx  Avg min between received tnx  \\\n",
       "9836                  0.351318                     -0.319467   \n",
       "9837                 -0.236759                     -0.346822   \n",
       "9838                 -0.120427                     -0.251968   \n",
       "9839                 -0.236759                     -0.346822   \n",
       "9840                  1.496632                     -0.340343   \n",
       "\n",
       "      Time Diff between first and last (Mins)  Sent tnx  Received Tnx  \\\n",
       "9836                                -0.494191 -0.147826     -0.160186   \n",
       "9837                                -0.676119 -0.153108     -0.174004   \n",
       "9838                                 0.133991 -0.064623     -0.128298   \n",
       "9839                                -0.676119 -0.153108     -0.172941   \n",
       "9840                                 1.401220 -0.129336     -0.170815   \n",
       "\n",
       "      Number of Created Contracts  Unique Received From Addresses  \\\n",
       "9836                     -0.02637                       -0.064838   \n",
       "9837                     -0.02637                       -0.101676   \n",
       "9838                     -0.02637                        0.002140   \n",
       "9839                     -0.02637                       -0.098327   \n",
       "9840                     -0.02637                       -0.098327   \n",
       "\n",
       "      Unique Sent To Addresses  min value received  max value received   ...  \\\n",
       "9836                 -0.082788           -0.134518            -0.039295  ...   \n",
       "9837                 -0.097951           -0.134530            -0.040217  ...   \n",
       "9838                  0.068838           -0.134527            -0.038579  ...   \n",
       "9839                 -0.097951           -0.132996            -0.040179  ...   \n",
       "9840                 -0.078998           -0.132090             1.420251  ...   \n",
       "\n",
       "       ERC20 max val rec   ERC20 avg val rec   ERC20 min val sent  \\\n",
       "9836       -1.242182e-02       -2.121228e-02        -1.164623e-02   \n",
       "9837       -1.242182e-02       -2.121222e-02        -1.164623e-02   \n",
       "9838       -1.242167e-02       -2.121082e-02        -1.164623e-02   \n",
       "9839        1.477813e-18        4.545457e-18        -1.804268e-18   \n",
       "9840       -1.241982e-02       -2.120562e-02        -1.164623e-02   \n",
       "\n",
       "       ERC20 max val sent   ERC20 avg val sent   ERC20 min val sent contract  \\\n",
       "9836        -1.154591e-02        -1.116354e-02                           0.0   \n",
       "9837        -1.154591e-02        -1.116354e-02                           0.0   \n",
       "9838        -1.154591e-02        -1.116354e-02                           0.0   \n",
       "9839        -1.649742e-18         1.645492e-18                           0.0   \n",
       "9840        -1.154591e-02        -1.116354e-02                           0.0   \n",
       "\n",
       "       ERC20 max val sent contract   ERC20 avg val sent contract  \\\n",
       "9836                           0.0                           0.0   \n",
       "9837                           0.0                           0.0   \n",
       "9838                           0.0                           0.0   \n",
       "9839                           0.0                           0.0   \n",
       "9840                           0.0                           0.0   \n",
       "\n",
       "       ERC20 uniq sent token name   ERC20 uniq rec token name  \n",
       "9836                     -0.21489               -1.771125e-01  \n",
       "9837                     -0.21489               -2.397701e-01  \n",
       "9838                     -0.21489                1.086008e-02  \n",
       "9839                      0.00000                5.565108e-17  \n",
       "9840                     -0.21489                2.329189e+00  \n",
       "\n",
       "[5 rows x 45 columns]"
      ]
     },
     "execution_count": 321,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfCopy.iloc[:, 2:47].tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 322,
   "id": "708e8a21",
   "metadata": {},
   "outputs": [],
   "source": [
    "X = dfCopy.iloc[:, 2:46]\n",
    "y = dfCopy.iloc[:, 1]\n",
    "X_train, X_test, y_train, y_test = train_test_split(X, y, test_size=0.3, random_state=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 323,
   "id": "09052457",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([1, 0, 0, ..., 0, 0, 0], dtype=int64)"
      ]
     },
     "execution_count": 323,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "clf = rdc(n_estimators = 100)\n",
    "clf = clf.fit(X_train,y_train)\n",
    "# clf = DecisionTreeClassifier(criterion=\"entropy\")\n",
    "# clf = clf.fit(X_train,y_train)\n",
    "\n",
    "#For Logistic Regression the Precision, Accuracy, and Recall was of 0.85, 0.84, and 0.36 respectively\n",
    "# clf = lg(random_state=0,  max_iter=1000).fit(X_train, y_train)\n",
    "\n",
    "y_pred = clf.predict(X_test)\n",
    "y_pred"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e7e47424",
   "metadata": {},
   "source": [
    "# Evaluating the model"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 324,
   "id": "02e026b0",
   "metadata": {},
   "outputs": [],
   "source": [
    "confusion_matrix = metrics.confusion_matrix(y_test, y_pred)\n",
    "cm_display = metrics.ConfusionMatrixDisplay(confusion_matrix = confusion_matrix, display_labels = [False, True]) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 325,
   "id": "667ffa17",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<sklearn.metrics._plot.confusion_matrix.ConfusionMatrixDisplay at 0x1c01947f0d0>"
      ]
     },
     "execution_count": 325,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAVEAAAEGCAYAAADc/aYNAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/NK7nSAAAACXBIWXMAAAsTAAALEwEAmpwYAAAc80lEQVR4nO3deZgV1bnv8e+PUWZoEIJAwIEYSK4iEsdIHIigSa7R5DrEXE2OCSZi4jkxydHEG425ej05R70mxyGY8IgnxinGqIkRkAyIERUNIs44oCLazMogNN3v+aOqcdPQ3bv37t21d/fv8zz1dO21V1W9u/fTb69Vq2qVIgIzMytMp6wDMDOrZE6iZmZFcBI1MyuCk6iZWRGcRM3MitAl6wBKYVBV5xg1omvWYVgLvLi4Z9YhWAu9x9pVEbF7MfuYfFSvWL2mNq+6TyzeMisiphRzvFJol0l01IiuPDZrRNZhWAtM3mNc1iFYCz0Yv11W7D5Wranl0VnD86rbdejLg4o9Xim0yyRqZpUiqI26rIMoipOomWUmgDoq+4YfJ1Ezy1QdbomamRUkCGrcnTczK0wAte7Om5kVzudEzcwKFEBthc8k5yRqZpmq7DOiTqJmlqEgfE7UzKxQEVBT2TnUSdTMsiRqUdZBFMVJ1MwyE0CdW6JmZoVzS9TMrEDJxfZOomZmBQmgJip7bngnUTPLTCBqK/wBG06iZpapunB33sysID4namZWFFHrc6JmZoVJZrZ3EjUzK0iE2Bqdsw6jKE6iZpapOp8TNTMrTDKwVNnd+cqO3swqXDKwlM/S5F6kEZL+IulZSc9IOi8tr5I0R9JL6c8Babkk/UzSUkmLJY3P2deZaf2XJJ3Z3CdwEjWzzNQPLOWzNGMbcH5EjAUOAaZJGgtcAMyNiNHA3PQ1wHHA6HSZClwPSdIFLgYOBg4CLq5PvI1xEjWzTNWG8lqaEhErIuLJdP094DlgGHACMDOtNhP4fLp+AnBzJBYA/SUNBSYDcyJiTUSsBeYAU5o6ts+JmllmAlETrZuGJI0CDgAeBYZExIr0rbeBIen6MOCNnM3eTMsaK2+Uk6iZZaaFA0uDJC3MeT09IqbnVpDUG7gL+OeIeFf6oAUbESGp1WcvdRI1s8wEzXfVc6yKiAmNvSmpK0kCvSUifpcWvyNpaESsSLvr1Wn5cmBEzubD07LlwJENyv/aVFA+J2pmmWqNgSUlTc5fAc9FxFU5b90L1I+wnwnck1N+RjpKfwiwPu32zwKOlTQgHVA6Ni1rlFuiZpaZCFrr3vnDgf8NPC1pUVr2A+AK4A5JZwHLgJPT9+4HjgeWApuArybxxBpJPwEeT+tdGhFrmjqwk6iZZSYZWCr+ts+ImA+N3vp0zC7qBzCtkX3NAGbke2wnUTPLVKXfseQkamaZCeRJmc3MiuGWqJlZgZLnzjuJmpkVSH48iJlZoZJHJntSZjOzgkTI3Xkzs2L4QXVmZgVK5hP1OVEzswL5kclmZgVLLnFyS9TMrCCtde98lpxEzSxTeTw/qaw5iZpZZpKp8NydNzMrmM+JmpkVKJnFyd15M7OCJLd9OolaEaqXd+Xfz/sw61Z2BQXHf3k1J35tFTdeugcL5vSla7dg6MgtnH/1G/TuV0vNVnHN94fz0uKeqBN889Ll7H/YBgBqtoprfziMxY/0RoKvXLCCIz6zPuNP2HF856rXOXjSe6xb1YWzj94XgD79t/GDG5YxZPhW3nmzG5edPZIN6/1n94HKb4mWLHpJtZIW5Syjmqi7oVRxlLvOXYKpP3qLG//2PNf84SXuu2kQy17szviJ7zH9L89zw9wXGLbXFm77+WAA/nTLQAB+8ecXuOK2l5n+4z2oq0v2des1Q+g/aBsz5j/PjX97nv0O6bC/1kzMvr2KH56+5w5lJ59bzT/m9+afPjmGf8zvzSnnVjeydcdVh/JaylUp/wVsjohxOctrJTxWxRo4ZBuj99sMQM/edYzYZwurVnTlwCPfo3PaYBlz4CZWregKwOsvdmfcJ5Pk2H/QNnr3q+XFp3oCMOu2Kk79VvJH2qkT9BtY28afpmNb8mhv3lu7Yyvz0Mnv8uAdVQA8eEcVh055N4vQylb96Hw+S7lqs3a0pN6S5kp6UtLTkk7YRZ2hkualLdclko5Iy4+V9Ei67Z2SerdV3G3p7Te68fKSHnx0/KYdymfdWsUnjn4PgL0+9j4LZvejdhu8/Xo3Xlrck5VvdWXD+uSC5Zk//RDTjv0I/3fqKNaudLcxawMG1bCmOvkHuKa6CwMG1WQcUfmpi055LeWqlJH1yOnK3w28D5wYEeOBo4Ar02dF5/oSMCsixgH7A4skDQIuAial2y4EvtPwYJKmSlooaeHK1ZXXAtu8sRM/+doovnHpcnr1qdte/ptrhtC5S3D0SWsBmHzqagYN3cq5U/bl+h8NY+yEjXTuBLXbYNWKboydsJFrZ7/ImAM3cuOle2T1cWyXRJRxiyoL9c9YymcpV6VsqmxOkyEAkroCl0uaCNQBw4AhwNs52zwOzEjr/j4iFkn6FDAWeDjNud2ARxoeLCKmA9MBJuy/W5TkE5XIthr4yddGcfRJa/nk8R8MBM2+vYrHHuzLFbcvpf7fTecu8I0fv7W9zj9/bjTD9n6fvlW1dO9Ry+Hp9kd8dh0P3FrVpp/DdrZ2VVeqBiet0arBNaxb7d5BrgC2lXErMx9tGf3pwO7AgWlyfQfYLbdCRMwDJgLLgZsknUHyLOk5OedWx0bEWW0Yd0lFwFXnf5gRo7fwhbNXbi9//C99uPO6wVxy0yvs1vOD/wnvbxLvb0q+tif+1pvOXYKRH9mCBId8+l0W/z0507Fofh9GfmRL234Y28mC2X2ZdPIaACadvIZHZvXNOKLyU+nd+bb8t9gPqI6IGklHASMbVpA0EngzIm6U1B0YD1wGXCtpn4hYKqkXMCwiXmzD2Evmmcd6Mfe3Vew5ZjPfnJRcFvPVC9/iuv8znJot4sJT9gHgowdu5Lx/e5N1q7vyw9P2Qp1g4Idq+P7Pl23f11kXvcVPvzWSGy7uTL+B2zj/qtcz+Uwd1QXXLWO/QzfQr2obv174LP915RBu/8/B/PCGZUw5dQ3Vy5NLnCxHmXfV89GWSfQW4D5JT5Oc13x+F3WOBL4nqQbYAJwRESslfQW4NU2skJwjbRdJ9OMHb2TWW4t2Kj/omOd2Wf9DI7byq/m7+tXBkOE1XHn30tYMz1rginN2nSAvOGXvNo6kcnhS5iZERO8Gr1cBhzZVNyJmAjN38f6fgU+UIEwzy5hbomZmBfKkzGZmRQjEtrryHTTKh5OomWXK50TNzAoV7s6bmRXM50TNzIrkJGpmVqBA1HpgycyscB5YMjMrUHhgycysOJU+PaCTqJllyBOQmJkVpdJbopU9LGZmFS0CauuU19IcSTMkVUtaklN2iaTlOU/ZOD7nvQslLZX0gqTJOeVT0rKlki5o7rhOomaWqVZ82udNwJRdlF+dM6n7/QCSxgKnAh9Lt7lOUmdJnYFrgeNInqhxWlq3Ue7Om1lmgtbrzkfEvKYezd7ACcBtEbEFeFXSUuCg9L2lEfEKgKTb0rrPNrYjt0TNLEMtelDdoPqHUabL1DwPcq6kxWl3f0BaNgx4I6fOm2lZY+WNchI1s0xF5LcAqyJiQs4yPY/dXw/sDYwDVgBXtnb87s6bWaZKOTofEe/Ur0u6EfhD+nI5MCKn6vC0jCbKd8ktUTPLTDI63ymvpRCShua8PBGoH7m/FzhVUndJewKjgcdIHts+WtKekrqRDD7d29Qx3BI1s0xFNF8nH5JuJXnY5SBJbwIXA0dKGkcyhvUacHZyzHhG0h0kA0bbgGkRUZvu51xgFtAZmBERzzR1XCdRM8tUK47On7aL4l81Uf8ykkeyNyy/H7g/3+M6iZpZZgJV/B1LTqJmlqlW6s1nxknUzLITEHnc0lnOnETNLFPuzpuZFaG1Ruez0mgSlfRzmjhdERHfLklEZtZhtOa981lpqiW6sM2iMLOOKYD2mkQjYmbua0k9I2JT6UMys46k0rvzzd5LJelQSc8Cz6ev95d0XckjM7MOQERdfku5yueG1P8PTAZWA0TEU8DEEsZkZh1J5LmUqbxG5yPiDWmH/wS1pQnHzDqUaN8DS/XekHQYEJK6AucBz5U2LDPrMMq4lZmPfLrz3wCmkczu/BbJ5KbTShiTmXUoynMpT822RCNiFXB6G8RiZh1RXdYBFCef0fm9JN0naWX6ONJ7JO3VFsGZWTtXf51oPkuZyqc7/xvgDmAosAdwJ3BrKYMys46jBc9YKkv5JNGeEfFfEbEtXX4N7FbqwMysg2ivlzhJqkpX/yTpAuA2ko9yCi2Y9dnMrEll3FXPR1MDS0+QJM36T3h2znsBXFiqoMys41AZtzLz0dS983u2ZSBm1gGFoIxv6cxHXncsSfo4MJacc6ERcXOpgjKzDqS9tkTrSbqY5DGkY0nOhR4HzAecRM2seBWeRPMZnf8icAzwdkR8Fdgf6FfSqMys42ivo/M5NkdEnaRtkvoC1cCIEsdlZh1Be56UOcdCSf2BG0lG7DcAj5QyKDPrONrt6Hy9iDgnXb1B0gNA34hYXNqwzKzDaK9JVNL4pt6LiCdLE5KZdSTtuSV6ZRPvBXB0K8fSal58uhdTRh6UdRjWAptOOiDrEKyl7vpt6+ynvZ4TjYij2jIQM+uAynzkPR95XWxvZlYyTqJmZoVThU/K7CRqZtmq8JZoPjPbS9KXJf0off1hSR61MbOiKfJfylU+t31eBxwKnJa+fg+4tmQRmVnHUuGPB8mnO39wRIyX9A+AiFgrqVuJ4zKzjqKMW5n5yCeJ1kjqTPpRJe1OxT+fz8zKRTl31fORTxL9GXA3MFjSZSSzOl1U0qjMrGOIDjA6HxG3SHqCZDo8AZ+PiOdKHpmZdQwV3hLNZ3T+w8Am4D7gXmBjWmZmVrxWmk9U0gxJ1ZKW5JRVSZoj6aX054C0XJJ+JmmppMW5c4VIOjOt/5KkM5s7bj6j838E/pD+nAu8Avwpj+3MzJrVipc43QRMaVB2ATA3IkaT5K8L0vLjgNHpMhW4HrY/5fhi4GDgIODi+sTbmGaTaET8j4jYL/05Ot2x5xM1s7ISEfOANQ2KTwBmpuszgc/nlN8ciQVAf0lDgcnAnIhYExFrgTnsnJh30OI7liLiSUkHt3Q7M7NdKu050SERsSJdfxsYkq4PA97IqfdmWtZYeaPyeVDdd3JedgLGA281t52ZWbNaNjo/SNLCnNfTI2J63oeKCKn1L6jKpyXaJ2d9G8m50btaOxAz66DyT2urImJCC/f+jqShEbEi7a5Xp+XL2fFZccPTsuUkTzfOLf9rUwdoMommF9n3iYjvtixuM7PmiZJfbH8vcCZwRfrznpzycyXdRjKItD5NtLOAy3MGk44FLmzqAE09HqRLRGyTdHiRH8LMrHGtlEQl3UrSihwk6U2SUfYrgDsknQUsA05Oq98PHA8sJbmE86sAEbFG0k+Ax9N6l0ZEw8GqHTTVEn2M5PznIkn3AncCG+vfjIjfteQDmpntpBVnaIqI0xp565hd1A1gWiP7mQHMyPe4+ZwT3Q1YTfJMpSBpgQfgJGpmxWvHt30OTkfml/BB8qxX4TdqmVm5aM8TkHQGerNj8qxX4R/bzMpGhWeTppLoioi4tM0iMbOOp50/7bN8p5I2s3ajPXfndxrRMjNrde01iTZ3bZSZWWto95Mym5mVTDs/J2pmVlKi8gdfnETNLFtuiZqZFa49j86bmZWek6iZWYE6wiOTzcxKyi1RM7PC+ZyomVkxnETNzArnlqiZWaGCdj0ps5lZSbXBg+pKzknUzLLlJGpmVjhFZWdRJ1Ezy45ncTIzK47PiZqZFcG3fZqZFcMtUTOzAoW782ZmxXESNTMrjC+2NzMrkuoqO4s6iZpZdnydqJXSzPlPsWljZ+pqobZWfPtzH6N3v2384NqXGTJ8C++82Z3Lz9mbDe/6a8zSHT/+DZu2dKWurhO1deLrPz2JvYet5runPkSP7jW8vboPl848mk3vd+PTE17itEmLt2+79x6rOevfTmLp8kEZfoJs+RKnPEgaCMxNX34IqAVWpq8PioitbRFHJfrXU/fl3bVdt78+5ZwVLHq4L3dcP5STv7mCk89ZwYwrRmQYoQGcd83nWL9xt+2v//VL87ju7oNZtHQPjj/keU475il+9cdPMGfhaOYsHA3AXnus4fKvz+rQCRSo+JZop7Y4SESsjohxETEOuAG4uv51RGyV5KZUng799DoevGsgAA/eNZDDjl2XbUC2SyMGr2PR0qEALHx+OEeOe3WnOpMOXMrcJ/du69DKjiK/pVxllrwk3QS8DxwAPCzpXWBDRPxH+v4S4LMR8ZqkLwPfBroBjwLnRERtNpG3nQAu//WLRMD9t+zOn24dTP9BNayp7gbAmuqu9B9Uk22QRoS46tw/EiHueXgM9z08hldXVHHEfst4aPEojhr/CoMHbNxpu6PHv8yF0ydnEHEZCcATkBRlOHBYRNRKumRXFSSNAU4BDo+IGknXAacDNzeoNxWYCrAbPUsadFs5/wtjWP1ON/oNrOH//foF3ni5R4MaqvSeULsw7er/yar1vejfezNXn/tHXn+7P1fc8inO++LDnDnlSeY/PZKa2h07fWNHVvN+TRdeXVGVUdTlw+dEi3NnHi3KY4ADgcclAfQAqhtWiojpwHSAvp0GtovcsvqdpMW5fnVX/j5rAPuO28C6VV2pGryVNdXdqBq8lfWrujazFyu1Vet7AbBuQw/mLR7FmFHV3DZ3f86/9jNA0rU/9GOv77DNMQcuZe7Cfdo81nLTHq4TbZNzok3I7eNsY8d46s/SC5iZcw5134i4pK0CzEr3HrX06FW7fX38xPW89kJPFjzYn0lfWA3ApC+s5pE5/TOM0nbrVkOP7lu3r3/io8t55a0q+vfeDIAUnDH5H9wzf8z2baTgqPGv8OATPh9KRP5Lmcq6JZrrNeCzAJLGA3um5XOBeyRdHRHVkqqAPhGxLJsw28aAQTX8aPpSADp3Cf5yz0Ce+Fs/XnyqFz+4bimTT1lJ9fLuXHaO/xCzNKDPZi7/+mwAOncO5izcm8eeG8EXj3yakyY+C8DfFo3i/gX7bt9m/31WUL22NytW980k5nJT6S1RRRtn+PTc5wbg48AfIuK3aXkP4B5gGMng0aHAcenA0inAhSQt1RpgWkQsaOwYfTsNjEO6Tinp57DWtfFzB2QdgrXQ3+/63hMRMaGYffTpPzwOmHheXnUfuu/7RR+vFNq8JdpYVzwiNgPHNvLe7cDtJQzLzDLSWi1RSa8B75Fch74tIiakPdfbgVEkvd2TI2KtkgGWa4DjgU3AVyLiyUKOm/U5UTPryAKojfyW/ByVjp3Ut1gvAOZGxGiSU4MXpOXHAaPTZSpwfaEfwUnUzDJV4ovtTwBmpuszgc/nlN8ciQVAf0lDCzmAk6iZZSv/0flBkhbmLFMb7gmYLemJnPeGRMSKdP1tYEi6Pgx4I2fbN9OyFiun0Xkz64Ba0Mpc1czA0icjYrmkwcAcSc/nvhkRIbX+tQBuiZpZdqIFS3O7ilie/qwG7gYOAt6p76anP+tv1FkO5M7cMzwtazEnUTPLjADVRl5Lk/uReknqU79OcqXPEuBe4My02pkkl1GSlp+hxCHA+pxuf4u4O29mmVLrXKs+BLg7vTW8C/CbiHhA0uPAHZLOApYBJ6f17ye5vGkpySVOXy30wE6iZpadVprZPiJeAfbfRflqkvk3GpYHMK34IzuJmlmmyvu++Hw4iZpZpir93nknUTPLlluiZmYFCpodeS93TqJmlq3KzqFOomaWrVa6xCkzTqJmli0nUTOzAgXgB9WZmRVGhLvzZmZFqavspqiTqJllx915M7PiuDtvZlYMJ1Ezs0J5AhIzs8LVP+2zgjmJmlmmfE7UzKwYTqJmZgUKoM5J1MysQB5YMjMrjpOomVmBAqit7FuWnETNLEMB4SRqZlY4d+fNzArk0XkzsyK5JWpmVgQnUTOzAkVAbW3WURTFSdTMsuWWqJlZEZxEzcwKFR6dNzMrWED4YnszsyL4tk8zswJF+JHJZmZF8cCSmVnhwi1RM7NCeVJmM7PCeQISM7PCBRC+7dPMrEDhSZnNzIoS7s6bmRWhwluiigofGdsVSSuBZVnHUSKDgFVZB2Et0l6/s5ERsXsxO5D0AMnvJx+rImJKMccrhXaZRNszSQsjYkLWcVj+/J21b52yDsDMrJI5iZqZFcFJtPJMzzoAazF/Z+2Yz4mamRXBLVEzsyI4iZqZFcEX22dMUi3wdE7R5yPitUbqboiI3m0SmDVJ0kBgbvryQ0AtsDJ9fVBEbM0kMGtzPieasZYkRifR8iTpEmBDRPxHTlmXiNiWXVTWVtydLzOSekuaK+lJSU9LOmEXdYZKmidpkaQlko5Iy4+V9Ei67Z2SnHDbkKSbJN0g6VHgp5IukfTdnPeXSBqVrn9Z0mPpd/gLSZ2zituK4ySavR7pH9IiSXcD7wMnRsR44CjgSklqsM2XgFkRMQ7YH1gkaRBwETAp3XYh8J02+xRWbzhwWEQ0+ruXNAY4BTg8/Q5rgdPbJjxrbT4nmr3N6R8SAJK6ApdLmgjUAcOAIcDbOds8DsxI6/4+IhZJ+hQwFng4zbndgEfa5iNYjjsjorkJMo8BDgQeT7+rHkB1qQOz0nASLT+nA7sDB0ZEjaTXgN1yK0TEvDTJfga4SdJVwFpgTkSc1tYB2w425qxvY8feXv33KGBmRFzYZlFZybg7X376AdVpAj0KGNmwgqSRwDsRcSPwS2A8sAA4XNI+aZ1ekj7ShnHbzl4j+W6QNB7YMy2fC3xR0uD0var0O7UK5JZo+bkFuE/S0yTnNZ/fRZ0jge9JqgE2AGdExEpJXwFuldQ9rXcR8GLpQ7ZG3AWcIekZ4FHS7yIinpV0ETBbUiegBphG+52+sV3zJU5mZkVwd97MrAhOomZmRXASNTMrgpOomVkRnETNzIrgJNpBSarNuff+Tkk9i9jXTZK+mK7/UtLYJuoeKemwAo7xWnpra17lDepsaOGxdrjn3awpTqId1+aIGBcRHwe2At/IfVNSQdcQR8TXIuLZJqocCbQ4iZqVKydRA3gI2CdtJT4k6V7gWUmdJf27pMclLZZ0NoAS/ynpBUkPAoPrdyTpr5ImpOtT0hmlnkpnphpFkqz/JW0FHyFpd0l3pcd4XNLh6bYDJc2W9IykX5LcKtkkSb+X9ES6zdQG712dls+VtHtatrekB9JtHpL00Vb5bVqH4juWOri0xXkc8EBaNB74eES8miai9RHxifQuqIclzQYOAPYlmfBkCPAsMKPBfncHbgQmpvuqiog1km4gZ+5NSb8Bro6I+ZI+DMwCxgAXA/Mj4lJJnwHOyuPj/FN6jB4kk3vcFRGrgV7Awoj4F0k/Svd9LskD5L4RES9JOhi4Dji6gF+jdWBOoh1XD0mL0vWHgF+RdLMfi4hX0/Jjgf3qz3eS3Nc/GpgI3JrOVvSWpD/vYv+HAPPq9xURaxqJYxIwNme2v75K5kGdCJyUbvtHSWvz+EzflnRiuj4ijXU1yWxYt6flvwZ+lx7jMODOnGN3x6yFnEQ7rh2m4ANIk0nuLEQCvhURsxrUO74V4+gEHBIR7+8ilrxJOpIkIR8aEZsk/ZUGs1/liPS46xr+DsxayudErSmzgG+m85Yi6SOSegHzgFPSc6ZDSSaPbmgBMFHSnum2VWn5e0CfnHqzgW/Vv5A0Ll2dRzL5NJKOAwY0E2s/YG2aQD9K0hKu1wmob01/ieQ0wbvAq5L+V3oMSdq/mWOY7cRJ1JryS5LznU9KWgL8gqT3cjfwUvrezexi8ueIWAlMJek6P8UH3en7gBPrB5aAbwMT0oGrZ/ngKoEfkyThZ0i69a83E+sDQBdJzwFXkCTxehuBg9LPcDRwaVp+OnBWGt8zwE6PYjFrjmdxMjMrgluiZmZFcBI1MyuCk6iZWRGcRM3MiuAkamZWBCdRM7MiOImamRXhvwEVzi0Rk+qUAQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 2 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "cm_display.plot()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 326,
   "id": "6c6256da",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Accuracy of Decision Tree:  0.9796816796478158\n",
      "Precision of Decision Tree:  0.9835255354200988\n",
      "Recall of Decision Tree:  0.9227202472952086\n"
     ]
    }
   ],
   "source": [
    "accuracy_score = metrics.accuracy_score(y_test, y_pred)\n",
    "precision_score = metrics.precision_score(y_test, y_pred)\n",
    "recall_score = metrics.recall_score(y_test, y_pred)\n",
    "print(\"Accuracy of Decision Tree: \", accuracy_score)\n",
    "print(\"Precision of Decision Tree: \", precision_score)\n",
    "print(\"Recall of Decision Tree: \", recall_score)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e6c4a7b3",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.10.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}