s2n09-challenge3-verified-email-list.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Optional Challenge - Verified Email List\n",
    "\n",
    "We want you to produce a new DataFrame that contains the only following columns:\n",
    "* first_name\n",
    "* last_name\n",
    "* email\n",
    "\n",
    "Ensure that all first names are title cased. Do not include any records that have a missing last name, and make sure that their email is verified (**`email_verified`** should be set True).  Sort by last name and then by first.\n",
    "\n",
    "Once you have completed the TODOs, choose the `Run Tests` button.\n",
    "\n",
    "*Need a little extra help? Check out the [Treehouse Forum](https://teamtreehouse.com/community?instruction=4573).*\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Setup\n",
    "import os\n",
    "\n",
    "import pandas as pd\n",
    "\n",
    "from utils import make_chaos\n",
    "\n",
    "from tests.helpers import check\n",
    "\n",
    "pd.options.display.max_rows = 10\n",
    "users = pd.read_csv(os.path.join('data', 'users.csv'), index_col=0)\n",
    "# Pay no attention to the person behind the curtain\n",
    "make_chaos(users, 19, ['first_name'], lambda val: val.lower())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>first_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>email</th>\n",
       "      <th>email_verified</th>\n",
       "      <th>signup_date</th>\n",
       "      <th>referral_count</th>\n",
       "      <th>balance</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>aaron</th>\n",
       "      <td>Aaron</td>\n",
       "      <td>Davis</td>\n",
       "      <td>aaron6348@gmail.com</td>\n",
       "      <td>True</td>\n",
       "      <td>2018-08-31</td>\n",
       "      <td>6.0</td>\n",
       "      <td>18.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>acook</th>\n",
       "      <td>Anthony</td>\n",
       "      <td>Cook</td>\n",
       "      <td>cook@gmail.com</td>\n",
       "      <td>True</td>\n",
       "      <td>2018-05-12</td>\n",
       "      <td>2.0</td>\n",
       "      <td>55.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>adam.saunders</th>\n",
       "      <td>Adam</td>\n",
       "      <td>Saunders</td>\n",
       "      <td>adam@gmail.com</td>\n",
       "      <td>False</td>\n",
       "      <td>2018-05-29</td>\n",
       "      <td>3.0</td>\n",
       "      <td>72.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>adrian</th>\n",
       "      <td>Adrian</td>\n",
       "      <td>Fang</td>\n",
       "      <td>adrian.fang@teamtreehouse.com</td>\n",
       "      <td>True</td>\n",
       "      <td>2018-04-28</td>\n",
       "      <td>3.0</td>\n",
       "      <td>30.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>adrian.blair</th>\n",
       "      <td>Adrian</td>\n",
       "      <td>Blair</td>\n",
       "      <td>adrian9335@gmail.com</td>\n",
       "      <td>True</td>\n",
       "      <td>2018-06-16</td>\n",
       "      <td>7.0</td>\n",
       "      <td>25.85</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>wilson</th>\n",
       "      <td>Robert</td>\n",
       "      <td>Wilson</td>\n",
       "      <td>robert@yahoo.com</td>\n",
       "      <td>False</td>\n",
       "      <td>2018-05-16</td>\n",
       "      <td>5.0</td>\n",
       "      <td>59.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>wking</th>\n",
       "      <td>Wanda</td>\n",
       "      <td>King</td>\n",
       "      <td>wanda.king@holt.com</td>\n",
       "      <td>True</td>\n",
       "      <td>2018-06-01</td>\n",
       "      <td>2.0</td>\n",
       "      <td>67.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>wright3590</th>\n",
       "      <td>Jacqueline</td>\n",
       "      <td>Wright</td>\n",
       "      <td>jacqueline.wright@gonzalez.com</td>\n",
       "      <td>True</td>\n",
       "      <td>2018-02-08</td>\n",
       "      <td>6.0</td>\n",
       "      <td>18.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>young</th>\n",
       "      <td>Jessica</td>\n",
       "      <td>Young</td>\n",
       "      <td>jessica4028@yahoo.com</td>\n",
       "      <td>True</td>\n",
       "      <td>2018-07-17</td>\n",
       "      <td>4.0</td>\n",
       "      <td>75.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zachary.neal</th>\n",
       "      <td>Zachary</td>\n",
       "      <td>Neal</td>\n",
       "      <td>zneal@gmail.com</td>\n",
       "      <td>True</td>\n",
       "      <td>2018-07-26</td>\n",
       "      <td>1.0</td>\n",
       "      <td>39.90</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>475 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               first_name last_name                           email  \\\n",
       "aaron               Aaron     Davis             aaron6348@gmail.com   \n",
       "acook             Anthony      Cook                  cook@gmail.com   \n",
       "adam.saunders        Adam  Saunders                  adam@gmail.com   \n",
       "adrian             Adrian      Fang   adrian.fang@teamtreehouse.com   \n",
       "adrian.blair       Adrian     Blair            adrian9335@gmail.com   \n",
       "...                   ...       ...                             ...   \n",
       "wilson             Robert    Wilson                robert@yahoo.com   \n",
       "wking               Wanda      King             wanda.king@holt.com   \n",
       "wright3590     Jacqueline    Wright  jacqueline.wright@gonzalez.com   \n",
       "young             Jessica     Young           jessica4028@yahoo.com   \n",
       "zachary.neal      Zachary      Neal                 zneal@gmail.com   \n",
       "\n",
       "              email_verified signup_date  referral_count  balance  \n",
       "aaron                   True  2018-08-31             6.0    18.14  \n",
       "acook                   True  2018-05-12             2.0    55.45  \n",
       "adam.saunders          False  2018-05-29             3.0    72.12  \n",
       "adrian                  True  2018-04-28             3.0    30.01  \n",
       "adrian.blair            True  2018-06-16             7.0    25.85  \n",
       "...                      ...         ...             ...      ...  \n",
       "wilson                 False  2018-05-16             5.0    59.75  \n",
       "wking                   True  2018-06-01             2.0    67.08  \n",
       "wright3590              True  2018-02-08             6.0    18.48  \n",
       "young                   True  2018-07-17             4.0    75.39  \n",
       "zachary.neal            True  2018-07-26             1.0    39.90  \n",
       "\n",
       "[475 rows x 7 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## CHALLENGE - Verified email list ##\n",
    "\n",
    "# TODO: Narrow list to those that have email verified.\n",
    "#  The only columns should be first, last and email\n",
    "email_list = users[:]\n",
    "\n",
    "# TODO: Remove any rows missing last names\n",
    "\n",
    "\n",
    "# TODO: Ensure that the first names are the proper case\n",
    "\n",
    "\n",
    "# Return the new sorted DataFrame..last name then first name ascending\n",
    "email_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "9979fc1830b443128f18c18c4cc5f59f",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "Button(description='Run Tests', style=ButtonStyle())"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/markdown": [
       "```\n",
       "FFFFF\n",
       "======================================================================\n",
       "FAIL: test_columns (tests.helpers.TestVerifiedEmailList)\n",
       "----------------------------------------------------------------------\n",
       "Traceback (most recent call last):\n",
       "  File \"/Users/craig/Code/scripting/intro-to-pandas/tests/test_cells.py\", line 92, in test_columns\n",
       "    ', '.join(expected.columns))\n",
       "AssertionError: 7 != 3 : Please only return the following columns: first_name, last_name, email\n",
       "\n",
       "======================================================================\n",
       "FAIL: test_email_verified (tests.helpers.TestVerifiedEmailList)\n",
       "----------------------------------------------------------------------\n",
       "Traceback (most recent call last):\n",
       "  File \"/Users/craig/Code/scripting/intro-to-pandas/tests/test_cells.py\", line 100, in test_email_verified\n",
       "    \"Ensure that you are only including users with verified emails\"\n",
       "AssertionError: 475 != 358 : Ensure that you are only including users with verified emails\n",
       "\n",
       "======================================================================\n",
       "FAIL: test_has_na (tests.helpers.TestVerifiedEmailList)\n",
       "----------------------------------------------------------------------\n",
       "Traceback (most recent call last):\n",
       "  File \"/Users/craig/Code/scripting/intro-to-pandas/tests/test_cells.py\", line 83, in test_has_na\n",
       "    \"Looks like there are still rows with last names missing. Drop them!\"\n",
       "AssertionError: 45 != 0 : Looks like there are still rows with last names missing. Drop them!\n",
       "\n",
       "======================================================================\n",
       "FAIL: test_sort (tests.helpers.TestVerifiedEmailList)\n",
       "----------------------------------------------------------------------\n",
       "Traceback (most recent call last):\n",
       "  File \"/Users/craig/Code/scripting/intro-to-pandas/tests/test_cells.py\", line 116, in test_sort\n",
       "    msg\n",
       "AssertionError: 'Aaron' != 'Darlene'\n",
       "- Aaron\n",
       "+ Darlene\n",
       " : Check your sort, it should be last name and then first name\n",
       "\n",
       "======================================================================\n",
       "FAIL: test_title_cased (tests.helpers.TestVerifiedEmailList)\n",
       "----------------------------------------------------------------------\n",
       "Traceback (most recent call last):\n",
       "  File \"/Users/craig/Code/scripting/intro-to-pandas/tests/test_cells.py\", line 107, in test_title_cased\n",
       "    \"Make sure you title case the first names, there are still some lower case versions\"\n",
       "AssertionError: 19 != 0 : Make sure you title case the first names, there are still some lower case versions\n",
       "\n",
       "----------------------------------------------------------------------\n",
       "Ran 5 tests in 0.033s\n",
       "\n",
       "FAILED (failures=5)\n",
       "\n",
       "```"
      ],
      "text/plain": [
       "<IPython.core.display.Markdown object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "check(__name__, 'Verified email list')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}