Introduction to SQL with Python.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### In this notebook we'll go over a brief introduction to the structure of the Sakila Database and setting up SQL in your Python Environment.\n",
    "\n",
    "####*DISCLAIMER:*\n",
    "------\n",
    "There are many ways to browse through a SQL database, throughout this Appendix we are only going to be focusing on learning about SQL queries using a combination of SQLite,Python,pandas, and SQLAlchemy. Please note that this is a pretty specific way of operating with a SQL Database, and may or may not fit other general needs. The primary goal of this section is to teach you how to use SQL queries to grab information and set it as a pandas DataFrame. We will not be going over more general topics of relational databases, MySQL, or using a SQL console directly.\n",
    "\n",
    "\n",
    "To fully understand the content of this Appendix, I suggest you complete the course up to at least Lecture 28, although I really recommend completing up to Lecture 46 to get the most out of this Appendix!\n",
    "\n",
    "##### Great, let's begin!\n",
    "\n",
    "---\n",
    "\n",
    "\n",
    "\n",
    "#### Step 1: Download SQL Alchemy\n",
    "\n",
    "To start this appendix, download SQLAlchemy. You can do this by either downloading it [here](http://www.sqlalchemy.org/download.html)\n",
    "\n",
    "*Or* -  by typing pip install sqlalchemy in your command line.\n",
    "\n",
    "*Or* - by typing conda install sqlalchemy if you are using the Anaconda installation of Python. *(recommended)*\n",
    "\n",
    "#### Step 2: Download SQLite Broswer\n",
    "\n",
    "Next up we will download a sql browser. We will be using SQLite Browser because it is lightweight and free to use. There are many alternatives you can use, check out a list of 10 free ones [here](http://www.gfi.com/blog/top-10-free-database-tools-for-sys-admins/)\n",
    "\n",
    "Download SQLite Browser here: http://sqlitebrowser.org/\n",
    "\n",
    "#### Step 3: Download the sakila Database\n",
    "\n",
    "You can download the fully constructed database [here](https://www.dropbox.com/s/t049qmjzycrakro/sakila.db?dl=0)\n",
    "\n",
    "*Or* - you can download the .sql file to construct the database yourself: http://dev.mysql.com/doc/index-other.html\n",
    "Then use SQLite Browser to construct the database by running the .sql\n",
    "\n",
    "Either way, make sure to save it in the same directory as your iPython notebooks, or remember the file path for later so we can tell pandas exactly where to look for it.\n",
    "\n",
    "#### All done! Now let's look at the database before diving into how to work with it in Python.\n",
    "\n",
    "Check out the database either by opening it up using SQLite Browser or by checking out the diagram at this link: [Diagram](http://www.dbquanti.eu/css/images/database.png)\n",
    "\n",
    "I've posted it below as well inside this notebook, but fair warning, the picture is huge!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<img src=\"http://www.dbquanti.eu/css/images/database.png\"/>"
      ],
      "text/plain": [
       "<IPython.core.display.Image object>"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Note: The picture is really big, I suggest you check out the link directly!\n",
    "\n",
    "from IPython.display import Image\n",
    "Image(url='http://www.dbquanti.eu/css/images/database.png')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now that we have seen an overview of what the database looks like, let's go ahead and learn how to communicate with it with Python and pandas."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Python comes with SQLite3, which provides a lightweight disk-based database that doesn't require a seperate server process. It's useful to prototyp with SQLite and then port the code to a larger database system, like MySQL. Python comes with a pretty awesome module to connect to a SQL database with SQLite. The module is SQLite3, let's go ahead and import it (and pandas as well)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# imports!\n",
    "import sqlite3\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "To use the module, you must first create a Connection object that represents the database. If the database name already exists SQLite3 will automatically connect to it, if it does not exsist, SQLite3 will automatically create.\n",
    "\n",
    "For experienced users: You can also supply the special name :memory: to create a database in RAM.\n",
    "\n",
    "Let's make the connection!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Connect to the database (again, downloaded from here: https://www.dropbox.com/s/t049qmjzycrakro/sakila.db?dl=0\n",
    "con = sqlite3.connect(\"sakila.db\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now we can run a basic SQL query, pass it with pandas, and display the output as a DataFrame! Don't worry if you don't understand the query completely yet, this is just a usage example for connecting to the database, other lectures will dive deeper into SQL queries."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>customer_id</th>\n",
       "      <th>store_id</th>\n",
       "      <th>first_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>email</th>\n",
       "      <th>address_id</th>\n",
       "      <th>active</th>\n",
       "      <th>create_date</th>\n",
       "      <th>last_update</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0  </th>\n",
       "      <td>   1</td>\n",
       "      <td> 1</td>\n",
       "      <td>      MARY</td>\n",
       "      <td>     SMITH</td>\n",
       "      <td>         MARY.SMITH@sakilacustomer.org</td>\n",
       "      <td>   5</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1  </th>\n",
       "      <td>   2</td>\n",
       "      <td> 1</td>\n",
       "      <td>  PATRICIA</td>\n",
       "      <td>   JOHNSON</td>\n",
       "      <td>   PATRICIA.JOHNSON@sakilacustomer.org</td>\n",
       "      <td>   6</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2  </th>\n",
       "      <td>   3</td>\n",
       "      <td> 1</td>\n",
       "      <td>     LINDA</td>\n",
       "      <td>  WILLIAMS</td>\n",
       "      <td>     LINDA.WILLIAMS@sakilacustomer.org</td>\n",
       "      <td>   7</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3  </th>\n",
       "      <td>   4</td>\n",
       "      <td> 2</td>\n",
       "      <td>   BARBARA</td>\n",
       "      <td>     JONES</td>\n",
       "      <td>      BARBARA.JONES@sakilacustomer.org</td>\n",
       "      <td>   8</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4  </th>\n",
       "      <td>   5</td>\n",
       "      <td> 1</td>\n",
       "      <td> ELIZABETH</td>\n",
       "      <td>     BROWN</td>\n",
       "      <td>    ELIZABETH.BROWN@sakilacustomer.org</td>\n",
       "      <td>   9</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5  </th>\n",
       "      <td>   6</td>\n",
       "      <td> 2</td>\n",
       "      <td>  JENNIFER</td>\n",
       "      <td>     DAVIS</td>\n",
       "      <td>     JENNIFER.DAVIS@sakilacustomer.org</td>\n",
       "      <td>  10</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6  </th>\n",
       "      <td>   7</td>\n",
       "      <td> 1</td>\n",
       "      <td>     MARIA</td>\n",
       "      <td>    MILLER</td>\n",
       "      <td>       MARIA.MILLER@sakilacustomer.org</td>\n",
       "      <td>  11</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7  </th>\n",
       "      <td>   8</td>\n",
       "      <td> 2</td>\n",
       "      <td>     SUSAN</td>\n",
       "      <td>    WILSON</td>\n",
       "      <td>       SUSAN.WILSON@sakilacustomer.org</td>\n",
       "      <td>  12</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8  </th>\n",
       "      <td>   9</td>\n",
       "      <td> 2</td>\n",
       "      <td>  MARGARET</td>\n",
       "      <td>     MOORE</td>\n",
       "      <td>     MARGARET.MOORE@sakilacustomer.org</td>\n",
       "      <td>  13</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9  </th>\n",
       "      <td>  10</td>\n",
       "      <td> 1</td>\n",
       "      <td>   DOROTHY</td>\n",
       "      <td>    TAYLOR</td>\n",
       "      <td>     DOROTHY.TAYLOR@sakilacustomer.org</td>\n",
       "      <td>  14</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10 </th>\n",
       "      <td>  11</td>\n",
       "      <td> 2</td>\n",
       "      <td>      LISA</td>\n",
       "      <td>  ANDERSON</td>\n",
       "      <td>      LISA.ANDERSON@sakilacustomer.org</td>\n",
       "      <td>  15</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11 </th>\n",
       "      <td>  12</td>\n",
       "      <td> 1</td>\n",
       "      <td>     NANCY</td>\n",
       "      <td>    THOMAS</td>\n",
       "      <td>       NANCY.THOMAS@sakilacustomer.org</td>\n",
       "      <td>  16</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12 </th>\n",
       "      <td>  13</td>\n",
       "      <td> 2</td>\n",
       "      <td>     KAREN</td>\n",
       "      <td>   JACKSON</td>\n",
       "      <td>      KAREN.JACKSON@sakilacustomer.org</td>\n",
       "      <td>  17</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13 </th>\n",
       "      <td>  14</td>\n",
       "      <td> 2</td>\n",
       "      <td>     BETTY</td>\n",
       "      <td>     WHITE</td>\n",
       "      <td>        BETTY.WHITE@sakilacustomer.org</td>\n",
       "      <td>  18</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14 </th>\n",
       "      <td>  15</td>\n",
       "      <td> 1</td>\n",
       "      <td>     HELEN</td>\n",
       "      <td>    HARRIS</td>\n",
       "      <td>       HELEN.HARRIS@sakilacustomer.org</td>\n",
       "      <td>  19</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15 </th>\n",
       "      <td>  16</td>\n",
       "      <td> 2</td>\n",
       "      <td>    SANDRA</td>\n",
       "      <td>    MARTIN</td>\n",
       "      <td>      SANDRA.MARTIN@sakilacustomer.org</td>\n",
       "      <td>  20</td>\n",
       "      <td> 0</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16 </th>\n",
       "      <td>  17</td>\n",
       "      <td> 1</td>\n",
       "      <td>     DONNA</td>\n",
       "      <td>  THOMPSON</td>\n",
       "      <td>     DONNA.THOMPSON@sakilacustomer.org</td>\n",
       "      <td>  21</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17 </th>\n",
       "      <td>  18</td>\n",
       "      <td> 2</td>\n",
       "      <td>     CAROL</td>\n",
       "      <td>    GARCIA</td>\n",
       "      <td>       CAROL.GARCIA@sakilacustomer.org</td>\n",
       "      <td>  22</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18 </th>\n",
       "      <td>  19</td>\n",
       "      <td> 1</td>\n",
       "      <td>      RUTH</td>\n",
       "      <td>  MARTINEZ</td>\n",
       "      <td>      RUTH.MARTINEZ@sakilacustomer.org</td>\n",
       "      <td>  23</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19 </th>\n",
       "      <td>  20</td>\n",
       "      <td> 2</td>\n",
       "      <td>    SHARON</td>\n",
       "      <td>  ROBINSON</td>\n",
       "      <td>    SHARON.ROBINSON@sakilacustomer.org</td>\n",
       "      <td>  24</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20 </th>\n",
       "      <td>  21</td>\n",
       "      <td> 1</td>\n",
       "      <td>  MICHELLE</td>\n",
       "      <td>     CLARK</td>\n",
       "      <td>     MICHELLE.CLARK@sakilacustomer.org</td>\n",
       "      <td>  25</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21 </th>\n",
       "      <td>  22</td>\n",
       "      <td> 1</td>\n",
       "      <td>     LAURA</td>\n",
       "      <td> RODRIGUEZ</td>\n",
       "      <td>    LAURA.RODRIGUEZ@sakilacustomer.org</td>\n",
       "      <td>  26</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22 </th>\n",
       "      <td>  23</td>\n",
       "      <td> 2</td>\n",
       "      <td>     SARAH</td>\n",
       "      <td>     LEWIS</td>\n",
       "      <td>        SARAH.LEWIS@sakilacustomer.org</td>\n",
       "      <td>  27</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23 </th>\n",
       "      <td>  24</td>\n",
       "      <td> 2</td>\n",
       "      <td>  KIMBERLY</td>\n",
       "      <td>       LEE</td>\n",
       "      <td>       KIMBERLY.LEE@sakilacustomer.org</td>\n",
       "      <td>  28</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24 </th>\n",
       "      <td>  25</td>\n",
       "      <td> 1</td>\n",
       "      <td>   DEBORAH</td>\n",
       "      <td>    WALKER</td>\n",
       "      <td>     DEBORAH.WALKER@sakilacustomer.org</td>\n",
       "      <td>  29</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25 </th>\n",
       "      <td>  26</td>\n",
       "      <td> 2</td>\n",
       "      <td>   JESSICA</td>\n",
       "      <td>      HALL</td>\n",
       "      <td>       JESSICA.HALL@sakilacustomer.org</td>\n",
       "      <td>  30</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26 </th>\n",
       "      <td>  27</td>\n",
       "      <td> 2</td>\n",
       "      <td>   SHIRLEY</td>\n",
       "      <td>     ALLEN</td>\n",
       "      <td>      SHIRLEY.ALLEN@sakilacustomer.org</td>\n",
       "      <td>  31</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27 </th>\n",
       "      <td>  28</td>\n",
       "      <td> 1</td>\n",
       "      <td>   CYNTHIA</td>\n",
       "      <td>     YOUNG</td>\n",
       "      <td>      CYNTHIA.YOUNG@sakilacustomer.org</td>\n",
       "      <td>  32</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28 </th>\n",
       "      <td>  29</td>\n",
       "      <td> 2</td>\n",
       "      <td>    ANGELA</td>\n",
       "      <td> HERNANDEZ</td>\n",
       "      <td>   ANGELA.HERNANDEZ@sakilacustomer.org</td>\n",
       "      <td>  33</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29 </th>\n",
       "      <td>  30</td>\n",
       "      <td> 1</td>\n",
       "      <td>   MELISSA</td>\n",
       "      <td>      KING</td>\n",
       "      <td>       MELISSA.KING@sakilacustomer.org</td>\n",
       "      <td>  34</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:36.000</td>\n",
       "      <td> 2011-09-14 18:10:29</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>569</th>\n",
       "      <td> 570</td>\n",
       "      <td> 2</td>\n",
       "      <td>      IVAN</td>\n",
       "      <td>  CROMWELL</td>\n",
       "      <td>      IVAN.CROMWELL@sakilacustomer.org</td>\n",
       "      <td> 576</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>570</th>\n",
       "      <td> 571</td>\n",
       "      <td> 2</td>\n",
       "      <td>   JOHNNIE</td>\n",
       "      <td>  CHISHOLM</td>\n",
       "      <td>   JOHNNIE.CHISHOLM@sakilacustomer.org</td>\n",
       "      <td> 577</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>571</th>\n",
       "      <td> 572</td>\n",
       "      <td> 1</td>\n",
       "      <td>    SIDNEY</td>\n",
       "      <td>  BURLESON</td>\n",
       "      <td>    SIDNEY.BURLESON@sakilacustomer.org</td>\n",
       "      <td> 578</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>572</th>\n",
       "      <td> 573</td>\n",
       "      <td> 1</td>\n",
       "      <td>     BYRON</td>\n",
       "      <td>       BOX</td>\n",
       "      <td>          BYRON.BOX@sakilacustomer.org</td>\n",
       "      <td> 579</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>573</th>\n",
       "      <td> 574</td>\n",
       "      <td> 2</td>\n",
       "      <td>    JULIAN</td>\n",
       "      <td>      VEST</td>\n",
       "      <td>        JULIAN.VEST@sakilacustomer.org</td>\n",
       "      <td> 580</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>574</th>\n",
       "      <td> 575</td>\n",
       "      <td> 2</td>\n",
       "      <td>     ISAAC</td>\n",
       "      <td>   OGLESBY</td>\n",
       "      <td>      ISAAC.OGLESBY@sakilacustomer.org</td>\n",
       "      <td> 581</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>575</th>\n",
       "      <td> 576</td>\n",
       "      <td> 2</td>\n",
       "      <td>    MORRIS</td>\n",
       "      <td>  MCCARTER</td>\n",
       "      <td>    MORRIS.MCCARTER@sakilacustomer.org</td>\n",
       "      <td> 582</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>576</th>\n",
       "      <td> 577</td>\n",
       "      <td> 2</td>\n",
       "      <td>   CLIFTON</td>\n",
       "      <td>   MALCOLM</td>\n",
       "      <td>    CLIFTON.MALCOLM@sakilacustomer.org</td>\n",
       "      <td> 583</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>577</th>\n",
       "      <td> 578</td>\n",
       "      <td> 2</td>\n",
       "      <td>   WILLARD</td>\n",
       "      <td>   LUMPKIN</td>\n",
       "      <td>    WILLARD.LUMPKIN@sakilacustomer.org</td>\n",
       "      <td> 584</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>578</th>\n",
       "      <td> 579</td>\n",
       "      <td> 2</td>\n",
       "      <td>     DARYL</td>\n",
       "      <td>     LARUE</td>\n",
       "      <td>        DARYL.LARUE@sakilacustomer.org</td>\n",
       "      <td> 585</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>579</th>\n",
       "      <td> 580</td>\n",
       "      <td> 1</td>\n",
       "      <td>      ROSS</td>\n",
       "      <td>      GREY</td>\n",
       "      <td>          ROSS.GREY@sakilacustomer.org</td>\n",
       "      <td> 586</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>580</th>\n",
       "      <td> 581</td>\n",
       "      <td> 1</td>\n",
       "      <td>    VIRGIL</td>\n",
       "      <td>   WOFFORD</td>\n",
       "      <td>     VIRGIL.WOFFORD@sakilacustomer.org</td>\n",
       "      <td> 587</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>581</th>\n",
       "      <td> 582</td>\n",
       "      <td> 2</td>\n",
       "      <td>      ANDY</td>\n",
       "      <td>   VANHORN</td>\n",
       "      <td>       ANDY.VANHORN@sakilacustomer.org</td>\n",
       "      <td> 588</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>582</th>\n",
       "      <td> 583</td>\n",
       "      <td> 1</td>\n",
       "      <td>  MARSHALL</td>\n",
       "      <td>     THORN</td>\n",
       "      <td>     MARSHALL.THORN@sakilacustomer.org</td>\n",
       "      <td> 589</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>583</th>\n",
       "      <td> 584</td>\n",
       "      <td> 2</td>\n",
       "      <td>  SALVADOR</td>\n",
       "      <td>      TEEL</td>\n",
       "      <td>      SALVADOR.TEEL@sakilacustomer.org</td>\n",
       "      <td> 590</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>584</th>\n",
       "      <td> 585</td>\n",
       "      <td> 1</td>\n",
       "      <td>     PERRY</td>\n",
       "      <td>  SWAFFORD</td>\n",
       "      <td>     PERRY.SWAFFORD@sakilacustomer.org</td>\n",
       "      <td> 591</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>585</th>\n",
       "      <td> 586</td>\n",
       "      <td> 1</td>\n",
       "      <td>      KIRK</td>\n",
       "      <td>   STCLAIR</td>\n",
       "      <td>       KIRK.STCLAIR@sakilacustomer.org</td>\n",
       "      <td> 592</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>586</th>\n",
       "      <td> 587</td>\n",
       "      <td> 1</td>\n",
       "      <td>    SERGIO</td>\n",
       "      <td> STANFIELD</td>\n",
       "      <td>   SERGIO.STANFIELD@sakilacustomer.org</td>\n",
       "      <td> 593</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>587</th>\n",
       "      <td> 588</td>\n",
       "      <td> 1</td>\n",
       "      <td>    MARION</td>\n",
       "      <td>    OCAMPO</td>\n",
       "      <td>      MARION.OCAMPO@sakilacustomer.org</td>\n",
       "      <td> 594</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>588</th>\n",
       "      <td> 589</td>\n",
       "      <td> 1</td>\n",
       "      <td>     TRACY</td>\n",
       "      <td>  HERRMANN</td>\n",
       "      <td>     TRACY.HERRMANN@sakilacustomer.org</td>\n",
       "      <td> 595</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>589</th>\n",
       "      <td> 590</td>\n",
       "      <td> 2</td>\n",
       "      <td>      SETH</td>\n",
       "      <td>    HANNON</td>\n",
       "      <td>        SETH.HANNON@sakilacustomer.org</td>\n",
       "      <td> 596</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>590</th>\n",
       "      <td> 591</td>\n",
       "      <td> 1</td>\n",
       "      <td>      KENT</td>\n",
       "      <td> ARSENAULT</td>\n",
       "      <td>     KENT.ARSENAULT@sakilacustomer.org</td>\n",
       "      <td> 597</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>591</th>\n",
       "      <td> 592</td>\n",
       "      <td> 1</td>\n",
       "      <td>  TERRANCE</td>\n",
       "      <td>     ROUSH</td>\n",
       "      <td>     TERRANCE.ROUSH@sakilacustomer.org</td>\n",
       "      <td> 598</td>\n",
       "      <td> 0</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>592</th>\n",
       "      <td> 593</td>\n",
       "      <td> 2</td>\n",
       "      <td>      RENE</td>\n",
       "      <td> MCALISTER</td>\n",
       "      <td>     RENE.MCALISTER@sakilacustomer.org</td>\n",
       "      <td> 599</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>593</th>\n",
       "      <td> 594</td>\n",
       "      <td> 1</td>\n",
       "      <td>   EDUARDO</td>\n",
       "      <td>     HIATT</td>\n",
       "      <td>      EDUARDO.HIATT@sakilacustomer.org</td>\n",
       "      <td> 600</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>594</th>\n",
       "      <td> 595</td>\n",
       "      <td> 1</td>\n",
       "      <td>  TERRENCE</td>\n",
       "      <td> GUNDERSON</td>\n",
       "      <td> TERRENCE.GUNDERSON@sakilacustomer.org</td>\n",
       "      <td> 601</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>595</th>\n",
       "      <td> 596</td>\n",
       "      <td> 1</td>\n",
       "      <td>   ENRIQUE</td>\n",
       "      <td>  FORSYTHE</td>\n",
       "      <td>   ENRIQUE.FORSYTHE@sakilacustomer.org</td>\n",
       "      <td> 602</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>596</th>\n",
       "      <td> 597</td>\n",
       "      <td> 1</td>\n",
       "      <td>   FREDDIE</td>\n",
       "      <td>    DUGGAN</td>\n",
       "      <td>     FREDDIE.DUGGAN@sakilacustomer.org</td>\n",
       "      <td> 603</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>597</th>\n",
       "      <td> 598</td>\n",
       "      <td> 1</td>\n",
       "      <td>      WADE</td>\n",
       "      <td>  DELVALLE</td>\n",
       "      <td>      WADE.DELVALLE@sakilacustomer.org</td>\n",
       "      <td> 604</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>598</th>\n",
       "      <td> 599</td>\n",
       "      <td> 2</td>\n",
       "      <td>    AUSTIN</td>\n",
       "      <td>   CINTRON</td>\n",
       "      <td>     AUSTIN.CINTRON@sakilacustomer.org</td>\n",
       "      <td> 605</td>\n",
       "      <td> 1</td>\n",
       "      <td> 2006-02-14 22:04:37.000</td>\n",
       "      <td> 2011-09-14 18:10:44</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>599 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     customer_id  store_id first_name  last_name  \\\n",
       "0              1         1       MARY      SMITH   \n",
       "1              2         1   PATRICIA    JOHNSON   \n",
       "2              3         1      LINDA   WILLIAMS   \n",
       "3              4         2    BARBARA      JONES   \n",
       "4              5         1  ELIZABETH      BROWN   \n",
       "5              6         2   JENNIFER      DAVIS   \n",
       "6              7         1      MARIA     MILLER   \n",
       "7              8         2      SUSAN     WILSON   \n",
       "8              9         2   MARGARET      MOORE   \n",
       "9             10         1    DOROTHY     TAYLOR   \n",
       "10            11         2       LISA   ANDERSON   \n",
       "11            12         1      NANCY     THOMAS   \n",
       "12            13         2      KAREN    JACKSON   \n",
       "13            14         2      BETTY      WHITE   \n",
       "14            15         1      HELEN     HARRIS   \n",
       "15            16         2     SANDRA     MARTIN   \n",
       "16            17         1      DONNA   THOMPSON   \n",
       "17            18         2      CAROL     GARCIA   \n",
       "18            19         1       RUTH   MARTINEZ   \n",
       "19            20         2     SHARON   ROBINSON   \n",
       "20            21         1   MICHELLE      CLARK   \n",
       "21            22         1      LAURA  RODRIGUEZ   \n",
       "22            23         2      SARAH      LEWIS   \n",
       "23            24         2   KIMBERLY        LEE   \n",
       "24            25         1    DEBORAH     WALKER   \n",
       "25            26         2    JESSICA       HALL   \n",
       "26            27         2    SHIRLEY      ALLEN   \n",
       "27            28         1    CYNTHIA      YOUNG   \n",
       "28            29         2     ANGELA  HERNANDEZ   \n",
       "29            30         1    MELISSA       KING   \n",
       "..           ...       ...        ...        ...   \n",
       "569          570         2       IVAN   CROMWELL   \n",
       "570          571         2    JOHNNIE   CHISHOLM   \n",
       "571          572         1     SIDNEY   BURLESON   \n",
       "572          573         1      BYRON        BOX   \n",
       "573          574         2     JULIAN       VEST   \n",
       "574          575         2      ISAAC    OGLESBY   \n",
       "575          576         2     MORRIS   MCCARTER   \n",
       "576          577         2    CLIFTON    MALCOLM   \n",
       "577          578         2    WILLARD    LUMPKIN   \n",
       "578          579         2      DARYL      LARUE   \n",
       "579          580         1       ROSS       GREY   \n",
       "580          581         1     VIRGIL    WOFFORD   \n",
       "581          582         2       ANDY    VANHORN   \n",
       "582          583         1   MARSHALL      THORN   \n",
       "583          584         2   SALVADOR       TEEL   \n",
       "584          585         1      PERRY   SWAFFORD   \n",
       "585          586         1       KIRK    STCLAIR   \n",
       "586          587         1     SERGIO  STANFIELD   \n",
       "587          588         1     MARION     OCAMPO   \n",
       "588          589         1      TRACY   HERRMANN   \n",
       "589          590         2       SETH     HANNON   \n",
       "590          591         1       KENT  ARSENAULT   \n",
       "591          592         1   TERRANCE      ROUSH   \n",
       "592          593         2       RENE  MCALISTER   \n",
       "593          594         1    EDUARDO      HIATT   \n",
       "594          595         1   TERRENCE  GUNDERSON   \n",
       "595          596         1    ENRIQUE   FORSYTHE   \n",
       "596          597         1    FREDDIE     DUGGAN   \n",
       "597          598         1       WADE   DELVALLE   \n",
       "598          599         2     AUSTIN    CINTRON   \n",
       "\n",
       "                                     email  address_id active  \\\n",
       "0            MARY.SMITH@sakilacustomer.org           5      1   \n",
       "1      PATRICIA.JOHNSON@sakilacustomer.org           6      1   \n",
       "2        LINDA.WILLIAMS@sakilacustomer.org           7      1   \n",
       "3         BARBARA.JONES@sakilacustomer.org           8      1   \n",
       "4       ELIZABETH.BROWN@sakilacustomer.org           9      1   \n",
       "5        JENNIFER.DAVIS@sakilacustomer.org          10      1   \n",
       "6          MARIA.MILLER@sakilacustomer.org          11      1   \n",
       "7          SUSAN.WILSON@sakilacustomer.org          12      1   \n",
       "8        MARGARET.MOORE@sakilacustomer.org          13      1   \n",
       "9        DOROTHY.TAYLOR@sakilacustomer.org          14      1   \n",
       "10        LISA.ANDERSON@sakilacustomer.org          15      1   \n",
       "11         NANCY.THOMAS@sakilacustomer.org          16      1   \n",
       "12        KAREN.JACKSON@sakilacustomer.org          17      1   \n",
       "13          BETTY.WHITE@sakilacustomer.org          18      1   \n",
       "14         HELEN.HARRIS@sakilacustomer.org          19      1   \n",
       "15        SANDRA.MARTIN@sakilacustomer.org          20      0   \n",
       "16       DONNA.THOMPSON@sakilacustomer.org          21      1   \n",
       "17         CAROL.GARCIA@sakilacustomer.org          22      1   \n",
       "18        RUTH.MARTINEZ@sakilacustomer.org          23      1   \n",
       "19      SHARON.ROBINSON@sakilacustomer.org          24      1   \n",
       "20       MICHELLE.CLARK@sakilacustomer.org          25      1   \n",
       "21      LAURA.RODRIGUEZ@sakilacustomer.org          26      1   \n",
       "22          SARAH.LEWIS@sakilacustomer.org          27      1   \n",
       "23         KIMBERLY.LEE@sakilacustomer.org          28      1   \n",
       "24       DEBORAH.WALKER@sakilacustomer.org          29      1   \n",
       "25         JESSICA.HALL@sakilacustomer.org          30      1   \n",
       "26        SHIRLEY.ALLEN@sakilacustomer.org          31      1   \n",
       "27        CYNTHIA.YOUNG@sakilacustomer.org          32      1   \n",
       "28     ANGELA.HERNANDEZ@sakilacustomer.org          33      1   \n",
       "29         MELISSA.KING@sakilacustomer.org          34      1   \n",
       "..                                     ...         ...    ...   \n",
       "569       IVAN.CROMWELL@sakilacustomer.org         576      1   \n",
       "570    JOHNNIE.CHISHOLM@sakilacustomer.org         577      1   \n",
       "571     SIDNEY.BURLESON@sakilacustomer.org         578      1   \n",
       "572           BYRON.BOX@sakilacustomer.org         579      1   \n",
       "573         JULIAN.VEST@sakilacustomer.org         580      1   \n",
       "574       ISAAC.OGLESBY@sakilacustomer.org         581      1   \n",
       "575     MORRIS.MCCARTER@sakilacustomer.org         582      1   \n",
       "576     CLIFTON.MALCOLM@sakilacustomer.org         583      1   \n",
       "577     WILLARD.LUMPKIN@sakilacustomer.org         584      1   \n",
       "578         DARYL.LARUE@sakilacustomer.org         585      1   \n",
       "579           ROSS.GREY@sakilacustomer.org         586      1   \n",
       "580      VIRGIL.WOFFORD@sakilacustomer.org         587      1   \n",
       "581        ANDY.VANHORN@sakilacustomer.org         588      1   \n",
       "582      MARSHALL.THORN@sakilacustomer.org         589      1   \n",
       "583       SALVADOR.TEEL@sakilacustomer.org         590      1   \n",
       "584      PERRY.SWAFFORD@sakilacustomer.org         591      1   \n",
       "585        KIRK.STCLAIR@sakilacustomer.org         592      1   \n",
       "586    SERGIO.STANFIELD@sakilacustomer.org         593      1   \n",
       "587       MARION.OCAMPO@sakilacustomer.org         594      1   \n",
       "588      TRACY.HERRMANN@sakilacustomer.org         595      1   \n",
       "589         SETH.HANNON@sakilacustomer.org         596      1   \n",
       "590      KENT.ARSENAULT@sakilacustomer.org         597      1   \n",
       "591      TERRANCE.ROUSH@sakilacustomer.org         598      0   \n",
       "592      RENE.MCALISTER@sakilacustomer.org         599      1   \n",
       "593       EDUARDO.HIATT@sakilacustomer.org         600      1   \n",
       "594  TERRENCE.GUNDERSON@sakilacustomer.org         601      1   \n",
       "595    ENRIQUE.FORSYTHE@sakilacustomer.org         602      1   \n",
       "596      FREDDIE.DUGGAN@sakilacustomer.org         603      1   \n",
       "597       WADE.DELVALLE@sakilacustomer.org         604      1   \n",
       "598      AUSTIN.CINTRON@sakilacustomer.org         605      1   \n",
       "\n",
       "                 create_date          last_update  \n",
       "0    2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "1    2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "2    2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "3    2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "4    2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "5    2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "6    2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "7    2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "8    2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "9    2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "10   2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "11   2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "12   2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "13   2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "14   2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "15   2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "16   2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "17   2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "18   2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "19   2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "20   2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "21   2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "22   2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "23   2006-02-14 22:04:36.000  2011-09-14 18:10:28  \n",
       "24   2006-02-14 22:04:36.000  2011-09-14 18:10:29  \n",
       "25   2006-02-14 22:04:36.000  2011-09-14 18:10:29  \n",
       "26   2006-02-14 22:04:36.000  2011-09-14 18:10:29  \n",
       "27   2006-02-14 22:04:36.000  2011-09-14 18:10:29  \n",
       "28   2006-02-14 22:04:36.000  2011-09-14 18:10:29  \n",
       "29   2006-02-14 22:04:36.000  2011-09-14 18:10:29  \n",
       "..                       ...                  ...  \n",
       "569  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "570  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "571  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "572  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "573  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "574  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "575  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "576  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "577  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "578  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "579  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "580  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "581  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "582  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "583  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "584  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "585  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "586  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "587  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "588  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "589  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "590  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "591  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "592  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "593  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "594  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "595  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "596  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "597  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "598  2006-02-14 22:04:37.000  2011-09-14 18:10:44  \n",
       "\n",
       "[599 rows x 9 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Set SQL query as a comment\n",
    "sql_query = ''' SELECT * FROM customer '''\n",
    "\n",
    "# Use pandas to pass sql query using connection form SQLite3\n",
    "df = pd.read_sql(sql_query, con)\n",
    "\n",
    "# Show the resulting DataFrame\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": false
   },
   "source": [
    "Congratulations! You just passed a SQL Query using pandas and Python! You're amazing! Subsequent lectures will go further into how to query with SQL, but if you already know SQL, you're good to go!"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}