Apple IPhone Data

The database of Apple phones sold in India in a cleaned CSV file

@kaggle.komalkhetlani_apple_iphone_data

Table List

1 table(13.09 KB)

Apple Products

@kaggle.komalkhetlani_apple_iphone_data.apple_products

13.09 KB
62 rows
11 columns

product_name Product Name	product_url Product URL	brand Brand	sale_price Sale Price	mrp Mrp	discount_percentage Discount Percentage	number_of_ratings Number Of Ratings	number_of_reviews Number Of Reviews	upc Upc	star_rating Star Rating	ram Ram
APPLE iPhone 8 Plus (Gold, 64 GB)	https://www.flipkart.com/apple-iphone-8-plus-gold-64-gb/p/itmexrgvuzgzttzh?pid=MOBEXRGV7EHHTGUH	Apple	49900	49900		3431	356	MOBEXRGV7EHHTGUH	4.6	2 GB
APPLE iPhone 8 Plus (Space Grey, 256 GB)	https://www.flipkart.com/apple-iphone-8-plus-space-grey-256-gb/p/itmexrgvzkbyqgtf?pid=MOBEXRGVAC6TJT4F	Apple	84900	84900		3431	356	MOBEXRGVAC6TJT4F	4.6	2 GB
APPLE iPhone 8 Plus (Silver, 256 GB)	https://www.flipkart.com/apple-iphone-8-plus-silver-256-gb/p/itmexrgvxatuyrqw?pid=MOBEXRGVGETABXWZ	Apple	84900	84900		3431	356	MOBEXRGVGETABXWZ	4.6	2 GB
APPLE iPhone 8 (Silver, 256 GB)	https://www.flipkart.com/apple-iphone-8-silver-256-gb/p/itmexrgvae48gzhp?pid=MOBEXRGVMZWUHCBA	Apple	77000	77000		11202	794	MOBEXRGVMZWUHCBA	4.5	2 GB
APPLE iPhone 8 (Gold, 256 GB)	https://www.flipkart.com/apple-iphone-8-gold-256-gb/p/itmexrgv8bvfbzgw?pid=MOBEXRGVPK7PFEJZ	Apple	77000	77000		11202	794	MOBEXRGVPK7PFEJZ	4.5	2 GB
APPLE iPhone 8 Plus (Silver, 64 GB)	https://www.flipkart.com/apple-iphone-8-plus-silver-64-gb/p/itmexrgv7yfjbryy?pid=MOBEXRGVQGYYP8FV	Apple	49900	49900		3431	356	MOBEXRGVQGYYP8FV	4.6	2 GB
APPLE iPhone 8 Plus (Space Grey, 64 GB)	https://www.flipkart.com/apple-iphone-8-plus-space-grey-64-gb/p/itmexrgvehtzhh9v?pid=MOBEXRGVQKBREZP8	Apple	49900	49900		3431	356	MOBEXRGVQKBREZP8	4.6	2 GB
APPLE iPhone 8 (Space Grey, 256 GB)	https://www.flipkart.com/apple-iphone-8-space-grey-256-gb/p/itmexrgvypzqw6df?pid=MOBEXRGVZFZGZEWV	Apple	77000	77000		11202	794	MOBEXRGVZFZGZEWV	4.5	2 GB
APPLE iPhone XS Max (Silver, 64 GB)	https://www.flipkart.com/apple-iphone-xs-max-silver-64-gb/p/itmf944ehzsh7emx?pid=MOBF944E2XAHW8V5	Apple	89900	89900		1454	149	MOBF944E2XAHW8V5	4.6	4 GB
Apple iPhone XR ((PRODUCT)RED, 128 GB) (Includes EarPods, Power Adapter)	https://www.flipkart.com/apple-iphone-xr-product-red-128-gb-includes-earpods-power-adapter/p/itmf9z7zbkvjzegf?pid=MOBF9Z7ZHQC23PWQ	Apple	41999	52900	20	79512	6796	MOBF9Z7ZHQC23PWQ	4.6	4 GB


CREATE TABLE apple_products (
  "product_name" VARCHAR,
  "product_url" VARCHAR,
  "brand" VARCHAR,
  "sale_price" BIGINT,
  "mrp" BIGINT,
  "discount_percentage" BIGINT,
  "number_of_ratings" BIGINT,
  "number_of_reviews" BIGINT,
  "upc" VARCHAR,
  "star_rating" DOUBLE,
  "ram" VARCHAR
);