Historical Mobile Phone Data

Columns

• Brand: The manufacturer's brand name (e.g., Samsung, LG). There are 113 unique brands, with Samsung being the most common (11%).
• Model: The specific model name of the smartphone. There are 4432 unique model names.
• OS: The operating system installed (e.g., Android 6.0 Marshmallow, Android 5.1 Lollipop). There are 149 unique OS versions, with 18 missing values.
• Release_Date: The date the smartphone was released, ranging from 1 January 2003 to 18 August 2022. Note that 48% of these values are missing.
• Battery: The battery capacity measured in mAh, ranging from 500 mAh to 8580 mAh. The mean capacity is 2.42k mAh.
• Processor: The name of the central processing unit (e.g., MediaTek). Approximately 32% of processor information is missing.
• Memory: The RAM (Random Access Memory) in GB, ranging from 0.02 GB to 32 GB. The mean memory is 2.02 GB, with 10% of values missing.
• Primary_Storage: The internal primary storage in GB, ranging from 0 GB to 512 GB. The mean storage is 34.1 GB, with 16% of values missing.
• External_Storage: Indicates support for external storage, such as microSDHC (47%) or microSDXC (32%). NULL denotes no support.
• Display_Size: The display size in inches, ranging from 1.8 inches to 10.1 inches. The mean display size is 4.73 inches.
• Display_Resolution: The display resolution in pixels (e.g., 1280 x 720, 800 x 480). There are 152 unique resolutions.
• Display_Refresh_Rate: The display refresh rate in Hz, ranging from 60 Hz to 165 Hz. This column has a notable number of missing values (93%).
• Primary_Camera: The rear or primary camera capacity in megapixels (MP), ranging from 0 MP to 108 MP. The mean primary camera capacity is 11.7 MP.
• Front_Camera: The front or secondary camera capacity in megapixels (MP), ranging from 0.3 MP to 60 MP. Approximately 27% of front camera information is missing.

Distribution

Usage

• Data Analytics: Performing in-depth analysis of smartphone specifications and trends.
• Time Series Analysis: Examining how smartphone features have evolved over the 20-year period.
• Market Research: Understanding historical market shifts and feature adoption.
• Product Development: Informing future smartphone design and feature considerations.
• Academic Research: Supporting studies on technology adoption and innovation.

Coverage

• Geographic Scope: Not specified in the provided data.
• Time Range: Covers a period of 20 years, specifically from 1 January 2003 to 18 August 2022.
• Demographic Scope: Not specified.
• Data Availability Notes: Several columns have missing values, notably Release_Date (48% missing), Processor (32% missing), Display_Refresh_Rate (93% missing), and Front_Camera (27% missing).

License

Who Can Use It

• Business Analysts: For market trend analysis and strategic planning.
• Data Scientists and Analysts: For developing predictive models and data visualisations.
• Students and Researchers: For academic projects related to technology, data science, and consumer electronics.
• Technology Enthusiasts: For exploring the history and evolution of smartphones.

Dataset Name Suggestions

• Smartphone Evolution: 20-Year Specifications
• Historical Mobile Phone Data
• Global Smartphone Specifications Archive
• Smartphone Technology Trends (2003-2022)
• Mobile Device Feature Timeline

Attributes