Booking¶

This example uses the 'Expedia' dataset to predict, based on site activity, whether a user is likely to make a booking. You can download the Jupyter Notebook of the study here and the the dataset here.

cnt: Number of similar events in the context of the same user session.
user_location_city: The ID of the city in which the customer is located.
is_package: 1 if the click/booking was generated as a part of a package (i.e. combined with a flight), 0 otherwise.
user_id: ID of the user
srch_children_cnt: The number of (extra occupancy) children specified in the hotel room.
channel: marketing ID of a marketing channel.
hotel_cluster: ID of a hotel cluster.
srch_destination_id: ID of the destination where the hotel search was performed.
is_mobile: 1 if the user is on a mobile device, 0 otherwise.
srch_adults_cnt: The number of adults specified in the hotel room.
user_location_country: The ID of the country in which the customer is located.
srch_destination_type_id: ID of the destination where the hotel search was performed.
srch_rm_cnt: The number of hotel rooms specified in the search.
posa_continent: ID of the continent associated with the site_name.
srch_ci: Check-in date.
user_location_region: The ID of the region in which the customer is located.
hotel_country: Hotel's country.
srch_co: Check-out date.
is_booking: 1 if a booking, 0 if a click.
orig_destination_distance: Physical distance between a hotel and a customer at the time of search. A null means the distance could not be calculated.
hotel_continent: Hotel continent.
site_name: ID of the Expedia point of sale (i.e. Expedia.com, Expedia.co.uk, Expedia.co.jp, ...).

We will follow the data science cycle (Data Exploration - Data Preparation - Data Modeling - Model Evaluation - Model Deployment) to solve this problem.

Initialization¶

This example uses the following version of VerticaPy:

In [1]:

import verticapy as vp
vp.__version__

Out[1]:

'0.9.0'

Connect to Vertica. This example uses an existing connection called "VerticaDSN." For details on how to create a connection, use see the connection tutorial.

In [2]:

vp.connect("VerticaDSN")

Let's create a Virtual DataFrame of the dataset.

In [3]:

expedia = vp.read_csv('data/expedia.csv', parse_nrows=1000)
expedia.head(5)

Out[3]:

	📅 date_time Timestamp	123 site_name Int	123 posa_continent Int	123 user_location_country Int	123 user_location_region Int	123 user_location_city Int	123 orig_destination_distance Numeric(11,5)	123 user_id Int	123 is_mobile Int	123 is_package Int	123 channel Int	📅 srch_ci Date	📅 srch_co Date	123 srch_adults_cnt Int	123 srch_children_cnt Int	123 srch_rm_cnt Int	123 srch_destination_id Int	123 srch_destination_type_id Int	123 is_booking Int	123 cnt Int	123 hotel_continent Int	123 hotel_country Int	123 hotel_market Int	123 hotel_cluster Int
1	2013-01-07 00:00:02	24	2	3	50	5703	[null]	461899	0	0	9	2013-03-14	2013-03-15	2	1	1	669	3	0	1	2	50	212	41
2	2013-01-07 00:00:06	2	3	66	174	21177	5713.6206	13796	0	0	9	2013-01-19	2013-01-26	1	0	1	8821	1	0	3	6	17	30	58
3	2013-01-07 00:00:06	11	3	205	155	14703	795.7298	1128575	0	0	9	2013-01-19	2013-01-22	1	0	1	25064	6	0	1	2	50	1230	91
4	2013-01-07 00:00:09	37	1	69	761	41949	[null]	1080476	0	1	9	2013-05-29	2013-06-05	2	0	1	7635	3	0	1	2	50	675	10
5	2013-01-07 00:00:17	37	1	69	761	41949	[null]	1018895	0	0	0	2013-09-08	2013-09-10	2	0	1	27215	6	0	2	2	50	645	59

Rows: 1-5 | Columns: 24

Data Exploration and Preparation¶

Sessionization is the process of gathering clicks for a certain period of time. We usually consider that after 30 minutes of inactivity, the user session ends (date_time - lag(date_time) > 30 minutes). For these kinds of use cases, aggregating sessions with meaningful statistics is the key for making accurate predictions.

