Amazon prices.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 77,
   "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>Index</th>\n",
       "      <th>ProductName</th>\n",
       "      <th>ScrapeDate</th>\n",
       "      <th>ScrapedIndex</th>\n",
       "      <th>ScrapedIndexTrueRank</th>\n",
       "      <th>CorrectedIndexTrueRank</th>\n",
       "      <th>ScrapedIndexPrice</th>\n",
       "      <th>CorrectedPrice</th>\n",
       "      <th>ScrapedIndexVendor</th>\n",
       "      <th>ScrapedIndexVendorType</th>\n",
       "      <th>BBScrapedPrice</th>\n",
       "      <th>BBVendorType</th>\n",
       "      <th>BBVendor</th>\n",
       "      <th>BBCorrectedPrice</th>\n",
       "      <th>difference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4782</th>\n",
       "      <td>4782</td>\n",
       "      <td>Midea WHS-65LB1 Compact Single Reversible Door...</td>\n",
       "      <td>2016-09-06</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>90.74</td>\n",
       "      <td>123.86</td>\n",
       "      <td>Amazon.com</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>90.74</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>123.86</td>\n",
       "      <td>33.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4646</th>\n",
       "      <td>4646</td>\n",
       "      <td>Masterbuilt 20070910 30-Inch Black Electric Di...</td>\n",
       "      <td>2016-06-26</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>209.99</td>\n",
       "      <td>242.83</td>\n",
       "      <td>Amazon.com</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>209.99</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>242.83</td>\n",
       "      <td>32.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2899</th>\n",
       "      <td>2899</td>\n",
       "      <td>Georgia-Pacific Envision 19880/01 White 2-Ply ...</td>\n",
       "      <td>2016-06-17</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>29</td>\n",
       "      <td>48.13</td>\n",
       "      <td>77.87</td>\n",
       "      <td>Amazon.com</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>48.13</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>77.87</td>\n",
       "      <td>29.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1637</th>\n",
       "      <td>1637</td>\n",
       "      <td>Celestron 127EQ PowerSeeker Telescope</td>\n",
       "      <td>2016-06-17</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>149.95</td>\n",
       "      <td>174.39</td>\n",
       "      <td>Amazon.com</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>149.95</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>174.39</td>\n",
       "      <td>24.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1638</th>\n",
       "      <td>1638</td>\n",
       "      <td>Celestron 127EQ PowerSeeker Telescope</td>\n",
       "      <td>2016-06-17</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>149.95</td>\n",
       "      <td>174.39</td>\n",
       "      <td>iSave</td>\n",
       "      <td>FBA</td>\n",
       "      <td>149.95</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>174.39</td>\n",
       "      <td>24.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3858</th>\n",
       "      <td>3858</td>\n",
       "      <td>Kleenex 50606 Hard Roll Towels, 8 x 600ft, 1 3...</td>\n",
       "      <td>2016-06-15</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>36.99</td>\n",
       "      <td>57.43</td>\n",
       "      <td>Amazon.com</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>36.99</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>57.43</td>\n",
       "      <td>20.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4165</th>\n",
       "      <td>4165</td>\n",
       "      <td>Little Tikes Jump 'n Slide Bouncer</td>\n",
       "      <td>2016-06-16</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>177.50</td>\n",
       "      <td>197.32</td>\n",
       "      <td>Amazon.com</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>177.50</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com in easy-to-o...</td>\n",
       "      <td>197.32</td>\n",
       "      <td>19.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5512</th>\n",
       "      <td>5512</td>\n",
       "      <td>Precious Cat Ultra Premium Clumping Cat Litter</td>\n",
       "      <td>2016-06-08</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>16.49</td>\n",
       "      <td>34.43</td>\n",
       "      <td>Amazon.com</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>16.49</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>34.43</td>\n",
       "      <td>17.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1093</th>\n",
       "      <td>1093</td>\n",
       "      <td>Brawny Pick-A-Size Paper Towels, 24 Giant Rolls</td>\n",
       "      <td>2016-06-21</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>29.99</td>\n",
       "      <td>47.39</td>\n",
       "      <td>Amazon.com</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>29.99</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>47.39</td>\n",
       "      <td>17.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4077</th>\n",
       "      <td>4077</td>\n",
       "      <td>Lifetime 4428 Height Adjustable Folding Utilit...</td>\n",
       "      <td>2016-09-06</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>33.00</td>\n",
       "      <td>49.59</td>\n",
       "      <td>Amazon.com</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>33.00</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>49.59</td>\n",
       "      <td>16.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6588</th>\n",
       "      <td>6588</td>\n",
       "      <td>Taste of the Wild Dry Dog Food</td>\n",
       "      <td>2016-09-02</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>43.99</td>\n",
       "      <td>60.03</td>\n",
       "      <td>Amazon.com</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>43.99</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>60.03</td>\n",
       "      <td>16.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3245</th>\n",
       "      <td>3245</td>\n",
       "      <td>Huggies Snug and Dry Diapers, Size 2, Economy ...</td>\n",
       "      <td>2016-06-26</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>45.99</td>\n",
       "      <td>61.89</td>\n",
       "      <td>Quidsi Retail LLC</td>\n",
       "      <td>FBA</td>\n",
       "      <td>42.99</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com in easy-to-o...</td>\n",
       "      <td>58.89</td>\n",
       "      <td>15.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3252</th>\n",
       "      <td>3252</td>\n",
       "      <td>Huggies Snug and Dry Diapers, Size 4, Economy ...</td>\n",
       "      <td>2016-06-26</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>42.99</td>\n",
       "      <td>58.89</td>\n",
       "      <td>Amazon.com</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>42.99</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com in easy-to-o...</td>\n",
       "      <td>58.89</td>\n",
       "      <td>15.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3243</th>\n",
       "      <td>3243</td>\n",
       "      <td>Huggies Snug and Dry Diapers, Size 2, Economy ...</td>\n",
       "      <td>2016-06-26</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>42.99</td>\n",
       "      <td>58.89</td>\n",
       "      <td>Amazon.com</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>42.99</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com in easy-to-o...</td>\n",
       "      <td>58.89</td>\n",
       "      <td>15.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3254</th>\n",
       "      <td>3254</td>\n",
       "      <td>Huggies Snug and Dry Diapers, Size 4, Economy ...</td>\n",
       "      <td>2016-06-26</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>45.99</td>\n",
       "      <td>61.89</td>\n",
       "      <td>Quidsi Retail LLC</td>\n",
       "      <td>FBA</td>\n",
       "      <td>42.99</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com in easy-to-o...</td>\n",
       "      <td>58.89</td>\n",
       "      <td>15.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6736</th>\n",
       "      <td>6736</td>\n",
       "      <td>ViewSonic VX2452MH 24-Inch LED-Lit LCD Monitor...</td>\n",
       "      <td>2016-06-19</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>149.99</td>\n",
       "      <td>165.39</td>\n",
       "      <td>Amazon.com</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>149.99</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>165.39</td>\n",
       "      <td>15.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5285</th>\n",
       "      <td>5285</td>\n",
       "      <td>Oreck Commercial XL2100RHS 8 Pound Commercial ...</td>\n",
       "      <td>2016-06-14</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>169.99</td>\n",
       "      <td>184.32</td>\n",
       "      <td>Galaxy Vacuum</td>\n",
       "      <td>FBA</td>\n",
       "      <td>168.96</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com in easy-to-o...</td>\n",
       "      <td>183.29</td>\n",
       "      <td>14.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5284</th>\n",
       "      <td>5284</td>\n",
       "      <td>Oreck Commercial XL2100RHS 8 Pound Commercial ...</td>\n",
       "      <td>2016-06-14</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>168.96</td>\n",
       "      <td>183.29</td>\n",
       "      <td>Amazon.com</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>168.96</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com in easy-to-o...</td>\n",
       "      <td>183.29</td>\n",
       "      <td>14.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>748</th>\n",
       "      <td>748</td>\n",
       "      <td>BISSELL 9595A Vacuum with OnePass</td>\n",
       "      <td>2016-06-21</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>77.99</td>\n",
       "      <td>92.30</td>\n",
       "      <td>Amazon.com</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>77.99</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com in easy-to-o...</td>\n",
       "      <td>92.30</td>\n",
       "      <td>14.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6435</th>\n",
       "      <td>6435</td>\n",
       "      <td>Suncast GHW1732 Resin Wicker Trash Hideaway</td>\n",
       "      <td>2016-06-14</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>44.87</td>\n",
       "      <td>58.76</td>\n",
       "      <td>Amazon.com</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>44.87</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>58.76</td>\n",
       "      <td>13.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1865</th>\n",
       "      <td>1865</td>\n",
       "      <td>Dell E2015HV 20-Inch Screen LED-Lit Monitor</td>\n",
       "      <td>2016-08-29</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>118.59</td>\n",
       "      <td>132.43</td>\n",
       "      <td>Less 4 Great Things! NO TAX</td>\n",
       "      <td>FBA</td>\n",
       "      <td>105.99</td>\n",
       "      <td>FBA</td>\n",
       "      <td>Sold by dizzy deals and Fulfilled by Amazon.</td>\n",
       "      <td>119.21</td>\n",
       "      <td>13.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>452</th>\n",
       "      <td>452</td>\n",
       "      <td>Acer G226HQL 21.5-Inch Screen LED Monitor</td>\n",
       "      <td>2016-07-04</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>124.98</td>\n",
       "      <td>138.82</td>\n",
       "      <td>ShopAmerica</td>\n",
       "      <td>FBA</td>\n",
       "      <td>89.99</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>103.64</td>\n",
       "      <td>13.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>801</th>\n",
       "      <td>801</td>\n",
       "      <td>Bai Rainforest Variety Pack, 5 Calories, No Ar...</td>\n",
       "      <td>2016-06-18</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>23.88</td>\n",
       "      <td>37.64</td>\n",
       "      <td>Amazon.com</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>23.88</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>37.64</td>\n",
       "      <td>13.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>443</th>\n",
       "      <td>443</td>\n",
       "      <td>Acer G226HQL 21.5-Inch Screen LED Monitor</td>\n",
       "      <td>2016-07-04</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>89.99</td>\n",
       "      <td>103.64</td>\n",
       "      <td>Amazon.com</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>89.99</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>103.64</td>\n",
       "      <td>13.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>449</th>\n",
       "      <td>449</td>\n",
       "      <td>Acer G226HQL 21.5-Inch Screen LED Monitor</td>\n",
       "      <td>2016-07-04</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>115.90</td>\n",
       "      <td>129.55</td>\n",
       "      <td>E Stars LLC</td>\n",
       "      <td>FBA</td>\n",
       "      <td>89.99</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>103.64</td>\n",
       "      <td>13.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1861</th>\n",
       "      <td>1861</td>\n",
       "      <td>Dell E2015HV 20-Inch Screen LED-Lit Monitor</td>\n",
       "      <td>2016-08-29</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>105.99</td>\n",
       "      <td>119.21</td>\n",
       "      <td>PNR SALES</td>\n",
       "      <td>FBA</td>\n",
       "      <td>105.99</td>\n",
       "      <td>FBA</td>\n",
       "      <td>Sold by dizzy deals and Fulfilled by Amazon.</td>\n",
       "      <td>119.21</td>\n",
       "      <td>13.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1860</th>\n",
       "      <td>1860</td>\n",
       "      <td>Dell E2015HV 20-Inch Screen LED-Lit Monitor</td>\n",
       "      <td>2016-08-29</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>105.99</td>\n",
       "      <td>119.21</td>\n",
       "      <td>dizzy deals</td>\n",
       "      <td>FBA</td>\n",
       "      <td>105.99</td>\n",
       "      <td>FBA</td>\n",
       "      <td>Sold by dizzy deals and Fulfilled by Amazon.</td>\n",
       "      <td>119.21</td>\n",
       "      <td>13.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1862</th>\n",
       "      <td>1862</td>\n",
       "      <td>Dell E2015HV 20-Inch Screen LED-Lit Monitor</td>\n",
       "      <td>2016-08-29</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>105.99</td>\n",
       "      <td>119.21</td>\n",
       "      <td>Greener Sales</td>\n",
       "      <td>FBA</td>\n",
       "      <td>105.99</td>\n",
       "      <td>FBA</td>\n",
       "      <td>Sold by dizzy deals and Fulfilled by Amazon.</td>\n",
       "      <td>119.21</td>\n",
       "      <td>13.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1871</th>\n",
       "      <td>1871</td>\n",
       "      <td>Dell E2015HV 20-Inch Screen LED-Lit Monitor</td>\n",
       "      <td>2016-08-29</td>\n",
       "      <td>17</td>\n",
       "      <td>14</td>\n",
       "      <td>15</td>\n",
       "      <td>179.69</td>\n",
       "      <td>192.91</td>\n",
       "      <td>E Stars LLC</td>\n",
       "      <td>FBA</td>\n",
       "      <td>105.99</td>\n",
       "      <td>FBA</td>\n",
       "      <td>Sold by dizzy deals and Fulfilled by Amazon.</td>\n",
       "      <td>119.21</td>\n",
       "      <td>13.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1864</th>\n",
       "      <td>1864</td>\n",
       "      <td>Dell E2015HV 20-Inch Screen LED-Lit Monitor</td>\n",
       "      <td>2016-08-29</td>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>118.60</td>\n",
       "      <td>131.82</td>\n",
       "      <td>E Stars LLC</td>\n",
       "      <td>FBA</td>\n",
       "      <td>105.99</td>\n",
       "      <td>FBA</td>\n",
       "      <td>Sold by dizzy deals and Fulfilled by Amazon.</td>\n",
       "      <td>119.21</td>\n",
       "      <td>13.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2394</th>\n",
       "      <td>2394</td>\n",
       "      <td>Fiskars Traditional Bypass Pruning Shears</td>\n",
       "      <td>2016-08-30</td>\n",
       "      <td>54</td>\n",
       "      <td>52</td>\n",
       "      <td>53</td>\n",
       "      <td>29.99</td>\n",
       "      <td>29.99</td>\n",
       "      <td>VladiPri</td>\n",
       "      <td>Other</td>\n",
       "      <td>11.79</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>18.63</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2393</th>\n",
       "      <td>2393</td>\n",
       "      <td>Fiskars Traditional Bypass Pruning Shears</td>\n",
       "      <td>2016-08-30</td>\n",
       "      <td>53</td>\n",
       "      <td>51</td>\n",
       "      <td>52</td>\n",
       "      <td>29.73</td>\n",
       "      <td>29.73</td>\n",
       "      <td>VirVentures</td>\n",
       "      <td>Other</td>\n",
       "      <td>11.79</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>18.63</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2392</th>\n",
       "      <td>2392</td>\n",
       "      <td>Fiskars Traditional Bypass Pruning Shears</td>\n",
       "      <td>2016-08-30</td>\n",
       "      <td>52</td>\n",
       "      <td>50</td>\n",
       "      <td>51</td>\n",
       "      <td>29.24</td>\n",
       "      <td>29.24</td>\n",
       "      <td>7GIFTS</td>\n",
       "      <td>Other</td>\n",
       "      <td>11.79</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>18.63</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2414</th>\n",
       "      <td>2414</td>\n",
       "      <td>Fiskars Traditional Bypass Pruning Shears</td>\n",
       "      <td>2016-08-30</td>\n",
       "      <td>73</td>\n",
       "      <td>68</td>\n",
       "      <td>70</td>\n",
       "      <td>38.24</td>\n",
       "      <td>38.24</td>\n",
       "      <td>MEGA Select Shop</td>\n",
       "      <td>Other</td>\n",
       "      <td>11.79</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>18.63</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2416</th>\n",
       "      <td>2416</td>\n",
       "      <td>Fiskars Traditional Bypass Pruning Shears</td>\n",
       "      <td>2016-08-30</td>\n",
       "      <td>84</td>\n",
       "      <td>78</td>\n",
       "      <td>72</td>\n",
       "      <td>38.63</td>\n",
       "      <td>38.63</td>\n",
       "      <td>DDN INC</td>\n",
       "      <td>Other</td>\n",
       "      <td>11.79</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>18.63</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2442</th>\n",
       "      <td>2442</td>\n",
       "      <td>Flowmaster 942443 40 Delta Flow Muffler - 2.25...</td>\n",
       "      <td>2016-06-26</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>97.26</td>\n",
       "      <td>97.26</td>\n",
       "      <td>FORBIDDEN DIESEL PERFORMANCE</td>\n",
       "      <td>Other</td>\n",
       "      <td>97.26</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com in easy-to-o...</td>\n",
       "      <td>107.02</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2431</th>\n",
       "      <td>2431</td>\n",
       "      <td>Flowmaster 942443 40 Delta Flow Muffler - 2.25...</td>\n",
       "      <td>2016-06-26</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>97.26</td>\n",
       "      <td>97.26</td>\n",
       "      <td>WunderCarParts</td>\n",
       "      <td>Other</td>\n",
       "      <td>97.26</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com in easy-to-o...</td>\n",
       "      <td>107.02</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2441</th>\n",
       "      <td>2441</td>\n",
       "      <td>Flowmaster 942443 40 Delta Flow Muffler - 2.25...</td>\n",
       "      <td>2016-06-26</td>\n",
       "      <td>13</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>97.26</td>\n",
       "      <td>97.26</td>\n",
       "      <td>KMJPerformance</td>\n",
       "      <td>Other</td>\n",
       "      <td>97.26</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com in easy-to-o...</td>\n",
       "      <td>107.02</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2440</th>\n",
       "      <td>2440</td>\n",
       "      <td>Flowmaster 942443 40 Delta Flow Muffler - 2.25...</td>\n",
       "      <td>2016-06-26</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>97.26</td>\n",
       "      <td>97.26</td>\n",
       "      <td>The Pep Boys - Manny, Moe, &amp; Jack</td>\n",
       "      <td>Other</td>\n",
       "      <td>97.26</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com in easy-to-o...</td>\n",
       "      <td>107.02</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2439</th>\n",
       "      <td>2439</td>\n",
       "      <td>Flowmaster 942443 40 Delta Flow Muffler - 2.25...</td>\n",
       "      <td>2016-06-26</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>97.26</td>\n",
       "      <td>97.26</td>\n",
       "      <td>Wheel Counter</td>\n",
       "      <td>Other</td>\n",
       "      <td>97.26</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com in easy-to-o...</td>\n",
       "      <td>107.02</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2438</th>\n",
       "      <td>2438</td>\n",
       "      <td>Flowmaster 942443 40 Delta Flow Muffler - 2.25...</td>\n",
       "      <td>2016-06-26</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>97.26</td>\n",
       "      <td>97.26</td>\n",
       "      <td>Zig's Auto</td>\n",
       "      <td>Other</td>\n",
       "      <td>97.26</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com in easy-to-o...</td>\n",
       "      <td>107.02</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2437</th>\n",
       "      <td>2437</td>\n",
       "      <td>Flowmaster 942443 40 Delta Flow Muffler - 2.25...</td>\n",
       "      <td>2016-06-26</td>\n",
       "      <td>9</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>97.26</td>\n",
       "      <td>97.26</td>\n",
       "      <td>UNLIMITED MOTORSPORTS</td>\n",
       "      <td>Other</td>\n",
       "      <td>97.26</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com in easy-to-o...</td>\n",
       "      <td>107.02</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2436</th>\n",
       "      <td>2436</td>\n",
       "      <td>Flowmaster 942443 40 Delta Flow Muffler - 2.25...</td>\n",
       "      <td>2016-06-26</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>97.26</td>\n",
       "      <td>97.26</td>\n",
       "      <td>Everything-Aftermarket</td>\n",
       "      <td>Other</td>\n",
       "      <td>97.26</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com in easy-to-o...</td>\n",
       "      <td>107.02</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2435</th>\n",
       "      <td>2435</td>\n",
       "      <td>Flowmaster 942443 40 Delta Flow Muffler - 2.25...</td>\n",
       "      <td>2016-06-26</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>97.26</td>\n",
       "      <td>97.26</td>\n",
       "      <td>Baxter Auto Parts</td>\n",
       "      <td>Other</td>\n",
       "      <td>97.26</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com in easy-to-o...</td>\n",
       "      <td>107.02</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2434</th>\n",
       "      <td>2434</td>\n",
       "      <td>Flowmaster 942443 40 Delta Flow Muffler - 2.25...</td>\n",
       "      <td>2016-06-26</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>97.26</td>\n",
       "      <td>97.26</td>\n",
       "      <td>Car + Audio</td>\n",
       "      <td>Other</td>\n",
       "      <td>97.26</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com in easy-to-o...</td>\n",
       "      <td>107.02</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2433</th>\n",
       "      <td>2433</td>\n",
       "      <td>Flowmaster 942443 40 Delta Flow Muffler - 2.25...</td>\n",
       "      <td>2016-06-26</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>97.26</td>\n",
       "      <td>97.26</td>\n",
       "      <td>Specialty Truck and Auto</td>\n",
       "      <td>Other</td>\n",
       "      <td>97.26</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com in easy-to-o...</td>\n",
       "      <td>107.02</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2432</th>\n",
       "      <td>2432</td>\n",
       "      <td>Flowmaster 942443 40 Delta Flow Muffler - 2.25...</td>\n",
       "      <td>2016-06-26</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>97.26</td>\n",
       "      <td>97.26</td>\n",
       "      <td>LSX PERFORMANCE</td>\n",
       "      <td>Other</td>\n",
       "      <td>97.26</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com in easy-to-o...</td>\n",
       "      <td>107.02</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2430</th>\n",
       "      <td>2430</td>\n",
       "      <td>Flowmaster 942443 40 Delta Flow Muffler - 2.25...</td>\n",
       "      <td>2016-06-26</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>97.26</td>\n",
       "      <td>97.26</td>\n",
       "      <td>Buy-Less</td>\n",
       "      <td>Other</td>\n",
       "      <td>97.26</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com in easy-to-o...</td>\n",
       "      <td>107.02</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2417</th>\n",
       "      <td>2417</td>\n",
       "      <td>Fiskars Traditional Bypass Pruning Shears</td>\n",
       "      <td>2016-08-30</td>\n",
       "      <td>75</td>\n",
       "      <td>70</td>\n",
       "      <td>73</td>\n",
       "      <td>38.88</td>\n",
       "      <td>38.88</td>\n",
       "      <td>Dream Shops</td>\n",
       "      <td>Other</td>\n",
       "      <td>11.79</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>18.63</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2428</th>\n",
       "      <td>2428</td>\n",
       "      <td>Fitbit One Wireless Activity Plus Sleep Tracke...</td>\n",
       "      <td>2016-06-21</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>99.95</td>\n",
       "      <td>99.95</td>\n",
       "      <td>Eastern Mountain Sports, Inc.</td>\n",
       "      <td>Other</td>\n",
       "      <td>74.99</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>80.01</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2427</th>\n",
       "      <td>2427</td>\n",
       "      <td>Fitbit One Wireless Activity Plus Sleep Tracke...</td>\n",
       "      <td>2016-06-21</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>99.95</td>\n",
       "      <td>99.95</td>\n",
       "      <td>Clever Training</td>\n",
       "      <td>Other</td>\n",
       "      <td>74.99</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>80.01</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2426</th>\n",
       "      <td>2426</td>\n",
       "      <td>Fitbit One Wireless Activity Plus Sleep Tracke...</td>\n",
       "      <td>2016-06-21</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>99.90</td>\n",
       "      <td>99.90</td>\n",
       "      <td>Heart Rate Monitors USA</td>\n",
       "      <td>Other</td>\n",
       "      <td>74.99</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>80.01</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2425</th>\n",
       "      <td>2425</td>\n",
       "      <td>Fitbit One Wireless Activity Plus Sleep Tracke...</td>\n",
       "      <td>2016-06-21</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>99.90</td>\n",
       "      <td>99.90</td>\n",
       "      <td>Heart Rate Monitors USA</td>\n",
       "      <td>Other</td>\n",
       "      <td>74.99</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>80.01</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2424</th>\n",
       "      <td>2424</td>\n",
       "      <td>Fitbit One Wireless Activity Plus Sleep Tracke...</td>\n",
       "      <td>2016-06-21</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>94.95</td>\n",
       "      <td>94.95</td>\n",
       "      <td>Brookstone</td>\n",
       "      <td>Other</td>\n",
       "      <td>74.99</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>80.01</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2422</th>\n",
       "      <td>2422</td>\n",
       "      <td>Fiskars Traditional Bypass Pruning Shears</td>\n",
       "      <td>2016-08-30</td>\n",
       "      <td>80</td>\n",
       "      <td>74</td>\n",
       "      <td>77</td>\n",
       "      <td>39.97</td>\n",
       "      <td>39.97</td>\n",
       "      <td>George Sports</td>\n",
       "      <td>Other</td>\n",
       "      <td>11.79</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>18.63</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2421</th>\n",
       "      <td>2421</td>\n",
       "      <td>Fiskars Traditional Bypass Pruning Shears</td>\n",
       "      <td>2016-08-30</td>\n",
       "      <td>79</td>\n",
       "      <td>73</td>\n",
       "      <td>76</td>\n",
       "      <td>39.64</td>\n",
       "      <td>39.64</td>\n",
       "      <td>TeaBoxes</td>\n",
       "      <td>Other</td>\n",
       "      <td>11.79</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>18.63</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2420</th>\n",
       "      <td>2420</td>\n",
       "      <td>Fiskars Traditional Bypass Pruning Shears</td>\n",
       "      <td>2016-08-30</td>\n",
       "      <td>78</td>\n",
       "      <td>72</td>\n",
       "      <td>75</td>\n",
       "      <td>39.23</td>\n",
       "      <td>39.23</td>\n",
       "      <td>SK Street</td>\n",
       "      <td>Other</td>\n",
       "      <td>11.79</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>18.63</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2419</th>\n",
       "      <td>2419</td>\n",
       "      <td>Fiskars Traditional Bypass Pruning Shears</td>\n",
       "      <td>2016-08-30</td>\n",
       "      <td>77</td>\n",
       "      <td>72</td>\n",
       "      <td>75</td>\n",
       "      <td>39.23</td>\n",
       "      <td>39.23</td>\n",
       "      <td>FleX.</td>\n",
       "      <td>Other</td>\n",
       "      <td>11.79</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>18.63</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2418</th>\n",
       "      <td>2418</td>\n",
       "      <td>Fiskars Traditional Bypass Pruning Shears</td>\n",
       "      <td>2016-08-30</td>\n",
       "      <td>76</td>\n",
       "      <td>71</td>\n",
       "      <td>74</td>\n",
       "      <td>39.09</td>\n",
       "      <td>39.09</td>\n",
       "      <td>Ghaziman</td>\n",
       "      <td>Other</td>\n",
       "      <td>11.79</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>18.63</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6972</th>\n",
       "      <td>6972</td>\n",
       "      <td>myBaby SoundSpa Portable</td>\n",
       "      <td>2016-08-30</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>39.99</td>\n",
       "      <td>39.99</td>\n",
       "      <td>discount showcase</td>\n",
       "      <td>Other</td>\n",
       "      <td>19.99</td>\n",
       "      <td>Amazon</td>\n",
       "      <td>Ships from and sold by Amazon.com.</td>\n",
       "      <td>26.77</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6973 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Index                                        ProductName  ScrapeDate  \\\n",
       "4782   4782  Midea WHS-65LB1 Compact Single Reversible Door...  2016-09-06   \n",
       "4646   4646  Masterbuilt 20070910 30-Inch Black Electric Di...  2016-06-26   \n",
       "2899   2899  Georgia-Pacific Envision 19880/01 White 2-Ply ...  2016-06-17   \n",
       "1637   1637              Celestron 127EQ PowerSeeker Telescope  2016-06-17   \n",
       "1638   1638              Celestron 127EQ PowerSeeker Telescope  2016-06-17   \n",
       "3858   3858  Kleenex 50606 Hard Roll Towels, 8 x 600ft, 1 3...  2016-06-15   \n",
       "4165   4165                 Little Tikes Jump 'n Slide Bouncer  2016-06-16   \n",
       "5512   5512     Precious Cat Ultra Premium Clumping Cat Litter  2016-06-08   \n",
       "1093   1093    Brawny Pick-A-Size Paper Towels, 24 Giant Rolls  2016-06-21   \n",
       "4077   4077  Lifetime 4428 Height Adjustable Folding Utilit...  2016-09-06   \n",
       "6588   6588                     Taste of the Wild Dry Dog Food  2016-09-02   \n",
       "3245   3245  Huggies Snug and Dry Diapers, Size 2, Economy ...  2016-06-26   \n",
       "3252   3252  Huggies Snug and Dry Diapers, Size 4, Economy ...  2016-06-26   \n",
       "3243   3243  Huggies Snug and Dry Diapers, Size 2, Economy ...  2016-06-26   \n",
       "3254   3254  Huggies Snug and Dry Diapers, Size 4, Economy ...  2016-06-26   \n",
       "6736   6736  ViewSonic VX2452MH 24-Inch LED-Lit LCD Monitor...  2016-06-19   \n",
       "5285   5285  Oreck Commercial XL2100RHS 8 Pound Commercial ...  2016-06-14   \n",
       "5284   5284  Oreck Commercial XL2100RHS 8 Pound Commercial ...  2016-06-14   \n",
       "748     748                  BISSELL 9595A Vacuum with OnePass  2016-06-21   \n",
       "6435   6435        Suncast GHW1732 Resin Wicker Trash Hideaway  2016-06-14   \n",
       "1865   1865        Dell E2015HV 20-Inch Screen LED-Lit Monitor  2016-08-29   \n",
       "452     452          Acer G226HQL 21.5-Inch Screen LED Monitor  2016-07-04   \n",
       "801     801  Bai Rainforest Variety Pack, 5 Calories, No Ar...  2016-06-18   \n",
       "443     443          Acer G226HQL 21.5-Inch Screen LED Monitor  2016-07-04   \n",
       "449     449          Acer G226HQL 21.5-Inch Screen LED Monitor  2016-07-04   \n",
       "1861   1861        Dell E2015HV 20-Inch Screen LED-Lit Monitor  2016-08-29   \n",
       "1860   1860        Dell E2015HV 20-Inch Screen LED-Lit Monitor  2016-08-29   \n",
       "1862   1862        Dell E2015HV 20-Inch Screen LED-Lit Monitor  2016-08-29   \n",
       "1871   1871        Dell E2015HV 20-Inch Screen LED-Lit Monitor  2016-08-29   \n",
       "1864   1864        Dell E2015HV 20-Inch Screen LED-Lit Monitor  2016-08-29   \n",
       "...     ...                                                ...         ...   \n",
       "2394   2394          Fiskars Traditional Bypass Pruning Shears  2016-08-30   \n",
       "2393   2393          Fiskars Traditional Bypass Pruning Shears  2016-08-30   \n",
       "2392   2392          Fiskars Traditional Bypass Pruning Shears  2016-08-30   \n",
       "2414   2414          Fiskars Traditional Bypass Pruning Shears  2016-08-30   \n",
       "2416   2416          Fiskars Traditional Bypass Pruning Shears  2016-08-30   \n",
       "2442   2442  Flowmaster 942443 40 Delta Flow Muffler - 2.25...  2016-06-26   \n",
       "2431   2431  Flowmaster 942443 40 Delta Flow Muffler - 2.25...  2016-06-26   \n",
       "2441   2441  Flowmaster 942443 40 Delta Flow Muffler - 2.25...  2016-06-26   \n",
       "2440   2440  Flowmaster 942443 40 Delta Flow Muffler - 2.25...  2016-06-26   \n",
       "2439   2439  Flowmaster 942443 40 Delta Flow Muffler - 2.25...  2016-06-26   \n",
       "2438   2438  Flowmaster 942443 40 Delta Flow Muffler - 2.25...  2016-06-26   \n",
       "2437   2437  Flowmaster 942443 40 Delta Flow Muffler - 2.25...  2016-06-26   \n",
       "2436   2436  Flowmaster 942443 40 Delta Flow Muffler - 2.25...  2016-06-26   \n",
       "2435   2435  Flowmaster 942443 40 Delta Flow Muffler - 2.25...  2016-06-26   \n",
       "2434   2434  Flowmaster 942443 40 Delta Flow Muffler - 2.25...  2016-06-26   \n",
       "2433   2433  Flowmaster 942443 40 Delta Flow Muffler - 2.25...  2016-06-26   \n",
       "2432   2432  Flowmaster 942443 40 Delta Flow Muffler - 2.25...  2016-06-26   \n",
       "2430   2430  Flowmaster 942443 40 Delta Flow Muffler - 2.25...  2016-06-26   \n",
       "2417   2417          Fiskars Traditional Bypass Pruning Shears  2016-08-30   \n",
       "2428   2428  Fitbit One Wireless Activity Plus Sleep Tracke...  2016-06-21   \n",
       "2427   2427  Fitbit One Wireless Activity Plus Sleep Tracke...  2016-06-21   \n",
       "2426   2426  Fitbit One Wireless Activity Plus Sleep Tracke...  2016-06-21   \n",
       "2425   2425  Fitbit One Wireless Activity Plus Sleep Tracke...  2016-06-21   \n",
       "2424   2424  Fitbit One Wireless Activity Plus Sleep Tracke...  2016-06-21   \n",
       "2422   2422          Fiskars Traditional Bypass Pruning Shears  2016-08-30   \n",
       "2421   2421          Fiskars Traditional Bypass Pruning Shears  2016-08-30   \n",
       "2420   2420          Fiskars Traditional Bypass Pruning Shears  2016-08-30   \n",
       "2419   2419          Fiskars Traditional Bypass Pruning Shears  2016-08-30   \n",
       "2418   2418          Fiskars Traditional Bypass Pruning Shears  2016-08-30   \n",
       "6972   6972                           myBaby SoundSpa Portable  2016-08-30   \n",
       "\n",
       "      ScrapedIndex  ScrapedIndexTrueRank  CorrectedIndexTrueRank  \\\n",
       "4782             2                     2                       8   \n",
       "4646             1                     1                       3   \n",
       "2899             3                     3                      29   \n",
       "1637             1                     1                       4   \n",
       "1638             2                     1                       4   \n",
       "3858             1                     1                      22   \n",
       "4165             1                     1                       1   \n",
       "5512             1                     1                       3   \n",
       "1093             1                     1                       8   \n",
       "4077             1                     1                      18   \n",
       "6588             2                     2                       4   \n",
       "3245             2                     2                       4   \n",
       "3252             1                     1                       2   \n",
       "3243             1                     1                       2   \n",
       "3254             2                     2                       4   \n",
       "6736             1                     1                       4   \n",
       "5285             8                     3                       3   \n",
       "5284             7                     2                       2   \n",
       "748              9                     5                       5   \n",
       "6435             1                     1                      24   \n",
       "1865            10                     8                      10   \n",
       "452              7                     7                      10   \n",
       "801              1                     1                       5   \n",
       "443              1                     1                       1   \n",
       "449              2                     2                       7   \n",
       "1861             6                     5                       7   \n",
       "1860             5                     5                       7   \n",
       "1862             7                     5                       7   \n",
       "1871            17                    14                      15   \n",
       "1864            11                     9                       9   \n",
       "...            ...                   ...                     ...   \n",
       "2394            54                    52                      53   \n",
       "2393            53                    51                      52   \n",
       "2392            52                    50                      51   \n",
       "2414            73                    68                      70   \n",
       "2416            84                    78                      72   \n",
       "2442            14                     2                       1   \n",
       "2431             3                     2                       1   \n",
       "2441            13                     2                       1   \n",
       "2440            12                     2                       1   \n",
       "2439            11                     2                       1   \n",
       "2438            10                     2                       1   \n",
       "2437             9                     2                       1   \n",
       "2436             8                     2                       1   \n",
       "2435             7                     2                       1   \n",
       "2434             6                     2                       1   \n",
       "2433             5                     2                       1   \n",
       "2432             4                     2                       1   \n",
       "2430             2                     2                       1   \n",
       "2417            75                    70                      73   \n",
       "2428             7                     5                       4   \n",
       "2427             6                     5                       4   \n",
       "2426             4                     3                       3   \n",
       "2425             3                     3                       3   \n",
       "2424             2                     2                       2   \n",
       "2422            80                    74                      77   \n",
       "2421            79                    73                      76   \n",
       "2420            78                    72                      75   \n",
       "2419            77                    72                      75   \n",
       "2418            76                    71                      74   \n",
       "6972            14                    14                      14   \n",
       "\n",
       "      ScrapedIndexPrice  CorrectedPrice                 ScrapedIndexVendor  \\\n",
       "4782              90.74          123.86                         Amazon.com   \n",
       "4646             209.99          242.83                         Amazon.com   \n",
       "2899              48.13           77.87                         Amazon.com   \n",
       "1637             149.95          174.39                         Amazon.com   \n",
       "1638             149.95          174.39                              iSave   \n",
       "3858              36.99           57.43                         Amazon.com   \n",
       "4165             177.50          197.32                         Amazon.com   \n",
       "5512              16.49           34.43                         Amazon.com   \n",
       "1093              29.99           47.39                         Amazon.com   \n",
       "4077              33.00           49.59                         Amazon.com   \n",
       "6588              43.99           60.03                         Amazon.com   \n",
       "3245              45.99           61.89                  Quidsi Retail LLC   \n",
       "3252              42.99           58.89                         Amazon.com   \n",
       "3243              42.99           58.89                         Amazon.com   \n",
       "3254              45.99           61.89                  Quidsi Retail LLC   \n",
       "6736             149.99          165.39                         Amazon.com   \n",
       "5285             169.99          184.32                      Galaxy Vacuum   \n",
       "5284             168.96          183.29                         Amazon.com   \n",
       "748               77.99           92.30                         Amazon.com   \n",
       "6435              44.87           58.76                         Amazon.com   \n",
       "1865             118.59          132.43        Less 4 Great Things! NO TAX   \n",
       "452              124.98          138.82                        ShopAmerica   \n",
       "801               23.88           37.64                         Amazon.com   \n",
       "443               89.99          103.64                         Amazon.com   \n",
       "449              115.90          129.55                        E Stars LLC   \n",
       "1861             105.99          119.21                          PNR SALES   \n",
       "1860             105.99          119.21                        dizzy deals   \n",
       "1862             105.99          119.21                      Greener Sales   \n",
       "1871             179.69          192.91                        E Stars LLC   \n",
       "1864             118.60          131.82                        E Stars LLC   \n",
       "...                 ...             ...                                ...   \n",
       "2394              29.99           29.99                           VladiPri   \n",
       "2393              29.73           29.73                        VirVentures   \n",
       "2392              29.24           29.24                             7GIFTS   \n",
       "2414              38.24           38.24                   MEGA Select Shop   \n",
       "2416              38.63           38.63                            DDN INC   \n",
       "2442              97.26           97.26       FORBIDDEN DIESEL PERFORMANCE   \n",
       "2431              97.26           97.26                     WunderCarParts   \n",
       "2441              97.26           97.26                     KMJPerformance   \n",
       "2440              97.26           97.26  The Pep Boys - Manny, Moe, & Jack   \n",
       "2439              97.26           97.26                      Wheel Counter   \n",
       "2438              97.26           97.26                         Zig's Auto   \n",
       "2437              97.26           97.26              UNLIMITED MOTORSPORTS   \n",
       "2436              97.26           97.26             Everything-Aftermarket   \n",
       "2435              97.26           97.26                  Baxter Auto Parts   \n",
       "2434              97.26           97.26                        Car + Audio   \n",
       "2433              97.26           97.26           Specialty Truck and Auto   \n",
       "2432              97.26           97.26                    LSX PERFORMANCE   \n",
       "2430              97.26           97.26                           Buy-Less   \n",
       "2417              38.88           38.88                        Dream Shops   \n",
       "2428              99.95           99.95      Eastern Mountain Sports, Inc.   \n",
       "2427              99.95           99.95                    Clever Training   \n",
       "2426              99.90           99.90            Heart Rate Monitors USA   \n",
       "2425              99.90           99.90            Heart Rate Monitors USA   \n",
       "2424              94.95           94.95                         Brookstone   \n",
       "2422              39.97           39.97                      George Sports   \n",
       "2421              39.64           39.64                           TeaBoxes   \n",
       "2420              39.23           39.23                          SK Street   \n",
       "2419              39.23           39.23                              FleX.   \n",
       "2418              39.09           39.09                           Ghaziman   \n",
       "6972              39.99           39.99                  discount showcase   \n",
       "\n",
       "     ScrapedIndexVendorType  BBScrapedPrice BBVendorType  \\\n",
       "4782                 Amazon           90.74       Amazon   \n",
       "4646                 Amazon          209.99       Amazon   \n",
       "2899                 Amazon           48.13       Amazon   \n",
       "1637                 Amazon          149.95       Amazon   \n",
       "1638                    FBA          149.95       Amazon   \n",
       "3858                 Amazon           36.99       Amazon   \n",
       "4165                 Amazon          177.50       Amazon   \n",
       "5512                 Amazon           16.49       Amazon   \n",
       "1093                 Amazon           29.99       Amazon   \n",
       "4077                 Amazon           33.00       Amazon   \n",
       "6588                 Amazon           43.99       Amazon   \n",
       "3245                    FBA           42.99       Amazon   \n",
       "3252                 Amazon           42.99       Amazon   \n",
       "3243                 Amazon           42.99       Amazon   \n",
       "3254                    FBA           42.99       Amazon   \n",
       "6736                 Amazon          149.99       Amazon   \n",
       "5285                    FBA          168.96       Amazon   \n",
       "5284                 Amazon          168.96       Amazon   \n",
       "748                  Amazon           77.99       Amazon   \n",
       "6435                 Amazon           44.87       Amazon   \n",
       "1865                    FBA          105.99          FBA   \n",
       "452                     FBA           89.99       Amazon   \n",
       "801                  Amazon           23.88       Amazon   \n",
       "443                  Amazon           89.99       Amazon   \n",
       "449                     FBA           89.99       Amazon   \n",
       "1861                    FBA          105.99          FBA   \n",
       "1860                    FBA          105.99          FBA   \n",
       "1862                    FBA          105.99          FBA   \n",
       "1871                    FBA          105.99          FBA   \n",
       "1864                    FBA          105.99          FBA   \n",
       "...                     ...             ...          ...   \n",
       "2394                  Other           11.79       Amazon   \n",
       "2393                  Other           11.79       Amazon   \n",
       "2392                  Other           11.79       Amazon   \n",
       "2414                  Other           11.79       Amazon   \n",
       "2416                  Other           11.79       Amazon   \n",
       "2442                  Other           97.26       Amazon   \n",
       "2431                  Other           97.26       Amazon   \n",
       "2441                  Other           97.26       Amazon   \n",
       "2440                  Other           97.26       Amazon   \n",
       "2439                  Other           97.26       Amazon   \n",
       "2438                  Other           97.26       Amazon   \n",
       "2437                  Other           97.26       Amazon   \n",
       "2436                  Other           97.26       Amazon   \n",
       "2435                  Other           97.26       Amazon   \n",
       "2434                  Other           97.26       Amazon   \n",
       "2433                  Other           97.26       Amazon   \n",
       "2432                  Other           97.26       Amazon   \n",
       "2430                  Other           97.26       Amazon   \n",
       "2417                  Other           11.79       Amazon   \n",
       "2428                  Other           74.99       Amazon   \n",
       "2427                  Other           74.99       Amazon   \n",
       "2426                  Other           74.99       Amazon   \n",
       "2425                  Other           74.99       Amazon   \n",
       "2424                  Other           74.99       Amazon   \n",
       "2422                  Other           11.79       Amazon   \n",
       "2421                  Other           11.79       Amazon   \n",
       "2420                  Other           11.79       Amazon   \n",
       "2419                  Other           11.79       Amazon   \n",
       "2418                  Other           11.79       Amazon   \n",
       "6972                  Other           19.99       Amazon   \n",
       "\n",
       "                                               BBVendor  BBCorrectedPrice  \\\n",
       "4782                 Ships from and sold by Amazon.com.            123.86   \n",
       "4646                 Ships from and sold by Amazon.com.            242.83   \n",
       "2899                 Ships from and sold by Amazon.com.             77.87   \n",
       "1637                 Ships from and sold by Amazon.com.            174.39   \n",
       "1638                 Ships from and sold by Amazon.com.            174.39   \n",
       "3858                 Ships from and sold by Amazon.com.             57.43   \n",
       "4165  Ships from and sold by Amazon.com in easy-to-o...            197.32   \n",
       "5512                 Ships from and sold by Amazon.com.             34.43   \n",
       "1093                 Ships from and sold by Amazon.com.             47.39   \n",
       "4077                 Ships from and sold by Amazon.com.             49.59   \n",
       "6588                 Ships from and sold by Amazon.com.             60.03   \n",
       "3245  Ships from and sold by Amazon.com in easy-to-o...             58.89   \n",
       "3252  Ships from and sold by Amazon.com in easy-to-o...             58.89   \n",
       "3243  Ships from and sold by Amazon.com in easy-to-o...             58.89   \n",
       "3254  Ships from and sold by Amazon.com in easy-to-o...             58.89   \n",
       "6736                 Ships from and sold by Amazon.com.            165.39   \n",
       "5285  Ships from and sold by Amazon.com in easy-to-o...            183.29   \n",
       "5284  Ships from and sold by Amazon.com in easy-to-o...            183.29   \n",
       "748   Ships from and sold by Amazon.com in easy-to-o...             92.30   \n",
       "6435                 Ships from and sold by Amazon.com.             58.76   \n",
       "1865       Sold by dizzy deals and Fulfilled by Amazon.            119.21   \n",
       "452                  Ships from and sold by Amazon.com.            103.64   \n",
       "801                  Ships from and sold by Amazon.com.             37.64   \n",
       "443                  Ships from and sold by Amazon.com.            103.64   \n",
       "449                  Ships from and sold by Amazon.com.            103.64   \n",
       "1861       Sold by dizzy deals and Fulfilled by Amazon.            119.21   \n",
       "1860       Sold by dizzy deals and Fulfilled by Amazon.            119.21   \n",
       "1862       Sold by dizzy deals and Fulfilled by Amazon.            119.21   \n",
       "1871       Sold by dizzy deals and Fulfilled by Amazon.            119.21   \n",
       "1864       Sold by dizzy deals and Fulfilled by Amazon.            119.21   \n",
       "...                                                 ...               ...   \n",
       "2394                 Ships from and sold by Amazon.com.             18.63   \n",
       "2393                 Ships from and sold by Amazon.com.             18.63   \n",
       "2392                 Ships from and sold by Amazon.com.             18.63   \n",
       "2414                 Ships from and sold by Amazon.com.             18.63   \n",
       "2416                 Ships from and sold by Amazon.com.             18.63   \n",
       "2442  Ships from and sold by Amazon.com in easy-to-o...            107.02   \n",
       "2431  Ships from and sold by Amazon.com in easy-to-o...            107.02   \n",
       "2441  Ships from and sold by Amazon.com in easy-to-o...            107.02   \n",
       "2440  Ships from and sold by Amazon.com in easy-to-o...            107.02   \n",
       "2439  Ships from and sold by Amazon.com in easy-to-o...            107.02   \n",
       "2438  Ships from and sold by Amazon.com in easy-to-o...            107.02   \n",
       "2437  Ships from and sold by Amazon.com in easy-to-o...            107.02   \n",
       "2436  Ships from and sold by Amazon.com in easy-to-o...            107.02   \n",
       "2435  Ships from and sold by Amazon.com in easy-to-o...            107.02   \n",
       "2434  Ships from and sold by Amazon.com in easy-to-o...            107.02   \n",
       "2433  Ships from and sold by Amazon.com in easy-to-o...            107.02   \n",
       "2432  Ships from and sold by Amazon.com in easy-to-o...            107.02   \n",
       "2430  Ships from and sold by Amazon.com in easy-to-o...            107.02   \n",
       "2417                 Ships from and sold by Amazon.com.             18.63   \n",
       "2428                 Ships from and sold by Amazon.com.             80.01   \n",
       "2427                 Ships from and sold by Amazon.com.             80.01   \n",
       "2426                 Ships from and sold by Amazon.com.             80.01   \n",
       "2425                 Ships from and sold by Amazon.com.             80.01   \n",
       "2424                 Ships from and sold by Amazon.com.             80.01   \n",
       "2422                 Ships from and sold by Amazon.com.             18.63   \n",
       "2421                 Ships from and sold by Amazon.com.             18.63   \n",
       "2420                 Ships from and sold by Amazon.com.             18.63   \n",
       "2419                 Ships from and sold by Amazon.com.             18.63   \n",
       "2418                 Ships from and sold by Amazon.com.             18.63   \n",
       "6972                 Ships from and sold by Amazon.com.             26.77   \n",
       "\n",
       "      difference  \n",
       "4782       33.12  \n",
       "4646       32.84  \n",
       "2899       29.74  \n",
       "1637       24.44  \n",
       "1638       24.44  \n",
       "3858       20.44  \n",
       "4165       19.82  \n",
       "5512       17.94  \n",
       "1093       17.40  \n",
       "4077       16.59  \n",
       "6588       16.04  \n",
       "3245       15.90  \n",
       "3252       15.90  \n",
       "3243       15.90  \n",
       "3254       15.90  \n",
       "6736       15.40  \n",
       "5285       14.33  \n",
       "5284       14.33  \n",
       "748        14.31  \n",
       "6435       13.89  \n",
       "1865       13.84  \n",
       "452        13.84  \n",
       "801        13.76  \n",
       "443        13.65  \n",
       "449        13.65  \n",
       "1861       13.22  \n",
       "1860       13.22  \n",
       "1862       13.22  \n",
       "1871       13.22  \n",
       "1864       13.22  \n",
       "...          ...  \n",
       "2394        0.00  \n",
       "2393        0.00  \n",
       "2392        0.00  \n",
       "2414        0.00  \n",
       "2416        0.00  \n",
       "2442        0.00  \n",
       "2431        0.00  \n",
       "2441        0.00  \n",
       "2440        0.00  \n",
       "2439        0.00  \n",
       "2438        0.00  \n",
       "2437        0.00  \n",
       "2436        0.00  \n",
       "2435        0.00  \n",
       "2434        0.00  \n",
       "2433        0.00  \n",
       "2432        0.00  \n",
       "2430        0.00  \n",
       "2417        0.00  \n",
       "2428        0.00  \n",
       "2427        0.00  \n",
       "2426        0.00  \n",
       "2425        0.00  \n",
       "2424        0.00  \n",
       "2422        0.00  \n",
       "2421        0.00  \n",
       "2420        0.00  \n",
       "2419        0.00  \n",
       "2418        0.00  \n",
       "6972        0.00  \n",
       "\n",
       "[6973 rows x 15 columns]"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "data = pd.read_csv('09-19-Amazon-Ranking-Analysis.csv')\n",
    "data['difference'] = data.CorrectedPrice - data.ScrapedIndexPrice\n",
    "data.sort_values('difference', ascending=False)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "\n",
    "type = data[['ScrapedIndexVendorType', 'difference']]\n",
    "type.sort_values('difference', ascending=False)\n",
    "amazon = type[(type.ScrapedIndexVendorType == 'Amazon') | (type.ScrapedIndexVendorType == 'FBA')]\n",
    "not_amazon = type[~(type.ScrapedIndexVendorType == 'Amazon') & ~(type.ScrapedIndexVendorType == 'FBA')]\n",
    "amazon.plot.hist(title='Amazon', range=[0,30], facecolor='grey', align='left')\n",
    "plt.xlabel('Price')\n",
    "plt.savefig('amazon.jpg')\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "not_amazon = type[~(type.ScrapedIndexVendorType == 'Amazon') & ~(type.ScrapedIndexVendorType == 'FBA')]\n",
    "not_amazon.plot.hist(title='Third Party', range=[0,30], align='left')\n",
    "plt.xlabel('Price')\n",
    "plt.savefig('thirdparty.jpg')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "7.689267886855246"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_mean = amazon.difference.mean()\n",
    "amazon_mean"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}