File size: 23,079 Bytes
5ab8a9f |
1 |
{"cells":[{"cell_type":"code","execution_count":30,"id":"63eac0a4","metadata":{"id":"63eac0a4","executionInfo":{"status":"ok","timestamp":1736407450159,"user_tz":-360,"elapsed":322,"user":{"displayName":"44-271-Munsi Walid Al Hassan Nizhu","userId":"16216461530557409787"}}},"outputs":[],"source":["from bs4 import BeautifulSoup\n","import requests\n","import pandas as pd\n","import numpy as np"]},{"cell_type":"code","execution_count":31,"id":"8ca27ab4","metadata":{"id":"8ca27ab4","executionInfo":{"status":"ok","timestamp":1736407450513,"user_tz":-360,"elapsed":2,"user":{"displayName":"44-271-Munsi Walid Al Hassan Nizhu","userId":"16216461530557409787"}}},"outputs":[],"source":["# Function to extract Product Title\n","def get_title(soup):\n","\n"," try:\n"," # Outer Tag Object\n"," title_string = soup.find(\"span\", attrs={\"id\":'productTitle'}).text.strip()\n","\n"," except AttributeError:\n"," title_string = \"\"\n","\n"," return title_string\n","\n","# Function to extract Product Price\n","def get_price(soup):\n","\n"," try:\n"," price = soup.find(\"span\", attrs={'class':'a-price aok-align-center reinventPricePriceToPayMargin priceToPay'}).text.strip()\n","\n"," except AttributeError:\n"," price = \"\"\n","\n"," return price\n","\n","# Function to extract Product Rating\n","def get_rating(soup):\n","\n"," try:\n"," rating = soup.find(\"i\", attrs={'class':'a-icon a-icon-star a-star-4-5 cm-cr-review-stars-spacing-big'}).text.strip()\n","\n"," except AttributeError:\n"," try:\n"," rating = soup.find(\"span\", attrs={'class':'a-icon-alt'}).text.strip()\n"," except:\n"," rating = \"\"\n","\n"," return rating\n","\n","# Function to extract Number of User Reviews\n","def get_review_count(soup):\n"," try:\n"," review_count = soup.find(\"span\", attrs={'id':'acrCustomerReviewText'}).text.strip()\n","\n"," except AttributeError:\n"," review_count = \"\"\n","\n"," return review_count\n","\n","# Function to extract Availability Status\n","def get_availability(soup):\n"," try:\n"," available = soup.find(\"span\", attrs={'class':'a-size-medium a-color-success'}).text.strip()\n","\n"," except AttributeError:\n"," try:\n"," available = soup.find(\"span\", attrs={'class':'a-size-base a-color-price a-text-bold'}).text.strip()\n"," except AttributeError:\n"," available = \"Not Available\"\n","\n"," return available"]},{"cell_type":"code","execution_count":32,"id":"4713b996","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"4713b996","executionInfo":{"status":"ok","timestamp":1736407463579,"user_tz":-360,"elapsed":13067,"user":{"displayName":"44-271-Munsi Walid Al Hassan Nizhu","userId":"16216461530557409787"}},"outputId":"d67af827-0090-4bd6-84a3-6e404e4df1c0"},"outputs":[{"output_type":"stream","name":"stdout","text":["webpage: <Response [200]>\n"]}],"source":["if __name__ == '__main__':\n"," # add your user agent\n"," HEADERS = {'User-Agent': '', 'Accept-Language': 'en-US, en;q=0.5'}\n","\n"," # The webpage URL\n"," URL = \"https://www.amazon.com/s?k=laptop&crid=O6A9159L6OOM&sprefix=lap%2Caps%2C300&ref=nb_sb_ss_ts-doa-p_1_3\"\n","\n"," # HTTP Request\n"," webpage = requests.get(URL, headers=HEADERS)\n"," print(\"webpage: \",webpage)\n","\n"," # Soup Object containing all data\n"," soup = BeautifulSoup(webpage.content, \"html.parser\") # Convert Byte to Html Formate\n","\n"," # Fetch links as List of Tag Objects\n"," links = soup.find_all(\"a\", attrs={'class':'a-link-normal s-no-outline'})\n"," # print(\"links: \",links)\n","\n"," # Store the links\n"," links_list = []\n","\n"," # Loop for extracting links from Tag Objects\n"," for link in links:\n"," links_list.append(link.get('href'))\n","\n"," d = {\"title\":[], \"price\":[], \"rating\":[], \"reviews\":[],\"availability\":[]}\n","\n"," # Loop for extracting product details from each link\n"," for link in links_list:\n"," new_webpage = requests.get(\"https://www.amazon.com\" + link, headers=HEADERS)\n","\n"," new_soup = BeautifulSoup(new_webpage.content, \"html.parser\")\n","\n"," # Function calls to display all necessary product information\n"," d['title'].append(get_title(new_soup))\n"," d['price'].append(get_price(new_soup))\n"," d['rating'].append(get_rating(new_soup))\n"," d['reviews'].append(get_review_count(new_soup))\n"," d['availability'].append(get_availability(new_soup))\n","\n","\n"," amazon_df = pd.DataFrame.from_dict(d)\n"," amazon_df.to_csv(\"amazon_data.csv\", header=True, index=False)"]},{"cell_type":"code","execution_count":33,"id":"db08fbaf","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":551},"id":"db08fbaf","executionInfo":{"status":"ok","timestamp":1736407463579,"user_tz":-360,"elapsed":5,"user":{"displayName":"44-271-Munsi Walid Al Hassan Nizhu","userId":"16216461530557409787"}},"outputId":"c6bc2f33-7779-434f-cae2-c640ea2b3789"},"outputs":[{"output_type":"execute_result","data":{"text/plain":[" title price \\\n","0 HP 14 Laptop, Intel Celeron N4020, 4 GB RAM, 6... \n","1 \n","2 \n","3 \n","4 Lenovo Essential IdeaPad • 36GB RAM • 1.5TB St... \n","5 \n","6 ACEMAGIC Laptop,15.6In Windows 11 Laptop Compu... \n","7 \n","8 HP 15.6\" Laptop, 32GB RAM 1TB SSD | FHD Busine... \n","9 \n","10 \n","11 ASUS Chromebook CM14 Laptop, 14\" HD Anti-Glare... \n","12 HP Newest 14\" LED Business Laptop Computer, 16... \n","13 ApoloSign 15.6\" Full HD Laptop, 12GB RAM, 512G... \n","14 HP 14\" Laptop, 8GB DDR4 RAM, 64GB eMMC, Silver... \n","15 HP 17 Laptop, 17.3\" HD+ Touchscreen Display, 1... $903.99 \n","\n"," rating reviews availability \n","0 4.0 out of 5 stars (2,058) Not Available \n","1 Not Available \n","2 Not Available \n","3 Not Available \n","4 4.2 out of 5 stars (56) Not Available \n","5 Not Available \n","6 4.3 out of 5 stars (14) Not Available \n","7 Not Available \n","8 4.8 out of 5 stars (7) Not Available \n","9 Not Available \n","10 Not Available \n","11 4.2 out of 5 stars (1,169) Not Available \n","12 4.1 out of 5 stars (93) Not Available \n","13 5.0 out of 5 stars (8) Not Available \n","14 4.0 out of 5 stars (1,908) Not Available \n","15 4.2 out of 5 stars 453 ratings In Stock "],"text/html":["\n"," <div id=\"df-458407f3-c7b0-41eb-b317-ff08a2ec7ff6\" class=\"colab-df-container\">\n"," <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>title</th>\n"," <th>price</th>\n"," <th>rating</th>\n"," <th>reviews</th>\n"," <th>availability</th>\n"," </tr>\n"," </thead>\n"," <tbody>\n"," <tr>\n"," <th>0</th>\n"," <td>HP 14 Laptop, Intel Celeron N4020, 4 GB RAM, 6...</td>\n"," <td></td>\n"," <td>4.0 out of 5 stars</td>\n"," <td>(2,058)</td>\n"," <td>Not Available</td>\n"," </tr>\n"," <tr>\n"," <th>1</th>\n"," <td></td>\n"," <td></td>\n"," <td></td>\n"," <td></td>\n"," <td>Not Available</td>\n"," </tr>\n"," <tr>\n"," <th>2</th>\n"," <td></td>\n"," <td></td>\n"," <td></td>\n"," <td></td>\n"," <td>Not Available</td>\n"," </tr>\n"," <tr>\n"," <th>3</th>\n"," <td></td>\n"," <td></td>\n"," <td></td>\n"," <td></td>\n"," <td>Not Available</td>\n"," </tr>\n"," <tr>\n"," <th>4</th>\n"," <td>Lenovo Essential IdeaPad • 36GB RAM • 1.5TB St...</td>\n"," <td></td>\n"," <td>4.2 out of 5 stars</td>\n"," <td>(56)</td>\n"," <td>Not Available</td>\n"," </tr>\n"," <tr>\n"," <th>5</th>\n"," <td></td>\n"," <td></td>\n"," <td></td>\n"," <td></td>\n"," <td>Not Available</td>\n"," </tr>\n"," <tr>\n"," <th>6</th>\n"," <td>ACEMAGIC Laptop,15.6In Windows 11 Laptop Compu...</td>\n"," <td></td>\n"," <td>4.3 out of 5 stars</td>\n"," <td>(14)</td>\n"," <td>Not Available</td>\n"," </tr>\n"," <tr>\n"," <th>7</th>\n"," <td></td>\n"," <td></td>\n"," <td></td>\n"," <td></td>\n"," <td>Not Available</td>\n"," </tr>\n"," <tr>\n"," <th>8</th>\n"," <td>HP 15.6\" Laptop, 32GB RAM 1TB SSD | FHD Busine...</td>\n"," <td></td>\n"," <td>4.8 out of 5 stars</td>\n"," <td>(7)</td>\n"," <td>Not Available</td>\n"," </tr>\n"," <tr>\n"," <th>9</th>\n"," <td></td>\n"," <td></td>\n"," <td></td>\n"," <td></td>\n"," <td>Not Available</td>\n"," </tr>\n"," <tr>\n"," <th>10</th>\n"," <td></td>\n"," <td></td>\n"," <td></td>\n"," <td></td>\n"," <td>Not Available</td>\n"," </tr>\n"," <tr>\n"," <th>11</th>\n"," <td>ASUS Chromebook CM14 Laptop, 14\" HD Anti-Glare...</td>\n"," <td></td>\n"," <td>4.2 out of 5 stars</td>\n"," <td>(1,169)</td>\n"," <td>Not Available</td>\n"," </tr>\n"," <tr>\n"," <th>12</th>\n"," <td>HP Newest 14\" LED Business Laptop Computer, 16...</td>\n"," <td></td>\n"," <td>4.1 out of 5 stars</td>\n"," <td>(93)</td>\n"," <td>Not Available</td>\n"," </tr>\n"," <tr>\n"," <th>13</th>\n"," <td>ApoloSign 15.6\" Full HD Laptop, 12GB RAM, 512G...</td>\n"," <td></td>\n"," <td>5.0 out of 5 stars</td>\n"," <td>(8)</td>\n"," <td>Not Available</td>\n"," </tr>\n"," <tr>\n"," <th>14</th>\n"," <td>HP 14\" Laptop, 8GB DDR4 RAM, 64GB eMMC, Silver...</td>\n"," <td></td>\n"," <td>4.0 out of 5 stars</td>\n"," <td>(1,908)</td>\n"," <td>Not Available</td>\n"," </tr>\n"," <tr>\n"," <th>15</th>\n"," <td>HP 17 Laptop, 17.3\" HD+ Touchscreen Display, 1...</td>\n"," <td>$903.99</td>\n"," <td>4.2 out of 5 stars</td>\n"," <td>453 ratings</td>\n"," <td>In Stock</td>\n"," </tr>\n"," </tbody>\n","</table>\n","</div>\n"," <div class=\"colab-df-buttons\">\n","\n"," <div class=\"colab-df-container\">\n"," <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-458407f3-c7b0-41eb-b317-ff08a2ec7ff6')\"\n"," title=\"Convert this dataframe to an interactive table.\"\n"," style=\"display:none;\">\n","\n"," <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n"," <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n"," </svg>\n"," </button>\n","\n"," <style>\n"," .colab-df-container {\n"," display:flex;\n"," gap: 12px;\n"," }\n","\n"," .colab-df-convert {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-convert:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," .colab-df-buttons div {\n"," margin-bottom: 4px;\n"," }\n","\n"," [theme=dark] .colab-df-convert {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-convert:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n"," </style>\n","\n"," <script>\n"," const buttonEl =\n"," document.querySelector('#df-458407f3-c7b0-41eb-b317-ff08a2ec7ff6 button.colab-df-convert');\n"," buttonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n"," async function convertToInteractive(key) {\n"," const element = document.querySelector('#df-458407f3-c7b0-41eb-b317-ff08a2ec7ff6');\n"," const dataTable =\n"," await google.colab.kernel.invokeFunction('convertToInteractive',\n"," [key], {});\n"," if (!dataTable) return;\n","\n"," const docLinkHtml = 'Like what you see? Visit the ' +\n"," '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n"," + ' to learn more about interactive tables.';\n"," element.innerHTML = '';\n"," dataTable['output_type'] = 'display_data';\n"," await google.colab.output.renderOutput(dataTable, element);\n"," const docLink = document.createElement('div');\n"," docLink.innerHTML = docLinkHtml;\n"," element.appendChild(docLink);\n"," }\n"," </script>\n"," </div>\n","\n","\n","<div id=\"df-d199c4a0-6cf4-4a90-871c-a553638b1f2e\">\n"," <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-d199c4a0-6cf4-4a90-871c-a553638b1f2e')\"\n"," title=\"Suggest charts\"\n"," style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <g>\n"," <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n"," </g>\n","</svg>\n"," </button>\n","\n","<style>\n"," .colab-df-quickchart {\n"," --bg-color: #E8F0FE;\n"," --fill-color: #1967D2;\n"," --hover-bg-color: #E2EBFA;\n"," --hover-fill-color: #174EA6;\n"," --disabled-fill-color: #AAA;\n"," --disabled-bg-color: #DDD;\n"," }\n","\n"," [theme=dark] .colab-df-quickchart {\n"," --bg-color: #3B4455;\n"," --fill-color: #D2E3FC;\n"," --hover-bg-color: #434B5C;\n"," --hover-fill-color: #FFFFFF;\n"," --disabled-bg-color: #3B4455;\n"," --disabled-fill-color: #666;\n"," }\n","\n"," .colab-df-quickchart {\n"," background-color: var(--bg-color);\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: var(--fill-color);\n"," height: 32px;\n"," padding: 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-quickchart:hover {\n"," background-color: var(--hover-bg-color);\n"," box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: var(--button-hover-fill-color);\n"," }\n","\n"," .colab-df-quickchart-complete:disabled,\n"," .colab-df-quickchart-complete:disabled:hover {\n"," background-color: var(--disabled-bg-color);\n"," fill: var(--disabled-fill-color);\n"," box-shadow: none;\n"," }\n","\n"," .colab-df-spinner {\n"," border: 2px solid var(--fill-color);\n"," border-color: transparent;\n"," border-bottom-color: var(--fill-color);\n"," animation:\n"," spin 1s steps(1) infinite;\n"," }\n","\n"," @keyframes spin {\n"," 0% {\n"," border-color: transparent;\n"," border-bottom-color: var(--fill-color);\n"," border-left-color: var(--fill-color);\n"," }\n"," 20% {\n"," border-color: transparent;\n"," border-left-color: var(--fill-color);\n"," border-top-color: var(--fill-color);\n"," }\n"," 30% {\n"," border-color: transparent;\n"," border-left-color: var(--fill-color);\n"," border-top-color: var(--fill-color);\n"," border-right-color: var(--fill-color);\n"," }\n"," 40% {\n"," border-color: transparent;\n"," border-right-color: var(--fill-color);\n"," border-top-color: var(--fill-color);\n"," }\n"," 60% {\n"," border-color: transparent;\n"," border-right-color: var(--fill-color);\n"," }\n"," 80% {\n"," border-color: transparent;\n"," border-right-color: var(--fill-color);\n"," border-bottom-color: var(--fill-color);\n"," }\n"," 90% {\n"," border-color: transparent;\n"," border-bottom-color: var(--fill-color);\n"," }\n"," }\n","</style>\n","\n"," <script>\n"," async function quickchart(key) {\n"," const quickchartButtonEl =\n"," document.querySelector('#' + key + ' button');\n"," quickchartButtonEl.disabled = true; // To prevent multiple clicks.\n"," quickchartButtonEl.classList.add('colab-df-spinner');\n"," try {\n"," const charts = await google.colab.kernel.invokeFunction(\n"," 'suggestCharts', [key], {});\n"," } catch (error) {\n"," console.error('Error during call to suggestCharts:', error);\n"," }\n"," quickchartButtonEl.classList.remove('colab-df-spinner');\n"," quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n"," }\n"," (() => {\n"," let quickchartButtonEl =\n"," document.querySelector('#df-d199c4a0-6cf4-4a90-871c-a553638b1f2e button');\n"," quickchartButtonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n"," })();\n"," </script>\n","</div>\n","\n"," <div id=\"id_5e413bc3-b678-4760-a730-287811b94b53\">\n"," <style>\n"," .colab-df-generate {\n"," background-color: #E8F0FE;\n"," border: none;\n"," border-radius: 50%;\n"," cursor: pointer;\n"," display: none;\n"," fill: #1967D2;\n"," height: 32px;\n"," padding: 0 0 0 0;\n"," width: 32px;\n"," }\n","\n"," .colab-df-generate:hover {\n"," background-color: #E2EBFA;\n"," box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n"," fill: #174EA6;\n"," }\n","\n"," [theme=dark] .colab-df-generate {\n"," background-color: #3B4455;\n"," fill: #D2E3FC;\n"," }\n","\n"," [theme=dark] .colab-df-generate:hover {\n"," background-color: #434B5C;\n"," box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n"," filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n"," fill: #FFFFFF;\n"," }\n"," </style>\n"," <button class=\"colab-df-generate\" onclick=\"generateWithVariable('amazon_df')\"\n"," title=\"Generate code using this dataframe.\"\n"," style=\"display:none;\">\n","\n"," <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n"," width=\"24px\">\n"," <path d=\"M7,19H8.4L18.45,9,17,7.55,7,17.6ZM5,21V16.75L18.45,3.32a2,2,0,0,1,2.83,0l1.4,1.43a1.91,1.91,0,0,1,.58,1.4,1.91,1.91,0,0,1-.58,1.4L9.25,21ZM18.45,9,17,7.55Zm-12,3A5.31,5.31,0,0,0,4.9,8.1,5.31,5.31,0,0,0,1,6.5,5.31,5.31,0,0,0,4.9,4.9,5.31,5.31,0,0,0,6.5,1,5.31,5.31,0,0,0,8.1,4.9,5.31,5.31,0,0,0,12,6.5,5.46,5.46,0,0,0,6.5,12Z\"/>\n"," </svg>\n"," </button>\n"," <script>\n"," (() => {\n"," const buttonEl =\n"," document.querySelector('#id_5e413bc3-b678-4760-a730-287811b94b53 button.colab-df-generate');\n"," buttonEl.style.display =\n"," google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n"," buttonEl.onclick = () => {\n"," google.colab.notebook.generateWithVariable('amazon_df');\n"," }\n"," })();\n"," </script>\n"," </div>\n","\n"," </div>\n"," </div>\n"],"application/vnd.google.colaboratory.intrinsic+json":{"type":"dataframe","variable_name":"amazon_df","summary":"{\n \"name\": \"amazon_df\",\n \"rows\": 16,\n \"fields\": [\n {\n \"column\": \"title\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 10,\n \"samples\": [\n \"HP 14\\\" Laptop, 8GB DDR4 RAM, 64GB eMMC, Silver | Portable, Student and Business, HD Display, Intel Quad-Core N4120, 1 Year Office 365, Webcam, RJ-45, HDMI, Wi-Fi, Windows 11 Home\",\n \"\",\n \"ASUS Chromebook CM14 Laptop, 14\\\" HD Anti-Glare Display (1366x768), MediaTek Kompanio 520, 4GB RAM, 64GB eMMC, ChromeOS, Gray, CM1402CM2A-DS44, Gravity Grey\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"price\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 2,\n \"samples\": [\n \"$903.99\",\n \"\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"rating\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 7,\n \"samples\": [\n \"4.0 out of 5 stars\",\n \"\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"reviews\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 10,\n \"samples\": [\n \"(1,908)\",\n \"\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"availability\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 2,\n \"samples\": [\n \"In Stock\",\n \"Not Available\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n }\n ]\n}"}},"metadata":{},"execution_count":33}],"source":["amazon_df"]}],"metadata":{"kernelspec":{"display_name":"pp","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.12.7"},"colab":{"provenance":[]}},"nbformat":4,"nbformat_minor":5} |