Exploratory Data Analysis Project
An Exploratory Data Analysis on e-Commerce events
This dataset contains
900Kdetailed users events from an electronics store e-Commerce website
About the data
The Kaggle dataset is in
.csvfile format having
Each row in the file represents an event. All events are related to products and users. Each event is like many-to-many relation between products and users.
Below are description of
event_time: Time when the event occured (in UTC) in the format "2019-10-01 00:00:04+00:00"
event_type: A single event either "view", "cart" or "purchase"
product_id: A unique code for each product
category_id: A unique code for each product category
category_code: A '.' separated text with names of categories and subcategories "computers.network.router"
brand: Brand name of the product "sony"
price: Price of the product in decimals "31.90"
user_id: A permanent unique ID per shopper "1515915625519388267"
user_session: A temporary ID per session "LJuJVLEjPT"
Events in the column
event_type can be:
view- a user viewed a product
cart- a user added a product to shopping cart
remove_from_cart- a user removed a product from shopping cart
purchase- a user purchased a product
What does each column tell us
event_time and during session
purchased (event_type is "purchase") a product
product_id of brand
brand in category
category_code of price