We start by using the sessionize' method to create the variable 'session_id. We can then use this variable to aggregate the data.

In [4]:

expedia.sessionize(ts = "date_time", 
                   by = ["user_id"], 
                   session_threshold = "30 minutes", 
                   name = "session_id")

Out[4]:

	📅 date_time Timestamp	123 site_name Int	123 posa_continent Int	123 user_location_country Int	123 user_location_region Int	123 user_location_city Int	123 orig_destination_distance Numeric(11,5)	123 user_id Int	123 is_mobile Int	123 is_package Int	123 channel Int	📅 srch_ci Date	📅 srch_co Date	123 srch_adults_cnt Int	123 srch_children_cnt Int	123 srch_rm_cnt Int	123 srch_destination_id Int	123 srch_destination_type_id Int	123 is_booking Int	123 cnt Int	123 hotel_continent Int	123 hotel_country Int	123 hotel_market Int	123 hotel_cluster Int	123 session_id Integer
1	2014-09-03 08:18:41	2	3	66	174	9045	53.6059	0	1	0	2	2014-09-06	2014-09-07	2	2	1	24693	6	0	1	2	50	1241	19	0
2	2014-12-03 11:28:11	2	3	66	174	42538	343.7866	0	1	0	2	2014-12-29	2014-12-30	2	1	1	8279	1	0	1	2	50	1230	98	1
3	2014-12-03 11:28:58	2	3	66	174	42538	343.9901	0	1	0	2	2014-12-29	2014-12-30	2	1	1	8279	1	0	1	2	50	1230	40	1
4	2014-12-03 11:30:21	2	3	66	174	42538	343.7968	0	1	0	2	2014-12-29	2014-12-30	2	1	1	8279	1	0	1	2	50	1230	56	1
5	2014-12-03 11:32:43	2	3	66	174	42538	342.2163	0	1	0	2	2014-12-29	2014-12-30	3	2	1	8279	1	0	2	2	50	358	72	1
6	2014-12-06 01:38:26	2	3	66	174	9045	88.1489	0	1	0	2	2014-12-19	2014-12-20	2	2	1	8279	1	0	1	2	50	358	28	2
7	2014-04-25 16:14:28	2	3	66	174	37449	5405.4889	1	1	0	2	2014-11-07	2014-11-09	3	1	1	62881	4	0	1	4	98	2052	20	0
8	2014-04-25 16:14:46	2	3	66	174	37449	5405.4889	1	1	0	2	2014-11-07	2014-11-09	5	1	2	62881	4	0	1	4	98	2052	20	0
9	2014-04-25 16:15:11	2	3	66	174	37449	5405.4889	1	1	0	2	2014-11-07	2014-11-09	3	1	2	62881	4	0	1	4	98	2052	20	0
10	2014-04-25 16:15:50	2	3	66	174	37449	5405.7409	1	1	0	2	2014-11-07	2014-11-09	3	1	2	62881	4	0	1	4	98	2052	60	0
11	2014-01-27 12:56:00	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-12	2	0	1	11621	1	0	2	2	50	703	96	0
12	2014-01-27 13:00:31	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-12	2	0	1	11621	1	0	1	2	50	703	72	0
13	2014-01-27 13:04:55	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-12	2	0	1	11621	1	0	1	2	50	703	91	0
14	2014-01-27 13:06:31	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-12	2	0	1	11621	1	0	1	2	50	703	91	0
15	2014-01-27 13:14:21	2	3	66	311	25671	[null]	2	0	0	9	2014-04-08	2014-04-12	2	0	1	11621	1	0	2	2	50	703	91	0
16	2014-01-27 13:18:43	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-12	2	0	1	11621	1	0	1	2	50	703	94	0
17	2014-01-27 13:22:39	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-12	2	0	1	11621	1	0	1	2	50	703	21	0
18	2014-01-27 13:39:30	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-11	2	0	1	11621	1	0	2	2	50	703	96	0
19	2014-01-27 13:54:07	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-11	2	0	1	11621	1	0	2	2	50	703	94	0
20	2014-01-28 12:20:02	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-11	2	0	1	12008	1	0	3	2	50	686	95	1
21	2014-01-28 12:27:47	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-11	2	0	1	12008	1	0	1	2	50	686	41	1
22	2014-01-28 12:28:31	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-11	2	0	1	12008	1	0	1	2	50	686	73	1
23	2014-01-28 12:31:18	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-11	2	0	1	12008	1	0	1	2	50	686	68	1
24	2014-01-28 12:32:35	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-11	2	0	1	12008	1	0	1	2	50	686	91	1
25	2014-01-28 12:34:21	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-11	2	0	1	12008	1	0	1	2	50	686	91	1
26	2014-01-28 12:37:49	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-11	2	0	1	12008	1	0	2	2	50	686	18	1
27	2014-01-28 12:44:16	2	3	66	311	25671	[null]	2	0	0	9	2014-04-08	2014-04-11	2	0	1	12008	1	0	1	2	50	686	18	1
28	2014-01-28 17:06:02	2	3	66	311	25671	[null]	2	0	1	2	2014-04-08	2014-04-11	2	0	1	8250	1	0	4	2	50	628	18	2
29	2014-01-28 17:11:35	2	3	66	311	25671	[null]	2	0	1	2	2014-04-08	2014-04-11	2	0	1	8250	1	0	1	2	50	628	1	2
30	2014-07-31 07:10:39	2	3	66	321	51642	1432.9656	3	0	0	9	2015-02-07	2015-02-10	3	2	2	28586	6	0	1	2	50	705	5	0
31	2014-09-08 09:56:21	2	3	66	467	5222	142.7467	3	0	0	9	2014-10-11	2014-10-12	2	0	1	8261	1	0	1	2	50	646	18	1
32	2014-09-08 09:58:50	2	3	66	467	5222	141.0454	3	0	0	9	2014-10-11	2014-10-12	2	0	1	8261	1	0	1	2	50	646	2	1
33	2014-09-09 10:49:48	2	3	66	467	5222	143.2998	3	0	0	9	2015-02-01	2015-02-02	2	2	1	27699	6	0	1	2	50	646	48	2
34	2014-09-22 13:19:02	2	3	66	467	5222	141.1273	3	0	0	3	2015-02-01	2015-02-02	2	0	1	27699	6	0	1	2	50	646	94	3
35	2014-09-22 13:22:25	2	3	66	467	5222	141.1273	3	0	0	3	2015-02-01	2015-02-02	3	0	1	8261	1	0	1	2	50	646	94	3
36	2014-09-30 12:56:51	2	3	66	467	5222	142.7467	3	0	0	9	2014-10-11	2014-10-12	2	0	1	8261	1	0	1	2	50	646	18	4
37	2014-10-20 11:19:21	2	3	66	467	5222	144.4084	3	0	0	9	2015-02-01	2015-02-02	2	2	1	27704	6	0	1	2	50	646	47	5
38	2014-08-14 18:11:08	2	3	66	258	45545	110.4682	4	0	0	9	2014-10-18	2014-10-20	2	0	1	8283	1	0	1	2	50	414	21	0
39	2014-08-29 16:53:11	2	3	66	258	45545	1318.4152	4	0	0	7	2015-01-30	2015-02-03	6	0	1	8250	1	0	1	2	50	628	71	1
40	2014-08-29 16:54:16	2	3	66	258	45545	1318.8177	4	0	0	7	2015-01-30	2015-02-03	6	0	1	8250	1	0	1	2	50	628	71	1
41	2014-08-29 16:55:21	2	3	66	258	45545	1319.0022	4	0	0	7	2015-01-30	2015-02-03	6	0	1	8250	1	0	1	2	50	628	38	1
42	2014-08-29 16:58:41	2	3	66	258	45545	1318.1384	4	0	0	7	2015-01-30	2015-02-03	2	0	1	8250	1	0	1	2	50	628	34	1
43	2014-08-29 16:59:41	2	3	66	258	45545	1321.0614	4	0	0	7	2015-01-30	2015-02-03	2	0	1	8250	1	0	1	2	50	628	71	1
44	2014-08-29 17:00:33	2	3	66	258	45545	1317.3999	4	0	0	7	2015-01-30	2015-02-03	2	0	1	8250	1	0	1	2	50	628	18	1
45	2014-12-07 18:18:26	2	3	66	258	4687	978.1868	4	0	0	1	2015-03-18	2015-03-22	2	2	1	11624	6	0	1	2	50	666	73	2
46	2014-12-07 18:19:10	2	3	66	258	4687	978.3691	4	0	0	1	2015-03-18	2015-03-22	2	2	1	11624	6	0	1	2	50	666	73	2
47	2014-12-07 18:25:20	2	3	66	258	4687	149.625	4	0	0	1	2015-01-02	2015-01-04	2	2	1	4475	1	0	1	2	50	1343	15	2
48	2014-01-26 23:56:46	2	3	66	174	24103	960.42	5	0	1	10	2014-03-21	2014-03-25	1	1	1	8281	1	0	1	2	50	663	9	0
49	2014-01-27 00:00:31	2	3	66	174	24103	960.42	5	0	1	10	2014-03-22	2014-03-26	1	1	1	8281	1	0	3	2	50	663	9	0
50	2014-01-27 00:03:44	2	3	66	174	24103	960.1149	5	0	1	10	2014-03-22	2014-03-26	2	1	1	8281	1	0	1	2	50	663	68	0
51	2014-01-27 00:05:12	2	3	66	174	24103	960.5072	5	0	1	10	2014-03-22	2014-03-26	2	1	1	8281	1	0	1	2	50	663	18	0
52	2014-01-27 00:06:18	2	3	66	174	24103	960.7861	5	0	1	10	2014-03-22	2014-03-26	1	1	1	8281	1	0	1	2	50	663	42	0
53	2014-01-27 00:08:48	2	3	66	174	24103	960.0054	5	0	1	10	2014-03-22	2014-03-26	1	1	1	8281	1	0	1	2	50	663	70	0
54	2014-01-27 00:10:17	2	3	66	174	24103	960.001	5	0	1	10	2014-03-22	2014-03-26	1	1	1	8281	1	0	12	2	50	663	41	0
55	2014-01-27 00:36:54	2	3	66	174	24103	960.001	5	0	1	10	2014-03-22	2014-03-26	1	1	1	8281	1	1	1	2	50	663	41	0
56	2014-01-27 01:17:09	2	3	66	174	24103	960.42	5	0	1	2	2014-03-22	2014-03-26	1	1	1	8281	1	0	1	2	50	663	9	1
57	2014-07-30 17:13:07	2	3	66	356	51532	836.9683	6	1	0	9	2014-12-03	2014-12-06	2	3	1	12175	6	0	1	2	50	366	28	0
58	2014-08-28 11:54:12	2	3	66	246	49795	2574.2075	6	1	0	2	2014-12-03	2014-12-06	2	0	1	12175	6	0	1	2	50	366	13	1
59	2014-08-28 12:03:06	2	3	66	246	49795	2573.1667	6	1	0	2	2014-12-03	2014-12-06	2	0	1	12175	6	0	1	2	50	366	28	1
60	2014-08-29 16:25:06	2	3	66	246	50661	2579.8433	6	1	0	2	2014-12-03	2014-12-06	2	0	1	12175	6	0	1	2	50	366	28	2
61	2014-08-29 16:26:14	2	3	66	246	50661	2577.5509	6	1	0	2	2014-12-03	2014-12-06	2	0	1	12175	6	0	1	2	50	366	91	2
62	2014-08-29 16:27:07	2	3	66	246	50661	2577.6926	6	1	0	2	2014-12-03	2014-12-06	2	0	1	12175	6	0	1	2	50	366	13	2
63	2014-09-01 23:56:27	2	3	66	246	50661	2577.2399	6	1	0	2	2014-12-03	2014-12-06	2	0	1	12175	6	0	2	2	50	366	70	3
64	2014-09-01 23:58:04	2	3	66	246	50661	2577.6926	6	1	0	2	2014-12-03	2014-12-06	2	0	1	12175	6	0	1	2	50	366	13	3
65	2014-09-11 19:32:52	2	3	66	356	22202	756.9031	6	1	0	2	2014-12-08	2014-12-11	2	0	1	8250	1	0	1	2	50	628	1	4
66	2014-10-10 12:25:06	2	3	66	246	50661	2759.7778	6	0	0	9	2014-12-08	2014-12-11	2	0	1	8250	1	0	1	2	50	628	1	5
67	2014-11-03 01:01:07	2	3	66	462	49272	876.1516	6	1	0	2	2014-12-08	2014-12-11	2	0	1	8250	1	0	1	2	50	628	54	6
68	2014-11-03 11:09:56	2	3	66	246	50661	2755.8182	6	0	0	0	2014-12-08	2014-12-09	2	0	1	8250	1	0	1	2	50	628	54	7
69	2014-11-04 20:26:42	2	3	66	174	24103	225.6717	6	1	0	9	2014-12-08	2014-12-09	2	0	1	8250	1	0	1	2	50	628	54	8
70	2014-11-21 08:16:01	2	3	66	246	50661	2609.6874	6	0	0	0	2014-12-11	2014-12-12	2	0	1	12264	6	0	1	2	50	368	51	9
71	2014-11-21 08:18:12	2	3	66	246	50661	2610.2816	6	0	0	0	2014-12-11	2014-12-12	2	0	1	12264	6	0	1	2	50	368	47	9
72	2014-11-21 08:31:09	2	3	66	246	50661	2610.2808	6	0	0	0	2014-12-11	2014-12-12	2	0	1	12264	6	0	1	2	50	368	51	9
73	2014-11-24 20:36:28	2	3	66	246	50661	2609.9043	6	0	0	0	2014-12-11	2014-12-12	2	2	1	12264	6	0	2	2	50	368	17	10
74	2014-11-24 20:36:38	2	3	66	246	50661	2610.401	6	0	0	0	2014-12-11	2014-12-12	2	2	1	12264	6	0	1	2	50	368	16	10
75	2014-11-24 20:37:16	2	3	66	246	50661	2610.4181	6	0	0	0	2014-12-11	2014-12-12	2	2	1	12264	6	0	1	2	50	368	4	10
76	2014-11-24 21:00:40	2	3	66	246	50661	2607.7527	6	0	0	0	2014-12-11	2014-12-12	2	2	1	52512	3	0	1	2	50	368	16	10
77	2014-11-24 21:01:01	2	3	66	246	50661	2607.7383	6	0	0	0	2014-12-11	2014-12-12	2	2	1	52512	3	0	1	2	50	368	39	10
78	2014-08-27 09:45:42	2	3	66	318	31646	5378.6918	7	0	0	2	2014-10-31	2014-11-01	2	0	1	792	1	0	5	6	208	1480	64	0
79	2014-08-27 09:51:32	2	3	66	318	31646	5378.6918	7	0	0	2	2015-01-29	2015-02-08	2	0	1	792	1	0	2	6	208	1480	64	0
80	2014-08-27 09:58:02	2	3	66	318	31646	5378.6918	7	0	0	2	2015-01-30	2015-02-05	2	0	1	792	1	0	2	6	208	1480	64	0
81	2014-08-27 09:58:55	2	3	66	318	31646	5375.9045	7	0	0	2	2014-10-31	2014-11-01	2	0	1	792	1	0	1	6	208	1480	86	0
82	2014-08-27 10:01:09	2	3	66	318	31646	5380.6319	7	0	0	2	2014-10-31	2014-11-01	2	0	1	792	1	0	1	6	208	1480	64	0
83	2014-08-27 10:03:53	2	3	66	318	31646	5380.6319	7	0	1	2	2015-01-30	2015-02-05	2	0	1	792	1	0	1	6	208	1480	64	0
84	2014-09-10 12:20:39	2	3	66	318	31646	3936.1062	7	0	0	2	2014-10-12	2014-10-13	1	0	1	22616	6	0	1	6	204	1452	5	1
85	2014-09-24 11:23:59	2	3	66	318	878	830.2591	7	0	0	9	2014-12-04	2014-12-07	2	0	1	19535	1	0	2	2	50	593	5	2
86	2014-09-24 11:36:08	2	3	66	318	878	830.2591	7	0	0	9	2014-12-04	2014-12-07	2	0	1	19535	1	1	1	2	50	593	5	2
87	2014-09-24 11:57:49	2	3	66	318	878	830.2591	7	0	1	9	2014-12-04	2014-12-07	2	0	1	19535	1	0	1	2	50	593	5	2
88	2014-10-06 18:28:52	2	3	66	318	33705	826.9443	7	0	0	0	2014-12-04	2014-12-07	2	0	1	19535	1	0	1	2	50	593	91	3
89	2014-10-06 18:32:36	2	3	66	318	33705	826.9994	7	0	0	0	2014-12-04	2014-12-07	2	0	1	19535	1	0	1	2	50	593	5	3
90	2014-10-29 05:57:44	2	3	66	318	8031	862.7599	7	0	0	2	2014-11-11	2014-11-12	2	0	1	19535	1	0	2	2	50	593	32	4
91	2014-10-29 05:58:44	2	3	66	318	8031	862.7337	7	0	0	2	2014-11-11	2014-11-12	2	0	1	19535	1	0	1	2	50	593	7	4
92	2014-10-31 07:14:03	2	3	66	318	8031	863.0788	7	0	1	4	2014-12-04	2014-12-07	2	0	1	19535	1	0	6	2	50	593	90	5
93	2014-11-06 10:14:59	2	3	66	318	41478	[null]	7	0	1	2	2014-12-04	2014-12-07	2	0	1	19535	1	0	1	2	50	593	32	6
94	2014-11-06 10:44:50	2	3	66	318	41478	[null]	7	0	1	2	2014-12-04	2014-12-07	2	0	1	19535	1	0	1	2	50	593	28	6
95	2014-11-06 10:45:59	2	3	66	318	41478	[null]	7	0	1	2	2014-12-04	2014-12-07	2	0	1	19535	1	0	1	2	50	593	42	6
96	2014-11-06 10:47:25	2	3	66	318	41478	[null]	7	0	1	2	2014-12-04	2014-12-07	2	0	1	19535	1	0	1	2	50	593	76	6
97	2014-11-06 11:26:14	2	3	66	318	41478	[null]	7	0	0	2	2014-12-04	2014-12-07	2	0	1	19535	1	0	1	2	50	593	33	7
98	2014-11-06 11:27:14	2	3	66	318	41478	[null]	7	0	1	2	2014-12-04	2014-12-07	2	0	1	19535	1	0	1	2	50	593	33	7
99	2014-11-06 11:27:47	2	3	66	318	41478	[null]	7	0	1	2	2014-12-04	2014-12-07	2	0	1	19535	1	0	2	2	50	593	32	7
100	2014-11-07 11:01:05	2	3	66	318	41478	[null]	7	0	1	9	2014-12-04	2014-12-07	2	0	1	19535	1	0	2	2	50	593	73	8

