Smartphone Dataset

Unveiling the Comprehensive Specs and Features of Modern Smartphones

@kaggle.muzammilbaloch_smartphone_dataset

Table List

1 table(38.89 KB)

Smartphones

@kaggle.muzammilbaloch_smartphone_dataset.smartphones

38.89 KB
980 rows
22 columns

brand_name Brand Name	model Model	price Price	avg_rating Avg Rating	n_5g_or_not 5G Or Not	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	os Os	primary_camera_rear Primary Camera Rear	primary_camera_front Primary Camera Front	resolution_height Resolution Height	resolution_width Resolution Width
apple	Apple iPhone 11	38999	7.3		bionic	6	2.65	3110			4	64	6.1	60	2	ios	12	12	1792	828
apple	Apple iPhone 11 (128GB)	46999	7.5		bionic	6	2.65	3110			4	128	6.1	60	2	ios	12	12	1792	828
apple	Apple iPhone 11 Pro Max	109900	7.7		bionic	6	2.65	3500	1	18	4	64	6.5	60	3	ios	12	12	2688	1242
apple	Apple iPhone 12	51999	7.4	1	bionic	6	3.1				4	64	6.1	60	2	ios	12	12	2532	1170
apple	Apple iPhone 12 (128GB)	55999	7.5	1	bionic	6	3.1				4	128	6.1	60	2	ios	12	12	2532	1170
apple	Apple iPhone 12 (256GB)	67999	7.6	1	bionic	6	3.1				4	256	6.1	60	2	ios	12	12	2532	1170
apple	Apple iPhone 12 Mini	40999	7.4	1	bionic	6	3.1				4	64	5.4	60	2	ios	12	12	2340	1080
apple	Apple iPhone 12 Mini (128GB)	45999	7.5	1	bionic	6	3.1				4	128	5.4	60	2	ios	12	12	2340	1080
apple	Apple iPhone 12 Mini (256GB)	55999	7.5	1	bionic	6	3.1				4	256	5.4	60	2	ios	12	12	2340	1080
apple	Apple iPhone 12 Pro (256GB)	119900	8	1	bionic	6	3.1				6	256	6.1	60	3	ios	12	12	2532	1170


CREATE TABLE smartphones (
  "brand_name" VARCHAR,
  "model" VARCHAR,
  "price" BIGINT,
  "avg_rating" DOUBLE,
  "n_5g_or_not" BIGINT,
  "processor_brand" VARCHAR,
  "num_cores" DOUBLE,
  "processor_speed" DOUBLE,
  "battery_capacity" DOUBLE,
  "fast_charging_available" BIGINT,
  "fast_charging" DOUBLE,
  "ram_capacity" BIGINT,
  "internal_memory" BIGINT,
  "screen_size" DOUBLE,
  "refresh_rate" BIGINT,
  "num_rear_cameras" BIGINT,
  "os" VARCHAR,
  "primary_camera_rear" DOUBLE,
  "primary_camera_front" DOUBLE,
  "extended_memory_available" BIGINT,
  "resolution_height" BIGINT,
  "resolution_width" BIGINT
);