Phones 2024

A Comprehensive Collection of Phone Information

@kaggle.jakubkhalponiak_phones_2024

Table List

1 table(107.82 KB)

Processed Data2

@kaggle.jakubkhalponiak_phones_2024.processed_data2

107.82 KB
1708 rows
38 columns

phone_brand Phone Brand	phone_model Phone Model	store Store	price_usd Price Usd	storage Storage	ram Ram	launch_date Launch Date	dimensions Dimensions	weight Weight	display_type Display Type	display_size Display Size	display_resolution Display Resolution	os Os	nfc Nfc	usb Usb	battery Battery	features_sensors Features Sensors	colors Colors	video Video	chipset Chipset	cpu Cpu	gpu Gpu	year Year	ppi_density Ppi Density	quantile_10 Quantile 10	quantile_50 Quantile 50	quantile_90 Quantile 90	price_range Price Range	os_type Os Type	os_version Os Version	battery_size Battery Size	colors_available Colors Available	chip_company Chip Company	cpu_core Cpu Core	gpu_company Gpu Company	fingerprint Fingerprint	video_resolution Video Resolution
apple	Apple iPhone 16 Pro	Amazon DE	1357.55	256	8	Fri Sep 20 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	149.6 x 71.5 x 8.3 mm (5.89 x 2.81 x 0.33 in)	199	LTPO Super Retina XDR OLED, 120Hz, HDR10, Dolby Vision, 1000 nits (typ), 2000 nits (HBM)	6.3	1206 x 2622	iOS 18	1	USB Type-C 3.2 Gen 2, DisplayPort	3582	Face ID, accelerometer, gyro, proximity, compass, barometer	Black Titanium, White Titanium, Natural Titanium, Desert Titanium	4K@24/25/30/60/100/120fps, 1080p@25/30/60/120/240fps, 10-bit HDR, Dolby Vision HDR (up to 60fps), ProRes, 3D (spatial) video/audio, stereo sound rec.	Apple A18 Pro (3 nm)	Hexa-core (2x4.05 GHz + 4x2.42 GHz)	Apple GPU (6-core graphics)	Mon Jan 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	460	161.707	550.45	1375.35	medium price	iOS	18	Medium	4	Apple	Hexa-core	Apple	Face	4K
apple	Apple iPhone 16 Pro	Amazon DE	1492.55	512	8	Fri Sep 20 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	149.6 x 71.5 x 8.3 mm (5.89 x 2.81 x 0.33 in)	199	LTPO Super Retina XDR OLED, 120Hz, HDR10, Dolby Vision, 1000 nits (typ), 2000 nits (HBM)	6.3	1206 x 2622	iOS 18	1	USB Type-C 3.2 Gen 2, DisplayPort	3582	Face ID, accelerometer, gyro, proximity, compass, barometer	Black Titanium, White Titanium, Natural Titanium, Desert Titanium	4K@24/25/30/60/100/120fps, 1080p@25/30/60/120/240fps, 10-bit HDR, Dolby Vision HDR (up to 60fps), ProRes, 3D (spatial) video/audio, stereo sound rec.	Apple A18 Pro (3 nm)	Hexa-core (2x4.05 GHz + 4x2.42 GHz)	Apple GPU (6-core graphics)	Mon Jan 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	460	161.707	550.45	1375.35	high price	iOS	18	Medium	4	Apple	Hexa-core	Apple	Face	4K
apple	Apple iPhone 16 Pro	Amazon DE	1705.32	1000	8	Fri Sep 20 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	149.6 x 71.5 x 8.3 mm (5.89 x 2.81 x 0.33 in)	199	LTPO Super Retina XDR OLED, 120Hz, HDR10, Dolby Vision, 1000 nits (typ), 2000 nits (HBM)	6.3	1206 x 2622	iOS 18	1	USB Type-C 3.2 Gen 2, DisplayPort	3582	Face ID, accelerometer, gyro, proximity, compass, barometer	Black Titanium, White Titanium, Natural Titanium, Desert Titanium	4K@24/25/30/60/100/120fps, 1080p@25/30/60/120/240fps, 10-bit HDR, Dolby Vision HDR (up to 60fps), ProRes, 3D (spatial) video/audio, stereo sound rec.	Apple A18 Pro (3 nm)	Hexa-core (2x4.05 GHz + 4x2.42 GHz)	Apple GPU (6-core graphics)	Mon Jan 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	460	161.707	550.45	1375.35	high price	iOS	18	Medium	4	Apple	Hexa-core	Apple	Face	4K
apple	Apple iPhone 16 Pro Max	Amazon DE	1564.92	512	8	Fri Sep 20 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	163 x 77.6 x 8.3 mm (6.42 x 3.06 x 0.33 in)	227	LTPO Super Retina XDR OLED, 120Hz, HDR10, Dolby Vision, 1000 nits (typ), 2000 nits (HBM)	6.9	1320 x 2868	iOS 18	1	USB Type-C 3.2 Gen 2, DisplayPort	4685	Face ID, accelerometer, gyro, proximity, compass, barometer	Black Titanium, White Titanium, Natural Titanium, Desert Titanium	4K@24/25/30/60/100/120fps, 1080p@25/30/60/120/240fps, 10-bit HDR, Dolby Vision HDR (up to 60fps), ProRes, 3D (spatial) video/audio, stereo sound rec.	Apple A18 Pro (3 nm)	Hexa-core (2x4.05 GHz + 4x2.42 GHz)	Apple GPU (6-core graphics)	Mon Jan 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	460	161.707	550.45	1375.35	high price	iOS	18	Large	4	Apple	Hexa-core	Apple	Face	4K
apple	Apple iPhone 12 mini	Amazon DE	247.32	128	4	Fri Nov 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	131.5 x 64.2 x 7.4 mm (5.18 x 2.53 x 0.29 in)	135	Super Retina XDR OLED, HDR10, Dolby Vision, 625 nits (HBM), 1200 nits (peak)	5.4	1080 x 2340	iOS 14.1, upgradable to iOS 18	1	Lightning, USB 2.0	2227	Face ID, accelerometer, gyro, proximity, compass, barometer	Black, White, Red, Green, Blue, Purple	4K@24/30/60fps, 1080p@30/60/120/240fps, HDR, Dolby Vision HDR (up to 30fps), stereo sound rec.	Apple A14 Bionic (5 nm)	Hexa-core (2x3.1 GHz Firestorm + 4x1.8 GHz Icestorm)	Apple GPU (4-core graphics)	Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	476	100.8	196.81	491.512	medium price	iOS	14.1	Small	6	Apple	Hexa-core	Apple	Face	4K
apple	Apple iPhone 12 mini	Amazon DE	319.68	256	4	Fri Nov 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	131.5 x 64.2 x 7.4 mm (5.18 x 2.53 x 0.29 in)	135	Super Retina XDR OLED, HDR10, Dolby Vision, 625 nits (HBM), 1200 nits (peak)	5.4	1080 x 2340	iOS 14.1, upgradable to iOS 18	1	Lightning, USB 2.0	2227	Face ID, accelerometer, gyro, proximity, compass, barometer	Black, White, Red, Green, Blue, Purple	4K@24/30/60fps, 1080p@30/60/120/240fps, HDR, Dolby Vision HDR (up to 30fps), stereo sound rec.	Apple A14 Bionic (5 nm)	Hexa-core (2x3.1 GHz Firestorm + 4x1.8 GHz Icestorm)	Apple GPU (4-core graphics)	Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	476	100.8	196.81	491.512	medium price	iOS	14.1	Small	6	Apple	Hexa-core	Apple	Face	4K
apple	Apple iPhone 13 mini	Amazon DE	427.14	256	4	Fri Sep 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	131.5 x 64.2 x 7.7 mm (5.18 x 2.53 x 0.30 in)	141	Super Retina XDR OLED, HDR10, Dolby Vision, 800 nits (HBM), 1200 nits (peak)	5.4	1080 x 2340	iOS 15, upgradable to iOS 18	1	Lightning, USB 2.0	2438	Face ID, accelerometer, gyro, proximity, compass, barometer	Starlight, Midnight, Blue, Pink, Red, Green	4K@24/30/60fps, 1080p@30/60/120/240fps, HDR, Dolby Vision HDR (up to 60fps), stereo sound rec.	Apple A15 Bionic (5 nm)	Hexa-core (2x3.23 GHz Avalanche + 4x1.82 GHz Blizzard)	Apple GPU (4-core graphics)	Fri Jan 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	476	127.03	249.99	581.99	medium price	iOS	15	Small	6	Apple	Hexa-core	Apple	Face	4K
apple	Apple iPhone 13 mini	Amazon DE	467.64	512	4	Fri Sep 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	131.5 x 64.2 x 7.7 mm (5.18 x 2.53 x 0.30 in)	141	Super Retina XDR OLED, HDR10, Dolby Vision, 800 nits (HBM), 1200 nits (peak)	5.4	1080 x 2340	iOS 15, upgradable to iOS 18	1	Lightning, USB 2.0	2438	Face ID, accelerometer, gyro, proximity, compass, barometer	Starlight, Midnight, Blue, Pink, Red, Green	4K@24/30/60fps, 1080p@30/60/120/240fps, HDR, Dolby Vision HDR (up to 60fps), stereo sound rec.	Apple A15 Bionic (5 nm)	Hexa-core (2x3.23 GHz Avalanche + 4x1.82 GHz Blizzard)	Apple GPU (4-core graphics)	Fri Jan 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	476	127.03	249.99	581.99	medium price	iOS	15	Small	6	Apple	Hexa-core	Apple	Face	4K
apple	Apple iPhone XR	Amazon DE	213.85	128	3	Fri Oct 26 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	150.9 x 75.7 x 8.3 mm (5.94 x 2.98 x 0.33 in)	194	Liquid Retina IPS LCD, 625 nits (HBM)	6.1	828 x 1792	iOS 12, upgradable to iOS 18	1	Lightning, USB 2.0	2942	Face ID, accelerometer, gyro, proximity, compass, barometer	Black, Red, Yellow, Blue, Coral, White	4K@24/30/60fps, 1080p@30/60/120/240fps, HDR, stereo sound rec.	Apple A12 Bionic (7 nm)	Hexa-core (2x2.5 GHz Vortex + 4x1.6 GHz Tempest)	Apple GPU (4-core graphics)	Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	326	140.912	213.85	310.648	medium price	iOS	12	Small	6	Apple	Hexa-core	Apple	Face	4K
apple	Apple iPhone XR	Amazon DE	214.92	256	3	Fri Oct 26 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	150.9 x 75.7 x 8.3 mm (5.94 x 2.98 x 0.33 in)	194	Liquid Retina IPS LCD, 625 nits (HBM)	6.1	828 x 1792	iOS 12, upgradable to iOS 18	1	Lightning, USB 2.0	2942	Face ID, accelerometer, gyro, proximity, compass, barometer	Black, Red, Yellow, Blue, Coral, White	4K@24/30/60fps, 1080p@30/60/120/240fps, HDR, stereo sound rec.	Apple A12 Bionic (7 nm)	Hexa-core (2x2.5 GHz Vortex + 4x1.6 GHz Tempest)	Apple GPU (4-core graphics)	Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	326	140.912	213.85	310.648	medium price	iOS	12	Small	6	Apple	Hexa-core	Apple	Face	4K


