load_data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>requirejs.config({paths: { 'plotly': ['https://cdn.plot.ly/plotly-latest.min']},});if(!window.Plotly) {{require(['plotly'],function(plotly) {window.Plotly=plotly;});}}</script>"
      ],
      "text/vnd.plotly.v1+html": [
       "<script>requirejs.config({paths: { 'plotly': ['https://cdn.plot.ly/plotly-latest.min']},});if(!window.Plotly) {{require(['plotly'],function(plotly) {window.Plotly=plotly;});}}</script>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "from PIL import Image\n",
    "import requests\n",
    "from io import BytesIO\n",
    "import matplotlib.pyplot as plt\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import warnings\n",
    "from bs4 import BeautifulSoup\n",
    "from nltk.corpus import stopwords\n",
    "from nltk.tokenize import word_tokenize\n",
    "import nltk\n",
    "import math\n",
    "import time\n",
    "import re \n",
    "import os\n",
    "import seaborn as sns\n",
    "from collections import Counter\n",
    "from sklearn.feature_extraction.text import CountVectorizer\n",
    "from sklearn.feature_extraction.text import TfidfVectorizer\n",
    "from sklearn.metrics.pairwise import cosine_similarity \n",
    "from sklearn.metrics import pairwise_distances\n",
    "from matplotlib import gridspec\n",
    "from scipy.sparse import hstack\n",
    "import plotly\n",
    "import plotly.figure_factory as ff\n",
    "from plotly.graph_objs import Scatter, Layout\n",
    "\n",
    "plotly.offline.init_notebook_mode(connected=True)\n",
    "warnings.filterwarnings(\"ignore\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>asin</th>\n",
       "      <th>author</th>\n",
       "      <th>availability</th>\n",
       "      <th>availability_type</th>\n",
       "      <th>brand</th>\n",
       "      <th>color</th>\n",
       "      <th>editorial_reivew</th>\n",
       "      <th>editorial_review</th>\n",
       "      <th>formatted_price</th>\n",
       "      <th>large_image_url</th>\n",
       "      <th>manufacturer</th>\n",
       "      <th>medium_image_url</th>\n",
       "      <th>model</th>\n",
       "      <th>product_type_name</th>\n",
       "      <th>publisher</th>\n",
       "      <th>reviews</th>\n",
       "      <th>sku</th>\n",
       "      <th>small_image_url</th>\n",
       "      <th>title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>B016I2TS4W</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>FNC7C</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Minions Como Superheroes Ironman Women's O Nec...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Minions Como Superheroes Ironman Long Sleeve R...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>B01N49AI08</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>FIG Clothing</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sizing runs on the small side. FIG® recommends...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>FIG Clothing Womens Izo Tunic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>B01JDPCOHO</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>FIG Clothing</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sizing runs on the small side. FIG® recommends...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>FIG Clothing Womens Won Top</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>B01N19U5H5</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Focal18</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100% Brand New &amp; Fashion&lt;br&gt; Quantity: 1 Piece...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[True, https://www.amazon.com/reviews/iframe?a...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Focal18 Sailor Collar Bubble Sleeve Blouse Shi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>B004GSI2OS</td>\n",
       "      <td>None</td>\n",
       "      <td>Usually ships in 6-10 business days</td>\n",
       "      <td>now</td>\n",
       "      <td>FeatherLite</td>\n",
       "      <td>Onyx Black/ Stone</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "      <td>$26.26</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Featherlite Ladies' Long Sleeve Stain Resistan...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>B00TAEHGGS</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Fitscloth</td>\n",
       "      <td>Grape</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Solid Modern Long Sleeve Tee. Quality Cotton T...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>BL0002</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>[Fits Cloth] Grape Solid Modern Long Sleeve Pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>B012YX2ZPI</td>\n",
       "      <td>None</td>\n",
       "      <td>Usually ships in 4-5 business days</td>\n",
       "      <td>now</td>\n",
       "      <td>HX-Kingdom Fashion T-shirts</td>\n",
       "      <td>White</td>\n",
       "      <td>NaN</td>\n",
       "      <td>This Personalized Special Olympics World Games...</td>\n",
       "      <td>$9.99</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Women's Unique 100% Cotton T - Special Olympic...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>B074GPTP3J</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Floerns</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;strong&gt;Size Chart: &lt;/strong&gt;&lt;br&gt;&lt;br&gt; X-Small:...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[True, https://www.amazon.com/reviews/iframe?a...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Floerns Women's Bell Sleeve Beading Casual Blo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>B06Y2LCC5S</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Fashion2ne1</td>\n",
       "      <td>Black</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Standing on His Promises Bling Bling Rhineston...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Standing on His Promises Rhinestones T-Shirt R...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>B00T9W4E66</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Fila</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Fila Tulip Tank features a sporty design w...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>TW151JE6</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[True, https://www.amazon.com/reviews/iframe?a...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Fila Women's Tulip Durable Tennis Style Comfor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>B073Y91FTS</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Floerns</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;strong&gt;Size Chart: &lt;/strong&gt;&lt;br&gt;&lt;br&gt; &lt;strong&gt;...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[True, https://www.amazon.com/reviews/iframe?a...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Floerns Women's Cold Shoulder Casual Print Ruf...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>B001LOUGE4</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Fitness Etc.</td>\n",
       "      <td>Black</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Light Weight 2x1 Boy Beater Tank Top.  Great t...</td>\n",
       "      <td>$11.99</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Ladies Cotton Tank 2x1 Ribbed Tank Top</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>B0751PWCP7</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>FIFTEEN TWENTY</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fifteen Twenty's Grommet top features long bel...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>3F17090</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Fifteen Twenty Grommet Tie Sleeve Top in Black</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>B0747M995P</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Tee Fashion</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>This Short Sleeve Tee Will Take Your Casual We...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Yellow Women T Shirt,dance Cotton Short Sleeve...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>B01LQAINPG</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Fedi Apparel</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>*Brand Name:&lt;/b&gt; Fedi Apparel &lt;/b&gt;(We are a Re...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Fedi Apparel Womens V-neck Long Sleeve Tops Ca...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>B003BSRPB0</td>\n",
       "      <td>None</td>\n",
       "      <td>Usually ships in 6-10 business days</td>\n",
       "      <td>now</td>\n",
       "      <td>FeatherLite</td>\n",
       "      <td>White</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FeatherLite Ladies' Moisture Free Mesh Sport S...</td>\n",
       "      <td>$20.54</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>HT-2001_Lime-1149-XL</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>FeatherLite Ladies' Moisture Free Mesh Sport S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>B00L3C0O2S</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>FEA Merchandising</td>\n",
       "      <td>Light</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Officially licensed Florida Georgia line tee</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>FEA Juniors</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>2F104</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>FEA Juniors</td>\n",
       "      <td>[True, https://www.amazon.com/reviews/iframe?a...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>FEA Merchandising Juniors Florida Georgia Line...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>B00XIM7A1Y</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>FIFA</td>\n",
       "      <td>Grey</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Show your team pride! This Old Glory design is...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>World Cup USA Heather Grey Juniors Soft Tank Top</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>B06XKGTX6F</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Floerns</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Size Chart: &lt;br&gt; &lt;br&gt; &lt;br&gt;White:&lt;br&gt; Length(in...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[True, https://www.amazon.com/reviews/iframe?a...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Floerns Women's Flower Embroidered Side Slit S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>B01HMCZP80</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Fedi Apparel</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Brand Name: Fedi Apparel(We are a Brand for go...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Fedi Apparel Women Summer Chiffon Blouse Sleev...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>B00XGI2REA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Fight Like a Girl</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Breast cancer survivors and warriors, let canc...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[True, https://www.amazon.com/reviews/iframe?a...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Cancer Messed With Wrong Chick Breast Cancer T...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>B014ICEDNA</td>\n",
       "      <td>None</td>\n",
       "      <td>Usually ships in 4-5 business days</td>\n",
       "      <td>now</td>\n",
       "      <td>FNC7C</td>\n",
       "      <td>Purple</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Supernatural Chibis Sam Dean And Castiel Women...</td>\n",
       "      <td>$7.50</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[True, https://www.amazon.com/reviews/iframe?a...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Supernatural Chibis Sam Dean And Castiel Short...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>B01KKVZM88</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>FDPlus</td>\n",
       "      <td>Black</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MEASUREMENTS &lt;br&gt;1X - Bust (seam to seam) - 22...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Sexy Open Shoulder X Long Soft Shark Hemline W...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>B01N8YY9G1</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Fifth Sun</td>\n",
       "      <td>Purple Heather</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Celebrate your favorite heroes in a half-shell...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Fifth Sun</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>TMNT0013-60077010</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>Fifth Sun</td>\n",
       "      <td>[True, https://www.amazon.com/reviews/iframe?a...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Teenage Mutant Ninja Turtles Group Wave Womens...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>B071FKC36P</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Fifth Parallel Threads</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;br&gt;&lt;b&gt;MEASUREMENTS&lt;/b&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;FPAWTTS025:&lt;...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[True, https://www.amazon.com/reviews/iframe?a...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>FPT Womens Basic Casual Short Sleeve Round Nec...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>B009W1HUG0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Alivila.Y Fashion</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;b&gt;Alivila.Y Fashion Mesh Sequins Long Sleeve ...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SWEATER</td>\n",
       "      <td>None</td>\n",
       "      <td>[True, https://www.amazon.com/reviews/iframe?a...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Alivila.Y Fashion Womens Mesh Sequins Long Sle...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>B073S96HSS</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Fifth Sun</td>\n",
       "      <td>Cancun</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Show everyone your love for the circle of life...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Fifth Sun</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>PXLK0013-60077005</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>Fifth Sun</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Fifth Sun Women's Lion King Hakuna Matata Prin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>B014ICEJ1Q</td>\n",
       "      <td>None</td>\n",
       "      <td>Usually ships in 4-5 business days</td>\n",
       "      <td>now</td>\n",
       "      <td>FNC7C</td>\n",
       "      <td>Purple</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Supernatural Chibis Sam Dean And Castiel Women...</td>\n",
       "      <td>$7.39</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Supernatural Chibis Sam Dean And Castiel O Nec...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>B074DF831N</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Fast &amp; Furious</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Officially Licensed Merchandise. Comes with a ...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Officially Licensed Fast &amp; Furious - Est. 2007...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>B01GE1M4M0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Firebo</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The comfortable, easy-to-wear, soft cotton mak...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Firebo Billy Joel In Concert 2016 Short Sleeve...</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183108</th>\n",
       "      <td>B06WLNR267</td>\n",
       "      <td>None</td>\n",
       "      <td>Usually ships in 6-10 business days</td>\n",
       "      <td>now</td>\n",
       "      <td>Shawhuaa</td>\n",
       "      <td>Rosy</td>\n",
       "      <td>These tank tops are light and breezy comfortab...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$16.99</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Womens Basic Loose Low V Neck Racerback Sport ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183109</th>\n",
       "      <td>B010R8I8NA</td>\n",
       "      <td>None</td>\n",
       "      <td>Usually ships in 1-2 business days</td>\n",
       "      <td>now</td>\n",
       "      <td>GreaterGood</td>\n",
       "      <td>Turquoise</td>\n",
       "      <td>The spirit of freedom comes alive in every thr...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$28.95</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>81627</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Tie Dye Spirit Top</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183110</th>\n",
       "      <td>B073YGRLSM</td>\n",
       "      <td>None</td>\n",
       "      <td>Usually ships in 2-3 business days</td>\n",
       "      <td>now</td>\n",
       "      <td>Sky and Sparrow</td>\n",
       "      <td>Rose</td>\n",
       "      <td>Sky and Sparrow Grommet Lace Up top. Off the s...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$26.99</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Sky and Sparrow</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>30668638102</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>Sky and Sparrow</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>SKY AND SPARROW Grommet Lace Up Top, Rose, Small</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183111</th>\n",
       "      <td>B06XJ24BWH</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Hibluco</td>\n",
       "      <td>None</td>\n",
       "      <td>Hibluco,advocate minimalist fashion brand.&lt;br&gt;...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[True, https://www.amazon.com/reviews/iframe?a...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Hibluco Women's Sexy V-neck Crop Tops Backless...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183112</th>\n",
       "      <td>B06XY2DZCT</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Hatop</td>\n",
       "      <td>Brown</td>\n",
       "      <td>Item specifics &lt;br&gt; Gender:Women &lt;br&gt; Season:S...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Blouse, Hatop Womens Sexy Off Shoulder Irregul...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183113</th>\n",
       "      <td>B01A51IYDI</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Tribal</td>\n",
       "      <td>None</td>\n",
       "      <td>Tribal Sleeveless Pleat Front Blouse</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>10612O</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Tribal Sleeveless Pleat Front Blouse</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183114</th>\n",
       "      <td>B07579G728</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Three Dots</td>\n",
       "      <td>None</td>\n",
       "      <td>This Three Dots Blouse is guaranteed authentic...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Three Dots</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>Three Dots</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Three Dots Womens Gathered Pleated Blouse</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183115</th>\n",
       "      <td>B071D9X1S9</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Studio Works</td>\n",
       "      <td>None</td>\n",
       "      <td>Exclusively ours! Create a sleek, bold style w...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Studio Works Printed Poncho Top</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183116</th>\n",
       "      <td>B0749B51LK</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>YUNY</td>\n",
       "      <td>None</td>\n",
       "      <td>Hi buyer, pls pay attention, pls read our size...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>YUNY Women Casual Denim Patchwork Plaid Shirt ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183117</th>\n",
       "      <td>B01MS41A4S</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Solution Clothing</td>\n",
       "      <td>None</td>\n",
       "      <td>Short Sleeves, Zip Lining, Back Zip, Sexy Shap...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>T7180</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Bangbangusa Women One Golden Star Back Zip Top</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183118</th>\n",
       "      <td>B01LSBZB8A</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Paixpays</td>\n",
       "      <td>None</td>\n",
       "      <td>1.100% brand new and good quality.&lt;br&gt;2.Suitab...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>2008S0192</td>\n",
       "      <td>DRESS</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Women Long Sleeve Denim Blue Casual Shirt Blou...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183119</th>\n",
       "      <td>B06W53LT7P</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>XQS</td>\n",
       "      <td>None</td>\n",
       "      <td>&lt;br&gt;Dear buyer, we are new but grow rapidly, 9...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[True, https://www.amazon.com/reviews/iframe?a...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>XQS Women's Solid Basic Chiffon Casual Shirts ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183120</th>\n",
       "      <td>B01NCO06S0</td>\n",
       "      <td>None</td>\n",
       "      <td>Usually ships in 1-2 business days</td>\n",
       "      <td>now</td>\n",
       "      <td>Faded Glory</td>\n",
       "      <td>Blue/Grey</td>\n",
       "      <td>Faded Glory Women's Plaid Tunic Shirt: 100% ra...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$18.99</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Faded Glory Women's Plaid Button Down 2 Pocket...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183121</th>\n",
       "      <td>B074PNHL3P</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Romwe</td>\n",
       "      <td>None</td>\n",
       "      <td>Size Chart: &lt;br&gt; One-size:Shoulder:15.7 inch, ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>ROMWE Women's Floral Embroidered Long Sleeve B...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183122</th>\n",
       "      <td>B073PYBR49</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>WILLTOO</td>\n",
       "      <td>Black</td>\n",
       "      <td>&lt;br /&gt; 100% brand new and high quality &lt;br /&gt; ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>A-WILLTOO-3805</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>New! WILLTOO Women V Neck Long Sleeve Blouse F...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183123</th>\n",
       "      <td>B073GH8CKH</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>uxcell</td>\n",
       "      <td>None</td>\n",
       "      <td>• Bring a touch of edgy appeal to your new sea...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>uxcell</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>uxcell</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Agnes Orinda Women's Plus Size Asymmetric Hem ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183124</th>\n",
       "      <td>B01AVN150E</td>\n",
       "      <td>None</td>\n",
       "      <td>Usually ships in 1-2 business days</td>\n",
       "      <td>now</td>\n",
       "      <td>Sacred Threads</td>\n",
       "      <td>Multi</td>\n",
       "      <td>This 100% poly-blend top is butterfly style, h...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$22.00</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>#215586D</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Printed Top in Assorted Colors – One size #215...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183125</th>\n",
       "      <td>B073HZ4BLC</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Fulok</td>\n",
       "      <td>None</td>\n",
       "      <td>Tag Size is Asia size, it is smaller than Amer...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Fulok Women Rainbow Long Sleeve Blouse Button ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183126</th>\n",
       "      <td>B073N5YT66</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>XQS</td>\n",
       "      <td>None</td>\n",
       "      <td>&lt;br&gt;Dear buyer, we are new but grow rapidly, 9...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>XQS Womens Irregular hem Sleeveless Slim Fit t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183127</th>\n",
       "      <td>B00CAOHGO2</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>U.S. Polo Assn.</td>\n",
       "      <td>None</td>\n",
       "      <td>Button down woven shirt</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>U.S. Polo Assn. Juniors Sportswear</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>U.S. Polo Assn. Juniors Sportswear</td>\n",
       "      <td>[True, https://www.amazon.com/reviews/iframe?a...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>U.S. Polo Assn. Juniors Woven Plaid Shirt</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183128</th>\n",
       "      <td>B01IWXIBNO</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Velvet by Graham &amp; Spencer</td>\n",
       "      <td>None</td>\n",
       "      <td>Challis long sleeve boat neck blouse with smoc...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>VELVET BY GRAHAM &amp; SPENCER Women's Collection</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>HARRIETTE03</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>VELVET BY GRAHAM &amp; SPENCER Women's Collection</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>VELVET BY GRAHAM &amp; SPENCER Women's Rayon Chall...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183129</th>\n",
       "      <td>B06XVRZBDL</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HaoDuoYi</td>\n",
       "      <td>None</td>\n",
       "      <td>&lt;br&gt;-Customization and fashion design makes th...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[True, https://www.amazon.com/reviews/iframe?a...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>HaoDuoYi Womens Basic Cut Out Top T Shirt with...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183130</th>\n",
       "      <td>B074VX7YVN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Winwinus</td>\n",
       "      <td>None</td>\n",
       "      <td>&lt;br&gt;China size, pls compare carefully before p...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Winwinus Womens Bow-knot Bandage Long Sleeve B...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183131</th>\n",
       "      <td>B071V9D3MH</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Jingjing1</td>\n",
       "      <td>None</td>\n",
       "      <td>&lt;b&gt;Size Chart:&lt;/b&gt;&lt;br&gt; S:-----Shoulder 11.3\"--...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Women's Cold Shoulder Button Down Shirt, Long ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183132</th>\n",
       "      <td>B074GSTF5S</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Ulla Popken</td>\n",
       "      <td>None</td>\n",
       "      <td>Stay cool &amp; stylish in this lightweight layeri...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Ulla Popken</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>712277</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>Ulla Popken</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Ulla Popken Women's Plus Size Crochet Lace Acc...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183133</th>\n",
       "      <td>B01MSALTSO</td>\n",
       "      <td>None</td>\n",
       "      <td>Usually ships in 1-2 business days</td>\n",
       "      <td>now</td>\n",
       "      <td>TOOGOO(R)</td>\n",
       "      <td>Black</td>\n",
       "      <td>&lt;b&gt;* TOOGOO is a registered trademark. ONLY Au...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$14.58</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>089106A4</td>\n",
       "      <td>OUTERWEAR</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>TOOGOO(R) Women's Tops Spring Autumn Casual Pu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183134</th>\n",
       "      <td>B015W98YQK</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>VOGUE CODE</td>\n",
       "      <td>Monochrome Plaid</td>\n",
       "      <td>SIZE CHART &lt;p&gt; XS for length of front 27.6\"; l...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>VOGUE CODE Vintage V Neck Plaid Shirt Sleevele...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183135</th>\n",
       "      <td>B075756PGC</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Wrangler</td>\n",
       "      <td>Pink</td>\n",
       "      <td>Pretty pink print button down Western shirt fr...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>LGS7089</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Wrangler George Strait For Her Long Sleeve Pin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183136</th>\n",
       "      <td>B074L8FVTT</td>\n",
       "      <td>None</td>\n",
       "      <td>Usually ships in 2-3 business days</td>\n",
       "      <td>now</td>\n",
       "      <td>susana monaco</td>\n",
       "      <td>Rose</td>\n",
       "      <td>Color/pattern: rose. Approximately 23in from s...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$44.99</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>susana monaco</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>susana monaco</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>Susana Monaco Womens Susana Monoco Sleeveless ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183137</th>\n",
       "      <td>B074FTYJQC</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Sexybaby</td>\n",
       "      <td>None</td>\n",
       "      <td>Please check the measurement chart carefully. ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>None</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>None</td>\n",
       "      <td>[False, https://www.amazon.com/reviews/iframe?...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>SexyBaby Women's Mesh Splive Flounced Sleeve C...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>183138 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              asin author                         availability  \\\n",
       "0       B016I2TS4W   None                                 None   \n",
       "1       B01N49AI08   None                                 None   \n",
       "2       B01JDPCOHO   None                                 None   \n",
       "3       B01N19U5H5   None                                 None   \n",
       "4       B004GSI2OS   None  Usually ships in 6-10 business days   \n",
       "5       B00TAEHGGS   None                                 None   \n",
       "6       B012YX2ZPI   None   Usually ships in 4-5 business days   \n",
       "7       B074GPTP3J   None                                 None   \n",
       "8       B06Y2LCC5S   None                                 None   \n",
       "9       B00T9W4E66   None                                 None   \n",
       "10      B073Y91FTS   None                                 None   \n",
       "11      B001LOUGE4   None                                 None   \n",
       "12      B0751PWCP7   None                                 None   \n",
       "13      B0747M995P   None                                 None   \n",
       "14      B01LQAINPG   None                                 None   \n",
       "15      B003BSRPB0   None  Usually ships in 6-10 business days   \n",
       "16      B00L3C0O2S   None                                 None   \n",
       "17      B00XIM7A1Y   None                                 None   \n",
       "18      B06XKGTX6F   None                                 None   \n",
       "19      B01HMCZP80   None                                 None   \n",
       "20      B00XGI2REA   None                                 None   \n",
       "21      B014ICEDNA   None   Usually ships in 4-5 business days   \n",
       "22      B01KKVZM88   None                                 None   \n",
       "23      B01N8YY9G1   None                                 None   \n",
       "24      B071FKC36P   None                                 None   \n",
       "25      B009W1HUG0   None                                 None   \n",
       "26      B073S96HSS   None                                 None   \n",
       "27      B014ICEJ1Q   None   Usually ships in 4-5 business days   \n",
       "28      B074DF831N   None                                 None   \n",
       "29      B01GE1M4M0   None                                 None   \n",
       "...            ...    ...                                  ...   \n",
       "183108  B06WLNR267   None  Usually ships in 6-10 business days   \n",
       "183109  B010R8I8NA   None   Usually ships in 1-2 business days   \n",
       "183110  B073YGRLSM   None   Usually ships in 2-3 business days   \n",
       "183111  B06XJ24BWH   None                                 None   \n",
       "183112  B06XY2DZCT   None                                 None   \n",
       "183113  B01A51IYDI   None                                 None   \n",
       "183114  B07579G728   None                                 None   \n",
       "183115  B071D9X1S9   None                                 None   \n",
       "183116  B0749B51LK   None                                 None   \n",
       "183117  B01MS41A4S   None                                 None   \n",
       "183118  B01LSBZB8A   None                                 None   \n",
       "183119  B06W53LT7P   None                                 None   \n",
       "183120  B01NCO06S0   None   Usually ships in 1-2 business days   \n",
       "183121  B074PNHL3P   None                                 None   \n",
       "183122  B073PYBR49   None                                 None   \n",
       "183123  B073GH8CKH   None                                 None   \n",
       "183124  B01AVN150E   None   Usually ships in 1-2 business days   \n",
       "183125  B073HZ4BLC   None                                 None   \n",
       "183126  B073N5YT66   None                                 None   \n",
       "183127  B00CAOHGO2   None                                 None   \n",
       "183128  B01IWXIBNO   None                                 None   \n",
       "183129  B06XVRZBDL   None                                 None   \n",
       "183130  B074VX7YVN   None                                 None   \n",
       "183131  B071V9D3MH   None                                 None   \n",
       "183132  B074GSTF5S   None                                 None   \n",
       "183133  B01MSALTSO   None   Usually ships in 1-2 business days   \n",
       "183134  B015W98YQK   None                                 None   \n",
       "183135  B075756PGC   None                                 None   \n",
       "183136  B074L8FVTT   None   Usually ships in 2-3 business days   \n",
       "183137  B074FTYJQC   None                                 None   \n",
       "\n",
       "       availability_type                        brand              color  \\\n",
       "0                   None                        FNC7C               None   \n",
       "1                   None                 FIG Clothing               None   \n",
       "2                   None                 FIG Clothing               None   \n",
       "3                   None                      Focal18               None   \n",
       "4                    now                  FeatherLite  Onyx Black/ Stone   \n",
       "5                   None                    Fitscloth              Grape   \n",
       "6                    now  HX-Kingdom Fashion T-shirts              White   \n",
       "7                   None                      Floerns               None   \n",
       "8                   None                  Fashion2ne1              Black   \n",
       "9                   None                         Fila               None   \n",
       "10                  None                      Floerns               None   \n",
       "11                  None                 Fitness Etc.              Black   \n",
       "12                  None               FIFTEEN TWENTY               None   \n",
       "13                  None                  Tee Fashion               None   \n",
       "14                  None                 Fedi Apparel               None   \n",
       "15                   now                  FeatherLite              White   \n",
       "16                  None            FEA Merchandising              Light   \n",
       "17                  None                         FIFA               Grey   \n",
       "18                  None                      Floerns               None   \n",
       "19                  None                 Fedi Apparel               None   \n",
       "20                  None            Fight Like a Girl               None   \n",
       "21                   now                        FNC7C             Purple   \n",
       "22                  None                       FDPlus              Black   \n",
       "23                  None                    Fifth Sun     Purple Heather   \n",
       "24                  None       Fifth Parallel Threads               None   \n",
       "25                  None            Alivila.Y Fashion               None   \n",
       "26                  None                    Fifth Sun             Cancun   \n",
       "27                   now                        FNC7C             Purple   \n",
       "28                  None               Fast & Furious               None   \n",
       "29                  None                       Firebo               None   \n",
       "...                  ...                          ...                ...   \n",
       "183108               now                     Shawhuaa               Rosy   \n",
       "183109               now                  GreaterGood          Turquoise   \n",
       "183110               now              Sky and Sparrow               Rose   \n",
       "183111              None                      Hibluco               None   \n",
       "183112              None                        Hatop              Brown   \n",
       "183113              None                       Tribal               None   \n",
       "183114              None                   Three Dots               None   \n",
       "183115              None                 Studio Works               None   \n",
       "183116              None                         YUNY               None   \n",
       "183117              None            Solution Clothing               None   \n",
       "183118              None                     Paixpays               None   \n",
       "183119              None                          XQS               None   \n",
       "183120               now                  Faded Glory          Blue/Grey   \n",
       "183121              None                        Romwe               None   \n",
       "183122              None                      WILLTOO              Black   \n",
       "183123              None                       uxcell               None   \n",
       "183124               now               Sacred Threads              Multi   \n",
       "183125              None                        Fulok               None   \n",
       "183126              None                          XQS               None   \n",
       "183127              None              U.S. Polo Assn.               None   \n",
       "183128              None   Velvet by Graham & Spencer               None   \n",
       "183129              None                     HaoDuoYi               None   \n",
       "183130              None                     Winwinus               None   \n",
       "183131              None                    Jingjing1               None   \n",
       "183132              None                  Ulla Popken               None   \n",
       "183133               now                    TOOGOO(R)              Black   \n",
       "183134              None                   VOGUE CODE   Monochrome Plaid   \n",
       "183135              None                     Wrangler               Pink   \n",
       "183136               now                susana monaco               Rose   \n",
       "183137              None                     Sexybaby               None   \n",
       "\n",
       "                                         editorial_reivew  \\\n",
       "0                                                     NaN   \n",
       "1                                                     NaN   \n",
       "2                                                     NaN   \n",
       "3                                                     NaN   \n",
       "4                                                     NaN   \n",
       "5                                                     NaN   \n",
       "6                                                     NaN   \n",
       "7                                                     NaN   \n",
       "8                                                     NaN   \n",
       "9                                                     NaN   \n",
       "10                                                    NaN   \n",
       "11                                                    NaN   \n",
       "12                                                    NaN   \n",
       "13                                                    NaN   \n",
       "14                                                    NaN   \n",
       "15                                                    NaN   \n",
       "16                                                    NaN   \n",
       "17                                                    NaN   \n",
       "18                                                    NaN   \n",
       "19                                                    NaN   \n",
       "20                                                    NaN   \n",
       "21                                                    NaN   \n",
       "22                                                    NaN   \n",
       "23                                                    NaN   \n",
       "24                                                    NaN   \n",
       "25                                                    NaN   \n",
       "26                                                    NaN   \n",
       "27                                                    NaN   \n",
       "28                                                    NaN   \n",
       "29                                                    NaN   \n",
       "...                                                   ...   \n",
       "183108  These tank tops are light and breezy comfortab...   \n",
       "183109  The spirit of freedom comes alive in every thr...   \n",
       "183110  Sky and Sparrow Grommet Lace Up top. Off the s...   \n",
       "183111  Hibluco,advocate minimalist fashion brand.<br>...   \n",
       "183112  Item specifics <br> Gender:Women <br> Season:S...   \n",
       "183113               Tribal Sleeveless Pleat Front Blouse   \n",
       "183114  This Three Dots Blouse is guaranteed authentic...   \n",
       "183115  Exclusively ours! Create a sleek, bold style w...   \n",
       "183116  Hi buyer, pls pay attention, pls read our size...   \n",
       "183117  Short Sleeves, Zip Lining, Back Zip, Sexy Shap...   \n",
       "183118  1.100% brand new and good quality.<br>2.Suitab...   \n",
       "183119  <br>Dear buyer, we are new but grow rapidly, 9...   \n",
       "183120  Faded Glory Women's Plaid Tunic Shirt: 100% ra...   \n",
       "183121  Size Chart: <br> One-size:Shoulder:15.7 inch, ...   \n",
       "183122  <br /> 100% brand new and high quality <br /> ...   \n",
       "183123  • Bring a touch of edgy appeal to your new sea...   \n",
       "183124  This 100% poly-blend top is butterfly style, h...   \n",
       "183125  Tag Size is Asia size, it is smaller than Amer...   \n",
       "183126  <br>Dear buyer, we are new but grow rapidly, 9...   \n",
       "183127                            Button down woven shirt   \n",
       "183128  Challis long sleeve boat neck blouse with smoc...   \n",
       "183129  <br>-Customization and fashion design makes th...   \n",
       "183130  <br>China size, pls compare carefully before p...   \n",
       "183131  <b>Size Chart:</b><br> S:-----Shoulder 11.3\"--...   \n",
       "183132  Stay cool & stylish in this lightweight layeri...   \n",
       "183133  <b>* TOOGOO is a registered trademark. ONLY Au...   \n",
       "183134  SIZE CHART <p> XS for length of front 27.6\"; l...   \n",
       "183135  Pretty pink print button down Western shirt fr...   \n",
       "183136  Color/pattern: rose. Approximately 23in from s...   \n",
       "183137  Please check the measurement chart carefully. ...   \n",
       "\n",
       "                                         editorial_review formatted_price  \\\n",
       "0       Minions Como Superheroes Ironman Women's O Nec...            None   \n",
       "1       Sizing runs on the small side. FIG® recommends...            None   \n",
       "2       Sizing runs on the small side. FIG® recommends...            None   \n",
       "3       100% Brand New & Fashion<br> Quantity: 1 Piece...            None   \n",
       "4                                                                  $26.26   \n",
       "5       Solid Modern Long Sleeve Tee. Quality Cotton T...            None   \n",
       "6       This Personalized Special Olympics World Games...           $9.99   \n",
       "7       <strong>Size Chart: </strong><br><br> X-Small:...            None   \n",
       "8       Standing on His Promises Bling Bling Rhineston...            None   \n",
       "9       The Fila Tulip Tank features a sporty design w...            None   \n",
       "10      <strong>Size Chart: </strong><br><br> <strong>...            None   \n",
       "11      Light Weight 2x1 Boy Beater Tank Top.  Great t...          $11.99   \n",
       "12      Fifteen Twenty's Grommet top features long bel...            None   \n",
       "13      This Short Sleeve Tee Will Take Your Casual We...            None   \n",
       "14      *Brand Name:</b> Fedi Apparel </b>(We are a Re...            None   \n",
       "15      FeatherLite Ladies' Moisture Free Mesh Sport S...          $20.54   \n",
       "16           Officially licensed Florida Georgia line tee            None   \n",
       "17      Show your team pride! This Old Glory design is...            None   \n",
       "18      Size Chart: <br> <br> <br>White:<br> Length(in...            None   \n",
       "19      Brand Name: Fedi Apparel(We are a Brand for go...            None   \n",
       "20      Breast cancer survivors and warriors, let canc...            None   \n",
       "21      Supernatural Chibis Sam Dean And Castiel Women...           $7.50   \n",
       "22      MEASUREMENTS <br>1X - Bust (seam to seam) - 22...            None   \n",
       "23      Celebrate your favorite heroes in a half-shell...            None   \n",
       "24      <br><b>MEASUREMENTS</b><br><br><b>FPAWTTS025:<...            None   \n",
       "25      <b>Alivila.Y Fashion Mesh Sequins Long Sleeve ...            None   \n",
       "26      Show everyone your love for the circle of life...            None   \n",
       "27      Supernatural Chibis Sam Dean And Castiel Women...           $7.39   \n",
       "28      Officially Licensed Merchandise. Comes with a ...            None   \n",
       "29      The comfortable, easy-to-wear, soft cotton mak...            None   \n",
       "...                                                   ...             ...   \n",
       "183108                                                NaN          $16.99   \n",
       "183109                                                NaN          $28.95   \n",
       "183110                                                NaN          $26.99   \n",
       "183111                                                NaN            None   \n",
       "183112                                                NaN            None   \n",
       "183113                                                NaN            None   \n",
       "183114                                                NaN            None   \n",
       "183115                                                NaN            None   \n",
       "183116                                                NaN            None   \n",
       "183117                                                NaN            None   \n",
       "183118                                                NaN            None   \n",
       "183119                                                NaN            None   \n",
       "183120                                                NaN          $18.99   \n",
       "183121                                                NaN            None   \n",
       "183122                                                NaN            None   \n",
       "183123                                                NaN            None   \n",
       "183124                                                NaN          $22.00   \n",
       "183125                                                NaN            None   \n",
       "183126                                                NaN            None   \n",
       "183127                                                NaN            None   \n",
       "183128                                                NaN            None   \n",
       "183129                                                NaN            None   \n",
       "183130                                                NaN            None   \n",
       "183131                                                NaN            None   \n",
       "183132                                                NaN            None   \n",
       "183133                                                NaN          $14.58   \n",
       "183134                                                NaN            None   \n",
       "183135                                                NaN            None   \n",
       "183136                                                NaN          $44.99   \n",
       "183137                                                NaN            None   \n",
       "\n",
       "                                          large_image_url  \\\n",
       "0       https://images-na.ssl-images-amazon.com/images...   \n",
       "1       https://images-na.ssl-images-amazon.com/images...   \n",
       "2       https://images-na.ssl-images-amazon.com/images...   \n",
       "3       https://images-na.ssl-images-amazon.com/images...   \n",
       "4       https://images-na.ssl-images-amazon.com/images...   \n",
       "5       https://images-na.ssl-images-amazon.com/images...   \n",
       "6       https://images-na.ssl-images-amazon.com/images...   \n",
       "7       https://images-na.ssl-images-amazon.com/images...   \n",
       "8       https://images-na.ssl-images-amazon.com/images...   \n",
       "9       https://images-na.ssl-images-amazon.com/images...   \n",
       "10      https://images-na.ssl-images-amazon.com/images...   \n",
       "11      https://images-na.ssl-images-amazon.com/images...   \n",
       "12      https://images-na.ssl-images-amazon.com/images...   \n",
       "13      https://images-na.ssl-images-amazon.com/images...   \n",
       "14      https://images-na.ssl-images-amazon.com/images...   \n",
       "15      https://images-na.ssl-images-amazon.com/images...   \n",
       "16      https://images-na.ssl-images-amazon.com/images...   \n",
       "17      https://images-na.ssl-images-amazon.com/images...   \n",
       "18      https://images-na.ssl-images-amazon.com/images...   \n",
       "19      https://images-na.ssl-images-amazon.com/images...   \n",
       "20      https://images-na.ssl-images-amazon.com/images...   \n",
       "21      https://images-na.ssl-images-amazon.com/images...   \n",
       "22      https://images-na.ssl-images-amazon.com/images...   \n",
       "23      https://images-na.ssl-images-amazon.com/images...   \n",
       "24      https://images-na.ssl-images-amazon.com/images...   \n",
       "25      https://images-na.ssl-images-amazon.com/images...   \n",
       "26      https://images-na.ssl-images-amazon.com/images...   \n",
       "27      https://images-na.ssl-images-amazon.com/images...   \n",
       "28      https://images-na.ssl-images-amazon.com/images...   \n",
       "29      https://images-na.ssl-images-amazon.com/images...   \n",
       "...                                                   ...   \n",
       "183108  https://images-na.ssl-images-amazon.com/images...   \n",
       "183109  https://images-na.ssl-images-amazon.com/images...   \n",
       "183110  https://images-na.ssl-images-amazon.com/images...   \n",
       "183111  https://images-na.ssl-images-amazon.com/images...   \n",
       "183112  https://images-na.ssl-images-amazon.com/images...   \n",
       "183113  https://images-na.ssl-images-amazon.com/images...   \n",
       "183114  https://images-na.ssl-images-amazon.com/images...   \n",
       "183115  https://images-na.ssl-images-amazon.com/images...   \n",
       "183116  https://images-na.ssl-images-amazon.com/images...   \n",
       "183117  https://images-na.ssl-images-amazon.com/images...   \n",
       "183118  https://images-na.ssl-images-amazon.com/images...   \n",
       "183119  https://images-na.ssl-images-amazon.com/images...   \n",
       "183120  https://images-na.ssl-images-amazon.com/images...   \n",
       "183121  https://images-na.ssl-images-amazon.com/images...   \n",
       "183122  https://images-na.ssl-images-amazon.com/images...   \n",
       "183123  https://images-na.ssl-images-amazon.com/images...   \n",
       "183124  https://images-na.ssl-images-amazon.com/images...   \n",
       "183125  https://images-na.ssl-images-amazon.com/images...   \n",
       "183126  https://images-na.ssl-images-amazon.com/images...   \n",
       "183127  https://images-na.ssl-images-amazon.com/images...   \n",
       "183128  https://images-na.ssl-images-amazon.com/images...   \n",
       "183129  https://images-na.ssl-images-amazon.com/images...   \n",
       "183130  https://images-na.ssl-images-amazon.com/images...   \n",
       "183131  https://images-na.ssl-images-amazon.com/images...   \n",
       "183132  https://images-na.ssl-images-amazon.com/images...   \n",
       "183133  https://images-na.ssl-images-amazon.com/images...   \n",
       "183134  https://images-na.ssl-images-amazon.com/images...   \n",
       "183135  https://images-na.ssl-images-amazon.com/images...   \n",
       "183136  https://images-na.ssl-images-amazon.com/images...   \n",
       "183137  https://images-na.ssl-images-amazon.com/images...   \n",
       "\n",
       "                                         manufacturer  \\\n",
       "0                                                None   \n",
       "1                                                None   \n",
       "2                                                None   \n",
       "3                                                None   \n",
       "4                                                None   \n",
       "5                                                None   \n",
       "6                                                None   \n",
       "7                                                None   \n",
       "8                                                None   \n",
       "9                                                None   \n",
       "10                                               None   \n",
       "11                                               None   \n",
       "12                                               None   \n",
       "13                                               None   \n",
       "14                                               None   \n",
       "15                                               None   \n",
       "16                                        FEA Juniors   \n",
       "17                                               None   \n",
       "18                                               None   \n",
       "19                                               None   \n",
       "20                                               None   \n",
       "21                                               None   \n",
       "22                                               None   \n",
       "23                                          Fifth Sun   \n",
       "24                                               None   \n",
       "25                                               None   \n",
       "26                                          Fifth Sun   \n",
       "27                                               None   \n",
       "28                                               None   \n",
       "29                                               None   \n",
       "...                                               ...   \n",
       "183108                                           None   \n",
       "183109                                           None   \n",
       "183110                                Sky and Sparrow   \n",
       "183111                                           None   \n",
       "183112                                           None   \n",
       "183113                                           None   \n",
       "183114                                     Three Dots   \n",
       "183115                                           None   \n",
       "183116                                           None   \n",
       "183117                                           None   \n",
       "183118                                           None   \n",
       "183119                                           None   \n",
       "183120                                           None   \n",
       "183121                                           None   \n",
       "183122                                           None   \n",
       "183123                                         uxcell   \n",
       "183124                                           None   \n",
       "183125                                           None   \n",
       "183126                                           None   \n",
       "183127             U.S. Polo Assn. Juniors Sportswear   \n",
       "183128  VELVET BY GRAHAM & SPENCER Women's Collection   \n",
       "183129                                           None   \n",
       "183130                                           None   \n",
       "183131                                           None   \n",
       "183132                                    Ulla Popken   \n",
       "183133                                           None   \n",
       "183134                                           None   \n",
       "183135                                           None   \n",
       "183136                                  susana monaco   \n",
       "183137                                           None   \n",
       "\n",
       "                                         medium_image_url              model  \\\n",
       "0       https://images-na.ssl-images-amazon.com/images...               None   \n",
       "1       https://images-na.ssl-images-amazon.com/images...               None   \n",
       "2       https://images-na.ssl-images-amazon.com/images...               None   \n",
       "3       https://images-na.ssl-images-amazon.com/images...               None   \n",
       "4       https://images-na.ssl-images-amazon.com/images...               None   \n",
       "5       https://images-na.ssl-images-amazon.com/images...             BL0002   \n",
       "6       https://images-na.ssl-images-amazon.com/images...               None   \n",
       "7       https://images-na.ssl-images-amazon.com/images...               None   \n",
       "8       https://images-na.ssl-images-amazon.com/images...               None   \n",
       "9       https://images-na.ssl-images-amazon.com/images...           TW151JE6   \n",
       "10      https://images-na.ssl-images-amazon.com/images...               None   \n",
       "11      https://images-na.ssl-images-amazon.com/images...               None   \n",
       "12      https://images-na.ssl-images-amazon.com/images...            3F17090   \n",
       "13      https://images-na.ssl-images-amazon.com/images...               None   \n",
       "14      https://images-na.ssl-images-amazon.com/images...               None   \n",
       "15      https://images-na.ssl-images-amazon.com/images...               None   \n",
       "16      https://images-na.ssl-images-amazon.com/images...              2F104   \n",
       "17      https://images-na.ssl-images-amazon.com/images...               None   \n",
       "18      https://images-na.ssl-images-amazon.com/images...               None   \n",
       "19      https://images-na.ssl-images-amazon.com/images...               None   \n",
       "20      https://images-na.ssl-images-amazon.com/images...               None   \n",
       "21      https://images-na.ssl-images-amazon.com/images...               None   \n",
       "22      https://images-na.ssl-images-amazon.com/images...               None   \n",
       "23      https://images-na.ssl-images-amazon.com/images...  TMNT0013-60077010   \n",
       "24      https://images-na.ssl-images-amazon.com/images...               None   \n",
       "25      https://images-na.ssl-images-amazon.com/images...               None   \n",
       "26      https://images-na.ssl-images-amazon.com/images...  PXLK0013-60077005   \n",
       "27      https://images-na.ssl-images-amazon.com/images...               None   \n",
       "28      https://images-na.ssl-images-amazon.com/images...               None   \n",
       "29      https://images-na.ssl-images-amazon.com/images...               None   \n",
       "...                                                   ...                ...   \n",
       "183108  https://images-na.ssl-images-amazon.com/images...               None   \n",
       "183109  https://images-na.ssl-images-amazon.com/images...              81627   \n",
       "183110  https://images-na.ssl-images-amazon.com/images...        30668638102   \n",
       "183111  https://images-na.ssl-images-amazon.com/images...               None   \n",
       "183112  https://images-na.ssl-images-amazon.com/images...               None   \n",
       "183113  https://images-na.ssl-images-amazon.com/images...             10612O   \n",
       "183114  https://images-na.ssl-images-amazon.com/images...               None   \n",
       "183115  https://images-na.ssl-images-amazon.com/images...               None   \n",
       "183116  https://images-na.ssl-images-amazon.com/images...               None   \n",
       "183117  https://images-na.ssl-images-amazon.com/images...              T7180   \n",
       "183118  https://images-na.ssl-images-amazon.com/images...          2008S0192   \n",
       "183119  https://images-na.ssl-images-amazon.com/images...               None   \n",
       "183120  https://images-na.ssl-images-amazon.com/images...               None   \n",
       "183121  https://images-na.ssl-images-amazon.com/images...               None   \n",
       "183122  https://images-na.ssl-images-amazon.com/images...     A-WILLTOO-3805   \n",
       "183123  https://images-na.ssl-images-amazon.com/images...               None   \n",
       "183124  https://images-na.ssl-images-amazon.com/images...           #215586D   \n",
       "183125  https://images-na.ssl-images-amazon.com/images...               None   \n",
       "183126  https://images-na.ssl-images-amazon.com/images...               None   \n",
       "183127  https://images-na.ssl-images-amazon.com/images...               None   \n",
       "183128  https://images-na.ssl-images-amazon.com/images...        HARRIETTE03   \n",
       "183129  https://images-na.ssl-images-amazon.com/images...               None   \n",
       "183130  https://images-na.ssl-images-amazon.com/images...               None   \n",
       "183131  https://images-na.ssl-images-amazon.com/images...               None   \n",
       "183132  https://images-na.ssl-images-amazon.com/images...             712277   \n",
       "183133  https://images-na.ssl-images-amazon.com/images...           089106A4   \n",
       "183134  https://images-na.ssl-images-amazon.com/images...               None   \n",
       "183135  https://images-na.ssl-images-amazon.com/images...            LGS7089   \n",
       "183136  https://images-na.ssl-images-amazon.com/images...               None   \n",
       "183137  https://images-na.ssl-images-amazon.com/images...               None   \n",
       "\n",
       "       product_type_name                                      publisher  \\\n",
       "0                  SHIRT                                           None   \n",
       "1                  SHIRT                                           None   \n",
       "2                  SHIRT                                           None   \n",
       "3                  SHIRT                                           None   \n",
       "4                  SHIRT                                           None   \n",
       "5                  SHIRT                                           None   \n",
       "6                  SHIRT                                           None   \n",
       "7                  SHIRT                                           None   \n",
       "8                  SHIRT                                           None   \n",
       "9                  SHIRT                                           None   \n",
       "10                 SHIRT                                           None   \n",
       "11                 SHIRT                                           None   \n",
       "12                 SHIRT                                           None   \n",
       "13                 SHIRT                                           None   \n",
       "14                 SHIRT                                           None   \n",
       "15                 SHIRT                                           None   \n",
       "16                 SHIRT                                    FEA Juniors   \n",
       "17                 SHIRT                                           None   \n",
       "18                 SHIRT                                           None   \n",
       "19                 SHIRT                                           None   \n",
       "20                 SHIRT                                           None   \n",
       "21                 SHIRT                                           None   \n",
       "22                 SHIRT                                           None   \n",
       "23                 SHIRT                                      Fifth Sun   \n",
       "24                 SHIRT                                           None   \n",
       "25               SWEATER                                           None   \n",
       "26                 SHIRT                                      Fifth Sun   \n",
       "27                 SHIRT                                           None   \n",
       "28                 SHIRT                                           None   \n",
       "29                 SHIRT                                           None   \n",
       "...                  ...                                            ...   \n",
       "183108             SHIRT                                           None   \n",
       "183109             SHIRT                                           None   \n",
       "183110             SHIRT                                Sky and Sparrow   \n",
       "183111             SHIRT                                           None   \n",
       "183112             SHIRT                                           None   \n",
       "183113             SHIRT                                           None   \n",
       "183114             SHIRT                                     Three Dots   \n",
       "183115             SHIRT                                           None   \n",
       "183116             SHIRT                                           None   \n",
       "183117             SHIRT                                           None   \n",
       "183118             DRESS                                           None   \n",
       "183119             SHIRT                                           None   \n",
       "183120             SHIRT                                           None   \n",
       "183121             SHIRT                                           None   \n",
       "183122             SHIRT                                           None   \n",
       "183123             SHIRT                                         uxcell   \n",
       "183124             SHIRT                                           None   \n",
       "183125             SHIRT                                           None   \n",
       "183126             SHIRT                                           None   \n",
       "183127             SHIRT             U.S. Polo Assn. Juniors Sportswear   \n",
       "183128             SHIRT  VELVET BY GRAHAM & SPENCER Women's Collection   \n",
       "183129             SHIRT                                           None   \n",
       "183130             SHIRT                                           None   \n",
       "183131             SHIRT                                           None   \n",
       "183132             SHIRT                                    Ulla Popken   \n",
       "183133         OUTERWEAR                                           None   \n",
       "183134             SHIRT                                           None   \n",
       "183135             SHIRT                                           None   \n",
       "183136             SHIRT                                  susana monaco   \n",
       "183137             SHIRT                                           None   \n",
       "\n",
       "                                                  reviews  \\\n",
       "0       [False, https://www.amazon.com/reviews/iframe?...   \n",
       "1       [False, https://www.amazon.com/reviews/iframe?...   \n",
       "2       [False, https://www.amazon.com/reviews/iframe?...   \n",
       "3       [True, https://www.amazon.com/reviews/iframe?a...   \n",
       "4       [False, https://www.amazon.com/reviews/iframe?...   \n",
       "5       [False, https://www.amazon.com/reviews/iframe?...   \n",
       "6       [False, https://www.amazon.com/reviews/iframe?...   \n",
       "7       [True, https://www.amazon.com/reviews/iframe?a...   \n",
       "8       [False, https://www.amazon.com/reviews/iframe?...   \n",
       "9       [True, https://www.amazon.com/reviews/iframe?a...   \n",
       "10      [True, https://www.amazon.com/reviews/iframe?a...   \n",
       "11      [False, https://www.amazon.com/reviews/iframe?...   \n",
       "12      [False, https://www.amazon.com/reviews/iframe?...   \n",
       "13      [False, https://www.amazon.com/reviews/iframe?...   \n",
       "14      [False, https://www.amazon.com/reviews/iframe?...   \n",
       "15      [False, https://www.amazon.com/reviews/iframe?...   \n",
       "16      [True, https://www.amazon.com/reviews/iframe?a...   \n",
       "17      [False, https://www.amazon.com/reviews/iframe?...   \n",
       "18      [True, https://www.amazon.com/reviews/iframe?a...   \n",
       "19      [False, https://www.amazon.com/reviews/iframe?...   \n",
       "20      [True, https://www.amazon.com/reviews/iframe?a...   \n",
       "21      [True, https://www.amazon.com/reviews/iframe?a...   \n",
       "22      [False, https://www.amazon.com/reviews/iframe?...   \n",
       "23      [True, https://www.amazon.com/reviews/iframe?a...   \n",
       "24      [True, https://www.amazon.com/reviews/iframe?a...   \n",
       "25      [True, https://www.amazon.com/reviews/iframe?a...   \n",
       "26      [False, https://www.amazon.com/reviews/iframe?...   \n",
       "27      [False, https://www.amazon.com/reviews/iframe?...   \n",
       "28      [False, https://www.amazon.com/reviews/iframe?...   \n",
       "29      [False, https://www.amazon.com/reviews/iframe?...   \n",
       "...                                                   ...   \n",
       "183108  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183109  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183110  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183111  [True, https://www.amazon.com/reviews/iframe?a...   \n",
       "183112  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183113  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183114  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183115  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183116  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183117  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183118  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183119  [True, https://www.amazon.com/reviews/iframe?a...   \n",
       "183120  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183121  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183122  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183123  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183124  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183125  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183126  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183127  [True, https://www.amazon.com/reviews/iframe?a...   \n",
       "183128  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183129  [True, https://www.amazon.com/reviews/iframe?a...   \n",
       "183130  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183131  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183132  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183133  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183134  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183135  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183136  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "183137  [False, https://www.amazon.com/reviews/iframe?...   \n",
       "\n",
       "                         sku  \\\n",
       "0                       None   \n",
       "1                       None   \n",
       "2                       None   \n",
       "3                       None   \n",
       "4                       None   \n",
       "5                       None   \n",
       "6                       None   \n",
       "7                       None   \n",
       "8                       None   \n",
       "9                       None   \n",
       "10                      None   \n",
       "11                      None   \n",
       "12                      None   \n",
       "13                      None   \n",
       "14                      None   \n",
       "15      HT-2001_Lime-1149-XL   \n",
       "16                      None   \n",
       "17                      None   \n",
       "18                      None   \n",
       "19                      None   \n",
       "20                      None   \n",
       "21                      None   \n",
       "22                      None   \n",
       "23                      None   \n",
       "24                      None   \n",
       "25                      None   \n",
       "26                      None   \n",
       "27                      None   \n",
       "28                      None   \n",
       "29                      None   \n",
       "...                      ...   \n",
       "183108                  None   \n",
       "183109                  None   \n",
       "183110                  None   \n",
       "183111                  None   \n",
       "183112                  None   \n",
       "183113                  None   \n",
       "183114                  None   \n",
       "183115                  None   \n",
       "183116                  None   \n",
       "183117                  None   \n",
       "183118                  None   \n",
       "183119                  None   \n",
       "183120                  None   \n",
       "183121                  None   \n",
       "183122                  None   \n",
       "183123                  None   \n",
       "183124                  None   \n",
       "183125                  None   \n",
       "183126                  None   \n",
       "183127                  None   \n",
       "183128                  None   \n",
       "183129                  None   \n",
       "183130                  None   \n",
       "183131                  None   \n",
       "183132                  None   \n",
       "183133                  None   \n",
       "183134                  None   \n",
       "183135                  None   \n",
       "183136                  None   \n",
       "183137                  None   \n",
       "\n",
       "                                          small_image_url  \\\n",
       "0       https://images-na.ssl-images-amazon.com/images...   \n",
       "1       https://images-na.ssl-images-amazon.com/images...   \n",
       "2       https://images-na.ssl-images-amazon.com/images...   \n",
       "3       https://images-na.ssl-images-amazon.com/images...   \n",
       "4       https://images-na.ssl-images-amazon.com/images...   \n",
       "5       https://images-na.ssl-images-amazon.com/images...   \n",
       "6       https://images-na.ssl-images-amazon.com/images...   \n",
       "7       https://images-na.ssl-images-amazon.com/images...   \n",
       "8       https://images-na.ssl-images-amazon.com/images...   \n",
       "9       https://images-na.ssl-images-amazon.com/images...   \n",
       "10      https://images-na.ssl-images-amazon.com/images...   \n",
       "11      https://images-na.ssl-images-amazon.com/images...   \n",
       "12      https://images-na.ssl-images-amazon.com/images...   \n",
       "13      https://images-na.ssl-images-amazon.com/images...   \n",
       "14      https://images-na.ssl-images-amazon.com/images...   \n",
       "15      https://images-na.ssl-images-amazon.com/images...   \n",
       "16      https://images-na.ssl-images-amazon.com/images...   \n",
       "17      https://images-na.ssl-images-amazon.com/images...   \n",
       "18      https://images-na.ssl-images-amazon.com/images...   \n",
       "19      https://images-na.ssl-images-amazon.com/images...   \n",
       "20      https://images-na.ssl-images-amazon.com/images...   \n",
       "21      https://images-na.ssl-images-amazon.com/images...   \n",
       "22      https://images-na.ssl-images-amazon.com/images...   \n",
       "23      https://images-na.ssl-images-amazon.com/images...   \n",
       "24      https://images-na.ssl-images-amazon.com/images...   \n",
       "25      https://images-na.ssl-images-amazon.com/images...   \n",
       "26      https://images-na.ssl-images-amazon.com/images...   \n",
       "27      https://images-na.ssl-images-amazon.com/images...   \n",
       "28      https://images-na.ssl-images-amazon.com/images...   \n",
       "29      https://images-na.ssl-images-amazon.com/images...   \n",
       "...                                                   ...   \n",
       "183108  https://images-na.ssl-images-amazon.com/images...   \n",
       "183109  https://images-na.ssl-images-amazon.com/images...   \n",
       "183110  https://images-na.ssl-images-amazon.com/images...   \n",
       "183111  https://images-na.ssl-images-amazon.com/images...   \n",
       "183112  https://images-na.ssl-images-amazon.com/images...   \n",
       "183113  https://images-na.ssl-images-amazon.com/images...   \n",
       "183114  https://images-na.ssl-images-amazon.com/images...   \n",
       "183115  https://images-na.ssl-images-amazon.com/images...   \n",
       "183116  https://images-na.ssl-images-amazon.com/images...   \n",
       "183117  https://images-na.ssl-images-amazon.com/images...   \n",
       "183118  https://images-na.ssl-images-amazon.com/images...   \n",
       "183119  https://images-na.ssl-images-amazon.com/images...   \n",
       "183120  https://images-na.ssl-images-amazon.com/images...   \n",
       "183121  https://images-na.ssl-images-amazon.com/images...   \n",
       "183122  https://images-na.ssl-images-amazon.com/images...   \n",
       "183123  https://images-na.ssl-images-amazon.com/images...   \n",
       "183124  https://images-na.ssl-images-amazon.com/images...   \n",
       "183125  https://images-na.ssl-images-amazon.com/images...   \n",
       "183126  https://images-na.ssl-images-amazon.com/images...   \n",
       "183127  https://images-na.ssl-images-amazon.com/images...   \n",
       "183128  https://images-na.ssl-images-amazon.com/images...   \n",
       "183129  https://images-na.ssl-images-amazon.com/images...   \n",
       "183130  https://images-na.ssl-images-amazon.com/images...   \n",
       "183131  https://images-na.ssl-images-amazon.com/images...   \n",
       "183132  https://images-na.ssl-images-amazon.com/images...   \n",
       "183133  https://images-na.ssl-images-amazon.com/images...   \n",
       "183134  https://images-na.ssl-images-amazon.com/images...   \n",
       "183135  https://images-na.ssl-images-amazon.com/images...   \n",
       "183136  https://images-na.ssl-images-amazon.com/images...   \n",
       "183137  https://images-na.ssl-images-amazon.com/images...   \n",
       "\n",
       "                                                    title  \n",
       "0       Minions Como Superheroes Ironman Long Sleeve R...  \n",
       "1                           FIG Clothing Womens Izo Tunic  \n",
       "2                             FIG Clothing Womens Won Top  \n",
       "3       Focal18 Sailor Collar Bubble Sleeve Blouse Shi...  \n",
       "4       Featherlite Ladies' Long Sleeve Stain Resistan...  \n",
       "5       [Fits Cloth] Grape Solid Modern Long Sleeve Pl...  \n",
       "6       Women's Unique 100% Cotton T - Special Olympic...  \n",
       "7       Floerns Women's Bell Sleeve Beading Casual Blo...  \n",
       "8       Standing on His Promises Rhinestones T-Shirt R...  \n",
       "9       Fila Women's Tulip Durable Tennis Style Comfor...  \n",
       "10      Floerns Women's Cold Shoulder Casual Print Ruf...  \n",
       "11                 Ladies Cotton Tank 2x1 Ribbed Tank Top  \n",
       "12         Fifteen Twenty Grommet Tie Sleeve Top in Black  \n",
       "13      Yellow Women T Shirt,dance Cotton Short Sleeve...  \n",
       "14      Fedi Apparel Womens V-neck Long Sleeve Tops Ca...  \n",
       "15      FeatherLite Ladies' Moisture Free Mesh Sport S...  \n",
       "16      FEA Merchandising Juniors Florida Georgia Line...  \n",
       "17       World Cup USA Heather Grey Juniors Soft Tank Top  \n",
       "18      Floerns Women's Flower Embroidered Side Slit S...  \n",
       "19      Fedi Apparel Women Summer Chiffon Blouse Sleev...  \n",
       "20      Cancer Messed With Wrong Chick Breast Cancer T...  \n",
       "21      Supernatural Chibis Sam Dean And Castiel Short...  \n",
       "22      Sexy Open Shoulder X Long Soft Shark Hemline W...  \n",
       "23      Teenage Mutant Ninja Turtles Group Wave Womens...  \n",
       "24      FPT Womens Basic Casual Short Sleeve Round Nec...  \n",
       "25      Alivila.Y Fashion Womens Mesh Sequins Long Sle...  \n",
       "26      Fifth Sun Women's Lion King Hakuna Matata Prin...  \n",
       "27      Supernatural Chibis Sam Dean And Castiel O Nec...  \n",
       "28      Officially Licensed Fast & Furious - Est. 2007...  \n",
       "29      Firebo Billy Joel In Concert 2016 Short Sleeve...  \n",
       "...                                                   ...  \n",
       "183108  Womens Basic Loose Low V Neck Racerback Sport ...  \n",
       "183109                                 Tie Dye Spirit Top  \n",
       "183110   SKY AND SPARROW Grommet Lace Up Top, Rose, Small  \n",
       "183111  Hibluco Women's Sexy V-neck Crop Tops Backless...  \n",
       "183112  Blouse, Hatop Womens Sexy Off Shoulder Irregul...  \n",
       "183113               Tribal Sleeveless Pleat Front Blouse  \n",
       "183114          Three Dots Womens Gathered Pleated Blouse  \n",
       "183115                    Studio Works Printed Poncho Top  \n",
       "183116  YUNY Women Casual Denim Patchwork Plaid Shirt ...  \n",
       "183117     Bangbangusa Women One Golden Star Back Zip Top  \n",
       "183118  Women Long Sleeve Denim Blue Casual Shirt Blou...  \n",
       "183119  XQS Women's Solid Basic Chiffon Casual Shirts ...  \n",
       "183120  Faded Glory Women's Plaid Button Down 2 Pocket...  \n",
       "183121  ROMWE Women's Floral Embroidered Long Sleeve B...  \n",
       "183122  New! WILLTOO Women V Neck Long Sleeve Blouse F...  \n",
       "183123  Agnes Orinda Women's Plus Size Asymmetric Hem ...  \n",
       "183124  Printed Top in Assorted Colors – One size #215...  \n",
       "183125  Fulok Women Rainbow Long Sleeve Blouse Button ...  \n",
       "183126  XQS Womens Irregular hem Sleeveless Slim Fit t...  \n",
       "183127          U.S. Polo Assn. Juniors Woven Plaid Shirt  \n",
       "183128  VELVET BY GRAHAM & SPENCER Women's Rayon Chall...  \n",
       "183129  HaoDuoYi Womens Basic Cut Out Top T Shirt with...  \n",
       "183130  Winwinus Womens Bow-knot Bandage Long Sleeve B...  \n",
       "183131  Women's Cold Shoulder Button Down Shirt, Long ...  \n",
       "183132  Ulla Popken Women's Plus Size Crochet Lace Acc...  \n",
       "183133  TOOGOO(R) Women's Tops Spring Autumn Casual Pu...  \n",
       "183134  VOGUE CODE Vintage V Neck Plaid Shirt Sleevele...  \n",
       "183135  Wrangler George Strait For Her Long Sleeve Pin...  \n",
       "183136  Susana Monaco Womens Susana Monoco Sleeveless ...  \n",
       "183137  SexyBaby Women's Mesh Splive Flounced Sleeve C...  \n",
       "\n",
       "[183138 rows x 19 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "''' JSON file contains all the information about products.\n",
    "    Loading the data using pandas\n",
    "'''\n",
    "data=pd.read_json(\"tops_fashion.json\")\n",
    "data\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of data-points/products: 183138\n",
      "Number of features/variables: 19\n"
     ]
    }
   ],
   "source": [
    "print(\"Number of data-points/products: {}\\nNumber of features/variables: {}\".format(data.shape[0],data.shape[1]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['asin', 'author', 'availability', 'availability_type', 'brand', 'color',\n",
       "       'editorial_reivew', 'editorial_review', 'formatted_price',\n",
       "       'large_image_url', 'manufacturer', 'medium_image_url', 'model',\n",
       "       'product_type_name', 'publisher', 'reviews', 'sku', 'small_image_url',\n",
       "       'title'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'''Each product has 19 features in the raw dataset. Print col names'''\n",
    "data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Out of the 19 features, 12 features are discarded and remaining \\n7 features are extracted into the data frame'"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data=data[['asin','brand','color','medium_image_url','product_type_name','title','formatted_price']]\n",
    "'''Out of the 19 features, 12 features are discarded and remaining \n",
    "7 features are extracted into the data frame'''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of data-points/products: 183138\n",
      "Number of features/variables: 7\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>asin</th>\n",
       "      <th>brand</th>\n",
       "      <th>color</th>\n",
       "      <th>medium_image_url</th>\n",
       "      <th>product_type_name</th>\n",
       "      <th>title</th>\n",
       "      <th>formatted_price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>B016I2TS4W</td>\n",
       "      <td>FNC7C</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>Minions Como Superheroes Ironman Long Sleeve R...</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>B01N49AI08</td>\n",
       "      <td>FIG Clothing</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>FIG Clothing Womens Izo Tunic</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>B01JDPCOHO</td>\n",
       "      <td>FIG Clothing</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>FIG Clothing Womens Won Top</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>B01N19U5H5</td>\n",
       "      <td>Focal18</td>\n",
       "      <td>None</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>Focal18 Sailor Collar Bubble Sleeve Blouse Shi...</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>B004GSI2OS</td>\n",
       "      <td>FeatherLite</td>\n",
       "      <td>Onyx Black/ Stone</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>SHIRT</td>\n",
       "      <td>Featherlite Ladies' Long Sleeve Stain Resistan...</td>\n",
       "      <td>$26.26</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         asin         brand              color  \\\n",
       "0  B016I2TS4W         FNC7C               None   \n",
       "1  B01N49AI08  FIG Clothing               None   \n",
       "2  B01JDPCOHO  FIG Clothing               None   \n",
       "3  B01N19U5H5       Focal18               None   \n",
       "4  B004GSI2OS   FeatherLite  Onyx Black/ Stone   \n",
       "\n",
       "                                    medium_image_url product_type_name  \\\n",
       "0  https://images-na.ssl-images-amazon.com/images...             SHIRT   \n",
       "1  https://images-na.ssl-images-amazon.com/images...             SHIRT   \n",
       "2  https://images-na.ssl-images-amazon.com/images...             SHIRT   \n",
       "3  https://images-na.ssl-images-amazon.com/images...             SHIRT   \n",
       "4  https://images-na.ssl-images-amazon.com/images...             SHIRT   \n",
       "\n",
       "                                               title formatted_price  \n",
       "0  Minions Como Superheroes Ironman Long Sleeve R...            None  \n",
       "1                      FIG Clothing Womens Izo Tunic            None  \n",
       "2                        FIG Clothing Womens Won Top            None  \n",
       "3  Focal18 Sailor Collar Bubble Sleeve Blouse Shi...            None  \n",
       "4  Featherlite Ladies' Long Sleeve Stain Resistan...          $26.26  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#checking whether everything is correct or not\n",
    "print(\"Number of data-points/products: {}\\nNumber of features/variables: {}\".format(data.shape[0],data.shape[1]))\n",
    "#printing the top 5 rows \n",
    "data.head()"
   ]
  },
  {
   "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.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}