GSMArena Phone Dataset

8000+ phones specifications scraped from GSMArena Website

@kaggle.arwinneil_gsmarena_phone_dataset

Table List

1 table(714.61 KB)

Phone Dataset

@kaggle.arwinneil_gsmarena_phone_dataset.phone_dataset

714.61 KB
8628 rows
40 columns

brand Brand	model Model	network_technology Network Technology	n_2g_bands 2G Bands	n_3g_bands 3G Bands	n_4g_bands 4G Bands	network_speed Network Speed	gprs GPRS	edge EDGE	announced Announced	status Status	dimentions Dimentions	weight_g Weight G	weight_oz Weight Oz	sim SIM	display_type Display Type	display_resolution Display Resolution	display_size Display Size	os OS	cpu CPU	chipset Chipset	gpu GPU	memory_card Memory Card	internal_memory Internal Memory	ram RAM	primary_camera Primary Camera	secondary_camera Secondary Camera	loud_speaker Loud Speaker	audio_jack Audio Jack	wlan WLAN	bluetooth Bluetooth	gps GPS	nfc NFC	radio Radio	usb USB	sensors Sensors	battery Battery	colors Colors	approx_price_eur Approx Price EUR	img_url Img Url
Acer	Iconia Talk S	GSM / HSPA / LTE	GSM 850 / 900 / 1800 / 1900 - SIM 1 & SIM 2	HSDPA 850 / 1900 / 2100	LTE band 1(2100)\| 3(1800)\| 7(2600)\| 8(900)\| 20(800)	HSPA 42.2/11.5 Mbps LTE Cat4 150/50 Mbps	Yes	Yes	2016 August	Available. Released 2016 October	191.7 x 101 x 9.4 mm (7.55 x 3.98 x 0.37 in)	260	9.17	Dual SIM (Micro-SIM/Nano-SIM)	IPS LCD capacitive touchscreen 16M colors	7.0 inches (~69.8% screen-to-body ratio)	720 x 1280 pixels (~210 ppi pixel density)	Android 6.0 (Marshmallow)	Quad-core 1.3 GHz Cortex-A53	Mediatek MT8735	Mali-T720MP2	microSD up to 128 GB (dedicated slot)	16/32 GB	2 GB RAM	13 MP\| autofocus	2 MP\| 720p	Yes	Yes	Wi-Fi 802.11 a/b/g/n\| Wi-Fi Direct\| hotspot	4.0\| A2DP	Yes with A-GPS GLONASS	nan	FM radio	microUSB 2.0	Accelerometer\| proximity	Non-removable Li-Ion 3400 mAh battery (12.92 Wh)	Black	170	http://cdn2.gsmarena.com/vv/bigpic/acer-iconia-talk-s.jpg
Acer	Liquid Z6 Plus	GSM / HSPA / LTE	GSM 850 / 900 / 1800 / 1900 - SIM 1 & SIM 2 (dual-SIM model only)	HSDPA	LTE	HSPA 42.2/5.76 Mbps LTE Cat4 150/50 Mbps	Yes	Yes	2016 August	Available. Released 2016 December	153.8 x 75.6 x 8.5 mm (6.06 x 2.98 x 0.33 in)	169	5.96	Single SIM (Micro-SIM) or Dual SIM (Micro-SIM\| dual stand-by)	IPS LCD capacitive touchscreen 16M colors	5.5 inches (~71.7% screen-to-body ratio)	1080 x 1920 pixels (~401 ppi pixel density)	Android 6.0 (Marshmallow)	Octa-core 1.3 GHz Cortex-A53	Mediatek MT6753	Mali-T720MP3	microSD up to 256 GB (uses SIM 2 slot)	32 GB	3 GB RAM	13 MP\| autofocus\| LED flash	5 MP	Yes	Yes	Wi-Fi 802.11 b/g/n\| Wi-Fi Direct\| hotspot	4.0\| A2DP	Yes with A-GPS	nan	FM radio	microUSB 2.0	Fingerprint (front-mounted)\| accelerometer\| proximity	Removable Li-Po 4080 mAh battery	Black\| White	250	http://cdn2.gsmarena.com/vv/bigpic/acer-liquid-z6-plus.jpg
Acer	Liquid Z6	GSM / HSPA / LTE	GSM 850 / 900 / 1800 / 1900 - SIM 1 & SIM 2 (dual-SIM model only)	HSDPA	LTE	HSPA LTE	Yes	Yes	2016 August	Available. Released 2016 December	-	nan	nan	Single SIM (Micro-SIM) or Dual SIM (Micro-SIM\| dual stand-by)	IPS LCD capacitive touchscreen 16M colors	5.0 inches	720 x 1280 pixels (~294 ppi pixel density)	Android 6.0 (Marshmallow)	Quad-core 1.25 GHz Cortex-A53	Mediatek MT6737	Mali-T720MP2	microSD up to 256 GB	8 GB	1 GB RAM	8 MP\| autofocus\| LED flash	2 MP	Yes	Yes	Yes	Yes	Yes with A-GPS	nan	FM radio	microUSB 2.0	Accelerometer\| proximity	Removable Li-Ion 2000 mAh battery	Black\| White	120	http://cdn2.gsmarena.com/vv/bigpic/acer-liquid-z6.jpg
Acer	Iconia Tab 10 A3-A40	No cellular connectivity	N/A	nan	nan	nan	No	No	2016 April	Available. Released 2016 June	259 x 167 x 8.9 mm (10.20 x 6.57 x 0.35 in)	nan	nan	No	IPS LCD capacitive touchscreen 16M colors	10.1 inches (~68.4% screen-to-body ratio)	1920 x 1200 pixels (~224 ppi pixel density)	Android 6.0 (Marshmallow)	Quad-core 1.3 GHz Cortex-A53	Mediatek MT8163A	Mali-T720 MP2	microSD up to 256 GB (dedicated slot)	16/32/64 GB	2 GB RAM	5 MP	2 MP	Yes with stereo speakers (4 speakers)	Yes	Wi-Fi 802.11 a/b/g/n/ac\| dual-band\| hotspot	Yes	nan	nan	No	microUSB 2.0	Accelerometer	Non-removable Li-Ion battery	Black	230	http://cdn2.gsmarena.com/vv/bigpic/acer-iconia-tab-10-a3-a40.jpg
Acer	Liquid X2	GSM / HSPA / LTE	GSM 850 / 900 / 1800 / 1900	HSDPA 900 / 1900 / 2100 - Europe\| Taiwan	LTE 800 / 1800 / 2100 / 2600 - Europe	HSPA 42.2/5.76 Mbps LTE Cat4 150/50 Mbps	Yes	Yes	2015 April	Available. Released 2016 February	153.3 x 78.8 x 8.5 mm (6.04 x 3.10 x 0.33 in)	166	5.86	Triple SIM (Micro-SIM)	IPS LCD capacitive touchscreen 16M colors	5.5 inches (~69.0% screen-to-body ratio)	720 x 1280 pixels (~267 ppi pixel density)	Android 5.1 (Lollipop)	Octa-core 1.3 GHz Cortex-A53	Mediatek MT6753	Mali-T720MP4	microSD up to 32 GB (dedicated slot)	32 GB	3 GB RAM	13 MP\| f/1.8\| autofocus\| LED flash\|	13 MP\| f/1.8\| autofocus\| LED flash	Yes	Yes	Wi-Fi 802.11 b/g/n\| hotspot	4.0\| A2DP\| LE	Yes with A-GPS	nan	FM radio	microUSB 2.0	Accelerometer\| proximity\| compass	Removable Li-Po 4020 mAh battery	Black\| Gold	230	http://cdn2.gsmarena.com/vv/bigpic/acer-liquid-x2-1.jpg
Acer	Liquid Jade 2	GSM / HSPA / LTE	GSM 850 / 900 / 1800 / 1900 - SIM 1 & SIM 2	HSDPA 900 / 2100	LTE	HSPA 42.2/5.76 Mbps LTE Cat4 150/50 Mbps	Yes	Yes	2016 February	Available	-	nan	nan	Dual SIM (Nano-SIM\| dual stand-by)	Super AMOLED capacitive touchscreen 16M colors	5.5 inches	1080 x 1920 pixels (~401 ppi pixel density)	Android 6.0 (Marshmallow)	Hexa-core (4x1.4 GHz Cortex-A53 & 2x1.8 GHz Cortex-A57)	Qualcomm MSM8992 Snapdragon 808	nan	microSD up to 256 GB	32 GB	3 GB RAM	21 MP\| autofocus\| dual-LED flash	8 MP	Yes	Yes	Wi-Fi 802.11 a/b/g/n/ac\| dual-band\| Wi-Fi Direct\| hotspot	4.0\| A2DP\| LE	Yes with A-GPS	nan	FM radio	microUSB 2.0	Accelerometer\| gyro\| proximity\| compass	nan	Black		http://cdn2.gsmarena.com/vv/bigpic/acer-liquid-jade-2.jpg
Acer	Liquid Zest Plus	GSM / HSPA / LTE	GSM 850 / 900 / 1800 / 1900 - SIM 1 & SIM 2 (dual-SIM model only)	HSDPA	LTE	HSPA LTE	Yes	Yes	2016 April	Available. Released 2016 July	154 x 77 x 10 mm (6.06 x 3.03 x 0.39 in)	nan	nan	Single SIM (Micro-SIM) or Dual SIM (Micro-SIM\| dual stand-by)	IPS LCD capacitive touchscreen 16M colors	5.5 inches (~70.3% screen-to-body ratio)	720 x 1280 pixels (~267 ppi pixel density)	Android 6.0 (Marshmallow)	Quad-core 1.3 GHz Cortex-A53	Mediatek MT6735	Mali-T720MP2	microSD (dedicated slot)	16 GB	2 GB RAM	13 MP\| phase detection/laser autofocus\| LED flash	5 MP	Yes	Yes	Yes	Yes	Yes with A-GPS	nan	FM radio	microUSB 2.0	Accelerometer\| proximity\| compass	Non-removable Li-Ion 5000 mAh battery	Blue\| White	200	http://cdn2.gsmarena.com/vv/bigpic/acer-liquid-zest-plus-z628.jpg
Acer	Liquid Zest	GSM / HSPA / LTE	GSM 850 / 900 / 1800 / 1900 - SIM 1 & SIM 2 (dual-SIM model only)	HSDPA 850 / 900 / 1900 / 2100	LTE	HSPA LTE Cat4 150/50 Mbps	Yes	Yes	2016 February	Available. Released 2016 April	145.7 x 71.2 x 8.4 mm (5.74 x 2.80 x 0.33 in)	125	4.41	Single SIM (Micro-SIM) or Dual SIM (Micro-SIM\| dual stand-by)	IPS LCD capacitive touchscreen 16M colors	5.0 inches (~66.4% screen-to-body ratio)	720 x 1280 pixels (~294 ppi pixel density)	Android 6.0 (Marshmallow)	Quad-core 1.3 GHz - Z525	Mediatek MT6580 - Z525	Mali-400MP2 - Z525	microSD up to 32 GB (dedicated slot)	8 GB	1 GB RAM	8 MP\| f/2.0\| autofocus\| LED flash	5 MP	Yes	Yes	Yes	4.0\| A2DP	Yes with A-GPS	nan	FM radio	microUSB 2.0	Accelerometer\| proximity\| compass	Removable Li-Ion 2000 mAh battery	Black\| White	110	http://cdn2.gsmarena.com/vv/bigpic/acer-zest.jpg
Acer	Predator 8	No cellular connectivity	N/A	nan	nan	nan	No	No	2015 September	Available. Released 2015 November	217.9 x 127 x 8.6 mm (8.58 x 5.0 x 0.34 in)	353.8	12.49	No	IPS LCD capacitive touchscreen 16M colors	8.0 inches (~67.1% screen-to-body ratio)	1920 x 1200 pixels (~283 ppi pixel density)	Android 5.0 (Lollipop)	Quad-core 1.6 GHz	Intel Atom x7-Z8700	nan	microSD up to 256 GB (dedicated slot)	32/64 GB	2 GB RAM	5 MP	2 MP	Yes with stereo speakers (4 speakers)	Yes	Wi-Fi 802.11 a/b/g/n	4.0\| A2DP\| LE	nan	nan	No	microUSB 2.0	Yes	Non-removable Li-Po 4420 mAh battery	Black/Silver	350	http://cdn2.gsmarena.com/vv/bigpic/acer-predator-8.jpg
Acer	Liquid Jade Primo	GSM / HSPA / LTE	GSM 850 / 900 / 1800 / 1900 - SIM 1 & SIM 2	HSDPA 850 / 900 / 1900 / 2100 - Europe/ Taiwan	LTE 800 / 1800 / 2100 / 2600 - Europe	HSPA 42.2/5.76 Mbps LTE-A (2CA) Cat6 300/50 Mbps	Yes	Yes	2015 September	Available. Released 2016 April	156.5 x 75.9 x 8.4 mm (6.16 x 2.99 x 0.33 in)	150	5.29	Dual SIM (Nano-SIM\| dual stand-by)	AMOLED capacitive touchscreen 16M colors	5.5 inches (~70.2% screen-to-body ratio)	1080 x 1920 pixels (~401 ppi pixel density)	Microsoft Windows 10	Hexa-core (4x1.4 GHz Cortex-A53 & 2x1.8 GHz Cortex-A57)	Qualcomm MSM8992 Snapdragon 808	Adreno 418	microSD up to 256 GB (uses SIM 2 slot)	32 GB	3 GB RAM	21 MP\| f/2.2\| autofocus\| dual-LED flash\|	8 MP\| f/2.2\| 1080p@30fps	Yes	Yes	Wi-Fi 802.11 a/b/g/n/ac\| dual-band\| WiFi Direct\| hotspot	4.0\| A2DP\| LE\| EDR	Yes with A-GPS	nan	FM radio	3.1\| Type-C 1.0 reversible connector	Accelerometer\| gyro\| proximity\| compass	Non-removable Li-Po 2870 mAh battery	Black	220	http://cdn2.gsmarena.com/vv/bigpic/acer-liquid-jade-primo-.jpg