Rows: 1-100 | Columns: 25

The duration of the trip should also influence/be indicative of the user's behavior on the site, so we'll take that into account.

In [5]:

expedia["trip_duration"] = expedia["srch_co"] - expedia["srch_ci"]

If a user looks at the same hotel several times, then it might mean that they're looking to book that hotel during the session.

In [6]:

expedia.analytic('mode', 
                 columns = "hotel_cluster", 
                 by = ["user_id",
                       "session_id"], 
                 name = "mode_hotel_cluster",
                 add_count = True)

Out[6]:

	📅 date_time Timestamp	123 site_name Int	123 posa_continent Int	123 user_location_country Int	123 user_location_region Int	123 user_location_city Int	123 orig_destination_distance Numeric(11,5)	123 user_id Int	123 is_mobile Int	123 is_package Int	123 channel Int	📅 srch_ci Date	📅 srch_co Date	123 srch_adults_cnt Int	123 srch_children_cnt Int	123 srch_rm_cnt Int	123 srch_destination_id Int	123 srch_destination_type_id Int	123 is_booking Int	123 cnt Int	123 hotel_continent Int	123 hotel_country Int	123 hotel_market Int	123 hotel_cluster Int	123 session_id Integer	123 trip_duration Integer	123 mode_hotel_cluster Integer	123 mode_hotel_cluster_count Integer
