Baselight

Phone Information 2024

Dataset Overview: Phone Listings from GSMArena.com.

@kaggle.willianoliveiragibin_phone_information_2024

Loading...
Loading...

About this Dataset

Phone Information 2024



This dataset, titled "Phone Listings from GSMArena.com," consists of two primary files: data.json and processed_data.csv, each containing detailed information about various phone models available on the market.

data.json File
This file holds the raw, unprocessed data scraped from GSMArena.com. The columns and attributes include:

phone_brand: The brand or manufacturer of the phone (e.g., Apple, Samsung, Xiaomi).
phone_model: The specific model or number of the phone.
price: The price point of the phone, which can either be an exact figure or a rough estimate. This column might require data cleaning due to inconsistencies.
specs: A nested dictionary that details the phone’s technical specifications. This includes features such as screen size, camera resolution, processor type, battery life, and other relevant hardware components.
pricing: A nested dictionary containing price listings for the phone across various e-commerce platforms.
processed_data.csv File
This file contains cleaned and processed phone data, aggregated from various e-commerce sources. The columns are more refined, and each phone entry provides comprehensive details:

phone_brand: The manufacturer or brand of the phone.
phone_model: The specific model or name of the phone.
store: The particular store or e-commerce platform where the phone is listed.
price: The price of the phone as a floating-point number, set in the native currency.
currency: The currency in which the phone is priced (e.g., USD, EUR).
price_USD: The phone price converted into USD.
storage: The storage capacity of the phone, measured in gigabytes (GB).
ram: The amount of RAM available in the phone, also measured in gigabytes (GB).
Launch: The official launch date of the phone, represented in a datetime format.
Dimensions: The physical dimensions of the phone, typically provided in millimeters (e.g., 163.8 x 76.8 x 8.9 mm).
Weight: The weight of the phone, measured in grams.
Display_Type: The type of display technology used, for example, "LTPO Super Retina XDR OLED, 120Hz, HDR10."
Display_Size: The size of the phone's display in inches.
Display_Resolution: The resolution of the phone's display (e.g., 1280 x 2856 pixels).
OS: The phone's operating system, such as iOS 18 or Android 14.
NFC: A flag indicating the presence of Near Field Communication (NFC), with values of 1 for phones that have NFC and 0 for phones that do not.
USB: The type of USB port (e.g., USB Type-C 3.2 Gen 2).
BATTERY: The battery capacity of the phone, measured in milliampere hours (mAh).
Features_Sensors: Various features and sensors included with the phone (e.g., fingerprint scanner, accelerometer).
Colors: Available color options for the phone model (e.g., Black Titanium, White Titanium).
Video: Camera specifications for video recording, including supported resolutions and frame rates (e.g., 4K@30fps).
Chipset: The chipset model in the phone, such as "Apple A18 Pro (3 nm)."
CPU: Specifications of the central processing unit (CPU) (e.g., Hexa-core, 2x4.05 GHz).
GPU: Specifications of the graphical processing unit (GPU).
Year: The year in which the phone model was released.
Foldable: A flag indicating whether the phone is foldable (1 = foldable, 0 = not foldable).
PPI_Density: The pixel density of the display in pixels per inch (ppi).
quantile_10, quantile_50, quantile_90: These columns represent the 10th, 50th (median), and 90th quantiles of phone prices in a given year.
price_range: This column classifies phones into different price ranges (low, medium, or high), based on their position in the price distribution (quantiles).
Overall, this dataset provides extensive information on phone models, offering both raw and processed views of phone listings, along with important price and technical details.

Tables

Processed Data News

@kaggle.willianoliveiragibin_phone_information_2024.processed_data_news
  • 106.82 kB
  • 1,715 rows
  • 31 columns
Loading...
CREATE TABLE processed_data_news (
  "phone_brand" VARCHAR,
  "phone_model" VARCHAR,
  "store" VARCHAR,
  "price" DOUBLE,
  "currency" VARCHAR,
  "price_usd" DOUBLE,
  "storage" BIGINT,
  "ram" BIGINT,
  "launch" 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" BIGINT,
  "foldable" BIGINT,
  "ppi_density" BIGINT,
  "quantile_10" VARCHAR,
  "quantile_50" DOUBLE,
  "quantile_90" VARCHAR,
  "price_range" VARCHAR
);

Share link

Anyone who has the link will be able to view this.