CREATE TABLE phone_dataset (
  "brand" VARCHAR,
  "model" VARCHAR,
  "network_technology" VARCHAR,
  "n_2g_bands" VARCHAR,
  "n_3g_bands" VARCHAR,
  "n_4g_bands" VARCHAR,
  "network_speed" VARCHAR,
  "gprs" VARCHAR,
  "edge" VARCHAR,
  "announced" VARCHAR,
  "status" VARCHAR,
  "dimentions" VARCHAR,
  "weight_g" VARCHAR,
  "weight_oz" VARCHAR,
  "sim" VARCHAR,
  "display_type" VARCHAR,
  "display_resolution" VARCHAR,
  "display_size" VARCHAR,
  "os" VARCHAR,
  "cpu" VARCHAR,
  "chipset" VARCHAR,
  "gpu" VARCHAR,
  "memory_card" VARCHAR,
  "internal_memory" VARCHAR,
  "ram" VARCHAR,
  "primary_camera" VARCHAR,
  "secondary_camera" VARCHAR,
  "loud_speaker" VARCHAR,
  "audio_jack" VARCHAR,
  "wlan" VARCHAR,
  "bluetooth" VARCHAR,
  "gps" VARCHAR,
  "nfc" VARCHAR,
  "radio" VARCHAR,
  "usb" VARCHAR,
  "sensors" VARCHAR,
  "battery" VARCHAR,
  "colors" VARCHAR,
  "approx_price_eur" DOUBLE,
  "img_url" VARCHAR
);