Dataset: Flipkart Smartphones And Mobiles

About this Dataset

Flipkart Smartphones And Mobiles

Contains detailed data of popular as well as lesser known smartphones listed on Flipkart.

Brands included -

Apple
Asus
Gionee
Google
Htc
Huawei
Infinix
Intex
Itel
Karbonn
Lava
Lenevo
Lg
Micromax
Motorola
Nokia
Nothing
Oneplus
Oppo
Panasonic
Poco
Realme
Redmi
Samsung
Sony
Spice
Tecno
Vivo

Tables

Mobiles Clean

@kaggle.atharvataras_flipkart_smartphones_and_mobiles.mobiles_clean

1.23 MB
6983 rows
68 columns


CREATE TABLE mobiles_clean (
  "name" VARCHAR,
  "price_inr" DOUBLE,
  "marked_price_inr" DOUBLE,
  "discount" VARCHAR,
  "stars" DOUBLE,
  "rating_count" DOUBLE,
  "review_count" DOUBLE,
  "description" VARCHAR,
  "box_content" VARCHAR,
  "model_num" VARCHAR,
  "model_name" VARCHAR,
  "model_colour" VARCHAR,
  "sims" VARCHAR,
  "sims_hybrid" VARCHAR,
  "otg" VARCHAR,
  "quick_charge" VARCHAR,
  "sound_enhance" VARCHAR,
  "disp_size" VARCHAR,
  "disp_res" VARCHAR,
  "disp_res_type" VARCHAR,
  "gpu" VARCHAR,
  "disp_type" VARCHAR,
  "disp_cols" VARCHAR,
  "disp_feat" VARCHAR,
  "os_name" VARCHAR,
  "cpu_brand" VARCHAR,
  "cpu_type" VARCHAR,
  "cpu_core" VARCHAR,
  "cpu_clock_1" VARCHAR,
  "cpu_clock_2" VARCHAR,
  "storage_int" VARCHAR,
  "ram" VARCHAR,
  "storage_exp" VARCHAR,
  "mem_slot" VARCHAR,
  "cam_prim" VARCHAR,
  "cam_prim_feat" VARCHAR,
  "cam_opt_zoom" VARCHAR,
  "cam_secd" VARCHAR,
  "cam_secd_feat" VARCHAR,
  "cam_flash" VARCHAR,
  "recd_hd" VARCHAR,
  "rec_fhd" VARCHAR,
  "rec_vid_res" VARCHAR,
  "zoom" VARCHAR,
  "cam_fps" VARCHAR,
  "networks" VARCHAR,
  "musb" VARCHAR,
  "bluetooth" VARCHAR,
  "wifi" VARCHAR,
  "nfc" VARCHAR,
  "infrared" VARCHAR,
  "jack" VARCHAR,
  "sim_size" VARCHAR,
  "user_intf" VARCHAR,
  "disp_ppi" VARCHAR,
  "sensors" VARCHAR,
  "tones" VARCHAR,
  "gps_type" VARCHAR,
  "radio" VARCHAR,
  "bat_cap" VARCHAR,
  "bat_type" VARCHAR,
  "dim_width" VARCHAR,
  "dim_height" VARCHAR,
  "dim_depth" VARCHAR,
  "dim_weight" VARCHAR,
  "warranty" VARCHAR,
  "brand" VARCHAR,
  "availability" VARCHAR
);

Mobiles Raw

@kaggle.atharvataras_flipkart_smartphones_and_mobiles.mobiles_raw

1.66 MB
6983 rows
68 columns


CREATE TABLE mobiles_raw (
  "parent_url" VARCHAR,
  "name" VARCHAR,
  "price_inr" VARCHAR,
  "marked_price_inr" VARCHAR,
  "discount" VARCHAR,
  "stars" DOUBLE,
  "rating_count" VARCHAR,
  "review_count" VARCHAR,
  "description" VARCHAR,
  "box_content" VARCHAR,
  "model_num" VARCHAR,
  "model_name" VARCHAR,
  "model_colour" VARCHAR,
  "sims" VARCHAR,
  "sims_hybrid" VARCHAR,
  "otg" VARCHAR,
  "quick_charge" VARCHAR,
  "sound_enhance" VARCHAR,
  "disp_size" VARCHAR,
  "disp_res" VARCHAR,
  "disp_res_type" VARCHAR,
  "gpu" VARCHAR,
  "disp_type" VARCHAR,
  "disp_cols" VARCHAR,
  "disp_feat" VARCHAR,
  "os_name" VARCHAR,
  "cpu_brand" VARCHAR,
  "cpu_type" VARCHAR,
  "cpu_core" VARCHAR,
  "cpu_clock_1" VARCHAR,
  "cpu_clock_2" VARCHAR,
  "storage_int" VARCHAR,
  "ram" VARCHAR,
  "storage_exp" VARCHAR,
  "mem_slot" VARCHAR,
  "cam_prim" VARCHAR,
  "cam_prim_feat" VARCHAR,
  "cam_opt_zoom" VARCHAR,
  "cam_secd" VARCHAR,
  "cam_secd_feat" VARCHAR,
  "cam_flash" VARCHAR,
  "recd_hd" VARCHAR,
  "rec_fhd" VARCHAR,
  "rec_vid_res" VARCHAR,
  "zoom" VARCHAR,
  "cam_fps" VARCHAR,
  "networks" VARCHAR,
  "musb" VARCHAR,
  "bluetooth" VARCHAR,
  "wifi" VARCHAR,
  "nfc" VARCHAR,
  "infrared" VARCHAR,
  "jack" VARCHAR,
  "sim_size" VARCHAR,
  "user_intf" VARCHAR,
  "disp_ppi" VARCHAR,
  "sensors" VARCHAR,
  "tones" VARCHAR,
  "gps_type" VARCHAR,
  "radio" VARCHAR,
  "bat_cap" VARCHAR,
  "bat_type" VARCHAR,
  "dim_width" VARCHAR,
  "dim_height" VARCHAR,
  "dim_depth" VARCHAR,
  "dim_weight" VARCHAR,
  "warranty" VARCHAR,
  "brand" VARCHAR
);