Smartphone Dataset
Unveiling the Comprehensive Specs and Features of Modern Smartphones
@kaggle.muzammilbaloch_smartphone_dataset
Unveiling the Comprehensive Specs and Features of Modern Smartphones
@kaggle.muzammilbaloch_smartphone_dataset
This dataset provides comprehensive information about various mobile phones, including their specifications and features. The dataset includes the following columns:
brand_name: The brand name of the mobile phone manufacturer.model: The specific model name or designation of the mobile phone.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_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_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.).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).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.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.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.
CREATE TABLE smartphones (
"brand_name" VARCHAR,
"model" VARCHAR,
"price" BIGINT,
"avg_rating" DOUBLE,
"n_5g_or_not" BIGINT -- 5G Or Not,
"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
);Anyone who has the link will be able to view this.