ETL_Mini_Project_DLami_DImanova.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Import dependencies\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "pd.set_option('max_colwidth', 400)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Extract the crowdfunding.xlsx 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>cf_id</th>\n",
       "      <th>contact_id</th>\n",
       "      <th>company_name</th>\n",
       "      <th>blurb</th>\n",
       "      <th>goal</th>\n",
       "      <th>pledged</th>\n",
       "      <th>outcome</th>\n",
       "      <th>backers_count</th>\n",
       "      <th>country</th>\n",
       "      <th>currency</th>\n",
       "      <th>launched_at</th>\n",
       "      <th>deadline</th>\n",
       "      <th>staff_pick</th>\n",
       "      <th>spotlight</th>\n",
       "      <th>category &amp; sub-category</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>147</td>\n",
       "      <td>4661</td>\n",
       "      <td>Baldwin, Riley and Jackson</td>\n",
       "      <td>Pre-emptive tertiary standardization</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>failed</td>\n",
       "      <td>0</td>\n",
       "      <td>CA</td>\n",
       "      <td>CAD</td>\n",
       "      <td>1581573600</td>\n",
       "      <td>1614578400</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>food/food trucks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1621</td>\n",
       "      <td>3765</td>\n",
       "      <td>Odom Inc</td>\n",
       "      <td>Managed bottom-line architecture</td>\n",
       "      <td>1400</td>\n",
       "      <td>14560</td>\n",
       "      <td>successful</td>\n",
       "      <td>158</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1611554400</td>\n",
       "      <td>1621918800</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>music/rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1812</td>\n",
       "      <td>4187</td>\n",
       "      <td>Melton, Robinson and Fritz</td>\n",
       "      <td>Function-based leadingedge pricing structure</td>\n",
       "      <td>108400</td>\n",
       "      <td>142523</td>\n",
       "      <td>successful</td>\n",
       "      <td>1425</td>\n",
       "      <td>AU</td>\n",
       "      <td>AUD</td>\n",
       "      <td>1608184800</td>\n",
       "      <td>1640844000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>technology/web</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2156</td>\n",
       "      <td>4941</td>\n",
       "      <td>Mcdonald, Gonzalez and Ross</td>\n",
       "      <td>Vision-oriented fresh-thinking conglomeration</td>\n",
       "      <td>4200</td>\n",
       "      <td>2477</td>\n",
       "      <td>failed</td>\n",
       "      <td>24</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1634792400</td>\n",
       "      <td>1642399200</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>music/rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1365</td>\n",
       "      <td>2199</td>\n",
       "      <td>Larson-Little</td>\n",
       "      <td>Proactive foreground core</td>\n",
       "      <td>7600</td>\n",
       "      <td>5265</td>\n",
       "      <td>failed</td>\n",
       "      <td>53</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1608530400</td>\n",
       "      <td>1629694800</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>theater/plays</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   cf_id  contact_id                 company_name  \\\n",
       "0    147        4661   Baldwin, Riley and Jackson   \n",
       "1   1621        3765                     Odom Inc   \n",
       "2   1812        4187   Melton, Robinson and Fritz   \n",
       "3   2156        4941  Mcdonald, Gonzalez and Ross   \n",
       "4   1365        2199                Larson-Little   \n",
       "\n",
       "                                           blurb    goal  pledged     outcome  \\\n",
       "0           Pre-emptive tertiary standardization     100        0      failed   \n",
       "1               Managed bottom-line architecture    1400    14560  successful   \n",
       "2   Function-based leadingedge pricing structure  108400   142523  successful   \n",
       "3  Vision-oriented fresh-thinking conglomeration    4200     2477      failed   \n",
       "4                      Proactive foreground core    7600     5265      failed   \n",
       "\n",
       "   backers_count country currency  launched_at    deadline  staff_pick  \\\n",
       "0              0      CA      CAD   1581573600  1614578400       False   \n",
       "1            158      US      USD   1611554400  1621918800       False   \n",
       "2           1425      AU      AUD   1608184800  1640844000       False   \n",
       "3             24      US      USD   1634792400  1642399200       False   \n",
       "4             53      US      USD   1608530400  1629694800       False   \n",
       "\n",
       "   spotlight category & sub-category  \n",
       "0      False        food/food trucks  \n",
       "1       True              music/rock  \n",
       "2      False          technology/web  \n",
       "3      False              music/rock  \n",
       "4      False           theater/plays  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Read the data into a Pandas DataFrame\n",
    "crowdfunding_info_df = pd.read_excel('Resources/crowdfunding.xlsx')\n",
    "crowdfunding_info_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1000 entries, 0 to 999\n",
      "Data columns (total 15 columns):\n",
      " #   Column                   Non-Null Count  Dtype \n",
      "---  ------                   --------------  ----- \n",
      " 0   cf_id                    1000 non-null   int64 \n",
      " 1   contact_id               1000 non-null   int64 \n",
      " 2   company_name             1000 non-null   object\n",
      " 3   blurb                    1000 non-null   object\n",
      " 4   goal                     1000 non-null   int64 \n",
      " 5   pledged                  1000 non-null   int64 \n",
      " 6   outcome                  1000 non-null   object\n",
      " 7   backers_count            1000 non-null   int64 \n",
      " 8   country                  1000 non-null   object\n",
      " 9   currency                 1000 non-null   object\n",
      " 10  launched_at              1000 non-null   int64 \n",
      " 11  deadline                 1000 non-null   int64 \n",
      " 12  staff_pick               1000 non-null   bool  \n",
      " 13  spotlight                1000 non-null   bool  \n",
      " 14  category & sub-category  1000 non-null   object\n",
      "dtypes: bool(2), int64(7), object(6)\n",
      "memory usage: 103.6+ KB\n"
     ]
    }
   ],
   "source": [
    "# Get a brief summary of the crowdfunding_info DataFrame.\n",
    "crowdfunding_info_df.info()\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Create the Category and Subcategory DataFrames\n",
    "---\n",
    "**Create a Category DataFrame that has the following columns:**\n",
    "- A \"category_id\" column that is numbered sequential form 1 to the length of the number of unique categories.\n",
    "- A \"category\" column that has only the categories.\n",
    "\n",
    "Export the DataFrame as a `category.csv` CSV file.\n",
    "\n",
    "**Create a SubCategory DataFrame that has the following columns:**\n",
    "- A \"subcategory_id\" column that is numbered sequential form 1 to the length of the number of unique subcategories.\n",
    "- A \"subcategory\" column that has only the subcategories. \n",
    "\n",
    "Export the DataFrame as a `subcategory.csv` CSV file."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['cf_id', 'contact_id', 'company_name', 'blurb', 'goal', 'pledged',\n",
       "       'outcome', 'backers_count', 'country', 'currency', 'launched_at',\n",
       "       'deadline', 'staff_pick', 'spotlight', 'category & sub-category'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get the crowdfunding_info_df columns.\n",
    "crowdfunding_info_df.columns"
   ]
  },
  {
   "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>cf_id</th>\n",
       "      <th>contact_id</th>\n",
       "      <th>company_name</th>\n",
       "      <th>blurb</th>\n",
       "      <th>goal</th>\n",
       "      <th>pledged</th>\n",
       "      <th>outcome</th>\n",
       "      <th>backers_count</th>\n",
       "      <th>country</th>\n",
       "      <th>currency</th>\n",
       "      <th>launched_at</th>\n",
       "      <th>deadline</th>\n",
       "      <th>staff_pick</th>\n",
       "      <th>spotlight</th>\n",
       "      <th>category &amp; sub-category</th>\n",
       "      <th>category</th>\n",
       "      <th>subcategory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>147</td>\n",
       "      <td>4661</td>\n",
       "      <td>Baldwin, Riley and Jackson</td>\n",
       "      <td>Pre-emptive tertiary standardization</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>failed</td>\n",
       "      <td>0</td>\n",
       "      <td>CA</td>\n",
       "      <td>CAD</td>\n",
       "      <td>1581573600</td>\n",
       "      <td>1614578400</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>food/food trucks</td>\n",
       "      <td>food</td>\n",
       "      <td>food trucks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1621</td>\n",
       "      <td>3765</td>\n",
       "      <td>Odom Inc</td>\n",
       "      <td>Managed bottom-line architecture</td>\n",
       "      <td>1400</td>\n",
       "      <td>14560</td>\n",
       "      <td>successful</td>\n",
       "      <td>158</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1611554400</td>\n",
       "      <td>1621918800</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>music/rock</td>\n",
       "      <td>music</td>\n",
       "      <td>rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1812</td>\n",
       "      <td>4187</td>\n",
       "      <td>Melton, Robinson and Fritz</td>\n",
       "      <td>Function-based leadingedge pricing structure</td>\n",
       "      <td>108400</td>\n",
       "      <td>142523</td>\n",
       "      <td>successful</td>\n",
       "      <td>1425</td>\n",
       "      <td>AU</td>\n",
       "      <td>AUD</td>\n",
       "      <td>1608184800</td>\n",
       "      <td>1640844000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>technology/web</td>\n",
       "      <td>technology</td>\n",
       "      <td>web</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2156</td>\n",
       "      <td>4941</td>\n",
       "      <td>Mcdonald, Gonzalez and Ross</td>\n",
       "      <td>Vision-oriented fresh-thinking conglomeration</td>\n",
       "      <td>4200</td>\n",
       "      <td>2477</td>\n",
       "      <td>failed</td>\n",
       "      <td>24</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1634792400</td>\n",
       "      <td>1642399200</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>music/rock</td>\n",
       "      <td>music</td>\n",
       "      <td>rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1365</td>\n",
       "      <td>2199</td>\n",
       "      <td>Larson-Little</td>\n",
       "      <td>Proactive foreground core</td>\n",
       "      <td>7600</td>\n",
       "      <td>5265</td>\n",
       "      <td>failed</td>\n",
       "      <td>53</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1608530400</td>\n",
       "      <td>1629694800</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>theater/plays</td>\n",
       "      <td>theater</td>\n",
       "      <td>plays</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   cf_id  contact_id                 company_name  \\\n",
       "0    147        4661   Baldwin, Riley and Jackson   \n",
       "1   1621        3765                     Odom Inc   \n",
       "2   1812        4187   Melton, Robinson and Fritz   \n",
       "3   2156        4941  Mcdonald, Gonzalez and Ross   \n",
       "4   1365        2199                Larson-Little   \n",
       "\n",
       "                                           blurb    goal  pledged     outcome  \\\n",
       "0           Pre-emptive tertiary standardization     100        0      failed   \n",
       "1               Managed bottom-line architecture    1400    14560  successful   \n",
       "2   Function-based leadingedge pricing structure  108400   142523  successful   \n",
       "3  Vision-oriented fresh-thinking conglomeration    4200     2477      failed   \n",
       "4                      Proactive foreground core    7600     5265      failed   \n",
       "\n",
       "   backers_count country currency  launched_at    deadline  staff_pick  \\\n",
       "0              0      CA      CAD   1581573600  1614578400       False   \n",
       "1            158      US      USD   1611554400  1621918800       False   \n",
       "2           1425      AU      AUD   1608184800  1640844000       False   \n",
       "3             24      US      USD   1634792400  1642399200       False   \n",
       "4             53      US      USD   1608530400  1629694800       False   \n",
       "\n",
       "   spotlight category & sub-category    category  subcategory  \n",
       "0      False        food/food trucks        food  food trucks  \n",
       "1       True              music/rock       music         rock  \n",
       "2      False          technology/web  technology          web  \n",
       "3      False              music/rock       music         rock  \n",
       "4      False           theater/plays     theater        plays  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Assign the category and subcategory values to category and subcategory columns.\n",
    "crowdfunding_info_df[['category','subcategory']] = crowdfunding_info_df['category & sub-category'].str.split('/', n=1, expand= True)\n",
    "crowdfunding_info_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['food' 'music' 'technology' 'theater' 'film & video' 'publishing' 'games'\n",
      " 'photography' 'journalism']\n",
      "['food trucks' 'rock' 'web' 'plays' 'documentary' 'electric music' 'drama'\n",
      " 'indie rock' 'wearables' 'nonfiction' 'animation' 'video games' 'shorts'\n",
      " 'fiction' 'photography books' 'radio & podcasts' 'metal' 'jazz'\n",
      " 'translations' 'television' 'mobile games' 'world music'\n",
      " 'science fiction' 'audio']\n"
     ]
    }
   ],
   "source": [
    "# Get the unique categories and subcategories in separate lists.\n",
    "categories = crowdfunding_info_df['category'].unique()\n",
    "subcategories = crowdfunding_info_df['subcategory'].unique()\n",
    "\n",
    "print(categories)\n",
    "print(subcategories)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "9\n",
      "24\n"
     ]
    }
   ],
   "source": [
    "# Get the number of distinct values in the categories and subcategories lists.\n",
    "print(len(categories))\n",
    "print(len(subcategories))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[1 2 3 4 5 6 7 8 9]\n",
      "[ 1  2  3  4  5  6  7  8  9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24]\n"
     ]
    }
   ],
   "source": [
    "# Create numpy arrays from 1-9 for the categories and 1-24 for the subcategories.\n",
    "category_ids = np.arange(1, 10)\n",
    "subcategory_ids = np.arange(1, 25)\n",
    "\n",
    "print(category_ids)\n",
    "print(subcategory_ids)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['cat1', 'cat2', 'cat3', 'cat4', 'cat5', 'cat6', 'cat7', 'cat8', 'cat9']\n",
      "['subcat1', 'subcat2', 'subcat3', 'subcat4', 'subcat5', 'subcat6', 'subcat7', 'subcat8', 'subcat9', 'subcat10', 'subcat11', 'subcat12', 'subcat13', 'subcat14', 'subcat15', 'subcat16', 'subcat17', 'subcat18', 'subcat19', 'subcat20', 'subcat21', 'subcat22', 'subcat23', 'subcat24']\n"
     ]
    }
   ],
   "source": [
    "# Use a list comprehension to add \"cat\" to each category_id. \n",
    "cat_ids = [\"cat\" + str(c_id) for c_id in category_ids]\n",
    "# Use a list comprehension to add \"subcat\" to each subcategory_id.    \n",
    "scat_ids = [\"subcat\" + str(s_id) for s_id in subcategory_ids]\n",
    "    \n",
    "print(cat_ids)\n",
    "print(scat_ids)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create a category DataFrame with the category_id array as the category_id and categories list as the category name.\n",
    "category_df = pd.DataFrame({'category_id' : cat_ids, 'category':categories })\n",
    "# Create a category DataFrame with the subcategory_id array as the subcategory_id and subcategories list as the subcategory name. \n",
    "subcategory_df = pd.DataFrame({'subcategory_id' : scat_ids, 'subcategory':subcategories })"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>category_id</th>\n",
       "      <th>category</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>cat1</td>\n",
       "      <td>food</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>cat2</td>\n",
       "      <td>music</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>cat3</td>\n",
       "      <td>technology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>cat4</td>\n",
       "      <td>theater</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>cat5</td>\n",
       "      <td>film &amp; video</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>cat6</td>\n",
       "      <td>publishing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>cat7</td>\n",
       "      <td>games</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>cat8</td>\n",
       "      <td>photography</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>cat9</td>\n",
       "      <td>journalism</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  category_id      category\n",
       "0        cat1          food\n",
       "1        cat2         music\n",
       "2        cat3    technology\n",
       "3        cat4       theater\n",
       "4        cat5  film & video\n",
       "5        cat6    publishing\n",
       "6        cat7         games\n",
       "7        cat8   photography\n",
       "8        cat9    journalism"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "category_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>subcategory_id</th>\n",
       "      <th>subcategory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>subcat1</td>\n",
       "      <td>food trucks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>subcat2</td>\n",
       "      <td>rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>subcat3</td>\n",
       "      <td>web</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>subcat4</td>\n",
       "      <td>plays</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>subcat5</td>\n",
       "      <td>documentary</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>subcat6</td>\n",
       "      <td>electric music</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>subcat7</td>\n",
       "      <td>drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>subcat8</td>\n",
       "      <td>indie rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>subcat9</td>\n",
       "      <td>wearables</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>subcat10</td>\n",
       "      <td>nonfiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>subcat11</td>\n",
       "      <td>animation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>subcat12</td>\n",
       "      <td>video games</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>subcat13</td>\n",
       "      <td>shorts</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>subcat14</td>\n",
       "      <td>fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>subcat15</td>\n",
       "      <td>photography books</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>subcat16</td>\n",
       "      <td>radio &amp; podcasts</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>subcat17</td>\n",
       "      <td>metal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>subcat18</td>\n",
       "      <td>jazz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>subcat19</td>\n",
       "      <td>translations</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>subcat20</td>\n",
       "      <td>television</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>subcat21</td>\n",
       "      <td>mobile games</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>subcat22</td>\n",
       "      <td>world music</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>subcat23</td>\n",
       "      <td>science fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>subcat24</td>\n",
       "      <td>audio</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   subcategory_id        subcategory\n",
       "0         subcat1        food trucks\n",
       "1         subcat2               rock\n",
       "2         subcat3                web\n",
       "3         subcat4              plays\n",
       "4         subcat5        documentary\n",
       "5         subcat6     electric music\n",
       "6         subcat7              drama\n",
       "7         subcat8         indie rock\n",
       "8         subcat9          wearables\n",
       "9        subcat10         nonfiction\n",
       "10       subcat11          animation\n",
       "11       subcat12        video games\n",
       "12       subcat13             shorts\n",
       "13       subcat14            fiction\n",
       "14       subcat15  photography books\n",
       "15       subcat16   radio & podcasts\n",
       "16       subcat17              metal\n",
       "17       subcat18               jazz\n",
       "18       subcat19       translations\n",
       "19       subcat20         television\n",
       "20       subcat21       mobile games\n",
       "21       subcat22        world music\n",
       "22       subcat23    science fiction\n",
       "23       subcat24              audio"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "subcategory_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Export categories_df and subcategories_df as CSV files.\n",
    "category_df.to_csv(\"Resources/category.csv\", index=False)\n",
    "\n",
    "subcategory_df.to_csv(\"Resources/subcategory.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Campaign DataFrame\n",
    "----\n",
    "**Create a Campaign DataFrame that has the following columns:**\n",
    "- The \"cf_id\" column.\n",
    "- The \"contact_id\" column.\n",
    "- The “company_name” column.\n",
    "- The \"blurb\" column is renamed as \"description.\"\n",
    "- The \"goal\" column.\n",
    "- The \"goal\" column is converted to a `float` datatype.\n",
    "- The \"pledged\" column is converted to a `float` datatype. \n",
    "- The \"backers_count\" column. \n",
    "- The \"country\" column.\n",
    "- The \"currency\" column.\n",
    "- The \"launched_at\" column is renamed as \"launch_date\" and converted to a datetime format. \n",
    "- The \"deadline\" column is renamed as \"end_date\" and converted to a datetime format.\n",
    "- The \"category_id\" with the unique number matching the “category_id” from the category DataFrame. \n",
    "- The \"subcategory_id\" with the unique number matching the “subcategory_id” from the subcategory DataFrame.\n",
    "- And, create a column that contains the unique four-digit contact ID number from the `contact.xlsx` file.\n",
    " \n",
    "\n",
    "Then export the DataFrame as a `campaign.csv` CSV file.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>cf_id</th>\n",
       "      <th>contact_id</th>\n",
       "      <th>company_name</th>\n",
       "      <th>blurb</th>\n",
       "      <th>goal</th>\n",
       "      <th>pledged</th>\n",
       "      <th>outcome</th>\n",
       "      <th>backers_count</th>\n",
       "      <th>country</th>\n",
       "      <th>currency</th>\n",
       "      <th>launched_at</th>\n",
       "      <th>deadline</th>\n",
       "      <th>staff_pick</th>\n",
       "      <th>spotlight</th>\n",
       "      <th>category &amp; sub-category</th>\n",
       "      <th>category</th>\n",
       "      <th>subcategory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>147</td>\n",
       "      <td>4661</td>\n",
       "      <td>Baldwin, Riley and Jackson</td>\n",
       "      <td>Pre-emptive tertiary standardization</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>failed</td>\n",
       "      <td>0</td>\n",
       "      <td>CA</td>\n",
       "      <td>CAD</td>\n",
       "      <td>1581573600</td>\n",
       "      <td>1614578400</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>food/food trucks</td>\n",
       "      <td>food</td>\n",
       "      <td>food trucks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1621</td>\n",
       "      <td>3765</td>\n",
       "      <td>Odom Inc</td>\n",
       "      <td>Managed bottom-line architecture</td>\n",
       "      <td>1400</td>\n",
       "      <td>14560</td>\n",
       "      <td>successful</td>\n",
       "      <td>158</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1611554400</td>\n",
       "      <td>1621918800</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>music/rock</td>\n",
       "      <td>music</td>\n",
       "      <td>rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1812</td>\n",
       "      <td>4187</td>\n",
       "      <td>Melton, Robinson and Fritz</td>\n",
       "      <td>Function-based leadingedge pricing structure</td>\n",
       "      <td>108400</td>\n",
       "      <td>142523</td>\n",
       "      <td>successful</td>\n",
       "      <td>1425</td>\n",
       "      <td>AU</td>\n",
       "      <td>AUD</td>\n",
       "      <td>1608184800</td>\n",
       "      <td>1640844000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>technology/web</td>\n",
       "      <td>technology</td>\n",
       "      <td>web</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2156</td>\n",
       "      <td>4941</td>\n",
       "      <td>Mcdonald, Gonzalez and Ross</td>\n",
       "      <td>Vision-oriented fresh-thinking conglomeration</td>\n",
       "      <td>4200</td>\n",
       "      <td>2477</td>\n",
       "      <td>failed</td>\n",
       "      <td>24</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1634792400</td>\n",
       "      <td>1642399200</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>music/rock</td>\n",
       "      <td>music</td>\n",
       "      <td>rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1365</td>\n",
       "      <td>2199</td>\n",
       "      <td>Larson-Little</td>\n",
       "      <td>Proactive foreground core</td>\n",
       "      <td>7600</td>\n",
       "      <td>5265</td>\n",
       "      <td>failed</td>\n",
       "      <td>53</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1608530400</td>\n",
       "      <td>1629694800</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>theater/plays</td>\n",
       "      <td>theater</td>\n",
       "      <td>plays</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   cf_id  contact_id                 company_name  \\\n",
       "0    147        4661   Baldwin, Riley and Jackson   \n",
       "1   1621        3765                     Odom Inc   \n",
       "2   1812        4187   Melton, Robinson and Fritz   \n",
       "3   2156        4941  Mcdonald, Gonzalez and Ross   \n",
       "4   1365        2199                Larson-Little   \n",
       "\n",
       "                                           blurb    goal  pledged     outcome  \\\n",
       "0           Pre-emptive tertiary standardization     100        0      failed   \n",
       "1               Managed bottom-line architecture    1400    14560  successful   \n",
       "2   Function-based leadingedge pricing structure  108400   142523  successful   \n",
       "3  Vision-oriented fresh-thinking conglomeration    4200     2477      failed   \n",
       "4                      Proactive foreground core    7600     5265      failed   \n",
       "\n",
       "   backers_count country currency  launched_at    deadline  staff_pick  \\\n",
       "0              0      CA      CAD   1581573600  1614578400       False   \n",
       "1            158      US      USD   1611554400  1621918800       False   \n",
       "2           1425      AU      AUD   1608184800  1640844000       False   \n",
       "3             24      US      USD   1634792400  1642399200       False   \n",
       "4             53      US      USD   1608530400  1629694800       False   \n",
       "\n",
       "   spotlight category & sub-category    category  subcategory  \n",
       "0      False        food/food trucks        food  food trucks  \n",
       "1       True              music/rock       music         rock  \n",
       "2      False          technology/web  technology          web  \n",
       "3      False              music/rock       music         rock  \n",
       "4      False           theater/plays     theater        plays  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create a copy of the crowdfunding_info_df DataFrame name campaign_df. \n",
    "campaign_df = crowdfunding_info_df.copy()\n",
    "campaign_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>cf_id</th>\n",
       "      <th>contact_id</th>\n",
       "      <th>company_name</th>\n",
       "      <th>description</th>\n",
       "      <th>goal</th>\n",
       "      <th>pledged</th>\n",
       "      <th>outcome</th>\n",
       "      <th>backers_count</th>\n",
       "      <th>country</th>\n",
       "      <th>currency</th>\n",
       "      <th>launched_date</th>\n",
       "      <th>end_date</th>\n",
       "      <th>staff_pick</th>\n",
       "      <th>spotlight</th>\n",
       "      <th>category &amp; sub-category</th>\n",
       "      <th>category</th>\n",
       "      <th>subcategory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>147</td>\n",
       "      <td>4661</td>\n",
       "      <td>Baldwin, Riley and Jackson</td>\n",
       "      <td>Pre-emptive tertiary standardization</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>failed</td>\n",
       "      <td>0</td>\n",
       "      <td>CA</td>\n",
       "      <td>CAD</td>\n",
       "      <td>1581573600</td>\n",
       "      <td>1614578400</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>food/food trucks</td>\n",
       "      <td>food</td>\n",
       "      <td>food trucks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1621</td>\n",
       "      <td>3765</td>\n",
       "      <td>Odom Inc</td>\n",
       "      <td>Managed bottom-line architecture</td>\n",
       "      <td>1400</td>\n",
       "      <td>14560</td>\n",
       "      <td>successful</td>\n",
       "      <td>158</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1611554400</td>\n",
       "      <td>1621918800</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>music/rock</td>\n",
       "      <td>music</td>\n",
       "      <td>rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1812</td>\n",
       "      <td>4187</td>\n",
       "      <td>Melton, Robinson and Fritz</td>\n",
       "      <td>Function-based leadingedge pricing structure</td>\n",
       "      <td>108400</td>\n",
       "      <td>142523</td>\n",
       "      <td>successful</td>\n",
       "      <td>1425</td>\n",
       "      <td>AU</td>\n",
       "      <td>AUD</td>\n",
       "      <td>1608184800</td>\n",
       "      <td>1640844000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>technology/web</td>\n",
       "      <td>technology</td>\n",
       "      <td>web</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2156</td>\n",
       "      <td>4941</td>\n",
       "      <td>Mcdonald, Gonzalez and Ross</td>\n",
       "      <td>Vision-oriented fresh-thinking conglomeration</td>\n",
       "      <td>4200</td>\n",
       "      <td>2477</td>\n",
       "      <td>failed</td>\n",
       "      <td>24</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1634792400</td>\n",
       "      <td>1642399200</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>music/rock</td>\n",
       "      <td>music</td>\n",
       "      <td>rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1365</td>\n",
       "      <td>2199</td>\n",
       "      <td>Larson-Little</td>\n",
       "      <td>Proactive foreground core</td>\n",
       "      <td>7600</td>\n",
       "      <td>5265</td>\n",
       "      <td>failed</td>\n",
       "      <td>53</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1608530400</td>\n",
       "      <td>1629694800</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>theater/plays</td>\n",
       "      <td>theater</td>\n",
       "      <td>plays</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   cf_id  contact_id                 company_name  \\\n",
       "0    147        4661   Baldwin, Riley and Jackson   \n",
       "1   1621        3765                     Odom Inc   \n",
       "2   1812        4187   Melton, Robinson and Fritz   \n",
       "3   2156        4941  Mcdonald, Gonzalez and Ross   \n",
       "4   1365        2199                Larson-Little   \n",
       "\n",
       "                                     description    goal  pledged     outcome  \\\n",
       "0           Pre-emptive tertiary standardization     100        0      failed   \n",
       "1               Managed bottom-line architecture    1400    14560  successful   \n",
       "2   Function-based leadingedge pricing structure  108400   142523  successful   \n",
       "3  Vision-oriented fresh-thinking conglomeration    4200     2477      failed   \n",
       "4                      Proactive foreground core    7600     5265      failed   \n",
       "\n",
       "   backers_count country currency  launched_date    end_date  staff_pick  \\\n",
       "0              0      CA      CAD     1581573600  1614578400       False   \n",
       "1            158      US      USD     1611554400  1621918800       False   \n",
       "2           1425      AU      AUD     1608184800  1640844000       False   \n",
       "3             24      US      USD     1634792400  1642399200       False   \n",
       "4             53      US      USD     1608530400  1629694800       False   \n",
       "\n",
       "   spotlight category & sub-category    category  subcategory  \n",
       "0      False        food/food trucks        food  food trucks  \n",
       "1       True              music/rock       music         rock  \n",
       "2      False          technology/web  technology          web  \n",
       "3      False              music/rock       music         rock  \n",
       "4      False           theater/plays     theater        plays  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Rename the blurb, launched_at, and deadline columns.\n",
    "campaign_df = campaign_df.rename(columns={\"blurb\":\"description\", \"launched_at\":\"launched_date\",\"deadline\":\"end_date\"})\n",
    "campaign_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>cf_id</th>\n",
       "      <th>contact_id</th>\n",
       "      <th>company_name</th>\n",
       "      <th>description</th>\n",
       "      <th>goal</th>\n",
       "      <th>pledged</th>\n",
       "      <th>outcome</th>\n",
       "      <th>backers_count</th>\n",
       "      <th>country</th>\n",
       "      <th>currency</th>\n",
       "      <th>launched_date</th>\n",
       "      <th>end_date</th>\n",
       "      <th>staff_pick</th>\n",
       "      <th>spotlight</th>\n",
       "      <th>category &amp; sub-category</th>\n",
       "      <th>category</th>\n",
       "      <th>subcategory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>147</td>\n",
       "      <td>4661</td>\n",
       "      <td>Baldwin, Riley and Jackson</td>\n",
       "      <td>Pre-emptive tertiary standardization</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>failed</td>\n",
       "      <td>0</td>\n",
       "      <td>CA</td>\n",
       "      <td>CAD</td>\n",
       "      <td>1581573600</td>\n",
       "      <td>1614578400</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>food/food trucks</td>\n",
       "      <td>food</td>\n",
       "      <td>food trucks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1621</td>\n",
       "      <td>3765</td>\n",
       "      <td>Odom Inc</td>\n",
       "      <td>Managed bottom-line architecture</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>14560.0</td>\n",
       "      <td>successful</td>\n",
       "      <td>158</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1611554400</td>\n",
       "      <td>1621918800</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>music/rock</td>\n",
       "      <td>music</td>\n",
       "      <td>rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1812</td>\n",
       "      <td>4187</td>\n",
       "      <td>Melton, Robinson and Fritz</td>\n",
       "      <td>Function-based leadingedge pricing structure</td>\n",
       "      <td>108400.0</td>\n",
       "      <td>142523.0</td>\n",
       "      <td>successful</td>\n",
       "      <td>1425</td>\n",
       "      <td>AU</td>\n",
       "      <td>AUD</td>\n",
       "      <td>1608184800</td>\n",
       "      <td>1640844000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>technology/web</td>\n",
       "      <td>technology</td>\n",
       "      <td>web</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2156</td>\n",
       "      <td>4941</td>\n",
       "      <td>Mcdonald, Gonzalez and Ross</td>\n",
       "      <td>Vision-oriented fresh-thinking conglomeration</td>\n",
       "      <td>4200.0</td>\n",
       "      <td>2477.0</td>\n",
       "      <td>failed</td>\n",
       "      <td>24</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1634792400</td>\n",
       "      <td>1642399200</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>music/rock</td>\n",
       "      <td>music</td>\n",
       "      <td>rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1365</td>\n",
       "      <td>2199</td>\n",
       "      <td>Larson-Little</td>\n",
       "      <td>Proactive foreground core</td>\n",
       "      <td>7600.0</td>\n",
       "      <td>5265.0</td>\n",
       "      <td>failed</td>\n",
       "      <td>53</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1608530400</td>\n",
       "      <td>1629694800</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>theater/plays</td>\n",
       "      <td>theater</td>\n",
       "      <td>plays</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   cf_id  contact_id                 company_name  \\\n",
       "0    147        4661   Baldwin, Riley and Jackson   \n",
       "1   1621        3765                     Odom Inc   \n",
       "2   1812        4187   Melton, Robinson and Fritz   \n",
       "3   2156        4941  Mcdonald, Gonzalez and Ross   \n",
       "4   1365        2199                Larson-Little   \n",
       "\n",
       "                                     description      goal   pledged  \\\n",
       "0           Pre-emptive tertiary standardization     100.0       0.0   \n",
       "1               Managed bottom-line architecture    1400.0   14560.0   \n",
       "2   Function-based leadingedge pricing structure  108400.0  142523.0   \n",
       "3  Vision-oriented fresh-thinking conglomeration    4200.0    2477.0   \n",
       "4                      Proactive foreground core    7600.0    5265.0   \n",
       "\n",
       "      outcome  backers_count country currency  launched_date    end_date  \\\n",
       "0      failed              0      CA      CAD     1581573600  1614578400   \n",
       "1  successful            158      US      USD     1611554400  1621918800   \n",
       "2  successful           1425      AU      AUD     1608184800  1640844000   \n",
       "3      failed             24      US      USD     1634792400  1642399200   \n",
       "4      failed             53      US      USD     1608530400  1629694800   \n",
       "\n",
       "   staff_pick  spotlight category & sub-category    category  subcategory  \n",
       "0       False      False        food/food trucks        food  food trucks  \n",
       "1       False       True              music/rock       music         rock  \n",
       "2       False      False          technology/web  technology          web  \n",
       "3       False      False              music/rock       music         rock  \n",
       "4       False      False           theater/plays     theater        plays  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Convert the goal and pledged columns to a `float` data type.\n",
    "campaign_df['goal'] = campaign_df['goal'].astype(float)\n",
    "campaign_df['pledged'] = campaign_df['pledged'].astype(float)\n",
    "campaign_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "cf_id                        int64\n",
       "contact_id                   int64\n",
       "company_name                object\n",
       "description                 object\n",
       "goal                       float64\n",
       "pledged                    float64\n",
       "outcome                     object\n",
       "backers_count                int64\n",
       "country                     object\n",
       "currency                    object\n",
       "launched_date                int64\n",
       "end_date                     int64\n",
       "staff_pick                    bool\n",
       "spotlight                     bool\n",
       "category & sub-category     object\n",
       "category                    object\n",
       "subcategory                 object\n",
       "dtype: object"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check the datatypes\n",
    "campaign_df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>cf_id</th>\n",
       "      <th>contact_id</th>\n",
       "      <th>company_name</th>\n",
       "      <th>description</th>\n",
       "      <th>goal</th>\n",
       "      <th>pledged</th>\n",
       "      <th>outcome</th>\n",
       "      <th>backers_count</th>\n",
       "      <th>country</th>\n",
       "      <th>currency</th>\n",
       "      <th>launched_date</th>\n",
       "      <th>end_date</th>\n",
       "      <th>staff_pick</th>\n",
       "      <th>spotlight</th>\n",
       "      <th>category &amp; sub-category</th>\n",
       "      <th>category</th>\n",
       "      <th>subcategory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>147</td>\n",
       "      <td>4661</td>\n",
       "      <td>Baldwin, Riley and Jackson</td>\n",
       "      <td>Pre-emptive tertiary standardization</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>failed</td>\n",
       "      <td>0</td>\n",
       "      <td>CA</td>\n",
       "      <td>CAD</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>food/food trucks</td>\n",
       "      <td>food</td>\n",
       "      <td>food trucks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1621</td>\n",
       "      <td>3765</td>\n",
       "      <td>Odom Inc</td>\n",
       "      <td>Managed bottom-line architecture</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>14560.0</td>\n",
       "      <td>successful</td>\n",
       "      <td>158</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>music/rock</td>\n",
       "      <td>music</td>\n",
       "      <td>rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1812</td>\n",
       "      <td>4187</td>\n",
       "      <td>Melton, Robinson and Fritz</td>\n",
       "      <td>Function-based leadingedge pricing structure</td>\n",
       "      <td>108400.0</td>\n",
       "      <td>142523.0</td>\n",
       "      <td>successful</td>\n",
       "      <td>1425</td>\n",
       "      <td>AU</td>\n",
       "      <td>AUD</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>technology/web</td>\n",
       "      <td>technology</td>\n",
       "      <td>web</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2156</td>\n",
       "      <td>4941</td>\n",
       "      <td>Mcdonald, Gonzalez and Ross</td>\n",
       "      <td>Vision-oriented fresh-thinking conglomeration</td>\n",
       "      <td>4200.0</td>\n",
       "      <td>2477.0</td>\n",
       "      <td>failed</td>\n",
       "      <td>24</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>music/rock</td>\n",
       "      <td>music</td>\n",
       "      <td>rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1365</td>\n",
       "      <td>2199</td>\n",
       "      <td>Larson-Little</td>\n",
       "      <td>Proactive foreground core</td>\n",
       "      <td>7600.0</td>\n",
       "      <td>5265.0</td>\n",
       "      <td>failed</td>\n",
       "      <td>53</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>theater/plays</td>\n",
       "      <td>theater</td>\n",
       "      <td>plays</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   cf_id  contact_id                 company_name  \\\n",
       "0    147        4661   Baldwin, Riley and Jackson   \n",
       "1   1621        3765                     Odom Inc   \n",
       "2   1812        4187   Melton, Robinson and Fritz   \n",
       "3   2156        4941  Mcdonald, Gonzalez and Ross   \n",
       "4   1365        2199                Larson-Little   \n",
       "\n",
       "                                     description      goal   pledged  \\\n",
       "0           Pre-emptive tertiary standardization     100.0       0.0   \n",
       "1               Managed bottom-line architecture    1400.0   14560.0   \n",
       "2   Function-based leadingedge pricing structure  108400.0  142523.0   \n",
       "3  Vision-oriented fresh-thinking conglomeration    4200.0    2477.0   \n",
       "4                      Proactive foreground core    7600.0    5265.0   \n",
       "\n",
       "      outcome  backers_count country currency launched_date    end_date  \\\n",
       "0      failed              0      CA      CAD    1970-01-01  1970-01-01   \n",
       "1  successful            158      US      USD    1970-01-01  1970-01-01   \n",
       "2  successful           1425      AU      AUD    1970-01-01  1970-01-01   \n",
       "3      failed             24      US      USD    1970-01-01  1970-01-01   \n",
       "4      failed             53      US      USD    1970-01-01  1970-01-01   \n",
       "\n",
       "   staff_pick  spotlight category & sub-category    category  subcategory  \n",
       "0       False      False        food/food trucks        food  food trucks  \n",
       "1       False       True              music/rock       music         rock  \n",
       "2       False      False          technology/web  technology          web  \n",
       "3       False      False              music/rock       music         rock  \n",
       "4       False      False           theater/plays     theater        plays  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Format the launched_date and end_date columns to datetime format\n",
    "from datetime import datetime as dt\n",
    "campaign_df[\"launched_date\"] = pd.to_datetime(campaign_df[\"launched_date\"]).dt.date\n",
    "campaign_df[\"end_date\"] = pd.to_datetime(campaign_df[\"end_date\"]).dt.date\n",
    "campaign_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "scrolled": false
   },
   "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>cf_id</th>\n",
       "      <th>contact_id</th>\n",
       "      <th>company_name</th>\n",
       "      <th>description</th>\n",
       "      <th>goal</th>\n",
       "      <th>pledged</th>\n",
       "      <th>outcome</th>\n",
       "      <th>backers_count</th>\n",
       "      <th>country</th>\n",
       "      <th>currency</th>\n",
       "      <th>launched_date</th>\n",
       "      <th>end_date</th>\n",
       "      <th>staff_pick</th>\n",
       "      <th>spotlight</th>\n",
       "      <th>category &amp; sub-category</th>\n",
       "      <th>category</th>\n",
       "      <th>subcategory</th>\n",
       "      <th>category_id</th>\n",
       "      <th>subcategory_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>990</th>\n",
       "      <td>399</td>\n",
       "      <td>5983</td>\n",
       "      <td>Dixon, Perez and Banks</td>\n",
       "      <td>Re-engineered encompassing definition</td>\n",
       "      <td>8300.0</td>\n",
       "      <td>2111.0</td>\n",
       "      <td>failed</td>\n",
       "      <td>57</td>\n",
       "      <td>CA</td>\n",
       "      <td>CAD</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>photography/photography books</td>\n",
       "      <td>photography</td>\n",
       "      <td>photography books</td>\n",
       "      <td>cat8</td>\n",
       "      <td>subcat15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>991</th>\n",
       "      <td>1378</td>\n",
       "      <td>2873</td>\n",
       "      <td>Clements Ltd</td>\n",
       "      <td>Persistent bandwidth-monitored framework</td>\n",
       "      <td>3700.0</td>\n",
       "      <td>1343.0</td>\n",
       "      <td>failed</td>\n",
       "      <td>52</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>photography/photography books</td>\n",
       "      <td>photography</td>\n",
       "      <td>photography books</td>\n",
       "      <td>cat8</td>\n",
       "      <td>subcat15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>992</th>\n",
       "      <td>806</td>\n",
       "      <td>2961</td>\n",
       "      <td>Walter Inc</td>\n",
       "      <td>Streamlined 5thgeneration intranet</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>8142.0</td>\n",
       "      <td>failed</td>\n",
       "      <td>263</td>\n",
       "      <td>AU</td>\n",
       "      <td>AUD</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>photography/photography books</td>\n",
       "      <td>photography</td>\n",
       "      <td>photography books</td>\n",
       "      <td>cat8</td>\n",
       "      <td>subcat15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993</th>\n",
       "      <td>1563</td>\n",
       "      <td>3043</td>\n",
       "      <td>Sanders, Farley and Huffman</td>\n",
       "      <td>Cross-group clear-thinking task-force</td>\n",
       "      <td>172000.0</td>\n",
       "      <td>55805.0</td>\n",
       "      <td>failed</td>\n",
       "      <td>1691</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>photography/photography books</td>\n",
       "      <td>photography</td>\n",
       "      <td>photography books</td>\n",
       "      <td>cat8</td>\n",
       "      <td>subcat15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>994</th>\n",
       "      <td>1951</td>\n",
       "      <td>6013</td>\n",
       "      <td>Rodriguez-Robinson</td>\n",
       "      <td>Ergonomic methodical hub</td>\n",
       "      <td>5900.0</td>\n",
       "      <td>4997.0</td>\n",
       "      <td>failed</td>\n",
       "      <td>114</td>\n",
       "      <td>IT</td>\n",
       "      <td>EUR</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>photography/photography books</td>\n",
       "      <td>photography</td>\n",
       "      <td>photography books</td>\n",
       "      <td>cat8</td>\n",
       "      <td>subcat15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>461</td>\n",
       "      <td>3521</td>\n",
       "      <td>Erickson-Rogers</td>\n",
       "      <td>De-engineered even-keeled definition</td>\n",
       "      <td>9800.0</td>\n",
       "      <td>7608.0</td>\n",
       "      <td>canceled</td>\n",
       "      <td>75</td>\n",
       "      <td>IT</td>\n",
       "      <td>EUR</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>photography/photography books</td>\n",
       "      <td>photography</td>\n",
       "      <td>photography books</td>\n",
       "      <td>cat8</td>\n",
       "      <td>subcat15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>1095</td>\n",
       "      <td>3565</td>\n",
       "      <td>Young and Sons</td>\n",
       "      <td>Innovative disintermediate encryption</td>\n",
       "      <td>2400.0</td>\n",
       "      <td>4596.0</td>\n",
       "      <td>successful</td>\n",
       "      <td>144</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>journalism/audio</td>\n",
       "      <td>journalism</td>\n",
       "      <td>audio</td>\n",
       "      <td>cat9</td>\n",
       "      <td>subcat24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>1388</td>\n",
       "      <td>4517</td>\n",
       "      <td>Valenzuela-Cook</td>\n",
       "      <td>Total incremental productivity</td>\n",
       "      <td>6700.0</td>\n",
       "      <td>7496.0</td>\n",
       "      <td>successful</td>\n",
       "      <td>300</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>journalism/audio</td>\n",
       "      <td>journalism</td>\n",
       "      <td>audio</td>\n",
       "      <td>cat9</td>\n",
       "      <td>subcat24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>2448</td>\n",
       "      <td>2389</td>\n",
       "      <td>Little Ltd</td>\n",
       "      <td>Decentralized bandwidth-monitored ability</td>\n",
       "      <td>6900.0</td>\n",
       "      <td>12155.0</td>\n",
       "      <td>successful</td>\n",
       "      <td>419</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>journalism/audio</td>\n",
       "      <td>journalism</td>\n",
       "      <td>audio</td>\n",
       "      <td>cat9</td>\n",
       "      <td>subcat24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>602</td>\n",
       "      <td>2153</td>\n",
       "      <td>Giles-Smith</td>\n",
       "      <td>Right-sized web-enabled intranet</td>\n",
       "      <td>9700.0</td>\n",
       "      <td>11929.0</td>\n",
       "      <td>successful</td>\n",
       "      <td>331</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>journalism/audio</td>\n",
       "      <td>journalism</td>\n",
       "      <td>audio</td>\n",
       "      <td>cat9</td>\n",
       "      <td>subcat24</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     cf_id  contact_id                 company_name  \\\n",
       "990    399        5983       Dixon, Perez and Banks   \n",
       "991   1378        2873                 Clements Ltd   \n",
       "992    806        2961                   Walter Inc   \n",
       "993   1563        3043  Sanders, Farley and Huffman   \n",
       "994   1951        6013           Rodriguez-Robinson   \n",
       "995    461        3521              Erickson-Rogers   \n",
       "996   1095        3565               Young and Sons   \n",
       "997   1388        4517              Valenzuela-Cook   \n",
       "998   2448        2389                   Little Ltd   \n",
       "999    602        2153                  Giles-Smith   \n",
       "\n",
       "                                   description      goal  pledged     outcome  \\\n",
       "990      Re-engineered encompassing definition    8300.0   2111.0      failed   \n",
       "991   Persistent bandwidth-monitored framework    3700.0   1343.0      failed   \n",
       "992         Streamlined 5thgeneration intranet   10000.0   8142.0      failed   \n",
       "993      Cross-group clear-thinking task-force  172000.0  55805.0      failed   \n",
       "994                   Ergonomic methodical hub    5900.0   4997.0      failed   \n",
       "995       De-engineered even-keeled definition    9800.0   7608.0    canceled   \n",
       "996      Innovative disintermediate encryption    2400.0   4596.0  successful   \n",
       "997             Total incremental productivity    6700.0   7496.0  successful   \n",
       "998  Decentralized bandwidth-monitored ability    6900.0  12155.0  successful   \n",
       "999           Right-sized web-enabled intranet    9700.0  11929.0  successful   \n",
       "\n",
       "     backers_count country currency launched_date    end_date  staff_pick  \\\n",
       "990             57      CA      CAD    1970-01-01  1970-01-01       False   \n",
       "991             52      US      USD    1970-01-01  1970-01-01       False   \n",
       "992            263      AU      AUD    1970-01-01  1970-01-01       False   \n",
       "993           1691      US      USD    1970-01-01  1970-01-01        True   \n",
       "994            114      IT      EUR    1970-01-01  1970-01-01       False   \n",
       "995             75      IT      EUR    1970-01-01  1970-01-01       False   \n",
       "996            144      US      USD    1970-01-01  1970-01-01       False   \n",
       "997            300      US      USD    1970-01-01  1970-01-01       False   \n",
       "998            419      US      USD    1970-01-01  1970-01-01       False   \n",
       "999            331      US      USD    1970-01-01  1970-01-01       False   \n",
       "\n",
       "     spotlight        category & sub-category     category        subcategory  \\\n",
       "990      False  photography/photography books  photography  photography books   \n",
       "991      False  photography/photography books  photography  photography books   \n",
       "992      False  photography/photography books  photography  photography books   \n",
       "993      False  photography/photography books  photography  photography books   \n",
       "994       True  photography/photography books  photography  photography books   \n",
       "995       True  photography/photography books  photography  photography books   \n",
       "996      False               journalism/audio   journalism              audio   \n",
       "997      False               journalism/audio   journalism              audio   \n",
       "998      False               journalism/audio   journalism              audio   \n",
       "999      False               journalism/audio   journalism              audio   \n",
       "\n",
       "    category_id subcategory_id  \n",
       "990        cat8       subcat15  \n",
       "991        cat8       subcat15  \n",
       "992        cat8       subcat15  \n",
       "993        cat8       subcat15  \n",
       "994        cat8       subcat15  \n",
       "995        cat8       subcat15  \n",
       "996        cat9       subcat24  \n",
       "997        cat9       subcat24  \n",
       "998        cat9       subcat24  \n",
       "999        cat9       subcat24  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Merge the campaign_df with the category_df on the \"category\" column and \n",
    "# the subcategory_df on the \"subcategory\" column.\n",
    "campaign_merged_df = pd.merge(campaign_df,category_df, how = \"inner\",on = \"category\")\n",
    "campaign_merged_df = pd.merge(campaign_merged_df,subcategory_df, how = \"inner\",on = \"subcategory\")\n",
    "campaign_merged_df.tail(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>cf_id</th>\n",
       "      <th>contact_id</th>\n",
       "      <th>company_name</th>\n",
       "      <th>description</th>\n",
       "      <th>goal</th>\n",
       "      <th>pledged</th>\n",
       "      <th>outcome</th>\n",
       "      <th>backers_count</th>\n",
       "      <th>country</th>\n",
       "      <th>currency</th>\n",
       "      <th>launched_date</th>\n",
       "      <th>end_date</th>\n",
       "      <th>category_id</th>\n",
       "      <th>subcategory_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>147</td>\n",
       "      <td>4661</td>\n",
       "      <td>Baldwin, Riley and Jackson</td>\n",
       "      <td>Pre-emptive tertiary standardization</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>failed</td>\n",
       "      <td>0</td>\n",
       "      <td>CA</td>\n",
       "      <td>CAD</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>cat1</td>\n",
       "      <td>subcat1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1175</td>\n",
       "      <td>2288</td>\n",
       "      <td>Werner-Bryant</td>\n",
       "      <td>Virtual uniform frame</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>7991.0</td>\n",
       "      <td>successful</td>\n",
       "      <td>222</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>cat1</td>\n",
       "      <td>subcat1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>873</td>\n",
       "      <td>2067</td>\n",
       "      <td>Stewart LLC</td>\n",
       "      <td>Cloned bi-directional architecture</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>12047.0</td>\n",
       "      <td>successful</td>\n",
       "      <td>113</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>cat1</td>\n",
       "      <td>subcat1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2568</td>\n",
       "      <td>5989</td>\n",
       "      <td>Castillo-Carey</td>\n",
       "      <td>Cross-platform solution-oriented process improvement</td>\n",
       "      <td>142400.0</td>\n",
       "      <td>21307.0</td>\n",
       "      <td>failed</td>\n",
       "      <td>296</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>cat1</td>\n",
       "      <td>subcat1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1211</td>\n",
       "      <td>3307</td>\n",
       "      <td>Wright, Hartman and Yu</td>\n",
       "      <td>User-friendly tertiary array</td>\n",
       "      <td>3300.0</td>\n",
       "      <td>12437.0</td>\n",
       "      <td>successful</td>\n",
       "      <td>131</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>1970-01-01</td>\n",
       "      <td>cat1</td>\n",
       "      <td>subcat1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   cf_id  contact_id                company_name  \\\n",
       "0    147        4661  Baldwin, Riley and Jackson   \n",
       "1   1175        2288               Werner-Bryant   \n",
       "2    873        2067                 Stewart LLC   \n",
       "3   2568        5989              Castillo-Carey   \n",
       "4   1211        3307      Wright, Hartman and Yu   \n",
       "\n",
       "                                            description      goal  pledged  \\\n",
       "0                  Pre-emptive tertiary standardization     100.0      0.0   \n",
       "1                                 Virtual uniform frame    1800.0   7991.0   \n",
       "2                    Cloned bi-directional architecture    1300.0  12047.0   \n",
       "3  Cross-platform solution-oriented process improvement  142400.0  21307.0   \n",
       "4                          User-friendly tertiary array    3300.0  12437.0   \n",
       "\n",
       "      outcome  backers_count country currency launched_date    end_date  \\\n",
       "0      failed              0      CA      CAD    1970-01-01  1970-01-01   \n",
       "1  successful            222      US      USD    1970-01-01  1970-01-01   \n",
       "2  successful            113      US      USD    1970-01-01  1970-01-01   \n",
       "3      failed            296      US      USD    1970-01-01  1970-01-01   \n",
       "4  successful            131      US      USD    1970-01-01  1970-01-01   \n",
       "\n",
       "  category_id subcategory_id  \n",
       "0        cat1        subcat1  \n",
       "1        cat1        subcat1  \n",
       "2        cat1        subcat1  \n",
       "3        cat1        subcat1  \n",
       "4        cat1        subcat1  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Drop unwanted columns\n",
    "campaign_cleaned = campaign_merged_df.drop(\n",
    "    [\"staff_pick\",\"spotlight\",\"category & sub-category\", \"category\", \"subcategory\"],axis = 1)\n",
    "campaign_cleaned.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Export the DataFrame as a CSV file. \n",
    "campaign_cleaned.to_csv(\"Resources/campaign.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Extract the contacts.xlsx Data."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>contact_info</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>{\"contact_id\": 4661, \"name\": \"Cecilia Velasco\", \"email\": \"cecilia.velasco@rodrigues.fr\"}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>{\"contact_id\": 3765, \"name\": \"Mariana Ellis\", \"email\": \"mariana.ellis@rossi.org\"}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>{\"contact_id\": 4187, \"name\": \"Sofie Woods\", \"email\": \"sofie.woods@riviere.com\"}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>{\"contact_id\": 4941, \"name\": \"Jeanette Iannotti\", \"email\": \"jeanette.iannotti@yahoo.com\"}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>{\"contact_id\": 2199, \"name\": \"Samuel Sorgatz\", \"email\": \"samuel.sorgatz@gmail.com\"}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                contact_info\n",
       "0   {\"contact_id\": 4661, \"name\": \"Cecilia Velasco\", \"email\": \"cecilia.velasco@rodrigues.fr\"}\n",
       "1          {\"contact_id\": 3765, \"name\": \"Mariana Ellis\", \"email\": \"mariana.ellis@rossi.org\"}\n",
       "2            {\"contact_id\": 4187, \"name\": \"Sofie Woods\", \"email\": \"sofie.woods@riviere.com\"}\n",
       "3  {\"contact_id\": 4941, \"name\": \"Jeanette Iannotti\", \"email\": \"jeanette.iannotti@yahoo.com\"}\n",
       "4        {\"contact_id\": 2199, \"name\": \"Samuel Sorgatz\", \"email\": \"samuel.sorgatz@gmail.com\"}"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Read the data into a Pandas DataFrame. Use the `header=2` parameter when reading in the data.\n",
    "contact_info_df = pd.read_excel('Resources/contacts.xlsx', header=3)\n",
    "contact_info_df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Create the Contacts DataFrame \n",
    "---\n",
    "**Create a Contacts DataFrame that has the following columns:**\n",
    "- A column named \"contact_id\"  that contains the unique number of the contact person.\n",
    "- A column named \"first_name\" that contains the first name of the contact person.\n",
    "- A column named \"last_name\" that contains the first name of the contact person.\n",
    "- A column named \"email\" that contains the email address of the contact person\n",
    "\n",
    "Then export the DataFrame as a `contacts.csv` CSV file."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Option 1: Use Pandas to create the contacts DataFrame."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[[4661, 'Cecilia Velasco', 'cecilia.velasco@rodrigues.fr'], [3765, 'Mariana Ellis', 'mariana.ellis@rossi.org'], [4187, 'Sofie Woods', 'sofie.woods@riviere.com'], [4941, 'Jeanette Iannotti', 'jeanette.iannotti@yahoo.com'], [2199, 'Samuel Sorgatz', 'samuel.sorgatz@gmail.com'], [5650, 'Socorro Luna', 'socorro.luna@hotmail.com'], [5889, 'Carolina Murray', 'carolina.murray@knight.com'], [4842, 'Kayla Moon', 'kayla.moon@yahoo.de'], [3280, 'Ariadna Geisel', 'ariadna.geisel@rangel.com'], [5468, 'Danielle Ladeck', 'danielle.ladeck@scalfaro.net'], [3064, 'Tatiana Thompson', 'tatiana.thompson@hunt.net'], [4904, 'Caleb Benavides', 'caleb.benavides@rubio.com'], [1299, 'Sandra Hardy', 'sandra.hardy@web.de'], [5602, 'Lotti Morris', 'lotti.morris@yahoo.co.uk'], [5753, 'Reinhilde White', 'reinhilde.white@voila.fr'], [4495, 'Kerry Patel', 'kerry.patel@hutchinson.com'], [4269, 'Sophie Antoine', 'sophie.antoine@andersen.com'], [2226, 'Martha Girard', 'martha.girard@web.de'], [1558, 'Stephanie King', 'stephanie.king@cervantes.com'], [2307, 'Amanda Palmer', 'amanda.palmer@didier.fr'], [2900, 'Lina Alcala', 'lina.alcala@vespa.net'], [5695, 'Itzel Murphy', 'itzel.murphy@muelichen.de'], [5708, 'Filippo Parry', 'filippo.parry@live.com'], [1663, 'Katelyn Cole', 'katelyn.cole@fiebig.com'], [3605, 'Brian Novak', 'brian.novak@ford.net'], [4678, 'Cilly Gay', 'cilly.gay@callegaro.it'], [2251, 'Yolanda Snyder', 'yolanda.snyder@gmx.de'], [6202, 'Evelin Odonnell', 'evelin.odonnell@ibarra.net'], [3715, 'Ingeborg Alba', 'ingeborg.alba@hotmail.com'], [4242, 'Marina Madrid', 'marina.madrid@galarza-alba.com'], [4326, 'Sheila Goodwin', 'sheila.goodwin@yahoo.com'], [5560, 'Valeria Rich', 'valeria.rich@turchetta-mondadori.it'], [4002, 'Dustin Camacho', 'dustin.camacho@rhodes.org.au'], [3813, 'Amalia Marenzio', 'amalia.marenzio@grupo.com'], [5336, 'Gian Long', 'gian.long@hotmail.com'], [4994, 'Stewart Hunt', 'stewart.hunt@anderson-vargas.biz'], [1471, 'Greca Ruiz', 'greca.ruiz@carr.co.uk'], [4482, 'Gerald Olivera', 'gerald.olivera@outlook.com'], [3241, 'Jaqueline Wallace', 'jaqueline.wallace@gmail.com'], [3477, 'John Lane', 'john.lane@gregoire.fr'], [2265, 'Pero Joly', 'pero.joly@bernard.net'], [5911, 'Chad Turner', 'chad.turner@gmail.com'], [2288, 'Adam Zavala', 'adam.zavala@guichard.fr'], [4064, 'Tyler Rivera', 'tyler.rivera@guajardo-ozuna.com'], [1294, 'Jens Graham', 'jens.graham@jones-buckley.com'], [5008, 'Virginia Caetani', 'virginia.caetani@sosa.biz'], [3604, 'Martino Wagner', 'martino.wagner@laposte.net'], [3263, 'Martin Meyer', 'martin.meyer@davis.co.uk'], [5631, 'Marguerite Walls', 'marguerite.walls@martinez.fr'], [2851, 'Peter Vogt', 'peter.vogt@yahoo.com'], [3714, 'Nicholas Christian', 'nicholas.christian@hotmail.de'], [1664, 'Susi Steinberg', 'susi.steinberg@preiss.com'], [5027, 'Tammy Ramazzotti', 'tammy.ramazzotti@gmail.com'], [3070, 'Abdul Thomas', 'abdul.thomas@vasari.com'], [4248, 'Justin Luxardo', 'justin.luxardo@googlemail.com'], [2034, 'Antonio Gibson', 'antonio.gibson@faust.net'], [4085, 'Jeremy Gomez', 'jeremy.gomez@oconnor.org'], [3569, 'Raymond Solorzano', 'raymond.solorzano@gmail.com'], [3889, 'Flora Harris', 'flora.harris@hotmail.com.au'], [3136, 'Cheryl Boyd', 'cheryl.boyd@segni.it'], [2103, 'Rhys Leiva', 'rhys.leiva@gmx.de'], [2329, 'Mariano Prieto', 'mariano.prieto@vodafone.it'], [3325, 'Laurie Fibonacci', 'laurie.fibonacci@gmail.com'], [3131, 'David Rudolph', 'david.rudolph@nelson.com'], [4995, 'Bryan Ross', 'bryan.ross@yahoo.com'], [3631, 'Ubaldo Brown', 'ubaldo.brown@philippe.com'], [5373, 'Clelia Faulkner', 'clelia.faulkner@hotmail.com'], [3126, 'Sara Erickson', 'sara.erickson@yahoo.de'], [2194, 'Rupert Valle', 'rupert.valle@filogamo.it'], [2906, 'Puccio Kitzmann', 'puccio.kitzmann@yahoo.com'], [2611, 'Thomas Hutchinson', 'thomas.hutchinson@gmx.de'], [2374, 'Abelardo Castro', 'abelardo.castro@gmail.com'], [3254, 'Greco Walker', 'greco.walker@yahoo.com'], [3571, 'Miranda Lacombe', 'miranda.lacombe@longoria-vanegas.net'], [2812, 'Diana Schuchhardt', 'diana.schuchhardt@libero.it'], [3961, 'Stacey Knox', 'stacey.knox@corporacin.com'], [3872, 'Glen Faivre', 'glen.faivre@yahoo.com'], [4736, 'Andrew Torres', 'andrew.torres@ruiz-torres.org'], [5119, 'Denny Fritz', 'denny.fritz@despacho.biz'], [5725, 'Martyn Caldera', 'martyn.caldera@hotmail.co.uk'], [4037, 'Abigail Foster', 'abigail.foster@taylor.net'], [2109, 'Anthony Hauffer', 'anthony.hauffer@tlustek.org'], [3283, 'Roger Gerlach', 'roger.gerlach@may-mitchell.co.uk'], [6181, 'Christopher Poirier', 'christopher.poirier@hotmail.com'], [3251, 'Branka Traore', 'branka.traore@jacobi.com'], [3443, 'Briana Etienne', 'briana.etienne@bishop-coates.com'], [2988, 'Brandon Olson', 'brandon.olson@prince-moreno.net'], [1673, 'Celia Ungaretti', 'celia.ungaretti@fox.com'], [2085, 'Barbara Guibert', 'barbara.guibert@casares-sanches.com'], [1672, 'Daniela Bell', 'daniela.bell@vollbrecht.org'], [4426, 'Phyllis Gurule', 'phyllis.gurule@rodriguez-pham.com'], [3211, 'Alejandra Joseph', 'alejandra.joseph@escalante-abrego.biz'], [3190, 'Giulio Bohlander', 'giulio.bohlander@dbmail.com'], [2081, 'Amber Weller', 'amber.weller@toso.eu'], [3185, 'Mary Etzold', 'mary.etzold@conrad-harrison.com'], [5044, 'Amy Georges', 'amy.georges@raedel.de'], [1883, 'Jennifer Giraud', 'jennifer.giraud@yahoo.com'], [2067, 'Rosie Peltier', 'rosie.peltier@voila.fr'], [4604, 'Oreste Ward', 'oreste.ward@proyectos.com'], [3203, 'Luis Edwards', 'luis.edwards@live.com'], [5758, 'Fiona Griffiths', 'fiona.griffiths@curatoli-verdone.it'], [5755, 'Sally Raya', 'sally.raya@tarchetti.it'], [5150, 'Carolyn Charpentier', 'carolyn.charpentier@hotmail.de'], [4181, 'Nathalie Alvarez', 'nathalie.alvarez@live.com'], [3006, 'Abril Lowery', 'abril.lowery@novak.net'], [4865, 'Ottone Sullivan', 'ottone.sullivan@hussain-kaur.com'], [2862, 'Esmeralda Sollima', 'esmeralda.sollima@visintini.it'], [6070, 'Silvia Gierschner', 'silvia.gierschner@tele2.it'], [5300, 'Kyle Cunningham', 'kyle.cunningham@voila.fr'], [3486, 'Anel Carpentier', 'anel.carpentier@klein-joseph.org'], [5989, 'Sarah Davis', 'sarah.davis@david.com'], [2849, 'Luke Klein', 'luke.klein@hotmail.com'], [1612, 'Gudrun Mueller', 'gudrun.mueller@dillon-fuller.info'], [3307, 'Melissa Canali', 'melissa.canali@libero.it'], [5288, 'Gabrielle Ayala', 'gabrielle.ayala@hotmail.com'], [6026, 'Laura Buckley', 'laura.buckley@ryan.org'], [2212, 'Wilfrido Lorch', 'wilfrido.lorch@leclerc.fr'], [4591, 'Robert Bruder', 'robert.bruder@manzoni.com'], [2771, 'Phillip Soliz', 'phillip.soliz@outlook.com'], [5682, 'Alex Smith', 'alex.smith@fournier.fr'], [5368, 'Jessica Martinez', 'jessica.martinez@salieri.com'], [3706, 'Kelly Carter', 'kelly.carter@hotmail.com.au'], [4034, 'Ahmad Sosa', 'ahmad.sosa@gmail.com'], [3209, 'Toralf Iglesias', 'toralf.iglesias@borrego.com'], [2384, 'Irene Anichini', 'irene.anichini@yahoo.com'], [3074, 'Alicia Cainero', 'alicia.cainero@yahoo.com'], [2031, 'Tracey Laboy', 'tracey.laboy@bell.biz'], [5873, 'Donald Reynaud', 'donald.reynaud@green.edu.au'], [5501, 'Venancio Stadelmann', 'venancio.stadelmann@gmx.de'], [3489, 'Seth Olivier', 'seth.olivier@yahoo.com'], [4210, 'Dennis Boaga', 'dennis.boaga@gmx.de'], [6151, 'Pedro Wilson', 'pedro.wilson@outlook.com'], [6047, 'Roland Weihmann', 'roland.weihmann@gmail.com'], [5445, 'Hector Morrison', 'hector.morrison@web.de'], [5493, 'Evangelos Peters', 'evangelos.peters@sanchez.net'], [6036, 'Gerardo Hamilton', 'gerardo.hamilton@libero.it'], [2368, 'Meta Cuzzocrea', 'meta.cuzzocrea@howard-jensen.org'], [1501, 'Alma Raymond', 'alma.raymond@tin.it'], [4351, 'Kathleen Solimena', 'kathleen.solimena@wallace.biz'], [3096, 'Zacharie Cordier', 'zacharie.cordier@gmail.com'], [6162, 'Riza Techer', 'riza.techer@yahoo.com'], [1433, 'Enrique Guillen', 'enrique.guillen@hotmail.co.uk'], [2720, 'Tristan Weeks', 'tristan.weeks@pena.com'], [5251, 'Natalie Lerma', 'natalie.lerma@boucher.com'], [1797, 'Rodney Hamon', 'rodney.hamon@hotmail.com'], [1656, 'Adalberto Lombardo', 'adalberto.lombardo@sfr.fr'], [1346, 'Florencia Querini', 'florencia.querini@gmail.com'], [2989, 'Liam Rolland', 'liam.rolland@yahoo.fr'], [5629, 'Ian Kelly', 'ian.kelly@reeves.com.au'], [3456, 'Mehdi Todd', 'mehdi.todd@web.de'], [3229, 'Rembrandt Liguori', 'rembrandt.liguori@davis.org'], [2277, 'Irmi Schweitzer', 'irmi.schweitzer@ozuna.com'], [1276, 'Gioffre Stein', 'gioffre.stein@hotmail.com.au'], [3694, 'Frida Villarreal', 'frida.villarreal@hotmail.de'], [2260, 'Steffen Mangold', 'steffen.mangold@paul.net'], [5374, 'Elias Marin', 'elias.marin@herve.net'], [4420, 'Roman Gonzalez', 'roman.gonzalez@anderson.net'], [3849, 'Reina Middleton', 'reina.middleton@hotmail.com'], [1638, 'Sandro Moran', 'sandro.moran@hotmail.de'], [5230, 'Gebhard Thanel', 'gebhard.thanel@gmail.com'], [1763, 'Antonino Bolander', 'antonino.bolander@gmail.com'], [4323, 'Karl Trevisani', 'karl.trevisani@anguissola.it'], [5256, 'Silvester Brookes', 'silvester.brookes@franco.org'], [4836, 'Octavio Pratt', 'octavio.pratt@web.de'], [5981, 'Rebecca Greer', 'rebecca.greer@hotmail.com'], [1463, 'Pierina Gaggini', 'pierina.gaggini@free.fr'], [4577, 'Robin Schleich', 'robin.schleich@rogers-barrera.biz'], [4951, 'Sergio Abbott', 'sergio.abbott@moore.net.au'], [3567, 'Gilberto Evans', 'gilberto.evans@salcedo-archuleta.net'], [5475, 'James Elliott', 'james.elliott@gmail.com'], [2114, 'Timoteo Bolnbach', 'timoteo.bolnbach@laboratorios.com'], [5216, 'Tonino Stanley', 'tonino.stanley@hotmail.com'], [1665, 'Margaretha Murialdo', 'margaretha.murialdo@meunier.com'], [6051, 'Bianca Drubin', 'bianca.drubin@libero.it'], [3983, 'Kaylee Hoffmann', 'kaylee.hoffmann@poulain.com'], [2966, 'Teresa Vecellio', 'teresa.vecellio@yahoo.com'], [4478, 'Emine Tacchini', 'emine.tacchini@dbmail.com'], [4238, 'Dawn Cortez', 'dawn.cortez@gmail.com'], [4404, 'Emily Cundari', 'emily.cundari@clark.com.au'], [5666, 'Eleanor Hall', 'eleanor.hall@hotmail.com'], [3691, 'Monique Delgadillo', 'monique.delgadillo@hotmail.co.uk'], [2703, 'Arnaude Warner', 'arnaude.warner@gmail.com'], [4253, 'Jason Howell', 'jason.howell@gmx.de'], [5652, 'Nicole Mccullough', 'nicole.mccullough@hall.com'], [3279, 'Rosmarie Esquibel', 'rosmarie.esquibel@bouygtel.fr'], [3233, 'Leonor Ferreira', 'leonor.ferreira@gmail.com'], [3017, 'Brett Jones', 'brett.jones@alice.it'], [3482, 'Nino Bien', 'nino.bien@gmail.com'], [2166, 'Jemma Tate', 'jemma.tate@hotmail.de'], [4146, 'Denis Rogers', 'denis.rogers@poste.it'], [2651, 'Vanesa Khan', 'vanesa.khan@voila.fr'], [1409, 'Victoria Ojeda', 'victoria.ojeda@doehn.com'], [3717, 'Eugenio Martin', 'eugenio.martin@yahoo.de'], [3963, 'Nancy Hayes', 'nancy.hayes@hotmail.com'], [2152, 'Lara Jacob', 'lara.jacob@buckley.org'], [2974, 'Gino Hernandez', 'gino.hernandez@covarrubias.com'], [1268, 'Vicente Tijerina', 'vicente.tijerina@montanariello.com'], [1822, 'Michele Brambilla', 'michele.brambilla@yahoo.com'], [5066, 'Dana Ritacca', 'dana.ritacca@gmail.com'], [5075, 'Mitchell Bachmann', 'mitchell.bachmann@suarez-cruz.com'], [3855, 'Vincenza Key', 'vincenza.key@adams.com'], [5923, 'Salvador Gaillard', 'salvador.gaillard@yahoo.de'], [1867, 'Diane Rogner', 'diane.rogner@kelly.co.uk'], [4376, 'Josette Laine', 'josette.laine@saracino-parisi.net'], [2785, 'Courtney Fiebig', 'courtney.fiebig@doerschner.com'], [5884, 'Hugues Oliver', 'hugues.oliver@stiffel.com'], [2441, 'Espartaco Willis', 'espartaco.willis@hotmail.com'], [1243, 'Flavia Yoder', 'flavia.yoder@hotmail.de'], [3411, 'Casey Flores', 'casey.flores@baggio.org'], [2467, 'Calogero Cross', 'calogero.cross@mercantini.it'], [1850, 'Charles Begum', 'charles.begum@laboratorios.info'], [2604, 'Adina Pollard', 'adina.pollard@outlook.com'], [1693, 'Natasha Lara', 'natasha.lara@outlook.com'], [2969, 'Benita Pottier', 'benita.pottier@sfr.fr'], [1544, 'Elizabeth Valdivia', 'elizabeth.valdivia@gmail.com'], [4149, 'Mattia Huet', 'mattia.huet@aol.de'], [3463, 'Geza Howard', 'geza.howard@voila.fr'], [2939, 'Lauren Guillaume', 'lauren.guillaume@sorgatz.org'], [2202, 'Joanna Baxter', 'joanna.baxter@bruce-wright.com'], [1728, 'Tracy Metz', 'tracy.metz@bryant.info'], [5362, 'Birgit Pena', 'birgit.pena@armellini.it'], [4840, 'Elvira Papafava', 'elvira.papafava@ifrance.com'], [2955, 'Ernest Delorme', 'ernest.delorme@dowerg.de'], [5354, 'Christy Grossi', 'christy.grossi@alarcon-tafoya.com'], [3847, 'Hermelinda Olmos', 'hermelinda.olmos@portillo.com'], [3025, 'Herbert Fraser', 'herbert.fraser@holloway.org.au'], [1615, 'Giancarlo Heydrich', 'giancarlo.heydrich@hotmail.com'], [5154, 'Constance Maldonado', 'constance.maldonado@spiess.net'], [5005, 'Giampiero Carlier', 'giampiero.carlier@hotmail.com'], [1349, 'Carlo Jacquot', 'carlo.jacquot@hotmail.com'], [3670, 'Gabriel Robles', 'gabriel.robles@yahoo.com'], [2912, 'Gerd Gunpf', 'gerd.gunpf@gmail.com'], [4336, 'Ashley Hellwig', 'ashley.hellwig@libero.it'], [5576, 'Patrick Rosas', 'patrick.rosas@yahoo.com'], [2736, 'Lilla Leonard', 'lilla.leonard@jungfer.com'], [3321, 'Tony Nicolas', 'tony.nicolas@morrocco-seddio.net'], [3353, 'Allegra Benedetti', 'allegra.benedetti@miller.com'], [2336, 'Camille Tafuri', 'camille.tafuri@aol.de'], [4369, 'Juan Wheeler', 'juan.wheeler@gilmore.net'], [4464, 'Leopoldo Johnson', 'leopoldo.johnson@hotmail.com.au'], [5626, 'Dietmar Grenier', 'dietmar.grenier@tele2.it'], [1669, 'Leonid Scholl', 'leonid.scholl@collin.com'], [5544, 'Olivie Contarini', 'olivie.contarini@marshall-wright.biz'], [6078, 'Jeffery Lacroix', 'jeffery.lacroix@medina.org'], [2580, 'Edeltraud Chavez', 'edeltraud.chavez@hotmail.com.au'], [3592, 'Mesut Morvan', 'mesut.morvan@gmail.com'], [4914, 'Gregory Jackson', 'gregory.jackson@ortiz.com'], [3848, 'Nicola Rossi', 'nicola.rossi@berry.org'], [2619, 'Eddie Collazo', 'eddie.collazo@gmail.com'], [4605, 'Philippe Gardner', 'philippe.gardner@howells-jones.net'], [6147, 'Roy Fox', 'roy.fox@tejeda.com'], [1383, 'Heiderose Garcia', 'heiderose.garcia@noos.fr'], [1757, 'Claudine Rowley', 'claudine.rowley@industrias.com'], [4390, 'Astrid Roht', 'astrid.roht@fastwebnet.it'], [4165, 'Auguste Burnett', 'auguste.burnett@yahoo.fr'], [4529, 'Pellegrino Allen', 'pellegrino.allen@gmail.com'], [6084, 'Angela Bowers', 'angela.bowers@laboratorios.com'], [2916, 'Michael Descamps', 'michael.descamps@gmail.com'], [2005, 'Heidelore Kennedy', 'heidelore.kennedy@guinizzelli.org'], [2261, 'Lucrezia Koch', 'lucrezia.koch@petit.com'], [5342, 'Ivan Accardo', 'ivan.accardo@web.de'], [4087, 'Karen Avogadro', 'karen.avogadro@yahoo.com'], [2761, 'Laetitia Gallet', 'laetitia.gallet@aubry.org'], [2908, 'Amico Gosselin', 'amico.gosselin@shaw.info'], [2155, 'Ilaria Bowen', 'ilaria.bowen@hotmail.it'], [5642, 'Marlen Coardi', 'marlen.coardi@colletti.eu'], [6217, 'Rafael Alexander', 'rafael.alexander@jenkins.com'], [4222, 'Herma Gabbana', 'herma.gabbana@hotmail.com'], [4798, 'Zachary Vespucci', 'zachary.vespucci@industrias.com'], [5660, 'Marisol Richard', 'marisol.richard@gmail.com'], [5000, 'Joseph Glover', 'joseph.glover@laposte.net'], [2809, 'Lauretta Neal', 'lauretta.neal@hotmail.de'], [3349, 'Simone Sauvage', 'simone.sauvage@yahoo.com'], [3647, 'Ramona Brooks', 'ramona.brooks@kensy.de'], [5745, 'Gioele Schwital', 'gioele.schwital@moody.com'], [2583, 'Elena Jimenez', 'elena.jimenez@yahoo.com.au'], [5441, 'Pam Vargas', 'pam.vargas@guillot.net'], [2090, 'Alison Morales', 'alison.morales@lewis.com'], [3386, 'Marc Aumann', 'marc.aumann@holland.com'], [1816, 'Carla Butler', 'carla.butler@yahoo.com'], [4718, 'Dionigi Bruce', 'dionigi.bruce@industrias.com'], [1677, 'Frank Henry', 'frank.henry@yahoo.com'], [4218, 'Brent Pons', 'brent.pons@proyectos.net'], [4548, 'Patricia Liebelt', 'patricia.liebelt@baca.org'], [1431, 'Micheletto Sykes', 'micheletto.sykes@thompson-thompson.com'], [2830, 'Rose Blanc', 'rose.blanc@grupo.com'], [4400, 'Vincent Singh', 'vincent.singh@gmail.com'], [5773, 'Jamie Peacock', 'jamie.peacock@interiano-nordio.com'], [4161, 'Giorgia Dijoux', 'giorgia.dijoux@paul.com'], [2062, 'Serena Piacentini', 'serena.piacentini@yahoo.de'], [3458, 'Dimitri Posada', 'dimitri.posada@gmail.com'], [3174, 'Alexa Barillaro', 'alexa.barillaro@ramos.net'], [5565, 'Megan Kuhl', 'megan.kuhl@despacho.com'], [1906, 'Kaitlyn Farinelli', 'kaitlyn.farinelli@outlook.com'], [5479, 'Jonathan Castellitto', 'jonathan.castellitto@libero.it'], [4320, 'Lisa Terragni', 'lisa.terragni@proyectos.com'], [4213, 'Olivier Petrucelli', 'olivier.petrucelli@letta-raurica.eu'], [3373, 'Jos Trobbiani', 'jos.trobbiani@samson.com'], [4184, 'Mirjam Dawson', 'mirjam.dawson@yahoo.com'], [5472, 'Javier Tessier', 'javier.tessier@mclaughlin.biz'], [5559, 'Mirjana Collins', 'mirjana.collins@hotmail.com'], [5419, 'Vanessa Tschentscher', 'vanessa.tschentscher@mitchell.com'], [4171, 'Antonina Cobb', 'antonina.cobb@gibson.org'], [1302, 'Bernard Durand', 'bernard.durand@royer.com'], [3520, 'Corey Greggio', 'corey.greggio@johnson.org.au'], [6010, 'Rodolfo Couturier', 'rodolfo.couturier@tim.it'], [4617, 'Pierre Cardenas', 'pierre.cardenas@luzi-bonomo.eu'], [1417, 'Romeo Surian', 'romeo.surian@batista.com'], [4770, 'Ivo Moreno', 'ivo.moreno@hotmail.com'], [4328, 'Federico Marie', 'federico.marie@jourdan.fr'], [5171, 'Maggie Boito', 'maggie.boito@yahoo.com'], [4394, 'Brianna Hanson', 'brianna.hanson@stanley.com'], [1794, 'Heiko Bourgeois', 'heiko.bourgeois@togliatti.com'], [3510, 'Benito Gritti', 'benito.gritti@gmail.com'], [2487, 'Mitzy Junk', 'mitzy.junk@zaragoza.com'], [2215, 'Samantha Lowe', 'samantha.lowe@praga.it'], [4136, 'Ernesto Nerger', 'ernesto.nerger@middleton.co.uk'], [3723, 'Melinda Canova', 'melinda.canova@orange.fr'], [5842, 'Mohammad Hartung', 'mohammad.hartung@hotmail.com'], [3289, 'Ben Maillot', 'ben.maillot@ramos.net'], [1249, 'Isabel Pruschke', 'isabel.pruschke@gmail.com'], [5409, 'Linda Franceschi', 'linda.franceschi@richards.net'], [2951, 'Olivia Striebitz', 'olivia.striebitz@gmail.com'], [3432, 'Penny Watson', 'penny.watson@matthews.net'], [2297, 'Manfred James', 'manfred.james@davies.org'], [6161, 'Hazel Pierce', 'hazel.pierce@outlook.com'], [4603, 'Alf Bates', 'alf.bates@dunn.com'], [5818, 'Scott Gough', 'scott.gough@industrias.com'], [4270, 'Konrad Briones', 'konrad.briones@fierro.com'], [6007, 'Mathilde Kruschwitz', 'mathilde.kruschwitz@yahoo.com'], [4084, 'Irma Gemito', 'irma.gemito@googlemail.com'], [1340, 'Antoine Guyon', 'antoine.guyon@yahoo.com'], [5675, 'William Gibilisco', 'william.gibilisco@gaillard.com'], [2010, 'Judith Butte', 'judith.butte@fischer-vaughn.info'], [6201, 'Joanne Henderson', 'joanne.henderson@gmail.com'], [1791, 'Ludovica Arellano', 'ludovica.arellano@morandi-argento.com'], [3314, 'Catherine Gray', 'catherine.gray@hotmail.com'], [5852, 'Franco Fioravanti', 'franco.fioravanti@barry-gill.com.au'], [4618, 'Heather Zimmer', 'heather.zimmer@bluemel.de'], [2618, 'Hortense Taylor', 'hortense.taylor@chambers.biz'], [4967, 'Livia Ernst', 'livia.ernst@colas.fr'], [4594, 'Toby Etzler', 'toby.etzler@industrias.com'], [2080, 'Ennio Leoncavallo', 'ennio.leoncavallo@sanchez.org'], [2793, 'Philippine Vaca', 'philippine.vaca@hotmail.com'], [4890, 'Rhonda Phillips', 'rhonda.phillips@yahoo.com'], [3528, 'Alphonse Nitto', 'alphonse.nitto@voila.fr'], [5810, 'Karina Arreola', 'karina.arreola@yahoo.com.au'], [5720, 'Denise Wood', 'denise.wood@mantegna.com'], [4593, 'Burghard Rosenow', 'burghard.rosenow@hotmail.com'], [3186, 'Friedl Powell', 'friedl.powell@laposte.net'], [5136, 'Benjamin Schultz', 'benjamin.schultz@rivero-davila.com'], [2646, 'Rachel Ulibarri', 'rachel.ulibarri@schueler.com'], [3460, 'Silvano Blanchet', 'silvano.blanchet@yahoo.com'], [4345, 'Kurt Sauer', 'kurt.sauer@almanza.biz'], [2690, 'Nayeli Gehringer', 'nayeli.gehringer@hotmail.com'], [4025, 'Imelda Guerin', 'imelda.guerin@stumpf.net'], [4524, 'Zbigniew Holmes', 'zbigniew.holmes@stiffel.net'], [3978, 'Adela Alfonsi', 'adela.alfonsi@despacho.com'], [3910, 'Hilary Clark', 'hilary.clark@libero.it'], [5825, 'Kornelius Molina', 'kornelius.molina@heuser.com'], [3564, 'Christian Anderson', 'christian.anderson@tim.it'], [2396, 'Francisco Dorsey', 'francisco.dorsey@tiscali.fr'], [2140, 'Walli Albert', 'walli.albert@dussen.com'], [3079, 'Siegrun Mota', 'siegrun.mota@matthews-montoya.org.au'], [2017, 'Alberico Herve', 'alberico.herve@beer.net'], [5444, 'Serafina Bonnin', 'serafina.bonnin@mendes.com'], [2216, 'Marcelle Bender', 'marcelle.bender@edwards-robinson.info'], [1241, 'Hartmuth Robertson', 'hartmuth.robertson@thomas.edu.au'], [1484, 'Herlinde George', 'herlinde.george@free.fr'], [3475, 'Pamela Payne', 'pamela.payne@yahoo.com'], [4333, 'Gastone Beyer', 'gastone.beyer@stewart-sanchez.edu'], [5657, 'Lydia Berengario', 'lydia.berengario@aol.de'], [2527, 'Lucy Davidson', 'lucy.davidson@tele2.it'], [5967, 'Franck Wade', 'franck.wade@gute.org'], [5698, 'Heidi Barker', 'heidi.barker@gmail.com'], [3331, 'Arnaldo Ocasio', 'arnaldo.ocasio@hotmail.com'], [3841, 'Francis Bernier', 'francis.bernier@rodriguez.com'], [6105, 'Johanne Strong', 'johanne.strong@yahoo.de'], [3895, 'Debra Langlois', 'debra.langlois@schmiedecke.com'], [1891, 'Reingard Kambs', 'reingard.kambs@sagese.eu'], [1281, 'Mauro Ortiz', 'mauro.ortiz@oquendo.net'], [4186, 'Griselda Carranza', 'griselda.carranza@krause.de'], [2511, 'Janet Madrigal', 'janet.madrigal@gmail.com'], [4272, 'Jenna Day', 'jenna.day@reed.com'], [3533, 'Modesto Wright', 'modesto.wright@pareto.com'], [3618, 'Alice Wall', 'alice.wall@zaccardo.it'], [2177, 'Brenda Sontag', 'brenda.sontag@solari.com'], [4102, 'Sergius Mace', 'sergius.mace@palazzo.com'], [6089, 'Antonia Kline', 'antonia.kline@gmail.com'], [4701, 'Maurice Gumprich', 'maurice.gumprich@griffin.net.au'], [5645, 'Daniel Anders', 'daniel.anders@yahoo.com'], [4499, 'Zaira Cattaneo', 'zaira.cattaneo@yahoo.com'], [3365, 'Alessio Bruneau', 'alessio.bruneau@hotmail.co.uk'], [2290, 'Gerdi Guerrero', 'gerdi.guerrero@tele2.fr'], [1890, 'Brigitte Stiebitz', 'brigitte.stiebitz@gmail.com'], [1304, 'June Sinisi', 'june.sinisi@manzoni-giannini.it'], [3799, 'Carl Macias', 'carl.macias@yahoo.com'], [2749, 'Veronica Trapp', 'veronica.trapp@tiscali.it'], [2028, 'Frances Garnier', 'frances.garnier@aporti-guidotti.org'], [2383, 'Terri Iannelli', 'terri.iannelli@hotmail.com'], [5721, 'Odette Moore', 'odette.moore@hall.edu'], [1394, 'Mercedes Trujillo', 'mercedes.trujillo@aol.de'], [3451, 'Babette Dumas', 'babette.dumas@brady.net'], [5512, 'Jerry Santiago', 'jerry.santiago@soprano-ferragni.it'], [2453, 'Ronald Simpson', 'ronald.simpson@ovadia.net'], [6055, 'Emmanuel Dominguez', 'emmanuel.dominguez@gmail.com'], [5704, 'Christiane Ricciardi', 'christiane.ricciardi@zavala.com'], [3707, 'Ingolf Zamora', 'ingolf.zamora@yahoo.com.au'], [2205, 'Rita Sharp', 'rita.sharp@beard-scott.edu.au'], [5976, 'Geraldine Cabrera', 'geraldine.cabrera@green-smith.info'], [3290, 'Chantal Armas', 'chantal.armas@jenkins.net'], [4257, 'Louis Gilbert', 'louis.gilbert@gmail.com'], [4588, 'Michelle Collier', 'michelle.collier@peruzzi.it'], [4785, 'Guillermina Nicholson', 'guillermina.nicholson@grondin.fr'], [3033, 'Bertrand Hopkins', 'bertrand.hopkins@gmail.com'], [2779, 'Alonso Palomo', 'alonso.palomo@gehringer.de'], [2131, 'Tina Rodriguez', 'tina.rodriguez@web.de'], [6229, 'Eva Francis', 'eva.francis@parker.org'], [3429, 'Ottavio Rust', 'ottavio.rust@crespi.com'], [1613, 'Amelia Olvera', 'amelia.olvera@hotmail.com'], [4734, 'Paul Palladio', 'paul.palladio@mclaughlin.net.au'], [4439, 'Bernardo Wieloch', 'bernardo.wieloch@budig.com'], [1441, 'Umberto Hicks', 'umberto.hicks@hill.com'], [5799, 'Janko Bishop', 'janko.bishop@tim.it'], [1419, 'Jessika Meunier', 'jessika.meunier@gmx.de'], [3059, 'Isaac Benard', 'isaac.benard@googlemail.com'], [3224, 'Alexandrie Lambert', 'alexandrie.lambert@yahoo.com'], [3181, 'Roberto Guyot', 'roberto.guyot@bennett.com'], [6061, 'Giulietta Lucas', 'giulietta.lucas@club.com'], [4466, 'Damaris Pininfarina', 'damaris.pininfarina@gmail.com'], [6081, 'Fabrizia Renard', 'fabrizia.renard@higgins-marks.com'], [2159, 'Camillo Dehmel', 'camillo.dehmel@brown-campbell.com'], [3324, 'Ruggero Parpinel', 'ruggero.parpinel@gmail.com'], [3176, 'Stephen Pratesi', 'stephen.pratesi@hotmail.com'], [5874, 'Ludger Naccari', 'ludger.naccari@ingram.biz'], [5110, 'Meryem Tapia', 'meryem.tapia@yahoo.com'], [5490, 'Jasmine Juvara', 'jasmine.juvara@yahoo.com.au'], [1922, 'Victoire Travaglia', 'victoire.travaglia@zacchia.com'], [4398, 'Adrian Noel', 'adrian.noel@perrin.com'], [4754, 'Marvin Howe', 'marvin.howe@gmail.com'], [3309, 'Hanne Kidd', 'hanne.kidd@yahoo.com'], [1244, 'Donatello Millet', 'donatello.millet@fritsch.net'], [2892, 'Eloisa Pascarella', 'eloisa.pascarella@gmail.com'], [2777, 'Erica Zambrano', 'erica.zambrano@gmail.com'], [4952, 'Paula Canales', 'paula.canales@gilmore-guerrero.com'], [5144, 'Claudia Bernard', 'claudia.bernard@mazzanti.it'], [5487, 'Paulina Miller', 'paulina.miller@lewis-barker.com'], [1932, 'Kathrin Godfrey', 'kathrin.godfrey@tele2.fr'], [3364, 'Pina Passalacqua', 'pina.passalacqua@yahoo.co.uk'], [5165, 'Julien Miles', 'julien.miles@stevens-rose.com'], [3858, 'Suzanne Benigni', 'suzanne.benigni@mennea-morlacchi.com'], [4666, 'Annalisa Pugh', 'annalisa.pugh@hotmail.fr'], [2896, 'Mathew Maestas', 'mathew.maestas@casas-garrido.com'], [4520, 'Laszlo Vallee', 'laszlo.vallee@verdier.com'], [5726, 'Helen Polanco', 'helen.polanco@hotmail.com'], [5661, 'Mateo Sorrentino', 'mateo.sorrentino@calderon.com'], [4765, 'Eric Barnes', 'eric.barnes@barrett-winter.com'], [3710, 'Dragica West', 'dragica.west@yahoo.com.au'], [4925, 'Antje Voisin', 'antje.voisin@gmail.com'], [1533, 'Stanley Mills', 'stanley.mills@parker-lee.biz'], [5264, 'Brandy Meraz', 'brandy.meraz@yahoo.com'], [4606, 'Conor Reinhardt', 'conor.reinhardt@yahoo.com.au'], [2043, 'Gabino Blot', 'gabino.blot@lewis-russell.org'], [3871, 'Alvaro Lemus', 'alvaro.lemus@yahoo.com'], [6205, 'Patrizia Wilms', 'patrizia.wilms@dbmail.com'], [3193, 'Metin Coulon', 'metin.coulon@ashley.com'], [1810, 'Reece Valencia', 'reece.valencia@laboy-palomo.com'], [4797, 'Troy Schmiedecke', 'troy.schmiedecke@picard.com'], [1487, 'Wendy Bustos', 'wendy.bustos@libero.it'], [3474, 'Guglielmo Caldwell', 'guglielmo.caldwell@loeffler.com'], [5771, 'Travis Cowan', 'travis.cowan@turner.info'], [6074, 'Brandi Abbagnale', 'brandi.abbagnale@tele2.fr'], [1568, 'Hanno Gollum', 'hanno.gollum@smith.com'], [4263, 'Jutta Burke', 'jutta.burke@elliott.com'], [5850, 'Dorothe Paz', 'dorothe.paz@fiebig.de'], [5619, 'Desiree Huerta', 'desiree.huerta@morris.com'], [1904, 'Ilse Bray', 'ilse.bray@venturi.it'], [5388, 'Pierpaolo Scaduto', 'pierpaolo.scaduto@sanders-gibson.com.au'], [2150, 'Amedeo Bradford', 'amedeo.bradford@yahoo.com'], [2653, 'Julia Ali', 'julia.ali@yahoo.com'], [2687, 'Catalina Pizzetti', 'catalina.pizzetti@tim.it'], [3779, 'Dylan Porzio', 'dylan.porzio@yahoo.de'], [1494, 'Iris Trincavelli', 'iris.trincavelli@tiscali.fr'], [4129, 'Johnathan Guidotti', 'johnathan.guidotti@cox-sanchez.net'], [3035, 'Walburga Vollbrecht', 'walburga.vollbrecht@aol.de'], [2069, 'Kendra David', 'kendra.david@allan-morton.com'], [5469, 'Aleksandr Weiss', 'aleksandr.weiss@blanc.org'], [3903, 'Cornelio Guardado', 'cornelio.guardado@gmail.com'], [4083, 'Ferdi Blackburn', 'ferdi.blackburn@christensen.net'], [4003, 'Bill Gallagher', 'bill.gallagher@green.com'], [3565, 'Leonard Harvey', 'leonard.harvey@hotmail.com'], [1640, 'Milan Montenegro', 'milan.montenegro@langern.com'], [4769, 'Philip Perez', 'philip.perez@hotmail.co.uk'], [3398, 'Kathryn Hentschel', 'kathryn.hentschel@shaw.com'], [1865, 'Xavier Samson', 'xavier.samson@baggio.it'], [5690, 'Hartwig Roberts', 'hartwig.roberts@saraceno.net'], [3814, 'Kimberly Chan', 'kimberly.chan@gmail.com'], [2942, 'Lorraine Crawford', 'lorraine.crawford@gmail.com'], [5095, 'Maximiliano Knowles', 'maximiliano.knowles@gmail.com'], [2878, 'Gabriella Avila', 'gabriella.avila@gmail.com'], [3697, 'Rico Mortati', 'rico.mortati@faivre.fr'], [4744, 'Gail Petrocelli', 'gail.petrocelli@yahoo.com'], [2104, 'Liberto Niemeier', 'liberto.niemeier@germano-dibiasi.it'], [4883, 'Luciana Petitjean', 'luciana.petitjean@patterson-cole.biz'], [4807, 'Ron Cavazos', 'ron.cavazos@yahoo.com'], [1372, 'Aldo Cibin', 'aldo.cibin@gmx.de'], [3666, 'Alexandre Serrano', 'alexandre.serrano@yahoo.co.uk'], [2066, 'Lori Fagotto', 'lori.fagotto@hill-anderson.com'], [1834, 'Perla Figueroa', 'perla.figueroa@live.com'], [5853, 'Reginald Hughes', 'reginald.hughes@gmail.com'], [2219, 'Uriel Holt', 'uriel.holt@gmail.com'], [4148, 'Stefano Lemonnier', 'stefano.lemonnier@binner.com'], [4477, 'Madeleine Cooper', 'madeleine.cooper@poste.it'], [1786, 'Alban Barbier', 'alban.barbier@ortiz.org'], [3455, 'Alfonso Finetti', 'alfonso.finetti@quiroz.com'], [5707, 'Ryan Kim', 'ryan.kim@noos.fr'], [5470, 'Augustin Wohlgemut', 'augustin.wohlgemut@watson.info'], [3274, 'Rolando Bibi', 'rolando.bibi@tin.it'], [4613, 'Berthold Randall', 'berthold.randall@mcdonald.com'], [4465, 'Genaro Briand', 'genaro.briand@sfr.fr'], [1652, 'Rudolf Jenkins', 'rudolf.jenkins@hotmail.com'], [2100, 'Pauline Ackermann', 'pauline.ackermann@arredondo-roque.com'], [4321, 'Folker Swanson', 'folker.swanson@rodrigues.fr'], [4168, 'Ashleigh Montez', 'ashleigh.montez@perry-schneider.com'], [3733, 'Liliana Barber', 'liliana.barber@libero.it'], [2594, 'Caridad Carr', 'caridad.carr@huhn.com'], [3909, 'Lolita Borrego', 'lolita.borrego@gmail.com'], [5179, 'Gunar Patrick', 'gunar.patrick@leroy.com'], [2228, 'Leokadia Verdier', 'leokadia.verdier@hotmail.com.au'], [6222, 'Hanna Reid', 'hanna.reid@salas.org'], [2354, 'Edelgard Kreusel', 'edelgard.kreusel@hotmail.com'], [1725, 'Svenja Perrin', 'svenja.perrin@berger.com'], [2960, 'Pierluigi Taccola', 'pierluigi.taccola@gmx.de'], [2077, 'Cilli Watts', 'cilli.watts@yahoo.com'], [5662, 'Emiliano Wells', 'emiliano.wells@gmx.de'], [3481, 'April Davids', 'april.davids@fisher.info'], [2565, 'Dolores Didier', 'dolores.didier@yahoo.com.au'], [4436, 'Sylvia Bonomo', 'sylvia.bonomo@poulain.com'], [5072, 'Nelly Marsh', 'nelly.marsh@hotmail.it'], [5200, 'Beth Miniati', 'beth.miniati@hudson.net'], [4502, 'Renee Merino', 'renee.merino@gmail.com'], [4945, 'Hailey Russell', 'hailey.russell@jourdan.org'], [3012, 'Raphaela Gotthard', 'raphaela.gotthard@outlook.com'], [6094, 'Pomponio Comencini', 'pomponio.comencini@hotmail.co.uk'], [3815, 'Leone Richardson', 'leone.richardson@yahoo.com'], [4838, 'Valentine Acosta', 'valentine.acosta@peters.net'], [3469, 'Ricciotti Laureano', 'ricciotti.laureano@parsons.com'], [4874, 'Jacques Heidrich', 'jacques.heidrich@zamudio-chapa.com'], [1792, 'Anne Snow', 'anne.snow@gmail.com'], [4356, 'Sonia Volta', 'sonia.volta@gmx.de'], [6196, 'Dale Leblanc', 'dale.leblanc@stewart.com'], [3578, 'Alejandro Cruz', 'alejandro.cruz@hotmail.com'], [4491, 'Elsa Cugia', 'elsa.cugia@yahoo.com'], [3054, 'Geronimo Pechel', 'geronimo.pechel@hotmail.com'], [1968, 'Melania Klemm', 'melania.klemm@seidel.com'], [5869, 'Katherine Cooley', 'katherine.cooley@yahoo.com'], [5858, 'Guillermo Larsen', 'guillermo.larsen@yahoo.com'], [5203, 'Jill Barrios', 'jill.barrios@gmail.com'], [2577, 'Austin Musatti', 'austin.musatti@tin.it'], [3216, 'Jacinto Rose', 'jacinto.rose@yahoo.com'], [2037, 'Lucie Redi', 'lucie.redi@googlemail.com'], [3867, 'Tania Chapman', 'tania.chapman@remy.com'], [5109, 'Alexandria Best', 'alexandria.best@yahoo.co.uk'], [1376, 'Edward Scott', 'edward.scott@yahoo.com'], [5260, 'Jake Wiley', 'jake.wiley@outlook.com'], [2350, 'Claudio Reuter', 'claudio.reuter@morgan-collins.org.au'], [2269, 'Laure Traetta', 'laure.traetta@kay-perkins.co.uk'], [3650, 'Magarete Valentin', 'magarete.valentin@yahoo.com'], [3934, 'Paige Hill', 'paige.hill@jones.org.au'], [4048, 'Fulvio Curiel', 'fulvio.curiel@reynolds.com'], [4266, 'Thibaut Camarillo', 'thibaut.camarillo@hotmail.com'], [3863, 'Romana Blanchard', 'romana.blanchard@googlemail.com'], [4922, 'Thibault Savorgnan', 'thibault.savorgnan@butler.biz'], [4517, 'Alexander Pausini', 'alexander.pausini@gonzalez.info'], [3259, 'Pierangelo Scholtz', 'pierangelo.scholtz@lefevre.com'], [3123, 'Emmanuelle Keller', 'emmanuelle.keller@morton-clarke.com'], [3870, 'Isabella Deleon', 'isabella.deleon@web.de'], [2996, 'Timothy Weitzel', 'timothy.weitzel@gmail.com'], [2993, 'Alfredo Ingram', 'alfredo.ingram@hotmail.com'], [4556, 'Francesca Kade', 'francesca.kade@luna-rael.org'], [2326, 'Tonia Coleman', 'tonia.coleman@hotmail.com'], [4109, 'Gottfried Barbe', 'gottfried.barbe@hotmail.com'], [5739, 'Jeffrey Trommler', 'jeffrey.trommler@yahoo.com'], [5887, 'Giacobbe Owens', 'giacobbe.owens@huet.fr'], [1651, 'Conchita Pagliaro', 'conchita.pagliaro@googlemail.com'], [1628, 'Kevin Delahaye', 'kevin.delahaye@ellis-wilson.com'], [2642, 'Rouven Ovadia', 'rouven.ovadia@gmail.com'], [6020, 'Piermaria Laporte', 'piermaria.laporte@wesack.com'], [4747, 'Karolin Johann', 'karolin.johann@hotmail.com'], [5534, 'Steven Folliero', 'steven.folliero@noos.fr'], [4790, 'Livio Rosselli', 'livio.rosselli@green.co.uk'], [4632, 'Gaetano Leonardi', 'gaetano.leonardi@despacho.com'], [1952, 'Cynthia Robinson', 'cynthia.robinson@gilles.net'], [4388, 'Eleni Aponte', 'eleni.aponte@club-internet.fr'], [5529, 'Noelia Romo', 'noelia.romo@yahoo.com'], [1316, 'Evelyn Haynes', 'evelyn.haynes@clark.info'], [1670, 'Katharine Zaccagnini', 'katharine.zaccagnini@hotmail.com'], [4909, 'Lea Merle', 'lea.merle@stey.de'], [3401, 'Marta Huynh', 'marta.huynh@hernandez.info'], [4619, 'Amador Riley', 'amador.riley@hotmail.com'], [4722, 'Julie Coles', 'julie.coles@hotmail.fr'], [2188, 'Beverley Telesio', 'beverley.telesio@regnier.fr'], [5497, 'Corinne Mitschke', 'corinne.mitschke@hauffer.net'], [5711, 'Valerie Ortega', 'valerie.ortega@tele2.it'], [4076, 'Carlos Delle', 'carlos.delle@hicks.com'], [1847, 'Christina Besnard', 'christina.besnard@delorme.com'], [2816, 'Rosario Jacques', 'rosario.jacques@yahoo.com'], [5019, 'Celal Fischer', 'celal.fischer@aol.de'], [4869, 'Leonardo Guzman', 'leonardo.guzman@andreozzi-abba.com'], [3613, 'Clinton Mason', 'clinton.mason@yahoo.com'], [3069, 'Loretta Mallet', 'loretta.mallet@sansoni-toscani.it'], [2601, 'Lorenzo Roero', 'lorenzo.roero@hotmail.co.uk'], [2133, 'Lando Gutierrez', 'lando.gutierrez@heser.com'], [3164, 'Elaine Patterson', 'elaine.patterson@rose-morris.org'], [3897, 'Marcella Govoni', 'marcella.govoni@barkholz.net'], [5663, 'Ettore Amaldi', 'ettore.amaldi@germain.com'], [3879, 'Rufino Gallegos', 'rufino.gallegos@webster-newton.co.uk'], [5900, 'Georges Richards', 'georges.richards@macdonald.com'], [2272, 'Janice Infantino', 'janice.infantino@hotmail.com'], [5436, 'Svetlana Montanariello', 'svetlana.montanariello@putz.de'], [3676, 'Agnolo Cedillo', 'agnolo.cedillo@laboratorios.biz'], [4676, 'Hannah Jockel', 'hannah.jockel@ceravolo-tonisto.eu'], [1563, 'Yvonne Stout', 'yvonne.stout@sims.edu'], [4349, 'Anouk Pace', 'anouk.pace@gmail.com'], [1658, 'Esteban Valdez', 'esteban.valdez@hotmail.com'], [2552, 'Angelina Davies', 'angelina.davies@hotmail.com'], [4847, 'Anastasie Cadena', 'anastasie.cadena@live.com'], [1553, 'Hansjoachim Lettiere', 'hansjoachim.lettiere@hall-mcdaniel.net'], [2632, 'Yeni Tejada', 'yeni.tejada@olson.edu.au'], [1908, 'Dulce Adinolfi', 'dulce.adinolfi@hotmail.com'], [5801, 'Sean Mielcarek', 'sean.mielcarek@gmail.com'], [1935, 'Omar Fonseca', 'omar.fonseca@grupo.org'], [2609, 'Henry Gucci', 'henry.gucci@leleu.fr'], [2740, 'Samira Bottaro', 'samira.bottaro@vasseur.fr'], [1907, 'Korinna Arnold', 'korinna.arnold@zapata-saenz.biz'], [1831, 'Marcela Ferrante', 'marcela.ferrante@gmx.de'], [5177, 'Douglas Amaya', 'douglas.amaya@favata-brenna.net'], [6179, 'Katherina Barrientos', 'katherina.barrientos@trobbiani.eu'], [2917, 'Brittany Tran', 'brittany.tran@tele2.it'], [1486, 'Caroline Reeves', 'caroline.reeves@yahoo.com'], [3735, 'Joe Michaud', 'joe.michaud@yahoo.fr'], [3838, 'Marco Vittadello', 'marco.vittadello@gmail.com'], [2430, 'Kim Webb', 'kim.webb@yahoo.com.au'], [2480, 'Eugenia Zichichi', 'eugenia.zichichi@yahoo.com'], [3431, 'Aurore Rosemann', 'aurore.rosemann@leoncavallo-rusticucci.com'], [1742, 'Giustino Luzi', 'giustino.luzi@rolland.fr'], [4628, 'Anita Galindo', 'anita.galindo@gmail.com'], [2385, 'Gunhild Carrillo', 'gunhild.carrillo@elliott-gilbert.org'], [2213, 'Rosa Paul', 'rosa.paul@bien.com'], [5188, 'Marliese Oneal', 'marliese.oneal@gmail.com'], [3418, 'Bethany Hartmann', 'bethany.hartmann@yahoo.com'], [5637, 'Irina Martineau', 'irina.martineau@gmail.com'], [3530, 'Beatriz Moulin', 'beatriz.moulin@pinto.com'], [3731, 'Lucas Austin', 'lucas.austin@gmail.com'], [3219, 'Carole Nohlmans', 'carole.nohlmans@yahoo.com'], [2392, 'Bozena Schmitt', 'bozena.schmitt@vallet.com'], [5103, 'Aimee Foconi', 'aimee.foconi@outlook.com'], [3992, 'Marzena Carrero', 'marzena.carrero@roskoth.de'], [2442, 'Raisa Poulain', 'raisa.poulain@fastwebnet.it'], [2913, 'Marcantonio Bennett', 'marcantonio.bennett@hopkins.com.au'], [1631, 'Kenneth Hurst', 'kenneth.hurst@meunier.net'], [4073, 'Marisela Mende', 'marisela.mende@godoy-enriquez.com'], [4568, 'Blanka Villareal', 'blanka.villareal@monduzzi.net'], [1830, 'Tomislav Stoppani', 'tomislav.stoppani@corporacin.org'], [2623, 'Krystal Ammaniti', 'krystal.ammaniti@barbier.fr'], [4327, 'Deanna Aporti', 'deanna.aporti@bouygtel.fr'], [3713, 'Donatella Burns', 'donatella.burns@yahoo.de'], [2389, 'Margrit Hooper', 'margrit.hooper@douglas.com'], [5141, 'Baccio Marcacci', 'baccio.marcacci@laposte.net'], [3522, 'Alfio Roman', 'alfio.roman@hotmail.co.uk'], [1334, 'Soledad Soto', 'soledad.soto@hotmail.de'], [4721, 'Josh Cimarosa', 'josh.cimarosa@hotmail.com'], [3768, 'Nath Rico', 'nath.rico@yahoo.com'], [1639, 'Gary Armani', 'gary.armani@web.de'], [5149, 'Miriam Oquendo', 'miriam.oquendo@smith-watson.biz'], [2153, 'Monica Mohaupt', 'monica.mohaupt@live.com'], [2767, 'Alec Ho', 'alec.ho@parra-esparza.com'], [5124, 'Harry Fouquet', 'harry.fouquet@ibarra-cooper.com'], [2097, 'Arcelia Babati', 'arcelia.babati@orange.fr'], [4796, 'Trinidad Vespa', 'trinidad.vespa@gmail.com'], [5849, 'Colette Ryan', 'colette.ryan@hotmail.com'], [1495, 'Richard Andre', 'richard.andre@porras.org'], [2462, 'Ellinor Leclercq', 'ellinor.leclercq@gmail.com'], [2280, 'Patricio Guillon', 'patricio.guillon@web.de'], [1877, 'Kirsten Chindamo', 'kirsten.chindamo@carrillo-wall.com'], [6108, 'Leo Petruzzi', 'leo.petruzzi@yahoo.com'], [4427, 'Margot Tomaselli', 'margot.tomaselli@junck.org'], [2881, 'Ansaldo Marks', 'ansaldo.marks@patel-odonnell.com'], [2339, 'Regina Morin', 'regina.morin@barcaccia.net'], [5156, 'Karla Medici', 'karla.medici@yahoo.com'], [4750, 'Morgan Irizarry', 'morgan.irizarry@williams-harris.biz'], [4852, 'Natividad Wong', 'natividad.wong@hoevel.com'], [5734, 'Anna Freeman', 'anna.freeman@snyder.net'], [3801, 'Emilia Vivaldi', 'emilia.vivaldi@garnier.fr'], [4474, 'Gerda Cook', 'gerda.cook@tin.it'], [1992, 'Andrey Faure', 'andrey.faure@frederick-mitchell.info'], [5796, 'Charlotte Duke', 'charlotte.duke@ochoa.org'], [1373, 'Cindy Castillo', 'cindy.castillo@virgilio.it'], [1879, 'Hiltrud Thibault', 'hiltrud.thibault@barbe.com'], [3072, 'Kasimir Jaime', 'kasimir.jaime@gmail.com'], [4561, 'Sabine Lachmann', 'sabine.lachmann@phillips.org'], [5201, 'Andrea Arroyo', 'andrea.arroyo@yahoo.com.au'], [5871, 'Matthew Velasquez', 'matthew.velasquez@gmail.com'], [3041, 'Severino Linares', 'severino.linares@angeli.com'], [5864, 'Swantje Lomeli', 'swantje.lomeli@gmx.de'], [3999, 'Marcus Espino', 'marcus.espino@comolli.eu'], [4849, 'Allen Gates', 'allen.gates@gmail.com'], [5461, 'Mauricio Saunders', 'mauricio.saunders@hotmail.co.uk'], [5946, 'Gilbert Cornejo', 'gilbert.cornejo@hotmail.com'], [4508, 'Letizia Gulotta', 'letizia.gulotta@howard.biz'], [5096, 'Etta Gutknecht', 'etta.gutknecht@leconte.net'], [5443, 'Shelley Perry', 'shelley.perry@gierschner.de'], [2165, 'Geoffrey Williams', 'geoffrey.williams@poste.it'], [2125, 'Cory Stewart', 'cory.stewart@voila.fr'], [6141, 'Kristy Bartlett', 'kristy.bartlett@outlook.com'], [5245, 'Gianluca Beck', 'gianluca.beck@green.biz'], [2190, 'Guido Krein', 'guido.krein@gmail.com'], [2243, 'Leif Monnier', 'leif.monnier@querini.it'], [3336, 'Jonas Badoer', 'jonas.badoer@kennedy.biz'], [3305, 'Devin Ebert', 'devin.ebert@yahoo.fr'], [6191, 'Slobodan Camiscione', 'slobodan.camiscione@hotmail.com'], [1326, 'Volkmar Gauthier', 'volkmar.gauthier@hotmail.com'], [6159, 'Jordan Rowe', 'jordan.rowe@outlook.com'], [2003, 'Manon Daugherty', 'manon.daugherty@segre.com'], [5881, 'Estela Segovia', 'estela.segovia@vodafone.it'], [1918, 'Giada Celentano', 'giada.celentano@evans.net'], [2157, 'Clayton Salcedo', 'clayton.salcedo@hotmail.co.uk'], [3149, 'Raven Pinto', 'raven.pinto@hotmail.com'], [2444, 'Lewis Lewis', 'lewis.lewis@pisano.net'], [6207, 'Rochus Rousseau', 'rochus.rousseau@nguyen.com'], [5580, 'Belinda Gamez', 'belinda.gamez@leleu.com'], [5942, 'Angelo Lozano', 'angelo.lozano@macias.com'], [1592, 'Jorge Monti', 'jorge.monti@clement.fr'], [2344, 'Ricky Harrell', 'ricky.harrell@martin.edu'], [5995, 'Adriano Wulf', 'adriano.wulf@schmidtke.net'], [5022, 'Pompeo Bourdon', 'pompeo.bourdon@gmail.com'], [5991, 'Kristie Garrett', 'kristie.garrett@wernecke.com'], [4020, 'Lodovico Conley', 'lodovico.conley@yahoo.com'], [6028, 'Jean Berthelot', 'jean.berthelot@oscuro.it'], [2790, 'Tadeusz Medina', 'tadeusz.medina@jackson-clark.net'], [4033, 'Ruby Carriera', 'ruby.carriera@hotmail.it'], [1261, 'Theres Antonioni', 'theres.antonioni@hotmail.com'], [1979, 'Gloria Morton', 'gloria.morton@outlook.com'], [2122, 'Graziano Jensen', 'graziano.jensen@gmail.com'], [4506, 'Gianpaolo Massey', 'gianpaolo.massey@bouvier.com'], [3016, 'Alain Farmer', 'alain.farmer@hotmail.it'], [3272, 'Renato Murillo', 'renato.murillo@club.com'], [1375, 'Edda Ferraris', 'edda.ferraris@libero.it'], [4014, 'Luce Marty', 'luce.marty@waehner.org'], [3199, 'Rotraud Mitchell', 'rotraud.mitchell@laboratorios.com'], [2184, 'Israel Watkins', 'israel.watkins@hotmail.com'], [2170, 'Nathan Jennings', 'nathan.jennings@kim.com'], [1478, 'Gavin Proietti', 'gavin.proietti@gmx.de'], [6163, 'Emma Rios', 'emma.rios@yahoo.com.au'], [1889, 'Todd Douglas', 'todd.douglas@web.de'], [5912, 'Oscar Holsten', 'oscar.holsten@yahoo.com'], [2537, 'Ann Peron', 'ann.peron@grupo.biz'], [2118, 'Senta Grassi', 'senta.grassi@hotmail.com'], [3234, 'Kata Mena', 'kata.mena@gmail.com'], [3842, 'Gianfranco Hethur', 'gianfranco.hethur@stewart-lee.com.au'], [3032, 'Florentine Saraceno', 'florentine.saraceno@gmail.com'], [3238, 'Giuliano Bolzmann', 'giuliano.bolzmann@pacillo.it'], [2059, 'Alwine Kostolzin', 'alwine.kostolzin@holloway.com'], [5238, 'Giacinto Briggs', 'giacinto.briggs@yahoo.co.uk'], [2578, 'Holly Negrete', 'holly.negrete@hotmail.com'], [4789, 'Mark Trapanese', 'mark.trapanese@gmail.com'], [2357, 'Alyssa Brun', 'alyssa.brun@chittolini-spadafora.it'], [1235, 'Cristina Chevalier', 'cristina.chevalier@proyectos.com'], [3558, 'Shannon Lefevre', 'shannon.lefevre@gmail.com'], [1707, 'Logan Hornich', 'logan.hornich@tin.it'], [2842, 'Rosalia Toro', 'rosalia.toro@free.fr'], [5318, 'Reiner Poerio', 'reiner.poerio@yahoo.com'], [1620, 'Valentina Pages', 'valentina.pages@hotmail.de'], [4998, 'Enrico Fabre', 'enrico.fabre@gmail.com'], [3111, 'Sevim Begue', 'sevim.begue@yahoo.com.au'], [1424, 'Sonja Patberg', 'sonja.patberg@hotmail.com'], [3244, 'Christine Hiller', 'christine.hiller@yahoo.com'], [4643, 'Maik Beasley', 'maik.beasley@harper-brooks.biz'], [6132, 'Elliot Santana', 'elliot.santana@gmx.de'], [3790, 'Eloy Renzi', 'eloy.renzi@gmail.com'], [1312, 'Wolf Lutz', 'wolf.lutz@nichols-jackson.com.au'], [5686, 'Giuseppe Lee', 'giuseppe.lee@mahe.org'], [2111, 'Angelica Cuellar', 'angelica.cuellar@zaguri-bellucci.net'], [5685, 'Bekir Normand', 'bekir.normand@yahoo.de'], [1905, 'Carmine Gonzales', 'carmine.gonzales@schleich.net'], [3271, 'Marianne Hubert', 'marianne.hubert@hotmail.com'], [4178, 'Gonzalo Montes', 'gonzalo.montes@hotmail.com'], [3275, 'Shelly Guichard', 'shelly.guichard@gmail.com'], [5713, 'Tobias Carbajal', 'tobias.carbajal@live.com'], [3339, 'Santiago Berry', 'santiago.berry@aol.de'], [5585, 'Emilio Davenport', 'emilio.davenport@zamora-russo.net'], [4407, 'Maurizio Gute', 'maurizio.gute@knight.info'], [1941, 'Nadia Travaglio', 'nadia.travaglio@colletti-broggini.com'], [4690, 'Elisa Barkholz', 'elisa.barkholz@sfr.fr'], [3607, 'Cristal Mazzini', 'cristal.mazzini@gmail.com'], [2670, 'Trevor Granados', 'trevor.granados@gmail.com'], [5261, 'Matthieu Mcdonald', 'matthieu.mcdonald@morrison.org'], [4121, 'Juliette Preston', 'juliette.preston@gmail.com'], [4620, 'Stanislaw Montalvo', 'stanislaw.montalvo@mcpherson-hughes.info'], [4630, 'Lilia Lollobrigida', 'lilia.lollobrigida@le.com'], [3440, 'Brigitta Shaw', 'brigitta.shaw@hotmail.co.uk'], [3572, 'Rebeca Frey', 'rebeca.frey@gerard.fr'], [5306, 'Nicolas Palacios', 'nicolas.palacios@meraz.com'], [5122, 'Susanna Bonneau', 'susanna.bonneau@klingelhoefer.de'], [1368, 'Romina Valentine', 'romina.valentine@hotmail.com'], [5370, 'Erika Toussaint', 'erika.toussaint@sfr.fr'], [5636, 'Lothar Laurent', 'lothar.laurent@garcia.com.au'], [6033, 'Chelsea Verdugo', 'chelsea.verdugo@campbell.com'], [3599, 'Ria Venier', 'ria.venier@murillo-estevez.com'], [5566, 'Carly Summers', 'carly.summers@yahoo.co.uk'], [1873, 'Pasquale Tomasini', 'pasquale.tomasini@hotmail.co.uk'], [3904, 'Stefani Ughi', 'stefani.ughi@hotmail.it'], [4453, 'Jose Huang', 'jose.huang@gmx.de'], [5481, 'Petros Gaona', 'petros.gaona@googlemail.com'], [2987, 'Maximilian Siering', 'maximilian.siering@gaito-fornaciari.org'], [2431, 'Ermenegildo Holzapfel', 'ermenegildo.holzapfel@aol.de'], [4158, 'Damien Leger', 'damien.leger@dixon.biz'], [3753, 'Zeferino Barrera', 'zeferino.barrera@zedillo-velazquez.com'], [4391, 'Alfred Pohl', 'alfred.pohl@fechner.net'], [2026, 'Marissa Gaito', 'marissa.gaito@reed-campbell.edu'], [4547, 'Ariana Houston', 'ariana.houston@hotmail.it'], [2798, 'Victor Jacobs', 'victor.jacobs@young.com'], [4732, 'Henriette Lang', 'henriette.lang@mimun.it'], [5126, 'Wilfriede Baca', 'wilfriede.baca@caraballo.com'], [5151, 'Lucia Riviere', 'lucia.riviere@samaniego.biz'], [2134, 'Gordon Vigorelli', 'gordon.vigorelli@solano.com'], [5786, 'Diethard Salgado', 'diethard.salgado@gmail.com'], [5515, 'Sue Corrales', 'sue.corrales@cardenas-serna.org'], [4530, 'Arthur Salazar', 'arthur.salazar@yahoo.com.au'], [4088, 'Fortunata Schneider', 'fortunata.schneider@tiscali.it'], [3667, 'Gretchen Serna', 'gretchen.serna@pichon.org'], [3286, 'Egon Caron', 'egon.caron@hotmail.com'], [4804, 'Roberta Finzi', 'roberta.finzi@knight-davies.co.uk'], [5768, 'Editha Savage', 'editha.savage@davies.co.uk'], [6098, 'Allan Emanuelli', 'allan.emanuelli@fernandes.org'], [2508, 'Laurence Lucero', 'laurence.lucero@martin.org'], [5779, 'Istvan Draghi', 'istvan.draghi@ifrance.com'], [1717, 'Luigi Bonnet', 'luigi.bonnet@carriera-federico.it'], [3368, 'Yuridia Fantozzi', 'yuridia.fantozzi@mcdonald.com'], [4265, 'Eraldo Schmiedt', 'eraldo.schmiedt@hotmail.de'], [4455, 'Antoinette Cox', 'antoinette.cox@bustamante.com'], [2940, 'Cameron Ocampo', 'cameron.ocampo@hotmail.com.au'], [6144, 'Lynn Lawson', 'lynn.lawson@leclercq.com'], [3657, 'Natalia Seifert', 'natalia.seifert@ifrance.com'], [1537, 'Nuray Anguillara', 'nuray.anguillara@yahoo.co.uk'], [2116, 'Beate Morgan', 'beate.morgan@gmail.com'], [5102, 'Mario Rees', 'mario.rees@gmx.de'], [5815, 'Galasso Junken', 'galasso.junken@yahoo.co.uk'], [4250, 'Luca Moses', 'luca.moses@franke.de'], [4533, 'Aurelio Gertz', 'aurelio.gertz@hewitt.net'], [3329, 'Uberto Steele', 'uberto.steele@outlook.com'], [3606, 'Annie Hunter', 'annie.hunter@allen.co.uk'], [4749, 'Jo Mccarty', 'jo.mccarty@hotmail.com'], [2222, 'Eitel Lombard', 'eitel.lombard@thomas.net'], [1939, 'Susan Vigliotti', 'susan.vigliotti@yahoo.co.uk'], [2456, 'Jacqueline Germano', 'jacqueline.germano@valette.fr'], [2794, 'Fidel Ruppert', 'fidel.ruppert@yahoo.co.uk'], [2648, 'Margaret Eigenwillig', 'margaret.eigenwillig@yahoo.com'], [2545, 'Yvette Harding', 'yvette.harding@yahoo.co.uk'], [3273, 'Federigo Karge', 'federigo.karge@bohlander.com'], [6155, 'Guenther Armenta', 'guenther.armenta@free.fr'], [6064, 'Coriolano Higgins', 'coriolano.higgins@murphy.org.au'], [1729, 'Felix Rubio', 'felix.rubio@ebert.de'], [4969, 'Melanie Leveque', 'melanie.leveque@fleury.net'], [3402, 'Abbie Galeati', 'abbie.galeati@ubaldi.it'], [2810, 'Vittorio Caccioppoli', 'vittorio.caccioppoli@yahoo.com'], [2217, 'Biagio Valenzuela', 'biagio.valenzuela@robinson.info'], [5140, 'Dario Green', 'dario.green@live.com'], [4497, 'Alwina Textor', 'alwina.textor@poste.it'], [5100, 'Diether Baeza', 'diether.baeza@grupo.biz'], [3390, 'Sole Trevino', 'sole.trevino@hotmail.com'], [1926, 'Darren Bernardi', 'darren.bernardi@brooks-martin.com'], [3264, 'Martina Heser', 'martina.heser@morellato.it'], [2573, 'Bethan Giacometti', 'bethan.giacometti@gmail.com'], [3628, 'Ethan Duhamel', 'ethan.duhamel@sfr.fr'], [3826, 'Corrado Warren', 'corrado.warren@hotmail.com.au'], [5983, 'Damian Pulido', 'damian.pulido@yahoo.de'], [5678, 'Dino Osborne', 'dino.osborne@despacho.com'], [2093, 'Nicolaus Bernetti', 'nicolaus.bernetti@aol.de'], [5333, 'Gianna Carroll', 'gianna.carroll@perez.com'], [5139, 'Grit Knight', 'grit.knight@web.de'], [3173, 'Erin Weinhold', 'erin.weinhold@hotmail.fr'], [3333, 'Craig Jordan', 'craig.jordan@gmail.com'], [2262, 'Homero Respighi', 'homero.respighi@gmail.com'], [1531, 'Fanny Pertile', 'fanny.pertile@gmail.com'], [4881, 'Fridolin Comboni', 'fridolin.comboni@graf.com'], [3928, 'Hugh Cantu', 'hugh.cantu@libero.it'], [1803, 'Alphons Simmons', 'alphons.simmons@hotmail.com'], [2321, 'Ludovico Cafarchia', 'ludovico.cafarchia@gmail.com'], [6234, 'Nico Kaiser', 'nico.kaiser@almonte.com'], [1422, 'Kirsty Lamy', 'kirsty.lamy@alonzi.it'], [2660, 'Joshua Scheibe', 'joshua.scheibe@turci.org'], [5361, 'Carin Pineau', 'carin.pineau@yahoo.com'], [3420, 'Ellie Galarza', 'ellie.galarza@pareto-cattaneo.net'], [4337, 'Marion Lira', 'marion.lira@ifrance.com'], [2338, 'Aurelia Angiolello', 'aurelia.angiolello@lord.com'], [4140, 'Maura Ravaglioli', 'maura.ravaglioli@yahoo.com'], [2373, 'Brunhilde Fletcher', 'brunhilde.fletcher@schomber.de'], [1344, 'Ottfried Marques', 'ottfried.marques@tyler-watson.info'], [2141, 'Christelle Blasi', 'christelle.blasi@morris-chan.com'], [3415, 'Augusto Vercelloni', 'augusto.vercelloni@club-internet.fr'], [5696, 'Michela Pruvost', 'michela.pruvost@holt.co.uk'], [1798, 'Guarino Escalante', 'guarino.escalante@hotmail.com'], [1657, 'Gabriela Padilla', 'gabriela.padilla@pearson-russell.com'], [3651, 'Agathe Dias', 'agathe.dias@jackson.com'], [3574, 'Werner Kallert', 'werner.kallert@gmail.com'], [6063, 'Lore Delaunay', 'lore.delaunay@yahoo.com'], [2404, 'Enzio Campos', 'enzio.campos@tim.it'], [2705, 'Walther Duarte', 'walther.duarte@web.de'], [5059, 'Adelgunde Trevisan', 'adelgunde.trevisan@gmail.com'], [5466, 'Thierry Schwartz', 'thierry.schwartz@travaglio.net'], [5821, 'Katie Andersen', 'katie.andersen@haney.com.au'], [5385, 'Kathy Zamorani', 'kathy.zamorani@hotmail.com'], [3506, 'Giuseppina Tanguy', 'giuseppina.tanguy@wanadoo.fr'], [5427, 'Jack Klapp', 'jack.klapp@hotmail.com.au'], [6142, 'Tom Leconte', 'tom.leconte@woods-johnson.com'], [2873, 'Bonnie Cignaroli', 'bonnie.cignaroli@yahoo.com'], [3916, 'Danny Farrell', 'danny.farrell@hotmail.com'], [1687, 'Fiorenzo Bauer', 'fiorenzo.bauer@gmail.com'], [1542, 'Randy Alfieri', 'randy.alfieri@verri.org'], [3087, 'Tim Bradley', 'tim.bradley@schlosser.de'], [3857, 'Yves Mendez', 'yves.mendez@gmail.com'], [5921, 'Raffaella Esquivel', 'raffaella.esquivel@gmail.com'], [3144, 'Lawrence Vasari', 'lawrence.vasari@castillo.edu'], [2676, 'Sam Adams', 'sam.adams@yahoo.com'], [3646, 'Mirco Nicolini', 'mirco.nicolini@blin.net'], [1321, 'Graham Bajardi', 'graham.bajardi@yahoo.com'], [1399, 'Luc Quinn', 'luc.quinn@walker.com'], [3169, 'Stella Ullrich', 'stella.ullrich@hotmail.com.au'], [2058, 'Calcedonio Remy', 'calcedonio.remy@edwards-benton.com'], [1300, 'Nanni Almaraz', 'nanni.almaraz@martin.com'], [2075, 'Pascual Corradi', 'pascual.corradi@lopez.net.au'], [2984, 'Kristi Grant', 'kristi.grant@yahoo.co.uk'], [4768, 'Manuel Gracia', 'manuel.gracia@trussardi.eu'], [3682, 'Gionata Hussain', 'gionata.hussain@yahoo.com'], [5901, 'Maria Nguyen', 'maria.nguyen@hernadez.com'], [3540, 'Leon Baker', 'leon.baker@hotmail.com'], [2225, 'Gianmarco Alcaraz', 'gianmarco.alcaraz@zacchia.net'], [1485, 'Derrick Little', 'derrick.little@small.org'], [5343, 'Terry Ramirez', 'terry.ramirez@hotmail.co.uk'], [5594, 'Katarina Clarke', 'katarina.clarke@hotmail.com.au'], [2482, 'Leila Washington', 'leila.washington@gmail.com'], [2706, 'Mirko Townsend', 'mirko.townsend@schmitt.com'], [4861, 'Randall Connolly', 'randall.connolly@jovinelli-castelli.com'], [2961, 'Pia Burgess', 'pia.burgess@proyectos.org'], [3043, 'Justine Mancini', 'justine.mancini@tiscali.it'], [6103, 'Reynaldo Wagenknecht', 'reynaldo.wagenknecht@faure.com'], [4708, 'Toni Magrassi', 'toni.magrassi@gmail.com'], [4395, 'Patrizio Cisneros', 'patrizio.cisneros@martinez.edu.au'], [4912, 'Durante Lindner', 'durante.lindner@picard.fr'], [2030, 'Rosl Lamborghini', 'rosl.lamborghini@hiller.net'], [5235, 'Ugo Harrison', 'ugo.harrison@morley-chapman.co.uk'], [5001, 'Isidor Carpenter', 'isidor.carpenter@chauvin.com'], [4093, 'Marie Zoppetto', 'marie.zoppetto@kallert.de'], [2576, 'Branko Chambers', 'branko.chambers@ifrance.com'], [6122, 'Alan Pineda', 'alan.pineda@proyectos.info'], [2813, 'Carmen Oestrovsky', 'carmen.oestrovsky@gmail.com'], [3737, 'Shane Fernandez', 'shane.fernandez@hotmail.de'], [2803, 'Debbie Guilbert', 'debbie.guilbert@berg.edu'], [5508, 'Vito Dossi', 'vito.dossi@hotmail.co.uk'], [3850, 'Evan Schacht', 'evan.schacht@price.com'], [4220, 'Mandy Weston', 'mandy.weston@free.fr'], [4532, 'Paulo Zito', 'paulo.zito@nelson.biz'], [6013, 'Alberto Girschner', 'alberto.girschner@laboratorios.com'], [3396, 'Giacomo Bouvet', 'giacomo.bouvet@gmail.com'], [4401, 'Ehrentraud Puga', 'ehrentraud.puga@laboratorios.com'], [2981, 'Cristian Hale', 'cristian.hale@hotmail.co.uk'], [4467, 'Lilija Charles', 'lilija.charles@gmail.com'], [1377, 'Albert Legendre', 'albert.legendre@lee.com'], [5036, 'Marisa Renaud', 'marisa.renaud@smith.org'], [5761, 'Sharon Diallo', 'sharon.diallo@gmail.com'], [3699, 'Eduardo Delattre', 'eduardo.delattre@lynch.net.au'], [4519, 'Bernadette Wang', 'bernadette.wang@gmail.com'], [5395, 'Dina Gibbons', 'dina.gibbons@brewer.net'], [3057, 'Clara Armstrong', 'clara.armstrong@vodafone.it'], [2741, 'Elliott Herrmann', 'elliott.herrmann@hotmail.com.au'], [1675, 'Graziella Vidal', 'graziella.vidal@hotmail.com'], [2712, 'Francisca Becerra', 'francisca.becerra@young.com.au'], [4527, 'Edeltrud Boyer', 'edeltrud.boyer@outlook.com'], [1722, 'Julian Noble', 'julian.noble@hill.org.au'], [4330, 'Christophe Bohnbach', 'christophe.bohnbach@ifrance.com'], [5219, 'Ippazio Angulo', 'ippazio.angulo@yahoo.com'], [4997, 'Grace Kroker', 'grace.kroker@hotmail.com'], [2239, 'Jared Ferguson', 'jared.ferguson@roberts.com'], [4587, 'Virginie McLean', 'virginie.mclean@yahoo.com'], [4113, 'Mason Potter', 'mason.potter@gmail.com'], [4762, 'Aaron Anaya', 'aaron.anaya@hotmail.com.au'], [5242, 'Leah Ornelas', 'leah.ornelas@gmail.com'], [5765, 'Harald Roy', 'harald.roy@web.de'], [2185, 'Micaela Martel', 'micaela.martel@hotmail.com'], [5500, 'Vincentio Sanders', 'vincentio.sanders@voila.fr'], [3494, 'Bettina Norbiato', 'bettina.norbiato@allen-lutz.org'], [3924, 'Julio Renner', 'julio.renner@industrias.net'], [3521, 'Jelena Stiffel', 'jelena.stiffel@trupp.de'], [5262, 'Guadalupe Munoz', 'guadalupe.munoz@murray-hamilton.com.au'], [3684, 'Whitney Noack', 'whitney.noack@laboratorios.org'], [5784, 'Gelsomina Migliaccio', 'gelsomina.migliaccio@junk.com'], [1498, 'Evangelista Pereira', 'evangelista.pereira@thompson-peterson.biz'], [6073, 'Gareth Comolli', 'gareth.comolli@tiscali.fr'], [4939, 'Michelangelo Hess', 'michelangelo.hess@bouygtel.fr']]\n"
     ]
    }
   ],
   "source": [
    "# Iterate through the contact_info_df and convert each row to a dictionary.\n",
    "import json\n",
    "dict_values = []\n",
    "\n",
    "for i,row in contact_info_df.iterrows():\n",
    "    \n",
    "    data=row['contact_info']\n",
    "    contact_data=json.loads(data)\n",
    "    values=[value for key, value in contact_data.items()]\n",
    "    dict_values.append(values)\n",
    "\n",
    "# Print out the list of values for each row.\n",
    "print(dict_values)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>contact_id</th>\n",
       "      <th>name</th>\n",
       "      <th>email</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4661</td>\n",
       "      <td>Cecilia Velasco</td>\n",
       "      <td>cecilia.velasco@rodrigues.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3765</td>\n",
       "      <td>Mariana Ellis</td>\n",
       "      <td>mariana.ellis@rossi.org</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4187</td>\n",
       "      <td>Sofie Woods</td>\n",
       "      <td>sofie.woods@riviere.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4941</td>\n",
       "      <td>Jeanette Iannotti</td>\n",
       "      <td>jeanette.iannotti@yahoo.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2199</td>\n",
       "      <td>Samuel Sorgatz</td>\n",
       "      <td>samuel.sorgatz@gmail.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   contact_id               name                         email\n",
       "0        4661    Cecilia Velasco  cecilia.velasco@rodrigues.fr\n",
       "1        3765      Mariana Ellis       mariana.ellis@rossi.org\n",
       "2        4187        Sofie Woods       sofie.woods@riviere.com\n",
       "3        4941  Jeanette Iannotti   jeanette.iannotti@yahoo.com\n",
       "4        2199     Samuel Sorgatz      samuel.sorgatz@gmail.com"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create a contact_info DataFrame and add each list of values, i.e., each row \n",
    "# to the 'contact_id', 'name', 'email' columns.\n",
    "\n",
    "contact_info_df = pd.DataFrame(dict_values, columns=['contact_id', 'name', 'email'])\n",
    "contact_info_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "contact_id     int64\n",
       "name          object\n",
       "email         object\n",
       "dtype: object"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check the datatypes.\n",
    "contact_info_df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>contact_id</th>\n",
       "      <th>email</th>\n",
       "      <th>first_name</th>\n",
       "      <th>last_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4661</td>\n",
       "      <td>cecilia.velasco@rodrigues.fr</td>\n",
       "      <td>Cecilia</td>\n",
       "      <td>Velasco</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3765</td>\n",
       "      <td>mariana.ellis@rossi.org</td>\n",
       "      <td>Mariana</td>\n",
       "      <td>Ellis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4187</td>\n",
       "      <td>sofie.woods@riviere.com</td>\n",
       "      <td>Sofie</td>\n",
       "      <td>Woods</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4941</td>\n",
       "      <td>jeanette.iannotti@yahoo.com</td>\n",
       "      <td>Jeanette</td>\n",
       "      <td>Iannotti</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2199</td>\n",
       "      <td>samuel.sorgatz@gmail.com</td>\n",
       "      <td>Samuel</td>\n",
       "      <td>Sorgatz</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   contact_id                         email first_name last_name\n",
       "0        4661  cecilia.velasco@rodrigues.fr    Cecilia   Velasco\n",
       "1        3765       mariana.ellis@rossi.org    Mariana     Ellis\n",
       "2        4187       sofie.woods@riviere.com      Sofie     Woods\n",
       "3        4941   jeanette.iannotti@yahoo.com   Jeanette  Iannotti\n",
       "4        2199      samuel.sorgatz@gmail.com     Samuel   Sorgatz"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create a \"first\"name\" and \"last_name\" column with the first and last names from the \"name\" column. \n",
    "\n",
    "contact_info_df[[\"first_name\",\"last_name\"]] = contact_info_df[\"name\"].str.split(expand=True)\n",
    "\n",
    "# Drop the contact_name column\n",
    "contact_info_df = contact_info_df.drop(\"name\",axis=1)\n",
    "contact_info_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "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>contact_id</th>\n",
       "      <th>first_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>email</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4661</td>\n",
       "      <td>Cecilia</td>\n",
       "      <td>Velasco</td>\n",
       "      <td>cecilia.velasco@rodrigues.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3765</td>\n",
       "      <td>Mariana</td>\n",
       "      <td>Ellis</td>\n",
       "      <td>mariana.ellis@rossi.org</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4187</td>\n",
       "      <td>Sofie</td>\n",
       "      <td>Woods</td>\n",
       "      <td>sofie.woods@riviere.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4941</td>\n",
       "      <td>Jeanette</td>\n",
       "      <td>Iannotti</td>\n",
       "      <td>jeanette.iannotti@yahoo.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2199</td>\n",
       "      <td>Samuel</td>\n",
       "      <td>Sorgatz</td>\n",
       "      <td>samuel.sorgatz@gmail.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   contact_id first_name last_name                         email\n",
       "0        4661    Cecilia   Velasco  cecilia.velasco@rodrigues.fr\n",
       "1        3765    Mariana     Ellis       mariana.ellis@rossi.org\n",
       "2        4187      Sofie     Woods       sofie.woods@riviere.com\n",
       "3        4941   Jeanette  Iannotti   jeanette.iannotti@yahoo.com\n",
       "4        2199     Samuel   Sorgatz      samuel.sorgatz@gmail.com"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Reorder the columns\n",
    "contacts_df_clean = contact_info_df[[\"contact_id\",\"first_name\",\"last_name\",\"email\"]]\n",
    "contacts_df_clean.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "contact_id     int64\n",
       "first_name    object\n",
       "last_name     object\n",
       "email         object\n",
       "dtype: object"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check the datatypes one more time before exporting as CSV file.\n",
    "contacts_df_clean.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Export the DataFrame as a CSV file. \n",
    "contacts_df_clean.to_csv(\"Resources/contacts.csv\", encoding='utf8', index=False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.11.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}