Ayudantía 2.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "# IIC1005: Ayudantía 2\n",
    "#### 16 de agosto de 2017"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "## Objetivos:\n",
    "\n",
    "La idea de esta ayudantía es introducirte a:\n",
    "- Uso de Jupyter Notebook.\n",
    "- Pre-procesamiento de datos."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "## Jupyter Notebook"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "### ¿Qué es un *notebook*?\n",
    "\n",
    "Un *notebook* es un documento que contiene código (en Python, por ejemplo) y elementos más *human-readable*, como ecuaciones, gráficos, o lindos párrafos como los que vendrán a continuación.\n",
    "\n",
    "### ¿Qué es Jupyter?\n",
    "\n",
    "Jupyter es la plataforma web que utilizaremos para crear nuestros bonitos *notebooks*."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "### ¿Por qué utilizar Jupyter Notebook (en la opinión de esta humilde servidora)? \n",
    "\n",
    "Jupyter tiene una serie de ventajas, algunas que podrían servirte en este curso son:\n",
    "\n",
    "- En un *notebook* puedes correr tu código celda por celda. Esto permite volver a ejecutar solo las partes de tu programa en las que podrías tener error y así no correr nuevamente secciones que están buenas y demoran mucho tiempo en terminar. Un ejemplo de lo anterior es lo siguiente:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "ename": "FileNotFoundError",
     "evalue": "[Errno 2] No such file or directory: 'file.txt'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mFileNotFoundError\u001b[0m                         Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-1-a6bd66239df9>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      3\u001b[0m     \u001b[0mtime\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msleep\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;36m2\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      4\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 5\u001b[0;31m \u001b[0;32mwith\u001b[0m \u001b[0mopen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"file.txt\"\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0mfile\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      6\u001b[0m     \u001b[0;32mfor\u001b[0m \u001b[0mline\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mfile\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      7\u001b[0m         \u001b[0mprint\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mline\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mFileNotFoundError\u001b[0m: [Errno 2] No such file or directory: 'file.txt'"
     ]
    }
   ],
   "source": [
    "import time\n",
    "for i in range(10): # Esto va a demorar 20 segundos\n",
    "    time.sleep(2)\n",
    "\n",
    "with open(\"file.txt\") as file:\n",
    "    for line in file:\n",
    "        print(line)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Vemos que el *loop* de nuestro programa no tiene problemas y que el error está al intentar abrir un archivo que no existe. Si aprovechamos el *notebook* y escribimos nuestro código en celdas distintas: "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "import time\n",
    "for i in range(10):\n",
    "    time.sleep(2)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "**Nota**: el método *sleep* se utiliza solo para ejemplicar un sector de código que podría tardar mucho tiempo."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "este\n",
      "\n",
      "es\n",
      "\n",
      "un\n",
      "\n",
      "ejemplo\n",
      "\n",
      "para\n",
      "\n",
      "los\n",
      "\n",
      "alumnos\n",
      "\n",
      "del\n",
      "\n",
      "exploratorio\n",
      "\n"
     ]
    }
   ],
   "source": [
    "with open(\"file1.txt\") as file:\n",
    "    for line in file:\n",
    "        print(line)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "En este caso, basta con corregir en la celda correspondiente el nombre del archivo que deseamos abrir. Con el objeto de que los alumnos que no pudieron venir, reescribiré el código correcto en la celda siguiente. Si viniste a ayudantía (y estás replicando lo que hacemos en tu propio computador), basta con cambiar el nombre en la celda anterior."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "este\n",
      "\n",
      "es\n",
      "\n",
      "un\n",
      "\n",
      "ejemplo\n",
      "\n",
      "para\n",
      "\n",
      "los\n",
      "\n",
      "alumnos\n",
      "\n",
      "del\n",
      "\n",
      "exploratorio\n",
      "\n"
     ]
    }
   ],
   "source": [
    "with open(\"file1.txt\") as file:\n",
    "    for line in file:\n",
    "        print(line)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "- Otra ventaja de *Jupyter Notebook* es que la plataforma te permite exportar tus trabajos a distintos formatos, como .html, .py, .pdf. Lo anterior te será de especial utilidad en la tarea de *machine learning*, donde seguramente tendrás que hacer un informe con distintas ecuaciones, gráficos y análisis de tu código. Esto será tarea sencilla si usas Jupyter, ya que es compatible con [markdown](https://guides.github.com/features/mastering-markdown/) (el maravilloso lenguaje de marcación en que he escrito estos párrafos) y $\\LaTeX$: \n",
    "$$f(x) = \\frac{n!}{x_1! \\cdots x_k!} p_1^{x_1} \\cdots p_k^{x_k}$$."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "### Algunos atajos de teclado útiles"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "- Correr la celda actual: ctrl + enter.\n",
    "- Correr la celda actual y pasar a la siguiente: shift + enter."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "## Pre-procesamiento de datos"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Para poder generar el *dashboard* pedido en tu tarea, primero necesitas trabajar con los datos de manera tal de generar un nuevo archivo *csv*, que contenga, por ejemplo, la ciudad, latitud y longitud en que se generó dicho *tweet*. Las librerías pandas y numpy nos ayudarán mucho en esta misión."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "**Advertencia**: no esperes obtener de aquí código para copiar y pegar directamente en tu tarea. Nuestra idea es que aprendas, por lo que te rogamos plantear todas tus dudas en ayudantía o en el foro Piazza."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "### Conceptos básicos antes de continuar\n",
    "\n",
    "Al trabajar con Pandas, te encontrarás, principalmente, con dos estructuras de datos:\n",
    "\n",
    "1) **Series**: puedes pensar esta estructura como una columna de datos.\n",
    "\n",
    "2) **DataFrame**: un conjunto de series."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "### Cargar los datos\n",
    "\n",
    "La librería pandas tiene un método muy conveniente para cargar archivos *.csv*. Ahora lo utilizaremos para cargar un archivo que contiene transacciones de venta realizadas en 2009."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "dataset = pd.read_csv(\"SalesJan2009.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Con la siguiente línea, podemos observar el contenido del dataset:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Transaction_date</th>\n",
       "      <th>Product</th>\n",
       "      <th>Price</th>\n",
       "      <th>Payment_Type</th>\n",
       "      <th>Name</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Country</th>\n",
       "      <th>Account_Created</th>\n",
       "      <th>Last_Login</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1/2/09 6:17</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>carolina</td>\n",
       "      <td>Basildon</td>\n",
       "      <td>England</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>1/2/09 6:00</td>\n",
       "      <td>1/2/09 6:08</td>\n",
       "      <td>51.500000</td>\n",
       "      <td>-1.116667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1/2/09 4:53</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Betina</td>\n",
       "      <td>Parkville</td>\n",
       "      <td>MO</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/2/09 4:42</td>\n",
       "      <td>1/2/09 7:49</td>\n",
       "      <td>39.195000</td>\n",
       "      <td>-94.681940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1/2/09 13:08</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Federica e Andrea</td>\n",
       "      <td>Astoria</td>\n",
       "      <td>OR</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/1/09 16:21</td>\n",
       "      <td>1/3/09 12:32</td>\n",
       "      <td>46.188060</td>\n",
       "      <td>-123.830000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1/3/09 14:44</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Gouya</td>\n",
       "      <td>Echuca</td>\n",
       "      <td>Victoria</td>\n",
       "      <td>Australia</td>\n",
       "      <td>9/25/05 21:13</td>\n",
       "      <td>1/3/09 14:22</td>\n",
       "      <td>-36.133333</td>\n",
       "      <td>144.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1/4/09 12:56</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Gerd W</td>\n",
       "      <td>Cahaba Heights</td>\n",
       "      <td>AL</td>\n",
       "      <td>United States</td>\n",
       "      <td>11/15/08 15:47</td>\n",
       "      <td>1/4/09 12:45</td>\n",
       "      <td>33.520560</td>\n",
       "      <td>-86.802500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1/4/09 13:19</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>LAURENCE</td>\n",
       "      <td>Mickleton</td>\n",
       "      <td>NJ</td>\n",
       "      <td>United States</td>\n",
       "      <td>9/24/08 15:19</td>\n",
       "      <td>1/4/09 13:04</td>\n",
       "      <td>39.790000</td>\n",
       "      <td>-75.238060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1/4/09 20:11</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Fleur</td>\n",
       "      <td>Peoria</td>\n",
       "      <td>IL</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/3/09 9:38</td>\n",
       "      <td>1/4/09 19:45</td>\n",
       "      <td>40.693610</td>\n",
       "      <td>-89.588890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1/2/09 20:09</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>adam</td>\n",
       "      <td>Martin</td>\n",
       "      <td>TN</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/2/09 17:43</td>\n",
       "      <td>1/4/09 20:01</td>\n",
       "      <td>36.343330</td>\n",
       "      <td>-88.850280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1/4/09 13:17</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Renee Elisabeth</td>\n",
       "      <td>Tel Aviv</td>\n",
       "      <td>Tel Aviv</td>\n",
       "      <td>Israel</td>\n",
       "      <td>1/4/09 13:03</td>\n",
       "      <td>1/4/09 22:10</td>\n",
       "      <td>32.066667</td>\n",
       "      <td>34.766667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1/4/09 14:11</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Aidan</td>\n",
       "      <td>Chatou</td>\n",
       "      <td>Ile-de-France</td>\n",
       "      <td>France</td>\n",
       "      <td>6/3/08 4:22</td>\n",
       "      <td>1/5/09 1:17</td>\n",
       "      <td>48.883333</td>\n",
       "      <td>2.150000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1/5/09 2:42</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Diners</td>\n",
       "      <td>Stacy</td>\n",
       "      <td>New York</td>\n",
       "      <td>NY</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/5/09 2:23</td>\n",
       "      <td>1/5/09 4:59</td>\n",
       "      <td>40.714170</td>\n",
       "      <td>-74.006390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1/5/09 5:39</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Amex</td>\n",
       "      <td>Heidi</td>\n",
       "      <td>Eindhoven</td>\n",
       "      <td>Noord-Brabant</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>1/5/09 4:55</td>\n",
       "      <td>1/5/09 8:15</td>\n",
       "      <td>51.450000</td>\n",
       "      <td>5.466667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1/2/09 9:16</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Sean</td>\n",
       "      <td>Shavano Park</td>\n",
       "      <td>TX</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/2/09 8:32</td>\n",
       "      <td>1/5/09 9:05</td>\n",
       "      <td>29.423890</td>\n",
       "      <td>-98.493330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1/5/09 10:08</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>Eagle</td>\n",
       "      <td>ID</td>\n",
       "      <td>United States</td>\n",
       "      <td>11/11/08 15:53</td>\n",
       "      <td>1/5/09 10:05</td>\n",
       "      <td>43.695560</td>\n",
       "      <td>-116.353060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1/2/09 14:18</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Richard</td>\n",
       "      <td>Riverside</td>\n",
       "      <td>NJ</td>\n",
       "      <td>United States</td>\n",
       "      <td>12/9/08 12:07</td>\n",
       "      <td>1/5/09 11:01</td>\n",
       "      <td>40.032220</td>\n",
       "      <td>-74.957780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1/4/09 1:05</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Diners</td>\n",
       "      <td>Leanne</td>\n",
       "      <td>Julianstown</td>\n",
       "      <td>Meath</td>\n",
       "      <td>Ireland</td>\n",
       "      <td>1/4/09 0:00</td>\n",
       "      <td>1/5/09 13:36</td>\n",
       "      <td>53.677222</td>\n",
       "      <td>-6.319167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1/5/09 11:37</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Janet</td>\n",
       "      <td>Ottawa</td>\n",
       "      <td>Ontario</td>\n",
       "      <td>Canada</td>\n",
       "      <td>1/5/09 9:35</td>\n",
       "      <td>1/5/09 19:24</td>\n",
       "      <td>45.416667</td>\n",
       "      <td>-75.700000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1/6/09 5:02</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Diners</td>\n",
       "      <td>barbara</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Andhra Pradesh</td>\n",
       "      <td>India</td>\n",
       "      <td>1/6/09 2:41</td>\n",
       "      <td>1/6/09 7:52</td>\n",
       "      <td>17.383333</td>\n",
       "      <td>78.466667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1/6/09 7:45</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Sabine</td>\n",
       "      <td>London</td>\n",
       "      <td>England</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>1/6/09 7:00</td>\n",
       "      <td>1/6/09 9:17</td>\n",
       "      <td>51.527210</td>\n",
       "      <td>0.145590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1/2/09 7:35</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Diners</td>\n",
       "      <td>Hani</td>\n",
       "      <td>Salt Lake City</td>\n",
       "      <td>UT</td>\n",
       "      <td>United States</td>\n",
       "      <td>12/30/08 5:44</td>\n",
       "      <td>1/6/09 10:52</td>\n",
       "      <td>40.760830</td>\n",
       "      <td>-111.890280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1/6/09 12:56</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Jeremy</td>\n",
       "      <td>Manchester</td>\n",
       "      <td>England</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>1/6/09 10:58</td>\n",
       "      <td>1/6/09 13:31</td>\n",
       "      <td>53.500000</td>\n",
       "      <td>-2.216667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1/1/09 11:05</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Diners</td>\n",
       "      <td>Janis</td>\n",
       "      <td>Ballynora</td>\n",
       "      <td>Cork</td>\n",
       "      <td>Ireland</td>\n",
       "      <td>12/10/07 12:37</td>\n",
       "      <td>1/7/09 1:52</td>\n",
       "      <td>51.863056</td>\n",
       "      <td>-8.580000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1/5/09 4:10</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Nicola</td>\n",
       "      <td>Roodepoort</td>\n",
       "      <td>Gauteng</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>1/5/09 2:33</td>\n",
       "      <td>1/7/09 5:13</td>\n",
       "      <td>-26.166667</td>\n",
       "      <td>27.866667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1/6/09 7:18</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>asuman</td>\n",
       "      <td>Chula Vista</td>\n",
       "      <td>CA</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/6/09 7:07</td>\n",
       "      <td>1/7/09 7:08</td>\n",
       "      <td>32.640000</td>\n",
       "      <td>-117.083330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1/2/09 1:11</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Lena</td>\n",
       "      <td>Kuopio</td>\n",
       "      <td>Ita-Suomen Laani</td>\n",
       "      <td>Finland</td>\n",
       "      <td>12/31/08 2:48</td>\n",
       "      <td>1/7/09 10:20</td>\n",
       "      <td>62.900000</td>\n",
       "      <td>27.683333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1/1/09 2:24</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Lisa</td>\n",
       "      <td>Sugar Land</td>\n",
       "      <td>TX</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/1/09 1:56</td>\n",
       "      <td>1/7/09 10:52</td>\n",
       "      <td>29.619440</td>\n",
       "      <td>-95.634720</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1/7/09 8:08</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Diners</td>\n",
       "      <td>Bryan Kerrene</td>\n",
       "      <td>New York</td>\n",
       "      <td>NY</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/7/09 7:39</td>\n",
       "      <td>1/7/09 12:38</td>\n",
       "      <td>40.714170</td>\n",
       "      <td>-74.006390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1/2/09 2:57</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>chris</td>\n",
       "      <td>London</td>\n",
       "      <td>England</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>1/3/08 7:23</td>\n",
       "      <td>1/7/09 13:14</td>\n",
       "      <td>51.527210</td>\n",
       "      <td>0.145590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1/1/09 20:21</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Maxine</td>\n",
       "      <td>Morton</td>\n",
       "      <td>IL</td>\n",
       "      <td>United States</td>\n",
       "      <td>10/24/08 6:48</td>\n",
       "      <td>1/7/09 20:49</td>\n",
       "      <td>40.612780</td>\n",
       "      <td>-89.459170</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1/8/09 0:42</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Family</td>\n",
       "      <td>Los Gatos</td>\n",
       "      <td>CA</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/8/09 0:28</td>\n",
       "      <td>1/8/09 3:39</td>\n",
       "      <td>37.226670</td>\n",
       "      <td>-121.973610</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>968</th>\n",
       "      <td>1/2/09 17:24</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Diners</td>\n",
       "      <td>clara</td>\n",
       "      <td>Perth</td>\n",
       "      <td>Western Australia</td>\n",
       "      <td>Australia</td>\n",
       "      <td>1/1/09 21:20</td>\n",
       "      <td>2/27/09 18:43</td>\n",
       "      <td>-31.933333</td>\n",
       "      <td>115.833333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>969</th>\n",
       "      <td>1/7/09 18:15</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Selma</td>\n",
       "      <td>Greenville</td>\n",
       "      <td>TX</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/5/09 18:16</td>\n",
       "      <td>2/27/09 19:07</td>\n",
       "      <td>33.138330</td>\n",
       "      <td>-96.110560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>970</th>\n",
       "      <td>1/3/09 21:19</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Doug and Tina</td>\n",
       "      <td>Pls Vrds Est</td>\n",
       "      <td>CA</td>\n",
       "      <td>United States</td>\n",
       "      <td>12/24/07 22:59</td>\n",
       "      <td>2/27/09 21:40</td>\n",
       "      <td>33.800560</td>\n",
       "      <td>-118.389170</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>971</th>\n",
       "      <td>1/4/09 5:13</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Lauren</td>\n",
       "      <td>Hradec Kralove</td>\n",
       "      <td>East Bohemia</td>\n",
       "      <td>Czech Republic</td>\n",
       "      <td>3/5/06 0:51</td>\n",
       "      <td>2/27/09 23:30</td>\n",
       "      <td>50.211667</td>\n",
       "      <td>15.844167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>972</th>\n",
       "      <td>1/4/09 9:28</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Jen</td>\n",
       "      <td>Maidstone</td>\n",
       "      <td>England</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>7/18/05 14:17</td>\n",
       "      <td>2/28/09 2:28</td>\n",
       "      <td>51.266667</td>\n",
       "      <td>0.516667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>973</th>\n",
       "      <td>1/2/09 4:34</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>gladys</td>\n",
       "      <td>Saint Albans</td>\n",
       "      <td>England</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>1/10/06 4:20</td>\n",
       "      <td>2/28/09 3:43</td>\n",
       "      <td>51.750000</td>\n",
       "      <td>-0.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>974</th>\n",
       "      <td>1/22/09 11:10</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Gustavo</td>\n",
       "      <td>Voluntari</td>\n",
       "      <td>Bucuresti</td>\n",
       "      <td>Romania</td>\n",
       "      <td>7/28/08 11:12</td>\n",
       "      <td>2/28/09 7:52</td>\n",
       "      <td>44.466667</td>\n",
       "      <td>26.133333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>975</th>\n",
       "      <td>1/7/09 12:06</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Erica</td>\n",
       "      <td>Nadur</td>\n",
       "      <td></td>\n",
       "      <td>Malta</td>\n",
       "      <td>3/30/06 2:02</td>\n",
       "      <td>2/28/09 7:59</td>\n",
       "      <td>36.037778</td>\n",
       "      <td>14.294167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>976</th>\n",
       "      <td>1/29/09 13:25</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Diners</td>\n",
       "      <td>Hale</td>\n",
       "      <td>Morrison</td>\n",
       "      <td>CO</td>\n",
       "      <td>United States</td>\n",
       "      <td>11/3/05 18:14</td>\n",
       "      <td>2/28/09 8:27</td>\n",
       "      <td>39.653610</td>\n",
       "      <td>-105.190560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>977</th>\n",
       "      <td>1/27/09 2:57</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Rosemary</td>\n",
       "      <td>Cobham</td>\n",
       "      <td>England</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>1/27/09 2:50</td>\n",
       "      <td>2/28/09 9:22</td>\n",
       "      <td>51.383333</td>\n",
       "      <td>0.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>978</th>\n",
       "      <td>1/7/09 13:19</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Darian</td>\n",
       "      <td>Izmir</td>\n",
       "      <td>Izmir</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>8/26/08 7:33</td>\n",
       "      <td>2/28/09 9:54</td>\n",
       "      <td>38.407222</td>\n",
       "      <td>27.150278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>979</th>\n",
       "      <td>1/23/09 10:04</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Kevin</td>\n",
       "      <td>Hollywood</td>\n",
       "      <td>CA</td>\n",
       "      <td>United States</td>\n",
       "      <td>5/30/06 20:25</td>\n",
       "      <td>2/28/09 9:59</td>\n",
       "      <td>34.098330</td>\n",
       "      <td>-118.325830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>980</th>\n",
       "      <td>1/19/09 4:55</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Alyssa</td>\n",
       "      <td>Brighton</td>\n",
       "      <td>England</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>2/19/08 9:27</td>\n",
       "      <td>2/28/09 10:06</td>\n",
       "      <td>50.833333</td>\n",
       "      <td>-0.150000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>981</th>\n",
       "      <td>1/28/09 22:02</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Hale</td>\n",
       "      <td>Hawera</td>\n",
       "      <td>Taranaki</td>\n",
       "      <td>New Zealand</td>\n",
       "      <td>1/23/09 22:31</td>\n",
       "      <td>2/28/09 12:43</td>\n",
       "      <td>-39.591667</td>\n",
       "      <td>174.283333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>982</th>\n",
       "      <td>1/4/09 18:57</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>KELI</td>\n",
       "      <td>Worongary</td>\n",
       "      <td>Queensland</td>\n",
       "      <td>Australia</td>\n",
       "      <td>12/23/08 15:17</td>\n",
       "      <td>2/28/09 14:00</td>\n",
       "      <td>-28.050000</td>\n",
       "      <td>153.350000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>983</th>\n",
       "      <td>1/12/09 20:31</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Glen</td>\n",
       "      <td>Atlantida</td>\n",
       "      <td>Guatemala</td>\n",
       "      <td>Guatemala</td>\n",
       "      <td>1/6/09 16:53</td>\n",
       "      <td>2/28/09 14:39</td>\n",
       "      <td>14.650000</td>\n",
       "      <td>-90.483333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>984</th>\n",
       "      <td>1/24/09 12:00</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>T</td>\n",
       "      <td>El Escorial</td>\n",
       "      <td>Madrid</td>\n",
       "      <td>Spain</td>\n",
       "      <td>12/30/08 15:19</td>\n",
       "      <td>2/28/09 15:17</td>\n",
       "      <td>40.583333</td>\n",
       "      <td>-4.116667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>985</th>\n",
       "      <td>1/28/09 11:19</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>christal</td>\n",
       "      <td>Morrison</td>\n",
       "      <td>CO</td>\n",
       "      <td>United States</td>\n",
       "      <td>6/20/04 17:16</td>\n",
       "      <td>2/28/09 17:18</td>\n",
       "      <td>39.653610</td>\n",
       "      <td>-105.190560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>986</th>\n",
       "      <td>1/7/09 17:48</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Augusta</td>\n",
       "      <td>GA</td>\n",
       "      <td>United States</td>\n",
       "      <td>6/10/05 20:25</td>\n",
       "      <td>2/28/09 19:57</td>\n",
       "      <td>33.517220</td>\n",
       "      <td>-82.075830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>987</th>\n",
       "      <td>1/23/09 12:42</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Anke</td>\n",
       "      <td>Avalon</td>\n",
       "      <td>New South Wales</td>\n",
       "      <td>Australia</td>\n",
       "      <td>3/3/08 17:38</td>\n",
       "      <td>2/28/09 22:26</td>\n",
       "      <td>-33.633333</td>\n",
       "      <td>151.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>988</th>\n",
       "      <td>1/7/09 19:48</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>TRICIA</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>New South Wales</td>\n",
       "      <td>Australia</td>\n",
       "      <td>9/21/08 20:49</td>\n",
       "      <td>3/1/09 0:14</td>\n",
       "      <td>-33.883333</td>\n",
       "      <td>151.216667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>989</th>\n",
       "      <td>1/26/09 11:19</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>smith</td>\n",
       "      <td>Lahti</td>\n",
       "      <td>Etela-Suomen Laani</td>\n",
       "      <td>Finland</td>\n",
       "      <td>1/4/09 5:25</td>\n",
       "      <td>3/1/09 0:39</td>\n",
       "      <td>60.966667</td>\n",
       "      <td>25.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>990</th>\n",
       "      <td>1/5/09 13:23</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Macy</td>\n",
       "      <td>Inner City</td>\n",
       "      <td>Vienna</td>\n",
       "      <td>Austria</td>\n",
       "      <td>1/5/09 11:28</td>\n",
       "      <td>3/1/09 2:28</td>\n",
       "      <td>48.216667</td>\n",
       "      <td>16.366667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>991</th>\n",
       "      <td>1/26/09 13:41</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Lesleigh</td>\n",
       "      <td>Baden</td>\n",
       "      <td>Aargau</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>10/23/05 9:23</td>\n",
       "      <td>3/1/09 3:11</td>\n",
       "      <td>47.466667</td>\n",
       "      <td>8.300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>992</th>\n",
       "      <td>1/20/09 10:42</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Diners</td>\n",
       "      <td>esther</td>\n",
       "      <td>Huddersfield</td>\n",
       "      <td>England</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>1/20/09 9:15</td>\n",
       "      <td>3/1/09 3:29</td>\n",
       "      <td>53.650000</td>\n",
       "      <td>-1.783333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993</th>\n",
       "      <td>1/22/09 14:25</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Hans-Joerg</td>\n",
       "      <td>Belfast</td>\n",
       "      <td>Northern Ireland</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>11/10/08 12:15</td>\n",
       "      <td>3/1/09 3:37</td>\n",
       "      <td>54.583333</td>\n",
       "      <td>-5.933333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>994</th>\n",
       "      <td>1/28/09 5:36</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Christiane</td>\n",
       "      <td>Black River</td>\n",
       "      <td>Black River</td>\n",
       "      <td>Mauritius</td>\n",
       "      <td>1/9/09 8:10</td>\n",
       "      <td>3/1/09 4:40</td>\n",
       "      <td>-20.360278</td>\n",
       "      <td>57.366111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>1/1/09 4:24</td>\n",
       "      <td>Product3</td>\n",
       "      <td>7500</td>\n",
       "      <td>Amex</td>\n",
       "      <td>Pamela</td>\n",
       "      <td>Skaneateles</td>\n",
       "      <td>NY</td>\n",
       "      <td>United States</td>\n",
       "      <td>12/28/08 17:28</td>\n",
       "      <td>3/1/09 7:21</td>\n",
       "      <td>42.946940</td>\n",
       "      <td>-76.429440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>1/8/09 11:55</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Diners</td>\n",
       "      <td>julie</td>\n",
       "      <td>Haverhill</td>\n",
       "      <td>England</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>11/29/06 13:31</td>\n",
       "      <td>3/1/09 7:28</td>\n",
       "      <td>52.083333</td>\n",
       "      <td>0.433333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>1/12/09 21:30</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Julia</td>\n",
       "      <td>Madison</td>\n",
       "      <td>WI</td>\n",
       "      <td>United States</td>\n",
       "      <td>11/17/08 22:24</td>\n",
       "      <td>3/1/09 10:14</td>\n",
       "      <td>43.073060</td>\n",
       "      <td>-89.401110</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>998 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Transaction_date   Product Price Payment_Type               Name  \\\n",
       "0        1/2/09 6:17  Product1  1200   Mastercard           carolina   \n",
       "1        1/2/09 4:53  Product1  1200         Visa             Betina   \n",
       "2       1/2/09 13:08  Product1  1200   Mastercard  Federica e Andrea   \n",
       "3       1/3/09 14:44  Product1  1200         Visa              Gouya   \n",
       "4       1/4/09 12:56  Product2  3600         Visa            Gerd W    \n",
       "5       1/4/09 13:19  Product1  1200         Visa           LAURENCE   \n",
       "6       1/4/09 20:11  Product1  1200   Mastercard              Fleur   \n",
       "7       1/2/09 20:09  Product1  1200   Mastercard               adam   \n",
       "8       1/4/09 13:17  Product1  1200   Mastercard    Renee Elisabeth   \n",
       "9       1/4/09 14:11  Product1  1200         Visa              Aidan   \n",
       "10       1/5/09 2:42  Product1  1200       Diners              Stacy   \n",
       "11       1/5/09 5:39  Product1  1200         Amex              Heidi   \n",
       "12       1/2/09 9:16  Product1  1200   Mastercard              Sean    \n",
       "13      1/5/09 10:08  Product1  1200         Visa            Georgia   \n",
       "14      1/2/09 14:18  Product1  1200         Visa            Richard   \n",
       "15       1/4/09 1:05  Product1  1200       Diners             Leanne   \n",
       "16      1/5/09 11:37  Product1  1200         Visa              Janet   \n",
       "17       1/6/09 5:02  Product1  1200       Diners            barbara   \n",
       "18       1/6/09 7:45  Product2  3600         Visa             Sabine   \n",
       "19       1/2/09 7:35  Product1  1200       Diners               Hani   \n",
       "20      1/6/09 12:56  Product1  1200         Visa             Jeremy   \n",
       "21      1/1/09 11:05  Product1  1200       Diners              Janis   \n",
       "22       1/5/09 4:10  Product1  1200   Mastercard             Nicola   \n",
       "23       1/6/09 7:18  Product1  1200         Visa             asuman   \n",
       "24       1/2/09 1:11  Product1  1200   Mastercard               Lena   \n",
       "25       1/1/09 2:24  Product1  1200         Visa               Lisa   \n",
       "26       1/7/09 8:08  Product1  1200       Diners      Bryan Kerrene   \n",
       "27       1/2/09 2:57  Product1  1200         Visa              chris   \n",
       "28      1/1/09 20:21  Product1  1200         Visa             Maxine   \n",
       "29       1/8/09 0:42  Product1  1200         Visa             Family   \n",
       "..               ...       ...   ...          ...                ...   \n",
       "968     1/2/09 17:24  Product2  3600       Diners              clara   \n",
       "969     1/7/09 18:15  Product1  1200   Mastercard              Selma   \n",
       "970     1/3/09 21:19  Product1  1200         Visa      Doug and Tina   \n",
       "971      1/4/09 5:13  Product1  1200         Visa             Lauren   \n",
       "972      1/4/09 9:28  Product1  1200         Visa                Jen   \n",
       "973      1/2/09 4:34  Product1  1200         Visa             gladys   \n",
       "974    1/22/09 11:10  Product1  1200   Mastercard            Gustavo   \n",
       "975     1/7/09 12:06  Product1  1200         Visa              Erica   \n",
       "976    1/29/09 13:25  Product1  1200       Diners               Hale   \n",
       "977     1/27/09 2:57  Product1  1200         Visa           Rosemary   \n",
       "978     1/7/09 13:19  Product1  1200         Visa             Darian   \n",
       "979    1/23/09 10:04  Product1  1200   Mastercard              Kevin   \n",
       "980     1/19/09 4:55  Product1  1200         Visa             Alyssa   \n",
       "981    1/28/09 22:02  Product1  1200         Visa               Hale   \n",
       "982     1/4/09 18:57  Product1  1200   Mastercard               KELI   \n",
       "983    1/12/09 20:31  Product1  1200         Visa               Glen   \n",
       "984    1/24/09 12:00  Product1  1200         Visa                  T   \n",
       "985    1/28/09 11:19  Product1  1200         Visa           christal   \n",
       "986     1/7/09 17:48  Product1  1200   Mastercard               Alex   \n",
       "987    1/23/09 12:42  Product2  3600   Mastercard               Anke   \n",
       "988     1/7/09 19:48  Product2  3600   Mastercard             TRICIA   \n",
       "989    1/26/09 11:19  Product1  1200   Mastercard              smith   \n",
       "990     1/5/09 13:23  Product1  1200         Visa               Macy   \n",
       "991    1/26/09 13:41  Product1  1200   Mastercard           Lesleigh   \n",
       "992    1/20/09 10:42  Product2  3600       Diners             esther   \n",
       "993    1/22/09 14:25  Product1  1200         Visa         Hans-Joerg   \n",
       "994     1/28/09 5:36  Product2  3600         Visa         Christiane   \n",
       "995      1/1/09 4:24  Product3  7500         Amex             Pamela   \n",
       "996     1/8/09 11:55  Product1  1200       Diners              julie   \n",
       "997    1/12/09 21:30  Product1  1200         Visa             Julia    \n",
       "\n",
       "                             City               State         Country  \\\n",
       "0                        Basildon             England  United Kingdom   \n",
       "1    Parkville                                     MO   United States   \n",
       "2    Astoria                                       OR   United States   \n",
       "3                          Echuca            Victoria       Australia   \n",
       "4    Cahaba Heights                                AL   United States   \n",
       "5    Mickleton                                     NJ   United States   \n",
       "6    Peoria                                        IL   United States   \n",
       "7    Martin                                        TN   United States   \n",
       "8                        Tel Aviv            Tel Aviv          Israel   \n",
       "9                          Chatou       Ile-de-France          France   \n",
       "10   New York                                      NY   United States   \n",
       "11                      Eindhoven       Noord-Brabant     Netherlands   \n",
       "12   Shavano Park                                  TX   United States   \n",
       "13   Eagle                                         ID   United States   \n",
       "14   Riverside                                     NJ   United States   \n",
       "15                    Julianstown               Meath         Ireland   \n",
       "16                         Ottawa             Ontario          Canada   \n",
       "17                      Hyderabad      Andhra Pradesh           India   \n",
       "18                         London             England  United Kingdom   \n",
       "19   Salt Lake City                                UT   United States   \n",
       "20                     Manchester             England  United Kingdom   \n",
       "21                      Ballynora                Cork         Ireland   \n",
       "22                     Roodepoort             Gauteng    South Africa   \n",
       "23   Chula Vista                                   CA   United States   \n",
       "24                         Kuopio    Ita-Suomen Laani         Finland   \n",
       "25   Sugar Land                                    TX   United States   \n",
       "26   New York                                      NY   United States   \n",
       "27                         London             England  United Kingdom   \n",
       "28   Morton                                        IL   United States   \n",
       "29   Los Gatos                                     CA   United States   \n",
       "..                            ...                 ...             ...   \n",
       "968                         Perth   Western Australia       Australia   \n",
       "969  Greenville                                    TX   United States   \n",
       "970  Pls Vrds Est                                  CA   United States   \n",
       "971                Hradec Kralove        East Bohemia  Czech Republic   \n",
       "972                     Maidstone             England  United Kingdom   \n",
       "973                  Saint Albans             England  United Kingdom   \n",
       "974                     Voluntari           Bucuresti         Romania   \n",
       "975                         Nadur                               Malta   \n",
       "976  Morrison                                      CO   United States   \n",
       "977                        Cobham             England  United Kingdom   \n",
       "978                         Izmir               Izmir          Turkey   \n",
       "979  Hollywood                                     CA   United States   \n",
       "980                      Brighton             England  United Kingdom   \n",
       "981                        Hawera            Taranaki     New Zealand   \n",
       "982                     Worongary          Queensland       Australia   \n",
       "983                     Atlantida           Guatemala       Guatemala   \n",
       "984                   El Escorial              Madrid           Spain   \n",
       "985  Morrison                                      CO   United States   \n",
       "986  Augusta                                       GA   United States   \n",
       "987                        Avalon     New South Wales       Australia   \n",
       "988                        Sydney     New South Wales       Australia   \n",
       "989                         Lahti  Etela-Suomen Laani         Finland   \n",
       "990                    Inner City              Vienna         Austria   \n",
       "991                         Baden              Aargau     Switzerland   \n",
       "992                  Huddersfield             England  United Kingdom   \n",
       "993                       Belfast    Northern Ireland  United Kingdom   \n",
       "994                   Black River         Black River       Mauritius   \n",
       "995  Skaneateles                                   NY   United States   \n",
       "996                     Haverhill             England  United Kingdom   \n",
       "997  Madison                                       WI   United States   \n",
       "\n",
       "    Account_Created     Last_Login   Latitude   Longitude  \n",
       "0       1/2/09 6:00    1/2/09 6:08  51.500000   -1.116667  \n",
       "1       1/2/09 4:42    1/2/09 7:49  39.195000  -94.681940  \n",
       "2      1/1/09 16:21   1/3/09 12:32  46.188060 -123.830000  \n",
       "3     9/25/05 21:13   1/3/09 14:22 -36.133333  144.750000  \n",
       "4    11/15/08 15:47   1/4/09 12:45  33.520560  -86.802500  \n",
       "5     9/24/08 15:19   1/4/09 13:04  39.790000  -75.238060  \n",
       "6       1/3/09 9:38   1/4/09 19:45  40.693610  -89.588890  \n",
       "7      1/2/09 17:43   1/4/09 20:01  36.343330  -88.850280  \n",
       "8      1/4/09 13:03   1/4/09 22:10  32.066667   34.766667  \n",
       "9       6/3/08 4:22    1/5/09 1:17  48.883333    2.150000  \n",
       "10      1/5/09 2:23    1/5/09 4:59  40.714170  -74.006390  \n",
       "11      1/5/09 4:55    1/5/09 8:15  51.450000    5.466667  \n",
       "12      1/2/09 8:32    1/5/09 9:05  29.423890  -98.493330  \n",
       "13   11/11/08 15:53   1/5/09 10:05  43.695560 -116.353060  \n",
       "14    12/9/08 12:07   1/5/09 11:01  40.032220  -74.957780  \n",
       "15      1/4/09 0:00   1/5/09 13:36  53.677222   -6.319167  \n",
       "16      1/5/09 9:35   1/5/09 19:24  45.416667  -75.700000  \n",
       "17      1/6/09 2:41    1/6/09 7:52  17.383333   78.466667  \n",
       "18      1/6/09 7:00    1/6/09 9:17  51.527210    0.145590  \n",
       "19    12/30/08 5:44   1/6/09 10:52  40.760830 -111.890280  \n",
       "20     1/6/09 10:58   1/6/09 13:31  53.500000   -2.216667  \n",
       "21   12/10/07 12:37    1/7/09 1:52  51.863056   -8.580000  \n",
       "22      1/5/09 2:33    1/7/09 5:13 -26.166667   27.866667  \n",
       "23      1/6/09 7:07    1/7/09 7:08  32.640000 -117.083330  \n",
       "24    12/31/08 2:48   1/7/09 10:20  62.900000   27.683333  \n",
       "25      1/1/09 1:56   1/7/09 10:52  29.619440  -95.634720  \n",
       "26      1/7/09 7:39   1/7/09 12:38  40.714170  -74.006390  \n",
       "27      1/3/08 7:23   1/7/09 13:14  51.527210    0.145590  \n",
       "28    10/24/08 6:48   1/7/09 20:49  40.612780  -89.459170  \n",
       "29      1/8/09 0:28    1/8/09 3:39  37.226670 -121.973610  \n",
       "..              ...            ...        ...         ...  \n",
       "968    1/1/09 21:20  2/27/09 18:43 -31.933333  115.833333  \n",
       "969    1/5/09 18:16  2/27/09 19:07  33.138330  -96.110560  \n",
       "970  12/24/07 22:59  2/27/09 21:40  33.800560 -118.389170  \n",
       "971     3/5/06 0:51  2/27/09 23:30  50.211667   15.844167  \n",
       "972   7/18/05 14:17   2/28/09 2:28  51.266667    0.516667  \n",
       "973    1/10/06 4:20   2/28/09 3:43  51.750000   -0.333333  \n",
       "974   7/28/08 11:12   2/28/09 7:52  44.466667   26.133333  \n",
       "975    3/30/06 2:02   2/28/09 7:59  36.037778   14.294167  \n",
       "976   11/3/05 18:14   2/28/09 8:27  39.653610 -105.190560  \n",
       "977    1/27/09 2:50   2/28/09 9:22  51.383333    0.400000  \n",
       "978    8/26/08 7:33   2/28/09 9:54  38.407222   27.150278  \n",
       "979   5/30/06 20:25   2/28/09 9:59  34.098330 -118.325830  \n",
       "980    2/19/08 9:27  2/28/09 10:06  50.833333   -0.150000  \n",
       "981   1/23/09 22:31  2/28/09 12:43 -39.591667  174.283333  \n",
       "982  12/23/08 15:17  2/28/09 14:00 -28.050000  153.350000  \n",
       "983    1/6/09 16:53  2/28/09 14:39  14.650000  -90.483333  \n",
       "984  12/30/08 15:19  2/28/09 15:17  40.583333   -4.116667  \n",
       "985   6/20/04 17:16  2/28/09 17:18  39.653610 -105.190560  \n",
       "986   6/10/05 20:25  2/28/09 19:57  33.517220  -82.075830  \n",
       "987    3/3/08 17:38  2/28/09 22:26 -33.633333  151.333333  \n",
       "988   9/21/08 20:49    3/1/09 0:14 -33.883333  151.216667  \n",
       "989     1/4/09 5:25    3/1/09 0:39  60.966667   25.666667  \n",
       "990    1/5/09 11:28    3/1/09 2:28  48.216667   16.366667  \n",
       "991   10/23/05 9:23    3/1/09 3:11  47.466667    8.300000  \n",
       "992    1/20/09 9:15    3/1/09 3:29  53.650000   -1.783333  \n",
       "993  11/10/08 12:15    3/1/09 3:37  54.583333   -5.933333  \n",
       "994     1/9/09 8:10    3/1/09 4:40 -20.360278   57.366111  \n",
       "995  12/28/08 17:28    3/1/09 7:21  42.946940  -76.429440  \n",
       "996  11/29/06 13:31    3/1/09 7:28  52.083333    0.433333  \n",
       "997  11/17/08 22:24   3/1/09 10:14  43.073060  -89.401110  \n",
       "\n",
       "[998 rows x 12 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "### Exploración de los datos"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Pandas nos permite además explorar nuestros datos de manera sencilla. Podríamos querer conocer, por ejemplo, las transacciones que se realizaron con tarjeta *Mastercard*."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "mastercard = dataset[dataset[\"Payment_Type\"] == \"Mastercard\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Transaction_date</th>\n",
       "      <th>Product</th>\n",
       "      <th>Price</th>\n",
       "      <th>Payment_Type</th>\n",
       "      <th>Name</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Country</th>\n",
       "      <th>Account_Created</th>\n",
       "      <th>Last_Login</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1/2/09 6:17</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>carolina</td>\n",
       "      <td>Basildon</td>\n",
       "      <td>England</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>1/2/09 6:00</td>\n",
       "      <td>1/2/09 6:08</td>\n",
       "      <td>51.500000</td>\n",
       "      <td>-1.116667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1/2/09 13:08</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Federica e Andrea</td>\n",
       "      <td>Astoria</td>\n",
       "      <td>OR</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/1/09 16:21</td>\n",
       "      <td>1/3/09 12:32</td>\n",
       "      <td>46.188060</td>\n",
       "      <td>-123.830000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1/4/09 20:11</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Fleur</td>\n",
       "      <td>Peoria</td>\n",
       "      <td>IL</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/3/09 9:38</td>\n",
       "      <td>1/4/09 19:45</td>\n",
       "      <td>40.693610</td>\n",
       "      <td>-89.588890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1/2/09 20:09</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>adam</td>\n",
       "      <td>Martin</td>\n",
       "      <td>TN</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/2/09 17:43</td>\n",
       "      <td>1/4/09 20:01</td>\n",
       "      <td>36.343330</td>\n",
       "      <td>-88.850280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1/4/09 13:17</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Renee Elisabeth</td>\n",
       "      <td>Tel Aviv</td>\n",
       "      <td>Tel Aviv</td>\n",
       "      <td>Israel</td>\n",
       "      <td>1/4/09 13:03</td>\n",
       "      <td>1/4/09 22:10</td>\n",
       "      <td>32.066667</td>\n",
       "      <td>34.766667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1/2/09 9:16</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Sean</td>\n",
       "      <td>Shavano Park</td>\n",
       "      <td>TX</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/2/09 8:32</td>\n",
       "      <td>1/5/09 9:05</td>\n",
       "      <td>29.423890</td>\n",
       "      <td>-98.493330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1/5/09 4:10</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Nicola</td>\n",
       "      <td>Roodepoort</td>\n",
       "      <td>Gauteng</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>1/5/09 2:33</td>\n",
       "      <td>1/7/09 5:13</td>\n",
       "      <td>-26.166667</td>\n",
       "      <td>27.866667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1/2/09 1:11</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Lena</td>\n",
       "      <td>Kuopio</td>\n",
       "      <td>Ita-Suomen Laani</td>\n",
       "      <td>Finland</td>\n",
       "      <td>12/31/08 2:48</td>\n",
       "      <td>1/7/09 10:20</td>\n",
       "      <td>62.900000</td>\n",
       "      <td>27.683333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>1/8/09 3:56</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Katherine</td>\n",
       "      <td>New York</td>\n",
       "      <td>NY</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/8/09 3:33</td>\n",
       "      <td>1/8/09 6:19</td>\n",
       "      <td>40.714170</td>\n",
       "      <td>-74.006390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>1/8/09 3:16</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Linda</td>\n",
       "      <td>Miami</td>\n",
       "      <td>FL</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/8/09 3:06</td>\n",
       "      <td>1/8/09 6:34</td>\n",
       "      <td>25.773890</td>\n",
       "      <td>-80.193890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1/8/09 1:59</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>SYLVIA</td>\n",
       "      <td>Vesenaz</td>\n",
       "      <td>Geneve</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>11/28/07 11:56</td>\n",
       "      <td>1/8/09 7:20</td>\n",
       "      <td>46.233333</td>\n",
       "      <td>6.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>1/5/09 13:17</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Stephanie</td>\n",
       "      <td>Badhoevedorp</td>\n",
       "      <td>Noord-Holland</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>1/5/09 12:45</td>\n",
       "      <td>1/8/09 11:45</td>\n",
       "      <td>52.333333</td>\n",
       "      <td>4.783333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>1/9/09 6:39</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Anneli</td>\n",
       "      <td>Houston</td>\n",
       "      <td>TX</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/9/09 5:09</td>\n",
       "      <td>1/9/09 7:11</td>\n",
       "      <td>29.763060</td>\n",
       "      <td>-95.363060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>1/7/09 7:44</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Marie</td>\n",
       "      <td>Ball Ground</td>\n",
       "      <td>GA</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/7/09 5:35</td>\n",
       "      <td>1/9/09 10:52</td>\n",
       "      <td>34.338060</td>\n",
       "      <td>-84.376670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>1/9/09 15:58</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Sari</td>\n",
       "      <td>Newbury</td>\n",
       "      <td>England</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>1/9/09 14:53</td>\n",
       "      <td>1/10/09 13:16</td>\n",
       "      <td>51.400000</td>\n",
       "      <td>-1.316667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>1/3/09 13:11</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>simone</td>\n",
       "      <td>Kobenhavn</td>\n",
       "      <td>Kobenhavn</td>\n",
       "      <td>Denmark</td>\n",
       "      <td>10/31/08 0:31</td>\n",
       "      <td>1/10/09 13:24</td>\n",
       "      <td>55.666667</td>\n",
       "      <td>12.583333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>1/6/09 1:20</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Frank</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>Victoria</td>\n",
       "      <td>Australia</td>\n",
       "      <td>1/2/09 17:51</td>\n",
       "      <td>1/10/09 18:27</td>\n",
       "      <td>-37.816667</td>\n",
       "      <td>144.966667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>1/1/09 1:26</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Nikki</td>\n",
       "      <td>New Rochelle</td>\n",
       "      <td>NY</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/1/09 0:58</td>\n",
       "      <td>1/10/09 21:31</td>\n",
       "      <td>40.911390</td>\n",
       "      <td>-73.782780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>1/7/09 6:18</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>June</td>\n",
       "      <td>Beachwood</td>\n",
       "      <td>OH</td>\n",
       "      <td>United States</td>\n",
       "      <td>2/23/06 11:56</td>\n",
       "      <td>1/11/09 19:35</td>\n",
       "      <td>41.464440</td>\n",
       "      <td>-81.508890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>1/5/09 0:31</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Bonnie</td>\n",
       "      <td>Saltsjobaden</td>\n",
       "      <td>Stockholm</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>1/4/09 23:45</td>\n",
       "      <td>1/12/09 0:37</td>\n",
       "      <td>59.283333</td>\n",
       "      <td>18.300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>1/12/09 3:25</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>chrissy</td>\n",
       "      <td>W Lebanon</td>\n",
       "      <td>NH</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/12/09 3:12</td>\n",
       "      <td>1/12/09 3:22</td>\n",
       "      <td>43.649170</td>\n",
       "      <td>-72.310830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>1/4/09 13:56</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Tamar</td>\n",
       "      <td>Headley</td>\n",
       "      <td>England</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>11/29/07 9:23</td>\n",
       "      <td>1/12/09 5:38</td>\n",
       "      <td>51.116667</td>\n",
       "      <td>-0.816667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>1/7/09 0:12</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Deirdre</td>\n",
       "      <td>Lausanne</td>\n",
       "      <td>Vaud</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>12/1/08 6:25</td>\n",
       "      <td>1/12/09 6:55</td>\n",
       "      <td>46.533333</td>\n",
       "      <td>6.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>1/12/09 5:18</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Bernadett</td>\n",
       "      <td>Southampton</td>\n",
       "      <td>England</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>1/12/09 4:45</td>\n",
       "      <td>1/12/09 8:08</td>\n",
       "      <td>50.900000</td>\n",
       "      <td>-1.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>1/5/09 13:52</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Tammy</td>\n",
       "      <td>Morges</td>\n",
       "      <td>Vaud</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>1/5/09 5:55</td>\n",
       "      <td>1/12/09 14:04</td>\n",
       "      <td>46.516667</td>\n",
       "      <td>6.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>1/11/09 10:38</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>AnaPaula</td>\n",
       "      <td>Helens Bay</td>\n",
       "      <td>Northern Ireland</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>9/4/08 9:26</td>\n",
       "      <td>1/13/09 2:36</td>\n",
       "      <td>54.650000</td>\n",
       "      <td>-5.733333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>1/3/09 15:22</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Lindi</td>\n",
       "      <td>Vancouver</td>\n",
       "      <td>British Columbia</td>\n",
       "      <td>Canada</td>\n",
       "      <td>2/20/08 22:45</td>\n",
       "      <td>1/13/09 23:02</td>\n",
       "      <td>49.250000</td>\n",
       "      <td>-123.133333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>1/12/09 3:03</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Valda</td>\n",
       "      <td>Irvine</td>\n",
       "      <td>CA</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/12/09 2:48</td>\n",
       "      <td>1/14/09 1:07</td>\n",
       "      <td>33.669440</td>\n",
       "      <td>-117.822220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>1/5/09 8:58</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Marcia</td>\n",
       "      <td>Telgte</td>\n",
       "      <td>Nordrhein-Westfalen</td>\n",
       "      <td>Germany</td>\n",
       "      <td>9/1/08 3:39</td>\n",
       "      <td>1/14/09 2:07</td>\n",
       "      <td>52.333333</td>\n",
       "      <td>7.900000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>1/10/09 14:03</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Kevin</td>\n",
       "      <td>Cheltenham</td>\n",
       "      <td>England</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>3/13/06 4:56</td>\n",
       "      <td>1/14/09 2:22</td>\n",
       "      <td>51.900000</td>\n",
       "      <td>-2.083333</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>904</th>\n",
       "      <td>1/30/09 10:31</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>lorna</td>\n",
       "      <td>Castle Rock</td>\n",
       "      <td>CO</td>\n",
       "      <td>United States</td>\n",
       "      <td>10/6/08 16:31</td>\n",
       "      <td>2/25/09 7:42</td>\n",
       "      <td>39.372220</td>\n",
       "      <td>-104.855560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>908</th>\n",
       "      <td>1/23/09 9:27</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Jerome</td>\n",
       "      <td>Madrid</td>\n",
       "      <td>Madrid</td>\n",
       "      <td>Spain</td>\n",
       "      <td>2/19/08 2:01</td>\n",
       "      <td>2/25/09 11:38</td>\n",
       "      <td>40.400000</td>\n",
       "      <td>-3.683333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>912</th>\n",
       "      <td>1/25/09 11:35</td>\n",
       "      <td>Product3</td>\n",
       "      <td>7500</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Anita</td>\n",
       "      <td>Fresno</td>\n",
       "      <td>TX</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/24/09 9:24</td>\n",
       "      <td>2/25/09 14:22</td>\n",
       "      <td>29.538610</td>\n",
       "      <td>-95.447220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>913</th>\n",
       "      <td>1/26/09 14:02</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Veronique</td>\n",
       "      <td>Fresno</td>\n",
       "      <td>TX</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/24/09 9:24</td>\n",
       "      <td>2/25/09 14:22</td>\n",
       "      <td>29.538610</td>\n",
       "      <td>-95.447220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>920</th>\n",
       "      <td>1/16/09 10:27</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Maki</td>\n",
       "      <td>Montgomery</td>\n",
       "      <td>TX</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/15/09 8:52</td>\n",
       "      <td>2/25/09 17:24</td>\n",
       "      <td>30.388060</td>\n",
       "      <td>-95.696110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>922</th>\n",
       "      <td>1/25/09 18:33</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Sarah</td>\n",
       "      <td>Manteno</td>\n",
       "      <td>IL</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/25/09 15:56</td>\n",
       "      <td>2/25/09 19:27</td>\n",
       "      <td>41.250560</td>\n",
       "      <td>-87.831390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>923</th>\n",
       "      <td>1/16/09 6:13</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Niamh</td>\n",
       "      <td>Benoni</td>\n",
       "      <td>Gauteng</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>1/16/09 5:22</td>\n",
       "      <td>2/25/09 23:19</td>\n",
       "      <td>-26.183333</td>\n",
       "      <td>28.316667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>930</th>\n",
       "      <td>1/2/09 7:30</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Fiona</td>\n",
       "      <td>Lake Ronkonkoma</td>\n",
       "      <td>NY</td>\n",
       "      <td>United States</td>\n",
       "      <td>10/27/08 0:00</td>\n",
       "      <td>2/26/09 6:14</td>\n",
       "      <td>40.835000</td>\n",
       "      <td>-73.131670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>937</th>\n",
       "      <td>1/21/09 10:32</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Julie</td>\n",
       "      <td>Chelmsford</td>\n",
       "      <td>MA</td>\n",
       "      <td>United States</td>\n",
       "      <td>5/23/07 11:55</td>\n",
       "      <td>2/26/09 8:38</td>\n",
       "      <td>42.599720</td>\n",
       "      <td>-71.367780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>938</th>\n",
       "      <td>1/29/09 12:27</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>philippa katherine</td>\n",
       "      <td>Cabinteely</td>\n",
       "      <td>Dublin</td>\n",
       "      <td>Ireland</td>\n",
       "      <td>11/8/06 4:50</td>\n",
       "      <td>2/26/09 10:09</td>\n",
       "      <td>53.259444</td>\n",
       "      <td>-6.144722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>939</th>\n",
       "      <td>1/13/09 13:19</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Anthony</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>Ontario</td>\n",
       "      <td>Canada</td>\n",
       "      <td>3/16/06 19:11</td>\n",
       "      <td>2/26/09 11:19</td>\n",
       "      <td>43.666667</td>\n",
       "      <td>-79.416667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>943</th>\n",
       "      <td>1/23/09 11:23</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Lauren</td>\n",
       "      <td>Poughkeepsie</td>\n",
       "      <td>NY</td>\n",
       "      <td>United States</td>\n",
       "      <td>8/26/08 9:37</td>\n",
       "      <td>2/26/09 12:17</td>\n",
       "      <td>41.700280</td>\n",
       "      <td>-73.921390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>944</th>\n",
       "      <td>1/7/09 20:55</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Esther</td>\n",
       "      <td>Cincinnati</td>\n",
       "      <td>OH</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/7/09 20:25</td>\n",
       "      <td>2/26/09 12:24</td>\n",
       "      <td>39.161940</td>\n",
       "      <td>-84.456940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>947</th>\n",
       "      <td>1/30/09 20:58</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Tanya</td>\n",
       "      <td>Carcross</td>\n",
       "      <td>Yukon Territory</td>\n",
       "      <td>Canada</td>\n",
       "      <td>1/30/09 14:05</td>\n",
       "      <td>2/26/09 13:06</td>\n",
       "      <td>60.183333</td>\n",
       "      <td>-134.716667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>948</th>\n",
       "      <td>1/31/09 4:50</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Detlev</td>\n",
       "      <td>Taby</td>\n",
       "      <td>Stockholm</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>1/12/09 1:03</td>\n",
       "      <td>2/26/09 13:12</td>\n",
       "      <td>59.500000</td>\n",
       "      <td>18.050000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>952</th>\n",
       "      <td>1/3/09 11:03</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>paula</td>\n",
       "      <td>Sammamish</td>\n",
       "      <td>WA</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/1/09 22:43</td>\n",
       "      <td>2/26/09 15:30</td>\n",
       "      <td>47.641940</td>\n",
       "      <td>-122.079170</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>954</th>\n",
       "      <td>1/5/09 7:55</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Isabelle</td>\n",
       "      <td>Ewa Beach</td>\n",
       "      <td>HI</td>\n",
       "      <td>United States</td>\n",
       "      <td>12/31/08 7:40</td>\n",
       "      <td>2/26/09 17:47</td>\n",
       "      <td>21.315560</td>\n",
       "      <td>-158.007220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>958</th>\n",
       "      <td>1/22/09 3:57</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Parth</td>\n",
       "      <td>Oegstgeest</td>\n",
       "      <td>Zuid-Holland</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>1/20/09 14:36</td>\n",
       "      <td>2/27/09 1:59</td>\n",
       "      <td>52.183333</td>\n",
       "      <td>4.466667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>960</th>\n",
       "      <td>1/25/09 11:52</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Gloria Gail</td>\n",
       "      <td>WalcProduct3ee</td>\n",
       "      <td>Tyrol</td>\n",
       "      <td>Austria</td>\n",
       "      <td>1/25/09 5:03</td>\n",
       "      <td>2/27/09 5:37</td>\n",
       "      <td>47.650000</td>\n",
       "      <td>12.316667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>962</th>\n",
       "      <td>1/10/09 9:32</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Cheryl</td>\n",
       "      <td>Hilton Head</td>\n",
       "      <td>SC</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/10/05 21:39</td>\n",
       "      <td>2/27/09 7:33</td>\n",
       "      <td>32.216110</td>\n",
       "      <td>-80.752780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>964</th>\n",
       "      <td>1/6/09 18:11</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Triona</td>\n",
       "      <td>Swampscott</td>\n",
       "      <td>MA</td>\n",
       "      <td>United States</td>\n",
       "      <td>6/9/06 8:57</td>\n",
       "      <td>2/27/09 13:00</td>\n",
       "      <td>42.470830</td>\n",
       "      <td>-70.918060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>969</th>\n",
       "      <td>1/7/09 18:15</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Selma</td>\n",
       "      <td>Greenville</td>\n",
       "      <td>TX</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/5/09 18:16</td>\n",
       "      <td>2/27/09 19:07</td>\n",
       "      <td>33.138330</td>\n",
       "      <td>-96.110560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>974</th>\n",
       "      <td>1/22/09 11:10</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Gustavo</td>\n",
       "      <td>Voluntari</td>\n",
       "      <td>Bucuresti</td>\n",
       "      <td>Romania</td>\n",
       "      <td>7/28/08 11:12</td>\n",
       "      <td>2/28/09 7:52</td>\n",
       "      <td>44.466667</td>\n",
       "      <td>26.133333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>979</th>\n",
       "      <td>1/23/09 10:04</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Kevin</td>\n",
       "      <td>Hollywood</td>\n",
       "      <td>CA</td>\n",
       "      <td>United States</td>\n",
       "      <td>5/30/06 20:25</td>\n",
       "      <td>2/28/09 9:59</td>\n",
       "      <td>34.098330</td>\n",
       "      <td>-118.325830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>982</th>\n",
       "      <td>1/4/09 18:57</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>KELI</td>\n",
       "      <td>Worongary</td>\n",
       "      <td>Queensland</td>\n",
       "      <td>Australia</td>\n",
       "      <td>12/23/08 15:17</td>\n",
       "      <td>2/28/09 14:00</td>\n",
       "      <td>-28.050000</td>\n",
       "      <td>153.350000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>986</th>\n",
       "      <td>1/7/09 17:48</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Augusta</td>\n",
       "      <td>GA</td>\n",
       "      <td>United States</td>\n",
       "      <td>6/10/05 20:25</td>\n",
       "      <td>2/28/09 19:57</td>\n",
       "      <td>33.517220</td>\n",
       "      <td>-82.075830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>987</th>\n",
       "      <td>1/23/09 12:42</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Anke</td>\n",
       "      <td>Avalon</td>\n",
       "      <td>New South Wales</td>\n",
       "      <td>Australia</td>\n",
       "      <td>3/3/08 17:38</td>\n",
       "      <td>2/28/09 22:26</td>\n",
       "      <td>-33.633333</td>\n",
       "      <td>151.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>988</th>\n",
       "      <td>1/7/09 19:48</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>TRICIA</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>New South Wales</td>\n",
       "      <td>Australia</td>\n",
       "      <td>9/21/08 20:49</td>\n",
       "      <td>3/1/09 0:14</td>\n",
       "      <td>-33.883333</td>\n",
       "      <td>151.216667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>989</th>\n",
       "      <td>1/26/09 11:19</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>smith</td>\n",
       "      <td>Lahti</td>\n",
       "      <td>Etela-Suomen Laani</td>\n",
       "      <td>Finland</td>\n",
       "      <td>1/4/09 5:25</td>\n",
       "      <td>3/1/09 0:39</td>\n",
       "      <td>60.966667</td>\n",
       "      <td>25.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>991</th>\n",
       "      <td>1/26/09 13:41</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Lesleigh</td>\n",
       "      <td>Baden</td>\n",
       "      <td>Aargau</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>10/23/05 9:23</td>\n",
       "      <td>3/1/09 3:11</td>\n",
       "      <td>47.466667</td>\n",
       "      <td>8.300000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>277 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Transaction_date   Product Price Payment_Type                Name  \\\n",
       "0        1/2/09 6:17  Product1  1200   Mastercard            carolina   \n",
       "2       1/2/09 13:08  Product1  1200   Mastercard   Federica e Andrea   \n",
       "6       1/4/09 20:11  Product1  1200   Mastercard               Fleur   \n",
       "7       1/2/09 20:09  Product1  1200   Mastercard                adam   \n",
       "8       1/4/09 13:17  Product1  1200   Mastercard     Renee Elisabeth   \n",
       "12       1/2/09 9:16  Product1  1200   Mastercard               Sean    \n",
       "22       1/5/09 4:10  Product1  1200   Mastercard              Nicola   \n",
       "24       1/2/09 1:11  Product1  1200   Mastercard                Lena   \n",
       "30       1/8/09 3:56  Product1  1200   Mastercard           Katherine   \n",
       "31       1/8/09 3:16  Product1  1200   Mastercard               Linda   \n",
       "32       1/8/09 1:59  Product1  1200   Mastercard              SYLVIA   \n",
       "34      1/5/09 13:17  Product1  1200   Mastercard           Stephanie   \n",
       "38       1/9/09 6:39  Product1  1200   Mastercard              Anneli   \n",
       "41       1/7/09 7:44  Product1  1200   Mastercard               Marie   \n",
       "46      1/9/09 15:58  Product1  1200   Mastercard                Sari   \n",
       "47      1/3/09 13:11  Product1  1200   Mastercard              simone   \n",
       "51       1/6/09 1:20  Product1  1200   Mastercard               Frank   \n",
       "54       1/1/09 1:26  Product1  1200   Mastercard               Nikki   \n",
       "58       1/7/09 6:18  Product1  1200   Mastercard               June    \n",
       "60       1/5/09 0:31  Product1  1200   Mastercard              Bonnie   \n",
       "62      1/12/09 3:25  Product1  1200   Mastercard             chrissy   \n",
       "63      1/4/09 13:56  Product1  1200   Mastercard               Tamar   \n",
       "64       1/7/09 0:12  Product2  3600   Mastercard             Deirdre   \n",
       "65      1/12/09 5:18  Product1  1200   Mastercard           Bernadett   \n",
       "70      1/5/09 13:52  Product1  1200   Mastercard               Tammy   \n",
       "76     1/11/09 10:38  Product1  1200   Mastercard            AnaPaula   \n",
       "83      1/3/09 15:22  Product1  1200   Mastercard               Lindi   \n",
       "84      1/12/09 3:03  Product2  3600   Mastercard               Valda   \n",
       "85       1/5/09 8:58  Product2  3600   Mastercard              Marcia   \n",
       "86     1/10/09 14:03  Product1  1200   Mastercard               Kevin   \n",
       "..               ...       ...   ...          ...                 ...   \n",
       "904    1/30/09 10:31  Product1  1200   Mastercard               lorna   \n",
       "908     1/23/09 9:27  Product1  1200   Mastercard              Jerome   \n",
       "912    1/25/09 11:35  Product3  7500   Mastercard               Anita   \n",
       "913    1/26/09 14:02  Product1  1200   Mastercard           Veronique   \n",
       "920    1/16/09 10:27  Product1  1200   Mastercard                Maki   \n",
       "922    1/25/09 18:33  Product1  1200   Mastercard               Sarah   \n",
       "923     1/16/09 6:13  Product1  1200   Mastercard               Niamh   \n",
       "930      1/2/09 7:30  Product1  1200   Mastercard               Fiona   \n",
       "937    1/21/09 10:32  Product1  1200   Mastercard              Julie    \n",
       "938    1/29/09 12:27  Product1  1200   Mastercard  philippa katherine   \n",
       "939    1/13/09 13:19  Product2  3600   Mastercard             Anthony   \n",
       "943    1/23/09 11:23  Product1  1200   Mastercard              Lauren   \n",
       "944     1/7/09 20:55  Product1  1200   Mastercard              Esther   \n",
       "947    1/30/09 20:58  Product2  3600   Mastercard               Tanya   \n",
       "948     1/31/09 4:50  Product1  1200   Mastercard              Detlev   \n",
       "952     1/3/09 11:03  Product1  1200   Mastercard               paula   \n",
       "954      1/5/09 7:55  Product1  1200   Mastercard            Isabelle   \n",
       "958     1/22/09 3:57  Product2  3600   Mastercard               Parth   \n",
       "960    1/25/09 11:52  Product2  3600   Mastercard        Gloria Gail    \n",
       "962     1/10/09 9:32  Product2  3600   Mastercard              Cheryl   \n",
       "964     1/6/09 18:11  Product2  3600   Mastercard              Triona   \n",
       "969     1/7/09 18:15  Product1  1200   Mastercard               Selma   \n",
       "974    1/22/09 11:10  Product1  1200   Mastercard             Gustavo   \n",
       "979    1/23/09 10:04  Product1  1200   Mastercard               Kevin   \n",
       "982     1/4/09 18:57  Product1  1200   Mastercard                KELI   \n",
       "986     1/7/09 17:48  Product1  1200   Mastercard                Alex   \n",
       "987    1/23/09 12:42  Product2  3600   Mastercard                Anke   \n",
       "988     1/7/09 19:48  Product2  3600   Mastercard              TRICIA   \n",
       "989    1/26/09 11:19  Product1  1200   Mastercard               smith   \n",
       "991    1/26/09 13:41  Product1  1200   Mastercard            Lesleigh   \n",
       "\n",
       "                             City                State         Country  \\\n",
       "0                        Basildon              England  United Kingdom   \n",
       "2    Astoria                                        OR   United States   \n",
       "6    Peoria                                         IL   United States   \n",
       "7    Martin                                         TN   United States   \n",
       "8                        Tel Aviv             Tel Aviv          Israel   \n",
       "12   Shavano Park                                   TX   United States   \n",
       "22                     Roodepoort              Gauteng    South Africa   \n",
       "24                         Kuopio     Ita-Suomen Laani         Finland   \n",
       "30   New York                                       NY   United States   \n",
       "31   Miami                                          FL   United States   \n",
       "32                        Vesenaz               Geneve     Switzerland   \n",
       "34                   Badhoevedorp        Noord-Holland     Netherlands   \n",
       "38   Houston                                        TX   United States   \n",
       "41   Ball Ground                                    GA   United States   \n",
       "46                        Newbury              England  United Kingdom   \n",
       "47                      Kobenhavn            Kobenhavn         Denmark   \n",
       "51                      Melbourne             Victoria       Australia   \n",
       "54   New Rochelle                                   NY   United States   \n",
       "58   Beachwood                                      OH   United States   \n",
       "60                   Saltsjobaden            Stockholm          Sweden   \n",
       "62   W Lebanon                                      NH   United States   \n",
       "63                        Headley              England  United Kingdom   \n",
       "64                       Lausanne                 Vaud     Switzerland   \n",
       "65                    Southampton              England  United Kingdom   \n",
       "70                         Morges                 Vaud     Switzerland   \n",
       "76                     Helens Bay     Northern Ireland  United Kingdom   \n",
       "83                      Vancouver     British Columbia          Canada   \n",
       "84   Irvine                                         CA   United States   \n",
       "85                         Telgte  Nordrhein-Westfalen         Germany   \n",
       "86                     Cheltenham              England  United Kingdom   \n",
       "..                            ...                  ...             ...   \n",
       "904  Castle Rock                                    CO   United States   \n",
       "908                        Madrid               Madrid           Spain   \n",
       "912  Fresno                                         TX   United States   \n",
       "913  Fresno                                         TX   United States   \n",
       "920  Montgomery                                     TX   United States   \n",
       "922  Manteno                                        IL   United States   \n",
       "923                        Benoni              Gauteng    South Africa   \n",
       "930               Lake Ronkonkoma                   NY   United States   \n",
       "937  Chelmsford                                     MA   United States   \n",
       "938                    Cabinteely               Dublin         Ireland   \n",
       "939                       Toronto              Ontario          Canada   \n",
       "943  Poughkeepsie                                   NY   United States   \n",
       "944  Cincinnati                                     OH   United States   \n",
       "947                      Carcross      Yukon Territory          Canada   \n",
       "948                          Taby            Stockholm          Sweden   \n",
       "952  Sammamish                                      WA   United States   \n",
       "954  Ewa Beach                                      HI   United States   \n",
       "958                    Oegstgeest         Zuid-Holland     Netherlands   \n",
       "960                WalcProduct3ee                Tyrol         Austria   \n",
       "962  Hilton Head                                    SC   United States   \n",
       "964  Swampscott                                     MA   United States   \n",
       "969  Greenville                                     TX   United States   \n",
       "974                     Voluntari            Bucuresti         Romania   \n",
       "979  Hollywood                                      CA   United States   \n",
       "982                     Worongary           Queensland       Australia   \n",
       "986  Augusta                                        GA   United States   \n",
       "987                        Avalon      New South Wales       Australia   \n",
       "988                        Sydney      New South Wales       Australia   \n",
       "989                         Lahti   Etela-Suomen Laani         Finland   \n",
       "991                         Baden               Aargau     Switzerland   \n",
       "\n",
       "    Account_Created     Last_Login   Latitude   Longitude  \n",
       "0       1/2/09 6:00    1/2/09 6:08  51.500000   -1.116667  \n",
       "2      1/1/09 16:21   1/3/09 12:32  46.188060 -123.830000  \n",
       "6       1/3/09 9:38   1/4/09 19:45  40.693610  -89.588890  \n",
       "7      1/2/09 17:43   1/4/09 20:01  36.343330  -88.850280  \n",
       "8      1/4/09 13:03   1/4/09 22:10  32.066667   34.766667  \n",
       "12      1/2/09 8:32    1/5/09 9:05  29.423890  -98.493330  \n",
       "22      1/5/09 2:33    1/7/09 5:13 -26.166667   27.866667  \n",
       "24    12/31/08 2:48   1/7/09 10:20  62.900000   27.683333  \n",
       "30      1/8/09 3:33    1/8/09 6:19  40.714170  -74.006390  \n",
       "31      1/8/09 3:06    1/8/09 6:34  25.773890  -80.193890  \n",
       "32   11/28/07 11:56    1/8/09 7:20  46.233333    6.200000  \n",
       "34     1/5/09 12:45   1/8/09 11:45  52.333333    4.783333  \n",
       "38      1/9/09 5:09    1/9/09 7:11  29.763060  -95.363060  \n",
       "41      1/7/09 5:35   1/9/09 10:52  34.338060  -84.376670  \n",
       "46     1/9/09 14:53  1/10/09 13:16  51.400000   -1.316667  \n",
       "47    10/31/08 0:31  1/10/09 13:24  55.666667   12.583333  \n",
       "51     1/2/09 17:51  1/10/09 18:27 -37.816667  144.966667  \n",
       "54      1/1/09 0:58  1/10/09 21:31  40.911390  -73.782780  \n",
       "58    2/23/06 11:56  1/11/09 19:35  41.464440  -81.508890  \n",
       "60     1/4/09 23:45   1/12/09 0:37  59.283333   18.300000  \n",
       "62     1/12/09 3:12   1/12/09 3:22  43.649170  -72.310830  \n",
       "63    11/29/07 9:23   1/12/09 5:38  51.116667   -0.816667  \n",
       "64     12/1/08 6:25   1/12/09 6:55  46.533333    6.666667  \n",
       "65     1/12/09 4:45   1/12/09 8:08  50.900000   -1.400000  \n",
       "70      1/5/09 5:55  1/12/09 14:04  46.516667    6.500000  \n",
       "76      9/4/08 9:26   1/13/09 2:36  54.650000   -5.733333  \n",
       "83    2/20/08 22:45  1/13/09 23:02  49.250000 -123.133333  \n",
       "84     1/12/09 2:48   1/14/09 1:07  33.669440 -117.822220  \n",
       "85      9/1/08 3:39   1/14/09 2:07  52.333333    7.900000  \n",
       "86     3/13/06 4:56   1/14/09 2:22  51.900000   -2.083333  \n",
       "..              ...            ...        ...         ...  \n",
       "904   10/6/08 16:31   2/25/09 7:42  39.372220 -104.855560  \n",
       "908    2/19/08 2:01  2/25/09 11:38  40.400000   -3.683333  \n",
       "912    1/24/09 9:24  2/25/09 14:22  29.538610  -95.447220  \n",
       "913    1/24/09 9:24  2/25/09 14:22  29.538610  -95.447220  \n",
       "920    1/15/09 8:52  2/25/09 17:24  30.388060  -95.696110  \n",
       "922   1/25/09 15:56  2/25/09 19:27  41.250560  -87.831390  \n",
       "923    1/16/09 5:22  2/25/09 23:19 -26.183333   28.316667  \n",
       "930   10/27/08 0:00   2/26/09 6:14  40.835000  -73.131670  \n",
       "937   5/23/07 11:55   2/26/09 8:38  42.599720  -71.367780  \n",
       "938    11/8/06 4:50  2/26/09 10:09  53.259444   -6.144722  \n",
       "939   3/16/06 19:11  2/26/09 11:19  43.666667  -79.416667  \n",
       "943    8/26/08 9:37  2/26/09 12:17  41.700280  -73.921390  \n",
       "944    1/7/09 20:25  2/26/09 12:24  39.161940  -84.456940  \n",
       "947   1/30/09 14:05  2/26/09 13:06  60.183333 -134.716667  \n",
       "948    1/12/09 1:03  2/26/09 13:12  59.500000   18.050000  \n",
       "952    1/1/09 22:43  2/26/09 15:30  47.641940 -122.079170  \n",
       "954   12/31/08 7:40  2/26/09 17:47  21.315560 -158.007220  \n",
       "958   1/20/09 14:36   2/27/09 1:59  52.183333    4.466667  \n",
       "960    1/25/09 5:03   2/27/09 5:37  47.650000   12.316667  \n",
       "962   1/10/05 21:39   2/27/09 7:33  32.216110  -80.752780  \n",
       "964     6/9/06 8:57  2/27/09 13:00  42.470830  -70.918060  \n",
       "969    1/5/09 18:16  2/27/09 19:07  33.138330  -96.110560  \n",
       "974   7/28/08 11:12   2/28/09 7:52  44.466667   26.133333  \n",
       "979   5/30/06 20:25   2/28/09 9:59  34.098330 -118.325830  \n",
       "982  12/23/08 15:17  2/28/09 14:00 -28.050000  153.350000  \n",
       "986   6/10/05 20:25  2/28/09 19:57  33.517220  -82.075830  \n",
       "987    3/3/08 17:38  2/28/09 22:26 -33.633333  151.333333  \n",
       "988   9/21/08 20:49    3/1/09 0:14 -33.883333  151.216667  \n",
       "989     1/4/09 5:25    3/1/09 0:39  60.966667   25.666667  \n",
       "991   10/23/05 9:23    3/1/09 3:11  47.466667    8.300000  \n",
       "\n",
       "[277 rows x 12 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mastercard"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Para saber rápidamente cuántas transacciones cumplen con aquella condición, usamos el método ```len```."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "277"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(mastercard)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Comparando con el tamaño del dataset original:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "998"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(dataset)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "También podríamos querer saber cuántas de estas transacciones se realizaron con Mastercard y en Estados Unidos:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Transaction_date</th>\n",
       "      <th>Product</th>\n",
       "      <th>Price</th>\n",
       "      <th>Payment_Type</th>\n",
       "      <th>Name</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Country</th>\n",
       "      <th>Account_Created</th>\n",
       "      <th>Last_Login</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1/2/09 13:08</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Federica e Andrea</td>\n",
       "      <td>Astoria</td>\n",
       "      <td>OR</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/1/09 16:21</td>\n",
       "      <td>1/3/09 12:32</td>\n",
       "      <td>46.18806</td>\n",
       "      <td>-123.83000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1/4/09 20:11</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Fleur</td>\n",
       "      <td>Peoria</td>\n",
       "      <td>IL</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/3/09 9:38</td>\n",
       "      <td>1/4/09 19:45</td>\n",
       "      <td>40.69361</td>\n",
       "      <td>-89.58889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1/2/09 20:09</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>adam</td>\n",
       "      <td>Martin</td>\n",
       "      <td>TN</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/2/09 17:43</td>\n",
       "      <td>1/4/09 20:01</td>\n",
       "      <td>36.34333</td>\n",
       "      <td>-88.85028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1/2/09 9:16</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Sean</td>\n",
       "      <td>Shavano Park</td>\n",
       "      <td>TX</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/2/09 8:32</td>\n",
       "      <td>1/5/09 9:05</td>\n",
       "      <td>29.42389</td>\n",
       "      <td>-98.49333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>1/8/09 3:56</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Katherine</td>\n",
       "      <td>New York</td>\n",
       "      <td>NY</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/8/09 3:33</td>\n",
       "      <td>1/8/09 6:19</td>\n",
       "      <td>40.71417</td>\n",
       "      <td>-74.00639</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>1/8/09 3:16</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Linda</td>\n",
       "      <td>Miami</td>\n",
       "      <td>FL</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/8/09 3:06</td>\n",
       "      <td>1/8/09 6:34</td>\n",
       "      <td>25.77389</td>\n",
       "      <td>-80.19389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>1/9/09 6:39</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Anneli</td>\n",
       "      <td>Houston</td>\n",
       "      <td>TX</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/9/09 5:09</td>\n",
       "      <td>1/9/09 7:11</td>\n",
       "      <td>29.76306</td>\n",
       "      <td>-95.36306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>1/7/09 7:44</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Marie</td>\n",
       "      <td>Ball Ground</td>\n",
       "      <td>GA</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/7/09 5:35</td>\n",
       "      <td>1/9/09 10:52</td>\n",
       "      <td>34.33806</td>\n",
       "      <td>-84.37667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>1/1/09 1:26</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Nikki</td>\n",
       "      <td>New Rochelle</td>\n",
       "      <td>NY</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/1/09 0:58</td>\n",
       "      <td>1/10/09 21:31</td>\n",
       "      <td>40.91139</td>\n",
       "      <td>-73.78278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>1/7/09 6:18</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>June</td>\n",
       "      <td>Beachwood</td>\n",
       "      <td>OH</td>\n",
       "      <td>United States</td>\n",
       "      <td>2/23/06 11:56</td>\n",
       "      <td>1/11/09 19:35</td>\n",
       "      <td>41.46444</td>\n",
       "      <td>-81.50889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>1/12/09 3:25</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>chrissy</td>\n",
       "      <td>W Lebanon</td>\n",
       "      <td>NH</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/12/09 3:12</td>\n",
       "      <td>1/12/09 3:22</td>\n",
       "      <td>43.64917</td>\n",
       "      <td>-72.31083</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>1/12/09 3:03</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Valda</td>\n",
       "      <td>Irvine</td>\n",
       "      <td>CA</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/12/09 2:48</td>\n",
       "      <td>1/14/09 1:07</td>\n",
       "      <td>33.66944</td>\n",
       "      <td>-117.82222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>1/14/09 4:54</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>ZENA</td>\n",
       "      <td>Honolulu</td>\n",
       "      <td>HI</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/14/09 4:34</td>\n",
       "      <td>1/14/09 4:43</td>\n",
       "      <td>21.30694</td>\n",
       "      <td>-157.85833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>1/13/09 23:56</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Tod</td>\n",
       "      <td>Coral Gables</td>\n",
       "      <td>FL</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/13/09 23:13</td>\n",
       "      <td>1/14/09 15:17</td>\n",
       "      <td>25.72111</td>\n",
       "      <td>-80.26861</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>1/15/09 2:40</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Alexis</td>\n",
       "      <td>Genoa</td>\n",
       "      <td>IL</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/15/09 2:04</td>\n",
       "      <td>1/15/09 2:04</td>\n",
       "      <td>42.09722</td>\n",
       "      <td>-88.69278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>1/15/09 4:12</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>catherine</td>\n",
       "      <td>Keller</td>\n",
       "      <td>VA</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/15/09 4:02</td>\n",
       "      <td>1/15/09 6:59</td>\n",
       "      <td>37.61917</td>\n",
       "      <td>-75.76417</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>1/6/09 10:48</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Bruce and Camille</td>\n",
       "      <td>Clinton</td>\n",
       "      <td>NJ</td>\n",
       "      <td>United States</td>\n",
       "      <td>8/21/07 21:19</td>\n",
       "      <td>1/15/09 9:32</td>\n",
       "      <td>40.63667</td>\n",
       "      <td>-74.91028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>1/14/09 9:10</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Ellen</td>\n",
       "      <td>Owensboro</td>\n",
       "      <td>KY</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/14/09 8:25</td>\n",
       "      <td>1/15/09 9:40</td>\n",
       "      <td>37.77417</td>\n",
       "      <td>-87.11333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>1/16/09 7:21</td>\n",
       "      <td>Product1</td>\n",
       "      <td>2100</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Gerald</td>\n",
       "      <td>Mahopac</td>\n",
       "      <td>NY</td>\n",
       "      <td>United States</td>\n",
       "      <td>11/3/08 14:28</td>\n",
       "      <td>1/16/09 6:08</td>\n",
       "      <td>41.37222</td>\n",
       "      <td>-73.73389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>1/4/09 7:43</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Jamie</td>\n",
       "      <td>Houston</td>\n",
       "      <td>TX</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/4/09 6:51</td>\n",
       "      <td>1/17/09 17:31</td>\n",
       "      <td>29.76306</td>\n",
       "      <td>-95.36306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>1/4/09 17:02</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Clare</td>\n",
       "      <td>Lafayette</td>\n",
       "      <td>CA</td>\n",
       "      <td>United States</td>\n",
       "      <td>12/31/05 0:55</td>\n",
       "      <td>1/18/09 8:43</td>\n",
       "      <td>37.88583</td>\n",
       "      <td>-122.11694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>1/5/09 21:06</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Tracy</td>\n",
       "      <td>Louisville</td>\n",
       "      <td>KY</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/5/09 16:27</td>\n",
       "      <td>1/18/09 13:58</td>\n",
       "      <td>38.25417</td>\n",
       "      <td>-85.75944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>1/12/09 15:12</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>David</td>\n",
       "      <td>Deptford</td>\n",
       "      <td>NJ</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/12/09 14:07</td>\n",
       "      <td>1/19/09 3:47</td>\n",
       "      <td>39.83806</td>\n",
       "      <td>-75.15306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>1/2/09 17:45</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Jammie</td>\n",
       "      <td>Belmont</td>\n",
       "      <td>MA</td>\n",
       "      <td>United States</td>\n",
       "      <td>12/9/05 17:19</td>\n",
       "      <td>1/19/09 15:36</td>\n",
       "      <td>42.39583</td>\n",
       "      <td>-71.17917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>1/19/09 16:10</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Frank</td>\n",
       "      <td>Old Greenwich</td>\n",
       "      <td>CT</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/19/09 15:31</td>\n",
       "      <td>1/19/09 16:00</td>\n",
       "      <td>41.02278</td>\n",
       "      <td>-73.56528</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>1/19/09 16:55</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>scott</td>\n",
       "      <td>Coconut Grove</td>\n",
       "      <td>FL</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/19/09 16:18</td>\n",
       "      <td>1/19/09 16:18</td>\n",
       "      <td>25.71222</td>\n",
       "      <td>-80.25722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>1/19/09 23:06</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Rebecca</td>\n",
       "      <td>Norfolk</td>\n",
       "      <td>VA</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/19/09 22:53</td>\n",
       "      <td>1/19/09 22:53</td>\n",
       "      <td>36.84667</td>\n",
       "      <td>-76.28556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>1/20/09 5:24</td>\n",
       "      <td>Product3</td>\n",
       "      <td>7500</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Amanda</td>\n",
       "      <td>Shreveport</td>\n",
       "      <td>LA</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/20/09 5:13</td>\n",
       "      <td>1/20/09 7:15</td>\n",
       "      <td>32.52500</td>\n",
       "      <td>-93.75000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>1/20/09 6:03</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Andrea</td>\n",
       "      <td>Shreveport</td>\n",
       "      <td>LA</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/20/09 5:13</td>\n",
       "      <td>1/20/09 7:15</td>\n",
       "      <td>32.52500</td>\n",
       "      <td>-93.75000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>1/20/09 12:34</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Anastasia</td>\n",
       "      <td>NYC</td>\n",
       "      <td>NY</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/20/09 12:17</td>\n",
       "      <td>1/20/09 12:55</td>\n",
       "      <td>40.71417</td>\n",
       "      <td>-74.00639</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>790</th>\n",
       "      <td>1/19/09 16:16</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Alexandria</td>\n",
       "      <td>Lebanon</td>\n",
       "      <td>PA</td>\n",
       "      <td>United States</td>\n",
       "      <td>9/3/08 19:26</td>\n",
       "      <td>2/18/09 19:38</td>\n",
       "      <td>40.34083</td>\n",
       "      <td>-76.41167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>807</th>\n",
       "      <td>1/27/09 6:20</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Nathalie</td>\n",
       "      <td>Haymarket</td>\n",
       "      <td>VA</td>\n",
       "      <td>United States</td>\n",
       "      <td>6/1/06 12:04</td>\n",
       "      <td>2/19/09 16:52</td>\n",
       "      <td>38.81194</td>\n",
       "      <td>-77.63667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>822</th>\n",
       "      <td>1/18/09 18:57</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>isabela</td>\n",
       "      <td>Reston</td>\n",
       "      <td>VA</td>\n",
       "      <td>United States</td>\n",
       "      <td>12/31/08 8:16</td>\n",
       "      <td>2/20/09 11:34</td>\n",
       "      <td>38.96861</td>\n",
       "      <td>-77.34139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>829</th>\n",
       "      <td>1/10/09 15:18</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Jo</td>\n",
       "      <td>Huntington Beach</td>\n",
       "      <td>CA</td>\n",
       "      <td>United States</td>\n",
       "      <td>10/17/07 14:56</td>\n",
       "      <td>2/20/09 22:24</td>\n",
       "      <td>33.66028</td>\n",
       "      <td>-117.99833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>836</th>\n",
       "      <td>1/25/09 21:49</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Petra</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/24/09 1:35</td>\n",
       "      <td>2/21/09 9:26</td>\n",
       "      <td>37.77500</td>\n",
       "      <td>-122.41833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>842</th>\n",
       "      <td>1/12/09 12:00</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Tammy</td>\n",
       "      <td>Milford</td>\n",
       "      <td>ME</td>\n",
       "      <td>United States</td>\n",
       "      <td>7/6/08 8:49</td>\n",
       "      <td>2/21/09 18:45</td>\n",
       "      <td>44.94611</td>\n",
       "      <td>-68.64444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>853</th>\n",
       "      <td>1/30/09 9:00</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>james</td>\n",
       "      <td>Nashville</td>\n",
       "      <td>TN</td>\n",
       "      <td>United States</td>\n",
       "      <td>7/4/07 21:35</td>\n",
       "      <td>2/22/09 15:58</td>\n",
       "      <td>36.16583</td>\n",
       "      <td>-86.78444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>855</th>\n",
       "      <td>1/4/09 10:18</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Allison</td>\n",
       "      <td>Naples</td>\n",
       "      <td>FL</td>\n",
       "      <td>United States</td>\n",
       "      <td>11/8/08 9:42</td>\n",
       "      <td>2/22/09 18:36</td>\n",
       "      <td>26.14167</td>\n",
       "      <td>-81.79500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>856</th>\n",
       "      <td>1/23/09 14:57</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Surat</td>\n",
       "      <td>Bridgewater</td>\n",
       "      <td>NJ</td>\n",
       "      <td>United States</td>\n",
       "      <td>7/29/08 12:00</td>\n",
       "      <td>2/22/09 18:48</td>\n",
       "      <td>40.59450</td>\n",
       "      <td>-74.62440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>857</th>\n",
       "      <td>1/12/09 10:08</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Judy</td>\n",
       "      <td>Washington</td>\n",
       "      <td>DC</td>\n",
       "      <td>United States</td>\n",
       "      <td>5/31/08 12:03</td>\n",
       "      <td>2/22/09 18:58</td>\n",
       "      <td>38.89500</td>\n",
       "      <td>-77.03667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>874</th>\n",
       "      <td>1/21/09 7:31</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Beatrice</td>\n",
       "      <td>Wilmington</td>\n",
       "      <td>DE</td>\n",
       "      <td>United States</td>\n",
       "      <td>3/25/08 13:23</td>\n",
       "      <td>2/23/09 16:29</td>\n",
       "      <td>39.74583</td>\n",
       "      <td>-75.54694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>887</th>\n",
       "      <td>1/23/09 13:13</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Malahat</td>\n",
       "      <td>Minneapolis</td>\n",
       "      <td>MN</td>\n",
       "      <td>United States</td>\n",
       "      <td>4/3/07 12:56</td>\n",
       "      <td>2/24/09 8:46</td>\n",
       "      <td>44.98000</td>\n",
       "      <td>-93.26361</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>894</th>\n",
       "      <td>1/27/09 14:42</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Jean</td>\n",
       "      <td>Arlington</td>\n",
       "      <td>VA</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/8/09 11:01</td>\n",
       "      <td>2/24/09 16:38</td>\n",
       "      <td>38.89028</td>\n",
       "      <td>-77.08444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>896</th>\n",
       "      <td>1/29/09 12:16</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Jessica</td>\n",
       "      <td>Chiefland</td>\n",
       "      <td>FL</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/27/09 15:56</td>\n",
       "      <td>2/24/09 18:29</td>\n",
       "      <td>29.47472</td>\n",
       "      <td>-82.86000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>904</th>\n",
       "      <td>1/30/09 10:31</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>lorna</td>\n",
       "      <td>Castle Rock</td>\n",
       "      <td>CO</td>\n",
       "      <td>United States</td>\n",
       "      <td>10/6/08 16:31</td>\n",
       "      <td>2/25/09 7:42</td>\n",
       "      <td>39.37222</td>\n",
       "      <td>-104.85556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>912</th>\n",
       "      <td>1/25/09 11:35</td>\n",
       "      <td>Product3</td>\n",
       "      <td>7500</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Anita</td>\n",
       "      <td>Fresno</td>\n",
       "      <td>TX</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/24/09 9:24</td>\n",
       "      <td>2/25/09 14:22</td>\n",
       "      <td>29.53861</td>\n",
       "      <td>-95.44722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>913</th>\n",
       "      <td>1/26/09 14:02</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Veronique</td>\n",
       "      <td>Fresno</td>\n",
       "      <td>TX</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/24/09 9:24</td>\n",
       "      <td>2/25/09 14:22</td>\n",
       "      <td>29.53861</td>\n",
       "      <td>-95.44722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>920</th>\n",
       "      <td>1/16/09 10:27</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Maki</td>\n",
       "      <td>Montgomery</td>\n",
       "      <td>TX</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/15/09 8:52</td>\n",
       "      <td>2/25/09 17:24</td>\n",
       "      <td>30.38806</td>\n",
       "      <td>-95.69611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>922</th>\n",
       "      <td>1/25/09 18:33</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Sarah</td>\n",
       "      <td>Manteno</td>\n",
       "      <td>IL</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/25/09 15:56</td>\n",
       "      <td>2/25/09 19:27</td>\n",
       "      <td>41.25056</td>\n",
       "      <td>-87.83139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>930</th>\n",
       "      <td>1/2/09 7:30</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Fiona</td>\n",
       "      <td>Lake Ronkonkoma</td>\n",
       "      <td>NY</td>\n",
       "      <td>United States</td>\n",
       "      <td>10/27/08 0:00</td>\n",
       "      <td>2/26/09 6:14</td>\n",
       "      <td>40.83500</td>\n",
       "      <td>-73.13167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>937</th>\n",
       "      <td>1/21/09 10:32</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Julie</td>\n",
       "      <td>Chelmsford</td>\n",
       "      <td>MA</td>\n",
       "      <td>United States</td>\n",
       "      <td>5/23/07 11:55</td>\n",
       "      <td>2/26/09 8:38</td>\n",
       "      <td>42.59972</td>\n",
       "      <td>-71.36778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>943</th>\n",
       "      <td>1/23/09 11:23</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Lauren</td>\n",
       "      <td>Poughkeepsie</td>\n",
       "      <td>NY</td>\n",
       "      <td>United States</td>\n",
       "      <td>8/26/08 9:37</td>\n",
       "      <td>2/26/09 12:17</td>\n",
       "      <td>41.70028</td>\n",
       "      <td>-73.92139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>944</th>\n",
       "      <td>1/7/09 20:55</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Esther</td>\n",
       "      <td>Cincinnati</td>\n",
       "      <td>OH</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/7/09 20:25</td>\n",
       "      <td>2/26/09 12:24</td>\n",
       "      <td>39.16194</td>\n",
       "      <td>-84.45694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>952</th>\n",
       "      <td>1/3/09 11:03</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>paula</td>\n",
       "      <td>Sammamish</td>\n",
       "      <td>WA</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/1/09 22:43</td>\n",
       "      <td>2/26/09 15:30</td>\n",
       "      <td>47.64194</td>\n",
       "      <td>-122.07917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>954</th>\n",
       "      <td>1/5/09 7:55</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Isabelle</td>\n",
       "      <td>Ewa Beach</td>\n",
       "      <td>HI</td>\n",
       "      <td>United States</td>\n",
       "      <td>12/31/08 7:40</td>\n",
       "      <td>2/26/09 17:47</td>\n",
       "      <td>21.31556</td>\n",
       "      <td>-158.00722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>962</th>\n",
       "      <td>1/10/09 9:32</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Cheryl</td>\n",
       "      <td>Hilton Head</td>\n",
       "      <td>SC</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/10/05 21:39</td>\n",
       "      <td>2/27/09 7:33</td>\n",
       "      <td>32.21611</td>\n",
       "      <td>-80.75278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>964</th>\n",
       "      <td>1/6/09 18:11</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Triona</td>\n",
       "      <td>Swampscott</td>\n",
       "      <td>MA</td>\n",
       "      <td>United States</td>\n",
       "      <td>6/9/06 8:57</td>\n",
       "      <td>2/27/09 13:00</td>\n",
       "      <td>42.47083</td>\n",
       "      <td>-70.91806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>969</th>\n",
       "      <td>1/7/09 18:15</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Selma</td>\n",
       "      <td>Greenville</td>\n",
       "      <td>TX</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/5/09 18:16</td>\n",
       "      <td>2/27/09 19:07</td>\n",
       "      <td>33.13833</td>\n",
       "      <td>-96.11056</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>979</th>\n",
       "      <td>1/23/09 10:04</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Kevin</td>\n",
       "      <td>Hollywood</td>\n",
       "      <td>CA</td>\n",
       "      <td>United States</td>\n",
       "      <td>5/30/06 20:25</td>\n",
       "      <td>2/28/09 9:59</td>\n",
       "      <td>34.09833</td>\n",
       "      <td>-118.32583</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>986</th>\n",
       "      <td>1/7/09 17:48</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Augusta</td>\n",
       "      <td>GA</td>\n",
       "      <td>United States</td>\n",
       "      <td>6/10/05 20:25</td>\n",
       "      <td>2/28/09 19:57</td>\n",
       "      <td>33.51722</td>\n",
       "      <td>-82.07583</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>131 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Transaction_date    Product Price Payment_Type               Name  \\\n",
       "2       1/2/09 13:08   Product1  1200   Mastercard  Federica e Andrea   \n",
       "6       1/4/09 20:11   Product1  1200   Mastercard              Fleur   \n",
       "7       1/2/09 20:09   Product1  1200   Mastercard               adam   \n",
       "12       1/2/09 9:16   Product1  1200   Mastercard              Sean    \n",
       "30       1/8/09 3:56   Product1  1200   Mastercard          Katherine   \n",
       "31       1/8/09 3:16   Product1  1200   Mastercard              Linda   \n",
       "38       1/9/09 6:39   Product1  1200   Mastercard             Anneli   \n",
       "41       1/7/09 7:44   Product1  1200   Mastercard              Marie   \n",
       "54       1/1/09 1:26   Product1  1200   Mastercard              Nikki   \n",
       "58       1/7/09 6:18   Product1  1200   Mastercard              June    \n",
       "62      1/12/09 3:25   Product1  1200   Mastercard            chrissy   \n",
       "84      1/12/09 3:03   Product2  3600   Mastercard              Valda   \n",
       "89      1/14/09 4:54   Product1  1200   Mastercard               ZENA   \n",
       "95     1/13/09 23:56   Product1  1200   Mastercard                Tod   \n",
       "101     1/15/09 2:40   Product1  1200   Mastercard             Alexis   \n",
       "106     1/15/09 4:12   Product1  1200   Mastercard          catherine   \n",
       "108     1/6/09 10:48   Product1  1200   Mastercard  Bruce and Camille   \n",
       "109     1/14/09 9:10   Product1  1200   Mastercard              Ellen   \n",
       "121     1/16/09 7:21   Product1  2100   Mastercard             Gerald   \n",
       "137      1/4/09 7:43   Product1  1200   Mastercard              Jamie   \n",
       "145     1/4/09 17:02   Product1  1200   Mastercard              Clare   \n",
       "154     1/5/09 21:06   Product1  1200   Mastercard              Tracy   \n",
       "164    1/12/09 15:12   Product1  1200   Mastercard              David   \n",
       "178     1/2/09 17:45   Product1  1200   Mastercard             Jammie   \n",
       "179    1/19/09 16:10   Product1  1200   Mastercard              Frank   \n",
       "180    1/19/09 16:55   Product1  1200   Mastercard              scott   \n",
       "184    1/19/09 23:06   Product1  1200   Mastercard            Rebecca   \n",
       "189     1/20/09 5:24  Product3   7500   Mastercard             Amanda   \n",
       "190     1/20/09 6:03   Product1  1200   Mastercard            Andrea    \n",
       "198    1/20/09 12:34   Product1  1200   Mastercard          Anastasia   \n",
       "..               ...        ...   ...          ...                ...   \n",
       "790    1/19/09 16:16   Product1  1200   Mastercard         Alexandria   \n",
       "807     1/27/09 6:20   Product1  1200   Mastercard           Nathalie   \n",
       "822    1/18/09 18:57   Product1  1200   Mastercard            isabela   \n",
       "829    1/10/09 15:18   Product2  3600   Mastercard                Jo    \n",
       "836    1/25/09 21:49   Product1  1200   Mastercard              Petra   \n",
       "842    1/12/09 12:00   Product1  1200   Mastercard              Tammy   \n",
       "853     1/30/09 9:00   Product1  1200   Mastercard              james   \n",
       "855     1/4/09 10:18   Product1  1200   Mastercard            Allison   \n",
       "856    1/23/09 14:57   Product1  1200   Mastercard              Surat   \n",
       "857    1/12/09 10:08   Product2  3600   Mastercard               Judy   \n",
       "874     1/21/09 7:31   Product1  1200   Mastercard           Beatrice   \n",
       "887    1/23/09 13:13   Product1  1200   Mastercard            Malahat   \n",
       "894    1/27/09 14:42   Product2  3600   Mastercard               Jean   \n",
       "896    1/29/09 12:16   Product1  1200   Mastercard            Jessica   \n",
       "904    1/30/09 10:31   Product1  1200   Mastercard              lorna   \n",
       "912    1/25/09 11:35   Product3  7500   Mastercard              Anita   \n",
       "913    1/26/09 14:02   Product1  1200   Mastercard          Veronique   \n",
       "920    1/16/09 10:27   Product1  1200   Mastercard               Maki   \n",
       "922    1/25/09 18:33   Product1  1200   Mastercard              Sarah   \n",
       "930      1/2/09 7:30   Product1  1200   Mastercard              Fiona   \n",
       "937    1/21/09 10:32   Product1  1200   Mastercard             Julie    \n",
       "943    1/23/09 11:23   Product1  1200   Mastercard             Lauren   \n",
       "944     1/7/09 20:55   Product1  1200   Mastercard             Esther   \n",
       "952     1/3/09 11:03   Product1  1200   Mastercard              paula   \n",
       "954      1/5/09 7:55   Product1  1200   Mastercard           Isabelle   \n",
       "962     1/10/09 9:32   Product2  3600   Mastercard             Cheryl   \n",
       "964     1/6/09 18:11   Product2  3600   Mastercard             Triona   \n",
       "969     1/7/09 18:15   Product1  1200   Mastercard              Selma   \n",
       "979    1/23/09 10:04   Product1  1200   Mastercard              Kevin   \n",
       "986     1/7/09 17:48   Product1  1200   Mastercard               Alex   \n",
       "\n",
       "                             City State        Country Account_Created  \\\n",
       "2    Astoria                         OR  United States    1/1/09 16:21   \n",
       "6    Peoria                          IL  United States     1/3/09 9:38   \n",
       "7    Martin                          TN  United States    1/2/09 17:43   \n",
       "12   Shavano Park                    TX  United States     1/2/09 8:32   \n",
       "30   New York                        NY  United States     1/8/09 3:33   \n",
       "31   Miami                           FL  United States     1/8/09 3:06   \n",
       "38   Houston                         TX  United States     1/9/09 5:09   \n",
       "41   Ball Ground                     GA  United States     1/7/09 5:35   \n",
       "54   New Rochelle                    NY  United States     1/1/09 0:58   \n",
       "58   Beachwood                       OH  United States   2/23/06 11:56   \n",
       "62   W Lebanon                       NH  United States    1/12/09 3:12   \n",
       "84   Irvine                          CA  United States    1/12/09 2:48   \n",
       "89   Honolulu                        HI  United States    1/14/09 4:34   \n",
       "95   Coral Gables                    FL  United States   1/13/09 23:13   \n",
       "101  Genoa                           IL  United States    1/15/09 2:04   \n",
       "106  Keller                          VA  United States    1/15/09 4:02   \n",
       "108  Clinton                         NJ  United States   8/21/07 21:19   \n",
       "109  Owensboro                       KY  United States    1/14/09 8:25   \n",
       "121  Mahopac                         NY  United States   11/3/08 14:28   \n",
       "137  Houston                         TX  United States     1/4/09 6:51   \n",
       "145  Lafayette                       CA  United States   12/31/05 0:55   \n",
       "154  Louisville                      KY  United States    1/5/09 16:27   \n",
       "164  Deptford                        NJ  United States   1/12/09 14:07   \n",
       "178  Belmont                         MA  United States   12/9/05 17:19   \n",
       "179  Old Greenwich                   CT  United States   1/19/09 15:31   \n",
       "180  Coconut Grove                   FL  United States   1/19/09 16:18   \n",
       "184  Norfolk                         VA  United States   1/19/09 22:53   \n",
       "189  Shreveport                      LA  United States    1/20/09 5:13   \n",
       "190  Shreveport                      LA  United States    1/20/09 5:13   \n",
       "198  NYC                             NY  United States   1/20/09 12:17   \n",
       "..                            ...   ...            ...             ...   \n",
       "790  Lebanon                         PA  United States    9/3/08 19:26   \n",
       "807  Haymarket                       VA  United States    6/1/06 12:04   \n",
       "822  Reston                          VA  United States   12/31/08 8:16   \n",
       "829  Huntington Beach                CA  United States  10/17/07 14:56   \n",
       "836  San Francisco                   CA  United States    1/24/09 1:35   \n",
       "842  Milford                         ME  United States     7/6/08 8:49   \n",
       "853  Nashville                       TN  United States    7/4/07 21:35   \n",
       "855  Naples                          FL  United States    11/8/08 9:42   \n",
       "856  Bridgewater                     NJ  United States   7/29/08 12:00   \n",
       "857  Washington                      DC  United States   5/31/08 12:03   \n",
       "874  Wilmington                      DE  United States   3/25/08 13:23   \n",
       "887  Minneapolis                     MN  United States    4/3/07 12:56   \n",
       "894  Arlington                       VA  United States    1/8/09 11:01   \n",
       "896  Chiefland                       FL  United States   1/27/09 15:56   \n",
       "904  Castle Rock                     CO  United States   10/6/08 16:31   \n",
       "912  Fresno                          TX  United States    1/24/09 9:24   \n",
       "913  Fresno                          TX  United States    1/24/09 9:24   \n",
       "920  Montgomery                      TX  United States    1/15/09 8:52   \n",
       "922  Manteno                         IL  United States   1/25/09 15:56   \n",
       "930               Lake Ronkonkoma    NY  United States   10/27/08 0:00   \n",
       "937  Chelmsford                      MA  United States   5/23/07 11:55   \n",
       "943  Poughkeepsie                    NY  United States    8/26/08 9:37   \n",
       "944  Cincinnati                      OH  United States    1/7/09 20:25   \n",
       "952  Sammamish                       WA  United States    1/1/09 22:43   \n",
       "954  Ewa Beach                       HI  United States   12/31/08 7:40   \n",
       "962  Hilton Head                     SC  United States   1/10/05 21:39   \n",
       "964  Swampscott                      MA  United States     6/9/06 8:57   \n",
       "969  Greenville                      TX  United States    1/5/09 18:16   \n",
       "979  Hollywood                       CA  United States   5/30/06 20:25   \n",
       "986  Augusta                         GA  United States   6/10/05 20:25   \n",
       "\n",
       "        Last_Login  Latitude  Longitude  \n",
       "2     1/3/09 12:32  46.18806 -123.83000  \n",
       "6     1/4/09 19:45  40.69361  -89.58889  \n",
       "7     1/4/09 20:01  36.34333  -88.85028  \n",
       "12     1/5/09 9:05  29.42389  -98.49333  \n",
       "30     1/8/09 6:19  40.71417  -74.00639  \n",
       "31     1/8/09 6:34  25.77389  -80.19389  \n",
       "38     1/9/09 7:11  29.76306  -95.36306  \n",
       "41    1/9/09 10:52  34.33806  -84.37667  \n",
       "54   1/10/09 21:31  40.91139  -73.78278  \n",
       "58   1/11/09 19:35  41.46444  -81.50889  \n",
       "62    1/12/09 3:22  43.64917  -72.31083  \n",
       "84    1/14/09 1:07  33.66944 -117.82222  \n",
       "89    1/14/09 4:43  21.30694 -157.85833  \n",
       "95   1/14/09 15:17  25.72111  -80.26861  \n",
       "101   1/15/09 2:04  42.09722  -88.69278  \n",
       "106   1/15/09 6:59  37.61917  -75.76417  \n",
       "108   1/15/09 9:32  40.63667  -74.91028  \n",
       "109   1/15/09 9:40  37.77417  -87.11333  \n",
       "121   1/16/09 6:08  41.37222  -73.73389  \n",
       "137  1/17/09 17:31  29.76306  -95.36306  \n",
       "145   1/18/09 8:43  37.88583 -122.11694  \n",
       "154  1/18/09 13:58  38.25417  -85.75944  \n",
       "164   1/19/09 3:47  39.83806  -75.15306  \n",
       "178  1/19/09 15:36  42.39583  -71.17917  \n",
       "179  1/19/09 16:00  41.02278  -73.56528  \n",
       "180  1/19/09 16:18  25.71222  -80.25722  \n",
       "184  1/19/09 22:53  36.84667  -76.28556  \n",
       "189   1/20/09 7:15  32.52500  -93.75000  \n",
       "190   1/20/09 7:15  32.52500  -93.75000  \n",
       "198  1/20/09 12:55  40.71417  -74.00639  \n",
       "..             ...       ...        ...  \n",
       "790  2/18/09 19:38  40.34083  -76.41167  \n",
       "807  2/19/09 16:52  38.81194  -77.63667  \n",
       "822  2/20/09 11:34  38.96861  -77.34139  \n",
       "829  2/20/09 22:24  33.66028 -117.99833  \n",
       "836   2/21/09 9:26  37.77500 -122.41833  \n",
       "842  2/21/09 18:45  44.94611  -68.64444  \n",
       "853  2/22/09 15:58  36.16583  -86.78444  \n",
       "855  2/22/09 18:36  26.14167  -81.79500  \n",
       "856  2/22/09 18:48  40.59450  -74.62440  \n",
       "857  2/22/09 18:58  38.89500  -77.03667  \n",
       "874  2/23/09 16:29  39.74583  -75.54694  \n",
       "887   2/24/09 8:46  44.98000  -93.26361  \n",
       "894  2/24/09 16:38  38.89028  -77.08444  \n",
       "896  2/24/09 18:29  29.47472  -82.86000  \n",
       "904   2/25/09 7:42  39.37222 -104.85556  \n",
       "912  2/25/09 14:22  29.53861  -95.44722  \n",
       "913  2/25/09 14:22  29.53861  -95.44722  \n",
       "920  2/25/09 17:24  30.38806  -95.69611  \n",
       "922  2/25/09 19:27  41.25056  -87.83139  \n",
       "930   2/26/09 6:14  40.83500  -73.13167  \n",
       "937   2/26/09 8:38  42.59972  -71.36778  \n",
       "943  2/26/09 12:17  41.70028  -73.92139  \n",
       "944  2/26/09 12:24  39.16194  -84.45694  \n",
       "952  2/26/09 15:30  47.64194 -122.07917  \n",
       "954  2/26/09 17:47  21.31556 -158.00722  \n",
       "962   2/27/09 7:33  32.21611  -80.75278  \n",
       "964  2/27/09 13:00  42.47083  -70.91806  \n",
       "969  2/27/09 19:07  33.13833  -96.11056  \n",
       "979   2/28/09 9:59  34.09833 -118.32583  \n",
       "986  2/28/09 19:57  33.51722  -82.07583  \n",
       "\n",
       "[131 rows x 12 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mastercard_usa = dataset[(dataset[\"Payment_Type\"] == \"Mastercard\") & (dataset[\"Country\"] == \"United States\")]\n",
    "mastercard_usa"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "131"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(mastercard_usa)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "### Agregar información a nuestro dataset\n",
    "\n",
    "En esta sección revisaremos una forma sencilla de agregar datos a nuestro dataset. Es importante notar que probablemente esta no es la manera más elegante o eficiente de realizar lo pedido, pues este *notebook* es meramente introductorio. Queda como desafío al lector proponer un procedimiento que haga mejor uso de las *features* de las librerías revisadas."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Imaginemos que se nos pide agregar el estado de las transacciones, siguiendo una distribución multinomial con las siguientes probabilidades:\n",
    "\n",
    "| Status   | Probability |\n",
    "|----------|-------------|\n",
    "| Approved | 0,65        |\n",
    "| Pending  | 0,22        |\n",
    "| Rejected | 0,13        |  "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "source": [
    "#### Sobre la distribución multinomial\n",
    "\n",
    "En esta distribución, tenemos $k$ categorías que tienen probabilidad $p_{i}$, con $i = 1 \\dots k$ de ocurrir. La función de densidad que la caracteriza es: $$f(x) = \\frac{n!}{x_1! \\cdots x_k!} p_1^{x_1} \\cdots p_k^{x_k}$$.\n",
    "\n",
    "Usar la distribución multinomial en Python es tarea fácil, gracias a la librería numpy. Dicha librería posee el método ```multinomial```, que recibe como parámetros el tamaño *n* de nuestra muestra y una lista que contendrá las probabilidades de cada categoría. Puedes leer más de este método en la [documentación de numpy](https://docs.scipy.org/doc/numpy/reference/generated/numpy.random.multinomial.html).\n",
    "\n",
    "Así, aplicamos lo anterior a nuestro ejemplo:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "probs = [0.65, 0.22, 0.13]\n",
    "n = dataset.size"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([7797, 2683, 1496])"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "status_dist = np.random.multinomial(n, probs)\n",
    "status_dist"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Así, ahora sabemos que los estados de las transacciones serán:\n",
    "\n",
    "| Status   | Quantity |\n",
    "|----------|-------------|\n",
    "| Approved | status_dist[0]        |\n",
    "| Pending  | status_dist[1]        |\n",
    "| Rejected | status_dist[2]        |"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "**Nota**: los valores de ```status_dist``` cambiarán en cada ejecución."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Ahora, ¿cómo agregamos una nueva columna **Status** que contenga lo anterior? En primer lugar, reordenaremos aleatoriamente las columnas de nuestro dataset, para que, en caso de que los datos estuviesen ordenados, no queden todos los de cierto grupo aprobados/pendientes/rechazados, sino que haya una distribución más menos *justa* de cada estado."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "dataset = dataset.sample(frac=1).reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Transaction_date</th>\n",
       "      <th>Product</th>\n",
       "      <th>Price</th>\n",
       "      <th>Payment_Type</th>\n",
       "      <th>Name</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Country</th>\n",
       "      <th>Account_Created</th>\n",
       "      <th>Last_Login</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1/8/09 13:14</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Dr. Claudia</td>\n",
       "      <td>Oslo</td>\n",
       "      <td>Oslo</td>\n",
       "      <td>Norway</td>\n",
       "      <td>1/8/09 12:47</td>\n",
       "      <td>1/13/09 10:49</td>\n",
       "      <td>59.916667</td>\n",
       "      <td>10.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1/12/09 11:40</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Debra</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>Ontario</td>\n",
       "      <td>Canada</td>\n",
       "      <td>12/30/08 6:59</td>\n",
       "      <td>2/3/09 19:42</td>\n",
       "      <td>43.666667</td>\n",
       "      <td>-79.416667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1/18/09 17:21</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Nichol Jane</td>\n",
       "      <td>Midland Park</td>\n",
       "      <td>NJ</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/11/09 20:59</td>\n",
       "      <td>1/25/09 14:00</td>\n",
       "      <td>40.989170</td>\n",
       "      <td>-74.141110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1/29/09 13:41</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>John</td>\n",
       "      <td>San Jose</td>\n",
       "      <td>CA</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/14/04 21:59</td>\n",
       "      <td>2/10/09 23:58</td>\n",
       "      <td>37.339440</td>\n",
       "      <td>-121.893890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1/24/09 11:05</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>alan</td>\n",
       "      <td>Norcross</td>\n",
       "      <td>GA</td>\n",
       "      <td>United States</td>\n",
       "      <td>7/30/07 15:16</td>\n",
       "      <td>1/31/09 19:31</td>\n",
       "      <td>33.941110</td>\n",
       "      <td>-84.213610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1/7/09 13:49</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Diners</td>\n",
       "      <td>megan</td>\n",
       "      <td>West Hills</td>\n",
       "      <td>CA</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/7/09 12:36</td>\n",
       "      <td>2/1/09 8:20</td>\n",
       "      <td>34.201110</td>\n",
       "      <td>-118.597220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1/24/09 13:35</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Renee</td>\n",
       "      <td>Chaska</td>\n",
       "      <td>MN</td>\n",
       "      <td>United States</td>\n",
       "      <td>5/11/06 13:27</td>\n",
       "      <td>2/16/09 9:00</td>\n",
       "      <td>44.789440</td>\n",
       "      <td>-93.601940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1/16/09 13:35</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Michael</td>\n",
       "      <td>Milano</td>\n",
       "      <td>Lombardy</td>\n",
       "      <td>Italy</td>\n",
       "      <td>1/16/09 12:43</td>\n",
       "      <td>2/25/09 13:59</td>\n",
       "      <td>45.466667</td>\n",
       "      <td>9.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1/9/09 15:03</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Reto</td>\n",
       "      <td>Seattle</td>\n",
       "      <td>WA</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/8/09 18:59</td>\n",
       "      <td>2/18/09 15:51</td>\n",
       "      <td>47.606390</td>\n",
       "      <td>-122.330830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1/26/09 10:24</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Eleanor</td>\n",
       "      <td>Vancouver</td>\n",
       "      <td>British Columbia</td>\n",
       "      <td>Canada</td>\n",
       "      <td>12/1/08 18:30</td>\n",
       "      <td>1/26/09 10:12</td>\n",
       "      <td>49.250000</td>\n",
       "      <td>-123.133333</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Transaction_date   Product Price Payment_Type         Name  \\\n",
       "0     1/8/09 13:14  Product1  1200         Visa  Dr. Claudia   \n",
       "1    1/12/09 11:40  Product2  3600         Visa        Debra   \n",
       "2    1/18/09 17:21  Product1  1200   Mastercard  Nichol Jane   \n",
       "3    1/29/09 13:41  Product1  1200         Visa        John    \n",
       "4    1/24/09 11:05  Product1  1200         Visa         alan   \n",
       "5     1/7/09 13:49  Product1  1200       Diners        megan   \n",
       "6    1/24/09 13:35  Product1  1200         Visa        Renee   \n",
       "7    1/16/09 13:35  Product1  1200         Visa      Michael   \n",
       "8     1/9/09 15:03  Product1  1200         Visa         Reto   \n",
       "9    1/26/09 10:24  Product1  1200         Visa      Eleanor   \n",
       "\n",
       "                           City             State        Country  \\\n",
       "0                          Oslo              Oslo         Norway   \n",
       "1                       Toronto           Ontario         Canada   \n",
       "2  Midland Park                                NJ  United States   \n",
       "3  San Jose                                    CA  United States   \n",
       "4  Norcross                                    GA  United States   \n",
       "5  West Hills                                  CA  United States   \n",
       "6  Chaska                                      MN  United States   \n",
       "7                        Milano          Lombardy          Italy   \n",
       "8  Seattle                                     WA  United States   \n",
       "9                     Vancouver  British Columbia         Canada   \n",
       "\n",
       "  Account_Created     Last_Login   Latitude   Longitude  \n",
       "0    1/8/09 12:47  1/13/09 10:49  59.916667   10.750000  \n",
       "1   12/30/08 6:59   2/3/09 19:42  43.666667  -79.416667  \n",
       "2   1/11/09 20:59  1/25/09 14:00  40.989170  -74.141110  \n",
       "3   1/14/04 21:59  2/10/09 23:58  37.339440 -121.893890  \n",
       "4   7/30/07 15:16  1/31/09 19:31  33.941110  -84.213610  \n",
       "5    1/7/09 12:36    2/1/09 8:20  34.201110 -118.597220  \n",
       "6   5/11/06 13:27   2/16/09 9:00  44.789440  -93.601940  \n",
       "7   1/16/09 12:43  2/25/09 13:59  45.466667    9.200000  \n",
       "8    1/8/09 18:59  2/18/09 15:51  47.606390 -122.330830  \n",
       "9   12/1/08 18:30  1/26/09 10:12  49.250000 -123.133333  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "```head()``` nos permite revisar los primeros 5 elementos de un DataFrame."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Approved', 'Approved', 'Approved', 'Approved', 'Approved', 'Approved', 'Approved', 'Approved', 'Approved', 'Approved']\n"
     ]
    }
   ],
   "source": [
    "status = [\"Approved\"] * status_dist[0] + [\"Pending\"] * status_dist[1] + [\"Rejected\"] * status_dist[2]\n",
    "status[0:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Transaction_date</th>\n",
       "      <th>Product</th>\n",
       "      <th>Price</th>\n",
       "      <th>Payment_Type</th>\n",
       "      <th>Name</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Country</th>\n",
       "      <th>Account_Created</th>\n",
       "      <th>Last_Login</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Status</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1/8/09 13:14</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Dr. Claudia</td>\n",
       "      <td>Oslo</td>\n",
       "      <td>Oslo</td>\n",
       "      <td>Norway</td>\n",
       "      <td>1/8/09 12:47</td>\n",
       "      <td>1/13/09 10:49</td>\n",
       "      <td>59.916667</td>\n",
       "      <td>10.750000</td>\n",
       "      <td>Rejected</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1/12/09 11:40</td>\n",
       "      <td>Product2</td>\n",
       "      <td>3600</td>\n",
       "      <td>Visa</td>\n",
       "      <td>Debra</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>Ontario</td>\n",
       "      <td>Canada</td>\n",
       "      <td>12/30/08 6:59</td>\n",
       "      <td>2/3/09 19:42</td>\n",
       "      <td>43.666667</td>\n",
       "      <td>-79.416667</td>\n",
       "      <td>Rejected</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1/18/09 17:21</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>Nichol Jane</td>\n",
       "      <td>Midland Park</td>\n",
       "      <td>NJ</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/11/09 20:59</td>\n",
       "      <td>1/25/09 14:00</td>\n",
       "      <td>40.989170</td>\n",
       "      <td>-74.141110</td>\n",
       "      <td>Approved</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1/29/09 13:41</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>John</td>\n",
       "      <td>San Jose</td>\n",
       "      <td>CA</td>\n",
       "      <td>United States</td>\n",
       "      <td>1/14/04 21:59</td>\n",
       "      <td>2/10/09 23:58</td>\n",
       "      <td>37.339440</td>\n",
       "      <td>-121.893890</td>\n",
       "      <td>Approved</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1/24/09 11:05</td>\n",
       "      <td>Product1</td>\n",
       "      <td>1200</td>\n",
       "      <td>Visa</td>\n",
       "      <td>alan</td>\n",
       "      <td>Norcross</td>\n",
       "      <td>GA</td>\n",
       "      <td>United States</td>\n",
       "      <td>7/30/07 15:16</td>\n",
       "      <td>1/31/09 19:31</td>\n",
       "      <td>33.941110</td>\n",
       "      <td>-84.213610</td>\n",
       "      <td>Approved</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Transaction_date   Product Price Payment_Type         Name  \\\n",
       "0     1/8/09 13:14  Product1  1200         Visa  Dr. Claudia   \n",
       "1    1/12/09 11:40  Product2  3600         Visa        Debra   \n",
       "2    1/18/09 17:21  Product1  1200   Mastercard  Nichol Jane   \n",
       "3    1/29/09 13:41  Product1  1200         Visa        John    \n",
       "4    1/24/09 11:05  Product1  1200         Visa         alan   \n",
       "\n",
       "                           City    State        Country Account_Created  \\\n",
       "0                          Oslo     Oslo         Norway    1/8/09 12:47   \n",
       "1                       Toronto  Ontario         Canada   12/30/08 6:59   \n",
       "2  Midland Park                       NJ  United States   1/11/09 20:59   \n",
       "3  San Jose                           CA  United States   1/14/04 21:59   \n",
       "4  Norcross                           GA  United States   7/30/07 15:16   \n",
       "\n",
       "      Last_Login   Latitude   Longitude    Status  \n",
       "0  1/13/09 10:49  59.916667   10.750000  Rejected  \n",
       "1   2/3/09 19:42  43.666667  -79.416667  Rejected  \n",
       "2  1/25/09 14:00  40.989170  -74.141110  Approved  \n",
       "3  2/10/09 23:58  37.339440 -121.893890  Approved  \n",
       "4  1/31/09 19:31  33.941110  -84.213610  Approved  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset[\"Status\"] = pd.Series(status)\n",
    "dataset.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "¡Listo! Hemos agregado exitosamente una columna con datos que siguen una distribución multinomial."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "### Exportar DataFrame"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Para poder usar los datos pre-procesados en nuestras futuras visualizaciones, debemos exportarlos. Pandas incluye el método ```to_csv```, que nos permite exportar a un archivo *.csv* de manera rápida:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "dataset.to_csv(\"SalesNew.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "### Generar puntos aleatorios"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "En esta última sección de la ayudantía, generaremos puntos cerca de ciertas ciudades. Con ese objetivo en mente, crearemos una copia del *dataset* que estábamos usando, pero con algunas columnas menos."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "dataset_copy = dataset[[\"Product\", \"Name\", \"City\", \"Status\"]].copy()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "La línea anterior nos permitió crear un nuevo *DataFrame* a partir del anterior, pero solo con las columnas **Product**, **Name**, **City** y **Status**. Ahora, alteraremos la columna **City**, para que ahora contenga ciudades chilenas."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "for index, row in dataset_copy.iterrows():\n",
    "    dataset_copy.loc[index, \"City\"] = random.choice([\"Santiago\", \"Iquique\", \"Concepción\"])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Vemos que funciona:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Product</th>\n",
       "      <th>Name</th>\n",
       "      <th>City</th>\n",
       "      <th>Status</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Product1</td>\n",
       "      <td>Dr. Claudia</td>\n",
       "      <td>Concepción</td>\n",
       "      <td>Rejected</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Product2</td>\n",
       "      <td>Debra</td>\n",
       "      <td>Concepción</td>\n",
       "      <td>Rejected</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Product1</td>\n",
       "      <td>Nichol Jane</td>\n",
       "      <td>Santiago</td>\n",
       "      <td>Approved</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Product1</td>\n",
       "      <td>John</td>\n",
       "      <td>Concepción</td>\n",
       "      <td>Approved</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Product1</td>\n",
       "      <td>alan</td>\n",
       "      <td>Santiago</td>\n",
       "      <td>Approved</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Product1</td>\n",
       "      <td>megan</td>\n",
       "      <td>Santiago</td>\n",
       "      <td>Approved</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Product1</td>\n",
       "      <td>Renee</td>\n",
       "      <td>Concepción</td>\n",
       "      <td>Pending</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Product1</td>\n",
       "      <td>Michael</td>\n",
       "      <td>Santiago</td>\n",
       "      <td>Rejected</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Product1</td>\n",
       "      <td>Reto</td>\n",
       "      <td>Iquique</td>\n",
       "      <td>Approved</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Product1</td>\n",
       "      <td>Eleanor</td>\n",
       "      <td>Iquique</td>\n",
       "      <td>Pending</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Product         Name        City    Status\n",
       "0  Product1  Dr. Claudia  Concepción  Rejected\n",
       "1  Product2        Debra  Concepción  Rejected\n",
       "2  Product1  Nichol Jane    Santiago  Approved\n",
       "3  Product1        John   Concepción  Approved\n",
       "4  Product1         alan    Santiago  Approved\n",
       "5  Product1        megan    Santiago  Approved\n",
       "6  Product1        Renee  Concepción   Pending\n",
       "7  Product1      Michael    Santiago  Rejected\n",
       "8  Product1         Reto     Iquique  Approved\n",
       "9  Product1      Eleanor     Iquique   Pending"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset_copy.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Para que la generación de puntos resulte más cercana a la realidad, tenemos, convenientemente, un archivo *csv* con las coordenadas de cada ciudad:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Ciudad</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Long</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Iquique</td>\n",
       "      <td>-20.217</td>\n",
       "      <td>-70.167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Santiago</td>\n",
       "      <td>-33.450</td>\n",
       "      <td>-70.667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Concepción</td>\n",
       "      <td>-36.833</td>\n",
       "      <td>-73.050</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Ciudad     Lat    Long\n",
       "0     Iquique -20.217 -70.167\n",
       "1    Santiago -33.450 -70.667\n",
       "2  Concepción -36.833 -73.050"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cities = pd.read_csv(\"ciudades.csv\")\n",
    "cities"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Ahora, sabiendo que 1 grado equivale a 111 km aproximadamente, podemos hacer lo siguiente:\n",
    "\n",
    "Primero, creamos una columna vacía para la latitud y longitud:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "dataset_copy[\"Lat\"] = 0\n",
    "dataset_copy[\"Long\"] = 0"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Posteriormente, añadimos puntos aleatorios alrededor de las ciudades, sumando o restando grados."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "for index, row in dataset_copy.iterrows():\n",
    "    if row[\"City\"] == \"Santiago\":\n",
    "        radius = random.choice([-100/111, 100/111])\n",
    "        dataset_copy.loc[index, \"Lat\"] = cities[cities[\"Ciudad\"] == \"Santiago\"][\"Lat\"].values[0] +\\\n",
    "        random.random() * radius\n",
    "        dataset_copy.loc[index, \"Long\"] = cities[cities[\"Ciudad\"] == \"Santiago\"][\"Long\"].values[0] +\\\n",
    "        random.random() * radius\n",
    "    elif row[\"City\"] == \"Iquique\":\n",
    "        radius = random.choice([-80/111, 80/111])\n",
    "        dataset_copy.loc[index, \"Lat\"] = cities[cities[\"Ciudad\"] == \"Iquique\"][\"Lat\"].values[0] +\\\n",
    "        random.random() * radius\n",
    "        dataset_copy.loc[index, \"Long\"] = cities[cities[\"Ciudad\"] == \"Iquique\"][\"Long\"].values[0] +\\\n",
    "        random.random() * radius\n",
    "    else:\n",
    "        radius = random.choice([-95/111, 95/111])\n",
    "        dataset_copy.loc[index, \"Lat\"] = cities[cities[\"Ciudad\"] == \"Concepción\"][\"Lat\"].values[0] +\\\n",
    "        random.random() * radius\n",
    "        dataset_copy.loc[index, \"Long\"] = cities[cities[\"Ciudad\"] == \"Concepción\"][\"Long\"].values[0] +\\\n",
    "        random.random() * radius"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Product</th>\n",
       "      <th>Name</th>\n",
       "      <th>City</th>\n",
       "      <th>Status</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Long</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Product1</td>\n",
       "      <td>Dr. Claudia</td>\n",
       "      <td>Concepción</td>\n",
       "      <td>Rejected</td>\n",
       "      <td>-36.448819</td>\n",
       "      <td>-72.299436</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Product2</td>\n",
       "      <td>Debra</td>\n",
       "      <td>Concepción</td>\n",
       "      <td>Rejected</td>\n",
       "      <td>-36.585031</td>\n",
       "      <td>-72.589403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Product1</td>\n",
       "      <td>Nichol Jane</td>\n",
       "      <td>Santiago</td>\n",
       "      <td>Approved</td>\n",
       "      <td>-33.114396</td>\n",
       "      <td>-70.226246</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Product1</td>\n",
       "      <td>John</td>\n",
       "      <td>Concepción</td>\n",
       "      <td>Approved</td>\n",
       "      <td>-35.982845</td>\n",
       "      <td>-72.203010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Product1</td>\n",
       "      <td>alan</td>\n",
       "      <td>Santiago</td>\n",
       "      <td>Approved</td>\n",
       "      <td>-33.239447</td>\n",
       "      <td>-69.789800</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Product         Name        City    Status        Lat       Long\n",
       "0  Product1  Dr. Claudia  Concepción  Rejected -36.448819 -72.299436\n",
       "1  Product2        Debra  Concepción  Rejected -36.585031 -72.589403\n",
       "2  Product1  Nichol Jane    Santiago  Approved -33.114396 -70.226246\n",
       "3  Product1        John   Concepción  Approved -35.982845 -72.203010\n",
       "4  Product1         alan    Santiago  Approved -33.239447 -69.789800"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset_copy.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "Notamos que efectivamente se generan puntos en torno a las ciudades mencionadas."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "#### Desafíos relativos a la generación de puntos\n",
    "\n",
    "- Existe una forma más *agradable* a la vista de distribuir los puntos, con la distribución **normal bivariada**. Te sugerimos investigar sobre ella y usarla en tu tarea, si lo deseas.\n",
    "- Prueba poniendo algunos de los puntos generados en el mapa, para que veas por ti mismo que de verdad estén en las ciudades que dicen estar (o al menos cerca de ellas).\n",
    "- Con respecto al punto anterior, prueba a adelantarte con la tarea y graficar tú mismo la ubicación de los puntos, a partir de un archivo *.csv*."
   ]
  }
 ],
 "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.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}