{ "cells": [ { "cell_type": "code", "execution_count": 22, "metadata": {}, "outputs": [], "source": [ "# import libraries\n", "import re\n", "import datetime\n", "import time\n", "import pandas as pd\n", "import numpy as np\n", "from urllib.request import urlopen\n", "from selenium import webdriver\n", "from selenium.webdriver.common.keys import Keys\n", "from selenium.webdriver.chrome.options import Options\n", "from selenium.webdriver.remote.webelement import WebElement\n", "from selenium.common.exceptions import NoSuchElementException\n", "from selenium.webdriver.support.ui import WebDriverWait\n", "from selenium.webdriver.support import expected_conditions as EC\n", "from selenium.webdriver.common.by import By\n", "from selenium.common.exceptions import TimeoutException" ] }, { "cell_type": "code", "execution_count": 46, "metadata": {}, "outputs": [], "source": [ "\n", "#full_df=pd.Da" ] }, { "cell_type": "code", "execution_count": 24, "metadata": {}, "outputs": [], "source": [ "full_df=pd.read_csv('Scraped_Earbud_Featured_Page.csv')" ] }, { "cell_type": "code", "execution_count": 25, "metadata": {}, "outputs": [], "source": [ "full_df['Product_ID']=full_df['URL'].apply(lambda st: st[st.find(\"dp/\")+3:st.find(\"/ref\")])\n", "full_df['reviewmeta_rating']=''\n", "full_df['decision']=''" ] }, { "cell_type": "code", "execution_count": 26, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | Created_Date | \n", "Depth | \n", "Description | \n", "Height | \n", "Length | \n", "Listed_Date | \n", "Name | \n", "Price | \n", "Rating | \n", "Review | \n", "URL | \n", "Weight | \n", "Product_ID | \n", "reviewmeta_rating | \n", "decision | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2018-12-23T15:27:04.224105 | \n", "1.0 | \n", "Lightweight in-ear stereo earphones provides n... | \n", "7.3 | \n", "3.9 | \n", "NaN | \n", "Betron ELR50 Earphones Earbuds Headphones, Bal... | \n", "10.99 | \n", "4.4 | \n", "827 | \n", "https://www.amazon.com/Betron-Earphones-Headph... | \n", "0.21000 | \n", "B01M8G5K8V | \n", "\n", " | \n", " |
1 | \n", "2018-12-23T15:27:11.659088 | \n", "2.4 | \n", "ACTIVE NOISE CANCELLING: Reduce background sou... | \n", "4.1 | \n", "5.5 | \n", "NaN | \n", "Active Noise Cancelling Earphones, RAVEtone Wi... | \n", "44.99 | \n", "4.4 | \n", "3 | \n", "https://www.amazon.com/Cancelling-Earphones-RA... | \n", "0.38750 | \n", "B07G7468KC | \n", "\n", " | \n", " |
2 | \n", "2018-12-23T15:27:21.007620 | \n", "0.5 | \n", "\\r\\nNATURAL SOUND QUALITY - Super BASS. 20Hz-2... | \n", "0.5 | \n", "0.9 | \n", "NaN | \n", "Earphones Cloudio J1 Noise Cancelling Earbuds ... | \n", "19.99 | \n", "0.0 | \n", "0 | \n", "https://www.amazon.com/Cloudio-J1-Cancelling-H... | \n", "0.03000 | \n", "B079196D5M | \n", "\n", " | \n", " |
3 | \n", "2018-12-23T15:27:36.456498 | \n", "6.8 | \n", "\\r\\nWired In-Ear Headphones: Perfect for exerc... | \n", "3.2 | \n", "3.6 | \n", "NaN | \n", "Panasonic ErgoFit In-Ear Earbud Headphones RP-... | \n", "8.98 | \n", "4.2 | \n", "55942 | \n", "https://www.amazon.com/Panasonic-Headphones-RP... | \n", "0.01000 | \n", "B003EM8008 | \n", "\n", " | \n", " |
4 | \n", "2018-12-23T15:27:46.926620 | \n", "6.8 | \n", "12mm dome type driver units deliver powerful d... | \n", "1.5 | \n", "2.6 | \n", "NaN | \n", "Sony MDRXB50AP Extra Bass Earbud Headset (Black) | \n", "29.99 | \n", "4.1 | \n", "3761 | \n", "https://www.amazon.com/Sony-MDRXB50AP-Extra-Ea... | \n", "0.15000 | \n", "B00JRD13T8 | \n", "\n", " | \n", " |
5 | \n", "2018-12-23T15:27:53.540138 | \n", "1.4 | \n", "ORIGINAL SOUND EXPERIENCES: Excellent stereo h... | \n", "3.5 | \n", "3.5 | \n", "December 20, 2018 | \n", "Earbuds Headphones Stereo in-Ear Earphones Noi... | \n", "12.99 | \n", "5.0 | \n", "162 | \n", "https://www.amazon.com/Headphones-Earphones-Is... | \n", "0.12000 | \n", "B07M935W8X | \n", "\n", " | \n", " |
6 | \n", "2018-12-23T15:28:03.556126 | \n", "1.0 | \n", "COMFORTABLE & SNUG FIT PERFECT FOR WORKOUTS: A... | \n", "1.4 | \n", "4.7 | \n", "NaN | \n", "Avantree Sports Headphones Wired with Micropho... | \n", "14.99 | \n", "4.4 | \n", "327 | \n", "https://www.amazon.com/Avantree-Headphones-Mic... | \n", "0.06000 | \n", "B078T9HFDJ | \n", "\n", " | \n", " |
7 | \n", "2018-12-23T15:28:17.838286 | \n", "8.8 | \n", "\\r\\nDeep, clear sound enhanced by exclusive Tr... | \n", "1.9 | \n", "4.9 | \n", "NaN | \n", "Bose SoundSport in-ear headphones for Samsung ... | \n", "69.99 | \n", "4.0 | \n", "1657 | \n", "https://www.amazon.com/Bose-SoundSport-headpho... | \n", "0.04000 | \n", "B0117RFPCC | \n", "\n", " | \n", " |
8 | \n", "2018-12-23T15:28:27.615538 | \n", "1.2 | \n", "DUAL DRIVER EARBUDS WITH INCREDIBLE SOUND - Ex... | \n", "6.6 | \n", "9.2 | \n", "NaN | \n", "Aiwa Prodigy-1 Premium Earphones - in-Ear Head... | \n", "29.99 | \n", "4.3 | \n", "102 | \n", "https://www.amazon.com/Aiwa-Prodigy-1-Premium-... | \n", "0.15000 | \n", "B07BF5F9LZ | \n", "\n", " | \n", " |
9 | \n", "2018-12-23T15:28:37.388027 | \n", "1.0 | \n", "Lightweight in-ear stereo earphones provides n... | \n", "7.3 | \n", "3.9 | \n", "NaN | \n", "Betron ELR50 Earphones Earbuds Headphones, Bal... | \n", "10.99 | \n", "4.4 | \n", "827 | \n", "https://www.amazon.com/Betron-Earphones-Headph... | \n", "0.21000 | \n", "B01M8G5K8V | \n", "\n", " | \n", " |
10 | \n", "2018-12-23T15:28:45.764686 | \n", "1.1 | \n", "Ergonomic ear bud design makes these earphones... | \n", "3.4 | \n", "3.4 | \n", "NaN | \n", "Earbuds, BYZ Wired Earphones Stereo in Ear Hea... | \n", "9.99 | \n", "5.0 | \n", "132 | \n", "https://www.amazon.com/Earbuds-BYZ-Earphones-H... | \n", "0.03000 | \n", "B07KR681VD | \n", "\n", " | \n", " |
11 | \n", "2018-12-23T15:28:52.915777 | \n", "0.5 | \n", "MAGNETIC FEATURE:The unique magnetic design of... | \n", "1.1 | \n", "1.5 | \n", "NaN | \n", "Wired Earbuds,COSPOR Magnetic in-Ear Stereo Ea... | \n", "15.99 | \n", "5.0 | \n", "44 | \n", "https://www.amazon.com/COSPOR-Magnetic-Earphon... | \n", "0.10000 | \n", "B07LD4SCLZ | \n", "\n", " | \n", " |
12 | \n", "2018-12-23T15:29:01.026100 | \n", "0.0 | \n", "\\r\\nFeel the power of extra bass. Connectivity... | \n", "0.0 | \n", "0.0 | \n", "NaN | \n", "Sony MDRXB510AS/B Extra Bass Wired Headphones,... | \n", "39.99 | \n", "3.9 | \n", "209 | \n", "https://www.amazon.com/Sony-MDRXB510AS-Headpho... | \n", "0.25000 | \n", "B01MTEU4V9 | \n", "\n", " | \n", " |
13 | \n", "2018-12-23T15:29:07.901205 | \n", "1.6 | \n", "♬ EXCEPTIONAL GUALITY OF SOUND - These workout... | \n", "4.3 | \n", "6.5 | \n", "December 4, 2018 | \n", "Running Headphones, LZHE in Ear Hi-Fi Monitor ... | \n", "21.99 | \n", "5.0 | \n", "142 | \n", "https://www.amazon.com/Headphones-LZHE-Isolati... | \n", "0.13000 | \n", "B07L4JJYRB | \n", "\n", " | \n", " |
14 | \n", "2018-12-23T15:29:15.853423 | \n", "0.4 | \n", "\\r\\nPremium audio: Ultra-lightweight, digital ... | \n", "2.2 | \n", "3.0 | \n", "NaN | \n", "Moxil Original 3.5MM Metal In-ear Wired Earpho... | \n", "15.99 | \n", "5.0 | \n", "482 | \n", "https://www.amazon.com/Moxil-Original-Earphone... | \n", "0.05000 | \n", "B07L65BKF9 | \n", "\n", " | \n", " |
15 | \n", "2018-12-23T15:29:23.338881 | \n", "2.0 | \n", "✔【DURABLE LONG LASTING LIFE EARBUDS】:This in e... | \n", "2.0 | \n", "7.0 | \n", "NaN | \n", "Earbuds Ear Buds in Ear Headphones Wired Earph... | \n", "11.99 | \n", "5.0 | \n", "572 | \n", "https://www.amazon.com/Headphones-Earphones-Mi... | \n", "0.04000 | \n", "B07L7XS26S | \n", "\n", " | \n", " |
16 | \n", "2018-12-23T15:29:31.544381 | \n", "1.0 | \n", "COMFORTABLE & SNUG FIT PERFECT FOR WORKOUTS: A... | \n", "1.4 | \n", "4.7 | \n", "NaN | \n", "Avantree Sports Headphones Wired with Micropho... | \n", "14.99 | \n", "4.4 | \n", "327 | \n", "https://www.amazon.com/Avantree-Headphones-Mic... | \n", "0.06000 | \n", "B078T9HFDJ | \n", "\n", " | \n", " |
17 | \n", "2018-12-23T15:29:38.766098 | \n", "1.2 | \n", "COMFORTABLE & SNUG FIT IN KIDS/WOMEN SMALL EAR... | \n", "2.7 | \n", "5.6 | \n", "NaN | \n", "Joysico Sports Headphones Wired Over Ear In-ea... | \n", "14.99 | \n", "4.1 | \n", "84 | \n", "https://www.amazon.com/Joysico-Headphones-Earp... | \n", "0.03000 | \n", "B0796S9CGR | \n", "\n", " | \n", " |
18 | \n", "2018-12-23T15:29:45.662395 | \n", "0.6 | \n", "【Enhanced Sound】Powerful 10mm composite driver... | \n", "1.8 | \n", "51.2 | \n", "NaN | \n", "Anker SoundBuds Verve Built-in Microphone in E... | \n", "15.99 | \n", "3.9 | \n", "105 | \n", "https://www.amazon.com/Anker-SoundBuds-Built-M... | \n", "0.02000 | \n", "B077XNCSQS | \n", "\n", " | \n", " |
19 | \n", "2018-12-23T15:29:52.215953 | \n", "1.7 | \n", "\\r\\nUniversal compatibility: Compatible with m... | \n", "3.1 | \n", "3.9 | \n", "December 14, 2018 | \n", "in-Ear Earbuds,COSPOR Wired Headphones Hands-F... | \n", "15.99 | \n", "5.0 | \n", "58 | \n", "https://www.amazon.com/COSPOR-Headphones-Hands... | \n", "0.04000 | \n", "B07LCRQVYW | \n", "\n", " | \n", " |
20 | \n", "2018-12-23T15:29:58.417132 | \n", "1.2 | \n", "EXECELLENT SOUND BLOCKS OUT EXTERIOR NOISE:Ear... | \n", "4.6 | \n", "5.1 | \n", "December 2, 2018 | \n", "Earbuds Headphones with Microphone Mic Noise I... | \n", "12.99 | \n", "5.0 | \n", "197 | \n", "https://www.amazon.com/Headphones-Microphone-I... | \n", "0.08000 | \n", "B07L2R9KFR | \n", "\n", " | \n", " |
21 | \n", "2018-12-23T15:30:05.561680 | \n", "1.4 | \n", "\\r\\nStereo and Crystal Clear Sound: Built-in h... | \n", "3.2 | \n", "3.2 | \n", "NaN | \n", "Earphones, USTEK in-Ear Wired Earbuds Stereo S... | \n", "10.99 | \n", "5.0 | \n", "135 | \n", "https://www.amazon.com/Earphones-USTEK-Headpho... | \n", "0.15000 | \n", "B07KFD5DFF | \n", "\n", " | \n", " |
22 | \n", "2018-12-23T15:30:12.229971 | \n", "1.3 | \n", "♬【DEEP BASS SOUND & NOISE ISOLATING】Perfect st... | \n", "3.1 | \n", "5.5 | \n", "NaN | \n", "Earbuds Ear Buds Earphones with Microphone Mic... | \n", "12.99 | \n", "5.0 | \n", "98 | \n", "https://www.amazon.com/Earphones-Microphone-He... | \n", "0.11000 | \n", "B07KWM3NZ1 | \n", "\n", " | \n", " |
23 | \n", "2018-12-23T15:30:20.604759 | \n", "1.2 | \n", "Hybrid sound system of symphonic drivers and b... | \n", "3.2 | \n", "5.3 | \n", "NaN | \n", "in Ear Headphones SDFLAYER E97 Pro Earphones w... | \n", "28.99 | \n", "5.0 | \n", "1965 | \n", "https://www.amazon.com/Ear-Headphones-SDFLAYER... | \n", "0.24000 | \n", "B07JZ6N979 | \n", "\n", " | \n", " |
24 | \n", "2018-12-23T15:30:28.461220 | \n", "0.2 | \n", "ACTIVE NOISE CANCELLING: Reduce background sou... | \n", "0.2 | \n", "0.2 | \n", "NaN | \n", "TaoTronics Active Noise Cancelling Headphones,... | \n", "43.99 | \n", "3.9 | \n", "360 | \n", "https://www.amazon.com/TaoTronics-Cancelling-H... | \n", "0.07000 | \n", "B075DBL2QP | \n", "\n", " | \n", " |
25 | \n", "2018-12-23T15:30:34.839770 | \n", "0.4 | \n", "✔【DURABLE LONG LASTING LIFE EARBUDS】:This in e... | \n", "3.2 | \n", "6.0 | \n", "NaN | \n", "KURSO Compatible for iPhone Samsung Android Ea... | \n", "11.99 | \n", "5.0 | \n", "332 | \n", "https://www.amazon.com/KURSO-Compatible-Headph... | \n", "0.03000 | \n", "B07J59RGH7 | \n", "\n", " | \n", " |
26 | \n", "2018-12-23T15:30:41.286558 | \n", "1.0 | \n", "✤Ultra Perfect Sound Quality - Perfect stereo ... | \n", "3.7 | \n", "3.8 | \n", "NaN | \n", "Earbuds Ear Buds Wired Earbud with Microphone ... | \n", "12.99 | \n", "5.0 | \n", "190 | \n", "https://www.amazon.com/Microphone-Isolating-He... | \n", "0.10000 | \n", "B07KSYMTMC | \n", "\n", " | \n", " |
27 | \n", "2018-12-23T15:30:47.913486 | \n", "2.7 | \n", "OVER EAR EARBUDS FOR SMALL EARS - The ear buds... | \n", "1.1 | \n", "5.6 | \n", "NaN | \n", "ROVKING Over Ear in Ear Noise Isolating Sweatp... | \n", "14.99 | \n", "4.0 | \n", "3809 | \n", "https://www.amazon.com/ROVKING-Isolating-Sweat... | \n", "0.09000 | \n", "B01H3CQ64Q | \n", "\n", " | \n", " |
28 | \n", "2018-12-23T15:30:53.591498 | \n", "1.0 | \n", "PREMIUM EARBUDS EARPHONES HEADPHONE: High perf... | \n", "3.3 | \n", "3.3 | \n", "NaN | \n", "Earbuds Ear Buds Sport Earbuds Running Earbuds... | \n", "9.99 | \n", "5.0 | \n", "347 | \n", "https://www.amazon.com/Headphones-Earphones-Mi... | \n", "0.06000 | \n", "B07KQ4XNDV | \n", "\n", " | \n", " |
29 | \n", "2018-12-23T15:31:00.600181 | \n", "3.9 | \n", "WIRELESS + WIRED: Enjoy the freedom of wireles... | \n", "1.4 | \n", "3.5 | \n", "NaN | \n", "Back Bay 2-in-1 Wireless & Wired Bluetooth Ear... | \n", "34.99 | \n", "4.2 | \n", "157 | \n", "https://www.amazon.com/Back-Bay-Sweatproof-Hea... | \n", "0.04000 | \n", "B0757WVSN8 | \n", "\n", " | \n", " |
30 | \n", "2018-12-23T15:31:07.409431 | \n", "1.2 | \n", "♫ HIGH-PERFORMANCE SOUND QUALITY: These earbud... | \n", "2.8 | \n", "3.0 | \n", "December 5, 2018 | \n", "Earbuds Ear Buds Stereo Earphones in-Ear Headp... | \n", "12.99 | \n", "5.0 | \n", "229 | \n", "https://www.amazon.com/Earphones-Headphones-Mi... | \n", "0.15000 | \n", "B07L5CRQMB | \n", "\n", " | \n", " |
31 | \n", "2018-12-23T15:31:14.871387 | \n", "1.7 | \n", "SUPER SOUND: These in ear headphones delivery ... | \n", "5.6 | \n", "5.6 | \n", "NaN | \n", "Senzer H2 In Ear Headphones with Mic Wired Ear... | \n", "18.99 | \n", "4.8 | \n", "12 | \n", "https://www.amazon.com/Headphones-Noise-Isolat... | \n", "0.50000 | \n", "B07JL1HZGD | \n", "\n", " | \n", " |
32 | \n", "2018-12-23T15:31:22.703555 | \n", "0.9 | \n", "\\r\\nBuilt in Microphone and Volume control for... | \n", "3.1 | \n", "7.0 | \n", "NaN | \n", "Betron B25 Noise Isolating in Ear Canal Headph... | \n", "15.99 | \n", "4.4 | \n", "191 | \n", "https://www.amazon.com/Betron-Isolating-Headph... | \n", "0.10000 | \n", "B079GFF4HZ | \n", "\n", " | \n", " |
33 | \n", "2018-12-23T15:31:31.195693 | \n", "1.0 | \n", "Active Noise Cancelling Functionality: Reduces... | \n", "1.0 | \n", "24.2 | \n", "NaN | \n", "TaoTronics Active Noise Cancelling Headphones,... | \n", "49.99 | \n", "4.2 | \n", "160 | \n", "https://www.amazon.com/dp/B07FM1L5HJ/ref=sxbs_... | \n", "0.05000 | \n", "B07FM1L5HJ | \n", "\n", " | \n", " |
34 | \n", "2018-12-23T15:31:52.956426 | \n", "6.8 | \n", "\\r\\nPOWERFUL SOUND - Deep base and clean trebl... | \n", "2.2 | \n", "1.4 | \n", "NaN | \n", "Black GUMY in Ear Earbuds with Stay fit Ear Ti... | \n", "0.00 | \n", "3.9 | \n", "55 | \n", "https://www.amazon.com/dp/B073R2RSB2/ref=sxbs_... | \n", "0.07000 | \n", "B073R2RSB2 | \n", "\n", " | \n", " |
35 | \n", "2018-12-23T15:32:02.984393 | \n", "0.7 | \n", "【Super Sound quality+ Bluetooth 4.1】Powerful m... | \n", "0.9 | \n", "33.0 | \n", "NaN | \n", "SoundPEATS Bluetooth Headphones Wireless Earbu... | \n", "0.00 | \n", "4.3 | \n", "356 | \n", "https://www.amazon.com/dp/B07KLV4P88/ref=sxbs_... | \n", "0.04000 | \n", "B07KLV4P88 | \n", "\n", " | \n", " |
36 | \n", "2018-12-23T15:32:10.933854 | \n", "2.8 | \n", "\\r\\nSNUG FIT AND STAY PUT IN YOUR EARS THROUGH... | \n", "1.2 | \n", "5.7 | \n", "NaN | \n", "ROVKING Wired Sweatproof Earhook in Ear Sport ... | \n", "12.99 | \n", "3.9 | \n", "2667 | \n", "https://www.amazon.com/dp/B017AW0GO0/ref=sxbs_... | \n", "0.08000 | \n", "B017AW0GO0 | \n", "\n", " | \n", " |
37 | \n", "2018-12-23T15:32:18.698721 | \n", "1.2 | \n", "[IPX6 SWEATPROOF] - Inner nano-coating protect... | \n", "0.8 | \n", "24.8 | \n", "NaN | \n", "SoundPEATS Magnetic Wireless Earbuds Bluetooth... | \n", "0.00 | \n", "4.5 | \n", "146 | \n", "https://www.amazon.com/dp/B07DFGP3XQ/ref=sxbs_... | \n", "0.33125 | \n", "B07DFGP3XQ | \n", "\n", " | \n", " |
\n", " | Created_Date | \n", "Depth | \n", "Description | \n", "Height | \n", "Length | \n", "Listed_Date | \n", "Name | \n", "Price | \n", "Rating | \n", "Review | \n", "URL | \n", "Weight | \n", "Product_ID | \n", "reviewmeta_rating | \n", "decision | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2018-12-23T15:27:04.224105 | \n", "1.0 | \n", "Lightweight in-ear stereo earphones provides n... | \n", "7.3 | \n", "3.9 | \n", "NaN | \n", "Betron ELR50 Earphones Earbuds Headphones, Bal... | \n", "10.99 | \n", "4.4 | \n", "827 | \n", "https://www.amazon.com/Betron-Earphones-Headph... | \n", "0.21000 | \n", "B01M8G5K8V | \n", "4.1 | \n", "Good | \n", "
1 | \n", "2018-12-23T15:27:11.659088 | \n", "2.4 | \n", "ACTIVE NOISE CANCELLING: Reduce background sou... | \n", "4.1 | \n", "5.5 | \n", "NaN | \n", "Active Noise Cancelling Earphones, RAVEtone Wi... | \n", "44.99 | \n", "4.4 | \n", "3 | \n", "https://www.amazon.com/Cancelling-Earphones-RA... | \n", "0.38750 | \n", "B07G7468KC | \n", "4.3 | \n", "Good | \n", "
2 | \n", "2018-12-23T15:27:21.007620 | \n", "0.5 | \n", "\\r\\nNATURAL SOUND QUALITY - Super BASS. 20Hz-2... | \n", "0.5 | \n", "0.9 | \n", "NaN | \n", "Earphones Cloudio J1 Noise Cancelling Earbuds ... | \n", "19.99 | \n", "0.0 | \n", "0 | \n", "https://www.amazon.com/Cloudio-J1-Cancelling-H... | \n", "0.03000 | \n", "B079196D5M | \n", "3.5 | \n", "Good | \n", "
3 | \n", "2018-12-23T15:27:36.456498 | \n", "6.8 | \n", "\\r\\nWired In-Ear Headphones: Perfect for exerc... | \n", "3.2 | \n", "3.6 | \n", "NaN | \n", "Panasonic ErgoFit In-Ear Earbud Headphones RP-... | \n", "8.98 | \n", "4.2 | \n", "55942 | \n", "https://www.amazon.com/Panasonic-Headphones-RP... | \n", "0.01000 | \n", "B003EM8008 | \n", "4.1 | \n", "Good | \n", "
4 | \n", "2018-12-23T15:27:46.926620 | \n", "6.8 | \n", "12mm dome type driver units deliver powerful d... | \n", "1.5 | \n", "2.6 | \n", "NaN | \n", "Sony MDRXB50AP Extra Bass Earbud Headset (Black) | \n", "29.99 | \n", "4.1 | \n", "3761 | \n", "https://www.amazon.com/Sony-MDRXB50AP-Extra-Ea... | \n", "0.15000 | \n", "B00JRD13T8 | \n", "4.1 | \n", "Good | \n", "
5 | \n", "2018-12-23T15:27:53.540138 | \n", "1.4 | \n", "ORIGINAL SOUND EXPERIENCES: Excellent stereo h... | \n", "3.5 | \n", "3.5 | \n", "December 20, 2018 | \n", "Earbuds Headphones Stereo in-Ear Earphones Noi... | \n", "12.99 | \n", "5.0 | \n", "162 | \n", "https://www.amazon.com/Headphones-Earphones-Is... | \n", "0.12000 | \n", "B07M935W8X | \n", "N/A | \n", "Fake | \n", "
6 | \n", "2018-12-23T15:28:03.556126 | \n", "1.0 | \n", "COMFORTABLE & SNUG FIT PERFECT FOR WORKOUTS: A... | \n", "1.4 | \n", "4.7 | \n", "NaN | \n", "Avantree Sports Headphones Wired with Micropho... | \n", "14.99 | \n", "4.4 | \n", "327 | \n", "https://www.amazon.com/Avantree-Headphones-Mic... | \n", "0.06000 | \n", "B078T9HFDJ | \n", "4.0 | \n", "Good | \n", "
7 | \n", "2018-12-23T15:28:17.838286 | \n", "8.8 | \n", "\\r\\nDeep, clear sound enhanced by exclusive Tr... | \n", "1.9 | \n", "4.9 | \n", "NaN | \n", "Bose SoundSport in-ear headphones for Samsung ... | \n", "69.99 | \n", "4.0 | \n", "1657 | \n", "https://www.amazon.com/Bose-SoundSport-headpho... | \n", "0.04000 | \n", "B0117RFPCC | \n", "4.0 | \n", "Good | \n", "
8 | \n", "2018-12-23T15:28:27.615538 | \n", "1.2 | \n", "DUAL DRIVER EARBUDS WITH INCREDIBLE SOUND - Ex... | \n", "6.6 | \n", "9.2 | \n", "NaN | \n", "Aiwa Prodigy-1 Premium Earphones - in-Ear Head... | \n", "29.99 | \n", "4.3 | \n", "102 | \n", "https://www.amazon.com/Aiwa-Prodigy-1-Premium-... | \n", "0.15000 | \n", "B07BF5F9LZ | \n", "4.5 | \n", "Good | \n", "
9 | \n", "2018-12-23T15:28:37.388027 | \n", "1.0 | \n", "Lightweight in-ear stereo earphones provides n... | \n", "7.3 | \n", "3.9 | \n", "NaN | \n", "Betron ELR50 Earphones Earbuds Headphones, Bal... | \n", "10.99 | \n", "4.4 | \n", "827 | \n", "https://www.amazon.com/Betron-Earphones-Headph... | \n", "0.21000 | \n", "B01M8G5K8V | \n", "4.1 | \n", "Good | \n", "
10 | \n", "2018-12-23T15:28:45.764686 | \n", "1.1 | \n", "Ergonomic ear bud design makes these earphones... | \n", "3.4 | \n", "3.4 | \n", "NaN | \n", "Earbuds, BYZ Wired Earphones Stereo in Ear Hea... | \n", "9.99 | \n", "5.0 | \n", "132 | \n", "https://www.amazon.com/Earbuds-BYZ-Earphones-H... | \n", "0.03000 | \n", "B07KR681VD | \n", "N/A | \n", "Fake | \n", "
11 | \n", "2018-12-23T15:28:52.915777 | \n", "0.5 | \n", "MAGNETIC FEATURE:The unique magnetic design of... | \n", "1.1 | \n", "1.5 | \n", "NaN | \n", "Wired Earbuds,COSPOR Magnetic in-Ear Stereo Ea... | \n", "15.99 | \n", "5.0 | \n", "44 | \n", "https://www.amazon.com/COSPOR-Magnetic-Earphon... | \n", "0.10000 | \n", "B07LD4SCLZ | \n", "N/A | \n", "Fake | \n", "
12 | \n", "2018-12-23T15:29:01.026100 | \n", "0.0 | \n", "\\r\\nFeel the power of extra bass. Connectivity... | \n", "0.0 | \n", "0.0 | \n", "NaN | \n", "Sony MDRXB510AS/B Extra Bass Wired Headphones,... | \n", "39.99 | \n", "3.9 | \n", "209 | \n", "https://www.amazon.com/Sony-MDRXB510AS-Headpho... | \n", "0.25000 | \n", "B01MTEU4V9 | \n", "3.8 | \n", "Good | \n", "
13 | \n", "2018-12-23T15:29:07.901205 | \n", "1.6 | \n", "♬ EXCEPTIONAL GUALITY OF SOUND - These workout... | \n", "4.3 | \n", "6.5 | \n", "December 4, 2018 | \n", "Running Headphones, LZHE in Ear Hi-Fi Monitor ... | \n", "21.99 | \n", "5.0 | \n", "142 | \n", "https://www.amazon.com/Headphones-LZHE-Isolati... | \n", "0.13000 | \n", "B07L4JJYRB | \n", "N/A | \n", "Fake | \n", "
14 | \n", "2018-12-23T15:29:15.853423 | \n", "0.4 | \n", "\\r\\nPremium audio: Ultra-lightweight, digital ... | \n", "2.2 | \n", "3.0 | \n", "NaN | \n", "Moxil Original 3.5MM Metal In-ear Wired Earpho... | \n", "15.99 | \n", "5.0 | \n", "482 | \n", "https://www.amazon.com/Moxil-Original-Earphone... | \n", "0.05000 | \n", "B07L65BKF9 | \n", "N/A | \n", "Fake | \n", "
15 | \n", "2018-12-23T15:29:23.338881 | \n", "2.0 | \n", "✔【DURABLE LONG LASTING LIFE EARBUDS】:This in e... | \n", "2.0 | \n", "7.0 | \n", "NaN | \n", "Earbuds Ear Buds in Ear Headphones Wired Earph... | \n", "11.99 | \n", "5.0 | \n", "572 | \n", "https://www.amazon.com/Headphones-Earphones-Mi... | \n", "0.04000 | \n", "B07L7XS26S | \n", "N/A | \n", "Fake | \n", "
16 | \n", "2018-12-23T15:29:31.544381 | \n", "1.0 | \n", "COMFORTABLE & SNUG FIT PERFECT FOR WORKOUTS: A... | \n", "1.4 | \n", "4.7 | \n", "NaN | \n", "Avantree Sports Headphones Wired with Micropho... | \n", "14.99 | \n", "4.4 | \n", "327 | \n", "https://www.amazon.com/Avantree-Headphones-Mic... | \n", "0.06000 | \n", "B078T9HFDJ | \n", "4.0 | \n", "Good | \n", "
17 | \n", "2018-12-23T15:29:38.766098 | \n", "1.2 | \n", "COMFORTABLE & SNUG FIT IN KIDS/WOMEN SMALL EAR... | \n", "2.7 | \n", "5.6 | \n", "NaN | \n", "Joysico Sports Headphones Wired Over Ear In-ea... | \n", "14.99 | \n", "4.1 | \n", "84 | \n", "https://www.amazon.com/Joysico-Headphones-Earp... | \n", "0.03000 | \n", "B0796S9CGR | \n", "4.6 | \n", "Good | \n", "
18 | \n", "2018-12-23T15:29:45.662395 | \n", "0.6 | \n", "【Enhanced Sound】Powerful 10mm composite driver... | \n", "1.8 | \n", "51.2 | \n", "NaN | \n", "Anker SoundBuds Verve Built-in Microphone in E... | \n", "15.99 | \n", "3.9 | \n", "105 | \n", "https://www.amazon.com/Anker-SoundBuds-Built-M... | \n", "0.02000 | \n", "B077XNCSQS | \n", "4.0 | \n", "Good | \n", "
19 | \n", "2018-12-23T15:29:52.215953 | \n", "1.7 | \n", "\\r\\nUniversal compatibility: Compatible with m... | \n", "3.1 | \n", "3.9 | \n", "December 14, 2018 | \n", "in-Ear Earbuds,COSPOR Wired Headphones Hands-F... | \n", "15.99 | \n", "5.0 | \n", "58 | \n", "https://www.amazon.com/COSPOR-Headphones-Hands... | \n", "0.04000 | \n", "B07LCRQVYW | \n", "N/A | \n", "Fake | \n", "
20 | \n", "2018-12-23T15:29:58.417132 | \n", "1.2 | \n", "EXECELLENT SOUND BLOCKS OUT EXTERIOR NOISE:Ear... | \n", "4.6 | \n", "5.1 | \n", "December 2, 2018 | \n", "Earbuds Headphones with Microphone Mic Noise I... | \n", "12.99 | \n", "5.0 | \n", "197 | \n", "https://www.amazon.com/Headphones-Microphone-I... | \n", "0.08000 | \n", "B07L2R9KFR | \n", "N/A | \n", "Fake | \n", "
21 | \n", "2018-12-23T15:30:05.561680 | \n", "1.4 | \n", "\\r\\nStereo and Crystal Clear Sound: Built-in h... | \n", "3.2 | \n", "3.2 | \n", "NaN | \n", "Earphones, USTEK in-Ear Wired Earbuds Stereo S... | \n", "10.99 | \n", "5.0 | \n", "135 | \n", "https://www.amazon.com/Earphones-USTEK-Headpho... | \n", "0.15000 | \n", "B07KFD5DFF | \n", "N/A | \n", "Fake | \n", "
22 | \n", "2018-12-23T15:30:12.229971 | \n", "1.3 | \n", "♬【DEEP BASS SOUND & NOISE ISOLATING】Perfect st... | \n", "3.1 | \n", "5.5 | \n", "NaN | \n", "Earbuds Ear Buds Earphones with Microphone Mic... | \n", "12.99 | \n", "5.0 | \n", "98 | \n", "https://www.amazon.com/Earphones-Microphone-He... | \n", "0.11000 | \n", "B07KWM3NZ1 | \n", "N/A | \n", "Fake | \n", "
23 | \n", "2018-12-23T15:30:20.604759 | \n", "1.2 | \n", "Hybrid sound system of symphonic drivers and b... | \n", "3.2 | \n", "5.3 | \n", "NaN | \n", "in Ear Headphones SDFLAYER E97 Pro Earphones w... | \n", "28.99 | \n", "5.0 | \n", "1965 | \n", "https://www.amazon.com/Ear-Headphones-SDFLAYER... | \n", "0.24000 | \n", "B07JZ6N979 | \n", "N/A | \n", "Fake | \n", "
24 | \n", "2018-12-23T15:30:28.461220 | \n", "0.2 | \n", "ACTIVE NOISE CANCELLING: Reduce background sou... | \n", "0.2 | \n", "0.2 | \n", "NaN | \n", "TaoTronics Active Noise Cancelling Headphones,... | \n", "43.99 | \n", "3.9 | \n", "360 | \n", "https://www.amazon.com/TaoTronics-Cancelling-H... | \n", "0.07000 | \n", "B075DBL2QP | \n", "3.9 | \n", "Good | \n", "
25 | \n", "2018-12-23T15:30:34.839770 | \n", "0.4 | \n", "✔【DURABLE LONG LASTING LIFE EARBUDS】:This in e... | \n", "3.2 | \n", "6.0 | \n", "NaN | \n", "KURSO Compatible for iPhone Samsung Android Ea... | \n", "11.99 | \n", "5.0 | \n", "332 | \n", "https://www.amazon.com/KURSO-Compatible-Headph... | \n", "0.03000 | \n", "B07J59RGH7 | \n", "N/A | \n", "Fake | \n", "
26 | \n", "2018-12-23T15:30:41.286558 | \n", "1.0 | \n", "✤Ultra Perfect Sound Quality - Perfect stereo ... | \n", "3.7 | \n", "3.8 | \n", "NaN | \n", "Earbuds Ear Buds Wired Earbud with Microphone ... | \n", "12.99 | \n", "5.0 | \n", "190 | \n", "https://www.amazon.com/Microphone-Isolating-He... | \n", "0.10000 | \n", "B07KSYMTMC | \n", "N/A | \n", "Fake | \n", "
27 | \n", "2018-12-23T15:30:47.913486 | \n", "2.7 | \n", "OVER EAR EARBUDS FOR SMALL EARS - The ear buds... | \n", "1.1 | \n", "5.6 | \n", "NaN | \n", "ROVKING Over Ear in Ear Noise Isolating Sweatp... | \n", "14.99 | \n", "4.0 | \n", "3809 | \n", "https://www.amazon.com/ROVKING-Isolating-Sweat... | \n", "0.09000 | \n", "B01H3CQ64Q | \n", "4.0 | \n", "Good | \n", "
28 | \n", "2018-12-23T15:30:53.591498 | \n", "1.0 | \n", "PREMIUM EARBUDS EARPHONES HEADPHONE: High perf... | \n", "3.3 | \n", "3.3 | \n", "NaN | \n", "Earbuds Ear Buds Sport Earbuds Running Earbuds... | \n", "9.99 | \n", "5.0 | \n", "347 | \n", "https://www.amazon.com/Headphones-Earphones-Mi... | \n", "0.06000 | \n", "B07KQ4XNDV | \n", "N/A | \n", "Fake | \n", "
29 | \n", "2018-12-23T15:31:00.600181 | \n", "3.9 | \n", "WIRELESS + WIRED: Enjoy the freedom of wireles... | \n", "1.4 | \n", "3.5 | \n", "NaN | \n", "Back Bay 2-in-1 Wireless & Wired Bluetooth Ear... | \n", "34.99 | \n", "4.2 | \n", "157 | \n", "https://www.amazon.com/Back-Bay-Sweatproof-Hea... | \n", "0.04000 | \n", "B0757WVSN8 | \n", "4.0 | \n", "Good | \n", "
30 | \n", "2018-12-23T15:31:07.409431 | \n", "1.2 | \n", "♫ HIGH-PERFORMANCE SOUND QUALITY: These earbud... | \n", "2.8 | \n", "3.0 | \n", "December 5, 2018 | \n", "Earbuds Ear Buds Stereo Earphones in-Ear Headp... | \n", "12.99 | \n", "5.0 | \n", "229 | \n", "https://www.amazon.com/Earphones-Headphones-Mi... | \n", "0.15000 | \n", "B07L5CRQMB | \n", "N/A | \n", "Fake | \n", "
31 | \n", "2018-12-23T15:31:14.871387 | \n", "1.7 | \n", "SUPER SOUND: These in ear headphones delivery ... | \n", "5.6 | \n", "5.6 | \n", "NaN | \n", "Senzer H2 In Ear Headphones with Mic Wired Ear... | \n", "18.99 | \n", "4.8 | \n", "12 | \n", "https://www.amazon.com/Headphones-Noise-Isolat... | \n", "0.50000 | \n", "B07JL1HZGD | \n", "4.8 | \n", "Good | \n", "
32 | \n", "2018-12-23T15:31:22.703555 | \n", "0.9 | \n", "\\r\\nBuilt in Microphone and Volume control for... | \n", "3.1 | \n", "7.0 | \n", "NaN | \n", "Betron B25 Noise Isolating in Ear Canal Headph... | \n", "15.99 | \n", "4.4 | \n", "191 | \n", "https://www.amazon.com/Betron-Isolating-Headph... | \n", "0.10000 | \n", "B079GFF4HZ | \n", "4.2 | \n", "Good | \n", "
33 | \n", "2018-12-23T15:31:31.195693 | \n", "1.0 | \n", "Active Noise Cancelling Functionality: Reduces... | \n", "1.0 | \n", "24.2 | \n", "NaN | \n", "TaoTronics Active Noise Cancelling Headphones,... | \n", "49.99 | \n", "4.2 | \n", "160 | \n", "https://www.amazon.com/dp/B07FM1L5HJ/ref=sxbs_... | \n", "0.05000 | \n", "B07FM1L5HJ | \n", "4.2 | \n", "Good | \n", "
34 | \n", "2018-12-23T15:31:52.956426 | \n", "6.8 | \n", "\\r\\nPOWERFUL SOUND - Deep base and clean trebl... | \n", "2.2 | \n", "1.4 | \n", "NaN | \n", "Black GUMY in Ear Earbuds with Stay fit Ear Ti... | \n", "0.00 | \n", "3.9 | \n", "55 | \n", "https://www.amazon.com/dp/B073R2RSB2/ref=sxbs_... | \n", "0.07000 | \n", "B073R2RSB2 | \n", "3.7 | \n", "Good | \n", "
35 | \n", "2018-12-23T15:32:02.984393 | \n", "0.7 | \n", "【Super Sound quality+ Bluetooth 4.1】Powerful m... | \n", "0.9 | \n", "33.0 | \n", "NaN | \n", "SoundPEATS Bluetooth Headphones Wireless Earbu... | \n", "0.00 | \n", "4.3 | \n", "356 | \n", "https://www.amazon.com/dp/B07KLV4P88/ref=sxbs_... | \n", "0.04000 | \n", "B07KLV4P88 | \n", "4.3 | \n", "Good | \n", "
36 | \n", "2018-12-23T15:32:10.933854 | \n", "2.8 | \n", "\\r\\nSNUG FIT AND STAY PUT IN YOUR EARS THROUGH... | \n", "1.2 | \n", "5.7 | \n", "NaN | \n", "ROVKING Wired Sweatproof Earhook in Ear Sport ... | \n", "12.99 | \n", "3.9 | \n", "2667 | \n", "https://www.amazon.com/dp/B017AW0GO0/ref=sxbs_... | \n", "0.08000 | \n", "B017AW0GO0 | \n", "3.9 | \n", "Good | \n", "
37 | \n", "2018-12-23T15:32:18.698721 | \n", "1.2 | \n", "[IPX6 SWEATPROOF] - Inner nano-coating protect... | \n", "0.8 | \n", "24.8 | \n", "NaN | \n", "SoundPEATS Magnetic Wireless Earbuds Bluetooth... | \n", "0.00 | \n", "4.5 | \n", "146 | \n", "https://www.amazon.com/dp/B07DFGP3XQ/ref=sxbs_... | \n", "0.33125 | \n", "B07DFGP3XQ | \n", "4.5 | \n", "Good | \n", "