Smartphones Dataset

Web Scraped Smartphones dataset

@kaggle.informrohit1_smartphones_dataset

Table List

1 table(45.01 KB)

Smartphones Cleaned V6

@kaggle.informrohit1_smartphones_dataset.smartphones_cleaned_v6

45.01 KB
980 rows
26 columns

brand_name Brand Name	model Model	price Price	rating Rating	has_5g Has 5g	has_nfc Has Nfc	has_ir_blaster Has Ir Blaster	processor_brand Processor Brand	num_cores Num Cores	processor_speed Processor Speed	battery_capacity Battery Capacity	fast_charging_available Fast Charging Available	fast_charging Fast Charging	ram_capacity Ram Capacity	internal_memory Internal Memory	screen_size Screen Size	refresh_rate Refresh Rate	num_rear_cameras Num Rear Cameras	num_front_cameras Num Front Cameras	os Os	primary_camera_rear Primary Camera Rear	primary_camera_front Primary Camera Front	extended_memory_available Extended Memory Available	extended_upto Extended Upto	resolution_width Resolution Width	resolution_height Resolution Height
oneplus	OnePlus 11 5G	54999	89	true	true		snapdragon	8	3.2	5000	1	100	12	256	6.7	120	3	1	android	50	16			1440	3216
oneplus	OnePlus Nord CE 2 Lite 5G	19989	81	true			snapdragon	8	2.2	5000	1	33	6	128	6.59	120	3	1	android	64	16	1	1024	1080	2412
samsung	Samsung Galaxy A14 5G	16499	75	true			exynos	8	2.4	5000	1	15	4	64	6.6	90	3	1	android	50	13	1	1024	1080	2408
motorola	Motorola Moto G62 5G	14999	81	true			snapdragon	8	2.2	5000	1		6	128	6.55	120	3	1	android	50	16	1	1024	1080	2400
realme	Realme 10 Pro Plus	24999	82	true			dimensity	8	2.6	5000	1	67	6	128	6.7	120	3	1	android	108	16			1080	2412
samsung	Samsung Galaxy F23 5G (6GB RAM + 128GB)	16999	80	true	true		snapdragon	8	2.2	5000	1	25	6	128	6.6	120	3	1	android	50	8	1	1024	1080	2408
apple	Apple iPhone 14	65999	81	true	true		bionic	6	3.22	3279	1		6	128	6.1	60	2	1	ios	12	12			1170	2532
xiaomi	Xiaomi Redmi Note 12 Pro Plus	29999	86	true		true	dimensity	8	2.6	4980	1	120	8	256	6.67	120	3	1	android	200	16			1080	2400
nothing	Nothing Phone 1	26749	85	true	true		snapdragon	8	2.5	4500	1	33	8	128	6.55	120	2	1	android	50	16			1080	2400
oneplus	OnePlus Nord 2T 5G	28999	84	true	true		dimensity	8	3	4500	1	80	8	128	6.43	90	3	1	android	50	32			1080	2400


CREATE TABLE smartphones_cleaned_v6 (
  "brand_name" VARCHAR,
  "model" VARCHAR,
  "price" BIGINT,
  "rating" DOUBLE,
  "has_5g" BOOLEAN,
  "has_nfc" BOOLEAN,
  "has_ir_blaster" BOOLEAN,
  "processor_brand" VARCHAR,
  "num_cores" DOUBLE,
  "processor_speed" DOUBLE,
  "battery_capacity" DOUBLE,
  "fast_charging_available" BIGINT,
  "fast_charging" DOUBLE,
  "ram_capacity" DOUBLE,
  "internal_memory" DOUBLE,
  "screen_size" DOUBLE,
  "refresh_rate" BIGINT,
  "num_rear_cameras" BIGINT,
  "num_front_cameras" DOUBLE,
  "os" VARCHAR,
  "primary_camera_rear" DOUBLE,
  "primary_camera_front" DOUBLE,
  "extended_memory_available" BIGINT,
  "extended_upto" DOUBLE,
  "resolution_width" BIGINT,
  "resolution_height" BIGINT
);