crowdfunding_data_ETL.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "c7b07b70",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "# Import the Numpy dependency\n",
    "import numpy as np\n",
    "from datetime import datetime as dt\n",
    "import json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "39d12369",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['crowdfunding_info', 'contact_info']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Read the data into a Pandas DataFrame\n",
    "crowdfunding_data = pd.ExcelFile(\"crowdfunding.xlsx\")\n",
    "# Get the sheet names.\n",
    "crowdfunding_data.sheet_names"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "b5027757",
   "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>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>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>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>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>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>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                 company_name  \\\n",
       "0    147   Baldwin, Riley and Jackson   \n",
       "1   1621                     Odom Inc   \n",
       "2   1812   Melton, Robinson and Fritz   \n",
       "3   2156  Mcdonald, Gonzalez and Ross   \n",
       "4   1365                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": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get the crowdfunding_info from the crowdfunding_info worksheet. \n",
    "crowdfunding_info_df = pd.read_excel(crowdfunding_data, sheet_name='crowdfunding_info')\n",
    "crowdfunding_info_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "ca50939d",
   "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": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get the contact_info from the contact_info worksheet.\n",
    "# Increase the width of the column.\n",
    "pd.set_option('max_colwidth', 400)\n",
    "contact_info_df = pd.read_excel(crowdfunding_data, sheet_name='contact_info', header=3)\n",
    "contact_info_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "8b5f8a04",
   "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>995</th>\n",
       "      <td>{\"contact_id\": 3684, \"name\": \"Whitney Noack\", \"email\": \"whitney.noack@laboratorios.org\"}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>{\"contact_id\": 5784, \"name\": \"Gelsomina Migliaccio\", \"email\": \"gelsomina.migliaccio@junk.com\"}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>{\"contact_id\": 1498, \"name\": \"Evangelista Pereira\", \"email\": \"evangelista.pereira@thompson-peterson.biz\"}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>{\"contact_id\": 6073, \"name\": \"Gareth Comolli\", \"email\": \"gareth.comolli@tiscali.fr\"}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>{\"contact_id\": 4939, \"name\": \"Michelangelo Hess\", \"email\": \"michelangelo.hess@bouygtel.fr\"}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                                  contact_info\n",
       "995                   {\"contact_id\": 3684, \"name\": \"Whitney Noack\", \"email\": \"whitney.noack@laboratorios.org\"}\n",
       "996             {\"contact_id\": 5784, \"name\": \"Gelsomina Migliaccio\", \"email\": \"gelsomina.migliaccio@junk.com\"}\n",
       "997  {\"contact_id\": 1498, \"name\": \"Evangelista Pereira\", \"email\": \"evangelista.pereira@thompson-peterson.biz\"}\n",
       "998                       {\"contact_id\": 6073, \"name\": \"Gareth Comolli\", \"email\": \"gareth.comolli@tiscali.fr\"}\n",
       "999                {\"contact_id\": 4939, \"name\": \"Michelangelo Hess\", \"email\": \"michelangelo.hess@bouygtel.fr\"}"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "contact_info_df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "12c2807b",
   "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>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>995</th>\n",
       "      <td>2986</td>\n",
       "      <td>Manning-Hamilton</td>\n",
       "      <td>Vision-oriented scalable definition</td>\n",
       "      <td>97300</td>\n",
       "      <td>153216</td>\n",
       "      <td>successful</td>\n",
       "      <td>2043</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1609221600</td>\n",
       "      <td>1622350800</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>food/food trucks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>2031</td>\n",
       "      <td>Butler LLC</td>\n",
       "      <td>Future-proofed upward-trending migration</td>\n",
       "      <td>6600</td>\n",
       "      <td>4814</td>\n",
       "      <td>failed</td>\n",
       "      <td>112</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1634274000</td>\n",
       "      <td>1638252000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>theater/plays</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>1627</td>\n",
       "      <td>Ball LLC</td>\n",
       "      <td>Right-sized full-range throughput</td>\n",
       "      <td>7600</td>\n",
       "      <td>4603</td>\n",
       "      <td>canceled</td>\n",
       "      <td>139</td>\n",
       "      <td>IT</td>\n",
       "      <td>EUR</td>\n",
       "      <td>1636174800</td>\n",
       "      <td>1639116000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>theater/plays</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>2175</td>\n",
       "      <td>Taylor, Santiago and Flores</td>\n",
       "      <td>Polarized composite customer loyalty</td>\n",
       "      <td>66600</td>\n",
       "      <td>37823</td>\n",
       "      <td>failed</td>\n",
       "      <td>374</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1602133200</td>\n",
       "      <td>1618117200</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>music/indie rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>1788</td>\n",
       "      <td>Hernandez, Norton and Kelley</td>\n",
       "      <td>Expanded eco-centric policy</td>\n",
       "      <td>111100</td>\n",
       "      <td>62819</td>\n",
       "      <td>canceled</td>\n",
       "      <td>1122</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1609308000</td>\n",
       "      <td>1629262800</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>food/food trucks</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     cf_id                  company_name  \\\n",
       "995   2986              Manning-Hamilton   \n",
       "996   2031                    Butler LLC   \n",
       "997   1627                      Ball LLC   \n",
       "998   2175   Taylor, Santiago and Flores   \n",
       "999   1788  Hernandez, Norton and Kelley   \n",
       "\n",
       "                                        blurb    goal  pledged     outcome  \\\n",
       "995       Vision-oriented scalable definition   97300   153216  successful   \n",
       "996  Future-proofed upward-trending migration    6600     4814      failed   \n",
       "997         Right-sized full-range throughput    7600     4603    canceled   \n",
       "998      Polarized composite customer loyalty   66600    37823      failed   \n",
       "999               Expanded eco-centric policy  111100    62819    canceled   \n",
       "\n",
       "     backers_count country currency  launched_at    deadline  staff_pick  \\\n",
       "995           2043      US      USD   1609221600  1622350800       False   \n",
       "996            112      US      USD   1634274000  1638252000       False   \n",
       "997            139      IT      EUR   1636174800  1639116000       False   \n",
       "998            374      US      USD   1602133200  1618117200       False   \n",
       "999           1122      US      USD   1609308000  1629262800       False   \n",
       "\n",
       "     spotlight category & sub-category  \n",
       "995       True        food/food trucks  \n",
       "996      False           theater/plays  \n",
       "997      False           theater/plays  \n",
       "998       True        music/indie rock  \n",
       "999      False        food/food trucks  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "crowdfunding_info_df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "fb3f1217",
   "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>70</th>\n",
       "      <td>{\"contact_id\": 2611, \"name\": \"Thomas Hutchinson\", \"email\": \"thomas.hutchinson@gmx.de\"}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>{\"contact_id\": 5256, \"name\": \"Silvester Brookes\", \"email\": \"silvester.brookes@franco.org\"}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>826</th>\n",
       "      <td>{\"contact_id\": 5786, \"name\": \"Diethard Salgado\", \"email\": \"diethard.salgado@gmail.com\"}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>882</th>\n",
       "      <td>{\"contact_id\": 3333, \"name\": \"Craig Jordan\", \"email\": \"craig.jordan@gmail.com\"}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>465</th>\n",
       "      <td>{\"contact_id\": 3193, \"name\": \"Metin Coulon\", \"email\": \"metin.coulon@ashley.com\"}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                   contact_info\n",
       "70       {\"contact_id\": 2611, \"name\": \"Thomas Hutchinson\", \"email\": \"thomas.hutchinson@gmx.de\"}\n",
       "162  {\"contact_id\": 5256, \"name\": \"Silvester Brookes\", \"email\": \"silvester.brookes@franco.org\"}\n",
       "826     {\"contact_id\": 5786, \"name\": \"Diethard Salgado\", \"email\": \"diethard.salgado@gmail.com\"}\n",
       "882             {\"contact_id\": 3333, \"name\": \"Craig Jordan\", \"email\": \"craig.jordan@gmail.com\"}\n",
       "465            {\"contact_id\": 3193, \"name\": \"Metin Coulon\", \"email\": \"metin.coulon@ashley.com\"}"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "contact_info_df.sample(n=5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "c7052600",
   "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>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>363</th>\n",
       "      <td>807</td>\n",
       "      <td>Gray-Davis</td>\n",
       "      <td>Re-contextualized local initiative</td>\n",
       "      <td>5200</td>\n",
       "      <td>8330</td>\n",
       "      <td>successful</td>\n",
       "      <td>139</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1615528800</td>\n",
       "      <td>1633582800</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>music/rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>2730</td>\n",
       "      <td>Moss, Norman and Dunlap</td>\n",
       "      <td>Upgradable upward-trending workforce</td>\n",
       "      <td>8300</td>\n",
       "      <td>9337</td>\n",
       "      <td>successful</td>\n",
       "      <td>199</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1629522000</td>\n",
       "      <td>1636956000</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>theater/plays</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>2915</td>\n",
       "      <td>Hernandez Group</td>\n",
       "      <td>Ergonomic uniform open system</td>\n",
       "      <td>128100</td>\n",
       "      <td>40107</td>\n",
       "      <td>failed</td>\n",
       "      <td>955</td>\n",
       "      <td>DK</td>\n",
       "      <td>DKK</td>\n",
       "      <td>1589605200</td>\n",
       "      <td>1616043600</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>music/indie rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>348</th>\n",
       "      <td>553</td>\n",
       "      <td>Hensley Ltd</td>\n",
       "      <td>Versatile cohesive open system</td>\n",
       "      <td>199000</td>\n",
       "      <td>142823</td>\n",
       "      <td>failed</td>\n",
       "      <td>3483</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1627362000</td>\n",
       "      <td>1637474400</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>food/food trucks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>960</th>\n",
       "      <td>923</td>\n",
       "      <td>Robbins Group</td>\n",
       "      <td>Function-based interactive matrix</td>\n",
       "      <td>5500</td>\n",
       "      <td>4678</td>\n",
       "      <td>failed</td>\n",
       "      <td>55</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1612418400</td>\n",
       "      <td>1615096800</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>technology/web</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     cf_id             company_name                                 blurb  \\\n",
       "363    807               Gray-Davis    Re-contextualized local initiative   \n",
       "147   2730  Moss, Norman and Dunlap  Upgradable upward-trending workforce   \n",
       "168   2915          Hernandez Group         Ergonomic uniform open system   \n",
       "348    553              Hensley Ltd        Versatile cohesive open system   \n",
       "960    923            Robbins Group     Function-based interactive matrix   \n",
       "\n",
       "       goal  pledged     outcome  backers_count country currency  launched_at  \\\n",
       "363    5200     8330  successful            139      US      USD   1615528800   \n",
       "147    8300     9337  successful            199      US      USD   1629522000   \n",
       "168  128100    40107      failed            955      DK      DKK   1589605200   \n",
       "348  199000   142823      failed           3483      US      USD   1627362000   \n",
       "960    5500     4678      failed             55      US      USD   1612418400   \n",
       "\n",
       "       deadline  staff_pick  spotlight category & sub-category  \n",
       "363  1633582800       False      False              music/rock  \n",
       "147  1636956000       False       True           theater/plays  \n",
       "168  1616043600       False       True        music/indie rock  \n",
       "348  1637474400       False      False        food/food trucks  \n",
       "960  1615096800       False      False          technology/web  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "crowdfunding_info_df.sample(n=5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "9af10481",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1000 entries, 0 to 999\n",
      "Data columns (total 14 columns):\n",
      " #   Column                   Non-Null Count  Dtype \n",
      "---  ------                   --------------  ----- \n",
      " 0   cf_id                    1000 non-null   int64 \n",
      " 1   company_name             1000 non-null   object\n",
      " 2   blurb                    1000 non-null   object\n",
      " 3   goal                     1000 non-null   int64 \n",
      " 4   pledged                  1000 non-null   int64 \n",
      " 5   outcome                  1000 non-null   object\n",
      " 6   backers_count            1000 non-null   int64 \n",
      " 7   country                  1000 non-null   object\n",
      " 8   currency                 1000 non-null   object\n",
      " 9   launched_at              1000 non-null   int64 \n",
      " 10  deadline                 1000 non-null   int64 \n",
      " 11  staff_pick               1000 non-null   bool  \n",
      " 12  spotlight                1000 non-null   bool  \n",
      " 13  category & sub-category  1000 non-null   object\n",
      "dtypes: bool(2), int64(6), object(6)\n",
      "memory usage: 95.8+ KB\n"
     ]
    }
   ],
   "source": [
    "crowdfunding_info_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "c8e43e16",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1000 entries, 0 to 999\n",
      "Data columns (total 1 columns):\n",
      " #   Column        Non-Null Count  Dtype \n",
      "---  ------        --------------  ----- \n",
      " 0   contact_info  1000 non-null   object\n",
      "dtypes: object(1)\n",
      "memory usage: 7.9+ KB\n"
     ]
    }
   ],
   "source": [
    "contact_info_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "e69ffbf1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['food/food trucks', 'music/rock', 'technology/web',\n",
       "       'theater/plays', 'film & video/documentary',\n",
       "       'music/electric music', 'film & video/drama', 'music/indie rock',\n",
       "       'technology/wearables', 'publishing/nonfiction',\n",
       "       'film & video/animation', 'games/video games',\n",
       "       'film & video/shorts', 'publishing/fiction',\n",
       "       'photography/photography books', 'publishing/radio & podcasts',\n",
       "       'music/metal', 'music/jazz', 'publishing/translations',\n",
       "       'film & video/television', 'games/mobile games',\n",
       "       'music/world music', 'film & video/science fiction',\n",
       "       'journalism/audio'], dtype=object)"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get the unique values in the category & sub-category column. \n",
    "crowdfunding_info_df[\"category & sub-category\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "4321b93a",
   "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>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>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>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>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>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>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",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2057</td>\n",
       "      <td>Harris Group</td>\n",
       "      <td>Open-source optimizing database</td>\n",
       "      <td>7600</td>\n",
       "      <td>13195</td>\n",
       "      <td>successful</td>\n",
       "      <td>174</td>\n",
       "      <td>DK</td>\n",
       "      <td>DKK</td>\n",
       "      <td>1607666400</td>\n",
       "      <td>1630213200</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",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1894</td>\n",
       "      <td>Ortiz, Coleman and Mitchell</td>\n",
       "      <td>Operative upward-trending algorithm</td>\n",
       "      <td>5200</td>\n",
       "      <td>1090</td>\n",
       "      <td>failed</td>\n",
       "      <td>18</td>\n",
       "      <td>GB</td>\n",
       "      <td>GBP</td>\n",
       "      <td>1596171600</td>\n",
       "      <td>1620709200</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>film &amp; video/documentary</td>\n",
       "      <td>film &amp; video</td>\n",
       "      <td>documentary</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2669</td>\n",
       "      <td>Carter-Guzman</td>\n",
       "      <td>Centralized cohesive challenge</td>\n",
       "      <td>4500</td>\n",
       "      <td>14741</td>\n",
       "      <td>successful</td>\n",
       "      <td>227</td>\n",
       "      <td>DK</td>\n",
       "      <td>DKK</td>\n",
       "      <td>1608616800</td>\n",
       "      <td>1632200400</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",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1114</td>\n",
       "      <td>Nunez-Richards</td>\n",
       "      <td>Exclusive attitude-oriented intranet</td>\n",
       "      <td>110100</td>\n",
       "      <td>21946</td>\n",
       "      <td>live</td>\n",
       "      <td>708</td>\n",
       "      <td>DK</td>\n",
       "      <td>DKK</td>\n",
       "      <td>1586322000</td>\n",
       "      <td>1615356000</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",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>970</td>\n",
       "      <td>Rangel, Holt and Jones</td>\n",
       "      <td>Open-source fresh-thinking model</td>\n",
       "      <td>6200</td>\n",
       "      <td>3208</td>\n",
       "      <td>failed</td>\n",
       "      <td>44</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1628830800</td>\n",
       "      <td>1630386000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>music/electric music</td>\n",
       "      <td>music</td>\n",
       "      <td>electric music</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   cf_id                 company_name  \\\n",
       "0    147   Baldwin, Riley and Jackson   \n",
       "1   1621                     Odom Inc   \n",
       "2   1812   Melton, Robinson and Fritz   \n",
       "3   2156  Mcdonald, Gonzalez and Ross   \n",
       "4   1365                Larson-Little   \n",
       "5   2057                 Harris Group   \n",
       "6   1894  Ortiz, Coleman and Mitchell   \n",
       "7   2669                Carter-Guzman   \n",
       "8   1114               Nunez-Richards   \n",
       "9    970       Rangel, Holt and Jones   \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",
       "5                Open-source optimizing database    7600    13195  successful   \n",
       "6            Operative upward-trending algorithm    5200     1090      failed   \n",
       "7                 Centralized cohesive challenge    4500    14741  successful   \n",
       "8           Exclusive attitude-oriented intranet  110100    21946        live   \n",
       "9               Open-source fresh-thinking model    6200     3208      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",
       "5            174      DK      DKK   1607666400  1630213200       False   \n",
       "6             18      GB      GBP   1596171600  1620709200       False   \n",
       "7            227      DK      DKK   1608616800  1632200400       False   \n",
       "8            708      DK      DKK   1586322000  1615356000       False   \n",
       "9             44      US      USD   1628830800  1630386000       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  \n",
       "5      False             theater/plays       theater           plays  \n",
       "6      False  film & video/documentary  film & video     documentary  \n",
       "7      False             theater/plays       theater           plays  \n",
       "8      False             theater/plays       theater           plays  \n",
       "9      False      music/electric music         music  electric music  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Assign the category and subcategory values to category and subcategory columns.\n",
    "crowdfunding_info_df[[\"category\",\"subcategory\"]] = crowdfunding_info_df[\"category & sub-category\"].str.split('/', n=1, expand=True)\n",
    "crowdfunding_info_df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "2cd936ad",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "9\n",
      "24\n"
     ]
    }
   ],
   "source": [
    "# Get the distinct values in the category and subcategory columns.\n",
    "print(crowdfunding_info_df[\"category\"].nunique())\n",
    "print(crowdfunding_info_df[\"subcategory\"].nunique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "e80c9cb7",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['food' 'music' 'technology' 'theater' 'film & video' 'publishing' 'games'\n",
      " 'photography' 'journalism']\n",
      "\n",
      "['food trucks' 'rock' 'web' 'plays' 'documentary' 'electric music' 'drama'\n",
      " 'indie rock' 'wearables' 'nonfiction' 'animation' 'video games' 'shorts'\n",
      " 'fiction' 'photography books' 'radio & podcasts' 'metal' 'jazz'\n",
      " 'translations' 'television' 'mobile games' 'world music'\n",
      " 'science fiction' 'audio']\n"
     ]
    }
   ],
   "source": [
    "# Get the unique categories and subcategories in separate lists.\n",
    "categories = crowdfunding_info_df[\"category\"].unique()\n",
    "subcategories = crowdfunding_info_df[\"subcategory\"].unique()\n",
    "print(categories)\n",
    "print()\n",
    "print(subcategories)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "8ec90573",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create numpy arrays that have 1-10 for the category_ids and 1-25 for the subcategory_ids.\n",
    "category_ids = np.arange(1, 10)\n",
    "subcategory_ids = np.arange(1, 25)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "4889e300",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['cat01', 'cat02', 'cat03', 'cat04', 'cat05', 'cat06', 'cat07', 'cat08', 'cat09']\n",
      "['scat01', 'scat02', 'scat03', 'scat04', 'scat05', 'scat06', 'scat07', 'scat08', 'scat09', 'scat010', 'scat011', 'scat012', 'scat013', 'scat014', 'scat015', 'scat016', 'scat017', 'scat018', 'scat019', 'scat020', 'scat021', 'scat022', 'scat023', 'scat024']\n"
     ]
    }
   ],
   "source": [
    "# Use a list comprehension to add \"cat0\" to each category_id. \n",
    "cat_ids = [\"cat0\" + str(cat_id) for cat_id in category_ids]\n",
    "\n",
    "# Use a list comprehension to add \"scat0\" to each subcategory_id. \n",
    "scat_ids = [\"scat0\" + str(scat_id) for scat_id in subcategory_ids ]\n",
    "\n",
    "print(cat_ids)\n",
    "print(scat_ids)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "c7057082",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create a category DataFrame with the cat_ids array as the category_id and categories list as the category name.\n",
    "category_df = pd.DataFrame({\n",
    "    \"category_id\": cat_ids,\n",
    "    \"category\" : categories\n",
    "})\n",
    "\n",
    "# Create a subcategory DataFrame with the scat_ids array as the subcategory_id and subcategories list as the subcategory name.\n",
    "subcategory_df = pd.DataFrame({\n",
    "    \"subcategory_id\": scat_ids,\n",
    "    \"subcategory\" : subcategories\n",
    "})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "57541309",
   "metadata": {},
   "outputs": [],
   "source": [
    "category_df.to_csv(\"category.csv\", index=False)\n",
    "subcategory_df.to_csv(\"subcategory.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "fb2c3e5d",
   "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>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>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>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>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>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>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                 company_name  \\\n",
       "0    147   Baldwin, Riley and Jackson   \n",
       "1   1621                     Odom Inc   \n",
       "2   1812   Melton, Robinson and Fritz   \n",
       "3   2156  Mcdonald, Gonzalez and Ross   \n",
       "4   1365                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": 22,
     "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": 23,
   "id": "064a3dfb",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Rename the blurb, launched_at, and deadline columns.\n",
    "campaign_df = campaign_df.rename(columns={'blurb': 'description', 'launched_at': 'launched_date', 'deadline': 'end_date'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "bf8815a0",
   "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>company_name</th>\n",
       "      <th>description</th>\n",
       "      <th>goal</th>\n",
       "      <th>pledged</th>\n",
       "      <th>outcome</th>\n",
       "      <th>backers_count</th>\n",
       "      <th>country</th>\n",
       "      <th>currency</th>\n",
       "      <th>launched_date</th>\n",
       "      <th>end_date</th>\n",
       "      <th>staff_pick</th>\n",
       "      <th>spotlight</th>\n",
       "      <th>category &amp; sub-category</th>\n",
       "      <th>category</th>\n",
       "      <th>subcategory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>147</td>\n",
       "      <td>Baldwin, Riley and Jackson</td>\n",
       "      <td>Pre-emptive tertiary standardization</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>failed</td>\n",
       "      <td>0</td>\n",
       "      <td>CA</td>\n",
       "      <td>CAD</td>\n",
       "      <td>1581573600</td>\n",
       "      <td>1614578400</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>food/food trucks</td>\n",
       "      <td>food</td>\n",
       "      <td>food trucks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1621</td>\n",
       "      <td>Odom Inc</td>\n",
       "      <td>Managed bottom-line architecture</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>14560.0</td>\n",
       "      <td>successful</td>\n",
       "      <td>158</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1611554400</td>\n",
       "      <td>1621918800</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>music/rock</td>\n",
       "      <td>music</td>\n",
       "      <td>rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1812</td>\n",
       "      <td>Melton, Robinson and Fritz</td>\n",
       "      <td>Function-based leadingedge pricing structure</td>\n",
       "      <td>108400.0</td>\n",
       "      <td>142523.0</td>\n",
       "      <td>successful</td>\n",
       "      <td>1425</td>\n",
       "      <td>AU</td>\n",
       "      <td>AUD</td>\n",
       "      <td>1608184800</td>\n",
       "      <td>1640844000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>technology/web</td>\n",
       "      <td>technology</td>\n",
       "      <td>web</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2156</td>\n",
       "      <td>Mcdonald, Gonzalez and Ross</td>\n",
       "      <td>Vision-oriented fresh-thinking conglomeration</td>\n",
       "      <td>4200.0</td>\n",
       "      <td>2477.0</td>\n",
       "      <td>failed</td>\n",
       "      <td>24</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1634792400</td>\n",
       "      <td>1642399200</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>music/rock</td>\n",
       "      <td>music</td>\n",
       "      <td>rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1365</td>\n",
       "      <td>Larson-Little</td>\n",
       "      <td>Proactive foreground core</td>\n",
       "      <td>7600.0</td>\n",
       "      <td>5265.0</td>\n",
       "      <td>failed</td>\n",
       "      <td>53</td>\n",
       "      <td>US</td>\n",
       "      <td>USD</td>\n",
       "      <td>1608530400</td>\n",
       "      <td>1629694800</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>theater/plays</td>\n",
       "      <td>theater</td>\n",
       "      <td>plays</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   cf_id                 company_name  \\\n",
       "0    147   Baldwin, Riley and Jackson   \n",
       "1   1621                     Odom Inc   \n",
       "2   1812   Melton, Robinson and Fritz   \n",
       "3   2156  Mcdonald, Gonzalez and Ross   \n",
       "4   1365                Larson-Little   \n",
       "\n",
       "                                     description      goal   pledged  \\\n",
       "0           Pre-emptive tertiary standardization     100.0       0.0   \n",
       "1               Managed bottom-line architecture    1400.0   14560.0   \n",
       "2   Function-based leadingedge pricing structure  108400.0  142523.0   \n",
       "3  Vision-oriented fresh-thinking conglomeration    4200.0    2477.0   \n",
       "4                      Proactive foreground core    7600.0    5265.0   \n",
       "\n",
       "      outcome  backers_count country currency  launched_date    end_date  \\\n",
       "0      failed              0      CA      CAD     1581573600  1614578400   \n",
       "1  successful            158      US      USD     1611554400  1621918800   \n",
       "2  successful           1425      AU      AUD     1608184800  1640844000   \n",
       "3      failed             24      US      USD     1634792400  1642399200   \n",
       "4      failed             53      US      USD     1608530400  1629694800   \n",
       "\n",
       "   staff_pick  spotlight category & sub-category    category  subcategory  \n",
       "0       False      False        food/food trucks        food  food trucks  \n",
       "1       False       True              music/rock       music         rock  \n",
       "2       False      False          technology/web  technology          web  \n",
       "3       False      False              music/rock       music         rock  \n",
       "4       False      False           theater/plays     theater        plays  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Convert the goal and pledged columns to a `float` data type.\n",
    "campaign_df[[\"goal\",\"pledged\"]] = campaign_df[[\"goal\",\"pledged\"]].astype(float)\n",
    "campaign_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "aa1d50b8",
   "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>company_name</th>\n",
       "      <th>description</th>\n",
       "      <th>goal</th>\n",
       "      <th>pledged</th>\n",
       "      <th>outcome</th>\n",
       "      <th>backers_count</th>\n",
       "      <th>country</th>\n",
       "      <th>currency</th>\n",
       "      <th>launched_date</th>\n",
       "      <th>end_date</th>\n",
       "      <th>staff_pick</th>\n",
       "      <th>spotlight</th>\n",
       "      <th>category &amp; sub-category</th>\n",
       "      <th>category</th>\n",
       "      <th>subcategory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>147</td>\n",
       "      <td>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>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>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>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>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                 company_name  \\\n",
       "0    147   Baldwin, Riley and Jackson   \n",
       "1   1621                     Odom Inc   \n",
       "2   1812   Melton, Robinson and Fritz   \n",
       "3   2156  Mcdonald, Gonzalez and Ross   \n",
       "4   1365                Larson-Little   \n",
       "\n",
       "                                     description      goal   pledged  \\\n",
       "0           Pre-emptive tertiary standardization     100.0       0.0   \n",
       "1               Managed bottom-line architecture    1400.0   14560.0   \n",
       "2   Function-based leadingedge pricing structure  108400.0  142523.0   \n",
       "3  Vision-oriented fresh-thinking conglomeration    4200.0    2477.0   \n",
       "4                      Proactive foreground core    7600.0    5265.0   \n",
       "\n",
       "      outcome  backers_count country currency launched_date    end_date  \\\n",
       "0      failed              0      CA      CAD    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": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Format the launched_date and end_date columns to datetime format.\n",
    "from datetime import datetime as dt\n",
    "campaign_df[\"launched_date\"] = pd.to_datetime(campaign_df[\"launched_date\"], 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",
    "campaign_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "0887b223",
   "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>company_name</th>\n",
       "      <th>description</th>\n",
       "      <th>goal</th>\n",
       "      <th>pledged</th>\n",
       "      <th>outcome</th>\n",
       "      <th>backers_count</th>\n",
       "      <th>country</th>\n",
       "      <th>currency</th>\n",
       "      <th>launched_date</th>\n",
       "      <th>end_date</th>\n",
       "      <th>staff_pick</th>\n",
       "      <th>spotlight</th>\n",
       "      <th>category &amp; sub-category</th>\n",
       "      <th>category</th>\n",
       "      <th>subcategory</th>\n",
       "      <th>category_id</th>\n",
       "      <th>subcategory_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>990</th>\n",
       "      <td>1561</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>cat05</td>\n",
       "      <td>scat07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>991</th>\n",
       "      <td>2632</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>cat02</td>\n",
       "      <td>scat02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>992</th>\n",
       "      <td>439</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>cat05</td>\n",
       "      <td>scat07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993</th>\n",
       "      <td>461</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>cat08</td>\n",
       "      <td>scat015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>994</th>\n",
       "      <td>1419</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>cat06</td>\n",
       "      <td>scat019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>2986</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>cat01</td>\n",
       "      <td>scat01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>2031</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>cat04</td>\n",
       "      <td>scat04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>1627</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>cat04</td>\n",
       "      <td>scat04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>2175</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>cat02</td>\n",
       "      <td>scat08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>1788</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>cat01</td>\n",
       "      <td>scat01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     cf_id                  company_name  \\\n",
       "990   1561                 Ortiz-Roberts   \n",
       "991   2632                   Ramirez LLC   \n",
       "992    439                    Morrow Inc   \n",
       "993    461               Erickson-Rogers   \n",
       "994   1419         Leach, Rich and Price   \n",
       "995   2986              Manning-Hamilton   \n",
       "996   2031                    Butler LLC   \n",
       "997   1627                      Ball LLC   \n",
       "998   2175   Taylor, Santiago and Flores   \n",
       "999   1788  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 launched_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       cat05         scat07  \n",
       "991               rock       cat02         scat02  \n",
       "992              drama       cat05         scat07  \n",
       "993  photography books       cat08        scat015  \n",
       "994       translations       cat06        scat019  \n",
       "995        food trucks       cat01         scat01  \n",
       "996              plays       cat04         scat04  \n",
       "997              plays       cat04         scat04  \n",
       "998         indie rock       cat02         scat08  \n",
       "999        food trucks       cat01         scat01  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Merge the campaign_df with the category_df on the \"category\" column and \n",
    "# the subcategory_df on the \"subcategory\" column.\n",
    "campaign_merged_df = campaign_df.merge(category_df, on='category', how='left').merge(subcategory_df, on='subcategory', how='left')\n",
    "campaign_merged_df.tail(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "06f2cfb8",
   "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>company_name</th>\n",
       "      <th>description</th>\n",
       "      <th>goal</th>\n",
       "      <th>pledged</th>\n",
       "      <th>outcome</th>\n",
       "      <th>backers_count</th>\n",
       "      <th>country</th>\n",
       "      <th>currency</th>\n",
       "      <th>launched_date</th>\n",
       "      <th>end_date</th>\n",
       "      <th>category_id</th>\n",
       "      <th>subcategory_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>147</td>\n",
       "      <td>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>cat01</td>\n",
       "      <td>scat01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1621</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>cat02</td>\n",
       "      <td>scat02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1812</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>cat03</td>\n",
       "      <td>scat03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2156</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>cat02</td>\n",
       "      <td>scat02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1365</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>cat04</td>\n",
       "      <td>scat04</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   cf_id                 company_name  \\\n",
       "0    147   Baldwin, Riley and Jackson   \n",
       "1   1621                     Odom Inc   \n",
       "2   1812   Melton, Robinson and Fritz   \n",
       "3   2156  Mcdonald, Gonzalez and Ross   \n",
       "4   1365                Larson-Little   \n",
       "\n",
       "                                     description      goal   pledged  \\\n",
       "0           Pre-emptive tertiary standardization     100.0       0.0   \n",
       "1               Managed bottom-line architecture    1400.0   14560.0   \n",
       "2   Function-based leadingedge pricing structure  108400.0  142523.0   \n",
       "3  Vision-oriented fresh-thinking conglomeration    4200.0    2477.0   \n",
       "4                      Proactive foreground core    7600.0    5265.0   \n",
       "\n",
       "      outcome  backers_count country currency launched_date    end_date  \\\n",
       "0      failed              0      CA      CAD    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       cat01         scat01  \n",
       "1       cat02         scat02  \n",
       "2       cat03         scat03  \n",
       "3       cat02         scat02  \n",
       "4       cat04         scat04  "
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Drop unwanted columns.\n",
    "campaign_cleaned = campaign_merged_df.drop(['staff_pick', 'spotlight', 'category & sub-category','category', 'subcategory'], axis=1)\n",
    "campaign_cleaned.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "1cb81c01",
   "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": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Show the contact_info_df DataFrame.\n",
    "contact_info_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "66adda85",
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "# Retrieve the data from the \"contact_info\" column.\n",
    "contact_info_list = contact_info_df.contact_info.to_list()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "94155f2c",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{\"contact_id\": \n",
      "4661\n"
     ]
    }
   ],
   "source": [
    "# Pop out the unique identification number using list slicing. \n",
    "print(contact_info_list[0][:15])\n",
    "print(contact_info_list[0][15:19])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "096086e8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['4661', '3765', '4187', '4941', '2199', '5650', '5889', '4842', '3280', '5468', '3064', '4904', '1299', '5602', '5753', '4495', '4269', '2226', '1558', '2307', '2900', '5695', '5708', '1663', '3605', '4678', '2251', '6202', '3715', '4242', '4326', '5560', '4002', '3813', '5336', '4994', '1471', '4482', '3241', '3477', '2265', '5911', '2288', '4064', '1294', '5008', '3604', '3263', '5631', '2851', '3714', '1664', '5027', '3070', '4248', '2034', '4085', '3569', '3889', '3136', '2103', '2329', '3325', '3131', '4995', '3631', '5373', '3126', '2194', '2906', '2611', '2374', '3254', '3571', '2812', '3961', '3872', '4736', '5119', '5725', '4037', '2109', '3283', '6181', '3251', '3443', '2988', '1673', '2085', '1672', '4426', '3211', '3190', '2081', '3185', '5044', '1883', '2067', '4604', '3203', '5758', '5755', '5150', '4181', '3006', '4865', '2862', '6070', '5300', '3486', '5989', '2849', '1612', '3307', '5288', '6026', '2212', '4591', '2771', '5682', '5368', '3706', '4034', '3209', '2384', '3074', '2031', '5873', '5501', '3489', '4210', '6151', '6047', '5445', '5493', '6036', '2368', '1501', '4351', '3096', '6162', '1433', '2720', '5251', '1797', '1656', '1346', '2989', '5629', '3456', '3229', '2277', '1276', '3694', '2260', '5374', '4420', '3849', '1638', '5230', '1763', '4323', '5256', '4836', '5981', '1463', '4577', '4951', '3567', '5475', '2114', '5216', '1665', '6051', '3983', '2966', '4478', '4238', '4404', '5666', '3691', '2703', '4253', '5652', '3279', '3233', '3017', '3482', '2166', '4146', '2651', '1409', '3717', '3963', '2152', '2974', '1268', '1822', '5066', '5075', '3855', '5923', '1867', '4376', '2785', '5884', '2441', '1243', '3411', '2467', '1850', '2604', '1693', '2969', '1544', '4149', '3463', '2939', '2202', '1728', '5362', '4840', '2955', '5354', '3847', '3025', '1615', '5154', '5005', '1349', '3670', '2912', '4336', '5576', '2736', '3321', '3353', '2336', '4369', '4464', '5626', '1669', '5544', '6078', '2580', '3592', '4914', '3848', '2619', '4605', '6147', '1383', '1757', '4390', '4165', '4529', '6084', '2916', '2005', '2261', '5342', '4087', '2761', '2908', '2155', '5642', '6217', '4222', '4798', '5660', '5000', '2809', '3349', '3647', '5745', '2583', '5441', '2090', '3386', '1816', '4718', '1677', '4218', '4548', '1431', '2830', '4400', '5773', '4161', '2062', '3458', '3174', '5565', '1906', '5479', '4320', '4213', '3373', '4184', '5472', '5559', '5419', '4171', '1302', '3520', '6010', '4617', '1417', '4770', '4328', '5171', '4394', '1794', '3510', '2487', '2215', '4136', '3723', '5842', '3289', '1249', '5409', '2951', '3432', '2297', '6161', '4603', '5818', '4270', '6007', '4084', '1340', '5675', '2010', '6201', '1791', '3314', '5852', '4618', '2618', '4967', '4594', '2080', '2793', '4890', '3528', '5810', '5720', '4593', '3186', '5136', '2646', '3460', '4345', '2690', '4025', '4524', '3978', '3910', '5825', '3564', '2396', '2140', '3079', '2017', '5444', '2216', '1241', '1484', '3475', '4333', '5657', '2527', '5967', '5698', '3331', '3841', '6105', '3895', '1891', '1281', '4186', '2511', '4272', '3533', '3618', '2177', '4102', '6089', '4701', '5645', '4499', '3365', '2290', '1890', '1304', '3799', '2749', '2028', '2383', '5721', '1394', '3451', '5512', '2453', '6055', '5704', '3707', '2205', '5976', '3290', '4257', '4588', '4785', '3033', '2779', '2131', '6229', '3429', '1613', '4734', '4439', '1441', '5799', '1419', '3059', '3224', '3181', '6061', '4466', '6081', '2159', '3324', '3176', '5874', '5110', '5490', '1922', '4398', '4754', '3309', '1244', '2892', '2777', '4952', '5144', '5487', '1932', '3364', '5165', '3858', '4666', '2896', '4520', '5726', '5661', '4765', '3710', '4925', '1533', '5264', '4606', '2043', '3871', '6205', '3193', '1810', '4797', '1487', '3474', '5771', '6074', '1568', '4263', '5850', '5619', '1904', '5388', '2150', '2653', '2687', '3779', '1494', '4129', '3035', '2069', '5469', '3903', '4083', '4003', '3565', '1640', '4769', '3398', '1865', '5690', '3814', '2942', '5095', '2878', '3697', '4744', '2104', '4883', '4807', '1372', '3666', '2066', '1834', '5853', '2219', '4148', '4477', '1786', '3455', '5707', '5470', '3274', '4613', '4465', '1652', '2100', '4321', '4168', '3733', '2594', '3909', '5179', '2228', '6222', '2354', '1725', '2960', '2077', '5662', '3481', '2565', '4436', '5072', '5200', '4502', '4945', '3012', '6094', '3815', '4838', '3469', '4874', '1792', '4356', '6196', '3578', '4491', '3054', '1968', '5869', '5858', '5203', '2577', '3216', '2037', '3867', '5109', '1376', '5260', '2350', '2269', '3650', '3934', '4048', '4266', '3863', '4922', '4517', '3259', '3123', '3870', '2996', '2993', '4556', '2326', '4109', '5739', '5887', '1651', '1628', '2642', '6020', '4747', '5534', '4790', '4632', '1952', '4388', '5529', '1316', '1670', '4909', '3401', '4619', '4722', '2188', '5497', '5711', '4076', '1847', '2816', '5019', '4869', '3613', '3069', '2601', '2133', '3164', '3897', '5663', '3879', '5900', '2272', '5436', '3676', '4676', '1563', '4349', '1658', '2552', '4847', '1553', '2632', '1908', '5801', '1935', '2609', '2740', '1907', '1831', '5177', '6179', '2917', '1486', '3735', '3838', '2430', '2480', '3431', '1742', '4628', '2385', '2213', '5188', '3418', '5637', '3530', '3731', '3219', '2392', '5103', '3992', '2442', '2913', '1631', '4073', '4568', '1830', '2623', '4327', '3713', '2389', '5141', '3522', '1334', '4721', '3768', '1639', '5149', '2153', '2767', '5124', '2097', '4796', '5849', '1495', '2462', '2280', '1877', '6108', '4427', '2881', '2339', '5156', '4750', '4852', '5734', '3801', '4474', '1992', '5796', '1373', '1879', '3072', '4561', '5201', '5871', '3041', '5864', '3999', '4849', '5461', '5946', '4508', '5096', '5443', '2165', '2125', '6141', '5245', '2190', '2243', '3336', '3305', '6191', '1326', '6159', '2003', '5881', '1918', '2157', '3149', '2444', '6207', '5580', '5942', '1592', '2344', '5995', '5022', '5991', '4020', '6028', '2790', '4033', '1261', '1979', '2122', '4506', '3016', '3272', '1375', '4014', '3199', '2184', '2170', '1478', '6163', '1889', '5912', '2537', '2118', '3234', '3842', '3032', '3238', '2059', '5238', '2578', '4789', '2357', '1235', '3558', '1707', '2842', '5318', '1620', '4998', '3111', '1424', '3244', '4643', '6132', '3790', '1312', '5686', '2111', '5685', '1905', '3271', '4178', '3275', '5713', '3339', '5585', '4407', '1941', '4690', '3607', '2670', '5261', '4121', '4620', '4630', '3440', '3572', '5306', '5122', '1368', '5370', '5636', '6033', '3599', '5566', '1873', '3904', '4453', '5481', '2987', '2431', '4158', '3753', '4391', '2026', '4547', '2798', '4732', '5126', '5151', '2134', '5786', '5515', '4530', '4088', '3667', '3286', '4804', '5768', '6098', '2508', '5779', '1717', '3368', '4265', '4455', '2940', '6144', '3657', '1537', '2116', '5102', '5815', '4250', '4533', '3329', '3606', '4749', '2222', '1939', '2456', '2794', '2648', '2545', '3273', '6155', '6064', '1729', '4969', '3402', '2810', '2217', '5140', '4497', '5100', '3390', '1926', '3264', '2573', '3628', '3826', '5983', '5678', '2093', '5333', '5139', '3173', '3333', '2262', '1531', '4881', '3928', '1803', '2321', '6234', '1422', '2660', '5361', '3420', '4337', '2338', '4140', '2373', '1344', '2141', '3415', '5696', '1798', '1657', '3651', '3574', '6063', '2404', '2705', '5059', '5466', '5821', '5385', '3506', '5427', '6142', '2873', '3916', '1687', '1542', '3087', '3857', '5921', '3144', '2676', '3646', '1321', '1399', '3169', '2058', '1300', '2075', '2984', '4768', '3682', '5901', '3540', '2225', '1485', '5343', '5594', '2482', '2706', '4861', '2961', '3043', '6103', '4708', '4395', '4912', '2030', '5235', '5001', '4093', '2576', '6122', '2813', '3737', '2803', '5508', '3850', '4220', '4532', '6013', '3396', '4401', '2981', '4467', '1377', '5036', '5761', '3699', '4519', '5395', '3057', '2741', '1675', '2712', '4527', '1722', '4330', '5219', '4997', '2239', '4587', '4113', '4762', '5242', '5765', '2185', '5500', '3494', '3924', '3521', '5262', '3684', '5784', '1498', '6073', '4939']\n"
     ]
    }
   ],
   "source": [
    "# Pop out the unique identification number using list comprehension and slicing. \n",
    "print([x[15:19] for x in contact_info_list])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "76e25667",
   "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>company_name</th>\n",
       "      <th>description</th>\n",
       "      <th>goal</th>\n",
       "      <th>pledged</th>\n",
       "      <th>outcome</th>\n",
       "      <th>backers_count</th>\n",
       "      <th>country</th>\n",
       "      <th>currency</th>\n",
       "      <th>launched_date</th>\n",
       "      <th>end_date</th>\n",
       "      <th>category_id</th>\n",
       "      <th>subcategory_id</th>\n",
       "      <th>contact_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>147</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>cat01</td>\n",
       "      <td>scat01</td>\n",
       "      <td>4661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1621</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>cat02</td>\n",
       "      <td>scat02</td>\n",
       "      <td>3765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1812</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>cat03</td>\n",
       "      <td>scat03</td>\n",
       "      <td>4187</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2156</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>cat02</td>\n",
       "      <td>scat02</td>\n",
       "      <td>4941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1365</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>cat04</td>\n",
       "      <td>scat04</td>\n",
       "      <td>2199</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   cf_id                 company_name  \\\n",
       "0    147   Baldwin, Riley and Jackson   \n",
       "1   1621                     Odom Inc   \n",
       "2   1812   Melton, Robinson and Fritz   \n",
       "3   2156  Mcdonald, Gonzalez and Ross   \n",
       "4   1365                Larson-Little   \n",
       "\n",
       "                                     description      goal   pledged  \\\n",
       "0           Pre-emptive tertiary standardization     100.0       0.0   \n",
       "1               Managed bottom-line architecture    1400.0   14560.0   \n",
       "2   Function-based leadingedge pricing structure  108400.0  142523.0   \n",
       "3  Vision-oriented fresh-thinking conglomeration    4200.0    2477.0   \n",
       "4                      Proactive foreground core    7600.0    5265.0   \n",
       "\n",
       "      outcome  backers_count country currency launched_date    end_date  \\\n",
       "0      failed              0      CA      CAD    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 contact_id  \n",
       "0       cat01         scat01       4661  \n",
       "1       cat02         scat02       3765  \n",
       "2       cat03         scat03       4187  \n",
       "3       cat02         scat02       4941  \n",
       "4       cat04         scat04       2199  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Extract the four-digit contact ID number and add it to a new column in the `campaign_cleaned` DataFrame.\n",
    "campaign_cleaned[\"contact_id\"] = [x[15:19] for x in contact_info_df[\"contact_info\"].values]\n",
    "campaign_cleaned.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "e8b1e517",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 1000 entries, 0 to 999\n",
      "Data columns (total 14 columns):\n",
      " #   Column          Non-Null Count  Dtype  \n",
      "---  ------          --------------  -----  \n",
      " 0   cf_id           1000 non-null   int64  \n",
      " 1   company_name    1000 non-null   object \n",
      " 2   description     1000 non-null   object \n",
      " 3   goal            1000 non-null   float64\n",
      " 4   pledged         1000 non-null   float64\n",
      " 5   outcome         1000 non-null   object \n",
      " 6   backers_count   1000 non-null   int64  \n",
      " 7   country         1000 non-null   object \n",
      " 8   currency        1000 non-null   object \n",
      " 9   launched_date   1000 non-null   object \n",
      " 10  end_date        1000 non-null   object \n",
      " 11  category_id     1000 non-null   object \n",
      " 12  subcategory_id  1000 non-null   object \n",
      " 13  contact_id      1000 non-null   object \n",
      "dtypes: float64(2), int64(2), object(10)\n",
      "memory usage: 117.2+ KB\n"
     ]
    }
   ],
   "source": [
    "campaign_cleaned.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "e5402a2e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 1000 entries, 0 to 999\n",
      "Data columns (total 14 columns):\n",
      " #   Column          Non-Null Count  Dtype  \n",
      "---  ------          --------------  -----  \n",
      " 0   cf_id           1000 non-null   int64  \n",
      " 1   company_name    1000 non-null   object \n",
      " 2   description     1000 non-null   object \n",
      " 3   goal            1000 non-null   float64\n",
      " 4   pledged         1000 non-null   float64\n",
      " 5   outcome         1000 non-null   object \n",
      " 6   backers_count   1000 non-null   int64  \n",
      " 7   country         1000 non-null   object \n",
      " 8   currency        1000 non-null   object \n",
      " 9   launched_date   1000 non-null   object \n",
      " 10  end_date        1000 non-null   object \n",
      " 11  category_id     1000 non-null   object \n",
      " 12  subcategory_id  1000 non-null   object \n",
      " 13  contact_id      1000 non-null   int64  \n",
      "dtypes: float64(2), int64(3), object(9)\n",
      "memory usage: 117.2+ KB\n"
     ]
    }
   ],
   "source": [
    "# Convert the \"contact_id\" column to an int64 data type.\n",
    "campaign_cleaned['contact_id'] = pd.to_numeric(campaign_cleaned['contact_id'])\n",
    "campaign_cleaned.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "22a25894",
   "metadata": {},
   "outputs": [],
   "source": [
    "#\"cf_id\", \"contact_id\", \"company_name\", \"description\", \"goal\", \"pledged\", \"outcome\", \n",
    "#\"backers_count\", \"country\", \"currency\", \"launched_date\", \"end_date\", \"category_id\",\"subcategory_id\"\n",
    "campaign_cleaned_reorder = campaign_cleaned.reindex(columns=[\"cf_id\", \"contact_id\", \"company_name\", \"description\", \"goal\", \n",
    "\"pledged\", \"outcome\", \"backers_count\", \"country\", \"currency\", \"launched_date\", \"end_date\", \"category_id\",\"subcategory_id\"])\n",
    "campaign_cleaned_reorder.to_csv(\"campaign.csv\", encoding='utf8', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "72de7f5a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>cf_id</th>\n",
       "      <th>contact_id</th>\n",
       "      <th>company_name</th>\n",
       "      <th>description</th>\n",
       "      <th>goal</th>\n",
       "      <th>pledged</th>\n",
       "      <th>outcome</th>\n",
       "      <th>backers_count</th>\n",
       "      <th>country</th>\n",
       "      <th>currency</th>\n",
       "      <th>launched_date</th>\n",
       "      <th>end_date</th>\n",
       "      <th>category_id</th>\n",
       "      <th>subcategory_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>147</td>\n",
       "      <td>4661</td>\n",
       "      <td>Baldwin, Riley and Jackson</td>\n",
       "      <td>Pre-emptive tertiary standardization</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>failed</td>\n",
       "      <td>0</td>\n",
       "      <td>CA</td>\n",
       "      <td>CAD</td>\n",
       "      <td>2020-02-13</td>\n",
       "      <td>2021-03-01</td>\n",
       "      <td>cat01</td>\n",
       "      <td>scat01</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>cat02</td>\n",
       "      <td>scat02</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>cat03</td>\n",
       "      <td>scat03</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>cat02</td>\n",
       "      <td>scat02</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>cat04</td>\n",
       "      <td>scat04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</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>cat01</td>\n",
       "      <td>scat01</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>cat04</td>\n",
       "      <td>scat04</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>cat04</td>\n",
       "      <td>scat04</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>cat02</td>\n",
       "      <td>scat08</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>cat01</td>\n",
       "      <td>scat01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 14 columns</p>\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",
       "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  \\\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",
       "995            Vision-oriented scalable definition   97300.0  153216.0   \n",
       "996       Future-proofed upward-trending migration    6600.0    4814.0   \n",
       "997              Right-sized full-range throughput    7600.0    4603.0   \n",
       "998           Polarized composite customer loyalty   66600.0   37823.0   \n",
       "999                    Expanded eco-centric policy  111100.0   62819.0   \n",
       "\n",
       "        outcome  backers_count country currency launched_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",
       "995  successful           2043      US      USD    2020-12-29  2021-05-30   \n",
       "996      failed            112      US      USD    2021-10-15  2021-11-30   \n",
       "997    canceled            139      IT      EUR    2021-11-06  2021-12-10   \n",
       "998      failed            374      US      USD    2020-10-08  2021-04-11   \n",
       "999    canceled           1122      US      USD    2020-12-30  2021-08-18   \n",
       "\n",
       "    category_id subcategory_id  \n",
       "0         cat01         scat01  \n",
       "1         cat02         scat02  \n",
       "2         cat03         scat03  \n",
       "3         cat02         scat02  \n",
       "4         cat04         scat04  \n",
       "..          ...            ...  \n",
       "995       cat01         scat01  \n",
       "996       cat04         scat04  \n",
       "997       cat04         scat04  \n",
       "998       cat02         scat08  \n",
       "999       cat01         scat01  \n",
       "\n",
       "[1000 rows x 14 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "campaign_cleaned_reorder"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "587329af",
   "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",
       "  </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",
       "\n",
       "  contact_id  \n",
       "0       4661  \n",
       "1       3765  \n",
       "2       4187  \n",
       "3       4941  \n",
       "4       2199  "
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Extract the four-digit contact ID number and add it to a new column in the contact_info DataFrame.\n",
    "contact_info_df[\"contact_id\"] = [x[15:19] for x in contact_info_df[\"contact_info\"].values]\n",
    "contact_info_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "672206cf",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "contact_id 4661\n",
      "name Cecilia Velasco\n",
      "email cecilia.velasco@rodrigues.fr\n"
     ]
    }
   ],
   "source": [
    "# Get the data from the first row and convert it to a dictionary.\n",
    "first_row = contact_info_df.iloc[0]['contact_info']\n",
    "converted_data = json.loads(first_row)\n",
    "for k, v in converted_data.items():\n",
    "    print(k,v)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "4d21a8f9",
   "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",
    "dict_values = []\n",
    "for i, row in contact_info_df.iterrows():\n",
    "    # Get the data first item in each row.\n",
    "    data = row['contact_info']\n",
    "    converted_data = json.loads(data)\n",
    "    # Iterate through each dictionary (row) and get the values for each row using list comprehension.\n",
    "    row_values = [v for k, v in converted_data.items()]\n",
    "    # Append the list of values for each row to a new list. \n",
    "    dict_values.append(row_values)\n",
    "\n",
    "# Print out the list of values for each row.\n",
    "print(dict_values)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "d2e16a74",
   "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": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create a contact_info DataFrame and add each list of values, i.e., each row to the 'contact_id', 'name', 'email' columns.\n",
    "contacts_df = pd.DataFrame(dict_values, columns=['contact_id', 'name', 'email'])\n",
    "contacts_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "310bf56d",
   "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": [
    "contacts_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "fa8a0e1c",
   "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": 43,
     "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",
    "contacts_df[[\"first_name\",\"last_name\"]] = contacts_df[\"name\"].str.split(' ', n=1, expand=True)\n",
    "\n",
    "# Drop the name column. \n",
    "contacts_df_clean = contacts_df.drop(['name'], axis=1)\n",
    "contacts_df_clean.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "60fc71da",
   "metadata": {},
   "outputs": [],
   "source": [
    "#\"contact_id\", \"first_name\", \"last_name\", \"email\"\n",
    "contacts_df_reorder = contacts_df_clean.reindex(columns=[\"contact_id\", \"first_name\", \"last_name\", \"email\"])\n",
    "contacts_df_reorder.to_csv(\"contacts.csv\", encoding='utf8', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "31cd9309",
   "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>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>3684</td>\n",
       "      <td>Whitney</td>\n",
       "      <td>Noack</td>\n",
       "      <td>whitney.noack@laboratorios.org</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>5784</td>\n",
       "      <td>Gelsomina</td>\n",
       "      <td>Migliaccio</td>\n",
       "      <td>gelsomina.migliaccio@junk.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>1498</td>\n",
       "      <td>Evangelista</td>\n",
       "      <td>Pereira</td>\n",
       "      <td>evangelista.pereira@thompson-peterson.biz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>6073</td>\n",
       "      <td>Gareth</td>\n",
       "      <td>Comolli</td>\n",
       "      <td>gareth.comolli@tiscali.fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>4939</td>\n",
       "      <td>Michelangelo</td>\n",
       "      <td>Hess</td>\n",
       "      <td>michelangelo.hess@bouygtel.fr</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     contact_id    first_name   last_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",
       "..          ...           ...         ...   \n",
       "995        3684       Whitney       Noack   \n",
       "996        5784     Gelsomina  Migliaccio   \n",
       "997        1498   Evangelista     Pereira   \n",
       "998        6073        Gareth     Comolli   \n",
       "999        4939  Michelangelo        Hess   \n",
       "\n",
       "                                         email  \n",
       "0                 cecilia.velasco@rodrigues.fr  \n",
       "1                      mariana.ellis@rossi.org  \n",
       "2                      sofie.woods@riviere.com  \n",
       "3                  jeanette.iannotti@yahoo.com  \n",
       "4                     samuel.sorgatz@gmail.com  \n",
       "..                                         ...  \n",
       "995             whitney.noack@laboratorios.org  \n",
       "996              gelsomina.migliaccio@junk.com  \n",
       "997  evangelista.pereira@thompson-peterson.biz  \n",
       "998                  gareth.comolli@tiscali.fr  \n",
       "999              michelangelo.hess@bouygtel.fr  \n",
       "\n",
       "[1000 rows x 4 columns]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "contacts_df_reorder"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "00870854",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "PythonData",
   "language": "python",
   "name": "pythondata"
  },
  "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.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}