Name: Fitness Trackers Products Ecommerce
Creator: Kaggle
License: https://creativecommons.org/licenses/by-sa/4.0/

About this Dataset

Fitness Trackers Products Ecommerce

This is a fitness tracker product dataset consisting of different products from various brands with their specifications, ratings and reviews for the Indian market. The data has been collected from an e-commerce website (Flipkart) using webscraping technique.

Content

This dataset contains 565 samples with 11 attributes. There are some missing values in this dataset. Here are the columns in this dataset-

Brand Name: This indicates the manufacturer of the product (fitness tracker)
Device Type: This has two categories- FitnessBand and Smartwatch
Model Name: This indicates the variant/Product Name
Color: This includes the color of the Strap/Body of the fitness tracker
Selling Price: This column has the Selling Price or the Discounted Price of the fitness tracker
Original Price: This includes the Original Price of the product from the manufacturer.
Display: This categorical variable shows the type of display for the fitness tracker. eg: AMOLED, LCD,OLED, etc.
Rating (Out of 5): Average customer ratings on a scale of 5.
Strap Material: Details of the material used for the strap of the fitness tracker.
Average Battery Life (in days): Quoted average battery life from the manufacturer based on the individual product pages. (It is not the scraped data)
Reviews: count of product reviews received.

Inspiration

This dataset could be used to find answers to some interesting questions like -
1. Is there a significant demand for fitness trackers in the Indian market?
2. Information on the top 5 brands for fitness bands and smart watches
3. Is there a correlation between the prices and product specifications, ratings, etc.
4. Different types of fitness trackers, their price segments for different users

Tables

Fitness Trackers

@kaggle.devsubhash_fitness_trackers_products_ecommerce.fitness_trackers

19.75 kB
565 rows
11 columns

CREATE TABLE fitness_trackers (
  "brand_name" VARCHAR,
  "device_type" VARCHAR,
  "model_name" VARCHAR,
  "color" VARCHAR,
  "selling_price" BIGINT,
  "original_price" BIGINT,
  "display" VARCHAR,
  "rating_out_of_5" DOUBLE  -- Rating (Out Of 5),
  "strap_material" VARCHAR,
  "average_battery_life_in_days" BIGINT  -- Average Battery Life (in Days),
  "reviews" DOUBLE
);

Fitness Trackers Updated

@kaggle.devsubhash_fitness_trackers_products_ecommerce.fitness_trackers_updated

20.92 kB
610 rows
11 columns

CREATE TABLE fitness_trackers_updated (
  "brand_name" VARCHAR,
  "device_type" VARCHAR,
  "model_name" VARCHAR,
  "color" VARCHAR,
  "selling_price" BIGINT,
  "original_price" BIGINT,
  "display" VARCHAR,
  "rating_out_of_5" DOUBLE  -- Rating (Out Of 5),
  "strap_material" VARCHAR,
  "average_battery_life_in_days" BIGINT  -- Average Battery Life (in Days),
  "reviews" DOUBLE
);