CREATE TABLE processed_data2 (
  "phone_brand" VARCHAR,
  "phone_model" VARCHAR,
  "store" VARCHAR,
  "price_usd" DOUBLE,
  "storage" BIGINT,
  "ram" BIGINT,
  "launch_date" TIMESTAMP,
  "dimensions" VARCHAR,
  "weight" DOUBLE,
  "display_type" VARCHAR,
  "display_size" DOUBLE,
  "display_resolution" VARCHAR,
  "os" VARCHAR,
  "nfc" BIGINT,
  "usb" VARCHAR,
  "battery" BIGINT,
  "features_sensors" VARCHAR,
  "colors" VARCHAR,
  "video" VARCHAR,
  "chipset" VARCHAR,
  "cpu" VARCHAR,
  "gpu" VARCHAR,
  "year" TIMESTAMP,
  "foldable" BIGINT,
  "ppi_density" BIGINT,
  "quantile_10" DOUBLE,
  "quantile_50" DOUBLE,
  "quantile_90" DOUBLE,
  "price_range" VARCHAR,
  "os_type" VARCHAR,
  "os_version" VARCHAR,
  "battery_size" VARCHAR,
  "colors_available" BIGINT,
  "chip_company" VARCHAR,
  "cpu_core" VARCHAR,
  "gpu_company" VARCHAR,
  "fingerprint" VARCHAR,
  "video_resolution" VARCHAR
);