Skip to content

Instantly share code, notes, and snippets.

@dataxienxe

dataxienxe/Laptops.ipynb

Created November 1, 2019 18:07
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dataxienxe/a587896685481f65f0df485e0fdd47d8 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dataxienxe/a587896685481f65f0df485e0fdd47d8 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
Laptops.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd\n",
"import numpy as np\n",
"import matplotlib.pyplot as plt\n",
"import re"
]
},
{
"cell_type": "code",
"execution_count": 2,
"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>web-scraper-order</th>\n",
" <th>web-scraper-start-url</th>\n",
" <th>listing</th>\n",
" <th>listing-href</th>\n",
" <th>pagination</th>\n",
" <th>pagination-href</th>\n",
" <th>name</th>\n",
" <th>brand</th>\n",
" <th>category</th>\n",
" <th>category_breadcrumbs</th>\n",
" <th>rating</th>\n",
" <th>review_count</th>\n",
" <th>list_price</th>\n",
" <th>sales_price</th>\n",
" <th>product_description</th>\n",
" <th>product_specification</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>0</td>\n",
" <td>1572034776-196</td>\n",
" <td>https://www.amazon.com/s?k=laptop&amp;ref=nb_sb_noss</td>\n",
" <td>2019 Lenovo Flex 5 15 2-in-1 15.6\" Touchscreen...</td>\n",
" <td>https://www.amazon.com/gp/slredirect/picassoRe...</td>\n",
" <td>Next→</td>\n",
" <td>https://www.amazon.com/s?k=laptop&amp;page=11&amp;qid=...</td>\n",
" <td>$187.99</td>\n",
" <td>Lenovo</td>\n",
" <td>Electronics</td>\n",
" <td>[{\"category_breadcrumbs\":\"Electronics\"},{\"cate...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Product description\\n \\n ...</td>\n",
" <td>Screen Size\\n \\n ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>1</td>\n",
" <td>1572034836-212</td>\n",
" <td>https://www.amazon.com/s?k=laptop&amp;ref=nb_sb_noss</td>\n",
" <td>2019 Dell Inspiron 15.6\" Laptop Computer, 8th ...</td>\n",
" <td>https://www.amazon.com/Dell-Inspiron-Computer-...</td>\n",
" <td>Next→</td>\n",
" <td>https://www.amazon.com/s?k=laptop&amp;page=10&amp;qid=...</td>\n",
" <td>$103.99</td>\n",
" <td>Amazon Renewed</td>\n",
" <td>Electronics</td>\n",
" <td>[{\"category_breadcrumbs\":\"Electronics\"},{\"cate...</td>\n",
" <td>NaN</td>\n",
" <td>1 rating</td>\n",
" <td>NaN</td>\n",
" <td>$509.00</td>\n",
" <td>Product description\\n \\n ...</td>\n",
" <td>Screen Size\\n \\n ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>2</td>\n",
" <td>1572034179-37</td>\n",
" <td>https://www.amazon.com/s?k=laptop&amp;ref=nb_sb_noss</td>\n",
" <td>Newest HP 15.6-inch HD Touchscreen Display Lap...</td>\n",
" <td>https://www.amazon.com/HP-15-6-inch-Touchscree...</td>\n",
" <td>Next→</td>\n",
" <td>https://www.amazon.com/s?k=laptop&amp;page=18&amp;qid=...</td>\n",
" <td>$98.99</td>\n",
" <td>HP</td>\n",
" <td>Electronics</td>\n",
" <td>[{\"category_breadcrumbs\":\"Electronics\"},{\"cate...</td>\n",
" <td>NaN</td>\n",
" <td>27 ratings</td>\n",
" <td>NaN</td>\n",
" <td>$466.99</td>\n",
" <td>Product description\\n \\n ...</td>\n",
" <td>Screen Size\\n \\n ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>3</td>\n",
" <td>1572035405-360</td>\n",
" <td>https://www.amazon.com/s?k=laptop&amp;ref=nb_sb_noss</td>\n",
" <td>HP Pavilion 15 15.6\" FHD Touchscreen Business ...</td>\n",
" <td>https://www.amazon.com/gp/slredirect/picassoRe...</td>\n",
" <td>Next→</td>\n",
" <td>https://www.amazon.com/s?k=laptop&amp;page=4&amp;qid=1...</td>\n",
" <td>HP Pavilion 15 15.6\" FHD Touchscreen Business ...</td>\n",
" <td>HP</td>\n",
" <td>Electronics</td>\n",
" <td>[{\"category_breadcrumbs\":\"Electronics\"},{\"cate...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>$1,329.00</td>\n",
" <td>Product description\\n \\n ...</td>\n",
" <td>Screen Size\\n \\n ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>4</td>\n",
" <td>1572034939-240</td>\n",
" <td>https://www.amazon.com/s?k=laptop&amp;ref=nb_sb_noss</td>\n",
" <td>CHUWI LapBook Plus 15.6'' Windows 10 Laptop Co...</td>\n",
" <td>https://www.amazon.com/gp/slredirect/picassoRe...</td>\n",
" <td>Next→</td>\n",
" <td>https://www.amazon.com/s?k=laptop&amp;page=9&amp;qid=1...</td>\n",
" <td>$93.99</td>\n",
" <td>CHUWI</td>\n",
" <td>Electronics</td>\n",
" <td>[{\"category_breadcrumbs\":\"Electronics\"},{\"cate...</td>\n",
" <td>NaN</td>\n",
" <td>1 rating</td>\n",
" <td>NaN</td>\n",
" <td>$449.99</td>\n",
" <td>NaN</td>\n",
" <td>Screen Size\\n \\n ...</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" web-scraper-order web-scraper-start-url \\\n",
"0 1572034776-196 https://www.amazon.com/s?k=laptop&ref=nb_sb_noss \n",
"1 1572034836-212 https://www.amazon.com/s?k=laptop&ref=nb_sb_noss \n",
"2 1572034179-37 https://www.amazon.com/s?k=laptop&ref=nb_sb_noss \n",
"3 1572035405-360 https://www.amazon.com/s?k=laptop&ref=nb_sb_noss \n",
"4 1572034939-240 https://www.amazon.com/s?k=laptop&ref=nb_sb_noss \n",
"\n",
" listing \\\n",
"0 2019 Lenovo Flex 5 15 2-in-1 15.6\" Touchscreen... \n",
"1 2019 Dell Inspiron 15.6\" Laptop Computer, 8th ... \n",
"2 Newest HP 15.6-inch HD Touchscreen Display Lap... \n",
"3 HP Pavilion 15 15.6\" FHD Touchscreen Business ... \n",
"4 CHUWI LapBook Plus 15.6'' Windows 10 Laptop Co... \n",
"\n",
" listing-href pagination \\\n",
"0 https://www.amazon.com/gp/slredirect/picassoRe... Next→ \n",
"1 https://www.amazon.com/Dell-Inspiron-Computer-... Next→ \n",
"2 https://www.amazon.com/HP-15-6-inch-Touchscree... Next→ \n",
"3 https://www.amazon.com/gp/slredirect/picassoRe... Next→ \n",
"4 https://www.amazon.com/gp/slredirect/picassoRe... Next→ \n",
"\n",
" pagination-href \\\n",
"0 https://www.amazon.com/s?k=laptop&page=11&qid=... \n",
"1 https://www.amazon.com/s?k=laptop&page=10&qid=... \n",
"2 https://www.amazon.com/s?k=laptop&page=18&qid=... \n",
"3 https://www.amazon.com/s?k=laptop&page=4&qid=1... \n",
"4 https://www.amazon.com/s?k=laptop&page=9&qid=1... \n",
"\n",
" name brand \\\n",
"0 $187.99 Lenovo \n",
"1 $103.99 Amazon Renewed \n",
"2 $98.99 HP \n",
"3 HP Pavilion 15 15.6\" FHD Touchscreen Business ... HP \n",
"4 $93.99 CHUWI \n",
"\n",
" category category_breadcrumbs rating \\\n",
"0 Electronics [{\"category_breadcrumbs\":\"Electronics\"},{\"cate... NaN \n",
"1 Electronics [{\"category_breadcrumbs\":\"Electronics\"},{\"cate... NaN \n",
"2 Electronics [{\"category_breadcrumbs\":\"Electronics\"},{\"cate... NaN \n",
"3 Electronics [{\"category_breadcrumbs\":\"Electronics\"},{\"cate... NaN \n",
"4 Electronics [{\"category_breadcrumbs\":\"Electronics\"},{\"cate... NaN \n",
"\n",
" review_count list_price sales_price \\\n",
"0 NaN NaN NaN \n",
"1 1 rating NaN $509.00 \n",
"2 27 ratings NaN $466.99 \n",
"3 NaN NaN $1,329.00 \n",
"4 1 rating NaN $449.99 \n",
"\n",
" product_description \\\n",
"0 Product description\\n \\n ... \n",
"1 Product description\\n \\n ... \n",
"2 Product description\\n \\n ... \n",
"3 Product description\\n \\n ... \n",
"4 NaN \n",
"\n",
" product_specification \n",
"0 Screen Size\\n \\n ... \n",
"1 Screen Size\\n \\n ... \n",
"2 Screen Size\\n \\n ... \n",
"3 Screen Size\\n \\n ... \n",
"4 Screen Size\\n \\n ... "
]
},
"execution_count": 2,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df = pd.read_csv(\"amazon.csv\")\n",
"df.head()"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [],
"source": [
"data = df[['listing', 'listing-href', 'brand', 'review_count', 'sales_price', 'product_description', 'product_specification']].copy()"
]
},
{
"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>listing</th>\n",
" <th>listing-href</th>\n",
" <th>brand</th>\n",
" <th>review_count</th>\n",
" <th>sales_price</th>\n",
" <th>product_description</th>\n",
" <th>product_specification</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>0</td>\n",
" <td>2019 Lenovo Flex 5 15 2-in-1 15.6\" Touchscreen...</td>\n",
" <td>https://www.amazon.com/gp/slredirect/picassoRe...</td>\n",
" <td>Lenovo</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Product description\\n \\n ...</td>\n",
" <td>Screen Size\\n \\n ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>1</td>\n",
" <td>2019 Dell Inspiron 15.6\" Laptop Computer, 8th ...</td>\n",
" <td>https://www.amazon.com/Dell-Inspiron-Computer-...</td>\n",
" <td>Amazon Renewed</td>\n",
" <td>1 rating</td>\n",
" <td>$509.00</td>\n",
" <td>Product description\\n \\n ...</td>\n",
" <td>Screen Size\\n \\n ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>2</td>\n",
" <td>Newest HP 15.6-inch HD Touchscreen Display Lap...</td>\n",
" <td>https://www.amazon.com/HP-15-6-inch-Touchscree...</td>\n",
" <td>HP</td>\n",
" <td>27 ratings</td>\n",
" <td>$466.99</td>\n",
" <td>Product description\\n \\n ...</td>\n",
" <td>Screen Size\\n \\n ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>3</td>\n",
" <td>HP Pavilion 15 15.6\" FHD Touchscreen Business ...</td>\n",
" <td>https://www.amazon.com/gp/slredirect/picassoRe...</td>\n",
" <td>HP</td>\n",
" <td>NaN</td>\n",
" <td>$1,329.00</td>\n",
" <td>Product description\\n \\n ...</td>\n",
" <td>Screen Size\\n \\n ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>4</td>\n",
" <td>CHUWI LapBook Plus 15.6'' Windows 10 Laptop Co...</td>\n",
" <td>https://www.amazon.com/gp/slredirect/picassoRe...</td>\n",
" <td>CHUWI</td>\n",
" <td>1 rating</td>\n",
" <td>$449.99</td>\n",
" <td>NaN</td>\n",
" <td>Screen Size\\n \\n ...</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" listing \\\n",
"0 2019 Lenovo Flex 5 15 2-in-1 15.6\" Touchscreen... \n",
"1 2019 Dell Inspiron 15.6\" Laptop Computer, 8th ... \n",
"2 Newest HP 15.6-inch HD Touchscreen Display Lap... \n",
"3 HP Pavilion 15 15.6\" FHD Touchscreen Business ... \n",
"4 CHUWI LapBook Plus 15.6'' Windows 10 Laptop Co... \n",
"\n",
" listing-href brand \\\n",
"0 https://www.amazon.com/gp/slredirect/picassoRe... Lenovo \n",
"1 https://www.amazon.com/Dell-Inspiron-Computer-... Amazon Renewed \n",
"2 https://www.amazon.com/HP-15-6-inch-Touchscree... HP \n",
"3 https://www.amazon.com/gp/slredirect/picassoRe... HP \n",
"4 https://www.amazon.com/gp/slredirect/picassoRe... CHUWI \n",
"\n",
" review_count sales_price product_description \\\n",
"0 NaN NaN Product description\\n \\n ... \n",
"1 1 rating $509.00 Product description\\n \\n ... \n",
"2 27 ratings $466.99 Product description\\n \\n ... \n",
"3 NaN $1,329.00 Product description\\n \\n ... \n",
"4 1 rating $449.99 NaN \n",
"\n",
" product_specification \n",
"0 Screen Size\\n \\n ... \n",
"1 Screen Size\\n \\n ... \n",
"2 Screen Size\\n \\n ... \n",
"3 Screen Size\\n \\n ... \n",
"4 Screen Size\\n \\n ... "
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.head()"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>listing</th>\n",
" <th>listing-href</th>\n",
" <th>brand</th>\n",
" <th>review_count</th>\n",
" <th>sales_price</th>\n",
" <th>product_description</th>\n",
" <th>product_specification</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>count</td>\n",
" <td>253</td>\n",
" <td>253</td>\n",
" <td>253</td>\n",
" <td>253</td>\n",
" <td>253</td>\n",
" <td>253</td>\n",
" <td>253</td>\n",
" </tr>\n",
" <tr>\n",
" <td>unique</td>\n",
" <td>240</td>\n",
" <td>253</td>\n",
" <td>16</td>\n",
" <td>130</td>\n",
" <td>217</td>\n",
" <td>239</td>\n",
" <td>238</td>\n",
" </tr>\n",
" <tr>\n",
" <td>top</td>\n",
" <td>Acer Aspire 5 Slim Laptop, 15.6\" Full HD IPS D...</td>\n",
" <td>https://www.amazon.com/ASUS-Performance-Comput...</td>\n",
" <td>HP</td>\n",
" <td>1 rating</td>\n",
" <td>$249.99</td>\n",
" <td>Product description\\n \\n ...</td>\n",
" <td>Screen Size\\n \\n ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>freq</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>54</td>\n",
" <td>21</td>\n",
" <td>5</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" listing \\\n",
"count 253 \n",
"unique 240 \n",
"top Acer Aspire 5 Slim Laptop, 15.6\" Full HD IPS D... \n",
"freq 3 \n",
"\n",
" listing-href brand review_count \\\n",
"count 253 253 253 \n",
"unique 253 16 130 \n",
"top https://www.amazon.com/ASUS-Performance-Comput... HP 1 rating \n",
"freq 1 54 21 \n",
"\n",
" sales_price product_description \\\n",
"count 253 253 \n",
"unique 217 239 \n",
"top $249.99 Product description\\n \\n ... \n",
"freq 5 3 \n",
"\n",
" product_specification \n",
"count 253 \n",
"unique 238 \n",
"top Screen Size\\n \\n ... \n",
"freq 3 "
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data = data.dropna(how='any')\n",
"data = data.reset_index(drop=True)\n",
"data.describe()\n",
"#data['product_specification'][0]"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [],
"source": [
"data = data.replace(r'\\n',' ', regex=True)\n",
"data = data.replace(r'\\t','', regex=True)\n",
"data = data.replace(r'\\s\\s\\s','', regex=True)"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"C:\\Users\\Rohan.Gupta.USNIIT-TECH\\AppData\\Local\\Continuum\\anaconda3\\envs\\Flasktest\\lib\\site-packages\\pandas\\core\\strings.py:1843: UserWarning: This pattern has match groups. To actually get the groups, use str.extract.\n",
" return func(self, *args, **kwargs)\n"
]
},
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>listing</th>\n",
" <th>listing-href</th>\n",
" <th>brand</th>\n",
" <th>review_count</th>\n",
" <th>sales_price</th>\n",
" <th>product_description</th>\n",
" <th>product_specification</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>0</td>\n",
" <td>2019 Dell Inspiron 15.6\" Laptop Computer, 8th ...</td>\n",
" <td>https://www.amazon.com/Dell-Inspiron-Computer-...</td>\n",
" <td>Amazon Renewed</td>\n",
" <td>1 rating</td>\n",
" <td>$509.00</td>\n",
" <td>Product description Processor: 8th generation...</td>\n",
" <td>Screen Size 15.6 inches Screen Resolution 136...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>1</td>\n",
" <td>Newest HP 15.6-inch HD Touchscreen Display Lap...</td>\n",
" <td>https://www.amazon.com/HP-15-6-inch-Touchscree...</td>\n",
" <td>HP</td>\n",
" <td>27 ratings</td>\n",
" <td>$466.99</td>\n",
" <td>Product description Operating System: Windows...</td>\n",
" <td>Screen Size 15.6 inches Screen Resolution 136...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>2</td>\n",
" <td>2019 Lenovo L340 17.3\" Laptop Computer, 8th Ge...</td>\n",
" <td>https://www.amazon.com/Lenovo-L340-Computer-i3...</td>\n",
" <td>Lenovo</td>\n",
" <td>10 ratings</td>\n",
" <td>$423.99</td>\n",
" <td>Product description Specifications: Processo...</td>\n",
" <td>Screen Size 17.3 inches Screen Resolution 140...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>3</td>\n",
" <td>2018 Dell Inspiron 15 5000 15.6 inch Full HD T...</td>\n",
" <td>https://www.amazon.com/Dell-Inspiron-Keyboard-...</td>\n",
" <td>Dell</td>\n",
" <td>242 ratings</td>\n",
" <td>$534.98</td>\n",
" <td>Product description Capacity:8GB RAM | 1TB HDD...</td>\n",
" <td>Screen Size 15.6 inches Screen Resolution 192...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>4</td>\n",
" <td>Dell G7 17 Gaming Laptop (Windows 10 Home, 9th...</td>\n",
" <td>https://www.amazon.com/Dell-Gaming-Windows-i7-...</td>\n",
" <td>Dell</td>\n",
" <td>27 ratings</td>\n",
" <td>$1,236.00</td>\n",
" <td>Product description Color:Gray 17-Inch Dell g...</td>\n",
" <td>Screen Size 17.3 inches Max Screen Resolution...</td>\n",
" </tr>\n",
" <tr>\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",
" <td>153</td>\n",
" <td>Lenovo Chromebook 2-in-1 Convertible Laptop, 1...</td>\n",
" <td>https://www.amazon.com/Lenovo-Chromebook-Conve...</td>\n",
" <td>Lenovo</td>\n",
" <td>46 ratings</td>\n",
" <td>$243.24</td>\n",
" <td>Product description Description: Lenovo Conve...</td>\n",
" <td>Screen Size 11.6 inches Processor 2.1 GHz Non...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>154</td>\n",
" <td>2019 HP 14, 14\" HD Thin &amp; Light Flagship Lapto...</td>\n",
" <td>https://www.amazon.com/HP-14-Flagship-Computer...</td>\n",
" <td>HP</td>\n",
" <td>9 ratings</td>\n",
" <td>$302.00</td>\n",
" <td>Product description Microprocessor: Intel Cor...</td>\n",
" <td>Screen Size 14 inches Max Screen Resolution 1...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>155</td>\n",
" <td>HP 17.3\" HD+ SVA WLED-Backlit Notebook Laptop,...</td>\n",
" <td>https://www.amazon.com/HP-WLED-Backlit-Noteboo...</td>\n",
" <td>HP</td>\n",
" <td>44 ratings</td>\n",
" <td>$758.00</td>\n",
" <td>Product description 8th Generation Intel Core...</td>\n",
" <td>Screen Size 17.3 inches Screen Resolution 160...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>156</td>\n",
" <td>HP 2019 Newest 15 15.6 Inch HD Laptop (Intel D...</td>\n",
" <td>https://www.amazon.com/HP-i3-7100U-Graphics-Bl...</td>\n",
" <td>HP</td>\n",
" <td>3 ratings</td>\n",
" <td>$299.00</td>\n",
" <td>Product description NexiPC sells computers wi...</td>\n",
" <td>Screen Size 15.6 inches Screen Resolution 136...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>157</td>\n",
" <td>2019 HP Laptop Computer, 14\" FHD IPS BrightVie...</td>\n",
" <td>https://www.amazon.com/gp/slredirect/picassoRe...</td>\n",
" <td>HP</td>\n",
" <td>2 ratings</td>\n",
" <td>$522.00</td>\n",
" <td>Product description Processor &amp; Memory:Intel ...</td>\n",
" <td>Screen Size 14 inches Screen Resolution 1920x...</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>158 rows × 7 columns</p>\n",
"</div>"
],
"text/plain": [
" listing \\\n",
"0 2019 Dell Inspiron 15.6\" Laptop Computer, 8th ... \n",
"1 Newest HP 15.6-inch HD Touchscreen Display Lap... \n",
"2 2019 Lenovo L340 17.3\" Laptop Computer, 8th Ge... \n",
"3 2018 Dell Inspiron 15 5000 15.6 inch Full HD T... \n",
"4 Dell G7 17 Gaming Laptop (Windows 10 Home, 9th... \n",
".. ... \n",
"153 Lenovo Chromebook 2-in-1 Convertible Laptop, 1... \n",
"154 2019 HP 14, 14\" HD Thin & Light Flagship Lapto... \n",
"155 HP 17.3\" HD+ SVA WLED-Backlit Notebook Laptop,... \n",
"156 HP 2019 Newest 15 15.6 Inch HD Laptop (Intel D... \n",
"157 2019 HP Laptop Computer, 14\" FHD IPS BrightVie... \n",
"\n",
" listing-href brand \\\n",
"0 https://www.amazon.com/Dell-Inspiron-Computer-... Amazon Renewed \n",
"1 https://www.amazon.com/HP-15-6-inch-Touchscree... HP \n",
"2 https://www.amazon.com/Lenovo-L340-Computer-i3... Lenovo \n",
"3 https://www.amazon.com/Dell-Inspiron-Keyboard-... Dell \n",
"4 https://www.amazon.com/Dell-Gaming-Windows-i7-... Dell \n",
".. ... ... \n",
"153 https://www.amazon.com/Lenovo-Chromebook-Conve... Lenovo \n",
"154 https://www.amazon.com/HP-14-Flagship-Computer... HP \n",
"155 https://www.amazon.com/HP-WLED-Backlit-Noteboo... HP \n",
"156 https://www.amazon.com/HP-i3-7100U-Graphics-Bl... HP \n",
"157 https://www.amazon.com/gp/slredirect/picassoRe... HP \n",
"\n",
" review_count sales_price \\\n",
"0 1 rating $509.00 \n",
"1 27 ratings $466.99 \n",
"2 10 ratings $423.99 \n",
"3 242 ratings $534.98 \n",
"4 27 ratings $1,236.00 \n",
".. ... ... \n",
"153 46 ratings $243.24 \n",
"154 9 ratings $302.00 \n",
"155 44 ratings $758.00 \n",
"156 3 ratings $299.00 \n",
"157 2 ratings $522.00 \n",
"\n",
" product_description \\\n",
"0 Product description Processor: 8th generation... \n",
"1 Product description Operating System: Windows... \n",
"2 Product description Specifications: Processo... \n",
"3 Product description Capacity:8GB RAM | 1TB HDD... \n",
"4 Product description Color:Gray 17-Inch Dell g... \n",
".. ... \n",
"153 Product description Description: Lenovo Conve... \n",
"154 Product description Microprocessor: Intel Cor... \n",
"155 Product description 8th Generation Intel Core... \n",
"156 Product description NexiPC sells computers wi... \n",
"157 Product description Processor & Memory:Intel ... \n",
"\n",
" product_specification \n",
"0 Screen Size 15.6 inches Screen Resolution 136... \n",
"1 Screen Size 15.6 inches Screen Resolution 136... \n",
"2 Screen Size 17.3 inches Screen Resolution 140... \n",
"3 Screen Size 15.6 inches Screen Resolution 192... \n",
"4 Screen Size 17.3 inches Max Screen Resolution... \n",
".. ... \n",
"153 Screen Size 11.6 inches Processor 2.1 GHz Non... \n",
"154 Screen Size 14 inches Max Screen Resolution 1... \n",
"155 Screen Size 17.3 inches Screen Resolution 160... \n",
"156 Screen Size 15.6 inches Screen Resolution 136... \n",
"157 Screen Size 14 inches Screen Resolution 1920x... \n",
"\n",
"[158 rows x 7 columns]"
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.drop(data[~data.product_specification.str.contains(\"Screen Size\")].index, inplace=True)\n",
"data.drop(data[~data.product_specification.str.contains(\"Processor (?<![a-zA-Z:])[-+]?\\d*\\.?\\d+\\s\\w+\",regex=True)].index, inplace=True)\n",
"data.drop(data[~data.product_specification.str.contains(\"GHz (?:[A-Za-z]+\\s){0,}[A-Za-z]+\\w+\",regex=True)].index, inplace=True)\n",
"data.drop(data[~data.product_specification.str.contains(\"RAM (\\w+\\s\\w+){1,}\",regex=True)].index, inplace=True)\n",
"data.drop(data[~data.product_specification.str.contains(\"Hard Drive (\\w+\\s\\w+\\s\\w+){1,}\",regex=True)].index, inplace=True)\n",
"data.drop(data[~data.product_specification.str.contains(\"Chipset Brand (\\w+){0,}\",regex=True)].index, inplace=True)\n",
"data.drop(data[~data.product_specification.str.contains(\"Card Description (\\w+){0,}\",regex=True)].index, inplace=True)\n",
"\n",
"\n",
"\n",
"data = data.reset_index(drop=True)\n",
"data"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"['Screen Size 15.6 inches Screen Resolution 1366x768 Max Screen Resolution 1366 x 768 Processor 1.6 GHz Intel Core i5 RAM 16 GB Hard Drive 1 TB HDD 5400 rpm Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand intel Card Description Integrated Wireless Type 802.11abg, 802.11a/b/g/n/ac, 802.11ac, 802.11a/b/g/n, 802.11a',\n",
" 'Screen Size 15.6 inches Screen Resolution 1366x768 Processor 2.4 GHz Intel Core i3 RAM 8 GB SDRAM Memory Speed 2133 MHz Hard Drive 1 TB HDD 5400 rpm Graphics Coprocessor Intel HD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11a',\n",
" 'Screen Size 17.3 inches Screen Resolution 1400 x 900 Max Screen Resolution 1400 x 900 Processor 2.1 GHz Intel Core i3 RAM 8 GB Hard Drive 1 TB PCIE SSD Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand intel Card Description Integrated Wireless Type 802.11abg, 802.11a/b/g/n/ac, 802.11a/b/g/n, 802.11a',\n",
" 'Screen Size 15.6 inches Screen Resolution 1920x1080 Processor 1.6 GHz Intel Core i5 RAM 8 GB DDR Memory Speed 2400 MHz Hard Drive 1 TB HDD + Optional SSD Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11ac, Bluetooth Number of USB 2.0 Ports 1 Average Battery Life (in hours) 5 hours',\n",
" 'Screen Size 17.3 inches Max Screen Resolution 1920 x 1080 pixels Processor 4.5 GHz Intel Core i7 RAM 16 GB DDR4 Hard Drive 512 GB 512GB M.2 PCIe NVMe Solid State Drive Chipset Brand NVIDIA Card Description Dedicated Graphics Card Ram Size 6 GB Number of USB 2.0 Ports 1 Number of USB 3.0 Ports 2',\n",
" 'Screen Size 14 inches Max Screen Resolution 1920 x 1080 pixels Processor 3.4 GHz core_m RAM 8 GB DDR3L Hard Drive 64 GB Embedded MultiMediaCard Graphics Coprocessor Intel HD Graphics 615 Chipset Brand NVIDIA Card Description Integrated Graphics Card Ram Size 8 GB Wireless Type 802.11a/b/g/n/ac, Bluetooth Number of USB 3.0 Ports 3',\n",
" 'Screen Size 15.6 inches Screen Resolution 1920x1080 Processor 1.6 GHz Intel Core i5 RAM 8 GB SO-DIMM DDR4 Memory Speed 2400 MHz Hard Drive 1 TB HDD 5400 rpm Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11ac, Bluetooth',\n",
" 'Screen Size 15.6 inches Processor 3.1 GHz Core i7-740QM RAM 4 GB DDR4 Hard Drive 1 TB na Graphics Coprocessor UHD 620 Chipset Brand Intel Card Description Dedicated Number of USB 3.0 Ports 2',\n",
" 'Screen Size 15.6 inches Processor 2.2 GHz Intel Core i7 RAM 8 GB Hard Drive 1 TB flash_memory_solid_state Graphics Coprocessor NVIDIA GeForce GTX 1050 Ti Chipset Brand nvidia Card Description Dedicated Wireless Type 802.11ac',\n",
" 'Screen Size 14.1 inches Screen Resolution 1366x768 Max Screen Resolution 1366x768 Processor 2.5 GHz Intel Core i5 RAM 8 GB DDR3 Hard Drive 128 GB SSD Graphics Coprocessor Intel HD Graphics Chipset Brand Intel Card Description Integrated Wireless Type 802.11bgn',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 Processor 3.9 GHz Core i3 8130U RAM 8 GB Hard Drive 256 GB flash_memory_solid_state Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand intel Card Description Integrated',\n",
" 'Screen Size 15.6 inches Screen Resolution 1920 x 1080 Max Screen Resolution 1920 x 1080 Processor 1.8 GHz Intel Core i7 RAM 16 GB Hard Drive 512 GB SSD Graphics Coprocessor Intel HD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11ac',\n",
" 'Screen Size 15.6 inches Screen Resolution 1366x768 Max Screen Resolution 1366x768 Processor 2.2 GHz Intel Core i3 RAM 12 GB Hard Drive 1 TB mechanical_hard_drive Graphics Coprocessor Intel HD Graphics 620 Chipset Brand intel Card Description Integrated Wireless Type 802.11ac Average Battery Life (in hours) 5 hours',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1366x768 Processor 2.3 GHz Intel Core i3 RAM 12 GB DDR Hard Drive 1 TB HDD 5400 rpm Graphics Coprocessor Intel HD Graphics 620 Chipset Brand intel Card Description integrated Wireless Type 802.11ac',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 Processor 3.9 GHz Intel Core i5 RAM 8 GB DDR4 Hard Drive 256 GB Flash Memory Solid State Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11ac Number of USB 2.0 Ports 1 Number of USB 3.0 Ports 3',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 Processor 3.9 GHz Intel Core i3 RAM 4 GB DDR4 Hard Drive 128 GB Flash Memory Solid State Chipset Brand Intel Card Description Integrated Wireless Type 802.11ac Number of USB 2.0 Ports 1 Number of USB 3.0 Ports 3',\n",
" 'Screen Size 15.6 inches Screen Resolution 1366x768 Processor 2.7 GHz Intel Core i3 RAM 8 GB SDRAM Hard Drive 256 GB SSD Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11bgn',\n",
" 'Screen Size 11.6 inches Max Screen Resolution 1920 x 1080 pixels Processor 2.6 GHz Intel Celeron RAM 4 GB DDR4 Hard Drive 64 GB Hybrid Drive Graphics Coprocessor Intel UHD Graphics 600 Chipset Brand Intel Card Description Integrated Graphics Card Ram Size 4 GB Wireless Type 802.11a/b/g/n/ac, Bluetooth Number of USB 3.0 Ports 3',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 pixels Processor 1.6 GHz Intel Core i5 RAM 8 GB Hard Drive 256 GB Flash Memory Solid State Graphics Coprocessor NVIDIA GeForce MX150 Chipset Brand NVIDIA Card Description Dedicated Graphics Card Ram Size 2 GB Wireless Type 802.11ac Number of USB 2.0 Ports 1 Number of USB 3.0 Ports 3 Average Battery Life (in hours) 15 hours',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 pixels Processor 3.9 GHz Intel Core i5 RAM 8 GB DDR4 Memory Speed 1 GHz Hard Drive 256 GB Hybrid Drive Graphics Coprocessor Intel UHD Graphics 630 Chipset Brand Intel Card Description Integrated Graphics Card Ram Size 8 GB Wireless Type 802.11a/b/g/n/ac, Bluetooth Number of USB 2.0 Ports 2 Number of USB 3.0 Ports 2',\n",
" 'Screen Size 15.6 inches Processor 2.5 GHz Core i5-3210M RAM 8 GB Hard Drive 500 GB HDD 5400 rpm Chipset Brand intel Card Description integrated Wireless Type 802.11b/g, 802.11bgn, 802.11b',\n",
" 'Screen Size 13.5 inches Max Screen Resolution 2256x1504 pixels Processor 1.3 GHz i7-3960X RAM 8 GB LPDDR3 Hard Drive Flash Memory Solid State Graphics Coprocessor I5 Chipset Brand Intel Card Description Integrated Wireless Type 802.11abg, 802.11a/b/g/n/ac, 802.11a/b/g/n, 802.11a Number of USB 3.0 Ports 1',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 Processor 4.5 GHz Intel Core i7 RAM 16 GB DDR4 Hard Drive 256 GB Flash Memory Solid State Chipset Brand NVIDIA Card Description Dedicated Graphics Card Ram Size 6 GB Wireless Type 802.11ac Number of USB 3.0 Ports 4',\n",
" 'Screen Size 15.6 inches Screen Resolution 1920 x 1080 Max Screen Resolution 1920 x 1080 Processor 1.6 GHz Intel Core i5 RAM 12 GB SDRAM Hard Drive 256 GB SSD Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11ac Average Battery Life (in hours) 11 hours',\n",
" 'Screen Size 15.6 inches Screen Resolution 1920x1080 Max Screen Resolution 1920 x 1080 Processor 2.3 GHz Intel Core i5 RAM 8 GB Memory Speed 2133 MHz Hard Drive 256 GB SSD Graphics Coprocessor NVIDIA GeForce GTX 1050 Ti Chipset Brand NVIDIA Card Description Dedicated Graphics Card Ram Size 4 GB Wireless Type 802.11ac Number of USB 2.0 Ports 2 Average Battery Life (in hours) 5.5 hours',\n",
" 'Screen Size 15.6 inches Processor 3.5 GHz Ryzen 3 2200U RAM 4 GB DDR4 Hard Drive 128 GB Flash Memory Solid State Graphics Coprocessor AMD Radeon Vega 3 Chipset Brand AMD Card Description Integrated Number of USB 2.0 Ports 2 Number of USB 3.0 Ports 1',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 pixels Processor 4.1 GHz Intel Core i7 RAM 16 GB DDR4 Hard Drive 256 GB Flash Memory Solid State Graphics Coprocessor NVIDIA GeForce GTX 1060 Chipset Brand NVIDIA Card Description Dedicated Graphics Card Ram Size 6 GB Wireless Type 802.11ac Number of USB 2.0 Ports 2 Number of USB 3.0 Ports 2 Average Battery Life (in hours) 7 hours',\n",
" 'Screen Size 15.6 inches Screen Resolution 1366x768 Max Screen Resolution 1366x768 Processor 1.6 GHz Intel Core i5 RAM 12 GB Hard Drive 1 TB mechanical_hard_drive Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand intel Card Description Integrated Wireless Type 802.11ac Average Battery Life (in hours) 10 hours',\n",
" 'Screen Size 15.6 inches Screen Resolution 1920x1080 Processor 1.8 GHz Intel Mobile CPU RAM 8 GB Hard Drive 256 GB flash_memory_solid_state Chipset Brand Intel Card Description dedicated',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 pixels Processor 1.8 GHz Intel Core i7 RAM 16 GB DDR4 Hard Drive 256 GB Flash Memory Solid State Graphics Coprocessor Intel HD Graphics 620 Chipset Brand Intel Card Description Integrated Graphics Card Ram Size 16 GB Wireless Type 802.11ac Number of USB 3.0 Ports 3',\n",
" 'Screen Size 14 inches Processor 2.6 GHz Intel Celeron RAM 4 GB DDR4 Hard Drive 64 GB Flash Memory Solid State Graphics Coprocessor Intel UHD Graphics 600 Chipset Brand Intel Card Description Integrated Graphics Card Ram Size 4 GB Wireless Type 802.11a/b/g/n/ac, Bluetooth Number of USB 3.0 Ports 2',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1366 x 768 Processor 2.5 GHz Intel Core i5 RAM 8 GB DDR Hard Drive 2 TB mechanical_hard_drive Graphics Coprocessor Intel HD Graphics 620 Chipset Brand intel Card Description Integrated Wireless Type 802.11ac',\n",
" 'Screen Size 15.6 inches Screen Resolution 1366x768 Max Screen Resolution 1366x768 Processor 3.4 GHz Core i3 8130U RAM 8 GB Memory Speed 2400 MHz Hard Drive 1 TB HDD 5400 rpm Graphics Coprocessor Intel Graphics 620 Chipset Brand Intel Card Description integrated Wireless Type 802.11abg, Bluetooth Average Battery Life (in hours) 10 hours',\n",
" 'Screen Size 11.6 inches Max Screen Resolution 1366*768 pixels Processor 1.6 GHz Intel Celeron RAM 4 GB DDR3L Hard Drive 16 GB Embedded MultiMediaCard Graphics Coprocessor Intel HD Graphics Chipset Brand Intel Card Description Integrated Graphics Card Ram Size 4 Wireless Type 802.11ac Number of USB 3.0 Ports 2 Average Battery Life (in hours) 10 hours',\n",
" 'Screen Size 13.3 inches Screen Resolution 3840 x 2160 Max Screen Resolution 3840 x 2160 Processor 1.8 GHz Core i7 Family RAM 16 GB DDR4 Hard Drive 512 GB Flash Memory Solid State Graphics Coprocessor NVIDIA GeForce MX250 Graphics Chipset Brand NVIDIA Card Description Dedicated Graphics Card Ram Size 2 GB Wireless Type 802.11b/g, 802.11bgn, 802.11b',\n",
" 'Screen Size 14 inches Max Screen Resolution 1920 x 1080 Processor 4.6 GHz Core i7 Family RAM 16 GB DDR4 Hard Drive 512 GB Flash Memory Solid State Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11ac Number of USB 2.0 Ports 1 Number of USB 3.0 Ports 1',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920x1080 pixels Processor 4 GHz Intel Core i7 RAM 8 GB DDR4 Memory Speed 2133 MHz Hard Drive 1000 GB Hybrid Drive Graphics Coprocessor NVIDIA GeForce MX150 Chipset Brand nvidia Card Description Dedicated Graphics Card Ram Size 2 GB Wireless Type 802.11a, 802.11b, 802.11g Number of USB 2.0 Ports 2 Number of USB 3.0 Ports 2',\n",
" 'Screen Size 15.6 inches Processor 2.5 GHz AMD A Series RAM 4 GB SDRAM Hard Drive 500 GB mechanical_hard_drive Graphics Coprocessor AMD Radeon R4 Chipset Brand amd Card Description Dedicated Wireless Type 802.11b/g, 802.11bgn, 802.11b Average Battery Life (in hours) 6.25 hours',\n",
" 'Screen Size 14 inches Processor 2.48 GHz Intel Celeron RAM 4 GB DDR3 Hard Drive 32 GB emmc Graphics Coprocessor Intel HD Graphics Chipset Brand intel Card Description Integrated Wireless Type 802.11b/g, 802.11ac, 802.11bgn, 802.11b Average Battery Life (in hours) 10 hours',\n",
" 'Screen Size 11.6 inches Processor 2.1 GHz Intel Celeron RAM 4 GB DDR3 Hard Drive 16 GB flash_memory_solid_state Graphics Coprocessor Intel HD Graphics Chipset Brand intel Card Description Integrated Wireless Type 802.11n',\n",
" 'Screen Size 13.3 inches Processor 1.4 GHz Core i5-650 RAM 4 GB DDR3 Hard Drive 128 GB flash_memory_solid_state Graphics Coprocessor Intel HD Graphics 5000 Chipset Brand intel Card Description Integrated',\n",
" 'Screen Size 15.6 inches Screen Resolution 3840 x 2160 Max Screen Resolution 3840 x 2160 Processor 1.8 GHz Core i7 8550U RAM 16 GB SDRAM Memory Speed 2400 MHz Hard Drive 256 GB SSD Graphics Coprocessor NVIDIA GeForce MX130 Graphics Chipset Brand NVIDIA Card Description dedicated Wireless Type 802.11a',\n",
" 'Screen Size 15.6 inches Screen Resolution 1920x1080 Max Screen Resolution 1920x1080 Processor 2.2 GHz Core i3 8130U RAM 8 GB Hard Drive 128 GB flash_memory_solid_state Graphics Coprocessor Intel HD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11b/g, 802.11bgn, 802.11b',\n",
" 'Screen Size 14 inches Screen Resolution 1920x1080 pixels Max Screen Resolution 1440 x 900 pixels Processor 2.1 GHz AMD R Series RAM 12 GB DDR4 Memory Speed 2400 MHz Hard Drive Flash Memory Solid State Graphics Coprocessor AMD Radeon Vega 8 Chipset Brand AMD Card Description Integrated Wireless Type Bluetooth Number of USB 3.0 Ports 2',\n",
" 'Screen Size 14 inches Screen Resolution 1366x768 Max Screen Resolution 1366 x 768 pixels Processor 1.9 GHz Intel Core i5 RAM 16 GB DDR3 Memory Speed 2133 MHz Hard Drive 256 GB SSD Graphics Coprocessor Intel HD Graphics 4400 Chipset Brand intel Card Description Integrated Graphics Card Ram Size 8 GB Wireless Type 802.11bgn Number of USB 2.0 Ports 4 Number of USB 3.0 Ports 1',\n",
" 'Screen Size 14 inches Processor 2 GHz Intel Core i5 RAM 4 GB DDR3 Hard Drive 512 GB HDD 5400 rpm Graphics Coprocessor Intel HD Graphics 3000 Chipset Brand intel Card Description Integrated Wireless Type 802.11bgn Number of USB 2.0 Ports 3',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1366 x 768 Processor 1.6 GHz Intel Core i5 RAM 8 GB DDR Hard Drive 128 GB Hybrid Graphics Coprocessor Intel HD Graphics 620 Chipset Brand intel Card Description Integrated Wireless Type 802.11ac',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 pixels Processor 2.5 GHz Intel Core i5 RAM 8 GB DDR4 Hard Drive 1000 GB Mechanical Hard Drive Graphics Coprocessor Intel HD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11ac Number of USB 2.0 Ports 2 Number of USB 3.0 Ports 2',\n",
" 'Screen Size 14 inches Processor 2.2 GHz AMD A4 RAM 4 GB DDR4 Memory Speed 1 GHz Hard Drive 64 GB Embedded MultiMediaCard Chipset Brand AMD Card Description Integrated Wireless Type 802.11ac Number of USB 2.0 Ports 1',\n",
" 'Screen Size 14 inches Max Screen Resolution 1920 x 1080 pixels Processor 3.4 GHz core_m RAM 8 GB DDR3L Hard Drive 64 GB Embedded MultiMediaCard Graphics Coprocessor Intel HD Graphics 615 Chipset Brand NVIDIA Card Description Integrated Graphics Card Ram Size 8 GB Wireless Type 802.11a/b/g/n/ac, Bluetooth Number of USB 3.0 Ports 3',\n",
" 'Screen Size 14 inches Processor 2.6 GHz Intel Core i5 RAM 8 GB DDR3 Hard Drive 320 GB HDD 5400 rpm Graphics Coprocessor Intel HD Graphics 4000 Chipset Brand intel Card Description Integrated Wireless Type 802.11bgn',\n",
" 'Screen Size 15.6 inches Screen Resolution 1366 x 768 Max Screen Resolution 1366 x 768 Processor 2.4 GHz Intel Core i3 RAM 16 GB Hard Drive 1 TB HDD Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11ac',\n",
" 'Screen Size 15.6 inches Processor 3.5 GHz Ryzen 3 2200U RAM 4 GB DDR4 Hard Drive 128 GB Flash Memory Solid State Graphics Coprocessor AMD Radeon Vega 3 Chipset Brand AMD Card Description Integrated Number of USB 2.0 Ports 2 Number of USB 3.0 Ports 1',\n",
" 'Screen Size 14 inches Screen Resolution 1366x768 Processor 2.5 GHz Celeron N RAM 4 GB Hard Drive 32 GB SSD Graphics Coprocessor Intel HD Graphics 500 Chipset Brand Intel Card Description Integrated Wireless Type 802.11a Average Battery Life (in hours) 10 hours',\n",
" 'Screen Size 14 inches Screen Resolution 1366x768 Processor 1.6 GHz Intel Celeron RAM 4 GB SO-DIMM Hard Drive 64 GB emmc Graphics Coprocessor Intel HD Graphics Chipset Brand Intel Card Description Integrated Wireless Type 802.11ac, 802.11bgn Average Battery Life (in hours) 10 hours',\n",
" 'Screen Size 14 inches Screen Resolution 1366 x 768 Max Screen Resolution 1366 x 768 Processor 1.4 GHz Intel Celeron RAM 4 GB DDR3 Hard Drive 16 GB SSD Graphics Coprocessor Intel Chipset Brand Intel Card Description Integrated Wireless Type 802.11abg Number of USB 2.0 Ports 1',\n",
" 'Screen Size 14 inches Processor 2.2 GHz AMD A4 RAM 4 GB SDRAM Memory Speed 1 GHz Hard Drive 64 GB Embedded MultiMediaCard Chipset Brand AMD Card Description Integrated Wireless Type 802.11ac Number of USB 2.0 Ports 1',\n",
" 'Screen Size 15.6 inches Screen Resolution HD ( 1366 x 768 ) Max Screen Resolution HD ( 1366 x 768 ) Processor 2.6 GHz AMD A Series RAM 8 GB DDR Memory Speed 2133 MHz Hard Drive 512 GB SSD Graphics Coprocessor AMD Radeon R4 Graphics Integrated Chipset Brand AMD Card Description integrated Wireless Type 802.11ac Average Battery Life (in hours) 5 hours',\n",
" 'Screen Size 14 inches Screen Resolution 1366x768 Max Screen Resolution 1366x768 Processor 1.1 GHz Intel Celeron RAM 2 GB DDR Hard Drive 32 GB emmc Graphics Coprocessor Intel HD Graphics 500 Chipset Brand intel Card Description Integrated Wireless Type 802.11ac Number of USB 2.0 Ports 1 Number of USB 3.0 Ports 1',\n",
" 'Screen Size 15.6 inches Screen Resolution 1920x1080 Max Screen Resolution 1920 x 1080 Processor 1.8 GHz Intel Core i7 RAM 8 GB A8 Hard Drive 1 TB SSD Graphics Coprocessor Intel HD Graphics 620 Chipset Brand Intel Card Description Integrated Graphics Card Ram Size 3 Wireless Type Bluetooth Number of USB 2.0 Ports 1 Number of USB 3.0 Ports 3',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 pixels Processor 4 GHz AMD Ryzen 7 RAM 16 GB DDR4 Memory Speed 2666 MHz Hard Drive 1 TB Flash Memory Solid State Graphics Coprocessor NVIDIA GeForce GTX 1660Ti Chipset Brand NVIDIA Card Description Dedicated Graphics Card Ram Size 6 GB Wireless Type 802.11b/n/ac, Bluetooth Number of USB 2.0 Ports 1 Number of USB 3.0 Ports 2',\n",
" 'Screen Size 14 inches Max Screen Resolution 1366 x 768 Processor 2.3 GHz Pentium Other RAM 4 GB Hard Drive 128 GB flash_memory_solid_state Graphics Coprocessor Graphics 610 Chipset Brand intel Card Description integrated',\n",
" 'Screen Size 14 inches Screen Resolution 1366x768 Max Screen Resolution 1366 x 768 pixels Processor 2.1 GHz MediaTek_MT8127 RAM 4 GB DDR4 Hard Drive Flash Memory Solid State Graphics Coprocessor Integrated Mediatek Graphics Chipset Brand PowerVR Card Description Integrated Wireless Type 802.11ac Number of USB 3.0 Ports 1 Average Battery Life (in hours) 10 hours',\n",
" 'Screen Size 14 inches Max Screen Resolution 1920 x 1080 Processor 4.6 GHz Core i7 Family RAM 16 GB DDR4 Hard Drive 512 GB Flash Memory Solid State Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11ac Number of USB 2.0 Ports 1 Number of USB 3.0 Ports 1',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 pixels Processor 4.6 GHz Intel Core i7 RAM 8 GB DDR4 Hard Drive 1 TB Flash Memory Solid State Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand Intel Card Description Integrated Graphics Card Ram Size 8 GB Wireless Type 802.11b/n/ac, Bluetooth Number of USB 2.0 Ports 2 Number of USB 3.0 Ports 2',\n",
" 'Screen Size 14 inches Max Screen Resolution 1920 x 1080 pixels Processor 1.8 GHz Core i7-860 RAM 16 GB DDR4 Hard Drive 512 GB Flash Memory Solid State Graphics Coprocessor Intel HD Graphics 620 Chipset Brand Intel Card Description Integrated Graphics Card Ram Size 128 MB Wireless Type 802.11ac Number of USB 3.0 Ports 2',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 Processor 4.6 GHz Intel Core i7 RAM 16 GB Hard Drive 512 GB SSD Graphics Coprocessor GeForce MX130 Chipset Brand nvidia Card Description dedicated Wireless Type 802.11ac',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 pixels Processor 2.2 GHz Intel Core i3 RAM 6 GB DDR3 Hard Drive 1000 GB Mechanical Hard Drive Graphics Coprocessor Intel HD Graphics 620 Chipset Brand Intel Card Description Integrated Graphics Card Ram Size 2 GB Wireless Type 802.11ac Number of USB 2.0 Ports 1 Number of USB 3.0 Ports 3 Average Battery Life (in hours) 13.5 hours',\n",
" 'Screen Size 14 inches Screen Resolution 1366x768 Max Screen Resolution 1366 x 768 Processor 2.3 GHz Pentium RAM 4 GB SDRAM Hard Drive 128 GB flash_memory_solid_state Graphics Coprocessor Intel HD Graphics 610 Chipset Brand intel Card Description integrated Wireless Type 802.11bgn',\n",
" 'Screen Size 11.6 inches Screen Resolution 1366 x 768 Max Screen Resolution 1366X768 pixels Processor 2.1 GHz MediaTek_MT8127 RAM 4 GB LPDDR3 Memory Speed 1600 MHz Hard Drive 64 GB Flash Memory Solid State Graphics Coprocessor PowerVR SGX543 Chipset Brand Intel Card Description Integrated Wireless Type 802.11a, 802.11b, 802.11g Number of USB 3.0 Ports 1',\n",
" 'Screen Size 17 inches Max Screen Resolution 2560 x 1600 pixels Processor 1.8 GHz Intel Core i7 RAM 16 GB DDR4 Hard Drive 512 GB Flash Memory Solid State Graphics Coprocessor Intel HD Graphics 610 Chipset Brand Intel Card Description Integrated Graphics Card Ram Size 16 GB Number of USB 3.0 Ports 4 Average Battery Life (in hours) 5 hours',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 Processor 3.9 GHz Intel Core i5 RAM 8 GB DDR4 Hard Drive 256 GB Flash Memory Solid State Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11ac Number of USB 2.0 Ports 1 Number of USB 3.0 Ports 3',\n",
" 'Screen Size 13.3 inches Max Screen Resolution 1366 x 768 Processor 1.6 GHz Core i5-5250U RAM 4 GB Hard Drive 256 GB flash_memory_solid_state Graphics Coprocessor Intel HD Graphics 6000 Chipset Brand intel Card Description integrated Wireless Type 802.11ac Average Battery Life (in hours) 12 hours',\n",
" 'Screen Size 11.6 inches Screen Resolution 1366x768 Max Screen Resolution 1366x768 Processor 2.58 GHz Intel Celeron RAM 4 GB Memory Speed 12800 GHz Hard Drive 16 GB SSD Graphics Coprocessor Intel HD Graphics Chipset Brand Intel Card Description Integrated Wireless Type 802.11abg Number of USB 2.0 Ports 3 Average Battery Life (in hours) 5 hours',\n",
" 'Screen Size 14 inches Processor 1.6 GHz Intel Celeron D RAM 4 GB DDR3 Hard Drive 32 GB emmc Graphics Coprocessor Intel HD Graphics 400 Chipset Brand intel Card Description Integrated Wireless Type 802.11ac Average Battery Life (in hours) 5 hours',\n",
" 'Screen Size 13.3 inches Max Screen Resolution 1366 x 768 HD Processor 1.7 GHz Intel Core i3 RAM 4 GB Hard Drive 500 GB HDD Graphics Coprocessor Intel HD Graphics 4400 Chipset Brand intel Card Description Integrated',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1366x768 pixels Processor 2.7 GHz Athlon 2650e RAM 8 GB DDR3 Hard Drive 1000 GB Hybrid Drive Chipset Brand amd Card Description Integrated Number of USB 2.0 Ports 1 Number of USB 3.0 Ports 2 Average Battery Life (in hours) 5 hours',\n",
" 'Screen Size 14 inches Screen Resolution 1920x1080 Max Screen Resolution 1920 x 1080 Processor 1.1 GHz Pentium RAM 4 GB Hard Drive 64 GB emmc Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand intel Card Description Integrated Wireless Type 802.11b/g, 802.11bgn, 802.11b',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1366 x 768 Processor 2.48 GHz Intel Celeron RAM 4 GB DDR3 Hard Drive 16 GB flash_memory_solid_state Graphics Coprocessor Intel HD Graphics 400 Chipset Brand intel Card Description Integrated Wireless Type 802.11ac Average Battery Life (in hours) 12 hours',\n",
" 'Screen Size 15.6 inches Processor 2.5 GHz Intel Core i5 RAM 8 GB DDR Hard Drive 256 GB SSD Graphics Coprocessor Intel HD Graphics 620 Chipset Brand intel Card Description integrated Wireless Type 802.11abg Number of USB 2.0 Ports 2',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1366 x 768 Processor 3.1 GHz AMD A Series RAM 4 GB Hard Drive 128 GB flash_memory_solid_state Graphics Coprocessor AMD Radeon R5 Chipset Brand amd Card Description Dedicated Wireless Type 802.11ac',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 Processor 2.2 GHz Intel Core i7 RAM 8 GB SO-DIMM Hard Drive 256 GB Flash Memory Solid State Chipset Brand NVIDIA Card Description Dedicated Number of USB 3.0 Ports 4',\n",
" 'Screen Size 11.6 inches Screen Resolution 1366x768 Max Screen Resolution 1366 x 768 pixels Processor 1.1 GHz Pentium RAM 4 GB SDRAM Hard Drive 64 GB Flash Memory Solid State Graphics Coprocessor Intel HD Graphics Chipset Brand Intel Card Description Integrated Graphics Card Ram Size 4 GB Wireless Type 801.11ac, Bluetooth Number of USB 2.0 Ports 3 Number of USB 3.0 Ports 1 Average Battery Life (in hours) 6 hours',\n",
" 'Screen Size 11.6 inches Max Screen Resolution 1366 x 768 Processor 1.6 GHz Intel Celeron RAM 4 GB DDR3 Hard Drive 16 GB emmc Graphics Coprocessor Intel HD Graphics 400 Chipset Brand intel Card Description Integrated Wireless Type 802.11ac Average Battery Life (in hours) 12.5 hours',\n",
" 'Screen Size 14 inches Processor 2.6 GHz Celeron N RAM 4 GB DDR3 Hard Drive 32 GB SSD Graphics Coprocessor Intel HD Graphics Chipset Brand intel Card Description integrated Wireless Type 802.11abg, 802.11a/b/g/n, 802.11a Number of USB 2.0 Ports 1',\n",
" 'Screen Size 11.6 inches Screen Resolution 1366x768 Max Screen Resolution 1366x768 Processor 1.83 GHz Intel Celeron RAM 4 GB SO-DIMM DDR3 Hard Drive 128 GB SSD Graphics Coprocessor Intel Chipset Brand Intel Card Description Integrated Wireless Type 802.11abg, 802.11ac Number of USB 2.0 Ports 1',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 pixels Processor 3.9 GHz Intel Core i7 RAM 16 GB DDR4 Memory Speed 2666 MHz Hard Drive 512 GB Hybrid Drive Graphics Coprocessor NVIDIA GeForce RTX 2070 Chipset Brand NVIDIA Card Description Dedicated Graphics Card Ram Size 8 GB Wireless Type 802.11a/b/g/n/ac, Bluetooth Number of USB 3.0 Ports 3',\n",
" 'Screen Size 15.6 inches Screen Resolution 3840x2160 Max Screen Resolution 3840 x 2160 pixels Processor 2.8 GHz Intel Core i7 RAM 16 GB DDR Hard Drive 512 GB Flash Memory Solid State Graphics Coprocessor NVIDIA GeForce GTX 1050 Ti Chipset Brand nvidia Card Description Dedicated Graphics Card Ram Size 4 GB Wireless Type 802.11ac Number of USB 3.0 Ports 2 Average Battery Life (in hours) 8 hours',\n",
" 'Screen Size 15.6 inches Processor 3.1 GHz Intel Core i5 RAM 8 GB Hard Drive 256 GB flash_memory_solid_state Graphics Coprocessor Intel HD Chipset Brand intel Card Description Integrated',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 pixels Processor 1.8 GHz Core i7 8750H RAM 16 GB DDR3 Hard Drive Flash Memory Solid State Chipset Brand Intel Card Description Integrated Graphics Card Ram Size 2 Wireless Type 801.11ac Number of USB 3.0 Ports 2',\n",
" 'Screen Size 14 inches Screen Resolution 1366 x 768 Max Screen Resolution SVA anti-glare LED-backlit Non touch Processor 3.4 GHz Core i5 8250U RAM 8 GB Hard Drive 256 GB SSD Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand intel Card Description Integrated Wireless Type 802.11ac',\n",
" 'Screen Size 15.6 inches Screen Resolution 1366 x 768 Max Screen Resolution 1366 x 768 Processor 2.7 GHz Intel Core i3 RAM 8 GB DDR Hard Drive 1 TB HDD 5400 rpm Graphics Coprocessor Intel HD Graphics 620 Chipset Brand Intel Card Description Shared, Integrated Graphics Card Ram Size 1 GB Wireless Type Bluetooth, 802.11n Number of USB 2.0 Ports 1 Number of USB 3.0 Ports 2',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920x1080 pixels Processor 1.8 GHz Intel Core i5 RAM 8 GB DDR4 Memory Speed 2133 MHz Hard Drive 256 GB Flash Memory Solid State Graphics Coprocessor Intel Integrated Graphics Chipset Brand Intel Card Description Integrated Graphics Card Ram Size 1 GB Wireless Type 802.11a, 802.11b, 802.11g Number of USB 2.0 Ports 2 Number of USB 3.0 Ports 2',\n",
" 'Screen Size 15.6 inches Screen Resolution 1366x768 Max Screen Resolution 1366 x 768 Processor 1.6 GHz Core i5 8250U RAM 4 GB DDR4 Memory Speed 2133 MHz Hard Drive 1 TB Flash Memory Solid State Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11ac Number of USB 2.0 Ports 2 Average Battery Life (in hours) 7 hours',\n",
" 'Screen Size 17.3 inches Screen Resolution 1920x1080 pixels Max Screen Resolution 1920 x 1080 pixels Processor 3.9 GHz Intel Core i7 RAM 16 GB DDR4 Memory Speed 2666 MHz Hard Drive 1000 GB Hybrid Drive Graphics Coprocessor NVIDIA GeForce GTX 1060 Chipset Brand Intel Card Description Dedicated Graphics Card Ram Size 6 GB Wireless Type 802.11a/b/g/n/ac Number of USB 3.0 Ports 5',\n",
" 'Screen Size 13.3 inches Max Screen Resolution 1366*768 Processor 2.6 GHz Core i7 4600U RAM 8 GB DDR3 Hard Drive 256 GB flash_memory_solid_state Graphics Coprocessor Intel Integrated Graphics Chipset Brand intel Card Description integrated Wireless Type 802.11a/b/g/n/ac, 802.11ac',\n",
" 'Screen Size 17.3 inches Screen Resolution 1920x1080 Max Screen Resolution 1920x1080 Processor 2.3 GHz AMD R Series RAM 16 GB Hard Drive 512 GB PCIe SSD Graphics Coprocessor NVIDIA GeForce GTX 1650 4GB GDDR5 Chipset Brand nvidia Card Description dedicated Wireless Type 802.11abg, 802.11a/b/g/n/ac, 802.11ac, 802.11a/b/g/n, 802.11a Average Battery Life (in hours) 5 hours',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 Processor 3.9 GHz Intel Core i5 RAM 8 GB DDR4 Hard Drive 256 GB Flash Memory Solid State Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11ac Number of USB 2.0 Ports 1 Number of USB 3.0 Ports 3',\n",
" 'Screen Size 15.6 inches Processor 2.7 GHz Pentium RAM 4 GB Hard Drive 1 TB HDD 5400 rpm Graphics Coprocessor Intel Chipset Brand intel Card Description Integrated Wireless Type 802.11ac',\n",
" 'Screen Size 14 inches Processor 2.6 GHz Intel Core i5 RAM 8 GB DDR3 Hard Drive 128 GB SSD Graphics Coprocessor Intel HD Graphics 4000 Chipset Brand intel Card Description Integrated Wireless Type 802.11bgn Number of USB 2.0 Ports 3',\n",
" 'Screen Size 11.6 inches Max Screen Resolution 1366 x 768 pixels Processor 2.48 GHz Celeron N3060 RAM 4 GB DDR3L Hard Drive 32 GB emmc Graphics Coprocessor Intel HD Graphics 400 Chipset Brand Intel Card Description Integrated Wireless Type 802.11ac Number of USB 2.0 Ports 1 Number of USB 3.0 Ports 1',\n",
" 'Screen Size 11.6 inches Max Screen Resolution 1366 x 768 Processor 3 GHz AMD A Series RAM 4 GB DDR4 Hard Drive 64 GB 64GB eMMC Storage Chipset Brand AMD Card Description Integrated Wireless Type 802.11bgn Number of USB 2.0 Ports 2 Number of USB 3.0 Ports 1',\n",
" 'Screen Size 15.6 inches Screen Resolution 1366x768 Processor 2.5 GHz AMD A Series RAM 4 GB DDR3 Memory Speed 2133 MHz Hard Drive 500 GB HDD 5400 rpm Graphics Coprocessor AMD Radeon R4 Chipset Brand AMD Card Description Dedicated Wireless Type 802.11bgn',\n",
" 'Screen Size 15.6 inches Screen Resolution 1920 x 1080 Max Screen Resolution 1920 x 1080 Processor 2.7 GHz AMD A Series RAM 12 GB Hard Drive 128 GB flash_memory_solid_state Graphics Coprocessor AMD Radeon R7 Chipset Brand amd Card Description Dedicated Wireless Type 802.11ac',\n",
" 'Screen Size 15.6 inches Screen Resolution 1366x768 Max Screen Resolution HD 1366x768 Processor 2.7 GHz Intel Core i5 RAM 8 GB Memory Speed 2133 MHz Hard Drive 256 GB SSD Graphics Coprocessor Intel HD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11b/g, 802.11bgn, 802.11b',\n",
" 'Screen Size 15.6 inches Screen Resolution 1366x768 Max Screen Resolution 1366 x 768 Processor 2.6 GHz AMD A6 RAM 4 TB Memory Speed 2400 MHz Hard Drive 1 TB mechanical_hard_drive Graphics Coprocessor AMD Radeon R4 Chipset Brand amd Card Description Dedicated Wireless Type 802.11bgn',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 Processor 2.3 GHz Intel Core i5 RAM 16 GB Hard Drive 1256 GB Hybrid Graphics Coprocessor NVIDIA GeForce GTX 1050 Ti Chipset Brand nvidia Card Description Dedicated Wireless Type 802.11ac Average Battery Life (in hours) 6 hours',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 pixels Processor 1.8 GHz Intel Core i7 RAM 16 GB DDR4 Hard Drive 1 TB Flash Memory Solid State Graphics Coprocessor Intel HD Graphics 620 Chipset Brand Intel Card Description Integrated Graphics Card Ram Size 128 MB Wireless Type 801.11ac Number of USB 3.0 Ports 3',\n",
" 'Screen Size 14 inches Processor 2.5 GHz Intel Core i5 RAM 8 GB DDR3 Hard Drive 512 GB flash_memory_solid_state Graphics Coprocessor Intel HD Integrated Chipset Brand intel Card Description Integrated Wireless Type 802.11bgn Number of USB 2.0 Ports 4',\n",
" 'Screen Size 14 inches Screen Resolution 1366x768 Max Screen Resolution 1366x768 Processor 3 GHz Core i5 8400T RAM 8 GB SO-DIMM DDR3 Hard Drive 256 GB SSD Graphics Coprocessor Intel HD Graphics 5500 Chipset Brand Intel Card Description Dedicated Wireless Type 802.11abg, 802.11ab, 802.11n',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 pixels Processor 2.6 GHz Intel Core i7 RAM 8 GB DDR4 Memory Speed 2400 MHz Hard Drive 1 TB Mechanical Hard Drive Graphics Coprocessor NVIDIA GeForce GTX 1050 Chipset Brand NVIDIA Card Description Dedicated Graphics Card Ram Size 3 GB Wireless Type 801.11ac, Bluetooth Number of USB 3.0 Ports 2',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 pixels Processor 3.4 GHz Intel Core i5 RAM 8 GB DDR4 Hard Drive 1000 GB Hybrid Drive Graphics Coprocessor Intel HD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11ac Number of USB 2.0 Ports 2 Number of USB 3.0 Ports 2 Average Battery Life (in hours) 5 hours',\n",
" 'Screen Size 14 inches Screen Resolution 1366x768 Max Screen Resolution 1366x768 Processor 2.6 GHz AMD A Series RAM 4 GB Hard Drive 512 GB flash_memory_solid_state Graphics Coprocessor AMD Radeon R4 Chipset Brand amd Card Description Dedicated Wireless Type 802.11b/g, 802.11bgn, 802.11b',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 pixels Processor 4 GHz Intel Core i5 RAM 8 GB DRAM Memory Speed 2666 MHz Hard Drive 1000 GB Mechanical Hard Drive Graphics Coprocessor NVIDIA GeForce GTX 1050 Ti Chipset Brand intel Card Description Dedicated Wireless Type 802.11b, 802.11g, 802.11n',\n",
" 'Screen Size 14 inches Screen Resolution 1366 x 768 Processor 2.6 GHz Intel Core i5 RAM 8 GB SDRAM DDR3 Hard Drive 320 GB HDD 7200 rpm Graphics Coprocessor Intel Integrated Graphics Chipset Brand intel Card Description Integrated Wireless Type 802.11n Number of USB 2.0 Ports 2',\n",
" 'Screen Size 15.6 inches Screen Resolution 1366 x 768 Max Screen Resolution 1366 x 768 Processor 1.6 GHz Intel Core i5 RAM 8 GB Hard Drive 256 GB SSD Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11abg, 802.11a/b/g/n/ac, 802.11a/b/g/n, 802.11a',\n",
" 'Screen Size 15.6 inches Screen Resolution 1366x768 Max Screen Resolution 1366 x 768 Processor 2.6 GHz AMD A6 RAM 8 GB Hard Drive 1 TB HDD 5400 rpm Graphics Coprocessor AMD Radeon R4 Chipset Brand amd Card Description Dedicated Wireless Type 802.11bgn, 802.11b Number of USB 2.0 Ports 1',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 pixels Processor 3.9 GHz Intel Core i7 RAM 16 GB DDR4 Memory Speed 2666 MHz Hard Drive 1000 GB Hybrid Drive Graphics Coprocessor NVIDIA GeForce GTX 1060 Chipset Brand NVIDIA Card Description Dedicated Graphics Card Ram Size 6 GB Wireless Type 802.11a/b/g/n/ac Number of USB 3.0 Ports 4',\n",
" 'Screen Size 11.6 inches Max Screen Resolution 1366 x 768 Processor 1.1 GHz Intel Core 2 Duo RAM 2 GB DDR3 Hard Drive 32 GB emmc Graphics Coprocessor Intel UHD Graphics 600 Chipset Brand Intel Card Description Dedicated Graphics Card Ram Size 2 Wireless Type 802.11ac Number of USB 2.0 Ports 2 Number of USB 3.0 Ports 2 Average Battery Life (in hours) 10 hours',\n",
" 'Screen Size 15.6 inches Screen Resolution 1366x768 Processor 1.6 GHz Intel Celeron RAM 4 GB SDRAM Memory Speed 1600 MHz Hard Drive 16 GB eMMC Graphics Coprocessor Intel HD Graphics 400 Chipset Brand intel Card Description Integrated Wireless Type Bluetooth, 802.11ac Number of USB 3.0 Ports 2',\n",
" 'Screen Size 14 inches Processor 2.6 GHz Celeron N RAM 4 GB DDR4 Hard Drive 64 GB Embedded MultiMediaCard Chipset Brand Intel Card Description Integrated Number of USB 2.0 Ports 1',\n",
" 'Screen Size 11.6 inches Screen Resolution 1366 x 768 (HD) Max Screen Resolution 1366 x 768 (HD) Processor 1.1 GHz Intel Celeron RAM 4 GB Hard Drive 32 GB emmc Graphics Coprocessor Intel Chipset Brand Intel® UHD Graphics 600 Card Description Integrated',\n",
" 'Screen Size 14 inches Max Screen Resolution 1366 x 768 Processor 2.2 GHz AMD A4 RAM 4 GB SDRAM Hard Drive 32 GB Flash Memory Solid State Graphics Coprocessor AMD Radeon R3 Chipset Brand AMD Card Description Integrated Wireless Type 802.11ac Number of USB 2.0 Ports 1',\n",
" 'Screen Size 11.6 inches Processor 1.44 GHz Intel Atom RAM 4 GB DDR3 Hard Drive 64 GB Flash Memory Solid State Chipset Brand Intel Card Description Integrated Number of USB 2.0 Ports 2 Number of USB 3.0 Ports 1',\n",
" 'Screen Size 11.6 inches Processor 2.7 GHz Atom x5 Z8300 RAM 4 GB DDR3L Hard Drive 32 GB Flash Memory Solid State Chipset Brand Intel Card Description Integrated',\n",
" 'Screen Size 13.3 inches Max Screen Resolution 1920 x 1080 pixels Processor 4.6 GHz Intel Core i7 RAM 16 GB DDR3 Hard Drive 512 GB Flash Memory Solid State Graphics Coprocessor Intel HD Graphics 620 Chipset Brand Intel Card Description Integrated Graphics Card Ram Size 16 GB Wireless Type 802.11b/n/ac, Bluetooth Number of USB 2.0 Ports 1 Number of USB 3.0 Ports 2',\n",
" 'Screen Size 14 inches Processor 3.9 GHz Core i3 Family RAM 4 GB DDR4 Hard Drive 128 GB 128GB m.2 PCIe Solid State Drive Chipset Brand Intel Card Description Integrated Wireless Type 802.11ac Number of USB 2.0 Ports 1 Number of USB 3.0 Ports 2',\n",
" 'Screen Size 15.6 inches Screen Resolution 1366x768 Max Screen Resolution 1366 x 768 Processor 2.4 GHz Core i3 7100U RAM 4 GB SDRAM Hard Drive 1 TB HDD 5400 rpm Graphics Coprocessor Intel HD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11a',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1366 x 768 Processor 3.1 GHz AMD A Series RAM 4 GB Hard Drive 128 GB flash_memory_solid_state Graphics Coprocessor Other Chipset Brand amd Card Description integrated Average Battery Life (in hours) 5 hours',\n",
" 'Screen Size 15.6 inches Screen Resolution 1366x768 Max Screen Resolution 1366 x 768 Processor 2.6 GHz AMD A6 RAM 8 GB SDRAM Hard Drive 1 TB mechanical_hard_drive Graphics Coprocessor AMD Radeon R4 Chipset Brand amd Card Description Dedicated Wireless Type 802.11ac',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1366 x768 pixels Processor 2.5 GHz Apple A6 RAM 4 GB SD Hard Drive 500 GB Flash Memory Solid State Graphics Coprocessor AMD Radeon R4 Chipset Brand amd Card Description Integrated Wireless Type 802.11bgn Number of USB 2.0 Ports 1 Number of USB 3.0 Ports 2',\n",
" 'Screen Size 15.6 inches Screen Resolution 1366 x 768 Max Screen Resolution 1366 x 768 Processor 2.4 GHz Intel Core i3 RAM 8 GB Hard Drive 256 GB SSD Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11ac',\n",
" 'Screen Size 15.6 inches Screen Resolution 1366x768 Max Screen Resolution 1366x768 Processor 1.6 GHz Intel Core i5 RAM 16 GB DDR4 Hard Drive 512 GB SSD Graphics Coprocessor Intel HD Graphics 620 Chipset Brand intel Card Description Integrated Wireless Type 802.11ac',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 pixels Processor 4.1 GHz Intel Core i7 RAM 16 GB DDR4 Hard Drive 256 GB Flash Memory Solid State Graphics Coprocessor NVIDIA GeForce GTX 1060 Chipset Brand NVIDIA Card Description Dedicated Graphics Card Ram Size 6 GB Wireless Type 802.11ac Number of USB 2.0 Ports 2 Number of USB 3.0 Ports 2 Average Battery Life (in hours) 7 hours',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 Processor 2.6 GHz Intel Core i5 RAM 8 GB SO-DIMM Hard Drive 256 GB Flash Memory Solid State Graphics Coprocessor NVIDIA GeForce GTX 1050 Chipset Brand NVIDIA Card Description Dedicated Number of USB 3.0 Ports 4',\n",
" 'Screen Size 14 inches Screen Resolution 1366x768 Max Screen Resolution 1366x768 Processor 1.1 GHz Intel Celeron RAM 2 GB DDR Hard Drive 32 GB emmc Graphics Coprocessor Intel HD Graphics 500 Chipset Brand intel Card Description Integrated Wireless Type 802.11ac Number of USB 2.0 Ports 1 Number of USB 3.0 Ports 1',\n",
" 'Screen Size 14 inches Processor 2.6 GHz Intel Celeron RAM 4 GB Hard Drive 32 GB emmc Graphics Coprocessor intel Chipset Brand Intel Card Description Integrated Wireless Type 802.11ac',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1366 x 768 Processor 1.1 GHz Intel Celeron D RAM 8 GB Hard Drive 1 TB flash_memory_solid_state Graphics Coprocessor INTEL Chipset Brand intel Card Description Integrated Wireless Type 802.11ac',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 pixels Processor 3.9 GHz Intel Core i3 RAM 8 GB DDR4 Hard Drive 128 GB Flash Memory Solid State Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand Intel Card Description Integrated Graphics Card Ram Size 8 GB Wireless Type 802.11b/n/ac Number of USB 2.0 Ports 2 Number of USB 3.0 Ports 2',\n",
" 'Screen Size 15.6 inches Screen Resolution 1920 x 1080 Max Screen Resolution 1920 x 1080 Processor 2.7 GHz AMD A Series RAM 16 GB Hard Drive 500 GB flash_memory_solid_state Graphics Coprocessor AMD Radeon R7 Chipset Brand amd Card Description Dedicated Wireless Type 802.11ac',\n",
" 'Screen Size 15.6 inches Processor 2.7 GHz AMD A Series RAM 4 GB DDR Hard Drive 128 GB mechanical_hard_drive Graphics Coprocessor AMD Radeon R7 Chipset Brand amd Card Description Dedicated Wireless Type 802.11ac',\n",
" 'Screen Size 14 inches Processor 2 GHz Core i5 4300U RAM 8 GB Memory Speed 2133 MHz Hard Drive 500 GB mechanical_hard_drive Chipset Brand intel Card Description Integrated Intel HD Graphics Wireless Type 802.11ac, 802.11a/b/g/n Number of USB 2.0 Ports 4',\n",
" 'Screen Size 14 inches Max Screen Resolution 1920 x 1080 pixels Processor 1.1 GHz Intel Celeron RAM 4 GB DDR4 Hard Drive 64 GB Flash Memory Solid State Chipset Brand intel Card Description Integrated Wireless Type 802.11ac Number of USB 2.0 Ports 2 Number of USB 3.0 Ports 1 Average Battery Life (in hours) 6.5 hours',\n",
" 'Screen Size 14 inches Screen Resolution 1366x768 Max Screen Resolution 1366x768 Processor 1.6 GHz Intel Celeron RAM 4 GB DDR3 Memory Speed 1.6 GHz Hard Drive 32 GB SSD Graphics Coprocessor Intel HD Graphics 400 Chipset Brand Intel Card Description integrated Wireless Type 802.11ac, Bluetooth Number of USB 2.0 Ports 1',\n",
" 'Screen Size 15.6 inches Screen Resolution 1920x1080 Max Screen Resolution 1920x1080 Processor 2.7 GHz AMD A Series RAM 8 GB DDR4 Hard Drive 256 GB flash_memory_solid_state Graphics Coprocessor AMD Radeon R7 Chipset Brand amd Card Description Dedicated Wireless Type 802.11ac Number of USB 2.0 Ports 1',\n",
" 'Screen Size 11.6 inches Screen Resolution 1366x768 Max Screen Resolution 1366x768 Processor 1.6 GHz Intel Celeron RAM 4 GB DDR3 Hard Drive 32 GB SSD Graphics Coprocessor Intel HD Graphics Chipset Brand Intel Card Description Integrated Wireless Type 802.11b/g, 802.11bgn, 802.11b Number of USB 2.0 Ports 1 Average Battery Life (in hours) 16 hours',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920 x 1080 pixels Processor 2.5 GHz Intel Core i5 RAM 8 GB DDR4 Hard Drive 256 GB Flash Memory Solid State Graphics Coprocessor NVIDIA GeForce GTX 1050 Ti Chipset Brand NVIDIA Card Description Dedicated Graphics Card Ram Size 4000 GB Wireless Type Bluetooth Number of USB 2.0 Ports 2 Number of USB 3.0 Ports 2 Average Battery Life (in hours) 8.5 hours',\n",
" 'Screen Size 12.5 inches Max Screen Resolution 1920 x 1080 pixels Processor 2.5 GHz Intel Core i5 RAM 8 GB Hard Drive 128 GB SSD Graphics Coprocessor shared Chipset Brand Intel HD Graphics Card Description Integrated Wireless Type 802.11bgn Number of USB 3.0 Ports 2 Average Battery Life (in hours) 12.5 hours',\n",
" 'Screen Size 14 inches Screen Resolution 1366x768 Max Screen Resolution 1366x768 Processor 2.6 GHz AMD A Series RAM 4 GB Hard Drive 500 GB mechanical_hard_drive Graphics Coprocessor AMD Radeon R4 Chipset Brand amd Card Description Dedicated Wireless Type 802.11b/g, 802.11bgn, 802.11b',\n",
" 'Screen Size 11.6 inches Screen Resolution 1366 x 768 Max Screen Resolution 1366X768 pixels Processor 2.1 GHz MediaTek_MT8127 RAM 4 GB LPDDR3 Memory Speed 1600 MHz Hard Drive 64 GB Flash Memory Solid State Graphics Coprocessor PowerVR SGX543 Chipset Brand Intel Card Description Integrated Wireless Type 802.11a, 802.11b, 802.11g Number of USB 3.0 Ports 1',\n",
" 'Screen Size 15.6 inches Max Screen Resolution 1920x1080 pixels Processor 2.2 GHz Intel Core i7 RAM 16 GB DDR4 Hard Drive 1000 GB Hybrid Drive Graphics Coprocessor NVIDIA GeForce GTX 1060 Max-Q Chipset Brand NVIDIA Card Description Dedicated Graphics Card Ram Size 6 GB Wireless Type 802.11abg Number of USB 3.0 Ports 3',\n",
" 'Screen Size 15.6 inches Processor 2.7 GHz AMD A Series RAM 8 GB DDR Hard Drive 1 TB HDD 5400 rpm Graphics Coprocessor AMD Radeon R7 Chipset Brand amd Card Description Dedicated Wireless Type 802.11abg',\n",
" 'Screen Size 156 inches Screen Resolution 1366x768 Max Screen Resolution 1366 x 768 Processor 2.7 GHz Intel Core i3 RAM 8 GB DDR Hard Drive 1 TB HDD 5400 rpm Graphics Coprocessor Intel HD Graphics 620 Chipset Brand Intel Card Description Shared, Integrated Graphics Card Ram Size 1 GB Wireless Type 802.11b/g, 802.11bgn, 802.11b Number of USB 2.0 Ports 1 Number of USB 3.0 Ports 2',\n",
" 'Screen Size 11.6 inches Processor 2.1 GHz None RAM 4 GB LPDDR3 Hard Drive 32 GB SSD Graphics Coprocessor GX6250 Chipset Brand MediaTek Card Description Integrated Graphics Card Ram Size 0.01 GB Wireless Type 802.11ac Number of USB 3.0 Ports 1',\n",
" 'Screen Size 14 inches Max Screen Resolution 1366 x 768 Processor 2.4 GHz Core i3 Family RAM 4 GB DDR4 Hard Drive 128 GB flash_memory_solid_state Graphics Coprocessor Intel HD Graphics 620 Chipset Brand intel Card Description Integrated Wireless Type 802.11b/g, 802.11bgn, 802.11b',\n",
" 'Screen Size 17.3 inches Screen Resolution 1600x900 Max Screen Resolution 1600x900 Processor 1.6 GHz Intel Core i5 RAM 8 GB DDR4 Hard Drive 2 TB HDD Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11ac, Bluetooth, 802.11bgn Number of USB 2.0 Ports 1',\n",
" 'Screen Size 15.6 inches Screen Resolution 1366 x 768 Max Screen Resolution 1366 x 768 Processor 2.4 GHz Intel Core i3 RAM 4 GB Hard Drive 1 TB HDD Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand Intel Card Description Integrated Wireless Type 802.11ac',\n",
" 'Screen Size 14 inches Screen Resolution 1920x1080 Max Screen Resolution 1920x1080 Processor 2.2 GHz Intel Core i3 RAM 8 GB Hard Drive 256 GB flash_memory_solid_state Graphics Coprocessor Intel UHD Graphics 620 Chipset Brand intel Card Description Integrated Wireless Type 802.11b/g, 802.11ac, 802.11bgn, 802.11b']"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"l = []\n",
"for i in data['product_specification']:\n",
" l.append(i)\n",
"l"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"['Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 17.3',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 17.3',\n",
" 'Screen Size 14',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 14.1',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 11.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 13.5',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 11.6',\n",
" 'Screen Size 13.3',\n",
" 'Screen Size 14',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 11.6',\n",
" 'Screen Size 13.3',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 14',\n",
" 'Screen Size 14',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 14',\n",
" 'Screen Size 14',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 14',\n",
" 'Screen Size 14',\n",
" 'Screen Size 14',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 14',\n",
" 'Screen Size 14',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 11.6',\n",
" 'Screen Size 17',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 13.3',\n",
" 'Screen Size 11.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 13.3',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 11.6',\n",
" 'Screen Size 11.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 11.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 17.3',\n",
" 'Screen Size 13.3',\n",
" 'Screen Size 17.3',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 11.6',\n",
" 'Screen Size 11.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 14',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 11.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 11.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 11.6',\n",
" 'Screen Size 11.6',\n",
" 'Screen Size 13.3',\n",
" 'Screen Size 14',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 14',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 14',\n",
" 'Screen Size 14',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 11.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 12.5',\n",
" 'Screen Size 14',\n",
" 'Screen Size 11.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 156',\n",
" 'Screen Size 11.6',\n",
" 'Screen Size 14',\n",
" 'Screen Size 17.3',\n",
" 'Screen Size 15.6',\n",
" 'Screen Size 14']"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"screensize = []\n",
"\n",
"for words in l:\n",
" screensize.append(re.findall(r\"^Screen Size (?<![a-zA-Z:])[-+]?\\d*\\.?\\d+\", words))\n",
" \n",
"screen_size = []\n",
"for sublist in screensize:\n",
" for item in sublist:\n",
" screen_size.append(item)\n",
"screen_size"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"['Processor 1.6 GHz',\n",
" 'Processor 2.4 GHz',\n",
" 'Processor 2.1 GHz',\n",
" 'Processor 1.6 GHz',\n",
" 'Processor 4.5 GHz',\n",
" 'Processor 3.4 GHz',\n",
" 'Processor 1.6 GHz',\n",
" 'Processor 3.1 GHz',\n",
" 'Processor 2.2 GHz',\n",
" 'Processor 2.5 GHz',\n",
" 'Processor 3.9 GHz',\n",
" 'Processor 1.8 GHz',\n",
" 'Processor 2.2 GHz',\n",
" 'Processor 2.3 GHz',\n",
" 'Processor 3.9 GHz',\n",
" 'Processor 3.9 GHz',\n",
" 'Processor 2.7 GHz',\n",
" 'Processor 2.6 GHz',\n",
" 'Processor 1.6 GHz',\n",
" 'Processor 3.9 GHz',\n",
" 'Processor 2.5 GHz',\n",
" 'Processor 1.3 GHz',\n",
" 'Processor 4.5 GHz',\n",
" 'Processor 1.6 GHz',\n",
" 'Processor 2.3 GHz',\n",
" 'Processor 3.5 GHz',\n",
" 'Processor 4.1 GHz',\n",
" 'Processor 1.6 GHz',\n",
" 'Processor 1.8 GHz',\n",
" 'Processor 1.8 GHz',\n",
" 'Processor 2.6 GHz',\n",
" 'Processor 2.5 GHz',\n",
" 'Processor 3.4 GHz',\n",
" 'Processor 1.6 GHz',\n",
" 'Processor 1.8 GHz',\n",
" 'Processor 4.6 GHz',\n",
" 'Processor 4 GHz',\n",
" 'Processor 2.5 GHz',\n",
" 'Processor 2.48 GHz',\n",
" 'Processor 2.1 GHz',\n",
" 'Processor 1.4 GHz',\n",
" 'Processor 1.8 GHz',\n",
" 'Processor 2.2 GHz',\n",
" 'Processor 2.1 GHz',\n",
" 'Processor 1.9 GHz',\n",
" 'Processor 2 GHz',\n",
" 'Processor 1.6 GHz',\n",
" 'Processor 2.5 GHz',\n",
" 'Processor 2.2 GHz',\n",
" 'Processor 3.4 GHz',\n",
" 'Processor 2.6 GHz',\n",
" 'Processor 2.4 GHz',\n",
" 'Processor 3.5 GHz',\n",
" 'Processor 2.5 GHz',\n",
" 'Processor 1.6 GHz',\n",
" 'Processor 1.4 GHz',\n",
" 'Processor 2.2 GHz',\n",
" 'Processor 2.6 GHz',\n",
" 'Processor 1.1 GHz',\n",
" 'Processor 1.8 GHz',\n",
" 'Processor 4 GHz',\n",
" 'Processor 2.3 GHz',\n",
" 'Processor 2.1 GHz',\n",
" 'Processor 4.6 GHz',\n",
" 'Processor 4.6 GHz',\n",
" 'Processor 1.8 GHz',\n",
" 'Processor 4.6 GHz',\n",
" 'Processor 2.2 GHz',\n",
" 'Processor 2.3 GHz',\n",
" 'Processor 2.1 GHz',\n",
" 'Processor 1.8 GHz',\n",
" 'Processor 3.9 GHz',\n",
" 'Processor 1.6 GHz',\n",
" 'Processor 2.58 GHz',\n",
" 'Processor 1.6 GHz',\n",
" 'Processor 1.7 GHz',\n",
" 'Processor 2.7 GHz',\n",
" 'Processor 1.1 GHz',\n",
" 'Processor 2.48 GHz',\n",
" 'Processor 2.5 GHz',\n",
" 'Processor 3.1 GHz',\n",
" 'Processor 2.2 GHz',\n",
" 'Processor 1.1 GHz',\n",
" 'Processor 1.6 GHz',\n",
" 'Processor 2.6 GHz',\n",
" 'Processor 1.83 GHz',\n",
" 'Processor 3.9 GHz',\n",
" 'Processor 2.8 GHz',\n",
" 'Processor 3.1 GHz',\n",
" 'Processor 1.8 GHz',\n",
" 'Processor 3.4 GHz',\n",
" 'Processor 2.7 GHz',\n",
" 'Processor 1.8 GHz',\n",
" 'Processor 1.6 GHz',\n",
" 'Processor 3.9 GHz',\n",
" 'Processor 2.6 GHz',\n",
" 'Processor 2.3 GHz',\n",
" 'Processor 3.9 GHz',\n",
" 'Processor 2.7 GHz',\n",
" 'Processor 2.6 GHz',\n",
" 'Processor 2.48 GHz',\n",
" 'Processor 3 GHz',\n",
" 'Processor 2.5 GHz',\n",
" 'Processor 2.7 GHz',\n",
" 'Processor 2.7 GHz',\n",
" 'Processor 2.6 GHz',\n",
" 'Processor 2.3 GHz',\n",
" 'Processor 1.8 GHz',\n",
" 'Processor 2.5 GHz',\n",
" 'Processor 3 GHz',\n",
" 'Processor 2.6 GHz',\n",
" 'Processor 3.4 GHz',\n",
" 'Processor 2.6 GHz',\n",
" 'Processor 4 GHz',\n",
" 'Processor 2.6 GHz',\n",
" 'Processor 1.6 GHz',\n",
" 'Processor 2.6 GHz',\n",
" 'Processor 3.9 GHz',\n",
" 'Processor 1.1 GHz',\n",
" 'Processor 1.6 GHz',\n",
" 'Processor 2.6 GHz',\n",
" 'Processor 1.1 GHz',\n",
" 'Processor 2.2 GHz',\n",
" 'Processor 1.44 GHz',\n",
" 'Processor 2.7 GHz',\n",
" 'Processor 4.6 GHz',\n",
" 'Processor 3.9 GHz',\n",
" 'Processor 2.4 GHz',\n",
" 'Processor 3.1 GHz',\n",
" 'Processor 2.6 GHz',\n",
" 'Processor 2.5 GHz',\n",
" 'Processor 2.4 GHz',\n",
" 'Processor 1.6 GHz',\n",
" 'Processor 4.1 GHz',\n",
" 'Processor 2.6 GHz',\n",
" 'Processor 1.1 GHz',\n",
" 'Processor 2.6 GHz',\n",
" 'Processor 1.1 GHz',\n",
" 'Processor 3.9 GHz',\n",
" 'Processor 2.7 GHz',\n",
" 'Processor 2.7 GHz',\n",
" 'Processor 2 GHz',\n",
" 'Processor 1.1 GHz',\n",
" 'Processor 1.6 GHz',\n",
" 'Processor 2.7 GHz',\n",
" 'Processor 1.6 GHz',\n",
" 'Processor 2.5 GHz',\n",
" 'Processor 2.5 GHz',\n",
" 'Processor 2.6 GHz',\n",
" 'Processor 2.1 GHz',\n",
" 'Processor 2.2 GHz',\n",
" 'Processor 2.7 GHz',\n",
" 'Processor 2.7 GHz',\n",
" 'Processor 2.1 GHz',\n",
" 'Processor 2.4 GHz',\n",
" 'Processor 1.6 GHz',\n",
" 'Processor 2.4 GHz',\n",
" 'Processor 2.2 GHz']"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#processor-power\n",
"processors = []\n",
"\n",
"for words in l:\n",
" processors.append(re.findall(r\"Processor (?<![a-zA-Z:])[-+]?\\d*\\.?\\d+\\s\\w+\", words))\n",
" \n",
"processor = []\n",
"for sublist in processors:\n",
" for item in sublist:\n",
" processor.append(item)\n",
"\n",
"processor\n"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"['GHz Intel Core i5',\n",
" 'GHz Intel Core i3',\n",
" 'GHz Intel Core i3',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Intel Core i7',\n",
" 'GHz core_m',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Core i7',\n",
" 'GHz Intel Core i7',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Core i3',\n",
" 'GHz Intel Core i7',\n",
" 'GHz Intel Core i3',\n",
" 'GHz Intel Core i3',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Intel Core i3',\n",
" 'GHz Intel Core i3',\n",
" 'GHz Intel Celeron',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Core i5',\n",
" 'GHz i7',\n",
" 'GHz Intel Core i7',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Ryzen',\n",
" 'GHz Intel Core i7',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Intel Mobile CPU',\n",
" 'GHz Intel Core i7',\n",
" 'GHz Intel Celeron',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Core i3',\n",
" 'GHz Intel Celeron',\n",
" 'GHz Core i7',\n",
" 'GHz Core i7',\n",
" 'GHz Intel Core i7',\n",
" 'GHz AMD A Series',\n",
" 'GHz Intel Celeron',\n",
" 'GHz Intel Celeron',\n",
" 'GHz Core i5',\n",
" 'GHz Core i7',\n",
" 'GHz Core i3',\n",
" 'GHz AMD R Series',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Intel Core i5',\n",
" 'GHz AMD A4',\n",
" 'GHz core_m',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Intel Core i3',\n",
" 'GHz Ryzen',\n",
" 'GHz Celeron',\n",
" 'GHz Intel Celeron',\n",
" 'GHz Intel Celeron',\n",
" 'GHz AMD A4',\n",
" 'GHz AMD A Series',\n",
" 'GHz Intel Celeron',\n",
" 'GHz Intel Core i7',\n",
" 'GHz AMD Ryzen',\n",
" 'GHz Pentium Other',\n",
" 'GHz MediaTek_MT8127',\n",
" 'GHz Core i7',\n",
" 'GHz Intel Core i7',\n",
" 'GHz Core i7',\n",
" 'GHz Intel Core i7',\n",
" 'GHz Intel Core i3',\n",
" 'GHz Pentium',\n",
" 'GHz MediaTek_MT8127',\n",
" 'GHz Intel Core i7',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Core i5',\n",
" 'GHz Intel Celeron',\n",
" 'GHz Intel Celeron',\n",
" 'GHz Intel Core i3',\n",
" 'GHz Athlon',\n",
" 'GHz Pentium',\n",
" 'GHz Intel Celeron',\n",
" 'GHz Intel Core i5',\n",
" 'GHz AMD A Series',\n",
" 'GHz Intel Core i7',\n",
" 'GHz Pentium',\n",
" 'GHz Intel Celeron',\n",
" 'GHz Celeron',\n",
" 'GHz Intel Celeron',\n",
" 'GHz Intel Core i7',\n",
" 'GHz Intel Core i7',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Core i7',\n",
" 'GHz Core i5',\n",
" 'GHz Intel Core i3',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Core i5',\n",
" 'GHz Intel Core i7',\n",
" 'GHz Core i7',\n",
" 'GHz AMD R Series',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Pentium',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Celeron N3060',\n",
" 'GHz AMD A Series',\n",
" 'GHz AMD A Series',\n",
" 'GHz AMD A Series',\n",
" 'GHz Intel Core i5',\n",
" 'GHz AMD A6',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Intel Core i7',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Core i5',\n",
" 'GHz Intel Core i7',\n",
" 'GHz Intel Core i5',\n",
" 'GHz AMD A Series',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Intel Core i5',\n",
" 'GHz AMD A6',\n",
" 'GHz Intel Core i7',\n",
" 'GHz Intel Core',\n",
" 'GHz Intel Celeron',\n",
" 'GHz Celeron',\n",
" 'GHz Intel Celeron',\n",
" 'GHz AMD A4',\n",
" 'GHz Intel Atom',\n",
" 'GHz Atom x5',\n",
" 'GHz Intel Core i7',\n",
" 'GHz Core i3',\n",
" 'GHz Core i3',\n",
" 'GHz AMD A Series',\n",
" 'GHz AMD A6',\n",
" 'GHz Apple A6',\n",
" 'GHz Intel Core i3',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Intel Core i7',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Intel Celeron',\n",
" 'GHz Intel Celeron',\n",
" 'GHz Intel Celeron',\n",
" 'GHz Intel Core i3',\n",
" 'GHz AMD A Series',\n",
" 'GHz AMD A Series',\n",
" 'GHz Core i5',\n",
" 'GHz Intel Celeron',\n",
" 'GHz Intel Celeron',\n",
" 'GHz AMD A Series',\n",
" 'GHz Intel Celeron',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Intel Core i5',\n",
" 'GHz AMD A Series',\n",
" 'GHz MediaTek_MT8127',\n",
" 'GHz Intel Core i7',\n",
" 'GHz AMD A Series',\n",
" 'GHz Intel Core i3',\n",
" 'GHz None',\n",
" 'GHz Core i3',\n",
" 'GHz Intel Core i5',\n",
" 'GHz Intel Core i3',\n",
" 'GHz Intel Core i3']"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#processor-type\n",
"processortype = []\n",
"\n",
"for words in l:\n",
" processortype.append(re.findall(r\"GHz (?:[A-Za-z]+\\s){0,}[A-Za-z]+\\w+\", words))\n",
" \n",
"processor_type = []\n",
"\n",
"for sublist in processortype:\n",
" for item in sublist:\n",
" processor_type.append(item)\n",
" \n",
"processor_type"
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"['16 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '16 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '4 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '16 GB',\n",
" '12 GB',\n",
" '12 GB',\n",
" '8 GB',\n",
" '4 GB',\n",
" '8 GB',\n",
" '4 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '16 GB',\n",
" '12 GB',\n",
" '8 GB',\n",
" '4 GB',\n",
" '16 GB',\n",
" '12 GB',\n",
" '8 GB',\n",
" '16 GB',\n",
" '4 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '4 GB',\n",
" '16 GB',\n",
" '16 GB',\n",
" '8 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '16 GB',\n",
" '8 GB',\n",
" '12 GB',\n",
" '16 GB',\n",
" '4 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '4 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '16 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '8 GB',\n",
" '2 GB',\n",
" '8 GB',\n",
" '16 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '16 GB',\n",
" '8 GB',\n",
" '16 GB',\n",
" '16 GB',\n",
" '6 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '16 GB',\n",
" '8 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '8 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '8 GB',\n",
" '4 GB',\n",
" '8 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '16 GB',\n",
" '16 GB',\n",
" '8 GB',\n",
" '16 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '4 GB',\n",
" '16 GB',\n",
" '8 GB',\n",
" '16 GB',\n",
" '8 GB',\n",
" '4 GB',\n",
" '8 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '12 GB',\n",
" '8 GB',\n",
" '4 TB',\n",
" '16 GB',\n",
" '16 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '4 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '16 GB',\n",
" '2 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '16 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '8 GB',\n",
" '4 GB',\n",
" '8 GB',\n",
" '16 GB',\n",
" '16 GB',\n",
" '8 GB',\n",
" '2 GB',\n",
" '4 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '16 GB',\n",
" '4 GB',\n",
" '8 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '8 GB',\n",
" '4 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '16 GB',\n",
" '8 GB',\n",
" '8 GB',\n",
" '4 GB',\n",
" '4 GB',\n",
" '8 GB',\n",
" '4 GB',\n",
" '8 GB']"
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#RAM\n",
"rams = []\n",
"\n",
"for words in l:\n",
" rams.append(re.findall(r\"RAM (\\w+\\s\\w+){1,}\", words))\n",
" \n",
"ram = []\n",
"\n",
"for sublist in rams:\n",
" for item in sublist:\n",
" ram.append(item)\n",
" \n",
"ram"
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"['1 TB HDD',\n",
" '1 TB HDD',\n",
" '1 TB PCIE',\n",
" '1 TB HDD',\n",
" '512 GB 512GB',\n",
" '64 GB Embedded',\n",
" '1 TB HDD',\n",
" '1 TB na',\n",
" '1 TB flash_memory_solid_state',\n",
" '128 GB SSD',\n",
" '256 GB flash_memory_solid_state',\n",
" '512 GB SSD',\n",
" '1 TB mechanical_hard_drive',\n",
" '1 TB HDD',\n",
" '256 GB Flash',\n",
" '128 GB Flash',\n",
" '256 GB SSD',\n",
" '64 GB Hybrid',\n",
" '256 GB Flash',\n",
" '256 GB Hybrid',\n",
" '500 GB HDD',\n",
" 'Flash Memory Solid',\n",
" '256 GB Flash',\n",
" '256 GB SSD',\n",
" '256 GB SSD',\n",
" '128 GB Flash',\n",
" '256 GB Flash',\n",
" '1 TB mechanical_hard_drive',\n",
" '256 GB flash_memory_solid_state',\n",
" '256 GB Flash',\n",
" '64 GB Flash',\n",
" '2 TB mechanical_hard_drive',\n",
" '1 TB HDD',\n",
" '16 GB Embedded',\n",
" '512 GB Flash',\n",
" '512 GB Flash',\n",
" '1000 GB Hybrid',\n",
" '500 GB mechanical_hard_drive',\n",
" '32 GB emmc',\n",
" '16 GB flash_memory_solid_state',\n",
" '128 GB flash_memory_solid_state',\n",
" '256 GB SSD',\n",
" '128 GB flash_memory_solid_state',\n",
" 'Flash Memory Solid',\n",
" '256 GB SSD',\n",
" '512 GB HDD',\n",
" '128 GB Hybrid',\n",
" '1000 GB Mechanical',\n",
" '64 GB Embedded',\n",
" '64 GB Embedded',\n",
" '320 GB HDD',\n",
" '1 TB HDD',\n",
" '128 GB Flash',\n",
" '32 GB SSD',\n",
" '64 GB emmc',\n",
" '16 GB SSD',\n",
" '64 GB Embedded',\n",
" '512 GB SSD',\n",
" '32 GB emmc',\n",
" '1 TB SSD',\n",
" '1 TB Flash',\n",
" '128 GB flash_memory_solid_state',\n",
" 'Flash Memory Solid',\n",
" '512 GB Flash',\n",
" '1 TB Flash',\n",
" '512 GB Flash',\n",
" '512 GB SSD',\n",
" '1000 GB Mechanical',\n",
" '128 GB flash_memory_solid_state',\n",
" '64 GB Flash',\n",
" '512 GB Flash',\n",
" '256 GB Flash',\n",
" '256 GB flash_memory_solid_state',\n",
" '16 GB SSD',\n",
" '32 GB emmc',\n",
" '500 GB HDD',\n",
" '1000 GB Hybrid',\n",
" '64 GB emmc',\n",
" '16 GB flash_memory_solid_state',\n",
" '256 GB SSD',\n",
" '128 GB flash_memory_solid_state',\n",
" '256 GB Flash',\n",
" '64 GB Flash',\n",
" '16 GB emmc',\n",
" '32 GB SSD',\n",
" '128 GB SSD',\n",
" '512 GB Hybrid',\n",
" '512 GB Flash',\n",
" '256 GB flash_memory_solid_state',\n",
" 'Flash Memory Solid',\n",
" '256 GB SSD',\n",
" '1 TB HDD',\n",
" '256 GB Flash',\n",
" '1 TB Flash',\n",
" '1000 GB Hybrid',\n",
" '256 GB flash_memory_solid_state',\n",
" '512 GB PCIe',\n",
" '256 GB Flash',\n",
" '1 TB HDD',\n",
" '128 GB SSD',\n",
" '32 GB emmc',\n",
" '64 GB 64GB',\n",
" '500 GB HDD',\n",
" '128 GB flash_memory_solid_state',\n",
" '256 GB SSD',\n",
" '1 TB mechanical_hard_drive',\n",
" '1256 GB Hybrid',\n",
" '1 TB Flash',\n",
" '512 GB flash_memory_solid_state',\n",
" '256 GB SSD',\n",
" '1 TB Mechanical',\n",
" '1000 GB Hybrid',\n",
" '512 GB flash_memory_solid_state',\n",
" '1000 GB Mechanical',\n",
" '320 GB HDD',\n",
" '256 GB SSD',\n",
" '1 TB HDD',\n",
" '1000 GB Hybrid',\n",
" '32 GB emmc',\n",
" '16 GB eMMC',\n",
" '64 GB Embedded',\n",
" '32 GB emmc',\n",
" '32 GB Flash',\n",
" '64 GB Flash',\n",
" '32 GB Flash',\n",
" '512 GB Flash',\n",
" '128 GB 128GB',\n",
" '1 TB HDD',\n",
" '128 GB flash_memory_solid_state',\n",
" '1 TB mechanical_hard_drive',\n",
" '500 GB Flash',\n",
" '256 GB SSD',\n",
" '512 GB SSD',\n",
" '256 GB Flash',\n",
" '256 GB Flash',\n",
" '32 GB emmc',\n",
" '32 GB emmc',\n",
" '1 TB flash_memory_solid_state',\n",
" '128 GB Flash',\n",
" '500 GB flash_memory_solid_state',\n",
" '128 GB mechanical_hard_drive',\n",
" '500 GB mechanical_hard_drive',\n",
" '64 GB Flash',\n",
" '32 GB SSD',\n",
" '256 GB flash_memory_solid_state',\n",
" '32 GB SSD',\n",
" '256 GB Flash',\n",
" '128 GB SSD',\n",
" '500 GB mechanical_hard_drive',\n",
" '64 GB Flash',\n",
" '1000 GB Hybrid',\n",
" '1 TB HDD',\n",
" '1 TB HDD',\n",
" '32 GB SSD',\n",
" '128 GB flash_memory_solid_state',\n",
" '2 TB HDD',\n",
" '1 TB HDD',\n",
" '256 GB flash_memory_solid_state']"
]
},
"execution_count": 13,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#Storage\n",
"storages = []\n",
"\n",
"for words in l:\n",
" storages.append(re.findall(r\"Hard Drive (\\w+\\s\\w+\\s\\w+){1,}\", words))\n",
" \n",
"storage = []\n",
"\n",
"for sublist in storages:\n",
" for item in sublist:\n",
" storage.append(item)\n",
" \n",
"storage"
]
},
{
"cell_type": "code",
"execution_count": 14,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"['intel',\n",
" 'Intel',\n",
" 'intel',\n",
" 'Intel',\n",
" 'NVIDIA',\n",
" 'NVIDIA',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'nvidia',\n",
" 'Intel',\n",
" 'intel',\n",
" 'Intel',\n",
" 'intel',\n",
" 'intel',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'NVIDIA',\n",
" 'Intel',\n",
" 'intel',\n",
" 'Intel',\n",
" 'NVIDIA',\n",
" 'Intel',\n",
" 'NVIDIA',\n",
" 'AMD',\n",
" 'NVIDIA',\n",
" 'intel',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'intel',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'NVIDIA',\n",
" 'Intel',\n",
" 'nvidia',\n",
" 'amd',\n",
" 'intel',\n",
" 'intel',\n",
" 'intel',\n",
" 'NVIDIA',\n",
" 'Intel',\n",
" 'AMD',\n",
" 'intel',\n",
" 'intel',\n",
" 'intel',\n",
" 'Intel',\n",
" 'AMD',\n",
" 'NVIDIA',\n",
" 'intel',\n",
" 'Intel',\n",
" 'AMD',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'AMD',\n",
" 'AMD',\n",
" 'intel',\n",
" 'Intel',\n",
" 'NVIDIA',\n",
" 'intel',\n",
" 'PowerVR',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'nvidia',\n",
" 'Intel',\n",
" 'intel',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'intel',\n",
" 'Intel',\n",
" 'intel',\n",
" 'intel',\n",
" 'amd',\n",
" 'intel',\n",
" 'intel',\n",
" 'intel',\n",
" 'amd',\n",
" 'NVIDIA',\n",
" 'Intel',\n",
" 'intel',\n",
" 'intel',\n",
" 'Intel',\n",
" 'NVIDIA',\n",
" 'nvidia',\n",
" 'intel',\n",
" 'Intel',\n",
" 'intel',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'intel',\n",
" 'nvidia',\n",
" 'Intel',\n",
" 'intel',\n",
" 'intel',\n",
" 'Intel',\n",
" 'AMD',\n",
" 'AMD',\n",
" 'amd',\n",
" 'Intel',\n",
" 'amd',\n",
" 'nvidia',\n",
" 'Intel',\n",
" 'intel',\n",
" 'Intel',\n",
" 'NVIDIA',\n",
" 'Intel',\n",
" 'amd',\n",
" 'intel',\n",
" 'intel',\n",
" 'Intel',\n",
" 'amd',\n",
" 'NVIDIA',\n",
" 'Intel',\n",
" 'intel',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'AMD',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'amd',\n",
" 'amd',\n",
" 'amd',\n",
" 'Intel',\n",
" 'intel',\n",
" 'NVIDIA',\n",
" 'NVIDIA',\n",
" 'intel',\n",
" 'Intel',\n",
" 'intel',\n",
" 'Intel',\n",
" 'amd',\n",
" 'amd',\n",
" 'intel',\n",
" 'intel',\n",
" 'Intel',\n",
" 'amd',\n",
" 'Intel',\n",
" 'NVIDIA',\n",
" 'Intel',\n",
" 'amd',\n",
" 'Intel',\n",
" 'NVIDIA',\n",
" 'amd',\n",
" 'Intel',\n",
" 'MediaTek',\n",
" 'intel',\n",
" 'Intel',\n",
" 'Intel',\n",
" 'intel']"
]
},
"execution_count": 14,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#Graphics_Brand\n",
"chip_set = []\n",
"\n",
"for words in l:\n",
" chip_set.append(re.findall(r\"Chipset Brand (\\w+){0,}\", words))\n",
" \n",
"chipset = []\n",
"\n",
"for sublist in chip_set:\n",
" for item in sublist:\n",
" chipset.append(item)\n",
" \n",
"chipset"
]
},
{
"cell_type": "code",
"execution_count": 15,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"['Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Dedicated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Dedicated',\n",
" 'Dedicated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Dedicated',\n",
" 'Integrated',\n",
" 'integrated',\n",
" 'Integrated',\n",
" 'Dedicated',\n",
" 'Integrated',\n",
" 'Dedicated',\n",
" 'Integrated',\n",
" 'Dedicated',\n",
" 'Integrated',\n",
" 'dedicated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'integrated',\n",
" 'Integrated',\n",
" 'Dedicated',\n",
" 'Integrated',\n",
" 'Dedicated',\n",
" 'Dedicated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'dedicated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Dedicated',\n",
" 'integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'dedicated',\n",
" 'Integrated',\n",
" 'integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'integrated',\n",
" 'Dedicated',\n",
" 'Dedicated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'integrated',\n",
" 'Integrated',\n",
" 'Dedicated',\n",
" 'Dedicated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Shared',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Dedicated',\n",
" 'integrated',\n",
" 'dedicated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Dedicated',\n",
" 'Dedicated',\n",
" 'Integrated',\n",
" 'Dedicated',\n",
" 'Dedicated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Dedicated',\n",
" 'Dedicated',\n",
" 'Integrated',\n",
" 'Dedicated',\n",
" 'Dedicated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Dedicated',\n",
" 'Dedicated',\n",
" 'Dedicated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'integrated',\n",
" 'Dedicated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Dedicated',\n",
" 'Dedicated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Dedicated',\n",
" 'Dedicated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'integrated',\n",
" 'Dedicated',\n",
" 'Integrated',\n",
" 'Dedicated',\n",
" 'Integrated',\n",
" 'Dedicated',\n",
" 'Integrated',\n",
" 'Dedicated',\n",
" 'Dedicated',\n",
" 'Shared',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated',\n",
" 'Integrated']"
]
},
"execution_count": 15,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#Graphics_card\n",
"card_desc = []\n",
"\n",
"for words in l:\n",
" card_desc.append(re.findall(r\"Card Description (\\w+){0,}\", words))\n",
" \n",
"gc = []\n",
"\n",
"for sublist in card_desc:\n",
" for item in sublist:\n",
" gc.append(item)\n",
" \n",
"gc"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {},
"outputs": [],
"source": [
"data['Screen_size'] = screen_size\n",
"data['Screen_size'] = data['Screen_size'].map(lambda x: str(x)[12:])\n",
"\n",
"data['Processor_power'] = processor\n",
"data['Processor_power'] = data['Processor_power'].map(lambda x: str(x)[10:])\n",
"\n",
"data['Processor_type'] = processortype\n",
"data['Processor_type'] = data['Processor_type'].map(lambda x: str(x)[5:-2])\n",
"\n",
"data['RAM'] = ram\n",
"data['RAM'] = data['RAM'].map(lambda x: str(x)[:])\n",
"\n",
"data['Storage'] = storage\n",
"data['Storage'] = data['Storage'].map(lambda x: str(x)[:])\n",
"data['Storage_type'] = data['Storage'].map(lambda x: x.split()[2])\n",
"data['Storage'] = data['Storage'].map(lambda x: x.split()[0] + x.split()[1])\n",
"\n",
"data['Graphics_brand'] = chipset\n",
"data['Graphics_brand'] = data['Graphics_brand'].map(lambda x: str(x)[:])\n",
"\n",
"data['Graphics_type'] = gc\n",
"data['Graphics_type'] = data['Graphics_type'].map(lambda x: str(x)[:])\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>listing</th>\n",
" <th>listing-href</th>\n",
" <th>brand</th>\n",
" <th>review_count</th>\n",
" <th>sales_price</th>\n",
" <th>product_description</th>\n",
" <th>product_specification</th>\n",
" <th>Screen_size</th>\n",
" <th>Processor_power</th>\n",
" <th>Processor_type</th>\n",
" <th>RAM</th>\n",
" <th>Storage</th>\n",
" <th>Storage_type</th>\n",
" <th>Graphics_brand</th>\n",
" <th>Graphics_type</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>0</td>\n",
" <td>2019 Dell Inspiron 15.6\" Laptop Computer, 8th ...</td>\n",
" <td>https://www.amazon.com/Dell-Inspiron-Computer-...</td>\n",
" <td>Amazon Renewed</td>\n",
" <td>1 rating</td>\n",
" <td>$509.00</td>\n",
" <td>Product description Processor: 8th generation...</td>\n",
" <td>Screen Size 15.6 inches Screen Resolution 136...</td>\n",
" <td>15.6</td>\n",
" <td>1.6 GHz</td>\n",
" <td>Intel Core i5</td>\n",
" <td>16 GB</td>\n",
" <td>1TB</td>\n",
" <td>HDD</td>\n",
" <td>intel</td>\n",
" <td>Integrated</td>\n",
" </tr>\n",
" <tr>\n",
" <td>1</td>\n",
" <td>Newest HP 15.6-inch HD Touchscreen Display Lap...</td>\n",
" <td>https://www.amazon.com/HP-15-6-inch-Touchscree...</td>\n",
" <td>HP</td>\n",
" <td>27 ratings</td>\n",
" <td>$466.99</td>\n",
" <td>Product description Operating System: Windows...</td>\n",
" <td>Screen Size 15.6 inches Screen Resolution 136...</td>\n",
" <td>15.6</td>\n",
" <td>2.4 GHz</td>\n",
" <td>Intel Core i3</td>\n",
" <td>8 GB</td>\n",
" <td>1TB</td>\n",
" <td>HDD</td>\n",
" <td>Intel</td>\n",
" <td>Integrated</td>\n",
" </tr>\n",
" <tr>\n",
" <td>2</td>\n",
" <td>2019 Lenovo L340 17.3\" Laptop Computer, 8th Ge...</td>\n",
" <td>https://www.amazon.com/Lenovo-L340-Computer-i3...</td>\n",
" <td>Lenovo</td>\n",
" <td>10 ratings</td>\n",
" <td>$423.99</td>\n",
" <td>Product description Specifications: Processo...</td>\n",
" <td>Screen Size 17.3 inches Screen Resolution 140...</td>\n",
" <td>17.3</td>\n",
" <td>2.1 GHz</td>\n",
" <td>Intel Core i3</td>\n",
" <td>8 GB</td>\n",
" <td>1TB</td>\n",
" <td>PCIE</td>\n",
" <td>intel</td>\n",
" <td>Integrated</td>\n",
" </tr>\n",
" <tr>\n",
" <td>3</td>\n",
" <td>2018 Dell Inspiron 15 5000 15.6 inch Full HD T...</td>\n",
" <td>https://www.amazon.com/Dell-Inspiron-Keyboard-...</td>\n",
" <td>Dell</td>\n",
" <td>242 ratings</td>\n",
" <td>$534.98</td>\n",
" <td>Product description Capacity:8GB RAM | 1TB HDD...</td>\n",
" <td>Screen Size 15.6 inches Screen Resolution 192...</td>\n",
" <td>15.6</td>\n",
" <td>1.6 GHz</td>\n",
" <td>Intel Core i5</td>\n",
" <td>8 GB</td>\n",
" <td>1TB</td>\n",
" <td>HDD</td>\n",
" <td>Intel</td>\n",
" <td>Integrated</td>\n",
" </tr>\n",
" <tr>\n",
" <td>4</td>\n",
" <td>Dell G7 17 Gaming Laptop (Windows 10 Home, 9th...</td>\n",
" <td>https://www.amazon.com/Dell-Gaming-Windows-i7-...</td>\n",
" <td>Dell</td>\n",
" <td>27 ratings</td>\n",
" <td>$1,236.00</td>\n",
" <td>Product description Color:Gray 17-Inch Dell g...</td>\n",
" <td>Screen Size 17.3 inches Max Screen Resolution...</td>\n",
" <td>17.3</td>\n",
" <td>4.5 GHz</td>\n",
" <td>Intel Core i7</td>\n",
" <td>16 GB</td>\n",
" <td>512GB</td>\n",
" <td>512GB</td>\n",
" <td>NVIDIA</td>\n",
" <td>Dedicated</td>\n",
" </tr>\n",
" <tr>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>153</td>\n",
" <td>Lenovo Chromebook 2-in-1 Convertible Laptop, 1...</td>\n",
" <td>https://www.amazon.com/Lenovo-Chromebook-Conve...</td>\n",
" <td>Lenovo</td>\n",
" <td>46 ratings</td>\n",
" <td>$243.24</td>\n",
" <td>Product description Description: Lenovo Conve...</td>\n",
" <td>Screen Size 11.6 inches Processor 2.1 GHz Non...</td>\n",
" <td>11.6</td>\n",
" <td>2.1 GHz</td>\n",
" <td>None</td>\n",
" <td>4 GB</td>\n",
" <td>32GB</td>\n",
" <td>SSD</td>\n",
" <td>MediaTek</td>\n",
" <td>Integrated</td>\n",
" </tr>\n",
" <tr>\n",
" <td>154</td>\n",
" <td>2019 HP 14, 14\" HD Thin &amp; Light Flagship Lapto...</td>\n",
" <td>https://www.amazon.com/HP-14-Flagship-Computer...</td>\n",
" <td>HP</td>\n",
" <td>9 ratings</td>\n",
" <td>$302.00</td>\n",
" <td>Product description Microprocessor: Intel Cor...</td>\n",
" <td>Screen Size 14 inches Max Screen Resolution 1...</td>\n",
" <td>14</td>\n",
" <td>2.4 GHz</td>\n",
" <td>Core i3</td>\n",
" <td>4 GB</td>\n",
" <td>128GB</td>\n",
" <td>flash_memory_solid_state</td>\n",
" <td>intel</td>\n",
" <td>Integrated</td>\n",
" </tr>\n",
" <tr>\n",
" <td>155</td>\n",
" <td>HP 17.3\" HD+ SVA WLED-Backlit Notebook Laptop,...</td>\n",
" <td>https://www.amazon.com/HP-WLED-Backlit-Noteboo...</td>\n",
" <td>HP</td>\n",
" <td>44 ratings</td>\n",
" <td>$758.00</td>\n",
" <td>Product description 8th Generation Intel Core...</td>\n",
" <td>Screen Size 17.3 inches Screen Resolution 160...</td>\n",
" <td>17.3</td>\n",
" <td>1.6 GHz</td>\n",
" <td>Intel Core i5</td>\n",
" <td>8 GB</td>\n",
" <td>2TB</td>\n",
" <td>HDD</td>\n",
" <td>Intel</td>\n",
" <td>Integrated</td>\n",
" </tr>\n",
" <tr>\n",
" <td>156</td>\n",
" <td>HP 2019 Newest 15 15.6 Inch HD Laptop (Intel D...</td>\n",
" <td>https://www.amazon.com/HP-i3-7100U-Graphics-Bl...</td>\n",
" <td>HP</td>\n",
" <td>3 ratings</td>\n",
" <td>$299.00</td>\n",
" <td>Product description NexiPC sells computers wi...</td>\n",
" <td>Screen Size 15.6 inches Screen Resolution 136...</td>\n",
" <td>15.6</td>\n",
" <td>2.4 GHz</td>\n",
" <td>Intel Core i3</td>\n",
" <td>4 GB</td>\n",
" <td>1TB</td>\n",
" <td>HDD</td>\n",
" <td>Intel</td>\n",
" <td>Integrated</td>\n",
" </tr>\n",
" <tr>\n",
" <td>157</td>\n",
" <td>2019 HP Laptop Computer, 14\" FHD IPS BrightVie...</td>\n",
" <td>https://www.amazon.com/gp/slredirect/picassoRe...</td>\n",
" <td>HP</td>\n",
" <td>2 ratings</td>\n",
" <td>$522.00</td>\n",
" <td>Product description Processor &amp; Memory:Intel ...</td>\n",
" <td>Screen Size 14 inches Screen Resolution 1920x...</td>\n",
" <td>14</td>\n",
" <td>2.2 GHz</td>\n",
" <td>Intel Core i3</td>\n",
" <td>8 GB</td>\n",
" <td>256GB</td>\n",
" <td>flash_memory_solid_state</td>\n",
" <td>intel</td>\n",
" <td>Integrated</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>158 rows × 15 columns</p>\n",
"</div>"
],
"text/plain": [
" listing \\\n",
"0 2019 Dell Inspiron 15.6\" Laptop Computer, 8th ... \n",
"1 Newest HP 15.6-inch HD Touchscreen Display Lap... \n",
"2 2019 Lenovo L340 17.3\" Laptop Computer, 8th Ge... \n",
"3 2018 Dell Inspiron 15 5000 15.6 inch Full HD T... \n",
"4 Dell G7 17 Gaming Laptop (Windows 10 Home, 9th... \n",
".. ... \n",
"153 Lenovo Chromebook 2-in-1 Convertible Laptop, 1... \n",
"154 2019 HP 14, 14\" HD Thin & Light Flagship Lapto... \n",
"155 HP 17.3\" HD+ SVA WLED-Backlit Notebook Laptop,... \n",
"156 HP 2019 Newest 15 15.6 Inch HD Laptop (Intel D... \n",
"157 2019 HP Laptop Computer, 14\" FHD IPS BrightVie... \n",
"\n",
" listing-href brand \\\n",
"0 https://www.amazon.com/Dell-Inspiron-Computer-... Amazon Renewed \n",
"1 https://www.amazon.com/HP-15-6-inch-Touchscree... HP \n",
"2 https://www.amazon.com/Lenovo-L340-Computer-i3... Lenovo \n",
"3 https://www.amazon.com/Dell-Inspiron-Keyboard-... Dell \n",
"4 https://www.amazon.com/Dell-Gaming-Windows-i7-... Dell \n",
".. ... ... \n",
"153 https://www.amazon.com/Lenovo-Chromebook-Conve... Lenovo \n",
"154 https://www.amazon.com/HP-14-Flagship-Computer... HP \n",
"155 https://www.amazon.com/HP-WLED-Backlit-Noteboo... HP \n",
"156 https://www.amazon.com/HP-i3-7100U-Graphics-Bl... HP \n",
"157 https://www.amazon.com/gp/slredirect/picassoRe... HP \n",
"\n",
" review_count sales_price \\\n",
"0 1 rating $509.00 \n",
"1 27 ratings $466.99 \n",
"2 10 ratings $423.99 \n",
"3 242 ratings $534.98 \n",
"4 27 ratings $1,236.00 \n",
".. ... ... \n",
"153 46 ratings $243.24 \n",
"154 9 ratings $302.00 \n",
"155 44 ratings $758.00 \n",
"156 3 ratings $299.00 \n",
"157 2 ratings $522.00 \n",
"\n",
" product_description \\\n",
"0 Product description Processor: 8th generation... \n",
"1 Product description Operating System: Windows... \n",
"2 Product description Specifications: Processo... \n",
"3 Product description Capacity:8GB RAM | 1TB HDD... \n",
"4 Product description Color:Gray 17-Inch Dell g... \n",
".. ... \n",
"153 Product description Description: Lenovo Conve... \n",
"154 Product description Microprocessor: Intel Cor... \n",
"155 Product description 8th Generation Intel Core... \n",
"156 Product description NexiPC sells computers wi... \n",
"157 Product description Processor & Memory:Intel ... \n",
"\n",
" product_specification Screen_size \\\n",
"0 Screen Size 15.6 inches Screen Resolution 136... 15.6 \n",
"1 Screen Size 15.6 inches Screen Resolution 136... 15.6 \n",
"2 Screen Size 17.3 inches Screen Resolution 140... 17.3 \n",
"3 Screen Size 15.6 inches Screen Resolution 192... 15.6 \n",
"4 Screen Size 17.3 inches Max Screen Resolution... 17.3 \n",
".. ... ... \n",
"153 Screen Size 11.6 inches Processor 2.1 GHz Non... 11.6 \n",
"154 Screen Size 14 inches Max Screen Resolution 1... 14 \n",
"155 Screen Size 17.3 inches Screen Resolution 160... 17.3 \n",
"156 Screen Size 15.6 inches Screen Resolution 136... 15.6 \n",
"157 Screen Size 14 inches Screen Resolution 1920x... 14 \n",
"\n",
" Processor_power Processor_type RAM Storage Storage_type \\\n",
"0 1.6 GHz Intel Core i5 16 GB 1TB HDD \n",
"1 2.4 GHz Intel Core i3 8 GB 1TB HDD \n",
"2 2.1 GHz Intel Core i3 8 GB 1TB PCIE \n",
"3 1.6 GHz Intel Core i5 8 GB 1TB HDD \n",
"4 4.5 GHz Intel Core i7 16 GB 512GB 512GB \n",
".. ... ... ... ... ... \n",
"153 2.1 GHz None 4 GB 32GB SSD \n",
"154 2.4 GHz Core i3 4 GB 128GB flash_memory_solid_state \n",
"155 1.6 GHz Intel Core i5 8 GB 2TB HDD \n",
"156 2.4 GHz Intel Core i3 4 GB 1TB HDD \n",
"157 2.2 GHz Intel Core i3 8 GB 256GB flash_memory_solid_state \n",
"\n",
" Graphics_brand Graphics_type \n",
"0 intel Integrated \n",
"1 Intel Integrated \n",
"2 intel Integrated \n",
"3 Intel Integrated \n",
"4 NVIDIA Dedicated \n",
".. ... ... \n",
"153 MediaTek Integrated \n",
"154 intel Integrated \n",
"155 Intel Integrated \n",
"156 Intel Integrated \n",
"157 intel Integrated \n",
"\n",
"[158 rows x 15 columns]"
]
},
"execution_count": 17,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data"
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {},
"outputs": [],
"source": [
"df2 = data.to_csv(\"amazon_laptops.csv\")"
]
},
{
"cell_type": "code",
"execution_count": 19,
"metadata": {},
"outputs": [],
"source": [
"import seaborn as sb"
]
},
{
"cell_type": "code",
"execution_count": 20,
"metadata": {},
"outputs": [
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAWAAAAFgCAYAAACFYaNMAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjEsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy8QZhcZAAAgAElEQVR4nO3df3Rcd33m8fcjjcdRZNOosmxIRWqgwWk3zebHFMoGaEqAZlNO2rTQwOIaSrHrUPrz8KukS7rtsi1LgP5IcbCTNPUmuEAgbUkhQCkQypKUcXASB2xYIICSYCmKAFuWNR7NZ/+YK2WsjGSNPaPvjPS8zvHxzJ3vvffx9dWjO3fuzCgiMDOzxdeVOoCZ2XLlAjYzS8QFbGaWiAvYzCwRF7CZWSK51AGa6ZJLLok77rgjdQwzs9lUb+KSOgJ+9NFHU0cwM1uwJVXAZmadxAVsZpaIC9jMLBEXsJlZIi5gM7NEXMBmZom4gM3MEnEBm5kl4gI2M0vEBWxmlsiiFbCkGyUNS9pbM+1PJD0kaU/259Kax86R9EVJD0i6X9Ipi5W1nVUqwcjBSR4aO8zIwUkqFX+jiVmnWswP47kJuBbYOWv6eyLimtoJknLAzcCvR8S9kvqBo4uSso1VKsH+AwfZvLPI0NgEg3097NhUYMO61XR11f2sDzNrY4t2BBwRdwKPLXD4i4H7IuLebN7RiJhqWbgOMTpemilfgKGxCTbvLDI6XkqczMxORDucA369pPuyUxR92bRnAiHpE5LukfSmuWaWtEVSUVJxZGRkcRInUipPzZTvtKGxCUrlZf+7yawjpS7gbcAzgHOBR4B3ZdNzwHOBV2Z/Xy7p4noLiIjtEVGIiMLAwMAiRE4nn+tmsK/nmGmDfT3kc92JEpnZyUhawBFxICKmIqIC7ACelT00BHwuIh6NiMPAx4DzU+VsF/29eXZsKsyU8PQ54P7efOJkZnYikn4jhqSnRMQj2d3LgekrJD4BvEnSqUAJ+DngPQkitpWuLrFh3Wpue92FlMpT5HPd9Pfm/QKcWYdatAKWtAu4CFgjaQi4GrhI0rlAAA8CvwUQEWOS3g18KXvsYxHxL4uVtZ11dYmB1StTxzCzJlDE0rmOtFAoRLFYTB3DzGy2pf+dcGZmncQFbGaWiAvYzCwRF7CZWSIuYDOzRFzAZmaJuIDNzBJxAZuZJeICNjNLxAVsZpaIC9jMLBEXsJlZIi5gM7NEXMBmZom4gM3MEnEBm5kl4gI2M0vEBWxmlogL2MwsERewmVkiLmAzs0RaWsCSbpQ0LGlvzbR3Ston6T5Jt0k6bY55H5R0v6Q9kvxVx2a25LT6CPgm4JJZ0z4FnB0R5wBfA/5onvl/PiLOjYhCi/J1nEolGDk4yUNjhxk5OEmlEqkjmdkJyrVy4RFxp6T1s6Z9subuXcBLW5lhKalUgv0HDrJ5Z5GhsQkG+3rYsanAhnWr6epS6nhm1qDU54BfA3x8jscC+KSk3ZK2LGKmtjU6XpopX4ChsQk27ywyOl5KnMzMTkRLj4DnI+kqoAzcMseQCyPiYUlrgU9J2hcRd9ZZzhZgC8AZZ5zRsrztoFSeminfaUNjE5TKU4kSmdnJSHIELOlVwEuAV0ZE3ZOYEfFw9vcwcBvwrDnGbY+IQkQUBgYGWhW5LeRz3Qz29RwzbbCvh3yuO1EiMzsZi17Aki4B3gxcFhGH5xjTK2n19G3gxcDeemOXk/7ePDs2FWZKePoccH9vPnEyMzsRLT0FIWkXcBGwRtIQcDXVqx5WUj2tAHBXRGyVdDpwfURcCqwDbssezwHvj4g7Wpm1E3R1iQ3rVnPb6y6kVJ4in+umvzfvF+DMOpTmOAPQkQqFQhSLvmTYzNpO3aOk1FdBmJktWy5gM7NEXMBmZom4gM3MEnEBm5kl4gI2M0vEBWxmlogL2MwsERewmVkiLmAzs0RcwGZmibiAzcwScQGbmSXiAjYzS8QFbGaWiAvYzCwRF7CZWSIuYDOzRFzAZmaJuIDNzBJxAZuZJeICNjNLpC0KWNKNkoYl7a2Z9gFJe7I/D0rakzKjmVmz5VIHyNwEXAvsnJ4QEVdM35b0LuAHzV5ppRKMjpcolafI57rp783T1aVmr8bMrK62KOCIuFPS+nqPSRLwa8ALmrnOSiXYf+Agm3cWGRqbYLCvhx2bCmxYt9olbGaLoi1OQRzH84ADEfH1Zi50dLw0U74AQ2MTbN5ZZHS81MzVmJnNqRMK+BXArrkelLRFUlFScWRkZMELLZWnZsp32tDYBKXy1AkHNTNrRFsXsKQc8CvAB+YaExHbI6IQEYWBgYEFLzuf62awr+eYaYN9PeRz3Sca18ysIW1dwMALgX0RMdTsBff35tmxqTBTwtPngPt7881elZlZXW3xIpykXcBFwBpJQ8DVEXED8HLmOf1wMrq6xIZ1q7ntdRf6KggzS6ItCjgiXjHH9Fe3cr1dXWJg9cpWrsLMbE7tfgrCzGzJcgGbmSXiAjYzS8QFbGaWiAvYzCwRF7CZWSIuYDOzRFzAZmaJuIDNzBJxAZuZJeICNjNLxAVsZpaIC9jMLBEXsJlZIi5gM7NEXMBmZom4gM3MEnEBm5kl4gI2M0vEBWxmlogL2MwsERewmVkiLS1gSTdKGpa0t2ban0m6T9IeSZ+UdHqd+X5c0u5szAOStrYyp5lZCoqI1i1cej5wCNgZEWdn054UET/Mbv8u8FMRsXXWfPks26SkVcBe4L9ExMPzra9QKESxWFxwvnK5wvChSY5OVVjR3cXaVSvJ5dr7SUGlEoyOlyiVp8jnuunvzdPVpdSx5nT06BTDhyYpV4Jcl1i7aiUrVnSnjmW22Or+kOZaucaIuFPS+lnTflhztxd4wm+AiCjV3F1JC47Uy+UK+w4cZOvNuxkam2Cwr4frNl7AWetWt20JVyrB/gMH2byzOJN5x6YCG9atbssSPnp0in3Dh7iyZhtv23gBZ61d5RI2I9E5YElvl/Rd4JXA2+YY81RJ9wHfBd5xvKPfRg0fmpwpX4ChsQm23ryb4UOTzVxNU42Ol2bKF6qZN+8sMjpeOs6caQwfmpwpX6jmvbLNt7HZYkpSwBFxVUQ8FbgFeP0cY74bEecAPwG8StK6euMkbZFUlFQcGRlZcIajU5WZYpg2NDZBeaqy4GUstlJ5qm7mUnkqUaL5lStRfxtXWnfay6yTpH6u/X7gV+cbkB35PgA8b47Ht0dEISIKAwMDC17xiu4uBvt6jpk22NdDrjv1JplbPtddN3M+155P53Ndqr+N2/B0iVkKi942ks6suXsZsK/OmEFJPdntPuBCYH8zc6xdtZLrNl4wUxDT54DXrlrZzNU0VX9vnh2bCsdk3rGpQH9vPnGy+tauWsm2Wdt4W5tvY7PF1OqrIHYBFwFrgAPA1cClwAagAnwb2BoRD0kqZLdfK+lFwLuovkAn4NqI2H689Z3oVRDlqQo5XwXREr4KwgyY4yqIlhbwYmu0gM3MFkndAm7vwz0zsyXMBWxmlogL2MwsERewmVkiLmAzs0RcwGZmibiAzcwScQGbmSXiAjYzS8QFbGaWiAvYzCwRF7CZWSIuYDOzRFzAZmaJNFTA2dfFvzC73SNpdWtimZktfQsuYEmbgVuB92WTBoF/bEUoM7PloJEj4N+m+tVAPwSIiK8Da1sRysxsOWikgCcjYub7zyXlqH5lkJmZnYBGCvhzkt4K9GTf2fYh4KOtiWVmtvQ1UsBvAUaA+4HfAj4WEVe1JJWZ2TKQa2DsK4F/iIgd0xMkvSQibm9+LDOzpa+RI+C/AT4v6Sdrpv1pk/OYmS0bjRTwt4DXALdKelk2re5XLU+TdKOkYUl7a6b9maT7JO2R9ElJp88x71Q2Zo+kf24gp5lZR2ikgCMi7gF+Dtgi6Rqg+zjz3ARcMmvaOyPinIg4F7gdeNsc805ExLnZn8sayLmkVSrByMFJHho7zMjBSSoVX4hi1qkaKeBHACLiUeAXqF6CdvZ8M0TEncBjs6b9sOZuL76UbcEqlWD/gYNc/t4vcOE7PsPl7/0C+w8cdAmbdagFF3BE/GLN7UpEvDEiTuizJCS9XdJ3qb6wN9cR8CmSipLukvTLJ7KepWZ0vMTmnUWGxiYAGBqbYPPOIqPjpePMaWbt6LhXQUj6y4j4fUkfpc7R6omcHsguX7tK0h8BrweurjPsjIh4WNLTgX+TdH9EfKNOvi3AFoAzzjij0SgdpVSeminfaUNjE5TKU4kSmdnJWMhlaP8n+/uaFqz//cC/UKeAI+Lh7O9vSvoscB7whAKOiO3AdoBCobCkn4vnc90M9vUcU8KDfT3kc8c7FW9m7ei4pxAiYnf29+em/wD3AWPZ7YZIOrPm7mXAvjpj+iStzG6vofoZFF9pdF1LTX9vnh2bCgz29QDV8t2xqUB/bz5xMjM7EQt+I0Z2FHpZNs8eYETS5yLiD+eZZxdwEbBG0hDVI91LJW0AKsC3ga3Z2AKwNSJeC/wk8D5JFaq/JP4iIpZ9AXd1iQ3rVnPb6y6kVJ4in+umvzdPV9e8VwOaWZtSxMKetUv6ckScJ+m1wFMj4mpJ90XEOa2NuHCFQiGKxWLqGGZms9U9SmrkKoacpKcAv0b1+l0zMzsJjRTwnwKfAP5fRHwpuzrh662JZWa29DVyHfCHsnewvS67/82I+NXpx7NLyszMbIGa+aWcLzv+EDMzm9bMAvZL8WZmDWhmAS/pN0GYmTWbj4DNzBJpZgF/qInLMjNb8hp5J9wAsBlYXztfRLwm+/t/NTucmdlS1sh3wv0T8HngXwF//JaZ2UlqpIBPjYg3tyyJmdky08g54NslXdqyJGZmy0wjBfx7VEv4iKQfSjoo6YfHncvMzOpa8CmIiFjdyiBmZsvNgo+AVbVR0n/P7j9V0rNaF83MbGlr5BTEe4HnAP8tu38I+NumJzIzWyYauQri2RFxvqQvA0TEmCR/F46Z2Qlq5Aj4qKRuss98yN6YUWlJKjOzZaCRAv5r4DZgnaS3A/8O+N1vZmYnqJGrIG6RtBu4mOoH7/xyRHy1ZcnMzJa4Rj+MZw1wOCKuBR6V9LQWZDIzWxYauQztauDNwPRXD60Abm5FKDOz5aCRI+DLgcuAcYCIeBiY980Zkm6UNCxpb820l0l6QFJFUmGeeU+TdKukfZK+Kuk5DWQ1M2t7jRRwKSKCx6+C6F3APDcBl8yathf4FeDO48z7V8AdEXEW8J8Bn2/uQEeOlHlo7DDfHh3nobHDHDlSTh1pyalUgpGDkzw0dpiRg5NUKv5ymk7RyHXAH5T0PuA0SZuB1wA75pshIu6UtH7WtK8CSHN/gYakJwHPB16dzVMCSg1ktTZw5EiZr4+Oc+XNuxkam2Cwr4dtGy/gzP5eTjmlkV3P5lKpBPsPHGTzzuLMNt6xqcCGdavp6vKX1LS7Rr6W/hrgVuDDwAbgbRHxNy3K9XRgBPg7SV+WdP0Cj7itjYxOlGbKF2BobIIrb97N6IR/lzbL6Hhppnyhuo037ywyOu5t3AkWVMCSuiX9a0R8KiLeGBFviIhPtTBXDjgf2BYR51E97/yWObJtkVSUVBwZGWlhJGtUuRIzxTBtaGyCsp8iN02pPFV3G5fK/s6ETrCgAo6IKeCwpB9pcZ5pQ8BQRNyd3b+VaiHXy7Y9IgoRURgYGFikeLYQuS4x2NdzzLTBvh5yfmrcNPlcd91tnM91J0pkjWjkRbgjwP2SbpD019N/WhEqIr4HfFfShmzSxcBXWrEua53+njzbNl4wUxDT54D7e/wRIs3S35tnx6bCMdt4x6YC/b3exp1A1QsbFjBQelW96RHx9/PMswu4iOobOA4AVwOPAX8DDADfB/ZExC9IOh24PiIuzeY9F7geyAPfBH4jIsbmy1goFKJYLC7o32OL48iRMqMTJcqVINcl+nvyfgGuySqVYHS8RKk8RT7XTX9v3i/AtZ+6/yGNFHAvcCQ7HUH2wTwrI+Jw0yKeJBewmbWpugXcyCmITwO1J5t6qH5DspmZnYBGCviUiDg0fSe7fWrzI5mZLQ+NFPC4pJkrEbK3EU/MM97MzObRyKshvw98SNLDVN+OfDpwRUtSmZktA8c9Apb0M5KeHBFfAs4CPgCUgTuAb7U4n5nZkrWQUxDv4/HPYXgO8FaqX8Y5BmxvUS4zsyVvIacguiPisez2FcD2iPgw8GFJe1oXzcxsaVvIEXC3pOmivhj4t5rHfEW9mdkJWkiB7gI+J+lRqlc9fB5A0k8AP2hhNjOzJe24BRwRb5f0aeApwCfj8bfOdQG/08pwZmZL2YJOIUTEXXWmfa35cczMlo9GvxXZzMyaxAVsZpaIC9jMLBEXsJlZIi5gM7NEXMBmZom4gM3MEnEBm5kl4gI2M0vEBWxmlogL2MwskZYWsKQbJQ1L2lvnsTdICklr5pj3Dknfl3R7KzOamaXS6iPgm4BLZk+U9FTgRcB35pn3ncCvtyZW56pUgpGDkzw0dpiRg5NUKnH8mcysLbW0gCPiTuCxOg+9B3gT1S/3nGveTwMHWxStI1Uqwf4DB7n8vV/gwnd8hsvf+wX2HzjoEjbrUIt+DljSZcBDEXHvYq+7042Ol9i8s8jQ2AQAQ2MTbN5ZZHS8dJw5zawdLepXCkk6FbgKeHETl7kF2AJwxhlnNGuxbalUnpop32lDYxOUylOJEpnZyVjsI+BnAE8D7pX0IDAI3CPpySe6wIjYHhGFiCgMDAw0KWZ7yue6GezrOWbaYF8P+Vx3okRmdjIWtYAj4v6IWBsR6yNiPTAEnB8R31vMHJ2qvzfPjk2FmRIe7Othx6YC/b35xMnM7ES09BSEpF3ARcAaSUPA1RFxwxxjC8DWiHhtdv/zwFnAqmze34yIT7Qyb7vr6hIb1q3mttddSKk8RT7XTX9vnq4upY5mZidAj3/HZucrFApRLBZTxzAzm63uUZLfCWdmlogL2MwsERewmVkiLmAzs0RcwGZmibiAzcwScQGbmSXiAjYzS8QFbGaWiAvYzCwRF7CZWSIuYDOzRFzAZmaJuIDNzBJxAZuZJeICNjNLxAVsZpaIC9jMLBEXsJlZIi5gM7NEXMBmZom4gM3MEmmLApZ0o6RhSXvrPPYGSSFpTYpsZmatkksdIHMTcC2ws3aipKcCLwK+04qVlkplRsZLlCtBrksM9ObJ59tlk9R35EiZ0YnHM/f35DnllPbN3Gl5ASqVYHS8RKk8RT7XTX9vnq4upY41p3K5wvChSY5OVVjR3cXaVSvJ5dri2MqOoy1+EiLiTknr6zz0HuBNwD81e52lUpn9I+NcefNuhsYmGOzrYdvGC9gw0Nu2JXzkSJmvjz4x85n9vW1Zap2WF6rlu//AQTbvLM5k3rGpwIZ1q9uyhMvlCvsOHGRrzTa+buMFnLVutUu4A7Tt/5Cky4CHIuLeVix/ZLw0UwwAQ2MTXHnzbkbGS61YXVOMTtTPPDrRnpk7LS/A6HhppnyhmnnzziKjbbpfDB+anClfqObdevNuhg9NJk5mC9GWhyGSTgWuAl68gLFbgC0AZ5xxxoLXUa7EzE47bWhsgnIlGsq6mDotc6flBSiVp+pmLpWnEiWa39GpSv1tPFVJlMga0a5HwM8AngbcK+lBYBC4R9KTZw+MiO0RUYiIwsDAwIJXkOsSg309x0wb7Osh14ZPM6d1WuZOywuQz3XXzZzPdSdKNL8V3V31t3F3u/5oW622/F+KiPsjYm1ErI+I9cAQcH5EfK9Z6xjozbNt4wUzO+/0+cmB3nyzVtF0/T31M/f3tGfmTssL0N+bZ8emwjGZd2wq0N+m+8XaVSu5btY2vm7jBaxdtTJxMlsIRaR/OihpF3ARsAY4AFwdETfUPP4gUIiIR+dbTqFQiGKxuOD1+iqI1uu0vNC5V0GUpyrkfBVEu6q7A7VFATdLowVsZrZI6hawf02amSXiAjYzS8QFbGaWiAvYzCwRF7CZWSIuYDOzRFzAZmaJuIDNzBJxAZuZJeICNjNLxAVsZpaIC9jMLBEXsJlZIi5gM7NEXMBmZom4gM3MEnEBm5kl4gI2M0vEBWxmlogL2MwsERewmVkiLmAzs0RaWsCSbpQ0LGlvzbQPSNqT/XlQ0p46850i6T8k3SvpAUn/o5U5zcxSyLV4+TcB1wI7pydExBXTtyW9C/hBnfkmgRdExCFJK4B/l/TxiLirmeGOHp1i+NAk5UqQ6xJrV61kxYruZq6i6crlCsOHJjk6VWFFdxdrV60kl/MTGbNO1NICjog7Ja2v95gkAb8GvKDOfAEcyu6uyP5EM7MdPTrFvuFDXHnzbobGJhjs62Hbxgs4a+2qti3hcrnCvgMH2VqT+bqNF3DWutUuYbMOlPKn9nnAgYj4er0HJXVnpyeGgU9FxN3NXPnwocmZ8gUYGpvgypt3M3xospmraarhQ5Mz5QvVzFvbPLOZzS1lAb8C2DXXgxExFRHnAoPAsySdXW+cpC2SipKKIyMjC155uRIzRTZtaGyCcqWpB9pNdXSqUj/zVCVRIjM7GUkKWFIO+BXgA8cbGxHfBz4LXDLH49sjohARhYGBgQVnyHWJwb6eY6YN9vWQ69KCl7HYVnR31c/c7dMPZp0o1U/uC4F9ETFU70FJA5JOy273TI9vZoC1q1aybeMFM4U2fQ547aqVzVxNU61dtZLrZmW+rs0zm9ncVH29q0ULl3YBFwFrgAPA1RFxg6SbgLsi4rqasacD10fEpZLOAf4e6Kb6S+KDEfGnx1tfoVCIYrG44HydfBVEeapCzldBmHWKuk+tW1rAi63RAjYzWyR1C9iHTmZmibiAzcwScQGbmSXiAjYzS8QFbGaWiAvYzCwRF7CZWSIuYDOzRFzAZmaJuIDNzBJxAZuZJeICNjNLxAVsZpaIC9jMLBEXsJlZIi5gM7NEXMBmZom4gM3MEnEBm5kl4gI2M0vEBWxmlogL2MwskVwrFy7pRuAlwHBEnJ1N+xNgMzCSDXtrRHyszrynAdcDZwMBvCYivtjMfEeOlBmdKFGuBLku0d+T55RTWrpJTlqnZe60vACTk2UePfx45jWn5lm5sr0zd5JKJRgdL1EqT5HPddPfm6erq+63treNVmVu9V51E3AtsHPW9PdExDXHmfevgDsi4qWS8sCpzQx25EiZr4+Oc+XNuxkam2Cwr4dtGy/gzP7eti2ITsvcaXmhWr5fe/SJmZ+5ptcl3ASVSrD/wEE27yzObN8dmwpsWLe6bUu4lZlbegoiIu4EHmt0PklPAp4P3JAtpxQR329mttGJ0swPGcDQ2ARX3ryb0YlSM1fTVJ2WudPyAjx6uH7mRw+3b+ZOMjpemikyqG7fzTuLjI637/ZtZeZU54BfL+k+STdK6qvz+NOpnqL4O0lflnS9pN56C5K0RVJRUnFkZKTekLrKlZjZoNOGxiYoV6KBf8bi6rTMnZYXOjNzJymVp+pu31J5KlGi42tl5hQFvA14BnAu8AjwrjpjcsD5wLaIOA8YB95Sb2ERsT0iChFRGBgYWHCIXJcY7Os5ZtpgXw+5Nn0aBJ2XudPyQmdm7iT5XHfd7ZvPdSdKdHytzLzoBRwRByJiKiIqwA7gWXWGDQFDEXF3dv9WqoXcNP09ebZtvGBmw06f6+vvyTdzNU3VaZk7LS/AmlPrZ15zavtm7iT9vXl2bCocs313bCrQ39u+27eVmRXR2qdWktYDt9dcBfGUiHgku/0HwLMj4uV15vs88NqI2J9dOdEbEW+cb12FQiGKxeKCs3XiK/SdlrnT8oKvgmi1ZXoVRN3BLS1gSbuAi4A1wAHg6uz+uVQvLXsQ+K2IeETS6cD1EXFpNu+5VC9DywPfBH4jIsbmW1+jBWxmtkgWv4AXmwvYzNpU3QL2O+HMzBJxAZuZJeICNjNLxAVsZpaIC9jMLBEXsJlZIi5gM7NEXMBmZom4gM3MEllS74STNAJ8+wRmXQM82uQ4rdZpmTstL3ReZudtvRPN/GhEXDJ74pIq4BMlqRgRhdQ5GtFpmTstL3ReZudtvWZn9ikIM7NEXMBmZom4gKu2pw5wAjotc6flhc7L7Lyt19TMPgdsZpaIj4DNzBJxAZuZJbKkCjj7mvthSXvrPPY7kvZLekDS/55j/jMl3S7pG5J2S/qMpOdnj71a0oikPdkybpV0apPz/0G27L2Sdkk6ZY5xfyhpn6T7Jd0r6d2SVmSPPZhN35P9/UvNzFgnS7ekL0u6fZ4xyfLOtU9IemeW6T5Jt0k6bY75k+0Tkp6are+r2fJ/b56xG7N/ywPZNr5++t8k6bPZvr8nW9aWZmWsk+O0bDvsy9b1nHbOOyvTnPuypL/N8nxF0kR2e4+kl0q6SdK3svv7JF294JVGxJL5Azyf6rcn7501/eeBfwVWZvfX1pn3FOBrwGU1084GXp3dfjVwbc1j76f6PXXNyv5jwLeAnuz+B6fXPWvcVuAO4LTsfh54C/Ck7P6DwJrs9gbg2y3e5n+YbYvb53g8ad559okXA7ns9juAd7ThPvEU4Pzs9uosy0/VGXcJsBv4sex+N/AaYEN2/7NAIbv9o8AYkG/R/vD3VL9Md/r/+rR2ztvIvpyNWV9nX7oJeGnNPvNN4GkLWeeSOgKOiDuBx+o8dCXwFxExmY0brjPmlcAXI+Kfa5a3NyJumj1QUg7opbpjNFMO6MmWfyrwcJ0xVwFXRsT3s4yliPiLiPhhnbFPakHGGZIGgV+k+uWpc0mad659IiI+GRHl7O5dwGCd2ZPuExHxSETck90+CHyV6i/q2a4C3hARD2VjpyLixojYX2fsKmAcmGpWzmmSnkT1F94NWY7S9P97O+attcB9eSGmn7WOL2TwkirgeTwTeJ6kuyV9TtLP1Bnzn4B7jrOcKyTtAR6i+pv5o80KmO2M1wDfAR4BfhARn6wdI2k1sCoivnWcxX0me8r9OeCPm5Wxjr8E3gRU6j3Yhnnn8hrg43WmJ90naklaD5wH3F3n4YXkvEXSfcB+4M8iohWF9nRgBPi77Kn89ZJ664xrl7y15t2XF+Cd2X4wBPzDHAd5T7BcCjgH9AE/C7wR+KCkut9SOi07L7hX0kdqJn8gIs4Fngzcny2rKST1Ab8EPA04HeiVtHH2ME0WJS0AAAQtSURBVCBq5vmF7LzTg5L+S824n4+Is4GfBq6VtKpZOWvW/RJgOCJ2zzesXfLOGVC6CigDtyxg7KLuEzXrXQV8GPj9OZ451I796Wwbf0PSFTUPvTIizgHOAN4g6cebnZPqz9n5wLaIOI/qUeBb2jjvdIaF7MvH88aa/eDiWfv3nJZLAQ8BH4mq/6D6W27NrDEPUN15AIiIy6me4/vR2QuL6smej1J9utUsLwS+FREjEXEU+AhwzH9i9sM3Lulp2f1PZP/pe6meb5ud8xvAAeCnmphz2oXAZZIeBP4BeIGkm9s47xNIehXwEqo/7PUuiE+9T6Dqi5UfBm6JiI/MMWwmZ0Tcn23jjwM9dXKOUD36fHYzc2aGgKGImD5Kv5Wa7deGeacdd19eqIg4RPUc9nMXMn65FPA/Ai8AkPRMqj/8sz/R6P3AhZIuq5k23yvazwW+0cSM3wF+VtKp2dH5xVTP+c3258C2mleMxePnnY4haS3VI+oT+YS4eUXEH0XEYESsB14O/FtEzD5ib5u8ddZ1CfBmqi+wHZ5jWNJ9IttWNwBfjYh3zzP0z4FrsvOY055QZtkyT6V6KqOZ+y4AEfE94LuSNmSTLga+UmdoW+Sd1sC+fFzZawHPZoF5cyeyknYlaRdwEbBG0hBwdUTcANwI3JidZywBr5p9xBMRE9lTkXdL+kuqR2IHgf9ZM+wKSc+l+otriOrRUFNExN2SbqX6274MfJn6b3vcRrUE7pY0CRwCvpCNn/YZSVPACuAtEXGgWTlPQNK88+wT1wIrgU9lZ6PuioittfOm3ieoHpn9OnB/dn4R4K0R8bFZOT8maQD4uKRu4PtUn2V8ombYLZImqP6bbzrJp9vz+Z1sXXmqVwP8xuwBbZa3Wd4p6Y+pHtx9muoz2OPyW5HNzBJZLqcgzMzajgvYzCwRF7CZWSIuYDOzRFzAZmaJuIBtWZE0lb3zaq+kj2rWp6Cp+ol0RyT9SM20iySFpN+smXZeNu0Ni5nflhYXsC03ExFxbvbW58eA3571+CuALwGXz5p+P1D7VtmXA/e2LKUtCy5gW86+SM2ni0l6BtVP3/pjqkVc6zvAKZLWZe9Qu4T6H+BjtmAuYFuWsndgXQz8c83kVwC7gM8DG7K3Rte6FXgZ1c/ouAeYXISotoS5gG256cne1jtK9UN1PlXz2MupfpRghepbSV82a94PZtOmi9rspLiAbbmZyD5968epvm//twEknQOcSfWzIR6kWsbHnIbIPmzmKPAiqu/3NzspLmBbliLiB8DvUv2s2RVUy/ZPImJ99ud04MfqfA7t24A3L8IHhNsysKQ+Dc2sERHxZUn3Uj3afTnwX2cNuS2bfnfNPP938RLaUudPQzMzS8SnIMzMEnEBm5kl4gI2M0vEBWxmlogL2MwsERewmVkiLmAzs0T+P1/9EEtT2sP5AAAAAElFTkSuQmCC\n",
"text/plain": [
"<Figure size 360x360 with 1 Axes>"
]
},
"metadata": {
"needs_background": "light"
},
"output_type": "display_data"
}
],
"source": [
"scatplot = sb.relplot(x=\"RAM\", y=\"Screen_size\", data=data)\n",
"scatplot.savefig(\"scatterplt.png\")"
]
},
{
"cell_type": "code",
"execution_count": 21,
"metadata": {},
"outputs": [],
"source": [
"salesprice = data['sales_price'].str.lstrip('$')\n",
"salesprice = pd.to_numeric(salesprice, errors='coerce')\n",
"salesprice.fillna(salesprice.mode()[0], inplace=True)\n",
"screensize = data['Screen_size']\n",
"screensize = pd.to_numeric(screensize, errors='coerce')\n"
]
},
{
"cell_type": "code",
"execution_count": 22,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"[15.6,\n",
" 15.6,\n",
" 17.3,\n",
" 15.6,\n",
" 17.3,\n",
" 14.0,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 14.1,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 11.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 13.5,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 14.0,\n",
" 15.6,\n",
" 15.6,\n",
" 11.6,\n",
" 13.3,\n",
" 14.0,\n",
" 15.6,\n",
" 15.6,\n",
" 14.0,\n",
" 11.6,\n",
" 13.3,\n",
" 15.6,\n",
" 15.6,\n",
" 14.0,\n",
" 14.0,\n",
" 14.0,\n",
" 15.6,\n",
" 15.6,\n",
" 14.0,\n",
" 14.0,\n",
" 14.0,\n",
" 15.6,\n",
" 15.6,\n",
" 14.0,\n",
" 14.0,\n",
" 14.0,\n",
" 14.0,\n",
" 15.6,\n",
" 14.0,\n",
" 15.6,\n",
" 15.6,\n",
" 14.0,\n",
" 14.0,\n",
" 14.0,\n",
" 15.6,\n",
" 14.0,\n",
" 15.6,\n",
" 15.6,\n",
" 14.0,\n",
" 11.6,\n",
" 17.0,\n",
" 15.6,\n",
" 13.3,\n",
" 11.6,\n",
" 14.0,\n",
" 13.3,\n",
" 15.6,\n",
" 14.0,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 11.6,\n",
" 11.6,\n",
" 14.0,\n",
" 11.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 14.0,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 17.3,\n",
" 13.3,\n",
" 17.3,\n",
" 15.6,\n",
" 15.6,\n",
" 14.0,\n",
" 11.6,\n",
" 11.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 14.0,\n",
" 14.0,\n",
" 15.6,\n",
" 15.6,\n",
" 14.0,\n",
" 15.6,\n",
" 14.0,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 11.6,\n",
" 15.6,\n",
" 14.0,\n",
" 11.6,\n",
" 14.0,\n",
" 11.6,\n",
" 11.6,\n",
" 13.3,\n",
" 14.0,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 14.0,\n",
" 14.0,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 14.0,\n",
" 14.0,\n",
" 14.0,\n",
" 15.6,\n",
" 11.6,\n",
" 15.6,\n",
" 12.5,\n",
" 14.0,\n",
" 11.6,\n",
" 15.6,\n",
" 15.6,\n",
" 15.6,\n",
" 11.6,\n",
" 14.0,\n",
" 17.3,\n",
" 15.6,\n",
" 14.0]"
]
},
"execution_count": 22,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"screensizee = []\n",
"for i in screensize:\n",
" if i == 156.0:\n",
" i = 15.6\n",
" screensizee.append(i)\n",
"screensizee"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": [
"for i in screensizee:\n",
" print(i)"
]
},
{
"cell_type": "code",
"execution_count": 23,
"metadata": {},
"outputs": [],
"source": [
"data['Screen_size'] = screensizee"
]
},
{
"cell_type": "code",
"execution_count": 33,
"metadata": {},
"outputs": [],
"source": [
"data['Processor_GHz'] = data['Processor_power'].str.rstrip('GHz')\n",
"data['RAM_GB'] = data['RAM'].str.rstrip(' GB')"
]
},
{
"cell_type": "code",
"execution_count": 108,
"metadata": {},
"outputs": [],
"source": [
"processortypez = data['Processor_type'].str.lstrip(' Intel')\n",
"pt = []\n",
"for i in processortypez:\n",
" if i == 'core_m':\n",
" i = 'M Series'\n",
" elif i == 'AMD A4' or i =='AMD A6' or i=='Apple A6':\n",
" i = 'AMD A Series'\n",
" elif i == 'i7' or i == 'Core':\n",
" i = 'Core i7'\n",
" pt.append(i)\n",
"\n",
"data['Processor_type'] = pt\n",
"proz = data['Processor_type']\n",
"\n",
"pz = []\n",
"for i in proz:\n",
" if i != 'Core i3' and i != 'Core i5' and i != 'Core i7' and i != 'Celeron' and i != 'Pentium' and i != 'AMD A Series' and i != 'AMD R Series':\n",
" i = 'Other'\n",
" pz.append(i)\n",
"pz\n",
"\n",
"data['Processor_type'] = pz"
]
},
{
"cell_type": "code",
"execution_count": 106,
"metadata": {},
"outputs": [],
"source": [
"strzz = data['Storage']\n",
"zz = []\n",
"for i in strzz:\n",
" if i == '1TB':\n",
" i = '1000GB'\n",
" elif i == '2TB':\n",
" i = '2000GB'\n",
" elif i == 'FlashMemory':\n",
" i = '64GB'\n",
" zz.append(i)\n",
"data['Storage'] = zz\n",
"data['Storage_GB'] = data['Storage'].str.rstrip('GB')\n"
]
},
{
"cell_type": "code",
"execution_count": 111,
"metadata": {},
"outputs": [],
"source": [
"uzi = data['Processor_type']\n",
"\n",
"jumm = []\n",
"for i in uzi:\n",
" if i == 'Core i5' or i == 'Core i3' or i == 'Core i7' or i == 'Celeron' or i == 'Pentium':\n",
" i = 'Intel'\n",
" elif i == 'AMD A Series' or i == 'AMD R Series':\n",
" i = 'AMD'\n",
" else:\n",
" i = 'Other'\n",
" jumm.append(i)\n",
" \n",
"data['Processor_brand'] = jumm\n",
" "
]
},
{
"cell_type": "code",
"execution_count": 118,
"metadata": {},
"outputs": [],
"source": [
"hg = data['Graphics_brand']\n",
"ul = []\n",
"\n",
"for i in hg:\n",
" if i == 'intel':\n",
" i = 'Intel'\n",
" elif i == 'NVIDIA' or i == 'nvidia':\n",
" i = 'Nvidia'\n",
" elif i == 'amd':\n",
" i = 'AMD'\n",
" ul.append(i)\n",
" \n",
"data['Graphics_brand'] = ul"
]
},
{
"cell_type": "code",
"execution_count": 127,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"HDD\n",
"HDD\n",
"PCIE\n",
"HDD\n",
"512GB\n",
"Embedded\n",
"HDD\n",
"na\n",
"flash_memory_solid_state\n",
"SSD\n",
"flash_memory_solid_state\n",
"SSD\n",
"mechanical_hard_drive\n",
"HDD\n",
"Flash\n",
"Flash\n",
"SSD\n",
"Hybrid\n",
"Flash\n",
"Hybrid\n",
"HDD\n",
"Solid\n",
"Flash\n",
"SSD\n",
"SSD\n",
"Flash\n",
"Flash\n",
"mechanical_hard_drive\n",
"flash_memory_solid_state\n",
"Flash\n",
"Flash\n",
"mechanical_hard_drive\n",
"HDD\n",
"Embedded\n",
"Flash\n",
"Flash\n",
"Hybrid\n",
"mechanical_hard_drive\n",
"emmc\n",
"flash_memory_solid_state\n",
"flash_memory_solid_state\n",
"SSD\n",
"flash_memory_solid_state\n",
"Solid\n",
"SSD\n",
"HDD\n",
"Hybrid\n",
"Mechanical\n",
"Embedded\n",
"Embedded\n",
"HDD\n",
"HDD\n",
"Flash\n",
"SSD\n",
"emmc\n",
"SSD\n",
"Embedded\n",
"SSD\n",
"emmc\n",
"SSD\n",
"Flash\n",
"flash_memory_solid_state\n",
"Solid\n",
"Flash\n",
"Flash\n",
"Flash\n",
"SSD\n",
"Mechanical\n",
"flash_memory_solid_state\n",
"Flash\n",
"Flash\n",
"Flash\n",
"flash_memory_solid_state\n",
"SSD\n",
"emmc\n",
"HDD\n",
"Hybrid\n",
"emmc\n",
"flash_memory_solid_state\n",
"SSD\n",
"flash_memory_solid_state\n",
"Flash\n",
"Flash\n",
"emmc\n",
"SSD\n",
"SSD\n",
"Hybrid\n",
"Flash\n",
"flash_memory_solid_state\n",
"Solid\n",
"SSD\n",
"HDD\n",
"Flash\n",
"Flash\n",
"Hybrid\n",
"flash_memory_solid_state\n",
"PCIe\n",
"Flash\n",
"HDD\n",
"SSD\n",
"emmc\n",
"64GB\n",
"HDD\n",
"flash_memory_solid_state\n",
"SSD\n",
"mechanical_hard_drive\n",
"Hybrid\n",
"Flash\n",
"flash_memory_solid_state\n",
"SSD\n",
"Mechanical\n",
"Hybrid\n",
"flash_memory_solid_state\n",
"Mechanical\n",
"HDD\n",
"SSD\n",
"HDD\n",
"Hybrid\n",
"emmc\n",
"eMMC\n",
"Embedded\n",
"emmc\n",
"Flash\n",
"Flash\n",
"Flash\n",
"Flash\n",
"128GB\n",
"HDD\n",
"flash_memory_solid_state\n",
"mechanical_hard_drive\n",
"Flash\n",
"SSD\n",
"SSD\n",
"Flash\n",
"Flash\n",
"emmc\n",
"emmc\n",
"flash_memory_solid_state\n",
"Flash\n",
"flash_memory_solid_state\n",
"mechanical_hard_drive\n",
"mechanical_hard_drive\n",
"Flash\n",
"SSD\n",
"flash_memory_solid_state\n",
"SSD\n",
"Flash\n",
"SSD\n",
"mechanical_hard_drive\n",
"Flash\n",
"Hybrid\n",
"HDD\n",
"HDD\n",
"SSD\n",
"flash_memory_solid_state\n",
"HDD\n",
"HDD\n",
"flash_memory_solid_state\n"
]
}
],
"source": [
"huu = data['Storage_type']\n",
"gyu = []\n",
"\n",
"for i in huu:\n",
" if i == 'flash_memory_solid_state':\n",
" i = 'Flash'\n",
" elif i == 'mechanical_hard_drive' or i =='Mechanical':\n",
" i = 'HDD'\n",
" elif i == 'emmc':\n",
" i = 'eMMC'\n",
" elif i == 'PCIE' or i == 'Solid':\n",
" i == 'SSD'"
]
},
{
"cell_type": "code",
"execution_count": 122,
"metadata": {},
"outputs": [],
"source": [
"data['review_count'] = data['review_count'].str.rstrip(' ratings')"
]
},
{
"cell_type": "code",
"execution_count": 125,
"metadata": {},
"outputs": [],
"source": [
"data = data.drop(columns=['Processor_power', 'RAM', 'Storage'])"
]
},
{
"cell_type": "code",
"execution_count": 126,
"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>listing</th>\n",
" <th>listing-href</th>\n",
" <th>brand</th>\n",
" <th>review_count</th>\n",
" <th>sales_price</th>\n",
" <th>product_description</th>\n",
" <th>product_specification</th>\n",
" <th>Screen_size</th>\n",
" <th>Processor_type</th>\n",
" <th>Storage_type</th>\n",
" <th>Graphics_brand</th>\n",
" <th>Graphics_type</th>\n",
" <th>Processor_GHz</th>\n",
" <th>RAM_GB</th>\n",
" <th>Storage_GB</th>\n",
" <th>Processor_brand</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>0</td>\n",
" <td>2019 Dell Inspiron 15.6\" Laptop Computer, 8th ...</td>\n",
" <td>https://www.amazon.com/Dell-Inspiron-Computer-...</td>\n",
" <td>Amazon Renewed</td>\n",
" <td>1</td>\n",
" <td>$509.00</td>\n",
" <td>Product description Processor: 8th generation...</td>\n",
" <td>Screen Size 15.6 inches Screen Resolution 136...</td>\n",
" <td>15.6</td>\n",
" <td>Core i5</td>\n",
" <td>HDD</td>\n",
" <td>Intel</td>\n",
" <td>Integrated</td>\n",
" <td>1.6</td>\n",
" <td>16</td>\n",
" <td>1000</td>\n",
" <td>Intel</td>\n",
" </tr>\n",
" <tr>\n",
" <td>1</td>\n",
" <td>Newest HP 15.6-inch HD Touchscreen Display Lap...</td>\n",
" <td>https://www.amazon.com/HP-15-6-inch-Touchscree...</td>\n",
" <td>HP</td>\n",
" <td>27</td>\n",
" <td>$466.99</td>\n",
" <td>Product description Operating System: Windows...</td>\n",
" <td>Screen Size 15.6 inches Screen Resolution 136...</td>\n",
" <td>15.6</td>\n",
" <td>Core i3</td>\n",
" <td>HDD</td>\n",
" <td>Intel</td>\n",
" <td>Integrated</td>\n",
" <td>2.4</td>\n",
" <td>8</td>\n",
" <td>1000</td>\n",
" <td>Intel</td>\n",
" </tr>\n",
" <tr>\n",
" <td>2</td>\n",
" <td>2019 Lenovo L340 17.3\" Laptop Computer, 8th Ge...</td>\n",
" <td>https://www.amazon.com/Lenovo-L340-Computer-i3...</td>\n",
" <td>Lenovo</td>\n",
" <td>10</td>\n",
" <td>$423.99</td>\n",
" <td>Product description Specifications: Processo...</td>\n",
" <td>Screen Size 17.3 inches Screen Resolution 140...</td>\n",
" <td>17.3</td>\n",
" <td>Core i3</td>\n",
" <td>PCIE</td>\n",
" <td>Intel</td>\n",
" <td>Integrated</td>\n",
" <td>2.1</td>\n",
" <td>8</td>\n",
" <td>1000</td>\n",
" <td>Intel</td>\n",
" </tr>\n",
" <tr>\n",
" <td>3</td>\n",
" <td>2018 Dell Inspiron 15 5000 15.6 inch Full HD T...</td>\n",
" <td>https://www.amazon.com/Dell-Inspiron-Keyboard-...</td>\n",
" <td>Dell</td>\n",
" <td>242</td>\n",
" <td>$534.98</td>\n",
" <td>Product description Capacity:8GB RAM | 1TB HDD...</td>\n",
" <td>Screen Size 15.6 inches Screen Resolution 192...</td>\n",
" <td>15.6</td>\n",
" <td>Core i5</td>\n",
" <td>HDD</td>\n",
" <td>Intel</td>\n",
" <td>Integrated</td>\n",
" <td>1.6</td>\n",
" <td>8</td>\n",
" <td>1000</td>\n",
" <td>Intel</td>\n",
" </tr>\n",
" <tr>\n",
" <td>4</td>\n",
" <td>Dell G7 17 Gaming Laptop (Windows 10 Home, 9th...</td>\n",
" <td>https://www.amazon.com/Dell-Gaming-Windows-i7-...</td>\n",
" <td>Dell</td>\n",
" <td>27</td>\n",
" <td>$1,236.00</td>\n",
" <td>Product description Color:Gray 17-Inch Dell g...</td>\n",
" <td>Screen Size 17.3 inches Max Screen Resolution...</td>\n",
" <td>17.3</td>\n",
" <td>Core i7</td>\n",
" <td>512GB</td>\n",
" <td>Nvidia</td>\n",
" <td>Dedicated</td>\n",
" <td>4.5</td>\n",
" <td>16</td>\n",
" <td>512</td>\n",
" <td>Intel</td>\n",
" </tr>\n",
" <tr>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>153</td>\n",
" <td>Lenovo Chromebook 2-in-1 Convertible Laptop, 1...</td>\n",
" <td>https://www.amazon.com/Lenovo-Chromebook-Conve...</td>\n",
" <td>Lenovo</td>\n",
" <td>46</td>\n",
" <td>$243.24</td>\n",
" <td>Product description Description: Lenovo Conve...</td>\n",
" <td>Screen Size 11.6 inches Processor 2.1 GHz Non...</td>\n",
" <td>11.6</td>\n",
" <td>Other</td>\n",
" <td>SSD</td>\n",
" <td>MediaTek</td>\n",
" <td>Integrated</td>\n",
" <td>2.1</td>\n",
" <td>4</td>\n",
" <td>32</td>\n",
" <td>Other</td>\n",
" </tr>\n",
" <tr>\n",
" <td>154</td>\n",
" <td>2019 HP 14, 14\" HD Thin &amp; Light Flagship Lapto...</td>\n",
" <td>https://www.amazon.com/HP-14-Flagship-Computer...</td>\n",
" <td>HP</td>\n",
" <td>9</td>\n",
" <td>$302.00</td>\n",
" <td>Product description Microprocessor: Intel Cor...</td>\n",
" <td>Screen Size 14 inches Max Screen Resolution 1...</td>\n",
" <td>14.0</td>\n",
" <td>Core i3</td>\n",
" <td>flash_memory_solid_state</td>\n",
" <td>Intel</td>\n",
" <td>Integrated</td>\n",
" <td>2.4</td>\n",
" <td>4</td>\n",
" <td>128</td>\n",
" <td>Intel</td>\n",
" </tr>\n",
" <tr>\n",
" <td>155</td>\n",
" <td>HP 17.3\" HD+ SVA WLED-Backlit Notebook Laptop,...</td>\n",
" <td>https://www.amazon.com/HP-WLED-Backlit-Noteboo...</td>\n",
" <td>HP</td>\n",
" <td>44</td>\n",
" <td>$758.00</td>\n",
" <td>Product description 8th Generation Intel Core...</td>\n",
" <td>Screen Size 17.3 inches Screen Resolution 160...</td>\n",
" <td>17.3</td>\n",
" <td>Core i5</td>\n",
" <td>HDD</td>\n",
" <td>Intel</td>\n",
" <td>Integrated</td>\n",
" <td>1.6</td>\n",
" <td>8</td>\n",
" <td>2000</td>\n",
" <td>Intel</td>\n",
" </tr>\n",
" <tr>\n",
" <td>156</td>\n",
" <td>HP 2019 Newest 15 15.6 Inch HD Laptop (Intel D...</td>\n",
" <td>https://www.amazon.com/HP-i3-7100U-Graphics-Bl...</td>\n",
" <td>HP</td>\n",
" <td>3</td>\n",
" <td>$299.00</td>\n",
" <td>Product description NexiPC sells computers wi...</td>\n",
" <td>Screen Size 15.6 inches Screen Resolution 136...</td>\n",
" <td>15.6</td>\n",
" <td>Core i3</td>\n",
" <td>HDD</td>\n",
" <td>Intel</td>\n",
" <td>Integrated</td>\n",
" <td>2.4</td>\n",
" <td>4</td>\n",
" <td>1000</td>\n",
" <td>Intel</td>\n",
" </tr>\n",
" <tr>\n",
" <td>157</td>\n",
" <td>2019 HP Laptop Computer, 14\" FHD IPS BrightVie...</td>\n",
" <td>https://www.amazon.com/gp/slredirect/picassoRe...</td>\n",
" <td>HP</td>\n",
" <td>2</td>\n",
" <td>$522.00</td>\n",
" <td>Product description Processor &amp; Memory:Intel ...</td>\n",
" <td>Screen Size 14 inches Screen Resolution 1920x...</td>\n",
" <td>14.0</td>\n",
" <td>Core i3</td>\n",
" <td>flash_memory_solid_state</td>\n",
" <td>Intel</td>\n",
" <td>Integrated</td>\n",
" <td>2.2</td>\n",
" <td>8</td>\n",
" <td>256</td>\n",
" <td>Intel</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>158 rows × 16 columns</p>\n",
"</div>"
],
"text/plain": [
" listing \\\n",
"0 2019 Dell Inspiron 15.6\" Laptop Computer, 8th ... \n",
"1 Newest HP 15.6-inch HD Touchscreen Display Lap... \n",
"2 2019 Lenovo L340 17.3\" Laptop Computer, 8th Ge... \n",
"3 2018 Dell Inspiron 15 5000 15.6 inch Full HD T... \n",
"4 Dell G7 17 Gaming Laptop (Windows 10 Home, 9th... \n",
".. ... \n",
"153 Lenovo Chromebook 2-in-1 Convertible Laptop, 1... \n",
"154 2019 HP 14, 14\" HD Thin & Light Flagship Lapto... \n",
"155 HP 17.3\" HD+ SVA WLED-Backlit Notebook Laptop,... \n",
"156 HP 2019 Newest 15 15.6 Inch HD Laptop (Intel D... \n",
"157 2019 HP Laptop Computer, 14\" FHD IPS BrightVie... \n",
"\n",
" listing-href brand \\\n",
"0 https://www.amazon.com/Dell-Inspiron-Computer-... Amazon Renewed \n",
"1 https://www.amazon.com/HP-15-6-inch-Touchscree... HP \n",
"2 https://www.amazon.com/Lenovo-L340-Computer-i3... Lenovo \n",
"3 https://www.amazon.com/Dell-Inspiron-Keyboard-... Dell \n",
"4 https://www.amazon.com/Dell-Gaming-Windows-i7-... Dell \n",
".. ... ... \n",
"153 https://www.amazon.com/Lenovo-Chromebook-Conve... Lenovo \n",
"154 https://www.amazon.com/HP-14-Flagship-Computer... HP \n",
"155 https://www.amazon.com/HP-WLED-Backlit-Noteboo... HP \n",
"156 https://www.amazon.com/HP-i3-7100U-Graphics-Bl... HP \n",
"157 https://www.amazon.com/gp/slredirect/picassoRe... HP \n",
"\n",
" review_count sales_price \\\n",
"0 1 $509.00 \n",
"1 27 $466.99 \n",
"2 10 $423.99 \n",
"3 242 $534.98 \n",
"4 27 $1,236.00 \n",
".. ... ... \n",
"153 46 $243.24 \n",
"154 9 $302.00 \n",
"155 44 $758.00 \n",
"156 3 $299.00 \n",
"157 2 $522.00 \n",
"\n",
" product_description \\\n",
"0 Product description Processor: 8th generation... \n",
"1 Product description Operating System: Windows... \n",
"2 Product description Specifications: Processo... \n",
"3 Product description Capacity:8GB RAM | 1TB HDD... \n",
"4 Product description Color:Gray 17-Inch Dell g... \n",
".. ... \n",
"153 Product description Description: Lenovo Conve... \n",
"154 Product description Microprocessor: Intel Cor... \n",
"155 Product description 8th Generation Intel Core... \n",
"156 Product description NexiPC sells computers wi... \n",
"157 Product description Processor & Memory:Intel ... \n",
"\n",
" product_specification Screen_size \\\n",
"0 Screen Size 15.6 inches Screen Resolution 136... 15.6 \n",
"1 Screen Size 15.6 inches Screen Resolution 136... 15.6 \n",
"2 Screen Size 17.3 inches Screen Resolution 140... 17.3 \n",
"3 Screen Size 15.6 inches Screen Resolution 192... 15.6 \n",
"4 Screen Size 17.3 inches Max Screen Resolution... 17.3 \n",
".. ... ... \n",
"153 Screen Size 11.6 inches Processor 2.1 GHz Non... 11.6 \n",
"154 Screen Size 14 inches Max Screen Resolution 1... 14.0 \n",
"155 Screen Size 17.3 inches Screen Resolution 160... 17.3 \n",
"156 Screen Size 15.6 inches Screen Resolution 136... 15.6 \n",
"157 Screen Size 14 inches Screen Resolution 1920x... 14.0 \n",
"\n",
" Processor_type Storage_type Graphics_brand Graphics_type \\\n",
"0 Core i5 HDD Intel Integrated \n",
"1 Core i3 HDD Intel Integrated \n",
"2 Core i3 PCIE Intel Integrated \n",
"3 Core i5 HDD Intel Integrated \n",
"4 Core i7 512GB Nvidia Dedicated \n",
".. ... ... ... ... \n",
"153 Other SSD MediaTek Integrated \n",
"154 Core i3 flash_memory_solid_state Intel Integrated \n",
"155 Core i5 HDD Intel Integrated \n",
"156 Core i3 HDD Intel Integrated \n",
"157 Core i3 flash_memory_solid_state Intel Integrated \n",
"\n",
" Processor_GHz RAM_GB Storage_GB Processor_brand \n",
"0 1.6 16 1000 Intel \n",
"1 2.4 8 1000 Intel \n",
"2 2.1 8 1000 Intel \n",
"3 1.6 8 1000 Intel \n",
"4 4.5 16 512 Intel \n",
".. ... ... ... ... \n",
"153 2.1 4 32 Other \n",
"154 2.4 4 128 Intel \n",
"155 1.6 8 2000 Intel \n",
"156 2.4 4 1000 Intel \n",
"157 2.2 8 256 Intel \n",
"\n",
"[158 rows x 16 columns]"
]
},
"execution_count": 126,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.7.3"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment