gr-climate-exploration.ipynb

{
 "cells": [
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Sybil exploration grant climate"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import sys\n",
    "from pathlib import Path\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "pd.options.mode.chained_assignment = None"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sblegos.TransactionAnalyser import TransactionAnalyser\n",
    "from sbutils.LoadData import LoadData\n",
    "from sbdata.FlipsideApi import FlipsideApi"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "current_dir = Path(os.getcwd())"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Initialisation of the data"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Grant data initialisation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [],
   "source": [
    "path_to_grants = \"data/grants\"\n",
    "path_to_contributor_address = os.path.join(path_to_grants, \"address\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['df_contribution_address_CLIMATE.csv',\n",
       " 'df_contribution_address_ETHEREUM.csv',\n",
       " 'df_contribution_address_FANTOM.csv',\n",
       " 'df_contribution_address_GR15.csv',\n",
       " 'df_contribution_address_OSS.csv',\n",
       " 'df_contribution_address_UNICEF.csv',\n",
       " 'unique_ctbt_address.csv']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "full_path_add = os.path.join(current_dir, path_to_contributor_address)\n",
    "files = os.listdir(full_path_add)\n",
    "files"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [],
   "source": [
    "csv = files[0]\n",
    "gr_round = \"CLIMATE\"\n",
    "df_address = pd.read_csv(os.path.join(full_path_add, csv))\n",
    "list_address = df_address[\"address\"].tolist()"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The list_address is then used to load all the transactions from the grant data."
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Data loader initialisation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "c:\\Users\\DELL Admin\\Documents\\ODC\\DataBuilderHackathon\\transactions_full\n"
     ]
    }
   ],
   "source": [
    "path_to_parent = Path(current_dir).parent\n",
    "path_to_tx = os.path.join(path_to_parent, 'transactions_full')\n",
    "print(path_to_tx)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Initialize the data loader with the path to the transactions "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_loader = LoadData(path_to_tx)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The data loader is then used to load the data from the grant data. It takes some time to load the data. 3 minutes on my computer. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tx = data_loader.create_df_tx('ethereum', list_address)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Sybil scorer TransactionAnalyser initialisation and exploration"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "tx_analyser = TransactionAnalyser(df_tx, df_address=df_address)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Verify matching addresses because the transaction data is not always complete for a specific chain. ie an address may have contributed from a chain but have zero transactions on the studyed chain, here ethereum."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>0x001f41de6f455d6df74a669c6b21b6dda1bae644</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0x002153708f11f2651215059eea30820ee4d49ff3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      address\n",
       "0  0x001f41de6f455d6df74a669c6b21b6dda1bae644\n",
       "1  0x002153708f11f2651215059eea30820ee4d49ff3"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_matching_address = pd.DataFrame(df_tx.EOA.unique(), columns=[\"address\"])\n",
    "df_matching_address.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_matching_address.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_matching_address['seed_same_naive'] = df_matching_address.loc[:, 'address'].apply(lambda x : tx_analyser.has_same_seed_naive(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_matching_address['seed_same'] = df_matching_address.loc[:, 'address'].apply(lambda x : tx_analyser.has_same_seed(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_matching_address['seed_suspicious'] = df_matching_address.loc[:, 'seed_same_naive'].ne(df_matching_address.loc[:, 'seed_same'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "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))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "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": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_matching_address.set_index('address', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "seed_same_naive          1854\n",
       "seed_same                1887\n",
       "seed_suspicious            35\n",
       "less_5_tx                 843\n",
       "less_10_tx               1035\n",
       "interacted_other_ctbt     251\n",
       "dtype: int64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_matching_address.sum()"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Many addresses have the same seed wallet. This number should be lowered using tags to remove same wallet addresses comming from centralised exchange."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "list_same_seed_wallets = df_matching_address[np.logical_or(df_matching_address['seed_same_naive'], df_matching_address['seed_same'])].index.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_seeder = tx_analyser.df_seed_wallet"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "655\n"
     ]
    }
   ],
   "source": [
    "seeder = np.unique(df_seeder.from_address.values)\n",
    "print(len(seeder))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "FLIPSIDE_API_KEY = os.environ.get('FLIPSIDE_API_KEY')\n",
    "flipside_api  = FlipsideApi(FLIPSIDE_API_KEY)\n",
    "sql = flipside_api.get_cross_chain_info_sql_query(\n",
    "            seeder,\n",
    "            info_type=\"label\")\n",
    "df_labels = flipside_api.execute_query(sql)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "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>system_created_at</th>\n",
       "      <th>insert_date</th>\n",
       "      <th>blockchain</th>\n",
       "      <th>address</th>\n",
       "      <th>creator</th>\n",
       "      <th>label_type</th>\n",
       "      <th>label_subtype</th>\n",
       "      <th>address_name</th>\n",
       "      <th>project_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-01-03 20:43:08.094</td>\n",
       "      <td>2022-01-03 20:43:06.000</td>\n",
       "      <td>ethereum</td>\n",
       "      <td>0x9696f59e4d72e237be84ffd425dcad154bf96976</td>\n",
       "      <td>flipside</td>\n",
       "      <td>cex</td>\n",
       "      <td>hot_wallet</td>\n",
       "      <td>binance 18</td>\n",
       "      <td>binance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-11-30 00:15:28.111</td>\n",
       "      <td>2021-11-29 23:00:05.000</td>\n",
       "      <td>ethereum</td>\n",
       "      <td>0x96fc4553a00c117c5b0bed950dd625d1c16dc894</td>\n",
       "      <td>flipside</td>\n",
       "      <td>cex</td>\n",
       "      <td>hot_wallet</td>\n",
       "      <td>changelly</td>\n",
       "      <td>changelly</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         system_created_at              insert_date blockchain  \\\n",
       "0  2022-01-03 20:43:08.094  2022-01-03 20:43:06.000   ethereum   \n",
       "1  2021-11-30 00:15:28.111  2021-11-29 23:00:05.000   ethereum   \n",
       "\n",
       "                                      address   creator label_type  \\\n",
       "0  0x9696f59e4d72e237be84ffd425dcad154bf96976  flipside        cex   \n",
       "1  0x96fc4553a00c117c5b0bed950dd625d1c16dc894  flipside        cex   \n",
       "\n",
       "  label_subtype address_name project_name  \n",
       "0    hot_wallet   binance 18      binance  \n",
       "1    hot_wallet    changelly    changelly  "
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_labels.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "93"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_labels.shape[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['cex', 'dapp', 'operator', 'token'], dtype=object)"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_labels.label_type.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "sql = flipside_api.get_cross_chain_info_sql_query(\n",
    "            seeder,\n",
    "            info_type=\"tag\")\n",
    "df_tags = flipside_api.execute_query(sql)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: []\n",
       "Index: []"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tags"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "No tag where found in the seeders"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Lets remove these wallets from the case where has_same_seed is raised."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_matching_address['seed_without_label'] = df_seeder.apply(lambda x : x['from_address'] not in df_labels.address.values, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_matching_address.fillna(True, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_matching_address[\"same_seed_without_label\"] = np.logical_and(np.logical_or(df_matching_address['seed_same_naive'], df_matching_address['seed_same']), df_matching_address[\"seed_without_label\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "seed_same_naive            1854\n",
       "seed_same                  1887\n",
       "seed_suspicious              35\n",
       "less_5_tx                   843\n",
       "less_10_tx                 1035\n",
       "interacted_other_ctbt       251\n",
       "seed_without_label          707\n",
       "same_seed_without_label     176\n",
       "dtype: int64"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_matching_address.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_matching_reduced = df_matching_address.loc[:, ['seed_suspicious', 'less_5_tx', 'interacted_other_ctbt', 'same_seed_without_label']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "There are 1199 suspicious wallets out of 2463 wallets wich is a ratio of 49%.\n"
     ]
    }
   ],
   "source": [
    "suspicious_wallet_count = (df_matching_reduced.T.sum(axis=0) > 0).sum()\n",
    "total_wallet_count = df_matching_reduced.shape[0]\n",
    "print(f\"There are {suspicious_wallet_count} suspicious wallets out of {total_wallet_count} wallets wich is a ratio of {round(suspicious_wallet_count/total_wallet_count*100)}%.\")"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Now lets look at the project that have many suspicious contributors."
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We first load all the votes and then filter for the climate round"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\DELL Admin\\AppData\\Local\\Temp\\ipykernel_8116\\2868675674.py:1: DtypeWarning: Columns (0,4,7,10,11) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  df_contributions = pd.read_csv(os.path.join(path_to_grants, \"df_contribution_normalized.csv\"))\n"
     ]
    }
   ],
   "source": [
    "df_contributions = pd.read_csv(os.path.join(path_to_grants, \"df_contribution_normalized.csv\"))\n",
    "df_applications = pd.read_csv(os.path.join(path_to_grants, \"df_application_normalized.csv\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_ctbt_round = df_contributions.loc[df_contributions['project_round'] == gr_round,: ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(8556, 12)"
      ]
     },
     "execution_count": 93,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_ctbt_round.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['ctbt_id', 'ctbt_token', 'ctbt_amount', 'ctbt_address',\n",
       "       'project_address', 'ctbt_timestamp', 'project_round', 'checkout_type',\n",
       "       'ctbt_amount_in_usd', 'raw_amount_in_token', 'ctbt_tx_hash',\n",
       "       'ctbt_modified_on'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_ctbt_round.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2464"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_ctbt_round.ctbt_address.nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 174,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['CLIMATE'], dtype=object)"
      ]
     },
     "execution_count": 174,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_ctbt_round.project_round.unique()"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Many contributors have contributed several times to the climate grants. This is a sign that they are many sybils."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "812"
      ]
     },
     "execution_count": 98,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(df_ctbt_round.groupby('ctbt_address').ctbt_id.count() > 1).sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "project_address                             ctbt_address                              \n",
       "0x14cb60f6aca2b2a68d975743bacb33f01f587da5  0x67f06a56dbab410d1e06dc75493a1a09fc788047    3\n",
       "0x48f2696fb6fab7ac0956175b2e25b456e61b3fcf  0x67f06a56dbab410d1e06dc75493a1a09fc788047    3\n",
       "0x0f7272f8873b68b2a2f52685311822d831afc8b4  0x67f06a56dbab410d1e06dc75493a1a09fc788047    3\n",
       "0x41dde2dc7f718d5f764fc97e8d122864587642d4  0x67f06a56dbab410d1e06dc75493a1a09fc788047    3\n",
       "0x8d860d4f254ed45946f5fb0e3243c1db63a4ea2f  0x719028736f10164c838ef129936779ed739312f2    2\n",
       "                                                                                         ..\n",
       "0x41dde2dc7f718d5f764fc97e8d122864587642d4  0x140063a309fa9cab5f50c55ffd4fae592177a263    1\n",
       "                                            0x12b71792cb33186111f1a973e31c22c92547beae    1\n",
       "                                            0x12358f3801e916d7df8d86d7be9e48559837f6a7    1\n",
       "                                            0x10c0613d50cf8cd8886a9f248ce13d41b1d90faf    1\n",
       "0xfe97e32a873aa2f926fbfc560abeef01f753c128  0xf30bc2d6b591a648dbfa73ad1bc05f6bf2eeb565    1\n",
       "Name: ctbt_id, Length: 8275, dtype: int64"
      ]
     },
     "execution_count": 100,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_ctbt_round.groupby(['project_address', 'ctbt_address']).ctbt_id.count().sort_values(ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "metadata": {},
   "outputs": [],
   "source": [
    "gb_has_multi_ctbt_to_project = df_ctbt_round.groupby(['project_address', 'ctbt_address']).ctbt_id.count() > 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\DELL Admin\\AppData\\Local\\Temp\\ipykernel_8116\\1799691189.py:1: FutureWarning: The default value of numeric_only in DataFrameGroupBy.sum is deprecated. In a future version, numeric_only will default to False. Either specify numeric_only or select only columns which should be valid for the function.\n",
      "  has_multi_ctbt_to_project = gb_has_multi_ctbt_to_project.reset_index().groupby('ctbt_address').sum().sort_values(by='ctbt_id', ascending=False) > 0\n"
     ]
    }
   ],
   "source": [
    "has_multi_ctbt_to_project = gb_has_multi_ctbt_to_project.reset_index().groupby('ctbt_address').sum().sort_values(by='ctbt_id', ascending=False) > 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "69 out of 2464 wallets have contributed more than one time to a project.\n"
     ]
    }
   ],
   "source": [
    "print(f\"{has_multi_ctbt_to_project.sum().ctbt_id} out of {has_multi_ctbt_to_project.shape[0]} wallets have contributed more than one time to a project.\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_matching_reduced[\"many_ctbt_to_project\"] = has_multi_ctbt_to_project"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "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>seed_suspicious</th>\n",
       "      <th>less_5_tx</th>\n",
       "      <th>interacted_other_ctbt</th>\n",
       "      <th>same_seed_without_label</th>\n",
       "      <th>many_ctbt_to_project</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>address</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>0x001f41de6f455d6df74a669c6b21b6dda1bae644</th>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0x002153708f11f2651215059eea30820ee4d49ff3</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            seed_suspicious  less_5_tx  \\\n",
       "address                                                                  \n",
       "0x001f41de6f455d6df74a669c6b21b6dda1bae644            False       True   \n",
       "0x002153708f11f2651215059eea30820ee4d49ff3            False      False   \n",
       "\n",
       "                                            interacted_other_ctbt  \\\n",
       "address                                                             \n",
       "0x001f41de6f455d6df74a669c6b21b6dda1bae644                  False   \n",
       "0x002153708f11f2651215059eea30820ee4d49ff3                  False   \n",
       "\n",
       "                                            same_seed_without_label  \\\n",
       "address                                                               \n",
       "0x001f41de6f455d6df74a669c6b21b6dda1bae644                    False   \n",
       "0x002153708f11f2651215059eea30820ee4d49ff3                    False   \n",
       "\n",
       "                                            many_ctbt_to_project  \n",
       "address                                                           \n",
       "0x001f41de6f455d6df74a669c6b21b6dda1bae644                 False  \n",
       "0x002153708f11f2651215059eea30820ee4d49ff3                 False  "
      ]
     },
     "execution_count": 116,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_matching_reduced.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 124,
   "metadata": {},
   "outputs": [],
   "source": [
    "suspicious_address = df_matching_reduced[df_matching_reduced.sum(axis=1)>0].index.values"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Which projects are the most impacted?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 128,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(8556, 12)"
      ]
     },
     "execution_count": 128,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_ctbt_round.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_suspicious_votes = df_ctbt_round[df_ctbt_round.apply(lambda x : x['ctbt_address'] in suspicious_address, axis=1)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "project_address\n",
       "0x8d860d4f254ed45946f5fb0e3243c1db63a4ea2f    163\n",
       "0x18aa467e40e1defb1956708830a343c1d01d3d7c    139\n",
       "0x1208a26faa0f4ac65b42098419eb4daa5e580ac6    137\n",
       "0x08a3c2a819e3de7aca384c798269b3ce1cd0e437    133\n",
       "0x99b36fdbc582d113af36a21eba06bfeab7b9be12    128\n",
       "                                             ... \n",
       "0x799b774204a348e1182fe01074c51444ba70a149      1\n",
       "0xe126b3e5d052f1f575828f61feba4f4f2603652a      1\n",
       "0x9cce47e9cf12c6147c9844adbb81fe85880c4df4      1\n",
       "0x7f06ac71366631157551d97559b82975c293fdba      1\n",
       "0x7bd7de26ebd064465bb9c272513bb3bcbddb1e93      1\n",
       "Name: ctbt_id, Length: 65, dtype: int64"
      ]
     },
     "execution_count": 134,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_suspicious_votes.groupby('project_address').ctbt_id.count().sort_values(ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "metadata": {},
   "outputs": [],
   "source": [
    "import seaborn as sns"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Histplot of the number of suspicious contributor per project"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 143,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot: xlabel='ctbt_id', ylabel='Count'>"
      ]
     },
     "execution_count": 143,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAjIAAAGxCAYAAAB4AFyyAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjYuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/P9b71AAAACXBIWXMAAA9hAAAPYQGoP6dpAAAohUlEQVR4nO3df3RU9Z3/8ddAkkkCJJCEhEQyJrVo+CWgQBbhtLBkQdcK6G6rFiiLbi02yI90EdkaIliMuBZBpSCcIu5R1PYsUMquWAy/5ADhR0CMJoArISwkxBHJAAlDTO73D7/MMfIrCTNz5xOfj3PuOd6fn/c7Tm5e3HtnxmFZliUAAAADtbG7AAAAgJYiyAAAAGMRZAAAgLEIMgAAwFgEGQAAYCyCDAAAMBZBBgAAGIsgAwAAjBVmdwGB1tDQoJMnT6pDhw5yOBx2lwMAAJrAsiydPXtWKSkpatPm6tddWn2QOXnypFJTU+0uAwAAtMDx48fVtWvXq65v9UGmQ4cOkr75QcTExNhcDQAAaAqPx6PU1FTf3/GrafVB5tLtpJiYGIIMAACGud5jITzsCwAAjEWQAQAAxiLIAAAAYxFkAACAsQgyAADAWAQZAABgLIIMAAAwFkEGAAAYiyADAACMRZABAADGsjXIbNu2Tffdd59SUlLkcDi0du1a37q6ujrNnDlTvXv3Vrt27ZSSkqJf/OIXOnnypH0FAwCAkGJrkDl//rz69OmjxYsXX7aupqZGRUVFys3NVVFRkVavXq1Dhw5p1KhRNlQKAABCkcOyLMvuIqRvvhRqzZo1GjNmzFW32bNnjwYOHKhjx47J5XI16bgej0exsbGqrq7mSyMBADBEU/9+G/WMTHV1tRwOhzp27Gh3KQAAIASE2V1AU124cEEzZ87Uww8/fM1k5vV65fV6ffMejycY5aEFysvL5Xa7gzJWQkJCk6/iAQDMYUSQqaur089+9jNZlqUlS5Zcc9v8/HzNmTMnSJWhpcrLy5WR0V21tTVBGS8qKlqlpSWEGQBoZUI+yFwKMceOHdOmTZuu+5zLrFmzlJOT45v3eDxKTU0NdJloJrfbrdraGmU+kqeY5LSAjuWpKFPhijlyu90EGQBoZUI6yFwKMUeOHNHmzZsVHx9/3X2cTqecTmcQqoM/xCSnKc51m91lAAAMZWuQOXfunD777DPf/NGjR3XgwAHFxcUpOTlZ//zP/6yioiKtX79e9fX1qqyslCTFxcUpIiLCrrIBAECIsDXI7N27V8OGDfPNX7olNGHCBD3zzDNat26dJKlv376N9tu8ebOGDh0arDIBAECIsjXIDB06VNf6GJsQ+YgbAAAQooz6HBkAAIBvI8gAAABjEWQAAICxCDIAAMBYBBkAAGAsggwAADAWQQYAABiLIAMAAIxFkAEAAMYiyAAAAGMRZAAAgLEIMgAAwFgEGQAAYCyCDAAAMBZBBgAAGIsgAwAAjEWQAQAAxiLIAAAAYxFkAACAsQgyAADAWAQZAABgLIIMAAAwVpjdBSC0lJeXy+12B3yckpKSgI8BAGj9CDLwKS8vV0ZGd9XW1gRtzDrvxaCNBQBofQgy8HG73aqtrVHmI3mKSU4L6FgVH+9U8bpl+vrrrwM6DgCgdSPI4DIxyWmKc90W0DE8FWUBPT4A4PuBh30BAICxCDIAAMBYBBkAAGAsggwAADAWQQYAABiLIAMAAIxFkAEAAMYiyAAAAGMRZAAAgLEIMgAAwFgEGQAAYCyCDAAAMBZBBgAAGIsgAwAAjEWQAQAAxiLIAAAAYxFkAACAsQgyAADAWAQZAABgLIIMAAAwFkEGAAAYiyADAACMZWuQ2bZtm+677z6lpKTI4XBo7dq1jdZblqXZs2crOTlZUVFRysrK0pEjR+wpFgAAhBxbg8z58+fVp08fLV68+IrrX3jhBb388staunSpCgsL1a5dO40cOVIXLlwIcqUAACAUhdk5+D333KN77rnniussy9LChQv19NNPa/To0ZKk//zP/1RSUpLWrl2rhx56KJilAgCAEBSyz8gcPXpUlZWVysrK8i2LjY1VZmamdu7cedX9vF6vPB5PowkAALROIRtkKisrJUlJSUmNliclJfnWXUl+fr5iY2N9U2pqakDrBAAA9gnZINNSs2bNUnV1tW86fvy43SUBAIAACdkg06VLF0nSqVOnGi0/deqUb92VOJ1OxcTENJoAAEDrFLJBJj09XV26dFFBQYFvmcfjUWFhoQYNGmRjZQAAIFTY+q6lc+fO6bPPPvPNHz16VAcOHFBcXJxcLpemTZum3/3ud+rWrZvS09OVm5urlJQUjRkzxr6iAQBAyLA1yOzdu1fDhg3zzefk5EiSJkyYoJUrV+rJJ5/U+fPn9dhjj+nMmTMaMmSINmzYoMjISLtKBgAAIcTWIDN06FBZlnXV9Q6HQ3PnztXcuXODWBUAADBFyD4jAwAAcD0EGQAAYCyCDAAAMBZBBgAAGIsgAwAAjEWQAQAAxiLIAAAAYxFkAACAsQgyAADAWAQZAABgLIIMAAAwFkEGAAAYiyADAACMRZABAADGIsgAAABjEWQAAICxCDIAAMBYBBkAAGAsggwAADAWQQYAABiLIAMAAIxFkAEAAMYiyAAAAGMRZAAAgLEIMgAAwFgEGQAAYCyCDAAAMBZBBgAAGIsgAwAAjEWQAQAAxiLIAAAAYxFkAACAsQgyAADAWAQZAABgLIIMAAAwFkEGAAAYiyADAACMRZABAADGIsgAAABjEWQAAICxCDIAAMBYBBkAAGAsggwAADAWQQYAABiLIAMAAIxFkAEAAMYiyAAAAGOFdJCpr69Xbm6u0tPTFRUVpVtuuUXPPvusLMuyuzQAABACwuwu4Frmz5+vJUuW6I033lDPnj21d+9eTZw4UbGxsZoyZYrd5QEAAJuFdJDZsWOHRo8erXvvvVeSlJaWprffflu7d++2uTIAABAKQvrW0l133aWCggIdPnxYkvTRRx9p+/btuueee2yuDAAAhIKQviLz1FNPyePxKCMjQ23btlV9fb3mzZunsWPHXnUfr9crr9frm/d4PMEoFQAA2CCkr8j86U9/0ltvvaVVq1apqKhIb7zxhl588UW98cYbV90nPz9fsbGxvik1NTWIFQMAgGAK6SAzY8YMPfXUU3rooYfUu3dvjR8/XtOnT1d+fv5V95k1a5aqq6t90/Hjx4NYMQAACKaQvrVUU1OjNm0aZ622bduqoaHhqvs4nU45nc5AlwYAAEJASAeZ++67T/PmzZPL5VLPnj21f/9+LViwQI888ojdpQEAgBAQ0kHmlVdeUW5urn7961+rqqpKKSkp+tWvfqXZs2fbXRoAAAgBIR1kOnTooIULF2rhwoV2lwIAAEJQSD/sCwAAcC0EGQAAYCyCDAAAMBZBBgAAGIsgAwAAjEWQAQAAxiLIAAAAYxFkAACAsQgyAADAWAQZAABgLIIMAAAwFkEGAAAYiyADAACMRZABAADGIsgAAABjEWQAAICxCDIAAMBYBBkAAGAsggwAADAWQQYAABiLIAMAAIxFkAEAAMYKs7sAAKGtvLxcbrc7KGMlJCTI5XIFZSwArQNBBsBVlZeXKyOju2pra4IyXlRUtEpLSwgzAJqMIAPgqtxut2pra5T5SJ5iktMCOpanokyFK+bI7XYTZAA0WYuCzA9+8APt2bNH8fHxjZafOXNGd9xxhz7//HO/FAcgNMQkpynOdZvdZQDAZVr0sG9ZWZnq6+svW+71enXixIkbLgoAAKApmnVFZt26db7/fv/99xUbG+ubr6+vV0FBgdLS0vxWHAAAwLU0K8iMGTNGkuRwODRhwoRG68LDw5WWlqbf//73fisOAADgWpoVZBoaGiRJ6enp2rNnjxISEgJSFAAAQFO06GHfo0eP+rsOAACAZmvx268LCgpUUFCgqqoq35WaS1asWHHDhQEAAFxPi4LMnDlzNHfuXPXv31/JyclyOBz+rgsAAOC6WhRkli5dqpUrV2r8+PH+rgcAAKDJWvQ5MhcvXtRdd93l71oAAACapUVB5l//9V+1atUqf9cCAADQLC26tXThwgUtW7ZMH3zwgW6//XaFh4c3Wr9gwQK/FAcAAHAtLQoyBw8eVN++fSVJxcXFjdbx4C8AAAiWFgWZzZs3+7sOAACAZmvRMzIAAAChoEVXZIYNG3bNW0ibNm1qcUEAAABN1aIgc+n5mEvq6up04MABFRcXX/ZlkgAAAIHSoiDz0ksvXXH5M888o3Pnzt1QQQAAAE3l12dkxo0bx/csAQCAoPFrkNm5c6ciIyP9eUgAAICratGtpQceeKDRvGVZqqio0N69e5Wbm+uXwgAAAK6nRUEmNja20XybNm102223ae7cuRoxYoRfCgMAALieFgWZ119/3d91AAAANNsNPSOzb98+vfnmm3rzzTe1f/9+f9XUyIkTJzRu3DjFx8crKipKvXv31t69ewMyFgAAMEuLrshUVVXpoYce0pYtW9SxY0dJ0pkzZzRs2DC988476ty5s1+K++qrrzR48GANGzZM7733njp37qwjR46oU6dOfjk+AAAwW4uuyDzxxBM6e/asPvnkE50+fVqnT59WcXGxPB6PpkyZ4rfi5s+fr9TUVL3++usaOHCg0tPTNWLECN1yyy1+GwMAAJirRUFmw4YN+sMf/qDu3bv7lvXo0UOLFy/We++957fi1q1bp/79++unP/2pEhMT1a9fPy1fvtxvxwcAAGZr0a2lhoYGhYeHX7Y8PDxcDQ0NN1zUJZ9//rmWLFminJwc/fu//7v27NmjKVOmKCIi4qpfheD1euX1en3zHo/Hb/UACLySkpKAj+H1euV0OgM+jiQlJCTI5XIFZSzg+6hFQebv//7vNXXqVL399ttKSUmR9M1DudOnT9fw4cP9VlxDQ4P69++v5557TpLUr18/FRcXa+nSpVcNMvn5+ZozZ47fagAQHLXVX0pyaNy4cYEfzOGQLCvw40iKiopWaWkJYQYIkBYFmVdffVWjRo1SWlqaUlNTJUnHjx9Xr1699Oabb/qtuOTkZPXo0aPRsu7du+u//uu/rrrPrFmzlJOT45v3eDy+GgGErrqas5Is9f35THVOzwjYOBUf71TxumUBH0eSPBVlKlwxR263myADBEiLgkxqaqqKior0wQcfqLS0VNI3ASMrK8uvxQ0ePFiHDh1qtOzw4cO6+eabr7qP0+kM2iVjAP7XPtGlONdtATu+p6IsKOMACI5mPey7adMm9ejRQx6PRw6HQ//wD/+gJ554Qk888YQGDBignj176sMPP/RbcdOnT9euXbv03HPP6bPPPtOqVau0bNkyZWdn+20MAABgrmYFmYULF+qXv/ylYmJiLlsXGxurX/3qV1qwYIHfihswYIDWrFmjt99+W7169dKzzz6rhQsXauzYsX4bAwAAmKtZt5Y++ugjzZ8//6rrR4wYoRdffPGGi/q2n/zkJ/rJT37i12MCAIDWoVlXZE6dOnXFt11fEhYWpi+++OKGiwIAAGiKZgWZm266ScXFxVddf/DgQSUnJ99wUQAAAE3RrCDzj//4j8rNzdWFCxcuW1dbW6u8vDxuAwEAgKBp1jMyTz/9tFavXq1bb71VkydP1m23ffPWxdLSUi1evFj19fX67W9/G5BCAQAAvqtZQSYpKUk7duzQ448/rlmzZsn6/5+M6XA4NHLkSC1evFhJSUkBKRQAAOC7mv2BeDfffLP+53/+R1999ZU+++wzWZalbt26qVOnToGoDwAA4Kpa9Mm+ktSpUycNGDDAn7UAAAA0S7Me9gUAAAglBBkAAGAsggwAADAWQQYAABiLIAMAAIxFkAEAAMYiyAAAAGMRZAAAgLEIMgAAwFgEGQAAYCyCDAAAMBZBBgAAGIsgAwAAjEWQAQAAxiLIAAAAY4XZXYDJysvL5Xa7gzJWQkKCXC5XUMYCAMAUBJkWKi8vV0ZGd9XW1gRlvKioaJWWlhBmAAD4FoJMC7ndbtXW1ijzkTzFJKcFdCxPRZkKV8yR2+0myAAA8C0EmRsUk5ymONdtdpcBAMD3Eg/7AgAAYxFkAACAsQgyAADAWAQZAABgLIIMAAAwFkEGAAAYiyADAACMRZABAADGIsgAAABjEWQAAICxCDIAAMBYBBkAAGAsggwAADAWQQYAABiLIAMAAIxFkAEAAMYiyAAAAGMRZAAAgLEIMgAAwFgEGQAAYCyCDAAAMBZBBgAAGMuoIPP888/L4XBo2rRpdpcCAABCgDFBZs+ePXrttdd0++23210KAAAIEUYEmXPnzmns2LFavny5OnXqZHc5AAAgRITZXUBTZGdn695771VWVpZ+97vfXXNbr9crr9frm/d4PIEuD4YoKSkJ+BgJCQlyuVwBHwcA8I2QDzLvvPOOioqKtGfPniZtn5+frzlz5gS4KpiktvpLSQ6NGzcu4GNFRUWrtLSEMAMAQRLSQeb48eOaOnWqNm7cqMjIyCbtM2vWLOXk5PjmPR6PUlNTA1UiDFBXc1aSpb4/n6nO6RkBG8dTUabCFXPkdrsJMgAQJCEdZPbt26eqqirdcccdvmX19fXatm2bXn31VXm9XrVt27bRPk6nU06nM9ilwgDtE12Kc91mdxkAAD8K6SAzfPhwffzxx42WTZw4URkZGZo5c+ZlIQYAAHy/hHSQ6dChg3r16tVoWbt27RQfH3/ZcgAA8P1jxNuvAQAAriSkr8hcyZYtW+wuAQAAhAiuyAAAAGMRZAAAgLEIMgAAwFgEGQAAYCyCDAAAMBZBBgAAGIsgAwAAjEWQAQAAxiLIAAAAYxFkAACAsQgyAADAWAQZAABgLIIMAAAwFkEGAAAYiyADAACMRZABAADGIsgAAABjEWQAAICxCDIAAMBYBBkAAGAsggwAADAWQQYAABgrzO4CgNampKQkKOMkJCTI5XIFZSzADuXl5XK73UEZi98ncxFkAD+prf5SkkPjxo0LynhRUdEqLS3h5ItWqby8XBkZ3VVbWxOU8fh9MhdBBvCTupqzkiz1/flMdU7PCOhYnooyFa6YI7fbzYkXrZLb7VZtbY0yH8lTTHJaQMfi98lsBBnAz9onuhTnus3uMoBWISY5jd8nXBMP+wIAAGMRZAAAgLEIMgAAwFgEGQAAYCyCDAAAMBZBBgAAGIsgAwAAjEWQAQAAxiLIAAAAYxFkAACAsQgyAADAWAQZAABgLIIMAAAwFkEGAAAYiyADAACMRZABAADGIsgAAABjEWQAAICxCDIAAMBYBBkAAGAsggwAADBWSAeZ/Px8DRgwQB06dFBiYqLGjBmjQ4cO2V0WAAAIESEdZLZu3ars7Gzt2rVLGzduVF1dnUaMGKHz58/bXRoAAAgBYXYXcC0bNmxoNL9y5UolJiZq3759+tGPfmRTVQAAIFSE9BWZ76qurpYkxcXF2VwJAAAIBSF9RebbGhoaNG3aNA0ePFi9evW66nZer1der9c37/F4glEeANiqvLxcbrc7KGMlJCTI5XIFZaxgKikpCfgYrfVnZydjgkx2draKi4u1ffv2a26Xn5+vOXPmBKkqALBfeXm5MjK6q7a2JijjRUVFq7S0pNX8Qa6t/lKSQ+PGjQv4WK3tZxcKjAgykydP1vr167Vt2zZ17dr1mtvOmjVLOTk5vnmPx6PU1NRAlwgAtnG73aqtrVHmI3mKSU4L6FieijIVrpgjt9vdav4Y19WclWSp789nqnN6RsDGaY0/u1AQ0kHGsiw98cQTWrNmjbZs2aL09PTr7uN0OuV0OoNQHQCElpjkNMW5brO7DGO1T3Tx8zNQSAeZ7OxsrVq1Sn/5y1/UoUMHVVZWSpJiY2MVFRVlc3UAAMBuIf2upSVLlqi6ulpDhw5VcnKyb3r33XftLg0AAISAkL4iY1mW3SUAAIAQFtJXZAAAAK6FIAMAAIxFkAEAAMYiyAAAAGMRZAAAgLEIMgAAwFgEGQAAYCyCDAAAMBZBBgAAGIsgAwAAjEWQAQAAxiLIAAAAYxFkAACAsQgyAADAWAQZAABgLIIMAAAwFkEGAAAYiyADAACMRZABAADGIsgAAABjEWQAAICxCDIAAMBYYXYXgKYrKSkx+vjwP14TsAuvvdBXXl4ut9sd8HESEhLkcrkCPs7VEGQMUFv9pSSHxo0bF5Tx6rwXgzIOWo7XBOzCa88M5eXlysjortramoCPFRUVrdLSEtvCDEHGAHU1ZyVZ6vvzmeqcnhGwcSo+3qnidcv09ddfB2wM+AevCdiF154Z3G63amtrlPlInmKS0wI2jqeiTIUr5sjtdhNkcH3tE12Kc90WsON7KsoCdmwEBq8J2IXXnhliktMC+v8pFPCwLwAAMBZBBgAAGIsgAwAAjEWQAQAAxiLIAAAAYxFkAACAsQgyAADAWAQZAABgLIIMAAAwFkEGAAAYiyADAACMRZABAADGIsgAAABjEWQAAICxCDIAAMBYBBkAAGAsggwAADAWQQYAABiLIAMAAIxFkAEAAMYiyAAAAGMRZAAAgLGMCDKLFy9WWlqaIiMjlZmZqd27d9tdEgAACAEhH2Teffdd5eTkKC8vT0VFRerTp49Gjhypqqoqu0sDAAA2C/kgs2DBAv3yl7/UxIkT1aNHDy1dulTR0dFasWKF3aUBAACbhXSQuXjxovbt26esrCzfsjZt2igrK0s7d+60sTIAABAKwuwu4Frcbrfq6+uVlJTUaHlSUpJKS0uvuI/X65XX6/XNV1dXS5I8Ho9fazt37pwk6fSxQ/raW+vXY3+Xp+KYJKn6xBGFhzmMH6e1jkVPZowV1J4qyyVJ+/bt850zAuHQoUOSOB+F+ljBej1IwXtNXOrp3Llzfv87e+l4lmVde0MrhJ04ccKSZO3YsaPR8hkzZlgDBw684j55eXmWJCYmJiYmJqZWMB0/fvyaWSGkr8gkJCSobdu2OnXqVKPlp06dUpcuXa64z6xZs5STk+Obb2ho0OnTpxUfHy+H48aTtsfjUWpqqo4fP66YmJgbPl4oac29SfRnstbcm0R/JmvNvUn29mdZls6ePauUlJRrbhfSQSYiIkJ33nmnCgoKNGbMGEnfBJOCggJNnjz5ivs4nU45nc5Gyzp27Oj32mJiYlrli1Zq3b1J9Gey1tybRH8ma829Sfb1Fxsbe91tQjrISFJOTo4mTJig/v37a+DAgVq4cKHOnz+viRMn2l0aAACwWcgHmQcffFBffPGFZs+ercrKSvXt21cbNmy47AFgAADw/RPyQUaSJk+efNVbScHmdDqVl5d32e2r1qA19ybRn8lac28S/ZmsNfcmmdGfw7Ku974mAACA0BTSH4gHAABwLQQZAABgLIIMAAAwFkGmGRYvXqy0tDRFRkYqMzNTu3fvtrukFsnPz9eAAQPUoUMHJSYmasyYMb6Ps77kwoULys7OVnx8vNq3b69/+qd/uuyDCU3w/PPPy+FwaNq0ab5lpvd24sQJjRs3TvHx8YqKilLv3r21d+9e33rLsjR79mwlJycrKipKWVlZOnLkiI0VN119fb1yc3OVnp6uqKgo3XLLLXr22WcbfUS5Kf1t27ZN9913n1JSUuRwOLR27dpG65vSx+nTpzV27FjFxMSoY8eOevTRRwP+0fZNda3+6urqNHPmTPXu3Vvt2rVTSkqKfvGLX+jkyZONjmFqf981adIkORwOLVy4sNHyUO2vKb2VlJRo1KhRio2NVbt27TRgwACVl5f71ofSeZQg00TvvvuucnJylJeXp6KiIvXp00cjR45UVVWV3aU129atW5Wdna1du3Zp48aNqqur04gRI3T+/HnfNtOnT9df//pX/fnPf9bWrVt18uRJPfDAAzZW3Xx79uzRa6+9pttvv73RcpN7++qrrzR48GCFh4frvffe06effqrf//736tSpk2+bF154QS+//LKWLl2qwsJCtWvXTiNHjtSFCxdsrLxp5s+fryVLlujVV19VSUmJ5s+frxdeeEGvvPKKbxtT+jt//rz69OmjxYsXX3F9U/oYO3asPvnkE23cuFHr16/Xtm3b9NhjjwWrhWu6Vn81NTUqKipSbm6uioqKtHr1ah06dEijRo1qtJ2p/X3bmjVrtGvXrit++myo9ne93v73f/9XQ4YMUUZGhrZs2aKDBw8qNzdXkZGRvm1C6jx649+I9P0wcOBAKzs72zdfX19vpaSkWPn5+TZW5R9VVVWWJGvr1q2WZVnWmTNnrPDwcOvPf/6zb5uSkhJLkrVz5067ymyWs2fPWt26dbM2btxo/fjHP7amTp1qWZb5vc2cOdMaMmTIVdc3NDRYXbp0sf7jP/7Dt+zMmTOW0+m03n777WCUeEPuvfde65FHHmm07IEHHrDGjh1rWZa5/Umy1qxZ45tvSh+ffvqpJcnas2ePb5v33nvPcjgc1okTJ4JWe1N8t78r2b17tyXJOnbsmGVZraO///u//7Nuuukmq7i42Lr55putl156ybfOlP6u1NuDDz5ojRs37qr7hNp5lCsyTXDx4kXt27dPWVlZvmVt2rRRVlaWdu7caWNl/nHpG8Lj4uIkffPNrHV1dY36zcjIkMvlMqbf7Oxs3XvvvY16kMzvbd26derfv79++tOfKjExUf369dPy5ct9648eParKyspG/cXGxiozM9OI/u666y4VFBTo8OHDkqSPPvpI27dv1z333CPJ/P4uaUofO3fuVMeOHdW/f3/fNllZWWrTpo0KCwuDXvONqq6ulsPh8H1ljOn9NTQ0aPz48ZoxY4Z69ux52XpT+2toaNB///d/69Zbb9XIkSOVmJiozMzMRrefQu08SpBpArfbrfr6+ss+TTgpKUmVlZU2VeUfDQ0NmjZtmgYPHqxevXpJkiorKxUREXHZd1SZ0u8777yjoqIi5efnX7bO9N4+//xzLVmyRN26ddP777+vxx9/XFOmTNEbb7whSb4eTH2tPvXUU3rooYeUkZGh8PBw9evXT9OmTdPYsWMlmd/fJU3po7KyUomJiY3Wh4WFKS4uzqhepW+ep5g5c6Yefvhh3/f1mN7f/PnzFRYWpilTplxxvan9VVVV6dy5c3r++ed19913629/+5vuv/9+PfDAA9q6dauk0DuPGvHJvgic7OxsFRcXa/v27XaX4hfHjx/X1KlTtXHjxkb3c1uLhoYG9e/fX88995wkqV+/fiouLtbSpUs1YcIEm6u7cX/605/01ltvadWqVerZs6cOHDigadOmKSUlpVX0931UV1enn/3sZ7IsS0uWLLG7HL/Yt2+fFi1apKKiIjkcDrvL8auGhgZJ0ujRozV9+nRJUt++fbVjxw4tXbpUP/7xj+0s74q4ItMECQkJatu27WVPZJ86dUpdunSxqaobN3nyZK1fv16bN29W165dfcu7dOmiixcv6syZM422N6Hfffv2qaqqSnfccYfCwsIUFhamrVu36uWXX1ZYWJiSkpKM7U2SkpOT1aNHj0bLunfv7ns3waUeTH2tzpgxw3dVpnfv3ho/frymT5/uu7pmen+XNKWPLl26XPZmgq+//lqnT582ptdLIebYsWPauHFjo29PNrm/Dz/8UFVVVXK5XL7zzLFjx/Sb3/xGaWlpksztLyEhQWFhYdc9z4TSeZQg0wQRERG68847VVBQ4FvW0NCggoICDRo0yMbKWsayLE2ePFlr1qzRpk2blJ6e3mj9nXfeqfDw8Eb9Hjp0SOXl5SHf7/Dhw/Xxxx/rwIEDvql///4aO3as779N7U2SBg8efNlb5Q8fPqybb75ZkpSenq4uXbo06s/j8aiwsNCI/mpqatSmTePTUtu2bX3/SjS9v0ua0segQYN05swZ7du3z7fNpk2b1NDQoMzMzKDX3FyXQsyRI0f0wQcfKD4+vtF6k/sbP368Dh482Og8k5KSohkzZuj999+XZG5/ERERGjBgwDXPMyH3NyLojxcb6p133rGcTqe1cuVK69NPP7Uee+wxq2PHjlZlZaXdpTXb448/bsXGxlpbtmyxKioqfFNNTY1vm0mTJlkul8vatGmTtXfvXmvQoEHWoEGDbKy65b79riXLMru33bt3W2FhYda8efOsI0eOWG+99ZYVHR1tvfnmm75tnn/+eatjx47WX/7yF+vgwYPW6NGjrfT0dKu2ttbGyptmwoQJ1k033WStX7/eOnr0qLV69WorISHBevLJJ33bmNLf2bNnrf3791v79++3JFkLFiyw9u/f73vXTlP6uPvuu61+/fpZhYWF1vbt261u3bpZDz/8sF0tNXKt/i5evGiNGjXK6tq1q3XgwIFG5xmv1+s7hqn9Xcl337VkWaHb3/V6W716tRUeHm4tW7bMOnLkiPXKK69Ybdu2tT788EPfMULpPEqQaYZXXnnFcrlcVkREhDVw4EBr165ddpfUIpKuOL3++uu+bWpra61f//rXVqdOnazo6Gjr/vvvtyoqKuwr+gZ8N8iY3ttf//pXq1evXpbT6bQyMjKsZcuWNVrf0NBg5ebmWklJSZbT6bSGDx9uHTp0yKZqm8fj8VhTp061XC6XFRkZaf3gBz+wfvvb3zb642dKf5s3b77i79mECRMsy2paH19++aX18MMPW+3bt7diYmKsiRMnWmfPnrWhm8tdq7+jR49e9TyzefNm3zFM7e9KrhRkQrW/pvT2xz/+0frhD39oRUZGWn369LHWrl3b6BihdB7l268BAICxeEYGAAAYiyADAACMRZABAADGIsgAAABjEWQAAICxCDIAAMBYBBkAAGAsggwAADAWQQZASPqXf/kXjRkzxq/H3LJlixwOx2VfdvdtK1euVMeOHf06LoDAIcgAsFVZWZkcDocOHDjQ7H2HDh2qadOmNXn7u+66SxUVFYqNjW32WABCU5jdBQBAsERERKhLly52lwHAj7giAyAoGhoa9MILL+iHP/yhnE6nXC6X5s2bp/T0dElSv3795HA4NHTo0Eb7zZkzR507d1ZMTIwmTZqkixcvSvrm1tPWrVu1aNEiORwOORwOlZWVXbOGK91aWrlypVwul6Kjo3X//ffryy+/9GfbAAKMKzIAgmLWrFlavny5XnrpJQ0ZMkQVFRUqLS3V7t27NXDgQH3wwQfq2bOnIiIifPsUFBQoMjJSW7ZsUVlZmSZOnKj4+HjNmzdPixYt0uHDh9WrVy/NnTtXktS5c+dm1VRYWKhHH31U+fn5GjNmjDZs2KC8vDy/9g0gsAgyAALu7NmzWrRokV599VVNmDBBknTLLbdoyJAhvqso8fHxl932iYiI0IoVKxQdHa2ePXtq7ty5mjFjhp599lnFxsYqIiJC0dHRLb5dtGjRIt1999168sknJUm33nqrduzYoQ0bNrS8WQBBxa0lAAFXUlIir9er4cOHN2u/Pn36KDo62jc/aNAgnTt3TsePH/dbXZmZmY2WDRo0yC/HBhAcBBkAARcVFWV3CQBaKYIMgIDr1q2boqKiVFBQcNm6S8/E1NfXX7buo48+Um1trW9+165dat++vVJTU337Xmm/purevbsKCwsbLdu1a1eLjwcg+HhGBkDARUZGaubMmXryyScVERGhwYMH64svvtAnn3yiCRMmKCoqShs2bFDXrl0VGRnp+5yXixcv6tFHH9XTTz+tsrIy5eXlafLkyWrT5pt/g6WlpamwsFBlZWVq37694uLifOuaYsqUKRo8eLBefPFFjR49Wu+//z7PxwCG4YoMgKDIzc3Vb37zG82ePVvdu3fXgw8+qKqqKoWFhenll1/Wa6+9ppSUFI0ePdq3z/Dhw9WtWzf96Ec/0oMPPqhRo0bpmWee8a3/t3/7N7Vt21Y9evRQ586dVV5e3qya/u7v/k7Lly/XokWL1KdPH/3tb3/T008/7a+WAQSBw7Isy+4iAAAAWoIrMgAAwFgEGQCtxqRJk9S+ffsrTpMmTbK7PAABwK0lAK1GVVWVPB7PFdfFxMQoMTExyBUBCDSCDAAAMBa3lgAAgLEIMgAAwFgEGQAAYCyCDAAAMBZBBgAAGIsgAwAAjEWQAQAAxiLIAAAAY/0/ctlmAbvF88sAAAAASUVORK5CYII=",
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "sns.histplot(df_suspicious_votes.groupby('project_address').ctbt_id.count(), bins=17)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We must also look at the ratio of suspicious contributors"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "project_address\n",
       "0x01d79bceaeaadfb8fd2f2f53005289cfcf483464     85\n",
       "0x035a1f3419dd223293e5411133d9c786f5885425    200\n",
       "0x08a3c2a819e3de7aca384c798269b3ce1cd0e437    162\n",
       "0x0ea26051f7657d59418da186137141cea90d0652    177\n",
       "0x0f7272f8873b68b2a2f52685311822d831afc8b4    227\n",
       "                                             ... \n",
       "0xf64bbc221f89cc882fba507908bbe4ae3ad2f470    284\n",
       "0xfbca78474a09e2bf3543f4fc1037152ea2c6c32d    277\n",
       "0xfc148c92062ae30d788d48031b89b45237f27af7    144\n",
       "0xfd9f8a0f4bdeac72f08af1c708023cc31dd2e3be    123\n",
       "0xfe97e32a873aa2f926fbfc560abeef01f753c128     29\n",
       "Name: ctbt_id, Length: 66, dtype: int64"
      ]
     },
     "execution_count": 145,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_ctbt_round.groupby('project_address').ctbt_id.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_ctbt_round[\"suspicious_flag\"] = df_ctbt_round['ctbt_address'].apply(lambda x : x in suspicious_address)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 154,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "project_address\n",
       "0x01d79bceaeaadfb8fd2f2f53005289cfcf483464     73\n",
       "0x035a1f3419dd223293e5411133d9c786f5885425     85\n",
       "0x08a3c2a819e3de7aca384c798269b3ce1cd0e437    133\n",
       "0x0ea26051f7657d59418da186137141cea90d0652     57\n",
       "0x0f7272f8873b68b2a2f52685311822d831afc8b4     93\n",
       "                                             ... \n",
       "0xf64bbc221f89cc882fba507908bbe4ae3ad2f470    107\n",
       "0xfbca78474a09e2bf3543f4fc1037152ea2c6c32d     78\n",
       "0xfc148c92062ae30d788d48031b89b45237f27af7     54\n",
       "0xfd9f8a0f4bdeac72f08af1c708023cc31dd2e3be     35\n",
       "0xfe97e32a873aa2f926fbfc560abeef01f753c128     25\n",
       "Name: suspicious_flag, Length: 66, dtype: int64"
      ]
     },
     "execution_count": 154,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_ctbt_round.groupby(['project_address']).suspicious_flag.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 183,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['CLIMATE'], dtype=object)"
      ]
     },
     "execution_count": 183,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_ctbt_round.project_round.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "metadata": {},
   "outputs": [],
   "source": [
    "ratio_suspicious_ctbt = df_ctbt_round.groupby(['project_address']).suspicious_flag.sum() / df_ctbt_round.groupby(['project_address']).ctbt_id.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 159,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "project_address\n",
       "0xe126b3e5d052f1f575828f61feba4f4f2603652a    1.000000\n",
       "0x9cce47e9cf12c6147c9844adbb81fe85880c4df4    1.000000\n",
       "0x7f06ac71366631157551d97559b82975c293fdba    1.000000\n",
       "0x7bd7de26ebd064465bb9c272513bb3bcbddb1e93    1.000000\n",
       "0x799b774204a348e1182fe01074c51444ba70a149    1.000000\n",
       "                                                ...   \n",
       "0x81c776d0d7f7d9d3699851993ecaa88a46187f11    0.287234\n",
       "0xfd9f8a0f4bdeac72f08af1c708023cc31dd2e3be    0.284553\n",
       "0xfbca78474a09e2bf3543f4fc1037152ea2c6c32d    0.281588\n",
       "0x14cb60f6aca2b2a68d975743bacb33f01f587da5    0.278226\n",
       "0x283949d7c2ad3c8bca304df6aa5d9a2a78e02b77    0.000000\n",
       "Length: 66, dtype: float64"
      ]
     },
     "execution_count": 159,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ratio_suspicious_ctbt.sort_values(ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 160,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot: ylabel='Count'>"
      ]
     },
     "execution_count": 160,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAjMAAAGdCAYAAADnrPLBAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjYuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/P9b71AAAACXBIWXMAAA9hAAAPYQGoP6dpAAAkKUlEQVR4nO3de3BU9f3/8ddyySbYJBAikGiWAFYCiGDlMogXYlMxKl46rVqVplAvrRGVdBAiYgxegk5L02oK1RaxMyraVihVitUoUiqiBFKhBpQCLkUCblWWkLCE5PP7oz+230gCybq753zC8zGzM56zZ/fzziGBp7sniccYYwQAAGCpLk4PAAAA8FUQMwAAwGrEDAAAsBoxAwAArEbMAAAAqxEzAADAasQMAACwGjEDAACs1s3pAWKtublZn3zyiZKTk+XxeJweBwAAtIMxRgcOHFBmZqa6dDn+ay+dPmY++eQTZWVlOT0GAACIwK5du3T66acf95hOHzPJycmS/nsyUlJSHJ4GAAC0RzAYVFZWVvjf8ePp9DFz9K2llJQUYgYAAMu05xIRLgAGAABWI2YAAIDViBkAAGA1YgYAAFiNmAEAAFYjZgAAgNWIGQAAYDViBgAAWI2YAQAAViNmAACA1YgZAABgNWIGAABYjZgBAABW6/S/NRvorPx+vwKBQMzXSU9Pl8/ni/k6ABApYgawkN/vV07OEDU01Md8raSkHtqypYagAeBaxAxgoUAgoIaGeo2dWqKUjOyYrRPcs1PrFpUqEAgQMwBci5gBLJaSka0032CnxwAAR3EBMAAAsBoxAwAArEbMAAAAqxEzAADAasQMAACwGjEDAACsRswAAACrETMAAMBqxAwAALAaMQMAAKxGzAAAAKsRMwAAwGrEDAAAsBoxAwAArOZozKxevVqTJk1SZmamPB6Pli1bdswxNTU1uvLKK5WamqpTTjlFo0ePlt/vj/+wAADAlRyNmYMHD2rEiBGqqKho9f5//etfOv/885WTk6NVq1bp/fff15w5c5SYmBjnSQEAgFt1c3Lx/Px85efnt3n/7Nmzddlll+mxxx4L7xs0aFA8RgMAAJZw7TUzzc3NeuWVV3TmmWdq4sSJ6tOnj8aOHdvqW1H/VygUUjAYbHEDAACdl2tjZt++faqrq9O8efN06aWX6q9//auuueYaffvb39Zbb73V5uPKysqUmpoavmVlZcVxagAAEG+ujZnm5mZJ0lVXXaXp06dr5MiRmjVrlq644gotXLiwzccVFxdr//794duuXbviNTIAAHCAo9fMHE96erq6deumoUOHttg/ZMgQrVmzps3Heb1eeb3eWI8HAABcwrWvzCQkJGj06NHaunVri/0ffvih+vfv79BUAADAbRx9Zaaurk7btm0Lb+/YsUPV1dVKS0uTz+fTjBkzdN111+nCCy9Ubm6uVq5cqT//+c9atWqVc0MDAABXcTRm1q9fr9zc3PB2UVGRJKmgoECLFy/WNddco4ULF6qsrEx33nmnBg8erD/+8Y86//zznRoZAAC4jKMxM2HCBBljjnvM1KlTNXXq1DhNBAAAbOPaa2YAAADag5gBAABWI2YAAIDViBkAAGA1YgYAAFiNmAEAAFYjZgAAgNWIGQAAYDViBgAAWI2YAQAAViNmAACA1YgZAABgNWIGAABYjZgBAABWI2YAAIDViBkAAGA1YgYAAFiNmAEAAFYjZgAAgNWIGQAAYDViBgAAWI2YAQAAViNmAACA1YgZAABgNWIGAABYjZgBAABWI2YAAIDViBkAAGA1YgYAAFiNmAEAAFZzNGZWr16tSZMmKTMzUx6PR8uWLWvz2B/96EfyeDwqLy+P23wAAMD9HI2ZgwcPasSIEaqoqDjucUuXLtU777yjzMzMOE0GAABs0c3JxfPz85Wfn3/cY3bv3q1p06bp1Vdf1eWXXx6nyQAAgC0cjZkTaW5u1uTJkzVjxgwNGzasXY8JhUIKhULh7WAwGKvxgGP4/X4FAoGYr1NTUxPzNQDAFq6OmUcffVTdunXTnXfe2e7HlJWVqbS0NIZTAa3z+/3KyRmihob6uK3ZGDoct7UAwK1cGzNVVVX6xS9+oQ0bNsjj8bT7ccXFxSoqKgpvB4NBZWVlxWJEoIVAIKCGhnqNnVqilIzsmK61Z9NabV7+pI4cORLTdQDABq6Nmb/97W/at2+ffD5feF9TU5N+8pOfqLy8XDt37mz1cV6vV16vN05TAsdKychWmm9wTNcI7tkZ0+cHAJu4NmYmT56svLy8FvsmTpyoyZMna8qUKQ5NBQAA3MbRmKmrq9O2bdvC2zt27FB1dbXS0tLk8/nUu3fvFsd3795d/fr10+DBsf2/XgAAYA9HY2b9+vXKzc0Nbx+91qWgoECLFy92aCoAAGATR2NmwoQJMsa0+/i2rpMBAAAnL343EwAAsBoxAwAArEbMAAAAqxEzAADAasQMAACwGjEDAACsRswAAACrETMAAMBqxAwAALAaMQMAAKxGzAAAAKsRMwAAwGrEDAAAsBoxAwAArEbMAAAAqxEzAADAasQMAACwGjEDAACsRswAAACrETMAAMBqxAwAALAaMQMAAKxGzAAAAKsRMwAAwGrEDAAAsBoxAwAArEbMAAAAqxEzAADAasQMAACwGjEDAACsRswAAACrORozq1ev1qRJk5SZmSmPx6Nly5aF72tsbNTMmTM1fPhwnXLKKcrMzNT3v/99ffLJJ84NDAAAXMfRmDl48KBGjBihioqKY+6rr6/Xhg0bNGfOHG3YsEEvvfSStm7dqiuvvNKBSQEAgFt1c3Lx/Px85efnt3pfamqqXnvttRb7nnjiCY0ZM0Z+v18+ny8eIwIAAJdzNGY6av/+/fJ4POrZs2ebx4RCIYVCofB2MBiMw2QAAMAp1lwAfOjQIc2cOVPf+973lJKS0uZxZWVlSk1NDd+ysrLiOCUAAIg3K2KmsbFR1157rYwxWrBgwXGPLS4u1v79+8O3Xbt2xWlKAADgBNe/zXQ0ZD7++GO98cYbx31VRpK8Xq+8Xm+cpgMAAE5zdcwcDZmPPvpIb775pnr37u30SAAAwGUcjZm6ujpt27YtvL1jxw5VV1crLS1NGRkZ+s53vqMNGzbo5ZdfVlNTk2prayVJaWlpSkhIcGpsAADgIo7GzPr165WbmxveLioqkiQVFBTogQce0PLlyyVJI0eObPG4N998UxMmTIjXmAAAwMUcjZkJEybIGNPm/ce7DwAAQLLku5kAAADaQswAAACrETMAAMBqxAwAALAaMQMAAKxGzAAAAKsRMwAAwGrEDAAAsBoxAwAArEbMAAAAqxEzAADAasQMAACwGjEDAACsRswAAACrETMAAMBqxAwAALAaMQMAAKxGzAAAAKsRMwAAwGrEDAAAsBoxAwAArEbMAAAAqxEzAADAasQMAACwGjEDAACsRswAAACrETMAAMBqxAwAALAaMQMAAKxGzAAAAKs5GjOrV6/WpEmTlJmZKY/Ho2XLlrW43xij+++/XxkZGUpKSlJeXp4++ugjZ4YFAACu5GjMHDx4UCNGjFBFRUWr9z/22GP65S9/qYULF2rdunU65ZRTNHHiRB06dCjOkwIAALfq5uTi+fn5ys/Pb/U+Y4zKy8t133336aqrrpIk/e53v1Pfvn21bNkyXX/99fEcFQAAuJRrr5nZsWOHamtrlZeXF96XmpqqsWPHau3atW0+LhQKKRgMtrgBAIDOy7UxU1tbK0nq27dvi/19+/YN39easrIypaamhm9ZWVkxnRMAADjLtTETqeLiYu3fvz9827Vrl9MjAQCAGHJtzPTr10+StHfv3hb79+7dG76vNV6vVykpKS1uAACg83JtzAwYMED9+vVTZWVleF8wGNS6des0btw4BycDAABuElHMDBw4UP/5z3+O2f/FF19o4MCB7X6euro6VVdXq7q6WtJ/L/qtrq6W3++Xx+PR3XffrYceekjLly/Xpk2b9P3vf1+ZmZm6+uqrIxkbAAB0QhF9a/bOnTvV1NR0zP5QKKTdu3e3+3nWr1+v3Nzc8HZRUZEkqaCgQIsXL9Y999yjgwcP6tZbb9UXX3yh888/XytXrlRiYmIkYwMAgE6oQzGzfPny8H+/+uqrSk1NDW83NTWpsrJS2dnZ7X6+CRMmyBjT5v0ej0dz587V3LlzOzImAAA4iXQoZo6+vePxeFRQUNDivu7duys7O1s/+9nPojYcAADAiXQoZpqbmyX99+Lc9957T+np6TEZCgAAoL0iumZmx44d0Z4DAAAgIhH/bqbKykpVVlZq37594Vdsjlq0aNFXHgwAAKA9IoqZ0tJSzZ07V6NGjVJGRoY8Hk+05wIAAGiXiGJm4cKFWrx4sSZPnhzteQAAADokoh+ad/jwYZ133nnRngUAAKDDIoqZm2++Wc8991y0ZwEAAOiwiN5mOnTokJ588km9/vrrOvvss9W9e/cW98+fPz8qwwEAAJxIRDHz/vvva+TIkZKkzZs3t7iPi4EBAEA8RRQzb775ZrTnAAAAiEhE18wAAAC4RUSvzOTm5h737aQ33ngj4oEAAAA6IqKYOXq9zFGNjY2qrq7W5s2bj/kFlAAAALEUUcz8/Oc/b3X/Aw88oLq6uq80EAAAQEdE9ZqZm266id/LBAAA4iqqMbN27VolJiZG8ykBAACOK6K3mb797W+32DbGaM+ePVq/fr3mzJkTlcEAAADaI6KYSU1NbbHdpUsXDR48WHPnztUll1wSlcEAAADaI6KYefrpp6M9BwAAQEQiipmjqqqqVFNTI0kaNmyYzjnnnKgMBQAA0F4Rxcy+fft0/fXXa9WqVerZs6ck6YsvvlBubq6WLFmiU089NZozAgAAtCmi72aaNm2aDhw4oH/+85/67LPP9Nlnn2nz5s0KBoO68847oz0jAABAmyJ6ZWblypV6/fXXNWTIkPC+oUOHqqKigguAAQBAXEX0ykxzc7O6d+9+zP7u3burubn5Kw8FAADQXhHFzMUXX6y77rpLn3zySXjf7t27NX36dH3zm9+M2nAAAAAnElHMPPHEEwoGg8rOztagQYM0aNAgDRgwQMFgUI8//ni0ZwQAAGhTRNfMZGVlacOGDXr99de1ZcsWSdKQIUOUl5cX1eEAAABOpEOvzLzxxhsaOnSogsGgPB6PvvWtb2natGmaNm2aRo8erWHDhulvf/tbrGYFAAA4Rodipry8XLfccotSUlKOuS81NVW33Xab5s+fH7XhAAAATqRDMfOPf/xDl156aZv3X3LJJaqqqvrKQx3V1NSkOXPmaMCAAUpKStKgQYP04IMPyhgTtTUAAIDdOnTNzN69e1v9luzwk3Xrpk8//fQrD3XUo48+qgULFuiZZ57RsGHDtH79ek2ZMkWpqan8cD4AACCpgzFz2mmnafPmzTrjjDNavf/9999XRkZGVAaTpLfffltXXXWVLr/8cklSdna2nn/+eb377rtRWwMAANitQ28zXXbZZZozZ44OHTp0zH0NDQ0qKSnRFVdcEbXhzjvvPFVWVurDDz+U9N+3udasWaP8/PyorQEAAOzWoVdm7rvvPr300ks688wzdccdd2jw4MGSpC1btqiiokJNTU2aPXt21IabNWuWgsGgcnJy1LVrVzU1Nenhhx/WjTfe2OZjQqGQQqFQeDsYDEZtHgAA4D4dipm+ffvq7bff1o9//GMVFxeHL8T1eDyaOHGiKioq1Ldv36gN9+KLL+rZZ5/Vc889p2HDhqm6ulp33323MjMzVVBQ0OpjysrKVFpaGrUZAACAu3X4h+b1799fK1as0Oeff65t27bJGKOvf/3r6tWrV9SHmzFjhmbNmqXrr79ekjR8+HB9/PHHKisrazNmiouLVVRUFN4OBoPKysqK+mwAAMAdIvoJwJLUq1cvjR49OpqzHKO+vl5durS8rKdr167H/WWWXq9XXq83pnMBAAD3iDhm4mHSpEl6+OGH5fP5NGzYMG3cuFHz58/X1KlTnR4NAAC4hKtj5vHHH9ecOXN0++23a9++fcrMzNRtt92m+++/3+nRAACAS7g6ZpKTk1VeXq7y8nKnRwEAAC7VoZ8zAwAA4DbEDAAAsBoxAwAArEbMAAAAqxEzAADAasQMAACwGjEDAACsRswAAACrETMAAMBqxAwAALAaMQMAAKxGzAAAAKsRMwAAwGrEDAAAsBoxAwAArEbMAAAAqxEzAADAasQMAACwGjEDAACsRswAAACrETMAAMBqxAwAALAaMQMAAKxGzAAAAKsRMwAAwGrEDAAAsBoxAwAArEbMAAAAqxEzAADAasQMAACwGjEDAACs5vqY2b17t2666Sb17t1bSUlJGj58uNavX+/0WAAAwCW6OT3A8Xz++ecaP368cnNz9Ze//EWnnnqqPvroI/Xq1cvp0QAAgEu4OmYeffRRZWVl6emnnw7vGzBggIMTAQAAt3F1zCxfvlwTJ07Ud7/7Xb311ls67bTTdPvtt+uWW25p8zGhUEihUCi8HQwG4zEq0KnV1NTEZZ309HT5fL64rAWg83B1zGzfvl0LFixQUVGR7r33Xr333nu68847lZCQoIKCglYfU1ZWptLS0jhPCnRODfv/I8mjm266KS7rJSX10JYtNQQNgA5xdcw0Nzdr1KhReuSRRyRJ55xzjjZv3qyFCxe2GTPFxcUqKioKbweDQWVlZcVlXqCzaaw/IMlo5A0zdeqAnJiuFdyzU+sWlSoQCBAzADrE1TGTkZGhoUOHttg3ZMgQ/fGPf2zzMV6vV16vN9ajASeVr/XxKc032OkxAKBVrv7W7PHjx2vr1q0t9n344Yfq37+/QxMBAAC3cXXMTJ8+Xe+8844eeeQRbdu2Tc8995yefPJJFRYWOj0aAABwCVfHzOjRo7V06VI9//zzOuuss/Tggw+qvLxcN954o9OjAQAAl3D1NTOSdMUVV+iKK65wegwAAOBSrn5lBgAA4ESIGQAAYDViBgAAWI2YAQAAViNmAACA1YgZAABgNWIGAABYjZgBAABWI2YAAIDViBkAAGA1YgYAAFiNmAEAAFYjZgAAgNVc/1uzAQBAx/n9fgUCgZivk56eLp/PF/N1joeYAQCgk/H7/crJGaKGhvqYr5WU1ENbttQ4GjTEDAAAnUwgEFBDQ73GTi1RSkZ2zNYJ7tmpdYtKFQgEiBkAABB9KRnZSvMNdnqMmOMCYAAAYDViBgAAWI2YAQAAViNmAACA1YgZAABgNWIGAABYjZgBAABWI2YAAIDViBkAAGA1YgYAAFiNmAEAAFYjZgAAgNWIGQAAYDWrYmbevHnyeDy6++67nR4FAAC4hDUx89577+nXv/61zj77bKdHAQAALmJFzNTV1enGG2/UU089pV69ejk9DgAAcJFuTg/QHoWFhbr88suVl5enhx566LjHhkIhhUKh8HYwGIz1eLCA3+9XIBCI6Ro1NTUxfX7gZBOPr9ujQqGQvF5vzNdJT0+Xz+eL+TonG9fHzJIlS7Rhwwa999577Tq+rKxMpaWlMZ4KNvH7/crJGaKGhvq4rNcYOhyXdYDOLN5ft/J4JGNivkxSUg9t2VJD0ESZq2Nm165duuuuu/Taa68pMTGxXY8pLi5WUVFReDsYDCorKytWI8ICgUBADQ31Gju1RCkZ2TFbZ8+mtdq8/EkdOXIkZmsAJ4t4fd1K//vaHXnDTJ06ICdm6wT37NS6RaUKBALETJS5Omaqqqq0b98+feMb3wjva2pq0urVq/XEE08oFAqpa9euLR7j9Xrj8lIh7JOSka003+CYPX9wz86YPTdwsor11630v6/dr/XxxXwtxIarY+ab3/ymNm3a1GLflClTlJOTo5kzZx4TMgAA4OTj6phJTk7WWWed1WLfKaecot69ex+zHwAAnJys+NZsAACAtrj6lZnWrFq1yukRAACAi/DKDAAAsBoxAwAArEbMAAAAqxEzAADAasQMAACwGjEDAACsRswAAACrETMAAMBqxAwAALAaMQMAAKxGzAAAAKsRMwAAwGrEDAAAsJp1vzUbAL4qv9+vQCAQl7XS09Pl8/nishZwsiJmAJxU/H6/cnKGqKGhPi7rJSX10JYtNQQNEEPEDICTSiAQUENDvcZOLVFKRnZM1wru2al1i0oVCASIGSCGiBkAJ6WUjGyl+QY7PQaAKOACYAAAYDViBgAAWI2YAQAAViNmAACA1YgZAABgNWIGAABYjZgBAABWI2YAAIDViBkAAGA1YgYAAFiNmAEAAFYjZgAAgNWIGQAAYDViBgAAWM31MVNWVqbRo0crOTlZffr00dVXX62tW7c6PRYAAHAJ18fMW2+9pcLCQr3zzjt67bXX1NjYqEsuuUQHDx50ejQAAOAC3Zwe4ERWrlzZYnvx4sXq06ePqqqqdOGFFzo0FQAAcAvXx8yX7d+/X5KUlpbW6v2hUEihUCi8HQwG4zIXgOioqamx+vmdWjMUCsnr9cZ8HUlKT0+Xz+eLy1qdUTw+H5z4PHeSVTHT3Nysu+++W+PHj9dZZ53V6jFlZWUqLS2N82QAvqqG/f+R5NFNN90Ul/UaQ4djvkZcPyaPRzIm9utISkrqoS1bagiaDor357gUn89zN7AqZgoLC7V582atWbOmzWOKi4tVVFQU3g4Gg8rKyorHeAC+gsb6A5KMRt4wU6cOyInZOns2rdXm5U/qyJEjMVvjqHh/TLFeR5KCe3Zq3aJSBQIBYqaD4vX5IMX389wNrImZO+64Qy+//LJWr16t008/vc3jvF5v3F5qBRB9X+vjU5pvcMyeP7hnZ8yeuy3x+phivQ6iIx5/Tk58njvJ9TFjjNG0adO0dOlSrVq1SgMGDHB6JAAA4CKuj5nCwkI999xz+tOf/qTk5GTV1tZKklJTU5WUlOTwdAAAwGmu/zkzCxYs0P79+zVhwgRlZGSEby+88ILTowEAABdw/SszJk5X5wMAADu5/pUZAACA4yFmAACA1YgZAABgNWIGAABYjZgBAABWI2YAAIDViBkAAGA1YgYAAFiNmAEAAFYjZgAAgNWIGQAAYDViBgAAWI2YAQAAVnP9b812O7/fr0AgEPN10tPT5fP5Yr4OAAC2IWa+Ar/fr5ycIWpoqI/5WklJPbRlSw1BAwDAlxAzX0EgEFBDQ73GTi1RSkZ2zNYJ7tmpdYtKFQgEiBkAAL6EmImClIxspfkGOz0GAAAnJS4ABgAAViNmAACA1YgZAABgNWIGAABYjZgBAABWI2YAAIDViBkAAGA1YgYAAFiNmAEAAFYjZgAAgNWIGQAAYDViBgAAWI2YAQAAVrMiZioqKpSdna3ExESNHTtW7777rtMjAQAAl3B9zLzwwgsqKipSSUmJNmzYoBEjRmjixInat2+f06MBAAAXcH3MzJ8/X7fccoumTJmioUOHauHCherRo4cWLVrk9GgAAMAFujk9wPEcPnxYVVVVKi4uDu/r0qWL8vLytHbt2lYfEwqFFAqFwtv79++XJAWDwajPV1dXJ0n67OOtOhJqiPrzHxWs9UuSqqqqwmvGUpcuXdTc3Nxp1tm6daukOPw57flYkrR/90fq3s0Ts3XiuRYfkx1rxfVjitPfR/H6upU66Z9TvD6m///5UFdXF/V/Z48+nzHmxAcbF9u9e7eRZN5+++0W+2fMmGHGjBnT6mNKSkqMJG7cuHHjxo1bJ7jt2rXrhL3g6ldmIlFcXKyioqLwdnNzsz777DP17t1bHk906zQYDCorK0u7du1SSkpKVJ8b/8N5jg/Oc3xwnuOD8xwfsTzPxhgdOHBAmZmZJzzW1TGTnp6url27au/evS327927V/369Wv1MV6vV16vt8W+nj17xmpESVJKSgpfLHHAeY4PznN8cJ7jg/McH7E6z6mpqe06ztUXACckJOjcc89VZWVleF9zc7MqKys1btw4BycDAABu4epXZiSpqKhIBQUFGjVqlMaMGaPy8nIdPHhQU6ZMcXo0AADgAq6Pmeuuu06ffvqp7r//ftXW1mrkyJFauXKl+vbt6/Ro8nq9KikpOeZtLUQX5zk+OM/xwXmOD85zfLjlPHuMac/3PAEAALiTq6+ZAQAAOBFiBgAAWI2YAQAAViNmAACA1YiZE6ioqFB2drYSExM1duxYvfvuu8c9/ve//71ycnKUmJio4cOHa8WKFXGa1G4dOc9PPfWULrjgAvXq1Uu9evVSXl7eCf9c8F8d/Xw+asmSJfJ4PLr66qtjO2An0dHz/MUXX6iwsFAZGRnyer0688wz+bujHTp6nsvLyzV48GAlJSUpKytL06dP16FDh+I0rZ1Wr16tSZMmKTMzUx6PR8uWLTvhY1atWqVvfOMb8nq9OuOMM7R48eKYz+nq383ktCVLlpiEhASzaNEi889//tPccsstpmfPnmbv3r2tHv/3v//ddO3a1Tz22GPmgw8+MPfdd5/p3r272bRpU5wnt0tHz/MNN9xgKioqzMaNG01NTY35wQ9+YFJTU82///3vOE9ul46e56N27NhhTjvtNHPBBReYq666Kj7DWqyj5zkUCplRo0aZyy67zKxZs8bs2LHDrFq1ylRXV8d5crt09Dw/++yzxuv1mmeffdbs2LHDvPrqqyYjI8NMnz49zpPbZcWKFWb27NnmpZdeMpLM0qVLj3v89u3bTY8ePUxRUZH54IMPzOOPP266du1qVq5cGdM5iZnjGDNmjCksLAxvNzU1mczMTFNWVtbq8ddee625/PLLW+wbO3asue2222I6p+06ep6/7MiRIyY5Odk888wzsRqxU4jkPB85csScd9555je/+Y0pKCggZtqho+d5wYIFZuDAgebw4cPxGrFT6Oh5LiwsNBdffHGLfUVFRWb8+PExnbMzaU/M3HPPPWbYsGEt9l133XVm4sSJMZzMGN5masPhw4dVVVWlvLy88L4uXbooLy9Pa9eubfUxa9eubXG8JE2cOLHN4xHZef6y+vp6NTY2Ki0tLVZjWi/S8zx37lz16dNHP/zhD+MxpvUiOc/Lly/XuHHjVFhYqL59++qss87SI488oqampniNbZ1IzvN5552nqqqq8FtR27dv14oVK3TZZZfFZeaThVP/Drr+JwA7JRAIqKmp6ZifNNy3b19t2bKl1cfU1ta2enxtbW3M5rRdJOf5y2bOnKnMzMxjvoDwP5Gc5zVr1ui3v/2tqqur4zBh5xDJed6+fbveeOMN3XjjjVqxYoW2bdum22+/XY2NjSopKYnH2NaJ5DzfcMMNCgQCOv/882WM0ZEjR/SjH/1I9957bzxGPmm09e9gMBhUQ0ODkpKSYrIur8zAavPmzdOSJUu0dOlSJSYmOj1Op3HgwAFNnjxZTz31lNLT050ep1Nrbm5Wnz599OSTT+rcc8/Vddddp9mzZ2vhwoVOj9aprFq1So888oh+9atfacOGDXrppZf0yiuv6MEHH3R6NEQBr8y0IT09XV27dtXevXtb7N+7d6/69evX6mP69evXoeMR2Xk+6qc//anmzZun119/XWeffXYsx7ReR8/zv/71L+3cuVOTJk0K72tubpYkdevWTVu3btWgQYNiO7SFIvl8zsjIUPfu3dW1a9fwviFDhqi2tlaHDx9WQkJCTGe2USTnec6cOZo8ebJuvvlmSdLw4cN18OBB3XrrrZo9e7a6dOH/7aOhrX8HU1JSYvaqjMQrM21KSEjQueeeq8rKyvC+5uZmVVZWaty4ca0+Zty4cS2Ol6TXXnutzeMR2XmWpMcee0wPPvigVq5cqVGjRsVjVKt19Dzn5ORo06ZNqq6uDt+uvPJK5ebmqrq6WllZWfEc3xqRfD6PHz9e27ZtC8eiJH344YfKyMggZNoQyXmur68/JliOBqThVxRGjWP/Dsb08mLLLVmyxHi9XrN48WLzwQcfmFtvvdX07NnT1NbWGmOMmTx5spk1a1b4+L///e+mW7du5qc//ampqakxJSUlfGt2O3T0PM+bN88kJCSYP/zhD2bPnj3h24EDB5z6EKzQ0fP8ZXw3U/t09Dz7/X6TnJxs7rjjDrN161bz8ssvmz59+piHHnrIqQ/BCh09zyUlJSY5Odk8//zzZvv27eavf/2rGTRokLn22mud+hCscODAAbNx40azceNGI8nMnz/fbNy40Xz88cfGGGNmzZplJk+eHD7+6Ldmz5gxw9TU1JiKigq+NdsNHn/8cePz+UxCQoIZM2aMeeedd8L3XXTRRaagoKDF8S+++KI588wzTUJCghk2bJh55ZVX4jyxnTpynvv3728kHXMrKSmJ/+CW6ejn8/9FzLRfR8/z22+/bcaOHWu8Xq8ZOHCgefjhh82RI0fiPLV9OnKeGxsbzQMPPGAGDRpkEhMTTVZWlrn99tvN559/Hv/BLfLmm2+2+vft0XNbUFBgLrroomMeM3LkSJOQkGAGDhxonn766ZjP6TGG19cAAIC9uGYGAABYjZgBAABWI2YAAIDViBkAAGA1YgYAAFiNmAEAAFYjZgAAgNWIGQAAYDViBgAAWI2YAQAAViNmAACA1YgZAABgtf8HSMQw9d0hxZcAAAAASUVORK5CYII=",
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "sns.histplot(ratio_suspicious_ctbt, bins=17)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "With a ratio of suspicious contributors above 0.7 the project should be investigated."
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Histogram with all contributions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 155,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot: xlabel='suspicious_flag', ylabel='Count'>"
      ]
     },
     "execution_count": 155,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAjIAAAGxCAYAAAB4AFyyAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjYuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/P9b71AAAACXBIWXMAAA9hAAAPYQGoP6dpAAAtEElEQVR4nO3dfVyUdb7/8fcICHgDKihCgpAZ4E1q3mV2So+s5nZn7maZmmudbFPzhpOZZ0OjTqGeMspcXXsctU3T6qy65WaleFepiKIZG95U6rgK0qQyKIgI1++PHs7PSVFAYOaLr+fjMY+H1+3384HhmrfXdc2MzbIsSwAAAAaq5+kCAAAAqoogAwAAjEWQAQAAxiLIAAAAYxFkAACAsQgyAADAWAQZAABgLIIMAAAwlq+nC6hpZWVlOnbsmBo3biybzebpcgAAQAVYlqWCggJFRESoXr3yz7vU+SBz7NgxRUZGeroMAABQBUeOHFGrVq3KXV7ng0zjxo0l/fKDCAoK8nA1AACgIpxOpyIjI12v4+Wp80HmwuWkoKAgggwAAIa52m0h3OwLAACMRZABAADGIsgAAABjEWQAAICxCDIAAMBYBBkAAGAsggwAADAWQQYAABiLIAMAAIxFkAEAAMbyaJDZvHmz7rvvPkVERMhms2nVqlWuZSUlJZoyZYo6duyohg0bKiIiQo899piOHTvmuYIBAIBX8WiQOXPmjDp16qS5c+desqywsFCZmZlKSkpSZmamVqxYoX379un+++/3QKUAAMAb2SzLsjxdhPTLl0KtXLlSgwYNKnedjIwM9ejRQ4cPH1ZUVFSF9ut0OhUcHKz8/Hy+NBIAAENU9PXbqHtk8vPzZbPZ1KRJE0+XAgAAvICvpwuoqLNnz2rKlCkaOnToFZNZcXGxiouLXdNOp7M2ykMV2O12ORyOWhkrNDS0wmfxAADmMCLIlJSUaMiQIbIsS/PmzbviuikpKUpOTq6lylBVdrtdcXHxKioqrJXxAgMbaO/ebMIMANQxXh9kLoSYw4cPa/369Ve9z2Xq1KlKTEx0TTudTkVGRtZ0magkh8OhoqJC9Xx8uoLCo2t0LGfOIaUvTJbD4SDIAEAd49VB5kKIOXDggDZs2KCQkJCrbuPv7y9/f/9aqA7VISg8Ws2iYj1dBgDAUB4NMqdPn9b333/vmj548KB2796tZs2aKTw8XL///e+VmZmp1atXq7S0VLm5uZKkZs2aqX79+p4qGwAAeAmPBpkdO3aob9++rukLl4RGjhypF198UR9//LEkqXPnzm7bbdiwQX369KmtMgEAgJfyaJDp06ePrvQxNl7yETcAAMBLGfU5MgAAABcjyAAAAGMRZAAAgLEIMgAAwFgEGQAAYCyCDAAAMBZBBgAAGIsgAwAAjEWQAQAAxiLIAAAAYxFkAACAsQgyAADAWAQZAABgLIIMAAAwFkEGAAAYiyADAACMRZABAADGIsgAAABjEWQAAICxCDIAAMBYBBkAAGAsggwAADAWQQYAABiLIAMAAIxFkAEAAMYiyAAAAGMRZAAAgLEIMgAAwFgEGQAAYCyCDAAAMBZBBgAAGIsgAwAAjEWQAQAAxiLIAAAAYxFkAACAsQgyAADAWAQZAABgLIIMAAAwFkEGAAAYiyADAACMRZABAADGIsgAAABjEWQAAICxCDIAAMBYBBkAAGAsggwAADAWQQYAABiLIAMAAIzl0SCzefNm3XfffYqIiJDNZtOqVavclluWpWnTpik8PFyBgYFKSEjQgQMHPFMsAADwOh4NMmfOnFGnTp00d+7cyy6fNWuW3nrrLc2fP1/p6elq2LChBgwYoLNnz9ZypQAAwBv5enLwgQMHauDAgZddZlmWUlNT9cILL+iBBx6QJP31r39VWFiYVq1apUceeaQ2SwUAAF7Io0HmSg4ePKjc3FwlJCS45gUHB6tnz57aunVruUGmuLhYxcXFrmmn01njtdYldrtdDoejxsfJzs6u8TEAAHWf1waZ3NxcSVJYWJjb/LCwMNeyy0lJSVFycnKN1lZX2e12xcXFq6iosNbGLCk+V2tjAQDqHq8NMlU1depUJSYmuqadTqciIyM9WJE5HA6HiooK1fPx6QoKj67RsXK+3aqsjxfo/PnzNToOAKBu89og07JlS0nS8ePHFR4e7pp//Phxde7cudzt/P395e/vX9Pl1WlB4dFqFhVbo2M4cw7V6P4BANcHr/0cmZiYGLVs2VJpaWmueU6nU+np6erVq5cHKwMAAN7Co2dkTp8+re+//941ffDgQe3evVvNmjVTVFSUJk6cqP/+7/9W27ZtFRMTo6SkJEVERGjQoEGeKxoAAHgNjwaZHTt2qG/fvq7pC/e2jBw5UosXL9Zzzz2nM2fOaPTo0Tp16pTuuOMOffbZZwoICPBUyQAAwIt4NMj06dNHlmWVu9xms+mll17SSy+9VItVAQAAU3jtPTIAAABXQ5ABAADGIsgAAABjEWQAAICxCDIAAMBYBBkAAGAsggwAADAWQQYAABiLIAMAAIxFkAEAAMYiyAAAAGMRZAAAgLEIMgAAwFgEGQAAYCyCDAAAMBZBBgAAGIsgAwAAjEWQAQAAxiLIAAAAYxFkAACAsQgyAADAWAQZAABgLIIMAAAwFkEGAAAYiyADAACMRZABAADGIsgAAABjEWQAAICxCDIAAMBYBBkAAGAsggwAADAWQQYAABiLIAMAAIxFkAEAAMYiyAAAAGMRZAAAgLEIMgAAwFgEGQAAYCyCDAAAMBZBBgAAGIsgAwAAjEWQAQAAxiLIAAAAYxFkAACAsQgyAADAWAQZAABgLIIMAAAwllcHmdLSUiUlJSkmJkaBgYFq06aNXn75ZVmW5enSAACAF/D1dAFXMnPmTM2bN0/vvvuu2rdvrx07dmjUqFEKDg7W+PHjPV0eAADwMK8OMlu2bNEDDzyge+65R5IUHR2tZcuWafv27R6uDAAAeAOvvrR0++23Ky0tTfv375ckffPNN/rqq680cOBAD1cGAAC8gVefkXn++efldDoVFxcnHx8flZaW6pVXXtGwYcPK3aa4uFjFxcWuaafTWRulAgAAD/DqMzIffvihli5dqvfff1+ZmZl699139dprr+ndd98td5uUlBQFBwe7HpGRkbVYMQAAqE1eHWQmT56s559/Xo888og6duyoESNGaNKkSUpJSSl3m6lTpyo/P9/1OHLkSC1WDAAAapNXX1oqLCxUvXruWcvHx0dlZWXlbuPv7y9/f/+aLg0AAHgBrw4y9913n1555RVFRUWpffv22rVrl2bPnq3HH3/c06UBAAAv4NVBZs6cOUpKStKYMWOUl5eniIgIPfXUU5o2bZqnSwMAAF7Aq4NM48aNlZqaqtTUVE+XAgAAvJBX3+wLAABwJQQZAABgLIIMAAAwFkEGAAAYiyADAACMRZABAADGIsgAAABjEWQAAICxCDIAAMBYBBkAAGAsggwAADAWQQYAABiLIAMAAIxFkAEAAMYiyAAAAGMRZAAAgLEIMgAAwFgEGQAAYCyCDAAAMBZBBgAAGIsgAwAAjEWQAQAAxvL1dAEAvJvdbpfD4aiVsUJDQxUVFVUrYwGoGwgyAMplt9sVFxevoqLCWhkvMLCB9u7NJswAqDCCDIByORwOFRUVqufj0xUUHl2jYzlzDil9YbIcDgdBBkCFVSnI3HjjjcrIyFBISIjb/FOnTunWW2/Vjz/+WC3FAfAOQeHRahYV6+kyAOASVbrZ99ChQyotLb1kfnFxsY4ePXrNRQEAAFREpc7IfPzxx65/f/755woODnZNl5aWKi0tTdHR0dVWHAAAwJVUKsgMGjRIkmSz2TRy5Ei3ZX5+foqOjtbrr79ebcUBAABcSaWCTFlZmSQpJiZGGRkZCg0NrZGiAAAAKqJKN/sePHiwuusAAACotCq//TotLU1paWnKy8tznam5YOHChddcGAAAwNVUKcgkJyfrpZdeUrdu3RQeHi6bzVbddQEAAFxVlYLM/PnztXjxYo0YMaK66wEAAKiwKn2OzLlz53T77bdXdy0AAACVUqUg8x//8R96//33q7sWAACASqnSpaWzZ89qwYIFWrdunW655Rb5+fm5LZ89e3a1FAcAAHAlVQoye/bsUefOnSVJWVlZbsu48RcAANSWKgWZDRs2VHcdAAAAlVale2QAAAC8QZXOyPTt2/eKl5DWr19f5YIAAAAqqkpB5sL9MReUlJRo9+7dysrKuuTLJAEAAGpKlYLMG2+8cdn5L774ok6fPn1NBQEAAFRUtd4jM3z4cL5nCQAA1JpqDTJbt25VQEBAde4SAACgXFW6tDR48GC3acuylJOTox07digpKalaCgMAALiaKgWZ4OBgt+l69eopNjZWL730kvr3718thQEAAFxNlYLMokWLqrsOAACASrume2R27typJUuWaMmSJdq1a1d11eTm6NGjGj58uEJCQhQYGKiOHTtqx44dNTIWAAAwS5XOyOTl5emRRx7Rxo0b1aRJE0nSqVOn1LdvXy1fvlzNmzevluJOnjyp3r17q2/fvlqzZo2aN2+uAwcOqGnTptWyfwAAYLYqnZF55plnVFBQoH/+8586ceKETpw4oaysLDmdTo0fP77aips5c6YiIyO1aNEi9ejRQzExMerfv7/atGlTbWMAAABzVSnIfPbZZ/rzn/+s+Ph417x27dpp7ty5WrNmTbUV9/HHH6tbt2566KGH1KJFC3Xp0kXvvPNOte0fAACYrUqXlsrKyuTn53fJfD8/P5WVlV1zURf8+OOPmjdvnhITE/Vf//VfysjI0Pjx41W/fv1yvwqhuLhYxcXFrmmn01lt9fya3W6Xw+Gosf1fLDQ0VFFRUbUyFuBJ2dnZNT4Gf09A3VGlIPPv//7vmjBhgpYtW6aIiAhJv9yUO2nSJPXr16/aiisrK1O3bt306quvSpK6dOmirKwszZ8/v9wgk5KSouTk5GqroTx2u11xcfEqKiqs8bEkKTCwgfbuzebgizqrKP9nSTYNHz68xsfi7wmoO6oUZN5++23df//9io6OVmRkpCTpyJEj6tChg5YsWVJtxYWHh6tdu3Zu8+Lj4/W3v/2t3G2mTp2qxMRE17TT6XTVWJ0cDoeKigrV8/HpCgqPrvb9X8yZc0jpC5PlcDg48KLOKikskGSp86NT1DwmrsbG4e8JqFuqFGQiIyOVmZmpdevWae/evZJ+CRgJCQnVWlzv3r21b98+t3n79+9X69aty93G399f/v7+1VrHlQSFR6tZVGytjQfUdY1aRPE3BaDCKnWz7/r169WuXTs5nU7ZbDb95je/0TPPPKNnnnlG3bt3V/v27fXll19WW3GTJk3Stm3b9Oqrr+r777/X+++/rwULFmjs2LHVNgYAADBXpYJMamqqnnzySQUFBV2yLDg4WE899ZRmz55dbcV1795dK1eu1LJly9ShQwe9/PLLSk1N1bBhw6ptDAAAYK5KXVr65ptvNHPmzHKX9+/fX6+99to1F3Wxe++9V/fee2+17hMAANQNlTojc/z48cu+7foCX19f/fTTT9dcFAAAQEVUKsjccMMNysrKKnf5nj17FB4efs1FAQAAVESlgsxvf/tbJSUl6ezZs5csKyoq0vTp07kMBAAAak2l7pF54YUXtGLFCt18880aN26cYmN/eYvk3r17NXfuXJWWlupPf/pTjRQKAADwa5UKMmFhYdqyZYuefvppTZ06VZZlSZJsNpsGDBiguXPnKiwsrEYKBQAA+LVKfyBe69at9emnn+rkyZP6/vvvZVmW2rZtq6ZNm9ZEfQAAAOWq0if7SlLTpk3VvXv36qwFAACgUip1sy8AAIA3IcgAAABjEWQAAICxCDIAAMBYBBkAAGAsggwAADAWQQYAABiLIAMAAIxFkAEAAMYiyAAAAGMRZAAAgLEIMgAAwFgEGQAAYCyCDAAAMBZBBgAAGMvX0wUAtSU7O7vGxwgNDVVUVFSNj4NrVxvPB4nnBFDTCDKo84ryf5Zk0/Dhw2t8rMDABtq7N5sXLi9Wm88HiecEUNMIMqjzSgoLJFnq/OgUNY+Jq7FxnDmHlL4wWQ6HgxctL1ZbzweJ5wRQGwgyuG40ahGlZlGxni4DXoLnA1A3cLMvAAAwFkEGAAAYiyADAACMRZABAADGIsgAAABjEWQAAICxCDIAAMBYBBkAAGAsggwAADAWQQYAABiLIAMAAIxFkAEAAMYiyAAAAGMRZAAAgLEIMgAAwFgEGQAAYCyCDAAAMBZBBgAAGIsgAwAAjEWQAQAAxiLIAAAAYxFkAACAsYwKMjNmzJDNZtPEiRM9XQoAAPACxgSZjIwM/eUvf9Ett9zi6VIAAICXMCLInD59WsOGDdM777yjpk2berocAADgJYwIMmPHjtU999yjhISEq65bXFwsp9Pp9gAAAHWTr6cLuJrly5crMzNTGRkZFVo/JSVFycnJNVwVAADwBl59RubIkSOaMGGCli5dqoCAgAptM3XqVOXn57seR44cqeEqAQCAp3j1GZmdO3cqLy9Pt956q2teaWmpNm/erLffflvFxcXy8fFx28bf31/+/v61XSoAAPAArw4y/fr107fffus2b9SoUYqLi9OUKVMuCTEAAOD64tVBpnHjxurQoYPbvIYNGyokJOSS+QAA4Prj1ffIAAAAXIlXn5G5nI0bN3q6BAAA4CU4IwMAAIxFkAEAAMYiyAAAAGMRZAAAgLEIMgAAwFgEGQAAYCyCDAAAMBZBBgAAGIsgAwAAjEWQAQAAxiLIAAAAYxFkAACAsQgyAADAWAQZAABgLIIMAAAwFkEGAAAYiyADAACMRZABAADGIsgAAABjEWQAAICxCDIAAMBYBBkAAGAsX08XANQ12dnZtTJOaGiooqKiamUswBPsdrscDketjMXfk7kIMkA1Kcr/WZJNw4cPr5XxAgMbaO/ebA6+qJPsdrvi4uJVVFRYK+Px92QuggxQTUoKCyRZ6vzoFDWPiavRsZw5h5S+MFkOh4MDL+okh8OhoqJC9Xx8uoLCo2t0LP6ezEaQAapZoxZRahYV6+kygDohKDyavydcETf7AgAAYxFkAACAsQgyAADAWAQZAABgLIIMAAAwFkEGAAAYiyADAACMRZABAADGIsgAAABjEWQAAICxCDIAAMBYBBkAAGAsggwAADAWQQYAABiLIAMAAIxFkAEAAMYiyAAAAGMRZAAAgLEIMgAAwFgEGQAAYCyCDAAAMJZXB5mUlBR1795djRs3VosWLTRo0CDt27fP02UBAAAv4dVBZtOmTRo7dqy2bdumtWvXqqSkRP3799eZM2c8XRoAAPACvp4u4Eo+++wzt+nFixerRYsW2rlzp+68804PVQUAALyFV5+R+bX8/HxJUrNmzTxcCQAA8AZefUbmYmVlZZo4caJ69+6tDh06lLtecXGxiouLXdNOp7M2ygMAj7Lb7XI4HLUyVmhoqKKiomplrNqUnZ1d42PU1Z+dJxkTZMaOHausrCx99dVXV1wvJSVFycnJtVQVAHie3W5XXFy8iooKa2W8wMAG2rs3u868IBfl/yzJpuHDh9f4WHXtZ+cNjAgy48aN0+rVq7V582a1atXqiutOnTpViYmJrmmn06nIyMiaLhEAPMbhcKioqFA9H5+uoPDoGh3LmXNI6QuT5XA46syLcUlhgSRLnR+douYxcTU2Tl382XkDrw4ylmXpmWee0cqVK7Vx40bFxMRcdRt/f3/5+/vXQnUA4F2CwqPVLCrW02UYq1GLKH5+BvLqIDN27Fi9//77+vvf/67GjRsrNzdXkhQcHKzAwEAPVwcAADzNq9+1NG/ePOXn56tPnz4KDw93PT744ANPlwYAALyAV5+RsSzL0yUAAAAv5tVnZAAAAK6EIAMAAIxFkAEAAMYiyAAAAGMRZAAAgLEIMgAAwFgEGQAAYCyCDAAAMBZBBgAAGIsgAwAAjEWQAQAAxiLIAAAAYxFkAACAsQgyAADAWAQZAABgLIIMAAAwFkEGAAAYiyADAACMRZABAADGIsgAAABjEWQAAICxCDIAAMBYvp4uABWXnZ1t9P5R/XhOmKEu/p7qYk91jd1ul8PhqPFxQkNDFRUVVePjlIcgY4Ci/J8l2TR8+PBaGa+k+FytjIOq4zlhhrr4e6qLPdVFdrtdcXHxKioqrPGxAgMbaO/ebI+FGYKMAUoKCyRZ6vzoFDWPiauxcXK+3aqsjxfo/PnzNTYGqgfPCTPUxd9TXeypLnI4HCoqKlTPx6crKDy6xsZx5hxS+sJkORwOggyurlGLKDWLiq2x/TtzDtXYvlEzeE6YoS7+nupiT3VRUHh0jf6evAE3+wIAAGMRZAAAgLEIMgAAwFgEGQAAYCyCDAAAMBZBBgAAGIsgAwAAjEWQAQAAxiLIAAAAYxFkAACAsQgyAADAWAQZAABgLIIMAAAwFkEGAAAYiyADAACMRZABAADGIsgAAABjEWQAAICxCDIAAMBYBBkAAGAsggwAADAWQQYAABjLiCAzd+5cRUdHKyAgQD179tT27ds9XRIAAPACXh9kPvjgAyUmJmr69OnKzMxUp06dNGDAAOXl5Xm6NAAA4GFeH2Rmz56tJ598UqNGjVK7du00f/58NWjQQAsXLvR0aQAAwMO8OsicO3dOO3fuVEJCgmtevXr1lJCQoK1bt3qwMgAA4A18PV3AlTgcDpWWliosLMxtflhYmPbu3XvZbYqLi1VcXOyazs/PlyQ5nc5qre306dOSpBOH9+l8cVG17vvXnDmHJUn5Rw/Iz9dm/Dh1dSx6MmMsejJjrDrZU65dkrRz507Xa0hN2bdvn6Saf4260NPp06er/XX2wv4sy7ryipYXO3r0qCXJ2rJli9v8yZMnWz169LjsNtOnT7ck8eDBgwcPHjzqwOPIkSNXzApefUYmNDRUPj4+On78uNv848ePq2XLlpfdZurUqUpMTHRNl5WV6cSJEwoJCZHNVn1J2+l0KjIyUkeOHFFQUFC17ddb1OX+6M1cdbk/ejNXXe7Pk71ZlqWCggJFRERccT2vDjL169dX165dlZaWpkGDBkn6JZikpaVp3Lhxl93G399f/v7+bvOaNGlSYzUGBQXVuSfuxepyf/RmrrrcH72Zqy7356negoODr7qOVwcZSUpMTNTIkSPVrVs39ejRQ6mpqTpz5oxGjRrl6dIAAICHeX2Qefjhh/XTTz9p2rRpys3NVefOnfXZZ59dcgMwAAC4/nh9kJGkcePGlXspyVP8/f01ffr0Sy5j1RV1uT96M1dd7o/ezFWX+zOhN5tlXe19TQAAAN7Jqz8QDwAA4EoIMgAAwFgEGQAAYCyCTBXNnTtX0dHRCggIUM+ePbV9+3ZPl1RpKSkp6t69uxo3bqwWLVpo0KBBro+1vuDs2bMaO3asQkJC1KhRI/3ud7+75AMKTTBjxgzZbDZNnDjRNc/03o4eParhw4crJCREgYGB6tixo3bs2OFablmWpk2bpvDwcAUGBiohIUEHDhzwYMUVU1paqqSkJMXExCgwMFBt2rTRyy+/7PYx5ab0tnnzZt13332KiIiQzWbTqlWr3JZXpI8TJ05o2LBhCgoKUpMmTfTEE0/U+MfbV9SV+ispKdGUKVPUsWNHNWzYUBEREXrsscd07Ngxt314a39X+91d7I9//KNsNptSU1Pd5pvcW3Z2tu6//34FBwerYcOG6t69u+x2u2u5Nx0/CTJV8MEHHygxMVHTp09XZmamOnXqpAEDBigvL8/TpVXKpk2bNHbsWG3btk1r165VSUmJ+vfvrzNnzrjWmTRpkj755BN99NFH2rRpk44dO6bBgwd7sOrKy8jI0F/+8hfdcsstbvNN7u3kyZPq3bu3/Pz8tGbNGn333Xd6/fXX1bRpU9c6s2bN0ltvvaX58+crPT1dDRs21IABA3T27FkPVn51M2fO1Lx58/T2228rOztbM2fO1KxZszRnzhzXOqb0dubMGXXq1Elz58697PKK9DFs2DD985//1Nq1a7V69Wpt3rxZo0ePrq0WruhK/RUWFiozM1NJSUnKzMzUihUrtG/fPt1///1u63lrf1f73V2wcuVKbdu27bKfPmtqbz/88IPuuOMOxcXFaePGjdqzZ4+SkpIUEBDgWserjp/X/o1I158ePXpYY8eOdU2XlpZaERERVkpKigerunZ5eXmWJGvTpk2WZVnWqVOnLD8/P+ujjz5yrZOdnW1JsrZu3eqpMiuloKDAatu2rbV27VrrrrvusiZMmGBZlvm9TZkyxbrjjjvKXV5WVma1bNnS+p//+R/XvFOnTln+/v7WsmXLaqPEKrvnnnusxx9/3G3e4MGDrWHDhlmWZW5vkqyVK1e6pivSx3fffWdJsjIyMlzrrFmzxrLZbNbRo0drrfaK+HV/l7N9+3ZLknX48GHLsszpr7ze/vWvf1k33HCDlZWVZbVu3dp64403XMtM7u3hhx+2hg8fXu423nb85IxMJZ07d047d+5UQkKCa169evWUkJCgrVu3erCya3fhm8KbNWsm6ZdvaC0pKXHrNS4uTlFRUcb0OnbsWN1zzz1uPUjm9/bxxx+rW7dueuihh9SiRQt16dJF77zzjmv5wYMHlZub69ZfcHCwevbs6fX93X777UpLS9P+/fslSd98842++uorDRw4UJLZvV2sIn1s3bpVTZo0Ubdu3VzrJCQkqF69ekpPT6/1mq9Vfn6+bDab62tjTO6vrKxMI0aM0OTJk9W+fftLlpvaW1lZmf7xj3/o5ptv1oABA9SiRQv17NnT7fKTtx0/CTKV5HA4VFpaesknC4eFhSk3N9dDVV27srIyTZw4Ub1791aHDh0kSbm5uapfv/4l31VlSq/Lly9XZmamUlJSLllmem8//vij5s2bp7Zt2+rzzz/X008/rfHjx+vdd9+VJFcPJj5Pn3/+eT3yyCOKi4uTn5+funTpookTJ2rYsGGSzO7tYhXpIzc3Vy1atHBb7uvrq2bNmhnVq/TLPRVTpkzR0KFDXd/ZY3J/M2fOlK+vr8aPH3/Z5ab2lpeXp9OnT2vGjBm6++679cUXX+jBBx/U4MGDtWnTJkned/w04pN9UfPGjh2rrKwsffXVV54upVocOXJEEyZM0Nq1a92u69YVZWVl6tatm1599VVJUpcuXZSVlaX58+dr5MiRHq7u2nz44YdaunSp3n//fbVv3167d+/WxIkTFRERYXxv16uSkhINGTJElmVp3rx5ni7nmu3cuVNvvvmmMjMzZbPZPF1OtSorK5MkPfDAA5o0aZIkqXPnztqyZYvmz5+vu+66y5PlXRZnZCopNDRUPj4+l9ydffz4cbVs2dJDVV2bcePGafXq1dqwYYNatWrlmt+yZUudO3dOp06dclvfhF537typvLw83XrrrfL19ZWvr682bdqkt956S76+vgoLCzO2N0kKDw9Xu3bt3ObFx8e73lVwoQcTn6eTJ092nZXp2LGjRowYoUmTJrnOrJnc28Uq0kfLli0veRPB+fPndeLECWN6vRBiDh8+rLVr17p9g7Kp/X355ZfKy8tTVFSU6/hy+PBh/ed//qeio6MlmdtbaGiofH19r3p88abjJ0GmkurXr6+uXbsqLS3NNa+srExpaWnq1auXByurPMuyNG7cOK1cuVLr169XTEyM2/KuXbvKz8/Prdd9+/bJbrd7fa/9+vXTt99+q927d7se3bp107Bhw1z/NrU3Serdu/clb5Xfv3+/WrduLUmKiYlRy5Yt3fpzOp1KT0/3+v4KCwtVr577ocnHx8f1P0WTe7tYRfro1auXTp06pZ07d7rWWb9+vcrKytSzZ89ar7myLoSYAwcOaN26dQoJCXFbbmp/I0aM0J49e9yOLxEREZo8ebI+//xzSeb2Vr9+fXXv3v2Kxxeve22o9duL64Dly5db/v7+1uLFi63vvvvOGj16tNWkSRMrNzfX06VVytNPP20FBwdbGzdutHJyclyPwsJC1zp//OMfraioKGv9+vXWjh07rF69elm9evXyYNVVd/G7lizL7N62b99u+fr6Wq+88op14MABa+nSpVaDBg2sJUuWuNaZMWOG1aRJE+vvf/+7tWfPHuuBBx6wYmJirKKiIg9WfnUjR460brjhBmv16tXWwYMHrRUrVlihoaHWc88951rHlN4KCgqsXbt2Wbt27bIkWbNnz7Z27drletdORfq4++67rS5duljp6enWV199ZbVt29YaOnSop1pyc6X+zp07Z91///1Wq1atrN27d7sdY4qLi1378Nb+rva7+7Vfv2vJssztbcWKFZafn5+1YMEC68CBA9acOXMsHx8f68svv3Ttw5uOnwSZKpozZ44VFRVl1a9f3+rRo4e1bds2T5dUaZIu+1i0aJFrnaKiImvMmDFW06ZNrQYNGlgPPviglZOT47mir8Gvg4zpvX3yySdWhw4dLH9/fysuLs5asGCB2/KysjIrKSnJCgsLs/z9/a1+/fpZ+/bt81C1Fed0Oq0JEyZYUVFRVkBAgHXjjTdaf/rTn9xe/EzpbcOGDZf9Gxs5cqRlWRXr4+eff7aGDh1qNWrUyAoKCrJGjRplFRQUeKCbS12pv4MHD5Z7jNmwYYNrH97a39V+d792uSBjcm//+7//a910001WQECA1alTJ2vVqlVu+/Cm4yfffg0AAIzFPTIAAMBYBBkAAGAsggwAADAWQQYAABiLIAMAAIxFkAEAAMYiyAAAAGMRZAAAgLEIMgBqVXR0tFJTUyu07uLFi9WkSZMaracy9u7dq9tuu00BAQHq3LmzDh06JJvNpt27d3u6NOC65evpAgBcXzIyMtSwYcMKrfvwww/rt7/9bQ1XVHHTp09Xw4YNtW/fPjVq1EgFBQWeLgm47hFkANSq5s2bV3jdwMBABQYG1mA1lfPDDz/onnvucX0LMEEG8DwuLQHXof/7v/9Tx44dFRgYqJCQECUkJOjMmTPq06ePJk6c6LbuoEGD9Ic//ME1/ec//1lt27ZVQECAwsLC9Pvf/961rE+fPho3bpzGjRun4OBghYaGKikpSRd/pduvLy2dOnVKTz31lMLCwhQQEKAOHTpo9erVki5/aWnevHlq06aN6tevr9jYWL333nuuZZe71HPq1CnZbDZt3LhRknTy5EkNGzZMzZs3V2BgoNq2batFixZd9Wdms9m0c+dOvfTSS7LZbHrxxRcvWae0tFRPPPGEYmJiFBgYqNjYWL355ptu65w/f17jx49XkyZNFBISoilTpmjkyJEaNGjQVWsAcCnOyADXmZycHA0dOlSzZs3Sgw8+qIKCAn355ZeqyPfH7tixQ+PHj9d7772n22+/XSdOnNCXX37pts67776rJ554Qtu3b9eOHTs0evRoRUVF6cknn7xkf2VlZRo4cKAKCgq0ZMkStWnTRt999518fHwuO/7KlSs1YcIEpaamKiEhQatXr9aoUaPUqlUr9e3bt0L9JyUl6bvvvtOaNWsUGhqq77//XkVFRVfdLicnRwkJCbr77rv17LPPqlGjRnI4HJf006pVK3300UcKCQnRli1bNHr0aIWHh2vIkCGSpJkzZ2rp0qVatGiR4uPj9eabb2rVqlUVrh+AO4IMcJ3JycnR+fPnNXjwYNclko4dO1ZoW7vdroYNG+ree+9V48aN1bp1a3Xp0sVtncjISL3xxhuy2WyKjY3Vt99+qzfeeOOyQWbdunXavn27srOzdfPNN0uSbrzxxnLHf+211/SHP/xBY8aMkSQlJiZq27Zteu211yocBOx2u7p06aJu3bpJ+uUMUUW0bNlSvr6+atSokVq2bClJlwQZPz8/JScnu6ZjYmK0detWffjhh64gM2fOHE2dOlUPPvigJOntt9/Wp59+WqEaAFyKS0vAdaZTp07q16+fOnbsqIceekjvvPOOTp48WaFtf/Ob36h169a68cYbNWLECC1dulSFhYVu69x2222y2Wyu6V69eunAgQMqLS29ZH+7d+9Wq1atXCHmarKzs9W7d2+3eb1791Z2dnaFtpekp59+WsuXL1fnzp313HPPacuWLRXetiLmzp2rrl27qnnz5mrUqJEWLFggu90uScrPz9fx48fVo0cP1/o+Pj7q2rVrtdYAXE8IMsB1xsfHR2vXrtWaNWvUrl07zZkzR7GxsTp48KDq1at3ySWmkpIS178bN26szMxMLVu2TOHh4Zo2bZo6deqkU6dOVamW6r6Rt169Xw5pF/dwcf2SNHDgQB0+fFiTJk3SsWPH1K9fPz377LPVMv7y5cv17LPP6oknntAXX3yh3bt3a9SoUTp37ly17B/ApQgywHXIZrOpd+/eSk5O1q5du1S/fn2tXLlSzZs3V05Ojmu90tJSZWVluW3r6+urhIQEzZo1S3v27NGhQ4e0fv161/L09HS39bdt26a2bdte9r6XW265Rf/617+0f//+CtUdHx+vr7/+2m3e119/rXbt2kn6/++IuriHy33GS/PmzTVy5EgtWbJEqampWrBgQYXGv5qvv/5at99+u8aMGaMuXbropptu0g8//OBaHhwcrLCwMGVkZLjmlZaWKjMzs1rGB65H3CMDXGfS09OVlpam/v37q0WLFkpPT9dPP/2k+Ph4NWzYUImJifrHP/6hNm3aaPbs2W5nW1avXq0ff/xRd955p5o2bapPP/1UZWVlio2Nda1jt9uVmJiop556SpmZmZozZ45ef/31y9Zy11136c4779Tvfvc7zZ49WzfddJP27t0rm82mu++++5L1J0+erCFDhqhLly5KSEjQJ598ohUrVmjdunWSfjnDc9ttt2nGjBmKiYlRXl6eXnjhBbd9TJs2TV27dlX79u1VXFys1atXKz4+vhp+slLbtm3117/+VZ9//rliYmL03nvvKSMjQzExMa51nnnmGaWkpOimm25SXFyc5syZo5MnT7pdjgNQcQQZ4DoTFBSkzZs3KzU1VU6nU61bt9brr7+ugQMHqqSkRN98840ee+wx+fr6atKkSW430TZp0kQrVqzQiy++qLNnz6pt27ZatmyZ2rdv71rnscceU1FRkXr06CEfHx9NmDBBo0ePLreev/3tb3r22Wc1dOhQnTlzRjfddJNmzJhx2XUHDRqkN998U6+99pomTJigmJgYLVq0SH369HGts3DhQj3xxBPq2rWrYmNjNWvWLPXv39+1vH79+po6daoOHTqkwMBA/du//ZuWL19+DT/R/++pp57Srl279PDDD8tms2no0KEaM2aM1qxZ41pnypQpys3N1WOPPSYfHx+NHj1aAwYMKPedWgCuzGZV5D2XAFABffr0UefOnSv8FQT45S3b8fHxGjJkiF5++WVPlwMYhzMyAFCLDh8+rC+++EJ33XWXiouL9fbbb+vgwYN69NFHPV0aYCRu9gUASa+++qoaNWp02cfAgQOrbZx69epp8eLF6t69u3r37q1vv/1W69atq7b7dIDrDZeWAEDSiRMndOLEicsuCwwM1A033FDLFQGoCIIMAAAwFpeWAACAsQgyAADAWAQZAABgLIIMAAAwFkEGAAAYiyADAACMRZABAADGIsgAAABj/T8U/iZoYHHM/AAAAABJRU5ErkJggg==",
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "sns.histplot(df_ctbt_round.groupby(['project_address']).suspicious_flag.sum(), bins=17)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Above 60 suspicious flag for a project the project is highly suspicious"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Retrieve suspicious project from climate grant"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 164,
   "metadata": {},
   "outputs": [],
   "source": [
    "suspicious_project_address = ratio_suspicious_ctbt[ratio_suspicious_ctbt > 0.7]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 167,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "There are 15 very suspicious projects\n"
     ]
    }
   ],
   "source": [
    "print(f\"There are {suspicious_project_address.shape[0]} very suspicious projects\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 177,
   "metadata": {},
   "outputs": [],
   "source": [
    "suspicious_applications = df_applications.loc[df_applications['project_address'].isin(suspicious_project_address.index.values), :]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 178,
   "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>grant_id</th>\n",
       "      <th>project_active_grant</th>\n",
       "      <th>project_approved</th>\n",
       "      <th>project_address</th>\n",
       "      <th>project_title</th>\n",
       "      <th>project_website</th>\n",
       "      <th>project_decription</th>\n",
       "      <th>project_created_at</th>\n",
       "      <th>project_round</th>\n",
       "      <th>project_long_id</th>\n",
       "      <th>...</th>\n",
       "      <th>project_funding_source</th>\n",
       "      <th>project_team_size</th>\n",
       "      <th>live_on_other_chains</th>\n",
       "      <th>project_value</th>\n",
       "      <th>project_improvements_to_existing</th>\n",
       "      <th>project_github_twitter_credential</th>\n",
       "      <th>project_github_org_link</th>\n",
       "      <th>project_amount_received</th>\n",
       "      <th>project_contributor_count</th>\n",
       "      <th>project_contribution_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>819</th>\n",
       "      <td>0x30b826002362b50fbcc7ee9ccd0515e4ab91c14141d3...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x08a3c2a819e3de7aca384c798269b3ce1cd0e437</td>\n",
       "      <td>DefiLlama</td>\n",
       "      <td>https://defillama.com/</td>\n",
       "      <td>Open and transparent DeFi TVL and analytics. F...</td>\n",
       "      <td>2022-11-18 19:46:02</td>\n",
       "      <td>FANTOM</td>\n",
       "      <td>0x30b826002362b50fbcc7ee9ccd0515e4ab91c14141d3...</td>\n",
       "      <td>...</td>\n",
       "      <td>Previously received funding from Gitcoin Grant...</td>\n",
       "      <td>13</td>\n",
       "      <td>Yes, DefiLlama tracks almost all chains and Ll...</td>\n",
       "      <td>We track DeFi metrics for fantom projects, suc...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15454.296579</td>\n",
       "      <td>10064.0</td>\n",
       "      <td>11904.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>821</th>\n",
       "      <td>0x37ad3db0b0bc56cea1909e6a6f21fd35453ef27f1d9a...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0xe126b3e5d052f1f575828f61feba4f4f2603652a</td>\n",
       "      <td>Revoke.cash - Helping you stay safe in web3</td>\n",
       "      <td>https://revoke.cash</td>\n",
       "      <td>Hey all, we're building free and open source t...</td>\n",
       "      <td>2022-12-01 22:26:19</td>\n",
       "      <td>FANTOM</td>\n",
       "      <td>0x37ad3db0b0bc56cea1909e6a6f21fd35453ef27f1d9a...</td>\n",
       "      <td>...</td>\n",
       "      <td>Gitcoin Grants</td>\n",
       "      <td>1</td>\n",
       "      <td>Yes, Revoke.cash supports 30+ chains, and the ...</td>\n",
       "      <td>As a DeFi ecosystem grows more funds will be a...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7404.270070</td>\n",
       "      <td>7842.0</td>\n",
       "      <td>8636.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>985</th>\n",
       "      <td>0x429927c3a14cbe156749adb31371f385749150ac3604...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x7f06ac71366631157551d97559b82975c293fdba</td>\n",
       "      <td>Ethereum on ARM</td>\n",
       "      <td>https://ethereum-on-arm-documentation.readthed...</td>\n",
       "      <td>Help us to build a &lt;$400 PnP Ethereum full/arc...</td>\n",
       "      <td>2023-01-11 13:26:23</td>\n",
       "      <td>ETHEREUM</td>\n",
       "      <td>0x429927c3a14cbe156749adb31371f385749150ac3604...</td>\n",
       "      <td>...</td>\n",
       "      <td>Gitcoin Grants, EF and QF rounds</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>751.312258</td>\n",
       "      <td>411.0</td>\n",
       "      <td>420.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>986</th>\n",
       "      <td>0x46de99c3a4e0542fde6d77bfa1ff6d19e107f253ea52...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x08a3c2a819e3de7aca384c798269b3ce1cd0e437</td>\n",
       "      <td>Chainlist</td>\n",
       "      <td>https://chainlist.org/</td>\n",
       "      <td>We track all RPCs available for all chains, mo...</td>\n",
       "      <td>2023-01-15 23:49:35</td>\n",
       "      <td>ETHEREUM</td>\n",
       "      <td>0x46de99c3a4e0542fde6d77bfa1ff6d19e107f253ea52...</td>\n",
       "      <td>...</td>\n",
       "      <td>Donations + self-funding</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15454.296579</td>\n",
       "      <td>10064.0</td>\n",
       "      <td>11904.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>0x99b81016d61f8b9115282b1055649d4876f386197590...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x9cce47e9cf12c6147c9844adbb81fe85880c4df4</td>\n",
       "      <td>NiceNode: Run a node — just press start</td>\n",
       "      <td>https://nicenode.xyz</td>\n",
       "      <td>\\nThe current options to run a node require te...</td>\n",
       "      <td>2023-01-10 20:25:23</td>\n",
       "      <td>ETHEREUM</td>\n",
       "      <td>0x99b81016d61f8b9115282b1055649d4876f386197590...</td>\n",
       "      <td>...</td>\n",
       "      <td>Gitcoin, CityDAO, EF ESP program</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes for Twitter, working on Github (was an error)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>627.757908</td>\n",
       "      <td>433.0</td>\n",
       "      <td>436.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1006</th>\n",
       "      <td>0xfce9d62f9a833d6f7185f0051701d5a9e64c83d1daca...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x08a3c2a819e3de7aca384c798269b3ce1cd0e437</td>\n",
       "      <td>DefiLlama APIs</td>\n",
       "      <td>https://defillama.com</td>\n",
       "      <td>DefiLlama provides multiple APIs for free that...</td>\n",
       "      <td>2023-01-14 22:00:59</td>\n",
       "      <td>ETHEREUM</td>\n",
       "      <td>0xfce9d62f9a833d6f7185f0051701d5a9e64c83d1daca...</td>\n",
       "      <td>...</td>\n",
       "      <td>Donations + self-funding</td>\n",
       "      <td>11 full time people + 2 interns</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15454.296579</td>\n",
       "      <td>10064.0</td>\n",
       "      <td>11904.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1011</th>\n",
       "      <td>0x0f1d31d427400106f3d2958225dd235ae60b6a7572fb...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x01d79bceaeaadfb8fd2f2f53005289cfcf483464</td>\n",
       "      <td>Lenstube</td>\n",
       "      <td>https://lenstube.xyz</td>\n",
       "      <td>Decentralized video-sharing social media platf...</td>\n",
       "      <td>2023-01-12 06:50:23</td>\n",
       "      <td>OSS</td>\n",
       "      <td>0x0f1d31d427400106f3d2958225dd235ae60b6a7572fb...</td>\n",
       "      <td>...</td>\n",
       "      <td>Nil</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>User Account - sasicodes, Organization Account...</td>\n",
       "      <td>3560.551441</td>\n",
       "      <td>3035.0</td>\n",
       "      <td>3121.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1021</th>\n",
       "      <td>0x20632d089357836c07c38ae6a8b50449fa86c9eef6fd...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x7bd7de26ebd064465bb9c272513bb3bcbddb1e93</td>\n",
       "      <td>White Hat DAO</td>\n",
       "      <td>https://whitehatdao.com</td>\n",
       "      <td>Safety and security should be at the heart of ...</td>\n",
       "      <td>2023-01-08 21:15:59</td>\n",
       "      <td>OSS</td>\n",
       "      <td>0x20632d089357836c07c38ae6a8b50449fa86c9eef6fd...</td>\n",
       "      <td>...</td>\n",
       "      <td>Grants + raising funds through smart contract ...</td>\n",
       "      <td>19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>https://github.com/WhiteHatDAO</td>\n",
       "      <td>164.848446</td>\n",
       "      <td>157.0</td>\n",
       "      <td>160.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1029</th>\n",
       "      <td>0x3e4b3f7089aa5cb6614b67e235624d01364febe41841...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x1208a26faa0f4ac65b42098419eb4daa5e580ac6</td>\n",
       "      <td>Optinames | ENS on Optimism</td>\n",
       "      <td>https://optinames.eth.limo</td>\n",
       "      <td>What are Optinames?\\n\\nOptinames are tradable ...</td>\n",
       "      <td>2023-01-15 10:04:47</td>\n",
       "      <td>OSS</td>\n",
       "      <td>0x3e4b3f7089aa5cb6614b67e235624d01364febe41841...</td>\n",
       "      <td>...</td>\n",
       "      <td>Gitcoin Grants</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>https://github.com/stevegachau</td>\n",
       "      <td>1918.848550</td>\n",
       "      <td>1628.0</td>\n",
       "      <td>1664.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1032</th>\n",
       "      <td>0x43b94c544e8ac90c535752b8624e730820a5a752b361...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x799b774204a348e1182fe01074c51444ba70a149</td>\n",
       "      <td>0xDeadList</td>\n",
       "      <td>https://0xdeadlist.io</td>\n",
       "      <td>Inspiration\\nWhen we say that an Ethereum acco...</td>\n",
       "      <td>2023-01-08 07:38:23</td>\n",
       "      <td>OSS</td>\n",
       "      <td>0x43b94c544e8ac90c535752b8624e730820a5a752b361...</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>https://github.com/colinlyguo</td>\n",
       "      <td>116.124192</td>\n",
       "      <td>106.0</td>\n",
       "      <td>109.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1033</th>\n",
       "      <td>0x46ddc886ac23d5bc2cbc96cd2aa990627bcd98c881a9...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x08a3c2a819e3de7aca384c798269b3ce1cd0e437</td>\n",
       "      <td>DefiLlama</td>\n",
       "      <td>https://defillama.com/</td>\n",
       "      <td>Open and transparent DeFi TVL and analytics</td>\n",
       "      <td>2023-01-14 21:38:23</td>\n",
       "      <td>OSS</td>\n",
       "      <td>0x46ddc886ac23d5bc2cbc96cd2aa990627bcd98c881a9...</td>\n",
       "      <td>...</td>\n",
       "      <td>Donations + self-funding</td>\n",
       "      <td>11 full time people + 2 interns</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>org account: https://github.com/DefiLlama, my ...</td>\n",
       "      <td>15454.296579</td>\n",
       "      <td>10064.0</td>\n",
       "      <td>11904.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1047</th>\n",
       "      <td>0x60c037f9dfa5daee0f07bc26fb73393ef924e36c73c4...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x18aa467e40e1defb1956708830a343c1d01d3d7c</td>\n",
       "      <td>JediSwap</td>\n",
       "      <td>https://jediswap.xyz</td>\n",
       "      <td>Note: Donations for this grant are for develop...</td>\n",
       "      <td>2023-01-17 07:47:47</td>\n",
       "      <td>OSS</td>\n",
       "      <td>0x60c037f9dfa5daee0f07bc26fb73393ef924e36c73c4...</td>\n",
       "      <td>...</td>\n",
       "      <td>Gitcoin grant mainly. No external funding. Mes...</td>\n",
       "      <td>300+ contributors (dev + non dev)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>https://github.com/jediswapintern, https://git...</td>\n",
       "      <td>5370.176026</td>\n",
       "      <td>4163.0</td>\n",
       "      <td>4270.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1050</th>\n",
       "      <td>0x67583b52562147ffe4d7b9c4422c6109d0d18a596c25...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x9d100f017095e53b24d81296bca1d26742f1800f</td>\n",
       "      <td>StarkDeFi</td>\n",
       "      <td>https://www.starkdefi.com</td>\n",
       "      <td>StarkDeFi is a suite of decentralized financia...</td>\n",
       "      <td>2023-01-09 20:47:11</td>\n",
       "      <td>OSS</td>\n",
       "      <td>0x67583b52562147ffe4d7b9c4422c6109d0d18a596c25...</td>\n",
       "      <td>...</td>\n",
       "      <td>GR15</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>YES</td>\n",
       "      <td>https://github.com/Starkdefi/StarkDefi-contracts</td>\n",
       "      <td>4493.664469</td>\n",
       "      <td>3636.0</td>\n",
       "      <td>3729.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1062</th>\n",
       "      <td>0x8029c7cda58d70a6cd81ac56a6a678e8ccfb560f153e...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0xfe97e32a873aa2f926fbfc560abeef01f753c128</td>\n",
       "      <td>Soul Wallet</td>\n",
       "      <td>https://soulwallets.me</td>\n",
       "      <td>Next-gen Ethereum wallet for everyone.</td>\n",
       "      <td>2023-01-13 21:10:35</td>\n",
       "      <td>OSS</td>\n",
       "      <td>0x8029c7cda58d70a6cd81ac56a6a678e8ccfb560f153e...</td>\n",
       "      <td>...</td>\n",
       "      <td>Ethereum community and VCs</td>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>https://github.com/proofofsoulprotocol/soul-wa...</td>\n",
       "      <td>629.748810</td>\n",
       "      <td>708.0</td>\n",
       "      <td>717.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1069</th>\n",
       "      <td>0x91db8779fa1b15d75761e358fe57683892c68d5cad11...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x2af4125c8fe208a349ef78d3cb980308ab1ed34f</td>\n",
       "      <td>Proof of Humanity</td>\n",
       "      <td>https://proofofhumanity.eth.limo</td>\n",
       "      <td>Sybil-resistant registry of Humans using socia...</td>\n",
       "      <td>2023-01-16 18:01:47</td>\n",
       "      <td>OSS</td>\n",
       "      <td>0x91db8779fa1b15d75761e358fe57683892c68d5cad11...</td>\n",
       "      <td>...</td>\n",
       "      <td>Non profits</td>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Didnt work</td>\n",
       "      <td>Democracy Earth Foundation</td>\n",
       "      <td>1723.308271</td>\n",
       "      <td>1737.0</td>\n",
       "      <td>1775.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1078</th>\n",
       "      <td>0x9fb5b0d0698dc64cbd3a01c5205ebc5ef609e7d20c21...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x57ea12a3a8e441f5fe7b1f3af1121097b7d3b6a8</td>\n",
       "      <td>Umbra</td>\n",
       "      <td>https://app.umbra.cash</td>\n",
       "      <td>Umbra is a protocol that lets you get paid pri...</td>\n",
       "      <td>2023-01-12 18:59:11</td>\n",
       "      <td>OSS</td>\n",
       "      <td>0x9fb5b0d0698dc64cbd3a01c5205ebc5ef609e7d20c21...</td>\n",
       "      <td>...</td>\n",
       "      <td>Grants</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>https://github.com/apbendi, https://github.com...</td>\n",
       "      <td>1503.918455</td>\n",
       "      <td>1228.0</td>\n",
       "      <td>1259.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1090</th>\n",
       "      <td>0xafb022ea11846bceb90516c35155defd6404e4948697...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x99b36fdbc582d113af36a21eba06bfeab7b9be12</td>\n",
       "      <td>Tally Ho! - Open Source and Community Owned Wa...</td>\n",
       "      <td>https://tallyho.org</td>\n",
       "      <td>Help fund the development of the first open so...</td>\n",
       "      <td>2023-01-13 19:20:59</td>\n",
       "      <td>OSS</td>\n",
       "      <td>0xafb022ea11846bceb90516c35155defd6404e4948697...</td>\n",
       "      <td>...</td>\n",
       "      <td>Thesis is funding the development currently</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>https://github.com/tallyhowallet</td>\n",
       "      <td>6610.313733</td>\n",
       "      <td>3658.0</td>\n",
       "      <td>3749.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1101</th>\n",
       "      <td>0xbe519f8c8f7ff2acb359dd757c5d2bf25b05d9fd29b8...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x3a5bd1e37b099ae3386d13947b6a90d97675e5e3</td>\n",
       "      <td>Lenster</td>\n",
       "      <td>https://lenster.xyz</td>\n",
       "      <td>Lenster is a decentralized and permissionless ...</td>\n",
       "      <td>2023-01-07 07:15:23</td>\n",
       "      <td>OSS</td>\n",
       "      <td>0xbe519f8c8f7ff2acb359dd757c5d2bf25b05d9fd29b8...</td>\n",
       "      <td>...</td>\n",
       "      <td>Ethereum, Polygon, zkSync</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>https://github.com/bigint, https://github.com/...</td>\n",
       "      <td>8058.569967</td>\n",
       "      <td>5075.0</td>\n",
       "      <td>5222.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1124</th>\n",
       "      <td>0xe797fdf65ab6db40d29cb7144e8715799a91c9a2f8a7...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x1208a26faa0f4ac65b42098419eb4daa5e580ac6</td>\n",
       "      <td>MintBot | Polygon NFT Minter + ENS SubDomains ...</td>\n",
       "      <td>https://mintbot.io</td>\n",
       "      <td>Mintbot started out as a service that allows E...</td>\n",
       "      <td>2023-01-10 12:47:47</td>\n",
       "      <td>OSS</td>\n",
       "      <td>0xe797fdf65ab6db40d29cb7144e8715799a91c9a2f8a7...</td>\n",
       "      <td>...</td>\n",
       "      <td>Gitcoin Grants</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>https://github.com/stevegachau</td>\n",
       "      <td>1918.848550</td>\n",
       "      <td>1628.0</td>\n",
       "      <td>1664.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1126</th>\n",
       "      <td>0xf05829c76e3da92a8942378240ab4dc70c8c509f558e...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0xe126b3e5d052f1f575828f61feba4f4f2603652a</td>\n",
       "      <td>Revoke.cash - Helping you stay safe in web3</td>\n",
       "      <td>https://revoke.cash</td>\n",
       "      <td>Hey all, we're building free and open source t...</td>\n",
       "      <td>2023-01-17 05:07:47</td>\n",
       "      <td>OSS</td>\n",
       "      <td>0xf05829c76e3da92a8942378240ab4dc70c8c509f558e...</td>\n",
       "      <td>...</td>\n",
       "      <td>Gitcoin Grants</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>https://github.com/rkalis, https://github.com/...</td>\n",
       "      <td>7404.270070</td>\n",
       "      <td>7842.0</td>\n",
       "      <td>8636.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               grant_id project_active_grant  \\\n",
       "819   0x30b826002362b50fbcc7ee9ccd0515e4ab91c14141d3...                  NaN   \n",
       "821   0x37ad3db0b0bc56cea1909e6a6f21fd35453ef27f1d9a...                  NaN   \n",
       "985   0x429927c3a14cbe156749adb31371f385749150ac3604...                  NaN   \n",
       "986   0x46de99c3a4e0542fde6d77bfa1ff6d19e107f253ea52...                  NaN   \n",
       "996   0x99b81016d61f8b9115282b1055649d4876f386197590...                  NaN   \n",
       "1006  0xfce9d62f9a833d6f7185f0051701d5a9e64c83d1daca...                  NaN   \n",
       "1011  0x0f1d31d427400106f3d2958225dd235ae60b6a7572fb...                  NaN   \n",
       "1021  0x20632d089357836c07c38ae6a8b50449fa86c9eef6fd...                  NaN   \n",
       "1029  0x3e4b3f7089aa5cb6614b67e235624d01364febe41841...                  NaN   \n",
       "1032  0x43b94c544e8ac90c535752b8624e730820a5a752b361...                  NaN   \n",
       "1033  0x46ddc886ac23d5bc2cbc96cd2aa990627bcd98c881a9...                  NaN   \n",
       "1047  0x60c037f9dfa5daee0f07bc26fb73393ef924e36c73c4...                  NaN   \n",
       "1050  0x67583b52562147ffe4d7b9c4422c6109d0d18a596c25...                  NaN   \n",
       "1062  0x8029c7cda58d70a6cd81ac56a6a678e8ccfb560f153e...                  NaN   \n",
       "1069  0x91db8779fa1b15d75761e358fe57683892c68d5cad11...                  NaN   \n",
       "1078  0x9fb5b0d0698dc64cbd3a01c5205ebc5ef609e7d20c21...                  NaN   \n",
       "1090  0xafb022ea11846bceb90516c35155defd6404e4948697...                  NaN   \n",
       "1101  0xbe519f8c8f7ff2acb359dd757c5d2bf25b05d9fd29b8...                  NaN   \n",
       "1124  0xe797fdf65ab6db40d29cb7144e8715799a91c9a2f8a7...                  NaN   \n",
       "1126  0xf05829c76e3da92a8942378240ab4dc70c8c509f558e...                  NaN   \n",
       "\n",
       "     project_approved                             project_address  \\\n",
       "819               NaN  0x08a3c2a819e3de7aca384c798269b3ce1cd0e437   \n",
       "821               NaN  0xe126b3e5d052f1f575828f61feba4f4f2603652a   \n",
       "985               NaN  0x7f06ac71366631157551d97559b82975c293fdba   \n",
       "986               NaN  0x08a3c2a819e3de7aca384c798269b3ce1cd0e437   \n",
       "996               NaN  0x9cce47e9cf12c6147c9844adbb81fe85880c4df4   \n",
       "1006              NaN  0x08a3c2a819e3de7aca384c798269b3ce1cd0e437   \n",
       "1011              NaN  0x01d79bceaeaadfb8fd2f2f53005289cfcf483464   \n",
       "1021              NaN  0x7bd7de26ebd064465bb9c272513bb3bcbddb1e93   \n",
       "1029              NaN  0x1208a26faa0f4ac65b42098419eb4daa5e580ac6   \n",
       "1032              NaN  0x799b774204a348e1182fe01074c51444ba70a149   \n",
       "1033              NaN  0x08a3c2a819e3de7aca384c798269b3ce1cd0e437   \n",
       "1047              NaN  0x18aa467e40e1defb1956708830a343c1d01d3d7c   \n",
       "1050              NaN  0x9d100f017095e53b24d81296bca1d26742f1800f   \n",
       "1062              NaN  0xfe97e32a873aa2f926fbfc560abeef01f753c128   \n",
       "1069              NaN  0x2af4125c8fe208a349ef78d3cb980308ab1ed34f   \n",
       "1078              NaN  0x57ea12a3a8e441f5fe7b1f3af1121097b7d3b6a8   \n",
       "1090              NaN  0x99b36fdbc582d113af36a21eba06bfeab7b9be12   \n",
       "1101              NaN  0x3a5bd1e37b099ae3386d13947b6a90d97675e5e3   \n",
       "1124              NaN  0x1208a26faa0f4ac65b42098419eb4daa5e580ac6   \n",
       "1126              NaN  0xe126b3e5d052f1f575828f61feba4f4f2603652a   \n",
       "\n",
       "                                          project_title  \\\n",
       "819                                           DefiLlama   \n",
       "821         Revoke.cash - Helping you stay safe in web3   \n",
       "985                                     Ethereum on ARM   \n",
       "986                                           Chainlist   \n",
       "996             NiceNode: Run a node — just press start   \n",
       "1006                                     DefiLlama APIs   \n",
       "1011                                           Lenstube   \n",
       "1021                                      White Hat DAO   \n",
       "1029                        Optinames | ENS on Optimism   \n",
       "1032                                         0xDeadList   \n",
       "1033                                          DefiLlama   \n",
       "1047                                           JediSwap   \n",
       "1050                                          StarkDeFi   \n",
       "1062                                        Soul Wallet   \n",
       "1069                                  Proof of Humanity   \n",
       "1078                                              Umbra   \n",
       "1090  Tally Ho! - Open Source and Community Owned Wa...   \n",
       "1101                                            Lenster   \n",
       "1124  MintBot | Polygon NFT Minter + ENS SubDomains ...   \n",
       "1126        Revoke.cash - Helping you stay safe in web3   \n",
       "\n",
       "                                        project_website  \\\n",
       "819                              https://defillama.com/   \n",
       "821                                 https://revoke.cash   \n",
       "985   https://ethereum-on-arm-documentation.readthed...   \n",
       "986                              https://chainlist.org/   \n",
       "996                                https://nicenode.xyz   \n",
       "1006                              https://defillama.com   \n",
       "1011                               https://lenstube.xyz   \n",
       "1021                            https://whitehatdao.com   \n",
       "1029                         https://optinames.eth.limo   \n",
       "1032                              https://0xdeadlist.io   \n",
       "1033                             https://defillama.com/   \n",
       "1047                               https://jediswap.xyz   \n",
       "1050                          https://www.starkdefi.com   \n",
       "1062                             https://soulwallets.me   \n",
       "1069                   https://proofofhumanity.eth.limo   \n",
       "1078                             https://app.umbra.cash   \n",
       "1090                                https://tallyho.org   \n",
       "1101                                https://lenster.xyz   \n",
       "1124                                 https://mintbot.io   \n",
       "1126                                https://revoke.cash   \n",
       "\n",
       "                                     project_decription   project_created_at  \\\n",
       "819   Open and transparent DeFi TVL and analytics. F...  2022-11-18 19:46:02   \n",
       "821   Hey all, we're building free and open source t...  2022-12-01 22:26:19   \n",
       "985   Help us to build a <$400 PnP Ethereum full/arc...  2023-01-11 13:26:23   \n",
       "986   We track all RPCs available for all chains, mo...  2023-01-15 23:49:35   \n",
       "996   \\nThe current options to run a node require te...  2023-01-10 20:25:23   \n",
       "1006  DefiLlama provides multiple APIs for free that...  2023-01-14 22:00:59   \n",
       "1011  Decentralized video-sharing social media platf...  2023-01-12 06:50:23   \n",
       "1021  Safety and security should be at the heart of ...  2023-01-08 21:15:59   \n",
       "1029  What are Optinames?\\n\\nOptinames are tradable ...  2023-01-15 10:04:47   \n",
       "1032  Inspiration\\nWhen we say that an Ethereum acco...  2023-01-08 07:38:23   \n",
       "1033        Open and transparent DeFi TVL and analytics  2023-01-14 21:38:23   \n",
       "1047  Note: Donations for this grant are for develop...  2023-01-17 07:47:47   \n",
       "1050  StarkDeFi is a suite of decentralized financia...  2023-01-09 20:47:11   \n",
       "1062             Next-gen Ethereum wallet for everyone.  2023-01-13 21:10:35   \n",
       "1069  Sybil-resistant registry of Humans using socia...  2023-01-16 18:01:47   \n",
       "1078  Umbra is a protocol that lets you get paid pri...  2023-01-12 18:59:11   \n",
       "1090  Help fund the development of the first open so...  2023-01-13 19:20:59   \n",
       "1101  Lenster is a decentralized and permissionless ...  2023-01-07 07:15:23   \n",
       "1124  Mintbot started out as a service that allows E...  2023-01-10 12:47:47   \n",
       "1126  Hey all, we're building free and open source t...  2023-01-17 05:07:47   \n",
       "\n",
       "     project_round                                    project_long_id  ...  \\\n",
       "819         FANTOM  0x30b826002362b50fbcc7ee9ccd0515e4ab91c14141d3...  ...   \n",
       "821         FANTOM  0x37ad3db0b0bc56cea1909e6a6f21fd35453ef27f1d9a...  ...   \n",
       "985       ETHEREUM  0x429927c3a14cbe156749adb31371f385749150ac3604...  ...   \n",
       "986       ETHEREUM  0x46de99c3a4e0542fde6d77bfa1ff6d19e107f253ea52...  ...   \n",
       "996       ETHEREUM  0x99b81016d61f8b9115282b1055649d4876f386197590...  ...   \n",
       "1006      ETHEREUM  0xfce9d62f9a833d6f7185f0051701d5a9e64c83d1daca...  ...   \n",
       "1011           OSS  0x0f1d31d427400106f3d2958225dd235ae60b6a7572fb...  ...   \n",
       "1021           OSS  0x20632d089357836c07c38ae6a8b50449fa86c9eef6fd...  ...   \n",
       "1029           OSS  0x3e4b3f7089aa5cb6614b67e235624d01364febe41841...  ...   \n",
       "1032           OSS  0x43b94c544e8ac90c535752b8624e730820a5a752b361...  ...   \n",
       "1033           OSS  0x46ddc886ac23d5bc2cbc96cd2aa990627bcd98c881a9...  ...   \n",
       "1047           OSS  0x60c037f9dfa5daee0f07bc26fb73393ef924e36c73c4...  ...   \n",
       "1050           OSS  0x67583b52562147ffe4d7b9c4422c6109d0d18a596c25...  ...   \n",
       "1062           OSS  0x8029c7cda58d70a6cd81ac56a6a678e8ccfb560f153e...  ...   \n",
       "1069           OSS  0x91db8779fa1b15d75761e358fe57683892c68d5cad11...  ...   \n",
       "1078           OSS  0x9fb5b0d0698dc64cbd3a01c5205ebc5ef609e7d20c21...  ...   \n",
       "1090           OSS  0xafb022ea11846bceb90516c35155defd6404e4948697...  ...   \n",
       "1101           OSS  0xbe519f8c8f7ff2acb359dd757c5d2bf25b05d9fd29b8...  ...   \n",
       "1124           OSS  0xe797fdf65ab6db40d29cb7144e8715799a91c9a2f8a7...  ...   \n",
       "1126           OSS  0xf05829c76e3da92a8942378240ab4dc70c8c509f558e...  ...   \n",
       "\n",
       "                                 project_funding_source  \\\n",
       "819   Previously received funding from Gitcoin Grant...   \n",
       "821                                      Gitcoin Grants   \n",
       "985                    Gitcoin Grants, EF and QF rounds   \n",
       "986                            Donations + self-funding   \n",
       "996                    Gitcoin, CityDAO, EF ESP program   \n",
       "1006                           Donations + self-funding   \n",
       "1011                                                Nil   \n",
       "1021  Grants + raising funds through smart contract ...   \n",
       "1029                                     Gitcoin Grants   \n",
       "1032                                               None   \n",
       "1033                           Donations + self-funding   \n",
       "1047  Gitcoin grant mainly. No external funding. Mes...   \n",
       "1050                                               GR15   \n",
       "1062                         Ethereum community and VCs   \n",
       "1069                                        Non profits   \n",
       "1078                                             Grants   \n",
       "1090        Thesis is funding the development currently   \n",
       "1101                          Ethereum, Polygon, zkSync   \n",
       "1124                                     Gitcoin Grants   \n",
       "1126                                     Gitcoin Grants   \n",
       "\n",
       "                      project_team_size  \\\n",
       "819                                  13   \n",
       "821                                   1   \n",
       "985                                   2   \n",
       "986                                   2   \n",
       "996                                   3   \n",
       "1006    11 full time people + 2 interns   \n",
       "1011                                  1   \n",
       "1021                                 19   \n",
       "1029                                  2   \n",
       "1032                                  5   \n",
       "1033    11 full time people + 2 interns   \n",
       "1047  300+ contributors (dev + non dev)   \n",
       "1050                                  4   \n",
       "1062                                 10   \n",
       "1069                                 10   \n",
       "1078                                  6   \n",
       "1090                                 15   \n",
       "1101                                  1   \n",
       "1124                                  2   \n",
       "1126                                  1   \n",
       "\n",
       "                                   live_on_other_chains  \\\n",
       "819   Yes, DefiLlama tracks almost all chains and Ll...   \n",
       "821   Yes, Revoke.cash supports 30+ chains, and the ...   \n",
       "985                                                 NaN   \n",
       "986                                                 NaN   \n",
       "996                                                 NaN   \n",
       "1006                                                NaN   \n",
       "1011                                                NaN   \n",
       "1021                                                NaN   \n",
       "1029                                                NaN   \n",
       "1032                                                NaN   \n",
       "1033                                                NaN   \n",
       "1047                                                NaN   \n",
       "1050                                                NaN   \n",
       "1062                                                NaN   \n",
       "1069                                                NaN   \n",
       "1078                                                NaN   \n",
       "1090                                                NaN   \n",
       "1101                                                NaN   \n",
       "1124                                                NaN   \n",
       "1126                                                NaN   \n",
       "\n",
       "                                          project_value  \\\n",
       "819   We track DeFi metrics for fantom projects, suc...   \n",
       "821   As a DeFi ecosystem grows more funds will be a...   \n",
       "985                                                 NaN   \n",
       "986                                                 NaN   \n",
       "996                                                 NaN   \n",
       "1006                                                NaN   \n",
       "1011                                                NaN   \n",
       "1021                                                NaN   \n",
       "1029                                                NaN   \n",
       "1032                                                NaN   \n",
       "1033                                                NaN   \n",
       "1047                                                NaN   \n",
       "1050                                                NaN   \n",
       "1062                                                NaN   \n",
       "1069                                                NaN   \n",
       "1078                                                NaN   \n",
       "1090                                                NaN   \n",
       "1101                                                NaN   \n",
       "1124                                                NaN   \n",
       "1126                                                NaN   \n",
       "\n",
       "     project_improvements_to_existing  \\\n",
       "819                               NaN   \n",
       "821                               NaN   \n",
       "985                               NaN   \n",
       "986                               NaN   \n",
       "996                               NaN   \n",
       "1006                              NaN   \n",
       "1011                              NaN   \n",
       "1021                              NaN   \n",
       "1029                              NaN   \n",
       "1032                              NaN   \n",
       "1033                              NaN   \n",
       "1047                              NaN   \n",
       "1050                              NaN   \n",
       "1062                              NaN   \n",
       "1069                              NaN   \n",
       "1078                              NaN   \n",
       "1090                              NaN   \n",
       "1101                              NaN   \n",
       "1124                              NaN   \n",
       "1126                              NaN   \n",
       "\n",
       "                      project_github_twitter_credential  \\\n",
       "819                                                 NaN   \n",
       "821                                                 NaN   \n",
       "985                                                 Yes   \n",
       "986                                                 Yes   \n",
       "996   yes for Twitter, working on Github (was an error)   \n",
       "1006                                                Yes   \n",
       "1011                                                Yes   \n",
       "1021                                                Yes   \n",
       "1029                                                Yes   \n",
       "1032                                                Yes   \n",
       "1033                                                Yes   \n",
       "1047                                                Yes   \n",
       "1050                                                YES   \n",
       "1062                                                yes   \n",
       "1069                                         Didnt work   \n",
       "1078                                                Yes   \n",
       "1090                                                Yes   \n",
       "1101                                                yes   \n",
       "1124                                                Yes   \n",
       "1126                                                Yes   \n",
       "\n",
       "                                project_github_org_link  \\\n",
       "819                                                 NaN   \n",
       "821                                                 NaN   \n",
       "985                                                 NaN   \n",
       "986                                                 NaN   \n",
       "996                                                 NaN   \n",
       "1006                                                NaN   \n",
       "1011  User Account - sasicodes, Organization Account...   \n",
       "1021                     https://github.com/WhiteHatDAO   \n",
       "1029                     https://github.com/stevegachau   \n",
       "1032                      https://github.com/colinlyguo   \n",
       "1033  org account: https://github.com/DefiLlama, my ...   \n",
       "1047  https://github.com/jediswapintern, https://git...   \n",
       "1050   https://github.com/Starkdefi/StarkDefi-contracts   \n",
       "1062  https://github.com/proofofsoulprotocol/soul-wa...   \n",
       "1069                         Democracy Earth Foundation   \n",
       "1078  https://github.com/apbendi, https://github.com...   \n",
       "1090                   https://github.com/tallyhowallet   \n",
       "1101  https://github.com/bigint, https://github.com/...   \n",
       "1124                     https://github.com/stevegachau   \n",
       "1126  https://github.com/rkalis, https://github.com/...   \n",
       "\n",
       "     project_amount_received project_contributor_count  \\\n",
       "819             15454.296579                   10064.0   \n",
       "821              7404.270070                    7842.0   \n",
       "985               751.312258                     411.0   \n",
       "986             15454.296579                   10064.0   \n",
       "996               627.757908                     433.0   \n",
       "1006            15454.296579                   10064.0   \n",
       "1011             3560.551441                    3035.0   \n",
       "1021              164.848446                     157.0   \n",
       "1029             1918.848550                    1628.0   \n",
       "1032              116.124192                     106.0   \n",
       "1033            15454.296579                   10064.0   \n",
       "1047             5370.176026                    4163.0   \n",
       "1050             4493.664469                    3636.0   \n",
       "1062              629.748810                     708.0   \n",
       "1069             1723.308271                    1737.0   \n",
       "1078             1503.918455                    1228.0   \n",
       "1090             6610.313733                    3658.0   \n",
       "1101             8058.569967                    5075.0   \n",
       "1124             1918.848550                    1628.0   \n",
       "1126             7404.270070                    7842.0   \n",
       "\n",
       "     project_contribution_count  \n",
       "819                     11904.0  \n",
       "821                      8636.0  \n",
       "985                       420.0  \n",
       "986                     11904.0  \n",
       "996                       436.0  \n",
       "1006                    11904.0  \n",
       "1011                     3121.0  \n",
       "1021                      160.0  \n",
       "1029                     1664.0  \n",
       "1032                      109.0  \n",
       "1033                    11904.0  \n",
       "1047                     4270.0  \n",
       "1050                     3729.0  \n",
       "1062                      717.0  \n",
       "1069                     1775.0  \n",
       "1078                     1259.0  \n",
       "1090                     3749.0  \n",
       "1101                     5222.0  \n",
       "1124                     1664.0  \n",
       "1126                     8636.0  \n",
       "\n",
       "[20 rows x 28 columns]"
      ]
     },
     "execution_count": 178,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "suspicious_applications"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Some projects appears several times because they may have contributed to several grants. and are recorded with the same project_address, yet they where registered with different project_id."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 179,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['FANTOM', 'ETHEREUM', 'OSS'], dtype=object)"
      ]
     },
     "execution_count": 179,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "suspicious_applications.project_round.unique()"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "I think there is a bug somwhere because the project_address should be from the climate round."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "vexplorer",
   "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,
  "vscode": {
   "interpreter": {
    "hash": "e792627dd21444965ca9182d5837ded3009247ff5b5e7771c662170caaff759a"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}