Day11EcommerceQuizForPandas.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Address</th>\n",
       "      <th>Lot</th>\n",
       "      <th>AM or PM</th>\n",
       "      <th>Browser Info</th>\n",
       "      <th>Company</th>\n",
       "      <th>Credit Card</th>\n",
       "      <th>CC Exp Date</th>\n",
       "      <th>CC Security Code</th>\n",
       "      <th>CC Provider</th>\n",
       "      <th>Email</th>\n",
       "      <th>Job</th>\n",
       "      <th>IP Address</th>\n",
       "      <th>Language</th>\n",
       "      <th>Purchase Price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>16629 Pace Camp Apt. 448\\nAlexisborough, NE 77...</td>\n",
       "      <td>46 in</td>\n",
       "      <td>PM</td>\n",
       "      <td>Opera/9.56.(X11; Linux x86_64; sl-SI) Presto/2...</td>\n",
       "      <td>Martinez-Herman</td>\n",
       "      <td>6011929061123406</td>\n",
       "      <td>02/20</td>\n",
       "      <td>900</td>\n",
       "      <td>JCB 16 digit</td>\n",
       "      <td>pdunlap@yahoo.com</td>\n",
       "      <td>Scientist, product/process development</td>\n",
       "      <td>149.146.147.205</td>\n",
       "      <td>el</td>\n",
       "      <td>98.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>9374 Jasmine Spurs Suite 508\\nSouth John, TN 8...</td>\n",
       "      <td>28 rn</td>\n",
       "      <td>PM</td>\n",
       "      <td>Opera/8.93.(Windows 98; Win 9x 4.90; en-US) Pr...</td>\n",
       "      <td>Fletcher, Richards and Whitaker</td>\n",
       "      <td>3337758169645356</td>\n",
       "      <td>11/18</td>\n",
       "      <td>561</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>anthony41@reed.com</td>\n",
       "      <td>Drilling engineer</td>\n",
       "      <td>15.160.41.51</td>\n",
       "      <td>fr</td>\n",
       "      <td>70.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>Unit 0065 Box 5052\\nDPO AP 27450</td>\n",
       "      <td>94 vE</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (compatible; MSIE 9.0; Windows NT ...</td>\n",
       "      <td>Simpson, Williams and Pham</td>\n",
       "      <td>675957666125</td>\n",
       "      <td>08/19</td>\n",
       "      <td>699</td>\n",
       "      <td>JCB 16 digit</td>\n",
       "      <td>amymiller@morales-harrison.com</td>\n",
       "      <td>Customer service manager</td>\n",
       "      <td>132.207.160.22</td>\n",
       "      <td>de</td>\n",
       "      <td>0.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>7780 Julia Fords\\nNew Stacy, WA 45798</td>\n",
       "      <td>36 vm</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_0 ...</td>\n",
       "      <td>Williams, Marshall and Buchanan</td>\n",
       "      <td>6011578504430710</td>\n",
       "      <td>02/24</td>\n",
       "      <td>384</td>\n",
       "      <td>Discover</td>\n",
       "      <td>brent16@olson-robinson.info</td>\n",
       "      <td>Drilling engineer</td>\n",
       "      <td>30.250.74.19</td>\n",
       "      <td>es</td>\n",
       "      <td>78.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>23012 Munoz Drive Suite 337\\nNew Cynthia, TX 5...</td>\n",
       "      <td>20 IE</td>\n",
       "      <td>AM</td>\n",
       "      <td>Opera/9.58.(X11; Linux x86_64; it-IT) Presto/2...</td>\n",
       "      <td>Brown, Watson and Andrews</td>\n",
       "      <td>6011456623207998</td>\n",
       "      <td>10/25</td>\n",
       "      <td>678</td>\n",
       "      <td>Diners Club / Carte Blanche</td>\n",
       "      <td>christopherwright@gmail.com</td>\n",
       "      <td>Fine artist</td>\n",
       "      <td>24.140.33.94</td>\n",
       "      <td>es</td>\n",
       "      <td>77.82</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Address    Lot AM or PM  \\\n",
       "0  16629 Pace Camp Apt. 448\\nAlexisborough, NE 77...  46 in       PM   \n",
       "1  9374 Jasmine Spurs Suite 508\\nSouth John, TN 8...  28 rn       PM   \n",
       "2                   Unit 0065 Box 5052\\nDPO AP 27450  94 vE       PM   \n",
       "3              7780 Julia Fords\\nNew Stacy, WA 45798  36 vm       PM   \n",
       "4  23012 Munoz Drive Suite 337\\nNew Cynthia, TX 5...  20 IE       AM   \n",
       "\n",
       "                                        Browser Info  \\\n",
       "0  Opera/9.56.(X11; Linux x86_64; sl-SI) Presto/2...   \n",
       "1  Opera/8.93.(Windows 98; Win 9x 4.90; en-US) Pr...   \n",
       "2  Mozilla/5.0 (compatible; MSIE 9.0; Windows NT ...   \n",
       "3  Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_0 ...   \n",
       "4  Opera/9.58.(X11; Linux x86_64; it-IT) Presto/2...   \n",
       "\n",
       "                           Company       Credit Card CC Exp Date  \\\n",
       "0                  Martinez-Herman  6011929061123406       02/20   \n",
       "1  Fletcher, Richards and Whitaker  3337758169645356       11/18   \n",
       "2       Simpson, Williams and Pham      675957666125       08/19   \n",
       "3  Williams, Marshall and Buchanan  6011578504430710       02/24   \n",
       "4        Brown, Watson and Andrews  6011456623207998       10/25   \n",
       "\n",
       "   CC Security Code                  CC Provider  \\\n",
       "0               900                 JCB 16 digit   \n",
       "1               561                   Mastercard   \n",
       "2               699                 JCB 16 digit   \n",
       "3               384                     Discover   \n",
       "4               678  Diners Club / Carte Blanche   \n",
       "\n",
       "                            Email                                     Job  \\\n",
       "0               pdunlap@yahoo.com  Scientist, product/process development   \n",
       "1              anthony41@reed.com                       Drilling engineer   \n",
       "2  amymiller@morales-harrison.com                Customer service manager   \n",
       "3     brent16@olson-robinson.info                       Drilling engineer   \n",
       "4     christopherwright@gmail.com                             Fine artist   \n",
       "\n",
       "        IP Address Language  Purchase Price  \n",
       "0  149.146.147.205       el           98.14  \n",
       "1     15.160.41.51       fr           70.73  \n",
       "2   132.207.160.22       de            0.95  \n",
       "3     30.250.74.19       es           78.04  \n",
       "4     24.140.33.94       es           77.82  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('./D11/Ecommerce Purchases')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 10000 entries, 0 to 9999\n",
      "Data columns (total 14 columns):\n",
      "Address             10000 non-null object\n",
      "Lot                 10000 non-null object\n",
      "AM or PM            10000 non-null object\n",
      "Browser Info        10000 non-null object\n",
      "Company             10000 non-null object\n",
      "Credit Card         10000 non-null int64\n",
      "CC Exp Date         10000 non-null object\n",
      "CC Security Code    10000 non-null int64\n",
      "CC Provider         10000 non-null object\n",
      "Email               10000 non-null object\n",
      "Job                 10000 non-null object\n",
      "IP Address          10000 non-null object\n",
      "Language            10000 non-null object\n",
      "Purchase Price      10000 non-null float64\n",
      "dtypes: float64(1), int64(2), object(11)\n",
      "memory usage: 1.1+ MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Credit Card</th>\n",
       "      <th>CC Security Code</th>\n",
       "      <th>Purchase Price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>count</td>\n",
       "      <td>1.000000e+04</td>\n",
       "      <td>10000.000000</td>\n",
       "      <td>10000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>mean</td>\n",
       "      <td>2.341374e+15</td>\n",
       "      <td>907.217800</td>\n",
       "      <td>50.347302</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>std</td>\n",
       "      <td>2.256103e+15</td>\n",
       "      <td>1589.693035</td>\n",
       "      <td>29.015836</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>min</td>\n",
       "      <td>6.040186e+10</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>25%</td>\n",
       "      <td>3.056322e+13</td>\n",
       "      <td>280.000000</td>\n",
       "      <td>25.150000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>50%</td>\n",
       "      <td>8.699942e+14</td>\n",
       "      <td>548.000000</td>\n",
       "      <td>50.505000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>75%</td>\n",
       "      <td>4.492298e+15</td>\n",
       "      <td>816.000000</td>\n",
       "      <td>75.770000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>max</td>\n",
       "      <td>6.012000e+15</td>\n",
       "      <td>9993.000000</td>\n",
       "      <td>99.990000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Credit Card  CC Security Code  Purchase Price\n",
       "count  1.000000e+04      10000.000000    10000.000000\n",
       "mean   2.341374e+15        907.217800       50.347302\n",
       "std    2.256103e+15       1589.693035       29.015836\n",
       "min    6.040186e+10          0.000000        0.000000\n",
       "25%    3.056322e+13        280.000000       25.150000\n",
       "50%    8.699942e+14        548.000000       50.505000\n",
       "75%    4.492298e+15        816.000000       75.770000\n",
       "max    6.012000e+15       9993.000000       99.990000"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "AM or PM\n",
      "AM    4932\n",
      "PM    5068\n",
      "Name: Job, dtype: int64\n",
      "Job\n",
      "Academic librarian                  11\n",
      "Accommodation manager               17\n",
      "Accountant, chartered               20\n",
      "Accountant, chartered certified     18\n",
      "Accountant, chartered management    15\n",
      "                                    ..\n",
      "Water quality scientist             18\n",
      "Web designer                        20\n",
      "Wellsite geologist                  24\n",
      "Writer                              10\n",
      "Youth worker                        18\n",
      "Name: Language, Length: 623, dtype: int64\n",
      "Language\n",
      "de    1155\n",
      "el    1137\n",
      "en    1098\n",
      "es    1095\n",
      "fr    1097\n",
      "it    1086\n",
      "pt    1118\n",
      "ru    1155\n",
      "zh    1059\n",
      "Name: Job, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "print(df.groupby('AM or PM').Job.count())\n",
    "print(df.groupby('Job').Language.count())\n",
    "print(df.groupby('Language').Job.count())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Address</th>\n",
       "      <th>Lot</th>\n",
       "      <th>AM or PM</th>\n",
       "      <th>Browser Info</th>\n",
       "      <th>Company</th>\n",
       "      <th>Credit Card</th>\n",
       "      <th>CC Exp Date</th>\n",
       "      <th>CC Security Code</th>\n",
       "      <th>CC Provider</th>\n",
       "      <th>Email</th>\n",
       "      <th>Job</th>\n",
       "      <th>IP Address</th>\n",
       "      <th>Language</th>\n",
       "      <th>Purchase Price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>1269</td>\n",
       "      <td>155 Santiago Mill\\nLake Rebeccamouth, MH 24582...</td>\n",
       "      <td>48 LI</td>\n",
       "      <td>AM</td>\n",
       "      <td>Mozilla/5.0 (compatible; MSIE 6.0; Windows NT ...</td>\n",
       "      <td>Wells-Davis</td>\n",
       "      <td>3112136366815760</td>\n",
       "      <td>04/26</td>\n",
       "      <td>234</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>floresmichelle@yahoo.com</td>\n",
       "      <td>Accountant, chartered certified</td>\n",
       "      <td>192.169.49.221</td>\n",
       "      <td>pt</td>\n",
       "      <td>51.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2279</td>\n",
       "      <td>22238 Hudson Brook Apt. 446\\nStevenbury, WV 82590</td>\n",
       "      <td>08 Fe</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (X11; Linux x86_64; rv:1.9.7.20) G...</td>\n",
       "      <td>Singh, Jones and Cook</td>\n",
       "      <td>4287942833441354</td>\n",
       "      <td>05/21</td>\n",
       "      <td>327</td>\n",
       "      <td>Diners Club / Carte Blanche</td>\n",
       "      <td>tammy81@grimes-gross.com</td>\n",
       "      <td>Accountant, chartered certified</td>\n",
       "      <td>180.0.100.129</td>\n",
       "      <td>it</td>\n",
       "      <td>96.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2350</td>\n",
       "      <td>928 Rhodes Isle\\nPort Jamesport, NY 72568-2200</td>\n",
       "      <td>18 Zf</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (X11; Linux x86_64; rv:1.9.5.20) G...</td>\n",
       "      <td>Moore-Williams</td>\n",
       "      <td>4398601867787902</td>\n",
       "      <td>01/23</td>\n",
       "      <td>33</td>\n",
       "      <td>American Express</td>\n",
       "      <td>amy45@hotmail.com</td>\n",
       "      <td>Accountant, chartered certified</td>\n",
       "      <td>104.248.117.134</td>\n",
       "      <td>it</td>\n",
       "      <td>76.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2461</td>\n",
       "      <td>19313 Saunders Freeway\\nPort Ryan, MA 00609</td>\n",
       "      <td>55 aP</td>\n",
       "      <td>AM</td>\n",
       "      <td>Mozilla/5.0 (Windows NT 5.01; en-US; rv:1.9.1....</td>\n",
       "      <td>Thompson, Brown and Castillo</td>\n",
       "      <td>4139428822206875</td>\n",
       "      <td>11/19</td>\n",
       "      <td>345</td>\n",
       "      <td>VISA 13 digit</td>\n",
       "      <td>qhuerta@yahoo.com</td>\n",
       "      <td>Accountant, chartered certified</td>\n",
       "      <td>169.125.173.174</td>\n",
       "      <td>en</td>\n",
       "      <td>92.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4236</td>\n",
       "      <td>8691 Love Neck Apt. 138\\nPort Jesus, WV 12384-...</td>\n",
       "      <td>21 Qp</td>\n",
       "      <td>AM</td>\n",
       "      <td>Opera/9.28.(Windows NT 5.2; it-IT) Presto/2.9....</td>\n",
       "      <td>Kane and Sons</td>\n",
       "      <td>503809873451</td>\n",
       "      <td>07/26</td>\n",
       "      <td>857</td>\n",
       "      <td>Voyager</td>\n",
       "      <td>rpage@henderson.net</td>\n",
       "      <td>Accountant, chartered certified</td>\n",
       "      <td>131.194.11.206</td>\n",
       "      <td>de</td>\n",
       "      <td>52.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5141</td>\n",
       "      <td>10963 Rogers Streets Apt. 831\\nJohnberg, VA 99...</td>\n",
       "      <td>99 or</td>\n",
       "      <td>AM</td>\n",
       "      <td>Mozilla/5.0 (compatible; MSIE 6.0; Windows 98;...</td>\n",
       "      <td>Gonzalez-Douglas</td>\n",
       "      <td>30316587872817</td>\n",
       "      <td>02/23</td>\n",
       "      <td>449</td>\n",
       "      <td>Maestro</td>\n",
       "      <td>rsmith@white.com</td>\n",
       "      <td>Accountant, chartered certified</td>\n",
       "      <td>76.238.96.32</td>\n",
       "      <td>de</td>\n",
       "      <td>13.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5371</td>\n",
       "      <td>41797 Baker Circle Suite 589\\nSloanbury, TN 81...</td>\n",
       "      <td>64 WT</td>\n",
       "      <td>PM</td>\n",
       "      <td>Opera/8.36.(Windows 98; Win 9x 4.90; en-US) Pr...</td>\n",
       "      <td>Love LLC</td>\n",
       "      <td>210077418391748</td>\n",
       "      <td>08/18</td>\n",
       "      <td>312</td>\n",
       "      <td>Maestro</td>\n",
       "      <td>christopher87@saunders.net</td>\n",
       "      <td>Accountant, chartered certified</td>\n",
       "      <td>91.241.216.32</td>\n",
       "      <td>el</td>\n",
       "      <td>69.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5430</td>\n",
       "      <td>5863 Teresa Tunnel\\nJoshuachester, IA 25187</td>\n",
       "      <td>78 sJ</td>\n",
       "      <td>AM</td>\n",
       "      <td>Mozilla/5.0 (Windows 98) AppleWebKit/5312 (KHT...</td>\n",
       "      <td>Blake-Weber</td>\n",
       "      <td>3158317939609733</td>\n",
       "      <td>12/18</td>\n",
       "      <td>972</td>\n",
       "      <td>Voyager</td>\n",
       "      <td>hannahblair@hotmail.com</td>\n",
       "      <td>Accountant, chartered certified</td>\n",
       "      <td>50.0.33.238</td>\n",
       "      <td>de</td>\n",
       "      <td>58.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5633</td>\n",
       "      <td>710 Harris Alley Apt. 421\\nJohnsonhaven, SD 51534</td>\n",
       "      <td>65 sh</td>\n",
       "      <td>AM</td>\n",
       "      <td>Mozilla/5.0 (Windows NT 5.1) AppleWebKit/5361 ...</td>\n",
       "      <td>Fisher, Salinas and Sanders</td>\n",
       "      <td>4006602558662051</td>\n",
       "      <td>10/16</td>\n",
       "      <td>136</td>\n",
       "      <td>JCB 15 digit</td>\n",
       "      <td>jeffreykeith@rivers.com</td>\n",
       "      <td>Accountant, chartered certified</td>\n",
       "      <td>254.227.63.33</td>\n",
       "      <td>fr</td>\n",
       "      <td>89.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5847</td>\n",
       "      <td>3861 Pearson Dam Apt. 169\\nBruceview, MO 02165</td>\n",
       "      <td>26 UJ</td>\n",
       "      <td>AM</td>\n",
       "      <td>Mozilla/5.0 (Windows; U; Windows NT 5.0) Apple...</td>\n",
       "      <td>Kelly Group</td>\n",
       "      <td>30246600971850</td>\n",
       "      <td>01/20</td>\n",
       "      <td>117</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>kristinmiller@yahoo.com</td>\n",
       "      <td>Accountant, chartered certified</td>\n",
       "      <td>16.105.182.206</td>\n",
       "      <td>el</td>\n",
       "      <td>95.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6146</td>\n",
       "      <td>09120 Gutierrez Roads Suite 449\\nKingshire, CO...</td>\n",
       "      <td>59 Da</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (Windows NT 5.2) AppleWebKit/5312 ...</td>\n",
       "      <td>Mullen, Kramer and Hawkins</td>\n",
       "      <td>4338530728077992</td>\n",
       "      <td>10/21</td>\n",
       "      <td>950</td>\n",
       "      <td>Discover</td>\n",
       "      <td>williamskatelyn@gmail.com</td>\n",
       "      <td>Accountant, chartered certified</td>\n",
       "      <td>147.173.29.155</td>\n",
       "      <td>de</td>\n",
       "      <td>18.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6496</td>\n",
       "      <td>PSC 6951, Box 5906\\nAPO AE 75010</td>\n",
       "      <td>42 tV</td>\n",
       "      <td>PM</td>\n",
       "      <td>Opera/8.41.(Windows NT 5.01; it-IT) Presto/2.9...</td>\n",
       "      <td>Smith Inc</td>\n",
       "      <td>30453800763836</td>\n",
       "      <td>11/21</td>\n",
       "      <td>610</td>\n",
       "      <td>JCB 16 digit</td>\n",
       "      <td>bbrown@richmond.com</td>\n",
       "      <td>Accountant, chartered certified</td>\n",
       "      <td>204.65.186.250</td>\n",
       "      <td>el</td>\n",
       "      <td>67.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6511</td>\n",
       "      <td>2551 Schneider Center\\nGrantland, ID 14442-3339</td>\n",
       "      <td>25 DA</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (Windows NT 5.01; sl-SI; rv:1.9.0....</td>\n",
       "      <td>Lopez-Graham</td>\n",
       "      <td>503859378450</td>\n",
       "      <td>09/20</td>\n",
       "      <td>37</td>\n",
       "      <td>Discover</td>\n",
       "      <td>tsanchez@gmail.com</td>\n",
       "      <td>Accountant, chartered certified</td>\n",
       "      <td>77.118.67.29</td>\n",
       "      <td>fr</td>\n",
       "      <td>52.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8569</td>\n",
       "      <td>830 Steven Views Suite 879\\nAllenburgh, NJ 617...</td>\n",
       "      <td>46 bN</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (compatible; MSIE 7.0; Windows CE;...</td>\n",
       "      <td>Barker Inc</td>\n",
       "      <td>210033680750442</td>\n",
       "      <td>06/24</td>\n",
       "      <td>579</td>\n",
       "      <td>VISA 16 digit</td>\n",
       "      <td>justin92@smith.com</td>\n",
       "      <td>Accountant, chartered certified</td>\n",
       "      <td>131.211.241.41</td>\n",
       "      <td>zh</td>\n",
       "      <td>67.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8593</td>\n",
       "      <td>8983 Ferrell Springs Suite 238\\nNorth David, M...</td>\n",
       "      <td>19 fm</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (Windows NT 6.1) AppleWebKit/5332 ...</td>\n",
       "      <td>Roberts Ltd</td>\n",
       "      <td>3096328278865906</td>\n",
       "      <td>12/23</td>\n",
       "      <td>667</td>\n",
       "      <td>JCB 15 digit</td>\n",
       "      <td>kellermark@stanton.info</td>\n",
       "      <td>Accountant, chartered certified</td>\n",
       "      <td>252.12.156.169</td>\n",
       "      <td>el</td>\n",
       "      <td>62.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9645</td>\n",
       "      <td>5169 Justin Branch\\nTracyburgh, OR 21055-9526</td>\n",
       "      <td>99 nl</td>\n",
       "      <td>PM</td>\n",
       "      <td>Opera/8.62.(Windows NT 5.0; it-IT) Presto/2.9....</td>\n",
       "      <td>Leblanc, Bernard and Paul</td>\n",
       "      <td>342534748307985</td>\n",
       "      <td>10/23</td>\n",
       "      <td>371</td>\n",
       "      <td>JCB 16 digit</td>\n",
       "      <td>tararussell@hotmail.com</td>\n",
       "      <td>Accountant, chartered certified</td>\n",
       "      <td>1.32.225.174</td>\n",
       "      <td>el</td>\n",
       "      <td>61.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9706</td>\n",
       "      <td>1841 Fisher Flats\\nWest Sierrabury, WA 99755</td>\n",
       "      <td>04 gV</td>\n",
       "      <td>PM</td>\n",
       "      <td>Opera/8.78.(X11; Linux i686; sl-SI) Presto/2.9...</td>\n",
       "      <td>Murphy-Nolan</td>\n",
       "      <td>561261485107</td>\n",
       "      <td>01/20</td>\n",
       "      <td>947</td>\n",
       "      <td>VISA 16 digit</td>\n",
       "      <td>brittany29@green.biz</td>\n",
       "      <td>Accountant, chartered certified</td>\n",
       "      <td>10.253.36.163</td>\n",
       "      <td>el</td>\n",
       "      <td>8.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9807</td>\n",
       "      <td>76960 Pearson Greens\\nVincentview, NJ 28819</td>\n",
       "      <td>66 EX</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (compatible; MSIE 9.0; Windows NT ...</td>\n",
       "      <td>Hernandez Inc</td>\n",
       "      <td>6011472766372143</td>\n",
       "      <td>08/18</td>\n",
       "      <td>587</td>\n",
       "      <td>JCB 15 digit</td>\n",
       "      <td>deanosborne@yahoo.com</td>\n",
       "      <td>Accountant, chartered certified</td>\n",
       "      <td>120.16.226.53</td>\n",
       "      <td>pt</td>\n",
       "      <td>8.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1313</td>\n",
       "      <td>500 Stefanie Plaza\\nLawrencebury, AL 59120-9959</td>\n",
       "      <td>45 Nu</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (compatible; MSIE 6.0; Windows NT ...</td>\n",
       "      <td>Daniels LLC</td>\n",
       "      <td>4087580144692497</td>\n",
       "      <td>01/21</td>\n",
       "      <td>84</td>\n",
       "      <td>Voyager</td>\n",
       "      <td>lrojas@padilla.biz</td>\n",
       "      <td>Accountant, chartered management</td>\n",
       "      <td>111.88.128.73</td>\n",
       "      <td>de</td>\n",
       "      <td>70.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2475</td>\n",
       "      <td>671 Shields Estate\\nLake Robertton, WA 69702</td>\n",
       "      <td>31 Bw</td>\n",
       "      <td>AM</td>\n",
       "      <td>Mozilla/5.0 (compatible; MSIE 7.0; Windows NT ...</td>\n",
       "      <td>Larson and Sons</td>\n",
       "      <td>348355582719968</td>\n",
       "      <td>06/26</td>\n",
       "      <td>529</td>\n",
       "      <td>Diners Club / Carte Blanche</td>\n",
       "      <td>luis68@casey.com</td>\n",
       "      <td>Accountant, chartered management</td>\n",
       "      <td>234.75.137.90</td>\n",
       "      <td>pt</td>\n",
       "      <td>84.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2831</td>\n",
       "      <td>355 Debbie Drive\\nSouth Juan, IL 28882</td>\n",
       "      <td>72 cU</td>\n",
       "      <td>AM</td>\n",
       "      <td>Mozilla/5.0 (Macintosh; U; PPC Mac OS X 10_5_0...</td>\n",
       "      <td>Butler, Lambert and Chambers</td>\n",
       "      <td>4284257799670133</td>\n",
       "      <td>11/25</td>\n",
       "      <td>263</td>\n",
       "      <td>VISA 16 digit</td>\n",
       "      <td>christopher13@wallace-ingram.com</td>\n",
       "      <td>Accountant, chartered management</td>\n",
       "      <td>209.80.12.222</td>\n",
       "      <td>zh</td>\n",
       "      <td>88.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2912</td>\n",
       "      <td>27399 Brooks Mills\\nNew Benjaminchester, VA 17103</td>\n",
       "      <td>45 XN</td>\n",
       "      <td>PM</td>\n",
       "      <td>Opera/8.70.(X11; Linux x86_64; en-US) Presto/2...</td>\n",
       "      <td>Parker, Andrews and Cabrera</td>\n",
       "      <td>4736630007370</td>\n",
       "      <td>09/19</td>\n",
       "      <td>264</td>\n",
       "      <td>Diners Club / Carte Blanche</td>\n",
       "      <td>morrisaudrey@yahoo.com</td>\n",
       "      <td>Accountant, chartered management</td>\n",
       "      <td>228.242.82.129</td>\n",
       "      <td>it</td>\n",
       "      <td>72.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3543</td>\n",
       "      <td>75062 Timothy Fort\\nNorrishaven, CT 98946-9886</td>\n",
       "      <td>04 iB</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (Windows; U; Windows NT 6.2) Apple...</td>\n",
       "      <td>Escobar-Leon</td>\n",
       "      <td>5218064012959220</td>\n",
       "      <td>04/24</td>\n",
       "      <td>695</td>\n",
       "      <td>Maestro</td>\n",
       "      <td>turnerjoseph@yahoo.com</td>\n",
       "      <td>Accountant, chartered management</td>\n",
       "      <td>32.180.4.166</td>\n",
       "      <td>ru</td>\n",
       "      <td>86.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3740</td>\n",
       "      <td>7924 Baxter Ferry Suite 590\\nBarberland, VA 05...</td>\n",
       "      <td>98 uw</td>\n",
       "      <td>AM</td>\n",
       "      <td>Mozilla/5.0 (iPod; U; CPU iPhone OS 3_1 like M...</td>\n",
       "      <td>Griffin-Stafford</td>\n",
       "      <td>4879630215328</td>\n",
       "      <td>09/23</td>\n",
       "      <td>742</td>\n",
       "      <td>Diners Club / Carte Blanche</td>\n",
       "      <td>paula12@wilson-aguilar.com</td>\n",
       "      <td>Accountant, chartered management</td>\n",
       "      <td>135.106.137.178</td>\n",
       "      <td>pt</td>\n",
       "      <td>62.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3825</td>\n",
       "      <td>0962 Janice Loaf\\nEstesshire, CT 41306</td>\n",
       "      <td>05 CS</td>\n",
       "      <td>AM</td>\n",
       "      <td>Mozilla/5.0 (Windows 98; Win 9x 4.90) AppleWeb...</td>\n",
       "      <td>Meyer-Harvey</td>\n",
       "      <td>3337542935428739</td>\n",
       "      <td>01/25</td>\n",
       "      <td>997</td>\n",
       "      <td>Voyager</td>\n",
       "      <td>ohenderson@pacheco.com</td>\n",
       "      <td>Accountant, chartered management</td>\n",
       "      <td>28.92.201.168</td>\n",
       "      <td>de</td>\n",
       "      <td>52.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4379</td>\n",
       "      <td>USNV Drake\\nFPO AE 07026</td>\n",
       "      <td>40 Xs</td>\n",
       "      <td>AM</td>\n",
       "      <td>Mozilla/5.0 (Windows 98; Win 9x 4.90; it-IT; r...</td>\n",
       "      <td>Scott, Jackson and Rivera</td>\n",
       "      <td>5198145052916552</td>\n",
       "      <td>04/26</td>\n",
       "      <td>226</td>\n",
       "      <td>Voyager</td>\n",
       "      <td>brownjacqueline@yahoo.com</td>\n",
       "      <td>Accountant, chartered management</td>\n",
       "      <td>179.81.35.68</td>\n",
       "      <td>de</td>\n",
       "      <td>35.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5530</td>\n",
       "      <td>74402 Leblanc Vista\\nNew Dianafurt, NE 95009-1182</td>\n",
       "      <td>08 cW</td>\n",
       "      <td>AM</td>\n",
       "      <td>Opera/8.14.(Windows NT 5.01; sl-SI) Presto/2.9...</td>\n",
       "      <td>Anderson Ltd</td>\n",
       "      <td>374089185233815</td>\n",
       "      <td>11/23</td>\n",
       "      <td>644</td>\n",
       "      <td>VISA 16 digit</td>\n",
       "      <td>ywalker@guzman.com</td>\n",
       "      <td>Accountant, chartered management</td>\n",
       "      <td>244.247.195.99</td>\n",
       "      <td>pt</td>\n",
       "      <td>97.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6229</td>\n",
       "      <td>USCGC Davis\\nFPO AE 31505</td>\n",
       "      <td>62 XM</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_8...</td>\n",
       "      <td>Smith-Cox</td>\n",
       "      <td>869914351897808</td>\n",
       "      <td>11/20</td>\n",
       "      <td>375</td>\n",
       "      <td>Discover</td>\n",
       "      <td>oneillcassandra@ramirez.com</td>\n",
       "      <td>Accountant, chartered management</td>\n",
       "      <td>72.20.3.150</td>\n",
       "      <td>it</td>\n",
       "      <td>53.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6874</td>\n",
       "      <td>56433 Kelley Ways Suite 622\\nLopezshire, MI 14...</td>\n",
       "      <td>04 px</td>\n",
       "      <td>AM</td>\n",
       "      <td>Mozilla/5.0 (iPod; U; CPU iPhone OS 4_1 like M...</td>\n",
       "      <td>Hoffman-Miller</td>\n",
       "      <td>30345359240572</td>\n",
       "      <td>02/26</td>\n",
       "      <td>696</td>\n",
       "      <td>JCB 16 digit</td>\n",
       "      <td>jennifernunez@hotmail.com</td>\n",
       "      <td>Accountant, chartered management</td>\n",
       "      <td>98.200.254.132</td>\n",
       "      <td>fr</td>\n",
       "      <td>18.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>7482</td>\n",
       "      <td>71176 Swanson Isle Suite 021\\nMeganmouth, NH 6...</td>\n",
       "      <td>64 Sk</td>\n",
       "      <td>AM</td>\n",
       "      <td>Mozilla/5.0 (Windows NT 5.2; sl-SI; rv:1.9.1.2...</td>\n",
       "      <td>Sweeney-Stephens</td>\n",
       "      <td>4880489191966</td>\n",
       "      <td>12/22</td>\n",
       "      <td>760</td>\n",
       "      <td>VISA 16 digit</td>\n",
       "      <td>raymondschneider@yahoo.com</td>\n",
       "      <td>Accountant, chartered management</td>\n",
       "      <td>201.213.128.100</td>\n",
       "      <td>es</td>\n",
       "      <td>99.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>7521</td>\n",
       "      <td>590 Barbara Place\\nSouth Christyview, MA 18383...</td>\n",
       "      <td>42 Om</td>\n",
       "      <td>AM</td>\n",
       "      <td>Opera/8.44.(Windows NT 5.1; it-IT) Presto/2.9....</td>\n",
       "      <td>Ortega Ltd</td>\n",
       "      <td>4919922933610385</td>\n",
       "      <td>04/21</td>\n",
       "      <td>561</td>\n",
       "      <td>Discover</td>\n",
       "      <td>ghorn@hotmail.com</td>\n",
       "      <td>Accountant, chartered management</td>\n",
       "      <td>118.140.179.35</td>\n",
       "      <td>pt</td>\n",
       "      <td>86.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8729</td>\n",
       "      <td>1526 Mejia Cliffs\\nPort Cindy, AZ 40413-2541</td>\n",
       "      <td>43 lk</td>\n",
       "      <td>AM</td>\n",
       "      <td>Opera/8.87.(Windows CE; it-IT) Presto/2.9.166 ...</td>\n",
       "      <td>Hunter-Tyler</td>\n",
       "      <td>5115692539299466</td>\n",
       "      <td>08/24</td>\n",
       "      <td>670</td>\n",
       "      <td>Discover</td>\n",
       "      <td>christy88@yahoo.com</td>\n",
       "      <td>Accountant, chartered management</td>\n",
       "      <td>53.178.218.119</td>\n",
       "      <td>it</td>\n",
       "      <td>41.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9343</td>\n",
       "      <td>18247 Melissa Spur\\nDanahaven, NC 04268-5052</td>\n",
       "      <td>80 QT</td>\n",
       "      <td>AM</td>\n",
       "      <td>Opera/8.69.(X11; Linux x86_64; sl-SI) Presto/2...</td>\n",
       "      <td>Allison, Oneal and Gould</td>\n",
       "      <td>6011660650452902</td>\n",
       "      <td>05/18</td>\n",
       "      <td>169</td>\n",
       "      <td>VISA 13 digit</td>\n",
       "      <td>brenda62@williams.biz</td>\n",
       "      <td>Accountant, chartered management</td>\n",
       "      <td>166.174.60.198</td>\n",
       "      <td>fr</td>\n",
       "      <td>84.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2376</td>\n",
       "      <td>USNS Smith\\nFPO AE 06757-2270</td>\n",
       "      <td>53 Ve</td>\n",
       "      <td>AM</td>\n",
       "      <td>Opera/9.18.(Windows NT 4.0; it-IT) Presto/2.9....</td>\n",
       "      <td>Hardin, Burton and James</td>\n",
       "      <td>3158161390819062</td>\n",
       "      <td>04/20</td>\n",
       "      <td>676</td>\n",
       "      <td>American Express</td>\n",
       "      <td>jonesgregory@levine.info</td>\n",
       "      <td>Accountant, chartered</td>\n",
       "      <td>198.123.74.51</td>\n",
       "      <td>pt</td>\n",
       "      <td>44.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2408</td>\n",
       "      <td>8993 Kenneth Flat\\nGarciaton, DE 89817</td>\n",
       "      <td>21 yU</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (Macintosh; PPC Mac OS X 10_7_6) A...</td>\n",
       "      <td>Mcbride LLC</td>\n",
       "      <td>5596091334797253</td>\n",
       "      <td>08/22</td>\n",
       "      <td>130</td>\n",
       "      <td>Maestro</td>\n",
       "      <td>stantondanielle@wilson-garcia.info</td>\n",
       "      <td>Accountant, chartered</td>\n",
       "      <td>129.150.159.75</td>\n",
       "      <td>de</td>\n",
       "      <td>87.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2524</td>\n",
       "      <td>USNV Holmes\\nFPO AP 97630-7252</td>\n",
       "      <td>33 Ma</td>\n",
       "      <td>AM</td>\n",
       "      <td>Mozilla/5.0 (Windows 98) AppleWebKit/5311 (KHT...</td>\n",
       "      <td>Smith, Adams and Perez</td>\n",
       "      <td>180093607439285</td>\n",
       "      <td>05/24</td>\n",
       "      <td>17</td>\n",
       "      <td>Diners Club / Carte Blanche</td>\n",
       "      <td>wyattnicholas@yahoo.com</td>\n",
       "      <td>Accountant, chartered</td>\n",
       "      <td>179.145.95.106</td>\n",
       "      <td>zh</td>\n",
       "      <td>55.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2658</td>\n",
       "      <td>6771 Day Manor Suite 175\\nWest Amyshire, MD 87...</td>\n",
       "      <td>73 ds</td>\n",
       "      <td>AM</td>\n",
       "      <td>Mozilla/5.0 (compatible; MSIE 6.0; Windows 95;...</td>\n",
       "      <td>Tucker Inc</td>\n",
       "      <td>589384693778</td>\n",
       "      <td>09/25</td>\n",
       "      <td>400</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>jon59@yahoo.com</td>\n",
       "      <td>Accountant, chartered</td>\n",
       "      <td>188.87.254.122</td>\n",
       "      <td>zh</td>\n",
       "      <td>98.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3003</td>\n",
       "      <td>388 Ronald Light\\nNew Emilyland, MN 59256</td>\n",
       "      <td>63 PG</td>\n",
       "      <td>PM</td>\n",
       "      <td>Opera/8.78.(Windows NT 5.01; it-IT) Presto/2.9...</td>\n",
       "      <td>Smith-Montoya</td>\n",
       "      <td>3096974671691454</td>\n",
       "      <td>04/25</td>\n",
       "      <td>869</td>\n",
       "      <td>American Express</td>\n",
       "      <td>alan12@hotmail.com</td>\n",
       "      <td>Accountant, chartered</td>\n",
       "      <td>128.255.179.93</td>\n",
       "      <td>el</td>\n",
       "      <td>10.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3774</td>\n",
       "      <td>1858 Todd Lodge\\nEast Lancehaven, AL 06362</td>\n",
       "      <td>02 oc</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (X11; Linux i686) AppleWebKit/5362...</td>\n",
       "      <td>Nguyen Inc</td>\n",
       "      <td>5189501564675303</td>\n",
       "      <td>11/16</td>\n",
       "      <td>245</td>\n",
       "      <td>Voyager</td>\n",
       "      <td>yturner@yahoo.com</td>\n",
       "      <td>Accountant, chartered</td>\n",
       "      <td>168.241.114.245</td>\n",
       "      <td>pt</td>\n",
       "      <td>75.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4314</td>\n",
       "      <td>0274 Kimberly Shoal\\nRebeccabury, KS 68782</td>\n",
       "      <td>33 Cx</td>\n",
       "      <td>PM</td>\n",
       "      <td>Opera/8.82.(Windows NT 5.01; sl-SI) Presto/2.9...</td>\n",
       "      <td>Miller PLC</td>\n",
       "      <td>869977018146430</td>\n",
       "      <td>05/23</td>\n",
       "      <td>224</td>\n",
       "      <td>Discover</td>\n",
       "      <td>carolynjones@gmail.com</td>\n",
       "      <td>Accountant, chartered</td>\n",
       "      <td>97.183.214.220</td>\n",
       "      <td>es</td>\n",
       "      <td>60.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4778</td>\n",
       "      <td>359 Alexandria Extension\\nFoxtown, TX 87755</td>\n",
       "      <td>92 Bs</td>\n",
       "      <td>AM</td>\n",
       "      <td>Opera/9.27.(X11; Linux x86_64; en-US) Presto/2...</td>\n",
       "      <td>Gibson-Garcia</td>\n",
       "      <td>373158334321036</td>\n",
       "      <td>01/24</td>\n",
       "      <td>274</td>\n",
       "      <td>Maestro</td>\n",
       "      <td>vmiller@smith.com</td>\n",
       "      <td>Accountant, chartered</td>\n",
       "      <td>231.232.29.121</td>\n",
       "      <td>zh</td>\n",
       "      <td>4.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4780</td>\n",
       "      <td>217 Dyer Harbor\\nNorth Audreybury, KY 90403-2774</td>\n",
       "      <td>15 fw</td>\n",
       "      <td>AM</td>\n",
       "      <td>Mozilla/5.0 (Windows NT 5.2; it-IT; rv:1.9.2.2...</td>\n",
       "      <td>Carter, Pittman and Brown</td>\n",
       "      <td>373375335115734</td>\n",
       "      <td>01/24</td>\n",
       "      <td>6288</td>\n",
       "      <td>VISA 16 digit</td>\n",
       "      <td>dprince@swanson.com</td>\n",
       "      <td>Accountant, chartered</td>\n",
       "      <td>167.252.198.19</td>\n",
       "      <td>ru</td>\n",
       "      <td>97.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5028</td>\n",
       "      <td>17751 Angel Road\\nWilliamsshire, MH 75886</td>\n",
       "      <td>37 He</td>\n",
       "      <td>AM</td>\n",
       "      <td>Mozilla/5.0 (iPod; U; CPU iPhone OS 4_1 like M...</td>\n",
       "      <td>Lawson, Contreras and Maxwell</td>\n",
       "      <td>3096828489837743</td>\n",
       "      <td>05/25</td>\n",
       "      <td>157</td>\n",
       "      <td>JCB 15 digit</td>\n",
       "      <td>paulamanda@hotmail.com</td>\n",
       "      <td>Accountant, chartered</td>\n",
       "      <td>178.228.178.157</td>\n",
       "      <td>de</td>\n",
       "      <td>97.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>7220</td>\n",
       "      <td>45257 Kristen Springs\\nAmberton, OK 73996</td>\n",
       "      <td>09 yq</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (iPod; U; CPU iPhone OS 4_3 like M...</td>\n",
       "      <td>House, Rodriguez and Keith</td>\n",
       "      <td>346579304534866</td>\n",
       "      <td>10/22</td>\n",
       "      <td>149</td>\n",
       "      <td>JCB 15 digit</td>\n",
       "      <td>vhicks@hotmail.com</td>\n",
       "      <td>Accountant, chartered</td>\n",
       "      <td>90.30.165.62</td>\n",
       "      <td>pt</td>\n",
       "      <td>28.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>7422</td>\n",
       "      <td>674 Erin Square\\nNew Nicole, CT 21552</td>\n",
       "      <td>47 Vp</td>\n",
       "      <td>AM</td>\n",
       "      <td>Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_8...</td>\n",
       "      <td>Vasquez-Hutchinson</td>\n",
       "      <td>3158859057305925</td>\n",
       "      <td>10/20</td>\n",
       "      <td>662</td>\n",
       "      <td>Diners Club / Carte Blanche</td>\n",
       "      <td>maria01@gmail.com</td>\n",
       "      <td>Accountant, chartered</td>\n",
       "      <td>250.18.99.82</td>\n",
       "      <td>fr</td>\n",
       "      <td>8.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>7699</td>\n",
       "      <td>639 Edwards Radial\\nLake Donnahaven, NE 62546</td>\n",
       "      <td>97 jq</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (Windows 98; sl-SI; rv:1.9.2.20) G...</td>\n",
       "      <td>Greer-Garcia</td>\n",
       "      <td>676217573051</td>\n",
       "      <td>09/16</td>\n",
       "      <td>916</td>\n",
       "      <td>JCB 16 digit</td>\n",
       "      <td>qmartinez@yahoo.com</td>\n",
       "      <td>Accountant, chartered</td>\n",
       "      <td>59.246.127.153</td>\n",
       "      <td>el</td>\n",
       "      <td>1.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8136</td>\n",
       "      <td>4435 Tracy Stream Suite 945\\nWrighthaven, KS 8...</td>\n",
       "      <td>36 ue</td>\n",
       "      <td>AM</td>\n",
       "      <td>Opera/9.69.(X11; Linux x86_64; it-IT) Presto/2...</td>\n",
       "      <td>White LLC</td>\n",
       "      <td>4825363058881993</td>\n",
       "      <td>10/23</td>\n",
       "      <td>3613</td>\n",
       "      <td>JCB 16 digit</td>\n",
       "      <td>lisaunderwood@yahoo.com</td>\n",
       "      <td>Accountant, chartered</td>\n",
       "      <td>41.142.200.224</td>\n",
       "      <td>el</td>\n",
       "      <td>88.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8419</td>\n",
       "      <td>985 Shannon Shore Apt. 704\\nJohnsonport, MN 11780</td>\n",
       "      <td>17 Cl</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (Windows 95) AppleWebKit/5360 (KHT...</td>\n",
       "      <td>Turner Group</td>\n",
       "      <td>639059039391</td>\n",
       "      <td>09/18</td>\n",
       "      <td>971</td>\n",
       "      <td>JCB 16 digit</td>\n",
       "      <td>jacksonsandra@hotmail.com</td>\n",
       "      <td>Accountant, chartered</td>\n",
       "      <td>197.229.42.100</td>\n",
       "      <td>zh</td>\n",
       "      <td>31.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8597</td>\n",
       "      <td>344 Kenneth Village\\nGlennburgh, WI 94559</td>\n",
       "      <td>51 bu</td>\n",
       "      <td>AM</td>\n",
       "      <td>Mozilla/5.0 (X11; Linux i686) AppleWebKit/5361...</td>\n",
       "      <td>Johnson, Moore and Howard</td>\n",
       "      <td>4452121673733928</td>\n",
       "      <td>11/23</td>\n",
       "      <td>783</td>\n",
       "      <td>JCB 16 digit</td>\n",
       "      <td>david20@nguyen-rodriguez.com</td>\n",
       "      <td>Accountant, chartered</td>\n",
       "      <td>143.111.47.114</td>\n",
       "      <td>en</td>\n",
       "      <td>88.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9028</td>\n",
       "      <td>PSC 6683, Box 3165\\nAPO AP 82494-0426</td>\n",
       "      <td>55 eP</td>\n",
       "      <td>AM</td>\n",
       "      <td>Mozilla/5.0 (compatible; MSIE 5.0; Windows 95;...</td>\n",
       "      <td>Gray, Huff and Morales</td>\n",
       "      <td>345053426868843</td>\n",
       "      <td>02/17</td>\n",
       "      <td>171</td>\n",
       "      <td>VISA 16 digit</td>\n",
       "      <td>nicole03@byrd-simpson.com</td>\n",
       "      <td>Accountant, chartered</td>\n",
       "      <td>14.147.174.189</td>\n",
       "      <td>fr</td>\n",
       "      <td>0.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9209</td>\n",
       "      <td>018 Campbell Extension Suite 227\\nNorth Elizab...</td>\n",
       "      <td>22 dY</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (iPod; U; CPU iPhone OS 3_2 like M...</td>\n",
       "      <td>Gonzalez Inc</td>\n",
       "      <td>6011547191093198</td>\n",
       "      <td>06/23</td>\n",
       "      <td>52</td>\n",
       "      <td>JCB 16 digit</td>\n",
       "      <td>vchavez@hotmail.com</td>\n",
       "      <td>Accountant, chartered</td>\n",
       "      <td>221.115.243.52</td>\n",
       "      <td>pt</td>\n",
       "      <td>89.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9893</td>\n",
       "      <td>994 Norton Junctions\\nMichaelberg, OR 19245-6514</td>\n",
       "      <td>70 oU</td>\n",
       "      <td>AM</td>\n",
       "      <td>Opera/9.14.(Windows 98; it-IT) Presto/2.9.177 ...</td>\n",
       "      <td>Benjamin-Gould</td>\n",
       "      <td>502005550392</td>\n",
       "      <td>02/25</td>\n",
       "      <td>981</td>\n",
       "      <td>VISA 13 digit</td>\n",
       "      <td>masonlaurie@molina.com</td>\n",
       "      <td>Accountant, chartered</td>\n",
       "      <td>147.232.252.231</td>\n",
       "      <td>fr</td>\n",
       "      <td>48.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9913</td>\n",
       "      <td>13914 Casey Unions\\nWillisside, WA 40015</td>\n",
       "      <td>47 zP</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (Macintosh; PPC Mac OS X 10_5_7 rv...</td>\n",
       "      <td>Berry, Rocha and Ayers</td>\n",
       "      <td>180049776099458</td>\n",
       "      <td>11/25</td>\n",
       "      <td>195</td>\n",
       "      <td>VISA 13 digit</td>\n",
       "      <td>taylorjohn@daniel.com</td>\n",
       "      <td>Accountant, chartered</td>\n",
       "      <td>163.34.234.113</td>\n",
       "      <td>de</td>\n",
       "      <td>34.85</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                Address    Lot AM or PM  \\\n",
       "1269  155 Santiago Mill\\nLake Rebeccamouth, MH 24582...  48 LI       AM   \n",
       "2279  22238 Hudson Brook Apt. 446\\nStevenbury, WV 82590  08 Fe       PM   \n",
       "2350     928 Rhodes Isle\\nPort Jamesport, NY 72568-2200  18 Zf       PM   \n",
       "2461        19313 Saunders Freeway\\nPort Ryan, MA 00609  55 aP       AM   \n",
       "4236  8691 Love Neck Apt. 138\\nPort Jesus, WV 12384-...  21 Qp       AM   \n",
       "5141  10963 Rogers Streets Apt. 831\\nJohnberg, VA 99...  99 or       AM   \n",
       "5371  41797 Baker Circle Suite 589\\nSloanbury, TN 81...  64 WT       PM   \n",
       "5430        5863 Teresa Tunnel\\nJoshuachester, IA 25187  78 sJ       AM   \n",
       "5633  710 Harris Alley Apt. 421\\nJohnsonhaven, SD 51534  65 sh       AM   \n",
       "5847     3861 Pearson Dam Apt. 169\\nBruceview, MO 02165  26 UJ       AM   \n",
       "6146  09120 Gutierrez Roads Suite 449\\nKingshire, CO...  59 Da       PM   \n",
       "6496                   PSC 6951, Box 5906\\nAPO AE 75010  42 tV       PM   \n",
       "6511    2551 Schneider Center\\nGrantland, ID 14442-3339  25 DA       PM   \n",
       "8569  830 Steven Views Suite 879\\nAllenburgh, NJ 617...  46 bN       PM   \n",
       "8593  8983 Ferrell Springs Suite 238\\nNorth David, M...  19 fm       PM   \n",
       "9645      5169 Justin Branch\\nTracyburgh, OR 21055-9526  99 nl       PM   \n",
       "9706       1841 Fisher Flats\\nWest Sierrabury, WA 99755  04 gV       PM   \n",
       "9807        76960 Pearson Greens\\nVincentview, NJ 28819  66 EX       PM   \n",
       "1313    500 Stefanie Plaza\\nLawrencebury, AL 59120-9959  45 Nu       PM   \n",
       "2475       671 Shields Estate\\nLake Robertton, WA 69702  31 Bw       AM   \n",
       "2831             355 Debbie Drive\\nSouth Juan, IL 28882  72 cU       AM   \n",
       "2912  27399 Brooks Mills\\nNew Benjaminchester, VA 17103  45 XN       PM   \n",
       "3543     75062 Timothy Fort\\nNorrishaven, CT 98946-9886  04 iB       PM   \n",
       "3740  7924 Baxter Ferry Suite 590\\nBarberland, VA 05...  98 uw       AM   \n",
       "3825             0962 Janice Loaf\\nEstesshire, CT 41306  05 CS       AM   \n",
       "4379                           USNV Drake\\nFPO AE 07026  40 Xs       AM   \n",
       "5530  74402 Leblanc Vista\\nNew Dianafurt, NE 95009-1182  08 cW       AM   \n",
       "6229                          USCGC Davis\\nFPO AE 31505  62 XM       PM   \n",
       "6874  56433 Kelley Ways Suite 622\\nLopezshire, MI 14...  04 px       AM   \n",
       "7482  71176 Swanson Isle Suite 021\\nMeganmouth, NH 6...  64 Sk       AM   \n",
       "7521  590 Barbara Place\\nSouth Christyview, MA 18383...  42 Om       AM   \n",
       "8729       1526 Mejia Cliffs\\nPort Cindy, AZ 40413-2541  43 lk       AM   \n",
       "9343       18247 Melissa Spur\\nDanahaven, NC 04268-5052  80 QT       AM   \n",
       "2376                      USNS Smith\\nFPO AE 06757-2270  53 Ve       AM   \n",
       "2408             8993 Kenneth Flat\\nGarciaton, DE 89817  21 yU       PM   \n",
       "2524                     USNV Holmes\\nFPO AP 97630-7252  33 Ma       AM   \n",
       "2658  6771 Day Manor Suite 175\\nWest Amyshire, MD 87...  73 ds       AM   \n",
       "3003          388 Ronald Light\\nNew Emilyland, MN 59256  63 PG       PM   \n",
       "3774         1858 Todd Lodge\\nEast Lancehaven, AL 06362  02 oc       PM   \n",
       "4314         0274 Kimberly Shoal\\nRebeccabury, KS 68782  33 Cx       PM   \n",
       "4778        359 Alexandria Extension\\nFoxtown, TX 87755  92 Bs       AM   \n",
       "4780   217 Dyer Harbor\\nNorth Audreybury, KY 90403-2774  15 fw       AM   \n",
       "5028          17751 Angel Road\\nWilliamsshire, MH 75886  37 He       AM   \n",
       "7220          45257 Kristen Springs\\nAmberton, OK 73996  09 yq       PM   \n",
       "7422              674 Erin Square\\nNew Nicole, CT 21552  47 Vp       AM   \n",
       "7699      639 Edwards Radial\\nLake Donnahaven, NE 62546  97 jq       PM   \n",
       "8136  4435 Tracy Stream Suite 945\\nWrighthaven, KS 8...  36 ue       AM   \n",
       "8419  985 Shannon Shore Apt. 704\\nJohnsonport, MN 11780  17 Cl       PM   \n",
       "8597          344 Kenneth Village\\nGlennburgh, WI 94559  51 bu       AM   \n",
       "9028              PSC 6683, Box 3165\\nAPO AP 82494-0426  55 eP       AM   \n",
       "9209  018 Campbell Extension Suite 227\\nNorth Elizab...  22 dY       PM   \n",
       "9893   994 Norton Junctions\\nMichaelberg, OR 19245-6514  70 oU       AM   \n",
       "9913           13914 Casey Unions\\nWillisside, WA 40015  47 zP       PM   \n",
       "\n",
       "                                           Browser Info  \\\n",
       "1269  Mozilla/5.0 (compatible; MSIE 6.0; Windows NT ...   \n",
       "2279  Mozilla/5.0 (X11; Linux x86_64; rv:1.9.7.20) G...   \n",
       "2350  Mozilla/5.0 (X11; Linux x86_64; rv:1.9.5.20) G...   \n",
       "2461  Mozilla/5.0 (Windows NT 5.01; en-US; rv:1.9.1....   \n",
       "4236  Opera/9.28.(Windows NT 5.2; it-IT) Presto/2.9....   \n",
       "5141  Mozilla/5.0 (compatible; MSIE 6.0; Windows 98;...   \n",
       "5371  Opera/8.36.(Windows 98; Win 9x 4.90; en-US) Pr...   \n",
       "5430  Mozilla/5.0 (Windows 98) AppleWebKit/5312 (KHT...   \n",
       "5633  Mozilla/5.0 (Windows NT 5.1) AppleWebKit/5361 ...   \n",
       "5847  Mozilla/5.0 (Windows; U; Windows NT 5.0) Apple...   \n",
       "6146  Mozilla/5.0 (Windows NT 5.2) AppleWebKit/5312 ...   \n",
       "6496  Opera/8.41.(Windows NT 5.01; it-IT) Presto/2.9...   \n",
       "6511  Mozilla/5.0 (Windows NT 5.01; sl-SI; rv:1.9.0....   \n",
       "8569  Mozilla/5.0 (compatible; MSIE 7.0; Windows CE;...   \n",
       "8593  Mozilla/5.0 (Windows NT 6.1) AppleWebKit/5332 ...   \n",
       "9645  Opera/8.62.(Windows NT 5.0; it-IT) Presto/2.9....   \n",
       "9706  Opera/8.78.(X11; Linux i686; sl-SI) Presto/2.9...   \n",
       "9807  Mozilla/5.0 (compatible; MSIE 9.0; Windows NT ...   \n",
       "1313  Mozilla/5.0 (compatible; MSIE 6.0; Windows NT ...   \n",
       "2475  Mozilla/5.0 (compatible; MSIE 7.0; Windows NT ...   \n",
       "2831  Mozilla/5.0 (Macintosh; U; PPC Mac OS X 10_5_0...   \n",
       "2912  Opera/8.70.(X11; Linux x86_64; en-US) Presto/2...   \n",
       "3543  Mozilla/5.0 (Windows; U; Windows NT 6.2) Apple...   \n",
       "3740  Mozilla/5.0 (iPod; U; CPU iPhone OS 3_1 like M...   \n",
       "3825  Mozilla/5.0 (Windows 98; Win 9x 4.90) AppleWeb...   \n",
       "4379  Mozilla/5.0 (Windows 98; Win 9x 4.90; it-IT; r...   \n",
       "5530  Opera/8.14.(Windows NT 5.01; sl-SI) Presto/2.9...   \n",
       "6229  Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_8...   \n",
       "6874  Mozilla/5.0 (iPod; U; CPU iPhone OS 4_1 like M...   \n",
       "7482  Mozilla/5.0 (Windows NT 5.2; sl-SI; rv:1.9.1.2...   \n",
       "7521  Opera/8.44.(Windows NT 5.1; it-IT) Presto/2.9....   \n",
       "8729  Opera/8.87.(Windows CE; it-IT) Presto/2.9.166 ...   \n",
       "9343  Opera/8.69.(X11; Linux x86_64; sl-SI) Presto/2...   \n",
       "2376  Opera/9.18.(Windows NT 4.0; it-IT) Presto/2.9....   \n",
       "2408  Mozilla/5.0 (Macintosh; PPC Mac OS X 10_7_6) A...   \n",
       "2524  Mozilla/5.0 (Windows 98) AppleWebKit/5311 (KHT...   \n",
       "2658  Mozilla/5.0 (compatible; MSIE 6.0; Windows 95;...   \n",
       "3003  Opera/8.78.(Windows NT 5.01; it-IT) Presto/2.9...   \n",
       "3774  Mozilla/5.0 (X11; Linux i686) AppleWebKit/5362...   \n",
       "4314  Opera/8.82.(Windows NT 5.01; sl-SI) Presto/2.9...   \n",
       "4778  Opera/9.27.(X11; Linux x86_64; en-US) Presto/2...   \n",
       "4780  Mozilla/5.0 (Windows NT 5.2; it-IT; rv:1.9.2.2...   \n",
       "5028  Mozilla/5.0 (iPod; U; CPU iPhone OS 4_1 like M...   \n",
       "7220  Mozilla/5.0 (iPod; U; CPU iPhone OS 4_3 like M...   \n",
       "7422  Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_8...   \n",
       "7699  Mozilla/5.0 (Windows 98; sl-SI; rv:1.9.2.20) G...   \n",
       "8136  Opera/9.69.(X11; Linux x86_64; it-IT) Presto/2...   \n",
       "8419  Mozilla/5.0 (Windows 95) AppleWebKit/5360 (KHT...   \n",
       "8597  Mozilla/5.0 (X11; Linux i686) AppleWebKit/5361...   \n",
       "9028  Mozilla/5.0 (compatible; MSIE 5.0; Windows 95;...   \n",
       "9209  Mozilla/5.0 (iPod; U; CPU iPhone OS 3_2 like M...   \n",
       "9893  Opera/9.14.(Windows 98; it-IT) Presto/2.9.177 ...   \n",
       "9913  Mozilla/5.0 (Macintosh; PPC Mac OS X 10_5_7 rv...   \n",
       "\n",
       "                            Company       Credit Card CC Exp Date  \\\n",
       "1269                    Wells-Davis  3112136366815760       04/26   \n",
       "2279          Singh, Jones and Cook  4287942833441354       05/21   \n",
       "2350                 Moore-Williams  4398601867787902       01/23   \n",
       "2461   Thompson, Brown and Castillo  4139428822206875       11/19   \n",
       "4236                  Kane and Sons      503809873451       07/26   \n",
       "5141               Gonzalez-Douglas    30316587872817       02/23   \n",
       "5371                       Love LLC   210077418391748       08/18   \n",
       "5430                    Blake-Weber  3158317939609733       12/18   \n",
       "5633    Fisher, Salinas and Sanders  4006602558662051       10/16   \n",
       "5847                    Kelly Group    30246600971850       01/20   \n",
       "6146     Mullen, Kramer and Hawkins  4338530728077992       10/21   \n",
       "6496                      Smith Inc    30453800763836       11/21   \n",
       "6511                   Lopez-Graham      503859378450       09/20   \n",
       "8569                     Barker Inc   210033680750442       06/24   \n",
       "8593                    Roberts Ltd  3096328278865906       12/23   \n",
       "9645      Leblanc, Bernard and Paul   342534748307985       10/23   \n",
       "9706                   Murphy-Nolan      561261485107       01/20   \n",
       "9807                  Hernandez Inc  6011472766372143       08/18   \n",
       "1313                    Daniels LLC  4087580144692497       01/21   \n",
       "2475                Larson and Sons   348355582719968       06/26   \n",
       "2831   Butler, Lambert and Chambers  4284257799670133       11/25   \n",
       "2912    Parker, Andrews and Cabrera     4736630007370       09/19   \n",
       "3543                   Escobar-Leon  5218064012959220       04/24   \n",
       "3740               Griffin-Stafford     4879630215328       09/23   \n",
       "3825                   Meyer-Harvey  3337542935428739       01/25   \n",
       "4379      Scott, Jackson and Rivera  5198145052916552       04/26   \n",
       "5530                   Anderson Ltd   374089185233815       11/23   \n",
       "6229                      Smith-Cox   869914351897808       11/20   \n",
       "6874                 Hoffman-Miller    30345359240572       02/26   \n",
       "7482               Sweeney-Stephens     4880489191966       12/22   \n",
       "7521                     Ortega Ltd  4919922933610385       04/21   \n",
       "8729                   Hunter-Tyler  5115692539299466       08/24   \n",
       "9343       Allison, Oneal and Gould  6011660650452902       05/18   \n",
       "2376       Hardin, Burton and James  3158161390819062       04/20   \n",
       "2408                    Mcbride LLC  5596091334797253       08/22   \n",
       "2524         Smith, Adams and Perez   180093607439285       05/24   \n",
       "2658                     Tucker Inc      589384693778       09/25   \n",
       "3003                  Smith-Montoya  3096974671691454       04/25   \n",
       "3774                     Nguyen Inc  5189501564675303       11/16   \n",
       "4314                     Miller PLC   869977018146430       05/23   \n",
       "4778                  Gibson-Garcia   373158334321036       01/24   \n",
       "4780      Carter, Pittman and Brown   373375335115734       01/24   \n",
       "5028  Lawson, Contreras and Maxwell  3096828489837743       05/25   \n",
       "7220     House, Rodriguez and Keith   346579304534866       10/22   \n",
       "7422             Vasquez-Hutchinson  3158859057305925       10/20   \n",
       "7699                   Greer-Garcia      676217573051       09/16   \n",
       "8136                      White LLC  4825363058881993       10/23   \n",
       "8419                   Turner Group      639059039391       09/18   \n",
       "8597      Johnson, Moore and Howard  4452121673733928       11/23   \n",
       "9028         Gray, Huff and Morales   345053426868843       02/17   \n",
       "9209                   Gonzalez Inc  6011547191093198       06/23   \n",
       "9893                 Benjamin-Gould      502005550392       02/25   \n",
       "9913         Berry, Rocha and Ayers   180049776099458       11/25   \n",
       "\n",
       "      CC Security Code                  CC Provider  \\\n",
       "1269               234                   Mastercard   \n",
       "2279               327  Diners Club / Carte Blanche   \n",
       "2350                33             American Express   \n",
       "2461               345                VISA 13 digit   \n",
       "4236               857                      Voyager   \n",
       "5141               449                      Maestro   \n",
       "5371               312                      Maestro   \n",
       "5430               972                      Voyager   \n",
       "5633               136                 JCB 15 digit   \n",
       "5847               117                   Mastercard   \n",
       "6146               950                     Discover   \n",
       "6496               610                 JCB 16 digit   \n",
       "6511                37                     Discover   \n",
       "8569               579                VISA 16 digit   \n",
       "8593               667                 JCB 15 digit   \n",
       "9645               371                 JCB 16 digit   \n",
       "9706               947                VISA 16 digit   \n",
       "9807               587                 JCB 15 digit   \n",
       "1313                84                      Voyager   \n",
       "2475               529  Diners Club / Carte Blanche   \n",
       "2831               263                VISA 16 digit   \n",
       "2912               264  Diners Club / Carte Blanche   \n",
       "3543               695                      Maestro   \n",
       "3740               742  Diners Club / Carte Blanche   \n",
       "3825               997                      Voyager   \n",
       "4379               226                      Voyager   \n",
       "5530               644                VISA 16 digit   \n",
       "6229               375                     Discover   \n",
       "6874               696                 JCB 16 digit   \n",
       "7482               760                VISA 16 digit   \n",
       "7521               561                     Discover   \n",
       "8729               670                     Discover   \n",
       "9343               169                VISA 13 digit   \n",
       "2376               676             American Express   \n",
       "2408               130                      Maestro   \n",
       "2524                17  Diners Club / Carte Blanche   \n",
       "2658               400                   Mastercard   \n",
       "3003               869             American Express   \n",
       "3774               245                      Voyager   \n",
       "4314               224                     Discover   \n",
       "4778               274                      Maestro   \n",
       "4780              6288                VISA 16 digit   \n",
       "5028               157                 JCB 15 digit   \n",
       "7220               149                 JCB 15 digit   \n",
       "7422               662  Diners Club / Carte Blanche   \n",
       "7699               916                 JCB 16 digit   \n",
       "8136              3613                 JCB 16 digit   \n",
       "8419               971                 JCB 16 digit   \n",
       "8597               783                 JCB 16 digit   \n",
       "9028               171                VISA 16 digit   \n",
       "9209                52                 JCB 16 digit   \n",
       "9893               981                VISA 13 digit   \n",
       "9913               195                VISA 13 digit   \n",
       "\n",
       "                                   Email                               Job  \\\n",
       "1269            floresmichelle@yahoo.com   Accountant, chartered certified   \n",
       "2279            tammy81@grimes-gross.com   Accountant, chartered certified   \n",
       "2350                   amy45@hotmail.com   Accountant, chartered certified   \n",
       "2461                   qhuerta@yahoo.com   Accountant, chartered certified   \n",
       "4236                 rpage@henderson.net   Accountant, chartered certified   \n",
       "5141                    rsmith@white.com   Accountant, chartered certified   \n",
       "5371          christopher87@saunders.net   Accountant, chartered certified   \n",
       "5430             hannahblair@hotmail.com   Accountant, chartered certified   \n",
       "5633             jeffreykeith@rivers.com   Accountant, chartered certified   \n",
       "5847             kristinmiller@yahoo.com   Accountant, chartered certified   \n",
       "6146           williamskatelyn@gmail.com   Accountant, chartered certified   \n",
       "6496                 bbrown@richmond.com   Accountant, chartered certified   \n",
       "6511                  tsanchez@gmail.com   Accountant, chartered certified   \n",
       "8569                  justin92@smith.com   Accountant, chartered certified   \n",
       "8593             kellermark@stanton.info   Accountant, chartered certified   \n",
       "9645             tararussell@hotmail.com   Accountant, chartered certified   \n",
       "9706                brittany29@green.biz   Accountant, chartered certified   \n",
       "9807               deanosborne@yahoo.com   Accountant, chartered certified   \n",
       "1313                  lrojas@padilla.biz  Accountant, chartered management   \n",
       "2475                    luis68@casey.com  Accountant, chartered management   \n",
       "2831    christopher13@wallace-ingram.com  Accountant, chartered management   \n",
       "2912              morrisaudrey@yahoo.com  Accountant, chartered management   \n",
       "3543              turnerjoseph@yahoo.com  Accountant, chartered management   \n",
       "3740          paula12@wilson-aguilar.com  Accountant, chartered management   \n",
       "3825              ohenderson@pacheco.com  Accountant, chartered management   \n",
       "4379           brownjacqueline@yahoo.com  Accountant, chartered management   \n",
       "5530                  ywalker@guzman.com  Accountant, chartered management   \n",
       "6229         oneillcassandra@ramirez.com  Accountant, chartered management   \n",
       "6874           jennifernunez@hotmail.com  Accountant, chartered management   \n",
       "7482          raymondschneider@yahoo.com  Accountant, chartered management   \n",
       "7521                   ghorn@hotmail.com  Accountant, chartered management   \n",
       "8729                 christy88@yahoo.com  Accountant, chartered management   \n",
       "9343               brenda62@williams.biz  Accountant, chartered management   \n",
       "2376            jonesgregory@levine.info             Accountant, chartered   \n",
       "2408  stantondanielle@wilson-garcia.info             Accountant, chartered   \n",
       "2524             wyattnicholas@yahoo.com             Accountant, chartered   \n",
       "2658                     jon59@yahoo.com             Accountant, chartered   \n",
       "3003                  alan12@hotmail.com             Accountant, chartered   \n",
       "3774                   yturner@yahoo.com             Accountant, chartered   \n",
       "4314              carolynjones@gmail.com             Accountant, chartered   \n",
       "4778                   vmiller@smith.com             Accountant, chartered   \n",
       "4780                 dprince@swanson.com             Accountant, chartered   \n",
       "5028              paulamanda@hotmail.com             Accountant, chartered   \n",
       "7220                  vhicks@hotmail.com             Accountant, chartered   \n",
       "7422                   maria01@gmail.com             Accountant, chartered   \n",
       "7699                 qmartinez@yahoo.com             Accountant, chartered   \n",
       "8136             lisaunderwood@yahoo.com             Accountant, chartered   \n",
       "8419           jacksonsandra@hotmail.com             Accountant, chartered   \n",
       "8597        david20@nguyen-rodriguez.com             Accountant, chartered   \n",
       "9028           nicole03@byrd-simpson.com             Accountant, chartered   \n",
       "9209                 vchavez@hotmail.com             Accountant, chartered   \n",
       "9893              masonlaurie@molina.com             Accountant, chartered   \n",
       "9913               taylorjohn@daniel.com             Accountant, chartered   \n",
       "\n",
       "           IP Address Language  Purchase Price  \n",
       "1269   192.169.49.221       pt           51.53  \n",
       "2279    180.0.100.129       it           96.78  \n",
       "2350  104.248.117.134       it           76.78  \n",
       "2461  169.125.173.174       en           92.71  \n",
       "4236   131.194.11.206       de           52.06  \n",
       "5141     76.238.96.32       de           13.75  \n",
       "5371    91.241.216.32       el           69.10  \n",
       "5430      50.0.33.238       de           58.74  \n",
       "5633    254.227.63.33       fr           89.33  \n",
       "5847   16.105.182.206       el           95.42  \n",
       "6146   147.173.29.155       de           18.12  \n",
       "6496   204.65.186.250       el           67.86  \n",
       "6511     77.118.67.29       fr           52.34  \n",
       "8569   131.211.241.41       zh           67.75  \n",
       "8593   252.12.156.169       el           62.53  \n",
       "9645     1.32.225.174       el           61.44  \n",
       "9706    10.253.36.163       el            8.39  \n",
       "9807    120.16.226.53       pt            8.38  \n",
       "1313    111.88.128.73       de           70.48  \n",
       "2475    234.75.137.90       pt           84.65  \n",
       "2831    209.80.12.222       zh           88.83  \n",
       "2912   228.242.82.129       it           72.87  \n",
       "3543     32.180.4.166       ru           86.68  \n",
       "3740  135.106.137.178       pt           62.26  \n",
       "3825    28.92.201.168       de           52.22  \n",
       "4379     179.81.35.68       de           35.85  \n",
       "5530   244.247.195.99       pt           97.72  \n",
       "6229      72.20.3.150       it           53.26  \n",
       "6874   98.200.254.132       fr           18.71  \n",
       "7482  201.213.128.100       es           99.90  \n",
       "7521   118.140.179.35       pt           86.91  \n",
       "8729   53.178.218.119       it           41.86  \n",
       "9343   166.174.60.198       fr           84.04  \n",
       "2376    198.123.74.51       pt           44.78  \n",
       "2408   129.150.159.75       de           87.02  \n",
       "2524   179.145.95.106       zh           55.02  \n",
       "2658   188.87.254.122       zh           98.54  \n",
       "3003   128.255.179.93       el           10.39  \n",
       "3774  168.241.114.245       pt           75.59  \n",
       "4314   97.183.214.220       es           60.44  \n",
       "4778   231.232.29.121       zh            4.14  \n",
       "4780   167.252.198.19       ru           97.40  \n",
       "5028  178.228.178.157       de           97.76  \n",
       "7220     90.30.165.62       pt           28.98  \n",
       "7422     250.18.99.82       fr            8.84  \n",
       "7699   59.246.127.153       el            1.81  \n",
       "8136   41.142.200.224       el           88.03  \n",
       "8419   197.229.42.100       zh           31.44  \n",
       "8597   143.111.47.114       en           88.40  \n",
       "9028   14.147.174.189       fr            0.49  \n",
       "9209   221.115.243.52       pt           89.34  \n",
       "9893  147.232.252.231       fr           48.05  \n",
       "9913   163.34.234.113       de           34.85  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 회계관련 데이터 concat하기\n",
    "cca = df[df.Job=='Accountant, chartered certified']\n",
    "cma = df[df.Job=='Accountant, chartered management']\n",
    "ca = df[df.Job=='Accountant, chartered']\n",
    "\n",
    "pd.concat([cca,cma,ca])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Address</th>\n",
       "      <th>Lot</th>\n",
       "      <th>AM or PM</th>\n",
       "      <th>Browser Info</th>\n",
       "      <th>Company</th>\n",
       "      <th>Credit Card</th>\n",
       "      <th>CC Exp Date</th>\n",
       "      <th>CC Security Code</th>\n",
       "      <th>CC Provider</th>\n",
       "      <th>Email</th>\n",
       "      <th>Job</th>\n",
       "      <th>IP Address</th>\n",
       "      <th>Language</th>\n",
       "      <th>Purchase Price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>16629 Pace Camp Apt. 448\\nAlexisborough, NE 77...</td>\n",
       "      <td>46 in</td>\n",
       "      <td>PM</td>\n",
       "      <td>Opera/9.56.(X11; Linux x86_64; sl-SI) Presto/2...</td>\n",
       "      <td>Martinez-Herman</td>\n",
       "      <td>6011929061123406</td>\n",
       "      <td>02/20</td>\n",
       "      <td>900</td>\n",
       "      <td>JCB 16 digit</td>\n",
       "      <td>pdunlap@yahoo.com</td>\n",
       "      <td>Scientist, product/process development</td>\n",
       "      <td>149.146.147.205</td>\n",
       "      <td>el</td>\n",
       "      <td>98.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>9374 Jasmine Spurs Suite 508\\nSouth John, TN 8...</td>\n",
       "      <td>28 rn</td>\n",
       "      <td>PM</td>\n",
       "      <td>Opera/8.93.(Windows 98; Win 9x 4.90; en-US) Pr...</td>\n",
       "      <td>Fletcher, Richards and Whitaker</td>\n",
       "      <td>3337758169645356</td>\n",
       "      <td>11/18</td>\n",
       "      <td>561</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>anthony41@reed.com</td>\n",
       "      <td>Drilling engineer</td>\n",
       "      <td>15.160.41.51</td>\n",
       "      <td>fr</td>\n",
       "      <td>70.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>Unit 0065 Box 5052\\nDPO AP 27450</td>\n",
       "      <td>94 vE</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (compatible; MSIE 9.0; Windows NT ...</td>\n",
       "      <td>Simpson, Williams and Pham</td>\n",
       "      <td>675957666125</td>\n",
       "      <td>08/19</td>\n",
       "      <td>699</td>\n",
       "      <td>JCB 16 digit</td>\n",
       "      <td>amymiller@morales-harrison.com</td>\n",
       "      <td>Customer service manager</td>\n",
       "      <td>132.207.160.22</td>\n",
       "      <td>de</td>\n",
       "      <td>0.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>7780 Julia Fords\\nNew Stacy, WA 45798</td>\n",
       "      <td>36 vm</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_0 ...</td>\n",
       "      <td>Williams, Marshall and Buchanan</td>\n",
       "      <td>6011578504430710</td>\n",
       "      <td>02/24</td>\n",
       "      <td>384</td>\n",
       "      <td>Discover</td>\n",
       "      <td>brent16@olson-robinson.info</td>\n",
       "      <td>Drilling engineer</td>\n",
       "      <td>30.250.74.19</td>\n",
       "      <td>es</td>\n",
       "      <td>78.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>23012 Munoz Drive Suite 337\\nNew Cynthia, TX 5...</td>\n",
       "      <td>20 IE</td>\n",
       "      <td>AM</td>\n",
       "      <td>Opera/9.58.(X11; Linux x86_64; it-IT) Presto/2...</td>\n",
       "      <td>Brown, Watson and Andrews</td>\n",
       "      <td>6011456623207998</td>\n",
       "      <td>10/25</td>\n",
       "      <td>678</td>\n",
       "      <td>Diners Club / Carte Blanche</td>\n",
       "      <td>christopherwright@gmail.com</td>\n",
       "      <td>Fine artist</td>\n",
       "      <td>24.140.33.94</td>\n",
       "      <td>es</td>\n",
       "      <td>77.82</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Address    Lot AM or PM  \\\n",
       "0  16629 Pace Camp Apt. 448\\nAlexisborough, NE 77...  46 in       PM   \n",
       "1  9374 Jasmine Spurs Suite 508\\nSouth John, TN 8...  28 rn       PM   \n",
       "2                   Unit 0065 Box 5052\\nDPO AP 27450  94 vE       PM   \n",
       "3              7780 Julia Fords\\nNew Stacy, WA 45798  36 vm       PM   \n",
       "4  23012 Munoz Drive Suite 337\\nNew Cynthia, TX 5...  20 IE       AM   \n",
       "\n",
       "                                        Browser Info  \\\n",
       "0  Opera/9.56.(X11; Linux x86_64; sl-SI) Presto/2...   \n",
       "1  Opera/8.93.(Windows 98; Win 9x 4.90; en-US) Pr...   \n",
       "2  Mozilla/5.0 (compatible; MSIE 9.0; Windows NT ...   \n",
       "3  Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_0 ...   \n",
       "4  Opera/9.58.(X11; Linux x86_64; it-IT) Presto/2...   \n",
       "\n",
       "                           Company       Credit Card CC Exp Date  \\\n",
       "0                  Martinez-Herman  6011929061123406       02/20   \n",
       "1  Fletcher, Richards and Whitaker  3337758169645356       11/18   \n",
       "2       Simpson, Williams and Pham      675957666125       08/19   \n",
       "3  Williams, Marshall and Buchanan  6011578504430710       02/24   \n",
       "4        Brown, Watson and Andrews  6011456623207998       10/25   \n",
       "\n",
       "   CC Security Code                  CC Provider  \\\n",
       "0               900                 JCB 16 digit   \n",
       "1               561                   Mastercard   \n",
       "2               699                 JCB 16 digit   \n",
       "3               384                     Discover   \n",
       "4               678  Diners Club / Carte Blanche   \n",
       "\n",
       "                            Email                                     Job  \\\n",
       "0               pdunlap@yahoo.com  Scientist, product/process development   \n",
       "1              anthony41@reed.com                       Drilling engineer   \n",
       "2  amymiller@morales-harrison.com                Customer service manager   \n",
       "3     brent16@olson-robinson.info                       Drilling engineer   \n",
       "4     christopherwright@gmail.com                             Fine artist   \n",
       "\n",
       "        IP Address Language  Purchase Price  \n",
       "0  149.146.147.205       el           98.14  \n",
       "1     15.160.41.51       fr           70.73  \n",
       "2   132.207.160.22       de            0.95  \n",
       "3     30.250.74.19       es           78.04  \n",
       "4     24.140.33.94       es           77.82  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "$ 50.34730200000025\n",
      "$ 99.99\n",
      "$ 0.0\n",
      "$ 0.01\n"
     ]
    }
   ],
   "source": [
    "# 평균 구매가격 최고 구매가격 최소 구매가격\n",
    "print('$',df['Purchase Price'].mean()) #평균가\n",
    "print('$',df['Purchase Price'].max()) #최고가\n",
    "print('$',df['Purchase Price'].min()) #최저가\n",
    "print('$',df[df['Purchase Price']!=0]['Purchase Price'].min()) #0이아닌 최저가"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['el' 'fr' 'de' 'es' 'ru' 'pt' 'zh' 'en' 'it']\n",
      "$ 51.103014571949\n"
     ]
    }
   ],
   "source": [
    "# 영어권 사용자의 평균구매금액 \n",
    "print(df.Language.unique()) #언어의 종류\n",
    "print('$',df[df.Language=='en']['Purchase Price'].mean()) #영어(en)의 평균가"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Language\n",
      "de    50.254485\n",
      "el    51.555356\n",
      "en    51.103015\n",
      "es    49.366977\n",
      "fr    49.476718\n",
      "it    50.001004\n",
      "pt    51.215546\n",
      "ru    49.927134\n",
      "zh    50.180198\n",
      "Name: Purchase Price, dtype: float64\n"
     ]
    }
   ],
   "source": [
    "# 언어별 구매금액의 평균\n",
    "print(df.groupby('Language')['Purchase Price'].mean())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "30\n",
      "30\n",
      "30\n",
      "30\n",
      "30\n"
     ]
    }
   ],
   "source": [
    "# Job이 'Lawyer'인 사람의 숫자는\n",
    "#print(df.Job.unique()) #직업 종류추출(너무많음)\n",
    "#1. 'Lawyer'을 찾아서 카운트\n",
    "print(df[df.Job=='Lawyer'].Lot.count())\n",
    "print(sum(df.Job=='Lawyer'))\n",
    "\n",
    "# 대소문자까지 고려한 카운트\n",
    "print(sum(df.Job.apply(lambda x:x.lower()) == 'lawyer'))\n",
    "# Job 문자열에 'Lawyer'포함된 경우까지 카운트(for문, in 키워드)\n",
    "count = 0\n",
    "for j in df.Job:\n",
    "    if 'lawyer' in j.lower():\n",
    "        count += 1\n",
    "print(count)\n",
    "print(len([j for j in df.Job if 'lawyer' in j.lower()]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Job\n",
      "Academic librarian                  11\n",
      "Accommodation manager               17\n",
      "Accountant, chartered               20\n",
      "Accountant, chartered certified     18\n",
      "Accountant, chartered management    15\n",
      "                                    ..\n",
      "Water quality scientist             18\n",
      "Web designer                        20\n",
      "Wellsite geologist                  24\n",
      "Writer                              10\n",
      "Youth worker                        18\n",
      "Name: Lot, Length: 623, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "# Job별로 인원 출력\n",
    "print(df.groupby('Job').Lot.count())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "AM or PM\n",
      "AM    4932\n",
      "PM    5068\n",
      "Name: Lot, dtype: int64\n",
      "4932 5068\n",
      "AM 4932\n",
      "PM 5068\n",
      "PM    5068\n",
      "AM    4932\n",
      "Name: AM or PM, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "# AM과 PM 각각 구매한 건수\n",
    "# 방법1 group by\n",
    "print(df.groupby('AM or PM').Lot.count())\n",
    "\n",
    "#방법2 for문\n",
    "AM = 0\n",
    "PM = 0\n",
    "\n",
    "for t in df['AM or PM']:\n",
    "    if t=='AM':\n",
    "        AM += 1\n",
    "    else:\n",
    "        PM += 1\n",
    "print(AM, PM)\n",
    "# 방법3 Boolean Seriese만들어 sum()적용\n",
    "print('AM',sum(df['AM or PM']=='AM'))\n",
    "print('PM',sum(df['AM or PM']=='PM'))\n",
    "# 방법4 치트키\n",
    "print(df['AM or PM'].value_counts())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "513    75.1\n",
      "Name: Purchase Price, dtype: float64\n",
      "75.1\n"
     ]
    }
   ],
   "source": [
    "# Lot이 '90 WT'인 곳에서 구매한 구매금액\n",
    "print(df[df.Lot=='90 WT']['Purchase Price'])\n",
    "print(df.groupby('Lot')['Purchase Price'].mean()['90 WT'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1234    bondellen@williams-garza.com\n",
      "Name: Email, dtype: object\n"
     ]
    }
   ],
   "source": [
    "# 카드번호가 4926535242672853'인 사람의 이메일 주소\n",
    "print(df[df['Credit Card']==4926535242672853].Email)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "39\n",
      "39\n",
      "39\n"
     ]
    }
   ],
   "source": [
    "# 카드회사가 'American Express'이고 구매금액이 95$ 이상인 고객수\n",
    "print(sum( (df['CC Provider']=='American Express') & (df['Purchase Price']>=95) ))\n",
    "print(df[(df['CC Provider']=='American Express')&(df['Purchase Price']>=95)].count().Lot)\n",
    "print(sum( df[df['CC Provider']=='American Express']['Purchase Price'] >= 95))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Address</th>\n",
       "      <th>Lot</th>\n",
       "      <th>AM or PM</th>\n",
       "      <th>Browser Info</th>\n",
       "      <th>Company</th>\n",
       "      <th>Credit Card</th>\n",
       "      <th>CC Exp Date</th>\n",
       "      <th>CC Security Code</th>\n",
       "      <th>CC Provider</th>\n",
       "      <th>Email</th>\n",
       "      <th>Job</th>\n",
       "      <th>IP Address</th>\n",
       "      <th>Language</th>\n",
       "      <th>Purchase Price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>16629 Pace Camp Apt. 448\\nAlexisborough, NE 77...</td>\n",
       "      <td>46 in</td>\n",
       "      <td>PM</td>\n",
       "      <td>Opera/9.56.(X11; Linux x86_64; sl-SI) Presto/2...</td>\n",
       "      <td>Martinez-Herman</td>\n",
       "      <td>6011929061123406</td>\n",
       "      <td>02/20</td>\n",
       "      <td>900</td>\n",
       "      <td>JCB 16 digit</td>\n",
       "      <td>pdunlap@yahoo.com</td>\n",
       "      <td>Scientist, product/process development</td>\n",
       "      <td>149.146.147.205</td>\n",
       "      <td>el</td>\n",
       "      <td>98.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>9374 Jasmine Spurs Suite 508\\nSouth John, TN 8...</td>\n",
       "      <td>28 rn</td>\n",
       "      <td>PM</td>\n",
       "      <td>Opera/8.93.(Windows 98; Win 9x 4.90; en-US) Pr...</td>\n",
       "      <td>Fletcher, Richards and Whitaker</td>\n",
       "      <td>3337758169645356</td>\n",
       "      <td>11/18</td>\n",
       "      <td>561</td>\n",
       "      <td>Mastercard</td>\n",
       "      <td>anthony41@reed.com</td>\n",
       "      <td>Drilling engineer</td>\n",
       "      <td>15.160.41.51</td>\n",
       "      <td>fr</td>\n",
       "      <td>70.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>Unit 0065 Box 5052\\nDPO AP 27450</td>\n",
       "      <td>94 vE</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (compatible; MSIE 9.0; Windows NT ...</td>\n",
       "      <td>Simpson, Williams and Pham</td>\n",
       "      <td>675957666125</td>\n",
       "      <td>08/19</td>\n",
       "      <td>699</td>\n",
       "      <td>JCB 16 digit</td>\n",
       "      <td>amymiller@morales-harrison.com</td>\n",
       "      <td>Customer service manager</td>\n",
       "      <td>132.207.160.22</td>\n",
       "      <td>de</td>\n",
       "      <td>0.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>7780 Julia Fords\\nNew Stacy, WA 45798</td>\n",
       "      <td>36 vm</td>\n",
       "      <td>PM</td>\n",
       "      <td>Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_0 ...</td>\n",
       "      <td>Williams, Marshall and Buchanan</td>\n",
       "      <td>6011578504430710</td>\n",
       "      <td>02/24</td>\n",
       "      <td>384</td>\n",
       "      <td>Discover</td>\n",
       "      <td>brent16@olson-robinson.info</td>\n",
       "      <td>Drilling engineer</td>\n",
       "      <td>30.250.74.19</td>\n",
       "      <td>es</td>\n",
       "      <td>78.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>23012 Munoz Drive Suite 337\\nNew Cynthia, TX 5...</td>\n",
       "      <td>20 IE</td>\n",
       "      <td>AM</td>\n",
       "      <td>Opera/9.58.(X11; Linux x86_64; it-IT) Presto/2...</td>\n",
       "      <td>Brown, Watson and Andrews</td>\n",
       "      <td>6011456623207998</td>\n",
       "      <td>10/25</td>\n",
       "      <td>678</td>\n",
       "      <td>Diners Club / Carte Blanche</td>\n",
       "      <td>christopherwright@gmail.com</td>\n",
       "      <td>Fine artist</td>\n",
       "      <td>24.140.33.94</td>\n",
       "      <td>es</td>\n",
       "      <td>77.82</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Address    Lot AM or PM  \\\n",
       "0  16629 Pace Camp Apt. 448\\nAlexisborough, NE 77...  46 in       PM   \n",
       "1  9374 Jasmine Spurs Suite 508\\nSouth John, TN 8...  28 rn       PM   \n",
       "2                   Unit 0065 Box 5052\\nDPO AP 27450  94 vE       PM   \n",
       "3              7780 Julia Fords\\nNew Stacy, WA 45798  36 vm       PM   \n",
       "4  23012 Munoz Drive Suite 337\\nNew Cynthia, TX 5...  20 IE       AM   \n",
       "\n",
       "                                        Browser Info  \\\n",
       "0  Opera/9.56.(X11; Linux x86_64; sl-SI) Presto/2...   \n",
       "1  Opera/8.93.(Windows 98; Win 9x 4.90; en-US) Pr...   \n",
       "2  Mozilla/5.0 (compatible; MSIE 9.0; Windows NT ...   \n",
       "3  Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_0 ...   \n",
       "4  Opera/9.58.(X11; Linux x86_64; it-IT) Presto/2...   \n",
       "\n",
       "                           Company       Credit Card CC Exp Date  \\\n",
       "0                  Martinez-Herman  6011929061123406       02/20   \n",
       "1  Fletcher, Richards and Whitaker  3337758169645356       11/18   \n",
       "2       Simpson, Williams and Pham      675957666125       08/19   \n",
       "3  Williams, Marshall and Buchanan  6011578504430710       02/24   \n",
       "4        Brown, Watson and Andrews  6011456623207998       10/25   \n",
       "\n",
       "   CC Security Code                  CC Provider  \\\n",
       "0               900                 JCB 16 digit   \n",
       "1               561                   Mastercard   \n",
       "2               699                 JCB 16 digit   \n",
       "3               384                     Discover   \n",
       "4               678  Diners Club / Carte Blanche   \n",
       "\n",
       "                            Email                                     Job  \\\n",
       "0               pdunlap@yahoo.com  Scientist, product/process development   \n",
       "1              anthony41@reed.com                       Drilling engineer   \n",
       "2  amymiller@morales-harrison.com                Customer service manager   \n",
       "3     brent16@olson-robinson.info                       Drilling engineer   \n",
       "4     christopherwright@gmail.com                             Fine artist   \n",
       "\n",
       "        IP Address Language  Purchase Price  \n",
       "0  149.146.147.205       el           98.14  \n",
       "1     15.160.41.51       fr           70.73  \n",
       "2   132.207.160.22       de            0.95  \n",
       "3     30.250.74.19       es           78.04  \n",
       "4     24.140.33.94       es           77.82  "
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1033\n",
      "1033\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "0       False\n",
       "1       False\n",
       "2       False\n",
       "3       False\n",
       "4        True\n",
       "        ...  \n",
       "9995    False\n",
       "9996     True\n",
       "9997    False\n",
       "9998    False\n",
       "9999    False\n",
       "Name: CC Exp Date, Length: 10000, dtype: bool"
      ]
     },
     "execution_count": 104,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# credit card의 완료일이 2025년도인 카드를 소지한 고객은?\n",
    "df['cardyear'] = df['CC Exp Date'].apply(lambda z: '20'+z.split('/')[1])\n",
    "print(df[df.cardyear=='2025'].count().Lot)\n",
    "print(sum(df['CC Exp Date'].apply(lambda z: z.split('/')[1]=='25')))\n",
    "\n",
    "df['CC Exp Date'].apply(lambda z: z.split('/')[1]=='25')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3416\n"
     ]
    },
    {
     "ename": "AttributeError",
     "evalue": "'numpy.ndarray' object has no attribute 'count'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-102-8330c8113ed1>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m      3\u001b[0m \u001b[0mdomain\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mdf\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mdomain\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0munique\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      4\u001b[0m \u001b[0mprint\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mlen\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mdomain\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 5\u001b[1;33m \u001b[0mprint\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mdomain\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcount\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'gmail.com'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m: 'numpy.ndarray' object has no attribute 'count'"
     ]
    }
   ],
   "source": [
    "# 이메일에서 도메인뽑기\n",
    "df['domain']=df.Email.apply(lambda x: x.split('@')[1])\n",
    "domain = df.domain.unique()\n",
    "print(len(domain))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "python하는 것보다 낯서라"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}