Amazon Reviews Constructor.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Read in the json file\n",
    "reviews = pd.read_json('data/reviews_Electronics_5.json', lines=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>asin</th>\n",
       "      <th>helpful</th>\n",
       "      <th>overall</th>\n",
       "      <th>reviewText</th>\n",
       "      <th>reviewTime</th>\n",
       "      <th>reviewerID</th>\n",
       "      <th>reviewerName</th>\n",
       "      <th>summary</th>\n",
       "      <th>unixReviewTime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0528881469</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>We got this GPS for my husband who is an (OTR)...</td>\n",
       "      <td>06 2, 2013</td>\n",
       "      <td>AO94DHGC771SJ</td>\n",
       "      <td>amazdnu</td>\n",
       "      <td>Gotta have GPS!</td>\n",
       "      <td>1370131200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0528881469</td>\n",
       "      <td>[12, 15]</td>\n",
       "      <td>1</td>\n",
       "      <td>I'm a professional OTR truck driver, and I bou...</td>\n",
       "      <td>11 25, 2010</td>\n",
       "      <td>AMO214LNFCEI4</td>\n",
       "      <td>Amazon Customer</td>\n",
       "      <td>Very Disappointed</td>\n",
       "      <td>1290643200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0528881469</td>\n",
       "      <td>[43, 45]</td>\n",
       "      <td>3</td>\n",
       "      <td>Well, what can I say.  I've had this unit in m...</td>\n",
       "      <td>09 9, 2010</td>\n",
       "      <td>A3N7T0DY83Y4IG</td>\n",
       "      <td>C. A. Freeman</td>\n",
       "      <td>1st impression</td>\n",
       "      <td>1283990400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0528881469</td>\n",
       "      <td>[9, 10]</td>\n",
       "      <td>2</td>\n",
       "      <td>Not going to write a long review, even thought...</td>\n",
       "      <td>11 24, 2010</td>\n",
       "      <td>A1H8PY3QHMQQA0</td>\n",
       "      <td>Dave M. Shaw \"mack dave\"</td>\n",
       "      <td>Great grafics, POOR GPS</td>\n",
       "      <td>1290556800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0528881469</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>1</td>\n",
       "      <td>I've had mine for a year and here's what we go...</td>\n",
       "      <td>09 29, 2011</td>\n",
       "      <td>A24EV6RXELQZ63</td>\n",
       "      <td>Wayne Smith</td>\n",
       "      <td>Major issues, only excuses for support</td>\n",
       "      <td>1317254400</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         asin   helpful  overall  \\\n",
       "0  0528881469    [0, 0]        5   \n",
       "1  0528881469  [12, 15]        1   \n",
       "2  0528881469  [43, 45]        3   \n",
       "3  0528881469   [9, 10]        2   \n",
       "4  0528881469    [0, 0]        1   \n",
       "\n",
       "                                          reviewText   reviewTime  \\\n",
       "0  We got this GPS for my husband who is an (OTR)...   06 2, 2013   \n",
       "1  I'm a professional OTR truck driver, and I bou...  11 25, 2010   \n",
       "2  Well, what can I say.  I've had this unit in m...   09 9, 2010   \n",
       "3  Not going to write a long review, even thought...  11 24, 2010   \n",
       "4  I've had mine for a year and here's what we go...  09 29, 2011   \n",
       "\n",
       "       reviewerID              reviewerName  \\\n",
       "0   AO94DHGC771SJ                   amazdnu   \n",
       "1   AMO214LNFCEI4           Amazon Customer   \n",
       "2  A3N7T0DY83Y4IG             C. A. Freeman   \n",
       "3  A1H8PY3QHMQQA0  Dave M. Shaw \"mack dave\"   \n",
       "4  A24EV6RXELQZ63               Wayne Smith   \n",
       "\n",
       "                                  summary  unixReviewTime  \n",
       "0                         Gotta have GPS!      1370131200  \n",
       "1                       Very Disappointed      1290643200  \n",
       "2                          1st impression      1283990400  \n",
       "3                 Great grafics, POOR GPS      1290556800  \n",
       "4  Major issues, only excuses for support      1317254400  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Preview the file\n",
    "reviews.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1689188, 9)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# What size of file are we looking at?\n",
    "reviews.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Through exploring the data I found that there are some empty strings in the review column.\n",
    "# It will work out better if convert these empty string values to np.NAN values\n",
    "reviews.replace('', np.NaN, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "I strongly recommend this product I use it on all of my devices, laptop and glasses. It is very helpful and requires no liquid\n",
      "- - - - - -\n",
      "I was looking for a way to stream Rhapsody into my A/V Receiver, and maybe have some other music options too. The Squeezebox Touch is just what I needed. I hard wired it into my home network and used a digital cable to go into my A/V Receiver. I now have a massive collection of digital audio from Rhapsody to choose from. I'm in heaven. The unit was as easy as pie to hook up. The touch screen is reactive, and the remote control is very nice too. What a fabulous product. It does everything I was looking for and more. The fact that Amazon got it here fast and at a reasonable price just makes my enjoyment of it that much more. I love my Squeezebox Touch and I love Amazon. Thanks\n",
      "- - - - - -\n",
      "Well made and sized right for the Macbook Air.  Only minor observation is that it would be nice it had a handle.\n",
      "- - - - - -\n",
      "Not all GPS devices are made equal.  The Magellan RoadMate 1220 packs a decent punch for the price.  It doesn't have all the bells and whistles, but it does the basic job of getting you from point A to point B with minimal difficulties.This is our second GPS unit.  My husband received a GPS unit made by another manufacturor for his birthday and it was more expensive with some special features.  It has had a few hiccups nevertheless.  I wanted a GPS for my vehicle and decided to give this one a try.It is very easy to use.  The brightness level doesn't always seem to go quite bright enough in the bright sunshine on my dash.  The display while driving sometimes appears jumpy and bumpy.  But this unit's speaker is louder than my husbands and hasn't frozen up like his either.  The pros outweigh the cons without a doubt.If you are looking for a basic GPS unit and do not want to pay for all the bells and whistles, I would highly recommend giving this one a try.\n",
      "- - - - - -\n",
      "Very fast USB drive.  Worked right out of the box.  Great size and solid feel.  My computer has both USB 2.0 and USB 3.0, so I tested out this drive against a USB2.0 8GB memory stick.I copied a 1.5GB movie to both drives.  The 2.0 drive took 2'35&#34; while this drive in a USB3.0 slot took 1'02&#34;.  Quite impressive.  I also copied a folder of MP3 files which was 95MB in size (8 total files).  The 2.0 drive took 18 seconds while this drive took 8 seconds.  Not bad at all.\n",
      "- - - - - -\n",
      "Belkin makes great products and I decided to get this unit as it is much cheaper than other line conditioners.  However, the picture on Amazon, and on the cover of the box it ships in is wrong because this unit is available in BLACK only.  With this caveat in mind, sho away!\n",
      "- - - - - -\n",
      "love it.. It sounds great and was exactly what i was looking for . It works nicely with my home theater system\n",
      "- - - - - -\n",
      "What more can be said other than it provides the high charging speed of 2.1 amps and the quality is quite good for the price - expected from Belkin.  Recommended.\n",
      "- - - - - -\n",
      "I really wanted to like these.  Really.  They have awesome sound for the size and pair with no problem.  The issue is the earpiece.  It simply will not fit.  Unlike other headsets, these do not have any way to change out the ear pieces.  So, if you have small or even average ear canals, these are NOT going to work for you.What is even more amazing is that the company refuses to do anything about it.  There are hundreds of complaints about the earpieces falling out, not fitting, uncomfortable... etc.  The response from Plantronics is just \"IGNORE\".  Too bad.  They used to be a good company but the dollar has taken over their office, I guess.So, caveat emptor. These will probably NOT fit you!!\n",
      "- - - - - -\n",
      "I love this mouse. I have bought several of these for my company and they all work great. I love the Logitech unifying receiver. It works natively on our Wyse Thin clients.\n",
      "- - - - - -\n"
     ]
    }
   ],
   "source": [
    "# Let's see a sample of what some of our review text looks like\n",
    "sample_reviews = reviews['reviewText'].sample(n=10)\n",
    "\n",
    "for review in sample_reviews:\n",
    "    print(review)     \n",
    "    print('- - - - - -')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(1689188, 9)\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "(1688117, 9)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# We're interested in working with the text and the review score so let's drop any rows that don't have these values\n",
    "\n",
    "# See the shape before the drop \n",
    "print(reviews.shape)\n",
    "reviews.dropna(axis=0, how='any', subset=['overall', 'reviewText'], inplace=True)\n",
    "\n",
    "# See the shape after the drop\n",
    "reviews.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(200000, 9)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Let's bring the sample down to 200,000 to make it more managable\n",
    "reviews_subset = reviews.sample(n=200000, random_state=17).copy()\n",
    "reviews_subset.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>asin</th>\n",
       "      <th>helpful</th>\n",
       "      <th>overall</th>\n",
       "      <th>reviewText</th>\n",
       "      <th>reviewTime</th>\n",
       "      <th>reviewerID</th>\n",
       "      <th>reviewerName</th>\n",
       "      <th>summary</th>\n",
       "      <th>unixReviewTime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>674608</th>\n",
       "      <td>B002W7CW32</td>\n",
       "      <td>[1, 3]</td>\n",
       "      <td>5</td>\n",
       "      <td>got  my first projector yesterday from visuala...</td>\n",
       "      <td>04 7, 2010</td>\n",
       "      <td>A33XWDU85V5ZGM</td>\n",
       "      <td>Prasad N. Badal \"PB\"</td>\n",
       "      <td>updated review- still loving it</td>\n",
       "      <td>1270598400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>572683</th>\n",
       "      <td>B0028PJ6OQ</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>4</td>\n",
       "      <td>It is a decently made keyboard with a very bri...</td>\n",
       "      <td>08 16, 2013</td>\n",
       "      <td>AG2CSACQ7SXRK</td>\n",
       "      <td>Ginny's Store \"Ginny\"</td>\n",
       "      <td>Very brite</td>\n",
       "      <td>1376611200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1142343</th>\n",
       "      <td>B005HMO6A6</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>This keyboard is spot on. The first thing that...</td>\n",
       "      <td>08 14, 2013</td>\n",
       "      <td>A3REQ9RHP8LLWZ</td>\n",
       "      <td>theonerandom</td>\n",
       "      <td>Quality Keyboard A+</td>\n",
       "      <td>1376438400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1101357</th>\n",
       "      <td>B005BHX0A4</td>\n",
       "      <td>[1, 1]</td>\n",
       "      <td>4</td>\n",
       "      <td>This fits nicely on the Canon HF G10 and gives...</td>\n",
       "      <td>12 31, 2012</td>\n",
       "      <td>A1HHOD2XB7R64C</td>\n",
       "      <td>Michael Griffith</td>\n",
       "      <td>Good way to convert</td>\n",
       "      <td>1356912000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>667661</th>\n",
       "      <td>B002V88HFE</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I've ordered these in the past and they outlas...</td>\n",
       "      <td>01 21, 2013</td>\n",
       "      <td>A1YQDDM0ACMR97</td>\n",
       "      <td>L. Capps</td>\n",
       "      <td>Great Batteries</td>\n",
       "      <td>1358726400</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               asin helpful  overall  \\\n",
       "674608   B002W7CW32  [1, 3]        5   \n",
       "572683   B0028PJ6OQ  [0, 0]        4   \n",
       "1142343  B005HMO6A6  [0, 0]        5   \n",
       "1101357  B005BHX0A4  [1, 1]        4   \n",
       "667661   B002V88HFE  [0, 0]        5   \n",
       "\n",
       "                                                reviewText   reviewTime  \\\n",
       "674608   got  my first projector yesterday from visuala...   04 7, 2010   \n",
       "572683   It is a decently made keyboard with a very bri...  08 16, 2013   \n",
       "1142343  This keyboard is spot on. The first thing that...  08 14, 2013   \n",
       "1101357  This fits nicely on the Canon HF G10 and gives...  12 31, 2012   \n",
       "667661   I've ordered these in the past and they outlas...  01 21, 2013   \n",
       "\n",
       "             reviewerID           reviewerName  \\\n",
       "674608   A33XWDU85V5ZGM   Prasad N. Badal \"PB\"   \n",
       "572683    AG2CSACQ7SXRK  Ginny's Store \"Ginny\"   \n",
       "1142343  A3REQ9RHP8LLWZ           theonerandom   \n",
       "1101357  A1HHOD2XB7R64C       Michael Griffith   \n",
       "667661   A1YQDDM0ACMR97               L. Capps   \n",
       "\n",
       "                                 summary  unixReviewTime  \n",
       "674608   updated review- still loving it      1270598400  \n",
       "572683                        Very brite      1376611200  \n",
       "1142343              Quality Keyboard A+      1376438400  \n",
       "1101357              Good way to convert      1356912000  \n",
       "667661                   Great Batteries      1358726400  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Let's see the results:\n",
    "reviews_subset.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>asin</th>\n",
       "      <th>helpful</th>\n",
       "      <th>overall</th>\n",
       "      <th>reviewText</th>\n",
       "      <th>reviewTime</th>\n",
       "      <th>reviewerID</th>\n",
       "      <th>reviewerName</th>\n",
       "      <th>summary</th>\n",
       "      <th>unixReviewTime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1232663</th>\n",
       "      <td>B006K553LU</td>\n",
       "      <td>[1, 1]</td>\n",
       "      <td>5</td>\n",
       "      <td>I chose this product because it seemed to be t...</td>\n",
       "      <td>07 14, 2013</td>\n",
       "      <td>A1QDWPIXFKS0CU</td>\n",
       "      <td>Lexi</td>\n",
       "      <td>Great value and awesome product</td>\n",
       "      <td>1373760000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>369887</th>\n",
       "      <td>B0012S4APK</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I mounted my LG 42&amp;#34; tv. Easy and did the j...</td>\n",
       "      <td>01 6, 2014</td>\n",
       "      <td>A1428302YLXZXD</td>\n",
       "      <td>Jerry Choate</td>\n",
       "      <td>Good, Solid Mount!</td>\n",
       "      <td>1388966400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393272</th>\n",
       "      <td>B0015EDVVU</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>This is my second set of Wiremold kits.  I had...</td>\n",
       "      <td>10 27, 2013</td>\n",
       "      <td>A38LVONPQQT3GW</td>\n",
       "      <td>A. Mcintyre \"Frugal Shopper\"</td>\n",
       "      <td>Great addition to any home entertainment system</td>\n",
       "      <td>1382832000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1072538</th>\n",
       "      <td>B0053O9ZNQ</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>4</td>\n",
       "      <td>I chose it because it had almost the same key ...</td>\n",
       "      <td>01 24, 2014</td>\n",
       "      <td>A3AVSGDYKZMCOX</td>\n",
       "      <td>chriek</td>\n",
       "      <td>Good compact keyboard</td>\n",
       "      <td>1390521600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1659055</th>\n",
       "      <td>B00FF6J532</td>\n",
       "      <td>[6, 6]</td>\n",
       "      <td>5</td>\n",
       "      <td>Memo from a hard core iPad user: Lets face it....</td>\n",
       "      <td>03 11, 2014</td>\n",
       "      <td>ATGLHCY1BZ0TO</td>\n",
       "      <td>conis</td>\n",
       "      <td>Totally SLICK!</td>\n",
       "      <td>1394496000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1311812</th>\n",
       "      <td>B007MW73C2</td>\n",
       "      <td>[2, 2]</td>\n",
       "      <td>5</td>\n",
       "      <td>I am an OLD IT person....I started programming...</td>\n",
       "      <td>05 31, 2013</td>\n",
       "      <td>AQXB4AR9HCZTE</td>\n",
       "      <td>1912 House</td>\n",
       "      <td>Leap of Faith - gaming, school and work</td>\n",
       "      <td>1369958400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997812</th>\n",
       "      <td>B004OVECUA</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>Works great.  If you have ever used a Harmony ...</td>\n",
       "      <td>09 17, 2013</td>\n",
       "      <td>A3RACIXI8CK305</td>\n",
       "      <td>Ken</td>\n",
       "      <td>This is my favorite remote. Period</td>\n",
       "      <td>1379376000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48490</th>\n",
       "      <td>B00007E7C8</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>3</td>\n",
       "      <td>I only had them on 15 minutes before my right ...</td>\n",
       "      <td>01 11, 2014</td>\n",
       "      <td>ALIYGP2HGXOZT</td>\n",
       "      <td>Spots \"shialavati\"</td>\n",
       "      <td>Ear cups too shallow</td>\n",
       "      <td>1389398400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>553053</th>\n",
       "      <td>B001XURP7W</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>Great Deal......yes they are a &amp;#34;Bulk-Pack&amp;...</td>\n",
       "      <td>11 30, 2013</td>\n",
       "      <td>A3MJR0F0NUWJL7</td>\n",
       "      <td>Steven</td>\n",
       "      <td>Great Deal: Two for the price of One!</td>\n",
       "      <td>1385769600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1614296</th>\n",
       "      <td>B00DGNZ9G8</td>\n",
       "      <td>[9, 10]</td>\n",
       "      <td>4</td>\n",
       "      <td>The first thing I want to put out first is tha...</td>\n",
       "      <td>11 16, 2013</td>\n",
       "      <td>AYANKSMR7OVJX</td>\n",
       "      <td>YourName</td>\n",
       "      <td>Missing parts, but never the less a good value.</td>\n",
       "      <td>1384560000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1653771</th>\n",
       "      <td>B00F3SOHNU</td>\n",
       "      <td>[13, 13]</td>\n",
       "      <td>5</td>\n",
       "      <td>As a self-proclaimed &amp;#34;Apple&amp;#34; guy, I wa...</td>\n",
       "      <td>12 28, 2013</td>\n",
       "      <td>AX479H8UX80N4</td>\n",
       "      <td>Blake</td>\n",
       "      <td>An Interesting Twist of Events</td>\n",
       "      <td>1388188800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>375713</th>\n",
       "      <td>B0013CXZZ6</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>When I ordered this unit, I did not realize th...</td>\n",
       "      <td>05 24, 2013</td>\n",
       "      <td>A3H09VQI43K2PJ</td>\n",
       "      <td>D. G. Orr</td>\n",
       "      <td>Good surprise.</td>\n",
       "      <td>1369353600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993754</th>\n",
       "      <td>B004O0TRD8</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>3</td>\n",
       "      <td>this has turned out to work reasonably well. t...</td>\n",
       "      <td>03 24, 2013</td>\n",
       "      <td>A3SMPQ72XQ75W3</td>\n",
       "      <td>bluecitabria \"bluecitabria\"</td>\n",
       "      <td>good value. good performance</td>\n",
       "      <td>1364083200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1438525</th>\n",
       "      <td>B0091JMYWI</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>Gave this as a gift and she really loves it. I...</td>\n",
       "      <td>01 9, 2013</td>\n",
       "      <td>AS6YV5VLYZVAA</td>\n",
       "      <td>Carla</td>\n",
       "      <td>gift</td>\n",
       "      <td>1357689600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>849128</th>\n",
       "      <td>B003XZSZWO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>4</td>\n",
       "      <td>This was what I ordered, but I wasn't careful ...</td>\n",
       "      <td>10 9, 2013</td>\n",
       "      <td>A3C67YYQ9S1BEE</td>\n",
       "      <td>D. Johnson \"DJ\"</td>\n",
       "      <td>Seems to be good product; but different polari...</td>\n",
       "      <td>1381276800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1674888</th>\n",
       "      <td>B00H09BOXQ</td>\n",
       "      <td>[4, 4]</td>\n",
       "      <td>5</td>\n",
       "      <td>If you are a lifetime XP like myself and are f...</td>\n",
       "      <td>04 1, 2014</td>\n",
       "      <td>A24JWLYUXFS7I3</td>\n",
       "      <td>Jonathan Stoops</td>\n",
       "      <td>Doesn't suck!</td>\n",
       "      <td>1396310400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1212634</th>\n",
       "      <td>B00679A3W8</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>You could not ask for a better quality item fo...</td>\n",
       "      <td>02 8, 2013</td>\n",
       "      <td>A3E0OTIDJR95E5</td>\n",
       "      <td>Diane Jenkins</td>\n",
       "      <td>Great Price!</td>\n",
       "      <td>1360281600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>292037</th>\n",
       "      <td>B000PKX2KA</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I bought this for use with Microsoft Streets a...</td>\n",
       "      <td>12 31, 2012</td>\n",
       "      <td>A13B7T48AHY6AV</td>\n",
       "      <td>Daddicus Rex</td>\n",
       "      <td>Nice product</td>\n",
       "      <td>1356912000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>407331</th>\n",
       "      <td>B0017ZG538</td>\n",
       "      <td>[0, 1]</td>\n",
       "      <td>5</td>\n",
       "      <td>Works Perfect with my new Garmin 2797 7&amp;#34; s...</td>\n",
       "      <td>11 19, 2013</td>\n",
       "      <td>A3JBUZBUCRLQ4Z</td>\n",
       "      <td>Mike \"mk3509\"</td>\n",
       "      <td>The best mount I have ever bought!</td>\n",
       "      <td>1384819200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1259005</th>\n",
       "      <td>B0070Z87YO</td>\n",
       "      <td>[0, 1]</td>\n",
       "      <td>5</td>\n",
       "      <td>Got this amp to replace my computer 5.1 setup ...</td>\n",
       "      <td>03 31, 2014</td>\n",
       "      <td>A1HJ9UMIAYY6C4</td>\n",
       "      <td>Leo</td>\n",
       "      <td>Great sound! Even better value!</td>\n",
       "      <td>1396224000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1259115</th>\n",
       "      <td>B00711ST5O</td>\n",
       "      <td>[11, 11]</td>\n",
       "      <td>4</td>\n",
       "      <td>Purchased these because they were inexpensive....</td>\n",
       "      <td>11 27, 2013</td>\n",
       "      <td>A2NG1RE7UX6ST0</td>\n",
       "      <td>Son of Barra</td>\n",
       "      <td>Brings home the boom</td>\n",
       "      <td>1385510400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1533292</th>\n",
       "      <td>B00ATQF0DC</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>The feel of the case is nice and rich .... fir...</td>\n",
       "      <td>03 14, 2014</td>\n",
       "      <td>A2F3CXXSQ1UZHM</td>\n",
       "      <td>real gypsy girl</td>\n",
       "      <td>Love this case!</td>\n",
       "      <td>1394755200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1680618</th>\n",
       "      <td>B00HWMPRKC</td>\n",
       "      <td>[2, 2]</td>\n",
       "      <td>5</td>\n",
       "      <td>I've probably had 6 Android tablets so far, an...</td>\n",
       "      <td>06 17, 2014</td>\n",
       "      <td>AVJ6URCLNJQD2</td>\n",
       "      <td>Marc Strand</td>\n",
       "      <td>A high-end tablet at a high-end price -- you g...</td>\n",
       "      <td>1402963200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1169162</th>\n",
       "      <td>B005NCLDEC</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I put screen protectors and cases on everythin...</td>\n",
       "      <td>11 25, 2012</td>\n",
       "      <td>A1XMJXT4ZXPXOV</td>\n",
       "      <td>Sambardo</td>\n",
       "      <td>No bubbles, no problem</td>\n",
       "      <td>1353801600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1656781</th>\n",
       "      <td>B00FA4Y7N2</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>Not cheaply made - this one will not &amp;#34;not ...</td>\n",
       "      <td>02 10, 2014</td>\n",
       "      <td>A2O5QPR9OHW8I2</td>\n",
       "      <td>ChrisinWV</td>\n",
       "      <td>Compatible and solid</td>\n",
       "      <td>1391990400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1163710</th>\n",
       "      <td>B005LMWP78</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>It has a lot of pockets and storage areas for ...</td>\n",
       "      <td>06 16, 2014</td>\n",
       "      <td>A1025YTKW6RZ2L</td>\n",
       "      <td>Mark Muranaka</td>\n",
       "      <td>Nice</td>\n",
       "      <td>1402876800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>932524</th>\n",
       "      <td>B004CVBWSC</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>It's a cable it sits behind the rest of my wir...</td>\n",
       "      <td>07 4, 2013</td>\n",
       "      <td>A3MA21HKGWAIJ0</td>\n",
       "      <td>Chris S.</td>\n",
       "      <td>It works just like it was advertise!</td>\n",
       "      <td>1372896000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185417</th>\n",
       "      <td>B000CRFOMK</td>\n",
       "      <td>[1, 1]</td>\n",
       "      <td>5</td>\n",
       "      <td>My items arrived yesterday, so I cannot speak ...</td>\n",
       "      <td>07 12, 2013</td>\n",
       "      <td>A23D13HKTA95WX</td>\n",
       "      <td>David Hostetler \"SuperDave3006\"</td>\n",
       "      <td>Correct item showed up. Pretty basic, but it's...</td>\n",
       "      <td>1373587200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105191</th>\n",
       "      <td>B0002CPBWI</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>3</td>\n",
       "      <td>Seller offers this as a &amp;#34;new&amp;#34; and a &amp;#...</td>\n",
       "      <td>06 2, 2014</td>\n",
       "      <td>AOLK0TVACBKE8</td>\n",
       "      <td>David Felder</td>\n",
       "      <td>Seller problem...</td>\n",
       "      <td>1401667200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>894404</th>\n",
       "      <td>B0044DEDC0</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I use my laptop in a port replicator and there...</td>\n",
       "      <td>02 20, 2014</td>\n",
       "      <td>A3RWN5RBIOE1JT</td>\n",
       "      <td>Admin_Dude42</td>\n",
       "      <td>Easy to install and sounds decent</td>\n",
       "      <td>1392854400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1657926</th>\n",
       "      <td>B00FCU6NWM</td>\n",
       "      <td>[1, 2]</td>\n",
       "      <td>2</td>\n",
       "      <td>&amp;#34;You get what you pay for&amp;#34;It's depress...</td>\n",
       "      <td>12 19, 2013</td>\n",
       "      <td>A2171RS26KJQUX</td>\n",
       "      <td>Phillip A. Oliveto \"Don't knock it until you'...</td>\n",
       "      <td>Looks and feels cheap...</td>\n",
       "      <td>1387411200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1683271</th>\n",
       "      <td>B00IEZGWI2</td>\n",
       "      <td>[18, 20]</td>\n",
       "      <td>5</td>\n",
       "      <td>I literally crapped my pants when I plugged th...</td>\n",
       "      <td>05 5, 2014</td>\n",
       "      <td>A2M7GEJQPA0TUV</td>\n",
       "      <td>DGK</td>\n",
       "      <td>Crap!</td>\n",
       "      <td>1399248000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1282914</th>\n",
       "      <td>B00797A5GQ</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>4</td>\n",
       "      <td>I originally bought this for my desk at work b...</td>\n",
       "      <td>10 22, 2013</td>\n",
       "      <td>AXETJKRX8OH24</td>\n",
       "      <td>GeekDad</td>\n",
       "      <td>Great for traveling</td>\n",
       "      <td>1382400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1213694</th>\n",
       "      <td>B00683X4PQ</td>\n",
       "      <td>[1, 1]</td>\n",
       "      <td>5</td>\n",
       "      <td>CPU-Z identifies it as &amp;#34;Crucial PC3-12800&amp;...</td>\n",
       "      <td>03 23, 2014</td>\n",
       "      <td>A1ZX9OE1TCFIKL</td>\n",
       "      <td>D Bruton \"dabruton2\"</td>\n",
       "      <td>Works well</td>\n",
       "      <td>1395532800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1622178</th>\n",
       "      <td>B00DR0PDNE</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>4</td>\n",
       "      <td>Love it. So easy to use and one can be watchin...</td>\n",
       "      <td>12 14, 2013</td>\n",
       "      <td>A3HOC1P7HS7KFC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Great, but can get better</td>\n",
       "      <td>1386979200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1374280</th>\n",
       "      <td>B0088RIV1W</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>4</td>\n",
       "      <td>This mounting was priced fairly, is well made ...</td>\n",
       "      <td>10 2, 2013</td>\n",
       "      <td>A3P2OS8DYFVZWS</td>\n",
       "      <td>Deal Pilgrim</td>\n",
       "      <td>Infinite swivel flexibility - perfect for kitc...</td>\n",
       "      <td>1380672000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>342445</th>\n",
       "      <td>B000WS5I7U</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>First of all, I have two of these for two diff...</td>\n",
       "      <td>02 4, 2013</td>\n",
       "      <td>A2N4P35FVAGYAL</td>\n",
       "      <td>desorbod</td>\n",
       "      <td>One of the best items every created!</td>\n",
       "      <td>1359936000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1222269</th>\n",
       "      <td>B006EWUO22</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I bought 16gb mainly for large photoshop docum...</td>\n",
       "      <td>06 15, 2013</td>\n",
       "      <td>A1K0JKU03DVRI6</td>\n",
       "      <td>Monda</td>\n",
       "      <td>Fast and more than you could ever need.</td>\n",
       "      <td>1371254400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1678924</th>\n",
       "      <td>B00HPM1G8Q</td>\n",
       "      <td>[12, 13]</td>\n",
       "      <td>5</td>\n",
       "      <td>This case provides a good amount of protection...</td>\n",
       "      <td>04 17, 2014</td>\n",
       "      <td>A1P0JSFW184ZXJ</td>\n",
       "      <td>Jen \"Geek Girl\"</td>\n",
       "      <td>Turn your Kindle Fire HDX into a mini laptop!</td>\n",
       "      <td>1397692800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1515202</th>\n",
       "      <td>B00A9LHLQ6</td>\n",
       "      <td>[4, 5]</td>\n",
       "      <td>4</td>\n",
       "      <td>I had gotten this to improve the performance o...</td>\n",
       "      <td>03 15, 2013</td>\n",
       "      <td>A2AC7YG25V0ABD</td>\n",
       "      <td>Tech</td>\n",
       "      <td>Good beginner DAC/Amp</td>\n",
       "      <td>1363305600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1229020</th>\n",
       "      <td>B006J4G49C</td>\n",
       "      <td>[2, 3]</td>\n",
       "      <td>3</td>\n",
       "      <td>There has been a lot of talk about the Baofeng...</td>\n",
       "      <td>04 2, 2014</td>\n",
       "      <td>A2L36AGL8CKY3D</td>\n",
       "      <td>Tex \"Tex\"</td>\n",
       "      <td>Read before purchasing this radio</td>\n",
       "      <td>1396396800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1542911</th>\n",
       "      <td>B00B2VMJ00</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>Fits my 7&amp;#34; Google android Tablet 4.2 Jelly...</td>\n",
       "      <td>12 6, 2013</td>\n",
       "      <td>A35SYWA7A3XOXM</td>\n",
       "      <td>Does Amazon pay for clicks?</td>\n",
       "      <td>I love it</td>\n",
       "      <td>1386288000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>369983</th>\n",
       "      <td>B0012S4APK</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>4</td>\n",
       "      <td>Wouldn't rely on the level that comes with it,...</td>\n",
       "      <td>12 8, 2012</td>\n",
       "      <td>A3S02OBZAVQ5SF</td>\n",
       "      <td>KatDoh85</td>\n",
       "      <td>Great price, very sturdy, make a handy person ...</td>\n",
       "      <td>1354924800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1108</th>\n",
       "      <td>B000001OM5</td>\n",
       "      <td>[1, 1]</td>\n",
       "      <td>5</td>\n",
       "      <td>After trying the memorex lens cleaner obtained...</td>\n",
       "      <td>06 19, 2013</td>\n",
       "      <td>APK74RJ5E0DDX</td>\n",
       "      <td>Ficus</td>\n",
       "      <td>Maxell CD-340 Lens Cleaner!</td>\n",
       "      <td>1371600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1485459</th>\n",
       "      <td>B009PIRPG0</td>\n",
       "      <td>[0, 1]</td>\n",
       "      <td>4</td>\n",
       "      <td>I thought this speaker was of the 5&amp;#34; size....</td>\n",
       "      <td>06 6, 2013</td>\n",
       "      <td>A257FDIK89QBE9</td>\n",
       "      <td>Theresa</td>\n",
       "      <td>Smaller than it looks</td>\n",
       "      <td>1370476800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>917519</th>\n",
       "      <td>B0049S6ZUS</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>This is the third HDMI switch I bought.  In my...</td>\n",
       "      <td>06 16, 2014</td>\n",
       "      <td>A1DZNGDRN848BA</td>\n",
       "      <td>Ernie</td>\n",
       "      <td>Works Exactly as Described</td>\n",
       "      <td>1402876800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>752748</th>\n",
       "      <td>B003D8GAA0</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>4</td>\n",
       "      <td>These are a bit tricky to get right - no matte...</td>\n",
       "      <td>02 6, 2014</td>\n",
       "      <td>AT6E6JNL7AMV5</td>\n",
       "      <td>Small Wonder \"ML Small\"</td>\n",
       "      <td>fit perfectly</td>\n",
       "      <td>1391644800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>523533</th>\n",
       "      <td>B001SEQN3K</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>4</td>\n",
       "      <td>The headphone sound quality is decent and the ...</td>\n",
       "      <td>05 10, 2013</td>\n",
       "      <td>A2LYU2OT25EIV3</td>\n",
       "      <td>Billitteri \"Word...\"</td>\n",
       "      <td>They work well. Decent sound</td>\n",
       "      <td>1368144000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47388</th>\n",
       "      <td>B00007056H</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>Good sound light weight and I bought them on &amp;...</td>\n",
       "      <td>06 19, 2013</td>\n",
       "      <td>AUOLM3TA5629E</td>\n",
       "      <td>Shawn L. Oconnell \"king of all dogs\"</td>\n",
       "      <td>Great deal and great light weight on these hea...</td>\n",
       "      <td>1371600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>975155</th>\n",
       "      <td>B004L6MLPQ</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>Had to replace my daughters MBP 15&amp;#34; supply...</td>\n",
       "      <td>03 8, 2014</td>\n",
       "      <td>A2JSYLBHDPMLYY</td>\n",
       "      <td>Juliette A Dimitrov</td>\n",
       "      <td>Perfect Replacment</td>\n",
       "      <td>1394236800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1663308</th>\n",
       "      <td>B00FRDUZXM</td>\n",
       "      <td>[5, 7]</td>\n",
       "      <td>5</td>\n",
       "      <td>I could write 5000 words about this, but my ma...</td>\n",
       "      <td>03 10, 2014</td>\n",
       "      <td>AZICOXVMUPTY3</td>\n",
       "      <td>Jefenator</td>\n",
       "      <td>A specialized, \"artisan\" camera - huge improve...</td>\n",
       "      <td>1394409600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1402810</th>\n",
       "      <td>B008JJLW4M</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>In the near future I will build a desktop comp...</td>\n",
       "      <td>09 27, 2013</td>\n",
       "      <td>A2DT77DYNWF9AZ</td>\n",
       "      <td>Muther</td>\n",
       "      <td>The new way</td>\n",
       "      <td>1380240000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162763</th>\n",
       "      <td>B000A6PPOK</td>\n",
       "      <td>[3, 3]</td>\n",
       "      <td>5</td>\n",
       "      <td>I write and speak for a living.  I've been usi...</td>\n",
       "      <td>01 22, 2013</td>\n",
       "      <td>A2JPEX3KT3AB0T</td>\n",
       "      <td>John N. Doggett</td>\n",
       "      <td>The best Ergonomic Keyboard on the Market.  Pe...</td>\n",
       "      <td>1358812800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1623972</th>\n",
       "      <td>B00DR0PDNE</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>Though Google has been FAR too slow rolling ou...</td>\n",
       "      <td>01 30, 2014</td>\n",
       "      <td>A3H6IFZPQORY04</td>\n",
       "      <td>GeeBee \"caffeine-junkied insomniac\"</td>\n",
       "      <td>2nd one....</td>\n",
       "      <td>1391040000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1433524</th>\n",
       "      <td>B008ZGKWQI</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>When I worked for a tech company, I remember t...</td>\n",
       "      <td>08 22, 2013</td>\n",
       "      <td>A2C7KV2XWWVOB7</td>\n",
       "      <td>Amazon Customer</td>\n",
       "      <td>Just plug it in and it gives me 7 usb ports wh...</td>\n",
       "      <td>1377129600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272711</th>\n",
       "      <td>B000NDHV3S</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>1</td>\n",
       "      <td>Im a photographer and I needed this to work. I...</td>\n",
       "      <td>03 13, 2014</td>\n",
       "      <td>AEYMWENBGBTRQ</td>\n",
       "      <td>Mrs.D, Picture Lady \"Mrs.D Picture Lady\"</td>\n",
       "      <td>Do not buy it.</td>\n",
       "      <td>1394668800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>786411</th>\n",
       "      <td>B003KGBBRM</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>This Firewire base extends the flexibility of ...</td>\n",
       "      <td>02 27, 2013</td>\n",
       "      <td>A266WCM8G3LS5X</td>\n",
       "      <td>Brian A. Foster</td>\n",
       "      <td>Flexibility!</td>\n",
       "      <td>1361923200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>661986</th>\n",
       "      <td>B002TZ4CRG</td>\n",
       "      <td>[1, 1]</td>\n",
       "      <td>5</td>\n",
       "      <td>I used this on the 5th TV I've mounted and thi...</td>\n",
       "      <td>01 30, 2014</td>\n",
       "      <td>A39OM6SPWHS3FK</td>\n",
       "      <td>Neil Collins</td>\n",
       "      <td>The best Low Profile I've used</td>\n",
       "      <td>1391040000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1413740</th>\n",
       "      <td>B008OHNZI0</td>\n",
       "      <td>[0, 1]</td>\n",
       "      <td>3</td>\n",
       "      <td>I couldn't decide between the Tech Armor and Z...</td>\n",
       "      <td>01 26, 2013</td>\n",
       "      <td>A364YOXAKXTXP5</td>\n",
       "      <td>Dan F.</td>\n",
       "      <td>Works well as privacy screen, but ruins retina...</td>\n",
       "      <td>1359158400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1657322</th>\n",
       "      <td>B00FB45SI4</td>\n",
       "      <td>[4, 9]</td>\n",
       "      <td>1</td>\n",
       "      <td>I really was hoping this router would work wel...</td>\n",
       "      <td>12 28, 2013</td>\n",
       "      <td>A1UYTL2O9QH78E</td>\n",
       "      <td>Brett Hanna</td>\n",
       "      <td>High Hopes - Dashed</td>\n",
       "      <td>1388188800</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8060 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               asin   helpful  overall  \\\n",
       "1232663  B006K553LU    [1, 1]        5   \n",
       "369887   B0012S4APK    [0, 0]        5   \n",
       "393272   B0015EDVVU    [0, 0]        5   \n",
       "1072538  B0053O9ZNQ    [0, 0]        4   \n",
       "1659055  B00FF6J532    [6, 6]        5   \n",
       "1311812  B007MW73C2    [2, 2]        5   \n",
       "997812   B004OVECUA    [0, 0]        5   \n",
       "48490    B00007E7C8    [0, 0]        3   \n",
       "553053   B001XURP7W    [0, 0]        5   \n",
       "1614296  B00DGNZ9G8   [9, 10]        4   \n",
       "1653771  B00F3SOHNU  [13, 13]        5   \n",
       "375713   B0013CXZZ6    [0, 0]        5   \n",
       "993754   B004O0TRD8    [0, 0]        3   \n",
       "1438525  B0091JMYWI    [0, 0]        5   \n",
       "849128   B003XZSZWO    [0, 0]        4   \n",
       "1674888  B00H09BOXQ    [4, 4]        5   \n",
       "1212634  B00679A3W8    [0, 0]        5   \n",
       "292037   B000PKX2KA    [0, 0]        5   \n",
       "407331   B0017ZG538    [0, 1]        5   \n",
       "1259005  B0070Z87YO    [0, 1]        5   \n",
       "1259115  B00711ST5O  [11, 11]        4   \n",
       "1533292  B00ATQF0DC    [0, 0]        5   \n",
       "1680618  B00HWMPRKC    [2, 2]        5   \n",
       "1169162  B005NCLDEC    [0, 0]        5   \n",
       "1656781  B00FA4Y7N2    [0, 0]        5   \n",
       "1163710  B005LMWP78    [0, 0]        5   \n",
       "932524   B004CVBWSC    [0, 0]        5   \n",
       "185417   B000CRFOMK    [1, 1]        5   \n",
       "105191   B0002CPBWI    [0, 0]        3   \n",
       "894404   B0044DEDC0    [0, 0]        5   \n",
       "...             ...       ...      ...   \n",
       "1657926  B00FCU6NWM    [1, 2]        2   \n",
       "1683271  B00IEZGWI2  [18, 20]        5   \n",
       "1282914  B00797A5GQ    [0, 0]        4   \n",
       "1213694  B00683X4PQ    [1, 1]        5   \n",
       "1622178  B00DR0PDNE    [0, 0]        4   \n",
       "1374280  B0088RIV1W    [0, 0]        4   \n",
       "342445   B000WS5I7U    [0, 0]        5   \n",
       "1222269  B006EWUO22    [0, 0]        5   \n",
       "1678924  B00HPM1G8Q  [12, 13]        5   \n",
       "1515202  B00A9LHLQ6    [4, 5]        4   \n",
       "1229020  B006J4G49C    [2, 3]        3   \n",
       "1542911  B00B2VMJ00    [0, 0]        5   \n",
       "369983   B0012S4APK    [0, 0]        4   \n",
       "1108     B000001OM5    [1, 1]        5   \n",
       "1485459  B009PIRPG0    [0, 1]        4   \n",
       "917519   B0049S6ZUS    [0, 0]        5   \n",
       "752748   B003D8GAA0    [0, 0]        4   \n",
       "523533   B001SEQN3K    [0, 0]        4   \n",
       "47388    B00007056H    [0, 0]        5   \n",
       "975155   B004L6MLPQ    [0, 0]        5   \n",
       "1663308  B00FRDUZXM    [5, 7]        5   \n",
       "1402810  B008JJLW4M    [0, 0]        5   \n",
       "162763   B000A6PPOK    [3, 3]        5   \n",
       "1623972  B00DR0PDNE    [0, 0]        5   \n",
       "1433524  B008ZGKWQI    [0, 0]        5   \n",
       "272711   B000NDHV3S    [0, 0]        1   \n",
       "786411   B003KGBBRM    [0, 0]        5   \n",
       "661986   B002TZ4CRG    [1, 1]        5   \n",
       "1413740  B008OHNZI0    [0, 1]        3   \n",
       "1657322  B00FB45SI4    [4, 9]        1   \n",
       "\n",
       "                                                reviewText   reviewTime  \\\n",
       "1232663  I chose this product because it seemed to be t...  07 14, 2013   \n",
       "369887   I mounted my LG 42&#34; tv. Easy and did the j...   01 6, 2014   \n",
       "393272   This is my second set of Wiremold kits.  I had...  10 27, 2013   \n",
       "1072538  I chose it because it had almost the same key ...  01 24, 2014   \n",
       "1659055  Memo from a hard core iPad user: Lets face it....  03 11, 2014   \n",
       "1311812  I am an OLD IT person....I started programming...  05 31, 2013   \n",
       "997812   Works great.  If you have ever used a Harmony ...  09 17, 2013   \n",
       "48490    I only had them on 15 minutes before my right ...  01 11, 2014   \n",
       "553053   Great Deal......yes they are a &#34;Bulk-Pack&...  11 30, 2013   \n",
       "1614296  The first thing I want to put out first is tha...  11 16, 2013   \n",
       "1653771  As a self-proclaimed &#34;Apple&#34; guy, I wa...  12 28, 2013   \n",
       "375713   When I ordered this unit, I did not realize th...  05 24, 2013   \n",
       "993754   this has turned out to work reasonably well. t...  03 24, 2013   \n",
       "1438525  Gave this as a gift and she really loves it. I...   01 9, 2013   \n",
       "849128   This was what I ordered, but I wasn't careful ...   10 9, 2013   \n",
       "1674888  If you are a lifetime XP like myself and are f...   04 1, 2014   \n",
       "1212634  You could not ask for a better quality item fo...   02 8, 2013   \n",
       "292037   I bought this for use with Microsoft Streets a...  12 31, 2012   \n",
       "407331   Works Perfect with my new Garmin 2797 7&#34; s...  11 19, 2013   \n",
       "1259005  Got this amp to replace my computer 5.1 setup ...  03 31, 2014   \n",
       "1259115  Purchased these because they were inexpensive....  11 27, 2013   \n",
       "1533292  The feel of the case is nice and rich .... fir...  03 14, 2014   \n",
       "1680618  I've probably had 6 Android tablets so far, an...  06 17, 2014   \n",
       "1169162  I put screen protectors and cases on everythin...  11 25, 2012   \n",
       "1656781  Not cheaply made - this one will not &#34;not ...  02 10, 2014   \n",
       "1163710  It has a lot of pockets and storage areas for ...  06 16, 2014   \n",
       "932524   It's a cable it sits behind the rest of my wir...   07 4, 2013   \n",
       "185417   My items arrived yesterday, so I cannot speak ...  07 12, 2013   \n",
       "105191   Seller offers this as a &#34;new&#34; and a &#...   06 2, 2014   \n",
       "894404   I use my laptop in a port replicator and there...  02 20, 2014   \n",
       "...                                                    ...          ...   \n",
       "1657926  &#34;You get what you pay for&#34;It's depress...  12 19, 2013   \n",
       "1683271  I literally crapped my pants when I plugged th...   05 5, 2014   \n",
       "1282914  I originally bought this for my desk at work b...  10 22, 2013   \n",
       "1213694  CPU-Z identifies it as &#34;Crucial PC3-12800&...  03 23, 2014   \n",
       "1622178  Love it. So easy to use and one can be watchin...  12 14, 2013   \n",
       "1374280  This mounting was priced fairly, is well made ...   10 2, 2013   \n",
       "342445   First of all, I have two of these for two diff...   02 4, 2013   \n",
       "1222269  I bought 16gb mainly for large photoshop docum...  06 15, 2013   \n",
       "1678924  This case provides a good amount of protection...  04 17, 2014   \n",
       "1515202  I had gotten this to improve the performance o...  03 15, 2013   \n",
       "1229020  There has been a lot of talk about the Baofeng...   04 2, 2014   \n",
       "1542911  Fits my 7&#34; Google android Tablet 4.2 Jelly...   12 6, 2013   \n",
       "369983   Wouldn't rely on the level that comes with it,...   12 8, 2012   \n",
       "1108     After trying the memorex lens cleaner obtained...  06 19, 2013   \n",
       "1485459  I thought this speaker was of the 5&#34; size....   06 6, 2013   \n",
       "917519   This is the third HDMI switch I bought.  In my...  06 16, 2014   \n",
       "752748   These are a bit tricky to get right - no matte...   02 6, 2014   \n",
       "523533   The headphone sound quality is decent and the ...  05 10, 2013   \n",
       "47388    Good sound light weight and I bought them on &...  06 19, 2013   \n",
       "975155   Had to replace my daughters MBP 15&#34; supply...   03 8, 2014   \n",
       "1663308  I could write 5000 words about this, but my ma...  03 10, 2014   \n",
       "1402810  In the near future I will build a desktop comp...  09 27, 2013   \n",
       "162763   I write and speak for a living.  I've been usi...  01 22, 2013   \n",
       "1623972  Though Google has been FAR too slow rolling ou...  01 30, 2014   \n",
       "1433524  When I worked for a tech company, I remember t...  08 22, 2013   \n",
       "272711   Im a photographer and I needed this to work. I...  03 13, 2014   \n",
       "786411   This Firewire base extends the flexibility of ...  02 27, 2013   \n",
       "661986   I used this on the 5th TV I've mounted and thi...  01 30, 2014   \n",
       "1413740  I couldn't decide between the Tech Armor and Z...  01 26, 2013   \n",
       "1657322  I really was hoping this router would work wel...  12 28, 2013   \n",
       "\n",
       "             reviewerID                                      reviewerName  \\\n",
       "1232663  A1QDWPIXFKS0CU                                              Lexi   \n",
       "369887   A1428302YLXZXD                                      Jerry Choate   \n",
       "393272   A38LVONPQQT3GW                      A. Mcintyre \"Frugal Shopper\"   \n",
       "1072538  A3AVSGDYKZMCOX                                            chriek   \n",
       "1659055   ATGLHCY1BZ0TO                                             conis   \n",
       "1311812   AQXB4AR9HCZTE                                        1912 House   \n",
       "997812   A3RACIXI8CK305                                               Ken   \n",
       "48490     ALIYGP2HGXOZT                                Spots \"shialavati\"   \n",
       "553053   A3MJR0F0NUWJL7                                            Steven   \n",
       "1614296   AYANKSMR7OVJX                                          YourName   \n",
       "1653771   AX479H8UX80N4                                             Blake   \n",
       "375713   A3H09VQI43K2PJ                                         D. G. Orr   \n",
       "993754   A3SMPQ72XQ75W3                       bluecitabria \"bluecitabria\"   \n",
       "1438525   AS6YV5VLYZVAA                                             Carla   \n",
       "849128   A3C67YYQ9S1BEE                                   D. Johnson \"DJ\"   \n",
       "1674888  A24JWLYUXFS7I3                                   Jonathan Stoops   \n",
       "1212634  A3E0OTIDJR95E5                                     Diane Jenkins   \n",
       "292037   A13B7T48AHY6AV                                      Daddicus Rex   \n",
       "407331   A3JBUZBUCRLQ4Z                                     Mike \"mk3509\"   \n",
       "1259005  A1HJ9UMIAYY6C4                                               Leo   \n",
       "1259115  A2NG1RE7UX6ST0                                      Son of Barra   \n",
       "1533292  A2F3CXXSQ1UZHM                                   real gypsy girl   \n",
       "1680618   AVJ6URCLNJQD2                                       Marc Strand   \n",
       "1169162  A1XMJXT4ZXPXOV                                          Sambardo   \n",
       "1656781  A2O5QPR9OHW8I2                                         ChrisinWV   \n",
       "1163710  A1025YTKW6RZ2L                                     Mark Muranaka   \n",
       "932524   A3MA21HKGWAIJ0                                          Chris S.   \n",
       "185417   A23D13HKTA95WX                   David Hostetler \"SuperDave3006\"   \n",
       "105191    AOLK0TVACBKE8                                      David Felder   \n",
       "894404   A3RWN5RBIOE1JT                                      Admin_Dude42   \n",
       "...                 ...                                               ...   \n",
       "1657926  A2171RS26KJQUX  Phillip A. Oliveto \"Don't knock it until you'...   \n",
       "1683271  A2M7GEJQPA0TUV                                               DGK   \n",
       "1282914   AXETJKRX8OH24                                           GeekDad   \n",
       "1213694  A1ZX9OE1TCFIKL                              D Bruton \"dabruton2\"   \n",
       "1622178  A3HOC1P7HS7KFC                                               NaN   \n",
       "1374280  A3P2OS8DYFVZWS                                      Deal Pilgrim   \n",
       "342445   A2N4P35FVAGYAL                                          desorbod   \n",
       "1222269  A1K0JKU03DVRI6                                             Monda   \n",
       "1678924  A1P0JSFW184ZXJ                                   Jen \"Geek Girl\"   \n",
       "1515202  A2AC7YG25V0ABD                                              Tech   \n",
       "1229020  A2L36AGL8CKY3D                                         Tex \"Tex\"   \n",
       "1542911  A35SYWA7A3XOXM                       Does Amazon pay for clicks?   \n",
       "369983   A3S02OBZAVQ5SF                                          KatDoh85   \n",
       "1108      APK74RJ5E0DDX                                             Ficus   \n",
       "1485459  A257FDIK89QBE9                                           Theresa   \n",
       "917519   A1DZNGDRN848BA                                             Ernie   \n",
       "752748    AT6E6JNL7AMV5                           Small Wonder \"ML Small\"   \n",
       "523533   A2LYU2OT25EIV3                              Billitteri \"Word...\"   \n",
       "47388     AUOLM3TA5629E              Shawn L. Oconnell \"king of all dogs\"   \n",
       "975155   A2JSYLBHDPMLYY                               Juliette A Dimitrov   \n",
       "1663308   AZICOXVMUPTY3                                         Jefenator   \n",
       "1402810  A2DT77DYNWF9AZ                                            Muther   \n",
       "162763   A2JPEX3KT3AB0T                                   John N. Doggett   \n",
       "1623972  A3H6IFZPQORY04               GeeBee \"caffeine-junkied insomniac\"   \n",
       "1433524  A2C7KV2XWWVOB7                                   Amazon Customer   \n",
       "272711    AEYMWENBGBTRQ          Mrs.D, Picture Lady \"Mrs.D Picture Lady\"   \n",
       "786411   A266WCM8G3LS5X                                   Brian A. Foster   \n",
       "661986   A39OM6SPWHS3FK                                      Neil Collins   \n",
       "1413740  A364YOXAKXTXP5                                            Dan F.   \n",
       "1657322  A1UYTL2O9QH78E                                       Brett Hanna   \n",
       "\n",
       "                                                   summary  unixReviewTime  \n",
       "1232663                    Great value and awesome product      1373760000  \n",
       "369887                                  Good, Solid Mount!      1388966400  \n",
       "393272     Great addition to any home entertainment system      1382832000  \n",
       "1072538                              Good compact keyboard      1390521600  \n",
       "1659055                                     Totally SLICK!      1394496000  \n",
       "1311812            Leap of Faith - gaming, school and work      1369958400  \n",
       "997812                  This is my favorite remote. Period      1379376000  \n",
       "48490                                 Ear cups too shallow      1389398400  \n",
       "553053               Great Deal: Two for the price of One!      1385769600  \n",
       "1614296    Missing parts, but never the less a good value.      1384560000  \n",
       "1653771                     An Interesting Twist of Events      1388188800  \n",
       "375713                                      Good surprise.      1369353600  \n",
       "993754                        good value. good performance      1364083200  \n",
       "1438525                                               gift      1357689600  \n",
       "849128   Seems to be good product; but different polari...      1381276800  \n",
       "1674888                                      Doesn't suck!      1396310400  \n",
       "1212634                                       Great Price!      1360281600  \n",
       "292037                                        Nice product      1356912000  \n",
       "407331                  The best mount I have ever bought!      1384819200  \n",
       "1259005                    Great sound! Even better value!      1396224000  \n",
       "1259115                               Brings home the boom      1385510400  \n",
       "1533292                                    Love this case!      1394755200  \n",
       "1680618  A high-end tablet at a high-end price -- you g...      1402963200  \n",
       "1169162                             No bubbles, no problem      1353801600  \n",
       "1656781                               Compatible and solid      1391990400  \n",
       "1163710                                               Nice      1402876800  \n",
       "932524                It works just like it was advertise!      1372896000  \n",
       "185417   Correct item showed up. Pretty basic, but it's...      1373587200  \n",
       "105191                                   Seller problem...      1401667200  \n",
       "894404                   Easy to install and sounds decent      1392854400  \n",
       "...                                                    ...             ...  \n",
       "1657926                           Looks and feels cheap...      1387411200  \n",
       "1683271                                              Crap!      1399248000  \n",
       "1282914                                Great for traveling      1382400000  \n",
       "1213694                                         Works well      1395532800  \n",
       "1622178                          Great, but can get better      1386979200  \n",
       "1374280  Infinite swivel flexibility - perfect for kitc...      1380672000  \n",
       "342445                One of the best items every created!      1359936000  \n",
       "1222269            Fast and more than you could ever need.      1371254400  \n",
       "1678924      Turn your Kindle Fire HDX into a mini laptop!      1397692800  \n",
       "1515202                              Good beginner DAC/Amp      1363305600  \n",
       "1229020                  Read before purchasing this radio      1396396800  \n",
       "1542911                                          I love it      1386288000  \n",
       "369983   Great price, very sturdy, make a handy person ...      1354924800  \n",
       "1108                           Maxell CD-340 Lens Cleaner!      1371600000  \n",
       "1485459                              Smaller than it looks      1370476800  \n",
       "917519                          Works Exactly as Described      1402876800  \n",
       "752748                                       fit perfectly      1391644800  \n",
       "523533                        They work well. Decent sound      1368144000  \n",
       "47388    Great deal and great light weight on these hea...      1371600000  \n",
       "975155                                  Perfect Replacment      1394236800  \n",
       "1663308  A specialized, \"artisan\" camera - huge improve...      1394409600  \n",
       "1402810                                        The new way      1380240000  \n",
       "162763   The best Ergonomic Keyboard on the Market.  Pe...      1358812800  \n",
       "1623972                                        2nd one....      1391040000  \n",
       "1433524  Just plug it in and it gives me 7 usb ports wh...      1377129600  \n",
       "272711                                      Do not buy it.      1394668800  \n",
       "786411                                        Flexibility!      1361923200  \n",
       "661986                      The best Low Profile I've used      1391040000  \n",
       "1413740  Works well as privacy screen, but ruins retina...      1359158400  \n",
       "1657322                                High Hopes - Dashed      1388188800  \n",
       "\n",
       "[8060 rows x 9 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# While exploring the file I noticed that HTML entities are escaped. So instead of having\n",
    "# \" there is &#34; which is the HTML entity for double quote.\n",
    "# Let's clean this up by escaping the HTML entities in the reviw text\n",
    "\n",
    "# Let's preview rows that have HTML entities in the review text\n",
    "reviews_subset[reviews_subset['reviewText'].str.contains(\"&#34;\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(8060, 9)"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "reviews_subset[reviews_subset['reviewText'].str.contains(\"&#34;\")].shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(0, 9)"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# use an apply function to unescape html entities in the review text\n",
    "from html import unescape\n",
    "unescaper = lambda text: unescape(text)\n",
    "\n",
    "reviews_subset['reviewText'] = reviews_subset['reviewText'].apply(unescaper)\n",
    "\n",
    "# Verify that it worked by counting the number of rows with &#34; (the HTML entity for \")\n",
    "reviews_subset[reviews_subset['reviewText'].str.contains(\"&#34;\")].shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(200000, 9)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Save the file as a CSV \n",
    "reviews_subset.to_csv('data/amazon_electronics_reviews_subset.csv')\n",
    "reviews_subset.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>asin</th>\n",
       "      <th>helpful</th>\n",
       "      <th>overall</th>\n",
       "      <th>reviewText</th>\n",
       "      <th>reviewTime</th>\n",
       "      <th>reviewerID</th>\n",
       "      <th>reviewerName</th>\n",
       "      <th>summary</th>\n",
       "      <th>unixReviewTime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>674608</th>\n",
       "      <td>B002W7CW32</td>\n",
       "      <td>[1, 3]</td>\n",
       "      <td>5</td>\n",
       "      <td>got  my first projector yesterday from visuala...</td>\n",
       "      <td>04 7, 2010</td>\n",
       "      <td>A33XWDU85V5ZGM</td>\n",
       "      <td>Prasad N. Badal \"PB\"</td>\n",
       "      <td>updated review- still loving it</td>\n",
       "      <td>1270598400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>572683</th>\n",
       "      <td>B0028PJ6OQ</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>4</td>\n",
       "      <td>It is a decently made keyboard with a very bri...</td>\n",
       "      <td>08 16, 2013</td>\n",
       "      <td>AG2CSACQ7SXRK</td>\n",
       "      <td>Ginny's Store \"Ginny\"</td>\n",
       "      <td>Very brite</td>\n",
       "      <td>1376611200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1142343</th>\n",
       "      <td>B005HMO6A6</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>This keyboard is spot on. The first thing that...</td>\n",
       "      <td>08 14, 2013</td>\n",
       "      <td>A3REQ9RHP8LLWZ</td>\n",
       "      <td>theonerandom</td>\n",
       "      <td>Quality Keyboard A+</td>\n",
       "      <td>1376438400</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               asin helpful  overall  \\\n",
       "674608   B002W7CW32  [1, 3]        5   \n",
       "572683   B0028PJ6OQ  [0, 0]        4   \n",
       "1142343  B005HMO6A6  [0, 0]        5   \n",
       "\n",
       "                                                reviewText   reviewTime  \\\n",
       "674608   got  my first projector yesterday from visuala...   04 7, 2010   \n",
       "572683   It is a decently made keyboard with a very bri...  08 16, 2013   \n",
       "1142343  This keyboard is spot on. The first thing that...  08 14, 2013   \n",
       "\n",
       "             reviewerID           reviewerName  \\\n",
       "674608   A33XWDU85V5ZGM   Prasad N. Badal \"PB\"   \n",
       "572683    AG2CSACQ7SXRK  Ginny's Store \"Ginny\"   \n",
       "1142343  A3REQ9RHP8LLWZ           theonerandom   \n",
       "\n",
       "                                 summary  unixReviewTime  \n",
       "674608   updated review- still loving it      1270598400  \n",
       "572683                        Very brite      1376611200  \n",
       "1142343              Quality Keyboard A+      1376438400  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Read the file back in to check that it saved correctly\n",
    "test_df = pd.read_csv('data/amazon_electronics_reviews_subset.csv', header=0, index_col=0)\n",
    "test_df.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(200000, 9)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "B007WTAJTO    4914\n",
       "B003ES5ZUU    4143\n",
       "B00DR0PDNE    3798\n",
       "B0019EHU8G    3435\n",
       "B002WE6D44    2813\n",
       "B003ELYQGG    2652\n",
       "B0002L5R78    2598\n",
       "B009SYZ8OC    2542\n",
       "B00BGGDVOO    2104\n",
       "B002V88HFE    2081\n",
       "Name: asin, dtype: int64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Let's make another data set has reviews for the single product with the most reviews\n",
    "# Which product has the most reviews?\n",
    "reviews['asin'].value_counts()[0:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Let's see what kind of produc this is\n",
    "most_reviews = reviews.loc[reviews['asin']==\"B007WTAJTO\"].copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "This card has worked flawlessly so far. I use it in my Garmin Montana 600 and it allows me to load all my USGS 1:24,000 quads (US - SW, W, S Central, N Central and inland lakes) I was at first concerned that the 600 would not take 32 gb micro SD but no problem.\n",
      "- - - - - -\n",
      "Works perfect in Samsung Tab 2. It quadrupled my storage capability and seems to be very fast.  I would recommend to anyone\n",
      "- - - - - -\n",
      "I use these in my tablet as well as my camera. I find slower speed cards do not work well when taking pictures or video. It would be nice if the SD adapter had built in WiFi, that way for my DSLR, I would only need to buy one WiFi card and simply replace it with these micro SD cards and save money.\n",
      "- - - - - -\n",
      "I bought two of these for our new telephones. They work fine and were just what we needed if we have extra pictures on the phones. Pictures do take up a lot of room but now we don't have to worry about running out of room.\n",
      "- - - - - -\n",
      "Good size card and a great price. My only complaint is with the adapter card. The little lip on the end of the micro card is almost nonexistent and the adapter card slot is very, very tight. The only way I could get the micro card out was with needle nose pliers. Had to take a utility knife to the opening of the adapter card so I could actually slide it in an out with ease.\n",
      "- - - - - -\n"
     ]
    }
   ],
   "source": [
    "sample_most_reviews = most_reviews['reviewText'].sample(n=5)\n",
    "\n",
    "for review in sample_most_reviews:\n",
    "    print(review)     \n",
    "    print('- - - - - -')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# It looks like these are review for a Sandisk MicroSD card: http://a.co/6lnlOVo\n",
    "# Let's save these reviews as another data file and go through the same\n",
    "# Steps to unescape the HTML entities."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>asin</th>\n",
       "      <th>helpful</th>\n",
       "      <th>overall</th>\n",
       "      <th>reviewText</th>\n",
       "      <th>reviewTime</th>\n",
       "      <th>reviewerID</th>\n",
       "      <th>reviewerName</th>\n",
       "      <th>summary</th>\n",
       "      <th>unixReviewTime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1336624</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I like this SD Card because it can take music ...</td>\n",
       "      <td>05 11, 2013</td>\n",
       "      <td>A1RTQROTWR5NCB</td>\n",
       "      <td>808TREX50</td>\n",
       "      <td>32GB MicroSD Card.</td>\n",
       "      <td>1368230400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1336670</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>4</td>\n",
       "      <td>Used in my phone it's plenty fast and works ju...</td>\n",
       "      <td>11 5, 2013</td>\n",
       "      <td>A1R0JMNRV7HVQM</td>\n",
       "      <td>ACZ</td>\n",
       "      <td>Works just like it should in my phone</td>\n",
       "      <td>1383609600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1336674</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>You'll pay $10 more for these anywhere else. I...</td>\n",
       "      <td>02 12, 2014</td>\n",
       "      <td>AI1NJ92OUOM2V</td>\n",
       "      <td>Adam M Barnes</td>\n",
       "      <td>Great product at a great price.</td>\n",
       "      <td>1392163200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1336699</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>Lot of questions about this memory card fittin...</td>\n",
       "      <td>02 17, 2014</td>\n",
       "      <td>A16PH8I60IGM4F</td>\n",
       "      <td>A. GONZALEZ MEDINA</td>\n",
       "      <td>Works OK with the Samsung Galaxy Tab 3 10.1...</td>\n",
       "      <td>1392595200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1336727</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>4</td>\n",
       "      <td>I bought this for my son's tablet for cartoon ...</td>\n",
       "      <td>04 12, 2013</td>\n",
       "      <td>A1NZR4UN6DJQIO</td>\n",
       "      <td>Albert</td>\n",
       "      <td>Works great</td>\n",
       "      <td>1365724800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1336860</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I use this in my Samsung Galaxy Note II. For t...</td>\n",
       "      <td>05 30, 2013</td>\n",
       "      <td>A2HY1IGOK2MX5G</td>\n",
       "      <td>Amazon Customer</td>\n",
       "      <td>Great Quality</td>\n",
       "      <td>1369872000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1336864</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I wasn't absolutely certain if this would work...</td>\n",
       "      <td>04 27, 2013</td>\n",
       "      <td>A33M3XQJF4PDE1</td>\n",
       "      <td>Amazon Customer</td>\n",
       "      <td>Reliable expansion for your MicroSDXC needs</td>\n",
       "      <td>1367020800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1336910</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 3]</td>\n",
       "      <td>2</td>\n",
       "      <td>Thus microSD card worked fine for a year in my...</td>\n",
       "      <td>04 28, 2014</td>\n",
       "      <td>A308JP3BK4VAL7</td>\n",
       "      <td>Amazon Customer</td>\n",
       "      <td>Inadequate life span - lasted 1 year then failed</td>\n",
       "      <td>1398643200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1336915</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[1, 1]</td>\n",
       "      <td>5</td>\n",
       "      <td>I have this regularly plugged into my ASUS Tra...</td>\n",
       "      <td>09 2, 2013</td>\n",
       "      <td>A2O8NMK3RVDBAE</td>\n",
       "      <td>Amazon Customer</td>\n",
       "      <td>Speed, capacity and price!</td>\n",
       "      <td>1378080000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1336966</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>4</td>\n",
       "      <td>I just bought two of these for our two new Sam...</td>\n",
       "      <td>10 4, 2013</td>\n",
       "      <td>A3SMW7RDCEUJ24</td>\n",
       "      <td>Amazon Customer \"ZundapMan\"</td>\n",
       "      <td>Probably could have scrimpted and paid less...</td>\n",
       "      <td>1380844800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337050</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>Super fast compared to my other cards. Didn't ...</td>\n",
       "      <td>01 8, 2013</td>\n",
       "      <td>AWATUDXT8A7TA</td>\n",
       "      <td>Anthony Nonya</td>\n",
       "      <td>Fast</td>\n",
       "      <td>1357603200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337135</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>My Android tablet is a toy; there is nothing c...</td>\n",
       "      <td>06 18, 2014</td>\n",
       "      <td>A3PSG14OAK2A5F</td>\n",
       "      <td>Badotz \"Badotz\"</td>\n",
       "      <td>My Android tablet is all growed up!</td>\n",
       "      <td>1403049600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337161</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>We have bought two of these.  You get an open ...</td>\n",
       "      <td>05 12, 2014</td>\n",
       "      <td>A2L9I233YA2LDM</td>\n",
       "      <td>B. C. Dunlap</td>\n",
       "      <td>Bought for Samsung Galaxy S4</td>\n",
       "      <td>1399852800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337224</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 1]</td>\n",
       "      <td>5</td>\n",
       "      <td>I like to keep track of the &amp;#34;Daily Deals&amp;#...</td>\n",
       "      <td>06 24, 2014</td>\n",
       "      <td>A1F70KXI4UC60P</td>\n",
       "      <td>Bill \"Bill\"</td>\n",
       "      <td>I got it as a \"Daily Deal\" for $30</td>\n",
       "      <td>1403568000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337283</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I'm a music lover and like to carry my entire ...</td>\n",
       "      <td>06 21, 2014</td>\n",
       "      <td>A3ME4OH7OIKNJQ</td>\n",
       "      <td>Bonemane</td>\n",
       "      <td>Upgraded from 64gb to 128gb without any hassle</td>\n",
       "      <td>1403308800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337289</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 1]</td>\n",
       "      <td>3</td>\n",
       "      <td>Picked up this memory card at a great price on...</td>\n",
       "      <td>12 30, 2012</td>\n",
       "      <td>A2Y50SME6VPWYO</td>\n",
       "      <td>boomer \"Boomer\"</td>\n",
       "      <td>Great product (if it works in your model phone)</td>\n",
       "      <td>1356825600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337381</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>Perfect for our GoPro.  We haven't &amp;#34;maxed&amp;...</td>\n",
       "      <td>02 25, 2013</td>\n",
       "      <td>A308WW1LERDD4Z</td>\n",
       "      <td>Brusso</td>\n",
       "      <td>Perfect for our GoPro</td>\n",
       "      <td>1361750400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337384</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>Great card at a great price.  Hard to believe ...</td>\n",
       "      <td>02 9, 2014</td>\n",
       "      <td>A1BSQ4J3AOWIZ9</td>\n",
       "      <td>Bryan</td>\n",
       "      <td>great price</td>\n",
       "      <td>1391904000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337401</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>Bought two separately.1) One was a frustration...</td>\n",
       "      <td>01 29, 2014</td>\n",
       "      <td>ANEKXBM3HB75J</td>\n",
       "      <td>Bumqui</td>\n",
       "      <td>Works</td>\n",
       "      <td>1390953600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337485</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I use this card in my 7&amp;#34; iGo GPS. The GPS ...</td>\n",
       "      <td>04 18, 2013</td>\n",
       "      <td>A36LMXZJQFOH4W</td>\n",
       "      <td>C.B. Stone</td>\n",
       "      <td>Little card holds a lot of stuff</td>\n",
       "      <td>1366243200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337514</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>4</td>\n",
       "      <td>The micro SD card was extremely fast.  Writing...</td>\n",
       "      <td>07 8, 2013</td>\n",
       "      <td>A2ROR47LOES6F5</td>\n",
       "      <td>Charles C. Moy</td>\n",
       "      <td>Very fast memory card</td>\n",
       "      <td>1373241600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337521</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I've never had a problem with Sandisk memory p...</td>\n",
       "      <td>07 6, 2014</td>\n",
       "      <td>A27IL9J0ZNMTJC</td>\n",
       "      <td>Charles W. Stewart</td>\n",
       "      <td>A great product with no problems</td>\n",
       "      <td>1404604800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337529</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>4</td>\n",
       "      <td>I got this to upgrade my surface pro 2's stora...</td>\n",
       "      <td>03 9, 2014</td>\n",
       "      <td>A2OTTBZWWA0U7V</td>\n",
       "      <td>Chaz Ashley</td>\n",
       "      <td>Works nicely</td>\n",
       "      <td>1394323200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337549</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 1]</td>\n",
       "      <td>5</td>\n",
       "      <td>I am using this to add capacity to my Android ...</td>\n",
       "      <td>05 26, 2013</td>\n",
       "      <td>A30JLW5XPHUNKA</td>\n",
       "      <td>chris cooper</td>\n",
       "      <td>High capacity</td>\n",
       "      <td>1369526400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337551</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I bought one of the 32GB for my Galaxy S4, and...</td>\n",
       "      <td>02 24, 2014</td>\n",
       "      <td>A14Z6D3IRJ23F7</td>\n",
       "      <td>Chris F \"root\"</td>\n",
       "      <td>Fast card, very reliable, great price.</td>\n",
       "      <td>1393200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337612</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>32 gig MicroSD card that costs less than a dol...</td>\n",
       "      <td>03 11, 2013</td>\n",
       "      <td>A9YYXQEQ59YQ</td>\n",
       "      <td>Clifton Stuckey \"silver screen votary\"</td>\n",
       "      <td>This thing is fast</td>\n",
       "      <td>1362960000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337624</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>Purchased this along with the Nifty Minidrive ...</td>\n",
       "      <td>07 4, 2014</td>\n",
       "      <td>A1WKDR87HKTL93</td>\n",
       "      <td>Cody</td>\n",
       "      <td>Exactly what I was looking for...</td>\n",
       "      <td>1404432000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337705</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>4</td>\n",
       "      <td>Alot of storage for a great price. Only one pr...</td>\n",
       "      <td>01 9, 2014</td>\n",
       "      <td>A10SOO0G3PIJ9L</td>\n",
       "      <td>Curtis Massey</td>\n",
       "      <td>Great SD card, but........</td>\n",
       "      <td>1389225600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337709</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I have had cheaper SD Cards in the past, but t...</td>\n",
       "      <td>03 9, 2013</td>\n",
       "      <td>A2QC7V9IXJC708</td>\n",
       "      <td>C. Wells</td>\n",
       "      <td>You Get What You Pay For</td>\n",
       "      <td>1362787200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337724</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>5</td>\n",
       "      <td>Purchased this product for a new 7&amp;#34; Garmin...</td>\n",
       "      <td>04 27, 2014</td>\n",
       "      <td>A1KOKJZKWWGHBZ</td>\n",
       "      <td>Dale T. Brose \"nascardog\"</td>\n",
       "      <td>Wow wow wow</td>\n",
       "      <td>1398556800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1340540</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>3</td>\n",
       "      <td>Seemed to work as advertised.  But my first on...</td>\n",
       "      <td>07 2, 2013</td>\n",
       "      <td>A1HB9TA9NA7O3H</td>\n",
       "      <td>Rodney Cyr</td>\n",
       "      <td>OK, but First One Failed After One Week</td>\n",
       "      <td>1372723200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1340590</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I use this on my small ASUS 10.1&amp;#34; notepad ...</td>\n",
       "      <td>04 10, 2014</td>\n",
       "      <td>A35QMY5TQY2HFA</td>\n",
       "      <td>R. Shehane \"Ron\"</td>\n",
       "      <td>Good Micro Card</td>\n",
       "      <td>1397088000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1340663</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>2</td>\n",
       "      <td>I think I got 8 or 9 months out of this before...</td>\n",
       "      <td>04 15, 2014</td>\n",
       "      <td>A1LSFG5FJB9TQ9</td>\n",
       "      <td>Sandal \"&amp;#34;MFB&amp;#34;\"</td>\n",
       "      <td>Great while it lasted...</td>\n",
       "      <td>1397520000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1340759</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>Bought this to expand storage in my Windows 8 ...</td>\n",
       "      <td>03 31, 2014</td>\n",
       "      <td>AK37J5GXFGW68</td>\n",
       "      <td>S. Frainier \"rfrainier\"</td>\n",
       "      <td>Nice upgrade for my ASUS Transformer Book T100TA</td>\n",
       "      <td>1396224000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1340769</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I have a long term positive experience using S...</td>\n",
       "      <td>03 19, 2014</td>\n",
       "      <td>A3JU0TZ23LQVU1</td>\n",
       "      <td>Shaell Rodriguez De Cruz</td>\n",
       "      <td>Speedy, spacious and a great value. Works grea...</td>\n",
       "      <td>1395187200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1340781</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I purchased a Samsung 7&amp;#34; I primarily use a...</td>\n",
       "      <td>03 6, 2014</td>\n",
       "      <td>A340UTBGHV3ZZN</td>\n",
       "      <td>Sharon L. \"Sharon L.\"</td>\n",
       "      <td>Great little device</td>\n",
       "      <td>1394064000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1340790</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>4</td>\n",
       "      <td>i bought this for only one use, to put in my s...</td>\n",
       "      <td>12 6, 2012</td>\n",
       "      <td>A14PJ6GP1GS4TM</td>\n",
       "      <td>Shawn Fallin</td>\n",
       "      <td>be careful with this</td>\n",
       "      <td>1354752000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1340809</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>64GB is pretty good size, and in a cell phone,...</td>\n",
       "      <td>01 2, 2013</td>\n",
       "      <td>A1ITFRPPKFD4KP</td>\n",
       "      <td>S. Hunt</td>\n",
       "      <td>For the price you can't go wrong</td>\n",
       "      <td>1357084800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1340839</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[1, 1]</td>\n",
       "      <td>3</td>\n",
       "      <td>had to send it back to SanDisk.  They did repl...</td>\n",
       "      <td>09 29, 2013</td>\n",
       "      <td>A3EZFPA1U61I2G</td>\n",
       "      <td>slcpunk</td>\n",
       "      <td>failed after a few months</td>\n",
       "      <td>1380412800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1340847</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>Go two during a &amp;#34;Deal of the Day&amp;#34;. Cou...</td>\n",
       "      <td>01 10, 2014</td>\n",
       "      <td>A1I29V2Y9Q6D3P</td>\n",
       "      <td>smaruthi</td>\n",
       "      <td>Great card at a great price</td>\n",
       "      <td>1389312000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1340916</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[14, 16]</td>\n",
       "      <td>5</td>\n",
       "      <td>So I got this SD specifically for my GoPro Bla...</td>\n",
       "      <td>03 21, 2014</td>\n",
       "      <td>A2EL2GWJ9T0DWY</td>\n",
       "      <td>Stayeraug</td>\n",
       "      <td>Perfect with GoPro Black 3+</td>\n",
       "      <td>1395360000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1340945</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[1, 1]</td>\n",
       "      <td>5</td>\n",
       "      <td>I have a lot of music (59 GB) and many videos ...</td>\n",
       "      <td>06 10, 2014</td>\n",
       "      <td>AQZWPO4SDYBVD</td>\n",
       "      <td>Steve \"flixnpix\"</td>\n",
       "      <td>Perfect for my Samsung Galaxy S5</td>\n",
       "      <td>1402358400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1340982</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[1, 1]</td>\n",
       "      <td>1</td>\n",
       "      <td>As the title says, the card I got is defective...</td>\n",
       "      <td>03 10, 2014</td>\n",
       "      <td>A37R5M2DJRRWG8</td>\n",
       "      <td>S-T-R-Y-D-E-R</td>\n",
       "      <td>Sd Card always unexpectedly unmounts and remounts</td>\n",
       "      <td>1394409600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1340984</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I was a bit apprehensive about getting this SD...</td>\n",
       "      <td>04 12, 2014</td>\n",
       "      <td>ANQYNX4B62RT5</td>\n",
       "      <td>Stuck in Alaska</td>\n",
       "      <td>Works great!</td>\n",
       "      <td>1397260800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1341043</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I added this SanDisk Ultra 32 GB microSDHC to ...</td>\n",
       "      <td>03 2, 2013</td>\n",
       "      <td>A2PHRC1HCFR8A1</td>\n",
       "      <td>T. Copeland</td>\n",
       "      <td>Works great</td>\n",
       "      <td>1362182400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1341076</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>4</td>\n",
       "      <td>Sometimes when the price is too low you get le...</td>\n",
       "      <td>01 7, 2014</td>\n",
       "      <td>A2O4EDUJ1DDP66</td>\n",
       "      <td>Terrence K. Wraight \"gadgethound\"</td>\n",
       "      <td>I was suspicious with such a low price</td>\n",
       "      <td>1389052800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1341112</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>Bought this for my HTC Evo 4G LTE, it works gr...</td>\n",
       "      <td>01 10, 2013</td>\n",
       "      <td>A3TJCU8B44PGS8</td>\n",
       "      <td>The Frog</td>\n",
       "      <td>Works great in an Evo 4G LTE</td>\n",
       "      <td>1357776000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1341184</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>1</td>\n",
       "      <td>Within an hour of using the memory card, it fa...</td>\n",
       "      <td>01 28, 2013</td>\n",
       "      <td>A24Q80R2AB3EO</td>\n",
       "      <td>T. Narayanan</td>\n",
       "      <td>Don't Buy This CR*P</td>\n",
       "      <td>1359331200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1341208</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>3</td>\n",
       "      <td>When I bought this a year ago, I had problems ...</td>\n",
       "      <td>12 1, 2013</td>\n",
       "      <td>A37JYON6897Q2Y</td>\n",
       "      <td>Tom</td>\n",
       "      <td>May not work well in your android device</td>\n",
       "      <td>1385856000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1341240</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I'm not sure what else to say other than, &amp;#34...</td>\n",
       "      <td>05 21, 2014</td>\n",
       "      <td>A211KF6L25L8XV</td>\n",
       "      <td>Tough Nut</td>\n",
       "      <td>Works</td>\n",
       "      <td>1400630400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1341283</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I think the title says it all. This card is &amp;#...</td>\n",
       "      <td>11 1, 2013</td>\n",
       "      <td>A2DB3W4GWFLJIA</td>\n",
       "      <td>twilightstar</td>\n",
       "      <td>Super Fast and Works Great</td>\n",
       "      <td>1383264000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1341286</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[45, 49]</td>\n",
       "      <td>5</td>\n",
       "      <td>Sandisk announcement of the first 128GB micro ...</td>\n",
       "      <td>03 7, 2014</td>\n",
       "      <td>A2DKQQIZ793AV5</td>\n",
       "      <td>Twister</td>\n",
       "      <td>Super high capacity!!!  Excellent price (on Am...</td>\n",
       "      <td>1394150400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1341302</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I've used many SanDisk memory cards over the y...</td>\n",
       "      <td>01 31, 2014</td>\n",
       "      <td>A2QB5EM08KTI1G</td>\n",
       "      <td>Umpire.20</td>\n",
       "      <td>Another Quality Product from SanDisk</td>\n",
       "      <td>1391126400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1341310</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I got the &amp;#34;Ultra&amp;#34; becuase it said it l...</td>\n",
       "      <td>04 3, 2013</td>\n",
       "      <td>A324Q16NTIRFR9</td>\n",
       "      <td>Vanessa Roberts \"Book Lover\"</td>\n",
       "      <td>It seems faster</td>\n",
       "      <td>1364947200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1341316</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>It amazing how much data they can fit on these...</td>\n",
       "      <td>10 17, 2013</td>\n",
       "      <td>AIVU1J51MJ9O2</td>\n",
       "      <td>Vaughn \"The answer man!\"</td>\n",
       "      <td>Works great!</td>\n",
       "      <td>1381968000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1341326</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>I placed it in my better half's Samsung Galaxy...</td>\n",
       "      <td>11 21, 2013</td>\n",
       "      <td>A3QIEVO240ZIEJ</td>\n",
       "      <td>vetteman18361</td>\n",
       "      <td>Good to Go</td>\n",
       "      <td>1384992000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1341341</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[2, 2]</td>\n",
       "      <td>3</td>\n",
       "      <td>Bought this for Samsung Galaxy S3 in Fall 2012...</td>\n",
       "      <td>05 13, 2013</td>\n",
       "      <td>A59DOB4UY2K9T</td>\n",
       "      <td>villapoo</td>\n",
       "      <td>Awesome when not defective</td>\n",
       "      <td>1368403200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1341400</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>3</td>\n",
       "      <td>When I first inserted the card in my computer ...</td>\n",
       "      <td>02 8, 2014</td>\n",
       "      <td>AR7NZ6M0KDS2M</td>\n",
       "      <td>Westside</td>\n",
       "      <td>Card not recognized - Bad adapter</td>\n",
       "      <td>1391817600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1341473</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>With the adapter I can easily use it in my cam...</td>\n",
       "      <td>03 24, 2014</td>\n",
       "      <td>A21HP6M30Q5PAA</td>\n",
       "      <td>W.T. HAMPTON</td>\n",
       "      <td>VERSATILE !</td>\n",
       "      <td>1395619200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1341506</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 1]</td>\n",
       "      <td>1</td>\n",
       "      <td>Hello,Great card, great price. Plenty of speed...</td>\n",
       "      <td>12 26, 2013</td>\n",
       "      <td>A2SVI2JSSMA3PS</td>\n",
       "      <td>Zackariah Zielieke</td>\n",
       "      <td>It worked good until return policy was out</td>\n",
       "      <td>1388016000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>135 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               asin   helpful  overall  \\\n",
       "1336624  B007WTAJTO    [0, 0]        5   \n",
       "1336670  B007WTAJTO    [0, 0]        4   \n",
       "1336674  B007WTAJTO    [0, 0]        5   \n",
       "1336699  B007WTAJTO    [0, 0]        5   \n",
       "1336727  B007WTAJTO    [0, 0]        4   \n",
       "1336860  B007WTAJTO    [0, 0]        5   \n",
       "1336864  B007WTAJTO    [0, 0]        5   \n",
       "1336910  B007WTAJTO    [0, 3]        2   \n",
       "1336915  B007WTAJTO    [1, 1]        5   \n",
       "1336966  B007WTAJTO    [0, 0]        4   \n",
       "1337050  B007WTAJTO    [0, 0]        5   \n",
       "1337135  B007WTAJTO    [0, 0]        5   \n",
       "1337161  B007WTAJTO    [0, 0]        5   \n",
       "1337224  B007WTAJTO    [0, 1]        5   \n",
       "1337283  B007WTAJTO    [0, 0]        5   \n",
       "1337289  B007WTAJTO    [0, 1]        3   \n",
       "1337381  B007WTAJTO    [0, 0]        5   \n",
       "1337384  B007WTAJTO    [0, 0]        5   \n",
       "1337401  B007WTAJTO    [0, 0]        5   \n",
       "1337485  B007WTAJTO    [0, 0]        5   \n",
       "1337514  B007WTAJTO    [0, 0]        4   \n",
       "1337521  B007WTAJTO    [0, 0]        5   \n",
       "1337529  B007WTAJTO    [0, 0]        4   \n",
       "1337549  B007WTAJTO    [0, 1]        5   \n",
       "1337551  B007WTAJTO    [0, 0]        5   \n",
       "1337612  B007WTAJTO    [0, 0]        5   \n",
       "1337624  B007WTAJTO    [0, 0]        5   \n",
       "1337705  B007WTAJTO    [0, 0]        4   \n",
       "1337709  B007WTAJTO    [0, 0]        5   \n",
       "1337724  B007WTAJTO    [0, 2]        5   \n",
       "...             ...       ...      ...   \n",
       "1340540  B007WTAJTO    [0, 0]        3   \n",
       "1340590  B007WTAJTO    [0, 0]        5   \n",
       "1340663  B007WTAJTO    [0, 0]        2   \n",
       "1340759  B007WTAJTO    [0, 0]        5   \n",
       "1340769  B007WTAJTO    [0, 0]        5   \n",
       "1340781  B007WTAJTO    [0, 0]        5   \n",
       "1340790  B007WTAJTO    [0, 0]        4   \n",
       "1340809  B007WTAJTO    [0, 0]        5   \n",
       "1340839  B007WTAJTO    [1, 1]        3   \n",
       "1340847  B007WTAJTO    [0, 0]        5   \n",
       "1340916  B007WTAJTO  [14, 16]        5   \n",
       "1340945  B007WTAJTO    [1, 1]        5   \n",
       "1340982  B007WTAJTO    [1, 1]        1   \n",
       "1340984  B007WTAJTO    [0, 0]        5   \n",
       "1341043  B007WTAJTO    [0, 0]        5   \n",
       "1341076  B007WTAJTO    [0, 0]        4   \n",
       "1341112  B007WTAJTO    [0, 0]        5   \n",
       "1341184  B007WTAJTO    [0, 0]        1   \n",
       "1341208  B007WTAJTO    [0, 0]        3   \n",
       "1341240  B007WTAJTO    [0, 0]        5   \n",
       "1341283  B007WTAJTO    [0, 0]        5   \n",
       "1341286  B007WTAJTO  [45, 49]        5   \n",
       "1341302  B007WTAJTO    [0, 0]        5   \n",
       "1341310  B007WTAJTO    [0, 0]        5   \n",
       "1341316  B007WTAJTO    [0, 0]        5   \n",
       "1341326  B007WTAJTO    [0, 0]        5   \n",
       "1341341  B007WTAJTO    [2, 2]        3   \n",
       "1341400  B007WTAJTO    [0, 0]        3   \n",
       "1341473  B007WTAJTO    [0, 0]        5   \n",
       "1341506  B007WTAJTO    [0, 1]        1   \n",
       "\n",
       "                                                reviewText   reviewTime  \\\n",
       "1336624  I like this SD Card because it can take music ...  05 11, 2013   \n",
       "1336670  Used in my phone it's plenty fast and works ju...   11 5, 2013   \n",
       "1336674  You'll pay $10 more for these anywhere else. I...  02 12, 2014   \n",
       "1336699  Lot of questions about this memory card fittin...  02 17, 2014   \n",
       "1336727  I bought this for my son's tablet for cartoon ...  04 12, 2013   \n",
       "1336860  I use this in my Samsung Galaxy Note II. For t...  05 30, 2013   \n",
       "1336864  I wasn't absolutely certain if this would work...  04 27, 2013   \n",
       "1336910  Thus microSD card worked fine for a year in my...  04 28, 2014   \n",
       "1336915  I have this regularly plugged into my ASUS Tra...   09 2, 2013   \n",
       "1336966  I just bought two of these for our two new Sam...   10 4, 2013   \n",
       "1337050  Super fast compared to my other cards. Didn't ...   01 8, 2013   \n",
       "1337135  My Android tablet is a toy; there is nothing c...  06 18, 2014   \n",
       "1337161  We have bought two of these.  You get an open ...  05 12, 2014   \n",
       "1337224  I like to keep track of the &#34;Daily Deals&#...  06 24, 2014   \n",
       "1337283  I'm a music lover and like to carry my entire ...  06 21, 2014   \n",
       "1337289  Picked up this memory card at a great price on...  12 30, 2012   \n",
       "1337381  Perfect for our GoPro.  We haven't &#34;maxed&...  02 25, 2013   \n",
       "1337384  Great card at a great price.  Hard to believe ...   02 9, 2014   \n",
       "1337401  Bought two separately.1) One was a frustration...  01 29, 2014   \n",
       "1337485  I use this card in my 7&#34; iGo GPS. The GPS ...  04 18, 2013   \n",
       "1337514  The micro SD card was extremely fast.  Writing...   07 8, 2013   \n",
       "1337521  I've never had a problem with Sandisk memory p...   07 6, 2014   \n",
       "1337529  I got this to upgrade my surface pro 2's stora...   03 9, 2014   \n",
       "1337549  I am using this to add capacity to my Android ...  05 26, 2013   \n",
       "1337551  I bought one of the 32GB for my Galaxy S4, and...  02 24, 2014   \n",
       "1337612  32 gig MicroSD card that costs less than a dol...  03 11, 2013   \n",
       "1337624  Purchased this along with the Nifty Minidrive ...   07 4, 2014   \n",
       "1337705  Alot of storage for a great price. Only one pr...   01 9, 2014   \n",
       "1337709  I have had cheaper SD Cards in the past, but t...   03 9, 2013   \n",
       "1337724  Purchased this product for a new 7&#34; Garmin...  04 27, 2014   \n",
       "...                                                    ...          ...   \n",
       "1340540  Seemed to work as advertised.  But my first on...   07 2, 2013   \n",
       "1340590  I use this on my small ASUS 10.1&#34; notepad ...  04 10, 2014   \n",
       "1340663  I think I got 8 or 9 months out of this before...  04 15, 2014   \n",
       "1340759  Bought this to expand storage in my Windows 8 ...  03 31, 2014   \n",
       "1340769  I have a long term positive experience using S...  03 19, 2014   \n",
       "1340781  I purchased a Samsung 7&#34; I primarily use a...   03 6, 2014   \n",
       "1340790  i bought this for only one use, to put in my s...   12 6, 2012   \n",
       "1340809  64GB is pretty good size, and in a cell phone,...   01 2, 2013   \n",
       "1340839  had to send it back to SanDisk.  They did repl...  09 29, 2013   \n",
       "1340847  Go two during a &#34;Deal of the Day&#34;. Cou...  01 10, 2014   \n",
       "1340916  So I got this SD specifically for my GoPro Bla...  03 21, 2014   \n",
       "1340945  I have a lot of music (59 GB) and many videos ...  06 10, 2014   \n",
       "1340982  As the title says, the card I got is defective...  03 10, 2014   \n",
       "1340984  I was a bit apprehensive about getting this SD...  04 12, 2014   \n",
       "1341043  I added this SanDisk Ultra 32 GB microSDHC to ...   03 2, 2013   \n",
       "1341076  Sometimes when the price is too low you get le...   01 7, 2014   \n",
       "1341112  Bought this for my HTC Evo 4G LTE, it works gr...  01 10, 2013   \n",
       "1341184  Within an hour of using the memory card, it fa...  01 28, 2013   \n",
       "1341208  When I bought this a year ago, I had problems ...   12 1, 2013   \n",
       "1341240  I'm not sure what else to say other than, &#34...  05 21, 2014   \n",
       "1341283  I think the title says it all. This card is &#...   11 1, 2013   \n",
       "1341286  Sandisk announcement of the first 128GB micro ...   03 7, 2014   \n",
       "1341302  I've used many SanDisk memory cards over the y...  01 31, 2014   \n",
       "1341310  I got the &#34;Ultra&#34; becuase it said it l...   04 3, 2013   \n",
       "1341316  It amazing how much data they can fit on these...  10 17, 2013   \n",
       "1341326  I placed it in my better half's Samsung Galaxy...  11 21, 2013   \n",
       "1341341  Bought this for Samsung Galaxy S3 in Fall 2012...  05 13, 2013   \n",
       "1341400  When I first inserted the card in my computer ...   02 8, 2014   \n",
       "1341473  With the adapter I can easily use it in my cam...  03 24, 2014   \n",
       "1341506  Hello,Great card, great price. Plenty of speed...  12 26, 2013   \n",
       "\n",
       "             reviewerID                            reviewerName  \\\n",
       "1336624  A1RTQROTWR5NCB                               808TREX50   \n",
       "1336670  A1R0JMNRV7HVQM                                     ACZ   \n",
       "1336674   AI1NJ92OUOM2V                           Adam M Barnes   \n",
       "1336699  A16PH8I60IGM4F                      A. GONZALEZ MEDINA   \n",
       "1336727  A1NZR4UN6DJQIO                                  Albert   \n",
       "1336860  A2HY1IGOK2MX5G                         Amazon Customer   \n",
       "1336864  A33M3XQJF4PDE1                         Amazon Customer   \n",
       "1336910  A308JP3BK4VAL7                         Amazon Customer   \n",
       "1336915  A2O8NMK3RVDBAE                         Amazon Customer   \n",
       "1336966  A3SMW7RDCEUJ24             Amazon Customer \"ZundapMan\"   \n",
       "1337050   AWATUDXT8A7TA                           Anthony Nonya   \n",
       "1337135  A3PSG14OAK2A5F                         Badotz \"Badotz\"   \n",
       "1337161  A2L9I233YA2LDM                            B. C. Dunlap   \n",
       "1337224  A1F70KXI4UC60P                             Bill \"Bill\"   \n",
       "1337283  A3ME4OH7OIKNJQ                                Bonemane   \n",
       "1337289  A2Y50SME6VPWYO                         boomer \"Boomer\"   \n",
       "1337381  A308WW1LERDD4Z                                  Brusso   \n",
       "1337384  A1BSQ4J3AOWIZ9                                   Bryan   \n",
       "1337401   ANEKXBM3HB75J                                  Bumqui   \n",
       "1337485  A36LMXZJQFOH4W                              C.B. Stone   \n",
       "1337514  A2ROR47LOES6F5                          Charles C. Moy   \n",
       "1337521  A27IL9J0ZNMTJC                      Charles W. Stewart   \n",
       "1337529  A2OTTBZWWA0U7V                             Chaz Ashley   \n",
       "1337549  A30JLW5XPHUNKA                            chris cooper   \n",
       "1337551  A14Z6D3IRJ23F7                          Chris F \"root\"   \n",
       "1337612    A9YYXQEQ59YQ  Clifton Stuckey \"silver screen votary\"   \n",
       "1337624  A1WKDR87HKTL93                                    Cody   \n",
       "1337705  A10SOO0G3PIJ9L                           Curtis Massey   \n",
       "1337709  A2QC7V9IXJC708                                C. Wells   \n",
       "1337724  A1KOKJZKWWGHBZ               Dale T. Brose \"nascardog\"   \n",
       "...                 ...                                     ...   \n",
       "1340540  A1HB9TA9NA7O3H                              Rodney Cyr   \n",
       "1340590  A35QMY5TQY2HFA                        R. Shehane \"Ron\"   \n",
       "1340663  A1LSFG5FJB9TQ9                  Sandal \"&#34;MFB&#34;\"   \n",
       "1340759   AK37J5GXFGW68                 S. Frainier \"rfrainier\"   \n",
       "1340769  A3JU0TZ23LQVU1                Shaell Rodriguez De Cruz   \n",
       "1340781  A340UTBGHV3ZZN                   Sharon L. \"Sharon L.\"   \n",
       "1340790  A14PJ6GP1GS4TM                            Shawn Fallin   \n",
       "1340809  A1ITFRPPKFD4KP                                 S. Hunt   \n",
       "1340839  A3EZFPA1U61I2G                                 slcpunk   \n",
       "1340847  A1I29V2Y9Q6D3P                                smaruthi   \n",
       "1340916  A2EL2GWJ9T0DWY                               Stayeraug   \n",
       "1340945   AQZWPO4SDYBVD                        Steve \"flixnpix\"   \n",
       "1340982  A37R5M2DJRRWG8                           S-T-R-Y-D-E-R   \n",
       "1340984   ANQYNX4B62RT5                         Stuck in Alaska   \n",
       "1341043  A2PHRC1HCFR8A1                             T. Copeland   \n",
       "1341076  A2O4EDUJ1DDP66       Terrence K. Wraight \"gadgethound\"   \n",
       "1341112  A3TJCU8B44PGS8                                The Frog   \n",
       "1341184   A24Q80R2AB3EO                            T. Narayanan   \n",
       "1341208  A37JYON6897Q2Y                                     Tom   \n",
       "1341240  A211KF6L25L8XV                               Tough Nut   \n",
       "1341283  A2DB3W4GWFLJIA                            twilightstar   \n",
       "1341286  A2DKQQIZ793AV5                                 Twister   \n",
       "1341302  A2QB5EM08KTI1G                               Umpire.20   \n",
       "1341310  A324Q16NTIRFR9            Vanessa Roberts \"Book Lover\"   \n",
       "1341316   AIVU1J51MJ9O2                Vaughn \"The answer man!\"   \n",
       "1341326  A3QIEVO240ZIEJ                           vetteman18361   \n",
       "1341341   A59DOB4UY2K9T                                villapoo   \n",
       "1341400   AR7NZ6M0KDS2M                                Westside   \n",
       "1341473  A21HP6M30Q5PAA                            W.T. HAMPTON   \n",
       "1341506  A2SVI2JSSMA3PS                      Zackariah Zielieke   \n",
       "\n",
       "                                                   summary  unixReviewTime  \n",
       "1336624                                 32GB MicroSD Card.      1368230400  \n",
       "1336670              Works just like it should in my phone      1383609600  \n",
       "1336674                    Great product at a great price.      1392163200  \n",
       "1336699     Works OK with the Samsung Galaxy Tab 3 10.1...      1392595200  \n",
       "1336727                                        Works great      1365724800  \n",
       "1336860                                      Great Quality      1369872000  \n",
       "1336864        Reliable expansion for your MicroSDXC needs      1367020800  \n",
       "1336910   Inadequate life span - lasted 1 year then failed      1398643200  \n",
       "1336915                         Speed, capacity and price!      1378080000  \n",
       "1336966     Probably could have scrimpted and paid less...      1380844800  \n",
       "1337050                                               Fast      1357603200  \n",
       "1337135                My Android tablet is all growed up!      1403049600  \n",
       "1337161                       Bought for Samsung Galaxy S4      1399852800  \n",
       "1337224                 I got it as a \"Daily Deal\" for $30      1403568000  \n",
       "1337283     Upgraded from 64gb to 128gb without any hassle      1403308800  \n",
       "1337289    Great product (if it works in your model phone)      1356825600  \n",
       "1337381                              Perfect for our GoPro      1361750400  \n",
       "1337384                                        great price      1391904000  \n",
       "1337401                                              Works      1390953600  \n",
       "1337485                   Little card holds a lot of stuff      1366243200  \n",
       "1337514                              Very fast memory card      1373241600  \n",
       "1337521                   A great product with no problems      1404604800  \n",
       "1337529                                       Works nicely      1394323200  \n",
       "1337549                                      High capacity      1369526400  \n",
       "1337551             Fast card, very reliable, great price.      1393200000  \n",
       "1337612                                 This thing is fast      1362960000  \n",
       "1337624                  Exactly what I was looking for...      1404432000  \n",
       "1337705                         Great SD card, but........      1389225600  \n",
       "1337709                           You Get What You Pay For      1362787200  \n",
       "1337724                                        Wow wow wow      1398556800  \n",
       "...                                                    ...             ...  \n",
       "1340540            OK, but First One Failed After One Week      1372723200  \n",
       "1340590                                    Good Micro Card      1397088000  \n",
       "1340663                           Great while it lasted...      1397520000  \n",
       "1340759   Nice upgrade for my ASUS Transformer Book T100TA      1396224000  \n",
       "1340769  Speedy, spacious and a great value. Works grea...      1395187200  \n",
       "1340781                                Great little device      1394064000  \n",
       "1340790                               be careful with this      1354752000  \n",
       "1340809                   For the price you can't go wrong      1357084800  \n",
       "1340839                          failed after a few months      1380412800  \n",
       "1340847                        Great card at a great price      1389312000  \n",
       "1340916                        Perfect with GoPro Black 3+      1395360000  \n",
       "1340945                   Perfect for my Samsung Galaxy S5      1402358400  \n",
       "1340982  Sd Card always unexpectedly unmounts and remounts      1394409600  \n",
       "1340984                                       Works great!      1397260800  \n",
       "1341043                                        Works great      1362182400  \n",
       "1341076             I was suspicious with such a low price      1389052800  \n",
       "1341112                       Works great in an Evo 4G LTE      1357776000  \n",
       "1341184                                Don't Buy This CR*P      1359331200  \n",
       "1341208           May not work well in your android device      1385856000  \n",
       "1341240                                              Works      1400630400  \n",
       "1341283                         Super Fast and Works Great      1383264000  \n",
       "1341286  Super high capacity!!!  Excellent price (on Am...      1394150400  \n",
       "1341302               Another Quality Product from SanDisk      1391126400  \n",
       "1341310                                    It seems faster      1364947200  \n",
       "1341316                                       Works great!      1381968000  \n",
       "1341326                                         Good to Go      1384992000  \n",
       "1341341                         Awesome when not defective      1368403200  \n",
       "1341400                  Card not recognized - Bad adapter      1391817600  \n",
       "1341473                                        VERSATILE !      1395619200  \n",
       "1341506         It worked good until return policy was out      1388016000  \n",
       "\n",
       "[135 rows x 9 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Which rows have HTML entities in the reviews for the MicroSD card?\n",
    "most_reviews[most_reviews['reviewText'].str.contains(\"&#34;\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(135, 9)"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "most_reviews[most_reviews['reviewText'].str.contains(\"&#34;\")].shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(0, 9)"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# use an apply function to unescape html entities in the review text\n",
    "from html import unescape\n",
    "unescaper = lambda text: unescape(text)\n",
    "\n",
    "most_reviews['reviewText'] = most_reviews['reviewText'].apply(unescaper)\n",
    "\n",
    "# Verify that it worked by counting the number of rows with &#34; (the HTML entity for \")\n",
    "most_reviews[most_reviews['reviewText'].str.contains(\"&#34;\")].shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(4914, 9)"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Save the file as a CSV \n",
    "most_reviews.to_csv('data/sandisk_sd_card_reviews.csv')\n",
    "most_reviews.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>asin</th>\n",
       "      <th>helpful</th>\n",
       "      <th>overall</th>\n",
       "      <th>reviewText</th>\n",
       "      <th>reviewTime</th>\n",
       "      <th>reviewerID</th>\n",
       "      <th>reviewerName</th>\n",
       "      <th>summary</th>\n",
       "      <th>unixReviewTime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1336614</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>4</td>\n",
       "      <td>No issues.</td>\n",
       "      <td>07 23, 2014</td>\n",
       "      <td>A3SBTW3WS4IQSN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Four Stars</td>\n",
       "      <td>1406073600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1336615</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>5</td>\n",
       "      <td>Purchased this for my device, it worked as adv...</td>\n",
       "      <td>10 25, 2013</td>\n",
       "      <td>A18K1ODH1I2MVB</td>\n",
       "      <td>0mie</td>\n",
       "      <td>MOAR SPACE!!!</td>\n",
       "      <td>1382659200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1336616</th>\n",
       "      <td>B007WTAJTO</td>\n",
       "      <td>[0, 0]</td>\n",
       "      <td>4</td>\n",
       "      <td>it works as expected. I should have sprung for...</td>\n",
       "      <td>12 23, 2012</td>\n",
       "      <td>A2FII3I2MBMUIA</td>\n",
       "      <td>1K3</td>\n",
       "      <td>nothing to really say....</td>\n",
       "      <td>1356220800</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               asin helpful  overall  \\\n",
       "1336614  B007WTAJTO  [0, 0]        4   \n",
       "1336615  B007WTAJTO  [0, 0]        5   \n",
       "1336616  B007WTAJTO  [0, 0]        4   \n",
       "\n",
       "                                                reviewText   reviewTime  \\\n",
       "1336614                                         No issues.  07 23, 2014   \n",
       "1336615  Purchased this for my device, it worked as adv...  10 25, 2013   \n",
       "1336616  it works as expected. I should have sprung for...  12 23, 2012   \n",
       "\n",
       "             reviewerID reviewerName                    summary  \\\n",
       "1336614  A3SBTW3WS4IQSN          NaN                 Four Stars   \n",
       "1336615  A18K1ODH1I2MVB         0mie              MOAR SPACE!!!   \n",
       "1336616  A2FII3I2MBMUIA          1K3  nothing to really say....   \n",
       "\n",
       "         unixReviewTime  \n",
       "1336614      1406073600  \n",
       "1336615      1382659200  \n",
       "1336616      1356220800  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Read the file back in to check that it saved correctly\n",
    "test_df = pd.read_csv('data/sandisk_sd_card_reviews.csv', header=0, index_col=0)\n",
    "test_df.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(4914, 9)"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test_df.shape"
   ]
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}