Flipkart Smartphones Dataset

Smartphones available on E-commerce website Flipkart.com (26 Feb 2023)

@kaggle.dnyaneshyeole_flipkart_smartphones_dataset

Table List

1 table(36.03 KB)

Flipkart Smartphones

@kaggle.dnyaneshyeole_flipkart_smartphones_dataset.flipkart_smartphones

36.03 KB
836 rows
16 columns

brand Brand	model Model	colour Colour	original_price Original Price	discounted_price Discounted Price	ratings Ratings	rating_count Rating Count	reviews Reviews	memory Memory	storage Storage	processor Processor	rear_camera Rear Camera	front_camera Front Camera	display_size Display Size	battery_capacity Battery Capacity	battery_type Battery Type
VIVO	VIVO T1 44W	Starry Sky	19990	14499	4.5	87331	6044	4	128	Qualcomm Snapdragon 680	50MP + 2MP + 2MP	16MP	16.36	5000	Lithium
APPLE	APPLE IPHONE 11	White	48900	47199	4.6	184191	10818		128	A Bionic Chip	12MP + 12MP	12MP	15.49		nan
VIVO	VIVO T1 44W	Midnight Galaxy	20990	15999	4.4	51365	3750	6	128	Qualcomm Snapdragon 680	50MP + 2MP + 2MP	16MP	16.36	5000	Lithium
XIAOMI	POCO M4 5G	Power Black	15999	11999	4.2	53448	4185	4	64	Mediatek Dimensity 700	50MP + 2MP	8MP	16.71	5000	Lithium Polymer
XIAOMI	REDMI 10	Caribbean Green	14999	9299	4.3	187787	12084	4	64	Qualcomm Snapdragon 680	50MP + 2MP	5MP	17.02	6000	Lithium Polymer
XIAOMI	POCO M4 5G	Cool Blue	15999	11999	4.2	53448	4185	4	64	Mediatek Dimensity 700	50MP + 2MP	8MP	16.71	5000	Lithium Polymer
XIAOMI	POCO C31	Shadow Gray	11999	7499	4.3	202727	11672	4	64	MediaTek Helio G35	13MP + 2MP + 2MP	5MP	16.59	5000	Lithium
XIAOMI	POCO M4 5G	Yellow	15999	11999	4.2	53448	4185	4	64	Mediatek Dimensity 700	50MP + 2MP	8MP	16.71	5000	Lithium Polymer
XIAOMI	REDMI 10	Midnight Black	14999	9299	4.3	187787	12084	4	64	Qualcomm Snapdragon 680	50MP + 2MP	5MP	17.02	6000	Lithium Polymer
VIVO	VIVO T1 44W	Midnight Galaxy	23990	17999	4.3	5798	483	8	128	Qualcomm Snapdragon 680	50MP + 2MP + 2MP	16MP	16.36	5000	Lithium


CREATE TABLE flipkart_smartphones (
  "brand" VARCHAR,
  "model" VARCHAR,
  "colour" VARCHAR,
  "original_price" BIGINT,
  "discounted_price" BIGINT,
  "ratings" DOUBLE,
  "rating_count" BIGINT,
  "reviews" BIGINT,
  "memory" DOUBLE,
  "storage" DOUBLE,
  "processor" VARCHAR,
  "rear_camera" VARCHAR,
  "front_camera" VARCHAR,
  "display_size" DOUBLE,
  "battery_capacity" DOUBLE,
  "battery_type" VARCHAR
);