1	2014-09-03 08:18:41	2	3	66	174	9045	53.6059	0	1	0	2	2014-09-06	2014-09-07	2	2	1	24693	6	0	1	2	50	1241	19	0	1	19	1
2	2014-12-03 11:32:43	2	3	66	174	42538	342.2163	0	1	0	2	2014-12-29	2014-12-30	3	2	1	8279	1	0	2	2	50	358	72	1	1	72	1
3	2014-12-03 11:30:21	2	3	66	174	42538	343.7968	0	1	0	2	2014-12-29	2014-12-30	2	1	1	8279	1	0	1	2	50	1230	56	1	1	72	1
4	2014-12-03 11:28:58	2	3	66	174	42538	343.9901	0	1	0	2	2014-12-29	2014-12-30	2	1	1	8279	1	0	1	2	50	1230	40	1	1	72	1
5	2014-12-03 11:28:11	2	3	66	174	42538	343.7866	0	1	0	2	2014-12-29	2014-12-30	2	1	1	8279	1	0	1	2	50	1230	98	1	1	72	1
6	2014-12-06 01:38:26	2	3	66	174	9045	88.1489	0	1	0	2	2014-12-19	2014-12-20	2	2	1	8279	1	0	1	2	50	358	28	2	1	28	1
7	2014-04-25 16:14:46	2	3	66	174	37449	5405.4889	1	1	0	2	2014-11-07	2014-11-09	5	1	2	62881	4	0	1	4	98	2052	20	0	2	20	3
8	2014-04-25 16:15:11	2	3	66	174	37449	5405.4889	1	1	0	2	2014-11-07	2014-11-09	3	1	2	62881	4	0	1	4	98	2052	20	0	2	20	3
9	2014-04-25 16:15:50	2	3	66	174	37449	5405.7409	1	1	0	2	2014-11-07	2014-11-09	3	1	2	62881	4	0	1	4	98	2052	60	0	2	20	3
10	2014-04-25 16:14:28	2	3	66	174	37449	5405.4889	1	1	0	2	2014-11-07	2014-11-09	3	1	1	62881	4	0	1	4	98	2052	20	0	2	20	3
11	2014-01-27 13:06:31	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-12	2	0	1	11621	1	0	1	2	50	703	91	0	4	91	3
12	2014-01-27 12:56:00	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-12	2	0	1	11621	1	0	2	2	50	703	96	0	4	91	3
13	2014-01-27 13:18:43	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-12	2	0	1	11621	1	0	1	2	50	703	94	0	4	91	3
14	2014-01-27 13:14:21	2	3	66	311	25671	[null]	2	0	0	9	2014-04-08	2014-04-12	2	0	1	11621	1	0	2	2	50	703	91	0	4	91	3
15	2014-01-27 13:39:30	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-11	2	0	1	11621	1	0	2	2	50	703	96	0	3	91	3
16	2014-01-27 13:54:07	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-11	2	0	1	11621	1	0	2	2	50	703	94	0	3	91	3
17	2014-01-27 13:04:55	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-12	2	0	1	11621	1	0	1	2	50	703	91	0	4	91	3
18	2014-01-27 13:00:31	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-12	2	0	1	11621	1	0	1	2	50	703	72	0	4	91	3
19	2014-01-27 13:22:39	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-12	2	0	1	11621	1	0	1	2	50	703	21	0	4	91	3
20	2014-01-28 12:37:49	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-11	2	0	1	12008	1	0	2	2	50	686	18	1	3	18	2
21	2014-01-28 12:34:21	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08	2014-04-11	2	0	1	12008	1	0	1	2	50	686	91	1	3	18	2
22	2014-01-28 12:32:35	2	3	66	311	25671	[null]	2	0	1	9	2014-04-08