CalLink Scraping Analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Native imports\n",
    "import sys\n",
    "import os\n",
    "import os.path\n",
    "import json\n",
    "from pprint import pprint\n",
    "import urllib.request\n",
    "import urllib.parse\n",
    "\n",
    "# 3rd-party scraping/parsing imports\n",
    "import requests\n",
    "from bs4 import BeautifulSoup\n",
    "import dateutil.parser as dt\n",
    "\n",
    "# 3rd-party data science imports\n",
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "\n",
    "# Used to make the plots bigger\n",
    "import matplotlib.pyplot as plt\n",
    "plt.rcParams['figure.figsize'] = (8, 8)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "FORCE_ORG_CATALOG_DOWNLOAD = True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "ORGS_CATALOG_URL = 'https://callink.berkeley.edu/api/discovery/search/organizations?orderBy%5B0%5D=UpperName%20asc&top=1500'\n",
    "ORG_CATEGORIES_URL = 'https://callink.berkeley.edu/api/discovery/organization/category?take=1000&orderByField=name'\n",
    "\n",
    "DATA_FOLDER = 'data'\n",
    "ORG_JSON_FILE = f'{DATA_PATH}/callink-organizations.json'\n",
    "\n",
    "ORG_URL = 'https://callink.berkeley.edu/organization/'\n",
    "PROFILE_PIC_URL = 'https://se-infra-imageserver2.azureedge.net/clink/images/'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Step 0: Download organization data\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "os.makedirs(DATA_FOLDER, exist_ok=True)\n",
    "\n",
    "if FORCE_ORG_CATALOG_DOWNLOAD or not os.path.isfile(ORG_JSON_FILE):\n",
    "    urllib.request.urlretrieve(ORGS_CATALOG_URL, ORG_JSON_FILE)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Step 1: Load JSON files"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of Organizations: 1462\n"
     ]
    }
   ],
   "source": [
    "# Load organizations file\n",
    "with open(ORG_JSON_FILE) as fp:\n",
    "    data = json.load(fp)\n",
    "    \n",
    "    num_orgs = data['@odata.count']\n",
    "    print('Number of Organizations:', num_orgs)\n",
    "    orgs = data['value']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Step 2: Do some data cleaning and sanity checking"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1462 entries, 0 to 1461\n",
      "Data columns (total 15 columns):\n",
      " #   Column                Non-Null Count  Dtype \n",
      "---  ------                --------------  ----- \n",
      " 0   @search.score         1462 non-null   Int64 \n",
      " 1   Id                    1462 non-null   Int64 \n",
      " 2   InstitutionId         1462 non-null   Int64 \n",
      " 3   ParentOrganizationId  1462 non-null   Int64 \n",
      " 4   BranchId              1462 non-null   Int64 \n",
      " 5   Name                  1462 non-null   string\n",
      " 6   ShortName             1149 non-null   string\n",
      " 7   WebsiteKey            1462 non-null   string\n",
      " 8   ProfilePicture        1228 non-null   string\n",
      " 9   Description           1188 non-null   string\n",
      " 10  Summary               1462 non-null   string\n",
      " 11  CategoryIds           1462 non-null   object\n",
      " 12  CategoryNames         1462 non-null   object\n",
      " 13  Status                1462 non-null   string\n",
      " 14  Visibility            1462 non-null   string\n",
      "dtypes: Int64(5), object(2), string(8)\n",
      "memory usage: 178.6+ KB\n"
     ]
    }
   ],
   "source": [
    "# Prep orgs dataframe\n",
    "orgs_df = pd.DataFrame(orgs)\n",
    "orgs_df = orgs_df.apply(pd.to_numeric, errors='ignore').convert_dtypes()\n",
    "orgs_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>@search.score</th>\n",
       "      <th>Id</th>\n",
       "      <th>InstitutionId</th>\n",
       "      <th>ParentOrganizationId</th>\n",
       "      <th>BranchId</th>\n",
       "      <th>Name</th>\n",
       "      <th>ShortName</th>\n",
       "      <th>WebsiteKey</th>\n",
       "      <th>ProfilePicture</th>\n",
       "      <th>Description</th>\n",
       "      <th>Summary</th>\n",
       "      <th>CategoryIds</th>\n",
       "      <th>CategoryNames</th>\n",
       "      <th>Status</th>\n",
       "      <th>Visibility</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>136978</td>\n",
       "      <td>1660</td>\n",
       "      <td>45852</td>\n",
       "      <td>45852</td>\n",
       "      <td>180 Degrees Consulting at Berkeley</td>\n",
       "      <td>180DC</td>\n",
       "      <td>180dcberkeley</td>\n",
       "      <td>75258de9-3e52-4eac-902f-5e6c58534815ce019de6-d...</td>\n",
       "      <td>&lt;p&gt;180 Degrees Consulting is the world's large...</td>\n",
       "      <td>180 Degrees Consulting provides pro-bono consu...</td>\n",
       "      <td>[2693, 5115, 5118, 7395, 7850, 9413, 9415, 10377]</td>\n",
       "      <td>[y ASUC Student Activity Groups, Professional ...</td>\n",
       "      <td>Active</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>222008</td>\n",
       "      <td>1660</td>\n",
       "      <td>45852</td>\n",
       "      <td>45852</td>\n",
       "      <td>3D Modeling and Animation at Berkeley</td>\n",
       "      <td>3DMA@B</td>\n",
       "      <td>3d-modeling-and-animation-at-berkeley</td>\n",
       "      <td>636dc60c-77df-4fc6-ae01-0530ffd7b9e5ec000150-5...</td>\n",
       "      <td>&lt;div class=\"x_x_x_x_x_x_x_x_x_x_page\" title=\"P...</td>\n",
       "      <td>We are a student organization dedicated to edu...</td>\n",
       "      <td>[5120, 7850]</td>\n",
       "      <td>[Technology Student Organizations, Undergradua...</td>\n",
       "      <td>Active</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>92133</td>\n",
       "      <td>1660</td>\n",
       "      <td>45852</td>\n",
       "      <td>45852</td>\n",
       "      <td>3DMC</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>3dmc</td>\n",
       "      <td>90865567-61a4-4ff3-b4ad-667cbfae0fa5ff54bfe8-0...</td>\n",
       "      <td>&lt;p&gt;3DMC focuses on teaching and learning 3D pr...</td>\n",
       "      <td>Interested in Design, 3D Printing, and 3D Mode...</td>\n",
       "      <td>[2693, 5111, 7850]</td>\n",
       "      <td>[y ASUC Student Activity Groups, Media &amp; Film ...</td>\n",
       "      <td>Active</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>326213</td>\n",
       "      <td>1660</td>\n",
       "      <td>45852</td>\n",
       "      <td>45852</td>\n",
       "      <td>5&amp;2 Community Service</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>5and2</td>\n",
       "      <td>a0992b37-4b8c-4336-9900-dca867a1bf83e0ac0b53-1...</td>\n",
       "      <td>&lt;div&gt;\r\n",
       "&lt;p style=\"line-height: 22px; font-size:...</td>\n",
       "      <td>Our mission is to provide virtual volunteering...</td>\n",
       "      <td>[5118]</td>\n",
       "      <td>[Service Student Organizations]</td>\n",
       "      <td>Active</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>91982</td>\n",
       "      <td>1660</td>\n",
       "      <td>45852</td>\n",
       "      <td>45852</td>\n",
       "      <td>A Better Way at Berkeley</td>\n",
       "      <td>ABW</td>\n",
       "      <td>abetterwayberkeley</td>\n",
       "      <td>e78e6767-c883-4bbd-9a39-7349e633a5ff1fd21fb7-8...</td>\n",
       "      <td>&lt;p&gt;&lt;span style=\"font-weight: 400;\"&gt;Children in...</td>\n",
       "      <td>**Active Fall 2020!!** We tutor foster kids ar...</td>\n",
       "      <td>[5118, 7850]</td>\n",
       "      <td>[Service Student Organizations, Undergraduate ...</td>\n",
       "      <td>Active</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   @search.score      Id  InstitutionId  ParentOrganizationId  BranchId  \\\n",
       "0              1  136978           1660                 45852     45852   \n",
       "1              1  222008           1660                 45852     45852   \n",
       "2              1   92133           1660                 45852     45852   \n",
       "3              1  326213           1660                 45852     45852   \n",
       "4              1   91982           1660                 45852     45852   \n",
       "\n",
       "                                    Name ShortName  \\\n",
       "0    180 Degrees Consulting at Berkeley      180DC   \n",
       "1  3D Modeling and Animation at Berkeley    3DMA@B   \n",
       "2                                   3DMC      <NA>   \n",
       "3                  5&2 Community Service      <NA>   \n",
       "4               A Better Way at Berkeley       ABW   \n",
       "\n",
       "                              WebsiteKey  \\\n",
       "0                          180dcberkeley   \n",
       "1  3d-modeling-and-animation-at-berkeley   \n",
       "2                                   3dmc   \n",
       "3                                  5and2   \n",
       "4                     abetterwayberkeley   \n",
       "\n",
       "                                      ProfilePicture  \\\n",
       "0  75258de9-3e52-4eac-902f-5e6c58534815ce019de6-d...   \n",
       "1  636dc60c-77df-4fc6-ae01-0530ffd7b9e5ec000150-5...   \n",
       "2  90865567-61a4-4ff3-b4ad-667cbfae0fa5ff54bfe8-0...   \n",
       "3  a0992b37-4b8c-4336-9900-dca867a1bf83e0ac0b53-1...   \n",
       "4  e78e6767-c883-4bbd-9a39-7349e633a5ff1fd21fb7-8...   \n",
       "\n",
       "                                         Description  \\\n",
       "0  <p>180 Degrees Consulting is the world's large...   \n",
       "1  <div class=\"x_x_x_x_x_x_x_x_x_x_page\" title=\"P...   \n",
       "2  <p>3DMC focuses on teaching and learning 3D pr...   \n",
       "3  <div>\n",
       "<p style=\"line-height: 22px; font-size:...   \n",
       "4  <p><span style=\"font-weight: 400;\">Children in...   \n",
       "\n",
       "                                             Summary  \\\n",
       "0  180 Degrees Consulting provides pro-bono consu...   \n",
       "1  We are a student organization dedicated to edu...   \n",
       "2  Interested in Design, 3D Printing, and 3D Mode...   \n",
       "3  Our mission is to provide virtual volunteering...   \n",
       "4  **Active Fall 2020!!** We tutor foster kids ar...   \n",
       "\n",
       "                                         CategoryIds  \\\n",
       "0  [2693, 5115, 5118, 7395, 7850, 9413, 9415, 10377]   \n",
       "1                                       [5120, 7850]   \n",
       "2                                 [2693, 5111, 7850]   \n",
       "3                                             [5118]   \n",
       "4                                       [5118, 7850]   \n",
       "\n",
       "                                       CategoryNames  Status Visibility  \n",
       "0  [y ASUC Student Activity Groups, Professional ...  Active     Public  \n",
       "1  [Technology Student Organizations, Undergradua...  Active     Public  \n",
       "2  [y ASUC Student Activity Groups, Media & Film ...  Active     Public  \n",
       "3                    [Service Student Organizations]  Active     Public  \n",
       "4  [Service Student Organizations, Undergraduate ...  Active     Public  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "orgs_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Unique value counts\n",
      "===================\n",
      "@search.score              1\n",
      "Id                      1462\n",
      "InstitutionId              1\n",
      "ParentOrganizationId       2\n",
      "BranchId                   2\n",
      "Name                    1462\n",
      "ShortName               1121\n",
      "WebsiteKey              1462\n",
      "ProfilePicture          1229\n",
      "Description             1188\n",
      "Summary                 1414\n",
      "Status                     1\n",
      "Visibility                 1\n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "# List unique values and their counts\n",
    "# NOTE: We are excluding the 'Category' keys because lists aren't hashable\n",
    "print('Unique value counts')\n",
    "print('===================')\n",
    "print(pd.Series({c: len(orgs_df[c].unique()) for c in orgs_df if 'Category' not in c}))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Id</th>\n",
       "      <th>Name</th>\n",
       "      <th>ShortName</th>\n",
       "      <th>WebsiteKey</th>\n",
       "      <th>ProfilePicture</th>\n",
       "      <th>Description</th>\n",
       "      <th>Summary</th>\n",
       "      <th>CategoryIds</th>\n",
       "      <th>CategoryNames</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>136978</td>\n",
       "      <td>180 Degrees Consulting at Berkeley</td>\n",
       "      <td>180DC</td>\n",
       "      <td>180dcberkeley</td>\n",
       "      <td>75258de9-3e52-4eac-902f-5e6c58534815ce019de6-d...</td>\n",
       "      <td>&lt;p&gt;180 Degrees Consulting is the world's large...</td>\n",
       "      <td>180 Degrees Consulting provides pro-bono consu...</td>\n",
       "      <td>[2693, 5115, 5118, 7395, 7850, 9413, 9415, 10377]</td>\n",
       "      <td>[y ASUC Student Activity Groups, Professional ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>222008</td>\n",
       "      <td>3D Modeling and Animation at Berkeley</td>\n",
       "      <td>3DMA@B</td>\n",
       "      <td>3d-modeling-and-animation-at-berkeley</td>\n",
       "      <td>636dc60c-77df-4fc6-ae01-0530ffd7b9e5ec000150-5...</td>\n",
       "      <td>&lt;div class=\"x_x_x_x_x_x_x_x_x_x_page\" title=\"P...</td>\n",
       "      <td>We are a student organization dedicated to edu...</td>\n",
       "      <td>[5120, 7850]</td>\n",
       "      <td>[Technology Student Organizations, Undergradua...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>92133</td>\n",
       "      <td>3DMC</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>3dmc</td>\n",
       "      <td>90865567-61a4-4ff3-b4ad-667cbfae0fa5ff54bfe8-0...</td>\n",
       "      <td>&lt;p&gt;3DMC focuses on teaching and learning 3D pr...</td>\n",
       "      <td>Interested in Design, 3D Printing, and 3D Mode...</td>\n",
       "      <td>[2693, 5111, 7850]</td>\n",
       "      <td>[y ASUC Student Activity Groups, Media &amp; Film ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>326213</td>\n",
       "      <td>5&amp;2 Community Service</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>5and2</td>\n",
       "      <td>a0992b37-4b8c-4336-9900-dca867a1bf83e0ac0b53-1...</td>\n",
       "      <td>&lt;div&gt;\r\n",
       "&lt;p style=\"line-height: 22px; font-size:...</td>\n",
       "      <td>Our mission is to provide virtual volunteering...</td>\n",
       "      <td>[5118]</td>\n",
       "      <td>[Service Student Organizations]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>91982</td>\n",
       "      <td>A Better Way at Berkeley</td>\n",
       "      <td>ABW</td>\n",
       "      <td>abetterwayberkeley</td>\n",
       "      <td>e78e6767-c883-4bbd-9a39-7349e633a5ff1fd21fb7-8...</td>\n",
       "      <td>&lt;p&gt;&lt;span style=\"font-weight: 400;\"&gt;Children in...</td>\n",
       "      <td>**Active Fall 2020!!** We tutor foster kids ar...</td>\n",
       "      <td>[5118, 7850]</td>\n",
       "      <td>[Service Student Organizations, Undergraduate ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1457</th>\n",
       "      <td>91258</td>\n",
       "      <td>Youth Advocacy Project</td>\n",
       "      <td>YAP</td>\n",
       "      <td>youthadvocacyproject</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;p&gt;Students will work as youth advocates to su...</td>\n",
       "      <td>Enable law students to get experience with dir...</td>\n",
       "      <td>[2691, 5118]</td>\n",
       "      <td>[GSG - Graduate Student Groups, Service Studen...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1458</th>\n",
       "      <td>91813</td>\n",
       "      <td>Zahanat</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>zahanat</td>\n",
       "      <td>eda8071c-1591-4c8c-9ad6-aadf76d161bbb3af2a40-a...</td>\n",
       "      <td>&lt;p&gt;Zahanat is a competitive all-male fusion da...</td>\n",
       "      <td>Zahanat is a competitive all-male fusion dance...</td>\n",
       "      <td>[5113, 7850]</td>\n",
       "      <td>[Performing Arts Student Organizations, Underg...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1459</th>\n",
       "      <td>46461</td>\n",
       "      <td>Zawadi:  Black LGBTQ Community at Berkeley</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>zawadi</td>\n",
       "      <td>e543d5e4-0767-4729-ba73-7a25006c809e77ab99c4-b...</td>\n",
       "      <td>&lt;p&gt;We are interested in increasing visibility ...</td>\n",
       "      <td>This group is a social, academic, and politica...</td>\n",
       "      <td>[2691, 7853]</td>\n",
       "      <td>[GSG - Graduate Student Groups, Cultural &amp; Ide...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1460</th>\n",
       "      <td>181872</td>\n",
       "      <td>Zeta Chi Consulting</td>\n",
       "      <td>ZC Consulting</td>\n",
       "      <td>zcconsulting</td>\n",
       "      <td>dabebe05-2feb-444d-8b23-791bd72bef9351c89da1-6...</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>ZC Consulting seeks to bring together students...</td>\n",
       "      <td>[5115, 7850]</td>\n",
       "      <td>[Professional Student Organizations, Undergrad...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1461</th>\n",
       "      <td>91377</td>\n",
       "      <td>Zeta Tau Alpha</td>\n",
       "      <td>ZTA</td>\n",
       "      <td>zetataualpha</td>\n",
       "      <td>79cff071-d349-4dd8-8dc9-30e4307573b5b147b553-8...</td>\n",
       "      <td>&lt;p&gt;&lt;strong&gt;Welcome to Zeta Tau Alpha, Upsilon ...</td>\n",
       "      <td>Zeta Tau Alpha provides well over a hundred wo...</td>\n",
       "      <td>[5138]</td>\n",
       "      <td>[CalGreeks Panhellenic Council (PHC) Sororities]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1462 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          Id                                        Name      ShortName  \\\n",
       "0     136978         180 Degrees Consulting at Berkeley           180DC   \n",
       "1     222008       3D Modeling and Animation at Berkeley         3DMA@B   \n",
       "2      92133                                        3DMC           <NA>   \n",
       "3     326213                       5&2 Community Service           <NA>   \n",
       "4      91982                    A Better Way at Berkeley            ABW   \n",
       "...      ...                                         ...            ...   \n",
       "1457   91258                      Youth Advocacy Project            YAP   \n",
       "1458   91813                                     Zahanat           <NA>   \n",
       "1459   46461  Zawadi:  Black LGBTQ Community at Berkeley           <NA>   \n",
       "1460  181872                         Zeta Chi Consulting  ZC Consulting   \n",
       "1461   91377                              Zeta Tau Alpha            ZTA   \n",
       "\n",
       "                                 WebsiteKey  \\\n",
       "0                             180dcberkeley   \n",
       "1     3d-modeling-and-animation-at-berkeley   \n",
       "2                                      3dmc   \n",
       "3                                     5and2   \n",
       "4                        abetterwayberkeley   \n",
       "...                                     ...   \n",
       "1457                   youthadvocacyproject   \n",
       "1458                                zahanat   \n",
       "1459                                 zawadi   \n",
       "1460                           zcconsulting   \n",
       "1461                           zetataualpha   \n",
       "\n",
       "                                         ProfilePicture  \\\n",
       "0     75258de9-3e52-4eac-902f-5e6c58534815ce019de6-d...   \n",
       "1     636dc60c-77df-4fc6-ae01-0530ffd7b9e5ec000150-5...   \n",
       "2     90865567-61a4-4ff3-b4ad-667cbfae0fa5ff54bfe8-0...   \n",
       "3     a0992b37-4b8c-4336-9900-dca867a1bf83e0ac0b53-1...   \n",
       "4     e78e6767-c883-4bbd-9a39-7349e633a5ff1fd21fb7-8...   \n",
       "...                                                 ...   \n",
       "1457                                               <NA>   \n",
       "1458  eda8071c-1591-4c8c-9ad6-aadf76d161bbb3af2a40-a...   \n",
       "1459  e543d5e4-0767-4729-ba73-7a25006c809e77ab99c4-b...   \n",
       "1460  dabebe05-2feb-444d-8b23-791bd72bef9351c89da1-6...   \n",
       "1461  79cff071-d349-4dd8-8dc9-30e4307573b5b147b553-8...   \n",
       "\n",
       "                                            Description  \\\n",
       "0     <p>180 Degrees Consulting is the world's large...   \n",
       "1     <div class=\"x_x_x_x_x_x_x_x_x_x_page\" title=\"P...   \n",
       "2     <p>3DMC focuses on teaching and learning 3D pr...   \n",
       "3     <div>\n",
       "<p style=\"line-height: 22px; font-size:...   \n",
       "4     <p><span style=\"font-weight: 400;\">Children in...   \n",
       "...                                                 ...   \n",
       "1457  <p>Students will work as youth advocates to su...   \n",
       "1458  <p>Zahanat is a competitive all-male fusion da...   \n",
       "1459  <p>We are interested in increasing visibility ...   \n",
       "1460                                               <NA>   \n",
       "1461  <p><strong>Welcome to Zeta Tau Alpha, Upsilon ...   \n",
       "\n",
       "                                                Summary  \\\n",
       "0     180 Degrees Consulting provides pro-bono consu...   \n",
       "1     We are a student organization dedicated to edu...   \n",
       "2     Interested in Design, 3D Printing, and 3D Mode...   \n",
       "3     Our mission is to provide virtual volunteering...   \n",
       "4     **Active Fall 2020!!** We tutor foster kids ar...   \n",
       "...                                                 ...   \n",
       "1457  Enable law students to get experience with dir...   \n",
       "1458  Zahanat is a competitive all-male fusion dance...   \n",
       "1459  This group is a social, academic, and politica...   \n",
       "1460  ZC Consulting seeks to bring together students...   \n",
       "1461  Zeta Tau Alpha provides well over a hundred wo...   \n",
       "\n",
       "                                            CategoryIds  \\\n",
       "0     [2693, 5115, 5118, 7395, 7850, 9413, 9415, 10377]   \n",
       "1                                          [5120, 7850]   \n",
       "2                                    [2693, 5111, 7850]   \n",
       "3                                                [5118]   \n",
       "4                                          [5118, 7850]   \n",
       "...                                                 ...   \n",
       "1457                                       [2691, 5118]   \n",
       "1458                                       [5113, 7850]   \n",
       "1459                                       [2691, 7853]   \n",
       "1460                                       [5115, 7850]   \n",
       "1461                                             [5138]   \n",
       "\n",
       "                                          CategoryNames  \n",
       "0     [y ASUC Student Activity Groups, Professional ...  \n",
       "1     [Technology Student Organizations, Undergradua...  \n",
       "2     [y ASUC Student Activity Groups, Media & Film ...  \n",
       "3                       [Service Student Organizations]  \n",
       "4     [Service Student Organizations, Undergraduate ...  \n",
       "...                                                 ...  \n",
       "1457  [GSG - Graduate Student Groups, Service Studen...  \n",
       "1458  [Performing Arts Student Organizations, Underg...  \n",
       "1459  [GSG - Graduate Student Groups, Cultural & Ide...  \n",
       "1460  [Professional Student Organizations, Undergrad...  \n",
       "1461   [CalGreeks Panhellenic Council (PHC) Sororities]  \n",
       "\n",
       "[1462 rows x 9 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Keep only columns that have more than 1 unique value\n",
    "wanted_org_cols = ['Id', 'Name', 'ShortName', 'WebsiteKey', 'ProfilePicture',\n",
    "                   'Description', 'Summary', 'CategoryIds', 'CategoryNames']\n",
    "orgs_df = orgs_df[wanted_org_cols]\n",
    "orgs_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Step 3: Scrape the data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "50 / 1462 organizations processed\n",
      "100 / 1462 organizations processed\n",
      "150 / 1462 organizations processed\n",
      "200 / 1462 organizations processed\n",
      "250 / 1462 organizations processed\n",
      "300 / 1462 organizations processed\n",
      "350 / 1462 organizations processed\n",
      "400 / 1462 organizations processed\n",
      "450 / 1462 organizations processed\n",
      "500 / 1462 organizations processed\n",
      "550 / 1462 organizations processed\n",
      "600 / 1462 organizations processed\n",
      "650 / 1462 organizations processed\n",
      "700 / 1462 organizations processed\n",
      "750 / 1462 organizations processed\n",
      "800 / 1462 organizations processed\n",
      "850 / 1462 organizations processed\n",
      "900 / 1462 organizations processed\n",
      "950 / 1462 organizations processed\n",
      "1000 / 1462 organizations processed\n",
      "1050 / 1462 organizations processed\n",
      "1100 / 1462 organizations processed\n",
      "1150 / 1462 organizations processed\n",
      "1200 / 1462 organizations processed\n",
      "1250 / 1462 organizations processed\n",
      "1300 / 1462 organizations processed\n",
      "1350 / 1462 organizations processed\n",
      "1400 / 1462 organizations processed\n",
      "1450 / 1462 organizations processed\n",
      "All orgs processed!\n"
     ]
    }
   ],
   "source": [
    "'''\n",
    "Strategy: Although we have to navigate into each link to get the email and any other important info,\n",
    "the good part is we don't need to fully render the page despite CalLink being done in React.\n",
    "\n",
    "'window.initialAppState' is the key, so we just need to fetch that for each organization and we're\n",
    "good to go!\n",
    "'''\n",
    "\n",
    "PHOTOS_DOWNLOAD = False\n",
    "\n",
    "# Make the needed folders for downloading \"debug\" files\n",
    "COVER_PHOTOS_DIR = 'data/cover_pics/'\n",
    "PROFILE_PHOTOS_DIR = 'data/profile_pics/'\n",
    "APP_STATE_DIR = 'data/app_states/'\n",
    "\n",
    "os.makedirs(COVER_PHOTOS_DIR, exist_ok=True)\n",
    "os.makedirs(PROFILE_PHOTOS_DIR, exist_ok=True)\n",
    "os.makedirs(APP_STATE_DIR, exist_ok=True)\n",
    "\n",
    "def fetch_html_page(url):\n",
    "    return requests.get(url).text.strip()\n",
    "\n",
    "def fetch_init_app_state(soup):\n",
    "    for element in soup.find_all('script'):\n",
    "        if len(element.contents) > 0 and 'window.initialAppState' in element.contents[0]:\n",
    "            json_str = element.contents[0].split(' = ')[1][:-1]\n",
    "            return json.loads(json_str)\n",
    "    return None\n",
    "\n",
    "def safe_fetch(obj, key):\n",
    "    return (None if pd.isna(obj.get(key)) else obj[key].strip()) or None\n",
    "\n",
    "def process_org(org_row):\n",
    "    \n",
    "    # Non-nullable initial fields\n",
    "    org_id         = safe_fetch(org_row, 'WebsiteKey')\n",
    "    org_name       = safe_fetch(org_row, 'Name')\n",
    "    org_summary    = safe_fetch(org_row, 'Summary')\n",
    "    org_categories = [name.strip() for name in org_row.get('CategoryNames')]\n",
    "    \n",
    "    # Nullable initial fields\n",
    "    org_short_name  = safe_fetch(org_row, 'ShortName')\n",
    "    org_description = safe_fetch(org_row, 'Description')\n",
    "    \n",
    "    \n",
    "    if not os.path.isfile(APP_STATE_DIR + f'{org_id}.json'):\n",
    "        # Fetch the app state in the org page\n",
    "        html = fetch_html_page(ORG_URL + org_id)\n",
    "        soup = BeautifulSoup(html, 'html.parser')\n",
    "        app_state = fetch_init_app_state(soup)\n",
    "\n",
    "        # Save the app state for debugging purposes\n",
    "        with open(APP_STATE_DIR + f'{org_id}.json', 'w') as fp:\n",
    "            json.dump(app_state, fp)\n",
    "    else:\n",
    "        # Load the app state from the JSON file\n",
    "        with open(APP_STATE_DIR + f'{org_id}.json', 'r') as fp:\n",
    "            app_state = json.load(fp)\n",
    "            \n",
    "    # Shortcut to important organization info\n",
    "    org_details = app_state['preFetchedData']['organization']\n",
    "    \n",
    "    if PHOTOS_DOWNLOAD and not os.path.isfile(COVER_PHOTOS_DIR + f'{org_id}-cover.jpg'):\n",
    "        # Save the cover photo\n",
    "        cover_photo_url = app_state['coverPhoto']['url'].strip()\n",
    "        urllib.request.urlretrieve(cover_photo_url, COVER_PHOTOS_DIR + f'{org_id}-cover.jpg')\n",
    "    \n",
    "    if PHOTOS_DOWNLOAD and not os.path.isfile(PROFILE_PHOTOS_DIR + f'{org_id}-profile.jpg'):\n",
    "        # Save the profile photo\n",
    "        if org_details['profilePicture'] is not None:\n",
    "            profile_photo_url = PROFILE_PIC_URL + org_details['profilePicture'].strip()\n",
    "            urllib.request.urlretrieve(profile_photo_url, PROFILE_PHOTOS_DIR + f'{org_id}-profile.jpg')\n",
    "    \n",
    "    # Get the email, phone, and social media links\n",
    "    email = safe_fetch(org_details, 'email')\n",
    "    \n",
    "    if (len(org_details['contactInfo']) > 1):\n",
    "        print('ALERT - multi contact info', org_id)\n",
    "    \n",
    "    if (len(org_details['contactInfo']) == 1):\n",
    "        contact_info_obj = org_details['contactInfo'][0]\n",
    "        phone     = safe_fetch(contact_info_obj, 'phoneNumber')\n",
    "        phone_ext = safe_fetch(contact_info_obj, 'extension')\n",
    "    else:\n",
    "        phone = None\n",
    "        phone_ext = None\n",
    "    \n",
    "    if org_details['primaryContact'] is not None:\n",
    "        primary_contact_name = f\"{org_details['primaryContact']['firstName']} {org_details['primaryContact']['lastName']}\".strip()\n",
    "        primary_contact_email = org_details['primaryContact']['primaryEmailAddress'].strip()\n",
    "    else:\n",
    "        primary_contact_name = None\n",
    "        primary_contact_email = None\n",
    "    \n",
    "    social_media_tag_map = [\n",
    "        ('website', 'externalWebsite'),\n",
    "        ('flickr', 'flickrUrl'),\n",
    "        ('google-calendar', 'googleCalendarUrl'),\n",
    "        ('google-plus', 'googlePlusUrl'),\n",
    "        ('instagram', 'instagramUrl'),\n",
    "        ('linkedin', 'linkedInUrl'),\n",
    "        ('pinterest', 'pinterestUrl'),\n",
    "        ('tumblr', 'tumblrUrl'),\n",
    "        ('vimeo', 'vimeoUrl'),\n",
    "        ('youtube', 'youtubeUrl'),\n",
    "        ('facebook', 'facebookUrl'),\n",
    "        ('twitter-url', 'twitterUrl'),\n",
    "        ('twitter-user', 'twitterUserName')\n",
    "    ]\n",
    "    \n",
    "    social_media = {}\n",
    "    for (native_tag, alien_tag) in social_media_tag_map:\n",
    "        smedia_obj = org_details['socialMedia']\n",
    "        social_media[native_tag] = safe_fetch(smedia_obj, alien_tag)\n",
    "        \n",
    "    org_start_date = dt.parse(org_details['startDate'])\n",
    "    if org_start_date.timestamp() < 0:\n",
    "        org_start_date = None\n",
    "    else:\n",
    "        org_start_date = org_start_date.date()\n",
    "    \n",
    "    return {\n",
    "        'id': org_id, \n",
    "        'name': org_name,\n",
    "        'has-profile-pic': org_details['profilePicture'] is not None,\n",
    "        'has-cover-pic': True,\n",
    "        # NOTE: There hasn't been a case where an org has no cover photo as of yet.\n",
    "        'start-date': org_start_date,\n",
    "        'summary': org_summary,\n",
    "        'categories': org_categories,\n",
    "        'short-name': org_short_name,\n",
    "        'description': org_description,\n",
    "        'email': email,\n",
    "        'phone': phone,\n",
    "        'phone-ext': phone_ext,\n",
    "        'social-media': social_media\n",
    "    }\n",
    "\n",
    "processed_org_data = []\n",
    "\n",
    "for (index, row) in orgs_df.iterrows():\n",
    "    try:\n",
    "        processed_org = process_org(row)\n",
    "    except:\n",
    "        print(\"Unexpected error:\", sys.exc_info()[0])\n",
    "        print(f\"Problematic organization: {row['WebsiteKey']}\")\n",
    "        raise\n",
    "    processed_org_data += [processed_org]\n",
    "    \n",
    "    if ((index + 1) % 50 == 0):\n",
    "        print(f'{(index + 1)} / {num_orgs} organizations processed')\n",
    "print('All orgs processed!')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1462 entries, 0 to 1461\n",
      "Data columns (total 13 columns):\n",
      " #   Column           Non-Null Count  Dtype  \n",
      "---  ------           --------------  -----  \n",
      " 0   id               1462 non-null   string \n",
      " 1   name             1462 non-null   string \n",
      " 2   has-profile-pic  1462 non-null   boolean\n",
      " 3   has-cover-pic    1462 non-null   boolean\n",
      " 4   start-date       981 non-null    object \n",
      " 5   summary          1462 non-null   string \n",
      " 6   categories       1462 non-null   object \n",
      " 7   short-name       1146 non-null   string \n",
      " 8   description      1188 non-null   string \n",
      " 9   email            1182 non-null   string \n",
      " 10  phone            233 non-null    string \n",
      " 11  phone-ext        1 non-null      string \n",
      " 12  social-media     1462 non-null   object \n",
      "dtypes: boolean(2), object(3), string(8)\n",
      "memory usage: 131.5+ KB\n"
     ]
    }
   ],
   "source": [
    "# Let's make a DataFrame from all this new data\n",
    "new_orgs_df = pd.DataFrame(processed_org_data).convert_dtypes()\n",
    "new_orgs_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1462 entries, 0 to 1461\n",
      "Data columns (total 13 columns):\n",
      " #   Column           Non-Null Count  Dtype \n",
      "---  ------           --------------  ----- \n",
      " 0   website          891 non-null    string\n",
      " 1   flickr           12 non-null     string\n",
      " 2   google-calendar  77 non-null     string\n",
      " 3   google-plus      1 non-null      string\n",
      " 4   instagram        631 non-null    string\n",
      " 5   linkedin         210 non-null    string\n",
      " 6   pinterest        2 non-null      string\n",
      " 7   tumblr           5 non-null      string\n",
      " 8   vimeo            4 non-null      string\n",
      " 9   youtube          159 non-null    string\n",
      " 10  facebook         909 non-null    string\n",
      " 11  twitter-url      66 non-null     string\n",
      " 12  twitter-user     242 non-null    string\n",
      "dtypes: string(13)\n",
      "memory usage: 148.6 KB\n"
     ]
    }
   ],
   "source": [
    "# Let's also make a \"sub\" DataFrame for the social media links\n",
    "social_media_map = pd.DataFrame(processed_org_data)['social-media'].values.tolist()\n",
    "orgs_social_df = pd.DataFrame(social_media_map).convert_dtypes()\n",
    "orgs_social_df.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Step 4: Visualize and understand the data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAiQAAAHSCAYAAADc0NDpAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAApK0lEQVR4nO3de5hfVX3v8fdHgiAQEhDEiGI0UjGiBBlREG1QSq2ooEBDUStCm0Mt4qWo9HhqrbdjxVMvh1qMFMGKWARpEa2Ayv2ekBAi6MEKKEjxxiWgyMXv+eO3U3+MmWSSzGRlfvN+Pc88s/faa6/13Ts8yYe19/wmVYUkSVJLj2ldgCRJkoFEkiQ1ZyCRJEnNGUgkSVJzBhJJktScgUSSJDU3pXUBk9k222xTM2fObF2GJEnrzaJFi35WVdsObzeQNDRz5kwWLlzYugxJktabJLeurN1HNpIkqTlXSBp6+Ke/4Kf/9IXWZUiSJqFt/+L1rUt4FFdIJElScwYSSZLUnIFEkiQ1ZyCRJEnNGUgkSVJzBhJJktScgUSSJDVnIJEkSc0ZSCRJUnOTPpAkuSXJNqPsO5TkU9323CR7jm91kiRNDn50/BqoqoXAit+GNxe4D7i8WUGSJA2IgVkhSfKuJEd32x9P8u1u+2VJvpBk3yRXJLk2yZeTbNF3+juTXN19PaM77+Aky5Jcl+Tirm1uknOSzASOBN6eZEmSFyfZNsmZSa7pvl60fu+AJEkT18AEEuBi4MXd9hCwRZKNgb2A64H/BexTVc+jt8rxjr5z762q3YHjgU90be8F/rCqdgFe3T9RVd0CnAB8vKrmVNUlwCe7/ecDBwInjvkVSpI0oAbpkc0iYLckU4FfA9fSCyYvBs4GZgOXJQF4LHBF37mn9X3/eLd9GXByktOBr4xi/n2A2d34AFsmmVpVy/s7JZkPzAd48taPX5PrkyRpYA1MIKmqh5LcAryJ3nsdS4G9gVnAzcD5VfUnI50+fLuqjkzyAmA/YEmSOasp4THAHlX1q9XUuQBYADDnqU+vVfWVJGmyGKRHNtB7bHNM9/0Seu95LAGuBF7U937IZkl+r++8eX3fr+j6zKqqq6rqvcDPgKcMm2s5MLVv/zzgqBU7owgwkiSpM2iB5BJgBnBFVd0JPABcUlU/BQ4DTkuylF5A2anvvE2SXAW8FXh713ZckuuTLKMXcK4bNtdXgdeseKkVOBoYSrI0yQ30wpAkSRqFVPnUoJU5T316nX/s+1uXIUmahLb9i9c3mTfJoqoaGt4+aCskkiRpAjKQSJKk5gwkkiSpOQOJJElqzkAiSZKaM5BIkqTmDCSSJKk5A4kkSWpuYH6XzUQ0Zdutm30wjSRJGxJXSCRJUnMGEkmS1JyBRJIkNWcgkSRJzRlIJElScwYSSZLUnD/229CDP7mF244//Hfan3zUSQ2qkSSpHVdIJElScwYSSZLUnIFEkiQ1ZyCRJEnNGUgkSVJzBhJJktScgUSSJDVnIJEkSc0ZSIAkRye5McntSY7v2o5M8qerOGduknPWX5WSJA0uP6m1583AHwG/DwwBVNUJ6zpokilV9fC6jiNJ0qCb9CskSU4Ang6cDWzV1/6+JMd0289I8s0k1yW5NsmsYWM8P8niJE/vzluQ5Dzg8+vzWiRJmqgmfSCpqiOBHwN7A3eN0O1U4B+rahdgT+COFQeS7AmcAOxfVT/omnfr9g8dt8IlSRogPrJZjSRTge2r6iyAqnqgawd4FrAA2Leqftx32tlV9asRxpsPzAfYfqvNx7FySZImjkm/QjIKWcWxO4AHgF2Htd8/0glVtaCqhqpqaOstNh2L+iRJmvAMJKtRVfcCtyU5ACDJJkk26w7fDewHfDjJ3Bb1SZI0CAwko/MG4OgkS4HLgSeuOFBVdwKvAv4xyQsa1SdJ0oTmOyRAVc3sNk/uvqiq9/Udvwl46bDTfgBc2B3/IfDsrv2q8apTkqRB5QqJJElqzkAiSZKaM5BIkqTmDCSSJKk5A4kkSWrOQCJJkpozkEiSpOYMJJIkqTk/GK2hxz5hJk8+6qTWZUiS1JwrJJIkqTkDiSRJas5AIkmSmjOQSJKk5gwkkiSpOQOJJElqzh/7bWj5z27ighP3a13Gf9v7z77WugRJ0iTlCokkSWrOQCJJkpozkEiSpOYMJJIkqTkDiSRJas5AIkmSmjOQSJKk5gwkkiSpOQOJJElqrnkgSTI3yTnjPMd9YzTOzCTLxmIsSZL0W80DySBLslHrGiRJmghGFUiS/E2S7yY5P8lpSY5JMifJlUmWJjkryVZd35Han9+1XZHkuJWtNCTZPMlJSa5JsjjJ/iPU84wk30xyXZJrk8xKskWSb3X716/i3Hd24y9N8ndd28wkNyb5bJLvJDkvyeO6Y7t181wB/GXfODOTXNLNd22SPbv2uUkuSPJF4PrR3F9Jkia71QaSJEPAgcCuwGuBoe7Q54F3V9Vz6f3D+7eraf8ccGRV7QE8MsJ07wG+XVXPB/YGjkuy+Ur6nQr8Y1XtAuwJ3AE8ALymqp7Xnft/kmTYtewL7AjsDswBdkvyku7wjt2Yzwbu7q55Rd1Hd3X3+wnwB91884BP9R3bHXhPVc0e4TolSVKf0ayQ7AX8e1X9qqqWA18FNgemV9VFXZ9TgJckmTZC+3RgalVd3rV/cYS59gWOTbIEuBDYFNihv0OSqcD2VXUWQFU9UFW/BAJ8OMlS4JvA9sB2Kxl/X2AxcC2wE70gAnBzVS3pthcBM1dyPf/SN9bGwGeTXA98GegPH1dX1c0ru8Ak85MsTLLwnuUPjnAbJEmaXKaMok9W32XMxghwYFV971GNyefordD8GDhkhHNfB2wL7FZVDyW5hV6gGT7+/66qzwwbfybw676mR4DHdf1rhPneDtwJ7EIv2D3Qd+z+Ec6hqhYACwCeOXPaSGNLkjSpjGaF5FLgVUk2TbIFsB+9f3DvSvLirs8bgIuq6p4R2u8Clid5Ydc+Uqg4F3jLikctSXYFqKo3VdWcqnpFVd0L3JbkgK7PJkk2A6YBP+nCyN7AU0cY//DuOkiyfZInjHThVXU3cE+Svbqm1/UdngbcUVW/6a7TF1glSVpLq10hqaprkpwNXAfcCiwE7gHeCJzQhYEfAG/qThmp/Qh6jzjup/c45p6VTPcB4BPA0i6U3AK8ciX93gB8Jsn7gYeAg+m9V/LVJAuBJcB3V3It5yV5FnBFl3nuA17PyO+00NV/UpJf0gs0K3waODPJwcAFrGJVRJIkrVqqVv/UIMkWVXVfFzIuBuZX1bVrNFE3Rrd9LDCjqt66NkUPimfOnFYn/K+9Vt9xPdn7z77WugRJ0oBLsqiqhoa3j+YdEoAFSWbTeyfjlDUNI539kvx1N+etwGFrMYYkSRpAowokVXXouk5UVf8K/Ou6jiNJkgaPn9QqSZKaM5BIkqTmDCSSJKk5A4kkSWrOQCJJkpozkEiSpOZG+zkkGgdTt9nRDyOTJAlXSCRJ0gbAQCJJkpozkEiSpOYMJJIkqTkDiSRJas5AIkmSmjOQNPTzn/+/1iVIkrRBMJBIkqTmDCSSJKk5A4kkSWrOQCJJkpozkEiSpOYMJJIkqTkDiSRJas5AIkmSmhvoQJJkbpJzxmisw5IcPxZjSZKkRxvoQCJJkiaG5oEkyd8k+W6S85OcluSYJHOSXJlkaZKzkmzV9R2p/fld2xVJjkuybCXzbJ7kpCTXJFmcZP8R6rkwySeSXJ5kWZLdV9Ln5CQH9e3f132fkeTiJEu6c188VvdJkqRB1jSQJBkCDgR2BV4LDHWHPg+8u6qeC1wP/O1q2j8HHFlVewCPjDDde4BvV9Xzgb2B45JsPkLfzatqT+DNwElrcEmHAudW1RxgF2DJGpwrSdKk1XqFZC/g36vqV1W1HPgqsDkwvaou6vqcArwkybQR2qcDU6vq8q79iyPMtS9wbJIlwIXApsAOI/Q9DaCqLga27OYYjWuANyV5H/Cc7poeJcn8JAuTLFy+/KFRDitJ0mBrHUiyHscIcGBVzem+dqiqG5N8rnvE8vW+vjXs3OH7D9PduyQBHgv/HWBeAtwO/EuSPx1eRFUtqKqhqhqaOnXjUZYuSdJgax1ILgVelWTTJFsA+wH3A3f1vX/xBuCiqrpnhPa7gOVJXti1HzLCXOcCb+kCBEl2BaiqN3UB5RV9fed1ffYC7unm7ncLsFu3vT+wcdf/qcBPquqzwD8Dz1uDeyFJ0qQ1peXkVXVNkrOB64BbgYXAPcAbgROSbAb8AHhTd8pI7UcAn01yP73HMcMDBMAHgE8AS7tQcgvwyhFKuyvJ5cCWwOErOf5Z4N+TXA18i16IApgLvDPJQ8B9wO+skEiSpN+VquFPI9ZzAckWVXVfFzIuBuZX1bVrM0a3fSwwo6reupb1XAgcU1UL1+b8NfG0p21ZN99873hPI0nSBiPJoqoaGt7edIWksyDJbHovmZ6ypmGks1+Sv6Z3PbcCh41hfZIkaZw1XyGZzFwhkSRNNiOtkLR+qVWSJMlAIkmS2jOQSJKk5gwkkiSpOQOJJElqzkAiSZKaM5A09PjH/17rEiRJ2iAYSCRJUnMGEkmS1JyBRJIkNWcgkSRJzRlIJElScwYSSZLU3JTWBUxmt991E+/58stblyFJj/Khg7/RugRNQq6QSJKk5gwkkiSpOQOJJElqzkAiSZKaM5BIkqTmDCSSJKk5A4kkSWrOQCJJkpozkEiSpOY22ECS5PK1PO+AJLPHuh5JkjR+NthAUlV7ruWpBwBjEkiSbDQW40iSpFXbYANJkvu673OTXJjkjCTfTXJqknTHPpLkhiRLk3wsyZ7Aq4HjkixJMivJnye5Jsl1Sc5Msll37qwkV3bH3j9svguSfBG4vmv7tySLknwnyfz+GpP8fXfsm0l272r9QZJXr+dbJknShDVRfrnersCzgR8DlwEvSnID8Bpgp6qqJNOr6u4kZwPnVNUZAEnurqrPdtsfBI4A/i/wSeCTVXVakiOHzbc7sHNV3dztH15Vv0jyOOCaJGdW1c+BzYELq+rdSc4CPgj8Ab0VmlOAs4dfSBdo5gNsuc2mY3R7JEma2DbYFZJhrq6q26rqN8ASYCZwL/AAcGKS1wK/HOHcnZNckuR64HX0gg3AHsCXu+0vrmS+m/v2j05yHXAl8BRgx679QWDFr8W8Hrioqh7qtmeurJiqWlBVQ1U1tNmWj131VUuSNElMlEDy677tR4ApVfUwvZWMM+m9NzLS78s+GTiqqp4D/B0wmmWJ+1dsJJkL7APsUVW7AIv7xnioqqrb/s2KOrvgNFFWnyRJam6iBJLfkWQLYFpVfR14GzCnO7QcmNrXdSpwR5KN6a2QrHAlcGC3fcgqppoG3FVVv0yyE/DCda9ekiT1m7CBhF7QOCfJUuAi4O1d+5eAdyZZnGQW8DfAVcD5wHf7zn8b8I4kVwMzgHtGmOcbwJRung/QCzKSJGkM5bdPHCaX7qdtftW9EHsI8CdVtf/6rGHGrGl1+Ef2WJ9TStJqfejgkZ6AS+suyaKqGhrePpnfc9gNOL77EeK7gcPbliNJ0uQ1aQNJVV0C7NK6DkmSNLHfIZEkSQPCQCJJkpozkEiSpOYMJJIkqTkDiSRJas5AIkmSmpu0P/a7Idh+qx39ACJJknCFRJIkbQAMJJIkqTkDiSRJas5AIkmSmjOQSJKk5gwkkiSpOX/st6Gb7r6dV/zb/2xdxqT39QM+3LoESZr0XCGRJEnNGUgkSVJzBhJJktScgUSSJDVnIJEkSc0ZSCRJUnMGEkmS1JyBRJIkNTcwgSTJfd33JyU5Y7T913KuW5Js021fvrbjSJKknoH7pNaq+jFw0Hqcb8/1NZckSYNqYFZIVkgyM8mybvuwJF9J8o0kNyX56Er6b5PkiiT7Jdk2yZlJrum+XtT1eXyS85IsTvIZIH3nr1iZmZvkwiRnJPluklOTZPh8kiTpdw1cIFmJOcA84DnAvCRPWXEgyXbA14D3VtXXgE8CH6+q5wMHAid2Xf8WuLSqdgXOBnYYYa5dgbcBs4GnAy8a64uRJGkQDdwjm5X4VlXdA5DkBuCpwI+AjYFvAX9ZVRd1ffcBZvctbGyZZCrwEuC1AFX1tSR3jTDX1VV1WzfXEmAmcGl/hyTzgfkAm2675RhcniRJE99kCCS/7tt+hN9e88PAIuAPgRWB5DHAHlX1q/4BuoBS6zDXf6uqBcACgGnPmDGaMSVJGniT4ZHNSAo4HNgpybFd23nAUSs6JJnTbV4MvK5r+yNgq/VXpiRJg28yBxKq6hHgEGDvJG8GjgaGkiztHu8c2XX9O+AlSa4F9gV+2KRgSZIGVKp8atDKtGfMqBd97E2ty5j0vn7Ah1uXIEmTRpJFVTU0vH1Sr5BIkqQNg4FEkiQ1ZyCRJEnNGUgkSVJzBhJJktScgUSSJDVnIJEkSc0ZSCRJUnOT4XfZbLB2nL69H8olSRKukEiSpA2AgUSSJDVnIJEkSc0ZSCRJUnMGEkmS1JyBRJIkNWcgaeimu37WugRJkjYIBhJJktScgUSSJDVnIJEkSc0ZSCRJUnMGEkmS1JyBRJIkNWcgkSRJzRlIJElScwYSSZLU3MAEkiQnJpm9mj4HrK7PGNQxJ8krxnMOSZIGzcAEkqr6s6q6YTXdDgDWKJAkmbKGpcwBDCSSJK2BCRdIksxM8t0kpyRZmuSMJJsluTDJUNfnviQfSnJdkiuTbJdkT+DVwHFJliSZ1X19I8miJJck2ak7/+Qk/5DkAuDvV9Hv4CTLunkuTvJY4P3AvG6OeY1ukyRJE8qa/t//huKZwBFVdVmSk4A3Dzu+OXBlVb0nyUeBP6+qDyY5Gzinqs4ASPIt4MiquinJC4BPAy/txvg9YJ+qemQV/d4L/GFV3Z5kelU9mOS9wFBVHbWywpPMB+YDbLrN1mN3RyRJmsAmaiD5UVVd1m1/ATh62PEHgXO67UXAHwwfIMkWwJ7Al5OsaN6kr8uXuzCyqn6XAScnOR34ymgKr6oFwAKAabNm1mjOkSRp0E3UQDL8H/Lh+w9V1Yq2R1j5dT4GuLuq5owwx/2r61dVR3YrJvsBS5KMNJYkSVqFCfcOSWeHJHt0238CXDrK85YDUwGq6l7g5iQHA6Rnl+EnrKpfkllVdVVVvRf4GfCU/jkkSdLoTNRAciPwxiRLga2BfxrleV8C3plkcZJZwOuAI5JcB3wH2H+E80bqd1yS65MsAy4GrgMuAGb7UqskSaOX3z7ZmBiSzKT3YurOrWtZV9Nmzax7/vOW1mVIkrTeJFlUVUPD2yfqCokkSRogE+6l1qq6BZjwqyOSJOm3XCGRJEnNGUgkSVJzBhJJktScgUSSJDVnIJEkSc0ZSCRJUnMGkoZ23Gqb1iVIkrRBMJBIkqTmDCSSJKk5A4kkSWrOQCJJkpozkEiSpOYMJA19/667edUZZ/GqM85qXYokSU0ZSCRJUnMGEkmS1JyBRJIkNWcgkSRJzRlIJElScwYSSZLUnIFEkiQ1ZyCRJEnNGUgkSVJzAx1IkkxP8uYxGmtuknNGOHZLkm3GYh5JkiajgQ4kwHRgTALJmkrPoN9fSZLGxKD/g/kRYFaSJUmu6V/hSHJ8ksO67VuSfDjJFUkWJnleknOT/GeSI/vG2zLJWUluSHLC8MCRZGaSG5N8GrgWeMp6uEZJkia8QQ8kxwL/WVVzgHeupu+PqmoP4BLgZOAg4IXA+/v67A78FfAcYBbw2pWM80zg81W1a1Xduk7VS5I0SQx6IFkTZ3ffrweuqqrlVfVT4IEk07tjV1fVD6rqEeA0YK+VjHNrVV050iRJ5nerMAsfvPfesaxfkqQJazIFkod59PVuOuz4r7vvv+nbXrE/pduuYecM3we4f1VFVNWCqhqqqqHHbrnlqiuWJGmSGPRAshyY2m3fCsxOskmSacDL1mK83ZM8rXt3ZB5w6RjVKUnSpDZl9V0mrqr6eZLLkiwD/gM4HVgK3AQsXoshr6D3ouxzgIuBs8aqVkmSJrOBDiQAVXXosKZ3raTPzL7tk+m91Dr82IXd18rmWNHnZ8DOa1WoJEmT2KA/spEkSROAgUSSJDVnIJEkSc0ZSCRJUnMGEkmS1JyBRJIkNWcgkSRJzRlIJElScwP/wWgbsmdsNZ2vHvSa1mVIktScKySSJKk5A4kkSWrOQCJJkpozkEiSpOYMJJIkqTkDiSRJas5A0tB/3nU/B555desyJElqzkAiSZKaM5BIkqTmDCSSJKk5A4kkSWrOQCJJkpozkEiSpOYMJJIkqTkDiSRJas5AIkmSmpvUgSTJk5Kc0boOSZImuymtC2ipqn4MHNS6DkmSJrtJs0KS5O+TvLlv/31J/irJsm7/sCT/luSrSW5OclSSdyRZnOTKJFt3/WYl+UaSRUkuSbJT1/7UJN9KsrT7vkObK5UkaeKZNIEE+BIwr2//j4FrhvXZGTgU2B34EPDLqtoVuAL4067PAuAtVbUbcAzw6a79eODzVfVc4FTgUysrIsn8JAuTLPz1vXev80VJkjQIJs0jm6panOQJSZ4EbAvcBfxwWLcLqmo5sDzJPcBXu/brgecm2QLYE/hykhXnbNJ93wN4bbf9L8BHR6hjAb1Qw1aznlXrfGGSJA2ASRNIOmfQe2fkifRWTIb7dd/2b/r2f0PvXj0GuLuq5oxiLsOGJEmjNJke2UAvhBxCL5Ss8U/XVNW9wM1JDgZIzy7d4cu7sQFeB1y67uVKkjQ5TKpAUlXfAaYCt1fVHWs5zOuAI5JcB3wH2L9rPxp4U5KlwBuAt65rvZIkTRap8slCK1vNela99KOncOaBu7cuRZKk9SLJoqoaGt4+qVZIJEnShslAIkmSmjOQSJKk5gwkkiSpOQOJJElqzkAiSZKaM5BIkqTmDCSSJKk5A0lDs7ba3A9FkyQJA4kkSdoAGEgkSVJzBhJJktScgUSSJDVnIJEkSc1NaV3AZHbn3Q/xD2f9V+syJoR3vOaJrUuQJI0jV0gkSVJzBhJJktScgUSSJDVnIJEkSc0ZSCRJUnMGEkmS1JyBRJIkNWcgkSRJzRlIJElScwaSTpK3JdlsFP1OTnLQ+qhJkqTJwkDyW28DVhtIJEnS2JvwgSTJB5K8tW//Q0nemuS4JMuSXJ9kXndsbpJz+voen+SwJEcDTwIuSHJBd+y+vn4HJTm5b9p9klyS5P8leWXXZ6NuzmuSLE3yP8b3yiVJGhwTPpAA/wy8ESDJY4BDgNuAOcAuwD7AcUlmjDRAVX0K+DGwd1XtPYo5ZwK/D+wHnJBkU+AI4J6qej7wfODPkzxtLa9JkqRJZcL/tt+quiXJz5PsCmwHLAb2Ak6rqkeAO5NcRC8k3DtG055eVb8BbkryA2AnYF/guX3vl0wDdgRu7j8xyXxgPsBW224/RuVIkjSxTfhA0jkROAx4InASvXCwMg/z6FWhTVcxZq2iX61kP8BbqurcVRVaVQuABQBPecYuw8eRJGlSGoRHNgBnAS+ntwpyLnAxMK97r2Nb4CXA1cCtwOwkmySZBrysb4zlwNS+/TuTPKt7DPSaYfMdnOQxSWYBTwe+1837F0k2Bkjye0k2H/MrlSRpAA3ECklVPdi9jHp3VT2S5CxgD+A6eqsX76qq/wJIcjqwFLiJ3uOdFRYA/5Hkju49kmOBc4AfAcuALfr6fg+4iN4joiOr6oEkJ9J7t+TaJAF+ChwwTpcsSdJASdXEf2rQrWJcCxxcVTe1rme0nvKMXertx63yCY8673jNE1uXIEkaA0kWVdXQ8PYJ/8gmyWzg+8C3JlIYkSRJvzXhH9lU1Q303uOQJEkT1IRfIZEkSROfgUSSJDVnIJEkSc0ZSCRJUnMGEkmS1JyBRJIkNTfhf+x3Ittu+sZ+4JckSbhCIkmSNgAGEkmS1JyBRJIkNWcgkSRJzRlIJElScwYSSZLUnD/229DyXzzMhV/4aesyJEn6HXNfv+16nc8VEkmS1JyBRJIkNWcgkSRJzRlIJElScwYSSZLUnIFEkiQ1ZyCRJEnNGUgkSVJzEy6QJDk6yY1JTh2j8S5MMjQG47wvyTFjUZMkSZPNRPyk1jcDf1RVN7cuRJIkjY0JtUKS5ATg6cDZSd6d5PIki7vvz+z6bJTkY0muT7I0yVu69t2SXJRkUZJzk8zoG/r13RjLkuze9d86yb91Y1yZ5Lmrah9W558n+Y8kjxv3myJJ0gCYUCskVXVkkpcDewMPAv+nqh5Osg/wYeBAYD7wNGDX7tjWSTYG/i+wf1X9NMk84EPA4d3Qm1fVnkleApwE7Az8HbC4qg5I8lLg88CcVbQDkOQoYF/ggKr69bjeEEmSBsSECiTDTANOSbIjUMDGXfs+wAlV9TBAVf0iyc70Qsb5SQA2Au7oG+u0ru/FSbZMMh3Yi17Aoaq+neTxSaatoh3gDcBt9MLIQysrOsl8eqGJ7R7/5HW/C5IkDYAJ9chmmA8AF1TVzsCrgE279tALKP0CfKeq5nRfz6mqffuOD+9f3TnDraodYBkwExgxaVTVgqoaqqqhaVs+fqRukiRNKhM5kEwDbu+2D+trPw84MskU6L3zAXwP2DbJHl3bxkme3XfOvK59L+CeqroHuBh4Xdc+F/hZVd27inaAxcD/oPeOy5PG7lIlSRpsEzmQfBT430kuo/cIZoUTgR8CS5NcBxxaVQ8CBwF/37UtAfbsO+euJJcDJwBHdG3vA4aSLAU+ArxxNe0AVNWlwDHA15JsMzaXKknSYEvV8KcVWl+e+fQ59Zn3n9+6DEmSfsfc1287LuMmWVRVv/P5XxN5hUSSJA0IA4kkSWrOQCJJkpozkEiSpOYMJJIkqTkDiSRJas5AIkmSmjOQSJKk5gwkkiSpuYn8234nvKlbTxm3T8KTJGkicYVEkiQ1ZyCRJEnNGUgkSVJzBhJJktScgUSSJDXnT9k09NB/PcQdH72jydwz3jWjybySJK2MKySSJKk5A4kkSWrOQCJJkpozkEiSpOYMJJIkqTkDiSRJas5AIkmSmjOQSJKk5gwkkiSpuQ06kCSZnuTNa9D/8u77zCSH9rXPSfKK8ahxhDpOTnLQ+ppPkqSJboMOJMB0YNSBpKr27DZnAof2HZoDrFEgSbJWH6ufZKO1OU+SpMlsQw8kHwFmJVmS5HNJXg2Q5KwkJ3XbRyT5YLd9X995L+7OezfwfmBetz8vyeZJTkpyTZLFSfbvzj8syZeTfBU4r7+QJHOTnNO3f3ySw7rtW5K8N8mlwMHjeUMkSRpEG/ov1zsW2Lmq5iQ5BHgxcDawPbDit8PtBXxpJecdU1WvBEhyJzBUVUd1+x8Gvl1VhyeZDlyd5JvduXsAz62qX6xhrQ9U1V7d+C9fw3MlSZrUNvQVkn6X0Fv1mA3cANyZZAa9AHH5Go61L3BskiXAhcCmwA7dsfPXIowA/OtoOiWZn2RhkoU/v//nazGNJEmDZ8IEkqq6HdgKeDlwMb2A8sfAfVW1fA2HC3BgVc3pvnaoqhu7Y/cDJHlB94hnSfeo6GEefb82HTbm/aO8jgVVNVRVQ4/f/PFrWLYkSYNpQw8ky4GpfftXAG/jt4HkmO776s4bvn8u8JYkAUiy6/ABquqqvsByNnArMDvJJkmmAS9b66uSJEmPskEHkqr6OXBZkmVJjqMXPqZU1feBa4GtWXkgWQo8nOS6JG8HLqAXJpYkmQd8ANgYWJpkWbe/ulp+BJzejX0qsHjdr1CSJAGkqlrXMGnt8uRd6htHf6PJ3DPeNWP1nSRJGmNJFlXV0PD2DXqFRJIkTQ4GEkmS1JyBRJIkNWcgkSRJzRlIJElScwYSSZLUnIFEkiQ1ZyCRJEnNbei/7XegbfzEjf2AMkmScIVEkiRtAAwkkiSpOQOJJElqzkAiSZKaM5BIkqTmDCSSJKk5f+y3oYd+ch93furS1mVoHWx39F6tS5CkgeAKiSRJas5AIkmSmjOQSJKk5gwkkiSpOQOJJElqzkAiSZKaM5BIkqTmDCSSJKm5poEkyfQkb16D/pd332cmObSvfU6SV4xHjZIkafy1XiGZDow6kFTVnt3mTODQvkNzgDUKJEnG/VNq18cckiQNgtaB5CPArCRLknwuyasBkpyV5KRu+4gkH+y27+s778Xdee8G3g/M6/bnJdk8yUlJrkmyOMn+3fmHJflykq8C5/UXkmRuknP69o9Pcli3/ZEkNyRZmuRjXdu2Sc7s5rgmyYu69vclWZDkPODz43XjJEkaJK3/D/5YYOeqmpPkEODFwNnA9sCMrs9ewJdWct4xVfVKgCR3AkNVdVS3/2Hg21V1eJLpwNVJvtmduwfw3Kr6xWgKTLI18Bpgp6qqbjyATwIfr6pLk+wAnAs8qzu2G7BXVf1qtDdCkqTJrHUg6XcJ8LYks4EbgK2SzKAXII5ew7H2BV6d5Jhuf1Ngh277/NGGkc69wAPAiUm+BqxYRdkHmJ1kRb8tk0ztts8eKYwkmQ/MB3jyVtutQRmSJA2uDSaQVNXtSbYCXg5cDGwN/DFwX1UtX8PhAhxYVd97VGPyAuD+vu3PdIfeC/yCRz/C2rSr6+EkuwMvAw4BjgJe2vXdY3jw6ALK/au4zgXAAoBddtip1vC6JEkaSK3fIVkOTO3bvwJ4G71AcglwTPd9decN3z8XeEu6dJBk1+EDVNVVVTWn+zobuJXeiscmSabRCyAk2QKYVlVf72qb0w1xHr1wQtdvDpIkaa00DSRV9XPgsiTLkhxHL3xMqarvA9fSWyVZWSBZCjyc5LokbwcuoBcmliSZB3wA2BhYmmRZt7+6Wn4EnN6NfSqwuDs0FTgnyVLgIuDtXfvRwFD3ousNwJFrcQskSRKQKp8atLLLDjvVecec2LoMrYPtjt6rdQmSNKEkWVRVQ8PbWz+ykSRJMpBIkqT2DCSSJKk5A4kkSWrOQCJJkpozkEiSpOYMJJIkqTkDiSRJam6D+V02k9HGT9jCD9aSJAlXSCRJ0gbAQCJJkpozkEiSpOb85XoNJVkOfK91HZPQNsDPWhcxyXjP2/C+r3/e89V7alVtO7zRl1rb+t7KfuOhxleShd739ct73ob3ff3znq89H9lIkqTmDCSSJKk5A0lbC1oXMEl539c/73kb3vf1z3u+lnypVZIkNecKiSRJas5A0kiSlyf5XpLvJzm2dT2DIslTklyQ5MYk30ny1q596yTnJ7mp+75V3zl/3f05fC/JH7arfmJLslGSxUnO6fa95+MsyfQkZyT5bvff/B7e9/GV5O3d3y3LkpyWZFPv+dgwkDSQZCPgH4E/AmYDf5JkdtuqBsbDwF9V1bOAFwJ/2d3bY4FvVdWOwLe6fbpjhwDPBl4OfLr789GaeytwY9++93z8fRL4RlXtBOxC7/5738dJku2Bo4GhqtoZ2IjePfWejwEDSRu7A9+vqh9U1YPAl4D9G9c0EKrqjqq6ttteTu8v6O3p3d9Tum6nAAd02/sDX6qqX1fVzcD36f35aA0keTKwH3BiX7P3fBwl2RJ4CfDPAFX1YFXdjfd9vE0BHpdkCrAZ8GO852PCQNLG9sCP+vZv69o0hpLMBHYFrgK2q6o7oBdagCd03fyzGBufAN4F/KavzXs+vp4O/BT4XPeo7MQkm+N9HzdVdTvwMeCHwB3APVV1Ht7zMWEgaSMrafPHncZQki2AM4G3VdW9q+q6kjb/LNZAklcCP6mqRaM9ZSVt3vM1NwV4HvBPVbUrcD/do4IReN/XUfduyP7A04AnAZsnef2qTllJm/d8BAaSNm4DntK3/2R6y34aA0k2phdGTq2qr3TNdyaZ0R2fAfyka/fPYt29CHh1klvoPX58aZIv4D0fb7cBt1XVVd3+GfQCivd9/OwD3FxVP62qh4CvAHviPR8TBpI2rgF2TPK0JI+l99LT2Y1rGghJQu+Z+o1V9Q99h84G3thtvxH49772Q5JskuRpwI7A1eur3kFQVX9dVU+uqpn0/lv+dlW9Hu/5uKqq/wJ+lOSZXdPLgBvwvo+nHwIvTLJZ93fNy+i9p+Y9HwP+cr0GqurhJEcB59J7S/ukqvpO47IGxYuANwDXJ1nStf1P4CPA6UmOoPeXysEAVfWdJKfT+4v8YeAvq+qR9V71YPKej7+3AKd2/2PzA+BN9P5H0/s+DqrqqiRnANfSu4eL6X0y6xZ4z9eZn9QqSZKa85GNJElqzkAiSZKaM5BIkqTmDCSSJKk5A4kkSWrOQCJJkpozkEiSpOYMJJIkqbn/D5OWDYZDH2yiAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 576x576 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Visual plot to show \n",
    "sns.barplot(y=orgs_social_df.count().index, x=orgs_social_df.count())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "website            891\n",
       "flickr              12\n",
       "google-calendar     77\n",
       "google-plus          1\n",
       "instagram          631\n",
       "linkedin           210\n",
       "pinterest            2\n",
       "tumblr               5\n",
       "vimeo                4\n",
       "youtube            159\n",
       "facebook           909\n",
       "twitter-url         66\n",
       "twitter-user       242\n",
       "dtype: int64"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "orgs_social_df.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:xlabel='start-date', ylabel='email'>"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAfEAAAHgCAYAAAC1uFRDAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAAw+0lEQVR4nO3deXhcd33v8c9Xs2i0e5dlOY4d4pBEtkmDWEtZYlISHsdJaRoCPKRwL81NLxSX9LalvTSJTei90DYlIUCa0hR4bstWaLBTCIvDUsrS2JDYFiG242y2ZXnXMtLMaGZ+949ZMjOakUbWjK2f+n49jx9pzjnzO99zzu+cz8yZnzXmnBMAAPBPw7kuAAAAnBlCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8FTwXBcwXYsWLXIrV64812UAAHDW7Ny587hzbnHpdO9CfOXKldqxY8e5LgMAgLPGzJ4tN53b6QAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxVtxA3swfM7KiZ7akw38zsHjPbb2a7zOzyetUCAMBcVM/vE/+spHslfb7C/Kslrc7+e4WkT2d/nhXptNOzJ6I6PDim4VhSy+Y1KRyQjo+MazSR0rzmkJa0NWppa0R9A0M6OhRXeySozvZGjY2nNRIfVyotjSaSWj6/ScmUU/9QTC3hoEIBUyTcoPGkdHw4rqUdjRpPOR0djqt7frPmNwd1+HRMne0RrVzYooYGy9eVTKbV1z+ogaGYFrY0KuWcmsMBxcZTisaTagwFNDyW1IKWsMyktJNORuNa2NKoUNDknDQSSyocbFA0kVRLOKjxpNPSeRGtmN+s50+N6vDgmEbiSS3raNR4Sjp0OqbueRE1mDQaT6uzI6JgQDo+nFDSpZVMOcXH0zp/QbMCAVP/YExdHRFFgik9dzKpgeG4OtsbtWJ+QKPjwQnblE47PXMiqoGh8ttcKLf9mXU0qaerXcFg7V9rJhIp7T48qNNjCbVFQjo1Oq75zSE1hxr0/KmYFreFtXxeow6dTmgwllBLOKST0YSWzcvUJEl9hwd1eDCmzvZGxcZTGool1doYVEckqHjK6dRoQvOaQhqJJ9UYalBLKCgzKZpIVdwPuX11KhpX2kknognNaw5pbDypoDWovSmkaCKp4VhSzaGAmhuDCkgaGI5rcVujAg2mkXgyc7wWtmjVosw6EomUdmW3d15TSMdGEmoNB9UeCSrQkFlPWyRTa2w8pZULWxQONqh/cOpjVlj3seGYGsx0enRc7c0hDY6Nqy0SVHMooCNDcXV3RDQ6ntLAUFxL2xu1pL2x6FyQpKePR/Xsiaiawg2a3xzS4FhKR7N9zCmldNq0tC2i8xe1TlrT2VTuenLp0tr33eGxmJ48EtWxkYTamzL7dWAkrtZwUAtaghqOpbS4rfLxSqednjsZ1UgsqeF4UiejCXV1RJRyTgODcS1pb9SS1pBWLGyr2b49PRbT3iNRDQxljmHXvIAOnkxO2a/Gxsb17OmohmIpDY6Nq6MppOMjcS1qbdT85oACDROvNZPJnfPHRuJqawwqHGpQPJlUJBhUbDyt0URSHc1hjSbGFW4IqDUS1EWLWtXUFJq03eGxmH6VOyaRoNoiQR0biWt+c1hruzoUDgemvc+mo24h7pz7oZmtnGSRayV93jnnJP3UzOaZWZdzrr9eNeWk006PPDmgfQMjunv7PsXG04qEGnT7NT267wf79eyJMUVCDdp8zaUKBBr0oQf35JfZtH61Vi5s1vOnxnTXd/ZqfnNY7/71lbrrO3uLllk2L6K7vrNXiaTTTa86v2g9d1zTo3/+2bPae3REd91wma7qWaqGBlMymdaDjx8qWt8H3niRWhoD+vt/P6C39q7QPY9k2jl/YZNuee2F2vxQX37ZzRt79KnvZ+p/Yf7P8/P/6vp16h+MTaj1m7v7dfXarqIaN2/skcnpRHS8aPqtV16khx4/rPvfuVY/3Dek27a+sP4tG3v02tXterjvSH6b0mmnh/uO6NYvP5ZfrnCbC5Xb/juvW6PrXtJd04thIpHS13cd1l98/YX1vP+K1frSjuf03tdfqJ8+dVzf6BvQh69do0efPqaVi9rz+z23H+PJtD704B7Nbw5POL6bN/boKzue0xUXLy16Xmn/Kt0PuX31wI+e0vUvXaE7tvUV1ffIr47ot1+6QpsLpm9av1ot4YA+/YMDCgdNt7zuwqL5d91wma5YvVhb9/Trk9/bp7e//Hz97XeLj//ClpDiSaeR+HDRdvz51Rfr0z84oFOjiYrHrLDujz78RFEfLdyvt7zuQi1tC6mvf0i3by3usw/v7tdPnj6pe9/+a4qPO/3RVx7L9/H3vv7Coj62eWOPtj/Rr96Vi7RqUVTrL+4850Fe6XpS6747PBbTw33HivrtpvWr9fmfPKtTowltWr9a3fMi+pOv7tKfXnXJhOOVqzMaG9fouJvQj3LtbNnYo8ODMb3ygsUz3renx2L69p5jum3rnqLrRINSevdnH63Yr8bGxrXz0EkdPpXQJ7+/b0K/2rJxjYZGR7VsQXvFflmo3Dl/65UXafm8Ju0+WdzvP/DGi/TP//msbnzZCj17clRXXrSkYpBXOiYLmkP68EO/1HvfsFrXrVtW1yA/l5+Jd0t6vuDxwey0unvmRFS7Dg7mD5wkxcbT2rytTxvWdecfHxqM5QMlN+3u7fuUSisfhG+5fHn+98JlnjoW1YZ13XrL5csnrOeObX16z2tfpNh4Wrd++TE9cyIqSerrH5ywvr/97l4dHY5rw7rufCeWpA3ruvMBnlv29q0v1F9u/r6jI2Vrfc9rXzShxtu39qk5HJow/a7v7NV7XvsiPXcylb+45ubdtrVPz51MFW3TMyei+QDPLVc4v1C57f/Qg3vU1z84o+NdatfhwfxJl1vPPY/s04Z13bpta5+uf9kKxcbT+ouv79F1l68o2u+5/Zirs9zxvX1rn2569QUTnlfav0r3Q25f3fTqC/IBXljfTa++IH/hzU2/e/s+HY8m9JbLl2eOecn8W7/8mHb3D+q2r+/RhnXd+QAvfH5zOKRjI/EJ2/GX3/yV3nL58kmPWWHdpX20cL9u3tan5sZwPsAL99W7XrNKsfG0dh0czAe4pPzxKF3+Ha9cpbu+s1e7Dw1WrOlsqnQ9qXXffeJIdEK/vXv7vvwxunv7Pu3PXnfKHa9cnYGGQNl+lGvntq19SqZVk32790g0H+C5dd22tU8rFrZP2q92HxlSwAK6beuesv3qtq17tO68RZP2y0Llzvm7vrNXaacJx+1vv7tXG9Z1Z/bn0RHtPjJUsd1Kx+TQYCzTf7++R7sO1/b6Vepchni5l06u7IJmN5vZDjPbcezYsRmveGAoprRTfsfnxMbTsoKqKi0TTSTz083KL5N2mXmV5o8lkvnfjw7HJEn9g7FJ2yqcV6ndXP3l5lfanrF4csrtLK19YLh8rbnpuW0aGCq/XG5+oUrbf2Rw4rIzcaRCTbl9dmIknp92YiQ+6X6c7PhO1b9K90NuX1U6HpXanKqvHRmKF21f6fxoIjnl+VDpmBXWPVmfzD2/3PzTo+OSJvbPSu2dHh3Pb3elms6mya4ntey7A0MT+2LpMSq8VpTum1yd0Qr9q7CdU6PjNdm3lWoeyLZdqV8NDMV1bHjyflt6rZlMpXN+sn2R258DQ/Fpb1/hcRgYqm8fPZchflDSeQWPl0s6XG5B59z9zrle51zv4sWLZ7zizvaIAiZFQsWbHwk1yBW8jKi0TEs4WDS93DINpnxb5eY3hYP535e0RSRJXR1NFduq1M5k9ZfOr7Q9zY3BqrYzv3w4qM72SNl5nW2Rom2qtFxufqFK27+0Y+KyM9FVoSbnMj8Xtjbmpy1sbZxyP1baR9Ucn8L9kNtXlY5HpTan6mtL21/YhkrHearzodIxK6y7Uvu5/bqkrfx+n9ecuVVZqYZyy+e2u1JNZ9Nk15Na9t3O9ol9sfQY5fpCueOVq7MlMnnfjIQyYxFqsW8r1dyZbbtSv+psb9Titsn7bem1ZjKVzvnJ9kVuf3a2N057+wqPQ2d7ffvouQzxrZJuyo5Sf6WkwbPxebgkrVzYorXLO7Rp/eqiTnL7NT16aNeh/ONlHRHded2aomU2rV+tQIN065UXKRJq0Fd3Hsz/XrjMixa36KFdh/TVnQcnrOeOa3r0mR8+lf/MMjegp6erfcL6PvDGi7SkrVHbHj+k91/xQjvbHj+k2zf0FC27eeML9Zebf+GS1rK1/v0Pn5pQ4+aNPRpNjE+YfuuVF+nvf/iUVswPaMvG4va3bOzRigWBom1aubBFd91wWdFyhfMLldv+O69bo56ujhkd71Jrl3Xow9cWr+f9V6zWQ7sOacvGHv3Lo88pEmrQh69dowd//lzRfs/tx1yd5Y7v5o09+tyPD0x4Xmn/Kt0PuX31uR8f0B3X9Eyo73M/PqDbS6ZvWr9ai1rC+trPD2aOecn8u264TGu7OrTl2jXa9vghfeCNE4//aGJci1obJ2zHn199sb7284OTHrPCukv7aOF+vf2aHo3GE9q8cWKf/eyPnlYk1KC1yzv0N7/zQl/Z9vihCX1s88Ye/dNPn9atV16ktd0dFWs6mypdT2rddy9Z2jKh325avzp/jDatX60Ls9edcscrV2cqlSrbj3LtbNnYo2CDarJvL1raoi0bi2vesrFHz50YmrRfrV3arpRLacvGNWX71ZaNa7Tr+eOT9sui9sqc87deeZEapAnH7QNvvEgP7TqU2Z9LWrV2aXvFdisdk+6OSOZ6cu0arVtW2+tXKXOu7B3smTds9gVJr5e0SNKApNslhSTJOXefmZkyo9evkjQq6d3OuR1Ttdvb2+t27JhysSkVjiYdiaXU1dGocNAqj04fzoxoXDphdHpK3fMjSqWcjgzF1RwOZEanhxo0npKOj8TV2daoZDo7On1ek+a3hNQ/GNOSMqNIXxidHteClrCcnJpC5UenNzRIqbR0MprQgpawGoOWuV0WSyoUbNBoIqnmcFDjKaelHcWj06PxlJZ2hJXMjU7viKihQRpNpNXZPnF0eiKZ1nnzmxUMmI4MxbS0ffqj048Ol9/mQrntPzIY09KOiHq6Ouo/Or0xpFNjxaPTF7WGdd78zOj0oVhCzbnR6R0R9WRPyr7Dg+ofimlJa6NiyZSGYym1NAbUHgkqUTA6PRrPHI/WcPWj009H40q5zLHtaA4pNp5SwEztTSGNJpIajqWK3kUfHUloYWtYoQbTcDypRDKtFQsmjk4fHEuoIxLS8WhCLeHMSNpgbnR6Y0gj2Vv2Kxc2Kxxs0JGhqY9ZYd3Hh2Oy3Oj0ppCGYuNqbQyqORzQwFBcy7Kj049mRyovaW8sOhekF0anR0INWtCSGZ1+bDiuJW2NcpZWKiUtbY9o5SwdnZ67nlxah76bH50ezYyEbg4FdHQkrpZwUPNbghqZ5uj0U6MJdbZFlJbTwFBcS1obtaQtqBUL22ff6PRISMejtRmd3toYVGOoQYnxlBpDAcWTaUXjKXU0hTSWyJyvLeGgXry4+tHpx0cSasuOTj8+Ete8prDWLqvd6HQz2+mc650wvV4hXi+1CnEAAHxRKcT5i20AAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPFXXEDezq8zsSTPbb2YfLDO/w8y2mdnjZtZnZu+uZz0AAMwldQtxMwtI+qSkqyVdKultZnZpyWLvlfRL59xLJL1e0t+YWbheNQEAMJfU8534yyXtd84dcM4lJH1R0rUlyzhJbWZmklolnZSUrGNNAADMGfUM8W5Jzxc8PpidVuheSZdIOixpt6RNzrl0HWsCAGDOqGeIW5lpruTxmyQ9JmmZpMsk3Wtm7RMaMrvZzHaY2Y5jx47Vuk4AALxUzxA/KOm8gsfLlXnHXejdkr7mMvZLelrSxaUNOefud871Oud6Fy9eXLeCAQDwST1D/FFJq81sVXaw2o2StpYs85yk9ZJkZp2SXizpQB1rAgBgzgjWq2HnXNLM3ifpW5ICkh5wzvWZ2S3Z+fdJ+rCkz5rZbmVuv/+pc+54vWoCAGAuqVuIS5Jz7huSvlEy7b6C3w9L+s161gAAwFzFX2wDAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4Km6hriZXWVmT5rZfjP7YIVlXm9mj5lZn5n9oJ71AAAwlwTr1bCZBSR9UtKVkg5KetTMtjrnflmwzDxJn5J0lXPuOTNbUq96AACYa+r5TvzlkvY75w445xKSvijp2pJl3i7pa8655yTJOXe0jvUAADCn1DPEuyU9X/D4YHZaoYskzTez75vZTjO7qY71AAAwp9TtdrokKzPNlVn/SyWtl9Qk6Sdm9lPn3N6ihsxulnSzJK1YsaIOpQIA4J96vhM/KOm8gsfLJR0us8zDzrmoc+64pB9KeklpQ865+51zvc653sWLF9etYAAAfFLPEH9U0mozW2VmYUk3StpasszXJf2GmQXNrFnSKyQ9UceaAACYM+p2O905lzSz90n6lqSApAecc31mdkt2/n3OuSfM7GFJuySlJX3GObenXjUBADCXmHOlH1PPbr29vW7Hjh3nugwAAM4aM9vpnOstnc5fbAMAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPBSebaWbbJLlK851zG2teEQAAqMqkIS7pr89KFQAAYNomDXHn3A/OViEAAGB6prqd/mXn3A1mtltlbqs759bVrTIAADCpqW6nb8r+3FDvQgAAwPRMdTu9P/vz2bNTDgAAqFZV/8XMzF5pZo+a2YiZJcwsZWZD9S4OAABUVu3/E79X0tsk7ZPUJOk9kj5Rr6IAAMDUpvpMPM85t9/MAs65lKR/NLMf17EuAAAwhWpDfNTMwpIeM7OPSeqX1FK/sgAAwFSqvZ3+TkkBSe+TFJV0nqTfrldRAABgalW9Ey8YnT4maXP9ygEAANWqdnT6BjP7hZmdNLMhMxtmdDoAAOdWtZ+Jf1zSWyTtds5V/EIUAABw9lT7mfjzkvYQ4AAAzB7VvhP/E0nfMLMfSIrnJjrn7qpLVQAAYErVhvhHJI1IikgK168cAABQrWpDfIFz7jfrWgkAAJiWaj8T/66ZEeIAAMwi1Yb4eyV908zG+C9mAADMDtXeTu+Q9A5Jq5xzW8xshaSu+pUFAACmUu078U9KeqUy32QmScPKfLMZAAA4R6p9J/4K59zlZvYLSXLOncp+IQoAADhHqn0nPm5mAUlOksxssaR03aoCAABTqjbE75H0r5KWmNlHJP1I0l/WrSoAADClar/F7J/MbKek9ZJM0nXOuSfqWhkAAJhUtZ+Jyzn3K0m/qmMtAABgGqq9nQ4AAGYZQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBTdQ1xM7vKzJ40s/1m9sFJlnuZmaXM7Pp61gMAwFxStxA3s4CkT0q6WtKlkt5mZpdWWO6jkr5Vr1oAAJiL6vlO/OWS9jvnDjjnEpK+KOnaMsv9gaSvSjpax1oAAJhz6hni3ZKeL3h8MDstz8y6Jf2WpPvqWAcAAHNSPUPcykxzJY8/LulPnXOpSRsyu9nMdpjZjmPHjtWqPgAAvBasY9sHJZ1X8Hi5pMMly/RK+qKZSdIiSW82s6Rz7sHChZxz90u6X5J6e3tLXwgAAPBfUj1D/FFJq81slaRDkm6U9PbCBZxzq3K/m9lnJT1UGuAAAKC8uoW4cy5pZu9TZtR5QNIDzrk+M7slO5/PwQEAmIF6vhOXc+4bkr5RMq1seDvn3lXPWgAAmGv4i20AAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPFXXEDezq8zsSTPbb2YfLDP/HWa2K/vvx2b2knrWAwDAXFK3EDezgKRPSrpa0qWS3mZml5Ys9rSk1znn1kn6sKT761UPAABzTT3fib9c0n7n3AHnXELSFyVdW7iAc+7HzrlT2Yc/lbS8jvUAADCn1DPEuyU9X/D4YHZaJf9d0jfrWA8AAHNKsI5tW5lpruyCZm9QJsRfU2H+zZJulqQVK1bUqj4AALxWz3fiByWdV/B4uaTDpQuZ2TpJn5F0rXPuRLmGnHP3O+d6nXO9ixcvrkuxAAD4pp4h/qik1Wa2yszCkm6UtLVwATNbIelrkt7pnNtbx1oAAJhz6nY73TmXNLP3SfqWpICkB5xzfWZ2S3b+fZJuk7RQ0qfMTJKSzrneetUEAMBcYs6V/Zh61urt7XU7duw412UAAHDWmNnOcm9y+YttAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxV1xA3s6vM7Ekz229mHywz38zsnuz8XWZ2eT3rAQBgLgnWq2EzC0j6pKQrJR2U9KiZbXXO/bJgsaslrc7+e4WkT2d/nhXptNMzJ6IaGIppSVtEgQapfzCmzvaIVsxv1nOnRjUwFFNzOKihWELhQECd7Y1asaBF6bRTX/+g+gdj6upo0rzmoA6fzjx35cIWScq3nZvW0GBl111ufqlkMq2+w4M6NDimRa2N6mxv1HnzM8+ZbltnWkOp02Mx7T0S1cBQPLNf5gc0MCz1dLUrGJzZ68OZ1lZNm4XHuPT4T7W+wraaw0ElUiktaG6cVhvV1nsiGlc40KDRRGrG7abTTs+dzByzaCKpVQuaNRxP6nC2H9fq2D1/KqqBwbhOjibU2daoRDqtRNIplkhpfktIi1rLn0el66+2H0x2bGvVf2ZST265ctOlya8V5dodHEso1NCgaCKpk9FxtUWCCodMC5sbtWpR65R9t6gPLGxR2klHh6dfU+H2dM+P6OhQQkeGYupqj2jtsg6FwwGNjiW058hw/jqxtD2s5fMnrzFf54kR9Q/FdWIkoe55ESVSaZ2Mjqt7XpMunUZfTSbTRf3sks42HR4a07GRuGLjaTmXVnMoqGMjCbVGgupoCuriJZn2q9kPsVhSfUeGdGwkruZwQPNbwrqkc+bnUjXqFuKSXi5pv3PugCSZ2RclXSupMMSvlfR555yT9FMzm2dmXc65/jrWJSnTQR7uO6Jbv/yYYuNpRUIN2rR+tT7/k2cVDpr+4IrV+tCDe/Lz3n/Fan1px3O68WUr9JLz2nX4dLxo/u3X9OgLP3tWe4+O6N63/5oSSVfU9l03XKarepbmT+TSdRfOL5VMpvXg44cmrG/ZvKh+/YLF+vYTA1W3Ndn2V/O8nNNjMX17zzHdtvWFmrZs7NHLV7XrwccP6bqXdJ9xB55pbdW2eed1a/SJR/bp2RNjRcf/1Ghi0vWVa6uwf1TTRrX1fvThJ/TW3hW655F9M94X6bTTI08OaN/AiO7evk/zm8O66VXn6+7t+4r2yUyP3b/vP6rDp+PavK1P85vD+v3XXaBoIlW0nj9+04t1SVfrhPOocP3V9oPS5c5f2DTh/J1p/ym3nmrryS33m5d0lj1Xw0HT+/75F1PWmmv3gR89pf/2mgs0HEvq9q19RdevtkhQB45Htf7izop9d6o+MNX1q9x2vmrVAl21tquoni3XrtHVPYv1zTLXiZWLYuo9f9GkL1b+fd9RHR58oR+daV8tvX6ev7BJf/SbL9bpaELRRErbnzii61+6Qnds+3nRvuwfjCmZkv7oK5Pvh1gsqYf6+ov626b1q/X08aje3NNV9yCvZ+vdkp4veHwwO226y9TFMyei+U4qSbHxtO7evk9vuXy5Nqzrzh+Q3Lx7HtmnDeu6dff2fUqmNGH+5m19es9rX6TYeFq7Dg5OaPvWLz+mZ05EK667cH6pvv7BsusbHkupr3/ydU1n+6t5Xs7eI9H8iZl7/m1b+3R0KKUPPbhHff2DVbVTj9qqbfNDD+7RhnXd+ce54z/V+sq1Vdg/qmmj2no3rOvOB3huXWfa7jMnotp1cDB/IXzL5cvzv+farsWxGx5LafO2vvw6jkcTE9bzV996sux5VLj+avtB6XLlzt+Z9p+Z1JNbrtK5uuvgYFW15tq96dUXKJ1WPjBzz7t7+z4dHY5r96HBSfvuVH1gqutXue1812tWTajntq/v0RMVrhOptE16PJ45EdVwrLgfnWlfLb1+bljXrf1HR/L98qZXX6A7tk3cl+NJlw/wyfbD7jLX57u379P+oyMzOpeqVc8QL/cSy53BMjKzm81sh5ntOHbsWE2KGxiK5Xd6Tmw8LTPJTBXnxcbTOhUdLzt/LJGUJKVd+ecfHY5Nuu7c/FL9g+WXjyaSFedVaitnujVMfH687PMHhjPtHhmsrp161DadNs3KP55sfZO1VW0b1dZbqS+eSbsDQ7Givlmp7Zkeu2g8WbSOSudDpfMot/5q+0HpcrXcZ5Otp9p6cstVOlfTJVe8SrXm2h2LJ4v2cWlbuVvjlbZhqj4w1fWr3HZWOpaVrhPHR+KTHo9y/ehM+2rpfs/1ydx2jlXYl9FE+emldR+psI1ppxmdS9WqZ4gflHRewePlkg6fwTJyzt3vnOt1zvUuXry4JsV1tkcUCRVvfiTUIOde+L3cvEioQfNbQmXnN4Uzn04ErPzzl7RFJl13bn6pro6mssu3hIMV51VqK2e6NUx8fmPZ53e2Zdpd2lFdO/WobTptOlf+8WTrm6ytatuYTr212hed7ZEJfbNc2zM9di2RYFG7lc6HSudRbv3V9oNKy031vOmaaT2VztXSO8qVas2129wYnLCPC9tqME3ad6fqA1Ndv8pt54IKx7LSdWJRa+Okx6NcPzrTvlpuvwfshe1sbiy/L1vC5aeX1r20wjY2mGZ0LlWrniH+qKTVZrbKzMKSbpS0tWSZrZJuyo5Sf6WkwbPxebgkrVzYortuuKzoQrlp/Wp97ecHte3xQ7rzujVF895/xWo9tOuQNq1frWBAE+bffk2PPvPDpxQJNWjt8o4Jbd91w2X5ASPl1l04v1RPV3vZ9bU1BdTT1T6ttibb/mqel3PR0hZt2Vhc05aNPVrSHtCd161RT1dHVe3Uo7Zq27zzujV6aNeh/OPc8Z9qfeXaKuwf1bRRbb3bHj+k91+xuib7YuXCFq1d3qFN6zPtfXXnwfzvubZrcezaIgHdfk1Pfh0LW8IT1vPHb3px2fOocP3V9oPS5cqdvzPtPzOpJ7dcpXN13fKOqmrNtfu5Hx9Qg0mbN/ZMuH4taWvU2u6OSfvuVH1gqutXue38xx89PaGeLdeu0SUVrhOBBjfp8Vi5sEVtjcX96Ez7aun1c9vjh/SiJa35fvm5Hx/QHddM3JehoOlvfmfq/bC2q2NCf9u0frUuXNI6o3OpWubchLvXtWvc7M2SPi4pIOkB59xHzOwWSXLO3WdmJuleSVdJGpX0bufcjsna7O3tdTt2TLpI1XIjK48Ox7S4NTM6+Uh2pHLR6PRQQMPxcYXKjE4/MhjT0vaI5rWE1D+YeW7h6M6jwy9MKzc6vdL8UkWj01sa1dkxcXR6tW2daQ2likantzVqxYKABoacepZ11Gx0+pnWVk2buWNc7vhPb3R6QOOptOZnR6dX20a19Z6MxhWqw+j00URS5y9o1kg887HM0o6Ierpqc+xyo9NPjSa0JDs6fTzpNFZhdPqRCuuvth9Mdmxr1X9mUk/p6PTC6dLk14py7Q6NJRTMjk4/NTqu1sagwkHTwpbpjU4fTSS1Mjs6/djI9Gsq3J5l8zKj03MjudeVG53e1qilHWcwOj2a0LKOiJKptE6OjqurPTKt60xudHqun13S2Z4fnR4fT8spraZgUMeiCbU2BtUeCeZHl1ezHyaMTm8O65KltR2dbmY7nXO9E6bXM8TroZYhDgCADyqFOH+xDQAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPOXd94mb2TFJz57jMhZJOn6Oa5gOn+ql1vqg1vqg1vqg1onOd84tLp3oXYjPBma2o9yXs89WPtVLrfVBrfVBrfVBrdXjdjoAAJ4ixAEA8BQhfmbuP9cFTJNP9VJrfVBrfVBrfVBrlfhMHAAAT/FOHAAATxHikszsPDP7npk9YWZ9ZrYpO32BmX3HzPZlf87PTl+YXX7EzO4taKfZzP7NzH6Vbef/zuZ6s/MeNrPHs+3cZ2aB2VprQZtbzWxPLeusda1m9n0ze9LMHsv+WzKLaw2b2f1mtjfbd397NtZqZm0F+/MxMztuZh+fjbVm573NzHab2a7sebZoFtf61mydfWb2sVrWeYa1XmlmO7P7b6eZXVHQ1kuz0/eb2T1mZrO41o+Y2fNmNlLLGos45/7L/5PUJeny7O9tkvZKulTSxyR9MDv9g5I+mv29RdJrJN0i6d6CdpolvSH7e1jSv0u6erbWm53Xnv1pkr4q6cbZWmt2/lsk/bOkPbN8v35fUu9s77PZeZsl3Zn9vUHSotlaa0m7OyW9djbWKiko6WhuX2aff8csrXWhpOckLc4+/pyk9ee41l+TtCz7+xpJhwra+k9Jr1LmmvVN1fgaW+NaX5ltb6SWNRbVW6+Gff4n6euSrpT0pKSuggP7ZMly75riInO3pN/zoV5JIUnbJL11ttYqqVXSj7InVM1DvMa1fl91DPEa1/q8pBYfai2Ytzpbt83GWrPn0zFJ5ysTNvdJunmW1voySd8tePxOSZ+aDbVmp5ukE5Ias8v8qmDe2yT93WystWR63UKc2+klzGylMq+sfiap0znXL0nZn1XfEjWzeZKukbS99lUWrWelZlivmX1LmXcNw5L+pT6V1qTWD0v6G0mj9aoxp0b94B+zt33/ota3/ArNpNZsP5WkD5vZz83sK2bWORtrLfE2SV9y2StkPcykVufcuKTfl7Rb0mFlXnj+w2ysVdJ+SReb2UozC0q6TtJ5s6jW35b0C+dcXFK3pIMF8w5mp83GWs8KQryAmbUqc0v5D51zQzNoJyjpC5Lucc4dqFV9ZdZTk3qdc29S5pVlo6Qrplj8jMy0VjO7TNKFzrl/rXVtZdZVi/36DufcWkm/kf33zlrVV6gGtQYlLZf0H865yyX9RNJf17DEvFr116wblTnH6qIG/TWkTIj/mqRlknZJ+rOaFvnCumZUq3PulDK1fkmZjwCfkZSsZY05063VzHokfVTS/8hNKrNYXV7I1aDWs4IQz8qedF+V9E/Oua9lJw+YWVd2fpcy71arcb+kfc65j9e80Kwa1yvnXEzSVknXztJaXyXppWb2jDK31C8ys+/P0lrlnDuU/TmszGf4L5+ltZ5Q5s5G7sXRVyRdPktrzbX1EklB59zOWtdZw1ovkyTn3FPZuwVflvTqWVqrnHPbnHOvcM69SpnbxvvOda1mtlyZfnmTc+6p7OSDyrzozFmuzJ2O2VjrWUGIS8re6vwHSU845+4qmLVV0u9mf/9dZT4bmaqtOyV1SPrDGpdZuI6a1GtmrQWdMijpzZJ+NRtrdc592jm3zDm3UpnBOXudc6+fjbWaWdCyI5GzF4MNkmo6mr6G+9UpMxbi9dlJ6yX9cjbWWuBtqtO78BrWekjSpWaW+8KKKyU9MUtrlWX/90R2xPX/lPSZc1lr9mOef5P0Z865/8gtnL2NPWxmr8y2eZOq7zdntdazpl4ftvv0T5lQcMrc8nos++/Nyoza3K7Mq9LtkhYUPOcZSScljSjz6vBSZV4VOmVO1lw775nF9XZKejTbTp+kTyjzDmfW1VrS5krVZ3R6rfZrizIjp3P79W5JgdlYa3b6+ZJ+mG1ru6QVs7XW7LwDki6u9fGvw369RZlrwS5lXigtnMW1fkGZF2+/VI3/h8qZ1CrpQ5KiBcs+JmlJdl6vMi+Kn5J0r2o8uLHGtX4su5/T2Z931Hrf8hfbAADwFLfTAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiwBxmZn9oZs1n8Lx3mdmyKpf9rJldX6v2AFSPEAfmtj9U5tv1qmaZr6N9lzJ/LrRWat0eABHiwJxhZi2W+T77x81sj5ndrkxwfs/Mvpdd5tNmtsMy35O8ueC5z5jZbWb2I2X+IlqvpH/KfoFLU8l6zMzuNbNfmtm/qeCLILJtPJpd//3ZZa8vbc8y3wn9A8t8//K3cn85EMD0EOLA3HGVpMPOuZc459ZI+rgyf1f6Dc65N2SX+d/OuV5J6yS9zszWFTw/5px7jXPu/0naocyXuFzmnBsrWc9vSXqxpLWSfk/FfxP8Xufcy7Lrb5K0wTn3L4XtKfPlGp+QdL1z7qWSHpD0kRrtA+C/FEIcmDt2S3qjmX3UzH7DOTdYZpkbzOznkn4hqUeZPxOb86Uq1/NaSV9wzqWcc4clPVIw7w1m9jMz263MN+L1lHn+iyWtkfQdM3tMmT9bubzMcgCmEDzXBQCoDefcXjN7qTJ/5/n/mNm3C+eb2SpJ/0vSy5xzp8zss5IiBYtEy7VrZq+Q9HfZh7flVldmuYikT0nqdc49b2Z3lLSfX1RSn8t8YxaAGeCdODBHZEd/j2Zvh/+1Ml8pOiypLbtIuzJBPWhmnZKunqS5/POccz/L3la/zDm3VZkvS7nRzALZz7Jzt+pzgX3cMt/FfH259pT5qsvFZvaqbN0hy3wXM4Bp4p04MHeslfRXZpaWNC7p95X5HvZvmlm/c+4NZvYLZb5Z7YCkyb428bOS7jOzMUmvKvlc/F+VuVW+W9JeST+QJOfcaTP7++z0Z5T5hryy7SkT8PeYWYcy16GPZ+sCMA18ixkAAJ7idjoAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU/8fil2Atf8H2Q8AAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 576x576 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Trying to see if the age of the club has any correlation to the club having an email or not\n",
    "# Results: No correlation\n",
    "sns.scatterplot(\n",
    "    x=new_orgs_df['start-date'],\n",
    "    y=new_orgs_df['email'].apply(lambda email: not pd.isna(email))\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Oldest club start: 2011-09-13\n",
      "Newest club start: 2021-02-12\n"
     ]
    }
   ],
   "source": [
    "valid_start_date_indices = new_orgs_df['start-date'].notnull()\n",
    "valid_start_dates = new_orgs_df['start-date'][valid_start_date_indices]\n",
    "\n",
    "print('Oldest club start:', min(valid_start_dates))\n",
    "print('Newest club start:', max(valid_start_dates))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:xlabel='start-date', ylabel='email'>"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAfEAAAHgCAYAAAC1uFRDAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAAw+0lEQVR4nO3deXhcd33v8c9Xs2i0e5dlOY4d4pBEtkmDWEtZYlISHsdJaRoCPKRwL81NLxSX9LalvTSJTei90DYlIUCa0hR4bstWaLBTCIvDUsrS2JDYFiG242y2ZXnXMtLMaGZ+949ZMjOakUbWjK2f+n49jx9pzjnzO99zzu+cz8yZnzXmnBMAAPBPw7kuAAAAnBlCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8FTwXBcwXYsWLXIrV64812UAAHDW7Ny587hzbnHpdO9CfOXKldqxY8e5LgMAgLPGzJ4tN53b6QAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxVtxA3swfM7KiZ7akw38zsHjPbb2a7zOzyetUCAMBcVM/vE/+spHslfb7C/Kslrc7+e4WkT2d/nhXptNOzJ6I6PDim4VhSy+Y1KRyQjo+MazSR0rzmkJa0NWppa0R9A0M6OhRXeySozvZGjY2nNRIfVyotjSaSWj6/ScmUU/9QTC3hoEIBUyTcoPGkdHw4rqUdjRpPOR0djqt7frPmNwd1+HRMne0RrVzYooYGy9eVTKbV1z+ogaGYFrY0KuWcmsMBxcZTisaTagwFNDyW1IKWsMyktJNORuNa2NKoUNDknDQSSyocbFA0kVRLOKjxpNPSeRGtmN+s50+N6vDgmEbiSS3raNR4Sjp0OqbueRE1mDQaT6uzI6JgQDo+nFDSpZVMOcXH0zp/QbMCAVP/YExdHRFFgik9dzKpgeG4OtsbtWJ+QKPjwQnblE47PXMiqoGh8ttcKLf9mXU0qaerXcFg7V9rJhIp7T48qNNjCbVFQjo1Oq75zSE1hxr0/KmYFreFtXxeow6dTmgwllBLOKST0YSWzcvUJEl9hwd1eDCmzvZGxcZTGool1doYVEckqHjK6dRoQvOaQhqJJ9UYalBLKCgzKZpIVdwPuX11KhpX2kknognNaw5pbDypoDWovSmkaCKp4VhSzaGAmhuDCkgaGI5rcVujAg2mkXgyc7wWtmjVosw6EomUdmW3d15TSMdGEmoNB9UeCSrQkFlPWyRTa2w8pZULWxQONqh/cOpjVlj3seGYGsx0enRc7c0hDY6Nqy0SVHMooCNDcXV3RDQ6ntLAUFxL2xu1pL2x6FyQpKePR/Xsiaiawg2a3xzS4FhKR7N9zCmldNq0tC2i8xe1TlrT2VTuenLp0tr33eGxmJ48EtWxkYTamzL7dWAkrtZwUAtaghqOpbS4rfLxSqednjsZ1UgsqeF4UiejCXV1RJRyTgODcS1pb9SS1pBWLGyr2b49PRbT3iNRDQxljmHXvIAOnkxO2a/Gxsb17OmohmIpDY6Nq6MppOMjcS1qbdT85oACDROvNZPJnfPHRuJqawwqHGpQPJlUJBhUbDyt0URSHc1hjSbGFW4IqDUS1EWLWtXUFJq03eGxmH6VOyaRoNoiQR0biWt+c1hruzoUDgemvc+mo24h7pz7oZmtnGSRayV93jnnJP3UzOaZWZdzrr9eNeWk006PPDmgfQMjunv7PsXG04qEGnT7NT267wf79eyJMUVCDdp8zaUKBBr0oQf35JfZtH61Vi5s1vOnxnTXd/ZqfnNY7/71lbrrO3uLllk2L6K7vrNXiaTTTa86v2g9d1zTo3/+2bPae3REd91wma7qWaqGBlMymdaDjx8qWt8H3niRWhoD+vt/P6C39q7QPY9k2jl/YZNuee2F2vxQX37ZzRt79KnvZ+p/Yf7P8/P/6vp16h+MTaj1m7v7dfXarqIaN2/skcnpRHS8aPqtV16khx4/rPvfuVY/3Dek27a+sP4tG3v02tXterjvSH6b0mmnh/uO6NYvP5ZfrnCbC5Xb/juvW6PrXtJd04thIpHS13cd1l98/YX1vP+K1frSjuf03tdfqJ8+dVzf6BvQh69do0efPqaVi9rz+z23H+PJtD704B7Nbw5POL6bN/boKzue0xUXLy16Xmn/Kt0PuX31wI+e0vUvXaE7tvUV1ffIr47ot1+6QpsLpm9av1ot4YA+/YMDCgdNt7zuwqL5d91wma5YvVhb9/Trk9/bp7e//Hz97XeLj//ClpDiSaeR+HDRdvz51Rfr0z84oFOjiYrHrLDujz78RFEfLdyvt7zuQi1tC6mvf0i3by3usw/v7tdPnj6pe9/+a4qPO/3RVx7L9/H3vv7Coj62eWOPtj/Rr96Vi7RqUVTrL+4850Fe6XpS6747PBbTw33HivrtpvWr9fmfPKtTowltWr9a3fMi+pOv7tKfXnXJhOOVqzMaG9fouJvQj3LtbNnYo8ODMb3ygsUz3renx2L69p5jum3rnqLrRINSevdnH63Yr8bGxrXz0EkdPpXQJ7+/b0K/2rJxjYZGR7VsQXvFflmo3Dl/65UXafm8Ju0+WdzvP/DGi/TP//msbnzZCj17clRXXrSkYpBXOiYLmkP68EO/1HvfsFrXrVtW1yA/l5+Jd0t6vuDxwey0unvmRFS7Dg7mD5wkxcbT2rytTxvWdecfHxqM5QMlN+3u7fuUSisfhG+5fHn+98JlnjoW1YZ13XrL5csnrOeObX16z2tfpNh4Wrd++TE9cyIqSerrH5ywvr/97l4dHY5rw7rufCeWpA3ruvMBnlv29q0v1F9u/r6jI2Vrfc9rXzShxtu39qk5HJow/a7v7NV7XvsiPXcylb+45ubdtrVPz51MFW3TMyei+QDPLVc4v1C57f/Qg3vU1z84o+NdatfhwfxJl1vPPY/s04Z13bpta5+uf9kKxcbT+ouv79F1l68o2u+5/Zirs9zxvX1rn2569QUTnlfav0r3Q25f3fTqC/IBXljfTa++IH/hzU2/e/s+HY8m9JbLl2eOecn8W7/8mHb3D+q2r+/RhnXd+QAvfH5zOKRjI/EJ2/GX3/yV3nL58kmPWWHdpX20cL9u3tan5sZwPsAL99W7XrNKsfG0dh0czAe4pPzxKF3+Ha9cpbu+s1e7Dw1WrOlsqnQ9qXXffeJIdEK/vXv7vvwxunv7Pu3PXnfKHa9cnYGGQNl+lGvntq19SqZVk32790g0H+C5dd22tU8rFrZP2q92HxlSwAK6beuesv3qtq17tO68RZP2y0Llzvm7vrNXaacJx+1vv7tXG9Z1Z/bn0RHtPjJUsd1Kx+TQYCzTf7++R7sO1/b6Vepchni5l06u7IJmN5vZDjPbcezYsRmveGAoprRTfsfnxMbTsoKqKi0TTSTz083KL5N2mXmV5o8lkvnfjw7HJEn9g7FJ2yqcV6ndXP3l5lfanrF4csrtLK19YLh8rbnpuW0aGCq/XG5+oUrbf2Rw4rIzcaRCTbl9dmIknp92YiQ+6X6c7PhO1b9K90NuX1U6HpXanKqvHRmKF21f6fxoIjnl+VDpmBXWPVmfzD2/3PzTo+OSJvbPSu2dHh3Pb3elms6mya4ntey7A0MT+2LpMSq8VpTum1yd0Qr9q7CdU6PjNdm3lWoeyLZdqV8NDMV1bHjyflt6rZlMpXN+sn2R258DQ/Fpb1/hcRgYqm8fPZchflDSeQWPl0s6XG5B59z9zrle51zv4sWLZ7zizvaIAiZFQsWbHwk1yBW8jKi0TEs4WDS93DINpnxb5eY3hYP535e0RSRJXR1NFduq1M5k9ZfOr7Q9zY3BqrYzv3w4qM72SNl5nW2Rom2qtFxufqFK27+0Y+KyM9FVoSbnMj8Xtjbmpy1sbZxyP1baR9Ucn8L9kNtXlY5HpTan6mtL21/YhkrHearzodIxK6y7Uvu5/bqkrfx+n9ecuVVZqYZyy+e2u1JNZ9Nk15Na9t3O9ol9sfQY5fpCueOVq7MlMnnfjIQyYxFqsW8r1dyZbbtSv+psb9Titsn7bem1ZjKVzvnJ9kVuf3a2N057+wqPQ2d7ffvouQzxrZJuyo5Sf6WkwbPxebgkrVzYorXLO7Rp/eqiTnL7NT16aNeh/ONlHRHded2aomU2rV+tQIN065UXKRJq0Fd3Hsz/XrjMixa36KFdh/TVnQcnrOeOa3r0mR8+lf/MMjegp6erfcL6PvDGi7SkrVHbHj+k91/xQjvbHj+k2zf0FC27eeML9Zebf+GS1rK1/v0Pn5pQ4+aNPRpNjE+YfuuVF+nvf/iUVswPaMvG4va3bOzRigWBom1aubBFd91wWdFyhfMLldv+O69bo56ujhkd71Jrl3Xow9cWr+f9V6zWQ7sOacvGHv3Lo88pEmrQh69dowd//lzRfs/tx1yd5Y7v5o09+tyPD0x4Xmn/Kt0PuX31uR8f0B3X9Eyo73M/PqDbS6ZvWr9ai1rC+trPD2aOecn8u264TGu7OrTl2jXa9vghfeCNE4//aGJci1obJ2zHn199sb7284OTHrPCukv7aOF+vf2aHo3GE9q8cWKf/eyPnlYk1KC1yzv0N7/zQl/Z9vihCX1s88Ye/dNPn9atV16ktd0dFWs6mypdT2rddy9Z2jKh325avzp/jDatX60Ls9edcscrV2cqlSrbj3LtbNnYo2CDarJvL1raoi0bi2vesrFHz50YmrRfrV3arpRLacvGNWX71ZaNa7Tr+eOT9sui9sqc87deeZEapAnH7QNvvEgP7TqU2Z9LWrV2aXvFdisdk+6OSOZ6cu0arVtW2+tXKXOu7B3smTds9gVJr5e0SNKApNslhSTJOXefmZkyo9evkjQq6d3OuR1Ttdvb2+t27JhysSkVjiYdiaXU1dGocNAqj04fzoxoXDphdHpK3fMjSqWcjgzF1RwOZEanhxo0npKOj8TV2daoZDo7On1ek+a3hNQ/GNOSMqNIXxidHteClrCcnJpC5UenNzRIqbR0MprQgpawGoOWuV0WSyoUbNBoIqnmcFDjKaelHcWj06PxlJZ2hJXMjU7viKihQRpNpNXZPnF0eiKZ1nnzmxUMmI4MxbS0ffqj048Ol9/mQrntPzIY09KOiHq6Ouo/Or0xpFNjxaPTF7WGdd78zOj0oVhCzbnR6R0R9WRPyr7Dg+ofimlJa6NiyZSGYym1NAbUHgkqUTA6PRrPHI/WcPWj009H40q5zLHtaA4pNp5SwEztTSGNJpIajqWK3kUfHUloYWtYoQbTcDypRDKtFQsmjk4fHEuoIxLS8WhCLeHMSNpgbnR6Y0gj2Vv2Kxc2Kxxs0JGhqY9ZYd3Hh2Oy3Oj0ppCGYuNqbQyqORzQwFBcy7Kj049mRyovaW8sOhekF0anR0INWtCSGZ1+bDiuJW2NcpZWKiUtbY9o5SwdnZ67nlxah76bH50ezYyEbg4FdHQkrpZwUPNbghqZ5uj0U6MJdbZFlJbTwFBcS1obtaQtqBUL22ff6PRISMejtRmd3toYVGOoQYnxlBpDAcWTaUXjKXU0hTSWyJyvLeGgXry4+tHpx0cSasuOTj8+Ete8prDWLqvd6HQz2+mc650wvV4hXi+1CnEAAHxRKcT5i20AAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPFXXEDezq8zsSTPbb2YfLDO/w8y2mdnjZtZnZu+uZz0AAMwldQtxMwtI+qSkqyVdKultZnZpyWLvlfRL59xLJL1e0t+YWbheNQEAMJfU8534yyXtd84dcM4lJH1R0rUlyzhJbWZmklolnZSUrGNNAADMGfUM8W5Jzxc8PpidVuheSZdIOixpt6RNzrl0HWsCAGDOqGeIW5lpruTxmyQ9JmmZpMsk3Wtm7RMaMrvZzHaY2Y5jx47Vuk4AALxUzxA/KOm8gsfLlXnHXejdkr7mMvZLelrSxaUNOefud871Oud6Fy9eXLeCAQDwST1D/FFJq81sVXaw2o2StpYs85yk9ZJkZp2SXizpQB1rAgBgzgjWq2HnXNLM3ifpW5ICkh5wzvWZ2S3Z+fdJ+rCkz5rZbmVuv/+pc+54vWoCAGAuqVuIS5Jz7huSvlEy7b6C3w9L+s161gAAwFzFX2wDAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4Km6hriZXWVmT5rZfjP7YIVlXm9mj5lZn5n9oJ71AAAwlwTr1bCZBSR9UtKVkg5KetTMtjrnflmwzDxJn5J0lXPuOTNbUq96AACYa+r5TvzlkvY75w445xKSvijp2pJl3i7pa8655yTJOXe0jvUAADCn1DPEuyU9X/D4YHZaoYskzTez75vZTjO7qY71AAAwp9TtdrokKzPNlVn/SyWtl9Qk6Sdm9lPn3N6ihsxulnSzJK1YsaIOpQIA4J96vhM/KOm8gsfLJR0us8zDzrmoc+64pB9KeklpQ865+51zvc653sWLF9etYAAAfFLPEH9U0mozW2VmYUk3StpasszXJf2GmQXNrFnSKyQ9UceaAACYM+p2O905lzSz90n6lqSApAecc31mdkt2/n3OuSfM7GFJuySlJX3GObenXjUBADCXmHOlH1PPbr29vW7Hjh3nugwAAM4aM9vpnOstnc5fbAMAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPBSebaWbbJLlK851zG2teEQAAqMqkIS7pr89KFQAAYNomDXHn3A/OViEAAGB6prqd/mXn3A1mtltlbqs759bVrTIAADCpqW6nb8r+3FDvQgAAwPRMdTu9P/vz2bNTDgAAqFZV/8XMzF5pZo+a2YiZJcwsZWZD9S4OAABUVu3/E79X0tsk7ZPUJOk9kj5Rr6IAAMDUpvpMPM85t9/MAs65lKR/NLMf17EuAAAwhWpDfNTMwpIeM7OPSeqX1FK/sgAAwFSqvZ3+TkkBSe+TFJV0nqTfrldRAABgalW9Ey8YnT4maXP9ygEAANWqdnT6BjP7hZmdNLMhMxtmdDoAAOdWtZ+Jf1zSWyTtds5V/EIUAABw9lT7mfjzkvYQ4AAAzB7VvhP/E0nfMLMfSIrnJjrn7qpLVQAAYErVhvhHJI1IikgK168cAABQrWpDfIFz7jfrWgkAAJiWaj8T/66ZEeIAAMwi1Yb4eyV908zG+C9mAADMDtXeTu+Q9A5Jq5xzW8xshaSu+pUFAACmUu078U9KeqUy32QmScPKfLMZAAA4R6p9J/4K59zlZvYLSXLOncp+IQoAADhHqn0nPm5mAUlOksxssaR03aoCAABTqjbE75H0r5KWmNlHJP1I0l/WrSoAADClar/F7J/MbKek9ZJM0nXOuSfqWhkAAJhUtZ+Jyzn3K0m/qmMtAABgGqq9nQ4AAGYZQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBTdQ1xM7vKzJ40s/1m9sFJlnuZmaXM7Pp61gMAwFxStxA3s4CkT0q6WtKlkt5mZpdWWO6jkr5Vr1oAAJiL6vlO/OWS9jvnDjjnEpK+KOnaMsv9gaSvSjpax1oAAJhz6hni3ZKeL3h8MDstz8y6Jf2WpPvqWAcAAHNSPUPcykxzJY8/LulPnXOpSRsyu9nMdpjZjmPHjtWqPgAAvBasY9sHJZ1X8Hi5pMMly/RK+qKZSdIiSW82s6Rz7sHChZxz90u6X5J6e3tLXwgAAPBfUj1D/FFJq81slaRDkm6U9PbCBZxzq3K/m9lnJT1UGuAAAKC8uoW4cy5pZu9TZtR5QNIDzrk+M7slO5/PwQEAmIF6vhOXc+4bkr5RMq1seDvn3lXPWgAAmGv4i20AAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPFXXEDezq8zsSTPbb2YfLDP/HWa2K/vvx2b2knrWAwDAXFK3EDezgKRPSrpa0qWS3mZml5Ys9rSk1znn1kn6sKT761UPAABzTT3fib9c0n7n3AHnXELSFyVdW7iAc+7HzrlT2Yc/lbS8jvUAADCn1DPEuyU9X/D4YHZaJf9d0jfrWA8AAHNKsI5tW5lpruyCZm9QJsRfU2H+zZJulqQVK1bUqj4AALxWz3fiByWdV/B4uaTDpQuZ2TpJn5F0rXPuRLmGnHP3O+d6nXO9ixcvrkuxAAD4pp4h/qik1Wa2yszCkm6UtLVwATNbIelrkt7pnNtbx1oAAJhz6nY73TmXNLP3SfqWpICkB5xzfWZ2S3b+fZJuk7RQ0qfMTJKSzrneetUEAMBcYs6V/Zh61urt7XU7duw412UAAHDWmNnOcm9y+YttAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPEWIAwDgKUIcAABPEeIAAHiKEAcAwFOEOAAAniLEAQDwFCEOAICnCHEAADxV1xA3s6vM7Ekz229mHywz38zsnuz8XWZ2eT3rAQBgLgnWq2EzC0j6pKQrJR2U9KiZbXXO/bJgsaslrc7+e4WkT2d/nhXptNMzJ6IaGIppSVtEgQapfzCmzvaIVsxv1nOnRjUwFFNzOKihWELhQECd7Y1asaBF6bRTX/+g+gdj6upo0rzmoA6fzjx35cIWScq3nZvW0GBl111ufqlkMq2+w4M6NDimRa2N6mxv1HnzM8+ZbltnWkOp02Mx7T0S1cBQPLNf5gc0MCz1dLUrGJzZ68OZ1lZNm4XHuPT4T7W+wraaw0ElUiktaG6cVhvV1nsiGlc40KDRRGrG7abTTs+dzByzaCKpVQuaNRxP6nC2H9fq2D1/KqqBwbhOjibU2daoRDqtRNIplkhpfktIi1rLn0el66+2H0x2bGvVf2ZST265ctOlya8V5dodHEso1NCgaCKpk9FxtUWCCodMC5sbtWpR65R9t6gPLGxR2klHh6dfU+H2dM+P6OhQQkeGYupqj2jtsg6FwwGNjiW058hw/jqxtD2s5fMnrzFf54kR9Q/FdWIkoe55ESVSaZ2Mjqt7XpMunUZfTSbTRf3sks42HR4a07GRuGLjaTmXVnMoqGMjCbVGgupoCuriJZn2q9kPsVhSfUeGdGwkruZwQPNbwrqkc+bnUjXqFuKSXi5pv3PugCSZ2RclXSupMMSvlfR555yT9FMzm2dmXc65/jrWJSnTQR7uO6Jbv/yYYuNpRUIN2rR+tT7/k2cVDpr+4IrV+tCDe/Lz3n/Fan1px3O68WUr9JLz2nX4dLxo/u3X9OgLP3tWe4+O6N63/5oSSVfU9l03XKarepbmT+TSdRfOL5VMpvXg44cmrG/ZvKh+/YLF+vYTA1W3Ndn2V/O8nNNjMX17zzHdtvWFmrZs7NHLV7XrwccP6bqXdJ9xB55pbdW2eed1a/SJR/bp2RNjRcf/1Ghi0vWVa6uwf1TTRrX1fvThJ/TW3hW655F9M94X6bTTI08OaN/AiO7evk/zm8O66VXn6+7t+4r2yUyP3b/vP6rDp+PavK1P85vD+v3XXaBoIlW0nj9+04t1SVfrhPOocP3V9oPS5c5f2DTh/J1p/ym3nmrryS33m5d0lj1Xw0HT+/75F1PWmmv3gR89pf/2mgs0HEvq9q19RdevtkhQB45Htf7izop9d6o+MNX1q9x2vmrVAl21tquoni3XrtHVPYv1zTLXiZWLYuo9f9GkL1b+fd9RHR58oR+daV8tvX6ev7BJf/SbL9bpaELRRErbnzii61+6Qnds+3nRvuwfjCmZkv7oK5Pvh1gsqYf6+ov626b1q/X08aje3NNV9yCvZ+vdkp4veHwwO226y9TFMyei+U4qSbHxtO7evk9vuXy5Nqzrzh+Q3Lx7HtmnDeu6dff2fUqmNGH+5m19es9rX6TYeFq7Dg5OaPvWLz+mZ05EK667cH6pvv7BsusbHkupr3/ydU1n+6t5Xs7eI9H8iZl7/m1b+3R0KKUPPbhHff2DVbVTj9qqbfNDD+7RhnXd+ce54z/V+sq1Vdg/qmmj2no3rOvOB3huXWfa7jMnotp1cDB/IXzL5cvzv+farsWxGx5LafO2vvw6jkcTE9bzV996sux5VLj+avtB6XLlzt+Z9p+Z1JNbrtK5uuvgYFW15tq96dUXKJ1WPjBzz7t7+z4dHY5r96HBSfvuVH1gqutXue1812tWTajntq/v0RMVrhOptE16PJ45EdVwrLgfnWlfLb1+bljXrf1HR/L98qZXX6A7tk3cl+NJlw/wyfbD7jLX57u379P+oyMzOpeqVc8QL/cSy53BMjKzm81sh5ntOHbsWE2KGxiK5Xd6Tmw8LTPJTBXnxcbTOhUdLzt/LJGUJKVd+ecfHY5Nuu7c/FL9g+WXjyaSFedVaitnujVMfH687PMHhjPtHhmsrp161DadNs3KP55sfZO1VW0b1dZbqS+eSbsDQ7Givlmp7Zkeu2g8WbSOSudDpfMot/5q+0HpcrXcZ5Otp9p6cstVOlfTJVe8SrXm2h2LJ4v2cWlbuVvjlbZhqj4w1fWr3HZWOpaVrhPHR+KTHo9y/ehM+2rpfs/1ydx2jlXYl9FE+emldR+psI1ppxmdS9WqZ4gflHRewePlkg6fwTJyzt3vnOt1zvUuXry4JsV1tkcUCRVvfiTUIOde+L3cvEioQfNbQmXnN4Uzn04ErPzzl7RFJl13bn6pro6mssu3hIMV51VqK2e6NUx8fmPZ53e2Zdpd2lFdO/WobTptOlf+8WTrm6ytatuYTr212hed7ZEJfbNc2zM9di2RYFG7lc6HSudRbv3V9oNKy031vOmaaT2VztXSO8qVas2129wYnLCPC9tqME3ad6fqA1Ndv8pt54IKx7LSdWJRa+Okx6NcPzrTvlpuvwfshe1sbiy/L1vC5aeX1r20wjY2mGZ0LlWrniH+qKTVZrbKzMKSbpS0tWSZrZJuyo5Sf6WkwbPxebgkrVzYortuuKzoQrlp/Wp97ecHte3xQ7rzujVF895/xWo9tOuQNq1frWBAE+bffk2PPvPDpxQJNWjt8o4Jbd91w2X5ASPl1l04v1RPV3vZ9bU1BdTT1T6ttibb/mqel3PR0hZt2Vhc05aNPVrSHtCd161RT1dHVe3Uo7Zq27zzujV6aNeh/OPc8Z9qfeXaKuwf1bRRbb3bHj+k91+xuib7YuXCFq1d3qFN6zPtfXXnwfzvubZrcezaIgHdfk1Pfh0LW8IT1vPHb3px2fOocP3V9oPS5cqdvzPtPzOpJ7dcpXN13fKOqmrNtfu5Hx9Qg0mbN/ZMuH4taWvU2u6OSfvuVH1gqutXue38xx89PaGeLdeu0SUVrhOBBjfp8Vi5sEVtjcX96Ez7aun1c9vjh/SiJa35fvm5Hx/QHddM3JehoOlvfmfq/bC2q2NCf9u0frUuXNI6o3OpWubchLvXtWvc7M2SPi4pIOkB59xHzOwWSXLO3WdmJuleSVdJGpX0bufcjsna7O3tdTt2TLpI1XIjK48Ox7S4NTM6+Uh2pHLR6PRQQMPxcYXKjE4/MhjT0vaI5rWE1D+YeW7h6M6jwy9MKzc6vdL8UkWj01sa1dkxcXR6tW2daQ2likantzVqxYKABoacepZ11Gx0+pnWVk2buWNc7vhPb3R6QOOptOZnR6dX20a19Z6MxhWqw+j00URS5y9o1kg887HM0o6Ierpqc+xyo9NPjSa0JDs6fTzpNFZhdPqRCuuvth9Mdmxr1X9mUk/p6PTC6dLk14py7Q6NJRTMjk4/NTqu1sagwkHTwpbpjU4fTSS1Mjs6/djI9Gsq3J5l8zKj03MjudeVG53e1qilHWcwOj2a0LKOiJKptE6OjqurPTKt60xudHqun13S2Z4fnR4fT8spraZgUMeiCbU2BtUeCeZHl1ezHyaMTm8O65KltR2dbmY7nXO9E6bXM8TroZYhDgCADyqFOH+xDQAATxHiAAB4ihAHAMBThDgAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU4Q4AACeIsQBAPAUIQ4AgKcIcQAAPOXd94mb2TFJz57jMhZJOn6Oa5gOn+ql1vqg1vqg1vqg1onOd84tLp3oXYjPBma2o9yXs89WPtVLrfVBrfVBrfVBrdXjdjoAAJ4ixAEA8BQhfmbuP9cFTJNP9VJrfVBrfVBrfVBrlfhMHAAAT/FOHAAATxHikszsPDP7npk9YWZ9ZrYpO32BmX3HzPZlf87PTl+YXX7EzO4taKfZzP7NzH6Vbef/zuZ6s/MeNrPHs+3cZ2aB2VprQZtbzWxPLeusda1m9n0ze9LMHsv+WzKLaw2b2f1mtjfbd397NtZqZm0F+/MxMztuZh+fjbVm573NzHab2a7sebZoFtf61mydfWb2sVrWeYa1XmlmO7P7b6eZXVHQ1kuz0/eb2T1mZrO41o+Y2fNmNlLLGos45/7L/5PUJeny7O9tkvZKulTSxyR9MDv9g5I+mv29RdJrJN0i6d6CdpolvSH7e1jSv0u6erbWm53Xnv1pkr4q6cbZWmt2/lsk/bOkPbN8v35fUu9s77PZeZsl3Zn9vUHSotlaa0m7OyW9djbWKiko6WhuX2aff8csrXWhpOckLc4+/pyk9ee41l+TtCz7+xpJhwra+k9Jr1LmmvVN1fgaW+NaX5ltb6SWNRbVW6+Gff4n6euSrpT0pKSuggP7ZMly75riInO3pN/zoV5JIUnbJL11ttYqqVXSj7InVM1DvMa1fl91DPEa1/q8pBYfai2Ytzpbt83GWrPn0zFJ5ysTNvdJunmW1voySd8tePxOSZ+aDbVmp5ukE5Ias8v8qmDe2yT93WystWR63UKc2+klzGylMq+sfiap0znXL0nZn1XfEjWzeZKukbS99lUWrWelZlivmX1LmXcNw5L+pT6V1qTWD0v6G0mj9aoxp0b94B+zt33/ota3/ArNpNZsP5WkD5vZz83sK2bWORtrLfE2SV9y2StkPcykVufcuKTfl7Rb0mFlXnj+w2ysVdJ+SReb2UozC0q6TtJ5s6jW35b0C+dcXFK3pIMF8w5mp83GWs8KQryAmbUqc0v5D51zQzNoJyjpC5Lucc4dqFV9ZdZTk3qdc29S5pVlo6Qrplj8jMy0VjO7TNKFzrl/rXVtZdZVi/36DufcWkm/kf33zlrVV6gGtQYlLZf0H865yyX9RNJf17DEvFr116wblTnH6qIG/TWkTIj/mqRlknZJ+rOaFvnCumZUq3PulDK1fkmZjwCfkZSsZY05063VzHokfVTS/8hNKrNYXV7I1aDWs4IQz8qedF+V9E/Oua9lJw+YWVd2fpcy71arcb+kfc65j9e80Kwa1yvnXEzSVknXztJaXyXppWb2jDK31C8ys+/P0lrlnDuU/TmszGf4L5+ltZ5Q5s5G7sXRVyRdPktrzbX1EklB59zOWtdZw1ovkyTn3FPZuwVflvTqWVqrnHPbnHOvcM69SpnbxvvOda1mtlyZfnmTc+6p7OSDyrzozFmuzJ2O2VjrWUGIS8re6vwHSU845+4qmLVV0u9mf/9dZT4bmaqtOyV1SPrDGpdZuI6a1GtmrQWdMijpzZJ+NRtrdc592jm3zDm3UpnBOXudc6+fjbWaWdCyI5GzF4MNkmo6mr6G+9UpMxbi9dlJ6yX9cjbWWuBtqtO78BrWekjSpWaW+8KKKyU9MUtrlWX/90R2xPX/lPSZc1lr9mOef5P0Z865/8gtnL2NPWxmr8y2eZOq7zdntdazpl4ftvv0T5lQcMrc8nos++/Nyoza3K7Mq9LtkhYUPOcZSScljSjz6vBSZV4VOmVO1lw775nF9XZKejTbTp+kTyjzDmfW1VrS5krVZ3R6rfZrizIjp3P79W5JgdlYa3b6+ZJ+mG1ru6QVs7XW7LwDki6u9fGvw369RZlrwS5lXigtnMW1fkGZF2+/VI3/h8qZ1CrpQ5KiBcs+JmlJdl6vMi+Kn5J0r2o8uLHGtX4su5/T2Z931Hrf8hfbAADwFLfTAQDwFCEOAICnCHEAADxFiAMA4ClCHAAATxHiwBxmZn9oZs1n8Lx3mdmyKpf9rJldX6v2AFSPEAfmtj9U5tv1qmaZr6N9lzJ/LrRWat0eABHiwJxhZi2W+T77x81sj5ndrkxwfs/Mvpdd5tNmtsMy35O8ueC5z5jZbWb2I2X+IlqvpH/KfoFLU8l6zMzuNbNfmtm/qeCLILJtPJpd//3ZZa8vbc8y3wn9A8t8//K3cn85EMD0EOLA3HGVpMPOuZc459ZI+rgyf1f6Dc65N2SX+d/OuV5J6yS9zszWFTw/5px7jXPu/0naocyXuFzmnBsrWc9vSXqxpLWSfk/FfxP8Xufcy7Lrb5K0wTn3L4XtKfPlGp+QdL1z7qWSHpD0kRrtA+C/FEIcmDt2S3qjmX3UzH7DOTdYZpkbzOznkn4hqUeZPxOb86Uq1/NaSV9wzqWcc4clPVIw7w1m9jMz263MN+L1lHn+iyWtkfQdM3tMmT9bubzMcgCmEDzXBQCoDefcXjN7qTJ/5/n/mNm3C+eb2SpJ/0vSy5xzp8zss5IiBYtEy7VrZq+Q9HfZh7flVldmuYikT0nqdc49b2Z3lLSfX1RSn8t8YxaAGeCdODBHZEd/j2Zvh/+1Ml8pOiypLbtIuzJBPWhmnZKunqS5/POccz/L3la/zDm3VZkvS7nRzALZz7Jzt+pzgX3cMt/FfH259pT5qsvFZvaqbN0hy3wXM4Bp4p04MHeslfRXZpaWNC7p95X5HvZvmlm/c+4NZvYLZb5Z7YCkyb428bOS7jOzMUmvKvlc/F+VuVW+W9JeST+QJOfcaTP7++z0Z5T5hryy7SkT8PeYWYcy16GPZ+sCMA18ixkAAJ7idjoAAJ4ixAEA8BQhDgCApwhxAAA8RYgDAOApQhwAAE8R4gAAeIoQBwDAU/8fil2Atf8H2Q8AAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 576x576 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Trying to see if the age of the club has any correlation to the club having an email or not\n",
    "# Results: No correlation\n",
    "sns.scatterplot(\n",
    "    x=new_orgs_df['start-date'][valid_start_date_indices],\n",
    "    y=new_orgs_df['email'].apply(lambda email: not pd.isna(email))\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Save all this data into a massive JSON file\n",
    "\n",
    "from datetime import datetime, date\n",
    "\n",
    "OUTPUT_FOLDER = 'exported'\n",
    "os.makedirs(OUTPUT_FOLDER, exist_ok=True)\n",
    "\n",
    "OUTPUT_ORG_INFO_FILE = f'{OUTPUT_FOLDER}/org-info.json'\n",
    "\n",
    "# Allows handling of datetimes\n",
    "def json_serial(obj):\n",
    "    \"\"\"JSON serializer for objects not serializable by default json code\"\"\"\n",
    "\n",
    "    if isinstance(obj, (datetime, date)):\n",
    "        return obj.isoformat()\n",
    "    raise TypeError (\"Type %s not serializable\" % type(obj))\n",
    "\n",
    "\n",
    "with open(OUTPUT_ORG_INFO_FILE, 'w') as fp:\n",
    "    json.dump(processed_org_data, fp, default=json_serial)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1182\n"
     ]
    }
   ],
   "source": [
    "OUTPUT_ORG_EMAILS = 'exported/org-emails.json'\n",
    "\n",
    "all_club_emails = [org['email'].lower() for org in processed_org_data if org['email'] is not None]\n",
    "print(len(all_club_emails))\n",
    "with open(OUTPUT_ORG_EMAILS, 'w') as fp:\n",
    "    json.dump(all_club_emails, fp, default=json_serial)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['recruitment.berkeley@180dc.org',\n",
       " '3dma.at.berkeley@gmail.com',\n",
       " '3dmc.berkeley@gmail.com',\n",
       " 'fiveandtwo.berkeley@gmail.com',\n",
       " 'officers@abetterway.berkeley.edu',\n",
       " 'seanhkim@berkeley.edu',\n",
       " 'abbamodern@gmail.com',\n",
       " 'abcsketches@gmail.com',\n",
       " 'cal5@acacia.org',\n",
       " 'acecoaches@berkeley.edu',\n",
       " 'achievementim@gmail.com',\n",
       " 'info@acts2fellowship.org',\n",
       " None,\n",
       " None,\n",
       " 'calasae@gmail.com',\n",
       " 'calasapresident@gmail.com',\n",
       " 'aasdsocialmedia@gmail.com',\n",
       " 'afxdance@gmail.com',\n",
       " 'dalilalva@berkeley.edu',\n",
       " 'adseberkeley@gmail.com',\n",
       " 'axopichapterpresident@gmail.com',\n",
       " 'axs.sigma.president@gmail.com',\n",
       " 'info@aquadelt.org',\n",
       " 'caladpipresident@gmail.com',\n",
       " None,\n",
       " 'aakashr@berkeley.edu',\n",
       " 'ago_actives@lists.berkeley.edu',\n",
       " 'AKARHO1921@gmail.com',\n",
       " 'brandonqinqin@gmail.com',\n",
       " 'calalphaphipresident@gmail.com',\n",
       " 'icecolddynasty@gmail.com',\n",
       " 'president@calaphio.com',\n",
       " 'calapx@gmail.com',\n",
       " None,\n",
       " 'ato.berkeley@gmail.com',\n",
       " 'berkeleyaltprotein@gmail.com',\n",
       " 'berkeleyaltbreaks@gmail.com',\n",
       " 'kvillacorta@berkeley.edu',\n",
       " 'blast@law.berkeley.edu',\n",
       " None,\n",
       " 'execs@calaaf.com',\n",
       " 'acsberkeley@gmail.com',\n",
       " 'berkeleylawacs@gmail.com',\n",
       " None,\n",
       " 'aiasberkeley@gmail.com',\n",
       " 'aiche.berkeley@gmail.com',\n",
       " 'info@alcsi.org',\n",
       " 'berkeleyamsa@gmail.com',\n",
       " 'amwaberkeley@gmail.com',\n",
       " 'president@ans.berkeley.edu',\n",
       " 'UCBTrustee@theaosa.org',\n",
       " 'berkeleyapsa@gmail.com',\n",
       " 'americanredcrossatcal@gmail.com',\n",
       " 'calasceofficers@gmail.com',\n",
       " 'berkeleystudentasla@gmail.com',\n",
       " 'asme.cal@gmail.com',\n",
       " 'americastoothfairyatberkeley@gmail.com',\n",
       " 'amigos.ucberkeley@gmail.com',\n",
       " None,\n",
       " 'ahcberkeley@gmail.com',\n",
       " 'katalina@berkeley.edu',\n",
       " 'executive@anova.berkeley.edu',\n",
       " 'auaucberkeley@gmail.com',\n",
       " None,\n",
       " 'berkeleyantitrafficking@gmail.com',\n",
       " 'dghandour@berkeley.edu',\n",
       " 'arcrepertory@gmail.com',\n",
       " 'chibuzorobiorah@berkeley.edu',\n",
       " 'ucbtango@gmail.com',\n",
       " 'jillychoi@berkely.edu',\n",
       " 'CalBerkeleyASA@gmail.com',\n",
       " None,\n",
       " None,\n",
       " 'estherykim@berkeley.edu',\n",
       " 'artandmind.berkeley@gmail.com',\n",
       " 'artistsinresonanceucb@gmail.com',\n",
       " 'aia.berkeleylaw@gmail.com',\n",
       " 'alix.vadot@berkeley.edu',\n",
       " 'vegansam@berkeley.edu',\n",
       " 'ascendberkeley.exec@gmail.com',\n",
       " 'berkeley@ashanet.org',\n",
       " 'ucbsph.apiwc@gmail.com',\n",
       " 'aapihrg.info@gmail.com',\n",
       " 'ucberkeleyaaa@gmail.com',\n",
       " 'linda.chen@berkeley.edu',\n",
       " 'aalj@berkeley.edu',\n",
       " None,\n",
       " 'berkeleyapalsa@gmail.com',\n",
       " 'ucb.apapla@gmail.com',\n",
       " None,\n",
       " 'sharon.jan@berkeley.edu',\n",
       " 'atpucberk@gmail.com',\n",
       " 'johnson_jessica@berkeley.edu',\n",
       " 'gfatima55@berkeley.edu',\n",
       " 'asrbatberkeley@gmail.com',\n",
       " 'team@ace.berkeley.edu',\n",
       " 'akaberkeley@gmail.com',\n",
       " 'aphidsco@gmail.com',\n",
       " None,\n",
       " 'exec@caltv.berkeley.edu',\n",
       " 'grants@asuc.org',\n",
       " 'decalprogram@gmail.com',\n",
       " None,\n",
       " None,\n",
       " 'innovativedesignatcal@gmail.com',\n",
       " 'aavp@asuc.org',\n",
       " 'eavp@asuc.org',\n",
       " 'evp@asuc.org',\n",
       " 'president@asuc.org opchief@asuc.org',\n",
       " 'help (at) ocf.berkeley.edu',\n",
       " 'senate@asuc.org',\n",
       " 'legalclinic@asuc.org',\n",
       " None,\n",
       " 'adminoffice@asuc.org',\n",
       " None,\n",
       " 'grants@asuc.org',\n",
       " 'grants@asuc.org',\n",
       " None,\n",
       " 'disabledstudentscommittee@asuc.org',\n",
       " 'diversityaffairscommission@asuc.org',\n",
       " None,\n",
       " None,\n",
       " 'financialwellness@asuc.org',\n",
       " 'housing@asuc.org',\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " 'legal@asuc.org',\n",
       " None,\n",
       " 'mentalhealthcommission@asuc.org',\n",
       " 'ayahya@asuc.org',\n",
       " 'aaguilar@asuc.org',\n",
       " 'aprakash@asuc.org',\n",
       " 'ctellem@asuc.org',\n",
       " 'espickermann@asuc.org',\n",
       " 'jcastro@asuc.org',\n",
       " None,\n",
       " 'mchen@asuc.org',\n",
       " 'mtorrico@asuc.org',\n",
       " 'msavides@asuc.org',\n",
       " 'ngarcia@asuc.org',\n",
       " 'rsoo@asuc.org',\n",
       " 'rzhang@asuc.org',\n",
       " 'rsholkoff@asuc.org',\n",
       " 'rshah@asuc.org',\n",
       " 'srodriguez@asuc.org',\n",
       " 'speng@asuc.org',\n",
       " 'sbancroft@asuc.org',\n",
       " 'sheenade@asuc.org',\n",
       " 'wliu@asuc.org',\n",
       " 'transferstudentrep@asuc.org',\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " 'sexualviolence@asuc.org',\n",
       " 'help@berkeleysao.org',\n",
       " 'superb@berkeley.edu',\n",
       " 'sustainability@asuc.org',\n",
       " 'technology@asuc.org',\n",
       " 'eavpvotecoalition@asuc.org',\n",
       " None,\n",
       " None,\n",
       " 'atrium.berkeley@gmail.com',\n",
       " 'calaurumcosmetics@gmail.com',\n",
       " 'ucb.azaad@gmail.com',\n",
       " 'berkeleybside@gmail.com',\n",
       " 'rasareachan@berkeley.edu',\n",
       " 'ballet.berkeley@gmail.com',\n",
       " 'reflejosdemexico.cal@gmail.com',\n",
       " 'bsaatberkeley@gmail.com',\n",
       " 'leadership@berkeley.edu',\n",
       " None,\n",
       " 'barbellatberkeley@gmail.com',\n",
       " 'editor@baremagazine.org',\n",
       " 'managing@barestage.berkeley.edu',\n",
       " 'info@beacn.berkeley.edu',\n",
       " 'baoc.rep@gmail.com',\n",
       " 'jade_fostvedt@berkeley.edu',\n",
       " 'bavrd@berkeley.edu',\n",
       " None,\n",
       " 'bethematch.berkeley@gmail.com',\n",
       " 'bearballersociety@gmail.com',\n",
       " None,\n",
       " 'bearbuddies.berkeleylaw@gmail.com',\n",
       " 'calbearcloset@gmail.com',\n",
       " 'ryanwchen@berkeley.edu',\n",
       " 'calbearraid@gmail.com',\n",
       " 'bearettesatberkeley@gmail.com',\n",
       " None,\n",
       " 'bearsagainstice@protonmail.com',\n",
       " 'bearsforisrael@gmail.com',\n",
       " 'info@bearsforpalestine.org',\n",
       " None,\n",
       " 'bercatberkeleylaw@gmail.com',\n",
       " 'berc.undergraduate@gmail.com',\n",
       " 'berke1337-admin@lists.berkeley.edu',\n",
       " 'bampfasc@berkeley.edu',\n",
       " 'berkeleybahaiclub@gmail.com',\n",
       " None,\n",
       " 'bbs.ucb@gmail.com',\n",
       " 'bcsa.core@gmail.com',\n",
       " 'calbells@gmail.com',\n",
       " 'bcssa.official@gmail.com',\n",
       " 'hannahku@berkeley.edu',\n",
       " 'calcollegerepublicans@gmail.com',\n",
       " 'clarisahuang@berkeley.edu',\n",
       " 'BerkeleyDisasterTeam@berkeley.edu',\n",
       " 'editor@econreview.berkeley.edu',\n",
       " 'copresidents@berc.berkeley.edu',\n",
       " 'beeps@beeps.berkeley.edu',\n",
       " 'berkeleyfictionreview@gmail.com',\n",
       " 'info@forum.berkeley.edu',\n",
       " 'berkeleygraduate@ga.berkeley.edu',\n",
       " 'berkeleyimmigrationgroup@law.berkeley.edu',\n",
       " 'berkeleybisa@gmail.com',\n",
       " 'berkeley.innovation@gmail.com',\n",
       " None,\n",
       " 'bjalp@berkeley.edu',\n",
       " 'bjcl@berkeley.edu',\n",
       " 'bjell@berkeley.edu',\n",
       " 'bjesl@berkeley.edu',\n",
       " 'bglj@berkeley.edu',\n",
       " 'bjil@berkeley.edu',\n",
       " 'tiffanyhamidjaja@berkeley.edu',\n",
       " 'probonobloc@law.berkeley.edu',\n",
       " 'batpro@law.berkeley.edu',\n",
       " 'berkeleylawmsa@gmail.com',\n",
       " 'berkeleylegals@gmail.com',\n",
       " 'pio@berkeleymrc.org',\n",
       " 'chief@bmun.org',\n",
       " 'curtisrumrill@berkeley.edu',\n",
       " 'contact@boaa.berkeley.edu',\n",
       " 'bpreditors@gmail.com',\n",
       " 'bproutreach@gmail.com',\n",
       " 'executive@berkeleyproject.org',\n",
       " 'contact@bppj.berkeley.edu',\n",
       " 'sciencereview@gmail.com',\n",
       " 'bsj.berkeley@gmail.com',\n",
       " None,\n",
       " 'btlj@berkeley.edu',\n",
       " 'berkeleytennisassociation@gmail.com',\n",
       " 'buj@berkeley.edu',\n",
       " None,\n",
       " 'bwib.berkeley@gmail.com',\n",
       " 'maudetipton@berkeley.edu',\n",
       " 'berkeleybestbuddies@gmail.com',\n",
       " 'bestlaidplansimprov@gmail.com',\n",
       " 'rush.berkeleybap@gmail.com',\n",
       " 'mervitan@berkeley.edu',\n",
       " None,\n",
       " 'info@beyondacademia.berkeley.edu',\n",
       " 'ucberkeley@bpshi.com',\n",
       " 'biasbusters-admin@lists.eecs.berkeley.edu',\n",
       " 'hello@bicycal.berkeley.edu',\n",
       " 'bigdata.berkeley@gmail.com',\n",
       " 'bbi@bbi.berkeley.edu',\n",
       " 'bioeBEAST@gmail.com',\n",
       " 'bioehs.exec@lists.berkeley.edu',\n",
       " 'bioethical.berkeley@gmail.com',\n",
       " 'biofuelstechnology@gmail.com',\n",
       " 'calbmes@gmail.com',\n",
       " 'admin@bioprinting.berkeley.edu',\n",
       " 'berkeley.bsgsa@gmail.com',\n",
       " 'baeh@berkeley.edu',\n",
       " 'berkeleymswblackcaucus@gmail.com',\n",
       " 'ucberkeleybessa@gmail.com',\n",
       " 'janehenderson@berkeley.edu',\n",
       " 'bgess@berkeley.edu',\n",
       " 'caleb_dawson@berkeley.edu',\n",
       " 'bplaberkeley@gmail.com',\n",
       " 'brrcboard@gmail.com',\n",
       " 'blacksociologicalalliance@gmail.com',\n",
       " 'chair.calbsu@gmail.com',\n",
       " 'calbsha@gmail.com',\n",
       " 'angelicapagan@berkeley.edu',\n",
       " None,\n",
       " 'admin@blockchain.berkeley.edu',\n",
       " 'info@blockeley.com',\n",
       " 'projectbloodpressure@gmail.com',\n",
       " 'info@yearbook.berkeley.edu',\n",
       " 'team@calblueprint.org',\n",
       " 'Ucberkeleygames@gmail.com',\n",
       " 'karnikhajjar@berkeley.edu',\n",
       " None,\n",
       " 'bonehealthinitiative@gmail.com',\n",
       " 'berkeleybootlegcomedy@gmail.com',\n",
       " 'boricuasinberkeley@gmail.com',\n",
       " 'rwoody@berkeley.edu',\n",
       " 'braintrustberkeley@gmail.com',\n",
       " 'natasha.blazer@berkeley.edu',\n",
       " None,\n",
       " 'brasaberkeley@gmail.com',\n",
       " 'executivebridges@gmail.com',\n",
       " 'bridgeusa.berkeley@gmail.com',\n",
       " None,\n",
       " 'brownissues.ucb@gmail.com',\n",
       " 'buildliteracy@berkeley.edu',\n",
       " 'bulletjournalbears@gmail.com',\n",
       " 'bab.berkeley@gmail.com',\n",
       " 'berkeleytechnologyinitiative@gmail.com',\n",
       " 'calbcec@gmail.com',\n",
       " 'businessreviewatberkeley@gmail.com',\n",
       " 'btnexecboard@btn.berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " 'students@casa.berkeley.edu',\n",
       " 'calaclu1920@gmail.com',\n",
       " 'webmaster@calanimagealpha.com',\n",
       " 'california.archery@gmail.com',\n",
       " None,\n",
       " None,\n",
       " 'president@caldems.com',\n",
       " 'calbhangra@gmail.com',\n",
       " 'calboxingclub@gmail.com',\n",
       " 'intervarsityccf@gmail.com',\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " 'californiaclubtennis@gmail.com',\n",
       " 'calcommunitymusic@gmail.com',\n",
       " None,\n",
       " 'caldragonboat@gmail.com',\n",
       " 'calequestrianclub@gmail.com',\n",
       " None,\n",
       " 'ucbfigureskating@gmail.com',\n",
       " 'calhabitat.pres@gmail.com',\n",
       " 'evickers29@berkeley.edu',\n",
       " 'calhawaiiclub@gmail.com',\n",
       " 'k.lyon@berkeley.edu',\n",
       " 'publicserviceinternships@berkeley.edu',\n",
       " 'calinthecapital@gmail.com',\n",
       " 'caljapanclub@gmail.com',\n",
       " None,\n",
       " 'clam.art.editor@gmail.com',\n",
       " None,\n",
       " None,\n",
       " '18rway@berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " 'safta@calperformances.org',\n",
       " 'calprevet.president@gmail.com',\n",
       " 'cal.q.and.a@gmail.com',\n",
       " None,\n",
       " 'info@calrotaract.org',\n",
       " None,\n",
       " 'calsailing@gmail.com',\n",
       " 'calseismicteam@gmail.com',\n",
       " 'staph@berkeley.edu',\n",
       " 'alexander.rodriguez@berkeley.edu',\n",
       " 'calsmv@gmail.com',\n",
       " 'calttc@gmail.com',\n",
       " 'caltaiko@gmail.com',\n",
       " 'president@caltriathlon.com',\n",
       " 'caluphc.publichealth@gmail.com',\n",
       " 'calvetsgroup@gmail.com',\n",
       " 'calclublacrosse@gmail.com',\n",
       " None,\n",
       " None,\n",
       " 'calwomens.waterpolo@gmail.com',\n",
       " 'calwomensrugby@gmail.com',\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " 'calibermag@gmail.com',\n",
       " 'carc@berkeley.edu',\n",
       " 'cahpsa.berkeley@gmail.com',\n",
       " None,\n",
       " 'calmocktrial@gmail.com',\n",
       " 'calpirgbears@gmail.com',\n",
       " 'berkeleyscc@gmail.com',\n",
       " 'lead@berkeley.edu',\n",
       " 'calsol-me@berkeley.edu',\n",
       " None,\n",
       " 'berkeley@campkesem.org',\n",
       " 'mcharles@berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " 'apasdoffice@gmail.com',\n",
       " 'asucstudentunion@berkeley.edu',\n",
       " 'basicneedscenter@berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " 'artstudio@berkeley.edu',\n",
       " 'info.artsdesign@berkeley.edu',\n",
       " 'sashachang@berkeley.edu',\n",
       " None,\n",
       " 'studyabroad@berkeley.edu',\n",
       " 'https://ssall.zendesk.com/hc/en-us',\n",
       " None,\n",
       " None,\n",
       " 'dining@berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " 'lupeg@berkeley.edu',\n",
       " 'disabilityculture@berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " 'eventservices@berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " 'lead@berkeley.edu',\n",
       " 'mcc.community@berkeley.edu',\n",
       " 'nasd@berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " 'rhershkowitz@berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " 'berkeleymoves@berkeley.edu',\n",
       " 'pathtocare@berkeley.edu',\n",
       " 'studentmedia@berkeley.edu',\n",
       " 'rhershkowitz@berkeley.edu',\n",
       " None,\n",
       " 'serc@berkeley.edu',\n",
       " 'slc@berkeley.edu',\n",
       " 'sof@berkeley.edu',\n",
       " 'techfund@berkeley.edu',\n",
       " None,\n",
       " 'tgif_info@berkeley.edu',\n",
       " None,\n",
       " 'e-ref@library.berkeley.edu',\n",
       " None,\n",
       " 'geneq@berkeley.edu',\n",
       " None,\n",
       " 'publicservice@berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " 'cef.berkeley@gmail.com',\n",
       " 'derektzeng@berkeley.edu',\n",
       " 'ashwinbindra@berkeley.edu',\n",
       " None,\n",
       " 'cardsforcourageberkeley@gmail.com',\n",
       " 'casaesperanzaberkeley@gmail.com',\n",
       " 'casesovercoffeeatberkeley@gmail.com',\n",
       " 'taylor.chelan@berkeley.edu',\n",
       " 'smt.exec@calnewman.org',\n",
       " 'catholicsatberkeleylaw@gmail.com',\n",
       " 'eugenewlau@berkeley.edu',\n",
       " None,\n",
       " 'wearecelli@gmail.com',\n",
       " 'CAFEatucb@gmail.com',\n",
       " 'jenliu2@berkeley.edu',\n",
       " 'chec.berkeley@gmail.com',\n",
       " 'gsac@lists.berkeley.edu',\n",
       " 'berkeley.chemecar@gmail.com',\n",
       " 'ucbglc@gmail.com',\n",
       " 'curieatberkeley@gmail.com',\n",
       " 'ucbchess@gmail.com',\n",
       " 'berkeleyxe@gmail.com',\n",
       " 'calchiomegapresident@gmail.com',\n",
       " None,\n",
       " 'andreasmaass@berkeley.edu',\n",
       " 'checochair2@gmail.com',\n",
       " 'casistas@gmail.com',\n",
       " None,\n",
       " 'berkeleychineseacappella@gmail.com',\n",
       " 'chinesefinanceclub@gmail.com',\n",
       " 'berkeleycgpsa@gmail.com',\n",
       " 'chinesepeopleunion@gmail.com',\n",
       " 'syz0516@berkeley.edu',\n",
       " 'hi@7pmsalon.org',\n",
       " 'csaberkeley@gmail.com',\n",
       " 'ashleyhuang@berkeley.edu',\n",
       " 'chyk-berkeley-active@googlegroups.com',\n",
       " 'berkeleycmda@gmail.com',\n",
       " 'christiansatberkeleylaw@berkeley.edu',\n",
       " 'ucb.coc@gmail.com',\n",
       " 'chunjinahm@gmail.com',\n",
       " 'info.cinebears@gmail.com',\n",
       " 'capclubberkeley@gmail.com',\n",
       " 'cki.sarahg@gmail.com',\n",
       " 'faizkhwaja@berkeley.edu',\n",
       " 'stubbsjessica@berkeley.edu',\n",
       " 'lucia@berkeley.edu',\n",
       " None,\n",
       " 'ceejfc@berkeley.edu',\n",
       " 'js98@berkeley.edu',\n",
       " None,\n",
       " 'classicalforumberkeley@gmail.com',\n",
       " 'ucbclear@gmail.com',\n",
       " 'calclimbingofficers@googlegroups.com',\n",
       " 'cliosscroll@gmail.com',\n",
       " 'cloudatcal@gmail.com',\n",
       " 'berkeleycmg@gmail.com',\n",
       " 'curtisrumrill@berkeley.edu',\n",
       " 'coalitionfordiversity@gmail.com',\n",
       " 'cifmpatcal@gmail.com',\n",
       " 'ccmpatberkeley@gmail.com',\n",
       " 'joellefe@berkeley.edu',\n",
       " 'california@bamn.com',\n",
       " 'contact@codebase.berkeley.edu',\n",
       " 'info@codeology.club',\n",
       " 'cssa.berkeley@gmail.com',\n",
       " 'd1abears@collegediabetesnetwork.org',\n",
       " 'team@collegeleap.cc',\n",
       " None,\n",
       " 'carpbayarea@gmail.com',\n",
       " 'juan@berkeley.edu',\n",
       " 'colorsoftheater@gmail.com',\n",
       " 'info@combatrobotics.berkeley.edu',\n",
       " 'comicsstudiodecal@gmail.com',\n",
       " None,\n",
       " 'baycommunitywellness@gmail.com',\n",
       " 'trw@berkeley.edu',\n",
       " None,\n",
       " 'crj@berkeley.edu',\n",
       " 'berkeleycluj@gmail.com',\n",
       " 'mentors@berkeley.edu',\n",
       " 'pb@csua.berkeley.edu',\n",
       " 'calconcretecanoe@gmail.com',\n",
       " 'confiatcal@gmail.com',\n",
       " 'hello@connected.berkeley.edu',\n",
       " 'ucbconstructionteam@gmail.com',\n",
       " 'berkeley@consultyourcommunity.org',\n",
       " 'con@berkeley.edu',\n",
       " 'caps@law.berkeley.edu',\n",
       " 'c3po@law.berkeley.edu',\n",
       " 'maddypilgrim@berkeley.edu',\n",
       " 'angelicavohland@berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " 'calorigami@gmail.com',\n",
       " 'amyzh@berkeley.edu',\n",
       " 'calcreate@gmail.com',\n",
       " None,\n",
       " 'cal.ccas@gmail.com',\n",
       " 'xroadscf@gmail.com',\n",
       " 'crsso@lists.berkeley.edu',\n",
       " 'berkeleycru@gmail.com',\n",
       " 'cskickstart@gmail.com',\n",
       " 'ucbears4cubs@gmail.com',\n",
       " 'berkeleycubanamericans@gmail.com',\n",
       " 'editor@dailycal.org',\n",
       " 'berkeleydancecommunity@gmail.com',\n",
       " 'dancethebay@gmail.com',\n",
       " 'dwxpresidents@gmail.com',\n",
       " 'daraja.berkeley@gmail.com',\n",
       " 'info@dss.berkeley.edu',\n",
       " 'datagood@berkeley.edu',\n",
       " 'datastory.president@gmail.com',\n",
       " 'datongsociety@gmail.com',\n",
       " 'decoloresucb@gmail.com',\n",
       " 'contact@debate.berkeley.edu',\n",
       " 'decadence.berkeley@gmail.com',\n",
       " 'decode.build@gmail.com',\n",
       " 'adithi@berkeley.edu',\n",
       " 'darby.aono@berkeley.edu',\n",
       " None,\n",
       " 'deltaconsulting.berkeley@gmail.com',\n",
       " 'caltrideltapresident@gmail.com',\n",
       " 'caldelta.epsilon.mu@gmail.com',\n",
       " 'dggammapresident@gmail.com',\n",
       " 'president@berkeley.dka.org',\n",
       " 'berkeleydpe@gmail.com',\n",
       " None,\n",
       " 'kappa1921@gmail.com',\n",
       " None,\n",
       " 'ucbdeltaxiphi@gmail.com',\n",
       " 'caldibs@gmail.com',\n",
       " 'ajsolovy@berkeley.edu',\n",
       " 'designatberk@gmail.com',\n",
       " 'cloudcomputingdecal@gmail.com',\n",
       " 'digitalrightsproject@law.berkeley.edu',\n",
       " 'ucberkeleydilse@gmail.com',\n",
       " 'drp@berkeley.edu',\n",
       " 'disneyclubatberkeley@gmail.com',\n",
       " 'diversatech.berkeley@gmail.com',\n",
       " 'msf.ucberkeley@gmail.com',\n",
       " 'downsyndromeberkeley@gmail.com',\n",
       " 'cal.drawntoscale@gmail.com',\n",
       " 'Berkeley.Dream@gmail.com',\n",
       " None,\n",
       " None,\n",
       " 'eeri@berkeley.edu',\n",
       " 'chair@eau.berkeley.edu',\n",
       " 'minsookim729@berkeley.edu',\n",
       " 'dreamersclinic@berkeley.edu',\n",
       " 'jsycoff@berkeley.edu',\n",
       " 'ecodeatberkeley@gmail.com',\n",
       " 'julia.whitehead@berkeley.edu',\n",
       " None,\n",
       " 'ursan@berkeley.edu',\n",
       " 'epic.berkeley@gmail.com',\n",
       " 'edreimaginedberkeley@gmail.com',\n",
       " None,\n",
       " 'admin@eaberkeley.com',\n",
       " 'eggsteroverall@gmail.com',\n",
       " 'ucberkeley.ego@gmail.com',\n",
       " 'molly_haley@berkeley.edu',\n",
       " None,\n",
       " 'eleven.ucb@gmail.com',\n",
       " None,\n",
       " 'enabletechberkeley@gmail.com',\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " 'president@esc.berkeley.edu',\n",
       " 'engineeringwellnessatberkeley@gmail.com',\n",
       " 'beam.teach@gmail.com',\n",
       " 'officers@esw.berkeley.edu',\n",
       " None,\n",
       " 'ewb.ucb@gmail.com',\n",
       " 'berkeley.eua@gmail.com',\n",
       " 'cal.entomology@gmail.com',\n",
       " 'eso@lists.berkeley.edu',\n",
       " None,\n",
       " 'admin@entrepreneurs.berkeley.edu',\n",
       " 'ecoslp@berkeley.edu',\n",
       " None,\n",
       " 'gostout@berkeley.edu',\n",
       " 'environment@law.berkeley.edu',\n",
       " 'berkeley.essa@gmail.com',\n",
       " 'calenviroteam@gmail.com',\n",
       " 'epsilonetaberkeley@gmail.com',\n",
       " 'jcaminiti@berkeley.edu',\n",
       " 'equitybeyondbarriers@gmail.com',\n",
       " 'ergo@lists.berkeley.edu',\n",
       " 'espmgdc@berkeley.edu',\n",
       " 'espmgsa@gmail.com',\n",
       " 'r.madden@berkeley.edu',\n",
       " 'hkn@hkn.eecs.berkeley.edu',\n",
       " 'etaomegachi@gmail.com',\n",
       " 'ethicalapparel@gmail.com',\n",
       " None,\n",
       " 'expdancecrew@gmail.com',\n",
       " 'eyh_ucb@googlegroups.com',\n",
       " None,\n",
       " 'exposureos.ucb@gmail.com',\n",
       " 'ronitnath@berkeley.edu',\n",
       " 'contact@xr.berkeley.edu',\n",
       " 'haominm98@berkeley.edu',\n",
       " None,\n",
       " 'calfastinternal@gmail.com',\n",
       " 'berkeleyclubsoftball@gmail.com',\n",
       " 'berkeleyfederalistsociety@gmail.com',\n",
       " 'feelgoodberkeley@gmail.com',\n",
       " 'dance.chinese@gmail.com',\n",
       " 'kirstychoi@berkeley.edu',\n",
       " 'FMLAofBerkeley@gmail.com',\n",
       " 'femtechberkeley@gmail.com',\n",
       " 'a.mendoza@berkeley.edu',\n",
       " 'ucberkeleyflsa@berkeley.edu',\n",
       " 'fesa@mfe.berkeley.edu',\n",
       " 'flejcon@gmail.com',\n",
       " 'fintechberkeley@gmail.com',\n",
       " 'berkeleylawfgp@gmail.com',\n",
       " 'yakira.mirabito@berkeley.edu',\n",
       " 'noaht@berkeley.edu',\n",
       " 'foodatberkeley@gmail.com',\n",
       " 'brandonqinqin@gmail.com',\n",
       " 'foodjustice@law.berkeley.edu',\n",
       " 'fstatcal@gmail.com',\n",
       " 'feedberkeley@gmail.com',\n",
       " 'FCSBerkeley@gmail.com',\n",
       " 'foresight.president@gmail.com',\n",
       " 'contact@ev.berkeley.edu',\n",
       " 'fsae@me.berkeley.edu',\n",
       " 'fostered@law.berkeley.edu',\n",
       " 'fimrc.berkeley@gmail.com',\n",
       " 'spauker@berkeley.edu',\n",
       " 'adhiv@freeventures.org',\n",
       " 'president@bsc.coop',\n",
       " None,\n",
       " 'execs@pbl.berkeley.edu',\n",
       " 'tiffani.johnson@berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " 'bblj@law.berkeley.edu',\n",
       " 'cavp@ga.berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " 'funding@ga.berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " 'businessoffice@ga.berkeley.edu',\n",
       " None,\n",
       " 'president@ga.berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " 'rules@ga.berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " 'contact@gamedev.berkeley.edu',\n",
       " 'cal.gammaphi.pres@gmail.com',\n",
       " 'lambda@gammarholambda.org',\n",
       " 'calgammas@gmail.com',\n",
       " 'berkeleygarb@gmail.com',\n",
       " 'generationflowatberkeley@gmail.com',\n",
       " 'ucberkeleygensex@gmail.com',\n",
       " 'genupcoberkeley@gmail.com',\n",
       " 'geoengineering@berkeley.edu',\n",
       " 'jlamb2021@berkeley.edu',\n",
       " 'geowallcal@gmail.com',\n",
       " 'giamag.ucb@gmail.com',\n",
       " 'giantfilmmakers@gmail.com',\n",
       " 'golberkeley@gmail.com',\n",
       " 'giftsatberkeley@gmail.com',\n",
       " 'amritarama@berkeley.edu',\n",
       " 'ucberkeley@girlsteachinggirlstocode.org',\n",
       " 'gwcberkeley@gmail.com',\n",
       " 'berkeleygbb@gmail.com',\n",
       " None,\n",
       " 'gmbberkeley@gmail.com',\n",
       " 'globerkeley.president@gmail.com',\n",
       " 'berkeleygmma@gmail.com',\n",
       " 'gmtucberkeley@gmail.com',\n",
       " 'berkeley@grcglobalgroup.com',\n",
       " 'berkeley@globemed.org',\n",
       " None,\n",
       " 'elliot.choi@berkeley.edu',\n",
       " 'goldenwomenatberkeley@gmail.com',\n",
       " None,\n",
       " 'ced.gradstudentunion@berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " 'gasp@berkeley.edu',\n",
       " 'gradsrza@gmail.com',\n",
       " 'gea@econ.berkeley.edu',\n",
       " 'samstein@berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " 'educationresearchday@gmail.com',\n",
       " None,\n",
       " None,\n",
       " 'bre_editor@berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " 'sjohns@berkeley.edu',\n",
       " 'gradswe@berkeley.edu',\n",
       " None,\n",
       " 'gasa@calgreeks.com',\n",
       " 'calgreenerhearts@gmail.com',\n",
       " 'greeningthegreeks@berkeley.edu',\n",
       " 'grotech.berkeley@gmail.com',\n",
       " 'groundupjournal@gmail.com',\n",
       " 'gvpp@berkeley.edu',\n",
       " 'hbsageneral@gmail.com',\n",
       " 'ucbhubba@gmail.com',\n",
       " 'team@calhacks.io',\n",
       " 'handsandfeetberkeley@gmail.com',\n",
       " 'happyperiodberkeley@gmail.com',\n",
       " 'hmap@berkeley.edu',\n",
       " 'admin@healsca.berkeley.edu',\n",
       " 'hbls@law.berkeley.edu',\n",
       " 'healthcarebusinessberkeley@gmail.com',\n",
       " 'fionalzx@berkeley.edu',\n",
       " 'heartfulness.berkeley20@gmail.com',\n",
       " 'contact@thehelixgroup.org',\n",
       " None,\n",
       " 'hepbproject@gmail.com',\n",
       " 'hc.ucberkeley@hercampus.com',\n",
       " None,\n",
       " 'ucbhau.cochairs@gmail.com',\n",
       " 'huchochairs@berkeley.edu',\n",
       " 'heuristicsquelch@gmail.com',\n",
       " 'arsine.03@berkeley.edu',\n",
       " 'studentboardpres@berkeleyhillel.org',\n",
       " None,\n",
       " 'hesberkeley8@gmail.com',\n",
       " 'steelonsteelhfc@gmail.com',\n",
       " 'hga@berkeley.edu',\n",
       " 'hsaberkeley@gmail.com',\n",
       " 'hosfellowship@gmail.com',\n",
       " None,\n",
       " None,\n",
       " 'hkaaberk@gmail.com',\n",
       " 'berkeleyhksa@gmail.com',\n",
       " None,\n",
       " 'Hear@berkeley.edu',\n",
       " 'hpv-me@berkeley.edu',\n",
       " 'anyal23@berkeley.edu',\n",
       " None,\n",
       " 'berkeleyanidealism@gmail.com',\n",
       " None,\n",
       " None,\n",
       " 'ieee@berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " 'directors@igem.berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " 't4cimprov@gmail.com',\n",
       " 'inbetweenberkeley@gmail.com',\n",
       " 'contact@isa.berkeley.edu',\n",
       " 'natives@berkeley.edu',\n",
       " 'imsa@ischool.berkeley.edu',\n",
       " 'ilr.ucb@gmail.com',\n",
       " 'jmiller558@berkeley.edu',\n",
       " 'iise@berkeley.edu',\n",
       " 'ucberkeleyite@gmail.com',\n",
       " 'jaeminlee0622@berkeley.edu',\n",
       " 'ifjberkeley@gmail.com',\n",
       " None,\n",
       " 'intermissionberkeley@gmail.com',\n",
       " None,\n",
       " 'ruijis@berkeley.edu',\n",
       " 'berkeleyintconsulting@gmail.com',\n",
       " 'delangs2020@gmail.com',\n",
       " 'berkeleyigsm@gmail.com',\n",
       " 'ihcaberkeley@gmail.com',\n",
       " 'ihrwslp@berkeley.edu',\n",
       " 'irap@law.berkeley.edu',\n",
       " 'ircofberkeley@gmail.com',\n",
       " 'international@calrotaract.org',\n",
       " 'crystal.gong@berkeley.edu',\n",
       " 'yehongtan@berkeley.edu',\n",
       " 'isab.officer@gmail.com',\n",
       " 'berkiusm@gmail.com',\n",
       " 'iysse.ucberkeley@gmail.com',\n",
       " None,\n",
       " 'natives@berkeley.edu',\n",
       " 'intervarsityccf@gmail.com',\n",
       " 'eduhmc@berkeley.edu',\n",
       " 'inventioncorps@icb.berkeley.edu',\n",
       " None,\n",
       " 'info@isaa.berkeley.edu',\n",
       " 'iscoucb@gmail.com',\n",
       " 'irish.dancers.berkeley@gmail.com',\n",
       " 'ucb.imsu@gmail.com',\n",
       " 'shshah2018@berkeley.edu',\n",
       " 'jdhillon813@berkeley.edu',\n",
       " 'nsimha@berkeley.edu',\n",
       " 'jerichocomedy@gmail.com',\n",
       " 'jsabl@law.berkeley.edu',\n",
       " 'jqasatberkeley@gmail.com',\n",
       " 'm_chen@berkeley.edu',\n",
       " 'kairosdanceco@gmail.com',\n",
       " None,\n",
       " 'kapiucb.president@gmail.com',\n",
       " None,\n",
       " 'omegathetaceo@gmail.com',\n",
       " None,\n",
       " 'ucbkgdpresident@gmail.com',\n",
       " 'kkgucbpresident@gmail.com',\n",
       " 'kendoclub.berkeley@gmail.com',\n",
       " 'berkeleykdsap@gmail.com',\n",
       " 'ucbkin@gmail.com',\n",
       " 'alaynakwan@berkeley.edu',\n",
       " 'kinkclubberkeley@gmail.com',\n",
       " 'lilyli@berkeley.edu',\n",
       " 'kevmo@berkeley.edu',\n",
       " 'kojobsatberkeley@gmail.com',\n",
       " 'calkasa@gmail.com',\n",
       " None,\n",
       " 'berkeleychurch0691@gmail.com',\n",
       " 'kpg.cal@gmail.com',\n",
       " 'kseaatcal@gmail.com',\n",
       " 'kosmosucb@gmail.com',\n",
       " None,\n",
       " 'hojung1019@berkeley.edu',\n",
       " 'lrlj@berkeley.edu',\n",
       " 'laalianza@berkeley.edu',\n",
       " 'LaRazaSLP@berkeley.edu',\n",
       " 'ahs.laborcoach@gmail.com',\n",
       " 'lta.do.president@gmail.com',\n",
       " 'LambdaThetaNu.Berkeley@gmail.com',\n",
       " 'ucblambdas@gmail.com',\n",
       " 'a.mendoza@berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " 'llsatberkeley@gmail.com',\n",
       " 'lagses-contact@gmail.com',\n",
       " 'ucblbsa.president@gmail.com',\n",
       " None,\n",
       " 'lplsexecutivedirector@gmail.com',\n",
       " None,\n",
       " 'latinxstudentassociation.ucb@gmail.com',\n",
       " 'team@callaunchpad.org',\n",
       " 'lavenderallianceberkeley@gmail.com',\n",
       " 'berkeley.lpesoc@gmail.com',\n",
       " 'zsalazar2019@berkeley.edu',\n",
       " 'lsij.berkeleylaw@gmail.com',\n",
       " 'berkeleylsjp@gmail.com',\n",
       " 'lsad@law.berkeley.edu',\n",
       " 'layaofberkeley@gmail.com',\n",
       " 'jtennant@berkeley.edu',\n",
       " 'clairecombredet@berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " 'lfsucberkeley@gmail.com',\n",
       " 'daniellaivanir@berkeley.edu',\n",
       " 'LSAatBerkeley@gmail.com',\n",
       " 'legalautomation@berkeley.edu',\n",
       " 'berkeleyleagueoflegends@gmail.com',\n",
       " 'letsrisementorship@gmail.com',\n",
       " 'linkbayarea@gmail.com',\n",
       " 'lindyonthesproul@gmail.com',\n",
       " 'callinguaphiles@gmail.com',\n",
       " 'megnar13@berkeley.edu',\n",
       " 'livepoetsatberkeley@gmail.com',\n",
       " 'local@calrotaract.org',\n",
       " 'Buckingbears@gmail.com',\n",
       " None,\n",
       " 'luxintlconsulting@gmail.com',\n",
       " 'passionlivingwater@gmail.com',\n",
       " 'lwpresence@googlegroups.com',\n",
       " None,\n",
       " 'contact@ml.berkeley.edu',\n",
       " 'maganda.eic@gmail.com',\n",
       " 'mainstacksdance@gmail.com',\n",
       " None,\n",
       " 'sravyab@berkeley.edu',\n",
       " 'marchofdimesberkeley@gmail.com',\n",
       " 'ucbmariachi@gmail.com',\n",
       " 'infoMDG2020@mdgberkeley.com',\n",
       " 'general@msea.berkeley.edu',\n",
       " 'arutt@berkeley.edu',\n",
       " 'questions@bmt.berkeley.edu',\n",
       " 'mgsa@math.berkeley.edu',\n",
       " 'musa@math.berkeley.edu',\n",
       " 'info@matriculate.org',\n",
       " 'mayaatcal@gmail.com',\n",
       " None,\n",
       " 'treyriddle@berkeley.edu',\n",
       " None,\n",
       " 'jmpsuitcase@gmail.com',\n",
       " 'contact@mri.berkeley.edu',\n",
       " None,\n",
       " 'armen.n.demirjian@berkeley.edu',\n",
       " 'ucbmedlife@gmail.com',\n",
       " 'candy0712n@berkeley.edu',\n",
       " None,\n",
       " 'cbarber@berkeley.edu',\n",
       " 'calmicrobes@gmail.com',\n",
       " 'berkeleymicrofinance@gmail.com',\n",
       " 'berkeleylawmelsa@gmail.com',\n",
       " 'mrayes@berkeley.edu',\n",
       " 'ucberkeleymenarrc@gmail.com',\n",
       " 'yebrat@gmail.com',\n",
       " 'mvbl@berkeley.edu',\n",
       " 'ucbmbn@gmail.com',\n",
       " 'mindfulnessatberkeley@gmail.com',\n",
       " None,\n",
       " None,\n",
       " 'mixedatberkeley@gmail.com',\n",
       " 'contact@mdb.dev',\n",
       " 'mcbcdna@gmail.com',\n",
       " 'mcbusa@gmail.com',\n",
       " 'mcbgso@gmail.com',\n",
       " None,\n",
       " 'moodpsych@gmail.com',\n",
       " 'admin@morningsignout.berkeley.edu',\n",
       " 'movefellowshipcal@gmail.com',\n",
       " 'ucb.movement@gmail.com',\n",
       " 'julia_forte@berkeley.edu',\n",
       " 'mcgc.president@calgreeks.com',\n",
       " None,\n",
       " 'tmcberkeley@gmail.com',\n",
       " 'board@msa.berkeley.edu',\n",
       " None,\n",
       " None,\n",
       " None,\n",
       " 'ucbnaacp@gmail.com',\n",
       " 'nalaproject@berkeley.edu',\n",
       " 'CompassionInActionUCBerkeley@gmail.com',\n",
       " 'ngcwberkeley@gmail.com',\n",
       " 'namiucb@gmail.com',\n",
       " 'nabj.cal@gmail.com',\n",
       " 'ucbncnw@gmail.com',\n",
       " 'JOSHUA.ALPERT@BERKELEY.EDU',\n",
       " 'nlgberkeleylaw@gmail.com',\n",
       " 'nosa.berkeley@gmail.com',\n",
       " ...]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "[org['email'] for org in processed_org_data]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Step 5: Further analysis"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Max length of club name: 134\n",
      "Max length of summary: 255\n",
      "Max length of description: 19015\n"
     ]
    }
   ],
   "source": [
    "print('Max length of club name:', new_orgs_df['name'].apply(len).max())\n",
    "print('Max length of summary:', new_orgs_df['summary'].dropna().apply(len).max())\n",
    "print('Max length of description:', new_orgs_df['description'].dropna().apply(len).max())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of summaries: 1462\n",
      "Number of descriptions: 1188\n"
     ]
    }
   ],
   "source": [
    "summary_lengths = new_orgs_df['summary'].dropna().apply(lambda summary: len(summary)).to_list()\n",
    "print('Number of summaries:', len(summary_lengths))\n",
    "\n",
    "descr_lengths = new_orgs_df['description'].dropna().apply(lambda summary: len(summary)).to_list()\n",
    "print('Number of descriptions:', len(descr_lengths))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/tejashah88/extra-software/anaconda3/envs/sc-notebook/lib/python3.6/site-packages/seaborn/distributions.py:2557: FutureWarning: `distplot` is a deprecated function and will be removed in a future version. Please adapt your code to use either `displot` (a figure-level function with similar flexibility) or `histplot` (an axes-level function for histograms).\n",
      "  warnings.warn(msg, FutureWarning)\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAeYAAAHSCAYAAAA5eGh0AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAAW6klEQVR4nO3db4hd953f8c83tutdkoW18dgollyboEDtwCpFKAuGkibbtZuWynngRU43uGBwHjiQwELXzpNkCwJT8qcP2gScxqy2jeMKkmAR0t113IQQKHbkrNex7LgRa9dWLCwl6ZL4iYuVbx/MMbl1ZjRXmhnNz3deLxjuvb85596fDgfeOuceHVV3BwAYw1u2egIAwK8JMwAMRJgBYCDCDAADEWYAGIgwA8BALt7qCSTJFVdc0ddee+1WTwMALpjHH3/8p9299MbxIcJ87bXX5ujRo1s9DQC4YKrqf6807lQ2AAxEmAFgIMIMAAMRZgAYiDADwECEGQAGIswAMBBhBoCBCDMADESYAWAgwgwAAxFmABiIMAPAQIQZAAYizAAwEGEGgIEIMwAMRJgBYCDCDAADuXirJwAA5+OBR1+4YJ/1ofdcc8E+yxEzAAxEmAFgIMIMAAMRZgAYiDADwECEGQAGIswAMJC5w1xVF1XV31TVN6bXl1fVw1X14+nxspll76mq41X1bFXdtBkTB4BFdC5HzB9L8szM67uTPNLdu5M8Mr1OVV2f5ECSG5LcnOTzVXXRxkwXABbbXGGuqp1J/kWS/zwzvD/Joen5oSS3zIw/2N2vdvdzSY4n2bchswWABTfvEfN/SPJvk/xqZuyq7j6ZJNPjldP41UlenFnuxDQGAKxhzTBX1b9Mcqq7H5/zPWuFsV7hfe+sqqNVdfT06dNzvjUALLZ5jphvTPKvqur5JA8meV9V/dckL1fVjiSZHk9Ny59Ismtm/Z1JXnrjm3b3fd29t7v3Li0treOPAACLY80wd/c93b2zu6/N8kVd/6O7/zjJkSS3T4vdnuSh6fmRJAeq6tKqui7J7iSPbfjMAWABree/fbw3yeGquiPJC0luTZLuPlZVh5M8neS1JHd195l1zxQAtoFzCnN3fyfJd6bnP0vy/lWWO5jk4DrnBgDbjjt/AcBAhBkABiLMADAQYQaAgQgzAAxEmAFgIMIMAAMRZgAYiDADwECEGQAGIswAMBBhBoCBCDMADESYAWAgwgwAAxFmABiIMAPAQIQZAAYizAAwEGEGgIEIMwAMRJgBYCDCDAADEWYAGIgwA8BAhBkABiLMADAQYQaAgQgzAAxEmAFgIMIMAAMRZgAYiDADwECEGQAGIswAMBBhBoCBCDMADESYAWAgwgwAAxFmABiIMAPAQNYMc1X9VlU9VlV/W1XHqurPpvFPVdVPquqJ6ecDM+vcU1XHq+rZqrppM/8AALBILp5jmVeTvK+7X6mqS5J8r6r++/S7z3X3p2cXrqrrkxxIckOStyf5VlW9s7vPbOTEAWARrXnE3MtemV5eMv30WVbZn+TB7n61u59LcjzJvnXPFAC2gbm+Y66qi6rqiSSnkjzc3Y9Ov/poVT1ZVfdX1WXT2NVJXpxZ/cQ0BgCsYa4wd/eZ7t6TZGeSfVX1riRfSPKOJHuSnEzymWnxWukt3jhQVXdW1dGqOnr69OnzmDoALJ5zuiq7u/8+yXeS3NzdL0/B/lWSL+bXp6tPJNk1s9rOJC+t8F73dffe7t67tLR0PnMHgIUzz1XZS1X1u9Pz307yB0l+VFU7Zhb7YJKnpudHkhyoqkur6roku5M8tqGzBoAFNc9V2TuSHKqqi7Ic8sPd/Y2q+i9VtSfLp6mfT/KRJOnuY1V1OMnTSV5LcpcrsgFgPmuGubufTPLuFcY/fJZ1DiY5uL6pAcD2485fADAQYQaAgQgzAAxEmAFgIMIMAAMRZgAYiDADwECEGQAGIswAMBBhBoCBCDMADESYAWAgwgwAAxFmABiIMAPAQIQZAAYizAAwEGEGgIEIMwAMRJgBYCDCDAADEWYAGIgwA8BAhBkABiLMADAQYQaAgQgzAAxEmAFgIMIMAAMRZgAYiDADwECEGQAGIswAMBBhBoCBCDMADESYAWAgwgwAAxFmABiIMAPAQIQZAAYizAAwkDXDXFW/VVWPVdXfVtWxqvqzafzyqnq4qn48PV42s849VXW8qp6tqps28w8AAItkniPmV5O8r7t/L8meJDdX1e8nuTvJI929O8kj0+tU1fVJDiS5IcnNST5fVRdtwtwBYOGsGeZe9sr08pLpp5PsT3JoGj+U5Jbp+f4kD3b3q939XJLjSfZt5KQBYFHN9R1zVV1UVU8kOZXk4e5+NMlV3X0ySabHK6fFr07y4szqJ6YxAGANc4W5u890954kO5Psq6p3nWXxWuktfmOhqjur6mhVHT19+vRckwWARXdOV2V3998n+U6Wvzt+uap2JMn0eGpa7ESSXTOr7Uzy0grvdV937+3uvUtLS+c+cwBYQPNclb1UVb87Pf/tJH+Q5EdJjiS5fVrs9iQPTc+PJDlQVZdW1XVJdid5bIPnDQAL6eI5ltmR5NB0ZfVbkhzu7m9U1f9Mcriq7kjyQpJbk6S7j1XV4SRPJ3ktyV3dfWZzpg8Ai2XNMHf3k0nevcL4z5K8f5V1DiY5uO7ZAcA2485fADAQYQaAgQgzAAxEmAFgIMIMAAMRZgAYiDADwECEGQAGIswAMBBhBoCBCDMADESYAWAgwgwAAxFmABiIMAPAQIQZAAYizAAwEGEGgIEIMwAMRJgBYCDCDAADEWYAGIgwA8BAhBkABiLMADAQYQaAgQgzAAxEmAFgIMIMAAMRZgAYiDADwECEGQAGIswAMBBhBoCBCDMADESYAWAgwgwAAxFmABiIMAPAQIQZAAYizAAwEGEGgIGsGeaq2lVV366qZ6rqWFV9bBr/VFX9pKqemH4+MLPOPVV1vKqeraqbNvMPAACL5OI5lnktyZ909w+q6neSPF5VD0+/+1x3f3p24aq6PsmBJDckeXuSb1XVO7v7zEZOHAAW0ZpHzN19srt/MD3/ZZJnklx9llX2J3mwu1/t7ueSHE+ybyMmCwCL7py+Y66qa5O8O8mj09BHq+rJqrq/qi6bxq5O8uLMaieyQsir6s6qOlpVR0+fPn3uMweABTR3mKvqbUm+muTj3f2LJF9I8o4ke5KcTPKZ1xddYfX+jYHu+7p7b3fvXVpaOtd5A8BCmivMVXVJlqP85e7+WpJ098vdfaa7f5Xki/n16eoTSXbNrL4zyUsbN2UAWFzzXJVdSb6U5Jnu/uzM+I6ZxT6Y5Knp+ZEkB6rq0qq6LsnuJI9t3JQBYHHNc1X2jUk+nOSHVfXENPaJJLdV1Z4sn6Z+PslHkqS7j1XV4SRPZ/mK7rtckQ0A81kzzN39vaz8vfE3z7LOwSQH1zEvANiW3PkLAAYizAAwEGEGgIEIMwAMRJgBYCDCDAADEWYAGIgwA8BAhBkABiLMADAQYQaAgQgzAAxEmAFgIMIMAAMRZgAYiDADwECEGQAGIswAMBBhBoCBCDMADESYAWAgwgwAAxFmABiIMAPAQIQZAAYizAAwEGEGgIEIMwAMRJgBYCDCDAADEWYAGIgwA8BAhBkABiLMADAQYQaAgQgzAAxEmAFgIMIMAAMRZgAYiDADwECEGQAGsmaYq2pXVX27qp6pqmNV9bFp/PKqeriqfjw9Xjazzj1Vdbyqnq2qmzbzDwAAi2SeI+bXkvxJd/+jJL+f5K6quj7J3Uke6e7dSR6ZXmf63YEkNyS5Ocnnq+qizZg8ACyaNcPc3Se7+wfT818meSbJ1Un2Jzk0LXYoyS3T8/1JHuzuV7v7uSTHk+zb4HkDwEI6p++Yq+raJO9O8miSq7r7ZLIc7yRXTotdneTFmdVOTGMAwBrmDnNVvS3JV5N8vLt/cbZFVxjrFd7vzqo6WlVHT58+Pe80AGChzRXmqroky1H+cnd/bRp+uap2TL/fkeTUNH4iya6Z1XcmeemN79nd93X33u7eu7S0dL7zB4CFMs9V2ZXkS0me6e7PzvzqSJLbp+e3J3loZvxAVV1aVdcl2Z3ksY2bMgAsrovnWObGJB9O8sOqemIa+0SSe5Mcrqo7kryQ5NYk6e5jVXU4ydNZvqL7ru4+s9ETB4BFtGaYu/t7Wfl74yR5/yrrHExycB3zAoBtyZ2/AGAgwgwAAxFmABiIMAPAQIQZAAYizAAwEGEGgIEIMwAMRJgBYCDCDAADEWYAGIgwA8BAhBkABiLMADAQYQaAgQgzAAxEmAFgIMIMAAMRZgAYiDADwECEGQAGIswAMBBhBoCBCDMADESYAWAgwgwAA7l4qycAwOJ44NEXtnoKb3qOmAFgIMIMAAMRZgAYiDADwECEGQAGIswAMBBhBoCBCDMADESYAWAgwgwAAxFmABiIMAPAQIQZAAYizAAwkDXDXFX3V9WpqnpqZuxTVfWTqnpi+vnAzO/uqarjVfVsVd20WRMHgEU0zxHznye5eYXxz3X3nunnm0lSVdcnOZDkhmmdz1fVRRs1WQBYdGuGubu/m+Tnc77f/iQPdver3f1ckuNJ9q1jfgCwraznO+aPVtWT06nuy6axq5O8OLPMiWkMAJjD+Yb5C0nekWRPkpNJPjON1wrL9kpvUFV3VtXRqjp6+vTp85wGACyW8wpzd7/c3We6+1dJvphfn64+kWTXzKI7k7y0ynvc1917u3vv0tLS+UwDABbOeYW5qnbMvPxgktev2D6S5EBVXVpV1yXZneSx9U0RALaPi9daoKq+kuS9Sa6oqhNJPpnkvVW1J8unqZ9P8pEk6e5jVXU4ydNJXktyV3ef2ZSZA8ACWjPM3X3bCsNfOsvyB5McXM+kAGC7cucvABiIMAPAQIQZAAYizAAwEGEGgIEIMwAMRJgBYCDCDAADEWYAGIgwA8BAhBkABiLMADAQYQaAgQgzAAxEmAFgIGv+f8wAvLk98OgLWz0FzoEjZgAYiDADwECEGQAGIswAMBBhBoCBCDMADMQ/lwLYAv4JE6txxAwAAxFmABiIMAPAQIQZAAYizAAwEGEGgIEIMwAMRJgBYCDCDAADEWYAGIgwA8BA3CsbYOL+1YzAETMADESYAWAgwgwAAxFmABiIMAPAQIQZAAYizAAwkDXDXFX3V9WpqnpqZuzyqnq4qn48PV4287t7qup4VT1bVTdt1sQBYBHNc4ORP0/yH5P8xczY3Uke6e57q+ru6fWfVtX1SQ4kuSHJ25N8q6re2d1nNnbawHbhph9sN2seMXf3d5P8/A3D+5Mcmp4fSnLLzPiD3f1qdz+X5HiSfRszVQBYfOf7HfNV3X0ySabHK6fxq5O8OLPciWnsN1TVnVV1tKqOnj59+jynAQCLZaMv/qoVxnqlBbv7vu7e2917l5aWNngaAPDmdL5hfrmqdiTJ9HhqGj+RZNfMcjuTvHT+0wOA7eV8w3wkye3T89uTPDQzfqCqLq2q65LsTvLY+qYIANvHmldlV9VXkrw3yRVVdSLJJ5Pcm+RwVd2R5IUktyZJdx+rqsNJnk7yWpK7XJENAPNbM8zdfdsqv3r/KssfTHJwPZMCgO3Knb8AYCDCDAADEWYAGIgwA8BAhBkABiLMADAQYQaAgQgzAAxEmAFgIMIMAAMRZgAYiDADwECEGQAGIswAMBBhBoCBCDMADESYAWAgwgwAAxFmABiIMAPAQC7e6glslgcefeGCfdaH3nPNBfssABabI2YAGIgwA8BAhBkABiLMADCQhb34C7YbFzzCYnDEDAADEWYAGIhT2cA5u5CnzWG7ccQMAAMRZgAYiDADwECEGQAGIswAMBBhBoCBCDMADESYAWAgwgwAAxFmABiIMAPAQIQZAAayrv/EoqqeT/LLJGeSvNbde6vq8iT/Lcm1SZ5P8kfd/X/WN00A2B424oj5n3b3nu7eO72+O8kj3b07ySPTawBgDptxKnt/kkPT80NJbtmEzwCAhbTeMHeSv66qx6vqzmnsqu4+mSTT45Xr/AwA2DbW9R1zkhu7+6WqujLJw1X1o3lXnEJ+Z5Jcc80165wGACyGdR0xd/dL0+OpJF9Psi/Jy1W1I0mmx1OrrHtfd+/t7r1LS0vrmQYALIzzPmKuqrcmeUt3/3J6/odJ/l2SI0luT3Lv9PjQRkwU3oweePSFrZ4C8CaznlPZVyX5elW9/j4PdPdfVtX3kxyuqjuSvJDk1vVPEwC2h/MOc3f/XZLfW2H8Z0nev55JAcB25c5fADAQYQaAgQgzAAxEmAFgIOu9wQi5sP8k5kPvcTMWgEUmzG8y/hIAsNicygaAgQgzAAxEmAFgIMIMAAMRZgAYiKuy2Xb8j0/AyBwxA8BAhBkABiLMADAQYQaAgQgzAAxEmAFgIMIMAAMRZgAYiDADwECEGQAGIswAMBD3ymZVF/Ke0h96zzUX7LMARibMDMF/LAGwzKlsABiIMAPAQIQZAAYizAAwEGEGgIEIMwAMRJgBYCDCDAADEWYAGIgwA8BAhBkABiLMADAQYQaAgQgzAAxEmAFgIMIMAAPZtDBX1c1V9WxVHa+quzfrcwBgkWxKmKvqoiT/Kck/T3J9ktuq6vrN+CwAWCSbdcS8L8nx7v677v6/SR5Msn+TPgsAFsZmhfnqJC/OvD4xjQEAZ3HxJr1vrTDW/98CVXcmuXN6+UpVPbtBn31Fkp9u0HttR7bf+th+62P7rY/td/7Ouu3+9eZ85j9caXCzwnwiya6Z1zuTvDS7QHffl+S+jf7gqjra3Xs3+n23C9tvfWy/9bH91sf2O38jbbvNOpX9/SS7q+q6qvoHSQ4kObJJnwUAC2NTjpi7+7Wq+miSv0pyUZL7u/vYZnwWACySzTqVne7+ZpJvbtb7n8WGnx7fZmy/9bH91sf2Wx/b7/wNs+2qu9deCgC4INySEwAGsjBhdgvQc1dVz1fVD6vqiao6Oo1dXlUPV9WPp8fLtnqeo6iq+6vqVFU9NTO26vaqqnum/fHZqrppa2Y9jlW236eq6ifTPvhEVX1g5ne234yq2lVV366qZ6rqWFV9bBq3D87hLNtvuH1wIU5lT7cA/V9J/lmW/6nW95Pc1t1Pb+nEBldVzyfZ290/nRn790l+3t33Tn/Buay7/3Sr5jiSqvonSV5J8hfd/a5pbMXtNd2C9itZvgve25N8K8k7u/vMFk1/y62y/T6V5JXu/vQblrX93qCqdiTZ0d0/qKrfSfJ4kluS/JvYB9d0lu33RxlsH1yUI2a3AN04+5Mcmp4fyvKOS5Lu/m6Sn79heLXttT/Jg939anc/l+R4lvfTbWuV7bca2+8Nuvtkd/9gev7LJM9k+Y6K9sE5nGX7rWbLtt+ihNktQM9PJ/nrqnp8uhNbklzV3SeT5R05yZVbNrs3h9W2l31yfh+tqienU92vn4a1/c6iqq5N8u4kj8Y+eM7esP2SwfbBRQnzmrcAZUU3dvc/zvL/AnbXdKqRjWGfnM8XkrwjyZ4kJ5N8Zhq3/VZRVW9L8tUkH+/uX5xt0RXGtv02XGH7DbcPLkqY17wFKL+pu1+aHk8l+XqWT9O8PH0X8/p3Mqe2boZvCqttL/vkHLr75e4+092/SvLF/PpUoe23gqq6JMtR+XJ3f20atg/OaaXtN+I+uChhdgvQc1RVb50ugEhVvTXJHyZ5Ksvb7fZpsduTPLQ1M3zTWG17HUlyoKourarrkuxO8tgWzG9orwdl8sEs74OJ7fcbqqqSfCnJM9392Zlf2QfnsNr2G3Ef3LQ7f11IbgF6Xq5K8vXlfTUXJ3mgu/+yqr6f5HBV3ZHkhSS3buEch1JVX0ny3iRXVNWJJJ9Mcm9W2F7dfayqDid5OslrSe7arlfDvm6V7ffeqtqT5VOEzyf5SGL7reLGJB9O8sOqemIa+0Tsg/NabfvdNto+uBD/XAoAFsWinMoGgIUgzAAwEGEGgIEIMwAMRJgBYCDCDAADEWYAGIgwA8BA/h9z5OquxvlH1gAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 576x576 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "sns.distplot(summary_lengths, kde=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0.8392255892255892\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAeYAAAHTCAYAAADyJLvRAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAAU20lEQVR4nO3dbYyld3nf8d9VbyA8FGHXa9f4oWsqN60bqYWuMIQKoTgJJEHYL4rkGNptQ2VVoi1JWwW7SEV9EQmaKE2rtqksIHEabGQRUlsoD7gmEaoUlq55tDGuTUyWBWNvGiUhiQQ4ufpibsSwmWV35+zOXnPm85FW55z/Offc/793mS/3fc7cU90dAGCGv3S+JwAAfJMwA8AgwgwAgwgzAAwizAAwiDADwCCnDHNVvbuqnqqqBzeN/VRVfbaqPlVVv1JVz9/03G1V9VhVPVJVrzpH8waAtVSn+jnmqnpFkj9O8ovd/d3L2A8k+VB3P11V70iS7n5LVV2b5K4kL0nygiT/K8nf6O4/+3b7uPjii/vAgQOrrgUAdo0HHnjg97p7/4nj+061YXd/uKoOnDD2wU0PP5LkHyz3b0jy3u7+apLHq+qxbET6t7/dPg4cOJAjR46caioAsDaq6ne3Gj8b7zH/aJJfW+5fnuQLm547towBAKdhpTBX1VuTPJ3kPd8Y2uJlW54rr6pbqupIVR05fvz4KtMAgLWx7TBX1aEkr0ny+v7mG9XHkly56WVXJPnSVtt39+3dfbC7D+7f/xdOsQPAnrStMFfVq5O8Jclru/tPNz11b5KbquqZVXV1kmuSfHT1aQLA3nDKD39V1V1JXpnk4qo6luRtSW5L8swk91VVknyku/9Zdz9UVXcn+Uw2TnG/6VSfyAYAvumUPy61Ew4ePNg+lQ3AXlJVD3T3wRPHXfkLAAYRZgAYRJgBYBBhBoBBhBkABhFmABhEmAFgEGEGgEGEGQAGEWYAGESYAWAQYQaAQYQZAAY55a99hJ1w5+GjO7avm6+7asf2BXCmHDEDwCDCDACDCDMADCLMADCIMAPAIMIMAIMIMwAMIswAMIgwA8AgwgwAgwgzAAwizAAwiDADwCDCDACDCDMADCLMADCIMAPAIMIMAIMIMwAMIswAMIgwA8AgwgwAgwgzAAwizAAwyL7zPQFYZ3cePrpj+7r5uqt2bF/AueOIGQAGEWYAGESYAWAQYQaAQYQZAAYRZgAYRJgBYBBhBoBBhBkABhFmABhEmAFgEGEGgEGEGQAGEWYAGESYAWAQYQaAQYQZAAYRZgAYRJgBYBBhBoBB9p3vCXBm7jx8dMf2dfN1V+3YvgDY4IgZAAYRZgAYRJgBYJBThrmq3l1VT1XVg5vGLqqq+6rq0eX2wk3P3VZVj1XVI1X1qnM1cQBYR6dzxPwLSV59wtitSe7v7muS3L88TlVdm+SmJH972ea/VdUFZ222ALDmThnm7v5wkt8/YfiGJHcs9+9IcuOm8fd291e7+/EkjyV5ydmZKgCsv+2+x3xpdz+RJMvtJcv45Um+sOl1x5YxAOA0nO0Pf9UWY73lC6tuqaojVXXk+PHjZ3kaALA7bTfMT1bVZUmy3D61jB9LcuWm112R5EtbfYHuvr27D3b3wf37929zGgCwXrYb5nuTHFruH0pyz6bxm6rqmVV1dZJrknx0tSkCwN5xyktyVtVdSV6Z5OKqOpbkbUnenuTuqnpjkqNJXpck3f1QVd2d5DNJnk7ypu7+s3M0dwBYO6cMc3f/yEmeuv4kr//JJD+5yqQAYK9y5S8AGESYAWAQYQaAQYQZAAYRZgAYRJgBYBBhBoBBhBkABhFmABjklFf+gnVz5+Gj53sKACfliBkABhFmABhEmAFgEGEGgEGEGQAGEWYAGESYAWAQYQaAQYQZAAYRZgAYRJgBYBBhBoBBhBkABhFmABhEmAFgEGEGgEGEGQAGEWYAGESYAWAQYQaAQYQZAAYRZgAYRJgBYBBhBoBBhBkABhFmABhEmAFgEGEGgEGEGQAGEWYAGESYAWAQYQaAQYQZAAYRZgAYRJgBYJB953sCwNlx5+GjO7avm6+7asf2BXuNI2YAGESYAWAQYQaAQYQZAAYRZgAYRJgBYBA/LsVJ7eSP3wCwwREzAAwizAAwiDADwCDCDACDCDMADCLMADCIMAPAIMIMAIMIMwAMIswAMMhKYa6qH6+qh6rqwaq6q6q+s6ouqqr7qurR5fbCszVZAFh32w5zVV2e5F8mOdjd353kgiQ3Jbk1yf3dfU2S+5fHAMBpWPVU9r4kz6qqfUmeneRLSW5Icsfy/B1JblxxHwCwZ2w7zN39xSQ/neRokieS/GF3fzDJpd39xPKaJ5JccjYmCgB7wSqnsi/MxtHx1UlekOQ5VfWGM9j+lqo6UlVHjh8/vt1pAMBaWeVU9vcleby7j3f315O8P8n3JHmyqi5LkuX2qa027u7bu/tgdx/cv3//CtMAgPWxSpiPJnlpVT27qirJ9UkeTnJvkkPLaw4luWe1KQLA3rFvuxt29+Gqel+SjyV5OsnHk9ye5LlJ7q6qN2Yj3q87GxMFgL1g22FOku5+W5K3nTD81WwcPQMAZ8iVvwBgEGEGgEGEGQAGEWYAGESYAWCQlT6VDexNdx4+umP7uvm6q3ZsXzCBI2YAGESYAWAQYQaAQYQZAAYRZgAYRJgBYBBhBoBBhBkABhFmABhEmAFgEGEGgEGEGQAGEWYAGESYAWAQYQaAQYQZAAYRZgAYRJgBYBBhBoBBhBkABhFmABhEmAFgEGEGgEGEGQAGEWYAGESYAWAQYQaAQYQZAAYRZgAYRJgBYBBhBoBBhBkABhFmABhEmAFgEGEGgEGEGQAGEWYAGESYAWAQYQaAQYQZAAYRZgAYRJgBYBBhBoBBhBkABhFmABhEmAFgEGEGgEGEGQAGEWYAGESYAWAQYQaAQYQZAAYRZgAYRJgBYBBhBoBBhBkABhFmABhkpTBX1fOr6n1V9dmqeriqXlZVF1XVfVX16HJ74dmaLACsu1WPmP9Tkl/v7r+Z5O8keTjJrUnu7+5rkty/PAYATsO2w1xVz0vyiiTvSpLu/lp3/0GSG5LcsbzsjiQ3rjZFANg7VjlifmGS40l+vqo+XlXvrKrnJLm0u59IkuX2krMwTwDYE1YJ874kL07yc939oiR/kjM4bV1Vt1TVkao6cvz48RWmAQDrY5UwH0tyrLsPL4/fl41QP1lVlyXJcvvUVht39+3dfbC7D+7fv3+FaQDA+th2mLv7y0m+UFXftQxdn+QzSe5NcmgZO5TknpVmCAB7yL4Vt/8XSd5TVc9I8jtJ/kk2Yn93Vb0xydEkr1txHwCwZ6wU5u7+RJKDWzx1/SpfFwD2Klf+AoBBhBkABhFmABhEmAFgEGEGgEGEGQAGEWYAGESYAWAQYQaAQYQZAAYRZgAYRJgBYBBhBoBBhBkABhFmABhEmAFgEGEGgEGEGQAGEWYAGESYAWAQYQaAQYQZAAYRZgAYRJgBYJB953sC6+DOw0fP9xQAWBOOmAFgEGEGgEGcygZY7OTbUjdfd9WO7YvdxREzAAwizAAwiDADwCDCDACDCDMADCLMADCIMAPAIMIMAIMIMwAMIswAMIgwA8AgwgwAgwgzAAwizAAwiF/7CIy2k7+KESZwxAwAgwgzAAziVDbAmtvJtwNuvu6qHdvXunLEDACDCDMADCLMADCI95gBzgM/BsbJOGIGgEGEGQAGEWYAGESYAWAQYQaAQYQZAAYRZgAYRJgBYBBhBoBBhBkABhFmABhEmAFgEGEGgEFWDnNVXVBVH6+qDyyPL6qq+6rq0eX2wtWnCQB7w9k4Yn5zkoc3Pb41yf3dfU2S+5fHAMBpWCnMVXVFkh9O8s5NwzckuWO5f0eSG1fZBwDsJaseMf9skp9I8uebxi7t7ieSZLm9ZMV9AMCese0wV9VrkjzV3Q9sc/tbqupIVR05fvz4dqcBAGtllSPmlyd5bVV9Psl7k3xvVf1Skier6rIkWW6f2mrj7r69uw9298H9+/evMA0AWB/bDnN339bdV3T3gSQ3JflQd78hyb1JDi0vO5TknpVnCQB7xLn4Oea3J/n+qno0yfcvjwGA07DvbHyR7v6tJL+13P9/Sa4/G18XAPYaV/4CgEGEGQAGOSunsie68/DR8z0FADhjjpgBYBBhBoBBhBkABhFmABhEmAFgEGEGgEGEGQAGEWYAGESYAWAQYQaAQYQZAAYRZgAYRJgBYBBhBoBBhBkABhFmABhEmAFgEGEGgEGEGQAGEWYAGESYAWAQYQaAQYQZAAYRZgAYRJgBYBBhBoBBhBkABhFmABhEmAFgEGEGgEGEGQAGEWYAGESYAWAQYQaAQYQZAAYRZgAYRJgBYBBhBoBBhBkABtl3vicAANtx5+GjO7avm6+7asf25YgZAAYRZgAYRJgBYBBhBoBBhBkABhFmABhEmAFgEGEGgEGEGQAGEWYAGESYAWAQYQaAQYQZAAbx26UAOGt28jc+rStHzAAwiDADwCDCDACDCDMADCLMADCIMAPAINsOc1VdWVW/WVUPV9VDVfXmZfyiqrqvqh5dbi88e9MFgPW2yhHz00n+dXf/rSQvTfKmqro2ya1J7u/ua5LcvzwGAE7DtsPc3U9098eW+19J8nCSy5PckOSO5WV3JLlxxTkCwJ5xVt5jrqoDSV6U5HCSS7v7iWQj3kkuORv7AIC9YOUwV9Vzk/xykh/r7j86g+1uqaojVXXk+PHjq04DANbCSmGuqu/IRpTf093vX4afrKrLlucvS/LUVtt29+3dfbC7D+7fv3+VaQDA2ljlU9mV5F1JHu7un9n01L1JDi33DyW5Z/vTA4C9ZZXfLvXyJP8wyaer6hPL2L9N8vYkd1fVG5McTfK6lWYIAHvItsPc3f87SZ3k6eu3+3UBYC9z5S8AGESYAWAQYQaAQYQZAAYRZgAYRJgBYBBhBoBBhBkABhFmABhEmAFgEGEGgEGEGQAGEWYAGESYAWAQYQaAQYQZAAYRZgAYRJgBYBBhBoBBhBkABhFmABhEmAFgEGEGgEGEGQAGEWYAGESYAWAQYQaAQYQZAAYRZgAYRJgBYBBhBoBBhBkABhFmABhEmAFgEGEGgEGEGQAGEWYAGESYAWAQYQaAQYQZAAYRZgAYRJgBYBBhBoBBhBkABhFmABhEmAFgEGEGgEGEGQAGEWYAGESYAWAQYQaAQYQZAAYRZgAYRJgBYBBhBoBBhBkABhFmABhEmAFgEGEGgEGEGQAGEWYAGESYAWAQYQaAQc5ZmKvq1VX1SFU9VlW3nqv9AMA6OSdhrqoLkvzXJD+Y5NokP1JV156LfQHAOjlXR8wvSfJYd/9Od38tyXuT3HCO9gUAa+NchfnyJF/Y9PjYMgYAfBv7ztHXrS3G+lteUHVLkluWh39cVY+c4T4uTvJ725jbbrDOa0vWe33Wtnut8/qsbUWvPzdf9q9tNXiuwnwsyZWbHl+R5EubX9Ddtye5fbs7qKoj3X1wu9tPts5rS9Z7fda2e63z+qxtdzlXp7L/T5JrqurqqnpGkpuS3HuO9gUAa+OcHDF399NV9c+T/EaSC5K8u7sfOhf7AoB1cq5OZae7fzXJr56rr58VToPvAuu8tmS912dtu9c6r8/adpHq7lO/CgDYES7JCQCD7Low7/ZLfVbVlVX1m1X1cFU9VFVvXsYvqqr7qurR5fbCTdvctqz3kap61fmb/empqguq6uNV9YHl8Tqt7flV9b6q+uzyd/iydVlfVf348m/ywaq6q6q+czevrareXVVPVdWDm8bOeD1V9feq6tPLc/+5qrb6cdAddZK1/dTy7/JTVfUrVfX8Tc/tmrUlW69v03P/pqq6qi7eNLar1ndK3b1r/mTjg2SfS/LCJM9I8skk157veZ3hGi5L8uLl/l9O8n+zcdnS/5Dk1mX81iTvWO5fu6zzmUmuXtZ/wflexynW+K+S3JnkA8vjdVrbHUn+6XL/GUmevw7ry8YFgB5P8qzl8d1J/vFuXluSVyR5cZIHN42d8XqSfDTJy7JxfYZfS/KDQ9f2A0n2LfffsVvXdrL1LeNXZuNDxb+b5OLdur5T/dltR8y7/lKf3f1Ed39suf+VJA9n45viDdn4pp/l9sbl/g1J3tvdX+3ux5M8lo3/DiNV1RVJfjjJOzcNr8vanpeNbxjvSpLu/lp3/0HWZH3Z+DDos6pqX5JnZ+PaA7t2bd394SS/f8LwGa2nqi5L8rzu/u3e+E7/i5u2OW+2Wlt3f7C7n14efiQb149IdtnakpP+3SXJf0zyE/nWC1btuvWdym4L81pd6rOqDiR5UZLDSS7t7ieSjXgnuWR52W5b889m4384f75pbF3W9sIkx5P8/HKq/p1V9Zyswfq6+4tJfjrJ0SRPJPnD7v5g1mBtJzjT9Vy+3D9xfLofzcYRYrIma6uq1yb5Ynd/8oSn1mJ9m+22MJ/yUp+7RVU9N8kvJ/mx7v6jb/fSLcZGrrmqXpPkqe5+4HQ32WJs5NoW+7Jxeu3nuvtFSf4kG6dDT2bXrG95r/WGbJwKfEGS51TVG77dJluMjVzbaTrZenbdOqvqrUmeTvKebwxt8bJdtbaqenaStyb5d1s9vcXYrlrfiXZbmE95qc/doKq+IxtRfk93v38ZfnI59ZLl9qllfDet+eVJXltVn8/G2wzfW1W/lPVYW7Ix32PdfXh5/L5shHod1vd9SR7v7uPd/fUk70/yPVmPtW12pus5lm+eEt48PlJVHUrymiSvX07fJuuxtr+ejf/T+Mnl+8sVST5WVX8167G+b7HbwrzrL/W5fCrwXUke7u6f2fTUvUkOLfcPJbln0/hNVfXMqro6yTXZ+EDDON19W3df0d0HsvF386HufkPWYG1J0t1fTvKFqvquZej6JJ/JeqzvaJKXVtWzl3+j12fj8w/rsLbNzmg9y+nur1TVS5f/Lv9o0zajVNWrk7wlyWu7+083PbXr19bdn+7uS7r7wPL95Vg2PkT75azB+v6C8/3pszP9k+SHsvFJ5s8leev5ns825v/3s3E65VNJPrH8+aEkfyXJ/UkeXW4v2rTNW5f1PpJd8qnCJK/MNz+VvTZrS/J3kxxZ/v7+Z5IL12V9Sf59ks8meTDJ/8jGp1x37dqS3JWN98u/no1v5G/cznqSHFz+m3wuyX/JcmGmgWt7LBvvtX7j+8p/341rO9n6Tnj+81k+lb0b13eqP678BQCD7LZT2QCw1oQZAAYRZgAYRJgBYBBhBoBBhBkABhFmABhEmAFgkP8PRWq9C03CpTkAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 576x576 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "new_descr_lengths = [length for length in descr_lengths if length <= 1500]\n",
    "print(len(new_descr_lengths) / len(descr_lengths))\n",
    "sns.distplot(new_descr_lengths, kde=False)"
   ]
  }
 ],
 "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.6.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}