About this Dataset

Smartphone Dataset

Mobile Phones Dataset Description

This dataset provides comprehensive information about various mobile phones, including their specifications and features. The dataset includes the following columns:

Brand and Model Information

brand_name: The brand name of the mobile phone manufacturer.
model: The specific model name or designation of the mobile phone.

General Specifications

price: The price of the mobile phone in the respective currency.
avg_rating: The average rating or score given by users or reviewers for the mobile phone.
5G_or_not: Indicates whether the mobile phone supports 5G connectivity (0 for no, 1 for yes).

Processor Details

processor_brand: The brand or manufacturer of the processor used in the mobile phone.
num_cores: The number of cores in the processor.
processor_speed: The speed or clock rate of the processor, typically measured in GHz.

Battery and Charging

battery_capacity: The capacity of the mobile phone's battery, typically measured in mAh.
fast_charging_available: Indicates whether the mobile phone supports fast charging (0 for no, 1 for yes).
fast_charging: The fast charging capability or technology used by the mobile phone (e.g., Quick Charge, Dash Charge, etc.).

Memory and Storage

ram_capacity: The amount of RAM (Random Access Memory) available in the mobile phone, typically measured in GB.
internal_memory: The internal storage capacity of the mobile phone, typically measured in GB.
screen_size: The size of the mobile phone's display screen, typically measured in inches.
refresh_rate: The refresh rate of the display screen, typically measured in Hz.
extended_memory_available: Indicates whether the mobile phone supports expandable memory via a memory card slot (0 for no, 1 for yes).

Camera

num_rear_cameras: The number of rear-facing cameras on the mobile phone.
primary_camera_rear: The resolution or megapixel count of the primary rear-facing camera.
primary_camera_front: The resolution or megapixel count of the primary front-facing (selfie) camera.

Display

resolution_height: The height dimension of the display screen resolution, typically measured in pixels.
resolution_width: The width dimension of the display screen resolution, typically measured in pixels.

Operating System

os: The operating system installed on the mobile phone (e.g., Android, iOS, etc.).

The dataset provides a comprehensive overview of various mobile phone models, allowing for analysis and comparison of their specifications and features.

Tables

Smartphones

@kaggle.muzammilbaloch_smartphone_dataset.smartphones

38.89 KB
980 rows
22 columns


CREATE TABLE smartphones (
  "brand_name" VARCHAR,
  "model" VARCHAR,
  "price" BIGINT,
  "avg_rating" DOUBLE,
  "n_5g_or_not" BIGINT,
  "processor_brand" VARCHAR,
  "num_cores" DOUBLE,
  "processor_speed" DOUBLE,
  "battery_capacity" DOUBLE,
  "fast_charging_available" BIGINT,
  "fast_charging" DOUBLE,
  "ram_capacity" BIGINT,
  "internal_memory" BIGINT,
  "screen_size" DOUBLE,
  "refresh_rate" BIGINT,
  "num_rear_cameras" BIGINT,
  "os" VARCHAR,
  "primary_camera_rear" DOUBLE,
  "primary_camera_front" DOUBLE,
  "extended_memory_available" BIGINT,
  "resolution_height" BIGINT,
  "resolution_width" BIGINT
);