GraphicalAnalysis.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "cb8cb1cb",
   "metadata": {},
   "source": [
    "### Visual Analysis of the transaction logs to detect fraud detection.\n",
    "** Networkx and pyvis Network modules are used to analyse the data graphically."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "06b17ed2",
   "metadata": {},
   "outputs": [],
   "source": [
    "#import required libraries\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import networkx as nx\n",
    "from pyvis.network import Network\n",
    "plt.rcParams[\"figure.figsize\"] = (20,10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "aab51d50",
   "metadata": {
    "scrolled": false
   },
   "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>gT</th>\n",
       "      <th>sId</th>\n",
       "      <th>rId</th>\n",
       "      <th>sAcc</th>\n",
       "      <th>rAcc</th>\n",
       "      <th>TranAmount</th>\n",
       "      <th>TranType</th>\n",
       "      <th>TranStatus</th>\n",
       "      <th>sBalbefore</th>\n",
       "      <th>sBalAfter</th>\n",
       "      <th>rBalBefore</th>\n",
       "      <th>rBalAfter</th>\n",
       "      <th>sf1</th>\n",
       "      <th>sf2</th>\n",
       "      <th>sTD</th>\n",
       "      <th>rTD</th>\n",
       "      <th>TranTS</th>\n",
       "      <th>sType</th>\n",
       "      <th>rType</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>N-RegDep</td>\n",
       "      <td>PN_Ret2</td>\n",
       "      <td>PN_EU_0_261</td>\n",
       "      <td>RAcc2</td>\n",
       "      <td>EUAcc0_261</td>\n",
       "      <td>131926.49</td>\n",
       "      <td>Dt</td>\n",
       "      <td>SU</td>\n",
       "      <td>1.000000e+09</td>\n",
       "      <td>9.998681e+08</td>\n",
       "      <td>1.001319e+08</td>\n",
       "      <td>1.000000e+08</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>1/6/2011 0:11:22</td>\n",
       "      <td>1/6/2011 0:11:22</td>\n",
       "      <td>1/6/2011 0:11:22</td>\n",
       "      <td>RET</td>\n",
       "      <td>EU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>N_Reg_RC</td>\n",
       "      <td>PN_EU_1_502</td>\n",
       "      <td>operator</td>\n",
       "      <td>EUAcc1_502</td>\n",
       "      <td>A0</td>\n",
       "      <td>2054.46</td>\n",
       "      <td>ArRC</td>\n",
       "      <td>SU</td>\n",
       "      <td>1.000000e+08</td>\n",
       "      <td>9.999795e+07</td>\n",
       "      <td>9.918004e+07</td>\n",
       "      <td>9.917798e+07</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>1/6/2011 0:16:8</td>\n",
       "      <td>1/6/2011 0:16:8</td>\n",
       "      <td>1/6/2011 0:16:8</td>\n",
       "      <td>EU</td>\n",
       "      <td>operator</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>N-RegDep</td>\n",
       "      <td>PN_Ret2</td>\n",
       "      <td>PN_EU_1_362</td>\n",
       "      <td>RAcc2</td>\n",
       "      <td>EUAcc1_362</td>\n",
       "      <td>182548.74</td>\n",
       "      <td>Dt</td>\n",
       "      <td>SU</td>\n",
       "      <td>9.998681e+08</td>\n",
       "      <td>9.996855e+08</td>\n",
       "      <td>1.001825e+08</td>\n",
       "      <td>1.000000e+08</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>1/6/2011 0:36:47</td>\n",
       "      <td>1/6/2011 0:36:47</td>\n",
       "      <td>1/6/2011 0:36:47</td>\n",
       "      <td>RET</td>\n",
       "      <td>EU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>N_Reg_RC</td>\n",
       "      <td>PN_EU_1_26</td>\n",
       "      <td>operator</td>\n",
       "      <td>EUAcc1_26</td>\n",
       "      <td>A0</td>\n",
       "      <td>5507.28</td>\n",
       "      <td>ArRC</td>\n",
       "      <td>SU</td>\n",
       "      <td>1.000000e+08</td>\n",
       "      <td>9.999449e+07</td>\n",
       "      <td>9.918554e+07</td>\n",
       "      <td>9.918004e+07</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>1/6/2011 0:36:59</td>\n",
       "      <td>1/6/2011 0:36:59</td>\n",
       "      <td>1/6/2011 0:36:59</td>\n",
       "      <td>EU</td>\n",
       "      <td>operator</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>N_Reg_RC</td>\n",
       "      <td>PN_EU_1_18</td>\n",
       "      <td>operator</td>\n",
       "      <td>EUAcc1_18</td>\n",
       "      <td>A0</td>\n",
       "      <td>2102.60</td>\n",
       "      <td>ArRC</td>\n",
       "      <td>SU</td>\n",
       "      <td>1.000000e+08</td>\n",
       "      <td>9.999790e+07</td>\n",
       "      <td>9.918765e+07</td>\n",
       "      <td>9.918554e+07</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>1/6/2011 1:1:26</td>\n",
       "      <td>1/6/2011 1:1:26</td>\n",
       "      <td>1/6/2011 1:1:26</td>\n",
       "      <td>EU</td>\n",
       "      <td>operator</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          gT           sId          rId        sAcc        rAcc  TranAmount  \\\n",
       "0  N-RegDep        PN_Ret2  PN_EU_0_261       RAcc2  EUAcc0_261   131926.49   \n",
       "1  N_Reg_RC    PN_EU_1_502     operator  EUAcc1_502          A0     2054.46   \n",
       "2  N-RegDep        PN_Ret2  PN_EU_1_362       RAcc2  EUAcc1_362   182548.74   \n",
       "3  N_Reg_RC     PN_EU_1_26     operator   EUAcc1_26          A0     5507.28   \n",
       "4  N_Reg_RC     PN_EU_1_18     operator   EUAcc1_18          A0     2102.60   \n",
       "\n",
       "  TranType TranStatus    sBalbefore     sBalAfter    rBalBefore     rBalAfter  \\\n",
       "0       Dt         SU  1.000000e+09  9.998681e+08  1.001319e+08  1.000000e+08   \n",
       "1     ArRC         SU  1.000000e+08  9.999795e+07  9.918004e+07  9.917798e+07   \n",
       "2       Dt         SU  9.998681e+08  9.996855e+08  1.001825e+08  1.000000e+08   \n",
       "3     ArRC         SU  1.000000e+08  9.999449e+07  9.918554e+07  9.918004e+07   \n",
       "4     ArRC         SU  1.000000e+08  9.999790e+07  9.918765e+07  9.918554e+07   \n",
       "\n",
       "    sf1   sf2               sTD               rTD            TranTS sType  \\\n",
       "0  True  True  1/6/2011 0:11:22  1/6/2011 0:11:22  1/6/2011 0:11:22   RET   \n",
       "1  True  True   1/6/2011 0:16:8   1/6/2011 0:16:8   1/6/2011 0:16:8    EU   \n",
       "2  True  True  1/6/2011 0:36:47  1/6/2011 0:36:47  1/6/2011 0:36:47   RET   \n",
       "3  True  True  1/6/2011 0:36:59  1/6/2011 0:36:59  1/6/2011 0:36:59    EU   \n",
       "4  True  True   1/6/2011 1:1:26   1/6/2011 1:1:26   1/6/2011 1:1:26    EU   \n",
       "\n",
       "      rType  \n",
       "0        EU  \n",
       "1  operator  \n",
       "2        EU  \n",
       "3  operator  \n",
       "4  operator  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# load the dataset\n",
    "df=pd.read_csv('processedData1.csv')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a296fa7c",
   "metadata": {},
   "source": [
    "#### Step 1: Visualizing the graph network for all transactions\n",
    "Make separate lists holding senders AccountId, receivers AccountId, Amount of transactions."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "23e35eac",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "No of total senders: 54222\n",
      "No of unique senders: 1864\n",
      "No if unique receivers: 1562\n"
     ]
    }
   ],
   "source": [
    "#pandas series into list\n",
    "senders=list(df['sAcc'])\n",
    "receivers=list(df['rAcc'])\n",
    "Amount=list(df['TranAmount'])\n",
    "l=len(senders)\n",
    "un=df['sAcc'].nunique()\n",
    "un2=df['rAcc'].nunique()\n",
    "\n",
    "print('No of total senders:', l)\n",
    "print('No of unique senders:', un )\n",
    "print('No if unique receivers:', un2)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a8c308d5",
   "metadata": {},
   "source": [
    "#### Now using Network library create a garph and visualize the graph network representing transactions."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "d7eb40cb",
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "#Define a graph visualise it for basic analysis\n",
    "net=Network('1500px', '1500px')\n",
    "G=nx.DiGraph()\n",
    "\n",
    "for i in range(1000): # Considering only 1000 samples just to see the visualization\n",
    "    G.add_edge(senders[i],receivers[i],weight=Amount[i])\n",
    "    # senders and receivers are the nodes, Amount is the edge length.\n",
    "net.from_nx(G)\n",
    "net.show('transactionsViz.html')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8a6b2e07",
   "metadata": {},
   "source": [
    "#### Step 2: Segregate the possible frauds"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "5997045e",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Now create another graph G2 and perform the analysis\n",
    "net2=Network()\n",
    "G2=nx.Graph()\n",
    "for i in range(l): #For all the transactions\n",
    "    G2.add_edge(senders[i],receivers[i],weight=Amount[i])\n",
    "net2.from_nx(G2)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "de499de8",
   "metadata": {},
   "source": [
    "#### get those nodes whose degree is higher, if no of transactions is high it can be a poosible fraud"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "fec3c45f",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'list'>\n",
      "206\n"
     ]
    }
   ],
   "source": [
    "nds=list(G2.nodes()) #list of all nodes\n",
    "print(type(nds))\n",
    "degrees = [val for (node, val) in G2.degree()]\n",
    "l2=len(degrees)  # degree of respective nodes\n",
    "\n",
    "repeated_nodes=[] \n",
    "for i in range(l2):\n",
    "    val=degrees[i]\n",
    "    if val>=10:        # If it has done more than 10 transactions\n",
    "        ind = nds[i]\n",
    "        repeated_nodes.append(ind)\n",
    "print(len(repeated_nodes))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "49a82ba7",
   "metadata": {},
   "source": [
    "#### Select only those rows that appeares in repeated nodes and make a separate dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "bb3341c4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "No of accounts out of fradulent activities: 20014\n"
     ]
    }
   ],
   "source": [
    "sAccount=df['sAcc']  # All sender accouts\n",
    "numSamples=len(sAccount)\n",
    "count=0\n",
    "drop_indices=[] \n",
    "for i in range(numSamples):\n",
    "    acc=sAccount[i]\n",
    "    if acc not in repeated_nodes: \n",
    "        count=count+1\n",
    "        drop_indices.append(i)\n",
    "print('No of accounts out of fradulent activities:',l-count)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "df2ac678",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 20014 entries, 0 to 20013\n",
      "Data columns (total 20 columns):\n",
      " #   Column      Non-Null Count  Dtype  \n",
      "---  ------      --------------  -----  \n",
      " 0   index       20014 non-null  int64  \n",
      " 1   gT          20014 non-null  object \n",
      " 2   sId         20014 non-null  object \n",
      " 3   rId         20014 non-null  object \n",
      " 4   sAcc        20014 non-null  object \n",
      " 5   rAcc        20014 non-null  object \n",
      " 6   TranAmount  20014 non-null  float64\n",
      " 7   TranType    20014 non-null  object \n",
      " 8   TranStatus  20014 non-null  object \n",
      " 9   sBalbefore  20014 non-null  float64\n",
      " 10  sBalAfter   20014 non-null  float64\n",
      " 11  rBalBefore  20014 non-null  float64\n",
      " 12  rBalAfter   20014 non-null  float64\n",
      " 13  sf1         20014 non-null  bool   \n",
      " 14  sf2         20014 non-null  bool   \n",
      " 15  sTD         20014 non-null  object \n",
      " 16  rTD         20014 non-null  object \n",
      " 17  TranTS      20014 non-null  object \n",
      " 18  sType       20014 non-null  object \n",
      " 19  rType       20014 non-null  object \n",
      "dtypes: bool(2), float64(5), int64(1), object(12)\n",
      "memory usage: 2.8+ MB\n"
     ]
    }
   ],
   "source": [
    "# drop the samples that are not in the possible fraud list \n",
    "# and make a new dataframe with only possible fraud transactions.\n",
    "df2=df.drop(drop_indices).reset_index()\n",
    "df2.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7e417cbe",
   "metadata": {},
   "source": [
    "#### Step 3: Segregate the senders/receivers according to the criteria set for fradulent transactions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "f1e8eea9",
   "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>level_0</th>\n",
       "      <th>index</th>\n",
       "      <th>gT</th>\n",
       "      <th>sId</th>\n",
       "      <th>rId</th>\n",
       "      <th>sAcc</th>\n",
       "      <th>rAcc</th>\n",
       "      <th>TranAmount</th>\n",
       "      <th>TranType</th>\n",
       "      <th>TranStatus</th>\n",
       "      <th>...</th>\n",
       "      <th>sBalAfter</th>\n",
       "      <th>rBalBefore</th>\n",
       "      <th>rBalAfter</th>\n",
       "      <th>sf1</th>\n",
       "      <th>sf2</th>\n",
       "      <th>sTD</th>\n",
       "      <th>rTD</th>\n",
       "      <th>TranTS</th>\n",
       "      <th>sType</th>\n",
       "      <th>rType</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>N-RegC2C</td>\n",
       "      <td>PN_EU_2_5</td>\n",
       "      <td>PN_EU_1_121</td>\n",
       "      <td>EUAcc2_5</td>\n",
       "      <td>EUAcc1_121</td>\n",
       "      <td>66197.31</td>\n",
       "      <td>Ind</td>\n",
       "      <td>SU</td>\n",
       "      <td>...</td>\n",
       "      <td>9.993314e+07</td>\n",
       "      <td>1.000662e+08</td>\n",
       "      <td>1.000000e+08</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>1/6/2011 1:17:5</td>\n",
       "      <td>1/6/2011 1:17:5</td>\n",
       "      <td>1/6/2011 1:17:5</td>\n",
       "      <td>EU</td>\n",
       "      <td>EU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>N-RegC2C</td>\n",
       "      <td>PN_EU_1_91</td>\n",
       "      <td>PN_EU_0_213</td>\n",
       "      <td>EUAcc1_91</td>\n",
       "      <td>EUAcc0_213</td>\n",
       "      <td>157137.75</td>\n",
       "      <td>Ind</td>\n",
       "      <td>SU</td>\n",
       "      <td>...</td>\n",
       "      <td>9.984129e+07</td>\n",
       "      <td>1.001571e+08</td>\n",
       "      <td>1.000000e+08</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>1/6/2011 2:1:41</td>\n",
       "      <td>1/6/2011 2:1:41</td>\n",
       "      <td>1/6/2011 2:1:41</td>\n",
       "      <td>EU</td>\n",
       "      <td>EU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>15</td>\n",
       "      <td>37</td>\n",
       "      <td>N-RegC2C</td>\n",
       "      <td>PN_EU_3_10</td>\n",
       "      <td>PN_EU_0_1180</td>\n",
       "      <td>EUAcc3_10</td>\n",
       "      <td>EUAcc0_1180</td>\n",
       "      <td>48162.83</td>\n",
       "      <td>Ind</td>\n",
       "      <td>SU</td>\n",
       "      <td>...</td>\n",
       "      <td>9.995136e+07</td>\n",
       "      <td>1.000482e+08</td>\n",
       "      <td>1.000000e+08</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>1/6/2011 5:18:19</td>\n",
       "      <td>1/6/2011 5:18:19</td>\n",
       "      <td>1/6/2011 5:18:19</td>\n",
       "      <td>EU</td>\n",
       "      <td>EU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>16</td>\n",
       "      <td>41</td>\n",
       "      <td>N-RegC2C</td>\n",
       "      <td>PN_EU_1_138</td>\n",
       "      <td>PN_EU_0_500</td>\n",
       "      <td>EUAcc1_138</td>\n",
       "      <td>EUAcc0_500</td>\n",
       "      <td>7203.14</td>\n",
       "      <td>Ind</td>\n",
       "      <td>SU</td>\n",
       "      <td>...</td>\n",
       "      <td>9.999272e+07</td>\n",
       "      <td>1.000034e+08</td>\n",
       "      <td>9.999623e+07</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>1/6/2011 5:56:6</td>\n",
       "      <td>1/6/2011 5:56:6</td>\n",
       "      <td>1/6/2011 5:56:6</td>\n",
       "      <td>EU</td>\n",
       "      <td>EU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>25</td>\n",
       "      <td>69</td>\n",
       "      <td>N-RegC2C</td>\n",
       "      <td>PN_EU_2_26</td>\n",
       "      <td>PN_EU_0_883</td>\n",
       "      <td>EUAcc2_26</td>\n",
       "      <td>EUAcc0_883</td>\n",
       "      <td>203128.87</td>\n",
       "      <td>Ind</td>\n",
       "      <td>SU</td>\n",
       "      <td>...</td>\n",
       "      <td>9.979484e+07</td>\n",
       "      <td>1.002031e+08</td>\n",
       "      <td>1.000000e+08</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>1/6/2011 9:43:8</td>\n",
       "      <td>1/6/2011 9:43:8</td>\n",
       "      <td>1/6/2011 9:43:8</td>\n",
       "      <td>EU</td>\n",
       "      <td>EU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5715</th>\n",
       "      <td>19994</td>\n",
       "      <td>54153</td>\n",
       "      <td>N-RegC2C</td>\n",
       "      <td>PN_EU_1_371</td>\n",
       "      <td>PN_EU_2_126</td>\n",
       "      <td>EUAcc1_371</td>\n",
       "      <td>EUAcc2_126</td>\n",
       "      <td>3369.15</td>\n",
       "      <td>Ind</td>\n",
       "      <td>SU</td>\n",
       "      <td>...</td>\n",
       "      <td>1.022480e+08</td>\n",
       "      <td>1.029042e+08</td>\n",
       "      <td>1.029008e+08</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>30/9/2011 20:16:29</td>\n",
       "      <td>30/9/2011 20:16:29</td>\n",
       "      <td>30/9/2011 20:16:29</td>\n",
       "      <td>EU</td>\n",
       "      <td>EU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5716</th>\n",
       "      <td>20003</td>\n",
       "      <td>54188</td>\n",
       "      <td>N-RegC2C</td>\n",
       "      <td>PN_EU_1_382</td>\n",
       "      <td>PN_EU_0_405</td>\n",
       "      <td>EUAcc1_382</td>\n",
       "      <td>EUAcc0_405</td>\n",
       "      <td>323.91</td>\n",
       "      <td>Ind</td>\n",
       "      <td>SU</td>\n",
       "      <td>...</td>\n",
       "      <td>9.901628e+07</td>\n",
       "      <td>1.002065e+08</td>\n",
       "      <td>1.002062e+08</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>30/9/2011 22:11:43</td>\n",
       "      <td>30/9/2011 22:11:43</td>\n",
       "      <td>30/9/2011 22:11:43</td>\n",
       "      <td>EU</td>\n",
       "      <td>EU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5717</th>\n",
       "      <td>20006</td>\n",
       "      <td>54204</td>\n",
       "      <td>N_RegWith</td>\n",
       "      <td>PN_EU_3_33</td>\n",
       "      <td>PN_Ret3</td>\n",
       "      <td>EUAcc3_33</td>\n",
       "      <td>RAcc3</td>\n",
       "      <td>231559.46</td>\n",
       "      <td>Wl</td>\n",
       "      <td>SU</td>\n",
       "      <td>...</td>\n",
       "      <td>1.000289e+08</td>\n",
       "      <td>8.619040e+08</td>\n",
       "      <td>8.616712e+08</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>30/9/2011 22:54:3</td>\n",
       "      <td>30/9/2011 22:54:3</td>\n",
       "      <td>30/9/2011 22:54:3</td>\n",
       "      <td>EU</td>\n",
       "      <td>RET</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5718</th>\n",
       "      <td>20007</td>\n",
       "      <td>54205</td>\n",
       "      <td>N-RegC2C</td>\n",
       "      <td>PN_EU_1_368</td>\n",
       "      <td>PN_EU_3_3</td>\n",
       "      <td>EUAcc1_368</td>\n",
       "      <td>EUAcc3_3</td>\n",
       "      <td>226206.39</td>\n",
       "      <td>Ind</td>\n",
       "      <td>SU</td>\n",
       "      <td>...</td>\n",
       "      <td>9.691174e+07</td>\n",
       "      <td>9.849312e+07</td>\n",
       "      <td>9.826692e+07</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>30/9/2011 22:57:3</td>\n",
       "      <td>30/9/2011 22:57:3</td>\n",
       "      <td>30/9/2011 22:57:3</td>\n",
       "      <td>EU</td>\n",
       "      <td>EU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5719</th>\n",
       "      <td>20010</td>\n",
       "      <td>54211</td>\n",
       "      <td>N-RegC2C</td>\n",
       "      <td>PN_EU_1_340</td>\n",
       "      <td>PN_EU_2_134</td>\n",
       "      <td>EUAcc1_340</td>\n",
       "      <td>EUAcc2_134</td>\n",
       "      <td>54725.23</td>\n",
       "      <td>Ind</td>\n",
       "      <td>SU</td>\n",
       "      <td>...</td>\n",
       "      <td>1.001928e+08</td>\n",
       "      <td>1.025615e+08</td>\n",
       "      <td>1.025068e+08</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>30/9/2011 23:6:31</td>\n",
       "      <td>30/9/2011 23:6:31</td>\n",
       "      <td>30/9/2011 23:6:31</td>\n",
       "      <td>EU</td>\n",
       "      <td>EU</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5720 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      level_0  index          gT           sId           rId        sAcc  \\\n",
       "0           3      7   N-RegC2C      PN_EU_2_5   PN_EU_1_121    EUAcc2_5   \n",
       "1           6     11   N-RegC2C     PN_EU_1_91   PN_EU_0_213   EUAcc1_91   \n",
       "2          15     37   N-RegC2C     PN_EU_3_10  PN_EU_0_1180   EUAcc3_10   \n",
       "3          16     41   N-RegC2C    PN_EU_1_138   PN_EU_0_500  EUAcc1_138   \n",
       "4          25     69   N-RegC2C     PN_EU_2_26   PN_EU_0_883   EUAcc2_26   \n",
       "...       ...    ...         ...           ...           ...         ...   \n",
       "5715    19994  54153   N-RegC2C    PN_EU_1_371   PN_EU_2_126  EUAcc1_371   \n",
       "5716    20003  54188   N-RegC2C    PN_EU_1_382   PN_EU_0_405  EUAcc1_382   \n",
       "5717    20006  54204  N_RegWith     PN_EU_3_33       PN_Ret3   EUAcc3_33   \n",
       "5718    20007  54205   N-RegC2C    PN_EU_1_368     PN_EU_3_3  EUAcc1_368   \n",
       "5719    20010  54211   N-RegC2C    PN_EU_1_340   PN_EU_2_134  EUAcc1_340   \n",
       "\n",
       "             rAcc  TranAmount TranType TranStatus  ...     sBalAfter  \\\n",
       "0      EUAcc1_121    66197.31      Ind         SU  ...  9.993314e+07   \n",
       "1      EUAcc0_213   157137.75      Ind         SU  ...  9.984129e+07   \n",
       "2     EUAcc0_1180    48162.83      Ind         SU  ...  9.995136e+07   \n",
       "3      EUAcc0_500     7203.14      Ind         SU  ...  9.999272e+07   \n",
       "4      EUAcc0_883   203128.87      Ind         SU  ...  9.979484e+07   \n",
       "...           ...         ...      ...        ...  ...           ...   \n",
       "5715   EUAcc2_126     3369.15      Ind         SU  ...  1.022480e+08   \n",
       "5716   EUAcc0_405      323.91      Ind         SU  ...  9.901628e+07   \n",
       "5717        RAcc3   231559.46       Wl         SU  ...  1.000289e+08   \n",
       "5718     EUAcc3_3   226206.39      Ind         SU  ...  9.691174e+07   \n",
       "5719   EUAcc2_134    54725.23      Ind         SU  ...  1.001928e+08   \n",
       "\n",
       "        rBalBefore     rBalAfter   sf1   sf2                 sTD  \\\n",
       "0     1.000662e+08  1.000000e+08  True  True     1/6/2011 1:17:5   \n",
       "1     1.001571e+08  1.000000e+08  True  True     1/6/2011 2:1:41   \n",
       "2     1.000482e+08  1.000000e+08  True  True    1/6/2011 5:18:19   \n",
       "3     1.000034e+08  9.999623e+07  True  True     1/6/2011 5:56:6   \n",
       "4     1.002031e+08  1.000000e+08  True  True     1/6/2011 9:43:8   \n",
       "...            ...           ...   ...   ...                 ...   \n",
       "5715  1.029042e+08  1.029008e+08  True  True  30/9/2011 20:16:29   \n",
       "5716  1.002065e+08  1.002062e+08  True  True  30/9/2011 22:11:43   \n",
       "5717  8.619040e+08  8.616712e+08  True  True   30/9/2011 22:54:3   \n",
       "5718  9.849312e+07  9.826692e+07  True  True   30/9/2011 22:57:3   \n",
       "5719  1.025615e+08  1.025068e+08  True  True   30/9/2011 23:6:31   \n",
       "\n",
       "                     rTD              TranTS sType rType  \n",
       "0        1/6/2011 1:17:5     1/6/2011 1:17:5    EU    EU  \n",
       "1        1/6/2011 2:1:41     1/6/2011 2:1:41    EU    EU  \n",
       "2       1/6/2011 5:18:19    1/6/2011 5:18:19    EU    EU  \n",
       "3        1/6/2011 5:56:6     1/6/2011 5:56:6    EU    EU  \n",
       "4        1/6/2011 9:43:8     1/6/2011 9:43:8    EU    EU  \n",
       "...                  ...                 ...   ...   ...  \n",
       "5715  30/9/2011 20:16:29  30/9/2011 20:16:29    EU    EU  \n",
       "5716  30/9/2011 22:11:43  30/9/2011 22:11:43    EU    EU  \n",
       "5717   30/9/2011 22:54:3   30/9/2011 22:54:3    EU   RET  \n",
       "5718   30/9/2011 22:57:3   30/9/2011 22:57:3    EU    EU  \n",
       "5719   30/9/2011 23:6:31   30/9/2011 23:6:31    EU    EU  \n",
       "\n",
       "[5720 rows x 21 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Find out the transactions type 'Individual' or 'Withdrawl Type'\n",
    "tType=df2['TranType']\n",
    "dind2=[]\n",
    "for i in range(len(tType)):\n",
    "    el=tType[i]  # Transaction type of the particular transaction\n",
    "    if el=='ArRC' or el=='Dt':  #If not 'Ind' or 'Wl' then drop it.\n",
    "        dind2.append(i)\n",
    "df3=df2.drop(dind2).reset_index()\n",
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "a74defd4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Average: 77041.1407290211\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "2106"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Now find out the transaction with lower than average transaction Amount\n",
    "tAmt=df3['TranAmount']\n",
    "l3=len(tAmt)\n",
    "avg=np.mean(tAmt)\n",
    "print('Average:',avg)\n",
    "dind3=[]\n",
    "#remove all those that have transaction amount higher than average\n",
    "for i in range(l3):\n",
    "    amount=tAmt[i]\n",
    "    if amount>=avg:\n",
    "        dind3.append(i)\n",
    "len(dind3)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e47bd75b",
   "metadata": {},
   "source": [
    "#### Drop all other samples that are not showing any criteria for fraud transactions "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "6483e561",
   "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>level_0</th>\n",
       "      <th>index</th>\n",
       "      <th>gT</th>\n",
       "      <th>sId</th>\n",
       "      <th>rId</th>\n",
       "      <th>sAcc</th>\n",
       "      <th>rAcc</th>\n",
       "      <th>TranAmount</th>\n",
       "      <th>TranType</th>\n",
       "      <th>TranStatus</th>\n",
       "      <th>...</th>\n",
       "      <th>sBalAfter</th>\n",
       "      <th>rBalBefore</th>\n",
       "      <th>rBalAfter</th>\n",
       "      <th>sf1</th>\n",
       "      <th>sf2</th>\n",
       "      <th>sTD</th>\n",
       "      <th>rTD</th>\n",
       "      <th>TranTS</th>\n",
       "      <th>sType</th>\n",
       "      <th>rType</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>N-RegC2C</td>\n",
       "      <td>PN_EU_2_5</td>\n",
       "      <td>PN_EU_1_121</td>\n",
       "      <td>EUAcc2_5</td>\n",
       "      <td>EUAcc1_121</td>\n",
       "      <td>66197.31</td>\n",
       "      <td>Ind</td>\n",
       "      <td>SU</td>\n",
       "      <td>...</td>\n",
       "      <td>9.993314e+07</td>\n",
       "      <td>1.000662e+08</td>\n",
       "      <td>1.000000e+08</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>1/6/2011 1:17:5</td>\n",
       "      <td>1/6/2011 1:17:5</td>\n",
       "      <td>1/6/2011 1:17:5</td>\n",
       "      <td>EU</td>\n",
       "      <td>EU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>15</td>\n",
       "      <td>37</td>\n",
       "      <td>N-RegC2C</td>\n",
       "      <td>PN_EU_3_10</td>\n",
       "      <td>PN_EU_0_1180</td>\n",
       "      <td>EUAcc3_10</td>\n",
       "      <td>EUAcc0_1180</td>\n",
       "      <td>48162.83</td>\n",
       "      <td>Ind</td>\n",
       "      <td>SU</td>\n",
       "      <td>...</td>\n",
       "      <td>9.995136e+07</td>\n",
       "      <td>1.000482e+08</td>\n",
       "      <td>1.000000e+08</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>1/6/2011 5:18:19</td>\n",
       "      <td>1/6/2011 5:18:19</td>\n",
       "      <td>1/6/2011 5:18:19</td>\n",
       "      <td>EU</td>\n",
       "      <td>EU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>16</td>\n",
       "      <td>41</td>\n",
       "      <td>N-RegC2C</td>\n",
       "      <td>PN_EU_1_138</td>\n",
       "      <td>PN_EU_0_500</td>\n",
       "      <td>EUAcc1_138</td>\n",
       "      <td>EUAcc0_500</td>\n",
       "      <td>7203.14</td>\n",
       "      <td>Ind</td>\n",
       "      <td>SU</td>\n",
       "      <td>...</td>\n",
       "      <td>9.999272e+07</td>\n",
       "      <td>1.000034e+08</td>\n",
       "      <td>9.999623e+07</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>1/6/2011 5:56:6</td>\n",
       "      <td>1/6/2011 5:56:6</td>\n",
       "      <td>1/6/2011 5:56:6</td>\n",
       "      <td>EU</td>\n",
       "      <td>EU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>28</td>\n",
       "      <td>77</td>\n",
       "      <td>N-RegC2C</td>\n",
       "      <td>PN_EU_1_112</td>\n",
       "      <td>PN_EU_0_397</td>\n",
       "      <td>EUAcc1_112</td>\n",
       "      <td>EUAcc0_397</td>\n",
       "      <td>66492.79</td>\n",
       "      <td>Ind</td>\n",
       "      <td>SU</td>\n",
       "      <td>...</td>\n",
       "      <td>9.993284e+07</td>\n",
       "      <td>1.000665e+08</td>\n",
       "      <td>1.000000e+08</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>1/6/2011 11:5:51</td>\n",
       "      <td>1/6/2011 11:5:51</td>\n",
       "      <td>1/6/2011 11:5:51</td>\n",
       "      <td>EU</td>\n",
       "      <td>EU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>31</td>\n",
       "      <td>80</td>\n",
       "      <td>N-RegC2C</td>\n",
       "      <td>PN_EU_2_105</td>\n",
       "      <td>PN_EU_1_494</td>\n",
       "      <td>EUAcc2_105</td>\n",
       "      <td>EUAcc1_494</td>\n",
       "      <td>47020.50</td>\n",
       "      <td>Ind</td>\n",
       "      <td>SU</td>\n",
       "      <td>...</td>\n",
       "      <td>9.995251e+07</td>\n",
       "      <td>1.000470e+08</td>\n",
       "      <td>1.000000e+08</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>1/6/2011 11:19:0</td>\n",
       "      <td>1/6/2011 11:19:0</td>\n",
       "      <td>1/6/2011 11:19:0</td>\n",
       "      <td>EU</td>\n",
       "      <td>EU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3609</th>\n",
       "      <td>19983</td>\n",
       "      <td>54121</td>\n",
       "      <td>N-RegC2C</td>\n",
       "      <td>PN_EU_1_144</td>\n",
       "      <td>PN_EU_0_504</td>\n",
       "      <td>EUAcc1_144</td>\n",
       "      <td>EUAcc0_504</td>\n",
       "      <td>66531.27</td>\n",
       "      <td>Ind</td>\n",
       "      <td>SU</td>\n",
       "      <td>...</td>\n",
       "      <td>9.826441e+07</td>\n",
       "      <td>1.010993e+08</td>\n",
       "      <td>1.010328e+08</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>30/9/2011 18:15:27</td>\n",
       "      <td>30/9/2011 18:15:27</td>\n",
       "      <td>30/9/2011 18:15:27</td>\n",
       "      <td>EU</td>\n",
       "      <td>EU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3610</th>\n",
       "      <td>19988</td>\n",
       "      <td>54135</td>\n",
       "      <td>N-RegC2C</td>\n",
       "      <td>PN_EU_1_48</td>\n",
       "      <td>PN_EU_0_1119</td>\n",
       "      <td>EUAcc1_48</td>\n",
       "      <td>EUAcc0_1119</td>\n",
       "      <td>35068.36</td>\n",
       "      <td>Ind</td>\n",
       "      <td>SU</td>\n",
       "      <td>...</td>\n",
       "      <td>8.780167e+07</td>\n",
       "      <td>1.000998e+08</td>\n",
       "      <td>1.000647e+08</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>30/9/2011 19:1:48</td>\n",
       "      <td>30/9/2011 19:1:48</td>\n",
       "      <td>30/9/2011 19:1:48</td>\n",
       "      <td>EU</td>\n",
       "      <td>EU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3611</th>\n",
       "      <td>19994</td>\n",
       "      <td>54153</td>\n",
       "      <td>N-RegC2C</td>\n",
       "      <td>PN_EU_1_371</td>\n",
       "      <td>PN_EU_2_126</td>\n",
       "      <td>EUAcc1_371</td>\n",
       "      <td>EUAcc2_126</td>\n",
       "      <td>3369.15</td>\n",
       "      <td>Ind</td>\n",
       "      <td>SU</td>\n",
       "      <td>...</td>\n",
       "      <td>1.022480e+08</td>\n",
       "      <td>1.029042e+08</td>\n",
       "      <td>1.029008e+08</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>30/9/2011 20:16:29</td>\n",
       "      <td>30/9/2011 20:16:29</td>\n",
       "      <td>30/9/2011 20:16:29</td>\n",
       "      <td>EU</td>\n",
       "      <td>EU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3612</th>\n",
       "      <td>20003</td>\n",
       "      <td>54188</td>\n",
       "      <td>N-RegC2C</td>\n",
       "      <td>PN_EU_1_382</td>\n",
       "      <td>PN_EU_0_405</td>\n",
       "      <td>EUAcc1_382</td>\n",
       "      <td>EUAcc0_405</td>\n",
       "      <td>323.91</td>\n",
       "      <td>Ind</td>\n",
       "      <td>SU</td>\n",
       "      <td>...</td>\n",
       "      <td>9.901628e+07</td>\n",
       "      <td>1.002065e+08</td>\n",
       "      <td>1.002062e+08</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>30/9/2011 22:11:43</td>\n",
       "      <td>30/9/2011 22:11:43</td>\n",
       "      <td>30/9/2011 22:11:43</td>\n",
       "      <td>EU</td>\n",
       "      <td>EU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3613</th>\n",
       "      <td>20010</td>\n",
       "      <td>54211</td>\n",
       "      <td>N-RegC2C</td>\n",
       "      <td>PN_EU_1_340</td>\n",
       "      <td>PN_EU_2_134</td>\n",
       "      <td>EUAcc1_340</td>\n",
       "      <td>EUAcc2_134</td>\n",
       "      <td>54725.23</td>\n",
       "      <td>Ind</td>\n",
       "      <td>SU</td>\n",
       "      <td>...</td>\n",
       "      <td>1.001928e+08</td>\n",
       "      <td>1.025615e+08</td>\n",
       "      <td>1.025068e+08</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>30/9/2011 23:6:31</td>\n",
       "      <td>30/9/2011 23:6:31</td>\n",
       "      <td>30/9/2011 23:6:31</td>\n",
       "      <td>EU</td>\n",
       "      <td>EU</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3614 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      level_0  index         gT           sId           rId        sAcc  \\\n",
       "0           3      7  N-RegC2C      PN_EU_2_5   PN_EU_1_121    EUAcc2_5   \n",
       "1          15     37  N-RegC2C     PN_EU_3_10  PN_EU_0_1180   EUAcc3_10   \n",
       "2          16     41  N-RegC2C    PN_EU_1_138   PN_EU_0_500  EUAcc1_138   \n",
       "3          28     77  N-RegC2C    PN_EU_1_112   PN_EU_0_397  EUAcc1_112   \n",
       "4          31     80  N-RegC2C    PN_EU_2_105   PN_EU_1_494  EUAcc2_105   \n",
       "...       ...    ...        ...           ...           ...         ...   \n",
       "3609    19983  54121  N-RegC2C    PN_EU_1_144   PN_EU_0_504  EUAcc1_144   \n",
       "3610    19988  54135  N-RegC2C     PN_EU_1_48  PN_EU_0_1119   EUAcc1_48   \n",
       "3611    19994  54153  N-RegC2C    PN_EU_1_371   PN_EU_2_126  EUAcc1_371   \n",
       "3612    20003  54188  N-RegC2C    PN_EU_1_382   PN_EU_0_405  EUAcc1_382   \n",
       "3613    20010  54211  N-RegC2C    PN_EU_1_340   PN_EU_2_134  EUAcc1_340   \n",
       "\n",
       "             rAcc  TranAmount TranType TranStatus  ...     sBalAfter  \\\n",
       "0      EUAcc1_121    66197.31      Ind         SU  ...  9.993314e+07   \n",
       "1     EUAcc0_1180    48162.83      Ind         SU  ...  9.995136e+07   \n",
       "2      EUAcc0_500     7203.14      Ind         SU  ...  9.999272e+07   \n",
       "3      EUAcc0_397    66492.79      Ind         SU  ...  9.993284e+07   \n",
       "4      EUAcc1_494    47020.50      Ind         SU  ...  9.995251e+07   \n",
       "...           ...         ...      ...        ...  ...           ...   \n",
       "3609   EUAcc0_504    66531.27      Ind         SU  ...  9.826441e+07   \n",
       "3610  EUAcc0_1119    35068.36      Ind         SU  ...  8.780167e+07   \n",
       "3611   EUAcc2_126     3369.15      Ind         SU  ...  1.022480e+08   \n",
       "3612   EUAcc0_405      323.91      Ind         SU  ...  9.901628e+07   \n",
       "3613   EUAcc2_134    54725.23      Ind         SU  ...  1.001928e+08   \n",
       "\n",
       "        rBalBefore     rBalAfter   sf1   sf2                 sTD  \\\n",
       "0     1.000662e+08  1.000000e+08  True  True     1/6/2011 1:17:5   \n",
       "1     1.000482e+08  1.000000e+08  True  True    1/6/2011 5:18:19   \n",
       "2     1.000034e+08  9.999623e+07  True  True     1/6/2011 5:56:6   \n",
       "3     1.000665e+08  1.000000e+08  True  True    1/6/2011 11:5:51   \n",
       "4     1.000470e+08  1.000000e+08  True  True    1/6/2011 11:19:0   \n",
       "...            ...           ...   ...   ...                 ...   \n",
       "3609  1.010993e+08  1.010328e+08  True  True  30/9/2011 18:15:27   \n",
       "3610  1.000998e+08  1.000647e+08  True  True   30/9/2011 19:1:48   \n",
       "3611  1.029042e+08  1.029008e+08  True  True  30/9/2011 20:16:29   \n",
       "3612  1.002065e+08  1.002062e+08  True  True  30/9/2011 22:11:43   \n",
       "3613  1.025615e+08  1.025068e+08  True  True   30/9/2011 23:6:31   \n",
       "\n",
       "                     rTD              TranTS sType rType  \n",
       "0        1/6/2011 1:17:5     1/6/2011 1:17:5    EU    EU  \n",
       "1       1/6/2011 5:18:19    1/6/2011 5:18:19    EU    EU  \n",
       "2        1/6/2011 5:56:6     1/6/2011 5:56:6    EU    EU  \n",
       "3       1/6/2011 11:5:51    1/6/2011 11:5:51    EU    EU  \n",
       "4       1/6/2011 11:19:0    1/6/2011 11:19:0    EU    EU  \n",
       "...                  ...                 ...   ...   ...  \n",
       "3609  30/9/2011 18:15:27  30/9/2011 18:15:27    EU    EU  \n",
       "3610   30/9/2011 19:1:48   30/9/2011 19:1:48    EU    EU  \n",
       "3611  30/9/2011 20:16:29  30/9/2011 20:16:29    EU    EU  \n",
       "3612  30/9/2011 22:11:43  30/9/2011 22:11:43    EU    EU  \n",
       "3613   30/9/2011 23:6:31   30/9/2011 23:6:31    EU    EU  \n",
       "\n",
       "[3614 rows x 21 columns]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4=df3.drop(dind3).reset_index(drop=True)\n",
    "df4"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4d6a4292",
   "metadata": {},
   "source": [
    "#### df4 is the dataset created by droping the samples that not follow any criteria being involved in fraud transaction. So the samples in df4 are possible fraud transactions."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "f86eda83",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of possible transaction 3614\n"
     ]
    }
   ],
   "source": [
    "print('Number of possible transaction', len(df4))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f659c2c1",
   "metadata": {},
   "source": [
    "#### Step 4: Visualize all the transactions along with fraud transactions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "cadec29f",
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "#Now visualize the all transactions along with fraud transactions\n",
    "#pandas series into list\n",
    "fse=list(df4['sAcc'])\n",
    "fre=list(df4['rAcc'])\n",
    "Amnt=list(df4['TranAmount'])\n",
    "#Define a graph to visualise the fraud transactions\n",
    "net2=Network('1800px', '1000px')\n",
    "G2=nx.DiGraph()\n",
    "\n",
    "# Add normal transactions\n",
    "for i in range(1000):  #Visualizing only 1000 samples\n",
    "    G2.add_edge(senders[i],receivers[i],weight=Amount[i])\n",
    "\n",
    "# Add fraud transactions\n",
    "for j in range(200):  # Visualizing only 200 samples\n",
    "    G2.add_edge(fse[j],fre[j],weight=Amnt[j],color='red')\n",
    "\n",
    "net2.from_nx(G2)\n",
    "net2.show('AnalysedGraph.html')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.7.6 ('base')",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  },
  "vscode": {
   "interpreter": {
    "hash": "1448b48b023bcc9c3d4a79e814720a10ca6d4244f75e0f7ce4af58f96ba2b7d3"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}