stats_sxsw.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "d846f6b3",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ce71f5df",
   "metadata": {},
   "source": [
    "# VERI"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "9e498599",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_cleaned = pd.read_csv('cleaned_veri_data.csv')\n",
    "df_cleaned['FirstActivityTime'] = pd.to_datetime(df_cleaned['FirstActivityTime'])\n",
    "df_cleaned['LastActivityTime'] = pd.to_datetime(df_cleaned['LastActivityTime'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "20023397",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_t  = df_cleaned[(df_cleaned['FirstActivityTime'] >= '2022-03-11') & (df_cleaned['FirstActivityTime'] <= '2022-03-14')]\n",
    "df_t = df_t.drop(columns=['Unnamed: 0'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "ded76577",
   "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>Balance</th>\n",
       "      <th>NumTransactions</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>10.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>4.027797e+06</td>\n",
       "      <td>13.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>8.290829e+06</td>\n",
       "      <td>19.107881</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>6.678000e+03</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>4.826682e+05</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>9.990345e+05</td>\n",
       "      <td>3.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>1.986790e+06</td>\n",
       "      <td>11.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2.708965e+07</td>\n",
       "      <td>60.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Balance  NumTransactions\n",
       "count  1.000000e+01        10.000000\n",
       "mean   4.027797e+06        13.000000\n",
       "std    8.290829e+06        19.107881\n",
       "min    6.678000e+03         2.000000\n",
       "25%    4.826682e+05         2.000000\n",
       "50%    9.990345e+05         3.500000\n",
       "75%    1.986790e+06        11.000000\n",
       "max    2.708965e+07        60.000000"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_t[(df_t['Balance'] >= 0) & (df_t['NumTransactions']>1) & (df_t['Address']!='tz1c31KQdndxSMon9umQu3XQpLdzqTJ8FZ68') &\n",
    "    (df_t['LastActivityTime'] > df_t['FirstActivityTime'])].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "b0d2d970",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Address</th>\n",
       "      <th>Revealed</th>\n",
       "      <th>Balance</th>\n",
       "      <th>NumTransactions</th>\n",
       "      <th>FirstActivityTime</th>\n",
       "      <th>LastActivityTime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>694</th>\n",
       "      <td>tz2QnTXyY7L5wT6bYaGuq6YhKPUpmF1Drt9F</td>\n",
       "      <td>True</td>\n",
       "      <td>6059007</td>\n",
       "      <td>60</td>\n",
       "      <td>2022-03-12 16:23:14+00:00</td>\n",
       "      <td>2022-03-14 19:48:44+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>tz2HRKNQK4DCJB7xQXSxYho2y24MmVbaUcsF</td>\n",
       "      <td>True</td>\n",
       "      <td>27089648</td>\n",
       "      <td>33</td>\n",
       "      <td>2022-03-11 23:46:54+00:00</td>\n",
       "      <td>2022-03-12 19:35:54+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>tz28uqgy6aJRxhDyk1BvdrDYA1S8k8rYFyCP</td>\n",
       "      <td>True</td>\n",
       "      <td>1950012</td>\n",
       "      <td>11</td>\n",
       "      <td>2022-03-13 18:37:04+00:00</td>\n",
       "      <td>2022-04-06 06:59:29+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>628</th>\n",
       "      <td>tz2NqGFrG1P46LTTMKhwRSmRjLgQCaBx4oL5</td>\n",
       "      <td>True</td>\n",
       "      <td>477168</td>\n",
       "      <td>11</td>\n",
       "      <td>2022-03-13 18:15:24+00:00</td>\n",
       "      <td>2022-03-16 16:38:24+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>469</th>\n",
       "      <td>tz2JVVYwLkXBSX4PshBAmQ6CeB6kZA3kbAD5</td>\n",
       "      <td>True</td>\n",
       "      <td>6678</td>\n",
       "      <td>5</td>\n",
       "      <td>2022-03-13 16:04:44+00:00</td>\n",
       "      <td>2022-04-04 03:47:29+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286</th>\n",
       "      <td>tz2EM1h1K5B5GSbry9uk9SXFhrfApRZTDjDp</td>\n",
       "      <td>True</td>\n",
       "      <td>998907</td>\n",
       "      <td>2</td>\n",
       "      <td>2022-03-12 18:19:54+00:00</td>\n",
       "      <td>2022-03-14 11:11:34+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>527</th>\n",
       "      <td>tz2L7Nobc6UmXC3dFHaLotJZmd6BJf8fpp6Q</td>\n",
       "      <td>True</td>\n",
       "      <td>499169</td>\n",
       "      <td>2</td>\n",
       "      <td>2022-03-11 18:17:24+00:00</td>\n",
       "      <td>2022-03-13 23:14:34+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>563</th>\n",
       "      <td>tz2M2AJRsx8GgNocCoe9WcEgVf2nz7SYWmzU</td>\n",
       "      <td>True</td>\n",
       "      <td>199169</td>\n",
       "      <td>2</td>\n",
       "      <td>2022-03-12 16:55:54+00:00</td>\n",
       "      <td>2022-03-13 20:45:24+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>626</th>\n",
       "      <td>tz2NQaM2JuqSVyARkFJwzoLWw4wonw1Be1Fc</td>\n",
       "      <td>True</td>\n",
       "      <td>999162</td>\n",
       "      <td>2</td>\n",
       "      <td>2022-03-13 15:53:34+00:00</td>\n",
       "      <td>2022-03-13 16:10:44+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>899</th>\n",
       "      <td>tz2VehR3Q3UzuHHyveRUgUqajKxp4sWPYzgB</td>\n",
       "      <td>True</td>\n",
       "      <td>1999049</td>\n",
       "      <td>2</td>\n",
       "      <td>2022-03-12 16:55:24+00:00</td>\n",
       "      <td>2022-04-08 09:22:44+00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  Address  Revealed   Balance  \\\n",
       "694  tz2QnTXyY7L5wT6bYaGuq6YhKPUpmF1Drt9F      True   6059007   \n",
       "414  tz2HRKNQK4DCJB7xQXSxYho2y24MmVbaUcsF      True  27089648   \n",
       "32   tz28uqgy6aJRxhDyk1BvdrDYA1S8k8rYFyCP      True   1950012   \n",
       "628  tz2NqGFrG1P46LTTMKhwRSmRjLgQCaBx4oL5      True    477168   \n",
       "469  tz2JVVYwLkXBSX4PshBAmQ6CeB6kZA3kbAD5      True      6678   \n",
       "286  tz2EM1h1K5B5GSbry9uk9SXFhrfApRZTDjDp      True    998907   \n",
       "527  tz2L7Nobc6UmXC3dFHaLotJZmd6BJf8fpp6Q      True    499169   \n",
       "563  tz2M2AJRsx8GgNocCoe9WcEgVf2nz7SYWmzU      True    199169   \n",
       "626  tz2NQaM2JuqSVyARkFJwzoLWw4wonw1Be1Fc      True    999162   \n",
       "899  tz2VehR3Q3UzuHHyveRUgUqajKxp4sWPYzgB      True   1999049   \n",
       "\n",
       "     NumTransactions         FirstActivityTime          LastActivityTime  \n",
       "694               60 2022-03-12 16:23:14+00:00 2022-03-14 19:48:44+00:00  \n",
       "414               33 2022-03-11 23:46:54+00:00 2022-03-12 19:35:54+00:00  \n",
       "32                11 2022-03-13 18:37:04+00:00 2022-04-06 06:59:29+00:00  \n",
       "628               11 2022-03-13 18:15:24+00:00 2022-03-16 16:38:24+00:00  \n",
       "469                5 2022-03-13 16:04:44+00:00 2022-04-04 03:47:29+00:00  \n",
       "286                2 2022-03-12 18:19:54+00:00 2022-03-14 11:11:34+00:00  \n",
       "527                2 2022-03-11 18:17:24+00:00 2022-03-13 23:14:34+00:00  \n",
       "563                2 2022-03-12 16:55:54+00:00 2022-03-13 20:45:24+00:00  \n",
       "626                2 2022-03-13 15:53:34+00:00 2022-03-13 16:10:44+00:00  \n",
       "899                2 2022-03-12 16:55:24+00:00 2022-04-08 09:22:44+00:00  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_t[(df_t['Balance'] > 0) & (df_t['NumTransactions']>1) & \n",
    "     (df_t['Address']!='tz1c31KQdndxSMon9umQu3XQpLdzqTJ8FZ68')].sort_values(['NumTransactions'], ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "56b677b6",
   "metadata": {},
   "source": [
    "# FLEX"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "a20f1407",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_flex = pd.read_csv('cleaned_flex_data.csv')\n",
    "df_flex['FirstActivityTime'] = pd.to_datetime(df_flex['FirstActivityTime'])\n",
    "df_flex['LastActivityTime'] = pd.to_datetime(df_flex['LastActivityTime'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "db1e6d41",
   "metadata": {},
   "outputs": [],
   "source": [
    "flex_sxsw = df_flex[(df_flex['FirstActivityTime'] >='2022-03-11') & (df_flex['FirstActivityTime'] <= '2022-03-14')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "28c8fb68",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Address</th>\n",
       "      <th>Revealed</th>\n",
       "      <th>Balance</th>\n",
       "      <th>NumTransactions</th>\n",
       "      <th>FirstActivityTime</th>\n",
       "      <th>LastActivityTime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3353</th>\n",
       "      <td>3353</td>\n",
       "      <td>tz2LPtPFL8SkMZApM7gMUGAfSXqR9kVvwEzh</td>\n",
       "      <td>True</td>\n",
       "      <td>12118153</td>\n",
       "      <td>84</td>\n",
       "      <td>2022-03-12 17:19:24+00:00</td>\n",
       "      <td>2022-03-14 21:59:54+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>233</td>\n",
       "      <td>tz1c31KQdndxSMon9umQu3XQpLdzqTJ8FZ68</td>\n",
       "      <td>True</td>\n",
       "      <td>337494575</td>\n",
       "      <td>81</td>\n",
       "      <td>2022-03-13 21:29:24+00:00</td>\n",
       "      <td>2022-03-21 06:02:14+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3595</th>\n",
       "      <td>3595</td>\n",
       "      <td>tz2QnTXyY7L5wT6bYaGuq6YhKPUpmF1Drt9F</td>\n",
       "      <td>True</td>\n",
       "      <td>6059007</td>\n",
       "      <td>60</td>\n",
       "      <td>2022-03-12 16:23:14+00:00</td>\n",
       "      <td>2022-03-14 19:48:44+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3137</th>\n",
       "      <td>3137</td>\n",
       "      <td>tz2HRKNQK4DCJB7xQXSxYho2y24MmVbaUcsF</td>\n",
       "      <td>True</td>\n",
       "      <td>27089648</td>\n",
       "      <td>33</td>\n",
       "      <td>2022-03-11 23:46:54+00:00</td>\n",
       "      <td>2022-03-12 19:35:54+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>200</td>\n",
       "      <td>tz1bugtz2GbjHvQSKxhRkSEmpVxSjgkJKZjV</td>\n",
       "      <td>True</td>\n",
       "      <td>90635</td>\n",
       "      <td>17</td>\n",
       "      <td>2022-03-12 14:15:34+00:00</td>\n",
       "      <td>2022-03-18 10:07:04+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2280</th>\n",
       "      <td>2280</td>\n",
       "      <td>tz1XJt6JAkpVZsHoc3XtQqF2eT27R2Qn4FR4</td>\n",
       "      <td>True</td>\n",
       "      <td>55032161</td>\n",
       "      <td>17</td>\n",
       "      <td>2022-03-13 20:56:24+00:00</td>\n",
       "      <td>2022-03-21 12:15:14+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1084</th>\n",
       "      <td>1084</td>\n",
       "      <td>tz1LiXgJqw6DRXQEDQ49Yu6M4zfLGUn2TDeE</td>\n",
       "      <td>True</td>\n",
       "      <td>184208</td>\n",
       "      <td>13</td>\n",
       "      <td>2022-03-11 11:39:24+00:00</td>\n",
       "      <td>2022-03-12 09:59:34+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1468</th>\n",
       "      <td>1468</td>\n",
       "      <td>tz1Q5eSCpY35j9PUR8zK6YbFqJJVLSaeo4cB</td>\n",
       "      <td>True</td>\n",
       "      <td>41942</td>\n",
       "      <td>12</td>\n",
       "      <td>2022-03-12 17:20:54+00:00</td>\n",
       "      <td>2022-03-28 01:00:34+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>966</th>\n",
       "      <td>966</td>\n",
       "      <td>tz1ip9V9E5cZpB4yXeASDozQf9juWqAvihsq</td>\n",
       "      <td>True</td>\n",
       "      <td>108174</td>\n",
       "      <td>5</td>\n",
       "      <td>2022-03-12 17:20:54+00:00</td>\n",
       "      <td>2022-03-28 01:16:14+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2268</th>\n",
       "      <td>2268</td>\n",
       "      <td>tz1XHxEYUFJpkWfuzZYm9voofv88uQoHTuLB</td>\n",
       "      <td>True</td>\n",
       "      <td>64485</td>\n",
       "      <td>3</td>\n",
       "      <td>2022-03-12 17:19:54+00:00</td>\n",
       "      <td>2022-04-08 11:35:44+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2317</th>\n",
       "      <td>2317</td>\n",
       "      <td>tz1XTLDwp468tBrdnBXNcczrFyoPBgjGziEa</td>\n",
       "      <td>True</td>\n",
       "      <td>79980</td>\n",
       "      <td>3</td>\n",
       "      <td>2022-03-12 17:19:54+00:00</td>\n",
       "      <td>2022-04-08 11:31:44+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2945</th>\n",
       "      <td>2945</td>\n",
       "      <td>tz2EM1h1K5B5GSbry9uk9SXFhrfApRZTDjDp</td>\n",
       "      <td>True</td>\n",
       "      <td>998907</td>\n",
       "      <td>2</td>\n",
       "      <td>2022-03-12 18:19:54+00:00</td>\n",
       "      <td>2022-03-14 11:11:34+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3607</th>\n",
       "      <td>3607</td>\n",
       "      <td>tz2QR48dzhunQDwWaR2fptroWyCx5UcJq23P</td>\n",
       "      <td>True</td>\n",
       "      <td>369274</td>\n",
       "      <td>2</td>\n",
       "      <td>2022-03-11 03:19:44+00:00</td>\n",
       "      <td>2022-03-11 03:28:14+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3925</th>\n",
       "      <td>3925</td>\n",
       "      <td>tz2VehR3Q3UzuHHyveRUgUqajKxp4sWPYzgB</td>\n",
       "      <td>True</td>\n",
       "      <td>1999049</td>\n",
       "      <td>2</td>\n",
       "      <td>2022-03-12 16:55:24+00:00</td>\n",
       "      <td>2022-04-08 09:22:44+00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0                               Address  Revealed    Balance  \\\n",
       "3353        3353  tz2LPtPFL8SkMZApM7gMUGAfSXqR9kVvwEzh      True   12118153   \n",
       "233          233  tz1c31KQdndxSMon9umQu3XQpLdzqTJ8FZ68      True  337494575   \n",
       "3595        3595  tz2QnTXyY7L5wT6bYaGuq6YhKPUpmF1Drt9F      True    6059007   \n",
       "3137        3137  tz2HRKNQK4DCJB7xQXSxYho2y24MmVbaUcsF      True   27089648   \n",
       "200          200  tz1bugtz2GbjHvQSKxhRkSEmpVxSjgkJKZjV      True      90635   \n",
       "2280        2280  tz1XJt6JAkpVZsHoc3XtQqF2eT27R2Qn4FR4      True   55032161   \n",
       "1084        1084  tz1LiXgJqw6DRXQEDQ49Yu6M4zfLGUn2TDeE      True     184208   \n",
       "1468        1468  tz1Q5eSCpY35j9PUR8zK6YbFqJJVLSaeo4cB      True      41942   \n",
       "966          966  tz1ip9V9E5cZpB4yXeASDozQf9juWqAvihsq      True     108174   \n",
       "2268        2268  tz1XHxEYUFJpkWfuzZYm9voofv88uQoHTuLB      True      64485   \n",
       "2317        2317  tz1XTLDwp468tBrdnBXNcczrFyoPBgjGziEa      True      79980   \n",
       "2945        2945  tz2EM1h1K5B5GSbry9uk9SXFhrfApRZTDjDp      True     998907   \n",
       "3607        3607  tz2QR48dzhunQDwWaR2fptroWyCx5UcJq23P      True     369274   \n",
       "3925        3925  tz2VehR3Q3UzuHHyveRUgUqajKxp4sWPYzgB      True    1999049   \n",
       "\n",
       "      NumTransactions         FirstActivityTime          LastActivityTime  \n",
       "3353               84 2022-03-12 17:19:24+00:00 2022-03-14 21:59:54+00:00  \n",
       "233                81 2022-03-13 21:29:24+00:00 2022-03-21 06:02:14+00:00  \n",
       "3595               60 2022-03-12 16:23:14+00:00 2022-03-14 19:48:44+00:00  \n",
       "3137               33 2022-03-11 23:46:54+00:00 2022-03-12 19:35:54+00:00  \n",
       "200                17 2022-03-12 14:15:34+00:00 2022-03-18 10:07:04+00:00  \n",
       "2280               17 2022-03-13 20:56:24+00:00 2022-03-21 12:15:14+00:00  \n",
       "1084               13 2022-03-11 11:39:24+00:00 2022-03-12 09:59:34+00:00  \n",
       "1468               12 2022-03-12 17:20:54+00:00 2022-03-28 01:00:34+00:00  \n",
       "966                 5 2022-03-12 17:20:54+00:00 2022-03-28 01:16:14+00:00  \n",
       "2268                3 2022-03-12 17:19:54+00:00 2022-04-08 11:35:44+00:00  \n",
       "2317                3 2022-03-12 17:19:54+00:00 2022-04-08 11:31:44+00:00  \n",
       "2945                2 2022-03-12 18:19:54+00:00 2022-03-14 11:11:34+00:00  \n",
       "3607                2 2022-03-11 03:19:44+00:00 2022-03-11 03:28:14+00:00  \n",
       "3925                2 2022-03-12 16:55:24+00:00 2022-04-08 09:22:44+00:00  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flex_sxsw[(flex_sxsw['Balance']>0) & (flex_sxsw['NumTransactions']>1)].sort_values(['NumTransactions'], ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "5fc24b7a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Balance</th>\n",
       "      <th>NumTransactions</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>14.000000</td>\n",
       "      <td>1.400000e+01</td>\n",
       "      <td>14.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2241.285714</td>\n",
       "      <td>3.155216e+07</td>\n",
       "      <td>23.857143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>1266.056168</td>\n",
       "      <td>8.940667e+07</td>\n",
       "      <td>29.461467</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>200.000000</td>\n",
       "      <td>4.194200e+04</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>1180.000000</td>\n",
       "      <td>9.501975e+04</td>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2298.500000</td>\n",
       "      <td>6.840905e+05</td>\n",
       "      <td>12.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>3299.000000</td>\n",
       "      <td>1.060337e+07</td>\n",
       "      <td>29.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>3925.000000</td>\n",
       "      <td>3.374946e+08</td>\n",
       "      <td>84.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Unnamed: 0       Balance  NumTransactions\n",
       "count    14.000000  1.400000e+01        14.000000\n",
       "mean   2241.285714  3.155216e+07        23.857143\n",
       "std    1266.056168  8.940667e+07        29.461467\n",
       "min     200.000000  4.194200e+04         2.000000\n",
       "25%    1180.000000  9.501975e+04         3.000000\n",
       "50%    2298.500000  6.840905e+05        12.500000\n",
       "75%    3299.000000  1.060337e+07        29.000000\n",
       "max    3925.000000  3.374946e+08        84.000000"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flex_sxsw[(flex_sxsw['Balance']>0) & (flex_sxsw['NumTransactions']>1)].describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2cb5098f",
   "metadata": {},
   "source": [
    "# Avatar"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "00718a14",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_avatar = pd.read_csv('cleaned_avatar_data.csv')\n",
    "df_avatar['FirstActivityTime'] = pd.to_datetime(df_avatar['FirstActivityTime'])\n",
    "df_avatar['LastActivityTime'] = pd.to_datetime(df_avatar['LastActivityTime'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "83cd9587",
   "metadata": {},
   "outputs": [],
   "source": [
    "avatar_sxsw = df_avatar[(df_avatar['FirstActivityTime'] >= '2022-03-11') & (df_avatar['FirstActivityTime'] <= '2022-03-14')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "675594b9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(378, 7)"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "avatar_sxsw.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "d8ac22b6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Address</th>\n",
       "      <th>Revealed</th>\n",
       "      <th>Balance</th>\n",
       "      <th>NumTransactions</th>\n",
       "      <th>FirstActivityTime</th>\n",
       "      <th>LastActivityTime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>tz1c31KQdndxSMon9umQu3XQpLdzqTJ8FZ68</td>\n",
       "      <td>True</td>\n",
       "      <td>337494575</td>\n",
       "      <td>81</td>\n",
       "      <td>2022-03-13 21:29:24+00:00</td>\n",
       "      <td>2022-03-21 06:02:14+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>tz28uqgy6aJRxhDyk1BvdrDYA1S8k8rYFyCP</td>\n",
       "      <td>True</td>\n",
       "      <td>1950012</td>\n",
       "      <td>11</td>\n",
       "      <td>2022-03-13 18:37:04+00:00</td>\n",
       "      <td>2022-04-06 06:59:29+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>130</td>\n",
       "      <td>tz2EM1h1K5B5GSbry9uk9SXFhrfApRZTDjDp</td>\n",
       "      <td>True</td>\n",
       "      <td>998907</td>\n",
       "      <td>2</td>\n",
       "      <td>2022-03-12 18:19:54+00:00</td>\n",
       "      <td>2022-03-14 11:11:34+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>308</th>\n",
       "      <td>308</td>\n",
       "      <td>tz2NqGFrG1P46LTTMKhwRSmRjLgQCaBx4oL5</td>\n",
       "      <td>True</td>\n",
       "      <td>477168</td>\n",
       "      <td>11</td>\n",
       "      <td>2022-03-13 18:15:24+00:00</td>\n",
       "      <td>2022-03-16 16:38:24+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>350</th>\n",
       "      <td>350</td>\n",
       "      <td>tz2QnTXyY7L5wT6bYaGuq6YhKPUpmF1Drt9F</td>\n",
       "      <td>True</td>\n",
       "      <td>6059007</td>\n",
       "      <td>60</td>\n",
       "      <td>2022-03-12 16:23:14+00:00</td>\n",
       "      <td>2022-03-14 19:48:44+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>457</th>\n",
       "      <td>457</td>\n",
       "      <td>tz2VehR3Q3UzuHHyveRUgUqajKxp4sWPYzgB</td>\n",
       "      <td>True</td>\n",
       "      <td>1999049</td>\n",
       "      <td>2</td>\n",
       "      <td>2022-03-12 16:55:24+00:00</td>\n",
       "      <td>2022-04-08 09:22:44+00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0                               Address  Revealed    Balance  \\\n",
       "1             1  tz1c31KQdndxSMon9umQu3XQpLdzqTJ8FZ68      True  337494575   \n",
       "10           10  tz28uqgy6aJRxhDyk1BvdrDYA1S8k8rYFyCP      True    1950012   \n",
       "130         130  tz2EM1h1K5B5GSbry9uk9SXFhrfApRZTDjDp      True     998907   \n",
       "308         308  tz2NqGFrG1P46LTTMKhwRSmRjLgQCaBx4oL5      True     477168   \n",
       "350         350  tz2QnTXyY7L5wT6bYaGuq6YhKPUpmF1Drt9F      True    6059007   \n",
       "457         457  tz2VehR3Q3UzuHHyveRUgUqajKxp4sWPYzgB      True    1999049   \n",
       "\n",
       "     NumTransactions         FirstActivityTime          LastActivityTime  \n",
       "1                 81 2022-03-13 21:29:24+00:00 2022-03-21 06:02:14+00:00  \n",
       "10                11 2022-03-13 18:37:04+00:00 2022-04-06 06:59:29+00:00  \n",
       "130                2 2022-03-12 18:19:54+00:00 2022-03-14 11:11:34+00:00  \n",
       "308               11 2022-03-13 18:15:24+00:00 2022-03-16 16:38:24+00:00  \n",
       "350               60 2022-03-12 16:23:14+00:00 2022-03-14 19:48:44+00:00  \n",
       "457                2 2022-03-12 16:55:24+00:00 2022-04-08 09:22:44+00:00  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "avatar_sxsw[(avatar_sxsw['Balance'] > 0) & (avatar_sxsw['NumTransactions'] > 1)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "da3cffc9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Balance</th>\n",
       "      <th>NumTransactions</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>6.000000</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>6.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>209.333333</td>\n",
       "      <td>5.816312e+07</td>\n",
       "      <td>27.833333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>189.890144</td>\n",
       "      <td>1.368581e+08</td>\n",
       "      <td>33.949472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>4.771680e+05</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>40.000000</td>\n",
       "      <td>1.236683e+06</td>\n",
       "      <td>4.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>219.000000</td>\n",
       "      <td>1.974530e+06</td>\n",
       "      <td>11.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>339.500000</td>\n",
       "      <td>5.044018e+06</td>\n",
       "      <td>47.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>457.000000</td>\n",
       "      <td>3.374946e+08</td>\n",
       "      <td>81.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0       Balance  NumTransactions\n",
       "count    6.000000  6.000000e+00         6.000000\n",
       "mean   209.333333  5.816312e+07        27.833333\n",
       "std    189.890144  1.368581e+08        33.949472\n",
       "min      1.000000  4.771680e+05         2.000000\n",
       "25%     40.000000  1.236683e+06         4.250000\n",
       "50%    219.000000  1.974530e+06        11.000000\n",
       "75%    339.500000  5.044018e+06        47.750000\n",
       "max    457.000000  3.374946e+08        81.000000"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "avatar_sxsw[(avatar_sxsw['Balance'] > 0) & (avatar_sxsw['NumTransactions'] > 1)].describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8c6ec6e8",
   "metadata": {},
   "source": [
    "# Interpop "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "246fdd06",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_interpop = pd.read_csv('cleaned_interpop_data.csv')\n",
    "df_interpop['FirstActivityTime'] = pd.to_datetime(df_interpop['FirstActivityTime'])\n",
    "df_interpop['LastActivityTime'] = pd.to_datetime(df_interpop['LastActivityTime'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "54cd8b58",
   "metadata": {},
   "outputs": [],
   "source": [
    "interpop_sxsw = df_interpop[(df_interpop['FirstActivityTime'] >= '2022-03-11') & (df_interpop['FirstActivityTime'] <= '2022-03-14')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "5c410532",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Address</th>\n",
       "      <th>Revealed</th>\n",
       "      <th>Balance</th>\n",
       "      <th>NumTransactions</th>\n",
       "      <th>FirstActivityTime</th>\n",
       "      <th>LastActivityTime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>443</th>\n",
       "      <td>443</td>\n",
       "      <td>tz1c31KQdndxSMon9umQu3XQpLdzqTJ8FZ68</td>\n",
       "      <td>True</td>\n",
       "      <td>337494575</td>\n",
       "      <td>81</td>\n",
       "      <td>2022-03-13 21:29:24+00:00</td>\n",
       "      <td>2022-03-21 06:02:14+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17004</th>\n",
       "      <td>17004</td>\n",
       "      <td>tz2L7Nobc6UmXC3dFHaLotJZmd6BJf8fpp6Q</td>\n",
       "      <td>True</td>\n",
       "      <td>499169</td>\n",
       "      <td>2</td>\n",
       "      <td>2022-03-11 18:17:24+00:00</td>\n",
       "      <td>2022-03-13 23:14:34+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19646</th>\n",
       "      <td>19646</td>\n",
       "      <td>tz2NQaM2JuqSVyARkFJwzoLWw4wonw1Be1Fc</td>\n",
       "      <td>True</td>\n",
       "      <td>999162</td>\n",
       "      <td>2</td>\n",
       "      <td>2022-03-13 15:53:34+00:00</td>\n",
       "      <td>2022-03-13 16:10:44+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19654</th>\n",
       "      <td>19654</td>\n",
       "      <td>tz2NqGFrG1P46LTTMKhwRSmRjLgQCaBx4oL5</td>\n",
       "      <td>True</td>\n",
       "      <td>477168</td>\n",
       "      <td>11</td>\n",
       "      <td>2022-03-13 18:15:24+00:00</td>\n",
       "      <td>2022-03-16 16:38:24+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21626</th>\n",
       "      <td>21626</td>\n",
       "      <td>tz2QnTXyY7L5wT6bYaGuq6YhKPUpmF1Drt9F</td>\n",
       "      <td>True</td>\n",
       "      <td>6059007</td>\n",
       "      <td>60</td>\n",
       "      <td>2022-03-12 16:23:14+00:00</td>\n",
       "      <td>2022-03-14 19:48:44+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26337</th>\n",
       "      <td>26337</td>\n",
       "      <td>tz2VehR3Q3UzuHHyveRUgUqajKxp4sWPYzgB</td>\n",
       "      <td>True</td>\n",
       "      <td>1999049</td>\n",
       "      <td>2</td>\n",
       "      <td>2022-03-12 16:55:24+00:00</td>\n",
       "      <td>2022-04-08 09:22:44+00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0                               Address  Revealed    Balance  \\\n",
       "443           443  tz1c31KQdndxSMon9umQu3XQpLdzqTJ8FZ68      True  337494575   \n",
       "17004       17004  tz2L7Nobc6UmXC3dFHaLotJZmd6BJf8fpp6Q      True     499169   \n",
       "19646       19646  tz2NQaM2JuqSVyARkFJwzoLWw4wonw1Be1Fc      True     999162   \n",
       "19654       19654  tz2NqGFrG1P46LTTMKhwRSmRjLgQCaBx4oL5      True     477168   \n",
       "21626       21626  tz2QnTXyY7L5wT6bYaGuq6YhKPUpmF1Drt9F      True    6059007   \n",
       "26337       26337  tz2VehR3Q3UzuHHyveRUgUqajKxp4sWPYzgB      True    1999049   \n",
       "\n",
       "       NumTransactions         FirstActivityTime          LastActivityTime  \n",
       "443                 81 2022-03-13 21:29:24+00:00 2022-03-21 06:02:14+00:00  \n",
       "17004                2 2022-03-11 18:17:24+00:00 2022-03-13 23:14:34+00:00  \n",
       "19646                2 2022-03-13 15:53:34+00:00 2022-03-13 16:10:44+00:00  \n",
       "19654               11 2022-03-13 18:15:24+00:00 2022-03-16 16:38:24+00:00  \n",
       "21626               60 2022-03-12 16:23:14+00:00 2022-03-14 19:48:44+00:00  \n",
       "26337                2 2022-03-12 16:55:24+00:00 2022-04-08 09:22:44+00:00  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "interpop_sxsw[(interpop_sxsw['Balance'] > 0) & (interpop_sxsw['NumTransactions'] > 1)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "9d69dd30",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Balance</th>\n",
       "      <th>NumTransactions</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>6.000000</td>\n",
       "      <td>6.000000e+00</td>\n",
       "      <td>6.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>17451.666667</td>\n",
       "      <td>5.792136e+07</td>\n",
       "      <td>26.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>8894.208513</td>\n",
       "      <td>1.369784e+08</td>\n",
       "      <td>35.023801</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>443.000000</td>\n",
       "      <td>4.771680e+05</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>17664.500000</td>\n",
       "      <td>6.241672e+05</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>19650.000000</td>\n",
       "      <td>1.499106e+06</td>\n",
       "      <td>6.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>21133.000000</td>\n",
       "      <td>5.044018e+06</td>\n",
       "      <td>47.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>26337.000000</td>\n",
       "      <td>3.374946e+08</td>\n",
       "      <td>81.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Unnamed: 0       Balance  NumTransactions\n",
       "count      6.000000  6.000000e+00         6.000000\n",
       "mean   17451.666667  5.792136e+07        26.333333\n",
       "std     8894.208513  1.369784e+08        35.023801\n",
       "min      443.000000  4.771680e+05         2.000000\n",
       "25%    17664.500000  6.241672e+05         2.000000\n",
       "50%    19650.000000  1.499106e+06         6.500000\n",
       "75%    21133.000000  5.044018e+06        47.750000\n",
       "max    26337.000000  3.374946e+08        81.000000"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "interpop_sxsw[(interpop_sxsw['Balance'] > 0) & (interpop_sxsw['NumTransactions'] > 1)].describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5543ded1",
   "metadata": {},
   "source": [
    "# Pantone "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "88e88dc3",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_pantone = pd.read_csv('cleaned_pantone_data.csv')\n",
    "df_pantone['FirstActivityTime'] = pd.to_datetime(df_pantone['FirstActivityTime'])\n",
    "df_pantone['LastActivityTime'] = pd.to_datetime(df_pantone['LastActivityTime'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "d23fb482",
   "metadata": {},
   "outputs": [],
   "source": [
    "pantone_sxsw = df_pantone[(df_pantone['FirstActivityTime'] >= '2022-03-11') & (df_pantone['FirstActivityTime'] <= '2022-03-14')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "8847ea4f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Balance</th>\n",
       "      <th>NumTransactions</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>286.000000</td>\n",
       "      <td>2.860000e+02</td>\n",
       "      <td>286.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>5198.048951</td>\n",
       "      <td>1.352480e+06</td>\n",
       "      <td>7.006993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>3178.590268</td>\n",
       "      <td>2.001443e+07</td>\n",
       "      <td>13.407773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>21.000000</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2330.750000</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>5100.000000</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>8231.250000</td>\n",
       "      <td>1.903800e+04</td>\n",
       "      <td>8.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>10434.000000</td>\n",
       "      <td>3.374946e+08</td>\n",
       "      <td>178.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Unnamed: 0       Balance  NumTransactions\n",
       "count    286.000000  2.860000e+02       286.000000\n",
       "mean    5198.048951  1.352480e+06         7.006993\n",
       "std     3178.590268  2.001443e+07        13.407773\n",
       "min       21.000000  1.000000e+00         2.000000\n",
       "25%     2330.750000  1.000000e+00         3.000000\n",
       "50%     5100.000000  1.000000e+00         3.000000\n",
       "75%     8231.250000  1.903800e+04         8.750000\n",
       "max    10434.000000  3.374946e+08       178.000000"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pantone_sxsw[(pantone_sxsw['Balance'] > 0) & (pantone_sxsw['NumTransactions'] > 1)].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "4713eb56",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Address</th>\n",
       "      <th>Revealed</th>\n",
       "      <th>Balance</th>\n",
       "      <th>NumTransactions</th>\n",
       "      <th>FirstActivityTime</th>\n",
       "      <th>LastActivityTime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1606</th>\n",
       "      <td>1606</td>\n",
       "      <td>tz1gCRtyKVXggaz8ftjcq6XKieY74PMJ3nyF</td>\n",
       "      <td>True</td>\n",
       "      <td>3186</td>\n",
       "      <td>178</td>\n",
       "      <td>2022-03-12 07:24:24+00:00</td>\n",
       "      <td>2022-03-28 18:36:44+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>542</th>\n",
       "      <td>542</td>\n",
       "      <td>tz1c31KQdndxSMon9umQu3XQpLdzqTJ8FZ68</td>\n",
       "      <td>True</td>\n",
       "      <td>337494575</td>\n",
       "      <td>81</td>\n",
       "      <td>2022-03-13 21:29:24+00:00</td>\n",
       "      <td>2022-03-21 06:02:14+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9070</th>\n",
       "      <td>9070</td>\n",
       "      <td>tz2QnTXyY7L5wT6bYaGuq6YhKPUpmF1Drt9F</td>\n",
       "      <td>True</td>\n",
       "      <td>6059007</td>\n",
       "      <td>60</td>\n",
       "      <td>2022-03-12 16:23:14+00:00</td>\n",
       "      <td>2022-03-14 19:48:44+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4362</th>\n",
       "      <td>4362</td>\n",
       "      <td>tz1TXCaPWoDjRddDd64bAKMU7G2oVsfsoqHA</td>\n",
       "      <td>True</td>\n",
       "      <td>1</td>\n",
       "      <td>53</td>\n",
       "      <td>2022-03-12 17:44:24+00:00</td>\n",
       "      <td>2022-03-17 01:25:24+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6323</th>\n",
       "      <td>6323</td>\n",
       "      <td>tz2ACR9Bx2TP9c8vzPPaoZXQhsAZM9oMf8z6</td>\n",
       "      <td>True</td>\n",
       "      <td>93124</td>\n",
       "      <td>49</td>\n",
       "      <td>2022-03-11 21:25:04+00:00</td>\n",
       "      <td>2022-04-04 13:49:14+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9448</th>\n",
       "      <td>9448</td>\n",
       "      <td>tz2SLzfYFDgX9WGG3QwCbr7HuNndnesXfVQQ</td>\n",
       "      <td>True</td>\n",
       "      <td>372841</td>\n",
       "      <td>37</td>\n",
       "      <td>2022-03-12 17:41:24+00:00</td>\n",
       "      <td>2022-03-26 03:24:34+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8840</th>\n",
       "      <td>8840</td>\n",
       "      <td>tz2PgJDk5aY51wFdZmKNJG3zJxG4Gs3EwepX</td>\n",
       "      <td>True</td>\n",
       "      <td>173540</td>\n",
       "      <td>35</td>\n",
       "      <td>2022-03-12 16:05:34+00:00</td>\n",
       "      <td>2022-03-23 10:02:54+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>581</th>\n",
       "      <td>581</td>\n",
       "      <td>tz1cAfm45NDw1XtDo8fHMsaKveGbc6x97QX7</td>\n",
       "      <td>True</td>\n",
       "      <td>374263</td>\n",
       "      <td>33</td>\n",
       "      <td>2022-03-11 21:38:04+00:00</td>\n",
       "      <td>2022-04-02 22:02:59+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7788</th>\n",
       "      <td>7788</td>\n",
       "      <td>tz2HRKNQK4DCJB7xQXSxYho2y24MmVbaUcsF</td>\n",
       "      <td>True</td>\n",
       "      <td>27089648</td>\n",
       "      <td>33</td>\n",
       "      <td>2022-03-11 23:46:54+00:00</td>\n",
       "      <td>2022-03-12 19:35:54+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5439</th>\n",
       "      <td>5439</td>\n",
       "      <td>tz1XZs3cL64fg1WUPN6yQwH4gaaqUqKHEMY2</td>\n",
       "      <td>True</td>\n",
       "      <td>144094</td>\n",
       "      <td>31</td>\n",
       "      <td>2022-03-11 15:18:54+00:00</td>\n",
       "      <td>2022-03-17 19:08:14+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9137</th>\n",
       "      <td>9137</td>\n",
       "      <td>tz2QwYFPxtxJxfUDNWJuZ6iea53155gUz2WU</td>\n",
       "      <td>True</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>2022-03-11 06:04:54+00:00</td>\n",
       "      <td>2022-03-18 22:21:24+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>158</td>\n",
       "      <td>tz1aoKAVmvzpUq9Q1Ru7id8gPmMDnQJrVkup</td>\n",
       "      <td>True</td>\n",
       "      <td>1</td>\n",
       "      <td>26</td>\n",
       "      <td>2022-03-11 21:24:04+00:00</td>\n",
       "      <td>2022-03-12 21:25:54+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7292</th>\n",
       "      <td>7292</td>\n",
       "      <td>tz2F9m2NA8YXJLBpNGLUehToyr2fdhrJcgsM</td>\n",
       "      <td>True</td>\n",
       "      <td>1</td>\n",
       "      <td>26</td>\n",
       "      <td>2022-03-12 15:38:34+00:00</td>\n",
       "      <td>2022-03-17 12:13:44+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1993</th>\n",
       "      <td>1993</td>\n",
       "      <td>tz1hsyEpFKWmzWkf2Z9DrUbC9sQypMMSskjc</td>\n",
       "      <td>True</td>\n",
       "      <td>131489</td>\n",
       "      <td>21</td>\n",
       "      <td>2022-03-11 06:46:54+00:00</td>\n",
       "      <td>2022-04-07 15:14:14+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1097</th>\n",
       "      <td>1097</td>\n",
       "      <td>tz1ecAh5xPsxSrAUjde6o5E71zNGAaL67ADm</td>\n",
       "      <td>True</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>2022-03-11 06:40:54+00:00</td>\n",
       "      <td>2022-03-14 06:41:24+00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0                               Address  Revealed    Balance  \\\n",
       "1606        1606  tz1gCRtyKVXggaz8ftjcq6XKieY74PMJ3nyF      True       3186   \n",
       "542          542  tz1c31KQdndxSMon9umQu3XQpLdzqTJ8FZ68      True  337494575   \n",
       "9070        9070  tz2QnTXyY7L5wT6bYaGuq6YhKPUpmF1Drt9F      True    6059007   \n",
       "4362        4362  tz1TXCaPWoDjRddDd64bAKMU7G2oVsfsoqHA      True          1   \n",
       "6323        6323  tz2ACR9Bx2TP9c8vzPPaoZXQhsAZM9oMf8z6      True      93124   \n",
       "9448        9448  tz2SLzfYFDgX9WGG3QwCbr7HuNndnesXfVQQ      True     372841   \n",
       "8840        8840  tz2PgJDk5aY51wFdZmKNJG3zJxG4Gs3EwepX      True     173540   \n",
       "581          581  tz1cAfm45NDw1XtDo8fHMsaKveGbc6x97QX7      True     374263   \n",
       "7788        7788  tz2HRKNQK4DCJB7xQXSxYho2y24MmVbaUcsF      True   27089648   \n",
       "5439        5439  tz1XZs3cL64fg1WUPN6yQwH4gaaqUqKHEMY2      True     144094   \n",
       "9137        9137  tz2QwYFPxtxJxfUDNWJuZ6iea53155gUz2WU      True          1   \n",
       "158          158  tz1aoKAVmvzpUq9Q1Ru7id8gPmMDnQJrVkup      True          1   \n",
       "7292        7292  tz2F9m2NA8YXJLBpNGLUehToyr2fdhrJcgsM      True          1   \n",
       "1993        1993  tz1hsyEpFKWmzWkf2Z9DrUbC9sQypMMSskjc      True     131489   \n",
       "1097        1097  tz1ecAh5xPsxSrAUjde6o5E71zNGAaL67ADm      True          1   \n",
       "\n",
       "      NumTransactions         FirstActivityTime          LastActivityTime  \n",
       "1606              178 2022-03-12 07:24:24+00:00 2022-03-28 18:36:44+00:00  \n",
       "542                81 2022-03-13 21:29:24+00:00 2022-03-21 06:02:14+00:00  \n",
       "9070               60 2022-03-12 16:23:14+00:00 2022-03-14 19:48:44+00:00  \n",
       "4362               53 2022-03-12 17:44:24+00:00 2022-03-17 01:25:24+00:00  \n",
       "6323               49 2022-03-11 21:25:04+00:00 2022-04-04 13:49:14+00:00  \n",
       "9448               37 2022-03-12 17:41:24+00:00 2022-03-26 03:24:34+00:00  \n",
       "8840               35 2022-03-12 16:05:34+00:00 2022-03-23 10:02:54+00:00  \n",
       "581                33 2022-03-11 21:38:04+00:00 2022-04-02 22:02:59+00:00  \n",
       "7788               33 2022-03-11 23:46:54+00:00 2022-03-12 19:35:54+00:00  \n",
       "5439               31 2022-03-11 15:18:54+00:00 2022-03-17 19:08:14+00:00  \n",
       "9137               27 2022-03-11 06:04:54+00:00 2022-03-18 22:21:24+00:00  \n",
       "158                26 2022-03-11 21:24:04+00:00 2022-03-12 21:25:54+00:00  \n",
       "7292               26 2022-03-12 15:38:34+00:00 2022-03-17 12:13:44+00:00  \n",
       "1993               21 2022-03-11 06:46:54+00:00 2022-04-07 15:14:14+00:00  \n",
       "1097               19 2022-03-11 06:40:54+00:00 2022-03-14 06:41:24+00:00  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pantone_sxsw[(pantone_sxsw['Balance'] > 0) & (pantone_sxsw['NumTransactions'] > 1)].sort_values(['NumTransactions'], ascending=False).head(15)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "da54e46c",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "cfa78f7e",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2c7b7f67",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ca10ead0",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d5285169",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ba62caa7",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}