vDataFrame.sessionize¶

In [ ]:

vDataFrame.sessionize(ts: str,
                      by: list = [],
                      session_threshold: str = "30 minutes",
                      name: str = "session_id")

Adds a new vcolumn to the vDataFrame that corresponds to user sessions (user activity during a specific time). A session ends when ts - lag(ts) is greater than the specified threshold.

Parameters¶

Name	Type	Optional	Description
ts	str	❌	vcolumn used as timeline. It will be to use to order the data. It can be a numerical or type date like (date, datetime, timestamp...) vcolumn.
by	list	✓	vcolumns used in the partition.
session_threshold	str	✓	This parameter is the threshold which will determine the end of the session. For example, if it is set to '10 minutes' the session ends after 10 minutes of inactivity.
name	str	✓	The session name.

Returns¶

vDataFrame : self

Example¶

In [72]:

from verticapy import vDataFrame
expedia = vDataFrame("public.expedia").select(["date_time", "user_id"])
display(expedia)

	📅 date_time Timestamp	123 user_id Int
1	2013-01-07 00:00:02	461899
2	2013-01-07 00:00:06	13796
3	2013-01-07 00:00:06	1128575
4	2013-01-07 00:00:17	1018895
5	2013-01-07 00:00:18	783725
6	2013-01-07 00:00:28	1197968
7	2013-01-07 00:00:28	593375
8	2013-01-07 00:00:29	1174819
9	2013-01-07 00:00:33	233534
10	2013-01-07 00:00:39	519086
11	2013-01-07 00:00:42	176709
12	2013-01-07 00:00:48	1174819
13	2013-01-07 00:00:50	1173504
14	2013-01-07 00:00:51	233534
15	2013-01-07 00:00:55	836947
16	2013-01-07 00:00:59	1046558
17	2013-01-07 00:00:59	886436
18	2013-01-07 00:01:10	207769
19	2013-01-07 00:01:18	901573
20	2013-01-07 00:01:34	593375
21	2013-01-07 00:01:36	1103572
22	2013-01-07 00:01:45	1197968
23	2013-01-07 00:01:53	1174819
24	2013-01-07 00:02:02	614322
25	2013-01-07 00:02:02	725753
26	2013-01-07 00:02:20	901573
27	2013-01-07 00:02:21	799663
28	2013-01-07 00:02:24	1128575
29	2013-01-07 00:02:28	970396
30	2013-01-07 00:02:33	756870
31	2013-01-07 00:02:36	856762
32	2013-01-07 00:02:43	614322
33	2013-01-07 00:02:43	1162059
34	2013-01-07 00:02:45	1150496
35	2013-01-07 00:02:46	5061
36	2013-01-07 00:02:59	1162059
37	2013-01-07 00:03:09	80737
38	2013-01-07 00:03:19	176709
39	2013-01-07 00:03:23	486357
40	2013-01-07 00:03:27	228687
41	2013-01-07 00:03:33	901573
42	2013-01-07 00:03:35	598076
43	2013-01-07 00:03:37	1162059
44	2013-01-07 00:03:41	13796
45	2013-01-07 00:03:52	756870
46	2013-01-07 00:03:59	1128575
47	2013-01-07 00:04:02	593375
48	2013-01-07 00:04:14	368084
49	2013-01-07 00:04:17	486357
50	2013-01-07 00:04:24	1002737
51	2013-01-07 00:04:25	970396
52	2013-01-07 00:04:29	80737
53	2013-01-07 00:04:31	368084
54	2013-01-07 00:04:32	564664
55	2013-01-07 00:04:33	192004
56	2013-01-07 00:04:33	753394
57	2013-01-07 00:04:37	103449
58	2013-01-07 00:04:40	1162059
59	2013-01-07 00:04:42	368084
60	2013-01-07 00:04:44	332853
61	2013-01-07 00:04:51	783725
62	2013-01-07 00:04:55	976118
63	2013-01-07 00:04:58	368084
64	2013-01-07 00:05:04	192004
65	2013-01-07 00:05:31	124561
66	2013-01-07 00:05:32	425340
67	2013-01-07 00:05:34	487265
68	2013-01-07 00:05:39	1018895
69	2013-01-07 00:05:42	368084
70	2013-01-07 00:05:47	212900
71	2013-01-07 00:05:56	756870
72	2013-01-07 00:05:57	246177
73	2013-01-07 00:06:01	58429
74	2013-01-07 00:06:07	13796
75	2013-01-07 00:06:11	1115804
76	2013-01-07 00:06:11	901573
77	2013-01-07 00:06:23	871663
78	2013-01-07 00:06:33	487265
79	2013-01-07 00:06:35	1162059
80	2013-01-07 00:06:40	762423
81	2013-01-07 00:06:42	399892
82	2013-01-07 00:06:51	58429
83	2013-01-07 00:06:51	18250
84	2013-01-07 00:07:01	58429
85	2013-01-07 00:07:02	204066
86	2013-01-07 00:07:03	1128575
87	2013-01-07 00:07:08	1084815
88	2013-01-07 00:07:12	1181711
89	2013-01-07 00:07:17	332853
90	2013-01-07 00:07:23	13796
91	2013-01-07 00:07:25	58429
92	2013-01-07 00:07:29	228687
93	2013-01-07 00:07:30	1194880
94	2013-01-07 00:07:30	486357
95	2013-01-07 00:07:36	487265
96	2013-01-07 00:07:45	1018895
97	2013-01-07 00:08:04	191759
98	2013-01-07 00:08:14	255311
99	2013-01-07 00:08:16	80737
100	2013-01-07 00:08:20	486729

