Future Sign Up Analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Native imports\n",
    "import os\n",
    "import json\n",
    "\n",
    "# Import .env into loaded environment variables\n",
    "from dotenv import load_dotenv\n",
    "load_dotenv('../sc-backend/.env.dev')\n",
    "\n",
    "# MongoDB Python driver import\n",
    "import pymongo\n",
    "\n",
    "# 3rd-party data science imports\n",
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "pd.set_option('display.max_rows', None)\n",
    "\n",
    "OUTPUT_ORG_INFO_FILE = 'org-info.json'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Step 0: Load the data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>name</th>\n",
       "      <th>email</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>180 Degrees Consulting at Berkeley</td>\n",
       "      <td>berkeley@180dc.org</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3D Modeling and Animation at Berkeley</td>\n",
       "      <td>3dma.at.berkeley@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5&amp;2 Community Service</td>\n",
       "      <td>fiveandtwo.berkeley@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A Better Way at Berkeley</td>\n",
       "      <td>victorjann@berkeley.edu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ABA</td>\n",
       "      <td>tiffany.s.y.chen@berkeley.edu</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    name                          email\n",
       "0     180 Degrees Consulting at Berkeley             berkeley@180dc.org\n",
       "1  3D Modeling and Animation at Berkeley     3dma.at.berkeley@gmail.com\n",
       "2                  5&2 Community Service  fiveandtwo.berkeley@gmail.com\n",
       "3               A Better Way at Berkeley        victorjann@berkeley.edu\n",
       "4                                    ABA  tiffany.s.y.chen@berkeley.edu"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "with open(OUTPUT_ORG_INFO_FILE, 'r') as fp:\n",
    "    club_info_json = json.load(fp)\n",
    "club_json_df = pd.DataFrame(club_info_json)\n",
    "club_json_df = club_json_df[['name', 'email']]\n",
    "club_json_df['name'].apply(lambda s: s if pd.isna(s) else s.strip())\n",
    "club_json_df['email'].apply(lambda s: s if pd.isna(s) else s.lower().strip())\n",
    "club_json_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1024\n"
     ]
    }
   ],
   "source": [
    "club_json_df_copy = club_json_df.copy()\n",
    "club_json_df_copy = club_json_df_copy[~pd.isna(club_json_df_copy['email'])]\n",
    "club_json_df_copy.to_csv('callink-club-info.csv')\n",
    "print(len(club_json_df_copy))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "conn_string = os.getenv('MONGO_URI')\n",
    "client = pymongo.MongoClient(conn_string)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>name</th>\n",
       "      <th>email</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Phi Alpha Theta</td>\n",
       "      <td>phat.berkeley@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Berkeley Engineers and Mentors--BEAM</td>\n",
       "      <td>beam.teach@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Phoenix Consulting Group</td>\n",
       "      <td>nian_s@berkeley.edu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Product Space at UC Berkeley</td>\n",
       "      <td>cal@productspace.org</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>The Berkeley Alt. Protein Project</td>\n",
       "      <td>berkeleyaltprotein@gmail.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   name                         email\n",
       "0                       Phi Alpha Theta       phat.berkeley@gmail.com\n",
       "1  Berkeley Engineers and Mentors--BEAM          beam.teach@gmail.com\n",
       "2              Phoenix Consulting Group           nian_s@berkeley.edu\n",
       "3          Product Space at UC Berkeley          cal@productspace.org\n",
       "4     The Berkeley Alt. Protein Project  berkeleyaltprotein@gmail.com"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "club_info_db = []\n",
    "for club in client['develop-db']['future_user'].find():\n",
    "    club_info_db += [{'name': club['org_name'].strip(), 'email': club['org_email'].lower().strip()}]\n",
    "club_db_df = pd.DataFrame(club_info_db)\n",
    "club_db_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>name_x</th>\n",
       "      <th>email</th>\n",
       "      <th>name_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5&amp;2 Community Service</td>\n",
       "      <td>fiveandtwo.berkeley@gmail.com</td>\n",
       "      <td>5&amp;2 Berkeley</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Abba Modern</td>\n",
       "      <td>abbamodern@gmail.com</td>\n",
       "      <td>Abba Modern</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>acts2fellowship</td>\n",
       "      <td>info@acts2fellowship.org</td>\n",
       "      <td>acts2fellowship</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AFX Dance</td>\n",
       "      <td>afxdance@gmail.com</td>\n",
       "      <td>AFX Dance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alternative Breaks</td>\n",
       "      <td>berkeleyaltbreaks@gmail.com</td>\n",
       "      <td>Alternative Breaks</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  name_x                          email              name_y\n",
       "0  5&2 Community Service  fiveandtwo.berkeley@gmail.com        5&2 Berkeley\n",
       "1            Abba Modern           abbamodern@gmail.com         Abba Modern\n",
       "2        acts2fellowship       info@acts2fellowship.org     acts2fellowship\n",
       "3              AFX Dance             afxdance@gmail.com           AFX Dance\n",
       "4     Alternative Breaks    berkeleyaltbreaks@gmail.com  Alternative Breaks"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "existing_clubs_df = pd.merge(club_json_df, club_db_df, how='inner', on='email')\n",
    "existing_clubs_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "# of clubs on CalLink: 1309\n",
      "# of clubs on Sproul.club: 199\n",
      "\n",
      "# of clubs on both platforms: 124\n",
      "% of signed up clubs within CalLink: 62.3%\n"
     ]
    }
   ],
   "source": [
    "signed_up_clubs_in_callink_percent = len(existing_clubs_df) / len(club_db_df) * 100\n",
    "print('# of clubs on CalLink:', len(club_json_df))\n",
    "print('# of clubs on Sproul.club:', len(club_db_df))\n",
    "print()\n",
    "print('# of clubs on both platforms:', len(existing_clubs_df))\n",
    "print('%% of signed up clubs within CalLink: %.1f%%' % signed_up_clubs_in_callink_percent)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Step 1a: Merge data by same email"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "scrolled": true
   },
   "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>name_callink</th>\n",
       "      <th>email</th>\n",
       "      <th>name_mongo</th>\n",
       "      <th>match</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5&amp;2 Community Service</td>\n",
       "      <td>fiveandtwo.berkeley@gmail.com</td>\n",
       "      <td>5&amp;2 Berkeley</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Abba Modern</td>\n",
       "      <td>abbamodern@gmail.com</td>\n",
       "      <td>Abba Modern</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>acts2fellowship</td>\n",
       "      <td>info@acts2fellowship.org</td>\n",
       "      <td>acts2fellowship</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AFX Dance</td>\n",
       "      <td>afxdance@gmail.com</td>\n",
       "      <td>AFX Dance</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alternative Breaks</td>\n",
       "      <td>berkeleyaltbreaks@gmail.com</td>\n",
       "      <td>Alternative Breaks</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>American Chemical Society at Berkeley Student ...</td>\n",
       "      <td>acsberkeley@gmail.com</td>\n",
       "      <td>American Chemical Society at Berkeley (ACS@Ber...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>American Medical Student Association--Berkeley...</td>\n",
       "      <td>berkeleyamsa@gmail.com</td>\n",
       "      <td>American Medical Student Association</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Artists in Resonance</td>\n",
       "      <td>artistsinresonanceucb@gmail.com</td>\n",
       "      <td>Artists in Resonance</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Asha for Education, Berkeley</td>\n",
       "      <td>berkeley@ashanet.org</td>\n",
       "      <td>Asha for Education, Berkeley</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Asian American and Pacific Islander Health Res...</td>\n",
       "      <td>aapihrg.info@gmail.com</td>\n",
       "      <td>Asian American and Pacific Islander Health Res...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Asian Pacific American Pre-Law Association</td>\n",
       "      <td>ucb.apapla@gmail.com</td>\n",
       "      <td>Asian Pacific American Pre-Law Association</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Assistants, Therapists, And Practitioners at B...</td>\n",
       "      <td>atpucberk@gmail.com</td>\n",
       "      <td>Assistants, Therapists, and Practitioners</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Association for Socially Responsible Business</td>\n",
       "      <td>asrbatberkeley@gmail.com</td>\n",
       "      <td>Association for Socially Responsible Business ...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>ASUC - Innovative Design</td>\n",
       "      <td>innovativedesignatcal@gmail.com</td>\n",
       "      <td>Innovative Design</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>ASUC Mental Health Commission</td>\n",
       "      <td>mentalhealthcommission@asuc.org</td>\n",
       "      <td>ASUC Mental Health Commission</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>ASUC Student Legal Clinic</td>\n",
       "      <td>asuclegalclinic@gmail.com</td>\n",
       "      <td>ASUC Student Legal Clinic</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>ASUC Technology Office- Chief Technology Offic...</td>\n",
       "      <td>technology@asuc.org</td>\n",
       "      <td>ASUC Office of the CTO</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Aurum Cosmetics</td>\n",
       "      <td>calaurumcosmetics@gmail.com</td>\n",
       "      <td>Aurum Cosmetics</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Ballet Folklorico Reflejos De Mexico</td>\n",
       "      <td>reflejosdemexico.cal@gmail.com</td>\n",
       "      <td>Ballet Folklorico Reflejos de Mexico</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Bay Area Environmentally Aware Consulting Network</td>\n",
       "      <td>info@beacn.berkeley.edu</td>\n",
       "      <td>BEACN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Berkeley Art Museum Pacific Film Archive Stude...</td>\n",
       "      <td>bampfasc@berkeley.edu</td>\n",
       "      <td>BAMPFA Student Committee</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Berkeley Forum, The</td>\n",
       "      <td>info@forum.berkeley.edu</td>\n",
       "      <td>The Berkeley Forum</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Berkeley Innovation</td>\n",
       "      <td>berkeley.innovation@gmail.com</td>\n",
       "      <td>Berkeley Innovation</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Berkeley Scientific Journal</td>\n",
       "      <td>bsj.berkeley@gmail.com</td>\n",
       "      <td>Berkeley Scientific Journal</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Berkeley Tennis Association (Formerly Tennis a...</td>\n",
       "      <td>berkeleytennisassociation@gmail.com</td>\n",
       "      <td>Berkeley Tennis Association</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Bhagat Puran Singh Health Initiative at Berkeley</td>\n",
       "      <td>ucberkeley@bpshi.com</td>\n",
       "      <td>UC Berkeley BPSHI</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Big Data at Berkeley</td>\n",
       "      <td>bigdata.berkeley@gmail.com</td>\n",
       "      <td>Big Data at Berkeley</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>BioethiCAL</td>\n",
       "      <td>bioethical.berkeley@gmail.com</td>\n",
       "      <td>BioethiCAL</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Biofuels Technology Club</td>\n",
       "      <td>biofuelstechnology@gmail.com</td>\n",
       "      <td>Biofuels Technology Club</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Blockchain at Berkeley (formerly Bitcoin Assoc...</td>\n",
       "      <td>admin@blockchain.berkeley.edu</td>\n",
       "      <td>Blockchain at Berkeley</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Blockeley</td>\n",
       "      <td>info@blockeley.com</td>\n",
       "      <td>Blockeley</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Blueprint, Technology for Nonprofits</td>\n",
       "      <td>team@calblueprint.org</td>\n",
       "      <td>Blueprint, Technology for Nonprofits</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>BridgeUSA at Berkeley</td>\n",
       "      <td>bridgeusa.berkeley@gmail.com</td>\n",
       "      <td>BridgeUSA</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Business Careers in Entertainment Club</td>\n",
       "      <td>calbcec@gmail.com</td>\n",
       "      <td>Business Careers in Entertainment Club (BCEC)</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Business Review at Berkeley</td>\n",
       "      <td>businessreviewatberkeley@gmail.com</td>\n",
       "      <td>Business Review at Berkeley</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Business Transfer Network of Berkeley</td>\n",
       "      <td>btnexecboard@btn.berkeley.edu</td>\n",
       "      <td>Business Transfer Network</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Cal Figure Skating</td>\n",
       "      <td>ucbfigureskating@gmail.com</td>\n",
       "      <td>Cal Figure Skating</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Cal Seismic Design Team</td>\n",
       "      <td>calseismicteam@gmail.com</td>\n",
       "      <td>Cal Seismic Design Team</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>California Health Professional Student Allianc...</td>\n",
       "      <td>cahpsa.berkeley@gmail.com</td>\n",
       "      <td>California Health Professional Student Alliance</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Californians, The</td>\n",
       "      <td>berkeleyscc@gmail.com</td>\n",
       "      <td>Senior Class Council</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>CalSol</td>\n",
       "      <td>calsol-me@berkeley.edu</td>\n",
       "      <td>CalSol</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>CMG Strategy Consulting (Formerly Creative Mar...</td>\n",
       "      <td>berkeleycmg@gmail.com</td>\n",
       "      <td>CMG Strategy Consulting</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Codebase</td>\n",
       "      <td>contact@codebase.berkeley.edu</td>\n",
       "      <td>Codebase</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Codeology</td>\n",
       "      <td>info@codeology.club</td>\n",
       "      <td>Codeology</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Computer Science Mentors</td>\n",
       "      <td>mentors@berkeley.edu</td>\n",
       "      <td>Computer Science Mentors (CSM)</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Crossroads Christian Fellowship: Chinese for C...</td>\n",
       "      <td>xroadscf@gmail.com</td>\n",
       "      <td>Crossroads Christian Fellowship</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Cub Support</td>\n",
       "      <td>ucbears4cubs@gmail.com</td>\n",
       "      <td>Cub Support</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Dance the Bay</td>\n",
       "      <td>dancethebay@gmail.com</td>\n",
       "      <td>Dance the Bay</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Danceworx</td>\n",
       "      <td>dwxpresidents@gmail.com</td>\n",
       "      <td>Danceworx</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Data Science Society at Berkeley</td>\n",
       "      <td>info@dss.berkeley.edu</td>\n",
       "      <td>Data Science Society @ Berkeley</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>DataStory</td>\n",
       "      <td>datastory.president@gmail.com</td>\n",
       "      <td>DataStory</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Delta Phi Epsilon Co-ed Professional Foreign S...</td>\n",
       "      <td>berkeleydpe@gmail.com</td>\n",
       "      <td>Delta Phi Epsilon: Professional Co-Ed Foreign ...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Delta Xi Phi Multicultural Sorority</td>\n",
       "      <td>ucbdeltaxiphi@gmail.com</td>\n",
       "      <td>Delta Xi Phi Multicultural Sorority</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Design at Berkeley</td>\n",
       "      <td>designatberk@gmail.com</td>\n",
       "      <td>Design at Berkeley</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>DiversaTech</td>\n",
       "      <td>diversatech.berkeley@gmail.com</td>\n",
       "      <td>DiversaTech</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Eggster Organization</td>\n",
       "      <td>eggsteroverall@gmail.com</td>\n",
       "      <td>Eggster Organization</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Engineers and Mentors of Berkeley</td>\n",
       "      <td>beam.teach@gmail.com</td>\n",
       "      <td>Berkeley Engineers and Mentors--BEAM</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>EthiCAL Apparel</td>\n",
       "      <td>ethicalapparel@gmail.com</td>\n",
       "      <td>Ethical Apparel</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>EXP Dance</td>\n",
       "      <td>expdancecrew@gmail.com</td>\n",
       "      <td>EXP Dance</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Extended Reality at Berkeley</td>\n",
       "      <td>contact@xr.berkeley.edu</td>\n",
       "      <td>Extended Reality at Berkeley</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Formula Electric at Berkeley (Formerly bLoop)</td>\n",
       "      <td>contact@ev.berkeley.edu</td>\n",
       "      <td>Formula Electric at Berkeley</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Formula SAE (Society of Automotive Engineers)</td>\n",
       "      <td>fsae@me.berkeley.edu</td>\n",
       "      <td>Berkeley Formula Racing</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Future Business Leaders of America-Phi Beta La...</td>\n",
       "      <td>execs@pbl.berkeley.edu</td>\n",
       "      <td>Berkeley Phi Beta Lambda</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>Game Design and Development at Berkeley</td>\n",
       "      <td>calgamedev@berkeley.edu</td>\n",
       "      <td>Game Design and Development @ Berkeley</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Gamma Rho Lambda</td>\n",
       "      <td>lambda@gammarholambda.org</td>\n",
       "      <td>Gamma Rho Lambda</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Girls Teaching Girls to Code at Berkeley</td>\n",
       "      <td>ucberkeley@girlsteachinggirlstocode.org</td>\n",
       "      <td>Girls Teaching Girls to Code</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Girls Who Code at Berkeley</td>\n",
       "      <td>gwcberkeley@gmail.com</td>\n",
       "      <td>Girls Who Code at Berkeley</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>Global Research and Consulting Group at Berkeley</td>\n",
       "      <td>berkeley@grcglobalgroup.com</td>\n",
       "      <td>Global Research and Consulting Group at Berkeley</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>GlobeMed at Berkeley</td>\n",
       "      <td>berkeley@globemed.org</td>\n",
       "      <td>GlobeMed at Berkeley</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Haas Business School Association</td>\n",
       "      <td>hbsageneral@gmail.com</td>\n",
       "      <td>Haas Business School Association (HBSA)</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Hack the Bay</td>\n",
       "      <td>team@calhacks.io</td>\n",
       "      <td>Cal Hacks</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Hep B Project</td>\n",
       "      <td>hepbproject@gmail.com</td>\n",
       "      <td>Hep B Project</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Her Campus of Berkeley</td>\n",
       "      <td>hc.ucberkeley@hercampus.com</td>\n",
       "      <td>Her Campus at Berkeley</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Human Powered Vehicle</td>\n",
       "      <td>hpv-me@berkeley.edu</td>\n",
       "      <td>Human Powered Vehicle Team</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Indian Students Association</td>\n",
       "      <td>contact@isa.berkeley.edu</td>\n",
       "      <td>Indian Students Association</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Institute of Industrial and Systems Engineers</td>\n",
       "      <td>iise@berkeley.edu</td>\n",
       "      <td>Institute of Industrial and Systems Engineers ...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Invention Corps of Berkeley</td>\n",
       "      <td>inventioncorps@icb.berkeley.edu</td>\n",
       "      <td>Invention Corps Berkeley</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Jericho!</td>\n",
       "      <td>jerichocomedy@gmail.com</td>\n",
       "      <td>jericho! improv and sketch comedy</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Kappa Gamma Delta</td>\n",
       "      <td>ucbkgdpresident@gmail.com</td>\n",
       "      <td>Kappa Gamma Delta</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Kendo Club</td>\n",
       "      <td>kendoclub.berkeley@gmail.com</td>\n",
       "      <td>Kendo Club at Berkeley</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Kidney Disease Screening and Awareness Program</td>\n",
       "      <td>berkeleykdsap@gmail.com</td>\n",
       "      <td>Kidney Disease Screening and Awareness Program...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Launchpad</td>\n",
       "      <td>team@callaunchpad.org</td>\n",
       "      <td>Launchpad</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Legends of Berkeley</td>\n",
       "      <td>berkeleyleagueoflegends@gmail.com</td>\n",
       "      <td>Berkeley Legends</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Liberty in North Korea at Berkeley</td>\n",
       "      <td>linkbayarea@gmail.com</td>\n",
       "      <td>Liberty in North Korea (LiNK) at Berkeley</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>LW Passion Fellowship</td>\n",
       "      <td>passionlivingwater@gmail.com</td>\n",
       "      <td>LW Passion Fellowship</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Medical Reallocation Initiative</td>\n",
       "      <td>contact@mri.berkeley.edu</td>\n",
       "      <td>Medical Reallocation Initiative</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>Microfinance at Berkeley</td>\n",
       "      <td>berkeleymicrofinance@gmail.com</td>\n",
       "      <td>Microfinance at Berkeley</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>Mobile Developers of Berkeley</td>\n",
       "      <td>contact@mdb.dev</td>\n",
       "      <td>Mobile Developers of Berkeley</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Molecular and Cell Biology Cell Developmental ...</td>\n",
       "      <td>mcbcdna@gmail.com</td>\n",
       "      <td>Molecular &amp; Cell Biology, Cell Developmental, ...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>Molecular Cell Biology Undergraduate Student A...</td>\n",
       "      <td>mcbusa@gmail.com</td>\n",
       "      <td>mcbUSA</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>Music Connection, The</td>\n",
       "      <td>tmcberkeley@gmail.com</td>\n",
       "      <td>The Music Connection</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Nikkei Student Union</td>\n",
       "      <td>berkeleynsu@gmail.com</td>\n",
       "      <td>Nikkei Student Union</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>Partners In Health Engage at Berkeley</td>\n",
       "      <td>pih.engage.ucberkeley@gmail.com</td>\n",
       "      <td>Partners in Health Engage</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>Peer Health Exchange</td>\n",
       "      <td>ucb.phe@gmail.com</td>\n",
       "      <td>Peer Health Exchange</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Perennial : The Undergraduate Environmental Jo...</td>\n",
       "      <td>calperennial@gmail.com</td>\n",
       "      <td>Perennial: The Undergraduate Environmental Jou...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Phi Alpha Theta</td>\n",
       "      <td>phat.berkeley@gmail.com</td>\n",
       "      <td>Phi Alpha Theta</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>Phi Delta Epsilon</td>\n",
       "      <td>berkeleyphide@gmail.com</td>\n",
       "      <td>Phi Delta Epsilon</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>PlexTech</td>\n",
       "      <td>info@plextech.berkeley.edu</td>\n",
       "      <td>PlexTech</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>Pre-Pharmacy Informational, Learning and Leade...</td>\n",
       "      <td>pills.prepharmacy@gmail.com</td>\n",
       "      <td>Pre-Pharmacy Informational, Learning and Leade...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>PreDental Society</td>\n",
       "      <td>calpredentalsociety@gmail.com</td>\n",
       "      <td>Berkeley Pre-Dental Society</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>Product Space</td>\n",
       "      <td>cal@productspace.org</td>\n",
       "      <td>Product Space at UC Berkeley</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>Project RISHI, The Berkeley Chapter</td>\n",
       "      <td>ucberkeley@projectrishi.org</td>\n",
       "      <td>Project RISHI</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>Queer Alliance &amp; Resource Center</td>\n",
       "      <td>board@ucbqarc.org</td>\n",
       "      <td>Queer Alliance Resource Center</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>Reinnervate</td>\n",
       "      <td>reinnervate@gmail.com</td>\n",
       "      <td>Reinnervate</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>Sales and Trading Club at Berkeley</td>\n",
       "      <td>berkeleyfinanceclub@gmail.com</td>\n",
       "      <td>Berkeley Finance Club</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>Sigma Alpha Nu</td>\n",
       "      <td>sigmaalphanu.cal@gmail.com</td>\n",
       "      <td>Sigma Alpha Nu</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>SKY Campus Happiness Club at Berkeley</td>\n",
       "      <td>skybreathingberkeley@gmail.com</td>\n",
       "      <td>SKY Campus Happiness Club at Berkeley</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>Society of Women Engineers</td>\n",
       "      <td>swe.berkeley@gmail.com</td>\n",
       "      <td>Society of Women Engineers</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>Space Enterprise at Berkeley</td>\n",
       "      <td>info@seb.berkeley.edu</td>\n",
       "      <td>Space Enterprise at Berkeley</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>Sri Lankan Students Association</td>\n",
       "      <td>ucbslsa@gmail.com</td>\n",
       "      <td>Sri Lankan Students Association</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>Student to Student Peer Counseling</td>\n",
       "      <td>sspcemail@gmail.com</td>\n",
       "      <td>Student to Student Peer Counseling</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>Support, ENcourage and Develop for Children of...</td>\n",
       "      <td>calsendforc@gmail.com</td>\n",
       "      <td>SENDforC (Support, ENcourage, and Develop for ...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>Taiwanese Student Association</td>\n",
       "      <td>tsa.berkeley@gmail.com</td>\n",
       "      <td>Taiwanese Student Association</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>Team HBV</td>\n",
       "      <td>ucberkeley@teamhbv.org</td>\n",
       "      <td>Team HBV</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>Translational Medicine and Stem Cell Association</td>\n",
       "      <td>tmscaberkeley@gmail.com</td>\n",
       "      <td>Translational Medicine and Stem Cell Association</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>Tzu Chi Compassion Relief Foundation</td>\n",
       "      <td>berkeleytc@gmail.com</td>\n",
       "      <td>Tzu Chi Compassion Relief Foundation</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>UC Berkeley Model United Nations</td>\n",
       "      <td>secretary@ucbmun.org</td>\n",
       "      <td>UC Berkeley Model United Nations</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>Undergraduate Economics Association</td>\n",
       "      <td>ucberkeleyuea@gmail.com</td>\n",
       "      <td>Undergraduate Economics Association</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>Undergraduate Legal Honors Society (Formerly L...</td>\n",
       "      <td>board@ulhs.berkeley.edu</td>\n",
       "      <td>Undergraduate Legal Honor Society</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>Vietnamese Student Association</td>\n",
       "      <td>president@calvsa.com</td>\n",
       "      <td>Cal Vietnamese Student Association</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>Volunteer Health Interpreters Organization</td>\n",
       "      <td>cal.vhio@gmail.com</td>\n",
       "      <td>Volunteer Health Interpreters Organization</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>Volunteers for Medical Outreach</td>\n",
       "      <td>calvmo@gmail.com</td>\n",
       "      <td>Volunteers for Medical Outreach (VMO)</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>Voyager Consulting</td>\n",
       "      <td>info.voyagerconsulting@gmail.com</td>\n",
       "      <td>Voyager Consulting</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>You Mean More</td>\n",
       "      <td>youmeanmore@gmail.com</td>\n",
       "      <td>You Mean More</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          name_callink  \\\n",
       "0                                5&2 Community Service   \n",
       "1                                          Abba Modern   \n",
       "2                                      acts2fellowship   \n",
       "3                                            AFX Dance   \n",
       "4                                   Alternative Breaks   \n",
       "5    American Chemical Society at Berkeley Student ...   \n",
       "6    American Medical Student Association--Berkeley...   \n",
       "7                                 Artists in Resonance   \n",
       "8                         Asha for Education, Berkeley   \n",
       "9    Asian American and Pacific Islander Health Res...   \n",
       "10          Asian Pacific American Pre-Law Association   \n",
       "11   Assistants, Therapists, And Practitioners at B...   \n",
       "12       Association for Socially Responsible Business   \n",
       "13                            ASUC - Innovative Design   \n",
       "14                       ASUC Mental Health Commission   \n",
       "15                           ASUC Student Legal Clinic   \n",
       "16   ASUC Technology Office- Chief Technology Offic...   \n",
       "17                                     Aurum Cosmetics   \n",
       "18                Ballet Folklorico Reflejos De Mexico   \n",
       "19   Bay Area Environmentally Aware Consulting Network   \n",
       "20   Berkeley Art Museum Pacific Film Archive Stude...   \n",
       "21                                 Berkeley Forum, The   \n",
       "22                                 Berkeley Innovation   \n",
       "23                         Berkeley Scientific Journal   \n",
       "24   Berkeley Tennis Association (Formerly Tennis a...   \n",
       "25    Bhagat Puran Singh Health Initiative at Berkeley   \n",
       "26                                Big Data at Berkeley   \n",
       "27                                          BioethiCAL   \n",
       "28                            Biofuels Technology Club   \n",
       "29   Blockchain at Berkeley (formerly Bitcoin Assoc...   \n",
       "30                                           Blockeley   \n",
       "31                Blueprint, Technology for Nonprofits   \n",
       "32                               BridgeUSA at Berkeley   \n",
       "33              Business Careers in Entertainment Club   \n",
       "34                         Business Review at Berkeley   \n",
       "35               Business Transfer Network of Berkeley   \n",
       "36                                  Cal Figure Skating   \n",
       "37                             Cal Seismic Design Team   \n",
       "38   California Health Professional Student Allianc...   \n",
       "39                                   Californians, The   \n",
       "40                                              CalSol   \n",
       "41   CMG Strategy Consulting (Formerly Creative Mar...   \n",
       "42                                            Codebase   \n",
       "43                                           Codeology   \n",
       "44                            Computer Science Mentors   \n",
       "45   Crossroads Christian Fellowship: Chinese for C...   \n",
       "46                                         Cub Support   \n",
       "47                                       Dance the Bay   \n",
       "48                                           Danceworx   \n",
       "49                    Data Science Society at Berkeley   \n",
       "50                                           DataStory   \n",
       "51   Delta Phi Epsilon Co-ed Professional Foreign S...   \n",
       "52                 Delta Xi Phi Multicultural Sorority   \n",
       "53                                  Design at Berkeley   \n",
       "54                                         DiversaTech   \n",
       "55                                Eggster Organization   \n",
       "56                   Engineers and Mentors of Berkeley   \n",
       "57                                     EthiCAL Apparel   \n",
       "58                                           EXP Dance   \n",
       "59                        Extended Reality at Berkeley   \n",
       "60       Formula Electric at Berkeley (Formerly bLoop)   \n",
       "61       Formula SAE (Society of Automotive Engineers)   \n",
       "62   Future Business Leaders of America-Phi Beta La...   \n",
       "63             Game Design and Development at Berkeley   \n",
       "64                                    Gamma Rho Lambda   \n",
       "65            Girls Teaching Girls to Code at Berkeley   \n",
       "66                          Girls Who Code at Berkeley   \n",
       "67    Global Research and Consulting Group at Berkeley   \n",
       "68                                GlobeMed at Berkeley   \n",
       "69                    Haas Business School Association   \n",
       "70                                        Hack the Bay   \n",
       "71                                       Hep B Project   \n",
       "72                              Her Campus of Berkeley   \n",
       "73                               Human Powered Vehicle   \n",
       "74                         Indian Students Association   \n",
       "75       Institute of Industrial and Systems Engineers   \n",
       "76                         Invention Corps of Berkeley   \n",
       "77                                            Jericho!   \n",
       "78                                   Kappa Gamma Delta   \n",
       "79                                          Kendo Club   \n",
       "80      Kidney Disease Screening and Awareness Program   \n",
       "81                                           Launchpad   \n",
       "82                                 Legends of Berkeley   \n",
       "83                  Liberty in North Korea at Berkeley   \n",
       "84                               LW Passion Fellowship   \n",
       "85                     Medical Reallocation Initiative   \n",
       "86                            Microfinance at Berkeley   \n",
       "87                       Mobile Developers of Berkeley   \n",
       "88   Molecular and Cell Biology Cell Developmental ...   \n",
       "89   Molecular Cell Biology Undergraduate Student A...   \n",
       "90                               Music Connection, The   \n",
       "91                                Nikkei Student Union   \n",
       "92               Partners In Health Engage at Berkeley   \n",
       "93                                Peer Health Exchange   \n",
       "94   Perennial : The Undergraduate Environmental Jo...   \n",
       "95                                     Phi Alpha Theta   \n",
       "96                                   Phi Delta Epsilon   \n",
       "97                                            PlexTech   \n",
       "98   Pre-Pharmacy Informational, Learning and Leade...   \n",
       "99                                   PreDental Society   \n",
       "100                                      Product Space   \n",
       "101                Project RISHI, The Berkeley Chapter   \n",
       "102                   Queer Alliance & Resource Center   \n",
       "103                                        Reinnervate   \n",
       "104                 Sales and Trading Club at Berkeley   \n",
       "105                                     Sigma Alpha Nu   \n",
       "106              SKY Campus Happiness Club at Berkeley   \n",
       "107                         Society of Women Engineers   \n",
       "108                       Space Enterprise at Berkeley   \n",
       "109                    Sri Lankan Students Association   \n",
       "110                 Student to Student Peer Counseling   \n",
       "111  Support, ENcourage and Develop for Children of...   \n",
       "112                      Taiwanese Student Association   \n",
       "113                                           Team HBV   \n",
       "114   Translational Medicine and Stem Cell Association   \n",
       "115               Tzu Chi Compassion Relief Foundation   \n",
       "116                   UC Berkeley Model United Nations   \n",
       "117                Undergraduate Economics Association   \n",
       "118  Undergraduate Legal Honors Society (Formerly L...   \n",
       "119                     Vietnamese Student Association   \n",
       "120         Volunteer Health Interpreters Organization   \n",
       "121                    Volunteers for Medical Outreach   \n",
       "122                                 Voyager Consulting   \n",
       "123                                      You Mean More   \n",
       "\n",
       "                                       email  \\\n",
       "0              fiveandtwo.berkeley@gmail.com   \n",
       "1                       abbamodern@gmail.com   \n",
       "2                   info@acts2fellowship.org   \n",
       "3                         afxdance@gmail.com   \n",
       "4                berkeleyaltbreaks@gmail.com   \n",
       "5                      acsberkeley@gmail.com   \n",
       "6                     berkeleyamsa@gmail.com   \n",
       "7            artistsinresonanceucb@gmail.com   \n",
       "8                       berkeley@ashanet.org   \n",
       "9                     aapihrg.info@gmail.com   \n",
       "10                      ucb.apapla@gmail.com   \n",
       "11                       atpucberk@gmail.com   \n",
       "12                  asrbatberkeley@gmail.com   \n",
       "13           innovativedesignatcal@gmail.com   \n",
       "14           mentalhealthcommission@asuc.org   \n",
       "15                 asuclegalclinic@gmail.com   \n",
       "16                       technology@asuc.org   \n",
       "17               calaurumcosmetics@gmail.com   \n",
       "18            reflejosdemexico.cal@gmail.com   \n",
       "19                   info@beacn.berkeley.edu   \n",
       "20                     bampfasc@berkeley.edu   \n",
       "21                   info@forum.berkeley.edu   \n",
       "22             berkeley.innovation@gmail.com   \n",
       "23                    bsj.berkeley@gmail.com   \n",
       "24       berkeleytennisassociation@gmail.com   \n",
       "25                      ucberkeley@bpshi.com   \n",
       "26                bigdata.berkeley@gmail.com   \n",
       "27             bioethical.berkeley@gmail.com   \n",
       "28              biofuelstechnology@gmail.com   \n",
       "29             admin@blockchain.berkeley.edu   \n",
       "30                        info@blockeley.com   \n",
       "31                     team@calblueprint.org   \n",
       "32              bridgeusa.berkeley@gmail.com   \n",
       "33                         calbcec@gmail.com   \n",
       "34        businessreviewatberkeley@gmail.com   \n",
       "35             btnexecboard@btn.berkeley.edu   \n",
       "36                ucbfigureskating@gmail.com   \n",
       "37                  calseismicteam@gmail.com   \n",
       "38                 cahpsa.berkeley@gmail.com   \n",
       "39                     berkeleyscc@gmail.com   \n",
       "40                    calsol-me@berkeley.edu   \n",
       "41                     berkeleycmg@gmail.com   \n",
       "42             contact@codebase.berkeley.edu   \n",
       "43                       info@codeology.club   \n",
       "44                      mentors@berkeley.edu   \n",
       "45                        xroadscf@gmail.com   \n",
       "46                    ucbears4cubs@gmail.com   \n",
       "47                     dancethebay@gmail.com   \n",
       "48                   dwxpresidents@gmail.com   \n",
       "49                     info@dss.berkeley.edu   \n",
       "50             datastory.president@gmail.com   \n",
       "51                     berkeleydpe@gmail.com   \n",
       "52                   ucbdeltaxiphi@gmail.com   \n",
       "53                    designatberk@gmail.com   \n",
       "54            diversatech.berkeley@gmail.com   \n",
       "55                  eggsteroverall@gmail.com   \n",
       "56                      beam.teach@gmail.com   \n",
       "57                  ethicalapparel@gmail.com   \n",
       "58                    expdancecrew@gmail.com   \n",
       "59                   contact@xr.berkeley.edu   \n",
       "60                   contact@ev.berkeley.edu   \n",
       "61                      fsae@me.berkeley.edu   \n",
       "62                    execs@pbl.berkeley.edu   \n",
       "63                   calgamedev@berkeley.edu   \n",
       "64                 lambda@gammarholambda.org   \n",
       "65   ucberkeley@girlsteachinggirlstocode.org   \n",
       "66                     gwcberkeley@gmail.com   \n",
       "67               berkeley@grcglobalgroup.com   \n",
       "68                     berkeley@globemed.org   \n",
       "69                     hbsageneral@gmail.com   \n",
       "70                          team@calhacks.io   \n",
       "71                     hepbproject@gmail.com   \n",
       "72               hc.ucberkeley@hercampus.com   \n",
       "73                       hpv-me@berkeley.edu   \n",
       "74                  contact@isa.berkeley.edu   \n",
       "75                         iise@berkeley.edu   \n",
       "76           inventioncorps@icb.berkeley.edu   \n",
       "77                   jerichocomedy@gmail.com   \n",
       "78                 ucbkgdpresident@gmail.com   \n",
       "79              kendoclub.berkeley@gmail.com   \n",
       "80                   berkeleykdsap@gmail.com   \n",
       "81                     team@callaunchpad.org   \n",
       "82         berkeleyleagueoflegends@gmail.com   \n",
       "83                     linkbayarea@gmail.com   \n",
       "84              passionlivingwater@gmail.com   \n",
       "85                  contact@mri.berkeley.edu   \n",
       "86            berkeleymicrofinance@gmail.com   \n",
       "87                           contact@mdb.dev   \n",
       "88                         mcbcdna@gmail.com   \n",
       "89                          mcbusa@gmail.com   \n",
       "90                     tmcberkeley@gmail.com   \n",
       "91                     berkeleynsu@gmail.com   \n",
       "92           pih.engage.ucberkeley@gmail.com   \n",
       "93                         ucb.phe@gmail.com   \n",
       "94                    calperennial@gmail.com   \n",
       "95                   phat.berkeley@gmail.com   \n",
       "96                   berkeleyphide@gmail.com   \n",
       "97                info@plextech.berkeley.edu   \n",
       "98               pills.prepharmacy@gmail.com   \n",
       "99             calpredentalsociety@gmail.com   \n",
       "100                     cal@productspace.org   \n",
       "101              ucberkeley@projectrishi.org   \n",
       "102                        board@ucbqarc.org   \n",
       "103                    reinnervate@gmail.com   \n",
       "104            berkeleyfinanceclub@gmail.com   \n",
       "105               sigmaalphanu.cal@gmail.com   \n",
       "106           skybreathingberkeley@gmail.com   \n",
       "107                   swe.berkeley@gmail.com   \n",
       "108                    info@seb.berkeley.edu   \n",
       "109                        ucbslsa@gmail.com   \n",
       "110                      sspcemail@gmail.com   \n",
       "111                    calsendforc@gmail.com   \n",
       "112                   tsa.berkeley@gmail.com   \n",
       "113                   ucberkeley@teamhbv.org   \n",
       "114                  tmscaberkeley@gmail.com   \n",
       "115                     berkeleytc@gmail.com   \n",
       "116                     secretary@ucbmun.org   \n",
       "117                  ucberkeleyuea@gmail.com   \n",
       "118                  board@ulhs.berkeley.edu   \n",
       "119                     president@calvsa.com   \n",
       "120                       cal.vhio@gmail.com   \n",
       "121                         calvmo@gmail.com   \n",
       "122         info.voyagerconsulting@gmail.com   \n",
       "123                    youmeanmore@gmail.com   \n",
       "\n",
       "                                            name_mongo  match  \n",
       "0                                         5&2 Berkeley  False  \n",
       "1                                          Abba Modern   True  \n",
       "2                                      acts2fellowship   True  \n",
       "3                                            AFX Dance   True  \n",
       "4                                   Alternative Breaks   True  \n",
       "5    American Chemical Society at Berkeley (ACS@Ber...  False  \n",
       "6                 American Medical Student Association  False  \n",
       "7                                 Artists in Resonance   True  \n",
       "8                         Asha for Education, Berkeley   True  \n",
       "9    Asian American and Pacific Islander Health Res...   True  \n",
       "10          Asian Pacific American Pre-Law Association   True  \n",
       "11           Assistants, Therapists, and Practitioners  False  \n",
       "12   Association for Socially Responsible Business ...  False  \n",
       "13                                   Innovative Design  False  \n",
       "14                       ASUC Mental Health Commission   True  \n",
       "15                           ASUC Student Legal Clinic   True  \n",
       "16                              ASUC Office of the CTO  False  \n",
       "17                                     Aurum Cosmetics   True  \n",
       "18                Ballet Folklorico Reflejos de Mexico  False  \n",
       "19                                               BEACN  False  \n",
       "20                            BAMPFA Student Committee  False  \n",
       "21                                  The Berkeley Forum  False  \n",
       "22                                 Berkeley Innovation   True  \n",
       "23                         Berkeley Scientific Journal   True  \n",
       "24                         Berkeley Tennis Association  False  \n",
       "25                                   UC Berkeley BPSHI  False  \n",
       "26                                Big Data at Berkeley   True  \n",
       "27                                          BioethiCAL   True  \n",
       "28                            Biofuels Technology Club   True  \n",
       "29                              Blockchain at Berkeley  False  \n",
       "30                                           Blockeley   True  \n",
       "31                Blueprint, Technology for Nonprofits   True  \n",
       "32                                           BridgeUSA  False  \n",
       "33       Business Careers in Entertainment Club (BCEC)  False  \n",
       "34                         Business Review at Berkeley   True  \n",
       "35                           Business Transfer Network  False  \n",
       "36                                  Cal Figure Skating   True  \n",
       "37                             Cal Seismic Design Team   True  \n",
       "38     California Health Professional Student Alliance  False  \n",
       "39                                Senior Class Council  False  \n",
       "40                                              CalSol   True  \n",
       "41                             CMG Strategy Consulting  False  \n",
       "42                                            Codebase   True  \n",
       "43                                           Codeology   True  \n",
       "44                      Computer Science Mentors (CSM)  False  \n",
       "45                     Crossroads Christian Fellowship  False  \n",
       "46                                         Cub Support   True  \n",
       "47                                       Dance the Bay   True  \n",
       "48                                           Danceworx   True  \n",
       "49                     Data Science Society @ Berkeley  False  \n",
       "50                                           DataStory   True  \n",
       "51   Delta Phi Epsilon: Professional Co-Ed Foreign ...  False  \n",
       "52                 Delta Xi Phi Multicultural Sorority   True  \n",
       "53                                  Design at Berkeley   True  \n",
       "54                                         DiversaTech   True  \n",
       "55                                Eggster Organization   True  \n",
       "56                Berkeley Engineers and Mentors--BEAM  False  \n",
       "57                                     Ethical Apparel  False  \n",
       "58                                           EXP Dance   True  \n",
       "59                        Extended Reality at Berkeley   True  \n",
       "60                        Formula Electric at Berkeley  False  \n",
       "61                             Berkeley Formula Racing  False  \n",
       "62                            Berkeley Phi Beta Lambda  False  \n",
       "63              Game Design and Development @ Berkeley  False  \n",
       "64                                    Gamma Rho Lambda   True  \n",
       "65                        Girls Teaching Girls to Code  False  \n",
       "66                          Girls Who Code at Berkeley   True  \n",
       "67    Global Research and Consulting Group at Berkeley   True  \n",
       "68                                GlobeMed at Berkeley   True  \n",
       "69             Haas Business School Association (HBSA)  False  \n",
       "70                                           Cal Hacks  False  \n",
       "71                                       Hep B Project   True  \n",
       "72                              Her Campus at Berkeley  False  \n",
       "73                          Human Powered Vehicle Team  False  \n",
       "74                         Indian Students Association   True  \n",
       "75   Institute of Industrial and Systems Engineers ...  False  \n",
       "76                            Invention Corps Berkeley  False  \n",
       "77                   jericho! improv and sketch comedy  False  \n",
       "78                                   Kappa Gamma Delta   True  \n",
       "79                              Kendo Club at Berkeley  False  \n",
       "80   Kidney Disease Screening and Awareness Program...  False  \n",
       "81                                           Launchpad   True  \n",
       "82                                    Berkeley Legends  False  \n",
       "83           Liberty in North Korea (LiNK) at Berkeley  False  \n",
       "84                               LW Passion Fellowship   True  \n",
       "85                     Medical Reallocation Initiative   True  \n",
       "86                            Microfinance at Berkeley   True  \n",
       "87                       Mobile Developers of Berkeley   True  \n",
       "88   Molecular & Cell Biology, Cell Developmental, ...  False  \n",
       "89                                              mcbUSA  False  \n",
       "90                                The Music Connection  False  \n",
       "91                                Nikkei Student Union   True  \n",
       "92                           Partners in Health Engage  False  \n",
       "93                                Peer Health Exchange   True  \n",
       "94   Perennial: The Undergraduate Environmental Jou...  False  \n",
       "95                                     Phi Alpha Theta   True  \n",
       "96                                   Phi Delta Epsilon   True  \n",
       "97                                            PlexTech   True  \n",
       "98   Pre-Pharmacy Informational, Learning and Leade...   True  \n",
       "99                         Berkeley Pre-Dental Society  False  \n",
       "100                       Product Space at UC Berkeley  False  \n",
       "101                                      Project RISHI  False  \n",
       "102                     Queer Alliance Resource Center  False  \n",
       "103                                        Reinnervate   True  \n",
       "104                              Berkeley Finance Club  False  \n",
       "105                                     Sigma Alpha Nu   True  \n",
       "106              SKY Campus Happiness Club at Berkeley   True  \n",
       "107                         Society of Women Engineers   True  \n",
       "108                       Space Enterprise at Berkeley   True  \n",
       "109                    Sri Lankan Students Association   True  \n",
       "110                 Student to Student Peer Counseling   True  \n",
       "111  SENDforC (Support, ENcourage, and Develop for ...  False  \n",
       "112                      Taiwanese Student Association   True  \n",
       "113                                           Team HBV   True  \n",
       "114   Translational Medicine and Stem Cell Association   True  \n",
       "115               Tzu Chi Compassion Relief Foundation   True  \n",
       "116                   UC Berkeley Model United Nations   True  \n",
       "117                Undergraduate Economics Association   True  \n",
       "118                  Undergraduate Legal Honor Society  False  \n",
       "119                 Cal Vietnamese Student Association  False  \n",
       "120         Volunteer Health Interpreters Organization   True  \n",
       "121              Volunteers for Medical Outreach (VMO)  False  \n",
       "122                                 Voyager Consulting   True  \n",
       "123                                      You Mean More   True  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "existing_clubs_df_by_email = pd.merge(\n",
    "    club_json_df, club_db_df,\n",
    "    how='inner', on='email',\n",
    "    suffixes=('_callink', '_mongo')\n",
    ")\n",
    "\n",
    "matching_names = existing_clubs_df_by_email['name_callink'] == existing_clubs_df_by_email['name_mongo']\n",
    "existing_clubs_df_by_email['match'] = matching_names\n",
    "existing_clubs_df_by_email"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "# of matching names: 68\n",
      "# of non-matching names: 56\n",
      "% of matching names: 54.8%\n"
     ]
    }
   ],
   "source": [
    "print('# of matching names:', sum(matching_names))\n",
    "print('# of non-matching names:', len(matching_names) - sum(matching_names))\n",
    "print('%% of matching names: %.1f%%' % ( sum(matching_names) / len(matching_names) * 100 ))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Step 1b: Merge data by same name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>email_callink</th>\n",
       "      <th>email_mongo</th>\n",
       "      <th>match</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3D Modeling and Animation at Berkeley</td>\n",
       "      <td>3dma.at.berkeley@gmail.com</td>\n",
       "      <td>staff@ucbugg.com</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Abba Modern</td>\n",
       "      <td>abbamodern@gmail.com</td>\n",
       "      <td>abbamodern@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>acts2fellowship</td>\n",
       "      <td>info@acts2fellowship.org</td>\n",
       "      <td>info@acts2fellowship.org</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AFX Dance</td>\n",
       "      <td>afxdance@gmail.com</td>\n",
       "      <td>afxdance@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alpha Kappa Psi</td>\n",
       "      <td>sanampatel1999@gmail.com</td>\n",
       "      <td>corporaterelations@calakpsi.com</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Alternative Breaks</td>\n",
       "      <td>berkeleyaltbreaks@gmail.com</td>\n",
       "      <td>berkeleyaltbreaks@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Artists in Resonance</td>\n",
       "      <td>artistsinresonanceucb@gmail.com</td>\n",
       "      <td>artistsinresonanceucb@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Asha for Education, Berkeley</td>\n",
       "      <td>berkeley@ashanet.org</td>\n",
       "      <td>berkeley@ashanet.org</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Asian American and Pacific Islander Health Res...</td>\n",
       "      <td>aapihrg.info@gmail.com</td>\n",
       "      <td>aapihrg.info@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Asian Pacific American Pre-Law Association</td>\n",
       "      <td>ucb.apapla@gmail.com</td>\n",
       "      <td>ucb.apapla@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>ASUC Mental Health Commission</td>\n",
       "      <td>mentalhealthcommission@asuc.org</td>\n",
       "      <td>mentalhealthcommission@asuc.org</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>ASUC Sexual Violence Commission</td>\n",
       "      <td>sexualviolence@asuc.org</td>\n",
       "      <td>sexualviolencecommission@asuc.org</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>ASUC Student Legal Clinic</td>\n",
       "      <td>asuclegalclinic@gmail.com</td>\n",
       "      <td>asuclegalclinic@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Aurum Cosmetics</td>\n",
       "      <td>calaurumcosmetics@gmail.com</td>\n",
       "      <td>calaurumcosmetics@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Berkeley Business Society</td>\n",
       "      <td>BerkeleyBusinessSociety@gmail.com</td>\n",
       "      <td>bbs.ucb@gmail.com</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Berkeley Economic Review</td>\n",
       "      <td>editor@econreview.berkeley.edu</td>\n",
       "      <td>berkeleyeconreview@gmail.com</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Berkeley Innovation</td>\n",
       "      <td>berkeley.innovation@gmail.com</td>\n",
       "      <td>berkeley.innovation@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Berkeley Scientific Journal</td>\n",
       "      <td>bsj.berkeley@gmail.com</td>\n",
       "      <td>bsj.berkeley@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Big Data at Berkeley</td>\n",
       "      <td>bigdata.berkeley@gmail.com</td>\n",
       "      <td>bigdata.berkeley@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>BioethiCAL</td>\n",
       "      <td>bioethical.berkeley@gmail.com</td>\n",
       "      <td>bioethical.berkeley@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Biofuels Technology Club</td>\n",
       "      <td>biofuelstechnology@gmail.com</td>\n",
       "      <td>biofuelstechnology@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Blockeley</td>\n",
       "      <td>info@blockeley.com</td>\n",
       "      <td>info@blockeley.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Blueprint, Technology for Nonprofits</td>\n",
       "      <td>team@calblueprint.org</td>\n",
       "      <td>team@calblueprint.org</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Bone Health Initiative</td>\n",
       "      <td>info@bhi.berkeley.edu</td>\n",
       "      <td>bhi@berkeley.edu</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Business Review at Berkeley</td>\n",
       "      <td>businessreviewatberkeley@gmail.com</td>\n",
       "      <td>businessreviewatberkeley@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Cal Figure Skating</td>\n",
       "      <td>ucbfigureskating@gmail.com</td>\n",
       "      <td>ucbfigureskating@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Cal Habitat for Humanity</td>\n",
       "      <td>calhabitat.pres@gmail.com</td>\n",
       "      <td>calhabitat.vicepresident@gmail.com</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Cal Rotaract</td>\n",
       "      <td>info@calrotaract.org</td>\n",
       "      <td>executive@calrotaract.org</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Cal Seismic Design Team</td>\n",
       "      <td>calseismicteam@gmail.com</td>\n",
       "      <td>calseismicteam@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Cal Table Tennis Club</td>\n",
       "      <td>None</td>\n",
       "      <td>calttc@gmail.com</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>CalSol</td>\n",
       "      <td>calsol-me@berkeley.edu</td>\n",
       "      <td>calsol-me@berkeley.edu</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Codebase</td>\n",
       "      <td>contact@codebase.berkeley.edu</td>\n",
       "      <td>contact@codebase.berkeley.edu</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Codeology</td>\n",
       "      <td>info@codeology.club</td>\n",
       "      <td>info@codeology.club</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Cub Support</td>\n",
       "      <td>ucbears4cubs@gmail.com</td>\n",
       "      <td>ucbears4cubs@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Dance the Bay</td>\n",
       "      <td>dancethebay@gmail.com</td>\n",
       "      <td>dancethebay@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Danceworx</td>\n",
       "      <td>dwxpresidents@gmail.com</td>\n",
       "      <td>dwxpresidents@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Data Science Society at Berkeley</td>\n",
       "      <td>info@dss.berkeley.edu</td>\n",
       "      <td>dss.berkeley@gmail.com</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>DataStory</td>\n",
       "      <td>datastory.president@gmail.com</td>\n",
       "      <td>datastory.president@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Delta Xi Phi Multicultural Sorority</td>\n",
       "      <td>ucbdeltaxiphi@gmail.com</td>\n",
       "      <td>ucbdeltaxiphi@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Design at Berkeley</td>\n",
       "      <td>designatberk@gmail.com</td>\n",
       "      <td>designatberk@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>DiversaTech</td>\n",
       "      <td>diversatech.berkeley@gmail.com</td>\n",
       "      <td>diversatech.berkeley@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Eggster Organization</td>\n",
       "      <td>eggsteroverall@gmail.com</td>\n",
       "      <td>eggsteroverall@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Engineering Student Council</td>\n",
       "      <td>president@esc.berkeley.edu</td>\n",
       "      <td>esc.comms@gmail.com</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Equity Beyond Barriers at Berkeley</td>\n",
       "      <td>equitybeyondbarriers@gmail.com</td>\n",
       "      <td>equitybeyondbarriersatberkeley@gmail.com</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Eta Kappa Nu</td>\n",
       "      <td>hkn@hkn.eecs.berkeley.edu</td>\n",
       "      <td>hkn@hkn.mu</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>EXP Dance</td>\n",
       "      <td>expdancecrew@gmail.com</td>\n",
       "      <td>expdancecrew@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Extended Reality at Berkeley</td>\n",
       "      <td>contact@xr.berkeley.edu</td>\n",
       "      <td>contact@xr.berkeley.edu</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Fiat Lux Institute of Policy</td>\n",
       "      <td>a.mendoza@berkeley.edu</td>\n",
       "      <td>dhavalpatel@berkeley.edu</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Free Ventures</td>\n",
       "      <td>pranav.gulati@berkeley.edu</td>\n",
       "      <td>nikita@freeventures.org</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Gamma Rho Lambda</td>\n",
       "      <td>lambda@gammarholambda.org</td>\n",
       "      <td>lambda@gammarholambda.org</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Girls Who Code at Berkeley</td>\n",
       "      <td>gwcberkeley@gmail.com</td>\n",
       "      <td>gwcberkeley@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Global Research and Consulting Group at Berkeley</td>\n",
       "      <td>berkeley@grcglobalgroup.com</td>\n",
       "      <td>berkeley@grcglobalgroup.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>GlobeMed at Berkeley</td>\n",
       "      <td>berkeley@globemed.org</td>\n",
       "      <td>berkeley@globemed.org</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Hep B Project</td>\n",
       "      <td>hepbproject@gmail.com</td>\n",
       "      <td>hepbproject@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Humans of Berkeley</td>\n",
       "      <td>anyal23@berkeley.edu</td>\n",
       "      <td>humansofberkeley@gmail.com</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Indian Students Association</td>\n",
       "      <td>contact@isa.berkeley.edu</td>\n",
       "      <td>contact@isa.berkeley.edu</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Kappa Gamma Delta</td>\n",
       "      <td>ucbkgdpresident@gmail.com</td>\n",
       "      <td>ucbkgdpresident@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Kappa Gamma Delta</td>\n",
       "      <td>ucbkgdpresident@gmail.com</td>\n",
       "      <td>ucbkgdpublicrelations@gmail.com</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Launchpad</td>\n",
       "      <td>team@callaunchpad.org</td>\n",
       "      <td>team@callaunchpad.org</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>LW Passion Fellowship</td>\n",
       "      <td>passionlivingwater@gmail.com</td>\n",
       "      <td>passionlivingwater@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Matriculate</td>\n",
       "      <td>info@matriculate.org</td>\n",
       "      <td>ucbmatriculate@gmail.com</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Medical Reallocation Initiative</td>\n",
       "      <td>contact@mri.berkeley.edu</td>\n",
       "      <td>teambmri@gmail.com</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Medical Reallocation Initiative</td>\n",
       "      <td>contact@mri.berkeley.edu</td>\n",
       "      <td>contact@mri.berkeley.edu</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>Microfinance at Berkeley</td>\n",
       "      <td>berkeleymicrofinance@gmail.com</td>\n",
       "      <td>berkeleymicrofinance@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Mobile Developers of Berkeley</td>\n",
       "      <td>contact@mdb.dev</td>\n",
       "      <td>contact@mdb.dev</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Nikkei Student Union</td>\n",
       "      <td>berkeleynsu@gmail.com</td>\n",
       "      <td>berkeleynsu@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Peer Health Exchange</td>\n",
       "      <td>ucb.phe@gmail.com</td>\n",
       "      <td>ucb.phe@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>People's Test Preparation Service</td>\n",
       "      <td>ptps.berkeley@gmail.com</td>\n",
       "      <td>publicity@ptps.berkeley.edu</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Phi Alpha Theta</td>\n",
       "      <td>phat.berkeley@gmail.com</td>\n",
       "      <td>phat.berkeley@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Phi Delta Epsilon</td>\n",
       "      <td>berkeleyphide@gmail.com</td>\n",
       "      <td>berkeleyphide@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Phi Sigma Rho</td>\n",
       "      <td>calphirho@gmail.com</td>\n",
       "      <td>recruitment.calpsr@gmail.com</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Phoenix Consulting Group</td>\n",
       "      <td>phoenixconsulting.berkeley@gmail.com</td>\n",
       "      <td>nian_s@berkeley.edu</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Pi Sigma Epsilon</td>\n",
       "      <td>berkeleypse.president@gmail.com</td>\n",
       "      <td>berkeleypse.hr@gmail.com</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>PlexTech</td>\n",
       "      <td>info@plextech.berkeley.edu</td>\n",
       "      <td>info@plextech.berkeley.edu</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Pre-Pharmacy Informational, Learning and Leade...</td>\n",
       "      <td>pills.prepharmacy@gmail.com</td>\n",
       "      <td>pills.prepharmacy@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Public Health Advocate</td>\n",
       "      <td>editorialboard@pha.berkeley.edu</td>\n",
       "      <td>publichealthadvocate@gmail.com</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Reinnervate</td>\n",
       "      <td>reinnervate@gmail.com</td>\n",
       "      <td>reinnervate@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Sigma Alpha Nu</td>\n",
       "      <td>sigmaalphanu.cal@gmail.com</td>\n",
       "      <td>sigmaalphanu.cal@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Sigma Epsilon Omega</td>\n",
       "      <td>info@sigmaepsilonomega.com</td>\n",
       "      <td>president@sigmaepsilonomega.com</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>SKY Campus Happiness Club at Berkeley</td>\n",
       "      <td>skybreathingberkeley@gmail.com</td>\n",
       "      <td>skybreathingberkeley@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Society of Women Engineers</td>\n",
       "      <td>swe.berkeley@gmail.com</td>\n",
       "      <td>swe.berkeley@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Space Enterprise at Berkeley</td>\n",
       "      <td>info@seb.berkeley.edu</td>\n",
       "      <td>info@seb.berkeley.edu</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Sri Lankan Students Association</td>\n",
       "      <td>ucbslsa@gmail.com</td>\n",
       "      <td>ucbslsa@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Student Association for Applied Statistics</td>\n",
       "      <td>contact@saas.berkeley.edu</td>\n",
       "      <td>saas.berkeley@gmail.com</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Student to Student Peer Counseling</td>\n",
       "      <td>sspcemail@gmail.com</td>\n",
       "      <td>sspcemail@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Suitcase Clinic</td>\n",
       "      <td>suitcaseclinic1989@gmail.com</td>\n",
       "      <td>suitcasepr@gmail.com</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>Taiwanese Student Association</td>\n",
       "      <td>tsa.berkeley@gmail.com</td>\n",
       "      <td>tsa.berkeley@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>Team HBV</td>\n",
       "      <td>ucberkeley@teamhbv.org</td>\n",
       "      <td>ucberkeley@teamhbv.org</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Translational Medicine and Stem Cell Association</td>\n",
       "      <td>tmscaberkeley@gmail.com</td>\n",
       "      <td>tmscaberkeley@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>Tzu Chi Compassion Relief Foundation</td>\n",
       "      <td>berkeleytc@gmail.com</td>\n",
       "      <td>berkeleytc@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>UC Berkeley Model United Nations</td>\n",
       "      <td>secretary@ucbmun.org</td>\n",
       "      <td>secretary@ucbmun.org</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Undergraduate Economics Association</td>\n",
       "      <td>ucberkeleyuea@gmail.com</td>\n",
       "      <td>ucberkeleyuea@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>UrsaTech</td>\n",
       "      <td>None</td>\n",
       "      <td>ursatechberkeley@gmail.com</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>Valley Consulting Group</td>\n",
       "      <td>info@vcg.berkeley.edu</td>\n",
       "      <td>evp@vcg.berkeley.edu</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Volunteer Health Interpreters Organization</td>\n",
       "      <td>cal.vhio@gmail.com</td>\n",
       "      <td>cal.vhio@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Voyager Consulting</td>\n",
       "      <td>info.voyagerconsulting@gmail.com</td>\n",
       "      <td>info.voyagerconsulting@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>You Mean More</td>\n",
       "      <td>youmeanmore@gmail.com</td>\n",
       "      <td>youmeanmore@gmail.com</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 name  \\\n",
       "0               3D Modeling and Animation at Berkeley   \n",
       "1                                         Abba Modern   \n",
       "2                                     acts2fellowship   \n",
       "3                                           AFX Dance   \n",
       "4                                     Alpha Kappa Psi   \n",
       "5                                  Alternative Breaks   \n",
       "6                                Artists in Resonance   \n",
       "7                        Asha for Education, Berkeley   \n",
       "8   Asian American and Pacific Islander Health Res...   \n",
       "9          Asian Pacific American Pre-Law Association   \n",
       "10                      ASUC Mental Health Commission   \n",
       "11                    ASUC Sexual Violence Commission   \n",
       "12                          ASUC Student Legal Clinic   \n",
       "13                                    Aurum Cosmetics   \n",
       "14                          Berkeley Business Society   \n",
       "15                           Berkeley Economic Review   \n",
       "16                                Berkeley Innovation   \n",
       "17                        Berkeley Scientific Journal   \n",
       "18                               Big Data at Berkeley   \n",
       "19                                         BioethiCAL   \n",
       "20                           Biofuels Technology Club   \n",
       "21                                          Blockeley   \n",
       "22               Blueprint, Technology for Nonprofits   \n",
       "23                             Bone Health Initiative   \n",
       "24                        Business Review at Berkeley   \n",
       "25                                 Cal Figure Skating   \n",
       "26                           Cal Habitat for Humanity   \n",
       "27                                       Cal Rotaract   \n",
       "28                            Cal Seismic Design Team   \n",
       "29                              Cal Table Tennis Club   \n",
       "30                                             CalSol   \n",
       "31                                           Codebase   \n",
       "32                                          Codeology   \n",
       "33                                        Cub Support   \n",
       "34                                      Dance the Bay   \n",
       "35                                          Danceworx   \n",
       "36                   Data Science Society at Berkeley   \n",
       "37                                          DataStory   \n",
       "38                Delta Xi Phi Multicultural Sorority   \n",
       "39                                 Design at Berkeley   \n",
       "40                                        DiversaTech   \n",
       "41                               Eggster Organization   \n",
       "42                        Engineering Student Council   \n",
       "43                 Equity Beyond Barriers at Berkeley   \n",
       "44                                       Eta Kappa Nu   \n",
       "45                                          EXP Dance   \n",
       "46                       Extended Reality at Berkeley   \n",
       "47                       Fiat Lux Institute of Policy   \n",
       "48                                      Free Ventures   \n",
       "49                                   Gamma Rho Lambda   \n",
       "50                         Girls Who Code at Berkeley   \n",
       "51   Global Research and Consulting Group at Berkeley   \n",
       "52                               GlobeMed at Berkeley   \n",
       "53                                      Hep B Project   \n",
       "54                                 Humans of Berkeley   \n",
       "55                        Indian Students Association   \n",
       "56                                  Kappa Gamma Delta   \n",
       "57                                  Kappa Gamma Delta   \n",
       "58                                          Launchpad   \n",
       "59                              LW Passion Fellowship   \n",
       "60                                        Matriculate   \n",
       "61                    Medical Reallocation Initiative   \n",
       "62                    Medical Reallocation Initiative   \n",
       "63                           Microfinance at Berkeley   \n",
       "64                      Mobile Developers of Berkeley   \n",
       "65                               Nikkei Student Union   \n",
       "66                               Peer Health Exchange   \n",
       "67                  People's Test Preparation Service   \n",
       "68                                    Phi Alpha Theta   \n",
       "69                                  Phi Delta Epsilon   \n",
       "70                                      Phi Sigma Rho   \n",
       "71                           Phoenix Consulting Group   \n",
       "72                                   Pi Sigma Epsilon   \n",
       "73                                           PlexTech   \n",
       "74  Pre-Pharmacy Informational, Learning and Leade...   \n",
       "75                             Public Health Advocate   \n",
       "76                                        Reinnervate   \n",
       "77                                     Sigma Alpha Nu   \n",
       "78                                Sigma Epsilon Omega   \n",
       "79              SKY Campus Happiness Club at Berkeley   \n",
       "80                         Society of Women Engineers   \n",
       "81                       Space Enterprise at Berkeley   \n",
       "82                    Sri Lankan Students Association   \n",
       "83         Student Association for Applied Statistics   \n",
       "84                 Student to Student Peer Counseling   \n",
       "85                                    Suitcase Clinic   \n",
       "86                      Taiwanese Student Association   \n",
       "87                                           Team HBV   \n",
       "88   Translational Medicine and Stem Cell Association   \n",
       "89               Tzu Chi Compassion Relief Foundation   \n",
       "90                   UC Berkeley Model United Nations   \n",
       "91                Undergraduate Economics Association   \n",
       "92                                           UrsaTech   \n",
       "93                            Valley Consulting Group   \n",
       "94         Volunteer Health Interpreters Organization   \n",
       "95                                 Voyager Consulting   \n",
       "96                                      You Mean More   \n",
       "\n",
       "                           email_callink  \\\n",
       "0             3dma.at.berkeley@gmail.com   \n",
       "1                   abbamodern@gmail.com   \n",
       "2               info@acts2fellowship.org   \n",
       "3                     afxdance@gmail.com   \n",
       "4               sanampatel1999@gmail.com   \n",
       "5            berkeleyaltbreaks@gmail.com   \n",
       "6        artistsinresonanceucb@gmail.com   \n",
       "7                   berkeley@ashanet.org   \n",
       "8                 aapihrg.info@gmail.com   \n",
       "9                   ucb.apapla@gmail.com   \n",
       "10       mentalhealthcommission@asuc.org   \n",
       "11               sexualviolence@asuc.org   \n",
       "12             asuclegalclinic@gmail.com   \n",
       "13           calaurumcosmetics@gmail.com   \n",
       "14     BerkeleyBusinessSociety@gmail.com   \n",
       "15        editor@econreview.berkeley.edu   \n",
       "16         berkeley.innovation@gmail.com   \n",
       "17                bsj.berkeley@gmail.com   \n",
       "18            bigdata.berkeley@gmail.com   \n",
       "19         bioethical.berkeley@gmail.com   \n",
       "20          biofuelstechnology@gmail.com   \n",
       "21                    info@blockeley.com   \n",
       "22                 team@calblueprint.org   \n",
       "23                 info@bhi.berkeley.edu   \n",
       "24    businessreviewatberkeley@gmail.com   \n",
       "25            ucbfigureskating@gmail.com   \n",
       "26             calhabitat.pres@gmail.com   \n",
       "27                  info@calrotaract.org   \n",
       "28              calseismicteam@gmail.com   \n",
       "29                                  None   \n",
       "30                calsol-me@berkeley.edu   \n",
       "31         contact@codebase.berkeley.edu   \n",
       "32                   info@codeology.club   \n",
       "33                ucbears4cubs@gmail.com   \n",
       "34                 dancethebay@gmail.com   \n",
       "35               dwxpresidents@gmail.com   \n",
       "36                 info@dss.berkeley.edu   \n",
       "37         datastory.president@gmail.com   \n",
       "38               ucbdeltaxiphi@gmail.com   \n",
       "39                designatberk@gmail.com   \n",
       "40        diversatech.berkeley@gmail.com   \n",
       "41              eggsteroverall@gmail.com   \n",
       "42            president@esc.berkeley.edu   \n",
       "43        equitybeyondbarriers@gmail.com   \n",
       "44             hkn@hkn.eecs.berkeley.edu   \n",
       "45                expdancecrew@gmail.com   \n",
       "46               contact@xr.berkeley.edu   \n",
       "47                a.mendoza@berkeley.edu   \n",
       "48            pranav.gulati@berkeley.edu   \n",
       "49             lambda@gammarholambda.org   \n",
       "50                 gwcberkeley@gmail.com   \n",
       "51           berkeley@grcglobalgroup.com   \n",
       "52                 berkeley@globemed.org   \n",
       "53                 hepbproject@gmail.com   \n",
       "54                  anyal23@berkeley.edu   \n",
       "55              contact@isa.berkeley.edu   \n",
       "56             ucbkgdpresident@gmail.com   \n",
       "57             ucbkgdpresident@gmail.com   \n",
       "58                 team@callaunchpad.org   \n",
       "59          passionlivingwater@gmail.com   \n",
       "60                  info@matriculate.org   \n",
       "61              contact@mri.berkeley.edu   \n",
       "62              contact@mri.berkeley.edu   \n",
       "63        berkeleymicrofinance@gmail.com   \n",
       "64                       contact@mdb.dev   \n",
       "65                 berkeleynsu@gmail.com   \n",
       "66                     ucb.phe@gmail.com   \n",
       "67               ptps.berkeley@gmail.com   \n",
       "68               phat.berkeley@gmail.com   \n",
       "69               berkeleyphide@gmail.com   \n",
       "70                   calphirho@gmail.com   \n",
       "71  phoenixconsulting.berkeley@gmail.com   \n",
       "72       berkeleypse.president@gmail.com   \n",
       "73            info@plextech.berkeley.edu   \n",
       "74           pills.prepharmacy@gmail.com   \n",
       "75       editorialboard@pha.berkeley.edu   \n",
       "76                 reinnervate@gmail.com   \n",
       "77            sigmaalphanu.cal@gmail.com   \n",
       "78            info@sigmaepsilonomega.com   \n",
       "79        skybreathingberkeley@gmail.com   \n",
       "80                swe.berkeley@gmail.com   \n",
       "81                 info@seb.berkeley.edu   \n",
       "82                     ucbslsa@gmail.com   \n",
       "83             contact@saas.berkeley.edu   \n",
       "84                   sspcemail@gmail.com   \n",
       "85          suitcaseclinic1989@gmail.com   \n",
       "86                tsa.berkeley@gmail.com   \n",
       "87                ucberkeley@teamhbv.org   \n",
       "88               tmscaberkeley@gmail.com   \n",
       "89                  berkeleytc@gmail.com   \n",
       "90                  secretary@ucbmun.org   \n",
       "91               ucberkeleyuea@gmail.com   \n",
       "92                                  None   \n",
       "93                 info@vcg.berkeley.edu   \n",
       "94                    cal.vhio@gmail.com   \n",
       "95      info.voyagerconsulting@gmail.com   \n",
       "96                 youmeanmore@gmail.com   \n",
       "\n",
       "                                 email_mongo  match  \n",
       "0                           staff@ucbugg.com  False  \n",
       "1                       abbamodern@gmail.com   True  \n",
       "2                   info@acts2fellowship.org   True  \n",
       "3                         afxdance@gmail.com   True  \n",
       "4            corporaterelations@calakpsi.com  False  \n",
       "5                berkeleyaltbreaks@gmail.com   True  \n",
       "6            artistsinresonanceucb@gmail.com   True  \n",
       "7                       berkeley@ashanet.org   True  \n",
       "8                     aapihrg.info@gmail.com   True  \n",
       "9                       ucb.apapla@gmail.com   True  \n",
       "10           mentalhealthcommission@asuc.org   True  \n",
       "11         sexualviolencecommission@asuc.org  False  \n",
       "12                 asuclegalclinic@gmail.com   True  \n",
       "13               calaurumcosmetics@gmail.com   True  \n",
       "14                         bbs.ucb@gmail.com  False  \n",
       "15              berkeleyeconreview@gmail.com  False  \n",
       "16             berkeley.innovation@gmail.com   True  \n",
       "17                    bsj.berkeley@gmail.com   True  \n",
       "18                bigdata.berkeley@gmail.com   True  \n",
       "19             bioethical.berkeley@gmail.com   True  \n",
       "20              biofuelstechnology@gmail.com   True  \n",
       "21                        info@blockeley.com   True  \n",
       "22                     team@calblueprint.org   True  \n",
       "23                          bhi@berkeley.edu  False  \n",
       "24        businessreviewatberkeley@gmail.com   True  \n",
       "25                ucbfigureskating@gmail.com   True  \n",
       "26        calhabitat.vicepresident@gmail.com  False  \n",
       "27                 executive@calrotaract.org  False  \n",
       "28                  calseismicteam@gmail.com   True  \n",
       "29                          calttc@gmail.com  False  \n",
       "30                    calsol-me@berkeley.edu   True  \n",
       "31             contact@codebase.berkeley.edu   True  \n",
       "32                       info@codeology.club   True  \n",
       "33                    ucbears4cubs@gmail.com   True  \n",
       "34                     dancethebay@gmail.com   True  \n",
       "35                   dwxpresidents@gmail.com   True  \n",
       "36                    dss.berkeley@gmail.com  False  \n",
       "37             datastory.president@gmail.com   True  \n",
       "38                   ucbdeltaxiphi@gmail.com   True  \n",
       "39                    designatberk@gmail.com   True  \n",
       "40            diversatech.berkeley@gmail.com   True  \n",
       "41                  eggsteroverall@gmail.com   True  \n",
       "42                       esc.comms@gmail.com  False  \n",
       "43  equitybeyondbarriersatberkeley@gmail.com  False  \n",
       "44                                hkn@hkn.mu  False  \n",
       "45                    expdancecrew@gmail.com   True  \n",
       "46                   contact@xr.berkeley.edu   True  \n",
       "47                  dhavalpatel@berkeley.edu  False  \n",
       "48                   nikita@freeventures.org  False  \n",
       "49                 lambda@gammarholambda.org   True  \n",
       "50                     gwcberkeley@gmail.com   True  \n",
       "51               berkeley@grcglobalgroup.com   True  \n",
       "52                     berkeley@globemed.org   True  \n",
       "53                     hepbproject@gmail.com   True  \n",
       "54                humansofberkeley@gmail.com  False  \n",
       "55                  contact@isa.berkeley.edu   True  \n",
       "56                 ucbkgdpresident@gmail.com   True  \n",
       "57           ucbkgdpublicrelations@gmail.com  False  \n",
       "58                     team@callaunchpad.org   True  \n",
       "59              passionlivingwater@gmail.com   True  \n",
       "60                  ucbmatriculate@gmail.com  False  \n",
       "61                        teambmri@gmail.com  False  \n",
       "62                  contact@mri.berkeley.edu   True  \n",
       "63            berkeleymicrofinance@gmail.com   True  \n",
       "64                           contact@mdb.dev   True  \n",
       "65                     berkeleynsu@gmail.com   True  \n",
       "66                         ucb.phe@gmail.com   True  \n",
       "67               publicity@ptps.berkeley.edu  False  \n",
       "68                   phat.berkeley@gmail.com   True  \n",
       "69                   berkeleyphide@gmail.com   True  \n",
       "70              recruitment.calpsr@gmail.com  False  \n",
       "71                       nian_s@berkeley.edu  False  \n",
       "72                  berkeleypse.hr@gmail.com  False  \n",
       "73                info@plextech.berkeley.edu   True  \n",
       "74               pills.prepharmacy@gmail.com   True  \n",
       "75            publichealthadvocate@gmail.com  False  \n",
       "76                     reinnervate@gmail.com   True  \n",
       "77                sigmaalphanu.cal@gmail.com   True  \n",
       "78           president@sigmaepsilonomega.com  False  \n",
       "79            skybreathingberkeley@gmail.com   True  \n",
       "80                    swe.berkeley@gmail.com   True  \n",
       "81                     info@seb.berkeley.edu   True  \n",
       "82                         ucbslsa@gmail.com   True  \n",
       "83                   saas.berkeley@gmail.com  False  \n",
       "84                       sspcemail@gmail.com   True  \n",
       "85                      suitcasepr@gmail.com  False  \n",
       "86                    tsa.berkeley@gmail.com   True  \n",
       "87                    ucberkeley@teamhbv.org   True  \n",
       "88                   tmscaberkeley@gmail.com   True  \n",
       "89                      berkeleytc@gmail.com   True  \n",
       "90                      secretary@ucbmun.org   True  \n",
       "91                   ucberkeleyuea@gmail.com   True  \n",
       "92                ursatechberkeley@gmail.com  False  \n",
       "93                      evp@vcg.berkeley.edu  False  \n",
       "94                        cal.vhio@gmail.com   True  \n",
       "95          info.voyagerconsulting@gmail.com   True  \n",
       "96                     youmeanmore@gmail.com   True  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "existing_clubs_df_by_name = pd.merge(\n",
    "    club_json_df, club_db_df,\n",
    "    how='inner', on='name',\n",
    "    suffixes=('_callink', '_mongo')\n",
    ")\n",
    "\n",
    "matching_emails = existing_clubs_df_by_name['email_callink'] == existing_clubs_df_by_name['email_mongo']\n",
    "existing_clubs_df_by_name['match'] = matching_emails\n",
    "existing_clubs_df_by_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "# of matching emails: 68\n",
      "# of non-matching emails: 29\n",
      "% of matching emails: 70.1%\n"
     ]
    }
   ],
   "source": [
    "print('# of matching emails:', sum(matching_emails))\n",
    "print('# of non-matching emails:', len(matching_emails) - sum(matching_emails))\n",
    "print('%% of matching emails: %.1f%%' % ( sum(matching_emails) / len(matching_emails) * 100 ))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Step 1c: Merge data by same email and name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "scrolled": true
   },
   "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>name</th>\n",
       "      <th>email</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Abba Modern</td>\n",
       "      <td>abbamodern@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>acts2fellowship</td>\n",
       "      <td>info@acts2fellowship.org</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AFX Dance</td>\n",
       "      <td>afxdance@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Alternative Breaks</td>\n",
       "      <td>berkeleyaltbreaks@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Artists in Resonance</td>\n",
       "      <td>artistsinresonanceucb@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Asha for Education, Berkeley</td>\n",
       "      <td>berkeley@ashanet.org</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Asian American and Pacific Islander Health Res...</td>\n",
       "      <td>aapihrg.info@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Asian Pacific American Pre-Law Association</td>\n",
       "      <td>ucb.apapla@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>ASUC Mental Health Commission</td>\n",
       "      <td>mentalhealthcommission@asuc.org</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>ASUC Student Legal Clinic</td>\n",
       "      <td>asuclegalclinic@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Aurum Cosmetics</td>\n",
       "      <td>calaurumcosmetics@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Berkeley Innovation</td>\n",
       "      <td>berkeley.innovation@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Berkeley Scientific Journal</td>\n",
       "      <td>bsj.berkeley@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Big Data at Berkeley</td>\n",
       "      <td>bigdata.berkeley@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>BioethiCAL</td>\n",
       "      <td>bioethical.berkeley@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Biofuels Technology Club</td>\n",
       "      <td>biofuelstechnology@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Blockeley</td>\n",
       "      <td>info@blockeley.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Blueprint, Technology for Nonprofits</td>\n",
       "      <td>team@calblueprint.org</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Business Review at Berkeley</td>\n",
       "      <td>businessreviewatberkeley@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Cal Figure Skating</td>\n",
       "      <td>ucbfigureskating@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Cal Seismic Design Team</td>\n",
       "      <td>calseismicteam@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>CalSol</td>\n",
       "      <td>calsol-me@berkeley.edu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Codebase</td>\n",
       "      <td>contact@codebase.berkeley.edu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Codeology</td>\n",
       "      <td>info@codeology.club</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Cub Support</td>\n",
       "      <td>ucbears4cubs@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Dance the Bay</td>\n",
       "      <td>dancethebay@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Danceworx</td>\n",
       "      <td>dwxpresidents@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>DataStory</td>\n",
       "      <td>datastory.president@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Delta Xi Phi Multicultural Sorority</td>\n",
       "      <td>ucbdeltaxiphi@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Design at Berkeley</td>\n",
       "      <td>designatberk@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>DiversaTech</td>\n",
       "      <td>diversatech.berkeley@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Eggster Organization</td>\n",
       "      <td>eggsteroverall@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>EXP Dance</td>\n",
       "      <td>expdancecrew@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Extended Reality at Berkeley</td>\n",
       "      <td>contact@xr.berkeley.edu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Gamma Rho Lambda</td>\n",
       "      <td>lambda@gammarholambda.org</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Girls Who Code at Berkeley</td>\n",
       "      <td>gwcberkeley@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Global Research and Consulting Group at Berkeley</td>\n",
       "      <td>berkeley@grcglobalgroup.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>GlobeMed at Berkeley</td>\n",
       "      <td>berkeley@globemed.org</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Hep B Project</td>\n",
       "      <td>hepbproject@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Indian Students Association</td>\n",
       "      <td>contact@isa.berkeley.edu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Kappa Gamma Delta</td>\n",
       "      <td>ucbkgdpresident@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Launchpad</td>\n",
       "      <td>team@callaunchpad.org</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>LW Passion Fellowship</td>\n",
       "      <td>passionlivingwater@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Medical Reallocation Initiative</td>\n",
       "      <td>contact@mri.berkeley.edu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Microfinance at Berkeley</td>\n",
       "      <td>berkeleymicrofinance@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Mobile Developers of Berkeley</td>\n",
       "      <td>contact@mdb.dev</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Nikkei Student Union</td>\n",
       "      <td>berkeleynsu@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Peer Health Exchange</td>\n",
       "      <td>ucb.phe@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Phi Alpha Theta</td>\n",
       "      <td>phat.berkeley@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Phi Delta Epsilon</td>\n",
       "      <td>berkeleyphide@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>PlexTech</td>\n",
       "      <td>info@plextech.berkeley.edu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Pre-Pharmacy Informational, Learning and Leade...</td>\n",
       "      <td>pills.prepharmacy@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Reinnervate</td>\n",
       "      <td>reinnervate@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Sigma Alpha Nu</td>\n",
       "      <td>sigmaalphanu.cal@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>SKY Campus Happiness Club at Berkeley</td>\n",
       "      <td>skybreathingberkeley@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Society of Women Engineers</td>\n",
       "      <td>swe.berkeley@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Space Enterprise at Berkeley</td>\n",
       "      <td>info@seb.berkeley.edu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Sri Lankan Students Association</td>\n",
       "      <td>ucbslsa@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Student to Student Peer Counseling</td>\n",
       "      <td>sspcemail@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Taiwanese Student Association</td>\n",
       "      <td>tsa.berkeley@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Team HBV</td>\n",
       "      <td>ucberkeley@teamhbv.org</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Translational Medicine and Stem Cell Association</td>\n",
       "      <td>tmscaberkeley@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Tzu Chi Compassion Relief Foundation</td>\n",
       "      <td>berkeleytc@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>UC Berkeley Model United Nations</td>\n",
       "      <td>secretary@ucbmun.org</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Undergraduate Economics Association</td>\n",
       "      <td>ucberkeleyuea@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Volunteer Health Interpreters Organization</td>\n",
       "      <td>cal.vhio@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Voyager Consulting</td>\n",
       "      <td>info.voyagerconsulting@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>You Mean More</td>\n",
       "      <td>youmeanmore@gmail.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 name  \\\n",
       "0                                         Abba Modern   \n",
       "1                                     acts2fellowship   \n",
       "2                                           AFX Dance   \n",
       "3                                  Alternative Breaks   \n",
       "4                                Artists in Resonance   \n",
       "5                        Asha for Education, Berkeley   \n",
       "6   Asian American and Pacific Islander Health Res...   \n",
       "7          Asian Pacific American Pre-Law Association   \n",
       "8                       ASUC Mental Health Commission   \n",
       "9                           ASUC Student Legal Clinic   \n",
       "10                                    Aurum Cosmetics   \n",
       "11                                Berkeley Innovation   \n",
       "12                        Berkeley Scientific Journal   \n",
       "13                               Big Data at Berkeley   \n",
       "14                                         BioethiCAL   \n",
       "15                           Biofuels Technology Club   \n",
       "16                                          Blockeley   \n",
       "17               Blueprint, Technology for Nonprofits   \n",
       "18                        Business Review at Berkeley   \n",
       "19                                 Cal Figure Skating   \n",
       "20                            Cal Seismic Design Team   \n",
       "21                                             CalSol   \n",
       "22                                           Codebase   \n",
       "23                                          Codeology   \n",
       "24                                        Cub Support   \n",
       "25                                      Dance the Bay   \n",
       "26                                          Danceworx   \n",
       "27                                          DataStory   \n",
       "28                Delta Xi Phi Multicultural Sorority   \n",
       "29                                 Design at Berkeley   \n",
       "30                                        DiversaTech   \n",
       "31                               Eggster Organization   \n",
       "32                                          EXP Dance   \n",
       "33                       Extended Reality at Berkeley   \n",
       "34                                   Gamma Rho Lambda   \n",
       "35                         Girls Who Code at Berkeley   \n",
       "36   Global Research and Consulting Group at Berkeley   \n",
       "37                               GlobeMed at Berkeley   \n",
       "38                                      Hep B Project   \n",
       "39                        Indian Students Association   \n",
       "40                                  Kappa Gamma Delta   \n",
       "41                                          Launchpad   \n",
       "42                              LW Passion Fellowship   \n",
       "43                    Medical Reallocation Initiative   \n",
       "44                           Microfinance at Berkeley   \n",
       "45                      Mobile Developers of Berkeley   \n",
       "46                               Nikkei Student Union   \n",
       "47                               Peer Health Exchange   \n",
       "48                                    Phi Alpha Theta   \n",
       "49                                  Phi Delta Epsilon   \n",
       "50                                           PlexTech   \n",
       "51  Pre-Pharmacy Informational, Learning and Leade...   \n",
       "52                                        Reinnervate   \n",
       "53                                     Sigma Alpha Nu   \n",
       "54              SKY Campus Happiness Club at Berkeley   \n",
       "55                         Society of Women Engineers   \n",
       "56                       Space Enterprise at Berkeley   \n",
       "57                    Sri Lankan Students Association   \n",
       "58                 Student to Student Peer Counseling   \n",
       "59                      Taiwanese Student Association   \n",
       "60                                           Team HBV   \n",
       "61   Translational Medicine and Stem Cell Association   \n",
       "62               Tzu Chi Compassion Relief Foundation   \n",
       "63                   UC Berkeley Model United Nations   \n",
       "64                Undergraduate Economics Association   \n",
       "65         Volunteer Health Interpreters Organization   \n",
       "66                                 Voyager Consulting   \n",
       "67                                      You Mean More   \n",
       "\n",
       "                                 email  \n",
       "0                 abbamodern@gmail.com  \n",
       "1             info@acts2fellowship.org  \n",
       "2                   afxdance@gmail.com  \n",
       "3          berkeleyaltbreaks@gmail.com  \n",
       "4      artistsinresonanceucb@gmail.com  \n",
       "5                 berkeley@ashanet.org  \n",
       "6               aapihrg.info@gmail.com  \n",
       "7                 ucb.apapla@gmail.com  \n",
       "8      mentalhealthcommission@asuc.org  \n",
       "9            asuclegalclinic@gmail.com  \n",
       "10         calaurumcosmetics@gmail.com  \n",
       "11       berkeley.innovation@gmail.com  \n",
       "12              bsj.berkeley@gmail.com  \n",
       "13          bigdata.berkeley@gmail.com  \n",
       "14       bioethical.berkeley@gmail.com  \n",
       "15        biofuelstechnology@gmail.com  \n",
       "16                  info@blockeley.com  \n",
       "17               team@calblueprint.org  \n",
       "18  businessreviewatberkeley@gmail.com  \n",
       "19          ucbfigureskating@gmail.com  \n",
       "20            calseismicteam@gmail.com  \n",
       "21              calsol-me@berkeley.edu  \n",
       "22       contact@codebase.berkeley.edu  \n",
       "23                 info@codeology.club  \n",
       "24              ucbears4cubs@gmail.com  \n",
       "25               dancethebay@gmail.com  \n",
       "26             dwxpresidents@gmail.com  \n",
       "27       datastory.president@gmail.com  \n",
       "28             ucbdeltaxiphi@gmail.com  \n",
       "29              designatberk@gmail.com  \n",
       "30      diversatech.berkeley@gmail.com  \n",
       "31            eggsteroverall@gmail.com  \n",
       "32              expdancecrew@gmail.com  \n",
       "33             contact@xr.berkeley.edu  \n",
       "34           lambda@gammarholambda.org  \n",
       "35               gwcberkeley@gmail.com  \n",
       "36         berkeley@grcglobalgroup.com  \n",
       "37               berkeley@globemed.org  \n",
       "38               hepbproject@gmail.com  \n",
       "39            contact@isa.berkeley.edu  \n",
       "40           ucbkgdpresident@gmail.com  \n",
       "41               team@callaunchpad.org  \n",
       "42        passionlivingwater@gmail.com  \n",
       "43            contact@mri.berkeley.edu  \n",
       "44      berkeleymicrofinance@gmail.com  \n",
       "45                     contact@mdb.dev  \n",
       "46               berkeleynsu@gmail.com  \n",
       "47                   ucb.phe@gmail.com  \n",
       "48             phat.berkeley@gmail.com  \n",
       "49             berkeleyphide@gmail.com  \n",
       "50          info@plextech.berkeley.edu  \n",
       "51         pills.prepharmacy@gmail.com  \n",
       "52               reinnervate@gmail.com  \n",
       "53          sigmaalphanu.cal@gmail.com  \n",
       "54      skybreathingberkeley@gmail.com  \n",
       "55              swe.berkeley@gmail.com  \n",
       "56               info@seb.berkeley.edu  \n",
       "57                   ucbslsa@gmail.com  \n",
       "58                 sspcemail@gmail.com  \n",
       "59              tsa.berkeley@gmail.com  \n",
       "60              ucberkeley@teamhbv.org  \n",
       "61             tmscaberkeley@gmail.com  \n",
       "62                berkeleytc@gmail.com  \n",
       "63                secretary@ucbmun.org  \n",
       "64             ucberkeleyuea@gmail.com  \n",
       "65                  cal.vhio@gmail.com  \n",
       "66    info.voyagerconsulting@gmail.com  \n",
       "67               youmeanmore@gmail.com  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "existing_clubs_df_by_email_name = pd.merge(\n",
    "    club_json_df, club_db_df,\n",
    "    how='inner',\n",
    "    suffixes=('_callink', '_mongo')\n",
    ")\n",
    "\n",
    "existing_clubs_df_by_email_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "# of clubs matching by name and email: 68\n"
     ]
    }
   ],
   "source": [
    "print('# of clubs matching by name and email:', len(existing_clubs_df_by_email_name))"
   ]
  }
 ],
 "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
}