trial.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>id</th>\n",
       "      <th>product_name</th>\n",
       "      <th>category</th>\n",
       "      <th>product_description</th>\n",
       "      <th>price</th>\n",
       "      <th>location</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>243809c0-9cfc-4486-ad12-3b7a16605ba9</td>\n",
       "      <td>Mirror wall art | in Wokingham, Berkshire | Gu...</td>\n",
       "      <td>Home &amp; Garden / Dining, Living Room Furniture ...</td>\n",
       "      <td>Mirror wall art. Posted by Nisha in Dining, Li...</td>\n",
       "      <td>£5.00</td>\n",
       "      <td>Wokingham, Berkshire</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1c58d3f9-8b93-47ea-9415-204fcc2a22e6</td>\n",
       "      <td>Stainless Steel Food Steamer | in Inverness, H...</td>\n",
       "      <td>Home &amp; Garden / Other Household Goods</td>\n",
       "      <td>Morphy Richard’s (model no 48755)Stainless ste...</td>\n",
       "      <td>£20.00</td>\n",
       "      <td>Inverness, Highland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>860673f1-57f6-47ba-8d2f-13f9e05b8f9a</td>\n",
       "      <td>Sun loungers | in Skegness, Lincolnshire | Gum...</td>\n",
       "      <td>Home &amp; Garden / Garden &amp; Patio / Outdoor Setti...</td>\n",
       "      <td>I have 2 of these - collection only as I don’t...</td>\n",
       "      <td>£20.00</td>\n",
       "      <td>Skegness, Lincolnshire</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>59948726-29be-4b35-ade5-bb2fd7331856</td>\n",
       "      <td>Coffee side table from Ammunition ammo box hai...</td>\n",
       "      <td>Home &amp; Garden / Dining, Living Room Furniture ...</td>\n",
       "      <td>Great reclaimed army ammunition box used as co...</td>\n",
       "      <td>£115.00</td>\n",
       "      <td>Radstock, Somerset</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>16dbc860-696e-4cda-93f6-4dd4926573fb</td>\n",
       "      <td>Modern Shannon Sofa for sale at low cost | in ...</td>\n",
       "      <td>Home &amp; Garden / Dining, Living Room Furniture ...</td>\n",
       "      <td>New Design Shannon Corner sofa  5 Seater Avail...</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11313</th>\n",
       "      <td>7151</td>\n",
       "      <td>c4148656-78a9-4f3e-b393-134fdc5ef900</td>\n",
       "      <td>Sony PlayStation VR Move Bundle | in Acocks Gr...</td>\n",
       "      <td>Video Games &amp; Consoles / Consoles / PS4 (Sony ...</td>\n",
       "      <td>Sony PlayStation VR Move Bundle353CASH ON COLL...</td>\n",
       "      <td>£260.00</td>\n",
       "      <td>Acocks Green, West Midlands</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11314</th>\n",
       "      <td>7152</td>\n",
       "      <td>564e3411-768d-4250-a624-b119d696f103</td>\n",
       "      <td>Playstation VR V2 Bundle | in Acocks Green, We...</td>\n",
       "      <td>Video Games &amp; Consoles / Consoles / PS4 (Sony ...</td>\n",
       "      <td>Playstation VR V2 Bundle355CASH ON COLLECTION ...</td>\n",
       "      <td>£235.00</td>\n",
       "      <td>Acocks Green, West Midlands</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11315</th>\n",
       "      <td>7153</td>\n",
       "      <td>2b0a652b-46a2-4297-b619-5efeeb222787</td>\n",
       "      <td>Oculus quest 2 256gb | in Montrose, Angus | Gu...</td>\n",
       "      <td>Video Games &amp; Consoles / Other Video Games &amp; C...</td>\n",
       "      <td>Pick up only £250Comes with two pistols stocks...</td>\n",
       "      <td>£250.00</td>\n",
       "      <td>Montrose, Angus</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11316</th>\n",
       "      <td>7154</td>\n",
       "      <td>719fd40a-870e-4144-b324-55dff2e66fb4</td>\n",
       "      <td>Logitech driving force shifter | in Carrickfer...</td>\n",
       "      <td>Video Games &amp; Consoles / Video Game Accessorie...</td>\n",
       "      <td>Bought at christmas from currys retailing at £...</td>\n",
       "      <td>£30.00</td>\n",
       "      <td>Carrickfergus, County Antrim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11317</th>\n",
       "      <td>7155</td>\n",
       "      <td>86d1806b-5575-4a7e-9160-f24f12be6c95</td>\n",
       "      <td>20 GAMES &amp; NINTENDO SWITCH BUNDLE | in Poole, ...</td>\n",
       "      <td>Video Games &amp; Consoles / Games</td>\n",
       "      <td>Nintendo Switch console only used 2/3 times. A...</td>\n",
       "      <td>£450.00</td>\n",
       "      <td>Poole, Dorset</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11318 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0                                    id  \\\n",
       "0              0  243809c0-9cfc-4486-ad12-3b7a16605ba9   \n",
       "1              1  1c58d3f9-8b93-47ea-9415-204fcc2a22e6   \n",
       "2              2  860673f1-57f6-47ba-8d2f-13f9e05b8f9a   \n",
       "3              3  59948726-29be-4b35-ade5-bb2fd7331856   \n",
       "4              4  16dbc860-696e-4cda-93f6-4dd4926573fb   \n",
       "...          ...                                   ...   \n",
       "11313       7151  c4148656-78a9-4f3e-b393-134fdc5ef900   \n",
       "11314       7152  564e3411-768d-4250-a624-b119d696f103   \n",
       "11315       7153  2b0a652b-46a2-4297-b619-5efeeb222787   \n",
       "11316       7154  719fd40a-870e-4144-b324-55dff2e66fb4   \n",
       "11317       7155  86d1806b-5575-4a7e-9160-f24f12be6c95   \n",
       "\n",
       "                                            product_name  \\\n",
       "0      Mirror wall art | in Wokingham, Berkshire | Gu...   \n",
       "1      Stainless Steel Food Steamer | in Inverness, H...   \n",
       "2      Sun loungers | in Skegness, Lincolnshire | Gum...   \n",
       "3      Coffee side table from Ammunition ammo box hai...   \n",
       "4      Modern Shannon Sofa for sale at low cost | in ...   \n",
       "...                                                  ...   \n",
       "11313  Sony PlayStation VR Move Bundle | in Acocks Gr...   \n",
       "11314  Playstation VR V2 Bundle | in Acocks Green, We...   \n",
       "11315  Oculus quest 2 256gb | in Montrose, Angus | Gu...   \n",
       "11316  Logitech driving force shifter | in Carrickfer...   \n",
       "11317  20 GAMES & NINTENDO SWITCH BUNDLE | in Poole, ...   \n",
       "\n",
       "                                                category  \\\n",
       "0      Home & Garden / Dining, Living Room Furniture ...   \n",
       "1                  Home & Garden / Other Household Goods   \n",
       "2      Home & Garden / Garden & Patio / Outdoor Setti...   \n",
       "3      Home & Garden / Dining, Living Room Furniture ...   \n",
       "4      Home & Garden / Dining, Living Room Furniture ...   \n",
       "...                                                  ...   \n",
       "11313  Video Games & Consoles / Consoles / PS4 (Sony ...   \n",
       "11314  Video Games & Consoles / Consoles / PS4 (Sony ...   \n",
       "11315  Video Games & Consoles / Other Video Games & C...   \n",
       "11316  Video Games & Consoles / Video Game Accessorie...   \n",
       "11317                     Video Games & Consoles / Games   \n",
       "\n",
       "                                     product_description    price  \\\n",
       "0      Mirror wall art. Posted by Nisha in Dining, Li...    £5.00   \n",
       "1      Morphy Richard’s (model no 48755)Stainless ste...   £20.00   \n",
       "2      I have 2 of these - collection only as I don’t...   £20.00   \n",
       "3      Great reclaimed army ammunition box used as co...  £115.00   \n",
       "4      New Design Shannon Corner sofa  5 Seater Avail...      NaN   \n",
       "...                                                  ...      ...   \n",
       "11313  Sony PlayStation VR Move Bundle353CASH ON COLL...  £260.00   \n",
       "11314  Playstation VR V2 Bundle355CASH ON COLLECTION ...  £235.00   \n",
       "11315  Pick up only £250Comes with two pistols stocks...  £250.00   \n",
       "11316  Bought at christmas from currys retailing at £...   £30.00   \n",
       "11317  Nintendo Switch console only used 2/3 times. A...  £450.00   \n",
       "\n",
       "                           location  \n",
       "0              Wokingham, Berkshire  \n",
       "1               Inverness, Highland  \n",
       "2            Skegness, Lincolnshire  \n",
       "3                Radstock, Somerset  \n",
       "4                               NaN  \n",
       "...                             ...  \n",
       "11313   Acocks Green, West Midlands  \n",
       "11314   Acocks Green, West Midlands  \n",
       "11315               Montrose, Angus  \n",
       "11316  Carrickfergus, County Antrim  \n",
       "11317                 Poole, Dorset  \n",
       "\n",
       "[11318 rows x 7 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import csv\n",
    "import pandas as pd \n",
    "\n",
    "dframe = pd.read_csv(\"/Users/macbook/Downloads/Products.csv\")\n",
    "dframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>product_name</th>\n",
       "      <th>category</th>\n",
       "      <th>product_description</th>\n",
       "      <th>price</th>\n",
       "      <th>location</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>243809c0-9cfc-4486-ad12-3b7a16605ba9</td>\n",
       "      <td>Mirror wall art | in Wokingham, Berkshire | Gu...</td>\n",
       "      <td>Home &amp; Garden / Dining, Living Room Furniture ...</td>\n",
       "      <td>Mirror wall art. Posted by Nisha in Dining, Li...</td>\n",
       "      <td>£5.00</td>\n",
       "      <td>Wokingham, Berkshire</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1c58d3f9-8b93-47ea-9415-204fcc2a22e6</td>\n",
       "      <td>Stainless Steel Food Steamer | in Inverness, H...</td>\n",
       "      <td>Home &amp; Garden / Other Household Goods</td>\n",
       "      <td>Morphy Richard’s (model no 48755)Stainless ste...</td>\n",
       "      <td>£20.00</td>\n",
       "      <td>Inverness, Highland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>860673f1-57f6-47ba-8d2f-13f9e05b8f9a</td>\n",
       "      <td>Sun loungers | in Skegness, Lincolnshire | Gum...</td>\n",
       "      <td>Home &amp; Garden / Garden &amp; Patio / Outdoor Setti...</td>\n",
       "      <td>I have 2 of these - collection only as I don’t...</td>\n",
       "      <td>£20.00</td>\n",
       "      <td>Skegness, Lincolnshire</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>59948726-29be-4b35-ade5-bb2fd7331856</td>\n",
       "      <td>Coffee side table from Ammunition ammo box hai...</td>\n",
       "      <td>Home &amp; Garden / Dining, Living Room Furniture ...</td>\n",
       "      <td>Great reclaimed army ammunition box used as co...</td>\n",
       "      <td>£115.00</td>\n",
       "      <td>Radstock, Somerset</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5707be4f-49d9-4feb-b2c8-aa0868405c65</td>\n",
       "      <td>Spotlights | in Newent, Gloucestershire | Gumtree</td>\n",
       "      <td>Home &amp; Garden / Other Household Goods</td>\n",
       "      <td>New in box not needed Spotlights . Posted by s...</td>\n",
       "      <td>£9.00</td>\n",
       "      <td>Newent, Gloucestershire</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7151</th>\n",
       "      <td>c4148656-78a9-4f3e-b393-134fdc5ef900</td>\n",
       "      <td>Sony PlayStation VR Move Bundle | in Acocks Gr...</td>\n",
       "      <td>Video Games &amp; Consoles / Consoles / PS4 (Sony ...</td>\n",
       "      <td>Sony PlayStation VR Move Bundle353CASH ON COLL...</td>\n",
       "      <td>£260.00</td>\n",
       "      <td>Acocks Green, West Midlands</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7152</th>\n",
       "      <td>564e3411-768d-4250-a624-b119d696f103</td>\n",
       "      <td>Playstation VR V2 Bundle | in Acocks Green, We...</td>\n",
       "      <td>Video Games &amp; Consoles / Consoles / PS4 (Sony ...</td>\n",
       "      <td>Playstation VR V2 Bundle355CASH ON COLLECTION ...</td>\n",
       "      <td>£235.00</td>\n",
       "      <td>Acocks Green, West Midlands</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7153</th>\n",
       "      <td>2b0a652b-46a2-4297-b619-5efeeb222787</td>\n",
       "      <td>Oculus quest 2 256gb | in Montrose, Angus | Gu...</td>\n",
       "      <td>Video Games &amp; Consoles / Other Video Games &amp; C...</td>\n",
       "      <td>Pick up only £250Comes with two pistols stocks...</td>\n",
       "      <td>£250.00</td>\n",
       "      <td>Montrose, Angus</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7154</th>\n",
       "      <td>719fd40a-870e-4144-b324-55dff2e66fb4</td>\n",
       "      <td>Logitech driving force shifter | in Carrickfer...</td>\n",
       "      <td>Video Games &amp; Consoles / Video Game Accessorie...</td>\n",
       "      <td>Bought at christmas from currys retailing at £...</td>\n",
       "      <td>£30.00</td>\n",
       "      <td>Carrickfergus, County Antrim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7155</th>\n",
       "      <td>86d1806b-5575-4a7e-9160-f24f12be6c95</td>\n",
       "      <td>20 GAMES &amp; NINTENDO SWITCH BUNDLE | in Poole, ...</td>\n",
       "      <td>Video Games &amp; Consoles / Games</td>\n",
       "      <td>Nintendo Switch console only used 2/3 times. A...</td>\n",
       "      <td>£450.00</td>\n",
       "      <td>Poole, Dorset</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6311 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        id  \\\n",
       "0     243809c0-9cfc-4486-ad12-3b7a16605ba9   \n",
       "1     1c58d3f9-8b93-47ea-9415-204fcc2a22e6   \n",
       "2     860673f1-57f6-47ba-8d2f-13f9e05b8f9a   \n",
       "3     59948726-29be-4b35-ade5-bb2fd7331856   \n",
       "5     5707be4f-49d9-4feb-b2c8-aa0868405c65   \n",
       "...                                    ...   \n",
       "7151  c4148656-78a9-4f3e-b393-134fdc5ef900   \n",
       "7152  564e3411-768d-4250-a624-b119d696f103   \n",
       "7153  2b0a652b-46a2-4297-b619-5efeeb222787   \n",
       "7154  719fd40a-870e-4144-b324-55dff2e66fb4   \n",
       "7155  86d1806b-5575-4a7e-9160-f24f12be6c95   \n",
       "\n",
       "                                           product_name  \\\n",
       "0     Mirror wall art | in Wokingham, Berkshire | Gu...   \n",
       "1     Stainless Steel Food Steamer | in Inverness, H...   \n",
       "2     Sun loungers | in Skegness, Lincolnshire | Gum...   \n",
       "3     Coffee side table from Ammunition ammo box hai...   \n",
       "5     Spotlights | in Newent, Gloucestershire | Gumtree   \n",
       "...                                                 ...   \n",
       "7151  Sony PlayStation VR Move Bundle | in Acocks Gr...   \n",
       "7152  Playstation VR V2 Bundle | in Acocks Green, We...   \n",
       "7153  Oculus quest 2 256gb | in Montrose, Angus | Gu...   \n",
       "7154  Logitech driving force shifter | in Carrickfer...   \n",
       "7155  20 GAMES & NINTENDO SWITCH BUNDLE | in Poole, ...   \n",
       "\n",
       "                                               category  \\\n",
       "0     Home & Garden / Dining, Living Room Furniture ...   \n",
       "1                 Home & Garden / Other Household Goods   \n",
       "2     Home & Garden / Garden & Patio / Outdoor Setti...   \n",
       "3     Home & Garden / Dining, Living Room Furniture ...   \n",
       "5                 Home & Garden / Other Household Goods   \n",
       "...                                                 ...   \n",
       "7151  Video Games & Consoles / Consoles / PS4 (Sony ...   \n",
       "7152  Video Games & Consoles / Consoles / PS4 (Sony ...   \n",
       "7153  Video Games & Consoles / Other Video Games & C...   \n",
       "7154  Video Games & Consoles / Video Game Accessorie...   \n",
       "7155                     Video Games & Consoles / Games   \n",
       "\n",
       "                                    product_description    price  \\\n",
       "0     Mirror wall art. Posted by Nisha in Dining, Li...    £5.00   \n",
       "1     Morphy Richard’s (model no 48755)Stainless ste...   £20.00   \n",
       "2     I have 2 of these - collection only as I don’t...   £20.00   \n",
       "3     Great reclaimed army ammunition box used as co...  £115.00   \n",
       "5     New in box not needed Spotlights . Posted by s...    £9.00   \n",
       "...                                                 ...      ...   \n",
       "7151  Sony PlayStation VR Move Bundle353CASH ON COLL...  £260.00   \n",
       "7152  Playstation VR V2 Bundle355CASH ON COLLECTION ...  £235.00   \n",
       "7153  Pick up only £250Comes with two pistols stocks...  £250.00   \n",
       "7154  Bought at christmas from currys retailing at £...   £30.00   \n",
       "7155  Nintendo Switch console only used 2/3 times. A...  £450.00   \n",
       "\n",
       "                          location  \n",
       "0             Wokingham, Berkshire  \n",
       "1              Inverness, Highland  \n",
       "2           Skegness, Lincolnshire  \n",
       "3               Radstock, Somerset  \n",
       "5          Newent, Gloucestershire  \n",
       "...                            ...  \n",
       "7151   Acocks Green, West Midlands  \n",
       "7152   Acocks Green, West Midlands  \n",
       "7153               Montrose, Angus  \n",
       "7154  Carrickfergus, County Antrim  \n",
       "7155                 Poole, Dorset  \n",
       "\n",
       "[6311 rows x 6 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd \n",
    "dframe = pd.read_csv(\"/Users/macbook/Downloads/Products.csv\", index_col=0)\n",
    "dframe.dropna(axis='index', how='any', inplace=True)\n",
    "dframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0          £5.00\n",
       "1         £20.00\n",
       "2         £20.00\n",
       "3        £115.00\n",
       "4            NaN\n",
       "          ...   \n",
       "11313    £260.00\n",
       "11314    £235.00\n",
       "11315    £250.00\n",
       "11316     £30.00\n",
       "11317    £450.00\n",
       "Name: price, Length: 11318, dtype: object"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dframe.loc[:, 'price']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>price</th>\n",
       "      <th>location</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>£100.00</td>\n",
       "      <td>Quedgeley, Gloucestershire</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>£160.00</td>\n",
       "      <td>Stevenage, Hertfordshire</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>£7.00</td>\n",
       "      <td>Redruth, Cornwall</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>£3.00</td>\n",
       "      <td>Grange, Edinburgh</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      price                    location\n",
       "26  £100.00  Quedgeley, Gloucestershire\n",
       "27      NaN                         NaN\n",
       "28      NaN                         NaN\n",
       "29  £160.00    Stevenage, Hertfordshire\n",
       "30    £7.00           Redruth, Cornwall\n",
       "31    £3.00           Grange, Edinburgh"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dframe.loc[26:31, ['price', 'location']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>id</th>\n",
       "      <th>product_name</th>\n",
       "      <th>category</th>\n",
       "      <th>product_description</th>\n",
       "      <th>price</th>\n",
       "      <th>location</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11313</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11314</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11315</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11316</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11317</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11318 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0     id  product_name  category  product_description  price  \\\n",
       "0           False  False         False     False                False  False   \n",
       "1           False  False         False     False                False  False   \n",
       "2           False  False         False     False                False  False   \n",
       "3           False  False         False     False                False  False   \n",
       "4           False  False         False     False                False   True   \n",
       "...           ...    ...           ...       ...                  ...    ...   \n",
       "11313       False  False         False     False                False  False   \n",
       "11314       False  False         False     False                False  False   \n",
       "11315       False  False         False     False                False  False   \n",
       "11316       False  False         False     False                False  False   \n",
       "11317       False  False         False     False                False  False   \n",
       "\n",
       "       location  \n",
       "0         False  \n",
       "1         False  \n",
       "2         False  \n",
       "3         False  \n",
       "4          True  \n",
       "...         ...  \n",
       "11313     False  \n",
       "11314     False  \n",
       "11315     False  \n",
       "11316     False  \n",
       "11317     False  \n",
       "\n",
       "[11318 rows x 7 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dframe.isna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>price</th>\n",
       "      <th>location</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    price  location\n",
       "26  False     False\n",
       "27   True      True\n",
       "28   True      True\n",
       "29  False     False\n",
       "30  False     False\n",
       "31  False     False"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dframe.loc[26:31, ['price', 'location']].isna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>price</th>\n",
       "      <th>location</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>272</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274</th>\n",
       "      <td>£80.00</td>\n",
       "      <td>Haverfordwest, Pembrokeshire</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>275</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277</th>\n",
       "      <td>£30.00</td>\n",
       "      <td>County Antrim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>£180.00</td>\n",
       "      <td>Crowthorne, Berkshire</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>£70.00</td>\n",
       "      <td>Norwich, Norfolk</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>280</th>\n",
       "      <td>£10.00</td>\n",
       "      <td>Ilkeston, Derbyshire</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>283</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       price                      location\n",
       "272      NaN                           NaN\n",
       "273      NaN                           NaN\n",
       "274   £80.00  Haverfordwest, Pembrokeshire\n",
       "275      NaN                           NaN\n",
       "276      NaN                           NaN\n",
       "277   £30.00                 County Antrim\n",
       "278  £180.00         Crowthorne, Berkshire\n",
       "279   £70.00              Norwich, Norfolk\n",
       "280   £10.00          Ilkeston, Derbyshire\n",
       "281      NaN                           NaN\n",
       "282      NaN                           NaN\n",
       "283      NaN                           NaN\n",
       "284      NaN                           NaN\n",
       "285      NaN                           NaN"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dframe.loc[272:285, ['price', 'location']]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "dropna method will clean your data up no worries."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.feature_extraction.text import TfidfVectorizer\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>id</th>\n",
       "      <th>product_name</th>\n",
       "      <th>category</th>\n",
       "      <th>product_description</th>\n",
       "      <th>price</th>\n",
       "      <th>location</th>\n",
       "      <th>vectorised product names</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>243809c0-9cfc-4486-ad12-3b7a16605ba9</td>\n",
       "      <td>Mirror wall art | in Wokingham, Berkshire | Gu...</td>\n",
       "      <td>Home &amp; Garden / Dining, Living Room Furniture ...</td>\n",
       "      <td>Mirror wall art. Posted by Nisha in Dining, Li...</td>\n",
       "      <td>£5.00</td>\n",
       "      <td>Wokingham, Berkshire</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1c58d3f9-8b93-47ea-9415-204fcc2a22e6</td>\n",
       "      <td>Stainless Steel Food Steamer | in Inverness, H...</td>\n",
       "      <td>Home &amp; Garden / Other Household Goods</td>\n",
       "      <td>Morphy Richard’s (model no 48755)Stainless ste...</td>\n",
       "      <td>£20.00</td>\n",
       "      <td>Inverness, Highland</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>860673f1-57f6-47ba-8d2f-13f9e05b8f9a</td>\n",
       "      <td>Sun loungers | in Skegness, Lincolnshire | Gum...</td>\n",
       "      <td>Home &amp; Garden / Garden &amp; Patio / Outdoor Setti...</td>\n",
       "      <td>I have 2 of these - collection only as I don’t...</td>\n",
       "      <td>£20.00</td>\n",
       "      <td>Skegness, Lincolnshire</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>59948726-29be-4b35-ade5-bb2fd7331856</td>\n",
       "      <td>Coffee side table from Ammunition ammo box hai...</td>\n",
       "      <td>Home &amp; Garden / Dining, Living Room Furniture ...</td>\n",
       "      <td>Great reclaimed army ammunition box used as co...</td>\n",
       "      <td>£115.00</td>\n",
       "      <td>Radstock, Somerset</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>5</td>\n",
       "      <td>5707be4f-49d9-4feb-b2c8-aa0868405c65</td>\n",
       "      <td>Spotlights | in Newent, Gloucestershire | Gumtree</td>\n",
       "      <td>Home &amp; Garden / Other Household Goods</td>\n",
       "      <td>New in box not needed Spotlights . Posted by s...</td>\n",
       "      <td>£9.00</td>\n",
       "      <td>Newent, Gloucestershire</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11313</th>\n",
       "      <td>7151</td>\n",
       "      <td>c4148656-78a9-4f3e-b393-134fdc5ef900</td>\n",
       "      <td>Sony PlayStation VR Move Bundle | in Acocks Gr...</td>\n",
       "      <td>Video Games &amp; Consoles / Consoles / PS4 (Sony ...</td>\n",
       "      <td>Sony PlayStation VR Move Bundle353CASH ON COLL...</td>\n",
       "      <td>£260.00</td>\n",
       "      <td>Acocks Green, West Midlands</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11314</th>\n",
       "      <td>7152</td>\n",
       "      <td>564e3411-768d-4250-a624-b119d696f103</td>\n",
       "      <td>Playstation VR V2 Bundle | in Acocks Green, We...</td>\n",
       "      <td>Video Games &amp; Consoles / Consoles / PS4 (Sony ...</td>\n",
       "      <td>Playstation VR V2 Bundle355CASH ON COLLECTION ...</td>\n",
       "      <td>£235.00</td>\n",
       "      <td>Acocks Green, West Midlands</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11315</th>\n",
       "      <td>7153</td>\n",
       "      <td>2b0a652b-46a2-4297-b619-5efeeb222787</td>\n",
       "      <td>Oculus quest 2 256gb | in Montrose, Angus | Gu...</td>\n",
       "      <td>Video Games &amp; Consoles / Other Video Games &amp; C...</td>\n",
       "      <td>Pick up only £250Comes with two pistols stocks...</td>\n",
       "      <td>£250.00</td>\n",
       "      <td>Montrose, Angus</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11316</th>\n",
       "      <td>7154</td>\n",
       "      <td>719fd40a-870e-4144-b324-55dff2e66fb4</td>\n",
       "      <td>Logitech driving force shifter | in Carrickfer...</td>\n",
       "      <td>Video Games &amp; Consoles / Video Game Accessorie...</td>\n",
       "      <td>Bought at christmas from currys retailing at £...</td>\n",
       "      <td>£30.00</td>\n",
       "      <td>Carrickfergus, County Antrim</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11317</th>\n",
       "      <td>7155</td>\n",
       "      <td>86d1806b-5575-4a7e-9160-f24f12be6c95</td>\n",
       "      <td>20 GAMES &amp; NINTENDO SWITCH BUNDLE | in Poole, ...</td>\n",
       "      <td>Video Games &amp; Consoles / Games</td>\n",
       "      <td>Nintendo Switch console only used 2/3 times. A...</td>\n",
       "      <td>£450.00</td>\n",
       "      <td>Poole, Dorset</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6311 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0                                    id  \\\n",
       "0              0  243809c0-9cfc-4486-ad12-3b7a16605ba9   \n",
       "1              1  1c58d3f9-8b93-47ea-9415-204fcc2a22e6   \n",
       "2              2  860673f1-57f6-47ba-8d2f-13f9e05b8f9a   \n",
       "3              3  59948726-29be-4b35-ade5-bb2fd7331856   \n",
       "12             5  5707be4f-49d9-4feb-b2c8-aa0868405c65   \n",
       "...          ...                                   ...   \n",
       "11313       7151  c4148656-78a9-4f3e-b393-134fdc5ef900   \n",
       "11314       7152  564e3411-768d-4250-a624-b119d696f103   \n",
       "11315       7153  2b0a652b-46a2-4297-b619-5efeeb222787   \n",
       "11316       7154  719fd40a-870e-4144-b324-55dff2e66fb4   \n",
       "11317       7155  86d1806b-5575-4a7e-9160-f24f12be6c95   \n",
       "\n",
       "                                            product_name  \\\n",
       "0      Mirror wall art | in Wokingham, Berkshire | Gu...   \n",
       "1      Stainless Steel Food Steamer | in Inverness, H...   \n",
       "2      Sun loungers | in Skegness, Lincolnshire | Gum...   \n",
       "3      Coffee side table from Ammunition ammo box hai...   \n",
       "12     Spotlights | in Newent, Gloucestershire | Gumtree   \n",
       "...                                                  ...   \n",
       "11313  Sony PlayStation VR Move Bundle | in Acocks Gr...   \n",
       "11314  Playstation VR V2 Bundle | in Acocks Green, We...   \n",
       "11315  Oculus quest 2 256gb | in Montrose, Angus | Gu...   \n",
       "11316  Logitech driving force shifter | in Carrickfer...   \n",
       "11317  20 GAMES & NINTENDO SWITCH BUNDLE | in Poole, ...   \n",
       "\n",
       "                                                category  \\\n",
       "0      Home & Garden / Dining, Living Room Furniture ...   \n",
       "1                  Home & Garden / Other Household Goods   \n",
       "2      Home & Garden / Garden & Patio / Outdoor Setti...   \n",
       "3      Home & Garden / Dining, Living Room Furniture ...   \n",
       "12                 Home & Garden / Other Household Goods   \n",
       "...                                                  ...   \n",
       "11313  Video Games & Consoles / Consoles / PS4 (Sony ...   \n",
       "11314  Video Games & Consoles / Consoles / PS4 (Sony ...   \n",
       "11315  Video Games & Consoles / Other Video Games & C...   \n",
       "11316  Video Games & Consoles / Video Game Accessorie...   \n",
       "11317                     Video Games & Consoles / Games   \n",
       "\n",
       "                                     product_description    price  \\\n",
       "0      Mirror wall art. Posted by Nisha in Dining, Li...    £5.00   \n",
       "1      Morphy Richard’s (model no 48755)Stainless ste...   £20.00   \n",
       "2      I have 2 of these - collection only as I don’t...   £20.00   \n",
       "3      Great reclaimed army ammunition box used as co...  £115.00   \n",
       "12     New in box not needed Spotlights . Posted by s...    £9.00   \n",
       "...                                                  ...      ...   \n",
       "11313  Sony PlayStation VR Move Bundle353CASH ON COLL...  £260.00   \n",
       "11314  Playstation VR V2 Bundle355CASH ON COLLECTION ...  £235.00   \n",
       "11315  Pick up only £250Comes with two pistols stocks...  £250.00   \n",
       "11316  Bought at christmas from currys retailing at £...   £30.00   \n",
       "11317  Nintendo Switch console only used 2/3 times. A...  £450.00   \n",
       "\n",
       "                           location  \\\n",
       "0              Wokingham, Berkshire   \n",
       "1               Inverness, Highland   \n",
       "2            Skegness, Lincolnshire   \n",
       "3                Radstock, Somerset   \n",
       "12          Newent, Gloucestershire   \n",
       "...                             ...   \n",
       "11313   Acocks Green, West Midlands   \n",
       "11314   Acocks Green, West Midlands   \n",
       "11315               Montrose, Angus   \n",
       "11316  Carrickfergus, County Antrim   \n",
       "11317                 Poole, Dorset   \n",
       "\n",
       "                                vectorised product names  \n",
       "0      [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...  \n",
       "1      [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...  \n",
       "2      [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...  \n",
       "3      [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...  \n",
       "12     [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...  \n",
       "...                                                  ...  \n",
       "11313  [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...  \n",
       "11314  [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...  \n",
       "11315  [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...  \n",
       "11316  [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...  \n",
       "11317  [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...  \n",
       "\n",
       "[6311 rows x 8 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "productname_vectorizer = TfidfVectorizer()\n",
    "vectorised_product_names = productname_vectorizer.fit_transform(dframe.product_name).todense()\n",
    "dframe['vectorised product names'] = vectorised_product_names.tolist()\n",
    "dframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "productdescr_vectorizer = TfidfVectorizer()\n",
    "vectorised_product_description = productdescr_vectorizer.fit_transform(dframe.product_description).todense()\n",
    "dframe['vectorised product descriptions'] = vectorised_product_description.tolist()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "location_vectorizer = TfidfVectorizer()\n",
    "vectorised_location = location_vectorizer.fit_transform(dframe.location).todense()\n",
    "dframe['vectorised location'] = vectorised_location.tolist()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>id</th>\n",
       "      <th>product_name</th>\n",
       "      <th>category</th>\n",
       "      <th>product_description</th>\n",
       "      <th>price</th>\n",
       "      <th>location</th>\n",
       "      <th>vectorised product names</th>\n",
       "      <th>vectorised product descriptions</th>\n",
       "      <th>vectorised location</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>243809c0-9cfc-4486-ad12-3b7a16605ba9</td>\n",
       "      <td>Mirror wall art | in Wokingham, Berkshire | Gu...</td>\n",
       "      <td>Home &amp; Garden / Dining, Living Room Furniture ...</td>\n",
       "      <td>Mirror wall art. Posted by Nisha in Dining, Li...</td>\n",
       "      <td>£5.00</td>\n",
       "      <td>Wokingham, Berkshire</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1c58d3f9-8b93-47ea-9415-204fcc2a22e6</td>\n",
       "      <td>Stainless Steel Food Steamer | in Inverness, H...</td>\n",
       "      <td>Home &amp; Garden / Other Household Goods</td>\n",
       "      <td>Morphy Richard’s (model no 48755)Stainless ste...</td>\n",
       "      <td>£20.00</td>\n",
       "      <td>Inverness, Highland</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>860673f1-57f6-47ba-8d2f-13f9e05b8f9a</td>\n",
       "      <td>Sun loungers | in Skegness, Lincolnshire | Gum...</td>\n",
       "      <td>Home &amp; Garden / Garden &amp; Patio / Outdoor Setti...</td>\n",
       "      <td>I have 2 of these - collection only as I don’t...</td>\n",
       "      <td>£20.00</td>\n",
       "      <td>Skegness, Lincolnshire</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>59948726-29be-4b35-ade5-bb2fd7331856</td>\n",
       "      <td>Coffee side table from Ammunition ammo box hai...</td>\n",
       "      <td>Home &amp; Garden / Dining, Living Room Furniture ...</td>\n",
       "      <td>Great reclaimed army ammunition box used as co...</td>\n",
       "      <td>£115.00</td>\n",
       "      <td>Radstock, Somerset</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>5</td>\n",
       "      <td>5707be4f-49d9-4feb-b2c8-aa0868405c65</td>\n",
       "      <td>Spotlights | in Newent, Gloucestershire | Gumtree</td>\n",
       "      <td>Home &amp; Garden / Other Household Goods</td>\n",
       "      <td>New in box not needed Spotlights . Posted by s...</td>\n",
       "      <td>£9.00</td>\n",
       "      <td>Newent, Gloucestershire</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11313</th>\n",
       "      <td>7151</td>\n",
       "      <td>c4148656-78a9-4f3e-b393-134fdc5ef900</td>\n",
       "      <td>Sony PlayStation VR Move Bundle | in Acocks Gr...</td>\n",
       "      <td>Video Games &amp; Consoles / Consoles / PS4 (Sony ...</td>\n",
       "      <td>Sony PlayStation VR Move Bundle353CASH ON COLL...</td>\n",
       "      <td>£260.00</td>\n",
       "      <td>Acocks Green, West Midlands</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11314</th>\n",
       "      <td>7152</td>\n",
       "      <td>564e3411-768d-4250-a624-b119d696f103</td>\n",
       "      <td>Playstation VR V2 Bundle | in Acocks Green, We...</td>\n",
       "      <td>Video Games &amp; Consoles / Consoles / PS4 (Sony ...</td>\n",
       "      <td>Playstation VR V2 Bundle355CASH ON COLLECTION ...</td>\n",
       "      <td>£235.00</td>\n",
       "      <td>Acocks Green, West Midlands</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11315</th>\n",
       "      <td>7153</td>\n",
       "      <td>2b0a652b-46a2-4297-b619-5efeeb222787</td>\n",
       "      <td>Oculus quest 2 256gb | in Montrose, Angus | Gu...</td>\n",
       "      <td>Video Games &amp; Consoles / Other Video Games &amp; C...</td>\n",
       "      <td>Pick up only £250Comes with two pistols stocks...</td>\n",
       "      <td>£250.00</td>\n",
       "      <td>Montrose, Angus</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11316</th>\n",
       "      <td>7154</td>\n",
       "      <td>719fd40a-870e-4144-b324-55dff2e66fb4</td>\n",
       "      <td>Logitech driving force shifter | in Carrickfer...</td>\n",
       "      <td>Video Games &amp; Consoles / Video Game Accessorie...</td>\n",
       "      <td>Bought at christmas from currys retailing at £...</td>\n",
       "      <td>£30.00</td>\n",
       "      <td>Carrickfergus, County Antrim</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11317</th>\n",
       "      <td>7155</td>\n",
       "      <td>86d1806b-5575-4a7e-9160-f24f12be6c95</td>\n",
       "      <td>20 GAMES &amp; NINTENDO SWITCH BUNDLE | in Poole, ...</td>\n",
       "      <td>Video Games &amp; Consoles / Games</td>\n",
       "      <td>Nintendo Switch console only used 2/3 times. A...</td>\n",
       "      <td>£450.00</td>\n",
       "      <td>Poole, Dorset</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "      <td>[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6311 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0                                    id  \\\n",
       "0              0  243809c0-9cfc-4486-ad12-3b7a16605ba9   \n",
       "1              1  1c58d3f9-8b93-47ea-9415-204fcc2a22e6   \n",
       "2              2  860673f1-57f6-47ba-8d2f-13f9e05b8f9a   \n",
       "3              3  59948726-29be-4b35-ade5-bb2fd7331856   \n",
       "12             5  5707be4f-49d9-4feb-b2c8-aa0868405c65   \n",
       "...          ...                                   ...   \n",
       "11313       7151  c4148656-78a9-4f3e-b393-134fdc5ef900   \n",
       "11314       7152  564e3411-768d-4250-a624-b119d696f103   \n",
       "11315       7153  2b0a652b-46a2-4297-b619-5efeeb222787   \n",
       "11316       7154  719fd40a-870e-4144-b324-55dff2e66fb4   \n",
       "11317       7155  86d1806b-5575-4a7e-9160-f24f12be6c95   \n",
       "\n",
       "                                            product_name  \\\n",
       "0      Mirror wall art | in Wokingham, Berkshire | Gu...   \n",
       "1      Stainless Steel Food Steamer | in Inverness, H...   \n",
       "2      Sun loungers | in Skegness, Lincolnshire | Gum...   \n",
       "3      Coffee side table from Ammunition ammo box hai...   \n",
       "12     Spotlights | in Newent, Gloucestershire | Gumtree   \n",
       "...                                                  ...   \n",
       "11313  Sony PlayStation VR Move Bundle | in Acocks Gr...   \n",
       "11314  Playstation VR V2 Bundle | in Acocks Green, We...   \n",
       "11315  Oculus quest 2 256gb | in Montrose, Angus | Gu...   \n",
       "11316  Logitech driving force shifter | in Carrickfer...   \n",
       "11317  20 GAMES & NINTENDO SWITCH BUNDLE | in Poole, ...   \n",
       "\n",
       "                                                category  \\\n",
       "0      Home & Garden / Dining, Living Room Furniture ...   \n",
       "1                  Home & Garden / Other Household Goods   \n",
       "2      Home & Garden / Garden & Patio / Outdoor Setti...   \n",
       "3      Home & Garden / Dining, Living Room Furniture ...   \n",
       "12                 Home & Garden / Other Household Goods   \n",
       "...                                                  ...   \n",
       "11313  Video Games & Consoles / Consoles / PS4 (Sony ...   \n",
       "11314  Video Games & Consoles / Consoles / PS4 (Sony ...   \n",
       "11315  Video Games & Consoles / Other Video Games & C...   \n",
       "11316  Video Games & Consoles / Video Game Accessorie...   \n",
       "11317                     Video Games & Consoles / Games   \n",
       "\n",
       "                                     product_description    price  \\\n",
       "0      Mirror wall art. Posted by Nisha in Dining, Li...    £5.00   \n",
       "1      Morphy Richard’s (model no 48755)Stainless ste...   £20.00   \n",
       "2      I have 2 of these - collection only as I don’t...   £20.00   \n",
       "3      Great reclaimed army ammunition box used as co...  £115.00   \n",
       "12     New in box not needed Spotlights . Posted by s...    £9.00   \n",
       "...                                                  ...      ...   \n",
       "11313  Sony PlayStation VR Move Bundle353CASH ON COLL...  £260.00   \n",
       "11314  Playstation VR V2 Bundle355CASH ON COLLECTION ...  £235.00   \n",
       "11315  Pick up only £250Comes with two pistols stocks...  £250.00   \n",
       "11316  Bought at christmas from currys retailing at £...   £30.00   \n",
       "11317  Nintendo Switch console only used 2/3 times. A...  £450.00   \n",
       "\n",
       "                           location  \\\n",
       "0              Wokingham, Berkshire   \n",
       "1               Inverness, Highland   \n",
       "2            Skegness, Lincolnshire   \n",
       "3                Radstock, Somerset   \n",
       "12          Newent, Gloucestershire   \n",
       "...                             ...   \n",
       "11313   Acocks Green, West Midlands   \n",
       "11314   Acocks Green, West Midlands   \n",
       "11315               Montrose, Angus   \n",
       "11316  Carrickfergus, County Antrim   \n",
       "11317                 Poole, Dorset   \n",
       "\n",
       "                                vectorised product names  \\\n",
       "0      [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...   \n",
       "1      [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...   \n",
       "2      [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...   \n",
       "3      [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...   \n",
       "12     [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...   \n",
       "...                                                  ...   \n",
       "11313  [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...   \n",
       "11314  [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...   \n",
       "11315  [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...   \n",
       "11316  [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...   \n",
       "11317  [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...   \n",
       "\n",
       "                         vectorised product descriptions  \\\n",
       "0      [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...   \n",
       "1      [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...   \n",
       "2      [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...   \n",
       "3      [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...   \n",
       "12     [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...   \n",
       "...                                                  ...   \n",
       "11313  [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...   \n",
       "11314  [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...   \n",
       "11315  [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...   \n",
       "11316  [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...   \n",
       "11317  [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...   \n",
       "\n",
       "                                     vectorised location  \n",
       "0      [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...  \n",
       "1      [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...  \n",
       "2      [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...  \n",
       "3      [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...  \n",
       "12     [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...  \n",
       "...                                                  ...  \n",
       "11313  [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...  \n",
       "11314  [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...  \n",
       "11315  [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...  \n",
       "11316  [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...  \n",
       "11317  [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ...  \n",
       "\n",
       "[6311 rows x 10 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "X = dframe['vectorised product names'] + dframe['vectorised product descriptions'] + dframe['vectorised location']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([  5.,  20.,  20., ..., 250.,  30., 450.])"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Y = dframe['price'].str.replace('£', '').str.replace(',', '').astype(float).values\n",
    "Y"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "X = np.array(X.values.tolist())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "del dframe\n",
    "del vectorised_product_description\n",
    "del vectorised_location\n",
    "del vectorised_product_names"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.linear_model import LinearRegression\n",
    "reg = LinearRegression().fit(X, Y)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1.0"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "reg.score(X, Y)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([  5.,  20.,  20., 115.,   9., 419.,  10.,  50., 200., 449.])"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "reg.predict(X[:10])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([  5.,  20.,  20., 115.,   9., 419.,  10.,  50., 200., 449.])"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Y[:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>id</th>\n",
       "      <th>product_name</th>\n",
       "      <th>category</th>\n",
       "      <th>product_description</th>\n",
       "      <th>price</th>\n",
       "      <th>location</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>243809c0-9cfc-4486-ad12-3b7a16605ba9</td>\n",
       "      <td>Mirror wall art | in Wokingham, Berkshire | Gu...</td>\n",
       "      <td>Home &amp; Garden / Dining, Living Room Furniture ...</td>\n",
       "      <td>Mirror wall art. Posted by Nisha in Dining, Li...</td>\n",
       "      <td>£5.00</td>\n",
       "      <td>Wokingham, Berkshire</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1c58d3f9-8b93-47ea-9415-204fcc2a22e6</td>\n",
       "      <td>Stainless Steel Food Steamer | in Inverness, H...</td>\n",
       "      <td>Home &amp; Garden / Other Household Goods</td>\n",
       "      <td>Morphy Richard’s (model no 48755)Stainless ste...</td>\n",
       "      <td>£20.00</td>\n",
       "      <td>Inverness, Highland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>860673f1-57f6-47ba-8d2f-13f9e05b8f9a</td>\n",
       "      <td>Sun loungers | in Skegness, Lincolnshire | Gum...</td>\n",
       "      <td>Home &amp; Garden / Garden &amp; Patio / Outdoor Setti...</td>\n",
       "      <td>I have 2 of these - collection only as I don’t...</td>\n",
       "      <td>£20.00</td>\n",
       "      <td>Skegness, Lincolnshire</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>59948726-29be-4b35-ade5-bb2fd7331856</td>\n",
       "      <td>Coffee side table from Ammunition ammo box hai...</td>\n",
       "      <td>Home &amp; Garden / Dining, Living Room Furniture ...</td>\n",
       "      <td>Great reclaimed army ammunition box used as co...</td>\n",
       "      <td>£115.00</td>\n",
       "      <td>Radstock, Somerset</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>5</td>\n",
       "      <td>5707be4f-49d9-4feb-b2c8-aa0868405c65</td>\n",
       "      <td>Spotlights | in Newent, Gloucestershire | Gumtree</td>\n",
       "      <td>Home &amp; Garden / Other Household Goods</td>\n",
       "      <td>New in box not needed Spotlights . Posted by s...</td>\n",
       "      <td>£9.00</td>\n",
       "      <td>Newent, Gloucestershire</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11313</th>\n",
       "      <td>7151</td>\n",
       "      <td>c4148656-78a9-4f3e-b393-134fdc5ef900</td>\n",
       "      <td>Sony PlayStation VR Move Bundle | in Acocks Gr...</td>\n",
       "      <td>Video Games &amp; Consoles / Consoles / PS4 (Sony ...</td>\n",
       "      <td>Sony PlayStation VR Move Bundle353CASH ON COLL...</td>\n",
       "      <td>£260.00</td>\n",
       "      <td>Acocks Green, West Midlands</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11314</th>\n",
       "      <td>7152</td>\n",
       "      <td>564e3411-768d-4250-a624-b119d696f103</td>\n",
       "      <td>Playstation VR V2 Bundle | in Acocks Green, We...</td>\n",
       "      <td>Video Games &amp; Consoles / Consoles / PS4 (Sony ...</td>\n",
       "      <td>Playstation VR V2 Bundle355CASH ON COLLECTION ...</td>\n",
       "      <td>£235.00</td>\n",
       "      <td>Acocks Green, West Midlands</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11315</th>\n",
       "      <td>7153</td>\n",
       "      <td>2b0a652b-46a2-4297-b619-5efeeb222787</td>\n",
       "      <td>Oculus quest 2 256gb | in Montrose, Angus | Gu...</td>\n",
       "      <td>Video Games &amp; Consoles / Other Video Games &amp; C...</td>\n",
       "      <td>Pick up only £250Comes with two pistols stocks...</td>\n",
       "      <td>£250.00</td>\n",
       "      <td>Montrose, Angus</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11316</th>\n",
       "      <td>7154</td>\n",
       "      <td>719fd40a-870e-4144-b324-55dff2e66fb4</td>\n",
       "      <td>Logitech driving force shifter | in Carrickfer...</td>\n",
       "      <td>Video Games &amp; Consoles / Video Game Accessorie...</td>\n",
       "      <td>Bought at christmas from currys retailing at £...</td>\n",
       "      <td>£30.00</td>\n",
       "      <td>Carrickfergus, County Antrim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11317</th>\n",
       "      <td>7155</td>\n",
       "      <td>86d1806b-5575-4a7e-9160-f24f12be6c95</td>\n",
       "      <td>20 GAMES &amp; NINTENDO SWITCH BUNDLE | in Poole, ...</td>\n",
       "      <td>Video Games &amp; Consoles / Games</td>\n",
       "      <td>Nintendo Switch console only used 2/3 times. A...</td>\n",
       "      <td>£450.00</td>\n",
       "      <td>Poole, Dorset</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6311 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0                                    id  \\\n",
       "0              0  243809c0-9cfc-4486-ad12-3b7a16605ba9   \n",
       "1              1  1c58d3f9-8b93-47ea-9415-204fcc2a22e6   \n",
       "2              2  860673f1-57f6-47ba-8d2f-13f9e05b8f9a   \n",
       "3              3  59948726-29be-4b35-ade5-bb2fd7331856   \n",
       "12             5  5707be4f-49d9-4feb-b2c8-aa0868405c65   \n",
       "...          ...                                   ...   \n",
       "11313       7151  c4148656-78a9-4f3e-b393-134fdc5ef900   \n",
       "11314       7152  564e3411-768d-4250-a624-b119d696f103   \n",
       "11315       7153  2b0a652b-46a2-4297-b619-5efeeb222787   \n",
       "11316       7154  719fd40a-870e-4144-b324-55dff2e66fb4   \n",
       "11317       7155  86d1806b-5575-4a7e-9160-f24f12be6c95   \n",
       "\n",
       "                                            product_name  \\\n",
       "0      Mirror wall art | in Wokingham, Berkshire | Gu...   \n",
       "1      Stainless Steel Food Steamer | in Inverness, H...   \n",
       "2      Sun loungers | in Skegness, Lincolnshire | Gum...   \n",
       "3      Coffee side table from Ammunition ammo box hai...   \n",
       "12     Spotlights | in Newent, Gloucestershire | Gumtree   \n",
       "...                                                  ...   \n",
       "11313  Sony PlayStation VR Move Bundle | in Acocks Gr...   \n",
       "11314  Playstation VR V2 Bundle | in Acocks Green, We...   \n",
       "11315  Oculus quest 2 256gb | in Montrose, Angus | Gu...   \n",
       "11316  Logitech driving force shifter | in Carrickfer...   \n",
       "11317  20 GAMES & NINTENDO SWITCH BUNDLE | in Poole, ...   \n",
       "\n",
       "                                                category  \\\n",
       "0      Home & Garden / Dining, Living Room Furniture ...   \n",
       "1                  Home & Garden / Other Household Goods   \n",
       "2      Home & Garden / Garden & Patio / Outdoor Setti...   \n",
       "3      Home & Garden / Dining, Living Room Furniture ...   \n",
       "12                 Home & Garden / Other Household Goods   \n",
       "...                                                  ...   \n",
       "11313  Video Games & Consoles / Consoles / PS4 (Sony ...   \n",
       "11314  Video Games & Consoles / Consoles / PS4 (Sony ...   \n",
       "11315  Video Games & Consoles / Other Video Games & C...   \n",
       "11316  Video Games & Consoles / Video Game Accessorie...   \n",
       "11317                     Video Games & Consoles / Games   \n",
       "\n",
       "                                     product_description    price  \\\n",
       "0      Mirror wall art. Posted by Nisha in Dining, Li...    £5.00   \n",
       "1      Morphy Richard’s (model no 48755)Stainless ste...   £20.00   \n",
       "2      I have 2 of these - collection only as I don’t...   £20.00   \n",
       "3      Great reclaimed army ammunition box used as co...  £115.00   \n",
       "12     New in box not needed Spotlights . Posted by s...    £9.00   \n",
       "...                                                  ...      ...   \n",
       "11313  Sony PlayStation VR Move Bundle353CASH ON COLL...  £260.00   \n",
       "11314  Playstation VR V2 Bundle355CASH ON COLLECTION ...  £235.00   \n",
       "11315  Pick up only £250Comes with two pistols stocks...  £250.00   \n",
       "11316  Bought at christmas from currys retailing at £...   £30.00   \n",
       "11317  Nintendo Switch console only used 2/3 times. A...  £450.00   \n",
       "\n",
       "                           location  \n",
       "0              Wokingham, Berkshire  \n",
       "1               Inverness, Highland  \n",
       "2            Skegness, Lincolnshire  \n",
       "3                Radstock, Somerset  \n",
       "12          Newent, Gloucestershire  \n",
       "...                             ...  \n",
       "11313   Acocks Green, West Midlands  \n",
       "11314   Acocks Green, West Midlands  \n",
       "11315               Montrose, Angus  \n",
       "11316  Carrickfergus, County Antrim  \n",
       "11317                 Poole, Dorset  \n",
       "\n",
       "[6311 rows x 7 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import csv\n",
    "import pandas as pd \n",
    "\n",
    "\n",
    "def cleanser():\n",
    "        \n",
    "    dframe = pd.read_csv(\"/Users/macbook/Downloads/Products.csv\")\n",
    " \n",
    "    dframe = dframe.dropna(axis='index', how='any')\n",
    "    return dframe\n",
    "\n",
    "\n",
    "\n",
    "outcome_tabular = cleanser()\n",
    "outcome_tabular "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "from PIL import Image\n",
    "import os\n",
    "\n",
    "\n",
    "def resize_image(final_size, im):\n",
    "    size = im.size\n",
    "    ratio = float(final_size) / max(size)\n",
    "    new_image_size = tuple([int(x*ratio) for x in size])\n",
    "    im = im.resize(new_image_size, Image.Resampling.LANCZOS)\n",
    "    new_im = Image.new(\"RGB\", (final_size, final_size))\n",
    "    new_im.paste(im, ((final_size-new_image_size[0])//2, (final_size-new_image_size[1])//2))\n",
    "    return new_im\n",
    "\n",
    "if __name__ == '__main__':\n",
    "    path = \"/Users/macbook/Downloads/images/\"\n",
    "    dest_path = \"/Users/macbook/Downloads/resized_images/\"\n",
    "    dirs = os.listdir(path)\n",
    "    final_size = 400\n",
    "    for n, item in enumerate(dirs[:5], 1):\n",
    "        im = Image.open('/Users/macbook/Downloads/images/' + item)\n",
    "        new_im = resize_image(final_size, im)\n",
    "        new_im.save(dest_path + f'{n}_resized.jpg', 'JPEG', quality=100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0             Sports, Leisure & Travel \n",
       "1               Video Games & Consoles \n",
       "2                        Home & Garden \n",
       "3                    Baby & Kids Stuff \n",
       "4      Clothes, Footwear & Accessories \n",
       "                     ...               \n",
       "449                        Other Goods \n",
       "450             Video Games & Consoles \n",
       "451                        Other Goods \n",
       "452                    Health & Beauty \n",
       "453                    Health & Beauty \n",
       "Name: category, Length: 454, dtype: object"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from classification import image_data_df\n",
    "image_data_df.category"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "3d597f4c481aa0f25dceb95d2a0067e73c0966dcbd003d741d821a7208527ecf"
  },
  "kernelspec": {
   "display_name": "Python 3.9.7 ('base')",
   "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.9.7"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}