AmazonReview_draft.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Correlation between Amazon review counts and Google Trends"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "<table style='background-color:transparent;border-style: none;'>\n",
    "\n",
    "    \n",
    "  <tbody>\n",
    "    <tr style='background-color:transparent;border-style: none;'>\n",
    "      <td><img src=\"Images/AirPodsPro.png\" style=\"height: auto; width: 90%;\"></td>\n",
    "      <td><img src=\"Images/Elite75t.png\"  style=\"height: auto; width: 90%;\"></td>\n",
    "     </tr>\n",
    "    <tr style='background-color:transparent;border-style: none;'>\n",
    "      <td><img src=\"Images/SoundcoreLibertyAir2.png\"  style=\"height: auto; width: 90%;\"></td>\n",
    "      <td><img src=\"Images/WF-1000XM3.png\"  style=\"height: auto; width: 90%;\"></td>\n",
    "     </tr>\n",
    "    <tr style='background-color:transparent;border-style: none;'>\n",
    "      <td><img src=\"Images/NC700.png\"  style=\"height: auto; width: 90%;\"></td>\n",
    "     </tr>\n",
    "  </tbody>\n",
    "</table>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Best correlations between products and price segments. "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "![alt text](Images/CorrelationofAmzandGoogleTrend.png \"Title\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "![alt text](Images/Regressionbetweenreviewcountandaveragerating.png \"Title\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Amazon Review Text Analysis"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Here we look at all of the amazon reviews and for each product plot a violin of it's distribution, and order the violins by price from highest on the left to lowest on the right. As we can see reviews are skewed to the high ratings. The chart also shows that the review ratings from those who purchased the product and those who don't are very similar."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<img src=\"Images/violinProductRationDistribution.png\">"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Unique Adjectives Used By Amazon Reviewers"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Using the Natural Language Tool Kit, the reviewer's text parsed into an array of adjectives. Each review was given a ratio of it's usage in relation to the number of reviews for that product. The amazon data set was then separated into 5 star ratings and 1 star ratings. By merging the 1 and 5 star datasets together using an inner join we were able to get the common words we should exclude from the data set. Once we had the intersecting words and the usage ratio, we  the data set was grouped by word and summed the ratios of instances of that word. These words were then sorted by their usage ratio. The Following word cloud shows the top 40 uniquely positive words. From this cloud we can see the adjectives people use to describe the products. Some noticable words are \"lightweight\" \"affordable\" and \"powerful\""
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "![alt text](Top40Words.png \"Title\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "In the table below one can see how the adjectives rank between each product."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<table border=\"1\" class=\"dataframe\">\n",
    "  <thead>\n",
    "    <tr style=\"text-align: right;\">\n",
    "      <th></th>\n",
    "      <th>AirPods Pro_best</th>\n",
    "      <th>Elite 75t_best</th>\n",
    "      <th>Free_best</th>\n",
    "      <th>Galaxy Buds Plus_best</th>\n",
    "      <th>NC700_best</th>\n",
    "      <th>Soundcore Liberty 2 Pro_best</th>\n",
    "      <th>Soundcore Liberty Air 2_best</th>\n",
    "      <th>Soundcore Life Q20_best</th>\n",
    "      <th>WF-1000XM3_best</th>\n",
    "    </tr>\n",
    "  </thead>\n",
    "  <tbody>\n",
    "    <tr>\n",
    "      <th>0</th>\n",
    "      <td>awesome</td>\n",
    "      <td>amazing</td>\n",
    "      <td>little</td>\n",
    "      <td>long</td>\n",
    "      <td>super</td>\n",
    "      <td>different</td>\n",
    "      <td>awesome</td>\n",
    "      <td>little</td>\n",
    "      <td>black</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>1</th>\n",
    "      <td>incredible</td>\n",
    "      <td>awesome</td>\n",
    "      <td>usb</td>\n",
    "      <td>awesome</td>\n",
    "      <td>outstanding</td>\n",
    "      <td>awesome</td>\n",
    "      <td>excellent</td>\n",
    "      <td>awesome</td>\n",
    "      <td>impressed</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>2</th>\n",
    "      <td>true</td>\n",
    "      <td>impressive</td>\n",
    "      <td>perfect</td>\n",
    "      <td>clear</td>\n",
    "      <td>large</td>\n",
    "      <td>overall</td>\n",
    "      <td>overall</td>\n",
    "      <td>solid</td>\n",
    "      <td>android</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>3</th>\n",
    "      <td>top</td>\n",
    "      <td>hearthrough</td>\n",
    "      <td>overall</td>\n",
    "      <td>able</td>\n",
    "      <td>clean</td>\n",
    "      <td>amazing</td>\n",
    "      <td>amazing</td>\n",
    "      <td>expensive</td>\n",
    "      <td>solid</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>4</th>\n",
    "      <td>pleased</td>\n",
    "      <td>passive</td>\n",
    "      <td>expensive</td>\n",
    "      <td>overall</td>\n",
    "      <td>favorite</td>\n",
    "      <td>fantastic</td>\n",
    "      <td>perfect</td>\n",
    "      <td>impressed</td>\n",
    "      <td>helpful</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>5</th>\n",
    "      <td>solid</td>\n",
    "      <td>slight</td>\n",
    "      <td>high</td>\n",
    "      <td>previous</td>\n",
    "      <td>crystal</td>\n",
    "      <td>liberty</td>\n",
    "      <td>fantastic</td>\n",
    "      <td>build</td>\n",
    "      <td>minor</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>6</th>\n",
    "      <td>advertised</td>\n",
    "      <td>light</td>\n",
    "      <td>battery</td>\n",
    "      <td>excellent</td>\n",
    "      <td>pretty</td>\n",
    "      <td>wireless</td>\n",
    "      <td>wireless</td>\n",
    "      <td>battery</td>\n",
    "      <td>strong</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>7</th>\n",
    "      <td>outstanding</td>\n",
    "      <td>crisp</td>\n",
    "      <td>noise</td>\n",
    "      <td>perfect</td>\n",
    "      <td>rich</td>\n",
    "      <td>small</td>\n",
    "      <td>true</td>\n",
    "      <td>own</td>\n",
    "      <td>superior</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>8</th>\n",
    "      <td>everyday</td>\n",
    "      <td>intuitive</td>\n",
    "      <td>impressed</td>\n",
    "      <td>battery</td>\n",
    "      <td>alexa</td>\n",
    "      <td>big</td>\n",
    "      <td>pleased</td>\n",
    "      <td>ambient</td>\n",
    "      <td>convenient</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>9</th>\n",
    "      <td>hear</td>\n",
    "      <td>real</td>\n",
    "      <td>compact</td>\n",
    "      <td>active</td>\n",
    "      <td>phenomenal</td>\n",
    "      <td>incredible</td>\n",
    "      <td>black</td>\n",
    "      <td>incredible</td>\n",
    "      <td>hear</td>\n",
    "    </tr>\n",
    "  </tbody>\n",
    "</table>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The most common unique words in the one star reviews are shown below."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<table border=\"1\" class=\"dataframe\">\n",
    "  <thead>\n",
    "    <tr style=\"text-align: right;\">\n",
    "      <th></th>\n",
    "      <th>AirPods Pro_worst</th>\n",
    "      <th>Elite 75t_worst</th>\n",
    "      <th>Free_worst</th>\n",
    "      <th>Galaxy Buds Plus_worst</th>\n",
    "      <th>NC700_worst</th>\n",
    "      <th>Soundcore Liberty 2 Pro_worst</th>\n",
    "      <th>Soundcore Liberty Air 2_worst</th>\n",
    "      <th>Soundcore Life Q20_worst</th>\n",
    "      <th>WF-1000XM3_worst</th>\n",
    "    </tr>\n",
    "  </thead>\n",
    "  <tbody>\n",
    "    <tr>\n",
    "      <th>0</th>\n",
    "      <td>empty</td>\n",
    "      <td>disappointing</td>\n",
    "      <td>horrible</td>\n",
    "      <td>videos</td>\n",
    "      <td>unacceptable</td>\n",
    "      <td>add</td>\n",
    "      <td>user</td>\n",
    "      <td>unable</td>\n",
    "      <td>defective</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>1</th>\n",
    "      <td>disappointing</td>\n",
    "      <td>white</td>\n",
    "      <td>unable</td>\n",
    "      <td>algo</td>\n",
    "      <td>disappointing</td>\n",
    "      <td>galaxy</td>\n",
    "      <td>finicky</td>\n",
    "      <td>unusable</td>\n",
    "      <td>unusable</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>2</th>\n",
    "      <td>impossible</td>\n",
    "      <td>horrible</td>\n",
    "      <td>stop</td>\n",
    "      <td>sonido</td>\n",
    "      <td>defective</td>\n",
    "      <td>unchanged</td>\n",
    "      <td>awful</td>\n",
    "      <td>worked</td>\n",
    "      <td>weak</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>3</th>\n",
    "      <td>unbearable</td>\n",
    "      <td>unable</td>\n",
    "      <td>spotty</td>\n",
    "      <td>pair</td>\n",
    "      <td>unable</td>\n",
    "      <td>unable</td>\n",
    "      <td>basic</td>\n",
    "      <td>likely</td>\n",
    "      <td>worthless</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>4</th>\n",
    "      <td>numerous</td>\n",
    "      <td>dead</td>\n",
    "      <td>alive</td>\n",
    "      <td>panasonic</td>\n",
    "      <td>serious</td>\n",
    "      <td>purple</td>\n",
    "      <td>unacceptable</td>\n",
    "      <td>useless</td>\n",
    "      <td>youtube</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>5</th>\n",
    "      <td>unable</td>\n",
    "      <td>sudden</td>\n",
    "      <td>scant</td>\n",
    "      <td>pasa</td>\n",
    "      <td>frequent</td>\n",
    "      <td>professiinal</td>\n",
    "      <td>tech</td>\n",
    "      <td>amplified</td>\n",
    "      <td>unacceptable</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>6</th>\n",
    "      <td>existent</td>\n",
    "      <td>rid</td>\n",
    "      <td>oversized</td>\n",
    "      <td>popular</td>\n",
    "      <td>loyal</td>\n",
    "      <td>precautionary</td>\n",
    "      <td>afterwhich</td>\n",
    "      <td>percussive</td>\n",
    "      <td>audible</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>7</th>\n",
    "      <td>visible</td>\n",
    "      <td>unacceptable</td>\n",
    "      <td>pairs</td>\n",
    "      <td>present</td>\n",
    "      <td>tech</td>\n",
    "      <td>ocean</td>\n",
    "      <td>post</td>\n",
    "      <td>se</td>\n",
    "      <td>re</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>8</th>\n",
    "      <td>firmware</td>\n",
    "      <td>sad</td>\n",
    "      <td>paypal</td>\n",
    "      <td>purist</td>\n",
    "      <td>frustrating</td>\n",
    "      <td>nasty</td>\n",
    "      <td>spent</td>\n",
    "      <td>read</td>\n",
    "      <td>friendly</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>9</th>\n",
    "      <td>willing</td>\n",
    "      <td>unfortunate</td>\n",
    "      <td>potential</td>\n",
    "      <td>qi</td>\n",
    "      <td>horrendous</td>\n",
    "      <td>muted</td>\n",
    "      <td>scratched</td>\n",
    "      <td>petite</td>\n",
    "      <td>unintelligible</td>\n",
    "    </tr>\n",
    "  </tbody>\n",
    "</table>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Most Used Word Pairs "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "To generate word pairs we did a similar processes as was done with the adjectives. Using NTLK, we parsed each review into an array of words. We performed used a feature from NTLK called \"stemming\" on each word in an attempt to get it's root. This was done to help join similar words such as \"cancel\" and \"cancelling.\" With this new array we created a loop over all of the words in the review to get every two words into a set of pairs. Once we had the set of pairs we could perform a ratio of their usage for each product, group the pairs and sort by the sum of their ratios. This created the top 10 pairs as shown in the following table. "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Most used pairs for positive reviews."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "In the following list we can see the terms people used to "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Word Pairs"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<p>Word pairs were filtered through NTLK stemming function in an attempt to help find root words. We sorted the pairs by their usage ratio for each product and took the top 10 most used pairs from the 5 star reviews.</p> \n",
    "\n",
    "<p>As we can see in the list, there are the obvious features like sound quality of the headphones and comfort, but also a few less obvious features such as \"wireless\", \"App\", \"wireless charging\", and battery life, and touch controls. </p>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<table border=\"1\" class=\"dataframe\">\n",
    "  <thead>\n",
    "    <tr style=\"text-align: right;\">\n",
    "      <th></th>\n",
    "      <th>AirPods Pro_best</th>\n",
    "      <th>Elite 75t_best</th>\n",
    "      <th>Free_best</th>\n",
    "      <th>Galaxy Buds Plus_best</th>\n",
    "      <th>NC700_best</th>\n",
    "      <th>Soundcore Liberty 2 Pro_best</th>\n",
    "      <th>Soundcore Liberty Air 2_best</th>\n",
    "      <th>Soundcore Life Q20_best</th>\n",
    "      <th>WF-1000XM3_best</th>\n",
    "    </tr>\n",
    "  </thead>\n",
    "  <tbody>\n",
    "    <tr>\n",
    "      <th>0</th>\n",
    "      <td>(product, great)</td>\n",
    "        <td><b>(truli, wireless)</b></td>\n",
    "      <td>(so, far)</td>\n",
    "      <td>(ambient, sound)</td>\n",
    "      <td><b>(control, touch)</b></td>\n",
    "      <td>(in, ear)</td>\n",
    "      <td>(as, well)</td>\n",
    "      <td>(as, good)</td>\n",
    "        <td><b>(connect, app)</b></td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>1</th>\n",
    "      <td>(amaz, sound)</td>\n",
    "      <td>(so, far)</td>\n",
    "        <td><b>(usb, c)</b></td>\n",
    "      <td>(call, qualiti)</td>\n",
    "        <td>(veri, comfort)</td>\n",
    "      <td>(ear, your)</td>\n",
    "      <td><b>(charg, wireless)</b></td>\n",
    "      <td>(so, far)</td>\n",
    "      <td>(as, far)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>2</th>\n",
    "      <td>(qualiti, great)</td>\n",
    "      <td>(good, realli)</td>\n",
    "      <td>(qualiti, great)</td>\n",
    "      <td>(pro, airpod)</td>\n",
    "      <td>(bose, sound)</td>\n",
    "      <td>(earbud, wireless)</td>\n",
    "      <td>(pro, airpod)</td>\n",
    "      <td>(price, great)</td>\n",
    "      <td>(that, headphon)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>3</th>\n",
    "      <td>(great, fit)</td>\n",
    "      <td>(recommend, highli)</td>\n",
    "      <td>(as, good)</td>\n",
    "      <td>(so, far)</td>\n",
    "      <td><b>(out, block)</b></td>\n",
    "      <td>(amaz, sound)</td>\n",
    "      <td>(recommend, highli)</td>\n",
    "        <td><b>(last, batteri)</b></td>\n",
    "      <td>(product, great)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>4</th>\n",
    "      <td>(love, he)</td>\n",
    "      <td>(in, app)</td>\n",
    "      <td>(good, realli)</td>\n",
    "        <td><b>(earbud, wireless)</b></td>\n",
    "      <td>(nois, level)</td>\n",
    "      <td>(in, your)</td>\n",
    "      <td>(product, great)</td>\n",
    "      <td>(price, at)</td>\n",
    "      <td>(best, earbud)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>5</th>\n",
    "        <td><b>(earbud, wireless)</b></td>\n",
    "      <td>(qualiti, great)</td>\n",
    "      <td>(recommend, highli)</td>\n",
    "      <td>(qualiti, great)</td>\n",
    "      <td>(veri, well)</td>\n",
    "      <td>(veri, good)</td>\n",
    "      <td>(good, realli)</td>\n",
    "        <td><b>(bass, boost)</b></td>\n",
    "      <td>(easi, use)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>6</th>\n",
    "      <td>(worth, well)</td>\n",
    "      <td>(galaxi, bud)</td>\n",
    "      <td>(product, great)</td>\n",
    "      <td>(day, all)</td>\n",
    "      <td>(veri, nice)</td>\n",
    "      <td>(listen, music)</td>\n",
    "        <td><b>(wireless, true)</b></td>\n",
    "      <td>(nois, good)</td>\n",
    "      <td>(galaxi, bud)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>7</th>\n",
    "      <td>(worth, definit)</td>\n",
    "      <td>(high, mid)</td>\n",
    "      <td>(free, earfun)</td>\n",
    "      <td>(ear, your)</td>\n",
    "      <td>(veri, happi)</td>\n",
    "      <td>(case, charg)</td>\n",
    "      <td>(better, sound)</td>\n",
    "      <td>(product, great)</td>\n",
    "      <td>(so, good)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>8</th>\n",
    "      <td>(like, realli)</td>\n",
    "      <td>(through, featur)</td>\n",
    "        <td><b>(last, batteri)</b></td>\n",
    "      <td>(listen, music)</td>\n",
    "      <td>(high, end)</td>\n",
    "      <td>(best, sound)</td>\n",
    "        <td><b>(control, touch)</b></td>\n",
    "      <td>(set, headphon)</td>\n",
    "      <td>(nois, level)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>9</th>\n",
    "      <td>(worth, everi)</td>\n",
    "      <td>(secur, fit)</td>\n",
    "      <td>(good, sound)</td>\n",
    "      <td>(better, much)</td>\n",
    "      <td>(clear, crystal)</td>\n",
    "      <td>(phone, call)</td>\n",
    "      <td>(first, pair)</td>\n",
    "      <td>(valu, great)</td>\n",
    "      <td>(how, much)</td>\n",
    "    </tr>\n",
    "  </tbody>\n",
    "</table>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The common pairs in the 1 star reviews are in the list below. A few things we can see is that for the Elite 75t, Jabra Support and \"contact Jabra\" was mentioned the a lot. This suggests that reviewers had to contact their tech support. There's not as many interesting phrases in this table, but we can see that many of the products broke or were defective.  "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<table border=\"1\" class=\"dataframe\">\n",
    "  <thead>\n",
    "    <tr style=\"text-align: right;\">\n",
    "      <th></th>\n",
    "      <th>AirPods Pro_worst</th>\n",
    "      <th>Elite 75t_worst</th>\n",
    "      <th>Free_worst</th>\n",
    "      <th>Galaxy Buds Plus_worst</th>\n",
    "      <th>NC700_worst</th>\n",
    "      <th>Soundcore Liberty 2 Pro_worst</th>\n",
    "      <th>Soundcore Liberty Air 2_worst</th>\n",
    "      <th>Soundcore Life Q20_worst</th>\n",
    "      <th>WF-1000XM3_worst</th>\n",
    "    </tr>\n",
    "  </thead>\n",
    "  <tbody>\n",
    "    <tr>\n",
    "      <th>0</th>\n",
    "      <td>(work, doesn)</td>\n",
    "      <td>(support, jabra)</td>\n",
    "      <td>(in, cut)</td>\n",
    "      <td>(left, side)</td>\n",
    "      <td>(disappoint, veri)</td>\n",
    "      <td>(left, bud)</td>\n",
    "      <td>(connect, stay)</td>\n",
    "      <td>(n, c)</td>\n",
    "      <td>(softwar, connect)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>1</th>\n",
    "      <td>(disappoint, extrem)</td>\n",
    "      <td>(would, earbud)</td>\n",
    "      <td>(that, state)</td>\n",
    "      <td>(money, back)</td>\n",
    "      <td>(minut, 10)</td>\n",
    "      <td>(stop, connect)</td>\n",
    "      <td>(won, pair)</td>\n",
    "      <td>(stop, charg)</td>\n",
    "      <td>(disappoint, in)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>2</th>\n",
    "      <td>(tri, everi)</td>\n",
    "      <td>(out, figur)</td>\n",
    "      <td>(stop, one)</td>\n",
    "      <td>(disappoint, so)</td>\n",
    "      <td>(support, technic)</td>\n",
    "      <td>(bud, start)</td>\n",
    "      <td>(when, wa)</td>\n",
    "      <td>(issu, wa)</td>\n",
    "      <td>(nois, no)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>3</th>\n",
    "      <td>(left, airpod)</td>\n",
    "      <td>(contact, jabra)</td>\n",
    "      <td>(would, pair)</td>\n",
    "      <td>(work, one)</td>\n",
    "      <td>(be, return)</td>\n",
    "      <td>(dont, headphon)</td>\n",
    "      <td>(5, 6)</td>\n",
    "      <td>(off, mode)</td>\n",
    "      <td>(want, realli)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>4</th>\n",
    "      <td>(box, wa)</td>\n",
    "      <td>(left, side)</td>\n",
    "      <td>(went, one)</td>\n",
    "      <td>(return, go)</td>\n",
    "      <td>(return, go)</td>\n",
    "      <td>(last, one)</td>\n",
    "      <td>(work, doesn)</td>\n",
    "      <td>(turn, time)</td>\n",
    "      <td>(disappoint, realli)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>5</th>\n",
    "      <td>(hurt, realli)</td>\n",
    "      <td>(work, doesn)</td>\n",
    "      <td>(money, wast)</td>\n",
    "      <td>(back, take)</td>\n",
    "      <td>(no, sound)</td>\n",
    "      <td>(disconnect, no)</td>\n",
    "      <td>(drop, few)</td>\n",
    "      <td>(have, wa)</td>\n",
    "      <td>(again, tri)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>6</th>\n",
    "      <td>(luck, no)</td>\n",
    "      <td>(support, tech)</td>\n",
    "      <td>(turn, tri)</td>\n",
    "      <td>(hear, cannot)</td>\n",
    "      <td>(privaci, polici)</td>\n",
    "      <td>(lack, given)</td>\n",
    "      <td>(time, 50)</td>\n",
    "      <td>(after, week)</td>\n",
    "      <td>(wast, time)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>7</th>\n",
    "      <td>(use, tri)</td>\n",
    "      <td>(simpl, as)</td>\n",
    "      <td>(week, 3)</td>\n",
    "      <td>(beep, your)</td>\n",
    "      <td>(issu, all)</td>\n",
    "      <td>(in, what)</td>\n",
    "      <td>(play, onli)</td>\n",
    "      <td>(would, caus)</td>\n",
    "      <td>(would, connect)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>8</th>\n",
    "      <td>(out, pop)</td>\n",
    "      <td>(day, 1)</td>\n",
    "      <td>(return, window)</td>\n",
    "      <td>(work, noth)</td>\n",
    "      <td>(asleep, or)</td>\n",
    "      <td>(email, support)</td>\n",
    "      <td>(told, support)</td>\n",
    "      <td>(everi, ten)</td>\n",
    "      <td>(fix, issu)</td>\n",
    "    </tr>\n",
    "    <tr>\n",
    "      <th>9</th>\n",
    "      <td>(week, two)</td>\n",
    "      <td>(reset, factori)</td>\n",
    "      <td>(work, get)</td>\n",
    "      <td>(trebl, 1)</td>\n",
    "      <td>(unit, replac)</td>\n",
    "      <td>(stop, pair)</td>\n",
    "      <td>(pair, like)</td>\n",
    "      <td>(loud, caus)</td>\n",
    "      <td>(out, fell)</td>\n",
    "    </tr>\n",
    "  </tbody>\n",
    "</table>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}