ETL_Mini_Project.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)\n",
    "\n",
    "\n",
    "import json"
   ]
  },
  {
   "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()"
   ]
  },
  {
   "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",
    "\n",
    "\n",
    "# We have 'category & sub-category' is an existing column\n",
    "#'crowdfunding_info_df' is our DataFrame\n",
    "\n",
    "# Split the values in the 'category & sub-category column based on the delimiter ('/')\n",
    "split_category_subcategory_values = crowdfunding_info_df['category & sub-category'].str.split('/')\n",
    "\n",
    "# Assign the first element of the split result to 'category' column\n",
    "crowdfunding_info_df['category'] = split_category_subcategory_values.str[0]\n",
    "\n",
    "# Assign the second element of the split result to 'subcategory' column\n",
    "crowdfunding_info_df['subcategory'] = split_category_subcategory_values.str[1]\n",
    "\n",
    "\n",
    "#Display the Data Frame\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', 'photography', 'journalism']\n",
      "\n",
      "['food trucks', 'rock', 'web', 'plays', 'documentary', 'electric music', 'drama', 'indie rock', 'wearables', 'nonfiction', 'animation', 'video games', 'shorts', 'fiction', 'photography books', 'radio & podcasts', 'metal', 'jazz', 'translations', 'television', 'mobile games', 'world music', 'science fiction', 'audio']\n"
     ]
    }
   ],
   "source": [
    "# Get the unique categories and subcategories in separate lists.\n",
    "\n",
    "# Get unique categories and convert to a list\n",
    "categories = crowdfunding_info_df['category'].unique().tolist()\n",
    "\n",
    "# Get unique subcategories and convert to a list\n",
    "subcategories = crowdfunding_info_df['subcategory'].unique().tolist()\n",
    "\n",
    "# Display the results\n",
    "print(categories)\n",
    "print()\n",
    "print(subcategories)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Total number of categories is     9\n",
      "Total number of subcategories is  24\n"
     ]
    }
   ],
   "source": [
    "# Get the number of distinct values in the categories and subcategories lists.\n",
    "print(\"Total number of categories is    \", len(categories))\n",
    "print(\"Total number of subcategories is \", 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 = [f\"cat{category_id}\" for category_id in category_ids]\n",
    "\n",
    "# Use a list comprehension to add \"subcat\" to each subcategory_id.    \n",
    "scat_ids = [f\"subcat{subcategory_id}\" for subcategory_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_dict = {'category_id' : cat_ids , 'category' : categories}\n",
    "category_df = pd.DataFrame(category_dict)\n",
    "\n",
    "# Create a category DataFrame with the subcategory_id array as the subcategory_id and subcategories list as the subcategory name. \n",
    "subcategory_dict = {'subcategory_id' : scat_ids , 'subcategory' : subcategories}\n",
    "subcategory_df = pd.DataFrame(subcategory_dict)"
   ]
  },
  {
   "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(\"Output Files/category.csv\", index=False)\n",
    "\n",
    "subcategory_df.to_csv(\"Output Files/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>launch_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  launch_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 in 'campaign_df' DataFrame.\n",
    "\n",
    "# Creating a dictionary for new column names\n",
    "new_column_names = {\n",
    "    'blurb': 'description',\n",
    "    'launched_at': 'launch_date',\n",
    "    'deadline': 'end_date'\n",
    "}\n",
    "\n",
    "# Use the rename method to rename columns\n",
    "campaign_df.rename(columns = new_column_names, inplace=True)\n",
    "\n",
    "# Display the DataFrame with the renamed columns\n",
    "campaign_df.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Convert the goal and pledged columns to a `float` data type.\n",
    "\n",
    "campaign_df['goal'] = campaign_df['goal'].astype(float)\n",
    "campaign_df['pledged'] = campaign_df['pledged'].astype(float)"
   ]
  },
  {
   "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",
       "launch_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>launch_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>2020-02-13</td>\n",
       "      <td>2021-03-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>2021-01-25</td>\n",
       "      <td>2021-05-25</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>2020-12-17</td>\n",
       "      <td>2021-12-30</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>2021-10-21</td>\n",
       "      <td>2022-01-17</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>2020-12-21</td>\n",
       "      <td>2021-08-23</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 launch_date    end_date  \\\n",
       "0      failed              0      CA      CAD  2020-02-13  2021-03-01   \n",
       "1  successful            158      US      USD  2021-01-25  2021-05-25   \n",
       "2  successful           1425      AU      AUD  2020-12-17  2021-12-30   \n",
       "3      failed             24      US      USD  2021-10-21  2022-01-17   \n",
       "4      failed             53      US      USD  2020-12-21  2021-08-23   \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",
    "\n",
    "campaign_df[\"launch_date\"] = pd.to_datetime(campaign_df[\"launch_date\"], unit='s').dt.strftime('%Y-%m-%d') \n",
    "campaign_df[\"end_date\"] = pd.to_datetime(campaign_df[\"end_date\"], unit='s').dt.strftime('%Y-%m-%d')\n",
    "\n",
    "#Display the DataFrame\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>launch_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>1561</td>\n",
       "      <td>5500</td>\n",
       "      <td>Ortiz-Roberts</td>\n",
       "      <td>Devolved foreground customer loyalty</td>\n",
       "      <td>7800.0</td>\n",
       "      <td>6839.0</td>\n",
       "      <td>failed</td>\n",
       "      <td>64</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>2021-06-09</td>\n",
       "      <td>2021-06-18</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>film &amp; video/drama</td>\n",
       "      <td>film &amp; video</td>\n",
       "      <td>drama</td>\n",
       "      <td>cat5</td>\n",
       "      <td>subcat7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>991</th>\n",
       "      <td>2632</td>\n",
       "      <td>3494</td>\n",
       "      <td>Ramirez LLC</td>\n",
       "      <td>Reduced reciprocal focus group</td>\n",
       "      <td>9800.0</td>\n",
       "      <td>11091.0</td>\n",
       "      <td>successful</td>\n",
       "      <td>241</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>2020-12-09</td>\n",
       "      <td>2021-05-26</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>music/rock</td>\n",
       "      <td>music</td>\n",
       "      <td>rock</td>\n",
       "      <td>cat2</td>\n",
       "      <td>subcat2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>992</th>\n",
       "      <td>439</td>\n",
       "      <td>3924</td>\n",
       "      <td>Morrow Inc</td>\n",
       "      <td>Networked global migration</td>\n",
       "      <td>3100.0</td>\n",
       "      <td>13223.0</td>\n",
       "      <td>successful</td>\n",
       "      <td>132</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>2020-06-14</td>\n",
       "      <td>2021-02-09</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>film &amp; video/drama</td>\n",
       "      <td>film &amp; video</td>\n",
       "      <td>drama</td>\n",
       "      <td>cat5</td>\n",
       "      <td>subcat7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993</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>2021-07-03</td>\n",
       "      <td>2021-07-08</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>994</th>\n",
       "      <td>1419</td>\n",
       "      <td>5262</td>\n",
       "      <td>Leach, Rich and Price</td>\n",
       "      <td>Implemented bi-directional flexibility</td>\n",
       "      <td>141100.0</td>\n",
       "      <td>74073.0</td>\n",
       "      <td>failed</td>\n",
       "      <td>842</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>2021-11-15</td>\n",
       "      <td>2021-12-07</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>publishing/translations</td>\n",
       "      <td>publishing</td>\n",
       "      <td>translations</td>\n",
       "      <td>cat6</td>\n",
       "      <td>subcat19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>2986</td>\n",
       "      <td>3684</td>\n",
       "      <td>Manning-Hamilton</td>\n",
       "      <td>Vision-oriented scalable definition</td>\n",
       "      <td>97300.0</td>\n",
       "      <td>153216.0</td>\n",
       "      <td>successful</td>\n",
       "      <td>2043</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>2020-12-29</td>\n",
       "      <td>2021-05-30</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>food/food trucks</td>\n",
       "      <td>food</td>\n",
       "      <td>food trucks</td>\n",
       "      <td>cat1</td>\n",
       "      <td>subcat1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>2031</td>\n",
       "      <td>5784</td>\n",
       "      <td>Butler LLC</td>\n",
       "      <td>Future-proofed upward-trending migration</td>\n",
       "      <td>6600.0</td>\n",
       "      <td>4814.0</td>\n",
       "      <td>failed</td>\n",
       "      <td>112</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>2021-10-15</td>\n",
       "      <td>2021-11-30</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>theater/plays</td>\n",
       "      <td>theater</td>\n",
       "      <td>plays</td>\n",
       "      <td>cat4</td>\n",
       "      <td>subcat4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>1627</td>\n",
       "      <td>1498</td>\n",
       "      <td>Ball LLC</td>\n",
       "      <td>Right-sized full-range throughput</td>\n",
       "      <td>7600.0</td>\n",
       "      <td>4603.0</td>\n",
       "      <td>canceled</td>\n",
       "      <td>139</td>\n",
       "      <td>IT</td>\n",
       "      <td>EUR</td>\n",
       "      <td>2021-11-06</td>\n",
       "      <td>2021-12-10</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>theater/plays</td>\n",
       "      <td>theater</td>\n",
       "      <td>plays</td>\n",
       "      <td>cat4</td>\n",
       "      <td>subcat4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>2175</td>\n",
       "      <td>6073</td>\n",
       "      <td>Taylor, Santiago and Flores</td>\n",
       "      <td>Polarized composite customer loyalty</td>\n",
       "      <td>66600.0</td>\n",
       "      <td>37823.0</td>\n",
       "      <td>failed</td>\n",
       "      <td>374</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>2020-10-08</td>\n",
       "      <td>2021-04-11</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>music/indie rock</td>\n",
       "      <td>music</td>\n",
       "      <td>indie rock</td>\n",
       "      <td>cat2</td>\n",
       "      <td>subcat8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>1788</td>\n",
       "      <td>4939</td>\n",
       "      <td>Hernandez, Norton and Kelley</td>\n",
       "      <td>Expanded eco-centric policy</td>\n",
       "      <td>111100.0</td>\n",
       "      <td>62819.0</td>\n",
       "      <td>canceled</td>\n",
       "      <td>1122</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>2020-12-30</td>\n",
       "      <td>2021-08-18</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",
       "      <td>cat1</td>\n",
       "      <td>subcat1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     cf_id  contact_id                  company_name  \\\n",
       "990   1561        5500                 Ortiz-Roberts   \n",
       "991   2632        3494                   Ramirez LLC   \n",
       "992    439        3924                    Morrow Inc   \n",
       "993    461        3521               Erickson-Rogers   \n",
       "994   1419        5262         Leach, Rich and Price   \n",
       "995   2986        3684              Manning-Hamilton   \n",
       "996   2031        5784                    Butler LLC   \n",
       "997   1627        1498                      Ball LLC   \n",
       "998   2175        6073   Taylor, Santiago and Flores   \n",
       "999   1788        4939  Hernandez, Norton and Kelley   \n",
       "\n",
       "                                  description      goal   pledged     outcome  \\\n",
       "990      Devolved foreground customer loyalty    7800.0    6839.0      failed   \n",
       "991            Reduced reciprocal focus group    9800.0   11091.0  successful   \n",
       "992                Networked global migration    3100.0   13223.0  successful   \n",
       "993      De-engineered even-keeled definition    9800.0    7608.0    canceled   \n",
       "994    Implemented bi-directional flexibility  141100.0   74073.0      failed   \n",
       "995       Vision-oriented scalable definition   97300.0  153216.0  successful   \n",
       "996  Future-proofed upward-trending migration    6600.0    4814.0      failed   \n",
       "997         Right-sized full-range throughput    7600.0    4603.0    canceled   \n",
       "998      Polarized composite customer loyalty   66600.0   37823.0      failed   \n",
       "999               Expanded eco-centric policy  111100.0   62819.0    canceled   \n",
       "\n",
       "     backers_count country currency launch_date    end_date  staff_pick  \\\n",
       "990             64      US      USD  2021-06-09  2021-06-18       False   \n",
       "991            241      US      USD  2020-12-09  2021-05-26       False   \n",
       "992            132      US      USD  2020-06-14  2021-02-09       False   \n",
       "993             75      IT      EUR  2021-07-03  2021-07-08       False   \n",
       "994            842      US      USD  2021-11-15  2021-12-07       False   \n",
       "995           2043      US      USD  2020-12-29  2021-05-30       False   \n",
       "996            112      US      USD  2021-10-15  2021-11-30       False   \n",
       "997            139      IT      EUR  2021-11-06  2021-12-10       False   \n",
       "998            374      US      USD  2020-10-08  2021-04-11       False   \n",
       "999           1122      US      USD  2020-12-30  2021-08-18       False   \n",
       "\n",
       "     spotlight        category & sub-category      category  \\\n",
       "990       True             film & video/drama  film & video   \n",
       "991       True                     music/rock         music   \n",
       "992       True             film & video/drama  film & video   \n",
       "993       True  photography/photography books   photography   \n",
       "994       True        publishing/translations    publishing   \n",
       "995       True               food/food trucks          food   \n",
       "996      False                  theater/plays       theater   \n",
       "997      False                  theater/plays       theater   \n",
       "998       True               music/indie rock         music   \n",
       "999      False               food/food trucks          food   \n",
       "\n",
       "           subcategory category_id subcategory_id  \n",
       "990              drama        cat5        subcat7  \n",
       "991               rock        cat2        subcat2  \n",
       "992              drama        cat5        subcat7  \n",
       "993  photography books        cat8       subcat15  \n",
       "994       translations        cat6       subcat19  \n",
       "995        food trucks        cat1        subcat1  \n",
       "996              plays        cat4        subcat4  \n",
       "997              plays        cat4        subcat4  \n",
       "998         indie rock        cat2        subcat8  \n",
       "999        food trucks        cat1        subcat1  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Merge the campaign_df with the category_df on the \"category\" column and \n",
    "campaign_category_df=pd.merge(campaign_df , category_df , on='category', how=\"left\")\n",
    "\n",
    "# Merge the resultant DataFrame 'campaign_category_df' with the subcategory_df on the \"subcategory\" column.\n",
    "campaign_merged_df=pd.merge(campaign_category_df , subcategory_df , on='subcategory' , how=\"left\")\n",
    "\n",
    "# To display the last 10 rows of the DataFrame\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>launch_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>2020-02-13</td>\n",
       "      <td>2021-03-01</td>\n",
       "      <td>cat1</td>\n",
       "      <td>subcat1</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>2021-01-25</td>\n",
       "      <td>2021-05-25</td>\n",
       "      <td>cat2</td>\n",
       "      <td>subcat2</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>2020-12-17</td>\n",
       "      <td>2021-12-30</td>\n",
       "      <td>cat3</td>\n",
       "      <td>subcat3</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>2021-10-21</td>\n",
       "      <td>2022-01-17</td>\n",
       "      <td>cat2</td>\n",
       "      <td>subcat2</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>2020-12-21</td>\n",
       "      <td>2021-08-23</td>\n",
       "      <td>cat4</td>\n",
       "      <td>subcat4</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 launch_date    end_date  \\\n",
       "0      failed              0      CA      CAD  2020-02-13  2021-03-01   \n",
       "1  successful            158      US      USD  2021-01-25  2021-05-25   \n",
       "2  successful           1425      AU      AUD  2020-12-17  2021-12-30   \n",
       "3      failed             24      US      USD  2021-10-21  2022-01-17   \n",
       "4      failed             53      US      USD  2020-12-21  2021-08-23   \n",
       "\n",
       "  category_id subcategory_id  \n",
       "0        cat1        subcat1  \n",
       "1        cat2        subcat2  \n",
       "2        cat3        subcat3  \n",
       "3        cat2        subcat2  \n",
       "4        cat4        subcat4  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Drop unwanted columns \n",
    "# We found these unwanted columns (staff_pick,spotlight,category & subcategory, category and sub-category)\n",
    "\n",
    "campaign_cleaned_df = campaign_merged_df.drop( ['staff_pick', 'spotlight',\n",
    "                                            'category & sub-category', \n",
    "                                            'category', 'subcategory'],\n",
    "                                           axis=1 )\n",
    "\n",
    "#Display the Data Frame after dropping the unwanted columns\n",
    "campaign_cleaned_df.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "14"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Review to confirm the number of columns after dropping in the DataFrame\n",
    "campaign_cleaned_df.columns.nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Export 'campaign_cleaned_df' the DataFrame as a CSV file. \n",
    "campaign_cleaned_df.to_csv(\"Output Files/campaign.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Extract the contacts.xlsx Data."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Read the data into a Pandas DataFrame. Use the `header=3` 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": 24,
   "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",
    "\n",
    "dict_values = []\n",
    "\n",
    "\n",
    "for i, row in contact_info_df.iterrows():\n",
    "    \n",
    "    data = row[0]\n",
    "    contact_info_dict = json.loads(data)\n",
    "    \n",
    "    \n",
    "    # Extract the each dictionary values from the keys\n",
    "    # For each row using list comprehension\n",
    "    row_values = [v for k, v in contact_info_dict.items()]\n",
    "    \n",
    "     # Append the list of values for each row to a list. \n",
    "    dict_values.append(row_values)\n",
    "\n",
    "    \n",
    "\n",
    "# Print out the list of values for each row.\n",
    "print(dict_values)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['contact_id', 'name', 'email']\n"
     ]
    }
   ],
   "source": [
    "# Review the 'contact_info_dict' dictionary before create the Data Frame\n",
    "\n",
    "# Get column names from the keys of the dictionary\n",
    "columns = list(contact_info_dict.keys())\n",
    "\n",
    "# Display the column names\n",
    "print(columns)\n"
   ]
  },
  {
   "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>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": 26,
     "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",
    "column=['contact_id', 'name', 'email']\n",
    "\n",
    "# Create a new DataFrame using dict_values and columns\n",
    "new_contact_info_df = pd.DataFrame(dict_values, columns=column)\n",
    "\n",
    "# Display the new DataFrame\n",
    "new_contact_info_df.head() "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1000 entries, 0 to 999\n",
      "Data columns (total 3 columns):\n",
      " #   Column      Non-Null Count  Dtype \n",
      "---  ------      --------------  ----- \n",
      " 0   contact_id  1000 non-null   int64 \n",
      " 1   name        1000 non-null   object\n",
      " 2   email       1000 non-null   object\n",
      "dtypes: int64(1), object(2)\n",
      "memory usage: 23.6+ KB\n"
     ]
    }
   ],
   "source": [
    "# Check the datatypes.\n",
    "new_contact_info_df.info()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "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",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5650</td>\n",
       "      <td>socorro.luna@hotmail.com</td>\n",
       "      <td>Socorro</td>\n",
       "      <td>Luna</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>5889</td>\n",
       "      <td>carolina.murray@knight.com</td>\n",
       "      <td>Carolina</td>\n",
       "      <td>Murray</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4842</td>\n",
       "      <td>kayla.moon@yahoo.de</td>\n",
       "      <td>Kayla</td>\n",
       "      <td>Moon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3280</td>\n",
       "      <td>ariadna.geisel@rangel.com</td>\n",
       "      <td>Ariadna</td>\n",
       "      <td>Geisel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5468</td>\n",
       "      <td>danielle.ladeck@scalfaro.net</td>\n",
       "      <td>Danielle</td>\n",
       "      <td>Ladeck</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\n",
       "5        5650      socorro.luna@hotmail.com    Socorro      Luna\n",
       "6        5889    carolina.murray@knight.com   Carolina    Murray\n",
       "7        4842           kayla.moon@yahoo.de      Kayla      Moon\n",
       "8        3280     ariadna.geisel@rangel.com    Ariadna    Geisel\n",
       "9        5468  danielle.ladeck@scalfaro.net   Danielle    Ladeck"
      ]
     },
     "execution_count": 28,
     "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",
    "# Split the \"name\" column into \"first_name\" and \"last_name\" columns\n",
    "new_contact_info_df['first_name'] = new_contact_info_df['name'].str.split().str[0]\n",
    "new_contact_info_df['last_name'] = new_contact_info_df['name'].str.split().str[-1]\n",
    "\n",
    "# Drop the original \"name\" column\n",
    "new_contact_info_df.drop('name', axis=1, inplace=True)\n",
    "\n",
    "# Display the new DataFrame\n",
    "new_contact_info_df.head(10)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "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",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5650</td>\n",
       "      <td>Socorro</td>\n",
       "      <td>Luna</td>\n",
       "      <td>socorro.luna@hotmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>5889</td>\n",
       "      <td>Carolina</td>\n",
       "      <td>Murray</td>\n",
       "      <td>carolina.murray@knight.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4842</td>\n",
       "      <td>Kayla</td>\n",
       "      <td>Moon</td>\n",
       "      <td>kayla.moon@yahoo.de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3280</td>\n",
       "      <td>Ariadna</td>\n",
       "      <td>Geisel</td>\n",
       "      <td>ariadna.geisel@rangel.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5468</td>\n",
       "      <td>Danielle</td>\n",
       "      <td>Ladeck</td>\n",
       "      <td>danielle.ladeck@scalfaro.net</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\n",
       "5        5650    Socorro      Luna      socorro.luna@hotmail.com\n",
       "6        5889   Carolina    Murray    carolina.murray@knight.com\n",
       "7        4842      Kayla      Moon           kayla.moon@yahoo.de\n",
       "8        3280    Ariadna    Geisel     ariadna.geisel@rangel.com\n",
       "9        5468   Danielle    Ladeck  danielle.ladeck@scalfaro.net"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Reorder the columns\n",
    "\n",
    "new_contact_info_df = new_contact_info_df [['contact_id','first_name','last_name','email']]\n",
    "\n",
    "new_contact_info_df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1000 entries, 0 to 999\n",
      "Data columns (total 4 columns):\n",
      " #   Column      Non-Null Count  Dtype \n",
      "---  ------      --------------  ----- \n",
      " 0   contact_id  1000 non-null   int64 \n",
      " 1   first_name  1000 non-null   object\n",
      " 2   last_name   1000 non-null   object\n",
      " 3   email       1000 non-null   object\n",
      "dtypes: int64(1), object(3)\n",
      "memory usage: 31.4+ KB\n"
     ]
    }
   ],
   "source": [
    "# Check the datatypes one more time before exporting as CSV file.\n",
    "new_contact_info_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Export the DataFrame as a CSV file. \n",
    "new_contact_info_df.to_csv(\"Output Files/contacts.csv\", encoding='utf8', index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Option 2: Use regex to create the contacts DataFrame."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "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": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "regex_contact_info_df = contact_info_df.copy()\n",
    "regex_contact_info_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "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",
       "      <th>contact_id</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",
       "      <td>4661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>{\"contact_id\": 3765, \"name\": \"Mariana Ellis\", \"email\": \"mariana.ellis@rossi.org\"}</td>\n",
       "      <td>3765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>{\"contact_id\": 4187, \"name\": \"Sofie Woods\", \"email\": \"sofie.woods@riviere.com\"}</td>\n",
       "      <td>4187</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>{\"contact_id\": 4941, \"name\": \"Jeanette Iannotti\", \"email\": \"jeanette.iannotti@yahoo.com\"}</td>\n",
       "      <td>4941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>{\"contact_id\": 2199, \"name\": \"Samuel Sorgatz\", \"email\": \"samuel.sorgatz@gmail.com\"}</td>\n",
       "      <td>2199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>{\"contact_id\": 5650, \"name\": \"Socorro Luna\", \"email\": \"socorro.luna@hotmail.com\"}</td>\n",
       "      <td>5650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>{\"contact_id\": 5889, \"name\": \"Carolina Murray\", \"email\": \"carolina.murray@knight.com\"}</td>\n",
       "      <td>5889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>{\"contact_id\": 4842, \"name\": \"Kayla Moon\", \"email\": \"kayla.moon@yahoo.de\"}</td>\n",
       "      <td>4842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>{\"contact_id\": 3280, \"name\": \"Ariadna Geisel\", \"email\": \"ariadna.geisel@rangel.com\"}</td>\n",
       "      <td>3280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>{\"contact_id\": 5468, \"name\": \"Danielle Ladeck\", \"email\": \"danielle.ladeck@scalfaro.net\"}</td>\n",
       "      <td>5468</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\"}   \n",
       "5          {\"contact_id\": 5650, \"name\": \"Socorro Luna\", \"email\": \"socorro.luna@hotmail.com\"}   \n",
       "6     {\"contact_id\": 5889, \"name\": \"Carolina Murray\", \"email\": \"carolina.murray@knight.com\"}   \n",
       "7                 {\"contact_id\": 4842, \"name\": \"Kayla Moon\", \"email\": \"kayla.moon@yahoo.de\"}   \n",
       "8       {\"contact_id\": 3280, \"name\": \"Ariadna Geisel\", \"email\": \"ariadna.geisel@rangel.com\"}   \n",
       "9   {\"contact_id\": 5468, \"name\": \"Danielle Ladeck\", \"email\": \"danielle.ladeck@scalfaro.net\"}   \n",
       "\n",
       "  contact_id  \n",
       "0       4661  \n",
       "1       3765  \n",
       "2       4187  \n",
       "3       4941  \n",
       "4       2199  \n",
       "5       5650  \n",
       "6       5889  \n",
       "7       4842  \n",
       "8       3280  \n",
       "9       5468  "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Extract the four-digit contact ID number.\n",
    "\n",
    "regex_contact_info_df['contact_id'] = regex_contact_info_df['contact_info'].astype(str).str.extract(r'(\\d{4})')\n",
    "regex_contact_info_df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1000 entries, 0 to 999\n",
      "Data columns (total 2 columns):\n",
      " #   Column        Non-Null Count  Dtype \n",
      "---  ------        --------------  ----- \n",
      " 0   contact_info  1000 non-null   object\n",
      " 1   contact_id    1000 non-null   object\n",
      "dtypes: object(2)\n",
      "memory usage: 15.8+ KB\n"
     ]
    }
   ],
   "source": [
    "# Check the datatypes.\n",
    "regex_contact_info_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "contact_info    object\n",
       "contact_id       int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Convert the \"contact_id\" column to an int64 data type.\n",
    "\n",
    "regex_contact_info_df['contact_id'] = regex_contact_info_df ['contact_id'].astype('int64')\n",
    "regex_contact_info_df.dtypes\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "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",
       "      <th>contact_id</th>\n",
       "      <th>name</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",
       "      <td>4661</td>\n",
       "      <td>Cecilia Velasco</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>{\"contact_id\": 3765, \"name\": \"Mariana Ellis\", \"email\": \"mariana.ellis@rossi.org\"}</td>\n",
       "      <td>3765</td>\n",
       "      <td>Mariana Ellis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>{\"contact_id\": 4187, \"name\": \"Sofie Woods\", \"email\": \"sofie.woods@riviere.com\"}</td>\n",
       "      <td>4187</td>\n",
       "      <td>Sofie Woods</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>{\"contact_id\": 4941, \"name\": \"Jeanette Iannotti\", \"email\": \"jeanette.iannotti@yahoo.com\"}</td>\n",
       "      <td>4941</td>\n",
       "      <td>Jeanette Iannotti</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>{\"contact_id\": 2199, \"name\": \"Samuel Sorgatz\", \"email\": \"samuel.sorgatz@gmail.com\"}</td>\n",
       "      <td>2199</td>\n",
       "      <td>Samuel Sorgatz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>{\"contact_id\": 5650, \"name\": \"Socorro Luna\", \"email\": \"socorro.luna@hotmail.com\"}</td>\n",
       "      <td>5650</td>\n",
       "      <td>Socorro Luna</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>{\"contact_id\": 5889, \"name\": \"Carolina Murray\", \"email\": \"carolina.murray@knight.com\"}</td>\n",
       "      <td>5889</td>\n",
       "      <td>Carolina Murray</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>{\"contact_id\": 4842, \"name\": \"Kayla Moon\", \"email\": \"kayla.moon@yahoo.de\"}</td>\n",
       "      <td>4842</td>\n",
       "      <td>Kayla Moon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>{\"contact_id\": 3280, \"name\": \"Ariadna Geisel\", \"email\": \"ariadna.geisel@rangel.com\"}</td>\n",
       "      <td>3280</td>\n",
       "      <td>Ariadna Geisel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>{\"contact_id\": 5468, \"name\": \"Danielle Ladeck\", \"email\": \"danielle.ladeck@scalfaro.net\"}</td>\n",
       "      <td>5468</td>\n",
       "      <td>Danielle Ladeck</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\"}   \n",
       "5          {\"contact_id\": 5650, \"name\": \"Socorro Luna\", \"email\": \"socorro.luna@hotmail.com\"}   \n",
       "6     {\"contact_id\": 5889, \"name\": \"Carolina Murray\", \"email\": \"carolina.murray@knight.com\"}   \n",
       "7                 {\"contact_id\": 4842, \"name\": \"Kayla Moon\", \"email\": \"kayla.moon@yahoo.de\"}   \n",
       "8       {\"contact_id\": 3280, \"name\": \"Ariadna Geisel\", \"email\": \"ariadna.geisel@rangel.com\"}   \n",
       "9   {\"contact_id\": 5468, \"name\": \"Danielle Ladeck\", \"email\": \"danielle.ladeck@scalfaro.net\"}   \n",
       "\n",
       "   contact_id               name  \n",
       "0        4661    Cecilia Velasco  \n",
       "1        3765      Mariana Ellis  \n",
       "2        4187        Sofie Woods  \n",
       "3        4941  Jeanette Iannotti  \n",
       "4        2199     Samuel Sorgatz  \n",
       "5        5650       Socorro Luna  \n",
       "6        5889    Carolina Murray  \n",
       "7        4842         Kayla Moon  \n",
       "8        3280     Ariadna Geisel  \n",
       "9        5468    Danielle Ladeck  "
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Extract the name of the contact and add it to a new column.\n",
    "regex_contact_info_df['name'] = regex_contact_info_df['contact_info'].str.extract(r'\"name\": \"([^\"]+)\"')\n",
    "\n",
    "# Display the updated DataFrame\n",
    "regex_contact_info_df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "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",
       "      <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>{\"contact_id\": 4661, \"name\": \"Cecilia Velasco\", \"email\": \"cecilia.velasco@rodrigues.fr\"}</td>\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>{\"contact_id\": 3765, \"name\": \"Mariana Ellis\", \"email\": \"mariana.ellis@rossi.org\"}</td>\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>{\"contact_id\": 4187, \"name\": \"Sofie Woods\", \"email\": \"sofie.woods@riviere.com\"}</td>\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>{\"contact_id\": 4941, \"name\": \"Jeanette Iannotti\", \"email\": \"jeanette.iannotti@yahoo.com\"}</td>\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>{\"contact_id\": 2199, \"name\": \"Samuel Sorgatz\", \"email\": \"samuel.sorgatz@gmail.com\"}</td>\n",
       "      <td>2199</td>\n",
       "      <td>Samuel Sorgatz</td>\n",
       "      <td>samuel.sorgatz@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>{\"contact_id\": 5650, \"name\": \"Socorro Luna\", \"email\": \"socorro.luna@hotmail.com\"}</td>\n",
       "      <td>5650</td>\n",
       "      <td>Socorro Luna</td>\n",
       "      <td>socorro.luna@hotmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>{\"contact_id\": 5889, \"name\": \"Carolina Murray\", \"email\": \"carolina.murray@knight.com\"}</td>\n",
       "      <td>5889</td>\n",
       "      <td>Carolina Murray</td>\n",
       "      <td>carolina.murray@knight.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>{\"contact_id\": 4842, \"name\": \"Kayla Moon\", \"email\": \"kayla.moon@yahoo.de\"}</td>\n",
       "      <td>4842</td>\n",
       "      <td>Kayla Moon</td>\n",
       "      <td>kayla.moon@yahoo.de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>{\"contact_id\": 3280, \"name\": \"Ariadna Geisel\", \"email\": \"ariadna.geisel@rangel.com\"}</td>\n",
       "      <td>3280</td>\n",
       "      <td>Ariadna Geisel</td>\n",
       "      <td>ariadna.geisel@rangel.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>{\"contact_id\": 5468, \"name\": \"Danielle Ladeck\", \"email\": \"danielle.ladeck@scalfaro.net\"}</td>\n",
       "      <td>5468</td>\n",
       "      <td>Danielle Ladeck</td>\n",
       "      <td>danielle.ladeck@scalfaro.net</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\"}   \n",
       "5          {\"contact_id\": 5650, \"name\": \"Socorro Luna\", \"email\": \"socorro.luna@hotmail.com\"}   \n",
       "6     {\"contact_id\": 5889, \"name\": \"Carolina Murray\", \"email\": \"carolina.murray@knight.com\"}   \n",
       "7                 {\"contact_id\": 4842, \"name\": \"Kayla Moon\", \"email\": \"kayla.moon@yahoo.de\"}   \n",
       "8       {\"contact_id\": 3280, \"name\": \"Ariadna Geisel\", \"email\": \"ariadna.geisel@rangel.com\"}   \n",
       "9   {\"contact_id\": 5468, \"name\": \"Danielle Ladeck\", \"email\": \"danielle.ladeck@scalfaro.net\"}   \n",
       "\n",
       "   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  \n",
       "5        5650       Socorro Luna      socorro.luna@hotmail.com  \n",
       "6        5889    Carolina Murray    carolina.murray@knight.com  \n",
       "7        4842         Kayla Moon           kayla.moon@yahoo.de  \n",
       "8        3280     Ariadna Geisel     ariadna.geisel@rangel.com  \n",
       "9        5468    Danielle Ladeck  danielle.ladeck@scalfaro.net  "
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Extract the email from the contacts and add the values to a new column.\n",
    "regex_contact_info_df['email'] = regex_contact_info_df['contact_info'].str.extract(r'\"email\": \"([^\"]+)\"')\n",
    "\n",
    "# Display the updated DataFrame\n",
    "regex_contact_info_df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5650</td>\n",
       "      <td>Socorro Luna</td>\n",
       "      <td>socorro.luna@hotmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>5889</td>\n",
       "      <td>Carolina Murray</td>\n",
       "      <td>carolina.murray@knight.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4842</td>\n",
       "      <td>Kayla Moon</td>\n",
       "      <td>kayla.moon@yahoo.de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3280</td>\n",
       "      <td>Ariadna Geisel</td>\n",
       "      <td>ariadna.geisel@rangel.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5468</td>\n",
       "      <td>Danielle Ladeck</td>\n",
       "      <td>danielle.ladeck@scalfaro.net</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\n",
       "5        5650       Socorro Luna      socorro.luna@hotmail.com\n",
       "6        5889    Carolina Murray    carolina.murray@knight.com\n",
       "7        4842         Kayla Moon           kayla.moon@yahoo.de\n",
       "8        3280     Ariadna Geisel     ariadna.geisel@rangel.com\n",
       "9        5468    Danielle Ladeck  danielle.ladeck@scalfaro.net"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create a copy of the regex_contact_info_df with the 'contact_id', 'name', 'email' columns.\n",
    "new_regex_contact_info = regex_contact_info_df[['contact_id', 'name', 'email']].copy()\n",
    "\n",
    "# Display the copied DataFra_me\n",
    "new_regex_contact_info.head(10)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "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",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5650</td>\n",
       "      <td>socorro.luna@hotmail.com</td>\n",
       "      <td>Socorro</td>\n",
       "      <td>Luna</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>5889</td>\n",
       "      <td>carolina.murray@knight.com</td>\n",
       "      <td>Carolina</td>\n",
       "      <td>Murray</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4842</td>\n",
       "      <td>kayla.moon@yahoo.de</td>\n",
       "      <td>Kayla</td>\n",
       "      <td>Moon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3280</td>\n",
       "      <td>ariadna.geisel@rangel.com</td>\n",
       "      <td>Ariadna</td>\n",
       "      <td>Geisel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5468</td>\n",
       "      <td>danielle.ladeck@scalfaro.net</td>\n",
       "      <td>Danielle</td>\n",
       "      <td>Ladeck</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\n",
       "5        5650      socorro.luna@hotmail.com    Socorro      Luna\n",
       "6        5889    carolina.murray@knight.com   Carolina    Murray\n",
       "7        4842           kayla.moon@yahoo.de      Kayla      Moon\n",
       "8        3280     ariadna.geisel@rangel.com    Ariadna    Geisel\n",
       "9        5468  danielle.ladeck@scalfaro.net   Danielle    Ladeck"
      ]
     },
     "execution_count": 39,
     "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",
    "new_regex_contact_info[['first_name', 'last_name']] = new_regex_contact_info['name'].str.extract(r'(?P<first_name>\\w+)\\s+(?P<last_name>\\w+)')\n",
    "\n",
    "# Drop the original \"name\" column\n",
    "new_regex_contact_info.drop('name', axis=1, inplace=True)\n",
    "\n",
    "\n",
    "# Display the updated DataFrame\n",
    "new_regex_contact_info.head(10)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "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",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5650</td>\n",
       "      <td>Socorro</td>\n",
       "      <td>Luna</td>\n",
       "      <td>socorro.luna@hotmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>5889</td>\n",
       "      <td>Carolina</td>\n",
       "      <td>Murray</td>\n",
       "      <td>carolina.murray@knight.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4842</td>\n",
       "      <td>Kayla</td>\n",
       "      <td>Moon</td>\n",
       "      <td>kayla.moon@yahoo.de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3280</td>\n",
       "      <td>Ariadna</td>\n",
       "      <td>Geisel</td>\n",
       "      <td>ariadna.geisel@rangel.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5468</td>\n",
       "      <td>Danielle</td>\n",
       "      <td>Ladeck</td>\n",
       "      <td>danielle.ladeck@scalfaro.net</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\n",
       "5        5650    Socorro      Luna      socorro.luna@hotmail.com\n",
       "6        5889   Carolina    Murray    carolina.murray@knight.com\n",
       "7        4842      Kayla      Moon           kayla.moon@yahoo.de\n",
       "8        3280    Ariadna    Geisel     ariadna.geisel@rangel.com\n",
       "9        5468   Danielle    Ladeck  danielle.ladeck@scalfaro.net"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Reorder the columns\n",
    "\n",
    "new_regex_contact_info = new_regex_contact_info [['contact_id','first_name','last_name','email']]\n",
    "\n",
    "new_regex_contact_info.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1000 entries, 0 to 999\n",
      "Data columns (total 4 columns):\n",
      " #   Column      Non-Null Count  Dtype \n",
      "---  ------      --------------  ----- \n",
      " 0   contact_id  1000 non-null   int64 \n",
      " 1   first_name  1000 non-null   object\n",
      " 2   last_name   1000 non-null   object\n",
      " 3   email       1000 non-null   object\n",
      "dtypes: int64(1), object(3)\n",
      "memory usage: 31.4+ KB\n"
     ]
    }
   ],
   "source": [
    "# Check the datatypes one more time before exporting as CSV file.\n",
    "new_regex_contact_info.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Export the DataFrame as a CSV file. \n",
    "new_regex_contact_info.to_csv(\"Output Files/regex_contacts.csv\", encoding='utf8', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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
}