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
Data on competing power drill prices on Amazon, Lowe's, Walmart, and Home Depot
@kaggle.erichschulman_another_ecommerce_scrape
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
);
Anyone who has the link will be able to view this.