Clickstream Data For Online Shopping
clickstream data for online shopping Data Set
@kaggle.tunguz_clickstream_data_for_online_shopping
clickstream data for online shopping Data Set
@kaggle.tunguz_clickstream_data_for_online_shopping
Mariusz ÅapczyÅ„ski, Cracow University of Economics, Poland, lapczynm '@' uek.krakow.pl
Sylwester Białowąs, Poznan University of Economics and Business, Poland, sylwester.bialowas '@' ue.poznan.pl
The dataset contains information on clickstream from online store offering clothing for pregnant women. Data are from five months of 2008 and include, among others, product category, location of the photo on the page, country of origin of the IP address and product price in US dollars.
The dataset contains 14 variables described in a separate file (See 'Data set description')
N/A
If you use this dataset, please cite:
ÅapczyÅ„ski M., BiaÅ‚owÄ…s S. (2013) Discovering Patterns of Users' Behaviour in an E-shop - Comparison of Consumer Buying Behaviours in Poland and Other European Countries, “Studia Ekonomiczneâ€, nr 151, “La société de l'information : perspective européenne et globale : les usages et les risques d'Internet pour les citoyens et les consommateursâ€, p. 144-153
========================================================
========================================================
========================================================
========================================================
following categories:
1-Australia
2-Austria
3-Belgium
4-British Virgin Islands
5-Cayman Islands
6-Christmas Island
7-Croatia
8-Cyprus
9-Czech Republic
10-Denmark
11-Estonia
12-unidentified
13-Faroe Islands
14-Finland
15-France
16-Germany
17-Greece
18-Hungary
19-Iceland
20-India
21-Ireland
22-Italy
23-Latvia
24-Lithuania
25-Luxembourg
26-Mexico
27-Netherlands
28-Norway
29-Poland
30-Portugal
31-Romania
32-Russia
33-San Marino
34-Slovakia
35-Slovenia
36-Spain
37-Sweden
38-Switzerland
39-Ukraine
40-United Arab Emirates
41-United Kingdom
42-USA
43-biz (.biz)
44-com (.com)
45-int (.int)
46-net (.net)
47-org (*.org)
========================================================
========================================================
1-trousers
2-skirts
3-blouses
4-sale
========================================================
(217 products)
========================================================
1-beige
2-black
3-blue
4-brown
5-burgundy
6-gray
7-green
8-navy blue
9-of many colors
10-olive
11-pink
12-red
13-violet
14-white
========================================================
1-top left
2-top in the middle
3-top right
4-bottom left
5-bottom in the middle
6-bottom right
========================================================
1-en face
2-profile
========================================================
========================================================
the average price for the entire product category
1-yes
2-no
========================================================
++++++++++++++++++++++++++++++++++++++++++++++++++++++++
CREATE TABLE e_shop_clothing_2008 (
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"order" BIGINT,
"country" BIGINT,
"session_id" BIGINT,
"page_1_main_category" BIGINT -- Page 1 (main Category),
"page_2_clothing_model" VARCHAR -- Page 2 (clothing Model),
"colour" BIGINT,
"location" BIGINT,
"model_photography" BIGINT,
"price" BIGINT,
"price_2" BIGINT,
"page" BIGINT
);Anyone who has the link will be able to view this.