Mobile Phone Market In Ghana

Exploring Phone Models, Specifications, and Pricing in the Ghanaian Market

@kaggle.redpen12_mobile_phone_market_in_ghana

Table List

1 table(54.88 KB)

Mobile Phones

@kaggle.redpen12_mobile_phone_market_in_ghana.mobile_phones

54.88 KB
3600 rows
17 columns

brand Brand	model Model	sd_card Sd Card	main_camera Main Camera	resolution Resolution	display Display	sim_card Sim Card	os Os	color Color	region Region	location Location	screen_size_inch Screen Size(inch)	battery_mah Battery(mAh)	storage_gb Storage(GB)	ram_gb Ram(GB)	selfie_camera_mp Selfie Camera(MP)	price Price(¢)
Samsung	Galaxy S10	yes	3 Cameras: 12, 12, 16 MP	1440 x 3040	AMOLED	Single	Android	White	Greater Accra	Circle	6.1	3400	128	8	10	2450
Samsung	Galaxy Note 20 Ultra	yes	3 Cameras: 108, 12, 12 MP	1440 x 3088	AMOLED	Dual	Android	Bronze	Greater Accra	Circle	6.9	4500	128	12	10	5000
Samsung	Galaxy A54 5G	yes	3 Cameras: 50, 12, 5 MP	1080 x 2340	Super AMOLED	Dual	Android	Black	Greater Accra	Accra Metropolitan	6.4	5000	256	8	32	3000
Tecno	Camon 20 Pro	no	2 Cameras: 64, 2 MP	1080 x 2400	AMOLED	Dual	Android	Black	Greater Accra	Accra Metropolitan	6.67	5000	256	8	32	1900
Samsung	Galaxy S22 Ultra	no	4 Cameras: 108, 10, 10, 12 MP	1400 x 3088	AMOLED	Dual	Android	Black	Greater Accra	Accra Metropolitan	6.8	5000	512	12	40	5750
Samsung	Galaxy A73 5G	yes	4 Cameras: 108, 12, 5, 5 MP	1080 x 2400	Super AMOLED	Dual	Android	Black	Greater Accra	Accra Metropolitan	6.7	5000	256	8	32	2555
Samsung	Galaxy A54 5G	yes	3 Cameras: 50, 12, 5 MP	1080 x 2340	Super AMOLED	Dual	Android	Blue	Greater Accra	Accra Metropolitan	6.4	5000	256	8	32	2800
Samsung	Galaxy S23 Ultra	no	4 Cameras: 200, 10, 10, 12 MP	1440 x 3088	AMOLED	Dual	Android	Green	Greater Accra	Accra Metropolitan	6.8	5000	512	12	12	8480
Samsung	Galaxy A54 5G	yes	3 Cameras: 50, 12, 5 MP	1080 x 2340	Super AMOLED	Dual	Android	White	Greater Accra	Accra Metropolitan	6.4	5000	256	8	32	3710
Samsung	Galaxy A54 5G	yes	3 Cameras: 50, 12, 5 MP	1080 x 2340	Super AMOLED	Dual	Android	Black	Greater Accra	Accra Metropolitan	6.4	5000	256	8	32	3710


CREATE TABLE mobile_phones (
  "brand" VARCHAR,
  "model" VARCHAR,
  "sd_card" VARCHAR,
  "main_camera" VARCHAR,
  "resolution" VARCHAR,
  "display" VARCHAR,
  "sim_card" VARCHAR,
  "os" VARCHAR,
  "color" VARCHAR,
  "region" VARCHAR,
  "location" VARCHAR,
  "screen_size_inch" DOUBLE,
  "battery_mah" DOUBLE,
  "storage_gb" DOUBLE,
  "ram_gb" DOUBLE,
  "selfie_camera_mp" DOUBLE,
  "price" DOUBLE
);