jupyter/analysis-votes-web3-community_latest.ipynb

{
 "cells": [
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Web3 Community and Education sybil analysis\n",
    "\n",
    "This notebooks looks for patterns of sybil bahevior in the Web3 Community and Education round.\n",
    "\n",
    "This round was selected because during the grant review I flagged many projects from this round as suspicious.\n",
    "\n",
    "\n",
    "We use sybil-scorer as well as new metrics to identify suspicious behavior.\n",
    "\n",
    "We will then manually review the addresses using etherscan and DeBank to confirm our suspicions.\n",
    "\n",
    "Then we try to see if any project is more affected by these flagged addresses in particular to back up our claims of suspicious project applications. This will also allow us to see if the sybil behavior is targeted towards a specific project."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "from pathlib import Path\n",
    "import numpy as np\n",
    "\n",
    "import pandas as pd\n",
    "\n",
    "from sbdata.FlipsideApi import FlipsideApi\n",
    "\n",
    "# Set path to data folder\n",
    "current_dir = Path(os.getcwd())\n",
    "PATH_TO_EXPORT = os.path.join(current_dir.parent.parent, 'tx_data', 'web3_community_and_education')\n",
    "DATA_DIR = os.path.join(current_dir.parent.parent, 'data-regen-rangers')\n",
    "\n",
    "# read the address from oss grant\n",
    "\n",
    "api_key = os.environ['FLIPSIDE_API_KEY']\n",
    "flipside_api = FlipsideApi(api_key, max_address=400)\n",
    "PATH_TO_VOTES = os.path.join(DATA_DIR, \"votes_baoki.csv\")\n",
    "PATH_TO_GRANTS = os.path.join(DATA_DIR, \"all-allo-rounds.csv\")\n",
    "PATH_TO_PROJECTS = os.path.join(DATA_DIR, \"projects_QmQurt.csv\")\n",
    "\n",
    "# load data\n",
    "df_votes = pd.read_csv(PATH_TO_VOTES)\n",
    "df_grants = pd.read_csv(PATH_TO_GRANTS)\n",
    "df_application = pd.read_csv(PATH_TO_PROJECTS)\n",
    "# Lowercase all addresses because flipside api return lowercase address\n",
    "df_grants['Round ID'] = df_grants['Round ID'].str.lower()\n",
    "str_columns_votes = ['id', 'transaction', 'projectId', 'roundId', 'voter', 'grantAddress']\n",
    "df_votes[str_columns_votes] = df_votes[str_columns_votes].applymap(lambda x: x.lower())\n",
    "\n",
    "str_columns_application = ['id', 'roundId', 'metadata.application.round', 'metadata.application.recipient']\n",
    "df_application[str_columns_application] = df_application[str_columns_application].applymap(lambda x: str(x).lower())\n",
    "\n",
    "round_id = df_grants[df_grants['Round name'] == 'Web3 Community and Education']['Round ID'].values[0]\n",
    "array_unique_address = df_votes[df_votes['roundId'] == round_id]['voter'].unique()\n",
    "\n",
    "array_unique_address = np.char.lower(array_unique_address.astype(str))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sbutils import LoadData\n",
    "\n",
    "# Load data\n",
    "data_loader = LoadData.LoadData(PATH_TO_EXPORT)\n",
    "df_tx = data_loader.create_df_tx('ethereum')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1023"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(array_unique_address)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1022"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tx.EOA.nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['0x4a35674727c44cf4375d80c6171281ba2f764213'], dtype=object)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "c = np.setxor1d(array_unique_address, df_tx.EOA.values)\n",
    "c"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Looking at a specific address donation"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "I don't know why that address is not retrieved by the API, but it is a voter and had some interesting patterns to explore. \n",
    "The address is: 0x4a35674727c44cf4375d80c6171281ba2f764213 voted to many projects by giving exactly the same amount to all of them. Let see:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "suspicious_add = c[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of votes: 48\n",
      "Number of unique projects: 48\n",
      "Number of unique grants: 47\n"
     ]
    }
   ],
   "source": [
    "df_vote_sus = df_votes[df_votes.voter== suspicious_add]\n",
    "print(f'Number of votes: {len(df_vote_sus)}')\n",
    "print(f'Number of unique projects: {df_vote_sus.projectId.nunique()}')\n",
    "print(f'Number of unique grants: {df_vote_sus.grantAddress.nunique()}')"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Which project received the most votes from this address?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "grantAddress\n",
       "0xb6e780438882f2daa11da0972807f4d12166af8b    2\n",
       "0x486c853c41885d9c1edb57c423853fc4fbc60769    1\n",
       "0xc36e4889a820bd8089a8ad226ee9d0c703aed314    1\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_vote_sus['grantAddress'].value_counts().head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "268    Impact DAOs Research + Podcast + Book : Impact...\n",
       "337    Impact DAO Course + IRL/Online Events: Educati...\n",
       "687    Impact DAOs Research + Podcast + Book : Impact...\n",
       "Name: metadata.application.project.title, dtype: object"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# look at what is the project of the grant\n",
    "suspicious_add = df_vote_sus['grantAddress'].value_counts().index[0]\n",
    "df_application[df_application['metadata.application.recipient'] == suspicious_add]['metadata.application.project.title']\n"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "I find it very suspicious that this project \"Impact DAO\" applied for a grant with two subprojects. It would be interesting to explore how much common voter overlap there is between the two subprojects."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>id</th>\n",
       "      <th>transaction</th>\n",
       "      <th>blockNumber</th>\n",
       "      <th>applicationId</th>\n",
       "      <th>roundId</th>\n",
       "      <th>voter</th>\n",
       "      <th>grantAddress</th>\n",
       "      <th>token</th>\n",
       "      <th>amount</th>\n",
       "      <th>amountUSD</th>\n",
       "      <th>amountRoundToken</th>\n",
       "      <th>createdAt</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>projectId</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0x3e7af275e7342f380ce8182e2f1e19ecbf32086974f53a386a8e1278016f6a50</th>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0xa35e52635d40be090a49c587e58fab7410c30b9cff7ad5cc66b547d88cb93200</th>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    id  transaction   \n",
       "projectId                                                             \n",
       "0x3e7af275e7342f380ce8182e2f1e19ecbf32086974f53...  19           19  \\\n",
       "0xa35e52635d40be090a49c587e58fab7410c30b9cff7ad...  28           28   \n",
       "\n",
       "                                                    blockNumber   \n",
       "projectId                                                         \n",
       "0x3e7af275e7342f380ce8182e2f1e19ecbf32086974f53...           19  \\\n",
       "0xa35e52635d40be090a49c587e58fab7410c30b9cff7ad...           28   \n",
       "\n",
       "                                                    applicationId  roundId   \n",
       "projectId                                                                    \n",
       "0x3e7af275e7342f380ce8182e2f1e19ecbf32086974f53...             19       19  \\\n",
       "0xa35e52635d40be090a49c587e58fab7410c30b9cff7ad...             28       28   \n",
       "\n",
       "                                                    voter  grantAddress   \n",
       "projectId                                                                 \n",
       "0x3e7af275e7342f380ce8182e2f1e19ecbf32086974f53...     19            19  \\\n",
       "0xa35e52635d40be090a49c587e58fab7410c30b9cff7ad...     28            28   \n",
       "\n",
       "                                                    token  amount  amountUSD   \n",
       "projectId                                                                      \n",
       "0x3e7af275e7342f380ce8182e2f1e19ecbf32086974f53...     19      19         19  \\\n",
       "0xa35e52635d40be090a49c587e58fab7410c30b9cff7ad...     28      28         28   \n",
       "\n",
       "                                                    amountRoundToken   \n",
       "projectId                                                              \n",
       "0x3e7af275e7342f380ce8182e2f1e19ecbf32086974f53...                19  \\\n",
       "0xa35e52635d40be090a49c587e58fab7410c30b9cff7ad...                28   \n",
       "\n",
       "                                                    createdAt  \n",
       "projectId                                                      \n",
       "0x3e7af275e7342f380ce8182e2f1e19ecbf32086974f53...         19  \n",
       "0xa35e52635d40be090a49c587e58fab7410c30b9cff7ad...         28  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_votes[df_votes['grantAddress'] == suspicious_add].groupby('projectId').count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "projectId\n",
       "0x3e7af275e7342f380ce8182e2f1e19ecbf32086974f53a386a8e1278016f6a50    18\n",
       "0xa35e52635d40be090a49c587e58fab7410c30b9cff7ad5cc66b547d88cb93200    27\n",
       "Name: voter, dtype: int64"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_votes[df_votes['grantAddress'] == suspicious_add].groupby('projectId')['voter'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>count</th>\n",
       "      <th>unique</th>\n",
       "      <th>top</th>\n",
       "      <th>freq</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>projectId</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0x3e7af275e7342f380ce8182e2f1e19ecbf32086974f53a386a8e1278016f6a50</th>\n",
       "      <td>19</td>\n",
       "      <td>12</td>\n",
       "      <td>5000000000000000</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0xa35e52635d40be090a49c587e58fab7410c30b9cff7ad5cc66b547d88cb93200</th>\n",
       "      <td>28</td>\n",
       "      <td>15</td>\n",
       "      <td>1000000000000000</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   count unique   \n",
       "projectId                                                         \n",
       "0x3e7af275e7342f380ce8182e2f1e19ecbf32086974f53...    19     12  \\\n",
       "0xa35e52635d40be090a49c587e58fab7410c30b9cff7ad...    28     15   \n",
       "\n",
       "                                                                 top freq  \n",
       "projectId                                                                  \n",
       "0x3e7af275e7342f380ce8182e2f1e19ecbf32086974f53...  5000000000000000    3  \n",
       "0xa35e52635d40be090a49c587e58fab7410c30b9cff7ad...  1000000000000000    6  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_votes[df_votes['grantAddress'] == suspicious_add].groupby('projectId')['amount'].describe()"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The average donation is 1$ in both cases! 19 votes for 19$ and 28 votes for 28$."
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This project is very suspicious and should proably be squelched."
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Computing legos booleans"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sblegos.TransactionAnalyser import TransactionAnalyser as txa\n",
    "tx_analyser = txa(df_tx, df_address=pd.DataFrame(np.intersect1d(df_tx.EOA.unique(), array_unique_address)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>address</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0x0010e3bce7e7d5890849fa2bb2681174f4352bc4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0x00173c4cb23e6d876fcb036ba954a2f9cfcafa19</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      address\n",
       "0  0x0010e3bce7e7d5890849fa2bb2681174f4352bc4\n",
       "1  0x00173c4cb23e6d876fcb036ba954a2f9cfcafa19"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_matching_address = pd.DataFrame(df_tx.EOA.unique(), columns=[\"address\"])\n",
    "df_matching_address.head(2)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Compute the boolean "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_matching_address['seed_same_naive'] = df_matching_address.loc[:, 'address'].apply(lambda x : tx_analyser.has_same_seed_naive(x))\n",
    "df_matching_address['seed_same'] = df_matching_address.loc[:, 'address'].apply(lambda x : tx_analyser.has_same_seed(x))\n",
    "df_matching_address['seed_suspicious'] = df_matching_address.loc[:, 'seed_same_naive'].ne(df_matching_address.loc[:, 'seed_same'])\n",
    "df_matching_address['less_5_tx'] = df_matching_address.loc[:, 'address'].apply(lambda x : tx_analyser.has_less_than_n_transactions(x, 5))\n",
    "df_matching_address['less_10_tx'] = df_matching_address.loc[:, 'address'].apply(lambda x : tx_analyser.has_less_than_n_transactions(x, 10))\n",
    "df_matching_address['interacted_other_ctbt'] = df_matching_address.loc[:, 'address'].apply(lambda x : tx_analyser.has_interacted_with_other_contributor(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of voters: 1022\n"
     ]
    }
   ],
   "source": [
    "print(f'Number of voters: {len(df_matching_address)}')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "address                  0x0010e3bce7e7d5890849fa2bb2681174f4352bc40x00...\n",
       "seed_same_naive                                                        609\n",
       "seed_same                                                              617\n",
       "seed_suspicious                                                         14\n",
       "less_5_tx                                                              209\n",
       "less_10_tx                                                             283\n",
       "interacted_other_ctbt                                                  211\n",
       "dtype: object"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_matching_address.sum()"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Investigating the boolean seed suspicious"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>address</th>\n",
       "      <th>seed_same_naive</th>\n",
       "      <th>seed_same</th>\n",
       "      <th>seed_suspicious</th>\n",
       "      <th>less_5_tx</th>\n",
       "      <th>less_10_tx</th>\n",
       "      <th>interacted_other_ctbt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0x04afa8026bff7e97443f4efd6f96c6f2ff6d4ec9</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>0x3a42f1dcc218b0ee48966954208c9c4acbc04d89</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422</th>\n",
       "      <td>0x6b5918d8ef9094679f4b4e1bf397a66ea411b118</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>508</th>\n",
       "      <td>0x84f1cb27f0822135708aa879bbf04767af18019a</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>529</th>\n",
       "      <td>0x8a2ec4cc1d731bbace15fc5d234690a0788610a7</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>579</th>\n",
       "      <td>0x975a0e1bf2fdf3f4e5ba31b6c5774e73573b6b65</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>582</th>\n",
       "      <td>0x978eb534b26cb8749d352a2c94ec21e659e4248d</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>606</th>\n",
       "      <td>0x9d5c545d329454ab4ea9ff49a4e77985b9599232</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>673</th>\n",
       "      <td>0xac4ddaf8fbffba0f1e8c7619720335fd4f03eacd</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>774</th>\n",
       "      <td>0xc28064b875ae25f9a2ca28c08f116a5c26229f69</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>833</th>\n",
       "      <td>0xd15be984f5e58358b905b19e8fdafced86954970</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>910</th>\n",
       "      <td>0xe51200a4d161935fc311ed8a0401feb1abf20e3a</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>963</th>\n",
       "      <td>0xf11704511975cc5908f6dbd89be922f5c86c1055</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1006</th>\n",
       "      <td>0xfbca78474a09e2bf3543f4fc1037152ea2c6c32d</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         address  seed_same_naive  seed_same   \n",
       "19    0x04afa8026bff7e97443f4efd6f96c6f2ff6d4ec9            False       True  \\\n",
       "229   0x3a42f1dcc218b0ee48966954208c9c4acbc04d89            False       True   \n",
       "422   0x6b5918d8ef9094679f4b4e1bf397a66ea411b118            False       True   \n",
       "508   0x84f1cb27f0822135708aa879bbf04767af18019a            False       True   \n",
       "529   0x8a2ec4cc1d731bbace15fc5d234690a0788610a7             True      False   \n",
       "579   0x975a0e1bf2fdf3f4e5ba31b6c5774e73573b6b65            False       True   \n",
       "582   0x978eb534b26cb8749d352a2c94ec21e659e4248d             True      False   \n",
       "606   0x9d5c545d329454ab4ea9ff49a4e77985b9599232            False       True   \n",
       "673   0xac4ddaf8fbffba0f1e8c7619720335fd4f03eacd             True      False   \n",
       "774   0xc28064b875ae25f9a2ca28c08f116a5c26229f69            False       True   \n",
       "833   0xd15be984f5e58358b905b19e8fdafced86954970            False       True   \n",
       "910   0xe51200a4d161935fc311ed8a0401feb1abf20e3a            False       True   \n",
       "963   0xf11704511975cc5908f6dbd89be922f5c86c1055            False       True   \n",
       "1006  0xfbca78474a09e2bf3543f4fc1037152ea2c6c32d            False       True   \n",
       "\n",
       "      seed_suspicious  less_5_tx  less_10_tx  interacted_other_ctbt  \n",
       "19               True      False       False                   True  \n",
       "229              True      False       False                  False  \n",
       "422              True      False       False                  False  \n",
       "508              True      False       False                   True  \n",
       "529              True       True        True                   True  \n",
       "579              True      False       False                  False  \n",
       "582              True      False       False                   True  \n",
       "606              True      False       False                   True  \n",
       "673              True      False       False                   True  \n",
       "774              True      False       False                  False  \n",
       "833              True      False       False                   True  \n",
       "910              True      False       False                  False  \n",
       "963              True      False       False                  False  \n",
       "1006             True      False       False                   True  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_matching_address[df_matching_address['seed_suspicious'] == True]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of votes 16 Number of projects voted: 16\n"
     ]
    },
    {
     "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>grantAddress</th>\n",
       "      <th>metadata.application.project.title</th>\n",
       "      <th>status</th>\n",
       "      <th>metadata.application.round</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0x10666d9c6295e838d3b8b84ffcc97d62ef7e6120</td>\n",
       "      <td>Inverter Network - Fund and build in web 3 wit...</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0x11ee133a1408fe2d7c62296d7eb33f234b774503</td>\n",
       "      <td>dm3 protocol - the interoperability initiative</td>\n",
       "      <td>REJECTED</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0x7d658841f8ba93299970f6e765c2ce205f1e70dd</td>\n",
       "      <td>Loanshark</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0xb67fd6f4b908d702c2cf0e2b9d30d52d4ea5b2bc</td>\n",
       "      <td>ECHO</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0x713bc00d1df5c452f172c317d39eff71b771c163</td>\n",
       "      <td>Kakarot zkEVM</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0xdecf6615152ac768bfb688c4ef882e35debe08ac</td>\n",
       "      <td>Rhino Review - Ethereum Staking Journal</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0x187089b65520d2208ab93fb471c4970c29eaf929</td>\n",
       "      <td>Ape Framework</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0xb352bb4e2a4f27683435f153a259f1b207218b1b</td>\n",
       "      <td>eth.limo</td>\n",
       "      <td>REJECTED</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0xb7081fd06e7039d198d10a8b72b824e60c1b1e16</td>\n",
       "      <td>Otterscan</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0x52277e5cf8df8ef51d9bd37d8d7553a72d378bef</td>\n",
       "      <td>Trustless zkMafia</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>0x274554eb289004e15a7679123901b7f070dda0fa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0x23ada6e6a9e9d4ecddd185e3ec353163bceebf2a</td>\n",
       "      <td>PLUME: Pseudonymously Linked Unique Message En...</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>0x274554eb289004e15a7679123901b7f070dda0fa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0x00de4b13153673bcae2616b67bf822500d325fc3</td>\n",
       "      <td>Greenpill Podcast</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0x4d9339dd97db55e3b9bcbe65de39ff9c04d1c2cd</td>\n",
       "      <td>Giveth</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0x629e715db365fdbac0a61330cbf256237dccdcb9</td>\n",
       "      <td>Share</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>0x9c3b81967eafba0a451e324417dd4f3f353b997b</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0x7ad6e69fce7b87e0ada3f5c87e5f3705278f6ec7</td>\n",
       "      <td>FusionX</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>0xf1c021df6dc6b2dc2e5a837cdfddc2f42503233b</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0x63c3742f92b6144876dc9a36ac373d0346f4f2e3</td>\n",
       "      <td>Pulsar Protocol</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>0xf1c021df6dc6b2dc2e5a837cdfddc2f42503233b</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  grantAddress   \n",
       "0   0x10666d9c6295e838d3b8b84ffcc97d62ef7e6120  \\\n",
       "1   0x11ee133a1408fe2d7c62296d7eb33f234b774503   \n",
       "2   0x7d658841f8ba93299970f6e765c2ce205f1e70dd   \n",
       "3   0xb67fd6f4b908d702c2cf0e2b9d30d52d4ea5b2bc   \n",
       "4   0x713bc00d1df5c452f172c317d39eff71b771c163   \n",
       "5   0xdecf6615152ac768bfb688c4ef882e35debe08ac   \n",
       "6   0x187089b65520d2208ab93fb471c4970c29eaf929   \n",
       "7   0xb352bb4e2a4f27683435f153a259f1b207218b1b   \n",
       "8   0xb7081fd06e7039d198d10a8b72b824e60c1b1e16   \n",
       "9   0x52277e5cf8df8ef51d9bd37d8d7553a72d378bef   \n",
       "10  0x23ada6e6a9e9d4ecddd185e3ec353163bceebf2a   \n",
       "11  0x00de4b13153673bcae2616b67bf822500d325fc3   \n",
       "12  0x4d9339dd97db55e3b9bcbe65de39ff9c04d1c2cd   \n",
       "13  0x629e715db365fdbac0a61330cbf256237dccdcb9   \n",
       "14  0x7ad6e69fce7b87e0ada3f5c87e5f3705278f6ec7   \n",
       "15  0x63c3742f92b6144876dc9a36ac373d0346f4f2e3   \n",
       "\n",
       "                   metadata.application.project.title    status   \n",
       "0   Inverter Network - Fund and build in web 3 wit...  APPROVED  \\\n",
       "1     dm3 protocol - the interoperability initiative   REJECTED   \n",
       "2                                           Loanshark  APPROVED   \n",
       "3                                                ECHO  APPROVED   \n",
       "4                                       Kakarot zkEVM  APPROVED   \n",
       "5             Rhino Review - Ethereum Staking Journal  APPROVED   \n",
       "6                                       Ape Framework  APPROVED   \n",
       "7                                            eth.limo  REJECTED   \n",
       "8                                           Otterscan  APPROVED   \n",
       "9                                   Trustless zkMafia  APPROVED   \n",
       "10  PLUME: Pseudonymously Linked Unique Message En...  APPROVED   \n",
       "11                                  Greenpill Podcast  APPROVED   \n",
       "12                                             Giveth  APPROVED   \n",
       "13                                              Share  APPROVED   \n",
       "14                                            FusionX  APPROVED   \n",
       "15                                    Pulsar Protocol  APPROVED   \n",
       "\n",
       "                    metadata.application.round  \n",
       "0   0x12bb5bbbfe596dbc489d209299b8302c3300fa40  \n",
       "1   0x12bb5bbbfe596dbc489d209299b8302c3300fa40  \n",
       "2   0x12bb5bbbfe596dbc489d209299b8302c3300fa40  \n",
       "3   0x12bb5bbbfe596dbc489d209299b8302c3300fa40  \n",
       "4   0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094  \n",
       "5   0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094  \n",
       "6   0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094  \n",
       "7   0x12bb5bbbfe596dbc489d209299b8302c3300fa40  \n",
       "8   0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094  \n",
       "9   0x274554eb289004e15a7679123901b7f070dda0fa  \n",
       "10  0x274554eb289004e15a7679123901b7f070dda0fa  \n",
       "11  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  \n",
       "12  0x12bb5bbbfe596dbc489d209299b8302c3300fa40  \n",
       "13  0x9c3b81967eafba0a451e324417dd4f3f353b997b  \n",
       "14  0xf1c021df6dc6b2dc2e5a837cdfddc2f42503233b  \n",
       "15  0xf1c021df6dc6b2dc2e5a837cdfddc2f42503233b  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "projects_voted = df_votes[df_votes['voter'] == '0xc28064b875ae25f9a2ca28c08f116a5c26229f69']\n",
    "print(f'Number of votes {projects_voted.shape[0]} Number of projects voted: {projects_voted.grantAddress.nunique()}')\n",
    "# Merge the project the user voted for and the projects \n",
    "projects_voted.merge(df_application, left_on='grantAddress', right_on='metadata.application.recipient', how='left').drop_duplicates(subset='grantAddress').loc[:, ['grantAddress', 'metadata.application.project.title', 'status', 'metadata.application.round']].reset_index(drop=True)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Some of the projects he donated to are in the list of Rejected projects showing that this address is indeed a sybil. And may have contributed to ohter fraudulent projects."
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "- Pulsar is not very active and is forked code for the most part\n",
    "- Fusion not very active on github but has a lot of activity on twitter \n",
    "- Share suspicious Github with no activity, twitter does not exists: suspicious\n",
    "\n",
    "Other projects are ok"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of votes 3 Number of projects voted: 3\n"
     ]
    },
    {
     "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>grantAddress</th>\n",
       "      <th>metadata.application.project.title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0x5514f4a2bc7194664b12a48e238876aa53140350</td>\n",
       "      <td>Voting Contracts</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0x53390590476dc98860316e4b46bb9842af55efc4</td>\n",
       "      <td>DAppNode</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0x4cd6b4503d02973d78cff59c9c56f5f378688274</td>\n",
       "      <td>Mechanism Institute: Democratizing Cryptoecono...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 grantAddress   \n",
       "0  0x5514f4a2bc7194664b12a48e238876aa53140350  \\\n",
       "1  0x53390590476dc98860316e4b46bb9842af55efc4   \n",
       "2  0x4cd6b4503d02973d78cff59c9c56f5f378688274   \n",
       "\n",
       "                  metadata.application.project.title  \n",
       "0                                   Voting Contracts  \n",
       "1                                           DAppNode  \n",
       "2  Mechanism Institute: Democratizing Cryptoecono...  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "projects_voted = df_votes[df_votes['voter'] == '0x61ffe691821291d02e9ba5d33098adcee71a3a17']\n",
    "print(f'Number of votes {projects_voted.shape[0]} Number of projects voted: {projects_voted.grantAddress.nunique()}')\n",
    "# Merge the project the user voted for and the projects \n",
    "projects_voted.merge(df_application, left_on='grantAddress', right_on='metadata.application.recipient', how='left').drop_duplicates(subset='grantAddress').loc[:, ['grantAddress', 'metadata.application.project.title']].reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of votes 2 Number of projects voted: 2\n"
     ]
    },
    {
     "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>grantAddress</th>\n",
       "      <th>metadata.application.project.title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0x2f6c8f867df4e49e4fb24741c414f315e266c21b</td>\n",
       "      <td>Ethereum Lima</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0xba97f51b1b097ce1ea43cf941cd62dfbcd70cae3</td>\n",
       "      <td>ETH Kipu</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 grantAddress   \n",
       "0  0x2f6c8f867df4e49e4fb24741c414f315e266c21b  \\\n",
       "1  0xba97f51b1b097ce1ea43cf941cd62dfbcd70cae3   \n",
       "\n",
       "  metadata.application.project.title  \n",
       "0                      Ethereum Lima  \n",
       "1                           ETH Kipu  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "projects_voted = df_votes[df_votes['voter'] == '0xe51200a4d161935fc311ed8a0401feb1abf20e3a']\n",
    "print(f'Number of votes {projects_voted.shape[0]} Number of projects voted: {projects_voted.grantAddress.nunique()}')\n",
    "# Merge the project the user voted for and the projects \n",
    "projects_voted.merge(df_application, left_on='grantAddress', right_on='metadata.application.recipient', how='left').drop_duplicates(subset='grantAddress').loc[:, ['grantAddress', 'metadata.application.project.title']].reset_index(drop=True)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The boolean seed suspicious is not relevant for that round we will not use it for the analysis."
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Computing the new dex interaction score\n",
    "It was investigated in another notebook "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_interacted_address(from_address, to_address, address):\n",
    "    if from_address == address:\n",
    "        return to_address\n",
    "    else:\n",
    "        return from_address\n",
    "\n",
    "def count_interaction_with_any(tx_analyser, address, array_address):\n",
    "    \"\"\"\n",
    "    Return an integer of the number of interactions with the addresses in the array_address\n",
    "    Parameters\n",
    "    ----------\n",
    "    address : str\n",
    "        The address to check\n",
    "\n",
    "    Returns\n",
    "    -------\n",
    "    count_interaction_with_any : int\n",
    "        The number of interactions with the addresses in the array_address\n",
    "    \"\"\"\n",
    "    tx_analyser.set_group_by_sorted_EOA()\n",
    "\n",
    "    df = tx_analyser.gb_EOA_sorted.get_group(address)\n",
    "    address_interacted = df.apply(lambda x: get_interacted_address(x['from_address'], x['to_address'], address), axis=1)\n",
    "    tx_boolean_interacted = address_interacted.isin(array_address)\n",
    "    return tx_boolean_interacted.sum()\n",
    "\n",
    "def has_interacted_with_any(tx_analyser, address, array_address):\n",
    "    \"\"\"\n",
    "    Return a boolean whether the address has interacted with any address in the array_address\n",
    "    Parameters\n",
    "    ----------\n",
    "    address : str\n",
    "        The address to check\n",
    "\n",
    "    Returns\n",
    "    -------\n",
    "    has_interacted_with_any : bool\n",
    "        True if the address has interacted with one or more of the addresses in the array_address\n",
    "    \"\"\"\n",
    "    count_interaction_with_any = count_interaction_with_any(tx_analyser, address, array_address)\n",
    "    return count_interaction_with_any > 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "label_query = '''\n",
    "SELECT ADDRESS, CREATOR, LABEL_TYPE, ADDRESS_NAME, PROJECT_NAME\n",
    "FROM crosschain.core.address_labels \n",
    "WHERE BLOCKCHAIN='ethereum'\n",
    "AND LABEL_SUBTYPE = 'pool' \n",
    ";'''\n",
    "df_label = flipside_api.execute_query(label_query)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "# extract all the pool addresses\n",
    "array_pool_address = df_label['address'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "tx_analyser.set_group_by_sorted_EOA()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Compute the number of interactions with any of the pools for each address\n",
    "df_matching_address['count_interaction_with_pool'] = df_matching_address['address'].apply(lambda x: count_interaction_with_any(tx_analyser, x, array_pool_address))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.32093933463796476"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(df_matching_address['count_interaction_with_pool'] > 0).sum() / len(df_matching_address)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "label_query = '''\n",
    "SELECT DISTINCT(LABEL_SUBTYPE)\n",
    "FROM crosschain.core.address_labels \n",
    "WHERE BLOCKCHAIN='ethereum'\n",
    ";'''\n",
    "df_distinct_labels = flipside_api.execute_query(label_query)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['strategy', 'chadmin', 'router', 'multisig', 'airdrop_contract',\n",
       "       'nf_token_contract', 'token_distribution', 'nf_position_manager',\n",
       "       'donation_address', 'mining_pool', 'deposit_wallet',\n",
       "       'staking_contract', 'pool', 'token_contract', 'bridge',\n",
       "       'mint_burn', 'mint_contract', 'contract_deployer', 'marketplace',\n",
       "       'foundation', 'vault', 'voting', 'cold_wallet', 'reserve',\n",
       "       'swap_router', 'hot_wallet', 'toxic', 'fee_wallet', 'governance',\n",
       "       'general_contract', 'swap_contract', 'distributor_cex', 'escrow',\n",
       "       'rewards', 'dao', 'treasury', 'token_sale', 'oracle',\n",
       "       'aggregator_contract'], dtype=object)"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_distinct_labels.label_subtype.unique()"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "From these tags lets flag any address that have interacted with a toxic wallet"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "label_query = '''\n",
    "SELECT ADDRESS, CREATOR, LABEL_TYPE, ADDRESS_NAME, PROJECT_NAME\n",
    "FROM crosschain.core.address_labels \n",
    "WHERE BLOCKCHAIN='ethereum'\n",
    "AND LABEL_SUBTYPE = 'toxic'\n",
    ";'''\n",
    "df_toxic = flipside_api.execute_query(label_query)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(4857, 6)"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_toxic.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Compute the number of interactions with any of the scam for each address\n",
    "df_matching_address['count_interaction_with_toxic'] = df_matching_address['address'].apply(lambda x: count_interaction_with_any(tx_analyser, x, df_toxic['address'].unique()))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Percentage of addresses that have interacted with a toxic address: 1%\n"
     ]
    }
   ],
   "source": [
    "print(f'Percentage of addresses that have interacted with a toxic address: {int((df_matching_address[\"count_interaction_with_toxic\"] > 0).sum() / len(df_matching_address) *100)}%')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "tag_query = '''\n",
    "SELECT DISTINCT(TAG_TYPE)\n",
    "FROM crosschain.core.address_tags \n",
    "WHERE BLOCKCHAIN='ethereum'\n",
    ";'''\n",
    "df_distinct_tags = flipside_api.execute_query(tag_query)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['contract', 'Balancer Delegates', 'wallet', 'activity', 'cex',\n",
       "       'chainlink oracle', 'Aave Delegates', 'NFT', 'nft', 'dex'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_distinct_tags.tag_type.values"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "I found the tag_name \"airdrop master\" could be interesting "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "query_airdrop_master = '''\n",
    "SELECT BLOCKCHAIN, CREATOR, ADDRESS, TAG_NAME\n",
    "FROM crosschain.core.address_tags \n",
    "WHERE BLOCKCHAIN='ethereum'\n",
    "AND TAG_NAME = 'airdrop master'\n",
    ";\n",
    "'''\n",
    "df_airdrop_master = flipside_api.execute_query(query_airdrop_master)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Percentage of addresses that interacted with airdrop master: 19%\n"
     ]
    }
   ],
   "source": [
    "# Compute the number of interactions with any of the aidrop for each address\n",
    "df_matching_address['count_interaction_with_airdrop_m'] = df_matching_address['address'].apply(lambda x: count_interaction_with_any(tx_analyser, x, df_airdrop_master['address'].unique()))\n",
    "print(f'Percentage of addresses that interacted with airdrop master: {int((df_matching_address[\"count_interaction_with_airdrop_m\"] > 0).sum() / len(df_matching_address) * 100)}%')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Percentage of addresses that are airdrop master: 6%\n"
     ]
    }
   ],
   "source": [
    "# Boolean whether the address is a aidrop master\n",
    "df_matching_address['is_airdrop_master'] = df_matching_address['address'].apply(lambda x: x in df_airdrop_master['address'].unique()) \n",
    "print(f'Percentage of addresses that are airdrop master: {int((df_matching_address[\"is_airdrop_master\"]).sum() / len(df_matching_address) * 100)}%')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "sql_query_tornado = '''\n",
    "SELECT DISTINCT PROJECT_NAME, ADDRESS\n",
    "FROM crosschain.core.address_labels \n",
    "WHERE BLOCKCHAIN='ethereum'\n",
    "AND PROJECT_NAME LIKE '%tornado%'\n",
    ";\n",
    "'''\n",
    "df_tornado = flipside_api.execute_query(sql_query_tornado)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Percentage of addresses that interacted with tornado: 3%\n"
     ]
    }
   ],
   "source": [
    "# Count the number of interactions with tornado\n",
    "df_matching_address['count_interaction_with_tornado'] = df_matching_address['address'].apply(lambda x: count_interaction_with_any(tx_analyser, x, df_tornado['address'].unique()))\n",
    "print(f'Percentage of addresses that interacted with tornado: {int((df_matching_address[\"count_interaction_with_tornado\"] > 0).sum() / len(df_matching_address) * 100)}%')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Percentage of addresses that interacted with disperse: 1%\n"
     ]
    }
   ],
   "source": [
    "# Count the number of time the address interatec with disperse contract: '0xD152f549545093347A162Dce210e7293f1452150'\n",
    "df_matching_address['count_interaction_with_disperse'] = df_matching_address['address'].apply(lambda x: count_interaction_with_any(tx_analyser, x, [str.lower('0xD152f549545093347A162Dce210e7293f1452150')]))\n",
    "print(f'Percentage of addresses that interacted with disperse: {int((df_matching_address[\"count_interaction_with_disperse\"] > 0).sum() / len(df_matching_address) * 100)}%')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "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>count_interaction_with_pool</th>\n",
       "      <th>count_interaction_with_toxic</th>\n",
       "      <th>count_interaction_with_airdrop_m</th>\n",
       "      <th>count_interaction_with_tornado</th>\n",
       "      <th>count_interaction_with_disperse</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>1022.000000</td>\n",
       "      <td>1022.00000</td>\n",
       "      <td>1022.000000</td>\n",
       "      <td>1022.000000</td>\n",
       "      <td>1022.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>6.946184</td>\n",
       "      <td>0.02544</td>\n",
       "      <td>1.773973</td>\n",
       "      <td>0.103718</td>\n",
       "      <td>0.078278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>38.091056</td>\n",
       "      <td>0.23281</td>\n",
       "      <td>7.696927</td>\n",
       "      <td>0.830966</td>\n",
       "      <td>0.901483</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10%</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90%</th>\n",
       "      <td>12.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>742.000000</td>\n",
       "      <td>5.00000</td>\n",
       "      <td>96.000000</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>16.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       count_interaction_with_pool  count_interaction_with_toxic   \n",
       "count                  1022.000000                    1022.00000  \\\n",
       "mean                      6.946184                       0.02544   \n",
       "std                      38.091056                       0.23281   \n",
       "min                       0.000000                       0.00000   \n",
       "10%                       0.000000                       0.00000   \n",
       "25%                       0.000000                       0.00000   \n",
       "50%                       0.000000                       0.00000   \n",
       "75%                       2.000000                       0.00000   \n",
       "90%                      12.000000                       0.00000   \n",
       "max                     742.000000                       5.00000   \n",
       "\n",
       "       count_interaction_with_airdrop_m  count_interaction_with_tornado   \n",
       "count                       1022.000000                     1022.000000  \\\n",
       "mean                           1.773973                        0.103718   \n",
       "std                            7.696927                        0.830966   \n",
       "min                            0.000000                        0.000000   \n",
       "10%                            0.000000                        0.000000   \n",
       "25%                            0.000000                        0.000000   \n",
       "50%                            0.000000                        0.000000   \n",
       "75%                            0.000000                        0.000000   \n",
       "90%                            3.000000                        0.000000   \n",
       "max                           96.000000                       18.000000   \n",
       "\n",
       "       count_interaction_with_disperse  \n",
       "count                      1022.000000  \n",
       "mean                          0.078278  \n",
       "std                           0.901483  \n",
       "min                           0.000000  \n",
       "10%                           0.000000  \n",
       "25%                           0.000000  \n",
       "50%                           0.000000  \n",
       "75%                           0.000000  \n",
       "90%                           0.000000  \n",
       "max                          16.000000  "
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_matching_address.describe(percentiles=[0.1, 0.25, 0.5, 0.75, 0.9])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_matching_address['has_interaction_toxic'] = df_matching_address['count_interaction_with_toxic'] > 0\n",
    "df_matching_address['has_no_pool_interaction'] = df_matching_address['count_interaction_with_pool'] < 6\n",
    "df_matching_address['has_interaction_airdrop_m'] = df_matching_address['count_interaction_with_airdrop_m'] > 0\n",
    "df_matching_address['has_interaction_tornado'] = df_matching_address['count_interaction_with_tornado'] > 0\n",
    "df_matching_address['has_interaction_disperse'] = df_matching_address['count_interaction_with_disperse'] > 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "boolean_features = ['has_interaction_toxic', 'has_no_pool_interaction', 'has_interaction_airdrop_m', 'has_interaction_tornado', 'has_interaction_disperse', 'is_airdrop_master', 'interacted_other_ctbt', 'less_10_tx', 'less_5_tx']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "has_interaction_toxic         18\n",
       "has_no_pool_interaction      870\n",
       "has_interaction_airdrop_m    200\n",
       "has_interaction_tornado       32\n",
       "has_interaction_disperse      17\n",
       "is_airdrop_master             70\n",
       "interacted_other_ctbt        211\n",
       "less_10_tx                   283\n",
       "less_5_tx                    209\n",
       "dtype: int64"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_matching_address[boolean_features].sum() "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "305"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(df_matching_address[boolean_features].sum(axis=1) > 2).sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_matching_address['count_flags'] = df_matching_address[boolean_features].sum(axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_matching_address['suspicious_1'] = df_matching_address['count_flags'] > 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_suspicious_1 = df_matching_address[df_matching_address['suspicious_1'] == True]"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Investigating the grants receiving the most votes from the flagged addresses"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_vote_sus1 = df_votes[df_votes['voter'].isin(df_suspicious_1['address'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of votes 1304 Number of projects voted: 395\n"
     ]
    }
   ],
   "source": [
    "print(f'Number of votes {df_vote_sus1.shape[0]} Number of projects voted: {df_vote_sus1.grantAddress.nunique()}')\n",
    "# Merge the project the user voted for and the projects \n",
    "gr_sus = df_vote_sus1['grantAddress'].value_counts().reset_index().merge(df_application, left_on='grantAddress', right_on='metadata.application.recipient', how='left').drop_duplicates(subset='grantAddress').loc[:, ['grantAddress', 'metadata.application.project.title', 'count', 'roundId', 'status']].reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "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>grantAddress</th>\n",
       "      <th>metadata.application.project.title</th>\n",
       "      <th>count</th>\n",
       "      <th>roundId</th>\n",
       "      <th>status</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0xc36e4889a820bd8089a8ad226ee9d0c703aed314</td>\n",
       "      <td>Crypto Babes Club</td>\n",
       "      <td>173</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0x4adc8cc149a03f44386bee80bab36f9e8022b195</td>\n",
       "      <td>Unitap</td>\n",
       "      <td>17</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0x8110d1d04ac316fdcace8f24fd60c86b810ab15a</td>\n",
       "      <td>Commons Stack</td>\n",
       "      <td>14</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0x18aa467e40e1defb1956708830a343c1d01d3d7c</td>\n",
       "      <td>JediSwap</td>\n",
       "      <td>12</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0x4d9339dd97db55e3b9bcbe65de39ff9c04d1c2cd</td>\n",
       "      <td>Giveth</td>\n",
       "      <td>11</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0xda3dddae8119644f8be18c7afd16850b02a4c841</td>\n",
       "      <td>ETH Venezuela Community Projects</td>\n",
       "      <td>11</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0x3a5bd1e37b099ae3386d13947b6a90d97675e5e3</td>\n",
       "      <td>Lenster</td>\n",
       "      <td>11</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0x1dd8ec683e8b53c57ba5a01c5d2f866a3fbd3ce8</td>\n",
       "      <td>Help Protect the Internet Archive</td>\n",
       "      <td>10</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0xd8eab52bccf6307a4579ab868b42eee0eb5492ed</td>\n",
       "      <td>Ethereum Uruguay</td>\n",
       "      <td>10</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0x57e6cf96a2e99a3fdaa79acc3a14fc9be1eabc03</td>\n",
       "      <td>The Neptune Project</td>\n",
       "      <td>10</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0x4b8810b079eb22ecf2d1f75e08e0abbd6fd87dbf</td>\n",
       "      <td>BrightID 🔆 Universal Proof of Uniqueness</td>\n",
       "      <td>9</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0x3d2c7d934d0b0f2979de988e0092aa8c2ccfc638</td>\n",
       "      <td>Revolte</td>\n",
       "      <td>9</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0xc8d65e1bd67f16522e3117b980e1c9d2caeb9dc3</td>\n",
       "      <td>Pairwise: Tinder UX for web3 community signaling</td>\n",
       "      <td>9</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0x08a3c2a819e3de7aca384c798269b3ce1cd0e437</td>\n",
       "      <td>DefiLlama</td>\n",
       "      <td>9</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0xffbd35255008f86322051f2313d4b343540e0e00</td>\n",
       "      <td>Gravity DAO</td>\n",
       "      <td>9</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0x0b7246ef74ca7b37fdc3d15be4f0b49876622f95</td>\n",
       "      <td>Praise</td>\n",
       "      <td>8</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0x5ead82e959d8218f6003526ab8d457972b679c41</td>\n",
       "      <td>Ethereum Costa Rica</td>\n",
       "      <td>8</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0x0035cc37599241d007d0aba1fb931c5fa757f7a1</td>\n",
       "      <td>EVMcrispr</td>\n",
       "      <td>8</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0x53390590476dc98860316e4b46bb9842af55efc4</td>\n",
       "      <td>DAppNode</td>\n",
       "      <td>7</td>\n",
       "      <td>0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0x6c5a2688c83c806150ca9dd0b2f10f16f8f1c33e</td>\n",
       "      <td>L2BEAT</td>\n",
       "      <td>7</td>\n",
       "      <td>0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0xb604cda24cca1838428be7d40fcd830451c23a0e</td>\n",
       "      <td>Trusted Seed</td>\n",
       "      <td>7</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0xefedaf9c07e6eb56bb8f82f30018e4461b1c5f4c</td>\n",
       "      <td>Web3beach</td>\n",
       "      <td>7</td>\n",
       "      <td>0x421510312c40486965767be5ea603aa8a5707983</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0x73dce9348a03975415c6fa5296e71c1abae61407</td>\n",
       "      <td>zkBob</td>\n",
       "      <td>7</td>\n",
       "      <td>0x274554eb289004e15a7679123901b7f070dda0fa</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0x929e1b374fb07486c9a64570e5bda99383f48785</td>\n",
       "      <td>Solow</td>\n",
       "      <td>7</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>0x0442a9abbc93058a873c371f21cc366338254a88</td>\n",
       "      <td>Urbanika</td>\n",
       "      <td>7</td>\n",
       "      <td>0x421510312c40486965767be5ea603aa8a5707983</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0x5afc7720b161788f9d833555b7ebc3274fd98da1</td>\n",
       "      <td>POAPin</td>\n",
       "      <td>7</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>0xe126b3e5d052f1f575828f61feba4f4f2603652a</td>\n",
       "      <td>Revoke.cash - Helping you stay safe in web3</td>\n",
       "      <td>7</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0x9d4e94db689bc471e45b0a18b7bda36fccec9c3b</td>\n",
       "      <td>beaconcha.in</td>\n",
       "      <td>7</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0x57ea12a3a8e441f5fe7b1f3af1121097b7d3b6a8</td>\n",
       "      <td>Umbra</td>\n",
       "      <td>7</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>0xfbca78474a09e2bf3543f4fc1037152ea2c6c32d</td>\n",
       "      <td>Atlantis</td>\n",
       "      <td>6</td>\n",
       "      <td>0x421510312c40486965767be5ea603aa8a5707983</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  grantAddress   \n",
       "0   0xc36e4889a820bd8089a8ad226ee9d0c703aed314  \\\n",
       "1   0x4adc8cc149a03f44386bee80bab36f9e8022b195   \n",
       "2   0x8110d1d04ac316fdcace8f24fd60c86b810ab15a   \n",
       "3   0x18aa467e40e1defb1956708830a343c1d01d3d7c   \n",
       "4   0x4d9339dd97db55e3b9bcbe65de39ff9c04d1c2cd   \n",
       "5   0xda3dddae8119644f8be18c7afd16850b02a4c841   \n",
       "6   0x3a5bd1e37b099ae3386d13947b6a90d97675e5e3   \n",
       "7   0x1dd8ec683e8b53c57ba5a01c5d2f866a3fbd3ce8   \n",
       "8   0xd8eab52bccf6307a4579ab868b42eee0eb5492ed   \n",
       "9   0x57e6cf96a2e99a3fdaa79acc3a14fc9be1eabc03   \n",
       "10  0x4b8810b079eb22ecf2d1f75e08e0abbd6fd87dbf   \n",
       "11  0x3d2c7d934d0b0f2979de988e0092aa8c2ccfc638   \n",
       "12  0xc8d65e1bd67f16522e3117b980e1c9d2caeb9dc3   \n",
       "13  0x08a3c2a819e3de7aca384c798269b3ce1cd0e437   \n",
       "14  0xffbd35255008f86322051f2313d4b343540e0e00   \n",
       "15  0x0b7246ef74ca7b37fdc3d15be4f0b49876622f95   \n",
       "16  0x5ead82e959d8218f6003526ab8d457972b679c41   \n",
       "17  0x0035cc37599241d007d0aba1fb931c5fa757f7a1   \n",
       "18  0x53390590476dc98860316e4b46bb9842af55efc4   \n",
       "19  0x6c5a2688c83c806150ca9dd0b2f10f16f8f1c33e   \n",
       "20  0xb604cda24cca1838428be7d40fcd830451c23a0e   \n",
       "21  0xefedaf9c07e6eb56bb8f82f30018e4461b1c5f4c   \n",
       "22  0x73dce9348a03975415c6fa5296e71c1abae61407   \n",
       "23  0x929e1b374fb07486c9a64570e5bda99383f48785   \n",
       "24  0x0442a9abbc93058a873c371f21cc366338254a88   \n",
       "25  0x5afc7720b161788f9d833555b7ebc3274fd98da1   \n",
       "26  0xe126b3e5d052f1f575828f61feba4f4f2603652a   \n",
       "27  0x9d4e94db689bc471e45b0a18b7bda36fccec9c3b   \n",
       "28  0x57ea12a3a8e441f5fe7b1f3af1121097b7d3b6a8   \n",
       "29  0xfbca78474a09e2bf3543f4fc1037152ea2c6c32d   \n",
       "\n",
       "                  metadata.application.project.title  count   \n",
       "0                                  Crypto Babes Club    173  \\\n",
       "1                                             Unitap     17   \n",
       "2                                      Commons Stack     14   \n",
       "3                                           JediSwap     12   \n",
       "4                                             Giveth     11   \n",
       "5                   ETH Venezuela Community Projects     11   \n",
       "6                                            Lenster     11   \n",
       "7                  Help Protect the Internet Archive     10   \n",
       "8                                   Ethereum Uruguay     10   \n",
       "9                                The Neptune Project     10   \n",
       "10          BrightID 🔆 Universal Proof of Uniqueness      9   \n",
       "11                                           Revolte      9   \n",
       "12  Pairwise: Tinder UX for web3 community signaling      9   \n",
       "13                                         DefiLlama      9   \n",
       "14                                       Gravity DAO      9   \n",
       "15                                            Praise      8   \n",
       "16                               Ethereum Costa Rica      8   \n",
       "17                                         EVMcrispr      8   \n",
       "18                                          DAppNode      7   \n",
       "19                                            L2BEAT      7   \n",
       "20                                      Trusted Seed      7   \n",
       "21                                         Web3beach      7   \n",
       "22                                             zkBob      7   \n",
       "23                                             Solow      7   \n",
       "24                                          Urbanika      7   \n",
       "25                                            POAPin      7   \n",
       "26       Revoke.cash - Helping you stay safe in web3      7   \n",
       "27                                      beaconcha.in      7   \n",
       "28                                             Umbra      7   \n",
       "29                                          Atlantis      6   \n",
       "\n",
       "                                       roundId    status  \n",
       "0   0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "1   0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "2   0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "3   0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "4   0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "5   0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "6   0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "7   0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "8   0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "9   0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "10  0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "11  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "12  0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "13  0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "14  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "15  0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "16  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "17  0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "18  0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094  APPROVED  \n",
       "19  0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094  APPROVED  \n",
       "20  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "21  0x421510312c40486965767be5ea603aa8a5707983  APPROVED  \n",
       "22  0x274554eb289004e15a7679123901b7f070dda0fa  APPROVED  \n",
       "23  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "24  0x421510312c40486965767be5ea603aa8a5707983  APPROVED  \n",
       "25  0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "26  0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "27  0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "28  0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "29  0x421510312c40486965767be5ea603aa8a5707983  APPROVED  "
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gr_sus.head(30)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Upchain twitter handle does not exists but the repo is very active Suspicious?\n",
    "\n",
    "- Seoul bound is either very new or suspicious\n",
    "- Gravity DAO old project not sure it is still active\n",
    "\n",
    "Other projects are not suspicious"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Look at the addresses with many flags"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "has_interaction_toxic         18\n",
       "has_no_pool_interaction      870\n",
       "has_interaction_airdrop_m    200\n",
       "has_interaction_tornado       32\n",
       "has_interaction_disperse      17\n",
       "is_airdrop_master             70\n",
       "interacted_other_ctbt        211\n",
       "less_10_tx                   283\n",
       "less_5_tx                    209\n",
       "dtype: int64"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_matching_address[boolean_features].sum()"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We are going to review the addresses that have at least 1 flag:\n",
    "- has_intercation_toxic \n",
    "- has_interaction_tornado\n",
    "- has_interaction_disperse\n",
    "- has_interaction_airdrop_master\n",
    "- is airdrop master"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "interaction_bool = ['has_interaction_toxic', 'has_interaction_airdrop_m', 'has_interaction_tornado', 'has_interaction_disperse', 'is_airdrop_master']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of addresses that interacted with a suspicious contract or address: 226\n"
     ]
    }
   ],
   "source": [
    "df_interact_sus = df_matching_address[df_matching_address[interaction_bool].sum(axis=1) > 0]\n",
    "print(f'Number of addresses that interacted with a suspicious contract or address: {df_interact_sus.shape[0]}')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_vote_interact_sus = df_votes[df_votes['voter'].isin(df_interact_sus['address'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of votes 1304 Number of projects voted: 395\n"
     ]
    }
   ],
   "source": [
    "print(f'Number of votes {df_vote_sus1.shape[0]} Number of projects voted: {df_vote_sus1.grantAddress.nunique()}')\n",
    "# Merge the project the user voted for and the projects \n",
    "gr_sus = df_vote_interact_sus['grantAddress'].value_counts().reset_index().merge(df_application, left_on='grantAddress', right_on='metadata.application.recipient', how='left').drop_duplicates(subset='grantAddress').loc[:, ['grantAddress', 'metadata.application.project.title', 'count', 'roundId', 'status']].reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "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>grantAddress</th>\n",
       "      <th>metadata.application.project.title</th>\n",
       "      <th>count</th>\n",
       "      <th>roundId</th>\n",
       "      <th>status</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0x3a5bd1e37b099ae3386d13947b6a90d97675e5e3</td>\n",
       "      <td>Lenster</td>\n",
       "      <td>35</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0x18aa467e40e1defb1956708830a343c1d01d3d7c</td>\n",
       "      <td>JediSwap</td>\n",
       "      <td>29</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0x08a3c2a819e3de7aca384c798269b3ce1cd0e437</td>\n",
       "      <td>DefiLlama</td>\n",
       "      <td>26</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0x4d9339dd97db55e3b9bcbe65de39ff9c04d1c2cd</td>\n",
       "      <td>Giveth</td>\n",
       "      <td>26</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0xe126b3e5d052f1f575828f61feba4f4f2603652a</td>\n",
       "      <td>Revoke.cash - Helping you stay safe in web3</td>\n",
       "      <td>26</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0x8110d1d04ac316fdcace8f24fd60c86b810ab15a</td>\n",
       "      <td>Commons Stack</td>\n",
       "      <td>25</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0x99b36fdbc582d113af36a21eba06bfeab7b9be12</td>\n",
       "      <td>Taho - Open Source and Community Owned Wallet</td>\n",
       "      <td>23</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0x4b8810b079eb22ecf2d1f75e08e0abbd6fd87dbf</td>\n",
       "      <td>BrightID 🔆 Universal Proof of Uniqueness</td>\n",
       "      <td>22</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0x4adc8cc149a03f44386bee80bab36f9e8022b195</td>\n",
       "      <td>Unitap</td>\n",
       "      <td>21</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0xb352bb4e2a4f27683435f153a259f1b207218b1b</td>\n",
       "      <td>eth.limo</td>\n",
       "      <td>20</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>REJECTED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0x9d727911b54c455b0071a7b682fcf4bc444b5596</td>\n",
       "      <td>ZachXBT</td>\n",
       "      <td>20</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0x00de4b13153673bcae2616b67bf822500d325fc3</td>\n",
       "      <td>Greenpill Podcast</td>\n",
       "      <td>20</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0x6c5a2688c83c806150ca9dd0b2f10f16f8f1c33e</td>\n",
       "      <td>L2BEAT</td>\n",
       "      <td>19</td>\n",
       "      <td>0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0x01d79bceaeaadfb8fd2f2f53005289cfcf483464</td>\n",
       "      <td>Lenstube</td>\n",
       "      <td>19</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0x7d658841f8ba93299970f6e765c2ce205f1e70dd</td>\n",
       "      <td>Loanshark</td>\n",
       "      <td>18</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0xda3dddae8119644f8be18c7afd16850b02a4c841</td>\n",
       "      <td>ETH Venezuela Community Projects</td>\n",
       "      <td>18</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0x53390590476dc98860316e4b46bb9842af55efc4</td>\n",
       "      <td>DAppNode</td>\n",
       "      <td>17</td>\n",
       "      <td>0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0x0eb2ab241210900aeac2fba054dd605355fe2490</td>\n",
       "      <td>Buidl Guidl</td>\n",
       "      <td>17</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0x743b8e21eb7bd3cb81e521b5f3e7f3c6fbe61d33</td>\n",
       "      <td>GreenPill Global</td>\n",
       "      <td>17</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0x57ea12a3a8e441f5fe7b1f3af1121097b7d3b6a8</td>\n",
       "      <td>Umbra</td>\n",
       "      <td>17</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0xb604cda24cca1838428be7d40fcd830451c23a0e</td>\n",
       "      <td>Trusted Seed</td>\n",
       "      <td>16</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0xb6e780438882f2daa11da0972807f4d12166af8b</td>\n",
       "      <td>Impact DAOs Research + Podcast + Book : Impact...</td>\n",
       "      <td>16</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0x4af147188bfe1c02d18d752ed5e473d8394f2300</td>\n",
       "      <td>Fileverse – because Notion &amp; Gsuite are centra...</td>\n",
       "      <td>16</td>\n",
       "      <td>0x9c3b81967eafba0a451e324417dd4f3f353b997b</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0x73dce9348a03975415c6fa5296e71c1abae61407</td>\n",
       "      <td>zkBob</td>\n",
       "      <td>15</td>\n",
       "      <td>0x274554eb289004e15a7679123901b7f070dda0fa</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>0xc8d65e1bd67f16522e3117b980e1c9d2caeb9dc3</td>\n",
       "      <td>Pairwise: Tinder UX for web3 community signaling</td>\n",
       "      <td>15</td>\n",
       "      <td>0x12bb5bbbfe596dbc489d209299b8302c3300fa40</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0x6b5918d8ef9094679f4b4e1bf397a66ea411b118</td>\n",
       "      <td>Infinite Garden Library</td>\n",
       "      <td>15</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>0x9531c059098e3d194ff87febb587ab07b30b1306</td>\n",
       "      <td>rotki</td>\n",
       "      <td>15</td>\n",
       "      <td>0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0x713bc00d1df5c452f172c317d39eff71b771c163</td>\n",
       "      <td>Kakarot zkEVM</td>\n",
       "      <td>15</td>\n",
       "      <td>0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0xd39d6d3f7433a0cabd90c0ea74d76da29b718314</td>\n",
       "      <td>Metagov</td>\n",
       "      <td>15</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>0xf29ff96aaea6c9a1fba851f74737f3c069d4f1a9</td>\n",
       "      <td>Protocol Guild</td>\n",
       "      <td>15</td>\n",
       "      <td>0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  grantAddress   \n",
       "0   0x3a5bd1e37b099ae3386d13947b6a90d97675e5e3  \\\n",
       "1   0x18aa467e40e1defb1956708830a343c1d01d3d7c   \n",
       "2   0x08a3c2a819e3de7aca384c798269b3ce1cd0e437   \n",
       "3   0x4d9339dd97db55e3b9bcbe65de39ff9c04d1c2cd   \n",
       "4   0xe126b3e5d052f1f575828f61feba4f4f2603652a   \n",
       "5   0x8110d1d04ac316fdcace8f24fd60c86b810ab15a   \n",
       "6   0x99b36fdbc582d113af36a21eba06bfeab7b9be12   \n",
       "7   0x4b8810b079eb22ecf2d1f75e08e0abbd6fd87dbf   \n",
       "8   0x4adc8cc149a03f44386bee80bab36f9e8022b195   \n",
       "11  0xb352bb4e2a4f27683435f153a259f1b207218b1b   \n",
       "9   0x9d727911b54c455b0071a7b682fcf4bc444b5596   \n",
       "10  0x00de4b13153673bcae2616b67bf822500d325fc3   \n",
       "12  0x6c5a2688c83c806150ca9dd0b2f10f16f8f1c33e   \n",
       "13  0x01d79bceaeaadfb8fd2f2f53005289cfcf483464   \n",
       "14  0x7d658841f8ba93299970f6e765c2ce205f1e70dd   \n",
       "15  0xda3dddae8119644f8be18c7afd16850b02a4c841   \n",
       "18  0x53390590476dc98860316e4b46bb9842af55efc4   \n",
       "19  0x0eb2ab241210900aeac2fba054dd605355fe2490   \n",
       "17  0x743b8e21eb7bd3cb81e521b5f3e7f3c6fbe61d33   \n",
       "16  0x57ea12a3a8e441f5fe7b1f3af1121097b7d3b6a8   \n",
       "20  0xb604cda24cca1838428be7d40fcd830451c23a0e   \n",
       "21  0xb6e780438882f2daa11da0972807f4d12166af8b   \n",
       "22  0x4af147188bfe1c02d18d752ed5e473d8394f2300   \n",
       "23  0x73dce9348a03975415c6fa5296e71c1abae61407   \n",
       "24  0xc8d65e1bd67f16522e3117b980e1c9d2caeb9dc3   \n",
       "25  0x6b5918d8ef9094679f4b4e1bf397a66ea411b118   \n",
       "26  0x9531c059098e3d194ff87febb587ab07b30b1306   \n",
       "27  0x713bc00d1df5c452f172c317d39eff71b771c163   \n",
       "28  0xd39d6d3f7433a0cabd90c0ea74d76da29b718314   \n",
       "29  0xf29ff96aaea6c9a1fba851f74737f3c069d4f1a9   \n",
       "\n",
       "                   metadata.application.project.title  count   \n",
       "0                                             Lenster     35  \\\n",
       "1                                            JediSwap     29   \n",
       "2                                           DefiLlama     26   \n",
       "3                                              Giveth     26   \n",
       "4         Revoke.cash - Helping you stay safe in web3     26   \n",
       "5                                       Commons Stack     25   \n",
       "6       Taho - Open Source and Community Owned Wallet     23   \n",
       "7            BrightID 🔆 Universal Proof of Uniqueness     22   \n",
       "8                                              Unitap     21   \n",
       "11                                           eth.limo     20   \n",
       "9                                             ZachXBT     20   \n",
       "10                                  Greenpill Podcast     20   \n",
       "12                                             L2BEAT     19   \n",
       "13                                           Lenstube     19   \n",
       "14                                          Loanshark     18   \n",
       "15                   ETH Venezuela Community Projects     18   \n",
       "18                                           DAppNode     17   \n",
       "19                                        Buidl Guidl     17   \n",
       "17                                  GreenPill Global      17   \n",
       "16                                              Umbra     17   \n",
       "20                                       Trusted Seed     16   \n",
       "21  Impact DAOs Research + Podcast + Book : Impact...     16   \n",
       "22  Fileverse – because Notion & Gsuite are centra...     16   \n",
       "23                                              zkBob     15   \n",
       "24   Pairwise: Tinder UX for web3 community signaling     15   \n",
       "25                            Infinite Garden Library     15   \n",
       "26                                              rotki     15   \n",
       "27                                      Kakarot zkEVM     15   \n",
       "28                                            Metagov     15   \n",
       "29                                     Protocol Guild     15   \n",
       "\n",
       "                                       roundId    status  \n",
       "0   0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "1   0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "2   0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "3   0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "4   0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "5   0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "6   0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "7   0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "8   0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "11  0x12bb5bbbfe596dbc489d209299b8302c3300fa40  REJECTED  \n",
       "9   0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "10  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "12  0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094  APPROVED  \n",
       "13  0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "14  0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "15  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "18  0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094  APPROVED  \n",
       "19  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "17  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "16  0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "20  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "21  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "22  0x9c3b81967eafba0a451e324417dd4f3f353b997b  APPROVED  \n",
       "23  0x274554eb289004e15a7679123901b7f070dda0fa  APPROVED  \n",
       "24  0x12bb5bbbfe596dbc489d209299b8302c3300fa40  APPROVED  \n",
       "25  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "26  0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094  APPROVED  \n",
       "27  0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094  APPROVED  \n",
       "28  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "29  0xdf22a2c8f6ba9376ff17ee13e6154b784ee92094  APPROVED  "
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gr_sus.sort_values(by='count', ascending=False).head(30)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "No projects look suspicious in the top 30 by contribution"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Investigating more in details the type of donations made by the flagged addresses"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "# look at the average donation in USD\n",
    "gb_donation_usd = df_vote_interact_sus.groupby('voter').describe()['amountUSD']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "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>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>voter</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0x008c9f31533dd2a327d0ff28b6fe87194de1e3d3</th>\n",
       "      <td>1.0</td>\n",
       "      <td>5.997155</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.997155</td>\n",
       "      <td>5.997155</td>\n",
       "      <td>5.997155</td>\n",
       "      <td>5.997155</td>\n",
       "      <td>5.997155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0xa0839d50d601c0ce86677a03739f802fe614ba22</th>\n",
       "      <td>1.0</td>\n",
       "      <td>19.997351</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.997351</td>\n",
       "      <td>19.997351</td>\n",
       "      <td>19.997351</td>\n",
       "      <td>19.997351</td>\n",
       "      <td>19.997351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0xa009881d1ecddb62a2e15f0ef19c482dd2df1c3a</th>\n",
       "      <td>1.0</td>\n",
       "      <td>92.636609</td>\n",
       "      <td>NaN</td>\n",
       "      <td>92.636609</td>\n",
       "      <td>92.636609</td>\n",
       "      <td>92.636609</td>\n",
       "      <td>92.636609</td>\n",
       "      <td>92.636609</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0x9b278aaef429cc4728e594f8fa0fbfe78e72cc26</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.138289</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.138289</td>\n",
       "      <td>1.138289</td>\n",
       "      <td>1.138289</td>\n",
       "      <td>1.138289</td>\n",
       "      <td>1.138289</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0x921f80499a00ac6e95aae0daa411d338f41d5da2</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.528923</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.528923</td>\n",
       "      <td>9.528923</td>\n",
       "      <td>9.528923</td>\n",
       "      <td>9.528923</td>\n",
       "      <td>9.528923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0x40f9bf922c23c43acdad71ab4425280c0ffbd697</th>\n",
       "      <td>1.0</td>\n",
       "      <td>200.691627</td>\n",
       "      <td>NaN</td>\n",
       "      <td>200.691627</td>\n",
       "      <td>200.691627</td>\n",
       "      <td>200.691627</td>\n",
       "      <td>200.691627</td>\n",
       "      <td>200.691627</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0x3ffc07ed6a65e379e39bef93e713ee3ff77a56e4</th>\n",
       "      <td>1.0</td>\n",
       "      <td>36.972994</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36.972994</td>\n",
       "      <td>36.972994</td>\n",
       "      <td>36.972994</td>\n",
       "      <td>36.972994</td>\n",
       "      <td>36.972994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0x3e48830bf4415311d13c3c89a0e315ee7398d114</th>\n",
       "      <td>1.0</td>\n",
       "      <td>3.792925</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.792925</td>\n",
       "      <td>3.792925</td>\n",
       "      <td>3.792925</td>\n",
       "      <td>3.792925</td>\n",
       "      <td>3.792925</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0x71f84aa585e1eda8852dad8dff3a69d114366dba</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.734560</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.734560</td>\n",
       "      <td>9.734560</td>\n",
       "      <td>9.734560</td>\n",
       "      <td>9.734560</td>\n",
       "      <td>9.734560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0xff56ec56a405716accaa4e6c54aef7fa2948192e</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.247645</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.247645</td>\n",
       "      <td>9.247645</td>\n",
       "      <td>9.247645</td>\n",
       "      <td>9.247645</td>\n",
       "      <td>9.247645</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>81 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            count        mean  std   \n",
       "voter                                                                \n",
       "0x008c9f31533dd2a327d0ff28b6fe87194de1e3d3    1.0    5.997155  NaN  \\\n",
       "0xa0839d50d601c0ce86677a03739f802fe614ba22    1.0   19.997351  NaN   \n",
       "0xa009881d1ecddb62a2e15f0ef19c482dd2df1c3a    1.0   92.636609  NaN   \n",
       "0x9b278aaef429cc4728e594f8fa0fbfe78e72cc26    1.0    1.138289  NaN   \n",
       "0x921f80499a00ac6e95aae0daa411d338f41d5da2    1.0    9.528923  NaN   \n",
       "...                                           ...         ...  ...   \n",
       "0x40f9bf922c23c43acdad71ab4425280c0ffbd697    1.0  200.691627  NaN   \n",
       "0x3ffc07ed6a65e379e39bef93e713ee3ff77a56e4    1.0   36.972994  NaN   \n",
       "0x3e48830bf4415311d13c3c89a0e315ee7398d114    1.0    3.792925  NaN   \n",
       "0x71f84aa585e1eda8852dad8dff3a69d114366dba    1.0    9.734560  NaN   \n",
       "0xff56ec56a405716accaa4e6c54aef7fa2948192e    1.0    9.247645  NaN   \n",
       "\n",
       "                                                   min         25%   \n",
       "voter                                                                \n",
       "0x008c9f31533dd2a327d0ff28b6fe87194de1e3d3    5.997155    5.997155  \\\n",
       "0xa0839d50d601c0ce86677a03739f802fe614ba22   19.997351   19.997351   \n",
       "0xa009881d1ecddb62a2e15f0ef19c482dd2df1c3a   92.636609   92.636609   \n",
       "0x9b278aaef429cc4728e594f8fa0fbfe78e72cc26    1.138289    1.138289   \n",
       "0x921f80499a00ac6e95aae0daa411d338f41d5da2    9.528923    9.528923   \n",
       "...                                                ...         ...   \n",
       "0x40f9bf922c23c43acdad71ab4425280c0ffbd697  200.691627  200.691627   \n",
       "0x3ffc07ed6a65e379e39bef93e713ee3ff77a56e4   36.972994   36.972994   \n",
       "0x3e48830bf4415311d13c3c89a0e315ee7398d114    3.792925    3.792925   \n",
       "0x71f84aa585e1eda8852dad8dff3a69d114366dba    9.734560    9.734560   \n",
       "0xff56ec56a405716accaa4e6c54aef7fa2948192e    9.247645    9.247645   \n",
       "\n",
       "                                                   50%         75%         max  \n",
       "voter                                                                           \n",
       "0x008c9f31533dd2a327d0ff28b6fe87194de1e3d3    5.997155    5.997155    5.997155  \n",
       "0xa0839d50d601c0ce86677a03739f802fe614ba22   19.997351   19.997351   19.997351  \n",
       "0xa009881d1ecddb62a2e15f0ef19c482dd2df1c3a   92.636609   92.636609   92.636609  \n",
       "0x9b278aaef429cc4728e594f8fa0fbfe78e72cc26    1.138289    1.138289    1.138289  \n",
       "0x921f80499a00ac6e95aae0daa411d338f41d5da2    9.528923    9.528923    9.528923  \n",
       "...                                                ...         ...         ...  \n",
       "0x40f9bf922c23c43acdad71ab4425280c0ffbd697  200.691627  200.691627  200.691627  \n",
       "0x3ffc07ed6a65e379e39bef93e713ee3ff77a56e4   36.972994   36.972994   36.972994  \n",
       "0x3e48830bf4415311d13c3c89a0e315ee7398d114    3.792925    3.792925    3.792925  \n",
       "0x71f84aa585e1eda8852dad8dff3a69d114366dba    9.734560    9.734560    9.734560  \n",
       "0xff56ec56a405716accaa4e6c54aef7fa2948192e    9.247645    9.247645    9.247645  \n",
       "\n",
       "[81 rows x 8 columns]"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gb_donation_usd[gb_donation_usd['count'] == 1].sort_values(by='count', ascending=True)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This is interesting lets look at which project they gave\n",
    "\n",
    "Nonetheless some donations are very similar in the amount donated lets try to dig into them"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "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>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>voter</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0x2e3e22f9f4d2de3dbdee9cbf350e22afb1c1d6b9</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.515146</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.515146</td>\n",
       "      <td>9.515146</td>\n",
       "      <td>9.515146</td>\n",
       "      <td>9.515146</td>\n",
       "      <td>9.515146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0x588f6ccb39f3d474c5b3736483589e2bbc8e0847</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.281587</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.281587</td>\n",
       "      <td>9.281587</td>\n",
       "      <td>9.281587</td>\n",
       "      <td>9.281587</td>\n",
       "      <td>9.281587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0x70b224998167a500ef39ed91e35ad133d996e744</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.494141</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.494141</td>\n",
       "      <td>9.494141</td>\n",
       "      <td>9.494141</td>\n",
       "      <td>9.494141</td>\n",
       "      <td>9.494141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0x71f84aa585e1eda8852dad8dff3a69d114366dba</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.734560</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.734560</td>\n",
       "      <td>9.734560</td>\n",
       "      <td>9.734560</td>\n",
       "      <td>9.734560</td>\n",
       "      <td>9.734560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0x7267db34b6072080923f92e626c2fc5da91ff25b</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.219747</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.219747</td>\n",
       "      <td>9.219747</td>\n",
       "      <td>9.219747</td>\n",
       "      <td>9.219747</td>\n",
       "      <td>9.219747</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0x745339df47cb4186be2fc573e81d50e598b99aef</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.399484</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.399484</td>\n",
       "      <td>9.399484</td>\n",
       "      <td>9.399484</td>\n",
       "      <td>9.399484</td>\n",
       "      <td>9.399484</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0x921f80499a00ac6e95aae0daa411d338f41d5da2</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.528923</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.528923</td>\n",
       "      <td>9.528923</td>\n",
       "      <td>9.528923</td>\n",
       "      <td>9.528923</td>\n",
       "      <td>9.528923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0xa34faa5b9b9e29c191e163a520edeea93a574ba3</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.497355</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.497355</td>\n",
       "      <td>9.497355</td>\n",
       "      <td>9.497355</td>\n",
       "      <td>9.497355</td>\n",
       "      <td>9.497355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0xae65dfac43c1dd0b4e4976128d654adf597f756c</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.556308</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.556308</td>\n",
       "      <td>9.556308</td>\n",
       "      <td>9.556308</td>\n",
       "      <td>9.556308</td>\n",
       "      <td>9.556308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0xaee2e6432db54a6f3770d57f1108cd326f2b224f</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.497355</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.497355</td>\n",
       "      <td>9.497355</td>\n",
       "      <td>9.497355</td>\n",
       "      <td>9.497355</td>\n",
       "      <td>9.497355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0xbb49ccec023dc369844eec3190503853b1380606</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.497355</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.497355</td>\n",
       "      <td>9.497355</td>\n",
       "      <td>9.497355</td>\n",
       "      <td>9.497355</td>\n",
       "      <td>9.497355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0xe4c140a67a3a95913a6e2fcfc6d6434d94c07641</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.436143</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.436143</td>\n",
       "      <td>9.436143</td>\n",
       "      <td>9.436143</td>\n",
       "      <td>9.436143</td>\n",
       "      <td>9.436143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0xe8fb09228d1373f931007ca7894a08344b80901c</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.797497</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.797497</td>\n",
       "      <td>9.797497</td>\n",
       "      <td>9.797497</td>\n",
       "      <td>9.797497</td>\n",
       "      <td>9.797497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0xff56ec56a405716accaa4e6c54aef7fa2948192e</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.247645</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.247645</td>\n",
       "      <td>9.247645</td>\n",
       "      <td>9.247645</td>\n",
       "      <td>9.247645</td>\n",
       "      <td>9.247645</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            count      mean  std       min   \n",
       "voter                                                                        \n",
       "0x2e3e22f9f4d2de3dbdee9cbf350e22afb1c1d6b9    1.0  9.515146  NaN  9.515146  \\\n",
       "0x588f6ccb39f3d474c5b3736483589e2bbc8e0847    1.0  9.281587  NaN  9.281587   \n",
       "0x70b224998167a500ef39ed91e35ad133d996e744    1.0  9.494141  NaN  9.494141   \n",
       "0x71f84aa585e1eda8852dad8dff3a69d114366dba    1.0  9.734560  NaN  9.734560   \n",
       "0x7267db34b6072080923f92e626c2fc5da91ff25b    1.0  9.219747  NaN  9.219747   \n",
       "0x745339df47cb4186be2fc573e81d50e598b99aef    1.0  9.399484  NaN  9.399484   \n",
       "0x921f80499a00ac6e95aae0daa411d338f41d5da2    1.0  9.528923  NaN  9.528923   \n",
       "0xa34faa5b9b9e29c191e163a520edeea93a574ba3    1.0  9.497355  NaN  9.497355   \n",
       "0xae65dfac43c1dd0b4e4976128d654adf597f756c    1.0  9.556308  NaN  9.556308   \n",
       "0xaee2e6432db54a6f3770d57f1108cd326f2b224f    1.0  9.497355  NaN  9.497355   \n",
       "0xbb49ccec023dc369844eec3190503853b1380606    1.0  9.497355  NaN  9.497355   \n",
       "0xe4c140a67a3a95913a6e2fcfc6d6434d94c07641    1.0  9.436143  NaN  9.436143   \n",
       "0xe8fb09228d1373f931007ca7894a08344b80901c    1.0  9.797497  NaN  9.797497   \n",
       "0xff56ec56a405716accaa4e6c54aef7fa2948192e    1.0  9.247645  NaN  9.247645   \n",
       "\n",
       "                                                 25%       50%       75%   \n",
       "voter                                                                      \n",
       "0x2e3e22f9f4d2de3dbdee9cbf350e22afb1c1d6b9  9.515146  9.515146  9.515146  \\\n",
       "0x588f6ccb39f3d474c5b3736483589e2bbc8e0847  9.281587  9.281587  9.281587   \n",
       "0x70b224998167a500ef39ed91e35ad133d996e744  9.494141  9.494141  9.494141   \n",
       "0x71f84aa585e1eda8852dad8dff3a69d114366dba  9.734560  9.734560  9.734560   \n",
       "0x7267db34b6072080923f92e626c2fc5da91ff25b  9.219747  9.219747  9.219747   \n",
       "0x745339df47cb4186be2fc573e81d50e598b99aef  9.399484  9.399484  9.399484   \n",
       "0x921f80499a00ac6e95aae0daa411d338f41d5da2  9.528923  9.528923  9.528923   \n",
       "0xa34faa5b9b9e29c191e163a520edeea93a574ba3  9.497355  9.497355  9.497355   \n",
       "0xae65dfac43c1dd0b4e4976128d654adf597f756c  9.556308  9.556308  9.556308   \n",
       "0xaee2e6432db54a6f3770d57f1108cd326f2b224f  9.497355  9.497355  9.497355   \n",
       "0xbb49ccec023dc369844eec3190503853b1380606  9.497355  9.497355  9.497355   \n",
       "0xe4c140a67a3a95913a6e2fcfc6d6434d94c07641  9.436143  9.436143  9.436143   \n",
       "0xe8fb09228d1373f931007ca7894a08344b80901c  9.797497  9.797497  9.797497   \n",
       "0xff56ec56a405716accaa4e6c54aef7fa2948192e  9.247645  9.247645  9.247645   \n",
       "\n",
       "                                                 max  \n",
       "voter                                                 \n",
       "0x2e3e22f9f4d2de3dbdee9cbf350e22afb1c1d6b9  9.515146  \n",
       "0x588f6ccb39f3d474c5b3736483589e2bbc8e0847  9.281587  \n",
       "0x70b224998167a500ef39ed91e35ad133d996e744  9.494141  \n",
       "0x71f84aa585e1eda8852dad8dff3a69d114366dba  9.734560  \n",
       "0x7267db34b6072080923f92e626c2fc5da91ff25b  9.219747  \n",
       "0x745339df47cb4186be2fc573e81d50e598b99aef  9.399484  \n",
       "0x921f80499a00ac6e95aae0daa411d338f41d5da2  9.528923  \n",
       "0xa34faa5b9b9e29c191e163a520edeea93a574ba3  9.497355  \n",
       "0xae65dfac43c1dd0b4e4976128d654adf597f756c  9.556308  \n",
       "0xaee2e6432db54a6f3770d57f1108cd326f2b224f  9.497355  \n",
       "0xbb49ccec023dc369844eec3190503853b1380606  9.497355  \n",
       "0xe4c140a67a3a95913a6e2fcfc6d6434d94c07641  9.436143  \n",
       "0xe8fb09228d1373f931007ca7894a08344b80901c  9.797497  \n",
       "0xff56ec56a405716accaa4e6c54aef7fa2948192e  9.247645  "
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# inparticular address that donated close to 9.5$\n",
    "same_amount = gb_donation_usd[np.logical_and(gb_donation_usd['count'] == 1, np.floor(gb_donation_usd['mean']) == 9)].sort_values(by='count', ascending=True)\n",
    "same_amount"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_grant_title(address, df_application, df_votes):\n",
    "    project_address = df_votes[df_votes['voter'] == address]['grantAddress'].values[0]\n",
    "    return df_application[df_application['metadata.application.recipient'] == project_address]['metadata.application.project.title'].values[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Address: 0x2e3e22f9f4d2de3dbdee9cbf350e22afb1c1d6b9 Project: Unitap\n",
      "Address: 0x588f6ccb39f3d474c5b3736483589e2bbc8e0847 Project: Mechanism Institute: Democratizing Cryptoeconomics\n",
      "Address: 0x70b224998167a500ef39ed91e35ad133d996e744 Project: BanklessDAO Projects\n",
      "Address: 0x71f84aa585e1eda8852dad8dff3a69d114366dba Project: Web3TalentFair\n",
      "Address: 0x7267db34b6072080923f92e626c2fc5da91ff25b Project: Unitap\n",
      "Address: 0x745339df47cb4186be2fc573e81d50e598b99aef Project: GreenPill Global \n",
      "Address: 0x921f80499a00ac6e95aae0daa411d338f41d5da2 Project: JobStash\n",
      "Address: 0xa34faa5b9b9e29c191e163a520edeea93a574ba3 Project: BanklessDAO Projects\n",
      "Address: 0xae65dfac43c1dd0b4e4976128d654adf597f756c Project: Web3ForGood\n",
      "Address: 0xaee2e6432db54a6f3770d57f1108cd326f2b224f Project: BanklessDAO Projects\n",
      "Address: 0xbb49ccec023dc369844eec3190503853b1380606 Project: BanklessDAO Projects\n",
      "Address: 0xe4c140a67a3a95913a6e2fcfc6d6434d94c07641 Project: ReFi Japan\n",
      "Address: 0xe8fb09228d1373f931007ca7894a08344b80901c Project: Unitap\n",
      "Address: 0xff56ec56a405716accaa4e6c54aef7fa2948192e Project: H.E.R. DAO \n"
     ]
    }
   ],
   "source": [
    "for address in same_amount.index:\n",
    "    print(f'Address: {address} Project: {get_grant_title(address, df_application, df_votes)}')"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This analysis is pointing to a suspicion for the project \"BanklessDAO Projects\" and \"Unitap\"\n",
    "\n",
    "However the project \"BanklessDAO Projects\" is well known.\n",
    "\n",
    "My guess is that there is a lot of collusion within these addresses and there donation should not be matched. Especially knowing some of these addresses are flagged. Let's verify it."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "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>address</th>\n",
       "      <th>seed_same_naive</th>\n",
       "      <th>seed_same</th>\n",
       "      <th>seed_suspicious</th>\n",
       "      <th>less_5_tx</th>\n",
       "      <th>less_10_tx</th>\n",
       "      <th>interacted_other_ctbt</th>\n",
       "      <th>count_interaction_with_pool</th>\n",
       "      <th>count_interaction_with_toxic</th>\n",
       "      <th>count_interaction_with_airdrop_m</th>\n",
       "      <th>is_airdrop_master</th>\n",
       "      <th>count_interaction_with_tornado</th>\n",
       "      <th>count_interaction_with_disperse</th>\n",
       "      <th>has_interaction_toxic</th>\n",
       "      <th>has_no_pool_interaction</th>\n",
       "      <th>has_interaction_airdrop_m</th>\n",
       "      <th>has_interaction_tornado</th>\n",
       "      <th>has_interaction_disperse</th>\n",
       "      <th>count_flags</th>\n",
       "      <th>suspicious_1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>0x2e3e22f9f4d2de3dbdee9cbf350e22afb1c1d6b9</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>348</th>\n",
       "      <td>0x588f6ccb39f3d474c5b3736483589e2bbc8e0847</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>439</th>\n",
       "      <td>0x70b224998167a500ef39ed91e35ad133d996e744</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445</th>\n",
       "      <td>0x71f84aa585e1eda8852dad8dff3a69d114366dba</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>447</th>\n",
       "      <td>0x7267db34b6072080923f92e626c2fc5da91ff25b</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>455</th>\n",
       "      <td>0x745339df47cb4186be2fc573e81d50e598b99aef</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>556</th>\n",
       "      <td>0x921f80499a00ac6e95aae0daa411d338f41d5da2</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>636</th>\n",
       "      <td>0xa34faa5b9b9e29c191e163a520edeea93a574ba3</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>685</th>\n",
       "      <td>0xae65dfac43c1dd0b4e4976128d654adf597f756c</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>687</th>\n",
       "      <td>0xaee2e6432db54a6f3770d57f1108cd326f2b224f</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>749</th>\n",
       "      <td>0xbb49ccec023dc369844eec3190503853b1380606</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>908</th>\n",
       "      <td>0xe4c140a67a3a95913a6e2fcfc6d6434d94c07641</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>924</th>\n",
       "      <td>0xe8fb09228d1373f931007ca7894a08344b80901c</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1020</th>\n",
       "      <td>0xff56ec56a405716accaa4e6c54aef7fa2948192e</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         address  seed_same_naive  seed_same   \n",
       "172   0x2e3e22f9f4d2de3dbdee9cbf350e22afb1c1d6b9            False      False  \\\n",
       "348   0x588f6ccb39f3d474c5b3736483589e2bbc8e0847            False      False   \n",
       "439   0x70b224998167a500ef39ed91e35ad133d996e744            False      False   \n",
       "445   0x71f84aa585e1eda8852dad8dff3a69d114366dba            False      False   \n",
       "447   0x7267db34b6072080923f92e626c2fc5da91ff25b             True       True   \n",
       "455   0x745339df47cb4186be2fc573e81d50e598b99aef             True       True   \n",
       "556   0x921f80499a00ac6e95aae0daa411d338f41d5da2            False      False   \n",
       "636   0xa34faa5b9b9e29c191e163a520edeea93a574ba3            False      False   \n",
       "685   0xae65dfac43c1dd0b4e4976128d654adf597f756c            False      False   \n",
       "687   0xaee2e6432db54a6f3770d57f1108cd326f2b224f            False      False   \n",
       "749   0xbb49ccec023dc369844eec3190503853b1380606            False      False   \n",
       "908   0xe4c140a67a3a95913a6e2fcfc6d6434d94c07641             True       True   \n",
       "924   0xe8fb09228d1373f931007ca7894a08344b80901c            False      False   \n",
       "1020  0xff56ec56a405716accaa4e6c54aef7fa2948192e            False      False   \n",
       "\n",
       "      seed_suspicious  less_5_tx  less_10_tx  interacted_other_ctbt   \n",
       "172             False      False       False                   True  \\\n",
       "348             False      False       False                  False   \n",
       "439             False      False       False                   True   \n",
       "445             False      False       False                  False   \n",
       "447             False      False       False                   True   \n",
       "455             False      False       False                  False   \n",
       "556             False      False       False                   True   \n",
       "636             False      False       False                   True   \n",
       "685             False      False       False                   True   \n",
       "687             False      False       False                   True   \n",
       "749             False      False       False                   True   \n",
       "908             False      False       False                  False   \n",
       "924             False      False       False                   True   \n",
       "1020            False      False       False                  False   \n",
       "\n",
       "      count_interaction_with_pool  count_interaction_with_toxic   \n",
       "172                             5                             0  \\\n",
       "348                            14                             0   \n",
       "439                             2                             0   \n",
       "445                             8                             0   \n",
       "447                             3                             0   \n",
       "455                             0                             0   \n",
       "556                             3                             0   \n",
       "636                             3                             0   \n",
       "685                             0                             0   \n",
       "687                             2                             0   \n",
       "749                             2                             0   \n",
       "908                            18                             0   \n",
       "924                             5                             0   \n",
       "1020                            1                             0   \n",
       "\n",
       "      count_interaction_with_airdrop_m  is_airdrop_master   \n",
       "172                                 12               True  \\\n",
       "348                                  0              False   \n",
       "439                                  4               True   \n",
       "445                                  1               True   \n",
       "447                                  2              False   \n",
       "455                                  1              False   \n",
       "556                                  0              False   \n",
       "636                                 42              False   \n",
       "685                                  5              False   \n",
       "687                                 19              False   \n",
       "749                                 18              False   \n",
       "908                                  2              False   \n",
       "924                                 20              False   \n",
       "1020                                 4              False   \n",
       "\n",
       "      count_interaction_with_tornado  count_interaction_with_disperse   \n",
       "172                                0                                0  \\\n",
       "348                                1                                0   \n",
       "439                                0                                0   \n",
       "445                                0                                0   \n",
       "447                                0                                0   \n",
       "455                                0                                0   \n",
       "556                                1                                0   \n",
       "636                                1                                0   \n",
       "685                                0                                0   \n",
       "687                                0                                0   \n",
       "749                                0                                0   \n",
       "908                                0                                0   \n",
       "924                                0                                0   \n",
       "1020                               0                                0   \n",
       "\n",
       "      has_interaction_toxic  has_no_pool_interaction   \n",
       "172                   False                     True  \\\n",
       "348                   False                    False   \n",
       "439                   False                     True   \n",
       "445                   False                    False   \n",
       "447                   False                     True   \n",
       "455                   False                     True   \n",
       "556                   False                     True   \n",
       "636                   False                     True   \n",
       "685                   False                     True   \n",
       "687                   False                     True   \n",
       "749                   False                     True   \n",
       "908                   False                    False   \n",
       "924                   False                     True   \n",
       "1020                  False                     True   \n",
       "\n",
       "      has_interaction_airdrop_m  has_interaction_tornado   \n",
       "172                        True                    False  \\\n",
       "348                       False                     True   \n",
       "439                        True                    False   \n",
       "445                        True                    False   \n",
       "447                        True                    False   \n",
       "455                        True                    False   \n",
       "556                       False                     True   \n",
       "636                        True                     True   \n",
       "685                        True                    False   \n",
       "687                        True                    False   \n",
       "749                        True                    False   \n",
       "908                        True                    False   \n",
       "924                        True                    False   \n",
       "1020                       True                    False   \n",
       "\n",
       "      has_interaction_disperse  count_flags  suspicious_1  \n",
       "172                      False            4          True  \n",
       "348                      False            1         False  \n",
       "439                      False            4          True  \n",
       "445                      False            2         False  \n",
       "447                      False            3          True  \n",
       "455                      False            2         False  \n",
       "556                      False            3          True  \n",
       "636                      False            4          True  \n",
       "685                      False            3          True  \n",
       "687                      False            3          True  \n",
       "749                      False            3          True  \n",
       "908                      False            1         False  \n",
       "924                      False            3          True  \n",
       "1020                     False            2         False  "
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_matching_address[df_matching_address['address'].isin(same_amount.index)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "same_amount_tx = df_tx[np.logical_or(df_tx['from_address'].isin(same_amount.index), df_tx['to_address'].isin(same_amount.index))]\n",
    "txa_same_amount = txa(same_amount_tx, pd.DataFrame(same_amount.index, columns=['address']))"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "All true values mean that the wallet are connected between themselves in that small cluster of addresses"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([ True, False,  True, False,  True, False,  True,  True,  True,\n",
       "        True,  True, False,  True, False])"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "same_amount.reset_index()['voter'].apply(lambda x : txa_same_amount.has_interacted_with_other_contributor(x)).values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "45"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# explore other suspicious addresses\n",
    "add_sus = gb_donation_usd[np.logical_and(gb_donation_usd['count'] == 1, gb_donation_usd['mean'] < 25)].index.values\n",
    "len(add_sus)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_1_donation = df_vote_interact_sus[df_vote_interact_sus['voter'].isin(add_sus)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of votes 45 Number of projects voted: 28\n"
     ]
    },
    {
     "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>grantAddress</th>\n",
       "      <th>metadata.application.project.title</th>\n",
       "      <th>count</th>\n",
       "      <th>roundId</th>\n",
       "      <th>status</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0x4adc8cc149a03f44386bee80bab36f9e8022b195</td>\n",
       "      <td>Unitap</td>\n",
       "      <td>9</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0xf26d1bb347a59f6c283c53156519cc1b1abaca51</td>\n",
       "      <td>BanklessDAO Projects</td>\n",
       "      <td>4</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0x4cd6b4503d02973d78cff59c9c56f5f378688274</td>\n",
       "      <td>Mechanism Institute: Democratizing Cryptoecono...</td>\n",
       "      <td>3</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0xaa163c47065c22d17ed1c47e3e244337d2056c17</td>\n",
       "      <td>JobStash</td>\n",
       "      <td>2</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0x8efef51d19ef3844c00076ab9d02847b9c70f94a</td>\n",
       "      <td>Pentacle</td>\n",
       "      <td>2</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0xdb587c215626cc38c04f9e283e159f3907791baf</td>\n",
       "      <td>xBound</td>\n",
       "      <td>2</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0xd6823f807c45efdc56c9ae8db0226ca10af6e8ab</td>\n",
       "      <td>登链社区(Upchain)</td>\n",
       "      <td>2</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0x98714debf8c3114cffbdf04bb49c2e24c899c932</td>\n",
       "      <td>Open Town</td>\n",
       "      <td>1</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0x486c853c41885d9c1edb57c423853fc4fbc60769</td>\n",
       "      <td>Blu3 Global</td>\n",
       "      <td>1</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0x2ec655969160ab38d308140f3817a0e3be0ca9f2</td>\n",
       "      <td>KultureCity F THE NEVERS</td>\n",
       "      <td>1</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0x36f322fc85b24ab13263cfe9217b28f8e2b38381</td>\n",
       "      <td>Blocktrend（區塊勢）</td>\n",
       "      <td>1</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0x92ed8f6a9211f9eb0f16c83a052e75099b7bf4a5</td>\n",
       "      <td>Web3TalentFair</td>\n",
       "      <td>1</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0x3c8ad6f38a060a5b01af26fe1e1ed9c50c32902b</td>\n",
       "      <td>ReFi Japan</td>\n",
       "      <td>1</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>0xe82a0db3cf329844f22547fe0ef84eca8108e008</td>\n",
       "      <td>VoiceDeck: A Marketplace for Journalism Impact...</td>\n",
       "      <td>1</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0x743b8e21eb7bd3cb81e521b5f3e7f3c6fbe61d33</td>\n",
       "      <td>GreenPill Global</td>\n",
       "      <td>1</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>0xf2f099d2d133e2f3d1ed8417ca71e914a3185897</td>\n",
       "      <td>Crypto Fundraising</td>\n",
       "      <td>1</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0x2e8e95dbeb137a24469e711079ad483d081166f7</td>\n",
       "      <td>Boring Security</td>\n",
       "      <td>1</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0xb79f0156573a54e852fb9ac7b5bc6250b33405a0</td>\n",
       "      <td>Web3ForGood</td>\n",
       "      <td>1</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0x300da191248a500b2174aed992d6697bf97f9139</td>\n",
       "      <td>DAZE</td>\n",
       "      <td>1</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0x9dcba70b2dfe5807e2a847e065ebb666791f8b8a</td>\n",
       "      <td>B&lt;&gt;rder/ess</td>\n",
       "      <td>1</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0xc36e4889a820bd8089a8ad226ee9d0c703aed314</td>\n",
       "      <td>Crypto Babes Club</td>\n",
       "      <td>1</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0x5c69b671b91df2d8b0f7f5d962ae39c80388caf9</td>\n",
       "      <td>ENS DAO Newsletter</td>\n",
       "      <td>1</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0x3d2c7d934d0b0f2979de988e0092aa8c2ccfc638</td>\n",
       "      <td>Revolte</td>\n",
       "      <td>1</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0x50b25efa4a8b2eb1986e3bfbdc1f4ade756c806c</td>\n",
       "      <td>H.E.R. DAO</td>\n",
       "      <td>1</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0x2242f42f5ac525d967dfa9f21098160870edd978</td>\n",
       "      <td>Techstation</td>\n",
       "      <td>1</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0x4a44a94dfcd91d6a269fef0f167133f3231a7338</td>\n",
       "      <td>CreatorDAO</td>\n",
       "      <td>1</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0xaf66321c8cce672c1140bf8c2d3c0dbc07c15c56</td>\n",
       "      <td>SEED Latam</td>\n",
       "      <td>1</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0x32b74b90407309f6637245292cd90347de658a37</td>\n",
       "      <td>Somer Esat Ethereum Staking Guides (Ubuntu)</td>\n",
       "      <td>1</td>\n",
       "      <td>0xaa40e2e5c8df03d792a52b5458959c320f86ca18</td>\n",
       "      <td>APPROVED</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  grantAddress   \n",
       "0   0x4adc8cc149a03f44386bee80bab36f9e8022b195  \\\n",
       "1   0xf26d1bb347a59f6c283c53156519cc1b1abaca51   \n",
       "2   0x4cd6b4503d02973d78cff59c9c56f5f378688274   \n",
       "3   0xaa163c47065c22d17ed1c47e3e244337d2056c17   \n",
       "4   0x8efef51d19ef3844c00076ab9d02847b9c70f94a   \n",
       "5   0xdb587c215626cc38c04f9e283e159f3907791baf   \n",
       "6   0xd6823f807c45efdc56c9ae8db0226ca10af6e8ab   \n",
       "22  0x98714debf8c3114cffbdf04bb49c2e24c899c932   \n",
       "19  0x486c853c41885d9c1edb57c423853fc4fbc60769   \n",
       "20  0x2ec655969160ab38d308140f3817a0e3be0ca9f2   \n",
       "21  0x36f322fc85b24ab13263cfe9217b28f8e2b38381   \n",
       "25  0x92ed8f6a9211f9eb0f16c83a052e75099b7bf4a5   \n",
       "23  0x3c8ad6f38a060a5b01af26fe1e1ed9c50c32902b   \n",
       "24  0xe82a0db3cf329844f22547fe0ef84eca8108e008   \n",
       "17  0x743b8e21eb7bd3cb81e521b5f3e7f3c6fbe61d33   \n",
       "26  0xf2f099d2d133e2f3d1ed8417ca71e914a3185897   \n",
       "18  0x2e8e95dbeb137a24469e711079ad483d081166f7   \n",
       "14  0xb79f0156573a54e852fb9ac7b5bc6250b33405a0   \n",
       "16  0x300da191248a500b2174aed992d6697bf97f9139   \n",
       "15  0x9dcba70b2dfe5807e2a847e065ebb666791f8b8a   \n",
       "13  0xc36e4889a820bd8089a8ad226ee9d0c703aed314   \n",
       "12  0x5c69b671b91df2d8b0f7f5d962ae39c80388caf9   \n",
       "11  0x3d2c7d934d0b0f2979de988e0092aa8c2ccfc638   \n",
       "10  0x50b25efa4a8b2eb1986e3bfbdc1f4ade756c806c   \n",
       "9   0x2242f42f5ac525d967dfa9f21098160870edd978   \n",
       "8   0x4a44a94dfcd91d6a269fef0f167133f3231a7338   \n",
       "7   0xaf66321c8cce672c1140bf8c2d3c0dbc07c15c56   \n",
       "27  0x32b74b90407309f6637245292cd90347de658a37   \n",
       "\n",
       "                   metadata.application.project.title  count   \n",
       "0                                              Unitap      9  \\\n",
       "1                                BanklessDAO Projects      4   \n",
       "2   Mechanism Institute: Democratizing Cryptoecono...      3   \n",
       "3                                            JobStash      2   \n",
       "4                                            Pentacle      2   \n",
       "5                                              xBound      2   \n",
       "6                                       登链社区(Upchain)      2   \n",
       "22                                          Open Town      1   \n",
       "19                                        Blu3 Global      1   \n",
       "20                           KultureCity F THE NEVERS      1   \n",
       "21                                    Blocktrend（區塊勢）      1   \n",
       "25                                     Web3TalentFair      1   \n",
       "23                                         ReFi Japan      1   \n",
       "24  VoiceDeck: A Marketplace for Journalism Impact...      1   \n",
       "17                                  GreenPill Global       1   \n",
       "26                                 Crypto Fundraising      1   \n",
       "18                                    Boring Security      1   \n",
       "14                                        Web3ForGood      1   \n",
       "16                                               DAZE      1   \n",
       "15                                        B<>rder/ess      1   \n",
       "13                                  Crypto Babes Club      1   \n",
       "12                                 ENS DAO Newsletter      1   \n",
       "11                                            Revolte      1   \n",
       "10                                        H.E.R. DAO       1   \n",
       "9                                         Techstation      1   \n",
       "8                                          CreatorDAO      1   \n",
       "7                                          SEED Latam      1   \n",
       "27        Somer Esat Ethereum Staking Guides (Ubuntu)      1   \n",
       "\n",
       "                                       roundId    status  \n",
       "0   0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "1   0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "2   0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "3   0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "4   0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "5   0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "6   0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "22  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "19  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "20  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "21  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "25  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "23  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "24  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "17  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "26  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "18  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "14  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "16  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "15  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "13  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "12  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "11  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "10  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "9   0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "8   0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "7   0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  \n",
       "27  0xaa40e2e5c8df03d792a52b5458959c320f86ca18  APPROVED  "
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(f'Number of votes {df_1_donation.shape[0]} Number of projects voted: {df_1_donation.grantAddress.nunique()}')\n",
    "# Merge the project the user voted for and the projects \n",
    "gr_sus = df_1_donation['grantAddress'].value_counts().reset_index().merge(df_application, left_on='grantAddress', right_on='metadata.application.recipient', how='left').drop_duplicates(subset='grantAddress').loc[:, ['grantAddress', 'metadata.application.project.title', 'count', 'roundId', 'status']].reset_index(drop=True)\n",
    "gr_sus.sort_values(by='count', ascending=False)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "By reviewing manually I did not find that any of these projects were suspicious."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "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>address</th>\n",
       "      <th>seed_same_naive</th>\n",
       "      <th>seed_same</th>\n",
       "      <th>seed_suspicious</th>\n",
       "      <th>less_5_tx</th>\n",
       "      <th>less_10_tx</th>\n",
       "      <th>interacted_other_ctbt</th>\n",
       "      <th>count_interaction_with_pool</th>\n",
       "      <th>count_interaction_with_toxic</th>\n",
       "      <th>count_interaction_with_airdrop_m</th>\n",
       "      <th>is_airdrop_master</th>\n",
       "      <th>count_interaction_with_tornado</th>\n",
       "      <th>count_interaction_with_disperse</th>\n",
       "      <th>has_interaction_toxic</th>\n",
       "      <th>has_no_pool_interaction</th>\n",
       "      <th>has_interaction_airdrop_m</th>\n",
       "      <th>has_interaction_tornado</th>\n",
       "      <th>has_interaction_disperse</th>\n",
       "      <th>count_flags</th>\n",
       "      <th>suspicious_1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>0x0a251df99a88a20a93876205fb7f5faf2e85a481</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>106</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>True</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>0x0bb602f88bf886282ff69d4cec937cc2a7d9e19a</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>15</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>0x293c173b0ae90cd27c349cd8892efa625a98dbae</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>308</th>\n",
       "      <td>0x504c11bdbe6e29b46e23e9a15d9c8d2e2e795709</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>356</th>\n",
       "      <td>0x5a930b098ed8d58dd4590577af85a8e864a8f6fe</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>427</th>\n",
       "      <td>0x6d526f6b4c86fbdc8e359e6bef4cd6a42acea2d7</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>460</th>\n",
       "      <td>0x767a60f295aedd958932088f9cd6a4951d8739b6</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>78</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>481</th>\n",
       "      <td>0x7bc1d6e8150d4c96917901c26c922dd64654b3c3</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>64</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>0x85274906f537e0aa3823855bd6a0e374c771d19b</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>563</th>\n",
       "      <td>0x93907de38066d70109935732757b625d636e47b6</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>585</th>\n",
       "      <td>0x984b18b1823fef04a4ca7cf1e8a0ef5359fa522f</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>596</th>\n",
       "      <td>0x9aa470470cac9ab75e2b8648c9c054560749b33d</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>597</th>\n",
       "      <td>0x9b278aaef429cc4728e594f8fa0fbfe78e72cc26</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>642</th>\n",
       "      <td>0xa4ca1b15fe81f57cb2d3f686c7b13309906cd37b</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>82</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>684</th>\n",
       "      <td>0xae5679c84371d53c7e2bb2870f9d00e92d506e0c</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>821</th>\n",
       "      <td>0xcf61ebd3613684a53e48ee85d8fbc80c5156c479</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>898</th>\n",
       "      <td>0xe04885c3f1419c6e8495c33bdcf5f8387cd88846</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1002</th>\n",
       "      <td>0xfb40932271fc9db9dbf048e80697e2da4aa57250</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>76</td>\n",
       "      <td>1</td>\n",
       "      <td>68</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>5</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         address  seed_same_naive  seed_same   \n",
       "36    0x0a251df99a88a20a93876205fb7f5faf2e85a481            False      False  \\\n",
       "45    0x0bb602f88bf886282ff69d4cec937cc2a7d9e19a             True       True   \n",
       "158   0x293c173b0ae90cd27c349cd8892efa625a98dbae            False      False   \n",
       "308   0x504c11bdbe6e29b46e23e9a15d9c8d2e2e795709            False      False   \n",
       "356   0x5a930b098ed8d58dd4590577af85a8e864a8f6fe             True       True   \n",
       "427   0x6d526f6b4c86fbdc8e359e6bef4cd6a42acea2d7             True       True   \n",
       "460   0x767a60f295aedd958932088f9cd6a4951d8739b6            False      False   \n",
       "481   0x7bc1d6e8150d4c96917901c26c922dd64654b3c3             True       True   \n",
       "510   0x85274906f537e0aa3823855bd6a0e374c771d19b            False      False   \n",
       "563   0x93907de38066d70109935732757b625d636e47b6             True       True   \n",
       "585   0x984b18b1823fef04a4ca7cf1e8a0ef5359fa522f            False      False   \n",
       "596   0x9aa470470cac9ab75e2b8648c9c054560749b33d            False      False   \n",
       "597   0x9b278aaef429cc4728e594f8fa0fbfe78e72cc26             True       True   \n",
       "642   0xa4ca1b15fe81f57cb2d3f686c7b13309906cd37b             True       True   \n",
       "684   0xae5679c84371d53c7e2bb2870f9d00e92d506e0c             True       True   \n",
       "821   0xcf61ebd3613684a53e48ee85d8fbc80c5156c479             True       True   \n",
       "898   0xe04885c3f1419c6e8495c33bdcf5f8387cd88846             True       True   \n",
       "1002  0xfb40932271fc9db9dbf048e80697e2da4aa57250            False      False   \n",
       "\n",
       "      seed_suspicious  less_5_tx  less_10_tx  interacted_other_ctbt   \n",
       "36              False      False       False                  False  \\\n",
       "45              False      False       False                  False   \n",
       "158             False      False       False                   True   \n",
       "308             False      False       False                  False   \n",
       "356             False      False       False                   True   \n",
       "427             False      False       False                  False   \n",
       "460             False      False       False                  False   \n",
       "481             False      False       False                  False   \n",
       "510             False      False       False                   True   \n",
       "563             False      False       False                   True   \n",
       "585             False      False       False                  False   \n",
       "596             False      False       False                  False   \n",
       "597             False      False       False                  False   \n",
       "642             False      False       False                  False   \n",
       "684             False      False       False                  False   \n",
       "821             False      False       False                  False   \n",
       "898             False      False       False                  False   \n",
       "1002            False      False       False                   True   \n",
       "\n",
       "      count_interaction_with_pool  count_interaction_with_toxic   \n",
       "36                            106                             1  \\\n",
       "45                             15                             5   \n",
       "158                             0                             1   \n",
       "308                            34                             1   \n",
       "356                             0                             1   \n",
       "427                             6                             1   \n",
       "460                            78                             1   \n",
       "481                            64                             1   \n",
       "510                             4                             1   \n",
       "563                            16                             1   \n",
       "585                             4                             2   \n",
       "596                            14                             1   \n",
       "597                             0                             1   \n",
       "642                            82                             3   \n",
       "684                             8                             1   \n",
       "821                             7                             2   \n",
       "898                            33                             1   \n",
       "1002                           76                             1   \n",
       "\n",
       "      count_interaction_with_airdrop_m  is_airdrop_master   \n",
       "36                                  10               True  \\\n",
       "45                                   0              False   \n",
       "158                                  3              False   \n",
       "308                                 11              False   \n",
       "356                                  0              False   \n",
       "427                                  3               True   \n",
       "460                                  8               True   \n",
       "481                                  0              False   \n",
       "510                                  3              False   \n",
       "563                                  0              False   \n",
       "585                                 10              False   \n",
       "596                                  4              False   \n",
       "597                                  0              False   \n",
       "642                                  4              False   \n",
       "684                                  2              False   \n",
       "821                                  0              False   \n",
       "898                                  7               True   \n",
       "1002                                68               True   \n",
       "\n",
       "      count_interaction_with_tornado  count_interaction_with_disperse   \n",
       "36                                 1                                0  \\\n",
       "45                                 0                                0   \n",
       "158                                0                                0   \n",
       "308                                4                                2   \n",
       "356                                0                                0   \n",
       "427                                0                                0   \n",
       "460                                0                                0   \n",
       "481                                0                                0   \n",
       "510                                0                                0   \n",
       "563                                0                                0   \n",
       "585                                0                                0   \n",
       "596                                0                                0   \n",
       "597                                0                                0   \n",
       "642                                0                                0   \n",
       "684                                0                                0   \n",
       "821                                0                                0   \n",
       "898                                0                                0   \n",
       "1002                               0                                1   \n",
       "\n",
       "      has_interaction_toxic  has_no_pool_interaction   \n",
       "36                     True                    False  \\\n",
       "45                     True                    False   \n",
       "158                    True                     True   \n",
       "308                    True                    False   \n",
       "356                    True                     True   \n",
       "427                    True                    False   \n",
       "460                    True                    False   \n",
       "481                    True                    False   \n",
       "510                    True                     True   \n",
       "563                    True                    False   \n",
       "585                    True                     True   \n",
       "596                    True                    False   \n",
       "597                    True                     True   \n",
       "642                    True                    False   \n",
       "684                    True                    False   \n",
       "821                    True                    False   \n",
       "898                    True                    False   \n",
       "1002                   True                    False   \n",
       "\n",
       "      has_interaction_airdrop_m  has_interaction_tornado   \n",
       "36                         True                     True  \\\n",
       "45                        False                    False   \n",
       "158                        True                    False   \n",
       "308                        True                     True   \n",
       "356                       False                    False   \n",
       "427                        True                    False   \n",
       "460                        True                    False   \n",
       "481                       False                    False   \n",
       "510                        True                    False   \n",
       "563                       False                    False   \n",
       "585                        True                    False   \n",
       "596                        True                    False   \n",
       "597                       False                    False   \n",
       "642                        True                    False   \n",
       "684                        True                    False   \n",
       "821                       False                    False   \n",
       "898                        True                    False   \n",
       "1002                       True                    False   \n",
       "\n",
       "      has_interaction_disperse  count_flags  suspicious_1  \n",
       "36                       False            4          True  \n",
       "45                       False            1         False  \n",
       "158                      False            4          True  \n",
       "308                       True            4          True  \n",
       "356                      False            3          True  \n",
       "427                      False            3          True  \n",
       "460                      False            3          True  \n",
       "481                      False            1         False  \n",
       "510                      False            4          True  \n",
       "563                      False            2         False  \n",
       "585                      False            3          True  \n",
       "596                      False            2         False  \n",
       "597                      False            2         False  \n",
       "642                      False            2         False  \n",
       "684                      False            2         False  \n",
       "821                      False            1         False  \n",
       "898                      False            3          True  \n",
       "1002                      True            5          True  "
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_matching_address[df_matching_address['has_interaction_toxic']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "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>address</th>\n",
       "      <th>seed_same_naive</th>\n",
       "      <th>seed_same</th>\n",
       "      <th>seed_suspicious</th>\n",
       "      <th>less_5_tx</th>\n",
       "      <th>less_10_tx</th>\n",
       "      <th>interacted_other_ctbt</th>\n",
       "      <th>count_interaction_with_pool</th>\n",
       "      <th>count_interaction_with_toxic</th>\n",
       "      <th>count_interaction_with_airdrop_m</th>\n",
       "      <th>is_airdrop_master</th>\n",
       "      <th>count_interaction_with_tornado</th>\n",
       "      <th>count_interaction_with_disperse</th>\n",
       "      <th>has_interaction_toxic</th>\n",
       "      <th>has_no_pool_interaction</th>\n",
       "      <th>has_interaction_airdrop_m</th>\n",
       "      <th>has_interaction_tornado</th>\n",
       "      <th>has_interaction_disperse</th>\n",
       "      <th>count_flags</th>\n",
       "      <th>suspicious_1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>0x52432473144056fe91aeae9240ad21e6b8213440</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>5</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>503</th>\n",
       "      <td>0x839395e20bbb182fa440d08f850e6c7a8f6f0780</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>245</td>\n",
       "      <td>0</td>\n",
       "      <td>96</td>\n",
       "      <td>True</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>5</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>561</th>\n",
       "      <td>0x9325564ade7683706107685cf1993678b1163261</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>59</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>True</td>\n",
       "      <td>18</td>\n",
       "      <td>16</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>696</th>\n",
       "      <td>0xb08f95dbc639621dbaf48a472ae8fce0f6f56a6e</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>56</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>857</th>\n",
       "      <td>0xd6f5646d9e7fbee7cc907eb8e12dafa5378431e6</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>True</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>5</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1002</th>\n",
       "      <td>0xfb40932271fc9db9dbf048e80697e2da4aa57250</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>76</td>\n",
       "      <td>1</td>\n",
       "      <td>68</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>5</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         address  seed_same_naive  seed_same   \n",
       "319   0x52432473144056fe91aeae9240ad21e6b8213440            False      False  \\\n",
       "503   0x839395e20bbb182fa440d08f850e6c7a8f6f0780            False      False   \n",
       "561   0x9325564ade7683706107685cf1993678b1163261            False      False   \n",
       "696   0xb08f95dbc639621dbaf48a472ae8fce0f6f56a6e             True       True   \n",
       "857   0xd6f5646d9e7fbee7cc907eb8e12dafa5378431e6            False      False   \n",
       "1002  0xfb40932271fc9db9dbf048e80697e2da4aa57250            False      False   \n",
       "\n",
       "      seed_suspicious  less_5_tx  less_10_tx  interacted_other_ctbt   \n",
       "319             False      False       False                   True  \\\n",
       "503             False      False       False                   True   \n",
       "561             False      False       False                  False   \n",
       "696             False      False       False                   True   \n",
       "857             False      False       False                   True   \n",
       "1002            False      False       False                   True   \n",
       "\n",
       "      count_interaction_with_pool  count_interaction_with_toxic   \n",
       "319                             3                             0  \\\n",
       "503                           245                             0   \n",
       "561                            59                             0   \n",
       "696                            56                             0   \n",
       "857                            14                             0   \n",
       "1002                           76                             1   \n",
       "\n",
       "      count_interaction_with_airdrop_m  is_airdrop_master   \n",
       "319                                  4               True  \\\n",
       "503                                 96               True   \n",
       "561                                 10               True   \n",
       "696                                 40               True   \n",
       "857                                 40               True   \n",
       "1002                                68               True   \n",
       "\n",
       "      count_interaction_with_tornado  count_interaction_with_disperse   \n",
       "319                                0                                1  \\\n",
       "503                                8                                1   \n",
       "561                               18                               16   \n",
       "696                                0                                3   \n",
       "857                                1                                1   \n",
       "1002                               0                                1   \n",
       "\n",
       "      has_interaction_toxic  has_no_pool_interaction   \n",
       "319                   False                     True  \\\n",
       "503                   False                    False   \n",
       "561                   False                    False   \n",
       "696                   False                    False   \n",
       "857                   False                    False   \n",
       "1002                   True                    False   \n",
       "\n",
       "      has_interaction_airdrop_m  has_interaction_tornado   \n",
       "319                        True                    False  \\\n",
       "503                        True                     True   \n",
       "561                        True                     True   \n",
       "696                        True                    False   \n",
       "857                        True                     True   \n",
       "1002                       True                    False   \n",
       "\n",
       "      has_interaction_disperse  count_flags  suspicious_1  \n",
       "319                       True            5          True  \n",
       "503                       True            5          True  \n",
       "561                       True            4          True  \n",
       "696                       True            4          True  \n",
       "857                       True            5          True  \n",
       "1002                      True            5          True  "
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_matching_address[np.logical_and(np.logical_and(df_matching_address['has_interaction_airdrop_m'], df_matching_address['is_airdrop_master']), df_matching_address['has_interaction_disperse'])]"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Amost every airdrop master has interacted with another aidrop master. This is very suspicious. It means they are very connected to each other. These addresses are probably controlled by the same person or a group of person and thus their donation should not be matched."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "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>address</th>\n",
       "      <th>seed_same_naive</th>\n",
       "      <th>seed_same</th>\n",
       "      <th>seed_suspicious</th>\n",
       "      <th>less_5_tx</th>\n",
       "      <th>less_10_tx</th>\n",
       "      <th>interacted_other_ctbt</th>\n",
       "      <th>count_interaction_with_pool</th>\n",
       "      <th>count_interaction_with_toxic</th>\n",
       "      <th>count_interaction_with_airdrop_m</th>\n",
       "      <th>is_airdrop_master</th>\n",
       "      <th>count_interaction_with_tornado</th>\n",
       "      <th>count_interaction_with_disperse</th>\n",
       "      <th>has_interaction_toxic</th>\n",
       "      <th>has_no_pool_interaction</th>\n",
       "      <th>has_interaction_airdrop_m</th>\n",
       "      <th>has_interaction_tornado</th>\n",
       "      <th>has_interaction_disperse</th>\n",
       "      <th>count_flags</th>\n",
       "      <th>suspicious_1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>0x52432473144056fe91aeae9240ad21e6b8213440</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>5</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>503</th>\n",
       "      <td>0x839395e20bbb182fa440d08f850e6c7a8f6f0780</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>245</td>\n",
       "      <td>0</td>\n",
       "      <td>96</td>\n",
       "      <td>True</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>5</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>416</th>\n",
       "      <td>0x693edbcf118ec982f5a8101498b6c789470b0b89</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>5</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>449</th>\n",
       "      <td>0x7307174ed422e37cb5254b944ffa762907f0b41b</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>5</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>453</th>\n",
       "      <td>0x74160cb9d7900c65e9f716bf3fde36c0ec335a78</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>5</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>857</th>\n",
       "      <td>0xd6f5646d9e7fbee7cc907eb8e12dafa5378431e6</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>True</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>5</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1002</th>\n",
       "      <td>0xfb40932271fc9db9dbf048e80697e2da4aa57250</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>76</td>\n",
       "      <td>1</td>\n",
       "      <td>68</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>5</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>561</th>\n",
       "      <td>0x9325564ade7683706107685cf1993678b1163261</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>59</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>True</td>\n",
       "      <td>18</td>\n",
       "      <td>16</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>702</th>\n",
       "      <td>0xb1b7586656116d546033e3baff69bfcd6592225e</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>86</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>0x293c173b0ae90cd27c349cd8892efa625a98dbae</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>0x2e3e22f9f4d2de3dbdee9cbf350e22afb1c1d6b9</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>0x2e586806e193d22bbfbe9c466a35456c7bf73b5b</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>830</th>\n",
       "      <td>0xd11b4b2a4b9b31bf4e8f879e2036ddccab6fcb6f</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>811</th>\n",
       "      <td>0xccc6848c9f8d31ff6bf3136e5845b3f57f59b47a</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>0x32cefb2dc869bbfe636f7547cda43f561bf88d5a</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>797</th>\n",
       "      <td>0xc94caa5b4c1136fb1facd5dea83f25ec6a6cbd65</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>523</th>\n",
       "      <td>0x89343fbf39e484bbf502a9b564b3c9dfeb1b6e59</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>763</th>\n",
       "      <td>0xbe0284a4a260df4c58eec491d41995ceee3fac58</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270</th>\n",
       "      <td>0x46ce1348b3dd340a9323aa21ed6c3a90359882ca</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>713</th>\n",
       "      <td>0xb310d025e6054233b1f4b083bd9228197e7fd2d8</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         address  seed_same_naive  seed_same   \n",
       "319   0x52432473144056fe91aeae9240ad21e6b8213440            False      False  \\\n",
       "503   0x839395e20bbb182fa440d08f850e6c7a8f6f0780            False      False   \n",
       "416   0x693edbcf118ec982f5a8101498b6c789470b0b89            False      False   \n",
       "449   0x7307174ed422e37cb5254b944ffa762907f0b41b            False      False   \n",
       "453   0x74160cb9d7900c65e9f716bf3fde36c0ec335a78             True       True   \n",
       "857   0xd6f5646d9e7fbee7cc907eb8e12dafa5378431e6            False      False   \n",
       "1002  0xfb40932271fc9db9dbf048e80697e2da4aa57250            False      False   \n",
       "561   0x9325564ade7683706107685cf1993678b1163261            False      False   \n",
       "702   0xb1b7586656116d546033e3baff69bfcd6592225e             True       True   \n",
       "158   0x293c173b0ae90cd27c349cd8892efa625a98dbae            False      False   \n",
       "172   0x2e3e22f9f4d2de3dbdee9cbf350e22afb1c1d6b9            False      False   \n",
       "173   0x2e586806e193d22bbfbe9c466a35456c7bf73b5b             True       True   \n",
       "830   0xd11b4b2a4b9b31bf4e8f879e2036ddccab6fcb6f            False      False   \n",
       "811   0xccc6848c9f8d31ff6bf3136e5845b3f57f59b47a             True       True   \n",
       "194   0x32cefb2dc869bbfe636f7547cda43f561bf88d5a            False      False   \n",
       "797   0xc94caa5b4c1136fb1facd5dea83f25ec6a6cbd65            False      False   \n",
       "523   0x89343fbf39e484bbf502a9b564b3c9dfeb1b6e59             True       True   \n",
       "763   0xbe0284a4a260df4c58eec491d41995ceee3fac58             True       True   \n",
       "270   0x46ce1348b3dd340a9323aa21ed6c3a90359882ca             True       True   \n",
       "713   0xb310d025e6054233b1f4b083bd9228197e7fd2d8            False      False   \n",
       "\n",
       "      seed_suspicious  less_5_tx  less_10_tx  interacted_other_ctbt   \n",
       "319             False      False       False                   True  \\\n",
       "503             False      False       False                   True   \n",
       "416             False      False       False                   True   \n",
       "449             False       True        True                   True   \n",
       "453             False       True        True                   True   \n",
       "857             False      False       False                   True   \n",
       "1002            False      False       False                   True   \n",
       "561             False      False       False                  False   \n",
       "702             False      False       False                   True   \n",
       "158             False      False       False                   True   \n",
       "172             False      False       False                   True   \n",
       "173             False       True        True                   True   \n",
       "830             False      False        True                   True   \n",
       "811             False       True        True                   True   \n",
       "194             False      False       False                   True   \n",
       "797             False       True        True                   True   \n",
       "523             False       True        True                   True   \n",
       "763             False      False       False                  False   \n",
       "270             False       True        True                   True   \n",
       "713             False       True        True                   True   \n",
       "\n",
       "      count_interaction_with_pool  count_interaction_with_toxic   \n",
       "319                             3                             0  \\\n",
       "503                           245                             0   \n",
       "416                             1                             0   \n",
       "449                             0                             0   \n",
       "453                             0                             0   \n",
       "857                            14                             0   \n",
       "1002                           76                             1   \n",
       "561                            59                             0   \n",
       "702                            13                             0   \n",
       "158                             0                             1   \n",
       "172                             5                             0   \n",
       "173                             0                             0   \n",
       "830                             0                             0   \n",
       "811                             0                             0   \n",
       "194                             3                             0   \n",
       "797                             0                             0   \n",
       "523                             0                             0   \n",
       "763                             5                             0   \n",
       "270                             0                             0   \n",
       "713                             0                             0   \n",
       "\n",
       "      count_interaction_with_airdrop_m  is_airdrop_master   \n",
       "319                                  4               True  \\\n",
       "503                                 96               True   \n",
       "416                                  3               True   \n",
       "449                                  1              False   \n",
       "453                                  1              False   \n",
       "857                                 40               True   \n",
       "1002                                68               True   \n",
       "561                                 10               True   \n",
       "702                                 86               True   \n",
       "158                                  3              False   \n",
       "172                                 12               True   \n",
       "173                                  0              False   \n",
       "830                                  1              False   \n",
       "811                                  0              False   \n",
       "194                                  5               True   \n",
       "797                                  0              False   \n",
       "523                                  0              False   \n",
       "763                                  4               True   \n",
       "270                                  0              False   \n",
       "713                                  0              False   \n",
       "\n",
       "      count_interaction_with_tornado  count_interaction_with_disperse   \n",
       "319                                0                                1  \\\n",
       "503                                8                                1   \n",
       "416                                2                                0   \n",
       "449                                0                                0   \n",
       "453                                0                                0   \n",
       "857                                1                                1   \n",
       "1002                               0                                1   \n",
       "561                               18                               16   \n",
       "702                                3                                0   \n",
       "158                                0                                0   \n",
       "172                                0                                0   \n",
       "173                                0                                0   \n",
       "830                                0                                0   \n",
       "811                                0                                0   \n",
       "194                                0                                0   \n",
       "797                                0                                0   \n",
       "523                                0                                0   \n",
       "763                                2                                0   \n",
       "270                                0                                0   \n",
       "713                                0                                0   \n",
       "\n",
       "      has_interaction_toxic  has_no_pool_interaction   \n",
       "319                   False                     True  \\\n",
       "503                   False                    False   \n",
       "416                   False                     True   \n",
       "449                   False                     True   \n",
       "453                   False                     True   \n",
       "857                   False                    False   \n",
       "1002                   True                    False   \n",
       "561                   False                    False   \n",
       "702                   False                    False   \n",
       "158                    True                     True   \n",
       "172                   False                     True   \n",
       "173                   False                     True   \n",
       "830                   False                     True   \n",
       "811                   False                     True   \n",
       "194                   False                     True   \n",
       "797                   False                     True   \n",
       "523                   False                     True   \n",
       "763                   False                     True   \n",
       "270                   False                     True   \n",
       "713                   False                     True   \n",
       "\n",
       "      has_interaction_airdrop_m  has_interaction_tornado   \n",
       "319                        True                    False  \\\n",
       "503                        True                     True   \n",
       "416                        True                     True   \n",
       "449                        True                    False   \n",
       "453                        True                    False   \n",
       "857                        True                     True   \n",
       "1002                       True                    False   \n",
       "561                        True                     True   \n",
       "702                        True                     True   \n",
       "158                        True                    False   \n",
       "172                        True                    False   \n",
       "173                       False                    False   \n",
       "830                        True                    False   \n",
       "811                       False                    False   \n",
       "194                        True                    False   \n",
       "797                       False                    False   \n",
       "523                       False                    False   \n",
       "763                        True                     True   \n",
       "270                       False                    False   \n",
       "713                       False                    False   \n",
       "\n",
       "      has_interaction_disperse  count_flags  suspicious_1  \n",
       "319                       True            5          True  \n",
       "503                       True            5          True  \n",
       "416                      False            5          True  \n",
       "449                      False            5          True  \n",
       "453                      False            5          True  \n",
       "857                       True            5          True  \n",
       "1002                      True            5          True  \n",
       "561                       True            4          True  \n",
       "702                      False            4          True  \n",
       "158                      False            4          True  \n",
       "172                      False            4          True  \n",
       "173                      False            4          True  \n",
       "830                      False            4          True  \n",
       "811                      False            4          True  \n",
       "194                      False            4          True  \n",
       "797                      False            4          True  \n",
       "523                      False            4          True  \n",
       "763                      False            4          True  \n",
       "270                      False            4          True  \n",
       "713                      False            4          True  "
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_suspicious_1.sort_values(by='count_flags', ascending=False).head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [],
   "source": [
    "flag_bool =['has_interaction_toxic',\n",
    " 'has_interaction_airdrop_m',\n",
    " 'has_interaction_tornado',\n",
    " 'has_interaction_disperse',\n",
    " 'is_airdrop_master',\n",
    " 'less_5_tx']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of flagged addresses: 433 out of 1022\n"
     ]
    }
   ],
   "source": [
    "df_matching_address['flagged'] = df_matching_address[flag_bool].sum(axis=1) > 0\n",
    "print(f'Number of flagged addresses: {df_matching_address[\"flagged\"].sum()} out of {df_matching_address.shape[0]}')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_matching_address.to_csv('../suspicious_addresses.csv', index=False)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Almost half of the addresses are flagged"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Conclusion\n",
    "\n",
    "We have found a few suspicious projects and addresses. \n",
    "\n",
    "The proposed stamps for gitcoin passport is passed by 10% of the wallets only. This means it may be a good indicator of human behavior. However it is not enough to flag a wallet as suspicious if it does not have transaction with a decentralized exchange.\n",
    "\n",
    "The labels retrieved from Flipside Crypto are very useful and points to suspicious addresses that are colluding. They interact between themselves and with other suspicious addresses. This is a very good indicator of sybil behavior. And in particular the flag airdrop master. This addresses could be squelched.\n",
    "\n",
    "Some labels such as tornado cash is less usefull. \n",
    "\n",
    "In the contribuotrs 20% had less than 5 transactions that is a lot of wallets.\n",
    "\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "venvotes",
   "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.9"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}