Name: SmartPhone Dataset
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

SmartPhone Dataset

This dataset provides detailed information about various smartphone models, including their specifications, pricing, and user feedback. The dataset is ideal for analysis related to market trends, price comparison, feature analysis, and consumer preferences.

Columns description:

brand_name: The name of the smartphone brand.
model_name: The specific model name or number of the smartphone.
discounted_price: The current discounted price of the smartphone.
original_price: The original price of the smartphone before any discounts or promotions.
rating: The average rating of the smartphone based on user reviews.
colour: The available color options of the smartphone.
rom: The internal storage capacity (Read-Only Memory) of the smartphone.
ratings: The total number of ratings received for the smartphone.
reviews: The total number of reviews written by users for the smartphone.
ram: The Random Access Memory (RAM) capacity of the smartphone.
screen_size_cm: The size of the smartphone screen in centimeters.
display_size_inch: The size of the smartphone screen in inches.
display_type: The type of display technology used in the smartphone (e.g., LCD, OLED).
front_camera: The front-facing camera specifications of the smartphone.
rear_camera: The rear camera specifications of the smartphone.
battery: The battery capacity of the smartphone.
processor: The processor or chipset used in the smartphone.

Tables

Smartphone

@kaggle.shahriarkabir_smartphone_dataset.smartphone

46.37 kB
1,149 rows
17 columns

CREATE TABLE smartphone (
  "brand_name" VARCHAR,
  "model_name" VARCHAR,
  "discounted_price" BIGINT,
  "original_price" BIGINT,
  "rating" DOUBLE,
  "colour" VARCHAR,
  "rom" BIGINT,
  "ratings" DOUBLE,
  "reviews" VARCHAR,
  "ram" DOUBLE,
  "screen_size_cm" DOUBLE,
  "display_size_inch" DOUBLE,
  "display_type" VARCHAR,
  "front_camera" DOUBLE,
  "rear_camera" VARCHAR,
  "battery" VARCHAR,
  "processor" VARCHAR
);