Another Ecommerce Scrape (Power Drill Prices)

Data on competing power drill prices on Amazon, Lowe's, Walmart, and Home Depot

@kaggle.erichschulman_another_ecommerce_scrape

Table List

1 table(584.65 KB)

Clean Prices

@kaggle.erichschulman_another_ecommerce_scrape.clean_prices

584.65 KB
20529 rows
38 columns

platform Platform	website Website	date Date	zipcode Zipcode	rank Rank	page Page	query Query	prod_id Prod Id	product Product	manufacturer Manufacturer	model Model	price Price	list_price List Price	in_stock In Stock	seller Seller	shipping Shipping	store_stock Store Stock	store_address Store Address	store_zip Store Zip	weight Weight	reviews Reviews	rating Rating	quantity1 Quantity1	quantity2 Quantity2	calc_rank Calc Rank	calc_inven Calc Inven	calc_promo Calc Promo	calc_ship Calc Ship
LOW	https://www.lowes.com/	1578772057082	78722	1	1	https://www.lowes.com/search?searchTerm=drills&sortMethod=sortBy_bestSellers	863707	10-Tool 20-Volt Power Tool Combo Kit with Soft Case (Charger Included and 2-Batteries Included)	DEWALT	DCK1020D2	499	849	1	nan	Available!	nan	S.E. Austin Lowes, 5510 South IH 35, Austin, TX	78722	37	170	4.8176	2		1	2	1	2
LOW	https://www.lowes.com/	1578772059904	78722	2	1	https://www.lowes.com/search?searchTerm=drills&sortMethod=sortBy_bestSellers	797362	20-Volt Max 1/2-in Brushless Cordless Drill (Charger Included)	DEWALT	DCD777C2	99	159	1	nan	Available!	nan	S.E. Austin Lowes, 5510 South IH 35, Austin, TX	78722	2.56	1118	4.7209	23		2	23	1	2
LOW	https://www.lowes.com/	1578772062054	78722	3	1	https://www.lowes.com/search?searchTerm=drills&sortMethod=sortBy_bestSellers	836487	1-in SDS-plus 8-Amp Keyless Rotary Hammer	Bosch	11255VSR-GWS8	259			nan	Currently unavailable	nan	S.E. Austin Lowes, 5510 South IH 35, Austin, TX	78722		15	4.5333			3			7
LOW	https://www.lowes.com/	1578772064069	78722	4	1	https://www.lowes.com/search?searchTerm=drills&sortMethod=sortBy_bestSellers	797394	2-Tool 20-Volt Max Brushless Power Tool Combo Kit with Soft Case (Charger Included and 2-Batteries Included)	DEWALT	DCK277C2	249.99		1	nan	Available!	nan	S.E. Austin Lowes, 5510 South IH 35, Austin, TX	78722	9.2	449	4.7996	26	1	4	26	1	2
LOW	https://www.lowes.com/	1578772065698	78722	5	1	https://www.lowes.com/search?searchTerm=drills&sortMethod=sortBy_bestSellers	779395	XR 2-Tool 20-Volt Max Brushless Power Tool Combo Kit with Soft Case (Charger Included and 2-Batteries Included)	DEWALT	DCK283D2	249	299	1	nan	Available!	nan	S.E. Austin Lowes, 5510 South IH 35, Austin, TX	78722	9.2	254	4.8819	6		5	6	1	2
LOW	https://www.lowes.com/	1578772067384	78722	6	1	https://www.lowes.com/search?searchTerm=drills&sortMethod=sortBy_bestSellers	254285	20-Volt Max Variable Speed Cordless Impact Driver (2-Battery)	DEWALT	DCF885C2	179			nan	Currently unavailable	nan	S.E. Austin Lowes, 5510 South IH 35, Austin, TX	78722	3.7	90	4.7778		1	6		1	7
LOW	https://www.lowes.com/	1578772069457	78722	7	1	https://www.lowes.com/search?searchTerm=drills&sortMethod=sortBy_bestSellers	1045308	V20 8-Tool 20-Volt Max Power Tool Combo Kit with Soft Case (Charger Included and 2-Batteries Included)	CRAFTSMAN	CMCK800D2	299	449	1	nan	Delivery available	nan	S.E. Austin Lowes, 5510 South IH 35, Austin, TX	78722	38.2	129	4.7054	1		7	1	1	7
LOW	https://www.lowes.com/	1578772071746	78722	8	1	https://www.lowes.com/search?searchTerm=drills&sortMethod=sortBy_bestSellers	1045301	V20 2-Tool 20-Volt Max Power Tool Combo Kit with Soft Case (Charger Included and 2-Batteries Included)	CRAFTSMAN	CMCK200C2	99	149	1	nan	Available!	nan	S.E. Austin Lowes, 5510 South IH 35, Austin, TX	78722	9.6	486	4.6584	3		8	3	1	2
LOW	https://www.lowes.com/	1578772073746	78722	9	1	https://www.lowes.com/search?searchTerm=drills&sortMethod=sortBy_bestSellers	672795	XR 20-Volt Max 1/2-in Drive Variable Brushless Cordless Impact Wrench (1-Battery Included and Charger Included)	DEWALT	DCF899M1	319		1	nan	Available!	nan	S.E. Austin Lowes, 5510 South IH 35, Austin, TX	78722	7.2	155	4.729	6		9	6		2
LOW	https://www.lowes.com/	1578772075621	78722	10	1	https://www.lowes.com/search?searchTerm=drills&sortMethod=sortBy_bestSellers	797361	6-Tool 20-Volt Max Power Tool Combo Kit with Soft Case (Charger Included and 2-Batteries Included)	DEWALT	DCK620D2	369	629		nan	nan	nan	S.E. Austin Lowes, 5510 South IH 35, Austin, TX	78722	28.5	161	4.764			10		1	7


CREATE TABLE clean_prices (
  "platform" VARCHAR,
  "website" VARCHAR,
  "date" BIGINT,
  "zipcode" BIGINT,
  "rank" DOUBLE,
  "page" DOUBLE,
  "query" VARCHAR,
  "prod_id" VARCHAR,
  "upc" DOUBLE,
  "product" VARCHAR,
  "manufacturer" VARCHAR,
  "model" VARCHAR,
  "price" DOUBLE,
  "list_price" DOUBLE,
  "in_stock" DOUBLE,
  "max_qty" DOUBLE,
  "seller" VARCHAR,
  "arrives" DOUBLE,
  "shipping" VARCHAR,
  "shipping_price" DOUBLE,
  "shipping_options" DOUBLE,
  "store_stock" VARCHAR,
  "store_address" VARCHAR,
  "store_zip" DOUBLE,
  "store_price" DOUBLE,
  "weight" DOUBLE,
  "reviews" DOUBLE,
  "rating" DOUBLE,
  "quantity1" DOUBLE,
  "quantity2" DOUBLE,
  "quantity3" DOUBLE,
  "quantity4" VARCHAR,
  "quantity5" VARCHAR,
  "ads" DOUBLE,
  "calc_rank" DOUBLE,
  "calc_inven" DOUBLE,
  "calc_promo" DOUBLE,
  "calc_ship" BIGINT
);