Mercari.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "_cell_guid": "b653248a-fc15-44d1-bce8-84da424f93dd",
    "_uuid": "c04384d57897cdc855c07b543e40d2d936358292",
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# This Python 3 environment comes with many helpful analytics libraries installed\n",
    "# It is defined by the kaggle/python docker image: https://github.com/kaggle/docker-python\n",
    "# For example, here's several helpful packages to load in \n",
    "\n",
    "import numpy as np # linear algebra\n",
    "import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "\n",
    "sns.set_style('darkgrid')\n",
    "plt.rcParams[\"patch.force_edgecolor\"] = True\n",
    "%matplotlib inline\n",
    "\n",
    "# Input data files are available in the \"../input/\" directory.\n",
    "# For example, running this (by clicking run or pressing Shift+Enter) will list the files in the input directory\n",
    "\n",
    "# from subprocess import check_output\n",
    "# print(check_output([\"ls\", \"../input\"]).decode(\"utf8\"))\n",
    "\n",
    "# Any results you write to the current directory are saved as output."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "_uuid": "a8e43992a568cc2eaba053b54af064f314e36343"
   },
   "source": [
    "First, let's mport the test and train data sets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "_uuid": "0f5165fd2f07c2466815dbf36b63037dbfadd452",
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df_train = pd.read_csv('input/train.tsv',sep='\\t')\n",
    "df_test = pd.read_csv('input/test.tsv',sep='\\t')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "_uuid": "d21cd7a3610b5528d91bba8c481fcce3b48383d4",
    "collapsed": false
   },
   "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>train_id</th>\n",
       "      <th>name</th>\n",
       "      <th>item_condition_id</th>\n",
       "      <th>category_name</th>\n",
       "      <th>brand_name</th>\n",
       "      <th>price</th>\n",
       "      <th>shipping</th>\n",
       "      <th>item_description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>MLB Cincinnati Reds T Shirt Size XL</td>\n",
       "      <td>3</td>\n",
       "      <td>Men/Tops/T-shirts</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1</td>\n",
       "      <td>No description yet</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Razer BlackWidow Chroma Keyboard</td>\n",
       "      <td>3</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/Components &amp; P...</td>\n",
       "      <td>Razer</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0</td>\n",
       "      <td>This keyboard is in great condition and works ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>AVA-VIV Blouse</td>\n",
       "      <td>1</td>\n",
       "      <td>Women/Tops &amp; Blouses/Blouse</td>\n",
       "      <td>Target</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Adorable top with a hint of lace and a key hol...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Leather Horse Statues</td>\n",
       "      <td>1</td>\n",
       "      <td>Home/Home Décor/Home Décor Accents</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.0</td>\n",
       "      <td>1</td>\n",
       "      <td>New with tags. Leather horses. Retail for [rm]...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>24K GOLD plated rose</td>\n",
       "      <td>1</td>\n",
       "      <td>Women/Jewelry/Necklaces</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Complete with certificate of authenticity</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   train_id                                 name  item_condition_id  \\\n",
       "0         0  MLB Cincinnati Reds T Shirt Size XL                  3   \n",
       "1         1     Razer BlackWidow Chroma Keyboard                  3   \n",
       "2         2                       AVA-VIV Blouse                  1   \n",
       "3         3                Leather Horse Statues                  1   \n",
       "4         4                 24K GOLD plated rose                  1   \n",
       "\n",
       "                                       category_name brand_name  price  \\\n",
       "0                                  Men/Tops/T-shirts        NaN   10.0   \n",
       "1  Electronics/Computers & Tablets/Components & P...      Razer   52.0   \n",
       "2                        Women/Tops & Blouses/Blouse     Target   10.0   \n",
       "3                 Home/Home Décor/Home Décor Accents        NaN   35.0   \n",
       "4                            Women/Jewelry/Necklaces        NaN   44.0   \n",
       "\n",
       "   shipping                                   item_description  \n",
       "0         1                                 No description yet  \n",
       "1         0  This keyboard is in great condition and works ...  \n",
       "2         1  Adorable top with a hint of lace and a key hol...  \n",
       "3         1  New with tags. Leather horses. Retail for [rm]...  \n",
       "4         0          Complete with certificate of authenticity  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_train.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "_uuid": "631728656170ee4f3ebe9d0d45932bbfb764f08d",
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1482535 entries, 0 to 1482534\n",
      "Data columns (total 8 columns):\n",
      "train_id             1482535 non-null int64\n",
      "name                 1482535 non-null object\n",
      "item_condition_id    1482535 non-null int64\n",
      "category_name        1476208 non-null object\n",
      "brand_name           849853 non-null object\n",
      "price                1482535 non-null float64\n",
      "shipping             1482535 non-null int64\n",
      "item_description     1482531 non-null object\n",
      "dtypes: float64(1), int64(3), object(4)\n",
      "memory usage: 90.5+ MB\n"
     ]
    }
   ],
   "source": [
    "df_train.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "_uuid": "2bfb6b37a281ea3c016b8be295d71c5dde6e8aef",
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAagAAAEYCAYAAAAJeGK1AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4wLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvpW3flQAAGo1JREFUeJzt3XmUXVWZ9/FvDZnKhBRqoaIMKvro\ncsAGMThAoqKI2I1jryxxAPS19Y1LeZtuURsEu7WdECdAfFGIvqK2gtBqN4qv2hAQSSOzwoPggEtb\nO+Q1hJg5dd8/zimoFJWqS+4Jd1fV97NWFvfus8++e+8q7q/2Oeee29NqtZAkqTS93e6AJEnjMaAk\nSUUyoCRJRTKgJElFMqAkSUUyoCRJRervdgc0M0TEvsAdwE11US+wDvhkZn69rvOPwO2Z+aUJ2nkf\ncENm/us42+7dPyJawFBm3vUA+ngQ8KbMfGtEPBN4d2a+ut39d0ZE9AHfBJ4MfDozzxi1bQlwRmY+\nNSIWAhdl5gt2YV+eA7wPeCTQB9wJnJiZNzfU/sOBVZnZExF/BRyWme+IiCOBRZn5vtHlTbympjYD\nSg+mDZn5jJEnEbEP8IOI2JaZF2bm+9po4wXAz8fb0Ob+E3kK8Ji6rWuAXRpOtUcDhwMPycxtE9Tb\nHXjWrupERBwKfBl4RWb+tC47GrgsIp6UmauafL3M/BbwrfrpQcBDxynXDGdAqWsy8zf1iujvgQsj\nYjlwc2aeFhHvB14BbAZWA8cArwSeCXwsIrYBR1G9sT0e+A7wiJH965f4YL0q6gVOyszvRMQxwKsz\n82UAI8+BtwH/CCyMiPOAL7L96uVM4BlAC7gEeG9mbo2IjcCHgRcDjwI+mpmfHTvWiDgE+BgwUI/p\nJOBK4LvALOCnEfGqzLxjB9N1HjAvIq4HDgSeCHwKeBjVaufTmXluver6ENXqJ4A/1/17R/38wsz8\nX+O0/37gn0bCqf75nF+Pr68ew1vqdrYBfwTenpm31T+3tcDTgL2AG4E3ZOa6iHgl8EFgPfCfo+Zj\nZN7/CXgr0BcRdwO/oP75RMRjgM8C+wI9wBcz82P1avwHwL8Di6jC+12ZedEO5k5TlOeg1G03UL2x\n3Ssi9gKOBw7KzGcCl1IdAjoTuAb4+1FvRgOZ+ZTMPHGctn+ZmQcArwO+GBFDO+pEZv6W6vDWisw8\ndszmT1OF5NOoAnJ/4O/qbXOAuzLzOVRvuJ+IiLljxvMw4ALgnZn5dOCNVKuVhwMvpV5ZThBOAMdy\n3wq0p27v3Zl5ILAY+LuIOLiuexDw4bruWuA9wJHAAcCyiNhznPafSRWYY+flwsz8Q0S8AHgX8PzM\n3B/4CnBxRPTUVQ8EXkJ1qHJf4DUR8QjgXOBVdT9/M077VwNnA/+Smf8wZvP5wI8y82nAc4HXRcTS\netvjgO9l5rOAdwOf3NHEaeoyoNRtLaq/rkf7HVVwXRsRpwHXZ+bFO9j/ignaPhugPofyc+DZO9nH\nI6hWU63M3FS3e8So7SPnw66lCqyHjNl/EdW5savr/vyMKgyW7GR/nki1ajy3XlFdBswD/qLe/qvM\nvK5+fAfVm/zm+nzcWurDaWMMM/H7wUuoQmRVPYblVIcn9623fzczN2XmFqrzjA8FngfclJkjh2Q/\n1+4AI+IhVKF0Zv16dwPLuW/et1CtoKCa9/HGpCnOgFK3HcR9F04AkJnDVKuCY6hWLp+IiI/uYP91\nE7Q9+pxOL9WbWotqBTJidht97K33G/181qjnG+p+j9QZ3T5Uh8jG3vRybBsPRB9wd73qeka9UjqY\n6jAgwKYx9be00eZP6ja2ExFnRsRhjD+GHu4bw4ZR5aPnePRcbG2jHyN6uf88jp6zzfXvydjX0zRi\nQKlrIuKJwMnAx8eU7w/cDNySmR8CPkEVZFC9ybX7xn5M3d4BwH7A1cAq4KkRMTciZrH9hRA7avt7\nwNsjoici5gBvAb7fZh8ArgKeFBHPqvvzFOBQ4D8eQBtbqc7T9AAJbIiI19Xt7UU1Xwc+gPbG+gBw\nSkTc28ao80Q3UZ0rWzpymDQijqX64+H2Cdq8HHhK/fOE+ucxjvvNe2beQxWay+rXWwi8gQc275ri\nDCg9mOZFxPX1v2upDtm8JzP/bXSlzLwB+DpwTURcAxwH/G29+VvAhyLijW283uMi4jrg88DSzPx/\nVOezLgNupXoDvWZU/Z/U+3xzTDvvAPageqO+iSogPtjmmKkPrb0G+ExE3ER1/ubYzLyt3TaA/wJW\nAj8DFlBdIPLmiLixHtPJmXm/c0gPoI8rgDcDn6p/Pj8HXkV1zumPmfl9qj8UfhgRP6M6j/ayUauY\n8dpcBbwWOL/+eT92B1V/CBweEZ8ZU3408MJ6zlZSXY6/fGfHqKmnx6/bkCSVyBWUJKlIBpQkqUgG\nlCSpSAaUJKlIU+5WR6tW3dPxVR3z589h3bqxHxVRJ5zT5jmnzXNOm9fEnA4NLRj3c2wzcgXV39/X\n7S5MO85p85zT5jmnzduVczojA0qSVD4DSpJUJANKklQkA0qSVCQDSpJUJANKklQkA0qSVCQDSpJU\nJANKklSkKXeroyacfe6X+M3vV3W7G8XYY/eFHHv0a7vdDUnazowMqD+uXsMTDn15t7tRjF9cfnG3\nuyBJ9+MhPklSkQwoSVKRDChJUpEMKElSkQwoSVKRDChJUpEMKElSkQwoSVKRDChJUpHaupNERLwH\n+CtgNnAWcBmwHGgBNwPLMnM4Ik4BjgS2Asdn5sqI2K/Tug2NVZI0hUy6goqIJcBzgOcCi4G9gNOB\nkzLzEKAHOCoiDqi3LwKWAmfWTXRUt4ExSpKmoHYO8R0O3ARcBHwb+A5wINUqCuAS4DDgecClmdnK\nzDuB/ogYaqCuJGkGaucQ38OBfYCXAY8FvgX0Zmar3n4PsBDYDVg9ar+R8p4O625n/vw59Pf3tdHt\nHevp7WFg3uyO2phO5s6ZxeDgQEdt9PX1dtyGtuecNs85bd6unNN2Amo1cGtmbgYyIjZSHeYbsQBY\nA6ytH48tH+6w7nbWrdvURpcn1hpusX7D5o7bmS42btrCmjXrO2pjcHCg4za0Pee0ec5p85qY06Gh\nBeOWt3OI7wrgJRHRExF7Ag8BflCfmwI4AlgBXAkcHhG9EbE31SrrLuC6DutKkmagSVdQmfmdiDgU\nWEkVaMuAXwHnRMRs4BbggszcFhErgKtG1QM4oZO6DY1TkjTF9LRarclrFWTVqns67vCnzvk8ey06\nsonuTAu/uPxiTnz72zpqw0MnzXNOm+ecNq+hQ3w945X7QV1JUpEMKElSkQwoSVKRDChJUpEMKElS\nkQwoSVKRDChJUpEMKElSkQwoSVKRDChJUpEMKElSkQwoSVKRDChJUpEMKElSkQwoSVKRDChJUpEM\nKElSkQwoSVKRDChJUpEMKElSkQwoSVKRDChJUpEMKElSkQwoSVKRDChJUpEMKElSkfrbqRQR1wF3\n109/BXwO+BSwFbg0M98fEb3AWcD+wCbgzZl5e0Qc3EndpgYqSZpaJg2oiJgLkJlLRpVdD7wK+CXw\nbxFxALAvMDczn10HzceBo4CzO6mbmdc2M1RJ0lTSzgpqf2AgIi6t658KzMnMOwAi4nvAC4FHAd8F\nyMyfRMQzI2K3BuoaUJI0A7UTUOuB04DPA08ALgHWjNp+D/A4YDfuOwwIsK0uW9th3e3Mnz+H/v6+\nNrq9Yz29PQzMm91RG9PJ3DmzGBwc6KiNvr7ejtvQ9pzT5jmnzduVc9pOQN0G3J6ZLeC2iLgbeOio\n7QuoAmugfjyilypwFnRYdzvr1m1qo8sTaw23WL9hc8ftTBcbN21hzZr1HbUxODjQcRvannPaPOe0\neU3M6dDQgnHL27mK7ziqc0RExJ5U4fLniHh8RPQAhwMrgCuBl9b1DgZuysy1wOYO60qSZqB2VlBf\nAJZHxBVAiyqwhoHzgT6qq+2ujoj/BF4UET8GeoBj6/3f2kndJgYpSZp6Jg2ozNwMvHacTQePqTdM\nFTBj9/9JJ3UlSTOTH9SVJBXJgJIkFcmAkiQVyYCSJBXJgJIkFcmAkiQVyYCSJBXJgJIkFcmAkiQV\nyYCSJBXJgJIkFcmAkiQVyYCSJBXJgJIkFcmAkiQVyYCSJBXJgJIkFcmAkiQVadKvfJdmmvPO/wr/\n/ae7u90N5s6ZxcZNW7rdDfbYfSHHHv3abndDM5ABJY3x33+6mycc+vJud4OBebNZv2Fzt7vBLy6/\nuNtd0AzlIT5JUpEMKElSkQwoSVKRDChJUpEMKElSkQwoSVKR2rrMPCL2AH4KvAjYCiwHWsDNwLLM\nHI6IU4Aj6+3HZ+bKiNiv07pNDVSSNLVMuoKKiFnA54ANddHpwEmZeQjQAxwVEQcAi4FFwFLgzCbq\ndj48SdJU1c4K6jTgbOA99fMDgcvqx5cALwYSuDQzW8CdEdEfEUMN1L1obGfmz59Df3/fAxvlGD29\nPQzMm91RG9PJ3DmzGBwc6KiNvr7ejtsoxdw5s4r4/egt5Pe0id+PUkyn39NS7Mo5nTCgIuIYYFVm\nfi8iRgKqpw4XgHuAhcBuwOpRu46Ud1r3ftat29TGsCbWGm4V8Qn9UmzctIU1a9Z31Mbg4EDHbZRi\n46YtRfx+lHIniSZ+P0oxnX5PS9HEnA4NLRi3fLIV1HFAKyIOA54BfAnYY9T2BcAaYG39eGz5cId1\nJUkz1ITnoDLz0MxcnJlLgOuBNwCXRMSSusoRwArgSuDwiOiNiL2B3sy8C7iuw7qSpBlqZ24WewJw\nTkTMBm4BLsjMbRGxAriKKvSWNVF3ZwclSZr62g6oehU1YvE4208FTh1TdlundSVJM5Mf1JUkFcmA\nkiQVyYCSJBXJb9QVN9x4Ix8547MdtVHK15M34cabf1bEN+pKM50BJdZv3trxG3IpHyptwlXXXNvt\nLkjCQ3ySpEIZUJKkIhlQkqQiGVCSpCIZUJKkIhlQkqQiGVCSpCIZUJKkIhlQkqQiGVCSpCIZUJKk\nIhlQkqQiGVCSpCIZUJKkIhlQkqQiGVCSpCIZUJKkIhlQkqQiGVCSpCIZUJKkIvVPViEi+oBzgAC2\nAccCPcByoAXcDCzLzOGIOAU4EtgKHJ+ZKyNiv07rNjdcSdJU0c4K6i8BMvO5wPuA0+t/J2XmIVRh\ndVREHAAsBhYBS4Ez6/07qtvxCCVJU9KkAZWZFwNvqZ/uA/wROBC4rC67BDgMeB5waWa2MvNOoD8i\nhhqoK0magSY9xAeQmVsj4ovAK4BXAy/LzFa9+R5gIbAbsHrUbiPlPR3W3c78+XPo7+9rp9s71NPb\nw8C82R21MZ309/d2PB+902hOm5iPJpQyp3PnzGJwcKDb3WhEX1/vtBlLKXblnLYVUACZ+caIOBG4\nGpg3atMCYA2wtn48tny4w7rbWbduU7td3qHWcIv1GzZ33M50sXXrcMfzMTBv9rSZ0ybmowmlzOnG\nTVtYs2Z9t7vRiMHBgWkzllI0MadDQwvGLZ/0EF9EvD4i3lM/XU8VItdExJK67AhgBXAlcHhE9EbE\n3kBvZt4FXNdhXUnSDNTOCuqbwHkRcTkwCzgeuAU4JyJm148vyMxtEbECuIoq+JbV+5/QSd0mBilJ\nmnomDajM/DPw1+NsWjxO3VOBU8eU3dZpXUnSzOMHdSVJRTKgJElFMqAkSUUyoCRJRTKgJElFMqAk\nSUUyoCRJRTKgJElFMqAkSUUyoCRJRTKgJElFMqAkSUUyoCRJRTKgJElFMqAkSUUyoCRJRTKgJElF\nMqAkSUUyoCRJRTKgJElFMqAkSUUyoCRJRTKgJElFMqAkSUUyoCRJRTKgJElF6p9oY0TMAs4F9gXm\nAB8Afg4sB1rAzcCyzByOiFOAI4GtwPGZuTIi9uu0bqOjlSRNGZOtoF4HrM7MQ4AjgDOA04GT6rIe\n4KiIOABYDCwClgJn1vt3VLeZIUqSpqLJAuobwMmjnm8FDgQuq59fAhwGPA+4NDNbmXkn0B8RQw3U\nlSTNUBMe4svMdQARsQC4ADgJOC0zW3WVe4CFwG7A6lG7jpT3dFj3fubPn0N/f19bg9uRnt4eBubN\n7qiN6aS/v7fj+eidRnPaxHw0oZQ5nTtnFoODA93uRiP6+nqnzVhKsSvndMKAAoiIvYCLgLMy8ysR\n8dFRmxcAa4C19eOx5cMd1r2fdes2TdblSbWGW6zfsLnjdqaLrVuHO56PgXmzp82cNjEfTShlTjdu\n2sKaNeu73Y1GDA4OTJuxlKKJOR0aWjBu+YSH+CLiEcClwImZeW5dfF1ELKkfHwGsAK4EDo+I3ojY\nG+jNzLsaqCtJmqEmW0G9F9gdODkiRs5FvRP4dETMBm4BLsjMbRGxAriKKvSW1XVPAM7Z2bqNjFCS\nNCVNdg7qnVSBNNbiceqeCpw6puy2TutKkmYmP6grSSqSASVJKpIBJUkqkgElSSqSASVJKpIBJUkq\nkgElSSqSASVJKpIBJUkqkgElSSqSASVJKpIBJUkqkgElSSqSASVJKpIBJUkqkgElSSqSASVJKpIB\nJUkqkgElSSqSASVJKpIBJUkqkgElSSqSASVJKpIBJUkqkgElSSqSASVJKlJ/O5UiYhHwkcxcEhH7\nAcuBFnAzsCwzhyPiFOBIYCtwfGaubKJuc0OVJE0lk66gIuJdwOeBuXXR6cBJmXkI0AMcFREHAIuB\nRcBS4Mwm6nY+PEnSVNXOIb47gFeOen4gcFn9+BLgMOB5wKWZ2crMO4H+iBhqoK4kaYaa9BBfZl4Y\nEfuOKurJzFb9+B5gIbAbsHpUnZHyTuvez/z5c+jv75us2xPq6e1hYN7sjtqYTvr7ezuej95pNKdN\nzEcTSpnTuXNmMTg40O1uNKKvr3fajKUUu3JO2zoHNcbo80ILgDXA2vrx2PJO697PunWbdqLL22sN\nt1i/YXPH7UwXW7cOdzwfA/NmT5s5bWI+mlDKnG7ctIU1a9Z3uxuNGBwcmDZjKUUTczo0tGDc8p25\niu+6iFhSPz4CWAFcCRweEb0RsTfQm5l3NVBXkjRD7cwK6gTgnIiYDdwCXJCZ2yJiBXAVVegta6Lu\nzg5KkjT1tRVQmflr4OD68W1UV+GNrXMqcOqYso7rSpJmJj+oK0kqkgElSSqSASVJKpIBJUkqkgEl\nSSqSASVJKpIBJUkqkgElSSqSASVJKpIBJUkqkgElSSqSASVJKpIBJUkqkgElSSqSASVJKpIBJUkq\nkgElSSqSASVJKlJbX/kuaea64cYb+cgZn+12Nxoxd84sNm7a0lEbe+y+kGOPfm1DPdJEDChJE1q/\neStPOPTl3e5GIwbmzWb9hs0dtfGLyy9uqDeajIf4JElFMqAkSUUyoCRJRTKgJElFMqAkSUUyoCRJ\nRSrqMvOI6AXOAvYHNgFvzszbu9srSVI3FBVQwMuBuZn57Ig4GPg4cFSX+yRJ95pOH1xuwj57DrH0\nla/eJW33tFqtXdLwzoiI04GVmfm1+vnvMvPRXe6WJKkLSjsHtRtw96jn2yKitFWeJOlBUFpArQUW\njHrem5lbu9UZSVL3lBZQVwIvBajPQd3U3e5IkrqltMNnFwEviogfAz3AsV3ujySpS4q6SOLBEBGL\ngI9k5pJu92Wqi4hZwLnAvsAc4AOZ+a2udmqKi4g+4BwggG3AsZl5R3d7NT1ExB7AT4EXZeat3e7P\nVBcR13HfNQO/yszGFxSlraB2qYh4F/B64M/d7ss08TpgdWa+PiIeBlwHGFCd+UuAzHxuRCwBTseP\nWnSs/mPqc8CGbvdlOoiIuQC7+g/90s5B7Wp3AK/sdiemkW8AJ4967gUtHcrMi4G31E/3Af7Yxe5M\nJ6cBZwO/73ZHpon9gYGIuDQiflhfM9C4GRVQmXkh0NnXaepembkuM++JiAXABcBJ3e7TdJCZWyPi\ni8BnqOZVHYiIY4BVmfm9bvdlGllPFfqHA28Fzt8VHwmaUQGl5kXEXsCPgP+TmV/pdn+mi8x8I/BE\n4JyIeEi3+zPFHUd18dV/AM8AvhQRj+xul6a824AvZ2YrM28DVgOPavpFZtQ5KDUrIh4BXAq8PTN/\n0O3+TAcR8XrgMZn5Iaq/UoepLpbQTsrMQ0ce1yH11sz8Q/d6NC0cBzwN+J8RsSfVTRb+q+kXMaDU\nifcCuwMnR8TIuagjMtMT0Tvvm8B5EXE5MAs4PjM3drlP0lhfAJZHxBVACzhuV9xUYcZdZi5Jmho8\nByVJKpIBJUkqkgElSSqSASVJKpIBJUkqkpeZa0aLiJcAe9dPz8vMYu80EhFPAs7OzCUR8TXgDcAj\ngf0z89sR8Ung9My8s4HXejfww8xcOapsLnBrZu7baftSOwwozWiZ+V2AiPg18CWmyK2wMnMpQES8\nAHgS8O3MPL7B9j/cVFvSzjKgNKPV92n7GNU3OX8NeHlEfAg4lOoQ+OmZ+Y36DgQ3AE8F1gErqO5D\nNgi8ODP/tIP2FwGfovp+s98BR1MFymeo7hCxEfgf9Wt9Ffgt8HhgZWa+LSIeBZxf7/+HUe3+GngK\n8G6qm3b+GPhbqvui/QH4MtWn+/uBkzLzhxFxI3AZ8HSqD1celZkjX5cwtt/L6/m4on793YHbJ51Q\nqUGeg5KqT8X/AVgaEUcAj83M5wLPB/4hIgbreisz84VU3321PjNfBPwcWDxB2/+b6judFgH/F3gy\n1fc9vT0zFwNnUX2lBlT33nsT8CzgpfX94k4AvpqZzwcuHtP2NuDDwFfGfA/XScD361v8vAb4QkT0\nUgXWV+vX/R1wRBtzcwxwc93W59qoLzXGgJK29zTgwHrF9F2q2w3tU2+7tv7vGqpgAvgTMHeC9h6R\nmbcAZOZZmXktsGdmXl9vv5xqJQRwe2bek5nbqO5rNrfeNnIe6Mo2x/Dkul0y83fAWmCo3nZd/d/f\nTtLvEfe+fmZezRQ5BKrpwYCSKsNU/z/cCvyo/iK2FwBfB35Z19mZ+4L9PiKeABARJ0bEK+qyp9fb\nF1PdGXpH7d8KPLt+fNAE/R7tFuCQ+jUfTXV4bvVOjuHe14+Iv6AKbOlB4TkoqbIC+Heqw3pLImIF\nMB+4qP7Oq51t92+AcyNimGpV9Eng18AZEdFD9SWPb5pg/5OBf4mIpcCvxtl+E9VhyGtHlf1z/Zqv\nBuYBb6m/Y2pn+n8m1c1rr6AKq00704i0M7xZrCSpSK6gpA5FxN5Ul6iPdVlmnvJg96ddETGb6vu8\nxsrM/JsHuz/SWK6gJElF8iIJSVKRDChJUpEMKElSkQwoSVKRDChJUpH+P3voiFJ7A9ckAAAAAElF\nTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x2de822d1358>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "fig = sns.distplot(df_train['item_condition_id'],kde=False,bins=5)\n",
    "fig.set_xticks(np.arange(1,6))\n",
    "fig.set_title('Distribution of Item Condition')\n",
    "plt.tight_layout()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df_train['tier_count'] = df_train['category_name'].dropna().apply(lambda x: len(x.split('/')))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "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>train_id</th>\n",
       "      <th>name</th>\n",
       "      <th>item_condition_id</th>\n",
       "      <th>category_name</th>\n",
       "      <th>brand_name</th>\n",
       "      <th>price</th>\n",
       "      <th>shipping</th>\n",
       "      <th>item_description</th>\n",
       "      <th>tier_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>MLB Cincinnati Reds T Shirt Size XL</td>\n",
       "      <td>3</td>\n",
       "      <td>Men/Tops/T-shirts</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1</td>\n",
       "      <td>No description yet</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Razer BlackWidow Chroma Keyboard</td>\n",
       "      <td>3</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/Components &amp; P...</td>\n",
       "      <td>Razer</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0</td>\n",
       "      <td>This keyboard is in great condition and works ...</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>AVA-VIV Blouse</td>\n",
       "      <td>1</td>\n",
       "      <td>Women/Tops &amp; Blouses/Blouse</td>\n",
       "      <td>Target</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Adorable top with a hint of lace and a key hol...</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Leather Horse Statues</td>\n",
       "      <td>1</td>\n",
       "      <td>Home/Home Décor/Home Décor Accents</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.0</td>\n",
       "      <td>1</td>\n",
       "      <td>New with tags. Leather horses. Retail for [rm]...</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>24K GOLD plated rose</td>\n",
       "      <td>1</td>\n",
       "      <td>Women/Jewelry/Necklaces</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Complete with certificate of authenticity</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   train_id                                 name  item_condition_id  \\\n",
       "0         0  MLB Cincinnati Reds T Shirt Size XL                  3   \n",
       "1         1     Razer BlackWidow Chroma Keyboard                  3   \n",
       "2         2                       AVA-VIV Blouse                  1   \n",
       "3         3                Leather Horse Statues                  1   \n",
       "4         4                 24K GOLD plated rose                  1   \n",
       "\n",
       "                                       category_name brand_name  price  \\\n",
       "0                                  Men/Tops/T-shirts        NaN   10.0   \n",
       "1  Electronics/Computers & Tablets/Components & P...      Razer   52.0   \n",
       "2                        Women/Tops & Blouses/Blouse     Target   10.0   \n",
       "3                 Home/Home Décor/Home Décor Accents        NaN   35.0   \n",
       "4                            Women/Jewelry/Necklaces        NaN   44.0   \n",
       "\n",
       "   shipping                                   item_description  tier_count  \n",
       "0         1                                 No description yet         3.0  \n",
       "1         0  This keyboard is in great condition and works ...         3.0  \n",
       "2         1  Adorable top with a hint of lace and a key hol...         3.0  \n",
       "3         1  New with tags. Leather horses. Retail for [rm]...         3.0  \n",
       "4         0          Complete with certificate of authenticity         3.0  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_train.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([  3.,  nan,   5.,   4.])"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_train.tier_count.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "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>train_id</th>\n",
       "      <th>name</th>\n",
       "      <th>item_condition_id</th>\n",
       "      <th>category_name</th>\n",
       "      <th>brand_name</th>\n",
       "      <th>price</th>\n",
       "      <th>shipping</th>\n",
       "      <th>item_description</th>\n",
       "      <th>tier_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>239</td>\n",
       "      <td>Zagg invisible shield for IPad air</td>\n",
       "      <td>1</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Zag invisible shield for IPad air</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>742</th>\n",
       "      <td>742</td>\n",
       "      <td>iPad Pro Smart Cover</td>\n",
       "      <td>2</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0</td>\n",
       "      <td>iPad Pro Smart Cover in Lilac Made for iPad Pr...</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1700</th>\n",
       "      <td>1700</td>\n",
       "      <td>LIKE NEW KOBO eReader Tablet Only [rm]!!</td>\n",
       "      <td>1</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Selling a tablet literally like new. No scratc...</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2828</th>\n",
       "      <td>2828</td>\n",
       "      <td>Leotard</td>\n",
       "      <td>3</td>\n",
       "      <td>Sports &amp; Outdoors/Exercise/Dance/Ballet</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Competition Leo. only worn once for one comp. ...</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2923</th>\n",
       "      <td>2923</td>\n",
       "      <td>Vuru tablet. 7 inch.</td>\n",
       "      <td>3</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Vuru tablet. Perfect for children. It does hav...</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      train_id                                      name  item_condition_id  \\\n",
       "239        239        Zagg invisible shield for IPad air                  1   \n",
       "742        742                      iPad Pro Smart Cover                  2   \n",
       "1700      1700  LIKE NEW KOBO eReader Tablet Only [rm]!!                  1   \n",
       "2828      2828                                   Leotard                  3   \n",
       "2923      2923                      Vuru tablet. 7 inch.                  3   \n",
       "\n",
       "                                          category_name brand_name  price  \\\n",
       "239   Electronics/Computers & Tablets/iPad/Tablet/eB...        NaN   10.0   \n",
       "742   Electronics/Computers & Tablets/iPad/Tablet/eB...        NaN   31.0   \n",
       "1700  Electronics/Computers & Tablets/iPad/Tablet/eB...        NaN   31.0   \n",
       "2828            Sports & Outdoors/Exercise/Dance/Ballet        NaN   30.0   \n",
       "2923  Electronics/Computers & Tablets/iPad/Tablet/eB...        NaN   26.0   \n",
       "\n",
       "      shipping                                   item_description  tier_count  \n",
       "239          1                  Zag invisible shield for IPad air         5.0  \n",
       "742          0  iPad Pro Smart Cover in Lilac Made for iPad Pr...         5.0  \n",
       "1700         0  Selling a tablet literally like new. No scratc...         5.0  \n",
       "2828         0  Competition Leo. only worn once for one comp. ...         4.0  \n",
       "2923         0  Vuru tablet. Perfect for children. It does hav...         5.0  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_train[df_train['tier_count']>3].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def split_tiers(cat):\n",
    "    try:\n",
    "        text = cat.split('/')\n",
    "        l = len(text)\n",
    "        \n",
    "        if l == 3:\n",
    "            txt1, txt2, txt3 = text\n",
    "            return txt1, txt2, txt3, np.nan, np.nan\n",
    "        elif l == 4:\n",
    "            txt1, txt2, txt3, txt4 = text\n",
    "            return txt1, txt2, txt3, txt4, np.nan\n",
    "        elif l == 5:\n",
    "            txt1, txt2, txt3, txt4, txt5 = text\n",
    "            return txt1, txt2, txt3, txt4, txt5\n",
    "        else:\n",
    "            return np.nan, np.nan, np.nan, np.nan, np.nan\n",
    "    except:\n",
    "        return np.nan, np.nan, np.nan, np.nan, np.nan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def split_tiers(cat):\n",
    "    if cat:\n",
    "        tiers = cat.split(sep='/')\n",
    "        while len(tiers) < 5:\n",
    "            tiers.append('No Label')\n",
    "    else:\n",
    "        tiers = ['No Label', 'No Label', 'No Label', 'No Label', 'No Label']\n",
    "    \n",
    "    return tiers[0], tiers[1], tiers[2], tiers[3], tiers[4]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df_train['tier1'], df_train['tier2'], df_train['tier3'], df_train['tier4'], df_train['tier5'] = \\\n",
    "zip(*df_train.category_name.apply(lambda val: split_tiers(val)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {
    "collapsed": false
   },
   "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>train_id</th>\n",
       "      <th>name</th>\n",
       "      <th>item_condition_id</th>\n",
       "      <th>category_name</th>\n",
       "      <th>brand_name</th>\n",
       "      <th>price</th>\n",
       "      <th>shipping</th>\n",
       "      <th>item_description</th>\n",
       "      <th>tier_count</th>\n",
       "      <th>tier1</th>\n",
       "      <th>tier2</th>\n",
       "      <th>tier3</th>\n",
       "      <th>tier4</th>\n",
       "      <th>tier5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>MLB Cincinnati Reds T Shirt Size XL</td>\n",
       "      <td>3</td>\n",
       "      <td>Men/Tops/T-shirts</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1</td>\n",
       "      <td>No description yet</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Men</td>\n",
       "      <td>Tops</td>\n",
       "      <td>T-shirts</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Razer BlackWidow Chroma Keyboard</td>\n",
       "      <td>3</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/Components &amp; P...</td>\n",
       "      <td>Razer</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0</td>\n",
       "      <td>This keyboard is in great condition and works ...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>Components &amp; Parts</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>AVA-VIV Blouse</td>\n",
       "      <td>1</td>\n",
       "      <td>Women/Tops &amp; Blouses/Blouse</td>\n",
       "      <td>Target</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Adorable top with a hint of lace and a key hol...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Women</td>\n",
       "      <td>Tops &amp; Blouses</td>\n",
       "      <td>Blouse</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Leather Horse Statues</td>\n",
       "      <td>1</td>\n",
       "      <td>Home/Home Décor/Home Décor Accents</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.0</td>\n",
       "      <td>1</td>\n",
       "      <td>New with tags. Leather horses. Retail for [rm]...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Home</td>\n",
       "      <td>Home Décor</td>\n",
       "      <td>Home Décor Accents</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>24K GOLD plated rose</td>\n",
       "      <td>1</td>\n",
       "      <td>Women/Jewelry/Necklaces</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Complete with certificate of authenticity</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Women</td>\n",
       "      <td>Jewelry</td>\n",
       "      <td>Necklaces</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   train_id                                 name  item_condition_id  \\\n",
       "0         0  MLB Cincinnati Reds T Shirt Size XL                  3   \n",
       "1         1     Razer BlackWidow Chroma Keyboard                  3   \n",
       "2         2                       AVA-VIV Blouse                  1   \n",
       "3         3                Leather Horse Statues                  1   \n",
       "4         4                 24K GOLD plated rose                  1   \n",
       "\n",
       "                                       category_name brand_name  price  \\\n",
       "0                                  Men/Tops/T-shirts        NaN   10.0   \n",
       "1  Electronics/Computers & Tablets/Components & P...      Razer   52.0   \n",
       "2                        Women/Tops & Blouses/Blouse     Target   10.0   \n",
       "3                 Home/Home Décor/Home Décor Accents        NaN   35.0   \n",
       "4                            Women/Jewelry/Necklaces        NaN   44.0   \n",
       "\n",
       "   shipping                                   item_description  tier_count  \\\n",
       "0         1                                 No description yet         3.0   \n",
       "1         0  This keyboard is in great condition and works ...         3.0   \n",
       "2         1  Adorable top with a hint of lace and a key hol...         3.0   \n",
       "3         1  New with tags. Leather horses. Retail for [rm]...         3.0   \n",
       "4         0          Complete with certificate of authenticity         3.0   \n",
       "\n",
       "         tier1                tier2               tier3 tier4 tier5  \n",
       "0          Men                 Tops            T-shirts   NaN   NaN  \n",
       "1  Electronics  Computers & Tablets  Components & Parts   NaN   NaN  \n",
       "2        Women       Tops & Blouses              Blouse   NaN   NaN  \n",
       "3         Home           Home Décor  Home Décor Accents   NaN   NaN  \n",
       "4        Women              Jewelry           Necklaces   NaN   NaN  "
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_train.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "train_id             1482535\n",
       "name                 1225273\n",
       "item_condition_id          5\n",
       "category_name           1287\n",
       "brand_name              4809\n",
       "price                    828\n",
       "shipping                   2\n",
       "item_description     1281426\n",
       "tier_count                 3\n",
       "tier1                     10\n",
       "tier2                    113\n",
       "tier3                    870\n",
       "tier4                      6\n",
       "tier5                      2\n",
       "dtype: int64"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_train.nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {
    "collapsed": false
   },
   "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>train_id</th>\n",
       "      <th>name</th>\n",
       "      <th>item_condition_id</th>\n",
       "      <th>category_name</th>\n",
       "      <th>brand_name</th>\n",
       "      <th>price</th>\n",
       "      <th>shipping</th>\n",
       "      <th>item_description</th>\n",
       "      <th>tier_count</th>\n",
       "      <th>tier1</th>\n",
       "      <th>tier2</th>\n",
       "      <th>tier3</th>\n",
       "      <th>tier4</th>\n",
       "      <th>tier5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>239</td>\n",
       "      <td>Zagg invisible shield for IPad air</td>\n",
       "      <td>1</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Zag invisible shield for IPad air</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>742</th>\n",
       "      <td>742</td>\n",
       "      <td>iPad Pro Smart Cover</td>\n",
       "      <td>2</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0</td>\n",
       "      <td>iPad Pro Smart Cover in Lilac Made for iPad Pr...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1700</th>\n",
       "      <td>1700</td>\n",
       "      <td>LIKE NEW KOBO eReader Tablet Only [rm]!!</td>\n",
       "      <td>1</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Selling a tablet literally like new. No scratc...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2828</th>\n",
       "      <td>2828</td>\n",
       "      <td>Leotard</td>\n",
       "      <td>3</td>\n",
       "      <td>Sports &amp; Outdoors/Exercise/Dance/Ballet</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Competition Leo. only worn once for one comp. ...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Sports &amp; Outdoors</td>\n",
       "      <td>Exercise</td>\n",
       "      <td>Dance</td>\n",
       "      <td>Ballet</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2923</th>\n",
       "      <td>2923</td>\n",
       "      <td>Vuru tablet. 7 inch.</td>\n",
       "      <td>3</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Vuru tablet. Perfect for children. It does hav...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3394</th>\n",
       "      <td>3394</td>\n",
       "      <td>iPod 1st generation 80gb</td>\n",
       "      <td>5</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Apple</td>\n",
       "      <td>20.0</td>\n",
       "      <td>1</td>\n",
       "      <td>For parts or repair</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Access</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3816</th>\n",
       "      <td>3816</td>\n",
       "      <td>30oz Yeti Rambler Cooler Tumbler Cup Mug</td>\n",
       "      <td>1</td>\n",
       "      <td>Sports &amp; Outdoors/Outdoors/Indoor/Outdoor Games</td>\n",
       "      <td>Yeti</td>\n",
       "      <td>22.0</td>\n",
       "      <td>1</td>\n",
       "      <td>The double-wall vacuum insulation keeps your b...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Sports &amp; Outdoors</td>\n",
       "      <td>Outdoors</td>\n",
       "      <td>Indoor</td>\n",
       "      <td>Outdoor Games</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3880</th>\n",
       "      <td>3880</td>\n",
       "      <td>iPad 6/iPad Air 2 Kid's Tablet case</td>\n",
       "      <td>1</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Keep the kid's busy during the summer Fits iPa...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Access</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4159</th>\n",
       "      <td>4159</td>\n",
       "      <td>iPod Touch</td>\n",
       "      <td>4</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Apple</td>\n",
       "      <td>19.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1st Gen iPod Touch Everything works No scratch...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4287</th>\n",
       "      <td>4287</td>\n",
       "      <td>Apple Wireless Keyboard</td>\n",
       "      <td>2</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Apple</td>\n",
       "      <td>26.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Apple Wireless Keyboard. Used twice. Includes ...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Access</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4783</th>\n",
       "      <td>4783</td>\n",
       "      <td>Tommy Hilfiger jacket large</td>\n",
       "      <td>3</td>\n",
       "      <td>Men/Coats &amp; Jackets/Varsity/Baseball</td>\n",
       "      <td>Tommy Hilfiger</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Tommy Hilfiger jacket Red Large Full zip</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Men</td>\n",
       "      <td>Coats &amp; Jackets</td>\n",
       "      <td>Varsity</td>\n",
       "      <td>Baseball</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5468</th>\n",
       "      <td>5468</td>\n",
       "      <td>iPad</td>\n",
       "      <td>2</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Apple</td>\n",
       "      <td>106.0</td>\n",
       "      <td>0</td>\n",
       "      <td>iPad in perfect condition! I just got a laptop...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Access</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5651</th>\n",
       "      <td>5651</td>\n",
       "      <td>Alcatel One Touch</td>\n",
       "      <td>2</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Samsung</td>\n",
       "      <td>30.0</td>\n",
       "      <td>1</td>\n",
       "      <td>T-Mobile Carrier Comes with leather case 9015w...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5819</th>\n",
       "      <td>5819</td>\n",
       "      <td>Bag for IPad, tablets, and netbooks.</td>\n",
       "      <td>1</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Targus</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Citygear mini for IPad, tablets, and netbooks....</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Access</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6569</th>\n",
       "      <td>6569</td>\n",
       "      <td>Empire Paintball Pod Belt</td>\n",
       "      <td>2</td>\n",
       "      <td>Sports &amp; Outdoors/Outdoors/Indoor/Outdoor Games</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Empire belt with 3 pods included. 2 - Java 1 -...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Sports &amp; Outdoors</td>\n",
       "      <td>Outdoors</td>\n",
       "      <td>Indoor</td>\n",
       "      <td>Outdoor Games</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6731</th>\n",
       "      <td>6731</td>\n",
       "      <td>Capezio XS ballet leotard</td>\n",
       "      <td>2</td>\n",
       "      <td>Sports &amp; Outdoors/Exercise/Dance/Ballet</td>\n",
       "      <td>Capezio</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Adorable back design on this capezio leotard.</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Sports &amp; Outdoors</td>\n",
       "      <td>Exercise</td>\n",
       "      <td>Dance</td>\n",
       "      <td>Ballet</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6900</th>\n",
       "      <td>6900</td>\n",
       "      <td>Barnes and Noble Nook</td>\n",
       "      <td>5</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0</td>\n",
       "      <td>I have no information on this nook! It needs a...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7109</th>\n",
       "      <td>7109</td>\n",
       "      <td>Capezio Footundeez Half Sole Dance Shoe</td>\n",
       "      <td>1</td>\n",
       "      <td>Sports &amp; Outdoors/Exercise/Dance/Ballet</td>\n",
       "      <td>Capezio</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Brand new never worn (I accidently ordered the...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Sports &amp; Outdoors</td>\n",
       "      <td>Exercise</td>\n",
       "      <td>Dance</td>\n",
       "      <td>Ballet</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7216</th>\n",
       "      <td>7216</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>2</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>AmazonBasics</td>\n",
       "      <td>34.0</td>\n",
       "      <td>1</td>\n",
       "      <td>I got this for Christmas but I have an iPhone ...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Access</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7734</th>\n",
       "      <td>7734</td>\n",
       "      <td>Kindle Fire HD 7 inch 8gb</td>\n",
       "      <td>3</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Kindle fire HD 7 inch HD display Wifi 8gb Prev...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8230</th>\n",
       "      <td>8230</td>\n",
       "      <td>Samsung galaxy tab 2 7.0</td>\n",
       "      <td>3</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Samsung</td>\n",
       "      <td>41.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Lightly used comes with charger and case works...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8329</th>\n",
       "      <td>8329</td>\n",
       "      <td>Apple iPad Air 16GB UNLOCKED</td>\n",
       "      <td>3</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Apple</td>\n",
       "      <td>141.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Clean iPad Air</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8507</th>\n",
       "      <td>8507</td>\n",
       "      <td>DK GRAY SUN WALL 10 by 10 COVER NIP</td>\n",
       "      <td>1</td>\n",
       "      <td>Sports &amp; Outdoors/Outdoors/Indoor/Outdoor Games</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16.0</td>\n",
       "      <td>1</td>\n",
       "      <td>BRAND NEW DARK GRAY TENT COVER 10' BY 10' FOR ...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Sports &amp; Outdoors</td>\n",
       "      <td>Outdoors</td>\n",
       "      <td>Indoor</td>\n",
       "      <td>Outdoor Games</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8698</th>\n",
       "      <td>8698</td>\n",
       "      <td>Tab</td>\n",
       "      <td>3</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Samsung</td>\n",
       "      <td>25.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Samsung galaxy tab 3 lite Wifi edition Storage...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Access</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8880</th>\n",
       "      <td>8880</td>\n",
       "      <td>Glass screen protector for IPad mini 2-3</td>\n",
       "      <td>1</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Glass screen protector for IPad mini 2 or 3</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9247</th>\n",
       "      <td>9247</td>\n",
       "      <td>Circo Girls Large Leotard and Shorts Gym</td>\n",
       "      <td>3</td>\n",
       "      <td>Sports &amp; Outdoors/Exercise/Dance/Ballet</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Circo girls large 10/12 leotard for gymnastics...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Sports &amp; Outdoors</td>\n",
       "      <td>Exercise</td>\n",
       "      <td>Dance</td>\n",
       "      <td>Ballet</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9513</th>\n",
       "      <td>9513</td>\n",
       "      <td>iPad 4/3/2 360 rotating case</td>\n",
       "      <td>1</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0</td>\n",
       "      <td>high quality case</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10263</th>\n",
       "      <td>10263</td>\n",
       "      <td>Apple Pencil Brand New</td>\n",
       "      <td>1</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Apple</td>\n",
       "      <td>88.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Got this with an iPad and would like to sell i...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10687</th>\n",
       "      <td>10687</td>\n",
       "      <td>Girls Bloch Ballet Leotard w/ skirt 8</td>\n",
       "      <td>3</td>\n",
       "      <td>Sports &amp; Outdoors/Exercise/Dance/Ballet</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Block black Skirted Leotard Size: 8/10 Very Go...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Sports &amp; Outdoors</td>\n",
       "      <td>Exercise</td>\n",
       "      <td>Dance</td>\n",
       "      <td>Ballet</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10692</th>\n",
       "      <td>10692</td>\n",
       "      <td>Hold for sherill</td>\n",
       "      <td>2</td>\n",
       "      <td>Sports &amp; Outdoors/Outdoors/Indoor/Outdoor Games</td>\n",
       "      <td>NaN</td>\n",
       "      <td>176.0</td>\n",
       "      <td>0</td>\n",
       "      <td>In near mint condition Everything works perfec...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Sports &amp; Outdoors</td>\n",
       "      <td>Outdoors</td>\n",
       "      <td>Indoor</td>\n",
       "      <td>Outdoor Games</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1474688</th>\n",
       "      <td>1474688</td>\n",
       "      <td>Brand New Plastic Uzi Spring BB Gun</td>\n",
       "      <td>1</td>\n",
       "      <td>Sports &amp; Outdoors/Outdoors/Indoor/Outdoor Games</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Free SHIPPING The Buyer Must be at least 18 ye...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Sports &amp; Outdoors</td>\n",
       "      <td>Outdoors</td>\n",
       "      <td>Indoor</td>\n",
       "      <td>Outdoor Games</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1474944</th>\n",
       "      <td>1474944</td>\n",
       "      <td>Wacom bamboo pad</td>\n",
       "      <td>3</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Wacom</td>\n",
       "      <td>26.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Works great a few small scratches. Comes with ...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1475752</th>\n",
       "      <td>1475752</td>\n",
       "      <td>Apple Pencil For iPad Pro</td>\n",
       "      <td>2</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Apple</td>\n",
       "      <td>75.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Opened box but never been used! Perfect condit...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1475810</th>\n",
       "      <td>1475810</td>\n",
       "      <td>Apple IPad 2</td>\n",
       "      <td>2</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Apple</td>\n",
       "      <td>123.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NWOT Apple iPad 2 - near perfect condition. In...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1476199</th>\n",
       "      <td>1476199</td>\n",
       "      <td>iPad Mini 4 64gb</td>\n",
       "      <td>2</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Apple</td>\n",
       "      <td>306.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Like new - barely used and looks brand new! Ha...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1476792</th>\n",
       "      <td>1476792</td>\n",
       "      <td>UKARMS BB</td>\n",
       "      <td>2</td>\n",
       "      <td>Sports &amp; Outdoors/Outdoors/Indoor/Outdoor Games</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1</td>\n",
       "      <td>~2,000 bbs</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Sports &amp; Outdoors</td>\n",
       "      <td>Outdoors</td>\n",
       "      <td>Indoor</td>\n",
       "      <td>Outdoor Games</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1476926</th>\n",
       "      <td>1476926</td>\n",
       "      <td>Deer camera</td>\n",
       "      <td>2</td>\n",
       "      <td>Sports &amp; Outdoors/Outdoors/Indoor/Outdoor Games</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Its completely new.</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Sports &amp; Outdoors</td>\n",
       "      <td>Outdoors</td>\n",
       "      <td>Indoor</td>\n",
       "      <td>Outdoor Games</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1477074</th>\n",
       "      <td>1477074</td>\n",
       "      <td>iPad Air 16 gb with otter box</td>\n",
       "      <td>3</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Apple</td>\n",
       "      <td>189.0</td>\n",
       "      <td>0</td>\n",
       "      <td>iPad has never been taken out of otterbox it's...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1477410</th>\n",
       "      <td>1477410</td>\n",
       "      <td>Verizon Ellipsis​ 7 4G LTE Wi-Fi Tablet</td>\n",
       "      <td>3</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Apple</td>\n",
       "      <td>30.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Hello Everyone I'm Selling Excellent condition...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1477466</th>\n",
       "      <td>1477466</td>\n",
       "      <td>Planet Eclipse Etek 3 Ego Paintball Gun</td>\n",
       "      <td>3</td>\n",
       "      <td>Sports &amp; Outdoors/Outdoors/Indoor/Outdoor Games</td>\n",
       "      <td>NaN</td>\n",
       "      <td>215.0</td>\n",
       "      <td>0</td>\n",
       "      <td>•For sell is a used Planet Eclipse Etek 3 Ego ...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Sports &amp; Outdoors</td>\n",
       "      <td>Outdoors</td>\n",
       "      <td>Indoor</td>\n",
       "      <td>Outdoor Games</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1477503</th>\n",
       "      <td>1477503</td>\n",
       "      <td>Ipad Mini Silver 16G With Several Cases</td>\n",
       "      <td>3</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>134.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Great Ipad, always it a case. Comes with s Blu...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1478170</th>\n",
       "      <td>1478170</td>\n",
       "      <td>Ipad Air (ACTIVATION LOCKED)</td>\n",
       "      <td>2</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Apple</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Like new Activation Locked 32gb memory Accepti...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1478179</th>\n",
       "      <td>1478179</td>\n",
       "      <td>Vipertek taser w free case</td>\n",
       "      <td>1</td>\n",
       "      <td>Sports &amp; Outdoors/Outdoors/Indoor/Outdoor Games</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1</td>\n",
       "      <td>High quality taser Available in pink purple an...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Sports &amp; Outdoors</td>\n",
       "      <td>Outdoors</td>\n",
       "      <td>Indoor</td>\n",
       "      <td>Outdoor Games</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1478722</th>\n",
       "      <td>1478722</td>\n",
       "      <td>Apple Pencil</td>\n",
       "      <td>1</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Apple</td>\n",
       "      <td>70.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Brand new never used. Comes with extra tip and...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Access</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1478821</th>\n",
       "      <td>1478821</td>\n",
       "      <td>iPad 2 ** price drop **</td>\n",
       "      <td>3</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Apple</td>\n",
       "      <td>121.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2nd generation iPad. White and silver. Engrave...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Access</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1479295</th>\n",
       "      <td>1479295</td>\n",
       "      <td>Flirty Girl Deluxe workout set</td>\n",
       "      <td>2</td>\n",
       "      <td>Sports &amp; Outdoors/Exercise/Dance/Ballet</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.0</td>\n",
       "      <td>1</td>\n",
       "      <td>7 dvd set that includes pole fitness workouts,...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Sports &amp; Outdoors</td>\n",
       "      <td>Exercise</td>\n",
       "      <td>Dance</td>\n",
       "      <td>Ballet</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1479390</th>\n",
       "      <td>1479390</td>\n",
       "      <td>Samsung Galaxy Tablet 3 ( WiFi ; 8GB )</td>\n",
       "      <td>2</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Samsung</td>\n",
       "      <td>61.0</td>\n",
       "      <td>0</td>\n",
       "      <td>no carrier, just wifi.</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1479433</th>\n",
       "      <td>1479433</td>\n",
       "      <td>iPad Air 2 64gb gold excellent cond</td>\n",
       "      <td>3</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Apple</td>\n",
       "      <td>330.0</td>\n",
       "      <td>1</td>\n",
       "      <td>iPad Air 2 64gb gold excellent condition with ...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Access</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1479934</th>\n",
       "      <td>1479934</td>\n",
       "      <td>Holding for boutiquebabe</td>\n",
       "      <td>2</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Apple</td>\n",
       "      <td>85.0</td>\n",
       "      <td>1</td>\n",
       "      <td>iPad Mini 1 32 GB condition: 9/10 No scratches...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1480610</th>\n",
       "      <td>1480610</td>\n",
       "      <td>❤️BOX ONLY for iPad Air 64gb White❤️</td>\n",
       "      <td>2</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Apple</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0</td>\n",
       "      <td>No description yet</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Access</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1480689</th>\n",
       "      <td>1480689</td>\n",
       "      <td>Samsung Galaxy tab 4 As is</td>\n",
       "      <td>3</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>56.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Barely used Works fine when charged the only p...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1480808</th>\n",
       "      <td>1480808</td>\n",
       "      <td>Coach iPad case</td>\n",
       "      <td>3</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>39.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Good condition</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Access</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1481211</th>\n",
       "      <td>1481211</td>\n",
       "      <td>Capezio tap shoes 8 1/2 w</td>\n",
       "      <td>3</td>\n",
       "      <td>Sports &amp; Outdoors/Exercise/Dance/Ballet</td>\n",
       "      <td>Capezio</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Good condition</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Sports &amp; Outdoors</td>\n",
       "      <td>Exercise</td>\n",
       "      <td>Dance</td>\n",
       "      <td>Ballet</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1481238</th>\n",
       "      <td>1481238</td>\n",
       "      <td>Kindle</td>\n",
       "      <td>2</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>AmazonBasics</td>\n",
       "      <td>24.0</td>\n",
       "      <td>0</td>\n",
       "      <td>No description yet</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1481848</th>\n",
       "      <td>1481848</td>\n",
       "      <td>Samsung Tab 3</td>\n",
       "      <td>2</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Samsung</td>\n",
       "      <td>35.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Hardly ever used. No damage still has screen p...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1482118</th>\n",
       "      <td>1482118</td>\n",
       "      <td>Men's bomber jacket</td>\n",
       "      <td>2</td>\n",
       "      <td>Men/Coats &amp; Jackets/Flight/Bomber</td>\n",
       "      <td>H&amp;M</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Size xlarge buts runs like a large it will als...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Men</td>\n",
       "      <td>Coats &amp; Jackets</td>\n",
       "      <td>Flight</td>\n",
       "      <td>Bomber</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1482266</th>\n",
       "      <td>1482266</td>\n",
       "      <td>Body Wrappers leotard</td>\n",
       "      <td>2</td>\n",
       "      <td>Sports &amp; Outdoors/Exercise/Dance/Ballet</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.0</td>\n",
       "      <td>0</td>\n",
       "      <td>•Black leotard with open back •Slightly used •...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Sports &amp; Outdoors</td>\n",
       "      <td>Exercise</td>\n",
       "      <td>Dance</td>\n",
       "      <td>Ballet</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1482283</th>\n",
       "      <td>1482283</td>\n",
       "      <td>Kindle Fire HD</td>\n",
       "      <td>3</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>AmazonBasics</td>\n",
       "      <td>51.0</td>\n",
       "      <td>0</td>\n",
       "      <td>This is a Kindle Fire HD. This is 7 inches. Wi...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Readers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1482387</th>\n",
       "      <td>1482387</td>\n",
       "      <td>IPAD PRO 8.7 INCH 32GB</td>\n",
       "      <td>1</td>\n",
       "      <td>Electronics/Computers &amp; Tablets/iPad/Tablet/eB...</td>\n",
       "      <td>Apple</td>\n",
       "      <td>509.0</td>\n",
       "      <td>0</td>\n",
       "      <td>BRAND NEW IN BOX NEVER OPEN ,IPAD PRO 32GB,8.9...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Computers &amp; Tablets</td>\n",
       "      <td>iPad</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>eBook Access</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1482442</th>\n",
       "      <td>1482442</td>\n",
       "      <td>Ballet leotard Mirella</td>\n",
       "      <td>2</td>\n",
       "      <td>Sports &amp; Outdoors/Exercise/Dance/Ballet</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Classic black Mirella Leo in a M Supportive br...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Sports &amp; Outdoors</td>\n",
       "      <td>Exercise</td>\n",
       "      <td>Dance</td>\n",
       "      <td>Ballet</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4389 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         train_id                                      name  \\\n",
       "239           239        Zagg invisible shield for IPad air   \n",
       "742           742                      iPad Pro Smart Cover   \n",
       "1700         1700  LIKE NEW KOBO eReader Tablet Only [rm]!!   \n",
       "2828         2828                                   Leotard   \n",
       "2923         2923                      Vuru tablet. 7 inch.   \n",
       "3394         3394                  iPod 1st generation 80gb   \n",
       "3816         3816  30oz Yeti Rambler Cooler Tumbler Cup Mug   \n",
       "3880         3880       iPad 6/iPad Air 2 Kid's Tablet case   \n",
       "4159         4159                                iPod Touch   \n",
       "4287         4287                   Apple Wireless Keyboard   \n",
       "4783         4783               Tommy Hilfiger jacket large   \n",
       "5468         5468                                      iPad   \n",
       "5651         5651                         Alcatel One Touch   \n",
       "5819         5819      Bag for IPad, tablets, and netbooks.   \n",
       "6569         6569                 Empire Paintball Pod Belt   \n",
       "6731         6731                 Capezio XS ballet leotard   \n",
       "6900         6900                     Barnes and Noble Nook   \n",
       "7109         7109   Capezio Footundeez Half Sole Dance Shoe   \n",
       "7216         7216                                    Tablet   \n",
       "7734         7734                 Kindle Fire HD 7 inch 8gb   \n",
       "8230         8230                  Samsung galaxy tab 2 7.0   \n",
       "8329         8329              Apple iPad Air 16GB UNLOCKED   \n",
       "8507         8507       DK GRAY SUN WALL 10 by 10 COVER NIP   \n",
       "8698         8698                                       Tab   \n",
       "8880         8880  Glass screen protector for IPad mini 2-3   \n",
       "9247         9247  Circo Girls Large Leotard and Shorts Gym   \n",
       "9513         9513              iPad 4/3/2 360 rotating case   \n",
       "10263       10263                    Apple Pencil Brand New   \n",
       "10687       10687     Girls Bloch Ballet Leotard w/ skirt 8   \n",
       "10692       10692                          Hold for sherill   \n",
       "...           ...                                       ...   \n",
       "1474688   1474688       Brand New Plastic Uzi Spring BB Gun   \n",
       "1474944   1474944                          Wacom bamboo pad   \n",
       "1475752   1475752                 Apple Pencil For iPad Pro   \n",
       "1475810   1475810                              Apple IPad 2   \n",
       "1476199   1476199                          iPad Mini 4 64gb   \n",
       "1476792   1476792                                 UKARMS BB   \n",
       "1476926   1476926                               Deer camera   \n",
       "1477074   1477074             iPad Air 16 gb with otter box   \n",
       "1477410   1477410   Verizon Ellipsis​ 7 4G LTE Wi-Fi Tablet   \n",
       "1477466   1477466   Planet Eclipse Etek 3 Ego Paintball Gun   \n",
       "1477503   1477503   Ipad Mini Silver 16G With Several Cases   \n",
       "1478170   1478170              Ipad Air (ACTIVATION LOCKED)   \n",
       "1478179   1478179                Vipertek taser w free case   \n",
       "1478722   1478722                              Apple Pencil   \n",
       "1478821   1478821                   iPad 2 ** price drop **   \n",
       "1479295   1479295            Flirty Girl Deluxe workout set   \n",
       "1479390   1479390    Samsung Galaxy Tablet 3 ( WiFi ; 8GB )   \n",
       "1479433   1479433       iPad Air 2 64gb gold excellent cond   \n",
       "1479934   1479934                  Holding for boutiquebabe   \n",
       "1480610   1480610      ❤️BOX ONLY for iPad Air 64gb White❤️   \n",
       "1480689   1480689                Samsung Galaxy tab 4 As is   \n",
       "1480808   1480808                           Coach iPad case   \n",
       "1481211   1481211                 Capezio tap shoes 8 1/2 w   \n",
       "1481238   1481238                                    Kindle   \n",
       "1481848   1481848                             Samsung Tab 3   \n",
       "1482118   1482118                       Men's bomber jacket   \n",
       "1482266   1482266                     Body Wrappers leotard   \n",
       "1482283   1482283                            Kindle Fire HD   \n",
       "1482387   1482387                    IPAD PRO 8.7 INCH 32GB   \n",
       "1482442   1482442                    Ballet leotard Mirella   \n",
       "\n",
       "         item_condition_id                                      category_name  \\\n",
       "239                      1  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "742                      2  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "1700                     1  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "2828                     3            Sports & Outdoors/Exercise/Dance/Ballet   \n",
       "2923                     3  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "3394                     5  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "3816                     1    Sports & Outdoors/Outdoors/Indoor/Outdoor Games   \n",
       "3880                     1  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "4159                     4  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "4287                     2  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "4783                     3               Men/Coats & Jackets/Varsity/Baseball   \n",
       "5468                     2  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "5651                     2  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "5819                     1  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "6569                     2    Sports & Outdoors/Outdoors/Indoor/Outdoor Games   \n",
       "6731                     2            Sports & Outdoors/Exercise/Dance/Ballet   \n",
       "6900                     5  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "7109                     1            Sports & Outdoors/Exercise/Dance/Ballet   \n",
       "7216                     2  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "7734                     3  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "8230                     3  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "8329                     3  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "8507                     1    Sports & Outdoors/Outdoors/Indoor/Outdoor Games   \n",
       "8698                     3  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "8880                     1  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "9247                     3            Sports & Outdoors/Exercise/Dance/Ballet   \n",
       "9513                     1  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "10263                    1  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "10687                    3            Sports & Outdoors/Exercise/Dance/Ballet   \n",
       "10692                    2    Sports & Outdoors/Outdoors/Indoor/Outdoor Games   \n",
       "...                    ...                                                ...   \n",
       "1474688                  1    Sports & Outdoors/Outdoors/Indoor/Outdoor Games   \n",
       "1474944                  3  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "1475752                  2  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "1475810                  2  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "1476199                  2  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "1476792                  2    Sports & Outdoors/Outdoors/Indoor/Outdoor Games   \n",
       "1476926                  2    Sports & Outdoors/Outdoors/Indoor/Outdoor Games   \n",
       "1477074                  3  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "1477410                  3  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "1477466                  3    Sports & Outdoors/Outdoors/Indoor/Outdoor Games   \n",
       "1477503                  3  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "1478170                  2  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "1478179                  1    Sports & Outdoors/Outdoors/Indoor/Outdoor Games   \n",
       "1478722                  1  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "1478821                  3  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "1479295                  2            Sports & Outdoors/Exercise/Dance/Ballet   \n",
       "1479390                  2  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "1479433                  3  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "1479934                  2  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "1480610                  2  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "1480689                  3  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "1480808                  3  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "1481211                  3            Sports & Outdoors/Exercise/Dance/Ballet   \n",
       "1481238                  2  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "1481848                  2  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "1482118                  2                  Men/Coats & Jackets/Flight/Bomber   \n",
       "1482266                  2            Sports & Outdoors/Exercise/Dance/Ballet   \n",
       "1482283                  3  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "1482387                  1  Electronics/Computers & Tablets/iPad/Tablet/eB...   \n",
       "1482442                  2            Sports & Outdoors/Exercise/Dance/Ballet   \n",
       "\n",
       "             brand_name  price  shipping  \\\n",
       "239                 NaN   10.0         1   \n",
       "742                 NaN   31.0         0   \n",
       "1700                NaN   31.0         0   \n",
       "2828                NaN   30.0         0   \n",
       "2923                NaN   26.0         0   \n",
       "3394              Apple   20.0         1   \n",
       "3816               Yeti   22.0         1   \n",
       "3880                NaN   12.0         1   \n",
       "4159              Apple   19.0         0   \n",
       "4287              Apple   26.0         0   \n",
       "4783     Tommy Hilfiger   20.0         0   \n",
       "5468              Apple  106.0         0   \n",
       "5651            Samsung   30.0         1   \n",
       "5819             Targus   10.0         1   \n",
       "6569                NaN   18.0         1   \n",
       "6731            Capezio   10.0         1   \n",
       "6900                NaN   11.0         0   \n",
       "7109            Capezio   18.0         0   \n",
       "7216       AmazonBasics   34.0         1   \n",
       "7734                NaN   36.0         0   \n",
       "8230            Samsung   41.0         0   \n",
       "8329              Apple  141.0         0   \n",
       "8507                NaN   16.0         1   \n",
       "8698            Samsung   25.0         1   \n",
       "8880                NaN    8.0         1   \n",
       "9247                NaN   14.0         0   \n",
       "9513                NaN   11.0         0   \n",
       "10263             Apple   88.0         1   \n",
       "10687               NaN   10.0         0   \n",
       "10692               NaN  176.0         0   \n",
       "...                 ...    ...       ...   \n",
       "1474688             NaN   15.0         1   \n",
       "1474944           Wacom   26.0         0   \n",
       "1475752           Apple   75.0         1   \n",
       "1475810           Apple  123.0         0   \n",
       "1476199           Apple  306.0         0   \n",
       "1476792             NaN   12.0         1   \n",
       "1476926             NaN   41.0         0   \n",
       "1477074           Apple  189.0         0   \n",
       "1477410           Apple   30.0         1   \n",
       "1477466             NaN  215.0         0   \n",
       "1477503             NaN  134.0         0   \n",
       "1478170           Apple   60.0         0   \n",
       "1478179             NaN   15.0         1   \n",
       "1478722           Apple   70.0         1   \n",
       "1478821           Apple  121.0         0   \n",
       "1479295             NaN   35.0         1   \n",
       "1479390         Samsung   61.0         0   \n",
       "1479433           Apple  330.0         1   \n",
       "1479934           Apple   85.0         1   \n",
       "1480610           Apple   14.0         0   \n",
       "1480689             NaN   56.0         0   \n",
       "1480808             NaN   39.0         0   \n",
       "1481211         Capezio    8.0         0   \n",
       "1481238    AmazonBasics   24.0         0   \n",
       "1481848         Samsung   35.0         1   \n",
       "1482118             H&M   18.0         0   \n",
       "1482266             NaN   21.0         0   \n",
       "1482283    AmazonBasics   51.0         0   \n",
       "1482387           Apple  509.0         0   \n",
       "1482442             NaN   22.0         0   \n",
       "\n",
       "                                          item_description  tier_count  \\\n",
       "239                      Zag invisible shield for IPad air         5.0   \n",
       "742      iPad Pro Smart Cover in Lilac Made for iPad Pr...         5.0   \n",
       "1700     Selling a tablet literally like new. No scratc...         5.0   \n",
       "2828     Competition Leo. only worn once for one comp. ...         4.0   \n",
       "2923     Vuru tablet. Perfect for children. It does hav...         5.0   \n",
       "3394                                   For parts or repair         5.0   \n",
       "3816     The double-wall vacuum insulation keeps your b...         4.0   \n",
       "3880     Keep the kid's busy during the summer Fits iPa...         5.0   \n",
       "4159     1st Gen iPod Touch Everything works No scratch...         5.0   \n",
       "4287     Apple Wireless Keyboard. Used twice. Includes ...         5.0   \n",
       "4783              Tommy Hilfiger jacket Red Large Full zip         4.0   \n",
       "5468     iPad in perfect condition! I just got a laptop...         5.0   \n",
       "5651     T-Mobile Carrier Comes with leather case 9015w...         5.0   \n",
       "5819     Citygear mini for IPad, tablets, and netbooks....         5.0   \n",
       "6569     Empire belt with 3 pods included. 2 - Java 1 -...         4.0   \n",
       "6731         Adorable back design on this capezio leotard.         4.0   \n",
       "6900     I have no information on this nook! It needs a...         5.0   \n",
       "7109     Brand new never worn (I accidently ordered the...         4.0   \n",
       "7216     I got this for Christmas but I have an iPhone ...         5.0   \n",
       "7734     Kindle fire HD 7 inch HD display Wifi 8gb Prev...         5.0   \n",
       "8230     Lightly used comes with charger and case works...         5.0   \n",
       "8329                                        Clean iPad Air         5.0   \n",
       "8507     BRAND NEW DARK GRAY TENT COVER 10' BY 10' FOR ...         4.0   \n",
       "8698     Samsung galaxy tab 3 lite Wifi edition Storage...         5.0   \n",
       "8880           Glass screen protector for IPad mini 2 or 3         5.0   \n",
       "9247     Circo girls large 10/12 leotard for gymnastics...         4.0   \n",
       "9513                                     high quality case         5.0   \n",
       "10263    Got this with an iPad and would like to sell i...         5.0   \n",
       "10687    Block black Skirted Leotard Size: 8/10 Very Go...         4.0   \n",
       "10692    In near mint condition Everything works perfec...         4.0   \n",
       "...                                                    ...         ...   \n",
       "1474688  Free SHIPPING The Buyer Must be at least 18 ye...         4.0   \n",
       "1474944  Works great a few small scratches. Comes with ...         5.0   \n",
       "1475752  Opened box but never been used! Perfect condit...         5.0   \n",
       "1475810  NWOT Apple iPad 2 - near perfect condition. In...         5.0   \n",
       "1476199  Like new - barely used and looks brand new! Ha...         5.0   \n",
       "1476792                                         ~2,000 bbs         4.0   \n",
       "1476926                                Its completely new.         4.0   \n",
       "1477074  iPad has never been taken out of otterbox it's...         5.0   \n",
       "1477410  Hello Everyone I'm Selling Excellent condition...         5.0   \n",
       "1477466  •For sell is a used Planet Eclipse Etek 3 Ego ...         4.0   \n",
       "1477503  Great Ipad, always it a case. Comes with s Blu...         5.0   \n",
       "1478170  Like new Activation Locked 32gb memory Accepti...         5.0   \n",
       "1478179  High quality taser Available in pink purple an...         4.0   \n",
       "1478722  Brand new never used. Comes with extra tip and...         5.0   \n",
       "1478821  2nd generation iPad. White and silver. Engrave...         5.0   \n",
       "1479295  7 dvd set that includes pole fitness workouts,...         4.0   \n",
       "1479390                             no carrier, just wifi.         5.0   \n",
       "1479433  iPad Air 2 64gb gold excellent condition with ...         5.0   \n",
       "1479934  iPad Mini 1 32 GB condition: 9/10 No scratches...         5.0   \n",
       "1480610                                 No description yet         5.0   \n",
       "1480689  Barely used Works fine when charged the only p...         5.0   \n",
       "1480808                                     Good condition         5.0   \n",
       "1481211                                     Good condition         4.0   \n",
       "1481238                                 No description yet         5.0   \n",
       "1481848  Hardly ever used. No damage still has screen p...         5.0   \n",
       "1482118  Size xlarge buts runs like a large it will als...         4.0   \n",
       "1482266  •Black leotard with open back •Slightly used •...         4.0   \n",
       "1482283  This is a Kindle Fire HD. This is 7 inches. Wi...         5.0   \n",
       "1482387  BRAND NEW IN BOX NEVER OPEN ,IPAD PRO 32GB,8.9...         5.0   \n",
       "1482442  Classic black Mirella Leo in a M Supportive br...         4.0   \n",
       "\n",
       "                     tier1                tier2    tier3          tier4  \\\n",
       "239            Electronics  Computers & Tablets     iPad         Tablet   \n",
       "742            Electronics  Computers & Tablets     iPad         Tablet   \n",
       "1700           Electronics  Computers & Tablets     iPad         Tablet   \n",
       "2828     Sports & Outdoors             Exercise    Dance         Ballet   \n",
       "2923           Electronics  Computers & Tablets     iPad         Tablet   \n",
       "3394           Electronics  Computers & Tablets     iPad         Tablet   \n",
       "3816     Sports & Outdoors             Outdoors   Indoor  Outdoor Games   \n",
       "3880           Electronics  Computers & Tablets     iPad         Tablet   \n",
       "4159           Electronics  Computers & Tablets     iPad         Tablet   \n",
       "4287           Electronics  Computers & Tablets     iPad         Tablet   \n",
       "4783                   Men      Coats & Jackets  Varsity       Baseball   \n",
       "5468           Electronics  Computers & Tablets     iPad         Tablet   \n",
       "5651           Electronics  Computers & Tablets     iPad         Tablet   \n",
       "5819           Electronics  Computers & Tablets     iPad         Tablet   \n",
       "6569     Sports & Outdoors             Outdoors   Indoor  Outdoor Games   \n",
       "6731     Sports & Outdoors             Exercise    Dance         Ballet   \n",
       "6900           Electronics  Computers & Tablets     iPad         Tablet   \n",
       "7109     Sports & Outdoors             Exercise    Dance         Ballet   \n",
       "7216           Electronics  Computers & Tablets     iPad         Tablet   \n",
       "7734           Electronics  Computers & Tablets     iPad         Tablet   \n",
       "8230           Electronics  Computers & Tablets     iPad         Tablet   \n",
       "8329           Electronics  Computers & Tablets     iPad         Tablet   \n",
       "8507     Sports & Outdoors             Outdoors   Indoor  Outdoor Games   \n",
       "8698           Electronics  Computers & Tablets     iPad         Tablet   \n",
       "8880           Electronics  Computers & Tablets     iPad         Tablet   \n",
       "9247     Sports & Outdoors             Exercise    Dance         Ballet   \n",
       "9513           Electronics  Computers & Tablets     iPad         Tablet   \n",
       "10263          Electronics  Computers & Tablets     iPad         Tablet   \n",
       "10687    Sports & Outdoors             Exercise    Dance         Ballet   \n",
       "10692    Sports & Outdoors             Outdoors   Indoor  Outdoor Games   \n",
       "...                    ...                  ...      ...            ...   \n",
       "1474688  Sports & Outdoors             Outdoors   Indoor  Outdoor Games   \n",
       "1474944        Electronics  Computers & Tablets     iPad         Tablet   \n",
       "1475752        Electronics  Computers & Tablets     iPad         Tablet   \n",
       "1475810        Electronics  Computers & Tablets     iPad         Tablet   \n",
       "1476199        Electronics  Computers & Tablets     iPad         Tablet   \n",
       "1476792  Sports & Outdoors             Outdoors   Indoor  Outdoor Games   \n",
       "1476926  Sports & Outdoors             Outdoors   Indoor  Outdoor Games   \n",
       "1477074        Electronics  Computers & Tablets     iPad         Tablet   \n",
       "1477410        Electronics  Computers & Tablets     iPad         Tablet   \n",
       "1477466  Sports & Outdoors             Outdoors   Indoor  Outdoor Games   \n",
       "1477503        Electronics  Computers & Tablets     iPad         Tablet   \n",
       "1478170        Electronics  Computers & Tablets     iPad         Tablet   \n",
       "1478179  Sports & Outdoors             Outdoors   Indoor  Outdoor Games   \n",
       "1478722        Electronics  Computers & Tablets     iPad         Tablet   \n",
       "1478821        Electronics  Computers & Tablets     iPad         Tablet   \n",
       "1479295  Sports & Outdoors             Exercise    Dance         Ballet   \n",
       "1479390        Electronics  Computers & Tablets     iPad         Tablet   \n",
       "1479433        Electronics  Computers & Tablets     iPad         Tablet   \n",
       "1479934        Electronics  Computers & Tablets     iPad         Tablet   \n",
       "1480610        Electronics  Computers & Tablets     iPad         Tablet   \n",
       "1480689        Electronics  Computers & Tablets     iPad         Tablet   \n",
       "1480808        Electronics  Computers & Tablets     iPad         Tablet   \n",
       "1481211  Sports & Outdoors             Exercise    Dance         Ballet   \n",
       "1481238        Electronics  Computers & Tablets     iPad         Tablet   \n",
       "1481848        Electronics  Computers & Tablets     iPad         Tablet   \n",
       "1482118                Men      Coats & Jackets   Flight         Bomber   \n",
       "1482266  Sports & Outdoors             Exercise    Dance         Ballet   \n",
       "1482283        Electronics  Computers & Tablets     iPad         Tablet   \n",
       "1482387        Electronics  Computers & Tablets     iPad         Tablet   \n",
       "1482442  Sports & Outdoors             Exercise    Dance         Ballet   \n",
       "\n",
       "                 tier5  \n",
       "239      eBook Readers  \n",
       "742      eBook Readers  \n",
       "1700     eBook Readers  \n",
       "2828               NaN  \n",
       "2923     eBook Readers  \n",
       "3394      eBook Access  \n",
       "3816               NaN  \n",
       "3880      eBook Access  \n",
       "4159     eBook Readers  \n",
       "4287      eBook Access  \n",
       "4783               NaN  \n",
       "5468      eBook Access  \n",
       "5651     eBook Readers  \n",
       "5819      eBook Access  \n",
       "6569               NaN  \n",
       "6731               NaN  \n",
       "6900     eBook Readers  \n",
       "7109               NaN  \n",
       "7216      eBook Access  \n",
       "7734     eBook Readers  \n",
       "8230     eBook Readers  \n",
       "8329     eBook Readers  \n",
       "8507               NaN  \n",
       "8698      eBook Access  \n",
       "8880     eBook Readers  \n",
       "9247               NaN  \n",
       "9513     eBook Readers  \n",
       "10263    eBook Readers  \n",
       "10687              NaN  \n",
       "10692              NaN  \n",
       "...                ...  \n",
       "1474688            NaN  \n",
       "1474944  eBook Readers  \n",
       "1475752  eBook Readers  \n",
       "1475810  eBook Readers  \n",
       "1476199  eBook Readers  \n",
       "1476792            NaN  \n",
       "1476926            NaN  \n",
       "1477074  eBook Readers  \n",
       "1477410  eBook Readers  \n",
       "1477466            NaN  \n",
       "1477503  eBook Readers  \n",
       "1478170  eBook Readers  \n",
       "1478179            NaN  \n",
       "1478722   eBook Access  \n",
       "1478821   eBook Access  \n",
       "1479295            NaN  \n",
       "1479390  eBook Readers  \n",
       "1479433   eBook Access  \n",
       "1479934  eBook Readers  \n",
       "1480610   eBook Access  \n",
       "1480689  eBook Readers  \n",
       "1480808   eBook Access  \n",
       "1481211            NaN  \n",
       "1481238  eBook Readers  \n",
       "1481848  eBook Readers  \n",
       "1482118            NaN  \n",
       "1482266            NaN  \n",
       "1482283  eBook Readers  \n",
       "1482387   eBook Access  \n",
       "1482442            NaN  \n",
       "\n",
       "[4389 rows x 14 columns]"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_train[df_train['tier4'].notnull()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [default]",
   "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.5.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}