Rows: 1-100 of 37670293 | Columns: 2

In [73]:

# Creating use session: incremental label. It increments when the user
# did not click for more than 30 minutes.
expedia.sessionize(ts = "date_time",
                   by = ["user_id"],
                   session_threshold = "30 minutes")

	📅 date_time Timestamp	123 user_id Int	123 session_id Integer
1	2014-04-25 16:14:28	1	0
2	2014-04-25 16:14:46	1	0
3	2014-04-25 16:15:11	1	0
4	2014-04-25 16:15:50	1	0
5	2014-07-31 07:10:39	3	0
6	2014-09-08 09:56:21	3	1
7	2014-09-08 09:58:50	3	1
8	2014-09-09 10:49:48	3	2
9	2014-09-22 13:19:02	3	3
10	2014-09-22 13:22:25	3	3
11	2014-09-30 12:56:51	3	4
12	2014-10-20 11:19:21	3	5
13	2014-01-26 23:56:46	5	0
14	2014-01-27 00:00:31	5	0
15	2014-01-27 00:03:44	5	0
16	2014-01-27 00:05:12	5	0
17	2014-01-27 00:06:18	5	0
18	2014-01-27 00:08:48	5	0
19	2014-01-27 00:10:17	5	0
20	2014-01-27 00:36:54	5	0
21	2014-01-27 01:17:09	5	1
22	2014-08-27 09:45:42	7	0
23	2014-08-27 09:51:32	7	0
24	2014-08-27 09:58:02	7	0
25	2014-08-27 09:58:55	7	0
26	2014-08-27 10:01:09	7	0
27	2014-08-27 10:03:53	7	0
28	2014-09-10 12:20:39	7	1
29	2014-09-24 11:23:59	7	2
30	2014-09-24 11:36:08	7	2
31	2014-09-24 11:57:49	7	2
32	2014-10-06 18:28:52	7	3
33	2014-10-06 18:32:36	7	3
34	2014-10-29 05:57:44	7	4
35	2014-10-29 05:58:44	7	4
36	2014-10-31 07:14:03	7	5
37	2014-11-06 10:14:59	7	6
38	2014-11-06 10:44:50	7	6
39	2014-11-06 10:45:59	7	6
40	2014-11-06 10:47:25	7	6
41	2014-11-06 11:26:14	7	7
42	2014-11-06 11:27:14	7	7
43	2014-11-06 11:27:47	7	7
44	2014-11-07 11:01:05	7	8
45	2014-11-07 11:03:11	7	8
46	2014-11-10 16:27:13	7	9
47	2014-11-12 11:39:45	7	10
48	2014-11-12 11:40:28	7	10
49	2014-11-20 07:54:42	7	11
50	2014-11-20 07:56:48	7	11
51	2014-11-20 09:02:53	7	12
52	2014-12-01 15:07:49	7	13
53	2014-12-18 10:37:47	7	14
54	2014-12-18 11:04:14	7	14
55	2014-12-18 12:16:29	7	15
56	2014-12-18 13:19:09	7	16
57	2014-01-26 23:01:51	9	0
58	2014-01-26 23:06:55	9	0
59	2014-01-26 23:07:18	9	0
60	2014-01-26 23:28:16	9	0
61	2014-01-26 23:30:30	9	0
62	2014-01-26 23:31:44	9	0
63	2014-01-26 23:35:50	9	0
64	2014-01-26 23:36:22	9	0
65	2014-01-26 23:45:07	9	0
66	2014-01-27 00:36:29	9	1
67	2014-01-27 00:24:08	11	0
68	2014-01-27 00:36:46	11	0
69	2014-01-27 00:55:26	11	0
70	2014-02-15 00:27:13	11	1
71	2014-02-15 00:28:37	11	1
72	2014-02-15 00:29:26	11	1
73	2014-02-15 00:30:22	11	1
74	2014-02-15 00:30:57	11	1
75	2014-02-15 00:31:14	11	1
76	2014-02-15 00:31:32	11	1
77	2014-02-15 00:33:32	11	1
78	2014-02-15 00:38:49	11	1
79	2014-02-15 00:39:10	11	1
80	2014-02-15 00:39:30	11	1
81	2014-02-15 00:39:49	11	1
82	2014-02-15 00:40:12	11	1
83	2014-02-15 00:40:29	11	1
84	2014-02-15 00:40:47	11	1
85	2014-02-15 00:41:04	11	1
86	2014-02-15 00:41:23	11	1
87	2014-02-15 00:42:18	11	1
88	2014-02-15 00:45:20	11	1
89	2014-02-15 00:53:08	11	1
90	2014-02-15 00:59:58	11	1
91	2014-02-15 01:06:41	11	1
92	2014-02-15 01:15:30	11	1
93	2014-02-15 02:40:52	11	2
94	2014-02-15 03:43:10	11	3
95	2014-02-15 03:44:52	11	3
96	2014-02-15 03:50:16	11	3
97	2014-02-15 03:55:25	11	3
98	2014-02-15 04:05:18	11	3
99	2014-02-15 04:30:13	11	3
100	2014-02-15 05:27:52	11	4

Out[73]:

Rows: 1-100 of 37670293 | Columns: 3

vDataFrame.sessionize¶

Parameters¶

Returns¶

Example¶

See Also¶