SmartPhone Data

The dataset "smartphone-uncleaned.csv" represents a collection.

@kaggle.willianoliveiragibin_smartphone_data

Table List

1 table(37.92 KB)

Smartphone Cleaned New

@kaggle.willianoliveiragibin_smartphone_data.smartphone_cleaned_new

37.92 KB
980 rows
20 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	resolution Resolution	num_rear_cameras Num Rear Cameras	os Os
oneplus	OnePlus 11 5G	54999	89	true	true		snapdragon	8	3.2	5000	1	100	12	256	6.7	120	1440 x 3216	3	android
oneplus	OnePlus Nord CE 2 Lite 5G	19989	81	true			snapdragon	8	2.2	5000	1	33	6	128	6.59	120	1080 x 2412	3	android
samsung	Samsung Galaxy A14 5G	16499	75	true			exynos	8	2.4	5000	1	15	4	64	6.6	90	1080 x 2408	3	android
motorola	Motorola Moto G62 5G	14999	81	true			snapdragon	8	2.2	5000	1		6	128	6.55	120	1080 x 2400	3	android
realme	Realme 10 Pro Plus	24999	82	true			dimensity	8	2.6	5000	1	67	6	128	6.7	120	1080 x 2412	3	android
samsung	Samsung Galaxy F23 5G (6GB RAM + 128GB)	16999	80	true	true		snapdragon	8	2.2	5000	1	25	6	128	6.6	120	1080 x 2408	3	android
apple	Apple iPhone 14	65999	81	true	true		bionic	6	3.22	3279	1		6	128	6.1	60	1170 x 2532	2	ios
xiaomi	Xiaomi Redmi Note 12 Pro Plus	29999	86	true		true	dimensity	8	2.6	4980	1	120	8	256	6.67	120	1080 x 2400	3	android
nothing	Nothing Phone 1	26749	85	true	true		snapdragon	8	2.5	4500	1	33	8	128	6.55	120	1080 x 2400	2	android
oneplus	OnePlus Nord 2T 5G	28999	84	true	true		dimensity	8	3	4500	1	80	8	128	6.43	90	1080 x 2400	3	android


CREATE TABLE smartphone_cleaned_new (
  "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,
  "resolution" VARCHAR,
  "num_rear_cameras" BIGINT,
  "os" VARCHAR
);